Re: [web2py] geodal

2013-01-08 Thread paolo.vall...@gmail.com
Done, http://code.google.com/p/web2py/issues/detail?id=1259&thanks=1259&ts=1357666735 Thanks Paolo 2013/1/8 Massimo Di Pierro > Please open a ticket so I will look into it asap. I would add the st_x/y > to all GIS adapters. > > > On Tuesday, January 8, 2013 9:36:57 AM UTC-6, Paolo valleri wrot

Re: [web2py] geodal

2013-01-08 Thread Massimo Di Pierro
Please open a ticket so I will look into it asap. I would add the st_x/y to all GIS adapters. On Tuesday, January 8, 2013 9:36:57 AM UTC-6, Paolo valleri wrote: > > Hi Massimo, good to know that the patch is in trunk but I it is only for > the postgres adapter, I can try to define the same funct

Re: [web2py] geodal

2013-01-08 Thread Paolo valleri
Hi Massimo, good to know that the patch is in trunk but I it is only for the postgres adapter, I can try to define the same functions for the other adapter but then someone has to check if they works or not. For what concern the other issue I will open I ticket, the main problem is that web2py

Re: [web2py] geodal

2013-01-08 Thread Massimo Di Pierro
In trunk. How about the previous issue? Is that still open? If so, can you please open a ticket? Thanks. On Tuesday, 8 January 2013 05:31:28 UTC-6, Paolo valleri wrote: > > Hi all, I have a simple problem, how I can extract values of a single > point? > I found that there are the functions ST_X,

Re: [web2py] geodal

2013-01-08 Thread Paolo valleri
Hi all, I have a simple problem, how I can extract values of a single point? I found that there are the functions ST_X, and ST_Y. Please find attached a patch that add them to dal and to the postgres adapter, I haven't put them neither to MSSQLAdapter nor to SQLITESpatiaLiteAdapter because I don'

Re: [web2py] geodal

2013-01-06 Thread Paolo valleri
well done! All the former tests worked. I will investigate more the others functions as soon as possible. Paolo On Sunday, January 6, 2013 4:28:13 PM UTC+1, Massimo Di Pierro wrote: > > One more try please. > > On Sunday, 6 January 2013 02:11:09 UTC-6, Paolo valleri wrote: >> >> Hi Massimo, I'

Re: [web2py] geodal

2013-01-06 Thread Massimo Di Pierro
One more try please. On Sunday, 6 January 2013 02:11:09 UTC-6, Paolo valleri wrote: > > Hi Massimo, I've tried the same 3 tests. > The first one failed, it was working before though, the ticket: > > Traceback (most recent call last): > File "/home/paolo/Dropbox/git/web2py/gluon/restricted.py",

Re: [web2py] geodal

2013-01-06 Thread Paolo valleri
Hi Massimo, I've tried the same 3 tests. The first one failed, it was working before though, the ticket: Traceback (most recent call last): File "/home/paolo/Dropbox/git/web2py/gluon/restricted.py", line 212, in restricted exec ccode in environment File "/home/paolo/Dropbox/git/web2py/app

Re: [web2py] geodal

2013-01-05 Thread Massimo Di Pierro
If something still fails, can you place post the result of print db(...) _select(...) On Saturday, 5 January 2013 18:45:26 UTC-6, Massimo Di Pierro wrote: > > I made some changes in trunk. Can you please try again? > > On Saturday, 5 January 2013 07:05:48 UTC-6, Paolo valleri wrote: >> >> Hi, I m

Re: [web2py] geodal

2013-01-05 Thread Massimo Di Pierro
I made some changes in trunk. Can you please try again? On Saturday, 5 January 2013 07:05:48 UTC-6, Paolo valleri wrote: > > Hi, I made a few more tests: > from gluon.dal import geoPoint, geoLine, geoPolygon > db.define_table('test_geo', > Field('loc_test','geometry()')) > db.test

Re: [web2py] geodal

2013-01-05 Thread Alec Taylor
Thanks, will test it tomorrow. Examples with long/lat inserts, extracts and distance comparisons would also be handy for the book. On Sun, Dec 23, 2012 at 4:50 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > I made some changes to the DAL geo APIs. This is an experimental feature >

Re: [web2py] geodal

2013-01-05 Thread Paolo valleri
Hi Massimo, I have just tried a few examples but there is a bug in the getPoint function, please find attached a simple patch to fix it. Paolo On Monday, December 24, 2012 7:21:12 PM UTC+1, Massimo Di Pierro wrote: > > Thank you Denes. Would you please check my changes. I do not think I broke >

Re: [web2py] geodal

2012-12-24 Thread Massimo Di Pierro
Thank you Denes. Would you please check my changes. I do not think I broke anything but I tried to make it so that it always returns st_astext if not specified and created Python functions to generate geoPoint/geoLine/geoPolygon. I think it makes code more readable. On Monday, 24 December 2012

Re: [web2py] geodal

2012-12-24 Thread DenesL
The original post (Spatial / GIS support in DAL): https://groups.google.com/d/topic/web2py/feh1ksfdkGk/discussion --

Re: [web2py] geodal

2012-12-22 Thread Massimo Di Pierro
For the record, this feature has been in since summer 2011. It was sponsored by the Sahana project and implemented by Denes. It was only documented in an email from Denes. I have now added it to the manual and changed the APIs a little to make more human friendly. The API could use more work bu

Re: [web2py] geodal

2012-12-22 Thread Bruno Rocha
Excelent! I did not know DAL has its support, In my new project I will use this with Postgres, trying to test it today. Thank you again. --