Hi,
I could not render a PostGIS layer using the following setting on WindowsXP,
-Mapnik 0.6.1
-PostgreSQL 8.4/PostGIS 1.4
It works fine for shapefiles. But as I connect to a PostGIS Layer, I got the
following errors in the Postgresql log file,
2009-12-24 14:05:03 ESTERROR: zero-length delimited identifier at or near
"""" at character 17
2009-12-24 14:05:03 ESTSTATEMENT: SELECT AsBinary("",'NDR') AS geom from
(SELECT * FROM "mains_update_dlz" WHERE GeometryType("the_geom") IN
('LINESTRING','MULTILINESTRING')) as "mains_update_dlz" WHERE "" &&
SetSRID('BOX3D(1835078.82466 710209.522025,1842753.74984
713266.403181)'::box3d,0)
The XML file is shown below,
<?xml version="1.0" ?><Map bgcolor="rgb(255,255,255)" srs="+proj=longlat
+ellps=WGS84 +datum=WGS84 +no_defs">
<Style name="mains_update_dlz_style">
<Rule>
<LineSymbolizer>
<CssParameter name="stroke">rgb(229,210,191)</CssParameter>
<CssParameter name="stroke-width">0.96</CssParameter>
<CssParameter name="stroke-linejoin">bevel</CssParameter>
<CssParameter name="stroke-linecap">square</CssParameter>
</LineSymbolizer>
</Rule>
</Style>
<Layer clear_label_cache="0" name="mains_update_dlz" srs="+proj=longlat
+ellps=WGS84 +datum=WGS84 +no_defs" status="1">
<StyleName>mains_update_dlz_style</StyleName>
<Datasource>
<Parameter name="dbname">postgis</Parameter>
<Parameter
name="extent">1835078.82466,710209.522025,1842753.74984,713266.403181</Parameter>
<Parameter name="host">localhost</Parameter>
<Parameter name="password">postgres</Parameter>
<Parameter name="port">5432</Parameter>
<Parameter name="estimate_extent">false</Parameter>
<Parameter name="table">(SELECT * FROM mains_update_dlz) as
mains_update_dlz</Parameter>
<Parameter name="type">postgis</Parameter>
<Parameter name="user">postgres</Parameter>
</Datasource>
</Layer>
</Map>
Thank you very much,
Mel
_______________________________________________
Mapnik-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/mapnik-users
