URISA - Redistricting
Download
Report
Transcript URISA - Redistricting
Development of an Enterprise
Transportation Data Model for
Fairfax County, Virginia
Presented by:
Jim Fries
PlanGraphics, Inc
Brendan Ford
Fairfax County GIS
Presentation Topics
•
Background/Existing Situation
•
Model Requirements
•
Model Development Process
•
Existing Model Review
•
Transportation Network Applications
•
911 CAD and Non-emergency Routing Needs
•
Logical Model
•
Issues and Next Steps
Where is Fairfax County?
1990 Population:
818,584
2000 Population:
969,749 (+18.5%)
Total Land Area:
400 square miles
Roadway Miles:
Over 4,000 miles
Regional Area
City of Fairfax
Loudoun County
City of Falls
Church
Arlington
County
City of
Alexandria
Prince William
County
Fairfax County
Stafford County
Existing Situation
Multiple centerlines currently in use
Enterprise, School, E911
Implementing a new CAD system
Go live target of Q4 2008
Strong data sharing ties with State and other
local governments
Lots of users and agencies with desire to
perform AVRR applications
Existing CAD system does not support routing
Enterprise Centerline
Relatively simple data model
One of the most detailed in Virginia
Over 40 attributes
Maintained in Oracle/ArcSDE
Regional (multi-jurisdiction) coverage
Updated regularly based on
(a) plat recordation, (b) site plan approval, (c) error reports
from users, and (d) annual orthoimagery updates
Contains few attributes that support routing
Centerline Model Requirements
Provide a single centerline model that can be used by
all Fairfax County agencies irrespective of purpose
Support advanced automated routing for Fairfax
County’s public safety agencies (Police, Fire & Rescue,
Sheriff, Emergency Management) using new CAD
software
Support routing by non public safety agencies
Allow use by Virginia State Police and Virginia
Department of Transportation to be co-located in
new joint Public Safety and Transportation Operations
Center (PSTOC)
Contribute to the maintenance of the new VITA road
centerline (RCL) dataset for the entire Commonwealth
of Virginia
Participating Agencies
Public Safety
Police
Fire & Rescue
Sheriff
OEM
DPSC
VSP
Non-Public Safety
Public Works and
Environmental Services
Transportation
Human Services
Public Schools
GIS
Others (Parks, TA, etc.)
VDOT
VITA
Model Development Process
Three Step Process: Centerline, AVRR, and Model
Step One: Centerline
Ascertain existing County street centerline and addressing
components, processes, and procedures
Analyze CAD products for centerline and routing capabilities
Evaluate available models, standards, and protocols
Establish comprehensive street centerline requirements
Assess external state and local data sources (9 entities)
Step Two: AVRR
Establish automated vehicle routing recommendation (AVRR)
requirements
Evaluate non-commercial sources for routing data (26
entities)
Model Development Process – con’t
Step Three: Transportation Network Model
Document enterprise transportation network and AVRR
requirements
Prepare and Review Conceptual Strawman Model
Develop Logical Data Model
Prepare Physical Data Model
Existing Model Review
DHS Geospatial Data Model (FGDC)
DOJ (CAD and RMS Draft Specifications)
Global Justice Data Model (Global JXDM)
DOT - BTS NSDI Framework Standard: ANSI
Geographic Information Framework Data Content
Standard – Roads (also Rail, Transit)
National Information Exchange Model
(NIEM) – DOJ and DHS Partnership
Federal
State
Local
Other
Washington DOT
Virginia DOT
King County, Washington (Regional TNet)
Cobb County, Georgia (Etrans)
UNETRANS
NENA
King
County,
Washington
Cobb County, Georgia
DHS Geospatial Model
DHS Geospatial Model
Transportation Network Applications
1.
2.
3.
4.
5.
Address Location (e.g. geocoding, address assignment)
General Analysis/Modeling (e.g., incident and network analysis)
General Reference (e.g., base map layer, reporting, visual reference)
Permitting (e.g., coordination, inspection scheduling)
Planning (e.g., employment and housing forecasts, new facility site selection,
route selection, traffic zone analysis, highway planning)
6.
Road Attribute Determination (e.g., cross street determination, legal
speed limit confirmation)
7.
8.
Public Health and Safety (e.g., 911 dispatching, alert notification)
Emergency Routing (e.g., network incident response, criminal escape
route determination, evacuation route selection)
Routine Routing (e.g., school buses, solid waste, legal service)
10. Asset/Infrastructure Management (e.g., equipment tracking, project
9.
operation and maintenance)
Automated Routing Needs
Automated routing routines must account for multiple factors:
direction of travel
speed (legal and free flow)
grade/inclination
traffic flow
impedances (intersections, turn restrictions, vehicle
restrictions, blockages, obstacles)
other risk factors
Nearly all agencies recognize the value of performing
automated routing across an integrated network that consists
of all roadways, pathways, railways, and waterways
Only four County agencies (public schools, transit,
para-transit, solid waste) currently do limited computerized
routing using different proprietary COTS software packages
Fairfax County Logical Model
Fairfax County Virginia
Logical Diagram
03/02/07
Network Features/
Objects
Boundary Features
AssetPointFeatures
TRANS_ID
JURISDICTION
DATA_SOURCE
EFF_DATE
LAST_UPDATE
TR_CONNECTOR
CONNECTOR_ID
C_NAME
CONNECTOR_TYPE
SURF_TYPE
FEAT_LENGTH
FEAT_WIDTH
MAX_HEIGHT
PointFeatures
TRANS_ID
TRANS_MODE
POINT_MEASURE
LATITUDE
LONGITUDE
JURISDICTION
OWNERSHIP
MAINT_RES
DATA_SOURCE
EFF_DATE
LAST_UPDATE
PolylineFeatures
TR_PATHWAY
TR_RAILWAY
TR_ROADWAY
PATHWAY_ID
PW_NAME
PATH_TYPE
SURF_TYPE
VEHICLE_LIMIT
OWNERSHIP
MAINT_RES
STATUS
FEAT_LENGTH
MIN_WIDTH
DIRECTION
PED_BRIDGE
BARRIER_TYPE
DESCRIP
INV_NUM
XO
TRANSPLAN
MSMPROGRAM
RAILWAY_ID
RR_NAME
ROUTE_NUMBER
USDOT_RAIL_NUMBER
RR_TYPE
RR_SERVICE_TYPE
RR_MP
FROM_MP
TO_MP
MAX_SPEED
STATUS
CFCC
FEAT_LENGTH
FEAT_WIDTH
TRACK_TYPE
TRACK_NUMBER
HAZMAT
SEGID
FX_SOURCE
CFCC
ROAD_CLASS
FFX_CLASS
OWNERSHIP
MAINT_RES
STATUS
AUTHORIZE_USE
CLEARANCE
ROUTING
EMERGENCY_USE
TR_MODE_CONNECTOR
TR_WATERWAY
ACCESS_ID
ACCESS_TYPE
ACCESS_NAME
ALIAS_NAME
PRIMARY_ACCESS
SECONDARY_ACCESS
LOCATION
WARNING_TYPE
WATERWAY_ID
WW_NAME
ALIAS_NAME
WATER_TYPE
FEAT_DEPTH
MIN_NAV_DEPTH
FEAT_WIDTH
FEAT_LENGTH
MAX_SPEED
RESTRICTIONS
OWNERSHIP
MAINT_RES
CFCC
PolygonFeatures
TRANS_ID
TRANS_MODE
POINT_MEASURE
LATITUDE
LONGITUDE
JURISDICTION
DATA_SOURCE
EFF_DATE
LAST_UPDATE
TR_MILE_MARKER
MP_ID
MP
MP_NAME
MP_ACCESS
TR_DAM
TR_STREET_SENSOR
SENSOR_ID
SENSOR_TYPE
DESCRIP
COMM_CONNECTION
ONLINE_ACCESS
STATUS
CROSSING_ID
WATER_LEVEL
PASSABLE
SIGN
LZ_ID
NAME
OBSTACLE
LZ_TYPE
ESN
POLICE
VSP
BOUNDARY_ID
NAME
ESN_NUMBER
ESN_FIRE
ESN_EMS
ESN_POLICE
BOUNDARY_ID
NAME
POL_NUMBER
BOUNDARY_ID
NAME
UNIT_DESIGNATION
FIRE_RESCUE
SCHOOL
VDOT
BOUNDARY_ID
NAME
SCHOOL_NUMBER
BOUNDARY_ID
NAME
VDOT_NUMBER
BOUNDARY_ID
NAME
FIRE_NUMBER
SHERIFF
TR_STATION
TR_ELEVATED_CROSSING
REF_ID
REF_NAME
ALIAS_NAME
LOCATION
STATION_ID
ADDRESS_ID
LATITUDE
LONGITUDE
NAME
STATION_TYPE
BOUNDARY_ID
NAME
SHERIFF_NUMBER
JURISDICTION
BOUNDARY_ID
NAME
JURIS_TYPE
TAZ
BOUNDARY_ID
NAME
TAZ_NUMBER
TR_TRAFFIC_SIGNAL
SIGNAL_ID
SIGNAL_NUM
SIGNAL_TYPE
PRIMARY_NAME
SECONDARY_NAME
CONTROLLED
TR_STREET_INTERSECTION
TR_WATER_BODY
INT_ID
WATER_ID
NAME
ALIAS_NAME
MIN_DEPTH
MIN_WIDTH
MAX_SPEED
RESTRICTIONS
WATER_TYPE
ACCESS_ID
CFCC
TR_TRANSIT_STOP
TR_SIGN
TBS_ID
STOP_ID
STOP_TIME
CURB_APPROACH
SHELTER
SHELTER_OWNER
TR_TOLL_PLAZA
TOLL_ID
GATE
TOTAL_NUM_LANE
Raster
Aerial Photos
TR_LAUNCH_POINT
TR_COMMONPLACE_NAME
Restrictions
TR_TURN
TURN_ID
TURN_TYPE
TURN_RESTRICT
TURN_DAY
TURN_START_TIME
TURN_END_TIME
TURN_ANGLE
TURN_PENALTY
DESCRIP
TURN_STATUS
PointRestriction1
TRANS_ID_FROM
TRANS_ID_TO
POINT_MEASURE
LATITUDE
LONGITUDE
TR_TRAFFIC_CALMING_DEVICE
DEVICE_ID
DEVICE_TYPE
DESCRIP
EST_SPEED_REDUCTION
PointRestriction2
TRANS_ID
POINT_MEASURE
LATITUDE
LONGITUDE
COMMON_ID
ADDRESS_ID
LATITUDE
LONGITUDE
NAME
ALIAS_NAME
JURISDICTION
STATE
DESCRIP
HAZMAT
CONTACT_ID
TR_CONTACT_ASSOC
ASSOC_ID
TRANS_ID
CONTACT_ID
LAUNCH_ID
ACCESS_ID
LAUNCH_NAME
ALIAS_NAME
LAUNCH_TYPE
OWNER_TYPE
SURF_TYPE
FEAT_WIDTH
FEAT_LENGTH
MAX_WEIGHT
MIN_DEPTH
USE_RESTRICTION
LIGHTING
PARKING_LOT_SIZE
LIFT_CAPABILITY
EMS_REMOVAL
APPROACH_INST
ADC_MAP_PAGE
CHART_PAGE
DATA_SOURCE
EFF_DATE
LAST_UPDATE
TR_MODE_BORDERLINE
Address
TransLineObject
TRANS_ID
TRANS_MODE
FROM_MEASURE
TO_MEASURE
TR_ADDRESS_RANGE
TRANS_SIDE_ID
RANGE_ID
FROM_ADD
TO_ADD
RANGE_TYPE
BOUNDARY_ID
SIDE
BORDERLINE_TYPE
BORDERLINE_VALUE
CONTACT_ID
NAME
PHONE
ALT_PHONE
FAX
EMAIL
ADDRESS
CONTACT_TYPE
TR_BRIDGE
TransLineObject2
TR_ROADWAY_NAME
TR_TRANS_SIDE
TRANS_SIDE_ID
RW_NAME_ID
SIDE
JURISDICTION
CATEGORY
Other Features
Street Information
TransPointObject
OWNERSHIP
MAINT_RES
DATA_SOURCE
EFF_DATE
LAST_UPDATE
BRIDGE_ID
BRIDGE_TYPE
STRUCTURE_ID
NAME
ALIAS_NAME
HEIGHT
LENGTH
WIDTH
MAX_WEIGHT
BRIDGE_SOURCE
BRIDGE_UPDATE
SURF_TYPE
VERT_UNDER_CLEARANCE
HOR_UNDER_CLERANCE
LATITUDE
LONGITUDE
StreetLineObject
INT_ID
Airport
Address Grid
Address Point
Building Footprint
Cell Tower
Facility Location
Hydrant
National Map Grid
Parcel
ROW
School Zone/Block
Tax Map Grid
Water Body
SEGID
FROM_MEASURE
TO_MEASURE
TR_CROSS_STREET
CROSS_ID
TRANS_SIDE_ID1
TRANS_SIDE_ID2
TR_STREET_LANE
LANE_ID
LANE_DESIGNATION
LANE_TYPE
LANE_CAPACITY
REVERSIBLE
DOUBLE_PARK
TR_MODE_INTERSECTION
ACCESS_ID
REF_ID
TRANS_ID1
TRANS_ID2
TR_PEDESTRIAN_SIGNAL
TR_CONTACT_NAME
RW_NAME_ID
FULLNAME
RW_PREFIX
RW_NAME
RW_TYPE
RW_TYPE_USPS
RW_SUFFIX
RW_SUFFIX_DIR
STATUS
LOT_ID
NAME
LOCATION
PARKING_LOT_CLASS
PARKING_LOT_USE
LIGHTING
PAVED
TR_LANDING_ZONE
SIGN_ID
NAME
SIGN_TYPE
DESCRIP
Tables
TR_PARKING_LOT
TR_LOW_WATER_CROSSING
DAM_ID
STRUCTURE_ID
NAME
ALIAS_NAME
DAM_TYPE
HAZARD_CLASSIFICATION
JURISDICTION
OWNERSHIP
MAINT_RES
DATA_SOURCE
EFF_DATE
LAST_UPDATE
SIGNAL_ID
PED_ID
SIGNAL_NUM
SIGNAL_TYPE
BUTTON_ACTIVATED
CROSSWALK
OWNERSHIP
MAINT_RES
DATA_SOURCE
EFF_DATE
LAST_UPDATE
TR_TRAFFIC_COUNT
SEGID
COUNT_ID
COUNT_TYPE
COUNT_NUM
COUNT_TIME
COUNT_SOURCE
COUNT_PERIOD
EFF_DATE
LAST_UPDATE
LaneMeasure
LANE_ID
Street Lane Information
TR_STREET_INVENTORY
SEGID
INVENTORY_ID
FEAT_LENGTH
MIN_WIDTH
FROM_MP
TO_MP
SURF_TYPE
MAX_INCLINATION
FREE_FLOW_SPEED
CAD_SPEED
LAW_SPEED
SPEED_LIMIT_CAR
SPEED_LIMIT_TRUCK
FT_SECONDS
TF_SECONDS
DIRECTION
DIVIDED
MAX_NUM_LANE
GATE
DATA_SOURCE
LaneObject
FROM_MEASURE
TO_MEASURE
TR_STREET_BARRIER
BARRIER_ID
BARRIER_TYPE
SIDE
BREAK
TR_STREET_SHOULDER
SHOULDER_ID
FEAT_WIDTH
SURF_TYPE
SIDE
TR_STREET_MEDIAN
TR_STREET_LANE_RESTRICTION
MEDIAN_ID
CROSSABLE
MEDIAN_TYPE
FEAT_LENGTH
FEAT_WIDTH
SIDE
RESTRICT_ID
RESTRICT_TYPE
RESTRICT_DIR
START_TIME
END_TIME
RESTRICT_DAY
ZIP
BOUNDARY_ID
NAME
ZIPCODE
Fairfax County Logical Model
Fairfax County Virginia
Logical - Relationships
03/05/07
CONNECTOR
RAILWAY
Table
TR_LAUNCH_POINT
Relationship class
TR_ACCESS_LAUNCH_REL
TypeSimple
CardinalityOne to many
NotificationNone
Relationship class
TR_REFERENCE_INT_REL
Forward label TO_LAUNCH
Backward label FROM_ACCESS
Origin feature class
Name
Primary key
Foreign key
TypeSimple
CardinalityOne to many
NotificationNone
Table
TR_LAUNCH_POINT
Relationship class
TR_ACCESS_LAUNCH_REL
TR_MODE_CONNECTOR
ACCESS_ID
ACCESS_ID
Name
Primary key
Foreign key
Forward label TO_INT
Backward label FROM_REF
Origin feature class
Name TR_LAUNCH_POINT
Name TR_ELEVATED_CROSSING
Primary key REF_ID
Foreign key REF_ID
Name
TypeSimple
CardinalityOne to many
NotificationNone
Destination table
TR_MODE_CONNECTOR
ACCESS_ID
ACCESS_ID
Destination table
No relationship rules defined.
Relationship class
TR_REFERENCE_INT_REL
Forward label TO_LAUNCH
Backward label FROM_ACCESS
Origin feature class
TypeSimple
CardinalityOne to many
NotificationNone
Destination table
Forward label TO_INT
Backward label FROM_REF
Origin feature class
Name TR_LAUNCH_POINT
Destination table
Name TR_ELEVATED_CROSSING
Primary key REF_ID
Foreign key REF_ID
No relationship rules defined.
TR_MODE_INTERSECTION
Name TR_MODE_INTERSECTION
No relationship rules defined.
Point feature class
TR_ELEVATED_CROSSING
No relationship rules defined.
Point feature class
TR_ELEVATED_CROSSING
Point feature class
TR_MODE_CONNECTOR
TypeSimple
CardinalityOne to many
NotificationNone
TypeSimple
CardinalityOne to many
NotificationNone
Destination table
TR_MODE_CONNECTOR
ACCESS_ID
ACCESS_ID
Name
Table
TR_MODE_INTERSECTION
Relationship class
TR_ACCESS_INT_REL
Forward label TO_INT
Backward label FROM_ACCESS
Origin feature class
Name
Primary key
Foreign key
Point feature class
TR_MODE_CONNECTOR
Table
TR_MODE_INTERSECTION
Relationship class
TR_ACCESS_INT_REL
Forward label TO_INT
Backward label FROM_ACCESS
Origin feature class
Destination table
TR_MODE_INTERSECTION
Name TR_MODE_CONNECTOR
Primary key ACCESS_ID
Foreign key ACCESS_ID
No relationship rules defined.
Name
TR_MODE_INTERSECTION
No relationship rules defined.
Relationship class
TR_CONNECTOR_ACCESS_REL1
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_ACCESS
Backward label FROM_CONNECTOR
Origin feature class
Name
Primary key
Foreign key
Relationship class
TR_RAILWAY_ACCESS_REL1
Destination table
TR_CONNECTOR
TRANS_ID
TRANS_ID1
TypeSimple
CardinalityOne to many
NotificationNone
Name TR_MODE_INTERSECTION
No relationship rules defined.
Forward label TO_ACCESS
Backward label FROM_RAILWAY
Origin feature class
Line feature class
TR_CONNECTOR
Destination table
Name TR_RAILWAY
Primary key TRANS_ID
Foreign key TRANS_ID1
Name TR_MODE_INTERSECTION
No relationship rules defined.
Relationship class
TR_CONNECTOR_ACCESS_REL2
TypeSimple
CardinalityOne to many
NotificationNone
Line feature class
TR_RAILWAY
Forward label TO_ACCESS
Backward label FROM_CONNECTOR
Origin feature class
Name
Primary key
Foreign key
Destination table
TR_CONNECTOR
TRANS_ID
TRANS_ID2
Name TR_MODE_INTERSECTION
Relationship class
TR_RAILWAY_ACCESS_REL2
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
Relationship class
TR_CONNECTOR_REF_REL1
Forward label TO_ACCESS
Backward label FROM_RAILWAY
Origin feature class
TypeSimple
CardinalityOne to many
NotificationNone
Origin feature class
Destination table
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID1
Destination table
Name TR_RAILWAY
Primary key TRANS_ID
Foreign key TRANS_ID2
Forward label TO_REF
Backward label FROM_CONNECTOR
Name TR_MODE_INTERSECTION
No relationship rules defined.
Name TR_MODE_INTERSECTION
No relationship rules defined.
Relationship class
TR_RAILWAY_REF_REL1
TypeSimple
CardinalityOne to many
NotificationNone
Relationship class
TR_CONNECTOR_REF_REL2
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_REF
Backward label FROM_CONNECTOR
Origin feature class
Destination table
Name TR_RAILWAY
Primary key TRANS_ID
Foreign key TRANS_ID1
Destination table
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID2
Forward label TO_REF
Backward label FROM_RAILWAY
Origin feature class
Name TR_MODE_INTERSECTION
Name TR_MODE_INTERSECTION
No relationship rules defined.
No relationship rules defined.
Relationship class
TR_RAILWAY_REF_REL2
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_BRIDGE
Backward label FROM_CONNECTOR
TypeSimple
CardinalityOne to many
NotificationNone
Table
TR_BRIDGE
TR_BRIDGE
Destination table
Name TR_RAILWAY
Primary key TRANS_ID
Foreign key TRANS_ID2
Destination table
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID
Destination table
Name
Forward label TO_REF
Backward label FROM_RAILWAY
Origin feature class
Forward label TO_BORDERLINE
Backward label FROM_CONNECTOR
Origin feature class
Origin feature class
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID
TypeSimple
CardinalityOne to many
NotificationNone
Table
TR_MODE_BORDERLINE
Relationship class
TR_CONNECTOR_BORDERLINE_REL
Relationship class
TR_CONNECTOR_BRIGE_REL
Name TR_MODE_BORDERLINE
Name TR_MODE_INTERSECTION
No relationship rules defined.
No relationship rules defined.
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_DAM
Backward label FROM_CONNECTOR
Origin feature class
Forward label TO_SIGN
Backward label FROM_CONNECTOR
Origin feature class
Destination feature class
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID
Destination feature class
Name
Point feature class
TR_SIGN
Relationship class
TR_CONNECTOR_SIGN_REL
Point feature class
TR_DAM
Relationship class
TR_CONNECTOR_DAM_REL
TypeSimple
CardinalityOne to many
NotificationNone
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID
TR_DAM
Name
TR_SIGN
No relationship rules defined.
Relationship class
TR_CONNECTOR_TRANSIT_STOP_REL
TypeSimple
CardinalityOne to many
NotificationNone
Table
TR_TRAFFIC_CALMING_DEVICE
Relationship class
TR_RAILWAY_BRIGE_REL
TypeSimple
CardinalityOne to many
NotificationNone
Destination feature class
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID
Destination table
Point feature class
TR_TRANSIT_STOP
Forward label TO_TRANSIT_STOP
Backward label FROM_CONNECTOR
Origin feature class
Forward label TO_DEVICE
Backward label FROM_CONNECTOR
Origin feature class
Name TR_TRANSIT_STOP
Name
Relationship class
TR_CONTACT_ASSOC_REL
TR_CONTACT_ASSOC
TypeSimple
CardinalityOne to many
NotificationNone
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_ASSOC
Backward label FROM_CONTACT
Origin table
Destination table
Name TR_CONTACT_NAME
Primary key CONTACT_ID
Foreign key CONTACT_ID
Table
TR_TURN
Point feature class
TR_DAM
Relationship class
TR_RAILWAY_DAM_REL
Destination table
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID
TR_TURN
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_CONTACT
Backward label FROM_CONNECTOR
Origin feature class
Destination table
Name
No relationship rules defined.
Name
Point feature class
TR_SIGN
Forward label TO_SIGN
Backward label FROM_RAILWAY
Origin feature class
Destination feature class
Name TR_RAILWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Forward label TO_DAM
Backward label FROM_RAILWAY
Name TR_SIGN
No relationship rules defined.
Origin feature class
TR_CONTACT_ASSOC
Destination feature class
Name TR_RAILWAY
Primary key TRANS_ID
Foreign key TRANS_ID
No relationship rules defined.
Relationship class
TR_CONNECTOR_TTURN_REL
TypeSimple
CardinalityOne to many
NotificationNone
Destination table
Name TR_MODE_BORDERLINE
No relationship rules defined.
Relationship class
TR_RAILWAY_SIGN_REL
Table
TR_CONTACT_ASSOC
Relationship class
TR_CONNECTOR_CONTACT_REL
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_TURN
Backward label FROM_CONNECTOR
Origin feature class
Forward label TO_BORDERLINE
Backward label FROM_RAILWAY
Origin feature class
Name TR_RAILWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Destination table
Name TR_BRIDGE
No relationship rules defined.
Relationship class
TR_CONNECTOR_FTURN_REL
TypeSimple
CardinalityOne to many
NotificationNone
TypeSimple
CardinalityOne to many
NotificationNone
Table
TR_BRIDGE
Forward label TO_BRIDGE
Backward label FROM_RAILWAY
Origin feature class
Name TR_RAILWAY
Primary key TRANS_ID
Foreign key TRANS_ID
No relationship rules defined.
Name TR_TRAFFIC_CALMING_DEVICE
No relationship rules defined.
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID_FROM
Table
TR_MODE_BORDERLINE
Relationship class
TR_RAILWAY_BORDERLINE_REL
No relationship rules defined.
Relationship class
TR_CONNECTOR_DEVICE_REL
TypeSimple
CardinalityOne to many
NotificationNone
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID
Name TR_DAM
No relationship rules defined.
Forward label TO_TURN
Backward label FROM_CONNECTOR
Origin feature class
Name
TR_TURN
Relationship class
TR_CONNECTOR_PARATRANSIT_STOP_REL
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
Point feature class
TR_LANDING_ZONE
Relationship class
TR_CONNECTOR_LZ_REL
TypeSimple
CardinalityOne to many
NotificationNone
TypeSimple
CardinalityOne to many
NotificationNone
Destination feature class
Name
TR_PARATRANSIT_STOP
TypeSimple
CardinalityOne to many
NotificationNone
Table
TR_CONTACT_ASSOC
Forward label TO_CONTACT
Backward label FROM_RAILWAY
Origin feature class
Relationship class
TR_CONTACT_ASSOC_REL
Destination table
Name TR_RAILWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Forward label TO_DEVICE
Backward label FROM_RAILWAY
Origin feature class
Name TR_CONTACT_ASSOC
TypeSimple
CardinalityOne to many
NotificationNone
No relationship rules defined.
Destination table
Name TR_RAILWAY
Primary key TRANS_ID
Foreign key TRANS_ID
No relationship rules defined.
Destination feature class
Table
TR_TRAFFIC_CALMING_DEVICE
Relationship class
TR_RAILWAY_DEVICE_REL
Point feature class
TR_PARATRANSIT_STOP
Forward label TO_PARATRANSIT_STOP
Backward label FROM_CONNECTOR
Origin feature class
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID
Forward label TO_LZ
Backward label FROM_CONNECTOR
Origin feature class
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID
Relationship class
TR_RAILWAY_CONTACT_REL
Table
TR_CONTACT_NAME
Destination table
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID_TO
Forward label TO_ASSOC
Backward label FROM_CONTACT
Origin table
Destination table
Name TR_CONTACT_NAME
Primary key CONTACT_ID
Foreign key CONTACT_ID
Name TR_TRAFFIC_CALMING_DEVICE
Name
TR_CONTACT_ASSOC
Name TR_LANDING_ZONE
No relationship rules defined.
No relationship rules defined.
No relationship rules defined.
Relationship class
TR_CONNECTOR_SCHOOL_STOP_REL
TypeSimple
CardinalityOne to many
NotificationNone
Point feature class
TR_MILE_MARKER
Relationship class
TR_CONNECTOR_MP_REL
TypeSimple
CardinalityOne to many
NotificationNone
Origin feature class
Forward label TO_SCHOOL_STOP
Backward label FROM_CONNECTOR
Origin feature class
Forward label TO_MP
Backward label FROM_CONNECTOR
Point feature class
TR_SCHOOL_STOP
Destination feature class
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID
Relationship class
TR_CONTACT_COMMONPLACE_REL
Destination feature class
Name TR_CONNECTOR
Primary key TRANS_ID
Foreign key TRANS_ID
No relationship rules defined.
NameTR_MILE_MARKER
TypeSimple
CardinalityOne to many
NotificationNone
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_COMMONPLACE
Backward label FROM_CONTACT
Forward label TO_MP
Backward label FROM_RAILWAY
Origin feature class
Origin table
Destination table
Name TR_CONTACT_NAME
Primary key CONTACT_ID
Foreign key CONTACT_ID
Table
TR_COMMONPLACE_NAME
Destination feature class
Name TR_RAILWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Name TR_COMMONPLACE_NAME
Table
TR_CONTACT_NAME
Point feature class
TR_MILE_MARKER
Relationship class
TR_RAILWAY_MP_REL
Name TR_SCHOOL_STOP
NameTR_MILE_MARKER
Relationship class
TR_CONTACT_COMMONPLACE_REL
No relationship rules defined.
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_COMMONPLACE
Backward label FROM_CONTACT
Origin table
Destination table
Name TR_CONTACT_NAME
Primary key CONTACT_ID
Foreign key CONTACT_ID
Table
TR_COMMONPLACE_NAME
Name TR_COMMONPLACE_NAME
No relationship rules defined.
NETWORK
ROADWAY
CONNECTOR
Table
TR_ROADWAY_NAME
Table
TR_LAUNCH_POINT
Relationship class
TR_ACCESS_LAUNCH_REL
Table
TR_LAUNCH_POINT
Relationship class
TR_ACCESS_LAUNCH_REL
TypeSimple
CardinalityOne to many
NotificationNone
Name
Primary key
Foreign key
Forward label TO_INT
Backward label FROM_REF
Relationship class
TR_REFERENCE_INT_REL
TypeSimple
CardinalityOne to many
NotificationNone
Destination table
TR_MODE_CONNECTOR
ACCESS_ID
ACCESS_ID
No relationship rules defined.
Name
TypeSimple
CardinalityOne to many
NotificationNone
Destination table
Name TR_ELEVATED_CROSSING
Primary key REF_ID
Foreign key REF_ID
Name
TR_MODE_INTERSECTION
Table
TR_ADDRESS_RANGE
Destination table
Name TR_TRANS_SIDE
Relationship class
TR_TRANS_RANGE_REL
No relationship rules defined.
Point feature class
TR_ELEVATED_CROSSING
TR_MODE_INTERSECTION
Forward label TO_SIDE
Backward label FROM_NAME
Origin table
Name TR_ROADWAY_NAME
Primary key NAME_ID
Foreign key NAME_ID
No relationship rules defined.
Destination table
Name TR_ELEVATED_CROSSING
Primary key REF_ID
Foreign key REF_ID
Relationship class
TR_TRANS_SIDE_REL
Forward label TO_INT
Backward label FROM_REF
Origin feature class
Name TR_LAUNCH_POINT
No relationship rules defined.
Origin feature class
Name TR_LAUNCH_POINT
Forward label TO_LAUNCH
Backward label FROM_ACCESS
Origin feature class
TypeSimple
CardinalityOne to many
NotificationNone
Destination table
TR_MODE_CONNECTOR
ACCESS_ID
ACCESS_ID
TypeSimple
CardinalityOne to many
NotificationNone
Relationship class
TR_REFERENCE_INT_REL
Forward label TO_LAUNCH
Backward label FROM_ACCESS
Origin feature class
Name
Primary key
Foreign key
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_RANGE
Backward label FROM_SIDE
Origin table
No relationship rules defined.
Point feature class
TR_MODE_CONNECTOR
Point feature class
TR_ELEVATED_CROSSING
TypeSimple
CardinalityOne to many
NotificationNone
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_INT
Backward label FROM_ACCESS
Name
Primary key
Foreign key
Destination table
TR_MODE_CONNECTOR
ACCESS_ID
ACCESS_ID
Name
Name
Primary key
Foreign key
TR_MODE_INTERSECTION
Destination table
TR_TRANS_SIDE
TRANS_SIDE_ID
TRANS_SIDE_ID
Name
No relationship rules defined.
Forward label TO_SIDE
Backward label FROM_CROSS
Origin table
Origin feature class
Name
Primary key
Foreign key
Relationship class
TR_CROSS_SIDE_REL1
Table
TR_MODE_INTERSECTION
Relationship class
TR_ACCESS_INT_REL
Destination table
TR_CROSS_STREET
TRANS_SIDE_ID1
TRANS_SIDE_ID
Name TR_TRANS_SIDE
No relationship rules defined.
No relationship rules defined.
Point feature class
TR_MODE_CONNECTOR
Table
TR_MODE_INTERSECTION
Relationship class
TR_ACCESS_INT_REL
Relationship class
TR_ROADWAY_ACCESS_REL1
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_INT
Backward label FROM_ACCESS
TypeSimple
CardinalityOne to many
NotificationNone
Name
Primary key
Foreign key
Destination table
TR_MODE_CONNECTOR
ACCESS_ID
ACCESS_ID
Name
TR_MODE_INTERSECTION
TypeSimple
CardinalityOne to many
NotificationNone
Destination table
TR_ROADWAY
TRANS_ID
TRANS_ID1
Table
TR_TRANS_SIDE
Table
TR_CROSS_STREET
Relationship class
TR_INT_CROSS_REL
Forward label TO_ACCESS
Backward label FROM_ROADWAY
Origin feature class
Origin feature class
Name
Primary key
Foreign key
Name TR_MODE_INTERSECTION
Forward label TO_CROSS
Backward label FROM_INT
Origin feature class
Name
Primary key
Foreign key
No relationship rules defined.
Line feature class
TR_ROADWAY
Relationship class
TR_CROSS_SIDE_REL2
Destination table
TR_STREET_INTERSECTION
INT_ID
INT_ID
Name
TypeSimple
CardinalityOne to many
NotificationNone
TR_CROSS_STREET
Name
Primary key
Foreign key
TypeSimple
CardinalityOne to many
NotificationNone
Destination table
TR_ROADWAY
TRANS_ID
TRANS_ID2
Name TR_MODE_INTERSECTION
Table
TR_STREET_BARRIER
No relationship rules defined.
Relationship class
TR_LANE_BARRIER_REL
Forward label TO_ACCESS
Backward label FROM_PATHWAY
Origin feature class
TypeSimple
CardinalityOne to many
NotificationNone
Relationship class
TR_ROADWAY_REF_REL1
Destination table
TR_PATHWAY
TRANS_ID
TRANS_ID1
TypeSimple
CardinalityOne to many
NotificationNone
Name TR_MODE_INTERSECTION
Forward label TO_BARRIER
Backward label FROM_LANE
Origin table
Forward label TO_REF
Backward label FROM_ROADWAY
Origin feature class
Name
Primary key
Foreign key
Destination table
TR_STREET_LANE
LANE_ID
LANE_ID
Destination table
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID1
No relationship rules defined.
Name TR_STREET_BARRIER
No relationship rules defined.
Name TR_MODE_INTERSECTION
Table
TR_STREET_MEDIAN
No relationship rules defined.
Line feature class
TR_PATHWAY
Relationship class
TR_LANE_MEDIAN_REL
Relationship class
TR_ROADWAY_REF_REL2
TypeSimple
CardinalityOne to many
NotificationNone
Relationship class
TR_PATHWAY_ACCESS_REL2
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_MEDIAN
Backward label FROM_LANE
Origin table
Name
Primary key
Foreign key
Destination table
Name TR_MODE_INTERSECTION
Destination table
TR_STREET_LANE
LANE_ID
LANE_ID
Name
TR_STREET_MEDIAN
No relationship rules defined.
No relationship rules defined.
Origin feature class
Name
Primary key
Foreign key
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_REF
Backward label FROM_ROADWAY
Origin feature class
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID2
Forward label TO_ACCESS
Backward label FROM_PATHWAY
Name TR_TRANS_SIDE
No relationship rules defined.
Forward label TO_ACCESS
Backward label FROM_ROADWAY
Origin feature class
Name
Primary key
Foreign key
Destination table
TR_CROSS_STREET
TRANS_SIDE_ID2
TRANS_SIDE_ID
Relationship class
TR_ROADWAY_ACCESS_REL2
TypeSimple
CardinalityOne to many
NotificationNone
Name
Primary key
Foreign key
Forward label TO_SIDE
Backward label FROM_CROSS
Origin table
No relationship rules defined.
No relationship rules defined.
Relationship class
TR_PATHWAY_ACCESS_REL1
Table
TR_STREET_LANE_RESTRICTION
Destination table
TR_PATHWAY
TRANS_ID
TRANS_ID2
Relationship class
TR_LANE_RESTRICT_REL
Name TR_MODE_INTERSECTION
Relationship class
TR_ROADWAY_BORDER_REL
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
Origin feature class
Name
Primary key
Foreign key
Relationship class
TR_PATHWAY_REF_REL1
TypeSimple
CardinalityOne to many
NotificationNone
Table
TR_MODE_BORDERLINE
Forward label TO_BORDERLINE
Backward label FROM_ROADWAY
Forward label TO_RESTRICT
Backward label FROM_LANE
Origin table
Destination table
NameTR_STREET_LANE
Primary keyLANE_ID
Foreign keyLANE_ID
Destination table
TR_ROADWAY
SEGID
SEGID
TypeSimple
CardinalityOne to many
NotificationNone
Name TR_STREET_LANE_RESTRICTION
No relationship rules defined.
Name TR_MODE_BORDERLINE
No relationship rules defined.
Forward label TO_REF
Backward label FROM_PATHWAY
Origin feature class
Name TR_PATHWAY
Primary key TRANS_ID
Foreign key TRANS_ID1
Table
TR_STREET_SHOULDER
Relationship class
TR_LANE_SHOULDER_REL
TypeSimple
CardinalityOne to many
NotificationNone
Relationship class
TR_ROADWAY_BRIGE_REL
Destination table
TypeSimple
CardinalityOne to many
NotificationNone
Name TR_MODE_INTERSECTION
Forward label TO_BRIDGE
Backward label FROM_ROADWAY
Origin feature class
Table
TR_BRIDGE
Name
Primary key
Foreign key
Destination table
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID
No relationship rules defined.
Forward label TO_SHOULDER
Backward label FROM_LANE
Origin table
Name TR_BRIDGE
Destination table
TR_STREET_LANE
LANE_ID
LANE_ID
Name
TR_STREET_SHOULDER
No relationship rules defined.
No relationship rules defined.
Table
TR_TRAFFIC_COUNT
Relationship class
TR_ROADWAY_COUNT_REL
Relationship class
TR_PATHWAY_REF_REL2
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_COUNT
Backward label FROM_ROADWAY
Origin feature class
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_REF
Backward label FROM_PATHWAY
Destination table
Name TR_ROADWAY
Primary key SEGID
Foreign key SEGID
NameTR_TRAFFIC_COUNT
Destination table
Name TR_PATHWAY
Primary key TRANS_ID
Foreign key TRANS_ID2
Point feature class
TR_LANDING_ZONE
Relationship class
TR_ROADWAY_LZ_REL
No relationship rules defined.
Origin feature class
TypeSimple
CardinalityOne to many
NotificationNone
Name TR_MODE_INTERSECTION
Forward label TO_LZ
Backward label FROM_ROADWAY
Origin feature class
Destination feature class
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID
No relationship rules defined.
Name TR_LANDING_ZONE
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
Table
TR_BRIDGE
Forward label TO_BRIDGE
Backward label FROM_PATHWAY
Origin feature class
TR_BRIDGE
Name
Destination feature class
TR_DAM
NameTR_MILE_MARKER
No relationship rules defined.
No relationship rules defined.
Forward label TO_MP
Backward label FROM_PATHWAY
Origin feature class
Table
TR_TRAFFIC_CALMING_DEVICE
Relationship class
TR_ROADWAY_DEVICE_REL
Destination feature class
Name TR_PATHWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Destination table
Name
Forward label TO_MP
Backward label FROM_ROADWAY
Origin feature class
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Destination feature class
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Point feature class
TR_MILE_MARKER
Relationship class
TR_PATHWAY_MP_REL
Relationship class
TR_PATHWAY_BRIGE_REL
TypeSimple
CardinalityOne to many
NotificationNone
Name TR_PATHWAY
Primary key TRANS_ID
Foreign key TRANS_ID
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_DAM
Backward label FROM_ROADWAY
Origin feature class
Point feature class
TR_MILE_MARKER
Relationship class
TR_ROADWAY_MP_REL
Point feature class
TR_DAM
Relationship class
TR_ROADWAY_DAM_REL
TypeSimple
CardinalityOne to many
NotificationNone
TypeSimple
CardinalityOne to many
NotificationNone
Name TR_MILE_MARKER
Forward label TO_DEVICE
Backward label FROM_ROADWAY
Origin feature class
Point feature class
TR_STREET_SENSOR
Relationship class
TR_ROADWAY_SENSOR_REL
TypeSimple
CardinalityOne to many
NotificationNone
Destination table
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID
No relationship rules defined.
Forward label TO_SENSOR
Backward label FROM_ROADWAY
Origin feature class
Name TR_TRAFFIC_CALMING_DEVICE
Destination feature class
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID
No relationship rules defined.
NameTR_STREET_SENSOR
No relationship rules defined.
No relationship rules defined.
Relationship class
TR_ROADWAY_FTURN_REL
TypeSimple
CardinalityOne to many
NotificationNone
Table
TR_MODE_BORDERLINE
Relationship class
TR_PATHWAY_BORDERLINE_REL
Relationship class
TR_PATHWAY_DAM_REL
TypeSimple
CardinalityOne to many
NotificationNone
TypeSimple
CardinalityOne to many
NotificationNone
Point feature class
TR_DAM
Origin feature class
Table
TR_TRANS_SIDE
Destination table
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Name TR_TRANS_SIDE
No relationship rules defined.
Table
TR_TURN
Name TR_MODE_BORDERLINE
Relationship class
TR_ROADWAY_TTURN_REL
TypeSimple
CardinalityOne to many
NotificationNone
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
Destination table
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID_TO
TR_DAM
Point feature class
TR_SIGN
Relationship class
TR_ROADWAY_SIGN_REL
Forward label TO_TURN
Backward label FROM_ROADWAY
Origin feature class
Destination feature class
Name
Forward label TO_SIDE
Backward label FROM_ROADWAY
Origin feature class
Name TR_TURN
No relationship rules defined.
Destination table
Name TR_PATHWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Forward label TO_DAM
Backward label FROM_PATHWAY
Origin feature class
Name TR_PATHWAY
Primary key TRANS_ID
Foreign key TRANS_ID
TypeSimple
CardinalityOne to many
NotificationNone
Destination table
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID_FROM
Forward label TO_BORDERLINE
Backward label FROM_PATHWAY
Relationship class
TR_ROADWAY_SIDE_REL
Forward label TO_TURN
Backward label FROM_ROADWAY
Origin feature class
Name TR_TURN
Table
TR_PEDESTRIAN_SIGNAL
Forward label TO_SIGN
Backward label FROM_ROADWAY
Origin feature class
Relationship class
TR_SIGNAL_PED_REL
Destination feature class
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID
No relationship rules defined.
Name TR_SIGN
TypeSimple
CardinalityOne to many
NotificationNone
No relationship rules defined.
No relationship rules defined.
Point feature class
TR_SIGN
Relationship class
TR_PATHWAY_SIGN_REL
TypeSimple
CardinalityOne to many
NotificationNone
Table
TR_TRAFFIC_CALMING_DEVICE
Relationship class
TR_PATHWAY_DEVICE_REL
TypeSimple
CardinalityOne to many
NotificationNone
Origin feature class
TypeSimple
CardinalityOne to many
NotificationNone
Name
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_INVENTORY
Backward label FROM_ROADWAY
Name
TR_STREET_INVENTORY
Forward label TO_COMMONPLACE
Backward label FROM_CONTACT
TypeSimple
CardinalityOne to many
NotificationNone
Name TR_TRANSIT_STOP
No relationship rules defined.
Destination table
Name TR_CONTACT_NAME
Primary key CONTACT_ID
Foreign key CONTACT_ID
Name
TR_CONTACT_ASSOC
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
TR_TURN
Forward label TO_ASSOC
Backward label FROM_CONTACT
Origin table
TypeSimple
CardinalityOne to many
NotificationNone
Origin feature class
Forward label TO_ASSOC
Backward label FROM_CONTACT
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_LANE
Backward label FROM_ROADWAY
Name
Forward label TO_CONTACT
Backward label FROM_ROADWAY
Origin feature class
Destination table
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Destination table
Name TR_ROADWAY
Primary key SEGID
Foreign key SEGID
TR_STREET_LANE
Table
TR_COMMONPLACE_NAME
Table
TR_CONTACT_ASSOC
Relationship class
TR_ROADWAY_CONTACT_REL
Table
TR_STREET_LANE
Relationship class
TR_ROADWAY_LANE_REL
Relationship class
TR_CONTACT_ASSOC_REL
Name TR_COMMONPLACE_NAME
No relationship rules defined.
Relationship class
TR_CONTACT_ASSOC_REL
Destination feature class
No relationship rules defined.
No relationship rules defined.
TR_CONTACT_ASSOC
Destination table
Name TR_CONTACT_NAME
Primary key CONTACT_ID
Foreign key CONTACT_ID
Point feature class
TR_TRANSIT_STOP
Forward label TO_TRANSIT_STOP
Backward label FROM_ROADWAY
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Destination table
Name TR_ROADWAY
Primary key SEGID
Foreign key SEGID
Destination table
Name
Destination table
Name
Relationship class
TR_CONTACT_COMMONPLACE_REL
TypeSimple
CardinalityOne to many
NotificationNone
Table
TR_CONTACT_NAME
Relationship class
TR_ROADWAY_TRANSIT_STOP_REL
TypeSimple
CardinalityOne to many
NotificationNone
Origin feature class
Origin feature class
Origin feature class
Name TR_PEDESTRIAN_SIGNAL
No relationship rules defined.
Name TR_TRAFFIC_SIGNAL
Forward label TO_CONTACT
Backward label FROM_PATHWAY
Origin feature class
Name TR_CONTACT_ASSOC
No relationship rules defined.
No relationship rules defined.
Origin table
Destination table
Name TR_CONTACT_NAME
Primary key CONTACT_ID
Foreign key CONTACT_ID
No relationship rules defined.
Name
TR_CONTACT_ASSOC
Point feature class
TR_LOW_WATER_CROSSING
Relationship class
TR_ROADWAY_LWC_REL
No relationship rules defined.
Table
TR_TURN
TypeSimple
CardinalityOne to many
NotificationNone
Relationship class
TR_PATHWAY_TTURN_REL
Origin feature class
Table
TR_STREET_INVENTORY
Relationship class
TR_ROADWAY_INVENTORY_REL
Table
TR_CONTACT_ASSOC
Relationship class
TR_PATHWAY_CONTACT_REL
TypeSimple
CardinalityOne to many
NotificationNone
Name TR_PATHWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Forward label TO_TURN
Backward label FROM_PATHWAY
Name TR_PATHWAY
Primary key TRANS_ID
Foreign key TRANS_ID_FROM
Destination table
TR_TRAFFIC_SIGNAL
SIGNAL_ID
SIGNAL_ID
Destination feature class
TR_ROADWAY
TRANS_ID
TRANS_ID
No relationship rules defined.
Name TR_TRAFFIC_CALMING_DEVICE
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
TypeSimple
CardinalityOne to many
NotificationNone
Name
Primary key
Foreign key
Forward label TO_PED
Backward label FROM_SIGNAL
Origin feature class
Forward label TO_SIGNAL
Backward label FROM_ROADWAY
Origin feature class
TR_STREET_INTERSECTION
Origin table
Relationship class
TR_PATHWAY_FTURN_REL
Name TR_PATHWAY
Primary key TRANS_ID
Foreign key TRANS_ID_TO
Name
No relationship rules defined.
Destination table
Name TR_PATHWAY
Primary key TRANS_ID
Foreign key TRANS_ID
TypeSimple
CardinalityOne to many
NotificationNone
Destination feature class
TR_ROADWAY
TRANS_ID
TRANS_ID
TR_SIGN
Point feature class
TR_TRAFFIC_SIGNAL
Relationship class
TR_ROADWAY_SIGNAL_REL
Forward label TO_INT
Backward label FROM_ROADWAY
Origin feature class
Name
Primary key
Foreign key
Destination feature class
Name
Primary key
Foreign key
Point feature class
TR_STREET_INTERSECTION
Relationship class
TR_ROADWAY_INT_REL
Forward label TO_SIGN
Backward label FROM_PATHWAY
Origin feature class
Name TR_PATHWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Forward label TO_DEVICE
Backward label FROM_PATHWAY
Relationship class
TR_ROADWAY_TOLL_REL
Type Simple
Cardinality One to many
Notification None
Forward label TO_LWC
Backward label FROM_ROADWAY
Origin feature class
Origin feature class
Table
TR_CONTACT_NAME
Destination feature class
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Forward label TO_TURN
Backward label FROM_PATHWAY
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Name TR_LOW_WATER_CROSSING
Point feature class
TR_TOLL_PLAZA
Forward label TO_TOLL
Backward label FROM_ROADWAY
Destination feature class
NameTR_TOLL_PLAZA
No relationship rules defined.
No relationship rules defined.
Destination table
Name
Relationship class
TR_ROADWAY_PARATRANSIT_STOP_REL
TR_TURN
TypeSimple
CardinalityOne to many
NotificationNone
Relationship class
TR_CONTACT_COMMONPLACE_REL
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
Origin feature class
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Forward label TO_COMMONPLACE
Backward label FROM_CONTACT
Origin table
Point feature class
TR_PARATRANSIT_STOP
Forward label TO_PARATRANSIT_STOP
Backward label FROM_ROADWAY
Destination feature class
Name
TR_PARATRANSIT_STOP
No relationship rules defined.
Destination table
Name TR_CONTACT_NAME
Primary key CONTACT_ID
Foreign key CONTACT_ID
Name TR_COMMONPLACE_NAME
Relationship class
TR_ROADWAY_SCHOOL_STOP_REL
TypeSimple
CardinalityOne to many
NotificationNone
No relationship rules defined.
Origin feature class
Name TR_ROADWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Point feature class
TR_SCHOOL_STOP
Forward label TO_SCHOOL_STOP
Backward label FROM_ROADWAY
Destination feature class
Name TR_SCHOOL_STOP
No relationship rules defined.
Table
TR_COMMONPLACE_NAME
WATERWAY
Polygon feature class
TR_WATER_BODY
TypeSimple
CardinalityOne to many
NotificationNone
Table
TR_LAUNCH_POINT
Relationship class
TR_ACCESS_LAUNCH_REL
Relationship class
TR_WATERBODY_ACCESS_REL
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_ACCESS
Backward label FROM_WATERBODY
Name
Primary key
Foreign key
Destination feature class
TR_WATER_BODY
WATER_ID
ACCESS_ID
Name TR_MODE_CONNECTOR
Relationship class
TR_REFERENCE_INT_REL
Forward label TO_LAUNCH
Backward label FROM_ACCESS
Origin feature class
Origin feature class
Name
Primary key
Foreign key
TypeSimple
CardinalityOne to many
NotificationNone
Destination table
TR_MODE_CONNECTOR
ACCESS_ID
ACCESS_ID
Name
Forward label TO_INT
Backward label FROM_REF
Origin feature class
TR_LAUNCH_POINT
Name
Primary key
Foreign key
Destination table
TR_ELEVATED_CROSSING
REF_ID
REF_ID
No relationship rules defined.
Name
TR_MODE_INTERSECTION
No relationship rules defined.
No relationship rules defined.
Point feature class
TR_ELEVATED_CROSSING
Point feature class
TR_MODE_CONNECTOR
Table
TR_MODE_INTERSECTION
Relationship class
TR_ACCESS_INT_REL
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_INT
Backward label FROM_ACCESS
Origin feature class
Name
Primary key
Foreign key
Destination table
TR_MODE_CONNECTOR
ACCESS_ID
ACCESS_ID
Name
TR_MODE_INTERSECTION
No relationship rules defined.
Table
TR_MODE_BORDERLINE
Relationship class
TR_WATERWAY_SIDE_REL
Relationship class
TR_WATERWAY_DAM_REL
Relationship class
TR_WATERWAY_ACCESS_REL1
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_ACCESS
Backward label FROM_WATERWAY
Origin feature class
Name
Primary key
Foreign key
Destination table
TR_WATERWAY
TRANS_ID
TRANS_ID1
Name
TR_MODE_INTERSECTION
TypeSimple
CardinalityOne to many
NotificationNone
Point feature class
TR_DAM
Forward label TO_BORDERLINE
Backward label FROM_WATERWAY
Destination table
Name TR_WATERWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Destination feature class
Name
TypeSimple
CardinalityOne to many
NotificationNone
Origin feature class
Forward label TO_DAM
Backward label FROM_WATERWAY
Origin feature class
Name TR_WATERWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Name TR_MODE_BORDERLINE
No relationship rules defined.
TR_DAM
No relationship rules defined.
No relationship rules defined.
Line feature class
TR_WATERWAY
Point feature class
TR_SIGN
Relationship class
TR_WATERWAY_SIGN_REL
Relationship class
TR_WATERWAY_ACCESS_REL2
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_ACCESS
Backward label FROM_WATERWAY
Origin feature class
Name
Primary key
Foreign key
Destination table
TR_WATERWAY
TRANS_ID
TRANS_ID2
Name
TR_MODE_INTERSECTION
Table
TR_TRAFFIC_CALMING_DEVICE
Relationship class
TR_WATERWAY_DEVICE_REL
TypeSimple
CardinalityOne to many
NotificationNone
Origin feature class
Forward label TO_SIGN
Backward label FROM_WATERWAY
Destination feature class
Name TR_WATERWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Destination table
Name TR_WATERWAY
Primary key TRANS_ID
Foreign key TRANS_ID
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
Origin feature class
Forward label TO_DEVICE
Backward label FROM_WATERWAY
Name
TR_SIGN
No relationship rules defined.
Name TR_TRAFFIC_CALMING_DEVICE
No relationship rules defined.
Table
TR_CONTACT_ASSOC
Relationship class
TR_WATERWAY_CONTACT_REL
Relationship class
TR_WATERWAY_REF_REL1
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_REF
Backward label FROM_WATERWAY
Origin feature class
Destination table
Name TR_WATERWAY
Primary key TRANS_ID
Foreign key TRANS_ID1
Name TR_MODE_INTERSECTION
TypeSimple
CardinalityOne to many
NotificationNone
Origin feature class
Name TR_WATERWAY
Primary key TRANS_ID
Foreign key TRANS_ID
No relationship rules defined.
Point feature class
TR_MILE_MARKER
Relationship class
TR_WATERWAY_MP_REL
Forward label TO_MP
Backward label FROM_WATERWAY
Destination feature class
NameTR_MILE_MARKER
No relationship rules defined.
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_CONTACT
Backward label FROM_WATERWAY
Origin feature class
Name TR_WATERWAY
Primary key TRANS_ID
Foreign key TRANS_ID
Destination table
Name
No relationship rules defined.
TR_CONTACT_ASSOC
Relationship class
TR_CONTACT_ASSOC_REL
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_ASSOC
Backward label FROM_CONTACT
Origin table
Destination table
Name TR_CONTACT_NAME
Primary key CONTACT_ID
Foreign key CONTACT_ID
Name
TR_CONTACT_ASSOC
No relationship rules defined.
Relationship class
TR_WATERWAY_REF_REL2
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_REF
Backward label FROM_WATERWAY
Origin feature class
Destination table
Name TR_WATERWAY
Primary key TRANS_ID
Foreign key TRANS_ID2
Name TR_MODE_INTERSECTION
No relationship rules defined.
Table
TR_CONTACT_NAME
Relationship class
TR_CONTACT_COMMONPLACE_REL
TypeSimple
CardinalityOne to many
NotificationNone
Forward label TO_COMMONPLACE
Backward label FROM_CONTACT
Origin table
Destination table
Name TR_CONTACT_NAME
Primary key CONTACT_ID
Foreign key CONTACT_ID
Name TR_COMMONPLACE_NAME
No relationship rules defined.
Table
TR_COMMONPLACE_NAME
TR_ADDRESS_RANGE
Fairfax County Logical Model
Fairfax County Virginia
Logical Domains
03/02/07
Coded value domain
Coded value domain
Coded value domain
Coded value domain
GIS_TR_EMER_USE
GIS_TR_ACCESS_TYPE
GIS_TR_PARKING_LOT_CLASS
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Description
Description
Field type String
Split policy Default value
Merge policy Default value
Description
LAUNCH POINT
0
NONE
0
PUBLIC
STATION
1
SNOW
1
PRIVATE
2
GATE
2
EVACUATION
9
OTHER
GIS_TR_WATER_TYPE
Description
Field type String
Split policy Default value
Merge policy Default value
GIS_TR_STATE
Code
Description
0
1
Coded value domain
GIS_TR_STREET_TYPE
Coded value domain
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Code
Code
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Code
Description
AL
Code
Description
DC
DC
MD
MD
VA
VA
ALLEY
AV
AVENUE
BV
BOULEVARD
BW
BELTWAY
CE
CENTER
CI
Coded value domain
GIS_TR_PARKING_LOT_USE
Coded value domain
Coded value domain
GIS_TR_FIPS
GIS_TR_BARRIER_TYPE
Description
Field type Long integer
Split policy Default value
Merge policy Default value
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Description
Field type Short integer
Split policy Default value
Merge policy Default value
0
Description
1000
GUARDRAIL
51013
GIS_TR_STATION_TYPE
Code
Code
Code
Coded value domain
1
2
DISTRICT OF COLUMBIA
SCHOOL
RETAIL
PARKING GARAGE OR STRUCTURE
5
RECREATION
CITY OF FALLS CHURCH
6
REST STOP
FORT BELVOIR
6
VEGETATION
51107
LOUDOUN COUNTY
7
CURB
51153
PRINCE WILLIAM COUNTY
8
BOLLARD
51179
STAFFORD COUNTY
9
DRIVABLE CURB
24000
10
OTHER
51000
STATE OF VIRGINIA
TOWN OF CLIFTON
36648
TOWN OF HERNDON
58696
TOWN OF OCCOQUAN
81072
TOWN OF VIENNA
0
UNKNOWN
Code
Description
0
UNKNOWN
1
FIPS
JURISDICTION
3
JURISDICTION TYPE
4
5
Coded value domain
SOME
NONE
Description
OTHER
POLICE
SHERIFF
Code
Description
SCHOOL
0
MULTIPLE USE
11
TAZ
12
VDOT
VSP
1
PLACE
Description
Field type Short integer
Split policy Default value
Merge policy Default value
GIS_TR_JURIS_TYPE
A
ACTIVE
INACTIVE
PROPOSED
TOWN
1
CITY
2
COUNTY
3
STATE
4
FEDERAL
Code
1
SIDEWALK
4
WALKING/HIKING
2
Code
Description
0
STANDARD
1
Coded value domain
GIS_TR_JURISDICTION
CITY OF ALEXANDRIA
2
ARLINGTON COUNTY
3
DISTRICT OF COLUMBIA
4
FAIRFAX COUNTY
RAILWAY
5
CITY OF FAIRFAX
PATHWAY
6
CITY OF FALLS CHURCH
3
TUNNEL
7
FEDERAL GOVERNMENT
8
String
Default value
Default value
COUNTDOWN
AUDIBLE
AUDIBLE/COUNTDOWN
Code
ROADWAY
1
DRIVEWAY
PEDESTRIAN BRIDGE
NON-FEATURE
GIS_TR_CONST_MATERIAL
AC
C ALUM
3
HDPE
MASONRY ARCH
6
RCP
7
PVC
8
STEEL
9
OTHER
Coded value domain
String
Default value
Default value
EMERGENCY
MAINTENANCE
4
OWNER
5
OPERATOR
Description
B00
Railroad, major and minor categories unknown, Not present in
Dynamap
B01
Railroad track, not in tunnel or underpassing
B02
MONDAY
TUESDAY
WEDNESDAY
SUNDAY
WEEKDAYS
B21
Railroad spur track, not in tunnel or underpassing
Coded value domain
GIS_TR_LANE_RESTRICT_TYPE
Description
Field type Short integer
Split policy Default value
Merge policy Default value
B22
Railroad spur track, in tunnel
B23
Railroad spur track, underpassing
HOV
TRANSIT
2
BIKE
B30
Railroad yard track, major category
B31
Railroad yard track, not in tunnel or underpassing
B32
Railroad yard track, in tunnel
Code
LEFT
RIGHT
OTHER
Coded value domain
GIS_TR_COUNT_SOURCE
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Code
0
FCDOT
OTHER
6
BUS
GIS_TR_RR_STATUS
7
BIKE
ALL
9
ALL BUT TRUCKS
Description
Field type String
Split policy Default value
Merge policy Default value
A
String
Default value
Default value
Code
Description
0
0 - 5%
1
ACTIVE
I
INACTIVE
P
PROPOSED
10 - 20%
FRE
> 20%
PKY
1
PIER
2
DOCK
3
MARINA
4
BOAT HOUSE
9
OTHER
Code
MAA
MEA
E
EAST
N
NORTH
Code
Description
S
SOUTH
0
MAIN LINE
W
WEST
1
SIDING
2
SPUR
3
SWITCH YARD
MIA
Description
Coded value domain
GIS_TR_STREET_RANGE_TYPE
Coded value domain
Description
Field type String
Split policy Default value
Merge policy Default value
GIS_TR_LZ_TYPE
GIS_TR_COUNT_TYPE
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Code
Description
Coded value domain
GIS_TR_RR_TYPE
Code
Description
0
HELIPORT
0
TURN
1
LZ
1
FLOW
2
AIRPORT
2
BOTH
Code
Description
METRO
METRO
Description
A
ACTUAL
T
THEORETICAL
COLLECTOR (TWO LANES, HAS SOME DRIVEWAYS, MAY HAVE TURN LANES)
LOC
LOCAL (TWO LANES, LOTS OF DRIVEWAYS, RARELY WIDENED AT INTERSECTIONS,
ALMOST ALWAYS HAS STOP SIGNS)
RAM
RAMP (HIGH-SPEED RAMP (FREEWAY-TO-FREEWAY CONNECTION), ON RAMP, OFF
RAMP)
ALY
ALLEY
CRO
CROSSOVER
STU
STUB
MRG
MERGE
RAILWAY
RAILWAY
BOTH
METRO/RAILWAY
PRIVATE
1
MUNICIPAL
RAILWAY
2
COUNTY
2
PATHWAY
3
STATE
3
WATERWAY
4
FEDERAL
4
MULTIPLE
5
VDOT
6
FAIRFAX COUNTY DPWES
8
FAIRFAX COUNTY PARK AUTHORITY
EARTHEN
0
UNKNOWN
1
CITY OF ALEXANDRIA
2
ARLINGTON COUNTY
3
DISTRICT OF COLUMBIA
4
FAIRFAX COUNTY
5
CITY OF FAIRFAX
6
CITY OF FALLS CHURCH
7
FEDERAL GOVERNMENT
FORT BELVIOR
9
LOUDOUN COUNTY
10
ALT-PRIMARY
A
ALIAS
PRINCE WILLIAM COUNTY
STAFFORD COUNTY
STATE OF MARYLAND
STATE OF VIRGINIA
Description
50
CAPTURED VIA GPS
100
L
LEFT
R
RIGHT
B
BOTH
CAPTURED FROM DIGITAL ORTHOPHOTOGRAPHY
CAPTURED FROM DIGITAL ORTHOPHOTOGRAPHY HOWEVER THE ROAD WAS STILL UNDER
CONSTRUCTION.
200
CAPTURED FROM EXISTING DATA ON 1:2400 PARCEL MAPS
230
CAPTURED FROM EXISTING DATA ON 1:2400 PARCEL MAPS HOWEVER THE EXACT PLACEMENT
CAN NOT BE FINALIZED WITHOUT FURTHER RESEARCH. AN EXAMPLE OF THIS IS ON ROYAL LANE
ON MAP 49-3. THE ACCESS POINT TO ROUTE 29 NEEDS TO BE DETERMINED.
500
CAPTURED FROM 1:48000 BASE MAP. NO OTHER ACCURATE SOURCE AVAILABLE.
998
THE EDGE OF PAVEMENT GOES OUTSIDE THE DEDICATED RIGHT-OF-WAY. THE COUNTY WILL
MAKE THE FINAL SOURCE STATEMENT UPDATE.
999
SOURCE CODE TO INDICATE THAT COUNTY STAFF SHOULD REVISIT THIS AREA DURING THE QC
PROCESS. A QUESTION THAT COULD NOT BE RESOLVED BY BAKER EXISTS IN THE DATA.
SWALE
GUARDRAIL
ARRESTOR
5
PARABOLIC CONCRETE CURB
6
ASPHALT
7
DIRT
8
GRAVEL
9
CURB
10
DRIVABLE SECTION
Code
Description
0
CCTV
1
WEATHER
2
Coded value domain
LOOP
ACOUSTIC
5
TRAFFIC COUNT
Description
Field type String
Split policy Default value
Merge policy Default value
Code
B
BUILT
HISTORIC/EXPIRED
RESERVED
B
BOTH
C
CENTER
19
REGIONAL
20
VDOT
Coded value domain
Code
Description
L
LEFT
R
RIGHT
N
NONE
GIS_TR_OWNER_TYPE
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Code
CUSHION
3
RUMBLE STRIP
4
PINCH
9
OTHER
Coded value domain
0
5
Description
BOTH
WITH
2
AGAINST
FROM_TO
TO_FROM
B
BOTH
CITY OF FAIRFAX
FORT BELVIOR
9
LOUDOUN COUNTY
10
PRINCE WILLIAM COUNTY
11
STAFFORD COUNTY
12
STATE OF MARYLAND
13
Description
FT
TF
POSTING SIGN
5
PEDESTRIAN CROSSING
STATE OF VIRGINIA
TOWN OF VIENNA
TOWN OF HERNDON
16
TOWN OF CLIFTON
17
TOWN OF OCCOQUAN
Description
Field type String
Split policy Default value
Merge policy Default value
Code
Description
B
BUILT
P
PLANNED/PROPOSED
A
APPROVED/RECORDED
Description
0
NORMAL
1
EMERGENCY
Description
LEFT TURN
2
RIGHT TURN
3
STRAIGHT AHEAD
4
U-TURN
0
NO TURN
Coded value domain
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Code
Description
0
NONE
1
PASSIVE
2
FLASHING LIGHTS
3
FLASHING LIGHTS AND BELL
4
CANTILEVER FLASHING LIGHTS
5
FLASHING LIGHTS AND GATE
6
TRAFFIC SIGNAL
Code
Description
0
STORMWATER POND
1
LAKE
2
WETLAND
9
OTHER
String
Default value
Default value
Code
Description
H00
Water feature, classification unknown or not elsewhere classified
H01
Shoreline of perennial water feature
H02
Shoreline of intermittent water feature
H10
Stream boundary, major category
H11
Perennial stream or river
REVERSIBLE LANE
LOW WATER CROSSING
NO WAKE
DEPTH MARKER
11
NAVIGATION CHANNEL MARKER
12
LOCATION REFERENCE (INCLUDING MILE MARKER)
13
LIGHTED BUOY
14
DAY MARKER BUOY
15
VARIABLE MESSAGE
16
NO U-TURN
Coded value domain
Lake or pond; major category used when the minor category could not be
determined
Intermittent lake or pond
Reservoir; major category used when the minor category could not be determined
Intermittent reservoir
H50
Bay, estuary, gulf, sound, sea, or ocean; major category used when the minor
category could not be determined
H51
EB
EASTBOUND
NB
NORTHBOUND
SB
SOUTHBOUND
WESTBOUND
IL
INNER LOOP
OL
OUTERLOOP
Coded value domain
H70
H71
H72
H73
H75
Code
VDOT
0
1
TRAFFIC
CAUTION
2
FLASHING RED
Description
GIS_TR_STREET_SUFFIX
Description
Field type String
Split policy Default value
Merge policy Default value
3
FLASHING RED/CAUTION
4
TURN ARROW
E
EAST
5
FIRE
N
NORTH
6
ITS
7
PEDESTRIAN
9
OTHER
Code
S
W
Description
SOUTH
WEST
NE
NORTHEAST
NW
NORTHWEST
SE
SW
SOUTHEAST
SOUTHWEST
Sea or ocean
GDT Shoreline
Gravel pit or quarry filled with water
H80
Coded value domain
PRIVATE
REGIONAL
Bay, estuary, gulf, or sound
H59
H60
H74
GIS_TR_SIGNAL_TYPE
Description
Field type Short integer
Split policy Default value
Merge policy Default value
18
19
20
Perennial reservoir
H42
H53
WB
Perennial lake or pond
H32
H40
GIS_TR_STREET_SUFFIX_DIR
Description
Braided stream or river
Canal, ditch, or aqueduct
Intermittent canal, ditch, or aqueduct
H30
H31
Description
Field type String
Split policy Default value
Merge policy Default value
Code
Intermittent stream, river, or wash
Perennial canal, ditch, or aqueduct
H22
H41
PEDESTRIAN FINE
7
8
9
10
FAIRFAX COUNTY
CITY OF FALLS CHURCH
FEDERAL GOVERNMENT
14
Code
ARLINGTON COUNTY
DISTRICT OF COLUMBIA
6
15
Coded value domain
GIS_TR_DIRECTION
Description
Field type String
Split policy Default value
Merge policy Default value
YEILD
WIEGHT LIMIT
4
6
7
8
STOP
4-WAY
2
UNKNOWN
CITY OF ALEXANDRIA
2
Description
Field type Short integer
Split policy Default value
Merge policy Default value
H21
GIS_TR_STREET_STATUS
Description
0
1
3
Description
0
1
3
OTHER
GIS_TR_TURN_STATUS
H20
Coded value domain
Short integer
Default value
Default value
GIS_TR_OWNERSHIP
4
1
Description
Field type
Split policy
Merge policy
Description
Field type Short integer
Split policy Default value
Merge policy Default value
GIS_TR_DIRECTION_RESTRICT
Code
Coded value domain
GIS_TR_SIGN_TYPE
Code
Description
Field type Short integer
Split policy Default value
Merge policy Default value
NO TRUCK
H12
PUBLIC
PRIVATE
Coded value domain
Code
NO CAR
1
9
H13
Description
0
1
Description
ROAD HUMP
Description
0
Description
Field type
Split policy
Merge policy
Coded value domain
GIS_TR_SIDE
Description
Field type String
Split policy Default value
Merge policy Default value
PLANNED/PROPOSED
APPROVED/RECORDED
R
SPEED BUMP
Code
Coded value domain
GIS_TR_WATER_CFCC
Description
P
A
H
PRIVATE
0
Coded value domain
GIS_TR_TURN_RESTRICT
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Coded value domain
GIS_TR_RW_NAME_STATUS
TOWN OF VIENNA
1
WEEKDAYS
SPECIAL EVENT
VEHICLE
3
4
TOWN OF CLIFTON
2
SUNDAY
9
10
GIS_TR_WATER_BODY_TYPE
GIS_TR_SENSOR_TYPE
TOWN OF HERNDON
Code
FRIDAY
SATURDAY
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Coded value domain
Description
Field type Short integer
Split policy Default value
Merge policy Default value
TOWN OF OCCOQUAN
GIS_TR_DEVICE_TYPE
THURSDAY
WEEKENDS
Coded value domain
EARTHEN BERM
4
16
Coded value domain
MONDAY
TUESDAY
WEDNESDAY
7
8
1
Code
150
17
Description
Field type Short integer
Split policy Default value
Merge policy Default value
SAME ALL DAYS
2
3
GIS_TR_WARNING_TYPE
Description
18
14
15
Description
0
VEGETATION
2
3
Description
Code
Description
0
1
GIS_TR_DATA_SOURCE
8
AP
Code
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Code
Coded value domain
Description
Field type Short integer
Split policy Default value
Merge policy Default value
13
PRIMARY
GIS_TR_RW_NAME_SIDE
CONCRETE
11
Description
P
Description
Field type String
Split policy Default value
Merge policy Default value
Coded value domain
GIS_TR_MEDIAN_TYPE
0
12
Code
Coded value domain
GIS_TR_DAM_TYPE
1
Coded value domain
GIS_TR_TURN_DAY
Code
Short integer
Default value
Default value
Description
Field type String
Split policy Default value
Merge policy Default value
FAIRFAX COUNTY DOT
7
Coded value domain
Code
Description
Field type
Split policy
Merge policy
Coded value domain
0
ROADWAY
Description
CONNECTOR
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Coded value domain
GIS_TR_RW_NAME_CATEOGRY
Description
Description
0
1
Code
RAILWAY
PATHWAY
WATERWAY
4
Coded value domain
GIS_TR_STREET_SOURCE
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Code
Description
Field type Short integer
Split policy Default value
Merge policy Default value
ROADWAY
1
2
3
GIS_TR_TURN_TYPE
GIS_TR_MAINT_RES
Code
Description
0
Code
Code
Description
Field type String
Split policy Default value
Merge policy Default value
COL
Coded value domain
Coded value domain
GIS_TR_CROSSING_TYPE
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Code
4
EXPRESSWAY (ALWAYS DIVIDED WITH A CONTINUOUS WIDE GRASSY MEDIAN,
FOUR TO EIGHT LANES, NO ABUTTING LAND USE, FEW SIGNALS OR
INTERSECTIONS, NO STOP SIGNS)
FREEWAY (INTERSTATE, LIMITED ACCESS, FOUR OR MORE LANES, NO ABUTTING
LAND USE, NO SIGNALS OR AT GRADE INTERSECTIONS)
PARKWAY (MOSTLY LIMITED ACCESS, USUALLY DIVIDED, TWO TO FOUR LANES,
NO TRUCKS, SHARPER CURVES AND GRADES THAN FREEWAY, NO SIGNALS OR
STOP SIGNS)
MAJOR ARTERIAL (ALWAYS DIVIDED WITH A WIDE GRASSY MEDIAN, FOUR TO
EIGHT LANES, TWO OR MORE TURN LANES AT INTERSECTIONS, NO STOP SIGNS)
MEDIUM ARTERIAL (USUALLY DIVIDED, WITH A NARROW GRASSY OR PAINTED
MEDIAN OR CONCRETE BARRIER, FOUR TO SIX LANES, NO STOP SIGNS, MORE
MEDIAN BREAKS THAN MAJOR ARTERIAL, ALMOST ALWAYS HAS TURN LANES)
MINOR ARTERIAL (RARELY DIVIDED, MAY HAVE PAINTED MEDIAN, TWO TO FOUR
LANES, USUALLY HAS TURN LANES)
5 - 10%
2
3
GIS_TR_STREET_PREFIX
Description
Field type Short integer
Split policy Default value
Merge policy Default value
AM
Coded value domain
GIS_TR_TRANS_MODE
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Description
EXP
Description
Field type String
Split policy Default value
Merge policy Default value
GIS_TR_RR_TRACK_TYPE
PM
WOOD
WOOD CHIP
5
Code
Coded value domain
RAMP
METAL
WATER
10
11
1
Description
Field type
Split policy
Merge policy
Description
Coded value domain
Description
0
DIRT
GRASS
GRAVEL
9
Description
Field type Short integer
Split policy Default value
Merge policy Default value
GIS_TR_STREET_CLASS
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Code
OFF PEAK
Coded value domain
Stairway, stepped road for pedestrians, usually unnamed
Alley, road for service vehicles, usually unnamed, located at the rear of buildings and
property
Driveway or service road, usually privately owned and unnamed, used as access to
residences, etc., or as access to logging areas, etc.
Road, Parking Area
GIS_TR_STREET_INCLINATION
Coded value domain
8
Code
5
6
SHOULDER
AIRPORT TRAFFIC
1
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Ferry Crossing, Vehicular, Seasonal
Ferry Crossing, Vehicular, Year-Round
Other thoroughfare, major category used when the minor category could not be
determined
Walkway or trail for pedestrians, usually unnamed
Coded value domain
4
5
2
Description
A68
A69
Coded value domain
FREIGHT
Coded value domain
0
Vehicular trail, road passable only by 4WD vehicle, unseparated, underpassing
Special road feature, major category used when the minor category could not be
determined
Cul-de-sac, the closed end of a road that forms a loop or turn-around
AMTRACK
GIS_TR_LANUCH_TYPE
Code
A53
Description
FREIGHT AND AMTRACK
FREIGHT AND COMMUTER
FREIGHT, AMTRACK AND COMMUTER
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Vehicular trail, road passable only by 4WD vehicle, unseparated
Vehicular trail, road passable only by 4WD vehicle, unseparated, in tunnel
A65
COMMUTER
3
4
5
VDOT
1
9
GIS_TR_COUNT_TIME
A51
A52
A74
1
Description
Coded value domain
Vehicular trail, road (4WD) vehicle, major category
Traffic circle, the portion of a road or intersection of roads forming a roundabout
SOV
BRICK
CONCRETE
Local, neighborhood, and rural road, city street, separated, with rail line in center
A66
HOV 2
HOV 3
ASPHALT
COBBLESTONE
A48
Access ramp, the portion of a road that forms a cloverleaf or limited-access interchange
Service drive, road that provides access to businesses, facilities, and rest areas along
limited-access highway
Ferry crossing, the representation of a route over water that connects roads on opposite
shores
Ferry crossing, Passenger, Year Round
Description
TRUCK PULLOFF
UNKNOWN
2
3
4
A50
A75
2
1
2
3
Description
0
1
6
A72
0
0
Code
7
A73
Code
Code
GIS_TR_SURF_TYPE
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Local, neighborhood, and rural road, city street, separated, in tunnel
A70
Description
Field type Short integer
Split policy Default value
Merge policy Default value
KNOLLS
CROSSING
Local, neighborhood, and rural road, city street, separated, underpassing
A71
Coded value domain
STATIC
DYNAMIC
WAY
COMMONS
XING
A46
A63
Coded value domain
GIS_TR_LANE_TYPE
Description
1
WALK
WAY
KNLS
Coded value domain
A47
A64
Description
Field type Short integer
Split policy Default value
Merge policy Default value
9
Local, neighborhood, and rural road, city street, separated
A61
BOTH
L
Local, neighborhood, and rural road, city street, unseparated, underpassing
Local, neighborhood, and rural road, city street, unseparated, with rail line in center
A45
A62
Subway or Metroline
Cog railroad, incline railway, or logging tram
Description
B
R
Local, neighborhood, and rural road, city street, unseparated
Local, neighborhood, and rural road, city street, unseparated, in tunnel
A43
A44
Railroad yard track, underpassing
B52
WALK
CMNS
Secondary and connecting road, state highways, separated
Secondary and connecting road, state highways, separated, in tunnel
Secondary and connecting road, state and county highways, separated, underpassing
Secondary and connecting road, state and county highway, separated, with rail line in
center
Local, neighborhood, rural road, city street, major category
A60
Other rail line; major category used alone when the minor category
could not be determined
Carline, a track for streetcars, trolleys, and other mass transit rail
systems
B50
B51
Coded value domain
0
Secondary state and county highways, major category
Secondary and connecting road, state highways, unseparated
Secondary and connecting road, state highways, unseparated, in tunnel
Secondary and connecting road, state highways, unseparated, underpassing
Secondary and connecting road, state highways, unseparated, with rail line in center
A36
A37
Railroad ferry crossing, route over water used by ships carrying
train cars to connecting railroads on opposite shores
B33
Coded value domain
GIS_TR_LANE_SIDE
Description
Field type String
Split policy Default value
Merge policy Default value
GIS_TR_COUNT_PERIOD
Code
VIEW
8
Description
0
1
TRACE
TRAIL
A41
Railroad main track, underpassing
Railroad spur track, major category
STREET
TERRACE
TURNPIKE
VW
A42
Railroad main track, in tunnel
B13
B20
SQUARE
ST
TRL
A40
Railroad Main Track, major category
Railroad main track, not in tunnel or underpassing
B12
ROW
SQ
TER
Railroad track, underpassing
B10
B11
FRIDAY
SATURDAY
WEEKENDS
9
RUN
ROW
TRCE
TPKE
A34
Railroad track, in tunnel
B03
THURSDAY
7
8
ROAD
RIDGE
Primary road without limited access, US highways, separated, in tunnel
A38
2
PLAZA
RD
RUN
Primary road without limited access, US highways, separated, underpassing
A35
GIS_TR_RR_SERVICE_TYPE
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Primary road without limited access, US highways, separated
PASS
PARKWAY
PLZ
RDG
Primary road without limited access, US highways, separated, with rail line in center
A30
Code
B42
PRIMARY
SECONDARY
2
3
Primary road without limited access, US highways, unseparated, underpassing
Primary road without limited access, US highways, unseparated, with rail line in center
PIKE
PASS
PKWY
A27
A32
3
PATH
A28
A33
Description
EVERYDAY
B40
Description
0
1
A23
A24
A31
Coded value domain
GIS_TR_LANE_RESTRICT_DAY
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Code
Primary Highways without limited access, major category
A25
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Code
GIS_TR_CONTACT_TYPE
Primary road with limited access or interstate highway, separated, with rail line in center
A26
GIS_TR_RR_CFCC
CMP
4
5
A18
A20
Coded value domain
Description
Field type
Split policy
Merge policy
6
UNKNOWN
AIRPORT
COUNTY ROAD
TOWN OF CLIFTON
4
Description
0
1
2
PARK
STATE OF VIRGINIA
5
Code
AIR
STATE OF MARYLAND
0
NOOK
PLACE
Primary road without limited access, US highways, unseparated
Code
LOOP
NK
PL
Primary road without limited access, US highways, unseparated, in tunnel
UNKNOWN
LANE
LANDING
PATH
A21
TOWN OF VIENNA
HEIGHTS
HIGHWAY
LN
PARK
A22
TOWN OF HERNDON
GROVE
HTS
Primary road with limited access or interstate highway, separated
INTERSTATE
TOWN OF OCCOQUAN
GREEN
GRV
Primary road with limited access or interstate highway, separated, in tunnel
LOCAL ROAD
0
COVE
DRIVE
GRN
HWY
LNDG
LOOP
Primary road with limited access or interstate highway, separated, underpassing
STATE HIGHWAY
1
Coded value domain
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Primary road with limited access or interstate highway, unseparated, with rail line in center
INT
17
COURT
A16
LOC
15
CIRCLE
A17
HWY
16
CENTER
CLUSTER
CT
PIKE
Description
LOUDOUN COUNTY
RAILWAY
CROSSWALK
PARKING LOT
7
8
A14
A15
Code
STAFFORD COUNTY
WATERWAY
4
5
6
GIS_TR_REG_STREET_CLASS
Description
Field type String
Split policy Default value
Merge policy Default value
Primary road with limited access or interstate highway, unseparated, in tunnel
Primary road with limited access or interstate highway, unseparated, underpassing
PRINCE WILLIAM COUNTY
PATHWAY
2
3
Description
Primary road with limited access, major category
Primary road with limited access or interstate highway, unseparated
A12
A13
9
13
Description
0
BELTWAY
CORRIDOR
DR
2
3
Coded value domain
CTY
FORT BELVOIR
ALLEY
AVENUE
BOULEVARD
CL
CORR
CV
10
14
Code
Description
AVE
CIR
11
12
Coded value domain
Code
BLVD
CTR
Description
Field type
Split policy
Merge policy
A10
Description
1
1
GIS_TR_CONNECTOR_TYPE
GIS_TR_STREET_USPS
Description
Field type String
Split policy Default value
Merge policy Default value
A11
Code
2
Description
Field type Short integer
Split policy Default value
Merge policy Default value
WAY
ALL
PUBLIC SAFETY ONLY
MAINTENANCE AND PUBLIC SAFETY
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Description
VIEW
WALK
CROSSING
BLTWY
VDOT
ROADWAY
TRAIL
KNOLLS
XING
BUS
NO TRUCK
3
4
GIS_TR_STREET_CFCC
OTHER
0
TURNPIKE
COMMONS
KNLS
Coded value domain
Coded value domain
0
Code
TERRACE
TR
Description
0
EQUESTRIAN
3
Description
Field type Short integer
Split policy Default value
Merge policy Default value
1
Description
Field type Short integer
Split policy Default value
Merge policy Default value
YES
TRACE
TE
VW
Coded value domain
GIS_TR_PED_SIGNAL_TYPE
Description
NO
1
RUN
ROW
STREET
TC
TP
I
Description
0
ROAD
SQUARE
ST
P
Code
PLAZA
RIDGE
SQ
Description
0
GIS_TR_BRIDGE_TYPE
PASS
PARKWAY
RI
RN
ALY
Code
Coded value domain
PS
PW
RW
Description
Description
Field type Short integer
Split policy Default value
Merge policy Default value
BIKE
2
Coded value domain
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Code
PARK
PL
CMNS
8
13
PK
COMMERCIAL
GIS_TR_STREET_AUTH
9
Description
Field type Short integer
Split policy Default value
Merge policy Default value
AUTO AND COMMUTER BUS
Coded value domain
10
GIS_TR_BRIDGE_SOURCE
6
7
PZ
9
YES
GIS_TR_YN_NUM
RD
Description
Field type Short integer
Split policy Default value
Merge policy Default value
NO
Y
Coded value domain
PIKE
Code
GIS_TR_PATH_TYPE
Description
N
PATH
WK
ALL
1
2
Code
LOOP
NOOK
PI
WY
0
Coded value domain
LANE
LANDING
LP
PA
Coded value domain
Code
ESN
FIRE
HEIGHTS
HIGHWAY
LA
LD
NK
COMMUTER BUS AND RAIL
GIS_TR_STATUS
GIS_TR_GATE
Description
Field type Short integer
Split policy Default value
Merge policy Default value
ZIP
ZIP4
6
7
DRIVE
GREEN
GROVE
HT
HY
METRO
AIRPORT
COMMUTER BUS AND METRO
Coded value domain
GATE
BOLLARD
CONCRETE
STREAM
Description
Field type String
Split policy Default value
Merge policy Default value
3
Description
Field type String
Split policy Default value
Merge policy Default value
Description
1
2
NAVIGABLE CHANNEL
GIS_TR_YN_CHAR
4
GIS_TR_PATH_BARRIER_TYPE
0
2
RAIL
Description
0
1
Coded value domain
5
Coded value domain
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Code
GIS_TR_BORDERLINE_TYPE
Description
Field type Short integer
Split policy Default value
Merge policy Default value
COMMUTER BUS
1
2
STATE OF MARYLAND
17376
Coded value domain
COVE
GV
Description
0
OTHER COMMERCIAL
4
CITY OF FAIRFAX
27200
29008
COURT
GR
Code
OFFICE
3
FAIRFAX COUNTY
26496
EARTHEN BERM
CLUSTER
CORRIDOR
CT
CV
DR
Description
Field type Short integer
Split policy Default value
Merge policy Default value
Description
0
Description
ARLINGTON COUNTY
51059
FENCE
PARABOLIC CONCRETE CURB
ARRESTOR
50000
CITY OF ALEXANDRIA
SOUND BARRIER
3
4
5
1
2
Code
CIRCLE
CL
CR
Nonvisible water area definition boundary; used to separate named water areas
USGS closure line; used as maritime shoreline
Census water center line; computed to use as a median positional boundary
Census water boundary, international in waterways or at 10-mile limit; used as an
area measurement line
Census water boundary separating inland from coastal or Great Lakes; used as an
area measurement line
Census water boundary separating coastal water from territorial sea at the 3-mile
limit; used as an area measurement line
Special water feature; major category used when the minor category could not be
determined
Logical Model Characteristics
Contains point, polyline, polygon, boundary, and
other features
Includes 53 primary tables
Incorporates raster imagery
Provides a non-asset management focus
Introduces a “connector” polyline feature for use in
routing
Meets nearly all needs of Fairfax County agencies
and VDOT
Allows incremental adoption by other regional
jurisdictions
Supports point addressing and integration with
County’s Master Address Repository (MAR) for CAD
Issues and Next Steps
911 Dispatch requires a complete network of both
planned and actual roads for public safety incident
response, and this requirement will necessitate a
change in current County street centerline updating
procedures (three stage approach)
A variety of relatively minor anomalies with the
current enterprise centerline will need to be resolved
No single source of data exists to populate
the new model
Multiple existing sources and techniques will need to
be utilized to build and maintain some portions of the
new transportation network database; new sources
and procedures will also be required to populate other
data elements
Issues and Next Steps – con’t
Some County agencies have unique centerline
requirements because of their current COTS software,
and some software/procedural modifications may be
required
CAD AVRR routines emphasize roadway routing and
may not be sophisticated enough to effectively use all
modes and data included in the transportation
network model
Regional data will be considerably less detailed than
Fairfax County data
Next Steps
Produce physical data model
Determine data gaps
Prepare data migration plan for existing data
sources
Craft development plan for missing data
Generate statement of work to produce data
required for transportation network database and
AVRR factors
Prepare data procurement RFP
Evaluate current 911 CAD layers for migration
Prepare CAD conversion statement of work and RFP
Presented by:
Jim Fries
Executive Consultant
PlanGraphics, Inc.
[email protected]
and in absentia
Brendan Ford
Application Development Manager
Fairfax County Department of Information Technology
Geographic Information Services
[email protected]