[Geocoding] [OpenStreetMap] #5329: Button Search can't work on Web Interface
OpenStreetMap
trac at noreply.openstreetmap.org
Thu Jul 9 10:33:42 UTC 2015
#5329: Button Search can't work on Web Interface
----------------------------------------+-------------------------------
Reporter: sylvain.ballaud.externe@… | Owner: geocoding@…
Type: defect | Status: new
Priority: blocker | Milestone:
Component: nominatim | Version:
Resolution: | Keywords: nominatim, search
----------------------------------------+-------------------------------
Comment (by sylvain.ballaud.externe@…):
I changed the php.ini with this :
{{{
date.timezone = 'Europe/Paris'
}}}
No others PHP Warning on Apache. This is the result of the query :
{{{
string(136) "select word_id,word_token, word, class, type, country_code,
operator, search_name_count from word where word_token in ('
paris','paris')" array(1) { [0]=> array(3) { ["string"]=> string(5)
"paris" ["words"]=> array(1) { [0]=> string(5) "paris" } ["wordsets"]=>
array(1) { [0]=> array(1) { [0]=> string(5) "paris" } } } } array(2) { ["
paris"]=> array(1) { [0]=> array(8) { ["word_id"]=> string(5) "39933"
["word_token"]=> string(6) " paris" ["word"]=> string(5) "paris"
["class"]=> NULL ["type"]=> NULL ["country_code"]=> NULL ["operator"]=>
NULL ["search_name_count"]=> string(1) "0" } } ["paris"]=> array(1) {
[0]=> array(8) { ["word_id"]=> string(3) "284" ["word_token"]=> string(5)
"paris" ["word"]=> NULL ["class"]=> NULL ["type"]=> NULL
["country_code"]=> NULL ["operator"]=> NULL ["search_name_count"]=>
string(4) "5685" } } } array(2) { [1]=> array(1) { [0]=> array(16) {
["iSearchRank"]=> int(1) ["iNamePhrase"]=> int(-1) ["sCountryCode"]=>
bool(false) ["aName"]=> array(1) { [39933]=> string(5) "39933" }
["aAddress"]=> array(0) { } ["aFullNameAddress"]=> array(0) { }
["aNameNonSearch"]=> array(0) { } ["aAddressNonSearch"]=> array(0) { }
["sOperator"]=> string(0) "" ["aFeatureName"]=> array(0) { } ["sClass"]=>
string(0) "" ["sType"]=> string(0) "" ["sHouseNumber"]=> string(0) ""
["fLat"]=> string(0) "" ["fLon"]=> string(0) "" ["fRadius"]=> string(0) ""
} } [2]=> array(1) { [0]=> array(16) { ["iSearchRank"]=> int(2)
["iNamePhrase"]=> int(0) ["sCountryCode"]=> bool(false) ["aName"]=>
array(1) { [284]=> string(3) "284" } ["aAddress"]=> array(0) { }
["aFullNameAddress"]=> array(0) { } ["aNameNonSearch"]=> array(0) { }
["aAddressNonSearch"]=> array(0) { } ["sOperator"]=> string(0) ""
["aFeatureName"]=> array(0) { } ["sClass"]=> string(0) "" ["sType"]=>
string(0) "" ["sHouseNumber"]=> string(0) "" ["fLat"]=> string(0) ""
["fLon"]=> string(0) "" ["fRadius"]=> string(0) "" } } }
rank Name Tokens Name Not Address Tokens Address Not
country operator class type house# Lat Lon Radius
1 # paris(39933)#
2 #paris(284)#
Search Loop, group 1, loop 1
rank Name Tokens Name Not Address Tokens Address Not
country operator class type house# Lat Lon Radius
1 # paris(39933)#
string(214) "select place_id, 0::int as exactmatch from search_name where
name_vector @> ARRAY[39933] order by (case when importance = 0 OR
importance IS NULL then 0.75-(search_rank::float/40) else importance end)
DESC limit 20"
Place IDs: array(17) { [0]=> string(6) "101375" [1]=> string(6) "854399"
[2]=> string(6) "859305" [3]=> string(6) "856181" [4]=> string(6) "156081"
[5]=> string(6) "280198" [6]=> string(6) "318451" [7]=> string(6) "378529"
[8]=> string(6) "501719" [9]=> string(6) "514761" [10]=> string(6)
"725418" [11]=> string(6) "778426" [12]=> string(6) "856293" [13]=>
string(6) "109932" [14]=> string(6) "172079" [15]=> string(6) "199487"
[16]=> string(6) "261681" } string(4643) "select
osm_type,osm_id,class,type,admin_level,rank_search,rank_address,min(place_id)
as place_id, min(parent_place_id) as parent_place_id,
calculated_country_code as country_code,get_address_by_language(place_id,
ARRAY['short_name:fr','short_name:fr-FR','short_name:en-
US','short_name:en','name:fr','name:fr-FR','name:en-
US','name:en','place_name:fr','place_name:fr-FR','place_name:en-
US','place_name:en','official_name:fr','official_name:fr-
FR','official_name:en-
US','official_name:en','short_name','name','place_name','official_name','ref','type'])
as langaddress,get_name_by_language(name,
ARRAY['short_name:fr','short_name:fr-FR','short_name:en-
US','short_name:en','name:fr','name:fr-FR','name:en-
US','name:en','place_name:fr','place_name:fr-FR','place_name:en-
US','place_name:en','official_name:fr','official_name:fr-
FR','official_name:en-
US','official_name:en','short_name','name','place_name','official_name','ref','type'])
as placename,get_name_by_language(name, ARRAY['ref']) as
ref,avg(ST_X(centroid)) as lon,avg(ST_Y(centroid)) as lat,
coalesce(importance,0.75-(rank_search::float/40)) as importance, (select
max(p.importance*(p.rank_address+2)) from place_addressline s, placex p
where s.place_id = min(CASE WHEN placex.rank_search < 28 THEN
placex.place_id ELSE placex.parent_place_id END) and p.place_id =
s.address_place_id and s.isaddress and p.importance is not null) as
addressimportance, (extratags->'place') as extra_place from placex where
place_id in
(101375,854399,859305,856181,156081,280198,318451,378529,501719,514761,725418,778426,856293,109932,172079,199487,261681)
and (placex.rank_address between 0 and 30 OR (extratags->'place') =
'city') and linked_place_id is null group by
osm_type,osm_id,class,type,admin_level,rank_search,rank_address,calculated_country_code,importance,langaddress
,placename ,ref ,extratags->'place' union select 'T' as osm_type,place_id
as osm_id,'place' as class,'house' as type,null as admin_level,30 as
rank_search,30 as rank_address,min(place_id) as place_id,
min(parent_place_id) as parent_place_id,'us' as
country_code,get_address_by_language(place_id,
ARRAY['short_name:fr','short_name:fr-FR','short_name:en-
US','short_name:en','name:fr','name:fr-FR','name:en-
US','name:en','place_name:fr','place_name:fr-FR','place_name:en-
US','place_name:en','official_name:fr','official_name:fr-
FR','official_name:en-
US','official_name:en','short_name','name','place_name','official_name','ref','type'])
as langaddress,null as placename,null as ref,avg(ST_X(centroid)) as
lon,avg(ST_Y(centroid)) as lat, -1.15 as importance, (select
max(p.importance*(p.rank_address+2)) from place_addressline s, placex p
where s.place_id = min(location_property_tiger.parent_place_id) and
p.place_id = s.address_place_id and s.isaddress and p.importance is not
null) as addressimportance, null as extra_place from
location_property_tiger where place_id in
(101375,854399,859305,856181,156081,280198,318451,378529,501719,514761,725418,778426,856293,109932,172079,199487,261681)
and 30 between 0 and 30 group by place_id union select 'L' as
osm_type,place_id as osm_id,'place' as class,'house' as type,null as
admin_level,30 as rank_search,30 as rank_address,min(place_id) as
place_id, min(parent_place_id) as parent_place_id,'us' as
country_code,get_address_by_language(place_id,
ARRAY['short_name:fr','short_name:fr-FR','short_name:en-
US','short_name:en','name:fr','name:fr-FR','name:en-
US','name:en','place_name:fr','place_name:fr-FR','place_name:en-
US','place_name:en','official_name:fr','official_name:fr-
FR','official_name:en-
US','official_name:en','short_name','name','place_name','official_name','ref','type'])
as langaddress,null as placename,null as ref,avg(ST_X(centroid)) as
lon,avg(ST_Y(centroid)) as lat, -1.10 as importance, (select
max(p.importance*(p.rank_address+2)) from place_addressline s, placex p
where s.place_id = min(location_property_aux.parent_place_id) and
p.place_id = s.address_place_id and s.isaddress and p.importance is not
null) as addressimportance, null as extra_place from location_property_aux
where place_id in
(101375,854399,859305,856181,156081,280198,318451,378529,501719,514761,725418,778426,856293,109932,172079,199487,261681)
and 30 between 0 and 30 group by
place_id,get_address_by_language(place_id,
ARRAY['short_name:fr','short_name:fr-FR','short_name:en-
US','short_name:en','name:fr','name:fr-FR','name:en-
US','name:en','place_name:fr','place_name:fr-FR','place_name:en-
US','place_name:en','official_name:fr','official_name:fr-
FR','official_name:en-
US','official_name:en','short_name','name','place_name','official_name','ref','type'])
order by importance desc" Recheck words:<\i>array(1) { [1]=> string(5)
"paris" }
}}}
But I have always no reaction when i click on Search. About the PNG errors
with "NetworkError: 407 Proxy Authentication Required", they appears when
i zoom on the map.
--
Ticket URL: <https://trac.openstreetmap.org/ticket/5329#comment:7>
OpenStreetMap <http://www.openstreetmap.org/>
OpenStreetMap is a free editable map of the whole world
More information about the Geocoding
mailing list