Contacts

Identifiers and Keywords

ANZLIC Id

ANZVI0803005216 

Victorian Spatial Data Library (VSDL) Schema

FORESTS:RECWEB_HISTORIC_RELIC 

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 historic relics for public visitation. 

Classification

Unclassified  

Creative Commons Attribution 4.0 (CC-BY)

• 
• License Text

Other Dataset Details

Date ( Revision )

2022-12-02

Date ( Publication )

2024-03-17T18:50:27

Status

Completed  

Purpose

This dataset provides information on historic relics suitable for public visitation (ie. type, significance and location) to assist staff in their management and maintenance and to promote these historic relics for public visitation. This dataset replaces the RFDB_HISTORIC_RELIC dataset. 

Credit

David Payne - initial design of table structure Cameron Williams - advice and program development (SQL, oracle SQL on python, Oracle Spatial, automation) Saionn Chann - RECWEB source tables Martin Talento - migration and maintenance of automated geoprocessing service (2013-2023) 

Supplemental Information

History: Formerly RFDB_HISTORIC_RELIC 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. The audio and video id columns were added to enable app users to access site related videos and audios. 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_HISTORIC_RELIC. Data is derived from RECWEB_FAC_HISTORIC_RELIC. Points are created by Oracle spatial . 

Maintenance and update frequency

Daily  

Maintenance date ( Publication )

2023-03-20T01:16:25

Spatial

Spatial representation type

Vector  

Reference system identifier

4283

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. The source table for the RECWEB_HISTORIC_RELIC is RECWEB_FAC_HISTORIC_RELIC. This is a data dump from the Recweb database. The latitude and longitude are used to create the point layers on engine13. 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
LABEL	O	N	VARCHAR2	60						LABEL
COMMENTS	O	N	VARCHAR2	4000						COMMENTS
AUDIO_ID_3	O	N	VARCHAR2	10						AUDIO_ID_3
AUDIO_ID_1	O	N	VARCHAR2	10						AUDIO_ID_1
SDE_DATE	O	N	VARCHAR2	60						SDE_DATE
VIDEO_ID_3	O	N	VARCHAR2	10						VIDEO_ID_3
ELEV_STRU	O	N	VARCHAR2	3						ELEV_STRU
SERIAL_NO	O	N	VARCHAR2	10						SERIAL_NO
LATITUDE	O	N	NUMBER	22	38	10				LATITUDE
PHOTO_ID_1	O	N	VARCHAR2	10						PHOTO_ID_1
VIDEO_ID_1	O	N	VARCHAR2	10						VIDEO_ID_1
ENTITY_ID	O	N	VARCHAR2	9						ENTITY_ID
IS_PART_OF	O	N	VARCHAR2	10						IS_PART_OF
VIDEO_ID_2	O	N	VARCHAR2	10						VIDEO_ID_2
TYPE	O	N	VARCHAR2	30						TYPE
ALTER_DATE	O	N	VARCHAR2	25						ALTER_DATE
VERS_DATE	O	N	DATE	7						VERS_DATE
PUBLISHED	O	N	VARCHAR2	3						PUBLISHED
CATEGORY	O	N	VARCHAR2	30						CATEGORY
HPL_NO	O	N	VARCHAR2	5						HPL_NO
NAME	O	N	VARCHAR2	100						NAME
AUDIO_ID_2	O	N	VARCHAR2	10						AUDIO_ID_2
FAC_TYPE	O	N	VARCHAR2	30						FAC_TYPE
SIGNIF	O	N	VARCHAR2	20						SIGNIF
LONGITUDE	O	N	NUMBER	22	38	10				LONGITUDE
UFI	O	N	VARCHAR2	25						UFI
DIS_ACCESS	O	N	VARCHAR2	10						DIS_ACCESS
Y_COORD	O	N	NUMBER	22	38	10				Y_COORD
PHOTO_ID_2	O	N	VARCHAR2	10						PHOTO_ID_2
PHOTO_ID_3	O	N	VARCHAR2	10						PHOTO_ID_3
X_COORD	O	N	NUMBER	22	38	10				X_COORD

About the Metadata Record

Metadata identifier

urn:uuid / f820e396-84ac-598c-9c73-f0305a028783