G-NAF Data Product Description
Navigation
Contents
1. Overview
2. Specification Scope
3. Data Product Identification
4. Data Content and Structure
5. Reference System
6. Data Quality
7. Data Capture
8. Data Maintenance
9. Data Product Delivery
10. Geoscape Data
11. Appendix A – Addressing Standards and NAMF Relationship
12. Appendix B – G-NAF Data Model
13. Appendix C – Data Dictionary
Geoscape
Geoscape Documentation
Related Topics
Documentation overview
Previous:
11.
Appendix A – Addressing Standards and NAMF Relationship
Next:
13.
Appendix C – Data Dictionary
Quick search
←
11.
Appendix A – Addressing Standards and NAMF Relationship
13.
Appendix C – Data Dictionary
→
12.
Appendix B – G-NAF Data Model
¶
←
11.
Appendix A – Addressing Standards and NAMF Relationship
13.
Appendix C – Data Dictionary
→
![digraph G {
fontname="ROBOTO" fontsize="10pt"
node [fontname="ROBOTO" fontsize="8pt"]
edge [fontname="ROBOTO" fontsize="8pt"]
overlap = false
rankdir=LR
address_detail [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">ADDRESS_DETAIL</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_DETAIL_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_LAST_MODIFIED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >BUILDING_NAME: varchar (200) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOT_NUMBER_PREFIX: varchar (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOT_NUMBER: varchar (5) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOT_NUMBER_SUFFIX: varchar (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >FLAT_TYPE_CODE: varchar (7) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >FLAT_NUMBER_PREFIX: varchar (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >FLAT_NUMBER: number (5) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >FLAT_NUMBER_SUFFIX: varchar (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LEVEL_TYPE_CODE: varchar (4) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LEVEL_NUMBER_PREFIX: varchar (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LEVEL_NUMBER: number (3) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LEVEL_NUMBER_SUFFIX: varchar (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NUMBER_FIRST_PREFIX: varchar (3) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NUMBER_FIRST: number (6) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NUMBER_FIRST_SUFFIX: varchar (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NUMBER_LAST_PREFIX: varchar (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NUMBER_LAST: number (6) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NUMBER_LAST_SUFFIX: varchar (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STREET_LOCALITY_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOCATION_DESCRIPTION: varchar (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOCALITY_PID: varchar (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ALIAS_PRINCIPAL: char (1) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >POSTCODE: varchar (4) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >PRIVATE_STREET: varchar (75) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LEGAL_PARCEL_ID: varchar (20) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CONFIDENCE: number (1) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_SITE_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LEVEL_GEOCODED_CODE: number (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >PROPERTY_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GNAF_PROPERTY_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >PRIMARY_SECONDARY: varchar (1) </TD>
</TR>
</TABLE>>];
address_type_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">ADDRESS_TYPE_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: varchar (8) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (30) </TD>
</TR>
</TABLE>>];
geocoded_level_type_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">GEOCODED_LEVEL_TYPE_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: varchar (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (70) </TD>
</TR>
</TABLE>>];
flat_type_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">FLAT_TYPE_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: varchar (7) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (30) </TD>
</TR>
</TABLE>>];
level_type_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">LEVEL_TYPE_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: varchar (4) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (30) </TD>
</TR>
</TABLE>>];
address_site [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">ADDRESS_SITE</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_SITE_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_TYPE: varchar (8) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_ALIAS: varchar (200) </TD>
</TR>
</TABLE>>];
address_alias [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">ADDRESS_ALIAS</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_ALIAS_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >PRINCIPAL_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ALIAS_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ALIAS_TYPE_CODE: varchar (10) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ALIAS_COMMENT: varchar (200) </TD>
</TR>
</TABLE>>];
address_alias_type_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">ADDRESS_ALIAS_TYPE_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: varchar (10) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (30) </TD>
</TR>
</TABLE>>];
locality [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">LOCALITY</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOCALITY_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOCALITY_NAME: varchar (100) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >PRIMARY_POSTCODE: varchar (4) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOCALITY_CLASS_CODE: char (1) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GNAF_LOCALITY_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GNAF_RELIABILITY_CODE: varchar (1) </TD>
</TR>
</TABLE>>];
locality_class_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">LOCALITY_CLASS_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: char (1) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (200) </TD>
</TR>
</TABLE>>];
street_locality [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">STREET_LOCALITY</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STREET_LOCALITY_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STREET_CLASS_CODE: char (1) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STREET_NAME: varchar (100) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STREET_TYPE_CODE: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STREET_SUFFIX_CODE: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOCALITY_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GNAF_STREET_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GNAF_STREET_CONFIDENCE: number (1) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GNAF_RELIABILITY_CODE: varchar (1) </TD>
</TR>
</TABLE>>];
street_class_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">STREET_CLASS_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: char (1) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (200) </TD>
</TR>
</TABLE>>];
street_type_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">STREET_TYPE_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: char (1) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (15) </TD>
</TR>
</TABLE>>];
street_locality_alias [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">STREET_LOCALITY_ALIAS</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STREET_LOCALITY_ALIAS_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STREET_LOCALITY_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STREET_NAME: varchar (100) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STREET_TYPE_CODE: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STREET_SUFFIX_CODE: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ALIAS_TYPE_CODE: varchar (10) </TD>
</TR>
</TABLE>>];
street_suffix_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">STREET_SUFFIX_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (30) </TD>
</TR>
</TABLE>>];
street_locality_alias_type_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">STREET_LOCALITY_ALIAS_TYPE_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: char (1) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (200) </TD>
</TR>
</TABLE>>];
street_locality_point [shape=plain
label=<<TABLE BGCOLOR="#7EA6E0"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">STREET_LOCALITY_POINT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STREET_LOCALITY_POINT_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STREET_LOCALITY_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >BOUNDARY_EXTENT: number (7) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >PLAINIMETRIC_ACCURACY: number (12) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GEOMETRY: Point </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LONGITUDE: varchar (10,8) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LATITUDE: number (10,8) </TD>
</TR>
</TABLE>>];
locality_neighbour [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">LOCALITY_NEIGHBOUR</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOCALITY_NEIGHBOUR_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOCALITY_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NEIGHBOUR_LOCALITY_PID: varchar (15) </TD>
</TR>
</TABLE>>];
state [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">STATE</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_ABBREVIATION: varchar (3) </TD>
</TR>
</TABLE>>];
locality_alias [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">LOCALITY_ALIAS</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOCALITY_ALIAS_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOCALITY_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (100) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >POSTCODE: varchar (4) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ALIAS_TYPE_CODE: varchar (10) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_PID: varchar (15) </TD>
</TR>
</TABLE>>];
locality_alias_type_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">LOCALITY_ALIAS_TYPE_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: char (10) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (100) </TD>
</TR>
</TABLE>>];
locality_point [shape=plain
label=<<TABLE BGCOLOR="#7EA6E0"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">LOCALITY_POINT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOCALITY_POINT_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LOCALITY_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >PLAINIMETRIC_ACCURACY: number (12) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GEOMETRY: Point </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LONGITUDE: varchar (10,8) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LATITUDE: number (10,8) </TD>
</TR>
</TABLE>>];
address_default_geocode [shape=plain
label=<<TABLE BGCOLOR="#7EA6E0"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">ADDRESS_DEFAULT_GEOCODE</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_DEFAULT_GEOCODE_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_DETAIL_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GEOCODE_TYPE_CODE: varchar (4) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GEOMETRY: Point </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LONGITUDE: varchar (11,8) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LATITUDE: number (10,8) </TD>
</TR>
</TABLE>>];
geocode_type_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">GEOCODE_TYPE_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: varchar (4) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (250) </TD>
</TR>
</TABLE>>];
address_site_geocode [shape=plain
label=<<TABLE BGCOLOR="#7EA6E0"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">ADDRESS_SITE_GEOCODE</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_SITE_GEOCODE_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_SITE_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GEOCODE_SITE_NAME: varchar (200) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GEOCODE_SITE_DESCRIPTION: varchar (45) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GEOCODE_TYPE_CODE: varchar (4) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >RELIABILITY_CODE: varchar (1) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >BOUNDARY_EXTENT: number (1) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >PLAINIMETRIC_ACCURACY: number (12) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ELEVATION: number (7) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GEOMETRY: Point </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LONGITUDE: varchar (11,8) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >LATITUDE: number (10,8) </TD>
</TR>
</TABLE>>];
mb_match_code_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">MB_MATCH_CODE_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (100) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (250) </TD>
</TR>
</TABLE>>];
address_mesh_block_2016 [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">ADDRESS_MESH_BLOCK_2016</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_MESH_BLOCK_2016_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_DETAIL_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >MB_2016_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >MB_MATCH_CODE: varchar (15) </TD>
</TR>
</TABLE>>];
address_mesh_block_2021 [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">ADDRESS_MESH_BLOCK_2021</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_MESH_BLOCK_2021_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_DETAIL_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >MB_2021_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >MB_MATCH_CODE: varchar (15) </TD>
</TR>
</TABLE>>];
mb_2016 [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">MB_2016</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >MB_2016_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >MB_2016_CODE: varchar (15) </TD>
</TR>
</TABLE>>];
mb_2021 [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">MB_2021</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >MB_2021_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >MB_2021_CODE: varchar (15) </TD>
</TR>
</TABLE>>];
address_feature [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">ADDRESS_FEATURE</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_FEATURE_ID: varchar (16) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_ADDRESS_DETAIL_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_ADDRESS_DETAIL_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_DETAIL_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_CHANGE_TYPE: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >ADDRESS_FEATURE_PID: varchar (16) </TD>
</TR>
</TABLE>>];
address_change_type_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">ADDRESS_CHANGE_TYPE_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (100) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (500) </TD>
</TR>
</TABLE>>];
primary_secondary [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">PRIMARY_SECONDARY</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >PRIMARY_SECONDARY_PID: varchar (16) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_CREATED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >PRIMARY_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >SECONDARY_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >PS_JOIN_TYPE_CODE: number (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >PS_JOIN_TYPE_COMMENT: varchar (500) </TD>
</TR>
</TABLE>>];
ps_join_type_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">PS_JOIN_TYPE_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: varchar (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (500) </TD>
</TR>
</TABLE>>];
address_detail -> flat_type_aut [constraint=none arrowhead=noneteenoneodot dir=both arrowtail=crownoneodot]
address_detail -> level_type_aut [constraint=none arrowhead=noneteenoneodot dir=both arrowtail=crownoneodot]
address_detail -> geocoded_level_type_aut [constraint=none arrowhead=nonetee dir=both arrowtail=crownoneodot ]
flat_type_aut -> address_detail [style=invis ]
level_type_aut -> address_detail [style=invis]
geocoded_level_type_aut -> address_detail [style=invis]
address_detail -> address_site [ arrowhead=nonetee dir=both arrowtail=crownoneodot ]
address_site -> address_type_aut [arrowhead=nonetee dir=both arrowtail=crownoneodot ]
address_detail -> address_alias [arrowhead=crownoneodot dir=both arrowtail=nonetee ]
address_alias -> address_alias_type_aut [arrowhead=nonetee dir=both arrowtail=crownoneodot ]
address_detail -> locality [constraint=none arrowhead=nonetee dir=both arrowtail=crownoneodot ]
locality -> locality_class_aut [arrowhead=nonetee dir=both arrowtail=crownoneodot ]
address_detail -> street_locality [arrowhead=nonetee dir=both arrowtail=crownoneodot ]
locality -> street_locality [arrowhead=crownoneodot dir=both arrowtail=nonetee ]
street_locality -> street_class_aut [arrowhead=nonetee dir=both arrowtail=crownoneodot ]
street_locality -> street_type_aut [arrowhead=noneteenoneodot dir=both arrowtail=crownoneodot ]
street_locality_alias -> street_locality [constraint=none arrowhead=nonetee dir=both arrowtail=crownoneodot]
street_locality -> street_locality_alias [style=invis]
street_locality_alias -> street_type_aut [arrowhead=noneteenoneodot dir=both arrowtail=crownoneodot ]
street_locality_alias -> street_suffix_aut [arrowhead=noneteenoneodot dir=both arrowtail=crownoneodot ]
street_locality -> street_suffix_aut [arrowhead=noneteenoneodot dir=both arrowtail=crownoneodot ]
street_locality_alias -> street_locality_alias_type_aut [arrowhead=noneteenoneodot dir=both arrowtail=crownoneodot ]
street_locality -> street_locality_point [arrowhead=noneteenoneodot dir=both arrowtail=nonetee ]
locality -> locality_neighbour[constraint=none arrowhead=noneteenoneodot dir=both arrowtail=nonetee ]
locality_neighbour -> locality[style=invis]
locality -> state [arrowhead=nonetee dir=both arrowtail=crownoneodot ]
locality -> locality_alias [arrowhead=crownoneodot dir=both arrowtail=nonetee ]
locality_alias -> state [arrowhead=nonetee dir=both arrowtail=crownoneodot ]
locality_alias -> locality_alias_type_aut [arrowhead=nonetee dir=both arrowtail=crownoneodot ]
locality -> locality_point [arrowhead=noneteenoneodot dir=both arrowtail=nonetee ]
address_detail -> address_default_geocode [arrowhead=nonetee dir=both arrowtail=nonetee ]
address_default_geocode -> geocode_type_aut [arrowhead=nonetee dir=both arrowtail=crownoneodot ]
address_site_geocode -> geocode_type_aut [arrowhead=nonetee dir=both arrowtail=crownoneodot ]
address_site -> address_site_geocode [arrowhead=none dir=both arrowtail=none ]
address_detail -> address_mesh_block_2021 [constraint=none arrowhead=crownoneodot dir=both arrowtail=nonetee]
address_mesh_block_2021 -> mb_2021 [constraint=none arrowhead=nonetee dir=both arrowtail=crownoneodot]
mb_2021 -> address_mesh_block_2021 [style=invis]
address_mesh_block_2021 -> flat_type_aut [style=invis]
address_mesh_block_2021 -> mb_match_code_aut [constraint=none arrowhead=nonetee dir=both arrowtail=crownoneodot]
address_detail -> address_mesh_block_2016 [constraint=none arrowhead=crownoneodot dir=both arrowtail=nonetee]
address_mesh_block_2016 -> flat_type_aut [style=invis]
address_mesh_block_2016 -> mb_2016 [constraint=none arrowhead=nonetee dir=both arrowtail=crownoneodot]
mb_2016 -> address_mesh_block_2016 [style=invis]
address_mesh_block_2016 -> mb_match_code_aut[constraint=none]
mb_2016 -> locality [style=invis]
address_detail -> address_feature [constraint=none arrowhead=crownoneodot dir=both arrowtail=nonetee]
address_feature -> address_change_type_aut [constraint=none arrowhead=nonetee dir=both arrowtail=crownoneodot]
address_detail -> primary_secondary [constraint=none arrowhead=crownoneodot dir=both arrowtail=nonetee]
primary_secondary -> address_detail [style=invis]
primary_secondary -> ps_join_type_aut [constraint=none arrowhead=nonetee dir=both arrowtail=crownoneodot]
ps_join_type_aut -> primary_secondary [style=invis]
locality -> address_detail [style=invis]
{rank=same; address_mesh_block_2016; address_mesh_block_2021; mb_match_code_aut;
flat_type_aut; level_type_aut; geocoded_level_type_aut;
}
mb_match_code_aut -> locality [style=invis]
mb_2016 -> mb_match_code_aut [style=invis]
mb_2021 -> mb_match_code_aut [style=invis]
address_feature -> address_detail [style=invis]
locality_neighbour -> locality[style=invis]
{rank=same; locality_neighbour;locality;}
{rank=same; address_detail ;locality;}
subgraph cluster_legend {
graph[style="" label="Legend" ]
legend [shape=plain
label=<<TABLE
CELLBORDER="0"
Border="0">
<TR>
<TD BGCOLOR="#7EA6E0" BORDER="1"> </TD>
<TD>Spatial Attribute Table</TD>
</TR>
<TR>
<TD BGCOLOR="#FFD966" BORDER="1"> </TD>
<TD>Textual Attribute Table</TD>
</TR>
<TR>
<TD BGCOLOR="#FFB570" BORDER="1"> </TD>
<TD>Authority Code Table</TD>
</TR>
</TABLE>>]
key [shape=plain label=<<table border="0" cellpadding="1" cellspacing="0" cellborder="0">
<tr><td port="i1"> Zero or Many </td> </tr>
<tr><td port="i2"> One or Many </td> </tr>
<tr><td port="i3"> Zero or One </td> </tr>
<tr><td port="i4"> One </td> </tr>
</table>>]
key2 [shape=plain label=<<TABLE border="0" cellpadding="1" cellspacing="0" CELLBORDER="0">
<tr><td port="i1"> </td></tr>
<tr><td port="i2"> </td></tr>
<tr><td port="i3"> </td></tr>
<tr><td port="i4"> </td></tr>
</TABLE>>]
key:i1 -> key2:i1 [arrowhead=crownoneodot]
key:i2 -> key2:i2 [arrowhead=crownonetee]
key:i3 -> key2:i3 [arrowhead=noneteenoneodot]
key:i4 -> key2:i4 [arrowhead=nonetee]
legend -> key[style=invis]
}
}](_images/graphviz-1ecde22ec388b167487249242830cfb71c904b87.png)