Latest Contributions by TedKowal

What about using a text field and store "WKT"  Well Known Text to describe the geometry?  Many other medium to large format database can read and interpret WKT.   I use this in SQL server for custom geometry analysis/manipulation.   Just the first thought that came to me when I read your post. ... View more

Typically a Join between two tables require a key relationship eg  part of the sql in the join should relate FC1.somekey  = Table1.somekey.  Too add some complexity Left Joins or Right Joins include all of one set and those matching of another.  This too requires an equality or relationship key which I see missing from your example.  Joining on dates within databases presents other issues.  In a database, Datefields contain not only dates but time as well.  To complicate it further, dates are stored in the Databases own default format which can differ between databases ie MS Access/SQL Server/Oracle.... so the trick is placing or setting the date in a compatible format and setting the join key on that converted format  between the FC1 dataset and Table1.  In your examples above it appears that you are trying to do a cross join or in equality type of join and if that is the intent then search for info on Cross Joins. Hope this gives you some ideas! ... View more

File Geodatabase is not compatible with anything outside of ESRI!  A Personal Geodatabase can be read from almost any other application.  Please vote on keeping this option within Pro  https://community.esri.com/ideas/12662  ... View more

In my experience either I geo-reference the CAD file (does not take long if you have enough control points), take a guess at the projections (trial and error -- this can be frustrating), or have the technician, if possible, use the correct projected seed file (I deal mainly with DGN's which uses a seed). ... View more

How To: Define the projection for CAD data for use in ArcMap  ... View more

I can give you some tips..although you can do this with a direct join (sometimes), i would highly recommend that you : 1.  Import the excel sheet/table into a database (MS Access would work) 2.  While importing, make sure that the field you are joining on are the same data type ie (Text, Integer, double etc) that is in the shape file.  If you are joining in Zipcode and the shape file dbf has it as a "Long Integer" make sure that the imported excel table in step one is a Long Integer as well.  The datatype for the join field must be the same. 3.  From Arcmap - add the datatable you made in step 1 and perform your join. ... View more

from string import ascii_uppercase import itertools def iter_all_strings():     size = 1     while True:         for s in itertools.product(ascii_uppercase, repeat=size):             yield "".join(s)         size +=1 for s in itertools.islice(iter_all_strings(), 54):     print s‍‍‍‍‍‍‍‍‍‍‍‍ Just save your stopping point in line 11 (number of iterations you want  54... I believe is "BB" ... View more

In the field calculator VB script does not have any more efficient way.  In VB language ... like .net  -- yes there are other ways.  Testing for Null's in VB  is by using the "is NULL" test.  However in my experience with addresses I use an old fashion test and test for one blank space   by doing something like this ...  if a & "" = "" then  do something.  In vb if a null is concatenated with a space then the value will be a space. I am an old fashion VB'r but I would highly recommend doing this in Python there is less and less support for VB.  Already ESRI has downgraded from VBA to VBScript in ArcMap. ... View more

Love to move to Pro but it does not accept MS Access which is critical to our operations.  The choice of DB's is not mine to make! ... View more

Dan's is better --- the sample code I was using had unicode strings in it .... ... View more

Pre-Logic Scipt Code: def dmm (dia): if dia is not None: units=dia[-2:] if units=='in': cnv = int(int(filter(str.isdigit,dia))*25.4) return str(cnv)+'mm'‍‍‍‍‍‍ YourField= dmm(str( !d_diameter!))‍‍ ... View more

Or something like this.... if s is not None:       print s[:s.index('-')] else:       print ' '‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Lot of ways to appoach it ... one way is to make the number a string... but the test doesnt care whether or not the variable is a number or string  so testing myNumber is None would be valid as well -- It is what you return to the field that is important. def reclass (myNumber):     if str(myNumber) is None:          return 911     return myNumber reclass(!NumberField!) ... View more

Much Ado About Nothing   is a excellent document written by curtvprice  Dan Patterson‌  describing techniques in dealing with Null values. def reclass (myString):     if myString is None:          return 'Hedgerow'     return myString reclass(!Description!)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Currently Pro does not accept MS Access even with the 64 bit engine.  You can vote here and possibly they will add MS Access to list of compatible databases? Enable ArcGIS Pro to access ESRI Personal Geodatabases  My opinions: https://community.esri.com/thread/204332-arc-gis-pro-data-sharing  ... View more