Tag Info

New answers tagged

0

You can put your polygons or lines in a geojson column. If necessary, you can transform that column in geometries using the st_geomfromgeojson function. update yourcsv set the_geom = st_geomfromgeojson(polygon1) The question is more or less related: ...


1

An alternative to exporting the results of a join is to use the Join Field tool instead of creating a join. This tool directly adds the attributes to the feature class based on a join (one step) as opposed to joining and exporting (two step).


1

If you want to preserve a permanent copy of the fields that you have joined to a feature class, you need to export it to a new feature class. Right-click the layer in the TOC and choose Data > Export Data.


4

You can use QGIS' Delimited Text Layer support to add the layer to the map, at which point you can right-click the layer and select 'Save As...' to convert to Shapefile or other supported formats.


1

The line breaks are in Classic Mac (CR); they should be in Unix (LF). I fixed this by opening my file in TextWrangler and changing the line encoding in the save as screen.


-1

Now there is a great plugin produced by Michael Minn that does exactly what you're looking for. Just update your plugin repository and install MMQGIS. I just tried it out and it worked great.


0

By using "Add comma delimited file" instead of Vector layer button QGIS will read it with number columns as columns. A dialog window will open where you can change the delimiting character to colon, semicolon, tab or others. If the csv is intended to be used as a table (not an xy or event layer) you have to ask for No geometry. Here you have an example ...


1

In previous answer I completely forget to check plugins first which you should always do because there are really many good ones and for this particular case you want to use: PointConnector Creating lines between points following a from-to list You can install it through Plugins / Manage and install Plugins...


1

With not that hard adjusting you should be able to use Processing / Toolbox... QGIS algorithms / Vector creation tools / Points to path the point layer must be exported to csv including id of points and coordinates x,y the csv with FROM / TO must have some Path_ID (Group) for every future path through which the attribute COST or others will be linked, ...


1

I think the two messages are separate. The first message is just a warning that anything such as formulae, formatting and additional worksheets cannot be saved in a CSV as it is a simple ascii format. The second message suggests that you maybe have a text field as one of your attributes which contains a comma. This will effectively introduce an extra ...


1

I took a closer look and actually the data wasn't truncated. It's just that some values are bigger (1477701) and others are smaller (203071). I thought I had a truncation issue when I saw the smaller values in the first page of the DBF and the large values from a segment of the attribute table of the shapefile they are supposed to match. On a different note ...


3

The solution may be to create a .csvt file, in the same folder as your .csv file, where you just write the data type. For instance: "String", "String", "String", "String", "String", "Integer"


0

In Rails, you should check the import log as follows: DataImport.find(id: 'f248f418-5d88-4c06-ab2c-4bbbfdea88ce').log Typical errors for CSV files are: - File has some weird encoding. Solution: open it with a text editor and save it as UTF-8. - In the street you're using commas that are being interpreted as new rows. If this is the case, be sure that ...


1

There is a rule for detection of columns containing coordinates based on attribute name. Coordinate column is detected if the attribute name of X coordinate is: x, xcoord, xcoordinate, coordx, coordinatex, longitude, long or the attribute name contains: x_*, *_x Similar for Y coordinate: y, ycoord, ycoordinate, coordy, coordinatey, latitude, lat or ...


1

Indeed, the whole calculation is better done in excel, thanks for the attention anyway!



Top 50 recent answers are included