[Qgis-user] Preserving geometry when batching joins

Nicolas Cadieux nicolas.cadieux at archeotec.ca
Sun May 27 18:16:30 PDT 2018


Hi,
Once you have joined the geometry file to the matching attribute file, you should be able to save that as a shape file.  If you can’t figure it out, put a sample on the next email.
Nicolas

> Le 27 mai 2018 à 17:10, Samuel Williams <sam.williams at sineenvironmental.com> a écrit :
> 
> Hello,
> 
> I've hit a issue in Qgis that I'm struggling to resolve, and I'm hoping that someone might be able to point me in the right direction.
> 
> I have 12 point geometry data sets and 12 csv files. Each csv file contain the attributes for one of the point data sets - there are exactly the same number of records in each point / csv pair:
> 
> Points1.shp:
> -- point 1 UID
> -- point 2 UID
> ..
> -- point 980 UID
> 
> Attributes1.csv:
> -- record 1 (Point 1 UID, blah, blah, whatever)
> -- record 2 (Point 2 UID, blah, blah, whatever)
> ...
> -- record 980 (Point 980 UID, blah, blah, whatever)
> 
> I've loaded them all into Qgis and was hoping that I could join them as a batch process, so that I end up with 12 point geometry shapefiles, with each point associated with the equivalent record from the matching csv file.... I've had some success, in that the batch interface to join allows me to list the input layers, fields for the joins and the output file names very easily, but I can't work out how to preserve the geometry of the points. The only file type listed that I can save are DBF / XLSX / CSV / ODS files, which will only preserve the joined tables not the geometry.
> 
> Am I approaching this whole problem in the wrong way, or is there something very obvious that I've missed?
> 
> I'm using:
> QGIS version
> 2.18.17
> QGIS code branch
> Release 2.18
> Compiled against Qt
> 4.8.7
> Running against Qt
> 4.8.7
> Compiled against GDAL/OGR
> 2.2.3
> Running against GDAL/OGR
> 2.2.3
> Compiled against GEOS
> 3.6.2-CAPI-1.10.2
> Running against GEOS
> 3.6.2-CAPI-1.10.2 4d2925d6
> PostgreSQL Client Version
> 10.2 (Ubuntu 10.2-1)
> SpatiaLite Version
> 4.3.0a
> QWT Version
> 6.1.3
> PROJ.4 Version
> 493
> QScintilla2 Version
> 2.10.2
> This particular workstation is running Ubuntu 18.04 on amd64 hardware.
> 
> Any suggestions welcomed - I know that for just 12 data sets I could probably have done the joins manually in the time it has taken to type this out, but I'm really curious as to whether there is a better way.
> 
> Cheers,
> 
> Sam
> 
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180527/97e3810a/attachment.html>


More information about the Qgis-user mailing list