File specifications for GIS connections (Links): CONCEPTUAL LINK DATA BASE |
||
Field Number
|
Description
|
|
1
|
Upstream Node Number |
(F8.1)
|
2
|
Downstream Node Number |
(F8.1)
|
3
|
Upstream Topographic Elevation |
(F8.2)
|
4
|
Downstream Topographic Elevation |
(F8.2)
|
5
|
Associated Node Number |
(F8.1)
|
6
|
Label |
('10 CHARACTERS')
|
7
|
Hydrologic/hydraulic process ID |
(I3)
|
8
|
Length |
(F8.2)
|
9
|
Topographic Slope |
(F7.5)
|
10
|
Curb Height |
(F6.3)
|
11
|
Half Street Width |
(F8.2)
|
12
|
Gutter Lip |
(F8.4)
|
13
|
Gutter Width |
(F8.4)
|
14
|
Gutter Hike |
(F8.4)
|
15
|
Distance from Crown to Grade Break |
(F8.2)
|
16
|
Interior Street Grade |
(F8.4)
|
17
|
Exterior Street Grade |
(F8.4)
|
18
|
Parkway Grade |
(F8.4)
|
19
|
Street Carry Capacity (1 = one-side; 2 = two-side) |
(I2)
|
20
|
Street Friction Factor |
(F8.4)
|
21
|
Street ID |
(I3)
|
22
|
Existing Conduit ID |
(I3)
|
23
|
Diameter/Height(Existing system) |
(F8.3)
|
24
|
Width(Existing system) |
(F8.3)
|
25
|
Side slope(Existing system) |
(F8.3)
|
26
|
Friction factor(Existing system) |
(F8.4)
|
27
|
Freeboard(Existing system) |
(F8.2)
|
28
|
Upstream Invert Elevation(Existing system) |
(F8.2)
|
29
|
Downstream Invert Elevation(Existing system) |
(F8.2)
|
30
|
Invert Slope(Existing system) |
(F8.4)
|
31
|
Recommended Peak Flow Rate(includes Street Flow) for Storm Event #1 for Upstream Node Number. |
(F10.2)
|
32
|
Recommended Peak Flow Rate(includes Street Flow) for Storm Event #2 for Upstream Node Number. |
(F10.2)
|
33
|
Recommended Peak Flow Rate(includes Street Flow) for Storm Event #3 for Upstream Node Number. |
(F10.2)
|
34
|
Recommended Peak Flow Rate(includes Street Flow) for Storm Event #4 for Upstream Node Number. |
(F10.2)
|
35
|
Recommended Peak Flow Rate(includes Street Flow) for Storm Event #5 for Upstream Node Number. |
(F10.2)
|
36
|
Recommended Peak Flow Rate(includes Street Flow) for Storm Event #6 for Upstream Node Number. |
(F10.2)
|
37
|
Recommended Peak Flow Rate(includes Street Flow) for Storm Event #1 for Downstream Node Number. |
(F10.2)
|
38
|
Recommended Peak Flow Rate(includes Street Flow) for Storm Event #2 for Downstream Node Number. |
(F10.2)
|
39
|
Recommended Peak Flow Rate(includes Street Flow) for Storm Event #3 for Downstream Node Number. |
(F10.2)
|
40
|
Recommended Peak Flow Rate(includes Street Flow) for Storm Event #4 for Downstream Node Number. |
(F10.2)
|
41
|
Recommended Peak Flow Rate(includes Street Flow) for Storm Event #5 for Downstream Node Number. |
(F10.2)
|
42
|
Recommended Peak Flow Rate(includes Street Flow) for Storm Event #6 for Downstream Node Number. |
(F10.2)
|
43
|
Street Allowable Flow Depth for Storm Event #1. |
(F8.3)
|
44
|
Street Allowable Flow Depth for Storm Event #2. |
(F8.3)
|
45
|
Street Allowable Flow Depth for Storm Event #3. |
(F8.3)
|
46
|
Street Allowable Flow Depth for Storm Event #4. |
(F8.3)
|
47
|
Street Allowable Flow Depth for Storm Event #5. |
(F8.3)
|
48
|
Street Allowable Flow Depth for Storm Event #6. |
(F8.3)
|
49
|
Street Capacity for Storm Event #1. |
(F8.2)
|
50
|
Street Capacity for Storm Event #2. |
(F8.2)
|
51
|
Street Capacity for Storm Event #3. |
(F8.2)
|
52
|
Street Capacity for Storm Event #4. |
(F8.2)
|
53
|
Street Capacity for Storm Event #5. |
(F8.2)
|
54
|
Street Capacity for Storm Event #6. |
(F8.2)
|
55
|
HGL Optimized Friction Slope. |
(F8.4)
|
56
|
Maximum Possible Friction Slope. |
(F8.4)
|
57
|
Balanced U/S HGL. |
(F8.4)
|
58
|
Balanced D/S HGL. |
(F8.4)
|
59
|
Future Development. |
(F8.4)
|
60
|
Future Development. |
(F8.4)
|
61
|
Future Development. |
(F8.4)
|
62
|
User Recommended Replacement/Parallel System Flag. (1 = Replacement; 2 = Parallel) |
(F8.4)
|
63
|
Computer Estimated Friction Slope for Estimating Existing Conduit Capacity. |
(F8.4)
|
64
|
Computer Recommended Friction Slope for Estimating Existing Conduit Capacity. |
(F8.4)
|
65
|
User-Recommended Friction Slope for Estimating Existing Conduit Capacity. |
(F8.4)
|
66
|
Ratio |
(F8.4)
|
67
|
Future Development |
(F8.4)
|
68
|
Computer Estimated Friction Slope for Estimating Future Conduit Capacity. |
(F8.4)
|
69
|
Computer Recommended Friction Slope for Estimating Future Conduit Capacity. |
(F8.4)
|
70
|
User-Recommended Friction Slope for Estimating Future Conduit Capacity. |
(F8.4)
|
71
|
Ratio |
(F8.4)
|
72
|
Future Development |
(F8.4)
|
73
|
Computer Estimated Existing Conduit Conveyance Capacity. |
(F8.2)
|
74
|
Computer Recommended Existing Conduit Conveyance Capacity. |
(F8.2)
|
75
|
User-Recommended Existing Conduit Conveyance Capacity. |
(F8.2)
|
76
|
Ratio |
(F8.2)
|
77
|
Future Development |
(F8.2)
|
78
|
Existing Total Conveyance Capacity for Storm Event #1. |
(F10.2)
|
79
|
Existing Total Conveyance Capacity for Storm Event #2. |
(F10.2)
|
80
|
Existing Total Conveyance Capacity for Storm Event #3. |
(F10.2)
|
81
|
Existing Total Conveyance Capacity for Storm Event #4. |
(F10.2)
|
82
|
Existing Total Conveyance Capacity for Storm Event #5. |
(F10.2)
|
83
|
Existing Total Conveyance Capacity for Storm Event #6. |
(F10.2)
|
84
|
Deficiency for Storm Event #1(based upon user-recommended peak flow rate). |
(F10.2)
|
85
|
Deficiency for Storm Event #2(based upon user-recommended peak flow rate). |
(F10.2)
|
86
|
Deficiency for Storm Event #3(based upon user-recommended peak flow rate). |
(F10.2)
|
87
|
Deficiency for Storm Event #4(based upon user-recommended peak flow rate). |
(F10.2)
|
88
|
Deficiency for Storm Event #5(based upon user-recommended peak flow rate). |
(F10.2)
|
89
|
Deficiency for Storm Event #6(based upon user-recommended peak flow rate). |
(F10.2)
|
90
|
Deficiency Target Delta Peak Flow Rate. |
(F10.2)
|
91
|
Deficiency Target Return Frequency. |
(I4)
|
92
|
Diameter/Height(Computer Estimated Replacement System). |
(F8.3)
|
93
|
Width(Computer Estimated Replacement System). |
(F8.3)
|
94
|
Side slope(Computer Estimated Replacement System). |
(F8.5)
|
95
|
Friction factor(Computer Estimated Replacement System). |
(F8.5)
|
96
|
Freeboard(Computer Estimated Replacement System). |
(F8.2)
|
97
|
System Peak Flow Rate(Computer Estimated). |
(F8.2)
|
98
|
Diameter (Computer Estimated Parallel System). |
(F8.2)
|
99
|
Friction Factor (Computer Estimated Parallel System). |
(F8.5)
|
100
|
System Cost Status. |
(F8.2)
|
101
|
Other Data (Computer Estimated Parallel System). |
(F8.2)
|
102
|
Diameter/Height(Computer Recommended Replacement System). |
(F8.3)
|
103
|
Width(Computer Recommended Replacement System). |
(F8.3)
|
104
|
Side slope(Computer Recommended Replacement System). |
(F8.5)
|
105
|
Friction factor(Computer Recommended Replacement System). |
(F8.5)
|
106
|
Freeboard(Computer Recommended Replacement System). |
(F8.2)
|
107
|
System Peak Flow Rate(Computer Recommended). |
(F8.2)
|
108
|
Diameter (Computer Recommended Parallel System). |
(F8.2)
|
109
|
Friction Factor (Computer Recommended Parallel System). |
(F8.5)
|
110
|
Computer Recommended System ID. |
(F8.2)
|
111
|
Other Data (Computer Recommended Parallel System). |
(F8.2)
|
112
|
Diameter/Height(User Recommended Replacement System). |
(F8.3)
|
113
|
Width(User Recommended Replacement System). |
(F8.3)
|
114
|
Side slope(User Recommended Replacement System). |
(F8.5)
|
115
|
Friction factor(User Recommended Replacement System). |
(F8.5)
|
116
|
Freeboard(User Recommended Replacement System). |
(F8.2)
|
117
|
Other Data(User Recommended Replacement System). |
(F8.2)
|
118
|
Diameter (User Recommended Parallel System). |
(F8.2)
|
119
|
Friction Factor (User Recommended Parallel System). |
(F8.5)
|
120
|
Other Data (User Recommended Parallel System). |
(F8.2)
|
121
|
Other Data (User Recommended Parallel System). |
(F8.2)
|
122
|
Recommended System Code. |
(I3)
|
123
|
Recommended System ID |
(I3)
|
124
|
Upstream Invert Elevation(Recommended system) |
(F8.2)
|
125
|
Downstream Invert Elevation(Recommended system) |
(F8.2)
|
126
|
Upstream flow velocity for Recommended system. |
(F8.2)
|
127
|
Downstream flow velocity for Recommended system. |
(F8.2)
|
128
|
Upstream flow depth for Recommended system. |
(F8.2)
|
129
|
Upstream HGL for Recommended system. |
(F8.2)
|
130
|
Downstream flow depth for Recommended system. |
(F8.2)
|
131
|
Downstream HGL for Recommended system. |
(F8.2)
|
132
|
Difference of upstream HGL and Nodal Elevation for Recommended system. |
(F8.2)
|
133
|
Difference of downstream HGL and Nodal Elevation for Recommended system. |
(F8.2)
|
134
|
Normal Depth |
(F8.2)
|
135
|
Critical Depth |
(F8.2)
|
136
|
Unit cost opinion |
(F8.2)
|
137
|
Cost-to-Benefit Index |
(F8.2)
|
138
|
Priority Grouping |
(I3)
|
Add 50 fields for string template data. |