]> git.openstreetmap.org Git - nominatim.git/log
nominatim.git
8 years agomark checkpoint_segments parameter as deprecated
Sarah Hoffmann [Thu, 4 Aug 2016 20:17:05 +0000 (22:17 +0200)]
mark checkpoint_segments parameter as deprecated

Postgresql 9.5 has checkpoint_segments removed and fails to start
if the options is given. Adds a comment to that effect.

Fixes #494.

8 years agoMerge pull request #499 from mtmail/travis-ci
Sarah Hoffmann [Wed, 3 Aug 2016 06:35:32 +0000 (08:35 +0200)]
Merge pull request #499 from mtmail/travis-ci

Travis ci setup - tests pass

8 years agoMerge remote-tracking branch 'upstream/master' into travis-ci
Marc Tobias Metten [Tue, 2 Aug 2016 23:10:30 +0000 (01:10 +0200)]
Merge remote-tracking branch 'upstream/master' into travis-ci

8 years agotravis-ci: enable river tests again, numpy package was missing
Marc Tobias Metten [Tue, 2 Aug 2016 22:57:30 +0000 (00:57 +0200)]
travis-ci: enable river tests again, numpy package was missing

8 years agotravis-ci: enable river tests again, numpy package was missing
Marc Tobias Metten [Tue, 2 Aug 2016 22:54:49 +0000 (00:54 +0200)]
travis-ci: enable river tests again, numpy package was missing

8 years agoupdate paths in vagrant docs
Sarah Hoffmann [Tue, 2 Aug 2016 20:55:13 +0000 (22:55 +0200)]
update paths in vagrant docs

8 years agoMerge pull request #497 from lonvia/forbid-execution-from-sourcedir
Sarah Hoffmann [Tue, 2 Aug 2016 20:42:20 +0000 (22:42 +0200)]
Merge pull request #497 from lonvia/forbid-execution-from-sourcedir

fail on execution of util scripts from source directory

8 years agoMerge pull request #476 from mtmail/travis-ci
mtmail [Mon, 1 Aug 2016 00:03:45 +0000 (02:03 +0200)]
Merge pull request #476 from mtmail/travis-ci

travis-ci setup

8 years agofail on execution of util scripts from source directory
Sarah Hoffmann [Sun, 31 Jul 2016 20:55:38 +0000 (22:55 +0200)]
fail on execution of util scripts from source directory

Utils scripts must be run from the build directory to make sure
we get the right paths. Rename the settings file in source and
replace the original one with an error, so that scripts
fail with an understandable error message when run from the
source directory.

8 years agotravis: exclude poldi, waterway tests
Marc Tobias Metten [Sun, 31 Jul 2016 00:33:47 +0000 (02:33 +0200)]
travis: exclude poldi, waterway tests

8 years agotravis: exclude poldi, waterway tests
Marc Tobias Metten [Sun, 31 Jul 2016 00:18:27 +0000 (02:18 +0200)]
travis: exclude poldi, waterway tests

8 years agotravis: exclude poldi, waterway tests
Marc Tobias Metten [Sun, 31 Jul 2016 00:17:28 +0000 (02:17 +0200)]
travis: exclude poldi, waterway tests

8 years agoMerge remote-tracking branch 'upstream/master' into travis-ci
Marc Tobias Metten [Sat, 30 Jul 2016 19:53:27 +0000 (21:53 +0200)]
Merge remote-tracking branch 'upstream/master' into travis-ci

8 years agoMerge pull request #490 from lonvia/streamline-class-interfaces
Sarah Hoffmann [Wed, 27 Jul 2016 18:56:10 +0000 (20:56 +0200)]
Merge pull request #490 from lonvia/streamline-class-interfaces

Code cleanup for geocode classes

8 years agoremove unused functions in Geocode
Sarah Hoffmann [Tue, 26 Jul 2016 21:01:42 +0000 (23:01 +0200)]
remove unused functions in Geocode

8 years agocleanup interface of PlaceLookup
Sarah Hoffmann [Mon, 25 Jul 2016 21:55:06 +0000 (23:55 +0200)]
cleanup interface of PlaceLookup

Move lookup parameters (place id, type, frac etc.) from members
to parameters for lookup().

8 years agoremove unnecessary local variable
Sarah Hoffmann [Mon, 25 Jul 2016 21:02:30 +0000 (23:02 +0200)]
remove unnecessary local variable

