[postgis-users] Postgis and Python

[Jorge Arévalo]

Hi George,

I suggest you to use PyGreSQL to connect with PostgreSQL from Python:
http://www.pygresql.org/

About the queries to extract the info, just check
http://postgis.refractions.net/documentation/manual-1.5/reference.html

Best regards,

-- 
Jorge Arévalo
Internet & Mobilty Division, DEIMOS
jorge.arevalo at deimos-space.com
http://es.linkedin.com/in/jorgearevalo80
http://mobility.grupodeimos.com/
http://gis4free.wordpress.com
http://geohash.org/ezjqgrgzz0g


On Fri, Apr 15, 2011 at 11:37 AM, Marco Lechner - FOSSGIS e.V.
<marco.lechner at fossgis.de> wrote:
> hi georg,
>
> this is no postgis-specific question. You connect from python as connecting
> to any postgresql-DB. You just have a bunch of postgis-functions available
> on SQl-side
>
> Marco
>
> P.S. if you are familiar with python you also could write new functions in
> postgreSQL using plpythonu as processing language within postgis/postgreSQL
>
> Am 15.04.2011 11:17, schrieb George Washington:
>
> 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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>