Working with Models
Every model in Geodb.io comes with a set of powerful, consistent features to help you manage and interact with your data seamlessly—whether you’re working in the web application or integrating with QGIS. A model is simply another word for Table, but we choose to it because of infers intentional design in the data structure, which has been built in.
Every model in Geodb.io comes with a set of powerful, consistent features to help you manage and interact with your data seamlessly—whether you’re working in the web application or integrating with QGIS. A model is simply another word for Table, but we choose to it because of infers intentional design in the data structure, which has been built in.
Model Characteristics
- Table View: Each model is available as an interactive table within the Geodb.io web application, giving you a clear overview of your data.
- QGIS Integration: Every model can be synced to QGIS using the Geodb.io QGIS plugin, enabling you to work with your data in a geospatial context effortlessly.
Accessing Options with the Offcanvas Menu
All table options are accessible via the offcanvas menu:
All table options are accessible via the offcanvas menu:
- On larger screens, look for the green arrow on the far left side of the table.
- On mobile devices, find it under the Menu arrow in the hamburger menu.
Filtering Results
Every model supports filtering to refine the data you see:
Every model supports filtering to refine the data you see:
- Open the offcanvas menu and expand the Filter tab.
- To create a filter:
- Go to the Save Filter sub-tab.
- Name your filter and enter the criteria you want to use.
- Hit Submit to save it. This autopopulates the filter in the Choose Filter tab.
- To apply or adjust a filter:
- In the Choose Filter tab, select an existing filter from the dropdown and click Load Filter, or use the newly created filter (already loaded).
- Adjust the parameters if needed, then click Apply Filter. The table will update to show only data matching your criteria, and any changes to the parameters will be saved.
- Filter management:
- Remove Filter: Clears the filter from the table without deleting it, preserving it for later use.
- Delete Filter: Deletes the filter entirely, refreshes the page, and removes it from your options.
Exporting Data
The Export Table option in the offcanvas menu lets you download your data:
- Export Formats:
- All models can be exported as an Excel spreadsheet (.xlsx) or CSV (.csv).
- Models with geometry (all Field Data models and DrillCollars) can also be exported as a GeoPackage (.gpkg) for use in GIS software like QGIS.
- Filtered Data: If a filter is applied, only the filtered subset of data will be exported.
- Images and Documents: These are included as clickable links in all export formats. Note: For security, these links expire 24 hours after export. Simply re-export the data to generate new links as needed.
Entering Data
How you input data depends on your access level within the company and project, as well as the model type:
- Single Entry: Available to all users with appropriate permissions. Manually input data into each field one entry at a time.
- Bulk Import: Available to users with administrative access for most models. Options include:
- CSV: Supported for all bulk-importable models.
- GeoPackage (.gpkg): Supported for models with geometry (e.g., Field Data models and DrillCollars).
- Bulk Import Exceptions: Models like Definitions, Documents, Photos, and Certificates require Geodb.io-specific customization and are limited to single-entry input to ensure accuracy.
- Bulk-Importable Models: All other models (e.g., Assays, QCSamples, LandHolding, PointSamples, DrillSamples, etc.) support bulk imports for efficient data loading.
These shared features make working with models in Geodb.io intuitive and flexible, whether you’re filtering data on the web, syncing to QGIS, or managing large datasets through imports and exports.