Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

normalization mismatch for search/extract #234

Open
missinglink opened this issue Feb 21, 2020 · 0 comments
Open

normalization mismatch for search/extract #234

missinglink opened this issue Feb 21, 2020 · 0 comments

Comments

@missinglink
Copy link
Member

> a.street('beuthstraße')
[ 'beuthstrasse', 'beuth strasse' ]
sqlite> select * from names where id = 1990635;
3554177|1990635|beuthstraße
3554178|1990635|beuth straße
docker-compose run interpolation ./interpolate extract /data/address.db /data/street.db 52.50963118805493 13.401955235749485 beuthstraße
undefined
sqlite3 :memory: < tests.sql
123041870|1990635|OA|de/berlin:e67ccb17f8c132aa|1.0|52.5087661|13.40284|R|52.50875|13.402632
123041869|1990635|OA|de/berlin:face254800537468|1.03|52.5088398|13.4027748|R|52.5088131194434|13.4026051958528
123041868|1990635|OA|de/berlin:a1a2946f3af94cac|1.06|52.5089204|13.4027121|R|52.5088765260963|13.4025594660892
123041871|1990635|OA|de/berlin:801ac243742a200f|2.0|52.5090147|13.4026457|R|52.5089692345119|13.4024875284115
123041872|1990635|OA|de/berlin:d640fcc1b3a3d0b7|3.0|52.5091497|13.4025363|R|52.5091053266308|13.4023819268766
123041874|1990635|OA|de/berlin:a2517e2eea66e0cb|4.0|52.5092497|13.4024615|R|52.5092046697633|13.4023048409487
123041873|1990635|OA|de/berlin:eacfec31a478e67d|4.03|52.5093545|13.4023754|R|52.5093105932856|13.4022226489259
123041875|1990635|OA|de/berlin:c2892efdc4f8ee05|5.0|52.5095203|13.4022467|R|52.5094764044727|13.4020939866933
123041876|1990635|OA|de/berlin:39b49f7438ad72c7|6.0|52.5097384|13.4020772|R|52.5096931502367|13.4019233264138
123041878|1990635|OA|de/berlin:b8a63b4be6314738|7.0|52.5100261|13.40187|R|52.509976051559|13.4016989776398
123041880|1990635|OA|de/berlin:eb2d62df670599c3|8.0|52.5103593|13.401714|R|52.510283763401|13.4014558772081
123041899|1990635|OA|de/berlin:8df4473aca729ae1|22.0|52.5090447|13.4022067|L|52.5090969387299|13.402388435521
cat tests.sql
ATTACH DATABASE 'address.db' AS 'address';
ATTACH DATABASE 'street.db' AS 'street';

SELECT address.*
FROM street.rtree
JOIN street.names ON street.names.id = street.rtree.id
JOIN address ON address.id = street.rtree.id
WHERE (
  street.rtree.minX<=13.401955235749485 AND street.rtree.maxX>=13.401955235749485 AND
  street.rtree.minY<=52.50963118805493 AND street.rtree.maxY>=52.50963118805493
)
AND ( (street.names.name='beuthstraße') )
ORDER BY address.housenumber ASC
LIMIT 100;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant