Re: [gdal-dev] OGR SQL CAST geometry example

2024-05-30 Thread Dan Jacobson via gdal-dev
Alas, even for MULTIPOINT, as there are no facilities for extracting from aggregates, not even ST_Dump, in the end all one can do is $ ogrinfo 0.lines.kml -al | perl -nwle \ 'if(/LINESTRING.*\((.*)\)/){print for split /,/, $1}' -100.79005679 36.38022 1000 -100.79008013 36.38531 1

Re: [gdal-dev] OGR SQL CAST geometry example

2024-05-30 Thread Dan Jacobson via gdal-dev
$ ogrinfo 0.lines.kml -q -dialect SQLITE -sql \ 'SELECT ST_PointN(GEOMETRY, generate_series(1, ST_NPoints(GEOMETRY))) FROM "0"' ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2( no such function: generate_series ___ gdal-dev mailing list gdal-dev@lists.

Re: [gdal-dev] OGR SQL CAST geometry example

2024-05-30 Thread Dan Jacobson via gdal-dev
> "ER" == Even Rouault writes: ER> you can't do operations on geometries with OGR SQL... OK, I'll try it. Thanks. The page should still have an example of actual use of Casting ... POINT[Z], LINESTRING[Z] Without examples people will try things like POINTZ, "POINTS[Z]"

[gdal-dev] OGR SQL CAST geometry example

2024-05-30 Thread Dan Jacobson via gdal-dev
Hi. I will add an example to https://gdal.org/user/ogr_sql_dialect.html#changing-the-type-of-the-fields showing users how to e.g., CAST LINESTRING Z to POINTS Z, e.g., to extract the points from: $ ogrinfo 0.lines.kml -q -sql 'SELECT "_ogr_geometry_" FROM "0"' Layer name: 0 OGRFeature(0):1 LINEST

Re: [gdal-dev] Gettin' started: WMTS -> gdal2tiles

2020-05-20 Thread Dan Jacobson
Or, how would I download a few tiles, from openstreetmap, say near 24,121 lat/lon? Yes, https://github.com/OSGeo/gdal/issues/2052#issuecomment-628650934 but of course works for me, but is black. I suppose there is no way to pipe this into gdal2tiles, so I will save it as a separate file(s) first.

[gdal-dev] Gettin' started: WMTS -> gdal2tiles

2020-05-14 Thread Dan Jacobson
I have got this far: $ wget https://maps.nlsc.gov.tw/OpenData/wmts $ gdalinfo wmts I want to use $ gdal2tiles on one of its layers, for a few km. wide rectangle, for offline browsing. So I need to somehow save the tiles from WMTS, and then feed them into gdal2tiles. Yes I read https://gdal.org/d

Re: [gdal-dev] Does "OGR_STYLE from rivers" mean it will read rivers.ofs ?

2016-07-02 Thread 積丹尼 Dan Jacobson
Maybe http://www.gdal.org/ogr_feature_style.html is just a framework and not something that is implemented anywhere? Are there any examples of anybody using LABEL(f:"Times New Roman",s:12pt,t:{text_string}) to print anything anywhere? ___ gdal-dev mailin

Re: [gdal-dev] Does "OGR_STYLE from rivers" mean it will read rivers.ofs ?

2016-07-02 Thread 積丹尼 Dan Jacobson
All I want to do is try the various Label Placement Modes seen in http://www.gdal.org/ogr_feature_style.html , given my LineString of .csv Lon/Lat points that I stripped out of my .kml. Surely there is a way to attach Label Placement Modes to a LineSrting and then output it to some .png etc. file,

Re: [gdal-dev] Does "OGR_STYLE from rivers" mean it will read rivers.ofs ?

2016-07-02 Thread 積丹尼 Dan Jacobson
But this applies the style to all the points in the line, but I just want to apply it to the line itself. And then how can I finally print the result to a .png file? Convert to .shp and view in qgis? But my .shp ended up with no points in it. ___ gdal-de

Re: [gdal-dev] Does "OGR_STYLE from rivers" mean it will read rivers.ofs ?

2016-07-02 Thread 積丹尼 Dan Jacobson
I finally gave up and stipped the KML data into a .csv and finally was able to (according to ogrinfo) successfully attach styles to it with this .vrt file: road.csv wkbLineString WGS84 SELECT *,'PEN(c:#FF00FF,w:10px)' AS OGR_STYLE FROM road _

Re: [gdal-dev] Does "OGR_STYLE from rivers" mean it will read rivers.ofs ?

2016-07-02 Thread 積丹尼 Dan Jacobson
I failed miserably at adding ANY style to a shapefile. $ ogrinfo -al -q zk2.shp|colrm 66 Layer name: zk2 Metadata: DBF_DATE_LAST_UPDATE=2016-07-02 OGRFeature(zk2):0 Name (String) = zaokeng main road 中45市道 descriptio (String) = (null) timestamp (Date) = (null) begin (Date) = (null) end

[gdal-dev] Does "OGR_STYLE from rivers" mean it will read rivers.ofs ?

2016-07-02 Thread 積丹尼 Dan Jacobson
http://www.gdal.org/ogr_feature_style.html says Here is what one of those .OFS files could look like: OFS-Version: 1.0 StyleField: "style" DefaultStyle: PEN(C:#00FF) road: PEN(c:#FF,w:5px) lake: BRUSH(fc:#FF);PEN(c:#00) campsite: SYMBOL(c:#0

Re: [gdal-dev] R: Problem using ogrlineref

2016-07-01 Thread 積丹尼 Dan Jacobson
Well OK but the Debian guy closed all my bug reports instantly, and on the man page you will need to give full examples, including input file content, before any of this becomes understandable. Thanks. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org h

Re: [gdal-dev] R: Problem using ogrlineref

2016-07-01 Thread 積丹尼 Dan Jacobson
I just have a single . I want to put kilometer markers along it. That is all I am trying to do. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] R: Problem using ogrlineref

2016-07-01 Thread 積丹尼 Dan Jacobson
I am trying to use the ogrlineref command. I can't even understand its man page. Maybe it only works on shapefiles. Maybe it only Seg Faults. How can I get the locations of the kilometer markers given only this KML: zaokeng main road 中45市道 1 120.86817,24.17922,0.0 120.86816,24.17922