Data Dictionary

Data Element Section Master Field Name Description Type Sub Type Example Data Type
DDL-01 Applicant Details Applicant Full Name Full name of the Applicant applicant_details applicant_name David White string
DDL-02 Applicant Details Applicant Organization Organization the applicant is associated with applicant_details applicant_organization HASSLER HEATING & AIR CONDITIONING string
DDL-03 Applicant Details Applicant Phone Applicant Phone Number applicant_details applicant_phone (510)848-3030 string
DDL-04 Applicant Details Applicant Address Applicant Address applicant_details applicant_address 1537 S 56TH ST EL CERRITO,, CA,, 94530-2107 string
DDL-05 Building Location Job Street Address Property address associated with the permit address_details street PARK HILLS RD string
DDL-06 Building Location Job City City of the property associated with the permit address_details city BERKELEY string
DDL-07 Building Location Job State State of the property associated with the permit address_details state CA string
DDL-08 Building Location Job Zip Zip of the property associated with the permit address_details zip 94708 string
DDL-09 Building Location Latitude The Latitude of the property's primary address address_details latitude 34.23322133 float
DDL-10 Building Location Longitude The Longitude of the property's primary address address_details longitude -96.76261827 float
DDL-11 Building Permits Permit Type Raw values indicating type of permit in abbreviated format permit_details permit_type Building Addition string
DDL-12 Building Permits Permit Sub-Type Sub Type of the permit permit_details permit_sub_type Single Family Attached string
DDL-13 Building Permits Master Permit Number If the permit is listed as the child of another permit, this is the Project ID of that parent permit. A building permit's (BP) master permit number will reference the Plan Review Project ID, while trades under that BP will reference the BP's ID as their master. This may also be called the "parent folderRSN" permit_details master_permit_number B2016-01442 string
DDL-14 Building Permits Permit # Permit number for the scheduled work permit_details permit_number B2016-01442 string
DDL-15 Building Permits Permit Class Indicates if the permit is intended for Residential or Commercial. This mapping is derived from the PermitClass field (if the Class starts with "R", it is residential, otherwise it is commercial) permit_details permit_class Residential string
DDL-16 Building Permits Work Description Detailed description of work permitted permit_details work_description ATTIC INSULATION, HEATING FURNACE AND DUCT REPLACEMENT, NEW DEDICATED LIGHT SWITCH AND GFCI IN FURNACE ROOM string
DDL-17 Building Permits Permit Applied Date Date on which the permit was applied, This relates to the original Plan Review application submission where applicable permit_details permit_applied_date 2016-04-01 string
DDL-18 Building Permits Permit Issue Date Date on which the permit was issued permit_details permit_issued_date 2016-04-01 string
DDL-19 Building Permits Permit Category Category to which the applied permit is classified permit_details permit_category Building Permit string
DDL-20 Building Permits Permit Status Current Current status of permit permit_details permit_status Closed string
DDL-21 Building Permits Status Date Date on which the permit status was reported permit_details permit_status_date 2016-07-08 string
DDL-22 Building Permits Permit Expiry Date Date on which the permit will/would have expire(d) permit_details permit_expiry_date 2016-08-01 string
DDL-23 Building Permits Stories # Number of stories of the primary building against which the permit is applied permit_details stories 2 string
DDL-24 Building Permits Units Number of household units for a given building permit_details units 5 string
DDL-25 Building Permits Total SqFt Total square feet of the property location permit_details total_sqft 4570 string
DDL-26 Building Permits Valuation Valuation of building or property permit_details valuation $18,000.00 string
DDL-27 Building Permits Comments Additional comments on the building permit permit_details comments Category: Residential, Work Type: Alteration, Job Valuation: 18000 string
DDL-28 Building Permits PIN Property identification number permit_details pin 3321213 string
DDL-29 Building Permits Parcel ID A Parcel Identifier or PID is a number that uniquely identifies a parcel in the land title permit_details parcel_id 3321213 string
DDL-30 Building Permits Permit Fees Sum of subtotal paid subtotal unpaid and subtotal waived permit_details permit_fees $911.55 string
DDL-31 Contractor Details Contractor Organization Company name of the Contractor contractor_details contractor_organization HASSLER HEATING & AIR CONDITIO string
DDL-32 Contractor Details Contractor Name Full name of the Contractor contractor_details contractor_name Dewald Clinton string
DDL-33 Contractor Details Contractor Contact # Contractor phone number contractor_details contractor_phone 5108483030 string
DDL-34 Contractor Details Contractor Address Contractor address contractor_details contractor_address BL-033358,1537 S 56TH ST string
DDL-35 Contractor Details Contractors License Type Permittee's / Contractor License Type contractor_details contractor_license_type GC string
DDL-36 Contractor Details Contractors License number Permittee's/Contractor License # contractor_details contractor_license_number 324711 string
DDL-37 Contractor Details Contractors License Expiry Date Expiry date of the contractor's license contractor_details contractor_license_expiry_date 2027-04-07 string
DDL-38 Owner Details Owner Full Name Owner Full Name owner_details owner_name Travis Henry string
DDL-39 Owner Details Owner Organization Owner Organization owner_details owner_organization ONEILL DAVID D & MARY V TRS string
DDL-40 Owner Details Owner Phone Owner Phone Number owner_details owner_contact_number 4233367243 string
DDL-41 Owner Details Owner Address Owner Address owner_details owner_address 1123 PARK HILLS RD,BERKELEY CA 94708 string
DDL-42 Inspection Details Inspection Number Unique identifier for the inspection inspection_details inspection_number B2019-03675 string
DDL-43 Inspection Details Inspection Type Type of inspection conducted inspection_details inspection_type Building Addition string
DDL-44 Inspection Details Inspection Status Current status of the inspection inspection_details inspection_status Issued string
DDL-45 Inspection Details Inspection Applied Date Date on which the inspection was requested inspection_details inspection_applied_date 2019-07-12 string
DDL-46 Inspection Details Inspection Scheduled Date Date on which the inspection is scheduled inspection_details inspection_scheduled_date 2019-08-30 string
DDL-47 Inspection Details Inspection Status Date Date on which the inspection status was reported inspection_details inspection_status_date 2019-07-25 string
DDL-48 Inspection Details Inspection Valuation Valuation of work being inspected inspection_details inspection_valuation $1232.00 string
DDL-49 Inspection Details Inspection Fees Fees paid for the inspection inspection_details inspection_fees $127.00 string
DDL-50 Inspection Details Inspector Name Full name of the assigned inspector inspection_details inspector_name PAUL GERRARD string

Downloads