Location: BlogsHEEP Agency ReportsArea II
Posted by: rjrobinson@dot.state.nc.us	5/25/2007
Current and Proposed Organizational Activities A. Developing Applications for New Technology – The department has undertaken an effort to upgrade several of its applications to use Oracle 9i drivers. This involves several different systems throughout the department and requires a coordination of efforts among different project leaders. We hope to have all systems upgraded to use Oracle 9i drivers on the client machines by the end of 2007. B. Organization Change – The SiteManager Implementation project was officially moved under the GIS/Engineering Support group within Computer Services and a new project manager was appointed. New Systems (Just Completed, In Progress, or Preparing to Start) A. SiteManager Implementation – Implementation efforts continue with implementation of Estimate Approvals, Change Orders, and the Materials and Tests module being the most recent roll-outs. Integration with the accounting system will be the next major implementation and we hope to accomplish this by the end of 2007. B. ALDOT Transit Reporting System (ATRS) – The Transportation Reporting System program allows agencies who receive federal funds through Section 5309, 5310, and 5311 grants to file forms online. The program will automate the process of filing seven reports that are required by the FHWA: 1. 5310/5309 Quarterly Report 2. 5310/5309 Annual Operating Report 3. 5310/5309 Annual Monitoring Report 4. 5310 Purchased Transportation Quarterly Report 5. 5310 Purchased Transportation Annual Operating Report 6. 5311 Quarterly Report 7. 5311 Semi-Annual DBE Report If the project is successful it may be expanded to include more public transportation reports. C. Alabama Transportation Reporting Information System (ALTRIS) – The purpose of this application is to provide a simple  tool that can be used by Transportation Planning Analysts and/or high level Engineers to analyze transportation data on-the-fly and generate maps based on specific criteria to be used in decision making and decision support. Version 1 was released in 2005. Further requirements are being driven by a recent initiative to produce a new statewide plan. D. DBE Application Tracking – Added additional functionality to the DBE section of CPMS to allow for tracking of applications and training scheduled for DBE companies. This will not only provide a better means by which to ensure applications are processed within the allowed timeframe but will also eliminate a good deal of manual reporting that was being done. E. TransView – TransView is a Transportation oriented GIS application which provides users with a  map display of  ALDOT’s State maintained Roads,  Bridges, County Boundaries with Auto-Loading OrthoPhoto backdrops. The application also includes ‘Player’ functionality to give the user the ability to Drive-On routes via use of the Photologs, Drive-Over routes via the OrthoPhotos,  and the ability to run financial reports on projects.  The application implants the concept of a workspace, display-by-scale, and symbology editing. F. Web Development – 1. Intelligent Transportation System (ITS) – A public web site was created and streaming video from traffic cameras in Birmingham was added to the web site. (http://www.dot.state.al.us/Bureau/Design/ITS/PublicITS/CameraList.aspx) Additional cameras are being added currently in Birmingham. Cameras from the city of Mobile are expected to be online early June. Collaboration with the cities of Tuscaloosa and Montgomery are taking place now, and cameras from those locations expected to be published within the next year. Development of a private web site providing unrestricted access to camera views is currently being developed. The site is being developed for first responders, traffic management, and emergency dispatch entities. 2. Traffic Polling Data System – (http://aldotgis.dot.state.al.us/traffic_counts/) The Traffic Polling Data System allows users to view hourly traffic volumes for traffic counters throughout the state. Additional efforts have been made to publish hourly counts from permanent traffic counter locations daily via automated collection systems. It is hoped for the future that this automated collection system will be able to publish real time traffic counts during times of emergency. 3. Approved Materials Site –Web site that allows internal users to select a particular material and retrieve details such as the approved manufacturer, approval effective date, and approval expiration date. 4. Materials FlowThru Site – Currently developing a web site that will allow employees of a producer and batch plant inspectors to log in and enter testing data currently tracked via paper forms. K. County Roads Project – This effort entails importing all 67 County Base Roads from MicroStation (CAD) Design files into a GIS layer, attributing the road features, and realigning the road geometry via High-Resolution OrthoPhotos.  L. Sinkhole Project – Transfer data from hard copy drawings into electronic files that can be geocoded. (This is very labor intensive and requires a high degree of manual effort. This project is currently on hold due to resource constraints.) M. Imagery – This project entails copying, viewing, and providing quality control of the file-based Orthophotos that ALDOT’s Location Section receives from the Counties. The OrthoPhotos are utilized to re-align roads, and are the Auto-Loaded backdrops used by the TransView application for its Drive-Over functionality. N. Lanes Data – Creating geocoded (segmented, attributed, and realigned) database records indicating the number of lanes on segments of the road state network. This is very labor intensive and requires a high degree of manual effort. O. Mobility (ArcPad) – Trained HPMS employees on how to use ArcPad and created ArcPad maps for them to use to collect data in the field. P. Training – Conducted Seven Introduction to ArcGIS in-house training sessions. Q. Oracle Database Instrumentation – Built a system for monitoring certain aspects of Oracle databases through the Microsoft Operations Manager system. The current version of instrumentation will track the number of connected users and machines for any Oracle database, and will also monitor tablespace size and connectivity for the Oracle GIS16 database. R. Centerlines – Aligning, segmenting, attributing, and updating mileposts on centerline maps of the ALDOT road state network with aerial photography and GPS coordinates to improve location accuracy. This is very labor intensive and requires a high degree of manual effort. S. Disaster Recovery – Worked in conjunction with the Computer Services Operations Disaster Recovery team to determine hardware and software necessary to implement a disaster recovery center capable of housing the data stored within the GIS/ES 30 TB Storage Area Network (SAN). T. Bridge Document Retrieval System – A system for the Bridge Maintenance Bureau to retrieve documents from the document management system using a map interface. Users will be able to select a bridge from a map and view a list of documents related to the bridge. The user can then select the documents that they are interested in and download the documents to their computer. U. Dgn2data CAD Data Harvester Program – Enables the extraction, transformation, and loading of data from MicroStation design (dgn) files into an ArcGIS geodatabase.  Each input dgn file produces as output an ESRI shapefile containing a point, line, or polygon feature dataset.  Multiple input dgn files produce multiple shapefiles, which can then be incorporated into the geodatabase. A unique feature of Dgn2data is the ability to capture textual attribute data along with the graphical feature set.  The attribute search algorithm is based on the GIS technique of a proximity buffer.  The attribute capture saves many hours of manual data entry and reduces data entry errors. V. Nightly Roadway Inventory Data Processing – Automated nightly data processing system developed to update road state network on a daily basis. W. BatchTools Program – BatchTools provides the ability to perform several MicroStation design (dgn) file administrative functions in batch mode.  The input is a folder of dgn files.  The functions that can be performed on each dgn file are:  1) set working unit labels; 2) set working unit ratios for master units, sub units, and positional units; 3) set global origin; and 4) transform from 2D to 3D. X. ROWStatus Program – Provides the ability to share Right of Way (ROW) tract acquisition status between various bureaus within the department, such Right of Way, Design, and Construction.  ROW projects can be search and located in the context of a statewide map and roadway network.  Acquisition status is easily visualized through color coding.  Tracts and parcels can be viewed against a background of the latest aerial photography for the project area.  Projects can be sorted and displayed by linear feet of contiguous acquired right of way, acquired acreage, funding type, or various other project criteria.  This program is in the prototype development phase Y. Dynamic Segmentation Event Table Generation Programs - These integrated program sets generate event tables for many Road entities such as Lane Counts, AADT intervals, Shoulder Width, Functional Class, Lane Width, etc. They were used by ALDOT to provide the subcontractor Day-Wilburn with the data they require to perform Needs Analysis Studies. Z. GIS Analyses/Data Creation-Acquisition/Map Production –  Five Year Bridge Plan ABIMS Bridge Scour Data Analyses and Map Production Rest Area/Welcome Center Map Production http://www.dot.state.al.us/NR/rdonlyres/453675EC-87EF-490C-8F0D-75FED49D9DB2/0/Alabama_WelcomeCenters_RestAreas_20061016.pdf  CORS/GCP/Leveling/Height Modernization Map Production Bridge Coordinate/LRS Analyses/Map Production Statewide by County and Division Hurricane Evacuation Route GIS Layer Creation and Map Production nterstate Management Program Analysis, Map Production, and GeoPDF Milepost Analysis and Data Creation Southeast US Map and Data Layer creation for the National Geodetic Survey Railroad GIS Data Layer Correction Support and Management FY06 and FY07 Resurfacing Program Data Analysis and Map Production Shoulder Type Data Analysis and Map Production New Statewide National Hydrography Dataset acquisition and State-wide data layer creation  IRI Data Analyses and Map Production Quarterly Construction Brochure Map Production Milepost Map DGN conversion to ArcGIS by County  Map Productions for Governor’s Declarations related to Hurricane Recovery http://www.dot.state.al.us/NR/rdonlyres/381C3EBB-8ED8-4B32-840C-1F1DD3B27FEF/0/GovernorsDeclarationKatrinaCleanupNorth.pdf http://www.dot.state.al.us/NR/rdonlyres/986894CC-4DEE-4495-9BE0-F8A5D80F56CF/0/GovernorsDeclarationKatrinaCleanupSouth.pdf Division 5 Construction Project Map Prodution Southeast AL Contracts Map Production Alabama Transportation Networks Map Production ABIMS Analyses and Internal and Public Map Productions for the Maintenance Bureau’s Permitting Office and ArcReader pmf deployment http://www.dot.state.al.us/NR/rdonlyres/BF10EC09-6BF5-4258-8368-1B1DCC8A3556/0/PermitDesignLoadMap02.pdf Vertical Clearance Bridge Analyses and Data Layer Creation Election Results for Auburn University Map Prodution for Trucking Bill – 2006 AL Legislature Corridor X, West Alabama Freeway, other new/proposed project Map Production Bayou La Batre Map for ADECA Bridge Analyses for Automated Permitting System/Bellfus Cities with Population Above 19,000 Map Production Opening Ceremony Maps T-Shirt Map Design HBCU HTML and Map Production Interactive AL Senate Map Production I-65 ContraFlow Staffing GeoPDF Map Traffic Fatality Statewide Data Analyses and Map Production GIS Layer Acquisition and/or Creation for ALDOT/Enterprise GeoDB and other        Local/State/Federal Agencies:        Interstate Exits, Rest Areas, ALDOT Division/District Offices,       USTs/LUSTs/Corrective Actions, Heavy Load Haulers, Steel Fabrication Facilities, Aggregate Material/Mining Sources, Hurricane Evacuation Shelters, USDA NAIP Photo Acquisitions, Major Tourism Destinations, Airports, USGS DRGs, Power Generation Facilities, Mobile Home Manufacturers, Paper Mills, Crane Suppliers, Aviation/Auto Manufacturers, Landfills, Coastal Points, Major Creeks NHD derivative GIS Layer, State Forests, Some Federal Lands (i.e. NPS Trail of Tears), GNIS Statewide Data, Mayor Data, Sheriff Data, AEMA County Contact Data, Congressional and State Legislative Districts, AL Beverage Control Alcohol Sales County and City layer, Endangered/Threatened/Candidate Species, AL Intelligence Areas, AL DHS Regions, 2 Year/4 Year Colleges, Census Data (Blocks, Block Groups, Tracts, Roads, etc.), Federal Lands, State Wildlife Management Area/Hunting Areas, Township-Range-Section Layer Creation, HAZUS data, NED, §303d Layer, Gulf of Mexico Shoreline, Dams, USGS Cataloging Units, USDA-NRCS Subwatersheds, NHD by County, Mining/Stormwater Permits via ADEM, USGS Gaging Stations, Latitude- Longitude TICs, 24K-100K-250K DRG and DOQQ Reference Indexes, AL Telephone Area Codes, Ecoregions, Physiographic Provinces, Land Use-Land Cover, Geology, STATSGO/SURGO Soils, Bus Stations, NWI data, ABIMS Structure Missing Models, County Fishing Lakes, Scenic Drives, Coastal/Inland Ports, OAW-ONRW Water Classifications/Designations, Trooper Posts/Field Offices, Red Cross Chapters/Service Areas, etc., AA. Link-Node dgn to GIS Proposed Conversion BB. GIS Staff Participation: Alabama URISA Chapter Board of Directors, Troy/Auburn Univ. GIS Symposium Coordinating Committee, State Agency GIS MOA CC. ALDOT-wide as well as Local/State/Federal Agency Support for ArcGIS, Data Creation/Sharing, Tools, Integration, Planning, Analyses, and Map Production
Permalink |  Trackback