| 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. |
|
|
|
| PARKID |
Parkid |
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. |
|
|
|
| PARK |
Park |
VARCHAR2 |
Name of the park |
|
|
|
| CATEGORY |
Category |
VARCHAR2 |
Park categories from the park master plan form community services |
ParkCategory |
OPEN SPACE |
CITY WIDE PARK; GREEN (COMMONS); GREEN (PARKETTE); GREEN (URBAN PLAZA); GREENWAY; NATURAL AREA; NEIGHBOURHOOD PARK; OPEN SPACE; OTHER; UNKNOWN ...See GIS for a complete list... |
| SUBCATEGORY |
Subcategory |
VARCHAR2 |
Park subcategories from the park master plan form community services |
ParkSubcategory |
|
FACILITY PROPERTY; OPEN SPACE/WETLAND; OPEN SPACE/WOODLAND; OS-PLANTING STRIP/LANDSCAPE BUFFER; PARK; PASSIVE AREA; PLAY AREA; PLAY AREA-LIMITED ACCESS; PUMPING STATION; UNKNOWN ...See GIS for a complete list... |
| MAP_CLASS |
Map Class |
VARCHAR2 |
Park classification used for GIS mapping |
ParkMapClass |
|
LOCAL; MAJOR; MINOR; UNKNOWN |
| MAP_TEXT_ROTATION |
Map Text Rotation |
NUMBER |
Rotation for placing text in mapping documents |
|
|
|
| MAPLABEL1 |
Maplabel1 |
VARCHAR2 |
Label used for mapping |
|
|
|
| MAPLABEL2 |
Maplabel2 |
VARCHAR2 |
Label used for mapping |
|
|
|
| MAPLABEL3 |
Maplabel3 |
VARCHAR2 |
Label used for mapping |
|
|
|
| MANAGEMENT |
Management |
VARCHAR2 |
Who manages the Park, Generally Government agenciessuch as CITY, REGION and MTO and private citizens and businesses shown as PUBLIC |
ParkManagement |
KITCHENER |
FEDERAL GOVERNMENT; GRCA; KITCHENER; PROVINCE OF ONTARIO; REGION; UNKNOWN |
| PROPERTYUNITID |
Propertyunitid |
NUMBER |
Reference Address ID (Property_unit) that the feature is addresses to. The value is either manually entered or generated from a spatial join process |
|
|
|
| STREET |
Street |
VARCHAR2 |
Street name of the feature based on the STREET MASTER Table. |
|
|
|
| CIVIC_NO |
Civic No |
VARCHAR2 |
Integer value. Civic address of the feature. |
|
|
|
| GENERAL_GRID |
General Grid |
NUMBER |
Reference number of the mapping Grid the park is in. This is used for creating atlases. |
GridStandardID |
|
|
| WARDID |
Wardid |
NUMBER |
Reference Ward that the feature is located in. The value is either manually entered or generated from a spatial join process. |
WardCodedValues |
|
|
| 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. |
PlanningCommunityID |
|
Bridgeport North (48); City Commercial Core (1); Heritage Park (23); Laurentian West (28); Mill Courtland Woodside Park (5); Northward (12); Rosemount (22); Rosenberg (54); Southdale (17); Vanier (25) ...See GIS for a complete list... |
| MUNICIPAL_FACILITY |
Municipal Facility |
VARCHAR2 |
If the feature is maintained by the City of Kitchener it is determined to be a Municipal facility. |
YesNo |
Y |
N - NO; U - UNKNOWN; Y - YES |
| ON_CALL |
On Call |
VARCHAR2 |
If the feature is part of the On-Call system at the City of Kitchener |
YesNo |
N |
N - NO; U - UNKNOWN; Y - YES |
| DIVISION_RESPONSIBLE |
Division Responsible |
VARCHAR2 |
Asset Lead: The division at the City of Kitchener responsible for the asset financially. |
ParkDivisionResponsible |
OPERATIONS |
ENGINEERING; NON-CITY; OPERATIONS; UNKNOWN |
| 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. |
OwnershipPark |
KITCHENER |
FEDERAL GOVERNMENT; KITCHENER/HYDRO; KITCHENER/PRIVATE; KITCHENER/REGION; PRIVATE; PROVINCE OF ONTARIO; REGION; REGION/HYDRO; SCHOOL BOARD; UNKNOWN ...See GIS for a complete list... |
| ASSOCIATED_LAND_AREA |
Associated Land Area |
VARCHAR2 |
Area (generally in m2) of the land associated with the feature. |
|
|
|
| CONSTRUCTION_YEAR |
Construction Year |
VARCHAR2 |
Estimate of the feature''s construction year |
|
|
|
| LOCATION_DESCRIPTION |
Location Description |
VARCHAR2 |
Open text field that describes the location of the feature. |
|
|
|
| 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 |
|
|
|
| STATUS |
Status |
VARCHAR2 |
Indicates the status of feature. A pick list is used for this field - contact GIS for pick list values. |
RoadStatus |
REGISTERED |
ACTIVE; CLOSED; PLANNED; PRELIMINARY; REGISTERED; TO INPUT; UNKNOWN |
| STATUS_DATE |
Status Date |
DATE |
Database maintained field. Updates to the current date/time when the STATUS field value is changed. |
|
|
|
| NOTES |
Notes |
VARCHAR2 |
Descriptive text outlining any problems or to highlight special characteristics of the feature. |
|
|
|
| TAG1 |
Tag1 |
VARCHAR2 |
Temporary location to store short term data for mapping purposes only. |
|
|
|
| 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. |
|
|
|
| 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. |
|
|
|
| SHAPE |
SHAPE |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|
| PARKBOUNDARYID |
Parkboundaryid |
NUMBER |
|
|
|
|
| PARK_BOUNDARY_NAME |
Park Boundary Name |
VARCHAR2 |
|
|
|
|
| CATEGORY_OPERATIONS |
Operations Category (Marks Parks) |
VARCHAR2 |
|
ParkCategoryOperations |
|
ACTIVE; CITY; COMMUNITY; LEGACY; NATURAL; NEIGHBOURHOOD; NOT APPLICABLE; PASSIVE; UTILITY |
