| 00:03:26 | razla: | When comparing PostGIS to Oracle spatial and MySQL with spatial extention, what are the main factors or areas you'd investigate/compare? |
| 00:50:00 | razla: | I'm searching for like a hypothesis type of statement on making comparison analysis in aspects of spatial dbms, any suggestions? |
| 01:14:13 | CIA-34: | mloskot * r3946 /spike/wktraster/scripts/ ( Makefile.rt Makefile.rt.sample ): [wktraster] Renamed scripts/Makefile.rt to scripts.Makefile.rt.sample. |
| 02:58:14 | mloskot: | holy cow, how could I forget to calculate georeferencing for tiles |
| 02:58:37 | mloskot: | @seen pracine |
| 02:58:37 | sigq: | mloskot: pracine was last seen in #postgis 3 weeks, 2 days, 17 hours, 56 minutes, and 23 seconds ago: <pracine> ok |
| 02:58:49 | strk: | you may try to guess, sinc eyou're doing "regular blocking" : ) |
| 02:59:05 | strk: | should take far less then 40 minutes for an SQL call : ) |
| 02:59:21 | : | * strk just read mloskot's blog posts about crunching... |
| 03:00:03 | mloskot: | strk: re 40 min, probably it would |
| 03:00:52 | : | * mloskot - the god of being smart-ass - has put shame on himself |
| 03:02:11 | strk: | it'd take less then 12 minutes |
| 03:02:35 | mloskot: | yes Sir : ) |
| 03:49:39 | CIA-34: | mloskot * r3947 /spike/wktraster/scripts/gdal2wktraster.py: [wktraster] Added missing calculation of georeferencing for tiles. Previously, each tile was generated using the same geo-transformation parameters ( upper-left corner ), quite a bug. |
| 06:11:27 | sanova: | hi all |
| 06:13:08 | sanova: | i'm trying to find a way to connect a db in postgre to a shape published in web throught a web-gis application. is possible to do that? anyone can help me? |
| 06:15:45 | sanova: | i have done a join between dbf and table in postgre through mapfile ( so mapserver ) but it doesn't work fine |
| 06:16:12 | sanova: | is there a solution ? |
| 06:17:35 | strk: | have asked on #mapserver ? |
| 06:20:03 | mloskot: | sanova: yes, it is possible to do that and yes there is a solution. |
| 06:20:18 | CIA-34: | mloskot * r3948 /spike/wktraster/scripts/window.py: [wktraster] Added scripts/window.py - a simple replacement for pencil-and-paper to calculate window corners of given raster using georeferencing information. |
| 06:20:24 | mloskot: | ls -l |
| 06:20:46 | sanova: | strk, yes i asked on mapserver |
| 06:22:07 | sanova: | mloskot, oh great news : ) |
| 06:22:07 | ue: | sanova, write a scriptsthat downloads that file & shp2pgsql to your db, ~every 1 day for example |
| 06:23:30 | mloskot: | sanova: or expose your file using a service that can dump geojson, then use ogr2ogr to dump geojson to shapefile, then use shp2pgsql ( or again ogr2ogr ) to dump it to postgis |
| 06:24:36 | mloskot: | ogr2ogr can eat geojson stuff directly from network resource, like http:// |
| 06:25:25 | sanova: | mloskot, thank you .. i have to read slowly to understand the method |
| 06:25:32 | mloskot: | strk: do you have suggestion how to automagically tick rt_lib_version on every build? |
| 06:25:57 | mloskot: | strk: what you think about setting it from $Revision$ for now, so it's easy to identify what you are playing with |
| 06:26:00 | mloskot: | while testing |
| 06:26:09 | mloskot: | 0.0.0 does not tell much |
| 06:26:21 | strk: | I know, $Revision$ would be a step forward |
| 06:27:53 | mloskot: | I'll set it for now, not ideal as it reports rev of the file, but always better |
| 06:30:02 | strk: | have ./autogen.sh use revno |
| 06:30:47 | CIA-34: | mloskot * r3949 /spike/wktraster/configure.ac: [wktraster] Use $ as RT_LIB_VERSION for now, temporarily. |
| 06:34:55 | sigq: | geosfeed: Ticket #245 ( defect created ): GEOSGeomToWKT( ) not include the SRID? <http://trac.osgeo.org/geos/ticket/245> |
| 06:36:56 | sigq: | geosfeed: Ticket #245 ( defect closed ): GEOSGeomToWKT( ) not include the SRID? <http://trac.osgeo.org/geos/ticket/245#comment:1> |
| 06:46:29 | CIA-34: | mloskot * r3950 /spike/wktraster/scripts/gdal2wktraster.py: [wktraster] Fixed undefined values in calculate_geoxy function in gdal2wktraster.py. |
| 08:17:36 | CIA-34: | mloskot * r3951 /spike/wktraster/scripts/gdal2wktraster.py: [wktraster] Issue warning if input raster has no NODATA value and write Zero in corresponding bytes. |
| 09:12:39 | : | * mloskot is dealing with a very mysterious issue in wktraster, quite funky |
| 09:13:03 | mloskot: | Anyone intersted, look at discussion + 2 URLs I pasted on #gdal |
| 09:13:04 | mloskot: | http://logs.qgis.org/gdal/%23gdal.2009-03-31.log |
| 09:13:05 | sigq: | Title: IRC Log - #GDAL ( at logs.qgis.org ) |
| 09:13:13 | mloskot: | start from 09:04:44 |
| 09:13:19 | mloskot: | That's a pity strk is not here |
| 09:15:14 | mloskot: | bye |
| 10:50:49 | tbnorth: | hi all - this is OT sry, but what's the best python binding for lat/long <-> UTM conversions? pyproj for proj4? |
| 15:09:34 | samgranieri: | Hi everyone, i'm new at GIS and I'm stuck trying to figure out how to get latitude and longitude from a shapefile. http://gist.github.com/88465 . If any of you can help, it would be much appreciated! |
| 15:09:36 | sigq: | Title: gist: 88465 - GitHub ( at gist.github.com ) |
| 15:47:44 | samgranieri: | i actually got it to work |
| 15:48:06 | samgranieri: | i had to look up the srid online, http://spatialreference.org/ref/esri/102671/postgis/ |
| 16:43:29 | pramsey: | well done, samgranieri, good work for a newbie. |
| 16:43:58 | samgranieri: | thx |