Technical_Exhibit_2_Data_Dictionary.xlsx

XLSX spreadsheet 609 KB Posted Aug 3, 2017

Attached to: History of Dredge Upland Placement Sites
Solicitation number: W9127N-17-Q-0060
Issued by: Department of the Army Corps of Engineers Engineering District Portland

About this file

From the source

Technical Exhibit 2 Data Dictionary

View the file

Other files

File	Type	Posted
QA2.pdf	PDF	Aug 17, 2017
Amendment_1.pdf	PDF	Aug 17, 2017
Q&A_1.pdf	PDF	Aug 11, 2017
Attachment_2_Deliverables_Schedule.pdf	PDF	Aug 3, 2017
Attachment_1_PRS.pdf	PDF	Aug 3, 2017
Technical_Exhibit_3_Placement_Sites.docx	DOCX document	Aug 3, 2017
Technical_Exhibit_1_Map.pdf	PDF	Aug 3, 2017
Solicitation_W9127N-17-Q-0060.pdf	PDF	Aug 3, 2017
Attachment_3_QASP.pdf	PDF	Aug 3, 2017

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Feature_List

Feature Dataset Name	Feature_List
Alias
Table Definition	A list of feature classes and tables in the NWW Archaeology database with summary explanations.
Population
SDSFIE3	Features	Definition	Default Geometry	Permissible Geometry	Color Code
No - NWW	ArchaeologicalDistricts_A	A polygon feature that contains the location of an archaeological district. Archaeological districts are comprised of contributing sites that have been proposed, determined eligible, or listed on the NRHP. Many times the NPS Historic Places information will not contain locational information for archaeological districts for the purposes of site protection.	Area/Polygon	Area/Polygon	Purple: DoD, SDSFIE3
Yes	ArchaeologicalSite_A	The location of a recorded archaeological site. 'A' suffix denotes area or polygons, 'P' denotes points.	Area/Polygon	Area/Polygon	Red: USACE, NWW
No - NWW	ArchSiteCondition_P	Points recording condition assessment information related to ArchaeologicalSite_A.	N/A	N/A	Blue: SRI
Yes	CemeteryOrBurialSite_A	A place or a ground set apart for the burial of the dead. Can contain an area representing a graveyard, or a point feature containing one or more graves.	Area/Polygon	Area/Polygon	White: Arc
No - NWW	CulturalLandClass_A	Ancillary Archaeologic polygon features (Area of potential effect, cultural resource potential, cultural restricted access, Corps owned land for FCRPS inventories, etc.)	Area/Polygon	Area/Polygon
No - NWW	CulturalMaterial_A	A polygon feature that contains an object of archaeological significance. 'P' suffix denotes points, 'L' denotes lines, 'A' denotes area/polygons.	Area/Polygon	Area/Polygon
No - NWW	CulturalMaterial_L	A line feature that contains an object of archaeological significance. 'P' suffix denotes points, 'L' denotes lines, 'A' denotes area/polygons.	Line	Line
No - NWW	CulturalMaterial_P	A point feature that contains an object of archaeological significance. 'P' suffix denotes points, 'L' denotes lines, 'A' denotes area/polygons.	Point	Point
No - NWW	CulturalReports	Non-spatial table used to relate Investigation_P, Investigation_L, & Investigation_A to ArchaeologicalSite_P and ArchaeologicalSite_A via ArchSite_Supplement.	N/A	N/A
Yes	CulturalSurvey_A	The area in which a cultural resource inventory has been conducted.	Area/Polygon	Area/Polygon
No - NWW	Excavation_P	The location of a shovel test or excavation	Point	Point
No - NWW	Investigation_A	The location of an area or polygon feature that supports archaeological investigations. 'P' suffix denotes points, 'L' denotes lines, 'A' denotes area/polygons.	Area/Polygon	Area/Polygon
No - NWW	Investigation_L	The location of a line feature that supports archaeological investigations. 'P' suffix denotes points, 'L' denotes lines, 'A' denotes area/polygons.	Line	Line
No - NWW	Investigation_P	The location of a point feature that supports archaeological investigations. 'P' suffix denotes points, 'L' denotes lines, 'A' denotes area/polygons.	Point	Point
Yes	NativeAffiliation_A	Locations of current or prior native use, occupation, or interest, to assist in consultation. This may include but is not limited to: reservations, treaty lands, trust lands, ceded lands, lands identified during consultation, and areas of customary and traditional use.	Area/Polygon	Area/Polygon
No - NWW	NativePlants_A	Indicates existence of a species by the geographically described geometry either currently, historically, or the species is being recruited into the range	Area/Polygon	Area/Polygon
No - NWW	NationalRegistryOfHistoricPlaces_P	Excerpt from National Park Service's Historic Places database. Includes basic attributes plus geographic information such as UTM coordinates for points, centroids and polygons.	Area/Polygon	Area/Polygon
No - NWW	ReportsCultSurvAreaJoin	Non-spatial table establishing a many to many relationship between CulturalReports and CulturalSurveyArea.	N/A	N/A
No - NWW	TraditionalCultResAttributes	Amplifying information about Traditional Cultural Resource_A features.	N/A	Non-spatial table
Yes	TraditionalCulturalResource_A	The location of a recorded traditional cultural resource, including Traditional Cultural Property and/or Reserved Treaty Rights.	Area/Polygon	Area/Polygon, Line, Point

Domains

Domain Tables:
SDSFIE3	Domain Name	Domain Name Description	Code Value	Code Value Description
No - NWW	archaeologicalDistrictType	Category of archaeological district.	Archaeological District	Archaeological District
			Historic District	Historic District
			Historic Structure	Historic Structure
			Other	Other
No - NWW	Boolean	Constrains answers to these values	YES	Yes
			NO	No
			UNK	Unknown
No - NWW	CultLandClassSubtype	Indicates type of cultural land: Potential, Restricted Access, Area of Potential Effects, CorpsOwnedLand (for FCRPS inventories)	0	Archaeology APE
			1	Cultural Restricted Access Area
			2	Area of Potential Effects
			3	Corps Owned Land (for FCRPS inventories)
			5	Fire Department
			6	Fire District
			7	Potential Disposal
			8	TCP/Built Environment APE
			9	Other
No - NWW	CulturalDataStatus	Indication of quality/validity of data.	Current	Current
			Legacy	Legacy
No - NWW	CulturalDisposal	Reference to what Civil Works project the archaeological site was part of before it was disposed of.	Disposal-DWA	Disposal-Dworshak
			Disposal-HLD	Disposal-Ice Harbor
			Disposal-LGA	Disposal-Little Goose
			Disposal-LLA	Disposal-Lower Granite
			Disposal-LMA	Disposal-Lower Monumental
			Disposal-MNA	Disposal-McNary
			Disposal-Other	Disposal-Other
			NA	NA
