About this Dataset

Road Centerlines

This map data layer represents the centerline of roadways for the City of Bloomington, Indiana. It includes source data from the City of Bloomington and Monroe County to create a countywide network. It includes public roads, named private roads, major multi-use trails, and proposed roadways to be constructed. Attributes for centerlines outside the City of Bloomington are updated from information supplied by Monroe County Planning, Monroe County Public Works, and Ellettsville Planning.
Organization: City of Bloomington
Last updated: 2023-05-20T03:38:17.524796
Tags: centerlines, gis, maps, roads, streets, transportation

Tables

Table 1

@usgov.city_of_bloomington_road_centerlines_3ee47.table_1

4.12 MB
7,390 rows
61 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "centerline_type" VARCHAR,
  "construction_status" VARCHAR,
  "street_id" BIGINT,
  "street_direction_prefix" VARCHAR,
  "street_prefix_type" VARCHAR,
  "street_name" VARCHAR,
  "street_direction_suffix" VARCHAR,
  "street_post_direction" VARCHAR,
  "street_post_direction_modifier" VARCHAR,
  "full_street_name" VARCHAR,
  "vicinity" VARCHAR,
  "address_block" DOUBLE,
  "low_address" DOUBLE,
  "high_address" DOUBLE,
  "left_from_address" DOUBLE,
  "left_to_address" DOUBLE,
  "right_from_address" DOUBLE,
  "right_to_address" DOUBLE,
  "left_parity" VARCHAR,
  "right_parity" VARCHAR,
  "oneway_designation" VARCHAR,
  "travel" VARCHAR,
  "travel_direction" VARCHAR,
  "speed_limit" DOUBLE,
  "functional_class" VARCHAR,
  "road_class" VARCHAR,
  "government_jurisdiction" VARCHAR,
  "left_government_jurisdiction" VARCHAR,
  "right_government_jurisdiction" VARCHAR,
  "maintenance_custodian" VARCHAR,
  "low_cross_street" VARCHAR,
  "hight_cross_street" VARCHAR,
  "left_postal_code" DOUBLE,
  "right_postal_code" DOUBLE,
  "left_township" VARCHAR,
  "right_township" VARCHAR,
  "left_county" VARCHAR,
  "right_county" VARCHAR,
  "left_incorporated_municipality" VARCHAR,
  "right_incorporated_municipality" VARCHAR,
  "highway" VARCHAR,
  "local_id" DOUBLE,
  "road_level" DOUBLE,
  "federal_road_type" DOUBLE,
  "alternate_name" VARCHAR,
  "low_intersection_id" DOUBLE,
  "high_intersection_id" DOUBLE,
  "low_intersection_name" VARCHAR,
  "high_intersection_name" VARCHAR,
  "mtfcc_code" VARCHAR,
  "divided_flag" VARCHAR,
  "length_ft" DOUBLE  -- Length (ft),
  "geometry" VARCHAR,
  "pci_index" DOUBLE,
  "pci_survey_date" VARCHAR,
  "condition" VARCHAR,
  "width_ft" DOUBLE  -- Width (ft),
  "number_of_lanes" DOUBLE,
  "cityworks_id" BIGINT,
  "truck_route" VARCHAR
);