2,259 reputation
414
bio website
location
age
visits member for 2 years, 1 month
seen 17 mins ago

20h
answered How to split/divide linestrings of larger lengths in postgis
Apr
9
comment Unable to execute pgsql2shp in php
pgsql2shp not in php users path ? no execution rights ? not allowed in php.ini ? Error message would be helpful
Apr
8
comment Automating the production of GPS-compatible map tiles from georeferenced raster maps
not an answer, but qgis print composer atlas may be able to handle this if you create X*X grid points and use those for coverage layer. X*X grid points and scale should be defined so that it created wanted rasters. this may or may not work, last time when i tried to create tiles with qgis i noticed that coverage layers seems to work like i said , but i have not done any real experiments with it
Apr
8
reviewed Approve suggested edit on How to give elevation information to a polygon feature class using existing TIN file ? (geological mapping)
Apr
8
reviewed Approve suggested edit on Weird ST_Contains behaviour
Apr
8
comment Workflow to convert a DWG CAD file to a shapefile
i think FME supports linux ( but not necessarily all file formats) see : safe.com/support/support-resources/fme-downloads there is linux version
Apr
7
reviewed Approve suggested edit on Trouble converting .osm to .pbf with Osmosis
Apr
7
answered How to work with Microstation DGN v8i files in QGIS?
Apr
4
comment (Pgrouting) Finding the best path within some maximal length
When using this : SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_astar( 'SELECT id, source, target, cost, x1, y1, x2, y2 FROM edge_table', 7, 12, false, false ); alter inner SELECT with WHERE clause which limits data to 10km from start node (7)
Apr
4
comment (Pgrouting) Finding the best path within some maximal length
cost is not length, cost is just cost which you have assigned to it.
Apr
4
revised Looking for system specifications for a modern GIS workstation
added 111 characters in body
Apr
4
answered Looking for system specifications for a modern GIS workstation
Apr
4
comment Routing in MS SQL 2012
There is no in database solutions for routing that i know for MS SQL. But if you have network topology table in MS SQL you can write one , or use 3rd party middleware
Apr
3
answered How to convert distance into latitude + longitude
Apr
3
revised FME - How to send list of files to reader
fixed typos
Apr
3
comment Can I fix 'qodbc3:unable to execute statement' when querying SQL Server 2008?
the error hints that there is no table named SITES_2G , so wrong database or wrong schema would be my best guess or odbc driver is case sensitive (that depends how driver escapes table names
Mar
27
comment Convert DWG/shp format for Openlayers
FME is good (basic version costs 1000€+ i think )
Mar
24
comment How to move line segment to certain direction using ArcGIS for Desktop?
For reference: Other GIS programs call it OffSet or Translate, Also Affine transformation can be used just offset
Mar
24
comment Update postgres/postgis point data attribute from another enclosed polygon shapefile in QGIS
Not really, that should be done on importin data phase. UPDATE xx set geom on = ST_SetSRID(4326) ( 4326 is wgs84 , you should use correct srid ) now both data needs to be on same srid then UPDATE xx set geom = ST_Transform(geom, 900973) or you can also do transform in where clause if you really need to have data in different srid ´WHERE ST_Within(points.geom, ST_Transform(poly.geom,900973))´
Mar
24
comment Update postgres/postgis point data attribute from another enclosed polygon shapefile in QGIS
both need to be in same system (ST_SetSrid(geom, srid) can be used to set srid and ST_Transform(geom,srid ) can be used to transform to different projection