{"id":276942,"date":"2021-11-11T09:52:35","date_gmt":"2021-11-11T17:52:35","guid":{"rendered":"http:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=276942"},"modified":"2021-11-11T09:52:35","modified_gmt":"2021-11-11T17:52:35","slug":"how-to-author-a-feature-layer-to-show-current-in-last-xx-days-or-previous-locations-in-arcgis-pro-and-share-as-a-map-service","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/mapping\/how-to-author-a-feature-layer-to-show-current-in-last-xx-days-or-previous-locations-in-arcgis-pro-and-share-as-a-map-service","title":{"rendered":"How to author a feature layer to show current ( ‘in last xx days’ ) or previous locations in ArcGIS Pro and share as a map service"},"author":5971,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[22941],"tags":[525722,762772,762742,762752,762762],"industry":[],"product":[36571],"class_list":["post-276942","blog","type-blog","status-publish","format-standard","hentry","category-mapping","tag-earthquakes","tag-historic","tag-in-last-query","tag-latest","tag-previous","product-arcgis-enterprise"],"acf":{"short_description":"Blog shows how to use just one layer to display latest\/current locations by default and switch it to mode to play back all previous locations","flexible_content":[{"acf_fc_layout":"content","content":"

Show me features from ‘last x number of days’ is a very common workflow especially with datasets that keep updating frequently. Earthquakes, sales, traffic volumes, crimes etc. are some examples where data gets updated daily or hourly or at an irregular frequency.<\/p>\n

For this exercise, let’s assume we have a global earthquakes data that keeps growing. And to keep it simple, the feature layer points to a dataset that have earthquakes that are recorded for the entire year. Viewing one year worth of data on a map is too much information. Instead we usually want to see only earthquakes recorded in last 24 hours or last 7 days or last month without needing to modify the query\/filter every time<\/strong>.<\/p>\n

How can we do that?<\/h2>\n

This part is actually pretty simple:<\/p>\n

    \n
  1. Add the feature layer in a map in ArcGIS Pro.<\/li>\n
  2. Open the layer’s Properties<\/strong> page and switch to the Definition Query<\/strong> page.<\/li>\n
  3. Click New definition query<\/strong>.<\/li>\n
  4. Pick the date<\/em> field<\/em> from the fields<\/em> drop down list.<\/li>\n
  5. Select is after<\/strong> from the operator<\/em> drop down box.<\/li>\n
  6. Click SQL<\/strong> from the upper right corner to switch to the sql mode.
    \n\"\"<\/li>\n
  7. An incomplete clause like the one below will be shown.
    \n\"\"<\/li>\n
  8. Pick an expression from the table below that is appropriate for your data source and enter that in the text box right after the ‘>’ sign. Make sure to have a space in between<\/em>.
    \n\n\n\n\n\n\n\n
    Database platform<\/strong><\/th>\nExpression<\/strong><\/th>\n<\/tr>\n
    File geodatabase<\/td>\nCURRENT_DATE \u2010 7<\/code><\/td>\n<\/tr>\n
    PostgreSQL<\/td>\nCURRENT_TIMESTAMP \u2010 INTERVAL '7 days'<\/code><\/td>\n<\/tr>\n
    SQL Server<\/td>\nDATEADD(dd, \u2010 7, getdate())<\/code><\/td>\n<\/tr>\n
    Oracle<\/td>\nCURRENT_DATE \u2010 INTERVAL '7' DAY<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Note: if you copy\/paste from this above table, you might need to delete the dash and single quotes characters, and retype in.<\/i><\/li>\n

  9. It should look something like this
    \n\"\"<\/li>\n
  10. Click Apply<\/strong> followed by OK<\/strong> button to apply this dynamic definition query to your feature layer.<\/li>\n<\/ol>\n

    Now we have got a layer that will always show earthquakes that occurred in last 7 days.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1397472,"id":1397472,"title":"earthquakes_last7days","filename":"earthquakes_last7days.png","filesize":109390,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/earthquakes_last7days.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-enterprise\/mapping\/how-to-author-a-feature-layer-to-show-current-in-last-xx-days-or-previous-locations-in-arcgis-pro-and-share-as-a-map-service\/earthquakes_last7days","alt":"","author":"5971","description":"","caption":"","name":"earthquakes_last7days","status":"inherit","uploaded_to":276942,"date":"2021-11-11 06:44:51","modified":"2021-11-11 06:44:51","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":600,"height":305,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/earthquakes_last7days-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/earthquakes_last7days.png","medium-width":464,"medium-height":236,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/earthquakes_last7days.png","medium_large-width":600,"medium_large-height":305,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/earthquakes_last7days.png","large-width":600,"large-height":305,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/earthquakes_last7days.png","1536x1536-width":600,"1536x1536-height":305,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/earthquakes_last7days.png","2048x2048-width":600,"2048x2048-height":305,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/earthquakes_last7days.png","card_image-width":600,"card_image-height":305,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/earthquakes_last7days.png","wide_image-width":600,"wide_image-height":305}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

    Looking back in the past<\/h2>\n

    Let’s make it a bit more interesting. The feature layer has data for the entire year. Because I have the ‘last 7 days’ definition query set to the layer, I can’t view\/query any feature outside that filter. Of course, one option is to remove (or temporary turn off the definition query<\/a>), and apply another definition query for the time period that I need. But that won’t give good user experience, and when I will share, I might need to create multiple layers (see the very last section below<\/em>).<\/p>\n

    Good news is that there is a better option available now. Only gotcha is that you must have your data copied in an enterprise database. This will allow me to:<\/p>\n