SepticModular
@SepticModular@quokk.au
- Comment on Self host a garden management software 14 hours ago:
This sounds more like a job for QGIS considering you are working trees. Partnered with QField, the app, you can create any number of “surveys” that will capture what you do on each pass (depending on how and what you set up), which you can then poll that data with the myriad of tools that QGIS has available. QField can also poll that data and display it to you in a limited form (QField is a mobile QGIS).
If you are fully pumped on the selfhost part, QFieldCloud can be selfhosted which each QField device can then sync to and from each project you set up on that “cloud”.
You can also go full data offline (if infield has spotty connection) if you create maptiles and share a basemap to each device via cable/network, or if you are selfhosting (or paid hosting) can also share those basemaps with each user. Borrowing a drone and mapping your property will get you extremely high quality basemap so you can zoom into even juvenile trees with a basic GPS but there are a lot of free imagery services about. There may be contour maps available for your area (our local government has 0.25m contours available), which you can stamp onto your basemap so people can instantly tell the lay of the land with a visual cue.
QField ships with 2 sample projects so you can get an idea (https://docs.qfield.org/get-started/sample-projects/). You can even import Excel sheets into QGIS if that interests you. Spreadsheet is good, but GIS adds a visual aspect to that reinforces the overall project and helps laypeople work out exactly what’s where. It basically is a spreadsheet/database under the hood with any number of visuals on top. However you write your survey/s will dictate what is captured in the database.