Fire Stations by US Government | Demographics and Population Studies

About this Dataset

Fire Stations

Fire Stations in Oregon Any location where fire fighters are stationed or based out of, or where equipment that such personnel use in carrying out their jobs is stored for ready use. Fire Departments not having a permanent location are included, in which case their location has been depicted at the city/town hall or at the center of their service area if a city/town hall does not exist. This dataset includes those locations primarily engaged in forest or grasslands fire fighting, including fire lookout towers if the towers are in current use for fire protection purposes. This dataset includes both private and governmental entities. Fire fighting training academies are also included. This dataset is comprised completely of license free data. The Fire Station dataset and the EMS dataset were merged into one working file. TGS processed as one file and then separated for delivery purposes. Records with "-DOD" appended to the end of the [NAME] value are located on a military base, as defined by the Defense Installation Spatial Data Infrastructure (DISDI) military installations and military range boundaries. Text fields in this dataset have been set to all upper case to facilitate consistent database engine search results. All diacritics (e.g., the German umlaut or the Spanish tilde) have been replaced with their closest equivalent English character to facilitate use with database systems that may not support diacritics. The currentness of this dataset is indicated by the [CONTDATE] field. Based upon this field, the oldest record dates from 07/11/2006 and the newest record dates from 06/02/2008.
Organization: State of Oregon
Last updated: 2024-02-09T16:03:54.307102
Tags: fire-stations, framework, oregon-state-fire-marshal, osfm, preparedness

Tables

Table 1

@usgov.state_of_oregon_fire_stations_a63a1.table_1

171.96 KB
731 rows
52 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "id" BIGINT,
  "secclass" VARCHAR,
  "name" VARCHAR,
  "telephone" VARCHAR,
  "address" VARCHAR,
  "address2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "zipp4" VARCHAR,
  "county" VARCHAR,
  "fips" BIGINT,
  "directions" VARCHAR,
  "emergtitle" VARCHAR,
  "emergtel" VARCHAR,
  "emergext" VARCHAR,
  "contdate" VARCHAR,
  "conthow" VARCHAR,
  "geodate" VARCHAR,
  "geohow" VARCHAR,
  "naicscode" BIGINT,
  "naicsdescr" VARCHAR,
  "geolinkid" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "st_vendor" VARCHAR,
  "st_version" VARCHAR,
  "geoprec" VARCHAR,
  "phoneloc" VARCHAR,
  "qc_qa" VARCHAR,
  "state_id" VARCHAR,
  "fdid" VARCHAR,
  "frst_mbrs" BIGINT,
  "ems_mbrs" BIGINT,
  "totalpers" BIGINT,
  "numtrks" BIGINT,
  "numabul" BIGINT,
  "total_vehi" BIGINT,
  "nbr_sta" BIGINT,
  "owner" VARCHAR,
  "level" VARCHAR,
  "type" VARCHAR,
  "specialty" VARCHAR,
  "emslicense" VARCHAR,
  "emerphone" VARCHAR,
  "ems" VARCHAR,
  "perm_id" VARCHAR,
  "gnis_id" VARCHAR,
  "globalid" VARCHAR,
  "x2" DOUBLE,
  "y2" DOUBLE
);