[Qgis-user] Preserving geometry when batching joins

Tue May 29 08:16:34 PDT 2018

Thanks, I'll check out QGIS 3!

On Tue, 29 May 2018, 16:00 Nicolas Cadieux, <nicolas.cadieux at archeotec.ca>
wrote:

> Hi,
>
> It appears that the join attributes table found in the 2.18 processing
> joins tables but not like the "Joins" found in the layer property.  You are
> right, there is no option to save as a shp file!!!!! Only database
> formats.
>
> Your best option is to use the field calculator in the point shp file and
> to create a new column with the geometries x and y.   Then you can join the
> table and save as a csv.  Then, reimport the csv and use the x and y to
> recreate the points geometry.
>
> OR
>
> The problem is solved by using Qgis 3 where you can save as a .shp.
>
> Nicolas
>
>
>
>
> On 2018-05-28 1:44 PM, Samuel Williams wrote:
>
> Hi Nicolas,
>
> Thanks! Here are two matching files - I would be interested to know if it
> gives you other options.
>
> https://drive.google.com/open?id=1bM6qGYaNmm93sEbwE4x4aoQSAZMtEIvH
> <https://link.getmailspring.com/link/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/0?redirect=https%3A%2F%2Fdrive.google.com%2Fopen%3Fid%3D1bM6qGYaNmm93sEbwE4x4aoQSAZMtEIvH&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D>
> Let me know if you need anything else.
>
> Sam
>
> On May 28 2018, at 4:15 pm, Nicolas Cadieux <nicolas.cadieux at archeotec.ca>
> <nicolas.cadieux at archeotec.ca> wrote:
>
>
>
> 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/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/1?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F0%3Fredirect%3Dhttps%253A%252F%252Fdrive.google.com%252Ffile%252Fd%252F1x0ADTag8xk85Ty3Vx6Wyb0FQCXfKDyBQ%252Fview%253Fusp%253Dsharing%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&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>
> <https://link.getmailspring.com/link/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/2?redirect=mailto%3Anicolas.cadieux%40archeotec.ca&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D>
> 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/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/3?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F1%3Fredirect%3Dmailto%253Asam.williams%2540sineenvironmental.com%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&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/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/4?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F2%3Fredirect%3Dhttps%253A%252F%252Flink.getmailspring.com%252Flink%252F1527454204.local-f62ddf4d-2b7e-v1.2.1-7e7447b6%2540getmailspring.com%252F0%253Fredirect%253Dhttps%25253A%25252F%25252Fgithub.com%25252Fqgis%25252FQGIS%25252Ftree%25252Frelease-2_18%2526recipient%253DcWdpcy11c2VyQGxpc3RzLm9zZ2VvLm9yZw%25253D%25253D%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%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
>
> [image: Open Tracking]
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> <https://link.getmailspring.com/link/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/5?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F3%3Fredirect%3Dmailto%253AQgis-user%2540lists.osgeo.org%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D>
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> <https://link.getmailspring.com/link/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/6?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F4%3Fredirect%3Dhttps%253A%252F%252Flists.osgeo.org%252Fmailman%252Flistinfo%252Fqgis-user%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D>
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> <https://link.getmailspring.com/link/1527529341.local-5ca47607-9dc5-v1.2.1-7e7447b6@getmailspring.com/7?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F1527503634.local-c54bfe18-f86f-v1.2.1-7e7447b6%40getmailspring.com%2F5%3Fredirect%3Dhttps%253A%252F%252Flists.osgeo.org%252Fmailman%252Flistinfo%252Fqgis-user%26recipient%3Dbmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%253D%253D&recipient=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYQ%3D%3D>
>
> [image: Open Tracking]
>
> [image: Open Tracking]
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180529/1fdcb460/attachment.html>