Re: Qgis/Postgis : Multi Union (25 polygonal layers)

id and/or using an explicit order by on res_id > when building res_assoc could make the processs more stabke ? > > -- > *From:* Martin Davis > *Sent:* Friday, July 11, 2025 21:24 > *To:* celati Laurent > *Cc:* postgis-users@lists.osgeo.org > *Subject:* Re: Q

Overlay of overlapping polygonal datasets : postgis bug/lack of reliability/stabilization ?

Good afternoon, I'm taking the liberty to write a message beacause i feel a bug with postgis. As part of a "Overlay of overlapping polygonal datasets" usecase. >From 28 postgis polygon vectors.I try to node and polygonize to make a flat coverage, and then join back to the parent layers to determi

Re: Qgis/Postgis : Multi Union (25 polygonal layers)

overlay > the small layers first, and then overlay that with the big layer. And if > you don't care about overlaps in the big layer (or if there are none), that > makes it much easier, since you can process each big-layer polygon > independently (and ideally in parallel). > >

Qgis/Postgis : Multi Union (25 polygonal layers)

Dear all, I'm working with QGIS and PostGIS. As input, I have 25 polygonal layers covering a large area (multicities area). One of these data is a very large dataset (1 million objects). The other 24 are much smaller (a maximum of a hundred objects). For information, I should point out that some of

Postgreql/postgis : Error No space left on device SQL state: 53100

Dear all, 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). I was never able to complete

Re: Postgreql/postgis : Error No space left on device SQL state: 53100

mes all of your > disk drive and then frees it back up during crash handling. Please get > someone to write the query to correctly do what you meant to do instead. > > On Tue, Jun 24, 2025 at 12:37 PM celati Laurent > wrote: > >> <https://gis.stackexchange.com/posts/494

[postgis-users] (no subject)

Good morning, I have 5 postgis tables which have different types of geometries (1 point, 1 linear, 3 polygon). And also different field structures. These tables share fields that provide the same information (project_monitoring, municipality, etc.). Although the name of these fields is not always

[postgis-users] Repeat operations on 50 tables of the same schema?

Good morning, I am new to Postgresql. I have 50 tables into a "ign" schema (schema other than public). I would like for each of these 50 tables: - Add a prefix to the name of the table: "IGN_bdTopo_" - Add a suffix to the table name: "_V1" - create a new "date" column of date type. And populate th

[postgis-users] Postgresql/Postgis: Trigger for historization/versioning

Good evening, I work with Postgresql 13, Postgis and Qgis 3.22. My need is to set up within my Postgis database (used for maps production), triggers for automation of data historization/versioning. The idea: For instance within a table 'BOREHOLE' (geometry: points), different updates of the table a

[postgis-users] Postresql/postgis/qgis : assign privileges only for access/reading tables ?

Good morning, I work on Postgresql/postgis and Qgis. I had created a superuser account for me. In qgis, I can see the postgis schemas and tables and browse the tables without problem. This time, i created another simple user account just to be able with qgis to access and load the table in qgis

[postgis-users] Postgis trigger : table and materialized view

Good evening, I have a postgis polygons table for my "cities". I have a point table for my "boreholl". I created a "mv" materialized view defined by a spatial join as follows: SELECT boreholl.*, > cities.gid, > cities.insee_id, > cities.name > FROM boreholl, cities > WHER

[postgis-users] st_concav_hull : error message & speed up the process?

Dear all, >From a lidar las file (cloud Point), i converted the raw .las file toward a shapefile thanks to lastools (las2shp). Then, i imported the MULTI POINT cover (109 rows) file into a postgis db. In a first time, my goal is to generate for each row, a concave hull. I succeed in launching ST

[postgis-users] Which tool/referecence for adress geocoding ?

Dear all, i have to geocode several corporates sites ( a big excel file). I would like geocode this file thanks to the adress. 1/ Could you tell me the best tool for this task (accuracy, performance,ease of use,etc.). On my station, i have *Postgis, Qgis, mapinfo. * 2/ is it better to use a web

Re: [postgis-users] ST_intersects : valeurs champs?

Bonjour, Merci à vous pour vos conseils. Vous aviez raison. En utilisant le layer départements la requete fut bien plus rapide. J'ai donc écrit cette requete : - CREATE TABLE example_intersections_a_v2 AS SELECT part_2.geom,field_1,field_2,field_3 FROM fra_adm2 AS part_1,france_merge_

Re: [postgis-users] ST_intersects : error message

