Pseudo-Service DiDok

Les arrêts sont importants pour de nombreuses autres requêtes. Ceux-ci peuvent être obtenus à partir de Didok (description).

Aspects techniques

Avec l’API CKAN, il est possible de mettre en place une recherche simple. Notez que vous avez besoin d’une clé API pour cela.

Exemple de requête Didok

A partir de Didok, nous recherchons “Domodossola” à l’aide d’une requête SQL.

• Identification de la ressource dans “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",         //...       }     ]   }

  
   
• A l’aide de l’ID dans la ressource avec l’identifiant “Didok.xlsx”, nous recherchons maintenant 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'

  
  Au lieu de “079e10fc-c212-4fc8-a75d-d02028f1539c”, il faut insérer le code actuellement valable pour une ressource.
  
  { "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'"   } }

  
   

Informations supplémentaires

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