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

learn more… | top users | synonyms

0
votes
1answer
65 views

Trying to find Coordinate System for Dubai?

I have a CSV file to convert .shp. The X,Y values are like X -40219075 Y 200946341 This is somewhere in Dubai area. Can any one tell me what will be the coordinate system they used for this?
9
votes
4answers
559 views

How to reproject 500 CSV files efficiently and easily using QGIS?

I know, my question is similar to some old ones on this site. I've a lot of CSV files (geo coordinates) to import to qgis (and then to convert them), and the usual way is not the best way to do it (...
0
votes
0answers
6 views

Trouble with graduated symbols after joining shapefile with csv file Again [duplicate]

This question has already been asked: Trouble with graduated symbols after joining shapefile with csv file BUT I do not know how to create a csvt file? Having a lot of trouble with this. Is there ...
4
votes
1answer
54 views

QGIS - Import CSV column names as numbers

I want to import a CSV table (no geometry) to QGIS. The column names which are numbers (e.g. 2004) are not getting imported. This is my test CSV file: Name;Eigenschaft;2004;test derName;1;21;21 ...
2
votes
1answer
74 views

Creating a CSV with Irish Grid references and opening the points in QGIS

I have a load of Irish grid references that I need to create a map of in Ireland - any advice? Tried to input a couple of refs and open in Biological record tool thinking this would be simple but hey ...
0
votes
0answers
113 views

CartoDB data load from csv , geojson file error

I had installed CartoDB locally on my Ubuntu 12.04 and the installation was perfect. I can create dataset by CartoDB's GUI and able to visulaize data perfectly without any problem. But when i drag and ...
2
votes
1answer
72 views

CSV to Layer from a Delimited Text File in QGIS

enter image description hereI am importing a CSV file into QGIS using the official instructions on their page: http://www.qgistutorials.com/en/docs/importing_spreadsheets_csv.html. For some reason, ...
1
vote
2answers
91 views

Adding a csv layer in PyQGIS

I am trying to load a series of csv files as vectors in PyQGIS. I run this code to try to get the first one: uri='file://D:/Saved Stuff/gulags/1.40.csv?delimiter=;&yField=y&xField=x' layer = ...
1
vote
0answers
35 views

Adding multiple icons to a single csv layer

I am loading the NumberIcon1 image for every point added through the csv file, is it possible to loop through the images so that way they go in order like NumberIcon 2 for the second point in the csv ...
1
vote
0answers
274 views

Using Python to compute the distance, speed, and time between coordinates (lat/long) using haversine formula and print results within .csv

I have a .csv file with 10 columns. The first column is titled Distance_Between_Points, the second column is titled Time_Between_Points, and the third column is titled Speed_Between_Points and all ...
1
vote
0answers
360 views

MMQGIS Geocoding Error [closed]

I have a file with over 27,000 addresses, and I'm trying to geocode it using the OpenStreetMap/Nominatim web service via the MMQGIS plugin on QGIS 2.10. I keep getting an error after about 30 minutes ...
3
votes
1answer
159 views

Qgis: Export only some columns of the selected objects to CSV

I have a layer with a table containing several columns. If I right click on the layer --> Save as.. --> CSV and chose to only include my selection I get a nice CSV file with all columns for the ...
1
vote
0answers
167 views

PyQGIS export return blank .tif

I'm new to pyqgis and trying to bring up from the previous post with a little progress from the last (implemented debugging tool pdb) but now trying to export into a .tif file so that I can check on ...
1
vote
1answer
105 views

Importing CSV data with Coordinates in one column

I'm trying to import the Lat/Long coordinates from the "Location" field of a CSV from here :https://data.colorado.gov/Water/DWR-Water-Right-Net-Amounts/acsg-f33s Unfortunately the coordinates are in ...
1
vote
1answer
75 views

Export shapefile with “non standard” characters to csv and read in excel

Macbook air mid 2011 running OSX 10.10.5 QGIS 2.8.2 - Wien Excel 15.13.1 (O365) When I export a shapefile containing non-ascii characters to a csv file using QGIS (setting encoding to utf-8) and ...
0
votes
1answer
154 views

Importing updated CSV values to feature class fields?

Some time back I had a requirement to develop an automated method (Python) to update field values for a spatial points dataset in an Oracle 11g SDE database (exported to GDB for testing). Im Using Win ...
6
votes
3answers
523 views

