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
FID | Shape | STATEFP10 | COUNTYFP10 | TRACTCE10 | BLOCKCE10 | GEOID10 | NAME10 | MTFCC10 | UR10 | UACE10 | FUNCSTAT10 | ALAND10 | AWATER10 | INTPTLAT10 | INTPTLON10 |
0 | Polygon | 19 | 13 | 2902 | 1025 | 190130029021025 | Block 1025 | G5040 | S | 31623 | 0 | 42.40741 | -92.2661 | ||
1 | Polygon | 19 | 13 | 2902 | 1012 | 190130029021012 | Block 1012 | G5040 | S | 1714701 | 0 | 42.41826 | -92.2374 | ||
2 | Polygon | 19 | 13 | 2902 | 1067 | 190130029021067 | Block 1067 | G5040 | S | 42781 | 0 | 42.38603 | -92.2455 | ||
3 | Polygon | 19 | 13 | 2902 | 1017 | 190130029021017 | Block 1017 | G5040 | S | 219504 | 0 | 42.41964 | -92.2722 | ||
4 | Polygon | 19 | 13 | 2902 | 1100 | 190130029021100 | Block 1100 | G5040 | S | 24776 | 0 | 42.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
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.
Thanks
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.