From: Sarah Hoffmann Date: Wed, 28 Dec 2016 22:41:08 +0000 (+0100) Subject: add source files for test database X-Git-Tag: v3.0.0~85^2~3 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/5252051291262562a3339f33ec284196f4a3c919 add source files for test database --- diff --git a/test/testdb/README.md b/test/testdb/README.md new file mode 100644 index 00000000..a39b0258 --- /dev/null +++ b/test/testdb/README.md @@ -0,0 +1,15 @@ +Creating the test database +========================== + +The official test dataset is derived from the 160725 planet. Newer +planets are likely to work as well but you may see isolated test +failures where the data has changed. To recreate the input data +for the test database run: + + wget http://free.nchc.org.tw/osm.planet/pbf/planet-160725.osm.pbf + osmconvert planet-160725.osm.pbf -B=testdb.polys -o=testdb.pbf + +Before importing make sure to add the following to your local settings: + + @define('CONST_Database_DSN', 'pgsql://@/test_api_nominatim'); + @define('CONST_Wikipedia_Data_Path', CONST_BasePath.'/test/testdb'); diff --git a/test/testdb/testdb.polys b/test/testdb/testdb.polys new file mode 100644 index 00000000..4298d68e --- /dev/null +++ b/test/testdb/testdb.polys @@ -0,0 +1,188 @@ +hamburg +1 + 9.5842804224817 53.5792118965693 + 10.2155260812517 53.8246176085747 + 10.475796519837 53.4477065812749 + 9.86815657040402 53.3278566584492 + 9.5842804224817 53.5792118965693 +END +END +liechtenstein +1 + 9.20853378041844 47.0559465458986 + 9.29384606832709 47.3507444175206 + 9.49848868129809 47.4492015884201 + 9.89867967626406 47.130228397937 + 9.58252408463202 46.8691824262863 + 9.20853378041844 47.0559465458986 +END +END +mauretania +1 + -17.1644809253606 20.8842205115601 + -16.9724694177095 21.4269590060279 + -13.1021317602129 21.4296172232924 + -13.1921945122782 22.933479308252 + -12.6268357994672 23.3657053906301 + -12.097953263953 23.5240373343518 + -12.0829087151283 26.0504750040867 + -8.76667736314239 26.0902806494621 + -8.70696146546581 27.398150020094 + -4.74082309576697 25.0335832288387 + -4.81791817472112 24.9110447612753 + -6.46188681458007 24.9097418021523 + -5.52019664485951 16.5528424294381 + -5.23944558032214 16.3345963721271 + -5.46430959536222 15.4167603246987 + -10.5098309475637 15.3543804758815 + -10.8990110578091 15.0165664449548 + -11.4524241105327 15.5284484048548 + -11.6506044402694 15.4177129737211 + -11.7217380574693 14.8443740855381 + -12.0680385872662 14.631162290351 + -12.9159650211166 15.1353675285383 + -13.4682080737434 15.990978880421 + -13.9034306609561 16.0335336430301 + -14.4204259536969 16.5367120778098 + -16.2084993845136 16.4236729998869 + -16.4302891135388 15.983629954068 + -16.7862990158802 16.0015581695182 + -16.3398604501701 18.2277294784962 + -16.8886326298423 19.403294102207 + -16.585950103956 20.1812628878206 + -17.0813413461875 20.5018960498623 + -17.1644809253606 20.8842205115601 +END +END +southdakota +1 + -104.297439187793 45.5046231666747 + -104.299553299189 45.9775616107873 + -104.096382287788 46.1214554410027 + -96.4569073278818 46.0989703969216 + -96.3044767039811 45.9115675974812 + -96.5247176872565 45.5862877816162 + -96.1968327207445 45.3001425265336 + -96.1895592635092 43.1140553398185 + -96.3329810429579 42.753709571028 + -96.2088431240585 42.4315154785281 + -96.5131423452368 42.3018249286814 + -97.3698668669773 42.6757095208851 + -98.0672608450503 42.5864899816312 + -98.6364176029847 42.8190548434256 + -104.146030684593 42.8349704964079 + -104.298744415682 43.0007971343175 + -104.297439187793 45.5046231666747 +END +END +uruguay +1 + -58.7094503498495 -33.5893528935793 + -58.5930297220504 -33.0935229194446 + -58.329380679061 -32.9223715673938 + -58.4160616358367 -31.8529190894557 + -58.2162152055053 -31.6271374679322 + -58.2872417410783 -31.4234579824293 + -58.0141967102111 -30.7805399817192 + -58.0801823804181 -30.438369563871 + -57.7465673402929 -30.0366166581386 + -57.3919054971047 -30.0920714480735 + -57.0841245854315 -29.904689506793 + -56.5203007925187 -30.0577138349604 + -55.8148965965951 -30.7486942236281 + -55.4992686810269 -30.6637735134172 + -55.0823825399047 -31.0951827436534 + -54.4609533378373 -31.3096231186724 + -52.8647106347639 -32.7122837473293 + -53.3056885052038 -33.2040687582016 + -53.3095867684494 -33.547639206286 + -52.9652990494926 -33.8719452856167 + -53.3564833683333 -34.6077542513996 + -55.6741509399751 -35.9609110600942 + -58.0955146798429 -34.8078487405856 + -58.1517292851949 -34.5120322638008 + -58.490557396808 -34.2574246976253 + -58.7094503498495 -33.5893528935793 +END +END + + +vietnam +1 + 111.737359200422 8.65966389848196 + 112.121385535871 9.03974154821598 + 112.431435613709 8.95854407291052 + 112.38091038991 8.72869141993135 + 112.09887919106 8.68752900955559 + 111.97764097397 8.47027379584868 + 111.737359200422 8.65966389848196)) + ((101.952539778161 22.3744843276505 + 102.42115782215 22.9512287654112 + 103.011765362757 22.7267436381062 + 103.309708309047 22.9942421815192 + 103.88404879754 22.8346923138744 + 104.62599830253 23.0355978361405 + 104.77147320329 23.3199292571035 + 105.357960240763 23.571602116825 + 105.914016228782 23.1523756402279 + 106.944000642084 22.9589139939517 + 106.898848084023 22.1610135134167 + 107.607567716302 21.7959107906373 + 107.974793702983 21.8006347108588 + 108.387669146529 21.2765369215022 + 108.350851164743 20.968001228975 + 107.807714207219 20.5205405897832 + 108.126799006308 20.25069143158 + 108.024397106408 19.8655870027683 + 107.557799016272 19.7778131848293 + 107.347203511678 19.9746481898397 + 107.334187929597 20.2503746970115 + 107.017188364275 20.2484351047036 + 106.88168214676 19.9452753668929 + 106.293211714996 19.5544614034104 + 106.229050701227 19.084494263666 + 106.339912028886 18.6544696395528 + 107.02787120458 18.0908270105482 + 106.992048357062 17.6610336194013 + 107.61356106657 17.4455208732243 + 109.497501740771 15.5635441996556 + 109.851305717105 12.5942782065681 + 109.388462041025 9.73419261849773 + 106.766311197844 8.27477170182912 + 104.780565299066 8.00956568214471 + 103.236641212428 8.93273491992321 + 102.869224286517 9.37238182036115 + 102.909736286172 9.54505245725422 + 103.717955146996 10.1271353150665 + 103.686354089781 10.5210100495922 + 104.015476398095 10.662190116791 + 104.247688572369 10.5092223585766 + 104.775438554966 10.7014491439673 + 104.980441972174 11.1056591699101 + 105.7024629092 11.2045497780933 + 105.626753980109 11.6300119740348 + 105.748149258633 11.8111016132902 + 107.378741221451 12.5115515071093 + 107.300732476862 12.958173736809 + 107.435951728865 13.4799057185978 + 107.150187488306 14.1107044150892 + 107.411164618718 15.2667546971578 + 107.034817435829 15.6854570535274 + 107.112895173759 15.9819504632758 + 106.538255811019 16.3296204491326 + 106.173473133351 17.0787384431658 + 105.048356842632 18.1992017641427 + 104.927464569104 18.5590394564598 + 103.69790542148 19.2392576346486 + 103.937765477152 19.8144348780526 + 104.649272403028 19.9254452865302 + 104.202109979964 20.3691301778448 + 104.304114148338 20.6519242141597 + 103.979630359435 20.7152945884418 + 103.65735416319 20.4809125958884 + 103.000528825335 20.7510959123255 + 102.627912181829 21.1973495084135 + 102.683177661723 21.4733395191357 + 101.952539778161 22.3744843276505 +END +END diff --git a/test/testdb/wikipedia_article.sql.bin b/test/testdb/wikipedia_article.sql.bin new file mode 100644 index 00000000..628e2af4 Binary files /dev/null and b/test/testdb/wikipedia_article.sql.bin differ diff --git a/test/testdb/wikipedia_redirect.sql.bin b/test/testdb/wikipedia_redirect.sql.bin new file mode 100644 index 00000000..9c4b513d Binary files /dev/null and b/test/testdb/wikipedia_redirect.sql.bin differ