Latest Contributions by KyleGonterwitz

Hi Elsit!    I believe you can do sql updates on a branch versioned database: UPDATE MyBranchVersionedTable SET Field1 = 'New Value' WHERE ID = 123 -- Specify the branch version to update FOR VERSION 'MyBranchVersion';   Another alternative, similar to your workaround, would be to save the table in the SQL database, use SQL update/set values rather than ArcGIS field calculator, then append processed records.  I think the database updates are way faster than field calculator. ... View more

I have utilized data from a state DOT Roads and Highways database and integrated it into TransCAD, that isnt very hard to do.  It took a lot of effort for the DOT to implement that roads and highways system, many difficult decisions have to be made to answer your questions in a way that works uniquely for that state's data to be implemented in Roads and Highways. Once the data is implemented in Roads and Highways you can process the roadway data you want to use to a format that can be imported into TransCAD.  I do not think it would be worth the effort to implement roads and highways just to utilize the network in TransCAD unless you have other significant business cases to use roads and highways.  I think any cases of DOTs using their Roads and Highways data in TransCAD are because the Roads and Highways system exists as the DOT system of record. Those DOTs expend significant resources to implement and maintain those Roads and Highways systems. The data maintained by any US DOT should contain resources that can be leveraged by TransCAD simply by exporting a dynamic segmentation of event data into a shapefile for TransCAD use. ... View more

my opinion is you should draw the culverts as a line from point to point, or maybe simply a point where the culvert intersects the route.  If you need to know where the culverts are along the highway in the R&H database, use the location of the culvert point, line to intersect, and locate the route/measure of the culvert point of intersection along the highway.   If you wanted to look at the condition along the culvert you could support linear referencing along the length of the culvert, but that culvert would not be a road or a highway, so you might just want to use traditional linear referencing or a water resources application like HY-8 for that.  ... View more

Linear Referencing!   ... View more

https://www.mapillary.com/ does some of this, it has the collection apps and an extension for arcgis pro although I prefer using the website.  It doesn't meet all of your requirements but it is pretty much free to use. ... View more

If you create a process in the jupyter notebook in pro and it takes too long or has a looping error it is not possible to break or cancel the process while running in pro.   The only method to kill the process is to kill the ArcGIS pro application.  The idea is to add a button or menu item to kill the notebook to stop it from processing. ... View more

I agree batch exporting layouts to pdf is a great idea, and it was pretty easy to do with python, here is an example in a python notebook https://github.com/gontek/CMED/blob/main/LayoutExport.ipynb In this example rather than export all layouts I am controlling the desired layouts to be output by explicitly listing those layouts by name.  To export all layouts I suppose you could change the logic to "not in" on line 9 and have an empty list. ... View more

I am not sure if I am answering the question you are asking but if you want to use an external IDE with your ArcGIS pro cloned environment that environment python interpreter can be found at C:\Users\%USER%\AppData\Local\ESRI\conda\envs\arcgispro-py3-%clone name% If you want to find the location where arcgis pro stores the internal jupyter notebooks created in arcgis pro I think by default those notebooks are found in the same directory as the pro project, which by default might be C:\users\%user%\documents\arcgis\projects I think you would probably need to somewhat coordinate the location of the jupyter notebook with the interpreter environment to get the results you would expect working with an IDE outside pro, especially if you want to use the arcgis libs in that ide.  ... View more

Sure - If you have a working model builder export that to python or look at the geoprocessing history and copy the python commands to a notebook in pro.  Take advantage of for loops with incrementation and use the looping to automate the input and output naming conventions, and change the input and output of the geoprocessed python commands to use the iterated string variables to meet your needs.  ... View more

for what you are doing my tip would be use python instead of model builder and  simply iterate your tin names in loops with python. ... View more

One way to show hatch marks for your linear referencing in web maps is to create points that represent the hatches for the web mapping.  The following python script was used by a DOT to "fake" the hatches with points.  The script uses in-memory datasets which I believe are not supported in the same way as they once were, and would likely need to be modified. https://github.com/KDOTGIS/pydot/blob/master/HatchFake.py     ... View more

I believe I am experiencing a similar issue with McAfee on one particular computer.  Attempts to create a file geodatabase in a directory take a very long time and the task manager shows the antivirus spiking in activity.  Attempts from another computer - same version of pro, same output directory, do not encounter the issue.  Did you resolve the issue? ... View more

This convenience seems to be fixed/restored in Pro 3.0 ... View more

to the original question of calculation of 10-85 slopes, I would use linear referencing in the following general geoprocessing: 1. calculate a field in the drainage line/flowpath that is from, and set it equal to zero 2. calculate a field in drainage line that is equal to the the shape length of the stream  3. calculate a field in the drainage line that is the shape length *0.1 4. calculate a field in the drainage line that is the shape length *0.85 5. make sure you have a unique identifier for the drainage lines create routes from stream lines (uniquely named) using the digitized direction (correctly drawn) using either the projected from (0) and to (shape length) calculated into fields;  export the table/make table view from the drainage lines and make route event layers as points of the 10% and 85% coordinates along the stream route calculate elevations at those event layer point locations, one way is using "Extract Values to Points" The event layers should cleanly join back to the drainage line unique identifier/route identifier, so then calculate slope =delta elevation/delta 10-85 coordinates along the route   ... View more