20230814 16464200 1.0 FALSE addresses_20240708 002 file://\\maple\users\JAvalos\Scratch Workspaces\Dispatch - CAD Mapping\Dispatch Workspace\addresses_20240708.shp Local Area Network 12596693.167651 12876418.681759 181081.025919 555638.234252 1 0.000 Projected GCS_North_American_1983 Linear Unit: Foot (0.304800) NAD_1983_StatePlane_Michigan_South_FIPS_2113_Feet_Intl <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.1.0'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Michigan_South_FIPS_2113_Feet_Intl&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;Lambert_Conformal_Conic&quot;],PARAMETER[&quot;False_Easting&quot;,13123359.58005249],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-84.36666666666666],PARAMETER[&quot;Standard_Parallel_1&quot;,42.1],PARAMETER[&quot;Standard_Parallel_2&quot;,43.66666666666666],PARAMETER[&quot;Latitude_Of_Origin&quot;,41.5],UNIT[&quot;Foot&quot;,0.3048],AUTHORITY[&quot;EPSG&quot;,2253]]</WKT><XOrigin>-107138600</XOrigin><YOrigin>-97193800</YOrigin><XYScale>37448250.484633707</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808398950131233</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2253</WKID><LatestWKID>2253</LatestWKID></ProjectedCoordinateSystem> FeatureClassToFeatureClass J:\data\Shapefiles\00AlleganCo\Addresses.shp "Database Connections\Juniper.sde\AC_Pro.DBO.Addresses" Addresses # "SITE_ID "SITE_ID" true true false 11 Double 0 11 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,SITE_ID,-1,-1;ADDRESS "ADDRESS" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,ADDRESS,-1,-1;PROBLEM "PROBLEM" true true false 20 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,PROBLEM,-1,-1;NOTES "NOTES" true true false 250 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,NOTES,-1,-1;PREDIRECTI "PREDIRECTI" true true false 2 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,PREDIRECTI,-1,-1;NUMBER "NUMBER" true true false 5 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,NUMBER,-1,-1;NAME "NAME" true true false 40 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,NAME,-1,-1;SUFFIX "SUFFIX" true true false 4 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,SUFFIX,-1,-1;NUMBERSUP "NUMBERSUP" true true false 4 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,NUMBERSUP,-1,-1;POSTDIRECT "POSTDIRECT" true true false 2 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,POSTDIRECT,-1,-1;SUPPLEMENT "SUPPLEMENT" true true false 30 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,SUPPLEMENT,-1,-1;CITY "CITY" true true false 30 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,CITY,-1,-1;ZIP "ZIP" true true false 5 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,ZIP,-1,-1;ADDRESS1 "ADDRESS1" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,ADDRESS1,-1,-1;ADDRESS2 "ADDRESS2" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,ADDRESS2,-1,-1;NUMBER1 "NUMBER1" true true false 5 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,NUMBER1,-1,-1;NUMBERSUP1 "NUMBERSUP1" true true false 4 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,NUMBERSUP1,-1,-1;PREDIREC0 "PREDIREC0" true true false 2 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,PREDIREC0,-1,-1;NAME1 "NAME1" true true false 40 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,NAME1,-1,-1;SUFFIX1 "SUFFIX1" true true false 4 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,SUFFIX1,-1,-1;POSTDIRE0 "POSTDIRE0" true true false 2 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,POSTDIRE0,-1,-1;SUPPLEME0 "SUPPLEME0" true true false 30 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,SUPPLEME0,-1,-1;NUMBER2 "NUMBER2" true true false 5 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,NUMBER2,-1,-1;NUMBERSUP2 "NUMBERSUP2" true true false 4 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,NUMBERSUP2,-1,-1;PREDIREC1 "PREDIREC1" true true false 2 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,PREDIREC1,-1,-1;NAME2 "NAME2" true true false 40 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,NAME2,-1,-1;SUFFIX2 "SUFFIX2" true true false 4 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,SUFFIX2,-1,-1;POSTDIRE1 "POSTDIRE1" true true false 2 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,POSTDIRE1,-1,-1;SUPPLEME1 "SUPPLEME1" true true false 30 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,SUPPLEME1,-1,-1;PARETIRED "PARETIRED" true true false 1 Short 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,PARETIRED,-1,-1;A1RETIRED "A1RETIRED" true true false 1 Short 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,A1RETIRED,-1,-1;A2RETIRED "A2RETIRED" true true false 1 Short 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,A2RETIRED,-1,-1;UNOCCUPIED "UNOCCUPIED" true true false 1 Short 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,UNOCCUPIED,-1,-1;O99 "O99" true true false 1 Short 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,O99,-1,-1;O04 "O04" true true false 1 Short 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,O04,-1,-1;O05 "O05" true true false 1 Short 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,O05,-1,-1;O06 "O06" true true false 1 Short 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,O06,-1,-1;VERIFIED "VERIFIED" true true false 1 Short 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,VERIFIED,-1,-1;SOURCE "SOURCE" true true false 20 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,SOURCE,-1,-1;NAME0 "NAME0" true true false 80 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,NAME0,-1,-1;SOURCE0 "SOURCE0" true true false 40 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,SOURCE0,-1,-1;LATITUDE "LATITUDE" true true false 31 Double 15 30 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 31 Double 15 30 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,LONGITUDE,-1,-1;ENTITYID "ENTITYID" true true false 11 Double 0 11 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,ENTITYID,-1,-1;COUNTY "COUNTY" true true false 20 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,COUNTY,-1,-1;MUNI "MUNI" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,MUNI,-1,-1;MCD_DIV "MCD_DIV" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,MCD_DIV,-1,-1;UNCORP "UNCORP" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,UNCORP,-1,-1;NHBRHD "NHBRHD" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,NHBRHD,-1,-1;HSENO_PRE "HSENO_PRE" true true false 11 Double 0 11 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,HSENO_PRE,-1,-1;ST_PREMOD "ST_PREMOD" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,ST_PREMOD,-1,-1;ST_POSTMOD "ST_POSTMOD" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,ST_POSTMOD,-1,-1;ESN "ESN" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,ESN,-1,-1;PSAP "PSAP" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,PSAP,-1,-1;MSAGCOM "MSAGCOM" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,MSAGCOM,-1,-1;BLDG "BLDG" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,BLDG,-1,-1;FLOOR "FLOOR" true true false 2 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,FLOOR,-1,-1;ROOM "ROOM" true true false 10 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,ROOM,-1,-1;UNIT "UNIT" true true false 10 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,UNIT,-1,-1;SEAT "SEAT" true true false 10 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,SEAT,-1,-1;LANDMARK "LANDMARK" true true false 150 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,LANDMARK,-1,-1;LOC "LOC" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,LOC,-1,-1;PLC_TYPE "PLC_TYPE" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,PLC_TYPE,-1,-1;SLOC_TYPE "SLOC_TYPE" true true false 1 Short 0 1 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,SLOC_TYPE,-1,-1;RCL_ID "RCL_ID" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,RCL_ID,-1,-1;TAX_PIN "TAX_PIN" true true false 50 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,TAX_PIN,-1,-1;COLL_MTHD "COLL_MTHD" true true false 1 Short 0 1 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,COLL_MTHD,-1,-1;EXCEPTION "EXCEPTION" true true false 18 Double 0 18 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,EXCEPTION,-1,-1;FLAG "FLAG" true true false 10 Text 0 0 ,First,#,J:\data\Shapefiles\00AlleganCo\Addresses.shp,FLAG,-1,-1" # DeleteField AC_Pro.DBO.Addresses O99;O04;O05;O06;HSENO_PRE;ST_PREMOD;ST_POSTMOD;BLDG;FLOOR;ROOM;UNIT;SEAT;LANDMARK;LOC;PLC_TYPE;SLOC_TYPE;RCL_ID;EXCEPTION;FLAG CalculateField AC_Pro.DBO.Addresses SUFFIX "Dr" VB # CalculateField AC_Pro.DBO.Addresses SUFFIX "Ave" VB # CalculateField AC_Pro.DBO.Addresses SUFFIX "Ct" VB # CalculateField AC_Pro.DBO.Addresses SUFFIX "Hwy" VB # CalculateField AC_Pro.DBO.Addresses SUFFIX "Ln" VB # CalculateField AC_Pro.DBO.Addresses SUFFIX "Rd" VB # CalculateField AC_Pro.DBO.Addresses SUFFIX "St" VB # CalculateField AC_Pro.DBO.Addresses SUFFIX "Trl" VB # CalculateField AC_Pro.DBO.Addresses PROBLEM "SEQUENCE" VB # AssignDomainToField "Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses" PROBLEM addressPROBLEM # AssignDomainToField "Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses" PREDIRECTI RoadPrefix # AssignDomainToField "Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses" SUFFIX addressSUFFIX # AssignDomainToField "Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses" CITY addressCity # AssignDomainToField "Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses" MUNI addressMuni # AssignDomainToField "Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses" MUNI addressMuni # CalculateField AC_Pro.DBO.Addresses Site_ID [xSITE_ID] VB # AlterField "Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses" Site_ID SITE_ID # LONG 4 NULLABLE false FeatureClassToFeatureClass AC_Pro.DBO.Addresses J:\Apps\Python\LayerUpdates\addresses\source\AddressData.gdb Addresses20170810b # "ADDRESS "Complete Address" true true false 50 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,ADDRESS,-1,-1;PROBLEM "PROBLEM" true true false 20 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,PROBLEM,-1,-1;NOTES "NOTES" true true false 250 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,NOTES,-1,-1;PREDIRECTI "Directional Prefix" true true false 2 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,PREDIRECTI,-1,-1;NUMBER "NUMBER" true true false 5 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,NUMBER,-1,-1;NAME "Street Name" true true false 40 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,NAME,-1,-1;SUFFIX "Road Type Suffix" true true false 4 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,SUFFIX,-1,-1;NUMBERSUP "Post Number Supplement" true true false 4 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,NUMBERSUP,-1,-1;POSTDIRECT "Post Rd Type Suffix Direction Post RdTypeSuffix Direction" true true false 2 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,POSTDIRECT,-1,-1;SUPPLEMENT "Suffix Supplement" true true false 30 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,SUPPLEMENT,-1,-1;CITY "Postal City" true true false 30 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,CITY,-1,-1;ZIP "Zip Code" true true false 5 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,ZIP,-1,-1;ADDRESS1 "ADDRESS1" true true false 50 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,ADDRESS1,-1,-1;ADDRESS2 "ADDRESS2" true true false 50 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,ADDRESS2,-1,-1;NUMBER1 "NUMBER1" true true false 5 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,NUMBER1,-1,-1;NUMBERSUP1 "NUMBERSUP1" true true false 4 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,NUMBERSUP1,-1,-1;PREDIREC0 "PREDIREC0" true true false 2 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,PREDIREC0,-1,-1;NAME1 "NAME1" true true false 40 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,NAME1,-1,-1;SUFFIX1 "SUFFIX1" true true false 4 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,SUFFIX1,-1,-1;POSTDIRE0 "POSTDIRE0" true true false 2 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,POSTDIRE0,-1,-1;SUPPLEME0 "SUPPLEME0" true true false 30 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,SUPPLEME0,-1,-1;NUMBER2 "NUMBER2" true true false 5 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,NUMBER2,-1,-1;NUMBERSUP2 "NUMBERSUP2" true true false 4 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,NUMBERSUP2,-1,-1;PREDIREC1 "PREDIREC1" true true false 2 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,PREDIREC1,-1,-1;NAME2 "NAME2" true true false 40 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,NAME2,-1,-1;SUFFIX2 "SUFFIX2" true true false 4 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,SUFFIX2,-1,-1;POSTDIRE1 "POSTDIRE1" true true false 2 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,POSTDIRE1,-1,-1;SUPPLEME1 "SUPPLEME1" true true false 30 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,SUPPLEME1,-1,-1;PARETIRED "PARETIRED" true true false 2 Short 0 5 ,First,#,AC_Pro.DBO.Addresses,PARETIRED,-1,-1;A1RETIRED "A1RETIRED" true true false 2 Short 0 5 ,First,#,AC_Pro.DBO.Addresses,A1RETIRED,-1,-1;A2RETIRED "A2RETIRED" true true false 2 Short 0 5 ,First,#,AC_Pro.DBO.Addresses,A2RETIRED,-1,-1;UNOCCUPIED "UNOCCUPIED" true true false 2 Short 0 5 ,First,#,AC_Pro.DBO.Addresses,UNOCCUPIED,-1,-1;VERIFIED "VERIFIED" true true false 2 Short 0 5 ,First,#,AC_Pro.DBO.Addresses,VERIFIED,-1,-1;SOURCE "SOURCE" true true false 20 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,SOURCE,-1,-1;NAME0 "NAME0" true true false 80 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,NAME0,-1,-1;SOURCE0 "SOURCE0" true true false 40 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,SOURCE0,-1,-1;LATITUDE "LATITUDE" true true false 8 Double 15 30 ,First,#,AC_Pro.DBO.Addresses,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 15 30 ,First,#,AC_Pro.DBO.Addresses,LONGITUDE,-1,-1;ENTITYID "ENTITYID" true true false 8 Double 0 11 ,First,#,AC_Pro.DBO.Addresses,ENTITYID,-1,-1;COUNTY "COUNTY" true true false 20 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,COUNTY,-1,-1;MUNI "Local Jurisdiction" true true false 50 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,MUNI,-1,-1;MCD_DIV "MCD_DIV" true true false 50 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,MCD_DIV,-1,-1;UNCORP "UNCORP" true true false 50 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,UNCORP,-1,-1;NHBRHD "Assessment Neighborhood" true true false 50 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,NHBRHD,-1,-1;ESN "ESN" true true false 50 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,ESN,-1,-1;PSAP "PSAP" true true false 50 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,PSAP,-1,-1;MSAGCOM "MSAGCOM" true true false 50 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,MSAGCOM,-1,-1;TAX_PIN "TAX_PIN" true true false 50 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,TAX_PIN,-1,-1;COLL_MTHD "COLL_MTHD" true true false 2 Short 0 5 ,First,#,AC_Pro.DBO.Addresses,COLL_MTHD,-1,-1;created_user "created_user" false true false 255 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,created_user,-1,-1;created_date "created_date" false true false 8 Date 0 0 ,First,#,AC_Pro.DBO.Addresses,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0 ,First,#,AC_Pro.DBO.Addresses,last_edited_user,-1,-1;last_edited_date "last_edited_date" false true false 8 Date 0 0 ,First,#,AC_Pro.DBO.Addresses,last_edited_date,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,AC_Pro.DBO.Addresses,GlobalID,-1,-1;Site_ID "SITE_ID" true true false 4 Long 0 10 ,First,#,AC_Pro.DBO.Addresses,Site_ID,-1,-1" # FeatureClassToFeatureClass Addresses20170810b "Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses" Addresses # "ADDRESS "Complete Address" true true false 50 Text 0 0 ,First,#,Addresses20170810b,ADDRESS,-1,-1;PROBLEM "PROBLEM" true true false 20 Text 0 0 ,First,#,Addresses20170810b,PROBLEM,-1,-1;NOTES "NOTES" true true false 250 Text 0 0 ,First,#,Addresses20170810b,NOTES,-1,-1;PREDIRECTI "Directional Prefix" true true false 2 Text 0 0 ,First,#,Addresses20170810b,PREDIRECTI,-1,-1;NUMBER "NUMBER" true true false 5 Text 0 0 ,First,#,Addresses20170810b,NUMBER,-1,-1;NAME "Street Name" true true false 40 Text 0 0 ,First,#,Addresses20170810b,NAME,-1,-1;SUFFIX "Road Type Suffix" true true false 4 Text 0 0 ,First,#,Addresses20170810b,SUFFIX,-1,-1;NUMBERSUP "Post Number Supplement" true true false 4 Text 0 0 ,First,#,Addresses20170810b,NUMBERSUP,-1,-1;POSTDIRECT "Post Rd Type Suffix Direction Post RdTypeSuffix Direction" true true false 2 Text 0 0 ,First,#,Addresses20170810b,POSTDIRECT,-1,-1;SUPPLEMENT "Suffix Supplement" true true false 30 Text 0 0 ,First,#,Addresses20170810b,SUPPLEMENT,-1,-1;CITY "Postal City" true true false 30 Text 0 0 ,First,#,Addresses20170810b,CITY,-1,-1;ZIP "Zip Code" true true false 5 Text 0 0 ,First,#,Addresses20170810b,ZIP,-1,-1;ADDRESS1 "ADDRESS1" true true false 50 Text 0 0 ,First,#,Addresses20170810b,ADDRESS1,-1,-1;ADDRESS2 "ADDRESS2" true true false 50 Text 0 0 ,First,#,Addresses20170810b,ADDRESS2,-1,-1;NUMBER1 "NUMBER1" true true false 5 Text 0 0 ,First,#,Addresses20170810b,NUMBER1,-1,-1;NUMBERSUP1 "NUMBERSUP1" true true false 4 Text 0 0 ,First,#,Addresses20170810b,NUMBERSUP1,-1,-1;PREDIREC0 "PREDIREC0" true true false 2 Text 0 0 ,First,#,Addresses20170810b,PREDIREC0,-1,-1;NAME1 "NAME1" true true false 40 Text 0 0 ,First,#,Addresses20170810b,NAME1,-1,-1;SUFFIX1 "SUFFIX1" true true false 4 Text 0 0 ,First,#,Addresses20170810b,SUFFIX1,-1,-1;POSTDIRE0 "POSTDIRE0" true true false 2 Text 0 0 ,First,#,Addresses20170810b,POSTDIRE0,-1,-1;SUPPLEME0 "SUPPLEME0" true true false 30 Text 0 0 ,First,#,Addresses20170810b,SUPPLEME0,-1,-1;NUMBER2 "NUMBER2" true true false 5 Text 0 0 ,First,#,Addresses20170810b,NUMBER2,-1,-1;NUMBERSUP2 "NUMBERSUP2" true true false 4 Text 0 0 ,First,#,Addresses20170810b,NUMBERSUP2,-1,-1;PREDIREC1 "PREDIREC1" true true false 2 Text 0 0 ,First,#,Addresses20170810b,PREDIREC1,-1,-1;NAME2 "NAME2" true true false 40 Text 0 0 ,First,#,Addresses20170810b,NAME2,-1,-1;SUFFIX2 "SUFFIX2" true true false 4 Text 0 0 ,First,#,Addresses20170810b,SUFFIX2,-1,-1;POSTDIRE1 "POSTDIRE1" true true false 2 Text 0 0 ,First,#,Addresses20170810b,POSTDIRE1,-1,-1;SUPPLEME1 "SUPPLEME1" true true false 30 Text 0 0 ,First,#,Addresses20170810b,SUPPLEME1,-1,-1;PARETIRED "PARETIRED" true true false 2 Short 0 0 ,First,#,Addresses20170810b,PARETIRED,-1,-1;A1RETIRED "A1RETIRED" true true false 2 Short 0 0 ,First,#,Addresses20170810b,A1RETIRED,-1,-1;A2RETIRED "A2RETIRED" true true false 2 Short 0 0 ,First,#,Addresses20170810b,A2RETIRED,-1,-1;UNOCCUPIED "UNOCCUPIED" true true false 2 Short 0 0 ,First,#,Addresses20170810b,UNOCCUPIED,-1,-1;VERIFIED "VERIFIED" true true false 2 Short 0 0 ,First,#,Addresses20170810b,VERIFIED,-1,-1;SOURCE "SOURCE" true true false 20 Text 0 0 ,First,#,Addresses20170810b,SOURCE,-1,-1;NAME0 "NAME0" true true false 80 Text 0 0 ,First,#,Addresses20170810b,NAME0,-1,-1;SOURCE0 "SOURCE0" true true false 40 Text 0 0 ,First,#,Addresses20170810b,SOURCE0,-1,-1;LATITUDE "LATITUDE" true true false 8 Double 0 0 ,First,#,Addresses20170810b,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 0 0 ,First,#,Addresses20170810b,LONGITUDE,-1,-1;ENTITYID "ENTITYID" true true false 8 Double 0 0 ,First,#,Addresses20170810b,ENTITYID,-1,-1;COUNTY "COUNTY" true true false 20 Text 0 0 ,First,#,Addresses20170810b,COUNTY,-1,-1;MUNI "Local Jurisdiction" true true false 50 Text 0 0 ,First,#,Addresses20170810b,MUNI,-1,-1;MCD_DIV "MCD_DIV" true true false 50 Text 0 0 ,First,#,Addresses20170810b,MCD_DIV,-1,-1;UNCORP "UNCORP" true true false 50 Text 0 0 ,First,#,Addresses20170810b,UNCORP,-1,-1;NHBRHD "Assessment Neighborhood" true true false 50 Text 0 0 ,First,#,Addresses20170810b,NHBRHD,-1,-1;ESN "ESN" true true false 50 Text 0 0 ,First,#,Addresses20170810b,ESN,-1,-1;PSAP "PSAP" true true false 50 Text 0 0 ,First,#,Addresses20170810b,PSAP,-1,-1;MSAGCOM "MSAGCOM" true true false 50 Text 0 0 ,First,#,Addresses20170810b,MSAGCOM,-1,-1;TAX_PIN "TAX_PIN" true true false 50 Text 0 0 ,First,#,Addresses20170810b,TAX_PIN,-1,-1;COLL_MTHD "COLL_MTHD" true true false 2 Short 0 0 ,First,#,Addresses20170810b,COLL_MTHD,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,Addresses20170810b,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,Addresses20170810b,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,Addresses20170810b,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,Addresses20170810b,last_edited_date,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Addresses20170810b,GlobalID,-1,-1;Site_ID "SITE_ID" true true false 4 Long 0 0 ,First,#,Addresses20170810b,Site_ID,-1,-1" # CalculateField "Address Maint\Addresses" NUMBERSUP "" VB # CalculateField "Address Maint\Addresses" PREDIRECTI "" VB # CalculateField "Address Maint\Addresses" POSTDIRECT "" VB # CalculateField "Address Maint\Addresses" NUMBERSUP "" VB # CalculateField "Address Maint\Addresses" PREDIRECTI "" VB # CalculateField "Address Maint\Addresses" POSTDIRECT "" VB # CalculateField "Address Maint\Addresses" POSTDIRECT "" VB # CalculateField "Address Maint\Addresses" PREDIRECTI "" VB # CalculateField "Address Maint\Addresses" SUFFIX "" VB # CalculateField "Address Maint\Addresses" ADDRESS1 !ADDRESS1![1:] PYTHON_9.3 # CalculateField "Address Maint\Addresses" ADDRESS2 !ADDRESS2![1:] PYTHON_9.3 # CalculateField "Address Maint\Addresses" UNOCCUPIED 0 VB # AssignDefaultToField "Address Maint\Addresses" UNOCCUPIED 0 # false AssignDefaultToField "Address Maint\Addresses" SOURCE ACLIS # false FeatureClassToFeatureClass "Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses" C:\AC\Data\Geodatabases\AddressImportExport.gdb Address # "ADDRESS "Complete Address" true true false 50 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS,-1,-1;PROBLEM "PROBLEM" true true false 20 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PROBLEM,-1,-1;NOTES "NOTES" true true false 250 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NOTES,-1,-1;PREDIRECTI "Directional Prefix" true true false 2 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIRECTI,-1,-1;NUMBER "NUMBER" true true false 5 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER,-1,-1;NAME "Street Name" true true false 40 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME,-1,-1;SUFFIX "Road Type Suffix" true true false 4 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX,-1,-1;NUMBERSUP "Post Number Supplement" true true false 4 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP,-1,-1;POSTDIRECT "Post Rd Type Suffix Direction Post RdTypeSuffix Direction" true true false 2 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIRECT,-1,-1;SUPPLEMENT "Suffix Supplement" true true false 30 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEMENT,-1,-1;CITY "Postal City" true true false 30 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,CITY,-1,-1;ZIP "Zip Code" true true false 5 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ZIP,-1,-1;ADDRESS1 "ADDRESS1" true true false 50 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS1,-1,-1;ADDRESS2 "ADDRESS2" true true false 50 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS2,-1,-1;NUMBER1 "NUMBER1" true true false 5 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER1,-1,-1;NUMBERSUP1 "NUMBERSUP1" true true false 4 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP1,-1,-1;PREDIREC0 "PREDIREC0" true true false 2 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIREC0,-1,-1;NAME1 "NAME1" true true false 40 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME1,-1,-1;SUFFIX1 "SUFFIX1" true true false 4 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX1,-1,-1;POSTDIRE0 "POSTDIRE0" true true false 2 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIRE0,-1,-1;SUPPLEME0 "SUPPLEME0" true true false 30 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEME0,-1,-1;NUMBER2 "NUMBER2" true true false 5 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER2,-1,-1;NUMBERSUP2 "NUMBERSUP2" true true false 4 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP2,-1,-1;PREDIREC1 "PREDIREC1" true true false 2 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIREC1,-1,-1;NAME2 "NAME2" true true false 40 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME2,-1,-1;SUFFIX2 "SUFFIX2" true true false 4 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX2,-1,-1;POSTDIRE1 "POSTDIRE1" true true false 2 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIRE1,-1,-1;SUPPLEME1 "SUPPLEME1" true true false 30 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEME1,-1,-1;PARETIRED "PARETIRED" true true false 2 Short 0 5 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PARETIRED,-1,-1;A1RETIRED "A1RETIRED" true true false 2 Short 0 5 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,A1RETIRED,-1,-1;A2RETIRED "A2RETIRED" true true false 2 Short 0 5 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,A2RETIRED,-1,-1;UNOCCUPIED "UNOCCUPIED" true true false 2 Short 0 5 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,UNOCCUPIED,-1,-1;VERIFIED "VERIFIED" true true false 2 Short 0 5 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,VERIFIED,-1,-1;SOURCE "SOURCE" true true false 20 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SOURCE,-1,-1;NAME0 "NAME0" true true false 80 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME0,-1,-1;SOURCE0 "SOURCE0" true true false 40 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SOURCE0,-1,-1;LATITUDE "LATITUDE" true true false 8 Double 8 38 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 8 38 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,LONGITUDE,-1,-1;COUNTY "COUNTY" true true false 20 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,COUNTY,-1,-1;MUNI "Local Jurisdiction" true true false 50 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,MUNI,-1,-1;MCD_DIV "MCD_DIV" true true false 50 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,MCD_DIV,-1,-1;NHBRHD "Assessment Neighborhood" true true false 50 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NHBRHD,-1,-1;TAX_PIN "TAX_PIN" true true false 50 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,TAX_PIN,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,last_edited_date,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,GlobalID,-1,-1;Site_ID "SITE_ID" true true false 4 Long 0 10 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,Site_ID,-1,-1" # FeatureClassToFeatureClass Address "Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.AddressTest" Address # "ADDRESS "Complete Address" true true false 50 Text 0 0 ,First,#,Address,ADDRESS,-1,-1;PROBLEM "PROBLEM" true true false 20 Text 0 0 ,First,#,Address,PROBLEM,-1,-1;NOTES "NOTES" true true false 250 Text 0 0 ,First,#,Address,NOTES,-1,-1;PREDIRECTI "Directional Prefix" true true false 2 Text 0 0 ,First,#,Address,PREDIRECTI,-1,-1;NUMBER "NUMBER" true true false 5 Text 0 0 ,First,#,Address,NUMBER,-1,-1;NAME "Street Name" true true false 40 Text 0 0 ,First,#,Address,NAME,-1,-1;SUFFIX "Road Type Suffix" true true false 4 Text 0 0 ,First,#,Address,SUFFIX,-1,-1;NUMBERSUP "Post Number Supplement" true true false 4 Text 0 0 ,First,#,Address,NUMBERSUP,-1,-1;POSTDIRECT "Post Rd Type Suffix Direction Post RdTypeSuffix Direction" true true false 2 Text 0 0 ,First,#,Address,POSTDIRECT,-1,-1;SUPPLEMENT "Suffix Supplement" true true false 30 Text 0 0 ,First,#,Address,SUPPLEMENT,-1,-1;CITY "Postal City" true true false 30 Text 0 0 ,First,#,Address,CITY,-1,-1;ZIP "Zip Code" true true false 5 Text 0 0 ,First,#,Address,ZIP,-1,-1;ADDRESS1 "ADDRESS1" true true false 50 Text 0 0 ,First,#,Address,ADDRESS1,-1,-1;ADDRESS2 "ADDRESS2" true true false 50 Text 0 0 ,First,#,Address,ADDRESS2,-1,-1;NUMBER1 "NUMBER1" true true false 5 Text 0 0 ,First,#,Address,NUMBER1,-1,-1;NUMBERSUP1 "NUMBERSUP1" true true false 4 Text 0 0 ,First,#,Address,NUMBERSUP1,-1,-1;PREDIREC0 "PREDIREC0" true true false 2 Text 0 0 ,First,#,Address,PREDIREC0,-1,-1;NAME1 "NAME1" true true false 40 Text 0 0 ,First,#,Address,NAME1,-1,-1;SUFFIX1 "SUFFIX1" true true false 4 Text 0 0 ,First,#,Address,SUFFIX1,-1,-1;POSTDIRE0 "POSTDIRE0" true true false 2 Text 0 0 ,First,#,Address,POSTDIRE0,-1,-1;SUPPLEME0 "SUPPLEME0" true true false 30 Text 0 0 ,First,#,Address,SUPPLEME0,-1,-1;NUMBER2 "NUMBER2" true true false 5 Text 0 0 ,First,#,Address,NUMBER2,-1,-1;NUMBERSUP2 "NUMBERSUP2" true true false 4 Text 0 0 ,First,#,Address,NUMBERSUP2,-1,-1;PREDIREC1 "PREDIREC1" true true false 2 Text 0 0 ,First,#,Address,PREDIREC1,-1,-1;NAME2 "NAME2" true true false 40 Text 0 0 ,First,#,Address,NAME2,-1,-1;SUFFIX2 "SUFFIX2" true true false 4 Text 0 0 ,First,#,Address,SUFFIX2,-1,-1;POSTDIRE1 "POSTDIRE1" true true false 2 Text 0 0 ,First,#,Address,POSTDIRE1,-1,-1;SUPPLEME1 "SUPPLEME1" true true false 30 Text 0 0 ,First,#,Address,SUPPLEME1,-1,-1;PARETIRED "PARETIRED" true true false 2 Short 0 0 ,First,#,Address,PARETIRED,-1,-1;A1RETIRED "A1RETIRED" true true false 2 Short 0 0 ,First,#,Address,A1RETIRED,-1,-1;A2RETIRED "A2RETIRED" true true false 2 Short 0 0 ,First,#,Address,A2RETIRED,-1,-1;UNOCCUPIED "UNOCCUPIED" true true false 2 Short 0 0 ,First,#,Address,UNOCCUPIED,-1,-1;VERIFIED "VERIFIED" true true false 2 Short 0 0 ,First,#,Address,VERIFIED,-1,-1;SOURCE "SOURCE" true true false 20 Text 0 0 ,First,#,Address,SOURCE,-1,-1;NAME0 "NAME0" true true false 80 Text 0 0 ,First,#,Address,NAME0,-1,-1;SOURCE0 "SOURCE0" true true false 40 Text 0 0 ,First,#,Address,SOURCE0,-1,-1;LATITUDE "LATITUDE" true true false 8 Double 0 0 ,First,#,Address,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 0 0 ,First,#,Address,LONGITUDE,-1,-1;COUNTY "COUNTY" true true false 20 Text 0 0 ,First,#,Address,COUNTY,-1,-1;MUNI "Local Jurisdiction" true true false 50 Text 0 0 ,First,#,Address,MUNI,-1,-1;MCD_DIV "MCD_DIV" true true false 50 Text 0 0 ,First,#,Address,MCD_DIV,-1,-1;NHBRHD "Assessment Neighborhood" true true false 50 Text 0 0 ,First,#,Address,NHBRHD,-1,-1;TAX_PIN "TAX_PIN" true true false 50 Text 0 0 ,First,#,Address,TAX_PIN,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,Address,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,Address,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,Address,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,Address,last_edited_date,-1,-1;Site_ID "SITE_ID" true true false 4 Long 0 0 ,First,#,Address,Site_ID,-1,-1" # FeatureClassToFeatureClass "Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses" J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb AddressToAdjust # "ADDRESS "Complete Address" true true false 50 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS,-1,-1;CITY "Postal City" true true false 30 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,CITY,-1,-1;ZIP "Zip Code" true true false 5 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ZIP,-1,-1;PROBLEM "PROBLEM" true true false 20 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PROBLEM,-1,-1;NOTES "NOTES" true true false 250 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NOTES,-1,-1;PREDIRECT "Directional Prefix" true true false 2 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIRECTI,-1,-1;NUMBER "NUMBER" true true false 5 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER,-1,-1;NAME "Street Name" true true false 40 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME,-1,-1;SUFFIX "Road Type Suffix" true true false 4 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX,-1,-1;NUMBERSUP "Post Number Supplement" true true false 4 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP,-1,-1;POSTDIRECT "Post Rd Type Suffix Direction Post RdTypeSuffix Direction" true true false 2 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIRECT,-1,-1;SUPPLEMENT "Suffix Supplement" true true false 30 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEMENT,-1,-1;ADDRESS1 "ADDRESS1" true true false 50 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS1,-1,-1;NUMBER1 "NUMBER1" true true false 5 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER1,-1,-1;NUMBERSUP1 "NUMBERSUP1" true true false 4 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP1,-1,-1;PREDIRECT1 "PREDIRECT1" true true false 2 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIREC0,-1,-1;NAME1 "NAME1" true true false 40 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME1,-1,-1;SUFFIX1 "SUFFIX1" true true false 4 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX1,-1,-1;SUPPLEM1 "SUPPLEM1" true true false 30 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEME0,-1,-1;POSTDIR1 "POSTDIR1" true true false 2 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIRE0,-1,-1;ADDRESS2 "ADDRESS2" true true false 50 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS2,-1,-1;NUMBER2 "NUMBER2" true true false 5 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER2,-1,-1;NUMBERSUP2 "NUMBERSUP2" true true false 4 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP2,-1,-1;PREDIRECT2 "PREDIRECT2" true true false 2 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIREC1,-1,-1;NAME2 "NAME2" true true false 40 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME2,-1,-1;SUFFIX2 "SUFFIX2" true true false 4 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX2,-1,-1;SUPPLEM2 "SUPPLEM2" true true false 30 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEME1,-1,-1;POSTDIR2 "POSTDIR2" true true false 2 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIRE1,-1,-1;PARETIRED "PARETIRED" true true false 2 Short 0 5 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PARETIRED,-1,-1;A1RETIRED "A1RETIRED" true true false 2 Short 0 5 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,A1RETIRED,-1,-1;A2RETIRED "A2RETIRED" true true false 2 Short 0 5 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,A2RETIRED,-1,-1;UNOCCUPIED "UNOCCUPIED" true true false 2 Short 0 5 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,UNOCCUPIED,-1,-1;VERIFIED "VERIFIED" true true false 2 Short 0 5 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,VERIFIED,-1,-1;SOURCE "SOURCE" true true false 20 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SOURCE,-1,-1;NAME0 "NAME0" true true false 80 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME0,-1,-1;SOURCE0 "SOURCE0" true true false 40 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SOURCE0,-1,-1;LATITUDE "LATITUDE" true true false 8 Double 8 38 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 8 38 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,LONGITUDE,-1,-1;COUNTY "COUNTY" true true false 20 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,COUNTY,-1,-1;MUNI "Local Jurisdiction" true true false 50 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,MUNI,-1,-1;MCD_DIV "MCD_DIV" true true false 50 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,MCD_DIV,-1,-1;NHBRHD "Assessment Neighborhood" true true false 50 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NHBRHD,-1,-1;TAX_PIN "TAX_PIN" true true false 50 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,TAX_PIN,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,last_edited_date,-1,-1;Site_ID "SITE_ID" true true false 4 Long 0 10 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,Site_ID,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,GlobalID,-1,-1" # FeatureClassToFeatureClass AddressToAdjust J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb AC_AddressesReworked # "ADDRESS "Complete Address" true true false 50 Text 0 0 ,First,#,AddressToAdjust,ADDRESS,-1,-1;CITY "Postal City" true true false 30 Text 0 0 ,First,#,AddressToAdjust,CITY,-1,-1;ZIP "Zip Code" true true false 5 Text 0 0 ,First,#,AddressToAdjust,ZIP,-1,-1;PROBLEM "PROBLEM" true true false 20 Text 0 0 ,First,#,AddressToAdjust,PROBLEM,-1,-1;NOTES "NOTES" true true false 250 Text 0 0 ,First,#,AddressToAdjust,NOTES,-1,-1;PREDIRECT "Directional Prefix" true true false 2 Text 0 0 ,First,#,AddressToAdjust,PREDIRECT,-1,-1;NUMBER "NUMBER" true true false 5 Text 0 0 ,First,#,AddressToAdjust,NUMBER,-1,-1;NAME "Street Name" true true false 40 Text 0 0 ,First,#,AddressToAdjust,NAME,-1,-1;SUFFIX "Road Type Suffix" true true false 4 Text 0 0 ,First,#,AddressToAdjust,SUFFIX,-1,-1;NUMBERSUP "Post Number Supplement" true true false 4 Text 0 0 ,First,#,AddressToAdjust,NUMBERSUP,-1,-1;POSTDIRECT "Post Rd Type Suffix Direction Post RdTypeSuffix Direction" true true false 2 Text 0 0 ,First,#,AddressToAdjust,POSTDIRECT,-1,-1;SUPPLEMENT "Suffix Supplement" true true false 30 Text 0 0 ,First,#,AddressToAdjust,SUPPLEMENT,-1,-1;ADDRESS1 "ADDRESS1" true true false 50 Text 0 0 ,First,#,AddressToAdjust,ADDRESS1,-1,-1;NUMBER1 "NUMBER1" true true false 5 Text 0 0 ,First,#,AddressToAdjust,NUMBER1,-1,-1;NUMBERSUP1 "NUMBERSUP1" true true false 4 Text 0 0 ,First,#,AddressToAdjust,NUMBERSUP1,-1,-1;PREDIRECT1 "PREDIRECT1" true true false 2 Text 0 0 ,First,#,AddressToAdjust,PREDIRECT1,-1,-1;NAME1 "NAME1" true true false 40 Text 0 0 ,First,#,AddressToAdjust,NAME1,-1,-1;SUFFIX1 "SUFFIX1" true true false 4 Text 0 0 ,First,#,AddressToAdjust,SUFFIX1,-1,-1;SUPPLEM1 "SUPPLEM1" true true false 30 Text 0 0 ,First,#,AddressToAdjust,SUPPLEM1,-1,-1;POSTDIR1 "POSTDIR1" true true false 2 Text 0 0 ,First,#,AddressToAdjust,POSTDIR1,-1,-1;ADDRESS2 "ADDRESS2" true true false 50 Text 0 0 ,First,#,AddressToAdjust,ADDRESS2,-1,-1;NUMBER2 "NUMBER2" true true false 5 Text 0 0 ,First,#,AddressToAdjust,NUMBER2,-1,-1;NUMBERSUP2 "NUMBERSUP2" true true false 4 Text 0 0 ,First,#,AddressToAdjust,NUMBERSUP2,-1,-1;PREDIRECT2 "PREDIRECT2" true true false 2 Text 0 0 ,First,#,AddressToAdjust,PREDIRECT2,-1,-1;NAME2 "NAME2" true true false 40 Text 0 0 ,First,#,AddressToAdjust,NAME2,-1,-1;SUFFIX2 "SUFFIX2" true true false 4 Text 0 0 ,First,#,AddressToAdjust,SUFFIX2,-1,-1;SUPPLEM2 "SUPPLEM2" true true false 30 Text 0 0 ,First,#,AddressToAdjust,SUPPLEM2,-1,-1;POSTDIR2 "POSTDIR2" true true false 2 Text 0 0 ,First,#,AddressToAdjust,POSTDIR2,-1,-1;PARETIRED "PARETIRED" true true false 2 Short 0 0 ,First,#,AddressToAdjust,PARETIRED,-1,-1;A1RETIRED "A1RETIRED" true true false 2 Short 0 0 ,First,#,AddressToAdjust,A1RETIRED,-1,-1;A2RETIRED "A2RETIRED" true true false 2 Short 0 0 ,First,#,AddressToAdjust,A2RETIRED,-1,-1;UNOCCUPIED "UNOCCUPIED" true true false 2 Short 0 0 ,First,#,AddressToAdjust,UNOCCUPIED,-1,-1;VERIFIED "VERIFIED" true true false 2 Short 0 0 ,First,#,AddressToAdjust,VERIFIED,-1,-1;SOURCE "SOURCE" true true false 20 Text 0 0 ,First,#,AddressToAdjust,SOURCE,-1,-1;NAME0 "NAME0" true true false 80 Text 0 0 ,First,#,AddressToAdjust,NAME0,-1,-1;SOURCE0 "SOURCE0" true true false 40 Text 0 0 ,First,#,AddressToAdjust,SOURCE0,-1,-1;LATITUDE "LATITUDE" true true false 8 Double 0 0 ,First,#,AddressToAdjust,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 0 0 ,First,#,AddressToAdjust,LONGITUDE,-1,-1;COUNTY "COUNTY" true true false 20 Text 0 0 ,First,#,AddressToAdjust,COUNTY,-1,-1;MUNI "Local Jurisdiction" true true false 50 Text 0 0 ,First,#,AddressToAdjust,MUNI,-1,-1;MCD_DIV "MCD_DIV" true true false 50 Text 0 0 ,First,#,AddressToAdjust,MCD_DIV,-1,-1;NHBRHD "Assessment Neighborhood" true true false 50 Text 0 0 ,First,#,AddressToAdjust,NHBRHD,-1,-1;TAX_PIN "TAX_PIN" true true false 50 Text 0 0 ,First,#,AddressToAdjust,TAX_PIN,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,AddressToAdjust,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,AddressToAdjust,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,AddressToAdjust,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,AddressToAdjust,last_edited_date,-1,-1;Site_ID "SITE_ID" true true false 4 Long 0 0 ,First,#,AddressToAdjust,Site_ID,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,AddressToAdjust,GlobalID,-1,-1" # CalculateField AC_AddressesReworked UNIQUE concat( !PREDIRECT!, !NAME!, !SUFFIX!, !NUMBERSUP!, !POSTDIRECT!, !SUPPLEMENT!) PYTHON_9.3 "def concat(*args):\n sep = " "\n nonnull_args = [str(arg).strip() for arg in args if arg] # Filter NULLs\n good_args = [arg for arg in nonnull_args if arg] # Filter blanks\n retval = sep.join(good_args)\n returnVal = retval.title()\n return returnVal" CalculateField AC_AddressesReworked UNIQUE1 concat( !PREDIRECT1!, !NAME1!, !SUFFIX1!, !NUMBERSUP1!, !POSTDIR1!, !SUPPLEM1! ) PYTHON_9.3 "def concat(*args):\n sep = " "\n nonnull_args = [str(arg).strip() for arg in args if arg] # Filter NULLs\n good_args = [arg for arg in nonnull_args if arg] # Filter blanks\n retval = sep.join(good_args)\n returnVal = retval.title()\n return returnVal" CalculateField AC_AddressesReworked UNIQUE2 concat( !PREDIRECT2!, !NAME2!, !SUFFIX2!, !NUMBERSUP2!, !POSTDIR2!, !SUPPLEM2! ) PYTHON_9.3 "def concat(*args):\n sep = " "\n nonnull_args = [str(arg).strip() for arg in args if arg] # Filter NULLs\n good_args = [arg for arg in nonnull_args if arg] # Filter blanks\n retval = sep.join(good_args)\n returnVal = retval.title()\n return returnVal" CalculateField AC_AddressesReworked UNIQUE2 concat( !PREDIRECT2!, !NAME2!, !SUFFIX2!, !POSTDIR2!, !SUPPLEM2! ) PYTHON_9.3 "def concat(*args):\n sep = " "\n nonnull_args = [str(arg).strip() for arg in args if arg] # Filter NULLs\n good_args = [arg for arg in nonnull_args if arg] # Filter blanks\n retval = sep.join(good_args)\n returnVal = retval.title()\n return returnVal" CalculateField AC_AddressesReworked UNIQUE1 concat( !PREDIRECT1!, !NAME1!, !SUFFIX1!, !POSTDIR1!, !SUPPLEM1! ) PYTHON_9.3 "def concat(*args):\n sep = " "\n nonnull_args = [str(arg).strip() for arg in args if arg] # Filter NULLs\n good_args = [arg for arg in nonnull_args if arg] # Filter blanks\n retval = sep.join(good_args)\n returnVal = retval.title()\n return returnVal" CalculateField AC_AddressesReworked UNIQUE concat( !PREDIRECT!, !NAME!, !SUFFIX!, !POSTDIRECT!, !SUPPLEMENT! ) PYTHON_9.3 "def concat(*args):\n sep = " "\n nonnull_args = [str(arg).strip() for arg in args if arg] # Filter NULLs\n good_args = [arg for arg in nonnull_args if arg] # Filter blanks\n retval = sep.join(good_args)\n returnVal = retval.title()\n return returnVal" FeatureClassToFeatureClass J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb AC_AddressesReworked3 # "ADDRESS "Complete Address" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,ADDRESS,-1,-1;CITY "Postal City" true true false 30 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,CITY,-1,-1;ZIP "Zip Code" true true false 5 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,ZIP,-1,-1;PROBLEM "PROBLEM" true true false 20 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,PROBLEM,-1,-1;NOTES "NOTES" true true false 250 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,NOTES,-1,-1;PREDIRECT "Directional Prefix" true true false 2 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,PREDIRECT,-1,-1;NUMBER "NUMBER" true true false 5 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,NUMBER,-1,-1;NAME "Street Name" true true false 40 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,NAME,-1,-1;SUFFIX "Road Type Suffix" true true false 4 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,SUFFIX,-1,-1;NUMBERSUP "Post Number Supplement" true true false 4 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,NUMBERSUP,-1,-1;POSTDIR "Post Rd Type Suffix Direction Post RdTypeSuffix Direction" true true false 2 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,POSTDIRECT,-1,-1;SUPPLEM "Suffix Supplement" true true false 30 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,SUPPLEMENT,-1,-1;ADDRESS1 "ADDRESS1" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,ADDRESS1,-1,-1;NUMBER1 "NUMBER1" true true false 5 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,NUMBER1,-1,-1;NUMBERSUP1 "NUMBERSUP1" true true false 4 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,NUMBERSUP1,-1,-1;PREDIRECT1 "PREDIRECT1" true true false 2 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,PREDIRECT1,-1,-1;NAME1 "NAME1" true true false 40 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,NAME1,-1,-1;SUFFIX1 "SUFFIX1" true true false 4 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,SUFFIX1,-1,-1;SUPPLEM1 "SUPPLEM1" true true false 30 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,SUPPLEM1,-1,-1;POSTDIR1 "POSTDIR1" true true false 2 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,POSTDIR1,-1,-1;ADDRESS2 "ADDRESS2" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,ADDRESS2,-1,-1;NUMBER2 "NUMBER2" true true false 5 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,NUMBER2,-1,-1;NUMBERSUP2 "NUMBERSUP2" true true false 4 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,NUMBERSUP2,-1,-1;PREDIRECT2 "PREDIRECT2" true true false 2 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,PREDIRECT2,-1,-1;NAME2 "NAME2" true true false 40 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,NAME2,-1,-1;SUFFIX2 "SUFFIX2" true true false 4 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,SUFFIX2,-1,-1;SUPPLEM2 "SUPPLEM2" true true false 30 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,SUPPLEM2,-1,-1;POSTDIR2 "POSTDIR2" true true false 2 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,POSTDIR2,-1,-1;PARETIRED "PARETIRED" true true false 2 Short 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,PARETIRED,-1,-1;A1RETIRED "A1RETIRED" true true false 2 Short 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,A1RETIRED,-1,-1;A2RETIRED "A2RETIRED" true true false 2 Short 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,A2RETIRED,-1,-1;UNOCCUPIED "UNOCCUPIED" true true false 2 Short 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,UNOCCUPIED,-1,-1;VERIFIED "VERIFIED" true true false 2 Short 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,VERIFIED,-1,-1;SOURCE "SOURCE" true true false 20 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,SOURCE,-1,-1;BUSNAME "BUSNAME" true true false 80 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,NAME0,-1,-1;SOURCE0 "SOURCE0" true true false 40 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,SOURCE0,-1,-1;LATITUDE "LATITUDE" true true false 8 Double 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,LONGITUDE,-1,-1;COUNTY "COUNTY" true true false 20 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,COUNTY,-1,-1;MUNI "Local Jurisdiction" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,MUNI,-1,-1;MCD_DIV "MCD_DIV" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,MCD_DIV,-1,-1;NHBRHD "Assessment Neighborhood" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,NHBRHD,-1,-1;TAX_PIN "TAX_PIN" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,TAX_PIN,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,last_edited_date,-1,-1;Site_ID "SITE_ID" true true false 4 Long 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,Site_ID,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,GlobalID,-1,-1;UNIQUE "UNIQUE" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,UNIQUE,-1,-1;UNIQUE1 "UNIQUE1" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,UNIQUE1,-1,-1;UNIQUE2 "UNIQUE2" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked,UNIQUE2,-1,-1" # CalculateField AC_AddressesReworked3 ROADNAME concat( !PREDIRECT!, !NAME!, !SUFFIX!, !POSTDIR! ) PYTHON_9.3 "def concat(*args):\n sep = " "\n nonnull_args = [str(arg).strip() for arg in args if arg] # Filter NULLs\n good_args = [arg for arg in nonnull_args if arg] # Filter blanks\n retval = sep.join(good_args)\n returnVal = retval.title()\n return returnVal" CalculateField AC_AddressesReworked3 ROADNAME concat( !PREDIRECT!, !NAME!, !SUFFIX!, !POSTDIR! ) PYTHON_9.3 "def concat(*args):\n sep = " "\n nonnull_args = [str(arg).strip() for arg in args if arg] # Filter NULLs\n good_args = [arg for arg in nonnull_args if arg] # Filter blanks\n retval = sep.join(good_args)\n returnVal = retval.title()\n return returnVal" CalculateField AC_AddressesReworked3 ROADNAME1 concat( !PREDIRECT1!, !NAME1!, !SUFFIX1!, !POSTDIR1! ) PYTHON_9.3 "def concat(*args):\n sep = " "\n nonnull_args = [str(arg).strip() for arg in args if arg] # Filter NULLs\n good_args = [arg for arg in nonnull_args if arg] # Filter blanks\n retval = sep.join(good_args)\n returnVal = retval.title()\n return returnVal" CalculateField AC_AddressesReworked3 ROADNAME2 concat( !PREDIRECT2!, !NAME2!, !SUFFIX2!, !POSTDIR2! ) PYTHON_9.3 "def concat(*args):\n sep = " "\n nonnull_args = [str(arg).strip() for arg in args if arg] # Filter NULLs\n good_args = [arg for arg in nonnull_args if arg] # Filter blanks\n retval = sep.join(good_args)\n returnVal = retval.title()\n return returnVal" FeatureClassToFeatureClass J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3 "Database Connections\AC_Pro(admin).sde\AC_Pro.DBO.Addresses" Addresses # "ADDRESS "Complete Address" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,ADDRESS,-1,-1;CITY "Postal City" true true false 30 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,CITY,-1,-1;ZIP "Zip Code" true true false 5 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,ZIP,-1,-1;PROBLEM "PROBLEM" true true false 20 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,PROBLEM,-1,-1;NOTES "NOTES" true true false 250 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,NOTES,-1,-1;NUMBER "NUMBER" true true false 5 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,NUMBER,-1,-1;NUMBERSUP "Post Number Supplement" true true false 4 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,NUMBERSUP,-1,-1;PREDIR "Directional Prefix" true true false 2 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,PREDIRECT,-1,-1;NAME "Street Name" true true false 40 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,NAME,-1,-1;SUFFIX "Road Type Suffix" true true false 4 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,SUFFIX,-1,-1;POSTDIR "Post Rd Type Suffix Direction Post RdTypeSuffix Direction" true true false 2 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,POSTDIR,-1,-1;SUPPLEM "Suffix Supplement" true true false 30 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,SUPPLEM,-1,-1;ADDRESS1 "ADDRESS1" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,ADDRESS1,-1,-1;NUMBER1 "NUMBER1" true true false 5 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,NUMBER1,-1,-1;NUMBERSUP1 "NUMBERSUP1" true true false 4 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,NUMBERSUP1,-1,-1;PREDIR1 "PREDIR1" true true false 2 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,PREDIRECT1,-1,-1;NAME1 "NAME1" true true false 40 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,NAME1,-1,-1;SUFFIX1 "SUFFIX1" true true false 4 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,SUFFIX1,-1,-1;POSTDIR1 "POSTDIR1" true true false 2 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,POSTDIR1,-1,-1;SUPPLEM1 "SUPPLEM1" true true false 30 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,SUPPLEM1,-1,-1;ADDRESS2 "ADDRESS2" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,ADDRESS2,-1,-1;NUMBER2 "NUMBER2" true true false 5 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,NUMBER2,-1,-1;NUMBERSUP2 "NUMBERSUP2" true true false 4 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,NUMBERSUP2,-1,-1;PREDIR2 "PREDIR2" true true false 2 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,PREDIRECT2,-1,-1;NAME2 "NAME2" true true false 40 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,NAME2,-1,-1;SUFFIX2 "SUFFIX2" true true false 4 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,SUFFIX2,-1,-1;POSTDIR2 "POSTDIR2" true true false 2 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,POSTDIR2,-1,-1;SUPPLEM2 "SUPPLEM2" true true false 30 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,SUPPLEM2,-1,-1;PARETIRED "PARETIRED" true true false 2 Short 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,PARETIRED,-1,-1;A1RETIRED "A1RETIRED" true true false 2 Short 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,A1RETIRED,-1,-1;A2RETIRED "A2RETIRED" true true false 2 Short 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,A2RETIRED,-1,-1;UNOCCUPIED "UNOCCUPIED" true true false 2 Short 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,UNOCCUPIED,-1,-1;VERIFIED "VERIFIED" true true false 2 Short 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,VERIFIED,-1,-1;SOURCE "SOURCE" true true false 20 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,SOURCE,-1,-1;BUSNAME "BUSNAME" true true false 80 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,BUSNAME,-1,-1;SOURCE0 "SOURCE0" true true false 40 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,SOURCE0,-1,-1;LATITUDE "LATITUDE" true true false 8 Double 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,LONGITUDE,-1,-1;COUNTY "COUNTY" true true false 20 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,COUNTY,-1,-1;MUNI "Local Jurisdiction" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,MUNI,-1,-1;MCD_DIV "MCD_DIV" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,MCD_DIV,-1,-1;NHBRHD "Assessment Neighborhood" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,NHBRHD,-1,-1;TAX_PIN "TAX_PIN" true true false 50 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,TAX_PIN,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,last_edited_date,-1,-1;Site_ID "SITE_ID" true true false 4 Long 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,Site_ID,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,J:\Apps\Python\LayerUpdates\AC_ProDevelopment\source\ProDevWs.gdb\AC_AddressesReworked3,GlobalID,-1,-1" # CalculateField "Address Maint\Addresses" ROADNAME concat( !PREDIR!, !NAME!, !SUFFIX! ) PYTHON_9.3 "def concat(*args):\n sep = " "\n nonnull_args = [str(arg).strip() for arg in args if arg] # Filter NULLs\n good_args = [arg for arg in nonnull_args if arg] # Filter blanks\n retval = sep.join(good_args)\n returnVal = retval.title()\n return returnVal" CalculateField AC_Pro.DBO.Addresses ADDRESS NULL VB # CalculateField AC_Pro.DBO.Addresses CITY NULL VB # CalculateField AC_Pro.DBO.Addresses ZIP NULL VB # CalculateField AC_Pro.DBO.Addresses PROBLEM NULL VB # CalculateField AC_Pro.DBO.Addresses NOTES NULL VB # CalculateField AC_Pro.DBO.Addresses NUMBER NULL VB # CalculateField AC_Pro.DBO.Addresses NUMBERSUP NULL VB # CalculateField AC_Pro.DBO.Addresses PREDIR NULL VB # CalculateField AC_Pro.DBO.Addresses SUFFIX NULL VB # CalculateField AC_Pro.DBO.Addresses POSTDIR NULL VB # CalculateField AC_Pro.DBO.Addresses SUPPLEM NULL VB # CalculateField AC_Pro.DBO.Addresses TAX_PIN NULL VB # CalculateField AC_Pro.DBO.Addresses SOURCE NULL VB # CalculateField AC_Pro.DBO.Addresses COUNTY NULL VB # CalculateField AC_Pro.DBO.Addresses MUNI NULL VB # CalculateField AC_Pro.DBO.Addresses MCD_DIV NULL VB # CalculateField AC_Pro.DBO.Addresses NHBRHD NULL VB # CalculateField AC_Pro.DBO.Addresses NAME1 "M 40" VB # CalculateField AC_Pro.DBO.Addresses ADDRESS1 "[NUMBER1] +" "+ [NAME1]" VB # CalculateField AC_Pro.DBO.Addresses SUFFIX "St" VB # CalculateField AC_Pro.DBO.Addresses SUFFIX "Ave" VB # CalculateField AC_Pro.DBO.Addresses ADDRESS "[ADDRESS] + " Ave"" VB # CalculateField AC_Pro.DBO.Addresses ROADNAME "[ROADNAME] + " Ave"" VB # CalculateField Addresses PROBLEM "None" VB # CalculateField Addresses A1RETIRED 1 VB # CalculateField Addresses A2RETIRED 1 VB # AssignDomainToField Addresses SUFFIX RoadType # AssignDomainToField Addresses SUFFIX RoadType # AssignDomainToField Addresses SUFFIX RoadType # CalculateField Addresses NAME "Hidden" VB # CalculateField Addresses PARETIRED 0 VB # CalculateField Addresses PARETIRED 1 VB # CalculateField AC_Pro.DBO.Addresses PARETIRED 0 VB # CalculateField AC_Pro.DBO.Addresses PARETIRED 1 VB # CalculateField AC_Pro.DBO.Addresses A1RETIRED 0 VB # CalculateField AC_Pro.DBO.Addresses A1RETIRED 1 VB # CalculateField AC_Pro.DBO.Addresses A2RETIRED 0 VB # CalculateField AC_Pro.DBO.Addresses A2RETIRED 1 VB # CalculateField AC_Pro.DBO.Addresses A1RETIRED 1 VB # CalculateField AC_Pro.DBO.Addresses A2RETIRED 1 VB # CalculateField AC_Pro.DBO.Addresses PARETIRED 0 VB # CalculateField AC_Pro.DBO.Addresses PARETIRED 1 VB # CalculateField AC_Pro.DBO.Addresses A1RETIRED 1 VB # CalculateField AC_Pro.DBO.Addresses A1RETIRED 0 VB # CalculateField AC_Pro.DBO.Addresses A2RETIRED 1 VB # CalculateField AC_Pro.DBO.Addresses A2RETIRED 0 VB # CalculateField AC_Pro.DBO.Addresses VERIFIED 0 VB # CalculateField AC_Pro.DBO.Addresses ROADNAME "!NAME!+' '+ !SUFFIX!" PYTHON_9.3 # CalculateField Addresses NOTES "check for unoccupied" VB # CalculateField AC_Pro.DBO.Addresses POSTDIR1 "Hwy" VB # CalculateField AC_Pro.DBO.Addresses SUFFIX1 "Hwy" VB # CalculateField AC_Pro.DBO.Addresses POSTDIR1 "" VB # CalculateField Addresses NOTES "Uninhabitable Structure" VB # CalculateField Addresses NOTES "Uninhabitable Structure" VB # CalculateField Addresses NOTES NULL VB # CalculateField Addresses UNOCCUPIED 1 VB # CalculateField AC_Pro.DBO.Addresses SUFFIX "Mdw" VB # CalculateField AC_Pro.DBO.Addresses SUFFIX "Mdws" VB # CalculateField Addresses SUFFIX "Ln" VB # CalculateField Addresses ROADNAME "Nature View Ln" VB # CalculateField Addresses ROADNAME "[NAME] & " " & [SUFFIX]" VB # CalculateField Addresses ROADNAME "[NAME] & " " & [SUFFIX]" VB # CalculateField Addresses ADDRESS1 [ADDRESS] VB # CalculateField Addresses SUFFIX "" VB # CalculateField AC_Pro.DBO.Addresses SUFFIX "Mdws" VB # CalculateField Addresses SUFFIX "Trl" VB # CalculateField Addresses NUMBER1 [NUMBER] VB # CalculateField Addresses NAME1 "Sanctuary" VB # CalculateField Addresses SUFFIX1 "Way" VB # CalculateField Addresses ADDRESS1 !NUMBER1!+" Sanctuary Way" PYTHON_9.3 # 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.1.0'><FeatureDataset>AC_Pro.DBO.Addresses</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68313168444f3977557170684d5a356a63726a6776324b694776624b377a672f4b3875535358554f6b4b58513d2a00;ENCRYPTED_PASSWORD=00022e684b4737447a776f4d345a6e454a69423474697779744b475a42796173386658374e316f30312f546a736d493d2a00;SERVER=Juniper;INSTANCE=sde:sqlserver:Juniper;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=Juniper;DATABASE=AC_Pro;USER=LISuser;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>AC_Pro.DBO.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Unique_ID</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_scale>0</field_scale><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.1.0'><FeatureDataset>AC_Pro.DBO.Addresses</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68313168444f3977557170684d5a356a63726a6776324b694776624b377a672f4b3875535358554f6b4b58513d2a00;ENCRYPTED_PASSWORD=00022e684b4737447a776f4d345a6e454a69423474697779744b475a42796173386658374e316f30312f546a736d493d2a00;SERVER=Juniper;INSTANCE=sde:sqlserver:Juniper;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=Juniper;DATABASE=AC_Pro;USER=LISuser;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>AC_Pro.DBO.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Unique_ID</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_scale>0</field_scale><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.1.0'><FeatureDataset>AC_Pro.DBO.Addresses</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e687a57464173584e347967756c666c7a506b4a31704674376b3356586a4f4f6e43617576752b3556576b736b3d2a00;ENCRYPTED_PASSWORD=00022e682b7167544458546943596e365a50343563316868595739316f5072354432666757796a716c6942525a324d3d2a00;SERVER=Juniper;INSTANCE=sde:sqlserver:Juniper;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=Juniper;DATABASE=AC_Pro;USER=LISuser;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>AC_Pro.DBO.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>UNIQUE_ID</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>unique_id</field_alias><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.1.0'><FeatureDataset>AC_Pro.DBO.Addresses</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e687a57464173584e347967756c666c7a506b4a31704674376b3356586a4f4f6e43617576752b3556576b736b3d2a00;ENCRYPTED_PASSWORD=00022e682b7167544458546943596e365a50343563316868595739316f5072354432666757796a716c6942525a324d3d2a00;SERVER=Juniper;INSTANCE=sde:sqlserver:Juniper;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=Juniper;DATABASE=AC_Pro;USER=LISuser;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>AC_Pro.DBO.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>UNIQUE_ID</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>unique_id</field_alias><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.1.0'><FeatureDataset>AC_Pro.DBO.Addresses</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686e616973486963586339684d385749544d624e443073384258766b6456316352326a31755a6c634144536b3d2a00;ENCRYPTED_PASSWORD=00022e68766a685653446e566b416463337631316f2b7839495559626d5337544d44577a7336704f672f32545a48453d2a00;SERVER=Juniper;INSTANCE=sde:sqlserver:Juniper;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=Juniper;DATABASE=AC_Pro;USER=LISuser;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>AC_Pro.DBO.Addresses</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> 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.9.0'><FeatureDataset>ACESRIDB.GIS.Addresses</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68507056566f4f304c412f707442366f434a694245445a466a55487a614d6c704b474f6a2b487463724c48633d2a00;SERVER=AC-IntSQL02;INSTANCE=sde:sqlserver:AC-IntSQL02;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=AC-IntSQL02;DATABASE=ACESRIDB;USER=gis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ACESRIDB.GIS.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><EnableAttachments /></workflow></operationSequence>" Append APPEND_Addresses_ForACES ACESRIDB.GIS.Addresses "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append Addresses_021324 Addresses_ACES "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY CalculateField "Orchard Hills MHP" NUMBER1 !NUMBER! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "Orchard Hills MHP" ADDRESS1 !ADDRESS! "Python 3" # Text NO_ENFORCE_DOMAINS Append Addresses_03012024 Addresses_ACES "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append Addresses_03012024_Graystone Addresses_ACES "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append Addresses_040924 Addresses_ACES "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append Addresses_040924 Addresses_ACES "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append Addresses_040924 Addresses_ACES "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append Addresses_041224 Addresses_ACES "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append Addresses_050624 Addresses_ACES "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append Addresses_050624 Addresses_ACES "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append Addresses_0610 Addresses_ACES "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY 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.1.0'><FeatureDataset>ACESRIDB.GIS.Addresses</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6867774c7a4d426c682b5a4a517a474747626c682b502b7676634c6d5150726b6d336742686e4371595852493d2a00;ENCRYPTED_PASSWORD=00022e6865737148727072613269684e456b45557349324a5449354f614d5357626c567953646f4b4232564a394f733d2a00;SERVER=AC-IntSQL02;INSTANCE=sde:sqlserver:AC-IntSQL02;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=AC-IntSQL02;DATABASE=ACESRIDB;USER=gis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ACESRIDB.GIS.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Field</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.1.0'><FeatureDataset>ACESRIDB.GIS.Addresses</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6867774c7a4d426c682b5a4a517a474747626c682b502b7676634c6d5150726b6d336742686e4371595852493d2a00;ENCRYPTED_PASSWORD=00022e6865737148727072613269684e456b45557349324a5449354f614d5357626c567953646f4b4232564a394f733d2a00;SERVER=AC-IntSQL02;INSTANCE=sde:sqlserver:AC-IntSQL02;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=AC-IntSQL02;DATABASE=ACESRIDB;USER=gis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ACESRIDB.GIS.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>LAT_Y</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>LONG_X</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><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.1.0'><FeatureDataset>ACESRIDB.GIS.Addresses</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6867774c7a4d426c682b5a4a517a474747626c682b502b7676634c6d5150726b6d336742686e4371595852493d2a00;ENCRYPTED_PASSWORD=00022e6865737148727072613269684e456b45557349324a5449354f614d5357626c567953646f4b4232564a394f733d2a00;SERVER=AC-IntSQL02;INSTANCE=sde:sqlserver:AC-IntSQL02;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=AC-IntSQL02;DATABASE=ACESRIDB;USER=gis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ACESRIDB.GIS.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Y_Lat</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>X_Long</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Field1</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> ExportFeatures "Address Features\Addresses_20240708" "U:\Scratch Workspaces\Dispatch - CAD Mapping\Dispatch Workspace\addresses_20240708.shp" # NOT_USE_ALIAS "MAPPING_ID "MAPPING_ID" true true false 20 Text 0 0,First,#,Address Features\Addresses_20240708,Addresses_AddSpatialJoin.MAPPING_ID,0,20;ADDRESS "Complete Address" true true false 50 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.ADDRESS,0,50;CITY "Postal City" true true false 30 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.CITY,0,30;ZIP "Zip Code" true true false 5 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.ZIP,0,5;PROBLEM "PROBLEM" true true false 20 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.PROBLEM,0,20;NOTES "NOTES" true true false 250 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.NOTES,0,250;NUMBER "NUMBER" true true false 5 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.NUMBER,0,5;NUMBERSUP "Post Number Supplement" true true false 4 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.NUMBERSUP,0,4;PREDIR "Directional Prefix" true true false 8 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.PREDIR,0,8;NAME "Street Name" true true false 40 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.NAME,0,40;SUFFIX "Road Type Suffix" true true false 12 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.SUFFIX,0,12;POSTDIR "Post RdTypeSuffix Direction" true true false 8 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.POSTDIR,0,8;SUPPLEM "Suffix Supplement" true true false 30 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.SUPPLEM,0,30;ADDRESS1 "ADDRESS1" true true false 50 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.ADDRESS1,0,50;NUMBER1 "NUMBER1" true true false 5 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.NUMBER1,0,5;NUMBERSUP1 "NUMBERSUP1" true true false 4 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.NUMBERSUP1,0,4;PREDIR1 "PREDIR1" true true false 2 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.PREDIR1,0,2;NAME1 "NAME1" true true false 40 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.NAME1,0,40;SUFFIX1 "SUFFIX1" true true false 8 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.SUFFIX1,0,8;POSTDIR1 "POSTDIR1" true true false 2 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.POSTDIR1,0,2;SUPPLEM1 "SUPPLEM1" true true false 30 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.SUPPLEM1,0,30;ADDRESS2 "ADDRESS2" true true false 50 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.ADDRESS2,0,50;NUMBER2 "NUMBER2" true true false 5 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.NUMBER2,0,5;NUMBERSUP2 "NUMBERSUP2" true true false 4 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.NUMBERSUP2,0,4;PREDIR2 "PREDIR2" true true false 2 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.PREDIR2,0,2;NAME2 "NAME2" true true false 40 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.NAME2,0,40;SUFFIX2 "SUFFIX2" true true false 8 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.SUFFIX2,0,8;POSTDIR2 "POSTDIR2" true true false 2 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.POSTDIR2,0,2;SUPPLEM2 "SUPPLEM2" true true false 30 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.SUPPLEM2,0,30;PARETIRED "PARETIRED" true true false 2 Short 0 5,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.PARETIRED,-1,-1;A1RETIRED "A1RETIRED" true true false 2 Short 0 5,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.A1RETIRED,-1,-1;A2RETIRED "A2RETIRED" true true false 2 Short 0 5,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.A2RETIRED,-1,-1;UNOCCUPIED "UNOCCUPIED" true true false 2 Short 0 5,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.UNOCCUPIED,-1,-1;VERIFIED "VERIFIED" true true false 2 Short 0 5,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.VERIFIED,-1,-1;SOURCE "SOURCE" true true false 20 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.SOURCE,0,20;BUSNAME "BUSNAME" true true false 80 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.BUSNAME,0,80;BUSSOURCE "BUSSOURCE" true true false 40 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.BUSSOURCE,0,40;LATITUDE "LATITUDE" true true false 8 Double 8 38,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 8 38,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.LONGITUDE,-1,-1;COUNTY "COUNTY" true true false 20 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.COUNTY,0,20;MUNI "Local Jurisdiction" true true false 50 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.MUNI,0,50;MCD_DIV "MCD_DIV" true true false 50 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.MCD_DIV,0,50;NHBRHD "Assessment Neighborhood" true true false 50 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.NHBRHD,0,50;TAX_PIN "TAX_PIN" true true false 50 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.TAX_PIN,0,50;created_user "created_user" false true false 255 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.created_user,0,255;created_date "created_date" false true false 8 Date 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.last_edited_user,0,255;last_edited_date "last_edited_date" false true false 8 Date 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.last_edited_date,-1,-1;Site_ID "SITE_ID" true true false 4 Long 0 10,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.Site_ID,-1,-1;GlobalID "GlobalID" false false true 38 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.GlobalID,-1,-1;ROADNAME "ROADNAME" true true false 75 Text 0 0,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.ROADNAME,0,75;OBJECTID "OBJECTID" false true false 4 Long 0 9,First,#,Address Features\Addresses_20240708,Addresses_AddSpatialJoin.OBJECTID,-1,-1;Join_Count "Join_Count" true true false 4 Long 0 0,First,#,Address Features\Addresses_20240708,Addresses_AddSpatialJoin.Join_Count,-1,-1;TARGET_FID "TARGET_FID" true true false 4 Long 0 0,First,#,Address Features\Addresses_20240708,Addresses_AddSpatialJoin.TARGET_FID,-1,-1;Field "Field" true true false 4 Long 0 10,First,#,Address Features\Addresses_20240708,ACESRIDB.GIS.Addresses.Field,-1,-1" # 20240731 12091800 20240731 12091800 150000000 5000 FGDC Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.1.2.41833 addresses_20240708 1 -86.335952 -85.275035 43.020968 41.980254 Authoritative address dataset <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Dataset the contains edits done by ACGIS Services based on regular updates from EH</SPAN></P></DIV></DIV></DIV> Authoritative Shapefile 0.000 dataset EPSG 5.3(9.0.0) 0 Simple FALSE 0 FALSE FALSE addresses_20240708 Feature Class 0 FID FID OID 4 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. OBJECTID OBJECTID Integer 9 9 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. MAPPING_ID MAPPING_ID String 20 0 0 SITE_ID Site_ID Integer 10 10 0 ADDRESS ADDRESS String 50 0 0 PROBLEM PROBLEM String 20 0 0 NOTES NOTES String 250 0 0 NUMBER NUMBER String 5 0 0 NAME NAME String 40 0 0 SUFFIX SUFFIX String 12 0 0 PREDIR PREDIR String 8 0 0 NUMBERSUP NUMBERSUP String 4 0 0 CITY CITY String 30 0 0 ZIP ZIP String 5 0 0 POSTDIR POSTDIR String 8 0 0 SUPPLEM SUPPLEM String 30 0 0 ADDRESS1 ADDRESS1 String 50 0 0 ADDRESS2 ADDRESS2 String 50 0 0 PREDIR1 PREDIR1 String 2 0 0 NUMBER1 NUMBER1 String 5 0 0 NUMBERSUP1 NUMBERSUP1 String 4 0 0 NAME1 NAME1 String 40 0 0 SUPPLEM1 SUPPLEM1 String 30 0 0 POSTDIR1 POSTDIR1 String 2 0 0 SUFFIX1 SUFFIX1 String 8 0 0 NUMBER2 NUMBER2 String 5 0 0 PREDIR2 PREDIR2 String 2 0 0 NUMBERSUP2 NUMBERSUP2 String 4 0 0 NAME2 NAME2 String 40 0 0 SUFFIX2 SUFFIX2 String 8 0 0 SUPPLEM2 SUPPLEM2 String 30 0 0 POSTDIR2 POSTDIR2 String 2 0 0 PARETIRED PARETIRED Integer 5 5 0 A1RETIRED A1RETIRED Integer 5 5 0 A2RETIRED A2RETIRED Integer 5 5 0 UNOCCUPIED UNOCCUPIED Integer 5 5 0 VERIFIED VERIFIED Integer 5 5 0 SOURCE SOURCE String 20 0 0 BUSSOURCE BUSSOURCE String 40 0 0 BUSNAME BUSNAME String 80 0 0 LATITUDE LATITUDE Double 19 18 8 LONGITUDE LONGITUDE Double 19 18 8 COUNTY COUNTY String 20 0 0 MUNI MUNI String 50 0 0 MCD_DIV MCD_DIV String 50 0 0 NHBRHD NHBRHD String 50 0 0 created_us created_us String 254 0 0 created_da created_da Date 8 0 0 last_edite last_edite String 254 0 0 last_edi_1 last_edi_1 Date 8 0 0 TAX_PIN TAX_PIN String 50 0 0 Shape Shape Geometry 0 0 0 Feature geometry. Esri Coordinates defining the features. GlobalID GlobalID String 38 0 0 ROADNAME ROADNAME String 75 0 0 Join_Count Join_Count Integer 10 10 0 TARGET_FID TARGET_FID Integer 10 10 0 Field Field Integer 10 10 0 20240731 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD07dxn aP1qims2hCuy3EaNysj20ioR2O4jbj8atyr5lrKhBOVIwOp4rm7OKD+09NUx6mRLAl00+4C2j2iI OeoyrKNpBzjniumcuXY9GtU5HZI6Y44I6HmkDKp3PjaOTnpiqGgBv+EZ0sPu3i0izu652DOam1GN 5dMu441LO8LqoHUkqa1h71kzfmvTbJ8gx5UgqRwR0xUinFw5Jx+8f+Zqnp6PHpNpHIpR1gQMp6g7 RkVYnt4roywzrujaRiRkjoxPb6VnNJVrPaz/ADQm/wB1fyHli3Uk/WlV2X7rEfSqV5dXFu6rDYy3 KkZLRuox7ckU+zuJrlWM1rJbFSOJWBz9NpNbOD5ebp/XQPaQfu2/B/5F6YX80syQm2EfzeS5ZSQN q7cg853bs+36F0bsXLNp72AgK8eYCG3bjnOT0xt/XviqN5cvaqhjtZrndnIhx8v13EUyzvJLqQo9 jc24Azum24PtwxrJYd8vNfQ5/ZQ+Hmf4mhNJukcKxKbjtz6VGCVOR1qG6mNtD5gikmOcbIgC364q tbai1xOsRsbyHOfnljAUfiCa1jTbjdbHRzwj7v6Fi21A3b3Me3HkSGIk454Bz+tTA4OarCCOwjuL hFkkMrGV1T5iT04H4CoI9WWSRU+xXy7jjLW5AH1NVyc2sFoRTqQjGzZsB3FuWjtRO5D8YHykLleM jqeKbiVredhp3lzR/wCrWSXiX5e3rznuOMVEw2qTkHHYVmf23FwDZ6j/AOAj/wCFYxoym24mc4xU r89jaLSeQWmtooJBKVVUcPuTA5z9SR+FVzyaUKSM8fiRWa+tW8cjI0F7lTg4tZCPwOKqnTk9I6ms JQpxs5GpuJjZcDoOce4plQqGuhDPFM0cYBdkIALjpgg8jnn8KmotYum03Jr+tB6nCNkA8jr+NZD6 Vcs7Mus3y5OQP3ZA9vu1rD7h+o/rWQ3iXR0kZGvowynBBB4P5VpSVRt8iv8AK5lN0rvnlb52/U0J J47O2DXDbgoALYJZj7AdSfQCsKWe7eZ3j1HVYULEhDpLkIO3JTp7mtW9hmuEsrm3haeNJDIVUDLK 0bqCA2AcFgcEjpXLG/0W0n0+Ga6u1bTWYCP9wuG3ljwH+XnggdQMdKiDq8z9nG/yuYV6kIuyenq/ 8zrLC8S4j8omYzRIok863eFm/wBrawHBIPTjrVaez1dpnaHVo44y2VRrUNtHpndzVbw/pzwJDLbi drUwuQ8kajzd8hkBAUtgDc2OeQw9KuTa7pNvO8M2o2scqHDI8oBU+hzVUXUbfKrv0uaxdOUE5yt/ 281+pajlW3igiu5FedzsDgbd7YJ4HOOAaqXMWrtcu1rd2iQH7qSwFmHHchhn8qlktzqTWF1bOskM Uvmh15Djay8EfWln1TT7WZobi+topU+8kkqqw4zyCfSrjdP3Vd9Va9tew17PW8tPXy9SfT47kosd 68UkzPgNEpRcHpwc/wA6qS6okczFILiRY4WlaIwkFgHVeGBI/iHGCeDVu3uYbmMS280cqZxvjYMM /UVLLqvkELNeJExHVnCsR9euKxmpuWm4Ti2lyT/EhmaSyvpILpJGUgPH5UPRS5UZJbrx6dx60X4u o1K2axNKrYPnEgY/CpYdR80YhvA4HPySZppkQcl1H1NEVJSvIqEJW96dynbPqhuFF1FarDzuaN2L D8CKurFFECY1ALksxAxk+tAdW+6wP0NPb+H6VUpXe1i1GzWtxtCwQwKRENu47yAOCTyTRSnk8+1T qVJe8gGM8nAp22P++fyplFFimr9QIDKVOcMCDiudGn6hGZICuoSh4fs4XzkNsg2xruClgw+4T908 uRXRUpJPU1MoKRnUpKo1cdwvU/gKikkWKJ5HOERSzH0Ap1Q3kTT2U8K/ekjZRn1IxVRSvZlOPLF2 HpMlxCs0Tbo5FDq3qCMg1KP9dJ/vv/M1T0+2ks9LtbWXHmQwpG2DkZCgH+VWJpGi810iaVg7YRcZ PzH1rOaXtrR7P80Q2/ZXfb9B1FKzbuwH0GKVW254B+orQ11sNopXkG3LbVA79KgtLyO8toLmzeOa KbaysQSCh5J6jHGTz34pN2VxSlyxuyaikS58yNibbYEK5YdHy5U7eeuBkdeo604fK3IBpRkpbE06 qmtDP04zGe/83ftFwfL3dNu0dPbOav1HBew3RmSNOYXMb8Hg9ePzqQcGtJtt6qwqPwff+YUVHc3s NsE3xszyHaiRozsxxngDnpVc6gV+9YaiPpZyH+Q/Xp71HMupfOlo9C5RTLe8guQ2yNlZDtdHUoyn 3B5p560J3HGVxV/i/wB3+opKR7mCDYsvytKdiHk5brj9KWnqTB+9IbskMokExEYXaYtowT2OevGC Pxp1NFxCswt2YGVl3hM4JUcE/mR+dZj2+t72KajaBSflDWp4H/fVXGPNu7f15Ec7i3ZN6+X+ZbvZ pI1hjhZFkmkEYZxkKMFicZGcBT3rno9WZzYqL24Y3UjoF8mFwm19hLEEbl78cgAkkiuoNrBPbIby d4jGyfvo22lXJ2gj06469DWMYNRubhzZeIZNmC6iWCThA23s2M5HPA96xesrc1jlxFZqXUbouqtd zxxiTz4ZlmaOQhOPLZFPKEgg+YMEf3T14NbTQQsctFGT6lRUFhHasFlF5Nd3XkKzSSR7cIT/AA+g J7d+OTiq8/8AbguH+zjTzDn5PMLhse+OKuinLqbUqqcLtN/Inu7l7SaxiiVAk03lsMdBtY8fiBU0 lnbSsWkt4XY9SyAk0QqrW8LagsX2lTkbPuhuny55zj+tVbuTV1uGFpBaPDxtMsjK3TnIAIrVau0d H37jUopttP7vIv2yRWpURRrHGGyVQbQfyqG60y5u0UrrEe5Y2CtLH8wYnI7HAx3/AAGKWx+1Sx/6 YkUUpbAWIlxj6nFRXd2I5tlpc2Uu0N5nnSPFtx1x8pz1/wAKxnFOdm9fX9TOv7Fpc918i5NaQrdv LY3xtI2GDHHbgBjvJJ4x1BA/AZ71HewQXwaOeFZYS24JIMgelQxTSwyzJqjWdqY0D/u5ml4L7B0U fxcetS3puII2+zwrPKGxsZ9g+ucGiKtPR6+v6hR+r2fLr8n/AJFaDSNOtbhZ7eygilX7rogBHGKt K0zPJ5oUANhCGySuO/oc5qlb3OpyXCpcadHFEesi3G7H4bRWk2ABg545rSpzX993frc1jyXXIrfK 3T0G0iPNsKyBQMnaFOcr2z70tPIBQHcMgdKhmsrcyuNBIOR1p3mv/epg5PXFTpbNIMowI6dDSduo TcV8RAORnBHsaKhF5FJeSWoY+dGiuwIxkHIBHr0qaqaa3HCXMrhTJpBDBJKQSEUtgd8Cn0yWPzoX izjepXPpmhWvqOWzGW12t/ZRXiqVWdBIFPUAjOKiuL9odRNuYhh5MBi3JyxGenb60+ztfsOnwWe/ f5EYi3YxnaMZ/SsjxBDNPfCKBzHKx+SQfwncQCfxI/M/hhVt7Zcr01+66OarKUaF+tjoWXaeoP0N CqW7gfU02itjp1sUtb0sappU1mxjzIPlY87T68VR0bw8+kafJa21wokaUuZuVJXBAzg9ienTik+2 NJd26TXM6m6SeWNIGRdiRkhRgoxYtj+eBxVaDVBcRW7217debNayXSpM0bBFTPDKEVsNj1DDPTg1 Dre64X0OeVeLi4M6JkvQQftEW3fITiNc7SPlA47HnP8AOnAXHnHZcZVucMikqeehx0+7+vthIn8y JHxjcoOPSnUezRXsF3Io7W6t5C4kh2vIZJAIVG7ngflwfoOetPhWRZMtKxXaRtzu3HPBy3TjPA9q p6ddS3TXglYHyrlok4xhQBj+dXqqVJxdpPUmlSi4pmdq1neOQ8Nu0ymCWFlQIWBYphgGZQcBWHUd e9Z2y8Ekcn9n3+6Kw+xR/urY7eBljmb5s46HIH550tUvJbdQkDIjeW8rO4BComM8FlGcsByR/SqL Xt6JIlj1KBzJZ/bButF+WPA4b98MNyME4BrKSjfUioqfN771Lei6XNa7naCWICCOBVk27iELHcdp IGS54yen4DTIwcGsvRdRe/twZXDOYop0by/LJjkXcpK5ODncOvVTWpWkNtDopK0VbYeqHYzFTjHB /EUyq15Ldx/ZxaxiQPMqy5/hj5yev0qzV8rSuEH70kQ/YlkvlvQWMiRmIKOmGIJ/9BFRHU7AOVN9 bBgcEGVcj9aGvHXV4rHavlvA8xPfKsoH/oRpW0ywc5extmPXJiU/0rRJae0+RC57y5Lb/wCRcilZ Rvifhh1HQimNqcQkINzAso+UncobrnBPXrUNxdNaRQxwrlpG8uNA20dCe3YAE8DtXPM2n3Mlq8lh pUkl858oukis7btp3bovl+bjLYyayTp398ipPletr/15HVNcNKgzLuU8jnio/MTON65+tUNM1HeU tlESR+WWgMDsUZUbYwGVXgHHI4III4IouNB0m7nee40+3klc7mdkBJPuaqnyPfb+vQuMpuN4Jffb 9CS+tpLiWyeMArDOJH57bSP5kVcyPUVUaePSYrS0ghCwySiFFQ4CZyc4/D9ahfQNKknad7KMys28 tzknrmr0aXNt0/q4oupzOyV+uvl6GkDggg80SJazbjNY2shZWVi0Y+YN1B+uOvWmXMSXdu8Ey7o3 4YdM/lWNs0/RLl5LeKKIhQsks9yI0G7kLljyTtJ47CsmoON5bjqX3lFW9f8AgHQyTmVmLxwtuGDu jB4ByByOgPNRsxZixOSTkmsW6+zX16lvexqsit5eILoExsQSFcIeMhTgnjjFalrBHZwiKIHaCSC5 LH8zzQlDlvHcKbe8Yq3r/wAAlqra2r291eSs4ZZ3DqB/DhQuP0qJtIt2nMxlugxbcQLlwM/TOKsR XiT3U9sqkPb7Qx7HcMjFabJ8mvcbcnKPMra9/Jk9VbO1ktTcmSTf50zSr/sggDH6VaqsJ49RhuYF MkYjkMLMp2tkAHgj61Mb2aW3UdT4otblmp4bp4EKqFIJzyM1kRaSsUySC8vW2nO15yQfqK0tw/ui lOMemo/ekrSiZz2Mp12K/Qr5YtmhkBPPLAjH5GtUoUhEgtJ5wVU5i65L7SPwHzVXkeRIXaJBI4U7 ULYyewz2qnY6xFcXAt2WW2vR/wAsJBhvqp6MPcU5RnUjddDKaUW481ru/wDwDSdLged5dgXKXDRK pkwWUNjd06Y79s+1RSmSKzWaSHyZ9rs0RbO3BOPzAB/GkublYF8y6mCL03SNgfmaijubW93xQ3EU pKnIRwTjpUQhJe89UEVy7zuR6ddvf6Xb3cihXniEjAdASM1S1QpHrdvI7bQJlBJfaB85PToehrTg torO1S2gBEUS7Eyc/KOBWLr9suo6gbFmKJN8jMGxgFsf+zd/T61lW5XW00Wv3XRFa6w672R0Dbf4 QR9aVdv8WfwptFbWOu2hRm02BC/2eaSJZciSGRvMhcE5P7tjtBzzkAGmppVu6BLi4uJI8Y8qOUxx bR/D5akLt9sc981lmJZtVt2lS3lP2qc3sU6I7+SAwjCKwLdkb5evPU1Uit/LitZLi0WML9oedzZr F+7AbyjuEa4YkLjBU88qawcknsccqkE2uU7EiML8u7PvSLjPzZx7VDbeZ9lh83PmbBuz645qWtzs S0HGK3jz5a7S3zHCgZPqfemjGeelZ2kxyRvf+YjLuu3ZdwxkYHI9q0aqUeV2vczo6wIrqxgumRxP LFIgKh0VT8pwSCGBBBKjt2FVv7Pl3E/b5cldhzBByvp/q+ntVPW53R9iLvK2sskcTHCyShkCg/Mu RgscZFUpXYSP5OnwiNbNGGZcbpyVyFxNyAC3y8Zx1rnk0nqY1JwjJpq50NpYw2zPI07ySuFVnZFH yrnCgKAABk9B3NTHrxyKx9Ae4aKTzVULtTKq+5Vkx86qcngfL3PJYZ4rYrSOxvS+FNDwF253c46Y plVL+3uJ1tzbybPLnR5OcbkB5FW6u1le4QvzyGfZomnF0VHnIpjViT90kEj81H5VnvqV6sjL/Y1y yg4DLImD78mpJ7uSHWrW3ZwtvPE+Mj70gKkDP+7uq/Wi92zkr323IUXJy5ZW18uy8ircWhvoreQy eRLG3mKCu7BKMhBHfh2HBrAkguLV1WDRll+zB1h/0VAuDnODvyAST7jNdBetIIUSJyjyypEHABK7 mAyM8Z571iedM9vBJBBqkjSXLwYEr4wrKA/MfBIbPOFwDWDlCL95XMq6in7zd/kT6Bo4tVimNqLN UEpitzMZCnmsGbJwOm1VAHQL3zV2fU5IJ2jGm3soU43xopU/T5qpWN2ZbmMo11G/2uSB4J3LfIqk hmyowT8hG0kYY/hu1VKUV00LpRvD3Hb7isIY9QhgnkSSJo381UfhgRkc9fWoJNV8udovsF82Djes WVPvnPSjVJ5IDZeWxXzLpEbHcHPFaFa7JOSunt5DipOTSfboNmfyYHlKs4UZ2oMsfoK5a8ij1ye4 srrS9Qe3kkWUOsYjO0JsKbmZcZBf1yGPpXV1ga9rLaakkrTSQwRMEYxRK7MxQv8AxEAAAdOpJAGK xk48tpIK8fd96WnoRuDBrDXstpefvpvPciENyqMiqAhbA/eMckjnGB1rdtbhbuHzUSVBnGJUKH8j WVHqM0Wsy2bXS3QimSGUqihQzBiNuGJBG3kNzgj6Vt0QcOS0VqKinb3Xp6FB9WgScxGC73BtuRbO R+eMYqxFZJb3dxdK5LXO0sOw2jHFT1VhvvP1G6s9mPsyxndnruyf6VrunyL1/D9SmmpR5nfX9GWq qRwRaZFd3DyHy5ZTOxI+7kAYAHPardVbO8N1NeRlAv2ebyhzncNqtn/x79KUb2dtupVT4o23/wCA V4te0yeZYo7nLs20Aow5/KtPB9KSilJxfwq34/5DSqdWvu/4I1WDqWUhlHUqcgfX0pcKSGwD6Gm/ vM5cJKezMNrfmKawGcm3c/7suf51z3qR3Vx80uqHvFHKu2RFdfRhkUyK1t4WLRQRRsRglEAJpny/ 9Pqf98N/jTgVHWe4H+9AD/KqVZpWsxXjvYlPQ0rqplckDO484qIspHFy34wGguCxY3KDJz/qmrNz 99Ss9v8AIfOh8wM8DxF2XeuN6cMPcH1pLePyIEi3vJtGN8hyx+ppu8f8/UX4qR/Wjf8A9PEH4nH9 a09srWsyLU97DL2ygv7R7eZBhujdSp9RnvUcOk6dBKskVjArryDtzg+v196sbj/z2tz/AMDpGdwr ENAxAOB5g5qfax7P7gtS3JXy44+XkdKXIz939ayZNZaJirWx3CNWADdWbb8vTr82P+AnOMVKuqiS 8hto7eZnkmeIlk2hdqFs9ehwMfXtT9rEn2lLv+ZpFwcfKOBjvTHDMyFWChTlgB94YPH9fwrKj8Q2 TmcSGWLyi+N0ZO9UGSwx2649QM1pRu80ayRxSMjDKnb1H50e1ghqVJ7P8xzxxyrtkjVx6MM1Xewh NzHIkcSxqCHj8pTv9OeoqziTvFJ/3waPm/usPqjf4UKtBf8ADMq0H1/FijaqhVRVA6Adqg8q5+2i X7Qv2fbjyfL5z67s/wBKm5/yj/8AxNGfcf8AfLf/ABNNV4L/AIYGoPr+LHE5GMACkpu4f3h+R/wo 3j+8v50vbU+5acVsx2BkEgEjpkVDd/aGtz9jMSzZGDLkrj6Dmn+avqv/AH2P8aTzl/vJ/wB/F/xp qvTTvcUlGXX8Stb29zcQyxaqLaVGxgRKcY981WvdI8qIPpS7LoMCJJJnGB+ufoRitLzU/vJ/38X/ ABpfMU/xJ/32v+NN16TlzNoh0otWb/EztI06WD97fLAs67ljFugCKpwTgAKASQMnHYUt5PfRXmIE Z4gRn93xtx1z657VpBgehH/fQ/xpRk9AT9KmVWm9pJCVJKNlIwJL3UpVjEthg7lbIiLFDntnuBz+ NP8A7R1TdEWttqk4b903Awef5fnV/U7W8nSMWwcEE5xxU1jb3Udvi48x5CxPIzgduaj2kW7cxChL na5n66FTTby8umAuIFiGwFsqwIPpz/nr6VU1WzuVvFe3ga4jeQTMowQrgKucFlB4VfvBgCM1v+W/ /PN/++TRsf8AuP8A98mtIzp/aaZpKlzRs5fkZllbyXDJc3huhLG5ZUnZOGwRu+QY6Ejn1NTXd5Lb SBUsbi4BGd0W3A9uSKubW/uN/wB8mkwf7rfkauNSmnfS3YaptKyl+X+RDaTtcxF3gltyGxtlAz9e CaSO0hhu7i4QN5k+3cWOeFGAP5/nU/4H8qM0/aR1s9ylDVOTvYKhhs4Yru4uV3LJOFD88HbkDj8a l3D1FG9f7w/OkprZMqUFK3kVLq+ktpdi2NzOMZ3xBcfTkirFvKZ4FkaN4i38Eg+YfXFP3r/eH50b l/vD86pyi1ZE8kr/ABEN7c/Y4RJ5M05JxtgTcR706zn+2Q+Z5UkPONsy7G/Kqmh3U17pENxO26Ri 4Jxjo5A/QVoA4OaqceS8HuupnTc5xU77rsVr+9j08KZUmfcSuIYzIR9cdKktLhb22FxGkioSRiRC jcex5qZiWYk9Sc0AkHIpXXLa2pdqm9193/BEoqC1u47xJHjVlCSNGQ3qpwakkuIbZRLO4WMEAk+p PA/Ok4tO1tR+0XJz9AnmS2t3nlyIkGWOCeKdEfOhSVOUdQynpkHkcUpJPU5opdAtPuvu/wCCMmZI Imlmwka8lmHAp5g4yYvzWsr7fcTTqqmGFJVmeIPG7l0iOGYkYC89Bz1HrUK6tcSWzXEMllOoge4W NN4kljQkMcEfKeCBydxFRzxMvba2bX3Gw0UajLRqOcZK0pt0/iiX8VpQQ6gggqeR70uT61ZraXkM EEZ4EY9eBTTbw55QZNR2V+94bkFdogmaEYPXGOf1qz1IPcHI9qHFxdmiYNyV0kRi3jHIDD6MaPKA 6PIP+2jf41U1HVxZF14YxoJJGklEaRqSQCzH1IOAATwary6xLE0sktnGptjslY3kf7ktjhueM446 njoKjmityZVFF2dv6+RqbCOkso/7aH/Gl2v/AM95v+/hqK0vBeQ+YAysDhlZg2DgHqCQeCDkdjUu wfaPP/j27PbGc9OlUkmVq1dJf18hf3n/AD3l/wC+qMy/8/Ev5innBGcYOabRZFRSfQTdN/z8Sfp/ hS75/wDn4f8AIf4UoAwSegqOWJJZInIIMTFlwT1xjn1/GhJCfaKHbp/+e2fqg/wpCZj/AMtEP1jF E1ytvGZJBkZAACZJJ4AAA5NUjeGS4jnWyvS6hkVUj+U565GcE8d+RS91bkSajul95bKSHr9nP1gH +NMMJPWKzP1t/wD69VbbVLid43lhg8mSQwh4XLbXAJwcqAfutypIyKvLGFuWnyxLIF2E/KMHOQPX mklFoIvmV4r8SL7Mv/PtZH/tj/8AXpPs6/8APpafgpFS3F7FaCNpFAEkixLhc/MxwKciFZpJCxbe R8p6LgY4p+zVrtB1sl+JD5Cf8+cH4OwpRGB0tVH0nYVYyM8oD+J/xqCW9gt5djAtIRu2IrOQPXA7 cVLhDsNq26/EXGP+WDj6XLUuT/cuPwumqOPULeaRY1yGfJTdGyhsehPWrOR/d/U0vZwfQFrsvyI9 zf8AT2PpcGmSNcExmKW7TaxLbpc7htIx+ZB/CpI1KBgzF8sSCeMD0p5A4I6Gh0Ydg5U9GmjIU6+s BUXh81YmCszZDOZMjP0TA98mpJn1ryL3ybphM8gFuWPyomcEng84yR7+1aVLgbDz83b2pewh2JdG MerM2G51szRCd4xFz5jIpLdARgdO7D8Ae+Be85/+fi4/78iqcEGqLcK097A8IPzIsBUkfXcf5Vo/ J6N+dOWGpx2swhF9n+BWtLSHT7RbeEkRJkjcc9SSf51NGySkbWDAnqDmsaG7Oq6bYSzrGomuCHUj KELvxkdx8oJHeqFjNG0sk0V/Y3N1ZzQLI9nCIs+ZIq4bAAdSrg5xgEcVpVlKM3GW5EKyjCMUuiOq cbXYDscUlVNRDTtb2+XC3E4jcIxDEYJxkcgcckc4zWRZJcWF8olWBAkwt5zbTM6fMgZdyljsO75f /wBYqeazsbOryyUWb8UEVupWJdoZi592JyT+dEtvFdJ5U6hkPOD6jkfqKbb3Ud3GzxZ2q7RnI7qS D+op0sogjLsrsBxhF3HnjpWvvX8xaex8rEjAA8MD9KVVDfxAfWm0VJrZ2M+Tw9cRzxywxQ3JRGjj 3qFlhUnOFkCkgZJ4IPWq0HhmaOSFotPtrSaKIwR3CzMWWI8EEEfM2CwB4ALHj115LS0mmuJmNykl wrK3lyY27ihJB7f6tePr60t9b2V/dPcTWzb2XZ8spHG4t+fzH865+WXY4XTqP7I5bcW8SxqV2oAo APIAoVdxxkD60sjmSRnPViSabW6vY7knbUrSQw6VDcTKsjh2851Qb2LHAOAKqQ67BNPHCLW+VnYK C9q6gfUkcVJpc0sz33muzbLp0Td2UAYA9q0K3do3U9X6nPTU3FOLsvT/AIJmalpkkv2xj5UlvcRI s0bSsjfuyxGChyQdx4xXOX+pxXkd1C9nqCyXUiO80McrkbQQNu/bsPPBGR7Vu61fXFus/wBmEjfZ 7Vp3ji+9IdwCqDtbGcP27DpVK/kmC30ZW7uRbQQzRCTJR2cgEOBGuQuc9T6kcYrmvSV+dNvydv8A M56695q+vp/wTb02zNpbbfLSPcRiNH3BFVQirnvhVUZqqfEemqxUyTAg4P8Ao8n/AMTUHh43B3eb F5Cm2gd4NpURTMGZ1A7fKYuPXJwM1uVpScLe8v0/RnTBVHBcrS+X/BIlUXK291HK4j+8FHAcEdwe fepaUD5SfpSUr3NKaabv3/RDRExl80SPtA2+WPu59frWefEGkgkG9jGPXP8AhWoP9WfqP60zav8A dH5VUXH7S/r7ibTu+Vr7v+CQXMU00VvPbKH8uRJgucbwOevb1/CuUeDS4TaW8zf8eVy8yo91EgDl 1fB2xjGGUdMHkjoa7iIgJIolMLnbtcLnGGBx9CBikSFI2R3v5pvlZTkdcsTkqcjgccc/TFZPl5ve TZz141HLRXOd0TSBbQ24tlZbKN/PXLBy77PLGCoAwFLZ7knPatOXVNPglaKa9t45F4ZHkAI/A1eV TDEFN/Pc/u1Ta64AIJO769v51C0MTsWaJGJ6kqDVUuVbrQ1oqooaaFW4gTVbe3e3mRo0nSYOp3Bg rZIyKfJqVjFI0cl5bo6nDK0gBBpl/ctYRW/kogElxHERjszYNWGtbd2LPBEzHqSgJNbaWXNt0Guf ndrX0JGZUQu5CooyWJwAK5LWJLbU2urSLVRbTGZHDQyZZoxHjKqAS5BZ8AcgqDXXMN6FH+ZCMFTy CKhis7aF98VvDG3TciAGsnGMo2e46tOc1bQxcznWpLq5eSOOa7Fwn2gBBEojZNozI2Sd2eAOp9hW 9HIkq7o3V19VORTJ7W3ugBcQRSgdPMQNj86dBDFbJst40iTOdsahR+lCjGMdNx04ThothpuIFbaZ owwOMFhmhEuFuZXkkBhYL5aY5UjOeffj8qhk0vT5pTLJY2zyE5LtEpJPrnFXCSQMkn61TaXwg+fm jzd/0YlZ9rZzW+rajdSbfKuPLMfP91SDn05rQocpLGYiQylSrpnsc8EUKTiml1/4f9B1Fdxa6P8A RjfMQ9HX86dWcNB0pXV1sIFZTkELjBrYiKFT5krg57E0T5V8I+aot0vv/wCAYSWP9l2FlHvaRba4 81nVCSASxzgcnBYHHoKp6VbySXximmsZ1kuGu3FlEYow3lxKCyn+LcHIzn147bGn3y6jZR3SIUVy w2k88Ej+laCRAMzebF+7YhxvGVIUMQR6gEH8aisnztz3/U54xgoQnfojN1IiKWzldykUV0rO+cYG CBk9gSQD7E1i6fZomohFsrS0a4k8+UWk3mh1RUwN3UKHPQYHHpXUzLGgDS3FuiyBmUtIMMBgkj16 j8xUK20VvIxjijVmxlkA+b05HWospO9zTljUmpJ7BHBFbqVhQIrEuQPU8k/makU7WB9Mn9KiguYr uFZYWyn3c4xyOD+oqUZ5wMnB4/CtJX+1uVp7HTsUb6xmu5FeLULm0AXBWHaQff5gafYW01msgmvJ bvcQQZgMr9NoFWyCOoIpACegq+duPL0/rqP2UL836v8AzMvUrhbhhHBqEts0ZIf7PD5gz6HIOKqW t3dWsxZ5bzUIiCAHjjhyRydoJVmIHoD+dNP+gzW813M9qsNrNbmNhtSV3bJYSbwqnuMgHqM+lLTr G8820vo7q6uZlsfszKcmJm/echy33cyA52k/IMHFY+3ny8iX4frucknJy0T+9/5nS3Ie9skNlcm3 Z8MsoUPlfoagtLTUIbhXuNTNxEM5jMCrnj1FXIIvIt44s52IFz9BipK2jNqPL+i/Pc6/ZRbvr97/ AMyGaUXUEqWc6pKnyF8btjDqCKpQ2mrJOjS6nFJED8yC2AJH1zxU1haSWbXZl2/vrhpVwf4SBj+V XMj1FVzcl4x1XomRTpqUU3f73/mVdQiszGZpmEUiqVSZpCu3PbIxkZA4z2rAVJSVB160YZ6B5Af/ AEZWlrXnpNHJEj5FvKkciqzeXKSm1vlUkfLv5x+VRLeXsn2hlu1BXT0j2vJJEwlyAZjvReBzkg5w PesPauDaST9VcxrKKlqn97NWz+xmE/Y3Vo9xyUcNlu+T61UMeuZO25sMdswv/wDFUujwsImuXlll MqoqvKMO6qMB2H95uSfYgdq0qunNxWx0Rp80U3dfMRCBEiylfOwM46E98UtKDgN70lIuCtf+uiFD JyhYbuDjvisxjreTtGnkZ77608DbnHOcZpKqEuXpcnk5m9WgX/VrvHz45x0zWXNc6kjO6DT/ACAT hnmYHA9eKdrLxLDbi5OLVpsTknC7QrEBieMFgo54554rBjubdH09h/wj6uuWuCxgJOHO0fL/ALOM Fe/J4FZ+15HtcyrTcXa7/r5HT2V7DdIqmaPz9uWRMkfUZwSPeop5NUWdxBbWrxZ+VnmZSR7jaaxd AW4kmhSW7+2tFI80k/nCXZmNV2bgSOWLtgH+FScV1FVTn1aLp8043baIIozcQR/b4o1kVg+1W3AM DwQTirDYz8pJHvWbrEUksNqI0Zyt3Cx2jOAHGT9MVo1clopX+Q4K02vQcoU/eYj8KiuLi2tVVpZ0 QE4Bchc0+ub17+05JZ00gY1EhEibcoZY8OSRn1YKCR04znpWUnyq5VSTguY6OJ45lDrIpQjIZeQa eVQDh8n0xXKm6ePXbxLdEBiuY4w8LkrIWkAYMAxUtsDuQFUrjvnnqKUZc2oqc/aK4o5PJxQ0ao25 WJLDnk449u1JTm+6v0/rVlSXvR/roxtQ/ZobUXF3GjGaUbnUZJcqMADsKmo8xGUIrqWQncAeR9ad 2thVFdr+ujMpNYnaRVOjX6hiBuKpge5+atbH+0v60lFVNp7KwKE1vL8ijo9lJp+lxW0pUuhYkqeO WJ/rV94bO4mEk1lE8u4tu3MMkpsOee68fgKr3lql6irK0i4OcxOUP5jFNsrNLHd5cs77sf66VpMf TPSlUtUvKW7MlSfKoOKaS7l2ZoplRJrSCRYwVQMv3QQAQPyH5U123tnAHYAdAKrXlsLyMIZposHO 6FyhNR2lj9kdm+1XM2RjbNJuA9xSjCCV+pcYuL0iWY4o4U2RIEXrgDueT+tOyyglcbgDjP0qK3u4 b6EXMBJifO0kY6cf0qZfvfpzSldfFuGnsdO36ASW6kn60BmXoSPpVK/1FbB1U211PuGc28JcD64p 1jfLfBysFxDsx/r4imc+metX7OXLzW0H7WnfluQHVJ7i4EUUcGGMgi+0Sspl8vIcqFVuAQRzjOOn Sol1e5HllFsnaRXMaJcOGfZncBmMAEbW4JHSqWopLpcsTSQTXkISWOH7KjGSIOctuGTG4OSOVGeO uKg0mOLUDb6fBZ6lbWltB5eLxAg2ZyyrgAZckZ/2VwBgmsfZ1bc1tDkdeXNyXOpjnM8KSBmKuoYA +9OBKnIODVe9uY9Pt/NlV2XIXEKGQ/kuTVaz1m2vbkQRx3KuQTmW3eMfmwArWNOTjzJaHX7Wkvdb RJHdR6vFdwyxZjjlaBlY53bcc0yLRNOglWWK1VHQ7lIJ4P51IYYNHtrics7JJIZnwN5BY9gOcVXg 16xuZ0hj+0b3O1d1u6jP1IwK1SnZulflMIOhZe0tf5D9T1KK0jaJ0Mm5CzgyKiqnTLMxAHp61g3l jpyCSS50pLf7KymV7m8D+Tn7p2I7EljjA4z7VsavpryLeyyRiW1ntljnj84xsFQu3BAbIO45GOwr Hm1Wx1KaYzW5eS5MQYNcS8FDlcfuOOT3rGHt3f2V7eRlWlDms+X8Do7O9lneaGUDdGqNuVcAhlyO DyD7e4Peqx0CxLFs3IJ9LqQf+zVY03Tv7NtSm2NBhQEjOVjVUVFUHqcKo571W/4SXSAxU3eCPWN/ 8Kuh7W37u/nb/gG96HKvaWv8jQ83ymhtlicqV4fGQuB3PXJqWhWDwB15ViCDjqMGiszalbXl2/4C I/tGLhbfY/KF9+3K8EDGfXn9Kzm0KNiT9v1FcnPFyeK1gpI4BP0FZbeItJRirX0YIOCDn/CtaXtN fZr7jKXsbv2jXzLzzRWdsgkywG1ASpdnPQcDkk1iTWxmuDL5uuw72J2xr8q/QAH8uo71q3cM1ytn cWyiVY5PN25A3qUZRgkEcbgefSuVb+w9Ols1vGnUae77FWWP5GZi2dqJlRuIHyDp1BArKMqqk/Zq /wCJjXlBdrev/BOn0+5hVUs8zeaqlh9pUq7gHBPbOCRn0yKjudLmnuXlTVb6BW/5ZxlNq/TKk1k+ GLBQIZ7XcbNTI6t5RUMWCKAuVUkBU5YqNzNntW5Nqun28zQz3tvFIv3keQKR+BqqUql20tfQ0h7O UE5u3z/4I+GVNKtY0ubh5tziMSyjLFmOFHGB1IHSor6yubqYSQ6jPaqFxsiVSCfX5gTRPAms20DW s6NGk8c29PmB2MGIyPpipri/s7SURXN3BDIRkLJIFJHrg1aupXj8Wt1b9BpU7tN6adX/AJiWNtNb K4uLuS7LHgyBV2/98gVk+J3WWJYVKxhAWkeQR7FB6ZaToTg4xzwelbVvdW92pa2nimCnBMbhsflX O+JbCO63Q3c7RW80ivlXQFsKylfmZf72QeRycg1nNz5rpa+n6CqqCp+6/wAX/mR6WJbHUwdQnuZy gEY8+aORoS2ACQrsVByBn3GcV09ykskDLBL5Mp6OVDAfhXMWtot9q93LDMGW5mSRl3J+7RXV8Da7 ZyURcgKMDnJrqZHSGMySsqIOrMcAUk5815Kz9LfgLDxjyav8X/mUYLbU0mRptRjljDZZfs4Ukemc 8VeE8UjtEjAvGBvX0z0qJL20kcJHdQux6KsgJNWT/q1/Grm237y/Q1UYprlf4t9BtI53QMsRCy4O CRwD2z60tDEKoJOAFySfqaguortX/rQzlj1kMu65siuRuxAwJH/fVaXHp+tRCeEkASoc9MMKkwau cm90ChFbN/eFFYyaxLKykfZ4Ve0+3L55dQIMj5y+3aD8wO0ZNSSalcwsokSBv9HF0QvmDMW4DIJX APzD5Sc1lzxF7eHc1aKKKo1EWOOJQkSKiAcKowBTJojPC0SyvEW43xnDD6VBpl6dR023vCgjMqbt oOcVZkuIbRDcTyCOKP5ndugHrVNSjK3VfmYXToX6W/QdRVS9S/d0+wzwRLj5hNGXJPtgilsUvU8z 7fNDL02eRGUx65yT7U+VcvNf5F+0d7cr/D/MzVmvLq+t4xLcqLi2luEMIwqlWwqHMbZLDnOexwOm ciK9+23NiDaM0NxbPc3F3OxLxqA+3y3AXaB5YPQYLDPJrb1XSLiaHy9MuVt0cnzo5182JwTnHln5 evPSm6fpF0oEeqTQ3UCgbY4wyKCMY+TOwAY4AArH2Umr8xySjVcrO9jUtDI1nA0pJkMals+uOamq C7+1GD/QjCJc/wDLYErj8KgtRqvnD7W1mYsc+UrBs/ia2Ubxvc6/aWdrMZpN1NdLeec+7yruSJOA MKDwK0ahkKm3k/s8wmUMc5Hy7887sd6qwHWPPT7Qtl5Wfm8stux7ZqmlNuS08jOlPlgk02V9b1X+ zo55DL5UNtbNcTMNu48gKq7iBk/N/wB88A1Xl1aOKS+jGoyzNaW8VwwiWFiyuR2BJGMjJOBg5962 r61tBCbuS4lt5hE+1kLDcq4JB29R/wDXrJurTU2tmP8AadjLY58ucS+dNghgvG0qf4h3wQc4rld2 3ZnPWrtSdmXtOnlmE6yOJAjKFfjuitjjg43dRwau4HoKitLSK0gkSO485hK6SP5ezMi4BAHYDgDH YCqZm1nnFpZn0/ft/wDE1tSi5rRnTCquRN3fyLchuftkIQD7LtbzD33cbf8A2ap6RXHlIrkCU4JX PtzilobNKerb8/0RXL3P9pIgX/RfJYscfx5GP0zU5VT1UflSgpnaW+bqAOtZzT6uGbbYWpXPBNye R/3zVJOW2lvkQpqLd779myzdyvDHGsQTzJZFiUv0GTjJ+gyfwrKjvlnWzYXij7ZNLCm+0X5WjDFt 2JOnynGMnpWtNbi7t0WYtG4w2UPKN7Hv37Vzz2l1HOotzCYoXPlMJoVIPqB5Xyn6Gs+Scn7r/Gxl WlK947ej/wAi7pWrm7mjRSJIZAwV/LEZUhUYcBmyCrg9QRjBHNbDQxMxZo0JPcqKpaZZxxIs0rbr gKUOGVhGCckDaFAyQCeOcc9Kdc3Ooxzstvp6TRD7rmcKT+GKqnGTdr6+ppCVo+/r8n/kLqF0+nW0 TwInzTxxEEcYZgp/nVl4IZW3SRI56ZZQajiQXlsBf26xsDuCbtwBXlTke4zVlgAeDkfSqbS06hC0 pvtp09RkcUcQIjRUB67RisHxHe/Z4JpHG6O3VflVQWdm3HGSrYAVGY4UnH0rolCnq2PwrJ1qztHU O91Ajtg+XcRo8chXpuVgemTyMHmspN9Nx1VeNolK1vBZMu1VEoSBpI2gCuBMwAAkX5WI5PQZCk1v yxpMhSVFdD1VhkVlWktndakZmuLNGZjIscc3mFpGGCxJx0UBQMcDPrWyVUDIcH2xRGUt29SaK920 iqlhZxyCRLSBXXkMsYBFEM80l1cxyRFY4iojf++CMn9asgZOCce9KwAwAwPHUVo5331LcUpRtp/w zG1XjkluWure4gxAp2KDyJFI5OPqSPwqxSTN5cJkCl2VCRGo5bGeB25pJhVtdX2/4DKaaPpqOrpY WyspyCIgCDV3J9T+dZaavO8qo2kXyBiBuKrge5w1awQnoR+v+FXUU18b/G5MZUei/D/gGHNoY2A/ Z7G9ZYlg23MCqzxjGFMgBIxgc4PI6U210LZbxqYrS22wfZsRJ5jiLpt8w4Jz1J2jrW+UnKTKNVKx tFIiqYjuVmfcGB3dgSvXsKkJQ3DyLdzhS0ZEbLkAKckcEdf6965P+3TDrf2ZBR0FKcZOOnamSHbE 59FJroR3dB5RImKRoqIpICqMAVFNaQ30LWtym+GX5XXJGQfpVTRLia70SyuLhy80kKs7HuSKdrF9 LpukXV7CFMsEZdQ4yCR61apzVTkT1vb5nO5L6vzPa36F5lZfvAj60BWb7qk/QUhJPU0oJHQkVnqb 62Aqy9VI+ooAJ6Amsv8AtC6nuYYo/JTz/OMPmh8MsRIZmYDao4469RUf9sMq2rJeWTfa/wDUBRKD JztGflO0E4ALdc1HOjL28Vo3qbBUjqCPwpMZ6UyC5+1W0UwLbZFDgE9MipASDkHBqzVXsZ+nWklg l355QeddSTLz/Cx4zVwTRE4EiE+zCqlvdLrEF1FcQq0cU7wFW+YNtPU0sWj6bBMk0VjbpIhyrLGA Qa2lq37Tcwpc/IuVK39eRfWfamz92y88Mobr1609bhkBEaxoCcsEQAMeOSOmeB+VZ2p3wij+zyIJ RLG5cSOERYxgMXJ6D5gOhPPSsgWdlEzuuk6WrQIszEXK5VT91+F+6ex6+1YL2X29/S4pySlqlf8A ryOmkleU5c5P0xTKr2d4L2Fm2lSDtZdwYcgEEEcEEEEH0NVf+Ef0n/nwh/75q4KDWrt6f8OjROdl ypW9f+ATyWjvqkF2GXZFE6EdyWKkf+gmrdV2uxHfQ2IQ/PEzgjoApUY/8eqxRLmsr/IdPeXr+iKb Wsh1qK7GPKW3eM885LKR/I1cqE3iLfLZYbzHjaUN2wpAP/oQqo+hac8jO0DbmOSRK45/Or3tz6dv 6uQnJOXIk9e/p5EmqGMWqedn7P50fndcbNw3Zx2x1rBh1GzEdl50ujbku3Fx89t/x7c7U6DuR09D 6iunaWKythnCxoAoG3cfQD1JrHmt7GeZpJLDVN7tztSYA++Acfh19qwcYN+87f16oyrwlJp3S+f/ AACrok63GoQSQtbEqLlJVtPLKCPehhLGM7d20MMHn5m7CumqjYXNqoWzhE0bKpKpOjBiAeSN3JwS PpkZouNJtbqdppDcB267Lh0H5AgVVOMVo3p/XmaU1OMLKz+f/AG6zDNPYokCMzCeJiB/dDgk/kDW hVQy2+jWYyZDFvCDcxkOWOBksc4yauMxY5OPwFXJvlS6a/oVC/tHfey/USuV8SzXaG5jsrpLS8dU CStOIiIwrk4YsON+0MQeBgkHpXWK5XsD9RWfqeoxwEI8EblQHZnZUSME4BZj6nIAAJrGaugrLmjZ 6IxGuZ7q9uYvtkd3FczRC1EUoZQiyqSwVWxnYrEuVBDEDmupqjbX8C7ZJLWS3eUgbnhOxifu4kA2 tnjHPOa0WfcMbVH0FKCtsKjHlWmoyqVpDPHqF/JKT5cjoYsnPAXBx6c5q8Dg5wD9ajW7huJ5Y4yN 8OEkABGCef5EVtFtJpIufxR9f0Y+qNlHcJe37TbvLeUGLJyNu0Dj05Bq9ULSx3Uc8EEu2RAY2dR8 0bEZ4zxkAg96ItpNdxVN4vz/AEZNUsc7RrgAdc81iRaVfRyqza5dyKCCVaOPBHp92tgFO8Y/76NE 4pbO/wDXnYFOUlrB/h/mUb46iGj/ALPFqy4O/wA8sD7YxmnWJviH/tAW69Nn2cs355xV0Mg/5Zg/ iaVzHuwqcexpe093lt8yLO9/e/Ao3zXyhPsEcDnnf57FcemMA0li183mDUIrdBgbPIctn1zkCprl ZnCfZpFiIPzb13ZHp1GKsjytpO09ehNNztC1v8xe9fXm/Aj47KFHoO1NeOOVSk0ayRtwyMAQw9CD UV2t07L9kkhiXHzCSMvk/gRVlAvlZc/OMZxxk1L0SZfNpyuLt8v8yneT3kLqLSzW4Uj5i0wTH6Gp rZ5ZYA88Xkyk8pu3Y/GorlL5pc2s0CR46SRFjn6hhU9vvECi42tL3MfC/kc1crci/wCDf/IhSlzf a/AwtR0ow+XNDYw6jIgZI1mgiYojEkpvYBtp3EcGls/DyKkTfZ7awEZYxRQIsjxbzl/3hUHJJI4A wMY9a3bkOImFuV83+Ev938cU6LHkp5p/e4G/aOM98Vk4xcU7Eezi5X1+5ELbbSGKOKNmUFYwqD7o 9foKmC57j86eFjIJG7gZ5pjAbTsPzY4z0zTv0Ned+f3EFtZQ2YlEJJ82Rpnyf4mPNOmmWB4VZWPm ttBVdwB9yOg9zUVo16ZD9tit0THBgkZzn3yoq1cDZG3lAtJtyqtwCe3ParbfNaWpEZ2jZX+5mbqW m3F25e3liw8D28iM5GUYqThlIIPy/jWLqeLdpbC+E6SXlulsGtWeUeWOAuGwFP8AtZ9cjmt+1l1C SdVubSGKI9XWfcR+G0VoiOMnHmZ4z92olCMZe/r6f0zOSVT3tv8At1lGwtpI0kZotjSPuEanO1Qo VRkd9qioJ9c0u2uHgnvYo5UOGVjgg1otgSqoBKEEl/Q8YGPfn8qhmyJYlS3EqM2HcsBsHrjvVU+X aX+RpzyirRf/AJKxjWe++hvdzDZG0YUr1DEHP/jv61YqQRjbncAM4qtLLJHdxRJA0kTfemVhhPqC cn8BQpOWnYuNSMbt9fJkTWZbVY77eAqQNDt7ksynP/jv61L9qt923z4s5xjeKsmMLg+YoyMjrWHd wW0F2Smgm4IO7zo0j5PXuQc1cGqmj6f11IlVULuPXyf+RfvFkZIXiUO0UyS7MgbtpzgE9/8ACsa1 sIrV9OWK3ud9jdS3MagWw+ZwcjA6Dk9MdvQV0drJLcwJI26F2/5ZyN8w+uMiqN3Da2Vyt7HYG4uW JzJbxqXHHUkkVkoRlJp7kVHGXvP9f8ijpukvbX0cixSJEnnO7SiMM7vsAwIwFAAQ/mPetrI3FcjI 6inxl5I1fJXcAdrHBHsaYLKFJ3ulWITSYDyD7zY6ZNKNo6M0hNQVo/r/AJFPVLGTULMQRlQ3mI+W /wBlgx/lV2lctGjPnIUEnacn8qZayi8TzIwygnH7xSh/I81fM3HyQKolNu6u/wBPl5jsjOKwNe0r +0YbiCdbn7NNsZntgrMAocbSpI/vbhjuBx67kvl2YluSMEgb2jUsxxwOAMnrUVvqcV1MsUXn7m6b 4XUfmRik4OUbpaCnVhJcsmvvOfjhgutbuWshE6XE0LO23LokZzhm2KVHyRgR5JzntmuoqKPTIILp 7qO3jSd/vSLgE59aIrtJ7iW3V5N8f3twYD8CeD+FKMUl7uoqUo01ZtfeSblPQj86p2lnJb319M5X bcOrpg9goXn8RSw6Dp9vOs0NpEkqnKspwQfzq+0bjqRnpy1aOcY3UHuXzqTTk1p5+QyqNhbS291q DyLhZ5/MTnquxR/MGrwy0piAJcDcQPSia2eaGSFtyh1K5U4YZ9D2qVO113HOcG001p5hRWRbw2Gm amsJ1C4e4PyiGednBJ6cHitsK56Iv/fIp1EovTb7hRxCfb70R0rAqcGiip6m99bCUu07d3bOKKKG EnYSlCkqW7DrRRSbsEnZCUUUUxikEHB60lFFCEndXFAJBIHSkoooBMKMY60UUDCiiigAooooAO3t RRRQAEk9TRRRQAAkHI60UUUAFLk4x260UUAJSglSCOooooASiiigBcnaR2NJRRQAA4OaUkkknqaK KAFRWdwqjLE8CrDWN0zkmPnr1FFFROVmYVajg9CO6jvoZIorW2ikLRsW3xFvm7ZfcAB045NWraO+ Ak820tlG87AHI+XjGevPX/CiisW2zkbctz//2Q==