==========================================
Appendix I: Buildings Footprint Data Model
==========================================


.. graphviz::

    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 Footprints"
        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:m 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" >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" >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" >geometry_quality: varchar (30) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >centroid_longitude: number (3,6) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >centroid_latitude: number (3,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" >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" >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 [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]

    }