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)

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)

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)

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

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)

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

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)

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

Corridor Fact Sheet

This report contains no WHERE clause

DVMT / AVMT Inventory Reports

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

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

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

Federal Aid Breakdown by Lanemiles

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

Federal Aid Eligibility

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

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

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

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

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

Interchange Report

WHERE DT_COUNTIES.DISTRICT_ID = :DistrictID

Interstate Mileage Report

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

Interstate Mileage, VMT and DVMT by Route (EZRIVM8Y)

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

Log Mile

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)

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

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

			 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)

         (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

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)

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

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

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

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

where rab_id is not null

Route Mod Report for Photolog Images

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

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

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

State System Road Miles (Huley)

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

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

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

Structure Inventory and Appraisal Report

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

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

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

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) )		
)