2

The SRID metadata is showed by, e.g., this web page:

Definition: Well Known Text (WKT)

PROJCS["UTM Zone 24, Northern Hemisphere",
GEOGCS["GRS 1980(IUGG, 1980)",
DATUM["unknown",
SPHEROID["GRS80",6378137,298.257222101],
TOWGS84[0,0,0,0,0,0,0]],
PRIMEM["Greenwich",0],
UNIT["degree",0.0174532925199433]],
PROJECTION["Transverse_Mercator"],
PARAMETER["latitude_of_origin",0],
PARAMETER["central_meridian",-39],
PARAMETER["scale_factor",0.9996],
PARAMETER["false_easting",500000],
PARAMETER["false_northing",0],
UNIT["Meter",1],
AUTHORITY["epsg","6211"]]

This information is on my local database, but how can I see it?

A function like SRID_AsText(srid). Or some complex PostgreSQL query over all PostGIS tables to see the SRID metadata?

3

This page should have what you're after, the spatial_ref_sys table in PostGIS:

https://postgis.net/docs/using_postgis_dbmanagement.html#spatial_ref_sys

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.