7,649
edits
Changes
Jump to navigation
Jump to search
no edit summary
cat Out6.txt | perl -pe 's/\s{2,}/ /g' > Out7.txt
cat Out7.txt | perl -pe 's/###/\t/g' > USPortCoLongDesc1980Cleaned.txt
===Geocoding===
Part of Load.sql requires that we update the Geocoding - adding new long and lat for PortCos and firm offices that we haven't seen before.
The last time this was run was vcdb20. Accordingly:
* In vcdb20, export the portcogeo, firmgeo, and bogeo tables
* Import them as portcogeo_vcdb20, firmgeo_vcdb20, and bogeo_vcdb20
* Build portcogrowthneedsgeo, firmneedsgeo, firmboneedsgeo files for geocoding
