This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
publisher:mapping_a_csv [2021/09/27 14:16] admin [Things to know beforehand] |
publisher:mapping_a_csv [2022/02/22 15:59] (current) admin [Things to know beforehand] |
||
---|---|---|---|
Line 4: | Line 4: | ||
This guide is for publishers who would like to display a map file on Dublinked. | This guide is for publishers who would like to display a map file on Dublinked. | ||
===== What this guide teaches ===== | ===== What this guide teaches ===== | ||
+ | * How to convert a CSV file with location information to a GeoJSON or KML file (geolocated data) | ||
* How to upload KML or GeoJSON files to the Geoserver and Datastore so that they can be published as maps | * How to upload KML or GeoJSON files to the Geoserver and Datastore so that they can be published as maps | ||
* How to copy styling from a similar dataset | * How to copy styling from a similar dataset | ||
Line 20: | Line 21: | ||
[[publisher:ArcGIS data to lat/long|If you have a CSV containing eastings and northings, see here]] | [[publisher:ArcGIS data to lat/long|If you have a CSV containing eastings and northings, see here]] | ||
- | - To generate a KML from an Excel or CSV file use one of the online converters, eg. [[https://www.convertcsv.com/csv-to-kml.htm|CSV To KML Converter]] | + | - To generate a GeoJSON from an Excel or CSV file use this link:[[public:converting_geolocated_data|Converting geolocated data]] |
- | - You will be asked to identify any name/description field(s) and the latitude/longitude columns by column number. | + | - Once you have generated the GeoJSON, upload it to the dataset on Dublinked where you have published the CSV file |
- | - Convert the file then download the resulting KML file and upload it to the dataset on SmartDublin where you have published the CSV file | + | |
===== Uploading the data to the Geoserver and Datastore ===== | ===== Uploading the data to the Geoserver and Datastore ===== | ||
Line 40: | Line 40: | ||
{{ :publisher:successful_load_no_styling.jpg?600 |}} | {{ :publisher:successful_load_no_styling.jpg?600 |}} | ||
- | As you can see, this map is not very useful. You may want to style it, that is, use CMS styling to improve the way it displays. For Smart Dublin we are going to use common styling for harmonized datasets across the local authorities so you may be able to just [[publisher:copy_styling_from_existing_map|copy an existing style from a similar dataset]]. | + | As you can see, this map is not very useful. You may want to style it, that is, use CMS styling to improve the way it displays. For Dublinked we are going to use common styling for harmonized datasets across the local authorities so you may be able to just [[publisher:copy_styling_from_existing_map|copy an existing style from a similar dataset]]. |