This data category requires all national laws and statutes to be available online, although it is not a requirement that information on legislative behaviour e.g. voting records is available.

• Content of the law / status
• Date of last amendment
• Amendments to the law (if applicable)

http://global.survey.okfn.org/

Twitter Facebook Google+
National government budget at a high level. This category is looking at budgets, that is the planned government expenditure for the upcoming year, and not the actual expenditure.

• Budget per government department
• Budget per sub-department
• Descriptions for budget sections

http://global.survey.okfn.org/dataset/procurement

Data, measured at the water source, on the quality of water is essential for both the delivery of services and the prevention of diseases. In order to satisfy the minimum requirements for this category, data should be available on level of the following chemicals by water source.

• Fecal coliform
• Arsenic
• Fluoride levels
• Nitrates
• Total Dissolved Solids
• Data per water source
• Available for entire country

http://global.survey.okfn.org/dataset/water

Data should include maps of lands with parcel layer that displays boundaries in addition to a land registry with information on registered parcels of land. The following characteristics must be included in cadastral and registry information submitted.

• Parcel Boundaries
• Parcel ID
• Property Value
• Tenure Type

For more information on land ownership datasets and where they're located, check out Cadasta Foundation's Data Overview.

• Parcel boundaries (inc. latitude and longitude)
• Parcel ID
• Property value (i.e. Price Paid, Property Tax Value)
• Tenure Type (ie. leasehold, freehold, protected lands, public lands, customary lands)

http://global.survey.okfn.org/dataset/land

Using hyphens is crazy enough, maybe just "Open Data tracker" would work? Since it's OK-EE initative, we can also omit "Estonian"? The machine name could be just opendata-tracker or something like that?

Idea from Tartu hackathon:
Coordinates and specifics of crime This would predict future location or future crimes and visualize current crime levels.

Intro

Estonian government agencies and local municipalities make datasets available in an open format – these are published in the government repository. https://opendata.riik.ee/et/data/search

In Estonian-Open-Data-Issue-Tracker repository, Open Knowledge Estonia is independently crowd-sourcing to learn about what kind of data people need to use and which open data should be available.

We believe that persons and organizations who use the data are in a strong position to advocate for more and higher quality open data. We have used Global Open Data Index as a model but we are adding categories that are not covered in Open Data Index. http://global.survey.okfn.org/

The Global Open Data Index tracks whether this data is actually released in a way that is accessible to citizens, media and civil society. OK-EE wants to give a crowd-sourced input to the global survey of open data releases. Contributions are welcome!

Data on administrative units or areas defined for the purpose of administration by a (local) government.

• Boundary level 1
• Boundary level 2
• Coordinates (latitude, longitude)
• Name of poligone (department, region, city)
• Borders of poligone

http://global.survey.okfn.org/dataset/boundaries

The points of interest of RMK (State Forest Management Centre) should ideally be open and machine-readable, but as a part of a project I have written a scraper to pull an occasionally updated JSON dump from the web.

• Traffic volumes in streets – car's volumes, pedestrians volumes, bicyclists volumes, public transportation users volumes.
• Bottleneck's (intersections)
• Changes after street reconstruction or construction

EMTA publishes its tax data at http://www.emta.ee/et/kontaktid-ja-ametist/maksulaekumine-statistika/tasutud-maksud Huge ODT sheets, really hard to analyse.

As a data user, I want to be able to access historical and current tax data for a particular company and query companies and paid taxes per quarter per municipality.

For this, we need to build something that

• Polls the URL for new data published
• Downloads the data
• Makes it available via a RESTful API

National Registry of Cultural Monuments has published it's data in JSON API format, but monuments open data is missing location and / or address information which makes it very hard to use the data available.

Registry's UI provides cadastral code and address, but no exact location (latlon or boundary). The location is available via Maa-amet's mapping application.

