Creating a Data Dictionary for UN

[MichaelParma]

Greetings,

I'm wondering what others are using to create/export data dictionaries of their built UNs, similar to what Esri provides with the base water model (for example) at https://solutions.arcgis.com/water/help/water-distribution-utility-network-foundation/DataDictionary.... This is such a great resource and I'm hoping to find a way to more easily generate something like this after having extended the base model.

Thanks,
Mike

[AnthonyRyanEQL]

Our model which is fully custom electric model basically resides in a big spreadsheet.

[RobertKrisher]

You can find an add-in in this thread that allows you to export your utility network properties to csv files to produce reports: https://community.esri.com/t5/arcgis-utility-network-blog/utility-network-properties-extractor/ba-p/...

[MichaelParma]

Hi Robert,

I think this gets us closer to what we're looking for. We're trying to figure out the filtering. What is your recommendation for displaying only fields relevant to hydrants, versus say valves? When we use the Fields button, it displays all fields for all subtypes  in the classname.

-Mike

[RobertKrisher]

Mike,

  The fields button lists all the fields for the feature class. If you want something like the online data dictionary that has aliases and visibility at the subtype level you will need to use the "Map Field Properties' button on a map that has been configured with subtype group layers that reflect the subtype settings you want. In the example below I've exported the map field properties from the water distribution utility network foundation utility network editor display and filtered the field properties to just show the values for hydrants.

 

[MichaelParma]

Thanks, Robert. This gets us closer to what our users are looking for - the data model as perceived from the asset type level rather than the feature class level. 

[SSMIC3038]

Perhaps this is what your looking for?

GitHub - Esri/solutions-data-dictionary-viewer: An Interactive Viewer to View Feature Service Detail...

[MichaelParma]

Thanks, we'll have to explore this one, too. I didn't realize it had been updated recently.

[gpgisandsky]

@MichaelParma , @RobertKrisher which tool ESRI use to create Data dictionary like  

https://solutions.arcgis.com/water/help/water-distribution-utility-network-foundation/DataDictionary...

? 

[MichaelParma]

There's not really a clean way to do it in earlier versions, but in Pro 3.2 Esri just released a Generate Schema Report geoprocessing tool. Check out the documentation at https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/schema-report.htm. It's also the first highlight in the "What's New in ArcGIS Pro 3.2" page.

Hope this helps,
Mike