Road Atlas of BC

Brief Road Description

 

PACKAGE

FIELD

TYPE

DESCRIPTION

CODE LIST or examples

all

GISI_ID

number(11,0)

the unique identifier from GISI

note that this is the last field in MapInfo

name

 

 

 

 

name

STREETNAME

char(40)

the fully concatenated road name using numeric suffixes

eg: "Main St", "E 12th AVE"

name

STPREDIR

char(2)

directional prefix

N,S,E,W,NE,NW,SW,SE

name

STPRETYPE

char(4)

road type prefix

HWY, RD, RUE

name

STNAME

char(40)

name (without suffixes)

eg: Main, 1, 22, 123

name

STNAMESUF

char(40)

name (including the suffix portion of numbered roads)

eg: Main, 1st, 22nd, 123rd

name

STTYPE

char(10)

the road type as per GISI;s list

eg: AVE, ST, RD, and more

name

STSUFDIR

char(2)

directional suffix

N,S,E,W,NE,NW,SW,SE

name

STRUCTURE

char(12)

additional information trailing a standard name

BRIDGE, TUNNEL, TERMINAL, and more

name

STNAME_ID

number(11,0)

Unique numeric identifier

 

 

 

 

 

 

name

ALIASNAME

char(40)

ALIAS-name, fully concatenated

eg: "Main St", "E 12th AVE"

name

ALIPREDIR

char(2)

ALIAS-directional prefix

N,S,E,W,NE,NW,SW,SE

name

ALIPRETYPE

char(4)

ALAIS- road type prefix

HWY, RD, RUE

name

ALINAME

char(40)

ALIAS (without suffixes)

eg: Main, 1, 22,123

name

ALINAMESUF

char(40)

ALIAS- (including the suffix portion of numbered roads)

eg: Main, 1st, 22nd, 123rd

name

ALITYPE

char(10)

ALIAS type as per GISI;s list

eg: AVE, ST, RD, and more

name

ALISUFDIR

char(2)

ALIAS-directional suffix

N,S,E,W,NE,NW,SW,SE

name

ALISTRUCT

char(12)

ALIAS-additional information trailing a standard name

BRIDGE, TUNNEL, TERMINAL, and more

name

ALIAS_ID

number(11,0)

Unique numeric identifier

 

 

 

 

 

 

name

HWYRTE

char(12)

the numbered Highway designator, "+" delimited

eg: 1, 1A, 99, 1A+99A

name

EXIT_NUM

char(6)

a highway exit number

eg: 28, 28A, 28AB

name

RD_CLASS

char(12)

the road class

eg: HIGHWAY, LOCAL, and more

name

RD_CLASSID

number(6,0)

a numerical version of the road class (TYPE in MapInfo)

eg: 1=FREEWAY, 8=LOCAL, through to 17

 

geocode

 

 

 

 

geocode

RD_SUBCLSS

char(16)

a finer version of the road class

eg: MINOR HIGHWAY and more

geocode

RD_SUBCLID

number(6,0)

a numerical version of the road subclass (TYPES in MapInfo)

eg: 1=FREEWAY, 8=LOCAL, through to 17

geocode

FROMLEFT

number(11,0)

address range From Left

 101

geocode

TOLEFT

number(11,0)

address range To Left

 199

geocode

FROMRIGHT

number(11,0)

address range From Right

 100

geocode

TORIGHT

number(11,0)

address range ToRight

 198

geocode

SINGLEADDR

number(11,0)

single address applied to the whole road, mostly strata roads

 888

geocode

ADDRTYPE_L

char(1)

addressing style Left (even, odd, continuous, strata, none)

E,O,C,S,N, e,o,c,s

geocode

ADDRTYPE_R

char(1)

addressing style Right (even, odd, continuous, strata, none)

E,O,C,S,N, e,o,c,s

geocode

CITY_LEFT

char(32)

"city" (GISI locality) Left

eg: Vancouver

geocode

CITY_RIGHT

char(32)

"city" (GISI locality) Right

eg: Burnaby

geocode

RGN_LEFT

char(6)

Regional District Left (abbr)

eg: GVRD

geocode

RGN_RIGHT

char(6)

Regional District Left (abbr)

eg: GVRD

geocode

CSD_LEFT

number(11,0)

Census Subdivision Left

reserved for FUTURE use

geocode

CSD_RIGHT

number(11,0)

Census Subdivision Right

reserved for FUTURE use

 

nav

 

 

 

 

nav

DIROFTVL

char(2)

the direction of vehicle travel vs. the vector direction

B,1F,1R,2F,2R,DF,DR

nav

RD_ACCESS

number(6,0)

a numeric code describing the accessibility of the road

0=no restriction, >1 restricted in some manner

nav

RD_SURFACE

char(6)

a description of the road surface

Paved, Loose, Rough, Boat

nav

MAX_SPEED

number(6,0)

maximum speed in "kph"

10,15,20,30,40,50,60,70,80,90,100,110

nav

DISTR_RTE

char(1)

