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 agree to our terms of service, privacy policy and cookie policy

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