Hi everyone, I struggle to generate osm data from the postgreSQL/postGIS database. “generate_tiles.py” renders the lower zoom levels 0-5 of the world overview without any problems:
# World bbox = (-180.0,-90.0, 180.0,90.0) render_tiles(bbox, mapfile, tile_dir, 0, 5, "World")
But then it should also render my example map section from the little country of Liechtenstein, which I loaded into the postGIS database:
minZoom = 10 maxZoom = 16 bbox = (9.4, 47.3,9.7,47.0) render_tiles(bbox, mapfile, tile_dir, minZoom, maxZoom)
But it doesn’t do it. It creates the folders for zoomlevel 10-16, but doesn’t fill them with tiles. The Windows command line says:
render_tiles ( (9.4, 47.3,9.7,47.0) c:\users\tanja\out.xml c:\users\tanja\osm\tiles/ 10 16 unknown )
So it just ends the process, without any error message.
Some more information about my system:
One thing I might need to mention is, that after importing the osm data into the database, it was missing several colums in the tables. Generating the intermediate stylesheet “out.xml” with “generate_xml.py” gave out an error message until I added all colums manually to the database. I added them manually with the same properties as the existing colums (type “text”, pg_catalogue.“default”). I tried different raw osm data from bbb.bike and geofabrik with both it said the columns are missing. It is these ones:
- “disused” (in the tables: line, point,polygon)
- “capital” (in the table: point)
- “generator:source” (in the tables: point, polygon)
- “power_source” (in the tables: point, polygon)
- “ele” (in the table: point)
I am no programmer and at the end of my abilities. I already searched this forum and in the rest of the internet for possible solutions. Nothing worked so far
Thanks for your help!
Update: Finally found the postgreSQL log files. At least there is an error:
“2019-11-24 18:32:59.698 CET  LOG: konnte Daten vom Client nicht empfangen: unrecognized winsock error 10054” - Translation: “couldn’t recieve data from client”
Doing some research about this now. Does anyone know this problem?