Timeline for Losing commmon data when joining excel and shapefile
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 10, 2016 at 12:29 | history | edited | PieterB | CC BY-SA 3.0 |
added 924 characters in body
|
| Aug 10, 2016 at 11:52 | comment | added | PieterB | i have a sollution with virtual layers. Can you share your shapefile and csv with me? | |
| Aug 10, 2016 at 10:40 | comment | added | C.McCabe | Let us continue this discussion in chat. | |
| Aug 10, 2016 at 10:36 | comment | added | C.McCabe | Ideally, I want the block layer to contain the information which is in the database in its attribute table, allowing me to save it as a new shapefile layer with all of my excel data contained within. Basically like my output that results from the join (see image 2) but obviously without the loss of data. I had thought about putting the 'lost data' into a separate excel and doing the join again on a duplicate of the block shapefile, then merging the two, but I don't know if that will work either. | |
| Aug 10, 2016 at 10:24 | comment | added | PieterB | how do you want to display the data by block? As a table without geometry? | |
| Aug 10, 2016 at 10:15 | comment | added | C.McCabe | It is a shame to hear that the relation does not add data to the shapefile as a join does. Alwyn A and B share the same UKCS Block in the North Sea, basically a designated area for the oil and gas industry, and the block layer provides the geometry. I want to display the data by block, and so after some digging I think this may be better described as a one-to-many join (many platforms to the one block). There doesn't seem to be an easy method for this join in QGIS, unless anything comes to mind? | |
| Aug 10, 2016 at 10:05 | comment | added | PieterB | It is not clear to me how the shapefile relates to the records in the CSV. Does Alwyn A shares the same geometry with Alwyn B? | |
| Aug 10, 2016 at 9:59 | comment | added | PieterB | No, the relation does not provide extra data to the shapefile. | |
| Aug 10, 2016 at 9:26 | comment | added | C.McCabe | Pieter, thanks for the answer, but does the creation of this relation assign any values to the shapefile itself? I'm looking to create a shapefile which contains all of the data by block at the end, in order to share and deliver this information to other users. Does the relation allow this? | |
| Aug 9, 2016 at 14:00 | history | answered | PieterB | CC BY-SA 3.0 |