Biodiversity In National Parks

Plant and animal species found in the American national park system

@kaggle.nationalparkservice_park_biodiversity

Parks

@kaggle.nationalparkservice_park_biodiversity.parks

park_code Park Code	park_name Park Name	state State	acres Acres	latitude Latitude	longitude Longitude
ACAD	Acadia National Park	ME	47390	44.35	-68.21
ARCH	Arches National Park	UT	76519	38.68	-109.57
BADL	Badlands National Park	SD	242756	43.75	-102.5
BIBE	Big Bend National Park	TX	801163	29.25	-103.25
BISC	Biscayne National Park	FL	172924	25.65	-80.08
BLCA	Black Canyon of the Gunnison National Park	CO	32950	38.57	-107.72
BRCA	Bryce Canyon National Park	UT	35835	37.57	-112.18
CANY	Canyonlands National Park	UT	337598	38.2	-109.93
CARE	Capitol Reef National Park	UT	241904	38.2	-111.17
CAVE	Carlsbad Caverns National Park	NM	46766	32.17	-104.44


CREATE TABLE parks (
  "park_code" VARCHAR,
  "park_name" VARCHAR,
  "state" VARCHAR,
  "acres" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);