pushd \\gissrv.ad.mps\data\ogr2ogr\
ogr2ogr --config GDAL_DRIVER_PATH \\gissrv.ad.mps\data\ogr2ogr\gdalplugins\ -f "KML" "\\GMSRVDEV\Workflows\Reports\wma.kml" -s_srs "EPSG:28355" "MSSQL:server=gissrv;database=Bushland_Prod;trusted_connection=yes" -sql "SELECT GMSC_KEY, Reserve_Name, YEAR, Author, Date, Planning_Permit, Action_Type, Cautions, Geometry_spa, isRare_Threatened_Species, isHabitat, Rare_Threatened_Species_com, Habitat_com, isWorkingbee, Workingbee_com, Auditor, Audit_Date, Audit_Others_Present, Cautions_Adhered, Cautions_Adhered_com, Instruction_Adhered, Instruction_Adhered_com, Methods_Applied, Methods_Applied_com, Timing_Works, Timing_Works_com, Works_Impact, Works_Impact_com, Outcome_Achieved, Outcome_Achieved_com, SignOff_Name, SignOff_Date, SignOff_Officer, isSignOff_Accepted, SignOff_com, Followup_SignOff_Name, Followup_SignOff_Date, Followup_SignOff_Officer, isFollowup_SignOff_Accepted, Followup_SignOff_com, Budget, Total_Hours_worked, SignOff_Date_Completed, Followup_Date_Complete, Acacia_saligna, Acetosa_sagittata, Agrostis_capillaris, Anthoxanthum_odoratum, Asparagus_asparagoides, Asparagus_scandens, Billardiera_heterophylla, Briza_sp, Coprosma_repens, Coprosma_robusta, Crataegus_monogyna, Dactylis_glomerata, Delairea_odorata, Dipogon_lignosus, Ehrharta_erecta_var_erecta, Ehrharta_longiflora, Genista_spp, Hedera_helix, Holcus_lanatus, Hypochaeris_radicata, Leptospermum_laevigatum, Lonicera_japonica, Oxalis_spp, Pinus_spp, Pittosporum_undulatum, Plantago_lanceolata, Polygala_myrtifolia, Rhamnus_alaternus, Rubus_fruticosus_spp_agg, Senecio_angulatus, Senecio_pterophorus, Tradescantia_fluminensis, Ulex_europaeus, Vinca_major, Vulpia_spp, Zantedeschia_aethiopica, Acacia_longifolia_subsp, Aira_caryophyllea_subsp, Chrysanthemoides_monilifera, Watsonia_meriana, Project_Name, Purchase_Order, Approved, ApprovedBy, ApprovalDate, Action_Ground_Flora, Action_Scrambling, Action_Woody, Quantafiable_Outcomes, Specific_Instructions, Condition_Statement, Action_ID, Contractor_Response, Woody_Other, Scrambling_Other, Ground_Other, Woody_Other_Species, Scrambling_Other_Species, Ground_Other_Species, Labour_Hrs_Total, Further_Comments, Responder, Responder_date, Cautions_Adhered_res, Instruction_Adhered_res, Methods_Applied_res, Timing_Works_res, Works_Impact_res, Outcome_Achieved_res, isArchived, Non_Labour_Expenses, Non_Labour_Expense_Details, GrFlora_Condition_Dist, GrFlora_Condition_Density, GrFlora_Condition_LifeStage, GrFlora_Quant_Dist, GrFlora_Quant_Density, GrFlora_Quant_LifeStage, Scrambling_Condition_Dist, Scrambling_Condition_Density, Scrambling_Condition_LifeStage, Scrambling_Condition_Height, Scrambling_Quant_Dist, Scrambling_Quant_Density, Scrambling_Quant_LifeStage, Scrambling_Quant_Height, Woody_Condition_Dist, Woody_Condition_Density, Woody_Condition_LifeStage, Woody_Condition_Height, Woody_Quant_Dist, Woody_Quant_Density, Woody_Quant_Height, Woody_Quant_LifeStage, Contractor_com, Agreed_Action_Changes, Service_Provider FROM bushland_prod.dbo.vw_NL_Weed_Management_KML_Output" -t_srs "EPSG:28355"
popd \\gissrv.ad.mps\data\ogr2ogr\