Select to view content in your preferred language

Join PLSS narrative description to PLSS FIRSTDIVID

172
2
Jump to solution
11-05-2025 08:21 AM
Labels (2)
AvaFarouche
Frequent Contributor

Greetings,

I'm stumped on this and wonder if anyone can just point me in the right direction. Thanks in advance!

I have a csv to excel table that includes a narrative PLSS land description attribute, i.e., "CO T. 34 N., R. 5 W., New Mexico Principal, Sec. 22". I need to map these parcels. But I am stuck on how to do this. I have the PLSS shapefile to join this data to, but I don't know how to do this practically.

The PLSS shapefiles themselves of course do not include a narrative description that I can directly join to. The field I want to use is the FIRSTDIVID of the PLSS shapefile. The FIRSTDIVID entry "CO230340N0050W0SN220" corresponds to the narrative land description "CO T. 34 N., R. 5 W., New Mexico Principal, Sec. 22".  

So what's the process I need to use to get those two fields to match up and join? I thought there might be a way to geolocate the land description and then do a spatial join, but I haven't found a Locator for PLSS descriptions. There's probably a way to create the FIRSTDIVID attribute in excel from the land description before importing it into Pro? Or do I need to learn Python to create a new field that translates the narrative into the alphanumeric?

If anyone can just point me in the right direction I can hopefully figure out the details from there. I know this is an unconventional post here but I am stumped. This is probably something I should know but, well, I don't!

Thanks!!

 

0 Kudos
1 Solution

Accepted Solutions
ThomasHoman
Frequent Contributor

Perhaps use excel Textsplit function to explode via space character. Then excel concatenate after massaging data to reassemble

View solution in original post

0 Kudos
2 Replies
ThomasHoman
Frequent Contributor

Perhaps use excel Textsplit function to explode via space character. Then excel concatenate after massaging data to reassemble

0 Kudos
AvaFarouche
Frequent Contributor

Thanks for the suggestion!! I'm afraid it's going to be something like this. I was able to get ahold of someone who's accomplished this task and she reiterated a few times that it's very complicated, and involves multiple shapefiles, along with database and programming knowledge that I do not have, and involving steps similar to what you mention. I'm going to have to up my game. Thanks again!

0 Kudos