8 years agorefactor ReverseGeocode
Sarah Hoffmann [Mon, 25 Jul 2016 20:44:01 +0000 (22:44 +0200)]
refactor ReverseGeocode

- remove unused functions and members
- move coordinates from being members to being parameters of lookup()

8 years agofix typos and grammar in installation instructions
Sarah Hoffmann [Tue, 26 Jul 2016 18:38:07 +0000 (20:38 +0200)]
fix typos and grammar in installation instructions

8 years agoMerge pull request #487 from lonvia/unify-reverse
Sarah Hoffmann [Mon, 25 Jul 2016 20:15:28 +0000 (22:15 +0200)]
Merge pull request #487 from lonvia/unify-reverse

Remove duplicate reverse geocoding code

8 years agoremove duplicate reverse geocoding code
Sarah Hoffmann [Sun, 24 Jul 2016 21:58:39 +0000 (23:58 +0200)]
remove duplicate reverse geocoding code

Geocode now uses ReverseGeocode directly. Note that it currently
cannot support any interpolations, neither OSM nor Tiger. But
neither did the previous version.

8 years agoadapt Tiger reverse test to new output format
Sarah Hoffmann [Sun, 24 Jul 2016 21:58:21 +0000 (23:58 +0200)]
adapt Tiger reverse test to new output format

8 years agoremove IP blocking and rate-limiting code
Sarah Hoffmann [Mon, 18 Jul 2016 12:41:09 +0000 (14:41 +0200)]
remove IP blocking and rate-limiting code

Closes #472.

8 years agoMerge pull request #486 from IrlJidel/patch-1
Sarah Hoffmann [Sat, 16 Jul 2016 08:09:09 +0000 (10:09 +0200)]
Merge pull request #486 from IrlJidel/patch-1

pgsqlRunPartitionScript needs global $aCMDResult

8 years agopgsqlRunPartitionScript needs global $aCMDResult
IrlJidel [Thu, 14 Jul 2016 18:49:58 +0000 (19:49 +0100)]
pgsqlRunPartitionScript needs global $aCMDResult

function pgsqlRunPartitionScript  was missing global $aCMDResult

setup was failing with

...
PHP Notice:  Undefined variable: aCMDResult in /home/roles/nominatim/app/Nominatim/build/utils/setup.php on line 768
NOTICE:  type "nearplace" does not exist, skipping
..
ERROR:  relation "location_area_large_0" already exists
ERROR: pgsql returned with error code (3)
pgsql returned with error code (3)
Command exited with non-zero status 255

8 years agotravis-ci setup, some tests fails
Marc Tobias Metten [Tue, 21 Jun 2016 21:42:36 +0000 (23:42 +0200)]
travis-ci setup, some tests fails

8 years agoallow coordinates in query only with name or classtype
Sarah Hoffmann [Wed, 15 Jun 2016 20:39:21 +0000 (22:39 +0200)]
allow coordinates in query only with name or classtype

Coordinates with country or housenumber only do not make much
sense. Currently these combination result in queries that
require a sequential scan of search_name and normally time
out before yielding any results.

fixes #462

8 years agofix links to documentation in README
Sarah Hoffmann [Tue, 14 Jun 2016 21:11:14 +0000 (23:11 +0200)]
fix links to documentation in README

8 years agomore instructions for Tiger imports
Sarah Hoffmann [Tue, 14 Jun 2016 19:44:18 +0000 (21:44 +0200)]
more instructions for Tiger imports

8 years agoreverse do not downgrade tiger and interpolation results
Sarah Hoffmann [Tue, 14 Jun 2016 19:38:03 +0000 (21:38 +0200)]
reverse do not downgrade tiger and interpolation results

Also fix the type that is returned for Tiger data.

Fixes #470

8 years agoMerge pull request #469 from lonvia/refactor-php
Sarah Hoffmann [Mon, 13 Jun 2016 18:13:38 +0000 (20:13 +0200)]
Merge pull request #469 from lonvia/refactor-php

Some refactoring of website php

8 years agoadd instructions to enable use of Tiger data
Sarah Hoffmann [Mon, 13 Jun 2016 18:07:57 +0000 (20:07 +0200)]
add instructions to enable use of Tiger data

