Tag Info

New answers tagged

0

QGis should be able to import this directly as an XYZ grid (under Raster) provided it meets the following (from the GDAL Manual): Those datasets are ASCII files with (at least) 3 columns, each line containing the X and Y coordinates of the center of the cell and the value of the cell. The spacing between each cell must be constant and no missing value is ...


1

I have run into a similar problem in the past. ArcGIS was importing columns as interger and truncating leading zeros. ArcGIS uses its own method of determining column types. I had to specifically tell ArcGIS that the attribute column was to be text by using a schema.ini file. This is the article I used to get started.


3

If you want to reproject data from one CRS to another, DO NOT simply change the CRS with Set CRS for Layer. This will NOT reproject any coordinates. So please change the CRS back to EPSG:4326 since that is the correct CRS for your lat/lon data. Instead, use Save As... to another file name and CRS. You might want to use ESRI Shapefile format, since CSV does ...


1

If you need to join csv to geometry file like shapefile (with attributes) in 1:N connection there is no simple way to do it as far as I am aware at this moment. One of the ways which I'm not going to describe in detail here is to import your csv as table into database together with your geometry features where you can do SQL queries and sure 1:N connections. ...


5

You don't want to export csv, you should Save as... the shapefile which you joined the csv to. If you export csv table (which was not loaded with points geometry), there won't be any geometry and thus no shapefile. So it should go like this: drag and drop shapefile and csv into QGIS Double click on shapefile in layers list, switch to joins tab join csv to ...


1

I found a solution. To date it does not seem possible to export the attribute table to a csv and keep the value relation at the same time. There is however a way of accomplish it by using a your SQL client. I just made a join between the Child and the Parent table to display the value instead of the numeric id number. Note: If you are working with *.shp ...


1

If anyone is still ever looking at this and are interested in scripting instead of batching, you can use the glob module in python to search through your directory that contains the .csv's, and then use one of the arc tools (feature class to feature class, copy features, etc.) as mentioned above. You can download the glob module for free, but I think it ...


1

Your .csv file is mis-formatted. From the documentation: Note: Many programs produce strange and occasionally perverse CSV files, so the file format is more a convention than a standard. Thus you might encounter some files that cannot be imported using this mechanism, and COPY might produce files that other programs cannot process. I don't know where ...


1

Have you tried using DELIMITER ','? COPY t00_import FROM 'C:\temp\CSV\Aberdeen City 9051_20150212_C_01.csv' DELIMITER ',' CSV; Also, might try naming the columns in the statement: COPY t00_import (column1,column2,etc...,column17) FROM 'C:\temp\\CSV\Aberdeen City 9051_20150212_C_01.csv' DELIMITER ',' CSV; Also, are any of your columns set to not allow ...


0

As suggested by @FelixIP you can pre-format your CSV to: Replace ND with 0.0. Replace NA with ridiculous -9999. Make sure 1st row in Excel contains numeric (if there is a number) with desirable decimal accuracy. then: When it comes to interpolation, select rows where CONCENTRATION <>-9999.


1

So I've found out what was it ! I added into the code a column with city names to add as labels on the map. But it only contain a small number of them, and Qgis probably don't like Null values that much... After replacing them with zeros the importation of the .xlsx files went smoothly ;) !



Top 50 recent answers are included