Re: [gdal-dev] Corrupted geopackage

2022-02-14 Thread Mark Johnson via gdal-dev
On Mon, 14 Feb 2022, 14:11 Mark Johnson, wrote: > You should try rebuild the SpatialIndex. > > Spatialite offers gpkgAddSpatialIndex for a new Index. > > For its own format there are repair functions. > >SQL functions reference list >- spatialite-sql-latest.h

Re: [gdal-dev] Corrupted geopackage

2022-02-14 Thread Mark Johnson via gdal-dev
You should try rebuild the SpatialIndex. Spatialite offers gpkgAddSpatialIndex for a new Index. For its own format there are repair functions. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev

[gdal-dev] ogr2ogr project/transform CRS in the same database table

2020-12-02 Thread Mark Johnson
See MSSQLSpatial - Microsoft SQL Server Spatial Database — GDAL documentation https://gdal.org/drivers/vector/mssqlspatial.html The MS SQL Spatial driver passes SQL statements directly to MS SQL by default, rather than evaluating them internally when using the ExecuteSQL() call on the

[gdal-dev] gdal_translate: adding a gcp_file parameter useful?

2018-05-10 Thread Mark Johnson
Would adding a '-gcp_file' as a input parameter, that would contain the list of gcp's to be used, be considered useful? Often the gcp list could be created programmaticly and saved to file, which would simplify the use from a script. Mark ___ gdal-dev

[gdal-dev] Link faulty in FDORfc16 page

2018-03-02 Thread Mark Johnson
(not sure if here is the right place for this) The 'FDO Binary Geometry Format' link: http://fdo.osgeo.org/files/fdo/docs/FDG_FDODevGuide/files/WSfacf1429558a55de8821c21057fbebc2b-789.htm on page https://trac.osgeo.org/fdo/wiki/FDORfc16 is no longer valid. Resulting in: Forbidden You don't

[gdal-dev] Questions / clarification about 'FDO Geometry Format' and creation of GeoPackage Vectors

2018-03-02 Thread Mark Johnson
'FDO Geometry Format': Am I reading the code correctly that 'FDO', at least in the case of a Sqlite-Container, is read only? GeoPackage-Vector creation with ogr2ogr: That it not possible to retain the original Geometry-Column Name, but either 'geom' of the value given with '-lco

Re: [gdal-dev] gdal make fails for python bindings - with ccache: invalid option -- 'p'

2017-12-14 Thread Mark Johnson
export CXX=/usr/bin/c++ make install did not resolve this problem. The WARNING, with ' --tag=CXX /usr/bin/g++ -std=c++11"' still turns up during setup.py. gcc -pthread -Wno-unused-result -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -fPIC -I../../port -I../../gcore -I../../alg

Re: [gdal-dev] gdal make fails for python bindings - with ccache: invalid option -- 'p'

2017-12-14 Thread Mark Johnson
>> Do you know where this ccache invokation comes from ? Both libtool and non-libtool regular builds work for me with the python bindings echo $CC shows nothing. echo $CXX shows '/usr/bin/ccache /usr/bin/c++' At some point in the last year I added 'ccache' for use with QGis. For ./configure

[gdal-dev] gdal make fails for python bindings - with ccache: invalid option -- 'p'

2017-12-14 Thread Mark Johnson
$(MAKE) install)' is commented out in the GNUmakefile file, everything else runs and installs. Mark Johnson, Berlin Germany ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] Call for discussion on RFC 70: Guessing output format from output file name extension

2017-11-10 Thread Mark Johnson
Sorry, I overlooked the 'output filename to guess', while reading the PR and title. Mark ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] Call for discussion on RFC 70: Guessing output format from output file name extension

