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

1d
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
1d
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, ....)
Apr
28
comment suitable column Data-type for geojson data storage and processign in PostGis
If you have mixed srid in table you can use ST_SRID (postgis.net/docs/ST_SRID.html) to get correct srid for feature.
Apr
27
comment suitable column Data-type for geojson data storage and processign in PostGis
I have a vague recollection that key word geometry/geography type and hstore type could be very useful for you. i'm not sure if psotgis support json column queries (select from x where json.key like 'something' ) but i recall that hstore should be "easy" solution for it
Apr
21
comment How to build a query tool for spatialite data in QGIS?
Things happen. I'm interested about this too. What i want to do is perform query in same database where feature is from.
Apr
20
reviewed Approve How to make SQL Server buffer only on one side?
Apr
20
answered Converting shapefile from Shift_JIS to UTF-8 when the usual methods fail
Apr
16
comment Postgis 2.1 Inconsistent with spatialreference.org
far as i know you can remove constraint <=998999
Apr
14
reviewed Approve building GDAL with libKML support
Apr
8
reviewed Approve How can I remove default zoom in/out [+/-] buttons from openlayers to keep the navigation bar on?
Mar
31
comment Procedure putting online a graveyard in a GIS
QGIS + PostGIS for free option. Database tables could be something like : area, line, point, person, road where area,line and point table have rowid, geometry, type... and person table has rowid, person details and geometry id for id in area table. same logic with other types. After that it is just using SQL tools
Mar
20
answered Postgresql trigger on a table that update a field
Mar
16
answered Routing two not-node points and road side with pgrouting
Mar
14
awarded  Yearling
Feb
2
comment Split Lines at Intersection of Other Lines
problem is that your line table has some multilines, fix them to lines using st_linemerge or if that does not work you need to use ST_dump
Jan
27
comment Create a buffer in decimal degrees
en.wikipedia.org/wiki/Decimal_degrees about 1 degree is about 111 km at the equator. In other systems only way to get "accurate" 800m is reproject data to system which uses meters
Jan
27
comment FME - Writing Large Shapefiles
not that i know , but fast & dirty way to fix problem is just take modulo count (5) from all feature and fanout using it. its not optimal solution but works , using 5 raises limit to ~20G data. Another option , use workspace runne ronto workspace which allways fanouts all data to x filse then in workspace runner check output directory and merge shapefiles to ~4G max size files.
Dec
22
revised MapInfo, SQL data from multiple tab files which have the same columns
added 476 characters in body
Dec
22
answered MapInfo, SQL data from multiple tab files which have the same columns