Tag: Data Collection and Management
Esri is pleased to offer all new World Countries and World Administrative Divisions datasets to all ArcGIS users.
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.
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
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:
- DBS_FC_VVT lists the features classes that will be validated.
- PLTS_Master_CNT has a record for each condition that must be met.
- PLTS_Error provides a description of the error that results if the check fails.
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?
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:
- Ensure inverts of incoming pipes are >= elevation at bottom of manhole.
- Ensure invert of outgoing pipe at manhole is = elevation at bottom of manhole.
- 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.
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!
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:
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.
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.
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.