Thanks, I'll check out QGIS 3! On Tue, 29 May 2018, 16:00 Nicolas Cadieux, <[email protected]> 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/[email protected]/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 <[email protected]> > <[email protected]> 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/[email protected]/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 <[email protected]> > <https://link.getmailspring.com/link/[email protected]/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 < > [email protected] > <https://link.getmailspring.com/link/[email protected]/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/[email protected]/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 > [email protected] > <https://link.getmailspring.com/link/[email protected]/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/[email protected]/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/[email protected]/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] > > >
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
