das-g
  • Member for 6 years, 8 months
  • Last seen more than a month ago
How do I create/write a Shapefile with UTF-8 encoded attributes with ogr2ogr?
Accepted answer
13 votes

How can I get ogr2ogr to write a UTF-8 encoded *.dbf file when exporting to Shapefile? Similar to How to encode shapefiles from LATIN1 to UTF-8?, this is possible with -lco ENCODING=UTF-8. So for my ...

View answer
OSM: How often does OpenStreetMap update their building footprint data?
6 votes

Despite its name, OpenStreetMap is a collaborative geodatabase (or geodata collection) first, and a map only second (if at all). Anyone with an OpenStreetMap account can edit the data. Live. That is, ...

View answer
Error occurred decoding the EPSG code EPSG%3A3857 in GeoServer
4 votes

That looks like insufficient URL-decoding: CRS.decode most probably expects a string like EPSG:3857 instead of EPSG%3A3857. Whether GeoServer should URL-decode that value more or whether the data or ...

View answer
Applying OSM z-order after osm2pgsql with qgis
4 votes

Within a layer, you can use the z-order values to determine the QGIS feature rendering order: Open the respective layer's style panel. Either in the layer properties or in the layer styling dock (...

View answer
Is there an inverse operation to ST_Shift_Longitude in PostGIS < 2.3?
Accepted answer
3 votes

Use shifted_geom::geography to cast the shifted_geometry to a geography: SELECT ST_AsText( 'POLYGON( ( 176.792 -12.2085, 182.1313 -12.2085, 182.1313 -...

View answer
raster tiles from vector data with GDAL - how to avoid aliasing artefacts?
Accepted answer
3 votes

Is my theory correct? It seems so, as I get flawless results with the method described below. If so, how can I determine the precise -ts parameters for gdal_rasterize (or, alternatively, -tr ...

View answer
How do I update the extent of a raster in QGIS to the actual extent?
2 votes

I've found a feasible workaround: Simply delete the <extent>...</extent> XML elements of the respective layers from the *.qgs file. QGIS will recalculate them. (Be careful not to delete ...

View answer
How can I convert Bing's "quadtree" tile addresses to ZXY tile addresses in Python?
Accepted answer
2 votes

from functools import reduce # required in Python 3 def quad_to_xy(quadtree_coordinate): return [reduce(lambda result, bit: (result << 1) | bit, bits, 0) for bits in zip(*(reversed(...

View answer
Importing geocentric cartesian coordinates csv file in QGIS
Accepted answer
2 votes

If you import it with Layer > Add Layer > Add Delimited Text Layer... with the settings as seen above (note that "First record has field names" is unchecked, and that I've chosen "Trim fields" as your ...

View answer
how to preserve color-interpretation when merging TIFFs and adding alpha band
1 votes

Whether or not this is a bug in QGIS, it can be worked around by handling trasparency with a NODATA value instead of by adding an alpha band. (Thanks to Andy Harfoot for the hint!) As -cutline ... ...

View answer
How to use postgis to reproject 900913 to a different bounding box
Accepted answer
1 votes

The OSM data is in 900913. Um, no, it isn't, that's just how it is displayed on the web. Almost all the OpenStreetMap APIs and planet downloads (whether .osm.xml or .osm.pbf) have coordinates in ...

View answer
Problem with contour lines thickness in bigger zoom levels
1 votes

Line widths are determined at the rasterization step Other than lines in a vector image (e.g. SVG), lines in vector data do not have an inherent width. They are lines in a mathematical, not in a ...

View answer
how to preserve color-interpretation when merging TIFFs and adding alpha band
0 votes

Whether or not this is a bug in QGIS, it can be worked around by creating a 4-band TIFF with a band for Red, Green, Blue and Alpha each. This can be done by post-processing with gdal_translate -...

View answer