Spatial Queries, Table Joins, and Relates: A Technical Video Lecture

A Geographic Information Systems (GIS) technical video lecture designed for teaching at the Rochester Institute of Technology (RIT).
For questions, comments and more information, contact:
Brian Tomaszewski, Ph.D.
Department of Information Sciences & Technologies
Rochester Institute of Technology
Rochester, NY 14623, USA
[e-mail]
people.rit.edu/bmtski/
v1.0 - Spring 2017

[@kendelbolanio9920]

Thank you for sharing. This will be of great help especially in preparing my lectures in GIS class.

[@capuano3d]

That's really relevant and plenty of content tutorial. Cheers!

[@madangautam9000]

It is simply excellent, well illustrated, complex things are illustrated in a simple way.

[@tkar66]

Highly appreciate! Thank you.

[@AmazingJayB51]

Working on another online course project, your video was very helpful in helping me understand joins, Thank you!

[@DeadbeatGodfather]

hey monroe county and RIT! I was born n raised in Rochester, live down south now... anyways, awesome video

[@bhushanpatil6233]

Awesome Work...

[@pariadk]

Really good and useful video...

[@kwandumakayi8784]

Great!

[@berhanumoges9696]

That is great tutorial! Thank you !

[@GIScienceRIT]

Thank you!

[@daradulcey9396]

Very informative video, Where can I get the shapefiles that you were using?

[@AhmadAhmad-ki2su]

Hello, the first step in join and relate how to get data

[@pariadk]

Please create same video of Geomedia software.. Thanks

[@vishalibaburaj5036]

Great Tutorial

[@GIScienceRIT]

Thanks!

[@rawaizkhan8887]

Really helpfull..

[@GIScienceRIT]

Glad it was helpful!

[@noneofyourbusiness4911]

saved my butt ! Thank you !

[@GIScienceRIT]

Awesome! Glad the video was useful

[@pbsmultan6251]

PLZ Tell me how to ad text in start of already added text

[@GIScienceRIT]

Hello, not sure exactly what you're referring to, can you please provide a more specific example I'll try to help you if I can thank you

[@ayuandika6466]

Awesome! but how to do one-to-many join in arcgis pro? thx

[@GIScienceRIT]

you might consider doing a relate pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-relate.htm Also, this outlines "How To: Create a one-to-many join in ArcMap" (the older software) but all of these tools still exist in ArcGIS Pro so follow the instructions and use the tools accordingly support.esri.com/en/technical-article/000010848 thanks!

[@saniaparveen9428]

Really Appreciatable✌✌

[@GIScienceRIT]

Thank you! Be sure to check out other videos on the channel to build your GIS skills!

[@saniaparveen9428]

I will In Shaa Allah

[@okotelvincent]

HI, 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. I tried and I failed. When I join, I lose data in the output table and my results end up not being significant. How can I do a 1:M join. I will be so grateful for your kind help.

[@GIScienceRIT]

Check the settings you're using when you set up a join oh, you should have an option to do a one-to-many relationship when you run the join

[@okotelvincent]

@@GIScienceRIT I am using arcgis pro, but when you do a join you lose data which affects the significance of your results.

[@GIScienceRIT]

If you're losing data that could be that you don't have matching data double check that your columns in the two tables are the same

[@okotelvincent]

@@GIScienceRIT the primary table has single record for each key in the secondary table which has multiple records of same in the first table

[@twilsoncohen]

I really found the information informative, however the smacking and swallowing really got on my nerves!

[@clickmintaka1232]

HATHI KA DANTH DEKANA KA AUR KHANA KA AUR/////