8 years agofix more syntax errors in error functions
Sarah Hoffmann [Sun, 12 Jun 2016 21:25:47 +0000 (23:25 +0200)]
fix more syntax errors in error functions

8 years agoallow parameters to be empty
Sarah Hoffmann [Sun, 12 Jun 2016 21:22:14 +0000 (23:22 +0200)]
allow parameters to be empty

Consider empty parameters as unset and use the default. Simplifies
use in forms.

8 years agofix syntax errors and update tests
Sarah Hoffmann [Sun, 12 Jun 2016 20:33:37 +0000 (22:33 +0200)]
fix syntax errors and update tests

Some of the tests with bad parameters now return a HTTP 400.

8 years agouse chksql everywhere in lib/
Sarah Hoffmann [Sun, 12 Jun 2016 12:58:05 +0000 (14:58 +0200)]
use chksql everywhere in lib/

Replaces manual PEAR error checks and adds the chksql wrapper
where the error checks were still missing.

8 years agointroduce chksql function for website code and move other fail functions
Sarah Hoffmann [Sun, 12 Jun 2016 12:34:57 +0000 (14:34 +0200)]
introduce chksql function for website code and move other fail functions

The default error screen now reports the full SQL even when not
in debug mode as this message is often more helpful than our
custom error message.

8 years agofactor out link formatting function and osm type translation
Sarah Hoffmann [Sun, 12 Jun 2016 10:39:09 +0000 (12:39 +0200)]
factor out link formatting function and osm type translation

8 years agoupdate links to OSM objects
Sarah Hoffmann [Sun, 12 Jun 2016 07:26:58 +0000 (09:26 +0200)]
update links to OSM objects

/browse/ is no longer necesary in the URL

8 years agoremove now unused bAsPoints in reverse API
Sarah Hoffmann [Sat, 11 Jun 2016 21:27:21 +0000 (23:27 +0200)]
remove now unused bAsPoints in reverse API

8 years agointroduce accessor function for URL parameter
Sarah Hoffmann [Sat, 11 Jun 2016 21:07:06 +0000 (23:07 +0200)]
introduce accessor function for URL parameter

These functions take care of type conversion and check that
the parameters contain legal values. The API now returns a
Bad Request error if the format is wrong.

8 years agopolygons.php: print total number of broken polygons
Sarah Hoffmann [Fri, 10 Jun 2016 21:58:50 +0000 (23:58 +0200)]
polygons.php: print total number of broken polygons

8 years agoremove dead code
Sarah Hoffmann [Fri, 10 Jun 2016 21:54:28 +0000 (23:54 +0200)]
remove dead code

8 years agoMerge pull request #219 from mizabrik/master
Sarah Hoffmann [Thu, 9 Jun 2016 19:53:56 +0000 (21:53 +0200)]
Merge pull request #219 from mizabrik/master

Fix case sensitivity of cyrillic ghe

8 years agointroduce chksql function for phpscripts
Sarah Hoffmann [Wed, 8 Jun 2016 22:24:18 +0000 (00:24 +0200)]
introduce chksql function for phpscripts

Checks SQL query results for errors and bails out if it finds one.
Avoids some heavy code duplication all over the place.

8 years agoremove --create-website function
Sarah Hoffmann [Wed, 8 Jun 2016 21:39:12 +0000 (23:39 +0200)]
remove --create-website function

Symlinking does not go well with the separate build directory.
The recommended method is now to serve the website directly from
build/website via an alias. 'website installation' may be
reintroduced later via cmake.

8 years agoMerge pull request #464 from lonvia/vagrant-with-docs
Sarah Hoffmann [Wed, 8 Jun 2016 21:25:50 +0000 (23:25 +0200)]
Merge pull request #464 from lonvia/vagrant-with-docs

Move installation documentation from wiki into /docs directory

8 years agoremove old vagrant scripts
Sarah Hoffmann [Wed, 8 Jun 2016 21:23:09 +0000 (23:23 +0200)]
remove old vagrant scripts

8 years agofix formatting of docs
Sarah Hoffmann [Wed, 8 Jun 2016 21:17:48 +0000 (23:17 +0200)]
fix formatting of docs

8 years agoadd compiled vagrant docs in docs/ directory
Sarah Hoffmann [Wed, 8 Jun 2016 21:06:15 +0000 (23:06 +0200)]
add compiled vagrant docs in docs/ directory

8 years agoadd vagrant script for ubuntu 16 and polish everything
Sarah Hoffmann [Wed, 8 Jun 2016 21:03:11 +0000 (23:03 +0200)]
add vagrant script for ubuntu 16 and polish everything

8 years agofix cut&paste error in php tests
Sarah Hoffmann [Wed, 8 Jun 2016 20:51:56 +0000 (22:51 +0200)]
fix cut&paste error in php tests

8 years agomove installation instructions from wiki page here
Sarah Hoffmann [Tue, 7 Jun 2016 20:47:57 +0000 (22:47 +0200)]
move installation instructions from wiki page here

8 years agofix apache permission problems in CentOS vagrant script
Sarah Hoffmann [Mon, 6 Jun 2016 22:27:20 +0000 (00:27 +0200)]
fix apache permission problems in CentOS vagrant script

8 years agosplit instruction into software installation and import
Sarah Hoffmann [Mon, 6 Jun 2016 22:17:15 +0000 (00:17 +0200)]
split instruction into software installation and import

Basically leaves the part that needs to be done by the automatic
vagrant script in the bash script and moves the remaining part
into an OS-independent md file.

Also fixes some of the instructions for CentOS. Now almost runs
through (some minor issue with permission remains).

8 years agoinitial version of documented CentOS7 vagrant script
Sarah Hoffmann [Sun, 1 May 2016 20:45:54 +0000 (22:45 +0200)]
initial version of documented CentOS7 vagrant script

8 years agoprovide srcdir for postgres module in VPATH and CPPFLAGS
Sarah Hoffmann [Sat, 4 Jun 2016 22:35:07 +0000 (00:35 +0200)]
provide srcdir for postgres module in VPATH and CPPFLAGS

The pgxs makefile in Postgres <= 9.2 cannot yet handle VPATH
correctly. Provide header paths explicitly and overwrite
VPATH after sourcing the pgxs file.

Fixes #454.

8 years agouse place_id instead of parent_place_id for excluded place_ids in interpolation lines...
markigail [Thu, 19 May 2016 19:12:38 +0000 (21:12 +0200)]
use place_id instead of parent_place_id for excluded place_ids in interpolation lines query

8 years agoremove reference assignment where unnecessary
Sarah Hoffmann [Sat, 4 Jun 2016 21:46:19 +0000 (23:46 +0200)]
remove reference assignment where unnecessary

Avoids a number of warnings on PHP7.

8 years agoMerge branch 'interpolations'
Sarah Hoffmann [Sat, 4 Jun 2016 21:29:11 +0000 (23:29 +0200)]
Merge branch 'interpolations'

8 years agofill place and osmline independently for interpolations on update
Sarah Hoffmann [Sat, 28 May 2016 16:18:18 +0000 (18:18 +0200)]
fill place and osmline independently for interpolations on update

interpolation lines may be missing in osmline when the interpolation
is broken, so we cannot conclude that a way is not in place, just
because there are no entries in location_property_osmline.

8 years agoreinstate tests for geometrytype
Sarah Hoffmann [Fri, 27 May 2016 21:36:01 +0000 (23:36 +0200)]
reinstate tests for geometrytype

8 years agofix variable name in search xml output
Sarah Hoffmann [Fri, 27 May 2016 21:35:24 +0000 (23:35 +0200)]
fix variable name in search xml output

8 years agocmake: use explicit VPATH when calling pgxs makefile
Sarah Hoffmann [Mon, 23 May 2016 22:24:23 +0000 (00:24 +0200)]
cmake: use explicit VPATH when calling pgxs makefile

Some postgres installations report problems with the makefile
magic that should look for the source where the Makefile is
located. So hand in the path explicitly via VPATH instead.

Fixes #453.

8 years agocmake: force-set options and explicitly check for pgxs makefile
Sarah Hoffmann [Mon, 23 May 2016 20:20:59 +0000 (22:20 +0200)]
cmake: force-set options and explicitly check for pgxs makefile

fixes #443

8 years agoreintroduce addr:place for interpolation
Sarah Hoffmann [Sun, 15 May 2016 12:24:43 +0000 (14:24 +0200)]
reintroduce addr:place for interpolation

It is perfectly valid that interpolated addresses refer to
something else than a street.

