Streets

This query is used to create a list of all the streets in a client database. The streets query is only used for clients implementing the intersection study. This query and the streets normalizer are used to display the list of possible streets when a user starts to enter a street name in an intersection study, address or milepost study.

Example query:

SELECT

St.Streetname AS Fullstreetname

FROM

CITY.STREETS St

In this example the clients collision database contains a table called Streets that maintains a relationship the clients collision table.

Some clients do are not able to validate their street locations is this way, and may resort to querying all of the streets from their collision table.