Where to Get Your Drinks Downtown

By Eric Richardson
Published: Thursday, November 09, 2006, at 05:18PM

DOWNTOWN LOS ANGELES — Downtown Liquor Licenses

As I teased yesterday, I’ve been messing around with info on Downtown liquor licenses this week. Did you know that in the seven zip codes that serve Downtown (there’s a good guessing question – can you name all seven?) there are 467 liquor licenses outstanding?

I grabbed the license info from the California Alcoholic Beverage Control and ran it through a script to parse the HTML tables into tab-delimited data. I then took that and fed it into Google Earth, which geocoded all the addresses and gave me this super-handy guide to who can serve Downtown. It’s a kmz file, so you’ll need Google Earth to open it. The file contains only about 435 of the entries at the moment – the remaining 30 didn’t geocode successfully.

As an FYI, Downtown’s seven zipcodes are: 90012, 90013, 90014, 90015, 90017, 90021, 90071.



Comments

1
Brian Humphrey writes:

Eric:

You are simply amazing. How I wish we could harness such skill and ingenuity to tackle the geospatial data at our office.

Please keep up the great work, which continues to inspire more people than you might imagine. Though I have no need to imbibe, I do imagine that I could use your dataset to acquire a might fine sasparilla next time I get thirsty downtown.

Again Eric, thanks for your blogging efforts, which always make an interesting read.

Respectfully Yours in Safety and Service,

Brian Humphrey Firefighter/Specialist Public Service Officer Los Angeles Fire Department

# on Nov.10.2006 AT 11:01 AM
2
Jason McCabe writes:

This shows up as code in Safar and Firefox on my Mac.

# on Nov.11.2006 AT 09:59 AM
3
Eric Richardson writes:

Jason: Do you have Google Earth installed? If not, take care of that first. If so, try ctrl-clicking and saving the .kmz file to your desktop and opening it from there.

# on Nov.11.2006 AT 04:41 PM

Your Comment:

YOUR INFORMATION:

Want blogdowntown to remember you?
Create a user account or log in.

Name:
Email:
URL:
GUIDELINES:
  • Comments should be on the topic of the post or they will be removed.
  • Use the live preview below to see how your comment will look before posting.
  • Keep it civil, everyone. If you're attacking people instead of arguments, or being overly profane, expect your comment to get deleted.

FORMATTING BASICS:

blogdowntown uses Markdown formatting.

_Italics_
__Bold__
<http://url.to.link>
[link text](http://url)

COMMENT:

Preview

Start typing...