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

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

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

revision 2639 by torben, Mon Jul 13 10:16:41 2015 UTC revision 2640 by torben, Tue Jul 28 08:08:22 2015 UTC
# Line 102  public class Database { Line 102  public class Database {
102                                  "LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " +                                  "LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " +
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
106                                    "AND a.postnr NOT BETWEEN 9000 AND 9499 " + // 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.2639  
changed lines
  Added in v.2640
  ViewVC Help
Powered by ViewVC 1.1.20