No - NWW	CulturalEra	General date of archaeological site/feature/object.	Historic	Historic
			Modern	Modern
			Precontact	Precontact
			Unknown	Unknown
No - NWW	CulturalMonitoringInterval	Desribes the required frequency of evaluating the site.	Annual	Annual
			Five years	Five years
			Not required	Not required
			Occasional	Occasional
			Seasonal	Seasonal
			Three years	Three years
			Two years	Two years
			Unknown	Unknown
No - NWW	CulturalSiteCondition	NWW evaluation of site's condition	Good	Good
			Fair	Fair
			Poor	Poor
			Destroyed	Destroyed
			Inundated - Uncertain	Inundated - Uncertain
			Not Relocated - Unknown	Not Relocated - Unknown
			Unknown	Unknown
No - NWW	CulturalSiteImpacts	Degree a hazard impacts an archaeological site.	No	No
			Yes-adjacent site	Yes-adjacent site
			Yes-within site	Yes-within site
No - NWW	CulturalSurveyInterval	Amount of spacing between transects or shovel tests.	Surface Intensive	Surface Intensive
			Intensive	Intensive
			Recon	Recon
			N/A	N/A
			Unsurvayable	Unable to survey due to visibility, slope, or access issues
No - NWW	CulturalVisitType	Describes the purpose of the site visit.	Excavation	Excavation
			Inadvertant Discovery	Inadvertant Discovery
			Monitoring-Condition	Monitoring-Condition
			No Visit-Research Only	No Visit-Research Only
			Other	Other
			Site Documentation	Site Documentation
			Stabilization	Stabilization
			Testing	Testing
			Topographic Survey	Topographic Survey
No - NWW	dataSource	Indicates equipment and means of digitizing GIS features.	1	GPS - Recreation Grade Data (e.g. Garmin)
			2	GPS - Resource Grade Data (e.g. Trimble)
			3	GPS - Survey Grade Data (e.g. extremely high quality Trimble, not currently used by most archaeologists)
			10	Digitized - scale at <=24k
			11	Digitized - scale at <=100k
			13	Digitized - scale at <=250k
			14	Digitized - digital orthophoto
			20	Survey Plat
			21	Geographic Coordinate Database (GCDB)
			22	Cadastral Information (COGO)
			23	Monument Map Sheet
			24	CADD
			30	Remote Sensing Data - Base Level (ex LiDAR)
			31	Remote Sensing Data - Mid Level
			32	Remote Sensing Data - Broad Level
			33	Remote Sensing Data - National Level
			40	SONAR - Single Beam
			41	SONAR - Multibeam
			42	SONAR - Custom
			43	LIDAR - Green
			50	Analysis Derived Data
			51	Field Form/Computer (coordinates entered from a field form)
			52	Digital Transfer - From Other Entity
			53	Geography interpreted from non-quantitative narrative
			54	Site form
No-NWW	ExcavationFinding	Artifacts or features were found or not found in unit	Positive	Positive
			Negative	Negative
			Unknown	Unknown
No-NWW	ExcavationType	Type of excavation	Shovel or Auger	Shovel or Auger
			Excavation Unit(s)	Excavation Unit(s)
			Backhoe Trench	Backhoe Trench
			Surface Scrape	Surface Scrape
			Cutbank Scrape	Cutbank Scrape
Yes	HistoricalStatusCode	List of possible status' for National Register eligibility.	Corps - Eligible	Corps - Eligible
			Corps - Not Eligible	Corps - Not Eligible
			Eligible - Contributing	Eligible - Contributing
			Eligible - Individual	Eligible - Individual
			Inundated - Unevaluated	Inundated - Unevaluated
			Isolated Find	Isolated Find
			Listed - Contributing	Listed - Contributing
			Listed - Individual	Listed - Individual
			Listed - NHL	Listed - NHL
			N/A	N/A
			Not Eligible	Not Eligible
			Unevaluated	Unevaluated
No - NWW	HistoricArtifact_P	Historic artifact - cultural point	Bone (non-human)	Bone (non-human)
			Bottle/Jar	Bottle/Jar
			Can	Can
			Ceramic	Ceramic
			Glass	Glass
			Machinery	Machinery
			Metal	Metal
			Nail	Nail
			Other	Other
			Pipe	Pipe
			Wood	Wood
No - NWW	HistoricFeature_A	Historic Feature - cultural polygon	Cemetery/burial	Cemetery/burial
			Other	Other
			Platform	Platform
			Refuse Scatter	Refuse Scatter
			Structure - Collapsed	Structure - Collapsed
			Structure - Foundation	Structure - Foundation
			Structure - Standing	Structure - Standing
No - NWW	HistoricFeature_L	Historic feature - cultural line	Canal	Canal
			Fence	Fence
			Foundation	Foundation
			Levee	Levee
			Other	Other
			Railroad	Railroad
			Railroad grade	Railroad grade
			Retaining Wall	Retaining Wall
			Rock Alignment	Rock Alignment
			Trail/Road	Trail/Road
No - NWW	HistoricFeature_P	Historic feature - cultural point	Cairn	Cairn
			Depression	Depression
			Gate	Gate
			Grave	Grave
			Hearth/Fire Ring	Hearth/Fire Ring
			Historic Rock Art/Inscription	Historic Rock Art/Inscription
			Monument/Statue	Monument/Statue
			Other	Other
			Post	Post
			Refuse Scatter	Refuse Scatter
			Structure	Structure
			Tree Stump	Tree Stump
			Utility	Utility
			Vehicle	Vehicle
No - NWW	HistoricSiteType	Type of archaeological features from the Historic period.	Agriculture	Agriculture
			Cemetery/burial	Cemetery/burial
			Debris Scatter/concentration	Debris Scatter/concentration
			Historic Inscription	Historic Inscription
			Historic Property	Historic Property
			Hunting Related	Hunting Related
			Industry	Industry
			Isolated Find	Isolated Find
			Landscape Other	Landscape Other
			NA	NA
			Residential	Residential
			Rock Feature	Rock Feature
			Structure Other	Structure Other
			Structure Unknown	Structure Unknown
			Townsite	Townsite
			Trail	Trail
			Transportation	Transportation
			Unknown	Unknown
No - NWW	InvestigationType_A	Investigation type - polygon	Bank Stabilization	Bank Stabilization
			Development	Development
			Disturbed Area	Disturbed Area
			Excavation	Excavation
			Fire	Fire
			GPR Grid	Ground Penetrating Radar Grid
			Proposed APE	Proposed APE
			Other	Other
