search

zachatrocity / mapnik-fork

A fork of mapnik already configured to work with my environment and using the mapquest theme.
GNU Lesser General Public License v2.1
5 stars 2 forks source link

SQL Issue with MapQuest #1

Open agponte opened 8 years ago

agponte commented 8 years ago

Zach,

Great work and thanks! Do you have a solution for this issue reported by renderd? Stangely it seems to only happen east of Atlantic Ocean - African continent, etc.

renderd[29516]:    reason: Postgis Plugin: ERROR:  invalid input syntax for integer: "RW O2"#012#012in executeQuery Full sql was: 'SELECT ST_AsBinary("way") AS geom,"name","place" FROM (select way,place,replace(replace(name,'(',''),')','') as name,ref#012       from planet_osm_point#012       where place in ('continent','country','county','state')#012       or (place in ('city','metropolis') and capital='yes' #012           and (admin_level is null or admin_level::integer < 4))#012       ) as placenames WHERE "way" && ST_SetSRID('BOX3D(-2504688.542849999 -19929239,20037508 2504688.542849999)'::box3d, 900913)'
zachatrocity commented 8 years ago

Not sure if you found this but you can follow this and it might help: http://www.zachatrocity.com/blog/creating-a-mapnik-tileserver-on-windows/

As far as your problem goes, I'm not too sure, did you run the postgis script?

psql -d gis -U postgres -f "C:\Program Files\PostgreSQL\9.4\share\extension\postgis".sql

You could try editing this file C:\Program Files\PostgreSQL\9.4\data\postgresql.conf and allowing more memory for the field work_mem = 256MB