Can I display Zip Code points from CSV in WAB?

deleted-user-8zpXkQfV8bQC · ‎07-21-2016

I like the new 'Add Data' Widget in AGOL-WAB, but it wants to open from http: (URL). All I have is AGOL, desktop, and WAB site I created. I have a .csv file with a field called 'ZIP' and I have a feature class that has over 33,000 zip code centroids. What I would like to do, is load the .csv into the WAB site and have the zip code centroids appear as a symbol. I don't have a LAT/LON, just City, State, and Zip. No address. the .csv file changes daily as well. Any ideas are welcome. I know geoprocessing can work, I just cannot afford ArcGIS server. thank you

DanPatterson_Retired · ‎07-21-2016

a row or two would help describe visually your table.

Are you looking to geocode first?

Geocode Addresses—Help | ArcGIS for Desktop

assuming you don't have coordinates, since I am not sure what you mean by zip code centroids

deleted-user-8zpXkQfV8bQC · ‎07-21-2016

Dan,

No, I am not looking to geocode first. I don't have enough credits for AGOL. I get 2 or 3 of these csv files a day that I would like to load to my WAB site. They are operational or temporary layers.

Example of CSV file

ID Name City State ZIP

1 Pine Lake Lincoln NE 68512

2 Wahoo Wahoo NE 68066

3 Taylor Taylor NE 68879

I'd like to upload this csv file. Need to find the upload.

DanPatterson_Retired · ‎07-21-2016

that could be an issue if you don't have arcmap available to do the geocoding prior to upload. I know of no alternative to free geocoding

deleted-user-8zpXkQfV8bQC · ‎07-21-2016

Dan,

I appreciate the attempt. I am not asking for free geocoding, I am simply asking for a quick way to display a .CSV file with zip codes to place a symbol on zip code centroid - OR - a way in WAB to compare the .csv file with another table full of zip codes, find the matches, and display. I know in the MAP side of ArcGIS Online when creating the MAP before the APP, I can drop a .CSV file in the MAP with the zip code and symbols will appear it attempt to locate. It would be cool if I could DROP .CSV to WAB.

Appreciate the response.