Changes for version 0.023.0 - 2026-11-10
- Enhancements
- Maps can outline the county each marker is in: tick Show county boundaries in the map panel (bounds=county). The outlines come from OpenStreetMap, which is sent each marker's position rounded to about 100 metres, and are remembered. A checkbox on the map hides them (HTML::OSM 0.15). A county is the level below a country's states, so India, Bangladesh and China get districts, Spain provinces, Kenya counties; map_bounds_ranks in the configuration sets other countries. With the heat layer on, the outlines go from green to red by the weight column's total in each county (or its rows), each step the same multiple, with a key to the colours on the map (HTML::OSM 0.16). The map calls an outline a district, province and so on where it is one. When the markers are coloured the outlines take their colours instead. Each coloured outline is drawn inside its own edge, so neighbours of different colours show side by side, and a county holding markers of two colours gets a line of each (HTML::OSM 0.17). A key gives its totals in round figures; each outline's popup has the exact one.
- Colour shade, in the map panel (shade=, shade_color=): fills each county outline in a shade of one colour, darker for a larger total of a column, with a key to the shades (boxes with HTML::OSM 0.18). With coloured markers each county is shaded in its markers' colour, stronger the further into that colour's rule (greenest furthest below a "less than" rule). The key then lists every shade by size, and stands in for the markers' own key, which comes back while the outlines are hidden (HTML::OSM 0.19).
- Under a map with outlines, a list of the outlines holding more than one marker and of the markers in no outline, each with a link to its rows: a place looked up by an ambiguous name shows up there. A note that some places have no outline yet links to their rows, and to try again.
- Add to each place, in the map panel (loc_text=): text added to the end of every place before it is looked up, such as "Virginia, USA" for a column of county names. Remember columns keeps it too, and script/bi-geocode takes it as --text.
Documentation
check the measures of saved Database::BI canvases against thresholds
build the extracts of Database::BI's accelerated datasets
fill Database::BI's geocode cache for a column of places
start Database::BI, or run one of its commands
Modules
Web-based Business Intelligence viewer for data files
Natural language to analysis spec
Where a cache keeps its files
Safe recursive-descent expression evaluator for Database::BI
Make the password_hash for the login
Home picker, filesystem browser, table viewer, left-join engine, result filter, export, and file upload
SQLite materialisation cache for Database::BI
Choose the language of messages, and give them in it
The application's messages in American English
Automatic statistical insights for Database::BI (Phase 5.2)
The county outline around each map marker
Table-agnostic adapter around Database::Abstraction
Resolve a location column to coordinates, once per distinct value
Hash and check the login password
Fetch a URL only if it leads to the public internet
Session cookies that are Secure over https
Narrative summary generation for an analysis result
the chapters of the in-application tutorial
Shared utility functions for Database::BI modules