| 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. |