Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Issue with MapQuest #1

Open
agponte opened this issue Jan 19, 2016 · 1 comment
Open

SQL Issue with MapQuest #1

agponte opened this issue Jan 19, 2016 · 1 comment

Comments

@agponte
Copy link

agponte commented Jan 19, 2016

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
Copy link
Owner

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants