Re: [gdal-dev] Sustainable GDAL initiative and fundraising

2021-04-15 Thread Paolo Cavallini
Great news, thanks Even!
Long life GDAL.

Il 15/04/21 15:31, Even Rouault ha scritto:
> All,
> 
> I wanted to inform you about an initiative that the PSC recently
> started, and which is now sufficiently advanced to share and develop
> further publicly along with the larger GDAL community. As you all know,
> GDAL is a foundational piece of the open-source and proprietary
> geospatial software ecosystem. While the project has successfully
> attracted contributions for adding new features and capabilities, it
> lacked financial capacity and a vehicle to support difficult-to-fund
> maintenance and infrastructure.
> 
> The PSC recently applied to be fiscally hosted by NumFOCUS
> (https://numfocus.org) to receive donations to provide that vehicle (*).
> I should underline that GDAL is and will continue to remain a OSGeo
> project for all other concerns.
> 
> We approached a first round of potential sponsors and received
> substantial multi-year pledges, which make us confident that our minimum
> target, of being able to fund the equivalent of a full-time senior
> engineer for three years, will eventually be reached. These resources
> will help fund *several* co-maintainers, enable increasing the bus
> factor of the project, and address the many tasks (ticket triaging and
> addressing, CI maintenance, pull request reviews, release management,
> etc.) needed to make it even better.
> 
> The sponsorship funding will be entirely used for activities that
> benefit the project and its associated dependencies such as PROJ,
> libgeotiff, and libtiff. The PSC will be developing procedures and
> details of how the sponsorship resources will be allocated, and we will
> update the GDAL website with them as they are finalized.
> 
> Finally, we would like to thank our initial sponsors, who have provided
> the project with generous three-year pledges of support:
> - Platinium (50k USD/yr): Microsoft and Planet
> - Gold (25k USD/yr): Esri, Google, Safe Software
> - Silver (10k USD/yr): Koordinates, Sparkgeo, Mapgears
> 
> On behalf of the PSC,
> 
> Even
> 
> (*) NumFocus being a 501(c)3 organization, donations from US companies
> and persons are tax deductible.
> 
> 
> _______
> gdal-dev mailing list
> gdal-dev@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev
> 

-- 
Paolo Cavallini
www.faunalia.eu - QGIS.org
training, support, development on QGIS, PostGIS and more
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] Fwd: Catching many errors of the same record (ogr2ogr)

2021-01-14 Thread Paolo Cavallini
Hi Even,

Il 14/01/21 16:24, Even Rouault ha scritto:

> That was not at all my point :-) The above was supposed to demonstrate that 
> even when using PostgreSQL outside of any GDAL context, you cannot do what 
> you 
> want (only one violation reported at a time), so you shouldn't expect GDAL to 
> be better than PostgreSQL offers.

OK, so it's a pg limitation, nothing we can do about, at least in the
short term.
Thanks a lot for the clarification.
Cheers.
-- 
Paolo Cavallini
www.faunalia.eu - QGIS.org
training, support, development on QGIS, PostGIS and more
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] Fwd: Catching many errors of the same record (ogr2ogr)

2021-01-14 Thread Paolo Cavallini
Hi Even, all,

> On vendredi 8 janvier 2021 15:58:39 CET matteo wrote:
>> Hi all,
>>
>> I've 2 small questions during a syncing from a GPKG to a PG DB with
>> constraints using -skipfailures:
>>
>> * is it possible to show only the constraint error and not also the
>> insert one? Even if there is only a single error, reading the log it
>> seems that there are 2 of them (I know a person should only read)
>> * is there are 2 errors (e.g. constraints error) BUT in the same record,
>> ogr2ogr shows only the first one and not all of them
> 
> Why not experimenting outside GDAL a bit ?
> 
> $ psql
> 
> # create table foo(bar integer check (bar = 1), baz integer check (baz =
> 1));
> # insert into foo values (2,2);
> ERROR:  new row for relation "foo" violates check constraint
> "foo_bar_check"
> DETAIL:  Failing row contains (2, 2).
> 
> 
> and asking your favorite search engine about
> "postgresql get all constraint violations"
> 
> ==>
> https://stackoverflow.com/questions/23822162/error-message-with-all-constraint-violations-in-postgres

