Skip to main content

Questions tagged [postgresql-14]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
85 views

Hard upgrade of PostGIS - no postgis_restore in Ubuntu package

I'm running Ubuntu 22.04 with Postgresql 14 and PostGIS 3.4 installed from the repositories. I'm trying to follow the steps in the PostGIS docs for a hard upgrade of an old database dump. Step three ...
PeteBrew's user avatar
  • 133
1 vote
0 answers
166 views

PostGIS ogr_fdw foreign data wrapper ERROR: column "date" of foreign table 'mytable' converts OGR "String" to "date"

Using the ogr_fdw extension on PG 14 PostGIS 3.2 on Ubuntu 22.04.1 LTS, I am trying to register a foreign table in my local PostgreSQL database based on an OGC API Feature endpoint serving GeoJSON ...
swiss_knight's user avatar
  • 10.5k
3 votes
1 answer
529 views

Storing a large 3D TIN into a PostGIS database

I have to store a massive TIN (1.5 GB) into a PostGIS database to do some computations with it. After my first try, I was getting a "server closed the connection unexpectedly" issue when ...
swiss_knight's user avatar
  • 10.5k
0 votes
1 answer
331 views

PostGIS SFCGAL ERROR: PolyhedralSurface is invalid : inconsistent orientation of PolyhedralSurface detected at edge 0 (0-1) of polygon 3

I am trying to tesselate (yes, in the following case the tessellation is perfectly useless, but it's for the purpose of the example), with the help of ST_Tesselate() from SFCGAL, a polyhedral surface ...
swiss_knight's user avatar
  • 10.5k
2 votes
0 answers
1k views

How to write Shapely polygons (or a multipolygon) to a PostGIS polyhedralsurface

Context In a Python script, I have a 3D square pyramid composed of 4 triangles (a list of 4 Shapely 3D polygons) that I need to store within a PostgreSQL database (+PostGIS). Here's what this pyramid ...
swiss_knight's user avatar
  • 10.5k