Questions tagged [csv]
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
1,398
questions
4
votes
1
answer
204
views
How can I use ogr2ogr to left join a CSV to a GPKG file and produce a GeoJSON output in a scalable way?
I have a large GPKG and a CSV file, and I'd like to (left) join the CSV to the GPKG on one of the columns. A visualisation of what I'm trying to achieve:
Reproducible example
We can create an example ...
- 2,224
0
votes
1
answer
82
views
CSV with Coordinates in QGIS [closed]
I want to upload a CSV in QGIS (add layer "Data source manager", "delimiter text"). Every time when I'm uploading the file it won't show me as a point layer.
What am I doing wrong?
0
votes
0
answers
28
views
QGIS calculated area output as CSV
I have used the graphical modeler to extract polygons. I calculate the areas of each polygon in the attribut table.
Since I have multiple layers, I do not want to use the function Field Statistic for ...
- 677
0
votes
1
answer
77
views
Overwriting hosted table in ArcGIS Online with CSV file from Pandas dataframe in Python
I have a script that I'm using to sort through a very large feature layer with thousands of records and create a summary table of them by type. It also calculates the count of records of the last 5 ...
0
votes
0
answers
33
views
Imported CSV files from Fieldmove and QGIS only displayed as lists
Downloaded some .csv data for an assignment I need to do (from fieldmove specifically), and am trying to display a single point for which i downloaded said data as a csv. file. However, when i try to ...
3
votes
1
answer
154
views
QGIS changes column headers and date time data after export
I have a csv that looks like this:
After I convert the csv to a shape file in QGIS, edit it in QGIS (clip), then export it as a csv, the output looks like this:
What do I need to do to reduce the ...
0
votes
0
answers
36
views
QGIS vector layer attribute table update using CSV - JOIN not working
I have an existing vector layer which I have added features to and updated the geometry existing features. The associated attribute table has 34 FIELDS (with 25 features). I'm trying to undertake a ...
- 1
-1
votes
1
answer
49
views
What is the convention when exporting point locations in a CSV? [closed]
When creating a CVS export which includes a point location, what is the most popular convention to export the data?
I can imagine a few ways
GEOJSON LON,LAT as string
"Lat,Lon"
Lat
Lon
&...
1
vote
1
answer
140
views
Cannot plot geometry on a CSV file (Python)
I'm trying to plot a data about Istanbul's metro lines. The actual data is in CSV format and all of the data is in string. The data is from Istanbul Metropolitan Municipality (https://data.ibb.gov.tr/...
- 25
0
votes
1
answer
69
views
Schema.ini file not being honored by ArcMap, string fields still being converted to numbers when importing CSV to GDB
I am trying to import a CSV to GDB using an ArcMap script tool and preserve some string fields that look like numbers as strings. I added some code to create and populate a schema.ini file in the CSV'...
0
votes
0
answers
37
views
Preserve string field type and leading zeros when using arcpy.conversion.TableToTable to go from CSV to GDB table? [duplicate]
I'm building an ArcMap script tool that will be run on many different input table schemas for geocoding purposes. When importing from CSV to GDB table using the arcpy.conversion.TableToTable function ...
0
votes
1
answer
92
views
Uploading CSV file without coordinates in QGIS
I am very much a QGIS beginner and want a vector layer of food deserts in England, but the only data I can find is in CSV format with no shapefile https://data.cdrc.ac.uk/dataset/e-food-desert-index.
...
- 9
-2
votes
4
answers
267
views
Merging features with same value in table (CSV) [closed]
I have a table (CSV) with statistical data for different neighbourhoods in a city (population according to different age categories).
My problem is that the neighbourhood doesn't have one field per ...
- 7
0
votes
1
answer
50
views
How to generate multi band raster map from CSV
I'm trying to generate a map from a CSV with percent land usages.
The CSV data looks something like the following:
Index x y l1 l2 l3 l4 l5 l6 l7 l8 l9 l10 l11 l12 l13 l14 l15 l16 l17 ...
- 127
0
votes
0
answers
62
views
Adding multiple CSV files to ArcGIS Pro all at same time
I have a folder of CSV files and I was told to add all of the CSV files at once into ArcGIS Pro. The CSV files are all formatted the same way, they include latitude, longitude, depth and time.
Is ...
