meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 9 months |
| seen | Dec 20 '12 at 16:04 | |
| stats | profile views | 9 |
|
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 :) |
|
Nov 29 |
comment |
Which SRS to use for global distance queries? And the best approx? I don't really care about the poles, only penguins there, but something that performs geometrically better than WGS84? |
|
Nov 29 |
comment |
What is a delta in lat/lon called? Ah, and an arc would be the difference between two points on the same line of lat or lon? |
|
Nov 29 |
comment |
Which SRS to use for global distance queries? Well, that is the point. Postgis is not fast enough for me. What I do right now is put all points in redis and make a KDtree index on top of it. BUT the KDtree is a geometric solution. If I ask it a question like "give all points in 1k radius" it treads the distance geometrically. I cant do haversine there. I need to convert it beforehand to a roughly equidistant SRS. But which one? |
|
Nov 29 |
asked | What is a delta in lat/lon called? |
|
Nov 29 |
asked | Which SRS to use for global distance queries? |
|
Nov 20 |
comment |
Django client install postgresql/postgis on Ubuntu 12.04 Thanks, but other comments where useful too... |
|
Nov 20 |
accepted | Django client install postgresql/postgis on Ubuntu 12.04 |
|
Nov 20 |
comment |
Django client install postgresql/postgis on Ubuntu 12.04 Found it: apt-get install binutils gdal-bin libproj-dev postgis python-psycopg2 python-setuptools |
|
Nov 20 |
comment |
Django client install postgresql/postgis on Ubuntu 12.04 Tried it, but postgresql-9.1-postgis also has postgresql-9.1 as an dependency. Is it possible to do this without that? |
|
Nov 20 |
asked | Django client install postgresql/postgis on Ubuntu 12.04 |
|
Oct 8 |
comment |
convert from c# to pythonpfeature.copy() ? |
|
Sep 6 |
comment |
Mapnik WKT rendering problem Yes, using the csv route does work. Now I know why python and geos input plugins are still experimental. |
|
Sep 6 |
awarded | Scholar |
