I have a script that, among other things, conducts a Clip operation between two line feature classes. When I run the script in Spyder, I get ~3000 features in the resulting clip. When I run that same script in an ArcGIS Notebook in Pro, I get ~30 features.
I assume this is an issue caused by 'on the fly' projection in Pro.
However, I'm also unable to use the Project tool on either feature class. One is in WGS 1984 Major Auxiliary Sphere projected into Web Mercator and the other is in NAD 1983 with a StatePlane projection. However, the Project tool's drop-down list of transformations all give an ERROR 000365: Invalid Geographic Transformation. This confuses me since the transformation from NAD 1983 to WGS 1984 exists and...should work, but instead just reports that error?
I'm not sure what steps to take next here. I want to be able to test this script in an ArcGIS Notebook and have it work the same way it does when running outside of Pro. The script does make use of Feature layers so it will inevitably do on the fly projection when run in Pro. What can I check to try and get the Project tool to work so I can write a project into the script?