Appendix A: National Roads Data Model DiagramΒΆ

digraph G { fontname="ROBOTO" fontsize="10pt" node [fontname="ROBOTO" fontsize="8pt"] edge [fontname="ROBOTO" fontsize="8pt"] rankdir = LR subgraph cluster_roads { label=" National 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] }