Data Sources

The reports in Inventory Manager either pull from RIMS or use the overlay. The table below outlines each report and its data source.

Filters

The reports are also based on filters. The sections below outline the WHERE clauses for each report.

Annual and Daily VMT by County (EZRIVM8G)

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID in ( 1,2,4,7,9,10,11,12,13 ) ) AND  
         ( O.LURouteAuxID <> 9 ) AND
         O.LUCountyID <> 47 AND 
         O.F_System > 0
		and ( O.Fed_Owner_ID is null or O.Fed_Owner_ID not in (3,10))

Annual and Daily VMT by County (State Maintained)

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID in ( 1,2,4,7 ) ) AND  
         ( O.LURouteAuxID <> 9 ) AND
         O.LUCountyID <> 47 AND 
         O.F_System > 0
		and ( O.Fed_Owner_ID is null or O.Fed_Owner_ID not in (3,10))

Annual VMT by County by System (EZRIVM8)

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE LURouteTypeID in ( 1,2,4,7,9,10,11,12,13 )
       and LURouteAuxID <> 9
       and o.LUCountyID <> 47
       and (Fed_Owner_ID is null or Fed_Owner_ID not in (3,10))

Bridge RIMS/BrM Discrepancies Report

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( ( rb.q_is_dom is null and rb.q_is_domu is null and rb.q_is_dom_hmms is null and rb.q_is_domu_hmms is null ) 
       or   ( rb.q_is_dom = 1 and rb.q_is_domu = 1 and rb.q_is_dom_hmms = 1 and rb.q_is_domu_hmms = 1 ) )

and ( rb.dom_rte_lrs is null or NOT ( to_number( substr( rb.dom_rte_lrs, 10, 2 ) )  = 1 ) )
and REGEXP_LIKE (bb.STRUCT_NUM,'^-?\d+(\.\d+)?$')  -- only look at BrM Bridge records where STRUCT_NUM is numeric
) b 
where b.RIMS_Status <> b.BrM_Status

C Apportionment (RIRURAL) (CHECK THIS)

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID in ( 1,2,4,7,9,10,11,12,13 ) )
			AND ( O.LURouteAuxID <> 9 )
			AND  ( O.AREA_ID = 1)
			AND O.LUCountyID <> 47
			and ( O.Fed_Owner_ID is null or O.Fed_Owner_ID not in (3,10) ))

Centerline Lane Public Miles

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

Runtime WHERE Clause
WHERE A.LURouteTypeID IN (1,2,4,7) AND
        A.F_System > 0 AND
        A.LURouteAuxID != 9 AND
        A.LUCountyID != 47
)

Centerline Lane Public Miles (State Maintained)

Overlay: RIMS Standard Reports Data Source (Overlay Table): Overlay103412122022131957

WHERE A.LURouteTypeID IN (1,2,4,7) AND
        A.F_System > 0 AND
        A.LURouteAuxID != 9 AND
        A.LUCountyID != 47

Corridor Fact Sheet

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

This report contains no WHERE clause

DVMT / AVMT Inventory Reports

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE A.LURouteTypeID IN (1,2,4,7) AND
A.F_System > 0 AND
A.LURouteAuxID != 9 AND
A.LUCountyID != 47 AND
(A.Fed_Owner_ID IS NULL OR A.Fed_Owner_ID NOT IN (3,10))

DVMT / AVMT Inventory Special Reports

Overlay: RIMS Standard Reports Data Source (Overlay Table): Overlay103412122022131957

WHERE A.LURouteTypeID IN (1,2,4,7) AND
A.S_Area_ID IS NULL AND
A.LURouteAuxID != 9 AND
A.F_System IS NOT NULL AND
(A.Fed_Owner_ID IS NULL OR A.Fed_Owner_ID NOT IN (3,10))

Federal Aid Breakdown

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID in ( 1,2,4,7 ) )
		AND ( O.LURouteAuxID <> 9 )
		AND O.LUCountyID <> 47

Federal Aid Breakdown by Lanemiles

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID IN( 1,2,4,7) ) AND
		( O.LURouteAuxID <> 9 )
		AND O.LUCountyID <> 47

