20191204
16040300
1.0
FALSE
GIS.SDE.Milfoil
002
Server=SQL4; Service=sde:sqlserver:SQL4; Database=GIS; User=sde; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983
Linear Unit: Meter (1.000000)
NAD_1983_UTM_Zone_11N
<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/2.4.0'><WKT>PROJCS["NAD_1983_UTM_Zone_11N",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-117.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",26911]]</WKT><XOrigin>-5120900</XOrigin><YOrigin>-9998100</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>2</MTolerance><HighPrecision>true</HighPrecision><WKID>26911</WKID><LatestWKID>26911</LatestWKID></ProjectedCoordinateSystem>
FeatureClassToFeatureClass "Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019" "P:\GIS\SDE_Connection\GIS_Tech_Connections\GIS on SQL4.sde\GIS.SDE.Environmental_Services" Milfoil # "Site "Site" true true false 256 Text 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,Site,0,256;Landmark_or_Feature "Landmark or Feature" true true false 1000 Text 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,Landmark_or_Feature,0,2147483647;GPS "GPS" true true false 1000 Text 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,GPS,0,2147483647;F2011_Rating "2011 Rating" true true false 10 Text 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,F2011_Rating,0,2147483647;F2019_Plants "2019 Plants" true true false 0 Long 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,F2019_Plants,-1,-1;F2018_Plants "2018 Plants" true true false 0 Long 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,F2018_Plants,-1,-1;F2017_Plants "2017 Plants" true true false 0 Long 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,F2017_Plants,-1,-1;F2016_Plants "2016 Plants" true true false 0 Long 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,F2016_Plants,-1,-1;F2015_Plants "2015 Plants" true true false 0 Long 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,F2015_Plants,-1,-1;YTD_Change "YTD Change" true true false 0 Long 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,YTD_Change,-1,-1;F2015_Levels "2015 Levels" true true false 100 Text 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,F2015_Levels,0,2147483647;F2018_Levels "2018 Levels" true true false 100 Text 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,F2018_Levels,0,2147483647;F2019_Levels "2019 Levels" true true false 100 Text 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,F2019_Levels,0,2147483647;Lat_whole "Lat whole" true true false 0 Long 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,Lat_whole,-1,-1;lat_minutes "lat minutes" true true false 0 Double 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,lat_minutes,-1,-1;Long_whole "Long whole" true true false 0 Long 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,Long_whole,-1,-1;long_minutes "long minutes" true true false 0 Double 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,long_minutes,-1,-1;lat "lat" true true false 0 Double 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,lat,-1,-1;long "long" true true false 0 Double 0 0,First,#,Christina Lake Milfoil Data 2019\Christina_Lake_Milfoil_Data_2019,long,-1,-1" #
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.4.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6849717478477531744162443150543254775654623670666a584f67654d5a72457071455843504d725a48383d2a00;SERVER=SQL4;INSTANCE=sde:sqlserver:SQL4;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL4;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Lat_whole</field_name><field_name>lat_minutes</field_name><field_name>Long_whole</field_name><field_name>long_minutes</field_name><field_name>lat</field_name><field_name>long</field_name></DeleteField></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.4.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6849717478477531744162443150543254775654623670666a584f67654d5a72457071455843504d725a48383d2a00;SERVER=SQL4;INSTANCE=sde:sqlserver:SQL4;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL4;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Days_2015</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Days_2015</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Days_2016</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Days_2016</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Days_2017</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Days_2017</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Days_2018</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Days_2018</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Days_2019</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Days_2019</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.4.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6849717478477531744162443150543254775654623670666a584f67654d5a72457071455843504d725a48383d2a00;SERVER=SQL4;INSTANCE=sde:sqlserver:SQL4;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL4;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>TotalPlant_2015_2019</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>Total Plants Removed 2015-2019</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Field</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Field</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField "Milfoil Site" TotalPlant_2015_2019 !F2019_Plants!+!F2018_Plants!+!F2017_Plants!+!F2016_Plants!+!F2015_Plants! "Python 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/2.4.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6849717478477531744162443150543254775654623670666a584f67654d5a72457071455843504d725a48383d2a00;SERVER=SQL4;INSTANCE=sde:sqlserver:SQL4;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL4;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>TotalPlant_2015_2019</field_name><field_name>Field</field_name></DeleteField></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.4.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6849717478477531744162443150543254775654623670666a584f67654d5a72457071455843504d725a48383d2a00;SERVER=SQL4;INSTANCE=sde:sqlserver:SQL4;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL4;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>Plants_2015_2019</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>Total Plants Removed 2015 - 2019</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField "Milfoil Site" Plants_2015_2019 !F2019_Plants!+!F2018_Plants!+!F2017_Plants!+!F2016_Plants!+!F2015_Plants! "Python 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/2.4.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6849717478477531744162443150543254775654623670666a584f67654d5a72457071455843504d725a48383d2a00;SERVER=SQL4;INSTANCE=sde:sqlserver:SQL4;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL4;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>Cost_2015_2019</field_name><field_type>DOUBLE</field_type><field_precision>7</field_precision><field_scale>1</field_scale><field_alias>Total Cost 2015-2019</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField "Milfoil Site" Cost_2015_2019 (!Days_2015!+!Days_2016!+!Days_2017!+!Days_2018!+!Days_2019!)*1500 "Python 3" #
EnableAttachments "P:\GIS\SDE_Connection\GIS_Tech_Connections\GIS on SQL4.sde\GIS.SDE.Environmental_Services\GIS.SDE.Milfoil"
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.6.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e687a516b784e6e513877382b51796f426a4157667755614e462f4b666f6153622b346141615a364c526537513d2a00;SERVER=SQL4;INSTANCE=sde:sqlserver:SQL4;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL4;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>F2020_Plants</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>2020 Plants</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>F2020_Levels</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>2020 Levels</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
AddAttachments "P:\GIS\SDE_Connection\GIS_Tech_Connections\GIS on SQL4.sde\GIS.SDE.Environmental_Services\GIS.SDE.Milfoil" Site match_table MATCHID PhotoPath #
CalculateField "Milfoil Data" YTD_Change !F2020_Plants!-!F2019_Plants! "Python 3" # Text
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.6.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68386a694f6e5535476d317165742f4a736b5441744a722f52587877305442593635355455525a554d5671553d2a00;SERVER=SQL4;INSTANCE=sde:sqlserver:SQL4;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL4;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>attachID</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>attachment ID</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField GIS.SDE.Milfoil attachID None PYTHON_9.3 #
RemoveAttachments "P:\GIS\SDE_Connection\GIS_Tech_Connections\GIS on SQL4.sde\GIS.SDE.Environmental_Services\GIS.SDE.Milfoil" Site H:\GIS\scratch.gdb\match_table MATCHID PhotoPath
RemoveAttachments GIS.SDE.Milfoil Site match_table MATCHID #
RemoveAttachments GIS.SDE.Milfoil Site match_table MATCHID #
RemoveAttachments GIS.SDE.Milfoil Site match_table MATCHID #
AddAttachments GIS.SDE.Milfoil Site match_table2 MATCHID PhotoPath #
RemoveAttachments GIS.SDE.Milfoil Site match_table2 MATCHID #
AddAttachments "P:\GIS\SDE_Connection\GIS_Tech_Connections\GIS on SQL4.sde\GIS.SDE.Environmental_Services\GIS.SDE.Milfoil" Site match_table MATCHID PhotoPath #
RemoveAttachments GIS.SDE.Milfoil Site match_table MATCHID #
RemoveAttachments GIS.SDE.Milfoil Site match_table MATCHID #
RemoveAttachments GIS.SDE.Milfoil Site match_table MATCHID #
AddAttachments GIS.SDE.Milfoil Site match_table MATCHID PhotoPath #
RemoveAttachments GIS.SDE.Milfoil Site match_table MATCHID #
AddAttachments GIS.SDE.Milfoil Site match_table MATCHID PhotoPath #
AddAttachments "P:\GIS\SDE_Connection\GIS_Tech_Connections\GIS on SQL4.sde\GIS.SDE.Environmental_Services\GIS.SDE.Milfoil" Site H:\GIS\scratch.gdb\match_table3 MATCHID PhotoPath #
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.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e682b506a68425541724964652f795370543044734368426a62516e453556716f39443654484248547a6877453d2a00;SERVER=SQL5;INSTANCE=sde:sqlserver:SQL5;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL5;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>F2021_Plants</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_alias>F2021_Plants</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>F2021_Levels</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_alias>F2021_Levels</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.0.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b774e3572755843524962653945733052372b6d6b644e583249665758647436534772416c775565535a593d2a00;ENCRYPTED_PASSWORD=00022e6853746b54345741744133747a2b6b764d65482f45427665485765673064797041545368637736704b2f67553d2a00;SERVER=SQL5;INSTANCE=sde:sqlserver:SQL5;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL5;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>F2022_Plants</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><workflow><AddField><field_name>F2022_Levels</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.0.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b774e3572755843524962653945733052372b6d6b644e583249665758647436534772416c775565535a593d2a00;ENCRYPTED_PASSWORD=00022e6853746b54345741744133747a2b6b764d65482f45427665485765673064797041545368637736704b2f67553d2a00;SERVER=SQL5;INSTANCE=sde:sqlserver:SQL5;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL5;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>F2022_Levels</field_name></DeleteField></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.0.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b774e3572755843524962653945733052372b6d6b644e583249665758647436534772416c775565535a593d2a00;ENCRYPTED_PASSWORD=00022e6853746b54345741744133747a2b6b764d65482f45427665485765673064797041545368637736704b2f67553d2a00;SERVER=SQL5;INSTANCE=sde:sqlserver:SQL5;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL5;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>F2022_Levels</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><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.2.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e684c55462f315462333436784455684f6e344a2f69446537484d42526c3038574a2f3541716a764f7337426b3d2a00;SERVER=SQL5;INSTANCE=sde:sqlserver:SQL5;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL5;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>F2023_Plants</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><workflow><AddField><field_name>F2023_Levels</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><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.4.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68494d694a3650452b3350786146732f34574b4b7a5a4a587375625432682b346b554f5969634146437970633d2a00;ENCRYPTED_PASSWORD=00022e6871396e74667635384c67304462596142372b2b78626457663839503443595366796e706131486c43625a383d2a00;SERVER=SQL5;INSTANCE=sde:sqlserver:SQL5;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL5;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>F2024_Plants</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><workflow><AddField><field_name>F2024_Levels</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.4.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68494d694a3650452b3350786146732f34574b4b7a5a4a587375625432682b346b554f5969634146437970633d2a00;ENCRYPTED_PASSWORD=00022e6871396e74667635384c67304462596142372b2b78626457663839503443595366796e706131486c43625a383d2a00;SERVER=SQL5;INSTANCE=sde:sqlserver:SQL5;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL5;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>F2024_Levels</field_name></DeleteField></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.4.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68494d694a3650452b3350786146732f34574b4b7a5a4a587375625432682b346b554f5969634146437970633d2a00;ENCRYPTED_PASSWORD=00022e6871396e74667635384c67304462596142372b2b78626457663839503443595366796e706131486c43625a383d2a00;SERVER=SQL5;INSTANCE=sde:sqlserver:SQL5;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL5;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>F2024_Levels</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><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.4.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68494d694a3650452b3350786146732f34574b4b7a5a4a587375625432682b346b554f5969634146437970633d2a00;ENCRYPTED_PASSWORD=00022e6871396e74667635384c67304462596142372b2b78626457663839503443595366796e706131486c43625a383d2a00;SERVER=SQL5;INSTANCE=sde:sqlserver:SQL5;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL5;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AlterField><field_name>F2024_Levels</field_name><field_type>TEXT</field_type><field_length>50</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></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.4.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68494d694a3650452b3350786146732f34574b4b7a5a4a587375625432682b346b554f5969634146437970633d2a00;ENCRYPTED_PASSWORD=00022e6871396e74667635384c67304462596142372b2b78626457663839503443595366796e706131486c43625a383d2a00;SERVER=SQL5;INSTANCE=sde:sqlserver:SQL5;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL5;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>F2024_Levels</field_name></DeleteField></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.4.0'><FeatureDataset>GIS.SDE.Environmental_Services</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68494d694a3650452b3350786146732f34574b4b7a5a4a587375625432682b346b554f5969634146437970633d2a00;ENCRYPTED_PASSWORD=00022e6871396e74667635384c67304462596142372b2b78626457663839503443595366796e706131486c43625a383d2a00;SERVER=SQL5;INSTANCE=sde:sqlserver:SQL5;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=SQL5;DATABASE=GIS;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS.SDE.Milfoil</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>F2024_Levels</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>50</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
20191204
16040400
20191204
16040400
Microsoft Windows 10 Version 10.0 (Build 16299) ; Esri ArcGIS 12.4.2.19948
Milfoil Data
milfoil
environmental services
feature service to display milfoil data
Enterprise Geodatabase Feature Class
dataset
EPSG
6.13(3.0.1)
0
Simple
FALSE
0
TRUE
FALSE
GIS.SDE.Milfoil
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Site
Site
String
256
0
0
Landmark_or_Feature
Landmark or Feature
String
1000
0
0
GPS
GPS
String
1000
0
0
F2011_Rating
2011 Rating
String
10
0
0
F2019_Plants
2019 Plants
Integer
4
10
0
F2018_Plants
2018 Plants
Integer
4
10
0
F2017_Plants
2017 Plants
Integer
4
10
0
F2016_Plants
2016 Plants
Integer
4
10
0
F2015_Plants
2015 Plants
Integer
4
10
0
YTD_Change
YTD Change
Integer
4
10
0
F2015_Levels
2015 Levels
String
100
0
0
F2018_Levels
2018 Levels
String
100
0
0
F2019_Levels
2019 Levels
String
100
0
0
Lat_whole
Lat whole
Integer
4
10
0
lat_minutes
lat minutes
Double
8
38
8
Long_whole
Long whole
Integer
4
10
0
long_minutes
long minutes
Double
8
38
8
lat
lat
Double
8
38
8
long
long
Double
8
38
8
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
20191204
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAA
JwAAACcBKgmRTwAABpNJREFUeJzt3H1rFOsZwOF7ZnZj3pukEldPFNo/FM/5An7/r1DsoRWhFbTl
pCJyjM3L7k55JhndpG5MskkPd7kuCSb7AhLhx/0888wO2rZtAyCBwW/9DwC4KsEC0hAsIA3BAtIQ
LCANwQLSECwgDcEC0hAsIA3BAtIQLCANwQLSECwgDcEC0hAsIA3BAm5s0Y/Tq6rqWq8XLCANwQLS
ECwgDcEC0hAsIA3BAtIQLCANwQLmmk6nUdf1uXNX/Vc5QzX7XP98f7Zq9vvbIljAXN8KTnmsf3wy
mUTTNF+em43ZbceqECxgrtlp6eJj31ImrjKV3RXBAr6rD9bFJeDsdNUrr1n0lp15BAu4kX7pd3Bw
EEdHRzEcDmN5ebmL2F0sBwvBAi7V70vNTldl2Tcej+Pw8DDevn0b+/v7sbKyEqPRKLa3t7twDQa3
nxfBAi71reVd2Ww/OTmJd+/excuXL+P169exvr4ez58/j6dPn8b9+/cFC/jtzC7zSrDKhPXLv/bj
9d//Fn/6+c+xtbkZG7/bjAcPR7G1sx195m5zcWjCAi51cT+qXyJOo41fjw/j8+Q4DttxfJ6cxKeT
o+7rcHwSy6evjrKQrM7q1f/9Re3zsIA7MHu+qmys14NB7I4exJM//qGbplZXV+OHx3vdlNUsDb+8
rxxy+O9riTdjwgIuVQJ1cR+rBGupWoq9vb3ygvhh9LDbaH+wuxs7OzvdFcO7IFjAlczealOCda+p
Y3u4FYPhsLs6WCK1srwcw2YQg+rrFcXzJ7cWI1jAjVRRRR1VrK+sxdrKajTRdBvsbbS3utE+S7CA
S112E/O4HXdLwuosVWUjvnvP2dXB25yuCsEC5ioHRGdvZO73svqf67ZsqpeZqlw5PH1POWBargZO
2/Of9NC9v5pztfCKBAuY62KgZh8r8SlBqs/C1p+GL8vE04Dd/v2EggXMdfHm5osfG9PPT3XdnH/s
7OjDPF8mrbgewQJupN+jmt7BXtU8ggXcWNmLKofVb7ondV2CBSzkfxWrQrCAW49Vv0c1jz0s4P+e
CQu4s8nre5PWdQkWkIZgATf3nc+zmvfsTQcvwQLSECwgDcEC0hAsIA3BAtIQLCANwQLSECwgDcEC
0hAsIA3BAtIQLCANwQLSECwgDcEC0hAsIA3BAtIQLCANwQLSECwgDcEC0hAsIA3BAtIQLCANwQLS
ECwgDcEC0hAsIA3BAtIQLCANwQLSECwgDcEC0hAsIA3BAtIQLCANwQLSECwgDcEC0hAsIA3BAtIQ
LCANwQLSECwgDcEC0hAsIA3BAtIQLCANwQLSECwgDcEC0hAsIA3BAtIQLCANwQLSECwgDcEC0hAs
IA3BAtIQLCANwQLSECwgDcEC0hAsIA3BAtIQLCANwQLSECwgDcEC0hAsIA3BAtIQLCANwQLSECwg
DcEC0hAsIA3BAtIQLCANwQLSECwgDcEC0hAsIA3BAtIQLCANwQLSECwgDcEC0hAsIA3BAtIQLCAN
wQLSECwgDcEC0hAsIA3BAtIQLCANwQLSECwgDcEC0hAsIA3BAtIQLCANwQLSECwgDcEC0hAsIA3B
AtIQLCANwQLSECwgDcEC0hAsIA3BAtIQLCANwQLSECwgDcEC0hAsIA3BAtIQLCANwQLSECwgDcEC
0hAsIA3BAtIQLCANwQLSECwgDcEC0hAsIA3BAtIQLCANwQLSECwgDcEC0hAsIA3BAtIQLCANwQLS
ECwgDcEC0hAsIA3BYmHtFV9X+V2zIMFi4ViN22m0bRtN3cSnfx/EwcFBbG5vRdM0MYg6qi5VbbST
SfdTeTymbYzH4xgsDf0PcGWCxcKTVVVVMY02fnm/H2//+Y/4+PFjrKytxqNHj+L+zu9j0AxiEFW0
VXVuHCvvg+sQLBbSlj/t6bT06tWr+Pmvf4n3799HW0W8ePEiNtbWo1quYlgPTwPVtjGdTrtJq65r
v32uRbBYSFnuTSbjODo6ijdv3nTRKsH69Pmgm7B+ev5jDIfDiLNgte30NFxVZcLi2gSLhZWJ6fj4
OE5OTrrvy1eZuErE4DYJFgsrE1PZSB+NRvHx06+xsbERJ5Nx7O7udtNVt8lelo9tG3W/b9WeLiWr
xrKQqxMsFjJtp12QVldX49mzZ7G0shwfPnyItY31ePz4cdy7d6+7etjvdRXd3tX0dC+rESyuQbBY
yGQyiWYwjLpu4snek5hWEZubm/Hg4Si2trZi2Ay/HmvogvX1ymAfMIgr+g8hAGsv8LbrRAAAAABJ
RU5ErkJggg==