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

About this Dataset

Street Lights

Street Light Assets. The dataset contains locations and attributes of street lights provided by the District Department of Transportation (DDOT).
Organization: District of Columbia
Last updated: 2024-04-30T17:29:12.251616
Tags: dc, district-of-columbia, safety, street-lights, trail-lights, transportation, tunnel-lights, washington-dc

Tables

Table 1

@usgov.district_of_columbia_street_lights_3d42d.table_1

6.77 MB
72,044 rows
61 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "addedby" VARCHAR,
  "addtogis" TIMESTAMP,
  "armlength1_desc" VARCHAR,
  "armlength2_desc" VARCHAR,
  "armstyle_desc" VARCHAR,
  "assetstatus_desc" VARCHAR,
  "assettype" DOUBLE,
  "cct_desc" VARCHAR,
  "condition_desc" VARCHAR,
  "crossstreet" VARCHAR,
  "facilityid" VARCHAR,
  "feedmanhole_desc" VARCHAR,
  "fixturestyle_desc" VARCHAR,
  "globalid" VARCHAR,
  "houseno" VARCHAR,
  "inoperation" TIMESTAMP,
  "ismetered_desc" VARCHAR,
  "ismodified_desc" VARCHAR,
  "lastmodified" VARCHAR,
  "lastpainted" VARCHAR,
  "ledinoperation" TIMESTAMP,
  "lighthistory" VARCHAR,
  "lightmanufacturer_desc" VARCHAR,
  "lighttype_desc" VARCHAR,
  "numberlights" DOUBLE,
  "numberarms_desc" VARCHAR,
  "otherequipment" VARCHAR,
  "owner_desc" VARCHAR,
  "pepcolightid" VARCHAR,
  "polecolor_desc" VARCHAR,
  "polecomposition_desc" VARCHAR,
  "poleheight_desc" VARCHAR,
  "poletype_desc" VARCHAR,
  "powerfeed_desc" VARCHAR,
  "proximity_desc" VARCHAR,
  "quadrant_desc" VARCHAR,
  "rms_desc" VARCHAR,
  "roadclassification_desc" VARCHAR,
  "shield_desc" VARCHAR,
  "streetlightid" VARCHAR,
  "streetname" VARCHAR,
  "streetsegmid" DOUBLE,
  "tbasetype_desc" VARCHAR,
  "trafficcombo" VARCHAR,
  "ward" DOUBLE,
  "wattage1" DOUBLE,
  "wattage2" VARCHAR,
  "whatmodified" VARCHAR,
  "whyinactive" VARCHAR,
  "subblockkey" VARCHAR,
  "xcoord" BIGINT,
  "ycoord" BIGINT,
  "gis_id" VARCHAR,
  "objectid" BIGINT,
  "globalid_1" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR
);