Bonjour, Merci beaucoup pour votre réponse. Pour etre plus clair : J'ai un layer polygonal représentant les limites admin nationales de la France. Il s'agit d'une seule entité. Et mon autre donnée est en effet un fichier de points LIDAR vraiment énorme (>re à 2 millions de points) distribués sur p

Re: [postgis-users] ST_intersects : error message

I imported my 2 layers into db thanks to postgis tools. An spatial index has been created after the loading automatically. Indeed, via my qgis DB manager, i can confirm the spatial index creation for my two tables... -- View this message in context: http://postgis.17.x6.nabble.com/ST-inte

Re: [postgis-users] ST_intersects : error message

Hello, Ok sorry for the mistake. So please read the correction : --- CREATE TABLE example_intersections_a AS (SELECT ST_Intersection (part_1.geom, part_2.geom)FROM fra_adm0 AS part_1,france_merge_pts1 AS part_2 WHERE ST_Intersects(part_1.geom, part_2.geom)); ALTER TABLE examp

[postgis-users] ST_intersects : error message

Hello, I have 2 tables : one points and one surface. I would like intersects the geometries. I write the query but i have an error message : -- CREATE TABLE example_intersections_a AS (SELECT ST_Intersection (part1.geom, part2.geom)FROM fra_adm0 AS part_1,france_merge_pts1

[postgis-users] Postgis raster : jfif? jp2?

Dear all, I would like import a world raster DEM in my postgis db. I would like use raster2pgsql. When i try to convert the jp2 file or jfif file to the .sql, i have an error message saying "Unable to read raster". When i type: raster2pgsql -G , the jpeg jfif seems to be in the list. Why i have

Re: [postgis-users] Qgis/Postgis : impossible to open a project

@ Morten : Thank you for your help. I succeed in loading without any problem my qgis project through qgis from my station hosting the postgrsql server. But i can't do it from another station. From other station, the error message that i put previously. Another thing. I opened my qgis project th

Re: [postgis-users] Qgis/Postgis : impossible to open a project

I paste below the usefull sentences from my postgresql.conf: -- listen_addresses = '*' # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to 'lo

Re: [postgis-users] Qgis/Postgis : impossible to open a project

@ Nicolas : i put the CIDR mask after the address in the file. In vain... @ Morten : Yes i'm sure : i saved the pg_hba.conf. correctly Please find below the error message when i open my qgis project from one of remote station :

Re: [postgis-users] Qgis/Postgis : impossible to open a project

Dear Nicolas, You 're right. The pg_hba.conf file is in the C:\ProgramFiles\PostgreSQL\9.1\data folder. I tried to modify it to : # IPv4 local connections: hostall all 192.167.40.0/24 trust hostall all 192.167.40.92 tru

Re: [postgis-users] Qgis/Postgis : impossible to open a project

Hello, So. In the folder C:\Program Files\PostgreSQL\9.1\share, i have a file called "pg_hba.conf.sample". Please find below the raw sentences : -- # IPv4 local connections: hostall all 127.0.0.1/32@authmethod@ # IPv6 local connections: ho

Re: [postgis-users] postgis raster : viewer with qgis 2.0?

Hello, Thanks for your reply. For your information, the "add to canvas" seems to work fine. But no the drag and drop to the list of layers... IMAGE. -- View this message in context: http://postgis.17.x6.nabble.com/postgis-raster-viewer-with-qgis-2-0-tp5004218p5004223.html Sent from the Po

[postgis-users] postgis raster : viewer with qgis 2.0?

Hello, I would like load postgis raster data with qgis 2.0. But i can't find the usefull extension. Before with qgis 1.8 there was an extension called gdal postgis raster loader. Could you throw light for me. Regards. Laurent Celati. -- View this message in context: http://postgis.

[postgis-users] Qgis/Postgis : impossible to open a project

Hello, My windows 7 station hosts a postresql/postgis server (9.1). On this station i succeed in saving a qgis (1.8) project with several postgis layers (vector). I saved this qgis project on our network. So i thought to be able to open this project from any station. But when i try to do that, i

Re: [postgis-users] How to test gdalinfo for my postgis 's gdal ?

Hello, Thank you. Indeed. I did not think to tape this query. Thank to that query i know the gdal version. But moreover, i would like tape a gdalinfo --formats in order to read the list of supported formats & check if there is the ECW driver in the list. I would know if my postgis 's gdal has bee

[postgis-users] How to test gdalinfo for my postgis 's gdal ?

I would like know information regarding gdal version used by my postgis.i would like test my postgis gdal version with gdalinfo . But how to find the .bat file in the in order to tape gdalinfo --formats ? Where is the command file in the postgis directory? In advance thank you. Regards.

Re: [postgis-users] import .ecw into postgis database ?

Hello Paolo. I understand what did you say. ok, i stop to write message in this mailing list. I am obliged to use ecw files. My client works with ecw and I did not convert data ecw. I know how to compile gdal svn version with visual studio... So i will ask to gdal dev..ok thank you. Bye.

Re: [postgis-users] import .ecw into postgis database ?

Hello, Yes, when i do gdalinfo--formats, ecw is not in that list. My gdal comes from osgeo4w install setup. On a other station i have qgis. And when i browse a ecw raster, the browse of any ecw seems works... -- View this message in context: http://postgis.17.n6.nabble.com/import-ecw-

Re: [postgis-users] import .ecw into postgis database ?

Hello, please find below a SS of my prompt command when i taped gdal info : SS_error_gdalinfo.JPG Thank you to throw light for me. Regards. -- View this message in context: http://postgis.17.n6.nabble.com/import

Re: [postgis-users] import .ecw into postgis database ?

Hello, Thanks. Pierre, please read the following message when i try ro import into my db a .ecw file thanks to raster2pgsql: SS_error_ecw.JPG So it seems my raster2pgsql can't load ecw file. For information, i succeed last y

[postgis-users] import .ecw into postgis database ?

Hello, I'm working on windows 7 64bits. I would like import into my db several .ecw files. Up to now i have followed this following tutorial : http://trac.osgeo.org/osgeo4w/wiki/pkg-gdal-ecw I have installed the ECW SDK and paste the *dll from redistributable\vc90\win32\ to C:\Windows\SysWOW64.

[postgis-users] Upgrade to postgis 2.1 : error message

Hello, Thanks to your following message, i'm following the part of the doc regarding the upgrade called " 2.9.1.2. Soft Upgrade 9.1+ using extensions ". In a 1st time i tied to tape this sql query : ALTER EXTENSION postgis UPDATE TO "2.1.0SVN"; ALTER EXTENSION postgis_topology UPDATE TO "2.1.0

[postgis-users] Upgrade postgis 2.0 to postgis 2.01 or 2.02 ?

Hello, Up to now, i have worked with Postgis 2.00 for PostgreSQL 9.1 (x64) on windows 7. I would like upgrade upgrade my postgis version toward 2.01 or 2.02. *Could you tell me how to upgrade my postgis version please? In advance, thank you to throw light for me. Regards. -- View t

Re: [postgis-users] ST_SetSRID

Hello, -- SELECT postgis_full_version() "POSTGIS="2.0.0 r9605" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER" --- Yes, yesterday i trie

[postgis-users] ST_SetSRID

Hello, I tried to reproject one of my postgis raster layer (called 'bd_ortho') from SRID 2154 to SRID 4326 . It seems work. But the metadata are not updated. Indeed when i tape SELECT ST_SRID(rast) As srid FROM bd_ortho WHERE rid=1; The result is always 2154. So that's why i tape this follow

[postgis-users] problem with 'sobel' & ST_MapAlgebraFctNgb

Hello, I would like apply a sobel filter to my raster DEM. In a 1st time, i defined the sobel function in a sql.file. In a 2nd time, i tried to run the 'ST_MapAlgebraFctNgb' via PSQL console available via pgadmin3. When i run the query, i have an error message saying : The "Sobel(float [] [], t

[postgis-users] Qgis : display Postgis Raster as a filesystem ?

Hello, I have imported into my postgis db a filesystem raster (with -R optional parameter). I thought the path of the raster has been stored in the database. I do not succeed in displaying this table via Qgis. Could you throw light for me? Regards. IMAGE. -- View this message in contex

[postgis-users] Postgis raster : storage performance ?

Hello, 1/ Is there a real advantage to import raster into postgis db in storage purposes? Can you give me an indicator evaluating the gain of file size compared to raw raster files? 2/ Is there a postgis raster tool for compressing raster cover in order to compress the size of the dbs? 3/ Coul

[postgis-users] Problem regarding tiff raster 's import into postgis

Hello, I want import 39 raster tiff files in my postgis data base (tiff). I suceed in converting the 39 tiff files into one sql file. The size of this sql file is 21,7 Go. But i have an error message whenever i try to upload the sql into Postgis : " ERROR : invalid memory alloc request size 107

[postgis-users] Problem regarding tiff raster 's import into postgis

Hello, I want import 39 raster tiff files in my postgis data base (tiff). I suceed in converting the 39 tiff files into one sql file. The size of this sql file is 21,7 Go. But i have an error message whenever i try to upload the sql into Postgis : " ERROR : invalid memory alloc request size 1073