20230705 23494300 1.0 TRUE CreateFeatureclass "Z:\DP2000_Seedcorn_Projects\DP2000D - Spatial tools for field work (SCN1007)\Working Area\geospatial_survey_management\geospatial_survey_agedb_owner.sde" water_quality_survey_plan Point # No No "GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision" # # # # "Qater Quality survey plans" UpdateSchema "Z:\DP2000_Seedcorn_Projects\DP2000D - Spatial tools for field work (SCN1007)\Working Area\geospatial_survey_management\geospatial_survey_agedb_owner.sde\water_quality_survey_plan" "<operationSequence><workflow><AddField><field_name>cruise_id</field_name><field_type>TEXT</field_type><field_is_nullable>FALSE</field_is_nullable><field_length>150</field_length></AddField></workflow><workflow><AddField><field_name>survey_id</field_name><field_type>TEXT</field_type><field_is_nullable>FALSE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>survey_date_start</field_name><field_type>DATE</field_type><field_is_nullable>TRUE</field_is_nullable><field_default_value>05/07/2023 00:00:00</field_default_value><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>survey_date_end</field_name><field_type>DATE</field_type><field_is_nullable>TRUE</field_is_nullable><field_default_value>05/07/2023 00:00:00</field_default_value><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>survey_region</field_name><field_type>TEXT</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>station_id</field_name><field_type>TEXT</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>station_lon</field_name><field_type>DOUBLE</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>station_lat</field_name><field_type>DOUBLE</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>comment</field_name><field_type>TEXT</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow></operationSequence>" AssignDefaultToField "Z:\DP2000_Seedcorn_Projects\DP2000D - Spatial tools for field work (SCN1007)\Working Area\geospatial_survey_management\geospatial_survey_agedb_owner.sde\water_quality_survey_plan" survey_date_start "05/07/2023 00:00:00" # DO_NOT_CLEAR AssignDefaultToField "Z:\DP2000_Seedcorn_Projects\DP2000D - Spatial tools for field work (SCN1007)\Working Area\geospatial_survey_management\geospatial_survey_agedb_owner.sde\water_quality_survey_plan" survey_date_end "05/07/2023 00:00:00" # DO_NOT_CLEAR UpdateSchema "Z:\DP2000_Seedcorn_Projects\DP2000D - Spatial tools for field work (SCN1007)\Working Area\geospatial_survey_management\geospatial_survey_agedb_owner.sde\water_quality_survey_plan" <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> Rename "Z:\DP2000_Seedcorn_Projects\DP2000D - Spatial tools for field work (SCN1007)\Working Area\geospatial_survey_management\geospatial_survey_agedb_owner.sde\geospatial_survey.gs_agedb_owner.water_quality_survey_plan" "Z:\DP2000_Seedcorn_Projects\DP2000D - Spatial tools for field work (SCN1007)\Working Area\geospatial_survey_management\geospatial_survey_agedb_owner.sde\geospatial_survey.gs_agedb_owner.water_quality_survey_sites" FeatureClass 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=00022e686665664a79427a336b4e6375696c516b58573962714e66797370316a44742f3639567a54644c71555877303d2a00;ENCRYPTED_PASSWORD=00022e6867694859734c2b5a48664376484f6b6647784b6f7030577a643675566b4f35375571547a546343646932633d2a00;SERVER=citprodpostgres01;INSTANCE=sde:postgresql:citprodpostgres01;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=citprodpostgres01;DATABASE=geospatial_survey;USER=gs_agedb_owner;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>geospatial_survey.gs_agedb_owner.water_quality_survey_sites</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>cruise_id</field_name><domain_name>water_quality_platform</domain_name></AssignDomainToField></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=00022e686665664a79427a336b4e6375696c516b58573962714e66797370316a44742f3639567a54644c71555877303d2a00;ENCRYPTED_PASSWORD=00022e6867694859734c2b5a48664376484f6b6647784b6f7030577a643675566b4f35375571547a546343646932633d2a00;SERVER=citprodpostgres01;INSTANCE=sde:postgresql:citprodpostgres01;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=citprodpostgres01;DATABASE=geospatial_survey;USER=gs_agedb_owner;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>geospatial_survey.gs_agedb_owner.water_quality_survey_sites</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AssignDefaultToField><field_name>cruise_id</field_name><default_value>THGUARD</default_value></AssignDefaultToField></workflow><workflow><AssignDomainToField><field_name>survey_id</field_name><domain_name>water_quality_surveys</domain_name></AssignDomainToField><AssignDefaultToField><field_name>survey_id</field_name><default_value>THGUARD_07_2023_1</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>survey_date_start</field_name><default_value>14/07/2023 00:00:00</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>survey_date_end</field_name><default_value>14/07/2023 00:00:00</default_value></AssignDefaultToField></workflow></operationSequence>" CalculateGeometryAttributes water_quality_survey_sites "station_lon POINT_X;station_lat POINT_Y" # # GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]] "Same as input" CalculateGeometryAttributes water_quality_survey_sites "station_lon POINT_X;station_lat POINT_Y" # # GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]] "Same as input" sites water quality data collection field maps Layer with location of the survey sites selected Water quality survey sites /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3JSSu WGDTGnjUkFxkUk1wsQweT6Vmk5JPrWtOlz6s56tbk0WrJZ52lYgE7OwqGiiuuMVFWRxSk5O7Ciii qEFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQ AUUUUAFFFFAASScmiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooo oAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiig AooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAC iiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooo oAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiig AooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAzNftdQvNJkh0y5+z3RIw+c cdxntVnTYrmDTbaK9mE1ykYEsg/ibHJq1RStrcfNpYKKKKYgooooAKKKKACiiigAooooAKKKKACi iigAooooAKKKKACiiigAooooAKwrHVtUuPE15YT6a0VlEuY7gg4bp36HPP5Vu0VLV+o00r6BRRRV CCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAHiGQgkKSB1p PLfbu2nb64pMkdzRubGMnHpmp1HoKUcYypGfak2nGcHHrSmRyBljx05o8x9mzcdvpRqGg3B9KKeZ pCoUtkDpSmZywYkEjpxRqGhHRUnnNv3FVJxjpQJcFiUU59qNQsu5HRUgkUIV8tST3pC6bAPLGfXN FwshlFSM0Z24jI55560ZiLj5WC46ZouFvMjoqQeTvOdwXtQoiIO5mBzxxRcLEdFP2x+Xned3pilK IAMSAk9eOlFwsR0VIY13ACVSD39KPKy+0OnTrnii6DlZHRUgiZiwDLx70ghcoXAGB70XQcrGUU8x OEDFflPehoZFIBQgnpTugsxlFOMbhtpRs9cYpNrZxg/lRcVhKKKKYBRRRQAUUUUAFFFFABRRRQAU UUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAZpdzep496SigB 3mOG3b2z0zmlE0isSHOT1OaZRU2Q7skWaRVIDcHrR5z+Xs42/So6KLILskMxbblU4P8AdoMuWDGN OOwHWo6KLIOZkgkXeWMSkHtQrxjO6LOenPSo6KOULseDH5eCh3euaUmLaMBg3fmo6KLBckPk7htL 475o2xb8b22464qOiiwXJAkZZgZMAdDjrQEUqT5gBHb1qOiiwX8h/ljy929c+nen+R/00T86hoos wuuwUUUVQgooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKAP//Z