Latest Contributions by TedKowal

Very interesting article! I was not referring to the Arcgis data view but to create your view within your database itself (outside of ESRI products).  Then use this created view as a table within Arcgis ....  may be a little old fashion but in the few tests that I did it seems to work with creating an automatic concatenation of multiple fields to a unique key index.  This only works for all the tabular data fields (not the shape column). ... View more

Another thought came to me, create a view of the data and use a composite index for the view.... then at least your concatenations would be automated and indexed ... View more

I believe you are referring to composite keys.  I know you can do this when working with data table,  I generally separate my tabular data from the geometry use the composite form of the type database you are using to reference multiple column primary keys.... an example: CREATE TABLE Persons (   P_Id int NOT NULL,   LastName varchar(255) NOT NULL,   FirstName varchar(255),   Address varchar(255),   City varchar(255),    CONSTRAINT pk_PersonID PRIMARY KEY (P_Id,LastName) ) I am not sure, however, if a feature class can do this?  ... View more

If you want to try vbscript: int([ID]) Of course those string with no numbers will come out to be 0. ... View more

>>> a = "MIA-45.678" >>> b = float(''.join(ele for ele in a if ele.isdigit() or ele == '.')) >>> b 45.678 ... View more

Sorry -- I just could not resist ..... Temptation got the better of me!  int(filter(str.isdigit, [ID])) BTW:  I had an access denied when trying to use the advanced editor.... ... View more

Google Maps are only as accurate as the controls used to rectify the imagery.  In my experience, I have found Google Maps to be very accurate as well as way off in equal parts for the areas of my interest.  Personally, I would use the GPS over Google maps.  At least with the GPS, you may run across features that have known positional coordinate and then you can determine or even correct the GPS data. I have re-rectified some of the Google Image and the results have been so warped and unusable.  So Google/Bing type  imagery is always my last choice to use. ... View more

As mentioned earlier excel is a poor database... it has a nasty habit of reading the first few rows and setting the data type which is near impossible to over rule.  To give you some hints/recommendation (ones I use): Even though it is extra work: 1.  I always import my excel data (database) into MS Access.  2.  Check/correct the data types 3.  Use/Import/Link/Join as needed to ArcGIS By using the above steps, I generally can avoid unexpected data types, missing data etc. Hope this helps ... View more

/T Indicates that this operation is performed on all matching files/directories below the directories specified in the name. If memory serves me, I believe there is a bug for traversing sub-directories the inheritance flag must be set for the traversal to work. This source may give you some other ideas and examples:  Windows command line icacls command help ... View more

LOL! ... View more

Have you tried the values of the Domain for those alignment tokens? Example: Horizontal         Vertical 0 - Left             0 - Top 1 - Center        1 - Center 2 - Right           2 - Baseline 3 - Full             3 - Bottom Updating your selected values for the alignment column in question to a 1 (which 'center' represents) ... View more

That is one hell of a spinning back kick ... Still goes to my point (my laziness) that this should be embedded within the language and not have to be manually accounted for (and thought of). I believe that I have been spoiled by other 4th generation languages and have the expection that python honors certain expected rules.  When it does not intrinsically, I am left with no/lesser confidence.  Again I am beating a dead horse... either jump on the train or get left behind. def Live_Long_and_Prosper(vulcan)       return "Needs of the Many outweigh the Needs of the few" print Live_Long_and_Prosper ... View more

Dan I agree with your statements -- It is more of Laziness on my part.  I would rather use a function isNull rather than a def for trapping all possibilities of nullness.  In the same hand, knowing a division by zero will halt my program/script in its tracks.  Pure Laziness! However, I use python on databases outside of GIS/No shapefiles and still I have problems with Nulls!  Yes they are Pesky!  One day we will avoid Null in database design and this issue will go away (and replaced by with some other pesky issue) --- Keeping us in business. ... View more

Good Catch .... This is why I like to stick with C or VB.  I have confidence it will catch errors or inconsistencies such as you noted.  In fact when I have to deal with Null values, I avoid python like a plague.  I still have no confidence that it can trap and deal with null values.  I still find situations where Python did not catch or trap (or more correctly I did not envision all the possibilities where a null value is described).  I can'd give up isNull() ..... old, lazy and set my ways and now I have to worry about dividing by zero!      Good catch -- learned something else today. ... View more

I have gotten around this issue with other languages and other ODBC api's by: Yes No field in Access is either -1, 0 no nulls.  I have had success by passing a non null tiny int/small int to an access Yes/No field if it is already pre-exisiting. For table creation with an access Yes/No field, I pass thru a DDL statement to access to create the table then populate it with non null -1,0 values as neccessary for Yes/No True/False. The DDL field type to pass is "YESNO" CREATE TABLE TestAllTypes    (       MyText       TEXT(50),       MyMemo       MEMO,       MyByte       BYTE,       MyInteger    INTEGER,       MyLong       LONG,       MyAutoNumber COUNTER,       MySingle     SINGLE,       MyDouble     DOUBLE,       MyCurrency   CURRENCY,       MyReplicaID  GUID,       MyDateTime   DATETIME,       MyYesNo      YESNO,       MyOleObject  LONGBINARY,       MyBinary     BINARY(50)     ) I would imagine that a DDL "Alter Table"  would work in a similiar manner.  I believe PyODBC requires you to commit when you pass the DDL SQL... import pyodbc con = pyodbc.connect(r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=Z:\Data\Instruments\testDB.accdb; Provider=MSDASQL;'cur = con.cursor() string = "CREATE TABLE TestTable(symbol Text(15), leverage double, shares YESNO, price double)" cur.execute(string) con.commit() ... View more