Tablo is a lightweight Django application that creates a interface layer for interacting with spatial data stored within a PostGIS database.

The main goal of Tablo is to allow us to store data in a PostGIS database and be able to access it in the same way we access ArcGIS feature services.

We wanted to be able to query the data in the PostGIS database using a REST endpoint similar to this:

localhost:8383/tablo/arcgis/rest/services/905/FeatureServer/0/query?f=json
&returnGeometry=true&spatialRel=esriSpatialRelIntersects
&geometry={"xmin":-13697515.468700845,"ymin":5662246.477956772,
"xmax":-13619243.951736793,"ymax":5740517.994920822,
"spatialReference":{"wkid":3857}}
&geometryType=esriGeometryEnvelope&inSR=3857&outFields=*&outSR=3857

This allows us to take a CSV file like this:

Team Name	Name of the Stream	Longitude	Latitude	Temperature Reading
Fun Team	Columbia 'D' River	-122.2345	45.5483	60
Fun Team 2	Columbia River	-122.2869	45.5429	60
Fun Team	Columbia River	-122.4224	45.5655	65
Portlandias	Johnson Creek	-122.5849	45.4606	59
Portlandias	Johnson Creek	-122.5986	45.4551	61

And turn it into a map like this:

Full documentation available here.