254 reputation
113
bio website
location
age
visits member for 1 year, 11 months
seen Jul 19 at 13:17

Jun
19
comment Will ogr2ogr correctly merge features from several OSM files to resulting set
osm2pgsql (as least the version I tried on Windows) does not create primary key, and I guess other OS versions does not too, as osm_id is not unique.
Jun
12
comment Geometry to Shapefile
By one of many interfaces to SQL exposed to VB.Net
Jun
4
comment How to migrate PostGIS spatial data to MsSql spatial data?
very cool spartan program, you just copy/paste layers between servers, and it does the rest for you
Jun
4
comment Export GeoJSON to MSSQL with UTF-8 encoding
Well, open ticket you linked and this question show that there is no way to import Unicode with org2org to mssqlserver. UTF-8 data is passed to mssqlserver, but it doesn't recognize it as such because the column type is set to varchar instead nvarchar. If column is set to nvarchar, mssqlserver would apparently import UTF-8 data and convert it on the fly to it's Unicode encoding variant - UTF-16LE.
Jun
3
comment Export GeoJSON to MSSQL with UTF-8 encoding
So this task is impossible currently. Thanks for the information.
Jun
2
comment Export GeoJSON to MSSQL with UTF-8 encoding
It's just the same. Both GeoJSON and now converted GML, render fine in UTF-8 text editor, but not in database table.
May
27
comment How to georeference using GDAL tools?
According documentation and test: -a_ullr ulx uly lrx lry or with lat/lon terms -a_ullr ullon ullat lrlon lrlat is the correct way to use the command.
Jun
8
comment re-project from EPSG:4326 to polar projection
Perhaps input has to be cropped first, like you did. Following your steps (i.e. cropping the input to north hemisphere) I also get expected result. Trying again on whole globe it fails for some reason. Thanks for you answer :)
Jun
8
comment re-project from EPSG:4326 to polar projection
It reaches 90deg north. It's etopo tiff provided here: ngdc.noaa.gov/mgg/global. I'll update question with gdalinfo report. Thanks
Dec
27
comment What's the difference between gdalwarp and gdal_merge for mosaicing
Had no idea about this tuning switch, which indeed speeds up the process. For reference 3000 is 3GB (more info trac.osgeo.org/gdal/wiki/UserDocs/GdalWarp) I have NumPy build with MKL in my system Python, but still gdalwarp must be doing something more, as NumPy can't be faster then C implementation, although can reach it.
Dec
13
comment How to re-project shapefiles?
Thanks I didn't know about that, and Googling it showed me what you meant. It's exactly what I needed. If you could have only posted your last comment yesterday... I did lot of typing to get there ;)
Dec
13
comment How to re-project shapefiles?
I was trying to overlay vector layer from one projection (epsg:31277) to another (epsg:4326). However I did not understood this well, as now I know that I don't need re-projection (changing the shapefile data) but just change to shapefile projection file (.prj) by using -a_srs instead -t_srs. Issue why EPSG:4326 SRS that didn't had projection, was because it's WGS84 geographic coordinate system, so it doesn't need projection, as was shown to me by others.
Dec
13
comment How to re-project shapefiles?
I tried different projections and they all output very different values for coordinates. I'll ask at gdal mailing list, and post results if I get answer. Thanks for your time
Dec
12
comment How to re-project shapefiles?
With EPSG:900913 instead EPSG:4326 I get "PROJCS["Google_Maps_Global_Mercator"... but coordinates are totally off :Extent: (-3785362.530285, 25.607240) - (-3785362.528919, 25.608223)
Dec
12
comment How to re-project shapefiles?
But it's not projected. PROJCS dictionary is not present in metadata and coordinates are wrong. See the coordinates (Extent) in source file and then in file output by ogr2ogr.
Dec
12
comment How to re-project shapefiles?
But it just changes coordinate system without re-projecting. That's why I asked this question. Please see the code box in my question more closely
Dec
12
comment How to re-project shapefiles?
thanks for your effort, but did you actually read my question?
Dec
12
comment How to re-project shapefiles?
Yes, they are in same folder
Dec
12
comment How to re-project shapefiles?
@steko: If "on the fly" is what is answered by djq, yes I already knew that.
Dec
12
comment How to re-project shapefiles?
Yes that's great, but I would have to do that for every layer, which is time consuming. By using command line I was hoping to re-project all shapefiles at once (with for loop)