Name: Streetlights
Creator: US Government
License: http://creativecommons.org/publicdomain/zero/1.0/legalcode

About this Dataset

Streetlights

Point layer that comes every 2 years from the firm responsible for maintaining streetlights. Has attributes such as the light bulb type (LED, etc) and the condition of the pole and other hardware (Pay attention to Lat/Long coordinates that are reversed)
Organization: City of New Orleans
Last updated: 2022-01-24T23:27:07.703547
Tags: 311, dpw

Tables

Table 1

@usgov.city_of_new_orleans_streetlights_bc0fd.table_1

3.51 MB
52,199 rows
52 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "assetid" VARCHAR,
  "point_y" DOUBLE,
  "point_x" DOUBLE,
  "councildistrict" VARCHAR,
  "neighborhood" VARCHAR,
  "dpwzone" VARCHAR,
  "date" VARCHAR,
  "wiring" VARCHAR,
  "poletype" VARCHAR,
  "polecondition" VARCHAR,
  "basetype" VARCHAR,
  "basecond" VARCHAR,
  "inspplatec" VARCHAR,
  "lightpoint" VARCHAR,
  "treetrim" VARCHAR,
  "dayburn" VARCHAR,
  "fixtype1" VARCHAR,
  "fixcond1" VARCHAR,
  "supparmtyp" VARCHAR,
  "supparmcon" VARCHAR,
  "bulbtype1" VARCHAR,
  "wattlabel1" VARCHAR,
  "refcond1" VARCHAR,
  "fixtype2" VARCHAR,
  "fixcond2" VARCHAR,
  "supparmt_1" VARCHAR,
  "supportarmc_1" VARCHAR,
  "bulbtype2" VARCHAR,
  "wattlabel2" DOUBLE,
  "refcond2" VARCHAR,
  "fixtype3" VARCHAR,
  "fixcond3" VARCHAR,
  "bulbtype3" VARCHAR,
  "wattlabel3" DOUBLE,
  "refcond3" VARCHAR,
  "fixtype4" VARCHAR,
  "fixcond4" VARCHAR,
  "bulbtype4" VARCHAR,
  "wattlabel4" DOUBLE,
  "refcond4" VARCHAR,
  "fixtype5" VARCHAR,
  "fixture_condition_5" VARCHAR,
  "bulbtype5" VARCHAR,
  "wattlabel5" VARCHAR,
  "refcond5" VARCHAR,
  "fixtype6" VARCHAR,
  "fixcond6" VARCHAR,
  "bulbtype6" VARCHAR,
  "wattlabel6" VARCHAR,
  "refcond6" VARCHAR
);