I have data stored in PostGIS. When I view its properties in QGIS, it says:
SRS: EPSG:4326 - WGS 84
However, when I want retrieve the SRID value directly using the Find_SRID function, it returns 0. And by looking at the data, SRID is really 0 in PostGIS.
Query:
select * from geometry_columns;
Returns:
f_table_name | f_geometry_column | coord_dimension | srid | type
-----------------+------------------+--------------+-------------------
vector | wkb_geometry | 2 | 0 | POINT
vector | wkb_geometry | 2 | 0 | POINT
buff_out | wkb_geometry | 2 | 0 | POLYGON
buff_out | wkb_geometry | 2 | 0 | POLYGON
Question: Why is SRID for the same data different in QGIS and in PostGIS? How do I get the correct SRID value from PostGIS?
I am using PostGIS 9.5.
geom
refers to the identifier/name of the data's geometry column; it'swkb_geometry
in this case, e.g.SELECT ST_SRID(wkb_geometry) FROM <your_table>