Questions tagged [csv]
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
3
votes
1answer
45 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
0answers
24 views
Select certain rows and columns from a CSV file in Python [on hold]
I have been trying to get this to work for a decent amount of time and I finally got it to print out the contents of the file but I can't get it to print out the 5 lines that I need out of a large, ...
-3
votes
0answers
27 views
Converting/exporting more than 60k shapefiles to CSV files? [duplicate]
I am using QGIS.
Is there any simple method to convert/export more than 60k shapefiles to CSV files?
0
votes
0answers
18 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 ...
0
votes
0answers
40 views
QGIS Girona 3.0.3 : CSV File and Georeferencing
I installed version 3.0.3 because I have to give lessons on this version but I meet several bugs compared to version 2.18.
I would like to import a csv file. I do not have an error message but my ...
2
votes
1answer
42 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
14 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
44 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
35 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
13 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 ...
1
vote
0answers
26 views
Can't find pcs, gcs, ellipsoid, datum and prime_meridian).csv [closed]
I try the tutorial for get dataset from raster map on gdal to display on console. It seem there some of the data not found. Just like in the pic below
Although, threre still assertion error but i ...
0
votes
0answers
22 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
57 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
104 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
49 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
0answers
12 views
Creating timeseries from csv file using ArcGIS Online?
Is it possible to create a time slider/time-aware layer from a csv file in Web Maps? (I could swear I've found a page saying so but I've gone through so many tabs and pages I have no clue)
My data ...
0
votes
1answer
30 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
48 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
0answers
22 views
Field types in ArcCatalog and ArcMap don't match
I am opening a .csv in ArcMap. In ArcCatalog when I open the properties I see that my first field is a text field (which is what I want) but when I open it in ArcMap the field is a double.
1) Why ...
0
votes
1answer
66 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
50 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
55 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
60 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 ...
0
votes
0answers
12 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
36 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
42 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
68 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
0answers
33 views
Is there a quick way to decode a batch of census block group numbers to create a geopoint?
I have a CSV file containing a list of census block group data numbers. Is there a way to process them quickly to create geopoints to map?
The first w_geocode and the second h_geocode column is what ...
0
votes
1answer
23 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
39 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
15 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
80 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
81 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
271 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
87 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 ...
0
votes
0answers
38 views
Using ArcMap add x y data, points are in wrong location [duplicate]
According to ArcGIS esri when I add a CSV with the "add XY" tool, * "The tool automatically adopts the data frame’s coordinate system"*. Since I'm importing a csv with no defined coordinate system, I ...
0
votes
1answer
46 views
QGIS: Loading a CSV of points as a line
I have a CSV file downloaded from a GPS tracking system. Every row contains lat, lon, timestamp, and row no. How can I load it into QGIS as a line layer?
2
votes
2answers
79 views
CSV Loading Problem in QGIS [closed]
I try to load a CSV file into QGIS. The file contains a list of points in decimal degree format without E, W, S, or N letters, like 35.876528, 045.982671.
When I add it as a delimited layer, it loads ...
4
votes
1answer
200 views
No “Save As…” in QGIS 3.2?
I have been trying to save my CSV file using the "Save As" from a right click as suggested on many websites, but I literally can't see this button. See my picture attached (on the left my QGIS 3.2 ...
2
votes
2answers
74 views
Load multiple csv files without defined x y headers
Initial Question Here Followed with Developments Below
I'm aware of the question posted here but my 120 csv files representing UK postcode centroids do not have x and y headers and dive straight into ...
1
vote
3answers
187 views
Importing CSV file to create point layer
I have a CSV file with following fields:
Nodename
Nodeid
Latitude
Longtitude
Elevation
I am using Python console in QGIS to automate this. How should I write so that point with latitude, ...
1
vote
0answers
41 views
Uneditable fields in attribute table
I have data in a .csv sheet that I imported as a vector layer into QGIS. I then joined the imported table with an existing .shp file. The fields that I joined into the .shp file are not editable (they ...
0
votes
0answers
31 views
Importing .CSV with coordinates in one row [duplicate]
I want to load in a series of lines (a survey grid) into QGIS.
The CSV file looks like this (only 2 lines plus headers shown):
Line # Name SOLE SOLN EOLE EOLN SOLKP EOLKP
1 01001-...
1
vote
1answer
54 views
Comparing a list from an arcpy search cursor to a list from a CSV file
I'm attempting to compare entries in a CSV file to entries in a geodatabase using a search cursor through arcpy.
I'm not sure if this is the best way to go about a comparison against these two ...
1
vote
1answer
40 views
Importing CSV matrix of z values to raster with no x y coordinates using ArcGIS Desktop?
I have a CSV file of depth values that have no spatial information. I know the "cell size" of the data but not where it should be put in space.
How do I convert this into a data format, such as tif, ...
3
votes
1answer
90 views
How to draw all possible lines between a set of points in QGIS?
I have a points layer in QGIS defined by a csv file in the following format:
group,name,lat,long
1,A,…,…
1,B,…,…
1,C,…,…
2,A,…,…
2,D,…,…
3,E,…,…
3,F,…,…
(lat and long are coordinates in WGS84)
How ...
1
vote
1answer
99 views
Export shapefile with column name of csv file or change column names afterwards
I am joining a .csv file with a shapefile in QGIS 2.18.12 and I need the column names for further processing (but they are way longer than 10 digits). However, when I save the new file, the column ...
2
votes
0answers
49 views
Add layer info to points, keeps failing in QGIS
Within QGIS, I am looking to get an extra column in the points file, describing in which layer the point lies.
All points are within 1 layer:
Layer source >SHP file from shapefile.zip.
Validate layer ...
2
votes
1answer
50 views
Can't get CSV to align with shapefile
Formatted this CSV data and tried to add it to an existing QGIS project and for the life of me can't get the data to align. Project reference is Illinois East NAD 83. Have tried that for the CSV layer ...
