Latest Contributions by TanuHoque

@StefanoAngarano  Sorry to reopen an old post. I see @KellyGerrow referred to a blog post where it mentioned about aggregating features in hexagon bin. I think that would work fine with large datasets with hundreds of thousands or even million of features (depending on the backend database). I was wondering why you would prefer cluster approach over aggregated-in-hexagon-bins? I'd appreciate your thoughts on this. Tanu ... View more

In a print service created from ArcMap, I just need to add a template mxd to the registered folder and stop and start the service for a new template to show up. @MichaelVolz I believe that only works for the print service that comes out of the box when you install ArcGIS Server/Enterprise prior to 10.6.1 release. When you publish a new print service from ArcMap, the template names get burnt into the service - therefore adding a new mxd in the Layout Template Folder won't make print service pick up new templates. You need to republish. Only time you won't need to republish is when you update an existing .mxd and the service is published by reference (i meant when mxd files don't get copied to the server during publishing process).   In a print service created from Pro, do I really need to republish the service to see a new pagx template in the registered folder as opposed to just stopping and starting the custom print service? Yes, that is true.         ... View more

@GCPSFAdmin  sorry for some reasons I didn't see the notification for your comment. If you copy/pasted the string from the blog, then I could see why that could fail. The double-quotes were somehow messed up (I have fixed that in the blog too). please try this and let me know if it still does not work   { "preferredTimeReference" : { "timeZone" : "AUS Eastern Standard Time", "respectsDaylightSaving" : true } }     ... View more

@PatSmyth  yes, that is correct. you need to update your server to 10.7 or higher. And then use ArcGIS Pro 2.3 or higher to publish your service from. ... View more

hi @KennethBusby  Sorry to resurrect this year and half old post. I was doing some research and ran into this. I was wondering how your use case is different from the original post? In both case, it is all about filtering features using related records, right? Sorry it looks like I missed something very obvious. Thanks Tanu ... View more

I somehow stumbled on this post from late last year. I thought I should provide another solution to this problem for folks from the future 🙂 Pros: the benefit of this approach is that this dynamic. When new data comes in, it will continue to work without you doing anything. Cons: you must use enterprise database. FileGDB won't work. finally the sql that I provided below is not a very elegant one. I put that together quickly and also helps you understand what is going on in this nested fashion.   Let's take a look at the output first: Black dots represents the original vessel's positions in the screenshot below. Red circles, off a different layer, show positions with some temporal gaps. Imagine you group the original locations (black dots) into bins/buckets of 5 min interval. Then pick up first ones (red circles) from each group. That is what I did here.   How to: first you must copy data in an enterprise database (in my case I copied them in a SQL Server) i used the data attached in the previous comment click Query Layer from Add Data dropdown in Map tab in ArcGIS Pro choose your database connection provide a name paste the following SQL (this is for SQL Server, and should work with other database flavors too) select objectid, datetimestamp, mmsi, latitude, longitude, shape from ( select *, rank() over (partition by elapsed_time_group order by datetimestamp) as rnk from ( select *, DATEDIFF(second, FIRST_VALUE(datetimestamp) over(order by datetimestamp), datetimestamp) / 300 as elapsed_time_group from VESSELTRACK_MMSIPOINTS ) a ) b where b.rnk = 1​ click Validate click Next make sure the correct field is chosen as the Unique Identifier Fields(s) aka the object-id field make sure the Geometry type and spatial reference is picked correctly. Otherwise choose one. click Finish a query layer gets added to your map   Problem with this SQL is that it produces a result where a few positions are still very close together (see the screenshots below). That is because positions are not recorded at a regular frequency.   To weed out those points too, I have added an additional filter in the SQL - see below.   select objectid, datetimestamp, mmsi, latitude, longitude, shape from ( select *, datediff(minute, lag(datetimestamp) over (order by datetimestamp), datetimestamp) as time_diff from ( select objectid, datetimestamp, mmsi, latitude, longitude, shape from ( select *, rank() over (partition by elapsed_time_group order by datetimestamp) as rnk from ( select *, DATEDIFF(second, FIRST_VALUE(datetimestamp) over(order by datetimestamp), datetimestamp) / 300 as elapsed_time_group from VESSELTRACK_MMSIPOINTS ) a ) b where b.rnk = 1 ) c ) d where d.time_diff > 2 or d.time_diff is null     here is the output where green circles represents a cleaner version of the previous one.   Hope some folks might find this helpful in the future 🙂 ... View more

for the standalone server case - I don't see any option to overwrite a gp service in Pro (I need to double check with the relevant team).  I checked with the team. Unfortunately this is how it is right now. There are no options to overwrite a gp service off a standalone server as of Pro 2.7. ... View more

@MichaelVolz    when you have more than 1 map frames in your layout, print service needs to know which one to update. In ArcMap world, there was a concept of active dataframe. We don't have that in Pro realm, as a result you need to tell print service which map frame to update by naming one map frame "WEBMAP_MAP_FRAME" please see the first bullet in 'Considerations when preparing your layouts' section in this help below: https://enterprise.arcgis.com/en/server/latest/create-web-apps/windows/tutorial-publish-additional-layouts-for-printing-with-arcgis-pro.htm   Is this true for both standalone server as well as a federated server? yes, that is true in both case - that issue has nothing to do with how your server is configured.   hope this helps. pls let me know if you have any questions.   ... View more

on #2: This process works for some layouts, but other layouts with items such as Overview maps are generating errors when used in a web app. did you try exporting layouts with overview to pdf/png from Pro?   also, set the print service error level to Info and see whether you get any informative error message returned by your print service.       ... View more

@MichaelVolz    on #1: did you try the overwrite options? for sharing in a portal,   for the standalone server case - I don't see any option to overwrite a gp service in Pro (I need to double check with the relevant team). Having said that we can always take the workaround approach i.e. delete the service in the Manager site and republish. I know it is a pain 😞     ... View more

Thanks @Noah-Sager for quick response. @LarsDe_Sloover  can you pls share your repro steps/webmap etc. with us? I can take a look. thanks ... View more

@AngeloTaylor2  did you happen to check out the following blogs? We do have capabilities in Pro similar to what you are asking for. I admit creating such layer is not an easy user experience - we are working on making the authoring such layers better. Having said that I'd appreciate if you could check out this capability, and let me know what you find missing. https://www.esri.com/arcgis-blog/products/arcgis-pro/mapping/dynamic-spatiotemporal-exploratory-analysis-with-aggregated-results-using-time-series-data-in-arcgis/ https://www.esri.com/arcgis-blog/products/arcgis-pro/mapping/transform-aggregated-time-series-results-into-polygons-in-arcgis/ https://www.esri.com/arcgis-blog/products/arcgis-pro/mapping/dynamic-aggregate-points-within-polygon-features-for-exploratory-analysis/ Thanks Tanu ... View more

Hi @DSIProvince_Nord,   Could you pls share some screenshots to describe your problems? If you happen to have your web app/map public, that'd be great too.   thanks Tanu ... View more