CAD12 - Spatial Data Model - Specification

Contents

1. Overview

2. Class Diagram

3. Class Details

3.1. Class: AddPoint

3.1.1. Attribute: pid

3.1.2. Attribute: ad_pt_type

3.1.3. Attribute: ufi

3.1.4. Attribute: fmp

3.1.5. Attribute: created_on

3.1.6. Attribute: retired_on

3.2. Class: Bdy_Pt

3.2.1. Attribute: bdy_pt_id

3.2.2. Attribute: plan

3.2.3. Attribute: easting

3.2.4. Attribute: northing

3.2.5. Attribute: coord_acc

3.2.6. Attribute: prov

3.2.7. Attribute: ufi

3.2.8. Attribute: fmp

3.2.9. Attribute: created_on

3.2.10. Attribute: retired_on

3.3. Class: Bdy_Seg

3.3.1. Attribute: bdy_seg_id

3.3.2. Attribute: comp_len

3.3.3. Attribute: feat_fol

3.3.4. Attribute: foreign_id

3.3.5. Attribute: prov

3.3.6. Attribute: ufi

3.3.7. Attribute: fmp

3.3.8. Attribute: created_on

3.3.9. Attribute: retired_on

3.4. Class: Cad_Area

3.4.1. Attribute: cid

3.4.2. Attribute: plan

3.4.3. Attribute: lot

3.4.4. Attribute: pid

3.4.5. Attribute: pot_pid

3.4.6. Attribute: map_text

3.4.7. Attribute: cad_type1

3.4.8. Attribute: cad_type2

3.4.9. Attribute: item_id

3.4.10. Attribute: comp_area

3.4.11. Attribute: meas_area

3.4.12. Attribute: nom_reg_no

3.4.13. Attribute: proclam_pr

3.4.14. Attribute: tenure_ty

3.4.15. Attribute: prov_luc

3.4.16. Attribute: gaz_date

3.4.17. Attribute: ungaz_date

3.4.18. Attribute: prov

3.4.19. Attribute: ufi

3.4.20. Attribute: fmp

3.4.21. Attribute: created_on

3.4.22. Attribute: retired_on

3.4.23. Attribute: ing_upi_g

3.4.24. Attribute: ing_mun_no

3.4.25. Attribute: ing_mun_ol

3.4.26. Attribute: ing_cre_d

3.4.27. Attribute: ing_lu_d

3.4.28. Attribute: ing_ten_c

3.4.29. Attribute: ing_ten_d

3.4.30. Attribute: ing_procl

3.4.31. Attribute: ing_comm

3.4.32. Attribute: ing_digit

3.4.33. Attribute: ing_graph

3.4.34. Attribute: ing_disc_d

3.4.35. Attribute: ing_erron

3.4.36. Attribute: ing_east

3.4.37. Attribute: ing_north

3.5. Class: ComFacil

3.5.1. Attribute: com_fac_id

3.5.2. Attribute: pid

3.5.3. Attribute: com_type1

3.5.4. Attribute: com_type2

3.5.5. Attribute: nom_reg_no

3.5.6. Attribute: created_on

3.5.7. Attribute: retired_on

3.6. Class: Land_Use

3.6.1. Attribute: land_use_code

3.6.2. Attribute: land_use

3.7. Class: Mapped_Area

3.7.1. Attribute: map_text

3.7.2. Attribute: par_mp_txt

3.8. Class: Plan

3.8.1. Attribute: plan

3.8.2. Attribute: plan_auth

3.8.3. Attribute: plan_type

3.8.4. Attribute: plan_ref

3.8.5. Attribute: par_plan

3.8.6. Attribute: reg_date

3.8.7. Attribute: doc_type

3.8.8. Attribute: rev_no

3.8.9. Attribute: num_pages

3.8.10. Attribute: prov

3.9. Class: PlanPage

3.9.1. Attribute: plan

