topic Re: How do I link county names with a location? in Health and Human Services Questions https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40787#M18 <HTML><HEAD></HEAD><BODY><P>Are you displaying xy events from the csv?&nbsp;</P></BODY></HTML> Tue, 02 Jul 2019 16:31:37 GMT forestknutsen1 2019-07-02T16:31:37Z How do I link county names with a location? https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40786#M17 <HTML><HEAD></HEAD><BODY><P>Before I can ask my question I will provide some background.&nbsp; I am looking to map the number of medical doctors, primary doctors, otolaryngologists, and radiation oncologists for each county across the US.&nbsp; I split the large database I have into each of those categories.&nbsp; When I added the layers, several counties in CO and various ones on the east coast did not show up.&nbsp; I am unsure how they are missing as they are clearly included in the .csv file I used to add the layers.&nbsp; The missing counties are also in the layer table but not visible on the map.&nbsp; How can I get the 30ish missing counties to display with the other 3200??</P></BODY></HTML> Tue, 02 Jul 2019 16:05:07 GMT https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40786#M17 BlakeAlbright 2019-07-02T16:05:07Z Re: How do I link county names with a location? https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40787#M18 <HTML><HEAD></HEAD><BODY><P>Are you displaying xy events from the csv?&nbsp;</P></BODY></HTML> Tue, 02 Jul 2019 16:31:37 GMT https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40787#M18 forestknutsen1 2019-07-02T16:31:37Z Re: How do I link county names with a location? https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40788#M19 <HTML><HEAD></HEAD><BODY><P>No the csv has only the column of number of physicians, the county name (county, St) and the cooresponding FIPS code.&nbsp;</P></BODY></HTML> Tue, 02 Jul 2019 16:34:19 GMT https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40788#M19 BlakeAlbright 2019-07-02T16:34:19Z Re: How do I link county names with a location? https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40789#M20 <HTML><HEAD></HEAD><BODY><P>So, are you joining the csv to a feature class with counties?</P></BODY></HTML> Wed, 03 Jul 2019 19:52:06 GMT https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40789#M20 forestknutsen1 2019-07-03T19:52:06Z Re: How do I link county names with a location? https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40790#M21 <HTML><HEAD></HEAD><BODY><P>I suspect you have a typo for each of those counties; most likely an extra space either before or after the&nbsp;FIPS (or whatever you are using for the key).&nbsp;&nbsp;</P></BODY></HTML> Wed, 03 Jul 2019 20:43:24 GMT https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40790#M21 EileenAllen 2019-07-03T20:43:24Z Re: How do I link county names with a location? https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40791#M22 <HTML><HEAD></HEAD><BODY><P>Yep, that is what I was thinking as well.</P></BODY></HTML> Wed, 03 Jul 2019 22:09:47 GMT https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40791#M22 forestknutsen1 2019-07-03T22:09:47Z Re: How do I link county names with a location? https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40792#M23 <HTML><HEAD></HEAD><BODY><P>Yes, I eventually joined features with counties and the 30 missing counties still fail to show up. Today I mapped one of the missing counties (mineral county, CO) and it displayed in mineral County Nevada when using the name as the location key. I tried to use Fips codes again but I am not sure which item to chose from the drop down when I am importing the layer.</P><P></P><P>Get Outlook for iOS&lt;https://aka.ms/o0ukef&gt;</P></BODY></HTML> Wed, 03 Jul 2019 23:03:33 GMT https://community.esri.com/t5/health-and-human-services-questions/how-do-i-link-county-names-with-a-location/m-p/40792#M23 BlakeAlbright 2019-07-03T23:03:33Z