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

learn more… | top users | synonyms

1
vote
1answer
11 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
34 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
36 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
18 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
56 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
59 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
23 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
17 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
30 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
16 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
26 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
64 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
40 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
58 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
0answers
27 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
104 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 ...
1
vote
0answers
37 views

geocoding CSV using MMQGIS and error massage

While geocoding a csv file using MMQGIS utility in QGIS, I provide an input and the follwing errror message pops out, what could be the problem?
1
vote
1answer
49 views

Is it possible to change data (attributes) in the .csv of a data vector layer and QGIS automatically adopt this?

I have a .csv with data for 300 points: Each column on the .csv is a particular object and the cells define the amount that is available in each point. If I need to change this amount, is it possible ...
1
vote
1answer
34 views

why the values are NULL if I join the csv table to a point shp file [closed]

So my problem is all values are NULL if I join my csv-table to a point-shape-file. (QGIS) Why? I tried so much thing but I can not find and handle the problem. I have customer names in the csv, ...
1
vote
1answer
63 views

CSV to ArcGIS table, insufficient text field length

I currently use arcpy.TableToTable_conversion in order to convert a CSV file into an ArcGIS file geodatabase table. This works when string length is less than or equal to 255 characters. Whenever 255 ...
3
votes
2answers
39 views

Coordinate formatting for swath data - to polygon

I've got a CSV of Lidar coverage swaths in the below format. Each run or strip is tied together via run_id. I'm assuming L is for left, R is for right and M is for middle. EDIT: These are coordinates ...
0
votes
0answers
22 views

Adding .CSV file

When I add my file to ArcGis SandBox it shows the data from CSV file to Layer . But when I try to Add it through ArcGis API For JavaScript it doesn't work.I'm working on localhost. Help!!! ...
0
votes
1answer
112 views

Leaflet map - custom markers from CSV and referring to CSV / GeoJSON marker properties?

I run a non-profit online resource called the Megalithic Portal and have created a Leaflet map that uses Leaflet.geoCSV to load in points from a CSV file github.com/joker-x/Leaflet.geoCSV To see ...
0
votes
0answers
6 views

Not able to use Find by Layer feature in ArcGIS Online, when data is url .csv?

In AGOL, when using Layers linked with a url to a .csv, the 'Find' by layer feature in the Details/Edits section is not active. Meaning that layers cannot be searched using the 'Find' feature. Is it ...
0
votes
0answers
36 views

Converting lat,lon & solar data in CSV to raster using Python?

I have a csv file with lat,lon and solar radiation data. I am trying to convert it to a grid/raster format so that it can be used with a raster population data set that is in ascii format. How can ...
1
vote
0answers
47 views

Creating a single layer of polygons from a point layer

I have a csv file of lats and lons for points that represent the vertices of parcels of land. I want to create a polygon for each set of specific points within the csv and then create one unified ...
1
vote
1answer
53 views

Export attribute table values to CSV

I am getting false parsing and un-necessary quotes for 3 numeric fields when exporting table to ascii (CSV). Items are all DOUBLE. "675,654","5,567,000" is the resulting export format which should be ...
1
vote
0answers
27 views

Discrepancy between importing same data from CSV and GPS [closed]

I have been importing similar data by using two different methods: Entering the coordinates manually in excel and save as CSV, then importing in QGIS through delimited text layer. Column A is name, ...
3
votes
1answer
41 views

Exporting BNG coordinates from MapInfo (27700) without rounding

I have a TAB file in ESPG 27700 projection and MapInfo is rounding Y coordinate values upon export. It also occurs when viewing the table (although selecting the value shows its 'true' form) Upon ...
2
votes
1answer
101 views

Importing CSV file with csvt data in QGIS (2.8) will not assign type “date” to fields

I have a dataset (in CSV) and am trying to add several fields with date information, so I can filter points based on this data and generate maps (in QGIS 2.8) which will form a chronological series. ...
0
votes
0answers
59 views

How can I use a csv file with coordinates and multiple attributes to extract interpolated values for a different set of coordinates in ArcGIS?

I have a .cvs file of 501 rows that correspond to 500 coordinate points, with each row consisting of latitude, longitude for a single location, followed by a list of about 100 weather attributes ...
2
votes
0answers
43 views

Standard for geospatial CSV with either lat/lon or region encoding

I'm tasked with finding a standard for data providers to publish data that is linked to either points (lat/lons), postcodes, or local government areas (Australian term for councils). The data will be ...
1
vote
1answer
27 views

Alternatives to GeoRSS for time-sensitive point data

I'm looking for a suitable data format for various organisations to publish point data with a recent time component, like events, road closures, etc. GeoRSS is the obvious candidate but: It's XML, ...
3
votes
1answer
63 views

ogr2ogr postgres import: check if dataset exists

I have a PostGIS database which I update daily with ogr2ogr using CSV files. This works great. Is there a way to check whether the actual value of a column already exists in the table (e.g. ...
2
votes
1answer
55 views

Exporting coordinates of shapefile into CSV using FME?

I use FME to make a series of transformations from an autocad file to a shape file (with line geometry). What I am trying to do is to also export (together with the shape file) a CSV file containing ...
11
votes
4answers
1k views

How to model a graveyard - one point per deceased or one per grave? [closed]

This is a continuation of my previous question about our project on how to economically get away with the implementaion of a graveyard in a GIS system… On the graveyard we can find Regular ...
2
votes
1answer
78 views

How to merge/combine several tables in geodatabase into one table using ModelBuilder?

I have over 50 csv files that have the same data structure and I need to merge them into one table. As I need to build a model I have successfully imported all the files into a File Geodatabase. ...
1
vote
2answers
116 views

How to overlay a Lat/Long CSV and NAD83 Shapefile in QGIS?

For reference I am new (as in a few hours of messing around) to GIS. I have a shape file/accompany projection files ect: CURRENT.prj CURRENT.shx CURRENT.shp CURRENT.dbf CURRENT.sbx CURRENT.sbn I ...
2
votes
0answers
22 views

Black map after attempt to style by column in QGIS [closed]

I'm very new to QGIS and I'd really appreciate some guidance. I have a shapefile of NYC census tracts and 2 csv info files with tract info joined with it. I'm trying to style the individual tracts to ...
1
vote
1answer
52 views

Exporting shapefile to csv with cursor

I'm trying to export a shapefile to a csv file using a cursor. I found this quesion asked and answered here: Exporting table to XYZ ASCII file via ArcPy? However I only want to export several ...
1
vote
2answers
176 views

Leafletjs : combine location data in geoJSON/KML/GPX with other information in CSV through key field

I've been able to load CSV having lat-long co-ordinates into leaflet using this useful solution. Looking for ways to cross-link co-ordinates from a different source and data from another. Describing ...
0
votes
0answers
75 views

Not matching schema problems when appending a list of CSV's into an existing FGDB table

So far I have the following code for creating the FGDB table and defining fields which works just fine. But when I try to append a list of csv's to this table I always get a matching schema error. Do ...
1
vote
1answer
141 views

How can I geocode CSV by postcode, using existing point data, in QGIS?

I have a very simple MapInfo workflow for geocoding a CSV file which contains UK postcodes, based on an SQL select query referring to point data for postcodes. This is simple. Using Mapinfo open the ...
1
vote
1answer
60 views

Rewriting csv file for QGIS

So, I have a .csv file. Here an example how the a row from the original .csv looks like: "AREA",44.37,-00.83,"5","1","8","E","E",,,"KKI","KKO" Some lines have missing latitudes and longitudes, ...
0
votes
0answers
29 views

Extracting single area with multiple layers from two different data sources

I'm very new to GIS, but I have a relatively simple project that seems almost too easy for this forum but I have been searching for an answer and no luck. I am using ArcMap. I have a state map of ...
0
votes
1answer
50 views

ogr2ogr Spatialite to csv very slow

I am using ogr2ogr to extract point data from a Spatialite db to a csv file:- ogr2ogr -f "CSV" commandtmp.csv dtm2.sqlite -lco GEOMETRY=AS_XYZ -progress -explodecollections the Spatialite db is 7GB ...
-1
votes
2answers
109 views

Displaying XY coordinates from csv file

I have a csv file which I created from a SQLite3 database. I want to display the points from the csv in QGis - which does not work. My coordinates are Lat/Long. They get displayed completely wrong. ...
0
votes
1answer
45 views

Import CSV to QGIS with z-values in column 4

I would like to import CSV into QGIS, but the z-values are listed in column 4. I didn't find out how I could specify that the values are not in column 3 but in column 4. Edit: Added a screenshot
1
vote
1answer
111 views

Copy Features tool run after Make XY Event Layer on CSV file fails to complete?

Using the Make XY Event Layer tool I converted a table to a layer. I am trying to convert the newly created layer to a feature class in my file geodatabase. I have been able to do this in ...
0
votes
1answer
49 views

Plotting a list of towns in google maps or CartoDB

is there a way to plot a big (700) list of towns on google maps. I don't have any geographic reference, just their names in a .csv file. I've tried uploading using their help pages but it just seems ...