Latest Contributions by TedKowal

I like yours better!   I have a long way to go in learning Python! ... View more

Yes that works just fine, however, that solution is run on the database and not gis software, and specifically it removes "ALL" characters except for the ones with ASCII values between 0 and 255.  So spaces and decimal values are not stripped.  In this case, I am assuming the individual wanted to use the field calculate and only remove certain characters. ... View more

Note that using .isalnum() will strip out significant '." and spaces as well   testString = " North Highway Route 2.1"  ---> "NorthHighwayRoute21"  if that is ok then it is a quick easy way! ... View more

To add on to Dan's comment.  If you have a list of special characters to remove you can do it in the field calculater inside a def with something similiar to ..... >>> import string >>> StringThatNeedsWork = "The - Time ! was well f$$$### spent   don't, you agree? 12345% 1.234" >>> removethesechars = ['$','#','%','-'] >>> StringThatNeedsWork.translate(None,''.join(removethesechars)) "The  Time ! was well f spent   don't, you agree? 12345 1.234" ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Joe, I am use to receiving all sorts of external data and many gremlins embedded within...  If you are using SQL server, one technique I use is to clean up the  text data to printable ascii codes only ... using techniques like described here:  Remove non ASCII characters from column  ... View more

I am assuming that you do not have access to geo-wizards or other custom tools....  One old fashion way was to semi-manually create the points from event mapping against the LRS (Routes). Below pictured is a modern guide on how to use an excel spreadsheet to calculate the interval and "Events" needed to map the points.  It should be fairly self explanatory. ... View more

https://community.esri.com/thread/107369  ... View more

Function FindLabel ([Well_Nme], [Total_Sulfate_3_16], [Total_Sulfate_6_16], [Total_Sulfate_9_16], [Total_Sulfate_12_16])      FindLabel="<BOL><UND>"&[Well_Nme]&"</UND></BOL>" & vbcr      if ( [Total_Sulfate_3_16]>=250000) then           FindLabel= FindLabel & "<CLR red='255'>"& [Total_Sulfate_3_16] &"</CLR>" & vbcr      else           FindLabel = Findlabel & [Total_Sulfate_3_16] & vbcr      end if      if ([Total_Sulfate_6_16] >=250000) then           FindLabel = FindLabel & "<CLR red='255'>"& [Total_Sulfate_6_16] &"</CLR>" & vbcr      else           FindLabel = FindLabel & [Total_Sulfate_6_16] & vbcr      end if      if ( [Total_Sulfate_9_16] >=250000) then           FindLabel = Findlabel & "<CLR red='255'>"& [Total_Sulfate_9_16] &"</CLR>" & vbcr      else           FindLabel = Findlabel & [Total_Sulfate_9_16] & vbcr      end if      if ( [Total_Sulfate_12_16]>=250000) then           FindLabel = FindLabel & "<CLR red='255'>"& [Total_Sulfate_12_16] &"</CLR>"      else           FindLabel = FindLabel & [Total_Sulfate_12_16]      end if End Function‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ In your code every time you set FindLabel you are erasing the previous values....  you only needed to set FindLabel = Findlabel & "whatever else you wanted to add on" ... View more

This may help you understand the basics of ArcGIS linear referencing. What is linear referencing?—Help | ArcGIS for Desktop  Penndot, if memory serves correctly, uses a Quadrant system in tangent to a linear referencing line.   You may want to contact some of these folks who wrote article.... PennDOT Integrates ArcGIS for Modernized Field Data Collection  Ted ... View more

Perhaps this may help ...  http://www.arcgis.com/home/item.html?id=9ea3a6c7c4e349aa96d68497605b61bd  Or  Use  the Create Random Points  ArcToolbox Tool   ...  ArcGIS 10.4 >ArcToolbox>Sampling>Create Random Points ... View more

It is quite difficult to determine what you are trying to do?  Maybe show the table with the required fields you wish to label and a sample formatted output you desire would help.  Your field named [Layer] is misleading is this referring to a layer on your map? or referencing something else altogether? So at first pass I am going on the assumption " I want it displayed as currency and rounded." FormatNumber([Cost],2)  <-- Will round to two decimal places‍ FormatNumber(number [,DecimalPlaces [,IncludeLeadingZero [,UseParenthesis [, GroupDigits]]]] ) or FormatCurrency(Expression[,NumDigAfterDec[,IncLeadingDig[,UseParForNegNum[,GroupDig]]]]) number : The number to format. DecimalPlaces : Number of digits to display after the decimal point. IncludeLeadingZero : Include a leading zero for numbers <1 and > -1 UseParenthesis : Show negative numbers in Parentheis (500) = -500 GroupDigits : Group large numbers with commas (or the regional delimiter) ... View more

I have no experience or familiarity with Attribute Assistant, however if you want it embedded within a IIF statement, MS access if the closest I have that contains the IIF function.... Putting this into a single line IIF format is ugly  ....  (ReformatDateString is a value field) DatePart("yyyy",CDate([inspdate])) & "/" & IIf(DatePart("m",CDate([inspdate]))<10,"0" & DatePart("m",CDate([inspdate])) & "/",DatePart("m",CDate([inspdate])) & "/") & IIf(DatePart("d",CDate([inspdate]))<10,"0" & DatePart("d",CDate([inspdate])),DatePart("d",CDate([inspdate])))‍‍‍   ... View more

I am assuming you want this in VB Script......  so something like  below would work..... my Font Size is based upon the Bridge Width while I am labeling the Bridge Number .... Function FindLabel ( [BRIDGE_NUM],[Width])   myFontSize = int([Width]/10)   myFormat = "<FNT name='Arial' size = '" & myFontSize & "'>"   FindLabel = myFormat & [BRIDGE_NUM] & "</FNT>" End Function‍‍‍‍‍ ... View more