Stack Exchange Network

Stack Exchange network consists of 174 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
0answers
24 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. ...
0
votes
1answer
22 views

Convert/translate EPSG:4326 to grid coordinates of a CSV file [closed]

I have EPSG:4326 coordinates and a file with cell coordinates either in CSV or shapefile. Each cell (500x500 meter) is described with EPSG:25832 coordinates of the South-West corner and the centre ...
1
vote
0answers
45 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
11 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
76 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
0answers
33 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
21 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
25 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 ...
0
votes
1answer
46 views

Importing CSV to shapefiles using loop?

EDIT - Code now runs correctly. I wasn't able to properly indent "arcpy.AddField_management" here for some reason; move it two spaces to the right if you use this code. I'm adapting this code to ...
1
vote
0answers
50 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
36 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
62 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
69 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
36 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
35 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
27 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
43 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
91 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
30 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
32 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
41 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
88 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
28 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
54 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 ...
0
votes
1answer
19 views

Asking user to select file in Python Script tool using parameter?

In a custom toolbox you can make a parameter and ask user for input where he can type something and used as arcpy.GetParameterAsText(0) in the script in the toolbox. This is good if you want to use ...
0
votes
1answer
47 views

Prevent ArcMap from adding field_X and field_Y fields to CSV?

I have a csv file that contains a field with an ID in a certain format that ArcMap seems to recognize as a coordinate (e.g. "11X355"). When I add it to a map in ArcMap 10.6, it automatically adds two ...
0
votes
1answer
41 views

Importing Google coordinates to QGIS but can't select X/Y field, because coordinates are shown in one row

I am new to QGIS. I am attempting to import CSV file with x/y coordinates into QGIS. When I add CSV file to delimited text layer all coordinates are shown in one row, so I can't select which one is X ...
0
votes
1answer
22 views

Reformatting Dictionary Object to rows and columns using Google Earth Engine?

I'm new to javascript & GEE, trying to reduce a global FeatureCollection by computing sums of two specific properties, grouped by country (using this helpful link). The output is a Dictionary ...
0
votes
0answers
33 views

How to plot points from a CSV file into a country polygon in Arcmap?

I am trying to import points, which contain longitude and latitude data, to a geographic area (polygon) in ArcMap but they are not overlapping. I have added a point layer (.csv) to my table of ...
-1
votes
1answer
76 views

Saving point layer as shapefile? [closed]

I am working with a layer created from a csv file, upload it by means of python. Now I need to save the layer that is loaded with the points like a ShapeFile. Do you know if this is possible and ...
0
votes
3answers
192 views

Convert CSV file in shapefile with pyshp/shapefile

I'm trying to convert a file.csv to a file.shp through the pyshp / shapefile module. The content of the CSV is: Lon,Lat,Vel,Dir 15.9576198620869825,41.1791119428255143,9.3949995040893555,92....
0
votes
1answer
128 views

Geopandas - Import CSV: make polygons from X,Y Coordinates based on ID

I'm working on a script, where I want to import a CSV file with coordinates and an ID which should be used to make a polygon shapefile from those. CSV file looks like this (example): ID, X, Y 10,15....
0
votes
1answer
35 views

Combining raster file with country boundaries into a .csv dataframe in R [closed]

I have a raster file from the FAO's Global Agro-ecological Zone database ( http://gaez.fao.org/Main.html#) which gives the yields of specific crops in 5' grid cells. I would like to assign a country ...
1
vote
1answer
50 views

999999 Generic Error when converting CSVs to dBase with TableToTable_conversion()

I am attempting to convert 5 fairly large CSV files into DBFs using ArcPy. My code is below. Currently when I run this script I am met with the following error: ExecuteError: ERROR 999999: Error ...
0
votes
1answer
166 views

Create time series and export it to csv GEE

I'm new to GEE and I'm trying to create time series of MODIS LST for a selected point. I first chose a point on the map and my script is: var POI = geometry; // Get temperature data for 1 year. var ...
1
vote
1answer
60 views

ArcMap keeps loading old CSV file after I've updated it

I have a CSV I'd like to join to a shapefile. I brought the CSV into ArcMap, realized it had an error, fixed it and saved the file with the same name. I removed the CSV from my map document, refreshed ...
1
vote
1answer
129 views

QGIS 3.2 - Forcing column type when importing csv

I've got this csv file that I'm trying to import to QGIS 3.2. It's just a data table with no geometry attached. When I just drag it from the Browser on the left-hand side, all the columns get ...
0
votes
1answer
101 views

QGIS heatmap issue

I'm trying to create a heatmap on QGIS 3 from a layer based on a 20,000-entry CSV file with longitude and latitude values, using EPSG:4326 as the CRS. The layer itself looks fine, the markers are ...
1
vote
0answers
15 views

Editing Specific Raster Cells Via CSV Values using GDAL?

I have a raster grid that I would like to modify. I am trying to manually edit specific raster cells' values via vales in a CSV file. My CSV contains three columns: VAL,LAT,LON 91.0,31.04250,-86....
0
votes
0answers
37 views

Why is Append_Management failing on just 2 (out of 9) table columns?

In Arc 10.2 I have a script tool that uses arcpy.Append_management() to transfer .csv data into a freshly truncated feature class table. It works perfectly on all .csv tables except one in which it ...
2
votes
1answer
72 views

Joining CSV file to Shp file using ogr2ogr and python

I am having problems with the code below i.e. parsing the SQL string in python. I keep getting an error. I am joining a CSV file called lookup_scales.csv to a shp file called RC_CATALOGUE_GRANTED. I ...
4
votes
3answers
84 views

Draw Bounds with coordinates in QGIS from CSV

I have a CSV file that contains 4 coordinates on each line, 1 min latitude, 1 max latitude, 1 min longitude and 1 max longitude. These 4 points delimit a particular region(they are the bounds) I would ...
0
votes
1answer
24 views

QGIS - Import transposed points coordinates/nodes as polygons

I'm attempting to streamline the process of importing polygons (19 in this case) from a website into QGIS. I extracted the JSON using chrome's dev tools and converted it into CSV spreadsheet here. The ...
1
vote
1answer
59 views

Appending list to column of a CSV file

There are 5 polygons in a shapefile. I am extracting the mean value of the NDVI pixel inside each polygon using "zonal statics as table". At this moment, I have 3 NDVI files, thus, I will get 3 sets ...
2
votes
0answers
94 views

ArcPy approach to add lat/long to CSV for multiple sets in one row [closed]

I have a CSV where each row contains 3 sets of coordinates in EPSG 32611 (UTM). I'd like to add columns that contain the coordinates in lat/long (EPSG 4326) also. So, columns H&I would be cols. B&...
1
vote
0answers
16 views

Apply Distance Buffer to Lat/Lon Points [duplicate]

I have a CSV with three columns: CSV Sample: lat,lon,fhr 25.5,-61.7,0 26.1,-63.2,6 26.7,-64.7,12 27.3,-66.2,18 28.2,-67.7,24 29.1,-69.3,30 30.1,-70.6,36 31.3,-71.6,42 32.5,-72.7,48 33.3,-73.9,54 34....
1
vote
1answer
105 views

Write array to CSV inside arc script tool (works in pycharm, doesn't work in arc)

I have an arcpy script in which I am writing an array to a CSV (for later use in the script to make a routeing layer). I've tried a couple iterations, and all work like a charm in PyCharm (can't ...
0
votes
2answers
161 views

Convert shapefile into lat long points and export it as CSV in R?

I have a shapefile that I extracted form a compilation of species distributions taken from IUCN. > foo Simple feature collection with 1 feature and 27 fields geometry type: MULTIPOLYGON dimension:...
3
votes
3answers
402 views

Converting CSV (polygon coordinates) to polygon feature class (shapefile)?

I have a CSV table as following : ID;POLYGON 1;(-7.59443,33.55933):(-7.59416,33.55937):(-7.59414,33.55922) 2;(-7.58361,33.56655):(-7.58148,33.56655):(-7.58148,33.56486):(-7.58361,33.56486) The ...
2
votes
3answers
92 views

Format .csv or .txt file so that the following stops happening?

I have a large dataset compiled of point data. Previously, this data was contained in 3 different files that all were successfully made into layers on QGIS, however I just combined them into one large ...