Title

Recreation Assets 

Alternate title

RECWEB_ASSET 

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 

Status

Completed  

Horizontal Accuracy

25m  

Code

4283 

Maintenance and update frequency

Daily  

Topic category

• Biota
• Structure

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  

Statement

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

Description

Collection Method: Trimble pro XR GPS with external atenna. 

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. 

Classification

Unclassified  

Attribute Quality

Comments

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

Positional Accuracy

Comments

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. 

Conceptual Consistency

Comments

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

Missing Data

Comments

80% 

Excess Data