Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
I've been working on deriving bearings and distances from lines in qgis 2.18 from a number of coordinates stored as a csv file. I have been able to generate the bearing of the lines using this expression in the field calculator:
CONCAT(format_number(degrees(azimuth(start_point($geometry), end_point($geometry))), 2), '°')
But this expression does not allow the bearing to be added in the attribute table (or i simply dont know how to do that). Can anyone help?
Assuming you are using the field calculator and creating a new field, this works just fine.
Therefore, I suspect that you have not specified your firld type as Text and left it as the default Whole number (Integer). Remember you are concatenating numeric values with the degree sign - which is text and the result is text.
CSV files can't be edited in QGIS.
Save the layer in a different format such as shapefile or geopackage. Load the file you just created into QGIS. You will be able to add fields to this layer using the Field Calculator.
If you need this file in CSV format, you have two options:
Work with the data in a QGIS-compatible format (as described above). When you're finished making changes, export the data to CSV format.
Install the Editable GeoCSV plugin. This plugin should allow you to directly edit the CSV file without first converting it to shapefile or other compatible format. It might be a good idea to make a backup copy of the CSV file before using the plugin, just in case it changes your file in a way you don't like.
Related: Why can't I edit attribute table imported through 'text as layer'
