Manually remove spawn points and related spawn data for spawns that have an excessive missed count. A high missed count can indicate that the spawn point may have been removed or may have been previously mis-identified.

remove-missed-spawns.sql

use rocketmap;

SET foreign_key_checks = 0;

DELETE FROM scanspawnpoint where spawnpoint_id in (
	SELECT id FROM spawnpoint where missed_count > 9
);

DELETE FROM spawnpointdetectiondata where spawnpoint_id in (
	SELECT id FROM spawnpoint where missed_count > 9
);

DELETE FROM spawnpoint where missed_count > 9;

SET foreign_key_checks = 1;

DELETE from pokemon where spawnpoint_id not in (
	select id from spawnpoint
);