I would like to use SqlAlchemy with PostGIS to create, read, update, and query spatial data. I have search around a bit and found a few ideas of doing this [1][2] but I haven't seen a definitive best practice by any means. It looks like all the solutions I can find have a least some limitations.
Is anyone here using SqlAlchemy with spatial databases and if so how are you doing it right now? Specifically: - How do you handle table specification with geometry types? [1] tries to do this but it is incomplete - Do you use custom types and if so how are you doing this? [2] has some custom type code but it seems to be tied to binary formats and I don't see how to create/retrieve the geometry in text format. - How are you handling the object mapping? For example is there a way to map a "POINT" geometry to a python Point class or tuple? - Do you have any general recommendations for how to use spatial data successfully with SqlAlchemy? Thanks, Allen [1] http://www.mail-archive.com/[email protected]/msg03371.html [2] http://bycycle.org/2007/01/29/using-postgis-with-sqlalchemy/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
