| 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. |
|
|
|
| PARCELID |
Parcelid |
VARCHAR2 |
Reference Parcel ID that the feature is located in. The value is either manually entered or generated from a spatial join process. |
|
|
|
| PROPERTY_UNIT |
Property Unit |
NUMBER |
|
|
|
|
| WARDID |
Ward Id |
NUMBER |
Reference Ward that the feature is located in. The value is either manually entered or generated from a spatial join process. |
|
|
|
| PLANNINGCOMMUNITYID |
Planning Community Id |
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. |
|
|
|
| NEIGHBOURHOOD_ASSOCIATIONID |
Neighbourhood Association Id |
NUMBER |
|
|
|
|
| ADDRESS |
Address |
VARCHAR2 |
Street address the feature is located at. Includes both a civic number and a street. |
|
|
|
| APPLICATION_NO |
Application Number |
VARCHAR2 |
|
|
|
|
| STATUS |
Status |
VARCHAR2 |
Indicates the status of feature. A pick list is used for this field - contact GIS for pick list values. |
|
|
|
| APPLICANT |
Applicant |
VARCHAR2 |
|
|
|
|
| PROPERTY_OWNER |
Property Owner |
VARCHAR2 |
|
|
|
|
| FOLDERRSN |
Folder RSN |
NUMBER |
|
|
|
|
| FOLDERYEAR |
Folder Year |
VARCHAR2 |
|
|
|
|
| FOLDERNAME |
Folder Name |
VARCHAR2 |
|
|
|
|
| FOLDERTYPE |
Application Type |
VARCHAR2 |
|
|
|
|
| SUBTYPE |
Application Subtype |
VARCHAR2 |
|
|
|
|
| PRIMARY_PROPERTY |
Primary Property RSN |
NUMBER |
|
|
|
|
| ISSUED_BY |
City Planning Contact |
VARCHAR2 |
|
|
|
|
| DESCRIPTION |
Application Summary |
VARCHAR2 |
|
|
|
|
| COMBINED_APPLICATION |
Combined Application |
VARCHAR2 |
|
|
|
|
| INDATE |
In Date |
TIMESTAMP(6) |
|
|
|
|
| PUBLIC_STATUS_UPDATE |
Status Update |
VARCHAR2 |
|
|
|
|
| PSI_MTG_DATE |
Committee Meeting Date |
VARCHAR2 |
|
|
|
|
| DSD_MTG_DATE |
Committee Meeting Sudivision Date |
VARCHAR2 |
|
|
|
|
| NHBD_MTG_DATE |
Neighbourhood Information Meeting Date |
VARCHAR2 |
|
|
|
|
| NHBD_SA_MTG_DATE |
Neighbourhood Information Meeting Subdivision Date |
VARCHAR2 |
|
|
|
|
| COUNCIL_MEETING_DATE |
Council Meeting Date |
VARCHAR2 |
|
|
|
|
| DRAFT_APPROVAL_DATE |
Subdivision Draft Approval Date |
VARCHAR2 |
|
|
|
|
| REGIONAL_APPROVAL_DATE |
OPA Regional Approval Date |
VARCHAR2 |
|
|
|
|
| REMOVAL_DATE |
Map Removal Date |
VARCHAR2 |
|
|
|
|
| FINAL_DATE |
Final Date |
TIMESTAMP(6) |
|
|
|
|
| HIGHLIGHT_APP |
Highlighted Application |
VARCHAR2 |
|
|
|
|
| EXISTING_OPA_LANDUSE |
Existing OPA Landuse |
VARCHAR2 |
|
|
|
|
| PROPOSED_OPA_LANDUSE |
Proposed OPA Landuse |
VARCHAR2 |
|
|
|
|
| EXISTING_ZONING |
Existing Zoning |
VARCHAR2 |
|
|
|
|
| PROPOSED_ZONING |
Proposed Zoning |
VARCHAR2 |
|
|
|
|
| EXISTING_LANDUSE |
Existing Landuse |
VARCHAR2 |
|
|
|
|
| PROPOSED_LANDUSE |
Proposed Landuse |
VARCHAR2 |
|
|
|
|
| PROP_MAX_RES_UNITS_INCIR |
Proposed Max. Res. Units In Circulation |
VARCHAR2 |
|
|
|
|
| PROP_MAX_RES_UNITS_DA |
Proposed Max. Res. Units Draft Approved |
VARCHAR2 |
|
|
|
|
| PROPOSED_COMMERCIAL_HA |
Proposed Commercial Area (ha) |
VARCHAR2 |
|
|
|
|
| PROPOSED_INSTITUTIONAL_HA |
Proposed Institutional Area (ha) |
VARCHAR2 |
|
|
|
|
| PROPOSED_PARKLAND_HA |
Proposed Parkland Area (ha) |
VARCHAR2 |
|
|
|
|
| PROP_SIZE_HA |
Property Size (Ha) |
VARCHAR2 |
|
|
|
|
| CONTACT_EMAIL |
Contact Email |
VARCHAR2 |
|
|
|
|
| CONTACT_PHONE |
Contact Phone Number |
VARCHAR2 |
|
|
|
|
| CONTACT_TTY |
Contact TTY |
VARCHAR2 |
|
|
|
|
| PUBLIC_STATUS_DESC |
Public Status Description |
VARCHAR2 |
|
|
|
|
| AMANDA_STATUS_DESC |
AMANDA Status Description |
NCLOB |
|
|
|
|
| IMAGE_DESCR |
Status Image Description |
NCLOB |
|
|
|
|
| IMAGE_LINK |
Status Weblink |
NCLOB |
|
|
|
|
| THUMBNAIL_LINK |
Thumbnail Weblink |
VARCHAR2 |
|
|
|
|
| SORTID |
Sorting Id |
VARCHAR2 |
|
|
|
|
| SHAPE |
SHAPE |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|
