publisher:mapping_a_csv
Differences
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/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 SmartDublin. They 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 a 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
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
