Latest Contributions by TedKowal

As of yet, no I have not found any workarounds - at least ones that don't require lots of additional cost in licensing fees.  I will work with desktop till I cannot anymore.  On the side I have been dabbling in QGIS and GRASS. ... View more

I do not believe VB script will be able to run on a startup simply..... The start up routine is stored/pointed to in the registry of your computer....you would need to create a program in .net (not script)  and map objects to get a handle on the map.start.  This is not simple or easy and if you do not know what you are doing I highly do not recommend you modifying the map.start. Xander Bakker‌ may have some other alternative if you can describe what you want to do ... View more

The symbols "<" , ">", and "&" are special characters and are not valid in your text if formatting tags are used. Use the equivalent character entity codes &amp; and &lt; instead....  You can find other special entity character codes here: HTML 4 Entities   "<FNT size='3'>" & [Count] & vbCrLf & vbCrLf& "</FNT>" & "<BOL>" & "&lt;1" & "</BOL>" & vbCrLf & " "‍‍ ... View more

The Transform tool correlates the same road (routes) from two differing systems by location and tolerance.  In my case I am in a urban environment and this technique has very poor results.  I had to resort to a differing technique.... In my case I normally work with our LRS system and receive data from a State LRS which is very different in structure and rules from our own: My process is simply event map my data on our system to get the points of interest along with the route and milepost.  With that  data set, I add a field to place the other route systems designation  eg  RouteNameOther.  I populate this field from a dataset I maintain that looks up the corresponding routes (how I initially created this lookup see below).  With the other routes populated I then re-event map this to the other system the result is a data set with both References (Mileposts) from both systems.  Of course I have automated this by creating my own add-in using VB.Net  I could never get a "Model" to do this cleanly and handle the differences between two differing structures and rule sets cleanly. Route lookup table initial creation I initially populated this lookup table by placing points at the midpoints of our "centerline: segments (from which our LRS was developed from) and intersecting that with the other systems centerline segments to pickup the other route name for the other system for the corresponding routes.  That takes care of the minimum requirements to event map (Route and a Point).  Over the years, I have maintained this lookup table till it is very clean and is corrected for the different geometric structure and naming convention rules between the two systems.  On my first pass for cleaning  the lookup table I used the offset distance to help Identify discrepancies.  I then looked at over and under routes and overpasses to make sure that these routes were Identified correctly.   Be advise you will have to handle 1 to many relationships in translating routes systems in this manner  for example we may have route 112 from MP 0 to 15 Miles and the other system this is divided up into route 1A and parts of route 2B and visa versa from the other system to ours....  these types of scenarios I use a segment Id that I place on our system in terms of our centerline break point rules.  On the other system I also create a field if it is not there for a segment id and auto uniquely populate it... I then use the segment Id to resolve any  Many to Many relationships.  Note I have to do this because our rules and structure are vastly different. I hope this triggers some other Ideas for you! ... View more

This may help ....   https://community.esri.com/thread/176287  ... View more

This may be a stupid thing...but that happens to a few of my users too.  Still do not know the reason.. but if the model was saved to the correct toolbox and the other machine  can access the toolbox (added to the toolbox window)  -- Open the tool and then try and right click on the .tbx that contains your model and choose "Edit".    ... View more

That is the whole point....ESRI does not manage databases well.  My databases are all managed outside independent of any application.  The data contained serves many functions; GIS being only one of many applications using the data.  MS Access albeit a poor bottom of the rung still barely adheres to the definition of a  DBMS and it provides seamless linkage between other scalable Datastores such as Oracle, SQL Server .... Postgress etc. ... View more

Not for editing, It cost extra. ... View more

A database is a repository(Infrastructure related software) which serves the purpose of storing data and retrieving the stored data by using some specific structured language such as SQL.  The data and retrieval methods are not limited in scope to one specific application or function. A database provides various functions that allow entry, storage and retrieval of large quantities of information and provides ways to manage how that information is organized.   The query language(s) used to access the database (such as SQL), and their internal engineering, which affects performance, scalability, resilience, and security. File Geodatabase is only a structured link list which is only readable and usable to ArcGIS.  It is not scalable nor can its internals be tuned by the user.  It has no compatibility in other third party applications, nor does it implement anywhere close to a full SQL language for retrieval or using NonSQL structure any of its means.  Whereas MS Access does fit the bottom end of a DBMS definition. ... View more

You many have to install the microsoft provider to access the oldb connection.  You can download all the drivers you need here in one package with the install .... Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center  ... View more

Yes I can understand why people love Excel for data entry... but it is not a database and it starts to fall apart when you try and use it as such...  Same thing  for the File Geodatabase..... It is not a database .   Our field folks love Excel so I have written many of a data validation scripts within excel  just to ease my import to GIS pains! Good luck! Ted ... View more

I am a VB man and VB has a clear screen for its shell..... I have not tried but ran across this: https://www.geeksforgeeks.org/clear-screen-python/  :::: update did not work in the built in Python interpreter in ArcMap. However it did work external python console/ide Right now I used for the built in Python interpreter:  print "\n" * 80 ... View more

Digital Recognition????  I had a company try this using Lidar in one of our projects.... (failure) We ended up doing it by hand because the reliability was so bad that the false positives were more work than coding by hand.  Even Bridge extraction that I have had party to were horribly bad... missed Bridge Culverts, mis-identified sign structures, utility lines etc as Bridges and simply missed classical Bridge structures. Some articles in reference to extracting Overpasses that I found and may be of assistance: https://static.googleusercontent.com/media/research.google.com/en//pubs/archive/37364.pdf  https://dl.acm.org/citation.cfm?id=2093975  Yes I am an old fart! No need to rot away in the corner there is no progress without bumps along the way! ... View more

I work within Transportation... There is no magical way of detecting Underpasses or Overpasses that are reliable.  Old fashion elbow grease is the only sure way.  Within the attributes, I generally have a field call OverUnder and I manually populate that field.  Values I use:  1 for Overpass, 2 for Underpass and Null/0 for plain old road. Some techniques I use for finding Overpasses.....  They occur at Intersection and generally have a Bridge associated with them.  So I query the map for all Intersection points that are within a small buffer range of a Bridge (Polygon layer in my case).  This leaves a mucher set of points that I need to determine Over or Under codes manually! ... View more

No answer to your problem, I use MS Access Geodatabases here in my shop and a little VB import script solves my issues like yours.  MS Access is a powerful little tool that ESRI is overlooking in pro! Enable ArcGIS Pro to access ESRI Personal Geodatabases The ESRI import has a default value of 255 for text fields, anything bigger comes in as a blob.  In addition, the import reads the first 8 rows of the excel data imported from which data type is determined..... A template example of resetting text field widths in a personal geodatabase:  Public Sub change_field_size(DBPath as string, _   tblName As String, fldName As String, fldSize As Integer)     ' this routine changes the field size         Dim db As Database     Dim td As TableDef     Dim fld As field             On Error GoTo errhandler     Set db = OpenDatabase(DBPath)     Set td = db.TableDefs(tblName)         If td.Fields(fldName).Type <> dbText Then         ' wrong field type         db.Close         Exit Sub     End If         If td.Fields(fldName).size = fldSize Then         ' the field width is correct         db.Close         Exit Sub     End If         ' create a temp feild     td.Fields.Append td.CreateField("temp", dbText, fldSize)     td.Fields("temp").AllowZeroLength = True     td.Fields("temp").DefaultValue = """"""     ' copy the info into the temp field     db.Execute "Update " & tblName & " set temp = " & fldName & " "         ' delete the field     td.Fields.Delete fldName         ' rename the field     td.Fields("temp").Name = fldName     db.Close     '====================================================================== Exit Sub errhandler: MsgBox CStr(Err.Number) & vbCrLf & Err.Description & vbCrLf & "Change Field Size Routine", vbCritical, App.Title End Sub‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more