Illinois Department of Transportation, Ann L. Schneider, Secretary
Loading
Patrick J. Quinn, Governor
Traveling PublicMapsProjectsRoad ClosuresNewsDoing BusinessLetting & BiddingCareers@IDOTGeneral Info


QUERY TIPS FOR SIMS - COUNTY

  • Important fields for record selection criteria in SIMS-County queries.

SIMS Field Name

ISIS
Item #

SIMS Table

Description
KRLinkOn

12

All

Code "Y" indicates that a road is carried on the bridge and that the road is linked in the Illinois Roadway Information System.
KRLinkUn

12

All

Code "Y" indicates that a road is carried under the bridge and that the road is linked in the Illinois Roadway Information System.
Status

41

ISIS Master
ISIS Summary

Field operational status of bridge. e.g., Code "2" indicates weight limit posting in place and code "9" is for bridges not yet built, etc.
AASHTOLength

112

ISIS Master
ISIS Summary

Bridges 20.0' or less that carry a road are not subject to the NBIS.
ReportingAgency

22A

ISIS Master
ISIS Summary

Indicates type of agency responsible for reporting ISIS data to IDOT. e.g., State reported structures = "1", County reported structures = "3".
MainStrType

43B

ISIS Master
ISIS Summary

2-digit ID # for the structural type of a bridge. Code "26" (Low Water Crossing) structures, and certain other types, should normally be excluded in queries since they are not subject to the NBIS.
SequenceNBR

N/A

Tables w/2 or more records per bridge*

Indicates the historical sequence of NBIS inspections, etc., with the most recent coded "1".
MaintRespA & MaintRespB

21A & 21B

ISIS Master
ISIS Summary

Indicates the types of agencies responsible for the maintenance of a structure.
MaintCountyNumber

3B

ISIS Master
ISIS Summary

3-digit ID # indicating the county where the agency with primary maintenance responsibility is located.
MunicipalityCodeOn or ...Under

4

Key Route On or …Under
ISIS Summary

4-digit ID # for the municipality where the road on or under the structure is located. (Not related to bridge maintenance.)
MaintTwspCode

3B1

ISIS Master
ISIS Summary

For township bridges, 2-digit ID # for township responsible for bridge maintenance.
* Tables that may have 2 or more records per bridge: Const Reconstruction, Fracture Critical Inspections, Fracture Critical Members, Inspection Appraisals, Key Route On, Key Route Under, Microfilm History, Scour Critical Inspections, Underwater Inspections.
Note: For detailed descriptions of fields refer to the IDOT Structure Information and Procedure Manual.
  • If the Criteria box in the query design for the field "KRLinkOn" is not set to "Y", your query will generate records for any structures that may be in your county carrying railroads, bikepaths, etc., in addition to bridges carrying roads. These structures do not require NBIS inspections.
  • The field "SequenceNbr" will usually be needed in queries that include tables that may have more than one record per structure. For example, in the table "Inspection Appraisals", SequenceNbr is 1 for the most recent inspection, 2 for the inspection previous to "1", 3 for the one previous to "2", etc. The SequenceNbr field in Construction / Reconstruction information employs a slightly different coding scheme. The Original Construction record (code "O") always has SequenceNbr = "0" (zero), Reconstruction (code "R") records are numbered in descending date order from "1" to "50" and minor maintenance (code "M") records are numbered by descending date beginning with "51".
  • Care must be exercised when performing queries referring to multiple tables where some of the records of one are not matched in the other. When the tables are joined in the query, give special attention to proper configuration of the join properties. Example: A query is based on the ISIS Master and Inspection Appraisals tables and it is desired to output data for bridges not yet inspected (i.e. no Inspection Appraisals record exists). Use the following Join Property- "Include ALL records from 'ISIS Master' and only those records from 'Inspection Appraisals' where the joined fields are equal." The link between the tables will be graphically represented by a line with and arrow head pointing to the Inspection Appraisals table box.
  • To simplify querying in SIMS-County, the ISIS Summary State And Local table has been provided. This table contains, in one record per bridge, data from the ISIS Master, Key Route, Construction and other tables including only the most recent inspection and reconstruction information. The one record per structure format simplifies querying by making table joins unnecessary.
IDOT Privacy Statement | Illinois Privacy Information | Kids Privacy | Web Accessibility  | FOIA