Latest Contributions by LarryMcEvoy

When using clip layers to clip to the outline of a feature in ArcGIS Pro 2.4 the layout and map tabs show results as expected screen grab below.  But when printing or exporting the map the clipping layer is not honored is there a setting I am missing or is this expected behavior. ... View more

Hi I am trying to replicate a workflow that I had in ArcMAP 10.2.2 using ArcGIS Pro 2.3.3, I have a table with native SQL geometry stored in SQL server 2008 10.0.6241.0. I load this table up as a query layer I then need to select all the polygons from this query layer contained within a geometry stored in a SDE versioned feature class (located on the same SQL server with the geometry also stored in native SQL server format). This works perfectly in arcmap 10.2.2 using the select by location tool. When I try the same process in PRO the resulting selection appears to be random with some polygons 10's of km's outside of the selecting polygon. I can apply a definition query which visually returns the right results using this SQL Syntax                    ref in (select rtrim(ref)from databasename.databaseuser.querylayertablename a                  inner join (select shape from databasename.databaseuser.selectingtablemultiversionedview_EVW                  where id=17) b                  on a.geom.STIntersects(b.Shape)=1) (this also works in SQL Server Management Studio) unfortunately although the visual representation is correct, the attribute table fails to open as it errors with a Failed to parse the where clause error. Anybody else experience a similar issue or aware of a fix? Ta Larry ... View more

Hi all, I'm not a developer but do have to write the odd bit of code to automate output. I have written a script which uses an mxd which has 3 data frames with different basemaps and some textual information which serves as a template to produce a pdf. I have written a script (attached) which loops through the sites of interest zooms to the extent, adjusts the scale to a set scale and then populates the textual information including two tables by doing an intersection with a point and polygon feature class. It all works ok but tends to crash out in or around the 80th site that it hits. I thought at first it was a memory leak, hence all the del()'s but when I checked it out in the resource monitor I found memory consumption was low but the thread count is incrementing by 3 or 4 every time it loops. Anybody any ideas on why this might be happening or a workaround to fix. Thanks in advance Larry ... View more