20230814 16464200 1.0 FALSE AC_Pro.DBO.Addresses 002 Server=AC-IntSQL02; Service=sde:sqlserver:AC-IntSQL02; Database=ACESRIDB; User=gis; Version=sde.DEFAULT ArcSDE Connection 12596693.167651 12876418.681759 181081.025919 555638.234252 1 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/10.5'><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>3048</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</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> 20230418 13521900 20230418 13521900 150000000 5000 FGDC Version 6.2 (Build 9200) ; Esri ArcGIS 10.5.0.6491 CADADD_8152024 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 SDE Feature Class dataset EPSG 5.3(9.0.0) 60958 Simple FALSE 60958 TRUE FALSE AC_Pro.DBO.Addresses Feature Class 60958 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. SITE_ID SITE_ID Integer 4 10 0 ADDRESS Complete Address String 50 0 0 PROBLEM PROBLEM String 20 0 0 NOTES NOTES String 250 0 0 NUMBER NUMBER String 5 0 0 NAME Street Name String 40 0 0 SUFFIX Road Type Suffix String 12 0 0 PREDIR Directional Prefix String 8 0 0 NUMBERSUP Post Number Supplement String 4 0 0 CITY Postal City String 30 0 0 ZIP Zip Code String 5 0 0 POSTDIR Post RdTypeSuffix Direction String 8 0 0 SUPPLEM Suffix Supplement 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 SmallInteger 2 5 0 A1RETIRED A1RETIRED SmallInteger 2 5 0 A2RETIRED A2RETIRED SmallInteger 2 5 0 UNOCCUPIED UNOCCUPIED SmallInteger 2 5 0 VERIFIED VERIFIED SmallInteger 2 5 0 SOURCE SOURCE String 20 0 0 BUSSOURCE BUSSOURCE String 40 0 0 BUSNAME BUSNAME String 80 0 0 LATITUDE LATITUDE Double 8 38 8 LONGITUDE LONGITUDE Double 8 38 8 COUNTY COUNTY String 20 0 0 MUNI Local Jurisdiction String 50 0 0 MCD_DIV MCD_DIV String 50 0 0 NHBRHD Assessment Neighborhood String 50 0 0 TAX_PIN TAX_PIN String 50 0 0 created_user created_user String 255 0 0 created_date created_date Date 8 0 0 last_edited_user last_edited_user String 255 0 0 last_edited_date last_edited_date Date 8 0 0 Shape Shape Geometry 4 0 0 Feature geometry. Esri Coordinates defining the features. GlobalID GlobalID GlobalID 38 0 0 ROADNAME ROADNAME String 75 0 0 20230418 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDsLfW4 LqCN71HeJrb7Z/pUREiQYJDmRMgDCk4bByMHkjJCllfWkF1aXBiWeNXVLjAzkZwHHykjp+BqGe1R 2kae3E3mKUkaNiC65UlSCeh2Kp55UY6VXjuL+K9gjS4iGnxyvNOjFvNlZzI7jHC4LFFG4DAzjtWH s4y+BmvtZL40W5Ybmyb51dA3fA2t9OxpVuQzYY4HHanaJHqQWSKWR/3cS70jw8cs8mZZmUNwUBdV XsNrCmWl1YalZWU04jsrq8Mgjt4pC5yg+dSrKuGU5BHAB9c1nKnJFqUWWQN0ZZGVlHXB5/KmbQDw cc9ulRtaTRnMLeZjvHnI/DrSLevjbKofA4J4I/Gs7sbjbcmBzwQD7jpSuTIMMxbj+LnFNR434Qgf 7JOD/hS/WndMRgeJIxOtrpkBKTXshVscgRqMufbjA/GtHyWtY1RUAiUADZyAOw/lWdop/tPVr3WC o8v/AI9rbPUKvLH05P8AKt7vnkfSuisuRKmum/q/8tjGl7zdTvt6L+rlPcrDkYqKQGNdy9/erzQo 7FioyRyRxVaW1kMuIyrKvOCcE/h/+usLmw5LuQIsUwWaMDG2Tnj2PUfgRTgYHYGKUwt/ck5XPsQM j6Y/GoDkNtdCG96TYp6UCLxmubcr5gBUttDFgQT6AjjPtzUq3EExG75TnHzcc+mazo5Z7dsxyFc8 HnqKm8+CUYniMZxt3xcDH+70P0GKLDLsuUChRuPIAPJ+lRi6hiwkrGN8Z2v1xUcKSgiSCVJ1xwir hgvptz1+melPim8yZjPFsYDaNxyOpz9D0z+FIAmiiv4GibB3DCE4PPsPWuYu9KubVCCh25+8Oc11 qbWdiOwwfx5/wpZNwULtWQHA2t7n1qWrgcBIjKSWwGHGSOmKXK7NzcnPbvXWXukWs7kjMDnoTwD/ AErJu9EuIMHAdR/EOMfrUOLQzLd0ds8HHTjmmNIAuMA8YGRgj6HNSpburHaTvHJUgZxUZbYhMiH1 J9KgBGQIEwSfY9D+X1FRAksS3GOvSplKsBvcLuPTPH5VH8ofO5h77s0wJlK43HkHng07KOBnhenJ FRFDsyCCSM46U0GSOQblA6cE5BpBcsizfl8qBjPPNVnRX+729+vvUxui42n0xkH8cUwN+7IOCvfm mw0K/wA8e4Fenrmq7Ab93Cntn09q0mKyJtYAgDselQyQtICSCwX0pEtFFIzGwZXyG960Ibl48LG7 q+PvL0OPaojEoQmLB45yelV1uYo1IkJVunJp7C2NWa/jvIJba6QlWXbvjOGGRgn61LaWltNjy5/M +X5kbrn6VjpPuUEMCSR3qVLjy5BgKVzyR1q41GtB6M63QEmtfEdubeNWndHEW5cgPtJHcYzgj/gX vXZNYeLrljKdQht8/wDLPcvH5If5mvMrfWZ4J1kRx5kTblLHkEHjFdGvjvU3UF75om7qIoz/AEro p1YpWZMo3ehMC8Q4PPUg8jmhtl0PLeIcck+3seornLTXLtUCyqJkHBJOD+dbtnf280e9flYjndjN YqSZe4k2mgsWhfax7MNwP1z19ec1Db3MmlypJPZs/lrJGJImzxIys5PcklQSe/fpWm0qggEYz0Pb FJsy6upBUZxjpk9/5/nXRGvJaPVeZm6S3WhNaahY6hgQyqZP7jcMKmmtlmzv6+rcn8+v86xbvS7e 6lDzRfMowHjO1snHOR6f1pirrOnn/RLlL2DtDc/K4+jjr+IqrUp7aev+YKVSHmaE2myJkxZYc9Oc f59wKwdc1C40/THhgOLm4IggBHG5jjIPY9Tmte18UWMjrHdrJYTHoJxhT6YbpWpZ7dX1OS3KRPbq o/ejqWxngjrx9aI0pQlzNXS/rcHUhUXKnZsxtNjgsrCC0T5ViQL9T3P51dyNueMexyKkk0fK5t5w zDqkny5+h6fnVGWOeym2yK8T9t3Gf8awbbd2a8nKrLYslgqkngDnNNQfL8w5PJB7e1VWuQzLHIp5 6kdMe4qz8rHMDqSeik7c/wCfai/ckV1VxhkVh6MM0z7FEy/upTG391un5/4/nTiXRiskTqfcD+lO UhhlTxStfYZUlimgx5sZwehA4NRhlfoa0Fd0yFYjPUdj+FQSQI4yUAb+8vH+f0o16gVtmOVJB9RU wvpgNs8YuAMdchvpuGDj2zj2qN4JEYeWwcZ6Hg0gcZ2uMEevWncQ6OWKaVfLWSGXcGIl9cnPzL9e 4A96vmWaN08+I7MkK45DHHYjr36Zqh5avjBB5zg06Ka4tt5ikbB4KtyD9fWgDS8yOSXy8qcLuK/X pQsaAFE+UA9F9aofabdmUzQtC/3fMh5C5wM7cj0HQj6VahjmwfJmEydQV+c49xwfyGPeiw7kd3Yw XG3zoQ79FZR0/wA4rNm0Q9bdww7o3BH9a1luA0mSDheBtOQTk/0H8/bMrBXcDn5RnIPrUtIZxk+m MhPmIynsSPyrNZTA2M5APUdDXokwDMkbKJA5Od3pj/8AVWfdaJay7mUGNjn3FZuAWOMjuQcqSCRy ARU+VYZ34zxitG90GeIEqN68EMvWsuS3kRzgEbeOeDU2a3Aa6KnIxnPOKfFLbxRulzE7knKuBnt2 5+nbpUK3Dbykgx9R0P1p+Mt8rBu+KAFjd1gGQWBbAAPJqeDDOoYnJGBn/Go0ySGORjGcVMhBdfuk DG2gB72+UJKggehrOnslcBmUMOlaEhaFu+PT1pd8e0885Py4zQDVzCihG8iBCMHPBqcLICchdvXP fHetVUhGQBgZzUbxsJG2jKYxjjg/X8KCbWKGyNfmDAE5A5601fLKglh+Wf61KIA0vltFheuMc/lU 6W8bLkR5pCKG9l43deh96tpI/lBF3K6HJYHAAxVd1aNVO/DYwdw4P5f596fDdMVJyPlPBJyCe68d /anYEbdprk9rHGJW81B6gk1r2l1bXMYW2mMLtgsCRzj6/h6fjXIvIgGYxgdDntUXmtG24FjjoAOh pqVirnoJaSN/nwy9yeCP8aUtHIhw4xjBwelctZ+IJoY1QuZUGAFl4/EGtm11W01CZI1UiUg/ITjd jt/WtFJMC5dRLNbtFJEsiEcqwyKTSbCLSRe3enyS24jgZvK3EpuPT5T06npUjrMhOz5hno/BHrz/ APWqclTosxYH99cQw7TwT8wOKtSaVk9yoxTd2tihda7PpVx5F/aPKgQM09sMhckjlTyenbP0rUsN atNRhxa3EVzHnDROM4+qnkVm3sbPqMwGGkVUB3dzyf61QudHsbhS8kDxXK5CSR5Vh1xgjit3Ug9J K3p/kYKM46xf3nQSaVY3BLwO1pKezZeM/wBRWdd6deWQ3zQlov8AnrF86fmOn41Sjk13TM7Xj1K3 B/1ch2yAezYwfxH41o2Hiy0aURNJJY3BOPLnGAT6A9DS9jfWDv8A12K9qvtqxXhupEQANvjBB2k7 l47ew+mKmaS3mIO1onHcMSP8fw5rXltdOvfnmgMEhOTPbELn6joazp9BvIlL2xS9iHJMXyuPqp/p WDhZmm+xGwdRkESL6ggjPpkcUgkQkLuAYjOD1IqpHM0chCsyyLwVOVYexHWpxcZG2RAynuOD+XQ/ pRqIkPI+YZprAOpBUOD6+nalUMy/uXyc8Kwyfw5/xozjhlK479RRow2IDDtAKFkI7PyD+NNSVgg3 rjJ79/pVsgjdTQ23vjPamBCBHIPTvTfLZTuRip65U/0qz5cDjkMjd2XnP4VE1vcRKWTbKg7oaVws L9vd5Nt1EtwccydHHYfN1PGfUe1SReS8h+yz7ZDglJCASceuMfniq3mpuw+AxOPQmleJX5U/40xF 5pJIJh5yMc8DauMn1HqPccVKJVkwu4E4ywzyBWck9zbqyBt0TdUcZBP8j+VSLdWshVXDW5z7sv4D Oc++T9KVh3L5RSDkcVQvtOtpVLyJtA4yg5P+PJqaOSVFLDE0QGWdCDt+vAwPcgUhm+0XESqcIvzu D19h+fP4UrDRhXfhp1TMMiSc42MMZ/KsaTS5bQ42SYzgAc16Fw1QyRRkglFck4wf1qHBCPPjlflY AkckA09p/s6oT1PQGujvtDE5M9oQjEcKxwOP8/pWM+h31qolKea2dzehFS4tARx3HnKTKpYZ6r0F NZUZSQxycnHb6Uwkh2YKYyedq81JEilj5h6jHHT8qQCJEd3UHvwelTRyumAPmHcr6+9O8nyyzxsv AycYpqSBjkgDnp1pASvEsw+dOc8EtzTPssygBQjDGcsQf5ikkkbaDgN2weccf/rqP+0GwB5Z4GOo oBmUlzICCGM64XjJyAO3rgflUjyWs4JEjxuwKkk8EdcH8fwrEacowCAjHck1JFfbj+9Afnrjkfj/ AI07mSZqbTDISduC2A0fRx34xz+lNJ82IyRFtxx8o989v8MioortGfCPs74bqPx6Hr3qzIqgoZIy CMZZOpHrg4zn8qNCrlYSYIBJyDzxV61uYo0bzUUllwC2Dx36/wCNVtgdNizJM3J2kHcv16Hj16U0 RI7Om8rt+ba7Dp9f/rUrMpHQw+I5YXXy5jJH2WT519MA5yPwNdjDIl1ZaKJAsb3Mzz7c55Vf1rzN ISm0bPvdD2P413mr/udT0izXj7LZbmHcE4H51cHqaR0i2SynN/dAsVPm4yOhwAP6UhLErG53ZO4E exFUNO1BdYguBtf7TFIzFxxuyTg/59Kljt7qJ2lSQPu/hboPatb3ZC2L3yyBlBx2NQzWVvchluLe KRMBQGUHinRSdRIpRycn09sGpG3Kvy/MPQn+tFwMpdLnsGH9k30tuP8AnjKfMi/I9PwqzH4jutOc f2paNCB0uLclkPb6irQlUvsPD/3T1qTBA56Vsqz2nr/Xcz9ml8LsX49R03XIFM6wXiAYEiHDr9CK gl8P78vpt0Je/kXHDfQN3rFutHtp5RLb/wCjTjkyRfKT9cdfxpkV7rmnorSql9CAvI4kHrn1quWn P4Xb1/zDnnH4lf0/yJ545rWTy7uF4GPUSDg/Q9DUgmkDDOHBIzv54x2PX9cVfsPF1legW1wVOf8A ljcjn8CatSaLp90u+xmNpIedjHdGaidKUfiRcZRl8LMjchXKMUY9A2WH04/wFOeGVUDuqsh6OhyP 04pbzTr6wIFzbEp/z0i+Zfy6iq0c5BLwyfUqev1/+vWdmthkgYE/KwPt6U9XKNlSVI7immeOQDzI gGz9+P5Tj6dPyxSIyuDsdXAz068deKV+4ExCSLh1V++SOc/WozbdPKfk/wALHj86arZJI4FSg0WA rSGSI7ZExnp6H6Vl6nciGEhW2M2QOM8/T/OOuDXRK5C4HQ9QeR+VUNQ021v48Sx7SDkFe3GOOcg/ jQnbcRy9rqV9b4mDgxBiFbJDDB7Dvz6Y71sWOvW1y+y5jV5XJJYAJJ+OPvfiCazbzRLu0twsTtco pJUAcgHrnA9T1IrPW3kuZBD9mkRlYE5XAXBGDn24PvWnuvYnXqd3CS4za3KSY+URudpH58frk+lS JcbJVjmVkYL/ABjafqQeme31rOjhG0EHn24qwk8yJ5bhZY+yv2+nofcYqNCi/wDuyck7jycjqcng D+VIkYYkths8q2O3+efxqlvgdl2F7dgc4bLIOh4I5A477qkLS20UmUJQ9JUO5V7AZ7fQ460rDuJd afaXCkyRqoUcuo7Vi3fhxlDmCYsueF710fmI4CqW2g5Yntjnn9PzqUL8q5645qbIDhvss1qSJN6v 03lcCoh5iq7MBkjAYV3EsccuIZEEmecHqB6/rWbc6FG6Hym2+iuOB+VQ4dhnOAKu0KSMHpnOeP8A 69RlwpP7sjPPIq/caTcwuML930GRUElkS2fOKjsD2/UVOojjRbSxkKx698+tSrCoOCV9M4rVSweZ WMceVVS5HoB1PNVo4w29xlhnb0xzUamdivJG0aghAy9DnFPae5QRpEUCsfmVuQPqDV0IskWCozg8 dKqtaPLKkhEZjHy43D16UbFWHwWjToyTZhl9ex7+ufx5q2YZYrfdcHzYx/F97JxwScfzqJVMaokP IQFcFsnA4J9PTpViCCdtmd3yndkH3Hp2571PM1qOxa0SBLzU7WKFiA8ihlIDA89Pfp1NdTqkvn+L tSmKlVhiCBs5zjrx9QazvCKRP4pt4VjG2JGlLHgjA7/n1x2pqSu41q8MuWkkbg9BwcfzFa05X1Le lMpeHJZbbU0wC4kjKMFPOcbhx9R39a63cu87MbSe1cpbpEmpQSMdsqbThRjt3BNdFHNubBO4AA57 1VKakSi0drjbIoKn3qIw7ZAY3YqOqsaeNpHX86euQc4/OtQK6zbZCJOM98dKnWRHXKsDQ6qc8dfS mtCMA7QGz94cYoAHIZ/L7n+VSkYGT0FVfnRyhkDgjAHAanJOwUKY5P8Avg8j8qAG3On2t4uLiBHP XJHNU1sNQsCX069JXOfJl5B/H/IrVBIjDMCvc7gRg/jSqQ2MjBrSFWUNmRKEZbohtPF1xZOIL+2k iz8oIG6Nvp/kVrC10rXIzcxoIipw88XY9vesxoxNdW8JwVaUEgjOQvzf0FPvonkgnit7p4GllJIX kDAABx9QfyqnOElqrPy/yHBSV9brz/zEvvD2owQNJaNHdrtO0g4Of6/pXNy7IiAHMcYl5ZBnhGKt u6BmURsCAeWI5rVh1TWdLZlcGVACBJHyRxwT6+vOKgtr4S6Zp+n2f2OT7NB5WJ0B82Z2VPOcHBwo aV2AbJJxmtY0/wCXUzlNddBovykuyVX5bbubAbdxxtzuzzjvzn0NXIbqGRxGH/eY6FT1zyM+3viq KxWskQYK9q8cJnl81RHCiP5iqTvcOpZULbQTtJGearzpNbKks8KYYSLH5UjMMoDvwFOVKiNE5yBg 7uazdJPbQrmZvEEcH60nesxLyRUMqymQbxEIgAck5CnGOpKuOoxgdc1ZW4Us7NwQAww4dcHoOOOm DwT1FZOEkrspNMm2rJITx8vA9j/nFShYXyJ4t5P8QOGH+NJDE0keU2vjltp5BPt1/SjFRoyhTYq3 NvKGP9xhtb/Cq8jGFtko2t6NxVjIA6U7cWUgncDxg80JNAVMKwoR5IH3RuyEd1OKnNtET8gMRzng 5X6Y7VC0M0Z4XzB1ypHT3z0qrisBaJ+JIgp7NH8v6dP5H3qVRKXzFKJVOBgHa2Pdf8CTUWVI+YYp NmPumgZYjuI0kkaTcrHAKuvKj0/rVnzAeAQapC4faElUSoOgft7A9R+BpR5JYNFIY5CCNsnI/Mf4 fjRYC4CpAI6Hmmb1RmBUHnI4NRCSVFJlQBc43D7v0B5BpUm4z5Z5PalYLnmklz5iqwkGAO5/Gqi3 KBNquqsDyFPWsmN9W0+223lkJkUY3wurH8QDWWJ7m5kfyYmY5yNoyw/CoWHnv0MudbdTso/NlLrG ARj5iWweeB/n2NWSu+1ZXyG4yFP6ZrJt7qZMb4X3Y5LRE4PqPT/9dXrdhLlVU4DEEsDn8DWDi09T QtxRledoXdhmz0OP61e8tQYz8xGec9R6UyJQwwzqrAcf1/nVnZhAQykZ4OfTnn0pablJG34ThW2j 1O/C/wCqtmUOexb/APVWagX/AIRy5YYxPOMnHH3h/wDXrbs/9F8H3kpwDczJH1+hrIMbHQ7QBsu8 u4gnpyzVcbWKqbJEMTxb1QD5V6AdM1bSQeYOSvAxnpVBY1E+WLHGcknJHtVlGV9xJyOxHQ1jflJN uBi0Q9PzzViMlV9P5VRsmJXqa0E967IO8UIQ4Z1AyO/tTL24gsY/MuXIycKqjJJ9Bjv+QHc1JJKl ujSseFBPHX8B3NcLe6uL9vPlJjYghCrcID29fr+Z6UN2Buxoz+IriRnjREt4xx2fP1J4H5VEutsq k/apuOMIxGfy6Vh7bhyqIquDj5kPr0B6jNWI7d0t43kaPYwwBuxIeP7p5P4Z61l725PMbth4lu0k CuVkXnh+ox79fzzXS2NxDqcRaMeVOvVG6H3HqOev6V5tbTszja3yg5H4/wAuK6G3n+zyYUmN0ORs 7HpkGnGY0zqtPDvqzh4iFgTDHI+XPOR+AqL7Ussh3ZB7ZGBjOf5k1Lp920vh271BsC4kbyAQMAtw mR/48fxqoqSIgUhXUdOxrdl7It4yOKo3unQXZzKgDf3gBmrAUYLI7xk87W6UNI8cJaRN2B1XmjVb EPUw59Nu1lt4/tHmWwZg5kTcQuCRgj5h84U8HqBTVmhhlijuLy6gkPyPLGkgBUy+bLtY8gyERqeg AXjsK3CVbOCGHtTGgSQbXUEehrZV39rUzdJfZ0KOqNbW/hqwuir3GorsN7d2gVvLVBvkkGcAnjaC f72cGkjhMDWtrdvuvHaOOSCNNzrKVDFePk+VMMQGO1V4zwS46S8bMbScxBhgqeVI9x0I7cg0yK/u 7DU0vbq382aEuyyIx25YKpfb0DbVxn3bjLGtFyTVk/vFeUXqvuJ1cB9p3JIP4WyrCraXbD/WKJFx jBOCPx//AF1fi17RtYj8u+hQMR94gKR7+lOl8OCQF9MuxIDz5Uv+c1hOk4/EjWMlL4XcoeZGzAIe oHDkA59j0I/HPtTQQ0rLggr13Ag/rUFxFPZkpeW7xD1IyuPr/jSRStGoEbZj/u8Ffw9PwxUWsMtj IpThgPUdOxFRC4Q8bWT8CwH4df51oWth9qiR/tNrH5h2xB5QDIcgYA+rKPqQKau9BPQpSRpIvzKC fXofzqJ4HGTFIG6YV/lP59K2xoEgMeb20AlYpH+8++4zlRxyRtP5VGdIeKZ4J7yyhuEjMzRPOAwi BwZCOyjI5p8kuwcyMMyFCVlQqQcc0sioU3H+Hn3rTntfsjhSYZo2B2sh3IeSDg9jkEHvVdraCTmN 2hJ/hYbl/TkVDbT1HvsVopXjO6KQ4IwcH9DT/Nj72y577Syj8gQKJIJ4Dl49ykZ8xeVNMyp52mmn cR57NC8MrwyIyOjFWVhggjqDVefTLa8cF4QHzw6/Kw/EV0d/pOqXl9NcPZTCad3l8sRnd1BYgdcD ev5/WmWmkXc3n7Y1Uw8SebIse04Jx8xHOFY49jVpyi/dG0pLU5trTUbIbopku4+pSXh/oG7/AI1B aayj3bWsg+yOBk+cBgtk9+P9n6/y6K8sru2t0lngaJZGdUDjBOwqG4PoWUfU+xxjW1rHJPM0sUci SdVkGRx7VNWScfeRHI18LNeFsyjY7FeigDtj0/rV1UfzAV2Yx3Y8mub/ALOexuMafeNBnnymBdOv oen1rYtLy/hgkl1CCNI1zmWF1KkYyWCk7vyBrn9ndXg7/mCqW+JW/I67VQkHhDTYCcLK7zE+hzwf 1qhqO2Ky0yHAwqZIHPYDn86v+ImI0bSIEOW+zA89MNgd/wAKoavGx1GJE4VIRwecjPb34qG0k7m1 T4rFYwbw5LgtnHfFPjXaAM5B5yOKkZNsO0duCM0QgHAAzWOrSRJdszs+Yng1qQur/dINUAuI/rT4 8qjds8V2wjyqwjJ8S3eZktn+4DvJHpXKOfMO5/mUgjLDv25/Oui1yQXdxLEiYkgxknHzA44rnoY5 JclTsC5JJYev/wBes5vUUh1mI7e5WQTGNt42tk/L75Hb8q0L6aGS4ETQho4flWRHzv6ZYYIBHHHT jFZkTl5du4bTxnH8qteeIx5asCmeFYfSkpO1iSSAAMRuE6HONvDjg+o5A/Hp2p8bSPE0qb2JOCjK VZR7jqOlS6U6rcMwHzbWYbgMLgZJzjoACcY7d63rCGG71G1sVVZBORiXksAGw3JOccP1Ufj1rSNP mjzAt7HRxQLb6do+lumHMLXUq+hOF/m5/Kq6x4BB7GnTXIu/GF1PnKRW5iXA/wBpT/hUmN2Sp71Z oyNQG4I5FMeFguEYgHqO1SjAY0HPr1FAimcgEuoz6ingqT1pk0nGKYp3MAPzpgW8dKj8pSpDqp3H J4pu51BwQacsnygdD70gKk2mWs7BirKw/iU4NV0i1DTiDbzPIgOfl6/iDx+Nam7BO4cdvenMBtJU 9B0rSFWUdE9CZQjLViWXjB2AhvoRMvfjP6H+fNXfsWh6rl7Oc2sx5IU8fiD/AFrKe2ilXEsW4A// AFqqSaWVcGGXYQcqrZPQevUVpz05bq3p/l/wSffj1v6/5mldaLqNl85iFxF/z0i64+lOtLrS5Rbf b7eeS5snLwGN9hGWRiGH+9Gp/CqdrrOq6WAWZ2jx/ENy/mP6itP+2NI1UBNStFjfoJUxjP8AvCmq ct4a+n+Qc8XpLT1/zLIh8NpptjbJc3OLGZLmDzgZHRlwNoLZwSARnP8AEeaWWXQdQl+0SW9yJfss 1l5SSFVMMpBYEE9Tgfl+VWTw68i+bpl4lzGedkh5x9ay5Y5beQJdReRJnCrIQN3BPy+vAJOOgFQ6 kiuRI07n7PGkdvaQyRW8e8qJDlmLuXYk+pLGoKghupokwG8yPGNr/MKmS5hkOHR4T0DL86n8Oo/X pWTk92VZbIcM4/HNLx3jQn1I/wADTXGCCrI65xkNwT9f6U3zB3VwfQKT/KlowKcAsdTtnjEgAtmW 5ePyFjjdUlgk2Km84BFsqnk5MjNgfdOZHrFhEs0Un2wRkW4jaE7CfLiaMlgG5B3Z2kkHoeuazJAd w78VUkAPJB4rX2kmHs0i/wCJtbs9Zm+0xmUS7dpWSBQx4QFmkDfN/qlIG0YLNyawbExRGQkYJ5Pf PvTpiqrnv1q5ZRRPeWoMeQWQtkY3DPSsqkm9wSS2K+8zTZU5zxnitebyxoKo8370uF8pSoyC+CTu PPp8oHTvTdYhjtZIBbxqgYNnBB+bjr/9b1prFhDZWsltFueSM7i4IA37wwGPvYwM56cU6MeVt+RE tbI6LxbpcN7qukxuriSCKJFdGK7QTz/KsnVbfWItTla0eC8iQKpSb5XxjOAw47966jWnRvFUUZbl dvyj2TP9ayZZRJfXL5BJkIGMdAAP6VH2bPVeZdWClNvZnPDXIIpRFfwzWMueBMvyn6MOCPyrctFR 0EkbK6HkFTkGp/Iiuo5BJGjo4w6MMg/hXL+GtEM2hW95aXk9pcuW3Mh3I2GI5Q8Hirp0KdSLqX5b NLuuvz6eZg51ISUd/wAHpb5dfI7LZ8q5qWJM4HtWG2oaxpo/0+xF3Co/19mfmH1Q9/pxV+y1vT7u CSW3uFcxqWZOjjHqDzWk6M4rm3Xda/18y41Yt22fZnJSss13eO7nezttGO1UM+WWKg5zz83fpxVs LvVGIJY5G49ietMeERsQF+XGc9f89a4XuN6jItgkXafmXnBNPC+blwenzc1R89I5CeWGOoHTirFp cZzgg4x+NIVzY0u0uZ5WW1IFwsbOvJBcAcgAdTjtXReFvNR7nULkx7rdHii8tVC9TyMAd2P5VkWi A6K908FvcoCQycl1ydoyduRyQcKwJzz7bl2f7I0RoAApjTJAOTk5IB98tj8K7OXlgkVB7yG+HZlv Lq9vCdpd9qgntnJ/kla7AD8T2rJ8P6e1nC0jufm42eh6Vsnhc1CKIM/MATkVI5XZx1xTQqs3oaHX r0PbrTApTDDDOc9ahhVjMWBYqe2eBVmU4JPtSWse3cDwCQR3H+eP1pgS7RxT1i3rjb+Jp21IUMkr BUHc9K53U9cnnLLC5itxwQOGYdOfT6Cpckhm1PJFbDZPOgZTnBH+OKRGhudr200TYPIV+v5VxsSj cw2A7mOcAZ+tSCIByxOMHseajnEjtEaRQN8YK5OcHnrx/nNOVFmy/KMABj+77H8xXMR6ldJGu2Us F6A5I/A9RVmw1eSI7bmUDJ4bBwB9RTU0xm45aMbWUZxwy/dP1HUfrULaXasoMeUP99Dgn69j+NTR XkTENuB9CpyDU4CFSc5buR1NWpW1QmjJFpeWb+ZbyE46NC2xs+6ng/pVbVI73XNR068W+h+2WBIj WaLDRqyuJGCk4ZiPKwDwCp5wa3iHTOQrKBk4ODn6dP1pksEN0myWNWx2Ycj6en1rdV5P4tfzM/Zp fDoYNpc2llZ22m3tzfNqFvaS3N5O8nm+XhfNfOfvIu8ICD1wPXFqWRLfzTNNEFij8yXqskS4By8Z +YdRxj+Ieoq7Jb3EarDDMs0JIPkXXzqMHIwTyMEA/Wqc6o8skly1xbtJLHK6SOWglaMsyAsvKjeV PIJwgHTo/cmHvRHljHM6LJiSNiCVPII/pUwu253pETnrsI/kcVUma/gihSWxF/bWlkFW9MgeS7lV EC52jcHaRiDliMKxPXNaOkaXPqVvK7Xdp5cMn2dJinNwY1CySYBAH7wSDGOig96iVIanfY41kzLj 0FQSJ81WyAOe9RyDcCazRu0Y06sAetaOySKKCcDoqkHHfrVe4Ube+MetXNNv4zahJULxAlQcdSMZ Hv1qZK6IZExmu5Eed2kC4VUwBtGfatmyjB1LSrboHnTKmdWONpx8ob5eCM5X8uapiBMPLHnaeEQc /wCFaekuZ/EmkQtdTs8TMwt3n8xVUbQGAydvUjGe1XS+CVyH8cfU17lvP8YXKk8xhjgj6D/GscRC RjLltryMQD2yTWlI2dd1O6DDEYYfmxP9KxraYvEIgxVQgJb+dZN2ijSXxM0rcjna2cfKceorM8Gr /wAUvafV/wD0Nqv6coSAhPulz/hVLwYP+KXs/q//AKG1dNNfuJesfykYS/jR9H+aNxscj3rG1/S7 G6sJZZ7ZfNC/LKvyuD06jn862GHrVXWMDRrhj025H51kpyhrF2NJRUlaSPOTb6jZ7vs1x9pjXjy5 +GH0b1+tNfW4TG0N2strKQQBKvynscHp+NaAddrkuCTycGqkkTzM9tKnyMMlWycjrWLmpazX6GXI 18LKhk3KTvLJgAMDkZ9K09KRHuVxGJHxkDnPGT25/wA96z/+EaiGZbK7e2J5KD5kJ+lJaX0+ky/6 ZYpPt4EsRYgHPXAIIq6dP3k0xNuPxI9A0WCLUtftYgVaNVEskgI6L1yQqnnnqM+5puu3RurbzVOG uJ949SOWH8hS6Hd58L6t4gAj82+xaQFVwDk7Sfrkkn3FWfscc0tupX5Iot2O/PH4dP1q5Nyk2b/Z S+ZpW9yIbeOKbhx1IHBqz5gkXKsCPaq7FWjC9gMc96rmMrIDGSpxwQaQGiDtX1pM5HpVIXEikrId wHPHWrMUqS4O4AHnmgBHjBGMdfSnqnlxF2YADv7U4KS5GKw/EN6A0dsJMdzj9KTdkMfqOoLIyxAs E9V5yfp3A5rEubYM0hQIVyTlB25wSM8H8fwqYoJYi0h5HOcVmSN+9AWXcynI28MPWsm7iZNCGEDN y7Ic8c4Gce2O/WlM8SR8NjHChuvNRmUZ+ZSuf4h8p/Tr3qGR5BCdiiVeuBwwH07n6e3NJrsHMSPc eYPl+Vc4znOadHdHf8xJXsKzIZmYKgV9zZ+QryPTI/wp7vt6k4BI6VOvUVzY+1oi4jI3Ht0q7Y62 wI85GK99p5FcvHICdvIJq3HKVXjGP0pqTDmZ21pq8dwcI24+g61fFzDLwcfSuBE5MeADnknHb6Gr cGr3ETDzGEyn+/y3T16/zq1MdztgmPmRs57Mc/r/APrprsqKxlXavqeQR9axLTX7dwN+5CcfeOcf j/8AqrXivkk53Z9OatSGRR6eIHMkEkltMf8Ank3H0I7ioZLe6dyZLO1nb++HePP4BgK0FSJjmP5C eTt7/h0px3g8eWR6ltv6YNaxqSj8LIlCMt0cJvGBzTk+YnNRxW1wQCYHyeuBmrKW8wBJhkHPdTU2 Zte5SuI/3bHsAa5+2nlWVAwKqODxnj2Jyf8A9ddFeGQhoVjfLDBOOgrL8hVTpzRYlmhDfxjBDYAG AM9K0vBdyl98RgQQTHaYP5sf8K5/yVLAYFbPw1j2eNNYuccRW4xx0+XmrhG0ZPy/VENXlFef6M0v tLNbaxJECzOWQfXH/wBlWMttdGSUpE23LLgPj1HX6irfliPwzfSnhjKTn05WqEGp3CQoEKshOCW7 DvWM4pJFO3M2dVZoY7WMN97bk49azfBpA8KWmf8App/6G1akLDYoGeFA6H0rE8KsR4XsQpOcvwP9 9q6IfwJesfykYy/jR9H+aOhVt6r+dZviWYrorop5kYL7Yzk/yrSQkKAVxisXxLIBawrjJaT+lc8t jZnKhfKWSZFBMYGOONx6cewyfyqOISszSTEuxBYnuf8AJNTXMfnadNGhxh1z7jnj9DVCwe4Bk3Ll cbRk5IxWT0t2JWgkup3JdFMnyxJ5aDaBgDscDnr1PNPs5I55VhKSO7sASo7E/wA6qqI7pnkhdVAw RvOC2T2/z/XHSfD+xa+8UIJFQ29upml4+7jpn6n+Rqpq6LSTaR0XiSCKF9D8NpvC2qfaZthwQ+Dg 8e+fzqnC2sW9xcS2jRX8IfZ5b/I+0fLw3Q9O9Pv5vtHiPVdTDF1WJSufQqGx+AAFamkx+XpcO7Iy o+tb058i2v6mdSPPN629Cpb+JLF3EF35lhc4z5V0uz8ieDWqDl844x1qK7tre8iMVxCkseOVdc1i NoV1ZSB9HvXtoxljBITJGT6Y6j61ralPb3X96/z/ADM71I76r7mbuN5ftmoFiJkDB/mB/Csn+2r3 Txt1bT2RRgfabb54z7kdVH51rWV9aXsYktZ45V6nac4+vpUTozirtad+hcKsZOy3L6ytHGzFvlAJ NcdcTme6kmn4ZxuAPYZ4rotXuRBYOCcFxtGP1rjXlklZQz4QKfvdu9c830NGOudQigiKtLwg6A/0 9axP7WuZHJj2ICcj5QxH5g1FdWt48kk8sLAEk5HTHtRY2M95IscS4LMFDNwCT0oUbENsvwatLkC5 VZYicsuMEfTFWZAH8t0K7Tyqt2Hrn/8AVWRdRvb3DKwITPBA4PFTWtwzRyjBYxgMregyMjn/ADxU zWgepoyyIZI2mi3BTuDMcHHs359c1HIGAUxy+cegSYgPnPY9/wBfpVN2ZXx5nB6rjIqGSQE4Pygn GCdy9fzH61CdyWTySOhJI2MoORIdpGPQ9KswK5+TawfPI5zn0NUo7i4iZFZVkiOBh/mH0B7fT36V oxsgYeXKIySSUl5Ayf73b17VVl0BMes+32dT0IpZJyzkv8yn86jDskm24j68/McZ49f8/WniBRhk O5ducf4HvUtNFIsxsgUAEjHTipUuJofmgl2nPT/61UTmMsijJ7ZpgkdWJB4+vSmM6eDW7lFXzIxg 8lk/qK1I9ctpEDMYs4/iIzXHQXwGMdvWnm4WRizghiew601NjudBHwBUxZthAHXvUMfQf4VZRC3G OxP5V2iIVUjpxmuclQtLJ7sf511ixKXX61hGBCxOTyamRUUZyxcjrW18Po8P4nuD1VXj/ID/AAqu sSxnP+RVvwOjJ4Y8R3C/M00zYx7tt/pQrezl8v6/Aav7WPz/AMv1Kt84TwpJno83/s3/ANasK0YT qFBz+8HboM1q6rPay+GPIgv7S4mhk3zJDKGZPnIOR9WA9+2azNEBkvrYFCR5gyKxq6SSM27s72Pa BgDFYnhBAfC1o+Of3g/8fatRdwYZB5rL8IY/4RS1yOz/APobV0w/gS9Y/lIiX8aPo/zRuBxyDjNc 54qcCKFVGWznH5VuMx2scck8VzniVDLNCAD8qbjz05ArmnsavYxkuQkrhzmORcdec9c4+o/nTI4t 2VibaHBJ/Kq1zLskAXgAZJJ4qKG5njZZk3YA7emcfhWSfRkpjxosxU+XyqjIB9B2rvfDVmuj+Cb6 /CJHPesIQ54IUdSf1rjLSW6lvVgikdJJNowADkHpn0rr/G9ylq2n6GjrstIQXOCfmI/z+dO9zWFk nIpjDaPKU3Bry5wu7rtLY/kK6OFPKgRO4AyBXOygpcaXZHH7sqzY9Rgf410RbBGPStTKI4g7M0xW JYLkcc0pOcUxTgmmUPPJx3rMu/D1hdTGaNHtbjoJ7ZvLb9OD+NacYyxY9qU/cZvQVUJyg7xdiZQj NWkrnG682taeiK80d/ArcHASQZB69jwK5uTUYNRikt8+RcHb8k3yk+1dh4o2pp8bM37zfuweOMEH +YrlwLa6tvLniWRV6ZHc/wAutROopSvJfd/lt+RHK46Rf3mZLNcRyGJ5XOw7fvGujtJGjt0kUsXE ZOe+SMf1rktUs5LN1+zSuCQcpIdy/T1FMtLsxzhb1JoWwCjr8yj39ulUoX1hqNVLfFodmxjkQI6K 6ehHWsi4Itl+zxjBI+Y4I/DPrVyzzdI0glSSIr8pXByfWr624LAyopXHBPXNZzi9jR6rQwXkbeB8 ygAnIP8AntVaSRQAUU+Zk49qvT26C9ZXcIG+ZQP5fpV21sbdrZlcKxJzu96yUSLXMlPMi4Rsbu+f 0NSmUFxnbv6FowAPy/wpbu3SFnVWGOoHc8dKrKdvO75s59qWwrGlFLOkZCkPHnnjIxxnjqPrxVmO WBz8u6EnJx1Qn6f5+tZ0LPy24javXPSrMMykEyIC5JAZeDn+R/zzTTGaHkuhAliyn8Lgkj8+tQSq SuQCoAGScHr05H0NTW7T7m8rc+3qoX5h6ZX/APXUiurYLo8bcncvQ/UdfWmVcqC1dYllViyO2Pm4 x+venM8QVN8RJK9QpNagnEbErbq9uUCkKQRwByRg+/HGN3emW1pZzwhpLpIWGAVd2GeByPl6UWK0 exvRGMgbWBNWkmZUKArg+qgn8+o6VzeyZ5EBRhzyQeMfWtCOSZCAHBH+1XZexNzTBwQaxO1XzebY 2LoeATwawP7UhUgFZOfYf41EpIuLRoFgASTwBV/wLOLX4eveOu7NyCR64fOP1rmbrW7ZbWf/AFgY I3b2rf0m4itfhNaSEkJJOvOD6f40+ZeyfqvyYR1qXXRP80Q65DeyaJBNdXM0q3MgzE6ssaEAFCoJ ODtDknOWL5PQYy9Ft3j1OLYnCnPrkYq/qhxa3wV8g6ipdd68NhwSFCKVB2jGWftyOcnh/JvJMNnC ZqK3xoyjY30Zg4INZHhL/kVLXPq3/oZraVTuGRisPwl/yKdtx0Zz/wCPGuiH8CXrH8pES/jR9H+a NV5FVRlgNxxz61zGszu16ybflZQOmfeumZQUXuM81ymrE/b5TzjPXPHQVyz2NmYrQx3F06svTgrn GR7elWD8tu7Qg4GTnjOACMCkjl8xmU4QA8jHX86ls40bcwziTOQeRj6f561mQza8D2K3XiOyIiAK HzZCe+Bwf5VDqNwdU8X3DjJWW4P/AHyD0/IfpW/4QVLW11XU0f5ILbZET1DHOOfyrB0a3d7975g7 RqhDSY4DdMfkDTWrNJaQSL1pi48Szux3JBGAuOx4/wDr1v5yawvDuZI7i6IOZpCc+nPStxeua1RK 2A9/YU0DCk96ccY+ppoyxAGeaBkgGI8etEjBYTu4z3p3cVma/MkdoqlS7bgVQHG5gDjn64pNjOU8 V30N3MI40UvCDmQnHHcfoPfj3qvaW7LYZVkVWwoIPzP0P16Vn3hDscAZY54HHWr+mOYnMU21kBwA xyA4GAf6Vje5Cd2E+nW8q7ZclRnA6fyqCyslt9e2MxaP7LkBvTcOK13kRi7IVYDrg1SaVf8AhIgc Aj7Hx/33XRSW/oKelvUZfaRbRkT2oe2k4G6A7ePcdDUc19qtkq+bCt7GCRviG1wPp/hW1LF5sS5y DkHKmopY0ZQhJK857Yp+1la0tQ9klrHQyopLHUmykpS5AwYn+Vh3/OrpjW3iQEn5Qcj19zill060 uIis8QlwM7jwR9COaoS2l3aOPsd2Zo8f6q55/JutPkpy+F29f8ybyjur+n+RK1sk9wJWb5D0Wny6 faklUGxyvy5Jxmsy31oR3pivIJLfDfeblR9Grf8AJS6SOWF9ylQQQeo9M1k6bW6KjKMtjCkDW5CO MEYY/SrVnF58yw4wMZJHRfrVjULMtbhl2hl6HPaodIlX7X9592zkADHUZzmsXGzGtGdRpujqFb92 djEFVKbmxnrg5xnjnqOOlaxiEtsIjIZODjec847ehPqPWmQRGRYo/u7sKAeg+tWXZZ7gbM/uxsUg Y4H/ANfmt1Bctyupy17pxtGWSAugzt2dCo56noeg+uRxVf7SysyzQAuDyShya09eby40hJJy24+h H/68Vk2M0sELLI8iEsWCqTwPyrK2oWRvfarTHEqn86Rri3yMSx8jP3sUUVamxWHSmNYZP3sRJQ4w 4OePrXNvbhh+GcDrRRUTdwM/U7dI9NuZMn/VMBn3Fdy1qY/hpoduoQZDSMHcIuFBySSQAMUUVrCK cF6/5Ch8UvT/ADMu/mgktpIINWa/G6KU7phMsZxIMbg7DPUkALgFKuaBYtbxCZguZBkEE9PeiinV /iCgbfLSA4rm/CjEeGLTk4Lvx/wI0UVvD+BL1X5SJl/Gj6P9DbzgLg1xusy7r6UqPuls/SiiuWex q9jFWTMwlAZUztbFXI5yybmUc4UFeCR/gaKKzRKO1VZLT4ancxWa/uPvHk7Qc/0qsjTW9qLu3jmj t7SIqJjePtkOGZT5aMVxkDdvC5LAAepRW1F2bKrdCxo8Xk6ZABjBXJwc8mtEDrRRTQA3AAHUCli6 8iiigCZDlie1cnrt0st66BwAgKcH+Lr+ny0UVE9gexx90oaYKOADWk2CqyFsPtCsE69MZ/l+tFFY maLltaRlD/e/iJPXmqzxsviQBSAfsfY/7dFFdNLZ+gVOnqXxPM0qow+RcZYcZ/I1akiZ9w+U55xR RUI1RTjkZEZZEzsJ5A6ioo5ozIFjGUJJ547UUUwLBghKNvCBWGCCuf8APWqE2lRWsJls55bN2yzb CTGR7r3/AAooqozlHZkShGW6M2HUb6KDfcWpkiH8cJzwD3Tt0qvb6jDPcPLA6vIxJK/U8jBoopzi pQ5+pjzOM1E7Cx8UQLDEJhJGy9Sfmz06e9aQ8SWHlmXzlUkY2+v4UUVhzs3uc/eakNQlLFSsajEY 9B6/yqruYE7JpVBOcBhRRWd3uB//2Q==