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.

Filter by
Sorted by
Tagged with
2 votes
0 answers
29 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 &...
user avatar
  • 21
1 vote
1 answer
49 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 (*) ...
user avatar
0 votes
0 answers
28 views

PostGIS 3.1.4 compilation process fails at the linking stage for SFCGAL 1.3.8 on Ubuntu 18.04

I try to build PostGIS 3.1.4 on Ubuntu 18.04 / 64 bit with SFCGAL 1.3.8. SFCGAL was compiled and installed via sudo checkinstall before and the toolkit resides in /usr/local. I have configured the ...
user avatar
  • 3,453
0 votes
0 answers
58 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&...
user avatar
0 votes
1 answer
44 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 ----------------------------------...
user avatar
1 vote
0 answers
95 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:\...
user avatar
  • 201
0 votes
1 answer
82 views

Extracting a subset of pixels from a large raster in PostGIS/ST_Clip result missing values

PostgreSQL: 12.4 (running on Amazon Aurora) PostGIS: 3.0.2 I'm attempting to clip a much larger raster (global meteorological data on a 0.25 degree resolution grid, split into 64x64 tiles, with 9 ...
user avatar
2 votes
2 answers
107 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 ...
user avatar
  • 171
4 votes
2 answers
203 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 ...
user avatar
  • 171
0 votes
0 answers
58 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 ...
user avatar
  • 1,567