Address Pool¶
Insight Pack¶
Disclaimer
Overview¶
The Address Pool Insight Pack is a national digital dataset representing pool information at the address level for each State and Territory in Australia. Pool information such as a pool flag (Yes/No presence of a pool), pool count (count of pools related to an address) and pool area (combined area of all pools relating to an address) are provided at the address level.
Geoscape Australia welcomes your feedback on our Address Pool Insight Pack. We also publish regular updates on the development of our products on the Geoscape website ( www.geoscape.com.au ).
Frequency and Currency¶
The Address Pool Insight Pack is released on a quarterly schedule for the months of March, June, September and December.
Technical Description¶
Linkages¶
The Address Pool Insight Pack references addresses with pool information associated. An address that has not been assessed for pool information will not be represented in the Address Pool Insight Pack.
The address_pid attribute can be used to link the Address Pool Insight Pack address_pool table to the Buildings product building_address table. This is a 1:Many relationship as an address_pool record can relate to an address that links to many buildings and therefore has many building_address records.
The address_detail_pid attribute can be used to link the Address Pool Insight Pack address_pool table to the G-NAF product address_detail table. This is a Many:1 relationship. An address_pool record will usually link to only one G-NAF address_detail record. However, in some cases due to the way the address link is created more than one address_pool record may relate to one G-NAF address_detail record.
Data format¶
The Address Pool Insight Pack is provided in the Pipe-Separated Values (PSV) file format and is an aspatial file.
More Information¶
For more information on the Address Pool Insight Pack please contact Geoscape Australia Support.
Data Model¶
![digraph G {
fontname="ROBOTO" fontsize="10pt"
node [fontname="ROBOTO" fontsize="8pt"]
edge [fontname="ROBOTO" fontsize="8pt"]
address_pool [shape=plain
label=<<TABLE BGCOLOR="#FFD966"
BORDER="1"
CELLBORDER="0"
style="rounded"
CELLSPACING="0"
CELLPADDING="5">
<TR>
<TD COLSPAN="2">address_pool</TD>
</TR>
<TR>
<TD BGCOLOR="white" >PK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >address_pid: varchar (15) </TD>
</TR>
<TR>
<TD BGCOLOR="white" >FK</TD>
<TD BGCOLOR="white" ALIGN="LEFT" >address_detail_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" >address: varchar (150) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >date_last_captured: date </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >capture_resolution: varchar (6) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >capture_method: varchar (20) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >pool_flag: varchar (3) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >pool_count: number (2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >pool_area: number (10,2) </TD>
</TR>
<TR>
<TD BGCOLOR="white" ></TD>
<TD BGCOLOR="white" ALIGN="LEFT" >state: varchar (3) </TD>
</TR>
</TABLE>>];
}](_images/graphviz-bdcd1c309cf818cd62f9282eb93b66e499d58ab1.png)
Data Dictionary¶
This data dictionary is applicable for the address_pool insights pack.
Attribute |
Data Type |
Description |
Primary Key |
Mandatory |
10 Character Alias |
|---|---|---|---|---|---|
address_pid |
character string (15) |
The address pid that is related to the pool feature. The persistent identifier is unique to the address feature this record relates to. |
Yes |
Yes |
ADD_PID |
address_detail_pid |
character string (15) |
The unique persistent identifier for each address_detail record associated with the address record. |
No |
No |
ADD_DT_PID |
date_created |
date (yyyy-mm-dd) |
The date of record creation for the address_pool record. |
No |
Yes |
DT_CREATE |
date_modified |
date (yyyy-mm-dd) |
The most recent date that an attribute has been modified for the address_pool record. |
No |
No |
DT_MOD |
address |
character string (150) |
The address string from the related address record. |
No |
Yes |
ADDRESS |
date_last_captured |
date (yyyy-mm-dd) |
The date of the image used for the most recent update of the pool_flag field. |
No |
Yes |
DT_LST_CPT |
capture_resolution |
character string (6) |
Resolution in centimeters of the imagery source used to capture the pool information. |
No |
Yes |
CAPT_RES |
capture_method |
character string (20) |
Type of imagery source used to capture the pool information (e.g. Aerial, Satellite, etc.). |
No |
Yes |
CAPT_MTHD |
pool_flag |
character string (3) |
Indicates whether a pool is on a property related to the address (Yes/No). |
No |
Yes |
POOL_FLAG |
pool_count |
number (2) |
The number of pools related to the address. |
No |
No |
POOL_COUNT |
pool_area |
number (10,2) |
The area of pool/s related to the address. |
No |
No |
POOL_AREA |
state |
character string (3) |
The abbreviated name of the State or Territory that the address is primarily within. |
No |
Yes |
STATE |