Resource

Geodata

Tips for using (Spatial) SQL to manage your farm

Edit

On this page we are collecting tips on the use of non-proprietary, low cost, open source tools and learning resources. The source of it is the experience of the Open Farming Hackdays teams, and several "awesome" lists - in particularawesome-geospatial that is linked in the Source.

Collection

The basic ingredient of spatial data is best made using portable and reliable apps and mobile devices. You can also start with open data sources - here are just a couple of examples amongst many others:

  • QField
  • Ushahidi
  • OsmAnd
  • Nominatim
  • Swisstopo

Formats

The building blocks of interoperability are these open formats, into which standards of geospatial data exchange are baked in:

  • GeoJSON
  • Geopackage
  • Parquet
  • CSV

Exploration

To visualize your data and combine it with other maps, you will find these tools of data visualization easy to install, learn, and share with others:.

  • Leaflet
  • Maplibre
  • OpenLayers
  • Cesium

Analytics

Asking questions about the data, making improvements, controlling quality, creating new layers and layer compositions for further visualization:

  • SpatiaLite
  • PostGIS
  • Datasette

Workflows

Connecting the analytical system to notifications and dashboards and other instruments, so as to make spatial data part of your daily business:

  • Airflow
  • Mattermost
  • n8n
πŸ’‘ Open Source Tools fΓΌr Prototyping gibt es auf schoolofdata.ch

Weitere Tipps bitte auf Slack empfehlen πŸ‘‰ #datensets_and_tools

All attendees, sponsors, partners, volunteers and staff at our hackathon are required to agree with the Hack Code of Conduct. Organisers will enforce this code throughout the event. We expect cooperation from all participants to ensure a safe environment for everybody.

Creative Commons LicenceThe contents of this website, unless otherwise stated, are licensed under a Creative Commons Attribution 4.0 International License.