7,649
edits
Changes
Jump to navigation
Jump to search
→Fix the Geocoding
There are some notes on [[VentureXpert_Data#GeoCoding_Companies.2C_Firms.2C_and_Branch_Offices]] and the SQL appears to be in:
E:\mcnair\Projects\VentureXpert Database\vcdb3\LoadingScripts\GeoLoad.sql
===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:
The next step in the company geo process was to load remaining from RemainingLatLong.txt. This is high precision data.
===Firm Process===
For the firms, there are three sources, all of which are high precision:
*bogeo 2046 from BranchOfficesGeo.txt
*oldfirmcoords 5556 from FirmCoords.txt
*firmremainingcoords 706 from FirmRemainingCoords.txt
These produce:
*bogeo 2046
*firmgeocoords 6049
*firmbasecore 15437, which is large because it contains non-US
