About this Dataset

Survey Markers

Data is captured by Iowa DOT surveyors and loaded via the Survey Portal. All populated data comes directly from the field data collection units. X, Y, and Z fields are projected in the system listed in the "Coordinates System" field using the datums listed in the Horizontal Datum and Vertical Datum fields. Contact information for each point can be found in the "Surveyors Name" field. If you have any questions about the general data, contact the Survey Manager in the Office of Design.
Organization: State of Iowa
Last updated: 2024-04-12T12:52:06.548889
Tags: markers, survey

Tables

Table 1

@usgov.state_of_iowa_survey_markers_data.table_1

1.91 MB
15,813 rows
27 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "z_coordinate" DOUBLE,
  "survey_marker_type" VARCHAR,
  "description" VARCHAR,
  "dot_project_number" VARCHAR,
  "horizontal_datum" VARCHAR,
  "gps_network" VARCHAR,
  "coordinate_system" VARCHAR,
  "vertical_datum" VARCHAR,
  "project_office_owner" VARCHAR,
  "date_added" VARCHAR,
  "surveyor_name" VARCHAR,
  "precision_quality_level" VARCHAR,
  "land_surveyor_certified" VARCHAR,
  "record_status" VARCHAR,
  "capture_date_year" DOUBLE  -- Capture Date - Year,
  "capture_date_month" DOUBLE  -- Capture Date - Month,
  "capture_date_day" DOUBLE  -- Capture Date - Day,
  "rest_service_last_updated" VARCHAR,
  "globalid" VARCHAR,
  "survey_id" VARCHAR,
  "document_url" VARCHAR,
  "project_directory_path" VARCHAR,
  "url" VARCHAR
);