Наш чат в Telegram для обмена идеями, проектами, мыслями, людьми в сфере ИТ г.Ростова-на-Дону: @it_rostov

Информация об IP-адресе 140.227.198.33




IP можно вводить как в формате IPv4, так и в формате длинного целого числа.

Данный сервис доступен по API, готовый виджет

Осталось 15 бесплатных запросов до 11:34:19 29.03.24

Информация о занятости и владельце домена

Если Ваш ip адрес находится в этом черном списке и вы устранили ошибки в своих запросах, которые привели к блокировке, Вы можете однократно исключить ip из черного списка, для этого укажите IP и подтвердите что Вы не робот:


Загрузка капчи...

Если Вы многократно попадали в бан, разблокировка данным способом невозможна.


IP: 140.227.198.33, в формате числа (ip2long): 2363737633
ВИД: 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%)

Одинаковые города в базе:


  1. Камикава, Кансай, Хёго, 35.0828, 134.747, расстояние 8км

  2. 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км)

По мягкому поиску одинаковые города в базе:

  1. Hyōgo, 35.0333, 134.812, расстояние 2км Переименовать в Итикава
  2. Камикава, 35.0828, 134.747, Хёго, Кансай, вероятность 66%, расстояние 9км Объединить в 1

Одинаковые города в базе:


  1. Hyōgo, 35.0333, 134.812, расстояние 2км

  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км)

По мягкому поиску одинаковые города в базе:

  1. Итикава, 35.015, 134.808, Kanzaki, Кансай, вероятность 100%, расстояние 4км Переименовать в Итикава
  2. 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км Заменить координаты ~
задан район, но нет региона
вид населенного пункта: город

По данным htmlweb whois MaxMind abstractapi db-ip ipapi ipstack ipinfo Black List Spam
htmlweb.ru:Неверно?
Город: Hyōgo (Hego) Wiki
Страна: Япония Wiki (, Japan, ISO:392) , Столица Токио
Часть света: Азия
Код страны(2): JP
Код страны(3): JPN
Широта: 35.0333
Долгота: 134.812

Телефонный код страны: +81
Временная зона(Time Zone,UTC,GMT): +9
Домен: 140-227-198-33.vpscloud.static.arena.ne.jp
Осталось 15 бесплатных запросов до 11:34:19 29.03.24
Информация актуальна на 01.01.1970 03:00, Обновить?, из локальной базы



Server: whois.ripe.net
% This is the RIPE Database query service.
% The objects are in RPSL format.
%
% The RIPE Database is subject to Terms and Conditions.
% See https://apps.db.ripe.net/docs/HTML-Terms-And-Conditions
% Note: this output has been filtered.
% To receive output for a database update, use the "-B" flag.
% Information related to '140.204.0.0 - 140.228.31.255'
% No abuse contact registered for 140.204.0.0 - 140.228.31.255
inetnum: 140.204.0.0 - 140.228.31.255
netname: NON-RIPE-NCC-MANAGED-ADDRESS-BLOCK
descr: IPv4 address block not managed by the RIPE NCC
remarks: ------------------------------------------------------
remarks:
remarks: For registration information,
remarks: you can consult the following sources:
remarks:
remarks: IANA
remarks: http://www.iana.org/assignments/ipv4-address-space
remarks: http://www.iana.org/assignments/iana-ipv4-special-registry
remarks: http://www.iana.org/assignments/ipv4-recovered-address-space
remarks:
remarks: AFRINIC (Africa)
remarks: http://www.afrinic.net/ whois.afrinic.net
remarks:
remarks: APNIC (Asia Pacific)
remarks: http://www.apnic.net/ whois.apnic.net
remarks:
remarks: ARIN (Northern America)
remarks: http://www.arin.net/ whois.arin.net
remarks:
remarks: LACNIC (Latin America and the Carribean)
remarks: http://www.lacnic.net/ whois.lacnic.net
remarks:
remarks: ------------------------------------------------------
country: EU # Country is really world wide
admin-c: IANA1-RIPE
tech-c: IANA1-RIPE
status: ALLOCATED UNSPECIFIED
mnt-by: RIPE-NCC-HM-MNT
created: 2021-09-16T14:06:06Z
last-modified: 2021-09-16T14:06:06Z
source: RIPE
role: Internet Assigned Numbers Authority
address: see http://www.iana.org.
admin-c: IANA1-RIPE
tech-c: IANA1-RIPE
nic-hdl: IANA1-RIPE
remarks: For more information on IANA services
remarks: go to IANA web site at http://www.iana.org.
mnt-by: RIPE-NCC-MNT
created: 1970-01-01T00:00:00Z
last-modified: 2001-09-22T09:31:27Z
source: RIPE # Filtered
% This query was served by the RIPE Database Query Service version 1.111 (ABERDEEN)


