About this Dataset

Reference Post

The feature class contains the reference post sign locations for all the primary routes in the State of Iowa. These signs are often referred to as mileposts, however these signs are not necessarily located at a mile apart. Also a 0 value virtual post is present at the beginning of every route.
Organization: State of Iowa
Last updated: 2024-04-12T12:45:57.553013
Tags: assets, inventory, mile-post, rams, reference, reference-posts, transportation

Tables

Table 1

@usgov.state_of_iowa_reference_post_data.table_1

1.86 MB
17,953 rows
19 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "route_id" VARCHAR,
  "measure" DOUBLE,
  "effective_start_date" VARCHAR,
  "effective_end_date" VARCHAR,
  "reference_post_value" VARCHAR,
  "reference_post_name" VARCHAR,
  "opposite_side" VARCHAR,
  "virtual" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "official_common_name" VARCHAR,
  "official_route_number" BIGINT,
  "official_route_direction" VARCHAR,
  "official_route_prefix" VARCHAR,
  "utc_offset" VARCHAR,
  "globalid" VARCHAR
);