Reputation
2,683
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
6 16
Newest
 Yearling
Impact
~94k people reached

Jul
14
reviewed Approve Keeping Properties When Converting JSON to SHP
Jul
14
reviewed Approve surface area in a basin with reference to incremental height of DAM
Jul
3
comment trigger postgis and dump qgis 2.8.2
... maybe. I mean : IF st_isvalid(new.geom) = 'f' THEN RAISE EXCEPTION 'erreur de topologie' ; ELSE (INSERT data here and call return ) RETURN NEW END IF ; end;
Jul
3
comment trigger postgis and dump qgis 2.8.2
have you tried to return new.* on success ?
Jun
24
comment Speed of people measured by gps
It look like loading gpx and saving track_points layer doesn't work, it look like it truncated time field. you could try ogr2ogr if it can handle timestamps. Or open gpx in excel( open office probably works too). Let excel figure xml out and copy data what you want to another excel file, save as csv and import to qgis.
Jun
23
comment Speed of people measured by gps
do you have timestamps for points ?
Jun
17
reviewed Approve How to delete char in table attribute in QGIS 2.6.1
Jun
17
revised postgis linestring segmentation in 4326
edited body
Jun
16
comment Unable to Display Postgis Database Table Geometry Column Points in Geomoose
You don't need to transform geom field. SET geom = ST_GeomFromText('POINT(' || longitude || ' ' || lattitude || ')',4326) ; should be good
Jun
15
comment Difference between empty and NULL geometry in file geodatabase?
In database world empty and null have different meaning. empty means that we know this should be empty where null means we do not know values of this attribute.
Jun
11
revised How do I explode a MultiLineString using ST_Dump() in PostGIS?
deleted 5 characters in body
Jun
11
revised How do I explode a MultiLineString using ST_Dump() in PostGIS?
added 2018 characters in body
Jun
11
comment How do I explode a MultiLineString using ST_Dump() in PostGIS?
SELECT ST_Dump(geom) returns rows path and geoms. SELECT id, ST_Dump(geom) from x where id = 1 returns
Jun
10
reviewed Reject How can I generate irregular grid containing minimum n points?
Jun
10
comment Using GPS to field walk through a LiDAR scene
question needs more information... But see: docs.qgis.org/2.8/en/docs/user_manual/working_with_gps/… ,and i assume that "in real time" on the lidar doesn't mean live lidar data , only gps data
Jun
8
answered How do I explode a MultiLineString using ST_Dump() in PostGIS?
Jun
5
comment How to split attributes using FME
Use AttributeSplitter with ',' and store results to _firstlist (ListName variable) ( assuming that your data contains only one ',' ) Then use AttributeSplitter ' ' from list{1} to _secondlist
Jun
4
reviewed Approve Is WGS84 a Coordinate system or projection system?
Jun
4
comment How to arrange polygon in Postgis
well , technically speaking your select should be : SELECT area_polygon FROM polygons ORDER BY ST_Area(area_polygon) desc; it returns polygon sorted by polygons area
Jun
3
comment Find lines that have specific distance between them in QGIS
if you are familiar with postgis pseudo query: select a.gid, g1.gid FROM ( SELECT gid, st_offset(-1*st_X(geom), -1*st_y(geom) geom) g from a)) g1 , a WHERE a.gid != g1.gid AND st_equals(g.geom, g1.geom) IS TRUE AND st_dwithin(a.geom, g1,geom , 10 ) That would return all gid from table which are same when moved to 0,0 and are within 10 units from each other in original coordinates How to do it in qgis , no idea