Changes

Jump to navigation Jump to search
96 bytes added ,  19:20, 30 May 2019
===Company Process===
The company process began with a load of oldgeocords 44740 from companybasegeomaster.txt (which came from vcdb2). The problem is that companybasegeomaster has low precision data in it. This was documented in [[VC_Database_Rebuild#Re-Fixing_erroneous_geo-coordinates]]. There's good data, but keyed solely by companyname, in vcdb2:*Geocore 43628 (with nulls), keyed by coname (colevelsimple)*Geoallcoords 44999 (with nulls), keyed by coname, datefirst, statecode*Geoallcoords1 44999 (with nulls), keyed by coname, datefirst, statecode, with exclude flag
The next step in the company geo process was to load remaining from RemainingLatLong.txt. This is high precision data.

Navigation menu