File Name: \lockchar\data\lockchar.txt and \lockchar\dbf\lockchar.dbf COLUMN COLUMN
NUMBER NAME DESCRIPTION TYPE WIDTH
1 NDCCODE Unique NDC dock & lock ID TEXT 10
2 REGION Geographic Region code TEXT 02
AT=ATLANTIC IN=INLAND
GL=GREAT LAKES PC=PACIFIC COAST
GU=GULF OF MEXICO
3 RIVERCD LPMS river code TEXT 02
4 LOCKCD LPMS lock code TEXT 02
5 CHMBCD LPMS chamber code TEXT 01
6 NOCHMB # of chambers in the lock INTG 01
7 SITEOM HQ's accountable lock site (Y/N) TEXT 01
8 SITENDC NDC's accountable lock site (Y/N) TEXT 01
9 FUELTAX Y = Fuel tax site, N = Not TEXT 01
10 PMSDATA LPMS data collected at lock site (Y/N) TEXT 01
11 NAVSTR Structure name (Lock name) TEXT 35
12 CHAMBN Chamber name TEXT 15
13 CHB1 (M) MAIN (A) AUX (C) CONTROL STRUCTURE TEXT 01
14 STR1 Type of structure TEXT 01
(L) LOCK & DAM (F) FLOOD GATE (C) CONTROL STRUCTURE (B) BARRIER
15 PMSNAME LPMS Lock Name TEXT 33
16 ALIAS Alias name of structure TEXT 45
17 STATUS Status of lock (operable/inoperable) TEXT 01
(1) OPERATIONAL
(2) SEASONAL
(3) OPERATIONAL - WEEKEND/SUMMER
(4) UNDER CONSTRUCTION
(5) CARETAKER
(6) INOPERABLE
(7) CLOSED WITH OPEN GATES
(8) REPLACED
18 RIVER River name TEXT 35
19 RIVERMI River milepoint of structure NUMB 6,2
20 BANK Lock location (L or R obnd river bank) TEXT 01
21 LIFT Dist. from empty to full NUMB 05
22 LENGTH Length of chamber NUMB 05
23 CHMBUL Chamber useable length NUMB 05
24 WIDTH Width of chamber NUMB 05
25 CHMBUW Chamber useable width NUMB 05
26 AUDPA Authorized channel depth (above) NUMB 05
27 AUDPB Authorized channel depth (below) NUMB 05
28 UPDPTHMS Upper depth of miter sill NUMB 05
29 LWDPTHMS Lower depth of miter sill NUMB 05
30 YEAROPEN Year structure opened NUMB 04
31 GATETYPE Physical description of gate TEXT 50
32 GATE Type of gate TEXT 01
(1) MITER (2) MOVEABLE (3) SECTOR (4) TAINTER
(5) VERTICAL & SUBMERSIBLE
(6) LEAF (7) REPLACED
33 CHNLGTH Channel length NUMB 05
34 CHNDPTHA Channel depth (above) NUMB 05
35 CHNDPTHB Channel depth (below) NUMB 05
36 CHNWDTHA Channel width (above) NUMB 05
37 CHNWDTHB Channel width (below) NUMB 05
38 WWPROJCT Waterway project TEXT 50
39 LAKEPOOL Navigation poolname TEXT 35
40 POOLELEV Elevation of pool from datum NUMB 05
41 POOLDTM Pool datum used for measurement TEXT 15
42 POOLNGTH Pool length NUMB 07
43 POOLST Pool state TEXT 02
44 MOORING Mooring devices (Y or N) TEXT 01
45 MULTI Multi use of structure TEXT 06
(N) NAVIGATION (P) POWER
(R) RECREATION (F) FLOOD CONTROL
(C) COMMERCIAL (I) IRRAGATION
46 DIVISION COE Division TEXT 04
47 DISTRICT COE District TEXT 03
48 STATE State of lock TEXT 02
These codes are for the following fields: BUILT*, MAINT*, OPER*, OWNER*
1 = CORPS 2 = TVA 3 = OTHER FEDERAL
4 = STATE 5 = LOCAL (CITY) 6 = PRIVATE
7 = CONTRACTOR 8 = CARETAKER 9 = OTHER
10 = UNKNOWN
49 BUILT1 Designated code for builder of lock NUMB 02
50 BUILT1P Percentage built NUMB 06
51 BUILT2 Designated code for co-builder of lock NUMB 02
52 BUILT2P Co-Percentage built NUMB 06
53 MAINT1 Designated code for maintenance NUMB 02
54 MAINT1P Percentage of maintenance NUMB 06
55 MAINT2 Designated code for co-maintenance NUMB 02
56 MAINT2P Co-Percentage of maintenance NUMB 06
57 MAINT3 Designated code for co-maintenance NUMB 02
58 MAINT3P Co-Percentage of maintenance NUMB 06
59 OPER1 Designated code for operation NUMB 02
60 OPER1P Percentage of operation NUMB 06
61 OPER2 Designated code for co-operation NUMB 02
62 OPER2P Percentage of co-operation NUMB 06
63 OPER3 Designated code for co-operation NUMB 02
64 OPER3P Percentage of co-operation NUMB 06
65 OWNER1 Designated code for owner NUMB 02
66 OWNER1P Percentage of ownership NUMB 06
67 OWNER2 Designated code for co-owner NUMB 02
68 OWNER2P Percentage of co-ownership NUMB 06
69 DUPDATE Last date of data update TEXT 08
71 PWDDATE Last date of PWD survey update TEXT 08
72 LKMSTR Name of lock master TEXT 35
73 RADIOC Coast Guard radio call sign TEXT 07
74 MAIL1O Official mail header TEXT 60
75 MAIL1ADD Mail address TEXT 45
76 MAILCTY Mail city TEXT 30
77 MAILST Mail state TEXT 02
78 MAILZIP Mail zip code TEXT 10
79 LKPHONE Lock phone number TEXT 14
80 LKPHEXT Lock phone number extension TEXT 04
81 FAX Lock fax number TEXT 14
82 DISTCONT COE District contact person TEXT 35
83 DISTPH COE District contact phone number TEXT 14
84 DISTEXT COE District contact phone extension TEXT 04
85 DISTFAX COE District contact fax number TEXT 14
86 DFAXEXT COE District contact fax extension TEXT 04
87 TOWN Town of structure TEXT 30
88 COUNTY1 County of structure TEXT 30
89 CNGDST1 Congressional district of structure TEXT 10
90 SEG LPMS Waterway segment number TEXT 02
91 AUTHDOC Congressional authorized TEXT 60
document number
92 CWIS CWIS# (CORPS use) TEXT 05
93 MAJREHAB Last year of major rehabilitation TEXT 04
94 NAVSTORE Navigation storage facilities (Y or N) TEXT 01
95 MOORING_R Mooring remarks TEXT 70
96 DAMSLGTH Length of dam TEXT 06
97 DAMYR Year dam built NUMB 04
98 HGWY_CNT Highway connection near lock site TEXT 60
99 GEN_REMK General lock site remarks TEXT 80
100 REP_LK_N Name of replaced lock (lookup) TEXT 35
101 REPLK_CD NDC code for replaced lock (lookup) TEXT 10
102 CNGDST2 Congressional district of structure TEXT 10
|
Top