<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Mauricio,<div><br></div><div>Again, I do think this would be useful. Hopefully others will chime in as well.</div><div><div><br></div><div>John</div><div><br><div><div>On Dec 27, 2009, at 10:41 AM, Maurício de Paulo wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">The idea behind this plugin is that it would use qgsvectorlayer (that supports shapefile, postgresql, grass, dbf, etc) and would join only a single feature attributes.<br>So i'm proposing that the user would select a feature and would be able to find everything related to it. Every relationship could be stored in a relationship file so that you could reproduce it for a given data model. <br>
It's a major problem in Brasil because we defined a new spatial model and qgis is not able to read relationships. At least, the user should be able to build them to look for non-spatial relations of a given feature.<br>
Well, as soon as I have a working plugin i'm going to release it. If anyone have interest in it, please tell me so I can continue working without loosing my time. :P<br>Mauricio de Paulo<br><br><br><div class="gmail_quote">
2009/12/27 John C. Tull <span dir="ltr"><<a href="mailto:john.tull@wildnevada.org">john.tull@wildnevada.org</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="">Hi Mauricio,<div><br></div><div>I am interested in what you propose. Currently, fTools allows joining tables using dbf files (maybe other formats, not sure). But this produces a new shapefile. Having a means to create table joins without outputting a new file would be very useful. I am sure others would agree. Ideally, this would allow the use of multiple table formats, including postgresql, as you suggested.</div>
<div><br></div><div>Cheers,</div><div>John</div><div><br><div><div><div></div><div class="h5"><div>On Dec 26, 2009, at 8:56 PM, Maurício de Paulo wrote:</div><br></div></div><blockquote type="cite"><div><div></div><div class="h5">
Well, after some testing I found out that qgis now can open dbf files as vector layers. It's enough for me to create the "relate" implementation. <br>As far as I can see, it's possible and won't take too long to implement. Will it be usefull? Is anyone already working on a full join implementation?<br>
Mauricio de Paulo<br><br><div class="gmail_quote">2009/12/26 Maurício de Paulo <span dir="ltr"><<a href="mailto:mauricio.dev@gmail.com" target="_blank">mauricio.dev@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi folks,<br>I don't remember exactly what was defined on the last discussion about table joins.<br>I've read many good sugestions, many of them about implementing attribute relationship inside qgsvectorprovider.<br>
I also work on ArcGIS and the relations and joins on ArcGIS usually don't show the full table join. It only shows the related attributes of a single feature. So for each feature, you can use a Info tool to see every attribute about it (including the ones that comes from related tables). Everything is done on the fly, but performance is not a big issue as i'm only going to search for one feature's relationships.<br>
I'm using the screenshots that are attached to the mail as an example of how it should work.<br>At the moment I need some feedback on what it is or is not a good approach and if it's gonna be usefull for the users.<br>
What do you guys think?<br>The idea is a plugin to record what relationships are stored for each layer and then show the attributes in a tree view where a single feature can be linked to many other rows in the second table. I still don't know how i'm going to implement it but either I will use ogr or qgsvectorprovider. I still have to search if it's possible to access the dbf files and postgis connections using qgis api.<br>
Any comment is welcome.<br>Mauricio de Paulo<br><br><br><br>
</blockquote></div><br></div></div>
_______________________________________________<br>Qgis-developer mailing list<div class="im"><br><a href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a><br></div><a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
</blockquote></div><br></div></div></blockquote></div><br>
</blockquote></div><br></div></div></body></html>