thanks Evan for this reply. The approach you suggested work well for an
interactive session, but not if one wants to write a little script
importing a set of layers and sending all the errors to the user. in
this case:
* reducing verbosity would make things more clear for the user
* listing all errors (non only all failing records, the first error per
record, as -skipfailures does, but all failing values for each record)
would be important to provide the user a list of issues to fix before
resubmitting the layer to import.
I have studied ogr2ogr man, but I do not find a way to solve either of
these problems. From your reply I assume this is a limitation of the pg
provider. Am I wrong? Is there a way to circumvent this?
Thanks a lot.
All the best.

-- 
Paolo Cavallini
www.faunalia.eu - QGIS.org
training, support, development on QGIS, PostGIS and more
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] gdaldem color-relief transparency

2016-12-22 Thread Paolo Cavallini
Il 22/12/2016 17:21, Even Rouault ha scritto:

> If there's none, then you've spotted the issue and you need to define
> one with -dstnodata

exactly, it works now with

gdalwarp -dstnodata -999 -q -cutline mcp_buf.shp -tr 0.0015703125
0.00038671875 output/temperature.tif output/temp_clip.tif

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
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] gdaldem color-relief transparency

2016-12-22 Thread Paolo Cavallini
Hi Even,

Il 22/12/2016 16:57, Even Rouault ha scritto:

> Perhaps there's an issue with the nodata value of your raster ?

maybe; I have created it with:

gdalwarp -q -cutline mcp_buf.shp -tr 0.0015703125 0.00038671875
temperature.tif temp_clip.tif

How do I check?

Thanks.

-- 
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
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

[gdal-dev] gdaldem color-relief transparency

2016-12-22 Thread Paolo Cavallini
Hi all,
sorry if this is not the right list. Please redirect me elsewhere in case.
I cannot give a transparency to NULL when creating a coloured raster:

gdaldem color-relief -alpha temp_clip.tif byr.txt temp_col.tif -of GTiff

where byr.txt is:

0% 5 113 176 255
25% 146 197 222 255
50% 247 247 247 255
75% 244 165 130 255
100% 202 0 32 255
nv 255 255 255 0

I tried several other combinations, but I cannot hava a transparency of
NULLs.
Where am I wrong?
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&geo=IT&q=qgis,arcgis
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] Error in gdalwarp

2016-10-24 Thread Paolo Cavallini
Il 24/10/2016 12:58, Paolo Cavallini ha scritto:
> Il 24/10/2016 12:51, Even Rouault ha scritto:
> 
>> Possibly. I've just fixed the issue per 
>> https://trac.osgeo.org/gdal/ticket/6694 
>> and will issue a GDAL 2.1.2 RC4 with that extra fix.

For the record, ticket open on Processing:
https://hub.qgis.org/issues/15746
Thanks again for the help.
-- 
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
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] Error in gdalwarp

2016-10-24 Thread Paolo Cavallini
Il 24/10/2016 12:51, Even Rouault ha scritto:

> Possibly. I've just fixed the issue per 
> https://trac.osgeo.org/gdal/ticket/6694 
> and will issue a GDAL 2.1.2 RC4 with that extra fix.

thanks for that.

> Hum, I'm not sure to understand. I don't see any difference when running 
> gdalwarp with your cutline (with --config GDALWARP_IGNORE_BAD_CUTLINE YES or 
> after my fix) or the cutline resulting of the union (anyway my fix doesn't 
> involve union'ing). Or perhaps if you enable blending ?

the difference is when running the analisys as recursive, under Processing.
All the best, and thanks again.

-- 
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
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] Error in gdalwarp

2016-10-22 Thread Paolo Cavallini
Hi Even,

Il 22/10/2016 21:54, Even Rouault ha scritto:

> Since GDAL 2.1, validation of the cutline geometry once reprojected into 
> source coordinates is done, and defaults into an error if the validation 
> fails.
> 
> Here the issue is linked to the fact that when the cutline datasource is made 
> of several polygons, a multipolygon is made with them by adding them as parts 
> of the multipolygon. And if you do that on watersheds.shp, it results in a 
> invalid multipolygon likely because the parts share common boundaries

Thanks for the detailed explanation.

