*** dneighbors has quit IRC
*** ninj1 has quit IRC
*** ninj1 has joined #gnuenterprise
*** bigbrother_ has joined #gnuenterprise
*** bigbrother` has quit IRC
*** reinhard has joined #gnuenterprise
*** kilo has joined #gnuenterprise
*** btami has joined #gnuenterprise
<reinhard> good morning all
<kilo> good morning
<btami> good morning
*** bigbrother` has joined #gnuenterprise
*** kilo has quit IRC
*** dimas__ has joined #gnuenterprise
*** dimas__ has quit IRC
*** btami has quit IRC
*** ajmitch__ has joined #gnuenterprise
*** ajmitch_ has quit IRC
*** ajmitch__ has quit IRC
*** dneighbors has joined #gnuenterprise
*** dneighbors has quit IRC
*** btami has joined #gnuenterprise
*** jamest has joined #gnuenterprise
*** btami has quit IRC
*** yure_ has joined #gnuenterprise
*** dneighbors has joined #gnuenterprise
*** dneighbors is now known as derek
<derek> does anyone know where to get geocode data for zipcodes or addresses
<derek> seems can find a few packages to buy zipcode
<derek> but not zip+4
*** jcater has joined #gnuenterprise
*** yure has quit IRC
*** derek has quit IRC
*** dneighbors has joined #gnuenterprise
<dneighbors> jcater: you here?
*** dneighbors is now known as derek
<jcater> depends on who's asking
<jamest> jcater: derek's asking
<derek> along time ago you had zipcode data from USPS (i think)
<derek> do you still have that kind of data and where do you get it from
<derek> we need geocode data and it seems everyone stopped carrying it
<derek> USPS and all its vendors
<derek> they have moved to a "webservices" model where you have to pay per lookup via a webservice
<jamest> i think my zipsales stuff provides geocode
<derek> we think we have found a few that are reasonable that does zipcode level
<derek> but not zip+4 or zip11 (which would be an entire address)
<jamest> but it's 1500 a year IIRC
<jamest> and I think geocode is also available in census data (kina maybe?)
<jcater> derek, yeah we get that
<jcater> let me pull an invoice
<derek> jamest: census data has the "raw" input
<derek> but i think these companies take USPS data and merge with census data to get their information
<derek> jcater: you using zip sales too
<jcater> http://www.usps.com/ncsc/addressmgmt/tiger.htm
<jcater> is that what you're looking for?
<jcater> I get quarterly lists from the USPS
<jcater> of Zip+4 information and Five-Digit info
<jcater> we don't buy the one with latitude/longitude data
<derek> cant thmm
<derek> the tiger one has demographics, but not sure if it is address detail or not on geocoding
<derek> zipsales has something that looks about right, but looks like a windows program and not a database
<jcater> wait... what exactly are you looking to do?
<jcater> I buy two products
<jcater> (there is overlap)
<jcater> One is from the USPS that is just a raw database of zipcodes and zip+4 codes
<jcater> the second is PAVE/CASS software
<jcater> where I feed it an address (or a batch of addresses)
<jcater> and it spits back out a zip+11 code for it and all the info needed to get postal discounts
<jcater> I missed what exactly you're trying to do
<derek> we have several needs
<derek> one application we want to use right now is
<derek> supply it an address
<derek> and get a latitude/longitude back
<derek> we then will use that lat/lon to place coordinates on a map
<derek> and to calculate distances between two addresses
<derek> another application is we calculate temperatures of shipping destinations to determine what packing material to use
<jcater> TIGER is what you want
<derek> right now we use weather.com
<jcater> http://www.usps.com/ncsc/addressmgmt/tiger.htm
<derek> BUT we give it city, st
<jcater> not sure how much it costs
<derek> and higley, az for example isn't a "real" city
<derek> if we had lat/lon we could pass that and it would read from nearest weather station
<derek> so in that instance zipcode lat lon is suffiicent
<derek> jcater: how did you subscribe to usps stuff?
<jcater> called the customer support center
<derek> we called them yesterday and they in essence told us they don't sell stuff anymore (but the person we talked to was retarded)
<jcater> National Customer Support Center (NCSC) 1-800-238-3150
<jcater> that's baloney
<jcater> MelissaData is a big provider of that sort of info too
<jcater> http://www.melissadata.com/zd.html
<derek> we were looking at melissadata
<derek> called them
<derek> they no longer offer their zip11 product
<derek> you have to use the webservice :(
<jcater> strange
<derek> wait i might be thinking of different group
<derek> these guys might have what we need for 1,200
*** ninj1 has quit IRC
<derek> with tiger would i need to get an additional product as well?
<jcater> tiger is raw data
<jcater> which you could load into a database
*** jamest has quit IRC
<jcater> if you just need to get zipcode-level latitude/longitude
<jcater> I'm sure that's all you need
<jcater> if you're trying to standardize an address to get the zip+4 or zip11 code
<jcater> there's no way you want to do that inhouse
<derek> ?
<derek> would like to enter
<derek> 100 W BESTY CT, GILBERT, AZ 85233
<derek> and get a lat/lon returned
<jcater> but the latitude/longitude of the center of 85233 would be enough?
<jcater> or you want it more precise than that?
<derek> not for some of our applications
<derek> for the weather station example yes
<derek> for some other examples no
<derek> say i have 200 kids playing soccer
<derek> all in the same zipcode
<derek> and i want to put players on team closest to a coach
<derek> i have to be finer grained than the zipcode
<derek> there are a plethora of webservices out there (including a free one from yahoo) that you can get to return this
<derek> however, doing a query over the wire seems less than optimal
<jcater> yeah
<jcater> well
<jcater> I use aescass.com's product on linux to take an address
<jcater> and return properly coded address with zip+4, etc
<jcater> but it doesn't integrate tiger data
<jcater> but the tiger data is detailed to a zip+4 level
<jcater> best I can tell
<jcater> so I think you could use the two in combination
<jcater> but buying two apps, you're probably talking $2k/yr
<derek> thats all
<derek> and that lets us distribute in applications?
<jcater> oh
<jcater> this would be a huge thing to distribute
<derek> currently the webservices run about 2 cents a transaction
<derek> so 100,000 transactions and you pay for yourself
<derek> jcater: we were thinking of having our applications use us as the webservice
<derek> not distributing per say the database to every client
<derek> but rather let the clients grab it from us
<derek> as this has to be millions of rows of data
<jcater> yeah
<jcater> well, the cass product
<jcater> comes on a dvd
<jcater> and the usps data fills a cd
<jcater> that's what I'd do
*** btami has joined #gnuenterprise
<jcater> I really like AES
<jcater> it uses a sybase runtime on linux
<jcater> the guys are all engineers
<jcater> I would call them
<derek> so aes doesnt have geocode
<jcater> and tell thema friend uses their product
<jcater> but he doesn't think they use tiger data
<jcater> and ask
* derek was thinking maybe they could provide it all
<jcater> (they might add it)
<derek> okay will do that
<jcater> when I first bought their software
<jcater> 2 weeks later
<jcater> an actual programmer there called
<jcater> and made sure I installed it okay
<jcater> and talked with me about what we were doing
<jcater> and how they could help w/the initial integration into our software
<jcater> (and this wasn't a sales call to charge us consulting fees...
<jcater> this was something they were just doing to make sure we transitioned okay)
<jcater> iow, I think they are responsive to what people need
<derek> um i talked to guy for 20 minutes
<derek> they are VERY interested in doing TIGER stuff and geocoding
<derek> they want to partner to have us be the first live customer
<derek> btw: he told me how to get the TIGER data directly from dept of commerce for $99 instead of the couple thousand at usps
<derek> and he said it is all public domain and only costs $99 for the cd
<reinhard> good night all
*** reinhard has quit IRC
*** btami has quit IRC
*** ncjp has quit IRC
*** bigbrother has quit IRC
*** Amorphous has quit IRC
*** btami has joined #gnuenterprise
*** ncjp has joined #gnuenterprise
*** bigbrother has joined #gnuenterprise
*** Amorphous has joined #gnuenterprise
*** btami has quit IRC
*** sjc has joined #gnuenterprise
*** Makki_ has joined #gnuenterprise
*** jcater_ has joined #gnuenterprise
*** jcater has quit IRC
*** Makki has quit IRC
*** kilo has joined #gnuenterprise
*** derek has quit IRC
*** jcater_ has quit IRC
*** dneighbors has joined #gnuenterprise
*** dneighbors has quit IRC
*** kilo has quit IRC
*** sjc has quit IRC
*** jcater has joined #gnuenterprise
*** ninja has joined #gnuenterprise
*** jcater_ has joined #gnuenterprise
*** jcater has quit IRC
*** dneighbors has joined #gnuenterprise
*** dneighbors has quit IRC