Critical Habitats

State of Connecticut

@usgov.state_of_connecticut_critical_habitats_09741

Table List

1 table(265.85 KB)

Table 1

@usgov.state_of_connecticut_critical_habitats_09741.table_1

265.85 KB
2972 rows
27 columns

objectid_1 OBJECTID 1	sitename SITENAME	commsiteid COMMSITEID	commtype COMMTYPE	commsubtyp COMMSUBTYP	acreage ACREAGE	data_methd DATA METHD	data_sourc DATA SOURC	data_equip DATA EQUIP	data_edtr DATA EDTR	assocdata ASSOCDATA	speciesdat SPECIESDAT	comments COMMENTS	elcode ELCODE	eonmbr EONMBR	is_qaqc IS QAQC	gps_pdop GPS PDOP	gps_hdop GPS HDOP	gps_hrzpr GPS HRZPR	group_legend Group Legend	centroid_x Centroid X	centroid_y Centroid Y	comlabel COMLABEL	shape_area Shape, Area	shape_length Shape, Length
2973	Hazel Meadow Pond		Poor Fen	Shrub Thicket	6.0450195	Aerial Photo Interpretation	CT 2004 Black and White Ortho Photo	Not Applicable	CT DEP NHS	Farmington Valley Biodiversity Project, 2002	Vaccinium corymbosum-Rhododendrom viscosum comm;Decodon verticillatus semi-pmnt flood. shrblands;Nuphar variegatum hydromorphic rootd veg;Chamaedaphne calyculata	tall Chamaedaphne	CP2C2A0000	17	true	Not Applicable	Not Applicable	Not Applicable	Palustrine Non-forested	980387.663937	875120.113912	PF	263321.049316406	2534.09601957975
2974	Matianuck Sand Dunes Natural Area Preserve	1	Sand Barren	Pitch Pine Scrub	0.56013302	Aerial Photo Interpretation	CT 2004 Black and White Ortho Photo	Not Applicable	CT DEP NHS	Matianuck Provisional Classification Mapping of Vegetation and Natural Communities, 2004	Pinus rigida - oak forest		CT1L100000	0	true	Not Applicable	Not Applicable	Not Applicable	Terrestrial Non-forested	1019431.31354	856716.994222	SB	24399.3942871094	656.142401503837
2975	Matianuck Sand Dunes Natural Area Preserve	2	Sand Barren	Pitch Pine Scrub	2.49608744	Aerial Photo Interpretation	CT 2004 Black and White Ortho Photo	Not Applicable	CT DEP NHS	Matianuck Provisional Classification Mapping of Vegetation and Natural Communities, 2004	Pinus rigida-oak forest surrounding Pinus rigida woodland	restorable to rare or uncommon type; part of larger sand barren complex, rare invert potential	CT1L100000	0	true	Not Applicable	Not Applicable	Not Applicable	Terrestrial Non-forested	1019204.91012	856275.107638	SB	108729.569152832	1437.38879427672
2976	McLean Bogs	1	Poor Fen	Dwarf Shrub	2.39998545	Aerial Photo Interpretation	CT 2004 Black and White Ortho Photo	Not Applicable	CT DEP NHS	Farmington Valley Biodiversity Project, 2002	Chamaedaphne calyculata-Picea mariana community; Vaccinium corymbosum-Rhododendron viscosum community	Low shrubby bog. Picea mariana. In good stable shape. Heavy deer browse noted on Kalmia polifolia (Moorhead 2002)	CP2C2A0000	7	true	Not Applicable	Not Applicable	Not Applicable	Palustrine Non-forested	981677.814572	896718.592368	PF	104543.366577148	1293.66154289063
2977	McLean Bogs	2	Poor Fen	Dwarf Shrub	0.82329484	Aerial Photo Interpretation	CT 2004 Black and White Ortho Photo	Not Applicable	CT DEP NHS	Farmington Valley Biodiversity Project, 2002	Rhododendron canadense, Picea mariana	Openly tall and low shrubby bog, abundant Woodwardia virginica. Rhodora codominant subshrub with Chamaedaphne. Dominant tall and low shrubs are Pinus strobus and Tusga.	CP2C2A0000	7	true	Not Applicable	Not Applicable	Not Applicable	Palustrine Non-forested	981214.596994	896341.309986	PF	35862.723449707	814.247487892093
2978	Congamond Bogs	11	Poor Fen	Shrub Thicket	1.72574491	Aerial Photo Interpretation	CT 1990 Black and White Ortho Photo	Not Applicable	CT DEP NHS	Farmington Valley Biodiversity Project, 2002			CP2C2A0000	33	true	Not Applicable	Not Applicable	Not Applicable	Palustrine Non-forested	997385.335978	931588.866459	PF	75173.4486083984	1231.70947884806
2979	Congamond Bogs	8	Poor Fen	Dwarf Shrub	1.34168796	Aerial Photo Interpretation	CT 1990 Black and White Ortho Photo	Not Applicable	CT DEP NHS	Farmington Valley Biodiversity Project, 2002	Larix and Picea mariana, Gaylussacia frondosa, Vaccinium oxycoccos; potential for rare invert habitat		CP2C2A0000	33	true	Not Applicable	Not Applicable	Not Applicable	Palustrine Non-forested	997127.292531	929179.19641	PF	58443.9275512695	966.947334152972
2980	Congamond Bogs	7	Poor Fen	Dwarf Shrub	1.27409152	Aerial Photo Interpretation	CT 1990 Black and White Ortho Photo	Not Applicable	CT DEP NHS	Farmington Valley Biodiversity Project, 2002	G3 (globally vulnerable) community, high apparent ecological integrity, stable		CP2C2A0000	33	true	Not Applicable	Not Applicable	Not Applicable	Palustrine Non-forested	999320.540441	931499.908632	PF	55499.426574707	1000.62682118069
2981	Congamond Bogs	2	Poor Fen	Dwarf Shrub	0.1799652	Aerial Photo Interpretation	CT 1990 Black and White Ortho Photo	Not Applicable	CT DEP NHS	Farmington Valley Biodiversity Project, 2002	G3 comm in good shape,rare to uncommon spp habitat;Andromeda glaucophylla,Utricularia cornuta,Picea mariana		CP2C2A0000	33	true	Not Applicable	Not Applicable	Not Applicable	Palustrine Non-forested	998236.312623	932458.2056	PF	7839.28424072266	578.818745926436
2982	Congamond Bogs	3	Poor Fen	Dwarf Shrub	0.15602175	Aerial Photo Interpretation	CT 1990 Black and White Ortho Photo	Not Applicable	CT DEP NHS	Farmington Valley Biodiversity Project, 2002	G3 comm in good shape,rare to uncommon spp habitat;Andromeda glaucophylla,Utricularia cornuta,Picea mariana		CP2C2A0000	33	true	Not Applicable	Not Applicable	Not Applicable	Palustrine Non-forested	998443.246592	932604.517315	PF	6796.30773925781	489.180115941764


CREATE TABLE table_1 (
  "objectid_1" BIGINT,
  "sitename" VARCHAR,
  "commsiteid" BIGINT,
  "commtype" VARCHAR,
  "commsubtyp" VARCHAR,
  "acreage" DOUBLE,
  "lastvisit" VARCHAR,
  "data_methd" VARCHAR,
  "data_sourc" VARCHAR,
  "data_equip" VARCHAR,
  "data_edtr" VARCHAR,
  "data_date" VARCHAR,
  "assocdata" VARCHAR,
  "speciesdat" VARCHAR,
  "comments" VARCHAR,
  "elcode" VARCHAR,
  "eonmbr" VARCHAR,
  "is_qaqc" BOOLEAN,
  "gps_pdop" VARCHAR,
  "gps_hdop" VARCHAR,
  "gps_hrzpr" VARCHAR,
  "group_legend" VARCHAR,
  "centroid_x" DOUBLE,
  "centroid_y" DOUBLE,
  "comlabel" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);