Latest Contributions by KyleGonterwitz

It looks like the error message is telling you that your network the events are registered to is not present in the map service your event editor is using.  Is the network included in the service? ... View more

we do this in Kansas.  Here is a link to our web service of pavement layers for our state highway system.  We can group up the distinct material types into base and surface categories for HPMS from this detailed layer with lookup tables and stored procedures. Layer: Pavement Layers (ID: 0)  - here is a link to our old system of managing pavement layers using EXOR, we are doing it a little differently in Roads and Highways - now we will track actions applied to a pavement layer starting point, and apply the action to that layer starting point forward in time to create a view of the current existing pavement materials.   Things to consider: keep a sequence (like your "LAYER") from bottom to top or top to bottom and consider what will happen with a mill and overlay.  You will cut into the top layer or more. Mill and overlay are "actions" to the pavement. If you recycle pavement, that can be a distinct material type, you may want to keep information about the material recycled and how many recycles occur form some "original" pavement material. Other actions might include replacing dowels and/or joints of concrete slabs, or seals, which we sometimes consider "0 depth" and we don't want to report seals as a surface material. You definitely should want to track pavement layer dates as well as major grading dates, project numbers, and project stationings.  Major grading activities might be considered a layer and that activity wipes out all existing layers you cant edit pavement layers out of temporal sequence - it just cant be done.  If you find you missed a layer due to a project, you will have to re-enter the layers from the bottom up in the temporal sequence they were put down. We used to always do full width mill/overlays, but these days we are doing smaller cross sectional pavement jobs or adding passing lanes, we would want to track the cross sectional width and center line offset of the pavement jobs for projects that aren't the full pavement width. As you overlay and overlay and overlay over a period of time, the available pavement width will decrease, it becomes the shape of a trapezoid, another argument for tracking width.   I've got a lot more details I could share offline about how we are doing this now, this is what comes to mind in terms of ideas and potential pitfalls. ... View more

There was some discussion about a process to get the dominant route from the concurrency in this post a while ago: https://community.esri.com/thread/227849-export-only-dominant-routes-from-lrs  That's not how to do it using the geometry to measure LRE Rest tool, but maybe it could be incorporated as part of the solution?   ... View more

At one time I was running a Geodatabase replication between Oracle and SQL server which provided the best of both worlds for security, control, editing, query and processing... however it seems the days of old school geodatabase replication are numbered or in the case of Roads and Highways are passed. ... View more

I also run a postgresql instance in my desktop and a couple VM's for temporary development work and data processing, which I find works really well with memory-intensive functions. ... View more

I forgot to mention we have three more instances, dev - test- prod , each for a Roads and Highways "publication" database, where the idea is to routinely export simple features from the Location Referencing database.  That's a total of 6 instances of SQL server.  I also should mention we have three more instance environments for traveler information systems, two oracle instances (test and prod) for legacy GIS data, and two SQL instances for other application specific GIS Databases that are associated with ArcGIS server (processed and exported from legacy systems for ArcOnline and/or specific application/requirement needs).   Issues...  as you see that's a lot of instances, let alone databases and database connections to manage as sa, sde, owner, and ad group logins.  In our Roads and Highways instance, I do not have sa yet which I would really need in dev.  Managing user security around SA is an interesting issue, as Scott Fierro mentions below, there are some specific privileges that need to be assigned to ad users/route editors in order to keep privileges minimized.  In fact, keeping privileges to a minimum is still something we are trying to sort out and improve upon from the Oracle days where most connections were by the Data Owner or admin oracle database users.  The issue is where we need to export/output a segmentation table for processing, we have a database named user for that, but we need to figure out how to better organize the output and processing tables so they are not included in the Roads and Highways database.  Some of the output tables are created by database scripts, and as such are unregistered to the geodatabase. A side effect issue of this is that we have so many objects in our roads and highways database in addition to the hundred plus event and registered LRS features and tables that using ArcPy to listFeatures or listTables takes about 20 minutes.  I find it beneficial to keep a explicit list of events in a python config file to save time and add flexibility for listing event features. ... View more

SQL Server definitely makes it easier to update a database as needed.  I'm not sure, but I think Postgres gives the same update functionality as SQL server, while providing about the same native spatial query and function as Oracle, which is much greater than SQL server.  Our DBA's of course would prefer we stick with SQL Server or Oracle. ... View more

We do have three dedicated instances, one each for Dev test and prod SQL servers, designed for our roads and highways systems. I'm happy to announce here we have few databases in prod that interact a little bit with io... and many more databases in Dev. Oracle having multiple schemas makes challenge geodatabase updates a challenge, is your issue related to that? ... View more

