Every geologist knows the 80/20 of reporting. Around 80% of the effort goes into getting the data into the right shape: exporting it, reshaping it in another program, hunting down last month’s query, working out which export gives the right output. The report itself gets the other 20%.
None of that is geology. It’s data handling, and it repeats on every project, every reporting cycle, for everyone who needs the same numbers. A better spreadsheet won’t fix it. Putting reports, queries and exports where the data already lives will.
That 80% is what 1point’s latest release solves. Reports, queries and exports now live where your data does, so the round trip stops being the default and your day goes back to the geology.
The hidden round trip behind every report
Most geology databases are great at storing data and not much help answering questions about it. So the ritual begins: pull the tables out, rebuild the logic in Excel or your modelling software, produce the report, spot an error in the source data, and do it all again.
Every handoff is a chance for a stale copy, a missed filter or a version nobody can trace. The real cost isn’t just the time. It’s that your report now lives one step away from the data it’s meant to describe.
Reports that run where your data lives
1point’s built-in reports cover the ones you already run. Header and lithology summaries, English logs, graphic logs, core photos, well completion reports, seam summaries, validation error reports and geophysical details are all there, with hole statistics like total metres drilled and average seam thickness alongside. Reports run straight from your data in seconds.
Trim the columns you don’t need, save the report as a template so you’re not rebuilding it next time, and export to Excel, CSV or PDF.
Then the bit that matters most: the way back. Spot something off in a report and jump straight to the source data in data entry or the LAS manager to fix it. No detective work to find which table the number came from.
See a report run straight from your data in the reports video.
Queries: write once, reuse endlessly
Rebuilding the same query every month is a big chunk of that 80%. Save the query once and that work is done. The query manager keeps every saved query in one place, each with a plain-English summary of what it does, so last month’s query is locatable and easy for the next person to understand, instead of being rebuilt from scratch.
Add parameters so one query covers different inputs, and you’re not maintaining a near-copy for each one. Give columns your own aliases, undo and redo as you build, and preview the SQL before you save. Build it once, then rerun it whenever the question comes back.
Query your drillhole data yourself
You don’t need to know SQL. The simple builder lets you join tables, apply filters and stack conditions with AND/OR groups. When you need custom SQL, switch to the advanced builder. The AI query assistant can help write the SQL from a plain-English description. You save time because the person who knows the geology can ask the question themselves, instead of waiting for the person who knows the database (and SQL).
Prefer seeing it to reading about it? Watch the query manager video to see it in action.
Two exports, so you find what you need faster
Exporting used to be one job. Now it’s two tools, because getting raw data out and getting an answer out are different jobs, and splitting them gets you to what you need faster.
Table data export is for raw tables. Pick exactly which drillholes, versions and tables you want, then download as CSV, Excel or a SQLite database.
Query export is for answers. Choose the drillholes and versions, pick the saved queries to run, input any required parameters and check the results before you export to Excel or a CSV archive (ZIP).
Speed up your exporting process: watch the exports video.
Shrink the distance between your data and your answer
The biggest takeaway from the latest 1point isn’t a single feature. It’s the direction.
- Reports run straight from your data in seconds
- Corrections happen at the source, not after another export
- Queries get saved and reused, not rebuilt
- Exports fit the job, not the other way around
- More of your day goes to the data
Geology data management is moving past storage. It’s becoming a place where you ask a question and the answer is already sitting next to the data, because reports, queries and exports all live there.
That’s the idea 1point is built around.
Book a discovery call to see reports, the query manager and export tools in 1point.
Frequently asked questions
What reports are built into 1point?
1point includes header and lithology summaries, English logs, graphic logs, core photos, well completion reports, seam summaries, validation error reports and geophysical details, plus hole statistics such as total metres drilled and average seam thickness. Reports can be exported as Excel, CSV or PDF.
Do I need to know SQL to query my data in 1point?
No. The simple builder uses AND/OR groups and previews how many records and drillholes match. The advanced builder supports joins and custom SQL, with an AI query assistant to help write it from plain English.
What’s the difference between table data export and query export?
Table data export downloads raw table data as CSV, Excel or a SQLite database, for the drillholes, versions and tables you choose. Query export runs saved queries for the drillholes and versions you choose and downloads the results as Excel or a CSV archive (ZIP), prompting for parameter values where a query has them.
Can I fix errors I find in a report without re-exporting the data?
Yes. From any report you can jump straight to the source data in data entry or the LAS manager and correct it there.