Sophox / sophox

A collection of services exposing OSM data, metadata, and other microservices
Apache License 2.0
31 stars 5 forks source link

Data items not fully imported ? #31

Open nlehuby opened 2 years ago

nlehuby commented 2 years ago

Hi,

there seems to be a synchronization issue with the wiki data items. The following query for example returns very few results compared to what is expected:

SELECT ?osmd WHERE {
  ?osmd osmdt:P10 osmd:Q695.
}

https://sophox.org/#SELECT%20%3Fosmd%20WHERE%20%7B%0A%20%20%3Fosmd%20osmdt%3AP10%20osmd%3AQ695.%0A%7D

The following items are missing for instance: https://wiki.openstreetmap.org/wiki/Item:Q5706 or https://wiki.openstreetmap.org/wiki/Item:Q4730

The interface displays however : OSM Metadata - Data updated 3 hours ago

Maybe related to #27 ?

sfkeller commented 1 year ago

@nyurik : Do you have any idea why so many items are missing? Broken import? Broken synchronization?

1ec5 commented 8 months ago

Maybe related to #27 ?

27 is now fixed, but the query still returns no results.

sfkeller commented 2 weeks ago

Any update on this issue? If Sophox doesn't process OSM Wiki data items (like "All Shops..." in the SPARQL query above), for what else is Sophox used?

1ec5 commented 2 weeks ago

It is intended to process data items. The issue is that some are missing for some reason.

Otherwise, Sophox still has plenty of uses that don’t involve data items.

sfkeller commented 2 weeks ago

Thanks for the answer and the Sophox examples.

Sorry for insisting. Just to explain: I'm trying to extract OSM wikidata items and finally to build a (sub)graph from it.

The issue is that some are missing for some reason.

I don't understand what you mean by "some": The first query above "SELECT ?osmd WHERE { ?osmd osmdt:P10 osmd:Q695.}" (about "shop" OSM wikidata items) returns "No matching records found".

In fact, all queries in the Sophox examples involving OSM wikidata items "osmd" and "osmdt" that I have tried return "No matching records found".

1ec5 commented 2 weeks ago

Argh, it seems to have gradually gotten worse, similar to what happened in #27. I don’t think we ever really got to the bottom of that.

Anyhow, if you’re trying to work with all or most of the data items systematically, maybe you’d find a Turtle dump more convenient.

nyurik commented 2 weeks ago

I am still around, and when needed, can reboot it or even rebuild the index (in the worst case). Volunteers needed