About this Dataset

SHN Postmiles Tenth

Postmiles are valid postmile points at 0.1 (1/10th) mile intervals, based on the Caltrans Linear Referencing System, updated to match TSN as it appeared on 1 October 2021. Exceptions that are included are the beginning and ends of routes (and other situations) that don't necessarily begin or end on the even 0.1 mile interval.
Organization: State of California
Last updated: 2023-08-12T12:05:04.399282
Tags: caltrans, clearinghouse, highway, postmiles, shn, tenth, transportation

Tables

Table 1

@usgov.ca_gov_shn_postmiles_tenth_972a0.table_1

10.73 MB
311,298 rows
20 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "route" BIGINT,
  "rtesuffix" VARCHAR,
  "routes" VARCHAR,
  "pmrouteid" VARCHAR,
  "county" VARCHAR,
  "district" BIGINT,
  "pmprefix" VARCHAR,
  "pm" DOUBLE,
  "pmsuffix" VARCHAR,
  "pmc" VARCHAR,
  "odometer" DOUBLE,
  "pminterval" DOUBLE,
  "hwysegment" VARCHAR,
  "aligncode" VARCHAR,
  "routetype" VARCHAR,
  "direction" VARCHAR,
  "pmoffset" DOUBLE
);