Yellow-billed Cuckoo Inventory At Petrified Forest National Park 2023 - Open Format Dataset
Department of the Interior
@usgov.doi_gov_yellow_billed_cuckoo_inventory_at_petrified_fo_018afe84
Department of the Interior
@usgov.doi_gov_yellow_billed_cuckoo_inventory_at_petrified_fo_018afe84
CREATE TABLE pefo_yellow_billedcuckoo_taxon (
"taxonid" VARCHAR,
"scientificnameid" VARCHAR,
"scientificname" VARCHAR,
"acceptednameusage" VARCHAR,
"kingdom" VARCHAR,
"phylum" VARCHAR,
"class" VARCHAR,
"order" VARCHAR,
"family" VARCHAR,
"genus" VARCHAR,
"subgenus" VARCHAR,
"specificepithet" VARCHAR,
"infraspecificepithet" VARCHAR,
"taxonrank" VARCHAR,
"scientificnameauthorship" VARCHAR,
"vernacularname" VARCHAR,
"nomenclaturalcode" VARCHAR,
"taxonomicstatus" VARCHAR,
"nomenclaturalstatus" VARCHAR,
"taxonremarks" VARCHAR,
"parentnameusage" VARCHAR,
"originalnameusage" VARCHAR,
"nameaccordingto" VARCHAR,
"namepublishedin" VARCHAR,
"namepublishedinyear" VARCHAR,
"higherclassification" VARCHAR,
"acceptednameusageid" VARCHAR,
"parentnameusageid" VARCHAR,
"originalnameusageid" VARCHAR,
"nameaccordingtoid" VARCHAR,
"namepublishedinid" VARCHAR,
"taxonconceptid" VARCHAR
);
CREATE TABLE pefo_yellow_billedcuckoo_surveyevent (
"eventid" VARCHAR,
"parenteventid" VARCHAR,
"samplingprotocol" VARCHAR,
"samplesizevalue" BIGINT,
"samplesizeunit" VARCHAR,
"samplingeffort" VARCHAR,
"startdatetime" TIMESTAMP,
"enddatetime" TIMESTAMP,
"waterfeaturename" VARCHAR,
"countrycode" VARCHAR,
"stateprovince" VARCHAR,
"county" VARCHAR,
"habitatdescription" VARCHAR,
"verbatimlatitude" DOUBLE,
"verbatimlongitude" DOUBLE,
"verbatimlatitudestart" VARCHAR,
"verbatimlongitudestart" VARCHAR,
"verbatimlatitudestop" VARCHAR,
"verbatimlongitudestop" VARCHAR,
"verbatimcoordinatesystem" VARCHAR,
"verbatimsrs" VARCHAR,
"verbatimdatum" VARCHAR,
"coordinateuncertaintyinmeters" BIGINT,
"coordinateprecision" DOUBLE,
"publicdisplay" VARCHAR,
"dataaccess" VARCHAR,
"fieldnumber" VARCHAR,
"fieldnotes" VARCHAR,
"eventremarks" VARCHAR,
"verbatimelevation" VARCHAR,
"verbatimdepth" VARCHAR,
"waterfeaturesubstrate" VARCHAR,
"locationremarks" VARCHAR,
"footprintwkt" VARCHAR,
"footprintsrs" VARCHAR
);
CREATE TABLE pefo_yellow_billedcuckoo_occurrence (
"occurrenceid" VARCHAR,
"eventid" VARCHAR,
"basisofrecord" VARCHAR,
"taxonid" VARCHAR,
"scientificname" VARCHAR,
"recordedby" VARCHAR,
"occurrencestatus" VARCHAR,
"individualcount" BIGINT,
"organismquantity" BIGINT,
"organismquantitytype" VARCHAR,
"publicdisplay" VARCHAR,
"dataaccess" VARCHAR,
"lifestage" VARCHAR,
"sex" VARCHAR,
"reproductivecondition" VARCHAR,
"behavior" VARCHAR,
"covariatesample" VARCHAR,
"preparations" VARCHAR,
"identifiedby" VARCHAR,
"dateidentified" VARCHAR,
"identificationreferences" VARCHAR,
"identificationremarks" VARCHAR,
"identificationqualifier" VARCHAR,
"identificationverificationstatus" VARCHAR,
"occurrenceremarks" VARCHAR,
"materialsampleid" VARCHAR,
"recordnumber" VARCHAR,
"organismremarks" VARCHAR,
"identificationid" VARCHAR
);
Anyone who has the link will be able to view this.