topic Re: Recommendations on creating a sql database for the UPDM? in ArcGIS Utility Network Questions

Recommendations on creating a sql database for the UPDM?

neomapper — Thu, 10 Aug 2023 13:27:26 GMT

We installed SQL 2019 and now we're wondering what the best next step is to getting the Gas and pipeline utility network v2.2 on it. Any help or suggestions would be awesome! Thanks all

Re: Recommendations on creating a sql database for the UPDM?

JohnAlsup — Thu, 10 Aug 2023 13:34:20 GMT

I would start by using Stage Utility Network and Apply Asset Package from the Utility Network Package toolbox using the Gas Utility Network Foundation model found on the Solutions site.

https://arcg.is/0995Pr0

Re: Recommendations on creating a sql database for the UPDM?

RobertKrisher — Thu, 10 Aug 2023 14:02:32 GMT

@neomapper John's approach will deploy an empty schema to your environment using a spatial reference from our sample dataset. Other items to consider:

You should change the spatial reference of the asset package to the coordinate system of your organization using the "Change Asset Package Spatial Reference" tool, also in the Utility Network Package toolbox, before deploying
If you're just looking to try out the model, the link John provided includes a file geodatabase that contains a standalone utility network that can be used without an SDE or ArcGIS Enterprise
When you want to see your data in the utility network you should migrate your data into the asset package (With the updated spatial reference) then stage/deploy THAT asset package to SDE

Re: Recommendations on creating a sql database for the UPDM?

MarceloMarques — Thu, 10 Aug 2023 15:51:07 GMT

Best Practices for Storing the Linear Referencing Workspace in an Enterprise Geodatabase in SQL Server.

Linear Referencing - Pipeline Referencing
      Best Practices LR 3.x Workspace in SQL Server®

For more best practices visit.

Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices