√
|
Description
|
Name
|
Note
|
|
|
|
|
Create SQL scripts for data tables
|
|
Create resource: SQLScript
|
CreateCrashTables
|
Hopefully just one for all tables needed
|
|
Create resource: SQLScript
|
InsertLookups
|
Inserts lookups. As many as needed to fit in 64k and for logical categories
|
|
Create resource: SQLScript
|
DropCrashTables
|
Will be used only during configuration testing
|
|
Instantiate database on DEV SQL Server
|
|
Permissions granted automatically using web interface
|
|
|
|
|
Create remaining basic configuration resources
|
|
Create resource: Locale Info
|
Default
|
non-US customers only
|
|
Create resource: .options
|
Default
|
|
|
Locate and set agency logo
|
<ST>_<City>.png
|
250x250 pixels exactly. Must send to Scott or Pete to add to source.
|
|
|
|
|
Create and verify connections
|
|
Create resource: Connection
|
Reader
|
|
|
Create resource: Connection
|
Writer
|
Used for changing crash data, coordinate data, volume data, etc.
|
|
|
|
|
Create and test import definitions
|
|
Create resource: Lookup Query
|
Lookups
|
Prefer fewer queries to more. Performance penalty at login
|
|
Create resource: ImportLookups
|
ImportLookups
|
Needed only if converting data (i.e. text to numbers) on import (rare)
|
|
Create resource: DBtoXML
|
<Source>_DBtoXML
|
Needed if source data is not XML.
|
|
Process DBtoXML
|
|
Use the resulting XML to create XMLtoDB
|
|
Create resource: XMLtoDB
|
<Source_XMLtoDB
|
All configurations will need this unless 100% data entry
|
|
Import using XMLtoDB
|
|
|
|
|
|
|
Create analysis queries
|
|
Create resource: Study query
|
Crashes
|
One per roadway system. (usually just one) Fill in normalize and lookup values
|
|
Create resource: Calculated fields
|
P_Default
|
All values required - basis for normalizing data
|
|
Create resource: Calculated fields
|
P2_Default
|
Currently used for GIS - required
|
|
Create resource: Calculated fields
|
U_UserSpecific
|
Handy for making object map clearer or providing custom fields for user
|
|
Create resource: query
|
ClickOn
|
|
|
Create resource: query
|
ClickOnImages
|
For data that may have multiple images/columns per crash
|
|
|
|
|
Create normalizers
|
|
Create resource: Streets query
|
Streets
|
For streets normalizer
|
|
Create resource: Intersections query
|
Intersections
|
For intersection normalizer
|
|
Create resource: Nodes query
|
Nodes
|
For node normalizer. If nodes used
|
|
Create resource: Street normalizer
|
Default
|
"Default" is for the primary road system
|
|
Create resource: Intersection normalizer
|
Default
|
|
|
Create resource: Node normalizer
|
Default
|
|
|
|
|
|
Create study definitions
|
|
Create resource: study definition
|
Date range
|
|
|
Create resource: study definition
|
Case id
|
|
|
Create resource: study definition
|
Intersection...
|
Intersection, Route milepost, Address, UserCID, XY Rect, etc.
|
|
|
|
|
Create object map
|
|
Create resource: Object map
|
Default
|
|
|
Add veh 1 and veh 2 movements
|
|
|
|
Add veh 3 direction symbol
Add bicycle, pedestrian, direction and no direction
|
|
|
|
Add injury, fatality, DUI, nighttime symbols
|
|
|
|
Add any remaining attributes
|
|
|
|
|
|
|
Create templates
|
|
Create resource: Field list
|
ClickOn
|
from analysis side
|
|
Create resource: Field list
|
ClickOnImages
|
from analysis side
|
|
|
|
|
Prepare data entry
|
|
Create resource: Data entry definition
|
LongForm, ShortForm, etc.
|
|
|
Create resource: Validation rules
|
Default
|
|
|
|
|
|
Misc. items
|
|
Create resource: .Options report buttons
|
Default
|
User specific templates
|
|
|
|
|
Complete verification
|
|
Prepare verification document
|
|
|
|
Have verification document reviewed
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|