User Tools

Site Tools


publisher:mapping_a_csv

Publishing Map files on Dublinked

Who is this guide for

This guide is for publishers who would like to display a map file on Dublinked.

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 copy styling from a similar dataset
  • How to fix simple error (zero error) encountered when uploading

Things to know beforehand

You must know how to upload resources to Dublinked.

Currently (July 2021), Dublinked requires a KML or GeoJSON file to publish as a map.

You must have one of the following

  • a CSV file that includes latitude and longitude or X and Y values
  • a KML file
  • a GeoJSON file

If you have a CSV containing eastings and northings, see here

  1. To generate a GeoJSON from an Excel or CSV file use this link:Converting geolocated data
  2. 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

To display a map, the data needs to be available in the Geoserver and the Datastore.

  • 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

  • You will be asked about the EPSG code, click OK to accept the default value

  • You should get the following message, confirming that the data has been submitted to the Datastore and Geoserver:

If it does not load correctly, see 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”:

  • And if you refresh the dataset, the map should display by default.

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 copy an existing style from a similar dataset.

publisher/mapping_a_csv.txt · Last modified: 2022/02/22 15:59 by admin