Tag: Data Collection and Management

New World datasets are now available

Esri is pleased to offer all new World Countries and World Administrative Divisions datasets to all ArcGIS users. 

World Administrative Divisions 

Both datasets are based on source data provided by DeLorme Publishing Company, Inc., with additional attributes from Esri. These very detailed datasets of boundaries can be used at both large and small scales. They have been designed for use as a basemap that easily can be edited to fit a user’s needs and view of the political world.

World Countries

Each dataset includes attributes for name and ISO codes, along with continent information. Particularly useful are the Land_Type and Land_Rank fields which separate polygons based on their area size; these attributes can be used for rendering at different scales by providing the ability to turn off small islands which may clutter small scale views. The World Administrative Divisions dataset also includes notes describing disputed boundaries.

View the World Countries and World Administrative Divisions item details on ArcGIS.com to download the layer packages or visit the Esri Data & Maps World datasets page on the ArcGIS Content Resource Center for a list of all the world layers available for download on ArcGIS.com.

Contributed by James Shimota

Posted in ArcGIS Online, Services | Tagged , , , , | 1 Comment

Migrating 9.x CNT/VVT checks to 10

Those of you who have been using the Condition Table (CNT) and Valid Value Table (VVT) checks in Data Reviewer 9.x might have noticed these checks were removed in version 10. For this blog entry I’d like to walk you through configuring the Execute SQL check to validate your data in the place of CNT and VVT checks.

About CNTs and VVTs
Let’s first review what CNTs and VVTs were. CNTs were used to define a WHERE clause with invalid attribute values or attribute combinations. For example, a condition might be that, for certain subtypes, the NAM text field cannot be blank or contain N/A. This means the field must always be populated for the subtypes specified in the condition table. Running the CNT check within Data Reviewer 9.x would find features that satisfy the chosen conditions. This CNT information is stored in a combination of three tables:

  1. DBS_FC_VVT lists the features classes that will be validated.
  2. PLTS_Master_CNT has a record for each condition that must be met.
  3. PLTS_Error provides a description of the error that results if the check fails.

Continue reading

Posted in Editing | Tagged , , , , | Leave a comment

Data quality concerns keeping you up at night?

What keeps water, wastewater and stormwater utility GIS professionals up at night?   Could be doubts about your system architecture or capacity, might be fears about data backups and recovery, maybe your backlog of unprocessed as-builts.  A common concern we are hearing right now from the user community is about being sure that your data is good enough to meet the needs of your utility.  This is driving more water utilities to focus on quality assurance (QA) and quality control (QC).

Across the industry water utilities are expanding their GIS quality control procedures or implementing formalized quality control if they don’t have any in place.  Water utilities are also reviewing their existing GIS implementation and workflows for ways to increase quality assurance.  At some water utilities these changes are coming out the GIS department, driven by proactive GIS managers and staff.  At other utilities these changes are coming top down from utility management that recognize GIS data now runs throughout their utility like a steel thread or from the IT department as it assess the state of all utility digital data.

But haven’t we always been concerned about data quality?

Continue reading

Posted in Water Utilities | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Response to ArcGIS Data Reviewer Valency check for from/to nodes idea posted on the Ideas site

Recently, one of our users posted an idea for ArcGIS Data Reviewer on the Ideas site. The user provided some examples of how they would like to implement the Data Reviewer Valency check in their work environment. These were:

  1. Ensure inverts of incoming pipes are >= elevation at bottom of manhole.
  2. Ensure invert of outgoing pipe at manhole is = elevation at bottom of manhole.
  3. Ensure a main pipe never flows into a lateral.

Although Srinivas had discussed configuring the Valency check for various common scenarios in our previous blogs, he did not address any user-specific examples such as the above. In this blog, I wanted to highlight how to configure the Valency check for examples 1 and 2.

