From 2dce0ba6123ea0ff7fe9438e610780709e829ce7 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Fri, 1 Jul 2011 12:59:37 +0000 Subject: [PATCH] put in associated ticket numbers change to unaligned format for easier diffing, add in script to run test suite. Force LF and put svn keywords git-svn-id: http://svn.osgeo.org/postgis/trunk@7541 b70326c6-7e19-0410-871a-916f4a2858ee --- .../tiger_2010/regress/geocode_regress.sql | 3 +- .../regress/normalize_address_regress | 30 ++++++++----------- .../regress/normalize_address_regress.sql | 21 +++++++------ .../tiger_2010/regress/regress.sql | 5 ++++ 4 files changed, 31 insertions(+), 28 deletions(-) create mode 100644 extras/tiger_geocoder/tiger_2010/regress/regress.sql diff --git a/extras/tiger_geocoder/tiger_2010/regress/geocode_regress.sql b/extras/tiger_geocoder/tiger_2010/regress/geocode_regress.sql index 0f17d2246..1c3cde0af 100644 --- a/extras/tiger_geocoder/tiger_2010/regress/geocode_regress.sql +++ b/extras/tiger_geocoder/tiger_2010/regress/geocode_regress.sql @@ -1,3 +1,4 @@ +--$Id$ \timing -- Limit 1 SELECT pprint_addy(addy) As address, ST_AsText(geomout) As pt, rating FROM geocode('529 Main Street, Boston, MA 02129',1); @@ -29,4 +30,4 @@ SELECT pprint_addy(addy) As address, ST_AsText(geomout) As pt, rating FROM geoco --Geocoding mangled zipcodes SELECT pprint_addy(addy) As address, ST_AsText(geomout) As pt, rating FROM geocode('212 3rd Ave N, MINNEAPOLIS, MN 553404'); SELECT pprint_addy(addy) As address, ST_AsText(geomout) As pt, rating FROM geocode('212 3rd Ave N, MINNEAPOLIS, MN 55340-'); -\timing \ No newline at end of file +\timing diff --git a/extras/tiger_geocoder/tiger_2010/regress/normalize_address_regress b/extras/tiger_geocoder/tiger_2010/regress/normalize_address_regress index 4ab88ffe2..211f91e4d 100644 --- a/extras/tiger_geocoder/tiger_2010/regress/normalize_address_regress +++ b/extras/tiger_geocoder/tiger_2010/regress/normalize_address_regress @@ -1,18 +1,12 @@ - 3937 | | 43RD | Ave | S | | MINNEAPOLIS | MN | 55406 | t - - 529 | | Main | St | | | Boston | MA | 02129 | t - - 529 | | Main | St | | | Boston | MA | 02129 | t - - 529 | | Main | St | | | Boston | MA | | t - - 529 | | Main | St | | | Boston | MA | 021 | t - - 212 | | 3rd | Ave | N | | MINNEAPOLIS | MN | 553404 | t - - 212 | | 3rd | Ave | N | | MINNEAPOLIS | MN | 55401 | t - - 949 | N | 3rd | St | | | New Hyde Park | NY | 11040 | t - - 949 | N | 3rd | St | | | New Hyde Park | NY | 11040 | t - +#887|2450|N|COLORADO|St|||PHILADELPHIA|PA|19132|t +#1051|212||3rd|Ave|N|Suite 560|Minneapolis|MN|55401|t +#1051|3937||43RD|Ave|S||MINNEAPOLIS|MN|55406|t +#1051|212|N|3rd|Ave|||Minneapolis|MN|55401|t +529||Main|St|||Boston|MA|02129|t +529||Main|St|||Boston|MA|02129|t +529||Main|St|||Boston|MA||t +#1073|212||3rd|Ave|N||MINNEAPOLIS|MN|553404|t +#1073|212||3rd|Ave|N||MINNEAPOLIS|MN|55401|t +#1073|529||Main|St|||Boston|MA|021|t +#1086|949|N|3rd|St|||New Hyde Park|NY|11040|t +#1086|949|N|3rd|St|||New Hyde Park|NY|11040|t diff --git a/extras/tiger_geocoder/tiger_2010/regress/normalize_address_regress.sql b/extras/tiger_geocoder/tiger_2010/regress/normalize_address_regress.sql index 9c805315f..ba34e39ca 100644 --- a/extras/tiger_geocoder/tiger_2010/regress/normalize_address_regress.sql +++ b/extras/tiger_geocoder/tiger_2010/regress/normalize_address_regress.sql @@ -1,21 +1,24 @@ +--$Id$ \timing -SELECT * FROM normalize_address('3937 43RD AVE S, MINNEAPOLIS, MN 55406'); +SELECT '#887' As ticket, * FROM normalize_address('2450 N COLORADO ST, PHILADELPHIA, PA, 19132'); +SELECT '#1051' As ticket, * FROM normalize_address('212 3rd Ave N Suite 560, Minneapolis, MN 55401'); +SELECT '#1051' As ticket, * FROM normalize_address('3937 43RD AVE S, MINNEAPOLIS, MN 55406'); +SELECT '#1051' As ticket, * from normalize_address('212 N 3rd Ave, Minneapolis, MN 55401'); -- comma in wrong spot SELECT * FROM normalize_address('529 Main Street, Boston MA, 02129'); -- comma in right spot SELECT * FROM normalize_address('529 Main Street, Boston,MA 02129'); -- partial address SELECT * FROM normalize_address('529 Main Street, Boston, MA'); --- partial address -SELECT * FROM normalize_address('529 Main Street, Boston, MA 021'); --- Mangled zipcodes -SELECT * FROM normalize_address('212 3rd Ave N, MINNEAPOLIS, MN 553404'); -SELECT * FROM normalize_address('212 3rd Ave N, MINNEAPOLIS, MN 55401-'); +-- Partial and Mangled zipcodes +SELECT '#1073' As ticket, * FROM normalize_address('212 3rd Ave N, MINNEAPOLIS, MN 553404'); +SELECT '#1073' As ticket, * FROM normalize_address('212 3rd Ave N, MINNEAPOLIS, MN 55401-'); +SELECT '#1073' As ticket, * FROM normalize_address('529 Main Street, Boston, MA 021'); -- comma in wrong position -SELECT * FROM normalize_address('949 N 3rd St, New Hyde Park, NY, 11040'); +SELECT '#1086' As ticket, * FROM normalize_address('949 N 3rd St, New Hyde Park, NY, 11040'); -- comma in right position -- -SELECT * FROM normalize_address('949 N 3rd St, New Hyde Park, NY 11040'); -\timing \ No newline at end of file +SELECT '#1086' As ticket, * FROM normalize_address('949 N 3rd St, New Hyde Park, NY 11040'); +\timing diff --git a/extras/tiger_geocoder/tiger_2010/regress/regress.sql b/extras/tiger_geocoder/tiger_2010/regress/regress.sql new file mode 100644 index 000000000..c8f730c7f --- /dev/null +++ b/extras/tiger_geocoder/tiger_2010/regress/regress.sql @@ -0,0 +1,5 @@ +\a +\o normalize_address.out +\i normalize_address_regress.sql +\o geocode_regress.out +\i geocode_regress.sql \ No newline at end of file -- 2.50.1