7,613
edits
Changes
Jump to navigation
Jump to search
no edit summary
The next phase is to standardize the names and match the portcos to the IPOs and MAs. Then clean up all of the core tables. That takes us to the end of the old LoadingScriptV1.sql. We then need to do the equivalent of updating GeoLoad.sql. This time, we are going to use the old data, as before, but try updating any portco or firm that doesn't have at least 4dp (11.1m resolution) or perhaps 5dp (1.11m resolution) accuracy [http://wiki.gis.com/wiki/index.php/Decimal_degrees]. We have to fix the PortCo keys first, but we can only run 2,500 queries through Google each day for free per API key, so this should be a batch job.
==Enable PostGIS Extensions==
Before we can load up geometries and other PostGIS types, and do PostGIS operations, we need to:
create extension postgis;
===Updating GeoCoding===
===Additions===
====Population====
For now:
