Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Abstract

The core principles of collecting good quality data from site for creating CCTV inspection reports including some explanations of how to avoid common mistakes.

...

Page Tree
rootWRc Collecting Good Site CCTV Inspection Data
searchBoxtrue

...

The PLR Naming Convention

Most global drainage inspection standards include a system for naming pipes based on either the upstream manhole ID or a combination of both the upstream and downstream manhole IDs. The Manual of Sewer Condition Classification (MSCC) defines the naming convention for WRc pipe and sewer inspection using the Pipe Length Reference (PLR) system at all times:

...

This works well in Infonet and helps with connectivity analysis, but there is no concept of this in the WRc MSCC data stream which is why using this value to create PLRs is not recommended.

...

Good Site Drawings

Everything described above regarding avoiding problems with data in software applications can be avoided by taking care and time to create good quality site drawings. The process described here considers a domestic CCTV inspection but the recommended logical approach can be extended to any type of CCTV inspection.

...

Notice in the drawing we have used red lines for foul drains and blue for surface water objects. There is not hard and fast recommendation for this and different water companies use different colours for this so you can be fluid, but it is advisable to at lease least have some coloured pens to hand for this reason, particularly where there are separate foul and surface water systems at the site.

...

That’s it, your job as a CCTV surveyor is complete provided that the video files and data that you have recorded on your CCTV camera match up with this drawing. Based on the information reported here, the office rehab manager can either go with your recommendations or create their own, but regardless of which way they go, they have enough information in the video files, pictures and (most importantly) the very good site sketch to make all the good and proper quotations needed for this job.

...

Understanding STC25 Manhole References

It is common when working with water company asset records to see STC25 manhole references like NZ24567401 (made up example) and although this seems like a mad set of numbers and letters, the way these are constructed is actually quite simple and is described in Appendix A of the MSCC.

...

To understand the STC25 reference, we must split it up into its 5 6 constituent parts:

  • NZ 24 56 7 4 01

    • NZ = the 100km grid tile that you are currently in as described and specified by the Ordnance Survey. Remember 100km = 100,000 metres.

    • 24 = the 24th kilometre across the NZ box from the bottom left corner starting at 00.

    • 56 = the 58th kilometre up the NZ box from the bottom left corner starting at 00.

    • 7 = the 7th 100m segment across the km grid square starting at 00.

    • 4 = the 4th 100m segment up the km grid square starting at 00.

    • 01 = numeric counter as described previously.

...

OS grid tiles.

From this, we can deduce that the NZ 100km grid tile is in the North East of England, and if we count 24Km East from the bottom-left corner of the tile and 56Km North from the bottom-left corner of the tile, then we hit the red cross:

...

  • you can do what you want with the last 2 characters, they are unique identifiers only, and

  • you cannot assume what the correct values for the first 8 characters are because you may be standing on a prescribed 100m square right now but if you take one step to the right or left then you could be in a different square and you would never know it. There are no golden lines on the ground where these square squares start and end.

WinCan VX Map includes an option to click on a point on the screen against a given background location plan and the appropriate STC25 reference will be generated for you. How does it do this? Because we know the coordinates where the mouse was clicked on the screen and the first 8 digits are geo-spacial so they are not in a any question or open to modification by the user.

Given that the Water and Sewerage Companies (WaSCs - pronounced Wazzucks 😃) usually use 2 numeric digits for the last 2 values when we are plotting uncharted assets, we cannot be absolutely sure in any 100m grid square that the last 2 digits ‘01’ have already been used by the WaSC so an easy solution when using WinCan Map VX is to let the software create the correct STC25 reference and then edit the last 2 character sonly to 2 letters rather than 2 numbers. The best suggestion for this to prevent duplicates on the client’s mapping system is to use your initials for the first uncharted asset, so the first manhole in the 100m grid might be JG (if that’s your initials), then JH, JI, JK etc.

...

This means that with HADDMS numbering, we are focusing down to a 10m grid rather than a 100m grid and a typical HADDMS node reference might typically look like NZ2456_7348a where:

  • NZ 24 56 _ 73 48 a

    • NZ = the 100km grid tile that you are currently in as described and specified by the Ordnance Survey. Remember 100km = 100,000 metres.

    • 24 = the 24th kilometre across the NZ box from the bottom left corner starting at 00.

    • 56 = the 58th kilometre up the NZ box from the bottom left corner starting at 00.

    • _ = fixed text character.

    • 73 = the 73rd 10m segment across the km grid square starting at 00.

    • 48 = the 48th 10m segment up the km grid square starting at 00.

    • a = alpha node counter inside this 10m grid.

As a point of interest, and if the standard character lengths allowed it, we could specify a 1m grid on the ground using a manhole reference like NZ2456734854a, so this can be achieved with only 13 characters. The chances of there being more than 1 drainage asset plotted in a 1m grid square are extremely low, but possible. It is common to see double gullies side-by-side on the inner ring of roundabouts where the road surface level is angles downwards in towards the centre of the roundabout.

...