Summary of Proposed Model Changes to VMADD by guym13

VIEWS: 0 PAGES: 2

									                      Summary of Proposed Model Changes to VMADD

Please refer to full documentation for further details of proposed data model changes to Vicmap Address

Data fields:
• Source varchar – change to the reference table categories & codes
ADDRESS_SOURCE Reference table (Appendix E) categories changed to identify the source of the
creators/custodians of each property address.
•   source_verified – creation of a new attribute field
Inclusion to supplement the source field, denoting the latest date the address has been verified by the source.
•   geocode_feature – change field name, change reference table name & codes
Field name changed from address_type to geocode_feature to accord with with AS/NZS 4590:2006 and AS/NZS
4819:2003 terminology. ADDRESS_GEOCODE_FEATURE reference table codes (Appendix A) changed to
eliminate confusion with same codes in the property_status field.
•   location_descriptor – create reference table
New reference table ADDRESS_LOCATION_DESCRIPTOR created – Appendix H
•   blg_unit_type – change field name & length, modify reference table & codes
Field name changed from premises_type to blg_unit_type. Field size to be reduced from 7 characters to 4 characters
to accord with and include unit type abbreviations in AS4590-2006 –
Reference Table name changed from ADDRESS_PREMISES_TYPE to ADDRESS_BLG_UNIT_TYPE – Appendix D
• floor_type - change field length, modify reference table & codes
Additional types included, descriptions & abbreviations amended
•   road_name - field name change from street_name.
To accord with AS/NZS 4819:2003 & Vicmap Transport.
•   road_type - field name change from street_type
To accord with AS/NZS 4819:2003 & Vicmap Transport.
•   road_suffix - field name change from street_suffix
To accord with AS/NZS 4819:2003 & Vicmap Transport.
•   mesh_block - creation of a new attribute field
Included to accommodate ABS data users into the future.
•   num_road_address - creation of a new attribute field
Aggregation of building unit (blg_unit_*), house (house_*) identifiers, plus the street name/type/suffix fields.
•   num_address - creation of a new attribute field
The aggregation of building unit (blg_unit_*) and house (house_*) identifiers, that would normally be displayed. e.g.
1A/345-347
•   dpid – remove this field
No expectation that the dpid field will be populated.
•   side_of_street - remove this field and associated reference table
Incomplete and inaccurate population. Limited practical application.
Reference Table ADDRESS_SIDE_OF_STREET also to be removed
•   geo_address – remove this field
Superseded by num_road_address & num_address

Reference Tables:

•   ADDRESS_TYPE – Renamed to ADDRESS_GEOCODE_FEATURE, points re classified & re coded.
    (Appendix A)
•   ADDRESS_CLASS - standard class(S) description amended
    (Appendix B)
•   ADDRESS_FLOOR_TYPE – Additional types included, descriptions & abbreviations amended
    (Appendix C)
•   ADDRESS_BLG_UNIT_TYPE – Additional types and amended type abbreviations.
    (Appendix D)
•   ADDRESS_SOURCE – New classifications, codes & descriptions
    (Appendix E)
•   ROAD_SUFFIX – Additional suffix added.
    (Appendix F)
•   ROAD_TYPE – Additional types added & codes amended.
    (Appendix G)
•   ADDRESS_LOCATION_DESCRIPTOR – New reference table
    (Appendix H)
•   ADDRESS_SIDE_OF_STREET – Redundant
    (Removed)

								
To top