Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleAttribute Schema:

Recreational Areas

A polygon feature class displaying the extent of land set aside for recreational, relaxation or amusement purposes.

Column Name

Nulls

Format

Size

Description

Constraints

FEATURE_TYPE

No

Text

50

 

Unique feature type that identifies the type of feature. Options:

  • Aquatic Centre

  • Botanic Gardens

  • Civic Square

  • Golf Course

  • Park

  • Racecourse

  • Rifle Range

  • Show Ground

  • Sporting Complex

  • Theme Park

  • Zoo

  • Other Recreational Area

 

dm_rec_area

NAME

Yes

Text

100

The name of the feature (if available)

 

ALTERNATE_NAME

Yes

Text

100

 

An alternate name of the feature if available from the Queensland Place Names Database, otherwise left blank

 

 

QLD_PNDB_ID

Yes

Long

 

Queensland Place Names Database unique identifier

 

ATTRIBUTE_SOURCE

No

Text

100

 

If the feature is named, the attribute_source is the source imagery, map, or data from which the features name has been obtained.

If the feature is not named, the attribute_source is the source imagery, map, or data used to define what the feature type is.  

 

 

ATTRIBUTE_DATE

No

Date

 

Date of the source imagery, map, or data used for attributing the feature.

 

ADDITIONAL_NAMES

Yes

Text

100

 

The feature may be commonly known by other names or have different spelling. Multiple additional names can be shown and separated by a comma.

 

 

ADD_NAMES_SOURCE

Yes

Text

100

 

The source map or data that the additional names were obtained.  Multiple sources can be shown, separated by a comma. If multiple sources are shown, the written sequence will be the same as the written sequence of the names themselves.

 

 

FEATURE_SOURCE

No

Text

100

 

The source imagery, map, or data that the spatial location and shape of the of the feature was obtained from.

 

 

FEATURE_DATE

No

Date

 

 

Date of the source imagery, map, or data that the spatial location and shape of the feature was obtained from.

 

 

PFI

No

Text

15

 

A Persistent Feature Identifier (PFI) is generated for each feature at the point of creation in the database. The value of the PFI will stay with the feature through all changes to the feature (both spatial and non-spatial) until the feature is retired. (See Persistent and Unique Feature Identifiers)

 

 

UFI

No

Text

15

 

A Unique Feature Identifier (UFI) is generated for each new feature at the point of creation in the database (at this point the PFI and UFI will be the same). The value of the UFI will stay with the feature through all changes to the feature (both spatial and non-spatial) unless the feature is split into multiple other parts. If the feature is split, the separate parts will retain the original PFI but new UFI’s will be generated for the split parts. (See Persistent and Unique Feature Identifiers)

 

 

CREATED_DATE*

No

Date

 

The date the feature was originally captured and first loaded to the database

*internal use only

 

LAST_EDITED_DATE*

No

Date

 

Date of the last editing or revision to the feature

*internal use only

 

 

DIMENSION_M2

No

Double

 

 

The area of the feature measured in square metres GDA2020

 

 

UPPER_SCALE

No

Long

 

The upper scale for which the feature should be considered suitable for digital display

dm_upper_scale

TEXT_NOTE

Yes

Text

50

  •  

  • For mapping purposes. Additional annotation that can be shown on a map.

  • If the feature type is an aquatic centre, golf course, park, rifle range, showground or sporting complex and the feature has no name. In this field, type in lower case either of the following:

    • aquatic centre

    • golf course

    • park

    • rifle range

    • showground

    • sporting complex

  • If the feature type is a racecourse, used for the racing of horses and the feature has no name. In this field, type in lower case the following:

    • racecourse

  • If the feature type is a racecourse used for racing other than by horses and the feature has no name. In this field, type in lower case either of the following:

    • bmx

    • motorsport

  • If the feature type is a caravan park. The feature is classified as “Other Recreational Area” in the feature type field and no name is recorded in the name field. In this field, type in lower case the following:

    • caravan park

  • If the feature type is a dog park. The feature is classified as “Other Recreational Area” in the feature type field and no name is recorded in the name field. In this field, type in lower case the following:

    • dog park

 

 

ADD_INFORMATION

Yes

Text

255

A comment field (additional information)

 

...