Changeset 181


Ignore:
Timestamp:
Oct 26, 2006, 5:21:03 PM (13 years ago)
Author:
Dominic Hargreaves
Message:

Reference correct URL; exclude deleted entries

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/npemap.org.uk/scripts/exporter/export.pl

    r179 r181  
    4444print "# Generated on ".gmtime()."\n";
    4545print "#\n";
    46 print "# This information is public domain, and comes from http://npemap.org.uk/\n";
     46print "# This information is public domain, and comes from http://www.npemap.org.uk/\n";
    4747print "#\n";
    4848print "# <outward> <inward> <easting> <northing> <WGS84 lat> <WGS84 long>\n";
     
    111111                        "SELECT outward, inward, AVG(easting) AS avg_easting, AVG(northing) AS avg_northing ".
    112112                        "FROM postcodes   ".
    113                         "WHERE source = ? ".
     113                        "WHERE source = ? AND NOT deleted ".
    114114                        "GROUP BY outward, inward ".
    115115                        "ORDER BY outward, inward ";
     
    121121                my $sql =
    122122                        "SELECT outward, '###' AS inward, AVG(easting) AS avg_easting, AVG(northing) AS avg_northing ".
    123                         "FROM postcodes   ".
     123                        "FROM postcodes WHERE NOT deleted ".
    124124                        "GROUP BY outward ".
    125125                        "ORDER BY outward ";
     
    130130                my $sql =
    131131                        "SELECT outward, substr(inward,1,1) || '##' AS inward, AVG(easting) AS avg_easting, AVG(northing) AS avg_northing ".
    132                         "FROM postcodes   ".
     132                        "FROM postcodes WHERE NOT deleted ".
    133133                        "GROUP BY outward, substr(inward,1,1) ".
    134134                        "ORDER BY outward, inward";
Note: See TracChangeset for help on using the changeset viewer.