OSM Plugin

[ajayre]

Hi,

Is there a simple way of getting the OSM Plugin for the Windows binary
version of Mapnik?

Or is the only option to rebuild the windows binary myself?

thanks, Andy

--
Andy
PGP Key ID: 0xDC1B5864
_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[Dane Springmeyer]

Hey Andrew,

All plugins are separate DLL's that link to libmapnik.dll and are  
installed by being dropped into c:/mapnik_0_6_0/lib/mapnik/input.

So, if you can compile the osm plugin as a DLL with the extension of  
'input' then it should work, but we've yet to do that for windows and  
don't currently have a plan for it.

Dane


On Jun 16, 2009, at 12:06 PM, Andrew Ayre wrote:

> Hi,
>
> Is there a simple way of getting the OSM Plugin for the Windows binary
> version of Mapnik?
>
> Or is the only option to rebuild the windows binary myself?
>
> thanks, Andy
>
> --
> Andy
> PGP Key ID: 0xDC1B5864
> _______________________________________________
> Mapnik-users mailing list
> Mapnik-users@...
> https://lists.berlios.de/mailman/listinfo/mapnik-users

_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[ajayre]

Thanks. I just want some OSM maps as a background. So I think for now I
will download OSM tiles, add as a raster layer in Mapnik and then
reproject my data and add as Mapnik layers.

Any reason why this approach wouldn't work?

Andy

Dane Springmeyer wrote:

> Hey Andrew,
>
> All plugins are separate DLL's that link to libmapnik.dll and are
> installed by being dropped into c:/mapnik_0_6_0/lib/mapnik/input.
>
> So, if you can compile the osm plugin as a DLL with the extension of
> 'input' then it should work, but we've yet to do that for windows and
> don't currently have a plan for it.
>
> Dane
>
>
> On Jun 16, 2009, at 12:06 PM, Andrew Ayre wrote:
>
>> Hi,
>>
>> Is there a simple way of getting the OSM Plugin for the Windows binary
>> version of Mapnik?
>>
>> Or is the only option to rebuild the windows binary myself?
>>
>> thanks, Andy
>>
>> --
>> Andy
>> PGP Key ID: 0xDC1B5864
>> _______________________________________________
>> Mapnik-users mailing list
>> Mapnik-users@...
>> https://lists.berlios.de/mailman/listinfo/mapnik-users
>
>
>

--
Andy
PGP Key ID: 0xDC1B5864
_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[Dane Springmeyer]

The standard approach to rendering OSM data is by using osm2pqsql to  
import osm data into postgres/postgis.

http://wiki.openstreetmap.org/index.php/Mapnik

Dane


On Jun 16, 2009, at 12:45 PM, Andrew Ayre wrote:

> Thanks. I just want some OSM maps as a background. So I think for  
> now I will download OSM tiles, add as a raster layer in Mapnik and  
> then reproject my data and add as Mapnik layers.
>
> Any reason why this approach wouldn't work?
>
> Andy
>
> Dane Springmeyer wrote:
>> Hey Andrew,
>> All plugins are separate DLL's that link to libmapnik.dll and are  
>> installed by being dropped into c:/mapnik_0_6_0/lib/mapnik/input.
>> So, if you can compile the osm plugin as a DLL with the extension  
>> of 'input' then it should work, but we've yet to do that for  
>> windows and don't currently have a plan for it.
>> Dane
>> On Jun 16, 2009, at 12:06 PM, Andrew Ayre wrote:
>>> Hi,
>>>
>>> Is there a simple way of getting the OSM Plugin for the Windows  
>>> binary
>>> version of Mapnik?
>>>
>>> Or is the only option to rebuild the windows binary myself?
>>>
>>> thanks, Andy
>>>
>>> --
>>> Andy
>>> PGP Key ID: 0xDC1B5864
>>> _______________________________________________
>>> Mapnik-users mailing list
>>> Mapnik-users@...
>>> https://lists.berlios.de/mailman/listinfo/mapnik-users
>
> --
> Andy
> PGP Key ID: 0xDC1B5864

_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[ajayre]

Hi Dane,

Yep, but I'm using SQLite/Spatialite. I haven't managed to find a simple
  program like osm2pgsql to get data from OSM XML to Spatialite. Seems I
need multiple tools, 20Mb download (FW Tools), etc. I also want to use
the standard OSM styling for the maps - not sure if the SQLite plugin
for Mapnik would use it.

Andy

Dane Springmeyer wrote:

> The standard approach to rendering OSM data is by using osm2pqsql to
> import osm data into postgres/postgis.
>
> http://wiki.openstreetmap.org/index.php/Mapnik
>
> Dane
>
>
> On Jun 16, 2009, at 12:45 PM, Andrew Ayre wrote:
>
>> Thanks. I just want some OSM maps as a background. So I think for now
>> I will download OSM tiles, add as a raster layer in Mapnik and then
>> reproject my data and add as Mapnik layers.
>>
>> Any reason why this approach wouldn't work?
>>
>> Andy
>>
>> Dane Springmeyer wrote:
>>> Hey Andrew,
>>> All plugins are separate DLL's that link to libmapnik.dll and are
>>> installed by being dropped into c:/mapnik_0_6_0/lib/mapnik/input.
>>> So, if you can compile the osm plugin as a DLL with the extension of
>>> 'input' then it should work, but we've yet to do that for windows and
>>> don't currently have a plan for it.
>>> Dane
>>> On Jun 16, 2009, at 12:06 PM, Andrew Ayre wrote:
>>>> Hi,
>>>>
>>>> Is there a simple way of getting the OSM Plugin for the Windows binary
>>>> version of Mapnik?
>>>>
>>>> Or is the only option to rebuild the windows binary myself?
>>>>
>>>> thanks, Andy
>>>>
>>>> --
>>>> Andy
>>>> PGP Key ID: 0xDC1B5864
>>>> _______________________________________________
>>>> Mapnik-users mailing list
>>>> Mapnik-users@...
>>>> https://lists.berlios.de/mailman/listinfo/mapnik-users
>>
>> --
>> Andy
>> PGP Key ID: 0xDC1B5864
>
>
>

--
Andy
PGP Key ID: 0xDC1B5864
_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[Jon Burgess-2]

On Tue, 2009-06-16 at 13:07 -0700, Andrew Ayre wrote:

> Hi Dane,
>
> Yep, but I'm using SQLite/Spatialite. I haven't managed to find a
> simple
>   program like osm2pgsql to get data from OSM XML to Spatialite. Seems
> I
> need multiple tools, 20Mb download (FW Tools), etc. I also want to
> use
> the standard OSM styling for the maps - not sure if the SQLite plugin
> for Mapnik would use it.
>

Do you really need to render new tiles containing the OSM data? The
other alternative is to overlay the data in the browser. If you have
complex data then you can render it into tiles with a transparent
background. Or for simpler data OpenLayers supports drawing lines,
markers etc on top of the tiles.

        Jon


_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[Dane Springmeyer]

Andy,

On Jun 16, 2009, at 1:07 PM, Andrew Ayre wrote:

> Hi Dane,
>
> Yep, but I'm using SQLite/Spatialite.

Ah, well you can use more than one datasource for different layers in  
your map. But maybe you're saying you want to only use file based  
datasources, either sqlite or raster files?

> I haven't managed to find a simple  program like osm2pgsql to get  
> data from OSM XML to Spatialite.

