Name: Fire Hydrants
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-by

About this Dataset

Fire Hydrants

This layer contains points representing locations for fire hydrants in the District of Columbia.
Organization: District of Columbia
Last updated: 2024-04-30T17:31:17.849273
Tags: dc, district-of-columbia, emergency, fems, fire, hydrant, public-safety, safety, washington-dc, water

Tables

Table 1

@usgov.district_of_columbia_fire_hydrants_f1807.table_1

1.51 MB
10,998 rows
29 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "assetnum" VARCHAR,
  "description" VARCHAR,
  "locationdetail" VARCHAR,
  "inservice" VARCHAR,
  "isnfpa" VARCHAR,
  "lastservicedt" TIMESTAMP,
  "battalion" DOUBLE,
  "engineid" VARCHAR,
  "smd" VARCHAR,
  "anc" VARCHAR,
  "ward" VARCHAR,
  "blockkey" VARCHAR,
  "offset" DOUBLE,
  "measure" DOUBLE,
  "blockfacekey" VARCHAR,
  "routeid" VARCHAR,
  "dcs_last_mod_dtm" TIMESTAMP,
  "bandcolor" VARCHAR,
  "flow" DOUBLE,
  "xcoord" BIGINT,
  "ycoord" BIGINT,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "created" VARCHAR,
  "edited" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "objectid" BIGINT
);