No - NWW	InvestigationType_L	Investigation type - line	Backhoe Trench	Backhoe Trench
			Bank Stabilization	Bank Stabilization
			Canal	Canal
			Cut bank	Cut bank
			Ditch	Ditch
			Drainage/Wash	Drainage/Wash
			Fence	Fence
			Foundation	Foundation
			Levee	Levee
			Other	Other
			Path/Roads/Trail	Path/Roads/Trail
			Railroad	Railroad
			Retaining Wall	Retaining Wall
			Rip-Rap	Rip-Rap
			Road	Road
			Shoreline	Shoreline
			Survey Transect	Survey Transect
			Utility - Above Ground	Utility - Above Ground
			Utility - Buried	Utility - Buried
No - NWW	InvestigationType_P	Investigation type - point	APE	Area of Potential Effect
			Backhoe Trench	Backhoe Trench
			Bank Stabilization	Bank Stabilization
			Boundary Point	Boundary Point
			Cadastral	Cadastral
			Dock	Dock
			Erosion Point	Erosion Point
			Fencepost	Fencepost
			GPR Grid Corner	GPR Grid Corner
			Other	Other
			Photo Point	Photo Point
			Sign	Sign
			Structure	Structure
			Trash	Trash
			Tree	Tree
No - NWW	ModernArtifact_P	Modern artifact - cultural point	Modern Bottle/Jar	Modern Bottle/Jar
			Modern Can	Modern Can
			Modern Cartridge	Modern Cartridge
			Modern Other	Modern Other
No - NWW	ModernFeature_A	Modern feature - cultural polygon	Modern Structure	Modern Structure
			Modern Disturbed Area	Modern Disturbed Area
			Modern Other	Modern Other
No - NWW	ModernFeature_L	Modern feature - cultural line	Modern Canal	Modern Canal
			Modern Cut Bank	Modern Cut Bank
			Modern Fence	Modern Fence
			Modern Foundation Edge	Modern Foundation Edge
			Modern Levee	Modern Levee
			Modern Other	Modern Other
			Modern Path/Trail	Modern Path/Trail
			Modern Railroad	Modern Railroad
			Modern Retaining Wall	Modern Retaining Wall
			Modern Rip-Rap	Modern Rip-Rap
			Modern Road	Modern Road
			Modern Rock Alignment	Modern Rock Alignment
			Modern Shoreline	Modern Shoreline
No - NWW	ModernFeature_P	Modern feature - cultural point	Modern Borrow Pit	Modern Borrow Pit
			Modern Campfire Ring	Modern Campfire Ring
			Modern Cut Bank	Modern Cut Bank
			Modern Depression	Modern Depression
			Modern Dock/Launch Ramp	Modern Dock/Launch Ramp
			Modern Fencepost	Modern Fencepost
			Modern Graffiti	Modern Graffiti
			Modern Other	Modern Other
			Modern Pipeline	Modern Pipeline
			Modern Rock Pile	Modern Rock Pile
			Modern Sign	Modern Sign
			Modern Structure	Modern Structure
			Modern Tree/Stump	Modern Tree/Stump
No - NWW	PrecontactSiteType	Type of archaeological features from the Precontact period.	Burial	Burial
			Camp	Camp
			Isolated Find	Isolated Find
			Legend Site	Legend Site
			Lithic Scatter	Lithic Scatter
			NA	NA
			Other-Unknown	Other-Unknown
			Paleontological Site	Paleontological Site
			Resource Procurement/Processing	Resource Procurement/Processing
			Rock Feature	Rock Feature
			Rock Image	Rock Image
			Rockshelter	Rockshelter
			Storage	Storage
			TCP	TCP
			Trail	Trail
			Unknown	Unknown
			Village	Village
No - NWW	PrecontactArtifact_P	Precontact artifact - cultural point	Basketry/Textile	Basketry/Textile
			Bead	Bead
			Biface	Biface
			Bone (non-human)	Bone (non-human)
			Charcoal	Charcoal
			Core	Core
			Debitage	Debitage
			FCR	Fire Cracked Rock
			Groundstone	Groundstone
			Hammerstone	Hammerstone
			Lithic	Lithic
			Net Weight	Net Weight
			Other	Other
			Projectile Point	Projectile Point
			Shell	Shell
No - NWW	PrecontactFeature_A	Precontact feature - cultural polygon	Artifact Scatter	Artifact Scatter
			Burial	Burial
			Midden	Midden
			Other	Other
			Reburial	Reburial
			Rockshelter	Rockshelter
No - NWW	PrecontactFeature_L	Precontact feature - cultural line	Precontact Other	Precontact Other
			Precontact Rock Alignment	Precontact Rock Alignment
			Precontact Rockshelter	Precontact Rockshelter
			Precontact Trail	Precontact Trail
No - NWW	PrecontactFeature_P	Precontact feature - cultural point	Artifact Concentration	Artifact Concentration
			BRM/Slick	BRM/Slick
			Burial	Burial
			Cairn	Cairn
			Cobble Concentration	Cobble Concentration
			Culturally Modified Tree	Culturally Modified Tree
			Depression	Depression
			FCR Concentration	Fire Cracked Rock Concentration
			Hearth	Hearth
			Hunting Blind	Hunting Blind
			Other	Other
			Pithouse	Pithouse
			Reburial	Reburial
			Rock Alignment	Rock Alignment
			Rock Image	Rock Image
			Rock Ring	Rock Ring
			Rockshelter	Rockshelter
No - NWW	PROJECTID	Unique ID for Civil Works projects within the Portland District	COST	COST SHARE AGREEMENT ENTITY
			AGD	APPLEGATE DAM AND RESERVOIR
			BCL	BIG CLIFF DAM AND RESERVOIR
			BLR	BLUE RIVER DAM AND RESERVOIR
			BON	BONNEVILLE DAM AND RESERVOIR
			CHT	CHETCO
			CSB	COOS BAY
			COQ	COQUILLE
			CTG	COTTAGE GROVE DAM AND RESERVOIR
			CGR	COUGAR DAM AND RESERVOIR
			DPB	DEPOE BAY
			DET	DETROIT DAM AND RESERVOIR
			DEX	DEXTER DAM AND RESERVOIR
			DOR	DORENA DAM AND RESERVOIR
			ELK	ELK CREEK PROJECT
			FLC	FALL CREEK DAM AND RESERVOIR
			FRN	FERN RIDGE DAM AND RESERVOIR
			FOS	FOSTER DAM AND RESERVOIR
			GPR	GREEN PETER DAM AND RESERVOIR
			HCR	HILLS CREEK DAM AND RESERVOIR
			JDA	JOHN DAY DAM AND RESERVOIR
			LOP	LOOKOUT POINT DAM AND RESERVOIR
			LCD	LOST CREEK DAM AND RESERVOIR
			LCR	LOWER COLUMBIA RIVER
			LWR	LOWER WILLAMETTE RIVER
			MSH	MOUNT ST. HELENS
			MCR	MOUTH OF THE COLUMBIA RIVER
			NEH	NEHALEM
			OFFPRJ	OFF PROJECT ENTITY
			PTO	PORT ORFORD
			RGE	ROGUE
			SRS	SEDIMENT RETENTION STRUCTURE
			SIU	SIUSLAW
			TDA	THE DALLES DAM AND RESERVOIR
			TIL	TILLAMOOK
			UGM	U.S. GOVERNMENT MOORINGS
			UMP	UMPQUA
			WFL	WILLAMETTE FALLS LOCKS
			WIL	WILLOW CREEK DAM AND RESERVOIR
			YAQ	YAQUINA
