193 reputation
6
bio website
location
age
visits member for 1 year, 8 months
seen Sep 29 '13 at 18:55

Aug
5
awarded  Citizen Patrol
Jul
25
comment Center point approximation of a polygon
Edited image to make this more clear. Blue poly on top can not be represented as a voronoi.
Jul
25
revised Center point approximation of a polygon
added 4 characters in body
Jul
25
comment Center point approximation of a polygon
They can have multiple centers because these are not voronoi polygons but can have complex shapes. That is why the centroid is to much of an approximation.
Jul
25
asked Center point approximation of a polygon
Jul
10
comment Visualising WKT geometry string in QGIS
@elrobis You can add multiple geometries by splitting them with an linebreak, so that every geom is on a single line. No comma's or other delimiters needed.
Jul
9
comment Select empty Postgis (Postgresql) geometry column
@nickves Interesting, but still weird that <> '' works. Maybe because PG treads empty char as NULL. Also this IS vs. = in sql was the real problem here.
Jul
9
accepted Select empty Postgis (Postgresql) geometry column
Jul
9
comment Select empty Postgis (Postgresql) geometry column
Thats a thought....
Jul
9
comment Select empty Postgis (Postgresql) geometry column
Your update works. Why oh why doesn't it work with an = sign but does work with an is?
Jul
9
revised Select empty Postgis (Postgresql) geometry column
edited tags
Jul
9
comment Select empty Postgis (Postgresql) geometry column
That gives me ERROR: function isnull(geometry) does not exist SQL state: 42883 Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Jul
9
asked Select empty Postgis (Postgresql) geometry column
Dec
4
awarded  Supporter
Dec
4
accepted Which SRS to use for global distance queries?
Dec
4
accepted What is a delta in lat/lon called?
Nov
29
comment Which SRS to use for global distance queries?
It is actually!
Nov
29
awarded  Commentator
Nov
29
comment Which SRS to use for global distance queries?
@nickves yes I saw that, but postgis is really not fast enough for me. I need less then 2ms latency and should be able to handle 1000 request per sec. I could reverse engineer postgis's solutions though :)
Nov
29
comment Which SRS to use for global distance queries?
Hey, that is an idea! I could squeeze in another dimension in my KDTree and work with that. Will need some rework though :)