Re: [Qgis-user] Attribute Table - Primary key

[Ujaval Gandhi]

The 'primary key' for vector layer in QGIS could be any column that has
unique values for each feature. Using the fids as primary key is not a good
idea. I would recommend having a 'Parcel ID' column in your vector layer.
For a 1-to-1 join, you don't need to do anything special to designate that
column as your primary key. You can setup a join between the parcels layer
and the database table using 'Join Properties'
https://docs.qgis.org/3.10/en/docs/user_manual/working_with_vector/vector_properties.html?highlight=join#joins-properties

QGIS has a relation manager that allows you to create one-to-many joins.
See
https://docs.qgis.org/3.10/en/docs/user_manual/working_with_vector/attribute_table.html?highlight=foreign%20key#creating-one-or-many-to-many-relations




[image: Logo] 
Ujaval Gandhi
Spatial Thoughts
mobile: +91-8095684687
email: uja...@spatialthoughts.com
[image: LinkedIn icon]   [image:
Twitter icon] 



On Sun, Dec 13, 2020 at 3:14 AM  wrote:

>
>
> Cheers
>
>
>
> *Dr Iain Stuart*
>
> *JCIS Consultants *
>
> P.O. Box 2397
>
> Burwood North
>
> NSW, 2134
>
>
>
> (02) 9701 0191
> (0413) 380116 (m)
>
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Excel sync plugin ( Qgis)

[Marin Mirosevic]

Hi,

I tried connectiing Qgis layer to excell sheet but didn’t manage . Can somebody 
explain what is to be putted in “ excel sheet” part of the outline  ( I guess 
path to excel file)?

Also would be good to get a snapshot showing setup especially how “excell 
sheet” line looks like. If doesn’t go  with snapshot than copy - pasted line 
from your “excel sheet” line.

Thanks
Best regards


Dohvati Outlook za iOS
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Attribute Table - Primary key

[Iain]

 

Cheers

 

Dr Iain Stuart

JCIS Consultants 

P.O. Box 2397

Burwood North

NSW, 2134

 

(02) 9701 0191
(0413) 380116 (m)

 

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user