Also gets rid of the maximum interpolation size. As we don't
expand, arbitrary sizes are fine.

8 years agotests: permit duplicate entries in interpolation table
Sarah Hoffmann [Sun, 15 May 2016 12:24:12 +0000 (14:24 +0200)]
tests: permit duplicate entries in interpolation table

fixes self-intersecting interpolation test

8 years agotests for interpolation to building type change
Sarah Hoffmann [Sun, 15 May 2016 10:37:49 +0000 (12:37 +0200)]
tests for interpolation to building type change

8 years agoupdate comments and formatting
Sarah Hoffmann [Sun, 15 May 2016 10:37:20 +0000 (12:37 +0200)]
update comments and formatting

8 years agofix scene making scripts and add building-parallel-road scene
Sarah Hoffmann [Sun, 15 May 2016 09:29:09 +0000 (11:29 +0200)]
fix scene making scripts and add building-parallel-road scene

Scripts updated to newest libosmium and shebang fixed.

8 years agoremove duplicate index
Sarah Hoffmann [Sun, 15 May 2016 08:57:03 +0000 (10:57 +0200)]
remove duplicate index

8 years agoget housenumber data for interpolations from place table
Sarah Hoffmann [Sun, 15 May 2016 07:44:00 +0000 (09:44 +0200)]
get housenumber data for interpolations from place table

The placex table may not yet be filled when the interpolation
lines are computed.

8 years agofix syntax in load-data function
Sarah Hoffmann [Sun, 15 May 2016 07:41:11 +0000 (09:41 +0200)]
fix syntax in load-data function

Also makes sure that load data runs with at least 2 threads: one
for loading placex and one for loading osmline.

8 years agoMerge remote-tracking branch 'markus/master' into master
Sarah Hoffmann [Sat, 14 May 2016 19:09:57 +0000 (21:09 +0200)]
Merge remote-tracking branch 'markus/master' into master

8 years agoChange load-data in setup.php.
markigail [Mon, 9 May 2016 13:07:58 +0000 (15:07 +0200)]
Change load-data in setup.php.

8 years agoFix bug in index.c and remove column admin_level from location_property_osmline.
markigail [Sun, 8 May 2016 14:46:42 +0000 (16:46 +0200)]
Fix bug in index.c and remove column admin_level from location_property_osmline.

8 years agofix small bug in index.c
markigail [Tue, 3 May 2016 10:52:08 +0000 (12:52 +0200)]
fix small bug in index.c

8 years agoMerge pull request #447 from lonvia/fix-array-expression
mtmail [Sun, 1 May 2016 09:53:54 +0000 (11:53 +0200)]
Merge pull request #447 from lonvia/fix-array-expression

replace new-style [] expression with old-style array()

8 years agoreplace new-style [] expression with old-style array()
Sarah Hoffmann [Sun, 1 May 2016 09:17:18 +0000 (11:17 +0200)]
replace new-style [] expression with old-style array()

Also removes some unused code.

fixes #444

8 years agoMerge pull request #446 from mtmail/make-outline-clickable-in-ui
Sarah Hoffmann [Sun, 1 May 2016 09:11:21 +0000 (11:11 +0200)]
Merge pull request #446 from mtmail/make-outline-clickable-in-ui

UI: the result outline (geojson/polygon) now lets the map handle clicks

8 years agoUI: the result outline (geojson/polygon) now lets the map handle its clicks
marc tobias [Sun, 1 May 2016 08:47:13 +0000 (10:47 +0200)]
UI: the result outline (geojson/polygon) now lets the map handle its clicks

8 years agofix bug in Geocode.php
Markus Gail [Fri, 29 Apr 2016 08:24:30 +0000 (10:24 +0200)]
fix bug in Geocode.php

8 years agoindex on geometry of interpolation lines, and more improvements.
Markus Gail [Wed, 27 Apr 2016 15:42:59 +0000 (17:42 +0200)]
index on geometry of interpolation lines, and more improvements.

8 years agoMerge pull request #441 from mtmail/update-php-to-check-for-correct-js-file
Sarah Hoffmann [Tue, 26 Apr 2016 19:03:58 +0000 (21:03 +0200)]
Merge pull request #441 from mtmail/update-php-to-check-for-correct-js-file

update.php was checking for static file which is no longer part of the project

