Commit executed outputs for the geography query notebook
Nessuno ha ancora preso questa issue.
Valutazione
- Difficoltà
- 4/5
- Tempo stimato
- 3-5 giorni
- Idoneità per principianti
- 45/100
- Tipo di issue
- Documentazione
- Chiarezza
- Specificata chiaramente
- Stato di attività
- Tranquilla
- Ambito
- databases, documentation
Direzione di ricerca
Attendi che apache/sedona-db#1084 e #1085 vengano rilasciati, quindi installa docs/requirements.txt e genera o scarica i dati SF1. Esegui notebooks/geography-queries.ipynb dall’inizio alla fine, rigenera docs/geography-queries.md con il front matter e l’intestazione ASF esistenti, esegui pre-commit sui file modificati e replica i blocchi di output in docs/geography-queries.zh.md. Il lavoro è completato quando gli output documentati superano i controlli di coerenza elencati per Q2, Q3, Q4 e Q9.
Scritto dal modello di indicizzazione a partire dal testo della issue.
Descrizione
Follow-up to #131, which adds the geography query suite.
notebooks/queries.ipynb ships with executed outputs — every query cell has a result table, and those tables are what appear in docs/queries.md. notebooks/geography-queries.ipynb was committed without outputs, because executing it today would put misleading results into the docs.
Why it was deferred
Two SedonaDB defects, both filed and both engine-side:
- apache/sedona-db#1084 — a geography scalar function over the output of a geography spatial join fails with
Array input must not be empty. Q9 raises this, so its cell would carry an error traceback. - apache/sedona-db#1085 — one zone polygon of 156 095 (
z_zonekey150480) returns a negative geographyST_Areaand matches points anywhere on Earth. Q4, Q6, Q10 and Q11 are all distorted by it: at SF1, Q6 would displayShendi | 5999980— essentially every trip in the dataset, for a county nowhere near the query area — and Q11 would report 6 290 682 cross-zone trips against the planar suite's 176 391.
Committing those outputs would document engine bugs as if they were the queries' results, and the page deliberately carries no engine-defect discussion.
Executing only the sound subset was considered and rejected: a notebook where some cells have outputs and others do not reads as broken rather than deliberate.
What to do
Once #1084 and #1085 are released:
- Install the docs environment (
docs/requirements.txt, which bringsapache-sedona[db]) and generate or download SF1 data. - Run
notebooks/geography-queries.ipynbtop to bottom. Q12 is a markdown cell, not a code cell, so it will not error — it needs a geographyST_KNN(apache/sedona-db#1086, apache/sedona#3178). - Regenerate the page:
python -m nbconvert --to markdown notebooks/geography-queries.ipynb, then re-prepend the YAML front matter and ASF license header thatdocs/geography-queries.mdcarries (the notebook itself is RAT-excluded via*.ipynb; the page is not, unlikedocs/queries.md). - Run
pre-commit run --files ...— the end-of-file fixer adjusts nbconvert's trailing newlines. - Mirror the new output blocks into
docs/geography-queries.zh.md, which is maintained by hand from the English page.
Sanity checks worth keeping
At SF1 the geography results were verified against the committed geometry answers: Q2 matches exactly (541), Q3 matches its row count (22), Q4 reproduces the geometry answer row for row (258 zones, same counts, same order) once the #1085 polygon is excluded, and Q9's self-join finds the same 37 building pairs. Those are good regression anchors when the outputs are finally committed.
- Lingua principale
- Rust
- Stelle
- 50
- Fork
- 23
- Metriche di merge delle PR
- Nessuna PR unita negli ultimi 30g
Preparare l'ambiente
- Nessun Dockerfile né file Docker Compose
- Nessun modello di pull request
- Leggi la guida per i contributori
Come iniziare
- Leggi tutta la issue e poi la guida ai contributi del progetto.
- Commenta sulla issue per dire che te ne occupi tu — evita che due persone facciano lo stesso lavoro.
- Fai un fork del repository e lavora su un branch.
- Apri una pull request che faccia riferimento al numero della issue.
Altre issue di apache/sedona-spatialbench
-
[FEATURE] Updated Single Node ResultsForse di nuovo libera @prantogg l’ha presa 71 giorni fa e non c’è nessuna pull request aperta. Apertaenhancement
apache/sedona-spatialbench#140 · 1 commento · 1 assegnatario ·
-
enhancement
Difficoltà 5/5 Più di una settimana Idoneità per principianti 30/100
apache/sedona-spatialbench#134 ·
-
Add the ASF Allowlist Check workflowForse già presa @jbampton l’ha presa 140 giorni fa. Apertagithub actions good first issue in progress
apache/sedona-spatialbench#103 · 1 assegnatario ·
-
[FEATURE] all uncompressed file sizes for different scale factorsForse di nuovo libera @prantogg l’ha presa 339 giorni fa e non c’è nessuna pull request aperta. Apertaenhancement
apache/sedona-spatialbench#67 · 4 commenti · 1 assegnatario ·
-
[FEATURE] Add a python script or CLI app to run/time the benchmark queriesForse di nuovo libera @prantogg l’ha presa 358 giorni fa e non c’è nessuna pull request aperta. Apertaenhancement
apache/sedona-spatialbench#62 · 1 commento · 1 assegnatario ·
Tutte le issue di apache/sedona-spatialbench
Issue simili
-
bug priority: low
Difficoltà 2/5 1-3 ore Idoneità per principianti 78/100
storytold/photocraft#12183 · 1 commento ·
I maintainer di solito rispondono entro 2 giorni
-
area:render needs-triage
Difficoltà 2/5 1-3 ore Idoneità per principianti 78/100
bherbruck/solvecraft#13138 ·
-
testing
Difficoltà 2/5 1-3 ore Idoneità per principianti 65/100
-
Difficoltà 2/5 1-3 ore Idoneità per principianti 86/100
ratatui/ratatui-textarea#39 ·
-
bug
Difficoltà 2/5 1-3 ore Idoneità per principianti 68/100
transit-audio/transit#369 ·