Soil Sensor Locations

This dataset contains the locations of where soil sensors have been deployed across the city. The readings are stored in the <a href='https://data.melbourne.vic.gov.au/Environment/Soil-Sensor-Readings/mv4n-8k4v' target='_blank'>soil sensor readings dataset</a>. The sensors take a variety of readings such as salinity, temperature and moisture. The units and readings are included within the readings dataset. The dataset joins to the soil sensor readings dataset by matching the site_id column.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"melbourne-vic-gov-au/soil-sensor-locations-dxvp-runr\".\"soil_sensor_locations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.