Thread: Lat / Long
View Single Post
  #6 (permalink)  
Old February 4th, 2008, 23:04
EmergeNow EmergeNow is offline
Junior Member
 
Join Date: Aug 2007
Posts: 9
Thanks: 1
Thanked 2 Times in 2 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
EmergeNow is on a distinguished road
Re: Lat / Long

If you create a new location with lat/long, it gets stored in the location table. If you populate the other lat/long tables (GEO_POSTAL_POINT, GEO_CITYPROV_POINT), the location refers to them to look up the lat/long and populate the location table.

For example, I have worked with clients that have purchased the lat/long for every US zip code and I loaded that information in the GEO_POSTAL_POINT table. When a new location was entered with a valid zip code and saved, the lat/long is defined for the location.
Reply With Quote