New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Challenge: improve urban mobility! #72

Open
infokujur opened this Issue Apr 28, 2017 · 26 comments

Comments

Projects
None yet
7 participants
@infokujur
Member

infokujur commented Apr 28, 2017

Please link here all relevant info/data sources etc!

Descritpion:
We are waiting: city activists, mobility experts interested in improving urban space, infrastructure geeks, archidects designing common space!

This challenge is focusing on using data to create effective and sustainable mobility models. How to make smooth trips and interchanges for commuting between urban and suburban areas? What innovations are most needed to provide cost-effective, need-based and sustainable modes of transport? How can we provide more accessible public transport for people with special needs? What kind of innovative and sustainable transport solutions could be offered to statisfy the mobility demand of people living in suburban and rural areas?

Challenge is supported by Ministry of Economic Affairs and Communications and Tallinn Region Sustainable Urban Mobility strategic planning process.

@infokujur

This comment has been minimized.

Show comment
Hide comment
@infokujur
Member

infokujur commented Apr 28, 2017

@infokujur

This comment has been minimized.

Show comment
Hide comment
@infokujur

infokujur May 5, 2017

Member

Public transport registry: www.peatus.ee/gtfs

Member

infokujur commented May 5, 2017

Public transport registry: www.peatus.ee/gtfs

@infokujur

This comment has been minimized.

Show comment
Hide comment
@infokujur

infokujur May 5, 2017

Member

Spatial data, incl base map of Tallinn and 3-D models: https://veeb.tallinnlv.ee/pilv/index.php/s/JWpQk2sP1Qd2nBn

Member

infokujur commented May 5, 2017

Spatial data, incl base map of Tallinn and 3-D models: https://veeb.tallinnlv.ee/pilv/index.php/s/JWpQk2sP1Qd2nBn

@infokujur

This comment has been minimized.

Show comment
Hide comment
@infokujur

infokujur May 5, 2017

Member

Kredex/Emor (2015) - Questionaire data of 4000 people of Tallinn - how and why people are moving - to map patterns of moving.
https://www.dropbox.com/s/nntxk6bwnhnqlx2/2015%20Tallinna%20uuringu%20tulemused.zip?dl=0

Member

infokujur commented May 5, 2017

Kredex/Emor (2015) - Questionaire data of 4000 people of Tallinn - how and why people are moving - to map patterns of moving.
https://www.dropbox.com/s/nntxk6bwnhnqlx2/2015%20Tallinna%20uuringu%20tulemused.zip?dl=0

@infokujur

This comment has been minimized.

Show comment
Hide comment
@infokujur

infokujur May 5, 2017

Member

Maaameti (Land Board) geoportaal - #12

Member

infokujur commented May 5, 2017

Maaameti (Land Board) geoportaal - #12

@infokujur

This comment has been minimized.

Show comment
Hide comment
@infokujur

infokujur May 5, 2017

Member

National statistics #9

Member

infokujur commented May 5, 2017

National statistics #9

@infokujur

This comment has been minimized.

Show comment
Hide comment
@infokujur
Member

infokujur commented May 5, 2017

Population registry: http://www.rahvastikuregister.ee/

@infokujur

This comment has been minimized.

Show comment
Hide comment
@infokujur

infokujur May 5, 2017

Member

Addresses and other locations datasets #2

Member

infokujur commented May 5, 2017

Addresses and other locations datasets #2

@tormi

This comment has been minimized.

Show comment
Hide comment
@tormi

tormi May 5, 2017

Contributor

This might suite here as well - Anna teada (Estonian version of FixMyStreet): #76

Contributor

tormi commented May 5, 2017

This might suite here as well - Anna teada (Estonian version of FixMyStreet): #76

@taavilooke

This comment has been minimized.

Show comment
Hide comment
@taavilooke

taavilooke May 11, 2017

All the Estonian public transit lines with locations of stops and timetables from the Estonian Road Administration
https://www.mnt.ee/et/uhistransport/uhistranspordi-infosusteem

taavilooke commented May 11, 2017

All the Estonian public transit lines with locations of stops and timetables from the Estonian Road Administration
https://www.mnt.ee/et/uhistransport/uhistranspordi-infosusteem

@taavilooke

This comment has been minimized.

Show comment
Hide comment
@taavilooke

