postgis_srs_all
Name
postgis_srs_all — Return metadata records for every spatial reference system in the underlying Proj database.
Synopsis
setof record
postgis_srs_all
(
void)
;
Description
Returns a set of all metadata records in the underlying Proj database. The records will have the
auth_name
,
auth_srid
,
srname
,
srtext
,
proj4text
, and the corners of the area of usage,
point_sw
and
point_ne
.
Availability: 3.4.0
Proj version 6+
Examples
Get the first 10 metadata records from the Proj database.
Code
SELECT auth_name, auth_srid, srname FROM postgis_srs_all() ORDER BY auth_name, auth_srid LIMIT 10;
Output
auth_name | auth_srid | srname -----------+-----------+---------------------------------------------------------------------- EPSG | 10156 | ETRS89 + MSL UK & Ireland VORF08 depth EPSG | 10157 | ETRS89 + CD UK & Ireland VORF08 depth EPSG | 10158 | S34J-IRF EPSG | 10160 | S34J reconstruction east-orientated EPSG | 10162 | JGD2011 / Japan Plane Rectangular CS I + JGD2011 (vertical) height EPSG | 10163 | JGD2011 / Japan Plane Rectangular CS II + JGD2011 (vertical) height EPSG | 10164 | JGD2011 / Japan Plane Rectangular CS III + JGD2011 (vertical) height EPSG | 10165 | JGD2011 / Japan Plane Rectangular CS IV + JGD2011 (vertical) height EPSG | 10166 | JGD2011 / Japan Plane Rectangular CS V + JGD2011 (vertical) height EPSG | 10167 | JGD2011 / Japan Plane Rectangular CS VI + JGD2011 (vertical) height