Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import arcpy
- Layer1 = arcpy.GetParameterAsText(0)
- Tabela1 = arcpy.GetParameterAsText(1)
- Estado = arcpy.GetParameterAsText(2).split(';')
- Ano = arcpy.GetParameterAsText(3).split(';')
- mxd = arcpy.mapping.MapDocument("CURRENT")
- Saida = arcpy.GetParameterAsText(4)
- stats = []
- for lyr in arcpy.mapping.ListLayers(mxd):
- lyr.name = Layer1
- lyr.definitionQuery = """UF IN ({})""".format(Estado)
- for field in arcpy.ListFields(Tabela1):
- if field.name in (Ano):
- stats.append([field.name, "SUM"])
- arcpy.Statistics_analysis(Layer1, Saida, stats, "")
- arcpy.RefreshActiveView()
- arcpy.RefreshTOC()
- Traceback (most recent call last):
- File "F:AgroBD.gdbM6a.py", line 19, in <module>
- arcpy.Statistics_analysis(Layer1, Saida, stats, "")
- File "c:program files (x86)arcgisdesktop10.3arcpyarcpyanalysis.py",
- line 1160, in Statistics
- raise e
- ExecuteError: ERROR 999999: Error executing function.
- An invalid SQL statement was used.
- An invalid SQL statement was used. [Brasil_Municipios]
- An invalid SQL statement was used. [SELECT * FROM Brasil_Municipios WHERE UF
- IN ([u'AC', u'AM'])]
- An invalid SQL statement was used.
- An invalid SQL statement was used. [Brasil_Municipios]
- An invalid SQL statement was used. [SELECT OBJECTID FROM Brasil_Municipios
- WHERE UF IN ([u'AC', u'AM'])]
- The table was not found. [out3]
- Failed to execute (Statistics).
- Failed to execute (Script1).
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement