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

Aug
26
comment Sql Query in Postgresql
@John Barça , That is reason why i left comment also your answer seems to be correct
Aug
26
comment Sql Query in Postgresql
why not something like : WHERE ST_Equals(ST_Startpoint(r.geom),e.geom) OR ST.Equals(ST_Equals(r.ST_Endpoint(r.geom),e.geom) (if both geoms are in same srid)
Aug
25
reviewed Approve QGIS Filtering Multiple Values using Query Builder
Aug
20
reviewed Approve How to create a series of points along multiple polylines at once in ArcMap 10
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?