I have my tables set up in the same way to track networking among correspondents - but when I add the virtual layer no lines are showing up connecting the idfrom and idto.... I've been trying to troubleshoot this for a couple days now and am at a loss of what I have set up wrong.
when im adding virtual layer im getting this error after pressing test "Query preparation error on PRAGMA table_info(_tview): no such column: a.ID" can you help me please
Nice Tuto! Congrats! When I want to test the Virtual layer, I always have messages of syntax error, I triple check and I am sure all the text are equal. I am using QGIS 3.4. Do you think It can come from QGIS version?
Thank you so much! I have a question: suppose one also has a certain number of people staying within the city, and you'd like to visualize that. Is there a way to create arrow loops from one city to itself in QGIS as well?
I haven't thought about that before. Of course, if you have exacts addresses of people, and you zoom in to the level of the city, those arrows could point from one person's address to another's just as set up in this video. However, if zoomed out, I am not sure it would be very clear without a lot of customisation for those specific arrows since the arrow heads would overlap and need fixing, but also the bend would need to be different for those local cases. I'm sure it could be done, but not sure how well it would as a visualisation.
@@konradlawson2912 Hmmm alright, thank you for your thoughts. I'm now trying to do it by creating a set of copy set of points just next to the original ones. Then I proceed to create arrows between the original ones to the copies. In order to create the loops, it is indeed important to adjust the bend. I'm not entirely sure yet how to customize the bend in such a way that it is proportional to the distance between the points though. Or perhaps it's easier to manually adjust the bend for each pair, if one has a limited amount of nodes? If so, do you perhaps know how to manually adjust the bend of each arrow?
thanks, good explanation and great video
you should upload more often.
I have my tables set up in the same way to track networking among correspondents - but when I add the virtual layer no lines are showing up connecting the idfrom and idto.... I've been trying to troubleshoot this for a couple days now and am at a loss of what I have set up wrong.
Can you please tell how to create network using node and edges
Hi, Thanks For this excellent video, could you please share the excel document you are working with. I have trouble in following each step!
when im adding virtual layer im getting this error after pressing test "Query preparation error on PRAGMA table_info(_tview): no such column: a.ID" can you help me please
Hi, when I try to change the arrow line width I don't have any option in the source bottom. You know what could be the problem?
the same here, but when i typed the option name appeared
Nice Tuto! Congrats! When I want to test the Virtual layer, I always have messages of syntax error, I triple check and I am sure all the text are equal. I am using QGIS 3.4. Do you think It can come from QGIS version?
A tip: you can watch series at flixzone. Me and my gf have been using them for watching a lot of movies during the lockdown.
@Kameron Desmond definitely, I've been using Flixzone} for months myself :D
Thank you so much! I have a question: suppose one also has a certain number of people staying within the city, and you'd like to visualize that. Is there a way to create arrow loops from one city to itself in QGIS as well?
I haven't thought about that before. Of course, if you have exacts addresses of people, and you zoom in to the level of the city, those arrows could point from one person's address to another's just as set up in this video. However, if zoomed out, I am not sure it would be very clear without a lot of customisation for those specific arrows since the arrow heads would overlap and need fixing, but also the bend would need to be different for those local cases. I'm sure it could be done, but not sure how well it would as a visualisation.
@@konradlawson2912 Hmmm alright, thank you for your thoughts. I'm now trying to do it by creating a set of copy set of points just next to the original ones. Then I proceed to create arrows between the original ones to the copies. In order to create the loops, it is indeed important to adjust the bend. I'm not entirely sure yet how to customize the bend in such a way that it is proportional to the distance between the points though. Or perhaps it's easier to manually adjust the bend for each pair, if one has a limited amount of nodes? If so, do you perhaps know how to manually adjust the bend of each arrow?