The configurations provided below use the sample data provided with the Infrastructure Editing Template on the Water Utilities Resource Center. If you’re interested in testing the configurations you can download this template as well as the Data Reviewer for Infrastructure Template from the Water Utilities Resource Center that contains additional checks in the form of batch jobs for validating water / wastewater / stormwater data.

Continue reading

Posted in Editing, Water Utilities | Tagged , , , , , , , , , | 2 Comments

ArcGIS Data Reviewer for Water Utilities webinar recording now available

The video for the February 15, 2011 ArcGIS Data Reviewer for Water Utilities webinar is now available on the Data Reviewer and Water Utilities Resource Center. You can find the recording here.

In addition, you’ll find a written copy of the Q&A attached to this blog post below.

Thanks for the feedback and for attending!

Posted in Editing | Tagged , , , , , , , , , , , , | Leave a comment

Two new Data Reviewer white papers released!

Learn more about best practices for database administrators to establish the ArcGIS Data Reviewer 10 workspace in an enterprise geodatabase for SQL Server and Oracle. The white papers are available at:




Posted in Editing | Tagged , , , , , , | Leave a comment

What's inside the holes in my polygons? Part 2

In part 1 of this blog, I wrote about how you can use the ArcGIS Data Reviewer Invalid Hole Feature check in a spatial analysis.

The Invalid Hole Feature check uses an overlay to locate features within polygon holes. This type of overlay is deceptively tricky because a feature in a polygon hole is not inside or outside that polygon. Such a feature is located outside an interior ring of the polygon.

Part 1 of this blog demonstrated how you can use Data Reviewer to locate and display crime events within an unincorporated area of a city. However, the analysis is incomplete. After running the Invalid Hole Feature check as described in part 1, the Reviewer geometry returned are Reviewer point features. These features are multipart points (multiple geometries stored as a single feature with one set of attributes). While good for visualization, these features cannot be used as-is for analysis because they lack the crime information stored in the original data. You need to attach attributes to these features to understand what happened at each location. This will require splitting the multipart geometry into singlepart geometry.


Continue reading

Posted in Editing | Tagged , , , , , , , , , , | Leave a comment

Spatial Roundtable Discussion & new Crash Collection Data Model

See what traffic safety industry experts have to say about current trends as they share their experiences on the Spatial Roundtable. The topic “Safer Roads Through Effective Traffic Safety Management” is now open for discussion!
We have also created a new Crash Collection Data Model, a geodatabase schema containing elements and valid values specified in the MMUCC. The Model Minimum Uniform Crash Criteria (MMUCC) is a guideline for collecting consistent crash data in the field.

Posted in Transportation | Tagged , , , , | Leave a comment

Upcoming ArcGIS Data Reviewer for Water Utilities webinar on February 15th!

If you are a water, sewer, or stormwater utility, you may be interested in the free webinar on Feb 15th offered by Esri’s Water Practice and the Data Reviewer team. The webinar will discuss how water utilities can leverage the ArcGIS Data Reviewer extension and the Water Utility Resource Center templates to effectively integrate quality control into your GIS data creation and maintenance process, and how to ensure the accuracy of your assets.

Sign up for the free webinar here.  Also, feel free to explore the newly released Data Reviewer for Infrastructure template available on the Water Utilities and Data Reviewer Resource Centers.

Posted in Editing | Tagged , , , , , , , , , , , | Leave a comment

Data Reviewer for Infrastructure template released on the Resource Center!

Interested in exploring how Data Reviewer can be implemented in water utilities? Then check out the latest template just released! The Data Reviewer for Infrastructure template is a pre-configured set of Data Reviewer batch jobs (.rbj) for performing automated quality control on water, sewer and stormwater data. It enhances the Infrastructure Network Editing template and is configured to work with the local government sample geodatabase delivered in the Local Government Resource Center templates.

To learn more about how to use the Data Reviewer template for water utilities, sign up for a free webinar here on February 15th.

Posted in Editing | Tagged , , , , , , , , , | Leave a comment