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

learn more… | top users | synonyms

2
votes
1answer
29 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
51 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
20 views

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

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
34 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 ...
0
votes
1answer
16 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
57 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
49 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
36 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
25 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
0answers
24 views

Help how to return values from multiple columns to dictionary [migrated]

can anyone help with how to call additional columns to my dict below please? The example works fine for the return of one set of values (column) but I need to return values for 2 columns that are not ...
0
votes
0answers
113 views

Help with python, import update csv values to feature class fields

I am trying to update a bunch of field values from a csv file where there are existing (incorrect) values in my featureclass. After searching I came across a similar post (Help with Python Update ...
0
votes
1answer
29 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 ...
2
votes
0answers
49 views

Converting csv that it can be displayed

I have this Excel sheet here (far to right side there is a box where the file can be downloaded, the very first one). http://www.bafg.de/GRDC/EN/02_srvcs/21_tmsrs/211_ctlgs/catalogues_node.html Im ...
-1
votes
2answers
73 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
36 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
63 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
29 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 ...
0
votes
1answer
26 views

CartoDB import defaults to string

When uploading CSV files to CartoDB through their web interface, all columns default to string as their data type, despite the CSV file containing a number of number-only columns. An example row is ...
0
votes
0answers
17 views

QGIS Import WKB csv file

I have a csv with a unique field that are the coordinates of thousands of points but in WKB format. How can I import all the features into QGIS? CSV file is like this: ...
0
votes
1answer
99 views

Cannot convert csv file into point shapefile using ArcGIS for Desktop?

I can import my large csv file into ArcGis Desktop and I can view it in Catalog and everything looks fine. When I go to 'create feature class' it does not recognize the column that I need to use for ...
3
votes
3answers
108 views

QGIS won't read table columns in CSV import on Mac OS

I am trying to import a CSV file to QGIS, but it ends up looking like my print screen below (program is in Swedish but in the preview window you can how QGIS won't read my data correctly). I can't ...
2
votes
1answer
71 views

QGIS 2.6 How to create a shapefile from an excel file?

I am using QGIS 2.6.1 and have worked in an Excel file database (which was actually converted from a Shape-File). I have managed to convert it as CSV file and load it into QGIS (displays data fine) ...
1
vote
2answers
61 views

Load multi CSV files from local disc to Postgres

I want to load a lot of CSV files from a local disc in an already created postgres database. Which is the easiest way to do that? By using SQL or Java? I suppose that I need a loop for doing that, but ...
0
votes
0answers
51 views

Getting coordinates from random directions

This is an odd question, but was wanting to know if there was a way to get coordinates from random directions. I have about 2000 directions in a spreadsheet column. There is name and a few other ...
1
vote
0answers
25 views

In QGIS, how do I limit decimal places in data I imported as .CSV and joined to a shapefile? [duplicate]

I am importing a csv into QGIS 2.4 with a csvt file that specifies for percent columns Real(2.1) to limit it to 1 decimal place. It imports fine. When I join it to a shapefile, it looks fine. But when ...
2
votes
2answers
54 views

In QGIS how do I edit/save data which has no geometries?

In QGIS I can import data tables (CSV in particular) which have no inherent geometry (and no lat/lon columns) into QGIS. There doesn't seem to be any obvious way to manipulate that data (edit/save). ...
1
vote
1answer
47 views

How to add neighborhood names from shp to csv data points QGIS

I'd like to add the neighborhoods listed in a shp file to the data points in a csv Link to shp Link to csv Here are the data points overlaid on the shapefile map of the neighborhoods. I'd like ...
2
votes
2answers
155 views

How to load a data table as a 'vector layer' using PyQGIS?

This might be a simple problem, but how does one load a simple two column CSV with no associated geometric data? I have given a couple go's via QgsVectorlayer[delimited text, spatialite] types - but ...
0
votes
1answer
207 views

Loading Multiple CSV Files into PostgreSQL Table

I am having multiple CSV files. Those CSV files are the log files created as a result of running a windows batch file. The location of these CSV files lies on the server and i want all these CSV files ...
1
vote
1answer
83 views

How to convert total station data (coordinates) to 3D model? [closed]

i have my coordinates in .csv format and i want to convert it to a usable 3D model. How do i go about this or what software can i use to achieve this?
1
vote
1answer
109 views

Displaying real-time CSV data in OpenLayers 3?

is there a good way to display real-time csv data with OpenLayers 3? ...
1
vote
0answers
43 views

Geoserver WFS 2.0 CSV Output Multiple Features/typeNames

I'm setting up an export function so that users may download data from a Geoserver WFS 2.0 service in a variety of the supported formats. The service has multiple FeatureTypes which should be ...
1
vote
2answers
39 views

Including js file in openlayer.js file

I have this code for showing markers on map: function addUserLayerCSV(){ layer1 = new OpenLayers.Layer.Vector("CSV", { projection: epsg6316, strategies: [new ...
1
vote
2answers
97 views

Showing csv file on map

Does OpenLayers support the uploading and rendering of CSV files? If it does, how? I used this code and it didn't help. var curLayer = new OpenLayers.Layer.Vector("layer", { protocol: new ...
2
votes
0answers
45 views

Is there a QGIS alternative for ArcMap's Append (to Shapefile) Data management tool?

Is there something out there for QGIS that is similar to the Append Tool in ArcMap? Reason I am looking: I am currently working on a storm drainage project that involves GPSing Storm drain lids. My ...
0
votes
2answers
30 views

Why won't my csv file imported as a vector layer have attribute table headers?

I have a .csv file that has unique identifiers that I'd like to join with some legislative district shapefiles in QGIS. I've done this before, and the joins all worked fine -- and technically it still ...
2
votes
0answers
63 views

Via PyQgis how to refresh a modified CSV layer without having to reopen the file? [duplicate]

UPDATED: With an CSV layer Qgis workspace [loaded as a delimited text layer], an external algorithm is ran; outputting (writing) new values to certain rows in the layers source CSV file. The writing ...
1
vote
2answers
84 views

Extracting/Exporting coordinates from polygons (shape) to text?

Is there any well working way to extract the X and Y coordinates of a polygon from shapefile to some sort of text (preferably csv)? The whole process should be somehow done automated through a ...
1
vote
3answers
206 views

convert csv to kml or geojson, etc using ogr2ogr or equivalent command line tools (use “latitude” and “longitude” attributes for coordinates)

I've just unsuccessfully tried to use ogr2ogr to convert CSV into KML like so: ogr2ogr -f "KML" output.kml input.csv The csv has "latitude" and "longitude" columns. The attributes are all loaded ...
0
votes
1answer
50 views

csv data into an .xml Workspace Document to import into my geodatabase?

I'm looking to import data into my geodatabase from an .xml file using the import XML workspace document utility that comes from right clicking the geodatabase in ArcCatalog . Only problem is my ...
1
vote
0answers
61 views

Importing csv file in QGIS including names and description [closed]

I'm just getting to learn QGIS. I want to make a map (Google maps) where I can map all our customers from our database. Including names and even better: description, address, telephone, etc. All this ...
3
votes
2answers
149 views

How to output coordinates from a shapefile to a GMT or CSV file in QGIS?

I want to get the coordinates for a line shapefile as csv or gmt files. I click create "new layer" - "new shapefile layer" - I check the "line" box and then "OK". Then I make my shapefile. When I ...
2
votes
1answer
70 views

How to use a csv file to add values to a value map?

I'm trying to populate a value map in the edit widget with some values from a csv file. Could anyone let me know what format the csv file has to be in? At the moment I have just a list of ...
1
vote
0answers
37 views

Can't get pyshp to work when converting csv to point file [closed]

I've been hammering at it for ages, but I just can't get pyshp to work. The csv file looks like this: lon,lat -122.5163113, 45.55324148 -95.1719409, 29.97979461 153.0072888, -27.45988559 etc, ...
1
vote
0answers
24 views

Columns decimalLatitude and decimalLongitud not recognized while creating a layer from a csv file in QGIS

I'm using QGIS 2.0.1 Dufour to create a layer from a csv file. When I try to define the geometry and assign the x y coordinates sources, I'd expect QGIS to recognize the decimalLongitud and ...
0
votes
2answers
70 views

send csv with polygon or line in gps data

I want to send a csv with a polygon or line to show it in cartoDB map but when I try to send data to the server I don´t know the exact way to send the info. for polygon some think like this. ...
2
votes
1answer
150 views

From CSV file (latitude and longitude fields) to point .shp

How i create a new point shapefile from CSV table? If i have a CSV file with a latitude and longitude fields, is there a method for to have in output a puntal shapefile?
1
vote
2answers
34 views

Making data joined from Excel independent in ArcMap? [duplicate]

I have joined some data from Excel (.csv) "text" to my attributes table of one feature class. However I can't edit it. I found out it is still connected to Excel file from where I added it, and I need ...
0
votes
0answers
40 views

AutoCad Line generation from csv script

I have the coordinates of a start point, from that start point I captured the angles from a traverse boundary and distances to multiple other points. How can I set up a csv file that when I run in ...
1
vote
0answers
26 views

Region partitions (shapefiles) comparison in ArcMap 10

I have 2 shapefiles, in each file the region is divided into zones. Each zone from 1st ("large") file is "almost" a union of a few zones from 2nd ("small") file. Specifically, for each union in ...