Latest Contributions by ZacharyHart

‎10-09-2020

That's not quite correct and I'm sure this is a source of much confusion. You can still create DBs in SQL express (desktop or workgroup edition DB server) wirh ArcMap and then work with them just fine in Pro. You cannot CREATE those DBs in Pro, however. I don't understand how Pro will be a full replacement for desktop with major functionality like this still missing. I don't understand how after years of users asking the same/similar question that Esri cannot clarify the roadmap here. Should we start planning that 2way replica environments will no longer be possible without a full ArcGIS Server Standard license for both participating DB instances??

‎10-08-2020

All I'm seeing from multiple threads is that there is absolutely no way to create a GDB in SQL Express with Pro.

‎10-08-2020

I honestly feel like Esri is just ignoring this. How is it I need to have ArcMap just to create a GDB in SQL Express?

‎06-18-2020

Ok, I see. What if you put your SDE connection files in a shared network location and have your script point to those? The location would have to be made available to the ArcGIS service account. Not sure if you used a domain or local machine account for your server setup.

‎06-17-2020

Have these various DB connections been registered with your Server's Data Store?

‎06-17-2020

Is there a list of ArcPy functions that can use feature services directly for input? For example, arcpy.da.TableToNumPyArray will happily use a FS REST endpoint URL directly as an input and from there you can do all the awesome NumPy stuff you want. On the other hand, arcpy.MakeFeatureLayer_management will not accept the URL as an input. It will accept the layer reference in the TOC if the feature layer is added to Pro and you are using the Python window. The issue isn't solved with the ArcGIS Python API. Yes, there is the arcgis.features module, but despite being able to call up a Portal item as a 'Feature Layer', this cannot then be passed to an ArcPy function. The Python API is great for a lot of things, but obviously doesn't leverage all the power that ArcPy brings to geoprocessing. So, is there a list of arcpy functions compatible with feature services? Perhaps the Data Access module is the only set of functions that is?

‎06-03-2020

I tried what Dale Jackan‌ suggested. I did this from a fresh clone from a clean 2.5 install. I can't even up update python via Conda! Dan Patterson‌

‎06-02-2020

I too give up. I CANNOT get spyder of any version to install with 2.5. I've done more clean-clean uninstalls of the entire environment than I care to remember, I've done via Python command line, i've tried over and over again with the stupid package manager. I just want my Spyder IDE. The most recent failure of trying to install from the command line corrupted my cloned environment and all the jupyter labs & extensions all ruined. I've tried tech support and the analyst is convinced it is because of my (work at home) internet speed! None of this should be so hard! Hours upon hours wasted again!

‎05-12-2020

This ArcGIS Blog post by Hussein Nasser‌ is what inspired my interest in finding a way to do this. Basically I'd like to create an attribute rule where a user collects/creates a point (probably Collector) and this then updates a polygon which the point falls within/intersects. Imagine the polygon feature class being something like zip codes, or census units and the attribute field getting updated is something like simply indicating that the person has visited that location or even more simply that the polygon feature/record itself as been visited. I suppose there might be a way to achieve this with a relationship class as well. Thanks for any ideas anyone may have!

‎04-21-2020

Thanks Lukas, Now i need to wrap my head around the suggested workaround as I'm not quite clear on that yet...my brain is fried from spending days trying to research this problem.

‎04-21-2020

