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

learn more… | top users | synonyms

2
votes
1answer
43 views

How do I rename rasters in an mxd by using my csv?

I have the following data in a csv: RasterName First name Raster 1 Aaron Raster 1 Paul Raster 2 Bryan Raster 3 Cranston Raster 3 Vince I have added these ...
2
votes
0answers
32 views

How to convert shp to csv

I am trying to convert my shape files to csv through a batch processing in Java using Geotools. The problem is I have more than 500 shape files (point features). The code is working fine for a small ...
0
votes
0answers
13 views

What is the workflow to add more records from CSV files to a point feature in Oracle Spatial?

We have some GPS data in CSVs to export to existing features in database schema. The CSVs have the same attributes columns, as that of the tables in ORACLE (missing objectIDs, geometry and globalID). ...
1
vote
0answers
34 views

Categorized style hiding map

I am having an issue with the style properties of my map. I imported the US Zip Code Tabulation Area map from a government website, and in a separate excel file I have a list of people connected to ...
2
votes
2answers
55 views

How to change precision on a column in the attribute table without losing data?

I have data in an Excel-file that I want to join with a shapefile in my project. The Excel-file contains values like volumes. The Excel-file and the shapefile I want to join it with both contain the ...
0
votes
0answers
28 views

Keep leading zeros when importing .csv into QGIS?

I'm having issues getting QGIS to retain leading zeros when I import a .csv file. I have zip codes I am trying to read in and I need the leading zeros. I am not super familiar with GIS, so please ...
1
vote
1answer
37 views

Replacing text string on layout text element by reading lookup value from table via SearchCursor?

I'm not sure what the best way is to go about this, but here's my situation: In short, I exported a domain to a table (and I exported the table as a CSV, too, just in case it might be easier to work ...
4
votes
1answer
82 views

Pulling CSV file directly from website into QGIS?

I want to be able to automatically update my csv files in a QGIS project. My organization has an online database that can easily export csv files. These csv files are constantly updated with new ...
1
vote
2answers
68 views

Exporting lists of Feature classes and fields from SDE

I'm using matt wilkies' arcplus module http://gis.stackexchange.com/a/5943/16793 to export a list of feature classes within an SDE database to a text file. I've also written a tool to write field ...
3
votes
2answers
165 views

Python script to export .csv tables from GDB

I am very new to Python programming and have been tasked with writing a program to export a csv file from a file geodatabase feature class. The csv should contain only certain fields and the records ...
1
vote
1answer
46 views

How to “lower the resolution” of a lat long csv

I have a csv with 12.5 million date/lat/long/value points, it's a point every 800 meters ( in a grid ) of the united states what's the best way to convert the points to every 1600 meters? or 3200? ...
3
votes
1answer
75 views

Join CSV using gdal/ogr

I'm trying to use gdal/ogr to join a shapefile called myshape.shp with a csv called mycsv.csv. The join field in the shape in joinshp and the join field in the csv is joincsv. I've found this command ...
1
vote
1answer
37 views

ArcMap 10.1 Crashing when using field calculator

I keep getting a serious error message when I try to use the field calculator. I've joined a .csv to my SDE feature class and am trying to set one of the columns equal to one of the columns from the ...
0
votes
2answers
62 views

Error while importing CSV File using PyQGIS

Currently I am trying to import a CSV file using the python extension in QGIS and I have run into a problem that I can not seem to solve. I am trying to do a basic import of a CSV file from a python ...
0
votes
0answers
19 views

convert csv file into grib2 format using wgrib2

I have used wgrib2 in terminal.And convert grib2 file into csv file to view content of grib2 file.my command is, wgrib2 CMC_naefs-geps-raw_ARAIN_SFC_0_latlon1p0x1p0_2014022012_P012_allmbrs.grb2 ...
2
votes
1answer
60 views

Is the csv handling in QGIS bugged?

I am using QGIS 2.4.0 and sadly it seems that QGIS imported csv files are somewhat bugged. I cannot use imported csv files the same way as shapefiles. It seems that sometimes it is easier to import ...
0
votes
1answer
39 views

Problems Joining CSV to Shpfile arcgis 9.3

So I have been trying to get this to work all day and have had no success. I am attempting to join a CSV file with a Shapefile. The CSV is from the Hud's location affordability portal ...
1
vote
2answers
34 views

Adding Rasters as Columns in Shapefile using ArcGIS for Desktop? [closed]

I am currently working on a research project in a lab, and I am fairly familiar with ArcGIS (I'm only in high school and have done some previous work using ArcGIS). I was asked to add 3 columns onto a ...
1
vote
1answer
54 views

Why does QGIS add decimals when a csv is saved as a shapefile?

When I save a csv as shapefile the fields with decimals are saved adding decimals, then the new table in some case has new values. Old Table (CSV) ALTURA ELI ALTURA ORT 1.94 39.6 -11.19 ...
1
vote
1answer
24 views

Writing list of feature classes with fields to one csv file per feature class?

I have a database with multiple feature classes. Now I extracted a list of feature classes and a list of fields. I figured out how to write the list of feature classes and the corresponding fields to ...
2
votes
1answer
49 views

gdal_grid with CSV file and VRT “No point geometry found on layer”

Given the following .vrt file which I manually created: <OGRVRTDataSource> <OGRVRTLayer name="DGM5_BE"> <SrcDataSource>DGM5_BE.txt</SrcDataSource> ...
0
votes
1answer
31 views

How to define which columns in a Spatialite database are the latitude and longitude?

I have imported a CSV containing points with coordinates specified in columns named Latitude and Longitude. How do tell spatialite that these columns are the coordinates of of my points?
0
votes
1answer
56 views

How to convert excel csv file to filled contour Google Earth Map?

I have a csv file http://www.geocities.ws/radar/data2.csv. The first column is latitude. The second column is lonitude. The third column is precipitation type. 5 represents freezing rain. 15 ...
3
votes
1answer
34 views

ogr2gui geojson to csv do not export coordinates

I tried to convert ogr2gui to convert geojson files to csv. The geojson file contains point data only. The resulting csv only contains attribute data, no coordinates. Is there a way to get the ...
1
vote
1answer
62 views

How to upload a csv file into esri map with coordinates and plot in an esri map

I have got a sample code to plot the points on an esri map using a csv file. But the csv file is maintained in a server, i'm unable to upload it from my local system.Please let me know how i can refer ...
1
vote
2answers
77 views

csv to shp python and formating a row

I´m doing a script to convert csv to shp, but I want to format one of the columns. It´s a string then I´d like to format like this a[8:10]+' / '+a[11:16]+' UTC' being a the value in the column. ...
1
vote
1answer
145 views

How to import .csv file to CartoDB using SQL?

How to import .csv file to CartoDB using SQL, the data given below : POINT | TOP_dm | BOTTOM_dm | X_RD | Y_RD 35AP7600 | 4418 | 4368 | 262053 | 467223 35AP7601 | ...
2
votes
3answers
88 views

Can QGIS merge CSV files with different colums? [closed]

I am trying to merge a month's worth of daily CSV files without using ArcGIS. Each file has ~25,000 entries so this is a high data load project. Sample data can be found here. Note that we are using ...
0
votes
0answers
25 views

Broken links after joining an .accdb with a .csv in ArcGIS 10.1

I have two sets of data: A "master" file of coordinates that has one row for each location, saved as a .csv file A table with information for each location but no coordinates, saved in an Access ...
0
votes
0answers
22 views

Import CSV limited to 20 records [duplicate]

I want to import data that I have on a csv file into QGis. Its basic data; point name, latitude, longitude. I have around 1200 records on the csv file. Surprisingly, when I import the data into QGis ...
3
votes
2answers
75 views

Efficient way to use a CSV to Define a Feature Class

I was provided an Excel Spreadsheet which had the definitions of fields for a feature class. There were several worksheets in the file, each containing field definitions for different feature ...
1
vote
2answers
90 views

How to draw a square from 2 coordinates?

I have a CSV file with the following output id, x min, y min, x max, y max, value 1 , 0 , 0 , 100 , 100 , 5 2 , 0, , 100 , 100 , 200 , 10 3 , 100 , 100 , 200 , 200 , 15 4 , 100 , 0 ...
1
vote
2answers
55 views

Min/Max values from a feature class

I am very rusty/inexperienced in python and I was hoping someone might be able to give me some pointers on this script. I would like to create a more compact script that prints min and max values of ...
0
votes
0answers
29 views

csv to INSPIRE gml problem in FME Desktop 2014

I have .csv file with id, name, lat, long and other. I just cannot make gml writer to write geometry tags. I mean something like . How can I read this things from my .cvs? What am I missing? fme is ...
0
votes
0answers
36 views

Producing latitude longitute coordinates in csv file based on place names on existing csv file

I have a code that takes the HTML code and extracts the table to put it in CSV file. I want to further take the place names inside csv file and add two columns that show lat and longitude. Here is ...
3
votes
2answers
172 views

Join a CSV file to shapefile using gdal/ogr?

I have a shapefile with several attributes, for example YEAR, COUNTY, and AREA. I also have a CSV file with more fields that I want in the shapefile, such as POPULATION. Both the shapefile and the CSV ...
0
votes
0answers
54 views

Batch join non-spatial csv to shape files

I have 173 point shape files from soil testing and 173 non spatial csv files with lab ressults (one csv for each shape file) that need joining. The files are located in a library with folders named ...
1
vote
1answer
47 views

Problem with QGIS 2.2 joins between shp and csv

Didn't see question like this asked, so... I've joined csv to shp file and everythings seems ok. I've modified attribute form so that fields from joined csv appears in there. So far so good- it's ...
0
votes
0answers
64 views

overpass-api: data export into csv-formate

update; perhaps we can do this like so: to use Perl for text-mangling - so we can use the XML::Simple module. here's an example of a little script to parse your XML: see the Code: #!/usr/bin/perl ...
1
vote
0answers
141 views

How do I convert a CSV of latitude/longitude coordinates with timestamps to a GPX tracklog?

Converting from a GPX track to CSV is easy, but I'm looking to go the other way. I have a table of point locations logged with a handheld GPS, with timestamps. I need to convert them to a GPX file ...
0
votes
1answer
57 views

How Do I Snap a CSV to a SHP Using ArcPy?

I'm a veteran Python programmer very new to ArcGIS. I'm trying to do what seems like it would be a simple operation in arcpy, but I don't think I know enough about the ArcGIS terminology to do more ...
4
votes
3answers
529 views

Bulk convert DBF to CSV in a folder ArcGIS 10.1 using Python

I would like to convert 1000 dbf files to CSV. All dbf files are in one folder and they have sequential names (S:\output_tables\tcb1.dbf, S:\output_tables\tcb2.dbf, S:\output_tables\tcb3.dbf, up to ...
1
vote
0answers
61 views

Why does GeoServer's GetFeature round my numbers, but only for outputFormat=CSV?

When I make a GetFeature request with outputFormat=CSV to my GeoServer v2.4.5 I'm finding that the floating point numbers in my returned data have been rounded. When I make the same request with ...
0
votes
1answer
121 views

Save as .csv with coordinates in both QGIS 2.2 and PyqGIS

These questions have been asked before, but since they are not answered I will try to pick up the ends here. 1) First, as stated here: QGIS 2.2 saving layer as CSV with GEOMETRY=AS_WKT not working ...
1
vote
0answers
16 views

Can QGIS2 refresh layers without the need to reclassify each layer individually?

I have a set of layers which I'd like to have refreshed each time I open QGIS2.2.0 (Windows 7). Each of 14 layers (polygons) is linked via a join to a csv file with no geometry. The layer displays a ...
1
vote
2answers
76 views

Change field map properties in ArcMap

I am trying to import csv files in ArcGIS to do a join. However, some of the fields are identified as double, some as long and some as long. Therefore the join results in bunch of columns with NULL ...
0
votes
1answer
71 views

Import non spatial data into SQL Server using ogr2ogr

I am trying to import a CSV files in to SQL Server 2012 using ogr2ogr. The spatial data imports without any problems, but I cannot work out why the non spatial tables fail. I can import the data using ...
0
votes
1answer
45 views

Trouble joining table in arcgis. Joining field is 'greyed out'

I'm trying to join a shape file with a excel file I converted into a CSV. I had done this before with the same shape file but with a different CSV but this time when I try to select the column it's ...
0
votes
0answers
68 views

Converting a CSV to shapefile [duplicate]

I am attempting to load a CSV file into Qgis and ultimately convert it into a shapefile. I used Layer->Delimited Text Layer but the only options are for points, WKT and no-geometry. Neither of ...
0
votes
1answer
53 views

why can't i export geometry data from a shapefile?

I saved the layer using "vector save as" box but even when adding GEOMETRY=AS_XY in the layer box, the csv only showed the id and no gemetry data.