How can I get ArcMap 10.2 to recognize a csv column as float and not int?

I am trying to show a .csv file (2 columns, 291 rows) in ArcMap 10.2 using Catalog window to drag the .csv file into ArcMap. The second column of the .csv is a floating point number (range is [0-1]), ...
1
vote
0answers
60 views

Populate empty attribute table from constantly growing CSV in QGIS

I have a Python script running that will generate a line feature from a point depending on a degree of rotation around that point. I have a non-spatial CSV setup to get fed this rotation data from ...
1
vote
3answers
98 views

QGIS, a simple way to enable colleagues access to tabular data?

This question may sound like it's a bit vague, but I think that lots of people seem to face similar issues, and on this occasion a general answer seems better than a specific focused one: I use QGIS....
1
vote
1answer
89 views

QGIS delimited text import CRS not being defined

I've recently updated to both the long term release and 2.10 versions of QGIS and the delimited text plugin has stopped working. Everytime I try to add a CSV file and say ok on the plugin it no ...
1
vote
1answer
119 views

Add date field to imported csv file

I am using a script written by John to import a csv file and make a point feature class. My table looks like this: "timestamp_pretty","mmsi","imo","shipType","lat","long","month","week" "31/12/1969 ...
0
votes
2answers
161 views

QGIS 2.10, csv points to vector grid

I have a series of point data from a .csv file that I would like to display as a heatmap raster, the .csv data have various attributes with them and I would like to adjust the color ramp based on ...
0
votes
0answers
39 views

multiple attributes in csv file to raster

I have a several large comma separated text files each with multiple attributes. Each text file is about ~2.9 GB with 21 million lines. Each line contains X, Y, VALUE1, VALUE2, VALUE3, etc. The X and ...
1
vote
1answer
25 views

Trying to create colour co-ordinated values on a map from data from a csv. file

I have a list of values for some data recorded via Magnetic susceptibility, I have these in a shapefile and want to try creating a colour map out of the values. The values that I'm using relate to, ...
0
votes
1answer
47 views

arcpy.da.SearchCursor, cannot read preceding zeros from csv

I'm using arcpy.da.SearchCursor to read a csv that has a column with preceding zeros, e.g.: myCSVColumn 0124578 12598 04589 012568 ... When using the arcpy.da.SearchCursor it returns the value w/o ...
2
votes
1answer
195 views

QGIS Reprojecting csv point file to projected CRS

This is a problem I have been struggling with quite a bit and so far have not found a good solution, so I hope to find some help here or an eyeopener where I have gone wrong so far. Using QGIS 2.10.1 ...
2
votes
0answers
182 views

Qgis delimited text layer from an excel file converted to .csv

I'm trying to add a delimited text layer using coordinates. The file has been created in excel and then converted to a csv file in the saving. When I put it into Qgis it doesn't recognise the headings-...
3
votes
2answers
378 views

Exporting .csv file as .shp in QGIS?

I am a newbie to QGIS. Here's what I'm trying to achieve: Step 1: Load the required GIS layer (*.shp file) Step 2: Load the .csv file in QGIS Step 3: Perform the join based on common attributes ...
1
vote
0answers
82 views

Inputting Longitude and Latitude in CSV from Geotagged, Photo Coordinates (WGS 84)

I am trying to take Geotagged picture coordinates and put them into a CSV file to display in QGIS as point values. Using Picasa, I can see that the picture coordinates are in the correct locations on ...
1
vote
0answers
79 views

CSV file locked for editing after join

I have created a table join between a vector shape-file and a csv file using pyQgs. Now i want to edit the csv file (not from inside QGIS) . But when i double click on the csv file , it says that ...
1
vote
1answer
58 views

QGIS export attribute table to csv and keep value relation

If i export my joined table to csv i get the numeric id value instead of the value relation name from the joined table. Can I export my table with the value relation value? Best regards
0
votes
2answers
404 views

How can I import a csv file with varying numbers of values per row into postgres?

I am trying to import a csv file into postgres using this statement: COPY T00_import FROM E'C:\\temp\\CSV\\Aberdeen City 9051_20150212_C_01.csv' CSV; The Table T00_import is a simple table with 17 ...
1
vote
0answers
14 views

clustering categorized data

