Load large sewer datasets into the UN

TobeyKane-Seitz

Hi all,

Has anyone run into issues loading large sewer datasets into the UN? I have 250,000 line features in an asset package that I am migrating into the UN. My goal is to migrate these features and to see that the Line - Snap to Manhole attribute rule is working properly, meaning that the pipe connections are generated with associations, and the line is offset from the manhole features. The sewer device and structure junctions were previously loaded into the database.

For now, I am loading the data into a fgdb UN.

I have tried the following

• Applying the asset package with data: this loads the line features, but the attribute rule does not fire. The lines are still connected to the manhole features
• Appending the data in small subsets: I have tried this in modelbuilder and just using the gp tool. It is extremely slow and seems to crash if I select more than 5,000 features at a time.

My network topology is disabled, and I've also disabled all unnecessary attribute rules to try to speed up the process. My source and target databases are in the same folder on my local machine.

Any help is appreciated!

JohnAlsup

When running Apply Asset Package where the UN properties are being applied and data is being loaded in a single execution, Attribute Rules do not fire, we do this for performance reasons.

I would suggest first using Apply Asset Package and not checking the Load Data option so that your UN properties are applied to the target UN and then re-running Apply Asset Package with the Load Data option checked against the same UN.  

 

However, a more scalable approach is to manipulate the data before loading in to the UN.  Relying on the Attribute rules will be very slow for loading that volume of data.