--
-- Структура таблицы `cities`
--

CREATE TABLE IF NOT EXISTS `cities` (
`Id` bigint(13) DEFAULT NULL,
`Name` varchar(78) DEFAULT NULL,
`ZipCode` varchar(6) DEFAULT NULL,
`TypeShort` varchar(20) DEFAULT NULL,
`Okato` varchar(11) DEFAULT NULL,
`Type` varchar(54) DEFAULT NULL,
`CodeRegion` smallint(2) DEFAULT NULL,
`CodeDistrict` smallint(3) DEFAULT NULL,
`CodeCity` smallint(4) DEFAULT NULL,
`CodeStreet` int(1) DEFAULT NULL,
`CodeBuilding` int(1) DEFAULT NULL,
`Sort` int(6) DEFAULT NULL,
`TypeCode` int(1) DEFAULT NULL,
`Bad` varchar(15) DEFAULT NULL,
`Points` varchar(30) NOT NULL,
`check` char(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Структура таблицы `district`
--

CREATE TABLE IF NOT EXISTS `district` (
`Id` bigint(13) DEFAULT NULL,
`Name` varchar(68) DEFAULT NULL,
`ZipCode` varchar(6) DEFAULT NULL,
`TypeShort` varchar(20) DEFAULT NULL,
`Okato` varchar(11) DEFAULT NULL,
`Type` varchar(54) DEFAULT NULL,
`CodeRegion` smallint(2) DEFAULT NULL,
`CodeDistrict` smallint(3) DEFAULT NULL,
`CodeCity` int(1) DEFAULT NULL,
`CodeStreet` int(1) DEFAULT NULL,
`CodeBuilding` int(1) DEFAULT NULL,
`Sort` int(5) DEFAULT NULL,
`TypeCode` int(1) DEFAULT NULL,
`Bad` varchar(15) DEFAULT NULL,
`Points` varchar(30) NOT NULL,
`check` char(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Структура таблицы `regions`
--

CREATE TABLE IF NOT EXISTS `regions` (
`Id` bigint(13) DEFAULT NULL,
`Name` varchar(74) DEFAULT NULL,
`ZipCode` varchar(6) DEFAULT NULL,
`TypeShort` varchar(20) DEFAULT NULL,
`Okato` bigint(11) DEFAULT NULL,
`Type` varchar(54) DEFAULT NULL,
`CodeRegion` smallint(2) DEFAULT NULL,
`CodeDistrict` int(1) DEFAULT NULL,
`CodeCity` int(1) DEFAULT NULL,
`CodeStreet` int(1) DEFAULT NULL,
`CodeBuilding` int(1) DEFAULT NULL,
`Sort` int(6) DEFAULT NULL,
`TypeCode` int(1) DEFAULT NULL,
`Bad` varchar(15) DEFAULT NULL,
`Points` varchar(30) NOT NULL,
`check` char(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Структура таблицы `streets`
--

CREATE TABLE IF NOT EXISTS `streets` (
`Id` bigint(17) DEFAULT NULL,
`Name` varchar(78) DEFAULT NULL,
`ZipCode` varchar(6) DEFAULT NULL,
`TypeShort` varchar(20) DEFAULT NULL,
`Okato` varchar(11) DEFAULT NULL,
`Type` varchar(55) DEFAULT NULL,
`Bad` varchar(15) DEFAULT NULL,
`CodeRegion` smallint(2) DEFAULT NULL,
`CodeDistrict` smallint(3) DEFAULT NULL,
`CodeCity` smallint(4) DEFAULT NULL,
`CodeStreet` int(4) DEFAULT NULL,
`CodeBuilding` int(1) DEFAULT NULL,
`Points` varchar(30) NOT NULL,
`check` char(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Индексы сохранённых таблиц
--

--
-- Индексы таблицы `cities`
--
ALTER TABLE `cities`
ADD KEY `CodeRegion` (`CodeRegion`), ADD KEY `CodeCity` (`CodeCity`), ADD KEY `CodeStreet` (`CodeStreet`), ADD KEY `Points` (`Points`), ADD KEY `Id` (`Id`), ADD KEY `CodeDistrict` (`CodeDistrict`);

--
-- Индексы таблицы `district`
--
ALTER TABLE `district`
ADD KEY `Id` (`Id`), ADD KEY `CodeRegion` (`CodeRegion`), ADD KEY `CodeDistrict` (`CodeDistrict`), ADD KEY `Points` (`Points`), ADD KEY `check` (`check`), ADD KEY `TypeShort` (`TypeShort`);

--
-- Индексы таблицы `regions`
--
ALTER TABLE `regions`
ADD KEY `Id` (`Id`), ADD KEY `CodeRegion` (`CodeRegion`), ADD KEY `Points` (`Points`), ADD KEY `check` (`check`), ADD KEY `TypeShort` (`TypeShort`);

--
-- Индексы таблицы `streets`
--
ALTER TABLE `streets`
ADD KEY `Id` (`Id`), ADD KEY `TypeShort` (`TypeShort`), ADD KEY `CodeRegion` (`CodeRegion`), ADD KEY `CodeDistrict` (`CodeDistrict`), ADD KEY `CodeCity` (`CodeCity`), ADD KEY `CodeStreet` (`CodeStreet`), ADD KEY `Points` (`Points`), ADD KEY `check` (`check`);

SELECT
S.Id AS Id, S.TypeShort AS t_s, S.Name AS street,
R.TypeShort AS t_r, R.Name AS region,
D.Name AS rayon, D.TypeShort AS t_d,
C.TypeShort AS t_c, C.Name AS city

FROM streets S, regions R, district D, cities C"

WHERE S.check = '0'
AND S.CodeRegion != 0
AND S.CodeDistrict != 0
AND S.CodeCity != 0

AND R.CodeRegion = S.CodeRegion
AND D.CodeRegion = S.CodeRegion
AND D.CodeDistrict = S.CodeDistrict

AND C.CodeRegion = S.CodeRegion
AND C.CodeDistrict = S.CodeDistrict
AND C.CodeCity = S.CodeCity

ORDER BY S.Id DESC
LIMIT 1;

<!DOCTYPE html>
<html lang="ru">
<head>

<meta charset="utf-8" />
<!-- на всякий случай обновляю каждую минуту index.php-->
<META HTTP-EQUIV='Refresh' CONTENT='60; URL=index.php'>
<title>importDB</title>

<script src=" http://code.jquery.com/jquery-2.0.3.js"></script>
<script>
setTimeout(F1, 10);
function F1(){
$.get('import.php', function(data){
$('#html').html(data);
});
setTimeout(F1, 100);
}
</script>

</head>
<body>

<div id=html></div>

</body>
</html>

<?
set_time_limit(0);

define('_DB_HOST', 'localhost');
define('_DB_USER', 'root');
define('_DB_PASS', '');
define('_DB_NAME', 'geo_kladr');
define('_DB_PREX', '');

require_once( $_SERVER['DOCUMENT_ROOT'].'/class/db.php' );
$db = new database( _DB_HOST, _DB_USER, _DB_PASS, _DB_NAME, _DB_PREX );



switch ($o){
case 'import_db':
import_db();
break;

default:
for($i=0; $i< 5; $i++)
{
import_db();
}

break;
}


function import_db()
{
global $db;

$query = "SELECT * FROM `streets` WHERE `check` = '1' ORDER BY Id ASC LIMIT 1";
$db->setQuery($query);
$rows = $db->loadObjectList();

if (count($rows) != 0)
{
foreach ($rows as $row)
{
$query_insert = "INSERT INTO `streets_test` (`Id`, `Name`, `ZipCode`, `TypeShort`, `Okato`, `Type`, `Bad`, `CodeRegion`, `CodeDistrict`, `CodeCity`, `CodeStreet`, `CodeBuilding`, `Points`, `check`)
VALUES ( '$row->Id', '$row->Name', '$row->ZipCode', '$row->TypeShort', '$row->Okato', '$row->Type', '$row->Bad', '$row->CodeRegion', '$row->CodeDistrict', '$row->CodeCity', '$row->CodeStreet', '$row->CodeBuilding', '$row->Points', '$row->check');";

$db->setQuery($query_insert);

if( !$db->query() )
{
echo $content = 'Ошибка: не удалось вставить запись '.$row->Id." в таблицу streets_test\n";

$log = file_get_contents($_SERVER['DOCUMENT_ROOT'].'/log.txt');
$log .= $content;
file_put_contents($_SERVER['DOCUMENT_ROOT'].'/log.txt', $log );
}
else
{
$db->setQuery("DELETE FROM `streets` WHERE `Id` = '$row->Id';");

if( !$db->query() )
{
echo $content = 'Ошибка: не удалось удалить запись '.$row->Id." из таблицы streets\n";

$log = file_get_contents($_SERVER['DOCUMENT_ROOT'].'/log.txt');
$log .= $content;
file_put_contents($_SERVER['DOCUMENT_ROOT'].'/log.txt', $log );
}
else
{
echo $content = 'Успех '.$row->Id;
echo '<br>';
}
}
}
}
else
{
echo $content = 'Импорт завершён.';
}
}
?>

SELECT
R.TypeShort AS t_r, R.Name AS region, R.TypeCode AS TypeCode,
D.Name AS rayon, D.TypeShort AS t_d,
C.TypeShort AS t_c, C.Name AS city,
S.Name, S.kID

FROM regions R, district D, cities C, streets S

WHERE S.CodeRegion = R.CodeRegion
AND D.CodeRegion = R.CodeRegion
AND C.CodeRegion = D.CodeRegion
AND C.CodeDistrict = D.CodeDistrict
AND S.CodeCity = C.CodeCity
AND S.Points = ''
LIMIT 1;