3.9.2. Attribute: page_no

3.9.3. Attribute: image_data

3.10. Class: Plan_Cad

3.10.1. Attribute: cid

3.10.2. Attribute: plan

3.10.3. Attribute: disc_date

3.11. Class: Property

3.11.1. Attribute: property_id

3.11.2. Attribute: currency_code

3.11.3. Attribute: municipality_code

3.11.4. Attribute: street

3.11.5. Attribute: property_area

3.11.6. Attribute: street_no_from

3.11.7. Attribute: street_no_to

3.11.8. Attribute: valuation_no

3.11.9. Attribute: land_use_code

3.11.10. Attribute: zoning_code

3.11.11. Attribute: postcode

3.11.12. Attribute: bldg_property_name

3.11.13. Attribute: location_desc

3.11.14. Attribute: bldg_subunit_no

3.11.15. Attribute: bldg_subunit_type_code

3.11.16. Attribute: bldg_type_code

3.11.17. Attribute: floor_level_no

3.11.18. Attribute: floor_level_type_code

3.11.19. Attribute: last_assd_annual_value

3.11.20. Attribute: last_capital_value

3.11.21. Attribute: last_land_value

3.11.22. Attribute: last_sale_price

3.11.23. Attribute: property_frontage

3.11.24. Attribute: property_type_code

3.11.25. Attribute: roof_construction_code

3.11.26. Attribute: room_count

3.11.27. Attribute: street_no_from_suffix

3.11.28. Attribute: street_no_to_suffix

3.11.29. Attribute: street_suffix

3.11.30. Attribute: street_type_code

3.11.31. Attribute: suburb_locality

3.11.32. Attribute: wall_construction_code

3.11.33. Attribute: lot_no

3.11.34. Attribute: plan_no

3.11.35. Attribute: region_code

3.11.36. Attribute: other_delivery_type_code

3.11.37. Attribute: other_delivery_no

3.11.38. Attribute: construction_year

3.11.39. Attribute: state_country_code

3.11.40. Attribute: last_reval_valuation_no

3.11.41. Attribute: upi_general

3.11.42. Attribute: national_trust_code

3.11.43. Attribute: owner_short_name

3.11.44. Attribute: improvements

3.11.45. Attribute: improvement_type_code

3.11.46. Attribute: bldg_area

3.11.47. Attribute: course_erection_yn

3.11.48. Attribute: curr_sub_props_count

3.11.49. Attribute: map_no

3.11.50. Attribute: more_ct_refs_yn

3.11.51. Attribute: more_map_refs_yn

3.11.52. Attribute: more_upis_yn

3.11.53. Attribute: last_issue_date

3.11.54. Attribute: last_effective_date

3.11.55. Attribute: last_valuation_reason

3.11.56. Attribute: last_real_estate_price

3.11.57. Attribute: last_chattels_price

3.11.58. Attribute: last_other_items_price

3.11.59. Attribute: last_contract_date

3.12. Class: Title

3.12.1. Attribute: plan

3.12.2. Attribute: lot

3.12.3. Attribute: status

3.12.4. Attribute: edition

3.12.5. Attribute: editiondate

3.12.6. Attribute: titleshare

3.12.7. Attribute: titletype

3.12.8. Attribute: warnflg

3.12.9. Attribute: plantype

3.12.10. Attribute: deaddate

4. Relationships

4.1. Relationship Pair: AddPoint (AddPoint_to_CompFacil) and ComFacil (ComFacil_to_AddPoint)

4.1.1. From AddPoint To ComFacil

4.1.2. From ComFacil To AddPoint

4.2. Relationship Pair: AddPoint (AddPoint_to_Property) and Property (Property_to_AddPoint)

4.2.1. From AddPoint To Property

4.2.2. From Property To AddPoint

4.3. Relationship Pair: Bdy_Pt (Bdy_Pt_to_Bdy_Seg_1) and Bdy_Seg (Bdy_Seg_to_Bdy_Pt_1)