Bing maps shows a "Prairie Village" neighborhood in Butler County labeled more prominently than the City of Andover. Those from Kansas City know Prairie Village is a suburban city in Johnson County, KS.  We have never figured out why Bing maps labels Prairie Village in Butler County, and after many years of contacting Bing about the issue and using Bing for our Basemaps - it's still there, and we now prefer not to use Bing basemaps.   I use OpenStreetMaps for many basemapping purposes, which I like because it is usually updated before anything else, and if it is not I can update it myself including changing of the symbol classification.  I can also grab vector data for the State from https://www.geofabrik.de or similar sites and query, overlay, and show vertical bridge relationships between over/under highways in interchanges, all it costs me is attribution "...CC-by-SA" and/or "© OpenStreetMap contributors..." credits on the maps produced.  For Garmin/HERE we happen to have a HERE representative who lives near me, I provide him planning resolution information regularly and he is very competitive about processing it through as quickly as possible.  Even though he may have the HERE Maps updated on the day we go open to traffic, it may take 6 months for Garmin to process the updates into their Vehicular GPS device basemaps.   I would say that based on some conference sessions I've been to lately involving transportation technology, connected and autonomous vehicles and all that - there is room for improvement in this area. Silicon Valley tech companies may think they can do everything without DOT participation but the fact is they can't.  They have to admit they have a problem before we can work with them to solve it, I think some states have solutions ready once the problem is recognized.   I wish I could link to some of the specific conference presentations I've seen in the last year.  Here are some articles I just googled on the subject: https://gis.usc.edu/blog/self-driving-cars-and-the-role-of-gis-in-future-transportation/ https://www.gislounge.com/spatial-challenges-navigating-rural-roads-self-driving-cars/ https://spectrum.ieee.org/cars-that-think/transportation/self-driving/mit-experts-selfdriving-cars-wont-need-accurate-digital-maps I noticed these articles focus on silicon valley technology and never mention state DOT's.   ... View more

At KDOT we are also beginning to use Transcends Intersection Manager.  It;s a nice relational setup that takes advantage of the Roads and Highways and Geodatabase capabilities to relational join the junction and segment data based on MIRE concepts.  Its a good capability and it forces you to think about the level of detail and abstraction of intersection geometries into or related to your roads and highways network. I think now the challenge is to collect the data we do not yet have into that model by 2026.   Every compliant DOT has submitted a plan by now.  I think we could use AI, something like mapillary, in addition to consulting, contracting with a provider, or a small task workforce applied to obtain traffic signs and signal information related to turn protections, prohibitions, channelization, and traffic controls.  Some of the traffic controls information do involve coordinated intergovernmental relations between traffic engineers, planners and consultants.  By 2026 we should be able to relate the point sign and control information into the LRS and intersection data. ... View more

I think you can do it in Desktop with the Network Analyst extension and any network analysis capable dataset.  Esri provides a "Maps and Data" resource that includes a roads dataset as a baseline, you'd have to get that into an editable database then copy a road and give it the properties you desire for the network extension to figure out the drive time. I doubt if there is easy way to do it through online drive time analysis tools... you might be able to if you could configure your own network dataset for the tool like you can for geocoding... but you seem to be talking about one road. The online tools are convenient and I like to compare drive time analysis polygons generated by different software, I've found some methods produce better results than others for different purposes, and what is best for my particular case can vary a lot in different locations or case by case.   Basically, distance traveled is a simple function of length and speed, if you can plot a line and guess an average speed, you can calculate distance traveled along that line for any given time. You could use linear referencing to model a route with the units of length as measures, and create a point event or line event starting at the origin measure, and calculate and plot the traveled distance as an event by making the point or end measure equal to the travel time T (60 minutes=1hour) * Vaveragetravelspeed (miles/hour).  You could complicate it further by making events of average travel speeds per section then summing the sections. Kyle ... View more

Transportation Planning/FRA reporting based draft data model for Railroad ... View more

I just had a problem "arcgis portal failed to determine if item can be deleted" where the problem was related to a bad manual copy/paste error in the Data Source URL, making it invalid.  While the Map Image Layer data source URL was invalid, Portal could not figure out if the item was able to be deleted, so it could not delete the item from Portal.  This is a 10.6.1 portal/server federated environment. To delete the item from portal which I knew to be invalid rather than doing these steps  https://support.esri.com/en/technical-article/000016345 I deleted the invalid URL leaving the data source URL blank, then I was able to delete the item from portal. ... View more