Federal Aid Eligibility

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID NOT IN(15,16) ) AND
		( O.LURouteAuxID <> 9 )
		AND O.LUCountyID <> 47
		AND (O.Fed_Owner_ID IS NULL or O.Fed_Owner_ID NOT IN (3,10))

Federal Aid Eligibility by DVMT

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID NOT IN(15,16) ) AND
		( O.LURouteAuxID <> 9 )
		AND O.LUCountyID <> 47
		AND (O.Fed_Owner_ID IS NULL or O.Fed_Owner_ID NOT IN (3,10))

Federal Aid Eligibility by Lanemiles

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID NOT IN(15,16) ) AND
		( O.LURouteAuxID <> 9 )
		AND O.LUCountyID <> 47
		AND (O.Fed_Owner_ID IS NULL or O.Fed_Owner_ID NOT IN (3,10))

Federal Aid Eligibility by Lanemiles, Primary NHS & Non-NHS

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID NOT IN(15,16) ) AND
		( O.LURouteAuxID <> 9 )
		AND O.LUCountyID <> 47
		AND (O.Fed_Owner_ID IS NULL or O.Fed_Owner_ID NOT IN (3,10))

Gaps and Noncontiguous Milepoints Report

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE a.RPT_ID = 13
AND length(dom_rte_lrs)=12

Interchange Report

Overlay: RIMS Standard Reports Data Source (Overlay Table): Overlay103412122022131957

WHERE DT_COUNTIES.DISTRICT_ID = :DistrictID

Interstate Mileage Report

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID = 1)
			 AND ( O.LURouteAuxID <> 9 )
			 AND O.LUCountyID <> 47

Interstate Mileage, VMT and DVMT by Route (EZRIVM8Y)

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID = 1) AND  
			 ( O.LURouteAuxID <> 9 ) AND
			 O.LUCountyID <> 47

Log Mile

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE rv_logmile.feature_id IN (2,3,4,5,6,7,8,9,10,11,12,13,14)

-- District filter
AND (:is_district IS NULL OR rv_logmile.district_id = :is_district)

-- Pavement District and County filters
AND (
    :is_pavement_district IS NULL
    OR (
        (:is_pavement_district = '1' AND rv_logmile.county_id IN (3, 5, 7, 8, 9, 10, 14, 15, 17, 18, 21, 22, 25, 26, 27, 34, 38, 45))
        OR (:is_pavement_district = '2' AND rv_logmile.county_id IN (2, 6, 13, 16, 28, 29, 31, 32, 35, 40, 43))
        OR (:is_pavement_district = '3' AND rv_logmile.county_id IN (1, 4, 11, 12, 19, 20, 23, 24, 30, 33, 36, 37, 39, 41, 42, 44, 46))
    )
)

-- County-specific filter
AND (:is_county IS NULL OR rv_logmile.county_id = :is_county)

-- Route Type and Route Specifics
AND (
    :is_rte_type IS NULL
    OR (
        (:is_rte_type = '7' AND (rv_logmile.dom_rte_type_id = 7 OR (rv_logmile.dom_rte_type_id = 9 AND rims.is_sls_lrs2(rv_logmile.dom_rte_lrs) = 1)))
        OR (rv_logmile.dom_rte_type_id = :is_rte_type)
    )
)

-- Additional Criteria for Local and Secondary Routes
AND (
    :is_rte_type IS NOT NULL
    OR (
        rv_logmile.dom_rte_type_id <> 9
        OR (
            rv_logmile.dom_rte_type_id = 9
            AND rv_logmile.dom_rte_nbr IN (
                SELECT dt_rtes.rte_nbr
                FROM dt_rtes
                WHERE dt_rtes.rte_type_id = 7
                AND rv_logmile.dom_rte_nbr = dt_rtes.rte_nbr
                AND rv_logmile.county_id = dt_rtes.county_id
                AND rv_logmile.dom_rte_aux_id = dt_rtes.rte_aux_id
                AND rv_logmile.dom_rte_dir = dt_rtes.rte_dir
                AND dt_rtes.rte_bmp <> (SELECT dt_rtes.rte_bmp FROM dt_rtes WHERE dt_rtes.route_lrs = rv_logmile.dom_rte_lrs)
            )
        )
    )
)

