2,663 reputation
616
bio website
location
age
visits member for 3 years, 3 months
seen 7 hours ago

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
Jun
3
comment GIS and Geodatabase with Reminder Function
This question need more information. One solution is create view from geometry and maintenance tables which has calculated column, then load view to qgis and see if where is "red" color ... Is that what you need or do you really want to send email on certain dates or... (if so see : stackoverflow.com/questions/12002662/… for start)
May
27
comment Multiple LEFT JOIN in PostgreSQL
if you do not succeed joinin tables then your ""Monitoraggio_L001_L008_2015_aprile"."IDPartner" = "Clienti"."IDPartner" and "Clienti"."ID" = "GeoLocalita"."IDCliente" has to be wrong. Post column definitions for id fields. Also , join .. on support aliases
May
27
comment Multiple LEFT JOIN in PostgreSQL
have you tried to remove all limiting WHERE clauses, except LEFT JOIN ON ... or WHERE m.id = c.idpartner
May
18
comment how to insert coordinate of province to postgresql?
INSERT INTO xxx(the_geom) VALUES(ST_GeomFromText('POINT(-71.060316 48.432044)', 4326)); Noe replace Point with POLYGON and take your sample string and replace all [] with () then remove , with " " (space) then remove ( ) from coordinate pairs. you should have string like POLYGON((50.2 31.2, 52.2 31.2, ....)