318 reputation
213
bio website
location
age
visits member for 2 years, 2 months
seen Oct 25 at 5:01

Sep
27
accepted Migrating data from Python to PostGIS
Sep
27
comment Find correct SRID
Right, good catch... I didn't noticed that UNIT isn't closed. Thanks for confirmation.
Sep
27
comment Find correct SRID
I did what was most obvious to me and added new record for SRID 9001 to spatial_ref_sys column, afterwhich all seem to work as expected.
Sep
27
asked Find correct SRID
Sep
11
revised Migrating data from Python to PostGIS
added 2 characters in body
Sep
11
revised Migrating data from Python to PostGIS
added 2 characters in body
Sep
11
answered Migrating data from Python to PostGIS
Sep
11
asked Migrating data from Python to PostGIS
Sep
4
comment How to correctly import GeoJSON in PostGIS?
@user30184 ring errors are because I have many geometries where two separate rings create single feature and they are treated by ogr2ogr as polygons. If I convert these to multipolygon, errors are gone.
Sep
4
revised How to correctly import GeoJSON in PostGIS?
update
Sep
4
reviewed Approve suggested edit on How to correctly import GeoJSON in PostGIS?
Sep
4
revised How to correctly import GeoJSON in PostGIS?
deleted 6 characters in body
Sep
4
asked How to correctly import GeoJSON in PostGIS?
Aug
27
comment Crop and reproject shapefile based on GeoTIFF sample
Nice tip. I tried to reproject and clip at the same time, but I put -clipdst before the filenames, so it didn't work, and I didn't read the error message carefully about partial reprojection possiblity with OGR_ENABLE_PARTIAL_REPROJECTION nor I would have known how to define that option ;)
Aug
27
accepted Crop and reproject shapefile based on GeoTIFF sample
Aug
27
comment Crop and reproject shapefile based on GeoTIFF sample
Thanks, it was countries shapefile, but I managed to get correct output by first cropping to outer rectangle of GeoTIFF file, then reprojecting and then clipping to projected coordinates. I was just hoping that straightforward approach of using georeferenced file as reference exists in gdal/org system.
Aug
27
comment Crop and reproject shapefile based on GeoTIFF sample
Projecting whole globe to destination projection is not possible, so I have to crop the source first, and that is where I stopped in the first place as corner coordinates are not forming rectangle in Natural Earth shapefile source projection. Any suggestions?
Aug
27
asked Crop and reproject shapefile based on GeoTIFF sample
Aug
26
comment Query PostGIS database without creating primary key
Sorry, it's my fault. Before issuing PostgreSQL layer has no primary key. there was one more message: Duplicate field Code found. So that was the real reason why the query didn't load as layer - latter message seems like result from the previous fault.
Aug
26
asked Query PostGIS database without creating primary key