Talk:Sophox

From OpenStreetMap Wiki
Jump to navigation Jump to search

osmm:key coverage

This page says every data item has an osmm:key predicate, giving bridge (Q103) as an example, but Sophox isn't returning any results for osmd:Q103 osmm:key ?key. 889 items have permanent key ID (P16) but no osmm:key:

SELECT * WHERE {
  ?subject osmdt:P16 ?key.
  FILTER NOT EXISTS {
    ?subject osmm:key [].
  }
}

Run it (edit query)

What's special about these keys? Does it have something to do with when the data items were created?

 – Minh Nguyễn 💬 10:37, 19 August 2020 (UTC)

Received fatal alert: handshake_failure

@Yurik: Hi, this federated query fails with Caused by: javax.net.ssl.SSLException: Received fatal alert: handshake_failure. It sounds like bad certificate, it would be nice if you could what the error actually is?

prefix taxmeon: <http://www.yso.fi/onto/taxmeon/>
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT *
WHERE 
{
    SERVICE <https://api.finto.fi/sparql> { 
     SELECT * WHERE {
        ?scifi taxmeon:hasVernacularName <http://www.yso.fi/onto/kassu/k20487> 
     }
    }
}

Run it (edit query)

--Zache (talk) 13:30, 24 October 2020 (UTC)

Could be also just that https is not supported by server and request is downgraded to http? In any case http://api.finto.fi/sparql works --Zache (talk) 05:42, 25 October 2020 (UTC)

Tag usage statistics

It seem that this is possible to get usage statistics from taginfo only for keys.

Is it possible to add it also for tags ?

osmd:Q5043  osmm:count_all    54856951  # Number of objects in the OSM database with this tag.

--Pyrog (talk) 09:45, 7 November 2020 (UTC)

Any idea why Sophox is now rejecting

SELECT ?value ?loc
WHERE { ?osm osmt:amenity 'atm'; osmt:operator ?value; osmm:loc ?loc. }

? It used to work and become part of StreetComplete, and now it seems impossible to update tag statistics. It goes down with

java.util.concurrent.ExecutionException: org.openrdf.query.MalformedQueryException: com.bigdata.rdf.sail.sparql.ast.VisitorException: QName 'osmt:amenity' uses an undefined prefix

@Yurik:

Mateusz Konieczny (talk) 14:11, 22 August 2021 (UTC)

I opened https://github.com/streetcomplete/StreetComplete/issues/3202 as I see no obvious solutions Mateusz Konieczny (talk) 14:23, 22 August 2021 (UTC)
Seems already known - https://github.com/Sophox/sophox/issues/27 - Sophox has only small portion of OSM data, just what was recently edited Mateusz Konieczny (talk) 15:25, 22 August 2021 (UTC)
@Mateusz Konieczny: Sophox seems to have no problem with the query above for me: I get 7,925 results in 1.798 seconds. But of course that's far short of the actual total. – Minh Nguyễn 💬 01:28, 23 August 2021 (UTC)
https://taginfo.openstreetmap.org/tags/amenity=atm reports over 180 000 atm, so Sophox no longer contains most of OSM data - making it useless at least for that purpose :( Mateusz Konieczny (talk) 07:54, 23 August 2021 (UTC)
Whatever the circumstances for the error message above, it's easy to get around. "osmt:amenity" is used simply as an abbreviation for "https://wiki.openstreetmap.org/wiki/Key:amenity" - if the prefix "osmt" is not defined, you can define it in the beginning of your query yourself:
PREFIX osmt: <https://wiki.openstreetmap.org/wiki/Key:>
--TuukkaH (talk) 08:34, 23 August 2021 (UTC)

sophox.org not accessible

@@Yurik:, Today when I tried to access https://sophox.org I got the following error.

Secure Connection Failed
An error occurred during a connection to sophox.org. Peer’s Certificate has been revoked.
Error code: SEC_ERROR_REVOKED_CERTIFICATE
The page you are trying to view cannot be shown because the authenticity of the received data could not be verified.
Please contact the website owners to inform them of this problem.

Hope you or someone will fix it soon.--Arjunaraoc (talk) 04:11, 11 February 2022 (UTC)

@Yurik: I have the same problem. SPARQL queries do not load. --Galopax (talk) 09:52, 17 February 2022 (UTC)
@Yurik:, Server is up, but old working queries are failing. Example: https://w.wiki/BBt ----Arjunaraoc (talk) 04:49, 18 April 2022 (UTC)