Appendix B – Data Dictionary¶
Commonwealth Electoral Boundaries¶
Name |
Data Type |
Description |
Prim Key |
Man |
F K TABLE |
F K Col |
10 Char Alias |
|---|---|---|---|---|---|---|---|
COMM_ELECTORAL_PID |
varchar2(15) |
The Persistent Identifier is unique to the real world feature this record represents. |
Y |
Y |
CE_PID |
||
DATE_CREATED |
date |
Date this record was created. |
N |
Y |
DT_CREATE |
||
DATE_RETIRED |
date |
Date this record was retired. |
N |
N |
DT_RETIRE |
||
COMM_ELECTORAL_NAME |
varchar2(50) |
Name of the Commonwealth electorate. |
N |
Y |
NAME |
||
DATE_GAZETTED |
date |
Gazetted date. |
N |
N |
DT_GAZETD |
||
STATE_PID |
varchar2(15) |
State Persistent Identifier. |
N |
Y |
STATE |
STATE_PID |
STATE_PID |
REDISTYEAR |
number(4) |
The field is the year of the boundary redistribution for each electorate. |
N |
N |
REDISTYEAR |
Name |
Data Type |
Description |
Prim Key |
Man |
F K TABLE |
F K Col |
10 Char Alias |
|---|---|---|---|---|---|---|---|
COMM_ELECTORAL_POLYGON_PID |
varchar2(15) |
The Persistent Identifier is unique to the real world feature this record represents. |
y |
y |
CE_PLY_PID |
||
DATE_CREATED |
date |
Date this record was created. |
N |
Y |
DT_CREATE |
||
DATE_RETIRED |
date |
Date this record was retired. |
N |
N |
DT_RETIRE |
||
COMM_ELECTORAL_PID |
varchar2(15) |
Commonwealth electoral persistent identifier. |
N |
Y |
COMM_ELECTORAL |
COMM_ELECTORAL_PID |
CE_PID |
GEOMETRY |
polygon |
Polygon geometry. |
N |
Y |
GEOMETRY |
State Electoral Boundaries¶
Name |
Data Type |
Description |
Prim Key |
Man |
F K TABLE |
F K Col |
10 Char Alias |
|---|---|---|---|---|---|---|---|
STATE_ELECTORAL_PID |
varchar2(15) |
The Persistent Identifier is unique to the real world feature this record represents. |
Y |
Y |
SE_PID |
||
DATE_CREATED |
date |
Date this record was created. |
N |
Y |
DT_CREATE |
||
DATE_RETIRED |
date |
Date this record was retired. |
N |
N |
DT_RETIRE |
||
STATE_ELECTORAL_NAME |
varchar2(50) |
Name. |
N |
Y |
NAME |
||
DATE_GAZETTED |
date |
Gazetted date. |
N |
N |
DT_GAZETD |
||
EFFECTIVE_START |
date |
Where available, the date the electorate becomes effective, often this is the first election date after redistribution. In some states the effective date and gazetted date are the same |
N |
N |
EFF_START |
||
EFFECTIVE_END |
date |
Where available, the date the electorate is no longer in effect, often this is the due to a redistribution. |
N |
N |
EFF_END |
||
STATE_PID |
varchar2(15) |
State Persistent Identifier. |
N |
Y |
STATE |
STATE_PID |
STATE_PID |
STATE_ELECTORAL_CLASS_CODE |
varchar2(10) |
State Electoral class code |
N |
N |
STATE_ELECTORAL_CLASS_AUT |
CODE |
SECL_CODE |
Name |
Data Type |
Description |
Prim Key |
Man |
F K TABLE |
F K Col |
10 Char Alias |
|---|---|---|---|---|---|---|---|
STATE_ELECTORAL_POLYGON_PID |
varchar2(15) |
The Persistent Identifier is unique to the real world feature this record represents. |
Y |
Y |
SE_PLY_PID |
||
DATE_CREATED |
date |
Date this record was created. |
N |
Y |
DT_CREATE |
||
DATE_RETIRED |
date |
Date this record was retired. |
N |
N |
DT_RETIRE |
||
STATE_ELECTORAL_PID |
varchar2(15) |
State electoral Persistent Identifier. |
N |
N |
STATE_ELECTORAL |
STATE_ELECTORAL_PID |
SE_PID |
GEOMETRY |
polygon |
Polygon geometry. |
N |
Y |
GEOMETRY |
Name |
Data Type |
Description |
Prim Key |
Man |
F K TABLE |
F K Col |
10 Char Alias |
|---|---|---|---|---|---|---|---|
CODE |
varchar2(10) |
This is the persistent Identifier of the record. |
Y |
Y |
CODE |
||
NAME |
varchar2(50) |
Name. |
N |
Y |
NAME |
||
DESCRIPTION |
varchar2(200) |
Description of the State Electoral classes. |
N |
N |
DESCRIPTIO |
Code |
DESCRIPTION |
NAME |
|---|---|---|
1 |
Jurisdiction Electoral Boundaries for the House of Assembly |
House of Assembly |
2 |
Jurisdiction Electoral Boundaries for the Legislative Assembly |
Legislative Assembly |
3 |
Jurisdiction Electoral Boundaries for the Legislative Council |
Legislative Council |
4 |
Jurisdiction Electoral Boundaries for the Legislative Assembly and Legislative Council |
Legislative Assembly and Legislative Council |
5 |
Jurisdiction Electoral Boundaries for the House of Assembly and Legislative Council |
House of Assembly and Legislative Council |