Table | Name | Field Alias | Data Type | Description |
LANDADMIN.HERITAGE_*_VW | HERITAGENR | | Binary | Unique ID allocated by Oracle, also referred to as DPTI ID |
LANDADMIN.HERITAGE_*_VW | PARLOCATION | | Character | Concatenation of the address fields (UNITNR, STREETNR, STREETNAME, STREETTYPE, ADDRESS2 & SUBURB). Nb the field name may get truncated to PARLOCATIO |
LANDADMIN.HERITAGE_*_VW | UNITNR | | Character | Unit number as recorded in development plan/SA Heritage Register |
LANDADMIN.HERITAGE_*_VW | STREETNR | | Character | Street number as recorded in development plan/SHR |
LANDADMIN.HERITAGE_*_VW | STREETNRSORT | | Number | Numerical field introduced so the records can be sorted numerically by street number |
LANDADMIN.HERITAGE_*_VW | STREETNAME | | Character | Street name as recorded in development plan/SHR |
LANDADMIN.HERITAGE_*_VW | STREETTYPE | | Character | Street type as recorded in development plan/SHR |
LANDADMIN.HERITAGE_*_VW | STREETSUFFIX | | Character | Street suffix as recorded in development plan/SHR |
LANDADMIN.HERITAGE_*_VW | ADDRESS2 | | Character | Any other additional address information recorded in Development Plans/SA Heritage Register |
LANDADMIN.HERITAGE_*_VW | SUBURB | | Character | Legal suburb that is generated using ArcGIS and legal suburbs boundary or for State Heritage Places as it is recorded in the SA Heritage Register |
LANDADMIN.HERITAGE_*_VW | DETAILS | | Character | Name/description of the heritage place/item being listed as recorded in Development Plans/SA Heritage Register |
LANDADMIN.HERITAGE_*_VW | EXTENTOFLISTING | | Character | Extent of listing of the place/item being listed, as recorded in the Development Plan (Local Heritage Places only). This field is only available online via the Heritage Database Search System |
LANDADMIN.HERITAGE_*_VW | HERITAGECLASS1 | | Character | Level of protection: S = State Heritage Place, L = Local Heritage Place or C = Representative Buildings (formally Contributory Items in Development Plans). Nb the field name may get truncated to HCLASS1 |
LANDADMIN.HERITAGE_*_VW | HERITAGECLASS1DESC | | Character | Description field for HERITAGECLASS1. Nb the field name may get truncated to HCLASS1DES |
LANDADMIN.HERITAGE_*_VW | HERITAGECLASS2 | | Character | Some places are protected twice, ie, State Heritage Place and Local Heritage Place if so, the secondary class is entered in this field. Nb the field name may get truncated to HCLASS2 |
LANDADMIN.HERITAGE_*_VW | HERITAGECLASS2DESC | | Character | Description field for HERITAGECLASS2. Nb the field name may get truncated to HCLASS2DES |
LANDADMIN.HERITAGE_*_VW | LGADESC | | Character | Name of the LGA |
LANDADMIN.HERITAGE_*_VW | SHRCODE | | Number | SA Heritage Register's unique identifier code (sometimes called Heritage Branch Id or 'Doccode') |
LANDADMIN.HERITAGE_*_VW | SHRSTATUSCODE | | Character | Indicates the status of the State Heritage Place. REG = registered, PRO = provisionally registered, REM = removed. This item is only available online via the Heritage Database Search System |
LANDADMIN.HERITAGE_*_VW | SHRSTATUSDESC | | Character | Provides a description of the STATUSCODE field. This item is only available online via the Heritage Database Search System |
LANDADMIN.HERITAGE_*_VW | SHRSTATUSDATE | | Date | Date that the last recorded STATUSCODE update occurred for a State Heritage Place. Nb this field may get truncated to SHRSTADATE |
LANDADMIN.HERITAGE_*_VW | COUNCILREF | | Character | Referencing system the council uses for each heritage place/item (if applicable) |
LANDADMIN.HERITAGE_*_VW | CODE | | Number | LGA wide unique code (related to the idcode) |
LANDADMIN.HERITAGE_*_VW | IDCODE | | Character | Statewide unique code given to each heritage place/item |
LANDADMIN.HERITAGE_*_VW | AS2482 | | Number | Australian Standard landuse classification code |
LANDADMIN.HERITAGE_*_VW | AS2482DESC | | Character | Description field of the AS2482 code |
LANDADMIN.HERITAGE_*_VW | LOCATIONACCURACY | | Character | Level of accuracy that the heritage place/item has been mapped with (H=high, L=low, U=unlocatable). Nb the field name may get truncated to ACCURACY |
LANDADMIN.HERITAGE_*_VW | ACCURACYDESC | | Character | Description field for LOCATIONACCURACY. Nb the field name may get truncated to ACCDESC |
LANDADMIN.HERITAGE_*_VW | SOURCEOFDATA | | Character | Indicates who has checked/verified the locational accuracy (DPTI=Dept for Planning and Local Government, C=council, SHB=State Heritage Branch). Nb the field name may get truncated to SOURCEDATA |
LANDADMIN.HERITAGE_*_VW | INTERIMDATE | | Date | Date the Local Heritage Place or Representative Buildings Item came INTO interim effect. Nb the field name may get truncated to INTDATE |
LANDADMIN.HERITAGE_*_VW | INTERIMPARREF | | Character | DPTI docket associated with the interim effect. Nb may get truncated to INTPARREF |
LANDADMIN.HERITAGE_*_VW | INTERIMPARNAME | | Character | Name of the DPA the local heritage place or Representative Buildings item came INTO interim operation in |
LANDADMIN.HERITAGE_*_VW | AUTHORISATIONDATE | | Date | Date the local heritage place or Representative Buildings item was approved. Nb the field name may get truncated to AUTHDATE |
LANDADMIN.HERITAGE_*_VW | AUTHPARREF | | Character | DPTI docket associated with the approval |
LANDADMIN.HERITAGE_*_VW | AUTHPARNAME | | Character | Name of the DPA the local heritage place or Representative Buildings item came INTO authorisation under |
LANDADMIN.HERITAGE_*_VW | POLYGONTYPE | | Character | Whether the heritage place/item has been captured at: P (DCDB parcel level)SELECT 1 FROM DUAL;
B (Building footprint)SELECT 1 FROM DUAL;
D (Digitised)SELECT 1 FROM DUAL;
S (Parcel that has been split because 2 or more heritage places/items are in one parcel). Nb this field may get truncated to POLYTYPE |
LANDADMIN.HERITAGE_*_VW | POLYGONTYPEDESC | | Character | Description field for POLYGONTYPE. Nb the field name may get truncated to POLYDESC |
LANDADMIN.HERITAGE_*_VW | LOCALITY | | Character | SA Heritage Register data field used in addition to Suburb, particularly important for out of councils areas where there are no suburbs |
LANDADMIN.HERITAGE_*_VW | PUBLICCOMMENTS | | Character | Comments made about individual heritage places/items that are made available to the public. This field is only available online via the Heritage Database Search System |
LANDADMIN.HERITAGE_*_VW | DEVPLANDESC | | Character | Name of the Development Plan that the heritage place/item is currently located in. Nb the field name may get truncated to DEVPLNDESC |
LANDADMIN.HERITAGE_*_VW | SECTION23S | | Character | Section 23 criteria the Local Heritage Place fits (data is only entered for Local Heritage Places) |
LANDADMIN.HERITAGE_*_VW | SECTION16S | | Character | Section 16 criteria the State Heritge Place fits (data is only entered for State Heritage Places) |
LANDADMIN.HERITAGE_*_VW | PLANPARCELS | | Character | Certificate of titles and plan/parcel references relating the heritage place/item - as included in the Development Plan |
LANDADMIN.HERITAGE_*_VW | VALUATIONS | | Character | 2006 Valuation/assessment numbers that the heritage place/item covers (generated using ArcGIS and Property Cadastre coverage). This item is only available online via the Heritage Database Search System |
LANDADMIN.HERITAGE_*_VW | SUBJECTINDEX | | Character | Subject/index category the State Heritage Place falls under (obtained from the SA Heritage Register). This item is only available online via the Heritage Database Search System |
LANDADMIN.HERITAGE_*_VW | SIGNIFICANCE | | Character | Statement of Heritage Significance of a State Heritage Place (data is only entered for State Heritage Places). This field is only available online via the Heritage Database Search System |