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
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
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:
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.
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?
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.
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.