20240110 12294300 1.0 TRUE CalculateField AddressesWithOwnershipComcate ACCFacility "NO" VB # CalculateField AddressesWithOwnershipComcate ParkAdd "NO" VB # CalculateField AddressesWithOwnershipComcate USD "NO" VB # CalculateField AddressesWithOwnershipComcate StateRd "NO" VB # CalculateField AddressesWithOwnershipComcate ParkAdd "YES" VB # CalculateField AddressesWithOwnershipComcate USD "YES" VB # CalculateField AddressesWithOwnershipComcate ACCFacility "YES" VB # CalculateField AddressesWithOwnershipComcate StateRd "YES" VB # AddSpatialJoin AddressesWithOwnershipComcate ParksNameOnly JOIN_ONE_TO_ONE KEEP_ALL "ParkName "ParkName" true true false 254 Text 0 0,First,#,ParksNameOnly,ParkName,0,253" "Have their center in" # # PERMANENT_FIELDS # DeleteField AddressesWithOwnershipComcate Join_Count "Delete Fields" AddSpatialJoin AddressesWithOwnershipComcate Athens-Clarke_County_Commission_District_Boundaries JOIN_ONE_TO_ONE KEEP_ALL "FID_1 "FID_1" true true false 2 Short 0 2,First,#,P:\Elections\Athens-Clarke_County_Commission_District_Boundaries.shp,FID_1,-1,-1;ID "ID" true true false 2 Short 0 2,First,#,P:\Elections\Athens-Clarke_County_Commission_District_Boundaries.shp,ID,-1,-1;Label "Label" true true false 2 Text 0 0,First,#,P:\Elections\Athens-Clarke_County_Commission_District_Boundaries.shp,Label,0,1;Population "Population" true true false 5 Long 0 5,First,#,P:\Elections\Athens-Clarke_County_Commission_District_Boundaries.shp,Population,-1,-1;Incumbent "Incumbent" true true false 17 Text 0 0,First,#,P:\Elections\Athens-Clarke_County_Commission_District_Boundaries.shp,Incumbent,0,16;Shape__Are "Shape__Are" true true false 24 Double 15 23,First,#,P:\Elections\Athens-Clarke_County_Commission_District_Boundaries.shp,Shape__Are,-1,-1;Shape__Len "Shape__Len" true true false 24 Double 15 23,First,#,P:\Elections\Athens-Clarke_County_Commission_District_Boundaries.shp,Shape__Len,-1,-1;Percent_No "Percent_No" true true false 24 Double 15 23,First,#,P:\Elections\Athens-Clarke_County_Commission_District_Boundaries.shp,Percent_No,-1,-1;Percent_Bl "Percent_Bl" true true false 24 Double 15 23,First,#,P:\Elections\Athens-Clarke_County_Commission_District_Boundaries.shp,Percent_Bl,-1,-1;Percent_Hi "Percent_Hi" true true false 24 Double 15 23,First,#,P:\Elections\Athens-Clarke_County_Commission_District_Boundaries.shp,Percent_Hi,-1,-1;Percent_Mi "Percent_Mi" true true false 24 Double 15 23,First,#,P:\Elections\Athens-Clarke_County_Commission_District_Boundaries.shp,Percent_Mi,-1,-1" "Have their center in" # # PERMANENT_FIELDS # DeleteField AddressesWithOwnershipComcate Shape__Are "Delete Fields" DeleteField AddressesWithOwnershipComcate Shape__Len "Delete Fields" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.2.0'><FeatureDataset>ComcateAddresses</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Comcate\ComcateAddresses.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>AddressesWithOwnershipComcate</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>District_num</field_name><field_type>TEXT</field_type><field_length>15</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField AddressesWithOwnershipComcate District_num ""District" + [Label]" VBScript # Text NO_ENFORCE_DOMAINS CalculateField AddressesWithOwnershipComcate District_num ""District" + " "+[Label]" VBScript # Text NO_ENFORCE_DOMAINS DeleteField AddressesWithOwnershipComcate Join_Count "Delete Fields" DeleteField AddressesWithOwnershipComcate FID_1 "Delete Fields" DeleteField AddressesWithOwnershipComcate ID "Delete Fields" DeleteField AddressesWithOwnershipComcate Label "Delete Fields" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.2.0'><FeatureDataset>ComcateAddresses</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Comcate\ComcateAddresses.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>AddressesWithOwnershipComcate</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Urban</field_name><field_type>TEXT</field_type><field_length>30</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField AddressesWithOwnershipComcate Urban "General Service District" VBScript # Text NO_ENFORCE_DOMAINS CalculateField AddressesWithOwnershipComcate Urban "Urban Service District" VBScript # Text NO_ENFORCE_DOMAINS DeleteField AddressesWithOwnershipComcate USD "Delete Fields" acc crm comcate work order service request citizen request resident request 311 Address points for use in Comcate CRM. Includes the following: Ownership & homestead exemption information, whether an address is associated with an ACCGov facility, Park name (if applicable), whether an address lies in the urban service district ComcateAddressesMercator2_20_24_WFL1 iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=