No video

Joining Tables in ArcGIS Pro

  Рет қаралды 7,677

Jedi_Mapper P

Jedi_Mapper P

2 жыл бұрын

This video was made to help a student who was getting null values when peforming a join. The problem was FIPS fields in the Tracts feature layer and in data table CSV file appeared to have identical values but still would not join properly. The problem was caused due the respective FIPS fields were not the same data type. The Tracts table had FIPS set to Text, while the CSV table had FIPS set to Double. This video demonstrates how to remedy this issue and create a successful join.

Пікірлер: 19
@samjones6661
@samjones6661 3 ай бұрын
Thanks a lot. Many videos are like: you have a layer and a table, just add join and you are fine. Your video is like: Before you add join make sure they have the same data type. After this go for it ... and it magically worked :)
@jedi_mapperp4073
@jedi_mapperp4073 3 ай бұрын
Yep. I noticed the same thing so I made a video for my student(s). It made me realize many GIS users can click buttons but don’t understand much below the surface. Understanding first principles of tabular, vector, and raster data are key. Same for map projections and setting up Geodatabases so all the data is in the same projection. If not…everything crashes, or looks good “on the fly” but the spatial analysis tools crash. Many don’t understand why.
@slt5431
@slt5431 11 ай бұрын
This video makes me feeling hope again, because I was struggle to join the table for the past few weeks. Thank you for the detail explanation
@katepeng3774
@katepeng3774 Жыл бұрын
Thank you so much for this video. It is a life saver to me! p.s. For people who lost in translation on the following error message: "000970: The join field in the join table is not indexed. To improve performance, we recommend that an index be created for the join field in the join table", the most straight forward answer is right here!
@jedi_mapperp4073
@jedi_mapperp4073 Жыл бұрын
Thank you. Please like and subscribe so others find this video. I made it for one of my students. Glad you found it useful.
@katepeng3774
@katepeng3774 Жыл бұрын
@@jedi_mapperp4073 I already subscribed your channel. Thank you for sharing.
@jackiec7284
@jackiec7284 Ай бұрын
THANK YOU SO MUCH!you solved my problem right before my assignmenr due!your video is really helpful!!
@jeremiahladucapro
@jeremiahladucapro Жыл бұрын
BY FAR THE MOST HELPFUL VIDEO ON THE INTERNET FOR JOINING FIELDS! THANK YOU!
@jedi_mapperp4073
@jedi_mapperp4073 Жыл бұрын
Thank you! Share it around. I’m retired now. Pretty cool feeling seeing my videos are still teaching. 👍
@dunkman206
@dunkman206 Жыл бұрын
This video was extremely helpful with a project I am working on, I greatly appreciate you creating this video!
@jedi_mapperp4073
@jedi_mapperp4073 Жыл бұрын
Glad it helped. If you need help in the future let me know. If I can help I make a video.
@noegaray7088
@noegaray7088 Жыл бұрын
I was having trouble with this same issue for a capstone project I'm working on. I greatly appreciate the time you took in making this video!
@jedi_mapperp4073
@jedi_mapperp4073 Жыл бұрын
You’re welcome. Glad it’s still applicable as ESRI changes the software so often.
@elijahdavis1175
@elijahdavis1175 6 ай бұрын
My savior thank you so much
@chisatotarui9396
@chisatotarui9396 Жыл бұрын
YES!!! THANK YOU!!! MOSZT HELPFUL VISDEO EVER I LOVE YOU!!!! *aggressive virtual handshake*
@jedi_mapperp4073
@jedi_mapperp4073 Жыл бұрын
Well alright alright…aggressive virtual You’re welcome!! 😀
@user-im7cp9fn3b
@user-im7cp9fn3b 6 ай бұрын
LIFE SAVER
@user-ey4rc5tu4t
@user-ey4rc5tu4t Жыл бұрын
Ok. You are joining. Not merging. Interesting.
@jedi_mapperp4073
@jedi_mapperp4073 Жыл бұрын
You add tabular data to an existing layer feature by joining tables. You can merge two features with identical attribute tables.
Linking Tables in ArcGIS Pro using Joins and Relates
30:20
eGIS Associates
Рет қаралды 31 М.
Edit Attributes the Easy Way in ArcGIS Pro
9:29
GIS Chops
Рет қаралды 5 М.
Survive 100 Days In Nuclear Bunker, Win $500,000
32:21
MrBeast
Рет қаралды 152 МЛН
Алексей Щербаков разнес ВДВшников
00:47
OMG what happened??😳 filaretiki family✨ #social
01:00
Filaretiki
Рет қаралды 9 МЛН
女孩妒忌小丑女? #小丑#shorts
00:34
好人小丑
Рет қаралды 10 МЛН
ArcGIS Pro Spatial Join or Relate?
17:39
GIS Coordinated
Рет қаралды 10 М.
GIS Questions and Answers: Why is my join all Null?
7:09
Forrest Bowlick
Рет қаралды 4,3 М.
ArcGIS Pro - Joining Tables to Shapefiles
8:12
Forrest Bowlick
Рет қаралды 8 М.
Spatial Join - An ArcGIS Pro tutorial
13:35
Geography Viz
Рет қаралды 4,9 М.
Performing a spatial join in ArcGIS Pro
11:37
CWU Geography
Рет қаралды 17 М.
20 ArcGIS Pro Tips & Tricks
11:44
Spatial Zone
Рет қаралды 12 М.
Heatmaps in ArcGIS Pro
8:47
GeoDelta Labs
Рет қаралды 13 М.
ArcGIS Tools - Feature Compare Tool
13:08
GIS Chops
Рет қаралды 11 М.
Joins and Relates in ArcGIS
8:24
Geospatial Guy
Рет қаралды 16 М.
Importing an excel file and adding fields in ArcGIS Pro.
10:50
Dr. McKinnon's GIS Tutorials
Рет қаралды 20 М.
Survive 100 Days In Nuclear Bunker, Win $500,000
32:21
MrBeast
Рет қаралды 152 МЛН