User Tools

Site Tools


publisher:mapping_a_csv

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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]].
    
  
  
publisher/mapping_a_csv.1632752169.txt.gz · Last modified: 2021/09/27 14:16 by admin