Home

ODAI-WP5-D2 - Open-DAI

1. 28 1 2 1 2 Pilot documentation uuareseasuanmemmnsnnianniivv 29 1 2 1 2 1 Pilot code repository EE 29 1 2 1 2 2 How to install and deploy EE 30 Ee PUBLIC CONFIDENTIAL 3 www opendai eu OPEN x i DAI 220 amp Infrastructures GH Pilots development report NE MAMMA EE 31 1 2 2 Correlation between environment and mobility Web App 32 1 2 2 1 Pilot development 32 1 2 2 1 1 Followed development 0 34 1 2 2 1 2 Development results asnasmummrmesrseinernnenersaansasndanseknankvan 34 herr Pilot documentation zsrsr tegna e 35 1 2 2 2 1 Pilot code repository EE 35 1 2 2 2 2 How to install and deploy 35 12225 User Mariali danda RU Ee 36 1 3 Lleida operstoen 38 1 3 1 Road Incidents and Accessibility Mobile App 38 1 3 1 1 Pilot developiTieril iiie inus de di sen ka pack a2 eto DdcnER aere den dad ide ii 38 1 3 1 1 1 Followed development 0 40 1 3 1 1 2 Development reSUlls sucio rua token titi waioeu abus aurai n pU GEM RR D Eua 40 1 3 1 2 Pilot documentation ocaeca itte einen an addc pierdan 41 1 3 1 2 1 Pilot code repository uus cce eben eclesia anoo pntant 4
2. m p 7 sl Figure 33 Screenshot query 2 4 1 1 1 Followed development plan M9 M10 M11 M12 M13 M14 M15 M16 M17 M18 Final data design Services development App Mobile development Services testing App testing PUBLIC CONFIDENTIAL 59 www opendai eu OPEN i DAI 20 amp Infrastructures 2 2 Pilots development report Deploying publishing a and 2 4 1 1 2 Development results OrduServices provide a set of information that is designed to simplify the life in Ordu and it enables citizens and 3rd party developers to access daily information easily Currently in Ordu this type of information content is only managed and generated by the Public Authority and citizens are only able to get information using the Call Center Secondly these services provide different kinds of information about the nearest garbage bin according to its properties APIs https api opendai eu store apis info name OrduServices amp version 1 0 0 amp provider Tur keyAdmin More information can be found on the deliverable D6 1 as part of WP6 and also on the documentations in the API Store documentation part Mobile Application An Android application was prepared to distribute the data and make shown in the No map Figure 34 Mobile App image ES PUBLIC CONFIDENTIAL 60 www opendai eu OPEN DAI Opening Data e Architectures amp Infrastructures ied
3. stations id startDate AA List of sensors of a Id Id of the station AMMMGGG amp endDate AA station AMMMGGG startDate Optional date to require stations active from date endDate Optional date to require stations active until date parameters List of parameters data stations idstation1 id The measured stations The list of sensors of par1 idpar2 idstation2 idpar data for required each station to get 3 amp parameters of the data startDate AAAMMMGGG amp stated stations endDate AAAMMMGGG startDate Optional date to require data from date endDate Optional date to require data until date The documentation on the entity returned by the API can be found on the EU web site http dd eionet europa eu schemaset id2011850eu view http dd eionet europa eu schema id2011850eu 20130712 IPR Mapping xIsx view ES PUBLIC CONFIDENTIAL 22 www opendai eu OPEN x i y DAI 20 amp Infrastructures p gt Pilots development report 2 1 4 Transport API Abstract API publishing transports information Technologies used on pilot Data sources silos e Open DAI platform Transport dataset 2 1 4 1 Pilot development This pilot suffered by a DB migration problem due to the fact that the legacy owner started a migration towards a new software system after the project start This caused a reduction in the scope of the project and a reduction of the data set that has bee
4. Parades de Bus Hospitality Bus Lines Bus Alertes Powered by Leaflet Map data OpenStreetMap contributors CC BY SA Imagery CloudMade Figure 23 Screenshot Data Publication 2 3 2 2 Pilot documentation 2 3 2 2 1 Pilot code repository Github repository https github com open dai bcn lleida opendai pilots On Github repository we can found all the code necessary for Pilot divided on e jboss teiid apis the code to implement the TEIID data virtualization to connect to original data sources Silos e web geo server the application back end including the Geo Server and the web resources needed by the web app 2 3 2 2 2 How to install and deploy The process to install this pilot is the same than the needed to deploy the Open DAl platform as it is detailed on the WP4 deliverables Inside this platform this Pilot uses JBoss server and TEIID tool for the data virtualization e Virtual machines for the application servers e API Manager for API publication As it has been previously explained this pilot is composed of a mobile app a backend service over the Open DAI infrastructure To deploy these artefacts step by step we need to follow ES PUBLIC CONFIDENTIAL 47 www opendai eu OPEN DAI Opening Data y Architectures amp Infrastructures p Cip Pilots development report Data virtualization artefact The pilot calls to REST API from Open DAI WSO2 infrastructure This API is
5. 15 142235 User 000 76 lwen e ENN 79 ES Ne e 79 1 5 1 1 Pilot development E 80 1 5 1 1 1 Followed development plan 81 23 PUBLIC CONFIDENTIAL 4 www opendai eu OPEN GE p Cip Pilots development report 15112 Deelipnentresuks eenegen g eegente EN 1 5 1 2 le e eet E 82 15 121 Pilot code repository u u uiunuimiineisnie dssmsiiesersss setntik 82 1 5 1 2 2 How to install and deploy annannannnnnennnneennneennnnnnnnnn nnne eeenne 82 15122 User Manual tc 83 List of Figures Figure 1 Block diagram TWIST accident publishing 8 Figure 2 Image WEB e ME 9 Figure 3 Main use case TWIST accident 0 6 9 10 Figure 4 Block diagram TWIST real time collection cece eeeeeeeeeeeeeeeeeeeeeeeeeeeees 12 Figure 5 Image TWIST real time collection 13 Figure 6 Main use case TWIST real time 60 86 0 14 Figure 7 Image registration Process esagesdeege cen EeeeEEeEeEE Eeer 16 Figure 8 Image login DrODOSE uitiis coron talk c e aan andes EE RE Reggae 16 Figure E ne neie 17 Figure 10 Mobile App Figure 11 Mobile App SaveMe 18 Figure 12 Block diagram Air Quality sxe
6. 53 e e UE ee 54 Figure 29 City Dynamics Worklowell 55 e e UI Ee EE TE 56 Figure 31 Screenshot information EE 57 Figure 32 Screenshot geilnf rmation sssmemmimiinieeimirisisiinmiui etatene 58 Figure 33 Screenshot qUENV d 59 Figure 34 Mobile App ne CN 60 Figure 35 Mobile App TE paeem tdt aa armas ipu Qd e 61 Figure 36 City Dynamics Deployment Diagram 62 Figure 37 City Dynamics Use Case1 Get Garbage Collection Hours By Location 63 Figure 38 City Dynamics Use Case2 Get Garbage Collection Hour 63 Figure 39 City Dynamics Use Case3 3rd Party Development 64 PUBLIC CONFIDENTIAL 5 www opendai eu OPEN GE p Cip Pilots development report Figure 40 City Dynamics Use Case4 System Administration 65 Figure T Block Diagram EE 67 Figure 42 POI Nok cx 68 Figure 43 Screenshot sample 8 68 69 Figure 44 Screenshot request 5 2222 70 Figure 45 Screenshot request ClosestPOl 2 71 Figure 46 Screenshot list CW c seeme
7. Not Now x Personalizza le azioni dei pulsanti 118 al dicat J Save Figure 9 Customization process SmartPhone app The smart phone application is as simple as possible There is a settings area where the user will enter the code received in the registration mail The user can also set the application in testing mode to prevent the application to save the data or calling the emergency number but testing the mail sending to assert that the application is really working Setting this option activate a blinking message in the main screen Ee PUBLIC CONFIDENTIAL 17 www opendai eu OPEN y DAI 20 amp Infrastructures p gt Pilots development report 8 GT 19000 leE ct 19000 LOLI RENET LEZ all B 12 20 SaveMe ME Numero di telefono E E Identificativo Open DAI 118 Modalit di Test attiva Incidente Versione I Messaggio Segnala Pos 45 037125N 7 651363E Ela am ul m rds al al ey Figure 10 Mobile App Figure 11 Mobile App SaveMe The main screen offers just the 4 buttons that allows to send the message and signal the different types of emergency as described in the pilot description ES PUBLIC CONFIDENTIAL 18 www opendai eu OPEN x i y DAI 20 amp Infrastructures GH Pilots development report 2 1 3 Air Quality Abstract API for publishing air quality information accordingly to
8. On Github repository we can found all the code necessary for Pilot divided on e jboss teiid apis the code needed to implement the TEIID data virtualization to connect to original data sources Silos e web geo server the application back end including the Geo Server and the resources needed for the web app 2 2 2 2 2 How to install and deploy The process to install this pilot is the same as to deploy the Open DAI platform it is detailed on the WP4 deliverables Inside this platform this Pilot uses JBoss server and TEIID tool for the data virtualization Virtual machines for the application servers e API Manager for API publication ES PUBLIC CONFIDENTIAL 35 www opendai eu OPEN DAI Opening Data Architectures amp Infrastructures cip Pilots development report As it has been explained previously this pilot is composed of a mobile app a backend service over the Open DAI infrastructure In order to deploy these artefacts step by step we need to follow Data virtualization artefact The pilot calls to REST API from Open DAI WSO2 infrastructure This API is composed by a WAR apibarcelona war for JBOSS and custom Translators for TEIID To deploy this API is required the source code and the JBOSS TEIID environment The data used by the pilot is virtualized on a virtual DB barcelona_base_vdb vdb deployed also in TEIID All configuration required is included on the war file and this should be deployed a
9. lt fm Yo Legacy Host Figure 13 Block diagram Pollution monitor for outdoor activities In the diagram there are two types of artefacts The orange nodes are the Open DAI platform nodes while the green ones are the external nodes Describing the artefacts on detail On Public administration host are localized the legacy data sources connected to the Open DAI Platform The first artefact as part of Open DAI platform is the TEIID data virtualization system adapted to Barcelona city silos ES PUBLIC CONFIDENTIAL 27 www opendai eu OPEN x i DAI 27 25 p amp Infrastructures GH Cipz Pilots development report Over the data virtualization the API manager provided by WSO2 framework offers access and control to the REST APIs publishing publicly an API store Also part of Open DAI platform is designed and developed using Django framework the back end required by the mobile application This back end is composed by 2 artefacts o A Geo server artefact developed using geodjango required by mobile app for the geospatial services such as geonaming reverse resolution and some different trigonometric functions o An application server developed using django with services and logic functions required by mobile application on purpose to light the computation on the mobile device The access on the back end services is provided and controlled by a proxy implemented with NGinx At the end a cross platform mobile appl
10. uses uses List POIs by area uses Citizen or Tourist Get route to POI Figure 51 POI Use Case1 Citizen Tourist POI Information Actions Description List POI types User is able to see to POI types Show POIs on map User can see POIs on a map List POls by type User can search for POls by type List POls by area User can search for POls by area List closest POI by type User can find closest POI for related POI type Get POI information User can reach the POI information Get route to POI User is able to get route to POI from user location Ee PUBLIC CONFIDENTIAL TT www opendai eu OPEN DAI Opening Data y Architectures amp Infrastructures Le Pilots development report Use Case 2 3 Party Development Figure 52 POI Use Case2 3rd Party Development Actions Description Get WMS User can reach the maps as images for an area Get WFS User can reach the vector spatial data for an area List POI types User is able to see to POI types List POls by type User can search for POls by type Get POI information User can reach the POI information Use Case 3 System Administration System Administrator Publish WMS and WFS Figure 53 POI Use Case3 System Administration Actions Description Update POls Admin is able to create update or delete a POI Update POI types Admin is able to create update or delete a POI type Publish
11. 9 Get Closest Garbage Collections Hour Information Get Closest Garbage Collections Hour Information Asks for Closest Garbage Collection Hours Citizen Calls Ordu Call Center Get Garbage Collections Hours Opens the Map Find Citizen Location by Address Find Closest Can Opens the Map Ordu Municipality City Dynamics Process Flow Get Garbage Collections Hours Call Center Agent Figure 26 City Dynamics Workflow l Here we present the screenshots of sample SOAP UI requests and their expected results for our basic webservice operations which are presented in the workflow diagram above listTheCansByStreet In this sample request we sent a mahalle id neighbourhood value for querying the cans and their information which are available in that neighbourhood Expected outcome of these operations is that we can get each of garbage cans detailed informations such as type company street district info etc Ee PUBLIC CONFIDENTIAL 52 www opendai eu OPEN Opening Data DA Architectures amp Infrastructures Pilots development report Request 1 box Sg zo http 182 168 34 231 2112 services OpenDaiServices vj 4 s0apenv Envelope xmins soapenve http fschemas xmisoap or N soap Envelope xmins s0ap http schemas xmlsoap o
12. F r att rapportera m ste du logga in Ki Logga in med Facebook deg Lean fg bet Figure 55 Example App 1 PUBLIC CONFIDENTIAL 81 www opendai eu OPEN DAI opening Data Architectures amp Infrastructures d Cip Pilots development report Carrier amp 3 46 PM 194 116 110 159 v lt ig til Figure 56 Example App 2 2 5 1 2 Pilot documentation 2 5 1 2 1 Pilot code repository Github repository https github com open dai netport pilot In the repository you find the source code for both the server API and the application The server works as an API for the application It also serves the application as a web server 2 5 1 2 2 How to install and deploy To run the application you have to have node js and node package manager npm installed To install first you have to fetch the repository from github Then you have to run commands to install the dependencies which are used by the application and the server The commands are npm install for installing the npm dependencies bower install for installing the bower dependencies To build and deploy you will have to run the command grunt build Which will concatenate the files and minimize them to save loading times You can then run node server js in the build directory 23 PUBLIC CONFIDENTIAL 82 www opendai eu OPEN DAI Opening Data y Architectures amp Infrastructures cip Pilots development report The
13. L s0apenv Envelope xmins soapenve http schemas xmlsoap org soap 4 z soap Envelope xmins soap http schemas xmlsoap org soap envelope gt a lt soapenv Header gt lt soap Body gt gt lt soapenv Body gt lt ns2 QueryClosestPOlResponse xmins ns2 http servis esb opendai socbs sampas com E ser GueryClosestPOl E returns C Optional gt lt poiList gt xqueryClosestPOlRequest description 313 descriptions zt Optionat name AC AR ECZANESI inamez coordinate lt poiType gt Eczanes poiType gt sL Optional gt x gt 37 878337665220414 x gt slatitude gt 37 7 latitude lt y gt 40 98389074431245 y gt C Optionat poiList gt longtitude gt 40 70 Aongtitude gt ireturn ns2 QueryClosestPOlResponse gt coordinate gt lt soap Body gt C Optional soap Envelope gt lt poiType Eczane lt poiType gt iqueryClosestPOlRequest lt ser QueryClosestPOl gt lt soapeny Body gt s0apenv Envelope gt EX gt bld C pla Figure 45 Screenshot request ClosestPO Also there are other helpful requests Some of them are listTheAddressCity This operation gives all the cities and their Id s PUBLIC CONFIDENTIAL 71 www opendai eu OPEN Opening Data DA Architectures amp Infrastructures Request 1 Pilots development repo ae http 192 168 34 231 2112 services OpenDaiServ
14. cip Pilots development report In the application user can select the types of the garbage bins to locate them on the map tr LC Figure 35 Mobile App image 2 4 1 2 Pilot documentation 2 4 1 2 1 Pilot code repository Github repository https github com open dai ordu pilot citydynamics The source code of the CityDynamics project which was coded in Java is available in the repository The respective packages and class files can be seen there There is a simple document named README md which basically sums up the methods their aim and usage Also the main actions and their related webservice operations are available there 2 4 1 2 2 How to install and deploy The Deployment Diagram for City Dynamics services in Open Data Platform is given as follows Es PUBLIC CONFIDENTIAL 61 www opendai eu OPEN x i y DAI 20 amp Infrastructures GH Pilots development report Legacy DB Figure 36 City Dynamics Deployment Diagram 2 4 1 2 3 User Manual Use Case 1 Get Garbage Collection Hours By Location Users are able learn garbage collections hours for the closest cans using their application This use case defined the actions that can be taken by the citizen or the call center agent by location information Geoserver is used for serving geographical data
15. deployed also in TEIID All configuration required is included on the war file and this should be deployed as a web application on JBOSS server included in this case on Open DAI platform Application Back end The Backend service is developed using Python django framework To deploy these services the source code and a server with Python 2 7 and Django 1 6 x are required The django applications run using WSGI technology behind a proxy web server In our case we used Gunicorn as WSGI provider and NGINX server as a proxy This application has to run on the same network where the TEIID artefact publishes the APls Then it is only needed to configure the IP address of this APIS on the django application settings Application Front end The Mobile App is developed using Titanium framework This is a cross platform technology allowing the deployment on different App markets iOS and Android The required items needed to deploy the apps are the source code the Titanium Studio Environment 3 1 x and the Apple and Android market environments Once the Android and iOS apps are built with the titanium studio is necessary follow the official methodology to deploy Apps on the Google and Apple markets 2 3 1 2 3 User Manual The app allows finding services nearby in these case restaurants with particular features in this case an enabled exterior space The user is able to select one or more features among a list that it is displayed with a
16. isoapenv Envelopes soapenv Envelope xmlns soapenve http schemas xmlsoap orgisoap envelg 4 N T Raw XML soap Envelope xmins soap http schemas xmlsoap org soap envelope soap Bodys return gcCollectScheduleltemList comment COP TOPLAMA comment gt lt companyld gt 53000 companyld gt lt day gt 1 lt day gt districtTypes lt id gt sidistrictType gt lt finishTime gt value 201 1 10 03 12 00 00 0 lt value gt ifinishTimes period period startTime valuez2011 10 03 08 00 00 0 value istartTime streetType gt sid gt 234 id gt streetType gt syear gt 2011 lt year gt lt igcPollectScheduleltemList gt gcCollectScheduleltemList comment C P TOPLAMA comment gt scompanyld 63000 lt companyld sday gt 1 lt day gt districtTypes sid gt 1 lt id gt sidistrictType gt finishTime svalue gt 201 1 10 03 12 00 00 0 lt value gt ifinishTime period 3 period startTime lt value 2011 10 03 08 00 00 0 valuez istartTime lt streetType gt sid 728 lt id gt streetType gt syear 2011 lt year gt gcCollectScheduleltemList gt gcCollectSchedulettemList lt comment gt GOP TOPLAMA comment lt companyld gt 63000 companyld gt day gt 2 day gt lt districtType gt sid 1 lt id gt lt idistrictType lt finishTime gt ns2 getGCHoursForCanResponse xmins ns2 http servis esb opendai socbs sa
17. Ad istreetInfo laddressStreetitemList xaddressStreetltemList sid 682 lt id gt districtinto sid 1 lt id gt idistrictInfo streetlnfo sid gt 682 d gt xistreetInfo s addressStreetitemList addressStreetltemList sid gt 722 lt id lt districtinfo sid gt 1 lt id gt lt districtinfo streetlnfo sid gt 722 d gt istreetInfo laddressStreetitemList addressStreetltemList sid gt 723 id gt sdistrictInfo gt sid 1 ils lt districtinfo streetlnfo sid gt 723 d gt sistreetinfo gt s addressStreetttemList saddressStreetitemList 1 kel D HU D I Figure 47 Screenshot request detailed information gt soap Envelope xmins soap http schemas xmlsoap org soap envelope gt soap Body gt Raw XML 2 4 2 1 1 Followed development plan M9 M10 M11 M12 M13 M14 M15 M16 M17 M18 Final data design Services development App Mobile development Services testing App testing Deploying and publishing PUBLIC CONFIDENTIAL 73 www opendai eu OPEN x i x DAI 220 amp Infrastructures pm Pilots development report 2 4 2 1 2 Development results OrduServices provide a set of information that is designed to simplify the life in Ordu and it enables citizens and 3rd party developers to access daily information easily Currently in Ordu this type of information content is only managed a
18. ECZANESI name gt lt poiType gt Eczane lt poilype gt x 37 90477042235702 x gt y gt 40 97734661294404 y gt poiList gt lt poiList gt description gt 272 description gt names AYDIN ECZANESI lt name gt lt poiType gt Eczane poiType gt x gt 37 8778090309766 x gt y gt 40 983363293056456 gt poiList gt poiList description 37 598 description name AYDOGAN ECZANESIsiname gt lt poiType gt Eczanes poiType gt x 37 91299541734154 x gt y gt 40 974790453601265 gt poiList gt lt poiList gt lt description gt 528 description gt sname AYHAN ECZANESIs name gt Figure 44 Screenshot request POIs soap Envelope xmlns soapz http schemas xmlsoap org soap envelope soap Body ns2 listPOISByTypeResponse xmlns ns2z http servis esb opendai soacbs sampas com sreturn lt poiType gt Eczane lt boiType 4 queryClosestPOI This operation finds and presents the closest POI for a given user coordinate and a POI type In the sample presented below we sent the coordinates and the POI type Eczane pharmacy we wish to find As a a result we got the closest pharmacy s coordinates and name PUBLIC CONFIDENTIAL 70 www opendai eu OPEN DA Opening Data Architectures amp Infrastructures Pilots development repo Request 1 KS RO a 8 http 212 175 88 99 2225 services OpenDaiServices X
19. and width Ee PUBLIC CONFIDENTIAL 55 www opendai eu OPEN DA Opening Data C Architectures amp Infrastructures Pilots development report oY cr HOD e e http 192 168 34 231 2112 services OpenDaiServices soapenv Envelope xmlns soapenve http schemas 4 is lt soapenv Header gt Request 1 soap Envelope xmins soap http schemas xmlsoap org soap envelope lt soap Body gt E lt soapenv Body gt ns2 listTheStreetsResponse xmlns ns2z http servis esb opendai socbs sampas com lt ser listTheStreets gt return zxt Optionar streetTypelist slistTheStreetsRequest gt sid 234 lt id gt ser listTheStreets gt length gt 0 A ength gt soapenv Body gt streetlnfo isoapenv Envelopes description OSMANGA Zi CAD description gt sid 234 lt id gt xistreetinfo width Os vvidth lt istreetTypeList streetTypeList gt id gt 287 d gt length gt 0 flength gt streetinfo description N FAZIL KISAK REK CD description gt lt id 287 lt id lt streetinto lt width O0 lt width istreetTypeList streetTypeList gt id gt 682 d gt slength O lt Jength lt streetinfo gt lt description gt NECMETTIN CEVHER CADDESI description gt id gt 682 id gt lt streetinfo swidth gt 0 width gt streetTypeList gt lt streetTypeList gt sid 722 lt id gt elength 0 lt Jength gt lt streetinfo gt description MILLET CAD
20. businesses Educational centres e Python Bars and restaurants Sport Django framework facilities Local markets and e Javascript services related Tourism offices Leaflet Health care services Municipal services Non municipal services Mobility services information Municipal bus stops This pilot aims to publish the data silos detailed on the document D5 1 using the Open DAI infrastructure and technologies Once APIs are available the pilot aims to develop a specific utility to use this data and prove the use case detailed also on D5 1 The Pilot development consists on add APIs on Open DAI platform from silos detailed and a mobile application development addressed to the Barcelona citizens The main goal is to achieve a useful service using the APIs opened with Open DAI project The service developed to prove the data utility is a Web application for the Lleida citizens to consume city data on real time 2 3 2 1 Pilot development In order to develop the application correlation between environment and mobility in a service we define a solution composed by a Web Application as a user interface and a service back end to attend the petitions from the mobile phone The Web application interacts with the server application described previously and offers a graphical user interface for the consumers 2 PUBLIC CONFIDENTIAL 44 www opendai eu OPEN DAI Opening Data Architectures amp Infrastructures Le ci
21. description gt id gt 722 id gt xistreetinfo lt width gt 0 Awidth gt lt istreetTypeList lt streetTypeList gt sid 723 lt id slength O0 lt ength gt streetlnfo description 308 SOKAK description gt sid 723 lt id lt streetinto wicth gt 0 Awidth streetTypeList gt vi lt streetTypeList gt zal DE Pial Figure 30 Screenshot list Raw XML Raw XML getGCListByType This operation sends a garbage can type as a parameter and gets the information about the cans which fit the given type This return information has the coordinates start and finish hours for each of these cans In the sample request below we requested the cans in type of Hastane hospital PUBLIC CONFIDENTIAL 56 www opendai eu OPEN Opening Data DA Architectures amp Infrastructures Pilots development report Request 1 KS EIL a http 212 175 88 99 2225 services OpenDaiServices gt w e soapenv Envelope xmins soapenv http schemas xmlsoap org soap enveld a N soapenv Header soapenv Bodys ycCollectSchedulettem gt ser getGCLIstByType gt lt gcCollectScheduletem gt C Optional lt finishTime gt lt gcType gt Hastane lt gcType gt lt value 16 30 00 value gt ser getGCLIstByType gt ftinishTime gt lt soapenv Body gt lt startTime gt soapenv Envelope gt lt value gt 16 00 00 value gt lt startTime gt sigcC
22. e Java SDK Android SDK 2 4 1 1 Pilot development The following diagram shows the deployment of the artefacts ES PUBLIC CONFIDENTIAL 50 www opendai eu OPEN DAI Opening Data Architectures amp Infrastructures p cip Pilots development report pkg rdu Applications Figure 25 Block diagram City Dynamics The smartphone takes the user input and choices Then the data takes a way to legacy DB and Geoserver as stated above Ordu Applications artefact consists of SOAP webservices and logic of the application Based on the use cases defined in the technical description citizens are able to start two different workflows Call Center workflow and Citizen self service workflow is given in Figure below According to the Call Center workflow the citizen calls Ordu Call Center and asks for the closest garbage collection hours by location and by time The Call Center Agent opens the map searches the address of the citizen according to the given information The Agent then finds the closest can to the citizen and shares the garbage collection hours information with the citizen In the second workflow the citizen opens his or her map on the device finds the closest can and get garbage collection hours information without the need of an agent Ee PUBLIC CONFIDENTIAL 51 www opendai eu OPEN x i c DAI 202222 amp Infrastructures GH Pilots development report By Call Center By Citizen
23. e On Public administration host are localized the legacy data sources connected to the Open DAI Platform The first artefact as part of Open DAI platform is the TEIID data virtualization system adapted to Barcelona city silos e Over the data virtualization the API manager provided by WSO2 framework offers access and control to the REST APIs publishing publicly a API store e Also part of Open DAI platform is designed and developed using Django framework the back end required by the mobile application This back end is composed by 2 artefacts o A Geo server artefact developed using geodjango required by the web application for the geospatial services such as geonaming reverse resolution and some different trigonometric functions o An application server developed using django with services and logic functions are required by the web application on purpose to light the computation on the web browser The web resources and the access on the back end services are provided and controlled by a proxy implemented with NGinx ES PUBLIC CONFIDENTIAL 33 www opendai eu OPEN DAI 20 E amp Infrastructures p Cipz Pilots development report At the end the web application runs on a Web browser providing a user interface for the user 2 2 2 1 1 Followed development plan M9 M10 M11 M12 M13 M14 M15 M16 M18 Streets dataset connection procedure Pollution dataset connection procedure Traffic dataset connection procedure Devel
24. orange nodes are the Open DAI platform nodes while the green ones are the external nodes Describing the artefacts on detail e On Public administration host are localized the legacy data sources connected to the Open DAI Platform The first artefact as part of Open DAI platform is the TEIID data virtualization system adapted to Barcelona city silos e Over the data virtualization the API manager provided by WSO2 framework offers access and control to the REST APIs publishing publicly a API store e Also part of Open DAI platform is designed and developed using Django framework the back end required by the mobile application This back end is composed by 2 artefacts 23 PUBLIC CONFIDENTIAL 39 www opendai eu OPEN x i DAI 27 25 P amp Infrastructures H Cip Pilots development report o A Geo server artefact developed using geodjango required by mobile app for the geospatial services such as geonaming reverse resolution and some different trigonometric functions o An application server developed using django with services and logic functions required by mobile application on purpose to light the computation on the mobile device The access on the back end services are provided and controlled by a proxy implemented with NGinx At the end a cross platform mobile application is developed using Titanium framework as a client of the services and as an user interface application 2 3 1 1 1 Followed development plan
25. our sample we questioned the POI s in the type of Eczane pharmacy and the response gives information about the pharmacies with their coordinates PUBLIC CONFIDENTIAL 69 www opendai eu OPEN Opening Data DA Architectures amp Infrastructures Request 1 DA o Pilots development repo ZS ie Ki D 3 http 212 175 88 99 2225 services OpenDaiServices gt lt soapenv Header gt lt soapeny Body gt lt serlistPOlsByType gt LOptional listPOlsByTypeRequest gt Raw XML lt poiType gt Eczane lt boiType gt sfistPOlsByTypeRequest ser listPOlsByType gt soapenv Body gt soapenv Envelope gt soapenv Envelope xmins soapeny http schemas 3 4 t gt i ES bd c poiList gt lt description gt 31 3 description gt lt name gt ACAR ECZANESIs name gt lt poiType gt Eczanes boiType gt x 37 878337665220414 x gt lt y 40 98389074431245 y gt poiList gt poiList lt description 659 lt description sname AKYAZI ECZANESIs name gt spoiType Eczane lt poiType gt x gt 37 91176993700408 x gt y gt 40 974717444505636 gt poiList gt poiList gt lt description gt 1052 description gt zname ALTA ECZANESi iname lt poiType gt Eczanes poiType gt zx 37 89318913442435 x zy740 97099656304815 y7 poiList gt poiList gt lt description 603 lt description gt names ARDA
26. problem that consumed part of the initial activity without diverging from the project specifics The development has been done in synch with the meetings with the European Environment Agency where CSI and Piedmont Region participate to meetings for the standard definition The creation of the mapping of the data and API took longer than planned due to the complexity of the XML document to be produced 2 1 3 1 1 Followed development plan M9 M10 M11 M12 M13 M14 M15 M16 M18 Mapping of data set to XML API creation API testing 2 1 3 1 2 Development results The API can be found at https api opendai eu store apis info name AirQuality amp version 1 0 0 amp provider ItalyAd min 2 1 3 2 Pilot documentation 2 1 3 2 1 Pilot code repository Github repository https github com open dai piedmont pilot air In the source repository there is the eclipse project to create the java servlet that transforms the original data into the EU standard data format since the required XML was too complex to be managed by the TEIID translator 2 1 3 2 2 Pilot code guide The request is done by the API consumer to the API manager that turns the requests to the JAVA servlet that invoke the DB to get the information than thanks to the XML mappings creates the correct XML response from relational data The mapping from the relational and the XML schema is done using XMLBeans that is a tool that generates JAVA beans compliant to an XML schema so i
27. published by the API Manager 2 1 4 2 2 How to install and deploy There are two artefacts for this project e The VDB The PHP rest service The VDB has to be deployed in TEIID accordingly to the Open DAI platform The PHP rest service has to be published in the internal Apache server The API is than published by the API manager 2 1 4 2 3 User Manual The API is divided into two main API one dedicated to the aziende entity This entity represents the transport companies that operate in the Piedmont region The second API is dedicated to the Movicentri entity that represents the nodal point of stop and departure of different transportation systems Tpl aziende API result parameter parameter meaning List of aziende NA No parameter required Tpl movicentri API result parameter parameter meaning Information on callName Type of call required transport event in getSegnalazioni the movicentro movicentro The ID of the movicentro 25 PUBLIC CONFIDENTIAL 24 www opendai eu OPEN DAI Opening Data po Architectures amp Infrastructures Le cip Pilots development report Get the list of the callName Type of call required movicentri around getMovicentri a point longitude The point from where you make the search latitude The point from where you make the search Get the Arrivals callName Type of call required time i
28. the use case detailed also on D5 1 The Pilot development consists in adding APIs on Open DAI platform from silos detailed and a mobile application development addressed to the Barcelona citizens One of the goals is to achieve a useful service using the APIs opened with Open DAI project The service developed in order to validate the data utility is a Web application for the public authorities to see the correlation between the air pollution and the traffic status 2 2 2 1 Pilot development In order to develop the application Correlation between environment and mobility in a service we define a solution composed by a Web Application as a user interface and a service back end that attends to the petitions from the mobile phone The Web application interacts with the server application described before and offers a graphical user interface for the consumers The following diagram shows the deployment of the artefacts of the pilot Ee PUBLIC CONFIDENTIAL 32 www opendai eu OPEN x c DAI 22322022 Ka amp Infrastructures CH Pilots development report Web Application HTM JS JBoss Cluster API Manager D oo l Host Figure 16 Block diagram Correlation between environment and mobility On diagram there are two types of artefacts The orange nodes are the Open DAl platform nodes while the green ones are the external nodes Describing the artefacts on detail
29. their related webservice operations are available there 2 4 2 2 2 How to install and deploy The Deployment Diagram for POI services in Open Data Platform is given as follows Ee PUBLIC CONFIDENTIAL 75 www opendai eu OPEN x i y DAI 20 amp Infrastructures p gt Pilots development report Legacy DB Figure 50 POI Deployment Diagram 2 4 2 2 3 User Manual POls will be a mobile application that citizens can use to search for point of interests and also there will be a capability to find closest poi to user Use Case 1 Citizen Tourist POI Information This use case identified the actions that a citizen or a tourist can take during POI information retrieval Use Case 2 3 Party Development This use case identifies potential areas of 3rd party development for POI services This provides actions that 3rd party developers are able to do using the opened data from the platform Use Case 3 System Administration System is controlled and managed by the system administrators in the PA This use case provides actions that a system admin can take during the system runtime Ee PUBLIC CONFIDENTIAL 76 www opendai eu OPEN DAI Opening Data y Architectures amp Infrastructures E cip Pilots development report Use Case 1 Citizen Tourist POI Information
30. 1 1 3 1 2 2 How to install and deploy esses 41 PE OR Er p Ere EREE E 42 1 3 2 Data publication Web App 44 1 3 2 1 Pilot Een 44 1 3 2 1 1 Followed development 46 13212 Development resulle iciasoca otiam ep DR p Bal AN a pa RV HE REY 46 1 3 2 2 PlMobUOCUITiBrIEA KE 47 1 3 2 2 1 Pilot code repository eror reuera nca econtra nnam neni 47 1 3 2 2 2 How to install and deploy 47 13220 User Mill E 48 14 Ordu municipality MONS eot Stet ege ege 50 1 4 4 City Dynamics Mobile App 50 1 4 1 1 Pilot development T 50 1 4 1 1 1 Followed development 0 59 1 4 1 1 2 Development results EE 60 1 4 1 2 Pilot documentation oegeseucb ergee EENEG 61 1 4 1 2 1 Pilot code repository E 61 1 4 1 2 2 How to install and deploy 61 121285 User E TEE 62 142 Pors Mobile e E 66 1421 Pilotdevebpmen Laursuvasorasmmsunken must 66 1 4 2 1 1 Followed development plan 73 1 4 2 1 2 Development results EE 74 1 4 2 2 Pilot documentation ms eesmeimessmsseentensevennsssssassneddsadea es eenetek 19 14221 Pilot code repository EE 75 1 4 2 2 2 How to install and deploy
31. 2 How to install and deploy The process to install this pilot is the same as to deploy the Open DAI platform it is detailed on the WP4 deliverables Inside this platform this Pilot uses JBoss server and TEIID tool for the data virtualization e Virtual machines for the application servers s API Manager for Api publication As it has been previously explained this pilot is composed of a mobile App and a backend service over the Open DAI infrastructure To deploy these artefacts step by step we need to follow Data virtualization artefact The pilot calls to REST API from Open DAI WSO2 infrastructure This API is composed by a WAR apibarcelona war for JBOSS and custom Translators for TEIID To deploy this API the source code and the JBOSS TEIID environment are required The data used by the pilot is virtualized on a virtual DB barcelona_base_vdb vdb deployed also in TEIID All configuration required is included on the war file and this should be deployed as a web application on JBOSS server included in this case on Open DAI platform Application Back end The Backend service is developed using Python django framework To deploy these services it requires the source code and a server with Python 2 7 and Django 1 6 x The django applications run using WSGI technology behind a proxy web server In our case we used Gunicorn as WSGI provider and NGINX server as a proxy This application has to run on the same network where the TE
32. 3 User Manual With the web application the user is able to search different kind of city data for instance bus routes and stops nearby his location or nearby a manually provided address The bus routes and stops are displayed on a map of the city Ee PUBLIC CONFIDENTIAL 48 www opendai eu OPEN x i c DAI amp Infrastructures GH Pilots development report API consumer m Incidents API Current incidents viewer N N V N Application user N System Accessible services finder Accessibility API Figure 24 Use case Data publication Using the City Bus Routes REST API the application fetches the coordinates of the bus routes and stops nearby the ones ES PUBLIC CONFIDENTIAL 49 www opendai eu OPEN i y PAI amp Infrastructures p gt Pilots development report 2 4 Ordu municipality Pilots 2 4 1 City Dynamics Mobile App Abstract City Dynamics provides a set of information that is designed to simplify the life in Ordu and it enables citizens and 3rd party developers to access daily information easily Currently in Ordu this type of information content is only managed and generated by the Public Authority and citizens are only able to get information using the Call Center Technologies used on pilot Data sources silos e Open DAI platform e City facilities e WSO2 ESB Server e Street directory e Geoserver e Points of interest e TEIID data repositories Reports
33. EU standard Technologies used on pilot Data sources silos e Open DAI platform Air quality dataset Java 2 1 3 1 Pilot development JBoss cluster API manager Transformation application API manager AP publication CI Ld Legacy Host TEIID ly Y LegacyHost LegacyDB TEIID VDB Figure 12 Block diagram Air Quality The diagram above shows the deployment diagram of the artefacts the TEIID VDB accesses the legacy DB the java application connects to the VDB and the API thus generated is published through the API manager The project made a first attempt in using just TEIID to expose the API by transforming the relational view into the XML output needed The complexity of the EU adopted schema and the fact that many xschema referenced URI not valid made impossible to use the wizards in the TEIID designer and the process over complicated The development thus decided to create a set of java classes to marshal and unmarshal the content and from these to build the objects needed to execute the mapping for the correct output Ee PUBLIC CONFIDENTIAL 19 www opendai eu OPEN DAI opening Data Architectures amp Infrastructures Leg cip Pilots development report Since the Open DAI architecture provisioned a JBoss cluster it was possible to solve the initial
34. IID artefacts publish the APIs Then what it is need is to configure the IP address of this APIS on the django application settings Application Front end The Mobile App is developed using Titanium framework This is a cross platform technology allowing the deployment on different App markets iOS and Android Items required in order to deploy the apps are the source code the Titanium Studio Environment 3 1 x and the Apple and Android market environments 23 PUBLIC CONFIDENTIAL 30 www opendai eu OPEN DAI opening Data Architectures amp Infrastructures Leg cip Pilots development report Once the Android and iOS apps are built with the titanium studio is necessary to follow the official methodology to deploy Apps on the Google and Apple markets 2 2 1 2 3 User Manual Register and Loging API consumer System Running or Cicling Route Planner Application User Polltion Map Environmental API Figure 15 Use Case Monitoring real time pollution in spaces for outdoor activities This App service has the functionality to show the state of pollution and meteorological factors on different running routes used by citizens The aim is to provide advice on using the outdoor spaces depending on the levels of pollution or weather conditions The polluting elements to be taken into account are The air pollution the pollen level and the meteorological parameters that can affect the pollution s
35. KS 13 1 1 2 2 1 Pilot code repository EE 13 11222 Pilot code Uu 13 1 1 2 2 3 How to install and deploy 14 VL222 MI dat ETT 15 lt Ar SUNY m Y 19 1 1 3 1 Pilot development 19 1 1 3 1 1 Followed development plan 20 1 1 3 1 2 Development FeSUltS 10icisssneciseniennsocancebnenesaternwandannnantanene 20 11 32 lege Tu En RE 20 1 1 3 2 1 Pilot code repository uuumimnsnansnmeiienueeiuntv ej 20 1 1 3 2 2 Pilot code ET 20 1 1 3 2 3 How to install and deploy 2 gt 21 1 1 3 2 4 User MAAL e geseet 21 1144 Tes AP EE 23 THAT NN Gegen EE 23 1 1 4 1 1 Followed development 0 23 1 1 4 1 2 Development results EE 23 1 1 4 2 Pilot documentation 24 1 1 4 2 1 Pilot code repository 24 1 1 4 2 2 How to install and deploy 24 1 14 23 User Man al degen ergeet 24 1 2 Barcelona municipality EE rore ertt t dead 26 1 2 1 Pollution monitor for outdoor activities Pilot Mobile App 26 1 2 1 1 Pilot GEVElO DMC LE 26 1 2 1 1 1 Followed development olan sess 28 1 2 1 1 2 Development 88 8
36. M9 M10 M11 M12 M13 M14 M15 M16 M18 Facilities dataset connection procedure Public transport dataset connection procedure Road Incidence dataset connection procedure Development TEIID data virtualization App Backend development App Mobile development App testing Deploying and publishing 2 3 1 1 2 Development results The pilot results are mainly 2 different services The APIs with public data available for citizens and 3 party developers and a mobile application focused on adding a service on Barcelona city council public catalogue of services for the citizens APIS The APIs developed and published on this pilot is Public Data Publication API https api opendai eu store apis info name Data Publication amp version 1 0 amp provi der SpainAdmin This APIs is explained and documented on the deliverable D6 1 as part of WP6 App 23 PUBLIC CONFIDENTIAL 40 www opendai eu OPEN DA Opening Data x Architectures amp Infrastructures p Pilots development report The result is an operational app application on iOS and Android platforms released on Lleida city council Lleida App Atras Lleida App Salir Lleida App Atr s Puntos accesibles Buscar los Ultimos Incidencias p blicas Info sobre bus A DAS Come Z SE N d 8 ee Comarcal d 2 del Segri Figure 20 Screenshot Mobile App Road incidents and accessibility 2 3 1 2 Pilot documentation 2 3 1 2 1 Pilot code r
37. OPEN i i DAI 2 25 gt amp Infrastructures WS Pilots development report Project Acronym Open DAl Grant Agreement number 297362 Project Title Opening Data Architectures and Infrastructures of European Public Administrations Work Package Pilot development Deliverable Number D5 2 Revision History Revision Date Author Organisation Description 1 Jul 2013 Marc Planaguma BDigital Draft ver 0 1 9 Oct 2013 Marc Planaguma BDigital Final ver 1 0 17 Mar 2014 Marc Planaguma BDigital Revision ver 2 0 6 Jun 2014 Marc Planaguma BDigital Revision ver 2 1 29 Jun 2014 Marc Planaguma BDigital Revision ver 2 2 11 Jul 2014 Marc Planaguma BDigital Final Reviewed ver 2 3 Legal Disclaimer Copyright 2013 by CSI Piemonte BDIGITAL SAMPAS NetPort Regione Piemonte Karlshamn Municipality Ordu Municipality Barcelona Municipality Lleida Municipality Politecnico di Torino DIGITPA The information in this document is proprietary to the following Open DAI Consortium members CSI Piemonte BDIGITAL SAMPAS NetPort Regione Piemonte Karlshamn Kommun Ordu Municipality Barcelona Municipality Lleida Municipality Politecnico di Torino DIGITPA This document contains preliminary information and it is available under the term of the following license The Open DAI Data Assessment and Specification Report by Open DAI Project is licensed under a Creative Commons Attribution 3 0 Unpo
38. OPEN x DAI Opening Data Architectures amp Infrastructures Leg Cip Pilots development report The project thus opted for implementing a simple demonstrator of how these API could be used to give more insight to PA managers with the correlated data 2 1 1 1 Pilot development The following diagram shows the deployment of the artefacts of the pilot The orange nodes are the Open DAl platform nodes while the green ones are the external nodes The legacy DB is accessed by geoserver that generate the needed layers The access to geoserver is mediated by the API Manager that protects the API through ACL allowing only defined users to access the geoserver service The Web application is published through an Apache that is exposed only to the internal network of Piedmont Region The when application uses OpenLayer to query the geoserver data Browser a Web Application Apache D L_ Legacy Host Legacy DB EG geoserver API store Ei mn C TEIID Se Figure 1 Block diagram TWIST accident publishing 2 1 1 1 1 Followed development plan M9 M10 M11 M12 M13 M14 M15 M16 M18 Definition of the traffic data collection procedure Definition of the new set of 23 PUBLIC CONFIDENTIAL 8 www opendai eu OPEN i DAI 20 amp Infrastructures 2 Pilots development report accident data Definition of the correct association between traffic and accident Implementation o
39. SOAP webservices and logic of the application The figure below shows the process flows according to the defined use cases Citizen or a Tourist is able to list POI types show the POls on the map get POI list based on their types list POls according the their locations and given area and also get closest POI information based on their location They will also be able to get routing information to the selected POIs 3 Party developers are able to develop POI based applications by the features provided from the Open Dai platform The business process flow also shows the operations that a system admin can take during the management of the POI services Ee PUBLIC CONFIDENTIAL 67 www opendai eu OPEN DA Opening Data Architectures amp Infrastructures Cip Pilots development report Citizen or Tourist Process 1 3rd Party Developer Get WMS System Admin Publishes WMS Update POI Se bizaal Figure 42 POI Workflow Here we present the screenshots of sample SOAP UI requests and their expected results for our basic webservice operations which are presented in the workflow diagram above listPOITypes This operation returns the available POI types As can be seen from the sample request presented below POI types such as hastane hospital eczane pharmacy are listed Ee PUBLIC CONFIDENTIAL 68 www opendai eu OPEN Opening Data DA Architecture
40. ST real time collection 2 1 2 1 1 Followed development plan The planning of the pilot proceeded accordingly to the initial plan M9 M10 M11 M12 M13 M14 M15 M16 M18 Final data design User Interface mockup Data services mockup Smart phone implementation Data service implementation Business process implementation Smart phone app testing Smart phone app market publishing 2 1 2 1 2 Development results The web site is published at the address http saveus opendai eu The API is published by the API manager but is reserved to the smart phone application and visible just to the appropriate user PUBLIC CONFIDENTIAL 12 www opendai eu OPEN DAI opening Data Architectures amp Infrastructures cip Pilots development report The smart phone application is published in the Apple Store and Google Market LG phemeier cl How to Cen htm Cent SaveMe gt Module i 7 Wiki ViPH 5 Manage ra Download lt Tunes Link Batch conv History for Nuova sche Ses eak EE EE GE PA B gt Lal mae B Q 3 Bookmark ST Highlight E Capture D Send 3 Read Later Unread 3 Recent 34 Add afilter T Options aft Go premium SaveMe Figure 5 Image TWIST real time collection 2 1 2 2 Pilot documentation 2 1 2 2 1 Pilot code repository Github repository https github com open dai pie
41. Use Case 2 Get Garbage Collection Hours Users are able learn garbage collections hours for the closest cans using their application This use case defined the actions that can be taken by the citizen or the call center agent without using location information Use Case 3 3 Party Development This use case identifies potential areas of 3rd party development for optimizing the garbage collection issues in the municipality This provides actions that 3rd party developers are able to do using the opened data from the platform Use Case 4 System Administration System is controlled and managed by the system administrators in the PA This use case provides actions that a system admin can take during the system runtime Ee PUBLIC CONFIDENTIAL 62 www opendai eu OPEN DAI Opening Data Architectures amp Infrastructures Cip Pilots development report Use Case 1 Get Garbage Collection Hours By Location Citizen Call Center Agent 4 Get GC Hours forY X can Get informationN gt for can Figure 37 City Dynamics Use Case1 Get Garbage Collection Hours By Location lt Actions Description Open Map User is able to open the map and navigate the map Find Closest GC User can find the closest can for gps position Get GC Hours for can User can find the schedule for the GC Get information for can User can find information for GC Use Case 2 Get Garbage Collectio
42. WMS and WFS Admin can publish the WMS and WFS services 23 PUBLIC CONFIDENTIAL 78 www opendai eu OPEN i yox PAI amp Infrastructures p gt Pilots development report 2 5 Karlshamn municipality pilot 2 5 1 Reports Abstract The pilot from NetPort Science Park and Karlshamn municipality provides a mobile reporting service that allows citizens and staff to place reports and suggestions on a map To achieve this we used Open DAI to virtualize a reports database into a RESTful API and publish municipality provided map points as GeoJSON Technologies used on pilot Data sources silos Node js Reports e MySQL e Points of interest e JSON e Backbone js e Handlebars js ES PUBLIC CONFIDENTIAL 79 www opendai eu OPEN DAI opening Data Architectures amp Infrastructures Leg cip Pilots development report 2 5 1 1 Pilot development Application start App Check User Geolocation Check user login User Load Reports 50 closest to user Reports Load Map Load List List Show user on map Show reports on Show List reports in list map Figure 54 Block Diagram Reports When the application starts the user is asked to log in using facebook By using this login method the user doesn t have to register another account just to use our app After the login process the application will try to find the user position with the geol
43. application makes use of Open DAI TEIID installation for connecting to the MySQL database within Karlshamn municipality It also makes use of the geoserver for loading static objects like light poles from Karlshamn municipality 2 5 1 2 3 User Manual First you have to login with facebook If the login is successful you will be redirected to the list of reports already created by other users You will only have a few navigation items in the menu The one to the left is the list of reports which you are currently watching Second is all the reports displayed on a map The third and most important item is the create report which allows you to create a new report The last ones are settings and user profile ES PUBLIC CONFIDENTIAL 83 www opendai eu
44. ble to cross this information with other datasets like mobility reports These data relationship will allow to public authorities to formulate and modify e g in a daily basis a mobility plan for the city that takes into account also the pollution factor i e car generated pollution such as quality of air and noise when setting up routes and speed limits ES PUBLIC CONFIDENTIAL 37 www opendai eu OPEN x i y DAI 20 amp Infrastructures p gt Pilots development report 2 3 Lleida municipality Pilots 2 3 1 Road Incidents and Accessibility Mobile App Abstract The Road Incidents and Accessibility pilot consists of a mobile application with two main functionalities The first one is checking in real time information about incidents in the city like traffic accidents or closed streets because of public works The second one is finding accessible services for people with mobility issues Places are classified according to their category and to features making easier for the user the search for a convenient place Technologies used on pilot Data sources silos e Open DAI platform e Road incidents REST JSON City Facilities Python Public transport Django framework e Javascript e Titanium framework Accessibility This pilot aims to publish the data silos detailed on the document D5 1 using the Open DAI infrastructure and technologies Once APIs are available the pilot aims to develop a
45. composed by a WAR apilleida war for JBOSS and custom Translators for TEIID In order to deploy this API the source code and the JBOSS TEIID environment are required The data used by the pilot is virtualized on a virtual DB lleida base vdb vdb deployed also in TEIID All configuration required is included on the war file and this should be deployed as a web application on JBOSS server included in this case on Open DAI platform Application Back end The Backend service is developed using Python django framework To deploy these services the source code and a server with Python 2 7 and Django 1 6 x are required The django applications run using WSGI technology behind a proxy web server In our case we used Gunicorn as WSGI provider and NGINX server as a proxy This application has to run on the same network where the TEIID artefact publishes the APIs Then it is needed to configure the IP address of this APIS on the django application settings Application Front end The Mobile App is developed using Titanium framework This is a cross platform technology allowing the deployment on different App markets iOS and Android Required items to deploy the apps are the source code the Titanium Studio Environment 3 1 x and the Apple and Android market environments Once the Android and iOS apps are built with the titanium studio is necessary to follow the official methodology to deploy Apps on the Google and Apple markets 2 3 2 2
46. computation on the web browser The web resources and the access on the back end services are provided and controlled by a proxy implemented with NGinx e At the end the web application runs on a Web browser providing a user interface for the user 2 3 2 1 1 Followed development plan M9 M10 M11 M12 M13 M14 M15 M16 M18 Facilities dataset connection procedure Public transport dataset connection procedure Road Incidence dataset connection procedure Development TEIID data virtualization App Backend development Web development App testing Deploying and publishing 2 3 2 1 2 Development results The pilot results are mainly 2 different services The APIs with public data available for citizens and 3 party developers and a web application focused on adding a service on Lleida city council catalogue of services for internal public authorities APIS The APIs developed and published on this pilot is Public Data Publication API https api opendai eu store apis info name Data_Publication amp version 1 0 amp provi der SpainAdmin This APIs is explained and documented on the deliverable D6 1 as part of WP6 App The result is an operational web app application published on this side http lleida opendai eu 23 PUBLIC CONFIDENTIAL 46 www opendai eu OPEN DAI Opening Data po Architectures amp Infrastructures Le Pilots development report Normal Minimal Night View POIs Pois
47. d denn 72 Figure 47 Screenshot request detailed information 73 Figure 48 Screenshot Mobile App POls EEN 74 Figure 49 Screenshot Mobile App POIs 2 75 Figure 50 POI Deployment BIgODSITL erlebt nes 76 Figure 51 POI Use Case1 Citizen Tourist POI Intormaton 77 Figure 52 POI Use Case2 3rd Party Development 78 Figure 53 POI Use Case3 System Administration 78 Figure 54 Block Diagram RT 80 Figure 55 Example App 1 EE 81 Figure 56 Example APP 2 s ren Eege ku uU aa EE 82 6 www opendai eu ES PUBLIC CONFIDENTIAL OPEN DAI Opening Data y Architectures amp Infrastructures p Cip Pilots development report 1 Overview This document includes the development reports of the pilots showing the development results indicating the resources repositories and providing the way to deploy all pilot applications 2 Pilots implementation report All development reports are explained by pilot areas 2 1 Piedmont Region Pilots implementation 2 1 1 TWIST accident publishing Abstract This pilot planned to deliver API in geographic and tabular data to citizen on a merged data set of accident and traffic Since the change of access right on the API and in the effort to convince PA stakeholders on the utility of having the tw
48. d using the WSO2 deploy console into the BPS server Ee PUBLIC CONFIDENTIAL 14 www opendai eu OPEN x i y DAI 220 amp Infrastructures p gt Pilots development report The smart phone application have to be compiled and signed in order to be deployed in the Apple and Google marketplace The TEIID component virtualizes the new dataset and is used both by the YII web application and by the PHP services The web application manages the customization data while the PHP services offer API used by the BPS to get the information Just the API from the BPS is exposed through the API manager and is reserved to the smart phone application the API manager is enforcing protection on this API through ACL The PHP services are also used to send mails from the BPS process 2 1 2 2 4 User Manual There are just 2 element of the pilot that require a user manual since all the other components are just server side components Web Site The web site offers the following main features e Registration Login Process customization These use cases will be hereafter described Registration The user accesses the registration form of the web site and inserts the data As a consequence he will receive a confirmation eMail with an activation link and the code to insert in the smart phone application this code will be the only element that will be used to allow the BPS to get the process customization this way no user data transit in
49. dmont pilot savelives In the source repository can be found 4 different artefacts The save us website The smartphone apps divided in iOS and Android codebase The internal services The business process 2 1 2 2 2 Pilot code guide The following diagram summarize the principal use cases of the pilot Ee PUBLIC CONFIDENTIAL 13 www opendai eu OPEN DAI opening Data Architectures amp Infrastructures Leg cip Pilots development report Smart phone user NE setTestMode Application user d De Zi setlD sendalertt18 NON sendtlertincidente Customization user jt sendAlertMessadggio A es Cam Figure 6 Main use case TWIST real time collection sendAlertSegnale The user acts on the two different systems with different capabilities On the web component he can register and deregister and can customize the process workflow On the smart phone he can configure it and send alerts 2 1 2 2 3 How to install and deploy The web site has to be deployed into an Apache with PHP configured A virtual host for the web site has to be created The production parameters like production mail server and DB have to be set in the webapp protected config imain php file The internal services can be deployed on the same Apache but there is no need to expose the service to the public since it is used just by the BPS The WSO2 BPS archive has to be deploye
50. end of 2013 Since the emergency department is a public actor financed by Piedmont Region it has been decided to retire the Open DAI pilot in favour of this new release to make citizens converge on one single solution 2 1 2 1 Pilot development The following diagram shows the deployment of the artefacts and the usage of the Open DAI platform In orange the nodes of the Open DAI platform in green the external nodes The web site is the place where end users register to the service and configure the process The process is the artefact to be deployed in WSO2 BPS that executes the operations in consequence of the smart phone application usage The smart phone application is the end user application that allows to signal the accident The internal services are the ones that insert data into the DB and expose the process information to the BPS these are internal services and not produce any API This pilot makes an extensive usage of the Open DAI components since it involves the adoption of the Business Process Server tool to orchestrate different internal services and to offer to the pilot a single new API to manage the communication of the accident Ee PUBLIC CONFIDENTIAL 11 www opendai eu OPEN c DAI 22302202 p d amp Infrastructures H Pilots development report T Mail Hpst Legacy Host LegacyoB TI el n Figure 4 Block diagram TWI
51. epository Github repository https github com open dai bcn lleida opendai pilots On Github repository we can found all the code necessary for Pilot divided on _ e jboss teiid apis the code needed to implement the TEIID data virtualization to connect to original data sources Silos e mobile apps the mobile application code e web geo server the application back end including the Geo Server and the remote services needed by mobile app 2 3 1 2 2 How to install and deploy The process to install this pilot is the same than the needed to deploy the Open DAI platform it is detailed on the WP4 deliverables Inside this platform this Pilot uses JBoss server and TEIID tool for the data virtualization Virtual machines for the application servers e API Manager for API publication As it has been explained this pilot is composed of a mobile app a backend service over the Open DAI infrastructure To deploy these artefacts step by step we need to follow 23 PUBLIC CONFIDENTIAL 41 www opendai eu OPEN x i y DAI 20 amp Infrastructures GH Pilots development report Data virtualization artefact The pilot calls to REST API from Open DAI WSO2 infrastructure This API is composed by a WAR apilleida war for JBOSS and custom Translators for TEIID In order to deploy this API the source code and the JBOSS TEIID environment are required The data used by the pilot is virtualized on a virtual DB lleida base vdb vdb
52. f the raw data traffic collection Implementation of the merged dataset API publishing Implementation of web dashboard Functional and load testing 2 1 1 1 2 Development results The WEB dashboard is published in the internal intranet of Piedmont Region while the API is published in the Open DAI API manager but protected by ACL control and not visible or usable to generic public e Bl cooge Bl Pi visitati Hotmail gratuita rsonalizzazione coll Windows WindowsMedia li O oo B Q 4 Bookmark S Highlight El Capture GR Sende lt Read Later E Unread E Recent 3 Add afiter Options RoadAccidents Opendai Incidenti stradali e sensori di traffico selezionare un incidente rosso per verificare lo stato del traffico nei sensori corrispondenti Home Info o May 2014 o Su Mo Tu We Th Fr Sa A 2 3 A 444 nom oo 4 15 16 17 Figure 2 Image WEB dashboard 2 1 1 2 Pilot documentation 2 1 1 2 1 Pilot code repository 23 PUBLIC CONFIDENTIAL 9 www opendai eu OPEN DAI opening Data Architectures amp Infrastructures Leg CID Pilots development report Github repository https github com open dai piedmont pilot accident 2 1 1 2 2 How to install and deploy The web application has been deployed in an Apache with PHP and it is defined a virtual host dedicated to the web site The geoserver services are deployed by copying the workspace information in the cor
53. gt sidistirictType gt id gt 3 id gt xitemCount 6 ttemCount itemType gt S lt itemType gt lt streetType gt sid gt 1727 id gt streetType xicanPoiltemList canPoiltemList lt companyld gt 63000 companyld gt distirictType id gt 23 id gt kdistirictType id gt 4 id gt itemCount gt 3s temCount gt itemType gt 6 temType gt E lt streetType gt E z sid 2122 lt id gt Ia DS Ge rial Head Attachm Wa Headers 9 Attachments 0 response time 9 ims 2422 bytes 21237 Figure 27 Screenshot Sample request getGcHoursForCan In this operation we sent a mahalle id neighbourhood value again to get detailed day and hour values for the garbage cans in that area As it can be seen the result contains dates starting and finishing times and other useful information about these cans PUBLIC CONFIDENTIAL 53 www opendai eu OPEN DAI Opening Data Architectures amp Infrastructures Request 1 Pilots development report ci ERODE 192 168 34 231 2112 services OpenDaiServices ser getGCHoursForCan C Optionat getGCHoursForCanRequest en z gt lt soapeny Header gt lt soapenv Body gt bal a saddressStreetttem gt lt L Optional sLOptional gt C Optional mahalle jd gt SB lt mahalle jd gt addressStreettem get GCHoursForCanRequest gt ser getGCHoursForCan gt soapenv Body gt
54. ication is developed using Titanium framework as a client of the services and as a user interface application 2 2 1 1 1 Followed development plan Pollution dataset connection procedure Weather dataset connection procedure Noise dataset connection procedure Pollen dataset connection procedure Development TEIID data virtualization App Backend development App Mobile development App testing Deploying and publishing M9 M10 M11 M12 M13 M14 M15 M16 M18 2 2 1 1 2 Development results The pilot results are mainly 2 different services The APIs with public data available for citizens and 3 party developers and a mobile application focused on adding a service on Barcelona city council public catalogue of services for the citizens APIS The APIs developed and published on this pilot are Pollution API Ee PUBLIC CONFIDENTIAL 28 www opendai eu OPEN DAI Opening Data Architectures amp Infrastructures cipz Pilots development report https api opendai eu store apis info name Barcelona_Pollution amp version 1 0 amp p rovider SpainAdmin Pollen API https api opendai eu store apis info name Polen Barcelona amp version 1 0 amp prov ider SpainAdmin Noise API https api opendai eu store apis info name Barcelona Noise Levels amp version 1 O amp provider SpainAdmin These APIs are explained and documented on the deliverable D6 1 as part of WP6 App The result is an operationa
55. ices gt soapenv Envelope xmins soapenv http ischemas lt lt soapenv Body gt ser listTheAddressCityi gt soapenv Body gt xisoapenv Envelope em E gt soapenv Header gt D E soap Envelope xmins soap http schemas xmlsoap org soap envelope gt lt soap Body gt ns2 listTheAddressCityResponse xmins ns2 http servis esh opendai sochs sampas com gt return lt addressCityltemList gt sid gt 63 id gt sinfo gt description ANLI URFAs description sid B3 lt id gt dinfo gt sfaddressCityltemList lt addressCityltemList gt id gt 38000 id gt info description KA YSERI description gt sid 38000 lt id gt infos lt addressCityltemList lt addressCityltemList gt sid 39000 lt id info description KIRKL ARELI description sid gt 39000 id gt infos addressCityltemList gt addressCityltemList sid gt 40000 lt id infos description KIRSEHIR description xid240000 d info addressCityltemList gt lt addressCityltemList gt sid gt 41000 id gt info description KOCAELI description xid 41000 id siinto gt lt addressCityltemList gt lt addressCityltemList gt sid 42000 lt id info description KONY A description gt id gt 42000 id gt lt info gt s addressCityltemList lt addressCityltemList gt sid gt 43000 lt id sinfo gt b lt description gt KUTAHY A lt description Ra
56. in Arn Figure 40 City Dynamics Use Case4 System Administration Actions Description Update GC data Admin is able to create update and delete GC data Update address data Admin can create update and delete address data ES PUBLIC CONFIDENTIAL 65 www opendai eu OPEN i yox PAI amp Infrastructures p gt Pilots development report 2 4 2 Poi s Mobile App Abstract POI Points of Interest provides location information about interesting points around the user location The citizen or the tourist after locating his position on a map may ask for a specific location such as the nearest taxi pharmacies mosques museums cultural places the nearest train station or the user can also ask for the nearest hospital Technologies used on pilot Data sources silos e Open DAI platform e City facilities e WSO2 ESB Server Street directory e Geoserver Points of interest e TEIID data repositories Reports e Java SDK Android SDK 2 4 2 1 Pilot development The following diagram shows the deployment of the artefacts 23 PUBLIC CONFIDENTIAL 66 www opendai eu OPEN DAI opening Data Architectures amp Infrastructures Leg cip Pilots development report pkg rdu Apphcations SI Figure 41 Block Diagram POIs The smartphone takes the user input and choices Then the data takes a way to legacy DB and Geoserver as stated above Ordu Applications artefact consists of
57. l app application deployed on iOS and Android markets by the Barcelona city council in order to grow the on line services to the citizens http apps4bcn cat app barcelona corre 1 354 i Ms movistar T 8 31 4 eeeee movistar F 8 32 ve S Fitxa T cnica Fitxa T cnica Ajuntament de q7 Barcelona ER 3 Pol len r BAI ICE LONA 2 p Temperature 16 688 9 Urticaceae Sy X X XX CORRE R Gramineae ex Temp min 16 88 E Olea CE E XXOXX X0 e ib j zwei t Temp max 16 88 Poaceae ontaminaci ug m Artemisia EK 00 TEMPORALMENT so2 HO DISPONIELE Castanea Chenopodiace ae Amaranth Plantago 80000000 Palmae Arecaceae TEMPORALMENT v NO DISPDHIELE Pinus se 000000 Figure 14 Image Mobile App Barcelona corre 2 2 1 2 Pilot documentation 2 2 1 2 1 Pilot code repository Github repository https github com open dai bcn lleida opendai pilots On Github repository we can found all the code necessary for Pilot divided on e jboss teiid apis the code to implement the TEIID data virtualization to connect to original data sources Silos e mobile apps the mobile application code e web geo server the application back end including the Geo Server and the Ee PUBLIC CONFIDENTIAL 29 www opendai eu OPEN x i y DAI 220 amp Infrastructures p gt Pilots development report remote services needed by mobile app 2 2 1 2
58. lhost index php user auth ge You are not logged in to your password database l Load my password database Launch KeePass Not Now x SaveMe TUN Perfavore inserisci le tue credenziali d accesso gioppo Name aioopoluca Password eesse Registrazione Password dimenticata Entra domnt csi it Accesso a Internet Rete non identificata Nessun accesso a Internet Figure 8 Image login process PUBLIC CONFIDENTIAL 16 www opendai eu OPEN x i y DAI amp Infrastructures GH Cip Pilots development report Process customization The process is saved and managed as an XML file to allow for extensibility in future evolution of the system The whole XML data is presented to the user as a sequence of tabs and accordion elements At the moment the only operation allowed is sending a mail but in the future it will be possible to implement new operations The user has now the option of entering a mail address and a message that will be sent by the BPS through the internal services AG seve m o emm Ah c gt mm zm mm ce ts J essfown 24 Q 4 amp 3 Bookmark S Highlight C Capture Hj Send lt 3 Read Later 3 Unread D Recent 27 Adda filter F Options A Go premium saveus localhost index Launch KeePass Logins vy logged in to your password database Load my password database Launch KeePass
59. ll the features registered He also is able to select the type or types of services he is looking for in this case a restaurant Once the desired features are selected and the service types a list of available services is presented to the user either in list form or displayed on a map 23 PUBLIC CONFIDENTIAL 42 www opendai eu OPEN x i c DAI amp Infrastructures GH Pilots development report API consumer Incidents API Current incidents viewer Pd N D Fd Application user fy System Accessible services finder Accessibility API Figure 21 Use case Road incidents and accessibility Using the Accessibility REST API the application fetches firstly the lists of all the available service features and types and secondly the services that match those desired features ES PUBLIC CONFIDENTIAL 43 www opendai eu OPEN x i y DAI 20 amp Infrastructures p gt Pilots development report 2 3 2 Data publication Web App Abstract The Data Publication pilot consists of a web application The main functionality of this application shows the different services municipal or not and points of interest of the city from public transports to tourism offices This information is useful not only to the city tourists but to the local population as well Technologies used on pilot Data sources silos e Open DAI platform Facilities by categories Hospitality e REST JSON
60. mpas com gt rfl 4 rfl Figure 28 Screenshot result The City Dynamics Open Data model also has two other different actors based on the goals defined previously The System Admin in the Ordu Municipality is the one who is managing the system and the data The System Admin is able to publish Web Map Service WMS and Web Feature Service WFS information using GeoServer in the Open Data Cloud platform The System Admin is also able to update address and can Information including garbage collection hours to the system Here update operation includes all types of creation modification and deletion operations Eed PUBLIC CONFIDENTIAL 54 www opendai eu OPEN x i DAI 2o p amp Infrastructures GH Pilots development report Start Get WMS Get WFS Search Address 3rd Party Developer z 5 T i 2 a H E gt 2 H M t 5 3 T o Publishes WMS Updates Can amp WFS Information System Admin bizaal Figure 29 City Dynamics Workflow ll Here we present the screenshots of sample SOAP UI requests and their expected results for our basic webservice operations which are presented in the workflow diagram above listTheStreets In this operation all the available streets in that area is listed in the response We can get name and id values Also it can hold the other useful information about that street such as length
61. n Hours USES USES X List the streets K List the cans by X street List GC Hours byY gt can lt Citizen Z Call Center Agent e Get Information gt for can Figure 38 City Dynamics Use Case2 Get Garbage Collection Hours Ee PUBLIC CONFIDENTIAL 63 www opendai eu OPEN DAI opening Data y Gy pim a Cip Pilots development report Actions Description Open Map User is able to open the map and navigate the map Search address User is able to search for an address List the streets User can see the list of streets List the cans by street User can see the GC list for a street List GC Hours by can User can see the collection hours for a GC Get information for can User can see the information for a GC Use Case 3 3 Party Development uses 3rd Party Figure 39 City Dynamics Use Case3 3rd Party Development Actions Description Get WMS User can reach the maps as images for an area Get WFS User can reach the vector spatial data for an area Search address User can search for an address List Streets User can see the list of streets List cans User can see the GB list for related street Ee PUBLIC CONFIDENTIAL 64 www opendai eu OPEN DAI Opening Data y Architectures amp Infrastructures Le cip Pilots development report Use Case 4 System Administration System Adm
62. n a getArrivi movicentro movicentro The ID of the movicentro Get the Departures callName Type of call required time in a getPartenze movicentro movicentro The ID of the movicentro ES PUBLIC CONFIDENTIAL 25 www opendai eu OPEN x i y DAI 20 amp Infrastructures p gt Pilots development report 2 2 Barcelona municipality Pilots 2 2 1 Pollution monitor for outdoor activities Pilot Mobile App Abstract The pollution monitor for outdoor activities pilot is a mobile application with relevant data about the environmental conditions on the Barcelona area in order to choose the best places or routes for outdoor activities or sports This pilot also represents opening the access to the environmental data for Barcelona Technologies used on pilot Data sources silos e Open DAI platform e REST JSON City facilities Street directory e Python Pollution levels Django framework Noise Levels Titanium framework Pollen levels Weather This pilot aims to publish the data silos detailed on the document D5 1 using the Open DAI infrastructure and technologies Once APIs are available the pilot aims to develop a specific utility to use this data and prove the use case detailed also on D5 1 The Pilot development consists on adding APIs on Open DAI platform from silos previously specified and development of a mobile application addressed to the Barcelona citize
63. n published Development had to delay until the first data set was migrated and was stable enough to implement API on it The adoption of a VDB helped the project to identify a small subset of information and defining a very simple view model for data so that it was possible to adapt the virtual view to the changing structure of the legacy DB The project team chose the JSONP format for opening to HTML and javascript consumption of the API solving the cross scripting problem This pilot suffered from a delay in the development due to the change of the data set stated above 2 1 4 1 1 Followed development plan M9 M10 M11 M12 M13 M14 M15 M16 M18 Data set mapping API creation API testing 2 1 4 1 2 Development results The API can be found at https api opendai eu store apis info name tpl_movicentri amp version 1 0 0 amp provider ltal yAdmin https api opendai eu store apis info name tpl_aziende amp version 1 0 0 amp provider ItalyA dmin 25 PUBLIC CONFIDENTIAL 23 www opendai eu OPEN x i y PAI amp Infrastructures p gt Pilots development report 2 1 4 2 Pilot documentation 2 1 4 2 1 Pilot code repository Github repository https github com open dai piedmont pilot tpl In the source repository there is the TEIID project to create the VDB and the PHP scripts that implement the API The PHP scripts connect to the VDB through the postgres protocol and the Slim framework implement the REST API that are
64. nd generated by the Public Authority and citizens are only able to get information using the Call Center Secondly these services provide location information about interesting points around the user location The citizen or the tourist after locating his position on a map may ask for a specific location such as the nearest taxi pharmacies mosques museums cultural places the nearest train station or the user can also ask for the nearest hospital APIs https api opendai eu store apis info name OrduServices amp version 1 0 0 amp provider Tur keyAdmin More information can be found on the deliverable D6 1 as part of WP6 and also on the documentations in the API Store documentation part App An Android application was prepared to distribute the data and make shown in the map So that user can locate different kinds of places on the map according to its POI type rw Figure 48 Screenshot Mobile App POIs E PUBLIC CONFIDENTIAL 74 www opendai eu OPEN x DAI 20 amp Infrastructures p Pilots development report Figure 49 Screenshot Mobile App POIs 2 2 4 2 2 Pilot documentation 2 4 2 2 1 Pilot code repository The source code of the POI project which was coded in Java is available in the repository The respective packages and class files can be seen there In the repository there is a simple document named README md which basically sums up the methods their aim and usage Also the main actions and
65. ns The main goal is to achieve a useful service using the APIs opened with Open DAI project The service developed to prove that the data is useful is a mobile app that provides environmental data on real time to the runners This App was not developed from scratch This pilot is an extension on existing mobile application from Barcelona city council that contains the running routes on the city This App had already a good acceptance on the city but with Open DAI project we have added dynamic and real time data improving significantly the app features and the rating among the users 2 2 1 1 Pilot development In order to develop the application Monitoring pollution in spaces for outdoor activities in a service we define a solution composed by a Mobile Application as a user interface and a service back end to attend the petitions from the mobile phone 23 PUBLIC CONFIDENTIAL 26 www opendai eu OPEN x i DAI 2 25 p amp Infrastructures GH Cipz Pilots development report The smart phone application interacts with the server application described and offers a graphical user interface for the consumers This mobile application is developed using a web based cross platform technology in order to facilitate the availability on the different mobile platforms The following diagram shows the deployment of the artefacts of the pilot Smartphone Mobile App D JBoss Cluster API Manager Django App Server
66. o data sets together the project limited the API generation and delivered a dashboard to the Piedmont Region users only that show the accident point and the traffic correlated information Technologies used on pilot Data sources silos e Open DAI platform e Accident data set Web application based on Traffic data set OpenLayer The pilot is reserved to the Piedmont Region users only The reason for this user restriction is that both data sets are not considered open by the owner therefore the application has been deployed as reserved to a limited number of users authorized to use the application The traffic data set has been obtained thanks to the Open DAI project for usage for the Public Administration since is managed and owned by a third party public owned company that did not opened it until the Open DAI project requested The traffic data has been given just for internal PA usage and not open to public The original plan to open that data as part of the project had to be changed and the usage of that information has been limited to this application for now but will be used also for other internal development In this approach we can consider this as a minor success since this data is now available as a new data set for other project and there is an API that exposes it This has limited the initial scope of the pilot that planned to open API to citizen and public usage 23 PUBLIC CONFIDENTIAL f www opendai eu
67. ocation API When this is done the map will be loaded and also the closest reports By loading the application views and data directly we save the user lots of loading time when navigating within the application Ee PUBLIC CONFIDENTIAL 80 www opendai eu OPEN x i x DAI 220 amp Infrastructures pzm Pilots development report 2 5 1 1 1 Followed development plan M9 M10 M11 M12 M13 M14 M15 M16 M17 M18 Database connection API development Application dev software tests Application development Application testing Application buggfix Deploy 2 5 1 1 2 Development results The pilot will help the everyday life of citizens Karlshamn but it is also built to be deployed in any PA which have the same needs of citizens reporting errors on broken equipment The pilot shows that it is possible for the citizens to be more involved in keeping the city functional and clean We are trying new technology by building this pilot application and that has resulted in some problems with packages and versions While the development process was undergoing the software used was updated several times which resulted in bugs and slowed the development process The api can be found on the API store https api opendai eu store apis info name KHReports amp version 1 0 0 amp provider Swed enAdmin Carrier gt 3 45 PM E Carrier gt 3 46 PM 194 116 110 159 e 194 116 110 159 o 9 Q Nya rapporter Si
68. ollectSchedulettem gt gcCollectScheduleltem finishTime lt value 20 30 00 value sifinishTime gt startTime svalue gt 20 00 00 lt value gt istartTime sigcCollectSchedulettem gt x gt 37 883198114758706 x gt y 40 975953909991645 gt canList gt canList acCollectScheduleltem finishTime svalue 06 30 00 value finishTime gt lt startTime gt lt value 06 00 00 value gt zistartTime xigcCollectScheduleltem acCollectScheduleltem sfinishTime gt lt value 10 30 00 value gt ifinishTime gt startTime svalue gt 10 00 00 lt value gt lt startTime gt ycCollectSchedulettem gt gcCollectScheduleltem finishTime lt value gt 16 30 00 value gt lt finishTime gt startTime zvalue 16 00 00 value istartTime lt gcCollectSchedulettem gt lt gcCollectSchedulettem gt finishTime xvaluez 20 30 00 valuez by em Cl C DS Figure 31 Screenshot information svalue gt 10 00 00 lt value gt startTime gt Raw XML Raw XML getinformationForCan In this operation the outcome consists of information about for a specific garbage can In the sample request presented below we asked information about the can with Id of 2 and the return has useful information like company district amp street info itemType and itemCount PUBLIC CONFIDENTIAL 57 www opendai eu OPEN Opening Data DA Architectu
69. opment TEIID data virtualization App Backend development App Mobile development App testing Deploying and publishing 2 2 2 1 2 Development results The pilot results are mainly 2 different services The APIs with public data available for citizens and 3 party developers and a web application focused on adding a service on Barcelona city council catalogue of services for internal public authorities APIS The APIs developed and published on this pilot are e Pollution API https api opendai eu store apis info name Barcelona_Pollution amp version 1 0 amp p rovider SpainAdmin Streets API https api opendai eu store apis info name Barcelona Streets amp version 1 0 amp pro vider SpainAdmin This APIs are explained and documented on the deliverable D6 1 as part of WP6 App The result is an operational web app application published on this side http bcn opendai eu Eed PUBLIC CONFIDENTIAL 34 www opendai eu OPEN i c DAI eue amp Infrastructures p gt Pilots development report Montgat EMD valldoreix Sant Feliu de Sant Just Desvern Llobrega Esplugues de lobregat vell Sant Joan Desp Comell de Llobregat Sant Boi de Llobregat Optimal Regular Bad Figure 17 Screenshot Correlation between environment and mobility 2 2 2 2 Pilot documentation 2 2 2 2 1 Pilot code repository Github repository https github com open dai bcn lleida opendai pilots
70. p Pilots development report The following diagram shows the deployment of the artefacts of the pilot Browser Web Application HTM JS JBoss Cluster API Manager x S Figure 22 Block diagram Data publication In the diagram there are two types of artefacts The orange nodes are the Open DAI platform nodes while the green ones are the external nodes Describing the artefacts on detail On Public administration host are localized the legacy data sources connected to the Open DAI Platform The first artefact as part of Open DAI platform is the TEIID data virtualization system adapted to Barcelona city silos e Over the data virtualization the API manager provided by WSO2 framework offers access and control to the REST APIs publishing publicly an API store Also part of Open DAI platform is designed and developed using Django framework the back end required by the mobile application This back end is composed by 2 artefacts o A Geo server artefact developed using geodjango required by the web application for the geospatial services such as geonaming reverse resolution and some different trigonometric functions Ee PUBLIC CONFIDENTIAL 45 www opendai eu OPEN x DAI 2o p amp Infrastructures H Cipz Pilots development report o An application server developed using django with services and logic functions required by the web application on purpose to light the
71. res amp Infrastructures Pilots development report Request 2 ocr pg Boc O htt 192 168 34 231 2112 services OpenDaiServices gt 4 0 soapenv Envelope xmins soapenv http schemas xmlsoap org soap envelope xml aj N soap Envelope xmlns soapz http schemas xmlsoap org soap envelope gt CG soapenv Header gt X lt soap Body gt gt lt soapenv Body gt ns2 getlnformationForCanResponse xmins ns2 http servis esh opendai sochs sampag E ser getinformationForCan gt ZS return LOptional gt canPoiltem getlnformationForCanRequest lt companyld gt 63000 companyld gt C Optional gt distirictType gt lt canPoittem gt lt id 38 lt id gt LOptional gt lt distirictType gt lt comment gt lt comment gt id gt 2 id gt xitemCount 5 ttemCount companyld companyld itemType gt 3 temType gt streetTypes sid gt 2 id gt sid gt 1727 id gt et Optional streetType gt sitemCount gt lt itemCount gt icanPoiltem C Optional return itemTypes temType ins2 getlnformationForCanResponse tC Optionat soap Body gt soap Envelope gt zc Dptional exe C Optional ayseMN xicanPoiltem fgetInformationForCanRequest lt ser getinformationForCan gt soapenv Body gt soapenv Envelope gt Cl EE D Figure 32 Screen
72. responding data directory of geoserver restart of the geoserver instance it is required 2 1 1 2 3 User Manual The main use cases for the web dashboard are represented in the diagram below Ee Choose an accident X m m 8 E Correlate traffic information near N accident Figure 3 Main use case TWIST accident publishing The user has a map where all the accident point are plotted He can filter by period to get just the accident he is interested The map also shows the traffic sensors position When he selects an accident he can visualize in the sensor point near the traffic information to correlate the traffic information to the accident event The application is javascript based application mainly based on OpenLayer Eed PUBLIC CONFIDENTIAL 10 www opendai eu OPEN x i y DAI 20 amp Infrastructures p gt Pilots development report 2 1 2 TWIST real time accident collection SaveUS Abstract Application to collect real time accident data from citizens Pilot is composed by a web site a smartphone application a business process and API Technologies used on pilot Technologies used on pilot e Open DAI platform e Open DAI platform e ll framework e ll framework The pilot deployed in September 2013 has been replaced by a new version forked by a private company that used the published source to release a new improved and integrated with the emergency service IT systems in the
73. rg soap envelopes gt soapenv Header gt gt soap Body gt soapenv Bodys sns2 listTheCansByStreetResponse xmlns ns22 http servis esb opendai socbs sampas com d ser listTheCansByStreet gt E return C Optional canPoiltemList slistTheCansByStreetRequest gt lt companyld gt 63000 companyld gt zt Optional gt distirictType gt lt addressDistricttem gt id gt 4 lt id gt C Optional idistirictTypes xidz fid id gt 50 id gt C Optional lt itemCount 0 lt temCount gt ilce jd gt lce id itemType gt 7 lt temType gt LOptional gt lt streetType gt mahalle adi gt lt mahalle adi id gt 10739 id gt addressDistricttem gt streetType C Optional gt canPoiltemList gt lt addressStreettem gt canPoiltemList Cc Optional lt companyld 63000 lt companyld cadde sokak adi gt lt cadde sokak adi distirict Types xt Optional sid gt 38 lt id gt cadde sokak id cadde sokak id fdistirict Types Cc Optional id gt 2 id gt mahalle id gt 58 mahalle id itemCount gt S lt temCount gt lt faddressStreetttem gt itemType gt 3 temType gt sfistTheCansByStreetRequest gt streetType gt ser listTheCansByStreet gt id gt 1727 id gt lt soapenv Body gt streetType gt soapenv Envelope gt canPoittemList gt canPoiltemList companyld 63000 lt companyld distirictType gt id gt 38 id
74. rted License Statement of originality EG PUBLIC CONFIDENTIAL 1 www opendai eu OPEN DAI opening Data y Gy ppm a Cip Pilots development report This deliverable contains original unpublished work except where clearly indicated otherwise Acknowledgement of previously published material and of the work of others has been made through appropriate citation quotation or both ES PUBLIC CONFIDENTIAL 2 www opendai eu OPEN DAI 75 i Ar chi tectun res amp Infrastructures Leg Cip Pilots development report Table of Contents 1 Pilots implementation report 7 1 1 Piedmont Region Pilots mplementaton 7 1 1 1 TWIST accident publish e Eden maintains a dada a ase e iccd ai 7 TT Pilotd velopment siainen pbnk M qmd dade dacuE Gai edddudedudedac ban 8 1 1 1 1 1 Followed development 0 8 1 1 1 1 2 Development r sulls geed Ee 9 1 1 1 2 Pilot documentation dee 9 1 1 1 2 1 Pilot code reposkonuuuesmanmandieeinmenjiskenvvvv bd 9 1 1 1 2 2 How to install and deploy 10 su E USER Manual ROE roep ieaiaia e ari 10 1 1 2 TWIST real time accident collechon Gavellz 11 1 1 2 1 Pilot Een 11 1 1 2 1 1 Followed development olan 12 1 1 2 1 2 Development reegen odas gap iis Ba a atas Ce 12 1122 Pilot done sukooseqiss opio quE E EFE Eee tn aant ERE FUSE dde p EYE FEER
75. s amp Infrastructures Pilots development report Request 1 ort K bou E D http 192 168 34 231 2112 services OpenDaiServices gt 0 z soapenv Envelope xmlns soapenv http schemas xmlsoap org soap envg S soap Envelope xmlns soapz http schemas xmlsoap org soap envelope soapenv Header gt lt soap Body gt gt lt soapenv Body gt sns2 listPOlTypesResponse xmins ns2 http servis esb opendai socbs sampas com d lt ser listPOlTypes gt d return lt poiTypes gt listPOITypesRequest gt lt poiTypes gt Hastane lt poiTypes gt ser listPOITypes gt lt poiTypes gt Eczane lt poiTypes gt soapenv Body gt poiTypes Kilises poiTypes lt soapeny Envelope gt lt poiTypes gt Camis poiTypes gt lt poiTypes Egitin poiTypes lt poiTypes Konaklamas poiTypes gt lt poiTypes Sinagog poiTypes gt lt poiTypes gt Tiyatro poiTypes gt lt poiTypes gt Sinemas poiTypes gt lt poiTypes Ulasim Turizms poiTypes gt lt poiTypes gt Konsolosluks poiTypes gt lt poiTypes gt Yakifs poiTypes gt lt poiTypes Tarihi Eser poiTypes gt lt poiTypes gt Otels poiTypes gt poilTypes gt return gt ns2 listPOITypesResponse gt lt soap Body gt lt soap Envelope gt Jer viel v 8 Figure 43 Screenshot sample request listPOIsByType This operation queries and presents info about the POI locations for a given POI type In
76. s a web application on JBOSS server included in this case on Open DAI platform Application Back end The Backend service is developed using Python django framework To deploy these services is required the source code and a server with Python 2 7 and Django 1 6 x The django applications run using WSGI technology behind a proxy web server In our case we used Gunicorn as WSGI provider and NGINX server as a proxy This application has to run on the same network where the TEIID artefact publishes the APIs Then only is needed to configure the IP address of this APIS on the django application settings Application Front end The Web App resources needs to be served using a web server system in our case is used a NGinx software 2 2 2 2 3 User Manual Register and Loging p API consumer System Polltion Map Environmental API Figure 18 Use caseCorrelation between environment and mobility Ee PUBLIC CONFIDENTIAL 36 www opendai eu Application User OPEN DAI opening Data y Gy g Eear a Pilots development report This app permits a data correlation service between environment and mobility data The main client is intended to be the PA with the goal to improve its planning and operating capabilities The map displaying services on environmental status will be used in conjunction with urban mobility data obtained by the project Having environmental status data with location and timestamp attributes will ena
77. shot getlnformation queryCanType By using this operation one can see the available garbage can types and their respected Id s PUBLIC CONFIDENTIAL 58 www opendai eu OPEN Opening Data DA Architectures amp Infrastructures Pilots development report go http 212 175 88 99 2225 services OpenDaiServices gt a lt soapenv Header gt lt soapenv Body gt ser queryCanType gt soapenv Body gt soapenv Envelope gt soapenv Envelope xmlns soapenv http schemas E x m lt gt soap Envelope xmins soap http schemas xmlsoap org soap envelope E ssoap Body gt ns2 queryCanTypeResponse xmlns ns2z http servis esb opendai socbs sampas com sreturn gt canTypeList lt code gt 2 lt code gt sname COP BIDONU name gt canTypeList gt canTypeList scode gt 1 lt code gt lt sname TIBBI ATIK BIDONUs name gt lt icanTypeList lt canTypeList gt lt code gt 3 lt code gt sname PLASTIK COP KOVASIs name canTypeList gt canTypeList s lt code gt 4 lt icode gt name DEMIR COP KOVASIs name gt canTypeList gt canTypeList lt code gt 5 lt code gt name BAHCE TIP COP KOVALARIs name gt IcanTypeList canTypeList lt code gt 6 lt code gt name GERI DONUSUM KONTEYNERLARIs name canTypeList gt iretur lt ns2 queryCanTypeResponse gt s0ap Body gt soap Envelope gt Raw XML
78. specific utility to use this data and prove the use case detailed also on D5 1 The Pilot development consists on add APIs on Open DAI platform from silos detailed and a mobile application development addressed to the Barcelona citizens The main goal is to achieve a useful service using the APIs opened with Open DAI project The service developed to prove the data utility is a mobile app to give road incidents and public facilities data on real time to the citizens 2 3 1 1 Pilot development In order to develop the application Road Incidents and Accessibility in a service we define a solution composed by a Mobile Application as a user interface and a service back end to attend the petitions from the mobile phone The smart phone application interacts with the server application described and offers a graphical user interface for the consumers This mobile application is developed using a 23 PUBLIC CONFIDENTIAL 38 www opendai eu OPEN DAI Opening Data Architectures amp Infrastructures Le a cipz Pilots development report web based cross platform technology in order to facilitate the availability on the different mobile platforms The following diagram shows the deployment of the artefacts of the pilot Smartphone Mobile App D JBoss Cluster API Manager EK poe e es Figure 19 Block diagram of road incidents and accessibility In the diagram there are two types of artefacts The
79. t will be possible to populate the JAVA beans and marshal the resulting XML easily 23 PUBLIC CONFIDENTIAL 20 www opendai eu OPEN C DA amp Infrastructures Pilots development report 2 1 3 2 3 How to install and deploy The code produces a WAR file that has to be installed in a JBoss application server The application server requires the JNDI connection to the DB and the servlet exposes the data service that will be published through the API manager 2 1 3 2 4 User Manual This pilot is a pure API project There are 4 API published to expose the different entities that are Measurement network stations Measurement stations Measurement parameters Raw data measurement The data is real time data The API call is described in the following table API result parameter parameter meaning networks List of measurement networks networks id startDate AA List of stations part Id Id of the network AMMMGGG amp S endDate AA of the network AMMMGGG startDate Optional date to require stations active from date endDate Optional date to require stations active until date stations List of all stations startDate Optional date to require stations active from date endDate Optional date to require stations active until date 23 PUBLIC CONFIDENTIAL 21 www opendai eu OPEN C DAI oes amp Infrastructures Pilots development report x cip
80. tatus The service logic is responsible to obtain the environmental data from Open DAI and detect the health risk zones depending on the pollution levels on a specific time The pollution limits set by the European Union are used as a health risk Also the service logic takes into account the weather data effect over pollution Finally this data service is presented on a mobile application on each running route selected Ee PUBLIC CONFIDENTIAL 31 www opendai eu OPEN DAI Opening Data y Architectures amp Infrastructures Le Cip Pilots development report 2 2 2 Correlation between environment and mobility Web App Abstract The Correlation between environment and mobility pilot is a web application with relevant data about the environmental conditions and mobility data from the Barcelona city in order to show on a map view the correlation between the environmental data and the mobility data This pilot is also opening the silos with mobility data on the city and the access to the environmental data for Barcelona Technologies used on pilot Data sources silos e Open DAI platform Road congestion e REST JSON Noise Levels e Python e Pollution level Django framework Titanium framework This pilot aims to publish the data silos detailed on the document D5 1 using the Open DAI infrastructure and technologies Once APIs are available the pilot aims to develop a specific utility to use this data and prove
81. the systems and since this code is not saved with the accident information we can assure that is not possible to associate the accident information to a particular user preserving anonymity Ee PUBLIC CONFIDENTIAL 15 www opendai eu OPEN Opening Data x DA Architectures amp Infrastructures Pilots development report Firefox O saveMe beak gt Gr saveuslocathost index php Registration registration e Googie 2 E E Q Bookmark B Highlight El Capture D Send Cj Read Later 3 Unread E Recent 3 Add a filter P Options al Go premium KeeFox 4B KeeFox loading 8 Logins Registrazione Fields with are required Username aioopoluca email gioppoluca libero it IE Cognome Gioopo Nome Luca Password m Conferma password domnt csiit Accesso a Internet Rete non identificata 1 1 13 Nessun accesso a Internet Figure 7 Image registration process Login With the login data it will be possible to login into the web site and doing so will enable a new tag for managing the process customization EEG see m j i ecco oogle 2 t B Digo E Q 4 Bookmark 9h Highlight E Capture Send Read Later Unread 3 Recent 27 Add a filter F Options ill Go premium KeeFox 49 Launch KeePass Logins gt saveus loca
82. tie ettet umana dun de Gu sdscea Deco Ded eustate ues 19 Figure 13 Block diagram Pollution monitor for outdoor activities 27 Figure 14 Image Mobile App Barcelona corre 29 Figure 15 Use Case Monitoring real time pollution in spaces for outdoor activities 31 Figure 16 Block diagram Correlation between environment and mobility 33 Figure 17 Screenshot Correlation between environment and mobility 35 Figure 18 Use caseCorrelation between environment and mobility 36 Figure 19 Block diagram of road incidents and accessibility 39 Figure 20 Screenshot Mobile App Road incidents and accessibility 41 Figure 21 Use case Road incidents and accessibility 43 Figure 22 Block diagram Data publication corriere nene erret 45 Figure 23 Screenshot Data Publication cocotte e eer e deele Eer 47 Figure 24 Use case Data DUDIICSIIQI EE 49 Figure 25 Block diagram City Dynamics e iuncta ena mqi seh rm teams oan venn 51 Figure 26 City Dynamics Workflowe l crie eeieeeieec eee rien nente urne n npn us 52 Figure 27 Screenshot Sample request
83. w XML Figure 46 Screenshot list cities listTheAddressStreet In this operation for a given city district or neighbourhood one can get detailed street information about this area In the below example we requested the info for the city which has the Id 63 PUBLIC CONFIDENTIAL 72 www opendai eu OPEN Opening Data DA Architectures amp Infrastructures Pilots development repo at D Ek H D htto 192 168 34 231 2112 services OpenDaiServices soapenv Envelope xmlns soapenvs http schemas xmlsoap org soap envelope Ee N lt soapenv Header gt lt soapenv Body gt ns2 listTheA amp ddressStreetResponse xmins ns2 http servis esh opendai sochs sampas com lt serlistTheAddressStreet return t Optional addressStreetltemList listThe amp ddressStreetRequest sid 234 lt id gt C Optional gt districtlnfo saddressDistricttem gt sid gt 1 lt dd gt LOptional idistrictinfo lt id 63fsid lt streetinfo lt LOptional gt sid gt 234 lt id gt silce_id gt lt flce_id gt streetinfo gt LOptional gt x addressStreetitemList mahalle adi gt lt mahalle adi gt lt addressStreetttemList gt lt addressDistricttem gt lt id gt 287 id gt flistTheAddressStreetRequest gt districtinfo lt iser listTheAddressStreet gt sid 1 lt dd gt soapenv Body gt districtinfo soapenv Envelope gt streetInfo sid gt 287

ODAI-WP5-D2 - Open-DAI

Contents

Download Pdf Manuals

Related Search

Related Contents