Address Pool¶
Insight Pack¶
Disclaimer
Overview¶
The Address Pool Insight Pack is a national digital dataset that provides swimming pool information at the address level across all Australian states and territories. It includes attributes such as a pool presence flag, pool count, and pool area.
Detailed attribute definitions are provided in the data dictionary.
Technical Description¶
Coverage¶
The Address Pool Insight Pack includes addresses that have been assessed for pool information. Addresses that have not been assessed for pool attributes are not included in this Insight Pack.
Linkages¶
Records in the Address Pool Insight Pack can be linked to the National Buildings product using the address_pid attribute. An address may relate to multiple buildings, and therefore to multiple records in the Buildings product. Records can also be linked to the G-NAF address_detail table using the address_detail_pid attribute. In most cases, an Address Pool record links to a single G-NAF address_detail record. In some cases, more than one Address Pool record may relate to the same address_detail record.
Data format¶
The Address Pool Insight Pack is provided as an aspatial dataset in Pipe Separated Values (PSV) format.
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 |
Frequency and Currency¶
The Address Pool Insight Pack is updated on a quarterly release cycle in March, June, September and December.
The currency of individual address pool records may vary across the dataset depending on when they were last captured or updated. Relevant dates are provided as attributes in the dataset.
More Information¶
For more information on the Address Pool Insight Pack please contact Geoscape Australia Support.