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 #
GISData.DBO.Parcels_Online
002
Server=GIS2SQL; Service=sde:sqlserver:GIS2SQL; Database=GISData; 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["NAD_1983_HARN_StatePlane_Ohio_North_FIPS_3401_Feet",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1968500.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-82.5],PARAMETER["Standard_Parallel_1",40.43333333333333],PARAMETER["Standard_Parallel_2",41.7],PARAMETER["Latitude_Of_Origin",39.66666666666666],UNIT["Foot_US",0.3048006096012192]],VERTCS["NAVD_1988",VDATUM["North_American_Vertical_Datum_1988"],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Meter",1.0]]</WKT><XOrigin>-118963900</XOrigin><YOrigin>-96373800</YOrigin><XYScale>3048.0060960121914</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333335</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>3753</WKID><LatestWKID>3753</LatestWKID><VCSWKID>5703</VCSWKID><LatestVCSWKID>5703</LatestVCSWKID></ProjectedCoordinateSystem>
20211119
06260900
20211119
06260900
Version 6.2 (Build 9200) ; Esri ArcGIS 10.7.1.11595
Parcels_Labels
ashtabula county
for pictometry
SDE Feature Class
dataset
EPSG
8.9.3(9.3.0.0)
0
Simple
FALSE
0
TRUE
FALSE
GISData.DBO.Parcels_Online
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Joined
Joined
Integer
4
10
0
PlanID
Plan ID
Integer
4
10
0
Name
Parcel Identification Number
String
50
0
0
Type
Parcel Type
Integer
4
10
0
StatedArea
Stated Area
String
50
0
0
Compiled
Compiled From Records
Integer
4
10
0
Historical
Historical
Integer
4
10
0
SystemStartDate
System Start Date
Date
8
0
0
SystemEndDate
System End Date
Date
8
0
0
LegalStartDate
Legal Start Date
Date
8
0
0
LegalEndDate
Legal End Date
Date
8
0
0
GroupID
GroupID
Integer
4
10
0
Accuracy
Accuracy
Integer
4
10
0
Rotation
Rotation
Double
8
38
8
Scale
Scale
Double
8
38
8
Unclosed
Unclosed
Integer
4
10
0
MiscloseRatio
Misclose Ratio
Double
8
38
8
MiscloseDistance
Misclose Distance
Double
8
38
8
MiscloseBearing
MiscloseBearing
Double
8
38
8
Construction
Construction
Integer
4
10
0
ShapeStdErrorE
ShapeStdErrorE
Double
8
38
8
ShapeStdErrorN
ShapeStdErrorN
Double
8
38
8
BacksightBearing
BacksightBearing
Double
8
38
8
ConstructionData
ConstructionData
Blob
0
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
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
20211119
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACjrRRQBSfR9NluGuHsoGmYbWcoMkVNb2VtaxeVBBHHH/AHVX
AqeigCmNJ08RSxCzhEcvLrsGG+tVX8L6G+N2l2pwMD5O1a1FAFV9NspbZbZ7WJoU+6hUYFIdLsDM
kxtIfMj4VtgyKt0UAV7mwtLzb9ptopdpyN65xVFvC+hu5dtKtSxOSdla1FAGfZ6HpenymS0sYIXI
wWRcHFTDTbESSOLSHfIMOdg+YVaooAgtbO2sovLtoEiTrtQYqeiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigD//2Q==