All Questions
Tagged with postgresql coordinate-system
74
questions
3
votes
1
answer
187
views
SRID in PostGIS -> ST_SRID !== Find_SRID
i am trying to understand why I get two different values for
those two Querys (to a PostGIS db)
SELECT ST_SRID(ground_geometry) FROM cjdb.city_object LIMIT 1;
select Find_SRID('cjdb', 'city_object', '...
- 237
1
vote
0
answers
148
views
Discrepancy In PostGIS Transformation: 103761 to 900913 to 4326 vs 103761 to 4326 [closed]
Overview
I'm using PostGIS 3.1 on PostgreSQL 12.14 and I'm facing an issue with GIS data transformation and I need some assistance in understanding the cause of a significant discrepancy between two ...
- 119
0
votes
0
answers
75
views
Transform raster of unknown SRID using proj4 in PostGIS
In PostGIS is there any way to transform raster of unknown SRID using proj4 to EPSG:3857 without dumping polygons?
2
votes
1
answer
139
views
How to fix 'BOOM! Could not generate outside point' error when using ST_Distance_Spheroid with different SRS in PostGIS
I am trying to calculate the nearest feature distance from a point using PostGIS ST_Distance_Spheroid function.
Case 1:
The point and the feature collection are in the same SRS and I am expecting the ...
- 47
1
vote
0
answers
124
views
How do I get the distance between two points in meters with different SRIDs in PostGIS? [closed]
I purchased an address-point database (string, geom with SRID 2914) from my local county GIS provider, and I am trying to find the distance between a point in this database and a point with SRID 4326. ...
- 11
0
votes
0
answers
14
views
Different polygon placement between GeoServer versions for the same data [duplicate]
I have a database with a table containing 27700 geometry polygons on an Azure managed Postgres database.
I've also got two GeoServer instances with layers created from that same table, but on one of ...
- 151
0
votes
2
answers
736
views
How to change coordinate system in PostGIS database: alter, transform or update?
I created an empty database in PostGIS and I need to change the coordinate system from EPSG:4326 to EPSG:32632. I am confused if I should be transforming, altering or updating? Also, how do I know ...
1
vote
2
answers
66
views
PostGIS create view outputs without projection
I uploaded a shapefile through the postGUI. It contains an EPSG code projection. When I want to create a view based on a selection of N-South roads. What is missing?
CREATE VIEW shapefiles."...
- 389
1
vote
0
answers
880
views
PostGIS: ST_Transform error
I have a table (tbl1) containing POINT geometries in EPSG:27700 (British National Grid).
SELECT id, ST_AsText(geom) as geom FROM tbl1;
=
id | geom
------+--------
1 | POINT(363179.79 176400.12)...
- 1,839
2
votes
1
answer
1k
views
Avoiding this PostGIS error: "Coordinate values were coerced into range [-180 -90, 180 90] for GEOGRAPHY"
I have:
a table crashes with data on car crashes in nyc
a table locations with data on the locations of NYC schools
Both have latitude and longitude columns.
I'm trying to generate a table with one ...
6
votes
1
answer
2k
views
ST_Transform error: latitude or longitude exceeded limits(-14)
I am trying to run a query in PostGres on a multiline spatial feature class table. Among other things, I am trying to use PostGIS to get the shape length of the reprojected geometry. My query looks ...
- 1,913
4
votes
1
answer
899
views
ST_DWithin is returning all the data in the table
I am new to PostGIS and currently struggling with ST_DWithin function.
I have a table stores, which stores lat and long of locations in Denmark in the location column as geometry and with SRID 4326.
...
- 43
5
votes
1
answer
296
views
Reprojecting in PostGIS not working as expected
I just reprojected with PostGIS tree layers using this function:
select UpdateGeometrySRID('schema', 'table', 'geom', 3857)
These tree layers are contiguous. The problem is, when I open it on QGIS to ...
- 313
0
votes
1
answer
367
views
Which coordinate reference system should I use to have more precision while calculating polygon area? 4326 or convert to the one specific to my area?
We are saving our drawn polygons in our database with the coordinate system 4326.
The polygons drawn are all in Spain (where I came to find out the adequate coordinate system for Spain is EPSG:2062).
...
3
votes
2
answers
297
views
How to manage different SRID data in same database table? [closed]
My data is in two different cities and three different EPSG code area. (Database is PostgreSQL/PostGIS.)
So I think, I can not set SRID values by data. Making 3 different table is difficult. How can ...
- 1,714