Skip to content

History / Join_equal_values

Revisions

  • #1281 pareto_optimal: the non-dominated elements per partition by a sort and a sweep New page pareto_optimal.md: syntax, the weak-dominance rule with first-of-duplicates, the null rule, the relation to the pareto option of impedance_matrix, since 20.21.0, an example table. Linked from Relational-functions.md (beside the join_equal_values family it replaces for this purpose), from the see-also of Join_equal_values.md, and from the pareto section of Impedance-options.md. The page is not in nav/geodms.md of the converter yet. Co-Authored-By: Claude Fable 5.1 <noreply@anthropic.com>

    @MaartenHilferink MaartenHilferink committed Sep 23, 2026
  • Add Spatial joins and allocation: the matching functions as joins, and the road from a database to an allocation model A new page that connects the functions which match two domain units the way a JOIN does in SQL: join_equal_values and rlookup on a given key; the pair-producing spatial pre-selections (join_near_values, connect_matrix / dist_matrix, point_in_all_polygons, geos_overlay_polygon, impedance_matrix) as inner joins; connect, connect_info, point_in_polygon, impedance_table, capacitated_connect and discrete_alloc as left joins that already chose one match per row; and how a pair domain aggregates into a relation but not back. The last section traces, in five steps, how a customer-order-product database differs from a spatial interaction or allocation model: the join table is recorded there, and derived, chosen, distributed and finally optimised under competing claims here. Spatial-join now opens with a sentence (it opened with a code block, which loses the search snippet) and names itself as the Cartesian-product form. Reverse links on How-To-Model, Relational-model-versus-Semantic-arrays, the Relational, Network, Allocation and point-polygon hubs, and the see-also of join_equal_values, join_near_values, connect_matrix, geos_overlay_polygon and impedance_matrix. The page is not in the geodms.nl menu until nav/geodms.md in GeoDmsWikiToStaticHtml lists it. Co-Authored-By: Claude Fable 5.1 <noreply@anthropic.com>

    @MaartenHilferink MaartenHilferink committed Sep 3, 2026
  • join_equal_values: the values unit of the join key no longer needs a limited range Documents the current implementation (GeoDMS issue 1175): - applies to: an integer-valued attribute, usually a relation to a domain unit, instead of "a uint32 relation". - conditions: dropped "must represent a valid domain X"; added that rows with an undefined or out-of-range X do not participate in any combination. - new implementation section: the direct slot array over the range of X versus the index over the values that actually occur, and the rule that selects between them. - performance: the cost of each variant, and that memory follows the number of candidate values rather than the range of X. - states the result row order (ascending X, then row number in A, then in B), which both variants share. Co-Authored-By: Claude Opus 5 <noreply@anthropic.com>

    @jipclaassens jipclaassens committed Aug 11, 2026
  • Fix migration artifacts, typos and dead links across the wiki Sweep of all 867 pages: MediaWiki-to-GitHub migration damage repaired (wikilink artifacts, reversed link order, broken code blocks, image links restored as embeds), 2200+ typo/grammar/dead-link fixes, and remaining CalcCache references removed or marked version-historical. Factual example errors corrected where unambiguous (a.o. Boundcenter, Ge_or_rhs_null, Capacitated_connect, Dpoint, Modus). Co-Authored-By: Claude Fable 5 <noreply@anthropic.com>

    @jipclaassens jipclaassens committed Jul 6, 2026
  • #988 Add new function docs, performance notes, and doc updates - Added documentation for new functions: HtmlEncode/Decode, UrlEncode/Decode, to_utf, split_piped_string, first_point, last_point, outer_single_polygon, outer_multi_polygon, join_near_values, triangualize, griddist_maximp, griddist_zonal, griddist_latitude_specific, invertAll, greedy_alloc, matr_mul/inv/var, strongly_connected_components, Mandelbrot, sd, var, impedance_matrix - Added detailed performance sections to many function/operator docs - Updated function index and overview pages with new functions and aliases - Improved .gitignore and _Sidebar.md, added navigation links and tools - Updated Projects.md with new project references and links - Rewrote Debugging.md with Visual Studio 2026 instructions and tips - Added referenced_pages.txt and orphaned/unreferenced page tracking files - Improved clarity, formatting, and cross-linking throughout documentation - Fixed typos and updated links and references

    @MaartenHilferink MaartenHilferink committed Apr 8, 2026
  • Updated Join_equal_values (markdown)

    @mtbeek32 mtbeek32 committed Jan 31, 2024
  • Updated Join_equal_values (markdown)

    @MaartenHilferink MaartenHilferink committed Jan 22, 2024
  • Updated Join_equal_values (markdown)

    @MaartenHilferink MaartenHilferink committed Jan 22, 2024
  • Updated Join_equal_values (markdown)

    @MaartenHilferink MaartenHilferink committed Jan 22, 2024
  • Updated Join_equal_values (markdown)

    @mtbeek32 mtbeek32 committed Jul 7, 2023
  • Updated Join_equal_values (markdown)

    @MaartenHilferink MaartenHilferink committed Apr 8, 2023
  • Updated Join_equal_values (markdown)

    @mtbeek32 mtbeek32 committed Jan 19, 2023
  • Bulk import title/permalink for pages with spaces

    @mtbeek32 mtbeek32 committed Jan 2, 2023
  • bulk import improved links

    @mtbeek32 mtbeek32 committed Jan 2, 2023
  • First port of geodms mediawiki to github markdown

    @erikandthecicada erikandthecicada committed Dec 7, 2022