Contacts

Identifiers and Keywords

ANZLIC Id

ANZVI0803005214 

Victorian Spatial Data Library (VSDL) Schema

FORESTS:RECWEB_ASSET 

Jurisdiction

Victoria 

Topic category

• Biota
• Structure

Resource Constraints

Use limitation

The dataset is available via VSDL, spatial datamart, open data feature services. Viewable in Mapshare Forest Explorer and More to Explore iphone app. To promote these assets for public use and encourage visitation. 

Classification

Unclassified  

Creative Commons Attribution 4.0 (CC-BY)

• 
• License Text

Other Dataset Details

Date ( Revision )

2022-06-22

Date ( Publication )

2024-11-19T19:25:14

Status

Completed  

Purpose

The main purpose is to assist DELWP staff with the management of recreation assets and to promote these assests for public use. This dataset replaces the RFDB_BIRD_VIEWING_HIDE, RFDB_BOARDWALK, RFDB_BRIDGE, RFDB_GENERATOR, RFDB_HANG GLIDING LAUNCH, RFDB-INFORMATION SHELTER, RFDB_JETTY, RFDB_PICNIC SHELTER, RFDB_SITE ELEMENT, RFDB_ELEVATED STAIRS, RFDB_TOILET BLOCK, RFDB_VIEWING PLATFORM datasets. 

Credit

David Payne - initial design of table structure Cameron Williams - advice and program development (SQL, oracel SQL on python, Oracle Spatial, automation) Saionn Chann - RECWEB source tables 

Supplemental Information

History: Formerly RFDB_BIRD_VIEWING_HIDE, RFDB_BOARDWALK, RFDB_BRIDGE, RFDB_GENERATOR, RFDB_HANG GLIDING LAUNCH, RFDB-INFORMATION SHELTER, RFDB_JETTY, RFDB_PICNIC SHELTER, RFDB_SITE ELEMENT, RFDB_ELEVATED STAIRS, RFDB_TOILET BLOCK, RFDB_VIEWING PLATFORM December, 2018 Addition of Unique Feature Identifier (UFI), a combination of the entity id and update date. Incremental update is enable using the UFI numbers. Current Design Issues: Recreation Facilites Database datatsets are currently captured as individual shapefiles which are validated, merged and migrated to the FORESTS schema of the corporate SDE evironment via an Arc/Info aml based process. Related Documents: None This dataset replaces the RFDB asset datasets- Bird Viewing Hide, Boardwalk, Bridge, Rec Generator, Hang Gliding Launch, Information Shelter, Jetty, Picnic Shelter, Recreation Element, Elevated Stairs, Toilet Block and Viewing Platform. Several tables with their Lat and Lon values are combined into the RECWEB_ASSET dataset. Oracle SQL is used to create the final tables structure. Oracle spatial is used to create the points layer. The following are the source tables used to create the dataset: RECWEB_FAC_BIRD_VIEW RECWEB_FAC_BOARDWALK RECWEB_FAC_BRIDGE RECWEB_FAC_ELEVATED_STAIRS RECWEB_FAC_HANG_GLIDING_LAUNCH RECWEB_FAC_INFORMATION_SHELTER RECWEB_FAC_JETTY RECWEB_FAC_PHOTO_EXTRA RECWEB_FAC_PICNIC_SHELTER RECWEB_FAC_REC_GENERATOR RECWEB_FAC_SITE_ELEMENT RECWEB_FAC_TOILET_BLOCK RECWEB_FAC_VIEWING_PF 

Maintenance and update frequency

Daily  

Maintenance date ( Publication )

2023-03-20T01:15:34

Spatial

Spatial representation type

Vector  

Description

General - Victoria 

Reference system identifier

4283

N

S

E

W

Temporal

Begin date

2013-07-18 

End date

now  

Resolution

Horizontal Accuracy

25m  

Quality

Conceptual Consistency

The majority of points have sub metre accuracy. All data has been post processed using GPSnet base stations. 

Missing Data

80% 

Attribute Quality

Recreation Facility attributes were collected on site. The majority of the attributes are from drop down lists which minimises errors. 

Positional Accuracy

Data has been collected with a Trimble pro XR GSP with an external antenna. The majority of points have sub metre accuracy, detailed in the attributes. The upper limit of accuracy is within 10m for 95% of the data. All data has been post processed using GPSnet base stations. 

Lineage

Description

All data has been post processed by base stations. A customised processing system screens the data to ensure all serial numbers are unique and to detect spelling errors. 

Statement

Dataset Source: Primary dataset based on GPS field work. Dataset Originality: Primary 

Attributes

Column Name	Obligation	Unique	Data Type	Data Length	Data Precision	Data Scale	Reference Table Owner	Reference Table Name	Reference Table Code Column Name	Short Column Name	Definition
ASSET_CLS	O	N	VARCHAR2	20						ASSET_CLS
CATEGORY	O	N	VARCHAR2	30						CATEGORY
X_COORD	O	N	NUMBER	22	38	10				X_COORD
IS_PART_OF	O	N	VARCHAR2	10						IS_PART_OF
PUBLISHED	O	N	VARCHAR2	3						PUBLISHED
NAME	O	N	VARCHAR2	100						NAME
SERIAL_NO	O	N	VARCHAR2	10						SERIAL_NO
LENGTH_M	O	N	NUMBER	22	10	0				LENGTH_M
SDE_DATE	O	N	VARCHAR2	60						SDE_DATE
DIS_ACCESS	O	N	VARCHAR2	10						DIS_ACCESS
LATITUDE	O	N	VARCHAR2	20						LATITUDE
PHOTO_ID_1	O	N	VARCHAR2	10						PHOTO_ID_1
QUANTITY	O	N	NUMBER	22	10	0				QUANTITY
Y_COORD	O	N	NUMBER	22	38	10				Y_COORD
VERS_DATE	O	N	DATE	7						VERS_DATE
LABEL	O	N	VARCHAR2	65						LABEL
ELEV_STRU	O	N	VARCHAR2	3						ELEV_STRU
LONGITUDE	O	N	VARCHAR2	20						LONGITUDE
PHOTO_ID_2	O	N	VARCHAR2	10						PHOTO_ID_2
PHOTO_ID_3	O	N	VARCHAR2	10						PHOTO_ID_3
TYPE	O	N	VARCHAR2	30						TYPE
WIDTH_M	O	N	NUMBER	22	10	0				WIDTH_M
FAC_TYPE	O	N	VARCHAR2	30						FAC_TYPE
COMMENTS	O	N	VARCHAR2	4000						COMMENTS
UFI	O	N	VARCHAR2	25						UFI

About the Metadata Record

Metadata identifier

urn:uuid / 607a12fb-359c-5173-aba6-fe0e89c13907