Questions tagged [postgresql]
PostgreSQL is an open source object-relational database system.
4,288 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
3
votes
0
answers
30
views
Does PostgreSQL/PostGIS on AWS RDS use OSTN15 transformation files for 27700?
I’m running PostGIS 3.4.3 on AWS RDS (PostgreSQL 16) with PROJ 9.5.0 (postgis_full_version() output).
We used to handle UK coordinate transformations outside of PostgreSQL (with ogr2ogr and PROJ 6.x) ...
0
votes
0
answers
29
views
ArcGIS Pro doesn't recognise PostgreSQL spatial property
I have two mirroring deployments (Dev & Prod) of PostgreSQL with PostGIS extension (i.e. not Esri enterprise geodatabase) on AWS RDS servers. The database on Prod was accidently deleted and then ...
0
votes
1
answer
65
views
QGIS Form from PostgreSQL evolutive related value column
In PostgreSQL / PostGIS : I have a layer (L1) related by a list values (LV1).
I'm searching for a way to relate L1 to LV1 which :
Automatically updates LV1 in QGIS if it's updated in PostgreSQL
Does ...
0
votes
0
answers
42
views
QGIS Browse panel "Failed to load layers"
I've run into a quite tricky problem with QGIS Browse panel and maybe someone of you had a similar experience or knows how to solve it.
The situation is as follows: I have a remote PostGIS database ...
1
vote
1
answer
107
views
PostgreSQL/PostGIS : Error No space left on device SQL state: 53100
I want to compare a geoprocessing done in QGIS and PostGIS. It involves a union of two large polygonal vector layers.The processing in QGIS tooks 1.5 hours on a well-equipped workstation (32 GB of RAM)...
0
votes
2
answers
37
views
QGIS, PostGIS. Table layers_styles missing
I'd like to have style(symbology) definitions per layer(geometry) saved in the database. As I understand it I can the just drag in a layer from the PostgreSQL in Browser section. And then I can apply ...
0
votes
0
answers
42
views
MapServer PostgreSQL WHERE clause with UUID column fails
I'm using MapServer with PostgreSQL and I need to be able to limit the query using a UUID field. This column type is not mentioned in the documentation.
I can happily use other field types in the ...
0
votes
0
answers
171
views
Seeking PostGIS docker image for Mac
I need the PostGIS extension to my PostgreSQL database but I cannot find one that will be compatible to my Mac M1,
I also need the vector extension for the PostgreSQL database.
Can you help me?
2
votes
0
answers
37
views
How can I intersect perfectly Graphhopper response with my PostGIS route network
I am working on a GeoDjango project which is linked with the graphhopper API installed locally on my machine. The goal of my project is to offer the user the shortest route (by usins the graphhopper ...
3
votes
0
answers
78
views
Difference between GeoPandas buffer and PostGIS ST_Buffer [closed]
We needed to offload some compute from our PostgreSQL server due to CPU limitations, so I am running some intersection and buffer calculations using GeoPandas which used to be calculated using ...
0
votes
1
answer
74
views
Unable to edit PostgreSQL layers in ArcGIS Pro – Only views are added
I'm facing an issue when connecting my PostgreSQL database to ArcGIS Pro. I am using a user with superuser privileges, so I have full access to the database and its contents, including editing rights.
...
1
vote
0
answers
34
views
Pilcrow ¶ in database fields, "PropertyIsLike" filter gives incomplete results from SLD compared to QGIS
Iis it possible to filter using the SLD with pilcrows present in database fields?
I am trying to use the code below in the SLD to filter for the word "Onbekend" to turn polygons red, but ...
4
votes
2
answers
243
views
Is there any reason why `ST_AsEWKB` can't take a geography type?
ST_AsEWKB is defined like this
bytea ST_AsEWKB(geometry g1);
bytea ST_AsEWKB(geometry g1, text NDR_or_XDR);
While ST_AsEWKT is defined like this,
text ST_AsEWKT(geometry g1);
text ST_AsEWKT(geometry ...
8
votes
1
answer
110
views
Associating original points with Voronoi output in PostGIS
Using PostGIS, what would best associate the source points fed into a ST_VoronoiPolygons call with the returned GEOMETRYCOLLECTION polygons?
I assume using something like ST_Within would work; I'm ...
5
votes
1
answer
137
views
ST_LineSubstring returns incorrect lengths in geography in PostGIS [closed]
I am encountering an issue with the ST_LineSubstring function in PostGIS. Despite the reported fixes in this version, the results remain inconsistent when applying ST_LineSubstring on a geography type....