[Qgis-user] Preserving geometry when batching joins

Nicolas Cadieux nicolas.cadieux at archeotec.ca
Mon May 28 08:15:29 PDT 2018


Hi,

Can you send me a sample of the files?  I have more options on my 
computer but is may be that I am not testing with a .csv.

Nicolas


On 2018-05-28 6:35 AM, Samuel Williams wrote:
> Bonjour Nicolas,
>
> Thanks for taking the time to answer my email.
> Unfortunately the only options that I have for saving the joined files 
> are all table based - see the screenshot that I have uploaded here:
>
> https://drive.google.com/file/d/1x0ADTag8xk85Ty3Vx6Wyb0FQCXfKDyBQ/view?usp=sharing 
> <https://link.getmailspring.com/link/1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6@getmailspring.com/0?redirect=https%3A%2F%2Fdrive.google.com%2Ffile%2Fd%2F1x0ADTag8xk85Ty3Vx6Wyb0FQCXfKDyBQ%2Fview%3Fusp%3Dsharing&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D>
>
> If I do the joins one by one, then yes it is easy to save the point 
> dataset as a shapefile after it has been joined with the csv file, but 
> I can't find a way of doing this in batch mode.
>
> Any suggestions?
>
> Thanks,
>
> Sam
>
>
>
>
>
> On May 28 2018, at 2:16 am, Nicolas Cadieux 
> <nicolas.cadieux at archeotec.ca> wrote:
>
>
>     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
>     <https://link.getmailspring.com/link/1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6@getmailspring.com/1?redirect=mailto%3Asam.williams%40sineenvironmental.com&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D>>
>     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
>         <https://link.getmailspring.com/link/1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6@getmailspring.com/2?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527454204.local-f62ddf4d-2b7e-v1.2.1-7e7447b6%40getmailspring.com%2F0%3Fredirect%3Dhttps%253A%252F%252Fgithub.com%252Fqgis%252FQGIS%252Ftree%252Frelease-2_18%26recipient%3DcWdpcy11c2VyQGxpc3RzLm9zZ2VvLm9yZw%253D%253D&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D>
>
>         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
>
>         Open Tracking
>
>         _______________________________________________
>         Qgis-user mailing list
>         Qgis-user at lists.osgeo.org
>         <https://link.getmailspring.com/link/1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6@getmailspring.com/3?redirect=mailto%3AQgis-user%40lists.osgeo.org&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D>
>         List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>         <https://link.getmailspring.com/link/1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6@getmailspring.com/4?redirect=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D>
>         Unsubscribe:
>         https://lists.osgeo.org/mailman/listinfo/qgis-user
>         <https://link.getmailspring.com/link/1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6@getmailspring.com/5?redirect=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D>
>
> Open Tracking 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180528/74298d1c/attachment.html>


More information about the Qgis-user mailing list