<div dir="ltr">Ciao<div><br></div><div>concordo con Michele ma aggiungerei un campo spaziatore ("-", ad esempio).</div><div><br></div><div>Facciamo il caso che esista, sempre a Lucca, il mappale 655 al foglio 3...avresti già un dubbio!!.</div><div><br></div><div>Il campo key sarebbe quindi;
<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Lucca-36-55.</span></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Personalmente preferisco, al posto del nome comune (apostrofi ecc.) il codice Belfiore o ISTAT.</span></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">A presto</span></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Alberto</span></div><div><br></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><span></span><span></span><img src="https://docs.google.com/uc?export=download&id=0B0D5sqlqwzd1c0o2ZjJFX184QWs&revid=0B0D5sqlqwzd1L0lGV3RIMjVFN0VDbXJZYmlqdlRnV0ZrSFU0PQ" width="420" height="131"><img src="https://docs.google.com/uc?id=0B0D5sqlqwzd1U09CZEJjd2FNak0&export=download" width="420" height="131"><img src="https://docs.google.com/uc?id=0B0D5sqlqwzd1ZDVrRHN1bVQwUGM&export=download" width="420" height="130"><img src="https://docs.google.com/uc?export=download&id=1BoRq9Ds78QW14KS_7mfnMsx99SZVe6Cl&revid=0B0D5sqlqwzd1eGRhUUxUTW5vdXJudDFIMXNXWGxoQ3pBS05NPQ" width="420" height="131"><br></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">Il giorno 9 febbraio 2018 07:58, <span dir="ltr"><<a href="mailto:qgis-it-user-request@lists.osgeo.org" target="_blank">qgis-it-user-request@lists.osgeo.org</a>></span> ha scritto:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Invia le richieste di iscrizione alla lista QGIS-it-user all'indirizzo<br>
<a href="mailto:qgis-it-user@lists.osgeo.org">qgis-it-user@lists.osgeo.org</a><br>
<br>
Per iscriverti o cancellarti attraverso il web, visita<br>
<a href="https://lists.osgeo.org/mailman/listinfo/qgis-it-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/qgis-it-user</a><br>
oppure, via email, manda un messaggio con oggetto `help' all'indirizzo<br>
<a href="mailto:qgis-it-user-request@lists.osgeo.org">qgis-it-user-request@lists.<wbr>osgeo.org</a><br>
<br>
Puoi contattare la persona che gestisce la lista all'indirizzo<br>
<a href="mailto:qgis-it-user-owner@lists.osgeo.org">qgis-it-user-owner@lists.<wbr>osgeo.org</a><br>
<br>
Se rispondi a questo messaggio, per favore edita la linea dell'oggetto<br>
in modo che sia più utile di un semplice "Re: Contenuti del digest<br>
della lista QGIS-it-user..."<br>
<br>Argomenti del Giorno:<br>
<br>
1. Re: Relazioni tra tabelle (Ribecai)<br>
<br><br>---------- Messaggio inoltrato ----------<br>From: Ribecai <<a href="mailto:michele.ribecai@cbtoscananord.it">michele.ribecai@cbtoscananord.it</a>><br>To: <a href="mailto:qgis-it-user@lists.osgeo.org">qgis-it-user@lists.osgeo.org</a><br>Cc: <br>Bcc: <br>Date: Fri, 9 Feb 2018 07:49:45 +0100<br>Subject: Re: [QGIS-it-user] Relazioni tra tabelle<br>
<div text="#000000" bgcolor="#FFFFFF">
Ciao,<br>
non so se ci sono modi più eleganti comunque tempo fa io ho risolto
creando un nuovo campo (es. key) che fosse l'unione del comune, del
foglio e della particella sia nello shape sia nel csv, esempio:<br>
<br>
coumune foglio particella key<br>
Lucca 36 55 Lucca3655<br>
<br>
Con questo nuovo campo (univoco) ho fatto poi il join su QGIS.<br>
<br>
Ciao<br>
Michele<br>
<br>
<br>
<br>
<br>
<div class="m_-2414029471029144540moz-cite-prefix">Il 08/02/2018 14:48, Alessio Puccini ha
scritto:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Ciao.</span>
<div>Devo collegare uno shape ad un csv. Lo shape è formato dai
campi comune, foglio, particella. La tabella .csv oltre ai
campi dello shape per ogni particella ha più attributi.<br>
</div>
<div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">
<div class="m_-2414029471029144540gmail-_li" id="m_-2414029471029144540gmail-u_0_l">
<div class="m_-2414029471029144540gmail-uiContextualLayerParent" id="m_-2414029471029144540gmail-globalContainer">
<div class="m_-2414029471029144540gmail-fb_content m_-2414029471029144540gmail-clearfix" id="m_-2414029471029144540gmail-content">
<div class="m_-2414029471029144540gmail-_2pie">
<div class="m_-2414029471029144540gmail-clearfix" id="m_-2414029471029144540gmail-mainContainer">
<div class="m_-2414029471029144540gmail-_5r-_ m_-2414029471029144540gmail-groupJumpLayout m_-2414029471029144540gmail-groupLitestandClassicJumpLayout m_-2414029471029144540gmail-homeWiderContent m_-2414029471029144540gmail-homeFixedLayout m_-2414029471029144540gmail-groupJumpLayoutCoverNewClip m_-2414029471029144540gmail-_1qkq m_-2414029471029144540gmail-_1ql0" id="m_-2414029471029144540gmail-contentCol">
<div class="m_-2414029471029144540gmail-clearfix" id="m_-2414029471029144540gmail-content_container">
<div class="m_-2414029471029144540gmail-_14i5 m_-2414029471029144540gmail-_1qkq m_-2414029471029144540gmail-_1qkx" id="m_-2414029471029144540gmail-contentArea">
<div id="m_-2414029471029144540gmail-pagelet_group_">
<div id="m_-2414029471029144540gmail-u_0_1h">
<div id="m_-2414029471029144540gmail-pagelet_group_mall">
<div class="m_-2414029471029144540gmail-_5pcb" id="m_-2414029471029144540gmail-group_mall_62367596384">
<div>
<div class="m_-2414029471029144540gmail-_4-u2 m_-2414029471029144540gmail-mbm m_-2414029471029144540gmail-_4mrt m_-2414029471029144540gmail-_5jmm m_-2414029471029144540gmail-_5pat m_-2414029471029144540gmail-_5v3q m_-2414029471029144540gmail-_4-u8" id="m_-2414029471029144540gmail-mall_post_10156198253231385:6:0">
<div class="m_-2414029471029144540gmail-_3ccb" id="m_-2414029471029144540gmail-u_0_1p">
<div class="m_-2414029471029144540gmail-_5pcr m_-2414029471029144540gmail-userContentWrapper">
<div class="m_-2414029471029144540gmail-_1dwg m_-2414029471029144540gmail-_1w_m m_-2414029471029144540gmail-_q7o">
<div class="m_-2414029471029144540gmail-_5pbx m_-2414029471029144540gmail-userContent m_-2414029471029144540gmail-_22jv m_-2414029471029144540gmail-_3576" id="m_-2414029471029144540gmail-js_1a">
<p>Come posso in Qgis
associare al mio shape
delle particelle gli
attributi del .csv?
Devo creare una
chiave.Ho provato a
importarlo in QGIS
tramite aggiungi testo
delimitato e fare un
comune join tabellare
solo che come campo
comune me ne da uno
solo.</p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<img src="cid:part1.D63630C6.E16BFABB@cbtoscananord.it" alt="Immagine incorporata 1" width="292" height="216"><br>
</span></div>
<div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br>
</span></div>
<div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Dovrei
creare una chiave altrimenti rischio di fare la join
sbagliata attribuendo ad esempio alla particella X gli
attributi (es. uso suolo) di tutte le particelle X dei fogli
e comuni interessati mentre in realtà la particella X del
Foglio X e comune X avrà un uso del suolo e la particella X
del Foglio Y del comune Y avra un altro uso del suolo.</span><br>
</div>
<div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br>
</span></div>
<div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Spero
di essere stato chiaro. Qualcuno sa aiutarmi?</span></div>
<div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br>
</span></div>
<div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Alessio</span></div>
<div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br>
</span></div>
</div>
<div id="m_-2414029471029144540DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid #d3d4de">
<tbody>
<tr>
<td style="width:55px;padding-top:18px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" style="width:46px;height:29px" width="46" height="29"></a></td>
<td style="width:470px;padding-top:17px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Mail
priva di virus. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" style="color:#4453ea" target="_blank">www.avast.com</a> </td>
</tr>
</tbody>
</table>
</div>
<br>
<fieldset class="m_-2414029471029144540mimeAttachmentHeader"></fieldset>
<br>
<pre>______________________________<wbr>_________________
QGIS-it-user mailing list
<a class="m_-2414029471029144540moz-txt-link-abbreviated" href="mailto:QGIS-it-user@lists.osgeo.org" target="_blank">QGIS-it-user@lists.osgeo.org</a>
<a class="m_-2414029471029144540moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-it-user" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/qgis-it-user</a>
</pre>
</blockquote>
<br>
<div class="m_-2414029471029144540moz-signature">-- <br>
______________________________<wbr>______ <br>
<div class="m_-2414029471029144540moz-signature"> <font size="1.9" face="Ubuntu" color="darkblue"> Michele Ribecai -
Pianificatore Territoriale <br>
</font> <font size="2.5" face="Ubuntu" color="black"> Consorzio
1 Toscana Nord - Ufficio Progettazione <br>
</font> <font size="1.6" face="Ubuntu" color="black">
centralino 0584 439921 diretti 0584 439921 - 346 0154409</font></div>
</div>
</div>
<br>______________________________<wbr>_________________<br>
QGIS-it-user mailing list<br>
<a href="mailto:QGIS-it-user@lists.osgeo.org">QGIS-it-user@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/qgis-it-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/qgis-it-user</a><br>
<br></blockquote></div><br></div></div>