Server: whois.arin.net
#
# ARIN WHOIS data and services are subject to the Terms of Use
# available at: https://www.arin.net/resources/registry/whois/tou/
#
# If you see inaccuracies in the results, please report at
# https://www.arin.net/resources/registry/whois/inaccuracy_reporting/
#
# Copyright 1997-2024, American Registry for Internet Numbers, Ltd.
#

#
# Query terms are ambiguous. The query is assumed to be:
# "n 140.227.198.33"
#
# Use "?" to get help.
#
NetRange: 140.227.0.0 - 140.227.255.255
CIDR: 140.227.0.0/16
NetName: APNIC
NetHandle: NET-140-227-0-0-1
Parent: NET140 (NET-140-0-0-0-0)
NetType: Early Registrations, Transferred to APNIC
OriginAS:
Organization: Asia Pacific Network Information Centre (APNIC)
RegDate: 2016-07-06
Updated: 2016-07-06
Ref: https://rdap.arin.net/registry/ip/140.227.0.0
ResourceLink: http://wq.apnic.net/whois-search/static/search.html
ResourceLink: whois://whois.apnic.net

OrgName: Asia Pacific Network Information Centre
OrgId: APNIC
Address: PO Box 3646
City: South Brisbane
StateProv: QLD
PostalCode: 4101
Country: AU
RegDate:
Updated: 2012-01-24
Ref: https://rdap.arin.net/registry/entity/APNIC
ReferralServer: whois://whois.apnic.net
ResourceLink: http://wq.apnic.net/whois-search/static/search.html
OrgAbuseHandle: AWC12-ARIN
OrgAbuseName: APNIC Whois Contact
OrgAbusephone: +61 7 3858 3188
OrgAbuseEmail: search-apnic-not-arin@apnic.net
OrgAbuseRef: https://rdap.arin.net/registry/entity/AWC12-ARIN
OrgTechHandle: AWC12-ARIN
OrgTechName: APNIC Whois Contact
OrgTechphone: +61 7 3858 3188
OrgTechEmail: search-apnic-not-arin@apnic.net
OrgTechRef: https://rdap.arin.net/registry/entity/AWC12-ARIN

#
# ARIN WHOIS data and services are subject to the Terms of Use
# available at: https://www.arin.net/resources/registry/whois/tou/
#
# If you see inaccuracies in the results, please report at
# https://www.arin.net/resources/registry/whois/inaccuracy_reporting/
#
# Copyright 1997-2024, American Registry for Internet Numbers, Ltd.
#
RefServer: whois.apnic.net



Server: whois.apnic.net

Мой IP?

Ваш IP адрес: 44.200.39.110 проверить

Еще полезное об IP:

Как посмотреть путь до указанного IP?

В Windows набираете:
пуск -> выполнить -> cmd
tracert "ip-адрес"
В Unix набираете:
traceroute 185.12.92.137 >a.txt
В файле a.txt будет результат трассировки по ICMP. Для проверки обращения по https выполните:
traceroute -p 443 185.12.92.137

Как узнать обратную зону для IP?

В Windows набираете:
пуск -> выполнить -> cmd
nslookup "ip-адрес"

А ещё можно определить местонахождение человека по номеру телефона. Или сделать для Вашего сайта красивый виджет определения местоположения по IP.


.