Latest Contributions by DanielBrenner

I have a field in a .dbf file with a long text string.   I need to delete x amount of characters WITHIN the text string.    I am also not very good with programming so I haven't looked into creating a script.   Essentially I have this: aaa bbb ccc ddd eee fff ggg What I need is this: aaa bbb ccc fff ggg I'm attaching the .dbf in MS Excel format (.xls).   I have had some luck with functions in MS Excel but I can't get the consistency I need. ... View more

Is there a Help Document on Rules For Text Strings and their formats in Text fields in dbf files? I have to do a lot of merging of files with a text string field and all to frequently I get error message 001156 regarding something in the text string I put in the text field and I go bonkers trying to figure out what it is.   I have been able to figure some things on my own but this is still a pain in the butt to  have to go through.   I have tried various queries in Help but nothing gets at what I'm talking about. I have been able to fix errors like the ones below in the past (consistent character string recognition from one database to another) but then when I thought I'd figured it out things like the ones in the pics still come up. Also:  Why is it when I am adding a Text field to a dbf file if I indicate a certain number of characters, after it becomes a part of the dbf file, it automatically goes to 255, even if I use the default of 50 when I am initially naming the Text field??? As in, why should I have to indicate what my field length is when I get this instead? ... View more

I do an extensive amount of editing of shapefile databases (.dbf) format for Quality Control with numerous attributes  in MS Excel for compatibility with shapefiles in ArcGIS 10.6.x.    While I clearly see the need for maintaining a high quality end product (shapefile to be used with other applications) this is also frustrating and is leads to a larger amount of time for achieving my end result. I have a number of questions for this subject, but one of them is this: How do I maintain the same order of fields in MS Excel 97-2003 that I have in the .dbf in ArcGIS? As in: ArcGIS:  a b c d MS Excel:  d b a c Thank you, Mr. Excel ... View more

I have a highways layer and a non state routes layer (roads) that I am using to create an intersection points layer.   I am then putting the points layer on top of Google Earth and manually identifying highway overpasses and underpasses, I would like to think there is a way to automate this or are there functions in ArcGIS that relate to it?     Will send screenshots upon request. ... View more

No worries if this doesn't work I'll go back to being an intern at 50 but here goes: I am interested in creating a couple of Model Builder type apps based on State Highways, ramps, and non Highway routes  that would create an intersection points layer.   I am curious if Model Builder can work with multiple formats of data as well as integrate custom applications and their end results as part of the procedure? Basic workflow for bigger apps: 1)  IN ArcGIS 10.6.x create Intersection points layer based on State Highways intersecting roads and add X/Y coordinates from ArcTool Box Features options.   (Would also be nice to add Intersection Points layer using  System Highway Ramps layer to create points layer for intersections with roads, but can see this not being possible due to different attributes in Ramps layer and non-compatibility with Intersection tool?) 2)  Export dbf file of points layer to .csv to be used in custom State Highways system application (Conversion tool that converts X/Y (Latitude/Longitude values) to create Odometer and State Highway System Postmile values database in .csv format.  (Application is based on State Highway segments and uses Dynamic Segmentation to create postmile and Odometer values) 3)  Edit .csv file in MS Excel 97-2003 to delete extraneous fields and put in required fields of DYNSEG_PRE, DYNSEG_SUF, and DYNSEG_PM (equal to Dynamic Segmentation Postmile).  CSV file will have Postmile fields for intersections on  BOTH Right and Left side of State Highway network.  Save file (if desired name file with side of Route (e.g StRte###_PMOdom_Right.csv) and then save as .csv file. 4)  Add .csv file to ArcGIS 10.6.1.  Run through Postmile Validation Wizard (also based on Dynamic Segmentation and postmile values in State Highway network) to create Points layer with Postmile Values. 5)  Open original .csv file from #2 and edit so that DYNSEG_PM vales are from other side of route (i.e. if original DNYSEGM_PM values were from right side, then copy-paste left values to DYNSEG_PM field) and save with name of file for other side of route (e.g., StRte###.PMOdom_Left.csv)  and do same procedure in #4 (add to ArcGIS and use Postmile Validation Wizard tool). Will send screen shots if need be but the core thing are whether multiple Non GIS  apps can be used? Can guess that this isn't a one button-does-everything given that I'm working with a couple of custom apps and I need to do editing to create requisite filed(s) for other custom apps. Will send screenshots upon request. ... View more