.. raw:: latex

   \begin{landscape}


Appendix C – Data Dictionary
============================

The following describes how the various fields should be interpreted in the respective metadata tables in the Feature Catalogue below.


.. csv-table:: Schema Table Summary
    :header-rows: 1
    :file: appendix/table_summary.csv
    :align: left


.. csv-table:: ADDRESS_ALIAS
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_address_alias.csv
    :align: left


.. csv-table:: ADDRESS_ALIAS_TYPE_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_address_alias_type_aut.csv
    :align: left


.. csv-table:: ADDRESS_ALIAS_TYPE_AUT CODES
    :header-rows: 1
    :file: appendix/domain_address_alias_type_aut_code.csv
    :align: center


.. csv-table:: ADDRESS_DETAIL
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_address_detail.csv
    :align: left


.. csv-table:: PRIMARY_SECONDARY
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_primary_secondary.csv
    :align: left


.. csv-table:: PS_JOIN_TYPE_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_ps_join_type_aut.csv
    :align: left


.. csv-table:: PS_JOIN_TYPE_AUT CODES
    :header-rows: 1
    :file: appendix/domain_ps_join_type_aut_codes.csv
    :align: left


.. csv-table:: ADDRESS_FEATURE
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_address_feature.csv
    :align: left


.. csv-table:: ADDRESS_CHANGE_TYPE_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_address_change_type_aut.csv
    :align: left


..  note::
    The codes are not listed due to the large number of change types. Please look at the tables within the data.


.. csv-table:: ADDRESS_MESH_BLOCK_2016
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_address_mesh_block_2016.csv
    :align: left


.. csv-table:: ADDRESS_MESH_BLOCK_2021
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_address_mesh_block_2021.csv
    :align: left


.. csv-table:: MB_MATCH_CODE_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_mb_match_code_aut.csv
    :align: left


.. csv-table:: MB_MATCH_CODE_AUT CODES
    :header-rows: 1
    :file: appendix/domain_mb_match_code_aut_codes.csv
    :align: left


.. csv-table:: ADDRESS_SITE
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_address_site.csv
    :align: left


.. csv-table:: ADDRESS_SITE_GEOCODE
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_address_site_geocode.csv
    :align: left


.. csv-table:: ADDRESS_TYPE_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_address_type_aut.csv
    :align: left


.. csv-table:: ADDRESS_TYPE_AUT CODES
    :header-rows: 1
    :widths: 50,100,50,100
    :file: appendix/domain_address_type_aut_codes.csv
    :align: center


.. csv-table:: FLAT_TYPE_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_flat_type_aut.csv
    :align: left


.. csv-table:: FLAT_TYPE_AUT CODES
    :header-rows: 1
    :widths: 50,100,50,100,50,100,50,100
    :file: appendix/domain_flat_type_aut_codes.csv
    :align: center


.. csv-table:: GEOCODE_RELIABILITY_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_geocode_reliability_aut.csv
    :align: left


.. csv-table:: GEOCODE_RELIABILITY_AUT CODES
    :header-rows: 1
    :file: appendix/domain_geocode_reliability_aut_codes.csv
    :align: left


.. csv-table:: GEOCODE_TYPE_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_geocode_type_aut.csv
    :align: left


.. csv-table:: GEOCODE_TYPE_AUT CODES
    :header-rows: 1
    :widths: 100,100,500
    :file: appendix/domain_geocode_type_aut_codes.csv
    :align: center


.. csv-table:: ADDRESS_DEFAULT_GEOCODE
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_address_default_geocode.csv
    :align: left


.. csv-table:: GEOCODE_LEVEL_TYPE_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_geocode_level_type_aut.csv
    :align: left


.. csv-table:: GEOCODE_LEVEL_TYPE_AUT CODES
    :header-rows: 1
    :file: appendix/domain_geocode_level_type_aut_codes.csv
    :align: center


