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> CalculateField "Address Features\ACESRIDB.GIS.Addresses" SUFFIX "Hwy" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "Address Features\ACESRIDB.GIS.Addresses" ADDRESS !ADDRESS!+" Hwy" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "Address Features\ACESRIDB.GIS.Addresses" ROADNAME !ROADNAME!+" Hwy" "Python 3" # Text NO_ENFORCE_DOMAINS Append AC_Pro.DBO.Addresses ACESRIDB.GIS.Addresses "Use the field map to reconcile field differences" "ADDRESS "Complete Address" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS,0,50;CITY "Postal City" true true false 30 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,CITY,0,30;ZIP "Zip Code" true true false 5 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ZIP,0,5;PROBLEM "PROBLEM" true true false 20 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PROBLEM,0,20;NOTES "NOTES" true true false 250 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NOTES,0,250;NUMBER "NUMBER" true true false 5 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER,0,5;NUMBERSUP "Post Number Supplement" true true false 4 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP,0,4;PREDIR "Directional Prefix" true true false 8 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIR,0,8;NAME "Street Name" true true false 40 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME,0,40;SUFFIX "Road Type Suffix" true true false 12 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX,0,12;POSTDIR "Post RdTypeSuffix Direction" true true false 8 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIR,0,8;SUPPLEM "Suffix Supplement" true true false 30 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEM,0,30;ADDRESS1 "ADDRESS1" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS1,0,50;NUMBER1 "NUMBER1" true true false 5 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER1,0,5;NUMBERSUP1 "NUMBERSUP1" true true false 4 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP1,0,4;PREDIR1 "PREDIR1" true true false 2 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIR1,0,2;NAME1 "NAME1" true true false 40 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME1,0,40;SUFFIX1 "SUFFIX1" true true false 8 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX1,0,8;POSTDIR1 "POSTDIR1" true true false 2 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIR1,0,2;SUPPLEM1 "SUPPLEM1" true true false 30 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEM1,0,30;ADDRESS2 "ADDRESS2" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS2,0,50;NUMBER2 "NUMBER2" true true false 5 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER2,0,5;NUMBERSUP2 "NUMBERSUP2" true true false 4 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP2,0,4;PREDIR2 "PREDIR2" true true false 2 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIR2,0,2;NAME2 "NAME2" true true false 40 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME2,0,40;SUFFIX2 "SUFFIX2" true true false 8 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX2,0,8;POSTDIR2 "POSTDIR2" true true false 2 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIR2,0,2;SUPPLEM2 "SUPPLEM2" true true false 30 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEM2,0,30;PARETIRED "PARETIRED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PARETIRED,-1,-1;A1RETIRED "A1RETIRED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,A1RETIRED,-1,-1;A2RETIRED "A2RETIRED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,A2RETIRED,-1,-1;UNOCCUPIED "UNOCCUPIED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,UNOCCUPIED,-1,-1;VERIFIED "VERIFIED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,VERIFIED,-1,-1;SOURCE "SOURCE" true true false 20 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SOURCE,0,20;BUSNAME "BUSNAME" true true false 80 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,BUSNAME,0,80;BUSSOURCE "BUSSOURCE" true true false 40 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,BUSSOURCE,0,40;LATITUDE "LATITUDE" true true false 8 Double 8 38,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 8 38,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,LONGITUDE,-1,-1;COUNTY "COUNTY" true true false 20 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,COUNTY,0,20;MUNI "Local Jurisdiction" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,MUNI,0,50;MCD_DIV "MCD_DIV" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,MCD_DIV,0,50;NHBRHD "Assessment Neighborhood" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NHBRHD,0,50;TAX_PIN "TAX_PIN" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,TAX_PIN,0,50;Site_ID "SITE_ID" true true false 4 Long 0 10,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,Site_ID,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,GlobalID,-1,-1;ROADNAME "ROADNAME" true true false 75 Text 0 0,First,#,C:\Users\ebuettner\AppData\Roaming\Esri\ArcGISPro\Favorites\Juniper.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ROADNAME,0,75;Field "Field" true true false 4 Long 0 10,First,#" # # # NOT_UPDATE_GEOMETRY CalculateField "Address Features\ACESRIDB.GIS.Addresses" SUFFIX "Hwy" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "Address Features\ACESRIDB.GIS.Addresses" ADDRESS "!ADDRESS! + " Hwy"" "Python 3" # Text NO_ENFORCE_DOMAINS Append AC_Pro.DBO.Addresses ACESRIDB.GIS.Addresses "Use the field map to reconcile field differences" "ADDRESS "Complete Address" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS,0,50;CITY "Postal City" true true false 30 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,CITY,0,30;ZIP "Zip Code" true true false 5 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ZIP,0,5;PROBLEM "PROBLEM" true true false 20 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PROBLEM,0,20;NOTES "NOTES" true true false 250 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NOTES,0,250;NUMBER "NUMBER" true true false 5 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER,0,5;NUMBERSUP "Post Number Supplement" true true false 4 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP,0,4;PREDIR "Directional Prefix" true true false 8 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIR,0,8;NAME "Street Name" true true false 40 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME,0,40;SUFFIX "Road Type Suffix" true true false 12 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX,0,12;POSTDIR "Post RdTypeSuffix Direction" true true false 8 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIR,0,8;SUPPLEM "Suffix Supplement" true true false 30 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEM,0,30;ADDRESS1 "ADDRESS1" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS1,0,50;NUMBER1 "NUMBER1" true true false 5 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER1,0,5;NUMBERSUP1 "NUMBERSUP1" true true false 4 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP1,0,4;PREDIR1 "PREDIR1" true true false 2 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIR1,0,2;NAME1 "NAME1" true true false 40 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME1,0,40;SUFFIX1 "SUFFIX1" true true false 8 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX1,0,8;POSTDIR1 "POSTDIR1" true true false 2 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIR1,0,2;SUPPLEM1 "SUPPLEM1" true true false 30 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEM1,0,30;ADDRESS2 "ADDRESS2" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS2,0,50;NUMBER2 "NUMBER2" true true false 5 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER2,0,5;NUMBERSUP2 "NUMBERSUP2" true true false 4 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP2,0,4;PREDIR2 "PREDIR2" true true false 2 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIR2,0,2;NAME2 "NAME2" true true false 40 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME2,0,40;SUFFIX2 "SUFFIX2" true true false 8 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX2,0,8;POSTDIR2 "POSTDIR2" true true false 2 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIR2,0,2;SUPPLEM2 "SUPPLEM2" true true false 30 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEM2,0,30;PARETIRED "PARETIRED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PARETIRED,-1,-1;A1RETIRED "A1RETIRED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,A1RETIRED,-1,-1;A2RETIRED "A2RETIRED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,A2RETIRED,-1,-1;UNOCCUPIED "UNOCCUPIED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,UNOCCUPIED,-1,-1;VERIFIED "VERIFIED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,VERIFIED,-1,-1;SOURCE "SOURCE" true true false 20 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SOURCE,0,20;BUSNAME "BUSNAME" true true false 80 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,BUSNAME,0,80;BUSSOURCE "BUSSOURCE" true true false 40 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,BUSSOURCE,0,40;LATITUDE "LATITUDE" true true false 8 Double 8 38,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 8 38,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,LONGITUDE,-1,-1;COUNTY "COUNTY" true true false 20 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,COUNTY,0,20;MUNI "Local Jurisdiction" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,MUNI,0,50;MCD_DIV "MCD_DIV" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,MCD_DIV,0,50;NHBRHD "Assessment Neighborhood" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NHBRHD,0,50;TAX_PIN "TAX_PIN" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,TAX_PIN,0,50;Site_ID "SITE_ID" true true false 4 Long 0 10,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,Site_ID,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,GlobalID,-1,-1;ROADNAME "ROADNAME" true true false 75 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp1400\a97004c588c506ab623336ffd3ef2f9e.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ROADNAME,0,75;Field "Field" true true false 4 Long 0 10,First,#" # # # NOT_UPDATE_GEOMETRY Append AC_Pro.DBO.Addresses ACESRIDB.GIS.Addresses "Use the field map to reconcile field differences" "ADDRESS "Complete Address" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS,0,50;CITY "Postal City" true true false 30 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,CITY,0,30;ZIP "Zip Code" true true false 5 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ZIP,0,5;PROBLEM "PROBLEM" true true false 20 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PROBLEM,0,20;NOTES "NOTES" true true false 250 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NOTES,0,250;NUMBER "NUMBER" true true false 5 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER,0,5;NUMBERSUP "Post Number Supplement" true true false 4 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP,0,4;PREDIR "Directional Prefix" true true false 8 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIR,0,8;NAME "Street Name" true true false 40 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME,0,40;SUFFIX "Road Type Suffix" true true false 12 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX,0,12;POSTDIR "Post RdTypeSuffix Direction" true true false 8 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIR,0,8;SUPPLEM "Suffix Supplement" true true false 30 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEM,0,30;ADDRESS1 "ADDRESS1" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS1,0,50;NUMBER1 "NUMBER1" true true false 5 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER1,0,5;NUMBERSUP1 "NUMBERSUP1" true true false 4 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP1,0,4;PREDIR1 "PREDIR1" true true false 2 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIR1,0,2;NAME1 "NAME1" true true false 40 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME1,0,40;SUFFIX1 "SUFFIX1" true true false 8 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX1,0,8;POSTDIR1 "POSTDIR1" true true false 2 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIR1,0,2;SUPPLEM1 "SUPPLEM1" true true false 30 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEM1,0,30;ADDRESS2 "ADDRESS2" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ADDRESS2,0,50;NUMBER2 "NUMBER2" true true false 5 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBER2,0,5;NUMBERSUP2 "NUMBERSUP2" true true false 4 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NUMBERSUP2,0,4;PREDIR2 "PREDIR2" true true false 2 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PREDIR2,0,2;NAME2 "NAME2" true true false 40 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NAME2,0,40;SUFFIX2 "SUFFIX2" true true false 8 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUFFIX2,0,8;POSTDIR2 "POSTDIR2" true true false 2 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,POSTDIR2,0,2;SUPPLEM2 "SUPPLEM2" true true false 30 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SUPPLEM2,0,30;PARETIRED "PARETIRED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,PARETIRED,-1,-1;A1RETIRED "A1RETIRED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,A1RETIRED,-1,-1;A2RETIRED "A2RETIRED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,A2RETIRED,-1,-1;UNOCCUPIED "UNOCCUPIED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,UNOCCUPIED,-1,-1;VERIFIED "VERIFIED" true true false 2 Short 0 5,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,VERIFIED,-1,-1;SOURCE "SOURCE" true true false 20 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,SOURCE,0,20;BUSNAME "BUSNAME" true true false 80 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,BUSNAME,0,80;BUSSOURCE "BUSSOURCE" true true false 40 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,BUSSOURCE,0,40;LATITUDE "LATITUDE" true true false 8 Double 8 38,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 8 38,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,LONGITUDE,-1,-1;COUNTY "COUNTY" true true false 20 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,COUNTY,0,20;MUNI "Local Jurisdiction" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,MUNI,0,50;MCD_DIV "MCD_DIV" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,MCD_DIV,0,50;NHBRHD "Assessment Neighborhood" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,NHBRHD,0,50;TAX_PIN "TAX_PIN" true true false 50 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,TAX_PIN,0,50;Site_ID "SITE_ID" true true false 4 Long 0 10,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,Site_ID,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,GlobalID,-1,-1;ROADNAME "ROADNAME" true true false 75 Text 0 0,First,#,C:\Users\ebuettner\AppData\Local\Temp\ArcGISProTemp12608\03f176473496c0c3e36dce6dabdeba71.sde\AC_Pro.DBO.Addresses\AC_Pro.DBO.Addresses,ROADNAME,0,75;Field "Field" true true false 4 Long 0 10,First,#" # # # NOT_UPDATE_GEOMETRY 20230418 13521900 20230418 13521900 150000000 5000 FGDC Version 6.2 (Build 9200) ; Esri ArcGIS 10.5.0.6491 Addresses_20241216 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/9oADAMBAAIRAxEAPwD1Sio2 kcKSImJ9MiooLiSVWLRkEHGB2rp5lsY+3gWaKiklZELCJmI7CmwTtLEHKHJPajmV7B7eBPRUM05i jLeU5pYpjJGjFD8w7dKOZXsHt6fcloqvPdeTGG8pzkdxwPrUglyoJRuQego5lsHt6fceSB1IFG9f 7w/OpLHyHubt54kZYoFYebwo5Penx3lk80cTaUiM5XOf4clRzx1y3Ss5yT0aHOMasLdCHOelFMcp Fc3EaqQqysAAOBzUEd6slxJEEcbBkkj+lacyG60E7XLVFMMqj+91x901DBepOZNqsFQ4yR1NHMhe 2p9yzRUZmRQSSeM9jUdvdx3CllyBuKjPejmV7B7an3LFFRNcRIm8txjPSmw3Uc0SyA4DZxn2o5ls P21PuT0VDLdQwxl3fgeg5pUuI3jD5wCM4NHMtg9tT7ktFQTXcMCku/Q4wOTmpBKhAO4c47+tPmQe 1h3H0VBLeQQ43OCWOABzTnZWaKMPjfNHGcHnBYA/oaXMhqpB9SWirE8WlWryLPNdp5fLkseB61Dd RQW8kLQyS7HDhhI2cFTg/qDUqom7FNpasbRURuYhMId4Mh7CpN6/3h+dXdE+0h3FoqIXETTGJXBd RkgHpUm4eoouh88e4tFRpPFI7Kjhiv3sHpT8j1oug549xaKZHLHLu2OGCnBI9adkAZJouHPHuLRT UkSQZRgRnGRSkgDJIA9TRcOaO9xaKajq6hlOQehp1A7oKKKKYwooooAKAMdKKKAAjIwaAMDAoooA IpJYJneMRsJECMsgyMAn/GrA1G6XAWK2AByMJ0qvRxWVSyV7GNebhC67oQbizu5BZ2LHHTmjaN27 AzjGaWitLG1gpAqhiwABPU0tFMVkFNVFTO1QMnJxTqKQWQEZGD0pqIsa7UAA9BTqKA5V2EZVdSrA EHqDSIiogRRhR0FOooDlXYZJGkq7XUMPQinAADFLRRYXLHsRyQxygB0BwcjjpSuCDG6qCUlSTHTO 1gf6U+iiyDkj2JnntJC5fTS28ktumJyT1qO4lFw8QW38qNA3Bfdkk5NNoqVBLUpq+5EbeIyiXYN4 7gU/Yn91fTpTqKqyI9nDsQi2hWYyhAGYYPvUnlof4F/KnUUWQezh2IY7SGN3ZEA39R2p5ijPVB+V Poosg9lDsQxWsUIYIvBbdg+tOaCJlKlBgjFSUUcq2F7KHYhhtYoIwijgE4z2oktYZYzGyfKRipqK XKrWD2UOxFHbpHEsfUAYp4RRnA606inZC9jT/lQUUUUzUKKKKACiiigAooooAKKKKio7La5z4l2h ouq/MKKKKs6AooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigA ooooAKKo/aJP736UfaJP736Vl7WJh7eJeoqj9ok/vfpR9ok/vfpR7WIe3iXqKo/aJP736UfaJP73 6Ue1iHt4l6iqP2iX+9+lH2iX+9+lHtYh7eJauCVtpWU4IQkH8KvT2NpBex25F2xcgbhJ6+nHOO9Y c88hgkBbjac1u3ktjPqMVyl9p5CMpJaZc8HnHpx71Ep32LjOM0VZIhBd3EKszLG+FLHJxtB/rSVX vbsSandvBKjxmQYZCCD8q96h+0S/3v0qlVSWpLrRTsXqKo/aJf736UfaJf71P20Re3iXqKo/aJf7 1H2iX+9R7aIe3iXqKo/aJf71H2iX+9R7aIe3iXqKo/aJf71J58v96j20Q9vEv0VQ8+X++aPOk/vm l7ZB9Yj2L9FZ/nSf3zR5sn98/nR7ZB9YXY0KKzvMf++350eY/wDfb86PbLsL6wuxo0Vnb2/vH86T c394/nR7byD6wuxpUVm5PqaTJ9aXtvIX1jyNOjI9azKKPbeQfWPI0tw9RRuX+8PzrNoo9t5B9Y8j R3p/eX86PMT++v51nUUvbPsL6w+xoebH/fX86PNj/vr+dZ9FHtn2D6w+wUUUVic4UUUUAFFFFABR RRQAVIi/uXOB+VR1PHKVgZcLik79DOreyt3RBRRRTNAooooAKKKKACiiigAooooAKKKKACiiigAo oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACpVU+Q55xmoqmSRhAwB 4+lJ36GVW9lbuiGiiimahRRRQAUUUUAFFHABYkBQMknsKcy7QCTgEZ+YFD1x0bB6g1Si3qkUoSau kNopGZI4/MkcKhZVDBS2SzBVA2gnkkD8aImSc/unDLkLuPAyRnvT5JWvYr2U2r20FooBBAKsCCoY euCMjjqOCOtFS01uQ007MKKKKQgooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAo oooAKKKKACplRjbu2DjNQ1MrsIGwTjOKTv0Mquy9UQ0UUUzUKKKKACiiigB0cYmJiIDBxtwTjP41 SmawmhW4uridPOCvmSUsQMh1/hIHKE446HtzVxWKsGHUU0RxBVUQRbVXYAVz8vIxz7Ej6Ejoa3pV FBWd/kddCvGnFp3+RFs07yFthJvjeSJxySGKyIEGduMb1UfU0GTT7hwwmmVCUuFMchEbFPnGAF7e XnB9DUxWIhB5EQCY2hV2gYYOOB/tAH6imeTB/wA+8f4ZHYj164ZvzrRVoLq/wNo4mmru8vwI7e3s ITHHbPI7QIsahmPAEagdVGflK/nU9NWGKJ5XjXBkYHnnaAqrge2FFOrGrJSldO5y4iopzum36hRR RWRgFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAVOsZNszY75quz BRliAPeniZfJI39/Wk79DOom0rdxtFIrBhlSCPalpmgUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAU UUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFADov+Pu0/wCvmH/0YtdI 11MNfWDzD5Z/gyOmD2znHviuZDFJIpAMmOVJMZ67WBx+lap1hGnF0bKTzFbI/wBIOM4x06d6pHRS qRjH3mZ91/x/3X/XZ/51FSvIZppZWXaZHZ9uc4yaSkYyd5MKKKKRIUUUUAFFFFABRRRQAUUUUAFF FFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFWAq/ZT8/Oc4qv Un/LA/X0pNN7GVVbepHRRRTNQooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooo oAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACp8R/ZfvfN1qCpP8Al3/4FSav1Mqq29SOiiim ahRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUA FFFFABRRRQAUUUUAFT5j+y4wc56+9QVJ/wAsP+BetJq5lVW3qR0UUUzUKKKKACiiigAooooAKKKK ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAqwXX7 Lt29+vvRRSauZVV8PqV6KKKZqFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFF FABRRRQAUUUUAFFFFAH/2Q==