I'm hoping that someone might be able to point me in the right direction with a little exercise I need to carry out. I work for a water utility customer and I have recently implemented a new GIS within the organisation. We are using ESRI (ArcMap v10.3.1) with ArcGIS for Server Basic Standard Version. We also have the Data Interoperability extension.
We are looking at changing our connectivity rules and hopefully retrospectively cleaning up our existing data to match these rules.
Does anybody know of a way that I could either set up some model builder queries (I haven't gotten into python yet) that will allow me to identify connected sections of pipe that have the same attribute values such as install date, diameter, material or pressure rating? I would ideally like to then merge these features together in such a way that it creates a new feature in my database (this will automatically assign it a new ID from the triggers that we have set up in the database) but also copies the old original ID's into some OLD ID fields that I will set up in against these featureclasses. I can do the sorting out of the ID's further down the track, my priority is being able to identify the connected sections of pipes that have the same attribute values.
I've just started to dabble in SQL so I'm quite happy to have a look at ways that this could potentially be done at the backend database level if this is an easier way to do it using spatial querying etc but again I would need some pointers on how this could be done.
If it can't be done, or there's going to be too much work involved then we will most likely just leave our existing data as it is, but I'm quite anal about stuff like that so ideally I'd like to get it cleaned up and matching the new rules that we are trying to implement for any new data that is entered.
Thanks in advance for any advice guys.
Cheers.
أكثر...
We are looking at changing our connectivity rules and hopefully retrospectively cleaning up our existing data to match these rules.
Does anybody know of a way that I could either set up some model builder queries (I haven't gotten into python yet) that will allow me to identify connected sections of pipe that have the same attribute values such as install date, diameter, material or pressure rating? I would ideally like to then merge these features together in such a way that it creates a new feature in my database (this will automatically assign it a new ID from the triggers that we have set up in the database) but also copies the old original ID's into some OLD ID fields that I will set up in against these featureclasses. I can do the sorting out of the ID's further down the track, my priority is being able to identify the connected sections of pipes that have the same attribute values.
I've just started to dabble in SQL so I'm quite happy to have a look at ways that this could potentially be done at the backend database level if this is an easier way to do it using spatial querying etc but again I would need some pointers on how this could be done.
If it can't be done, or there's going to be too much work involved then we will most likely just leave our existing data as it is, but I'm quite anal about stuff like that so ideally I'd like to get it cleaned up and matching the new rules that we are trying to implement for any new data that is entered.
Thanks in advance for any advice guys.
Cheers.
أكثر...