-- Route Number and Auxiliary ID
AND (:is_rte_nbr IS NULL OR rv_logmile.dom_rte_nbr = :is_rte_nbr)
AND (:is_rte_aux IS NULL OR rv_logmile.dom_rte_aux_id = :is_rte_aux)

-- Exclude Proposed, Summary, Private Roads, and Rail Crossing Routes
AND rv_logmile.dom_rte_aux_id NOT IN (1, 9)
AND rv_logmile.dom_rte_type_id NOT IN (15, 16)
)

Mileage Totals by System (D760010)

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ((LURouteTypeID = 1 AND @Include_Interstate = 1) 
        OR ((LURouteTypeID = 2 OR LURouteTypeID = 4) AND @Include_Primary = 1)
        OR (LURouteTypeID = 7 AND @Include_Secondary = 1)
        OR (LURouteTypeID = 9 AND @Include_Local = 1)
        OR (LURouteTypeID IN (10, 11, 12, 13) AND @Include_Other = 1)) AND
        A.LUCountyID != 0 AND
        A.LUCountyID != 47 AND
        LURouteAuxID != 9 AND
        (A.Fed_Owner_ID IS NULL OR A.Fed_Owner_ID NOT IN (3,10)) AND
  A.F_System IS NOT NULL
)

National Highway System Mileage

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE (LURouteTypeID IN ( 1,2,4,7,9,10,11,12,13 ))
		  AND O.LUCountyID <> 47 
		  AND (O.Fed_Owner_ID IS NULL OR O.Fed_Owner_ID NOT IN(3,10))
) A

NHS Fact Sheet

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

			 AND (NHS > 0)
			  AND LURouteTypeID NOT IN(15,16)
			AND ( O.Fed_Owner_ID is null or O.Fed_Owner_ID not in (3,10))
) a

NOTES Report (.NET)

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

         (O.F_System > 0) AND  
         ( O.LURouteAuxID <> 9 ) AND  
         O.LUCountyID <> 47
		 AND ( O.Fed_Owner_ID IS NULL OR O.Fed_Owner_ID NOT IN (3,10) )
)

OSOW Bridge Report

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ((Q_COUNTY_ID = NULL AND Q_SUB_RTE_TYPE_ID = NULL AND Q_SUB_RTE_NBR = NULL 
AND Q_SUB_RTE_AUX_ID = NULL) OR (Q_COUNTY_IDU = NULL AND Q_SUB_RTE_TYPE_IDU = NULL 
AND Q_SUB_RTE_NBRU = NULL AND Q_SUB_RTE_AUX_IDU = NULL)) AND (NBI_041 <> 'G' AND IS_INACTIVE = 0)

Paved and Unpaved Public Road Miles (EZRIEAR1)

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

Runtime WHERE Clause
WHERE (LURouteTypeID NOT IN (5, 6, 14, 15, 16))  
		AND LURouteAuxID <> 9
		AND O.LUCountyID <> 47 
		AND (O.Fed_Owner_ID IS NULL OR O.Fed_Owner_ID NOT IN(3,10))
) A

Photolog Completeness Report

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE county_id=q.county_id) as county
	,(select route_type from ct_rte_types where rte_type_id=q.rte_type_id) as route_type
	,(select route_aux from ct_rte_aux_ids where rte_aux_id=q.rte_aux_id) as route_aux
	,year as dyear
	,route
from
(
  SELECT RPT_ID
         ,DOM_RTE_LRS
         ,VIEW_DIR
         ,BMP
         ,EMP
         ,LENGTH
         ,IMG_CNT
         ,MSG_FLG
         ,to_number( substr( dom_rte_lrs, 1, 2 ) ) as county_id
         ,to_number( substr( dom_rte_lrs, 3, 2 ) ) as rte_type_id
         ,to_number( substr( dom_rte_lrs, 5, 5 ) ) as rte_nbr
         ,to_number( substr( dom_rte_lrs, 10, 2 ) ) as rte_aux_id
		,year
		,substr( dom_rte_lrs, 3, 10 ) as route
    FROM si_photolog_completeness
    where rpt_id=:al_rpt_id
) q