> You can revert to the previous behaviour and avoid the error to be fatal by 
> adding
> --config GDALWARP_IGNORE_BAD_CUTLINE YES
> to the gdalwarp command line.
> 
> The clipping to the cutline might work or not depending on the nature of the 
> invalidity (in your case that shouldn't be an issue). The check was added 
> because there were use cases where unnoticed invalidities resulted in rather 
> critical issues (for example when you need to clip out some regions because 
> of 
> regulations on forbidden zones, and an invalidity causes an area that should 
> have been clipped out to not being clipped out).

Rather tricky. The same analysis seems to run fine, however, on the same
data with different software.
What would be your advice for gdalwarp usage in QGIS>Processing? Just
adding GDALWARP_IGNORE_BAD_CUTLINE YES by default, and perhaps an extra
option to disable it?

> Probably that in the use case you point, the way the multipolygon is built 
> should be revised to use a proper unioning operation instead of the current 
> rather naive way. Could be worth a ticket.
> 
> You can do that step manually with:
> 
> ogr2ogr cutline.shp -sql "select st_union(geometry) from watersheds" 
> watersheds.shp -dialect sqlite

Unfortunately this removes all internal borders, making it unusable for
the original purpose.
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&geo=IT&q=qgis,arcgis
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

[gdal-dev] Error in gdalwarp

2016-10-22 Thread Paolo Cavallini
Hi all,
I'm running gdalwarp on data from

https://github.com/qgis/QGIS-Training-Data/tree/master/training_manual_data/processing/iterative

as

gdalwarp -ot Float32 -q -of GTiff -cutline watersheds.shp -co
COMPRESS=DEFLATE -co PREDICTOR=1 -co ZLEVEL=6 -wo OPTIMIZE_SIZE=TRUE
dem25.tif OUTPUT.tif

and I get

GDAL command output:
Warning 1: Self-intersection at or near point 583.000182 326
ERROR 1: Cutline is not valid after transformation

Previously the same command was running fine. I also checked geom
validity of the vector, and I coud not spot any error.

Is there an explanation?

GDAL 2.1.1+dfsg-5 on Debian sid.

All the best, and thanks.
-- 
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
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] ogr2ogr failing on postgis?

2016-04-10 Thread Paolo Cavallini
Il 10/04/2016 18:01, Even Rouault ha scritto:

> Yes, this is expected and a rather common problem with shapefiles.

Thanks a lot for the explanation. QGIS therefore creates an incorrect
prj, but I did not noticed it because it loaded it with the correct
EPSG. Ticket upstream opened:
http://hub.qgis.org/issues/14655
All the best, and thanks.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

[gdal-dev] ogr2ogr failing on postgis?

2016-04-10 Thread Paolo Cavallini
Hi all,
I have an ogr2ogr command, from shp to pg, that fails because it
requests write access to spatial_ref_sys. An apparently identical
command on another file runs smoothly. Any hint?
Details and data documented here:
http://hub.qgis.org/issues/14650
Thanks.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] OGR SQL and lother dialects?

2015-12-04 Thread Paolo Cavallini
Il 04/12/2015 17:20, Even Rouault ha scritto:
> Ah indeed when trying directly with SQLite. My initial test was through -
> dialect SQLite which uses a SQLite virtual table mechanism, and that might be 
> in its implementation in OGR that it is rejected.

Thanks a lot to all for the clarifications.
All the best.

-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

[gdal-dev] OGR SQL and lother dialects?

2015-12-04 Thread Paolo Cavallini
Hi all,
apparently the OGR SQL dialect is different from others:
https://hub.qgis.org/issues/7380
Any hope to bring them to common ground?
Thanks.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] Files without .dxf extension result invalid

2015-06-12 Thread Paolo Cavallini
Il 12/06/2015 10:02, Even Rouault ha scritto:

> Yes, the driver could possibily be improved to also look at the first lines 
> and
> guess if they look like valid DXF. Although it must be extremely uncommon to
> have dxf files without .dxf extension.

thanks, done.

-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


[gdal-dev] Files without .dxf extension result invalid

2015-06-12 Thread Paolo Cavallini
See details at: http://hub.qgis.org/issues/9547
with sample data.
Should I open a ticket?
Thanks.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] Fast feature count not available?

2015-05-26 Thread Paolo Cavallini
Il 26/05/2015 12:13, Even Rouault ha scritto:

> The "-spat -180.0 -90.0 180.0 90.0" part looks a bit suspicious to me. Why do 

Quite clear, thanks Even. The command line was built by a QGIS plugin;
your explanation can help to solve also a bug on it.
All the best.

-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


[gdal-dev] Fast feature count not available?

2015-05-26 Thread Paolo Cavallini
Hi all,
I'm trying to import from Oracle to PostGIS, with the command

