Road and Street Record G

The Road/Street record also integrates ALL Fixed Assets you manage, as all fixed assets have an address that is over, under, within the right-of-way or adjacent to a given road, street or segment of a road or street.

 

The TABs: Culverts, Signs, Bridges, Other Assets group those assets.   The Costs TAB shows costs in any Fiscal Year and the Graph It TAB displays a time series graph of the fiscal year costs to maintain the road surface and right of ways - exclusive of the specific maintenance and inspections costs on each discrete Culvert, Sign, Bridge or Other Asset.   GIS lookups to Google® (maps, satellite, terrain and street level - when available) are automatic - all you need is an internet connection.

 

The Update Road/Streets form enables you to edit and add information on the Roads/Streets under your jurisdiction.    

After entering a Road/Street segment you should synchronize (edit GIS dataset for exact spelling and punctuation) the GIS database with the new Road/Street segment.   The GIS dataset contains many thousand records which identify all 21 data layer records in your City or County; i.e., Highways, Roads, Streets, Rivers, Streams, etc.   The records you enter or edit in the Road/Street Profiles database are only those Roads/Streets that you maintain, ergo, the need for a separate database for more detail on the subset of Roads/Streets you maintain.   The process of synchronizing guarantees that when a cost record is charged against a GIS Road/Street it is also properly identified by the Road/Street Profile database; i.e., spelling and upper/lower case need to be the same.

Clicking on the Culverts, Signs or   Bridges TABs will enable you to drill down to a particular asset and its summary Cost and Maintenance history.   The Cost History TAB maintains a current Cost and Maintenance history on each segment of Road/Street.

How to utilize this DataSet?

Enter a record with correct Road/Street (segment) name.   You can add other field information when available; i.e, road segment is From and To what locations and the Road Segment ID and/or Posted, Commissioner, average daily traffic (ADT), etc.   When record is saved it links with any Bridges, Culverts and Signs that are on this particular Road/Street (segment).     To add or change Bridge, Culvert, Sign or other information go to that record in appropriate database.   This module will enable you to find all assets located on any Road/Street segment AND see current spending and maintenance history on each asset.   This data is transparently maintained by R&B IMS once you make linkages.

The structure of this data lookup enables you to see all assets located on any particular Road or Street in your City or County and see current cost analysis and maintenance history on that particular asset.   This structure provides:

Road/Street Segment with Cost/Maintenance History

        -   Bridges with Cost/Maintenance History

        -   Culverts with Cost/Maintenance History

        -   Signs with Cost Maintenance History

The Graph It TAB (initially) brings up the total historical costs (by date) to show amount and frequency of costs incurred on the road/street.   To see an asset (bridge, culvert, sign or other asset) enter the identification number for that asset and click the Gen Graph button.

A time series graph can display maintenance cost trends; i.e., a continually rising graph could indicate the particular asset is deteriorating or is in need of other maintenance procedures, which could range to replacement of that asset.

The GIS TAB and Google It button enable you to “see” your asset via Google Earth® (if you have a live internet connection).   Whatever asset you have previously looked at (for instance, click on Sign TAB and highlight a particular sign) – then click GIS and Google It button.   If you have the latitude and longitude loaded in the Sign record you will see its location on the map with latitude and longitude displayed.   If you do not have the latitude and longitude it will default to the basic map and you can determine the latitude and longitude for that particular sign.   First, install the “getLatLongPlus” utility by clicking the My Maps TAB in Google Earth®, then Browse the Directory.   If you haven’t signed up with Google a free sign up is provided – then you will be able to access utilities.    

There are many free utilities (measure land area, elevation contours, etc. – be sure to get the “getLatLongPlus” utility.   Click anywhere on the map for the Latitude/Longitude point where the sign (or other asset) is located.   When you click the Lat/Long is displayed in the lower left window – highlight the entire latitude and longitude, right click mouse and copy it.

Click on the Sign TAB and open the highlighted sign record – Click the Google® Lat/Lng button which loads the previously copied latitude and longitude in the record.   The next time you access this record you will see it on Google®, either the basic road map, Satellite or Hybrid (satellite with road names).  

The latitude and longitude you load in the record also works with our built-in GIS, ESRI® ArcGIS Explorer (free) or nearly all other GIS platforms.   If you’ve downloaded Google Earth® it has additional functionality – and it is also free.