#mapnik log: Friday 20, March 2009

2009 | 03

previous | next
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")