disaster route flag

Y or null - reserved for future usage

nav

TRUCK_RTE

char(1)

truck route flag

Y or null - reserved for future usage

nav

NUMLANES_L

char(1)

number of lanes Left of Centreline

0,R,N,1,2,3,4

nav

NUMLANES_R

char(1)

number of lanes Right of Centreline

0,R,N,1,2,3,4

nav

NUMSPDBMPS

number(6,0)

the number of speedbumps or cattleguards on the road

reserved for FUTURE use

nav

FR_STOP

char(1)

a travel impactor at the FROM end of the segment

S,Y,U,O,C,L (will be expanded for rail)

nav

TO_STOP

char(1)

a travel impactor at the TO end of the segment

S,Y,U,O,C,L (will be expanded for rail)

nav

FR_WEIGHT

number(6,0)

From end, maximum weight, in "kg"

eg. 5000

nav

TO_WEIGHT

number(6,0)

To end, maximum weight, in "kg"

 

nav

FR_HEIGHT

number(6,2)

From end, maximum height, in "m.cm"

eg. 4.38

nav

TO_HEIGHT

number(6,2)

To end, maximum height, in "m.cm"

 

nav

FR_WIDTH

number(6,2)

From end, maximum width, in "m.cm"

eg. 5.50

nav

TO_WIDTH

number(6,2)

To end, maximum width, in "m.cm"

 

nav

FR_TURNL

char(4)

FromLeft -The DAYS of the turning restriction

MF, MS, SS

nav

FR_TL_TIME

char(4)

FromLeft -The TIMES of the turning restriction

AM, PM, AMPM, DAY, 24

nav

FR_TURNR

char(4)

FromRight-The DAYS of the turning restriction

MF, MS, SS

nav

FR_TR_TIME

char(4)

FromRight-The TIMES of the turning restriction

AM, PM, AMPM, DAY, 24

nav

FR_STRGHT

char(4)

FromStraight-The DAYS of the turning restriction

MF, MS, SS

nav

FR_ST_TIME

char(4)

FromStraight-The TIMES of the turning restriction

AM, PM, AMPM, DAY, 24

nav

TO_TURNL

char(4)

ToLeft-The DAYS of the turning restriction

MF, MS, SS

nav

TO_TL_TIME

char(4)

ToLeft-The TIMES of the turning restriction

AM, PM, AMPM, DAY, 24

nav

TO_TURNR

char(4)

ToRight-The DAYS of the turning restriction

MF, MS, SS

nav

TO_TR_TIME

char(4)

ToRight-The TIMES of the turning restriction

AM, PM, AMPM, DAY, 24

nav

TO_STRGHT

char(4)

ToStraight-The DAYS of the turning restriction

MF, MS, SS

nav

TO_ST_TIME

char(4)

ToStraight-The TIMES of the turning restriction

AM, PM, AMPM, DAY, 24

 

topo

 

 

 

 

topo

SEG_LENGTH

number(11,3)

the length of the road segment in "m" (BCALBERS)

n/a

topo

FR_AZIMUTH

number(6,0)

the angle of entry into the road segment "deg" (BCALBERS)

n/a

topo

TO_AZIMUTH

number(6,0)

the angle of egress from the road segment in "deg" (BCALBERS)

n/a

topo

FR_NODE

number(11,0)

our maintained network Node topology, From

n/a

topo

TO_NODE

number(11,0)

our maintained network Node topology, To

n/a

metadata

 

 

 

 

metadata

POSITIONBY

char(12)

the primary source of the roadway positioning

eg: GPS, TRIM, SKETCH, and more

metadata

UPDT_ZONE

char(8)

a code describing the GISI maintenance/update zone

eg: GVRD, and more

 

update

 

 

 

 

update

UPDT_ACT

char(1)

update action, Delete, Insert, UpdateAttritbutesOnly, GraphicsUpdate, Both U&G, Meta

D,I,U,G,B,M

update

UPDT_DATE

date

the release date of the update

eg. 20040301

update

ADMIN_CH

char(1)

indicates an road class (class or subclass) or an administrative link change (city, region, etc)

T or F, eg. "T" if the city boundary changed or road reclassified

update

NAME_CH

char(1)

indicates a road name change (name, alias, hwy_rte, exit_num)

T or F, eg. "T" if road was renamed or corrected

update

ADDR_CH

char(1)

indicates a geocoding attribute change

T or F, eg. "T" if the FROMLEFT address ranges changes

update

NAV_CH

char(1)

indicates a navigation attribute change

T or F, eg. "T" if a speed changes

update

GEO_CH

char(1)

indicates a topology attribute changes

T or F or M, eg: "T" if there is a geometry change, M recalculated topology but no change to geometry

update

META_CH

char(1)

indicates a metadata change

T or F, eg: "T" if the road is recoded as GPS from SKETCH

Best printed in Landscape
Last Revised: 13 June 2006
Last revised: 30 Dec 2005 revised rd_classid and rd_subclid to max to 17 for service road