You can click on the Attribute Rule link in the TOC to go to the sheet containing all of them. I can sort these alphabetically and now I’ve got an easy list of fields to review and compare.Ī nice addition to the report is that all the attribute rules in the geodatabase come along for the ride. What if I only care about the date fields being used as the Date Created field in Editor Tracking? Filter the Usage column by Created. How does looking at all 721 fields in my Communication Network help me? Well, as shown in the gif below, maybe I just want to see all my Date fields. For example, clicking the Field link on the TOC sheet will take you to a page with all of the fields in the geodatabase listed on it. These sheets contain every single instance of that schema element. Clicking on any of them will take you to a “megasheet”. “Megasheets”Īs mentioned above, the TOC page has a summary list of all the schema elements in the geodatabase you’ve exported. Now you can easily click back and forth between sheets to navigate around. Find Forward in the list and click Add >.In the Excel Options dialog click Quick Access Toolbar.Click Options (all the way at the bottom).To add these to the Quick Access Toolbar: These are obviously a huge help when navigating a massive workbook like these schema reports can create. It also has information about the workspace that the report was generated from at the top.Īnd then, for some reason, the Back and Forward navigation buttons are not on the Excel ribbon by default. The first page of the report acts as a table of contents for the rest of the workbook. More dataset types and properties supported.Here’s a not-so-exhaustive list of what we added and why (that also doubles as a tips and tricks section): We thought about it, we built out the tool, we tested, we iterated, and we got a lot of these improvements in there. Why not add other output formats?Īnd so it went. What if I wanted to see all the fields in the whole geodatabase all at once? What capabilities are enabled on the feature class? Why not add domain usage information? Let’s put more details on the pages and have links anchored throughout them to navigate around more easily. “Schema Biffer” sounded cool but “ Generate Schema Report” was a way more sensible, say-it-like-it-is kind of name.īut of course, we aimed to improve the output too. Each sheet of the workbook would be a schema element such as a feature class or domain. The goal was to make a geoprocessing tool that biffed the geodatabase schema into an Excel workbook. Obviously, phase one was to generate the schema report itself. To perform mass schema updates – a lot of users found it to be faster to make batch edits within the spreadsheet, add and reorder fields, update and delete domains, adjust properties as needed, then reimport and create a new geodatabase containing all the schema changes they’d just made.Īlright, cool.As documentation of their data model – users would use the output to generate data dictionaries, collaborate on their data models and adjust them, use it as a snapshot in time of the schema, and some would straight up print it and hand it out as documentation.Through our engagements we found these to be the top two reasons people used the X-Ray tool: Our goal was to offer this capability in the core software, but we also wanted to hear from people on ways we could improve upon it. In house, our Professional Services and Solutions teams also had a number of workflows involving X-Ray. We met with users and talked to them about their use cases. So, we took some time to go through the comments and see what the main trends were. We knew it was some beloved functionality. This type of experience has not been available in ArcGIS Pro, so when the idea (and other duplicate ideas) hit the community pages, the views, comments, and kudos kept clipping up-up-upwards. So, this experience offered a familiar and easy way to view your data model in a spreadsheet and quickly navigate between schema elements to see their properties. Feature classes and domains were represented on their own sheets in the workbook. X-Ray was an unsupported add-in to ArcCatalog that could be used to “develop, refine and document your geodatabase designs.” It basically exported your geodatabase schema to an Excel workbook via an XML workspace document.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |