Assateague Island National Seashore (ASIS) Shoreline Position Change Monitoring Data Package - 2025
Department of the Interior
@usgov.doi_gov_assateague_island_national_seashore_asis_shore_786b0644
Department of the Interior
@usgov.doi_gov_assateague_island_national_seashore_asis_shore_786b0644
CREATE TABLE asis_shoreline_event_data (
"surveyevent" VARCHAR,
"surveyyear" BIGINT,
"dataprocessinglevel" VARCHAR,
"parkcode" VARCHAR,
"parksubunit" VARCHAR,
"parksection" VARCHAR,
"surveydate" TIMESTAMP,
"starttime" VARCHAR,
"endtime" VARCHAR,
"surveyseason" VARCHAR,
"observer" VARCHAR,
"surveyqualifier" VARCHAR,
"lasthightidetime" VARCHAR,
"closestneaptidedate" TIMESTAMP,
"supplementalsurvey" VARCHAR,
"protocolname" VARCHAR,
"deviationreason" VARCHAR,
"laststormdate" TIMESTAMP,
"numphotos" BIGINT,
"partialcollection" VARCHAR,
"utmzone" VARCHAR,
"geoidmodel" VARCHAR,
"units" VARCHAR,
"geodeticreference" VARCHAR,
"eventnotes" VARCHAR,
"accuracynotes" VARCHAR,
"benchmarkbuffer_meters" DOUBLE,
"presurveyhorizontaldifference_meters" DOUBLE,
"presurveyhorizontalwithintolerance" VARCHAR,
"presurveyobservednorthing_meters" DOUBLE,
"presurveyobservedeasting_meters" DOUBLE,
"presurveypublishedbenchmarkid" VARCHAR,
"presurveypublishednorthing_meters" DOUBLE,
"presurveypublishedeasting_meters" DOUBLE,
"presurveypublishedspatialreference" VARCHAR,
"presurveypublishedprotectedstatus" VARCHAR,
"presurveypublishedisactive" VARCHAR,
"postsurveyhorizontaldifference_meters" DOUBLE,
"postsurveyhorizontalwithintolerance" VARCHAR,
"postsurveyobservednorthing_meters" DOUBLE,
"postsurveyobservedeasting_meters" DOUBLE,
"postsurveypublishedbenchmarkid" VARCHAR,
"postsurveypublishednorthing_meters" DOUBLE,
"postsurveypublishedeasting_meters" DOUBLE,
"postsurveypublishedspatialreference" VARCHAR,
"postsurveypublishedprotectedstatus" VARCHAR,
"postsurveypublishedisactive" VARCHAR,
"realtimecorrected" VARCHAR,
"correctionstationcode" VARCHAR,
"correctionstationlabel" VARCHAR,
"correctionstationstatelocationabbr" VARCHAR,
"correctionstationsponsoringagency" VARCHAR,
"correctionservice" VARCHAR,
"receiver" VARCHAR,
"downloadsoftware" VARCHAR,
"postprocesssoftware" VARCHAR
);
Anyone who has the link will be able to view this.