Location Definition Information Table

Top  Previous  Next

Name

Location

Short Name

LDI

AFCEE Supplied

Yes

Number of Fields

30

Total Record Length

479

Child Tables

ATI

CALC

EMI

GWD

LOX

LSX

LTD

LTX

PUMPINT

SAMPLE

SLX

TRI

WCI

ZLX

General information about sampling locations.

 

The Location Definition Information (LDI) file is the foundation for all the subsequent environmental data submitted to ERPIMS and ties together all hydrogeological and chemical data.  A location is a uniquely defined geographical point where some environmental sample or measurement was taken for inclusion into ERPIMS.  Incomplete location definition information will limit the usefulness of the data in Geographic Information Systems (GIS).  The Location Identification (LOCID) for a given location must be consistent throughout a submission and between submissions.  A sampling location that may have begun as a bore hole and was later completed as a monitoring well needs only one LDI record.  The LDI information is mandatory.  If a location has not been previously entered into ERPIMS, and it was not provided when submitting a current LDI file, the location's technical information cannot be accepted.  (See Section 3, Definitions, for more information.)

 

Note: There can be only one sampling location with a given coordinate pair.  Distinction of samples collected at different depths or contained in different matrices are reflected in the Samples table and must not be treated as if collected from different LOCIDs.  If a location type is converted, say from a bore hole to a monitoring well, contact the ERPIMS Help Desk to have the location information updated.  A list of all the current locations and the associated information is automatically downloaded in a project during the application synchronization process.

 

Changes to location coordinates, elevation and well measuring point elevation, and well maintenance resulting in changes to casings, screen changes, or depths should be coordinated with the Help Desk.

 

Whenever a new well or bore hole location is submitted, lithology (LTD) data should be submitted also.  Well locations should have any applicable site (SLX) data provided.  Newly established or reported well locations should have well completion data (WCI) and well interval data (WINT) submitted.

When normal environmental samples are taken from monitoring wells, GWD must be provided with the Group 2 data.  Missing GWD data will result in the data submission being considered incomplete.

 

 

 

 

Short Field Name

Required?

Start

End

AFIID

Yes

1

5

LOCID

Yes

7

21

LTCCODE

No

23

24

LPRCODE

No

26

26

NCOORD

No

28

38

ECOORD

No

40

50

CRDTYPE

No

52

54

CRDMETH

No

56

60

CRDUNITS

No

62

71

CRDUN

No

73

79

ESTDATE

No

81

91

ESCCODE

No

93

96

DRLCODE

No

98

101

EXCCODE

No

103

106

CMCCODE

No

108

109

ELEV

No

111

118

ELEVMETH

No

120

124

ELEVUNITS

No

126

135

ELEVUN

No

137

143

ELFLAG

No

145

145

DEPTH

No

147

154

BHDIAM

No

156

160

BHANGLE

No

162

167

BHAZIM

No

169

175

DATUM

No

177

181

STPZONE

No

183

187

UTMZONE

No

189

193

GEOLOG

No

195

229

LOCDESC

No

231

470

CP_DIAM

No

472

479




All photos contained in this online document are linked to full sided images of the imbedded image.  Simply click on the image to have a browser view the image in its full size.


For questions or concerns on any information on this page please Email ERPIMS Help Desk.
This page last updated 9/4/2012
© 2014 United States Government, as represented by the Secretary of the Air Force.  All rights reserved.