topic Re: Selecting a list Census Block within a feature layer in ArcGIS Pro Questions

Selecting a list Census Block within a feature layer

AnthonyB — Fri, 15 Oct 2021 21:59:56 GMT

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

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

Re: Selecting a list Census Block within a feature layer

JoeBorgione — Fri, 15 Oct 2021 22:37:37 GMT

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?

Re: Selecting a list Census Block within a feature layer

AnthonyB — Sat, 16 Oct 2021 03:39:45 GMT

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

Re: Selecting a list Census Block within a feature layer

DavidPike — Sat, 16 Oct 2021 18:32:11 GMT

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.