Address Pool

Insight Pack

Disclaimer

Geoscape Australia believes this publication to be correct at the time of printing and does not accept responsibility for any consequences arising from the use of the information herein. Readers should rely on their own skill and judgement to apply information to particular issues.
This work is copyright. Apart from any use as permitted under the Copyright Act 1968, no part may be reproduced by any process without prior written permission of Geoscape Australia.

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>>];

}

Data Dictionary

This data dictionary is applicable for the address_pool insights pack.

address_pool

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.

Geoscape Australia Support
Geoscape Australia