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

About this Dataset

Specialty Lighting

The dataset contains locations and attributes of specialty street lights provided by the District Department of Transportation (DDOT).
Organization: District of Columbia
Last updated: 2024-04-30T17:32:10.766119
Tags: dc, ddot, district-of-columbia, specialty-lighting, street-light, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_specialty_lighting.table_1

26.16 kB
15 rows
37 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "tsalightid" VARCHAR,
  "sourceid" VARCHAR,
  "squareid" VARCHAR,
  "lighttype" BIGINT,
  "wattage" BIGINT,
  "poletype" VARCHAR,
  "polestyle" VARCHAR,
  "poleheight" VARCHAR,
  "powerfeed" BIGINT,
  "numberarms" BIGINT,
  "armlength" BIGINT,
  "fixture" BIGINT,
  "corner" BIGINT,
  "proximity" BIGINT,
  "houseno" BIGINT,
  "streetname" VARCHAR,
  "quadrant" BIGINT,
  "streetname1" VARCHAR,
  "roadtype" BIGINT,
  "owner" BIGINT,
  "ward" BIGINT,
  "comments" VARCHAR,
  "modifiedby" VARCHAR,
  "modifieddate" TIMESTAMP,
  "type" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "gis_id" VARCHAR,
  "objectid" BIGINT,
  "se_anno_cad_data" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR
);