4.3.1. From Bdy_Pt To Bdy_Seg

4.3.2. From Bdy_Seg To Bdy_Pt

4.4. Relationship Pair: Bdy_Pt (Bdy_Pt_to_Bdy_Seg_2) and Bdy_Seg (Bdy_Seg_to_Bdy_Pt_2)

4.4.1. From Bdy_Pt To Bdy_Seg

4.4.2. From Bdy_Seg To Bdy_Pt

4.5. Relationship Pair: Bdy_Seg (Bdy_Seg_to_Cad_Area) and Cad_Area (Cad_Area_to_Bdy_Seg)

4.5.1. From Bdy_Seg To Cad_Area

4.5.2. From Cad_Area To Bdy_Seg

4.5.3. Spatial Representation

4.6. Relationship Pair: Bdy_Seg (Bdy_Seg_to_Bdy_Pt_1) and Bdy_Pt (Bdy_Pt_to_Bdy_Seg_1)

4.7. Relationship Pair: Bdy_Seg (Bdy_Seg_to_Bdy_Pt_2) and Bdy_Pt (Bdy_Pt_to_Bdy_Seg_2)

4.8. Relationship Pair: Cad_Area (Map_Text) and Mapped_Area (Polygon)

4.8.1. From Cad_Area To Mapped_Area

4.8.2. From Mapped_Area To Cad_Area

4.9. Relationship Pair: Cad_Area (Cad_Area_to_Bdy_Seg) and Bdy_Seg (Bdy_Seg_to_Cad_Area)

4.10. Relationship Pair: Cad_Area (Cad_Area_to_Title) and Title (Title_to_Cad_Area)

4.10.1. From Cad_Area To Title

4.10.2. From Title To Cad_Area

4.11. Relationship Pair: Cad_Area (Cad_Area_to_Property) and Property (Property_to_Cad_Area)

4.11.1. From Cad_Area To Property

4.11.2. From Property To Cad_Area

4.12. Relationship Pair: Cad_Area (cad_area_to_potential_property) and Property (potential_property_to_cad_area)

4.12.1. From Cad_Area To Property

4.12.2. From Property To Cad_Area

4.13. Relationship Pair: Cad_Area (cad_area_to_plan) and Plan_Cad (plan_to_cad_area)

4.13.1. From Cad_Area To Plan_Cad

4.13.2. From Plan_Cad To Cad_Area

4.14. Relationship Pair: ComFacil (ComFacil_to_AddPoint) and AddPoint (AddPoint_to_CompFacil)

4.15. Relationship Pair: Land_Use (sales) and Sale (land_use)

4.15.1. From Land_Use To Sale

4.15.2. From Sale To Land_Use

4.16. Relationship Pair: Land_Use (Land_Use_to_Property) and Property (Property_to_Land_Use)

4.16.1. From Land_Use To Property

4.16.2. From Property To Land_Use

4.17. Relationship Pair: Mapped_Area (Polygon) and Cad_Area (Map_Text)

4.18. Relationship Pair: Mapped_Area (parent) and Mapped_Area (children)

4.18.1. From Mapped_Area To Mapped_Area

4.18.2. From Mapped_Area To Mapped_Area

4.19. Relationship Pair: Mapped_Area (children) and Mapped_Area (parent)

4.20. Relationship Pair: Plan (Parent_Plan) and Plan (Plan_Parent)

4.20.1. From Plan To Plan

4.20.2. From Plan To Plan

4.21. Relationship Pair: Plan (Plan_Parent) and Plan (Parent_Plan)

4.22. Relationship Pair: Plan (Plan_to_PlanPage) and PlanPage (PlanPage_to_Plan)

4.22.1. From Plan To PlanPage

4.22.2. From PlanPage To Plan

4.23. Relationship Pair: Plan (plan_to_cad_area) and Plan_Cad (cad_area_to_plan)

