Timber Harvests (Feature Layer)

Department of Agriculture

@usgov.usda_gov_timber_harvests_feature_layer_ea8be

Table List

1 table(72.78 MB)

Table 1

@usgov.usda_gov_timber_harvests_feature_layer_ea8be.table_1

72.78 MB
823754 rows
70 columns

objectid OBJECTID	admin_forest_code ADMIN FOREST CODE	admin_region_code ADMIN REGION CODE	admin_forest_name ADMIN FOREST NAME	proclaimed_forest_code PROCLAIMED FOREST CODE	admin_district_name ADMIN DISTRICT NAME	home_org HOME ORG	activity_unit_org ACTIVITY UNIT ORG	suid SUID	facts_id FACTS ID	subunit SUBUNIT	subunit_cn SUBUNIT CN	au_name AU NAME	subunit_name SUBUNIT NAME	subunit_size SUBUNIT SIZE	sale_name SALE NAME	unit_id UNIT ID	activity_cn ACTIVITY CN	activity_unit_cn ACTIVITY UNIT CN	activity_code ACTIVITY CODE	activity_name ACTIVITY NAME	treatment_type TREATMENT TYPE	nbr_units_planned NBR UNITS PLANNED	uom UOM	nbr_units_accomplished NBR UNITS ACCOMPLISHED	date_planned DATE PLANNED	date_awarded DATE AWARDED	date_completed DATE COMPLETED	fy_planned FY PLANNED	fy_awarded FY AWARDED	fy_completed FY COMPLETED	fund_codes FUND CODES	nepa_project_id NEPA PROJECT ID	nepa_doc_name NEPA DOC NAME	method_desc METHOD DESC	equipment_desc EQUIPMENT DESC	implementation_project_name IMPLEMENTATION PROJECT NAME	land_suitability_class_code LAND SUITABILITY CLASS CODE	land_suitability_class_desc LAND SUITABILITY CLASS DESC	productivity_class_code PRODUCTIVITY CLASS CODE	productivity_class_desc PRODUCTIVITY CLASS DESC	ownership_code OWNERSHIP CODE	ownership_desc OWNERSHIP DESC	aspect ASPECT	elevation ELEVATION	slope SLOPE	state_abbr STATE ABBR	subunit_uom SUBUNIT UOM	crc_value CRC VALUE
319792	4	1	Idaho Panhandle National Forests	106	Coeur d'Alene River Ranger District	10403	10401	010401A170400002002	A170400002	2	338521010602		SLATE CREEK #1	14	SLATE CREEK	001	AC77124701035910359	AU135940010359	4231	Salvage Cut (intermediate treatment, not regeneration)	Salvage cut (interme	14	ACRES	14	Sun Jul 01 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 01 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 01 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	1979	1979	1979	XXXX	NOT REQD	DEFAULT FOR NOT REQUIRED	Not Applicable	NA		500	Timber Production Primary Emphasis	5	50-84 cubic feet per acre per year	FS	USDA FOREST SERVICE	N	5000	38	ID	ACRES	00000000E4115414
823537	3	1	Bitterroot National Forest	103	Sula Ranger District	10303	10303	010303A180400041000	A180400041	0	17698010374		TSMRS LEGACY STAND	23	EAST FORK SPRINGER	4	AC35654701037410374	AU72623010374	4131	Shelterwood Establishment Cut (with or without leave trees) (EA/RH/NFH)	Shelterwood cut (EA/	23	ACRES	23	Thu Jan 01 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 01 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 01 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	1987	1987	1987	XXXX	NOT REQD	DEFAULT FOR NOT REQUIRED	Not Applicable	NA		500	Timber Production Primary Emphasis	5	50-84 cubic feet per acre per year	FS	USDA FOREST SERVICE	W	6200	33	MT	ACRES	00000000C890E28F
823538	3	1	Bitterroot National Forest	103	West Fork Ranger District	10304	10304	010304A330600312000	A330600312	0	1356541010602	FLAT BASIN	FLAT BASIN #154		FLAT BASIN RE OFFER	154	6751977010602	6797075010602	4132	Seed-tree Seed Cut (with and without leave trees) (EA/RH/NFH)	Seed-tree seed cut (	25	ACRES		Mon May 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)			2023			XXXX	55744	(PALS)MUD CREEK VEGETATION MANAGEMENT PROJECT	Single Span Skyline	Single span skyline	MUD CREEK PROJECT	500	Timber Production Primary Emphasis	4	85-119 cubic feet per acre per year	FS	USDA FOREST SERVICE	NE	5600	50	MT	ACRES	000000002ABA4F0D
823539	3	1	Bitterroot National Forest	103	Sula Ranger District	10303	10303	010303A050100060000	A050100060	0	14332010374		TSMRS LEGACY STAND	12	ELK POINT 2	387	AC33411201037410374	AU69257010374	4131	Shelterwood Establishment Cut (with or without leave trees) (EA/RH/NFH)	Shelterwood cut (EA/	12	ACRES	12	Sun Sep 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Sep 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Sep 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	2002	2002	2002	XXXX	NOT REQD	DEFAULT FOR NOT REQUIRED	Not Applicable	NA		500	Timber Production Primary Emphasis	5	50-84 cubic feet per acre per year	FS	USDA FOREST SERVICE	SE	5300	10	MT	ACRES	00000000F35B26DD
823540	3	1	Bitterroot National Forest	103	West Fork Ranger District	10304	10304	010304A330600008000	A330600008	0	22879010374		TSMRS LEGACY STAND	26	MUDDYONE	018	AC37532001037410374	AU78228010374	4141	Shelterwood Removal Cut (EA/NRH/FH)	Shelterwood final re	26	ACRES	26	Fri Nov 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 01 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 01 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	1986	1988	1988	XXXX	NOT REQD	DEFAULT FOR NOT REQUIRED	Tractor Logging	Ground Base Skidder *		500	Timber Production Primary Emphasis	5	50-84 cubic feet per acre per year	FS	USDA FOREST SERVICE	SE	6100	55	MT	ACRES	000000002AD53362
823541	3	1	Bitterroot National Forest	103	West Fork Ranger District	10304	10304	010304A300700003000	A300700003	0	22366010374		TSMRS LEGACY STAND	21			AC37435101037410374	AU77715010374	4131	Shelterwood Establishment Cut (with or without leave trees) (EA/RH/NFH)	Shelterwood cut (EA/	21	ACRES	21	Fri Oct 01 1965 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 01 1965 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 01 1965 00:00:00 GMT+0000 (Coordinated Universal Time)	1966	1966	1966	XXXX	NOT REQD	DEFAULT FOR NOT REQUIRED	Not Applicable	NA		500	Timber Production Primary Emphasis	4	85-119 cubic feet per acre per year	FS	USDA FOREST SERVICE	E	5100	32	MT	ACRES	0000000087CB533D
823542	3	1	Bitterroot National Forest	103	West Fork Ranger District	10304	10304	010304A360300002000	A360300002	0	23464010374		TSMRS LEGACY STAND	5			AC37697501037410374	AU78813010374	4113	Stand Clearcut (EA/RH/FH)	Stand Clearcutting(E	5	ACRES	5	Sun Oct 01 1961 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 01 1961 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Oct 01 1961 00:00:00 GMT+0000 (Coordinated Universal Time)	1962	1962	1962	XXXX	NOT REQD	DEFAULT FOR NOT REQUIRED	Not Applicable	NA		500	Timber Production Primary Emphasis	6	20-49 cubic feet per acre per year	FS	USDA FOREST SERVICE	NE	5800	55	MT	ACRES	000000005B270BF6
823543	3	1	Bitterroot National Forest	103	West Fork Ranger District	10304	10304	010304A240100219000	A240100219	0	21470010374		TSMRS LEGACY STAND	11	LEGACY SALE W/O NAME		AC37152201037410374	AU76819010374	4131	Shelterwood Establishment Cut (with or without leave trees) (EA/RH/NFH)	Shelterwood cut (EA/	11	ACRES	11	Sun Jun 01 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 01 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 01 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	1980	1980	1980	XXXX	NOT REQD	DEFAULT FOR NOT REQUIRED	Not Applicable	NA		500	Timber Production Primary Emphasis	5	50-84 cubic feet per acre per year	FS	USDA FOREST SERVICE	E	4900	46	MT	ACRES	0000000097AE0673
823544	3	1	Bitterroot National Forest	103	West Fork Ranger District	10304	10304	010304A240400041000	A240400041	0	21589010374		TSMRS LEGACY STAND	8	CHRISTISEN-BAKER		AC37201701037410374	AU76938010374	4231	Salvage Cut (intermediate treatment, not regeneration)	Salvage cut (interme	8	ACRES	8	Sat Jan 01 1983 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	1983	1986	1986	XXXX	NOT REQD	DEFAULT FOR NOT REQUIRED	Helicopter	Helicopter logging		200	Non-Forest Land			FS	USDA FOREST SERVICE	SE	6000	40	MT	ACRES	00000000C921BB5B
823545	3	1	Bitterroot National Forest	103	Darby Ranger District	10302	10302	010302A510300089000	A510300089	0	10704010374		TSMRS LEGACY STAND	11	BEAR TIMBER SALE	3	AC30681301037410374	AU65629010374	4231	Salvage Cut (intermediate treatment, not regeneration)	Salvage cut (interme	11	ACRES	11	Tue May 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue May 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue May 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	2001	2001	2001	XXXX	NOT REQD	DEFAULT FOR NOT REQUIRED	Not Applicable	NA		500	Timber Production Primary Emphasis	5	50-84 cubic feet per acre per year	FS	USDA FOREST SERVICE	SW	6200	62	MT	ACRES	00000000F9EF8E57


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "admin_forest_code" BIGINT,
  "admin_region_code" BIGINT,
  "admin_forest_name" VARCHAR,
  "proclaimed_forest_code" BIGINT,
  "admin_district_name" VARCHAR,
  "admin_district_code" DOUBLE,
  "home_org" BIGINT,
  "activity_unit_org" BIGINT,
  "suid" VARCHAR,
  "facts_id" VARCHAR,
  "subunit" VARCHAR,
  "subunit_cn" BIGINT,
  "au_name" VARCHAR,
  "subunit_name" VARCHAR,
  "subunit_size" DOUBLE,
  "sale_name" VARCHAR,
  "unit_id" VARCHAR,
  "activity_cn" VARCHAR,
  "activity_unit_cn" VARCHAR,
  "activity_code" BIGINT,
  "activity_name" VARCHAR,
  "treatment_type" VARCHAR,
  "nbr_units_planned" DOUBLE,
  "uom" VARCHAR,
  "nbr_units_accomplished" DOUBLE,
  "date_planned" TIMESTAMP,
  "date_awarded" TIMESTAMP,
  "date_completed" TIMESTAMP,
  "fy_planned" BIGINT,
  "fy_awarded" DOUBLE,
  "fy_completed" DOUBLE,
  "fund_codes" VARCHAR,
  "cost_per_uom" DOUBLE,
  "nepa_project_id" VARCHAR,
  "nepa_doc_name" VARCHAR,
  "nepa_project_cn" DOUBLE,
  "method_code" DOUBLE,
  "method_desc" VARCHAR,
  "equipment_code" DOUBLE,
  "equipment_desc" VARCHAR,
  "implementation_project_name" VARCHAR,
  "implementation_project_number" VARCHAR,
  "implementation_project_type" VARCHAR,
  "work_agent_codes" VARCHAR,
  "land_suitability_class_code" VARCHAR,
  "land_suitability_class_desc" VARCHAR,
  "productivity_class_code" DOUBLE,
  "productivity_class_desc" VARCHAR,
  "ownership_code" VARCHAR,
  "ownership_desc" VARCHAR,
  "aspect" VARCHAR,
  "elevation" DOUBLE,
  "slope" DOUBLE,
  "state_abbr" VARCHAR,
  "watershed_code" VARCHAR,
  "subunit_uom" VARCHAR,
  "stage" VARCHAR,
  "stage_desc" VARCHAR,
  "data_source_code" VARCHAR,
  "data_source_desc" VARCHAR,
  "accuracy" VARCHAR,
  "crc_value" VARCHAR,
  "uk" VARCHAR,
  "edw_insert_date" VARCHAR,
  "etl_modified" VARCHAR,
  "rev_date" VARCHAR,
  "gis_acres" VARCHAR,
  "shapearea" VARCHAR,
  "shapelen" VARCHAR
);