.. csv-table:: LEVEL_TYPE_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_level_type_aut.csv
    :align: left


.. csv-table:: LEVEL_TYPE_AUT CODES
    :header-rows: 1
    :file: appendix/domain_level_type_aut_codes.csv
    :align: center


.. csv-table:: LOCALITY_CLASS_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_locality_class_aut.csv
    :align: left


.. csv-table:: LOCALITY_CLASS_AUT CODES
    :header-rows: 1
    :file: appendix/domain_locality_class_aut_codes.csv
    :align: left


.. csv-table:: LOCALITY
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_locality.csv
    :align: left


.. csv-table:: LOCALITY_ALIAS
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_locality_alias.csv
    :align: left


.. csv-table:: LOCALITY_ALIAS_TYPE_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_locality_alias_type_aut.csv
    :align: left


.. csv-table:: LOCALITY_ALIAS_TYPE_AUT CODES
    :header-rows: 1
    :file: appendix/domain_locality_alias_type_aut_codes.csv
    :align: center


.. csv-table:: LOCALITY_NEIGHBOUR
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_locality_neighbour.csv
    :align: left


.. csv-table:: LOCALITY_POINT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_locality_point.csv
    :align: left


.. csv-table:: MB_2016
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_mb_2016.csv
    :align: left


.. csv-table:: MB_2021
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_mb_2021.csv
    :align: left


.. csv-table:: STREET_CLASS_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_street_class_aut.csv
    :align: left


.. csv-table:: STREET_CLASS_AUT CODES
    :header-rows: 1
    :file: appendix/domain_street_class_aut_codes.csv
    :align: center


.. csv-table:: STREET_TYPE_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_street_type_aut.csv
    :align: left


..  note::
    The usage of the code, name and description is intentional (i.e. full text street type is used for the code) due to the initial development of the model and the dependencies at the time of developing the integrated data model. Ideally this table should be changed, but there are no current plans to change due to the impact for users on changing the model.


..  note::
    Note: the list of street types may not necessarily have G-NAF addresses, the list of codes are mainly derived from the roads data (Geoscape’s Roads product) and in some cases there are roads with no addresses.  There are some additional street types not listed in the AS4590 (road abbreviations) that are due to the reasons explained, but also due to the street types provided by the contributors.


.. raw:: latex

    \pagebreak
    \end{landscape}


.. csv-table:: STREET_TYPE_AUT CODES
    :header-rows: 1
    :widths: 90,70,10,90,70,10,90,70
    :file: appendix/domain_street_type_aut_codes.csv
    :align: center


.. raw:: latex

    \pagebreak
    \begin{landscape}



.. csv-table:: STREET_LOCALITY
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_street_locality.csv
    :align: left


.. csv-table:: STREET_LOCALITY_POINT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_street_locality_point.csv
    :align: left


.. csv-table:: STREET_LOCALITY_ALIAS
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_street_locality_alias.csv
    :align: left


.. csv-table:: STREET_LOCALITY_ALIAS_TYPE_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_street_locality_alias_type_aut.csv
    :align: left


.. csv-table:: STREET_LOCALITY_ALIAS_TYPE_AUT CODES
    :header-rows: 1
    :file: appendix/domain_street_locality_alias_type_aut_codes.csv
    :align: center


.. csv-table:: STREET_SUFFIX_AUT
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_street_suffix_aut.csv
    :align: left


.. csv-table:: STREET_SUFFIX_AUT CODES
    :header-rows: 1
    :file: appendix/domain_street_suffix_aut_codes.csv
    :align: center


.. csv-table:: STATE
    :header-rows: 1
    :widths: 100,100,200,50,50,100,100,100
    :file: appendix/table_state.csv
    :align: left


.. csv-table:: APPLIED GEOCODE PRIORITY ORDER
    :header-rows: 1
    :file: appendix/table_applied_geocode_priority_order.csv
    :align: left




.. raw:: latex

   \end{landscape}