search

OpenDataSk / SK-Dataset-WishList

This is a wishlist of datasets which Slovak citizens would like to see published.
3 stars 1 forks source link

udaje o postovych smerovych cislach (PSC) #10

Closed hanecak closed 7 years ago

hanecak commented 8 years ago

Vo verejnej konzultacii v roku 2015, ktoru organizoval USV ROS, boli ako prioritne vyhodnotene udaje o postovych smerovych cislach (PSC):

Poštové smerovacie čísla (Ministerstvo dopravy, výstavby a regionálneho rozvoja, Slovenská pošta). Údaje o PSČ sú síce dostupné, ale v uzavretom formáte (Excel), nie je explicitne deklarovaná licencia. Bolo by vhodné zvážiť doplnenie GPS polohy jednotlivých pôšt (aby sa dali zobraziť na mape) -- táto sa síce dá vypočítať, ale bez garancie dát z Registra adries je nejasná.

Referencia: https://github.com/otvorenavlada/akcnyplan2015/tree/master/uloha-03

hanecak commented 7 years ago

Zoznam PSC sa od cca 2016 da ziskat z Registra adries (RA) cez API na data.gov.sk (vid #5 ) napr. pomocou takehoto dopytu:

SELECT "municipalityName", "streetName", "postalCode" from "011f4ec3-7a73-4dff-a63e-81b64cc52947", "47f0e853-3a67-487e-b45f-3f5d099105cf", "15262453-4a0f-4cce-a9e4-7709e135e4b8" WHERE "011f4ec3-7a73-4dff-a63e-81b64cc52947"."streetNameIdentifier" = "47f0e853-3a67-487e-b45f-3f5d099105cf"."objectId" AND "15262453-4a0f-4cce-a9e4-7709e135e4b8"."objectId"::text = "47f0e853-3a67-487e-b45f-3f5d099105cf"."municipalityIdentifiers" ORDER BY "postalCode" LIMIT 10

Konkretne teda staci klihnut na tuto linku:

https://data.gov.sk/api/action/datastore_search_sql?sql=SELECT%20%22municipalityName%22,%20%22streetName%22,%20%22postalCode%22%20from%20%22011f4ec3-7a73-4dff-a63e-81b64cc52947%22,%20%2247f0e853-3a67-487e-b45f-3f5d099105cf%22,%20%2215262453-4a0f-4cce-a9e4-7709e135e4b8%22%20WHERE%20%22011f4ec3-7a73-4dff-a63e-81b64cc52947%22.%22streetNameIdentifier%22%20=%20%2247f0e853-3a67-487e-b45f-3f5d099105cf%22.%22objectId%22%20AND%20%2215262453-4a0f-4cce-a9e4-7709e135e4b8%22.%22objectId%22::text%20=%20%2247f0e853-3a67-487e-b45f-3f5d099105cf%22.%22municipalityIdentifiers%22%20ORDER%20BY%20%22postalCode%22%20LIMIT%2010

(Zdatnejsi vedia, ze treba odstranit "LIMIT 10" a aj preco.)

Pripadne dalsie informacie: