0

I am new to QGIS. I am a land surveyor and I have all of the property parcel mapping information in a shape file for my area. I am trying to link/join an Excel file which has all of the survey files indexed which contain survey information and plans for various properties. The parcel mapping file has a field entitled PID.... the excel file has a file called PID and also a field called Plan No. I am not sure of the correct terminology but I would like to join the two, and have a symbol displayed in the parcel mapping which would represent that I have a Plan No. for that parcel. At this point I think I have joined the Parcel mapping to the Excel file, but do not know what to do next.

0

I am assuming that you could either set a label or a custom symbol in the center of the polygon. For the label simply use the field that you have joined. If you want a custom symbol you can do it in 2 ways, either export the centroid of your current layer using the tool in the processing toolbox (this will also export the joined excel table to the new file). Another way is to go in the symbology, use categorized geometry, for the symbol use the geometry generator to get the centroid (see image) and don't forget to lock your base style to prevent it from changing.

enter image description here

Though if you are using the geometry generator your symbology will be altered in the legend, if you have a legend.

Is this what you wanted?

  • Not really....perhaps we can begin with the first part...joining the tables...my parcel mapping layer is called "Export_output" and I have attached my Excel file as a table and that is called "Survey Files nov 24". Both the shapefile and the Excel file have a PID column in common. What are the steps to join these two using the PID column....i am using QGIS 3.4 – ken cormier Mar 24 '19 at 12:37
  • @kencormier this should help : qgistutorials.com/en/docs/performing_table_joins.html – Al rl Mar 24 '19 at 22:05
0

Ken, first ensure your join has been correctly set up. Right click on your layer then in Properties / Joins you should see a listing of the join(s) existing on your layer.

If the join is correctly set you can then open your attribute table you should be able to see the additionnal attributes coming from your joined layer (your xls file).

You then decide what you do with these extra data ! A common choice is to setup a categorized symbology (properties/symbology/categorized) based on the attributes you joined (choose the right column for that).

Care about the relation existing beetwen your 'properties' and your excel file (1-1 relation or 1-n relation) ... if it's a 1-n relation you'll certainly have to aggregate your data (by "properties") to help qgis understand what you want to map ...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.