About this Dataset

Streets

Chesapeake street centerlines represented as vector lines. VDOT_Rank field uses: LOS-LOCAL, COL-COLLECTOR, ARP-ARTERIAL PRIMARY, ARM-ARTERIAL MINOR. TYPE_ field: Street type follows U.S. Postal standards. LEFT_IS and RIGHT_IS fields use: O-odd numbers, E-even numbers, B- both odd and even numbers. ONEWAY field: BI- bidirectional, FT- From-to, TF- To-from
Organization: City of Chesapeake
Last updated: 2024-02-09T15:26:47.319715
Tags: open-data, transportation

Tables

Table 1

@usgov.city_of_chesapeake_streets_14b07.table_1

1.73 MB
14958 rows
35 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fr_addr_l" BIGINT,
  "to_addr_l" BIGINT,
  "left_is" VARCHAR,
  "fr_addr_r" BIGINT,
  "to_addr_r" BIGINT,
  "right_is" VARCHAR,
  "prefix" VARCHAR,
  "name" VARCHAR,
  "type" VARCHAR,
  "direction" VARCHAR,
  "oneway" VARCHAR,
  "speedlmt" BIGINT,
  "street_id" BIGINT,
  "class" VARCHAR,
  "vdot_rank" VARCHAR,
  "zip_left" DOUBLE,
  "zip_right" DOUBLE,
  "city_l" VARCHAR,
  "city_r" VARCHAR,
  "borough" VARCHAR,
  "state" VARCHAR,
  "fr_faddr_l" DOUBLE,
  "to_faddr_l" BIGINT,
  "fr_faddr_r" BIGINT,
  "to_faddr_r" BIGINT,
  "shape_leng" DOUBLE,
  "length_miles" DOUBLE,
  "minutes" DOUBLE,
  "created_user" VARCHAR,
  "created_date" TIMESTAMP,
  "last_edited_user" VARCHAR,
  "last_edited_date" TIMESTAMP,
  "globalid" VARCHAR,
  "shapestlength" DOUBLE
);