TileMill / Mapnik with Postgis datasource

[المشرف العام]

I'm having some problems getting a full features (roads, rivers, buildings, parks, etc) map to show on TileMill. The steps I taken so far:

• Mounted a PG9.4 with Postgis 2.1 database
• Downloaded the caribbean PBF from geofabrik
• Imported the data using osm2psql (default stylesheet)
• In TileMill I added a new layer and used my Postgis database as source

I want to know what to put in the Table or subquery part... I know I need to write a select (...) as X but what I can't figure out is a way to show everything on the map (select all features on a single SQL)

I can show only roads or only buildings but I want to show everything like in a normal OSM map.

It crossed my mind that maybe I need one layer for each feature that I want to show... but that's seems like an incredibly stupid idea since there are a lot of different features to show and it will be extremely stressful on the database to fire like 20 SQLs (1 for each feature) for each tile rendered.

I searched the web high and low, but seems that everyone that is into mapping only wants to draw 1 thing at a time on their maps :-/ what I mean is, I found many examples of using planet_osm_roads as the source.

Here's an image where you can see the map in the back is only showing roads (planet_osm_lines)



So the question is, what do I need to put on the Table or subquery field to get a full map?

Thanks.-



أكثر...