Address Data Management Solution Data Dictionary

518
1
04-21-2020 11:02 AM
JoeBorgione
MVP Emeritus

Is the html data dictionary that ships with the solution available in excel, csv or esri gdb table format?

Chris Fox

Hayley Miller

That should just about do it....
0 Kudos
1 Reply
JoeBorgione
MVP Emeritus

It's fairly easy to get an html table into excel; once there you can save it to what ever you want: I prefer csv which I perform a table to table upon to get it into a fgdb table.  I do this so I can map my current data schema(s) to the ESRI field names and vice-versa.

  1. Open the solutions html data dictionary in your favorite browser
  2. Copy the url
  3. Open Excel
  4. Click on the Data heading in the top ribbon
  5. In the Get Data Group, select From Web
  6. Paste the url into the subsequent dialog window

After that, you will be presented with several choices (like 65) of table names with the naming convention of Table ##.  Scroll through the list until you see the one you want, and click the Load button at the bottom of the Navigator window. It automagically displays as an excel worksheet and you can then save as you like...

That should just about do it....