2,450 reputation
515
bio website
location
age
visits member for 2 years, 5 months
seen yesterday

Aug
20
comment Problem measuring area with gps coordinates
see proj4js (proj4 lib).
Aug
19
awarded  Constituent
Aug
18
awarded  Caucus
Jul
11
comment Maintaining times with points2one in QGIS?
have you considered postgis ?
Jul
11
comment Postgis create polygon extent/convex hull from spatial table
CREATE OR REPLACE VIEW AS SELECT 1 as gid, ST_ConvexHULL(st_Collect(geom))::geometry(POLYGON,4326) as geom FROM xxx should do the job
Jul
4
comment Transform wkb to gml geometry using FME
now you need to select GML writer in FME and write data to there.
Jul
3
answered Transform wkb to gml geometry using FME
Jul
3
comment Transform wkb to gml geometry using FME
is WKB as WKB in SQL or as geometry, if geometry just add sql spatial reader and it just works. Or if it is as WKB use STGeomFromWKB (assuming 2008 r2+ version of ms sql) to convert it to geometry and use normal sql spatial reader
Jun
26
comment Generating a routing database for the entire world while keeping the tags
i recommend to modify postgresql.conf to have bigger memory limits after installation
Jun
26
comment ST_buffer display creates big circle
or you can use geography type instead of geometry , see postgis.net/docs/manual-2.1/ST_Buffer.html .
Jun
26
comment ST_buffer display creates big circle
as it should, well technically results is polygon (area)
Jun
19
comment Any difference between EPSG:3003 and EPSG:102091?
Looks same, You can test it in QGIS if it has both srid in system, set onfly projection off , load data and set to correct proj, then see if it looks correct
Jun
16
comment Pont to Point and Point to Line Calculations
i have done something like this when i needed things to get done: SELECT ST_Intersect(st_GeomFromText('LINE(...)'), ST_GeomFromText('Point(...)')) just sql to check if line and point intersects. Another option could be osgeo.org/geotools for java solution, it should have spatial functions which make it easier to implement. Of course if you have real spatial database you can just query results from there. calc azimuth for line , calc closest point on line, calc azimuth between point and closest point on line. of course you need to have only lines with start and end points
Jun
16
comment Pont to Point and Point to Line Calculations
i dont how to do math, thats why i would use postgresql + postgis geography to solve problem. Have you considered it?
Jun
13
comment Using ST_split to split a line feature using nearby points
FROM clause line means line table, points means point table. WHERE l.line_id points to line table and lines_id point to id column. query should be modified to suit your need , it only shows basic idea how you can extract substring from specific line using specific point.
Jun
13
comment Using ST_split to split a line feature using nearby points
syntax error fix, change , from where clause to AND
Jun
13
revised Using ST_split to split a line feature using nearby points
fixed where clause
Jun
12
comment Postgis: ST_Buffer breaks because of no forward edges
interesting. geospatialelucubrations.blogspot.ca/2014/05/… may be helpful if you really need to get polygon count down and you like working with rasters
Jun
12
comment Postgis: ST_Buffer breaks because of no forward edges
see @Paul Ramsey answer. I still have question why you need polygons. If you do something like: is point near some road then st_dwithin is "faster" solution than st_intersects over big table filled with polygons...
Jun
11
revised Postgis: ST_Buffer breaks because of no forward edges
added 437 characters in body