taavilooke May 11, 2017

Maybe this might be useful as well: Interface for queries about the city planning documents (detailplaneeringud ja üldplaneeringud) in Tallinn http://www.tallinn.ee/est/ehitus/Masinliides

taavilooke commented May 11, 2017

Maybe this might be useful as well: Interface for queries about the city planning documents (detailplaneeringud ja üldplaneeringud) in Tallinn http://www.tallinn.ee/est/ehitus/Masinliides

@McSim

This comment has been minimized.

Show comment
Hide comment
@McSim

McSim May 11, 2017

I saw a dataset of car crashes in Estonia, but cannot find it now. It was from Liikluskindlustus fond.
Does anybody know where it was?

McSim commented May 11, 2017

I saw a dataset of car crashes in Estonia, but cannot find it now. It was from Liikluskindlustus fond.
Does anybody know where it was?

@wipsise

This comment has been minimized.

Show comment
Hide comment
@wipsise

wipsise May 12, 2017

LKF data is currently not open. Statistical reports can be found:
http://www.lkf.ee/et/statistika-ja-uuringud
Crash map
http://kindlustus.maps.arcgis.com/apps/Viewer/index.html?appid=abd977aeea074631845cc67bfc3da87d
LKF statistics contains "only" events with insurance cases.
Maanteeamet data contains events on highways outside urban areas that are registered by the police.

wipsise commented May 12, 2017

LKF data is currently not open. Statistical reports can be found:
http://www.lkf.ee/et/statistika-ja-uuringud
Crash map
http://kindlustus.maps.arcgis.com/apps/Viewer/index.html?appid=abd977aeea074631845cc67bfc3da87d
LKF statistics contains "only" events with insurance cases.
Maanteeamet data contains events on highways outside urban areas that are registered by the police.

@keeganmcbride

This comment has been minimized.

Show comment
Hide comment
@keeganmcbride

keeganmcbride May 12, 2017

Collaborator

@McSim I have this data, they only asked that you cite the source and time period.

https://github.com/OpenGovIntelligence/EstonianRealEstatePilot/blob/master/applicationDevelopment/datasets/crashDataCleanedFixed.RDS

Is a link to the RDS file. In the EstonianRealEstatePilot readme there is a link to the dataset, but it has not been cleaned correctly and needs to be changed there. However, this link should be correct though, simply cite as Liikluskindlustus fond 2013-2016. https://drive.google.com/open?id=0B-uo-u1vqujbZWhtYi1jbU1OZE0

Collaborator

keeganmcbride commented May 12, 2017

@McSim I have this data, they only asked that you cite the source and time period.

https://github.com/OpenGovIntelligence/EstonianRealEstatePilot/blob/master/applicationDevelopment/datasets/crashDataCleanedFixed.RDS

Is a link to the RDS file. In the EstonianRealEstatePilot readme there is a link to the dataset, but it has not been cleaned correctly and needs to be changed there. However, this link should be correct though, simply cite as Liikluskindlustus fond 2013-2016. https://drive.google.com/open?id=0B-uo-u1vqujbZWhtYi1jbU1OZE0

@McSim

This comment has been minimized.

Show comment
Hide comment
@McSim

McSim May 14, 2017

@keeganmcbride Thank you! I am not a programmer. I made some simple variant of vizualization in python.
https://github.com/McSim/tallinn-car-crashes

McSim commented May 14, 2017

@keeganmcbride Thank you! I am not a programmer. I made some simple variant of vizualization in python.
https://github.com/McSim/tallinn-car-crashes

@infokujur

This comment has been minimized.

Show comment
Hide comment
@infokujur

infokujur May 16, 2017

Member

Closed data what will be available in the event:

  • Green card (public transport of Tallinn) validation data - > 2 weeks (dump)
  • State of real-estate (housing) by local authorities from National Audit Office
Member

infokujur commented May 16, 2017

Closed data what will be available in the event:

  • Green card (public transport of Tallinn) validation data - > 2 weeks (dump)
  • State of real-estate (housing) by local authorities from National Audit Office
@tormi

This comment has been minimized.

Show comment
Hide comment
@tormi

tormi May 16, 2017

Contributor

State of real-estate (housing) by local authorities

Could you please elaborate more on this?

Contributor

tormi commented May 16, 2017

