View Single Post
  #1 (permalink)  
Old 09-21-2005, 07:27 AM
tcampb01 tcampb01 is offline
Active Enthusiast
 
Real Name: Tim
Location: Dearborn, MI
Hybrids: '05 Ford Escape Hybrid 4WD & '06 Toyota Prius
Posts: 183
Default Comparing mileage to people in my area (ZIP codes)

Now that the database has zip codes in it, I think it'd be cool if I could compare mileage to people in my area.

The idea of the zip code was that people in similar zip codes at least have similar weather because Zip codes are actually geographic.

The first 3 numbers of the Zip indicate a geographic region (this is why satallite dish companies can let you align your dish by having you enter your zip code). The next 2 numbers of the Zip are simply assigned to each town or small city, or each sub-section of a larger city based on alphabetic order.

e.g. I live in Dearborn, MI. The geographic area is "481". Since my city starts with a "D" it has Zip codes of 48120-48124. Allen Park, MI starts with "A" so it is the "01" city in the region (48101).

If I could tell the Real Mileage database that I'd like to view all cars that have zip codes that start "481" then I could get a comparison of how I stack up against my neighbors who would have the same whether conditions that I have. If the database let us just use the first 2 digits of the zip "48", then I'd be able to compare against everybody in a much broader region of the state and not just my metro area (for example, the area north of the metro area has zip codes that all start "480" instead of "481".

Is there a way to do searches like this with the database that I've just missed?

.

Reply With Quote