optimize database queries - a lot (they were gigantic because they were copy+paste...

[osmrrze.git] / styles / mapnik-osm-data / rrze-overlay.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE Map [
<!ENTITY % entities SYSTEM "inc/entities.xml.inc">
%entities;
]>
<Map background-color="transparent" srs="&srs900913;" minimum-version="2.0.0" buffer-size="512" maximum-extent="-20037508.342789244,-20037508.342780735,20037508.342789244,20037508.342780709">
  &fontset-settings;
<Style name="text">
    <Rule>
      <Filter>[amenity]='bicycle_parking' and ([access] = 'public' or [access] = 'yes' or not [access] != '')</Filter>
      &maxscale_zoom17;
      <TextSymbolizer size="9" fill="#0066ff" dy="9" fontset-name="book-fonts" halo-radius="1" wrap-width="34" placement="interior">[name]</TextSymbolizer>
    </Rule>
</Style>

<Style name="points">
    <Rule>
      &maxscale_zoom15;
      <Filter>[amenity] = 'bicycle_parking' and ([access] = 'public' or [access] = 'yes' or not [access] != '')</Filter>
      <PointSymbolizer file="rrze&symbols;/parking_bicycle.p.16.png" allow-overlap="false" placement="interior"/>
    </Rule>
</Style>

<Layer name="amenity-points" status="on" srs="&osm2pgsql_projection;">
    <StyleName>points</StyleName>
    <Datasource>
      <Parameter name="table">
      (select way,amenity,access
      from &prefix;_point
      where amenity is not null
      ) as points</Parameter>
      &datasource-settings;
    </Datasource>
</Layer>
<Layer name="amenity-points-poly" status="on" srs="&osm2pgsql_projection;">
    <StyleName>points</StyleName>
    <Datasource>
      <Parameter name="table">
      (select way,amenity,access
      from &prefix;_polygon
      where amenity is not null
      ) as points</Parameter>
      &datasource-settings;
    </Datasource>
</Layer>


<Layer name="text" status="on" srs="&osm2pgsql_projection;">
    <StyleName>text</StyleName>
    <Datasource>
      <Parameter name="table">
      (select way,amenity,access,name,ref,'yes'::text as point
       from &prefix;_point
       where amenity is not null
      ) as text
      </Parameter>
      &datasource-settings;
    </Datasource>
</Layer>
<Layer name="text-poly" status="on" srs="&osm2pgsql_projection;">
    <StyleName>text</StyleName>
    <Datasource>
      <Parameter name="table">
      (select way,access,amenity,NULL as ele,name,ref,'no'::text as point
       from &prefix;_polygon
       where amenity is not null
      ) as text
      </Parameter>
      &datasource-settings;
    </Datasource>
</Layer>
</Map>