[postgis-users] ST_Split returning multipart
Hi all. I have a linear network as a single multilinestring. I need to cut it in separate subnet using a point layer. ST_Split dos the job, but it returns the subnet split into multipart, and I do not have an id to put them together. I cannot find a way to split the original network retaining each subnet as a single object. Am I missing something? Thanks for any hint. -- Paolo Cavallini www.faunalia.eu Training, support, development on QGIS, PostGIS and more ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
[postgis-users] spatial_ref_sys not populated after upgrade
Hi all, after an upgrade of Potsgres and Postgis the spatial_ref_sys table is created, but not populated. I kind of remember having the same issue, but I cannot find traces in my notes nor on the internet. Any hint of what can have be gone wrong? Cleanest way to fix this? TIA Cheers. -- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGIS and more ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] shp import through GDAL fails
Indeed, on a fresh db on one of our servers the import works. I'll check further in the others. Sorry for the noise. Cheers. Il 13/10/20 17:22, Regina Obe ha scritto: >> this was my initial guess, that's why I'm asking here (Postgis 3, that is). >> Thanks. >> >> Il 13/10/20 16:21, b.j.kob...@utwente.nl ha scritto: >>> I think the function AddGeometryColumnis deprecated already for some >>> time (now should be ST_AddGeometryColumn)so maybe in postgis v13 it >>> does not work anymore... >> >> -- >> Paolo Cavallini >> www.faunalia.eu - QGIS.org >> training, support, development on QGIS, PostGIS and more >> ___ >> postgis-users mailing list >> postgis-users@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/postgis-users > > The function is AddGeometryColumn. AddGeometryColumn still exists. > http://postgis.net/docs/manual-3.0/AddGeometryColumn.html > > We have never had nor will we ever have a ST_AddGeometryColumn > > So to Darafei's point, make sure you are connected to a database with PostGIS > installed and also make sure the schema PostGIS is installed in is in the > database search path. > Also make sure the account you are using in QGIS is does not have search_path > overridden. > > Thanks, > Regina > > _______ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > -- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGIS and more ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] shp import through GDAL fails
this was my initial guess, that's why I'm asking here (Postgis 3, that is). Thanks. Il 13/10/20 16:21, b.j.kob...@utwente.nl ha scritto: > I think the function AddGeometryColumnis deprecated already for some > time (now should be ST_AddGeometryColumn)so maybe in postgis v13 it does > not work anymore... -- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGIS and more ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] shp import through GDAL fails
Hi Darafei Il 13/10/20 15:55, Darafei "Komяpa" Praliaskouski ha scritto: > - is postgis installed into the same database where you are unpacking > dump to? common issue is installing to "postgres" database and then > expecting to have it in "gis" or "$yourapp" one. sure > - can you share a full reproducer scenario? there are two in the ticket > where there is no issue. can you retell step-by-step what you are doing > to get an error? I get the error when I import from QGIS (which uses GDAL behind the scenes): ERROR: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does not exist RIGA 1: SELECT AddGeometryColumn('public','world_simpl','geom',3857,... ^ NOTA: No function matches the given name and argument types. You might need to add explicit type casts. This on: PostgreSQL 13.0 (Debian 13.0-3) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.0-13) 10.2.0, 64-bit Whereas exactly the same thing on: PostgreSQL 11.9 (Debian 11.9-0+deb10u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit works smoothly, as has always done. Cheers. -- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGIS and more ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
[postgis-users] shp import through GDAL fails
Hi all, we are consistently getting errors during shapefiles import: https://github.com/OSGeo/gdal/issues/3053 Initially we believed this was due to unsupported syntax by GDAL, but from the ticket the issue seems more related to PostGIS, possibly packaging. Any hint will be welcome. Cheers. -- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGIS and more ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] Moving PostGIS to a different schema
Thanks Regina! Il 09/10/20 15:26, Regina Obe ha scritto: >> alter extension postgis set schema public ; returns, in PostGIS 3.0 >> ERROR: extension "postgis" does not support SET SCHEMA >> >> any solution to this? >> Thanks. >> -- >> Paolo Cavallini >> www.faunalia.eu - QGIS.org >> training, support, development on QGIS, PostGIS and more >> ___ >> postgis-users mailing list >> postgis-users@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/postgis-users > > Documented in this tip article > > > https://postgis.net/2017/11/07/tip-move-postgis-schema/ > > > > I need to update it a bit, for newer versions you should be able to use > > > SELECT postgis_extensions_upgrade(); > > > Instead of the ALTER UPDATE TO ... > > That way you don't need to know the version you are on. > > _______ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > -- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGIS and more ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
[postgis-users] Moving PostGIS to a different schema
Hi all, alter extension postgis set schema public ; returns, in PostGIS 3.0 ERROR: extension "postgis" does not support SET SCHEMA any solution to this? Thanks. -- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGIS and more ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] postgis_restore
Thanks! Il 09/10/20 13:46, Matti Linnanvuori ha scritto: > Hi! > > That has been fixed in 3.0.1. > https://trac.osgeo.org/postgis/ticket/4605 > > Best regards, Matti Linnanvuori > > >> On 9 Oct 2020, at 13.41, Paolo Cavallini > <mailto:cavall...@faunalia.it>> wrote: >> >> Hi all, >> is the utility supposed to work restoring a 9.3/2.1 dump into a >> 12.0/3.0 db? >> I keep on getting >> pg_restore: error: one of -d/--dbname and -f/--file must be specified >> Cheers. >> -- >> Paolo Cavallini >> www.faunalia.eu <http://www.faunalia.eu> - QGIS.org <http://QGIS.org> >> training, support, development on QGIS, PostGIS and more >> ___ >> postgis-users mailing list >> postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> >> https://lists.osgeo.org/mailman/listinfo/postgis-users > > > _______ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > -- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGIS and more ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
[postgis-users] postgis_restore
Hi all, is the utility supposed to work restoring a 9.3/2.1 dump into a 12.0/3.0 db? I keep on getting pg_restore: error: one of -d/--dbname and -f/--file must be specified Cheers. -- Paolo Cavallini www.faunalia.eu - QGIS.org training, support, development on QGIS, PostGIS and more ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] Broken link
Il 27/03/20 14:41, Sandro Santilli ha scritto: > On Fri, Mar 27, 2020 at 11:22:17AM +0100, Paolo Cavallini wrote: >> Hi all, >> sorry for the noise, probably not the best cahnnel to report this, but >> in https://postgis.net/support/ there is a broken link: >> http://refcardz.dzone.com/refcardz/essential-postgis > > Here's how you do: https://trac.osgeo.org/postgis/ticket/4653#ticket > (thanks for the report) oh, I thought the bugtracker was for executables, not for website thanks -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
[postgis-users] Broken link
Hi all, sorry for the noise, probably not the best cahnnel to report this, but in https://postgis.net/support/ there is a broken link: http://refcardz.dzone.com/refcardz/essential-postgis Cheers. -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] Is there a MapInfo to PostGIS/PostgreSQL loader?
Not that I know of, but you can use ogr or QGIS for this. Cheers. On 27 August 2019 15:14:06 EEST, Shaozhong SHI wrote: >Hi, >Is there a MapInfo to PostGIS/PostgreSQL loader? For instance, use >psql.exe or something like that? > >Regards, > >Shao -- Sorry for being short___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] pg_dump on upgraded server
Hi all On 03/04/19 20:15, Paolo Cavallini wrote: > Hi again > > On 03/04/19 19:44, Sandro Santilli wrote: > >> This is unexpected, if 2.3.1 was _really_ installed. >> Can it be you manually installed 2.1.4 again on top >> of 2.3.1 ? What version you update to depends on >> the contents of postgis.control file. > > to do so I think the only way is to recompile it, right? > >>> ALTER EXTENSION postgis >>> UPDATE TO "2.3.1" >>> with >>> ERRORE: l'estensione "postgis" non ha un percorso di aggiornamento >>> dalla versione "2.1.4" alla versione "2.3.1" >> >> It could be 2.1.4 was released _after_ 2.3.1 (check the NEWS file). >> In this case you could try a more recent 2.3.x version of PostGIS. > > 2.1.4 reached EOL long ago, I don't think this is the case. > thanks. solved by forcing install of official deb postgresql-9.4-postgis-2.1 from there on, things work. so, why does apt remove the needed package? it seems appropriate to me keeping it until postgresql 9.4 is purged. am I missing something? thanks a lot for the help. -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] pg_dump on upgraded server
Hi again On 03/04/19 19:44, Sandro Santilli wrote: > This is unexpected, if 2.3.1 was _really_ installed. > Can it be you manually installed 2.1.4 again on top > of 2.3.1 ? What version you update to depends on > the contents of postgis.control file. to do so I think the only way is to recompile it, right? >> ALTER EXTENSION postgis >> UPDATE TO "2.3.1" >> with >> ERRORE: l'estensione "postgis" non ha un percorso di aggiornamento >> dalla versione "2.1.4" alla versione "2.3.1" > > It could be 2.1.4 was released _after_ 2.3.1 (check the NEWS file). > In this case you could try a more recent 2.3.x version of PostGIS. 2.1.4 reached EOL long ago, I don't think this is the case. thanks. -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] pg_dump on upgraded server
Hi all >> On 03/04/19 19:04, Sandro Santilli wrote: >>> Can you show the ALTER EXTENSION command you're issuing and the >>> error you're getting ? Also please show the output of >>> >>> SELECT postgis_full_version(); select postgis_full_version(); ERRORE: caricamento della libreria "/usr/lib/postgresql/9.4/lib/postgis-2.1.so" fallito: liblwgeom-2.1.4.so: impossibile aprire il file oggetto condiviso: File o directory non esistente thanks -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] pg_dump on upgraded server
Hi Paul, On 03/04/19 19:42, Paul Ramsey wrote: > It can perhaps be fixed by copying postgis—2.3.0--2.3.1.sql (or, really, any > of the extension upgrade scripts) to postgis—2.1.4–2.3.1.sql cp /usr/share/postgresql/9.6/extension/postgis--2.1.4--2.3.1.sql /usr/share/postgresql/9.4/extension/ alter extension postgis update to '2.3.1'; ERRORE: errore di sintassi a o presso "PARALLEL" -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] pg_dump on upgraded server
On 03/04/19 19:04, Sandro Santilli wrote: > Can you show the ALTER EXTENSION command you're issuing and the > error you're getting ? Also please show the output of > > SELECT postgis_full_version(); I tried both ALTER EXTENSION postgis UPDATE; with something like the 2.1.4 version is already installed and ALTER EXTENSION postgis UPDATE TO "2.3.1" with ERRORE: l'estensione "postgis" non ha un percorso di aggiornamento dalla versione "2.1.4" alla versione "2.3.1" unfortunately the VPN just went down, and I don't have currently access to the machine. Thanks a lot. -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] pg_dump on upgraded server
Hi again On 03/04/19 18:32, Sandro Santilli wrote: > So, I guess what happens is that pg_dump wants to use the > "canonical output" functions for the geometry types of some > database (or why would pg_dump require that library?). > > Can you confirm the above ? Are you POSITIVE the database > you're dumping does NOT use PostGIS types at all ? the database is using it, but I'm dumping only a schema without PostGIS functions, I hoped this was enough. > There must be, in that database, some record in pg_proc > where probin like '%postgis%', can you check that ? yes, I confirm > In theory, any such function would be replaced by running > a soft upgrade of PostGIS in that database. how do I do a soft upgrade, given that alter extension says the function is already installed in the database? Thanks a lot. -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] pg_dump on upgraded server
Hi On 03/04/19 18:32, Sandro Santilli wrote: > Very interesting case, as it shows a problem with the idea > that dropping minor version from the SO would fix this kind > of problem. > > So, I guess what happens is that pg_dump wants to use the > "canonical output" functions for the geometry types of some > database (or why would pg_dump require that library?). > > Can you confirm the above ? Are you POSITIVE the database > you're dumping does NOT use PostGIS types at all ? > There must be, in that database, some record in pg_proc > where probin like '%postgis%', can you check that ? > > In theory, any such function would be replaced by running > a soft upgrade of PostGIS in that database. unfortunately alter extension does not upgrade, and the error in upgradecluster is still the same. starting to feel lost. thanks for any help. -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] pg_dump on upgraded server
same error, mismatching versions # pg_dropcluster --stop 9.6 main # pg_upgradecluster 9.4 main On 03/04/19 18:23, Paul Ramsey wrote: > Use a pg_upgrade process instead of a pg_dump. You should be able to that > with just the old data area and the new server software. > >> On Apr 3, 2019, at 9:21 AM, Paolo Cavallini wrote: >> >> I mean: server versions don't match (9.4 vs 9.6) >> >> On 03/04/19 18:20, Paolo Cavallini wrote: >>> done already, but it complains that the versions don't match >>> thanks >>> >>> On 03/04/19 18:10, Paul Ramsey wrote: >>>> Put a symlink to the postgis-2.3.so file, named as postgis-2.1.so >>>> >>>> P >>>> >>>>> On Apr 3, 2019, at 9:08 AM, Paolo Cavallini wrote: >>>>> >>>>> Hi all, >>>>> I'm on a difficult situation: a debian sever with a pg9.4/pgis2.1 db has >>>>> been upgraded to stretch, therefore to pg9.6/pgis2.3. Now pg_dump will >>>>> complain of the missing pgis2.1 lib, even if I dump only a non public >>>>> (thus without pgis functions) schema. >>>>> How could I fix this? >>>>> Thanks a lot. >>>>> -- >>>>> Paolo Cavallini - www.faunalia.eu >>>>> QGIS.ORG Chair: >>>>> http://planet.qgis.org/planet/user/28/tag/qgis%20board/ >>>>> ___ >>>>> postgis-users mailing list >>>>> postgis-users@lists.osgeo.org >>>>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>>> >>>> ___ >>>> postgis-users mailing list >>>> postgis-users@lists.osgeo.org >>>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>>> >>> >> >> -- >> Paolo Cavallini - www.faunalia.eu >> QGIS.ORG Chair: >> http://planet.qgis.org/planet/user/28/tag/qgis%20board/ >> ___ >> postgis-users mailing list >> postgis-users@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/postgis-users > > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] pg_dump on upgraded server
I mean: server versions don't match (9.4 vs 9.6) On 03/04/19 18:20, Paolo Cavallini wrote: > done already, but it complains that the versions don't match > thanks > > On 03/04/19 18:10, Paul Ramsey wrote: >> Put a symlink to the postgis-2.3.so file, named as postgis-2.1.so >> >> P >> >>> On Apr 3, 2019, at 9:08 AM, Paolo Cavallini wrote: >>> >>> Hi all, >>> I'm on a difficult situation: a debian sever with a pg9.4/pgis2.1 db has >>> been upgraded to stretch, therefore to pg9.6/pgis2.3. Now pg_dump will >>> complain of the missing pgis2.1 lib, even if I dump only a non public >>> (thus without pgis functions) schema. >>> How could I fix this? >>> Thanks a lot. >>> -- >>> Paolo Cavallini - www.faunalia.eu >>> QGIS.ORG Chair: >>> http://planet.qgis.org/planet/user/28/tag/qgis%20board/ >>> ___ >>> postgis-users mailing list >>> postgis-users@lists.osgeo.org >>> https://lists.osgeo.org/mailman/listinfo/postgis-users >> >> ___ >> postgis-users mailing list >> postgis-users@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/postgis-users >> > -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
[postgis-users] pg_dump on upgraded server
Hi all, I'm on a difficult situation: a debian sever with a pg9.4/pgis2.1 db has been upgraded to stretch, therefore to pg9.6/pgis2.3. Now pg_dump will complain of the missing pgis2.1 lib, even if I dump only a non public (thus without pgis functions) schema. How could I fix this? Thanks a lot. -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] Request for ideas to enhance the geometry viewer - GSoC
Are you sure you want to reimplement what a GIS does already? Doing proper, powerful styling it's a really big task. Sorry to jump in like this, I'm a strong advocate of open source tools also because you can reuse what is available, avoiding duplication of efforts. Cheers. Il 30 gennaio 2019 02:13:50 CET, Martin Davis ha scritto: >Here's an idea which might be a bit out there... > >Allow styling/labelling to be driven by columns in the displayed query. >The styling columns would have well-known names which are unlikely to >conflict with data columns. A nice pattern to follow is the SVG style >names. So e.g. styleStroke = line color, styleFill - fill color, >styleStrokeWidth = line width, etc etc etc. styleLabel would be the >string >to label with. > >This allows styling to be data-driven and easily captured and shared. > > >On Mon, Jan 28, 2019 at 8:16 PM Victoria Rautenbach < >victoria.rautenb...@gmail.com> wrote: > >> Dear PostGIS devs and users >> >> Firstly, we (Frikan, Xuri and I) would like to thank the PostGIS >> community again for the support you provided us in 2018 during Google >> Summer of Code (GSoC). We truly appreciate your time and effort. >> >> The call for OSGeo GSoC ideas is now out [1]. Frikan and I would like >> to suggest a project to address some of the issues left in the >> geometry viewer (available in pgAdmin4), but also include some new >> functionality. >> >> Are there any ideas or suggestions from you, the PostGIS community, >> for extra functionalities that would improve the usefulness of the >> geometry viewer? >> >> Thank you in advance. >> >> Regards >> Victoria >> >> >> [1] https://lists.osgeo.org/pipermail/soc/2019-January/004200.html >> ___ >> postgis-users mailing list >> postgis-users@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/postgis-users -- Sorry for being short___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
[postgis-users] Updating geometry_column
Hi all, why some functions (e.g. st_minline) create geometries without the appropriate definitions, so that the geometry_column view iss not updated correctly (missing geometrytype and srid)? Thanks. -- Paolo Cavallini - www.faunalia.eu QGIS.ORG Chair: http://planet.qgis.org/planet/user/28/tag/qgis%20board/ ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] ST_IsValid behaviour
Thanks Daniel, so it's a question of interpretation of specs. Any opinions about multiple self intersections? All the best. Il 14/02/2018 20:22, Daniel Baston ha scritto: > Hi Paolo, > > I've encountered differing opinions on the validity of repeated > vertices. The ticket linked below summarizes the "invalid" argument, and > includes a link to the "valid" argument: > https://trac.osgeo.org/postgis/ticket/3425 > > Dan > > > On Wed, Feb 14, 2018 at 2:17 PM, Paolo Cavallini <cavall...@faunalia.it > <mailto:cavall...@faunalia.it>> wrote: > > Hi all, > we noticed two strange things in the behaviour of ST_IsValid: > * repeated vertices are not considered invalid > * in case of multiple intersections on a same polygon, only the first > one is reported. > Is there an explanation for this? > Thanks. > -- > Paolo Cavallini - www.faunalia.eu <http://www.faunalia.eu> > QGIS & PostGIS courses: http://www.faunalia.eu/training.html > <http://www.faunalia.eu/training.html> > https://www.google.com/trends/explore?date=all=IT=qgis,arcgis > <https://www.google.com/trends/explore?date=all=IT=qgis,arcgis> > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org <mailto:postgis-users@lists.osgeo.org> > https://lists.osgeo.org/mailman/listinfo/postgis-users > <https://lists.osgeo.org/mailman/listinfo/postgis-users> > > > > > _______ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html https://www.google.com/trends/explore?date=all=IT=qgis,arcgis ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
[postgis-users] ST_IsValid behaviour
Hi all, we noticed two strange things in the behaviour of ST_IsValid: * repeated vertices are not considered invalid * in case of multiple intersections on a same polygon, only the first one is reported. Is there an explanation for this? Thanks. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html https://www.google.com/trends/explore?date=all=IT=qgis,arcgis ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] -R rasters fail to \i
Il 05/01/2017 11:58, Paolo Cavallini ha scritto: > Hi all, > creating an out-of-db raster fails: > === > raster2pgsql -s 3003 -I -M -C -R > /home/paolo/Scrivania/postgis/Dati/dtm/hdr.adf dtm_ext > dtm_ext.sql > > \i dtm_ext.sql > BEGIN > Tempo: 0,234 ms > CREATE TABLE > Tempo: 10,956 ms > psql:dtm_ext.sql:3: ERRORE: XX000: rt_band_load_offline_data: Cannot > open offline raster: /home/paolo/Scrivania/postgis/Dati/dtm/hdr.adf Further tests revealed that it works for tif, not for adf, even with SET postgis.enable_outdb_rasters TO True; SET postgis.gdal_enabled_drivers TO DISABLE_ALL; All the best. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html https://www.google.com/trends/explore?date=all=IT=qgis,arcgis ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] -R rasters fail to \i
Il 05/01/2017 15:44, Regina Obe ha scritto: > You sure your postgres service account can access that file? > > rt_band_load_offline_data: Cannot open offline raster: > /home/paolo/Scrivania/postgis/Dati/dtm/hdr.adf > > sounds like a permission error. > > One way to confirm it's not the .hdf driver is to try to load one tile (not > using out of db, in db). If it goes then I think it's probably a permission > issue. apparently permissions are OK: postgres@440:/home/paolo/$ tail /home/paolo/Scrivania/postgis/Dati/dtm/hdr.adf GRID1.2 ?�@Y@YA6;;%�AQ_�1G�ip thanks a lot -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html https://www.google.com/trends/explore?date=all=IT=qgis,arcgis ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users
[postgis-users] -R rasters fail to \i
Hi all, creating an out-of-db raster fails: === raster2pgsql -s 3003 -I -M -C -R /home/paolo/Scrivania/postgis/Dati/dtm/hdr.adf dtm_ext > dtm_ext.sql less dtm_ext.sql BEGIN; CREATE TABLE "dtm_ext" ("rid" serial PRIMARY KEY,"rast" raster); INSERT INTO "dtm_ext" ("rast") VALUES (ST_Transform('010100594059C09D13253B3BB9374114AE473165C95241BB0B7A08A109CA7FFF002F686F6D652F70616F6C6F2F5363726976616E69612F706F73746769732F446174692F64746D2F6864722E61646600'::raster, 3003)); CREATE INDEX ON "dtm_ext" USING gist (st_convexhull("rast")); ANALYZE "dtm_ext"; SELECT AddRasterConstraints('','dtm_ext','rast',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,FALSE,TRUE,TRUE,TRUE,TRUE,TRUE); END; VACUUM ANALYZE "dtm_ext"; \i dtm_ext.sql BEGIN Tempo: 0,234 ms CREATE TABLE Tempo: 10,956 ms psql:dtm_ext.sql:3: ERRORE: XX000: rt_band_load_offline_data: Cannot open offline raster: /home/paolo/Scrivania/postgis/Dati/dtm/hdr.adf CONTESTO: funzione SQL "st_transform" istruzione 1 POSIZIONE: rt_pg_error, rtpostgis.c:211 Tempo: 1,695 ms psql:dtm_ext.sql:4: ERRORE: 25P02: la transazione corrente è interrotta, i comandi saranno ignorati fino alla fine del blocco della transazione POSIZIONE: exec_simple_query, postgres.c:994 Tempo: 2,872 ms psql:dtm_ext.sql:5: ERRORE: 25P02: la transazione corrente è interrotta, i comandi saranno ignorati fino alla fine del blocco della transazione POSIZIONE: exec_simple_query, postgres.c:994 Tempo: 0,125 ms psql:dtm_ext.sql:6: ERRORE: 25P02: la transazione corrente è interrotta, i comandi saranno ignorati fino alla fine del blocco della transazione POSIZIONE: exec_simple_query, postgres.c:994 Tempo: 0,138 ms ROLLBACK Tempo: 0,135 ms psql:dtm_ext.sql:8: ERRORE: 42P01: la relazione "dtm_ext" non esiste POSIZIONE: RangeVarGetRelidExtended, namespace.c:420 Tempo: 12,499 ms === Previously the same command was working fine. postgresql-9.6-postgis-2.3 from Debian sid. Thanks for any hint. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html https://www.google.com/trends/explore?date=all=IT=qgis,arcgis ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] Postgis upgrade problem
Il 23/09/2016 08:23, Regina Obe ha scritto: > What does your > > > > SELECT version(); > > > > Say? > > > > I'm thinking you might have two PostgreSQL running and it's pointing at > the 9.4 which had 2.1 removed and not your 9.5 one that has 2.2 On Debian installing a new PostgreSQL version does not remove the previous one, but makes it listening on an higher port, so possibly you're using the wrong one. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] Handling LINESTRINGM
Il 24/12/2015 18:58, Paul Ramsey ha scritto: > That restored for me just fine (against svn trunk), though the > geometry isn't linestringm, it's multilinestring (no m) > > MULTILINESTRING((11.0615907778276 43.9299550718293,11.0616854681637 > 43.926456266)) confirmed here with 2.2.0, the problem was found with 2.1.4 (standard in Debian jessie). thanks. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] Handling LINESTRINGM
Il 22/12/2015 16:25, Sandro Santilli ha scritto: > On Tue, Dec 22, 2015 at 01:27:36PM +0100, Paolo Cavallini wrote: >> Hi all, >> I discovered that LINESTRINGM are lost during a dump/restore (the table >> is created, but completely empty). Is this a known bug? > > Never heard before. > Can you reproduce with a small (single linestring with 2 vertexes) dump ? Herewith attached, thanks. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html str_chk.backup.tar.gz Description: application/gzip ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] Errors restoring a db
Il 22/12/2015 14:21, Humberto Cereser Ibanez ha scritto: > Hi Paolo, > > If your sql is trying to use 'copy' command, I experencied that the > superuser postgres can run it and stop the errors that you showed. I see, thanks. Not very nice to be forced using postgres though. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users
[postgis-users] Handling LINESTRINGM
Hi all, I discovered that LINESTRINGM are lost during a dump/restore (the table is created, but completely empty). Is this a known bug? So I tried converting them to LINESTRING, but could not find a reasonable way: anyone has a suggestion? Thanks. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] Errors restoring a db
Il 22/12/2015 14:33, Birgit Laggner ha scritto: > You don't have to use postgres user per se - but the user using the > 'copy' command has to be a superuser. Perhaps it might be easier to > change your own user role accordingly? OK, I see, thanks. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users
[postgis-users] Errors restoring a db
Hi all, I'm getting errors while restoring a db from a 1.5 dump to a POSTGIS="2.1.4 r12966" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1" LIBJSON="UNKNOWN" RASTER: ... psql:geosisma_geo_restore.sql:8262499: invalid command \N psql:geosisma_geo_restore.sql:8262500: invalid command \. psql:geosisma_geo_restore.sql:8262504: ERROR: syntax error at or near "98424" LINE 1: 98424 98424 98424 RT1303152TO SENZA F572 ^ psql:geosisma_geo_restore.sql:8262507: invalid command \N psql:geosisma_geo_restore.sql:8262508: invalid command \. psql:geosisma_geo_restore.sql:8262513: ERROR: syntax error at or near "1" LINE 1: 1 12.9.2010 010620E610010001030001000500... ^ Any explanation or possible solution? Thanks a lot. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: http://www.faunalia.eu/training.html ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] Visualizing PostGIS 3D geometries
Il 07/07/2015 21:44, Hillier, Michael ha scritto: Honestly, the issues I have gone through to visualize simple 3D PostGIS geometries doesn't make sense to me. Shouldn't there be a simple environment to connect to the PostgreSQL/PostGIS database and visualize the 3D geometries? Or have I really missed something here? If there isn't what is the point in having standardized geometries on a S-DBMS if you can't visualize them? Is it expected that some advanced end user develop their own software using some visualization toolkit like VTK to visualize these geometries? QGIS 2.10 has some basic support for 3D, will have more in 2.12. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: http://www.faunalia.eu/training.html ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Line of sight (LOS) Calculation
Il 09/03/2015 04:16, Mark Wynter ha scritto: An example of how you can generate Viewsheds in PostGIS via PL/R and Grass using a single SQL query statement. CREATE OR REPLACE FUNCTION generate_viewshed(coordxy text) RETURNS text as Hi all. Please note that in GRASS7, recently released, r.los has been replaced by the (much more efficient) r.viewshed. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: http://www.faunalia.eu/training.html ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Getting TopologyExections when trying to node linestrings to create an overlay
Il 09/02/2015 02:31, John Abraham ha scritto: Well I could say that using PostGIS ST_Intersects with messy data always seems to give me TopologyExceptions. I've had luck with various combinations of ST_SnapToGrid and ST_Buffer(0), but with messy data there always seems to be some weird case that requires manually edits. Hi John, have you tried ST_MakeValid? All the best. -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: http://www.faunalia.eu/training.html *New course* QGIS for naturalists: http://www.faunalia.eu/en/nat_course.html ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] External rasters: access disabled?
Il 05/02/2015 10:24, Tom van Tilburg ha scritto: Hi Paolo, I bumped into this as well, but it is by design and the solution is fairly easy. Read this: http://postgis.net/docs/postgis_installation.html#install_short_version OK, clear, thanks. -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: http://www.faunalia.eu/training.html New course: QGIS for naturalists - http://www.faunalia.eu/en/nat_course.html ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Export from postGIS to ESRI Personal GeoDatabase
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 03/12/2014 12:37, Rémi Cura ha scritto: Hey, it is not mdb, but I know some people from Oslandia have successfully developed a postgis -SQLite system with sync so to be able to work in the field. Maybe some stuff to re-use there (open source of course) Hi Rémi, do you have a link to it? Merci. - -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: http://www.faunalia.eu/training.html -BEGIN PGP SIGNATURE- Version: GnuPG v1 iEYEARECAAYFAlR/Q+UACgkQ/NedwLUzIr4byACfdjulKaH5qHTNkHWzBmJcsddD XlEAoIBd3FiffNx8bPF13dNexJcq5udj =CwiT -END PGP SIGNATURE- ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] raster2pgsql gui
Il 08/06/2014 10:21, Pieter du Plooy ha scritto: Has anyone ever attempted to create a raster2pgsql gui (like the shp2pgsql gui). As I am sometimes lazy to use command line, this could be a very nice to have Have you checked DB Manager, in QGIS? All the best. -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Versioning system to use with QGIS + Postgis
Il 06/06/2014 00:28, Alexandre Neto ha scritto: I already knew about pgversion, but I haven't been able to see its code http://plugins.qgis.org/plugins/pgversion/ https://www.kappasys.ch/svn/pgversion/trunk/ Il 06/06/2014 08:18, Hugues François ha scritto: You could also have a look at Vincent Mora’s recent work at Oslandia : https://github.com/Oslandia/qgis-versioning Unifying the efforts, rather than duplicating, seems a sensible way. All the best, and thanks. -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Overlapping of polygons with SimplifyPreserveTopology
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 10/12/2013 04:49, Luca Morandini ha scritto: we noticed that, despite the use of ST_SimplifyPreserveTopology, non-adjacent polygons may overlap; this happens when there is a long and narrow water body of between them (think of a fiord), but this body is not itself a polygon. To solve this issue we came up with the idea of adding an universe polygon; that is, a polygon that enclose the entire extent of a table, so that every polygon has a left and right polygon: would this do the trick ? Hi Luca, you really need to use full topology for this. ST_SimplifyPreserveTopology simply prevents topological errors, it does not guarantee sharing of nodes etc. Good luck. - -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: http://www.faunalia.eu/training.html -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.15 (GNU/Linux) Comment: Using GnuPG with Icedove - http://www.enigmail.net/ iEYEARECAAYFAlKmreQACgkQ/NedwLUzIr538QCePEiOoGaI2eSq9u8JsCviY77X 0bgAn0BrwdhOY0Ua4hnLmIWE/YdkLon3 =UWZJ -END PGP SIGNATURE- ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[postgis-users] shp2pgsql failing on large shp
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all. I have hit the issue: http://trac.osgeo.org/postgis/ticket/393 on a large file. I have PostGIS 1.5.1-5 in production on Debian squeeze, so I cannot upgrade it on that machine. It is unclear to me, after reading the ticket, what is the best way to solve this. All the best. - -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.15 (GNU/Linux) Comment: Using GnuPG with Icedove - http://www.enigmail.net/ iEYEARECAAYFAlKN9ZMACgkQ/NedwLUzIr631wCeMkf6JeMbMjRegidE+ErKfhj+ uCMAoLHyjGJy81Ubm0ivvSRRGVS4ges3 =CX7o -END PGP SIGNATURE- ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] shp2pgsql failing on large shp
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 21/11/2013 14:24, Sandro Santilli ha scritto: Did you try using shp2pgsql from a newer PostGIS version ? It should work just fine. I confirm: creating the script with a newer version and pushing it bck to 1.5 works smoothly. Thanks. - -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.15 (GNU/Linux) Comment: Using GnuPG with Icedove - http://www.enigmail.net/ iEYEARECAAYFAlKOUNAACgkQ/NedwLUzIr4BZwCgmfWqUxMeY097dkk62fV/xX4F LH8AnAwNpPtsl7miCRxp5ijIxnI9X0Zr =nH3u -END PGP SIGNATURE- ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] The first release of the PostGIS Add-ons is out!
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 20/11/2013 16:32, Rémi Cura ha scritto: There is a very big difference between :' i tweak one of your function, so my tweak must be open source' and 'i use one of your function, so my code must be open source'. Unfortunately GPL imposes both. from my point of view, this is a Very Good Thing - -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.15 (GNU/Linux) Comment: Using GnuPG with Icedove - http://www.enigmail.net/ iEYEARECAAYFAlKM1r4ACgkQ/NedwLUzIr5SaACgoM78J5gKMoo2lFG/Qqx24hCJ UUoAoKgOIIakZ/HvbL94jT4gGVoWFQis =iyTi -END PGP SIGNATURE- ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Wiki editing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 30/10/2013 12:46, Sandro Santilli ha scritto: On Tue, Oct 29, 2013 at 04:03:47PM +0100, Rémi Cura wrote: Hey, here is a draft for a page about using QGIS with PostGIS Anybody can edit it . http://trac.osgeo.org/postgis/wiki/UsersWikiQGIS Thank you, very useful. ?? PostGIS srid are not supported, so you have to manually choose the right projection and coordinate system when adding a PostGIS geometry layer. all the best. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.15 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlJw/PUACgkQ/NedwLUzIr5fbwCfS8U5eIXdZ0noncTHyArpfgfc UREAn3VI1Clq4iyrJtvC0BbSLim07m6N =DKFs -END PGP SIGNATURE- ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] postgis raster : viewer with qgis 2.0?
On 2013-09-18 16:23, Mathieu Basille wrote: * For me, it used to work perfectly until a couple of days ago, but that might be completely system specific (or a recent update broke a few things). please check and open a ticket about this * I'm not sure how complex raster tables (such one with several tiles at the same position, e.g. a raster time series) are handled, my guess is that all tiles are loaded on top of each other. this shouldn't be. We would love to improve DB Manager, in this and other respects; if you are interested please let us knoe. All the best. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] postgis raster : viewer with qgis 2.0?
On 2013-09-18 17:44, basille@ase-research.org wrote: Check done, and the problem is still there (using the QGIS nightly version for Debian). What is a good place for a ticket about this? QGIS bug tracking system? http://hub.qgis.org/projects/quantum-gis/issues (I just want to make sure since DB Manager is a plugin) yes, right - DB Manager is now default component of QGIS. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] error on copying geometries between geometry columns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 12/08/2013 13:19, Pietro Rossin ha scritto: UPDATE mytable SET geom_simply=ST_SimplifyPreserveTopology(st_multi(geom), 100) ERROR: Geometry type (Polygon) does not match column type (MultiPolygon) SQL state: 22023 Why? Try SET geom_simply=ST_Multi(ST_SimplifyPreserveTopology(st_multi(geom), 100)) - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.14 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlIIx1UACgkQ/NedwLUzIr7CfgCgmrjYsZx1VYPv8e1s84xKJ61Q wu0An1uGZgFQF5mvhfj98flwerRC3KTj =dUaB -END PGP SIGNATURE- ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Is it worth to load background raster into postgis?
Il 08/02/2013 14:19, Pietro Rossin ha scritto: Hi Thanks Paolo How can I store my images to be served as WMS? any format that can by read by your WMS server; most probably gdalinfo --formats I don't know if these performances could be the same with raster... I mean, if I load the ecw's on a postgis database, which could be the ratio on disk space between ecw compressed image and raster table? certainly unfavourable for PG The refreshing of views are as fast as with ecw? no Does the postgis database grow up too much with raster? I do not know what is too much for you, certainly it will increase a lot. All the best. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Is it worth to load background raster into postgis?
Il 08/02/2013 20:27, Pietro Rossin ha scritto: We don't have a WMS server yet, any suggestion for a not too difficult to configure solution? OT here, but cetainly the easiest is aptitude install qgis-mapserver All the best. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Incorrect geometry_columns?
Il 09/12/2012 16:21, Francois Hugues ha scritto: As I can see in the view definition, srid comes from postgis constraint : COALESCE(NULLIF(postgis_typmod_srid(a.atttypmod), 0), postgis_constraint_srid(n.nspname::text, c.relname::text, a.attname::text), 0) AS srid, Did you have / did you try to add this kind of constraint on your table : CONSTRAINT enforce_srid_geom CHECK (st_srid(geom) = 3003) ? Hi all. More info: the lack of SRID and geometry type in the geometry_columns happens only for the tables created by PostGIS functions (e.g. st_union, st_convexhull, etc.). Is this a known issue? All the best. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Incorrect geometry_columns?
Il 10/12/2012 15:22, Sandro Santilli ha scritto: Or to cast on select (very useful with views..) create table test as select code_dept, st_centroid(geom)::geometry(point, 2154) as geom from dept; quite nice, thanks. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] Incorrect geometry_columns?
Il 09/12/2012 14:52, Francois Hugues ha scritto: Hi, Are you sure you don't have mixed srid ? Sure: Select st_srid(geom) from merge_strade group by st_srid(geom); st_srid 3003 Thanks. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users