--- dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java	2014/10/08 08:44:56	2231
+++ dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java	2014/12/09 15:49:43	2237
@@ -92,7 +92,8 @@
 				"AND a.postnr=?  " +
 				"AND latitude IS NOT NULL " +
 				"AND longitude IS NOT NULL " +
-				"AND gadeid IS NOT NULL ";
+				"AND gadeid IS NOT NULL " +
+				"AND (a.distributor IS NULL OR a.distributor<>'LUKKET') ";		
 		PreparedStatement stmt = conn.prepareStatement(sql);
 		stmt.setInt(1, postnr);
 
@@ -108,8 +109,8 @@
 
 		String sql = "SELECT postnr " + 
 					 "FROM fulddaekning.adressetabel " + 
-					 //"WHERE distributor = ? and rute is not null " +
 					 "WHERE postnr BETWEEN ? AND ? " +
+					 "AND rute is null " + // Træk kun liste på postnumre hvor der er ikke-dækkede adresser
 					 "GROUP BY postnr " + 
 					 "ORDER by postnr";
 		PreparedStatement stmt = conn.prepareStatement(sql);