Is there a OGC specification on how to implement spatial data storage in a database?
I was looking at the tinydb for spatial data storage, but I was wondering what is a standard way to store spatial data.
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
You need the OGC Simple Feature Specification - SQL Option.
This second part of OpenGIS® Simple Features Access (SFA), also called ISO 19125, is to define a standard Structured Query Language (SQL) schema that supports storage, retrieval, query and update of feature collections via the SQL Call-Level Interface (SQL/CLI) (ISO/IEC 9075-3:2003). A feature has both spatial and non- spatial attributes. Spatial attributes are geometry valued, and simple features are based on two-or-fewer dimensional geometric (point, curve and surface) entities in 2 or 3 spatial dimensions with linear or planar interpolation between vertices. This standard is dependent on the common architectural components defined in Part 1 of this standard.