1,470 reputation
218
bio website
location
age
visits member for 2 years, 10 months
seen 2 hours ago

1d
answered Change name of category heading in legend
Apr
18
answered POSTGIS query - extracting common point from polygon data
Apr
12
answered Problem with a PostGIS trigger
Apr
6
comment ST_MakePoint returns an error when using Python
Does it work with raw SQL, e.g. without using python?
Apr
6
comment GeoDjango: Find all points within radius?
No it is not, this ratio only works for equator.
Apr
6
comment ST_MakePoint returns an error when using Python
You say casting doesn't seem to help either. What did you cast it to? double precision?
Apr
6
comment ST_MakePoint returns an error when using Python
Are you sure postgis extension is installed in your database?
Mar
31
comment Problem with ST_Intersection in postgis
I'm afraid I can't help much... but it seems there is way too much "dev" versions in your setup. The issue might relate to the PostGIS version.
Mar
31
comment Problem with ST_Intersection in postgis
Your query actually works on my machine. Here's my config: POSTGIS="2.1.2 r12389" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1" LIBJSON="UNKNOWN" RASTER
Mar
31
answered Problem with ST_Intersection in postgis
Mar
28
answered Counting self intersections of linestring using PostGIS?
Mar
27
answered Fast way to check if postgis bounding box contains any points/linestrings
Mar
18
comment PostGIS ST_Union Performance
@DarrenCope ST_Buffer(St_Collect(wkb_geometry), 0) seems to be a lot faster and it fits my needs. It might help you as well.
Mar
17
comment PostGIS ST_Union Performance
@DarrenCope any progress? I'm facing the same issue.
Mar
16
comment “linestringZ” kills “pgr_createTopology”
Well then your geometry column is not called geom.
Mar
16
comment How to deal with multiple overlaps in PostGIS?
I have. It gives erroneous results and invalid geometries in some cases and cannot be considered robust.
Mar
16
answered “linestringZ” kills “pgr_createTopology”
Mar
16
comment How to deal with multiple overlaps in PostGIS?
@artwork21 question updated
Mar
16
revised How to deal with multiple overlaps in PostGIS?
added 211 characters in body
Mar
16
asked How to deal with multiple overlaps in PostGIS?