Table Report
For STNETALL
|
Field Name |
Field Description |
Field Type |
Field Length |
|
ADD_MAX |
Maximum address number for the segment |
Long integer |
9 |
|
ADD_MIN |
Minimum address number for the segment |
Long integer |
9 |
|
FINT |
From-intersection point ID |
Long integer |
9 |
|
L_ADD_FROM |
Left-side beginning address number for the segment |
Long integer |
9 |
|
L_ADD_TO |
Left-side ending address number for the segment |
Long integer |
9 |
|
PC_UID |
Unique ID, non-persistent |
Long integer |
9 |
|
PRE_DIR |
Street prefix direction |
Text |
2 |
|
R_ADD_FROM |
Right-side begining address number for the segment |
Long integer |
9 |
|
R_ADD_TO |
Right-side ending address number for the segment |
Long integer |
9 |
|
ROADCAT_CD |
Road category code |
Text |
10 |
|
ROADCAT_DS |
Road category description |
Text |
40 |
|
ROADID |
Unique ID for the segment, persistent |
Long integer |
9 |
|
STNAMETYPE |
Concatenation of the street name and street type, with no street direction |
Text |
40 |
|
STR_NAME |
Street name |
Text |
40 |
|
STR_TYPE |
Street type |
Text |
2 |
|
STREET |
Full street name, including prefix direction, name, type, and suffix direction |
Text |
50 |
|
STRLVL_CD |
Street level code (over/underpass indicator) |
Text |
5 |
|
SUF_DIR |
Street suffix direction |
Text |
2 |
|
TINT |
To-intersection point ID |
Long integer |
9 |
|
TRAVDIR_CD |
Direction of travel code (one-way street indicator) typically based on PRE_DIR. Values are: 'W' which means direction of travel along the street is "with" the street prefix direction. 'A' means "against" and 'B' means "both". |
Text |
5 |
PRE_DIR and SUF_DIR Values:
|
N |
|
E |
|
S |
|
W |
STR_TYPE Values:
|
STR_TYPE |
DESCRIPTION |
|
AL |
Alley |
|
AV |
Avenue |
|
BW |
Beltway |
|
BL |
Boulevard |
|
CI |
Circle |
|
CT |
Court |
|
DR |
Drive |
|
HY |
Highway |
|
LN |
Lane |
|
LP |
Loop |
|
PH |
Path |
|
PL |
Place |
|
PS |
Pass |
|
PW |
Parkway |
|
RD |
Road |
|
SQ |
Square |
|
ST |
Street |
|
SV |
Stravenue |
|
TE |
Terrace |
|
TR |
Trail |
|
WY |
Way |
ROADCAT_CD and ROADCAT_DS Values:
|
ROADCAT_CD |
ROADCAT_DS |
|
FRNT_RD |
Frontage road |
|
IND_RT |
Indian route |
|
INTERSTATE |
Interstate highway |
|
RMP_INT |
Interstate ramp |
|
LRD_MJ |
Major local road |
|
RMP_RDMJ |
Major road ramp |
|
LRD_MN |
Minor local road |
|
ST_RT |
State route |
|
RMP_STRT |
State route ramp |
TRAVDIR_CD Values:
|
A |
Against street direction |
|
B |
Both directions |
|
W |
With street direction |
STRVL_CD Values:
|
-1 |
1 level down |
|
0 |
Ground level |
|
1 |
1 level up |
|
2 |
2 levels up |
|
3 |
3 levels up |