Back
[00:01:41] <ErshKUS> да что такое... уже столько перебрал. Ну нафига пихать '' , нельзя что ли null
[00:05:17] <ErshKUS> тьфу tags @> ('')::hstore
[00:27:40] -!- _sev_ [_sev_!~sev@109.87.142.103] has joined #osm-ru
[00:27:40] -!- _sev has quit [Read error: Connection reset by peer]
[00:31:08] <ErshKUS> AMDmi3: вот еще по каталогу
http://osmru.reformal.ru/proj/?ia=391667
[00:31:39] <AMDmi3> ErshKUS: да, я как рас собирался посмотреть оно всё-таки leisure или amenity, потому что по тэгам их поровну
[00:32:02] <ErshKUS> AMDmi3: ну ок, тогда я спать
[00:32:05] <AMDmi3> ErshKUS: можешь обновить на бете каталог и osm.ru?
[00:32:31] <ErshKUS> AMDmi3: давай завтра, ок?
[00:32:32] <AMDmi3> я добавил description, во-первых, как бы не накосячить, во-вторых, хочу посмотреть что получилось
[00:32:40] <AMDmi3> ну ok, давай завтра
[00:40:49] -!- ErshKUS has quit [Ping timeout: 480 seconds]
[00:44:06] -!- private [private!~private@2.92.196.169] has joined #osm-ru
[00:57:56] -!- dr_mx1 has quit [Quit: Leaving.]
[01:17:59] -!- old_Bibigon has quit [Ping timeout: 480 seconds]
[01:22:08] -!- kisaa [kisaa!~user26@5.8.193.138] has joined #osm-ru
[01:23:41] -!- newbie [newbie!~private@2.92.196.169] has joined #osm-ru
[01:24:26] -!- Mixai[l|ll|lll] [Mixai[l|ll|lll]!me@37.213.143.94] has parted #osm-ru
[01:25:36] -!- vvoovv has quit [Quit: ChatZilla 0.9.89 [Firefox 17.0.1/20121128204232]]
[01:28:34] -!- private has quit [Ping timeout: 480 seconds]
[01:30:25] -!- Zverik_ has quit [Ping timeout: 480 seconds]
[01:31:37] -!- newbie has quit [Read error: Connection reset by peer]
[01:47:04] -!- old_Bibigon [old_Bibigon!~bibigon@static-92-39-68-20.kirov.comstar-r.ru] has joined #osm-ru
[01:48:38] -!- private [private!~private@2.93.126.147] has joined #osm-ru
[02:36:24] -!- _sev_ has quit [Read error: No route to host]
[02:36:42] -!- _sev [_sev!~sev@109.87.142.103] has joined #osm-ru
[02:37:35] -!- jekhor has quit [Ping timeout: 480 seconds]
[02:54:56] -!- old_Bibigon has quit [Remote host closed the connection]
[03:17:36] -!- private has quit [Read error: Connection reset by peer]
[03:23:31] -!- nickoe has quit [Remote host closed the connection]
[03:31:35] -!- nickoe [nickoe!~nickoe@2001:700:303:3:5eff:35ff:fe09:ad17] has joined #osm-ru
[03:44:43] -!- trolleway has quit [Quit: When two people dream the same dream, it ceases to be an illusion. KVIrc 3.4.3 Shiny(svn-3438) http://www.kvirc.net]
[03:56:40] -!- _sev_ [_sev_!~sev@109.87.142.103] has joined #osm-ru
[03:56:48] -!- _sev has quit [Read error: No route to host]
[04:20:21] -!- nickoe has quit [Read error: Operation timed out]
[04:36:18] -!- iav [iav!iav@customer-193.33.livas.lv] has joined #osm-ru
[05:09:37] -!- ambush has quit [synthon.oftc.net oxygen.oftc.net]
[05:09:37] -!- amak has quit [synthon.oftc.net oxygen.oftc.net]
[05:50:35] -!- |newbie| [|newbie|!~swg@178.76.246.190] has joined #osm-ru
[05:56:56] -!- Mezonin has quit [Ping timeout: 480 seconds]
[06:05:18] -!- private [private!~private@2.94.71.150] has joined #osm-ru
[06:23:20] -!- AMDmi3 has quit [Quit: #!/bin/rm]
[06:23:21] -!- iav has quit [Read error: Connection reset by peer]
[06:27:51] -!- iav [iav!iav@customer-193.33.livas.lv] has joined #osm-ru
[07:58:16] -!- _sev__ [_sev__!~sev@109.87.142.103] has joined #osm-ru
[07:58:16] -!- _sev_ has quit [Read error: Connection reset by peer]
[08:38:47] -!- gryphon [gryphon!~gryphon@82.140.120.164] has joined #osm-ru
[08:41:38] -!- Larry0ua has quit [Quit: http://www.mibbit.com ajax IRC Client]
[08:58:42] <|newbie|> по restrictions вопрос. Если я правильно понял, только один случай есть, где from = to, когда restriction = no_u_turn
[08:58:49] |newbie| is now known as Mezonin
[08:59:00] <iav> кажися
[09:00:44] <Mezonin> просто в москве очень много(480) запретов при from = to, где restriction = no left turn
[09:00:56] <Mezonin> это как-то странно.
[09:22:42] <iav> это просто неправильно
[09:22:46] <iav> ересь!
[09:36:02] -!- loir [loir!~loir@n44.jabber.d6.hsdnsrv.net] has parted #osm-ru
[09:37:24] -!- loir [loir!~loir@n44.jabber.d6.hsdnsrv.net] has joined #osm-ru
[09:50:13] -!- ErshKUS [ErshKUS!~ErshKUS@ppp31-192-152-199.tis-dialog.ru] has joined #osm-ru
[09:54:19] -!- private has quit [Read error: Connection reset by peer]
[10:12:35] -!- loir [loir!~loir@n44.jabber.d6.hsdnsrv.net] has parted #osm-ru
[10:16:40] -!- iav has quit [Ping timeout: 480 seconds]
[10:29:38] -!- kisaa has quit [Quit: Leaving.]
[11:15:29] -!- Zverik [Zverik!~zverik@ppp92-100-87-26.pppoe.avangarddsl.ru] has joined #osm-ru
[11:54:27] -!- jekhor [jekhor!~jek@nat3-minsk-pool-46-53-195-29.telecom.by] has joined #osm-ru
[12:01:00] -!- estet has quit [Ping timeout: 480 seconds]
[12:28:31] -!- old_Bibigon [old_Bibigon!~bibigon@91.144.172.20] has joined #osm-ru
[12:30:37] -!- _sev|work has quit [Quit: This computer has gone to sleep]
[12:34:26] -!- ambush [ambush!~nedr@79.173.86.67] has joined #osm-ru
[12:45:53] -!- ErshKUS has quit [Ping timeout: 480 seconds]
[12:49:36] -!- estet [estet!~estet@swsoft-msk-nat.sw.ru] has joined #osm-ru
[12:54:08] -!- lupin-de-mid [lupin-de-mid!~demid@mx.stc-spb.ru] has joined #osm-ru
[13:06:41] -!- old_Bibigon_ [old_Bibigon_!~bibigon@77.72.138.17] has joined #osm-ru
[13:08:33] -!- Larry0ua [Larry0ua!c3a0e9b5@ircip2.mibbit.com] has joined #osm-ru
[13:13:20] -!- old_Bibigon has quit [Ping timeout: 480 seconds]
[13:34:54] -!- jekhor has quit [Ping timeout: 480 seconds]
[13:48:14] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] has joined #osm-ru
[13:49:45] -!- nickoe [nickoe!~nickoe@2001:700:303:3:5eff:35ff:fe09:ad17] has joined #osm-ru
[13:57:12] -!- _sev|work [_sev|work!~sev@188.230.122.226] has joined #osm-ru
[14:14:04] -!- Maks|nossd has quit [Quit: Konversation terminated!]
[14:14:57] -!- nickoe has quit [Read error: No route to host]
[14:15:11] -!- nickoe [nickoe!~nickoe@2001:700:303:3:5eff:35ff:fe09:ad17] has joined #osm-ru
[14:31:56] -!- _sev|work has quit [Quit: This computer has gone to sleep]
[14:33:41] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] has parted #osm-ru
[14:37:04] -!- nickoe has quit [Read error: Connection reset by peer]
[14:37:14] -!- old_Bibigon_ has quit [charon.oftc.net reticulum.oftc.net]
[14:37:14] -!- estet has quit [charon.oftc.net reticulum.oftc.net]
[14:37:14] -!- ambush has quit [charon.oftc.net reticulum.oftc.net]
[14:37:14] -!- shurik has quit [charon.oftc.net reticulum.oftc.net]
[14:37:14] -!- lollo_ has quit [charon.oftc.net reticulum.oftc.net]
[14:37:14] -!- jer0m has quit [charon.oftc.net reticulum.oftc.net]
[14:37:15] -!- estet [estet!~estet@swsoft-msk-nat.sw.ru] has joined #osm-ru
[14:37:29] -!- lollo_ [lollo_!~lollo@95.129.140.248] has joined #osm-ru
[14:37:30] -!- old_Bibigon_ [old_Bibigon_!~bibigon@77.72.138.17] has joined #osm-ru
[14:38:16] -!- ambush [ambush!~nedr@79.173.86.67] has joined #osm-ru
[14:38:16] -!- shurik [shurik!~chatzilla@gw.mosuzedu.ru] has joined #osm-ru
[14:38:16] -!- jerom [jerom!jerom@mp2.macomnet.net] has joined #osm-ru
[14:39:27] -!- nickoe [nickoe!~nickoe@2001:700:303:3:5eff:35ff:fe09:ad17] has joined #osm-ru
[14:40:50] -!- iav_work has quit [resistance.oftc.net larich.oftc.net]
[14:40:50] -!- dezhin|laptop has quit [resistance.oftc.net larich.oftc.net]
[14:41:04] -!- iav_work [iav_work!~iav@80.90.1.92] has joined #osm-ru
[14:46:13] -!- logger[psha] [logger[psha]!~loggerpsh@195.135.238.205] has joined #osm-ru
[14:46:54] -!- _sev|work [_sev|work!~sev@188.230.122.226] has joined #osm-ru
[14:50:25] -!- Mezonin has quit [charon.oftc.net kinetic.oftc.net]
[14:50:25] -!- putnik has quit [charon.oftc.net kinetic.oftc.net]
[14:50:26] -!- psha[work] has quit [charon.oftc.net kinetic.oftc.net]
[14:50:26] -!- gryphon has quit [charon.oftc.net kinetic.oftc.net]
[14:50:26] -!- malenki has quit [charon.oftc.net kinetic.oftc.net]
[14:50:29] -!- putnik [putnik!~putnik@putnik.ws] has joined #osm-ru
[14:50:35] -!- gryphon [gryphon!~gryphon@82.140.120.164] has joined #osm-ru
[14:50:36] -!- malenki_ [malenki_!malenki@harpy.gmake.de] has joined #osm-ru
[14:50:36] -!- psha[work] [psha[work]!~psha@195.135.238.205] has joined #osm-ru
[14:50:54] malenki_ is now known as malenki
[14:52:13] -!- lupin-de-mid has quit [Ping timeout: 480 seconds]
[14:52:22] -!- lupin-de-mid [lupin-de-mid!~demid@mx.stc-spb.ru] has joined #osm-ru
[14:53:21] -!- cherry_l1n [cherry_l1n!~danst@static.148.60.47.78.clients.your-server.de] has joined #osm-ru
[14:53:21] -!- lupin-de-mid has quit [resistance.oftc.net charm.oftc.net]
[14:53:21] -!- psha[work] has quit [resistance.oftc.net charm.oftc.net]
[14:53:21] -!- _sev|work has quit [resistance.oftc.net charm.oftc.net]
[14:53:22] -!- glebius has quit [resistance.oftc.net charm.oftc.net]
[14:53:22] -!- Out`Of`Control has quit [resistance.oftc.net charm.oftc.net]
[14:53:22] -!- cherry_lin has quit [resistance.oftc.net charm.oftc.net]
[14:53:22] -!- glebius [glebius!~glebius@glebius.int.ru] has joined #osm-ru
[14:53:51] -!- lupin-de-mid [lupin-de-mid!~demid@mx.stc-spb.ru] has joined #osm-ru
[14:53:51] -!- _sev|work [_sev|work!~sev@188.230.122.226] has joined #osm-ru
[14:54:17] -!- lupin-de-mid has quit [Remote host closed the connection]
[14:55:57] -!- estet has quit [resistance.oftc.net graviton.oftc.net]
[14:55:57] -!- old_Bibigon_ has quit [resistance.oftc.net graviton.oftc.net]
[14:55:57] -!- _sev__ has quit [resistance.oftc.net graviton.oftc.net]
[14:55:57] -!- Larry0ua has quit [resistance.oftc.net graviton.oftc.net]
[14:55:58] -!- estet_ [estet_!~estet@swsoft-msk-nat.sw.ru] has joined #osm-ru
[14:56:16] -!- old_Bibigon_ [old_Bibigon_!~bibigon@77.72.138.17] has joined #osm-ru
[14:56:16] -!- _sev__ [_sev__!~sev@109.87.142.103] has joined #osm-ru
[14:56:16] -!- nickoe has quit [resistance.oftc.net weber.oftc.net]
[14:56:17] -!- Zverik has quit [resistance.oftc.net weber.oftc.net]
[14:56:17] -!- andrewsh has quit [resistance.oftc.net weber.oftc.net]
[14:56:20] -!- andrewsh_ [andrewsh_!~andrewsh@shadura.me] has joined #osm-ru
[14:56:24] -!- Zverik [Zverik!~zverik@ppp92-100-87-26.pppoe.avangarddsl.ru] has joined #osm-ru
[14:56:26] -!- nickoe [nickoe!~nickoe@m200f.studby.ntnu.no] has joined #osm-ru
[14:59:10] -!- lupin-de-mid [lupin-de-mid!~demid@mx.stc-spb.ru] has joined #osm-ru
[15:00:20] -!- _sev|work has quit [Quit: This computer has gone to sleep]
[15:00:38] -!- psha[work] [psha[work]!~psha@195.135.238.205] has joined #osm-ru
[15:05:29] -!- _sev|work [_sev|work!~sev@188.230.122.226] has joined #osm-ru
[15:10:30] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] has joined #osm-ru
[15:12:13] -!- Larry0ua [Larry0ua!c3a0e9b5@ircip2.mibbit.com] has joined #osm-ru
[15:15:41] andrewsh_ is now known as andrewsh
[15:17:29] -!- Mezonin [Mezonin!~swg@178.76.246.190] has joined #osm-ru
[15:33:53] -!- ErshKUS [ErshKUS!~ErshKUS@ppp31-192-152-199.tis-dialog.ru] has joined #osm-ru
[15:45:45] -!- amak has quit [reticulum.oftc.net synthon.oftc.net]
[15:45:45] -!- Larry0ua has quit [reticulum.oftc.net synthon.oftc.net]
[15:45:45] -!- andrewsh has quit [reticulum.oftc.net synthon.oftc.net]
[15:45:45] -!- ErshKUS has quit [reticulum.oftc.net synthon.oftc.net]
[15:45:45] -!- _sev|work has quit [reticulum.oftc.net synthon.oftc.net]
[15:45:45] -!- lupin-de-mid has quit [reticulum.oftc.net synthon.oftc.net]
[15:46:51] -!- andrewsh [andrewsh!~andrewsh@shadura.me] has joined #osm-ru
[15:46:57] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] has joined #osm-ru
[15:47:09] -!- Larry0ua [Larry0ua!c3a0e9b5@ircip3.mibbit.com] has joined #osm-ru
[15:47:09] -!- ErshKUS [ErshKUS!~ErshKUS@ppp31-192-152-199.tis-dialog.ru] has joined #osm-ru
[15:47:09] -!- _sev|work [_sev|work!~sev@188.230.122.226] has joined #osm-ru
[15:47:09] -!- lupin-de-mid [lupin-de-mid!~demid@mx.stc-spb.ru] has joined #osm-ru
[15:47:35] -!- mode/#osm-ru [+o Komzpa] by ChanServ
[15:48:23] Larry0ua is now known as Guest0
[15:50:20] -!- Mixai[l|ll|lll] [Mixai[l|ll|lll]!~me@37.213.143.94] has joined #osm-ru
[15:50:45] Guest0 is now known as Larry0ua
[15:57:23] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] has parted #osm-ru
[15:57:44] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] has joined #osm-ru
[16:01:09] -!- estet_ has quit [Read error: Connection reset by peer]
[16:01:12] -!- estet [estet!~estet@swsoft-msk-nat.sw.ru] has joined #osm-ru
[16:14:39] -!- _sev|work has quit [Quit: This computer has gone to sleep]
[16:19:35] -!- ambush has quit [Ping timeout: 480 seconds]
[16:24:52] -!- ambush [ambush!~nedr@79.173.86.67] has joined #osm-ru
[16:27:28] -!- Eugene [Eugene!~eugene@91.224.182.162] has joined #osm-ru
[16:28:39] -!- _sev|work [_sev|work!~sev@188.230.122.226] has joined #osm-ru
[16:42:08] -!- _sev|work has quit [Quit: This computer has gone to sleep]
[16:44:12] <Mixai[l|ll|lll]> Ого, Шпаньков из Opera уходит.
[16:55:50] -!- Scondo [Scondo!~Miranda@109.73.9.154] has joined #osm-ru
[16:56:25] -!- _sev|work [_sev|work!~sev@188.230.122.226] has joined #osm-ru
[17:10:20] -!- dr_mx [dr_mx!~drmx@178.76.246.158] has joined #osm-ru
[17:24:46] -!- psha[work] has quit [Quit: Lost terminal]
[17:37:30] -!- nordmike [nordmike!~nordmike@2a00:f480:4:148:dea9:71ff:fe2f:1679] has joined #osm-ru
[17:45:51] -!- _sev__ has quit [Read error: No route to host]
[17:46:01] -!- _sev__ [_sev__!~sev@109.87.142.103] has joined #osm-ru
[17:50:00] -!- gryphon has quit [Remote host closed the connection]
[17:50:13] -!- lupin-de-mid has quit [Ping timeout: 480 seconds]
[17:54:51] -!- lupin-de-mid [lupin-de-mid!~demid@mx.stc-spb.ru] has joined #osm-ru
[17:55:57] -!- nordmike has quit [Quit: Konversation terminated!]
[17:58:39] -!- old_Bibigon_ has quit [Remote host closed the connection]
[18:08:26] -!- estet has quit [Ping timeout: 480 seconds]
[18:10:34] -!- Out`Of`Control [Out`Of`Control!~Viper@000192c2.user.oftc.net] has joined #osm-ru
[18:11:25] -!- estet_ [estet_!~estet@swsoft-msk-nat.sw.ru] has joined #osm-ru
[18:17:24] -!- _sev_ [_sev_!~sev@109.87.142.103] has joined #osm-ru
[18:17:25] -!- _sev__ has quit [Read error: Connection reset by peer]
[18:25:22] -!- Scondo has quit [Quit: Lost in time. And lost in space. And meaning.]
[18:27:28] -!- gryphon [gryphon!~gryphon@net089023017094.pskovline.ru] has joined #osm-ru
[18:32:56] -!- estet___ [estet___!~estet@swsoft-msk-nat.sw.ru] has joined #osm-ru
[18:33:48] -!- psha [psha!~psha@213.208.162.67] has joined #osm-ru
[18:34:51] -!- estet_ has quit [Ping timeout: 480 seconds]
[18:46:05] -!- private [private!~private@78-106-239-24.broadband.corbina.ru] has joined #osm-ru
[18:55:01] -!- Eugene [Eugene!~eugene@91.224.182.162] has parted #osm-ru
[18:55:38] -!- Eugene [Eugene!~eugene@91.224.182.160] has joined #osm-ru
[18:56:04] -!- Eugene [Eugene!~eugene@91.224.182.160] has parted #osm-ru
[18:58:51] -!- private has quit [Read error: Connection reset by peer]
[19:02:14] -!- old_Bibigon [old_Bibigon!~bibigon@static-92-39-68-20.kirov.comstar-r.ru] has joined #osm-ru
[19:03:27] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] has parted #osm-ru
[19:03:48] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] has joined #osm-ru
[19:07:59] -!- gryphon has quit [Remote host closed the connection]
[19:15:47] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] has parted #osm-ru
[19:16:06] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] has joined #osm-ru
[19:22:52] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] has parted #osm-ru
[19:23:12] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] has joined #osm-ru
[19:28:04] -!- estet___ has quit [Quit: leaving]
[19:38:23] -!- cherry_l1n has quit [Server closed connection]
[19:38:25] -!- cherry_lin [cherry_lin!~danst@static.148.60.47.78.clients.your-server.de] has joined #osm-ru
[19:38:57] -!- ambush has quit [Ping timeout: 480 seconds]
[19:39:53] -!- loir [loir!~loir@n44.jabber.d6.hsdnsrv.net] has joined #osm-ru
[19:50:56] -!- lupin-de-mid has quit [Ping timeout: 480 seconds]
[20:03:17] <putnik> Все уже видели
http://csstardis.co.uk/? =)
[20:04:49] <andrewsh> bigger on the inside?
[20:06:22] <andrewsh> шрифты пичалька
[20:16:07] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] has parted #osm-ru
[20:16:25] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] has joined #osm-ru
[20:27:47] -!- ambush [ambush!~nedr@79.173.86.67] has joined #osm-ru
[20:50:01] -!- Scondo [Scondo!~Miranda@mariyaz.starlink.ru] has joined #osm-ru
[21:04:35] -!- Mixai[l|ll|lll] [Mixai[l|ll|lll]!~me@37.213.143.94] has parted #osm-ru
[21:05:17] -!- Mixai[l|ll|lll] [Mixai[l|ll|lll]!~me@37.213.143.94] has joined #osm-ru
[21:16:11] -!- dr_mx has quit [Server closed connection]
[21:16:51] -!- Out`Of`Control has quit [Server closed connection]
[21:17:11] -!- psha has quit [Server closed connection]
[21:17:12] -!- psha [psha!~psha@213.208.162.67] has joined #osm-ru
[21:17:22] -!- dr_mx [dr_mx!~drmx@178.76.246.158] has joined #osm-ru
[21:31:42] malenki is now known as malade
[21:34:24] <Scondo> Говорили, что где-то на форуме есть тема про БД на рамблере - что там крутится у кого... не могу найти...
[21:54:06] -!- FelisPimeja [FelisPimeja!~quassel@178.176.183.128] has joined #osm-ru
[22:01:16] -!- ambush has quit [Remote host closed the connection]
[22:01:53] -!- ambush [ambush!~nedr@79.173.86.67] has joined #osm-ru
[22:11:17] <old_Bibigon> на вики есть, хз какой свежести
[22:11:45] <old_Bibigon> ErshKUS, тыц? ^^
[22:17:42] <Zverik> Scondo: в вики же
[22:17:47] <Zverik> фш вики рамблер
[22:17:54] <Zverik> а, блин, он же издох
[22:18:02] <Scondo> Zverik: нашел уже... ничего интересного, но нашел...
[22:19:24] <Scondo> Один симпл и один апи... раельной геометрией никто не пользуется?
[22:19:57] <Zverik> Scondo: если туда случайно поставить постгис, сразу все начнут тайлы делать, а это пока, если не ошибаюсь, нежелательно
[22:21:01] <Scondo> Zverik: Ну не знаю... по-моему это вопрос допуска проектов, а не наличия БД.
[22:32:01] -!- old_Bibigon has quit [Ping timeout: 480 seconds]
[22:37:59] -!- FelisPimeja has quit [Remote host closed the connection]
[22:39:32] <ErshKUS> Scondo: '...раельной геометрией никто не пользуется?' а что за реальная? апи уже давно отключена, не юзают. А симпл застопарилась на сентябре. Сейчас идет миграция на 9.2, хз как идет. Я так понимаю там будет поднята симпл, но не ясно нужна ли она кому н
[22:39:32] <ErshKUS> ибудь
[22:40:46] <Scondo> Понятно... просто как каждый джанговец должен написать свой шаблоонизатор, так каждый осмер должен написать свой импортер :) Вот я хотел посмотреть кому что надо...
[22:42:01] <ErshKUS> Scondo: да хотели порядок навести, думаю даже хотят, но это пока медленно идет
[22:42:55] <ErshKUS> Scondo: мне оказалось действенее поднять свою базу, ибо вырезать из мира Россию кушало дофига времени
[22:43:10] <Scondo> Ну в общем попробую посочинять, а там посмотрим..
[22:44:15] <ErshKUS> Scondo: а что ты собрался сочинять, свою схему для апи? для симпл то и сочинять нечего, бери и грузи :)
[22:44:46] <ErshKUS> Scondo: но это так, просто интересно
[22:44:52] <Scondo> ErshKUS: Вот мне нужна схема не менее "осмовская" чем снапшот и не менее "геометрическая" чем osm2pgsql
[22:46:09] <Scondo> Ну ладноЮ из напшота точки без тегов мне не нужны. Но нужна вся связь между релейшнами, веями и нодами. чего нет в osm2pgsql. (точнеее есть, но через слим и очень грустняво)
[22:46:55] <ErshKUS> тебе для этого, забыл... заме кладра ?
[22:46:57] -!- Hind [Hind!57e40b03@ircip2.mibbit.com] has joined #osm-ru
[22:47:17] <Hind> У всех глагне говорит HTTP Error 500?
[22:47:23] <Hind> Application error
[22:47:52] <Scondo> Hind: нет, вроде работает
[22:48:04] <ErshKUS> Hind: работает
[22:48:17] <Hind> а если Ctrl+F5?
[22:48:23] <Hind> очистив кэш, проще говоря
[22:48:40] <Scondo> ErshKUS: Там я пока выкрутился. Но пока и некрасиво. А есть и еще задумки.
[22:48:40] <Scondo> Плюс у меня тупо osm2pgsql на триггерах виснет. х.з. почему.
[22:49:30] <ErshKUS> Hind: работает
[22:49:52] <ErshKUS> Scondo: триггера pg?
[22:50:00] <Scondo> ErshKUS: ухху.
[22:50:22] <ErshKUS> а на малых данных виснит
[22:50:24] <ErshKUS> ?
[22:50:26] <Scondo> Кстати, про osm.org.ru. Win8+ chrome - не скроллится мышкой (пальцем скроллится и зумится).
[22:51:21] <Scondo> ErshKUS: Не проверял как-то даже. Я как уперся в триггера, потыкал-потыкал, а потом прикинул, что уже неплохо оптимизировал основной скрипт и махнул рукой.
[22:51:56] <ErshKUS> Scondo: со скролом разобратся нужен спец, я хз
[22:52:14] <Scondo> В общем когда запись одну удаляю - все отрабатывает. А при импорте - повисает, болтается постгревый процесс со статусом DELETE waiting
[22:52:24] <ErshKUS> Scondo: у тебя мог уперется в нехватку памяти, пошел своп и....
[22:53:17] <Scondo> ErshKUS: Вообще не похоже. Потому что то же самое без триггеров - на ура. При том что триггера только на удаление.
[22:53:29] <ErshKUS> Scondo: попробуй через анализ погонять
[22:53:52] <ErshKUS> ну а как ты удаляешь? по условию есть индексы?
[22:53:52] <Scondo> Какой?
[22:54:18] -!- Hind has quit [Quit: http://www.mibbit.com ajax IRC Client]
[22:54:41] <Scondo> могут быть... ща..
[22:55:39] <Scondo> да, есть...
[22:56:22] -!- psha has quit [Quit: Lost terminal]
[22:56:33] <ErshKUS> Scondo: как называется то классификатор, а то ступор
[22:56:40] <Scondo> ФИАС :)
[22:56:46] <ErshKUS> :)
[22:57:45] <iav_work> откуда берут карты высот?
[22:58:04] <Mixai[l|ll|lll]> Куда этот Felis Pimeja убежал. Для того, чтобы абузить то дело нужно являться "владельцем авторских прав или лицом, имеющим право действовать от имени владельца"
[22:58:05] <Scondo> iav_work: SRTM как правило.
[22:58:42] <iav_work> а это где именно?
[22:58:47] <iav_work> мне для латвии
[22:59:17] <Scondo> iav_work: e.g.
http://gis-lab.info/qa/srtm.html
[22:59:59] <Mixai[l|ll|lll]> А еще там нужна ЭЦП :D
[23:01:18] <ErshKUS> Scondo: а анализ я про EXPLAIN
[23:01:43] <Scondo> ErshKUS: Что мне эксплейн если одиночное удаление рпоходит?
[23:03:35] <ErshKUS> Scondo: ну если у тебя Seq Scan ?
[23:03:56] <iav_work> и перестроение тонны индексов
[23:03:57] <ErshKUS> вот и повисание, хотя оно конечно не всегда долго
[23:04:05] <iav_work> нене, пусть объяснится
[23:04:23] -!- old_Bibigon [old_Bibigon!~bibigon@static-92-39-68-20.kirov.comstar-r.ru] has joined #osm-ru
[23:04:33] <Scondo> Нет, проблема именно в дедлоке, нагрузка на проц и хдд - 0. вот в чем проблема.
[23:05:18] <Scondo> если бы он считал и висел - я бы ждал пока не досчитает...
[23:05:20] <ErshKUS> Scondo: ты руками такое удаление пробовал делать?
[23:05:33] <Scondo> ErshKUS: Да, говорю же - проходит.
[23:06:11] <ErshKUS> Scondo: а самозацикливания нет?
[23:06:44] <iav_work> с триггерами зациклить как здрасте
[23:07:09] <Scondo> ErshKUS: у триггеров нет. Только если двойное удаление, но от этого не должен.
[23:07:54] <ErshKUS> Scondo: ищи гдето там, ибо тригер тупо выполняет запрос
[23:08:01] <Scondo> То есть каждый триггер вызывает удаление либо в той же таблице, либо в следующей. Ничег кроме удаления нет.
[23:08:06] <ErshKUS> и если он так быстро
[23:08:16] <ErshKUS> то значит что то не то удаляет
[23:08:19] <Scondo> Меня собсно смущает, что одиночный выполняется.
[23:08:23] -!- Zverik_ [Zverik_!~zverik@ppp92-100-109-64.pppoe.avangarddsl.ru] has joined #osm-ru
[23:09:04] <ErshKUS> посмотри может в логах pg, хотя вроде сначало нужно включить, чтоб pg логировал все sql запросы
[23:10:08] <Scondo> ErshKUS: А он запросы триггеров будет логировать при этом?
[23:11:33] <ErshKUS> должен, я такое не делал
[23:12:12] <Scondo> Потому что я запросами вытащил текущий исполняемый, но без запросов от триггеров...
[23:12:50] <ErshKUS> но с триггерами никогда н было проблем, а вот если не доглядишь и один пинает другого а тот его, вот тут висло
[23:14:33] -!- Zverik has quit [Ping timeout: 480 seconds]
[23:16:21] <Scondo> ErshKUS: Ну я посмотрю еще. Или если найдешь косяк - пиши
https://github.com/Scondo/fiosm/blob/master/fiosm/fias_search.py#L36
[23:16:21] <Scondo> Это мио превые триггеры, так что мог налажать...
[23:17:04] <ErshKUS> Scondo: хочется попробывать обработать фиас по моей адресной таблице, но времени нет :(
[23:17:54] -!- _sev_ has quit [Quit: This computer has gone to sleep]
[23:19:44] -!- _sev [_sev!~sev@109.87.142.103] has joined #osm-ru
[23:23:10] <ErshKUS> Scondo: я так понял тут зацикливание on_del_place
[23:24:18] <ErshKUS> Scondo:
https://github.com/Scondo/fiosm/blob/master/fiosm/fias_search.py#L94
[23:24:24] <ErshKUS> я спать
[23:26:18] <Scondo> ErshKUS: при удалении улиц тоже вроде вешался...
[23:26:44] <Scondo> ErshKUS: ладно, не горит. я сам еле живой..
[23:27:25] <ErshKUS> Scondo: ну может триггер не сам себя, а цепочка
[23:33:35] <shurik> Scondo: я считаю нужен постпроцессор к simple который будет строить в отдельной таблице мультиполигоны в том же формате, чтобы с помощью union объединять... и в идеале надо уметь их обновлять из .osc
[23:34:02] <shurik> всё это нужно далеко не только для рендерера
[23:34:28] <Scondo> shurik: ага, я думал в том же направлении. Но почему в отдельной таблице? Что бы не рядом с нодами/веями/полигонами?
[23:34:56] <shurik> потому что их мейнтейнит osmosis
[23:35:15] <shurik> у каждого должна быть своя зона ответственности
[23:36:31] <ErshKUS> shurik: а я как то уже привык в FROM указывать relations,relation_members,ways :)
[23:37:39] <shurik> ну это слабо помогает если например нужно проверять попадание внутрь административной границы
[23:38:00] <ErshKUS> shurik: ну тогда + 1 left join
[23:38:32] <ErshKUS> ну конечно это не есть удобно
[23:39:50] <ErshKUS> прикольно, osmosis не может мержить в исходную таблицу, точнее мержит, но данные первого pdf теряется :(
[23:39:56] <Scondo> shurik: В общем все логично. Только осмосис несколько пугает. И да, он не умеет o5m.
[23:45:26] -!- loir [loir!~loir@n44.jabber.d6.hsdnsrv.net] has parted #osm-ru
[23:45:39] -!- loir [loir!~loir@n44.jabber.d6.hsdnsrv.net] has joined #osm-ru
[23:48:44] <Scondo> А еще вопрос по pgsnapshot|pgsimple.... нахрена ему TABLE way_nodes , если есть nodes bigint[] ?