State of real-estate (housing) by local authorities

Could you please elaborate more on this?

@joellimberg

This comment has been minimized.

Show comment
Hide comment
@joellimberg

joellimberg May 16, 2017

@infokujur

"Green card (public transport of Tallinn) validation data - > 2 weeks (dump)"

Any info/example on what the data contains? My default assumption would be:

  • timestamp
  • (hashed/anonymized) card number
  • location (what bus/tram nr at what GPS location)

Does this look ok, or are my assumptions off?

joellimberg commented May 16, 2017

@infokujur

"Green card (public transport of Tallinn) validation data - > 2 weeks (dump)"

Any info/example on what the data contains? My default assumption would be:

  • timestamp
  • (hashed/anonymized) card number
  • location (what bus/tram nr at what GPS location)

Does this look ok, or are my assumptions off?

@infokujur

This comment has been minimized.

Show comment
Hide comment
@infokujur

infokujur May 18, 2017

Member

@tormi
State of real-estate (housing) by local authorities from National Audit Office
Dataset is in Estonian.
Contains 3 parts:
1) Questionaire/answers with administrator of the real-estate (214 rows/local authorities present)
2) Questionaire/answers about buildings owned by given authority (6200+ rows)
Headers:
KOV
Maakond
Hoone nimi
Hoone aadress või maaüksuse nimi
Hoone ehitisregistri kood või selle puudumisel ADS-OID
Omanik
Kasutusotstarve 2015. aasta jooksul
Suletud netopind vastavalt kasutus-otstarbele (m2)
Majandamiskulu (m2 kohta) vastavalt kasutusotstarbele 2015 (kontod 551100, 551101, 551102, 551103, 551104, 551105, 551107)
Korrashoiu- ja valveteenuse täpsustus
Ruumide kasutajate arv 31.12.2015 seisuga
Hoone amortisatsiooni norm (%)
Hoone jääkmaksumus 31.12.2015 seisuga
Akumuleeritud kulum (konto 155110) 31.12.2015 seisuga
Hoone seisukord
Lammutamise maksumus (vajadusel)
Vajaliku hoone investeerimise vajadus viie aasta perspektiivis
Märkused
3) Small set about apartments (how many, total size, not in use) owned by local authority (214 rows/authorities).

Member

infokujur commented May 18, 2017

@tormi
State of real-estate (housing) by local authorities from National Audit Office
Dataset is in Estonian.
Contains 3 parts:
1) Questionaire/answers with administrator of the real-estate (214 rows/local authorities present)
2) Questionaire/answers about buildings owned by given authority (6200+ rows)
Headers:
KOV
Maakond
Hoone nimi
Hoone aadress või maaüksuse nimi
Hoone ehitisregistri kood või selle puudumisel ADS-OID
Omanik
Kasutusotstarve 2015. aasta jooksul
Suletud netopind vastavalt kasutus-otstarbele (m2)
Majandamiskulu (m2 kohta) vastavalt kasutusotstarbele 2015 (kontod 551100, 551101, 551102, 551103, 551104, 551105, 551107)
Korrashoiu- ja valveteenuse täpsustus
Ruumide kasutajate arv 31.12.2015 seisuga
Hoone amortisatsiooni norm (%)
Hoone jääkmaksumus 31.12.2015 seisuga
Akumuleeritud kulum (konto 155110) 31.12.2015 seisuga
Hoone seisukord
Lammutamise maksumus (vajadusel)
Vajaliku hoone investeerimise vajadus viie aasta perspektiivis
Märkused
3) Small set about apartments (how many, total size, not in use) owned by local authority (214 rows/authorities).

@infokujur

This comment has been minimized.

Show comment
Hide comment
@infokujur

infokujur May 18, 2017

Member

@joellimberg
"Green card (public transport of Tallinn) validation data - > 2 weeks (dump)"

Well I got a moment to take a look. Great, we have whole March here :)!

Headers + first row and last row (total ca 4,5 milj journeys/rows):

pikas_transp_date;real_date;transp_date;real_date;time_slot;from_stop;to_stop;zone_from;zone_to;from_stop_name;to_stop_name;tln;har;sum_all
2016-03-01;2016-03-02;1;2016-03-02;00:00:00;309;901;2008;2010;Zoo;Sinilille;1;0;1
2016-03-31;2016-03-31;1;2016-03-31;23:30:00;;;;;;;39;1;43

