Skip to content

Instantly share code, notes, and snippets.

@midhunkrishna

midhunkrishna/debug.info

Created April 25, 2018 07:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save midhunkrishna/4c399e9e6a11c65974b8c81d8abb5a0a to your computer and use it in GitHub Desktop.
Save midhunkrishna/4c399e9e6a11c65974b8c81d8abb5a0a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
debug.info
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