My little site should be pooling list of items from a table using the active user's location as a filter. Think Craigslits, where you search for "dvd' but the results are not from all the DB, they are filtered by a location you select. My question has 2 levels: should I go a-la-craigslit, and ask users to use a city level location? My ...
Are there any open source/free databases for US zip codes? ...
What's the best way to get a function like the following to work: def getNearest(zipCode, miles): That is, given a zipcode (07024) and a radius, return all zipcodes which are within that radius? ...
I am looking for a way to get a function in excel to retrieve the distance form one zip to another. Lets say i have a list of 100,000 possible recruits and I want to sort by nearest. Id have the conference zip code and then 100,000 recruit zip codes. I'm looking to be able to just write a function =ZipCodeDistance(a2,d1) and then sort by...
Trying to find an XML file I can use in lieu of a look-up database table until we get our web hosting switched over to the right DB. Can anyone refer me to an XML file with elements whose children have zipcodes, states, and cities? E.g.: <zip code="98117"> <state>WA</state> <city>Seattle</state> </zip> Or <entry> <zip>98...
Hey all, I have a file that contains a mish-mash of cities, states, and zip codes. Example: Munson 11010 Shelter Island Heights. . . .. 11965 Brentwood 11717 Halesite 11743 I need to grab all of the zip codes out of that text. They are only 5 digit (no 5+4), and there are no other numbers besides the zips. It seems like a pre...
I'm new to SQL and relational databases and I have what I would imagine is a common problem. I'm making a website and when each user submits a post they have to provide a location in either a zip code or a City/State. What is the best practice for handling this? Do I simply create a Zip Code and City and State table and query against...
I have a list of records in my database and each record is associated with a zip code. What is the "best-practice" for querying all the records in my database to find all entries that are within n miles of another zip code? Each zip code has a lat/long associated with it in the database so I know I'll have to use that. However, I can'...
I'm looking for the ultimate postal code and zip code regex. I'm looking for something that will cover most (hopefully all) of the world. ...
I would like to write a JavaScript function that validates a zip code, by checking if the zip code actually exists. Here is a list of all zip codes: http://www.census.gov/tiger/tms/gazetteer/zips.txt (I only care about the 2nd column) This is really a compression problem. I would like to do this for fun. OK, now that's out of the w...
I want to make a geographical search using US city and state or zip-code and corresponding results will be viewed. In the search we have to mention the radius distance. For example: i would like to search between 25 miles around California. To do this, what should i do? is there any database containing us city,state,zip, latitude, long...
Hi, Is it possible to make zones in google maps, when provided with the zipcodes? If it is possible I would really like some links to information about it :) ...
Say I have a web service API that accepts a zipcode as a parameter, but I only have access to a GPS coordinate (latitude, longitude). How can I dynamically lookup the zipcode that the coordinate belongs to? I'm doing this work on the iPhone, so hopefully there's a simple way to do this within the CoreLocation APIs that I'm overlooking i...
Lots of web sites offer this data (see http://www.google.com/search?hl=en&q="average+temperature"+by+zip+code) but I don't see the dataset they are using. I looked at the national weather service for a bit (see for example http://www.rdc.noaa.gov/~foia/index.html#electronic), and didn't see it. NWS is in the National Oceanic and At...
Hello, First I would like to say that I am new to this site, never worked with Google Maps API and have an intermediate knowledge of JavaScript. What I have done: I put together a custom 'store locator' by adding locations to a Google 'my maps'. I then created a web page with a drop down menu and depending on the location you select f...
I want to count the amount of times that a zip code is entered into a database. I'm not sure if I am using the right function or not. Also eventually I need to separate the zip codes by the year they were entered int the data base. I know how to separate the years-I think. What I really need help on is counting duplicate entries Here is ...
I have a situation that's similar to what goes on in a job search engine where you type in the zipcode where you're searching for a job and the app returns jobs in that zipcode as well as in zipcodes that are 5, 10, 15, 20 or 25 miles from that zipcode, depending on preferences set by the user. How would you calculate the neighboring lo...
I have some US demographic and firmographic data. I would like to plot zipcode areas in a state or a smaller region (e.g. city). Each area would be annotated by color and/or text specific to that area. The output would be similar to http://maps.huge.info/ but a) with annotated text; b) pdf output; c) scriptable in R or Python. Is there ...
I am writing a web application, that is US specific, so the format that other countries use for postal codes are not important. I have a list of us zip codes that i am trying to load into a database table that includes the 5 digit us zip code latitude longitude usps classification code state code city the zip code is the primary ke...
How could I determine the closest 'center' ZIP code between two given US ZIP Codes? ...