Created
April 25, 2018 07:29
-
-
Save midhunkrishna/4c399e9e6a11c65974b8c81d8abb5a0a to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Debug output for Geocode::lookup | |
Geocode: 'Query' => 'New York' | |
'Structured query' => False | |
'Name keys' => 'short_name:en-US', 'name:en-US', 'short_name:en', 'name:en', 'short_name', 'name', 'brand', 'official_name:en-US', 'official_name:en', 'official_name', 'ref', 'type' | |
'Include address' => False | |
'Excluded place IDs' => | |
'Try reversed query' => True | |
'Limit (for searches)' => 20 | |
'Limit (for results)' => 10 | |
'Country codes' => | |
'Bounded search' => False | |
'Viewbox' => | |
'Route points' => | |
'Route width' => False | |
'Max rank' => 20 | |
'Min address rank' => 0 | |
'Max address rank' => 30 | |
'Address rank list' => | |
Query Preprocessing | |
Normalized query: 'new york' | |
Search context: 'Near radius' => False | |
'Near point (SQL)' => '' | |
'Bounded viewbox' => False | |
'Viewbox (SQL, small)' => '' | |
'Viewbox (SQL, large)' => '' | |
'Viewbox (SQL, centre)' => '' | |
'Countries (SQL)' => '' | |
'Excluded IDs (SQL)' => '' | |
Base search: 'Search rank' => 0 | |
'Country code' => '' | |
'Name terms' => | |
'Name terms (stop words)' => | |
'Address terms' => | |
'Address terms (stop words)' => | |
'Address terms (full words)' => | |
'Special search' => 0 | |
'Class' => '' | |
'Type' => '' | |
'House number' => '' | |
'Postcode' => '' | |
Final query phrases: 0 => 'New York' | |
Tokenization | |
Phrases: | |
Type Phrase Words WordSets | |
'' | |
'new york' | |
0 => 'new' | |
1 => 'york' | |
0 => 0 => 'new york' | |
1 => 0 => 'new' | |
1 => 'york' | |
Tokens: ' new york' => ' new york' | |
'new york' => 'new york' | |
' new' => ' new' | |
'new' => 'new' | |
' york' => ' york' | |
'york' => 'york' | |
SELECT word_id, word_token, word, class, type, country_code, operator, search_name_count FROM word WHERE word_token in (' new york','new york',' new','new',' york','york') | |
Valid Tokens: | |
Group word_id word_token word class type country_code operator search_name_count | |
new | |
'5526257' | |
' new' | |
'NEW' | |
new york | |
'5639492' | |
' new york' | |
'New York' | |
york | |
'8232680' | |
' york' | |
'The York' | |
new | |
'4020' | |
'new' | |
'73340' | |
new york | |
'626072' | |
'new york' | |
york | |
'498' | |
'york' | |
'16526' | |
Search candidates | |
rank Name Tokens Name Not Address Tokens Address Not country operator class type postcode housenumber | |
1 # new york(5639492)# | |
2 # york(8232680)# # new(5526257)# | |
3 #new york(626072)# | |
3 # york(8232680)# #new(4020)# | |
3 # new(5526257)# #york(498)# | |
4 #york(498)# # new(5526257)# | |
4 # york(8232680)# #new(4020)# | |
5 #york(498)# #new(4020)# | |
5 #york(498)# #new(4020)# | |
6 #york(498)# #new(4020)# | |
Search Loop, group 1, loop 1 | |
rank Name Tokens Name Not Address Tokens Address Not country operator class type postcode housenumber | |
1 # new york(5639492)# | |
SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20 | |
Internal Server Error | |
Nominatim has encountered an internal error while accessing the database. This may happen because the database is broken or because of a bug in the software. If you think it is a bug, feel free to report it over on Github. Please include the URL that caused the problem and the complete error details below. | |
Message: Could not get places for search terms. | |
SQL Error: DB Error: unknown error | |
Details: | |
object(DB_Error)#7 (8) { | |
["error_message_prefix"]=> | |
string(0) "" | |
["mode"]=> | |
int(1) | |
["level"]=> | |
int(1024) | |
["code"]=> | |
int(-1) | |
["message"]=> | |
string(23) "DB Error: unknown error" | |
["userinfo"]=> | |
string(284) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20 [nativecode=ERROR: canceling statement due to statement timeout]" | |
["backtrace"]=> | |
array(12) { | |
[0]=> | |
array(6) { | |
["file"]=> | |
string(21) "/usr/share/php/DB.php" | |
["line"]=> | |
int(967) | |
["function"]=> | |
string(11) "__construct" | |
["class"]=> | |
string(10) "PEAR_Error" | |
["type"]=> | |
string(2) "->" | |
["args"]=> | |
array(5) { | |
[0]=> | |
string(23) "DB Error: unknown error" | |
[1]=> | |
int(-1) | |
[2]=> | |
int(1) | |
[3]=> | |
int(1024) | |
[4]=> | |
string(284) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20 [nativecode=ERROR: canceling statement due to statement timeout]" | |
} | |
} | |
[1]=> | |
array(7) { | |
["file"]=> | |
string(23) "/usr/share/php/PEAR.php" | |
["line"]=> | |
int(575) | |
["function"]=> | |
string(11) "__construct" | |
["class"]=> | |
string(8) "DB_Error" | |
["object"]=> | |
*RECURSION* | |
["type"]=> | |
string(2) "->" | |
["args"]=> | |
array(4) { | |
[0]=> | |
int(-1) | |
[1]=> | |
int(1) | |
[2]=> | |
int(1024) | |
[3]=> | |
string(284) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20 [nativecode=ERROR: canceling statement due to statement timeout]" | |
} | |
} | |
[2]=> | |
array(7) { | |
["file"]=> | |
string(23) "/usr/share/php/PEAR.php" | |
["line"]=> | |
int(223) | |
["function"]=> | |
string(11) "_raiseError" | |
["class"]=> | |
string(4) "PEAR" | |
["object"]=> | |
object(DB_pgsql)#1 (28) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["features"]=> | |
array(7) { | |
["limit"]=> | |
string(5) "alter" | |
["new_link"]=> | |
string(5) "4.3.0" | |
["numrows"]=> | |
bool(true) | |
["pconnect"]=> | |
bool(true) | |
["prepare"]=> | |
bool(false) | |
["ssl"]=> | |
bool(true) | |
["transactions"]=> | |
bool(true) | |
} | |
["errorcode_map"]=> | |
array(0) { | |
} | |
["connection"]=> | |
resource(2) of type (pgsql link) | |
["dsn"]=> | |
array(9) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["username"]=> | |
string(0) "" | |
["password"]=> | |
bool(false) | |
["protocol"]=> | |
string(3) "tcp" | |
["hostspec"]=> | |
string(0) "" | |
["port"]=> | |
bool(false) | |
["socket"]=> | |
bool(false) | |
["database"]=> | |
string(9) "nominatim" | |
} | |
["autocommit"]=> | |
bool(true) | |
["transaction_opcount"]=> | |
int(0) | |
["affected"]=> | |
int(0) | |
["row"]=> | |
array(0) { | |
} | |
["_num_rows"]=> | |
array(0) { | |
} | |
["fetchmode"]=> | |
int(2) | |
["fetchmode_object_class"]=> | |
string(8) "stdClass" | |
["was_connected"]=> | |
NULL | |
["last_query"]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
["options"]=> | |
array(8) { | |
["result_buffering"]=> | |
int(500) | |
["persistent"]=> | |
bool(false) | |
["ssl"]=> | |
bool(false) | |
["debug"]=> | |
int(0) | |
["seqname_format"]=> | |
string(6) "%s_seq" | |
["autofree"]=> | |
bool(false) | |
["portability"]=> | |
int(0) | |
["optimize"]=> | |
string(11) "performance" | |
} | |
["last_parameters"]=> | |
array(0) { | |
} | |
["prepare_tokens"]=> | |
array(0) { | |
} | |
["prepare_types"]=> | |
array(0) { | |
} | |
["prepared_queries"]=> | |
array(0) { | |
} | |
["_last_query_manip"]=> | |
bool(false) | |
["_next_query_manip"]=> | |
bool(false) | |
["_debug"]=> | |
bool(false) | |
["_default_error_mode"]=> | |
NULL | |
["_default_error_options"]=> | |
NULL | |
["_default_error_handler"]=> | |
string(0) "" | |
["_error_class"]=> | |
string(8) "DB_Error" | |
["_expected_errors"]=> | |
array(0) { | |
} | |
} | |
["type"]=> | |
string(2) "->" | |
["args"]=> | |
array(8) { | |
[0]=> | |
object(DB_pgsql)#1 (28) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["features"]=> | |
array(7) { | |
["limit"]=> | |
string(5) "alter" | |
["new_link"]=> | |
string(5) "4.3.0" | |
["numrows"]=> | |
bool(true) | |
["pconnect"]=> | |
bool(true) | |
["prepare"]=> | |
bool(false) | |
["ssl"]=> | |
bool(true) | |
["transactions"]=> | |
bool(true) | |
} | |
["errorcode_map"]=> | |
array(0) { | |
} | |
["connection"]=> | |
resource(2) of type (pgsql link) | |
["dsn"]=> | |
array(9) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["username"]=> | |
string(0) "" | |
["password"]=> | |
bool(false) | |
["protocol"]=> | |
string(3) "tcp" | |
["hostspec"]=> | |
string(0) "" | |
["port"]=> | |
bool(false) | |
["socket"]=> | |
bool(false) | |
["database"]=> | |
string(9) "nominatim" | |
} | |
["autocommit"]=> | |
bool(true) | |
["transaction_opcount"]=> | |
int(0) | |
["affected"]=> | |
int(0) | |
["row"]=> | |
array(0) { | |
} | |
["_num_rows"]=> | |
array(0) { | |
} | |
["fetchmode"]=> | |
int(2) | |
["fetchmode_object_class"]=> | |
string(8) "stdClass" | |
["was_connected"]=> | |
NULL | |
["last_query"]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
["options"]=> | |
array(8) { | |
["result_buffering"]=> | |
int(500) | |
["persistent"]=> | |
bool(false) | |
["ssl"]=> | |
bool(false) | |
["debug"]=> | |
int(0) | |
["seqname_format"]=> | |
string(6) "%s_seq" | |
["autofree"]=> | |
bool(false) | |
["portability"]=> | |
int(0) | |
["optimize"]=> | |
string(11) "performance" | |
} | |
["last_parameters"]=> | |
array(0) { | |
} | |
["prepare_tokens"]=> | |
array(0) { | |
} | |
["prepare_types"]=> | |
array(0) { | |
} | |
["prepared_queries"]=> | |
array(0) { | |
} | |
["_last_query_manip"]=> | |
bool(false) | |
["_next_query_manip"]=> | |
bool(false) | |
["_debug"]=> | |
bool(false) | |
["_default_error_mode"]=> | |
NULL | |
["_default_error_options"]=> | |
NULL | |
["_default_error_handler"]=> | |
string(0) "" | |
["_error_class"]=> | |
string(8) "DB_Error" | |
["_expected_errors"]=> | |
array(0) { | |
} | |
} | |
[1]=> | |
NULL | |
[2]=> | |
int(-1) | |
[3]=> | |
int(1) | |
[4]=> | |
int(1024) | |
[5]=> | |
string(284) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20 [nativecode=ERROR: canceling statement due to statement timeout]" | |
[6]=> | |
string(8) "DB_Error" | |
[7]=> | |
bool(true) | |
} | |
} | |
[3]=> | |
array(7) { | |
["file"]=> | |
string(28) "/usr/share/php/DB/common.php" | |
["line"]=> | |
int(1907) | |
["function"]=> | |
string(6) "__call" | |
["class"]=> | |
string(4) "PEAR" | |
["object"]=> | |
object(DB_pgsql)#1 (28) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["features"]=> | |
array(7) { | |
["limit"]=> | |
string(5) "alter" | |
["new_link"]=> | |
string(5) "4.3.0" | |
["numrows"]=> | |
bool(true) | |
["pconnect"]=> | |
bool(true) | |
["prepare"]=> | |
bool(false) | |
["ssl"]=> | |
bool(true) | |
["transactions"]=> | |
bool(true) | |
} | |
["errorcode_map"]=> | |
array(0) { | |
} | |
["connection"]=> | |
resource(2) of type (pgsql link) | |
["dsn"]=> | |
array(9) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["username"]=> | |
string(0) "" | |
["password"]=> | |
bool(false) | |
["protocol"]=> | |
string(3) "tcp" | |
["hostspec"]=> | |
string(0) "" | |
["port"]=> | |
bool(false) | |
["socket"]=> | |
bool(false) | |
["database"]=> | |
string(9) "nominatim" | |
} | |
["autocommit"]=> | |
bool(true) | |
["transaction_opcount"]=> | |
int(0) | |
["affected"]=> | |
int(0) | |
["row"]=> | |
array(0) { | |
} | |
["_num_rows"]=> | |
array(0) { | |
} | |
["fetchmode"]=> | |
int(2) | |
["fetchmode_object_class"]=> | |
string(8) "stdClass" | |
["was_connected"]=> | |
NULL | |
["last_query"]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
["options"]=> | |
array(8) { | |
["result_buffering"]=> | |
int(500) | |
["persistent"]=> | |
bool(false) | |
["ssl"]=> | |
bool(false) | |
["debug"]=> | |
int(0) | |
["seqname_format"]=> | |
string(6) "%s_seq" | |
["autofree"]=> | |
bool(false) | |
["portability"]=> | |
int(0) | |
["optimize"]=> | |
string(11) "performance" | |
} | |
["last_parameters"]=> | |
array(0) { | |
} | |
["prepare_tokens"]=> | |
array(0) { | |
} | |
["prepare_types"]=> | |
array(0) { | |
} | |
["prepared_queries"]=> | |
array(0) { | |
} | |
["_last_query_manip"]=> | |
bool(false) | |
["_next_query_manip"]=> | |
bool(false) | |
["_debug"]=> | |
bool(false) | |
["_default_error_mode"]=> | |
NULL | |
["_default_error_options"]=> | |
NULL | |
["_default_error_handler"]=> | |
string(0) "" | |
["_error_class"]=> | |
string(8) "DB_Error" | |
["_expected_errors"]=> | |
array(0) { | |
} | |
} | |
["type"]=> | |
string(2) "->" | |
["args"]=> | |
array(2) { | |
[0]=> | |
string(10) "raiseError" | |
[1]=> | |
array(7) { | |
[0]=> | |
NULL | |
[1]=> | |
int(-1) | |
[2]=> | |
NULL | |
[3]=> | |
NULL | |
[4]=> | |
string(284) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20 [nativecode=ERROR: canceling statement due to statement timeout]" | |
[5]=> | |
string(8) "DB_Error" | |
[6]=> | |
bool(true) | |
} | |
} | |
} | |
[4]=> | |
array(7) { | |
["file"]=> | |
string(27) "/usr/share/php/DB/pgsql.php" | |
["line"]=> | |
int(778) | |
["function"]=> | |
string(10) "raiseError" | |
["class"]=> | |
string(9) "DB_common" | |
["object"]=> | |
object(DB_pgsql)#1 (28) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["features"]=> | |
array(7) { | |
["limit"]=> | |
string(5) "alter" | |
["new_link"]=> | |
string(5) "4.3.0" | |
["numrows"]=> | |
bool(true) | |
["pconnect"]=> | |
bool(true) | |
["prepare"]=> | |
bool(false) | |
["ssl"]=> | |
bool(true) | |
["transactions"]=> | |
bool(true) | |
} | |
["errorcode_map"]=> | |
array(0) { | |
} | |
["connection"]=> | |
resource(2) of type (pgsql link) | |
["dsn"]=> | |
array(9) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["username"]=> | |
string(0) "" | |
["password"]=> | |
bool(false) | |
["protocol"]=> | |
string(3) "tcp" | |
["hostspec"]=> | |
string(0) "" | |
["port"]=> | |
bool(false) | |
["socket"]=> | |
bool(false) | |
["database"]=> | |
string(9) "nominatim" | |
} | |
["autocommit"]=> | |
bool(true) | |
["transaction_opcount"]=> | |
int(0) | |
["affected"]=> | |
int(0) | |
["row"]=> | |
array(0) { | |
} | |
["_num_rows"]=> | |
array(0) { | |
} | |
["fetchmode"]=> | |
int(2) | |
["fetchmode_object_class"]=> | |
string(8) "stdClass" | |
["was_connected"]=> | |
NULL | |
["last_query"]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
["options"]=> | |
array(8) { | |
["result_buffering"]=> | |
int(500) | |
["persistent"]=> | |
bool(false) | |
["ssl"]=> | |
bool(false) | |
["debug"]=> | |
int(0) | |
["seqname_format"]=> | |
string(6) "%s_seq" | |
["autofree"]=> | |
bool(false) | |
["portability"]=> | |
int(0) | |
["optimize"]=> | |
string(11) "performance" | |
} | |
["last_parameters"]=> | |
array(0) { | |
} | |
["prepare_tokens"]=> | |
array(0) { | |
} | |
["prepare_types"]=> | |
array(0) { | |
} | |
["prepared_queries"]=> | |
array(0) { | |
} | |
["_last_query_manip"]=> | |
bool(false) | |
["_next_query_manip"]=> | |
bool(false) | |
["_debug"]=> | |
bool(false) | |
["_default_error_mode"]=> | |
NULL | |
["_default_error_options"]=> | |
NULL | |
["_default_error_handler"]=> | |
string(0) "" | |
["_error_class"]=> | |
string(8) "DB_Error" | |
["_expected_errors"]=> | |
array(0) { | |
} | |
} | |
["type"]=> | |
string(2) "->" | |
["args"]=> | |
array(5) { | |
[0]=> | |
int(-1) | |
[1]=> | |
NULL | |
[2]=> | |
NULL | |
[3]=> | |
string(284) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20 [nativecode=ERROR: canceling statement due to statement timeout]" | |
[4]=> | |
string(52) "ERROR: canceling statement due to statement timeout" | |
} | |
} | |
[5]=> | |
array(7) { | |
["file"]=> | |
string(27) "/usr/share/php/DB/pgsql.php" | |
["line"]=> | |
int(337) | |
["function"]=> | |
string(15) "pgsqlRaiseError" | |
["class"]=> | |
string(8) "DB_pgsql" | |
["object"]=> | |
object(DB_pgsql)#1 (28) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["features"]=> | |
array(7) { | |
["limit"]=> | |
string(5) "alter" | |
["new_link"]=> | |
string(5) "4.3.0" | |
["numrows"]=> | |
bool(true) | |
["pconnect"]=> | |
bool(true) | |
["prepare"]=> | |
bool(false) | |
["ssl"]=> | |
bool(true) | |
["transactions"]=> | |
bool(true) | |
} | |
["errorcode_map"]=> | |
array(0) { | |
} | |
["connection"]=> | |
resource(2) of type (pgsql link) | |
["dsn"]=> | |
array(9) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["username"]=> | |
string(0) "" | |
["password"]=> | |
bool(false) | |
["protocol"]=> | |
string(3) "tcp" | |
["hostspec"]=> | |
string(0) "" | |
["port"]=> | |
bool(false) | |
["socket"]=> | |
bool(false) | |
["database"]=> | |
string(9) "nominatim" | |
} | |
["autocommit"]=> | |
bool(true) | |
["transaction_opcount"]=> | |
int(0) | |
["affected"]=> | |
int(0) | |
["row"]=> | |
array(0) { | |
} | |
["_num_rows"]=> | |
array(0) { | |
} | |
["fetchmode"]=> | |
int(2) | |
["fetchmode_object_class"]=> | |
string(8) "stdClass" | |
["was_connected"]=> | |
NULL | |
["last_query"]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
["options"]=> | |
array(8) { | |
["result_buffering"]=> | |
int(500) | |
["persistent"]=> | |
bool(false) | |
["ssl"]=> | |
bool(false) | |
["debug"]=> | |
int(0) | |
["seqname_format"]=> | |
string(6) "%s_seq" | |
["autofree"]=> | |
bool(false) | |
["portability"]=> | |
int(0) | |
["optimize"]=> | |
string(11) "performance" | |
} | |
["last_parameters"]=> | |
array(0) { | |
} | |
["prepare_tokens"]=> | |
array(0) { | |
} | |
["prepare_types"]=> | |
array(0) { | |
} | |
["prepared_queries"]=> | |
array(0) { | |
} | |
["_last_query_manip"]=> | |
bool(false) | |
["_next_query_manip"]=> | |
bool(false) | |
["_debug"]=> | |
bool(false) | |
["_default_error_mode"]=> | |
NULL | |
["_default_error_options"]=> | |
NULL | |
["_default_error_handler"]=> | |
string(0) "" | |
["_error_class"]=> | |
string(8) "DB_Error" | |
["_expected_errors"]=> | |
array(0) { | |
} | |
} | |
["type"]=> | |
string(2) "->" | |
["args"]=> | |
array(0) { | |
} | |
} | |
[6]=> | |
array(7) { | |
["file"]=> | |
string(28) "/usr/share/php/DB/common.php" | |
["line"]=> | |
int(1215) | |
["function"]=> | |
string(11) "simpleQuery" | |
["class"]=> | |
string(8) "DB_pgsql" | |
["object"]=> | |
object(DB_pgsql)#1 (28) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["features"]=> | |
array(7) { | |
["limit"]=> | |
string(5) "alter" | |
["new_link"]=> | |
string(5) "4.3.0" | |
["numrows"]=> | |
bool(true) | |
["pconnect"]=> | |
bool(true) | |
["prepare"]=> | |
bool(false) | |
["ssl"]=> | |
bool(true) | |
["transactions"]=> | |
bool(true) | |
} | |
["errorcode_map"]=> | |
array(0) { | |
} | |
["connection"]=> | |
resource(2) of type (pgsql link) | |
["dsn"]=> | |
array(9) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["username"]=> | |
string(0) "" | |
["password"]=> | |
bool(false) | |
["protocol"]=> | |
string(3) "tcp" | |
["hostspec"]=> | |
string(0) "" | |
["port"]=> | |
bool(false) | |
["socket"]=> | |
bool(false) | |
["database"]=> | |
string(9) "nominatim" | |
} | |
["autocommit"]=> | |
bool(true) | |
["transaction_opcount"]=> | |
int(0) | |
["affected"]=> | |
int(0) | |
["row"]=> | |
array(0) { | |
} | |
["_num_rows"]=> | |
array(0) { | |
} | |
["fetchmode"]=> | |
int(2) | |
["fetchmode_object_class"]=> | |
string(8) "stdClass" | |
["was_connected"]=> | |
NULL | |
["last_query"]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
["options"]=> | |
array(8) { | |
["result_buffering"]=> | |
int(500) | |
["persistent"]=> | |
bool(false) | |
["ssl"]=> | |
bool(false) | |
["debug"]=> | |
int(0) | |
["seqname_format"]=> | |
string(6) "%s_seq" | |
["autofree"]=> | |
bool(false) | |
["portability"]=> | |
int(0) | |
["optimize"]=> | |
string(11) "performance" | |
} | |
["last_parameters"]=> | |
array(0) { | |
} | |
["prepare_tokens"]=> | |
array(0) { | |
} | |
["prepare_types"]=> | |
array(0) { | |
} | |
["prepared_queries"]=> | |
array(0) { | |
} | |
["_last_query_manip"]=> | |
bool(false) | |
["_next_query_manip"]=> | |
bool(false) | |
["_debug"]=> | |
bool(false) | |
["_default_error_mode"]=> | |
NULL | |
["_default_error_options"]=> | |
NULL | |
["_default_error_handler"]=> | |
string(0) "" | |
["_error_class"]=> | |
string(8) "DB_Error" | |
["_expected_errors"]=> | |
array(0) { | |
} | |
} | |
["type"]=> | |
string(2) "->" | |
["args"]=> | |
array(1) { | |
[0]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
} | |
} | |
[7]=> | |
array(7) { | |
["file"]=> | |
string(28) "/usr/share/php/DB/common.php" | |
["line"]=> | |
int(1662) | |
["function"]=> | |
string(5) "query" | |
["class"]=> | |
string(9) "DB_common" | |
["object"]=> | |
object(DB_pgsql)#1 (28) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["features"]=> | |
array(7) { | |
["limit"]=> | |
string(5) "alter" | |
["new_link"]=> | |
string(5) "4.3.0" | |
["numrows"]=> | |
bool(true) | |
["pconnect"]=> | |
bool(true) | |
["prepare"]=> | |
bool(false) | |
["ssl"]=> | |
bool(true) | |
["transactions"]=> | |
bool(true) | |
} | |
["errorcode_map"]=> | |
array(0) { | |
} | |
["connection"]=> | |
resource(2) of type (pgsql link) | |
["dsn"]=> | |
array(9) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["username"]=> | |
string(0) "" | |
["password"]=> | |
bool(false) | |
["protocol"]=> | |
string(3) "tcp" | |
["hostspec"]=> | |
string(0) "" | |
["port"]=> | |
bool(false) | |
["socket"]=> | |
bool(false) | |
["database"]=> | |
string(9) "nominatim" | |
} | |
["autocommit"]=> | |
bool(true) | |
["transaction_opcount"]=> | |
int(0) | |
["affected"]=> | |
int(0) | |
["row"]=> | |
array(0) { | |
} | |
["_num_rows"]=> | |
array(0) { | |
} | |
["fetchmode"]=> | |
int(2) | |
["fetchmode_object_class"]=> | |
string(8) "stdClass" | |
["was_connected"]=> | |
NULL | |
["last_query"]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
["options"]=> | |
array(8) { | |
["result_buffering"]=> | |
int(500) | |
["persistent"]=> | |
bool(false) | |
["ssl"]=> | |
bool(false) | |
["debug"]=> | |
int(0) | |
["seqname_format"]=> | |
string(6) "%s_seq" | |
["autofree"]=> | |
bool(false) | |
["portability"]=> | |
int(0) | |
["optimize"]=> | |
string(11) "performance" | |
} | |
["last_parameters"]=> | |
array(0) { | |
} | |
["prepare_tokens"]=> | |
array(0) { | |
} | |
["prepare_types"]=> | |
array(0) { | |
} | |
["prepared_queries"]=> | |
array(0) { | |
} | |
["_last_query_manip"]=> | |
bool(false) | |
["_next_query_manip"]=> | |
bool(false) | |
["_debug"]=> | |
bool(false) | |
["_default_error_mode"]=> | |
NULL | |
["_default_error_options"]=> | |
NULL | |
["_default_error_handler"]=> | |
string(0) "" | |
["_error_class"]=> | |
string(8) "DB_Error" | |
["_expected_errors"]=> | |
array(0) { | |
} | |
} | |
["type"]=> | |
string(2) "->" | |
["args"]=> | |
array(1) { | |
[0]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
} | |
} | |
[8]=> | |
array(7) { | |
["file"]=> | |
string(50) "/srv/nominatim/Nominatim/lib/SearchDescription.php" | |
["line"]=> | |
int(706) | |
["function"]=> | |
string(6) "getAll" | |
["class"]=> | |
string(9) "DB_common" | |
["object"]=> | |
object(DB_pgsql)#1 (28) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["features"]=> | |
array(7) { | |
["limit"]=> | |
string(5) "alter" | |
["new_link"]=> | |
string(5) "4.3.0" | |
["numrows"]=> | |
bool(true) | |
["pconnect"]=> | |
bool(true) | |
["prepare"]=> | |
bool(false) | |
["ssl"]=> | |
bool(true) | |
["transactions"]=> | |
bool(true) | |
} | |
["errorcode_map"]=> | |
array(0) { | |
} | |
["connection"]=> | |
resource(2) of type (pgsql link) | |
["dsn"]=> | |
array(9) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["username"]=> | |
string(0) "" | |
["password"]=> | |
bool(false) | |
["protocol"]=> | |
string(3) "tcp" | |
["hostspec"]=> | |
string(0) "" | |
["port"]=> | |
bool(false) | |
["socket"]=> | |
bool(false) | |
["database"]=> | |
string(9) "nominatim" | |
} | |
["autocommit"]=> | |
bool(true) | |
["transaction_opcount"]=> | |
int(0) | |
["affected"]=> | |
int(0) | |
["row"]=> | |
array(0) { | |
} | |
["_num_rows"]=> | |
array(0) { | |
} | |
["fetchmode"]=> | |
int(2) | |
["fetchmode_object_class"]=> | |
string(8) "stdClass" | |
["was_connected"]=> | |
NULL | |
["last_query"]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
["options"]=> | |
array(8) { | |
["result_buffering"]=> | |
int(500) | |
["persistent"]=> | |
bool(false) | |
["ssl"]=> | |
bool(false) | |
["debug"]=> | |
int(0) | |
["seqname_format"]=> | |
string(6) "%s_seq" | |
["autofree"]=> | |
bool(false) | |
["portability"]=> | |
int(0) | |
["optimize"]=> | |
string(11) "performance" | |
} | |
["last_parameters"]=> | |
array(0) { | |
} | |
["prepare_tokens"]=> | |
array(0) { | |
} | |
["prepare_types"]=> | |
array(0) { | |
} | |
["prepared_queries"]=> | |
array(0) { | |
} | |
["_last_query_manip"]=> | |
bool(false) | |
["_next_query_manip"]=> | |
bool(false) | |
["_debug"]=> | |
bool(false) | |
["_default_error_mode"]=> | |
NULL | |
["_default_error_options"]=> | |
NULL | |
["_default_error_handler"]=> | |
string(0) "" | |
["_error_class"]=> | |
string(8) "DB_Error" | |
["_expected_errors"]=> | |
array(0) { | |
} | |
} | |
["type"]=> | |
string(2) "->" | |
["args"]=> | |
array(1) { | |
[0]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
} | |
} | |
[9]=> | |
array(7) { | |
["file"]=> | |
string(50) "/srv/nominatim/Nominatim/lib/SearchDescription.php" | |
["line"]=> | |
int(433) | |
["function"]=> | |
string(15) "queryNamedPlace" | |
["class"]=> | |
string(27) "Nominatim\SearchDescription" | |
["object"]=> | |
object(Nominatim\SearchDescription)#12 (14) { | |
["iSearchRank":"Nominatim\SearchDescription":private]=> | |
int(1) | |
["sCountryCode":"Nominatim\SearchDescription":private]=> | |
string(0) "" | |
["aName":"Nominatim\SearchDescription":private]=> | |
array(1) { | |
[5639492]=> | |
string(7) "5639492" | |
} | |
["aAddress":"Nominatim\SearchDescription":private]=> | |
array(0) { | |
} | |
["aFullNameAddress":"Nominatim\SearchDescription":private]=> | |
array(0) { | |
} | |
["aNameNonSearch":"Nominatim\SearchDescription":private]=> | |
array(0) { | |
} | |
["aAddressNonSearch":"Nominatim\SearchDescription":private]=> | |
array(0) { | |
} | |
["iOperator":"Nominatim\SearchDescription":private]=> | |
int(0) | |
["sClass":"Nominatim\SearchDescription":private]=> | |
string(0) "" | |
["sType":"Nominatim\SearchDescription":private]=> | |
string(0) "" | |
["sHouseNumber":"Nominatim\SearchDescription":private]=> | |
string(0) "" | |
["sPostcode":"Nominatim\SearchDescription":private]=> | |
string(0) "" | |
["oContext":"Nominatim\SearchDescription":private]=> | |
object(Nominatim\SearchContext)#6 (8) { | |
["fNearRadius":"Nominatim\SearchContext":private]=> | |
bool(false) | |
["bViewboxBounded"]=> | |
bool(false) | |
["sqlNear"]=> | |
string(0) "" | |
["sqlViewboxSmall"]=> | |
string(0) "" | |
["sqlViewboxLarge"]=> | |
string(0) "" | |
["sqlViewboxCentre"]=> | |
string(0) "" | |
["sqlCountryList"]=> | |
string(0) "" | |
["sqlExcludeList":"Nominatim\SearchContext":private]=> | |
string(0) "" | |
} | |
["iNamePhrase":"Nominatim\SearchDescription":private]=> | |
int(-1) | |
} | |
["type"]=> | |
string(2) "->" | |
["args"]=> | |
array(5) { | |
[0]=> | |
&object(DB_pgsql)#1 (28) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["features"]=> | |
array(7) { | |
["limit"]=> | |
string(5) "alter" | |
["new_link"]=> | |
string(5) "4.3.0" | |
["numrows"]=> | |
bool(true) | |
["pconnect"]=> | |
bool(true) | |
["prepare"]=> | |
bool(false) | |
["ssl"]=> | |
bool(true) | |
["transactions"]=> | |
bool(true) | |
} | |
["errorcode_map"]=> | |
array(0) { | |
} | |
["connection"]=> | |
resource(2) of type (pgsql link) | |
["dsn"]=> | |
array(9) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["username"]=> | |
string(0) "" | |
["password"]=> | |
bool(false) | |
["protocol"]=> | |
string(3) "tcp" | |
["hostspec"]=> | |
string(0) "" | |
["port"]=> | |
bool(false) | |
["socket"]=> | |
bool(false) | |
["database"]=> | |
string(9) "nominatim" | |
} | |
["autocommit"]=> | |
bool(true) | |
["transaction_opcount"]=> | |
int(0) | |
["affected"]=> | |
int(0) | |
["row"]=> | |
array(0) { | |
} | |
["_num_rows"]=> | |
array(0) { | |
} | |
["fetchmode"]=> | |
int(2) | |
["fetchmode_object_class"]=> | |
string(8) "stdClass" | |
["was_connected"]=> | |
NULL | |
["last_query"]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
["options"]=> | |
array(8) { | |
["result_buffering"]=> | |
int(500) | |
["persistent"]=> | |
bool(false) | |
["ssl"]=> | |
bool(false) | |
["debug"]=> | |
int(0) | |
["seqname_format"]=> | |
string(6) "%s_seq" | |
["autofree"]=> | |
bool(false) | |
["portability"]=> | |
int(0) | |
["optimize"]=> | |
string(11) "performance" | |
} | |
["last_parameters"]=> | |
array(0) { | |
} | |
["prepare_tokens"]=> | |
array(0) { | |
} | |
["prepare_types"]=> | |
array(0) { | |
} | |
["prepared_queries"]=> | |
array(0) { | |
} | |
["_last_query_manip"]=> | |
bool(false) | |
["_next_query_manip"]=> | |
bool(false) | |
["_debug"]=> | |
bool(false) | |
["_default_error_mode"]=> | |
NULL | |
["_default_error_options"]=> | |
NULL | |
["_default_error_handler"]=> | |
string(0) "" | |
["_error_class"]=> | |
string(8) "DB_Error" | |
["_expected_errors"]=> | |
array(0) { | |
} | |
} | |
[1]=> | |
array(6) { | |
[5526257]=> | |
int(1) | |
[5639492]=> | |
int(1) | |
[8232680]=> | |
int(1) | |
[4020]=> | |
int(73341) | |
[626072]=> | |
int(1) | |
[498]=> | |
int(16527) | |
} | |
[2]=> | |
int(0) | |
[3]=> | |
int(30) | |
[4]=> | |
int(20) | |
} | |
} | |
[10]=> | |
array(7) { | |
["file"]=> | |
string(40) "/srv/nominatim/Nominatim/lib/Geocode.php" | |
["line"]=> | |
int(787) | |
["function"]=> | |
string(5) "query" | |
["class"]=> | |
string(27) "Nominatim\SearchDescription" | |
["object"]=> | |
object(Nominatim\SearchDescription)#12 (14) { | |
["iSearchRank":"Nominatim\SearchDescription":private]=> | |
int(1) | |
["sCountryCode":"Nominatim\SearchDescription":private]=> | |
string(0) "" | |
["aName":"Nominatim\SearchDescription":private]=> | |
array(1) { | |
[5639492]=> | |
string(7) "5639492" | |
} | |
["aAddress":"Nominatim\SearchDescription":private]=> | |
array(0) { | |
} | |
["aFullNameAddress":"Nominatim\SearchDescription":private]=> | |
array(0) { | |
} | |
["aNameNonSearch":"Nominatim\SearchDescription":private]=> | |
array(0) { | |
} | |
["aAddressNonSearch":"Nominatim\SearchDescription":private]=> | |
array(0) { | |
} | |
["iOperator":"Nominatim\SearchDescription":private]=> | |
int(0) | |
["sClass":"Nominatim\SearchDescription":private]=> | |
string(0) "" | |
["sType":"Nominatim\SearchDescription":private]=> | |
string(0) "" | |
["sHouseNumber":"Nominatim\SearchDescription":private]=> | |
string(0) "" | |
["sPostcode":"Nominatim\SearchDescription":private]=> | |
string(0) "" | |
["oContext":"Nominatim\SearchDescription":private]=> | |
object(Nominatim\SearchContext)#6 (8) { | |
["fNearRadius":"Nominatim\SearchContext":private]=> | |
bool(false) | |
["bViewboxBounded"]=> | |
bool(false) | |
["sqlNear"]=> | |
string(0) "" | |
["sqlViewboxSmall"]=> | |
string(0) "" | |
["sqlViewboxLarge"]=> | |
string(0) "" | |
["sqlViewboxCentre"]=> | |
string(0) "" | |
["sqlCountryList"]=> | |
string(0) "" | |
["sqlExcludeList":"Nominatim\SearchContext":private]=> | |
string(0) "" | |
} | |
["iNamePhrase":"Nominatim\SearchDescription":private]=> | |
int(-1) | |
} | |
["type"]=> | |
string(2) "->" | |
["args"]=> | |
array(5) { | |
[0]=> | |
&object(DB_pgsql)#1 (28) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["features"]=> | |
array(7) { | |
["limit"]=> | |
string(5) "alter" | |
["new_link"]=> | |
string(5) "4.3.0" | |
["numrows"]=> | |
bool(true) | |
["pconnect"]=> | |
bool(true) | |
["prepare"]=> | |
bool(false) | |
["ssl"]=> | |
bool(true) | |
["transactions"]=> | |
bool(true) | |
} | |
["errorcode_map"]=> | |
array(0) { | |
} | |
["connection"]=> | |
resource(2) of type (pgsql link) | |
["dsn"]=> | |
array(9) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["username"]=> | |
string(0) "" | |
["password"]=> | |
bool(false) | |
["protocol"]=> | |
string(3) "tcp" | |
["hostspec"]=> | |
string(0) "" | |
["port"]=> | |
bool(false) | |
["socket"]=> | |
bool(false) | |
["database"]=> | |
string(9) "nominatim" | |
} | |
["autocommit"]=> | |
bool(true) | |
["transaction_opcount"]=> | |
int(0) | |
["affected"]=> | |
int(0) | |
["row"]=> | |
array(0) { | |
} | |
["_num_rows"]=> | |
array(0) { | |
} | |
["fetchmode"]=> | |
int(2) | |
["fetchmode_object_class"]=> | |
string(8) "stdClass" | |
["was_connected"]=> | |
NULL | |
["last_query"]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
["options"]=> | |
array(8) { | |
["result_buffering"]=> | |
int(500) | |
["persistent"]=> | |
bool(false) | |
["ssl"]=> | |
bool(false) | |
["debug"]=> | |
int(0) | |
["seqname_format"]=> | |
string(6) "%s_seq" | |
["autofree"]=> | |
bool(false) | |
["portability"]=> | |
int(0) | |
["optimize"]=> | |
string(11) "performance" | |
} | |
["last_parameters"]=> | |
array(0) { | |
} | |
["prepare_tokens"]=> | |
array(0) { | |
} | |
["prepare_types"]=> | |
array(0) { | |
} | |
["prepared_queries"]=> | |
array(0) { | |
} | |
["_last_query_manip"]=> | |
bool(false) | |
["_next_query_manip"]=> | |
bool(false) | |
["_debug"]=> | |
bool(false) | |
["_default_error_mode"]=> | |
NULL | |
["_default_error_options"]=> | |
NULL | |
["_default_error_handler"]=> | |
string(0) "" | |
["_error_class"]=> | |
string(8) "DB_Error" | |
["_expected_errors"]=> | |
array(0) { | |
} | |
} | |
[1]=> | |
&array(6) { | |
[5526257]=> | |
int(1) | |
[5639492]=> | |
int(1) | |
[8232680]=> | |
int(1) | |
[4020]=> | |
int(73341) | |
[626072]=> | |
int(1) | |
[498]=> | |
int(16527) | |
} | |
[2]=> | |
int(0) | |
[3]=> | |
int(30) | |
[4]=> | |
int(20) | |
} | |
} | |
[11]=> | |
array(7) { | |
["file"]=> | |
string(49) "/srv/nominatim/Nominatim/build/website/search.php" | |
["line"]=> | |
int(66) | |
["function"]=> | |
string(6) "lookup" | |
["class"]=> | |
string(17) "Nominatim\Geocode" | |
["object"]=> | |
object(Nominatim\Geocode)#3 (23) { | |
["oDB":protected]=> | |
&object(DB_pgsql)#1 (28) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["features"]=> | |
array(7) { | |
["limit"]=> | |
string(5) "alter" | |
["new_link"]=> | |
string(5) "4.3.0" | |
["numrows"]=> | |
bool(true) | |
["pconnect"]=> | |
bool(true) | |
["prepare"]=> | |
bool(false) | |
["ssl"]=> | |
bool(true) | |
["transactions"]=> | |
bool(true) | |
} | |
["errorcode_map"]=> | |
array(0) { | |
} | |
["connection"]=> | |
resource(2) of type (pgsql link) | |
["dsn"]=> | |
array(9) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["username"]=> | |
string(0) "" | |
["password"]=> | |
bool(false) | |
["protocol"]=> | |
string(3) "tcp" | |
["hostspec"]=> | |
string(0) "" | |
["port"]=> | |
bool(false) | |
["socket"]=> | |
bool(false) | |
["database"]=> | |
string(9) "nominatim" | |
} | |
["autocommit"]=> | |
bool(true) | |
["transaction_opcount"]=> | |
int(0) | |
["affected"]=> | |
int(0) | |
["row"]=> | |
array(0) { | |
} | |
["_num_rows"]=> | |
array(0) { | |
} | |
["fetchmode"]=> | |
int(2) | |
["fetchmode_object_class"]=> | |
string(8) "stdClass" | |
["was_connected"]=> | |
NULL | |
["last_query"]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
["options"]=> | |
array(8) { | |
["result_buffering"]=> | |
int(500) | |
["persistent"]=> | |
bool(false) | |
["ssl"]=> | |
bool(false) | |
["debug"]=> | |
int(0) | |
["seqname_format"]=> | |
string(6) "%s_seq" | |
["autofree"]=> | |
bool(false) | |
["portability"]=> | |
int(0) | |
["optimize"]=> | |
string(11) "performance" | |
} | |
["last_parameters"]=> | |
array(0) { | |
} | |
["prepare_tokens"]=> | |
array(0) { | |
} | |
["prepare_types"]=> | |
array(0) { | |
} | |
["prepared_queries"]=> | |
array(0) { | |
} | |
["_last_query_manip"]=> | |
bool(false) | |
["_next_query_manip"]=> | |
bool(false) | |
["_debug"]=> | |
bool(false) | |
["_default_error_mode"]=> | |
NULL | |
["_default_error_options"]=> | |
NULL | |
["_default_error_handler"]=> | |
string(0) "" | |
["_error_class"]=> | |
string(8) "DB_Error" | |
["_expected_errors"]=> | |
array(0) { | |
} | |
} | |
["oPlaceLookup":protected]=> | |
object(Nominatim\PlaceLookup)#4 (15) { | |
["oDB":protected]=> | |
&object(DB_pgsql)#1 (28) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["features"]=> | |
array(7) { | |
["limit"]=> | |
string(5) "alter" | |
["new_link"]=> | |
string(5) "4.3.0" | |
["numrows"]=> | |
bool(true) | |
["pconnect"]=> | |
bool(true) | |
["prepare"]=> | |
bool(false) | |
["ssl"]=> | |
bool(true) | |
["transactions"]=> | |
bool(true) | |
} | |
["errorcode_map"]=> | |
array(0) { | |
} | |
["connection"]=> | |
resource(2) of type (pgsql link) | |
["dsn"]=> | |
array(9) { | |
["phptype"]=> | |
string(5) "pgsql" | |
["dbsyntax"]=> | |
string(5) "pgsql" | |
["username"]=> | |
string(0) "" | |
["password"]=> | |
bool(false) | |
["protocol"]=> | |
string(3) "tcp" | |
["hostspec"]=> | |
string(0) "" | |
["port"]=> | |
bool(false) | |
["socket"]=> | |
bool(false) | |
["database"]=> | |
string(9) "nominatim" | |
} | |
["autocommit"]=> | |
bool(true) | |
["transaction_opcount"]=> | |
int(0) | |
["affected"]=> | |
int(0) | |
["row"]=> | |
array(0) { | |
} | |
["_num_rows"]=> | |
array(0) { | |
} | |
["fetchmode"]=> | |
int(2) | |
["fetchmode_object_class"]=> | |
string(8) "stdClass" | |
["was_connected"]=> | |
NULL | |
["last_query"]=> | |
string(218) "SELECT place_id,0::int as exactmatch FROM search_name WHERE name_vector @> ARRAY[5639492] ORDER BY (CASE WHEN importance = 0 OR importance IS NULL THEN 0.75001-(search_rank::float/40) ELSE importance END) DESC LIMIT 20" | |
["options"]=> | |
array(8) { | |
["result_buffering"]=> | |
int(500) | |
["persistent"]=> | |
bool(false) | |
["ssl"]=> | |
bool(false) | |
["debug"]=> | |
int(0) | |
["seqname_format"]=> | |
string(6) "%s_seq" | |
["autofree"]=> | |
bool(false) | |
["portability"]=> | |
int(0) | |
["optimize"]=> | |
string(11) "performance" | |
} | |
["last_parameters"]=> | |
array(0) { | |
} | |
["prepare_tokens"]=> | |
array(0) { | |
} | |
["prepare_types"]=> | |
array(0) { | |
} | |
["prepared_queries"]=> | |
array(0) { | |
} | |
["_last_query_manip"]=> | |
bool(false) | |
["_next_query_manip"]=> | |
bool(false) | |
["_debug"]=> | |
bool(false) | |
["_default_error_mode"]=> | |
NULL | |
["_default_error_options"]=> | |
NULL | |
["_default_error_handler"]=> | |
string(0) "" | |
["_error_class"]=> | |
string(8) "DB_Error" | |
["_expected_errors"]=> | |
array(0) { | |
} | |
} | |
["aLangPrefOrderSql":protected]=> | |
string(162) "ARRAY['short_name:en-US','name:en-US','short_name:en','name:en','short_name','name','brand','official_name:en-US','official_name:en','official_name','ref','type']" | |
["bAddressDetails":protected]=> | |
bool(false) | |
["bExtraTags":protected]=> | |
bool(false) | |
["bNameDetails":protected]=> | |
bool(false) | |
["bIncludePolygonAsPoints":protected]=> | |
bool(false) | |
["bIncludePolygonAsText":protected]=> | |
bool(false) | |
["bIncludePolygonAsGeoJSON":protected]=> | |
bool(true) | |
["bIncludePolygonAsKML":protected]=> | |
bool(false) | |
["bIncludePolygonAsSVG":protected]=> | |
bool(false) | |
["fPolygonSimplificationThreshold":protected]=> | |
float(0) | |
["sAnchorSql":protected]=> | |
NULL | |
["sAddressRankListSql":protected]=> | |
NULL | |
["sAllowedTypesSQLList":protected]=> | |
NULL | |
["bDeDupe":protected]=> | |
bool(true) | |
} | |
["aLangPrefOrder":protected]=> | |
array(12) { | |
["short_name:en-US"]=> | |
string(16) "short_name:en-US" | |
["name:en-US"]=> | |
string(10) "name:en-US" | |
["short_name:en"]=> | |
string(13) "short_name:en" | |
["name:en"]=> | |
string(7) "name:en" | |
["short_name"]=> | |
string(10) "short_name" | |
["name"]=> | |
string(4) "name" | |
["brand"]=> | |
string(5) "brand" | |
["official_name:en-US"]=> | |
string(19) "official_name:en-US" | |
["official_name:en"]=> | |
string(16) "official_name:en" | |
["official_name"]=> | |
string(13) "official_name" | |
["ref"]=> | |
string(3) "ref" | |
["type"]=> | |
string(4) "type" | |
} | |
["bIncludeAddressDetails":protected]=> | |
bool(false) | |
["aExcludePlaceIDs":protected]=> | |
array(0) { | |
} | |
["bReverseInPlan":protected]=> | |
bool(true) | |
["iLimit":protected]=> | |
int(20) | |
["iFinalLimit":protected]=> | |
int(10) | |
["iOffset":protected]=> | |
int(0) | |
["bFallback":protected]=> | |
bool(false) | |
["aCountryCodes":protected]=> | |
bool(false) | |
["bBoundedSearch":protected]=> | |
bool(false) | |
["aViewBox":protected]=> | |
bool(false) | |
["aRoutePoints":protected]=> | |
bool(false) | |
["aRouteWidth":protected]=> | |
bool(false) | |
["iMaxRank":protected]=> | |
int(20) | |
["iMinAddressRank":protected]=> | |
int(0) | |
["iMaxAddressRank":protected]=> | |
int(30) | |
["aAddressRankList":protected]=> | |
array(0) { | |
} | |
["sAllowedTypesSQLList":protected]=> | |
bool(false) | |
["sQuery":protected]=> | |
string(8) "New York" | |
["aStructuredQuery":protected]=> | |
bool(false) | |
["oNormalizer":protected]=> | |
object(Transliterator)#5 (1) { | |
["id"]=> | |
string(13) "RulesTransPHP" | |
} | |
} | |
["type"]=> | |
string(2) "->" | |
["args"]=> | |
array(0) { | |
} | |
} | |
} | |
["callback"]=> | |
NULL | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment