Determine if an srid refers to a geodetic CRS

Richard Huesken <[email protected]> Tue, 29 Apr 2025 21:21:46 +0200
Newsgroups gmane.comp.gis.postgis
Message-ID <CAMjmB9q2bu7SoChq-h-dQD0ofsPC9r6jdgH414NeTbETzssEvg@mail.gmail.com>
Hi,

I'm wondering if there is an easy way to detect if an srid refers to a
geodetic CRS, by checking the spatial_ref_sys table.

1) Would it be safe to assume the srid is a geodetic CRS if the value in
the srtext column starts with 'GEO'? It almost seems to be too good to be
true...

2) Did I overlook a Postgis function that returns this information (and if
so, which one would that be)?

Thanks in advance,

Kind regards
Richard.