I don't know so much GIS specific terminology, so I am sorry for using the wrong words. I'll try to make my point clear by first describing what I want to achieve and then what I tried. [goal] I am ...
3
votes
1answer
125 views

Importing analytical data (CSV) with different data types into ArcGIS Desktop to generate concentration heat maps?

After reviewing all the possible related solutions to my problem, I could not piece together a solution to process and import multiple sets of groundwater analytical data that contains different data ...
1
vote
1answer
95 views

How to read non-spatial data using PyQgis?

I'm generating maps with QGis. What I do is generate a bunch of non-spatial data on a set of cities (using VBA), and still using VBA, generate a python code that will automaticaly output general map ...
0
votes
1answer
208 views

convert gdb to csv in batches

I have 88 gdb files on Arcmap that I need to export to csv format. Is it possible to do this in batches? maybe, without using the python window
0
votes
0answers
65 views

Assigning one-to-many polygon to .csv data in ArcGIS for Desktop?

So I am currently working with two separate files. One is a polygon feature class detailing a specific countries' subdistricts. These subdistricts are identified using a specific alpha-numeric code. ...
1
vote
0answers
63 views

Visualizing geo count data points in gradual colors using ArcGIS desktop?

I have data looking like the following: Latitude Longitude Class 35.773444 -78.6305752 0 38.82349688 -77.61919194 1 41.4985021 -81.7144364 1 39.9528 -75.2104 0 Longitude, latitude and ...
2
votes
1answer
161 views

FME Proccess to merge two CSV files not working

I am trying to merge two datasets of golfcourse data with almost similar information. my end goal is to have all the data into one csv file that have merged information from both csv files. I have ...
2
votes
0answers
90 views

How to show csv data point in Arcgis

I have sought and tried many tutorials and documents without success. I have arcgis desktop 10.2.2 installed. I have added a US map as a layer. Then I do the following hoping to display all (2000+) ...
0
votes
1answer
108 views

How can you publish a CSV as feature layer when creating a feature class in ArcGIS online?

According to ESRI's instructions, one is supposed to place a check mark next to a box which states "publish this file as a feature layer."However, this check box does not appear anywhere in the "Item ...
0
votes
1answer
54 views

Arcgis featureset to kml client side

I want to convert a js feature set retrieved from a geoprocessing service to a kml client side, and perhaps also to a csv (i have the object from the JS API). Is there any way do this? To clarify: ...
1
vote
1answer
260 views

How to read GeoCSV with OGR?

I have a GeoCSV file which stores the geometry in a WKT formatted cell following this recommendation: "identifier","date","geom","value" "Dgf01","15.04.2013","POINT (52.404869 13.147457)","285" "...
1
vote
0answers
40 views

Script for batch-clipping or masking rasters in R

I need a script that can do following batch process for all files in a folder: a) Clip or mask each raster layer (LAI product from MODIS MCD15A3) with a vector layer (vegetation types obtained from ...
1
vote
1answer
43 views

Importing Edge List into QGIS?

I have a CSV edge list such as follows: Lat1,Lon1,Lat2,Lon2 93.41823,-104.324324,93.41828,-104.324320 93.40110,-104.310552,93.40108,-104.310557 ... Is there a way to import such a CSV file into ...
1
vote
2answers
188 views

Export feature classes in geodatabase to CSVs

I am trying to export feature classes within a geodatabase to CSV format using "Export Feature Attribute to ASCII" in ArCGIS. I am getting the following error Traceback (most recent call last): ...
2
votes
1answer
79 views

QGIS TimeManager with multiple features at one time?

Since the data I have to deal with is really large, it is not practical to separate every feature into one line in the CSV file. Is there any way to animate them as a whole layer? I have ...
1
vote
1answer
334 views

Is it possible to use non-printable characters as delimiter for text file layer in QGIS?

I am trying to import a Delimited Text File Layer from a .csv file in QGIS. Because this caused a lot of errors, I posted a question here and got the hint towards using ASCII non-printable control ...
1
vote
1answer
82 views

Geoserver CSV - changing the default comma separator

I would like to know if it is possible to change the default comma separator CSV exportation in Geoserver using semicolon i.e. as a separator. Some of the tables that I published have large text ...
3
votes
2answers
303 views

Understand QGIS errors when importing .csv file

I am trying to import a .csv file as a layer in QGIS and keep getting a number of errors that I don't understand. Is there any documentation of QGIS errors available? Or can you point me towards a ...