Data Tables

TableName

Description

ACKEY

Accident Key Distances

INTNET

Intersection Network Table

INTNETJR

Intersection Leg Table

STACDATA

Accident Data Table

STACOCC

Accident Occupants

STACOO

Accident Officers Opinion

STACPED

Accident Pedestrian Table

STACVEH

Accident Vehicles

STACVIOL

Accident Violations

STACWIT

Accident Witnesses

STAEINS

Auxiliary Equipment Inspections

STAGATE

ITS AutoGate Inventory

STAICE

ITS Anti-Icing Inventory

STAICEPH

ITS Anti-Icing Pump House Inventory

STAUXILEQP

Auxiliary Equipment

STBRINS

Bridge Inspections

STBRINV

Bridge Inventory

STBSINS

Bus Stop Inspections

STBSINV

Bus Stop Inventory

STCABINET

Cabinets Inventory

STCABWAR

Cabinet Warranty Information

STCACCESOR

Cabinet Accessories

STCAML

ITS Camera Location Inventory

STCDECTOR

Signal Controller Detectors

STCIRCUIT

Street Light Circuit Inventory

STCLASS

Family Classes

STCNTRLINV

Signal Controller Inventory

STCNTRLOPT

Signal Controller Option Data

STCNTRWA

Controller Warranty Information

STCOM

Communication Path for ITS

STCOMD

Communication Device for ITS

STCOMDH

Communication Device/Phone Activity History Tracker for ITS

STCON

Street Construction Records

STCONA

Street Construction Asset Types

STCONAD

Street Construction Assets

STCONDML

Conduit and Main Line Linking Table

STCONDUCTR

Street Cabling Conductor

STCONDUIT

Street Cabling Conduit

STCONLOC

Street Construction Locations

STCOVERLAP

Street Controller Overlap

STCPREMPT

Signal Controller Preemptor

STCPREMPTP

Signal Controller Preemptor Phasing

STCTCLOCK

Signal Controller Clock

STCULINS

Street Culvert Inspection (linked to Structures)

STCULINSR

Street Culvert Inspection Recommendations

STCUPRBFIX

Side Walk Repair Requirements

STCUPROB

Side Walk Inspection Problems

STCURBINSP

Street Curb Inspection

STCURBINV

Street Curb Inventory

STCYCLESET

Signal Controller Cycle Offsets

STDGRKEY

Accident Diagram Key

STDGTEMP

Accident Diagram Temp

STDMS

ITS Dynamic Messaging Sign Inventory

STFENINS

Fence Inspection

STFENINV

Fence Inventory

STFIBROPTC

Fiber Optic Inventory

STFLASH

Signal Controller Start/Flash Data

STFOASSOC

Signal Controller Force Off Relations

STFORCEOFF

Signal Controller Force Off Timing

STFURN

Furniture Inventory

STFURNI

Furniture Inspections

STGDMEMO

Grid Memo

STGRINS

Guard Rail Inspection

STGRINV

Guard Rail Inventory

STJBOXINV

Junction Boxes Inventory

STKIOSK

ITS Kiosk Inventory

STLCCINS

Street Light Controller Inspections

STLCCINV

Street Light Controller Inventory

STLEADLAG

Signal Controller Lead/Lag Coordination

STLITINS

Street Light Inspections

STLITINV

Street Light Inventory

STLITLIB

Street Light Library

STLSA

Landscape Area Inventory

STLSAI

Landscape Area Inspections

STMAINLINE

Main Cabling Line Inventory

STMARM

Street Pole Mast Arm Inventory

STMDBDRZ

Pavement Rehab for Surface/Classification Combination

STMDBUD

Pavement Modeling Budget

STMDBUDD

Pavement Modeling Budget Annual Details

STMEDINS

Medians Inspection

STMEDINV

Medians Inventory

STMEMO

Some of the Comments Data

STMETERBOX

Meter Boxes Inventory

STMODLSEG

Model Segment Results

STMODLSUB

Model Subsegment Results

