Docs
Go to Hub
Electoral Boundaries
Documentation
Contents
Overview
Specification Scope
Data Product Identification
Data Content and Structure
Reference System
Data Quality
Data Capture
Data Updates and Maintenance
Delivery Format
Appendices
Appendix A – Data Model Diagram
Appendix B – Data Dictionary
Appendix C - Metadata
References
Geoscape Documentation
Related Topics
Documentation overview
Appendices
Previous:
Appendices
Next:
Appendix B – Data Dictionary
←
Appendices
Appendix B – Data Dictionary
→
Appendix A – Data Model Diagram
¶
←
Appendices
Appendix B – Data Dictionary
→
![digraph G {
fontname="ROBOTO" fontsize="10pt"
node [fontname="ROBOTO" fontsize="8pt"]
edge [fontname="ROBOTO" fontsize="8pt"]
rankdir=LR
graph [pad="0.5", ranksep="0.75", nodesep="0.65"];
subgraph cluster_property { label="Electoral Boundaries"
graph[style="dashed,rounded" color="#EA6B66"]
comm_electoral_polygon [shape=plain
label=<<TABLE BGCOLOR="#7EA6E0"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">COMM_ELECTORAL_POLYGON</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >COMM_ELECTORAL_POLYGON_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_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >COMM_ELECTORAL_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GEOMETRY: Polygon </TD>
</TR>
</TABLE>>];
comm_electoral [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">COMM_ELECTORAL</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >COMM_ELECTORAL_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_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >COMM_ELECTORAL_NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_GAZETTED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >REDISTYEAR: number (4) </TD>
</TR>
</TABLE>>];
state_electoral_polygon [shape=plain
label=<<TABLE BGCOLOR="#7EA6E0"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">STATE_ELECTORAL_POLYGON</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_ELECTORAL_POLYGON_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_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_ELECTORAL_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >GEOMETRY: Polygon </TD>
</TR>
</TABLE>>];
state_electoral [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">STATE_ELECTORAL</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_ELECTORAL_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_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_ELECTORAL_NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DATE_GAZETTED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >EFFECTIVE_START: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >EFFECTIVE_END: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_PID: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_ELECTORAL_CLASS_CODE: varchar (10) </TD>
</TR>
</TABLE>>];
state_electoral_class_aut [shape=plain
label=<<TABLE BGCOLOR="#FFB570"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">STATE_ELECTORAL_CLASS_AUT</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >CODE: varchar (10) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >DESCRIPTION: varchar (200) </TD>
</TR>
</TABLE>>];
comm_electoral_polygon -> comm_electoral [arrowhead=nonetee dir=both arrowtail=crownonetee]
state_electoral_polygon -> state_electoral [arrowhead=nonetee dir=both arrowtail=crownonetee]
state_electoral_class_aut -> state_electoral [arrowhead=crownonetee dir=both arrowtail=nonetee]
{rank = same;comm_electoral; state_electoral;state_electoral_class_aut}
}
subgraph cluster_state {
graph[style="dashed,rounded" color ="#7EA6E0" label="State Boundaries" ]
state [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">STATE</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_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_RETIRED: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_NAME: varchar (50) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >STATE_ABBREVIATION: varchar (3) </TD>
</TR>
</TABLE>>];
}
comm_electoral -> state [arrowhead=nonetee dir=both arrowtail=crownone]
state_electoral -> state [arrowhead=nonetee dir=both arrowtail=crownone]
subgraph cluster_legend {
graph[style="" label="Legend", ranksep="0.2", nodesep="0.2"];
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="#FFB570" BORDER="1"> </TD>
<TD>Authority Code Table</TD>
</TR>
</TABLE>>]
key [shape=plain label=<<table border="0" cellpadding="1" cellspacing="0" cellborder="0">
<tr><td port="i1"> One </td> </tr>
<tr><td port="i2"> Many </td> </tr>
<tr><td port="i3"> One or Many </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>
<tr><td port="i3"> </td></tr>
</TABLE>>]
key:i1 -> key2:i1 [arrowhead=nonetee]
key:i2 -> key2:i2 [arrowhead=crown]
key:i3 -> key2:i3 [arrowhead=crownonetee]
legend -> key[style = invis]
}
}](../_images/graphviz-adce8616ddebff3b003293768386fdc87847b1c6.png)