Latest Contributions by DavidPike

Found this for posterity https://support.esri.com/en-us/knowledge-base/faq-what-are-the-reserved-words-for-esris-file-geodatab-000010906 When you open the attribute table it's running a SQL query against the database (FGDB) (I think!).  GROUP is a reserved SQL keyword and probably causing a syntax error which there was no explicit error handling for (considering that FME is an unknown variable).  Just my musings however. ... View more

Probably the most foolproof method is to repeat the select by attribute queries and then switch the selection when all of 'B, C' are selected - this will then select the remainder which are not 'B, C' types. https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/select-layer-by-attribute.htm - for the first query, use NEW_SELECTION.  For subsequent queries use ADD_TO_SELECTION.  When all the features are selected you then switch/reverse/invert the selection    https://pro.arcgis.com/en/pro-app/latest/help/mapping/navigation/work-with-selected-features.htm Switch the selection. To deselect all the selected features and select all the deselected ones, right-click the layer in the Contents pane, point to Selection, and click Switch Selection  Another option would be to take your original queries and alter the sql select statement to do the opposite (I've not checked the syntax below )   -- 'B' type query example Animal = 'Dog' -- 'C' type query example Animal = 'Cat' -- Select all remaining example Animal <> 'Dog' AND Animal <> ' Cat' --another way: Animal NOT IN ('Cat', 'Dog')   ... View more

Do you have OBJECTIDs?  Might be struggling to query the data without a primary key.  Any potentially reserved SQL or ArcGIS names for the Excel columns?  Did the original data participate in a join and didn't come across?  ... View more

Think you have to set your Workspace for ListRasters().  At the moment it's probably returning nothing.  ... View more

1. https://desktop.arcgis.com/en/arcmap/latest/tools/analysis-toolbox/tabulate-intersection.htm would be the ideal tool for the land cover details per LSOA. 2. https://desktop.arcgis.com/en/arcmap/latest/tools/analysis-toolbox/tabulate-intersection.htm again would accomplish this simply.  a spatial join can also be used https://desktop.arcgis.com/en/arcmap/latest/tools/analysis-toolbox/spatial-join.htm but I'd just stick with tabulate intersection. ... View more

Ah I've tried this and it's creating a view of the original data, this is strange functionality which I can't see as clearly documented.  So please ignore my previous posts (which I'm sure is easily done!).  ... View more

If you Save As, it wont automatically add into the Map.  You should find the new 'Save As' layers if you go to your content, or you can add the newly saved layer into your Map if you browse for it using Add Data.   ... View more

What type of layer is it?  Click on the ellipsis/breadcrumb '...' then there should be a 'Save as' option.  Or is it greyed-out?   ... View more

Not an expert opinion, but this page https://pro.arcgis.com/en/pro-app/3.0/get-started/overview-of-named-user-licensing-in-arcgis-enterprise.htm seems to indicate that the Portal validates the license can be granted and then passes a certificate/key back to ArcGIS Pro (user).  Pro then directly contacts the license server to check out a license using that authorisation key.  In that scenario I would say that yes, access to the License Server is required via your Intranet/VPN etc. ... View more

This can certainly be done in Pro https://pro.arcgis.com/en/pro-app/latest/help/editing/create-a-preset-template.htm But I don't believe it can be done in AGOL since group feature templates can't be uploaded from Pro, and the Map Viewer Classic has relatively basic drawing and attribute templates you can configure. edit - using out-the-box tools I mean. ... View more

A Mosaic Dataset is the best option I can think of, and I recommend it.   The steps I would take if doing it myself: 1.  Create the Mosaic Dataset in the correct projection required.  Then load the rasters into it.  DO NOT check the boxes to calculate statistics or build overviews.  Wait for it to fully complete. 2.  Calculate statistics on the Mosaic Dataset using a very large skip factor (e.g. 1000 x and y), then work your way down values, repeating depending on how long it takes until you find an acceptable amount of time taken against the accuracy of the stats.  3.  If everything displays as expected then you can Define then Build your overviews.  You will need a clear strategy of what you want to achieve by doing this as if the dataset is as large as you say, then you may have to make trade offs for performance against the size of the overview cache generated (e.g. build the overviews/cache only in urban areas, reduce the cache/overview levels etc.). If you're not aware of how to do this then I'd recommend reading up on the overview tools/watch tutorials etc. ... View more

The expression looks ok.  The only thing I can think of is your field type, if Speed is a string rather than float/number then the expression would fail in this manner. if it is a string and you don't need to do any > < comparison: where_clause = "Speed = '30' AND Shape_Length < 400" ... View more