Selecting a list Census Block within a feature layer

201
3
10-15-2021 02:59 PM
Labels (1)
AnthonyB
New Contributor

I am a newbie to ARCGIS pro. 

I have a feature layer that includes every census block in the county and one of the attributes for each census block is a field of 15 digit numbers labeled GEOID10.   see sample below

FIDShapeSTATEFP10COUNTYFP10TRACTCE10BLOCKCE10GEOID10NAME10MTFCC10UR10UACE10FUNCSTAT10ALAND10AWATER10INTPTLAT10INTPTLON10
0Polygon191329021025190130029021025Block 1025G5040  S31623042.40741-92.2661
1Polygon191329021012190130029021012Block 1012G5040  S1714701042.41826-92.2374
2Polygon191329021067190130029021067Block 1067G5040  S42781042.38603-92.2455
3Polygon191329021017190130029021017Block 1017G5040  S219504042.41964-92.2722
4Polygon191329021100190130029021100Block 1100G5040  S24776042.35487-92.2973

 

In a separate spreadsheet I have a list of GEOID10  numbers that I would like to select out of the census block feature layer so that I can remove or better yet hide the rest of the census blocks in that feature layer. 

see sample list below

GEOID10
190130027004007
190130027004018
190130027004037
190130027004040
190130027004045
190130027004046

 

Can anyone help me out with this?  I have tried to add the sample list directly from a spreadsheet, but it reads the geoid's in like this:

GEOID10
1.90E+14
1.90E+14
1.90E+14
1.90E+14
1.90E+14
1.90E+14

 

This doesn't not make for a good list even start with much.  And so please let me know how to read the sample list in properly if that indeed needs to be in arcgis as well.

Thanks

0 Kudos
3 Replies
JoeBorgione
MVP Esteemed Contributor

I was working on the latest census data this past week.  Your spreadsheet is treating the GEOID as number; I thought that in the census data they are strings.

At any rate, what is the geoid10 you are referring to?  

can't wait to retire....
0 Kudos
AnthonyB
New Contributor

When I add the list as data it automatically treats it as a number.

So I have a whole list of geoid10's that each refer to an individual census block.  

And I want to remove or hide the blocks in the county that are not in that list of GEOID10's

Does that make sense?  So I'm after a specific list of census blocks not just one.

Thanks

0 Kudos
DavidPike
MVP Frequent Contributor

Try to play about with Text formatting in the xls, I know it doesn't always play friendly with arcgis, so try Excel To Table (Conversion)—ArcGIS Pro | Documentation 

The simplest thing to do is to add another column to our spreadsheet or table named something like 'visible' then put values of 'yes' in.

you'd then do a Join Add Join (Data Management)—ArcGIS Pro | Documentation whereby the 'visible' field value for matching GEOIDs would be 'yes'

Then a simple definition query whereby ,<YourField> == 'Yes'
Filter features with definition queries—ArcGIS Pro | Documentation

As Joe suggests, the key is initially to get this formatting issue sorted.