CCTV Manager est maintenant disponible ! Obtenez les dernières nouveautés de ArcGIS Solutions for Water<\/A>.<\/SPAN><\/PRE><\/P>Au fil des années, nous avons reçu beaucoup de retours positifs sur la solution CCTV Processor<\/A>. Si vous ne connaissez pas cette solution, c'est un outil de géotraitement pour ArcMap qui importe les données d'inspections vidéo en circuit fermé des égouts selon la norme NASSCO PACP version 6. Les tables Inspections et Conditions sont converties en points pour chaque observation et en lignes pour le tronçon principal inspecté. Les images ou photos des observations sont également chargées en tant que pièces jointes, ce qui facilite la publication des données en tant que service et permet à toute personne dans votre organisation d'accéder aux données CCTV. Cette solution libère simplement la richesse des informations capturées lors des inspections CCTV.<\/SPAN><\/P><\/P>En raison des demandes des utilisateurs pour supporter d'autres types d'importation et la nouvelle version PACP v7, nous savions qu'il était temps d'améliorer CCTV Processor.<\/SPAN><\/P><\/P>1:<\/STRONG><\/SPAN> Migration de Model Builder vers une boîte à outils Python : <\/STRONG><\/SPAN>Model Builder est excellent pour définir un processus complexe, nous avons créé un outil plus rapide, plus facile à utiliser et plus stable en utilisant une <\/SPAN>Python Toolbox<\/A>. <\/P><\/P><\/P>2 : Conçu pour ArcGIS Pro :<\/STRONG><\/SPAN> Pour supporter le futur Utility Network en plus des données représentées dans un Geometric Network, nous avons migré CCTV Processor vers ArcGIS Pro. Cela nous a également permis de simplifier le code, le rendant plus rapide et plus fiable.<\/SPAN><\/P> <\/SPAN><\/P>3 : Résolution du BUG-000104129 :<\/STRONG><\/SPAN> L'outil actuel fonctionne très bien pour les points d'observation sur une canalisation issus de plusieurs inspections, mais nous avions un problème difficile à corriger dans la version actuelle. Si une canalisation était inspectée plusieurs fois, nous ne créions qu'un seul segment de ligne d'inspection. La nouvelle version a corrigé ce bug.<\/SPAN><\/P> <\/SPAN><\/P>4 : Support pour plusieurs schémas d'entrée :<\/STRONG><\/SPAN> La mise à jour nous permet de supporter plus que les seules données PACP v6.0.4. Vous avez maintenant l'option de sélectionner PACP v6.0.4, PACP v7.0.7, et Custom. La sélection de l'une des options PACP remplira automatiquement le reste des paramètres de l'outil. Si vous choisissez Custom, vous devrez mapper ces paramètres à votre entrée. Il y a maintenant une option pour ajouter des schémas supplémentaires à la liste des options. Nous détaillerons ce processus lors de la sortie ou si vous souhaitez l'essayer, postez un commentaire et nous fournirons les instructions.<\/SPAN><\/P><\/P><\/P><\/P><\/P>Nous espérons que vous apprécierez la nouvelle version. Ceci n'est qu'un premier aperçu. Nous n'avons pas encore migré toutes les fonctionnalités, telles que les messages ou la conversion de liens. <\/SPAN><\/P> <\/SPAN><\/P>Nous recherchons également certaines de vos données CCTV pour tester. Si vous avez une exportation PACP v7 ou un autre schéma et que vous acceptez de la partager avec nous, nous serions ravis de la tester afin de garantir que tout fonctionne à 100%.<\/SPAN><\/P><\/P><\/P>Commencer avec CCTV dans Pro<\/STRONG><\/SPAN><\/P>Certaines installations sont requises :<\/SPAN><\/SPAN><\/P>1. <\/>Microsoft Access Database Engine 2010 Redistributable<\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/>Microsoft Access Database Engine 2010 Redistributable<\/>
<\/P>
Au fil des années, nous avons reçu beaucoup de retours positifs sur la solution
En raison des demandes des utilisateurs pour supporter d'autres types d'importation et la nouvelle version PACP v7, nous savions qu'il était temps d'améliorer CCTV Processor.<\/SPAN><\/P><\/P>1:<\/STRONG><\/SPAN> Migration de Model Builder vers une boîte à outils Python : <\/STRONG><\/SPAN>Model Builder est excellent pour définir un processus complexe, nous avons créé un outil plus rapide, plus facile à utiliser et plus stable en utilisant une <\/SPAN>
2 : Conçu pour ArcGIS Pro :<\/STRONG><\/SPAN> Pour supporter le futur Utility Network en plus des données représentées dans un Geometric Network, nous avons migré CCTV Processor vers ArcGIS Pro. Cela nous a également permis de simplifier le code, le rendant plus rapide et plus fiable.<\/SPAN><\/P> <\/SPAN><\/P>3 : Résolution du BUG-000104129 :<\/STRONG><\/SPAN> L'outil actuel fonctionne très bien pour les points d'observation sur une canalisation issus de plusieurs inspections, mais nous avions un problème difficile à corriger dans la version actuelle. Si une canalisation était inspectée plusieurs fois, nous ne créions qu'un seul segment de ligne d'inspection. La nouvelle version a corrigé ce bug.<\/SPAN><\/P> <\/SPAN><\/P>4 : Support pour plusieurs schémas d'entrée :<\/STRONG><\/SPAN> La mise à jour nous permet de supporter plus que les seules données PACP v6.0.4. Vous avez maintenant l'option de sélectionner PACP v6.0.4, PACP v7.0.7, et Custom. La sélection de l'une des options PACP remplira automatiquement le reste des paramètres de l'outil. Si vous choisissez Custom, vous devrez mapper ces paramètres à votre entrée. Il y a maintenant une option pour ajouter des schémas supplémentaires à la liste des options. Nous détaillerons ce processus lors de la sortie ou si vous souhaitez l'essayer, postez un commentaire et nous fournirons les instructions.<\/SPAN><\/P><\/P><\/P><\/P><\/P>Nous espérons que vous apprécierez la nouvelle version. Ceci n'est qu'un premier aperçu. Nous n'avons pas encore migré toutes les fonctionnalités, telles que les messages ou la conversion de liens. <\/SPAN><\/P> <\/SPAN><\/P>Nous recherchons également certaines de vos données CCTV pour tester. Si vous avez une exportation PACP v7 ou un autre schéma et que vous acceptez de la partager avec nous, nous serions ravis de la tester afin de garantir que tout fonctionne à 100%.<\/SPAN><\/P><\/P><\/P>Commencer avec CCTV dans Pro<\/STRONG><\/SPAN><\/P>Certaines installations sont requises :<\/SPAN><\/SPAN><\/P>1. <\/>Microsoft Access Database Engine 2010 Redistributable<\/>
Excited to see what the new model brings! I've taken the last model and made it fit my needs, but I'll definitely check out the new version when it comes out! I always learn something new! This might be beyond the scope of this solution, but one of the things I still struggle with is dealing with multiple inspections for the same pipe. Over time, we might end up CCTVing a pipe two three times (pre and post-construction). I'd like to be able to easily see or query the observations that are associated with a specific inspections. The PACP database does have some fields that can easily be used to establish a relationship between the inspections and the conditions , the problem is that ID is only unique within one database. I'm not quite sure what I would have to do to preserve that relationship once I append one set of inspections and observations to my master CCTV geodatabase.
I would like to test it with additional schemas so please - provide me instructions ..!
Python toolbox doesn't load ...
Right click the toolbox and select check syntax.
Did you follow the install instructions, they are required to load the toolbox.
I install pyodbc package thru the console as the Package Manager is stuck during installation !
Check Syntax fire up an error:
Try this fix. Some reason conda is adding a dll that causes an issue
https://community.esri.com/thread/195911-workaround-installed-package-crashing-pro-141
I don't have Python3.dll at all, so that's fix not worked for me...
Miko,
I have not seen this error. If you open the python window in ArcGIS Pro, can you add a simple statement like import ArcPy ?
Can you ensure python is working?
python is working and pyodbc is working as well
Sorry, meant to say in ArcGIS Pro's python window.
same
Can you make sure the PYT is valid, can you download it again. If right clicking will not let you edit it, something else is going on. Let me download it also to ensure it did not get corrupted
One other thought, this PYT requires the cctv folder, all the logic is in there, the pyt is just a shell that loads from there. Can you make sure the folder structure looks like this?
* Mine is not loading as I do not have ODBC install
Finally! I really don't know what was it. Actually I download it again, extract it, open ArcGIS Pro ... didn't work, then remove it and add it again and ...BOOM!
Great, at least we have some nice troubleshooting steps logged for the next person. Thanks!
... I'm expecting instructions for the Custom format (I saw it ask for Access database, but by default the data are in XML) now ..
At the moment, only an access database is support as an input type. Is your data in an Access Format? If so, select custom and then fill out the parameters. As for how to get a custom item in the drop down, we have not typed those instructions up.
Paul93
Python toolbox is not loading for me. I talked with my IT Dept about downloading that Access Database Engine x 64-bit because I am thinking this is my issue. They informed me not to do this as we are running 32 bit. Is there a work around for this? I cannot tell if I am experiencing another issue since I am unable to download the 64 bit Access Database Engine.
Thanks!
That library is required to use the tool. That is why you are getting the !
Can someone please help me out? I'm trying to use the tool and keep getting this error:
I tried using the sample data and it worked. I've compared the field types in my PACP Database with the sample data and they are identical. Is there something I'm missing??
Steven,
Are you using a PACP v7 schema? The code is incorrectly guessing that 'Direction' is the Inspections ID field. If you change that 'InspectionID' or similar, it should work.
Ok yea that fixed the initial error. I should have caught that but thank you Paul!
I'm running into another error though. Sorry, I'm not sure how to look through the script and debug it myself. I think there is any issue with the save_to_disk function. Not sure why I'm getting this error with my own database and not the sample.
Start Time: Monday, September 11, 2017 10:23:31 AMRunning script CreateConditionPoints...Traceback (most recent call last): File "<string>", line 442, in execute File "C:\_MyTools\CCTVProcessorA4W_Preview_RC1\CCTVProcessorA4W\Maps and GDBs\cctv\cctv.py", line 433, in save_to_disk target=table_names[self._inspection_table.lower()])KeyError: 'pacp_inspections'Failed to execute (CreateConditionPoints).Failed at Monday, September 11, 2017 10:23:34 AM (Elapsed Time: 3.59 seconds)
Does your sample database match the PACP schema? It's looking for 'inspections' and your PACP database table is called 'pacp_inspections'.
You can either rename your table to be 'inspections' (case doesn't matter) or modify the schema to use your table name of 'pacp_inspections'
CCTVProcessorA4W\Maps and GDBs\cctv\schema\PACP v6.0.4\schema.xml
That solved the problem. I just needed to modify the table names in the original survey database. Thank you very much Paul!!!
I'm looking to set this up for the first time, should I just wait until its official released as an update and ArcGIS Pro integrated? CCTV Processor | ArcGIS for Water
Any idea how much longer?
Thx
The goal is to have it updated and release for ArcGIS Pro 2.1 in January. You can start with the Beta and update when the release version is available. The end results will be very similar.
I have Microsoft Office Suite 32bit and Access 32bit installed. If I try to install the Microsoft Access Database Engine 2010 Redistributable(64bit) I get an error "You cannot install the 64-bit version of Microsoft Access Database Engine 2010 because you currently have 32-bit Office Products installed"
If I force the install using the /passive command prompt command it "installs" however when try to run the CCTV processor I get the following error, "Unable to load odbcji32.dll"
If I remove Office and Access and then install Microsoft Access Database Engine 2010 (64bit) the CCTV processor works but I don't have Office suite or Access now.
If I attempt to reinstall Office and Access 32bit, I get the following error "You cannot install the 32-bit version of Microsoft Office Suite because you currently have 64-bit Microsoft Access Database Engine 2010 installed"
This is a bit of a Catch 22
Is there a correct installation practice for Office 32bit and Access 32bit along with getting the CCTV processor to work other than installing the 64bit version of Office?
[UPDATE]
- I was able to get it to work alongside Office only by installing the 64bit version of Office and Access. This is not ideal.
- I was able to run the processor (PCAP 6.04 Schema) however the results were incorrect only 146 conditions came through out of an expected 6431.
- I was able to run it with the old CCTV processor and the results were as expected 6431.
- Not really sure what wrong with the new CCTV processor,
For example:Using the Old CCTV processor, I have a pipe with ID 4082. It has three separate inspections on it (95, 96, 403) and a total of 87 conditions.
Using the new one, it only has 3 conditions one for each pipe inspection (95,96, 403) and that's it, everything else is missing.
So for this year's CCTV going to use the Old CCTV Processor and hopefully next year the new one works correctly.
[UPDATE 2 - 28/11/2017]
- So it appears installing the 64bit version of office causes some additional headaches when using ArcGIS 10.3.1 and trying to load Excel tables into ArcMap.
- It gives you the following error: "Connect: Failed to connect to database. An underlying database error occurred. Class not registered."
- You can read more about this problem here: .XLSX PROBLEM - Failed to Connect to Database - Class Not Registered
- Easiest solution was to save the excel file as ".xls"
Tristan, would it be possible for you to share you data with us? You can email to pleblanc@esri.com
What version of Office do you have installed? I have x86 Office 365, and I can install and use x64 Access driver without issue.
I am getting the following error when running this tool and would greatly appreciate any help in solving this problem:
Running script CreateConditionPoints... Traceback (most recent call last): File "<string>", line 438, in execute File "C:\Users\mfacer\Documents\ArcGIS\Projects\PennHillsCCTV\CCTVProcessorA4W\Maps and GDBs\cctv\cctv.py", line 230, in __init__ self._check_dtypes() File "C:\Users\mfacer\Documents\ArcGIS\Projects\PennHillsCCTV\CCTVProcessorA4W\Maps and GDBs\cctv\cctv.py", line 236, in _check_dtypes pipe_pk = self.pipe[self.pipe_pk].dtype File "C:\Users\mfacer\Documents\ArcGIS\Projects\PennHillsCCTV\CCTVProcessorA4W\Maps and GDBs\cctv\cctv.py", line 280, in pipe sql = create_sql(self._pipe_table, self.pipe_pk, self.inspection[self.inspection_fk].tolist()) File "C:\Users\mfacer\Documents\ArcGIS\Projects\PennHillsCCTV\CCTVProcessorA4W\Maps and GDBs\cctv\cctv.py", line 37, in create_sql values = sorted(set(values))TypeError: '<' not supported between instances of 'NoneType' and 'str' Failed to execute (CreateConditionPoints).
There's probably an empty value in one of the access tables. I think this might be be ConditionID field.
Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.