gis data quality evaluator version 5 0 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
GIS Data Quality Evaluator Version 5.0 PowerPoint Presentation
Download Presentation
GIS Data Quality Evaluator Version 5.0

Loading in 2 Seconds...

play fullscreen
1 / 27

GIS Data Quality Evaluator Version 5.0 - PowerPoint PPT Presentation


  • 232 Views
  • Uploaded on

DataQE. GIS Data Quality Evaluator Version 5.0. DataLOGIC Corporation 72 Dartmouth Avenue Avondale Estates, GA 30002 404-289-4050 www.datalogic-systems.com. DataLOGIC, Inc. Overview. Concepts Types of QA Checks Performed Evaluation Process Future Development. What is DataQE?.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'GIS Data Quality Evaluator Version 5.0' - jesimae


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
gis data quality evaluator version 5 0

DataQE

GIS Data Quality EvaluatorVersion 5.0

DataLOGIC Corporation

72 Dartmouth Avenue

Avondale Estates, GA 30002

404-289-4050

www.datalogic-systems.com

DataLOGIC, Inc.

overview
Overview
  • Concepts
  • Types of QA Checks Performed
  • Evaluation Process
  • Future Development

DataQE – Data Quality Evaluator • 1

what is dataqe
What is DataQE?
  • GIS Data Quality Evaluation Tool
  • Evaluations based on user-specified rules
  • Focuses on evaluations of attribute fields and values
  • Includes:
    • Layer Checks
    • Data Structure Checks
    • Field Checks
    • Query Checks

DataQE – Data Quality Evaluator • 2

what can you evaluate with dataqe
What Can You Evaluate with DataQE?

Compliance

  • Is data compliant with established standards, such as a Data Dictionary?

Completeness

  • Has required data been appropriately populated?

Suitability

  • Is a data source appropriate for a given purpose?
  • Does data make sense from a real-world perspective?

DataQE – Data Quality Evaluator • 3

who can use dataqe
Who Can Use DataQE?
  • Anyone who needs to evaluate the quality or suitability of a GIS data layer or tabular data
    • Data Entry Staff
    • Data Migration Specialists
    • GIS Managers
    • Quality Assurance Staff
    • Analysts

DataQE – Data Quality Evaluator • 4

requirements
Requirements
  • ESRI ArcMap 9.3 or higher
  • Windows 7, Vista or XP
  • Operates in Desktop (Single User) or Enterprise (Multi-User) environments, including Citrix
  • Supports the following Data Formats:
    • Geodatabases (SDE, File, Personal)
    • Shapefiles/Coverages/CAD Files
    • Tables (SQL, Oracle, Access, Excel, DBF, CSV)

DataQE – Data Quality Evaluator • 5

the data evaluation process
The Data Evaluation Process
  • Create Rule Sets containing the rules your data should follow
  • Assign a Rule Set to the data source being evaluated
  • Launch an Evaluation of the data source using the selected Rule Set
  • View Evaluation Results and identify data errors
  • Correct any errors as necessary using ArcMap or other editing tools
  • Re-evaluate as necessary

DataQE – Data Quality Evaluator • 6

layer checks
Layer Checks

Verify commonly used properties within a spatial data source.

  • Data Source/File Name Check
    • Verifies that the name of the evaluated data source name matches a list of valid names
  • Layer Type Check
    • Verifies that the layer type of the evaluated data source matches specified requirements (GDB vs. Shapefile vs. Coverage, etc.)
  • Projection Check
    • Verifies that a layer’s current projection matches established projection requirements

DataQE – Data Quality Evaluator • 7

data structure checks
Data Structure Checks

Verify that a data source’s field structure matches appropriate requirements.

  • Field Exists Check
    • Verifies that required fields exist in the data source being evaluated
  • Field Type Check
    • Verifies that each field is the correct type (Text, Date, etc.)
  • Field Width Check
    • Verifies that each field is the correct width

DataQE – Data Quality Evaluator • 8

field checks
Field Checks

Verify that attribute values within a field match established standards.

  • Required Value Check
    • Verifies that each record in a field contains a value
  • Unique Value Check
    • Verifies that each record in a field contains a unique value
  • List of Values (LOV) Check
    • Verifies that each record in a field contains a value that matches a specified list of values (domain)
  • Valid Range Check
    • Verifies that each record in a numeric field contains a value that falls within a specified range

DataQE – Data Quality Evaluator • 9

query checks
Query Checks

User-defined rules based on customizable queries.

  • Used to perform in-depth evaluations of a data source
  • Query Rules can be created using the DataQE Query Builder, or copied from existing ArcMap or database queries
  • Allows queries to be stored permanently in Rule Sets
  • Can be used to expand basic compliance evaluations to determine whether data meets established Business Rules
  • Can be used by analysts to evaluate whether data is appropriate for a particular purpose
  • Can be used to validate whether data “makes sense”, as opposed to simply meeting data dictionary standards

DataQE – Data Quality Evaluator • 10

data quality evaluator window
Data Quality Evaluator Window
  • View Rule Set Assignments and properties
  • Review Evaluation Results
  • Used to perform evaluations of selected data sources

DataQE – Data Quality Evaluator • 11

slide13

Data Sources

Window

Rule Set

Explorer

Results

Window

Data Quality Evaluator

rule set editor
Rule Set Editor
  • Create Rule Sets
  • Add/Edit rules within a Rule Set
  • Rule Sets can be published and shared between multiple users

Used for managing and editing Rule Sets

DataQE – Data Quality Evaluator • 13

slide15

Rule Set

Explorer

Properties

Window

Rule Set Editor – Properties Window

slide16

Rule Set

Explorer

Layer

Rules

Rule Set Editor – Layer Rule Properties

slide17

Rule Set

Explorer

Field Rule

Properties

Rule Set Editor – Field Rule Properties

slide18

Rule Set

Explorer

Field Rules

Grid

Rule Set Editor – Field Rules Grid

query rule properties
Query Rule Properties
  • Allow users to build custom Query Rules.
  • Query Rule Properties tab helps users build a query statement that can be used to evaluate a field or combination of fields.

DataQE – Data Quality Evaluator • 18

slide20

Rule Set

Explorer

Query Rule

Properties

Rule Set Editor – Query Rule Properties

list of values
List of Values
  • Create new LOV’s
  • Add/Edit Values within an LOV
  • Assign LOV’s to Rule Sets on the Field Rule Properties and the Field Rules Grid tabs.

Used for managing and editing Lists of Values (LOV’s) for Domain Checks

DataQE – Data Quality Evaluator • 20

slide22

Valid Values

Rule Set Editor – List of Values

Rule Set

Explorer

create lov s from existing data
Create LOV’s from Existing Data
  • Create new LOV’s based on unique field values.
  • Specify a field for the LOV value and another field for the LOV description.

Use data from the current ArcMap session or browse for spatial or tabular data.

DataQE – Data Quality Evaluator • 22

evaluation manager
Evaluation Manager
  • Allows creation of Evaluations with pre-assigned properties
  • Easy selection of Data Sources and Rule Sets
  • Evaluation Definitions can be stored & shared
  • Allows definitions to be saved and performed at any time, individually or in batches

Used to manage and edit predefined Evaluation Definitions to support batch processing

DataQE – Data Quality Evaluator • 24

slide26

Properties

Window

Evaluation

Definitions

Window

Evaluation Manager

future development
Future Development

Coming in future versions of DataQE:

  • Associated Tables/Orphan Records Check
  • Metadata Check
  • User Definable Field Rules
    • Business Logic Check
    • Spatial Overlay Check

DataQE – Data Quality Evaluator • 26