Property Fire Protection Data Fields

Field Name Type Description
pbkey Char(17) A unique address identifier that is returned when an address match is made using the Master Location Dataset.
place_code Char(12) Incorporated Place ID. Its value will be Null if the address is not in an incorporated place.
place_name Char(40) Incorporated Place Name. Its value will be Null if the address is not in an incorporated place
fs1_department_id Integer Fire Department ID of nearest Fire Station 1
fs1_department_type Char(20) Department type of nearest Fire Station 1
fs1_station_id Integer Station ID of nearest Fire Station 1
fs1_drivetime_ampeak Double Precision Routing drive time (in minutes) from data point (start point) to nearest Fire Station 1 (end point) during the peak time of day in the AM.
fs1_drivetime_pmpeak Double Precision Routing drive time (in minutes) from data point (start point) to nearest Fire Station 1 (end point) during the peak time of day in the PM.
fs1_drivetime_offpeak Double Precision Routing drive time (in minutes) from data point (start point) to nearest Fire Station 1 (end point) during an off-peak time of day.
fs1_drivetime_night Double Precision Routing drive time (in minutes) from data point (start point) to nearest Fire Station 1 (end point) during the night
fs1_drivedistance Double Precision Routing drive distance (in miles) from data point (start point) to nearest Fire Station 1 (end point).
fs2_department_id Integer Fire Department ID of nearest Fire Station 2
fs2_department_type Char(20) Department type of nearest Fire Station 2
fs2_station_id Integer Station ID of nearest Fire Station 2
fs2_drivetime_ampeak Double Precision Routing drive time (in minutes) from data point (start point) to nearest Fire Station 2 (end point) during the peak time of day in the AM.
fs2_drivetime_pmpeak Double Precision Routing drive time (in minutes) from data point (start point) to nearest Fire Station 2 (end point) during the peak time of day in the PM.
fs2_drivetime_offpeak Double Precision Routing drive time (in minutes) from data point (start point) to nearest Fire Station 2 (end point) during an off-peak time of day.
fs2_drivetime_night Double Precision Routing drive time (in minutes) from data point (start point) to nearest Fire Station 2 (end point) during the night.
fs2_drivedistance Double Precision Routing drive distance (in miles) from data point (start point) to nearest Fire Station 2 (end point).
fs3_department_id Integer Fire Department ID of nearest Fire Station 3
fs3_department_type Char(20) Department type of nearest Fire Station 3
fs3_station_id Integer Station ID of nearest Fire Station 3
fs3_drivetime_ampeak Double Precision Routing drive time (in minutes) from data point (start point) to nearest Fire Station 3 (end point) during the peak time of day in the AM.
fs3_drivetime_pmpeak Double Precision Routing drive time (in minutes) from data point (start point) to nearest Fire Station 3 (end point) during the peak time of day in the PM.
fs3_drivetime_offpeak Double Precision Routing drive time (in minutes) from data point (start point) to nearest Fire Station 3 (end point) during an off-peak time of day.
fs3_drivetime_night Double Precision Routing drive time (in minutes) from data point (start point) to nearest Fire Station 3 (end point) during the night.
fs3_drivedistance Double Precision Routing drive distance (in miles) from data point (start point) to nearest Fire Station 3 (end point).
nearest_water_body Double Precision Distance (in feet) between data point and nearest waterbody point.