Latest Contributions by DavidSolari

I usually just generate the vtpk file in Pro, upload that directly to the Portal, then publish it out as a service. I'm pretty sure that should only keep one copy of the data around. ... View more

An addendum: as your dataset grows you'll run geometry checks against the entire Pole dataset (at least, the entire set that the map has access to) and your edit performance will slowly grind to a halt. The usual fix is to run a Buffer on your anchor point, then use Intersects to reduce the available poles. You can also use Count to see if that intersection is empty and return an error to prevent adding anchors in the middle of the Atlantic. ... View more

My faint memories of high school trig tell me something's wrong with how you're calculating the angle. Thankfully, nobody writing arcade has to remember how to do this right thanks to the Angle function. Replace the last few lines of calculations with Angle(referencePoint, nearestPoint) - 90 and you should be golden. ... View more

Doing heavy actions inside Update Cursors like creating a new feature class is a bit buggy from what I remember. Fortunately there's a solution: don't! The only thing you're doing with those new feature classes is capturing a single feature and then using that to location select the input data. Instead, try using Make Feature Layer to make lightweight views into your data that you can select freely, this should avoid the issue you have and speed up your script by a good deal. ... View more

Always annoying when you just need 2 or 3 columns from a giant table but you either have to screw around with the visible fields or copy out a giant field set and trim it down in Excel. This would be very nice! ... View more

Is your script running against Pro's python environment or ArcMap's? If it's the latter then it'd explain why the Pro geodatabases are tripping it up. Easy way to find out is to throw these two lines at the top of your script, then check the output: import sys arcpy.AddWarning(sys.path)     ... View more

Not an immediate fix by any means, but I suggest filing an Idea to get a "spinner" appearance for integer questions added to the forms. The teams have to reassess the form spec for other pending changes to Field Maps so this might be the perfect time to sneak something simple into scope. ... View more

Another entry in the list of random ArcGIS features that keel over and die when they have to handle a GUID, one of the six-ish standard data types, glad you figured out a workaround at least. ... View more

If you restructure the workbook around the ArcGIS for Excel extension you can have two-way updates between the GIS and the Workbook. Keep in mind the workbook authors will need a certain level of user privileges to push updates through the extension. ... View more

I'll add that the layer name of related tables has pretty strict length requirements compared to online, you may need to rename the layers and then republish the service to satisfy Survey123. ... View more

Try using an Add Message to print out that where clause string, I have a feeling your use of a format string with a format method isn't doing what you think it is. In general you should give your hand-written code a once over. For example, you're using pathlib to turn the current workspace into a Path object, but then you convert it into a string at every turn instead of using the native path building methods. Either use Path objects to their fullest or use the os.path functions to manipulate string paths (which arcpy prefers anyways). You also do a bunch of environment workspace stuff that goes nowhere, unless you're using functions like ListFeatureClasses you don't need to set this variable. Honestly you can probably ask for the feature class directly as one parameter and then peel off the workspace path from a Describe dictionary if needed. ... View more

Based on your workflow, you're either creating the hosted layers in Web Mercator or [State Plane]. I don't do a ton of work with hosted layers so I can't say what Pro is doing during publishing, you'd have to double-check the REST endpoints of the hosted layers after publishing. When I said "online editing" I meant any process that goes through the web map. These edits will be entered as Web Mercator coordinates and then projected and transformed as needed to align with the hosted layer's coordinate system. Edits directly to the hosted layers are possible but if you're using Experience Builder, Field Maps etc. the web map is in between. The loss from transformation differs on your location, you're best off loading a source feature class into pro, then using the Project tool to convert that to Web Mercator using the best transformation possible, then comparing both points. Transformation losses can accumulate over time but as long as your online edits aren't zipping features across the state or moving them dozens of times per day then you can usually estimate the loss by performing 2 or 3 Project tool passes back and forth from [State Plane] to Web Mercator. If the losses are unacceptable then you'll need to assemble some base data and publish out a basemap in your state plane, then use that in all your maps. Note that the basemap doesn't need all state plane inputs, the transformation loss from generating tiles should be well within heads-up digitization tolerances. ... View more

Short answer: all layers must be reprojected to the coordinate system of the web map's basemap. If you use any ArcGIS basemap that coordinate system is Web Mercator, and very few orgs have the resources to make a basemap gallery for their projects in an alternate coordinate system, so Online/Enterprise has a de facto coordinate system of Web Mercator. Therefore: No, but you have to pick a basemap in another coordinate system. No, but if the web map you add it to isn't locked to a basemap with the same coordinate system, your layer will undergo reprojection. No. Yes, but it will be reprojected. Note that reprojection isn't inherently bad. If your layer's coordinate system also uses the WGS 1984 datum then all you lose is rendering speed as someone's device has to warp the coordinates. If the layer uses a different datum (common in the US and Canada, a lot of required coordinate systems are pegged to NAD 83) then you'll also get a potential accuracy loss and even more speed loss due to the datum transformation. This is another reason why publishing to Online/Enterprise usually involves Web Mercator layers, if you have to pay the datum transformation price you might as well do it during data import/export where it won't impact web performance and you can manage the transformations. If you need to do online editing and datum transformation loss is unacceptable then you'll need to lock the maps to a custom basemap with a matching datum. ... View more

These are both great links! The vscode extension looks incredibly handy for debug work but it doesn't try to swap to the current environment, odd that it can read the current environment in the extension but can't offer a "click to sync" function. Spyder isn't really what I'm looking for for my type of work but that seems like a great IDE for more analytical work. ... View more