[postgis-users] Postgis and Python

[Nabil Servais]

Hello,

On Fri, Apr 15, 2011 at 11:17, George Washington <gws293 at hotmail.com> wrote:
> Hi, I am new to postgis (1.5 under Win 7) but have read enough to feel
> hopeful that it could be just what I need. I have a very large number of
> shape files which I have loaded in my first postgis database generating some
> hundreds of tables with vector data. So far so good, but now I need to use
> it to create queries and extract information in batch using Python. I have
> seen statements by people who used Python to access postgis databases but I
> have not been able to find any coded examples which show :
> 1) how to connect to the database
> 2) how to perform queries on the data
> 3) how to extract the results from the queries, etc...
>
> (all of which can be done in Python easily with MySql )
>
> Can you please point me to any document which gives examples or code
> fragments to do the above.
> Many thanks,
> George
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>

You can use a gis orm for python :

http://www.geoalchemy.org/

It's based on http://www.sqlalchemy.org/