New answers tagged csv
Use Add delimited text layer instead of Add vector layer. It will recognize the lat/lon columns and create a point layer. Add vector layer uses GDAL to open files. If you want to open your CSV with this tool, follow the instructions in Reading CSV containing spatial information.
If I understand this correctly the yellow fields contain X and Y values, and all the other cells contain some other value like elevation? If I was you I'd convert the data to a text file following this general pattern: X-coordinate;Y-coordinate;elevation You can do this within with a formula like this: The upper table is my test data, with 11, 22, 33 ...
Ok, I have tried a few things now and this is the only work around I can come up with right now. I installed the XYtools plugin from the python plugin repository. I also installed the xlrd and xlwt python modules. From their I converted my csv file to xls using libreoffice calc. After installing XYtools you should see it in the vector operations menu and I ...
Without knowing your particular dataset, I can't say for sure what the issue might be, but I know I had a similar issue working with some smaller CSV files where it got part way through the CSV and then quit with an error. What I finally determined was that in one of the fields/columns most of the values were a single numeric value 1 - 9, but I found out ...
If your values are stored as integers, the leading zeroes are dropped. You can either make a schema.ini file, or add a new "string" field and calculate it with the appropriate field. There is also the option of right clicking the field -> number format -> custom -> and adding in your own zeroes.
You can put a schema.ini file in the same folder as your CSV file. In it define the fields you need leading zeros as text fields. http://msdn.microsoft.com/en-us/library/ms709353%28v=vs.85%29.aspx http://gisnuts.com/terra/blog/2012/06/14/using-the-schemaini-file-to-import-a-csv-file-into-arcgis
Top 50 recent answers are included