Public Summary - CL Miles by MPO / System

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE A.S_Area_ID IS NOT NULL AND
        A.LURouteTypeID IN (1,2,4,7,9,10,11,12,13) AND
        A.LURouteAuxID != 9 AND
        (A.Fed_Owner_ID IS NULL OR A.Fed_Owner_ID NOT IN (3,10)) AND
  F_System IS NOT NULL
)

Public Summary - DVMT by MPO / System

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE A.S_Area_ID IS NOT NULL AND
        A.LURouteTypeID IN (1,2,4,7,9,10,11,12,13) AND
        A.LURouteAuxID != 9 AND
        (A.Fed_Owner_ID IS NULL OR A.Fed_Owner_ID NOT IN (3,10)) AND
  F_System IS NOT NULL
)

Roundabout Listing

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

where rab_id is not null

Route Mod Report for Photolog Images

Overlay: RIMS Standard Reports Data Source (Overlay Table): Overlay103412122022131957

WHERE MOD_TIME >= TO_DATE('08/04/2025', 'MM/dd/yyyy') 
and MOD_TIME <= TO_DATE('08/04/2026', 'MM/dd/yyyy')

S/L/S Report

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE sec.rte_type_id = 7 AND
        sec.is_dir_of_chg = 1 AND
        loc.rte_type_id = 9 AND
        loc.is_dir_of_chg = 1 AND
        (
            1 = 1 OR (1 = 2 AND sec.county_id = NULL)
        )
)

State – Urban and Rural Lane Miles and AVMT by County

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID IN( 1,2,4,7) ) AND
			( O.LURouteAuxID <> 9 )
			AND O.LUCountyID <> 47

State System Road Miles (Huley)

Overlay: RIMS Standard Reports Data Source (Overlay Table): Overlay103412122022131957

WHERE A.LURouteTypeID IN (1,2,4,7) AND
        A.LURouteAuxID != 9 AND
        A.LUCountyID != 47 AND
  A.F_System IS NOT NULL
)

State System Road Miles By District, By County

Overlay: RIMS Standard Reports Data Source (Overlay Table): Overlay103412122022131957

WHERE A.LURouteTypeID IN (1,2,4,7) AND
        A.LURouteAuxID != 9 AND
        A.LUCountyID != 47 AND
  A.F_System IS NOT NULL
)

State System Summary Reports

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE O.LURouteTypeID in ( 1,2,4, 7 )
and O.LURouteAuxID not in (1,9)

Structure Inventory and Appraisal Report (recheck)

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE --WHERE nbi_008 = '0240001900100' 
      AND Q_IS_DOM = 1 and Q_IS_DOMU = 1 and Q_IS_DOM_HMMS = 1 and Q_IS_DOMU_HMMS = 1) 

Total Public Lane Miles by Functional Class

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID in ( 1,2,4,7,9,10,11,12,13 ) ) AND  
         (O.F_System > 0) AND  
         ( O.LURouteAuxID <> 9 ) AND  
         O.LUCountyID <> 47
		 AND ( O.Fed_Owner_ID IS NULL OR O.Fed_Owner_ID NOT IN (3,10) )
) 

Total Public Mileage by Functional Class

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID in ( 1,2,4,7,9,10,11,12,13 ) ) AND  
         ( O.F_System > 0) AND  
         ( O.LURouteAuxID <> 9 ) AND  
         ( O.LUCountyID <> 47 ) AND 
		 ( O.Fed_Owner_ID IS NULL OR O.Fed_Owner_ID NOT IN (3,10) )
)

Total Public Road Mileage VMT by Functional Class

• Overlay: RIMS Standard Reports
• Data Source (Overlay Table): Overlay103412122022131957

WHERE ( O.LURouteTypeID in ( 1,2,4,7,9,10,11,12,13 ) ) AND  
		(O.F_System > 0) AND  
		(O.LURouteAuxID <> 9) AND  
		(O.LUCountyID <> 47) AND
		( O.Fed_Owner_ID IS NULL OR O.Fed_Owner_ID NOT IN (3,10) )		
)