Download - Citadel technical
![Page 1: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/1.jpg)
Open, Convert, UseThe Citadel Open Data ecosystem
![Page 2: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/2.jpg)
What is Citadel?• Citadel is a project co-funded by the EC
– To create a common European open data ecosystem– To allow apps to be used in different cities– To make it easy to open up data (for cities)– To make it easy to use this data (for citizens and developers )– Not only through standards, but through easy and usable tools as well
Open Convert Use
![Page 3: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/3.jpg)
Open
• Many governments are opening up data• Citadel focuses on cities
– Strong links with local community– But often lack in ICT budgets or know how (small cities)– Strong demand for Open Data!!
![Page 4: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/4.jpg)
![Page 5: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/5.jpg)
Benefits
• Inform – Allergies?– Make it visible which trees will need to be cut soon– Remarkable trees
• Engage citizens to identify risks, diseases• Crowd-source the information in a timely manner• Fun
![Page 6: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/6.jpg)
What took us so long?• We don’t check each tree every week• We don’t want to provide data that is inaccurate• We don’t have the exact geo-location for every tree.• We don’t know what the best format is to do so
![Page 7: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/7.jpg)
CSVThe Swiss army knife of open data
• simple• common• non-proprietary• easy to export (from Ecxel)• readable• …
![Page 8: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/8.jpg)
CSVCSV doesn’t always cut it• Different delimiters (tabs, semicolons, commas)
– “F. Mercury; musician” ≠ “F. Mercury”; “Musician”
• Encoding hell (Greek characters?)• Different line endings on different operating systems• Often has markup, subtitles, etc…• No semantics (which column names are used in France?)
![Page 9: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/9.jpg)
JRC Forest Map 2000. Source: EC-JRC – FRC Unit (earthzine.org)
![Page 10: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/10.jpg)
Open Convert Use
![Page 11: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/11.jpg)
Platform concept
• Open– Anyone can do it: publishing Excel files is a good
start• Convert– Converter tools transform and publish CSV/Excel
files (the majority of datasets) as “live” JSON files• Use– The App Generator Tool allows you to immediately
use selected datasets
![Page 12: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/12.jpg)
ODC architecture
![Page 13: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/13.jpg)
Converter development
• Version 1: on-line PHP– Test concept with partners and cities– Quick & dirty, but very simple to understand
• Version 2: off-line Java– More complex semantic functions– More stable development, possible batch use
• Version 3: on-line Java– Anytime, anywhere
![Page 14: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/14.jpg)
Demo
Converter
Data Days 2014, Ghent, 18 Feb 2014
![Page 15: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/15.jpg)
Interaction with Cities
• Enthusiastic reaction (we got something right)– 16 datasets converted over winter holidays
• Empowering civil servants as co-designers– Experimenting with prototypes, betas
• Motivating for data quality– Seeing the process end-to-end
![Page 16: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/16.jpg)
Ecosystem development
• Converter enhancements– Adaptations to convert other datasets
• New templates– New templates can be developed for different
data structures (eg socio-economic data)• Dataset enhancements– “Rich” datasets (eg containing links in text fields)
can link to external functionalities (ie reservations)
![Page 17: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/17.jpg)
Next Steps• Mobile access– Integration with AGT for on-the-fly conversions
• Support on-going day-to-day use– Save semantic mappings for re-use– Support batch processing– Integrate with AGT dataset listings
• Continue co-design with pilots
![Page 18: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/18.jpg)
Open Convert Use
![Page 19: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/19.jpg)
Citadel lifecycle
Open Convert Use
Data Days 2014, Ghent, 18 Feb 2014
![Page 20: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/20.jpg)
Data (re-)use
• Thousands of datasets are published every day– by public and private sources– in different formats– in many different domains
• Is there any value in publishing them?• Is it worth the effort/cost?• How are they used?
Data Days 2014, Ghent, 18 Feb 2014
![Page 21: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/21.jpg)
Citadel approach
• Make it easy to publish data• Make it easy for people to use data• Quick and simple apps– Increase the citizens’ innovation potential– Demonstrate the value of the dataset– Apps that can be used in different cities
Data Days 2014, Ghent, 18 Feb 2014
![Page 22: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/22.jpg)
How this is achieved
• Mobile application templates (for different types of data)– Parking– Events in the city– Points of Interest in the city– Crowd-sourcing Information– Environmental Data
• Application Generation Tool– 4 steps to create an app
• Citadel Hub– Documentation, resources, discussion forum
Data Days 2014, Ghent, 18 Feb 2014
![Page 23: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/23.jpg)
Citadel Mobile Application Templates
• Common template features:– HTML5, jQuery mobile, php ( + mysql)
– Datasets in common JSON format• Environmental uses Xively feeds
– 'Near-me' functionality using HTML5 geo-location feature
– Map and list views
– Category based filtering • All categories loaded dynamically
– Back end functionality for storage
Data Days 2014, Ghent, 18 Feb 2014
![Page 24: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/24.jpg)
• Information about the parking lots in a city
• List of total/available parking places
• List of places for disabled's people vehicles
• Variation: On-Street parking
Parking places
Data Days 2014, Ghent, 18 Feb 2014
![Page 25: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/25.jpg)
Events in the city
• Different event
categories: festivals,
exhibitions,
presentations, etc.
• Detailed description of
each event: time, place,
fees, transportation,
pictures
• Filter by date
• Add to favorites
Data Days 2014, Ghent, 18 Feb 2014
![Page 26: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/26.jpg)
• Different categories of
PoIs: museums, hotels,
restaurants, etc.
• Filtering function
• Detailed description of
each PoI
• Voting mechanism
• Add to favorites
Points of Interest (PoIs) in the city
Data Days 2014, Ghent, 18 Feb 2014
![Page 27: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/27.jpg)
User-generated PoIs or crowd-sourced information
• “Add new PoI”
functionality
• Different categories of
user-generated PoIs
• Detailed description of
each user-generated
PoI
• “Add to favourites”
Data Days 2014, Ghent, 18 Feb 2014
![Page 28: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/28.jpg)
Environmental data
• Xively feeds
• Environmental data for
different locations
(simulation of live feeds for
Athens and Manchester).
• Available sensors shown on
the map
• Detailed page shows
environmental data for
each sensor (including
historical data)
Data Days 2014, Ghent, 18 Feb 2014
![Page 29: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/29.jpg)
Demo
AGT
Data Days 2014, Ghent, 18 Feb 2014
![Page 30: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/30.jpg)
Application Generation ToolScreenshots 1/2
Data Days 2014, Ghent, 18 Feb 2014
![Page 31: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/31.jpg)
Application Generation ToolScreenshots 2/2
Data Days 2014, Ghent, 18 Feb 2014
![Page 32: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/32.jpg)
• The power of open data lies, not only on publishing, but on re-using Public administrators become aware of what data
is useful or interesting for citizens The relationship between City officials and citizens
is strengthened The innovation potential of citizens increases in a
very participatory way
Data Days 2014, Ghent, 18 Feb 2014
In summary...
![Page 33: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/33.jpg)
Thimo Thoeye (City of Gent)
Jesse Marsh (Alfamicro)
Evangelos Argyzoudis (Intrasoft Intl)
Data Days 2014, Ghent, 18 Feb 2014
Open
Convert
Use
Thank you!
![Page 34: Citadel technical](https://reader033.vdocuments.us/reader033/viewer/2022061123/5474af7ab4af9f980a8b575a/html5/thumbnails/34.jpg)
Thank you for your attention
Thimo Thoeye (Stad Gent), [email protected] Marsh (Alfamicro), [email protected]
Leonardo Dal Zovo (Alfamicro), [email protected] Argyzoudis (Intrasoft), [email protected]
Leonidas Kallipolitis, [email protected]