Accept Mistakes: No dataset is perfect. Opening up data will inevitably reveal inaccuracies. The good news is that it will also help to correct them. Engage Citizens: Remember your data is only valuable if it is used. Tell your – citizens that you are making data available and encourage them to use it. Citadel recommends that cities take the following steps when opening their data: Select the Data Set: Remember simple and can be good! The key thing is – that the data is publically available and has no IPR restrictions on the way it can be used, reused or redistributed. Publish the Data Set: For compatitbility with Citadel tools and templates, use CSV a very simple form that can be saved from Excel, Open Office and most spreadsheet – programmes. Try to avoid closed formats such as PDF. But most important of all, put your data out there. If someone wants to use it they will find a way! Publicise the Data Set: Data needs to be discovered and discoverable to be used. Make sure to post you data on your website or a central catalogue, and tell your citizens it is there! Step 2: Convert Data NOTE these instructions assume that a) the reader has a basic level of technical knowledge – in handling simple datasets and 2) the reader is able to access their dataset in CSV format. To convert data into a format that will enable your app to work in different cities Citadel across Europe follow these basic steps: Make sure your dataset is saved as a CSV file Access the Citadel Convertor Website: Upload the CSV file Review the preview that pops up (the 5 rows of datasets) to check that everything appears correctly If required, refine the following CSV presets and repeat the preview until the dataset displays correctly: Delimiter Enclosure Escape Character Follow the on-screen instructions to manually map the headings of your dataset to the values of the Citadel Dataset Template Select the Latitude and Longitude fields that enable data to be referenced on a map Complete the necessary metadata fields when prompted Click convert and wait for the JSON file to be produced Download JSON file to your computer
Accept Mistakes: No dataset is perfect. Opening up data will inevitably reveal inaccuracies. The good news is that it will also help to correct them. Engage Citizens: Remember – your data is only valuable if it is used. Tell your citizens that you are making data available and encourage them to use it. Citadel recommends that cities take the following steps when opening their data: Select the Data Set: Remember – simple and can be good! The key thing is that the data is publically available and has no IPR restrictions on the way it can be used, reused or redistributed. Publish the Data Set: For compatitbility with Citadel tools and templates, use CSV – a very simple form that can be saved from Excel, Open Office and most spreadsheet programmes. Try to avoid closed formats such as PDF. But most important of all, put your data out there. If someone wants to use it they will find a way! Publicise the Data Set: Data needs to be discovered and discoverable to be used. Make sure to post you data on your website or a central catalogue, and tell your citizens it is there! Step 2: Convert Data NOTE – these instructions assume that a) the reader has a basic level of technical knowledge in handling simple datasets and 2) the reader is able to access their dataset in CSV format. To convert data into a Citadel format that will enable your app to work in different cities across Europe follow these basic steps: Make sure your dataset is saved as a CSV file Access the Citadel Convertor Website: Upload the CSV file Review the preview that pops up (the 5 rows of datasets) to check that everything appears correctly If required, refine the following CSV presets and repeat the preview until the dataset displays correctly: Delimiter Enclosure Escape Character Follow the on-screen instructions to manually map the headings of your dataset to the values of the Citadel Dataset Template Select the Latitude and Longitude fields that enable data to be referenced on a map Complete the necessary metadata fields when prompted Click convert and wait for the JSON file to be produced Download JSON file to your computer
Citadel_WP2_v.2.docx