Select to view content in your preferred language

Recommendations on creating a sql database for the UPDM?

425
3
Jump to solution
08-10-2023 06:27 AM
neomapper
Occasional Contributor

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

 

 


 

 

0 Kudos
1 Solution

Accepted Solutions
JohnAlsup
Esri Contributor

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

John Alsup
jalsup@esri.com

View solution in original post

3 Replies
JohnAlsup
Esri Contributor

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

John Alsup
jalsup@esri.com
RobertKrisher
Esri Regular Contributor

@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
MarceloMarques
Esri Regular Contributor

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

| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov
0 Kudos