Contacts

Identifiers and Keywords

ANZLIC Id

ANZVI0803005213 

Victorian Spatial Data Library (VSDL) Schema

FORESTS:RECWEB_SITE 

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 sites 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:45:39

Status

Completed  

Purpose

The main purpose is to assist DELWP staff with the management of recreation sites and to promote these sites for public use. This dataset replaces the RFDB_SITE dataset. 

Credit

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

Supplemental Information

History: Formerly RFDB_SITE 19 July 2017 - Structural Change Changed the table structure to add horse riding activity and comments (HORSE_RIDE and HORSERIDE_C), changed caravan descriptions to campervanning (CARAVAN to CAMPERVANNING, CARAVAN_C to CAMPERVAN_C), added column CAMPERVAN_TYPE and extended CAMPING_C and HERITAGE_C to 1,000 characters. 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. Also added activity ranking columns for optimised mapping display. March,2019 - extend rest of activity desc to 1000 characters 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 

Maintenance and update frequency

Daily  

Maintenance date ( Publication )

2023-03-20T01:18:35

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

Location: 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. Data Creation: Facility and activity tables are dumped from the recweb database into CGDLDEV 'FORESTS' schema. These tables undergo a QA to remove and report back items that dont have a location or SERIAL_NO. Locations (X, Y values) are used to create the points. SERIAL_NO field is used to join associated tables. 

Statement

Dataset Source: Primary dataset based on GPS field work. The location and contents were derived from the RECWEB_FAC_RECREATION_SITE table. Other tables with a RECWEB_ACT prefix are joined to the Recreation Site using the ALLOWED_AT and SERIAL_NO fields respectively. This tells which activities are allowed in a Recreation Site location. 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
FAC_TYPE	O	N	VARCHAR2	150						FAC_TYPE
FOSSICKING	O	N	VARCHAR2	30						FOSSICKING
CLOS_REAS	O	N	VARCHAR2	30						CLOS_REAS
WILDLIFE	O	N	VARCHAR2	30						WILDLIFE
FOSSICK_C	O	N	VARCHAR2	1000						FOSSICK_C
PADDLING_C	O	N	VARCHAR2	1000						PADDLING_C
HORSE_RIDE	O	N	VARCHAR2	30						HORSE_RIDE
TBVA_R	O	N	NUMBER	22	10	0				TBVA_R
CAMPING	O	N	VARCHAR2	30						CAMPING
FISHING_R	O	N	NUMBER	22	10	0				FISHING_R
REDUCE_C	O	N	VARCHAR2	1000						REDUCE_C
COMMENTS	O	N	VARCHAR2	4000						COMMENTS
LONGITUDE	O	N	NUMBER	22	38	10				LONGITUDE
CAMPERVAN_R	O	N	NUMBER	22	10	0				CAMPVANR
PHOTO_ID_1	O	N	VARCHAR2	10						PHOTO_ID_1
CLOS_DESC	O	N	VARCHAR2	1000						CLOS_DESC
CLOS_STAT	O	N	VARCHAR2	30						CLOS_STAT
BBQ_GAS	O	N	VARCHAR2	3						BBQ_GAS
SITE_CLASS	O	N	VARCHAR2	20						SITE_CLASS
TREEVIEW_C	O	N	VARCHAR2	4000						TREEVIEW_C
HANG_GLD_R	O	N	NUMBER	22	10	0				HANG_GLD_R
PICNICING	O	N	VARCHAR2	30						PICNICING
Y_COORD	O	N	NUMBER	22	38	10				Y_COORD
HANG_GLD_C	O	N	VARCHAR2	1000						HANG_GLD_C
HANG_GLIDE	O	N	VARCHAR2	30						HANG_GLIDE
HORSERIDE_C	O	N	VARCHAR2	1000						HORSERIDEC
WALKDOG_C	O	N	VARCHAR2	1000						WALKDOG_C
UFI	O	N	VARCHAR2	25						UFI
REDUCE_NA	O	N	VARCHAR2	30						REDUCE_NA
X_COORD	O	N	NUMBER	22	38	10				X_COORD
PADDLING_R	O	N	NUMBER	22	10	0				PADDLING_R
IS_PART_OF	O	N	VARCHAR2	30						IS_PART_OF
CAMPERVAN_TYPE	O	N	VARCHAR2	30						CAMPERVANT
VERS_DATE	O	N	DATE	7						VERS_DATE
FEE	O	N	VARCHAR2	10						FEE
PUBLISHED	O	N	VARCHAR2	3						PUBLISHED
HERITAGE_C	O	N	VARCHAR2	4000						HERITAGE_C
TBVA_C	O	N	VARCHAR2	1000						TBVA_C
CLOS_START	O	N	DATE	7						CLOS_START
BBQ_ELEC	O	N	VARCHAR2	3						BBQ_ELEC
TREEVIEW_R	O	N	NUMBER	22	10	0				TREEVIEW_R
SERIAL_NO	O	N	VARCHAR2	10						SERIAL_NO
BBQ_WOOD	O	N	VARCHAR2	3						BBQ_WOOD
FAC_CODE	O	N	VARCHAR2	25						FAC_CODE
HERITAGE_R	O	N	NUMBER	22	10	0				HERITAGE_R
FOSSICK_R	O	N	NUMBER	22	10	0				FOSSICK_R
LABEL	O	N	VARCHAR2	100						LABEL
FISHING_C	O	N	VARCHAR2	1000						FISHING_C
NAME	O	N	VARCHAR2	100						NAME
ACCESS_DSC	O	N	VARCHAR2	4000						ACCESS_DSC
PADDLING	O	N	VARCHAR2	30						PADDLING
REDUCE_R	O	N	NUMBER	22	10	0				REDUCE_R
PHOTO_ID_3	O	N	VARCHAR2	10						PHOTO_ID_3
WALKDOG_R	O	N	NUMBER	22	10	0				WALKDOG_R
WILDLIFE_C	O	N	VARCHAR2	1000						WILDLIFE_C
PICNICING_R	O	N	NUMBER	22	10	0				PICNICINGR
ACT_CODE	O	N	VARCHAR2	25						ACT_CODE
CAMPERVANNING	O	N	VARCHAR2	30						CAMPERVANG
CAMPERVAN_C	O	N	VARCHAR2	1000						CAMPERVANC
WILDLIFE_R	O	N	NUMBER	22	10	0				WILDLIFE_R
LATITUDE	O	N	NUMBER	22	38	10				LATITUDE
PCT_AFRAME	O	N	VARCHAR2	3						PCT_AFRAME
SDE_DATE	O	N	VARCHAR2	25						SDE_DATE
TB_VISITOR	O	N	VARCHAR2	30						TB_VISITOR
WALKINGDOG	O	N	VARCHAR2	30						WALKINGDOG
BBQ_PIT	O	N	VARCHAR2	3						BBQ_PIT
CLOS_OPEN	O	N	DATE	7						CLOS_OPEN
PCT_OTHER	O	N	VARCHAR2	3						PCT_OTHER
DIS_ACCESS	O	N	VARCHAR2	10						DIS_ACCESS
ENTITY_ID	O	N	VARCHAR2	9						ENTITY_ID
MAINTAINED_BY	O	N	VARCHAR2	100						MAINT_BY
ROCKCLIMB	O	N	VARCHAR2	30						ROCKCLIMB
PHOTO_ID_2	O	N	VARCHAR2	10						PHOTO_ID_2
FISHING	O	N	VARCHAR2	30						FISHING
HERITAGE	O	N	VARCHAR2	30						HERITAGE
PCT_PEDEST	O	N	VARCHAR2	3						PCT_PEDEST
PICNICING_C	O	N	VARCHAR2	1000						PICNIC_C
HORSERIDE_R	O	N	NUMBER	22	10	0				HORSERIDER
ALTER_DATE	O	N	VARCHAR2	25						ALTER_DATE
TREE_VIEW	O	N	VARCHAR2	40						TREE_VIEW
ROCKCLIMB_C	O	N	VARCHAR2	1000						ROCKCLMB_C
ROCKCLIMB_R	O	N	NUMBER	22	10	0				ROCKCLIMBR
CAMPING_R	O	N	NUMBER	22	10	0				CAMPING_R
WILDERNESS	O	N	VARCHAR2	20						WILDERNESS
CAMPING_C	O	N	VARCHAR2	1000						CAMPING_C

About the Metadata Record

Metadata identifier

urn:uuid / b17d4d92-461f-500b-b023-1340f811681b