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.77 MB
12,318 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
);