Pseudo-Service DiDok

The stops play an important role for many other queries. They can be taken from Didok (description) or from the station list (description).

Technical aspects

Using CKAN API enables you to initiate a simple search. Please note that you need to have an API key for this.

Sample query using the station list

Search for stops with Lausanne in the name:

• Find the resource ID for the current resource from the “bhlist” using CKAN API:

• The resource with the ID “Station list” is used. The “id” will the be used in the second step.
  
  { // headers "resources": [ // other resources { //... "package_id": "695c7af6-d486-4cde-9bf0-a92fdd581a4e", //... "id": "bb43413d-c89c-49e8-869f-5575e63db9bb", //... "name": { "fr": "Station list", "de": "Station list", "en": "Station list", "it": "Station list" }, "language": [ ], "rights": "", "url": "https:\/\/opentransportdata.swiss\/dataset\/695c7af6-d486-4cde-9bf0-a92fdd581a4e\/resource\/bb43413d-c89c-49e8-869f-5575e63db9bb\/download\/bahnhof.csv", "created": "2016-11-08T12:53:53.025251", "modified": "", "webstore_url": null, "last_modified": "2016-11-08T12:53:52.974681", "position": 1, "revision_id": "ca65cd4a-dbc5-4948-89d2-73e7532a7401", "identifier": "Station list", "resource_type": null } ] //... } }

  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

  {    // headers       "resources": [       // other resources          {         //...         "package_id": "695c7af6-d486-4cde-9bf0-a92fdd581a4e",         //...         "id": "bb43413d-c89c-49e8-869f-5575e63db9bb",         //...         "name": {           "fr": "Station list",           "de": "Station list",           "en": "Station list",           "it": "Station list"         },         "language": [                    ],         "rights": "",         "url": "https:\/\/opentransportdata.swiss\/dataset\/695c7af6-d486-4cde-9bf0-a92fdd581a4e\/resource\/bb43413d-c89c-49e8-869f-5575e63db9bb\/download\/bahnhof.csv",         "created": "2016-11-08T12:53:53.025251",         "modified": "",         "webstore_url": null,         "last_modified": "2016-11-08T12:53:52.974681",         "position": 1,         "revision_id": "ca65cd4a-dbc5-4948-89d2-73e7532a7401",         "identifier": "Station list",         "resource_type": null       }     ]     //...   } }

  
  Use the query “https://opentransportdata.swiss/api/action/datastore_search?resource_id=<resource-id>&q=<search_string>”
  
  Search-String

  https://api.opentransportdata.swiss/ckan-api/datastore_search?resource_id=bb43413d-c89c-49e8-869f-5575e63db9bb&q=Lausanne

  1	https://api.opentransportdata.swiss/ckan-api/datastore_search?resource_id=bb43413d-c89c-49e8-869f-5575e63db9bb&q=Lausanne

  
  
  Resultat

  { "help": "https:\/\/opentransportdata.swiss\/api\/3\/action\/help_show?name=datastore_search", "success": true, "result": { "resource_id": "bb43413d-c89c-49e8-869f-5575e63db9bb", "fields": [ { "type": "int4", "id": "_id" }, { "type": "numeric", "id": "StationID" }, { "type": "text", "id": "Station" }, { "type": "int8", "id": "_full_count" }, { "type": "float4", "id": "rank" } ], "q": "Lausanne", "records": [ { "Station": "Lausanne$<1>$LS$<4>$Losanna$<4>$LS$<3>", "StationID": "8501120", "_id": 828, "_full_count": "211", "rank": 0.0573088 }, // more records { "Station": "Lausanne-Ouchy$<1>$LSO$<3>", "StationID": "8501075", "_id": 789, "_full_count": "211", "rank": 0.0573088 } ], "_links": { "start": "\/api\/action\/datastore_search?q=Lausanne&resource_id=bb43413d-c89c-49e8-869f-5575e63db9bb", "next": "\/api\/action\/datastore_search?q=Lausanne&offset=100&resource_id=bb43413d-c89c-49e8-869f-5575e63db9bb" }, "total": 211 } }

  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

  {   "help": "https:\/\/opentransportdata.swiss\/api\/3\/action\/help_show?name=datastore_search",   "success": true,   "result": {     "resource_id": "bb43413d-c89c-49e8-869f-5575e63db9bb",     "fields": [       {         "type": "int4",         "id": "_id"       },       {         "type": "numeric",         "id": "StationID"       },       {         "type": "text",         "id": "Station"       },       {         "type": "int8",         "id": "_full_count"       },       {         "type": "float4",         "id": "rank"       }     ],     "q": "Lausanne",     "records": [       {         "Station": "Lausanne$<1>$LS$<4>$Losanna$<4>$LS$<3>",         "StationID": "8501120",         "_id": 828,         "_full_count": "211",         "rank": 0.0573088       },       // more records          {         "Station": "Lausanne-Ouchy$<1>$LSO$<3>",         "StationID": "8501075",         "_id": 789,         "_full_count": "211",         "rank": 0.0573088       }     ],     "_links": {       "start": "\/api\/action\/datastore_search?q=Lausanne&resource_id=bb43413d-c89c-49e8-869f-5575e63db9bb",       "next": "\/api\/action\/datastore_search?q=Lausanne&offset=100&resource_id=bb43413d-c89c-49e8-869f-5575e63db9bb"     },     "total": 211   } }

  
   

Sample query using DiDok

We are looking for “Domodossola” using an SQL query.

• Identification of resource in “DiDok”:

• We will now search for Domodossola using the ID in the resource with the identifier “Didok.xlsx”.

• The code which is currently valid for a resource must be inserted instead of “079e10fc-c212-4fc8-a75d-d02028f1539c”.
  
  { "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'"   } }

  More detailed information

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