{"activeVersionTag":"latest","latestAvailableVersionTag":"latest","collection":{"info":{"_postman_id":"139b97fd-d64f-4d24-bbe0-bd574d1a29ef","name":"Athens Smart Neighbourhood CKAN DataStore API","description":"# Athens Smart Neighbourhood — CKAN DataStore Postman Collection\n\nΗ επίσημη τεκμηρίωση του CKAN DataStore ([https://docs.ckan.org/en/2.11/maintaining/datastore.html#the-data-api](https://docs.ckan.org/en/2.11/maintaining/datastore.html#the-data-api)) σε συνδυασμό με τα τεχνικά της πύλης δεδομένων ([https://opendata-cityofathens-gr.gitbook.io/guides/texnika-egxeiridia](https://opendata-cityofathens-gr.gitbook.io/guides/texnika-egxeiridia)) παραμένουν το βασικό σημείο αναφοράς για το πώς λειτουργούν τα `datastore_search` και `datastore_info` και αξίζει να τη συμβουλεύεσαι παράλληλα με αυτή τη συλλογή:\n\n- CKAN DataStore / The Data API\n    \n- datastore_search, datastore_info, `_table_metadata`, filters, fields, sort, records_format, dump endpoints\n    \n\nΗ συγκεκριμένη συλλογή είναι εστιασμένη στα δεδομένα που φαίνονται στην πύλη δεδομένων και προέρχονται από τους αισθητήρες και τους σταθμούς wifi που έχουν τοποθετηθεί στις γειτονιές του δήμου ([https://citizenhub.geitoniesathinas.gr/](https://citizenhub.geitoniesathinas.gr/)). Οι κλήσεις που παρουσιάζονται εδώ με ποικίλα παραδείγματα μπορούν να αξιοποιηθούν σε κάθε σύνολο δεδομένων λαμβάνοντας υπόψη βέβαια το εκάστοτε σχήμα των δεδομένων.\n\n## Πώς χρησιμοποιείται πρακτικά η συλλογή\n\nΗ συνήθης ροή είναι:\n\n1. **Εντοπίζεις το dataset / resource που σε ενδιαφέρει**\n    \n    - είτε από το CKAN UI,\n        \n    - είτε από το `_table_metadata`,\n        \n    - είτε — πιο πρακτικά για αυτή την υλοποίηση — από τα 2 registry datasets:\n        \n        - `wifi-stations-registry`\n            \n        - `env-stations-registry`\n            \n2. **Παίρνεις το** **`resource_id`**\n    \n    - κάθε DataStore query στο CKAN στοχεύει σε συγκεκριμένο `resource_id` (ή alias).\n        \n3. **Βλέπεις το σχήμα του resource**\n    \n    - με `datastore_info`,\n        \n    - ή από το UI του resource / DataStore preview.\n        \n4. **Στήνεις** **`datastore_search`**\n    \n    - επιλέγεις πεδία (`fields`),\n        \n    - βάζεις equality / IN φίλτρα (`filters`),\n        \n    - ορίζεις ταξινόμηση (`sort`),\n        \n    - περιορίζεις αποτελέσματα (`limit`, `offset`),\n        \n    - χρησιμοποιείς `q` ή `full_text` για text search,\n        \n    - διαλέγεις και μορφή επιστροφής (`records_format`).\n        \n\n## Ποια datasets καλύπτει η υλοποίηση\n\n### 1\\. Γενικά / lookup / master datasets (4 datasets)\n\n- `wifi-stations-registry`\n    \n- `env-stations-registry`\n    \n- `municipal-districts-athens`\n    \n- `neighbourhoods-athens`\n    \n\n### 2\\. Aggregate datasets (4 datasets)\n\n- `wifi-cumulative-traffic-all-stations`\n    \n- `wifi-active-visitors-all-stations`\n    \n- `wifi-highest-visitors-all-stations`\n    \n- `env-all-stations`\n    \n\n### 3\\. Per-station dataset families (318 datasets συνολικά)\n\n- WiFi per-station (240 datasets):\n    \n    - `wifi-cumulative-traffic-...`\n        \n    - `wifi-active-visitors-...`\n        \n    - `wifi-highest-visitors-...`\n        \n- Environmental per-station (78 datasets):\n    \n    - `env-...`\n        \n\n## Σημαντική πρακτική παρατήρηση\n\nΤα datasets **`wifi-stations-registry`** και **`env-stations-registry`** είναι τα καλύτερα σημεία εκκίνησης όταν ψάχνεις επιμέρους σταθμούς. Περιέχουν τα βασικά στοιχεία του σταθμού και παραπομπές προς:\n\n- aggregate datasets/resources\n    \n- per-station datasets/resources\n    \n- CKAN dataset URLs / resource URLs\n    \n\nΆρα, αν ανακτήσεις πρώτα ένα από αυτά τα δύο registry datasets, μπορείς μετά να πλοηγηθείς γρήγορα στα υπόλοιπα resources.\n\n## Πώς να \"διαβάζεις\" ένα resource πριν ψάξεις\n\nΤο `datastore_info` σε βοηθά να δεις:\n\n- ποια πεδία υπάρχουν,\n    \n- τι τύπους έχουν,\n    \n- αν υπάρχουν aliases,\n    \n- περίπου πόσες εγγραφές υπάρχουν,\n    \n- metadata για το schema.\n    \n\nΑφού δεις τα πεδία, μπορείς να χτίσεις στο `datastore_search` ένα JSON σαν κι αυτά:\n\n### Exact match\n\n``` json\n{\n  \"resource_id\": \"RESOURCE_ID\",\n  \"filters\": {\n    \"station_id\": 2\n  }\n}\n\n ```\n\n### IN filter\n\n``` json\n{\n  \"resource_id\": \"RESOURCE_ID\",\n  \"filters\": {\n    \"station_id\": [2, 10, 15]\n  }\n}\n\n ```\n\n### Projection + sorting\n\n``` json\n{\n  \"resource_id\": \"RESOURCE_ID\",\n  \"fields\": [\"station_id\", \"station_name\", \"date\", \"cumulative_traffic\"],\n  \"sort\": \"date desc\",\n  \"limit\": 50\n}\n\n ```\n\n### Full-text search\n\n``` json\n{\n  \"resource_id\": \"RESOURCE_ID\",\n  \"full_text\": \"Μαβίλη\"\n}\n\n ```\n\n## Δυνατότητες φίλτρων\n\nΗ παρούσα συλλογή εστιάζει **μόνο** στα `datastore_search` και `datastore_info`.  \nΑυτό σημαίνει ότι τα παραδείγματα με `filters` ακολουθούν τη λογική της τεκμηρίωσης του CKAN:\n\n- equality (`=`),\n    \n- πολλαπλές τιμές / `IN`.\n    \n\n## Σημειώσεις\n\n1. Η συλλογή εστιάζει μόνο στα endpoints `datastore_search` και `datastore_info`.\n    \n2. Για όλα τα resources της υλοποίησης, δεδομένου ότι πρόκειται για public resources, δεν χρειάζεται Authorization header.\n    \n3. Όλα τα requests είναι `POST` προς το CKAN Action API.\n    \n4. Στα παραδείγματα χρησιμοποιούνται πραγματικά `resource_id` από τα mappings της υλοποίησης.","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","isPublicCollection":false,"owner":"51309911","team":12617312,"collectionId":"139b97fd-d64f-4d24-bbe0-bd574d1a29ef","publishedId":"2sBXinJWVo","public":true,"publicUrl":"https://documenter-api.postman.tech/view/51309911/2sBXinJWVo","privateUrl":"https://go.postman.co/documentation/51309911-139b97fd-d64f-4d24-bbe0-bd574d1a29ef","customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"6674bd"},"documentationLayout":"classic-single-column","customisation":{"metaTags":[{"name":"description","value":""},{"name":"title","value":""}],"appearance":{"default":"dark","themes":[{"name":"dark","logo":"https://content.pstmn.io/70f1997c-a67f-49c1-a932-a1163d15b575/c21hcnROZWlnaGJvdXJob29kQXRoZW5zT3BlbkRhdGEucG5n","colors":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"6674bd"}},{"name":"light","logo":"https://content.pstmn.io/867f8775-f6df-4343-8d7a-7031609d6876/c21hcnROZWlnaGJvdXJob29kQXRoZW5zT3BlbkRhdGEucG5n","colors":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"6674bd"}}]}},"version":"8.11.6","publishDate":"2026-03-31T17:25:43.000Z","activeVersionTag":"latest","documentationTheme":"light","metaTags":{"title":"","description":""},"logos":{"logoLight":"https://content.pstmn.io/867f8775-f6df-4343-8d7a-7031609d6876/c21hcnROZWlnaGJvdXJob29kQXRoZW5zT3BlbkRhdGEucG5n","logoDark":"https://content.pstmn.io/70f1997c-a67f-49c1-a932-a1163d15b575/c21hcnROZWlnaGJvdXJob29kQXRoZW5zT3BlbkRhdGEucG5n"}},"statusCode":200},"environments":[],"user":{"authenticated":false,"permissions":{"publish":false}},"run":{"button":{"js":"https://run.pstmn.io/button.js","css":"https://run.pstmn.io/button.css"}},"web":"https://www.getpostman.com/","team":{"logo":"https://res.cloudinary.com/postman/image/upload/t_team_logo_pubdoc/v1/team/97a1e332b5d2cf4e3e314ae1bac3adfdb2e5ca4a7920de8fc01ceb538459215a","favicon":""},"isEnvFetchError":false,"languages":"[{\"key\":\"csharp\",\"label\":\"C#\",\"variant\":\"HttpClient\"},{\"key\":\"csharp\",\"label\":\"C#\",\"variant\":\"RestSharp\"},{\"key\":\"curl\",\"label\":\"cURL\",\"variant\":\"cURL\"},{\"key\":\"dart\",\"label\":\"Dart\",\"variant\":\"http\"},{\"key\":\"go\",\"label\":\"Go\",\"variant\":\"Native\"},{\"key\":\"http\",\"label\":\"HTTP\",\"variant\":\"HTTP\"},{\"key\":\"java\",\"label\":\"Java\",\"variant\":\"OkHttp\"},{\"key\":\"java\",\"label\":\"Java\",\"variant\":\"Unirest\"},{\"key\":\"javascript\",\"label\":\"JavaScript\",\"variant\":\"Fetch\"},{\"key\":\"javascript\",\"label\":\"JavaScript\",\"variant\":\"jQuery\"},{\"key\":\"javascript\",\"label\":\"JavaScript\",\"variant\":\"XHR\"},{\"key\":\"c\",\"label\":\"C\",\"variant\":\"libcurl\"},{\"key\":\"nodejs\",\"label\":\"NodeJs\",\"variant\":\"Axios\"},{\"key\":\"nodejs\",\"label\":\"NodeJs\",\"variant\":\"Native\"},{\"key\":\"nodejs\",\"label\":\"NodeJs\",\"variant\":\"Request\"},{\"key\":\"nodejs\",\"label\":\"NodeJs\",\"variant\":\"Unirest\"},{\"key\":\"objective-c\",\"label\":\"Objective-C\",\"variant\":\"NSURLSession\"},{\"key\":\"ocaml\",\"label\":\"OCaml\",\"variant\":\"Cohttp\"},{\"key\":\"php\",\"label\":\"PHP\",\"variant\":\"cURL\"},{\"key\":\"php\",\"label\":\"PHP\",\"variant\":\"Guzzle\"},{\"key\":\"php\",\"label\":\"PHP\",\"variant\":\"HTTP_Request2\"},{\"key\":\"php\",\"label\":\"PHP\",\"variant\":\"pecl_http\"},{\"key\":\"powershell\",\"label\":\"PowerShell\",\"variant\":\"RestMethod\"},{\"key\":\"python\",\"label\":\"Python\",\"variant\":\"http.client\"},{\"key\":\"python\",\"label\":\"Python\",\"variant\":\"Requests\"},{\"key\":\"r\",\"label\":\"R\",\"variant\":\"httr\"},{\"key\":\"r\",\"label\":\"R\",\"variant\":\"RCurl\"},{\"key\":\"ruby\",\"label\":\"Ruby\",\"variant\":\"Net::HTTP\"},{\"key\":\"shell\",\"label\":\"Shell\",\"variant\":\"Httpie\"},{\"key\":\"shell\",\"label\":\"Shell\",\"variant\":\"wget\"},{\"key\":\"swift\",\"label\":\"Swift\",\"variant\":\"URLSession\"}]","languageSettings":[{"key":"csharp","label":"C#","variant":"HttpClient"},{"key":"csharp","label":"C#","variant":"RestSharp"},{"key":"curl","label":"cURL","variant":"cURL"},{"key":"dart","label":"Dart","variant":"http"},{"key":"go","label":"Go","variant":"Native"},{"key":"http","label":"HTTP","variant":"HTTP"},{"key":"java","label":"Java","variant":"OkHttp"},{"key":"java","label":"Java","variant":"Unirest"},{"key":"javascript","label":"JavaScript","variant":"Fetch"},{"key":"javascript","label":"JavaScript","variant":"jQuery"},{"key":"javascript","label":"JavaScript","variant":"XHR"},{"key":"c","label":"C","variant":"libcurl"},{"key":"nodejs","label":"NodeJs","variant":"Axios"},{"key":"nodejs","label":"NodeJs","variant":"Native"},{"key":"nodejs","label":"NodeJs","variant":"Request"},{"key":"nodejs","label":"NodeJs","variant":"Unirest"},{"key":"objective-c","label":"Objective-C","variant":"NSURLSession"},{"key":"ocaml","label":"OCaml","variant":"Cohttp"},{"key":"php","label":"PHP","variant":"cURL"},{"key":"php","label":"PHP","variant":"Guzzle"},{"key":"php","label":"PHP","variant":"HTTP_Request2"},{"key":"php","label":"PHP","variant":"pecl_http"},{"key":"powershell","label":"PowerShell","variant":"RestMethod"},{"key":"python","label":"Python","variant":"http.client"},{"key":"python","label":"Python","variant":"Requests"},{"key":"r","label":"R","variant":"httr"},{"key":"r","label":"R","variant":"RCurl"},{"key":"ruby","label":"Ruby","variant":"Net::HTTP"},{"key":"shell","label":"Shell","variant":"Httpie"},{"key":"shell","label":"Shell","variant":"wget"},{"key":"swift","label":"Swift","variant":"URLSession"}],"languageOptions":[{"label":"C# - HttpClient","value":"csharp - HttpClient - C#"},{"label":"C# - RestSharp","value":"csharp - RestSharp - C#"},{"label":"cURL - cURL","value":"curl - cURL - cURL"},{"label":"Dart - http","value":"dart - http - Dart"},{"label":"Go - Native","value":"go - Native - Go"},{"label":"HTTP - HTTP","value":"http - HTTP - HTTP"},{"label":"Java - OkHttp","value":"java - OkHttp - Java"},{"label":"Java - Unirest","value":"java - Unirest - Java"},{"label":"JavaScript - Fetch","value":"javascript - Fetch - JavaScript"},{"label":"JavaScript - jQuery","value":"javascript - jQuery - JavaScript"},{"label":"JavaScript - XHR","value":"javascript - XHR - JavaScript"},{"label":"C - libcurl","value":"c - libcurl - C"},{"label":"NodeJs - Axios","value":"nodejs - Axios - NodeJs"},{"label":"NodeJs - Native","value":"nodejs - Native - NodeJs"},{"label":"NodeJs - Request","value":"nodejs - Request - NodeJs"},{"label":"NodeJs - Unirest","value":"nodejs - Unirest - NodeJs"},{"label":"Objective-C - NSURLSession","value":"objective-c - NSURLSession - Objective-C"},{"label":"OCaml - Cohttp","value":"ocaml - Cohttp - OCaml"},{"label":"PHP - cURL","value":"php - cURL - PHP"},{"label":"PHP - Guzzle","value":"php - Guzzle - PHP"},{"label":"PHP - HTTP_Request2","value":"php - HTTP_Request2 - PHP"},{"label":"PHP - pecl_http","value":"php - pecl_http - PHP"},{"label":"PowerShell - RestMethod","value":"powershell - RestMethod - PowerShell"},{"label":"Python - http.client","value":"python - http.client - Python"},{"label":"Python - Requests","value":"python - Requests - Python"},{"label":"R - httr","value":"r - httr - R"},{"label":"R - RCurl","value":"r - RCurl - R"},{"label":"Ruby - Net::HTTP","value":"ruby - Net::HTTP - Ruby"},{"label":"Shell - Httpie","value":"shell - Httpie - Shell"},{"label":"Shell - wget","value":"shell - wget - Shell"},{"label":"Swift - URLSession","value":"swift - URLSession - Swift"}],"layoutOptions":[{"value":"classic-single-column","label":"Single Column"},{"value":"classic-double-column","label":"Double Column"}],"versionOptions":[],"environmentOptions":[{"value":"0","label":"No Environment"}],"canonicalUrl":"https://documenter.gw.postman.com/view/metadata/2sBXinJWVo"}