Completely stumped here. I have seen a handful of somewhat similar threads dealing with Lambert Azimuthal Equal Area...the problem here is working out the proper transformation. Here's a bit of a summary of what I do know. This (NDVI) data can be obtained from USGS here [AVHRR in this example]. I have other data I am trying to align with this data (GCS_North_American_1983 WKID: 4269). There is no WKID associated with the data's projection info, nor is there a GCS or datum. When searching for 'LAEA_Sphere_19', surprisingly, only a handful of results are returned. One result provides some additional insight. Spatial Reference .org lists this as "SR-ORG Projection 8750 - eModis Phenology" The ESRI WKT reflects exactly what we see in the raster's spatial reference properties: PROJCS["LAEA_Sphere_19",GEOGCS["GCS_unknown",DATUM["D_unknown",SPHEROID["Sphere",6370997,0]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Lambert_Azimuthal_Equal_Area"],PARAMETER["latitude_of_origin",45],PARAMETER["central_meridian",-100],PARAMETER["false_easting",0],PARAMETER["false_northing",0],UNIT["Meter",1]] The raster metadata provides no additional insight. There is much discussion (and stories of headache) in dealing with the Sinusoidal projection associated with other USGS/NASA MODIS data, but this is not that projection. Out of desperation, I tried creating the custom geographic transformation found here...of course that failed to yield proper results. This was another dead-end waste of time. The various online tools associated with manipulating the USGS/NASA HDF files are not valid for this data. This are TIFs for NDVI Phenology. My source data is GCS_North_American_1983; i need to somehow match to this LAEA Sphere 19. Please, any insight or help here would be most appreciated...I cannot believe how little documentation there is regarding this!

‎04-02-2020

From Support Services: We finished the testing and confirmed and attached the following defect to your case: BUG-000129805 : Running the python command for Layer to KML works in idle, but fails to create output if run from script tool. Lame. We are in the process of updating all of our existing GP services to Pro/Python 3.x based tools. This roadblocks updating one of our most used GP widgets which will now have to remain ArcMap/Python 2.x based for the foreseeable future.

‎03-30-2020

Dan, I tossed this into a script tool with the script imported. The TBX is zipped and attached above. The output location will be a folder called 'export' in your scratch folder. Thanks!

‎03-28-2020

Hi Dan, I dumbed th code way down for purpose of isolation. No parameters set in the script tool for this test. I have tried a number of different input types and output locations. Humor me and toss that in a script tool and let me know if it works for you. This may be a bug.

‎03-27-2020

ArcGIS Pro 2.5 The Layer to KML GP Tool from the standard TBX works fine. The ArcPy code will work in the Python window. The ArcPy code will even run and produce the KMZ from an IDE (such as Spyder). The ArcPY code completes without error when run as a Script Tool in Pro, but no output is produced. Can anyone else test this? I'm losing my mind trying to figure this out. import arcpy arcpy.env.overwriteOutput = True arcpy.MakeFeatureLayer_management(r"C:\Users\JackTorrance\Documents\ArcGIS\scratch\export\ExportTestAgain333.shp", "ExportedFeaturesLayer") arcpy.AddMessage(arcpy.GetCount_management("ExportedFeaturesLayer").getOutput(0)) arcpy.LayerToKML_conversion("ExportedFeaturesLayer", "D:\\TEMP\\TryThis.kmz")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I added the message simply to ensure the feature layer was valid (contains features), and you can see this working as expected in the GP messaging dialog. One other observation: the script tool takes way longer than it should, like 2.5 minutes!

Online Status	Offline
Date Last Visited	‎03-24-2026 12:51 PM

My Ideas

Latest Contributions by ZacharyHart

Re: ArcGIS Pro and local SQL Express DB

Re: ArcGIS Pro and local SQL Express DB

Re: Manage Sql Server Express

Re: Centralizing database connection strings and publishing GP Services

Re: Centralizing database connection strings and publishing GP Services

ArcPy Functions which can use Feature Services directly?

Re: Spyder IDE no longer works after upgrade to ArcGIS Pro 2.5

Re: Spyder IDE no longer works after upgrade to ArcGIS Pro 2.5

Attribute Rule: Collect point and update polygon table that coincides with point location

Re: Reprojecting to match USGS LAEA_Sphere_19 eMODIS/AVHRR data?

Reprojecting to match USGS LAEA_Sphere_19 eMODIS/AVHRR data?

Re: Layer to KML works in Python window but not in Script tool [Update: Bug]

Re: Layer to KML works in Python window but not in Script tool

Re: Layer to KML works in Python window but not in Script tool

Layer to KML works in Python window but not in Script tool [Update: Bug]

Similar to authoritatve or deprecated have Beta/dr...

Retrieving attachments with Fetch updates, changes...

AGO Enterprise Distributed Collaboration Secured S...

Field Maps Multiple Label Classes?

Re: Can Field Maps Mobile Users Select Layers to D...

Esri Forestry Group (EFG)