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]> 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

                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>

        Open Tracking

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

Reply via email to