| 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. |
|
|
|
| ACTIVETRANSPORTID |
Activetransportid |
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. |
|
|
|
| STATUS |
Status |
VARCHAR2 |
Indicates the status of feature. A pick list is used for this field - contact GIS for pick list values. |
AtStatus |
ACTIVE |
ACTIVE; CLOSED; PLANNED; POTENTIAL; UNDESIGNATED |
| STATUS_DATE |
Status Date |
TIMESTAMP(6) |
Database maintained field. Updates to the current date/time when the STATUS field value is changed. |
|
|
|
| CATEGORY |
Category |
VARCHAR2 |
Identifies the major branches of Active Transportation modes. |
AtType |
SIDEWALKS AND WALKWAYS |
CYCLING; MAINTENANCE ACCESS; NETWORK LINKS; PATHWAYS; SIDEWALKS AND WALKWAYS |
| SUBCATEGORY |
Subcategory |
VARCHAR2 |
Identifies a further breakdown of the major branches of Active Transportation modes. |
AtSubcategory |
SIDEWALK |
BICYCLE LANE; COMBINED CROSSRIDE; CONTINUOUS SIDEWALK; CYCLE TRACK; MIXED CROSSRIDE; RAISED TRAIL CROSSING; SANITARY AND STORMWATER UTILITIES; SINGLE TRACK; TRAIL CROSSING; TRANSITION TO BMUT ...See GIS for a complete list... |
| TRAIL_MASTER_PLAN_CLASS |
Trail Master Plan Class |
VARCHAR2 |
same as CTMP_FACILITY_TYPE |
AtTrailMasterPlanClass |
|
CTMP; CTMP ABANDONED; CTMP COMPLETED AS PROPOSED; CTMP COMPLETED DIFFERENTLY; CTMP EXISTING; CTMP PROPOSED NEW; CTMP PROPOSED UPGRADE; OTHER; UNKNOWN |
| FEATURE_TYPE |
Feature Type |
VARCHAR2 |
Quickly shows locations of bridges and other non-standard asset types. Can also be used to query out features when mapping vertical relationships between features. |
AtFeatureType |
SURFACE |
BOARDWALK; BRIDGE; NA (VIRTUAL LINK); OVERPASS; STAIRS; SURFACE; UNDERPASS; UNKNOWN |
| SURFACE_MATERIAL |
Surface Material |
VARCHAR2 |
Identifies the type of surface material of the asset. |
AtSurfaceMaterial |
CONCRETE |
ASPHALT; GRAVEL; NA (VIRTUAL LINK); NATURAL; STEEL; STONE; STONEDUST; TAR AND CHIP; UNKNOWN; WOOD ...See GIS for a complete list... |
| ROUTE_NAME_1 |
Route Name 1 |
VARCHAR2 |
Gives name of route |
AtRouteName1 |
|
CENTRAL STATION TRAIL; DOON CREEK TRAIL; DOON SOUTH HYDRO CORRIDOR TRAIL; EVAN'S POND TRAIL; EVENSTONE TRAIL; GROH TRAIL; STAUFFER TRAIL; STAUFFER WOODS TRAIL; TARTAN WOODS TRAIL; TILT TRAIL ...See GIS for a complete list... |
| ROUTE_NAME_2 |
Route Name 2 |
VARCHAR2 |
Gives alternate name of route, i.e. if two routes share a facility before diverging again. |
AtRouteName2 |
|
BOARDWALK - BRESLAU; CONESTOGA COLLEGE DOON - BOARDWALK; DOWNTOWN - FAIRWAY - TRILLIUM; DOWNTOWN - STANLEY PARK; FOREST HEIGHTS - DOWNTOWN; MANNHEIM - DOWNTOWN; MANNHEIM - FAIRWAY - STANLEY PARK; NONE; SPORTSWORLD - STANLEY PARK - WATERLOO; TRANS CANADA TRAIL |
| ROUTE_NAME_PROPOSED |
Route Name Proposed |
VARCHAR2 |
Identifies potential named route |
|
|
|
| WIDTH_M |
Width M |
NUMBER |
Gives width of facility in metres default width 1.8m |
AtWidth |
1.5 |
0; 10; 12; 6.5; 7; 7.5; 8; 8.5; 9; 9.5 ...See GIS for a complete list... |
| GRADE |
Grade |
VARCHAR2 |
Indentifies maximum slope present along facility as calculated through a script |
AtGrade |
|
EXTREME; FLAT; MODERATE; NONE; STEEP; UNKNOWN |
| RAILING |
Railing |
VARCHAR2 |
Indicates presence of railing along the segment |
YesNoOnly |
N |
No; Yes |
| CURBCUT |
Curbcut |
VARCHAR2 |
Indicates whether the facility is a curbcut down to street level |
YesNo |
N |
N - NO; U - UNKNOWN; Y - YES |
| STREET |
Street |
VARCHAR2 |
Street name of the feature based on the STREET MASTER Table. |
|
|
|
| ROADSEGMENTID |
Roadsegmentid |
NUMBER |
ID of the Road the feature is on if applicable |
|
|
|
| ROADSEGMENT_SIDE |
Roadsegment Side |
VARCHAR2 |
Side of the road the feature is on if applicable |
AtSide |
NA |
LEFT; NA; RIGHT; UNKNOWN |
| PARCELID |
Parcelid |
NUMBER |
Reference Parcel ID that the feature is located in. The value is either manually entered or generated from a spatial join process. |
|
|
|
| WARD |
Ward |
NUMBER |
Reference Ward that the feature is located in. The value is either manually entered or generated from a spatial join process. |
WardCodedValues |
|
|
| 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 |
TIMESTAMP(6) |
GIS maintained field. Date of the source document or information. |
|
|
|
| NOTES |
Notes |
VARCHAR2 |
Descriptive text outlining any problems or to highlight special characteristics of the feature. |
|
|
|
| OWNERSHIP |
Ownership |
VARCHAR2 |
Asset Owner: Who owns the feature, Generally Government agencies such as CITY, REGION and MTO and private citizens and businesses shown as PUBLIC. This usually relates to the property the asset sits on. |
AtOwnership |
KITCHENER |
GRCA; HYDRO; KITCHENER; PRIVATE; PROVINCE; REGION; UNKNOWN; WATERLOO; WCDSB; WRDSB |
| MAINTAINED_BY |
Maintained By |
VARCHAR2 |
Asset Steward: The division at the City of Kitchener that is the custodian/caretaker of the asset. This is the City department or Non-City group that maintains an asset. |
AtMaintainedBy |
|
CEMETERY; NA; OPERATIONS (ROADS); OPERATIONS (TURF); PRIVATE; REGION; SSU; UNKNOWN; WCDSB; WRDSB ...See GIS for a complete list... |
| INSTALLATION_YEAR |
Installation Year |
NUMBER |
Year the asset was installed. Usually a database maintained field. |
|
|
|
| LAST_INSPECTION_YEAR |
Last Inspection Year |
VARCHAR2 |
Last year feature was inspected through the sidewalker inspection program in Engineering or Operations trail inspections |
|
|
|
| SURFACE_CONDITION |
Surface Condition |
VARCHAR2 |
Surface condition as found in the 2015 Trail inventory project |
AtSurfaceCondition |
GOOD |
FAIR; GOOD; POOR; UNKNOWN; UNUSABLE |
| CONDITION_DATE |
Condition Date |
TIMESTAMP(6) |
Date of alculated condition score from Cityworks |
|
|
|
| CONDITION_SCORE |
Condition Score |
NUMBER |
Calculated condition score from Cityworks |
|
|
|
| SW_WEIGHT_CLASS |
Sw Weight Class |
VARCHAR2 |
Sidewalk weight class as determined by |
|
|
|
| SW_PRIORITY |
Sw Priority |
NUMBER |
|
|
|
|
| PN_PROJECT_NO |
Pn Project No |
VARCHAR2 |
|
|
|
|
| PN_MAP_CLASS |
Pn Map Class |
VARCHAR2 |
|
|
|
|
| PN_OFFICIAL_PLAN_MAP |
Pn Official Plan Map |
VARCHAR2 |
|
|
|
|
| PN_REGION_CATEGORY |
Pn Region Category |
VARCHAR2 |
|
|
|
|
| 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 |
TIMESTAMP(6) |
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 |
TIMESTAMP(6) |
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. |
|
|
|
| SHAPE |
SHAPE |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|
| CW_WORK_AREA |
Cw Work Area |
VARCHAR2 |
Work areas used in Cityworks to assign work. Currently it is set to the plow route areas |
CityworksWorkAreaPlow |
|
11-2; 12-2; 2-1; 2-2; 3-1; 5-1; 5-2; 7-2; 8-1; UNKNOWN ...See GIS for a complete list... |
| WAYFINDING |
Wayfinding |
VARCHAR2 |
|
YesNoOnly |
N |
No; Yes |
| WINTER_MAINTENANCE |
Winter Maintenance |
VARCHAR2 |
Is the section winter maintained |
AtWinterMaintenance |
NONE |
LOAD; NA; NONE; PLOW |
| PLOW_OFF_ROAD |
Plow Off Road |
NUMBER |
|
|
|
|
| PLOW_DESC_NUM |
Plow Desc Num |
NUMBER |
|
|
|
|
| WINTER_MAINTAINED_BY |
Winter Maintained By |
VARCHAR2 |
What section performs winter maintenance if it is done |
AtMaintainedBy |
|
CEMETERY; NA; OPERATIONS (ROADS); OPERATIONS (TURF); PRIVATE; REGION; SSU; UNKNOWN; WCDSB; WRDSB ...See GIS for a complete list... |
| SIDEWALKER_PROGRAM |
Is sidewalk part of the Sidewalker Program |
VARCHAR2 |
Is the segment part of the current year's sidewalk inspection program completed by engineering. Segments may be excluded due to construction in the area or sidewalk is stll under a developer warrenty |
YesNoOnly |
N |
No; Yes |
| UPGRADE_YEAR |
UPGRADE_YEAR |
NUMBER |
|
|
|
|
| FACILITY_TYPE |
CTMP_FACILITY_TYPE |
VARCHAR2 |
|
AtCtmpFacilityType |
NA |
AAA; CONSTRAINED CORRIDOR; NA; SUPPORTING; UNKNOWN |
| SOC_AAA |
Largest AAA network |
VARCHAR2 |
|
|
|
|
| SOC_SUP |
Largest supporting network |
VARCHAR2 |
|
|
|
|
| SLOPE_GRADIENT_PERCENT |
SLOPE_GRADIENT_PERCENT |
NUMBER |
|
|
|
|
| SLOPE_GRADIENT_CLASS |
SLOPE_GRADIENT_CLASS |
VARCHAR2 |
|
|
|
|
| SLOPE_GRADIENT_SOURCE |
SLOPE_GRADIENT_SOURCE |
VARCHAR2 |
|
|
|
|
| SLOPE_GRADIENT_MAX |
SLOPE_GRADIENT_MAX |
NUMBER |
|
|
|
|
| SLOPE_GRADIENT_MIN |
SLOPE_GRADIENT_MIN |
NUMBER |
|
|
|
|
| SLOPE_GRADIENT_AVG |
SLOPE_GRADIENT_AVG |
NUMBER |
|
|
|
|
| GRADE_CATEGORY_MAX |
GRADE_CATEGORY_MAX |
VARCHAR2 |
|
|
|
|
| PATHWAYS_MAINTENANCE |
PATHWAYS_MAINTENANCE |
VARCHAR2 |
|
YesNoOnly |
N |
No; Yes |
| PATHWAYS_MAINT_AREA |
PATHWAYS_MAINT_AREA |
NUMBER |
|
|
|
|
