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/07/19 16:53]
admin
publisher:mapping_a_csv [2022/02/22 15:59] (current)
admin [Things to know beforehand]
Line 1: Line 1:
-====== Publishing Map files on SD ====== ​+====== Publishing Map files on Dublinked ​====== ​
  
 ===== Who is this guide for ===== ===== Who is this guide for =====
-This guide is for publishers who would like to display a map file on SmartDublinThey already have a CSV file that includes latitude and longitude values. +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 upload KML files to the Geoserver and Datastore so that they can be published as maps+  ​* 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 copy styling from a similar dataset   * How to copy styling from a similar dataset
   * How to fix simple error (zero error) encountered when uploading   * How to fix simple error (zero error) encountered when uploading
Line 11: Line 11:
 ===== Things to know beforehand ===== ===== Things to know beforehand =====
  
-You must know how to [[publisher:​adding_resource_to_sd|upload resources to SmartDublin]].+You must know how to [[publisher:​adding_resource|upload resources to Dublinked]].
    
-Currently (July 2021), ​SmartDublin ​requires a KML file to publish as a map (not currently a Shapefile).+Currently (July 2021), ​Dublinked ​requires a KML or GeoJSON ​file to publish as a map.
  
-  ​- 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]] +You must have one of the following 
-  - You will be asked to identify any name/​description field(s) and the latitude/​longitude columns by column number. +  * a CSV file that includes latitude and longitude or X and Y values  
-  - Convert the file then download the resulting KML file and upload it to the dataset on SmartDublin ​where you have published the CSV file+  * a KML file  
 +  * a GeoJSON file  
 +[[publisher:​ArcGIS data to lat/long|If you have a CSV containing eastings and northings, see here]] 
 +  
 +  ​- To generate a GeoJSON ​from an Excel or CSV file use this link:[[public:converting_geolocated_data|Converting geolocated data]] 
 +  - Once you have generated ​the GeoJSON, ​upload it to the dataset on Dublinked ​where you have published the CSV file
  
 ===== Uploading the data to the Geoserver and Datastore ===== ===== Uploading the data to the Geoserver and Datastore =====
 To display a map, the data needs to be available in the Geoserver and the Datastore. To display a map, the data needs to be available in the Geoserver and the Datastore.
-  * Click on the resource and there should now be a link to “Import GeoData” ​+  * Click on the (KML or GeoJSON) ​resource and there should now be a link to **“Import GeoData”** 
   * Click on this link to upload the data to the Geoserver and the Datastore   * Click on this link to upload the data to the Geoserver and the Datastore
 {{ :​publisher:​upload_to_geoserver.jpg?​600 |}} {{ :​publisher:​upload_to_geoserver.jpg?​600 |}}
-  * You will be asked about the EPSG code, click OK to accept the default value+  * You will be asked about the EPSG code, **click OK to accept the default value**
 {{ :​publisher:​accept_default_epsg.jpg?​600 |}} {{ :​publisher:​accept_default_epsg.jpg?​600 |}}
  
   * You should get the following message, confirming that the data has been submitted to the Datastore and Geoserver:   * You should get the following message, confirming that the data has been submitted to the Datastore and Geoserver:
 {{ :​publisher:​submitted_resources_message.jpg |}} {{ :​publisher:​submitted_resources_message.jpg |}}
-If it does not see [[publisher:​error on csv upload to geoserver|]]+**If it does not load correctly, ​see [[publisher:​error on csv upload to geoserver|]]**
   * You should now see 2 new resources on the dataset, one labelled with “Datastore via GeoServer”,​ the other “Web Map Service in GeoServer”:​   * You should now see 2 new resources on the dataset, one labelled with “Datastore via GeoServer”,​ the other “Web Map Service in GeoServer”:​
 {{ :​publisher:​2_new_resources_in_dataset.jpg?​600 |}} {{ :​publisher:​2_new_resources_in_dataset.jpg?​600 |}}
Line 35: Line 40:
 {{ :​publisher:​successful_load_no_styling.jpg?​600 |}} {{ :​publisher:​successful_load_no_styling.jpg?​600 |}}
  
-===== Copying styling from an existing 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]]
-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 copy an existing style+ 
-  * Go to the associated dataset that has already been styled +
-  * Open the “Web Map Service” resource and click on the “Edit Style” button +
-{{ :​publisher:​edit_style_button.jpg?​400 |}} +
-  * Click into the styling code and use CTRL-A, CTRL-C to copy the code +
-  * Leave that page without making any changes +
-  * Navigate to your original dataset and select the “Web Map Service” resource +
-  * Click on “Edit Style” and use CTRL-A, CTRL-V to paste in the code from the other dataset. Use the “Change Style” button to save the new style: +
-{{ :​publisher:​change_style_button.jpg?​400 |}} +
-  * You should now see success message: +
-{{ :​publisher:​styling_upload_success.jpg?​400 |}} +
-  * Now return to the dataset ​page and refresh it – you should now see the results of the styling:  +
-{{ :​publisher:​styling_working_after_refresh.jpg?400 |}} +
-  * If the page does not change, try refreshing it again or loading a private window - it should update +
  
  
publisher/mapping_a_csv.1626713618.txt.gz · Last modified: 2021/07/19 16:53 by admin