20140619 09415400 1.0 FALSE CalculateField Encumbrances Encumbrance [Name] VB # CalculateField Encumbrances Encumbrance [Name] VB # CalculateField Encumbrances Encumbrance [Name] VB # CopyFeatures "GISData.DBO.newParcels\Tax Parcels" "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" # 0 0 0 DeleteField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Joined;PlanID;Compiled;LegalStartDate;LegalEndDate;GroupID;Accuracy;Rotation;Scale;Unclosed;MiscloseRatio;MiscloseDistance;MiscloseBearing;Construction;ShapeStdErrorE;ShapeStdErrorN;BacksightBearing;ConstructionData AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" PIN_NO_DASHES TEXT # # 20 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Acreage DOUBLE 18 3 # # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Calculated_Acreage DOUBLE 18 3 # # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Location_Address TEXT # # 75 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Owner_Name TEXT # # 250 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Owner_Address TEXT # # 100 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Owner_City TEXT # # 50 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Tax_Name TEXT # # 250 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Tax_Address TEXT # # 100 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Tax_City TEXT # # 50 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Landuse_Code TEXT # # 5 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Landuse_Class TEXT # # 5 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Neighborhood_Code TEXT # # 10 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Book_Page TEXT # # 20 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Auditor_Link TEXT # # 150 # NULLABLE NON_REQUIRED # CalculateField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" PIN_NO_DASHES "Left([PIN],2) & Mid([PIN],4,3) & Mid([PIN],8,2) & Mid([PIN],11,3) & Right([PIN],2)" VB # CopyFeatures "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.Parcel\GIS_WEB.DBO.Parcel_Online" # 0 0 0 CopyFeatures "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.Parcel\GIS_WEB.DBO.Parcel_Online" "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\GIS_WEB.DBO.forfeitedRefresh" # 0 0 0 AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" CASENO TEXT # # 15 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" CASESTAT TEXT # # 1 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" ENTRYDATE TEXT # # 20 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" OWN1 TEXT # # 40 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" OWN2 TEXT # # 40 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" ADDR1 TEXT # # 40 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" ADDR2 TEXT # # 40 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" ADDR3 TEXT # # 40 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" NOTE1 TEXT # # 40 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" NOTE2 TEXT # # 40 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" ADVATE1 TEXT # # 19 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" ADVATE2 TEXT # # 19 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" SALEOFFER TEXT # # 19 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" ADVFLAG TEXT # # 1 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" BUY1 TEXT # # 40 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" BUY2 TEXT # # 40 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" DELQTAX TEXT # # 16 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" COURTCOST TEXT # # 16 # NULLABLE NON_REQUIRED # AddField "Database Connections\Connection.to.gis_web.sde\GIS_WEB.DBO.iasRefresh\forfeitedRefresh" PAYDATE TEXT # # 19 # NULLABLE NON_REQUIRED # GIS_WEB.DBO.forfeitedRefresh 002 Server=gis2sql; Service=sde:sqlserver:gis2sql; Database=GIS_WEB; Version=dbo.DEFAULT ArcSDE Connection Projected GCS_North_American_1983_HARN Linear Unit: Foot_US (0.304801) NAD_1983_HARN_StatePlane_Ohio_North_FIPS_3401_Feet <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.7'><WKT>PROJCS[&quot;NAD_1983_HARN_StatePlane_Ohio_North_FIPS_3401_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983_HARN&quot;,DATUM[&quot;D_North_American_1983_HARN&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;,1968500.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-82.5],PARAMETER[&quot;Standard_Parallel_1&quot;,40.43333333333333],PARAMETER[&quot;Standard_Parallel_2&quot;,41.7],PARAMETER[&quot;Latitude_Of_Origin&quot;,39.66666666666666],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,3753]]</WKT><XOrigin>-118963900</XOrigin><YOrigin>-96373800</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>2</MTolerance><HighPrecision>true</HighPrecision><WKID>3753</WKID><LatestWKID>3753</LatestWKID></ProjectedCoordinateSystem> 20210305 10502600 20210305 10502600 Version 6.2 (Build 9200) ; Esri ArcGIS 10.7.1.11595 Forfeited Parcels forfeited All current records from the forfeited land transaction. SDE Feature Class dataset EPSG 8.9.3(9.3.0.0) 0 Simple FALSE 0 TRUE FALSE GIS_WEB.DBO.forfeitedRefresh Feature Class 0 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Name Parcel Identification Number String 50 0 0 Type Parcel Type Integer 4 10 0 StatedArea Stated Area String 50 0 0 Historical Historical Integer 4 10 0 SystemStartDate System Start Date Date 8 0 0 SystemEndDate System End Date Date 8 0 0 PIN PIN String 30 0 0 ConveyanceType Sub or Condo Type String 50 0 0 ConveyanceDesignator Sub or Condo Number String 10 0 0 SimConDivType Lot or Unit Type String 50 0 0 BlockDesignator Block Number String 10 0 0 EncumbranceType Encumbrance Type String 50 0 0 SeparatedRightType Separated Right Type String 50 0 0 HistoryType Reason Parcel Retired String 50 0 0 FloorDesignator Floor Number SmallInteger 2 5 0 PrincipalMeridian Principal Meridian String 40 0 0 TownshipNumber Township Number String 3 0 0 TownshipFraction Township Fraction String 1 0 0 TownshipDirection Township Direction String 1 0 0 RangeNumber Range Number String 3 0 0 RangeFraction Range Fraction String 1 0 0 RangeDirection Range Direction String 1 0 0 TownshipDupCode Duplicate Township String 1 0 0 PLSSID PLSS Identification Number String 16 0 0 FirstDivisionType Section Type String 50 0 0 FirstDivisionDupCode Duplicate Section String 1 0 0 SecondDivisionNumber Quarter Section Number String 50 0 0 SecondDivisionSuffix Quarter Section Suffix String 10 0 0 SecondDivisionType Quarter Section Type String 50 0 0 SpecialSurveyNumber Special Survey Number String 5 0 0 SpecialSurveySuffix Special Survey Suffix String 5 0 0 SpecialSurveyType Special Survey Type String 50 0 0 SpecialSurveyNotes Special Survey Notes String 50 0 0 CreatedBy Created By String 50 0 0 ModifiedBy Modified By String 50 0 0 ModifyDate Modification Date Date 8 0 0 Encumbrance Encumbrance String 50 0 0 Name_Encumbrance Other String 50 0 0 jur jur String 50 0 0 Grantor Grantor String 50 0 0 Granted_To Granted_To String 50 0 0 Use_of Use_of String 50 0 0 Vol___Page Vol___Page String 50 0 0 Date Date Date 8 0 0 Survey Survey String 75 0 0 Sublot_num Sublot_num SmallInteger 2 5 0 UNIT_NUM UNIT_NUM String 50 0 0 FLOOR_NUM FLOOR_NUM String 50 0 0 SUBLOT_NUMBER SUBLOT_NUMBER String 50 0 0 PLAT_VOL_PAGE PLAT_VOL_PAGE String 50 0 0 DECLAR_VOL_PAGE DECLAR_VOL_PAGE String 50 0 0 PIN_NO_DASHES PIN_NO_DASHES String 20 0 0 Acreage Acreage Double 8 38 8 Calculated_Acreage Calculated_Acreage Double 8 38 8 Location_Address Location_Address String 75 0 0 Owner_Name Owner_Name String 250 0 0 Owner_Address Owner_Address String 100 0 0 Owner_City Owner_City String 50 0 0 Tax_Name Tax_Name String 250 0 0 Tax_Address Tax_Address String 100 0 0 Tax_City Tax_City String 50 0 0 Landuse_Code Landuse_Code String 5 0 0 Landuse_Class Landuse_Class String 5 0 0 Neighborhood_Code Neighborhood_Code String 10 0 0 Book_Page Book_Page String 20 0 0 Auditor_Link Auditor_Link String 150 0 0 Shape Shape Geometry 4 0 0 Feature geometry. Esri Coordinates defining the features. Shape.STArea() Shape.STArea() Double 0 0 0 Shape.STLength() Shape.STLength() Double 0 0 0 20210305 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAoopryJEu6R1QerHFADqKa7iNGdvuqCTVbTtTtNVtjcWcvmRBihOMcj/wDXQBbprtsj ZgpYqCcDqaxvFV3PaaIzWzOsjuqZTrg+n5VU0Cy8QWt6Uv7hXs41KqCclu/HfqepPY0Pa4Lexo6d qz6lOGhiU2pT5mDDdFIOqsM/yoni1MeIbeSKXOnmMiRDjAP8/T8q0Y7eGKWWSONVeUhpGH8RAxz+ FSUAFNWRHZlV1YocMAc4PvVLUtQfTTDK0Be1JImkB5j9DjuKg2afpzz6yJ2WKZMsFOVY+oA6nj+d JsDWorH0HXl1z7U8cPlxxOAhJyWBGea2KE01dAFFFFMAooooAKKKKACiiigAooooAKKKKACiiigA ooooAKKKKACiiigAooooAKKKKACqeo6nBpkKSTpKwdtoEabj0zVtt207QC2OAfWqWnyam5k/tCC2 iAxs8mQvn1zkCgC3DKs0KSpna6hhuGDz7VW1HS7TVYUivIvMRG3AbiMHGO31q5UE13DbzwQyEh52 KoAOpAzQ9dwHxwxw26QIuIkUIqnngDGOazdA0c6LbXNuCnlyXLyxquflUngc98AVrUUABAPUdKKK KAEJwCcE49K5bVdavysN5p6v9lQ/vVKYKkHBDjsO9b+pXU1naGeCDzyrDcgPO3uR60WVjbW0cjQo 2LhjI+8kk5579OvSk77ICUyrcWTSQBZldCUBPD8cD8a56d2XwjssbDhDskgYk7eeSD1PPOa6C4tl ns5LZWaJXQoDHwV+lZ+nhdEtrayu7ne0rlYjg4HoM/41MrvQOhJoun21laCS3gkg89VZ4nPKnHp6 +tadFFWlYAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKjeGKV43dFZozuQkfdOMcVJRQAjttRmwTgZwOpqnpOoLqumxXixtGJCw2sc4wxX+lXaKAIJ7g wSQr5MkiyPtLIMhPc+1T0UUAFFFFAFWKa5kvp42hRbdAAr78szdenYYNWHjSTG9VbB3DIzg+tVIt Nig1KW9id0Mw/eRg/Kx/vfWrtJAFFFFMAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAC iiigAooooAKKKKACqWo3z2ESPHZz3JZsbYVyR9au0wTRNM0IkQyqAWQMMge4oAIXMsKSNG0ZZQSj YyvscU+iigAoopskiQxPLIwREBZmJwAB1NADqKjhmjuIUmibdG4yp9akoAKKKKACiiigAooooAKK KKACiisy41K5trh4zps8qg5R4RuBHv6HrxQBp0UUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFF FFABRRRQAUUUUAFUYtMWLWp9SEhLTRLGUx0weuavUUAFFFFABTJoUuIJIZV3RyKUYeoIwafRQBHb wR2tvHBEu2OMbVGc8VJRVaBro3d0s0aLArL5DA8sNozn8c0AWaKKKACiiigAooooAKKKQnAJwT7D vQAtFQ27zyRlp4RCSflTfuIHv2z9M/WpqACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo AKKKKACiiigAooooAKKow6VBBqMl8sk5lkBBVpCVGcdB+FXqACiiigAoqC5vbWzVWurmGAMcKZZA uT6DNTg5GR0oAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo AKKKKACiiigAooooAyfEX206URp/mef5i/6vrjNa1FFABRRRQAUUUUAZuq6Ha6u0bXDSqUVlHlvj IOM5/KtFVCqFHQDApaKVle4BRRRTAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo AKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiqVzq9jaXsVnPOEuJSoRMHnJwPzNXaAGTSiGB 5SrNsUnagyT9BUVldfbbVJ/Img3Z+SZNrDnuKsUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFF FABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA0xoZBIUUuBgNjkfjTqKK ACiiigAooooAKo2ur2V7cGC3m3uBn7pAI9j3q9XFzk6R4gkkUfu4ZvNxj/lk4+bH0JbH+6KxrVfZ 2fS9mJux2lFICGAIIIPIIpa2GFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFF FABRRRQAUUUUAFFFFABRRRQAVR1ae8t7BpLGJZZgR8rKW4+gIJq9RSeqAitpHmtYpZImid0DNG3V SR0qWiimAUUUUAFcv4kiC6nDJjiWEoffB/8ArmuorC8Tx/6JbT/885gpPswI/ntrmxcOehJeRM1e LLHh65NxpYRjl4HMTH6YI/QitWuV8PzeRqzxk/LcR/8Ajy/4gn8q6qnhavtaMZBF3VwoooroKCii igAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKK ACiiigAqhrVubrRruIDL+WWT/eX5l/UCr9IRuUg9xik1dWA4IXX2fyr5ORCRLj1XuPyzXegggEHI PSvP3gJt5bY8FS0f0wSBXcaddfbdPguMAF0BYDse4/PNeZlr5VOm+jMqfVFmiiivUNQooooAKKKK ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKq38F1cWpjs7oWspIPmGPfgfTIoooAsR q6xIrvvcKAzYxuPrinUUUAFFFFABWbBr1hcXKwRyPvdiqkoQCfrRRWNWo4yil1Ym7GlRRRWwwooo oAKKKKAOLv4/J1e9j/6aeYPowB/nmtXw1PmG5tCxDRvvX/db/wCuDRRXj0Xy46SXX/hzFfGzVsIr qG1Ed5Ms0oJ+cDGR2z/n8+tWSAQQehoor2DYr2VqLC0EAmkkVc4aU5IHpn2qwjrIiujBlYZDA5BH rRRQB//Z