Don't know what Google does, but here you can see the table structure for Geonames: http://forum.geonames.org/gforum/posts/list/80.page
On 26 Nov., 16:18, Drozzy <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
