Hello guys,
there might be a little bit of garbage data in the database. for instance the wifi located at (lat,lon) (0,0) and some other wifi that seem to exists offshore of west africa. see this permalink:
http://owm.vreeken.net/map/?zoom=7&lat=248286.57709&lon=257401.69271...
especially the wifis at (0,0) are causing trouble here at Freifunk Nordwest, see
https://map.ffnw.de/#%21v:m%3Bl:ec086b741582-f4f26d85a1f6
it would help us a lot, if those obviously false entries could be removed from the DB
Kind regards Lorenz
Hello Lorenz, hello Yegor,
The WiFi AP's with position 0,0 are the ones from people that unsubscribed, that are WiFis in Buses/Cars and other APs which should not be part of the database because they can't be used for position recognition. They are still there with location 0,0 in order to store their BSSIDs.
So removing them from the main database would damage the position detection function of OpenWLANMap. Means you have to filter them on client side.
Michael
Gesendet: Mittwoch, 14. Juni 2017 um 22:49 Uhr Von: lrnzo lrnzo@osnabrueck.freifunk.net An: openwifi@lists.ffnw.de Betreff: [Openwifi] Garbage in the DB
Hello guys,
there might be a little bit of garbage data in the database. for instance the wifi located at (lat,lon) (0,0) and some other wifi that seem to exists offshore of west africa. see this permalink:
http://owm.vreeken.net/map/?zoom=7&lat=248286.57709&lon=257401.69271...
especially the wifis at (0,0) are causing trouble here at Freifunk Nordwest, see
https://map.ffnw.de/#%21v:m%3Bl:ec086b741582-f4f26d85a1f6
it would help us a lot, if those obviously false entries could be removed from the DB
Kind regards Lorenz
Openwifi mailing list Openwifi@lists.ffnw.de https://lists.ffnw.de/mailman/listinfo/openwifi
Filtering out the "misleading" bssids would be a good way to prevent misplaced Freifunk APs. But in order to filter them one must know them. So i downloaded the db.tar.bz2 and started to search. I tried
grep -P '\t[0.]*$' db.csv
but did not find anything. after reading through your mail again i understood why :) but I found some other maybe garbage and just wanted to let you know. If you do
grep -P '([^A-F0-9.\t-]|E-|e-)' db.csv
you will find entries like
á·‡4F8D1112D 7.0696091083265e-57 -1.2772267415701E-59
which look unintended to me.
Anyway. how can I find the bssids to be filtered out before they can confuse the autolocator script in the Freifunk Nordwest APs
Am 16.06.2017 um 07:37 schrieb virtual_worlds@gmx.de:
Hello Lorenz, hello Yegor,
The WiFi AP's with position 0,0 are the ones from people that unsubscribed, that are WiFis in Buses/Cars and other APs which should not be part of the database because they can't be used for position recognition. They are still there with location 0,0 in order to store their BSSIDs.
So removing them from the main database would damage the position detection function of OpenWLANMap. Means you have to filter them on client side.
Michael
Gesendet: Mittwoch, 14. Juni 2017 um 22:49 Uhr Von: lrnzo lrnzo@osnabrueck.freifunk.net An: openwifi@lists.ffnw.de Betreff: [Openwifi] Garbage in the DB
Hello guys,
there might be a little bit of garbage data in the database. for instance the wifi located at (lat,lon) (0,0) and some other wifi that seem to exists offshore of west africa. see this permalink:
http://owm.vreeken.net/map/?zoom=7&lat=248286.57709&lon=257401.69271...
especially the wifis at (0,0) are causing trouble here at Freifunk Nordwest, see
https://map.ffnw.de/#%21v:m%3Bl:ec086b741582-f4f26d85a1f6
it would help us a lot, if those obviously false entries could be removed from the DB
Kind regards Lorenz
Openwifi mailing list Openwifi@lists.ffnw.de https://lists.ffnw.de/mailman/listinfo/openwifi
I don't really understand your problem. Assuming your example: as long as you do not have a BSSID named "á·‡4F8D1112D" such a damaged entry will not have any influence on your position detection. And it would be really difficult to see such an BSSID somewhere...
Gesendet: Freitag, 16. Juni 2017 um 23:05 Uhr Von: lrnzo lrnzo@osnabrueck.freifunk.net An: openwifi@lists.ffnw.de Betreff: Re: [Openwifi] Garbage in the DB
Filtering out the "misleading" bssids would be a good way to prevent misplaced Freifunk APs. But in order to filter them one must know them. So i downloaded the db.tar.bz2 and started to search. I tried
grep -P '\t[0.]*$' db.csv
but did not find anything. after reading through your mail again i understood why :) but I found some other maybe garbage and just wanted to let you know. If you do
grep -P '([^A-F0-9.\t-]|E-|e-)' db.csv
you will find entries like
á·‡4F8D1112D 7.0696091083265e-57 -1.2772267415701E-59
which look unintended to me.
Anyway. how can I find the bssids to be filtered out before they can confuse the autolocator script in the Freifunk Nordwest APs
Am 16.06.2017 um 07:37 schrieb virtual_worlds@gmx.de:
Hello Lorenz, hello Yegor,
The WiFi AP's with position 0,0 are the ones from people that unsubscribed, that are WiFis in Buses/Cars and other APs which should not be part of the database because they can't be used for position recognition. They are still there with location 0,0 in order to store their BSSIDs.
So removing them from the main database would damage the position detection function of OpenWLANMap. Means you have to filter them on client side.
Michael
Gesendet: Mittwoch, 14. Juni 2017 um 22:49 Uhr Von: lrnzo lrnzo@osnabrueck.freifunk.net An: openwifi@lists.ffnw.de Betreff: [Openwifi] Garbage in the DB
Hello guys,
there might be a little bit of garbage data in the database. for instance the wifi located at (lat,lon) (0,0) and some other wifi that seem to exists offshore of west africa. see this permalink:
http://owm.vreeken.net/map/?zoom=7&lat=248286.57709&lon=257401.69271...
especially the wifis at (0,0) are causing trouble here at Freifunk Nordwest, see
https://map.ffnw.de/#%21v:m%3Bl:ec086b741582-f4f26d85a1f6
it would help us a lot, if those obviously false entries could be removed from the DB
Kind regards Lorenz
Openwifi mailing list Openwifi@lists.ffnw.de https://lists.ffnw.de/mailman/listinfo/openwifi
Openwifi mailing list Openwifi@lists.ffnw.de https://lists.ffnw.de/mailman/listinfo/openwifi
-
lrnzo -
virtual_worlds＠gmx.de