Also added two files what are containing example analyses of one line - simple excel
And results (summary - aggregated per line) about a query what was made for understading how much people actually validate themselves.

Member

infokujur commented May 18, 2017

@joellimberg
"Green card (public transport of Tallinn) validation data - > 2 weeks (dump)"

Well I got a moment to take a look. Great, we have whole March here :)!

Headers + first row and last row (total ca 4,5 milj journeys/rows):

pikas_transp_date;real_date;transp_date;real_date;time_slot;from_stop;to_stop;zone_from;zone_to;from_stop_name;to_stop_name;tln;har;sum_all
2016-03-01;2016-03-02;1;2016-03-02;00:00:00;309;901;2008;2010;Zoo;Sinilille;1;0;1
2016-03-31;2016-03-31;1;2016-03-31;23:30:00;;;;;;;39;1;43

Also added two files what are containing example analyses of one line - simple excel
And results (summary - aggregated per line) about a query what was made for understading how much people actually validate themselves.

@joellimberg

This comment has been minimized.

Show comment
Hide comment
@joellimberg

joellimberg May 18, 2017

@infokujur very cool, thanks.

Two questions (sorry):

1. Also added two files…

Where are these files you speak of? :)

2. the csv example:

  • Are there extra files with data about the from_stop/to_stop codes? (and the other, more cryptic fields?)
  • Do you happen to have any idea on how the "to stop…" data is determined? Validation only occurs on entry… ¯_(ツ)_/¯

joellimberg commented May 18, 2017

@infokujur very cool, thanks.

Two questions (sorry):

1. Also added two files…

Where are these files you speak of? :)

2. the csv example:

  • Are there extra files with data about the from_stop/to_stop codes? (and the other, more cryptic fields?)
  • Do you happen to have any idea on how the "to stop…" data is determined? Validation only occurs on entry… ¯_(ツ)_/¯
@infokujur

This comment has been minimized.

Show comment
Hide comment
@infokujur

infokujur May 18, 2017

Member
  • Green Card data at the moment is closed and accessible only at the event.
  • No extra things. All listed whats there.

I do have an idea, but I don't know for sure - probably they count times and frequencies.
This example analyse will give insights to this prbl.

Member

infokujur commented May 18, 2017

  • Green Card data at the moment is closed and accessible only at the event.
  • No extra things. All listed whats there.

I do have an idea, but I don't know for sure - probably they count times and frequencies.
This example analyse will give insights to this prbl.

@tormi

This comment has been minimized.

Show comment
Hide comment
@tormi

tormi May 18, 2017

Contributor

@infokujur, thanks! I don't understand how this can be closed data. Are you sure you understood correctly? I don't see anything non-public here in terms of Public Information Act.

Contributor

tormi commented May 18, 2017

@infokujur, thanks! I don't understand how this can be closed data. Are you sure you understood correctly? I don't see anything non-public here in terms of Public Information Act.

@tormi

This comment has been minimized.

Show comment
Hide comment
@tormi

tormi May 18, 2017

Contributor

Ok, most of the data of "State of real-estate (housing) by local authorities from National Audit Office" is available here: https://www.google.com/maps/d/viewer?mid=1xR9KNkQ8deFbaC2EgB7-oK142T4 (via VK_KOVid_teavitus_KKotto_08_02_17__1_.PDF)

Contributor

tormi commented May 18, 2017

Ok, most of the data of "State of real-estate (housing) by local authorities from National Audit Office" is available here: https://www.google.com/maps/d/viewer?mid=1xR9KNkQ8deFbaC2EgB7-oK142T4 (via VK_KOVid_teavitus_KKotto_08_02_17__1_.PDF)

@infokujur

This comment has been minimized.

Show comment
Hide comment
@infokujur

infokujur May 19, 2017

Member

We have now 1 year Tartu public transport info uploaded to the cloud.

Member

infokujur commented May 19, 2017

We have now 1 year Tartu public transport info uploaded to the cloud.

@infokujur

This comment has been minimized.

Show comment
Hide comment
@infokujur

infokujur May 19, 2017

Member

@tormi working on it ;)

Member

infokujur commented May 19, 2017

@tormi working on it ;)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment