query for gleimstrasse fails to match
Opened this issue · 0 comments
missinglink commented
query for gleimstrasse, berlin fails to match despite having rows in the db (matching logic bug?)
/extract/geojson?lat=52.546892&lon=13.404291&names=gleim%20strasse
select * from polyline where id = 20012388;
20012388|{qffcBizmqXTdEVlG~H|~BtJrqB\tFpB`d@|Jj}BdEv_AjA~V?jJN|GO}G?kJkA}VeEy_A}Jk}BqBad@]uFuJsqB_I{~BWoGUcEkQexEjQbxE
sqlite> select * from names where id = 20012388;
29100033|20012388|gleimstraße
29100034|20012388|gleim straße
select * from address where id = 20012388;
rowid|id|source|source_id|housenumber|lat|lon|parity|proj_lat|proj_lon
123117441|20012388|OA|de/berlin:0bda00204b2ddc9d|10.0|52.5468603|13.4058849|L|52.5470281270828|13.405838626042
123117442|20012388|OA|de/berlin:680583fb8599aff3|10.03|52.5468775|13.4060738|L|52.5470473315231|13.406026973333
123117443|20012388|OA|de/berlin:e5a1d3437fc3d936|11.0|52.5468984|13.4063029|L|52.5470706239638|13.4062554136339
123117444|20012388|OA|de/berlin:e62db3492191931e|12.0|52.5469252|13.4065954|L|52.5471003654175|13.4065471025441
123117445|20012388|OA|de/berlin:7e7e2a6a0c032fea|13.0|52.5469531|13.4068882|L|52.5471301667027|13.4068393782504
123117446|20012388|OA|de/berlin:68d3c3204fff2cb7|13.03|52.5469712|13.4070986|L|52.5471515280099|13.4070488789849
123117447|20012388|OA|de/berlin:fca1f8a028ee8a86|14.0|52.5470432|13.4078884|L|52.5472233841668|13.407850314934
123117448|20012388|OA|de/berlin:de161640924a8758|15.0|52.5470761|13.4082487|L|52.547251623353|13.4082116000227
123117449|20012388|OA|de/berlin:796a91b8a99d8615|16.0|52.5470987|13.4084969|L|52.5472710754548|13.4084604653493
123117450|20012388|OA|de/berlin:7ebe440509a64eba|17.0|52.5471151|13.4086763|L|52.5472851365658|13.4086403596887
123117451|20012388|OA|de/berlin:8a066b1c37e40eb4|18.0|52.5471384|13.408932|L|52.5473051767406|13.4088967486745
123117452|20012388|OA|de/berlin:2e7e869c9ea9d604|19.0|52.5471699|13.4092775|L|52.5473322551603|13.4092431832073
123117453|20012388|OA|de/berlin:5d42dcce4597d883|20.03|52.547238|13.4100145|L|52.5473961147333|13.4099783149099
123117454|20012388|OA|de/berlin:15173731ebf23605|20.06|52.5472595|13.4102506|L|52.547416124423|13.4102147559374
123117455|20012388|OA|de/berlin:a90eed0d6ac49c80|21.0|52.5472847|13.410528|L|52.5474396331682|13.4104925429464
123117456|20012388|OA|de/berlin:1f1a870f2ab282b9|22.0|52.5473099|13.4108036|L|52.547462992476|13.4107685641557
123117457|20012388|OA|de/berlin:8954f81f720ea09b|23.0|52.5473305|13.41103|L|52.547482179765|13.4109952874278
123117458|20012388|OA|de/berlin:5420f910277ccb3d|24.0|52.5473526|13.4112723|L|52.5475027155834|13.411237945363
123117459|20012388|OA|de/berlin:0817a7b4f06605f1|25.0|52.5473712|13.411477|L|52.5475200633231|13.4114429319196
123117460|20012388|OA|de/berlin:8ae7c91c3ea8364c|26.0|52.5474003|13.4117959|L|52.5475470915281|13.4117623060152
123117461|20012388|OA|de/berlin:a2e5312204333ab8|27.0|52.5474133|13.4119383|L|52.5475591606774|13.4119049190253
123117462|20012388|OA|de/berlin:1e9dbbdf67d44ae6|28.0|52.5474404|13.4122356|L|52.5475843576352|13.4122026545057
123117463|20012388|OA|de/berlin:b23c8a12edc048f0|29.0|52.5474825|13.4126975|L|52.5476235048024|13.4126652302158
123117464|20012388|OA|de/berlin:7526204dc4742a1a|30.0|52.5477687|13.4125195|L|52.5476141792412|13.4125548532755
123117465|20012388|OA|de/berlin:5371b90c813a6e3c|31.0|52.5477325|13.4121217|L|52.5475804753228|13.412156482132
123117466|20012388|OA|de/berlin:f6faf01adb0c845c|35.0|52.5476614|13.4113397|L|52.5475142209421|13.4113733733807
123117467|20012388|OA|de/berlin:b5e182ae49664ca5|36.0|52.5476269|13.410969|L|52.5474827985451|13.4110019691982
123117468|20012388|OA|de/berlin:fdd662b10f4394b6|37.0|52.5476119|13.4108104|L|52.5474693502624|13.4108430141561
123117469|20012388|OA|de/berlin:0b5f18d9ae1df159|38.0|52.5475791|13.4104606|L|52.5474396948004|13.4104924946651
123117470|20012388|OA|de/berlin:41f67cb896679b4d|39.0|52.547552|13.4101594|L|52.5474141812682|13.4101909316565
123117471|20012388|OA|de/berlin:737f96db51c5dbe2|40.0|52.5474778|13.4093685|L|52.5473443313989|13.4093967252638
123117472|20012388|OA|de/berlin:1d950c35905643d5|41.0|52.5474517|13.4090839|L|52.5473220127523|13.4091113255697
123117473|20012388|OA|de/berlin:da7d0a9cafd6b07d|42.0|52.5474276|13.4088209|L|52.5473013883126|13.4088475905474
123117474|20012388|OA|de/berlin:f1079ab047a4a35a|43.0|52.5474072|13.4085993|L|52.5472840089336|13.408625351739
123117475|20012388|OA|de/berlin:ca41d77ee6b0cfa2|44.0|52.5473774|13.4082746|L|52.5472585452347|13.4082997346888
123117476|20012388|OA|de/berlin:50dd83d8210456db|45.03|52.5473408|13.4078766|L|52.5472273320029|13.4079005954875
123117477|20012388|OA|de/berlin:bd7d0d71d00d73be|45.0|52.5473606|13.4080924|L|52.5472442554314|13.4081170038287
123117478|20012388|OA|de/berlin:16fc769a643627fb|46.0|52.5473606|13.4064217|R|52.547095044895|13.4064949215904
123117479|20012388|OA|de/berlin:a773fd9b543eb1ec|47.0|52.5475746|13.4063732|R|52.5470960869803|13.4065051418281
123117480|20012388|OA|de/berlin:0783bfed836e6e04|49.0|52.5472033|13.4062532|R|52.5470740324905|13.4062888427145
123117481|20012388|OA|de/berlin:80809d2cef8fce1c|50.0|52.5470683|13.4048499|R|52.5469318816115|13.4048847466934
123117482|20012388|OA|de/berlin:3e93ea2aa7f198cc|51.0|52.5470392|13.4045536|R|52.5469038666526|13.4045881694848
123117483|20012388|OA|de/berlin:9391eb5616341a25|52.0|52.5470079|13.4042162|R|52.5468720089862|13.4042509118853
123117484|20012388|OA|de/berlin:4607555f7b35f74b|53.0|52.546988|13.4040011|R|52.5468517002985|13.4040359162486
123117485|20012388|OA|de/berlin:fbabe666b2fd6318|54.0|52.5469595|13.4036934|R|52.5468226479927|13.4037283572836
123117486|20012388|OA|de/berlin:b3f442c2315dd226|55.0|52.5469374|13.4034554|R|52.5468001752812|13.4034904524532
123117487|20012388|OA|de/berlin:8a9c64e8dd14c1cd|56.0|52.5469076|13.4031338|R|52.5467698102747|13.4031689967297
123117488|20012388|OA|de/berlin:e6747f4e8a51c3f8|57.0|52.5468876|13.4029178|R|52.5467494162189|13.4029530973544
123117489|20012388|OA|de/berlin:f89d04e672cdd6db|58.0|52.5468578|13.4025969|L|52.546718923323|13.4026327523834
123117490|20012388|OA|de/berlin:de9bbc7be7562ff4|59.0|52.546839|13.4023939|L|52.5466995573274|13.4024298984699
123117491|20012388|OA|de/berlin:84c29efc207d7ee2|60.0|52.5468077|13.4020562|L|52.5466673404784|13.4020924351116
123117492|20012388|OA|de/berlin:d221920e03fd0d9c|61.0|52.5467835|13.4017948|L|52.5466424033853|13.4018312253589
166387367|20012388|OSM|node:733569766|48.0|52.5471756|13.4063|R|52.5470779163997|13.406326934102
174587465|20012388|OSM|node:4314333203|32.0|52.5477143|13.4120467|L|52.5475739048852|13.4120788213468
373093837|20012388|VERTEX||19.814||||52.547363|13.409618
373093838|20012388|VERTEX||19.52||||52.547351|13.409483
373093839|20012388|VERTEX||13.548||||52.547004|13.405602
373093840|20012388|VERTEX||15.403||||52.546989|13.405479
373093841|20012388|VERTEX||24.28||||52.546932|13.404886
373093842|20012388|VERTEX||54.539||||52.546741|13.402864
373093843|20012388|VERTEX||60.993||||52.546642|13.401828
373093844|20012388|VERTEX||60.174||||52.546604|13.401444
373093845|20012388|VERTEX||59.79||||52.546604|13.401262
373093846|20012388|VERTEX||59.488||||52.546596|13.401119
373093847|20012388|VERTEX||59.185||||52.546604|13.401262
373093848|20012388|VERTEX||58.802||||52.546604|13.401444
373093849|20012388|VERTEX||57.984||||52.546642|13.401827
373093850|20012388|VERTEX||55.773||||52.546741|13.402864
373093851|20012388|VERTEX||51.463||||52.546932|13.404886
373093852|20012388|VERTEX||50.198||||52.546989|13.405479
373093853|20012388|VERTEX||49.934||||52.547004|13.405602
373093854|20012388|VERTEX||46.017||||52.547191|13.407436