Hot answers tagged

3

To create a point from CSV file in MapInfo, you need to do the following: Go to File -> Open Change the format of the file from (tab) to (csv) Select the CSV file that you want. This procedure will open CSV file as table not point. To plot the X,Y as point, go to Table -> Create Points Select the field that represents X coordinate and the field the ...


2

a) With the solution you use (Pyshp (shapefile), you need 1) to extract the fields of the csv file 2) to define the fields of the shapefile (w.field('Target','C',50)) 3) to construct the geometry from the lon et lat fields ( w.point(float(i['x']),float(i['y'])) (see CSV to Shapefile ) b) With Fiona, it is easier but you have the same problem of field ...


2

In your excel spreadsheet copy the column with the values in it, then using "paste special" select "values". If this doesn't work you can remove all unnecessary spaces in your excel sheet before saving as a csv and importing. To do this you can use the find and replace function: open find and replace, put a single space in the "Find what" box and nothing in ...


1

I would recommend using the CSV module, I find it an extremely useful module to know, especially with any kind of reporting that needs to be done. https://docs.python.org/2/library/csv.html I have made up this code, I don't have arcpy on my computer at home, so you will need to check if it works import csv import arcpy csvLocation = r'/desktop/test.csv' ...


1

Just for future reference because I was able to solve my problem: If you want to create a new spatialite layer without having changes in the attribute field names (e.g. upper case to lower case), then you need to change the layer option LAUNDER in the 'save as' option form to "NO". Now the new spatialite layer possesses exactly the same attribute field ...



Only top voted, non community-wiki answers of a minimum length are eligible