[OSM-talk] SQL

[Torsten Mohr]

Hello,

when connecting to PostGIS and querying for german federal states
i can find them all in either:

planet_osm_line
planet_osm_polygon

It also is no problem to find states with special characters like in
Baden-Württemberg.

But no matter what i do, i don't find "Bayern" and "Sachsen".  I do
find "Thüringen" but it is not drawn when used in "osm.xml".

I try drawing the states with (works for all except the three mentioned):


<Style name="grmnx">
    <Rule>
      <Filter>[name] = 'FILL_STATE_NAME_IN_HERE'</Filter>
      <MaxScaleDenominator>250000000000</MaxScaleDenominator>
      <MinScaleDenominator>600000</MinScaleDenominator>

      <LineSymbolizer>
        <CssParameter name="stroke">#FF6565</CssParameter>
      </LineSymbolizer>
    </Rule>
</Style>


<Layer name="grmny" status="on" srs="+proj=merc +a=6378137 +b=6378137 
+lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null 
+no_defs +over">
    <StyleName>grmnx</StyleName>
    <Datasource>
      <Parameter name="type">postgis</Parameter>
      <Parameter name="user">tmohr</Parameter>
      <Parameter name="dbname">gis</Parameter>
      <Parameter name="table">(select * from planet_osm_polygon order by 
z_order,way_area desc) as grmnx</Parameter>
      <Parameter name="estimate_extent">false</Parameter>
      <Parameter 
name="extent">-20037508,-19929239,20037508,19929239</Parameter>
    </Datasource>
</Layer>

<Layer name="grmnx" status="on" srs="+proj=merc +a=6378137 +b=6378137 
+lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null 
+no_defs +over">
    <StyleName>grmnx</StyleName>
    <Datasource>
      <Parameter name="type">postgis</Parameter>
      <Parameter name="user">tmohr</Parameter>
      <Parameter name="dbname">gis</Parameter>
      <Parameter name="table">(select * from planet_osm_line order by 
z_order,way_area desc) as grmnx</Parameter>
      <Parameter name="estimate_extent">false</Parameter>
      <Parameter 
name="extent">-20037508,-19929239,20037508,19929239</Parameter>
    </Datasource>
</Layer>


I also tried to access "Thüringen" by its osm_id, but also no success.

In "PSQL gis":

gis=> select osm_id, name from planet_osm_polygon where name like 'Thüringen' 
limit 1000;
 osm_id |   name
--------+-----------
 -76689 | Thüringen
(1 Zeile)


Can anybody tell me how to draw the three missing states?

Is there an explanation why they are "missing"?

Is it possible to access parts from PostGIS by their osm_id from osm.xml?



Thanks for any hints,
Torsten.