No - NWW	siteDatum_P	Site Datum	siteDatum	A physical marker representing the site datum (e.g. rebar stake).
No - NWW	siteStability	Degree of change over time	Changing	Changing
			Stable	Stable

ArchaeologicalDistricts_A

Feature Dataset Name	ArchaeologicalDistricts_A
Alias	Archaeological Districts
Table Definition	A polygon feature that contains the location of an archaeological district. Archaeological districts are comprised of contributing sites that have been proposed, determined eligible, or listed on the NRHP. Many times the NPS Historic Places information will not contain locational information for archaeological districts for the purposes of site protection.
Population
SDSFIE3	Attribute Name	Data Type	Char Length	Domain Table	Common Name	Definition
No - NWW	archaeologicalDistrictsIDPK	Text	50		Primary Key Identifier	Primary Key. A unique, user defined identifier for each record or instance of an entity. Populated with "60ADS" + 4-digit sequence number. Ex: 60ADS0001.
Yes	projectID	Text	30	PROJECTID		A unique identifier for Civil Works projects within the Walla Walla Corps of Engineers district.
No - NWW	siteID	Text	8
No - NWW	agencyID	Text	255
	archaeologicalDistrictType	Text	30	archaeologicalDistrictType		Category of archaeological district.
No - NWW	eligibilityName	Text	255
No - NWW	eligibilityDescription	Text	255
No - NWW	dateCreated	Date				Date that the site was recorded or the data updated
No - NWW	comments	Text	255			Additional information
No - NWW	dataSource	Long Integer		dataSource		Indicates equipment and means of digitizing GIS features.
No - NWW	revisionUser	Text	8			Feature level metatdata describing the person making a revision by their G4 number.
No - NWW	revisionDate	Date				Feature level metatdata describing the date of a revision.
No - NWW	acres	Double				Area of feature in acres.
No - NWW	GLOBALID	GUID			Global ID	Global ID and GUID data types store registry style strings consisting of 36 characters enclosed in curly brackets. These strings uniquely identify a feature or table row within a geodatabase and across geodatabases. This is how features are tracked in one-way and two-way geodatabase replication.

ArchaelogicalSite_A

Feature Dataset Name	ArchaeologicalSite_A
Alias	Archaeological Sites
Table Definition	The boundaries of a recorded archaeological site, recorded as a polygon.
Population
SDSFIE3	Attribute Name	Data Type	Char Length	Domain Table	Common Name	Definition
Yes	archaeologicalSiteIDPK	Text	20		Primary Key Identifier	Reference to identification assigned by state or other entity. Nominally a Smithsonian Institute trinomial consisting of two digits representing state, two to three characters representing county, and four digits representing sequence (e.g. 45FR0030). 'N/A' in the case of an unrecorded point.
Yes	sdsFeatureName	Text	80			The common name of the feature. (Site Name)
Yes	sdsMetadataID	Text	80			The foreign key to a metadata record.
Yes	projectID	Text	10	PROJECTID		A unique identifier for Civil Works projects within the Walla Walla Corps of Engineers district.
No-NWW	disposal	Text	20	culturalDisposal		Reference to what Civil Works project the site was part of before it was disposed of. (Domains could be NA, Disposal-MNA, Disposal-HLD; Disposal-LMA; Disposal-LGA; Disposal-LLA, Disposal-DWA; Disposal-Other)
No-NWW	archaeologicalSiteSubtype	Short Integer		0: Isolated Find		Indicates if the polygon is a Recorded Site, Unrecorded Site, or Isolated Find.
				1: Recorded Site
				2: Unrecorded Site
No - NWW	acres	Double				GIS-calculated area of feature, measured in acres.
No - NWW	dateRecorded	Date				Date that the site was recorded or the data updated
No - NWW	fieldSiteNumber	Text	15			Temporary number assigned in the field when first documenting a site. (If the site does not have a temporary number, enter "NA".
No - NWW	comments	Text	255			Comments about the polygon, usually information pertinent to the shapefile (e.g. size, shape, etc).
No - NWW	CR_ProjectNumber	Text	15			For new fieldwork (or if you're importing GIS data from existing shapefiles related to a project), the project number would be assigned when you're doing the fieldwork, and this would link your site to a particular project when that information is first recorded. Does not need to be updated for old data (can leave field blank).
No - NWW	dataStatus	Text	15	CulturalDataStatus		Status of the shapefile - "Current" (best data we have at the time); "Legacy" (seems okay, but hasn't been verified by someone at USACE)
No - NWW	dataSource	Long Integer		dataSource		Indicates equipment and means of digitizing GIS features.
No - NWW	revisionUser	Text	8			Feature level metatdata describing the person making a revision by their G4 number.
No - NWW	revisionDate	Date				Feature level metatdata describing the date of a revision.
No - NWW	monitoringSchedule	Text	25	CulturalMonitoringInterval		Frequency for site assessments.
Yes	sdsFeatureDescription	Text	255			A narrative describing the feature.
Yes	nationalRegisterStatus	Text	30	HistoricalStatusCode		Specifies the historical status of a cultural resource feature with respect to placement on the National Register of Historical Places. Categorizes the feature as either as (a) one of the Real Property Asset (RPA) Historic Status Code values as defined by the DUSD IandE RPIR, or (b) No Assessment Required.
No - NWW	nationalRegisterStatusDate	Date	Date			Date that the SHPO concurred with the NRHP status (usually in a letter or on the NRHP form).
No - NWW	nationalRegisterComments	Text	255			Comments on the NRHP evaluation (e.g. is additional research needed, not relocated, etc).
No - NWW	contributingProperties	Text	20			For sites that contribute to archaeological districts, name of the Archaeological District(s)
No - NWW	burial	Text	3	Boolean		Does the site contain burials? Populated by NWW GIS staff; must be validated by archaeologist.
No - NWW	curation	Text	50			Other data, likely chronology or geography related, that is useful to researchers, e.g. obsidian sourcing, obsidian hydration, textile types, etc.
No - NWW	historicSiteType	Text	50	HistoricSiteType		Type of archeological features from the Historic period. Populated by NWW GIS staff; must be validated by archaeologist.
No - NWW	labAnalysisComments	Text	100			Results of laboratory analysis; obsidian sourcing, pollen, tephra, etc.
No - NWW	otherChrono	Text	3	Boolean		Are chronographic data other than radiocarbon available for this site?
No - NWW	otherChronoComments	Text	100			Other data, likely chronology or geography related, that is useful to researchers, e.g. obsidian sourcing, obsidian hydration, textile types, etc.
No - NWW	petroglyph	Text	3	Boolean		Does the site contain Petroglyphs? Populated by NWW GIS staff; must be validated by archaeologist.
No - NWW	precontactSiteType	Text	50	PrecontactSiteType		Type of archeological features from the Precontact period. Populated by NWW GIS staff; must be validated by archaeologist.
No - NWW	precontactRockCairn	Text	3	Boolean		Does the site contain Precontact rock cairns?
No - NWW	radiocarbon	Text	3	Boolean		Is radiocarbon data available for this site?
No - NWW	radiocarbonComments	Text	100			Radiocarbon dates, specify type. Use 'BP' (Before Present) if the date is not calibrated or 'BP Cal' if the date is calibrated.
No - from SRI gdb version	siteAge	Text	50			General age of site. Will become domain-contrained when domain definition is available.
No - from SRI gdb version	FCRPS_InundatedType	Text	255			FCRPS baseline data . Used to populate SRI field "generalSiteCondition".
No - from SRI gdb version	FCRPS_HumanRemains	Text	255			FCRPS baseline data. Used in conjunction with FCRPS field "SiteType" to populate SRI field "archaeologicalSiteType".
No - NWW	NAGPRA	Text	3	Boolean		Are data available about NAGPRA collections?
No - NWW	NAGPRAComments	Text	50			Status of collection's repatriation.
No - from SRI shapefile version	WADAHP_SiteType	Text	255			WA State Dept of Archaeology and Historic Preservation (DAHP) baseline data.
No - NWW	GLOBALID	GUID			Global ID	Global ID and GUID data types store registry style strings consisting of 36 characters enclosed in curly brackets. These strings uniquely identify a feature or table row within a geodatabase and across geodatabases. This is how features are tracked in one-way and two-way geodatabase replication.

ArchaelogicalSite_P_VW

Feature Dataset Name	ArchaeologicalSite_P_VW
Alias	Archaeological Sites
Table Definition	View based on ArchaeologicalSite_A. Point representation of a recorded archaeological site.
Population
SDSFIE3	Attribute Name	Data Type	Char Length	Domain Table	Common Name	Definition
Yes	archaeologicalSiteIDPK	Text	20		Primary Key Identifier	Reference to identification assigned by state or other entity. Nominally a Smithsonian Institute trinomial consisting of two digits representing state, two to three characters representing county, and four digits representing sequence (e.g. 45FR0030). 'N/A' in the case of an unrecorded point.
Yes	sdsFeatureName	Text	80			The common name of the feature. (Site Name)
Yes	sdsMetadataID	Text	80			The foreign key to a metadata record.
Yes	projectID	Text	10	PROJECTID		A unique identifier for Civil Works projects within the Walla Walla Corps of Engineers district.
No-NWW	disposal	Text	20	culturalDisposal		Reference to what Civil Works project the site was part of before it was disposed of. (Domains could be NA, Disposal-MNA, Disposal-HLD; Disposal-LMA; Disposal-LGA; Disposal-LLA, Disposal-DWA; Disposal-Other)
No-NWW	archaeologicalSiteSubtype	Short Integer		0: Isolated Find		Indicates if the polygon is a Recorded Site, Unrecorded Site, or Isolated Find.
				1: Recorded Site
				2: Unrecorded Site
No - NWW	acres	Double				GIS-calculated area of feature, measured in acres.
No - NWW	dateRecorded	Date				Date that the site was recorded or the data updated
No - NWW	fieldSiteNumber	Text	15			Temporary number assigned in the field when first documenting a site. (If the site does not have a temporary number, enter "NA".
No - NWW	comments	Text	255			Comments about the polygon, usually information pertinent to the shapefile (e.g. size, shape, etc).
No - NWW	CR_ProjectNumber	Text	15			For new fieldwork (or if you're importing GIS data from existing shapefiles related to a project), the project number would be assigned when you're doing the fieldwork, and this would link your site to a particular project when that information is first recorded. Does not need to be updated for old data (can leave field blank).
No - NWW	dataStatus	Text	15	CulturalDataStatus		Status of the shapefile - "Current" (best data we have at the time); "Legacy" (seems okay, but hasn't been verified by someone at USACE)
No - NWW	dataSource	Long Integer		dataSource		Indicates equipment and means of digitizing GIS features.
No - NWW	revisionUser	Text	8			Feature level metatdata describing the person making a revision by their G4 number.
No - NWW	revisionDate	Date				Feature level metatdata describing the date of a revision.
No - NWW	monitoringSchedule	Text	25	CulturalMonitoringInterval		Frequency for site assessments.
Yes	sdsFeatureDescription	Text	255			A narrative describing the feature.
Yes	nationalRegisterStatus	Text	30	HistoricalStatusCode		Specifies the historical status of a cultural resource feature with respect to placement on the National Register of Historical Places. Categorizes the feature as either as (a) one of the Real Property Asset (RPA) Historic Status Code values as defined by the DUSD IandE RPIR, or (b) No Assessment Required.
No - NWW	nationalRegisterStatusDate	Date	Date			Date that the SHPO concurred with the NRHP status (usually in a letter or on the NRHP form).
No - NWW	nationalRegisterComments	Text	255			Comments on the NRHP evaluation (e.g. is additional research needed, not relocated, etc).
No - NWW	contributingProperties	Text	20			For sites that contribute to archaeological districts, name of the Archaeological District(s)
No - NWW	burial	Text	3	Boolean		Does the site contain burials? Populated by NWW GIS staff; must be validated by archaeologist.
No - NWW	curation	Text	50			Other data, likely chronology or geography related, that is useful to researchers, e.g. obsidian sourcing, obsidian hydration, textile types, etc.
No - NWW	historicSiteType	Text	50	HistoricSiteType		Type of archeological features from the Historic period. Populated by NWW GIS staff; must be validated by archaeologist.
No - NWW	labAnalysisComments	Text	100			Results of laboratory analysis; obsidian sourcing, pollen, tephra, etc.
No - NWW	otherChrono	Text	3	Boolean		Are chronographic data other than radiocarbon available for this site?
No - NWW	otherChronoComments	Text	100			Other data, likely chronology or geography related, that is useful to researchers, e.g. obsidian sourcing, obsidian hydration, textile types, etc.
No - NWW	petroglyph	Text	3	Boolean		Does the site contain Petroglyphs? Populated by NWW GIS staff; must be validated by archaeologist.
No - NWW	precontactSiteType	Text	50	PrecontactSiteType		Type of archeological features from the Precontact period. Populated by NWW GIS staff; must be validated by archaeologist.
No - NWW	precontactRockCairn	Text	3	Boolean		Does the site contain Precontact rock cairns?
No - NWW	radiocarbon	Text	3	Boolean		Is radiocarbon data available for this site?
No - NWW	radiocarbonComments	Text	100			Radiocarbon dates, specify type. Use 'BP' (Before Present) if the date is not calibrated or 'BP Cal' if the date is calibrated.
No - from SRI gdb version	siteAge	Text	50			General age of site. Will become domain-contrained when domain definition is available.
No - from SRI gdb version	FCRPS_InundatedType	Text	255			FCRPS baseline data . Used to populate SRI field "generalSiteCondition".
No - from SRI gdb version	FCRPS_HumanRemains	Text	255			FCRPS baseline data. Used in conjunction with FCRPS field "SiteType" to populate SRI field "archaeologicalSiteType".
No - NWW	NAGPRA	Text	3	Boolean		Are data available about NAGPRA collections?
No - NWW	NAGPRAComments	Text	50			Status of collection's repatriation.
No - from SRI shapefile version	WADAHP_SiteType	Text	255			WA State Dept of Archaeology and Historic Preservation (DAHP) baseline data.
No - NWW	GLOBALID	GUID			Global ID	Global ID and GUID data types store registry style strings consisting of 36 characters enclosed in curly brackets. These strings uniquely identify a feature or table row within a geodatabase and across geodatabases. This is how features are tracked in one-way and two-way geodatabase replication.

ArchSiteCondition_P

Feature Dataset Name	ArchSiteCondition_P
Alias	Archaeological Site Condition
Table Definition	Points recording condition assessment information related to ArchaeologicalSite_A.
Population
SDSFIE3	Attribute Name	Data Type	Char Length	Domain Table	Common Name	Definition
Yes	archaeologicalSiteIDFK	Text	20		Foreign Key	Reference to identification assigned by state or other entity. Nominally a Smithsonian Institute trinomial consisting of two digits representing state, three characters representing county, and a varying number of digits representing sequence. 'N/A' in the case of an unrecorded point.
No - NWW	CR_ProjectNumber	Text	15			For new fieldwork (or if you're importing GIS data from existing shapefiles related to a project), the project number would be assigned when you're doing the fieldwork, and this would link your site to a particular project when that information is first recorded. Does not need to be updated for old data (can leave field blank).
No - NWW	agencyPerforming	Text	30			Name of the agency performing the condition assessment (will be text or abbreviation, will fix regularly to keep consistent using field calculator.
No - NWW	dateRecorded	Date				Date of the condition assessment
No - NWW	monitoringInterval	Text	15	CulturalMonitoringInterval		Desribes the required frequency of evaluating the site.
No - NWW	meanForebayElevation	Text	20			The elevation in feet of the forebay during the site evaluation.
No - NWW	siteCondition	Text	30	CulturalSiteCondition		Good; Fair; Poor; Destroyed; Unknown (still working on defintions)
No - NWW	visitType	Text	25	CulturalVisitType		Describes the purpose of the site visit.
No - NWW	revisionUser	Text	8			Feature level metatdata describing the person making a revision by their G4 number.
No - NWW	revisionDate	Date				Feature level metatdata describing the date of a revision.
No - NWW	impactsNoted	Text	70			Short description of the types of impacts noted on the Condition Monitoring form. Use "none" if no impacts were noted, or "Not Applicable" if the visit was not for Condition Monitoring.
No - NWW	remediationsRecommended	Text	70			Short description of the types of remediations needed, eg. Bank stabilization, planting, etc. Use "none" if no proposed remediations were noted, or "Not Applicable" if the visit was not for Condition Monitoring.
No - NWW	comments	Text	255			Comments relating to that site visit
No - NWW	faunalImpacts	Text	20	culturalSiteImpacts		Faunal impacts noted (e.g. trampling, burrowing, damming, etc)?
No - NWW	floralImpacts	Text	20	culturalSiteImpacts		Floral impacts noted (e.g. noxious weeds)?
No - NWW	geomorphicImpacts	Text	20	culturalSiteImpacts		Geomorphic impacts noted (fluvial, aeolian, etc)?
No - NWW	culturalImpacts	Text	20	culturalSiteImpacts		Feomorphic impacts noted (e.g. Livestock grazing, land development, Recreation, Vandalism, Looting, Other)?
No - NWW	siteStability	Text	10	siteStability		Degree of change over time
No - NWW	GLOBALID	GUID			Global ID	Global ID and GUID data types store registry style strings consisting of 36 characters enclosed in curly brackets. These strings uniquely identify a feature or table row within a geodatabase and across geodatabases. This is how features are tracked in one-way and two-way geodatabase replication.

CemeteryOrBurialSite_A

Feature Dataset Name	SDSFIE3 - CemeteryOrBurialSite
Alias
Table Definition	A place or a ground set apart for the burial of the dead. Can contain an area representing a graveyard, or a point feature containing one or more graves. This file is for Tribal reburial cemeteries on Corps Land; document historic Euroamerican cemeteries in the ArchaeologicalSite_A or _P files (since they can be assigned archaeological site numbers). Individual reinternments in these Tribal Cemeteries should be recorded under CulturalMaterial_A->Reburial or CulturalMaterial_P->Reburial.
Population
SDSFIE3	Attribute Name	Data Type	Char Length	Domain Table	Common Name	Definition
Yes	cemeteryOrBurialSiteIDPK	Text	20		Primary Key Identifier	Primary Key. A unique, user defined identifier for each record or instance of an entity. (Full cemetery name, or abbreviated cemetery name if the name is longer than 20 characters.)
Yes	sdsFeatureName	Text	80			The common name of the feature.
Yes	sdsFeatureDescription	Text	255			A narrative describing the feature. Dates of reburials followed by number of individuals reinterred (e.g. 1/1/2011=3 individuals)
Yes	nationalRegisterStatus	Text	30	HistoricalStatusCode		Specifies the historical status of a cultural resource feature with respect to placement on the National Register of Historical Places. Categorizes the feature as either as (a) one of the Real Property Asset (RPA) Historic Status Code values as defined by the DUSD IandE RPIR, or (b) No Assessment Required. In this instance, use "No Assessment Required."
Yes	otherRegisterStatus	Text	150			Specifies placement on the World Heritage List, or a cultural property inventory/registry of the host nation. In this instance use "Not Applicable"
Yes	realPropertySiteUniqueID	Long	n/a			The unique identifier (UID) used to permanently identify a Site. This UID will be a Real Property Site Unique Identifier (RPSUID). Source: RPIM 4.0a, November 4, 2010.
Yes	realPropertyUniqueIdentifier	Text	18			The real property unique identifier (RPUID) is a non-intelligent code used to permanently and uniquely identify a real property asset. Source: RPIM 4.0a, November 4, 2010.
Yes	propertyIDCode	Text	20			This unique identifier will be used to link Civil Works Real Property Assets to REMIS.
No - NWW	acres	Double				Area of feature in acres.
No - NWW	revisionUser	Text	8			Feature level metatdata describing the person making a revision by their G4 number.
No - NWW	revisionDate	Date				Feature level metatdata describing the date of a revision.
No - NWW	GLOBALID	GUID			Global ID	Global ID and GUID data types store registry style strings consisting of 36 characters enclosed in curly brackets. These strings uniquely identify a feature or table row within a geodatabase and across geodatabases. This is how features are tracked in one-way and two-way geodatabase replication.

CulturalLandClass_A

Feature Dataset Name	CulturalLandClass_A
Alias	Cultural Land Class Areas (Polygons)
Table Definition	Ancillary Archaeologic polygon features (Area of potential effect, cultural resource potential, cultural restricted access, Corps owned land for FCRPS inventories, etc.)
Population
SDSFIE3	Attribute Name	Data Type	Char Length	Domain Table	Common Name	Definition
No - NWW	cultLandClassIDPK	Text	20		Primary Key Identifier	Primary Key. A unique, user defined identifier for each record or instance of an entity.
No - NWW	cultLandClassSubtype	Short Integer		0: Archaeology APE		Indicates the type of feature (Area of potential effect, cultural resource potential, cultural restricted access, Corps owned land for FCRPS inventories, Potential Disposals, etc.)
				1: Area of Potential Effects
				2: Corps Owned Land (for FCRPS inventories)
				3: Cultural Resource Potential Area
				4: Cultural Restricted Access Area
				5: Fire Department
				6: Fire District
				7: Potential Disposal
				8: TCP/Built Environment APE
				9: Other
Yes	sdsFeatureName	Text	80			The common name of the feature.
Yes	sdsFeatureDescription	Text	255			A narrative describing the feature.
No - NWW	projectID	Text	10	PROJECTID		A unique identifier for Civil Works projects within the Walla Walla Corps of Engineers district.
No - NWW	acres	Double				Size of the area in acres.
No - NWW	dataStaus	Text	15	CulturalDataStatus		Status of the shapefile - "Current" (best data we have at the time); "Legacy" (seems okay, but hasn't been verified by someone at USACE)
No - NWW	dataSource	Long Integer		dataSource		Indicates equipment and means of digitizing GIS features.
No - NWW	revisionUser	Text	8			Feature level metatdata describing the person making a revision by their G4 number.
No - NWW	revisionDate	Date				Feature level metatdata describing the date of a revision.
No - NWW	comments	Text	255			Additional information
No - NWW	GLOBALID	GUID			Global ID	Global ID and GUID data types store registry style strings consisting of 36 characters enclosed in curly brackets. These strings uniquely identify a feature or table row within a geodatabase and across geodatabases. This is how features are tracked in one-way and two-way geodatabase replication.

CulturalMaterial_A

Feature Dataset Name	CulturalMaterial_A
Alias	Cultural Material Areas (Polygons)
Table Definition	An area that contains an object of archaeological significance.
Population
SDSFIE3	Attribute Name	Data Type	Char Length	Domain Table	Common Name	Definition
No - NWW	culturalMaterial_AIDPK	Text	20		Primary Key Identifier	Primary Key. A unique, user defined identifier for each record or instance of an entity. Populated with "60CMA" + 4-digit sequence number. Ex: 60CMA0001.
Yes	archaeologicalSite_IDFK	Text	20		Foreign Key	Reference to identification assigned by state or other entity. Nominally a Smithsonian Institute trinomial consisting of two digits representing state, two to three characters representing county, and four digits representing sequence (e.g. 45FR0030). 'N/A' in the case of an unrecorded point.
Yes	projectID	Text	10	PROJECTID		A unique identifier for Civil Works projects within the Walla Walla Corps of Engineers district.
No - NWW	fieldSiteNumber	Text	15			Temporary number assigned in the field when first documenting a site.
No - NWW	resourceNumber	Text	20			Artifact or feature number assigned in the field
No - NWW	culturalMaterialSubtype	Short Integer			Subtype:	Subtype selection describes feature polygon era; the domains associated with the subtypes classify the polygon according to SHPO standards.
					0: historicFeaturePoly
					1: modernFeaturePoly
					2: PrecontactFeaturePoly
No - NWW	culturalMaterialType	Text	50	historicFeature_A		The domains in culturalMaterialSubtype select attribute domains that populate this field.
				modernFeature_A
				PrecontactFeature_A
No - NWW	comments	Text	255			Comments about the feature, location, or GPS data accuracy.
No - NWW	dateRecorded	Date				Date that the site was recorded or the data updated
No - NWW	CR_ProjectNumber	Text	15			For new fieldwork (or if you're importing GIS data from existing shapefiles related to a project), the project number would be assigned when you're doing the fieldwork, and this would link your site to a particular project when that information is first recorded. Does not need to be updated for old data (can leave field blank).
No - NWW	acres	Double				GIS-calculated area of feature, measured in acres.
No - NWW	dataStatus	Text	15	CulturalDataStatus		Status of the shapefile - "Current" (best data we have at the time); "Legacy" (seems okay, but hasn't been verified by someone at USACE)
No - NWW	dataSource	Long Integer		dataSource		Indicates equipment and means of digitizing GIS features.
No - NWW	revisionUser	Text	8			Feature level metatdata describing the person making a revision by their G4 number.
No - NWW	revisionDate	Date				Feature level metatdata describing the date of a revision.
No - NWW	GLOBALID	GUID			Global ID	Global ID and GUID data types store registry style strings consisting of 36 characters enclosed in curly brackets. These strings uniquely identify a feature or table row within a geodatabase and across geodatabases. This is how features are tracked in one-way and two-way geodatabase replication.

CulturalMaterial_L

Feature Dataset Name	CulturalMaterial_L
Alias	Cultural Material Lines
Table Definition	A line that contains an object of archaeological significance.
Population
SDSFIE3	Attribute Name	Data Type	Char Length	Domain Table	Common Name	Definition
No - NWW	culturalMaterial_LIDPK	Text	20		Primary Key Identifier	Primary Key. A unique, user defined identifier for each record or instance of an entity. Populated with "60CML" + 4-digit sequence number. Ex: 60CML0001.
Yes	archaeologicalSiteIDFK	Text	20		Foreign Key	Reference to identification assigned by state or other entity. Nominally a Smithsonian Institute trinomial consisting of two digits representing state, two to three characters representing county, and four digits representing sequence (e.g. 45FR0030). 'N/A' in the case of an unrecorded point.
Yes	projectID	Text	10	PROJECTID		A unique identifier for Civil Works projects within the Walla Walla Corps of Engineers district.
No - NWW	fieldSiteNumber	Text	15			Temporary number assigned in the field when first documenting a site.
No - NWW	resourceNumber	Text	20			Artifact or feature number assigned in the field
No - NWW	culturalMaterialSubtype	Short Integer			Subtypes:	Subtype selection describes feature line era; the domains associated with the subtypes classify the line according to SHPO standards.
					0: historicFeatureLine
					1: modernFeatureLine
					2: precontactFeatureLine
No - NWW	culturalMaterialType	Text	50	HistoricFeature_L		The domains in culturalMaterialSubtype select attribute domains that populate this field.
				ModernFeature_L
				PrecontactFeature_L
No - NWW	comments	Text	255			Comments about the feature, location, or GPS data accuracy.
No - NWW	dateRecorded	Date				Date that the feature was recorded or the data updated
No - NWW	CR_ProjectNumber	Text	15			For new fieldwork (or if you're importing GIS data from existing shapefiles related to a project), the project number would be assigned when you're doing the fieldwork, and this would link your site to a particular project when that information is first recorded. Does not need to be updated for old data (can leave field blank).
No - NWW	dataStatus	Text	15	CulturalDataStatus		Status of the shapefile - "Current" (best data we have at the time); "Legacy" (seems okay, but hasn't been verified by someone at USACE)
No - NWW	dataSource	Long Integer		dataSource		Indicates equipment and means of digitizing GIS features.
No - NWW	revisionUser	Text	8			Feature level metatdata describing the person making a revision by their G4 number.
No - NWW	revisionDate	Date				Feature level metatdata describing the date of a revision.
No - NWW	GLOBALID	GUID			Global ID	Global ID and GUID data types store registry style strings consisting of 36 characters enclosed in curly brackets. These strings uniquely identify a feature or table row within a geodatabase and across geodatabases. This is how features are tracked in one-way and two-way geodatabase replication.

CulturalMaterial_P

Feature Dataset Name	CulturalMaterial_P
Alias	Cultural Material Points
Table Definition	A point that contains an object of archaeological significance.
Population
SDSFIE3	Attribute Name	Data Type	Char Length	Domain Table	Common Name	Definition
No - NWW	culturalMaterial_PIDPK	Text	20		Primary Key Identifier	Primary Key. A unique, user defined identifier for each record or instance of an entity. Populated with "60CMP" + 4-digit sequence number. Ex: 60CMP0001.
Yes	archaeologicalSiteIDFK	Text	20		Foreign Key	Reference to identification assigned by state or other entity. Nominally a Smithsonian Institute trinomial consisting of two digits representing state, two to three characters representing county, and four digits representing sequence (e.g. 45FR0030). 'N/A' in the case of an unrecorded point.
Yes	projectID	Text	10	PROJECTID		A unique identifier for Civil Works projects within the Walla Walla Corps of Engineers district.
No - NWW	fieldSiteNumber	Text	15			Temporary number assigned in the field when first documenting a site.
No - NWW	resourceNumber	Text	20			Artifact or feature number assigned in the field
No - NWW	culturalMaterialSubtype	Short Integer			Subtypes:	Subtype selection describes era and distinguishes point type as either Artifact or Featue; the domains associated with the subtypes classify the point according to SHPO standards.
					0: historicArtifactPoint
					1: modernArtifactPoint
					2: PrecontactArtifactPoint
					3: historicFeaturePoint
					4: modernFeaturePoint
					5: PrecontactFeaturePoint
					6:Datum
No - NWW	culturalMaterialType	Text	255	HistoricArtifact_P		The domains in culturalMaterialSubtype select attribute domains that populate this field.
				ModernArtifact_P
				PrecontactArtifact_P
				HistoricFeature_P
				ModernFeature_P
				PrecontactFeature_P
				Datum
No - NWW	comments	Text	255			Pertinent artifact comments (may not be any comments if using artifact form or doing quick documentation, in that case can be null)
No - NWW	dateRecorded	Date				Date that the site was recorded or the data updated
No - NWW	CR_ProjectNumber	Text	15			For new fieldwork (or if you're importing GIS data from existing shapefiles related to a project), the project number would be assigned when you're doing the fieldwork, and this would link your site to a particular project when that information is first recorded. Does not need to be updated for old data (can leave field blank).
No - NWW	dataStatus	Text	15	CulturalDataStatus		Status of the shapefile - "Current" (best data we have at the time); "Legacy" (seems okay, but hasn't been verified by someone at USACE)
No - NWW	dataSource	Long Integer		dataSource		Indicates equipment and means of digitizing GIS features. Only will be adding the artifacts and features to the GIS that was recorded with GPS or can be drafted in from an aerial photo or cad map, otherwise will probably remain null.
No - NWW	revisionUser	Text	8			Feature level metatdata describing the person making a revision by their G4 number.
No - NWW	revisionDate	Date				Feature level metatdata describing the date of a revision.
No - NWW	GLOBALID	GUID			Global ID	Global ID and GUID data types store registry style strings consisting of 36 characters enclosed in curly brackets. These strings uniquely identify a feature or table row within a geodatabase and across geodatabases. This is how features are tracked in one-way and two-way geodatabase replication.

CulturalReports

Feature Dataset Name	CulturalReports
Alias	Cultural Reports
Table Definition	Non-spatial table relating Investigation_P, Investigation_L, and Investigation_A to CulturalSurvey_A.
Population
SDSFIE3	Attribute Name	Data Type	Char Length	Domain Table	Common Name	Definition
No - NWW	CR_ProjectNumber	Text	15		Primary Key Identifier	For new fieldwork (or if you're importing GIS data from existing shapefiles related to a project), the project number would be assigned when you're doing the fieldwork, and this would link your site to a particular project when that information is first recorded. Does not need to be updated for old data (can leave field blank).
No - NWW	EC_ProjectNumber	Text	25			Alpha-numeric code assigned by Environmental Compliance. A combination of office symbol, calendar year in which the project was entered into the EC database, and sequence number.
No - NWW	stateReportNumber	Text	20			NADB number or other number that is assigned by the SHPO office to identify the survey.
No - NWW	CR_ReportTitle	Text	255			Title of the Cultural Resource report.
No - NWW	CR_ReportDate	Date				Date the Cultural Resources report was completed.

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Nov 14, 2017.