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 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.

Geoscape Australia Support
Geoscape Australia

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.

Data dictionary for 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