Starting a new POI

 

I've started compiling a POI file of all the state liquor stores in Oregon (the ONLY liquor stores in Oregon are state stores).

The POI info is being taken from the Oregon Liquor Control Commission listing and will include phone numbers and the stated hours of operation as well as the name of the store, the address, and the coordinates.

I only have the first 45 or so entries done with about 200 more to go so it won't be done right away but I am working on it.

--
GPSMAP 76CSx - nüvi 760 - nüvi 200 - GPSMAP 78S

I'll drink to that!

wink

--
Garmin 38 - Magellan Gold - Garmin Yellow eTrex - Nuvi 260 - Nuvi 2460LMT - Google Nexus 7 - Toyota Entune NAV

Liquor Stores

Even though you are making it for Oregon I would put the city and state in the address so that if at a later date one was made for all the states it would be easy to merge and for out off staters to use. I don't know Oregon so just and address when visting won't tell me which city it is in. Just a suggestion.

--
johnm405 660 & MSS&T

Alcoholics Anonymous meeting locations

Looks like we should think about making a POI file of all the AA meeting locations in the US.

--
Garmin Nuvi 780

Alcoholics Anonymous meeting locations

That's a good one. I think you could be on to something with all the booze locations some may need it. grin razz

--
johnm405 660 & MSS&T

Stuff....

johnm405 wrote:

Even though you are making it for Oregon I would put the city and state in the address so that if at a later date one was made for all the states it would be easy to merge and for out off staters to use. I don't know Oregon so just and address when visting won't tell me which city it is in. Just a suggestion.

Yes, it also includes the City and State. That's part of the address.

--
GPSMAP 76CSx - nüvi 760 - nüvi 200 - GPSMAP 78S

Stupid laws

HotTub wrote:

Looks like we should think about making a POI file of all the AA meeting locations in the US.

I'm from California. There's a liquor store anywhere you look and you can buy booze in grocery stores. The grocery stores can't sell between 2AM and 6AM but that's about it for restrictions.

In some states, such as Oregon, you can only buy booze in a state run liquor store and only during limited hours and rarely ever on Sunday. If you're traveling and have been in the car for hours and your back is killing you and you stop in some strange town the odds are good that you won't find anywhere to purchase a bit of pain medication.

I've found this in several states and it really annoys me. What's it to them if I want a drink? How is it fair to folks who work during the only hours the places are open? Who decides this stuff? Are they legislating my "morality" or what?

I pulled into a hotel in Idaho one time and I was really feeling sick. I was just getting over a horrendous bout of the flu and had been in the car for many hours driving through a snow storm. My back was screaming at me. There was a bar in the hotel but they said, "It's Sunday" and that was that. BAH!

--
GPSMAP 76CSx - nüvi 760 - nüvi 200 - GPSMAP 78S

In Ohio they sell wine and

In Ohio they sell wine and beer in the grocery stores. But on Sunday before noon they rope off those aisles so you can't even go in them.

that is what I am looking

that is what I am looking for, all of the AA locations for the state of Washington. How do I do that? thanks I'm new at this.

Central Office

Jeff280Z wrote:

that is what I am looking for, all of the AA locations for the state of Washington. How do I do that? thanks I'm new at this.

I think it would be a lot of manual work. The AA website and the GSO in NY, do not maintain local meeting information. For each city, you would have to contact the central office or intergroup and get a printed meeting list.

From that printed meeting list, you would then have to key in every meeting address manually and batch geocode them. Then you would have to define a method to include abbreviations to indicate meeting days & times and meeting type (open, speaker, Big Book, step, etc.) in the comments field, something like MrKen did with the rest area combined POI file to indicate what services are available at each rest stop.

It certainly could be done, but it would be mostly a manual effort and have to be done at a local level.

EDIT: Having said that, sometimg else occurred to me. The central office may create their local meeting schedule on a PC and send it out for printing. They may be willing to provide an electronic copy that could save some of the manual typing. Of course, if they use some little known or proprietary publisher software, you may have trouble finding a program that could open that particular file type. Just some random thoughts.

EDIT, EDIT: Well, maybe it will be easier than I first thought. Some of the larger central offices do have websites with meeting lists. Here is one example:

http://www.aapinellas.org/asp/meeting_area.asp?A=Clearwater

It gives you everything you need to start the project - full street address for geocoding, meeting days, times and meeting type. Some will make for a very long comments field in the POI entry.

--
Tampa, FL - Garmin nüvi 660 (Software Ver 4.90), 2021.20 CN NA NT maps | Magellan Meridian Gold

AA

Gary A wrote:
Jeff280Z wrote:

that is what I am looking for, all of the AA locations for the state of Washington. How do I do that? thanks I'm new at this.

I think it would be a lot of manual work. The AA website and the GSO in NY, do not maintain local meeting information. For each city, you would have to contact the central office or intergroup and get a printed meeting list.

I have a family member that can use the list, so I am going to just start generating POI's that apply to that person for the location I know are going to. Real time consuming for me, but piece of mind knowing someone I care about can find a meeting with less work.

I guess if each person who would be interested in such a thing just started working on POI's they themselves could use, eventually it could be a really big file (like the red light cameras).

Remind me to NOT take a drink of Pepsi

flaco wrote:

I'll Drink to That!
wink

When reading a post from flaco - lest I have it coming out my nose!

grin

--
And now, back to your regularly scheduled forum - already in progress . . .

Drive-Through

bbrady42 wrote:

In Ohio they sell wine and beer in the grocery stores. But on Sunday before noon they rope off those aisles so you can't even go in them.

In My home town in Ohio - there was a Drive-Thru Liquor store. Sort of like a long garage - you drive in one end, buy the booze, and drive out the other end.

They do that in Illinois as well - rope off the liquor aisles; at least in the Jewel that I frequent.

--
And now, back to your regularly scheduled forum - already in progress . . .

AA Meetings

Sidewalk wrote:
Gary A wrote:
Jeff280Z wrote:

that is what I am looking for, all of the AA locations for the state of Washington. How do I do that? thanks I'm new at this.

I think it would be a lot of manual work. The AA website and the GSO in NY, do not maintain local meeting information. For each city, you would have to contact the central office or intergroup and get a printed meeting list.

I have a family member that can use the list, so I am going to just start generating POI's that apply to that person for the location I know are going to. Real time consuming for me, but piece of mind knowing someone I care about can find a meeting with less work.

I guess if each person who would be interested in such a thing just started working on POI's they themselves could use, eventually it could be a really big file (like the red light cameras).

Sidewalk - your post really got me thinking. So, since I know a lot of the AA meeting locations around here, I decided to jump in. I know it doesn't help you where you live, but at least its a start. Maybe others will pick up in their areas.

It was a lot of manual research and keying to get the coordinates as accurate as possible. Batch geocaching just didn't provide good enough results. Plus, I found mistakes in the meeting lists. Things like a valid address, but the wrong address. Or, out in rural areas, no-name or no-number roads. It took almost a week straight to get just this one file right. Not to mention several phone calls to people who knew where some of these out-of-the-way places were really located.

Here is the first of 3 POI files I'll be uploading to cover the 3 counties that surround Tampa Bay:

arrow http://www.poi-factory.com/node/17414

When I'm done, I may also combine them into one, Tampa Bay area file, for people who want it that way.

--
Tampa, FL - Garmin nüvi 660 (Software Ver 4.90), 2021.20 CN NA NT maps | Magellan Meridian Gold