====================================
Appendix A – Road Data Model Diagram
====================================

.. graphviz::

    digraph G {

        fontname="ROBOTO" fontsize="10pt"
        node [fontname="ROBOTO" fontsize="8pt"]
        edge [fontname="ROBOTO" fontsize="8pt"]
        rankdir = LR

    subgraph cluster_roads { label="Roads"
         graph[style="dashed,rounded"  color="#EA6B66"]

    street_locality_line [shape=plain
    label=<<TABLE BGCOLOR="#7EA6E0"
    BORDER="1"
    CELLBORDER="0"
    style="rounded"
    CELLSPACING="0"
    CELLPADDING="5">

    <TR>
    <TD  COLSPAN="2">street_locality_line</TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" >PK</TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >street_locality_line_pid: character string (15)      </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" >FK</TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >street_locality_pid: character string (15) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >date_created: date </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" >FK</TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >road_pid: character string (15) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >road_name: character string  (50) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >road_type: character string  (12) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >road_suffix: character string  (10) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" >FK</TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >locality_pid: character string  (15) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >state: character string  (3) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >geometry: Polyline </TD>
    </TR>

    </TABLE>>];


    roads [shape=plain
    label=<<TABLE BGCOLOR="#7EA6E0"
    BORDER="1"
    CELLBORDER="0"
    style="rounded"
    CELLSPACING="0"
    CELLPADDING="5">

    <TR>
    <TD  COLSPAN="2">roads</TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" >PK</TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >road_pid: character string (15) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >contributor_id: character string (40) </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" >national_route: character string (10) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >state_route: character string (10) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >road_name: character string (50) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >road_name_label: character string (50) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >road_type: character string (12) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >road_type_label: character string (12) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >road_suffix: character string (10) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >road_suffix_label: character string (10) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >road_alias_name: character string (50)      </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >road_alias_type: character string (12) </TD>
    </TR>


    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >road_alias_suffix: character string (10) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >hierarchy: character string (25) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >subtype: character string (10) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >lane_count: number (2) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >lane_description: character string (20) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >one_way: character string (20) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >access_type: character string (20) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >status: character string (20) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >surface: character string (20) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >trafficability: character string (20) </TD>
    </TR>

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >travel_direction: character string (7) </TD>
    </TR>

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

    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >state: character string (3) </TD>
    </TR>


    <TR>
    <TD BGCOLOR="white" ></TD>
    <TD BGCOLOR="white" ALIGN="LEFT" >geometry: Polyline </TD>
    </TR>

    </TABLE>>];

    }

    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>


        </TABLE>>]

        key [shape=plain  label=<<table border="0" cellpadding="1" cellspacing="0" cellborder="0">
          <tr><td port="i1"> Zero or Many </td> </tr>
          <tr><td port="i2"> One </td> </tr>

          </table>>]

        key2 [shape=plain label=<<TABLE border="0" cellpadding="1" cellspacing="0" CELLBORDER="0">
          <tr><td port="i1"> </td></tr>
          <tr><td port="i2"> </td></tr>

          </TABLE>>]

          key:i1 -> key2:i1 [arrowhead=crownoneodot]
          key:i2 -> key2:i2 [arrowhead=nonetee]

        }

    roads -> street_locality_line [arrowhead=crownoneodot dir=both arrowtail=nonetee]

    street_locality_line -> legend [style=invis]

    }