Street Name by US Government | Transportation and Logistics

About this Dataset

Street Name

Road segments representing centerlines of all roadways or carriageways in a local government. Typically, this information is compiled from orthoimagery or other aerial photography sources. This representation of the road centerlines support address geocoding and mapping. It also serves as a source for public works and other agencies that are responsible for the active management of the road network.
Organization: City of New Orleans
Last updated: 2022-01-24T23:27:06.015917
Tags: transportation

Tables

Table 1

@usgov.city_of_new_orleans_bike_lanes_a4327.table_1

4.35 MB
28523 rows
39 columns


CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "centerline_id" BIGINT,
  "left_from_address" DOUBLE,
  "left_to_address" DOUBLE,
  "right_from_address" DOUBLE,
  "right_to_address" DOUBLE,
  "full_road_name" VARCHAR,
  "federal_route" DOUBLE,
  "federal_route_type" VARCHAR,
  "alternate_federal_route" VARCHAR,
  "alternate_federal_route_type" VARCHAR,
  "state_route" DOUBLE,
  "state_route_type" VARCHAR,
  "alternate_state_route" VARCHAR,
  "alternate_state_route_type" VARCHAR,
  "county_route" VARCHAR,
  "one_way_indicator" VARCHAR,
  "above_or_below_grade" DOUBLE,
  "in_water" VARCHAR,
  "road_class" VARCHAR,
  "census_mtfcc_code" VARCHAR,
  "owned_by" DOUBLE,
  "maintained_by" DOUBLE,
  "municipality_on_left" VARCHAR,
  "municipality_on_right" VARCHAR,
  "state_on_left" VARCHAR,
  "state_on_right" VARCHAR,
  "zip_on_left" VARCHAR,
  "zip_on_right" VARCHAR,
  "msag_on_left" VARCHAR,
  "msag_on_right" VARCHAR,
  "esn_on_left" DOUBLE,
  "esn_on_right" DOUBLE,
  "last_update_date" VARCHAR,
  "last_editor" VARCHAR,
  "abbreviated_road_name" VARCHAR,
  "join_id" DOUBLE,
  "shape_stlength" DOUBLE
);