| Layer Name: | Building_Permits |
|---|---|
| # of Features: | 74484 |
| Status: | ACTIVE |
| Layer Source: | GIS_DATA.VL_BUILDING_PERMIT_POINT |
| Layer Quality: | Good |
| Feature Accuracy: | +/- 3m |
| Type: | POLYGON |
| Description: | An extraction of basic building permit information from the AMANDA system joined to the parcel fabric. |
| Projection: | NAD 83 UTM Zone 17N (EPSG 26917) |
| Disclaimer: | The City of Kitchener assumes no responsibility for the accuracy of the provided data. Any use of this information is done so at the users risk. Good survey practices must be applied when utilizing this information. The City of Kitchener and its partners have created this data for information purposes on an as-is and as available basis and is under no circumstances a substitute for a Legal Survey. The City does not make any representations or warranty, express or implied, concerning the accuracy, quality, likely results, or reliability of the use of the data. The City of Kitchener assumes no responsibility for any errors and is not liable for any damages of any kind resulting from the use of, or reliance on, the information and material contained in this layer. All information should be verified independently before being used or relied on. Users are encouraged to contact the City of Kitchener to ensure the accuracy of the information provided by Kitchener. |
| Source Map Label: | Building Permits: Planning - AMANDA (Current) |
|---|---|
| History: | Records available from 1986 forward |
| Original Source: | BUILDING |
| Original Source Process: | Building permit applications are recorded in the AMANDA system. Issuance, conditions, and completion is recorded by various building staff in the AMANDA system. |
| Maintenance: | An Oracle procedure is executed on a daily basis to replace a building permit table in the Corporate Database based on information in the AMANDA system. A virtual layer is setup to join the building permit informortion to the Parcel centroid layer for display. |
| Current Info Source: | Spatial view based on one or more layers and/or tables. |
| Outstanding Issues: | |
| Update Frequency: | DAILY |
| Column Name | Alias | Data Type | Comments | Domain Name | Default value | Domain Values |
|---|---|---|---|---|---|---|
| OBJECTID | OBJECTID | NUMBER | ||||
| PARCELID | Parcelid | NUMBER | ||||
| PERMITNO | Permitno | VARCHAR2 | ||||
| FOLDERRSN | Folderrsn | NUMBER | ||||
| PERMIT_TYPE | Permit Type | VARCHAR2 | ||||
| PERMIT_TYPE_CODE | Permit Type Code | VARCHAR2 | ||||
| ROLL_NO | Roll No | VARCHAR2 | ||||
| FOLDERNAME | Foldername | VARCHAR2 | ||||
| LEGAL_DESCRIPTION | Legal Description | VARCHAR2 | ||||
| PERMIT_STATUS | Permit Status | VARCHAR2 | ||||
| STATUS_CODE | Status Code | VARCHAR2 | ||||
| APPLICATION_DATE | Application Date | DATE | ||||
| ISSUE_DATE | Issue Date | DATE | ||||
| FINAL_DATE | Final Date | DATE | ||||
| EXPIRY_DATE | Expiry Date | DATE | ||||
| ISSUE_YEAR | Issue Year | NUMBER | ||||
| ISSUED_BY | Issued By | VARCHAR2 | ||||
| SUB_WORK_TYPE | Sub Work Type | VARCHAR2 | ||||
| WORK_TYPE | Work Type | VARCHAR2 | ||||
| WORK_CODE | Work Code | NUMBER | ||||
| PERMIT_DESCRIPTION | Permit Description | VARCHAR2 | ||||
| CONSTRUCTION_VALUE | Construction Value | NUMBER | ||||
| TOTAL_UNITS | Total Units | VARCHAR2 | ||||
| UNITS_CREATED | Units Created | VARCHAR2 | ||||
| UNITS_LOST | Units Lost | VARCHAR2 | ||||
| UNITS_NET_CHANGE | Units Net Change | NUMBER | ||||
| REAR_YARD_RQRD | Rear Yard Rqrd | VARCHAR2 | ||||
| LEFT_SIDE_YARD_RQRD | Left Side Yard Rqrd | VARCHAR2 | ||||
| RIGHT_SIDE_YARD_RQRD | Right Side Yard Rqrd | VARCHAR2 | ||||
| SPECIAL_CONDITIONS | Special Conditions | VARCHAR2 | ||||
| OWNERS | Owners | CHAR | ||||
| APPLICANT | Applicant | VARCHAR2 | ||||
| CONTRACTOR | Contractor | VARCHAR2 | ||||
| CONTRACTOR_CONTACT | Contractor Contact | VARCHAR2 | ||||
| EXTRACTION_DATE | Extraction Date | DATE | ||||
| PERMIT_FEE | Permit Fee | NUMBER | ||||
| STATCANGROSSAREA_M2 | Statcangrossarea M2 | VARCHAR2 | ||||
| EXISTING_GFA_M2 | Existing Gfa M2 | VARCHAR2 | ||||
| PROPOSED_GFA | Proposed Gfa | VARCHAR2 | ||||
| TOTAL_GFA_M2 | Total Gfa M2 | VARCHAR2 | ||||
| OCCUPANCY_PERMITTED_DT | Occupancy Permitted Dt | DATE | ||||
| ROWHOUSE_UNITS_CREATED | Rowhouse Units Created | VARCHAR2 | ||||
| STOREYS_PROPOSED | Storeys Proposed | VARCHAR2 | ||||
| GFA_GROUPC_CONSTR_SQFT | Gfa Groupc Constr Sqft | VARCHAR2 | ||||
| NEW_FLOOR_AREA_SQFT | New Floor Area Sqft | VARCHAR2 | ||||
| SHAPE | Shape | ST_GEOMETRY |