4.23.1. From Plan To Plan_Cad

4.23.2. From Plan_Cad To Plan

4.24. Relationship Pair: PlanPage (PlanPage_to_Plan) and Plan (Plan_to_PlanPage)

4.25. Relationship Pair: Plan_Cad (plan_to_cad_area) and Cad_Area (cad_area_to_plan)

4.26. Relationship Pair: Plan_Cad (cad_area_to_plan) and Plan (plan_to_cad_area)

4.27. Relationship Pair: Property (planning_zone) and Planning_Zone (properties)

4.27.1. From Property To Planning_Zone

4.27.2. From Planning_Zone To Property

4.28. Relationship Pair: Property (roof_construction) and Roof_Construction (properties)

4.28.1. From Property To Roof_Construction

4.28.2. From Roof_Construction To Property

4.29. Relationship Pair: Property (building_type) and Building_Type (properties)

4.29.1. From Property To Building_Type

4.29.2. From Building_Type To Property

4.30. Relationship Pair: Property (property_interests) and Property_Interest (property)

4.30.1. From Property To Property_Interest

4.30.2. From Property_Interest To Property

4.31. Relationship Pair: Property (land_use) and Land_Use (properties)

4.31.1. From Property To Land_Use

4.31.2. From Land_Use To Property

4.32. Relationship Pair: Property (titles) and PID_CT (property)

4.32.1. From Property To PID_CT

4.32.2. From PID_CT To Property

4.33. Relationship Pair: Property (interest_addresses) and Property_Interest (address_at_property)

4.33.1. From Property To Property_Interest

4.33.2. From Property_Interest To Property

4.34. Relationship Pair: Property (Property_to_Cad_Area) and Cad_Area (Cad_Area_to_Property)

4.35. Relationship Pair: Property (Property_to_Land_Use) and Land_Use (Land_Use_to_Property)

4.36. Relationship Pair: Property (Property_to_AddPoint) and AddPoint (AddPoint_to_Property)

4.37. Relationship Pair: Property (potential_property_to_cad_area) and Cad_Area (cad_area_to_potential_property)

4.38. Relationship Pair: Title (title_type) and Title_Type (titles)

4.38.1. From Title To Title_Type

4.38.2. From Title_Type To Title

4.39. Relationship Pair: Title (derivation) and Title_Derivation (title)

4.39.1. From Title To Title_Derivation

4.39.2. From Title_Derivation To Title

4.40. Relationship Pair: Title (parent_derivation) and Title_Derivation (parent_title)

4.40.1. From Title To Title_Derivation

4.40.2. From Title_Derivation To Title

4.41. Relationship Pair: Title (Title_to_Cad_Area) and Cad_Area (Cad_Area_to_Title)

5. Code Lists

5.1. Code List: AdPtType

5.2. Code List: Building_Subunit

5.3. Code List: Building_Type

5.4. Code List: CadType1

5.5. Code List: CadType2

5.6. Code List: ComType1

5.7. Code List: ComType2

5.8. Code List: Currency

5.9. Code List: FeatFol

5.10. Code List: Floor_Type

5.11. Code List: Improvement_Type

5.12. Code List: Land_use

5.13. Code List: Municipality

5.14. Code List: National_Trust

5.15. Code List: Other_Delivery_Type

5.16. Code List: PlanAuth

5.17. Code List: PlanType

5.18. Code List: Plan_Type

5.19. Code List: ProclamPr

5.20. Code List: Property_Type

5.21. Code List: ProvClas

5.22. Code List: ProvFlag

5.23. Code List: Region

5.24. Code List: Roof_Construction

5.25. Code List: State_Country

5.26. Code List: Street_Type

5.27. Code List: Tenure

5.28. Code List: Title_Type

5.29. Code List: Wall_Construction

6. Miscellaneous Information

6.1. Defined System Variables