...
| Table of Contents | ||||
|---|---|---|---|---|
|
...
Introduction
It is normal in HADDMS projects to combine CCTV inspection data with GIS data into the required deliverable standards. Historically, this has often been done by entering into joint ventures between drainage contractors and GIS specialists, with the drainage contractor taking the lead.
...
The deviation of the coordinates measured for an asset can be anything between a few mm to many metres. Again, this is normal and there are a number of reasons why there can be such large or small differences including local site conditions.
...
Preparing the Data
The tool in WinCan VX for importing GIS data into an existing project can accept data in the following formats, in order of preference and ease of use:
...
| Info |
|---|
Advice - If you have followed this guide thoroughly, then you will be aware that good inspection data validation as described in Data Validation is essential for good data delivery, and if you have reached the point where you are ready to import GIS data, then hopefully your CCTV inspection data is in a good shape first. However, importing this data can (and often does) introduce a whole new range of errors, so it is a good idea to check the data for logic errors before import and to keep on validating the VX data throughout all stages of data processing, especially after importing external data. As just an example of this - when looking at some recent data where the WinCan VX data was well validated with little or no errors, we saw that after import of GIS data, there were many data errors. On closer inspection of the imported data which had been supplied by a partner contractor to the CCTV contractor, the errors became clear. Although it is not difficult to fix the errors in WinCan VX using tools such as the filters and the Search & Replace tool, it was easier in the end to roll back the project database, fix the source data and then re-import it again without the errors. |
...
Adding Photos
In WinCan VX v10.0 and higher, a new feature has been added that automatically imports photos into the WinCan VX project while importing the GIS data. This is most useful for creating reports for point, region and surface continuous items, and these photos are usually taken by the GIS team at the point of inspection.
...
From here, you can print node cards very easily and the node photos can be printed in the same way that you do for pipe inspections.
...
Running the Import
The first thing to remember before running this import GIS tool into an existing project is that it will modify the data, so your project database will not look the same after running the tool as it did before. As has been mentioned already, it is not uncommon to introduce errors into the project during this process.
...
Remember, during this import, a database backup has been created as described previously, so if you are not happy with the results, you can roll back.
...
Rolling Back the Database
There are a number of processes within WinCan VX where a backup copy is made against a date and time stamp of the current project database before the action is executed. This is done at points during different functions where the software is modifying the data automatically, and there is a chance that the user may not like the results. These include:
...
To roll back the project to a previous state, simply take the relevant backup databases, copy them and paste them into [Project Folder] → DB. You may choose to overwrite the current database files or take your own backup again of these but this must be done manually and there is no automated tool right now for doing this in WinCan VX.
...
Resizing Photos
In-pipe inspection photos taken inside pipe inspections have their file size specified by the video quality setting applied in the User Settings on the PC, but even when these settings are set to their highest values, the picture file sizes are not particularly large.
...
This tool is available for all WinCan VX projects, not just HADDMS, but it is particularly useful for HADDMS work because of the often large number of files that need to be added to the project.
...
Options to Improve the Data for Import
As described in Understanding Object Types, a solid understanding of WinCan VX object types as well as HADDMS object types is essential to creating good data in the WinCan arena. Fortunately, there are only 3 WinCan continuous types and 3 WinCan node types.
...
With these values (SEC, LAT, SUR, NOD, CON, REG), you can follow the process described above and create additional columns in your import data to again greatly improve the quality of the results in the WinCan world, but it cannot be stressed strongly enough that you must be considerate when deciding which value to assign to which object and you must only use the text strings exactly as they are listed above.
...
WinCan VX v11 Update
From WinCan VX v11 onwards, there are a number of improvements in the GIS file mapping editor:
...
Import mapping editor improvements.
The buttons with text captions have been replaced with icons with hover tip text.
A new ‘Clone’ button has been added. This allows you to clone and rename the current mapping file so that you can take an existing mapping file (the one that is currently loaded) and make a direct copy of it which you can then modify to suit your own requirements.
Transfer mapping tool has been added. This allows you to specify import transfers inot the current mapping file, so where an import file has data that does not align with the drainage standard that you are using, you can exchange the data at the point of import.
The exchange mappings for HADDMS are already defined in the standard mapping files, so for HADDMS, there is nothing to do here from v11 onwards. The exchange mappings include things like converting the bad material code PVC to PV, converting the HA ownership code to HE, and many more besides where the data is not clean in the import shapefiles. This then immediately removes a lot of validation errors from the project right from the beginning.
The converter settings can include wildcards if needed, but these are not needed for HADDMS.
...