Unanswered Questions
922 questions with no upvoted or accepted answers
16
votes
0
answers
1k
views
High PostgreSQL/PostGIS memory and disk usage when saving QGIS project
Why would simply pressing the Save button in QGIS cause my local PostgreSQL instance to cause memory and disk usage to spike to "Not Responding" levels? Seems to me like the PostgreSQL ...
- 18.7k
8
votes
1
answer
1k
views
Loading layer style from PostgreSQL with PyQGIS
I would like to write a Python macro that upon opening my QGIS project file will reload the default style for each layer from the PostgreSQL 'layer_style' table. I have had a look at the documentation ...
CommunityBot
- 1
7
votes
1
answer
505
views
PostGIS ST_Length returns 0 for geographies with high number of decimals
I'm having a weird issue when computing the distance between two geographies using ST_Length (PostgreSQL 10.4, PostGIS 2.4.4). Basically if the number of decimals is above six, ST_Length returns 0 in ...
CommunityBot
- 1
7
votes
0
answers
756
views
PostGIS issue with ST_Clip?
I'm trying to clip a raster using a polygon but I end up with a result that doesn't seem right and where some raster pixels are outside the polygon used for the clip.
See image below where polygon is ...
- 890
7
votes
0
answers
486
views
QGIS doesn't handle PostGis connection resets?
I'm highly frustrated by the fact that if I leave the database alone for a more than a few minutes, I can no longer insert new lines. If I restart QGIS, everything goes back to normal. I believe this ...
- 65.5k
7
votes
0
answers
666
views
Postgis load raster to DB running on AWS RDS with raster2pgsql
I want to perform very common task:
I have Postgresql + Postgis running on Amazon Web Service cloud, using RDS service.
I have there some vector layers and can execute SQL (Postgis) commands via ...
- 65.5k
6
votes
0
answers
308
views
Long QGIS project loading time due to QgsPostgresProvider SQL calls
QGIS 3.22.8 LTR.
Setup
I have a QGIS project file which contains around 100 PostGIS layers, hosted in Azure PostgreSQL (similar to AWS RDS). All layers were added via 'Add PostGIS Layers...' tool (not ...
- 354
6
votes
0
answers
626
views
Retrieve properties for a feature in MVT from JSONB column?
TL;DR Check the last UPDATE section.
We store all of our geometries in a single hybrid PostGIS table and corresponding properties in a single JSONB column. Properties can be anything and differ for ...
- 367
6
votes
0
answers
792
views
Error trying to split a Linestring in PostGis
I'm trying to split a group of Linestrings when they cross a Polygon shape, I'm using the following query:
SELECT
v.*,
c.name,
(st_dump(st_split(v.geom, c.geom))).geom AS geom
INTO table
FROM
...
CommunityBot
- 1
6
votes
0
answers
907
views
PostGIS JOIN table ON ST_Intersects
The following query and subquery help me finding a parcell using a GPS coordinate:
SELECT row_to_json(fc) FROM(
SELECT 'FeatureCollection' As type,
array_to_json(array_agg(f)) As features
...
- 181
6
votes
0
answers
964
views
How to add geometries using EntityFramework 6, EF designer from database, npgsql and postgis?
I have a postgre database with postgis geometries that i would like to access using Entity framework and npgsql. I tried to go for the "EF designer from database" , but when doing so i only get the ...
6
votes
0
answers
192
views
Automatically creating user CRS from postgis in QGIS
I have my custom CRS in table "spatial_ref_sys" in database. When I load layer from schema "public", QGIS create this CRS. But if layer from other schema, it's not. What I need to solve this problem?
- 133
6
votes
0
answers
453
views
Create network graph from contiguous polygons in KML, or PostGIS?
I am using Postgres 9.5 and PostGIS. I have a table with a geometry field. This table has about 200 rows, in each of which the geometry field contains a Polygon.
I would now like to derive an ...
- 3,329
6
votes
0
answers
430
views
Layers created by GeoServer do not display in Mapbender3
I have installed GeoServer 2.7.2 on my local windows 7 machine, which retrieves data from a remote PostgreSQL server. The data is represented in layers just fine!
I also have installed Mapbender3 ...
- 161
5
votes
0
answers
252
views
PostGIS Topology result still has gaps and overlap
I have been trying to build a Topology in Postgis with 4000+ polygons. They are not cleaned, with a lot of gaps and overlaps. After using ST_MakeValid, creating the topology and adding topogeom column,...
- 51