01
Data & field validation
- Invalid ACE field default values
- String fields without a defined size
- Invalid unset values
Free download
SEPM DataCheck
Read-only diagnostics for Smallworld GIS
A GIS database can look perfectly fine and still hide inconsistencies. SEPM DataCheck scans your Smallworld database, identifies known data-quality issues and gives you a clear report of what needs attention.
What it does
- Searches for known database and configuration issues
- Reports records examined and findings detected
- Writes detailed results to a tab-separated logfile
- Never modifies your data
Who it is for
Smallworld administrators and GIS specialists who want to find suspicious conditions before upgrades, migrations, exports or data-model changes.
Currently available for Smallworld. Support for PostGIS and other GIS environments is planned.
Data check
RunningSource dataset
Structure scan
Integrity pass
Catch issues before they travel downstream
How to get it
DataCheck is distributed through mySEPM and free for the GIS community. Create your free SEPM account to unlock the download.
Free download. Registration required.
Create free accountAfter registration, your DataCheck download becomes available in your SEPM account.
Before & after
Bad data shouldn't keep you awake.
Smallworld databases can accumulate hidden inconsistencies over time — from invalid geometries and coordinate-system definitions to corrupt styles or unexpected field values.
Before“Why is my data doing this?”
SEPM DataCheck
After“0 errors. Good night.”
SEPM DataCheck scans your Smallworld database, identifies known data-quality issues and gives you a clear report of what needs attention.
Run the checks.Fix what matters.Sleep better.
What it is
Know what's hiding in your Smallworld data.
A GIS database may look perfectly fine in everyday use while still containing inconsistencies that only become visible during upgrades, migrations, exports or unusual workflows.
SEPM DataCheck is a read-only diagnostic tool for Smallworld GIS that systematically searches for known database and configuration issues.
It does not modify your data. Instead, it scans the system, reports its findings and creates a consolidated logfile for further analysis.
Where hidden issues surface
- Upgrades
- Migrations
- Exports
- Unusual workflows
- 01
Scan
Systematically searches the database for known database and configuration issues.
- 02
Report
Reports how many records were examined and how many findings were detected.
- 03
Logfile
Writes a consolidated logfile for further analysis.
Your data stays untouched
Where it comes from
From real support cases to reusable checks.
DataCheck grew out of SEPM's experience with real Smallworld support cases. Instead of investigating the same difficult database problems repeatedly, SEPM turns suitable findings into reusable diagnostic checks.
The original concept is simple: a growing library of scripts for detecting Smallworld database issues, based on problems encountered in SEPM support.
Support case
A difficult database problem appears in a real Smallworld system.
Investigation
SEPM works out what went wrong and why.
Reusable check
Suitable findings become a diagnostic check.
Growing library
Every check can now run against any database.
What it looks for
What does SEPM DataCheck look for?
Current checks cover areas such as data and field validation, geometry and database configuration.
3 checks
02
Geometry
- Free geometries
- Inconsistent coordinate systems
- Overlapping busbars
- Corrupt or inconsistent geometry field mappings
- Invalid sector start/end coordinates
03
Database & configuration
- World owners without a corresponding world
- Corrupt RWO styles and missing or corrupt substyles
The library keeps growing as new support cases become reusable checks.
Informational — not errors
Geometry statistics
DataCheck can also collect geometry statistics. These are informational diagnostics rather than errors and can help you understand unusual characteristics of a database before they become problems.
Line lengths
Spot unusually short or long line geometries.
Geometry coordinate counts
See how complex geometries really are.
Area statistics
Understand the spread of area geometries.
Built for scale
Scan large databases. Focus on the exceptions.
DataCheck turns a large Smallworld database into something much easier to reason about: records checked, issues found, and a logfile showing where to look.
SEPM test run
- Records examined
- 0
- Findings detected
- 0
0.22%of records need attention
Across multiple diagnostic checks in one current SEPM test run.
Geometry statistics engine
- Records
- 0
- Databases
- 15
- Collections
- 460
Scanned in a single shared pass for broader geometry analysis.
Read-only by design
A diagnostic tool, not an automatic repair utility.
DataCheck helps administrators and GIS specialists find suspicious conditions while leaving the database untouched.
Database access
- Reads and analyses recordsYes
- Modifies dataNever
- Repairs automaticallyNever
Useful before
- Smallworld upgrades
- Migrations
- Data exports
- Data-model changes
- Troubleshooting
- Quality reviews
Clear results
Clear results instead of guesswork.
Each check has its own stable DataCheck identifier, such as SDC-GEOM-001 or SDC-STYLE-002. A run reports how many records were examined and how many findings were detected, while detailed results are written to a tab-separated logfile.
So instead of
“Something seems wrong with this database.”
you get
“This check examined these records, found these issues, and here is where they are.”
DataCheck run
Complete- Records examined
- 131,167
- Findings detected
- 295
Stable check IDsSDC-GEOM-001SDC-STYLE-002
datacheck.logTab-separated
| check_id | collection | record | finding |
|---|---|---|---|
| SDC-GEOM-001 | cable | 48213 | free geometry |
| SDC-GEOM-001 | busbar | 10977 | free geometry |
| SDC-STYLE-002 | cabinet | 3312 | corrupt RWO style |
| SDC-STYLE-002 | substation | 775 | missing substyle |
Illustrative logfile excerpt · totals from an SEPM test run
SEPM DataCheck
Better data starts with knowing what's wrong.
Run SEPM DataCheck before hidden inconsistencies turn into migration, upgrade or integration problems.
Find the problems. Understand your data. Sleep better.
Distributed through mySEPM · Free download · Registration required