select ts.datea as dat, t_s.descr as markv, t_r.descr as markg, ts.ido as ido, abs(ts.kend - ts.kbeg - 0) as kdelta from otklikt as ts, t_road as t_r, t_speed as t_s where ts.ido>0 and ts.idtr = '340' and t_s.id = ts.markv and t_r.id = ts.markg and ts.kend >= 0 and ts.kbeg <= 0 order by ts.datea desc, kdelta asc limit 1select ts.datea as dat, t_s.descr as markv, t_r.descr as markg, ts.ido as ido, abs(ts.kend - ts.kbeg - 4) as kdelta from otklikt as ts, t_road as t_r, t_speed as t_s where ts.ido>0 and ts.idtr = '340' and t_s.id = ts.markv and t_r.id = ts.markg and ts.kend >= 4 and ts.kbeg <= 4 order by ts.datea desc, kdelta asc limit 1select ts.datea as dat, t_s.descr as markv, t_r.descr as markg, ts.ido as ido, abs(ts.kend - ts.kbeg - 5) as kdelta from otklikt as ts, t_road as t_r, t_speed as t_s where ts.ido>0 and ts.idtr = '340' and t_s.id = ts.markv and t_r.id = ts.markg and ts.kend >= 5 and ts.kbeg <= 5 order by ts.datea desc, kdelta asc limit 1select ts.datea as dat, t_s.descr as markv, t_r.descr as markg, ts.ido as ido, abs(ts.kend - ts.kbeg - 8) as kdelta from otklikt as ts, t_road as t_r, t_speed as t_s where ts.ido>0 and ts.idtr = '340' and t_s.id = ts.markv and t_r.id = ts.markg and ts.kend >= 8 and ts.kbeg <= 8 order by ts.datea desc, kdelta asc limit 1select ts.datea as dat, t_s.descr as markv, t_r.descr as markg, ts.ido as ido, abs(ts.kend - ts.kbeg - 14) as kdelta from otklikt as ts, t_road as t_r, t_speed as t_s where ts.ido>0 and ts.idtr = '340' and t_s.id = ts.markv and t_r.id = ts.markg and ts.kend >= 14 and ts.kbeg <= 14 order by ts.datea desc, kdelta asc limit 1select ts.datea as dat, t_s.descr as markv, t_r.descr as markg, ts.ido as ido, abs(ts.kend - ts.kbeg - 21) as kdelta from otklikt as ts, t_road as t_r, t_speed as t_s where ts.ido>0 and ts.idtr = '340' and t_s.id = ts.markv and t_r.id = ts.markg and ts.kend >= 21 and ts.kbeg <= 21 order by ts.datea desc, kdelta asc limit 1select ts.datea as dat, t_s.descr as markv, t_r.descr as markg, ts.ido as ido, abs(ts.kend - ts.kbeg - 30) as kdelta from otklikt as ts, t_road as t_r, t_speed as t_s where ts.ido>0 and ts.idtr = '340' and t_s.id = ts.markv and t_r.id = ts.markg and ts.kend >= 30 and ts.kbeg <= 30 order by ts.datea desc, kdelta asc limit 1 Р40(Куровицы)-Гатчина
Россия: города, достопримечательности
Автопутешествия: зарубежные страны

Р40(Куровицы)-Гатчина

Вопросы о состоянии автодороги можно разместить на форуме, а информацию в разделе состояние трассы Р40(Куровицы)-Гатчина.

км
Легенда трассы: города, интересные места, гостиницы, кафеРейтинг н/пИнформация о состоянии трассы
0Куровицы
пересечение с трассой:
М11(Кемполово) - Выра - Тосно - Шапки
  
4 Кобрино. Музей "Домик няни А.С. Пушкина"
5 Прибытково. Дача адмирала Прибыткова
8Суйда
пересечение с трассой:
12.44 
14Пижма
пересечение с трассой:
Магистральная
  
21Гатчина
пересечение с трассой:
Санкт-Петербург - Псков
Гатчина-М11(Ополье)
365.31 
30 Пудость. Мельница Штакеншнейдера
Яндекс.Метрика
По вопросам сотрудничества и размещения рекламы пишите plo@autotravel.ru