Questions tagged [postgis-3.0]
PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.
13
questions
2
votes
0
answers
96
views
ST_Transform returning different results in PostGIS 2.4 and PostGIS 3.0
I am facing a problem with the function st_transform()and here is my analysis of this pb:
Example of SQL query with different results depending on PostGIS version:
select st_astext(st_transform(...
- 21
1
vote
0
answers
56
views
Discrepancy In PostGIS Transformation: 103761 to 900913 to 4326 vs 103761 to 4326
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
1
vote
0
answers
307
views
PostGIS 2.3 to PostGIS 3 upgrade blocked by changes in ST_Buffer
I'm on a PostgreSQL 10.21 AWS RDS with PostGIS 2.3.7. I need to upgrade PostGIS to PostGIS 3 in order to upgrade PostgreSQL because PostgreSQL 10 is approaching EOL.
When I run ALTER EXTENSION postgis ...
- 3,347
4
votes
2
answers
182
views
Convert datum of elevation data in PostGIS
Is there any specific feature to convert raster values (representing elevation) between basis systems, or do I just have to make do with manually adding the mean offset having looked it up from ...
- 231
1
vote
1
answer
281
views
Reconstructing PostGIS geometry from ST_DumpPoints()?
The PostGIS ST_DumpPoints function seems to have enough data in the return value about the structure of geometries (in the path field):
It returns a set of geometry_dump rows, each containing a ...
- 11k
3
votes
0
answers
261
views
PostGIS breaks after upgrade
I was running PostgreSQL 12 with PostGIS 3.1.1 extension. More than a week ago, I accidentally performed a PostGIS upgrade by running this query
SELECT PostGIS_Extensions_Upgrade(); which returned &...
- 31
1
vote
1
answer
222
views
PyQGIS: Querying PostGIS Table
I am trying to run a query on a PostGIS table via PyQGIS (QGIS3.16-Hannover installed on an Ubuntu 20.04LTS Desktop). Everything works fine if I SELECT ALL FIELDS using the wildcard pattern (*) ...
- 227
0
votes
0
answers
138
views
PostGIS 3.0 ST_PointFromText parse error - invalid geometry
A customer of ours is using PostGIS on AWS RDS (PostGIS 3.0/PostgreSQL 12.7) and is getting the following error when using ST_PointFromText:
ERROR: parse error - invalid geometry
HINT: "POINT(25&...
0
votes
1
answer
81
views
ST_Transform returning different results in PostGIS 2.4.3 and PostGIS 3.0.2
Getting this in 2.4.3
SELECT ST_AsText(ST_Transform(ST_SetSRID(ST_GeomFromText('POINT(-13279706.1692 5957543.84253624)'), 900913), 4326));
ST_AsText
----------------------------------...
- 165
1
vote
0
answers
190
views
pg_upgrade ERROR: could not find function "postgis_sfcgal_version" in file "C:/Program Files/PostgreSQL/13/lib/postgis-3.dll"
I'm trying to pg_upgrade folder data from v12 to v13
"C:\Program Files\PostgreSQL\13\bin\pg_upgrade.exe" --old-bindir "C:\Program Files\PostgreSQL\12\bin" --new-bindir "C:\...
- 201
2
votes
2
answers
398
views
How to efficiently fetch multiple ST_Value from PostGIS raster(s)
I have a raster table with index created by raster2pgsql
CREATE TABLE tbl (rid serial PRIMARY KEY, rast raster);
CREATE INDEX ON tbl USING gist (st_convexhull(rast));
I can see the best way to fetch ...
- 231
6
votes
3
answers
489
views
Using OSTN15 in PostGIS
I'm trying to use the OSTN15 transformation to convert ETRS (EPSG:4258) to OSGB (EPSG:27700).
I have downloaded the NTv2 data from the OS website and extracted into the proj data directory. I have ...
- 231
0
votes
0
answers
107
views
PostGIS Geography Data Changed After pg_restore
Two PostGIS databases (PostGIS 3.0, PostgreSQL 13.1) were setup on two separate machines to be as close to each other as possible using a Docker image kartoza/postgis:13.1.
A dump of the database was ...
- 1,667