[postgis-users] Postgis and Python

[IvoSilvestre]

Hello George,

You can also try Psycopg2:
http://initd.org/


Best regards,
Ivo.



2011/4/15 Jorge Arévalo <jorge.arevalo at deimos-space.com>

> 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
> >
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110415/0f53104f/attachment.html>