00:03:41 *** D3f0 has quit (Read error: 104 (Connection reset by peer)) 00:44:35 <CIA-6> mapnik-utils: cmarqu42 * r601 /sandbox/cascadenik/hike_n_bike/ (8 files): Support shop=bicycle; rails are a WIP (trying to fix the bridges); route tweaks; use extent; etc. 02:28:08 *** rcoup has quit (brown.freenode.net irc.freenode.net) 02:28:08 *** Berteun has quit (brown.freenode.net irc.freenode.net) 02:28:08 *** dibblego has quit (brown.freenode.net irc.freenode.net) 02:28:08 *** aled has quit (brown.freenode.net irc.freenode.net) 02:28:08 *** cmarqu has quit (brown.freenode.net irc.freenode.net) 02:28:41 *** rcoup (n=rcoup@ip-118-90-116-120.xdsl.xnet.co.nz) has joined #mapnik 02:28:41 *** dibblego (n=nobody@220-245-107-64.static.tpgi.com.au) has joined #mapnik 02:28:41 *** aled (n=chatzill@socksgw4.ncl.ac.uk) has joined #mapnik 02:28:41 *** cmarqu (i=colin@oemcomputer.oerks.de) has joined #mapnik 02:28:41 *** Berteun (i=berteun@berteun.nl) has joined #mapnik 04:11:30 *** rcoup has quit () 04:13:05 *** D3f0 (n=defo@190.176.255.232) has joined #mapnik 05:10:29 *** D3f0 has quit (Remote closed the connection) 06:55:08 *** scruggs_ has quit (Read error: 113 (No route to host)) 06:55:26 *** scruggs has quit (Read error: 110 (Connection timed out)) 07:22:28 *** vosson (n=chatzill@193.91.181.126) has joined #mapnik 07:31:14 *** scruggs (n=chris@72-161-97-59.dyn.centurytel.net) has joined #mapnik 07:32:27 *** scruggs_ (n=chris@72-161-97-59.dyn.centurytel.net) has joined #mapnik 07:55:21 *** xcacou (n=aga@AToulouse-157-1-58-12.w86-207.abo.wanadoo.fr) has joined #mapnik 09:35:40 *** rcoup (n=rcoup@ip-118-90-56-192.xdsl.xnet.co.nz) has joined #mapnik 10:51:44 *** rcoup has quit () 12:17:32 *** SandGorgon (n=user@122.162.233.169) has joined #mapnik 12:57:05 *** SandGorgon has quit (Read error: 110 (Connection timed out)) 13:58:36 *** D3f0 (n=defo@190.176.255.232) has joined #mapnik 14:54:15 *** SandGorgon (n=user@122.163.208.158) has joined #mapnik 15:06:25 *** vosson has quit (Read error: 60 (Operation timed out)) 15:16:16 *** SandGorgon has quit (Read error: 110 (Connection timed out)) 15:16:22 *** SandGorgon (n=user@122.163.210.115) has joined #mapnik 15:56:53 *** darragh (n=darragh@83.70.173.25) has joined #mapnik 16:02:55 *** SandGorgon has quit ("Leaving") 16:21:26 *** iwillig (n=ivan@topp-office-nyc.openplans.org) has joined #mapnik 16:41:39 *** xcacou has quit (Remote closed the connection) 16:52:30 *** Davedan (n=me@89.138.13.79) has joined #mapnik 16:53:07 <Davedan> why the ubuntu installation instruction doesn't use the ubuntu package? http://trac.mapnik.org/wiki/UbuntuInstallation 16:53:22 <Davedan> do I really need to follow all this steps?? 17:07:38 *** iwillig has quit (Read error: 113 (No route to host)) 17:17:10 *** D3f0 has quit (Read error: 104 (Connection reset by peer)) 18:19:48 <Scelestis> How are the filter lines parsed in the osm.xml, can any sql query be put there? I am trying to do an elaborate filter with St_within 18:20:52 <tomhughes> no, the filters are in mapnik's own language 18:21:07 <tomhughes> you can do whatever filters you want in the SQL when you define a PostGIS layer though 18:21:29 <tomhughes> but that applies to all styles based on that layer then 18:22:21 <Scelestis> well hot damn, that's even easier 18:23:07 <tomhughes> you just give the table name as a subquery IIRC - look at osm.xml to see what I mean 18:23:44 <tomhughes> <Parameter name="table"> 18:23:45 <tomhughes> (select way,highway,landuse,"natural",man_made,waterway,tourism,learning,a 18:23:45 <tomhughes> menity,place,name,ref,oneway,char_length(ref) as length from planet_osm_line whe 18:23:45 <tomhughes> re waterway IS NULL and leisure IS NULL and landuse IS NULL) as roads 18:23:46 <tomhughes> </Parameter> 18:23:46 <tomhughes> for example 18:26:49 *** darragh has quit (Remote closed the connection) 18:27:30 <Scelestis> is this syntax proper: WHERE table = 'something' OR table = 'somethingelse' AND table2 = 'something3' 18:28:09 <Scelestis> will that return all rows with something and something3, as well as somethingelse and something3 ? 18:29:22 <Scelestis> actually I am not sure that's necessary, since the style itself will parse out the first parts... 18:31:08 <tomhughes> um - is table a field there? 18:33:08 <Scelestis> I think column would have been better for me to put there 18:33:33 <tomhughes> it's fine, but you might want some parentheses to make the order of the and's and or's clear 18:33:51 <tomhughes> or write "column in ('something', 'somethingelse') 18:34:00 <tomhughes> instead of the or 18:35:16 <Scelestis> SELECT * FROM planet_osm_point WHERE (place = 'town' OR place = 'city') AND St_within(way, something) = '1' 18:35:38 <Scelestis> so if something has place as town and if the within is met, that works 18:36:03 <Scelestis> and if place is city, and also meets st_within, that works 18:36:15 <tomhughes> should do, but your big problem will be the second argument to the st_within ;-) 18:36:34 <tomhughes> as the radius you want will probably need to depend on the scale which I don;t think you can do 18:36:47 <Scelestis> oh my actual st_within line is giant 18:37:14 <tomhughes> it's almost certainly the wrong way to solve the problem people have been discussing on the osm list anyway ;-) 18:37:25 <Scelestis> hah 18:38:04 <Scelestis> yeah, I am making a polygon bounding box of the USA, then comparing that to the way column in planet_osm_points 18:38:13 <tomhughes> the way to solve that is probably to find an ordering that puts the most important places first then let mapnik's collision detector drop the ones which won't fit 18:38:59 <Scelestis> mapnik has some form of collision dection you say? =) 18:39:27 <tomhughes> yes - that's what causing the problem - it won't draw a place name that would conflict with things it has already drawn 18:39:45 <tomhughes> so you need to draw the most important places first 18:41:51 <Scelestis> hmm, I don't think I am drawing them more than once though, my idea was to create a layer that is excluding certain areas to beginwith, and never draw them at any point 18:50:08 *** iwillig (n=ivan@194-239-234-66.static.cosmoweb.net) has joined #mapnik 19:01:34 <jburgess> I would be tempted to perform the st_within() up front. Either by selecting the data into a new table, or deleting anything which does not meet the criteria from the existing tables 19:25:13 *** Scelestis has quit (Read error: 110 (Connection timed out)) 20:00:55 *** rcoup (n=rcoup@203.152.105.182) has joined #mapnik 20:34:09 *** lucadelu (n=lucadelu@host252-18-dynamic.8-87-r.retail.telecomitalia.it) has joined #mapnik 20:34:49 <lucadelu> hi everybody 20:35:28 <lucadelu> I have some problem, someone can help me? 20:55:21 <nikq> Mapnik Trac: Changeset [1018]: support for different icon types (uncrypted, crypted, WEP) | http://trac.mapnik.org/changeset/1018 21:19:52 <nikq> Mapnik Trac: PluginArchitecture edited | http://trac.mapnik.org/wiki/PluginArchitecture?version=10 21:21:49 <nikq> Mapnik Trac: PluginArchitecture edited | http://trac.mapnik.org/wiki/PluginArchitecture?version=11 21:22:44 <Davedan> I'm trying to render OSM. when calling source./set-mapnik-env I get 21:22:50 <Davedan> bash: user: command not found 21:23:20 <Davedan> where 'user' is the name of the user I'm running as which is also a superuser in postgresql 21:29:14 <Davedan> found the issue 21:29:57 <Davedan> in the set-mapnik-env the default username is with wrong commas. is this the right place to report the issue? 22:13:14 *** weizhuo (n=chatzill@nat/yahoo/x-89a7a0c3f71dbab8) has joined #mapnik 22:22:57 *** weizhuo has quit (Remote closed the connection) 22:23:30 *** weizhuo (n=chatzill@nat/yahoo/x-66756d12353dc631) has joined #mapnik 22:46:44 *** iwillig has quit (Read error: 110 (Connection timed out))