Alley Maintenance Inventory by US Government | Finance and Economics

About this Dataset

Alley Maintenance Inventory

Inventory of alleys within the District including data for alley condition, status, material, and other alley-related information.
Organization: District of Columbia
Last updated: 2024-04-30T18:33:14.228514
Tags: alley, alley-maintenance, construction, district-of-columbia, transportation, transportation-asset, washington-dc

Tables

Table 1

@usgov.district_of_columbia_alley_maintenance_inventory.table_1

908.83 KB
8725 rows
49 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "alleysegid" BIGINT,
  "ssd_id" BIGINT,
  "sourceid" BIGINT,
  "quadcode" BIGINT,
  "beginmeasure" BIGINT,
  "endmeasure" DOUBLE,
  "inservicedate" TIMESTAMP,
  "outofservicedate" VARCHAR,
  "updatetimestamp" TIMESTAMP,
  "lifecyclestatus" BIGINT,
  "directionality" BIGINT,
  "numberoflanes" DOUBLE,
  "segmentwidth" DOUBLE,
  "ownership" BIGINT,
  "description" VARCHAR,
  "propertysquare" VARCHAR,
  "fromnodeid" BIGINT,
  "tonodeid" BIGINT,
  "streetid" DOUBLE,
  "registeredname" VARCHAR,
  "streettype" VARCHAR,
  "quadrant" VARCHAR,
  "fromaddressleft" DOUBLE,
  "toaddressleft" DOUBLE,
  "fromaddressright" DOUBLE,
  "toaddressright" DOUBLE,
  "alley_id" DOUBLE,
  "width" DOUBLE,
  "length" DOUBLE,
  "material" DOUBLE,
  "lights" DOUBLE,
  "low_points" DOUBLE,
  "catch_basins" DOUBLE,
  "condition" DOUBLE,
  "status" DOUBLE,
  "restriction" DOUBLE,
  "direction" DOUBLE,
  "historic" DOUBLE,
  "paper_alley" DOUBLE,
  "se_anno_cad_data" VARCHAR,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "shapelen" BIGINT,
  "dcgisalleymaintenancelen" BIGINT
);