[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