Det visade sig att mitt program hade en bugg då den sökte efter kameran vars position skiljde sig mest från positionen i NVDB, den buggen är nu fixad.
Dessutom visade det sig att många kameror i vår databas pekades ut som överflödiga för att det finns kamerapar med en kamera på varje sida av vägen. I vår databas är koordinaterna oftast kamerans position bredvid vägen, i NVDBs databas är i stället ofta positionen mitt i vägen. Då hamnar de två kamerorna på varje sida om vägen nästan mitt på varandra i NVDBs databas. Det ledde till en fel-matchning som antydde att en av två kameror blev överflödig. Det är nu åtgärdat genom att vikta in kamerariktning och inte bara koordinater vid matchning mellan vår och NVDBs databaser.
Efter lite städning och tillagda kameror ser det nu ut såhär:
Unique, possible new positions from NVDB:
=========================================
55.928780
13.968260
KW
60
55.928780,13.968260
http://maps.google.com/maps?q=55.928780,13.968260&z=15
56.090290
13.738100
KS
80
56.090290,13.738100
http://maps.google.com/maps?q=56.090290,13.738100&z=15
57.116692
16.100460
KS
70
57.116692,16.100460
http://maps.google.com/maps?q=57.116692,16.100460&z=15
58.014050
11.680790
KN
80
58.014050,11.680790
http://maps.google.com/maps?q=58.014050,11.680790&z=15
58.014679
11.681360
KS
80
58.014679,11.681360
http://maps.google.com/maps?q=58.014679,11.681360&z=15
58.484879
11.351100
KE
70
58.484879,11.351100
http://maps.google.com/maps?q=58.484879,11.351100&z=15
58.765560
15.518940
KS
80
58.765560,15.518940
http://maps.google.com/maps?q=58.765560,15.518940&z=15
58.767738
12.228830
KE
80
58.767738,12.228830
http://maps.google.com/maps?q=58.767738,12.228830&z=15
58.777100
15.511240
KN
80
58.777100,15.511240
http://maps.google.com/maps?q=58.777100,15.511240&z=15
58.786140
15.498310
KS
80
58.786140,15.498310
http://maps.google.com/maps?q=58.786140,15.498310&z=15
59.126709
14.176000
KN
80
59.126709,14.176000
http://maps.google.com/maps?q=59.126709,14.176000&z=15
Unique, possible new fundaments from fartkameraforum:
=====================================================
KE22S41 is 82 meters from closest NVDB which prefers KE22N42
http://maps.google.com/maps?q=55.928841,13.968240&z=15
http://maps.google.com/maps?q=55.928669,13.969150&z=15
KE20W58 is 27157 meters from closest NVDB which prefers K100W03
http://maps.google.com/maps?q=55.609962,12.729553&z=15
http://maps.google.com/maps?q=55.405117,12.890667&z=15
KE20N25 is 3882 meters from closest NVDB which prefers KE20S20
http://maps.google.com/maps?q=58.665981,13.780550&z=15
http://maps.google.com/maps?q=58.653339,13.742421&z=15
KE20E57 is 27154 meters from closest NVDB which prefers K100W03
http://maps.google.com/maps?q=55.609875,12.729449&z=15
http://maps.google.com/maps?q=55.405117,12.890667&z=15
KAB669N01 is 1816 meters from closest NVDB which prefers K669W02
http://maps.google.com/maps?q=59.328644,18.550266&z=15
http://maps.google.com/maps?q=59.334187,18.568157&z=15
K70S40 is 5152 meters from closest NVDB which prefers K70N39
http://maps.google.com/maps?q=59.868633,16.628487&z=15
http://maps.google.com/maps?q=59.842972,16.673330&z=15
K678S04 is 3101 meters from closest NVDB which prefers K678W02
http://maps.google.com/maps?q=58.309956,11.928021&z=15
http://maps.google.com/maps?q=58.298882,11.897926&z=15
K678E03 is 2509 meters from closest NVDB which prefers K678W02
http://maps.google.com/maps?q=58.307716,11.922341&z=15
http://maps.google.com/maps?q=58.298882,11.897926&z=15
K646N01 is 1881 meters from closest NVDB which prefers K646E02
http://maps.google.com/maps?q=59.298420,18.390779&z=15
http://maps.google.com/maps?q=59.288521,18.406750&z=15
K576S01 is 19081 meters from closest NVDB which prefers K816N05
http://maps.google.com/maps?q=59.191742,17.523975&z=15
http://maps.google.com/maps?q=59.330883,17.640934&z=15
K56S07 is 8175 meters from closest NVDB which prefers K56N04
http://maps.google.com/maps?q=59.166267,16.112125&z=15
http://maps.google.com/maps?q=59.239155,16.100807&z=15
K56S01 is 9640 meters from closest NVDB which prefers K56N04
http://maps.google.com/maps?q=59.152679,16.108330&z=15
http://maps.google.com/maps?q=59.239155,16.100807&z=15
K56N02 is 9889 meters from closest NVDB which prefers K56N04
http://maps.google.com/maps?q=59.150780,16.112585&z=15
http://maps.google.com/maps?q=59.239155,16.100807&z=15
K562S01 is 5127 meters from closest NVDB which prefers KE4S115
http://maps.google.com/maps?q=62.294651,17.378683&z=15
http://maps.google.com/maps?q=62.248821,17.371960&z=15
K53S01 is 14441 meters from closest NVDB which prefers K55N21
http://maps.google.com/maps?q=59.075020,16.815571&z=15
http://maps.google.com/maps?q=59.204720,16.822439&z=15
K49W10 is 3277 meters from closest NVDB which prefers K49W13
http://maps.google.com/maps?q=58.389820,13.650900&z=15
http://maps.google.com/maps?q=58.380486,13.684230&z=15
K49W09 is 5170 meters from closest NVDB which prefers K194W05
http://maps.google.com/maps?q=58.395477,13.882188&z=15
http://maps.google.com/maps?q=58.388966,13.936327&z=15
K47S16 is 713 meters from closest NVDB which prefers K32N07
http://maps.google.com/maps?q=57.513988,14.987060&z=15
http://maps.google.com/maps?q=57.520321,14.988514&z=15
K33W02 is 3498 meters from closest NVDB which prefers K31W11
http://maps.google.com/maps?q=57.640808,14.836834&z=15
http://maps.google.com/maps?q=57.612877,14.819853&z=15
K33E03 is 2761 meters from closest NVDB which prefers K47S20
http://maps.google.com/maps?q=57.637501,14.826510&z=15
http://maps.google.com/maps?q=57.619495,14.806244&z=15
K27S27 is 24677 meters from closest NVDB which prefers K29S03
http://maps.google.com/maps?q=56.346668,15.153400&z=15
http://maps.google.com/maps?q=56.326736,14.887679&z=15
K226W16 is 1810 meters from closest NVDB which prefers K226W04
http://maps.google.com/maps?q=59.253960,18.012320&z=15
http://maps.google.com/maps?q=59.244720,17.996670&z=15
K226W06 is 1801 meters from closest NVDB which prefers K226W04
http://maps.google.com/maps?q=59.254002,18.012171&z=15
http://maps.google.com/maps?q=59.244720,17.996670&z=15
K226E15 is 1822 meters from closest NVDB which prefers K226W04
http://maps.google.com/maps?q=59.254005,18.012430&z=15
http://maps.google.com/maps?q=59.244720,17.996670&z=15
K226E05 is 1833 meters from closest NVDB which prefers K226W04
http://maps.google.com/maps?q=59.253971,18.012600&z=15
http://maps.google.com/maps?q=59.244720,17.996670&z=15
K218S02 is 1881 meters from closest NVDB which prefers K218N01
http://maps.google.com/maps?q=58.928627,17.535406&z=15
http://maps.google.com/maps?q=58.939312,17.520164&z=15
K218N03 is 2262 meters from closest NVDB which prefers K218N01
http://maps.google.com/maps?q=58.925240,17.537251&z=15
http://maps.google.com/maps?q=58.939312,17.520164&z=15
K151S03 is 461 meters from closest NVDB which prefers K151S06
http://maps.google.com/maps?q=57.273418,13.969830&z=15
http://maps.google.com/maps?q=57.269306,13.970468&z=15
K151N01 is 121 meters from closest NVDB which prefers K151N08
http://maps.google.com/maps?q=57.232155,14.005985&z=15
http://maps.google.com/maps?q=57.231075,14.006304&z=15
K108S02 is 5915 meters from closest NVDB which prefers K108N04
http://maps.google.com/maps?q=55.666431,13.202360&z=15
http://maps.google.com/maps?q=55.627350,13.246300&z=15
K108N05 is 5476 meters from closest NVDB which prefers K108N04
http://maps.google.com/maps?q=55.664108,13.206380&z=15
http://maps.google.com/maps?q=55.627350,13.246300&z=15
Mismatching speed (too high):
=============================
Mismatching speed (too low):
============================
KE4N90@70 has speed 80 in NVDB 63.637970,19.908260 distance 12 m http://maps.google.com/maps?q=63.637966,19.908388&z=15
KE4N10@70 has speed 80 in NVDB 64.539818,21.255630 distance 13 m http://maps.google.com/maps?q=64.539803,21.255760&z=15
KE45W83@60 has speed 70 in NVDB 62.037689,14.408440 distance 9 m http://maps.google.com/maps?q=62.037762,14.408491&z=15
KE45S96@80 has speed 90 in NVDB 63.377979,14.884940 distance 1 m http://maps.google.com/maps?q=63.377972,14.884925&z=15
KE45S94@80 has speed 90 in NVDB 62.881458,14.522420 distance 0 m http://maps.google.com/maps?q=62.881462,14.522411&z=15
KE45S93@60 has speed 70 in NVDB 62.916012,14.528360 distance 0 m http://maps.google.com/maps?q=62.916008,14.528359&z=15
KE45S92@60 has speed 70 in NVDB 62.752571,14.429190 distance 1 m http://maps.google.com/maps?q=62.752567,14.429178&z=15
KE45S90@80 has speed 90 in NVDB 62.736092,14.416740 distance 4 m http://maps.google.com/maps?q=62.736069,14.416704&z=15
KE45S88@80 has speed 90 in NVDB 62.694820,14.405240 distance 2 m http://maps.google.com/maps?q=62.694817,14.405219&z=15
KE45S85@80 has speed 90 in NVDB 63.331612,14.857260 distance 2 m http://maps.google.com/maps?q=63.331600,14.857242&z=15
KE45S80@50 has speed 70 in NVDB 62.650791,14.373490 distance 14 m http://maps.google.com/maps?q=62.650799,14.373342&z=15
KE45S13@60 has speed 70 in NVDB 62.048801,14.647810 distance 10 m http://maps.google.com/maps?q=62.048759,14.647718&z=15
KE45N97@60 has speed 70 in NVDB 62.908989,14.523050 distance 1 m http://maps.google.com/maps?q=62.908985,14.523037&z=15
KE45N91@60 has speed 70 in NVDB 62.749161,14.426330 distance 0 m http://maps.google.com/maps?q=62.749157,14.426323&z=15
KE45N89@80 has speed 90 in NVDB 62.731541,14.414670 distance 0 m http://maps.google.com/maps?q=62.731533,14.414667&z=15
KE45N87@80 has speed 90 in NVDB 62.687080,14.393960 distance 1 m http://maps.google.com/maps?q=62.687077,14.393946&z=15
KE45N86@80 has speed 90 in NVDB 63.338951,14.859470 distance 1 m http://maps.google.com/maps?q=63.338947,14.859456&z=15
KE45N25@60 has speed 70 in NVDB 62.047150,14.651040 distance 11 m http://maps.google.com/maps?q=62.047195,14.651140&z=15
KE45N104@80 has speed 90 in NVDB 63.370739,14.873880 distance 16 m http://maps.google.com/maps?q=63.370659,14.874023&z=15
KE45N101@80 has speed 90 in NVDB 62.863411,14.518700 distance 20 m http://maps.google.com/maps?q=62.863400,14.518911&z=15
KE45E82@60 has speed 70 in NVDB 62.038101,14.405690 distance 6 m http://maps.google.com/maps?q=62.038048,14.405656&z=15
KE20N23@70 has speed 80 in NVDB 58.882938,14.289250 distance 3 m http://maps.google.com/maps?q=58.882912,14.289272&z=15
K850S01@50 has speed 60 in NVDB 59.508480,17.867701 distance 6 m http://maps.google.com/maps?q=59.508522,17.867659&z=15
K850N02@50 has speed 60 in NVDB 59.508049,17.866039 distance 3 m http://maps.google.com/maps?q=59.508026,17.866062&z=15
K71S08@40 has speed 50 in NVDB 60.938271,13.359760 distance 6 m http://maps.google.com/maps?q=60.938263,13.359694&z=15
K71S05@80 has speed 90 in NVDB 61.028790,13.338900 distance 10 m http://maps.google.com/maps?q=61.028881,13.338890&z=15
K68S04@50 has speed 60 in NVDB 60.304871,16.412291 distance 14 m http://maps.google.com/maps?q=60.304852,16.412138&z=15
K66S24@60 has speed 70 in NVDB 61.069801,13.330080 distance 2 m http://maps.google.com/maps?q=61.069786,13.330062&z=15
K66E03@80 has speed 90 in NVDB 60.112679,15.484050 distance 13 m http://maps.google.com/maps?q=60.112610,15.483930&z=15
K63S04@70 has speed 80 in NVDB 59.499599,13.614110 distance 13 m http://maps.google.com/maps?q=59.499619,13.613974&z=15
K63N03@70 has speed 80 in NVDB 59.477139,13.586100 distance 7 m http://maps.google.com/maps?q=59.477093,13.586158&z=15
K56S21@70 has speed 80 in NVDB 59.558842,16.341980 distance 6 m http://maps.google.com/maps?q=59.558872,16.341919&z=15
K56S03@70 has speed 80 in NVDB 59.251549,16.108730 distance 6 m http://maps.google.com/maps?q=59.251537,16.108660&z=15
K56N04@70 has speed 80 in NVDB 59.239140,16.100620 distance 17 m http://maps.google.com/maps?q=59.239155,16.100807&z=15
K55S33@70 has speed 80 in NVDB 59.204739,16.823750 distance 26 m http://maps.google.com/maps?q=59.204769,16.824020&z=15
K55N21@70 has speed 80 in NVDB 59.204781,16.822451 distance 6 m http://maps.google.com/maps?q=59.204720,16.822439&z=15
K50W54@70 has speed 80 in NVDB 61.344681,16.347980 distance 17 m http://maps.google.com/maps?q=61.344669,16.347799&z=15
K50S16@60 has speed 80 in NVDB 58.464642,14.934580 distance 13 m http://maps.google.com/maps?q=58.464710,14.934460&z=15
K50N15@70 has speed 80 in NVDB 58.475552,14.951830 distance 6 m http://maps.google.com/maps?q=58.475498,14.951800&z=15
K50E65@70 has speed 80 in NVDB 61.344501,16.343800 distance 1 m http://maps.google.com/maps?q=61.344494,16.343794&z=15
K44W07@60 has speed 80 in NVDB 58.504631,13.311790 distance 36 m http://maps.google.com/maps?q=58.504860,13.312060&z=15
K44E06@70 has speed 80 in NVDB 58.535061,13.485500 distance 7 m http://maps.google.com/maps?q=58.535000,13.485530&z=15
K32N07@70 has speed 90 in NVDB 57.520329,14.988260 distance 23 m http://maps.google.com/maps?q=57.520321,14.988514&z=15
K31S19@70 has speed 90 in NVDB 57.236599,15.145050 distance 9 m http://maps.google.com/maps?q=57.236565,15.144959&z=15
K28S04@80 has speed 90 in NVDB 56.672901,15.543430 distance 8 m http://maps.google.com/maps?q=56.672867,15.543346&z=15
K271S03@50 has speed 60 in NVDB 59.253281,18.048780 distance 12 m http://maps.google.com/maps?q=59.253258,18.048653&z=15
K26N53@70 has speed 80 in NVDB 58.193531,13.892790 distance 35 m http://maps.google.com/maps?q=58.193840,13.892700&z=15
K260N04@50 has speed 70 in NVDB 59.218182,18.203951 distance 15 m http://maps.google.com/maps?q=59.218201,18.204107&z=15
K25S05@50 has speed 60 in NVDB 56.763168,15.264930 distance 6 m http://maps.google.com/maps?q=56.763161,15.264864&z=15
K24W10@70 has speed 80 in NVDB 56.287682,13.317940 distance 18 m http://maps.google.com/maps?q=56.287777,13.317777&z=15
K249W06@70 has speed 80 in NVDB 59.466961,15.521610 distance 1 m http://maps.google.com/maps?q=59.466961,15.521600&z=15
K249E03@70 has speed 80 in NVDB 59.461658,15.490780 distance 0 m http://maps.google.com/maps?q=59.461658,15.490783&z=15
K23N33@70 has speed 80 in NVDB 57.161480,15.353030 distance 12 m http://maps.google.com/maps?q=57.161385,15.353099&z=15
K195S09@60 has speed 70 in NVDB 58.002571,14.123950 distance 1 m http://maps.google.com/maps?q=58.002571,14.123936&z=15
K171E01@70 has speed 80 in NVDB 58.431561,11.409260 distance 4 m http://maps.google.com/maps?q=58.431534,11.409299&z=15
K140W05@60 has speed 80 in NVDB 57.486320,18.135120 distance 7 m http://maps.google.com/maps?q=57.486382,18.135157&z=15
K140N04@60 has speed 80 in NVDB 57.479912,18.126150 distance 11 m http://maps.google.com/maps?q=57.479897,18.126274&z=15
K136S07@70 has speed 80 in NVDB 56.753391,16.552540 distance 22 m http://maps.google.com/maps?q=56.753380,16.552299&z=15
K136S04@80 has speed 90 in NVDB 56.832809,16.617060 distance 13 m http://maps.google.com/maps?q=56.832809,16.617201&z=15
K136N05@80 has speed 90 in NVDB 56.801849,16.590160 distance 12 m http://maps.google.com/maps?q=56.801769,16.590250&z=15
K136N03@80 has speed 90 in NVDB 56.860760,16.651260 distance 18 m http://maps.google.com/maps?q=56.860771,16.651461&z=15
K120W06@40 has speed 70 in NVDB 56.530251,14.827960 distance 6 m http://maps.google.com/maps?q=56.530304,14.827933&z=15
K1003S02@30 has speed 50 in NVDB 59.425961,18.330641 distance 5 m http://maps.google.com/maps?q=59.425968,18.330589&z=15
K1003N01@30 has speed 50 in NVDB 59.424438,18.328770 distance 4 m http://maps.google.com/maps?q=59.424397,18.328760&z=15
Mismatching direction:
======================
KE4N57 differs in direction N, NVDB at distance 77 m says E http://maps.google.com/maps?q=65.839073,23.190607&z=15
KE22S35 differs in direction S, NVDB at distance 8 m says W http://maps.google.com/maps?q=56.199699,15.375910&z=15
KE22N36 differs in direction N, NVDB at distance 1 m says E http://maps.google.com/maps?q=56.199692,15.374710&z=15
KE20N40 differs in direction N, NVDB at distance 48 m says E http://maps.google.com/maps?q=59.417950,16.064301&z=15
K83S08 differs in direction S, NVDB at distance 38 m says E http://maps.google.com/maps?q=61.165611,16.840389&z=15
K83S06 differs in direction S, NVDB at distance 8 m says E http://maps.google.com/maps?q=61.211300,16.626270&z=15
K77E24 differs in direction E, NVDB at distance 5 m says W http://maps.google.com/maps?q=59.734428,18.440609&z=15
K71S07 differs in direction S, NVDB at distance 5 m says N http://maps.google.com/maps?q=60.494831,14.138510&z=15
K55S33 differs in direction S, NVDB at distance 26 m says W http://maps.google.com/maps?q=59.204769,16.824020&z=15
K55S07 differs in direction S, NVDB at distance 8 m says W http://maps.google.com/maps?q=59.660854,17.243784&z=15
K55N10 differs in direction N, NVDB at distance 7 m says E http://maps.google.com/maps?q=59.655338,17.190607&z=15
K46S10 differs in direction S, NVDB at distance 7 m says N http://maps.google.com/maps?q=58.140369,13.563329&z=15
K46N09 differs in direction N, NVDB at distance 11 m says S http://maps.google.com/maps?q=58.138401,13.563238&z=15
K204S05 differs in direction S, NVDB at distance 5 m says N http://maps.google.com/maps?q=59.215504,14.891159&z=15
K160N06 differs in direction N, NVDB at distance 8 m says W http://maps.google.com/maps?q=58.063648,11.726723&z=15
K147S07 differs in direction S, NVDB at distance 10 m says E http://maps.google.com/maps?q=57.632549,18.445116&z=15
K136S01 differs in direction S, NVDB at distance 12 m says W http://maps.google.com/maps?q=56.879028,16.691360&z=15
K113S03 differs in direction S, NVDB at distance 6 m says E http://maps.google.com/maps?q=55.906490,13.343438&z=15
K113S02 differs in direction S, NVDB at distance 4 m says N http://maps.google.com/maps?q=55.868683,13.308345&z=15
K113N04 differs in direction N, NVDB at distance 14 m says W http://maps.google.com/maps?q=55.907249,13.345442&z=15
K113N01 differs in direction N, NVDB at distance 5 m says S http://maps.google.com/maps?q=55.865978,13.306043&z=15
Biggest position mismatch:
==========================
K52E38 is about 149 meters from NVDB position.
K52E38: http://maps.google.com/maps?q=58.967834,16.344912&z=15
NVDB:
58.967812
16.343340
KE
80
58.967812,16.343340
http://maps.google.com/maps?q=58.967812,16.343340&z=15
Mycket jobb återstår med att uppdatera vår databas. Dessutom har jag insett att vi inte bara har svenska kameror i vår databas, vi har också ett par danska kameror. Dem vill vi inte ta bort bara för att de saknas i NVDB.
m v h Henrik