205 reputation
16
bio website in-fuse.co.nz
location New Zealand
age 29
visits member for 3 years, 6 months
seen Sep 15 '13 at 7:31
Web Developer and Designer. Business Owner. Use Django/Python and jQuery. Know PHP well, but don't like it.

Apr
4
awarded  Yearling
Sep
15
awarded  Editor
Sep
15
revised What do these curly graphics represent on this map?
added 1 characters in body
Sep
10
awarded  Nice Question
Sep
10
comment What do these curly graphics represent on this map?
Thanks. That makes sense as the two areas have the same outline style too. I think in this case a lot of smaller properties around the central one were merged but are not physically connected.
Sep
10
accepted What do these curly graphics represent on this map?
Sep
10
comment What do these curly graphics represent on this map?
Yes, @DevdattaTengshe. Originally published around 1900 in New Zealand.
Sep
10
asked What do these curly graphics represent on this map?
Oct
3
accepted Best way to exclude 0,0 from geography results (PostGIS, GeoDjango)
Sep
27
asked Best way to exclude 0,0 from geography results (PostGIS, GeoDjango)
May
8
awarded  Scholar
May
8
accepted PostGIS - certain MultiPolygons cause “BOOM! Could not generate outside point!”
May
6
awarded  Teacher
May
3
answered PostGIS - certain MultiPolygons cause “BOOM! Could not generate outside point!”
May
3
awarded  Student
May
3
comment PostGIS - certain MultiPolygons cause “BOOM! Could not generate outside point!”
I've got the problem down to pure SQL. The following causes the error: SELECT * FROM "photo" WHERE ST_CoveredBy("photo"."location", ST_GeomFromEWKT('SRID=4326;MULTIPOLYGON (((30 -80, 30 80, 180 80, 180 -80, 30 -80)), ((-180 -80, -180 80, -100 80, -100 -80, -180 -80)))'))
May
3
comment PostGIS - certain MultiPolygons cause “BOOM! Could not generate outside point!”
Update: I've just tried specifying srid for my Polygons with the same results. Like so: x0, y0, x1, y1 = -180, -80,-100,80 c = Polygon(((x0, y0), (x0, y1), (x1, y1), (x1, y0), (x0, y0)), srid=4326)
May
3
comment PostGIS - certain MultiPolygons cause “BOOM! Could not generate outside point!”
Yes, I do need geography. When looking at the table in pgAdmin it shows the column as "location geography(Point,4326)". That means it is a geography column, right? Do I need to change the table somehow? Could it be that my query is trying to use geometry?
May
3
asked PostGIS - certain MultiPolygons cause “BOOM! Could not generate outside point!”
May
3
awarded  Autobiographer