| 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. |
|
|
|
| STREET |
Street |
VARCHAR2 |
Street name of the feature based on the STREET MASTER Table. |
|
|
|
| LAND_USE |
Land Use |
VARCHAR2 |
|
|
|
|
| GENERAL_GRID |
General Grid |
NUMBER |
|
|
|
|
| LANDMARKID |
Landmarkid |
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. |
|
|
|
| MUNICIPALITY |
Municipality |
VARCHAR2 |
Municipality that the feature is in. The value is either manually entered or generated from a spatial join process. |
|
|
|
| MUNICIPAL_FACILITY |
Municipal Facility |
VARCHAR2 |
If the feature is maintained by the City of Kitchener it is determined to be a Municipal facility. |
|
|
|
| CREATE_DATE |
Create Date |
DATE |
Database maintained field. Updates to the current data/time. Update takes place when the feature is created. |
|
|
|
| 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. |
|
|
|
| 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. |
|
|
|
| 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. |
|
|
|
| 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. |
|
|
|
| CATEGORY |
Category |
VARCHAR2 |
Primary mapping field of the layer. Valid category values are:BALL DIAMOND,BASKETBALL,BUSINESS PARK,CEMETERY,CHILD CARE FACILITY,CLUB AND ASSOCIATION,COMMUNITY RESOURCE,EDUCATION FACILITY,EMERGENCY SERVICE,GOLF COURSE,GOVERNMENT SERVICE,INDUSTRIAL ARTIFACT,LIBRARY,MISC,OPERATIONS CENTRE,PARK,PARKING FACILITY,PLACE OF WORSHIP,PLAYGROUND,POINT OF INTEREST,PUMPING STATION,SENIOR CARE FACILITY,SOCCER,SPORTS ARENA,SPORTS CENTRE,SPORTS MISC,SPORTS POOL,SPORTS TENNIS |
|
|
|
| SUBCATEGORY |
Subcategory |
VARCHAR2 |
Secondary mapping field of the layer.Valid subcategory values are:ACCOMMODATION,AIRFIELD,AMBULANCE STATION,ARENA,ARTIFACT,ASSISTED LIVING,BALL DIAMOND,BALL DIAMOND ,BANKS,BASKETBALL COURT,BIKE PARK,BUS TERMINAL,CHILD CARE,CHURCH,CITY WIDE PARK,CLINIC,CLUB HOUSE,CLUBS AND ASSOCIATIONS,COMMUNITY LIBRARY,COMMUNITY RESOURCE CENTRE,COURT HOUSE,CRICKET,CURLING,DISTRICT PARK,ENTERTAINMENT,FESTHALLS,FIELD HOUSE,FIRE STATION,FRISBEE,GOVERNMENT OFFICE,GOVERNMENT SERVICE,GREEN,GREEN (COMMONS),GREEN (PARKETTE),GREEN (URBAN PLAZA),GREENWAY,GYMNASTICS/JUDO CENTRE,HOSPITAL,INDOOR POOL,LAWN BOWLING,MAIN LIBRARY,MAINTENANCE FACILITY,MARKET,MISC,MOSQUE,MULTI-PURPOSE PAD,MULTIUSE CENTRE,MUSEUM,NATURAL AREA,NEIGHBOURHOOD PARK,NURSING HOME,OPEN SPACE,OPERATIONS CENTRE,OTHER,OUTDOOR POOL,OUTDOOR RINK,PARKING,PARKING LOT,PAVILION,PHARMACY,PLAYGROUND,POLICE STATION,PRISON,PRIVATE CAREER COLLEGE,PRIVATE SCHOOL,PUBLIC ART,PUBLIC COLLEGE,PUBLIC SCHOOL,PUBLIC UNIVERSITY,RAILWAY STATION,RECREATION COMPLEX,RETIREMENT HOME,RETIRMENT HOME,SCHOOL BOARD OFFICE,SEPARATE SCHOOL,SHOPPING,SHUFFLEBOARD COURT,SKATEBOARD PARK,SOCCER FIELD,SOCIAL SERVICE,SPLASH PAD,STADIUM,SYNAGOGUE,TEMPLE,THEATRE,TOBOGGAN HILL,TOURIST,TRACK AND FIELD,VOLLEYBALL COURT,WATER TREATMENT |
|
|
|
| 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. |
|
|
|
| LANDMARK |
Landmark |
VARCHAR2 |
Name of the landmark feature |
|
|
|
| CIVIC_NO |
Civic No |
NUMBER |
Integer value. Civic address of the feature. |
|
|
|
| UNIT_NO |
Unit No |
VARCHAR2 |
Address unit of feature. |
|
|
|
| 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. |
|
|
|
| WARDID |
Wardid |
NUMBER |
Reference Ward that the feature is located in. The value is either manually entered or generated from a spatial join process. |
|
|
|
| PLANNINGCOMMUNITYID |
Planningcommunityid |
NUMBER |
GIS maintained field. Reference Planning Community that the feature is located in. The value is either manually entered or generated from a spatial join process. |
|
|
|
| MAPLABEL1 |
Maplabel1 |
VARCHAR2 |
|
|
|
|
| MAPLABEL2 |
Maplabel2 |
VARCHAR2 |
|
|
|
|
| MAPLABEL3 |
Maplabel3 |
VARCHAR2 |
|
|
|
|
| SUBSUBCATEGORY |
Subsubcategory |
VARCHAR2 |
|
|
|
|
| ON_CALL |
On Call |
VARCHAR2 |
If the feature is part of the On-Call system at the City of Kitchener |
|
|
|
| DIVISION_RESPONSIBLE |
Division Responsible |
VARCHAR2 |
Asset Lead: The division at the City of Kitchener responsible for the asset financially. |
|
|
|
| BUILDINGID |
Buildingid |
NUMBER |
Reference Building ID that the feature is located in. The value is either manually entered or generated from a spatial join process. |
|
|
|
| LOCATION_DESCRIPTION |
Location Description |
VARCHAR2 |
Open text field that describes the location of the feature. |
|
|
|
| CONSTRUCTION_YEAR |
Construction Year |
VARCHAR2 |
Estimate of the feature''s construction year |
|
|
|
| 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. |
|
|
|
| COMMON_LOCATION_REFERENCE |
Common Location Reference |
VARCHAR2 |
Location of the feature often using FM city sites as the source, it is generally populated by a spatial trigger |
|
|
|
| ASSOCIATED_LAND_AREA |
Associated Land Area |
NUMBER |
Area (generally in m2) of the land associated with the feature. |
|
|
|
| STATUS |
Status |
VARCHAR2 |
Indicates the status of feature. A pick list is used for this field - contact GIS for pick list values. |
|
|
|
| IMPORT_DATE |
Import Date |
DATE |
|
|
|
|
| SHAPE |
Shape |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|
| HYPERLINK |
WEBSITE |
VARCHAR2 |
|
|
|
|
| STATUS_DATE |
Status Date |
TIMESTAMP(6) |
Database maintained field. Updates to the current date/time when the STATUS field value is changed. |
|
|
|
| MAP_LABEL |
MAP_LABEL |
VARCHAR2 |
|
|
|
|
