Requirements for High Crash Location Lists
High Crash Location reports are currently only valid for databases that locate their crashes based on street and cross street. For a database to be able to use High Crash Location reports crash records must be able to link to the following items:
•Primary Street Field
•Cross Street Field
•Date Field
Additionally, these streets must be able to be located to a specific city as street names can repeat across states.
Required Crash Magic Attributes:
•Distinct Streets query - This query returns a data set that contains a list of unique streets in the database. It should contain the street name, along with unique 1 and unique 2 if needed.
•Distinct Intersection query - This query returns a data set that contains a list of unique locations in the database. It should contain the primary street name, cross street name, and unique fields as needed.
•Street Normalizer - This PSRAttr defines what a street is.
•Intersection Normalizer - This PRAttr defines what an intersection is.
•All Data query that has the same fields as specified in the Distinct Intersection query.
•Node button enabled in the button list.
•xsl-locationlist - A XSL style sheet to display the results.( This should be located in your Master .shared user)