Convert the archive of election results of Estonia (http://www.vvk.ee/arhiiv/) to machine-readable format

Generally better communication about licensing needed.

Need to communicate better - who is the owner of the data?

If it's public, then what applies (reference to Riigiteataja) etc

Datasets related to air quality, water quality, sound pollution, allergens would be beneficial.

It might be useful to file at least technical issues about the Open Data Portal (also) in official issue tracker at:

• https://github.com/opendata-ee/opendata.riik.ee/issues

Some issues are technical and about content at the same time, in these cases it is probably useful to crosslink the issue between different issue trackers.

Idea from Tartu hackathon:
First two ideas for layers were parks and buildings. Using mobile positioning services, it can be determined which parks are actively in use and should be kept as parks and which ones are underused and therefore could either be used for buildings or repurposed, redeveloped. For the buildings layer, information there would have data about accessibility, energy efficiency, safety, overall price levels etc.

A database of postcodes/zipcodes and the corresponding spatial locations in terms of a latitude and a longitude (or similar coordinates in an openly published coordinate system). The data has to be available for the entire country.

A database of postcodes/zipcodes and the corresponding spatial locations in terms of a latitude and a longitude (or similar coordinates in an openly published coordinate system). The data has to be available for the entire country.

• Zipcodes
• Addresses
• Coordinates (latitude, longitude)
• Data available for entire country

http://global.survey.okfn.org/dataset/postcodes

Property/facility management data is currently very fragmented or even missing. Let's describe what we have and how to improve the availability of that data in an open format.

Sources:

• State Real Property Register (RKVR), #21
• City of Tartu, #41 (comment)

Open the databases of their Web services such as http://www.eki.ee/dict/ies/index.cgi and http://www.eki.ee/dict/qs/index.cgi.

It's very painful (and error prone) to scrape the data for http://vis.one/englishtoestonian/

So we probably need labels for:

• Themes/topics
• Geographical areas (municipalities, at least bigger ones)
• Progress with the issue (some indication about status)

What else? We can also create milestones to prioritize the issues according to some procedure, that we agree on.

Crime data we currently have is by year, type, and at the linnaosa level.

Having access to crime data by distinct date would be beneficial, also if possible to have more accurate location information ex :https://data.cityofchicago.org/view/5cd6-ry5g

It would be beneficial if a dataset existed which was able to show the sale of real estate, the date, and the amount (or at least the amount in a range).

Information system of the parliament does not enable the tracking of legislative drafts the same way that EIS (https://eelnoud.valitsus.ee/main) does. For instance, there is no open data available about the processing of legislative proposals submitted to the parliament by the people. All information regarding processing of such drafts in parliamentary committees is send by e-mail only to the contact person indicated int the said draft.

There is a solution being created by the IT department of the parliament, but as of right now, this issue is open and Hille Hinsberg suggested we add this issue regardless.

The Estonian library catalogue is very data-rich (one of the best catalogues I've seen), but the licensing is quite meh: For the purposes of copy cataloguing, the data of the online catalogue are freely accessible to all Estonian libraries. Other institutions may copy these data upon agreement with ELNET.

It should of course ideally be CC0, but any sort of clear open licensing would be pretty good already.

Todo:

• Identify (with label&refered to current issue) all datasets what are not open and are emphasized in introductory note.

Introductory note:
http://www.g20.utoronto.ca/2015/G20-Anti-Corruption-Open-Data-Principles.pdf

Key national statistics on demographic and economic indicators such as Gross Domestic Product (GDP), or unemployment and population statistics.

• Gross Domestic Product
• National unemployment
• National population

http://global.survey.okfn.org/dataset/statistics

State Real Property Register's open data is available in xml format at https://riigivara.fin.ee/lr1/web/guest/avaandmed

• schema: https://riigivara.fin.ee/kvr/avaandmed/schema
• properties: https://riigivara.fin.ee/kvr/avaandmed/kinnisvarad
• land parcels: https://riigivara.fin.ee/kvr/avaandmed/maad
• buildings: https://riigivara.fin.ee/kvr/avaandmed/hooned
• facilities: https://riigivara.fin.ee/kvr/avaandmed/rajatised
• proceedings: https://riigivara.fin.ee/kvr/avaandmed/menetlused
• agreements: https://riigivara.fin.ee/kvr/avaandmed/lepingud
• usage agreements: https://riigivara.fin.ee/kvr/avaandmed/kasutuslepingud

File sizes

/20161030$ ls -lh
total 399M
11M Oct 30 11:56 hooned.xml
77M Oct 30 12:00 kasutuslepingud.xml
89M Oct 30 11:57 kinnisvarad.xml
29M Oct 30 11:59 lepingud.xml
76M Oct 30 11:56 maad.xml
111M Oct 30 11:59 menetlused.xml
6.9M Oct 30 11:57 rajatised.xml

About the register: https://www.riigiteataja.ee/en/eli/523012017002/consolide#para95
My GitHub repo (incl. buildings in GeoJSON): https://github.com/buildig/rkvr

It would be good to see what buildings (to start with in Tallinn) are handicap accessible AKA: ramp access, elevator in building, etc... this would be useful for those who may have some sort of disability and are moving to Tallinn, but would otherwise not be able to tell if a given building would be usable for them.

List of registered (limited liability) companies. The submissions in this data category does not need to include detailed financial data such as balance sheet etc. To satisfy this category, the following minimum criteria must be met:

• Name of company
• Unique identifier of the company
• Company address
• Updated at least once a month

http://global.survey.okfn.org/dataset/companies

Buildings data needs to be available on a daily basis, not as a snapshot from the history (2016-01-22 as of now, http://opendata.mkm.ee/ehr/). Also, there is no spatial data about the building boundaries available.

I propose to add readme.md to this repo with some guidance.

• Distances between school and home.
• where are schools and where are homes.
  In order to plan schools (or places where one can learn) and reduce traffic demand.

Will add a longer description soon
See an earlier presentation

5 day-forecasts of temperature, precipitation and wind. Forecasts have to be provided for several regions in the country.

• Temperature extremes
• Temperature average
• Wind speed
• Wind direction
• Precipitation Amount
• Precipitation Probability
• Forecast for current day and four following days

http://global.survey.okfn.org/dataset/weather

All tenders and awards of the national/federal government aggregated by office. Monitoring tenders can help new groups to participate in tenders and increase government compliance.

• Tenders per government office
• Awards per government office
• Tender name
• Tender description
• Tender status
• Award title
• Award description
• Value of the award
• Supplier's name

http://global.survey.okfn.org/dataset/procurement

Beekeepers need farmer's contacts to inform them about an apiaries near their fields (to coordinate pesticide poisoning etc). I'd like to add that information to https://mesilad.mesindus.ee/#4/58.63/24.98/alus-kobarad

PRIA provides WFS service pria_avalik:pria_massiivid (DescribeFeatureType), (GetFeature), but it doesn't contain the information about the farmer (name, registry code, phone, email).

Data about the bills discussed within national parliament as well as votings on bills (not to mix with passed national law). Data on bills must be available for the current legislation period.

• Content of bill
• Author of bill
• Votes on bill per member of parliament
• Transcripts of debates on bill
• Status of bill

http://global.survey.okfn.org/dataset/draftlegislation

What's missing?

• Tallinn http://avaandmed.tallinn.ee/
• Tartu http://www.tartu.ee/avaandmed

Records of actual (past) national government spending at a detailed transactional level. A database of contracts awarded or similar will not be considered sufficient. This data category refers to detailed ongoing data on actual expenditure.

• Individual record of transactions
• Government office which had the transaction
• Date of transaction
• Name of vendor
• Amount of the transaction

http://global.survey.okfn.org/dataset/spending

Not sure if this exists, but a dataset which has a food services' health/safety scores would be interesting to work with.

Example: https://data.cityofchicago.org/Health-Human-Services/Food-Inspections/4ijn-s7e5

Example use case: https://github.com/Chicago/food-inspections-evaluation

Data about the daily mean concentration of air pollutants, especially those potentially harmful to human health. Data should be available for all air monitoring stations or air monitoring zones in a country.

• Particulate matter (PM)
• Sulphur oxides (SOx)
• Nitrogen oxides (NOx)
• Carbon monoxide (CO)
• Ozone
• Volatile organic compounds (VOCs)
• Available per air monitoring station/zone

http://global.survey.okfn.org/dataset/emissions

Key national statistics such as demographic and economic indicators (GDP, unemployment, population, etc). To satisfy this category, the following minimum criteria must be met:

GDP for the whole country updated at least quarterly
Unemployment statistics updated at least monthly
Population updated at least once a year

http://index.okfn.org/dataset/statistics/

A dataset which contained information regarding schools' performance would be beneficial to have.

A geographical map of the country including national traffic routes, stretches of water, and markings of heights. The map must at least be provided at a scale of 1:250,000 (1 cm = 2.5km).

• Scale of 1:250,000 (1 cm = 2.5km)
• Markings of national traffic routes
• Markings of relief/heights
• Markings of water stretches
• National borders

http://global.survey.okfn.org/dataset/map

Idea from Tartu hackathon:

A career choice guide that would rely on long term projection of various industries' demand which would also help build relevant knowledge and plan education.

A dataset which provided information on ongoing public works projects would be beneficial, this dataset should include: current projects, issued building permit, etc..

• Places
• When happened, wheather conditions, day-night.
• Description, what happened.
• Descriprion, what are street parameters.
• ...
  It is wery useful to know where, why and when accidents happen in traffic.
  When that kind of information is accessible, community organizations can make analytics and suggestions to Transportation Department. Or just pay attention, armed with data.

A bit of a pet peeve of mine is that the all the [meta]data produced daily by the public broadcaster (ERR) is not programmatically accessible. Or rather, it is in many cases, but hidden behind private, undocumented APIs. For example, Raadio 2 (likely analogous for other channels) has API endpoints to fetch air times for a particular programme or the schedule for a particular date. I have reverse engineered these for my purposes; when I enquired Raadio 2 about opening up / documenting the APIs, I got a terse response about these being for private use.

Basically, the means to fetch machine-readable data are already there, it would simply take some effort on ERR's part to document the APIs and maintain them so that they would be stable and usable for 3rd parties. This is where OK Estonia's lobby could help get things moving.

Example use case: a script to download shows from R2. Having open APIs and a welcoming culture for 3rd party developers would certainly create synergy here.

This data category requires results by constituency / district for all major national electoral contests.

• Results for major electoral contests
• Number of registered votes
• Number of invalid votes
• Number of spoiled ballots
• Data available at polling station level

http://global.survey.okfn.org/dataset/elections