Hey there, great video- hoping to get some advice based on what I've seen in the video. I am trying to join tree measurement data to plot points on a map based on a shared "plot index" column. I need to be able to reference the tree measurements because I'll be using LiDAR sensing to develop a reference map for ecological work. The problem is, the spatial plot data is in a separate table than the non spatial tree measurement data, and the only thing combining the two tables would be the plot index that relates each tree to one plot. Is it even possible to create a one to many join where I can click on a plot point on my map and look at all of the tree measurement data within that plot? Thanks for your time, I hope you are able to help, this has been a bit of a headache!
You cannot do a join with a one to many relationship. You can use a relate in a one to many or many to many relationship. If your data is in a geodatabase you can also create a relationship class to link the data. All of these options keep the data in separate tables but does link records together based on the key fields. If your data is in something like SQL Server, PostgreSQL, or Oracle, you might also be able to create a view that combines the two tables together.
Thank you for the clear explanation. However, In which file format should the non spatial data be in before the joins or relates. Am a new GIS user. Thank you
Glad you thought the video provided a clear explanation. To answer your question, in a best-case scenario the non-spatial or stand-alone table would be included in a geodatabase. If that is not possible then any format supported by ArcGIS Pro including DBF, CSV, or any relational database (SQL, PostgreSQL, Oracle, or similar) you have can connect to. I would avoid Excel files if possible. Technically they will work but ArcGIS is very picky about working with Excel files. They have to be formatted very simply and meet specific standards. Also, Microsoft Access should be avoided. For a long time, ArcGIS Pro did not support Access at all. I believe with the newest versions of Pro you can connect to an Access database but it is still a bit unstable.
hi, thanks for your video. when i relate to shapefile its work like your video example. but when i relate from shapefile to standalone table it does not work.. do you know what the problem.
Without seeing the data it is hard to say exactly. It could be a problem with the data values. For example you might have unseen leading or ending spaces in the values. This often happens when you try to use text fields as the key fields for the joins or relates.
HI, Kindly help me. I am trying to join tables with a one to many relationship. I need to symbolise using the data in the many relationships (stand alone table) but it can't. How best can I navigate that. Have tried and have failed. When I join, I lose data in the output table and my results end up not being significant. I will be so grateful for your kind help.
Data connected via a relate or a relationship class cannot be used to symbolize or label features in a map. Relates or relationship classes are required if you have a one-to-many or a many-to-many relationship.
Congratulations on the video, it was very good and thorough. I have a request for you, since only you can enlighten us on this difficult topic: Could you explain the ulity network, perhaps for telecommunication networks? Thank you so much you are bravoism, I write from Italy, but here nobody can explain as well as you!
Thank you so much for the very kind words. They are appreciated. I will see what I can do to provide an explanation. Italy is a beautiful Country. I enjoyed visiting Naples and Trieste back in the 90s.
I've watched every video I can find on Joins and Relates and still failing to understand Joins and Relates. I have a spreadsheet of 4,446 items with a column header ALTKEY and additional columns of related data. I have a Parcels shapefile that contains all parcels in the county with a column header ALTKEY. I want to find the 4,446 parcels from the spreadsheet in my parcels dbf file and I want to create a separate layer for just those parcels. Can someone please help me?
First thing I would do is convert the spreadsheet to a DBF file since you are working with shapefiles. ArcGIS will read a spreadsheet but will often have issues unless it is a very simple spreadsheet that also conforms to Database standards. Next verify the the field type (Text/String, Integer, Float, Double and so on) for the ALTKEY field in both tables match. You cannot join or relate if they don't. Next you need to determine how many records in your shapefile match to records in your converted DBF. I mean does each parcel only have up to one matching record in the DBF or does it have multiple matches in the DBF or does each record in the DBF match to multiple records in the parcel shape file. If each parcel matches to no more than 1 record or row in the DBF or if a single record/row in the DBF matches multiple parcels in the shapefile, then you can do a join. Otherwise you would need to do a relate. Hopefully this helps even though it is a bit late.
Great video mate. Thank you for sharing.
Great video, I appreciate the visual aides.
I really like this video. It explained all I needed to know about Join and Relate in ArcGIS Pro
So glad you found it helpful and informative
Thank you for your clear and kind expaination.
Great tutorial vid, thanks so much
I enjoyed your video. Can you add in the version of ArcGIS Pro that you are using into the description? Thanks!
Will do. I believe it was 2.6 at the time of the video.
Hey there, great video- hoping to get some advice based on what I've seen in the video. I am trying to join tree measurement data to plot points on a map based on a shared "plot index" column. I need to be able to reference the tree measurements because I'll be using LiDAR sensing to develop a reference map for ecological work. The problem is, the spatial plot data is in a separate table than the non spatial tree measurement data, and the only thing combining the two tables would be the plot index that relates each tree to one plot. Is it even possible to create a one to many join where I can click on a plot point on my map and look at all of the tree measurement data within that plot? Thanks for your time, I hope you are able to help, this has been a bit of a headache!
You cannot do a join with a one to many relationship. You can use a relate in a one to many or many to many relationship. If your data is in a geodatabase you can also create a relationship class to link the data. All of these options keep the data in separate tables but does link records together based on the key fields. If your data is in something like SQL Server, PostgreSQL, or Oracle, you might also be able to create a view that combines the two tables together.
Thank you
very good video
Glad you liked it.
Thank you for the clear explanation. However, In which file format should the non spatial data be in before the joins or relates. Am a new GIS user. Thank you
Glad you thought the video provided a clear explanation. To answer your question, in a best-case scenario the non-spatial or stand-alone table would be included in a geodatabase. If that is not possible then any format supported by ArcGIS Pro including DBF, CSV, or any relational database (SQL, PostgreSQL, Oracle, or similar) you have can connect to. I would avoid Excel files if possible. Technically they will work but ArcGIS is very picky about working with Excel files. They have to be formatted very simply and meet specific standards. Also, Microsoft Access should be avoided. For a long time, ArcGIS Pro did not support Access at all. I believe with the newest versions of Pro you can connect to an Access database but it is still a bit unstable.
@@eGISAssociates Thank you kindly
hi, thanks for your video. when i relate to shapefile its work like your video example. but when i relate from shapefile to standalone table it does not work.. do you know what the problem.
Without seeing the data it is hard to say exactly. It could be a problem with the data values. For example you might have unseen leading or ending spaces in the values. This often happens when you try to use text fields as the key fields for the joins or relates.
HI,
Kindly help me.
I am trying to join tables with a one to many relationship.
I need to symbolise using the data in the many relationships (stand alone table) but it can't. How best can I navigate that. Have tried and have failed.
When I join, I lose data in the output table and my results end up not being significant.
I will be so grateful for your kind help.
Data connected via a relate or a relationship class cannot be used to symbolize or label features in a map. Relates or relationship classes are required if you have a one-to-many or a many-to-many relationship.
Good relates
Thank you
Congratulations on the video, it was very good and thorough. I have a request for you, since only you can enlighten us on this difficult topic: Could you explain the ulity network, perhaps for telecommunication networks? Thank you so much you are bravoism, I write from Italy, but here nobody can explain as well as you!
Thank you so much for the very kind words. They are appreciated. I will see what I can do to provide an explanation. Italy is a beautiful Country. I enjoyed visiting Naples and Trieste back in the 90s.
I've watched every video I can find on Joins and Relates and still failing to understand Joins and Relates. I have a spreadsheet of 4,446 items with a column header ALTKEY and additional columns of related data. I have a Parcels shapefile that contains all parcels in the county with a column header ALTKEY. I want to find the 4,446 parcels from the spreadsheet in my parcels dbf file and I want to create a separate layer for just those parcels. Can someone please help me?
First thing I would do is convert the spreadsheet to a DBF file since you are working with shapefiles. ArcGIS will read a spreadsheet but will often have issues unless it is a very simple spreadsheet that also conforms to Database standards. Next verify the the field type (Text/String, Integer, Float, Double and so on) for the ALTKEY field in both tables match. You cannot join or relate if they don't. Next you need to determine how many records in your shapefile match to records in your converted DBF. I mean does each parcel only have up to one matching record in the DBF or does it have multiple matches in the DBF or does each record in the DBF match to multiple records in the parcel shape file. If each parcel matches to no more than 1 record or row in the DBF or if a single record/row in the DBF matches multiple parcels in the shapefile, then you can do a join. Otherwise you would need to do a relate. Hopefully this helps even though it is a bit late.
When joining a table to a feature class, more than one table can be joined
Not sure if that was a question or a statement but yes more than one can be joined.
@@67Stang was a question. Thanks!