Re: [web2py] st_within example

2016-09-08 Thread Manuele Pesenti
Il 08/09/16 10:57, Gael Princivalle ha scritto:
> Hello.
>
> Could someone give me an example of the postgis st_within function?
>
> http://postgis.org/docs/ST_DWithin.html
>
> Model
> |
> db.define_table('places',Field('loc','geometry()'))
> |
> Where I insert 3 geoPoints:
> |
> geoPoint(1,1)geoPoint(3,2)geoPoint(6,5)
> |
>
> |
> query =db.places.loc.st_within(geoPoint(0,0),3)
> |
> geoPoint(0, 0) is my geometry 3 is the max. distance from this geometry
> |
> results =db(query).select(sp.id,sp.loc)
> |
> Ticket is:
> |
> st_within()takes exactly 2arguments (3given)
> |
|Hi Gael,
the st_within and st_dwithin are two different method, the second one is
the only you want now :)
|
>
> That's strange because I have 2 arguments:
> |
> geoPoint(0,0)3
> |
> Can someone give a hand? Thanks.
>
> -- 
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google
> Groups "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to web2py+unsubscr...@googlegroups.com
> .
> For more options, visit https://groups.google.com/d/optout.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] st_within example

2016-09-08 Thread Gael Princivalle
Hello.

Could someone give me an example of the postgis st_within function?

http://postgis.org/docs/ST_DWithin.html

Model

db.define_table('places', Field('loc', 'geometry()'))

Where I insert 3 geoPoints:
geoPoint(1, 1)
geoPoint(3, 2)
geoPoint(6, 5)


query = db.places.loc.st_within(geoPoint(0, 0), 3)
geoPoint(0, 0) is my geometry
3 is the max. distance from this geometry

results = db(query).select(sp.id, sp.loc)

Ticket is:
st_within() takes exactly 2 arguments (3 given)

That's strange because I have 2 arguments:

geoPoint(0, 0)
3

Can someone give a hand?

Thanks.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.