Existe uma maneira de programaticamente excluir e recriar a geometric network?

Question

<\/HEAD>Olá a todos,<\/P> <\/P> Estou atualizando um serviço de água para ArcMap e Enterprise 10.6.1 a partir da versão 10.2.1. Parte do processo de atualização é alterar o sistema de coordenadas de todos os conjuntos de dados. Eu escrevi código ArcPy para realizar a transformação in-place para um novo sistema de coordenadas. A lógica principal é;<\/P> 1. Projetar todas as classes de feição raiz e classes de feição nos conjuntos de dados para um geodatabase temporário com o sistema de coordenadas pretendido.<\/P> 2. Truncar todas as classes de feição e conjuntos de dados no workspace original.<\/P> 3. Alterar a referência espacial dos conjuntos de dados do workspace original e das classes de feição raiz para o sistema de coordenadas pretendido.<\/P> 4. Anexar os dados projetados das classes do geodatabase temporário de volta aos conjuntos de dados e classes originais.<\/P> <\/P> Isso evita excluir as classes de feição existentes mantendo todas as permissões etc iguais. E parece estar funcionando corretamente.<\/P> <\/P> No entanto, alguns dos conjuntos de dados possuem geometric network e estou tendo dificuldades para transformar esses. A maioria dos comandos como "project" etc não funcionam em classes de feição que participam da GN. Eu esperava exportar a geometric network, excluir ou desabilitar a geometric network, alterar o sistema de coordenadas dos conjuntos de dados usando o método acima e reimportar ou reabilitar a geometric network. Infelizmente, não há ferramenta para exportar a geometric network com as classes de feição que participam dela, todas as regras de conectividade e pesos. Mesmo arcpy.Describe não me fornece as regras de conectividade e pesos para que eu possa escrever meu próprio código para "reconstruir" a geometric network. Existe alguma opção para exportar e importar\/reconstruir programaticamente uma geometric network? O único link que encontrei é https:\/\/www.arcgis.com\/home\/item.html?id=fa4e4cdd3bf64be7a1287fd1fd12e2f1<\/A> que parece ser um addin do arcmap 10.2 e não existe versão 10.6+ dele.<\/P><\/P> Qualquer ajuda será muito apreciada.<\/P> <\/P> Obrigado,<\/P> Vish<\/P><\/BODY><\/HTML>

BillyBuerger · Answer

Yes, you can use ArcPy to do a lot of these things as well.  Depending on how many you have to do though, it can be a bit of work to manually build the specific scripts for each network.  Plus, the OP specified that it's the loading of all the network rules that is a big part of the issue.  I would assume there are ArcPy commands for that as well but I've seen some networks with a LOT of rules.  So unless you have a process that can generate those, building the python script to do that could be a lot of work as well.

Reading the OP again, I realize I've done something extremely close to what was described as far as wanting to reproject an existing database as opposed to creating a new database.  The other part of it for us is that we didn't (or couldn't) delete and replace the features as that would generate new OIDs which could be a problem for relationships both internal and possibly external "soft" relationships as well.  Our process was similar as far as projecting to a new GDB and changing the Spatial Reference of the existing classes.  But instead of deleting the features and loading in the updated projected features, we left the features as they were and then ran a process to update the geometry of each feature to the geometry from the projected GDB.  I likely had to drop spatial indexes to avoid index errors do to the large change in X/Y coordinates.  And I also had to regenerate the extents for each feature class after the updates.  There may have been a few other updates and fixes that needed to happen to make it all work.  And of course I used Geodatabase Designer (or our own version of it) to rebuild the geometric network and relationship after the fact.  But it was successful in the end.  It's been some time, did you get it to work or are you still working on it?

JoseSanchez · Answer

You can use ModelBuilder to build a model that  Creates a Geometric Network, then you can export it to Python. to run it in a script

To delete the Geometric Network

arcpy.Delete_management(FC Network , "GeometricNetwork")
 print "Delete Geometric Network"

arcpy.Delete_management(FC Network_Junctions, "FeatureClass")
 print "Delete Network Junctions"

arcpy.Delete_management(Table NETWORK_BUILDERR , "Table")
 print "Delete Table NETWORK_BUILDERR"

To Create a Geometric Network

# Local variables:

Water = "C:/arcgis/ArcTutor/BuildingaGeodatabase/Montgomery.gdb/Water"

# Process: Create Geometric Network

arcpy.CreateGeometricNetwork_management(Water, "Water_Net", "Distribmains COMPLEX_EDGE NO;Fittings SIMPLE_JUNCTION NO;Hydrants SIMPLE_JUNCTION NO;Sysvalves SIMPLE_JUNCTION NO;Tanks SIMPLE_JUNCTION YES;Transmains COMPLEX_EDGE NO", "0.5", "Friction_Factor DOUBLE #", "Distribmains FRICTION_FACTOR Friction_Factor;Transmains FRICTION_FACTOR Friction_Factor", "", "PRESERVE_ENABLED")

BillyBuerger · Answer

Geodatabase Designer 2 does exactly this but unfortunately hasn't been updated in a LONG time.  It still works on 10.2.1 at least although in the link you reference, apparently it doesn't work on some of the newer versions even with the work around.  All of the ArcObjects calls still exist and it's the installation method and reliance on the GxDockableWindow that cause problems.  So it's possible to reuse the code in a new extension or add-in that doesn't use these and get the same results.  But it is a bit of work as there's a lot of code in there.  You don't need to do everything though as GDB designer does a lot more than just geometry networks.  At the very least, it can be used as a reference for building a process to rebuild a network with all the same parameters.