00:33:23 <rcoup> springmeyer: back? :) 00:34:32 <springmeyer> :) yep 00:34:38 <springmeyer> hey rcoup 00:35:02 <springmeyer> Davedan2: really big :) you can find stats on the openstreetmap site 00:36:10 <rcoup> springmeyer: looking into vector symbols a bit further - is there currently a way to specify a symbol based on an attribute? 00:36:29 <rcoup> besides defining a rule for every attribute value 00:37:58 <springmeyer> hmm, not sure 00:38:01 <Davedan2> springmeyer: where can I find generate_tiles.py ? 00:38:03 <springmeyer> you mean in c++ or python? 00:38:09 <springmeyer> .g generate_tiles.py 00:38:09 <nikq> springmeyer: http://svn.openstreetmap.org/applications/rendering/mapnik/ 00:39:51 <Davedan2> nikq: after using generate_tiles.py Apache should be able to serve the tiles and openLayers should be able to fetch them? 00:40:13 <springmeyer> nikq is a bot :) 00:40:43 <springmeyer> .g phenny 00:40:43 <nikq> springmeyer: http://inamidst.com/phenny/ 00:40:57 <springmeyer> nikq accepts those commands ^^^^ 00:41:52 <springmeyer> Davedan2: Yes, you can generate a tileset using generate_tiles.py then, copy them to a web accessible location, then either point Google Maps JS or OpenLayers js at them 00:42:00 <Davedan2> ok :) 00:42:50 <Davedan2> springmeyer: I didn't thought I can use Gmap js for that. 00:43:14 <springmeyer> ah, why? 00:43:28 <Davedan2> thought it is only for displaying google maps 00:43:40 <Davedan2> I think I understand the proccess 00:44:09 <springmeyer> oh, well right 00:44:10 <Davedan2> now I need to calclulate the costs which will be allot higher then I thought and asking from someone rich to give me some money :) 00:44:13 <springmeyer> depends on what you want to do 00:44:32 <springmeyer> but Gmaps can be configured to add OSM tiles as an overlay is all I meant 00:44:41 <springmeyer> but ya it's unlikely you want to do that :) 00:44:50 <Davedan2> ok, I knew about overlays 00:45:08 <springmeyer> Davedan2: costs? what do you mean? 00:45:40 <Davedan2> springmeyer: I understand that to be able to have a google maps like service I need something like 5TB 00:46:10 <Davedan2> springmeyer: and then there are the band width costs 00:46:18 <springmeyer> ah, I'm not following you... 00:46:45 <Davedan2> I want to have a map like the OSM slippy map 00:47:04 <Davedan2> and I understand that the tiles images on disk are around 5TB 00:47:05 <springmeyer> I'm just referring to the gmaps javascript api, nothing more 00:47:35 <Davedan2> I understand what you were referring to 00:47:37 <springmeyer> Davedan2: well if you want to serve tiles at every zoom level for the whole world, sure 00:47:49 <springmeyer> but do you really need to do that? :) 00:48:05 <Davedan2> not sure 00:48:11 <springmeyer> what is your use case? do you really need to cache tiles even? 00:48:15 <Davedan2> does google give every zoom level? 00:48:57 <Davedan2> I want something like http://trailmapping.com/ 00:48:59 <springmeyer> well, zoom levels are just predetermined scales, you can use just a few or many 00:49:20 <springmeyer> ha, nice I know the fellow that put that together 00:49:37 <Davedan2> springmeyer: don't worry I won't still his idea :) 00:49:58 <Davedan2> springmeyer: it's something different but with similar requirements 00:50:11 <springmeyer> no worries, just remember the site :) 00:50:22 <springmeyer> I just/just 00:50:23 <Davedan2> actually this is more like what I want to do http://www.gpsies.com/home.do 00:50:52 <Davedan2> are you working in the geo industry because I think I saw a project of yours on bitbucket 00:50:59 <Davedan2> something about a lite tile server? 00:51:40 <springmeyer> yes, that is me 00:52:21 <Davedan2> are you related to mapnik? 00:52:28 <springmeyer> TileLite is dependent on mapnik trunk so I would not recommend it 00:52:41 <springmeyer> unless you want to learn how to compile mapnik from source ;) 00:53:05 <springmeyer> Davedan2: lots of questions! 00:53:17 <Davedan2> springmeyer: yes... :) 00:53:22 <Davedan2> sorry 00:53:50 <springmeyer> maybe you could state your purpose/interests 00:54:46 <Davedan2> springmeyer: I'm starting a project and I didnt' estimated properly the amount of work 00:55:09 <Davedan2> springmeyer: maybe I'll look for partners sometime soon 01:05:58 <springmeyer> heh, well its better to know that up front that down the road. 01:06:17 <springmeyer> but I gather you may be overthinking you need for custom rendering 01:06:26 <springmeyer> perhaps you can use Cloudmade tiles? 01:06:58 <Davedan2> springmeyer: probably I can 01:07:23 <Davedan2> springmeyer: usualy I like to experiment with the basics and then interesting ideas evolves 01:33:08 <rcoup> did any work get done on virtual datasources? eg. just creating feature objects in memory? 01:33:20 <rcoup> i see there is an ogr input plugin now 01:33:47 <rcoup> could always just add rows to an in-memory sqlite DB :) 01:34:47 <rcoup> hrm, it doesn't support that. 01:36:37 <springmeyer> yes, leslie wu got in memory points working 01:36:48 <springmeyer> and that landed in trunk a few months back 01:37:05 * rcoup remembered a post on mapnik-dev, but i can't find it 01:37:29 <springmeyer> ya, I can track it down i think 01:37:35 <springmeyer> this is the script I used to test: 01:37:36 *** springmeyer has parted #mapnik () 01:37:46 *** springmeyer (n=dane@c-24-19-50-92.hsd1.wa.comcast.net) has joined #mapnik 01:37:48 <springmeyer> http://mapnik-utils.googlecode.com/svn/example_code/memory_datasource/sea.py 01:39:43 <springmeyer> weird, the ticket on trac is messed up: http://trac.mapnik.org/ticket/113 01:40:18 <springmeyer> r790 01:40:18 <nikq> http://trac.mapnik.org/changeset/790, at , by artem: + applied python_point_datasource.patch from lwu 01:40:32 <springmeyer> cool, at least that works 01:40:38 <rcoup> ta 01:48:31 *** Davedan2 has parted #mapnik () 03:43:26 <springmeyer> huh, trac magically working now: http://trac.mapnik.org/ticket/113 04:42:37 *** rcoup has quit () 06:06:57 *** __d3f0__ has quit (Read error: 54 (Connection reset by peer)) 06:26:51 *** D3f0 (n=defo@190.177.8.65) has joined #mapnik 06:28:01 *** D3f0 has quit (Read error: 104 (Connection reset by peer)) 09:03:01 *** rafael89 (n=rafael@180.17-224-89.dsl.completel.net) has joined #mapnik 09:04:07 *** rafael89 has quit (Client Quit) 10:23:14 *** vosson (n=chatzill@193.91.181.126) has joined #mapnik 10:37:24 *** Foriskak has quit (Remote closed the connection) 10:40:57 *** xcacou (n=aga@AToulouse-157-1-58-12.w86-207.abo.wanadoo.fr) has joined #mapnik 10:46:13 <nikq> Mapnik Trac: xml_register_fonts_and_directories_of_fonts_fix.patch attached to Ticket #168 | http://trac.mapnik.org/attachment/ticket/168/xml_register_fonts_and_directories_of_fonts_fix.patch 11:15:29 *** benc1 (n=me@85-250-137-91.bb.netvision.net.il) has joined #mapnik 11:15:37 *** benc1 has parted #mapnik () 11:15:52 *** dbaker (n=me@85-250-137-91.bb.netvision.net.il) has joined #mapnik 11:18:54 <vosson> Struggeling with asian TrueType fonts in Mapnik. Tried installing ttf-arphic-uming on ubuntu, but don't understand how I shall tell mapnik about this. Help is highly appreciated 11:41:29 <w0lfie_> it can't find the font? 12:13:18 <vosson> No, can't find the font. 12:19:37 <w0lfie_> do you have the name right? 12:20:44 <w0lfie_> you need to use the name + style 12:20:48 <w0lfie_> so if fc-list says something like.. 12:20:55 <w0lfie_> DejaVu Sans:style=Book 12:21:15 <w0lfie_> you'd do something like.. TextSymbolizer('NAME', 'DejaVu Sans Book', 12, Color('black')) 12:40:55 *** ronny_ (n=ronny@p5B2655A9.dip.t-dialin.net) has joined #mapnik 12:41:07 *** ronny_ is now known as Kellertuer 12:41:55 <Kellertuer> Hi, does anybody have an idea, why the OSM Webfronted Mapnik renderer only renders uniform gray images? 12:44:15 <w0lfie_> it seeks neutral tones 12:44:24 <w0lfie_> what are you talking about specifically? 12:45:19 <vosson> Should I place the font ttc file in the /usr/local/lib64/mapnik/fonts folder? 12:45:38 <Kellertuer> hm i ment the whole map i specify in the OSM->Export is generated and gets into my homefolder but the map.png ist just one tone gray 12:45:55 <Kellertuer> so actually nothing is rendered at all 12:46:06 <w0lfie_> what OSM? 12:46:08 <w0lfie_> the website? 12:46:43 <w0lfie_> vosson, as long as fontconfig can find it, should be fine 12:47:01 <Kellertuer> jap directly on the osm Website the export panel 12:47:43 <w0lfie_> works for me 12:49:00 <Kellertuer> hm, didn't work the last two days for me, neither in Safari nor Firefox (Max OS X) 12:49:02 <vosson> I'm on ubuntu. Can't see fontconfig on the system. Can see it with apt-cache search fontconfig. Should I install it? 12:49:21 <w0lfie_> may as well 12:50:59 <Kellertuer> hm opera does the deal. Dunno whats wrong with firefox/safari here ;) 12:51:35 *** jbglaw has parted #mapnik () 12:52:43 <w0lfie_> i dunno 12:52:48 <w0lfie_> my macos safari doesnt work with it either 12:55:56 <Kellertuer> hm strange, it worked the last time i wanted to export a picture of my favourite area i'm working on (just to document the process) 12:56:09 <w0lfie_> stupid macs 12:56:38 <vosson> installed fontconfig 12:57:19 <vosson> It's not a commandline tool is it? How can I tell if it finds particular fonts? 12:57:34 <w0lfie_> you type fc-list 12:57:52 <vosson> Hey, cool 12:58:02 <w0lfie_> i told you that like 30 minutes ago ;p 12:58:02 <Kellertuer> ;) macs are nice for day to day use as long as you don't want to do very special stuff. 13:03:43 <vosson> Embaressed :-) 13:06:20 <vosson> I have a font that was recommended on the OSM Wiki for Asia. In fc-list it looks like: "AR PL Uming CH:style=Light". How do I refer to that in mapnik xml? 13:08:36 <w0lfie_> i already told you 13:09:05 <w0lfie_> AR PL Uming CH Light 13:09:38 <w0lfie_> nite 13:10:10 <vosson> Yeah, I know I seem slow here :p But I tried that and I got "Unable to find specified font face" 13:27:14 <w0lfie_> then its not installed properly 14:13:35 <vosson> I got it working now. Placed the ttf file in /usr/local/lib64/mapnik/fonts/ . Then i fired up python and did "from mapnik import *" and listed the available fonts with for fname in FontEngine.face_names(): print fname 14:15:02 <vosson> Shareware fonts from www.code2000.net works great even for asian fonts. Recommend it. 14:26:35 *** vosson has quit (Read error: 60 (Operation timed out)) 14:46:43 *** vosson (n=chatzill@126.80-202-247.nextgentel.com) has joined #mapnik 15:48:48 *** Kellertuer has parted #mapnik () 15:55:06 *** vosson has quit (Read error: 110 (Connection timed out)) 15:57:03 *** D3f0 (n=defo@190.177.8.65) has joined #mapnik 17:17:47 *** synax (n=synax@24.222.57.182) has joined #mapnik 17:18:06 <synax> hey all, anyone breathing in here? 17:18:08 *** xcacou has quit (Remote closed the connection) 17:19:12 <springmeyer> :) 17:19:16 <synax> I'm trying to bulid mapnik on OS X, but the scons step is choking on boost libs... I've tried all the suggestions in the documentation, but it still won't find my boost libs 17:19:26 <springmeyer> what mapnik version? 17:19:30 <synax> 0.51 17:19:44 <springmeyer> willing to try svn? 17:19:48 <synax> sure 17:19:53 <springmeyer> lots of better scons support has been added 17:19:55 <springmeyer> but.... 17:20:13 <springmeyer> before you do can you http://dpaste.com your 'config.log' file that is output by scons 17:20:19 <springmeyer> in the root mapnik source directory? 17:20:28 <synax> sure 17:21:42 <synax> springmeyer: http://dpaste.com/16993/ 17:22:32 <springmeyer> on mac os? 17:22:40 <synax> yep 17:22:42 <springmeyer> how did you build/install boost? 17:22:47 <synax> bjam 17:23:13 <springmeyer> okay, looks like you are missing boost system 17:23:40 <synax> how can I verify that? 17:23:44 <springmeyer> its a funny boost library since it is not required for mapnik on linux but it is on mac osx 17:24:17 <springmeyer> well, I should say you might be missing boost system, or it is installed wrong, or scons is not finding linking it correctly 17:24:22 <synax> I ran the staging and install --with-system flag 17:24:32 <springmeyer> but, i've not seen that error before... 17:24:35 <springmeyer> 'Undefined symbols: 17:24:35 <springmeyer> "boost::system::get_generic_category()", referenced from:' 17:24:48 <springmeyer> anyway, I would do... 17:24:56 <springmeyer> $ locate boost_system 17:25:01 <springmeyer> make sure you have it 17:25:13 <springmeyer> then try building from mapnik trunk 17:25:28 <synax> yeah, nothing was returned...wtf 17:25:37 <springmeyer> then if that does not work with boost, try reinstalling boost 17:26:04 <springmeyer> synax: maybe try $ ls /usr/local/lib/libboost* -l 17:26:12 <springmeyer> see if boost_system show up 17:26:21 <synax> yeah, I have all the required libs in there 17:27:00 <synax> /usr/local/lib/libboost_system-xgcc40-mt-1_38.dylib 17:27:52 <springmeyer> okay, cool 17:28:12 <synax> I'll give SVN a ago 17:28:22 <springmeyer> have you messed with the symlinks at all? 17:28:34 <springmeyer> for boost i mean 17:28:55 <synax> yeah, I've tried renaming the symlinks 17:29:41 <springmeyer> okay, that may be the 'proximate' reason wer're seeing that error now 17:29:57 <springmeyer> rebuild from trunk and use these options... 17:30:23 <springmeyer> $ python scons/scons.py configure BOOST_TOOLKIT=xgcc40 BOOST_VERSION=1_38 17:31:24 <synax> k, here goes 17:31:48 <springmeyer> doc you may not have seen: http://trac.mapnik.org/wiki/UsingScons 17:32:12 <synax> springmeyer: http://dpaste.com/16997/ 17:32:31 <synax> Checking for Boost version >= 1.33...no ... ugh... 17:33:47 <springmeyer> oh, and add... 17:34:05 <synax> src 17:34:10 <synax> *sec 17:34:16 <springmeyer> BOOST_LIBS=/usr/local/lib BOOST_INCLUDES=/usr/local/include/boost 17:34:19 <synax> added BOOST_INCLUDES and it solved the version issue 17:34:21 <synax> ya 17:34:38 <springmeyer> in trunk now you'll only need to do that once 17:34:42 <synax> k, looks like I'm just missing icuuc and icudata now 17:34:47 <synax> getting closer! 17:34:51 <springmeyer> custom options get serialized to a 'config.py' files 17:34:54 <springmeyer> files/file 17:34:55 <springmeyer> cool 17:35:02 <springmeyer> ya, ICU is a new dependency in trunk 17:35:13 <springmeyer> replaced fribidi for unicode support 17:35:15 <synax> where can I get these libs from? 17:35:29 <springmeyer> sudo port install icu ? 17:35:51 <synax> I don't use fink/port 17:35:54 <synax> garbage 17:36:44 <springmeyer> cool, thanks fine 17:37:08 <springmeyer> macports is what I use occaisionally because I want to be able to recommend it 17:37:22 <springmeyer> but it does not work well enough, ala 17:37:33 <springmeyer> ICU link can be had off of... http://trac.mapnik.org/wiki/MacInstallationSource 17:37:43 <springmeyer> e.g. http://site.icu-project.org/ 17:38:42 <springmeyer> btw, this page (http://trac.mapnik.org/wiki/MacInstallationSource) could use some updating from someone who has recently built boost/icu/ etc from source 17:38:51 <springmeyer> :) 17:39:17 <synax> heh, if I get it running, I may consider it 17:39:24 <synax> as repayment for your help 17:40:03 <springmeyer> ya, I'm looking for help on keeping wiki pages up to date 17:40:34 <springmeyer> I've spent a big chuck of time recently trying to get scons/boost and friends to be easier and more predictable 17:40:40 <springmeyer> in trunk. 17:40:58 <springmeyer> no time left for wiki pages :) 17:41:42 <synax> I've been trying to get this installed all day... 17:42:02 <synax> there's no RPM for RedHat/CentOS 17:42:13 <springmeyer> :) I hear ya. 17:42:34 <springmeyer> so you are doing both mac os and centOS? 17:47:00 <synax> just OS X for now 17:47:07 <synax> and bam, it's installed! 17:47:45 <synax> well...it passed deps. check 17:47:52 <synax> ...currently building 17:47:57 <springmeyer> cool 17:48:12 <synax> all this to generate a couple of tiles ;) 17:48:47 <springmeyer> :) well mapnik is a pretty complex library and the python bindings are very fun 17:49:08 <springmeyer> but ya, if you are just trying to render a few OSM tiles it can seem like a lot of dependencies 17:49:14 <synax> it's what I've been looking for to dig my hooks into Python 17:49:34 <synax> been trying to play with Django at home, but now work can pay me to learn it ;) 17:49:36 <springmeyer> ah, cool 17:49:42 * springmeyer was about to say... 17:49:53 <springmeyer> if you combine that with django, watch out :) 17:50:14 <synax> we use a PHP framework here 17:50:16 <synax> it's terrible 17:50:20 <synax> Code Igniter 17:54:10 <springmeyer> hmm, ya I've rarely used PHP 17:54:45 <synax> and it's installed! fantastic 17:55:08 <springmeyer> >>> import mapnik # works? 17:55:12 <synax> aye 17:55:39 <springmeyer> solid 17:55:58 <springmeyer> good. I think you may be first to try out the new build stuff in trunk for mac os 17:56:30 <springmeyer> glad it went smoother. 18:02:59 <synax> everything was built from source 18:03:10 <synax> all dependencies + mapnik 18:03:34 <synax> it wasn't too painful, except that I had to build Boost twice 18:03:38 <springmeyer> cool, your build notes will be valuable 18:03:48 <synax> ...first time via make - second time using bjam 18:03:49 <springmeyer> ya, boost is tricky 18:04:01 <springmeyer> bjam is nice once you learn it 18:04:04 <synax> and I'm pretty sure I already had some version previously installed 18:04:14 <synax> whatever came with Xcode 18:04:14 *** D3f0 has quit (Remote closed the connection) 18:04:15 <springmeyer> ah 18:04:24 <springmeyer> boost with xcode? huh never seen that 18:05:02 <synax> I think you're right 18:05:11 <synax> yeah, it's just all the symlinks throwing me off 18:05:16 <synax> I only have 1.38 on here 18:05:27 <springmeyer> okay 18:05:38 <springmeyer> ya, that has been kinda of story... 18:05:51 <springmeyer> without good support for specifying the boost lib names in mapnik 0.5.1 18:06:12 <synax> fwiw, these kinds of guides are almost totally useless: http://www.codingadventures.com/2008/04/howto-building-mapnik-on-osx-leopard/ 18:06:14 <springmeyer> folks start touching up symlinks which is tedius 18:06:23 <synax> step 1: get some package manager, step 2: get packages 18:06:33 <springmeyer> so that's why we need to get the word out about the stuff in trunk :) 18:06:52 <springmeyer> ya, I told that guys to contribute to the code base 18:07:08 <springmeyer> he pretty much said screw you I'll post to my blog 18:07:34 <synax> heh 18:13:36 <synax> alright, so I'm running into the same issues on CentOS, except I don't know where to specify the path for the boost libs 18:13:58 <springmeyer> okay. 18:14:03 <springmeyer> so boost from source again? 18:14:10 <synax> /usr/lib/ contains libboost*.a and *.so files 18:14:22 <synax> boost was installed via yum 18:14:28 <springmeyer> ah, okay 18:14:44 <springmeyer> then I would first try nothing but the defaults 18:14:50 <synax> did that 18:15:02 <springmeyer> since most packages create symlinks that the default config will find 18:15:03 <springmeyer> okay 18:15:42 <springmeyer> libboost_*-mt.so is what is looked for by default if THREADING=True 18:16:36 <synax> is that a scons option? 18:17:11 <springmeyer> er if THREADING=multi i mean 18:17:12 <springmeyer> ya 18:17:17 <synax> ok 18:17:18 <springmeyer> multi is default 18:17:37 <springmeyer> $ python scons/scons.py -h # will give you all the options 18:18:34 <synax> -H 18:18:35 <synax> ;) 18:19:41 <jbronn> synax: what do the boost libs filenames look like? 18:20:27 <synax> /usr/lib/libboost_filesystem.so 18:21:19 <synax> is a symlink to the filename + .1.33.1 18:37:20 <springmeyer> synax: just a additional caution 18:37:38 <springmeyer> I've been experiencing problems building against boost 1_33 on ubuntu/debian 18:39:04 <springmeyer> what does your config.log look like? 18:40:45 <synax> sec 18:42:01 <synax> springmeyer: http://dpaste.com/17015/ 18:43:54 <springmeyer> '/usr/bin/ld: cannot find -lboost_filesystem-mt' 18:44:18 <springmeyer> and it should be getting linked since that symlink name exists 18:44:26 <springmeyer> in '-L/usr/lib' right? 18:45:05 <springmeyer> or is there /usr/lib/libboost_filesystem.so and no /usr/lib/libboost_filesystem-mt.so ? 18:50:04 <synax> no -mt files 18:50:18 <synax> usr/lib/libboost_filesystem.so and usr/lib/libboost_filesystem.a 18:50:47 <springmeyer> interesting 18:50:58 <springmeyer> okay you have the non-threaded version of boost then 18:51:05 <springmeyer> so THREADING=single 18:51:13 <springmeyer> try that 18:55:59 <synax> k 18:56:24 <synax> sweet 18:56:30 <synax> now to install xml2config 18:59:11 <springmeyer> should just come with the development headers of libxml2 18:59:53 *** D3f0 (n=defo@190.176.196.8) has joined #mapnik 19:00:06 <synax> yay, building (again) 19:00:32 <springmeyer> I've never heard of someone using the non threaded version of boost 19:00:46 <springmeyer> usually you see 'usr/lib/libboost_filesystem.so' purely exist as a 19:00:55 <springmeyer> symlink to 'usr/lib/libboost_filesystem-mt.so' 19:01:00 <springmeyer> anyway, cool it is working 19:07:05 <synax> thanks again, springmeyer 19:07:15 <synax> you'll probably see me back in here on Monday ;) 19:07:58 <springmeyer> np, see ya around 19:26:09 *** synax has quit () 19:26:28 *** D3f0 has quit (Read error: 54 (Connection reset by peer)) 19:28:10 *** racicot has quit (Read error: 104 (Connection reset by peer)) 19:29:10 *** racicot (n=chatzill@dsl-209-166-85-189.whidbey.net) has joined #mapnik 20:49:11 *** rcoup (n=rcoup@ip-118-90-3-165.xdsl.xnet.co.nz) has joined #mapnik 20:59:20 *** Scelestis (n=Scelesti@pool-173-79-14-202.washdc.fios.verizon.net) has joined #mapnik 20:59:59 <Scelestis> Is it possible to exclude a certain bounding box from a layer in the osm.xml? 21:00:47 <Scelestis> or even specify a bounding box for the layer, and just make layers for all the areas I am interested in that don't include the area I am excluding 21:22:47 *** rcoup has quit () 21:33:55 <dukeku> Scelestis: how are you using the osm data? 21:33:56 <dukeku> postgis? 21:34:49 <dukeku> if you're doing postgis you could always create a second layer 21:35:07 <dukeku> and draw it last, so it'd be put on top of the already drawn layer 21:35:52 <dukeku> select the data you want with ST_Within(POLYGON(), the_geom) or similar 21:55:11 <Scelestis> yes, postgis database of the OSM data 22:11:25 <dukeku> your mapnik "table" could be something like (SELECT * FROM planet_osm_ways WHERE ST_Within(ST_SetSRID(ST_GeomFromText('LINESTRING(lon lat, lon lat, lon lat, lon lat)'), 4326), the_geom) = 't'; 22:11:30 <dukeku> er, ) at the end 22:11:48 <dukeku> where those lon lat pairs make up the bbox coordinates 22:32:26 *** dbaker has parted #mapnik () 22:40:03 <Scelestis> I see the way geom colomn, I guess the (ST_GeomFromText('LINESTRING(lon lat, lon lat, lon lat, lon lat)' converts that? 23:00:08 <dukeku> ST_GeomFromText creates a geometry type that has the polygon described within 23:00:36 <dukeku> setsrid(,4326) sets the srid of that geometry to geographic coordinates 23:00:57 <dukeku> the_geom is the openstreetmap geometry column within that particular OSM table, it might not be called that 23:02:42 <dukeku> doing a select in postgis like select f_table_name,f_geometry_column from geometry_columns where f_table_name like 'osm_%'; should let you know what the actual column is named 23:03:01 <dukeku> s/osm_/planet_osm_/ 23:22:17 *** D3f0 (n=defo@190.177.8.65) has joined #mapnik 23:50:40 *** Scelestis has quit ("Trillian (http://www.ceruleanstudios.com")