| 01:22:43 | dexteruk: | Hi can anyone help with mapnik and tilecache? |
| 02:05:26 | natte: | strange problem, postgres process dies with a bus error when importing some 20k rows ( multipolys ) from a shape file |
| 02:33:37 | CIA-3: | mloskot * r4176 /spike/wktraster/scripts/ovdump.py: [wktraster] Note on Frank's dumpoverview tool as an alternative |
| 02:34:52 | ha1331: | dexteruk: have you tried #openlayers or #openstreetmap ? Not any sort of authority here, but I'm thinking your question is not strictly speacing postgis related. |
| 02:35:45 | dexteruk: | ok thanks |
| 02:36:41 | ha1331: | And there he went. How rude of me. |
| 02:59:31 | ha1331: | I have database where I have openstreetmap data, used osm2pgsql tool. What I have gathered the streets are linestrings. I'm trying to create vehicle-tracking application. My question is, is it possible to query what street the vehicle is at? I have gps-trackers and I already store the information, but I would like to have the streetname also. So basicly is it possible to query what linestring is closest to a point? |
| 03:28:00 | CIA-3: | mloskot * r4177 /spike/wktraster/scripts/windownsample.py: [wktraster] Added downsampling simple util that mimics gdaladdo. It's going to be base for overview generator into gdal2wktarster. |
| 04:14:20 | simplexio: | ha1331: muuch better option is query wich line is closest to gps-point |
| 04:16:04 | ha1331: | simplexio: ok, well same difference to me. Just need to figure out the streetname : ) |
| 04:16:07 | simplexio: | ha1331: limiting spatial search around gps point |
| 04:17:22 | simplexio: | ha1331: you can read solution from my "thesis" after i get it done : ) |
| 04:19:22 | ha1331: | simplexio: sweet, will it be done today? |
| 04:19:28 | simplexio: | nope : ) |
| 04:19:56 | ha1331: | maybe let me have a sneek peek review on the part where the actual query is? |
| 04:20:03 | ha1331: | : ) |
| 04:20:12 | simplexio: | wait a sec.. if i find it |
| 04:20:26 | ha1331: | nice, you're the man |
| 04:23:35 | simplexio: | ha1331: with finnish comments.. taetaa kelevata ? |
| 04:27:33 | ha1331: | taetaapa hyviiinkii |
| 04:27:57 | simplexio: | http://pgsql.privatepaste.com/e10EPQwDZe |
| 04:28:00 | sigq: | Title: Private Paste :: Paste e10EPQwDZe ( at pgsql.privatepaste.com ) |
| 04:29:38 | simplexio: | ha1331: relevant part at this point is after second comment. select itself is used to get substring from longer line and define distance from beginning of that line |
| 05:40:29 | CIA-3: | mloskot * r4178 /spike/wktraster/scripts/windownsample.py: [wktraster] windownsample.py: enabled processing of all bands not only first one |
| 08:21:38 | CIA-3: | mloskot * r4179 /spike/wktraster/scripts/windownsample.py: [wktraster] windownsample.py: dump scanlines of in-memory block of raster fetched using RasterIO |
| 18:44:18 | ltcabral: | err is this pg_relation_size( '<table>' ) function trustable?? 78 points -> 16384 bytes and 95 points -> 8192 bytes :P |