| 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. |
|
|
|
| BUILDINGID |
Buildingid |
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. |
|
|
|
| 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. |
|
|
|
| STATUS |
Status |
VARCHAR2 |
Indicates the status of feature. A pick list is used for this field - contact GIS for pick list values. |
BuildingStatus |
|
ACTIVE; APPROVED SITE PLAN; CONCEPT PLAN; PERMIT ISSUED |
| STATUS_DATE |
Status Date |
DATE |
Database maintained field. Updates to the current date/time when the STATUS field value is changed. |
|
|
|
| BUILDING |
Building |
NVARCHAR2 |
Last known building name |
|
|
|
| CATEGORY |
Category |
VARCHAR2 |
Primary mapping field of the layer. Valid category values are:AGRICULTURE,APARTMENT,COMMERCIAL,COMMERCIAL INDUSTRIAL,CONDOMINIUM,GARAGE,INDUSTRIAL,INSTITUTIONAL,MISCELANEOUS,MULTIRESIDENTIAL,SEMI DETACHED,SHED,SINGLE HOMES,TOWNHOUSE,UTILITY |
BuildingCategory |
|
AGRICULTURAL; COMMERCIAL; COMMERCIAL RESIDENTIAL; INDUSTRIAL; INSTITUTIONAL; RECREATIONAL; RESIDENTIAL; UTILITY |
| SUBCATEGORY |
Subcategory |
VARCHAR2 |
Secondary mapping field of the layer.Valid subcategory values are:COMMUNITY RESOURCE,EDUCATION FACILITY,EMERGENCY SERVICE,GOVERNMENT SERVICE,OTHER,PLACE OF WORSHIP,POINT OF INTEREST,UNDERGROUND |
BuildingSubCategory |
|
ADU; OTHER; POINT OF INTEREST; RECREATIONAL; SHED; SHELTER; SINGLE/SEMI/DUPLEX; TOWNHOUSE; UNDERGROUND; UTILITY ...See GIS for a complete list... |
| 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. |
|
|
|
| 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. |
|
|
|
| TAG2 |
Tag2 |
VARCHAR2 |
Temporary location to store short term data for mapping purposes only. |
|
|
|
| TAG3 |
Tag3 |
VARCHAR2 |
Temporary location to store short term data for mapping purposes only. |
|
|
|
| UNITS |
Units |
NUMBER |
Estimated number of units in the building |
|
|
|
| STORIES |
Stories |
NUMBER |
Estimated or know building number of stories |
|
-1 |
|
| MUNICIPALITY |
Municipality |
VARCHAR2 |
Municipality that the feature is in. The value is either manually entered or generated from a spatial join process. |
|
KITCHENER |
|
| SHAPE |
Shape |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|
| LOCATION |
Location |
VARCHAR2 |
Open text field that describes the location of the feature in more detail. |
|
|
|
| YEAR_BUILT |
Year Built |
VARCHAR2 |
Year the building was built |
|
|
|
| YEAR_BUILT_DESC |
Year Built Desc |
VARCHAR2 |
Quality of the year built date as either CONFIRMED, ESTIMATED or MPAC. Data tagged as MPAC comes from SAS.ASMT_CC.YR_BUILT through a trigger on MAIN_PROPERTYUNITID. City building year built is from Operations |
BuildingYearBuilt |
|
CONFIRMED; ESTIMATED |
| MAJOR_MINOR |
Major or Minor based on building size |
VARCHAR2 |
Buildings over 500sq m are considered MAJOR all other MINOR. This was originally put in for PSAB purposes |
|
|
|
| MAIN_PROPERTYUNITID |
Main Propertyunitid |
NUMBER |
Main address of a building. Generally it is the base address without units and contains the mail roll number for the property |
|
|
|
| PSAB |
Include in PSAB reporting |
VARCHAR2 |
If the building is exported to PSAB |
YesNoOnly |
N |
No; Yes |
| FIRE_PRIORITY |
Fire Priority |
VARCHAR2 |
Priority rating of either 0 or 1 with priority buildings given a 1 |
|
0 |
|
| FIRE_HAZARD |
Fire Hazard |
VARCHAR2 |
Fire hazard rating from 0 to 4 |
|
0 |
|
| CITY_FACILITY |
City Facility |
VARCHAR2 |
If the building is considered a city facility in Cityworks |
YesNo |
N |
N - NO; U - UNKNOWN; Y - YES |
| YEAR_RENOVATED |
Year Renovated |
VARCHAR2 |
Year the building had a major renovated |
|
|
|
| YEAR_RENOVATED_DESC |
Year Renovated Desc |
VARCHAR2 |
Decription of quality of the YEAR_RENOVATED data. City owned building the data came from Operations |
|
|
|
| GROSS_FLOOR_AREA_M2 |
Gross Floor Area M2 |
NUMBER |
|
|
|
|
| BUILDING_3M_ROW |
Building is within 3m of right of way |
VARCHAR2 |
Parcels that have a CATEGORY field value of ROW are what are used to calculate if the building is within 3.01 metres. |
YesNoOnly |
N |
No; Yes |
| MPAC_LAND_USE |
MPAC_LAND_USE |
VARCHAR2 |
|
MPACLandUseDescription |
|
120 - Water lot (entirely under water); 233 - Large scale swine operation; 364 - House-keeping cottages - less than 50% American plan; 410 - Retail - one storey, generally under 10,000 s.f.; 462 - Country inns & small inns; 496 - Communication buildings; 602 - Multiple occupancy educational institutional residence located on or off campus; 720 - Commercial sport complex; 721 - Non-commercial sports complex; 750 - Scientific, pharmaceutical, medical research facility (structures predominantly other than office) ...See GIS for a complete list... |
| OCCUPANCY_TYPE |
OCCUPANCY_TYPE |
VARCHAR2 |
|
|
|
|