Describe Inspections Data

The Inspection Data Files available for FTP download are made available in several formats. We are able to offer the files as Fixed Length ASCII Text Files (flat files). The files are updated on a weekly basis. The extract data along with a detailed listing of file names, file contents, file formats, field names, field contents, and coding values for all available data files has been provided below.

Available Files - Current As Of: 01/12/2007

Fixed Length Text Files (Flat Files)

BP150 – Contractor Master File

BP200 – Application Master File

BP400 – Permit Master File

BP500 – Inspection Master File

BP900 – Permit Type Codes
BP910 – Names Master File

BP940 – Inspection Type Codes

BP945 – Inspector ID File

BP960 – Application Type Codes

LMABREP – Address File

LXACREP – Parcel ID File

File Format for Inspections Data Files

BP150			Contractor Master File

Field Name	# of Char	Type	Comments
BPCTNB	7	NUM	Contractor Number
BPCNAM	30	CHAR	Contractor Name
BPC1AD	30	CHAR	Address Line One
BPC2AD	30	CHAR	Address Line Two
BPC3AD	30	CHAR	Address Line Three
BPZIP	9	CHAR	Zip Code
BPCPAC	3	NUM	Phone Area Code
BPCPHN	7	NUM	Phone Number
BPCSTA	1	CHAR	Contractor Status (A=Active, I-Inactive, H=Hold)
BPCTYP	4	CHAR	Contractor Type Code

BP200			Application Master File

Field Name	# of Char	Type	Comments
BPPCB	1	NUM	Application Century
BPPYER	2	NUM	Application Year
BPPCNB	8	NUM	Application Number
BPLCID	9	NUM	Land ID Number
BPATYP	4	CHAR	Application type Code
BPASTS	2	CHAR	Application Status code
BPASDC	1	NUM	Application Status Century
BPASDT	6	NUM	Application Status Date (YYMMDD)
BPADAC	1	NUM	Application Century
BPADAT	6	NUM	Application Date (YYMMDD)
BPAPRB	3	CHAR	Plan Reviewed By
BPEVAL	9	NUM	Project Estimated Value
BPASQF	9	NUM	Application Square Footage

BP400			Permit Master File

Field Name	# of Char	Type	Comments
BPPYER	2	NUM	Application Year
BPPCNB	8	NUM	Application Number
BPSSNO	3	NUM	Structure Number
BPSSSQ	3	NUM	Structure Sequence Number
BPPTCD	4	CHAR	Permit Type Code
BPPPSQ	2	NUM	Permit Sequence Number
BPLCID	9	NUM	Land ID Number
BPPPNO	10	CHAR	Permit Number
BPPSTS	2	CHAR	Permit Status Code
BPPSTC	1	NUM	Permit Status Century
BPPSTD	6	NUM	Permit Status Date
BPPISC	1	NUM	Permit Issue Century
BPPISD	6	NUM	Permit Issue Date
BPPVAL	9	NUM	Permit Valuation
BPPADS	30	CHAR	Permit Additional Description
BPPCOF	1	CHAR	Permit CO Flag
BPPEXC	1	NUM	Permit Expiration Century
BPPEXD	6	NUM	Permit Expiration Date
BPPSQF	9	NUM	Permit Square Footage

BP500			Inspections Master File

Field Name	# of Char	Type	Comments
BPPYER	2	NUM	Application Year
BPPCNB	8	NUM	Application Number
BPSSNO	3	NUM	Structure Number
BPSSSQ	3	NUM	Structure Sequence Number
BPPTCD	4	CHAR	Permit Type Code
BPPPSQ	2	NUM	Permit Sequence Number
BPITYP	4	CHAR	Inspection Type Code
BPISEQ	4	NUM	Inspection Sequence Number
BPLCID	9	NUM	Land ID Number
BPIIID	6	CHAR	Inspector ID Code
BPISTS	2	CHAR	Inspection Status Code
BPISTC	1	NUM	Inspection Status Century
BPISTD	6	NUM	Inspection Status Date (YYMMDD)
BPISCB	1	NUM	Inspection Request Sched Century
BPISCD	6	NUM	Inspection Request Sched Date (YYMMDD)
BPIRBY	3	CHAR	Inspection Requested By
BPIRST	2	CHAR	Inspection Results Status Code
BPIRDC	1	NUM	Inspection Results Century
BPIRDT	6	NUM	Inspection Results Date (YYMMDD)
BPIFIF	1	CHAR	Final Inspection Flag
BPIPTV	3	NUM	Inspection Point Value

BP900			Permit Type Codes

Field Name	# of Char	Type	Comments
BPPTCD	4	CHAR	Permit Type Code
BPPTDS	30	CHAR	Permit Code Description

BP910			Names Master File

Field Name	# of Char	Type	Comments
BPPCB	1	NUM	Application Century
BPPYER	2	NUM	Application Year
BPPCNB	8	NUM	Application Number
BPLCID	9	NUM	Land ID Number
BPNMTP	2	CHAR	Name Type Code
BPNAM	30	CHAR	Name
BPADR1	30	CHAR	Address Line One
BPADR2	30	CHAR	Address Line Two
BPADR3	30	CHAR	Address Line Three
BPNZip	9	CHAR	Zip Code
BPNPAC	3	NUM	Phone Area Code
BPNPHN	7	NUM	Phone Number
BPNCNB	7	NUM	Contractor Number
BPNLAC	1	NUM	Last Activity Century
BPNLAD	6	NUM	Last Activity Date (YYMMDD)
BPNSKY	6	NUM	Structure Number
BPNPTP	4	CHAR	Permit Type Code
BPNPSQ	2	NUM	Permit Sequence Number

BP940			Inspection Type File

Field Name	# of Char	Type	Comments
BPINTP	4	CHAR	Inspection Type Code
BPINDS	30	CHAR	Inspection Code Description

BP945			Inspector ID File

Field Name	# of Char	Type	Comments
BPINID	6	CHAR	Inspector ID Code
BPINND	30	CHAR	Inspector Name/Description
BPINAC	1	CHAR	Inactive Inspector ID Flag

BP960			Application Type Codes File

Field Name	# of Char	Type	Comments

BPATCD	4	CHAR	Application Type Code
BPATDS	45	CHAR	Application Type Description

LMABREP			Address File

Field Name	# of Char	Type	Comments
ABAUCD	9	NUM	Location ID
ABAJCD	9	NUM	Parcel Cross Reference
ABBZCD	5	CHAR	Township code
ABA3CD	3	CHAR	Inspection Area
ABA5CD	6	CHAR	Use Zone
ABAECD	4	CHAR	Street Suffix
ABFXCD	2	CHAR	Post Street Direction
ABACCD	25	CHAR	Street Name
ABABTX	7	NUM	Street Number
ABDFCD	5	CHAR	Street Apartment Number
ABEPCD	5	CHAR