# import xlrd - used to help read excel files
import arcpy
import os
from arcpy import env
TemplateLocation = r"\\MKRAMER\Share\Fig1AutomationProject\Required Files"
ProjectLocation = r"\\MKRAMER\Share\Fig1AutomationProject"
OutputLocation = ProjectLocation + "\\Output Files"
projTable = r'C:\Users\mkramer\AppData\Roaming\ESRI\Desktop10.7\ArcCatalog\Connection to ACCTG-SQL.sde\ProjectLocations.dbo.SiteMapList'
#projTable.definitionQuery = "\"WBS1\" = '185-202' AND \"WBS2\" = ''"
try:
#sets data pulled from the database to variables
# Changing the aspects of the environment to allow overrides
arcpy.env.workspace = projTable
arcpy.env.overwriteOutput = True
# starts an edit session to change values
edit = arcpy.da.Editor(os.path.dirname(projTable))
edit.startEditing(False,True)
edit.startOperation()
with arcpy.da.UpdateCursor(projTable, ['WBS1','WBS2','Longitude','Latitude','ProjName','ClientName','City','map_created'],"\"map_created\" = '0'") as cursor:
print "Start Loop"
for row in cursor: