39 reputation
8
bio website
location
age
visits member for 1 year, 11 months
seen Nov 1 '12 at 13:02

Nov
27
awarded  Popular Question
Jun
19
awarded  Popular Question
Oct
26
comment What's the fastest way to search for polygons that intersect with others?
nice but this not is my unique problem, in my databse have 800000 polygons, very large
Oct
26
revised What's the fastest way to search for polygons that intersect with others?
added 109 characters in body
Oct
26
comment What's the fastest way to search for polygons that intersect with others?
im using st_intesects on where clause, using buffer in a polygon because i want search intersetions > 50m
Oct
26
awarded  Teacher
Oct
26
asked What's the fastest way to search for polygons that intersect with others?
Sep
23
accepted How to export data from QGIS to display in Google Maps?
Sep
23
comment How to export data from QGIS to display in Google Maps?
dont tryed yet, i try sunday, i have imported via ST_GeomFromKML, and thats ok, before use ST_GeomFromText
Sep
21
comment How to export data from QGIS to display in Google Maps?
yes, the error is in my workflow, www.itenho.com.br/teste7.kml see, hmn i pick the coordinates make POLYGON(()) in postgis, because this cause error?
Sep
21
comment How to export data from QGIS to display in Google Maps?
no, i use a shape file .shp, i read this in qgis, export kml, import kml to postgis via PHP, and return data in web on a gmap
Sep
21
awarded  Commentator
Sep
21
comment How to export data from QGIS to display in Google Maps?
i make this, setted the project crs: i46.tinypic.com/10z8voo.png and exported the layer as project crs:i46.tinypic.com/2zrzygj.png and the result is the same
Sep
21
revised How to export data from QGIS to display in Google Maps?
added 103 characters in body
Sep
20
asked How to export data from QGIS to display in Google Maps?
Sep
19
revised Postgis error on select all intersetcs of a polygon
added 1047 characters in body
Sep
19
comment Postgis error on select all intersetcs of a polygon
solved, i use a negative buffer -50 meters:SELECT p.*,ST_Distance( location, 'POLYGON(())' ) as dist FROM propriedades p WHERE ST_Intersects( ST_Buffer(location, -50.0), 'POLYGON(())' )
Sep
19
comment Postgis error on select all intersetcs of a polygon
like this slimber.com/gallery/pictures2/23/235563/polygons.jpg
Sep
19
comment Postgis error on select all intersetcs of a polygon
the intersection must have distance greater than 50 meters from the side of the polygon A to polygon B
Sep
19
revised Postgis error on select all intersetcs of a polygon
added 592 characters in body