ВИД:
administrative
{"country":"JP","latitude":"34.9891585","longitude":"134.7631772","place_id":261821809,"rajon":"神崎郡","name":"Итикава","vid":1}
Дистанция: 6.625км, похожесть имени 0%
Добавить синоним к Hyōgo
Итикава
{"latitude":"35.0149524","longitude":"134.8084291","post":"679-2302","name":"Итикава","rajon":"Kanzaki District","area":"Хёго","country":"JP"}
Дистанция: 2.066км, похожесть имени 0%
Добавить синоним к Hyōgo
⨹Добавил населенный пункт 1633318:
Hyōgo
{"inetnum":"140.227.198.33-140.227.198.33","country":"JP","city":"Hyōgo","latitude":"35.0333","longitude":"134.8121","str":"{\n \"request\":\"140.227.198.33\",\n \"status\":200,\n \"delay\":\"0ms\",\n \"credit\":\"Some of the returned data includes GeoLite2 data created by MaxMind, available from
https:\\\/\\\/www.maxmind.com<\\\/a>.\",\n \"city\":\"Hyōgo\",\n \"region\":\"Hyōgo\",\n \"regionCode\":\"28\",\n \"regionName\":\"Hyōgo\",\n \"areaCode\":\"\",\n \"dmaCode\":\"\",\n \"countryCode\":\"JP\",\n \"countryName\":\"Japan\",\n \"inEU\":0,\n \"euVATrate\":false,\n \"continentCode\":\"AS\",\n \"continentName\":\"Asia\",\n \"latitude\":\"35.0333\",\n \"longitude\":\"134.8121\",\n \"locationAccuracyRadius\":\"20\",\n \"timezone\":\"Asia\\\/Tokyo\",\n \"currencyCode\":\"JPY\",\n \"currencySymbol\":\"¥\",\n \"currencySymbol_UTF8\":\"¥\",\n \"currencyConverter\":151.3315\n}","add":1,"tz":"Asia\/Tokyo","iso":"28","debug":1,"region":0,"rajon":0,"telcod":"","english":"Hego","sound":"H200"}
INSERT INTO pb_city SET name="Hyōgo", area="0", rajon="0", country="JP", english="Hego", sound="H200", latitude="35.0333", longitude="134.8121", tz="Asia/Tokyo"
Итикава
ВИД:
administrative
{"country":"JP","latitude":"34.9891585","longitude":"134.7631772","place_id":261821809,"rajon":"神崎郡","name":"Итикава","vid":1}
Дистанция: 4.994км✔
⨹Добавил район Kanzaki (92441)
INSERT INTO pb_rajon SET name="Kanzaki", english="Kanzaki", area="20091", country="JP"
⨹Добавил населенный пункт 1633319:
Итикава
{"latitude":"35.0149524","longitude":"134.8084291","post":"679-2302","name":"Итикава","rajon":"92441","area":"Хёго","country":"JP","add":1,"debug":1,"region":"20091","telcod":"","english":"Itikava","sound":"I321"}
INSERT INTO pb_city SET name="Итикава", area="20091", rajon="92441", country="JP", english="Itikava", sound="I321", latitude="35.0149524", longitude="134.8084291", post="679-2302"
{"country":"JP","latitude":"34.9891585","longitude":"134.7631772","place_id":261821809,"rajon":"神崎郡","name":"Итикава","vid":1}
Название:
Итикава✔
Страна: JP
Координаты: 34.9891585, 134.7631772 ↙4.99км
Заменить координаты ~
задан район, но нет региона
Регион: 神崎郡 ⚠
заполняю вид населенного пункта: город
GetCity( Hyōgo, {"inetnum":"140.227.198.33-140.227.198.33","country":"JP","city":"Hyōgo","latitude":"35.0333","longitude":"134.8121","str":"{\n \"request\":\"140.227.198.33\",\n \"status\":200,\n \"delay\":\"0ms\",\n \"credit\":\"Some of the returned data includes GeoLite2 data created by MaxMind, available from
https:\\\/\\\/www.maxmind.com<\\\/a>.\",\n \"city\":\"Hyōgo\",\n \"region\":\"Hyōgo\",\n \"regionCode\":\"28\",\n \"regionName\":\"Hyōgo\",\n \"areaCode\":\"\",\n \"dmaCode\":\"\",\n \"countryCode\":\"JP\",\n \"countryName\":\"Japan\",\n \"inEU\":0,\n \"euVATrate\":false,\n \"continentCode\":\"AS\",\n \"continentName\":\"Asia\",\n \"latitude\":\"35.0333\",\n \"longitude\":\"134.8121\",\n \"locationAccuracyRadius\":\"20\",\n \"timezone\":\"Asia\\\/Tokyo\",\n \"currencyCode\":\"JPY\",\n \"currencySymbol\":\"¥\",\n \"currencySymbol_UTF8\":\"¥\",\n \"currencyConverter\":151.3315\n}","add":1,"tz":"Asia\/Tokyo","iso":"28","debug":1})
Синоним hyōgo->{"id":"751932","name":"Хёго","sinonim":"Hyogo","tbl":"area","lang":"0","tbl_id":"0"} [X]
GetCity( Hyōgo, {"inetnum":"140.227.198.33-140.227.198.33","country":"JP","city":"Hyōgo","latitude":"35.0333","longitude":"134.8121","str":"{\n \"request\":\"140.227.198.33\",\n \"status\":200,\n \"delay\":\"0ms\",\n \"credit\":\"Some of the returned data includes GeoLite2 data created by MaxMind, available from
https:\\\/\\\/www.maxmind.com<\\\/a>.\",\n \"city\":\"Hyōgo\",\n \"region\":\"Hyōgo\",\n \"regionCode\":\"28\",\n \"regionName\":\"Hyōgo\",\n \"areaCode\":\"\",\n \"dmaCode\":\"\",\n \"countryCode\":\"JP\",\n \"countryName\":\"Japan\",\n \"inEU\":0,\n \"euVATrate\":false,\n \"continentCode\":\"AS\",\n \"continentName\":\"Asia\",\n \"latitude\":\"35.0333\",\n \"longitude\":\"134.8121\",\n \"locationAccuracyRadius\":\"20\",\n \"timezone\":\"Asia\\\/Tokyo\",\n \"currencyCode\":\"JPY\",\n \"currencySymbol\":\"¥\",\n \"currencySymbol_UTF8\":\"¥\",\n \"currencyConverter\":151.3315\n}","add":1,"tz":"Asia\/Tokyo","iso":"28","debug":1})
Ищу Город=Hyōgo, хего, Hego
по запросу: {"inetnum":"140.227.198.33-140.227.198.33","country":"JP","city":"Hyōgo","latitude":"35.0333","longitude":"134.8121","str":"{\n \"request\":\"140.227.198.33\",\n \"status\":200,\n \"delay\":\"0ms\",\n \"credit\":\"Some of the returned data includes GeoLite2 data created by MaxMind, available from https:\\\/\\\/www.maxmind.com<\\\/a>.\",\n \"city\":\"Hyōgo\",\n \"region\":\"Hyōgo\",\n \"regionCode\":\"28\",\n \"regionName\":\"Hyōgo\",\n \"areaCode\":\"\",\n \"dmaCode\":\"\",\n \"countryCode\":\"JP\",\n \"countryName\":\"Japan\",\n \"inEU\":0,\n \"euVATrate\":false,\n \"continentCode\":\"AS\",\n \"continentName\":\"Asia\",\n \"latitude\":\"35.0333\",\n \"longitude\":\"134.8121\",\n \"locationAccuracyRadius\":\"20\",\n \"timezone\":\"Asia\\\/Tokyo\",\n \"currencyCode\":\"JPY\",\n \"currencySymbol\":\"¥\",\n \"currencySymbol_UTF8\":\"¥\",\n \"currencyConverter\":151.3315\n}","add":1,"tz":"Asia\/Tokyo","iso":"28","debug":1,"region":0,"rajon":0,"telcod":"","english":"Hego","sound":"H200"}
13~SELECT * FROM `pb_city` WHERE (ABS(latitude-35.0333)<0.2 and ABS(longitude-134.8121)<0.2 or (`SOUND`="H200" or SOUNDEX(english)="H200" or name="хего" or name="Hyōgo" or english="Hego" or REPLACE(REPLACE(REPLACE(lower(trim(name)), "-", ""), " ", ""), "ё", "е")="хего" or REPLACE(trim(english), "-", " ")="Hego") and (latitude=0 or latitude is null or ABS(latitude-35.0333)<0.9) and (longitude=0 or longitude is null or ABS(longitude-134.8121)<0.9)) and country="JP" ORDER BY id LIMIT 1000
sql(13)=
SELECT * FROM `pb_city` WHERE (ABS(latitude-35.0333)<0.2 and ABS(longitude-134.8121)<0.2 or (`SOUND`="H200" or SOUNDEX(english)="H200" or name="хего" or name="Hyōgo" or english="Hego" or REPLACE(REPLACE(REPLACE(lower(trim(name)), "-", ""), " ", ""), "ё", "е")="хего" or REPLACE(trim(english), "-", " ")="Hego") and (latitude=0 or latitude is null or ABS(latitude-35.0333)<0.9) and (longitude=0 or longitude is null or ABS(longitude-134.8121)<0.9)) and country="JP" ORDER BY id LIMIT 1000
Нашел: 13: Хигасиосака(Higasiosaka), Оно(Tonosho), Haga, Hiezu, Hyougo, Hayakawa, Hikawa, Хасаки(Higashi), Hikago, Хигасикагава(Higashikagawa), Камикава(Kamikava), Ясиро(Yugawara), Хигасиосака(Higasiosaka)
сузил выборку по координатам до 10+км: 1+7: Камикава(Kamikava,8км), Haga, Hiezu, Hyougo, Hayakawa, Hikawa, Хасаки(Higashi), Hikago
Подбор по созвучию(2): Камикава(Kamikava,8км), Hyougo(80%)
Одинаковые города в базе:
- Камикава, Кансай, Хёго, 35.0828, 134.747, расстояние 8км
- Hyougo, , , вероятность 80% Объединить в 1
Ближайший (8км): Камикава(Kamikava), следующий (??км): Hyougo(Hyougo)
GetCity( Итикава, {"latitude":"35.0149524","longitude":"134.8084291","post":"679-2302","name":"Итикава","rajon":"Kanzaki District","area":"Хёго","country":"JP","add":1,"debug":1})
SELECT * FROM `pb_sinonim` WHERE sinonim IN ("Хёго","Хёго","Хёго","Хёго Oblast") and (tbl="" and tbl_id=0 or tbl="area") and name<>"Хёго" LIMIT 1
GetRajon Хёго:{"latitude":"35.0149524","longitude":"134.8084291","country":"JP","debug":1,"strictly":1}
GetRajon(Хёго, {"latitude":"35.0149524","longitude":"134.8084291","country":"JP","debug":1,"strictly":1}~Хёго
SELECT * FROM `pb_rajon` WHERE (name="Хёго" or name="Хёго район" or english="Hego") and country="JP" LIMIT 500 нашел=1
Нашел! по созвучию: Хёго, вероятность 100
Получил регион: {"id":"20091","name":"Кансай","okrug":"","autocod":"","capital":"0","english":"Kansaj","iso":"14","country":"JP","vid":"20","wiki":"ru.wikipedia.org\/wiki\/Кансай"}
на запрос: {"latitude":"35.0149524","longitude":"134.8084291","post":"679-2302","name":"Итикава","rajon":"Kanzaki District","area":"Хёго","country":"JP","add":1,"debug":1,"region":"Хёго"}!
GetRajon Kanzaki:{"latitude":"35.0149524","longitude":"134.8084291","country":"JP","add":1,"debug":1,"region":"20091"}
GetRajon(Kanzaki District, {"latitude":"35.0149524","longitude":"134.8084291","country":"JP","add":1,"debug":1,"region":"20091"}, normal=Kanzaki~Kanzaki
SELECT * FROM `pb_rajon` WHERE (name="Kanzaki" or name="Kanzaki район" or english="Kanzaki") and area="20091" LIMIT 500 нашел=0
SELECT * FROM `pb_rajon` WHERE (SOUNDEX(REPLACE(english," rajon",""))="K522" or name LIKE "Kanzaki%" or locate(REPLACE(REPLACE(REPLACE(REPLACE(lower(trim(name)), "-", ""), " ", ""), "ё", "е"), "ь", ""), "kanzakikanzaki")>0 or locate("kanzaki", REPLACE(REPLACE(REPLACE(REPLACE(lower(trim(concat(name," ",english))), "-", ""), " ", ""), "ё", "е"), "ь", "") )>0) and area="20091" нашел=0
ищу в 7 синонимах SELECT * FROM `pb_rajon` WHERE area="20091" LIMIT 500 не нашел оптимального среди 0
GetOptimal: не нашел Kanzaki, Kanzaki для [{"id":"81007","name":"Киото","area":"20091","country":"JP","capital":"12299","english":"Kyoto shi","vid":"34","parent":"0","iso":"26","wiki":null},{"id":"83786","name":"Сига","area":"20091","country":"JP","capital":"1624516","english":"Siga","vid":"34","parent":"0","iso":"25","wiki":null},{"id":"83788","name":"Нара","area":"20091","country":"JP","capital":"66386","english":"Nara","vid":"34","parent":"0","iso":"28","wiki":null},{"id":"83804","name":"Миэ","area":"20091","country":"JP","capital":"1319226","english":"Mie","vid":"34","parent":"0","iso":"24","wiki":null},{"id":"83812","name":"Хёго","area":"20091","country":"JP","capital":"12301","english":"Hego","vid":"34","parent":"0","iso":"28","wiki":null},{"id":"83817","name":"Вакаяма","area":"20091","country":"JP","capital":"12289","english":"Vakajama","vid":"34","parent":"0","iso":"30","wiki":null},false]
Получил район: {"id":"92441","name":"Kanzaki","area":"20091","country":"JP","capital":"0","english":"Kanzaki","vid":"0","parent":"0","iso":"","wiki":null}
на запрос: {"latitude":"35.0149524","longitude":"134.8084291","post":"679-2302","name":"Итикава","rajon":"Kanzaki District","area":"Хёго","country":"JP","add":1,"debug":1,"region":"20091"}!
Ищу Город=Итикава, итикава, Itikava
по запросу: {"latitude":"35.0149524","longitude":"134.8084291","post":"679-2302","name":"Итикава","rajon":"92441","area":"Хёго","country":"JP","add":1,"debug":1,"region":"20091","telcod":"","english":"Itikava","sound":"I321"}
5~SELECT * FROM `pb_city` WHERE (ABS(latitude-35.0149524)<0.2 and ABS(longitude-134.8084291)<0.2 or post="679-2302" or (`SOUND`="I321" or SOUNDEX(english)="I321" or name="итикава" or name="Итикава" or english="Itikava" or REPLACE(REPLACE(REPLACE(lower(trim(name)), "-", ""), " ", ""), "ё", "е")="итикава" or REPLACE(trim(english), "-", " ")="Itikava") and area IN (0,20091) and rajon IN (0,92441) and (latitude=0 or latitude is null or ABS(latitude-35.0149524)<0.9) and (longitude=0 or longitude is null or ABS(longitude-134.8084291)<0.9)) and country="JP" ORDER BY id LIMIT 1000
sql(5)=
SELECT * FROM `pb_city` WHERE (ABS(latitude-35.0149524)<0.2 and ABS(longitude-134.8084291)<0.2 or post="679-2302" or (`SOUND`="I321" or SOUNDEX(english)="I321" or name="итикава" or name="Итикава" or english="Itikava" or REPLACE(REPLACE(REPLACE(lower(trim(name)), "-", ""), " ", ""), "ё", "е")="итикава" or REPLACE(trim(english), "-", " ")="Itikava") and area IN (0,20091) and rajon IN (0,92441) and (latitude=0 or latitude is null or ABS(latitude-35.0149524)<0.9) and (longitude=0 or longitude is null or ABS(longitude-134.8084291)<0.9)) and country="JP" ORDER BY id LIMIT 1000
Нашел: 5: Химедзи(Himeji), Оно(Tonosho), Камикава(Kamikava), Ясиро(Yugawara), Hyōgo(Hego)
сузил выборку по координатам до 10+км: 2+0: Камикава(Kamikava,9км), Hyōgo(Hego,2км)
Подбор по созвучию(2): Hyōgo(Hego,2км), Камикава(Kamikava,66%,9км)
По мягкому поиску одинаковые города в базе:
- Hyōgo, 35.0333, 134.812, расстояние 2км Переименовать в Итикава
- Камикава, 35.0828, 134.747, Хёго, Кансай, вероятность 66%, расстояние 9км Объединить в 1
Одинаковые города в базе:
- Hyōgo, 35.0333, 134.812, расстояние 2км
- Камикава, Кансай, Хёго, 35.0828, 134.747, вероятность 66%, расстояние 9км Объединить в 1
Ближайший (2км): Hyōgo(Hego), следующий (9км): Камикава(Kamikava)
Итикава
https://ru.wikipedia.org/wiki/Итикава_(Кансай,Kanzaki) - нет такого!
ru.wikipedia.org/wiki/Итикава [
x] [
город] [
область]
UPDATE `pb_city` SET `vid` = '1'
WHERE id = 1633319 LIMIT 1
вроде и нашел, но буду добавлять. ХРЕНЬ КАКАЯ ТО
[{"id":"1633318","name":"Hyōgo","area":"0","telcod":"","latitude":"35.0333","longitude":"134.812","time_zone":null,"tz":"Asia\/Tokyo","english":"Hego","rajon":"0","sub_rajon":"0","country":"JP","sound":"H200","level":"0","iso":"","vid":"0","post":"","geonameid":null,"wiki":null,"distance":2,"percent":0,"compatible":0},{"id":"1348318","name":"Камикава","area":"20091","telcod":"","latitude":"35.0828","longitude":"134.747","time_zone":"9","tz":"Asia\/Tokyo","english":"Kamikava","rajon":"83812","sub_rajon":"0","country":"JP","sound":"K521","level":"0","iso":"","vid":"0","post":"","geonameid":null,"wiki":null,"distance":9,"percent":66,"compatible":0}]
{"latitude":"34.9892293","longitude":"134.7633272","name":"Итикава","rajon":"Kanzaki District","area":"Хёго","country":"JP"}
Дистанция: 6.61км, похожесть имени 0%
Добавить синоним к Hyōgo
Итикава
GetCity( Итикава, {"latitude":"34.9892293","longitude":"134.7633272","name":"Итикава","rajon":"Kanzaki District","area":"Хёго","country":"JP","add":1,"debug":1})
SELECT * FROM `pb_sinonim` WHERE sinonim IN ("Хёго","Хёго","Хёго","Хёго Oblast") and (tbl="" and tbl_id=0 or tbl="area") and name<>"Хёго" LIMIT 1
Получил регион: {"id":"20091","name":"Кансай","okrug":"","autocod":"","capital":"0","english":"Kansaj","iso":"14","country":"JP","vid":"20","wiki":"ru.wikipedia.org\/wiki\/Кансай"}
на запрос: {"latitude":"34.9892293","longitude":"134.7633272","name":"Итикава","rajon":"Kanzaki District","area":"Хёго","country":"JP","add":1,"debug":1,"region":"Хёго"}!
GetRajon Kanzaki:{"latitude":"34.9892293","longitude":"134.7633272","country":"JP","add":1,"debug":1,"region":"20091"}
GetRajon(Kanzaki District, {"latitude":"34.9892293","longitude":"134.7633272","country":"JP","add":1,"debug":1,"region":"20091"}, normal=Kanzaki~Kanzaki
SELECT * FROM `pb_rajon` WHERE (name="Kanzaki" or name="Kanzaki район" or english="Kanzaki") and area="20091" LIMIT 500 нашел=1
Нашел! по созвучию: Kanzaki, вероятность 100
В базе чисто английское(Kanzaki~Kanzaki)= true, передано чисто русское(Kanzaki)=false
28.03.2024 12:04:49 GetRajon
UPDATE pb_rajon SET english="Kanzaki" WHERE id=92441 LIMIT 1
Записал в район Kanzaki(92441): english="Kanzaki"!
Получил район: {"id":"92441","name":"Kanzaki","area":"20091","country":"JP","capital":"0","english":"Kanzaki","vid":"0","parent":"0","iso":"","wiki":null,"percent":100}
на запрос: {"latitude":"34.9892293","longitude":"134.7633272","name":"Итикава","rajon":"Kanzaki District","area":"Хёго","country":"JP","add":1,"debug":1,"region":"20091"}!
Ищу Город=Итикава, итикава, Itikava
по запросу: {"latitude":"34.9892293","longitude":"134.7633272","name":"Итикава","rajon":"92441","area":"Хёго","country":"JP","add":1,"debug":1,"region":"20091","telcod":"","english":"Itikava","sound":"I321"}
5~SELECT * FROM `pb_city` WHERE (ABS(latitude-34.9892293)<0.2 and ABS(longitude-134.7633272)<0.2 or (`SOUND`="I321" or SOUNDEX(english)="I321" or name="итикава" or name="Итикава" or english="Itikava" or REPLACE(REPLACE(REPLACE(lower(trim(name)), "-", ""), " ", ""), "ё", "е")="итикава" or REPLACE(trim(english), "-", " ")="Itikava") and area IN (0,20091) and rajon IN (0,92441) and (latitude=0 or latitude is null or ABS(latitude-34.9892293)<0.9) and (longitude=0 or longitude is null or ABS(longitude-134.7633272)<0.9)) and country="JP" ORDER BY id LIMIT 1000
sql(5)=
SELECT * FROM `pb_city` WHERE (ABS(latitude-34.9892293)<0.2 and ABS(longitude-134.7633272)<0.2 or (`SOUND`="I321" or SOUNDEX(english)="I321" or name="итикава" or name="Итикава" or english="Itikava" or REPLACE(REPLACE(REPLACE(lower(trim(name)), "-", ""), " ", ""), "ё", "е")="итикава" or REPLACE(trim(english), "-", " ")="Itikava") and area IN (0,20091) and rajon IN (0,92441) and (latitude=0 or latitude is null or ABS(latitude-34.9892293)<0.9) and (longitude=0 or longitude is null or ABS(longitude-134.7633272)<0.9)) and country="JP" ORDER BY id LIMIT 1000
Нашел: 5: Химедзи(Himeji), Оно(Tonosho), Камикава(Kamikava), Hyōgo(Hego), Итикава(Itikava)
сузил выборку по координатам до 10+км: 2+0: Hyōgo(Hego,6км), Итикава(Itikava,4км)
Подбор по созвучию(2): Итикава(Itikava,100%,4км), Hyōgo(Hego,6км)
По мягкому поиску одинаковые города в базе:
- Итикава, 35.015, 134.808, Kanzaki, Кансай, вероятность 100%, расстояние 4км Переименовать в Итикава
- Hyōgo, 35.0333, 134.812, расстояние 6км Объединить в 1
Выбираю ближайший Итикава, вероятность: 100%, расстояние: 4км
Google: ДРУГОЕ НАЗВАНИЕ: Итикава Добавить синоним к Hyōgo
Страна: JP
Координаты: 34.9891585, 134.7631772 ↙6.63км
Заменить координаты ~
задан район, но нет региона
вид населенного пункта: город
Hyōgo
https://ru.wikipedia.org/wiki/Hyōgo - нет такого!
https://ru.wikipedia.org/wiki/Hyōgo - нет такого!
https://en.wikipedia.org/wiki/Hego - не нашел координаты!
https://en.wikipedia.org/wiki/Hego [
город]
https://en.wikipedia.org/wiki/Hego [
только имя][
перепроверить название по координатам]
GetCity( Итикава, {"country":"JP","latitude":"34.9891585","longitude":"134.7631772","place_id":261821809,"rajon":"神崎郡","name":"Итикава","vid":1,"add":1,"debug":1})
GetRajon 神崎郡:{"country":"JP","latitude":"34.9891585","longitude":"134.7631772","add":1,"debug":1}
GetRajon(神崎郡, {"country":"JP","latitude":"34.9891585","longitude":"134.7631772","add":1,"debug":1}~神崎郡
SELECT * FROM `pb_rajon` WHERE (name="神崎郡" or name="神崎郡 район" ) and country="JP" LIMIT 500 нашел=0
SELECT * FROM `pb_rajon` WHERE (SOUNDEX(REPLACE(english," rajon",""))="" or name LIKE "神崎郡%" or locate(REPLACE(REPLACE(REPLACE(REPLACE(lower(trim(name)), "-", ""), " ", ""), "ё", "е"), "ь", ""), "神崎郡")>0 or locate("神崎郡", REPLACE(REPLACE(REPLACE(REPLACE(lower(trim(concat(name," ",english))), "-", ""), " ", ""), "ё", "е"), "ь", "") )>0) and country="JP" нашел=2
НЕ нашел по созвучию `神崎郡`: 世羅郡,
ищу в 52 синонимах SELECT * FROM `pb_rajon` WHERE country="JP" LIMIT 500 не нашел оптимального среди 0
Получил район: null
на запрос: {"country":"JP","latitude":"34.9891585","longitude":"134.7631772","place_id":261821809,"rajon":"神崎郡","name":"Итикава","vid":1,"add":1,"debug":1}!
Ищу Город=Итикава, итикава, Itikava
по запросу: {"country":"JP","latitude":"34.9891585","longitude":"134.7631772","place_id":261821809,"rajon":0,"name":"Итикава","vid":1,"add":1,"debug":1,"region":0,"telcod":"","english":"Itikava","sound":"I321"}
5~SELECT * FROM `pb_city` WHERE (ABS(latitude-34.9891585)<0.2 and ABS(longitude-134.7631772)<0.2 or (`SOUND`="I321" or SOUNDEX(english)="I321" or name="итикава" or name="Итикава" or english="Itikava" or REPLACE(REPLACE(REPLACE(lower(trim(name)), "-", ""), " ", ""), "ё", "е")="итикава" or REPLACE(trim(english), "-", " ")="Itikava") and (latitude=0 or latitude is null or ABS(latitude-34.9891585)<0.9) and (longitude=0 or longitude is null or ABS(longitude-134.7631772)<0.9)) and country="JP" ORDER BY id LIMIT 1000
sql(5)=
SELECT * FROM `pb_city` WHERE (ABS(latitude-34.9891585)<0.2 and ABS(longitude-134.7631772)<0.2 or (`SOUND`="I321" or SOUNDEX(english)="I321" or name="итикава" or name="Итикава" or english="Itikava" or REPLACE(REPLACE(REPLACE(lower(trim(name)), "-", ""), " ", ""), "ё", "е")="итикава" or REPLACE(trim(english), "-", " ")="Itikava") and (latitude=0 or latitude is null or ABS(latitude-34.9891585)<0.9) and (longitude=0 or longitude is null or ABS(longitude-134.7631772)<0.9)) and country="JP" ORDER BY id LIMIT 1000
Нашел: 5: Химедзи(Himeji), Оно(Tonosho), Камикава(Kamikava), Hyōgo(Hego), Итикава(Itikava)
сузил выборку по координатам до 10+км: 2+0: Hyōgo(Hego,6км), Итикава(Itikava,4км)
Подбор по созвучию(2): Итикава(Itikava,100%,4км), Hyōgo(Hego,6км)
Выбираю ближайший Итикава, вероятность: 100%, расстояние: 4км
{"country":"JP","latitude":"34.9891585","longitude":"134.7631772","place_id":261821809,"rajon":"神崎郡","name":"Итикава","vid":1}
OSM: ДРУГОЕ НАЗВАНИЕ: Итикава Добавить синоним к Hyōgo
Страна: JP
Координаты: 34.9891585, 134.7631772 ↙6.63км
Заменить координаты ~
задан район, но нет региона
вид населенного пункта: город
В файле a.txt будет результат трассировки по ICMP.
Для проверки обращения по https выполните: