search

Esri / air-c2-cop-python

A collection of scripts and files necessary for the creation of the Defense Solutions Air C2 COP project.
Apache License 2.0
5 stars 7 forks source link

"Airspace Control Means - Use" contains time field in string which should be changed to "date" type. #140

Open jfrygeo opened 8 years ago

jfrygeo commented 8 years ago

The "Airspace Control Means - Use" feature class in the "AirC2_ACO_Use.mxd" contains the time fields in format of "string" rather than "date" type. When published as a feature service, and brought into a web map, this time enabled layer does not show. When time is not enabled in the web map, the layer appears.

Esri support articles indicate: "ArcMap appears to recognize text fields as date for enabling time, but AGOL will not. Once we created a new date field and used field calculator to copy the values over, we were able to enable this without a problem."

New fields need to be created in the feature class that are of "date" format.

┆Issue is synchronized with this Asana task

jfrygeo commented 8 years ago

The problem is actually with the joined table "AirC2_ACO_Period."

In order to fix:

-Remove locks from the sde on that table -delete rows in table -delete "period_from" and "period_to" columns -create 2 "date" type fields in that table, name one "period_from" and the other "period_to" -run "Process Airspace Control Order" -validate there are items in the table and in the joined feature class "Airspace Control Means-Use" -Fix time in ArcMap -Republish layers to Portal for ArcGIS