Building Inspections - Existing Structures Dataset

Overview and distributions for this dataset

Overview

Includes building inspections that have had complaints lodged against them. Includes results from violation letters to structural condemnations

87/88 inspections
API/Web Service Get all and search through 87/88 inspections
Building inspections, condemnations, and vacant buildings
Access Database Access database including building inspections, condemnations, and vacant building records (due to recent system upgrades, some recent data may be missing)
Existing Structure Inspections
API/Web Service JSON Endpoint
Get all inspections
API/Web Service Search all inspections with various filtering options
Get inspection types
API/Web Service Get a list of the inspection types that are recorded within the sytem

Provided by: Building Commissioner
Related topics: Permits, Inspections, and Certifications Construction, Maintenance, and Improvements
Tags: asset-parcel inspections property address property owner
Metadata added: 8/29/18
Metadata last updated: 3/1/21
Data last updated: See distribution
Data.json metadata: View metadata

Name	Label	Data Type
ADDR_Handle	Project Handle	String
ADDR_LocationX	Project X	String
ADDR_LocationY	Project Y	String
ADDR_Neighborhood	Neighborhood Name	String
ADDR_NeighborhoodNumber	Neighborhood Number	String
ADDR_NeighborhoodNumber	Project Neighborhood	String
ADDR_ParcelID	Project Parcel ID	String
ADDR_Ward	Project Ward	String
AKAAddress	Project AKA Address	String
AnswerNames	Violation Answer	String
CNTP_Name (HCIN_FK_CNTP_ID)	Construction	String
CurrentResult (HCRS_ID)	Violation Resolution	String
HCAA_OwnerAddress	Owner Address	String
HCAA_OwnerCity	Owner City	String
HCAA_OwnerName	Owner Name	String
HCAA_OwnerZip	Owner Zip Code	String
HCAA_ProjectAddress	Project Address	String
HCAA_ProjectCity	Project City	String
HCAA_ProjectZipCode	Project Zip Code	String
HCAA_UnitNumber	Unit Number	String
HCIN_GeneralNotes	General Notes	String
HCIN_NumberOfStories	# of Stories	String
HCIN_NumberOfUnits	# of Units	String
HCIN_OccupancyLimit	Occupancy Limit Number	String
HCIR_InspectorNotes	Violation Inspector Notes	String
HCIS_Name (HCIR_FK_HCIS_ID)	Violation Severity	String
HCLO_Name (HCLO_ID)	Violation Location	String
HCOI_COI_Number	COI Number	String
HCOI_DateIssued	COI Issue Date	String
HCRA_Name (HCIN_FK_HCRA_ID_Current)	Current Result	String
HCTM_LetterText	Violation Text	String
HCTM_Name (HCTM_ID)	Violation Item	String
HCTY_Name (HCTY_ID)	Violation Type	String
Inspector	Inspector Name	String
INTY_Name (HCIN_FK_INTY_ID)	Inspection Type	String
OwnerState	Owner State	String
ProjectState	Project State	String
USCD_Name (HCIN_FK_USCD_ID)	Use Code	String

Feedback is anonymous.