[PILOT] Herpetological Monitoring Surveys For The Southeast Coast Network: 2009-2010 - Data Package
Department of the Interior
@usgov.doi_gov_pilot_herpetological_monitoring_surveys_for_th_165fc82f
Department of the Interior
@usgov.doi_gov_pilot_herpetological_monitoring_surveys_for_th_165fc82f
CREATE TABLE pilot_secn_herpetological_ard_monitoring_survey_2009_2010 (
"parkcode" VARCHAR,
"samploc" VARCHAR,
"parksl" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR,
"survyear" BIGINT,
"speciescallcode" VARCHAR,
"scientificname" VARCHAR,
"scientificname_flag" VARCHAR,
"taxonrank" VARCHAR,
"verbatimidentification" VARCHAR,
"commonname" VARCHAR,
"author" VARCHAR,
"taxonomicserialnumber" BIGINT,
"occurrencestatus" VARCHAR,
"decimallatitude" VARCHAR,
"decimallongitude" VARCHAR,
"coordinate_flag" VARCHAR,
"geodeticdatum" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE pilot_secn_herpetological_ves_monitoring_survey_2009_2010 (
"parkcode" VARCHAR,
"samploc" VARCHAR,
"parksl" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR,
"survyear" BIGINT,
"startdate" TIMESTAMP,
"starttime" VARCHAR,
"speciescode" VARCHAR,
"scientificname" VARCHAR,
"scientificname_flag" VARCHAR,
"taxonrank" VARCHAR,
"verbatimfamily" VARCHAR,
"verbatimorder" VARCHAR,
"verbatimidentification" VARCHAR,
"commonname" VARCHAR,
"verbatimcommonname" VARCHAR,
"author" VARCHAR,
"taxonomicserialnumber" VARCHAR,
"collector" VARCHAR,
"count" BIGINT,
"decimallatitude" VARCHAR,
"decimallongitude" VARCHAR,
"coordinate_flag" VARCHAR,
"geodeticdatum" VARCHAR,
"detectionmethod" VARCHAR,
"nativity" VARCHAR,
"metamorphicstage" VARCHAR,
"temperatureinfahrenheit" VARCHAR,
"winddirection" VARCHAR,
"skycode" VARCHAR,
"windspeedinmilesperhour" VARCHAR,
"noisecode" VARCHAR,
"precipitation" VARCHAR,
"soilmoistureinpercent" DOUBLE,
"relativehumidityinpercent" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.