Appendix II: Buildings Heights and Roofs Data ModelΒΆ

digraph G { fontname="ROBOTO" fontsize="10pt" node [fontname="ROBOTO" fontsize="8pt"] edge [fontname="ROBOTO" fontsize="8pt"] rankdir="LR"; splines=ortho; subgraph cluster_building_ns_nsp { label="Geoscape Buildings Heights & Roofs" graph[style="dashed,rounded" color="#EA6B66"] building_ns_nsp [shape=plain label=<<TABLE BGCOLOR="#7EA6E0" BORDER="1" CELLBORDER="0" style="rounded" CELLSPACING="0" CELLPADDING="5"> <TR> <TD COLSPAN="2">buildings</TD> </TR> <TR> <TD BGCOLOR="white" >PK</TD> <TD BGCOLOR="white" ALIGN="LEFT" >building_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_modified: date </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >capture_date: date </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >building_review_date: date </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >building_source: varchar (30) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >quality_class: varchar (20) </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" >state: varchar (3) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >address_count: number (5) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >planning_zone: varchar (30) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >roof_height: number (7,2) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >eave_height: number (7,2) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >ground_elevation: number (7,2) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >ground_elevation_source: varchar (4) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >primary_roof_material: varchar (20) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >roof_type: varchar (30) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >roof_colour: varchar (7) </TD> </TR> <TR> <TD BGCOLOR="white" >FK</TD> <TD BGCOLOR="white" ALIGN="LEFT" >mesh_block_code: varchar (11) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >number_vertices: number (5) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >area: number (10,2) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >volume: number (10,2) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >geometry_quality: varchar (30) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >centroid_longitude: number (9,6) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >centroid_latitude: number (9,6) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >estimated_levels: varchar (3) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >roof_shape: varchar (7) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >tree_overhang: varchar (3) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >geometry: Polygon </TD> </TR> </TABLE>>]; building_address [shape=plain label=<<TABLE BGCOLOR="#FFD966" BORDER="1" CELLBORDER="0" style="rounded" CELLSPACING="0" CELLPADDING="5"> <TR> <TD COLSPAN="2">building_address</TD> </TR> <TR> <TD BGCOLOR="white" >PK</TD> <TD BGCOLOR="white" ALIGN="LEFT" >building_pid: varchar (15) </TD> </TR> <TR> <TD BGCOLOR="white" >PK</TD> <TD BGCOLOR="white" ALIGN="LEFT" >addresss_pid: varchar (15) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >addresss_detail_pid: varchar (15) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >addresss: varchar (150) </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_modified: date </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >relationship_confidence: number (3) </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >is_residential: varchar (3) </TD> </TR> </TABLE>>]; building_cad [shape=plain label=<<TABLE BGCOLOR="#FFD966" BORDER="1" CELLBORDER="0" style="rounded" CELLSPACING="0" CELLPADDING="5"> <TR> <TD COLSPAN="2">building_cad</TD> </TR> <TR> <TD BGCOLOR="white" >PK</TD> <TD BGCOLOR="white" ALIGN="LEFT" >building_pid: varchar (15) </TD> </TR> <TR> <TD BGCOLOR="white" >PK</TD> <TD BGCOLOR="white" ALIGN="LEFT" >cad_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_modified: date </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >relationship_confidence: number (3) </TD> </TR> </TABLE>>]; building_property [shape=plain label=<<TABLE BGCOLOR="#FFD966" BORDER="1" CELLBORDER="0" style="rounded" CELLSPACING="0" CELLPADDING="5"> <TR> <TD COLSPAN="2">building_property</TD> </TR> <TR> <TD BGCOLOR="white" >PK</TD> <TD BGCOLOR="white" ALIGN="LEFT" >building_pid: varchar (15) </TD> </TR> <TR> <TD BGCOLOR="white" >PK</TD> <TD BGCOLOR="white" ALIGN="LEFT" >property_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_modified: date </TD> </TR> <TR> <TD BGCOLOR="white" ></TD> <TD BGCOLOR="white" ALIGN="LEFT" >relationship_confidence: number (3) </TD> </TR> </TABLE>>]; } building_property -> building_ns_nsp building_address -> building_ns_nsp building_cad -> building_ns_nsp 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="#97D077" BORDER="1"> </TD> <TD>API Service</TD> </TR> </TABLE>>] } legend -> building_address [style=invis] }