FALSE 1.0 AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint C1_EXCEPTION LONG 0 0 10 "C1 Exception" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint COMMENTS TEXT 0 0 150 Comments NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint STSUF TEXT 0 0 2 "Street Suffix" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint STNAME TEXT 0 0 90 "Street Name" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint STPRE TEXT 0 0 2 "Street Prefix" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint STREETNAMEID LONG 0 0 10 "Street Name ID" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint PICTUREID TEXT 0 0 20 "Picture ID" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint CENTERLINEID LONG 0 0 10 "Street Segment ID" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint SOURCE TEXT 0 0 1 "Address Source" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint GPSX TEXT 38 8 150 "X Coordinate" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint GPSY TEXT 38 8 150 "Y Coordinate" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint PARCELID TEXT 0 0 23 "Parcel Identification Number" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint GPSFLAG TEXT 0 0 1 "Field Verification Flag" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint FLOOR LONG 0 0 10 Floor NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint BADADDRLOC TEXT 0 0 1 "Incorrect Address Location" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint BADADDRNUM LONG 0 0 10 "Incorrect Address Number" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint ZIP TEXT 0 0 5 Zipcode NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint SITETYPE TEXT 0 0 2 "Site Type" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint STREETID LONG 0 0 10 "Old Street Segment ID" NULLABLE NON_REQUIRED # AddField Q:\AddressDataManagementfor10.2\MapsandGeodatabase\TestMigrationAddressing\Geodatabases\LocalGovernment.gdb\SiteAddressPoint GEONAMEID LONG 0 0 10 "Old Street Name ID" NULLABLE NON_REQUIRED # CalculateField "Site Address Points" ADDRNUM !ADDRNUM!.rstrip() PYTHON_9.3 # CalculateField "Site Address Points" ALTUNITTYPE !ALTUNITTYPE!.rstrip() PYTHON_9.3 # CalculateField "Site Address Points" ALTUNITID !ALTUNITID!.rstrip() PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME!.rstrip() PYTHON_9.3 # CalculateField "Site Address Points" MUNICIPALITY !MUNICIPALITY!.rstrip() PYTHON_9.3 # CalculateField "Site Address Points" FULLADDR "!ADDRNUM! +" " + !FULLNAME! +"," + " " + !ALTUNITTYPE! +" " + !ALTUNITID! +"," +" " + !MUNICIPALITY! +"," +" " +"FL" +" " + !ZIP!" PYTHON_9.3 # CalculateField "Site Address Points" STNAME "!STNAME! .replace("AV", "Ave")" PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("RD", "Rd") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.title() PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Th", "th") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Nd", "nd") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("st", "St") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Address Points" STNAME "1st St" PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Rd", "rd") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Manor", "Mnr") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Manor", "Mnr") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Rd", "rd") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Manor", "Mnr") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Manor", "Mnr") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Rd", "rd") PYTHON_9.3 # CalculateField "Site Address Points" STNAME "56th Ave" PYTHON_9.3 # CalculateField "Site Address Points" STNAME "6th St" PYTHON_9.3 # CalculateField "Site Address Points" STNAME "7th Way" PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Address Points" STNAME "Adrian Ave" PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Address Points" STNAME "21st St" PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Rd", "rd") PYTHON_9.3 # CalculateField "Site Address Points" STNAME "Amsterdam St" PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("St","st") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("St","st") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Tr","Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME "Baltimore St" PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME "Bay St" PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Island", "Is") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("ITr", "Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME "Birch Ave" PYTHON_9.3 # CalculateField "Site Address Points" STNAME "Birch St" PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME "Bonnie Ave" PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Address Points" STNAME "Boston St" PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Address Points" STNAME "Boyleston St" PYTHON_9.3 # CalculateField "Site Address Points" STNAME "Boyleston St" PYTHON_9.3 # CalculateField "Site Address Points" STNAME "Brewster St" PYTHON_9.3 # CalculateField "Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Address Points" STNAME "Bumpy Rd" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STATUS "current" VB # CalculateField "Site Addresses\Addresses - Site Address Points" STATUS "Current" VB # CalculateField "Site Addresses\Addresses - Site Address Points" STATUS "Temporary" VB # CalculateField "Site Addresses\Addresses - Site Address Points" FULLNAME !FULLNAME!.title() PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" UNITTYPE [ALTUNITTYPE] VB # CalculateField "Site Addresses\Addresses - Site Address Points" UNITID [ALTUNITID] VB # CalculateField "Site Addresses\Addresses - Site Address Points" ALTUNITTYPE "Null" VB # CalculateField "Site Addresses\Addresses - Site Address Points" ALTUNITTYPE "<Null>" VB # CalculateField "Site Addresses\Addresses - Site Address Points" ALTUNITID "<Null>" VB # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "Oakside Dr" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STPRE "W" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] +"St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Rd"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("trl", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + "Rd"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Rd"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "Hickory Rd" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Cir"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Crescent", "Cres") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Rd"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Dr"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Ave"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Ave"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Mnr", "Manor") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Cove", "Cv") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "Ohio St" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Ave"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Ave"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Dr"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Ave"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Dr"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Bend", "Bnd") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:2] + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "Star Lake Forrest Rd" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "Stardust Blvd" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Glen", "Gln") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Ave"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Rd"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "Dr"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME! + " " + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "St"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME "!STNAME![:-2] + "Trl"" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("Tr", "Trl") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME!.replace("St", "st") PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" FULLNAME [STNAME] VB # CalculateField "Site Addresses\Addresses - Site Address Points" CAMAUPDATED "Yes" VB # CalculateField "Site Addresses\Addresses - Site Address Points" CAMAUPDATED "Yes" VB # CalculateField "Site Addresses\Addresses - Site Address Points" FULLNAME "[STPRE]+" "+ [STNAME]" VB # CalculateField "Site Addresses\Addresses - Site Address Points" STSUF "Ave" VB # CalculateField "Site Addresses\Addresses - Site Address Points" STSUF "Ave" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STNAME !STNAME![:-3] PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STSUF "Rd" PYTHON_9.3 # CalculateField "Site Addresses\Addresses - Site Address Points" STSUF "St" PYTHON_9.3 # CalculateField "Site Address Points" SITEADDID "<Null>" VB # EnableEditorTracking "Database Connections\AdminConnectionTo_putlgim.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint" # # LASTEDITOR LASTUPDATE # UTC CalculateField "Site Address Points" FULLNAME !FULLNAME!+"e" PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME!+"e" PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME!+"e" PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME!+"l" PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME![0:-5] PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME!+"Mnr" PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME![0:-2] PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME!+"Park" PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME![0:-4] PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME!+"Bnd" PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME!.replace("Manor", "Mnr") PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME "!FULLNAME!.replace("'", "")" PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME!.title() PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME!.replace("Dr", "Drive") PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME!.title() PYTHON_9.3 # CalculateField "Site Address Points" FULLADDR !FULLADDR!.title() PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME!.strip() PYTHON_9.3 # CalculateField "Site Address Points" FULLNAME !FULLNAME!.title() PYTHON_9.3 # CalculateField "Site Address Points" FULLADDR "[ADDRNUM] &" "&[FULLNAME] &" "& [UNITTYPE] &" "& [UNITID] &" "& [FLOOR] &" "& [COMMUNITY] &", "&"FL "& [ZIP]" VB # CalculateField "Site Address Points" FULLADDR "[ADDRNUM] &" "&[FULLNAME] &" "& [UNITTYPE] &" "& [UNITID] &" "& [FLOOR] &" "&[COMMUNITY] &", "&"FL"'& [ZIP]" VB # CalculateField "Site Address Points" UNITTYPE !UNITTYPE!.upper() PYTHON_9.3 # CalculateField "Site Address Points" PLACENAME "FOREST GLEN APARTMENTS" VB # CalculateField "Site Address Points" PLACENAME "FIVE OAKS REST HOME" VB # DeleteRows G:\GIS\GeodatabaseConnectionFiles\putlgim_sde.sde\SiteAddressPoint Append 'Site Address Points p06' "Site Address Points" TEST # # CalculateField PPMuniAddresses FULLNAME UCase([FULLNAME]) VB # CalculateField "Addresses\Site Address Points" MSAG "EAST PALATKA" VB # CalculateField "Addresses\Site Address Points" MSAG "EAST PALATKA" VB # CalculateField "Addresses\Site Address Points" MSAG [COMMUNITY] VB # CalculateField "Addresses\Site Address Points" MSAG [COMMUNITY] VB # CalculateField "Addresses\Site Address Points" MSAG [COMMUNITY] VB # CalculateField "Addresses\Site Address Points" MSAG [COMMUNITY] VB # DisperseMarkers "Site Address Points" "20 Points" Expanded 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/2.7.0'><FeatureDataset>putlgim.SDE.Address</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68437941687a6e31433972713469325254623746586b467331764f63704b2b78504874326a5a4c6f6a6451453d2a00;SERVER=putsgisp06;INSTANCE=sde:sqlserver:putsgisp06;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisp06;DATABASE=putlgim;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putlgim.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>ESN</field_name><domain_name>EmergencyServiceZones</domain_name></AssignDomainToField></workflow></operationSequence> 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/2.7.0'><FeatureDataset>putlgim.SDE.Address</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68437941687a6e31433972713469325254623746586b467331764f63704b2b78504874326a5a4c6f6a6451453d2a00;SERVER=putsgisp06;INSTANCE=sde:sqlserver:putsgisp06;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisp06;DATABASE=putlgim;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putlgim.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>ZIP</field_name><domain_name>Zipcodes</domain_name></AssignDomainToField></workflow></operationSequence> 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/2.7.0'><FeatureDataset>putlgim.SDE.Address</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e682f73562b4d6d343454715137507775334445536c4b43304c39686a686466525a692b544c6a454e616c2b673d2a00;SERVER=putsgisp06;INSTANCE=sde:sqlserver:putsgisp06;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisp06;DATABASE=putlgim;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putlgim.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddCodedValueToDomain><domain_name>AddressStatus</domain_name><coded_values><coded_value><code>NULL</code><code_description>NULL</code_description></coded_value></coded_values></AddCodedValueToDomain><SortCodedValueDomain><domain_name>AddressStatus</domain_name><descending>ASCENDING</descending><sortByDescription>CODE</sortByDescription></SortCodedValueDomain></workflow><workflow><AssignDefaultToField><field_name>STATUS</field_name><default_value>NULL</default_value></AssignDefaultToField></workflow></operationSequence> CalculateField "Site Address Points" ESN 302 "Python 3" # Text CalculateField "Site Address Points" ESN 326 "Python 3" # Text CalculateField "Addresses\Site Address Points" MSAG [COMMUNITY] VB # CalculateField "Addresses\Site Address Points" MSAG [COMMUNITY] VB # CalculateField "Addresses\Site Address Points" MSAG [COMMUNITY] VB # CalculateField "Addresses\Site Address Points" MSAG [COMMUNITY] VB # UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp9608\460d59b3-cdff-4904-a334-2360005fd472\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AddAttributeRule><rule_name>FullAddressRule</rule_name><rule_type>CALCULATION</rule_type><expression>IIf(IsEmpty($feature.UNITTYPE), ($feature.ADDRNUM+" "+$feature.FULLNAME+","+" "+$feature.COMMUNITY+","+" "+"FL"+" "+$feature.ZIP), ($feature.ADDRNUM+" "+$feature.FULLNAME+","+" "+$feature.UNITTYPE+" "+$feature.UNITID+","+" "+$feature.COMMUNITY+","+" "+"FL"+" "+$feature.ZIP))</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>populate full address field</rule_description><field_name>FULLADDR</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>FullAddressRule</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp4148\7abf8d36-61ae-47f5-b4a0-d8cc1329cdb3\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AddAttributeRule><rule_name>FullAddress</rule_name><rule_type>CALCULATION</rule_type><expression>IIf(IsEmpty($feature.UNITTYPE), ($feature.ADDRNUM+" "+$feature.FULLNAME+","+" "+$feature.COMMUNITY+","+" "+"FL"+" "+$feature.ZIP), ($feature.ADDRNUM+" "+$feature.FULLNAME+","+" "+$feature.UNITTYPE+" "+$feature.UNITID+","+" "+$feature.COMMUNITY+","+" "+"FL"+" "+$feature.ZIP))</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Full address field</rule_description><field_name>FULLADDR</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>FullAddress</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp4148\7abf8d36-61ae-47f5-b4a0-d8cc1329cdb3\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AddAttributeRule><rule_name>SiteAddressID</rule_name><rule_type>CALCULATION</rule_type><expression>NextSequenceValue('SiteAddIDSeq')</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Site address ID field</rule_description><field_name>SITEADDID</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>SiteAddressID</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp4148\7abf8d36-61ae-47f5-b4a0-d8cc1329cdb3\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AddAttributeRule><rule_name>AddressPointID</rule_name><rule_type>CALCULATION</rule_type><expression>NextSequenceValue('AddressPointIDSeq')</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Address point ID field</rule_description><field_name>ADDPTKEY</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>AddressPointID</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp4148\7abf8d36-61ae-47f5-b4a0-d8cc1329cdb3\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AddAttributeRule><rule_name>AddressPointID</rule_name><rule_type>CALCULATION</rule_type><expression>NextSequenceValue('AddressPointIDSeq')</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Address point ID field</rule_description><field_name>ADDPTKEY</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>AddressPointID</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp4148\7abf8d36-61ae-47f5-b4a0-d8cc1329cdb3\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AddAttributeRule><rule_name>AddressPointID</rule_name><rule_type>CALCULATION</rule_type><expression>NextSequenceValue('AddressPointIDSeq')</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Address point ID field</rule_description><field_name>ADDPTKEY</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>AddressPointID</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp4148\7abf8d36-61ae-47f5-b4a0-d8cc1329cdb3\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AddAttributeRule><rule_name>AddressPointID</rule_name><rule_type>CALCULATION</rule_type><expression>NextSequenceValue('AddressPointIDSeq')</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Address point ID field</rule_description><field_name>ADDPTKEY</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>AddressPointID</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp4148\7abf8d36-61ae-47f5-b4a0-d8cc1329cdb3\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AddAttributeRule><rule_name>AddressPointID</rule_name><rule_type>CALCULATION</rule_type><expression>NextSequenceValue('AddressPointIDSeq')</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Address point ID field</rule_description><field_name>ADDPTKEY</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>AddressPointID</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp4148\7abf8d36-61ae-47f5-b4a0-d8cc1329cdb3\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AddAttributeRule><rule_name>AddressPointID</rule_name><rule_type>CALCULATION</rule_type><expression>NextSequenceValue('AddressPointIDSeq')</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Address point ID field</rule_description><field_name>ADDPTKEY</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>AddressPointID</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp4148\7abf8d36-61ae-47f5-b4a0-d8cc1329cdb3\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AddAttributeRule><rule_name>AddressPointID</rule_name><rule_type>CALCULATION</rule_type><expression>NextSequenceValue('AddressPointIDSeq')</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Address point ID field</rule_description><field_name>ADDPTKEY</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>AddressPointID</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp3720\c7a78f43-cb24-47c0-b2d2-49d54e19c27e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AddAttributeRule><rule_name>AddressPointID</rule_name><rule_type>CALCULATION</rule_type><expression>NextSequenceValue('AddressPointIDSeq')</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Address point ID field</rule_description><field_name>ADDPTKEY</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>AddressPointID</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp3720\c7a78f43-cb24-47c0-b2d2-49d54e19c27e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AddAttributeRule><rule_name>AddressPointID</rule_name><rule_type>CALCULATION</rule_type><expression>NextSequenceValue('AddressPointIDSeq')</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Address point ID field</rule_description><field_name>ADDPTKEY</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>AddressPointID</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp17292\64702a0d-74e9-4225-8ae3-8493640182f0\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AlterAttributeRule><rule_name>SiteAddressID</rule_name><rule_description>Site address ID field</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>NextSequenceValue('SiteAddressIDSeq')</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp17292\64702a0d-74e9-4225-8ae3-8493640182f0\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint <operationSequence><workflow><DeleteAttributeRule><rule_name>SiteAddressID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence> UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp17292\64702a0d-74e9-4225-8ae3-8493640182f0\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint <operationSequence><workflow><DeleteAttributeRule><rule_name>SiteAddressID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence> UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp18808\20b0bb11-579c-42ea-a1b1-32c96143bcf0\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AlterAttributeRule><rule_name>SiteAddressID</rule_name><rule_description>Site address ID field</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>NextSequenceValue('SiteAddressIDSeq')</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "G:\GIS\Projects\_Brooke\ATTTRIBUTE RULES\ATTTRIBUTE RULES\putsgisp06(2).sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint" <operationSequence><workflow><DeleteAttributeRule><rule_name>FullAddress</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>SiteAddressID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>AddressPointID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence> UpdateSchema "G:\GIS\Projects\_Brooke\ATTTRIBUTE RULES\ATTTRIBUTE RULES\putsgisp06(2).sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint" "<operationSequence><workflow><AddAttributeRule><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type><expression>IIf(IsEmpty($feature.UNITTYPE), ($feature.ADDRNUM+" "+$feature.FULLNAME+","+" "+$feature.COMMUNITY+","+" "+"FL"+" "+$feature.ZIP), ($feature.ADDRNUM+" "+$feature.FULLNAME+","+" "+$feature.UNITTYPE+" "+$feature.UNITID+","+" "+$feature.COMMUNITY+","+" "+"FL"+" "+$feature.ZIP))</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><field_name>FULLADDR</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Full Address</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema "G:\GIS\Projects\_Brooke\ATTTRIBUTE RULES\ATTTRIBUTE RULES\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint" "<operationSequence><workflow><AddAttributeRule><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type><expression>IIf(IsEmpty($feature.UNITTYPE), ($feature.ADDRNUM+" "+$feature.FULLNAME+","+" "+$feature.COMMUNITY+","+" "+"FL"+" "+$feature.ZIP), ($feature.ADDRNUM+" "+$feature.FULLNAME+","+" "+$feature.UNITTYPE+" "+$feature.UNITID+","+" "+$feature.COMMUNITY+","+" "+"FL"+" "+$feature.ZIP))</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><field_name>FULLADDR</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Full Address</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema "G:\GIS\Projects\_Brooke\ATTTRIBUTE RULES\ATTTRIBUTE RULES\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>IIf(IsEmpty($feature.UNITTYPE), ($feature.UNITID+" "+$feature.FULLNAME+","+" "+$feature.COMMUNITY+","+" "+"FL"+" "+$feature.ZIP), ($feature.ADDRNUM+" "+$feature.FULLNAME+","+" "+$feature.UNITTYPE+" "+$feature.UNITID+","+" "+$feature.COMMUNITY+","+" "+"FL"+" "+$feature.ZIP))</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp2976\64e81e78-e27e-4cd9-a8d4-a4eecf0d6acc\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><DeleteAttributeRule><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp2976\64e81e78-e27e-4cd9-a8d4-a4eecf0d6acc\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><DeleteAttributeRule><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp2976\64e81e78-e27e-4cd9-a8d4-a4eecf0d6acc\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><DeleteAttributeRule><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19148\fded4294-08e6-43de-8cb0-1fcf7341cc6e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><DeleteAttributeRule><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19148\fded4294-08e6-43de-8cb0-1fcf7341cc6e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><DeleteAttributeRule><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>" AddAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19452\b3874743-b44e-4ac8-b5b5-ff7114e4ac4e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint FullAddress Calculation IIf(IsEmpty($feature.UNITTYPE), ($feature.ADDRNUM+" "+$feature.FULLNAME+","+" "+$feature.COMMUNITY+","+" "+"FL"+" "+$feature.ZIP), ($feature.ADDRNUM+" "+$feature.FULLNAME+","+" "+$feature.UNITTYPE+" "+$feature.UNITID+","+" "+$feature.COMMUNITY+","+" "+"FL"+" "+$feature.ZIP)) EDITABLE INSERT;UPDATE # # "Populate full address field" # FULLADDR INCLUDE NOT_BATCH # # AddGlobalIDs C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19452\b3874743-b44e-4ac8-b5b5-ff7114e4ac4e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint AddAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19452\b3874743-b44e-4ac8-b5b5-ff7114e4ac4e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "Add ESN" Calculation "// Create reference to the ESN layer in the map var zones = FeatureSetByName($datastore,"EmergencyServiceZones",["ESN"],true) // Get a feature set of zones that intersect the address var intersectingZones = Intersects(zones, Geometry($feature)) // Select the first record in the feature set var matchedZone = First(intersectingZones) // Return the ESN value of the selected zone return IIf(IsEmpty(matchedZone), null, matchedZone.ESN);" EDITABLE INSERT;UPDATE # # "Add ESN to address point" # ESN INCLUDE NOT_BATCH # # AddAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19452\b3874743-b44e-4ac8-b5b5-ff7114e4ac4e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint Zipcode Calculation "// Create reference to the Zip code layer in the map var zip = FeatureSetByName($datastore,"Zipcodes",["ZIP"],true) // Get a feature set of zones that intersect the address var intersectingZip = Intersects(zip, Geometry($feature)) // Select the first record in the feature set var matchedZip = First(intersectingZip) // Return the ESN value of the selected zone return IIf(IsEmpty(matchedZip), null, matchedZip.ZIP);" EDITABLE INSERT;UPDATE # # "Populate zip code" # ZIP INCLUDE NOT_BATCH # # AddAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19452\b3874743-b44e-4ac8-b5b5-ff7114e4ac4e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "Municipality Name" Calculation "// Create reference to the municipality layer in the map var muni = FeatureSetByName($datastore,"MunicipalBoundary",["NAME"],true) // Get a feature set of the municipality that intersect the address var intersectingmuni = Intersects(muni, Geometry($feature)) // Select the first record in the feature set var matchedmuni = First(intersectingmuni) // Return the ESN value of the selected zone return IIf(IsEmpty(matchedmuni), null, matchedmuni.NAME);" EDITABLE INSERT;UPDATE # # "Populate municipality name field" # MUNICIPALITY INCLUDE NOT_BATCH # # AddAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19452\b3874743-b44e-4ac8-b5b5-ff7114e4ac4e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint Community Calculation "// Create reference to the community layer in the map var community = FeatureSetByName($datastore,"CommunityBoundary",["COMMUNITY"],true) // Get a feature set of the community that intersect the address var intersectingcommunity = Intersects(community, Geometry($feature)) // Select the first record in the feature set var matchedcommunity = First(intersectingcommunity) // Return the community of the selected record return IIf(IsEmpty(matchedcommunity), null, matchedcommunity.COMMUNITY);" EDITABLE INSERT;UPDATE # # "Populate community field" # COMMUNITY INCLUDE NOT_BATCH # # AddAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19452\b3874743-b44e-4ac8-b5b5-ff7114e4ac4e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "USNG Coordinate" Calculation "// Create reference to the US national grid layer in the map var USNG = FeatureSetByName($datastore,"USNationalGrid",["USNGCOORD"],true) // Get a feature set of coordinates that intersect the address var intersectingUSNG = Intersects(USNG, Geometry($feature)) // Select the first record in the feature set var matchedUSNG = First(intersectingUSNG) // Return the USNG coordinate value of the selected zone return IIf(IsEmpty(matchedUSNG), null, matchedUSNG.USNGCOORD);" EDITABLE INSERT;UPDATE # # "Populate USNG coordinate" # USNGCOORD INCLUDE NOT_BATCH # # AddAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19452\b3874743-b44e-4ac8-b5b5-ff7114e4ac4e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint Longitude Calculation "var polyx = text(centroid($feature).x); " EDITABLE INSERT;UPDATE # # "Populate long field" # GPSX INCLUDE NOT_BATCH # # AddAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19452\b3874743-b44e-4ac8-b5b5-ff7114e4ac4e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint AddressPointID Calculation NextSequenceValue('ADDRESSPOINTIDSEQUENCE') EDITABLE INSERT # # "Populate address point id using database sequence" # ADDPTKEY INCLUDE NOT_BATCH # # AddAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19452\b3874743-b44e-4ac8-b5b5-ff7114e4ac4e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint AddressPointID Calculation NextSequenceValue('ADDRESSPOINTIDSEQUENCE') EDITABLE INSERT # # "Populate address point id using database sequence" # ADDPTKEY EXCLUDE NOT_BATCH # # AddAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19452\b3874743-b44e-4ac8-b5b5-ff7114e4ac4e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "Site Address ID" Calculation NextSequenceValue('SITEADDRESSIDSEQUENCE') EDITABLE INSERT # # "Populate site address ID using database sequence" # SITEADDID EXCLUDE NOT_BATCH # # AddAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19452\b3874743-b44e-4ac8-b5b5-ff7114e4ac4e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint MSAGCommunity Calculation "// Create reference to the community layer in the map var MSAGcommunity = FeatureSetByName($datastore,"putlgim.SDE.CommunityBoundary",["COMMUNITY"],true) // Get a feature set of the community that intersect the address var intersectingMSAGcommunity = Intersects(MSAGcommunity, Geometry($feature)) // Select the first record in the feature set var matchedMSAGcommunity = First(intersectingMSAGcommunity) // Return the community of the selected record return IIf(IsEmpty(matchedMSAGcommunity), null, matchedMSAGcommunity.COMMUNITY);" EDITABLE INSERT;UPDATE # # "Populate MSAG community" # MSAG INCLUDE NOT_BATCH # # AddAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp19452\b3874743-b44e-4ac8-b5b5-ff7114e4ac4e\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint PSAP Calculation "1640" EDITABLE INSERT # # "Populate PSAP field with code 1640" # PSAP INCLUDE NOT_BATCH # # UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp18584\4d8b4b04-415f-4154-a6c8-fa2d8b5e2dce\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow /><workflow /></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp18584\4d8b4b04-415f-4154-a6c8-fa2d8b5e2dce\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AlterAttributeRule><rule_name>AddressPointID</rule_name><rule_description>Populate address point id using database sequence</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>NextSequenceValue('putlgim.SDE.ADDRESSPOINTIDSEQUENCE')</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow><workflow><AlterAttributeRule><rule_name>Site Address ID</rule_name><rule_description>Populate site address ID using database sequence</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>NextSequenceValue('putlgim.SDE.SITEADDRESSIDSEQUENCE')</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp18584\4d8b4b04-415f-4154-a6c8-fa2d8b5e2dce\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AlterAttributeRule><rule_name>AddressPointID</rule_name><rule_description>Populate address point id using database sequence</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>NextSequenceValue('putlgim.SDE.ADDRESSPOINTIDSEQUENCE')</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp18584\4d8b4b04-415f-4154-a6c8-fa2d8b5e2dce\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><AlterAttributeRule><rule_name>Site Address ID</rule_name><rule_description>Populate site address ID using database sequence</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>NextSequenceValue('SITEADDRESSIDSEQUENCE')</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" DeleteAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp10660\04a19577-75e3-4a4c-b221-f230da581318\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint 'Site Address ID' Calculation DeleteAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp10660\04a19577-75e3-4a4c-b221-f230da581318\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint 'Site Address ID' Calculation AddAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp3012\dccdbfbd-a186-40f1-aeee-7882bc5bc739\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "Site Address ID" Calculation NextSequenceValue('SiteAddressIDSequenceNew') EDITABLE INSERT # # "Populate site address ID using database sequence" # SITEADDID EXCLUDE NOT_BATCH # # DeleteAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp16984\4f6923c5-dde2-4903-9605-bc0006d303c9\putsgisp06(1).sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint 'Site Address ID' Calculation AddAttributeRule C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp16984\4f6923c5-dde2-4903-9605-bc0006d303c9\putsgisp06(1).sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint SiteAddressID Calculation NextSequenceValue('putlgim.SDE.SiteAddressIDSequenceNew') EDITABLE INSERT # # "Populate site address ID using database sequence" # SITEADDID EXCLUDE NOT_BATCH # # 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/2.8.0'><FeatureDataset>putlgim.SDE.Address</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e684c5439724b4c61513756345a39634765724a345436456d6b65716e68412f436f387042756b442f7169536f3d2a00;SERVER=putsgisp06;INSTANCE=sde:sqlserver:putsgisp06;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisp06;DATABASE=putlgim;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putlgim.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>STATUS</field_name></RemoveDomainFromField></workflow></operationSequence> 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/2.8.0'><FeatureDataset>putlgim.SDE.Address</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e684c5439724b4c61513756345a39634765724a345436456d6b65716e68412f436f387042756b442f7169536f3d2a00;SERVER=putsgisp06;INSTANCE=sde:sqlserver:putsgisp06;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisp06;DATABASE=putlgim;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putlgim.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>STATUS</field_name><domain_name>AddressStatus</domain_name></AssignDomainToField></workflow></operationSequence> 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/2.8.0'><FeatureDataset>putlgim.SDE.Address</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e684c5439724b4c61513756345a39634765724a345436456d6b65716e68412f436f387042756b442f7169536f3d2a00;SERVER=putsgisp06;INSTANCE=sde:sqlserver:putsgisp06;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisp06;DATABASE=putlgim;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putlgim.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>STATUS</field_name></RemoveDomainFromField></workflow></operationSequence> UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp13032\2a593462-49a5-4ccc-aea8-a11269ab1f73\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint <operationSequence><workflow><DeleteAttributeRule><rule_name>FullAddress</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence> UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp13032\2a593462-49a5-4ccc-aea8-a11269ab1f73\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint <operationSequence><workflow><DeleteAttributeRule><rule_name>FullAddress</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence> UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp13032\2a593462-49a5-4ccc-aea8-a11269ab1f73\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><DeleteAttributeRule><rule_name>Add ESN</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Zipcode</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Municipality Name</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>" UpdateSchema C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp13032\2a593462-49a5-4ccc-aea8-a11269ab1f73\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint "<operationSequence><workflow><DeleteAttributeRule><rule_name>Community</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>USNG Coordinate</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Longitude</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>AddressPointID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>MSAGCommunity</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>PSAP</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>SiteAddressID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>" CalculateField "Site Address Points" PSAP "1640" "Python 3" # Text NO_ENFORCE_DOMAINS CopyFeatures C:\Users\btil08\AppData\Local\Temp\2\ArcGISProTemp1920\d84448b0-ca57-42a7-bdbc-047c3239cfcf\putsgisp06.sde\putlgim.SDE.Address\putlgim.SDE.SiteAddressPoint C:\Users\btil08\AppData\Local\Temp\2\ArcGISProTemp1920\d84448b0-ca57-42a7-bdbc-047c3239cfcf\putsgisdbv01.sde\putnamgis.SDE.E911\putnamgis.SDE.SiteAddressPoint # # # # 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.0.0'><FeatureDataset>putnamgis.SDE.E911</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686376643563743065794831356e5655706a4f7478544639727864373447654b6e4653514f6d4f732b4661383d2a00;ENCRYPTED_PASSWORD=00022e6874576c4445584b545157694672463551304b42395671374a6855796a6937394269317766535a61646270413d2a00;SERVER=putsgisdbv01;INSTANCE=sde:sqlserver:putsgisdbv01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisdbv01;DATABASE=putnamgis;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putnamgis.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>created_user</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>created_date</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>last_edited_user</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>last_edited_date</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> 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.0.0'><FeatureDataset>putnamgis.SDE.E911</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686376643563743065794831356e5655706a4f7478544639727864373447654b6e4653514f6d4f732b4661383d2a00;ENCRYPTED_PASSWORD=00022e6874576c4445584b545157694672463551304b42395671374a6855796a6937394269317766535a61646270413d2a00;SERVER=putsgisdbv01;INSTANCE=sde:sqlserver:putsgisdbv01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisdbv01;DATABASE=putnamgis;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putnamgis.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>created_user</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>created_date</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>last_edited_user</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>last_edited_date</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> 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>putnamgis.SDE.E911</FeatureDataset><WorkspaceConnectionString>SERVER=putsgisdbv01;INSTANCE=sde:sqlserver:putsgisdbv01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisdbv01;DATABASE=putnamgis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putnamgis.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>VEP_ID</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> 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>putnamgis.SDE.E911</FeatureDataset><WorkspaceConnectionString>SERVER=putsgisdbv01;INSTANCE=sde:sqlserver:putsgisdbv01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisdbv01;DATABASE=putnamgis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putnamgis.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>VEP_ID</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> 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>putnamgis.SDE.E911</FeatureDataset><WorkspaceConnectionString>SERVER=putsgisdbv01;INSTANCE=sde:sqlserver:putsgisdbv01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisdbv01;DATABASE=putnamgis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putnamgis.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>VEP_ID</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField putnamgis.SDE.SiteAddressPoint VEP_ID !OBJECTID! Python # Text NO_ENFORCE_DOMAINS CopyFeatures SiteAddressPoint_111723 G:\e911\Projects\DataMark\DataExport\DataExport_11172023.gdb\SiteAddressPoint_111723 # # # # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.1.0'><WorkspaceConnectionString>DATABASE=C:\Putnam, FL\7_VEP_Onboarding\Data\Data NOV 2023\DataExport_11172023.gdb\DataExport_11172023.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint_111723</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>DiscrpAgID</field_name><field_type>TEXT</field_type><field_length>100</field_length><field_alias>Discrepancy Agency ID</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Country</field_name><field_type>TEXT</field_type><field_length>2</field_length><field_alias>Country</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>State</field_name><field_type>TEXT</field_type><field_length>2</field_length><field_alias>State or Equivalent (A1)</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>County</field_name><field_type>TEXT</field_type><field_length>100</field_length><field_alias>County or Equivalent (A2)</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Add_Number</field_name><field_type>LONG</field_type><field_alias>Address Number</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>St_PreMod</field_name><field_type>TEXT</field_type><field_length>15</field_length><field_alias>Street Name Pre Modifier</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>St_PreDir</field_name><field_type>TEXT</field_type><field_length>10</field_length><field_alias>Street Name Pre Directional</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>St_PreTyp</field_name><field_type>TEXT</field_type><field_length>50</field_length><field_alias>Street Name Pre Type</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>St_Name</field_name><field_type>TEXT</field_type><field_length>254</field_length><field_alias>Street Name</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>St_PosTyp</field_name><field_type>TEXT</field_type><field_length>50</field_length><field_alias>Street Name Post Type</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>St_PosDir</field_name><field_type>TEXT</field_type><field_length>10</field_length><field_alias>Street Name Post Directional</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>St_PosMod</field_name><field_type>TEXT</field_type><field_length>25</field_length><field_alias>Street Name Post Modifier</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>LSt_PreDir</field_name><field_type>TEXT</field_type><field_length>2</field_length><field_alias>Legacy Street Name Pre Directional</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>LSt_Name</field_name><field_type>TEXT</field_type><field_length>75</field_length><field_alias>Legacy Street Name</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>LSt_Typ</field_name><field_type>TEXT</field_type><field_length>4</field_length><field_alias>Legacy Street Name Type</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>LSt_PosDir</field_name><field_type>TEXT</field_type><field_length>2</field_length><field_alias>Legacy Street Name Post Directional</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>external_nguid</field_name><field_type>LONG</field_type><field_alias>external_nguid</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>" CalculateField SiteAddressPoint_111723 Country "US" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 State "KY" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 County "Crittenden" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 Add_Number !ADDRNUM! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 external_nguid autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 1 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 external_nguid autoIncrement() "Python 3" "rec=0 def autoIncrement(): global rec pStart = 1 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 LSt_Name !FULLNAME! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 LSt_Name !LSt_Name!.upper() "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 St_PreDir longstr( !LSt_PreDir! ) "Python 3" "def longstr(abbv): if abbv == 'W': return 'West' elif abbv == 'N': return 'North' elif abbv == 'S': return 'South' elif abbv == 'NE': return 'Northeast' elif abbv == 'E': return 'East' elif abbv == 'NW': return 'Northwest' elif abbv == 'SE': return 'Southeast' elif abbv == 'SW': return 'Southwest' else: return abbv" Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 St_PosDir longstr( !LSt_PosDir! ) "Python 3" "def longstr(abbv): if abbv == 'W': return 'West' elif abbv == 'N': return 'North' elif abbv == 'S': return 'South' elif abbv == 'NE': return 'Northeast' elif abbv == 'E': return 'East' elif abbv == 'NW': return 'Northwest' elif abbv == 'SE': return 'Southeast' elif abbv == 'SW': return 'Southwest' else: return abbv" Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 St_PosTyp longstr( !LSt_Typ! ) "Python 3" "def longstr(abbv): abbv = abbv.upper() if abbv in ('AV','AVE','AVEN','AVENU','AVENUE','AVN','AVNUE'): return 'Avenue' elif abbv in ('AL','ALY','ALLEE','ALLEY','ALLY','ALY'): return 'Alley' elif abbv in ('ANX','ANEX','ANNEX','ANNX','ANX'): return 'Anex' elif abbv in ('ARC','ARCADE','ARC'): return 'Arcade' elif abbv in ('BAYOO','BYU','BAYOU'): return 'Bayou' elif abbv in ('BCH','BEACH'): return 'Beach' elif abbv in ('BEND','BND'): return 'Bend' elif abbv in ('BLF','BLUF','BLUFF'): return 'Bluff' elif abbv in ('BLFS','BLUFFS'): return 'Bluffs' elif abbv in ('BOT','BTM','BOTTM','BOTTOM'): return 'Bottom' elif abbv in ('BL','BLVD','BOULV','BOULEVARD'): return 'Boulevard' elif abbv in ('BR','BRNCH','BRANCH'): return 'Branch' elif abbv in ('BRG','BRDGE','BRIDGE'): return 'Bridge' elif abbv in ('BRK','BROOK'): return 'Brook' elif abbv in ('BRKS','BROOKS'): return 'Brooks' elif abbv in ('BG','BURG'): return 'Burg' elif abbv in ('BGS','BURGS'): return 'Burgs' elif abbv in ('BYP','BYPA','BYPAS','BYPASS','BYPS'): return 'Bypass' elif abbv in ('CAMP','CP','CMP'): return 'Camp' elif abbv in ('CANYN','CYN','CNYN','CANYON'): return 'Canyon' elif abbv in ('CPE','CAPE'): return 'Cape' elif abbv in ('CAUSEWAY','CSWY','CAUSWA','CSWY'): return 'Causeway' elif abbv in ('CEN','CTR','CENT','CENTER','CENTR','CNTR'): return 'Center' elif abbv in ('CTRS','CENTERS'): return 'Centers' elif abbv in ('CL','CIR','CIRC','CIRCL','CIRCLE','CRCL','CRCLE','CR'): return 'Circle' elif abbv in ('CIRCLES','CIRS'): return 'Circles' elif abbv in ('CLF','CLIFF'): return 'Cliff' elif abbv in ('CLFS','CLIFFS'): return 'Cliffs' elif abbv in ('CLB','CLUB'): return 'Club' elif abbv in ('CMN','COMMON'): return 'Common' elif abbv in ('CMNS','COMMONS'): return 'Commons' elif abbv in ('COR','CORNER'): return 'Corner' elif abbv in ('CORS','CORNERS'): return 'Corners' elif abbv in ('COURSE','CRSE'): return 'Course' elif abbv in ('CT','COURT'): return 'Court' elif abbv in ('CTS', 'COURTS'): return 'Court' elif abbv in ('CV','COVE'): return 'Cove' elif abbv in ('CVS','COVES'): return 'Coves' elif abbv in ('CREEK','CRK'): return 'Creek' elif abbv in ('CRESCENT','CRES','CRSENT','CRSNT'): return 'Crescent' elif abbv in ('CREST','CRST'): return 'Crest' elif abbv in ('CROSSING','CRSSNG','XING'): return 'Crossing' elif abbv in ('XRD','CROSSROAD'): return 'Crossroad' elif abbv in ('XRDS','CROSSROADS'): return 'Crossroads' elif abbv in ('CURVE','CURV'): return 'Curve' elif abbv in ('DALE','DL'): return 'Dale' elif abbv in ('DAM','DM'): return 'Dam' elif abbv in ('DIV','DIVIDE'): return 'Divide' elif abbv in ('DR','DRIVE','DRIV','DRV'): return 'Drive' elif abbv in ('DRS','DRIVES'): return 'Drives' elif abbv in ('EST','ESTATE'): return 'Estate' elif abbv in ('ESTS','ESTATES'): return 'Estates' elif abbv in ('EXPY','EX','EXP','EXPR','EXPRESS','EXPW','EXPRESSWAY'): return 'Expressway' elif abbv in ('EXT','EXTENSION','EXTN','EXTNSN'): return 'Extension' elif abbv in ('EXTS','EXTENSIONS'): return 'Extensions' elif abbv == 'FALL': return 'Fall' elif abbv in ('FALLS','FLS'): return 'Falls' elif abbv in ('FERRY','FRY','FRRY'): return 'Ferry' elif abbv in ('FIELD','FLD'): return 'Field' elif abbv in ('FIELDS','FLDS'): return 'Fields' elif abbv in ('FLAT','FLT'): return 'Flat' elif abbv in ('FLATS','FLTS'): return 'Flats' elif abbv in ('FORD','FRD'): return 'Ford' elif abbv in ('FORDS','FRDS'): return 'Fords' elif abbv in ('FOREST','FRST','FORESTS'): return 'Forest' elif abbv in ('FORG','FRG','FORGE'): return 'Forge' elif abbv in ('FORGES','FRGS'): return 'Forges' elif abbv in ('FORK','FRK'): return 'Fork' elif abbv in ('FORKS','FRKS'): return 'Forks' elif abbv in ('FORT','FRT','FT'): return 'Fort' elif abbv in ('FY','FWY','FREEWAY','FREEWY','FRWY'): return 'Freeway' elif abbv in ('GARDEN','GDN','GARDN','GARDEN'): return 'Garden' elif abbv in ('GARDENS','GDNS','GARDNS','GARDENS'): return 'Gardens' elif abbv in ('GATEWAY','GTWY','GATEWY','GATWAY','GTWAY'): return 'Gateway' elif abbv in ('GLEN','GLN'): return 'Glen' elif abbv in ('GLENS','GLNS'): return 'Glens' elif abbv in ('GREEN','GRN'): return 'Green' elif abbv in ('GROVE','GRV','GROV'): return 'Grove' elif abbv in ('GROVES','GRVS'): return 'Groves' elif abbv == 'GRD': return 'GRADE' elif abbv == 'GT': return 'GATE' elif abbv in ('HARB','HBR','HARBOR','HARBR','HRBOR'): return 'Harbor' elif abbv in ('HARBORS','HBRS'): return 'Harbors' elif abbv in ('HAVEN','HVN'): return 'Haven' elif abbv in ('HEIGHTS','HT','HTS'): return 'Heights' elif abbv in ('HY','HIGHWAY','HWY','HIWAY','HWAY','HIGHWY'): return 'Highway' elif abbv in ('HILL','HL'): return 'Hill' elif abbv in ('HILLS','HLS'): return 'Hills' elif abbv in ('HOLLOW','HLLW','HOLW','HOLLOWS','HOLWS'): return 'Hollow' elif abbv in ('INLET','INLT'): return 'Inlet' elif abbv in ('ISLAND','IS','ISLND'): return 'Island' elif abbv in ('ISLANDS','ISS','ISLNDS'): return 'Islands' elif abbv in ('ISLE','ISLES'): return 'Isle' elif abbv in ('JCT','JCTION','JCTN','JUNCTION','JUNCTN','JUNCTON'): return 'Junction' elif abbv in ('JCTNS','JCTS','JUNCTIONS'): return 'Junctions' elif abbv in ('KEY','KY'): return 'Key' elif abbv in ('KEYS','KYS'): return 'Keys' elif abbv in ('KNL','KNOLL','KNOL'): return 'Knoll' elif abbv in ('KNLS','KNOLLS'): return 'Knolls' elif abbv in ('LK','LAKE'): return 'Lake' elif abbv in ('LKS','LAKES'): return 'Lakes' elif abbv == 'LAND': return 'Land' elif abbv in ('LNDG','LD','LANDING','LNDNG'): return 'Landing' elif abbv in ('LN','LANE'): return 'Lane' elif abbv in ('LGT','LIGHT'): return 'Light' elif abbv in ('LGTS','LIGHTS'): return 'Lights' elif abbv in ('LF','LOAF'): return 'Loaf' elif abbv in ('LCK','LOCK'): return 'Lock' elif abbv in ('LCKS','LOCKS'): return 'Locks' elif abbv in ('LDG','LDGE','LODG','LODGE'): return 'Lodge' elif abbv in ('LP','LOOP','LOOPS'): return 'Loop' elif abbv == 'MALL': return 'Mall' elif abbv in ('MNR','MANOR'): return 'Manor' elif abbv in ('MNRS','MANORS'): return 'Manors' elif abbv in ('MEADOW','MDW'): return 'Meadow' elif abbv in ('MEADOWS','MDWS','MEDOWS'): return 'Meadows' elif abbv == 'MEWS': return 'Mews' elif abbv in ('ML','MILL'): return 'Mill' elif abbv in ('MILLS','MLS'): return 'Mills' elif abbv in ('MISSN','MSN','MISSION','MSSN'): return 'Mission' elif abbv in ('MOTORWAY','MTWY'): return 'Motorway' elif abbv in ('MOUNT','MT','MNT'): return 'Mount' elif abbv in ('MOUNTAIN','MNTAIN','MTN','MNTN','MOUNTIN','MTIN'): return 'Mountain' elif abbv in ('MOUNTAINS','MTNS','MNTNS'): return 'Mountains' elif abbv in ('NCK','NECK'): return 'Neck' elif abbv in ('ORCHARD','ORCH','ORCHRD'): return 'Orchard' elif abbv in ('OVAL','OVL'): return 'Oval' elif abbv in ('OVERPASS','OPASS'): return 'Overpass' elif abbv in ('PARK','PRK','PK'): return 'Park' elif abbv in ('PARKS','PRKS'): return 'Parks' elif abbv in ('PARKWAY','PKWY','PARKWY','PKWAY','PKY'): return 'Parkway' elif abbv in ('PARKWAYS','PKWYS'): return 'Parkways' elif abbv == 'PASS': return 'Pass' elif abbv in ('PASSAGE','PSGE'): return 'Passage' elif abbv in ('PATH','PATHS'): return 'Path' elif abbv in ('PIKE','PIKES','PKE'): return 'Pike' elif abbv in ('PINE','PNE'): return 'Pine' elif abbv in ('PINES','PNES'): return 'Pines' elif abbv in ('PL','PLACE'): return 'Place' elif abbv in ('PLAIN','PLN'): return 'Plain' elif abbv in ('PLAINS','PLNS'): return 'Plains' elif abbv in ('PLAZA','PLZ','PLZA'): return 'Plaza' elif abbv in ('POINT','PT'): return 'Point' elif abbv in ('POINTS','PTS'): return 'Points' elif abbv in ('PORT','PRT'): return 'Port' elif abbv in ('PORTS','PRTS'): return 'Ports' elif abbv in ('PRAIRIE','PR'): return 'Prairie' elif abbv in ('RAD','RADL','RADIAL','RADIEL'): return 'Radial' elif abbv == 'RAMP': return 'Ramp' elif abbv in ('RANCH','RNCH','RANCHES','RNCHS'): return 'Ranch' elif abbv in ('RAPID','RPD'): return 'Rapid' elif abbv in ('RAPIDS','RPDS'): return 'Rapids' elif abbv in ('REST','RST'): return 'Rest' elif abbv in ('RIDGE','RDG','RDGE'): return 'Ridge' elif abbv in ('RIDGES','RDGS','RDGS'): return 'Ridges' elif abbv in ('RIVER','RIV','RIVR'): return 'River' elif abbv in ('RD','ROAD'): return 'Road' elif abbv in ('RDS','ROADS'): return 'Roads' elif abbv in ('ROUTE','RTE'): return 'Route' elif abbv == 'ROW': return 'Row' elif abbv == 'RUE': return 'Rue' elif abbv == 'RUN': return 'Run' elif abbv in ('SHL','SHOAL'): return 'Shoal' elif abbv in ('SHLS','SHOALS'): return 'Shoals' elif abbv in ('SHOAR','SHR','SHORE'): return 'Shore' elif abbv in ('SHOARS','SHRS','SHORES'): return 'Shores' elif abbv in ('SKYWAY','SKWY'): return 'Skyway' elif abbv in ('SPRING','SPG','SPNG','SPRNG'): return 'Spring' elif abbv in ('SPRINGS','SPGS','SPNGS','SPRNGS'): return 'Springs' elif abbv == 'SPUR': return 'Spur' elif abbv == 'SPURS': return 'Spurs' elif abbv in ('SQ','SQUARE','SQR','SQU','SQRE'): return 'Square' elif abbv in ('SQS','SQUARES','SQRS'): return 'Squares' elif abbv in ('STA','STATION','STATN','STN'): return 'Station' elif abbv in ('STRA','STRAV','STRAVEN','STRAVENUE','STRAVN','STRVNUE'): return 'Stravenue' elif abbv in ('STREAM','STRM','STREME'): return 'Stream' elif abbv in ('ST','STREET','STRT'): return 'Street' elif abbv in ('STS','STREETS'): return 'Streets' elif abbv in ('SUMMIT','SMT','SUMIT','SUMITT'): return 'Summit' elif abbv in ('TERR','TER','TERRACE'): return 'Terrace' elif abbv in ('THROUGHWAY','TRWY'): return 'Throughway' elif abbv in ('TRACE','TRCE','TRACES'): return 'Trace' elif abbv in ('TRACK','TRK','TRKS','TRACKS','TRAK'): return 'Track' elif abbv in ('TRAFFICWAY','TRFY'): return 'Trafficway' elif abbv in ('TRL','TRAIL','TRLS','TRAILS','TR'): return 'Trail' elif abbv in ('TRAILER','TRLR','TRLRS'): return 'Trailer' elif abbv in ('TUNNEL','TUNNELS','TUNL','TUN','TUNEL','TUNLS','TUNNL'): return 'Tunnel' elif abbv in ('TRNPK','TPKE','TURNPIKE','TURNPK'): return 'Turnpike' elif abbv in ('UNDERPASS','UPASS'): return 'Underpass' elif abbv in ('UN','UNION'): return 'Union' elif abbv in ('UNS','UNIONS'): return 'Unions' elif abbv in ('VALLEY','VLY','VALLY','VLLY'): return 'Valley' elif abbv in ('VALLEYS','VLYS'): return 'Valleys' elif abbv in ('VDCT','VIA','VIADUCT','VIADCT'): return 'Viaduct' elif abbv in ('VIEW','VW'): return 'View' elif abbv in ('VIEWS','VWS'): return 'Views' elif abbv in ('VILLAGE','VILL','VLG','VILLAG','VILLG','VILLIAGE'): return 'Village' elif abbv in ('VILLAGES','VLGS'): return 'Villages' elif abbv in ('VILLE','VL'): return 'Ville' elif abbv in ('VIS','VISTA','VIST','VST','VSTA'): return 'Vista' elif abbv == 'WALK': return 'Walk' elif abbv == 'WALKS': return 'Walks' elif abbv == 'WALL': return 'Wall' elif abbv == 'WW': return 'Walkway' elif abbv in ('WY','WAY'): return 'Way' elif abbv == 'WAYS': return 'Ways' elif abbv in ('WELL','WL'): return 'Well' elif abbv in ('WELLS','WLS'): return 'Wells' else: return abbv.title()" Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 St_Name !LSt_Name!.title() "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 St_Name !LSt_Name!.title() "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 St_Name !St_Name!.lower() "Python 3" # Text NO_ENFORCE_DOMAINS UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.1.0'><WorkspaceConnectionString>DATABASE=C:\Putnam, FL\7_VEP_Onboarding\Data\Data NOV 2023\DataExport_11172023.gdb\DataExport_11172023.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint_111723</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>St_PreSep</field_name><field_type>TEXT</field_type><field_length>20</field_length><field_alias>Street Name Pre Type Separator</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.1.0'><WorkspaceConnectionString>DATABASE=C:\Putnam, FL\7_VEP_Onboarding\Data\Data NOV 2023\DataExport_11172023.gdb\DataExport_11172023.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint_111723</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>NGUID</field_name><field_type>TEXT</field_type><field_length>254</field_length><field_alias>NENA Globally Unique ID</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>" AlterField SiteAddressPoint_111723 POINTTYPE # # Text 50 NULLABLE DO_NOT_CLEAR CalculateField SiteAddressPoint_111723 County "Putnam" "Python 3" # Text NO_ENFORCE_DOMAINS UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\Jeremy.Mangin\DATAMARK\Data_Services\FL_Putnam\Parsing\DataExport_SE_20231122_ReadyforQC.gdb\DataExport_11172023.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint_111723</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Uninc_Comm</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField SiteAddressPoint_111723 MUNICIPALITY !MUNICIPALITY!.title() "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 MUNICIPALITY !MUNICIPALITY!.title() "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 County "Putnam County" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField SiteAddressPoint_111723 State "FL" "Python 3" # Text NO_ENFORCE_DOMAINS FeatureClassToFeatureClass SiteAddressPoint_111723 C:\Users\Jeremy.Mangin\DATAMARK\Data_Services\FL_Putnam\Parsing\DataExport_SE_20231122_ReadyforQC.gdb\DataExport_11172023.gdb SiteAddressPoint_111723_ # "SITEADDID "Site Address ID" true true false 20 Text 0 0,First,#,SiteAddressPoint_111723,SITEADDID,0,20;ADDPTKEY "Address Point ID" true true false 20 Text 0 0,First,#,SiteAddressPoint_111723,ADDPTKEY,0,20;PREADDRNUM "Address Number Prefix" true true false 5 Text 0 0,First,#,SiteAddressPoint_111723,PREADDRNUM,0,5;ADDRNUMSUF "Address Number Suffix" true true false 5 Text 0 0,First,#,SiteAddressPoint_111723,ADDRNUMSUF,0,5;ADDRNUM "Full Address Number" true true false 20 Text 0 0,First,#,SiteAddressPoint_111723,ADDRNUM,0,20;ADDRRANGE "Address Range" true true false 50 Text 0 0,First,#,SiteAddressPoint_111723,ADDRRANGE,0,50;UNITTYPE "Address Unit Type" true true false 10 Text 0 0,First,#,SiteAddressPoint_111723,UNITTYPE,0,10;UNITID "Address Unit Number" true true false 10 Text 0 0,First,#,SiteAddressPoint_111723,UNITID,0,10;ALTUNITTYPE "Alternate Address Unit Type" true true false 10 Text 0 0,First,#,SiteAddressPoint_111723,ALTUNITTYPE,0,10;ALTUNITID "Alternate Address Unit Number" true true false 10 Text 0 0,First,#,SiteAddressPoint_111723,ALTUNITID,0,10;FULLNAME "Full Road Name" true true false 125 Text 0 0,First,#,SiteAddressPoint_111723,FULLNAME,0,125;FULLADDR "Full Address" true true false 250 Text 0 0,First,#,SiteAddressPoint_111723,FULLADDR,0,250;PLACENAME "Place Name" true true false 250 Text 0 0,First,#,SiteAddressPoint_111723,PLACENAME,0,250;MUNICIPALITY "Municipality Name" true true false 100 Text 0 0,First,#,SiteAddressPoint_111723,MUNICIPALITY,0,100;ESN "Emergency Service Number" true true false 5 Text 0 0,First,#,SiteAddressPoint_111723,ESN,0,5;PSAP "Public Safety Answering Point" true true false 4 Text 0 0,First,#,SiteAddressPoint_111723,PSAP,0,4;MSAG "MSAG Community" true true false 35 Text 0 0,First,#,SiteAddressPoint_111723,MSAG,0,35;USNGCOORD "USNG Coordinate" true true false 50 Text 0 0,First,#,SiteAddressPoint_111723,USNGCOORD,0,50;ADDRCLASS "Description" true true false 4 Long 0 0,First,#,SiteAddressPoint_111723,ADDRCLASS,-1,-1;POINTTYPE "Location" true true false 50 Text 0 0,First,#,SiteAddressPoint_111723,POINTTYPE,0,50;CAPTUREMETH "Capture Method" true true false 30 Text 0 0,First,#,SiteAddressPoint_111723,CAPTUREMETH,0,30;STATUS "Status" true true false 30 Text 0 0,First,#,SiteAddressPoint_111723,STATUS,0,30;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,SiteAddressPoint_111723,LASTUPDATE,-1,-1;LASTEDITOR "Last Editor" true true false 50 Text 0 0,First,#,SiteAddressPoint_111723,LASTEDITOR,0,50;C1_EXCEPTION "C1 Exception" true true false 4 Long 0 0,First,#,SiteAddressPoint_111723,C1_EXCEPTION,-1,-1;COMMENTS "Comments" true true false 150 Text 0 0,First,#,SiteAddressPoint_111723,COMMENTS,0,150;STREETNAMEID "Street Name ID" true true false 4 Long 0 0,First,#,SiteAddressPoint_111723,STREETNAMEID,-1,-1;PICTUREID "Picture ID" true true false 20 Text 0 0,First,#,SiteAddressPoint_111723,PICTUREID,0,20;SOURCE "Address Source" true true false 1 Text 0 0,First,#,SiteAddressPoint_111723,SOURCE,0,1;GPSFLAG "Field Verification Flag" true true false 1 Text 0 0,First,#,SiteAddressPoint_111723,GPSFLAG,0,1;FLOOR "Floor" true true false 4 Long 0 0,First,#,SiteAddressPoint_111723,FLOOR,-1,-1;ZIP "Zipcode" true true false 5 Text 0 0,First,#,SiteAddressPoint_111723,ZIP,0,5;SITETYPE "Site Type" true true false 25 Text 0 0,First,#,SiteAddressPoint_111723,SITETYPE,0,25;STREETID "Old Street Segment ID" true true false 4 Long 0 0,First,#,SiteAddressPoint_111723,STREETID,-1,-1;GEONAMEID "Old Street Name ID" true true false 4 Long 0 0,First,#,SiteAddressPoint_111723,GEONAMEID,-1,-1;GPSX "X Coordinate" true true false 8 Double 0 0,First,#,SiteAddressPoint_111723,GPSX,-1,-1;GPSY "Y Coordinate" true true false 8 Double 0 0,First,#,SiteAddressPoint_111723,GPSY,-1,-1;COMMUNITY "COMMUNITY" true true false 50 Text 0 0,First,#,SiteAddressPoint_111723,COMMUNITY,0,50;CAMAUPDATED "CAMA Updated" true true false 5 Text 0 0,First,#,SiteAddressPoint_111723,CAMAUPDATED,0,5;CENTERLINEKEY "Street Segment ID" true true false 20 Text 0 0,First,#,SiteAddressPoint_111723,CENTERLINEKEY,0,20;BADADDNUM "Incorrect Address Number" true true false 5 Text 0 0,First,#,SiteAddressPoint_111723,BADADDNUM,0,5;URL "Link to Addressing Documentation" true true false 150 Text 0 0,First,#,SiteAddressPoint_111723,URL,0,150;created_user "created_user" true true false 255 Text 0 0,First,#,SiteAddressPoint_111723,created_user,0,255;created_date "created_date" true true false 8 Date 0 0,First,#,SiteAddressPoint_111723,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#,SiteAddressPoint_111723,last_edited_user,0,255;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#,SiteAddressPoint_111723,last_edited_date,-1,-1;VEP_ID "VEP_ID" true true false 4 Long 0 0,First,#,SiteAddressPoint_111723,VEP_ID,-1,-1;DiscrpAgID "Discrepancy Agency ID" true true false 100 Text 0 0,First,#,SiteAddressPoint_111723,DiscrpAgID,0,100;NGUID "NENA Globally Unique ID" true true false 254 Text 0 0,First,#,SiteAddressPoint_111723,NGUID,0,254;Country "Country" true true false 2 Text 0 0,First,#,SiteAddressPoint_111723,Country,0,2;State "State or Equivalent (A1)" true true false 2 Text 0 0,First,#,SiteAddressPoint_111723,State,0,2;County "County or Equivalent (A2)" true true false 100 Text 0 0,First,#,SiteAddressPoint_111723,County,0,100;Uninc_Comm "Uninc_Comm" true true false 255 Text 0 0,First,#,SiteAddressPoint_111723,Uninc_Comm,0,255;Add_Number "Address Number" true true false 4 Long 0 0,First,#,SiteAddressPoint_111723,Add_Number,-1,-1;St_PreMod "Street Name Pre Modifier" true true false 15 Text 0 0,First,#,SiteAddressPoint_111723,St_PreMod,0,15;St_PreDir "Street Name Pre Directional" true true false 10 Text 0 0,First,#,SiteAddressPoint_111723,St_PreDir,0,10;St_PreTyp "Street Name Pre Type" true true false 50 Text 0 0,First,#,SiteAddressPoint_111723,St_PreTyp,0,50;St_PreSep "Street Name Pre Type Separator" true true false 20 Text 0 0,First,#,SiteAddressPoint_111723,St_PreSep,0,20;St_Name "Street Name" true true false 254 Text 0 0,First,#,SiteAddressPoint_111723,St_Name,0,254;St_PosTyp "Street Name Post Type" true true false 50 Text 0 0,First,#,SiteAddressPoint_111723,St_PosTyp,0,50;St_PosDir "Street Name Post Directional" true true false 10 Text 0 0,First,#,SiteAddressPoint_111723,St_PosDir,0,10;St_PosMod "Street Name Post Modifier" true true false 25 Text 0 0,First,#,SiteAddressPoint_111723,St_PosMod,0,25;LSt_PreDir "Legacy Street Name Pre Directional" true true false 2 Text 0 0,First,#,SiteAddressPoint_111723,LSt_PreDir,0,2;LSt_Name "Legacy Street Name" true true false 75 Text 0 0,First,#,SiteAddressPoint_111723,LSt_Name,0,75;LSt_Typ "Legacy Street Name Type" true true false 4 Text 0 0,First,#,SiteAddressPoint_111723,LSt_Typ,0,4;LSt_PosDir "Legacy Street Name Post Directional" true true false 2 Text 0 0,First,#,SiteAddressPoint_111723,LSt_PosDir,0,2" # Rename C:\Users\Jeremy.Mangin\DATAMARK\Data_Services\FL_Putnam\Parsing\DataExport_SE_20231122_ReadyforQC.gdb\DataExport_11172023.gdb\SiteAddressPoint_111723_ C:\Users\Jeremy.Mangin\DATAMARK\Data_Services\FL_Putnam\Parsing\DataExport_SE_20231122_ReadyforQC.gdb\DataExport_11172023.gdb\SiteAddressPoint_111723 FeatureClass CopyFeatures SiteAddressPoint C:\Users\btil08\AppData\Local\Temp\ArcGISProTemp24536\Untitled\SQLServer-putsgisdbv01-putnamgis.sde\putnamgis.SDE.E911\putnamgis.SDE.SiteAddressPoint # # # # 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>putnamgis.SDE.E911</FeatureDataset><WorkspaceConnectionString>SERVER=putsgisdbv01;INSTANCE=sde:sqlserver:putsgisdbv01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisdbv01;DATABASE=putnamgis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putnamgis.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>UTC</record_dates_in></EnableEditorTracking></workflow></operationSequence> CalculateField "EDIT DATA\Address Points" Add_Number " ".join(!FULLADDR!.split()[0:1]) Python # Text NO_ENFORCE_DOMAINS CalculateField "EDIT DATA\Address Points" LSt_Name " ".join(!FULLADDR!.split()[0:3]) Python # Text NO_ENFORCE_DOMAINS CalculateField "EDIT DATA\Address Points" LSt_Name " ".join(!LSt_Name!.split()[2:3]) Python # Text NO_ENFORCE_DOMAINS CalculateField "EDIT DATA\Address Points" LSt_Name " ".join(!LSt_Name!.split()[1:3]) Python # Text NO_ENFORCE_DOMAINS CalculateField "EDIT DATA\Address Points" LSt_Name " ".join(!LSt_Name!.split()[1:4]) Python # Text NO_ENFORCE_DOMAINS CalculateField "EDIT DATA\Address Points" St_Name !LSt_Name!.title() Python # Text NO_ENFORCE_DOMAINS CalculateField "EDIT DATA\Address Points" St_PosTyp longstr(!LSt_Typ! ) Python "def longstr(abbv): abbv = abbv.upper() if abbv in ('AV','AVE','AVEN','AVENU','AVENUE','AVN','AVNUE'): return 'Avenue' elif abbv in ('AL','ALY','ALLEE','ALLEY','ALLY','ALY'): return 'Alley' elif abbv in ('ANX','ANEX','ANNEX','ANNX','ANX'): return 'Anex' elif abbv in ('ARC','ARCADE','ARC'): return 'Arcade' elif abbv in ('BAYOO','BYU','BAYOU'): return 'Bayou' elif abbv in ('BCH','BEACH'): return 'Beach' elif abbv in ('BEND','BND'): return 'Bend' elif abbv in ('BLF','BLUF','BLUFF'): return 'Bluff' elif abbv in ('BLFS','BLUFFS'): return 'Bluffs' elif abbv in ('BOT','BTM','BOTTM','BOTTOM'): return 'Bottom' elif abbv in ('BL','BLVD','BOULV','BOULEVARD'): return 'Boulevard' elif abbv in ('BR','BRNCH','BRANCH'): return 'Branch' elif abbv in ('BRG','BRDGE','BRIDGE'): return 'Bridge' elif abbv in ('BRK','BROOK'): return 'Brook' elif abbv in ('BRKS','BROOKS'): return 'Brooks' elif abbv in ('BG','BURG'): return 'Burg' elif abbv in ('BGS','BURGS'): return 'Burgs' elif abbv in ('BYP','BYPA','BYPAS','BYPASS','BYPS'): return 'Bypass' elif abbv in ('CAMP','CP','CMP'): return 'Camp' elif abbv in ('CANYN','CYN','CNYN','CANYON'): return 'Canyon' elif abbv in ('CPE','CAPE'): return 'Cape' elif abbv in ('CAUSEWAY','CSWY','CAUSWA','CSWY'): return 'Causeway' elif abbv in ('CEN','CTR','CENT','CENTER','CENTR','CNTR'): return 'Center' elif abbv in ('CTRS','CENTERS'): return 'Centers' elif abbv in ('CL','CIR','CIRC','CIRCL','CIRCLE','CRCL','CRCLE','CR'): return 'Circle' elif abbv in ('CIRCLES','CIRS'): return 'Circles' elif abbv in ('CLF','CLIFF'): return 'Cliff' elif abbv in ('CLFS','CLIFFS'): return 'Cliffs' elif abbv in ('CLB','CLUB'): return 'Club' elif abbv in ('CMN','COMMON'): return 'Common' elif abbv in ('CMNS','COMMONS'): return 'Commons' elif abbv in ('COR','CORNER'): return 'Corner' elif abbv in ('CORS','CORNERS'): return 'Corners' elif abbv in ('COURSE','CRSE'): return 'Course' elif abbv in ('CT','COURT'): return 'Court' elif abbv in ('CTS', 'COURTS'): return 'Court' elif abbv in ('CV','COVE'): return 'Cove' elif abbv in ('CVS','COVES'): return 'Coves' elif abbv in ('CREEK','CRK'): return 'Creek' elif abbv in ('CRESCENT','CRES','CRSENT','CRSNT'): return 'Crescent' elif abbv in ('CREST','CRST'): return 'Crest' elif abbv in ('CROSSING','CRSSNG','XING'): return 'Crossing' elif abbv in ('XRD','CROSSROAD'): return 'Crossroad' elif abbv in ('XRDS','CROSSROADS'): return 'Crossroads' elif abbv in ('CURVE','CURV'): return 'Curve' elif abbv in ('DALE','DL'): return 'Dale' elif abbv in ('DAM','DM'): return 'Dam' elif abbv in ('DIV','DIVIDE'): return 'Divide' elif abbv in ('DR','DRIVE','DRIV','DRV'): return 'Drive' elif abbv in ('DRS','DRIVES'): return 'Drives' elif abbv in ('EST','ESTATE'): return 'Estate' elif abbv in ('ESTS','ESTATES'): return 'Estates' elif abbv in ('EXPY','EX','EXP','EXPR','EXPRESS','EXPW','EXPRESSWAY'): return 'Expressway' elif abbv in ('EXT','EXTENSION','EXTN','EXTNSN'): return 'Extension' elif abbv in ('EXTS','EXTENSIONS'): return 'Extensions' elif abbv == 'FALL': return 'Fall' elif abbv in ('FALLS','FLS'): return 'Falls' elif abbv in ('FERRY','FRY','FRRY'): return 'Ferry' elif abbv in ('FIELD','FLD'): return 'Field' elif abbv in ('FIELDS','FLDS'): return 'Fields' elif abbv in ('FLAT','FLT'): return 'Flat' elif abbv in ('FLATS','FLTS'): return 'Flats' elif abbv in ('FORD','FRD'): return 'Ford' elif abbv in ('FORDS','FRDS'): return 'Fords' elif abbv in ('FOREST','FRST','FORESTS'): return 'Forest' elif abbv in ('FORG','FRG','FORGE'): return 'Forge' elif abbv in ('FORGES','FRGS'): return 'Forges' elif abbv in ('FORK','FRK'): return 'Fork' elif abbv in ('FORKS','FRKS'): return 'Forks' elif abbv in ('FORT','FRT','FT'): return 'Fort' elif abbv in ('FY','FWY','FREEWAY','FREEWY','FRWY'): return 'Freeway' elif abbv in ('GARDEN','GDN','GARDN','GARDEN'): return 'Garden' elif abbv in ('GARDENS','GDNS','GARDNS','GARDENS'): return 'Gardens' elif abbv in ('GATEWAY','GTWY','GATEWY','GATWAY','GTWAY'): return 'Gateway' elif abbv in ('GLEN','GLN'): return 'Glen' elif abbv in ('GLENS','GLNS'): return 'Glens' elif abbv in ('GREEN','GRN'): return 'Green' elif abbv in ('GROVE','GRV','GROV'): return 'Grove' elif abbv in ('GROVES','GRVS'): return 'Groves' elif abbv == 'GRD': return 'GRADE' elif abbv == 'GT': return 'GATE' elif abbv in ('HARB','HBR','HARBOR','HARBR','HRBOR'): return 'Harbor' elif abbv in ('HARBORS','HBRS'): return 'Harbors' elif abbv in ('HAVEN','HVN'): return 'Haven' elif abbv in ('HEIGHTS','HT','HTS'): return 'Heights' elif abbv in ('HY','HIGHWAY','HWY','HIWAY','HWAY','HIGHWY'): return 'Highway' elif abbv in ('HILL','HL'): return 'Hill' elif abbv in ('HILLS','HLS'): return 'Hills' elif abbv in ('HOLLOW','HLLW','HOLW','HOLLOWS','HOLWS'): return 'Hollow' elif abbv in ('INLET','INLT'): return 'Inlet' elif abbv in ('ISLAND','IS','ISLND'): return 'Island' elif abbv in ('ISLANDS','ISS','ISLNDS'): return 'Islands' elif abbv in ('ISLE','ISLES'): return 'Isle' elif abbv in ('JCT','JCTION','JCTN','JUNCTION','JUNCTN','JUNCTON'): return 'Junction' elif abbv in ('JCTNS','JCTS','JUNCTIONS'): return 'Junctions' elif abbv in ('KEY','KY'): return 'Key' elif abbv in ('KEYS','KYS'): return 'Keys' elif abbv in ('KNL','KNOLL','KNOL'): return 'Knoll' elif abbv in ('KNLS','KNOLLS'): return 'Knolls' elif abbv in ('LK','LAKE'): return 'Lake' elif abbv in ('LKS','LAKES'): return 'Lakes' elif abbv == 'LAND': return 'Land' elif abbv in ('LNDG','LD','LANDING','LNDNG'): return 'Landing' elif abbv in ('LN','LANE'): return 'Lane' elif abbv in ('LGT','LIGHT'): return 'Light' elif abbv in ('LGTS','LIGHTS'): return 'Lights' elif abbv in ('LF','LOAF'): return 'Loaf' elif abbv in ('LCK','LOCK'): return 'Lock' elif abbv in ('LCKS','LOCKS'): return 'Locks' elif abbv in ('LDG','LDGE','LODG','LODGE'): return 'Lodge' elif abbv in ('LP','LOOP','LOOPS'): return 'Loop' elif abbv == 'MALL': return 'Mall' elif abbv in ('MNR','MANOR'): return 'Manor' elif abbv in ('MNRS','MANORS'): return 'Manors' elif abbv in ('MEADOW','MDW'): return 'Meadow' elif abbv in ('MEADOWS','MDWS','MEDOWS'): return 'Meadows' elif abbv == 'MEWS': return 'Mews' elif abbv in ('ML','MILL'): return 'Mill' elif abbv in ('MILLS','MLS'): return 'Mills' elif abbv in ('MISSN','MSN','MISSION','MSSN'): return 'Mission' elif abbv in ('MOTORWAY','MTWY'): return 'Motorway' elif abbv in ('MOUNT','MT','MNT'): return 'Mount' elif abbv in ('MOUNTAIN','MNTAIN','MTN','MNTN','MOUNTIN','MTIN'): return 'Mountain' elif abbv in ('MOUNTAINS','MTNS','MNTNS'): return 'Mountains' elif abbv in ('NCK','NECK'): return 'Neck' elif abbv in ('ORCHARD','ORCH','ORCHRD'): return 'Orchard' elif abbv in ('OVAL','OVL'): return 'Oval' elif abbv in ('OVERPASS','OPASS'): return 'Overpass' elif abbv in ('PARK','PRK','PK'): return 'Park' elif abbv in ('PARKS','PRKS'): return 'Parks' elif abbv in ('PARKWAY','PKWY','PARKWY','PKWAY','PKY'): return 'Parkway' elif abbv in ('PARKWAYS','PKWYS'): return 'Parkways' elif abbv == 'PASS': return 'Pass' elif abbv in ('PASSAGE','PSGE'): return 'Passage' elif abbv in ('PATH','PATHS'): return 'Path' elif abbv in ('PIKE','PIKES','PKE'): return 'Pike' elif abbv in ('PINE','PNE'): return 'Pine' elif abbv in ('PINES','PNES'): return 'Pines' elif abbv in ('PL','PLACE'): return 'Place' elif abbv in ('PLAIN','PLN'): return 'Plain' elif abbv in ('PLAINS','PLNS'): return 'Plains' elif abbv in ('PLAZA','PLZ','PLZA'): return 'Plaza' elif abbv in ('POINT','PT'): return 'Point' elif abbv in ('POINTS','PTS'): return 'Points' elif abbv in ('PORT','PRT'): return 'Port' elif abbv in ('PORTS','PRTS'): return 'Ports' elif abbv in ('PRAIRIE','PR'): return 'Prairie' elif abbv in ('RAD','RADL','RADIAL','RADIEL'): return 'Radial' elif abbv == 'RAMP': return 'Ramp' elif abbv in ('RANCH','RNCH','RANCHES','RNCHS'): return 'Ranch' elif abbv in ('RAPID','RPD'): return 'Rapid' elif abbv in ('RAPIDS','RPDS'): return 'Rapids' elif abbv in ('REST','RST'): return 'Rest' elif abbv in ('RIDGE','RDG','RDGE'): return 'Ridge' elif abbv in ('RIDGES','RDGS','RDGS'): return 'Ridges' elif abbv in ('RIVER','RIV','RIVR'): return 'River' elif abbv in ('RD','ROAD'): return 'Road' elif abbv in ('RDS','ROADS'): return 'Roads' elif abbv in ('ROUTE','RTE'): return 'Route' elif abbv == 'ROW': return 'Row' elif abbv == 'RUE': return 'Rue' elif abbv == 'RUN': return 'Run' elif abbv in ('SHL','SHOAL'): return 'Shoal' elif abbv in ('SHLS','SHOALS'): return 'Shoals' elif abbv in ('SHOAR','SHR','SHORE'): return 'Shore' elif abbv in ('SHOARS','SHRS','SHORES'): return 'Shores' elif abbv in ('SKYWAY','SKWY'): return 'Skyway' elif abbv in ('SPRING','SPG','SPNG','SPRNG'): return 'Spring' elif abbv in ('SPRINGS','SPGS','SPNGS','SPRNGS'): return 'Springs' elif abbv == 'SPUR': return 'Spur' elif abbv == 'SPURS': return 'Spurs' elif abbv in ('SQ','SQUARE','SQR','SQU','SQRE'): return 'Square' elif abbv in ('SQS','SQUARES','SQRS'): return 'Squares' elif abbv in ('STA','STATION','STATN','STN'): return 'Station' elif abbv in ('STRA','STRAV','STRAVEN','STRAVENUE','STRAVN','STRVNUE'): return 'Stravenue' elif abbv in ('STREAM','STRM','STREME'): return 'Stream' elif abbv in ('ST','STREET','STRT'): return 'Street' elif abbv in ('STS','STREETS'): return 'Streets' elif abbv in ('SUMMIT','SMT','SUMIT','SUMITT'): return 'Summit' elif abbv in ('TERR','TER','TERRACE'): return 'Terrace' elif abbv in ('THROUGHWAY','TRWY'): return 'Throughway' elif abbv in ('TRACE','TRCE','TRACES'): return 'Trace' elif abbv in ('TRACK','TRK','TRKS','TRACKS','TRAK'): return 'Track' elif abbv in ('TRAFFICWAY','TRFY'): return 'Trafficway' elif abbv in ('TRL','TRAIL','TRLS','TRAILS','TR'): return 'Trail' elif abbv in ('TRAILER','TRLR','TRLRS'): return 'Trailer' elif abbv in ('TUNNEL','TUNNELS','TUNL','TUN','TUNEL','TUNLS','TUNNL'): return 'Tunnel' elif abbv in ('TRNPK','TPKE','TURNPIKE','TURNPK'): return 'Turnpike' elif abbv in ('UNDERPASS','UPASS'): return 'Underpass' elif abbv in ('UN','UNION'): return 'Union' elif abbv in ('UNS','UNIONS'): return 'Unions' elif abbv in ('VALLEY','VLY','VALLY','VLLY'): return 'Valley' elif abbv in ('VALLEYS','VLYS'): return 'Valleys' elif abbv in ('VDCT','VIA','VIADUCT','VIADCT'): return 'Viaduct' elif abbv in ('VIEW','VW'): return 'View' elif abbv in ('VIEWS','VWS'): return 'Views' elif abbv in ('VILLAGE','VILL','VLG','VILLAG','VILLG','VILLIAGE'): return 'Village' elif abbv in ('VILLAGES','VLGS'): return 'Villages' elif abbv in ('VILLE','VL'): return 'Ville' elif abbv in ('VIS','VISTA','VIST','VST','VSTA'): return 'Vista' elif abbv == 'WALK': return 'Walk' elif abbv == 'WALKS': return 'Walks' elif abbv == 'WALL': return 'Wall' elif abbv == 'WW': return 'Walkway' elif abbv in ('WY','WAY'): return 'Way' elif abbv == 'WAYS': return 'Ways' elif abbv in ('WELL','WL'): return 'Well' elif abbv in ('WELLS','WLS'): return 'Wells' else: return abbv.title()" Text NO_ENFORCE_DOMAINS CalculateField "EDIT DATA\Address Points" VEP_ID autoIncrement() Python "rec=0 def autoIncrement(): global rec pStart = 159165 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS CalculateField "EDIT DATA\Address Points" VEP_ID autoIncrement() Python "rec=0 def autoIncrement(): global rec pStart = 159194 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS CalculateField "EDIT DATA\Address Points" Uninc_Comm !MUNICIPALITY! Python # Text NO_ENFORCE_DOMAINS CalculateField "EDIT DATA\Address Points" LSt_Name !St_Name!.upper() Python # Text NO_ENFORCE_DOMAINS 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>putnamgis.SDE.E911</FeatureDataset><WorkspaceConnectionString>SERVER=putsgisdbv01;INSTANCE=sde:sqlserver:putsgisdbv01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisdbv01;DATABASE=putnamgis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putnamgis.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>SITETYPE</field_name><domain_name>SiteTypes</domain_name></AssignDomainToField></workflow></operationSequence> 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>putnamgis.SDE.E911</FeatureDataset><WorkspaceConnectionString>SERVER=putsgisdbv01;INSTANCE=sde:sqlserver:putsgisdbv01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisdbv01;DATABASE=putnamgis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putnamgis.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>SOURCE</field_name><domain_name>AddressSource</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>GPSFLAG</field_name><domain_name>FieldVerificationFlag</domain_name></AssignDomainToField></workflow></operationSequence> 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>putnamgis.SDE.E911</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68373257577a65662f46776a75496f6f434373534e63594c6d33636b683439367a467066517a696d533737733d2a00;ENCRYPTED_PASSWORD=00022e687668524b58434c617a6b33735262564d6d41574b57613942507a6f6957746c70676b7853517777456c34733d2a00;SERVER=putsgisdbv01;INSTANCE=sde:sqlserver:putsgisdbv01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisdbv01;DATABASE=putnamgis;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putnamgis.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>LocalAreas</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>LocalAreas</field_domain></AddField></workflow></operationSequence> 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>putnamgis.SDE.E911</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68373257577a65662f46776a75496f6f434373534e63594c6d33636b683439367a467066517a696d533737733d2a00;ENCRYPTED_PASSWORD=00022e687668524b58434c617a6b33735262564d6d41574b57613942507a6f6957746c70676b7853517777456c34733d2a00;SERVER=putsgisdbv01;INSTANCE=sde:sqlserver:putsgisdbv01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisdbv01;DATABASE=putnamgis;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putnamgis.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>LocalAreas</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>LocalAreas</field_domain></AddField></workflow></operationSequence> 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>putnamgis.SDE.E911</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68373257577a65662f46776a75496f6f434373534e63594c6d33636b683439367a467066517a696d533737733d2a00;ENCRYPTED_PASSWORD=00022e687668524b58434c617a6b33735262564d6d41574b57613942507a6f6957746c70676b7853517777456c34733d2a00;SERVER=putsgisdbv01;INSTANCE=sde:sqlserver:putsgisdbv01;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=putsgisdbv01;DATABASE=putnamgis;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>putnamgis.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>LocalAreas</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>LocalAreas</field_domain></AddField></workflow></operationSequence> Server=putsgisdbv01; Service=sde:sqlserver:putsgisdbv01; Database=putnamgis; User=sde; Version=sde.DEFAULT ArcSDE Connection putnamgis.SDE.SiteAddressPoint 002 320501.364000 510682.785500 1824522.198500 2002027.850000 1 Relationship Relationship Relationship putlgim.SDE.SiteAddressHasStreetSegment Relationship Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Florida_East_FIPS_0901_Feet <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' 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'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Florida_East_FIPS_0901_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Transverse_Mercator&quot;],PARAMETER[&quot;False_Easting&quot;,656166.6666666665],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-81.0],PARAMETER[&quot;Scale_Factor&quot;,0.9999411764705882],PARAMETER[&quot;Latitude_Of_Origin&quot;,24.33333333333333],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2236]]</WKT><XOrigin>-17791300</XOrigin><YOrigin>-41645400</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102658</WKID><LatestWKID>2236</LatestWKID></ProjectedCoordinateSystem> 20140716 17322600 FGDC CSDGM Metadata 20231203 13275400 20231203 13275400 Site address points represent the location of site or service delivery addresses assigned by local governments. Site Address Points X-Ray Addresses and Names NaN NaN NaN NaN OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. SHAPE Shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. ADDPTKEY Address Point ID String 20 0 0 Unique address point identifier - Foreign Key ADDRCLASS Description Integer 4 10 0 A general classification of how the structure or location represented by the site address point is used - FacilitySite Subtype Classification ADDRNUM Full Address Number String 20 0 0 The full address number ADDRNUMSUF Address Number Suffix String 5 0 0 The address number suffix ADDRRANGE Address Range String 50 0 0 Address range when a point describes a set of addresses ALTUNITID Alternate Address Unit Number String 10 0 0 The alternate or secondary address unit designation ALTUNITTYPE Alternate Address Unit Type String 10 0 0 The alternate or secondary address unit type CAPTUREMETH Capture Method String 30 0 0 Capture method for address point ESN Emergency Service Number String 5 0 0 The Emergency Service Number the site address resides in FULLADDR Full Address String 250 0 0 Address information combined into one text field. In your community, this may include the following fields: PREADDRNUM, ADDRNUM, ADDRNUMSUF, FULLNAME, UNITTYPE, UNITID, ALTUNITTYPE, and ALTUNITID. FULLNAME Full Road Name String 125 0 0 The full name of the road including any prefix and/or suffix in mixed case format for Esri Community Map contributors LASTEDITOR Last Editor String 50 0 0 The user who performed the last update LASTUPDATE Last Update Date Date 8 0 0 The date the feature was last updated in the maintenance database MSAG MSAG Community String 35 0 0 The valid service community name identified by the MSAG MUNICIPALITY Municipality Name String 100 0 0 The name of the physical municipality the site address resides in PLACENAME Place Name String 250 0 0 A common name or vanity address for the site or service delivery address POINTTYPE Location String 50 0 0 A general description of the physical location represented by the site address point PREADDRNUM Address Number Prefix String 5 0 0 The address number prefix PSAP Public Safety Answering Point String 4 0 0 The Public Safety Answering Point the site address resides in SITEADDID Site Address ID String 20 0 0 Locally assigned site address point identifier STATUS Status String 30 0 0 The status of the site address UNITID Address Unit Number String 10 0 0 The address unit designation UNITTYPE Address Unit Type String 10 0 0 The address unit type USNGCOORD USNG Coordinate String 50 0 0 The USNG coordinate value C1_EXCEPTION C1 Exception Integer 4 10 0 COMMENTS Comments String 150 0 0 STREETNAMEID Street Name ID Integer 4 10 0 PICTUREID Picture ID String 20 0 0 SOURCE Address Source String 1 0 0 GPSFLAG Field Verification Flag String 1 0 0 FLOOR Floor Integer 4 10 0 ZIP Zipcode String 5 0 0 SITETYPE Site Type String 25 0 0 STREETID Old Street Segment ID Integer 4 10 0 GEONAMEID Old Street Name ID Integer 4 10 0 GPSX X Coordinate Double 8 38 8 GPSY Y Coordinate Double 8 38 8 COMMUNITY COMMUNITY String 50 0 0 CAMAUPDATED CAMA Updated String 5 0 0 CENTERLINEKEY Street Segment ID String 20 0 0 BADADDNUM Incorrect Address Number String 5 0 0 putnamgis.SDE.SiteAddressPoint Feature Class 0 URL Link to Addressing Documentation String 150 0 0 created_user created_user String 255 0 0 created_date created_date Date 8 0 0 last_edited_user last_edited_user String 255 0 0 last_edited_date last_edited_date Date 8 0 0 VEP_ID VEP_ID Integer 4 10 0 DiscrpAgID Discrepancy Agency ID String 100 0 0 NGUID NENA Globally Unique ID String 254 0 0 Country Country String 2 0 0 State State or Equivalent (A1) String 2 0 0 County County or Equivalent (A2) String 100 0 0 Uninc_Comm Uninc_Comm String 255 0 0 Add_Number Address Number Integer 4 10 0 St_PreMod Street Name Pre Modifier String 15 0 0 St_PreDir Street Name Pre Directional String 10 0 0 St_PreTyp Street Name Pre Type String 50 0 0 St_PreSep Street Name Pre Type Separator String 20 0 0 St_Name Street Name String 254 0 0 St_PosTyp Street Name Post Type String 50 0 0 St_PosDir Street Name Post Directional String 10 0 0 St_PosMod Street Name Post Modifier String 25 0 0 LSt_PreDir Legacy Street Name Pre Directional String 2 0 0 LSt_Name Legacy Street Name String 75 0 0 LSt_Typ Legacy Street Name Type String 4 0 0 LSt_PosDir Legacy Street Name Post Directional String 2 0 0 Microsoft Windows 10 Version 10.0 (Build 19044) ; Esri ArcGIS 13.2.0.49743 SiteAddressPoint_R 1 -82.058669 -81.456671 29.839986 29.348494 Enterprise Geodatabase Feature Class dataset EPSG 5.3(9.0.0) 0 Simple FALSE 0 TRUE FALSE 20231203 iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO xAAADsQBlSsOGwAACgNJREFUeJzt3XuPE9cdh/GvZ8b2+Lq+rJdrQlggLU0KDY2U/1pVrfq6ozav IColUmjSEBJ2gWWv2B57LtU5yyVpIE0l1jM/9vlI1moBsQdYPz6XwRMVRVEIAAyIyh4AAPxSBAuA GQQLgBkEC4AZBAuAGQQLgBkEC4AZBAuAGQQLgBkEC4AZBAuAGQQLgBkEC4AZBAuAGQQLgBkEC4AZ BAuAGQQLgBkEC4AZBAuAGQQLgBkEC4AZBAuAGQQLgBkEC4AZBAtAJWRZpsUiUZIkyvNczWZTi8VC /X5fYXicKoIFoBKWy6UePXqoB99/56M1GI50dHigGzc/Urfb87+GYAGohEajrixNtfvkiZbpUjs7 j9Vqt5WmSxVFoVqtRrAAVEOtFmiycUZRVFeapRqNxjrY31e73fWxcphhAagEF6V2u6NmM5aKQmEU +c+j6GWmCBaAygiCwD9++PkPlRYstyZNkrnuffNvfzrQ66+pyHNf2bXBQL1ev6yhAaioUoOVpqnu ffO15kmi4WCoeTL369crV64RLADVCZabSdXrDa1PJkqSher1ugpJ9UbjR2tWAKhEsNyFYTdu/v7F 5+7hZl4A8CqlT2X+e1Pt+fElAFQuWADwSxEsAGYQLABmECwAZhAsAGYQLABmECwAZhAsAGYQLABm ECwAZhAsAGYQLABmECwAZhAsAGYQLABmECy8lnszxTzP3A1Mnr1PmXtzxZp/DzPetwxlIFh4baxm s6nu3LmtPMvU6XQ0nydqtVq6ePFd9frcJASrR7DwWkEQ6rv73/q3snZ34d3b29NgMNBgMCRYKAXB ws/cJKSuDz68oSIvFIaBZrOZj1d/bY2/NZTi1Afr+U0v2JP5qTAM9c47l/w+lpttuY/uduIuZEAZ otMcqsUi0fb21otN5Ea9oU63p3a7XfbwKqPRaJQ9BKDcYLlYuLs9p+ny2St37l+13Sv6Ksfgljj/ uvulCh3f1LXf6+vSe5ffSLB8EJNEB4cHCmo1/2dsNmO12m1mKIClYLmlxdHRoR4/eiR3Wu7ide7c BfV6Pbc2W9k43I1c3QbydPrUx8WNw5/cvwHu99rb39Xtf3zuZ3DT6VTnz1/Q5pVrqtfZA1ql5XKh NM2eLWmP73/pxHGLrQBjSglWluU6PDzUF1/c1v3799VqxfrDH/+kdqezslmWi4g7qr/5u1vy375v OJTuSRFFdcXNpmazuXZ3dzVenygMT+0qvDTbW1t6/PiRnj498t9ffg+uJt248ZF/0YIdpTx73K3o 3fH41avva2PjrH8F7LS7x+Eo+Uaub4p7YgyHQ936+BPlWa5luvRPjjiOT+Tr4eeX5wcHe/5FMs8L FUWuPteRmVRKsI5nN11d3rzqL0rMi8Iflwcr3MNaBbc/5/atnLgofrQcweqsTzbU7XW1WLilYeqX 61EYrXTPFG9GaesTFy0Xqbfd80ARqvK4Wa37XnMzq+MZlnvxcP8mJzO7xslhQwVvvZcz20BMqmwj WADMIFgAzCBYAMwgWADMIFgAzCBYAMwgWADMIFgAzCBYAMwgWADMIFgAzCBYAMwgWADMIFgAzCBY AMwgWADMIFgAzCBYAMwgWADMIFgAzCBYAMwgWADMIFgAzCBYAMwgWADMIFgAzCBYAMwgWADMIFgA zCBYAMwgWADMIFgAzCBYAMwgWADMIFinWJ7n/mOtVlNRFP6jewBVRbBOqTRNNZ1O5fIURZHSLFUY Rmo2mwrDsOzhAa9EsE7pzGp3d0ef/e1TdbpddTpdSYU6nZ7OX7iojY0zZQ8ReCWCdYLcMsuFQH4e o8osu9zXj5uxxusTFUWuOG4qSRYKw0ARsytUGME6oRnMfD7Tw+0HOjo8UJplarVaCqNIa2tDTSYb LyJWVrBa7Y4+/O1NH6wojJTluV8atuJWaeMC/heCdQL8DKo43ieqBaFqee5/LAxC/6gCF6fRaFz2 MID/C8E6AS5OjWZT65Mzxydwee43soMwVKPRKHV2BVhmNlhuP+jlHpHjjuaPZzJBBWYxbgYzGAz9 GOezmQ+VWxIuFgvt7+/52Zf7ucFg4E/nyt7XAiwwGqxCWZZp+vRIi+XCP/HdZrHrl5vZuFOvqgTA 7WftPH6o4Xhdnairo6NDfXvvG+3v7/poffzxJ+r2+pUZL1BlJoPlwjSfT3X37hd6svNY8/lcw+FI cauljY1zz47pqyEIAtUbDf/ReX5KmC5TzZOFD6//AwF4O4PlT7niti5fvqpL713xP+Y2s90ekbvw sUqzFTeWycbZF2Pq9fq6eu19vXd508++ut2uas9iBuAtDJbj4tRfG7743OegAtc4vcrz2ZUTRaHC sPViUhUEbrzVGzNQRWaD5S8TCEM/S/nu/j2/wd3p9ioZrB87jmrlhwlUkNlgPedP4eYzpVmv7KEA OGHmg+VmK+PxxO9pVX92BeBUB8vtD43G62UPA8AKmA8WgNODYAEwg2ABMINgATCDYAEwg2ABMINg ATCDYAEwg2ABMINgATCDYAEwg2ABMINgATCDYAEwg2ABMINgATCDYAEwg2ABMINgATCDYAEwg2AB MINgATCDYAEwg2ABMINgATCDYAEwg2ABMINgATCDYAEwg2ABMINgATCDYAEwg2ABMINgATCDYAEw g2ABMINgATCDYAEwg2ABMINgATCDYAEwg2ABMINgATCDYAEwg2ABMINgATCDYAEwg2ABMINgATCD YAEwg2ABMINgATCDYAEwg2ABMINgATCDYAEwg2ABMINgATCDYAEwg2ABMINgATCDYAEwg2ABMINg ATCDYAEwg2ABMINgATCDYAEwg2ABMINgATCDYAEwg2ABMGOlwSqKQmmaKk2XCoJQWZYqjltaLBaq 1+sKw3CVwwFgzEqDlee5trceaHt7S51ORwcH+7r+mw/19Vd3deHiuxqNxqrVaqscEgBDVj7DOjzc 11dffalms6nRcKTP/v6p7tz5p/78l7+q3++rXm+sckgADFl5sDrdnjavXFO/11eWZfrVrz/Q5uZV nTlzVmHIlhqA11tpIdwe1WRyRsPhSPWorizP1IpbWlsbKIwiBUGwyuEAMGalwXJBarVaktzjpQab 7QB+AdZgJXAnpbPZVPP53EfcLY3d/l2zGXPoAPwMglUCd1nHkyc72tp6oGSeqNFo6PLmpsbjiaKI fxLgdXh2lKBWCxQGgZL5XA++/17nzp/XIkn8zItgAa9HsErgLpJ1syl30ez16x8oSRKNxmPFcawq cKe5bpnquMviiuJ4/5FDEZSNYJXAPfHjVss/pMIHoSoXzLpY7ew80p07txXUAh9RN/O7ePEdf8Lb aDbLHiJOMYJVkpeBqvlZTJXG5f5HwvTpUx8qN/vb29tTmmZqt7sEC6UiWPiJfn+gGzdvqchzf62c i1a/v+b/OxWgEv0H4ICIdtKL1ukAAAAASUVORK5CYII=