Latest Contributions by SallieVaughn

I've got a series of MXDs with definition queries with file gdb-specific syntax. I'd like to batch modify those DQs to work with enterprise gdb syntax. Not every layer has a DQ, and not all DQs are the same. The problem I'm running into is with the expressions portion... the function is passing 'SHAPE.STLength()' with the quotes to the definition query, which doesn't match the syntax (need it without the quotes). Changing them to double quotes returns similar results, and removing the quotes all together causes the function to fail. Any ideas? import arcpy from arcpy import env from os import path env.workspace = ws = r"C:\temp\DefQueryScript\test1" expressions = {     'shape_length'  : 'SHAPE.STLength()',     'shape_area'    : 'SHAPE.STArea()',     'SHAPE_Length'  : 'SHAPE.STLength()',     'SHAPE_Area'    : 'SHAPE.STArea()',     'SHAPE_length' : 'SHAPE.STLength()',     'SHAPE_area'   : 'SHAPE.STArea()', } def letsGetThisPartyStarted():     ''' For each Map Document in the workspace, check each layer for a         definition query, and if found, update it according to the contents of         the expression dictionary.'''     print "Let's get this party started!\n"     mxds = getMXDs()     for i, mxd in enumerate(mxds):         for layer in getLayers(mxd):             evaluateExpression(layer)         saveMXD(mxd, i) def getMXDs():     ''' Create a list of each Map Document in the workspace(s).'''     mxds = [arcpy.mapping.MapDocument(m) for m in arcpy.ListFiles("*.mxd")]     return mxds def getLayers(mxd):     ''' Collects all feature layer in a Map Document.'''     print "{0} layers:\n".format(mxd.filePath)     layers = [l for l in arcpy.mapping.ListLayers(mxd) if l.isFeatureLayer]     return layers def evaluateExpression(lyr):     ''' If the layer has a Definition Query, update that query using the         dictionary of expressions.'''     if lyr.definitionQuery:         for exp in expressions.items():             key, value = exp[0], exp[1]             if key in lyr.definitionQuery:                 updateDefinitionQuery(lyr, key, value)     else:         print "        {0}: No Definition Query found\n".format(lyr.name)         pass def updateDefinitionQuery(lyr, old_exp, new_exp):     ''' Replaces the old expression with the new one. Fill in the old/new         associations in the "expressions" dictionary above.'''     print "        {0}:".format(lyr.name)     print "            Old expression: {0}".format(lyr.definitionQuery)     lyr.definitionQuery = lyr.definitionQuery.replace(old_exp, new_exp)     print "            New expression: {0}\n".format(lyr.definitionQuery) def saveMXD(mxd, i):     ''' Saves a copy of the Map Document which has had it's layers Definition         Queries updated.'''     mxd.saveACopy(path.join(ws, "COPY_" + mxd.filePath + "_{0}.mxd".format(i)))     del mxd if __name__ == "__main__":     letsGetThisPartyStarted()     print "'fin.'" ... View more

I just loaded a corrected topology into the parcel fabric and was attempting to edit a parcel. I chose the Merge Parcels workflow and got this error: "This Parcel Fabric layer is not compatible with the Parcel Workflows, please update your current map by replacing the Parcel Fabric and its associated layers with a new one." Anyone have any ideas how I can get rid of the error and start editing? ... View more

Does anyone have a representative sample of tax parcel records that are stored in the LGIM they would be able to share? I'm really just looking for a tabular view, not spatial data. I'd like to see how others are interpreting some of the fields like "Assessing Neighborhood Code" or "Structure Class Modifier." I'm happy to provide similar in return. Thanks! ... View more