GIS Module
Click here to see this page in full context

FLAT FILE SPECIFICATIONS - GIS MODULE

***WARNING***   The data (primarily notes / comments) may contain line feeds, carriage returns, and/or end of transmission blocks.  These need to be ignored when uploading your data.  ***WARNING***

 

The flat file specifications associated with the tables in the GIS Module are documented, by table, below.

 

     

GS_GIS

English Name

Starting Column

Field Length

Data Type

 Excel Column
EPA Handler ID

1

12

Alphanumeric

 A
GIS Owner

13

2

Alphanumeric

 B
GIS Sequence Number

15

4

Integer

 C
Process Unit Sequence Number

19

4

Integer

 D
Area Sequence Number

23

4

Integer

 E

Area Acreage

27

13

Integer

 F

Area Source Code Owner

40

2

Alphanumeric

 G
Area Source Code

42

4

Alphanumeric

 H
Area Source Date

46

8

Date (YYYYMMDD)

 I
Data Collection Date

54

8

Date (YYYYMMDD)

 J
Horizontal Accuracy Measure

62

6

Integer

 K
Source Map Scale Number

68

10

Integer

 L
Coordinate Data Code Owner

78

2

Alphanumeric

 M
Coordinate Data Code

80

3

Alphanumeric

 N
Geographic Reference Point Code Owner

83

2

Alphanumeric

 O
Geographic Reference Point

85

3

Alphanumeric

 P
Geometric Code Owner

88

2

Alphanumeric

 Q
Geometric Code

90

3

Alphanumeric

 R
Horizontal Collection Code Owner

93

2

Alphanumeric

 S
Horizontal Collection Code

95

3

Alphanumeric

 T
Horizontal Reference Code Owner

98

2

Alphanumeric

 U
Horizontal Reference Code

100

3

Alphanumeric

 V
Verification Method Code Owner

103

2

Alphanumeric

 W
Verification Method Code

105

3

Alphanumeric

 X

GS_GIS_LAT_LONG

English Name

Starting Column

Field Length

Data Type

 Excel Column
EPA Handler ID

1

12

Alphanumeric

 A
GIS Owner

13

2

Alphanumeric

 B
GIS Sequence Number

15

4

Integer

 C

GIS Latitude Longitude Sequence Number

19

4

Integer

 D
Latitude Measure

23

10

Number

 E

Longitude Measure

33

11

Number

 F

GS_LU_AREA_SOURCE

English Name

Starting Column

Field Length

Data Type

 Excel Column
Area Source Owner

1

2

Alphanumeric

 A
Area Source

3

4

Alphanumeric

 B
Area Source Description

7

80

Alphanumeric

 C
Active Status

87

1

Alphanumeric

 D

GS_LU_COORDINATE

English Name

Starting Column

Field Length

Data Type

 Excel Column

Coordinate Owner

1

2

Alphanumeric

 A
Coordinate

3

3

Alphanumeric

 B
Coordinate Description

6

120

Alphanumeric

 C
Active Status

126

1

Alphanumeric

 D

GS_LU_GEOGRAPHIC_REFERENCE

English Name

Starting Column

Field Length

Data Type

 Excel Column

Geographic Reference Owner

1

2

Alphanumeric

 A
Geographic Reference

3

3

Alphanumeric

 B
Geographic Reference Description

6

240

Alphanumeric

 C
Active Status

246

1

Alphanumeric

 D

GS_LU_GEOMETRIC

English Name

Starting Column

Field Length

Data Type

 Excel Column

Geometric Owner

1

2

Alphanumeric

 A
Geometric

3

3

Alphanumeric

 B
Geometric Description

6

200

Alphanumeric

 C
Active Status

206

1

Alphanumeric

 D

GS_LU_HORIZONTAL_COLLECTION

English Name

Starting Column

Field Length

Data Type

 Excel Column

Horizontal Collection Owner

1

2

Alphanumeric

 A
Horizontal Collection

3

3

Alphanumeric

 B
Horizontal Collection Description

6

200

Alphanumeric

 C
Active Status

206

1

Alphanumeric

 D

GS_LU_HORIZONTAL_REFERENCE

English Name

Starting Column

Field Length

Data Type

 Excel Column

Horizontal Reference Owner

1

2

Alphanumeric

 A
Horizontal Reference

3

3

Alphanumeric

 B
Horizontal Reference Description

6

50

Alphanumeric

 C
Active Status

56

1

Alphanumeric

 D

GS_LU_VERIFICATION

English Name

Starting Column

Field Length

Data Type

 Excel Column

Verification Method Owner

1

2

Alphanumeric

 A
Verification Method

3

3

Alphanumeric

 B
Verification Method Description

6

120

Alphanumeric

 C
Active Status

126

1

Alphanumeric

 D