Jag skrev ett program som läser kml-filen i kmz-filen, en csv-fil i Garmin-format från vår databas samt några andra filter-filer som presenterar skillnader mellan vår databas och NVDB.
./fartkameramatch ~/fartkamera/doc.kml /tmp/fartkameror.csv ~/fartkamera/hastighetsfilter.txt ~/fartkamera/ej_verifierat_bortagna,_saknas_i_nvdb,_kvar_i_streetview.txt ~/fartkamera/danska_kameror.txt ~/fartkamera/plats_flyttbar_kamera.txt
Applying extra position filter:
===============================
Ignoring that K53S01 is missing in NVDB
Ignoring that KE20E57 is missing in NVDB
Ignoring that KE20W58 is missing in NVDB
Ignoring that K151S03 is missing in NVDB
Ignoring that K218N03 is missing in NVDB
Ignoring that K218S02 is missing in NVDB
Ignoring that K27S27 is missing in NVDB
Ignoring that K33E03 is missing in NVDB
Ignoring that K33W02 is missing in NVDB
Ignoring that K47S16 is missing in NVDB
Ignoring that K562S01 is missing in NVDB
Ignoring that K576S01 is missing in NVDB
Ignoring that K646N01 is missing in NVDB
Ignoring that K678E03 is missing in NVDB
Ignoring that K678S04 is missing in NVDB
Ignoring that KAB669N01 is missing in NVDB
Ignoring that KE20N25 is missing in NVDB
Ignoring that K108S02 is missing in NVDB
Ignoring that K108N05 is missing in NVDB
Ignoring that K49W09 is missing in NVDB
Ignoring that K226W16 is missing in NVDB
Ignoring that K226W06 is missing in NVDB
Ignoring that K226E15 is missing in NVDB
Ignoring that K226E05 is missing in NVDB
Ignoring that K49W10 is missing in NVDB
Ignoring that K56N02 is missing in NVDB
Ignoring that K56S01 is missing in NVDB
Applying speed exception filter:
================================
Allowing K195S09 speed 70 in NVDB even though fartkamera says 60
Allowing K271S03 speed 60 in NVDB even though fartkamera says 50
Allowing K55E21 speed 80 in NVDB even though fartkamera says 70
Allowing K55W33 speed 80 in NVDB even though fartkamera says 70
Allowing K56N04 speed 80 in NVDB even though fartkamera says 70
Allowing K56S03 speed 80 in NVDB even though fartkamera says 70
Allowing K136N03 speed 90 in NVDB even though fartkamera says 80
Allowing K136N05 speed 90 in NVDB even though fartkamera says 80
Allowing K136W04 speed 90 in NVDB even though fartkamera says 80
Allowing KE4N10 speed 80 in NVDB even though fartkamera says 70
Allowing K50W16 speed 80 in NVDB even though fartkamera says 60
Allowing K31S19 speed 90 in NVDB even though fartkamera says 70
Allowing K140N04 speed 80 in NVDB even though fartkamera says 60
Allowing K140W05 speed 80 in NVDB even though fartkamera says 60
Unique, possible new positions from NVDB:
=========================================
Unique, possible new fundaments from fartkameraforum:
=====================================================
Mismatching speed (too high):
=============================
Mismatching speed (too low):
============================
Mismatching direction:
======================
Biggest position mismatch:
==========================
KE20W28 is about 139 meters from NVDB position.
KE20W28: http://maps.google.com/maps?q=58.640598,13.700100&z=15
NVDB:
58.641109
13.701440
KE20W57
70
Lugnås
58.641109,13.701440
http://maps.google.com/maps?q=58.641109,13.701440&z=15
kml-filen är från slutet av februari om jag minns rätt (tidsstämpeln säger 1979, men det var nog bara zip-formatet i kmz som luras lite).
Det som jag hade tänkt att se var vilka 3 positioner som fått ny hastighet, vilka 3 kameror som tagits bort, om möjligen KE20W28 (Lugnås) är en av de tre positionerna vars läge justerats i NVDB samt om riktningsändringen påverkar hur vi borde döpa kameran.
m v h Henrik