Field Name

Type

Required

Description

building_id

string

Yes

Building_id is a unique alpha-numeric identifier created or assigned by a single authoritative agency in a locale (e.g. tax collector)  that identifies each residential building inspected by any agency in locality. See source and definition of building_id in feed.csv below.

parcel_id

string

No

Unique BLKLOT identifier

facility_type

string

No

Type of residential property :

Single Family - Uncategorized

Single Family - Attached

Single Family - Detached

Single Family - Mobile Home

Multifamily - Duplex

Multifamily - Townhome

Multifamily - Condominium

Multifamily - Apartment

Uncategorized

dwelling_units

number

Yes

Number of residential dwelling units

occupancy

number

No

Occupancy of the building if available

built_year

number

Yes

Year building was constructed or rebuilt.

gross_floor_area

number

Yes

Recorded building gross floor area (square feet)

heated_floor_area

number

No

Floor area of the building which is heated

cooled_floor_area

number

No

Floor area of the building which is cooled

lighted_floor_area

number

No

Floor area of the building which is lighted

building_value

number

No

Current assessed property value.

from_st

string

Yes

Lowest numerical value of the street number if the building has an address range or only building street number.

to_st

string

No

Highest numerical value of the street number if the building has an address range.

street

string

Yes

Street name

predir

String

Yes

Field for the prefix that precedes the street name, for example,  N(orth), E(ast), S(outh) or W(est)

sufdir

String

Yes

Field for the suffix that follows the street name, for example,  N(orth), E(ast), S(outh) or W(est)

street_type

string

Yes

Street type (St, Ave, Way)

city

string

Yes

City where the property is located.

state

string

Yes

State where the property is located. In the U.S. this should be the two-letter code for the state

postal_code

string

Yes

Zip code or other postal code

latitude

number

Yes

Latitude of the residential building parcel. This field must be a valid WGS 84 latitude. For example 37.7859547

longitude

number

Yes

Longitude of the residential building parcel. This field must be a valid WGS 84 longitude. For example -122.4024658

operator_type

string

No

The kind of entity which is responsible for operating the building:  Private owner; property management; tenant; public institution; non-profit institution; bank.

owner_name

string

Yes

Property owner. This may be an individual or business entity.

owner_mailing_address

string

No

Mailing address for the owner of record. For example Jane Smith 310 Polaris Way San  Francisco CA 94117

date_updated

Date

No

date that the record was created or updated.

Name

Type

Required

Description

inspection_id

string

Yes

Unique ID for inspection; format provided by municipality

building_id

string

Yes

Unique identifier for the residential property being inspected.

inspection_date

date

Yes

Date of the inspection in YYYY-MM-DD format

inspection_address

string

Yes

Address at which the inspection occurred

inspection_unit_number

string

No

Identification for specific unit in a multi-unit building where inspection was conducted, for example, “113” or “F.”

inspection_agency

string

Yes

Type of agency conducting the inspection. Must be one of the following types: Health, Environment, Building, Housing, Planning, Fire, Code Enforcement.

inspection_purpose

string

Yes

Reason for the inspection. Must be one of the following types: permit [approval], routine or periodic [monitoring], complaint or service request [response], follow-up [of a previous inspection].

inspection_category

string

No

Functional category or subject of the inspection. For example, structural, mechanical, plumbing, pest-control, fire prevention, noise, indoor air quality, etc

inspection_rating

string

Yes

Inspection rating or result, for example, “pass/ fail,” “satisfactory/ not-satisfactory,” if one exists.

inspection_score

number

No

Numerical score associated with the inspection if one exists

latitude

number

Yes

Latitude of the residential building parcel. This field must be valid WGS 84 latitude. For example 37.7859547

longitude

number

Yes

Longitude of the residential building parcel. This field must be valid WGS 84 longitude. For example -122.4024658

Date_updated

date

No

Date that the record was updated or created.

Name

Type

Required

Description

violation_id

number

Yes

Unique identifier for the violations

building_id

string

Yes

Unique identifier for the property being inspected.

inspection_id

number

Yes

Unique identifier for the inspection

Inspection_agency

string

Yes

Type of agency issuing the violation, for example, Health, Environment, Building, Housing, Planning, Fire, Code Enforcement.

Inspection_purpose

string

Yes

Reason for the inspection, for example, permit [approval] , routine or periodic [monitoring], complaint [response], follow-up [of a previous inspection].

violation_date

date

Yes

Date that the violation was recorded in YYYY-MM-DD format.

violation_status

string

 Yes    

Violation status: Open or Closed.

violation_address

string

Yes

Address where violation observed.

violation_unit_number

string

No

Identification for specific unit in a multi-unit building where violation occurred, for example, “113” or “F.”

violation_date_closed

date

Yes

Date that the violation was closed in YYYY-MM-DD format.

violation_reason_closed

string     

No

Reason that the violation was closed (e.g. violation corrected by responsible party)

violation_category

string

Yes

Violation category. Must be one of the categories in the HFDS list of violation categories.

violation_type

string

Yes

Violation type (bedbugs, mold, etc)

violation_code

string

no

The legal authority under which a violation is issued, for example, a section of the housing code.

violation_severity

string

No

May be one of the following categories: high (imminently harmful to health and requires rapid correction) and low (nuisance with correction over a reasonable period of time)

latitude

number

Yes

Latitude of the residential building parcel. This field must be a valid WGS 84 latitude. For example 37.7859547

longitude

number

Yes

Longitude of the residential building parcel. This field must be a valid WGS 84 longitude. For example -122.4024658

Date_updated

Date

No

Date the violation record was created or updated.

field name

data type

required

description

building_id

string

yes

parcel_id

string

no

building_address

string

yes

building_certification_type

string

yes

Name of building performance certification system, standard, or program:

Energy Star Home

Energy Star Indoor AirPlus

CEC Home Energy Rating System

USGBC LEED for Homes

USGBC LEED Neighborhood Development

Enterprise Green Communities

Earth Advantage Home

Green Globes New Construction

Green Globes CIEB

building_certification_value

string

yes

Certification rating, level, or score.  This may be reported as a string or as a numerical score.

building_rating_date

date

no

Date of rating or performance measurement.

building_certification_source

string

yes

Data source for building certification information

date_updated

date

No

Date record created or updated

field name

data type

required

description

building_id

string

yes

parcel_id

string

yes

building_address

string

yes

utility_type

string

yes

May be any one of the following types: Water, sewage, electricity, natural gas, heating oil, landfill refuse, recycled refuse, etc.

utility_data_source

string

yes

Source of utility data (e.g., utility provider, municipality, building owner, EPA portolio manager, private energy benchmarking software, etc)

utility_measure

string

yes

*Standardize units for this field include: kwh (electricity), therms (natural gas), gallons (water),

utility_report_date

date

yes

Date data provided by source

utility_report_period

number

yes

Number of months of utility data

monthly_utility_use

number

yes

Average utility consumption per unit