wambachr Posted November 26, 2020 Share Posted November 26, 2020 (edited) Hi, select ST_Astext(ST_Transform(ST_MakeEnvelope(905014.414896487,6467184.089152194,907460.3998016127,6469630.074057321,3857),4326)); does not work (yet):ERROR: permission denied for relation spatial_ref_sysCONTEXT: SQL statement "SELECT proj4text FROM spatial_ref_sys WHERE srid = 3857 LIMIT 1" this PostGIS tables/views will need r/o access: spatial_ref_sysgeography_columngeometry_columns Regardwalter host: Tommydb: wambachr_osmdb user: wambachr_postgres & wambachr_osmuser Edited November 26, 2020 by wambachr Link to comment Share on other sites More sharing options...
Talk Sick Posted November 26, 2020 Share Posted November 26, 2020 This support request is being escalated to our root admins. Link to comment Share on other sites More sharing options...
Krydos Posted November 26, 2020 Share Posted November 26, 2020 Does it work now? Link to comment Share on other sites More sharing options...
wambachr Posted November 26, 2020 Author Share Posted November 26, 2020 Bingo select ST_Astext(ST_Transform(ST_MakeEnvelope(905014.414896487,6467184.089152194,907460. 3998016127,6469630.074057321,3857),4326)); st_astext ------------------------------------------------------------------------------------------------------------------------------------------------------------------ POLYGON((8.1298828125 50.1205780979601,8.1298828125 50.134664322167,8.15185546875 50.134664322167,8.15185546875 50.1205780979601,8.1298828125 50.1205780979601)) (1 row) Yes, that problem is gone. regardswalter, may be the only user on tommy doing this stuff Link to comment Share on other sites More sharing options...
Recommended Posts