1 / 37

ABOUT US

ABOUT US. EVOLUTION OF A PLANT GIS SYSTEM… FROM POLE CARDS TO FULL AUTOMATION. Presented by Karl Rozentals E&O Conference, 2004. We got trouble. Right here in River City. Like many utilities, Waunakee needed to know a lot more about their plant.

brigit
Download Presentation

ABOUT US

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ABOUT US EVOLUTION OF A PLANT GIS SYSTEM… FROM POLE CARDS TO FULL AUTOMATION Presented by Karl Rozentals E&O Conference, 2004

  2. We got trouble. Right here in River City. Like many utilities, Waunakee needed to know a lot more about their plant. Most of the information was there, it just wasn’t useful...

  3. We clicked on this hand-drawn map until the mouse fell apart. No data ever came out of it.

  4. Stapling thousands of pole cards to the map didn’t work, either.

  5. We decided the only way to digitize the plant was to do it right. That meant... A Field Inventory

  6. Before we went in the field, we helped them establish construction standards. • This provided a relationship between: • Units in the field • Assemblies • Sub-assemblies • Stock

  7. We equipped our field personnel with precision GPS receivers. The receivers were connected to data recorders. The data recorders were pre-loaded with the construction standards.

  8. The plant data, along with the GPS locations, was transmitted to our home office every night. Our digital cartography specialists applied post-processing tools, which increased the GPS accuracy to around 50cm. Then, the fun started.

  9. We used the field data to build a database. Then, we used the database to build a map.

  10. FIELD INVENTORY Field Inventory Stages GPS Location and Plant Data Collection Deliver Finished Plant Map and Database Software at our facility automatically creates the plant map from field data Map Edit and Data Quality Control Inspection and Acceptance

  11. By using the database to drive the map. The customer can use different graphic platforms to view the plant. And data can be shared with multiple applications.

  12. Speaking of applications, we felt they needed some. First, we gave them a GIS system...

  13. SQL*CAD Our SQL*CAD GIS application

  14. This application uses AutoDesk Map as the graphic engine, and gives the user a graphical interface to the database.

  15. SQL*CAD We provided a group of menus and toolbars to make plant entry and modification simple.

  16. SQL*CAD We provide a series of ready-to-use plant mapping elements We provided an easy way to insert unit symbols.

  17. SQL*CAD And some forms for updating the database

  18. SQL*CAD Engineering Data Export Then, we came up with an easy way to extract engineering data The data can then be manipulated in any desired manner, or even shared with applications that lack a database interface.

  19. The next thing they needed was a way to manage work orders from start to finish.

  20. SQL*CAD Changes to the plant can be drawn, along with notes for the line crew. Material requirements are determined as the changes are being drawn.

  21. UMS-II Projected costs are tracked throughout job planning. By Summary By Pole/Station By GL Account By Unit By Equipment By Direct Costs

  22. SQL*CAD With just a few more easy steps, the plant map is transformed... Work Order New Plant Original Plant

  23. UMS-II Once a work order is complete, the system updates the plant CPR records, and can provide an audit trail of the job for the accounting department.

  24. The next thing they needed was a non-graphical application for handling material transactions, purchasing, and CPR ledger updates. The material control needed to be fully integrated with the work order activity generated by the SQL*CAD system. Our UMS-II system was the best choice.

  25. UMS-II Stock Adjustments Material MGT Transactions Work Order Transactions Use a Requisition ? yes Edit Requisition Approve Requisition Create Requisition Low Stock Report no Use an RFQ ? no Create Purchase Order yes Edit Purchase Order Review Vendor Responses Create RFQ The purchasing and materials modules provide a complete, closed-loop material control system. Approve Purchase Order Process Invoice And Show Goods in Stock Receive Stock Against Packing Slip Release Purchase Order

  26. UMS-II We made sure they could generate a lot of reports.

  27. FIELD INVENTORY Benefits It all comes down to this: If plant data is in a comprehensive database, and linked to an accurate plant map, things happen faster. If staking engineers need to change equipment at a large number of locations, there is no need to locate, update, and replace the pole cards for each station. Line crews can go to a job site with correct materials and equipment, and can locate work more easily. Planned outages can be traced instantly. After work is completed in the field, the plant map and database can be brought up to date automatically. Accounting personnel can have the CPR ledger updated with no need to research each job. Engineering personnel can analyze plant conditions in far less time.

  28. FIELD INVENTORY When things happen faster, they cost less. We recently asked a client utility to track the hours spent on certain tasks during the year after a field inventory. They compared these times to the time spent on similar tasks prior to the field inventory. What they learned was amazing…

  29. FIELD INVENTORY They analyzed the cost of the reduced hours for various operations and procedures; and compared then to the overall cost of the field inventory – $100,000 in this case. Their savings – listed as a percentage of the field inventory cost – are listed below: Saving for crews and staking dept. by using up to date maps and data……...….25.5% Work order and maintenance efficiency by utility………………………………25.5% Work order closing and CPR’s entries by office personnel………..…………...25.5% Job layout and estimates……………………………………………………………7% Correct framing, quantities, planning ……………………………………….……14% In other words…

  30. FIELD INVENTORY 97.5% COST RECOVERY IN ONE YEAR

  31. The Future (It’s already here.)

  32. Times change. Utility plants change. Software changes. But because the client’s plant data is stored in an open database environment, they will be ready for anything...

  33. AUTODESK OR ESRI? Sharing data with other GIS products. ESRI Brand X Viewer AutoCAD Map

  34. MULTISPEAK IERFACE Sharing data with non-GIS software. Web-friendly MultiSpeak tables Third-party application on different database platform SQL*CAD data in Access

  35. And mobile computing...

  36. R&R Sy-TEC, inc. 1015 Walnut PO Box 696 The Dalles, OR 97058 541-298-6035 fax 541-298-4456 randr@rrsytec.com www.rrsytec.com

More Related