2017-11-10 Thread Mark Johnson
> > ogr2ogr output.gpkg input.shp Where would you read the Magic-Headers in > this case? Before the input file is opened. Read the first 100 bytes, compare with known signatures if ((memcmp (blob, tiff_signature_big, 4) == 0) && (memcmp (blob, tiff_signature_little, 4) == 0)) { return

Re: [gdal-dev] Call for discussion on RFC 70: Guessing output format from output file name extension

2017-11-10 Thread Mark Johnson
. //-- // https://en.wikipedia.org/wiki/List_of_file_signatures // https://gist.github.com/navinpai/983632 // https://www.iana.org/assignments/media-types/media-types.xhtml //-- Mark

Re: [gdal-dev] Appending to an existing GeoPackage raster table

2017-10-07 Thread Mark Johnson
e the tiles correctly, merging the 2 sources together and numbering the tiles correctly based on the given extent. Theoretically this should work. Mark Johnson, Berlin Germany ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] Opening gridded xyz data that is out of order

2017-09-11 Thread Mark Johnson
This will do the same, just replace the EPSG code number: gdal_translate -ot Float32 -a_srs EPSG:25833 ../xyz/390_5820.dhhn92.txt ../2007.390_5820.dhhn92.25833.tif Mark ___ gdal-dev mailing list gdal-dev@lists.osgeo.org

Re: [gdal-dev] Opening gridded xyz data that is out of order

2017-09-11 Thread Mark Johnson
You must sort the data beforehand - the y position must be sorted properly (ASC or DESC) Standard linux sort program: sort -k2 -n -k1 392_5810.xyz -o 392_5810.sort.xyz (2nd column (y) as numeric, then first column (x) -o = output file As a zip file you can also do: unzip -p 390_5820.zip |

Re: [gdal-dev] Participating on gdal2tiles

2017-01-20 Thread Mark Johnson
needed on sdcard's for tiles-directories is very high and slow It was always the intention to incorporate this into gdal2tiles, but not being a Python expert/fan, I was always hoping that someone could take this over and maintain it. Mark Johnson, Berlin Germany

Re: [gdal-dev] Seg fault & error running gdal_rasterize on a non georeferenced raster

2016-11-29 Thread Mark Johnson
meaning of is: SRC_METHOD=NO_GEOTRANSFORM - no idea But with a world file the expected result comes out. Mark Johnson Berlin Germany ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

[gdal-dev] minor correction for drv_libkml.html [bash-script] neeted

2016-09-10 Thread Mark Johnson
n Rouault > # > # Permission > > needs to be changed to: > #!/bin/bash > # Copyright (c) 2010, Brian Case > # Copyright (c) 2010-2014, Even Rouault > # > # Permission > > to run without error. Mark Johnson, Berlin Germany

Re: [gdal-dev] gdal_edit with ECW, parameter woes, documentation is probematic

2016-07-26 Thread Mark Johnson
Yes, that looks good. But also adapting the pages that use -co NAME=VALUE - such as http://www.gdal.org/gdal_translate.html -co "NAME=VALUE": Passes a creation option to the output format driver. Multiple -co options may be listed. See format specific documentation for legal creation options for

[gdal-dev] convert Grayscale to RGB and, after georeferencing, back

2016-06-17 Thread Mark Johnson
: gdal_calc.py -A input.tif --A_band=1 -B input.tif --B_band=2 -C input.tif --C_band=3 --outfile=result.tif --calc="A*0.2989+B*0.5870+C*0.1140" Would it be something in this form? Mark Johnson, Berlin, Germany ___ gdal-dev mailing lis

[gdal-dev] Creating a transparent GeoTIFF, writing shape data over it, reading GeoTIFF writing as PNG with transparency.

2015-06-11 Thread Mark Johnson
.area_rote_rathausturm_panorama.png Mark Johnson, Berlin Germany ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

[gdal-dev] Creating a transparent GeoTIFF, writing shape data over it, reading GeoTIFF writing as PNG with transparency.

2015-06-11 Thread Mark Johnson
Question 2 is now finished: https://github.com/geopaparazzi/Spatialite-Tasks-with-Sql-Scripts/wiki/Project-1811-gdal_question-02 Short version: gdal_rasterize -tr 0.475211759942328 0.475212956422887 -te 24800 20700 25800 21300 -ot Byte -init 192 -a_nodata 192 -burn 0 -burn 173 -burn 83 -sql

[gdal-dev] Write support for MBTiles drive

2014-07-21 Thread Mark Johnson
/geopaparazzi/issues Mark Johnson, Berlin Germany ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev