POST
|
Here is a topic that outlines the workflow for adding Reviewer sessions to an ArcGIS Pro project.
... View more
09-14-2022
10:45 AM
|
1
|
0
|
225
|
POST
|
Thanks for the heads-up on this issue. The development team has reproduced this workflow in ArcGIS Pro 3.0.1 and found that the issue is related to the missing Menu command in the Reviewer Results pane. Here is a topic that outlines how to configure the Reviewer Results pane to display different error types and their related attributes.
... View more
09-14-2022
10:42 AM
|
1
|
0
|
257
|
POST
|
Thanks-much for clarifying what you're seeing. Based on the info provided above, the dev team has been unable to reproduce this issue using Pro 3.0.1 and there have not been any bugs addressed since the check's release that would change its behavior. I would suggest starting an incident with the technical support team to capture the details of the rule configuration and associated relationship class.
... View more
09-12-2022
03:26 PM
|
1
|
0
|
539
|
POST
|
The lifecycle management workflow for Reviewer-created errors (in both Batch Job and validation attribute rule workflows) is the same as it was in ArcMap (albeit in a different user experience). This topic outlines the various "paths" that are available in the different phases.
... View more
09-12-2022
11:25 AM
|
1
|
0
|
386
|
POST
|
Is the phase/status values of the error feature not changing when evaluating the feature again after the edit in the destination datasource? On the second evaluation, the expected result is for the error feature's phase/status values to change from Review/Reviewed to Verification/Acceptable. By default, these columns are not turned-on in the Error Inspector pane.
... View more
09-09-2022
03:19 PM
|
0
|
1
|
560
|
POST
|
Hi, For clarification, it sounds like you are using a Data Reviewer check to create a validation attribute rule. Is the Phase/status values of the error feature not changing when evaluating the features again after the edit in the destination datasource? Note: The phase/status fields are enabled from the "Show Status" option on the Error Inspector.
... View more
09-08-2022
03:32 PM
|
0
|
0
|
566
|
POST
|
Hi @waeltaher, Thanks for sharing your geodatabase! It appears that your data does not currently meet the requirements for implementing a validation attribute rule. To implement a validation attribute rule, you will need to enable Global IDs and Editor Tracking on the data source(s). Here is a link to the documentation for reference: Add Global IDs (Data Management) Introduction to editor tracking Once these requirements have been implemented, you should be able to create and save a validation attribute rule.
... View more
09-06-2022
02:53 PM
|
0
|
0
|
494
|
IDEA
|
To all, Would appreciate additional feedback on this idea as it relates to Attribute rule-based workflows.
... View more
09-01-2022
03:12 PM
|
0
|
0
|
1105
|
POST
|
Does the dataset meet the requirements for using validation attribute rules? Here is a doc topic that outlines the requirements for implementing attribute rules.
... View more
08-30-2022
09:32 AM
|
1
|
1
|
578
|
BLOG
|
This post comes courtesy of Bailey Ohlson, from Austin, Texas. Bailey is a student at the University of Texas at Austin where she is finishing her Master of Arts (M.A.) in Geography. Data Reviewer for ArcMap provides the functionality to create different reports based on the records generated by running reviewer checks on a dataset. These reports provide a quick way to assess data quality in an easy-to-read table report format in Excel to inform stakeholders and other non-GIS professionals. The Automated Check Report By Origin Table report included information such as: Date and time the tool was run Feature Class name Check Type Check Title Total Records Total Results Percent Accuracy This blog explains how a similar Excel report is generated in the Q2 2022 release of ArcGIS Pro by extracting data from Attribute rule error layers and feature classes that contain validation attribute rules using ArcPy and OpenPyXL. Extracting Data from Feature Classes and Error Layers The Evaluate Rules geoprocessing tool (or the Evaluate command in the Error Inspector) in ArcGIS Pro evaluates features based on conditions identified in validation attribute rules and stores the results of that evaluation in a series error tables in your database. However, more information is required to create a Data Quality Report than can be found only in the error tables. Data must also be extracted from the features themselves and linked to the data from the error tables, ArcPy can be leveraged to achieve this task. First, all the feature classes in a dataset and their corresponding attribute rules must be identified. For each attribute rule, their parent feature class can be used to extract information for each attribute rule like the rule ID, rule name, rule type, rule severity, the subtype filter, and the input filters, using ‘arcpy.da.Describe’. def attributeRule_info(feature_class):
rule_info = []
attrule = arcpy.da.Describe(feature_class)['attributeRules']
for rule in range(len(attrule)):
error_number = attrule[rule]['errorNumber']
rule_type = attrule[rule]['type']
if(error_number == 998 or rule_type != 'esriARTValidation'):
pass
else:
rulelist = []
rlid = attrule[rule]['id']
error_number = attrule[rule]['errorNumber']
type = attrule[rule]['checkParameters'].get('reviewerRuleType')
name = attrule[rule].get('name')
severity = attrule[rule].get('severity')
subtype_code = attrule[rule]['subtypeCode']
input_filter = attrule[rule]['checkParameters'].get('inputFilters')
# Add to list
rulelist.append(rlid)
rulelist.append(error_number)
rulelist.append(type)
rulelist.append(name)
rulelist.append(severity) However, the feature class itself does not hold information about the number of features that are in error for a given feature class. This information is stored in the system-generated error layers (GDB_ValidationLineErrors, GDB_ValidationPointErrors, GDB_ValidationPolygonErrors, and GDB_ValidationObjectErrors) that are created after authoring attribute validation rules on your data . A search cursor, ‘arcpy.da.SearchCursor’, is used to iterate through each error layer and count the number of features that are in error for a given attribute rule. def attributeRule_errorCount(ruledata):
# Generate set of Rule IDs
id_list = {rd[0] for rd in ruledata}
for id in id_list:
a = 0
for el in errorLayers:
# Build search cursor for all row RuleIDs and ErrorStatuses
with arcpy.da.SearchCursor(el,['RuleID','ErrorStatus']) as cursor:
for row in cursor:
if(row[0] == id and row[1] == 1):
a = a + 1
else:
pass
for rd in ruledata:
if rd[0] == id:
rd.append(a) Note: Validation attribute rules based on the Composite check are not currently supported by the logic in this script and are excluded from the report. Inserting and formatting data in Excel Once the data for each feature class is associated with its corresponding error layer information, then the OpenPyXl python library, available with ArcGIS Pro, is utilized to insert and format the data in Excel. First, a new Excel Workbook is created, and the first worksheet is activated before adding data. wb = Workbook()
wksht = wb.active
wksht.title = "Reviewer Attribute Rules Report"
# Create column headers
labels = ["Workspace","Date/Time","Feature Class", "Rule Type", "Rule Title", "Severity",
"Total Number of Features","Total Validated Features", "Total Error Features",
"Percentage Accuracy", "Total Unvalidated Features", "Percent Unvalidated"]
wksht.append(labels)
print("Finished opening Workbook") Then, the data extracted from the feature classes and the error layers is inserted into the workbook and the cell color, height, width, and more are adjusted. def workbookFormat_header():
'''Formats the cells in the Excel Workbook for user readability.'''
black_fill = PatternFill(patternType='solid', fgColor = '000000')
darkGrey_fill = PatternFill(patternType='solid', fgColor = '808080')
white_text = Font(name='Calibri', size=11 , color='FFFFFF')
for i in range(1,13):
# Row 1 - Column Headders
wksht.cell(row = 1, column = i).fill = black_fill
wksht.cell(row = 1, column = i).font = white_text
# Row 2 & 3 - GDB Averages and date-time
wksht.cell(row = 2, column = i).fill = darkGrey_fill
wksht.cell(row = 2, column = i).font = white_text
wksht.cell(row = 3, column = i).fill = darkGrey_fill
wksht.cell(row = 3, column = i).font = white_text
#Adjust Column Width
wksht.column_dimensions['A'].width = 11
wksht.column_dimensions['B'].width = 18
wksht.column_dimensions['C'].width = 18
wksht.column_dimensions['D'].width = 18
wksht.column_dimensions['E'].width = 49
wksht.column_dimensions['F'].width = 8
wksht.column_dimensions['G'].width = 24
wksht.column_dimensions['H'].width = 23
wksht.column_dimensions['I'].width = 18.5
wksht.column_dimensions['J'].width = 19
wksht.column_dimensions['K'].width = 25
wksht.column_dimensions['L'].width = 19 def attributeRule_organize(ruledata, n, type_color, data_color):
type_list = {rd[2] for rd in ruledata}
for tl in type_list:
typename = RevRules.get(tl)
wksht.append(['','','',typename,'','','','','','','',''])
#Format color of row
for i in range(1,13):
wksht.cell(row = n, column = i).fill = type_color
n += 1
for r in ruledata:
if r[2] == tl:
wksht.append(['','','','',r[3],r[4],'',r[5],r[6],r[7],'',''])
for i in range(1,13):
wksht.cell(row = n, column = i).fill = data_color
n += 1
else:
pass
return n Once all the relevant data is found and inserted into the Excel Workbook, a table is created with the data and the formatting specified in your script. This script generates an accuracy report that calculates the total feature count, the number of validated features, the number of features in error, the percentage accuracy ((1 - (total_errors / total_feature_count)) * 100), the number of unvalidated features, and the percentage unvalidated ((total_unvalidated / total_feature_count) * 100) for each attribute rule in a feature class. To learn more about the python library OpenPyXL please visit the following link: openpyxl - A Python library to read/write Excel 2010 xlsx/xlsm files — openpyxl 3.0.10 documentation About the author Bailey Ohlson I am GIS professional from Austin, Texas with a B.S. in Geology from Texas A&M University (Gig ‘em Aggies!) and an M.A. in Geography from the University of Texas at Austin. I love finding ways to use GIS at the intersection of geology, hydrology, and geography, and have enjoyed improving my skills in python over the last few years. I am also an avid outdoorsman and can often be found taking a walk outside or planning my next backpacking trip.
... View more
08-15-2022
02:29 PM
|
4
|
2
|
2084
|
IDEA
|
@OliviaDeSimoneThanks for the feedback! Follow-up question: In ArcMap, custom fields have been used to support multiple workflows. How would you anticipate using custom fields in a validation attribute rule workflow?
... View more
08-08-2022
09:44 AM
|
0
|
0
|
1040
|
POST
|
Thanks-much for the feedback. There could be a number of reasons behind the error (we were unable to reproduce this error using an in-house EGDB containing an LRS network). I would suggest contacting Esri technical support if you would like to start an incident to identify the cause. Thanks!
... View more
07-26-2022
04:41 PM
|
0
|
0
|
353
|
POST
|
Hi, Currently, there is not a workflow in ArcGIS Pro for identifying missing features using a polygon/polyline geometry. That said, the team is currently gathering user feedback (see this blog article) to help improve tools and capabilities planned in future releases of ArcGIS Pro and ArcGIS Enterprise. Thanks in advance for your feedback!
... View more
07-26-2022
04:36 PM
|
0
|
0
|
233
|
POST
|
Hi, Could you share some details (ArcMap version, geodatabase type) on the errors you highlighted above?
... View more
07-22-2022
12:03 PM
|
0
|
5
|
376
|
BLOG
|
The Q2 2022 release of ArcGIS Data Reviewer has new capabilities that automate and simplify the quality control of GIS data. This includes an expanded library of data validation checks to detect common errors in your data and workflows for converting Reviewer Batch Jobs files (.rbj) into validation attribute rules. Head over to the ArcGIS Blog to read more on what’s new!!
... View more
07-22-2022
11:45 AM
|
0
|
0
|
416
|
Title | Kudos | Posted |
---|---|---|
1 | 02-23-2024 02:34 PM | |
1 | 10-31-2023 08:59 AM | |
1 | 02-24-2023 03:04 PM | |
1 | 01-25-2023 10:58 AM | |
1 | 11-01-2022 11:58 AM |
Online Status |
Online
|
Date Last Visited |
5 hours ago
|