Table 2.

Attribute crosswalk table for TWIG (Treatment and Wildfire Interagency Geodatabase) and its source databases.

Attribute Name	Variable Name	NFPORS/IFPRS Source**	FACTS HFT Source	FACTS CA Source
Treatment Name	name	trt_nm	activity_sub_unit_name	name
Unique Treatment ID	id	{nfporsid}-{trt_id}	activity_cn	event_cn
Identifier Database	identifier_database	"NFPORS"	"FACTS Hazardous Fuels"	"FACTS Common Attributes"
Date Current	date_current	modifiedon	etl_modified_date	act_modified_date
Actual Completion Date	actual_completion_date	act_comp_dt	date_completed	date_completed
Acres	acres	gis_acres	gis_acres	gis_acres
Activity code	activity_code	N/A	activity_code	activity_code
Activity	activity	N/A	activity	activity
Treatment Type	type	type_name	treatment_type	nfpors_treatment
Category	category	category	category	nfpors_category
IFPRS Category	ifprs_category	type*	activity*	activity* OR method*
IFPRS Type	ifprs_type	type*	activity*	activity* OR method*
Fund Code	fund_code	isbil*	fund_code	fund_code
Cost Per UOM	cost_per_uom	N/A	cost_per_uom	cost_per_unit
Unit of Measure	uom	"ACRES"	uom	uom
State	state	st_addr	state_abbr	state_abbr
Treatment Date	treatment_date	act_comp_dt OR plan_int_dt OR col_date	date_completed OR date_planned	date_completed OR act_created_date
Date Source	date_source	act_comp_dt OR plan_int_dt OR col_date*	date_completed OR date_planned*	date_completed OR act_created_date*
Fund source	fund_source	isbil*	fund_code*	fund_codes*
Global identifier	globalid	N/A	N/A	N/A
Total Cost	total_cost	N/A	cost_per_uom, uom*	cost_per_unit, uom*
Error flags	errors	[multiple]*	[multiple]*	[multiple]*

*Values are derived (not copied) from this field; see main text for details. **NFPORS (National Fire Plan Operations and Reporting System) is the current data source, but IFPRS (Interion Fuels and Post-fire Reporting System) will replace NFPORS in the coming months. See https://reshapewildfire.org for updates.