20190401
09015700
1.0
FALSE
CalculateField Encumbrances Encumbrance [Name] VB #
CalculateField Encumbrances Encumbrance [Name] VB #
CalculateField Encumbrances Encumbrance [Name] VB #
CopyFeatures "Database Connections\Connection to GIS2SQL.sde\GISData.DBO.Parcel_Fabric\GISData.DBO.ParcelFabric_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 #
CalculateField "Database Connections\Connection.to.GIS2SQL.sde\GISData.DBO.OnlineLayers\GISData.DBO.Parcels_Online" Calculated_Acreage !shape.area@acres! PYTHON_9.3 #
FeatureToPoint Coverbridge P:\Data\park\Park.gdb\Park\Covered_Bridge INSIDE
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>GIS_WEB.DBO.Metroparks</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686f775777695262554e503575444a75547039664c7979724f745978567a4a754a35484e4e5555744f7071343d2a00;SERVER=gis2sql;INSTANCE=sde:sqlserver:gis2sql;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis2sql;DATABASE=GIS_WEB;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_WEB.DBO.Covered_Bridge</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>BRIDGE_NAME</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Covered Bridge Name</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>BRIDGE_LINK</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Link to Google Maps</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>BRIDGE_NOTE</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Notes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>BRIDGE_COORDINATES</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Coordinates</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>BRIDGE_ADDRESS</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Address</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/2.9.0'><FeatureDataset>GIS_WEB.DBO.Metroparks</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e686f775777695262554e503575444a75547039664c7979724f745978567a4a754a35484e4e5555744f7071343d2a00;SERVER=gis2sql;INSTANCE=sde:sqlserver:gis2sql;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gis2sql;DATABASE=GIS_WEB;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_WEB.DBO.Covered_Bridge</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>BRIDGE_VISITERS_BUREAU</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Visitors Bureau Link</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>BRIDGE_DESC</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Bridge Descriptions</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>BRIDGE_AMENITIES</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Amenties Near By</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
GIS_WEB.DBO.Covered_Bridge
002
Server=gis2sql; Service=sde:sqlserver:gis2sql; Database=GIS_WEB; User=sa; Version=dbo.DEFAULT
ArcSDE Connection
Projected
GCS_WGS_1984
Linear Unit: Meter (1.000000)
WGS_1984_Web_Mercator_Auxiliary_Sphere
<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["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem>
20200123
15364400
20200123
15364400
Version 6.2 (Build 9200) ; Esri ArcGIS 10.7.1.11595
Covered_Bridge_Edit_2022
Coverd Bridge Ashtabula County
Covered_Bridge
SDE Feature Class
dataset
EPSG
8.8(9.3.1.2)
0
Simple
FALSE
0
TRUE
TRUE
GIS_WEB.DBO.Covered_Bridge
Feature Class
0
OBJECTID_1
FID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
OBJECTID
OBJECTID
Integer
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Name
Name
String
50
0
0
Type
Type
Integer
4
10
0
StatedArea
StatedArea
String
50
0
0
Historical
Historical
Integer
4
10
0
PIN
PIN
String
30
0
0
SystemStar
SystemStar
Date
8
0
0
SystemEndD
SystemEndD
Date
8
0
0
PLSSID
PLSSID
String
16
0
0
Conveyance
Conveyance
String
50
0
0
Conveyan_1
Conveyan_1
String
10
0
0
SimConDivT
SimConDivT
String
50
0
0
BlockDesig
BlockDesig
String
10
0
0
Encumbranc
Encumbranc
String
50
0
0
SeparatedR
SeparatedR
String
50
0
0
HistoryTyp
HistoryTyp
String
50
0
0
FloorDesig
FloorDesig
Integer
4
10
0
PrincipalM
PrincipalM
String
40
0
0
TownshipNu
TownshipNu
String
3
0
0
TownshipFr
TownshipFr
String
1
0
0
TownshipDi
TownshipDi
String
1
0
0
RangeNumbe
RangeNumbe
String
3
0
0
RangeFract
RangeFract
String
1
0
0
RangeDirec
RangeDirec
String
1
0
0
TownshipDu
TownshipDu
String
1
0
0
CreatedBy
CreatedBy
String
50
0
0
FirstDivis
FirstDivis
String
50
0
0
FirstDiv_1
FirstDiv_1
String
1
0
0
SecondDivi
SecondDivi
String
50
0
0
SecondDi_1
SecondDi_1
String
10
0
0
SecondDi_2
SecondDi_2
String
50
0
0
SpecialSur
SpecialSur
String
5
0
0
SpecialS_1
SpecialS_1
String
5
0
0
SpecialS_2
SpecialS_2
String
50
0
0
SpecialS_3
SpecialS_3
String
50
0
0
ModifiedBy
ModifiedBy
String
50
0
0
ModifyDate
ModifyDate
Date
8
0
0
jur
jur
String
50
0
0
Encumbra_1
Encumbra_1
String
50
0
0
Name_Encum
Name_Encum
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
Integer
4
10
0
UNIT_NUM
UNIT_NUM
String
50
0
0
FLOOR_NUM
FLOOR_NUM
String
50
0
0
Shape
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
SUBLOT_N_1
SUBLOT_N_1
String
50
0
0
PLAT_VOL_P
PLAT_VOL_P
String
50
0
0
DECLAR_VOL
DECLAR_VOL
String
50
0
0
PIN_NO_DAS
PIN_NO_DAS
String
20
0
0
Acreage
Acreage
Double
8
38
8
Calculated
Calculated
Double
8
38
8
Location_A
Location_A
String
75
0
0
Owner_Name
Owner_Name
String
250
0
0
Owner_Addr
Owner_Addr
String
100
0
0
Owner_City
Owner_City
String
50
0
0
Tax_Name
Tax_Name
String
250
0
0
Tax_Addres
Tax_Addres
String
100
0
0
Tax_City
Tax_City
String
50
0
0
Landuse_Co
Landuse_Co
String
5
0
0
Landuse_Cl
Landuse_Cl
String
5
0
0
Neighborho
Neighborho
String
10
0
0
Book_Page
Book_Page
String
20
0
0
Auditor_Li
Auditor_Li
String
150
0
0
Shape_STAr
Shape_STAr
Double
8
38
8
Shape_STLe
Shape_STLe
Double
8
38
8
ORIG_FID
ORIG_FID
Integer
4
10
0
20200123
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAorMkj1Q+IIpEngGliEiSIr+8Mm
eCD6f/XrToAKKKKACmlVJBIBI6HHSnUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA
UUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAZ9ppi2mpXt6Lm4kN0VJikfKR4GPlHatCiigAooo
oAKKKKACiis0wal/bwnF3H/ZvkbTb7Pm8zP3t30xQBpUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAU
UUUAFFFFABRRRQAUUUUAFFFZ/wDatp/bX9lbn+1+T52Nh27c469M80AaFFFFABRRRQAUUUUAFFFF
ABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUA
FN2ru3YG7GM45xTqKACiiigAqtei5NlOLNo1ujG3lGQZUNjjPtmrNFAFWwF2thAL5o2u9g80xjCl
u+KtUUUAFFRvIsaM7sFRRlmJwAPWm21zBeW6T28qSwuMq6HINAE1FFVNRvotN0+e9mV2jhQuwjXc
xHsKALdFV7S5S7tIbmMMElQOodcHBGeR2qxQAUUUUAFZ15dXkN9ZRW1l58ErkTy7wPJGODjvmtGs
+91JbK9srY29xKbtygeNMrHgZyx7ChAaFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAU
UUUAFFFFABWZqV7e2k9klpp7XSTTbJnDAeSv94/57Vp0UAFV7uZ7azmmjheZ40LLEnVyB0FWKKAK
emXkt9ptvdTWslrJKm5oZPvJ9auUUUAFFFFAEUsMc8TxSorxupVlYZDA9QRTLOzttPtI7W0hWGCM
YRFHAqxRQAUUUUAFFZ+n3txeSXaz2EtsIZjHG0hH71f7w9q0KACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACmswVS
x6AZp1FAFDStTt9XsVvLZZVjZmUCVCrZBweD9Kv0AYooAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiioXniSRI3kRXkyEUtgt9PWgCaiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo
ooAKKKKACqNzpdneXtreTwh7i0JMLkn5CRg1eooAKKKKACiiigAooooAKKKKACiiigAooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA
KKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKK
ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAGsyopZiAoGST0AqO2uoLy3S4tpU
lhflXQ5BpzxpLG0cihkYFWUjIIPaorOytdOtEtbOBIYI/uxoMAd6ALNFFFABRRRQAUUUUAFFFFAB
RRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFF
FFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUU
UAf/2Q==