20231019
16580000
1.0
FALSE
CreateFeatureclass "F:\GIS_Data\GISViewers\George Mun Pro Project\GISDB.sde" Civil_River_Monitoring Point # No Yes "PROJCS["Hartebeesthoek94_Lo23_(E-N)",GEOGCS["GCS_Hartebeesthoek_1994",DATUM["D_Hartebeesthoek_1994",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",23.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]];-5623200 -10002100 10000;-100000 10000;-100000 10000;0.001;0.001;0.001;IsHighPrecision" # # # # "River Monitoring"
UpdateSchema "F:\GIS_Data\GISViewers\George Mun Pro Project\GISDB.sde\Civil_River_Monitoring" <operationSequence><workflow><AlterField><field_name>OBJECTID</field_name><field_alias>OBJECTID</field_alias></AlterField></workflow><workflow><AlterField><field_name>SHAPE</field_name><field_alias>SHAPE</field_alias></AlterField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6879376558586d416c7630677a696370357a304a474f7244376449515155774b6569474837736b6465356a413d2a00;ENCRYPTED_PASSWORD=00022e685562423949344579546b6b78596e75772f4c4f4c6636614b6c3162757061447330564a61703935427970733d2a00;SERVER=grg-gis-sql.database.windows.net;INSTANCE=sde:sqlserver:grg-gis-sql.database.windows.net;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=grg-gis-sql.database.windows.net;DATABASE=GIS_DB;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_DB.SDE.Civil_River_Monitoring</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>logo</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>logo</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>date_monitored</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_alias>Date</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>laboratory</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Lab</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>river_name</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>River</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>river_location</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>River Location</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>min_max</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Greater, Less or Equal</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>lab_result</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>8</field_scale><field_alias>Result</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>blue_flag</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>8</field_scale><field_alias>BLUE FLAG</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>full_contact</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>8</field_scale><field_alias>Full Contact</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>intermediate_contact_l_limit</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>8</field_scale><field_alias>Intermediate Contact - L limit</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>intermediate_contact_h_limit</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>8</field_scale><field_alias>Intermediate Contact - H limit</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>result_text</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Result (Text)</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682f4f4d2b5264634e5968556338747779794b35695a4b42666f3159766a69774d61456269453645742b4a303d2a00;ENCRYPTED_PASSWORD=00022e684846615a4950503063396758387365643057386d444539494a4930444d776d4f7453484c62324e685436303d2a00;SERVER=grg-gis-sql.database.windows.net;INSTANCE=sde:sqlserver:grg-gis-sql.database.windows.net;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=grg-gis-sql.database.windows.net;DATABASE=GIS_DB;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_DB.SDE.Civil_River_Monitoring</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddGlobalIDs /></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e687932717a504d7a354c6d353369386376744b41555a6c5376314b33734a41314b5a6b6e3973384d6a4b42493d2a00;ENCRYPTED_PASSWORD=00022e682b4365575431635a6b776a6a6b5843724e7a6c32574d454b423935776c72354c35652b7270396c4d492b733d2a00;SERVER=grg-gis-sql.database.windows.net;INSTANCE=sde:sqlserver:grg-gis-sql.database.windows.net;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=grg-gis-sql.database.windows.net;DATABASE=GIS_DB;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_DB.SDE.Civil_River_Monitoring</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><EnableAttachments /></workflow></operationSequence>"
CalculateField "River Monitoring" river_name 'gwaiing' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "River Monitoring" river_name 'rooi' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "River Monitoring" river_location 'gwaaing_mouth' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "River Monitoring" river_location 'gwaaing_mouth_sea' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "River Monitoring" river_location 'gwaaing_mouth' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "River Monitoring" river_location 'gwaaing_malgas' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "River Monitoring" river_location 'gwaaing_mouth_middle' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "River Monitoring" river_location 'rooi_proefplaas' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "River Monitoring" laboratory 'gm_ls' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "River Monitoring" laboratory 'merieux' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "River Monitoring" min_max 'equal' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "River Monitoring" min_max 'min' "Python 3" # Text NO_ENFORCE_DOMAINS
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6879376558586d416c7630677a696370357a304a474f7244376449515155774b6569474837736b6465356a413d2a00;ENCRYPTED_PASSWORD=00022e685562423949344579546b6b78596e75772f4c4f4c6636614b6c3162757061447330564a61703935427970733d2a00;SERVER=grg-gis-sql.database.windows.net;INSTANCE=sde:sqlserver:grg-gis-sql.database.windows.net;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=grg-gis-sql.database.windows.net;DATABASE=GIS_DB;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_DB.SDE.Civil_River_Monitoring</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>group_</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><workflow><AddField><field_name>test</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>
Append GIS_DB.SDE.river_data_dat_XYTableToPoin "River Monitoring" "Use the field map to reconcile field differences" "logo "logo" true true false 255 Text 0 0,First,#;date_monitored "Date" true true false 8 Date 0 0,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,Date,-1,-1;laboratory "Lab" true true false 255 Text 0 0,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,Lab,0,1073741822;river_name "River" true true false 255 Text 0 0,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,River,0,1073741822;river_location "River Location" true true false 255 Text 0 0,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,Location,0,1073741822;min_max "Greater, Less or Equal" true true false 255 Text 0 0,First,#,F:\GISViewers\George Mun Pro Project\GISDB.sde\GIS_DB.SDE.river_data_dat_XYTableToPoin,min_max,0,1073741822;lab_result "Result" true true false 8 Double 8 38,First,#;blue_flag "BLUE FLAG" true true false 8 Double 8 38,First,#,F:\GISViewers\George Mun Pro Project\GISDB.sde\GIS_DB.SDE.river_data_dat_XYTableToPoin,BLUE_FLAG,-1,-1;full_contact "Full Contact" true true false 8 Double 8 38,First,#,F:\GISViewers\George Mun Pro Project\GISDB.sde\GIS_DB.SDE.river_data_dat_XYTableToPoin,Full_Contact,-1,-1;intermediate_contact_l_limit "Intermediate Contact - L limit" true true false 8 Double 8 38,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,Intermediate_Contact___L_limit,-1,-1;intermediate_contact_h_limit "Intermediate Contact - H limit" true true false 8 Double 8 38,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,Intermediate_Contact___H_limit,-1,-1;result_text "Result (Text)" true true false 255 Text 0 0,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,Result,0,1073741822;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#;group_ "group_" true true false 255 Text 0 0,First,#,F:\GISViewers\George Mun Pro Project\GISDB.sde\GIS_DB.SDE.river_data_dat_XYTableToPoin,Group_,0,1073741822;test "test" true true false 0 Long 0 10,First,#,F:\GISViewers\George Mun Pro Project\GISDB.sde\GIS_DB.SDE.river_data_dat_XYTableToPoin,Test,0,1073741822" # # # NOT_UPDATE_GEOMETRY
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6879376558586d416c7630677a696370357a304a474f7244376449515155774b6569474837736b6465356a413d2a00;ENCRYPTED_PASSWORD=00022e685562423949344579546b6b78596e75772f4c4f4c6636614b6c3162757061447330564a61703935427970733d2a00;SERVER=grg-gis-sql.database.windows.net;INSTANCE=sde:sqlserver:grg-gis-sql.database.windows.net;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=grg-gis-sql.database.windows.net;DATABASE=GIS_DB;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_DB.SDE.Civil_River_Monitoring</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>test</field_name></DeleteField></workflow><workflow><AddField><field_name>test_</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>
Append GIS_DB.SDE.river_data_dat_XYTableToPoin "River Monitoring" "Use the field map to reconcile field differences" "logo "logo" true true false 255 Text 0 0,First,#;date_monitored "Date" true true false 8 Date 0 0,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,Date,-1,-1;laboratory "Lab" true true false 255 Text 0 0,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,Lab,0,1073741822;river_name "River" true true false 255 Text 0 0,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,River,0,1073741822;river_location "River Location" true true false 255 Text 0 0,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,Location,0,1073741822;min_max "Greater, Less or Equal" true true false 255 Text 0 0,First,#,F:\GISViewers\George Mun Pro Project\GISDB.sde\GIS_DB.SDE.river_data_dat_XYTableToPoin,min_max,0,1073741822;lab_result "Result" true true false 8 Double 8 38,First,#;blue_flag "BLUE FLAG" true true false 8 Double 8 38,First,#,F:\GISViewers\George Mun Pro Project\GISDB.sde\GIS_DB.SDE.river_data_dat_XYTableToPoin,BLUE_FLAG,-1,-1;full_contact "Full Contact" true true false 8 Double 8 38,First,#,F:\GISViewers\George Mun Pro Project\GISDB.sde\GIS_DB.SDE.river_data_dat_XYTableToPoin,Full_Contact,-1,-1;intermediate_contact_l_limit "Intermediate Contact - L limit" true true false 8 Double 8 38,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,Intermediate_Contact___L_limit,-1,-1;intermediate_contact_h_limit "Intermediate Contact - H limit" true true false 8 Double 8 38,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,Intermediate_Contact___H_limit,-1,-1;result_text "Result (Text)" true true false 255 Text 0 0,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,Result,0,1073741822;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#;group_ "group_" true true false 255 Text 0 0,First,#,F:\GISViewers\George Mun Pro Project\GISDB.sde\GIS_DB.SDE.river_data_dat_XYTableToPoin,Group_,0,1073741822;test_ "test_" true true false 255 Text 0 0,First,#,GIS_DB.SDE.river_data_dat_XYTableToPoin,Test,0,1073741822" # # # NOT_UPDATE_GEOMETRY
CalculateField "River Monitoring" lab_result !lab_result! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "River Monitoring" lab_result !result_text! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "River Monitoring" lab_result !result_text![1:] "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "River Monitoring" lab_result !result_text! "Python 3" # Text NO_ENFORCE_DOMAINS
ExportFeatures "River Monitoring" C:\Users\gisadmin\Documents\ArcGIS\Projects\Scratch.gdb\RiverMonitoringPoints # NOT_USE_ALIAS "logo "logo" true true false 255 Text 0 0,First,#,River Monitoring,logo,0,255;date_monitored "Date" true true false 8 Date 0 0,First,#,River Monitoring,date_monitored,-1,-1;laboratory "Lab" true true false 255 Text 0 0,First,#,River Monitoring,laboratory,0,255;river_name "River" true true false 255 Text 0 0,First,#,River Monitoring,river_name,0,255;river_location "River Location" true true false 255 Text 0 0,First,#,River Monitoring,river_location,0,255;min_max "Greater, Less or Equal" true true false 255 Text 0 0,First,#,River Monitoring,min_max,0,255;lab_result "Result" true true false 8 Double 8 38,First,#,River Monitoring,lab_result,-1,-1;blue_flag "BLUE FLAG" true true false 8 Double 8 38,First,#,River Monitoring,blue_flag,-1,-1;full_contact "Full Contact" true true false 8 Double 8 38,First,#,River Monitoring,full_contact,-1,-1;intermediate_contact_l_limit "Intermediate Contact - L limit" true true false 8 Double 8 38,First,#,River Monitoring,intermediate_contact_l_limit,-1,-1;intermediate_contact_h_limit "Intermediate Contact - H limit" true true false 8 Double 8 38,First,#,River Monitoring,intermediate_contact_h_limit,-1,-1;result_text "Result (Text)" true true false 255 Text 0 0,First,#,River Monitoring,result_text,0,255;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,River Monitoring,GlobalID,-1,-1;group_ "group_" true true false 255 Text 0 0,First,#,River Monitoring,group_,0,255;test_ "test_" true true false 255 Text 0 0,First,#,River Monitoring,test_,0,255" #
DeleteIdentical RiverMonitoringPoints river_location # 0
Buffer RiverMonitoringPoints C:\Users\gisadmin\Documents\ArcGIS\Projects\Scratch.gdb\RiverMonitoringPoints_Buffer "100 Meters" Full Round "No Dissolve" # Planar
CopyFeatures "River Monitoring Area" "F:\GISViewers\George Mun Pro Project\GISDB.sde\GIS_DB.SDE.River_Monitoring_Area" # # # #
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684c4b686d425041396f684c6e57596f5a6f325976414c7a4d416f7268723174574742334e6151575041554d3d2a00;ENCRYPTED_PASSWORD=00022e684b4267735662752f5836716d2f5a4856724c42394763735a4630485a45542b32426d326f4b50414c4d4c413d2a00;SERVER=grg-gis-sql.database.windows.net;INSTANCE=sde:sqlserver:grg-gis-sql.database.windows.net;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=grg-gis-sql.database.windows.net;DATABASE=GIS_DB;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_DB.SDE.River_Monitoring_Area</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>sea</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Sea</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>sea_location</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Sea Location</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
Append Sheet1$_XYTableToPoin_Buffer "River Monitoring Area" "Use the field map to reconcile field differences" "logo "logo" true true false 255 Text 0 0,First,#;date_monitored "Date" true true false 8 Date 0 0,First,#;laboratory "Lab" true true false 255 Text 0 0,First,#;river_name "River" true true false 255 Text 0 0,First,#;river_location "River Location" true true false 255 Text 0 0,First,#;min_max "Greater, Less or Equal" true true false 255 Text 0 0,First,#;lab_result "Result" true true false 8 Double 8 38,First,#;blue_flag "BLUE FLAG" true true false 8 Double 8 38,First,#;full_contact "Full Contact" true true false 8 Double 8 38,First,#;intermediate_contact_l_limit "Intermediate Contact - L limit" true true false 8 Double 8 38,First,#;intermediate_contact_h_limit "Intermediate Contact - H limit" true true false 8 Double 8 38,First,#;result_text "Result (Text)" true true false 255 Text 0 0,First,#;group_ "group_" true true false 255 Text 0 0,First,#;test_ "test_" true true false 255 Text 0 0,First,#;BUFF_DIST "BUFF_DIST" true true false 8 Double 8 38,First,#,F:\George Municipality\George GIS - Documents\GIS_Data\2023\Civil Engineerng\Water Sampling\Sheet1$_XYTableToPoin_Buffer.shp,BUFF_DIST,-1,-1;ORIG_FID "ORIG_FID" true true false 4 Long 0 10,First,#,F:\George Municipality\George GIS - Documents\GIS_Data\2023\Civil Engineerng\Water Sampling\Sheet1$_XYTableToPoin_Buffer.shp,ORIG_FID,-1,-1;sea "Sea" true true false 255 Text 0 0,First,#,F:\George Municipality\George GIS - Documents\GIS_Data\2023\Civil Engineerng\Water Sampling\Sheet1$_XYTableToPoin_Buffer.shp,SEA,0,254;sea_location "Sea Location" true true false 255 Text 0 0,First,#,Sheet1$_XYTableToPoin_Buffer,Location,0,254" # # # NOT_UPDATE_GEOMETRY
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684c4b686d425041396f684c6e57596f5a6f325976414c7a4d416f7268723174574742334e6151575041554d3d2a00;ENCRYPTED_PASSWORD=00022e684b4267735662752f5836716d2f5a4856724c42394763735a4630485a45542b32426d326f4b50414c4d4c413d2a00;SERVER=grg-gis-sql.database.windows.net;INSTANCE=sde:sqlserver:grg-gis-sql.database.windows.net;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=grg-gis-sql.database.windows.net;DATABASE=GIS_DB;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_DB.SDE.River_Monitoring_Area</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>logo</field_name><field_name>date_monitored</field_name><field_name>laboratory</field_name><field_name>min_max</field_name><field_name>lab_result</field_name><field_name>blue_flag</field_name><field_name>full_contact</field_name><field_name>intermediate_contact_l_limit</field_name><field_name>intermediate_contact_h_limit</field_name><field_name>result_text</field_name><field_name>group_</field_name><field_name>test_</field_name></DeleteField></workflow></operationSequence>
GIS_DB.SDE.River_Monitoring_Area
002
Server=grg-gis-sql.database.windows.net; Service=sde:sqlserver:grg-gis-sql.database.windows.net; Database=GIS_DB; User=sde; Version=sde.DEFAULT
ArcSDE Connection
Projected
GCS_Hartebeesthoek_1994
Linear Unit: Meter (1.000000)
Hartebeesthoek94_Lo23_(E-N)
<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/3.1.0'><WKT>PROJCS["Hartebeesthoek94_Lo23_(E-N)",GEOGCS["GCS_Hartebeesthoek_1994",DATUM["D_Hartebeesthoek_1994",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",23.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["Esri",102564]]</WKT><XOrigin>-5623200</XOrigin><YOrigin>-10002100</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>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102564</WKID><LatestWKID>102564</LatestWKID></ProjectedCoordinateSystem>
20231211
14481600
20231211
14481600
Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 17763) ; Esri ArcGIS 13.1.0.41833
River Monitoring Area
River Monitoring Area
River Monitoring Area
Enterprise Geodatabase Feature Class
dataset
Esri
10.6.0
0
Simple
FALSE
0
TRUE
FALSE
GIS_DB.SDE.River_Monitoring_Area
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
logo
logo
String
255
0
0
date_monitored
Date
Date
8
0
0
laboratory
Lab
String
255
0
0
river_name
River
String
255
0
0
river_location
River Location
String
255
0
0
min_max
Greater, Less or Equal
String
255
0
0
lab_result
Result
Double
8
38
8
blue_flag
BLUE FLAG
Double
8
38
8
full_contact
Full Contact
Double
8
38
8
intermediate_contact_l_limit
Intermediate Contact - L limit
Double
8
38
8
intermediate_contact_h_limit
Intermediate Contact - H limit
Double
8
38
8
result_text
Result (Text)
String
255
0
0
group_
group_
String
255
0
0
test_
test_
String
255
0
0
BUFF_DIST
BUFF_DIST
Double
8
38
8
ORIG_FID
ORIG_FID
Integer
4
10
0
Shape.STArea()
Shape.STArea()
Double
0
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20231211
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3fyz1
ahsKeTwOtK8v8K0jrtjx3qbICMOZXJHAqZc7AB1qONcAAVOExjmlHuA0BqeB68U6kPTmrAjLbulK
ThTTQVBwOKdJnZwaXQCqetKjBRmk25PJpdoPFZCE83PSl35+tCIAKfhaAEAz1NHHSlIz0oVQPrQA
BcUjewpxIFMZ8DNADhnbUBX97UkbljgUjbg+cUASjgU049aaHPQc0EdzxQAu4AU5WyOlCqMZoJHb
rQAE4603JNO+tJuHYUwI3BxTo1PUmg80LktikA8gYPSlXhRxSEfLSF/SmAMeaQYxTdpJyTT1SkAo
Oe1Jzk4p/QU1eaYEbIWOaOVPFPJx9KgllxkDr/Kk9AB5UHGNxqJpXYY3YHoKQxsBkjGfWk24AJIG
ah3ZOoKu4nr0zRt/2hQTxgdP50mKWgGgQQwNJJn7xqST7oOeaikfK8V0S2LFV8DkVMZ48cmoA3HS
k8oNyRUJtCJjNnoacFcryaRIeBnipcgCrV+oxqxgc9abNnAHanBu1DsNp4NN7AVsYNJ+NKaADish
EbEk4FSIPlyaAOafxjAoAWkz1pGbA4FRGY9MUASHFQsC30oG5jzTy6ouDQA6LAGOlLIcCkj5XNK/
K0AMWRR7mkdyaiD4cjFSom85bpQAqkkcU9RjmnAADik3ADmgA6mmnANIZR2pqhnOe1AEgwadgCk2
9Paghe5pgIck8GmlMEZNOEidAc0D5uT+VCVxjsUtRHKkjOKPMI96BEnU+1NYjrnmmb88Cmu20AZG
TQA2WUsNoOO2ahzs6YJ7mhtxOcdKjmkWHLNnGR+tQ/IRLuU8lST7mk3/ACgYHBzUUbSPkuu0dlPW
pBSbYhOc0vPrQTiikBd3MetJxjmnYx7ilCK2efwrXVlCKQaceoo6dKTqKAJy4C9aru7McKaYxJ4y
afGuBmm5NgPiB3dfrUrr8hpsWNx9aWSTaCAM1S2GQH60wuBxmoy5yc1EWAPXmsxFjeM4z1qVcAVQ
UMX4NWPmUcmgCVs9KYFJakMu1eaasgwSTQBI/wAo4qJE3tUM1y7fKq8VYttxX5qAJ1AXgVDI5BwK
ldgozmqnmfvaABYn3bm4FWlOFwaiMoxwcmlQt1NAExJAquQ0rY7VLsZh1wKC0cAy7AD1NACrGqjp
SNMinaOT6Cq0szSkPGWWJTzxjdUwQNHhPlJHB9KHvZAN82WTITaoHB5o8rexLEn2zxTLIIbPzFQB
yTv9zQoM+UlQ7evBxQ462YDvOgRjGhDygEhBU8blo1Zk2N6Zzioo/JX5I1VdoxwO1Obhflq7roMl
kUMufSoABmnx5ZTk01lZTx+NJ66gOCelO2buoH40wOewqTJP1qREbW4zkHH0qGW3LAjOM96tk8U0
HPWmBmqJ1fa6LtHG/PX8KkFXTGrVDJBjp+lS432E0QdeaXNOKEDnp60yoegi+ODzSg8HuM0EgDin
LGeB61qrlEbZUe1MjLMuDV3YNu2q2wqcU2hjAhB6UpfbUqqzdCPxqlNcTJKVNsxGT8w6UuViLBlG
M9DTfNGMk5pABLEpYbSRkj0qJom6KeKQDS+9/QUjlFpghlZvQVZS1Qcs2TQMZCHPIFPdZCamA2jC
g0uCeposIqPA70vkMqY5/OreCO/50m7sRRYCCNFTqMmpwy4GOKYQN2RSOwA45oAJShOTUJKenFQ3
D+XE8z5CICx+lcxceJL6K4AS1XYeQvUnr7/5zWlOjOp8KJlOMdzso4wy5xUwCqK5yHxQPsSztZTJ
2cHHDenv2q5p+tQalH8mY5e8UnB/+vUuEluhppi6vrttpsEgkLtIF+5H1GenPauUi8RPNcgC9xcE
bhE4BOPoev1qLXra7ul1C3glSO6ZyyNIMjrlT+WKx7DRrltUhlez828ij2mRBwR9fTPrXqUqFGNH
nk9TkqVZufLE9I0q+/tG23yAB1JRl9xzn8q0hlHxWVpSLp1t5MwKSs29iRwScDg/kK0Re28kZZXD
EAngGvMaV3Y643truOSIRebg8O24D0qF5nDYVlUY7jJqVriJoPMLYXGckYqlJ8z7gcqeQazqTcVd
DbsSwOY3LzBTHyRJ0xz0q4zKF4OR2NUEcoeBkHqD0NTmcMAArfTFKnUTQJk0ZLUspYjIpwZY05NR
PcBuFFWA+Pgc1JkDvVKBnkZj0GasiMkZJ4pADOCaVUJ705Y1U04dKAEC4opScUFgKYDHQEdOareU
DyTg+mKsl/SmY3c0WvuBKozyakDkY9KYKeqjhieKauBNTHGfrSs2BwaZvHc1bsMj37TxT/MOOmaj
Z493J/Kk3ADis72EOwDSeWOoPNJ96nDgc0AJt9c0YApw54oIIPNACfhmjj0qQJx15pChA607MBh6
cU1Qc88UFsUwSEtipAkKg9hSbAajabDYp/mgDJIp3ArX9v8AabKa3U7S6kA+9eOeKSo1XzrrzIDY
qVyGI6jn69a9jknHauN8R+Gp7+5muLeFbiG4AEsLEdcYzz2OK7svrxp1LVNn+Zz4mnKUfd3OR0O7
klubXE8kkEy7owWOOhxn8qv/AGnVPLRL1I4LjzGKiFs5GcLz7/59K39B8HSCVJb6EQQxLiKJGwQc
Yzx0A9Kv6ppemWOyR55hOo+RnTeD7cDrXbUxVL2jUVp5bGMKFTlu2c5YXdrqXnXCW8qm2laNvMUp
vx16HpXotrbQWsQW3iEann3P1PeuS0k219erDdMYVzwpXAk9s9vpXanr+NefjJRbSR0UU7XYYBGC
KglYxPFggITtI29fSpj0461WnBa5gTaSASxPYVxo3JmVXUqwyCMEGoIY5UZoig8tfuN7elWAyngE
H8aa0iqQpbBPQU12AVQWJyKUgDjOKi88BgBTy46kH8qWwC4B4AqTy+MY6VCsoz90ikmuyqnbmhCJ
Y2RBiphz9DVG2Du24jj3q90GfxoATeM+p7igt6VVs3Enmz7SN7YGfQcVZ5ApgN3deKQt/s0h60YA
70AIodzg4Ap+z3pGYAVHvPpQMnyTz0pwOBUZYY9DTHfA60hD5JgOMVC8rHhRzTApZu9SLHz3oAj2
yZ5pwR/WplQk9Kk2EDpiiwEKhgOtG9qmZVC8moxg9BRYByuRzT/NNNMYYUCPFACmQ+tMaZjwKftO
OtIF5p3YEOWNIRsQtg5qYkL2qN5cgjHFIDE1a8mtbcNHxJI+xT6cE5/IGuattVabUp7aG/la7twG
kRmJAz0znj8q6vULf+0Lfy1IV1YOhPYj/wDWRWOmj3gnOIIo2bAeXIOcfqa78KqTi1Lc567mmmiD
UtQ82Iyl3jt4o90ijOc4yenXFJ4e1xZBbXFpI72twQu1wRjJxkA9CDWneaKzLGbZxlUCMr/xY759
abp2ivDOks+wLHykadM9vyrojCiqdmtTGVSbndG+J3HcflXNa9AiXELBCI2VgfmOMmuhpksMc8ZS
VFdT2IrKCjGSlYJSk1a55/YQXipMt8Y5XaU+QIsjC/wj65r0yPd5a7zlsDP5VmQadaW0nmRQKH7E
knH51owtlcdxU4xqaUktjTDtp2ZKTioyw60r9MZpFjGMn9a4EjrRWkig5wAj/wB4U3J3bml39gCB
U8giPQE1Gqxq2dp/OtFSn2I9rBdSRIejHj69qlJjHVwfpUbS5Taq4FRVrGgn8RlOtr7pZUwE8nH1
FKfs3c5+gqrRV+wgT7aReHlsh8roPalDcelVIpTETxkHqKlaVD90n8RWM6TT0WhrCqmtRsZeOdk2
7oyMhh2PpUu/2qJ3x2oEgxyKxNAwWfvilIOaQtxwKEBOSTj2oGOPT7tJ+FOJbkKDQMY5zn6UhE/y
AcgGqjuqtxzTS+7+LH1oCopy75+laOMr2sLnja9yQNntT87Rk0zfDjqfyppaMn7zUezn2Fzx7kon
2rj+lJ5u45zURaP0Y/U0iuvdcfSn7Kdthe1j3LAJbpinjOQM/WmxlSuVNOBweetRa25adxx4NL2p
uRjrzTC/FIBxYDikBHaoTJz0496Y1yBwCBSAmkbaCazpJXkfy16mrGTL1f8AIU6CFY2Z+pxQldjI
Y4xHwxJPenUUV6EKahscU5uW4UUUVZAUUUUAFKrFTkUlFJq+gJ2JRN82SvHpSSSb+mQKjoqVTind
It1JNWbCiiirICiiigAooooAKKKKAHB2AwDxSqw3gvnHtTKKhwi+hSk0WEaN25O360kkwDAR4wPb
rUFFSqMU7lOrJqxP9qcDhVH4Un2lv7q1DRVezj2F7SXcKKKKsgKKKKACiiigByOyHKmpFlB6n8Kh
orOdOM9y4zcdicyeoOKY0oHAGfoajoyc5rF4d9zVV11Q7yXkXLEKtN8qNf8AaNKST1JNJVRoR6il
Wb2JY2j3AEbR65qaeNY4zg9elVKmWYGExuCfSm6STTiKNVtNSIaKKK3MQooooAKKKKACiiigAooo
oAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiig
AooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAC
iiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK
KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooo
oAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiig
AooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAC
iiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK
KKACiiigAooooA//2Q==