topic Re: How to create a zip code-based point layer on a map in App Development

How to create a zip code-based point layer on a map

daveatkins — Wed, 12 Jul 2023 21:49:49 GMT

I have a spreadsheet which contains demographic data on individuals including their zip code. I want to create a map with a point layer showing the number of people in each zip code with varying sized points based on the value of the column Meds? = 'Yes'.

I cannot get even the most basic map to work as it does not recognize "zip" as location data. When I drag the ZIP field onto a map chart, it's just a mess.

I tried to change the data type of the ZIP using the data manager, but after selecting "geo data" I much choose from one of four options for city or state data. There is no zip code option.

What do I need to do?

Re: How to create a zip code-based point layer on a map

RafaelBarrios — Thu, 13 Jul 2023 18:28:26 GMT

hi @daveatkins

try adding the country code after the postal code

field: <postal_code>,<country_code>

Example: 3857,CH for Switzerland

or use the postal code in location field and use country field to limit the scope

i used a fixed value in location field but you could use a field, same for country field.

Hope this helps,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!

Re: How to create a zip code-based point layer on a map

daveatkins — Thu, 13 Jul 2023 18:57:25 GMT

Thank you; I found several helping things to be done:

clean the zip code when loading data: Num([ZIP],'00000') as ZIP, for example to solve issues like zip code 02139 in Massachusetts.
The map chart layer will need a location field further specified as an expression like this to tell it the zip code is in the US: [ZIP] & ', US'
need to make sure the zip field is being recognized as geo data; still not clear how to do that in load script

Re: How to create a zip code-based point layer on a map

RafaelBarrios — Thu, 13 Jul 2023 19:06:23 GMT

Hi @daveatkins

1. Agreed, be sure you have the proper zip format for the country

2. Agreed, it the same I just commented, I would take out the white space before ‘US’

3. Can’t be sure, but if you see my screenshoot is a field called “location type” there you can tell the map that the field is a zip code, but I think it’s not going to be necessary

Hope this helps,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!