How to determine a spatial columns srid

[patrick28]

Hi Spatial Experts,

What is the best way to determine the srid of an st_geometry column?

I could not find any metadata for an st_geometry column that includes the srid.

Regards,

Patrick

[pfefferf · Accepted solution]

Hello Patrick,

you can determine the Spatial Reference Identifier using method ST_SRID. This method applied to a spatial column returns the SRID.

Regards,

Florian

[patrick28 · Accepted solution]

Hi Florian,

I understand you can do ST_Srid() as in

     SELECT geom.ST_Srid() FROM mytable;

But what about metadata?

E.g. if a table is create as in

     CREATE COLUMN TABLE mytable(geom st_geometry(28992))

No records have been inserted, yet...how do I get the srid of the column?

Patrick

[pfefferf · Accepted solution]

Ok, for that you can use system view ST_GEOMETRY_COLUMNS.