In the recent project I worked on I had to design a database model for
storing locations of some stores.
I was wandering if the approach I came up with is anything resembling
how Google would store these things for their own use? My model is not
perfect, and it is very tedious to work with creating new (partial)
locations, but the searching is great.

Because I am using the ORM I will represent database models with
classes. So the structure I came up with is as follows:

Location Class:
  Latitude, Longitute
  ZIP FK
  City Nickname FK

ZIP Class:
  Code
  Country FK

City Nickname Class:
   Name
   City FK


City Class:
   Name
   State FK

State Class
  Name
  Country FK

Country Class
   Name
ZIP -> Country


I keep thinking about this, even though it is already done... Believe
it or now I even dreamt about it. Any comments?

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Google Maps API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/Google-Maps-API?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to