search

hackoregon / transportation-systems

Hack Oregon Repository to develop code for the Transportation Theme of CIVIC.
MIT License
5 stars 2 forks source link

Explore feasibility of doing GIS API using Spatialite instead of PostGIS for ridership data #28

Closed znmeb closed 6 years ago

znmeb commented 6 years ago

GeoDjango is capable of using Spatialite as a back end instead of PostGIS. (https://docs.djangoproject.com/en/2.0/ref/contrib/gis/install/#spatial-database). While PostGIS is preferred, our deployed application may not have a PostGIS server available, just PostgreSQL.

The ridership data is small-ish and very tidy - Spatialite should be capable of doing any GIS work GeoDjango has to do. And the Spatialite database is an SQLite database - it's just a file that lives in the same filesystem image as the container serving up the Django REST Framework API.

znmeb commented 6 years ago

Spatialite home page: https://www.gaia-gis.it/gaia-sins/

znmeb commented 6 years ago

Closing - so far the only Spatialite use case is the Census GDBs with the 1740-column table. Spatialite's in the data-science-pet-containers if we need it