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 & Pos
he 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 <mailto:cavall...@faunalia.it>> wrote:
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
larifying, this was my missing piece.
All the best.
--
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
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
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
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,
>&g
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-
r 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
>>>
>&g
; 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 los
27;, 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 Cavall
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
ension/
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
ion();
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
e 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/q
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
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___
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
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://
The easiest I know of is through QGIS.
Cheers.
On 15 August 2020 17:07:06 CEST, Imre Samu wrote:
>> Is there a simple way for users to load their data into PostGIS?
>
>CSV?
>- save as a CSV file ( contains LAT , LON columns )
> - import CSV to Postgres
>- convert LAT/LON to geometry columns .
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
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
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, PostGI
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
.
--
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
ype 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 ha
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
gt;
>> 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...
>>
>> --
>> Pao
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
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
t; linea 24 a RETURN
funzione PL/pgSQL "addoverviewconstraints" linea 61 a assegnazione
psql:dtm_tiled.sql:1468: ERROR: Unable to add the overview constraint. Is the
schema name, table name or column name incorrect?
...
Anything wrong?
PostGIS 2.0.2, GDAL 1.9.0
Thanks.
--
Paolo Cavall
Il 04/12/2012 20:53, Paolo Cavallini ha scritto:
> Hi all.
> I just came across to an old issue:
> http://trac.osgeo.org/postgis/ticket/1646
I should really stop working earlier: missing permissions on raster_columns
Sorry for the noise.
--
Paolo Cavallini - Faunalia
www.faunalia.eu
Ful
merge_strade LIMIT 1;
st_srid
3003
SELECT ST_geometrytype(geom) FROM merge_strade LIMIT 1;
st_geometrytype
ST_LineString
Am I missing something?
Thanks.
--
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc
Nuovi corsi QGIS e PostGIS: http://www.faunalia.
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.
ion, 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-us
..", you would have to
> alter
> the table to use the typemod:
I see, thanks a lot.
--
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc
Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario
___
p
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 con
cating them.
> Right now most of our raster are in ecw format and I'm searching a way to
> distribute them over LAN..
> May be a mosaic/vrt..
> Ay suggestion?
WMS
All the best.
--
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc
Nuovi cor
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
___
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.
we do il GPL for a reason.
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.12 (GNU/Linux)
Comment: Using GnuPG with Mo
gt; 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.1
#x27;
make: *** [all] Error 1
Debian testing, up to date; previous compilation of earlier PG versions went
fine on
this machine.
Any hint?
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/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Il 27/08/2013 16:38, Paolo Cavallini ha scritto:
> gcc: error: unrecognized command line option
> ‘-fno-aggressive-loop-optimizations’
In fact, this is a new gcc option:
http://gcc.gnu.org/gcc-4.8/changes.html
Has anyone compiled successfull
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
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
ttp://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 cont
:
* PostGIS is GPL, it is nice and natural not to mix up licences
* I do not like the idea of somebody taking up the results of my investment,
and use
it for some closed source stuff.
Thanks.
- --
Paolo Cavallini - www.faunalia.eu
Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html
ce'.
>
> 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
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
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/NedwLUzIr4BZwCgmfWqUxMeY097dkk62f
ck ?
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
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
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.
--
Pao
ere (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/NedwLUzIr4byACfdjulKaH5
Il 22/01/2015 01:28, Mark Wynter ha scritto:
> I’m open to any ideas, leads or offers of help.
I might be able to help, especially on the QGIS side; perhaps setting up
Processing modules could make the workflow easier.
All the best.
--
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS
RETURN
Debian sid, pg 9.4, PostGIS 2.1.4+dfsg-2, GDAL 1.10.1+dfsg-8+b3
They worked before. As it stands, they are pretty useless.
Anyone has a good explanation for this?
All the best, and thanks.
--
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.
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
ways 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":
tly 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@list
ome 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
___
post
store.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 solut
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
s 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
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 b
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?
>
> Ne
rmed 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
h
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
xec_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-po
@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&geo=IT&q=qgis,arcgis
___
postgis-users mailing list
postgis-
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
>
71 matches
Mail list logo