About this Dataset

Forest Service Office Locations (Feature Layer)

This data includes offices where Forest Service employees work or where IT equipment is housed. There is no Personally Identifiable Information (PII) data in this dataset, nor telework locations. It includes owned, leased and shared offices. Shared offices are buildings owned or leased by another entity (i.e. a university, other federal agency, etc.) but one or more Forest Service employee(s) work at the building or IT equipment is housed at the building.

Depicts the spatial locations for Office locations from the Forest Service CIO Asset Management Office. It includes owned, leased and shared offices. Data is collected, maintained and stewarded by the CIO Asset Management Office. EDW data loading tools extract the office location data from the CIO Asset Mgt. database. Latitude and longitude values are validated and then converted to spatial point data. Spatial point data and associated attributed data describing the office location are inserted into the Office Location Feature class in the Enterprise Data Warehouse. Changes to the Office Location data are checked daily by EDW data loading tools. Data is updated weekly. Data is visible at all scales and zoom levels. Metadata and Downloads.
Organization: Department of Agriculture
Last updated: 2024-03-30T10:45:41.512101
Tags: building, office-locations, offices, open-data, structure, usda-forest-service

Tables

Table 1

@usgov.usda_gov_forest_service_office_locations_feature_layer_77629.table_1

269.54 kB
1,949 rows
28 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "name" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "zip_code" VARCHAR,
  "state" VARCHAR,
  "phone" VARCHAR,
  "fax_phone" VARCHAR,
  "mailing_street" VARCHAR,
  "mailing_city" VARCHAR,
  "mailing_zip_code" VARCHAR,
  "mailing_state" VARCHAR,
  "physical_mail_difference" VARCHAR,
  "region" VARCHAR,
  "forest_name" VARCHAR,
  "district_name" VARCHAR,
  "country" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "contact" VARCHAR,
  "equipment_only" BOOLEAN,
  "seasonal" BOOLEAN,
  "wireless_site" BOOLEAN,
  "location_id" VARCHAR,
  "sys_created_on" TIMESTAMP,
  "shape" VARCHAR
);