POST
|
Thanks for the update Peter, always a good thing to find out you aren't going crazy. We are customer #693.
... View more
05-29-2020
12:30 PM
|
1
|
0
|
2989
|
POST
|
Hey Graham, Yesterday when i checked a few of my layers in open data it looked like the HTML requirements had been revised as my data was displaying properly. Looking now all of my datasets are back to having their descriptions limited by the HTML tags. was something changed between yesterday and today?
... View more
05-27-2020
08:12 AM
|
0
|
2
|
1309
|
POST
|
Thanks Graham. What sucks is that ArcGIS Online itself is the one adding the Font and Bold tags. When I use the built in metadata editor in AGO these are being added. So ArcGIS Online is essentially formatting my description in a format that open data will not read.
... View more
05-22-2020
09:05 AM
|
0
|
4
|
1309
|
POST
|
Hi All, I'm using open data for the first time and im noticing that my nicely formatted description from a layer in arcgis online are not carrying over to the layer in open data. Its carrying bits and pieces and is making things very difficult to me. Is there a guide to formatting for open data? or does anyone know why this is happening? Here are some examples: AGO with nicely formatted description: https://usflibrary.maps.arcgis.com/home/item.html?id=8ab43e1433b54ff8ad050ab7c6477536
... View more
05-22-2020
08:43 AM
|
0
|
7
|
1386
|
POST
|
Hi All, I have a layer hosted in ArcGIS Online that ive been editing in ArcPro on a daily basis. The layer is a point layer with roughly 3000 features and maybe 15 fields. Recently ive found then when I go to save my edits in ArcGIS Pro and synchronize to the Online layer, it take between 20 and 40 minutes to finish saving. Is this how it should be? Ive never had a layer take this long to save. Not sure if this is related, but when i first bring the layer into ArcPro to edit, the ability to add a field is greyed out for some reason. Despite this, i can still navigate to the table ribbon and add a new field through there.... weird. Thanks, Ben
... View more
05-20-2020
02:08 PM
|
2
|
7
|
3107
|
POST
|
Hey Eric, It's actually the opposite of this that i'm trying to accomplish. I would like a view of a layer that is only attribute table, no feature geometry.
... View more
04-28-2020
05:45 AM
|
0
|
2
|
3718
|
POST
|
Is it possible to create a table view of a layer in arcgis online. I have a COVID-19 dataset that is private, I would like to use some of the attribute data in a dashboard without making the geometry data public. Therefore, i'm looking to create a table in arcgis online that updates when the private layer is updated but doesnt have any of the x/y information. Is this possible?
... View more
04-27-2020
03:13 PM
|
0
|
5
|
3895
|
POST
|
Hello, I'm administering ESRI Licensing for a large organization. Users access ArcPro through named user licenses. I want users to be able to take ArcPro offline (which i have enabled) but i dont see the options present that show how long a user can keep it offline without checking it back in. I dont wan't users to able to leave our organization but be able to keep access to ArcPro because they have an offline license. Thanks, Ben
... View more
04-23-2020
10:33 AM
|
0
|
1
|
635
|
POST
|
Hi All, I have a research group that is trying to deploy a Survey123 survey through a Hub. They plan on collecting personal data that will likely require them to follow HIPAA data guidelines. Is there a proper workflow for this? I'm assuming the data can't be stored in ArcGIS Online. Is there any other solution besides them deploying enterprise and deploying the survey through that? They don't have the resources or expertise to manage an enterprise deployment. Thanks, Ben
... View more
04-23-2020
09:48 AM
|
1
|
1
|
1345
|
POST
|
Yea i figured that this is the case, but i'm not aware of a way to tell AGO to label the Counts and Amounts instead
... View more
04-15-2020
07:37 AM
|
0
|
1
|
936
|
POST
|
I don't think you get the alignment settings if your feature is technically a polygon. I'm not seeing those options
... View more
04-15-2020
07:33 AM
|
1
|
0
|
936
|
POST
|
Hi All, I have a polygon layer where the symbology being used is "Counts and Amounts" (Different sized circles based on COVID-19 cases). I have this layer labeled to show the count of cases but i am having issues where the label is not appearing in the same location as the circle. See map link below. Is there anything i can do about this? I specifically have Charlotte and Brevard Counties where labeling is way off. I tried the beta map viewer and labeling is somehow worse. Map: https://usflibrary.maps.arcgis.com/home/webmap/viewer.html?webmap=f07da7d21e654c6c901bfecb339b5bc8 Map in my hub where labeling is worse: Florida COVID-19 Hub
... View more
04-15-2020
06:54 AM
|
0
|
5
|
992
|
DOC
|
Posting this here for additional visibility, it's also in the Coronavirus community.
Hi all!
My name is Benjamin Mittler and I am a GIS Manager working in the University of South Florida Libraries - Digital Heritage and Humanities Collections. Last week I was asked by Canserina Kurnia to create a blog post describing the process I used to create my Florida COVID-19 Time Series Application (which is also found on my Florida COVID-19 Hub). Below is the process I used, I hope some of you find it useful. Let me know if it seems like I left something out.
Creating a Time-Series Map of the COVID-19 Outbreak
I’m going start off this blog with the bad news, this isn’t going to be as easy as plugging Johns Hopkins or your state health department data into an application and pressing go. As you may have noticed by now, most COVID-19 feature services are providing data on current metrics and not including any archival information. This makes creating a time-series a lot more difficult, but still possible. Below are the steps I took in creating my time-series application.
Formatting Spreadsheet
Even though State health departments aren’t publishing archival data as a feature service, they are likely still publishing daily reports. If you are lucky these reports will be in spreadsheet format. I started out by creating a brand new excel spreadsheet with 3 columns; “Date”, “County”, and “Count” (count field represents total cases up to the listed date). I then went through each archival report, day by day, and copy/pasted information into my spreadsheet so that it looked like the below. You only need to include a county in the spreadsheet once it has its first case, no reason to include them if the case count is 0. Notice how for 3/1/2020 only Hillsborough and Manatee are listed, they are the only 2 counties with a case. Once a county appears in the spreadsheet it must appear for all subsequent days.
Excel to table
Using the “Excel to Table” tool in ArcPro, converted the excel table and place it in a geodatabase. At this point you need to find a polygon county layer for the state you are working in. Ensure that the county names match those used in your spreadsheet, and put a copy of this county layer in that same geodatabase. Add both the table and the counties layer to a map.
Make Query Table
Now it’s time to use my favorite tool “Make Query Table” (not kidding). This tool is going to perform a one-to-many join between your counties layer and the table, the output will be a temporary layer where each row in the table has now been assigned the geometry for its respective county. Start by opening the tool and setting the Input tables to your table and the counties layer. For fields select the Date, County, and Count field from the table and the .shape field from the counties layer. By including the .shape field you are telling the tool that you want the output to have a polygon geometry. Without including the .shape field your output would be a table. Add an expression where the county field from the table is equal to the county field from the polygon layer (you will need to switch the second dropdown from value to field). Set your output table name. EDIT: After some testing I have found that joining to a point county layer rather than polygon increases performance of the time-series app.
When the tool is finished running, immediately export the output to a new feature layer
Publishing the Layer
Right click the output from the previous step in your table of contents and select “Sharing” - > “Share as Web Layer”. Fill out the appropriate name, summary, and tags.
Next select “Configuration” and click the button for “Configuration Parameters”. Set the time zone settings to the appropriate time zone. This step is very important and can throw your entire dataset off if not done correctly. When you upload data to ArcGIS Online it will be assumed that your data is in the UTC timezone. When date-time is displayed in ArcGIS Online it is displayed in the viewers time-zone preferences. For instance, if you are in the Eastern Timezone and upload data to ArcGIS Online without setting the appropriate timezone, it will be displayed 5 hour earlier than what is designated in the attribute table. Since I didn’t specify time in my attribute table, this would like push my dates back to the previous day, very bad. Once the time zone is set you can go ahead and publish.
Enabling Time
Once the layer is finished publishing, click on the hosted feature layer within your table of contents in ArcGIS Online. Under layers select “Time Settings”. Choose to enable time setting and set the correct time field, click ok.
Create a View Layer
This next part is up to you but this is how I chose to set up my data. Because the COVID-19 pandemic is still ongoing the time series is going to have regular updates. In order to best accommodate this I chose to make this hosted feature layer editable but kept its share setting to private. I then created a view layer which is used in my public facing applications.
At this point your layer should be ready to go. You can open it up in a map and set the time setting as you see fit. More information on this can be found here: https://doc.arcgis.com/en/arcgis-online/create-maps/configure-time.htm. Personally, I chose to display my times series through a web app.
Maintaining the time series layer
As previously mentioned, the COVID-19 pandemic is still ongoing so your dataset will likely need to be updated on a daily basis. Luckily, this should be much easier than the process described above. Since state health departments are publishing daily case data, this can be used to update your time-series dataset. In ArcPro I built a model that exports case data from my states health department. The model then reformats my export to have the appropriate date, county, and count fields. Using ArcPro, I then append this data to my hosted feature layer and save it (may want to hit the “Enable Undo” box just in case). This process automatically updates the data being used within my web applications. IMPORTANT NOTE: ArcGIS Online will assume the data being appended is UTC, I could not find a way to tell it otherwise. You must manually offset your date field to account for this. I was only concerned with the date being correct (not time) so for me as long as the data had a timestamp after 5:00AM for the day I was fine.
... View more
04-09-2020
10:09 AM
|
0
|
1
|
2175
|
DOC
|
Hi Sara, Is the data you are downloading spatial data? if so you shouldn't need to rerun the Make query table and export part. In order to republish to ArcGIS Online from ArcPro, first make sure your ArcPro is signed in using your ArcGIS Online credentials (should show your name and your organization in the top right on ArcPro). Then go to View and open a Catalog Pane. Click Portal and drag your edit enabled time series layer in ArcPro. From there you can use the append tool to append your new updated info to your timeseries layer. Use field mapping in the append tool to ensure that the correct fields are matched up (enable undo just in case),run and hit save once you are done. Now go back to ArcGIS online and your layer should be updated
... View more
04-09-2020
10:04 AM
|
0
|
0
|
3977
|
DOC
|
Hi all! My name is Benjamin Mittler and I am a GIS Manager working in the University of South Florida Libraries - Digital Heritage and Humanities Collections. Last week I was asked by Canserina Kurnia to create a blog post describing the process I used to create my Florida COVID-19 Time Series Application (which is also found on my Florida COVID-19 Hub). Below is the process I used, I hope some of you find it useful. Let me know if it seems like I left something out. Creating a Time-Series Map of the COVID-19 Outbreak I’m going start off this blog with the bad news, this isn’t going to be as easy as plugging Johns Hopkins or your state health department data into an application and pressing go. As you may have noticed by now, most COVID-19 feature services are providing data on current metrics and not including any archival information. This makes creating a time-series a lot more difficult, but still possible. Below are the steps I took in creating my time-series application. Formatting Spreadsheet Even though State health departments aren’t publishing archival data as a feature service, they are likely still publishing daily reports. If you are lucky these reports will be in spreadsheet format. I started out by creating a brand new excel spreadsheet with 3 columns; “Date”, “County”, and “Count” (count field represents total cases up to the listed date). I then went through each archival report, day by day, and copy/pasted information into my spreadsheet so that it looked like the below. You only need to include a county in the spreadsheet once it has its first case, no reason to include them if the case count is 0. Notice how for 3/1/2020 only Hillsborough and Manatee are listed, they are the only 2 counties with a case. Once a county appears in the spreadsheet it must appear for all subsequent days. Excel to table Using the “Excel to Table” tool in ArcPro, converted the excel table and place it in a geodatabase. At this point you need to find a polygon county layer for the state you are working in. Ensure that the county names match those used in your spreadsheet, and put a copy of this county layer in that same geodatabase. Add both the table and the counties layer to a map. Make Query Table Now it’s time to use my favorite tool “Make Query Table” (not kidding). This tool is going to perform a one-to-many join between your counties layer and the table, the output will be a temporary layer where each row in the table has now been assigned the geometry for its respective county. Start by opening the tool and setting the Input tables to your table and the counties layer. For fields select the Date, County, and Count field from the table and the .shape field from the counties layer. By including the .shape field you are telling the tool that you want the output to have a polygon geometry. Without including the .shape field your output would be a table. Add an expression where the county field from the table is equal to the county field from the polygon layer (you will need to switch the second dropdown from value to field). Set your output table name. When the tool is finished running, immediately export the output to a new feature layer Publishing the Layer Right click the output from the previous step in your table of contents and select “Sharing” - > “Share as Web Layer”. Fill out the appropriate name, summary, and tags. Next select “Configuration” and click the button for “Configuration Parameters”. Set the time zone settings to the appropriate time zone. This step is very important and can throw your entire dataset off if not done correctly. When you upload data to ArcGIS Online it will be assumed that your data is in the UTC timezone. When date-time is displayed in ArcGIS Online it is displayed in the viewers time-zone preferences. For instance, if you are in the Eastern Timezone and upload data to ArcGIS Online without setting the appropriate timezone, it will be displayed 5 hour earlier than what is designated in the attribute table. Since I didn’t specify time in my attribute table, this would like push my dates back to the previous day, very bad. Once the time zone is set you can go ahead and publish. Enabling Time Once the layer is finished publishing, click on the hosted feature layer within your table of contents in ArcGIS Online. Under layers select “Time Settings”. Choose to enable time setting and set the correct time field, click ok. Create a View Layer This next part is up to you but this is how I chose to set up my data. Because the COVID-19 pandemic is still ongoing the time series is going to have regular updates. In order to best accommodate this I chose to make this hosted feature layer editable but kept its share setting to private. I then created a view layer which is used in my public facing applications. At this point your layer should be ready to go. You can open it up in a map and set the time setting as you see fit. More information on this can be found here: https://doc.arcgis.com/en/arcgis-online/create-maps/configure-time.htm. Personally, I chose to display my times series through a web app. Maintaining the time series layer As previously mentioned, the COVID-19 pandemic is still ongoing so your dataset will likely need to be updated on a daily basis. Luckily, this should be much easier than the process described above. Since state health departments are publishing daily case data, this can be used to update your time-series dataset. In ArcPro I built a model that exports case data from my states health department. The model then reformats my export to have the appropriate date, county, and count fields. Using ArcPro, I then append this data to my hosted feature layer and save it (may want to hit the “Enable Undo” box just in case). This process automatically updates the data being used within my web applications. IMPORTANT NOTE: ArcGIS Online will assume the data being appended is UTC, I could not find a way to tell it otherwise. You must manually offset your date field to account for this. I was only concerned with the date being correct (not time) so for me as long as the data had a timestamp after 5:00AM for the day I was fine.
... View more
04-07-2020
12:23 PM
|
5
|
4
|
4285
|
Title | Kudos | Posted |
---|---|---|
1 | 11-13-2018 10:18 AM | |
1 | 02-13-2019 08:32 AM | |
1 | 12-04-2023 09:21 AM | |
2 | 10-26-2023 08:41 AM | |
1 | 08-23-2023 09:51 AM |
Online Status |
Offline
|
Date Last Visited |
04-03-2024
04:57 PM
|