Building_Permits Building_Permits
Logo

Corporate Production GIS Metadata

Layer Name: Building_Permits

General Information

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 and Contraints

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

Data Fields & Domain Information

Building_Permits

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