8 | | An option should be provided to store in [http://postgis.refractions.net PostGIS], [http://www.gaia-gis.it/spatialite Spatialite] or even [http://gitorious.org/geocouch/ GeoCouch] instead, where available, as then can have spatial indexes for speed.[[BR]] |
9 | | Q: Could we extend DAL for spatial indexes? |
10 | | * [http://groups.google.com/group/web2py/browse_thread/thread/7551b50ef3ca72a8 DAL can be bypassed] to allow other ORMs to be used: {{{response.custom_commit=lambda: do_commit()}}} |
| 8 | An option should be provided to store in [http://postgis.refractions.net PostGIS], [http://www.gaia-gis.it/spatialite Spatialite] or even [http://gitorious.org/geocouch/ GeoCouch] instead, where available, as then can have spatial indexes for speed. |
| 9 | |
| 10 | We can extend DAL for spatial support: |
| 11 | * adding if deployment_settings.gis.spatialdb == True and deployment_settings.database.db_type == "postgres" to routines inside S3GIS' spaital functions to use optimsied routines where possible & falling back to the existing Shapely routines. |
| 12 | |
| 13 | We could [http://groups.google.com/group/web2py/browse_thread/thread/7551b50ef3ca72a8 bypass DAL completely] & use an ORM like GeoAlchemy |
| 14 | {{{ |
| 15 | response.custom_commit=lambda: do_commit() |
| 16 | }}} |