Re: [sqlalchemy] Type mismatch on a GeoAlchemy2 query?

2017-02-08 Thread mike bayer
no worries, those errors from PG are very common and while I used to be kind of scared off by them for a long time, I realized they are actually very useful as PG has strict typing behavior. On 02/08/2017 05:41 PM, Andrew M wrote: Thanks Mike, it was kind of you to reply and you are, of

Re: [sqlalchemy] Type mismatch on a GeoAlchemy2 query?

2017-02-08 Thread Andrew M
Thanks Mike, it was kind of you to reply and you are, of course, correct. I think this was a case of type blindness on my part - I hadn't noticed the difference between 'geography' and 'geometry', and I'm still too much of a noob (*sigh*) to properly interpret this kind of error message.

Re: [sqlalchemy] Type mismatch on a GeoAlchemy2 query?

2017-02-08 Thread mike bayer
On 02/08/2017 03:06 PM, Andrew M wrote: Hi, I'm stuck on a query which might be a PostGIS problem, sorry, but in case it relates to the SQLAlchemy side (or someone can help regardless) I'm posting it here. I want to run a query which returns every point which falls within a rectangle, where

[sqlalchemy] Type mismatch on a GeoAlchemy2 query?

2017-02-08 Thread Andrew M
Hi, I'm stuck on a query which might be a PostGIS problem, sorry, but in case it relates to the SQLAlchemy side (or someone can help regardless) I'm posting it here. I want to run a query which returns every point which falls within a rectangle, where the points and the rectangle are based on