[postgis-devel] spatial_ref_sys view
Sandro Santilli
strk at kbt.io
Fri Feb 4 10:37:41 PST 2022
On Fri, Feb 04, 2022 at 01:27:40PM -0500, Regina Obe wrote:
> but the fact that many do
>
> INSERT INTO spatial_ref_sys VALUES (a....)
Not only "many do", but OGC standard dictates exact
structure of that view/table:
file:///tmp/mozilla_strk0/06-104r3_Candidate_Implementation_Specification_for_Geographic_Information_-_Simple_feature_access_-_Part_2_SQL_option_v1.2.0.pdf
Excerpt:
7.1.2.2 Table constructs
The following CREATE TABLE statement creates an appropriately structured SPATIAL_REF_SYS table.
This table may be an updatable view of an implementation-specific table.
Implementations shall either use this table format or provide stored procedures to create, to populate and to maintain this table
CREATE TABLE SPATIAL_REF_SYS
(
SRID INTEGER NOT NULL PRIMARY KEY,
AUTH_NAME CHARACTER VARYING,
AUTH_SRID INTEGER,
SRTEXT CHARACTER VARYING(2048)
)
My proposal is the "updatable view".
--strk;
Libre GIS consultant/developer
https://strk.kbt.io/services.html
More information about the postgis-devel
mailing list