Docs
Go to Hub
Buildings
Documentation
Contents
Preface
Product Version
Overview
Technical Description
Appendices
Appendix I: Buildings Footprint Data Model
Appendix II: Buildings Heights and Roofs Data Model
Appendix III: Metadata
References
Geoscape Documentation
Related Topics
Documentation overview
Appendices
Previous:
Appendix I: Buildings Footprint Data Model
Next:
Appendix III: Metadata
←
Appendix I: Buildings Footprint Data Model
Appendix III: Metadata
→
Appendix II: Buildings Heights and Roofs Data Model
ΒΆ
←
Appendix I: Buildings Footprint Data Model
Appendix III: Metadata
→
![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]
}](../_images/graphviz-43ac8fd505fada07d7a53a5dfd44b33879392441.png)