New answers tagged csv
In PYQGIS a shape file can be save as a .csv with coordinates by: QgsVectorFileWriter.writeAsVectorFormat(vlayer, "xy.csv", "utf-8", None, "CSV", layerOptions ='GEOMETRY=AS_WKT') This is not working in QGIS 2.2 but will work again in QGIS 2.4.
When you bring in a csv, Arc does its best to determine the appropriate field types and as you have found it doesn't always get it right. One solution is to use a schema.ini file (see bottom of page) to explicitly set the field types for your columns. There are several related (duplicate?) questions here on the GIS SE if you search for 'schema.ini'. More ...
I have arcgis 10 and I think you can not import CSV files into the geodatabase, much less save as .DBF. First, try to add to ArcMap, then export to geodatabase.
Verify that the field type of PCODE3 is the same as the field type of MUN_P_. You can't join fields with different types.
The Geometry export to CSV function of the MMQGIS plugin is the easiest way to get node and vertices coordinates of every vector layer.
Assuming the data is really DD MM SS you can just add the data as follows LAT,LON 42 46 05 N,86 12 04 E I use spaces to separate DD MM SS and I assume since numbers are positive N,E. Other ways may work but I find this the fastest for me at least since using special characters takes typing time
I recommend that you check whether you set the file format correctly in Add Delimited Text Layer.
This should be possible. But I have not tried it, so test it out first. In order to read a csv as a spatial file you need to create a .vrt file for it. So it can be loaded in virtually. So you need something like: <OGRVRTDataSource> <OGRVRTLayer name="codepoint"> <SrcDataSource>codepoint.csv</SrcDataSource> ...
Once the CSV has been joined to the Shapefile, use MMQGis > Modify > Text to Float to convert the appropriate columns
MMQGis caused this problem, and, as it turns out, it can fix it to. Once you've joined your Shapefile & CSV Data, use MMQGis's Modify > Text to Float tool. As usual, it leaves a trail of junk intermediate shapefiles but what else is new
Have you tried converting your csv table to a txt file instead? I have trouble with the csv format on occasion even in 10.2 so I always start first with a txt file, if possible. As for why it happens, I am not sure.
Top 50 recent answers are included