8 years agoupdate.php was checking for static file which is no longer part of the project
Marc Tobias Metten [Tue, 26 Apr 2016 18:45:48 +0000 (20:45 +0200)]
update.php was checking for static file which is no longer part of the project

8 years agoCorrect merge error in Geocode.php.
Markus Gail [Mon, 25 Apr 2016 15:44:34 +0000 (17:44 +0200)]
Correct merge error in Geocode.php.

8 years agoCoding style adaptions and correcting small errors from merge.
Markus Gail [Mon, 25 Apr 2016 11:58:28 +0000 (13:58 +0200)]
Coding style adaptions and correcting small errors from merge.

8 years agoMerge remote-tracking branch 'origin/master' into osmline
Markus Gail [Mon, 25 Apr 2016 09:01:04 +0000 (11:01 +0200)]
Merge remote-tracking branch 'origin/master' into osmline

Conflicts:
lib/Geocode.php
lib/PlaceLookup.php
sql/functions.sql
sql/tables.sql
utils/setup.php

8 years agoRemove interpolation lines from placex and save them in an extra table.
Markus Gail [Mon, 25 Apr 2016 07:44:01 +0000 (09:44 +0200)]
Remove interpolation lines from placex and save them in an extra table.

8 years agoMerge pull request #436 from lonvia/remove-location-property-tables
Sarah Hoffmann [Sun, 24 Apr 2016 14:05:10 +0000 (16:05 +0200)]
Merge pull request #436 from lonvia/remove-location-property-tables

remove unused location_property_-partion- tables

8 years agocreate_sql_functions() needs the commandline parameters
Sarah Hoffmann [Sat, 23 Apr 2016 09:07:12 +0000 (11:07 +0200)]
create_sql_functions() needs the commandline parameters

Fixes one failing test.

8 years agoremove unused location_property_-partion- tables
Sarah Hoffmann [Sat, 23 Apr 2016 08:07:57 +0000 (10:07 +0200)]
remove unused location_property_-partion- tables

8 years agoapply marker filtering to functions.sql also after table creation
Sarah Hoffmann [Wed, 20 Apr 2016 22:00:15 +0000 (00:00 +0200)]
apply marker filtering to functions.sql also after table creation

fixes #430

8 years agoremove duplicate CORS header
Sarah Hoffmann [Tue, 12 Apr 2016 21:04:38 +0000 (23:04 +0200)]
remove duplicate CORS header

fixes #427

8 years agoMerge pull request #425 from lonvia/disable-aux-tables
Sarah Hoffmann [Tue, 12 Apr 2016 21:00:24 +0000 (23:00 +0200)]
Merge pull request #425 from lonvia/disable-aux-tables

make tables for external data (Tiger and aux) configurable

8 years agoMerge pull request #424 from lonvia/cleanup-logging
Sarah Hoffmann [Tue, 12 Apr 2016 20:58:14 +0000 (22:58 +0200)]
Merge pull request #424 from lonvia/cleanup-logging

clean up query logging

8 years agomake tables for external data (Tiger and aux) configurable
Sarah Hoffmann [Thu, 7 Apr 2016 19:47:51 +0000 (21:47 +0200)]
make tables for external data (Tiger and aux) configurable

Introduces two new settings CONST_Use_US_Tiger_Data and
CONST_Use_Aux_Location_data, which are disabled by default.
When false the corresponding tables are ignored in queries
and updates.

Aux and tiger tables are no longer created by default. This
has to be done by the corresponding import scripts. The former
aux table creation can be found in sql/aux_tables.sql for
reference.

8 years agoclean up query logging
Sarah Hoffmann [Thu, 7 Apr 2016 18:37:27 +0000 (20:37 +0200)]
clean up query logging

- remove query_log table, keeping only new_query_log
- drop unused import_npi_log table
- disable DB logging per default
- use file logging structure from osm.org

8 years agoMerge pull request #420 from lonvia/remove-explicit-software-versions
Sarah Hoffmann [Fri, 1 Apr 2016 21:03:01 +0000 (23:03 +0200)]
Merge pull request #420 from lonvia/remove-explicit-software-versions

Remove unsupported/unused features and settings

8 years agoremove deleted us_state* tables from tests as well
Sarah Hoffmann [Fri, 1 Apr 2016 20:57:45 +0000 (22:57 +0200)]
remove deleted us_state* tables from tests as well