Coastal Topography Monitoring Data For Gateway National Recreation Area (GATE) Through 2023 by US Government | Ecommerce and Consumer Trends

About this Dataset

Coastal Topography Monitoring Data For Gateway National Recreation Area (GATE) Through 2023

These files contain topographic profiles collected at GATE through the 2023 field season
Organization: Department of the Interior
Last updated: 2025-06-01T07:21:01.565848
Tags: application-inventory-registry, beach, coastal-topography, dune, ecological-framework-geology-and-soils-geomorphology-coastal-oceanographic-features-and-process, geomorphologic, im, inventory-monitoring, ncbn, northeast-coastal-and-barrier-network, shoreline, vital-sign

Tables

GATE CoastalTopo Survey Events

@usgov.doi_gov_coastal_topography_monitoring_for_gateway_nati_3ca587b9.gate_coastaltopo_survey_events

69.6 KB
278 rows
56 columns


CREATE TABLE gate_coastaltopo_survey_events (
  "surveyevent" VARCHAR,
  "surveyyear" BIGINT,
  "dataprocessinglevel" VARCHAR,
  "parkcode" VARCHAR,
  "parksubunit" VARCHAR,
  "parksection" VARCHAR,
  "surveydate" TIMESTAMP,
  "starttime" VARCHAR,
  "endtime" VARCHAR,
  "surveyseason" VARCHAR,
  "observer" VARCHAR,
  "surveyqualifier" VARCHAR,
  "supplementalsurvey" VARCHAR,
  "protocolname" VARCHAR,
  "deviationreason" VARCHAR,
  "laststormdate" TIMESTAMP,
  "utmzone" VARCHAR,
  "verticaldatum" VARCHAR,
  "geoidmodel" VARCHAR,
  "units" VARCHAR,
  "geodeticreference" VARCHAR,
  "accuracynotes" VARCHAR,
  "benchmarkbuffer_meters" DOUBLE,
  "presurveyhorizontaldifference_meters" DOUBLE,
  "presurveyhorizontalwithintolerance" VARCHAR,
  "presurveyverticaldifference_meters" DOUBLE,
  "presurveyverticalwithintolerance" VARCHAR,
  "presurveyobservednorthing_meters" DOUBLE,
  "presurveyobservedeasting_meters" DOUBLE,
  "presurveyobservedorthometricheight_meters" DOUBLE,
  "presurveypublishedbenchmarkid" VARCHAR,
  "presurveypublishednorthing_meters" DOUBLE,
  "presurveypublishedeasting_meters" DOUBLE,
  "presurveypublishedorthometricheight_meters" DOUBLE,
  "presurveypublishedspatialreference" VARCHAR,
  "presurveypublishedprotectedstatus" VARCHAR,
  "presurveypublishedisactive" VARCHAR,
  "postsurveyhorizontaldifference_meters" DOUBLE,
  "postsurveyhorizontalwithintolerance" VARCHAR,
  "postsurveyverticaldifference_meters" DOUBLE,
  "postsurveyverticalwithintolerance" VARCHAR,
  "postsurveyobservednorthing_meters" DOUBLE,
  "postsurveyobservedeasting_meters" DOUBLE,
  "postsurveyobservedorthometricheight_meters" DOUBLE,
  "postsurveypublishedbenchmarkid" VARCHAR,
  "postsurveypublishednorthing_meters" DOUBLE,
  "postsurveypublishedeasting_meters" DOUBLE,
  "postsurveypublishedorthometricheight_meters" DOUBLE,
  "postsurveypublishedspatialreference" VARCHAR,
  "postsurveypublishedprotectedstatus" VARCHAR,
  "postsurveypublishedisactive" VARCHAR,
  "basestation" VARCHAR,
  "basebenchmark" VARCHAR,
  "correctionservice" VARCHAR,
  "rover" VARCHAR,
  "gnss_rtkdevicenotes" VARCHAR
);

GATE CoastalTopo Transect Measurements

@usgov.doi_gov_coastal_topography_monitoring_for_gateway_nati_3ca587b9.gate_coastaltopo_transect_measurements

2.01 MB
61507 rows
32 columns


CREATE TABLE gate_coastaltopo_transect_measurements (
  "surveyyear" BIGINT,
  "parkcode" VARCHAR,
  "parksubunit" VARCHAR,
  "parksection" VARCHAR,
  "surveydate" TIMESTAMP,
  "surveyseason" VARCHAR,
  "observerlastname" VARCHAR,
  "surveyqualifier" VARCHAR,
  "supplementalsurvey" BOOLEAN,
  "transectlabel" VARCHAR,
  "segmented" VARCHAR,
  "partialcollection" BOOLEAN,
  "pointlabel" VARCHAR,
  "northing_meters" DOUBLE,
  "easting_meters" DOUBLE,
  "orthometricheight_meters" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "ellipsoidheight_meters" DOUBLE,
  "horizontalprecision" DOUBLE,
  "verticalprecision" DOUBLE,
  "frompointid" VARCHAR,
  "importcomment" VARCHAR,
  "validationissue" VARCHAR,
  "utmzone" VARCHAR,
  "verticaldatum" VARCHAR,
  "geoidmodel" VARCHAR,
  "units" VARCHAR,
  "geodeticreference" VARCHAR,
  "wellknowntext" VARCHAR,
  "protectedstatus" VARCHAR,
  "dataprocessinglevel" VARCHAR
);