STMODLYEAR

Model Year-end Results

STMODPAR

Model Parameters

STMSCOST

Miscellaneous Cost

STMUTCD

Street Sign Descriptions

STNET

Street Segment Inventory

STPARAM

Pavement Parameters

STPARAMC

Pavement Condition Parameter

STPARK

ROW Parking Inventory

STPARKINS

ROW Parking Inspection

STPCIMATRX

User Defined PCI Matrix for Severity/Density

STPDMS

ITS Portable Dynamic Messaging Sign Inventory

STPERMASSC

Signal Controller Permissions

STPERMTIM

Signal Controller Coordination Permissions

STPHASESEQ

Signal Controller Phase Sequencing

STPHASET

Signal Controller Phase Timing

STPLAN

Planning Table

STPLANADD

Streets Added per Year for Model Run

STPLANYTW

Streets with Planned Work on a Specific Year

STPMINS

Pavement Markings Inspection

STPMINV

Pavement Markings Inventory

STPOLINSP

Street Pole Inspections

STPOLINV

Street Pole Inventory

STPRBADJ

Pavement Rehab for Surface/Classification Combination

STPRBADJDF

Pavement Rehab for Surface/Classification Combination

STPREEMPT

Preempt Signal Inventory

STPREHAB

Pavement Rehab Techniques

STPREHABDF

Pavement Rehab, Pavement Type, Classifications Combinations

STPSTALL

Parking Stall

STPSTAND

Pavement Standards - Deterioration Rates

STPVDIST

Pavement Distresses

STPVFLD

Pavement Field Inspections

STPVFLDD

Pavement Field Inspection Distress Details

STPVFLDREC

Pavement Field Recommendations

STPVPCI

Pavement PCI Setup

STPVPCID

Pavement PCI Setup/Distress Type Join Table

STPVREHAB

Street Curb Inspection

STRAMPIDT

Ramp Inspection Details

STRAMPINS

Ramp Inspection

STRAMPINV

Ramp Inventory

STRDASST

Road Assets

STRDCH

Road Attributes

STRDRAMP

Road Ramp

STRDROAD

Road Inventory

STRDROADA

Road Attributes

STRDSEG

Road Segment Inventory

STROUTE

Route

STRRXINS

Railroad Crossing Inspections

STRRXINV

Railroad Crossing Inventory

STRWIS

ITS Weather Station Inventory

STSENS

ITS Sensor Inventory

STSERVPLAN

Signal Controller Phase and Service Plan

STSGNREG

Street Sign Inventory & Regulations Link

STSHEAD

Signal Heads Inventory

STSHINS

Signal Head Inspections

STSIGNINS

Street Sign Inspections

STSIGNL

Signal Inventory

STSIGNLI

Signal Inspections

STSIGNREG

Street Sign Regulations

STSININV

Street Sign Inventory

STSNLORO

Route Link

STSNLPSC

Structure/Segment Linking Table

STSNOWSHOE

Snow Shoes Inventory

STSPLANPRG

Signal Controller Service Plan

STSPRSP

Linking Supersegments Table

STSSECT

Signal Head Sections

STSSECTLIB

Signal Head Sections Library (not used)

STSTEPSINS

Steps Inspection

STSTEPSINV

Steps Inventory

STSTRUCT

Structure Inventory

STSUBSEG

Subsegment Inventory

STSUPER

Supersegment Table

STSWINSP

Side Walk Inspections

STSWINV

Side Walk Inventory

STSWPRBFIX

Side Walk Repair Requirements

STSWPROB

Side Walk Inspection Problems

STTRAFDECT

Traffic Detector Inventory

STTRAIL

Trail Inventory

STTRAILI

Trail Inspections

STTVINT

Street Intersection Traffic Volume

STTVINTJR

Street Intersection Traffic Volume Child

STTVINTJRD

Street Intersection Traffic Volume Child Details

STTVSEG

Street Segment Traffic Volume

STWALLINS

Wall Inspections

STWALLINV

Wall Inventory