Empower Your Planning with Pipeline Tracking Spreadsheet for Planning

How to create outlook signature

hi I'm Krista Kimball thank you for joining us today for pipeline inspection management and planning for the city of Monrovia before we get started I would like to encourage you to post your questions we will have time at the end of the webinar to answer some of them the questions that we don't get to will be included in our Q&A document that will be posted on jeona after the webinar this webinar is being recorded and will be posted on jeona and Meetup you will receive a follow-up email with a link to the recording location we have a great lineup for you today david Totman Ezra's water industry manager will start the webinar with a discussion about sewer system management joining David is Corey Chris and Eric Brighton from IT pipes as well as special guests Jeff burns from Merrill Johnson Cory and Eric along with Jeff are going to share their story challenges and accomplishments surrounding the implementation of a pipeline inspection management plan for the city of Monrovia I hope you enjoy the webinar we're gonna let David kick us off David okay yeah thanks Krista just wanted to cover a couple of topics up front here as Kristen mentioned you know talk a little bit about sewer system management plans here in the state of California and as it applies to the rest of the country also a bit about pipeline inspection management in general then as Krista said we're going to turn it over to Cori and Jeff to talk about the project there at the city of Mountain Rovia California and so to start off with sewer system management plans here the California State Water Resources Control Board offer of many excellent resources for water organizations in the state of California as you can see by their website here they cover you know drinking water water quality water rights organizations but in in their programs you know they offer resources best practices and one of these is you know their sewer system management plans and really all these SS MPs are or you know good sound asset management plants and and you'll hear more about that as the reason the city of Monrovia tackled this particular project but it comes down to you know very simple goals of SSM P one is to perform you know a system condition assessment and as we kind of know in the CCTV world it starts with the CCTV inspection the raw data observations that allow you to make the condition assessment based on some standards that you are applying one of the reasons for doing this condition assessment is to check the structural integrity of the system and ultimately there you're hoping to minimize the inflow and infiltration because no one wants to unnecessarily treat all this natural water that is entered into your sanitary sewer system it's just you know kind of this excess capacity issue therefore you know treating water unnecessarily so minimizing I&I is one of the one of the goals really ultimately it's minimizing the sanitary sewer overflows those that are under consent decrees know about SSOs definitely and that's the goal of any system is to of course minimize any release from there sanitary sewer system so really again these SS MPs are basically these asset management plans that just say you know manage your system appropriately with respect to pipeline inspection management we actually held a a previous meetup back in August of 2016 on inspection management and you know I encourage you to go to that recording back in August to take a look at that and there again we also had IT pipes and they've since made lots of improvements to their software solution but back then in August you know we talked about kind of just data management in general how CCTV you you need a very comprehensive data management plan because you bring in now all this video and lots of at terabytes of information so data management plays a key role in basically an overall pipeline inspection management program and the asset management comes into play with these asset IDs because in CCTV you're basically inspecting these assets with observations but you need to hang the observations on to a particular asset and most of us in the sanitary sewer world an asset ID is basically between from one man hole to another man hole so but we all know that can be multiple pipe segments that the CCTV records observation and against but one thing about CCTV it's its truth right you have a camera in the pipe you know actually what's going on so many times many of us converted our sanitary sewer system into the GIS from aerial maps we may have sprayed the manholes and an area of photography and done conversion by connecting the dots well sure enough you know CCTV shows us the truth we find extra manholes that were buried underground and never captured and we also you know expect to find a manhole where there isn't one we may have erroneously flagged you know a telco manhole or something thought was sanitary sewer so you know you have to be kind of willing and flexible to move your asset IDs around that that comes into what are your split rules and things of that nature so you know CCTV really helps you get a handle on getting more accurate asset IDs when it comes to the actual condition inspection then you know these inspection standards come into play back in August we talked about NASSCO and of course the PACP but there's also other international standards and so IT pipes is one of those that supports multiple standards so again I encourage you to go back to August 2016 look at the recording on on some of the basics that we covered on data management and asset management and inspection standards from that and what you'll see today it's it's my belief that CCTV is definitely pushes the envelope on data structures data storage data standards and data sharing and with respect to data structures basically mean you know what sort of attributes are you collecting different software packages expect different attributes different standards request different attributes comes down to what is your SS MP expecting what do you you know need to understand about your sanitary sewer system should drive your data model or these data structures CCTV definitely pushes the envelope on data storage we talked about the video terabytes of video depending upon the size of your system and do you want to store that on hard drives you know on premise or do you want to turn to the cloud I think many are turning to the cloud because of the the scalability of data storage and and today's speeds on the internet providers you know are making it very very performance acceptable as well and so you know again the data storage CCTV definitely lends itself to cloud storage with respect to data standards in qa/qc those really kind of go hand-in-hand because we're trying to make sure we have accurately recorded video because we all know mobilizing to collect the data is a significant effort we don't want to have to go back to that pipe over and over again you know and recollect data because of like say fog that blocked the video those sorts of things but but even then you know we have to have those observations recorded accurately and consistently so we can have that apples to apples comparison and so that data definitely comes into play with you know having your crews certified and and up to speed on a given standard that your camera equipment supports that that your software solution supports that all that coming into play but what we're starting to see more and more too is CCTV pushing the envelope on data sharing one because of the use of contractors you know many of us don't have the bandwidth to be able to do all the CCTV work in-house especially with the some of the aggressive timelines that others that are facing regulatory challenges are you know they have to meet this this timeline and so we're finding you know third-party contractors being brought in and they may have different camera systems different software solutions so having a platform solution that allows you to integrate and share all of this data on a common platforms is very attractive and then I think that you're gonna see that a little conversation I think about though kind of the the right system for the right job and data granularity what this picture here kind of represents is in a CCTV collection if this were a sanitary sewer main say a gravity main you know on the left assume there's a manhole on the right assume there's a manhole so between these two manholes I have multiple sections of pipe and I might even encounter you know the blue is vcp and the orange may have been a PVC point repair with a couple sticks of PVC this is what I would see in a CCTV system every observation every change in the pipe is observed and recorded and is a very high granularity data recording but again it's still between the two manholes so every segment should share at the same asset ID as I kind of roll that up into the GIS there's no reason to really record every single fitting you can of course in the GIS but typically what you're looking for in the GIS is you know material changes so you know I know that from the left hand mine hole over some some clay pipe and then I have that PVC point repair but I just need to know you know the total length of PVC and then I go back into the BCP so again the GIS kind of stores those material properties because that's probably useful for analysis and when I get up to the CMMS or the computerized maintenance management system others will call it work order systems asset management systems really I just need the one asset ID and so CMMS goes from a manhole to a manhole with one ID the GIS same ID but you know records material change and then of course in the CCTV the same asset ID but I record every single observation every change in pipe every joint and you know I would keep the data in the CCTV system so the moral the story is with an integrated platform the CMMS the GIS and the CCTV can all talk to one another based on the same said ID so again you know use the right system for the right job in this case the right data storage and the structures and and and the ability to share that information out so again I think any of you embarking upon CCTV projects will see the granularity in these different systems and you want a platform that can easily share the information in between these various systems so I just wanted to kind of cover a couple basics on pipeline inspection management point you to our August recording and from there you're going to see some great content you're going to see some very interesting tech and and workflows coming from Cory and Jeff so from that I'd like to turn it over so my name is Jeff burns I'm manager of testing and inspection services from Merrill Johnson companies we provide civil engineering land survey and construction staking construction project managing management excuse me and of course materials testing and inspection services the two main staff working on this project that we're going to talk about today were myself and our lead inspector and project manager Sean best Sean and I have worked on similar projects throughout California and this project has been revolutionary from the technology standpoint as you'll see here in a few minutes so a little about myself I started with Merrill Johnson in 2000 working as a materials laboratory manager I went on to work as a field inspector and am now a general manager for testing inspection services so I have specific experience and testing and inspection for everything from soil concrete asphalt masonry fire proofing and of course Public Works and infrastructure utilities Sean best has been a part of our team since 2007 he joined the team as a field inspector and is now our lead inspector and project manager for field operations and his areas of expertise also include construction materials inspections such as soils concrete masonry structural steel road construction storm drain construction and sewer main construction over the course of the last year and a half he and I had been introduced to IT pipes and had the opportunity to utilize that on city of Monrovia projects and now also for work we're doing for the city of bar still my name is Cory Chris I'm with ITT ice and I've worked with inspection software since 1996 with 20 years experience I've worked with thousands of cities across North America and many of America's largest sewer agencies to develop their inspection program this includes city of La Charlotte water CDC and more I've had the pleasure of working with ESRI products in maps since 2000 and love being a part of this project of the city of Monrovia my name is Eric Greta gyum I am a QA QC technician that specializes in inspection review and client deliverables the extensive pipe inspection qa/qc experience I lead many of the client focused service projects I work primarily with California clients and I am familiar with the various compliance and regulation guidelines while Cori mentioned some of our key larger clients my group's role is working with small to mid-size clients like Monrovia okay well thank you Cory and Eric so now a little bit about the city of Monrovia obviously as an aging City Monrovia was running into infrastructure issues in 2014 the city had commissioned three separate master plans one for water one for sewer and one for streets the goal of this program was to put all three plans together and make repairs as efficiently as possible the city undertook this combined initiative known as Monrovia renewal program this comprehensive infrastructure Improvement Program is aimed at making citywide repairs to water pipelines sewer systems streets and sidewalks the main focus is to replace or repair all water lines production facilities sewer pipe lines and every street with a pavement index over 70 and of course develop and implement an ongoing program to maintain their infrastructure all while creating as little disturbance to the residents of Monrovia as possible the city of Monrovia contracted with Merrill Johnson to manage pipeline inspection for this project Merrill Johnson selected IT pipes for the pipe inspection management app and cloud hosting so today this presentation will review the city's project and plans and how inspections fit into the overall project the info we started with on the project how we organized the project using maps and inspection software how we organized the contractor deliverables how we expedited review of condition assessment inspections how we tracked rehab repair plans for each pipe and how we save time creating bid projects for contract actors on rehab repair of pipelines you can see here some of our goals for the pipeline planning part of this program to quote rod Thornhill from White Rock consultants every pipe needs a plan our goal with this program was not only to set up every pipe with a plan but to set up a system that the city could manage and continue to use when this project is complete so a little more background on the city of Monrovia the city was incorporated in 1887 the population is roughly 37,000 as you can see from the picture Monrovia is literally right in the foothills of the San Gabriel Mountains it operates under the jurisdiction of three different agencies when it comes to wastewater and water systems we're bordered by Arcadia on the West Ward E and Bradbury on the east and LA County on the north and south to give you background on Monrovia sewer system we have 92 miles with fairly small pipe sizes going up into a minimal amount of 18 and 24 inch lines then we have a major trunk line that is County maintained the majority of the system was constructed before 1970 we have one CCTV crew to work with inspections on the entire system that means essentially almost all of our work and definitely all the work on them on row v and renewal project had to be contracted out as you'll see on the next slide the inspection program ties in closely with other repay airs which meant a very aggressive schedule before that we're going to ask Christa to do a quick poll Crysta were you ready for that poll sorry I am ready we're launching it right now you should see the polling question on your screen please take just a second to answer the most appropriate choice do you contract outsource contracting or engineering services yes for our surveying and engineering yes for mapping and GIS services yes for pipeline rehabilitation and repair planning or no you don't contractor outsource contracting it should just take you a second to choose the best answer or all of the above if they apply to you great it looks like some of you are answering you still have a small percentage that hasn't had a chance yet to answer so we'll give you just another second so far appears that a majority of you do contract you're serving and engineering about 25% all right well thank you for answering we're gonna go ahead and close the poll Jeff back to you okay great thanks charissa so as part of the renewal project we had to expedite our plan for inspections maintenance and repairs this map gives you an idea of the street repairs going on in each area in order to be efficient we needed the underground portion of the project done prior to the above-ground street and sidewalk repairs from an ongoing standpoint our guidelines essentially call for cleaning all lines every 18 months hot spots quarterly and inspecting the entire system every five years to give you an idea where we are headed on the repair replacement side we've seen roughly 18% of the lines we've inspected so far show structural needs for this project we broke everything down into renewal phases as you can see on the map here this is the street repairs map and as mentioned all streets with an index over 70 we're going to be repaired this in turn translated into our projects for the sewer system breaking the project into phases based on areas or locations may perfect sense as we physically are going to visit each area to perform on-site work breaking the city up into phases benefited planning and execution of the project as well as review and filtering with an IT pipes web this gives you an idea on our timeline for the pipe inspection portion of the project and the overall project obviously a very aggressive schedule a monrovia renewal project is the largest public works project in the city's history overall this will take four to five years with expected completion in 2020 and a project budget estimated at 51 million from a timeline inspection schedule we're very close to completion on this portion we do expect completion in 2017 of the inspection process even with a couple of challenges we've run into you so speaking of challenges one of the major issues we ran into when starting the project was trying to get data from me bulgy is maps we've been handed to the current Public Works Management at the city this was a compilation of PDF maps inspections and PDFs on flash drives that had limited organization videos on flash drives and no easy way to organize or review the current inspections with the maps we worked with IT pipes to send them all the legacy inspections from the previous contractors work interline engineering when quarry shows you IT pipes web in a couple of minutes you'll see those legacy inspections appear right with the new inspections that we contracted out ITP pipes brought in all the inspection debt detail made the observation codes and grades match the system we set up for Monrovia and check the assets to verify they existed on the map that ended with some cleanup on legacy data but gave us completed inspections that we could start reviewing immediately in regards to verifying assets the original Maps had so many layers and the detail was so small it was often illegible the GIS is our central pipe inventory and it's critical it is correct so in the process of doing this project we've actually obtained the details from the contractor inspections to update the asset records in the GIS we'll talk later briefly about how we can automate that updating of GIS info the project was awarded and the crews had to start working immediately our intention was that most repairs would be done with casts and placed lining and similar products but we knew going into this that that wouldn't be possible for all locations and we would have some open trench repairs we really wanted to make sure we got out ahead of this thing so we didn't have Street repairs being delayed by the open trench repairs the inspections were the first part of moving forward on the overall project as any repairs underground or above ground required the inspection results as mentioned this led to an extremely fast start up and we didn't have time to clarify and document all of the deliverable requirements prior to startup this meant when we started the project IT pipes actually transferred info off the old GIS maps into projects for the contractors this eliminated the contractors having to do a lot of typing and data entry which also helped limit errors once we got the Maps coordinated with the software the process for assigning inspections became much simpler the deliverables from this part of the project required a significant amount of data scrubbing cleanup and review from a QA QC standpoint once we got through some of our major tasks for the project implementation you'll see our requirements for inspections and reporting were defined and from there the project started moving very quickly so as you can see here we identified several major tasks to get the project moving this included basic documentation for deliverable requirements that we could provide to the contractors this would clarify what we expected from them on the inspections this included defining the reporting that we wanted out of the inspections as well we also wanted to streamline how we received the deliverables and review the data in order to generate repair quantities and locations we're going to talk about these tasks briefly now maril Johnson's first major task was to define the SOP and inspection program deliverable requirements looked at several standards and decided to configure a template for Monrovia that was easy to use for inspections and gave specific results on whether repair or rehab or maintenance was necessary here are a few key pages out of Monrovia x' inspection program just to give you an idea what we required this document define the manner in which inspections would be performed the equipment necessary to perform the inspections the proper method for data entry and the deliverable expectations from a time period standpoint I should mention that we wanted results weekly so that we could start moving on repairs and rehab scheduling ASAP as we got weekly data we were calling through that immediately and generating quantities for bid Docs for the repair portion of the work those bids had to be completely assembled and ready to go out within days of completing the CCTV inspection once we had the basic deliverable requirements documented we needed to find a way to start organizing and reviewing the deliverables using maps was critical as the entire project for efficiency reasons was based on location we didn't actually realize how critical this was until one of the inspectors was in the field planning repair one day he'd gone out to do field survey to confirm lining would be accessible for a specific asset on site he could see the defect was near buildings and there may be problems doing the repair with large real mining equipment with the map on the tablet he could see immediately that the defect was located between the two buildings we're still figuring out how we're going to organize repair of this asset we'll show you more on this later but visualizing the defect locations or even just the nearby pipes we were working on was invaluable being able to amend the GIS data already implemented into the template was also invaluable as much of the info we had from the GIS was outdated or inaccurate we're able to update our GIS attribute info regularly from the info gathered during the inspection process eventually we can provide those updates to the city as well anyway having web Maps and inspections together save us hours and hours of time with organizing info finding assets and making decisions as you'll see from some of our reporting the inspection program manual to find the project requirements for deliverables this was key in ensuring clear communication between our inspectors and contractors conducting CCTV as well as contractors conducting repair and post CCTV work as part of the inspection program requirements we decided to have specific fields for reporting you can see the custom fields above that we're defined and the screenshot shows how those fields show up in the condition assessment map this would allow us to do comprehensive drill down reporting on any of the data fields with collaborative Maps which we'll show you in just a moment one item we should discuss on the project is getting the deliverables to us with sync the contractors could plug in their vehicle and inspections could be submitted easily with the click of a button over the Internet this allowed us to begin compiling bid documents immediately for repair projects as I mentioned earlier sync saved ours and just transferring data if inspections needed corrected we would simply reject the data and the contractor could resubmit again without shuttling hard drives at first the contractor would move files your leaked pics or media causing challenges with sink sink quickly showed how the deliverables needed improved and held them to the standards required in the SOP an inspection program document sink meant faster feedback to the contractor for data correction requests and REE inspections also with sink notice the arrows are bi-directional so not only could the contractors completed inspections come into our system with sink but we can assign inspections and pre populate the inspection software for the contractors this saved us a ton of QA QC work and again helped us clean up our map attribute data after inspections were received we can run a discrepancy report to see variances between GIS info and what the contractor changed then decide if we want to send out a survey crew or just update the info and GIS will review this tool later now we'd like to have Cori with IT pipes show how we have used maps to bring the pipeline planning portion of the Monrovia renewal project to get thanks Joe we've opened up our IQs web app and are going to give you basic overview of the workspace so we can then show how we use the reporting this apps browser-based the users could easily access this on tablets or phones out in the field with IDC five web open the app is divided into two main areas my smart tab on the left and map on the right in the smart cabbie area you can see I have several tabs at the top and we call these smart tabs as they manage their reporting I have the Smart Tab for assets selected and you can see that I have several types listed down below this list was actually pre-populated from the GIS and we added to this as we assigned in sections will show how we did that in just a minute on the right part of my workspace I have my map which in this case is an ArcGIS online web map in the upper right I have the legend for the map and you can see we're displaying different layers on the map I can always find my location which you'll see is not in monrovia today if you zoom out you'll see I'm actually at our company office in Albuquerque but if I was doing actual work in the field I could always check to see where I'm located and see nearby buildings or streets go back to Monrovia though on the smart tab when I select this specific asset you can see the map immediately zooms in and highlights that type location so smart term in the map are constantly working together from a user standpoint before we talk about reporting some basic tools helped tremendously with this project first my simple search tool that works from the menu or the map I can search by any and every day to feel that's part of the project this is great if we needed to find an inspection quickly you can see here that we're searching for all types that have the street name Briarcliff Road and right away my smart cab narrows down to show only those pipes and the map immediately zooms in on those pipes as mentioned I can also search from the map if i zoom out I can see the entire city of Monrovia so if I'm actually in Monrovia I can ping my location and then I can select assets nearby I can select that Street choose to filter my line and notice my smart tab changes to show me only those lines that are on Noren Baker Road so I can focus on those inspections that are nearby and look for something specific great tool when I'm out in the field they have that list of assets of norm Vega Road I can also select inspection view and actually go into the detailed condition assessment info on that pipe this is perfect for reviewers to determine what needs done with a pipe with inspection view I can play the video fast forward rewind or play video at faster speeds for a quick review I can also use my keyboard to do those playback functions and enlarge the video which expedited the review process tremendously in addition this view gives me a list of observations or defects on the right these are the defects that were logged during the inspection and with each defect you can also see that I have a severity grade or ranking those are really easy from this inspection view to send the hyperlink to anyone that I want to view the video which makes for super quick inspection sharing if I needed someone's opinion if I hide the video I can also see my coordinating snapshots for each observation and with that I can do a quick scan of what the pipe condition is either by scrolling through the snapshots or selecting the observations and reviewing the severity grade in addition I can pull up on the inspection header details this includes the 10 configurable data fields that Jeff talked about earlier and if I want to edit or manipulate any of that info I can do that here as long as I have permission you'll see when I go into reporting that we use those fields pretty comprehensive Lee I see price also Auto creates a report for each inspection so at any time if I needed a PDF or print out to give to someone I can always pull that up on screen as well so before I go into the reporting we're going to have Krista do a quick poll hi Cory I'm going to go ahead and launch the poll everyone should see the question on their screen do you have your inspections and map integrated seamlessly yes know who you're working to do this will give you just a few seconds to choose the answer that best fits your situation do you have your inspections and maps integrated seamlessly yes no or you're working on this so it looks like we have about 70% of our audiences voted we'll give you another second for the rest of you a majority of the audience is saying no that's not integrated about 40% is saying they're working on it that's pretty cool you guys and about 20% do you have their inspections and map integrated thank you everyone for voting we're going to close the poll and send it back to you Cory thanks Krista now let me show you some of the actual reports and smart tabs that we used on the Monrovia project one of the first parts of the project was to assign the work to be inspected most of our work has actually already been assigned and this complete but we have a few lines that still need to be inspected on our smart tab called work orders of sign you can see that I've chosen to display several fields related to assigning work I have accounts for work order assigned to renewal phase and type status we can also move those fields around is needed to get the report exactly the way that I want it first I'll go ahead and sort by work order is signed and you can see at the bottom of this page I have 1966 assets listed and if I scroll down several of those assets have work orders actually assigned to different contractors but I'll go ahead and choose the group and filter by work order assign so you can see we're going to apply a filter and now when I look at the bottom of the page I can see right away I'm only seeing the pipes that do not have a work-order sign and I've got 56 pipes listed there also my map Coordinates to show me those pipes that have no work order is fine I went ahead and grouped by or I can actually I group by work order sign to but I'm going to group by renewal phase and when I do that you can see at the top of my listing I have five pipes in the north area that have not been assigned for a work order I'll go ahead and select those five pipe and from here if I want to assign those I can see right away they're highlighted on the map on my math legend I can select my assign recorder icon and from the drop-down that appears I can select the contractors name that I want to do the work once I select the contractors name in the check box the alpha with all the GIS attribute info associated automatically push out to an IP pipe project through the sync tool that just gave an overview of this the contractor gets this project automatically assigned the contract you then simply open that project in their field inspection software and all the assets are listed in the smart cab similar to the smart tabs that we see here but in an IC pipe desktop app that's connected to the CCTV camera laser or sonar system this saves the contractor from having to type in mountain numbers pipe IDs street names and other details it also significantly improves the accuracy of the inspections that we get back from the contractor another report that we used inspect is inspection status once I have worked assigned if I want to check the status of inspections and anytime I can select an area on the map and immediately see what lines have or haven't been inspected this is based on the color coding and you can see here when I select this area some lines appear in a green color and that indicates those pipes have been inspected the other lines that are appearing in teal have not been inspected and in this situation those are County assets that are not even part of this particular project but as the project was in process at any time I could see the status of inspection completion once the inspections were completed Meryl Johnson had to review every inspection and the highest priorities focus is the Southwest and the southeast areas as previously mentioned many in the inspections in the beginning had qa/qc concerns and we were able to reject those immediately for reinfection the inspections that matter basic as those key requirements need to quickly review those so we can classify them for structural or maintenance needs first we set up smart tabs for the reviewer to use here you can see I have a filter applied that's only showing me assets in the southeast and the southwest phases so if you're quickly knew what inspections to start looking at based on our priorities the reviewers could then open the inspection view for an asset see the observation log sheet and through images or watch video I could also see my header details and input my reviewer information including dates and any comments if I go back to my smart cab list you can see that I have all my inspections that need reviewed and there are roughly 350 assets that we still need to review with this amount of assets to review we realize that we should be able if the contractors are providing quality inspection narrow this down and just review pipe growth with known problems we still need to review all the pipes eventually but by narrowing this down we can decide what infections need to have asset repairs or rehab completed first so on the same smart cab if I change my filter to show me only pipes with the level 4 or higher observation I can now see the pipes that are already logged as having problems at this point we're relying pretty heavily on the contractor data which is a little scary but necessary when I select this now at the bottom of my page you can see I only have a hundred and one pipes that have a level 4 defect or higher that we need to review ASAP from there I feel my grouping by renewal phase applied and I can quickly begin working on my priority areas as we started get inspections turned in we realize not all the inspections were completed and some require to reverse but that didn't always happen so we had to start checking this if we go to the assets tab and select the filter for observation abandoned I can see my smart tab and my map are showing me that I have 267 pipes that have an observation code of inspection abandoned and I can easily see on the map where the pipes are located up at the top of the smart cabba I have the option to hide all the newest inspections for an asset so if the contractor inspected the line more than one I can hide the older inspection and now I can see that I really only have 206 pipes with abandoned inspections and if I group this by pipe material I can see that almost all of those pipes that we couldn't in finish inspections on or vitrified clay this was expected but visually informative nonetheless once we began reviewing inspections then we started to get into scheduling we didn't plan on doing this through IQ type an IQ crisis not a full work order system but we had to start planning or rehab ASAP and we already had it icy pipes in place with all the inspection info included so we decided to go ahead and use this on the Monrovia projects using icy pipes for this we could easily put that contractor big project you can see that I have a smart caps or structural need and if I open this I have different columns of data two plates that are more related to structural repairs needed for this tab I have a couple filters set up that I can apply and use the first filter is for severe observations and this shows me any pipes that have a level size defect so we know that we may need to make sure all pipes with those level size D sets have the inspections reviewed and a structural status planned if necessary of course I can group those assets by renewal phase so I can work on high-priority area of first notice my map automatically shows me the color coding for the renewal phases in addition I can group by my inspection schedule field and within that I can still see that there are pipes that need reviewed and have level size defects notice my map also shows me additional grouping and this can get a little messy but from a color coding standpoint I can choose to hide areas that I'm not working on right away for structural repairs we needed the site to start organizing bid projects so inside the same structural tab I have all the info needed to do the planning I do have to reorganize my views slightly so I'll remove my previous grouping for reviewing lines and change the conceder report based only on structural needs after I do that when I collapse this listing I can immediately see how many pipes need each type of realigning or repair I can also see the color coding on the map for the different types of repair necessary once I have that list of assets that I want to put out to bid for a specific type of work I can easily export those into a separate web project or downloadable projects that I can give to anyone for viewing the web or downloadable version both come with an included viewer app to give you an idea how this happens I can collect all the pipes that need lateral connection repairs and highlight those then I select to export those assets essentially this creates a mini projects that I can send out to the contractors to bid on with that the project had an asset and inspection details log sheets snapshots videos and full info for the contractors the contractor could essentially pull up the screen that looks very similar to this one this made putting out projects for bid on repair and rehab very quick and easy once we reviewed the inspection and this literally saved hours of compiling did projects another report that we can use and the Eric will talk about minute is for billing having everything digital allowed us to maintain a billing smart tab with that I can pull up specific dates of work so for example on this smart tab I'm showing everything that was done after August then I can group by pipe diameter all the info shown in the smart cab can be copied and pasted into excel sheet exported or printed in a PDF format so comparing this to the contractors billing was really easy one of the tools we found invaluable is the inspection view we showed this earlier but wanted to show a little more with it one of the inspectors actually went out and bought a tablet that he uses specifically for this purpose in the field you can see I'm pulling up a filter for 177 Primrose and I'm opening my inspection view if I have multiple inspections of the same asset at the top of my workspace the multi inspection icon is active and that tells me that there are two inspections when I select this I can then compare the snapshots from each inspection and if I select the observation on each inspection for routes at 68 feet I can see the difference in only 6 months between inspections I can also with this select to review the videos and watch those side-by-side if I click on play both videos start playing simultaneously obviously this will be great for comparison when we start to get back the post repair and section review another totally found quite valuable is plot once we reviewed lines and confirm the defect logging is accurate we can then select pipes and plot the observations that were logged on the inspection the reviewer engineer could both use this tool and this helps us determine what actually needs to be done with the pipe with plot we can quickly do a visual condition assessment based on severity color coding to explain that a pipeline has ten level four defects or no level size defects but with plot I could get color-coded dots of the individual observation giving me a fast review of the pipe and telling me that I likely don't want to do a point repair here also if the contractor use IC pipe I have snapshots for every observation and can scroll through the pipe condition quickly from there obviously I may decide that this pipe needs relined we plotted only one line here for the demo but when I could plot an entire area of observations this is quite valuable to see what was going on with specific pipe construction project that's an overview of our IQ pipes web apps we're actually going to jump back to our presentation where Eric's going to show a couple more details on recording as the person doing a lot of the qa/qc on this data the map was invaluable when I came to Boeing the mighty pipes we easily provided a list of assets within specific renewal phases including diameter ranges and inspection dates we could easily confirm all the required information using the map with applied filters and converting this information to a spreadsheet for comparison to an invoice submitted by the contractor which was to have been created using the same parameters merrill johnson provided the spreadsheet to the contractor and the invoice was modified to reflect the proper bill the first time I made that report it took ten minutes but now at anytime I can go back to the report change dates and that literally takes two minutes this reporting was accurate had clear defensibility and ensured the city was only paying for work that was actually performed as mentioned a couple of times we ran into several GIS discrepancies Jeff brought this up earlier but we started that we started with paper maps and they were difficult to read for us and the contractors having the map next to the inspection detail on screen improved the spatial accuracy of our qa/qc we ran into the following during a standard review upon review we could see inspection video did not have a downstream pipe at the end manhole which the map just clearly displayed the operator had either inspected the wrong asset or mislabeled the inspection the inspection video supplied could not have been the asset identified in the inspection details upon further investigation we learned that the operator had inspected the pipe in the wrong direction traveling upstream versus downstream and therefore he had inspected the wrong asset fix this we simply had to update the inspection market of 19 hikes with the correct asset ID the map and IP pipes immediately matched at the end of this project Merrill Johnson will submit an updated geo database to the city with the IT pipes GIS tools we can easily see suggested updates this tool displays a discrepancy list by comparing the current GIS value with the inspection input value please notice the make selected updates icon at the bottom right of this window with that and as long as the user has permissions we can actually update the GIS attribute data if desired we can either print or export this list to excel there are several other reporting tools that can be used for qa/qc including audit trail logging the reporting is dynamic so throughout this project I could easily bring up any smart tab desired and get immediate intelligence throughout this project both merrill johnson and the city of Monrovia had access to IT pipes web upon completion of the project Merrill Johnson eternal a full control of it5 swamp to the city Shawn Sullivan is the Public Works Division manager for the city of Monrovia and heads up this project when we asked Shawn for his opinion of the project status you can see he had great things to say we hope this presentation has given you a good overview of how every web maps and IT pipes web streamlines in the city's pipeline planning program we'll open up now for questions thank you and we do have several questions coming in so I'm going to start the Q&A and I will share some so Cory this is probably more for you and your team our audience wants to know if this software that you've been demonstrating during the webinar will work with any CCTV out there can you speak to that definitely so I see pipes is camera agnostic we work with cues I box from rapid view Aris technical and virus sight hardware we also worked with some laser and cellular equipment so I keep Isis is very easy to set up inside of any any camera inspection hardware thanks Cory we also had a question about the data so in this project where was the data stored was it stored in an on-site server in the cloud multiple places can you discuss that definitely so maril Johnson chose for Monrovia to store the data on our icy pipes cloud hosting and that was nice because Merrill Donson the contractor doing the work and the city of Monrovia could all access the inspection information and if anyone made updates to inspection information everyone had those updates immediately and with icy pipes you can store locally or you can do can do cloud hosting thanks Cory we also have some questions concerning how often this data was turned in to this city and maybe Jeff can talk about that I know you mentioned it during the webinar but you can talk about the deliverables and how often it was delivered and how that relationship worked yeah sure so as Cory mentioned the data was updated to the cloud weekly from the contractor and then our reviews and any comments or rejections request for reinfection x' reverse inspections etc happened in real time as we conducted the review so during that entire process because it was all cloud based the city had access to that data at any time if they wanted just to check on things see how things were going have any comments or concerns they could satisfy those that way and then final deliverables were done based on our Monrovia renewal section so we initially started with Southwest southeast so as soon as all the inspections were done our review was done and we handled the filtering filtering the Corre demonstrated so that we could come up with repair quantities and locations that was all pulled together into our bid documents to put it out to contract to start the repairs thanks Jeff we also had several comments from our attendees about how nice the the web application was working and that it didn't seem to hesitate or be slow Jeff can you talk about the performance and if there were any issues or challenges in that area yeah absolutely the performances has been surprisingly great and I say surprisingly because so many cloud services that I've used not specific to CCTV but just in general you do sometimes find a lag things will hang up and so on and IT pipes especially considering its handling CCTV files video files works very well we do have some areas within the city of Monrovia where the internet signal on our mobile devices was less than stellar and even then we were still to maintain at least a functional working speed and of course if we were in better areas that things worked fantastic thanks Jeff well I think the webinar went great today there are a few hiccups but I hope everyone enjoyed the webinar we will be posting this webinar online so if you missed part of it or if you'd like to share it with some of your colleagues it will be available in about a week so watch for the follow-up email it will include links to where you'll be able to find the recorded version of the webinar and I hope you continue to join us for our future webinars Thank You Corey and Jeff and the rest of the team is a great webinar today thanks Krista thanks