The dataset provided, for Exercise 2(Create a time-enabled feature layer) in Chapter 6 in the 5th edition of Getting to know WebGIS, covers the years 1790 to 2000. There is a glitch in the resulting slider as it skips the year 1950. I believe this has to do with excel not recognizing dates prior to the year 1900. I attempted a workaround where I added 110 years to all the dates, (so all the data is from after 1900) and this solved the skip. It works straight through except the data waits 11 decades to begin, or rather, nothing shows up in the slider for the first 11 periods.
Any thoughts on my workaround's potential to have the slider start showing the data immediately, labeled correctly where a slider showing the year 1790 is actually showing 1790 data? Or is there a different way to fix this? I’m not sure on configuring but the original data file includes the following columns: Rank, City, Population, Year, PopDate, Longitude, and Latitude. The PopDate column is formatted as dates for the years 1900 to 2000 but has a general number format for the years before 1900. The Year column is formatted with general numbers.
The following links are for:
My Version 1 – skips 1950
https://palomar.maps.arcgis.com/apps/instant/slider/index.html?appid=4e8a98c5cc3e4c64a7c936f376ee1bc...
My Version 2 – doesn’t skip, but starts in 1900 showing 1790 data
https://palomar.maps.arcgis.com/apps/instant/slider/index.html?appid=10d11a93d8a04f398858f82ae1f4566...