Ya, I've seen postings on the OSM dev list about scripts, but I've not  
tried them. Generally I use the tool Artem wrote called  
'pgsql2sqlite' (http://trac.mapnik.org/browser/trunk/utils/pgsql2sqlite)

> Seems I need multiple tools, 20Mb download (FW Tools), etc.

Migrating data into sqlite with GDAL/OGR should work well. Posting a  
wiki page on what you've done so far would be interesting for helping  
other users.


> I also want to use the standard OSM styling for the maps - not sure  
> if the SQLite plugin for Mapnik would use it.
>


Sure, you can use the default OSM provided xml styles, you'd just need  
to tweak the the SQL statements to be compliant with SQLite. I've done  
this in the past but not too recently.

Dane

> Andy
>
> Dane Springmeyer wrote:
>> The standard approach to rendering OSM data is by using osm2pqsql  
>> to import osm data into postgres/postgis.
>> http://wiki.openstreetmap.org/index.php/Mapnik
>> Dane
>> On Jun 16, 2009, at 12:45 PM, Andrew Ayre wrote:
>>> Thanks. I just want some OSM maps as a background. So I think for  
>>> now I will download OSM tiles, add as a raster layer in Mapnik and  
>>> then reproject my data and add as Mapnik layers.
>>>
>>> Any reason why this approach wouldn't work?
>>>
>>> Andy
>>>
>>> Dane Springmeyer wrote:
>>>> Hey Andrew,
>>>> All plugins are separate DLL's that link to libmapnik.dll and are  
>>>> installed by being dropped into c:/mapnik_0_6_0/lib/mapnik/input.
>>>> So, if you can compile the osm plugin as a DLL with the extension  
>>>> of 'input' then it should work, but we've yet to do that for  
>>>> windows and don't currently have a plan for it.
>>>> Dane
>>>> On Jun 16, 2009, at 12:06 PM, Andrew Ayre wrote:
>>>>> Hi,
>>>>>
>>>>> Is there a simple way of getting the OSM Plugin for the Windows  
>>>>> binary
>>>>> version of Mapnik?
>>>>>
>>>>> Or is the only option to rebuild the windows binary myself?
>>>>>
>>>>> thanks, Andy
>>>>>
>>>>> --
>>>>> Andy
>>>>> PGP Key ID: 0xDC1B5864
>>>>> _______________________________________________
>>>>> Mapnik-users mailing list
>>>>> Mapnik-users@...
>>>>> https://lists.berlios.de/mailman/listinfo/mapnik-users
>>>
>>> --
>>> Andy
>>> PGP Key ID: 0xDC1B5864
>
> --
> Andy
> PGP Key ID: 0xDC1B5864

_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[ajayre]

Jon Burgess wrote:

> On Tue, 2009-06-16 at 13:07 -0700, Andrew Ayre wrote:
>> Hi Dane,
>>
>> Yep, but I'm using SQLite/Spatialite. I haven't managed to find a
>> simple
>>   program like osm2pgsql to get data from OSM XML to Spatialite. Seems
>> I
>> need multiple tools, 20Mb download (FW Tools), etc. I also want to
>> use
>> the standard OSM styling for the maps - not sure if the SQLite plugin
>> for Mapnik would use it.
>>
>
> Do you really need to render new tiles containing the OSM data? The
> other alternative is to overlay the data in the browser. If you have
> complex data then you can render it into tiles with a transparent
> background. Or for simpler data OpenLayers supports drawing lines,
> markers etc on top of the tiles.
>
> Jon

This small project is to gather data in the field and render maps on the
spot using a laptop running Windows. The field data will be put into an
SQLite database. I would like OSM maps as a background to give context
to the data the user enters.

I have a Debian-based Mapserver serving WMS/WFS from a PostGIS database
to Openlayers on a website, but I'm finding this offline project more of
a challenge to put the pieces in place. ;)

Andy

--
Andy
PGP Key ID: 0xDC1B5864
_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[ajayre]

Thanks Dane. I'll take a look at pgsql2splite. I won't have a PostGIS
database available at all, so hopefully I can get it to input a SQL file.

Andy

Dane Springmeyer wrote:

> Andy,
>
> On Jun 16, 2009, at 1:07 PM, Andrew Ayre wrote:
>
>> Hi Dane,
>>
>> Yep, but I'm using SQLite/Spatialite.
>
> Ah, well you can use more than one datasource for different layers in
> your map. But maybe you're saying you want to only use file based
> datasources, either sqlite or raster files?
>
>> I haven't managed to find a simple  program like osm2pgsql to get data
>> from OSM XML to Spatialite.
>
> Ya, I've seen postings on the OSM dev list about scripts, but I've not
> tried them. Generally I use the tool Artem wrote called 'pgsql2sqlite'
> (http://trac.mapnik.org/browser/trunk/utils/pgsql2sqlite)
>
>> Seems I need multiple tools, 20Mb download (FW Tools), etc.
>
> Migrating data into sqlite with GDAL/OGR should work well. Posting a
> wiki page on what you've done so far would be interesting for helping
> other users.
>
>
>> I also want to use the standard OSM styling for the maps - not sure if
>> the SQLite plugin for Mapnik would use it.
>>
>
>
> Sure, you can use the default OSM provided xml styles, you'd just need
> to tweak the the SQL statements to be compliant with SQLite. I've done
> this in the past but not too recently.
>
> Dane

--
Andy
PGP Key ID: 0xDC1B5864
_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[Jon Burgess-2]

On Tue, 2009-06-16 at 13:46 -0700, Andrew Ayre wrote:

> Jon Burgess wrote:
> > On Tue, 2009-06-16 at 13:07 -0700, Andrew Ayre wrote:
> >> Hi Dane,
> >>
> >> Yep, but I'm using SQLite/Spatialite. I haven't managed to find a
> >> simple
> >>   program like osm2pgsql to get data from OSM XML to Spatialite. Seems
> >> I
> >> need multiple tools, 20Mb download (FW Tools), etc. I also want to
> >> use
> >> the standard OSM styling for the maps - not sure if the SQLite plugin
> >> for Mapnik would use it.
> >>
> >
> > Do you really need to render new tiles containing the OSM data? The
> > other alternative is to overlay the data in the browser. If you have
> > complex data then you can render it into tiles with a transparent
> > background. Or for simpler data OpenLayers supports drawing lines,
> > markers etc on top of the tiles.
> >
> > Jon
>
> This small project is to gather data in the field and render maps on the
> spot using a laptop running Windows. The field data will be put into an
> SQLite database. I would like OSM maps as a background to give context
> to the data the user enters.

As Dane mentioned, provided you can install Postgres too, Mapnik will
happily render tiles from both SQLite & Postgres data sources.

As I mentioned before, you could still take a set of existing OSM tiles
and then render your new data to transparent tiles to use as an overlay.
This has the benefit of reducing the amount of data which needs to be
rendered which will make the local updates much faster.

> I have a Debian-based Mapserver serving WMS/WFS from a PostGIS database
> to Openlayers on a website, but I'm finding this offline project more of
> a challenge to put the pieces in place. ;)

Provided you have the disk space available & relevant OS support you can
generally run most the online tools on 'localhost' in an offline mode.

        Jon


_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[Rahkonen Jukka]

Hi,

If you have already Mapserver running and available, why don't you create static maps in geotiff format (or ecw or something else) and use those as background while doing off-line work?  WCS service is just made for that.  I am usually making 5000 by 5000 pixel geotiffs but they can be larger if needed.

-Jukka Rahkonen-


-----Alkuperäinen viesti-----
Lähettäjä: mapnik-users-bounces@... puolesta: Andrew Ayre
Lähetetty: ti 16.6.2009 23:46
Vastaanottaja: Jon Burgess
Kopio: mapnik-users@...
Aihe: Re: [Mapnik-users] OSM Plugin
 
Jon Burgess wrote:

> On Tue, 2009-06-16 at 13:07 -0700, Andrew Ayre wrote:
>> Hi Dane,
>>
>> Yep, but I'm using SQLite/Spatialite. I haven't managed to find a
>> simple
>>   program like osm2pgsql to get data from OSM XML to Spatialite. Seems
>> I
>> need multiple tools, 20Mb download (FW Tools), etc. I also want to
>> use
>> the standard OSM styling for the maps - not sure if the SQLite plugin
>> for Mapnik would use it.
>>
>
> Do you really need to render new tiles containing the OSM data? The
> other alternative is to overlay the data in the browser. If you have
> complex data then you can render it into tiles with a transparent
> background. Or for simpler data OpenLayers supports drawing lines,
> markers etc on top of the tiles.
>
> Jon

This small project is to gather data in the field and render maps on the
spot using a laptop running Windows. The field data will be put into an
SQLite database. I would like OSM maps as a background to give context
to the data the user enters.

I have a Debian-based Mapserver serving WMS/WFS from a PostGIS database
to Openlayers on a website, but I'm finding this offline project more of
a challenge to put the pieces in place. ;)

Andy

--
Andy
PGP Key ID: 0xDC1B5864
_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[ajayre]

Thanks. I'll look into what I can do with this.

Rahkonen Jukka wrote:
> Hi,
>
> If you have already Mapserver running and available, why don't you create static maps in geotiff format (or ecw or something else) and use those as background while doing off-line work?  WCS service is just made for that.  I am usually making 5000 by 5000 pixel geotiffs but they can be larger if needed.
>
> -Jukka Rahkonen-
>
>

--
Andy
PGP Key ID: 0xDC1B5864
_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[ajayre]

Jon Burgess wrote:

> On Tue, 2009-06-16 at 13:46 -0700, Andrew Ayre wrote:
>> Jon Burgess wrote:
>>> On Tue, 2009-06-16 at 13:07 -0700, Andrew Ayre wrote:
>>>> Hi Dane,
>>>>
>>>> Yep, but I'm using SQLite/Spatialite. I haven't managed to find a
>>>> simple
>>>>   program like osm2pgsql to get data from OSM XML to Spatialite. Seems
>>>> I
>>>> need multiple tools, 20Mb download (FW Tools), etc. I also want to
>>>> use
>>>> the standard OSM styling for the maps - not sure if the SQLite plugin
>>>> for Mapnik would use it.
>>>>
>>> Do you really need to render new tiles containing the OSM data? The
>>> other alternative is to overlay the data in the browser. If you have
>>> complex data then you can render it into tiles with a transparent
>>> background. Or for simpler data OpenLayers supports drawing lines,
>>> markers etc on top of the tiles.
>>>
>>> Jon
>> This small project is to gather data in the field and render maps on the
>> spot using a laptop running Windows. The field data will be put into an
>> SQLite database. I would like OSM maps as a background to give context
>> to the data the user enters.
>
> As Dane mentioned, provided you can install Postgres too, Mapnik will
> happily render tiles from both SQLite & Postgres data sources.
>
> As I mentioned before, you could still take a set of existing OSM tiles
> and then render your new data to transparent tiles to use as an overlay.
> This has the benefit of reducing the amount of data which needs to be
> rendered which will make the local updates much faster.

So your suggestion is to download the OSM tiles. Render transparent
tiles in Mapnik that are the same size with the same top left
coordinates. Then use another program to put the OSM tiles and my tiles
together?

Andy

--
Andy
PGP Key ID: 0xDC1B5864
_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[Jon Burgess-2]

On Tue, 2009-06-16 at 22:25 -0700, Andrew Ayre wrote:

> Jon Burgess wrote:
> > On Tue, 2009-06-16 at 13:46 -0700, Andrew Ayre wrote:
> >> Jon Burgess wrote:
> >>> On Tue, 2009-06-16 at 13:07 -0700, Andrew Ayre wrote:
> >>>> Hi Dane,
> >>>>
> >>>> Yep, but I'm using SQLite/Spatialite. I haven't managed to find a
> >>>> simple
> >>>>   program like osm2pgsql to get data from OSM XML to Spatialite. Seems
> >>>> I
> >>>> need multiple tools, 20Mb download (FW Tools), etc. I also want to
> >>>> use
> >>>> the standard OSM styling for the maps - not sure if the SQLite plugin
> >>>> for Mapnik would use it.
> >>>>
> >>> Do you really need to render new tiles containing the OSM data? The
> >>> other alternative is to overlay the data in the browser. If you have
> >>> complex data then you can render it into tiles with a transparent
> >>> background. Or for simpler data OpenLayers supports drawing lines,
> >>> markers etc on top of the tiles.
> >>>
> >>> Jon
> >> This small project is to gather data in the field and render maps on the
> >> spot using a laptop running Windows. The field data will be put into an
> >> SQLite database. I would like OSM maps as a background to give context
> >> to the data the user enters.
> >
> > As Dane mentioned, provided you can install Postgres too, Mapnik will
> > happily render tiles from both SQLite & Postgres data sources.
> >
> > As I mentioned before, you could still take a set of existing OSM tiles
> > and then render your new data to transparent tiles to use as an overlay.
> > This has the benefit of reducing the amount of data which needs to be
> > rendered which will make the local updates much faster.
>
> So your suggestion is to download the OSM tiles. Render transparent
> tiles in Mapnik that are the same size with the same top left
> coordinates. Then use another program to put the OSM tiles and my tiles
> together?

Yes. If you want to cover a very large area it may make sense for you to
render the Mapnik tiles yourself instead of downloading them from the
OSM server. Then you can bundle those pre-rendered background tiles with
the application install.

        Jon

> Andy
>

_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[ajayre]

Does Mapnik support the PostgreSQL/PostGIS schema generated by Osmosis?

   http://wiki.openstreetmap.org/wiki/PostGIS

The reason I ask is that Osmosis can output the SQL to a file, which I
can then post-process for SQLite.

Thanks, Andy

Dane Springmeyer wrote:
> The standard approach to rendering OSM data is by using osm2pqsql to
> import osm data into postgres/postgis.
>
> http://wiki.openstreetmap.org/index.php/Mapnik
>
> Dane

--
Andy
PGP Key ID: 0xDC1B5864
_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[ajayre]

Dane Springmeyer wrote:

> Andy,
>
> On Jun 16, 2009, at 1:07 PM, Andrew Ayre wrote:
>
>> Hi Dane,
>>
>> Yep, but I'm using SQLite/Spatialite.
>
> Ah, well you can use more than one datasource for different layers in
> your map. But maybe you're saying you want to only use file based
> datasources, either sqlite or raster files?
>
>> I haven't managed to find a simple  program like osm2pgsql to get data
>> from OSM XML to Spatialite.
>
> Ya, I've seen postings on the OSM dev list about scripts, but I've not
> tried them. Generally I use the tool Artem wrote called 'pgsql2sqlite'
> (http://trac.mapnik.org/browser/trunk/utils/pgsql2sqlite)

Can't seem to get it to compile. I don't have a
/usr/local/include/boost-1_38. Any ideas what package I need to install?
Is there a list of dependencies somewhere for pgsql2sqlite?

I tried literally converting the contents of a PostgreSQL database into
a SQLite database verbatim and I can't get Mapnik to accept it, so there
must be a step I am missing. It complains about syntax errors when there
are colons in the column names, about "limit" and missing column
"the_geom", even though I set the geometry column to "way" in the XML file.

Andy

--
Andy
PGP Key ID: 0xDC1B5864
_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[Dane Springmeyer]

On Jun 19, 2009, at 11:24 PM, Andrew Ayre wrote:

> Dane Springmeyer wrote:
>> Andy,
>> On Jun 16, 2009, at 1:07 PM, Andrew Ayre wrote:
>>> Hi Dane,
>>>
>>> Yep, but I'm using SQLite/Spatialite.
>> Ah, well you can use more than one datasource for different layers  
>> in your map. But maybe you're saying you want to only use file  
>> based datasources, either sqlite or raster files?
>>> I haven't managed to find a simple  program like osm2pgsql to get  
>>> data from OSM XML to Spatialite.
>> Ya, I've seen postings on the OSM dev list about scripts, but I've  
>> not tried them. Generally I use the tool Artem wrote called  
>> 'pgsql2sqlite' (http://trac.mapnik.org/browser/trunk/utils/pgsql2sqlite 
>> )
>
> Can't seem to get it to compile.

How are you trying to compile it?

If you do:

python scons/scons.py -h

You'll see the at the bottom, the instructions for how to build it  
(which is not enabled by default since it is experimental) which are:

python scons/scons.py PGSQL2SQLITE=True

> I tried literally converting the contents of a PostgreSQL database  
> into a SQLite database verbatim and I can't get Mapnik to accept it,  
> so there must be a step I am missing. It complains about syntax  
> errors when there are colons in the column names, about "limit" and  
> missing column "the_geom", even though I set the geometry column to  
> "way" in the XML file.
>

You can ignore the "limit" errors. I'm not sure why you'd get a  
missing column geometry column error if you are properly setting sit  
as "way"

Dane

_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[ajayre]

Dane Springmeyer wrote:

>
> On Jun 19, 2009, at 11:24 PM, Andrew Ayre wrote:
>
>> Dane Springmeyer wrote:
>>> Andy,
>>> On Jun 16, 2009, at 1:07 PM, Andrew Ayre wrote:
>>>> Hi Dane,
>>>>
>>>> Yep, but I'm using SQLite/Spatialite.
>>> Ah, well you can use more than one datasource for different layers in
>>> your map. But maybe you're saying you want to only use file based
>>> datasources, either sqlite or raster files?
>>>> I haven't managed to find a simple  program like osm2pgsql to get
>>>> data from OSM XML to Spatialite.
>>> Ya, I've seen postings on the OSM dev list about scripts, but I've
>>> not tried them. Generally I use the tool Artem wrote called
>>> 'pgsql2sqlite' (http://trac.mapnik.org/browser/trunk/utils/pgsql2sqlite)
>>
>> Can't seem to get it to compile.
>
> How are you trying to compile it?
>
> If you do:
>
> python scons/scons.py -h
>
> You'll see the at the bottom, the instructions for how to build it
> (which is not enabled by default since it is experimental) which are:
>
> python scons/scons.py PGSQL2SQLITE=True
>

OK, I've installed all the dependencies, then run scons.py and I get:

/usr/include/boost/python/detail/signature.hpp:98: error: too many
initializers for âconst boost::python::detail::signature_elementâ

Any ideas what to try next?

thanks, Andy

--
Andy
PGP Key ID: 0xDC1B5864
_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users

[Dane Springmeyer]

On Jun 20, 2009, at 2:25 PM, Andrew Ayre wrote:

>>>
>>> Can't seem to get it to compile.
>> How are you trying to compile it?
>> If you do:
>> python scons/scons.py -h
>> You'll see the at the bottom, the instructions for how to build it  
>> (which is not enabled by default since it is experimental) which are:
>> python scons/scons.py PGSQL2SQLITE=True
>
> OK, I've installed all the dependencies, then run scons.py and I get:
>
> /usr/include/boost/python/detail/signature.hpp:98: error: too many  
> initializers for âconst boost::python::detail::signature_elementâ
>

That's odd. You get that during the compile of pgsql2sqlite?  
Pgsql2sqlite a c++ app and should not be needing boost/python (which  
is only used for the compilation of the python bindings)

> Any ideas what to try next?


Try cleaning your build and recompiling everything:

python scons/scons.py -c

Dane

_______________________________________________
Mapnik-users mailing list
Mapnik-users@...
https://lists.berlios.de/mailman/listinfo/mapnik-users