Skip to main content
Geographic Information Systems

Questions tagged [postgresql]

Ask Question

PostgreSQL is an open source object-relational database system.

4,294 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
22 views

So I’m trying to create an enterprise geodatabase in ArcGIS Pro, and it keeps telling me that it was unable to access the st_geometry library. I already downloaded the ST_geometry.llb file and placed ...
Ana Amaral's user avatar
  • 1
1 vote
0 answers
30 views

Same question as Storing metadata in PostgreSQL? but for QGIS. How could we store metadata in PostgreSQL and load it automatically when loading a layer in QGIS? Idea is then to push it back to QGIS ...
Nono's user avatar
  • 493
0 votes
1 answer
126 views

I am attempting to add a parquet file to a PostgreSQL/PostGIS database and I keep getting this error. ogr2ogr -f PostgreSQL PG:"host=localhost user=docker password=docker dbname=gis port=5432&...
Brian Bergstrom's user avatar
  • 43
1 vote
0 answers
34 views

I'm developing a PostgreSQL–PostGIS database on a remote server. I’ve already created all the necessary layers and their attribute forms in QGIS. I now want to use it with QField. When my Android ...
user328884's user avatar
  • 11
1 vote
0 answers
67 views

I'm working with PostgreSQL in QGIS and have a Python script that runs when the QGIS session starts. Right now, the PostgreSQL connection requires authentication first, and only after that, the Python ...
Giene's user avatar
  • 1,027
1 vote
1 answer
85 views

I used osm2pgsql to create an OSM PostgreSQL database for my region. Now I want to extract data of different types within smaller areas. I can extract the nodes and ways within my bounding box using ...
Aaron Bramson's user avatar
  • 1,023
5 votes
0 answers
127 views

Currently, when opening attribute tables with a large number of features, QGIS 3.44 becomes very slow and sometimes unresponsive. This happens even on high-end hardware, which suggests the bottleneck ...
Al Francis Cardano's user avatar
  • 51
0 votes
0 answers
52 views

I am using QGIS 3.40.11 with QField Sync 4.17.3 and QField 3.7.7. My layers are stored in a PostgreSQL database. A few days ago everything was working fine, but today when I synchronized, I received ...
etorresm's user avatar
  • 61
3 votes
1 answer
148 views

I work with QGIS and PostGIS. With PostGIS, I ran an SQL script that contains a section dedicated to aggregation geoprocessing: from multiple source data, each containing a unique ID, this allows to ...
user35117's user avatar
  • 1,106
1 vote
0 answers
72 views

I would like to show the layer PostgreSQL comment (comment on table "xxxxx") when I move mouse over the layer name in the browser Panel Exploring:
User's user avatar
  • 347
3 votes
0 answers
43 views

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) ...
Dominik Zulovec Sajovic's user avatar
  • 31
0 votes
0 answers
41 views

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 ...
user322637's user avatar
  • 1
1 vote
1 answer
74 views

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 ...
User's user avatar
  • 347
0 votes
0 answers
54 views

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 ...
PajdaCom's user avatar
  • 1
1 vote
1 answer
183 views

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)...
user35117's user avatar
  • 1,106
0 votes
2 answers
59 views

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 ...
user3532232's user avatar
  • 101
0 votes
0 answers
52 views

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 ...
JasonB's user avatar
  • 9
0 votes
0 answers
208 views

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?
Oded k's user avatar
  • 1
3 votes
0 answers
53 views

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 ...
realmoz3xer's user avatar
  • 31
3 votes
0 answers
88 views

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 ...
maximosis's user avatar
  • 31
0 votes
1 answer
100 views

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. ...
james madisson's user avatar
  • 3
1 vote
0 answers
43 views

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 ...
TMSupportR's user avatar
  • 11
4 votes
2 answers
259 views

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 ...
Evan Carroll's user avatar
  • 7,259
8 votes
1 answer
132 views

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 ...
Lucas's user avatar
  • 83
5 votes
1 answer
159 views

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....
Jordan's user avatar
  • 51
2 votes
1 answer
63 views

I am importing 4 staates from OSM into a PostgreSQL database like this osm2pgsql -d $DB_NAME -U $DB_USER -C 4000 -r pbf -O pgsql -S ${GIT_DIR}/style/style_osm_20250326.style ${WORK_DIR}/bremen-latest....
dancesWithCycles's user avatar
  • 125
1 vote
0 answers
37 views

I am importing 4 staates from OSM into a PostgreSQL database like this. osm2pgsql -d $DB_NAME -U $DB_USER -C 4000 -r pbf -O pgsql -S ${GIT_DIR}/style/style_osm_20250326.style ${WORK_DIR}/bremen-latest....
dancesWithCycles's user avatar
  • 125
1 vote
1 answer
109 views

When trying get data from an OGC Features API into PostGIS, using GDAL ogr2ogr, it seems to be capping out at 300,000 features being loaded. The endpoint is https://environment.data.gov.uk/geoservices/...
Tim R's user avatar
  • 75
0 votes
1 answer
51 views

I have a web application based on ArcGIS API for Javascript 3. In the web application a QueryTask is executed on a MapServer feature layer. The result feature set is used to create a Feature Layer and ...
Andžej Miloš's user avatar
  • 101
1 vote
1 answer
56 views

I use the osm2pgsql-replication script to maintain a set of PostgreSQL tables from a single Geofabrik download .osm.pbf file, containing OSM data for a single geographic region in NW England. These ...
Libarch's user avatar
  • 125
0 votes
0 answers
62 views

I would like to make it as easy as possible for a QGIS user to insert a geopackage in a PostgreSQL connected database. But I also want to trigger a function to make a clone of the inserted table to ...
Rik De Hoop's user avatar
  • 1
1 vote
1 answer
416 views

I have a PostgreSQL database with PostGIS installed version 2.5.5 We use RDS and our PostgreSQL version will soon be deprecated, to upgrade our PostgreSQL version it's necessary to upgrade PostGIS. ...
Goncalves's user avatar
  • 21
1 vote
1 answer
56 views

geopandas.read_postgis return empty records while Django unittest, although Django ORM can read them. Plus, when I connect to db running as a container, there are no records when selecting in db for ...
taro's user avatar
  • 11
1 vote
0 answers
47 views

I am creating new projects in QGIS using a plugin called PlotCut. This plugin helps to clip specific polygons out of a layer image. It also performs some calculations to provide the number of pixels ...
Bryan's user avatar
  • 11
0 votes
0 answers
26 views

After passing the syntax check, and correcting all errors in the configuration file named ETL.xml, these problems occurred. The UML model was created in Enterprise Architect 15 (.eap extension) and I ...
Sergej Lav Bojanić 2022's user avatar
  • 13
0 votes
1 answer
406 views

Syntax validation has processed all the way to the target itself. There was a problem that if I fix it I get the product, the configuration validator says: cvc-complex-type.2.3: Element 'Target' ...
Sergej Lav Bojanić 2022's user avatar
  • 13
1 vote
2 answers
113 views

I am doing a transformation from UML model to DDL SQL (databaseSystem is PostgreSQL). I configured the configuration xml file. I believe that it is not necessary to state what is in it, but I will ...
Sergej Lav Bojanić 2022's user avatar
  • 13
2 votes
2 answers
190 views

I'm designing a system where there is a set of polygons representing different postal codes (not overlapping with each other). An user can either draw his own polygon OR fully select/deselect ...
Bartłomiej Wierciński's user avatar
  • 23
0 votes
0 answers
81 views

Out of the blue, two table in my PostGIS are being flagged for multiple users as needing the data source repaired. The permissions, schema and database have not changed. Navigating to the table in the ...
I_suck_at_sql's user avatar
  • 1
4 votes
1 answer
130 views

I use ST_DWithin in a WHERE clause. The row estimate is always 1. Independent of center point and radius. This causes problems in more complex queries because the query planner uses nested loops ...
Chris's user avatar
  • 41
1 vote
1 answer
74 views

Problem (or at least I think it is a problem): If I set the raster folder to include 3 or 4 GeoTIFFs of ~ the same size and the 1st one uploads in 30 minutes, why would the next one take 90 minutes? *...
Mike Peckham's user avatar
  • 11
0 votes
0 answers
95 views

I want to create a tool that allows me to use a source layer to retrieve the parcels contained in the selected commune from my PostgreSQL database. When I use layer actions, everything works fine. But ...
Aurélien ROBERT's user avatar
  • 1
2 votes
0 answers
55 views

I am attempting to write a function which will use PostGIS to group geometric points based off the bounding box passed to the function. I created the following table: CREATE TABLE items ( id ...
Mick's user avatar
  • 21
0 votes
1 answer
294 views

I am attempting to migrate/export an existing geodatabase into an existing database that I created in pgAdmin. When I attempt to transfer tables inside my existing geodatabase into my PostgreSQL ...
Connor Garrett's user avatar
  • 65
2 votes
0 answers
2k views

I want to install PostGIS with the Stack Builder 4.2.1 for PostgreSQL 17. However, I dont have the option of choosing PostGIS. The category "spatial extension" is simply missing. A ...
Lina's user avatar
  • 253
2 votes
1 answer
92 views

I have a table of POIs which are simple Points I would like to know each time a POI is close to the polyline. I would like to get the number of meters from the start of the polyline each time a POI is ...
ybert's user avatar
  • 123
0 votes
0 answers
121 views

I have table in multiple schemas, the table in all schemas have the same columns number and type so i'm trying to combine all table data into view table using UNION ALL as shown CREATE VIEW "...
Abdullah Muthanna's user avatar
  • 65
1 vote
0 answers
108 views

When migrating from PostGIS 2 to PostGIS 3.4, I found out that my old solution for overwriting the proj4text column in the spatial_ref_sys table did not work anymore. The reason for this is that ...
D H's user avatar
  • 11
0 votes
1 answer
110 views

We’re working with QGIS connected to PostgreSQL, and the data is huge—more than 5 million features. We decided to use ArcGIS Enterprise Pro, and we need it to connect to these QGIS (PostgreSQL) ...
Abdullah Muthanna's user avatar
  • 65
2 votes
1 answer
80 views

I'm building a QGIS model for calculating isochrones with PostGIS. I can input multiple time values in the model by typing something like '5,10,15' (these are minutes for calculating) into a string ...
Freestyle Season's user avatar
  • 43

1
2 3 4 5
…
86