Pseudo-Service DiDok

Die Haltestellen sind wichtig für viele andere Abfragen. Diese können aus Didok (Beschreibung) bezogen werden.

Technische Aspekte

Mit dem CKAN-API ist es möglich, einen einfache Suche aufzusetzen. Beachten Sie, dass Sie dafür einen API-Schlüssel benötigen.

Abfragebeispiel Didok

Aus Didok suchen wir “Domodossola” mit einem SQL-Query.

• Identifikation der Ressource in “Didok”:
  
  https://api.opentransportdata.swiss/ckan-api/package_show?id=didok

  1	https://api.opentransportdata.swiss/ckan-api/package_show?id=didok

  
   
  
  { //... "resources": [ { "url_type": "upload", "cache_last_updated": null, "issued": "2016-11-08T12:59:39.053524", "package_id": "f26dee75-1ed0-4c07-ac19-c98249e94bc5", "relations": "[]", "datastore_active": true, "id": "079e10fc-c212-4fc8-a75d-d02028f1539c", //... "identifier": "Didok.xlsx", //... } ] }

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

  {     //...       "resources": [       {         "url_type": "upload",         "cache_last_updated": null,         "issued": "2016-11-08T12:59:39.053524",         "package_id": "f26dee75-1ed0-4c07-ac19-c98249e94bc5",         "relations": "[]",         "datastore_active": true,         "id": "079e10fc-c212-4fc8-a75d-d02028f1539c",         //...             "identifier": "Didok.xlsx",         //...       }     ]   }

  
   
• Anhand der ID in der Ressource mit dem Identifier “Didok.xlsx” suchen wir jetzt nach Domodossola
  
  https://api.opentransportdata.swiss/ckan-api/datastore_search_sql?sql=SELECT * from "079e10fc-c212-4fc8-a75d-d02028f1539c" WHERE "Dst-Bezeichnung-offiziell" LIKE 'Domodossola'

  1	https://api.opentransportdata.swiss/ckan-api/datastore_search_sql?sql=SELECT * from "079e10fc-c212-4fc8-a75d-d02028f1539c" WHERE "Dst-Bezeichnung-offiziell" LIKE 'Domodossola'

  
  Statt “079e10fc-c212-4fc8-a75d-d02028f1539c” muss der aktuell gültige Code für eine Ressource eingefügt werden.
  
  { "help": "https:\/\/opentransportdata.swiss\/api\/3\/action\/help_show?name=datastore_search_sql", "success": true, "result": { "records": [ { "Dst-Bezeichung-offiziell": "Domodossola", "GO-Nr": "11", "GO-Abk": "FFS", "VD": "", "VPP": "*", "KOORDY": "666.299999999999954525264911353588104248046875", "KOORDX": "107.4500000000000028421709430404007434844970703125", "Dst-Nr.": "1607", "_full_text": "'1':6 '107.4500000000000028421709430404007434844970703125':8 '11':1 '1607':5 '270':3 '666.299999999999954525264911353588104248046875':9 '9998':7 'domodossola':10 'ffs':4", "Dst-Abk": "DO", "VPG": "", "BP": "*", "KZ": "1", "_id": 6602, "Dst-Bezeichnung lang": "", "Gde-Nr": "9998", "KOORDZ": "270" } ], "fields": [ { "type": "int4", "id": "_id" }, { "type": "tsvector", "id": "_full_text" }, { "type": "numeric", "id": "Dst-Nr." }, { "type": "numeric", "id": "KZ" }, { "type": "text", "id": "Dst-Bezeichung-offiziell" }, { "type": "text", "id": "Dst-Bezeichnung lang" }, { "type": "text", "id": "Dst-Abk" }, { "type": "numeric", "id": "GO-Nr" }, { "type": "text", "id": "GO-Abk" }, { "type": "numeric", "id": "Gde-Nr" }, { "type": "text", "id": "BP" }, { "type": "text", "id": "VPP" }, { "type": "text", "id": "VPG" }, { "type": "text", "id": "VD" }, { "type": "numeric", "id": "KOORDY" }, { "type": "numeric", "id": "KOORDX" }, { "type": "numeric", "id": "KOORDZ" } ], "sql": "SELECT * from \"079e10fc-c212-4fc8-a75d-d02028f1539c\" WHERE \"Dst-Bezeichung-offiziell\" LIKE 'Domodossola'" } }

  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98

  {   "help": "https:\/\/opentransportdata.swiss\/api\/3\/action\/help_show?name=datastore_search_sql",   "success": true,   "result": {     "records": [       {         "Dst-Bezeichung-offiziell": "Domodossola",         "GO-Nr": "11",         "GO-Abk": "FFS",         "VD": "",         "VPP": "*",         "KOORDY": "666.299999999999954525264911353588104248046875",         "KOORDX": "107.4500000000000028421709430404007434844970703125",         "Dst-Nr.": "1607",         "_full_text": "'1':6 '107.4500000000000028421709430404007434844970703125':8 '11':1 '1607':5 '270':3 '666.299999999999954525264911353588104248046875':9 '9998':7 'domodossola':10 'ffs':4",         "Dst-Abk": "DO",         "VPG": "",         "BP": "*",         "KZ": "1",         "_id": 6602,         "Dst-Bezeichnung lang": "",         "Gde-Nr": "9998",         "KOORDZ": "270"       }     ],     "fields": [       {         "type": "int4",         "id": "_id"       },       {         "type": "tsvector",         "id": "_full_text"       },       {         "type": "numeric",         "id": "Dst-Nr."       },       {         "type": "numeric",         "id": "KZ"       },       {         "type": "text",         "id": "Dst-Bezeichung-offiziell"       },       {         "type": "text",         "id": "Dst-Bezeichnung lang"       },       {         "type": "text",         "id": "Dst-Abk"       },       {         "type": "numeric",         "id": "GO-Nr"       },       {         "type": "text",         "id": "GO-Abk"       },       {         "type": "numeric",         "id": "Gde-Nr"       },       {         "type": "text",         "id": "BP"       },       {         "type": "text",         "id": "VPP"       },       {         "type": "text",         "id": "VPG"       },       {         "type": "text",         "id": "VD"       },       {         "type": "numeric",         "id": "KOORDY"       },       {         "type": "numeric",         "id": "KOORDX"       },       {         "type": "numeric",         "id": "KOORDZ"       }     ],     "sql": "SELECT * from \"079e10fc-c212-4fc8-a75d-d02028f1539c\" WHERE \"Dst-Bezeichung-offiziell\" LIKE 'Domodossola'"   } }

  
   

Weiterführende Angaben

• http://docs.ckan.org/en/latest/api/