{"id":1392752,"date":"2021-11-10T13:32:53","date_gmt":"2021-11-10T21:32:53","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1392752"},"modified":"2021-11-10T13:32:53","modified_gmt":"2021-11-10T21:32:53","slug":"generate-trajectories-paths-for-hurricanes-on-the-fly-from-their-point-locations","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/generate-trajectories-paths-for-hurricanes-on-the-fly-from-their-point-locations","title":{"rendered":"Generate trajectories\/paths for hurricanes on the fly from their point locations"},"author":5971,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23341,22941],"tags":[34611,762692,25511,762682],"industry":[],"product":[36561],"class_list":["post-1392752","blog","type-blog","status-publish","format-standard","hentry","category-analytics","category-mapping","tag-hurricane","tag-path","tag-time-slider","tag-trajectory","product-arcgis-pro"],"acf":{"authors":[{"ID":5971,"user_firstname":"Tanu","user_lastname":"Hoque","nickname":"Tanu Hoque","user_nicename":"mahoque","display_name":"Tanu Hoque","user_email":"ahoque@esri.com","user_url":"","user_registered":"2018-03-02 00:17:50","user_description":"Tanu is a product engineer on Esri Mapping Team focusing on map service, print service, and ArcGIS Pro. He also works on spatio-temporal analysis, spatial aggregation and real-time data. Tanu\u2019s background includes a masters in Urban Planning from University of Akron, Ohio, USA and a bachelor degree from Khulna University, Bangladesh, and worked as GIS Coordinator in City of West Springfield, and GIS Specialist in a hydrology modeling center in Bangladesh before joining Esri.","user_avatar":""}],"short_description":"This blog describes a method to create lines from point features on the fly using enterprise database capabilities.","flexible_content":[{"acf_fc_layout":"content","content":"

This blog is more of a hands-on tutorial. If you want to know more on the concept etc., please read this blog<\/a> that I wrote a while back.<\/p>\n

One important point before we begin, you must have an enterprise database such as PostgreSQL, SQL Server, Oracle etc. The function that I’m using below to generate line from points is specific to SQL Server. The SQL statements in general should work for other databases expect for that function. Please consult to your database help to find the equivalent one.<\/em><\/p>\n

Let’s dive in…<\/p>\n

Overview:<\/h1>\n

Let’s start by opening a layer package (https:\/\/arcg.is\/1H9vT8<\/a>) in ArcGIS Pro. When it is opened, you will see some points on the map.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1393612,"id":1393612,"title":"hurricaneLocations_small","filename":"hurricaneLocations_small.png","filesize":38720,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricaneLocations_small.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/generate-trajectories-paths-for-hurricanes-on-the-fly-from-their-point-locations\/hurricanelocations_small","alt":"","author":"5971","description":"","caption":"Hurricane locations symbolized by strength","name":"hurricanelocations_small","status":"inherit","uploaded_to":1392752,"date":"2021-11-09 00:39:54","modified":"2021-11-09 00:40:02","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":399,"height":304,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricaneLocations_small-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricaneLocations_small.png","medium-width":343,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricaneLocations_small.png","medium_large-width":399,"medium_large-height":304,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricaneLocations_small.png","large-width":399,"large-height":304,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricaneLocations_small.png","1536x1536-width":399,"1536x1536-height":304,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricaneLocations_small.png","2048x2048-width":399,"2048x2048-height":304,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricaneLocations_small.png","card_image-width":399,"card_image-height":304,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricaneLocations_small.png","wide_image-width":399,"wide_image-height":304}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

First thing we want to do is to generate lines from all point features belong to each hurricane just like below.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1393622,"id":1393622,"title":"hurricanePaths_small","filename":"hurricanePaths_small.png","filesize":37321,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/generate-trajectories-paths-for-hurricanes-on-the-fly-from-their-point-locations\/hurricanepaths_small","alt":"","author":"5971","description":"","caption":"Hurricane paths generated on the fly from the point shown above","name":"hurricanepaths_small","status":"inherit","uploaded_to":1392752,"date":"2021-11-09 00:39:55","modified":"2021-11-09 00:40:09","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":399,"height":304,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small.png","medium-width":343,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small.png","medium_large-width":399,"medium_large-height":304,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small.png","large-width":399,"large-height":304,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small.png","1536x1536-width":399,"1536x1536-height":304,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small.png","2048x2048-width":399,"2048x2048-height":304,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small.png","card_image-width":399,"card_image-height":304,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small.png","wide_image-width":399,"wide_image-height":304}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Second, we will make the layer a time aware layer and generates lines using only points from any time range.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1393642,"id":1393642,"title":"hurricanePaths_small_ani2","filename":"hurricanePaths_small_ani2.gif","filesize":225504,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small_ani2.gif","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/generate-trajectories-paths-for-hurricanes-on-the-fly-from-their-point-locations\/hurricanepaths_small_ani2","alt":"","author":"5971","description":"","caption":"Paths are generated dynamically for each time step. Dots are draw as a separate layer just for a reference.","name":"hurricanepaths_small_ani2","status":"inherit","uploaded_to":1392752,"date":"2021-11-09 00:45:31","modified":"2021-11-09 00:49:19","menu_order":0,"mime_type":"image\/gif","type":"image","subtype":"gif","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":399,"height":303,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small_ani2-213x200.gif","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small_ani2.gif","medium-width":344,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small_ani2.gif","medium_large-width":399,"medium_large-height":303,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small_ani2.gif","large-width":399,"large-height":303,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small_ani2.gif","1536x1536-width":399,"1536x1536-height":303,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small_ani2.gif","2048x2048-width":399,"2048x2048-height":303,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small_ani2.gif","card_image-width":399,"card_image-height":303,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_small_ani2.gif","wide_image-width":399,"wide_image-height":303}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Finally, we will compute some statistics such as current wind speed, min\/max wind speed during that period, and number of points used to generate each line.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1393702,"id":1393702,"title":"hurricanePaths_label_small_ani2","filename":"hurricanePaths_label_small_ani2.gif","filesize":384638,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_label_small_ani2.gif","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/mapping\/generate-trajectories-paths-for-hurricanes-on-the-fly-from-their-point-locations\/hurricanepaths_label_small_ani2","alt":"","author":"5971","description":"","caption":"Labels showing some dynamically computed statistics results","name":"hurricanepaths_label_small_ani2","status":"inherit","uploaded_to":1392752,"date":"2021-11-09 01:03:02","modified":"2021-11-09 01:04:09","menu_order":0,"mime_type":"image\/gif","type":"image","subtype":"gif","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":400,"height":304,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_label_small_ani2-213x200.gif","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_label_small_ani2.gif","medium-width":343,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_label_small_ani2.gif","medium_large-width":400,"medium_large-height":304,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_label_small_ani2.gif","large-width":400,"large-height":304,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_label_small_ani2.gif","1536x1536-width":400,"1536x1536-height":304,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_label_small_ani2.gif","2048x2048-width":400,"2048x2048-height":304,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_label_small_ani2.gif","card_image-width":400,"card_image-height":304,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/11\/hurricanePaths_label_small_ani2.gif","wide_image-width":400,"wide_image-height":304}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Create lines from points on the fly:<\/h1>\n
    \n
  1. Use Feature Class to Feature Class<\/a> (or right-click the layer in ArcGIS Pro Contents pane and choose Data | Export Features) geoprocessing tool to export all features in a feature class inside an enterprise database.\n