Latest Contributions by DavidSolari

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

I'm not sure if Vector Tiles support Symbol Layer Drawing but if you're just using the roads for reference then it's worth trying out. ... View more

If nothing else that filter is completely wrong, annotations should appear under Point and dimensions under Polyline. ... View more

Note that for most IDEs, you'll want to link to the python executable inside whatever environment you're currently using. For the built-in env these paths are: "%SYSTEMDRIVE%\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\python.exe" (all users install) "%LOCALAPPDATA%\Programs\ArcGIS\bin\Python\envs\arcgispro-py3\python.exe" (single user install) For the custom environments you can create through Pro you'll want to note the folder it's created in and then use the python.exe inside that folder. Unless something's changed most IDEs cannot pick up on the current Pro python environment so you'll have to change which interpreter you use on both ends; if someone's found a way to make this automatic I'd love to know! ... View more

This might be an Arcade limitation, if you use the Python calculation mode does that work? ... View more

If you have access to Pro: find the map file you publish the layers from, select a layer, go to the "Labeling" tab in the ribbon, click the tiny arrow in the bottom-right corner of the "Label Placement" section: now you have the Maplex positioning options. Click the third icon from the left to go to the conflict options and set a "Repeat". This will saturate your polygon with labels, even if the centroid is offscreen. This requires overwriting the map service or publishing a new one, and I'm pretty sure this won't work with your Feature Service (it might work with a vector tile service?) but it'll give you all the labels you could ever need.   That said, as others have mentioned: this is what symbology is for. A well-authored set of polygon symbols will make your areas easy to delineate and will work in all types of service. If the user has trouble remembering each symbol they can open the legend built into every web map. ... View more

If Scott can leverage JavaScript functions something like this StackOverflow question should be enough to calculate an end time given a start time and some combination of duration questions. ... View more

For clarification: would your workflow support collecting the geometry in Field Maps, hiding the attributes from editing, and providing an Arcade expression that opens the feature up in Survey123 via Global ID? This way you're only editing one feature between both apps. Alternatively you can make an Arcade link to a different feature layer (or a table layer in the same feature service) and pass in the GlobalID to a foreign key field, this works better if you need to do offline work. If neither option fits then that's a tough one, this level of app ping-pong is beyond what I've worked with. ... View more

For the two points where the blue vertices hit the edge of the orange square, are there matching vertices on the orange square? I've had issues with spatial selections where minute imprecisions along edges cause the inner feature to bleed out of the outer feature, even if it seems mathematically sound. If there are matching vertices then yeah this is a bug. ... View more