/[projects]/dao/FuldDaekningWorker/src/main/java/dk/daoas/fulddaekning/Database.java
ViewVC logotype

Diff of /dao/FuldDaekningWorker/src/main/java/dk/daoas/fulddaekning/Database.java

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 2642 by torben, Fri Aug 14 10:54:51 2015 UTC revision 2643 by torben, Fri Aug 14 10:56:32 2015 UTC
# Line 103  public class Database { Line 103  public class Database {
103                                  "WHERE rute IS NULL " +  //Ingen dækning                                  "WHERE rute IS NULL " +  //Ingen dækning
104                                  "AND a.postnr BETWEEN ? AND ? " +                                  "AND a.postnr BETWEEN ? AND ? " +
105                                  "AND a.postnr NOT BETWEEN 3900 and 3999 " + //Skip greenland                                  "AND a.postnr NOT BETWEEN 3900 and 3999 " + //Skip greenland
106                                  "AND a.postnr NOT BETWEEN 9000 AND 9499 " + // Skip nordjylland (DAO)                                  "AND a.postnr NOT BETWEEN 9000 AND 9549 " + // Skip nordjylland (DAO)
107                                  "AND latitude IS NOT NULL " +                                  "AND latitude IS NOT NULL " +
108                                  "AND longitude IS NOT NULL " +                                  "AND longitude IS NOT NULL " +
109                                  "AND gadeid IS NOT NULL " +                                  "AND gadeid IS NOT NULL " +
Legend:
Removed from v.2642  
changed lines
  Added in v.2643
  ViewVC Help
Powered by ViewVC 1.1.20