Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [csv]

A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.

0
votes
1answer
15 views

Trying to use a SelectByAttribute_mangement after I made the XY Event layer

I imported a CSV file using the MakeXYEventLayer_management and trying to use the SelectlayerByAttribute_management function, but I am getting error message saying on "Object ID(OID)" is present.. Is ...
0
votes
1answer
14 views

Graduated Style Renderer not displaying for joined csv to shp

I have joined a csv file (via the add spreadsheet layer plugin) and the field types have saved correctly (i.e. they are "real" types, see attached image), and yet the graduated style renderer option ...
0
votes
1answer
59 views

Parsing CSV data and updating a dictionary and creating a polyline

I am a little stuck on my code. I am new to Python and am learning as I go, but have usually been able to figure it out till now. The code was working up till I put the dictionary part in and now ...
1
vote
0answers
21 views

Data type for mixed representation

The following is a JSON representation of an large array of planar spatial surfaces. {"type":"Feature", "geometry":{ "type":"MultiPolygon", "coordinates": [[[[17.7529,-31.146],[17....
1
vote
1answer
37 views

Why is QGIS not recognising latitude and longitude correctly?

I am importing a simple 5 column csv file into QGIS using Add Delimited Text Layer. Each row of the table contains a name, a street address, a postcode, a decimal latitude and a decimal longitude, for ...
0
votes
0answers
78 views

Editing and saving CSV file to use in plugin for QGIS?

For using in a plugin (PS Time Series Viewer), I want to edit a CSV file in the way plugin wants. Somehow I think there's a problem with the CSV file. I would like to tell you all my steps because I ...
1
vote
1answer
51 views

exporting table to drive from Google Earth Engine returns some NAs where valid data

My question is similar to exporting table in to a drive from Google earth engine returns blank rows, but instead of getting entirely no data, only a few records come back NA where I have confirmed ...
4
votes
1answer
87 views

Import CSV from online resource

With QGIS it´s easy to load non-spatial CSV Data (and use it for joins). This works fine as long the CSV resides on the local file system as this answer suggests. Is there some way to import a CSV ...
1
vote
2answers
70 views

Load LINESTRING in WKT-format from CSV to pgAdmin?

I've got a CSV file with a column containing LINESTRINGs that looks something like this: 1,"LINESTRING(20.331 54.33, 21.67 44.89, 12.67 13.5679)",2014-03-09 13:30:33,2014-03-09 13:31:33 2,"LINESTRING(...
0
votes
3answers
47 views

ogr2ogr CSV conversion with two points into column names

I have a CSV with ":" in all column names. I am trying to convert it with ogr2ogr to another format. I don't need all fields example for formating: #0:imgID,1:camSN,2:lat,3:lon,...,57:fields ...
0
votes
2answers
33 views

Can't import stratigraphy data

I am having trouble importing stratigraphy data from a CSV file. The CSV files can be found at the following link: https://www.dropbox.com/sh/txrrcpbf6cpzh52/AAC8jk4DGP7dZYfBBpj2s1B7a?dl=0 When ...
3
votes
1answer
39 views

Issue converting CSV files to point shapefiles using pyqgis - QGIS 3

I have hit a snag using pyqgis in QGIS 3. I want to convert a set of CSVs (20 total) into point shapefiles but I am struggling with just the single CSV case. My code is based on this blogpost (https://...
1
vote
2answers
39 views

Reading CSV in loop stops at row that does not match?

I am trying to read a CSV then iterate through an sde to find matching features, their fields, and then print them. There is a table in the list and I'm not able to skip over it and continue reading ...
1
vote
3answers
92 views

Is it possible for ArcMap to treat data types (numbers as text) correctly when importing from a text file?

I am creating a text/csv file (using a python script). The file contains data to import into ArcMap. I have several fields that look like numbers but have leading zeros ("0012") etc. that I want to ...
2
votes
1answer
36 views

Add virtual layer to aggregate feature

newbie here of QGIS here, I was trying to aggregate a feature from a CSV with no geometries. The query is very basic: SELECT "PROV", SUM("POP_2012") AS POP_2012 FROM "municipalities-tuscany" ...
1
vote
1answer
38 views

QGIS-Export Raster Values to a .csv file

I use a Raster, based on .png and .pgw file. (plans from a town) The plans include information about where buildings are allowed to be built and maximum building height, ground elevation etc. Now i ...
1
vote
0answers
27 views

Using non-spatial csv with PyQGIS?

I have some csv lookup tables which are too heterogeneous for ordinary join so I want to process them in PyQgis. However the csv files have no geometry column whatsoever. If used as QgsVectorLayer the ...
1
vote
1answer
29 views

In QGIS, how can I use a delimited text layer to keep only those polygons and records of a shapefile which match a column in the delimited text layer?

What I want to do is trim the shapefile so that only those records and associated shapes that match the same values in a column in the delimited text layer (which in my case is a CSV) are kept in a ...
1
vote
0answers
27 views

Plotting with QGIS, blank positions result in errors

I tried to use the delimited text layers, then I found something wrong. Several plots are out of bound. Then I checked the original data and decoded data. It seems when one part of a single data is ...
2
votes
2answers
33 views

Automatically (re)classify data from layer using QGIS?

Is it possible to automatically (re)classify the data of a layer? (properties-symbology-delete all-classify) Because now I have to do this manually each time my data source changes.
1
vote
0answers
55 views

Updating set of attributes on vector layer from .csv table?

I have over 1,000 records in a .shp file, all with a unique ID field (LINKID), along with many other fields containing data (TXTFLD1, TXTFLD2, INTFLD1, INTFLD2, etc). These records have been copied ...
1
vote
0answers
41 views

Importing CSV to Carto from R?

I would like to import a csv file to my Carto account using R. I know the csv has been generated, and I'm able to save it in other locations. Running the code to upload this file to Carto appears to ...
1
vote
1answer
42 views

Exporting attributes table to csv from shp using PyQGIS 2.18?

I'm approaching now for the first time to Python console and I wanted to know step by step how to export in .csv two fields from the attribute table of a vector shapefile(.shp) using just PyQgis. Let'...
1
vote
0answers
40 views

QGIS Join is returning Null values

I am trying to join this data to this data (UTM32 Ebenen file = VG250_GEM.shp) using columns Column2 and SDV_RS, respectively. I am using QGIS 3.4 I am following the instructions found here . ...
1
vote
1answer
122 views

Extract data from NetCDF file based on station

I have read other solutions for NetCDF data but my data are a little different and I do not know how to extract data from NetCDF and save them in CSV files based on stations. Data include the maximum ...
1
vote
1answer
85 views

Converting GPX data stored in CSV into geography data type (WKB or WKT)?

I have a CSV that contains some data relating to hikes undertaken by various people. For each hike, there is an ID, max_elevation, length, start_time, end_time, and GPX field (along with some other ...
2
votes
3answers
105 views

Can I reorder the coordinates of a line when importing into QGIS a WKT linestring?

I managed to import a csv file containing lines in QGIS but unfortunately the x y aren't in the correct order. that is, the csv has a field where there is a sequence of lat (y), lon (x), while qgis ...
2
votes
1answer
83 views

How to create a polygon from a data CSV file with coordinates using QGIS? [duplicate]

Having the following information in a CSV file: I want to build a polygon with all the points where the Group name is the same. For example I want to join all the points where the group is T101 and ...
2
votes
0answers
126 views

QGIS 3.4.4 crashing when adding hyperlink into the Attribute Table

I made a CSV with coordinates and hyperlink connected to JPG photo. I uploaded it into QGIS, export it as ESRI shapefile, and uploaded back it into QGIS. I want to display the photo with hyperlink. ...
1
vote
0answers
70 views

Problem importing geometry from CSV in QGIS

I have a polygon layer (although I have also converted it to points and tried it that way). I would like to copy this layer into excel and add it back in after editing some things. I've attempted to ...
0
votes
0answers
15 views

Time series plot from NMEA 0183 log

I used a weather station sensor on a cruise, which logged the data in the following way (NMEA 0183): 13:07:46.380: <- $WIMDA,30.0911,I,1.0190,B,11.8,C,,,78.3,,8.1,C,70.4,T,68.0,M,8.9,N,4.6,M*59 ...
5
votes
2answers
103 views

Table to Table converting ArcMap table to CSV file in external location cuts column names short?

I am having a strange problem with the ArcPy Table to Table function. For some reason, when I use the function to create a CSV file in a folder that exists outside of my python project folder, several ...
1
vote
1answer
47 views

Understanding FME error?

When I launch a treatment on FME 2018 the following message will appear : CSV reader: Detected excess data and/or delimiters in addition to the defined schema in line XXXX Note that the ...
1
vote
0answers
27 views

Refresh layer with joined tables from watched files

I have a shapefile joined to data from a CSV file that is being watched by QGIS. If the CSV file is updated, the attributes in the CSV layer are updated as expected, but the data in the joined ...
2
votes
0answers
45 views

Importing CSV numbers formatted as string into ArcMap? [closed]

I'm importing a .csv that contains data that I am joining to a shapefile. The value that I am joining is shown in the first column of the image below. When I import the data into ArcMap the data in ...
1
vote
0answers
58 views

Visualizing signal strength of mobile towers

I have a list of latitude and longitude along with signal strength obtained from mobile towers in a certain region. I have all the data in CSV format. In total, I have 4 CSV files. I have mapped the ...
1
vote
1answer
46 views

File not found error using Contour in QGIS 3.4

CSV file load failure in "Contour" procedure, even though the same file will load and display from Layers>Add Layer>. This has not previously been true. The problem could be related to the use of ...
2
votes
1answer
108 views

Using graduate and categorize in QGIS?

I'm using a .csv detailing types of renewable energy in the UK. I want to display them as different colours for the types of energy (e.g. wind, solar, gas etc.) but also a different size symbol based ...
2
votes
0answers
100 views

Loading CSV as a GIS layer into QGIS 3.4 not possible with certain coordinate reference systems

I tried multiple times to load a CSV (CRS: EPSG 4647) into QGIS 3.4. While it works without problems in QGIS 2.x versions, there was no success loading it into QGIS 3.4 ('QGIS Madeira'). Do you have ...
1
vote
1answer
68 views

Inputting CSV in QGIS graphical modeler and defining its geometry [duplicate]

Is it possible to have a model in QGIS graphical modeller which accepts a CSV with geometry fields and then allows you to use them for the rest of the model as if it was a vector file? This is ...
1
vote
1answer
39 views

Trying to add lat long points to a map, not getting an ok button

I add "Data Source Manager" then "Delimited Text" and i select the x y and coordinate system but there is no OK button? just add and close add just restarts the process. how do i get the ok button?
1
vote
0answers
28 views

How can I make integers on a join SHP file stay as INT and not as qlonglong?

So I've been trying to join a CSV file with a polygon SHP file and everytime I try to save the joint SHP into a new file it transforms the type from int to qlonglong and prevents me from using some ...
2
votes
1answer
53 views

Volume calculation of CSV file

I have a CSV file with point cloud data of a terrain. How do I use QGIS to calculate the volume of the terrain? I tried using SAGA tool, natural neighbour, then use raster volume calculation. However,...
0
votes
0answers
154 views

CSV to GeoTIFF (Python)

Trying to convert a CSV file (3 columns: Lon, Lat, Ref) to .tif GeoTIFF (the Ref values) using gdal. Using Python 3.6, I am getting the error below. What am I doing wrong? C:\ProgramData\Anaconda2\...
1
vote
1answer
36 views

Conversion of CSV to DBF is getting error message, why?

My code import arcpy, os, shutil, re from arcpy import env arcpy.env.workspace = "R:\GIS_Data\Earthquake_Data\Updates\Eq_updates.mdb" path = r"R:\GIS_Data\Earthquake_Data\Updates" In_path = r"R:\...
0
votes
0answers
34 views

Write a script to create a new feature class and add the point objects of geometry to that feature class

The coordinates of the vertices representing the street Kochstraße in Erlangen are stored in a text file called Koord_Strasse.csv. Write a script to create a new feature class and add the point ...
0
votes
0answers
44 views

ArcMap fails to convert all records from CSV file using Table to Table geoprocessing tool

I am using the table to table geoprocessing tool to convert a CSV file with nearly 5 million records into an GDB table in a file geodatabase. The tool succeeds each time, but only 603 records are ...
3
votes
1answer
91 views

Importing from CSV and changing projection using ArcPy?

I'm attempting to convert CSV files to a group of shapefiles, then re-project them to a different coordinate system. The first conversion works, but I'm having issues with the projection piece. ...
0
votes
1answer
32 views

Exporting Polygons (RGB color bands) nto CSV

I have drawn ~40 polygons over NAIP imagery to collect their R, G, B color bands. I now want to export each polygon with its associated RGB color values into a CSV file so I can plot the polygons ...
2
votes
1answer
62 views

dbf to shp within BASH (ogr2ogr would be ideal)

I have a CSV with many points and attributes that I'm trying to convert into a shapefile but I'm having no luck. I have installed gdal-bin and can use my terminal environment to create a shapefile ...