--- dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2015/07/23 09:37:09 2639 +++ dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2015/07/28 08:08:22 2640 @@ -102,6 +102,8 @@ "LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + "WHERE rute IS NULL " + //Ingen dækning "AND a.postnr BETWEEN ? AND ? " + + "AND a.postnr NOT BETWEEN 3900 and 3999 " + //Skip greenland + "AND a.postnr NOT BETWEEN 9000 AND 9499 " + // Skip nordjylland (DAO) "AND latitude IS NOT NULL " + "AND longitude IS NOT NULL " + "AND gadeid IS NOT NULL " +