Latest Contributions by DavidPike

I'd very highly recommend the _7 transformation not the Petroleum transformation which is designed for offshore oil use I believe.  (I think there's even a _9) now but I wouldn't worry about it for your needs.  https://digimap.edina.ac.uk/help/gis/transformations/transform_arcgis/ The transformations option is shown in the 3rd photo on this site https://mserre.sph.unc.edu/teaching/fall2019archived/envr468/arcGIS/understandingCoordinateSystems/TransformCS.htm (Data fram properties -> Coordinate system tab at the top -> Transformations button at the bottom) For new data, it will have to be reprojected each time using the tool.  That's why you should just set the transformation option instead of processing them.  If you had a huge amount of points there might be a speed use case for it but it's much simpler to let ArcGIS reproject on the fly for this - you just need to set the correct transformation. ... View more

https://pro.arcgis.com/en/pro-app/latest/help/mapping/navigation/sql-reference-for-elements-used-in-query-expressions.htm "Strings are case sensitive in expressions, except when run on geodatabases in Microsoft SQL Server. " I'm not sure of an easy workaround.  There's mention of a COLLATION setting on the DBMS itself but that may not be ideal. It's maybe a bit convoluted or impractical if you have lots of records - but you could copy to an FGDB (copy should preserve OIDs) then run the selection there, obtain the OIDs of those records then use those to select the EGDB records, or what I'd recommend is to simply do as Johannes suggested and Field Calculate all the values to upper regardless of if they already are upper. ... View more

Also for reference: Overview of different package types - https://pro.arcgis.com/en/pro-app/latest/help/sharing/overview/introduction-to-sharing-packages.htm Package Map tool (Map Package) - https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/package-map.htm   ... View more

Where is this standalone table located?  Not sharepoint or cloud or anything? ... View more

https://doc.arcgis.com/en/arcgis-online/manage-data/publish-imagery-layers.htm   https://doc.arcgis.com/en/arcgis-online/reference/tile-layers.htm ... View more

Is it an SQL EGDB by any chance? ... View more

Strange.  Do you have a screenshot to get more of an understanding what may be happening? The field type is definitely Date? In the field designer, have you got any custom formatting or Default settings on (default would match your system time format) https://pro.arcgis.com/en/pro-app/latest/help/data/tables/format-numeric-and-date-fields.htm  I'd set the format to 'None'  - Note times of Midnight will show as having no time   from the link: Date and time formats Date formats, unlike numeric formats, only have one category: Date. Within this category, you can choose from multiple supported date formats. The default is None, which includes the full date and time, except for midnight when only the date is shown. Optionally, you can choose System Default, the date displayed matches the default established by the operating system, or use Custom to generate your own format string. ... View more

To get your rectangular grid - https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-fishnet.htm template extent - Current display extent height, width, number of columns/rows - as per your requirements then: https://pro.arcgis.com/en/pro-app/latest/tool-reference/analysis/clip.htm Clip - use a iterator within model builder (iterate row selection in the iterator) https://pro.arcgis.com/en/pro-app/latest/help/analysis/geoprocessing/modelbuilder/iterators-for-looping.htm        ... View more

Pasting into Excel can be a minefield in terms of how it tries to be helpful and deal with delimiters, set fractions as dates.. etc.  If it's a business process, then I'd recommend using https://pro.arcgis.com/en/pro-app/latest/tool-reference/conversion/table-to-excel.htm , maybe not as fast, but it works. ... View more

Datetime strptime module will cover this for you.  I've pinched the syntax from googling. from datetime import datetime input_string = '20220617010000' dt_object = datetime.strptime(input_string, '%Y%m%d%H%M%S') #print(dt_object) return dt_object ... View more

Ah OK, should be pretty simple.  Do you have the feature class/table names rather than their aliases?  Would make it simpler. ... View more