[Qgis-user] Preserving geometry when batching joins
Nicolas Cadieux
nicolas.cadieux at archeotec.ca
Tue May 29 07:59:37 PDT 2018
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> 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
>
> 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>
>
> Open Tracking
>
> Open Tracking
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180529/fc51cc60/attachment.html>
More information about the Qgis-user
mailing list