I have solved my curl problem and now it works.
You are a great community, thank you
--
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/g
Hi Even,
if you write that it works, it is not necessary for me to verify this using
the gdal docker build.
I'm sure it works.
I have compiled it again using these steps
wget http://download.osgeo.org/gdal/2.4.4/gdal244.zip
unzip gdal244.zip
cd ./gdal-2.4.4
./configure --prefix=/usr/local --with-
Hi,
if I run the command below in my "GDAL 2.4.4, released 2020/01/08"
ogr2ogr aout.geojson -f GEOJson
"http://sifweb.regione.sicilia.it/arcgis/rest/services/SIF_INCENDI_EXTENDED/MapServer/13/query?where=objectid>0&outfields=*&f=geojson"
-oo FEATURE_SERVER_PAGING=YES --debug on
I have 1000 geojso
Hi,
if I run
ogrinfo -ro -al
"http://sifweb.regione.sicilia.it/arcgis/rest/services/SIF_INCENDI_EXTENDED/MapServer/13/query?where=objectid+%3D+objectid&outfields=*&f=geojson";
-oo FEATURE_SERVER_PAGING=YES
I have only 1000 items.
Is it the same for you Jukka ?
Thank you
Warning 1: GDAL was bui
Hi,
below my debug output.
I have GDAL 2.4.4, released 2020/01/08. FEATURE_SERVER_PAGING is not
compliant with this version?
If yes, there is no note about it in the documentation.
Thank you
--
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
Hi,
when I try to download some data from the below GeoServices REST server, I
have always 1000 items, also if I set FEATURE_SERVER_PAGING to YES.
The command I use is:
ogr2ogr out.geojson -f GEOJson
"http://sifweb.regione.sicilia.it/arcgis/rest/services/SIF_INCENDI_EXTENDED/MapServer/13/query?wh
Solved I had a curl path problem. In my debian I have solved with
sudo ln -s /usr/lib/x86_64-linux-gnu/libcurl.so.4.6.0
/usr/local/lib/libcurl.so
Thank you jeff
--
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
___
gdal-dev mai
jmckenna wrote
> I believe curl is also required.
Thank you jeff. How do I must modify my configure command?
--
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.os
Hi all,
I have compiled and installed gdal 2.4.4 in this way:
wget http://download.osgeo.org/gdal/2.4.4/gdal244.zip
unzip gdal244.zip
cd ./gdal-2.4.4
./configure --prefix=/usr/local --with-sqlite3=/usr/local
--with-spatialite=/usr/local --with-static-proj4=/usr/local
--with-geos=/usr/local/bin/geo
My error, I had a carriage return. I had
CSV:/vsicurl_streaming/https://docs.google.com/spreadsheets/d/e/2PACX-1vTwuYdMYS7vKJnTETwycLEGPFG2pwhxIlPMeChXuluRLjApQwhzEy_gUgsw_9lVRrAmGhAHWEj9LDV7/pub?gid=0&single=true&output=csv
and not
CSV:/vsicurl_streaming/https://docs.google.com/spreadsheets/d/
Hi,
I have this source CSV that I would like to manage via VRT file
ogrinfo --debug ON
CSV:"/vsicurl_streaming/https://docs.google.com/spreadsheets/d/e/2PACX-1vTwuYdMYS7vKJnTETwycLEGPFG2pwhxIlPMeChXuluRLjApQwhzEy_gUgsw_9lVRrAmGhAHWEj9LDV7/pub?gid=0&single=true&output=csv";
"pub?gid=0&single=true&o
Thank you very much Sebastiaan, it works
--
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
Hi,
I'm building gdal 2.4.4 on CentOS Linux release 7.7.1908.
When I run "./configure --with-mysql=/usr/bin/mysql" I have no error.
Than when I run make I have
"make[3]: Entering directory
`/var/regsic/apps/gdal-2.4.4/ogr/ogrsf_frmts/mysql'
/bin/sh /var/regsic/apps/gdal-2.4.4/libtool --mode=comp
Hi Even,
as usual GDAL and you are really bombastic!!
Thank you very much
--
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
Hi Even,
Even Rouault-2 wrote
> /vsicurl/ should automatically follow links. This is even tested in
> https://github.com/OSGeo/gdal/blob/master/autotest/gcore/vsicurl.py#L230
I have this example CSV input source
https://query.data.world/s/q4h3mwm2acruvoc5snpp5ltsn5h2gk
It replies:
HTTP/1.1 301
Hi Even ,
Even Rouault-2 wrote
> No, this is an implementation detail. You'd have to use the curl or other
> HTTP
> API for that.
today a lot of datasets, especially structured text data, are hosted in
portals that reply with "HTTP/1.1 301 Moved Permanently".
A classic example are the many and
Hi all,
using /vsicurl/ is it possible to native intercept HTTP 3XX response code
and get the final URL of the source?
Thank you
--
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.or
It works, thank you very much
--
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
Hi,
I have this geosjon (map.geojson)
{
"type": "FeatureCollection",
"features": [
{
"type": "Feature",
"properties": {"id": 1},
"geometry": {
"type": "Point",
"coordinates": [-78.653, 35.7874]
}
},
{
"type": "Feature",
"propertie
Hi Jukka,
thank you.
jratike80 wrote
> Direct request
> http://map.sitr.regione.sicilia.it/orbs/services/geositi/catalogo_geositi/MapServer/WFSServer?service=wfs&request=GetFeature&TypeNames=geositi_catalogo_geositi:Geositi&Count=1
>
> returns
>
>
> 4159848.60569 407652.219702
>
>
>
Hi all,
I have this WFS source
http://map.sitr.regione.sicilia.it/orbs/services/geositi/catalogo_geositi/MapServer/WFSServer?service=wfs&request=GetCapabilities
If I run
ogr2ogr -skipfailures -f CSV /vsistdout/
wfs:"http://map.sitr.regione.sicilia.it/orbs/services/geositi/catalogo_geositi/MapSer
Hi Jukka,
jratike80 wrote
> You can have only one SRID on a layer so you must either split your data
> by
> the epsg field or transform each record to same SRID. Otherwise your
> request
> was almost complete.
I know, but my problem was the source!
jratike80 wrote
> ogrinfo -dialect sqlite -sq
Hi,
I have this kind of CSV
ID,x,y,epsg
1,50,400,32633
1,50,400,32632
Is it possible to use ogrinfo and a "dialect sqlite" query in this way, and
set the EPSG by reading the value from the `epsg` field?
ogrinfo -dialect sqlite -sql "select ST_GeomFromText('POINT(' || x || ' ' ||
Hi Even,
thank you very much.
Even Rouault-2 wrote
> It looks you have at least two libsqlite3 installed on your system ? You
> built
> against one that has sqlite3_column_table_name available, but at runtime
> the
> dynamic loader finds one that has not it.
> You can use LD_LIBRARY_PATH to poi
Hi all,
I have tried to build GDAL 2.2 [1], using this steps [1].
I have no problem in building, but after I have installed it, I have this
error for every GDAL/OGR command I run:
"symbol lookup error: /usr/lib/libgdal.so.20: undefined symbol:
sqlite3_column_table_name"
I'm a newbie, I do not kn
Hi all,
I have written a small tutorial related (in italian):
https://medium.com/tantotanto/trasformare-un-csv-in-un-feed-rss-7a6bd7b8c2f
Thank you gdal/ogr developers
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/CSV-to-GeoRSS-problem-with-pubDate-field-tp5329925p533067
Hi Even,
Even Rouault-2 wrote
> ogr2ogr -f GeoRSS georss.xml source.csv -oo AUTODETECT_TYPE=YES
so simple, so powerful.
Thank you very much
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/CSV-to-GeoRSS-problem-with-pubDate-field-tp5329925p5330632.html
Sent from the G
Solved, it was a stupid question: I must use a csvt and set the input pubDate
CSV field as `DateTime`.
Thank you
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/CSV-to-GeoRSS-problem-with-pubDate-field-tp5329925p5330608.html
Sent from the GDAL - Dev mailing list archive at
Hi,
does someone of you have an hello world example that works to transform with
GDAL a CSV to GeoRSS?
I'm writing here, because I do not find any tips everywhere.
Thank you again
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/CSV-to-GeoRSS-problem-with-pubDate-field-tp5
Hi,
I'm using GDAL 2.3.0dev to convert a CSV to GeoRSS, but I'm not able to set
properly pubDate field.
My test input CSV is (tab separated):
title description guidlinkpubDate
titolo des http://www.tin.it/1 http://www.tin.it/1 Wed, 11 Jul
2007 15:39:21
GMT
I run:
ogr
On 2 May 2016 at 09:32, Rahkonen Jukka (MML) [via OSGeo.org] <
ml-node+s1560n5263838...@n6.nabble.com> wrote:
> It seems to me that adding a general support for adding multiple columns
> with a single request into OGR SQL dialect would require to go through
> every driver: With PostgreSQL, build S
Hi Jukka,
Rahkonen Jukka (MML) wrote
> Do you know some database that accepts SQL "ALTER TABLE foo ADD COLUMN
> bar1, bar2"? At least SQLite and PostgreSQL don't. That kind of usage is
> not mentioned in a bunch of documents about SQL language which I browsed
> through, for example http://www.w3s
Hi Jeff,
thank you from Italy!
jmckenna wrote
>
> When I responded earlier I was testing and you cannot do this in one
> single ogrinfo command (so that answers your initial question). What
> would be great, if you could add your working example to the docs: here
> is an existing wiki page f
aborruso wrote
> As I written in my message I'm able to use ogrinfo to alterate my source
> file, but if I want to add 3 fields I must write 3 ogrinfo statements; I
> would like to know why a single statemente with a correct SQL command.
ops, I'm sorry ... why I cannot u
Hi Christine,
thank you.
Christine Waigl wrote
>
> As far as I'm aware -- please correct me if I'm wrong --
> ogrinfo only lists information about a file and doesn't
> alter it.
As I written in my message I'm able to use ogrinfo to alterate my source
file, but if I want to add 3 fields I must w
Hi Jeff,
thank you.
jmckenna wrote
> I think you have to use 2 ogrinfo statements.
I know it, it works with 2 statements. Do you know why I cannot use my kind
of SQL command with all in one statement?
And what do you think about to add some note in the documentation, about the
origin of the imp
Hi,
I have no problem to add a column to a shapefile with:
ogrinfo myfile.shp -sql "ALTER TABLE myfile ADD fieldX integer"
But if I use, the second column is not added to the file.
ogrinfo myfile.shp -sql "ALTER TABLE myfile ADD fieldX integer(3), fieldY
integer(3)"
The shell gives me only
INFO:
Even Rouault-2 wrote
> Use LINESTRING Z (with a space). I don't think LINESTRINGZ is valid WKT.
I'm really stupid :)
Thank you very much
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Impossible-to-read-wkbLineString25D-geometry-extent-tp5245452p5245460.html
Sent from th
Hi,
I have this CSV file:
WKT,id
"LINESTRINGZ (345033.07756361004 4221015.5546970163 50,330734.94084110629
4207332.313714385 50,331946.96878985036 4199477.8127947021
50,344424.26383262046 4197025.7027728558 50,351619.95001382299
4206318.4892121488 50,356988.82880540413 4212298.2940350361
50,354468.
Hi hrz,
hrz wrote
> The VRT is an XML format and hence you need to ensure the content is XML
> compliant: your URL contained `&` characters that need to be escaped to
> `&`. The following VRT works for me:
I'm stupid :)
It works good.
Thank you very much,
Andrea
--
View this message in
Hi Even,
thank you.
Even Rouault-2 wrote
> Yes, you can use the URL as the datasource name expected by the VRT
> format.
I have tried with:
http://www.provincia.caltanissetta.sitr.it/ArcGIS/rest/services/Immobili/MapServer/0/query?where=objectid+%3D+objectid&outfields=*&f=json
Hi all,
is it possible to define a Virtual Format of a remote GeoJSON file?
I would like to built a VRT file in example using this GeoJSON remote URL:
"http://www.provincia.caltanissetta.sitr.it/ArcGIS/rest/services/Immobili/MapServer/0/query?where=objectid+%3D+objectid&outfields=*&f=json";
Th
Ciao Jukka,
Rahkonen Jukka wrote
> It could be good to mention that since GDAL version r26506 in trunk and
> with
> the future GDAL releases beginning from 1.11 (or 2.0) users do not need to
> do this in a tricky way with VRT but it is enough to just use -dialect
> SQLITE. People will find your b
Hi Even, Jukka, GDAL developers,
I have written a blog post (in Italian), about this MySQL/GDAL/Sqlite
experience: http://goo.gl/YvRqo2
It is another way to say thank you.
Best regards,
a
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/sqlite-dialect-and-MySQL-spatial-in
Hi Even,
Even Rouault wrote
> Wouldn't Area() as described in
> http://dev.mysql.com/doc/refman/5.0/en/geometry-property-
> functions.html#function_area do the job ?
you are right, but I have used Area() in my post to make a simple example.
I'm talking about functions like "Contains". In MySQL
Hi,
firts of all thank you for your work. It is always very nice to see how a
great open source community works.
Even Rouault wrote
> Using SQLITE dialect with a RDBMS driver is kind of unusual use case
> (which was the thing that was finxed with r26506).
I want to add a detail, but I do not kno
Hi Jukka,
thank you.
Rahkonen Jukka wrote
> I wonder where in the documentation would be the best place to mention
> this over-override trick.
Probably in this moments it would be necessary to insert it in both pages
you mentioned.
Best regards,
Andrea
--
View this message in context:
http
Only to add that if I try to read the same MySQL input using OGR Virtual
Format, the ST_Area function works properly.
Thank you
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/sqlite-dialect-and-MySQL-spatial-input-tp5080909p5080911.html
Sent from the GDAL - Dev mailing li
Hi all,
I'm using sqlite dialect with shapefile input. An example is:
ogrinfo poligoni_input.shp -dialect sqlite -sql "SELECT ST_Area(geometry)
AS Area FROM poligoni_input"
It works and it's a great feature.
I have some problems with MySQL spatial input. I use this syntax:
ogrinfo MYSQL:"mydb,us
Hi Hermann,
only to say once again thank you very much!
I did not know that the conversion would change the original information. I
know it's a correction, but it changes the original file.
Once again thank you
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/A-strange-thi
Hi Hermann,
thank you very much.
peifer wrote
> At least it isn't a bug. Without -s_srs, the CRS info from the png file is
> used which specifies TOWGS84[0,0,0,0,0,0,0]. When specifying the EPSG code
> via -s_srs, the parameter +nadgrids=@null is used (in both cases EPSG:3857
> and EPSG:3785).
B
Here is the correct URL of the test file, sorry:
https://dl.dropboxusercontent.com/u/103202/trash/file_test.zip
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/A-strange-thing-with-a-png-geospatial-file-and-gdalwarp-Is-it-a-bug-tp5075948p5075966.html
Sent from the GDAL - De
Dear all,
I have a geospatial png file - http://ge.tt/7tmMR7r/v/0?c -and gdalinfo give
me this projection info:
PROJCS["Popular Visualisation CRS / Mercator",
GEOGCS["Popular Visualisation CRS",
DATUM["Popular_Visualisation_Datum",
SPHEROID["Popular Visualisation Spher
53 matches
Mail list logo
