Streets by US Government | Transportation and Logistics

About this Dataset

Streets

Line features representing the centerline of street corridors in Orange County, NC including Chapel Hill, NC. Data maintained by Orange County, the Town of Chapel Hill, and the Town of Carrboro. Updated regularly as needed.
Organization: Town of Chapel Hill, North Carolina
Last updated: 2024-02-09T14:55:44.582443
Tags: chapel-hill, gis, open-data, orange-county, streets, transportation

Tables

Table 1

@usgov.town_of_chapel_hill_north_caro_streets_9d69b.table_1

1.68 MB
12318 rows
100 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "streetid" DOUBLE,
  "dirprefix" VARCHAR,
  "name" VARCHAR,
  "type" VARCHAR,
  "dirsuffix" VARCHAR,
  "fullname" VARCHAR,
  "leftfrom" DOUBLE,
  "leftto" DOUBLE,
  "rightfrom" DOUBLE,
  "rightto" DOUBLE,
  "leftzip" DOUBLE,
  "rightzip" DOUBLE,
  "leftmailcity" VARCHAR,
  "rightmailcity" VARCHAR,
  "alt_prefix" VARCHAR,
  "alt_name" VARCHAR,
  "alt_type" VARCHAR,
  "alt_suffix" VARCHAR,
  "prevname" VARCHAR,
  "sr_num" DOUBLE,
  "jurisdiction_r" VARCHAR,
  "jurisdiction_l" VARCHAR,
  "county" VARCHAR,
  "segmentid" BIGINT,
  "maint" VARCHAR,
  "surface" VARCHAR,
  "rightspeed" DOUBLE,
  "leftspeed" DOUBLE,
  "direction" DOUBLE,
  "class" VARCHAR,
  "curb" VARCHAR,
  "width" DOUBLE,
  "miles" DOUBLE,
  "cross1" VARCHAR,
  "cross12" VARCHAR,
  "cross2" VARCHAR,
  "cross22" VARCHAR,
  "soundex" VARCHAR,
  "editedby" VARCHAR,
  "editeddate" TIMESTAMP,
  "comments" VARCHAR,
  "symbology" VARCHAR,
  "globalid" VARCHAR,
  "rangedistance" DOUBLE,
  "esn_r" DOUBLE,
  "ratecoder" VARCHAR,
  "st_posdir" VARCHAR,
  "st_predir" VARCHAR,
  "st_presep" VARCHAR,
  "gc_exception" DOUBLE,
  "nbrhdcom_r" VARCHAR,
  "valid_r" VARCHAR,
  "parity_l" VARCHAR,
  "addcode_l" VARCHAR,
  "adnumpre_r" VARCHAR,
  "county_l" VARCHAR,
  "postcomm_l" VARCHAR,
  "postcode_l" DOUBLE,
  "speedlimit" DOUBLE,
  "fromaddr_l" DOUBLE,
  "att_except" VARCHAR,
  "lst_posdir" VARCHAR,
  "lst_predir" VARCHAR,
  "dateupdate" TIMESTAMP,
  "toaddr_l" DOUBLE,
  "msagcomm_l" VARCHAR,
  "st_posmod" VARCHAR,
  "st_premod" VARCHAR,
  "oneway" DOUBLE,
  "roadclass" VARCHAR,
  "incmuni_l" VARCHAR,
  "uninccom_l" VARCHAR,
  "parity_r" VARCHAR,
  "addcode_r" VARCHAR,
  "county_r" VARCHAR,
  "postcomm_r" VARCHAR,
  "discrpagid" VARCHAR,
  "esn_l" DOUBLE,
  "postcode_r" DOUBLE,
  "ratecodel" VARCHAR,
  "fromaddr_r" DOUBLE,
  "lst_posmod" VARCHAR,
  "lst_premod" VARCHAR,
  "toaddr_r" DOUBLE,
  "msagcomm_r" VARCHAR,
  "st_name" VARCHAR,
  "nbrhdcom_l" VARCHAR,
  "valid_l" VARCHAR,
  "effective" TIMESTAMP,
  "lst_type" VARCHAR,
  "incmuni_r" VARCHAR,
  "uninccom_r" VARCHAR,
  "expire" VARCHAR,
  "adnumpre_l" VARCHAR,
  "st_postyp" VARCHAR,
  "st_pretyp" VARCHAR,
  "lst_name" VARCHAR,
  "rcl_nguid" VARCHAR,
  "shapestlength" DOUBLE
);