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()