TransWikia.com

No data found in this area ERROR - JOSM

Geographic Information Systems Asked by valdeci on December 21, 2020

I’m trying to edit my local database using JOSM. I’m already running the "Rails Port API" and pointing to it.

I imported a pbf file to my local database using the osm2pgsql without errors.

The connection is validated in the JOSM’s Connection settings, and I already tried to use the basic authentication and OAuth authentication and the two are working without problems.

But, when I tried to download the data on the JOSM (using the Ctrl + Shift + Down option) appears the error "No data found in this area".

In my development.log of the API shows the JOSM’s call:

Parameters:    {"bbox"=>"-48.9653778,-26.4644263,-48.8960266,-26.4481357"}

SELECT  "current_nodes".* FROM "current_nodes" WHERE (( tile BETWEEN 870717944 AND 870717951 OR tile BETWEEN 870718288 AND 870718303 OR tile BETWEEN 870718320 AND 870718335 OR tile BETWEEN 870718416 AND 870718425 OR tile BETWEEN 870718428 AND 870718429 OR tile BETWEEN 870718632 AND 870718636 OR tile BETWEEN 870718976 AND 870718980 OR tile BETWEEN 870718984 AND 870718988 OR tile BETWEEN 870719008 AND 870719012 OR tile BETWEEN 870719016 AND 870719020 OR tile BETWEEN 870719104 AND 870719108 OR tile BETWEEN 870719112 AND 870719113 OR tile IN (870718638,870718982,870718990,870719014,870719022,870719110,870719116) ) AND latitude BETWEEN -264644263.0 AND -264481357.00000003 AND longitude BETWEEN -489653778.0 AND -488960266.0) AND "current_nodes"."visible" = $1 LIMIT 50001  [["visible", "t"]]
Relation Load (22.2ms)  SELECT "current_relations".* FROM "current_relations" INNER JOIN "current_relation_members" ON "current_relation_members"."relation_id" = "current_relations"."id" WHERE "current_relation_members"."member_type" = 'Node' AND 1=0 AND "current_relations"."visible" = $1  [["visible", "t"]]
Relation Load (0.2ms)  SELECT "current_relations".* FROM "current_relations" INNER JOIN "current_relation_members" ON "current_relation_members"."relation_id" = "current_relations"."id" WHERE "current_relation_members"."member_type" = 'Way' AND 1=0 AND "current_relations"."visible" = $1  [["visible", "t"]]
Relation Load (0.2ms)  SELECT "current_relations".* FROM "current_relations" INNER JOIN "current_relation_members" ON "current_relation_members"."relation_id" = "current_relations"."id" WHERE "current_relation_members"."member_type" = 'Relation' AND 1=0 AND "current_relations"."visible" = $1  [["visible", "t"]]

But my current_nodes table is empty. Does anybody know how I can populate this table to edit in an editor?

I think that my question is related to this issue: http://github.com/openstreetmap/openstreetmap-website/issues/282

One Answer

You're running osm2pgsql to populate a database, but I think that's the wrong thing to do in this situation. Long story short, I think you should be reading the CONFIGURE.md instructions

osm2pgsql is a tool for populating a PostGIS database. It's a powerful thing, letting you run Mapnik rendering software, Nominatim search software, or your own geospatial queries. But it's a totally different database table structure to that required by the openstreetmap-website rails app.

For the rails app database, you need a different approach. If you just want some test data in there, you might use JOSM to write to the database (it's a read & write API after all!). First you'll need to create a test user account on your local copy of the OpenStreetMap website, and then try drawing a little map and "uploading" from JOSM to your API.

But you had a PBF file you wanted to import. That can be done with Osmosis. Something like this

osmosis --read-pbf greater-london-latest.osm.pbf --write-apidb host="localhost" database="openstreetmap" user="openstreetmap" password="" validateSchemaVersion="no"

Although you might be left with a sequence issue

Correct answer by Harry Wood on December 21, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP