Back to file

Schema

Formerly Used Defense Sites (FUDS) Projects (Points) / formerly-used-defense-sites-projects-points / v1.0.0

View metadata

Schema from GeoParquet, GCS hifld-next-datasets-prod, v1.0.0.

Columns
28 columns
Features
5,584
Geometry
Point
ColumnTypeNullableNullsUniqueDescriptionExamples / Values
geometrygeometryYes312
Range: Length:
Examples:
Values:
COSTTOCOMPLETEfloatNo0
Range: 0 to 360879Length:
Examples: 1736.0, 0.0, 0.0, 0.0, 2007.0
Values:
DERPPROGRAMstringNo0
Range: Length: 4
Examples: MMRP, IRP, IRP, IRP, MMRP
Values: IRP, MMRP
DODFORMERLYUSEDDEFENSESITENAMEstringNo0
Range: Length: 49
Examples: BLACK HILLS ORD DPT, WAFB FAC SITE #6, FLAMINGO PROPERTIES CO (REV.), BEAVERTAIL PT.NAV COMM, DEMING AAF PBR #1
Values:
DODFUDSPROPERTYIDFKstringNo0
Range: Length: 9
Examples: B08SD0008, K06NM0484, K06TX0569, D01RI0321, K06NM0385
Values:
EMSMGMTACTIONPLANLINKstringNo0
Range: Length: 60
Examples: https://fudsportal.usace.army.mil/ems/inventory/map?id=58261, https://fudsportal.usace.army.mil/ems/inventory/map?id=61540, https://fudsportal.usace.army.mil/ems/inventory/map?id=61715, https://fudsportal.usace.army.mil/ems/inventory/map?id=53807, https://fudsportal.usace.army.mil/ems/inventory/map?id=54443
Values:
ENVRESTORATIONCATEGORYstringNo0
Range: Length: 8
Examples: MMRP, HTRW, CON/HTRW, CON/HTRW, MMRP
Values: BD/DR, CON/HTRW, HTRW, MMRP, MMRP/CWM, PRP/HTRW, PRP/MMRP
ENVRESTORATIONPROJECTNAMEstringNo0
Range: Length: 41
Examples: Burning Ground No. 3, ATLAS MISSILE SILO #6, 7 UST'S, PCB TRANSFORMER, D01RI032101C_BEAVERTAIL PT.NAV, DEMING PBR #1
Values:
ENVRESTORATIONSITEIDFKstringNo0
Range: Length: 11
Examples: B08SD000811, K06NM048402, K06TX056901, D01RI032101, K06NM038501
Values:
FEDERALLANDNAMEstringYes5,000
Range: Length:
Examples:
Values:
FEDERALLANDTYPEstringYes5,000
Range: Length:
Examples:
Values:
FUDSINSTALLATIONIDstringNo0
Range: Length: 14
Examples: SD89799F077100, NM69799F627900, TX69799F672100, RI19799F211600, NM69799F618900
Values:
FUDSPROPERTYIDintegerNo0
Range: 0 to 0Length:
Examples: 0, 0, 0, 0, 0
Values:
FUDSSITEIDstringNo0
Range: Length: 2
Examples: 11, 02, 01, 01, 01
Values:
LATITUDEfloatYes312
Range: -14.275 to 48.941601Length:
Examples: 34.778889, 37.738611, 37.664167, 41.090556, 27.653461999999998
Values:
LONGITUDEfloatYes312
Range: -170.681667 to 170.395296Length:
Examples: -79.3725, -122.217778, -121.038333, -104.511389, -80.76605599999999
Values:
OVERLAPPINGFEDERALLANDAGENCYstringYes5,000
Range: Length:
Examples:
Values:
PROJECTNUMBERstringNo0
Range: Length: 10
Examples: 11OEW, 02HTRW, 01CON/HTRW, 01CON/HTRW, 01OEW
Values:
PROJECTREFERENCEAREAUOMstringNo0
Range: Length: 4
Examples: acre, acre, acre, acre, acre
Values: acre
PROJECTSTATUSstringNo0
Range: Length: 35
Examples: Investigation, Response Complete and Site Closeout, Response Complete and Site Closeout, Response Complete and Site Closeout, Investigation
Values: Cleanup, Investigation, Response Complete, Response Complete and Site Closeout
REMEDYINPLACEDATEstringNo0
Range: Length: 25
Examples: 2030-09-01T00:00:00+00:00, 2005-09-01T00:00:00+00:00, 1995-09-01T00:00:00+00:00, 1995-09-01T00:00:00+00:00, 2088-09-01T00:00:00+00:00
Values:
RESPONSECOMPLETEDATEstringNo0
Range: Length: 25
Examples: 2030-09-01T00:00:00+00:00, 2005-09-01T00:00:00+00:00, 1995-09-01T00:00:00+00:00, 1995-09-01T00:00:00+00:00, 2088-09-01T00:00:00+00:00
Values:
RISKVALUEMRSPPstringYes1,696
Range: Length: 2
Examples: 11, 05, R, R, H
Values: 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, H, L, M, N, R
STATEORTERRITORYNAMEstringNo0
Range: Length: 2
Examples: sd, nm, tx, ri, nm
Values:
SITECLOSEOUTDATEstringNo0
Range: Length: 25
Examples: 2061-09-01T00:00:00+00:00, 2007-09-01T00:00:00+00:00, 2016-09-01T00:00:00+00:00, 2009-09-01T00:00:00+00:00, 2119-09-01T00:00:00+00:00
Values:
PROJECTREFERENCEAREAfloatYes2,665
Range: 0 to 998864Length:
Examples: 495.0, 649.0, 1019.0, 187587.0, 1616.0
Values:
RIPRCSTRATEGYstringYes3,268
Range: Length: 2014
Examples: Acid Area 1 Decision Document signed in FY 16 RA-C awarded in 1st quarter of FY17. Remediation will be off-site disposal of PCB contaminated soil. RC should be achieved FY20. Acid Area 1 contains 5 areas all with PCB contamination and each requires off-site disposal. Remedial action is by PBA contract., MEC (a live M49 trip flare), 20 mm cartridge of unknown origin, and MD associated with 40mm projectiles and a 20mm casing was found by the SI field team. In addition, a live 2.75-inch projectile was found the Franklin County Bomb Squad while responding to address the live M49 trip flare. SI sampling results showed the lead concentration in surface soil exceeded background but did not exceed the human health screening value. Ecological receptors are not considered to be present. Additional investigation is warranted for both MEC and MC. RI/FS contract awarded in FY16. RI/FS Completion dates scheduled as follows: WP completed in FY18, RI FY19, FS FY20, PP FY20, DD FY21. As remedial investigation progresses, remediation strategy will be developed and refined., RA-C phase underway. MEC confirmed at site. Due to safety concerns working on an old lava field, no geophysical or soil sampling work can be done. Anticipated remedy to be IC only. IC will be education and signage. Anticipated length of LTM phase to be a minimum of 30 years., This site was recommended for No Department of Defense Actions Indicated 30 January 2011. , Contaminant of concern includes OEW and petroleum hydrocarbon contamination in soil and groundwater. This project is recommended for closure in the INPR dated 02 May 2018. The cemetery project and all other projects requiring an RI/FS have been moved to other projects, so all remaining areas of concern have recommendations of NFA. MDEQ agreement was obtained through their agreement wiht the content of the amended INPR. Although the bulk of closeout coordination is expected to occur in FY18, final negotiations and finalization are anticipated to occur during FY2019. Project Closeout was completed on 29 October 2018.
Values:
SE_ANNO_CAD_DATAstringNo0
Range: Length: 0
Examples: b'', b'', b'', b'', b''
Values:
Invalid geometry count: 0
Columns hash: 03bb1b6356b044713edcfdbd325b93832c36c7f8a0a738d7254791fb237854a1