Latest Contributions by BlakeTerhune

I think this issue has something to do with the view being created in ArcCatalog but not being "registered" with SDE. I had to dig up an ArcGIS 10.0 machine and use SDE command line to create the view. ... View more

Great examples there, thanks for sharing. What are your thoughts on using os.path for this stuff? ... View more

Here are three examples I found so far. Ironically, I think this snippet from my code is closest to what I was thinking but I still feel like there's something missing. Re: Writing Unique Attribute Field Values to csv # Get list of usable field names (exclude OID and SHAPE fields) fieldNames = [     f.name for f in arcpy.ListFields(inputTable)     if f.type != "Geometry" and f.editable == True ] Re: Return system fields Another way of accessing standard fields (not determining the name though) is using tokens in for instance an arcpy.da.SearchCursor. Some examples are: SHAPE@ (A geometry object for the feature.) SHAPE@AREA (A double of the feature's area.) SHAPE@LENGTH (A double of the feature's length.) OID@ (The value of the ObjectID field.) Re: Spatial join - distance from outline def getAllFieldsWithoutGeometryFields(fc):     flds = [fld.name for fld in arcpy.ListFields(fc)]     desc = arcpy.Describe(fc)     fld_length = desc.lengthFieldName     fld_area = desc.areaFieldName     fld_shape = desc.shapeFieldName     if fld_length in flds:         flds.pop(flds.index(fld_length))     if fld_area in flds:         flds.pop(flds.index(fld_area))     if fld_shape in flds:         flds.pop(flds.index(fld_shape))     flds.insert(0, 'SHAPE@')     return flds ... View more

Partially. I know about the field.editable property, but I'm looking for what properties you check for exclusions if you wanted to dynamically open an update cursor on a table using ListFields(). I know I've seen a few cases where people have posted code with a neat little function that returns the "valid" fields. Sorry, I wish I could explain it better. ... View more

I see you analyze Datasets on all your tables, can someone claify if this is necessary? I talked to Esri support to try and confirm I was on the right track with my process here. I explained very clearly I'm doing the rebuild and analyze on every table and feature class. They confirmed that I was doing things correctly but noted that it could take a long time to do everything. However, they did't say I should not do it. I notice you run your rebuild index BEFORE you run the Analyze Datasets, is there a reason you have decided to run in this order? I think I did it in that order only because that's the way the original documentation did it. Somewhere in the documentation it also mentioned possibly running one (or both of these) before the compress as well as after, so it's a little confusing in which scenarios you would do something like that. EDIT: I just stumbled across this post that recommends running analyze datasets before reconcile/post/compress. While this script has been running successfully for a while now, I'm noticing that it takes about 12 minutes longer to complete every night. This has been a steady increase and it now takes hours to finish where it originally took less than 30 minutes. My plan is to adjust the script so it will only rebuild and analyze the tables that were modified. Here is a sample query (Oracle) I will adjust and simplify to find the modified tables. SELECT TR.OWNER || '.' || TR.TABLE_NAME AS LAYER_NAME,     MM.REGISTRATION_ID,     COUNT(distinct(S.STATE_ID)) AS AFFECTED_STATES,     COUNT((SL.LINEAGE_ID)) AS LINEAGE_LENGTH FROM SDE.STATES S     INNER JOIN SDE.MVTABLES_MODIFIED MM         ON S.STATE_ID = MM.STATE_ID     JOIN SDE.TABLE_REGISTRY TR         ON MM.REGISTRATION_ID = TR.REGISTRATION_ID     JOIN SDE.STATE_LINEAGES SL         ON S.LINEAGE_NAME = SL.LINEAGE_NAME GROUP BY TR.OWNER, TR.TABLE_NAME, MM.REGISTRATION_ID ORDER BY LAYER_NAME; ... View more

I know I've seen a few posts where people use a little function to get the "valid" editable fields of a table of feature class. It will at least exclude fields that are not editable (to exclude ObjectID, GlobalID, etc), but I know it did a couple other exclusions. Do you know what I'm referring to? I'd like to see that snippet ... View more

How about something like this? s ="POWERS 1C-23HZ" s2 = "RATTLER4C-34HZ" for string in (s, s2):     string = string.replace(" ", "")  ## Drop spaces (optional)     print string     string_builder = ""     field_vals = None     for i in string:         if i.isdigit():             field_vals = (                 string[:len(string_builder)],  ## string before number                 string[len(string_builder):]  ## string after number             )             print field_vals             break         else:             string_builder += i I am not clear on how you want to use field calculator to write to two output fields, so I'll let you clarify your intent or adapt this logic to your specific need. You'll at least need to get rid of the first three lines. EDIT:​ Xander and Darren beat me to it! ... View more

If you're just in a file geodatabase and ArcMap, the Esri Attribute Assistant add-in may work for you. A traditional database trigger would require an RDBMS (like SQL Server or Oracle). Not sure about how to accomplish this with ArcGIS Online or Collector. This reply from Christopher Blinn has some helpful alternatives. ... View more

According to the documentation: IE 9 and higher Edge Firefox Chrome Safari iOS Safari Android Browser Chrome for Android Internet Explorer 9 is supported but has the following limitations. Additional browser limitations are also noted below. You cannot view streaming feature layers in the map viewer. Within the My Organization > Edit Settings > Open Data page, the Your Open Data Sites list does not appear. You cannot open metadata XML files or save local copies of your current metadata document in the built-in metadata editor. You cannot add CSV items (in My Content) as web layers in the map. This limitation applies to IE 9 and Safari. You cannot use the scene viewer. This limitation applies to IE 9 and 10. If the map contains feature layers, labels on the following basemaps may appear hidden: Imagery with Labels, Dark Gray Canvas, Light Gray Canvas, World Oceans, and Terrain with Labels. This limitation applies to IE 9 and 10. ... View more

Perhaps you'll find some helpful information here. Everything you ever wanted to know about ordering in mosaic datasets | ArcGIS Blog Understanding the mosaicking rules for a mosaic dataset—Help | ArcGIS for Desktop I also found that the Cell Size affected the mosaicking rules. ... View more

You can actually condense this a little by using enumeration instead of a separate cnt variable. Re: Enumeration of a cursor with arcpy.da.UpdateCursor(pointLayer, fields1) as u_cursor:     for cnt, row in enumerate(u_cursor, start=0):         # Process row and cnt; no need to update cnt variable. However, I don't get what this is supposed to be doing. It doesn't make sense to me. row[cnt] = row[cnt].title() ... View more

Shouldn't your zip codes be polygons rather than points? It would be more reliable if you could do a spatial join where your input point intersects the zip code polygon to find out which zip code a point is in, not which centroid it is closest to. ... View more

You can probably get rid of the del cursor line because it's redundant with the with statement. The cursor will be deleted automatically when the with statement is exited; same with row. ... View more