...
| Table | SQL Statement |
|---|---|
| BLPU | SELECT "UPRN", "BLPU_VER", CAST("BLPU_CUR" AS boolean) AS "BLPU_CUR", "ENTRY_DATE", "LAST_UPDATE_DATE", "START_DATE", "END_DATE", "EASTING", "NORTHING", "RPA", "LOCAL_CUSTODIAN", "LOGICAL_STATUS", "ORGANISATION_MATCH_STATUS", "PARTIAL_MATCH_STATUS", "MAPINFO_ID", "PRO_ORDER", "CHANGE_TYPE", CAST("ISPARENT" AS boolean) AS "ISPARENT", CAST("ISCHILD" AS boolean) AS "ISCHILD", "IE_NO", CAST("NEVERCHILD" AS boolean) AS "NEVERCHILD", CAST("NEVEREXPORT" AS boolean) AS "NEVEREXPORT", CAST("UPDATED" AS boolean) AS "UPDATED", "BLPU_STATE", "BLPU_STATE_DATE", "BLPU_CLASS", "PARENT_UPRN", "ORGANISATION", "WARD_CODE", "PARISH_CODE", "CUSTODIAN_ONE", "CUSTODIAN_TWO", "CAN_KEY", "LAST_UPDATED", "CROSS_REF_DETAILS", "USAGE", CAST("SITE_SURVEY" AS boolean) AS "SITE_SURVEY", "INSERTED_TIMESTAMP", "INSERTED_USER", "BLPU_LEVEL" FROM datashare_gis."BLPU" |
| LPI | SELECT "UPRN", "START_DATE", "ENTRY_DATE", "LAST_UPDATE_DATE", "END_DATE", "SAON_START_NUM", "SAON_START_SUFFIX", "SAON_END_NUM", "SAON_END_SUFFIX", "SAON_TEXT", "PAON_START_NUM", "PAON_START_SUFFIX", "PAON_END_NUM", "PAON_END_SUFFIX", "PAON_TEXT", "LPI_USRN", "POSTCODE_REF", "POSTTOWN_REF", "LPI_LEVEL", "OFFICIAL_ADDRESS_MAKER", CAST("LPI_CUR" AS boolean) AS "LPI_CUR", "LOGICAL_STATUS", "ORGANISATION_MATCH_STATUS", "PARTIAL_MATCH_STATUS", "LPI_CHECK_STATUS", "MAPINFO_ID", "PRO_ORDER", "CHANGE_TYPE", CAST("DONTDELETE" AS boolean) AS "DONTDELETE", "IE_NO", CAST("NEVEREXPORT" AS boolean) AS "NEVEREXPORT", "LANGUAGE", "POSTALLY_ADDRESSABLE", "CUSTODIAN_ONE", "CUSTODIAN_TWO", "CAN_KEY", "LPI_KEY", "LAST_UPDATED", "ADDRESS", "BS7666_ADDRESS", "SAON_DETAILS", "PAON_DETAILS", "TEMP_LINKED", "SEARCH_ADDRESS", "INSERTED_TIMESTAMP", "INSERTED_USER" FROM datashare_gis."LPI"; |
| LU_COUNTY | SELECT "COUNTY_REF", "COUNTY", CAST("HISTORIC" as boolean) AS "HISTORIC", "LANGUAGE", "LINKED_REF" FROM "datashare_gis"."LU_COUNTY" |
| LU_POSTCODE | SELECT "POSTCODE_REF", "POSTCODE", CAST("HISTORIC" AS boolean) AS "HISTORIC" FROM "datashare_gis"."LU_POSTCODE" |
| LU_TOWN | SELECT "TOWN_REF", "TOWN", CAST("HISTORIC" AS boolean) AS "HISTORIC", "LANGUAGE", "LINKED_REF" FROM "datashare_gis"."LU_TOWN" |
| LU_POSTTOWN | SELECT "POSTTOWN_REF", "POSTTOWN", CAST("HISTORIC" AS boolean) AS "HISTORIC", "LANGUAGE", "LINKED_REF" FROM "datashare_gis"."LU_POSTTOWN" |
| STREET_DESCRIPTOR | SELECT "USRN", "LANGUAGE", "DESCRIPTION", "LOC_REF", "TOWN_REF", "COUNTY_REF", "PK_ID", CAST("NEVEREXPORT" AS boolean) AS "NEVEREXPORT", "CHANGE_TYPE", "IE_NO", "PRO_ORDER", "LAST_UPDATED", "INSERTED_TIMESTAMP", "INSERTED_USER", "ISLAND" FROM "datashare_gis"."STREET_DESCRIPTOR" |
| LU_LOCALITY | SELECT "LOC_REF", "LOC", CAST("HISTORIC" AS boolean) AS "HISTORIC", "LANGUAGE", "LINKED_REF" FROM "datashare_gis"."LU_LOCALITY" |
In all cases the simplest method is to simply import all the data:
...