...
| Table | SQL Statement |
|---|---|
| BLPU | SELECT CAST(UPRN AS varchar(255)bigint) AS UPRN, CAST(BLPU_VER AS integer) AS BLPU_VER, CAST(BLPU_CUR AS integer) AS BLPU_CUR, CAST(ENTRY_DATE AS integer) AS ENTRY_DATE, CAST(LAST_UPDATE_DATE AS integer) AS LAST_UPDATE_DATE, CAST(START_DATE AS integer) AS START_DATE, CAST(END_DATE AS integer) AS END_DATE, CAST(EASTING AS varchar(255)) AS EASTING, CAST(NORTHING AS varchar(255)) AS NORTHING, CAST(RPA AS varchar(255)) AS RPA, CAST(LOCAL_CUSTODIAN AS integer) AS LOCAL_CUSTODIAN, CAST(LOGICAL_STATUS AS varchar(255)) AS LOGICAL_STATUS, CAST(ORGANISATION_MATCH_STATUS AS text) AS ORGANISATION_MATCH_STATUS, CAST(PARTIAL_MATCH_STATUS AS text) AS PARTIAL_MATCH_STATUS, CAST(MAPINFO_ID AS integer) AS MAPINFO_ID, CAST(PRO_ORDER AS integer) AS PRO_ORDER, CAST(CHANGE_TYPE AS text) AS CHANGE_TYPE, CAST(ISPARENT AS integer) AS ISPARENT, CAST(ISCHILD AS integer) AS ISCHILD, CAST(IE_NO AS integer) AS IE_NO, CAST(NEVERCHILD AS integer) AS NEVERCHILD, CAST(NEVEREXPORT AS integer) AS NEVEREXPORT, CAST(UPDATED AS integer) AS UPDATED, CAST(BLPU_STATE AS integer) AS BLPU_STATE, CAST(BLPU_STATE_DATE AS integer) AS BLPU_STATE_DATE, CAST(BLPU_CLASS AS text) AS BLPU_CLASS, CAST(PARENT_UPRN AS varchar(255)) AS PARENT_UPRN, CAST(ORGANISATION AS text) AS ORGANISATION, CAST(WARD_CODE AS text) AS WARD_CODE, CAST(PARISH_CODE AS text) AS PARISH_CODE, CAST(CUSTODIAN_ONE AS integer) AS CUSTODIAN_ONE, CAST(CUSTODIAN_TWO AS integer) AS CUSTODIAN_TWO, CAST(CAN_KEY AS text) AS CAN_KEY, CAST(LAST_UPDATED AS datetime2) AS LAST_UPDATED, CAST(CROSS_REF_DETAILS AS text) AS CROSS_REF_DETAILS, CAST(USAGE AS text) AS USAGE, CAST(SITE_SURVEY AS integer) AS SITE_SURVEY, CAST(INSERTED_TIMESTAMP AS datetime2) AS INSERTED_TIMESTAMP, CAST(INSERTED_USER AS text) AS INSERTED_USER, CAST(BLPU_LEVEL AS varchar(255)) AS BLPU_LEVEL FROM BLPU |
| LPI | SELECT CAST(UPRN AS varchar(255)bigint) AS UPRN, CAST(START_DATE AS integer) AS START_DATE, CAST(ENTRY_DATE AS integer) AS ENTRY_DATE, CAST(LAST_UPDATE_DATE AS integer) AS LAST_UPDATE_DATE, CAST(END_DATE AS integer) AS END_DATE, CAST(SAON_START_NUM AS integer) AS SAON_START_NUM, CAST(SAON_START_SUFFIX AS text) AS SAON_START_SUFFIX, CAST(SAON_END_NUM AS integer) AS SAON_END_NUM, CAST(SAON_END_SUFFIX AS text) AS SAON_END_SUFFIX, CAST(SAON_TEXT AS text) AS SAON_TEXT, CAST(PAON_START_NUM AS integer) AS PAON_START_NUM, CAST(PAON_START_SUFFIX AS text) AS PAON_START_SUFFIX, CAST(PAON_END_NUM AS integer) AS PAON_END_NUM, CAST(PAON_END_SUFFIX AS text) AS PAON_END_SUFFIX, CAST(PAON_TEXT AS text) AS PAON_TEXT, CAST(LPI_USRN AS integer) AS LPI_USRN, CAST(POSTCODE_REF AS integer) AS POSTCODE_REF, CAST(POSTTOWN_REF AS integer) AS POSTTOWN_REF, CAST(LPI_LEVEL AS text) AS LPI_LEVEL, CAST(OFFICIAL_ADDRESS_MAKER AS text) AS OFFICIAL_ADDRESS_MAKER, CAST(LPI_CUR AS integer) AS LPI_CUR, CAST(LOGICAL_STATUS AS varchar(255)) AS LOGICAL_STATUS, CAST(ORGANISATION_MATCH_STATUS AS text) AS ORGANISATION_MATCH_STATUS, CAST(PARTIAL_MATCH_STATUS AS text) AS PARTIAL_MATCH_STATUS, CAST(LPI_CHECK_STATUS AS text) AS LPI_CHECK_STATUS, CAST(MAPINFO_ID AS integer) AS MAPINFO_ID, CAST(PRO_ORDER AS integer) AS PRO_ORDER, CAST(CHANGE_TYPE AS text) AS CHANGE_TYPE, CAST(DONTDELETE AS integer) AS DONTDELETE, CAST(IE_NO AS integer) AS IE_NO, CAST(NEVEREXPORT AS integer) AS NEVEREXPORT, CAST(LANGUAGE AS text) AS LANGUAGE, CAST(POSTALLY_ADDRESSABLE AS text) AS POSTALLY_ADDRESSABLE, CAST(CUSTODIAN_ONE AS integer) AS CUSTODIAN_ONE, CAST(CUSTODIAN_TWO AS integer) AS CUSTODIAN_TWO, CAST(CAN_KEY AS text) AS CAN_KEY, CAST(LPI_KEY AS text) AS LPI_KEY, CAST(LAST_UPDATED AS datetime2) AS LAST_UPDATED, CAST(ADDRESS AS text) AS ADDRESS, CAST(BS7666_ADDRESS AS text) AS BS7666_ADDRESS, CAST(SAON_DETAILS AS text) AS SAON_DETAILS, CAST(PAON_DETAILS AS text) AS PAON_DETAILS, CAST(TEMP_LINKED AS text) AS TEMP_LINKED, CAST(SEARCH_ADDRESS AS text) AS SEARCH_ADDRESS, CAST(INSERTED_TIMESTAMP AS datetime2) AS INSERTED_TIMESTAMP, CAST(INSERTED_USER AS text) AS INSERTED_USER FROM LPI WHERE LANGUAGE='ENG' AND LOGICAL_STATUS<>'8' |
| LU_COUNTY | SELECT COUNTY_REF, COUNTY, CAST(HISTORIC AS integer) AS HISTORIC, LANGUAGE, LINKED_REF FROM LU_COUNTY WHERE LANGUAGE='ENG' |
| LU_LOCALITY | SELECT LOC_REF, LOC, CAST(HISTORIC AS integer) AS HISTORIC, LANGUAGE, LINKED_REF FROM LU_LOCALITY WHERE LANGUAGE='ENG' |
| LU_POSTCODE | SELECT POSTCODE_REF, POSTCODE, CAST(HISTORIC AS integer) AS HISTORIC FROM LU_POSTCODE |
| LU_TOWN | SELECT TOWN_REF, TOWN, CAST(HISTORIC AS integer) AS HISTORIC, LANGUAGE, LINKED_REF FROM LU_TOWN WHERE LANGUAGE='ENG' |
| LU_POSTTOWN | SELECT POSTTOWN_REF, POSTTOWN, CAST(HISTORIC AS integer) AS HISTORIC, LANGUAGE, LINKED_REF FROM LU_POSTTOWN WHERE LANGUAGE='ENG' |
| STREET_DESCRIPTOR | SELECT USRN, LANGUAGE, DESCRIPTION, LOC_REF, TOWN_REF, COUNTY_REF, PK_ID, CAST(NEVEREXPORT AS integer) AS NEVEREXPORT, CHANGE_TYPE, IE_NO, PRO_ORDER, CAST(LAST_UPDATED AS datetime2) AS LAST_UPDATED, CAST(INSERTED_TIMESTAMP AS datetime2) AS INSERTED_TIMESTAMP, INSERTED_USER, ISLAND FROM STREET_DESCRIPTOR WHERE LANGUAGE='ENG' |
...