ogr2ogr.exe -progress --config PG_USE_COPY YES -f PostgreSQL
PG:"host=*** port=5432 dbname=*** password=*** user=***" -lco DIM=2
OCI:georef/***@***:1523/**.**:GEOREF.GEO_NODES "GEOREF"."GEO_NODI_BT"
-nlt POINT -lco SCHEMA=georef -lco GEOMETRY_NAME=geom -lco FID=id -nln
geo_nodes -a_srs EPSG:4326 -spat -180.0 -90.0 180.0 90.0 -nlt
PROMOTE_TO_MULTI

which returns:

Progress turned off as fast feature count is not available.

The table is created, but empty.
I'd be grateful of any hint.

All the best.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


[gdal-dev] rgdal?

2015-05-21 Thread Paolo Cavallini
Hi all,
after a long time not installing R afresh, I was surprised seeing the
the important rgdal package is not packaged. Is there a spcific reason
for this, or is it just the usual lack of time?
all the best, and thanks.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] buildvrt and reverse BW images

2015-05-19 Thread Paolo Cavallini
Il 19/05/2015 18:13, Even Rouault ha scritto:

> Well, you could cheat a bit by generating inverted VRT for one of the two 
> categories with :

Merci Even.

-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


[gdal-dev] buildvrt and reverse BW images

2015-05-19 Thread Paolo Cavallini
Hi all.
I have several images, appearing correctly in BW, but with different
color tables:

  Color Table (RGB with 2 entries)
0: 255,255,255,255
1: 0,0,0,255

  Color Table (RGB with 2 entries)
0: 0,0,0,255
1: 255,255,255,255

When building a virtual raster, obviously they appear reversed (some BW,
some WB). Is there a way to build a uniform virtual raster, without
manually changing the single rasters?

Thanks.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] ogr2ogr segfault

2015-05-19 Thread Paolo Cavallini
Il 19/05/2015 11:43, Paolo Cavallini ha scritto:
> Il 19/05/2015 11:18, Antonio Falciano ha scritto:
> 
>> ogr2ogr OUTPUTLAYER.shp strade.shp -dialect sqlite -sql "SELECT
>> ST_Line_Interpolate_Point(geometry, 0.5), * FROM strade"
>> What happens in this case?
> 
> Same thing, segfault.
> Reading better notes from Debian developer I get convinced is the same
> problem reported (not proj, sorry).
> 
> In fact:
> 
> Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
> Core was generated by `ogr2ogr
> /tmp/processing/ac237fb069174742838e3f468b7b8a28/OUTPUTLAYER.shp /home/'.
> Program terminated with signal SIGSEGV, Segmentation fault.
> #0  0x7f9bfed4fff4 in spatialite_init () from
> /usr/lib/x86_64-linux-gnu/libspatialite.so.5

For completedness:

#0  0x7f9bfed4fff4 in spatialite_init () from
/usr/lib/x86_64-linux-gnu/libspatialite.so.5
#1  0x7f9c058874bf in ?? () from /usr/lib/libgdal.so.1
#2  0x7f9c0588c385 in ?? () from /usr/lib/libgdal.so.1
#3  0x7f9c058927e0 in ?? () from /usr/lib/libgdal.so.1
#4  0x00405303 in ?? ()
#5  0x7f9c04373b45 in __libc_start_main (main=0x404bc0, argc=7,
argv=0x7fff8d37a748, init=, fini=,
rtld_fini=, stack_end=0x7fff8d37a738) at libc-start.c:287
#6  0x00408292 in ?? ()

All the best.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] ogr2ogr segfault

2015-05-19 Thread Paolo Cavallini
Il 19/05/2015 11:18, Antonio Falciano ha scritto:

> ogr2ogr OUTPUTLAYER.shp strade.shp -dialect sqlite -sql "SELECT
> ST_Line_Interpolate_Point(geometry, 0.5), * FROM strade"
> What happens in this case?

Same thing, segfault.
Reading better notes from Debian developer I get convinced is the same
problem reported (not proj, sorry).

In fact:

Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
Core was generated by `ogr2ogr
/tmp/processing/ac237fb069174742838e3f468b7b8a28/OUTPUTLAYER.shp /home/'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0  0x7f9bfed4fff4 in spatialite_init () from
/usr/lib/x86_64-linux-gnu/libspatialite.so.5

Same thing as for qgis crashes.
Thanks for helping to understand.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] ogr2ogr segfault

2015-05-19 Thread Paolo Cavallini
Il 19/05/2015 11:18, Antonio Falciano ha scritto:

> ogr2ogr OUTPUTLAYER.shp strade.shp -dialect sqlite -sql "SELECT
> ST_Line_Interpolate_Point(geometry, 0.5), * FROM strade"
> What happens in this case?

Same thing, segfault.
Reading better notes from Debian developer I get convinced is the same
problem reported (not proj, sorry).
Thanks.

-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] ogr2ogr segfault

2015-05-19 Thread Paolo Cavallini
Il 19/05/2015 11:01, Ari Jolma ha scritto:

> Can you give us the back trace what led to the segfault? Can you share
> the shapefile?

The shape is irrelevant, it happens with anyone.
I'll try to get the backtrace later, I'm now in a workshop.
Could anyone get the command working on Sid?
Thanks for the feedback.
All the best.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


[gdal-dev] ogr2ogr segfault

2015-05-19 Thread Paolo Cavallini
Hi all.
I'm consistently getting a segfault from:

ogr2ogr OUTPUTLAYER.shp strade.shp strade -dialect sqlite -sql "SELECT
ST_Line_Interpolate_Point( geometry , 0.5 ),* FROM 'strade' "

Anything I can do for debugging?
Debian Sid, might be a platform specific issue?
https://bugs.debian.org/785091
All the best.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] SQL script for creating a test GeoPackage

2015-04-24 Thread Paolo Cavallini
Il 24/04/2015 09:51, Even Rouault ha scritto:

> GDAL already supports GeoPackage since 1.11 (with further enhancements & 
> fixes 
> in 2.0dev), so it's already available in QGIS without needing a new 
> dependency 
> ;-) At least in reading&updating mode, since I think there's perhaps a 
> missing 
> GUI item to be able to create a new geopackage.

Yes, that's what I meant, sorry for the confusion: it would be good to
have a way to initialize a gpkg proprely.
All the best, and thanks.

-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] SQL script for creating a test GeoPackage

2015-04-23 Thread Paolo Cavallini
Il 23/04/2015 20:24, Pepijn Van Eeckhoudt ha scritto:
> Jukka,
> 
> What I have is in the tool I wrote
> <https://bitbucket.org/luciad/libgpkg> ;) Not easy to copy/paste the SQL
> though.

Hi all,
what a nice idea. Would you be so kind as to let the QGIS-dev list know
when you have a tool ready? I think adding it to QGIS would greatly help
users start using gpkg.
Thanks.

-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] Garmin .img data?

2014-12-20 Thread Paolo Cavallini
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Il 20/12/2014 17:01, Oliver Eichler ha scritto:
> Hi,
> 
> 
> 
> The Garmin vector format is well known to a certain extend. Garmin

Thanks Oliver for the thorough explanation.
All the best.

- -- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iEYEARECAAYFAlSVx54ACgkQ/NedwLUzIr6t+wCghqNw9jaG9NuVSaC9Uz2uj2o0
CWQAmwaS1QG51uN9ZQKe7uKUgcDfwvHl
=tHuX
-END PGP SIGNATURE-
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] Garmin .img data?

2014-12-19 Thread Paolo Cavallini
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Even,

Il 19/12/2014 17:01, Even Rouault ha scritto:
> Probably perhaps nobody has written it. The link you gave doesn't
> link much information about the format. Is it the vector format
> described at http://sourceforge.net/projects/garmin- 
> img/?source=typ_redirect ? If so, a quick skimming of it would lend
> me thinking that read support should be possible, although likely
> not a trivial effort (41 pages for an unformal specification is
> quite significant). Write support and interoperability with Garmin
> devices would probably be harder as I can see quite a few ??? in
> the document.

thanks for your reply. I imagined this, but I was surprised by the
fact that apparently small projects were able to read the format
without much difficulty.
Going to ask qmapshack dev.
All the best.
- -- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iEYEARECAAYFAlSUVMsACgkQ/NedwLUzIr5giQCfYPrUmAapyobGIMzMQg/oN7Su
3GsAoJrfbXiCJGezXuzy7jeTAPyQlDzV
=qovP
-END PGP SIGNATURE-
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


[gdal-dev] Garmin .img data?

2014-12-19 Thread Paolo Cavallini
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi all.
AFAIK the format is not supported in GDAL, whereas it is so by smaller
GPL projects:
https://bitbucket.org/maproom/qmapshack/wiki/Home
Any special reason we do not have that support?
All the best.
- -- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iEYEARECAAYFAlSUQ/AACgkQ/NedwLUzIr7ongCfe6Ms9yiXw+Om8KaIXTgz/lee
7qoAni1VZuf09NhxcILRU9rFjDbJv7NH
=d0JD
-END PGP SIGNATURE-
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] GDAL GeoPackage raster support

2014-12-11 Thread Paolo Cavallini
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Even,

Il 11/12/2014 16:37, Even Rouault ha scritto:

> I'm confused by your comment :

sorry I was unclear:

> - are you trying to load a raster geopackage through "load
> vector"... ? That will not do it. You should open it with "load
> raster". That works with my antique QGIS 1.8 linked against GDAL
> trunk ;-) - are you using GDAL trunk ? This is necessary for raster
> support. Vector support should mostly work with GDAL 1.11

I'm saying that QGIS cannot load .gpkg, therefore I cannot do more
tests. When fixed, I'm available for testing.

All the best.

- -- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iEYEARECAAYFAlSJuvYACgkQ/NedwLUzIr5YrACgsVW3i48tsZqJTeFfA8iWPjhj
OXYAnRZWgxCAUZWm9qmstCyjbUOw7XMa
=qq+j
-END PGP SIGNATURE-
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] GDAL GeoPackage raster support

2014-12-11 Thread Paolo Cavallini
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Even,

Il 10/12/2014 23:52, Even Rouault ha scritto:
> I've committed in GDAL trunk the final pieces of the code needed to
> support GeoPackage rasters in read/creation/update modes. Feedback
> from early testers would be much appreciated, particularly
> regarding interoperability with other software stacks (1), as I
> could basically only test round-tripping with GDAL.

unfortunately, QGIS does not seem yet able to load .gpkg, either
through load vector or through the Browser, so I cannot thest this.
I think I've already opened tickets about it.
All the best.

- -- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iEYEARECAAYFAlSJuNwACgkQ/NedwLUzIr5mhACgitpy9z4m4+SdpfVdpmaq7zwJ
2jkAoLEurJbwLyaruFbmNxcv60AnN1Zo
=ee81
-END PGP SIGNATURE-
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] Sample script idea: gdal_srsguess

2014-11-03 Thread Paolo Cavallini
Il 03/11/2014 17:02, Andre Joost ha scritto:

> The "AREA_OF_USE_CODE" is already in /gdal-data/gdal_datum.csv.
> 
> The bounding boxes can be extracted from the EPSG database "Area" table as 
> well.

That's great news, thanks.
All the best.

-- 
Paolo Cavallini - www.faunalia.eu
Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] Sample script idea: gdal_srsguess

2014-11-02 Thread Paolo Cavallini
Il 31/10/2014 17:54, Aaron Racicot ha scritto:
> We played with something just like this last year (called projfinder):
> 
> http://projfinder.com/
> 
> That is just a simple demo application that was a proof of concept.  Center 
> the map where you think your data is from, enter in a sample X,Y from your 
> dataset and it tries to guess what projection your data is in.  Nothing fancy 
> like parsing arbitrary file formats etc… just simple X,Y from your data.
> 
> I gave a presentation on it at FOSS4G-NA 2013 (you can reference it here):
> 
> http://reprojected.com/blog/2013/05/28/foss4g-na-2013-was-a-home-run/
> 
> If you are interested in the code I can point you to it.  In the end it is 
> basically a simple web-service built around a PostGIS SQL query that does the 
> distance calculations to percolate up likely projections against the EPSG 
> database.

Thanks Aaron for this. IMHO an even better option would be to explicitly add to
EPSG/proj.4 db the bounding boxes of validity for each projection: in this way,
client GIS could show only valid projections for a given map area, and this 
would be
a major usability improvement for all.
All the best.

-- 
Paolo Cavallini - www.faunalia.eu
Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] OT: openev(2) alternative?

2014-06-26 Thread Paolo Cavallini
Il 26/06/2014 22:11, Even Rouault ha scritto:
> Le vendredi 20 juin 2014 14:56:44, Vincent Schut a écrit :

>> I just need something that is good in displaying (browsing, zooming)
>> multi-band raster files. Anybody knows a viable alternative?

Please have a look to QGIS 2.4, to be released today: it has now multithreaded
display, considerably faster.
All the best.

-- 
Paolo Cavallini - www.faunalia.eu
Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev


Re: [gdal-dev] VRTBuilder class

2014-05-28 Thread Paolo Cavallini
Il 28/05/2014 21:14, Siebe Bosch ha scritto:
> If you want to use the VRTBuilder inside your own programming environment (on
> Windows) you could also start using the MapWinGIS ActiveX control.
> Version 4.9 and later supports GDAL, including the VRTBuilder function.

Or you can use Processing in QGIS to automatically create a Python script for 
this.
All the best.

-- 
Paolo Cavallini - www.faunalia.eu
Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev