Data FormattingSTD_2017v1
Latitude/Longitude Precision Standard
Ensures geographic coordinates have sufficient precision for business use (typically 6 decimal places).
Owner: Unassigned
Updated: 10/31/2025
Business Rule
Insufficient precision leads to inaccurate location tracking and route optimization errors.
Technical Implementation
Store as DECIMAL(9,6) for latitude and DECIMAL(10,6) for longitude. Validate ranges: lat [-90, 90], lon [-180, 180].
Examples
Good practices vs common violations
Good Examples
Lat: 51.507351
Lon: -0.127758
Poor Examples (Violations)
Lat: 51.5 (too imprecise)
Lon: 200 (out of range)
Additional Information
Target Industries
Transportation & LogisticsMiningEnergy & Utilities
Status
activeLocal Network
DQ Improvements
Data quality dimensions improved by this standard
Precision (1 - Recording Accuracy)
highThe degree of accuracy with which data values are recorded or classified.
Type: prevents
Appropriateness
highThe degree to which the format is suitable for use.
Type: prevents
Validity
highThe degree to which data values comply with rules.
Type: prevents
Quick Stats
Related KPIs0
DQ Improvements3
Versionv1
API Access
GET /api/standards/latitude-longitude-precision-standard