topic Re: Creating a Data Dictionary for UN in ArcGIS Utility Network Questions

Creating a Data Dictionary for UN

MichaelParma — Wed, 04 Jan 2023 22:34:54 GMT

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/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

Re: Creating a Data Dictionary for UN

AnthonyRyanEQL — Wed, 04 Jan 2023 23:12:37 GMT

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

Re: Creating a Data Dictionary for UN

RobertKrisher — Wed, 04 Jan 2023 23:15:53 GMT

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/1056201

Re: Creating a Data Dictionary for UN

SSMIC3038 — Thu, 05 Jan 2023 13:04:35 GMT

Perhaps this is what your looking for?

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

Re: Creating a Data Dictionary for UN

MichaelParma — Thu, 05 Jan 2023 17:55:44 GMT

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

Re: Creating a Data Dictionary for UN

RobertKrisher — Thu, 05 Jan 2023 18:16:42 GMT

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.

Re: Creating a Data Dictionary for UN

MichaelParma — Fri, 06 Jan 2023 14:04:48 GMT

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.

Re: Creating a Data Dictionary for UN

MichaelParma — Fri, 06 Jan 2023 14:16:00 GMT

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

Re: Creating a Data Dictionary for UN

gpgisandsky — Mon, 20 Nov 2023 17:05:39 GMT

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

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

Re: Creating a Data Dictionary for UN

MichaelParma — Mon, 11 Dec 2023 18:24:24 GMT

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