Benchmarks

Benchmarks Benchmarks

Corporate Production GIS Metadata

Layer Name: Benchmarks

General Information

Layer Name:	Benchmarks
# of Features:	509
Status:	ACTIVE
Layer Source:	GIS_DATA.BENCHMARK
Layer Quality:	Good
Feature Accuracy:	+/- 2m
Type:	POINT
Description:	A Benchmark is a fixed permanent structure which has a measured vertical position above mean sea level. This vertical position is expressed as an "elevation" referenced from mean sea level set at 0.00 metres. These elevations are set by professional land surveyors for various levels of government and form a network across much of North America. Mean sea level is measured from New York.
Projection:	NAD 83 UTM Zone 17N (EPSG 26917)
Disclaimer:	The City of Kitchener assumes no responsibility for the accuracy of the provided data. Any use of this information is done so at the users risk. Good survey practices must be applied when utilizing this information. The City of Kitchener and its partners have created this data for information purposes on an as-is and as available basis and is under no circumstances a substitute for a Legal Survey. The City does not make any representations or warranty, express or implied, concerning the accuracy, quality, likely results, or reliability of the use of the data. The City of Kitchener assumes no responsibility for any errors and is not liable for any damages of any kind resulting from the use of, or reliance on, the information and material contained in this layer. All information should be verified independently before being used or relied on. Users are encouraged to contact the City of Kitchener to ensure the accuracy of the information provided by Kitchener.

Source and Contraints

Source Map Label:	Elevation Benchmarks: Development & Technical Services - Engineering (Nov 2003)
History:	Elevation Benchmarks: A Benchmark is a fixed permanent structure which has a measured vertical position above mean sea level. This vertical position is expressed as an "elevation" referenced from mean sea level set at 0.00 metres. These elevations are set by professional land surveyors for various levels of government and form a network across much of North America. Some of the permanent structures include: Concrete Monuments which are comprised of a concrete base with a brass tablet set into the top flat portion. This portion will have the identifying government agency details, a monument # and usually a penalty for removal warning stamped into the monuments flat top portion. Geodetic Tablets are typically brass tablets which are set permanently into a concrete structure in either a horizontal or vertical position. Each tablet is marked with the identifying government agency details, monument # and usually a penalty for removal warning stamped into the tablet. If it is set in a vertical wall a clear line denoting the elevation position is also stamped into the tablet.
Original Source:	INS - Engineering
Original Source Process:
Maintenance:
Current Info Source:	DTS - Engineering
Outstanding Issues:	Engineering not delivering this information as agreed through Service Agreement.
Update Frequency:	ON DEMAND

Data Fields & Domain Information

Benchmarks

Column Name	Alias	Data Type	Comments
OBJECTID	OBJECTID	NUMBER	ESRI system maintained integer field used to uniquely identify rows in tables in a geodatabase. Note that OBJECTIID values change upon export or import of the data and should not be used as a primary field for searching or identifying records.
CATEGORY	Category	VARCHAR2	Primary mapping field of the layer. Valid category values are:
SUBCATEGORY	Subcategory	VARCHAR2	Secondary mapping field of the layer.Valid subcategory values are:
STATUS	Status	VARCHAR2	Indicates the status of feature. A pick list is used for this field - contact GIS for pick list values.
STATUS_DATE	Status Date	DATE	Database maintained field. Updates to the current date/time when the STATUS field value is changed.
SOURCE	Source	VARCHAR2	GIS maintained field. Source EDRA (Electronic Document Registration Application) document number, or name of department or specific staff member that the information came from.
SOURCE_DATE	Source Date	DATE	GIS maintained field. Date of the source document or information.
CREATE_BY	Create By	VARCHAR2	Database maintained field. Updates to the user name that created the feature. Update takes place when the feature is created.
CREATE_DATE	Create Date	DATE	Database maintained field. Updates to the current data/time. Update takes place when the feature is created.
UPDATE_BY	Update By	VARCHAR2	Database maintained field. Updates to the user name that most recently updated either an attribute or the geometry of the feature. Update takes place when the feature is created and/or changed.
UPDATE_DATE	Update Date	DATE	Database maintained field. Updates to the current data/time when an attribute or the geometry of the feature is changed. Update takes place when the feature is created and/or changed.
TAG1	Tag1	VARCHAR2	Temporary location to store short term data for mapping purposes only.
TAG2	Tag2	NUMBER	Temporary location to store short term data for mapping purposes only.
TAG3	Tag3	NUMBER	Temporary location to store short term data for mapping purposes only.
BENCHMARKID	Benchmarkid	NUMBER	Database maintained field that permanently assigns a unique value for each record. This ID value should be the one referred to when identifying a record.
CROSS_REF_NO	Cross Ref No	VARCHAR2
ELEVATION	Elevation	NUMBER
DATE_INSTALLED	Date Installed	DATE
PLAN	Plan	VARCHAR2
UTM_EASTING	Utm Easting	NUMBER
UTM_NORTHING	Utm Northing	NUMBER
OCS_EASTING	Ocs Easting	NUMBER
OCS_NORTHING	Ocs Northing	NUMBER
WCS_EASTING	Wcs Easting	NUMBER
WCS_NORTHING	Wcs Northing	NUMBER
X_COORD	X Coord	NUMBER	The UTM NAD 83 zone 17 horizontal X co-ordinate of the geometric centroid of the feature location.
Y_COORD	Y Coord	NUMBER	The UTM NAD 83 zone 17 horizontal Y co-ordinate of the geometric centroid of the feature location.
NOTE	Note	VARCHAR2	Descriptive text outlining any problems or to highlight special characteristics of the feature.
GEODETICID	Geodeticid	VARCHAR2
NOTE_LABEL1	Note Label1	VARCHAR2
NOTE_LABEL2	Note Label2	VARCHAR2
NOTE_LABEL3	Note Label3	VARCHAR2
NOTE_LABEL4	Note Label4	VARCHAR2
NOTE_LABEL5	Note Label5	VARCHAR2
ELEVATION_FEET	Elevation Feet	NUMBER
ELEVATION_METRES	Elevation Metres	NUMBER
AVG_DEM_ELE	Avg Dem Ele	NUMBER
ELEVATION_DIFF_M	Elevation Diff M	NUMBER
DEM_COMPARED	Dem Compared	NUMBER
DISCLAIMER	Disclaimer	VARCHAR2
SHAPE	Shape	ST_GEOMETRY	ESRI system maintained field. Stores the geometry type and geometry of the feature.
STREET	Street	VARCHAR2	Street name of the feature based on the STREET MASTER Table.