import arcpy arcpy.env.workspace = r"C:\gis-ags\src\gp" # temporary date_range = "\"OBDATE\" BETWEEN date '2008-01-01' AND date '2008-01-03'" # Script arguments #date_range = arcpy.GetParameterAsText(0) if date_range == '#' or not date_range: date_range = "\"OBDATE\" BETWEEN date '2008-01-01' AND date '2008-01-03'" # Local variables accum_table = "in_memory\\accumulation_table" stat_table = "in_memory\\stat_table" db_table = r"C:\gis-ags\src\gp\gisselect_cdo.sde\GIS.DAILYSNOW_GP_DATA" # Table Select arcpy.TableSelect_analysis(db_table, accum_table, date_range) # Summary Statistics arcpy.Statistics_analysis(accum_table, stat_table, "NAME FIRST;STATE FIRST;SNOWFALL SUM;LATITUDE FIRST;LONGITUDE FIRST", "COBAN") # Spatial Reference sr = arcpy.SpatialReference() sr.factoryCode = 4269 sr.create() # Make XY Event Layer lyr = "accum_xy_layer" arcpy.MakeXYEventLayer_management(stat_table, "FIRST_LONGITUDE", "FIRST_LATITUDE", lyr, sr) # Symbology symbology_layer = "accumulation.lyr" arcpy.ApplySymbologyFromLayer_management(lyr, symbology_layer)
Solved! Go to Solution.
import arcpy arcpy.env.workspace = r"C:\gis-ags\src\gp" # temporary date_range = "\"OBDATE\" BETWEEN date '2008-01-01' AND date '2008-01-03'" # Script arguments #date_range = arcpy.GetParameterAsText(0) if date_range == '#' or not date_range: date_range = "\"OBDATE\" BETWEEN date '2008-01-01' AND date '2008-01-03'" # Local variables accum_table = "in_memory\\accumulation_table" stat_table = "in_memory\\stat_table" db_table = r"C:\gis-ags\src\gp\gisselect_cdo.sde\GIS.DAILYSNOW_GP_DATA" # Table Select arcpy.TableSelect_analysis(db_table, accum_table, date_range) # Summary Statistics arcpy.Statistics_analysis(accum_table, stat_table, "NAME FIRST;STATE FIRST;SNOWFALL SUM;LATITUDE FIRST;LONGITUDE FIRST", "COBAN") # Spatial Reference sr = arcpy.SpatialReference() sr.factoryCode = 4269 sr.create() # Make XY Event Layer lyr = "accum_xy_layer" arcpy.MakeXYEventLayer_management(stat_table, "FIRST_LONGITUDE", "FIRST_LATITUDE", lyr, sr) # Symbology symbology_layer = "accumulation.lyr" mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd, "")[0] lyr = arcpy.mapping.ListLayers(mxd, 'accum_xy_layer', df)[0] arcpy.ApplySymbologyFromLayer_management(lyr, symbology_layer) lyr.showLabels = True arcpy.RefreshActiveView()
lyr.showLabels = True
Caleb,
Thanks for the reply. I had already tried that with this result
Runtime error
Traceback (most recent call last):
File "<string>", line 47, in <module>
AttributeError: 'str' object has no attribute 'showLabels'
I could try to create a feature class, but thought that shouldn't be necessary.
Thanks,
Glen
for lyr in arcpy.mapping.ListLayers('accum_xy_layer')[0]: lyr.showLabels = True
import arcpy arcpy.env.workspace = r"C:\gis-ags\src\gp" # temporary date_range = "\"OBDATE\" BETWEEN date '2008-01-01' AND date '2008-01-03'" # Script arguments #date_range = arcpy.GetParameterAsText(0) if date_range == '#' or not date_range: date_range = "\"OBDATE\" BETWEEN date '2008-01-01' AND date '2008-01-03'" # Local variables accum_table = "in_memory\\accumulation_table" stat_table = "in_memory\\stat_table" db_table = r"C:\gis-ags\src\gp\gisselect_cdo.sde\GIS.DAILYSNOW_GP_DATA" # Table Select arcpy.TableSelect_analysis(db_table, accum_table, date_range) # Summary Statistics arcpy.Statistics_analysis(accum_table, stat_table, "NAME FIRST;STATE FIRST;SNOWFALL SUM;LATITUDE FIRST;LONGITUDE FIRST", "COBAN") # Spatial Reference sr = arcpy.SpatialReference() sr.factoryCode = 4269 sr.create() # Make XY Event Layer lyr = "accum_xy_layer" arcpy.MakeXYEventLayer_management(stat_table, "FIRST_LONGITUDE", "FIRST_LATITUDE", lyr, sr) # Symbology symbology_layer = "accumulation.lyr" arcpy.ApplySymbologyFromLayer_management(lyr, symbology_layer) for lyr in arcpy.mapping.ListLayers('accum_xy_layer')[0]: lyr.showLabels = True
# Symbology symbology_layer = "accumulation.lyr" arcpy.ApplySymbologyFromLayer_management(lyr, symbology_layer) mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd, "")[0] for lyr in arcpy.mapping.ListLayers(mxd, 'accum_xy_layer', df)[0]: lyr.showLabels = True
import arcpy arcpy.env.workspace = r"C:\gis-ags\src\gp" # temporary date_range = "\"OBDATE\" BETWEEN date '2008-01-01' AND date '2008-01-03'" # Script arguments #date_range = arcpy.GetParameterAsText(0) if date_range == '#' or not date_range: date_range = "\"OBDATE\" BETWEEN date '2008-01-01' AND date '2008-01-03'" # Local variables accum_table = "in_memory\\accumulation_table" stat_table = "in_memory\\stat_table" db_table = r"C:\gis-ags\src\gp\gisselect_cdo.sde\GIS.DAILYSNOW_GP_DATA" # Table Select arcpy.TableSelect_analysis(db_table, accum_table, date_range) # Summary Statistics arcpy.Statistics_analysis(accum_table, stat_table, "NAME FIRST;STATE FIRST;SNOWFALL SUM;LATITUDE FIRST;LONGITUDE FIRST", "COBAN") # Spatial Reference sr = arcpy.SpatialReference() sr.factoryCode = 4269 sr.create() # Make XY Event Layer lyr = "accum_xy_layer" arcpy.MakeXYEventLayer_management(stat_table, "FIRST_LONGITUDE", "FIRST_LATITUDE", lyr, sr) # Symbology symbology_layer = "accumulation.lyr" mxd = arcpy.mapping.MapDocument("CURRENT") df = arcpy.mapping.ListDataFrames(mxd, "")[0] lyr = arcpy.mapping.ListLayers(mxd, 'accum_xy_layer', df)[0] arcpy.ApplySymbologyFromLayer_management(lyr, symbology_layer) lyr.showLabels = True arcpy.RefreshActiveView()