Home

STEP 1

1. 129 gt a CE TA aman A AT A RN RR A A A ON RN NN NN NUI MIX QUIMET xlsm General Data Num of End Members wee a waa CLICK HERE TO START Num of Samples Num of Species J Carrera and 4 Serrano Juan Su HOCO CUPS Yes anal PRI Y ES Nitrats MANS CCLO Yes HOCO CUPS Ye Clorurs MAQU CUP Yes MANS CCLO MAQU CUP 19 STEP7 Click here to start your MIX analysis 22 23 24 Execute 27 Check Files 28 29 I Check INPUT file prn Check the Folder 30 i ES v1 0 2012 di m m FH 0 LL in 2 1 13 Spatial QUIMET instructions Regulatory parameter analysis tools 2 1 13 REGULATORY PARAMETER QUERY This tool allows the user to obtain thematic maps for the parameters measured in the queried area classified according to the threshold approach established by a given guideline or just chosen by the user This allows the identification of areas where determined chemical species exceed some specified limit uz ae Normative r _ STEP 1 Choose Choose normabve normativa de calidad de aguas de wachinein ejemplo I normative STEP 2 Define temporal interval query STEP 2 Choose parameters to query mores ama se STEP 3 a Create map maan anan Mae SS or b Create RTF report with defined P5 CCL0301 28 01 os 703 query DE COD1N11 DI AE AN nnn E i F ri 4 Creat
2. measDate namParam value clasParam compY alue observations idLabEntity qualifiers LibChemParamLab idParam idLabEntity ChemSamples idParamLab Observations idEntity idUnits namE ntity deteclim idPoint idChemSamp acoress methAnal idProcessUsed i il bi closPoramiab sampFieldM ue I 1 3 al dng observations a absinput sampulze sampDepth 1 idCampaign 1 References idResponsibleEntity 1 idRef Points PointsHasLibPoinfType shoriDesc formRef dPoint idPoint segrRef Nam Point l idlype Campaign idCampaign observations Project obsinput X startD ate idProject Y encD ate name elevation LibPoinfType idRef idRef Tref observations observations typeCon idType obsinput obsinput pe Desclype Tables with attributes hydrochemical parameters Sampling site represented by point entity laboratory related to points that represents samplimg sites 3 2 1 Description of DB Point table 1 3 NAME OF THE DESCRIPTION FORMAT RELATIONSHIPS FIELD IdPoint Unique identifier for each point Example Text 30 YES PointsHasLibPointType Field IdPoint Zipcode 10000 AutoNumber required M 1 DB ChemSamples Field IdPoint 1 M ToponomyPoint Place name of the point popular name of Text 100 NO the point e g Well of the Major Spring of the butterflies more detailed than Nam1Point Nam2Point
3. Nam1iPoint Na Points name in different bases or Text 100 NO m2Point Nam4 references IdRefNam Point CooX Coordinate X UTM Double YES CooY Coordinate Y UTM Double YES Z Elevation Double NO Ztdm Elevation masl obtained from a digital Double NO terrain model DTM IdRefZ dropdown list Fields required for using QUIMET tools 3 2 1 Description of DB Point table 2 3 NAME OF DESCRIPTION FORMAT RELATIONSHIPS THE FIELD IdCooType IdCooZType IdRefNam1 4 IdRefCoo IdRefZ IdOwnPoint Type of CooX CooY Id from DB LibTypeCoo dropdown list E g map data DTM Type of CooZ Id from DB LibTypeCoo dropdown list E g DTM GPS Reference of the name indicated in Nam1 4Point Id from DB References table dropdown list Reference of the origin of the coordinates CoorX CoorY Id from DB Reference table dropdown list Reference of the origin of Z Id comes from DB Reference table dropdown list Owner s identifier of the water point Id from DB LibEntities table dropdown list Text 10 No Text 10 No Text 50 No Text 50 No Text 50 No Text 50 No DB LibTypeCoo field IdTypeCoo M 1 DB LibTypeCoo field IdTypeCoo M 1 DB References field IdRef M 1 DB References field IdRef M 1 DB References field IdRef M 1 DB LibEntities field IdEntity M 1 3 3 2 1 Description of DB Point table 3 3 NAME OF THE FIELD Adres
4. DB Project EXDMA N204UGL EH DB References il EXDMA N135UGL EXDMA N Hydrochemistry x D 568UGL ea oo o o o 1 EXDMA N155UGL EH DB ChemMeasurements EXDMA NO18UGL EH DB ChemSamples EXDMA N687UGL EH DB Point Table EXDMA N485MGL Ed DB PointsHasLibPointType EXDMA N480MGL HydrochemistryLib z EXDMA N222UGL EH DB LibChemParameters EXDMA N171MGL EXDMA N159UGL gt lt Y Nuevo Registros ParamNorm Nitratos Antimoni Plomo Niquel Mercurio Cromo Cobre Cadmio Arsenico Selenio Benzeno 1 2 Dicloroetano Bromatos Nitritos Nitratos Cianuros Boro Benzopireno 2 Totales GH Guardar VP Revisi n ortogr fica Z X Eliminar gt EH M s UGL UGL UGL UGL UGL MGL UGL UGL UGL UGL UGL UGL MGL MGL UGL MGL UGL ShortUni MGL Groupl Y Filtro Ordenar y filtrar Group 1 Group 1 Group 1 Group 1 Group 1 Group 1 Group 1 Group 1 Group 1 Group 2 Group 2 Group 3 Group 3 Group 3 Group 3 Group 3 Group 3 YZ Selecci n Y Avanzadas 7 Y Alternar filtro AT Ajustar al Cambiar 0 S O GIO IGIOIGIOIBGIOIBGIOIBIO OI OI O STEP 2 Write here the limits according your classification of interest such as guide values or gal limits These limits will be ed to classify data and create the agend in the map u formulario ventanas Ventana 50 5 25 20 1 50 2 10 10 10 3 10 0 1 50 50 1 0 001 e ox Reemplazar a Lg Selec
5. El El riu MAPA JE t KIM Z W S PR 25 A LLL SUE Editor og Query w w 0 e m _ _ Time Query Choose your time interval AE Begin date lunes 01 de enero de1900 End date mi rcoles 26de marzo de 2014 33 El E Parameter Query E Choose parameters a M SelectWells for Max Excel Repat Query Results wasaqa EL x i Sean fos pem eem TE ama os mons on om x s s s e 025006 20 evans meme savan eme conciso s Td im thi care a in this table pw com ma y C 118 006 i b JE El E Z A 7 m E ad E o aeu IE E Sia dE y k EN ection Z XSection Projected XSection Dae Without Profile le sx a CJ Es i T wh E CUN Uum AB P ga ets Identify in map COLA SOLA CPR1011 11 25 2010 T COLA Campa a COLA CUPS8D1 1 29 1998 I d COLA Campa a OLA CUPSSD7 7 7 1998 1 F samp es se CC e mr 2 1 12 Spatial Quimet instructions MIX Hydrochemical data analysis tools M Query 9 mnn A E Time Query Choose your time interval Time Query Choose your time interval Begin date lunes 01de enero de1900 v End date viemes 21de marzo de 2014 v Begin date lunes 01de enero de1900 v End date viemes 21de marzo de2014 v STEPS Define End Member or Select Wells for ix Exo Report Sample
6. QUIMET idee Velasco V 12 Tubau 1 4 V zquez Su e E 0 Alcaraz M 12 Criollo R 12 Serrano Juan A 12 Gogu R Gaitanaru D Fernandez Garcia D Sanchez Vila X Ag ncia Catalana de l Aigua d GHS Institute of Environmental Assessment and VVater Research IDAEA CSIC Jordi Girona 18 26 08034 Barcelona Spain 2 GHS Department of Geotechnical Engineering and Geosciences Universitat Polit cnica de Catalunya UPC Barcelona Tech Jordi Girona 1 3 08034 Barcelona Spain 3 IGC Institut Geol gic de Catalunya Balmes 209 201 Barcelona Spain 4 Technical University of Civil Engineering B dul Lacul Tei 124 020296 Bucharest Romania Please cite as Velasco V Tubau V zquez Su e E Gogu R Gaitanaru D Alcaraz M Serrano Juan A Fernandez Garcia D Garrido T Fraile J Sanchez Vila X 2014 Accepted GIS based hydrogeochemical analysis tools QUIMET Computers Geosciences CAGEO D 13 00373R2 GHS 2014 QUIMET Developed in the Department of Geotechnical Engineering and Geosciences and Institute of Environmental Assessment and Water Research IDAEA CSIC Grupo de Hidrologia Subterr nea ETCG UPC CSIC Barcelona Spain Available at http www h2ogeo upc es English software QUIMET ACADEMIC index htm GUIDELINE 1 Installation 2 instructions 2 1 Spatial QUIMET instructions 2 1 1 Get to the application layer 2 1 2 Select Featur
7. TEMP GC pH T 7 20 TAC mgiL CaCO3 DUR mg L CaCO3 S Petri as 7 e eit 666 4 TSD mgiL Mo existe dato Mo existe dato No existe dato No existe dato WE existe dato No existe dato sumaniones 632 3 14271 12585 f f CCC Q l 964 8 8818 x sumeationes 280 1000000185 EE sei 3 gt SSS Ge EE GE SE E ee Ll mea aa E E E S O CI NO3 Nae K 164 2 583 8 493 8 3616 314 4 219 8 43 1000000030 393 7 333 1 287 36 AT s mene 222 855 Serrano Juan et al 2013 GHS 2013a 2 1 12 Spatial Quimet instructions MIX Hydrochemical data analysis tools 2 1 12 MIX QUERY STEP 1 Select points to query in the map and define the Begin date lunes 0lde enero de1900 lt End daie viemes 21de marzo de2014 temporal interval query emical parameters to query de Date Param Units ar a s s a nwt El Campa DANO CUPOGT 11 2006 was ees A UN enti NN RN STEP 3 Select data to e W EJ Campaign3 DANO_CUP9710 ane OS a analysis with MIX look O O mm I CC Ru at the following slides Em O Na ne mam reenn EGO CUM 400 8587 Mes UG mm Ulo ama EO PS 4207087 Qmm pm al amagat OO cursan 20866 Mes 8 po W n aa EA vam Owe GNI em Carrera et al 2004 Serrano Juan et al 2013 GHS 2013b 2 1 12 Spatial Quimet instructions MIX Hydrochemical data analysis tools STEP 3 Select data to analysis vvith MIX
8. Computing and recording the data ss Filling up the rest of the tables This can be done by using Excel Access ArcCatalog DB_ChemSamples DB_LibChemParameters DB_LibChemParamLab DB_LibChemParamNorm DB_LibEntities DB_LibNorm DE LibPointType DE Libliniquelnits DB LibUnits DE PiezoMeasurements DB Points Shape Index DB points table DB PointsHasLibPointType DB Project DB References DB WellsDescription HE Datesamp SCO1 SCOI1 SCOI1 5 01 SCO1 SCO1 SCOTI SCO1 SCOI1 TXAL TXAL TXAL TXAL TXAL TXAL TXAL TXAL TXAL TXAL TXAL TXAL PRUEBA IdChemsamp 24 10 2001 SCO1 CAG0110 005 18 12 2002 SCO1 CAG0212 003 04 02 2003 SCO1 CAG0302 001 26 03 2003 SCO1 CAG0303 003 25 06 2003 SCO1 CAG0306 002 26 08 2003 SCO1 CAG0308 003 25 09 2003 SCO1 CAG0309 002 23 12 2003 SCO1 CAG0312 002 26 03 2002 SCO1 CAG0203 003 29 01 1998 TXAL CUP9801 021 15 10 1998 TXAL CUP9810 036 09 10 1998 TXAL CUP9810 024 07 07 1998 TXAL CUP9807 021 05 05 1998 TXAL CUP9805 008 29 10 1997 TXAL CUP9710 015 29 04 1997 TXAL CUP9704 014 29 01 1997 TXAL CUP9701 002 13 12 2006 TXAL CUP0612 16 11 2005 TXAL CCL0511 28 01 1999 TXAL CUP9901 021 16 11 2004 TXAL CCL0411 3 3 Computing and recording the data Campa a Campa a Campa a Campa a Campa a Campa a Campa a Campa a Campa a Campa a Campa a Campa a Campa a Campa a Campa a Campa a Campa a Campa a Campa a Campa a Campa a 3 3 Computi
9. Es E EL Et X zu xx Param_Min 7 9 4049 72 4049 72 8091 54 8091 54 12133 36 9 12133 36 16175 18 16175 18 20217 New Lyr Teo shape tarot Param Mm Param Max Param Ava Param sta sospes mom 8 mt Tae sano d ton musowe za sat cremen 3152546 a s Point usissonse eo 4172 15855977 a Point ost 646 27293 837 898537 823202065 MS HER HLI i ETES 22 10723 2 BIC IC II rsr NI a W L T son Rasa total ral 044664 96 9767 si BT res sss e rs L to Pom Danang s 2062 1425792657 24102977 L 11 Pont CI II sre I CI IC L 12 Point fonos 5 78 sent lames 1586 50 Tre 01698 1278028081 I 74 Pom Tanza 1105 20632 38328233 408 578991 2 1 10 Spatial Quimet instructions Geostatistical Analysis Tools ArcGIS QUIMET 10 0 SO F be 5X eO M fc Explore Data dy Geostatistical Wizard 5 Subset Features 2 Tutorial About I se Disi Weighti Inverse Distance Weighting IDW is a quick deterministic interpolator that is exact There are very few decisions to make SET EE Parameters It can be a good way to take a first look at an interpolated there is no surface However assessment of prediction errors and IDW can produce bulls eyes around data locations There are no assumptions required u t Learn more about Inverse Distance We
10. 0001 AbrVariable 433856 6737 433856 6737 433856 6737 433856 6737 433856 6737 433856 6737 433856 6737 433856 6737 433856 6737 431168 0201 4584641 892 4585562 009 4583038 996 4587270 4588499 284 4588499 284 4589976 412 4589039 997 4589039 997 4586378 58 458603 8 58 45803 8 58 458603 78 58 45803 78 98 45863 78 58 45863 78 58 4586378 58 4584621 35 156 207 215 214 228 Clorurs 203 w 209 w 211 w w w w w 153 w 142 152 137 156 163 151 Data file only contains samples with measurements for each Of all selected parameters Only chloride has been measured Sodium measurement does not exit Remember both files can be generated also from Spatial QUIMET vvith Hydrochemical data analysis tools 2 2 1 Statistical Quimet instructions Interface we a QUIMETIO n rem E File Settings Tools Database Help El Node0 ACA 20130 Quimet Tools STEP 8 With Data xls or Data w xls Excel files different statistical analysis can be performed with these commands pen A spatial tool to analyze the spatial distribution of hydrochemical parameters Query interogate the DataBase i E I i L Univariable Analysis Coefficient R2 Matrix Correlation Graphic I Bivariable Analysis Geostatistical Quimet LE SE H lt 9 fal Za Non eactive mixture Organical Chemistry u ir t 3l NE 2 2 2
11. 2 Follow the vvizard Select Installation Folder The installer will install U UIME T T US eup to the following folder To install in this folder click Next To install to a different folder enter it below or click Browse Folder C GHSTools QUIMET 10 Browse Install QUIMET10Setup for yourself or for anyone who uses this computer gt Everyone 1 QUIMET 10 Installation STEP 3 Confirm installation Contirm Installation The Installer is ready to install GUIME T T US etup an your computer Click Nest to start the installation STEP 4 Installing 3j QUIMETIOSetu za ces JE QUIMET10Set Installing QUIMET10Setup C ay QUIMET1DSetup is being installed Please wall QUIMET105etup has been successfully installed Click Close to exit Please use Windows Update to check For any critical updates to the NET Framework COMPLETE Installation 1 QUIMET 10 Installation STEP5 Open ArcMap Attention With Windows 7 ArcMap must be run As Administrator just the first time for installing Quimet 10 Toolbar STEP6 ArcMap tools customize pem paper PELLEN carton BERNER oo AA EUR Toolbars Extensions Add In Manager me Manapa ArcMap Options Table Of Contents RX ArcToolbox a als E El Bi ArcToolbox EH El 3D Analyst To Egi Analysis Tools 1 83 Cartograph
12. 58 709 UP0609 mg 14 DANO 29 01 2003 Campa a DANO CCL0301 431168 0201 4584621 35 123 TXAL Violeta TXAL CU 13 12 2006 Cloroform CHCIS3 microg l 15 DANO 08 11 2006 Campa a DANO CUP0611 431168 0201 4584621 35 94 HRS EA SII m m woh TH aa T mp oe O soso vim eo m ml E ais er na a s s CI m E 08003 0023 080030029 200 9 25 2007 Nitrats 81 4 Create R IF Report This Excel file can be used also for a further geostatistical analysis vvith Statistical Quimet tools 2 1 9 Spatial Quimet instructions Hydrochemical data analysis tools D Create parameter distribution maps al Query ela fe Time Query Choose your time interval Begin date lunes 01de enero de 1900 End date domingo 04 de noviembre de 2012 Easy Quim Analysis Generate Easy Qum Excl Report STEP 2 Click D 1 Number of samples for selected parameter 08015 0016 aa mass e 08015 0029 201 DIM NN ar TS 7 080004 OS 08019 0014 201 5 21 2010 m 7 Dm NM er e a vj08019003 OS 080190037 19 1 26 1994 Oone 5627 mg Wiomsos fos asma 9 2 1085 Oos MS DL EZ O O See n ON ente RTE Besen Crese Erce Reron cession cmo s 4 LJ 2 1 9 Spatial Quimet instructions Hydrochemical data analysis tools D 1 Number of samples for selected parameter E nosampmap_3 SamplesMr Example map repres
13. 821E 02 1 661E 02 1 841E 02 1 11 78 57 8 1 700E 02 1 881E 02 1 700E 02 1 880E 02 1 12 85 71 9 1739E 02 1 700E 02 1 739E 02 1 720E 02 0 12 85 71 10 1 778E 02 1 739E 02 1 778E 02 1 759E 02 0 12 85 71 11 1 818E 02 1 778E 02 1 818E 02 1 788E 02 1 13 92 86 12 1857E 02 1 818E 02 1 857E 02 1 83TE 02 1 14 100 00 2 2 6 Statistical Quimet instructions Coefficient R2 Matrix Generated an Excel file named CoefficientR2Matrix xls with R2 coeficient Bicarbonats Sulfats Clorurs Nitrats Sodi Potassi Calci Magnesi Bicarbonats Sulfats Clorurs 2 2 7 Statistical Quimet instructions Correlation Graphics Generates an Excel file named CorrelatioGraphic xls with correlation graphics i i m E i L E i d E Hi 2 2 8 Statistical Quimet instructions Bivariable Analysis Covariance Matrix General Univariable Analysis Correlation Matrix Coefficient R2 Matrix Univanable Analysis Correlation Graphic 1 400E 04 Calci Sodi 1 200E 04 1 00E 04 amp OOE 03 sadi 6 ODE D3 4 DET y 3 266E400x 2 746E 02 R 3 223E 01 2 DOE U3 0 00E 00 0 000E 00 2 000E 02 4 000E 02 6 000E 02 8 000E 02 1 000E 03 calci Generates an Excel file named BivariableAnalysis xls with correlation graphics for each pair of selected parameters idvariable nom ariable unitats ariable Abr zariable nomar unitates ar
14. AB BDN1 AD RILIE 401123 401123 ADBURI ADCATA ADESPA ADESPA ADESPA ADMD3 ADMDS ADMETR1 ADMINS ADPKON ADPKON ADPKON ADPKON ADPRKONS ADPKONS ADPKON ADPKON ADPRORNA ADPKON ADPKON ADPKON ADPKONS ADPKONS ADPL ADPM Calci Talci 1 4 380E 01 1 275E 02 1 281E 02 1 147E 02 1 254E 02 1 S97E 02 4 15857E 01 2 660E 01 1 299E 02 2 356E 02 2 328E 02 1 S79E 02 4 423E 02 1 S10E 02 1 242E402 1 S86E 02 1 288E 02 1 457E 02 1 140E 02 1 761E 02 1 S56E 02 1 481E 02 1 764E 02 1 S90E 02 1 S50E 02 1 S80E 02 1 210E 02 B 890E 01 1 365E 02 Sodi Sodi 1 853E 01 1 907E 02 2 B30E 02 2 529E 02 2 958E 02 2 4 64E 02 1 982E 02 1 788E 02 1 711E 02 2128E 02 1 814E 02 2 4B1E 02 1 785E 03 2 S80E 02 2 B41E 02 2 781E 02 2 670E 02 2 B7BE 02 2 B29E 02 2 345E 02 2 406E 02 2 730E 02 1 24 8E402 1 830E 02 2 220E 02 2 B 7E 02 2 581E 02 2 488E 02 2 624E 02 3 Database 3 1 General scheme of the database 3 2 Description of data contained 3 3 Entering the data Imagen de http ocw uoc edu informatica tecnologia y multimedia bases de datos Course_listing 3 1 General Scheme of the Database 1 7 T LibChemParamHorm 1 ChemSamples Measurements a ae UniqueUnits idNorm idChemSamp codParam TER gt burak leh iciuni dPoromNorm bait giou vids shortUnits iclUnits nam nits imbaxNorm mmLRatio imblinNarm ceteclim meth nal clasPoramLab
15. Export RTF Report Export Excel Report STEP 1 Click over the point you want to query The point does not have to be selected Modify Visualize data from existing points stored in the database a Load data EE Point Identification ID EE Observation Type GWP punt d aigua sub S Owner Campaign and Samples Campaign Sample Observation Sample 080150023 20110523 PO Date 23 05 2011 A gu T e E TE rase Load XV LiataDase aramelers Choose your parameter Unit of Value measurement Save STEP 2 This window contains the data stored in the database for the point The user can modify add properties champaign E 2 1 8 Spatial Quimet instructions Load data Hydrogeochemical data Edition Tools 2 1 8 LOAD DATA AND IDENTIFY POINT ad Load data Po m ID P3 EJ STEP 1 Click here to edit point type owner observations Campaign8 ki Sample Observation aa CCLD STEP 2 Edit data for field campaign and x add new campaigns E ai Date lalamen A e F STEP 3 Click herelll to edit already I Campaign introduced values and to add new measurements STEP 4 Select parameters to add edit STEP 5 Edit add values for each parameter Farameter Walue Save ME a A rl and sample STEP 6 Save your edits 2 1 9 Spatial Quimet instructions Hydrochemical data analysis tools Query temporal evolu
16. IdParamLab From DB LibUniqueUnits Parameter detection limit Double NO Parameter Analysis Methodology Text 30 YES from DB ProcessUsed where IdProcUsedClass is ChemAnal DB LibChemParameters field IdParam M 1 DB LibEntities field IdEntity M 1 DB LibUnits field ShortUnits M 1 DB LibProcessUsed field IdProcessUsed M 1 3 2 10 Description of DB LibChemParametersLab 2 2 NAME OF THE FIELD DESCRIPTION FORMAT RELATIONSHIPS Clas1 4 ParamLab IdRef Observations Obsinput NumbReg Classification parameter 1 4 by lab IdRef of the document that contain the details of the analysis methodology nomenclature etc of the parameter e g protocol established by the laboratory Observations Observations of the person that introduce the data into the database Autonumber Text 30 NO Text 50 NO Text 80 NO Text 160 NO Autonumber DB References field IdRef M 1 3 2 11 Description of DB LibNorm 1 1 NAME OF THE FIELD DESCRIPTION FORMAT RELATIONSHIPS IdEntity NamNorm Date Observations Obsinput IdRef NumbReg Entity Agency organism that has developed or applied the normative Id from DB_LibEntities Name of regulations guidelines etc Date of regulations guidelines etc Observations Comments and or clarification of the guidelines etc Observations of the person that introduce the data into the database IdRef of the do
17. Sample Date Param mmolL Value Units H ia Mecca TEP 7 Export results from the de query to 2 Excel Files Data xls nni Data w xls Pay Attention Do not rename these files Othervvise the statistical analysis will not work properly 2 2 1 Statistical Quimet instructions Interface Data File AbrVariable Clorurs PUNT a CTO CSS CO SA ATT FRIG ET 1 2003 GELA 09 10 1996 HI BORI 23 11 20 10 MONT 24 09 2006 PUIG 19 12 1996 PUIG 24 10 2006 SANS 03 03 1998 SCO1 20 11 1997 SCO1 27 09 2006 Data vv File COLA COLA COLA COLA COLA COLA COLA COLA COLA DANO Data_w file contains all samples including incompleted samples samples without measurements 07 07 1 1998 09 10 1998 28 01 1999 25 11 2010 09 10 1998 25 11 2010 29 01 1998 28 01 1999 29 10 1997 FRIG CCLO301 GELA CUP9810 010 HI BORI CPR1011 MONT_CUPOGOS PUIG CUP9612 015 PUIG CUPOG1O SAN3 CUP9503 005 SCO1 CUPS711 005 SCO1 CUP0609 COLA CUP9801 003 OLA CUPS807 004 OLA CUPSS1I0 004 OLA CUP9901 014 OLA CPR1011 OLA CUPSS10 004 OLA CPR1011 OLA CUP9801 003 COLA CUP9901 014 DANO CUPS710 010 See ee a lC ES for each of all selected parameters Further queries can be carried out with this file but taken into account that analysis that require completed samples vvill not be performed 432962 0663 431795 2061 428048 8079 433630 0011 433624 0783 433624 0783 432525 5449 433660 0001 433660
18. Statistical Quimet instructions General Univariable Analysis General Univariable Analysis Correlation Matrix Covariance Matrix Univariable Analysis Coefficient RA Matrix Correlation Graphic Bivariable Analysis Generates an Excel file named GenUnivariableAnalysis xls with the following results Bicarbonats Sulfats Clorurs Hitrats Sodi Potassi Calci Magnesi CE n 88 88 88 88 88 88 88 88 88 Y qi 4 li tica e 378 67 375 68 1339 95 72 44 746 65 32 41 185 48 124 85 4217 83 desviaci estandar de la poblaci 104 04 817 21 4172 16 49 23 228510 78 24 146 37 284 66 0856 12 ACT pun 76 43 369 71 2072 90 36 68 111506 39 39 75 16 142 75 4984 82 MH E Img 1082523 66783034 1740692304 242377 5130868004 611648 2142541 8103281 9714319285 desviacio estandar de la mostra 104 64 821 89 4196 07 49 51 2278 08 7866 14721 286 29 9912 61 kaa INN NC 1094966 675506 55 17607002 62 245153 518965337 618678 2167168 8196422 9825978127 cdd 20 13 5 00 20 00 0 60 1170 1 00 26 32 6 09 239 00 kasa in sca 136 23 99 75 31 67 66 56 450 136 88 34 00 1173 75 mapasa prem uapa 405 04 167 15 122 50 70 80 84 33 7 55 148 97 45 58 1337 00 3er quartil percentil 75 dl 44170 219 25 206 25 94 25 139 25 19 00 169 90 60 25 1562 50 580 72 4650 00 19943 00 233 60 11310 00 36700 1080 00 1327 00 47420 00 curtosi pm 252 19 38 12 44 0 89 13 20 11 22 19 47 12 10 11 98 coeficient d asimetria 434 4 43 370 078 37 353 408 366 363 int rval de confian a de 95 per la mit
19. appears in ArcMap ready to uselll Georeferencing Geostatistical Analyst Graphics Image Analysis Image Classification Labeling Layout Main Menu Map Service Publishing Network Analyst Parcel Editor Publisher Quimet 10 0 Rename Delete QUIMET 10 0 File Settings Tools Database Help eg Node Quimet Tools Spatial Quimet ETT NETTES s Interogate the DataBase Quimet 10 Toolbar in ArcMAP Also a shortcut to Statistical QUIMET has been created in your desktop 2 1 Spatial Quimet ArcGIS Tools instructions 2 1 1 Get to the application layer 2 1 2 Select Features 2 1 3 Draw SALINIT Y diagram 2 1 4 Draw Sch ller Berkaloff diagram 2 1 5 Draw Piper diagram 2 1 6 Draw Stiff Diagram 2 1 7 Get lonic Balance 2 1 8 Load Data and identify points 2 1 9 Hydrochemical data Analysis Tools 2 1 10 Goestatistical Analysis Tools 2 1 11 EASY QUIM 2 1 12 MIX 2 1 13 Regulatory Parameter Query 2 1 1 Spatial Quimet instructions Get the application layer ArcGIS tools JUMET 10 0 Y x 2 1 1 GET THE APPLICATION LAYER E be FB m 8 M Geostatistical Analyst Help DB_Campaign M DB ChemMeasurements X WM DB_ChemSamples DB_LibChemParameters DB_LibChemParamLab ESIDB LibChemParamNorm DB_LibEntities DB_LibNorm DB_LibPointType 4 T Name DB Points DB LibUniqueUnits GCoordSystem DB PiezoMea
20. for each point See MIX manuals ARA STEP 4 Click here to A activate MIX Selection Sea A Deseiect AI odd Well En mm s s s Rara nmm e un 0 ETA 10 29 1997 L 10 29 1997 Param SENE ld Well Campaign Sample Date _ Mix Sample Wm et Mxocmun Ba m HM mesi home unes r Fm eran Ejes eee RR 520200 En Menter Ejes amat MAQU CUP 7S naa Ele mas ancians E Ejes eee UG cue ava y Ep fema Pu curser zs y Bleo eee apan rose y Era een RR temen y Em er IO e o Date 1 8 2006 1 8 2006 pano nans 1291 DINO cuesri waste puo mo avum 4 30 1997 4 30 1 29 1 EXPO CPR1011 11 24 2010 EXPO_CUP9704 Nitrate Sj S IS S S 321313 EJE oro co Tara ane eee naa Hid da ma mae a sA w D M w ame nr o 0 0 N N N im Mix Analysis STEP6 Click Mix Analysis to open MIX file 2 1 12 Spatial Quimet instructions MIX Hydrochemical data analysis tools Cl y d MIX QUIMET xlsm Microsoft Excel Vista 64 amp Calibri Ajustar texto qe tg a tW DE Lum AF Revisar Br Rellenar mm y i M A S bid Combinar y centrar Of ml 499 Formato Darformato Estilos de Insertar Eliminar Formato Orden T 3 I condicional como tabla celda T T T amp Borrar 7 y filtrar Portapapeles Fuente E Alineaci n x N mero Estilos Celdas Modifica
21. 2 1 5 DRAVV PIPER Dravv Query Piper diagrams Begin date viemes 11 de julio de 1997 vl l End date lunes lide julio de 4011 E Point ID Date I Same mechanism as SALINITY DIAGRAM and Sch ller Berkaloff Look at previous slides STEP 3 Two Options A Piper diagrams for different dates at the same point B Piper diagrams for different points with just one date for each one c 2 1 5 Spatial Quimet instructions Piper Hydrochemical diagrams tools Piper report and diagram Ca cl E cations anions cations anions V DANO X PUIG 8 TAL Y MONT X FRIG V 24 10 2001 X 23 10 2003 27 10 2004 26 10 2005 _ 24 09 2006 A Piper diagrams for B Piper diagrams for different different dates at the same points with just one date for point each one 2 1 6 Spatial Quimet instructions Stiff Hydrochemical diagrams tools 2 1 6 DRAVV THE STIFF DIAGRAM ww a so 0 w v Create Report Create Map Select All 9 91 Deselect All Query and create maps where Stiff diagrams are located in the space STEP 1 Select temporal interval query STEP 3 Two Options i A Draw Stiff diagrams for different dates at the same point Draw Stiff diagrams and create maps with the diagrams for different points with just one date for each one e dd gJ I 2 1 6
22. Convert Features to Graphics EXAMPLE 3 ArcCatalog al ArcCatalog ArcInfo C Users ord1471 Documents PROYECTOS ACA 05042013 BBDD HydorDBACAejemplo mdb DB_Points Edit View Go Geoprocessing Customize Windows Help lel El Eel gg D pr Location CAUserstord 1471 Documents PROYECTOS ACA 05042013 BBDD HydorDBACAejemplo lt BRB else BB x E E C Users ord1471 Documents ARTICULOS QUIMET datos E CilUserstordidTliDocumentsi Basededatos El Ca Userord14711Documents PROYECTOS E E 05042013 E El BEDD E L3 HydorDBACAejemplo mdb IH Relationships DB_Campaign DB ChemMeasurements DB ChemSamples DB Gravel DB LibChemParameters DB LibChemParamLab DB LibChemParamNorm DB LibEntities DB LibNorm DB LibPointType DB LibUniqueUnits DE LibWellStatusCode DB PiezoMeassurements DB Point Table RO DB Poig DB Poi DB Pro X Delete DB Pi DB Ref DB Ser lt Create Layer DB_We Errores IE Para Modifit Modifie Piper P SAR Pa SB Par Stiff Pa L3 HydorDBACA Librol csv ES 18 02 2013 ACA 4 11 12 QAN cs Oly Contents Preview Description STEP 1 ArcCatalog STEP 2 Click DBPoints and Load data STEP 3 follow the wizards Register with Geodatabase Compress File Geodatabase Uncompress File Geodatabase Upgrade Spatial Reference RA Review Rematch Addresses Load XML Recordset Document 3 3
23. Fields required for using QUIMET tools 3 2 4 Description of DB References 1 2 NAME OF THE DESCRIPTION FORMAT RELATIONSHIPS FIELD IdRef Unique identifier foreach Text 50 YES DB Points field IdRefNam1 1 M IdRefNam2 1 M reference example EU IdRefNam3 1 M IdRefNam4 1 M IdRefCoo 1 M IdRefZ 9985569 02 European 1 M Project Code DB LibChemParamLab field IdRef 1 M DB LibChemParamNorm field IdRef 1 M DB ChemSamples field IdRef 1 M DB Campaign field IdRef 1 M DB ChemMeasurements field IdRef 1 M DB LibNorm field IdRef 1 M DB Projects field IdRef 1 M ShortDesc Short description of the Text 200 NO reference with information such as title of the document file s name etc This table acts as a library of terms if the reference of the source of information document paper is already included you do not need to add a new term FormRef Format of the source of Text 50 NO information oral paper digital website digital CD digital file dropdown list 3 2 4 Description of DB References 2 2 NAME OF THE DESCRIPTION FORMAT RELATIONSHIPS FIELD SearRef Document s location Text 50 NO where it can be available and or who can facilitate it E g file path in your computer Observations Additional data Text 80 NO Obsinput Observations of the Text 240 NO person that introduce the data into the database NumbReg Autonumber Text 50 NO You should chang
24. Model Nugget Enable Calculate Nugget Mugget Measurement Error E Model 1 Type Parameter Anisotropy Calculate Partial Sill Partial Sill Model 2 Model 3 El Lag Lag Size Mumber of Lags True True 258723 5 100 Yo Stable 0 2 False EH El more gt Kriging is an interpolator that can be exact or smoothed depending on the measurement error m Geostatistical wizard Kriging step 4 of 5 Searching Neighborhood Dataset E Search Neighborhood Neighborhood type Copy from Variogram True Maximum neighbors 5 aa 8 Ql gt E yl lt El Dataset Type Data field Records El Method Type Output type El Dataset Trend type Type Neighbors to include Include at least Sector type Angle Major semiaxis Minor semiaxis Pra 10 0148 110 0029 9 10 0140 80 Clorurs Min 2 P Location C Users malcaraz Desktop Quimet_General EasyQuim bin Debu El Searching neighborhood Clorurs_Min_2 Feature Class Param_Std 15 Kriging Ordinary Prediction 1 None Standard Standard 5 2 Four and 45 degree 0 3668 4406769089246 3668 4406769089246 Semivariogram 10 0136 2 1 11 Spatial Quimet instructions EASY QUIM Hydrochemical data analysis tools 2 1 11 EASY QUIM QUERY QUIMET 10 0 Time Query Choose your time mterval Begin date Easy Qui
25. Spatial Quimet instructions Stiff Hydrochemical diagrams tools A A Dravv Stiff diagrams for different dates at the same point al Stiff Diagram viemes 11de julio de 1997 lunes 11de julio de 2011 STEP 1 Select u a AC Select All Deselect All Close Click here to create the map 2 1 6 Spatial Quimet instructions Stiff Hydrochemical diagrams tools B Dravv Stiff diagrams and create maps vvith the diagrams for different points vvith just one date for each one x XX viemes 11de julio de 1997 End date lunes 11de julio de 2011 STEP 1 Select Stiff Diagram size 1 28 Yi et STEP 2 Create maps with the Stiff diagrams with their dates for each selected point Select All Deselect All STER 3 Create diagrams and value parameters table for each selected point gt 2 1 6 Spatial Quimet instructions Stiff Hydrochemical diagrams tools STEP 2 Create maps with the Stiff diagrams with their dates for each selected point E Layer E El O Users malcaraz Desktop Quimet General El TempSTIFF 1 3 ids we p ds ES rly th E Stiff General Source Selection Display Symbology Fields Definition Query Labels Joins amp Relates HTML Popup diagrams check the properties Draw al features using the same Sj moot for tempStiff layer properties gt Symbology gt feature gt single s
26. Univariable Analysis Generates an Excel file named Univariable xls with spreadsheets for each parameter containing several statistical basic analysis Diagrama de caixa Variable percentil 75 maxim minim percentil 25 Sodi 2 mmolL 1633E 02 1 857E 02 1 425E 02 146 70 2 DODE O2 ldVariable 0 nomV ariable 0 UE AbrVariable Sodi 1 BOOE 02 unitats Variable 2 mmolL n 14 1 400E 02 mitja aritm tica 1 572E402 desviaci est ndar de la dE poblaci 1 352E 01 1 000E 02 desviaci promitja 1 303E 01 varian a de la poblaci 1 698E 02 8 000E 01 desviaci est ndar de la mostra 1 552E 01 ee 1 425E 02 varianca de la mostra 1 829E 02 maxim 1 857E 02 minim 1 425E 02 max min 4 320E 01 ter quartil percentil 25 1 467E 02 n m classes 42 max 12 mitjana percentil 50 1 541E 02 mn di 3er quartil percentil 75 1 633E402 X maxim 1 85 E 702 Classes Interval promig interval Frequencia Frequencia acumulada Acumulat 2 mmolL i its 2 543E 01 1 1 425E 02 1 425E 02 1 425E 02 1 1 7 14 coeficient d asimetria 1 029E 00 2 1 4646 02 1 425E 02 1 464E 02 1 445E 02 3 4 28 57 int rval de confian a de 95 per 3 1 504E 02 L 1464E 02 1 504E 02 1 484E 02 1 5 35 71 la mitjana de la poblaci T 084E 00 4 1 543E 02 1 504E 02 1 543E 02 1 523E 02 2 7 50 00 5 1 582E 02 1 543E 02 1 582E 02 1 582E 02 3 10 74 43 8 1621E 02 1 582E 02 1 821E 02 1 802E 02 0 10 71 43 T 16651E 02 1
27. alue 2 gt que LimMinNorm Double NO for a given paramater for a given normative it will used with Regulatory Parameter Tools 21 3 2 12 Description of DB LibchemParametersNorm 2 2 NAME OF THE FIELD IdProcessUsed Clas1 4ParamNorm IdRef Observations Obsinput NumbReg DESCRIPTION Unique identifier of the Parameter Analysis Methodology from DB ProcessUsed vvhen IdProcUsedClass is chemAnal Parameter classification 1 4 for a given legislation Reference ID from the table DB References about documents legislations rules etc Observations Comments and or clarification of the guidelines normative Observations of the person that introduce the data into the database Autonumber FORMAT Text 50 NO Text 30 NO Text 50 no Text 80 NO Text 160 NO Autonumber RELATIONSHIPS DB_LibProcessUsed field IdProcessUsed M 1 DB_References field IdRef M 1 3 2 13 Description of DB LibChemSamples 1 2 NAME OF THE DESCRIPTION FORMAT RELATIONSHIPS FIELD IdPoint DateSamp IdChemSamp IdCampaign NameField SizeSamp DepthMeas IdProcessUsed IdResponsibleEntity Unique identifier for each point IdPoint from DB Point Date of sample collection Unique identifier for each sample Ej NamePoint Entity monthyear n9sample 08004623 UPC1205 015 Campaign Id from DB Campaign Name of the sample in the field before to send it to the la
28. b Size of the sample Depth m where sample was obtained Sampling Methodology from DB ProcessUsed where IdProcUsedClass is ChemSamp Person responsible of sample collection Entity ID from DB References table Text 30 YES Fecha YES Text 30 YES Text 50 NO Text 30 NO Text 50 NO Double NO Text 30 NO Text 10 NO DB Points field IdPoint M 1 DB ChemMeasurements field IdChemSample 1 M DB Campaign field IdCampaign M 1 DB LibProcessUsed field IdProcessUsed M 1 DB LibEntity field IdEntity M 1 Fields required for using QUIMET tools 3 2 13 Description of DB LibChemSamples 2 2 NAME OF THE DESCRIPTION FORMAT RELATIONSHIPS FIELD IdRef Reference ID from the table DB_ References Text 50 NO DB References campo IdRef M 1 Observations Observations Comments and or clarification Text 80 NO Obsinput Observations of the person that introduce the Text 160 NO data into the database NumbReg Autonumber Autonumber 3 2 14 Description of DB_LibChemMeasurement 1 1 NAME OF THE DESCRIPTION FORMAT RELATIONSHIPS FIELD IdChemSamp IdParam DateMeas Value CompValue IdLabEntity IdRef Observations Obsinput NumReg Sample ID from DB ChemSamples table Unique identifier for each parameter Date of laboratory field analysis Result numeric value censored values which are the concentrations of some elements reported as non detec
29. ce Matrix 2 2 5 Univariable Analysis 2 2 6 Coefficient R2 Matrix 2 2 7 Correlation Matrix 2 2 8 Bivariavle Analysis Statistical Quimet instructions Interface p a QUIMETLO n File Settings Tools pl AG we STEP 1 Connection to geodatab El Nodel Connect to database ma Quimet Tools Spatial Quimet wa Q Open lt Ejea idrochemical parameters g k lt QUIMET ACA 15 02 12 49 Organize w New folder w Favorites E Documents library Arrange by Folder T y Deskt ACA 15 02 12 BE Desktop Covariance Matrix W Downloads K ACA DB 2 Dropbox lI VIO ACA 15 02 12 Correlation Graphic L El Recent Places A 9 H W A A G a Libraries ES Documents a Music El Pictures El Videos ed Homegroup da Computer w E File name VIO ACA 15 02 12 Access Files mdb z These tools work outside ArcGIS However the Excel files Data xls obtained with Hydrochemical data analysis tools can also serve as input file for statistical analysis 2 2 1 Statistical Quimet instructions Interface ica Bacca ae S EE E Opens ArcGIS where Spatial Lu Quimet Tools QUIMET toolbar Quimet 10 0 is Click available mes eea MET The Statistical QUIMET Interface menu is available from your desktop through the shortcut and also through the Quimet 10 0 Toolbar in ArcGIS QUIMET 10 0 SO F s OG A S Qe Click O
30. cio Buscar t LimMinNorm LimMedNor LimMaxNori Proces 10 50 50 2 1 13 Spatial Quimet instructions Regulatory parameter analysis tools b Create RTF Report dE Query M Time Query ER s f Chasse yen maten Generates a word report with specified query Begin date s bado 17de febrero de 1990 y Enddate viemes 17de febrero de2012 y Submit Parameter Query Choose parameters pasoa Bene B Es Ire Cloroform_CHCI3 Tricloroetile gt gt lt lt Substincies del GRUP S gt Query Report Bromoform Clorobenze Qey Results Area Delta del Bes s E ee Date 15 02 2012 14 23 26 Id Well Campaign Sample Dx b iv DANO DANO CUP0611 08 2 EM EE DS P Tm ns IV MONT MONT CUPOG09 24 udi UPC2000 BOLO C 23H0 2006 Cloroform CHCI3 T ss Create RTF Report UPC2000 TXAL_CU 13 12 2006 Cloroform CHCI3 5 75 microg P0612 UPC2000 ANO C 08 11 2006 Tetracloroetile 296 38 microg UPC2000 POLO C 23 10 2006 Tetracloroetile UP0610 UPC2000 131422006 Tetracloroetile 115 83 P0612 UPC2000 DANO C 08 11 2006 Tricloroetile 18 35 UP0611 POLO UPC2000 POLO C 23 10 2006 Tricloroetile microg UPO610 P0612 Fictitious limits have been chosen to illustrate the instructions of the tools 2 2 instructions Statistical QUIMET 2 2 1 Interface 2 2 2 General Univariable Analysis 2 2 3 Correlation Matrix 2 2 4 Covarian
31. cking the dates one by one 2 Click create graph gt Continues in Next Slide 2 1 3 Spatial Quimet instructions SALINITY Diagram Hydrochemical diagrams tools A Salinity diagram for different dates at the same point 829 SAR Report Visualize parameters values in a table SAR Diagram VeryHigh 4 SAR report and diagram SampleDat uS cm Ca meg Ma High 3 DANO 23 01 2003 945 0000 5 4450 2 4463 Medium 2 SODIO ADSORPTION RELATION SAR K 10 6 0300 8843 DNO ovis nma 6 CNC IN 4 NP N 2 1 E b aer Salinity diagram s 6 Low 1 Medium 2 8 8 10 0 100 0 1000 0 10000 0 ELECTRIC CONDUCTIVITY uS cm 29 01 2003 25 03 2003 12 11 2003 x 16 11 2004 2111 2005 08 11 2000 23 10 1397 Y 29 01 1998 05 05 1998 09 10 1998 x lt 26 01 1999 doe b D omo amam oeoo a Q2EG aaas pw 220 am em oem 0 me as wa w aa omo ama E sm um Na 3 5000 man 3 8174 Continues in Next Slide 2 1 3 Spatial Quimet instructions SALINITY Diagram Hydrochemical diagrams tools B Salinity diagram for different points vvith just one date for each one QUIMET 10 0 SO is amp 9 EES Q M Q Geostatistical Analyst Help lunes TT de jo de 2011 STEP 1 Click here to select date in the drop down list for each selected point Date Bj wer NL Z Rmn mmm DrwGegh STEP 2 Click here to create SALINITY dia
32. cument that contain the details of the guideline normative Autonumber Text 50 YES DB LibEntities field 1 M Text 5O Sl Date NO Text 80 NO Text 160 NO Text 50 SI DB References campo IdRef M 1 Autonumber This table acts as a library if the normative guideline details are already included you do not need to add a nevv term 3 2 12 Description of DB LibchemParametersNorm 1 2 NAME OF THE FIELD DESCRIPTION FORMAT RELATIONSHIPS IdNorm Unique identifier for each normative Text 10 YES DB LibChemNorm field directive etc IdNorm from DB LibNorm IdNorm M 1 IdParam Unique Identify for each parameter from Text 8 YES DB LibChemParameters DB LibChemParameters IdParam field IdParam M 1 ShortUnits Units of measurement for the parameter Integer YES DB LibUnits field defined by the normative guideline e g ShortUnits M 1 MGL Family Classification of the different parameters Text 255 NO following users defined normative criteria for its subsequent classification according to the threshold approach established by a given guideline normative it will used with This table acts as a library if the Regulatory Parameter Tools normative guideline details for a given LimMinNorm Threshold value 1 for a given paramater pabametelare already included you do for a given normative it will used with Regulatory Parameter Tools not need to add a new term LimMidNorm Threshold v
33. drochemical diagrams tools 2 1 4 DRAW SCHOLLER BERRALOFF DIAGRAM 1 Schoeller Berkaloff Diagram c3 Jn Begin date viemes 11 de julio de 1997 pad date lunes 11de jo de2 STEP 2 Click here to execute th 7 wire NS o d query Draw Query Sch ller Berkaloff diagrams J STEP 1 Select temporal interval query Same mechanism as SALINITY DIAGRAM Look at previous slides STEP 3 Two Options Steen A Scholler Berkaloff diagrams for different dates at the same point Scholler Berkaloff diagrams for different points with just one date for each one gt 2 1 4 Spatial Quimet instructions SCHOLLER BERKALOFF Hydrochemical diagrams tools 12 Schoeller Berkaloff Report Schoeller Berkaloff report and diagram Schoeller Berkaloff Report Schoeller Berkaloff Diagram Schoeller Berkaloff Diagram Ca Mg Na CI SO4 HCO3 X Axis gt 20 11 1997 O 24 10 2001 O 23 10 2003 O 27 10 2004 gt 26 10 2005 24 09 2006 A Sch ller Berkaloff diagrams for different dates at the same point al Schoeller Berkaloff Report Schoeller Berkaloff report and diagram Schoeller Berkaloff Report Schoeller Berkaloff Diagram Schoeller Berkaloff Diagram Schoeller Berkaloff Diagram Na CI B Sch ller Berkaloff diagrams for different points with just one date for each one 2 1 5 Spatial Quimet instructions Piper Hydrochemical diagrams tools
34. e RTF Report k Limits defined by user 2 1 13 Spatial Quimet instructions Regulatory parameter analysis tools a Create parameter map Generates a visualization of the chosen parameter classified in 4 intervals according to limits defined by the user and stored in the geodatabase please see following slides TON wld VGI VGA 195815 e E e gt VGA El co Mercuri ed 16 MAL3 PAGR Value DS VGNR DBIF VGNR val 195825 i TAL MAR_BCN1 e d P VGI VGA cuz gt vos a e El co Mercuri sd 15 GER e Value UCE POLO N ib vGNR 20 Bada e Fictitious data have been chosen to illustrate the instructions of the tools 2 1 13 Spatial Quimet instructions Regulatory parameter analysis tools a Create parameter map STEP 1 Open DB LibChemParametersNorm table in the geodatabase m P Inicio Crear X DB LibChemParamLab Parameter Query Fictitious limits have been chosen to illustrate the instructions of the tools 28 alla Datos externos Herramientas de base de datos Hoja de datos ben Tem fs ie se 2 V Pegar _ ab Actuali e Pegar jx as A 2 EET Masi Vistas Portapapeles Texto enriquecido e v 4 IdNorm IdParam juscar EXEWFD N480MGL Administration _ 82 EXDMA N130UGL Gi DB Campaign EXDMA N549UGL ee EXDMA N476UGL DB LibEntities EXDMA N447UGL A DB_tibNorm EXDMA N271UGL 3 DB ProcessUsed EXDMA N268MGL
35. e for different dates at the same point iJ Ionic Balance Report Report table Coord X lanic balance table vana m El mee esu o nes o Gm ES s Cox mma eenn sem Es Aniones mg l PEEL EN NEST NNI M ma mg l mgl mg sos aow amn mo fason SON Ck ww zooo exo ma 207000 Cationes Aniones Export RTF Report CC TC ITS ie nam pom ume freson mmo Gare mew meoo fisso aana Tara Mgr mamo atom ra ooo nos siamo IN mmm EE ma mg l mg l mgl ma 139 9000 168 7000 meq meq meq meq meq meos pse pey psm pee O mm oe sass eer sm MEME Lr xs a EN 0 1526 o Close Attention lonic balance can not be calculated if any major element is missing 2 1 7 Spatial Quimet instructions lonic Balance Parameter Calculator Tools B Calculate ionic balance for different points with just one date for each one ul Tonic Balance Report ll lonic balance table Report table Date P 08 11 2006 24 10 2006 13 12 2006 24 10 2001 ie ah 24 10 72 4 uen DANO PUIG TXAL MONT REGA GoordY na esie emo Gent asso em x ome w 7400 29506 x o sam zam EN mgl SS ES ma mg mg l mg mg l TT a 200000 C femo zumo me coo Tem on Cationes mg l mg l mg l mg l mg l mg CC a E ama 3220o Two options export a NT complete report m 7 diagram and parameters values to MSVVord or MSExcel
36. e identifier Text 10 YES DB Campaign field IdProject 1 M NamProject Project Name Text 200 NO IdRef Reference of the document Text 50 SI DB References field IdRef that contains the agreement M 1 proposal etc Id from DB References Observations Observations and or Text 80 NO clarifications about the normative directive etc Obsinput Observations of the person Text 160 NO that introduce the data into the database NumbReg Autonumber Auton mero 3 2 8 Description of DB LibChemParameters 1 2 NAME OF THE FIELD DESCRIPTION FORMAT RELATIONSHIPS IdParam CodParam ShortUnits NamParam Clas1 4Param The default language is catalan but the user has two columns to introduce the Parameter name in other languages e g Spanish or English Unique identifier for each Text 8 YES DB LibChemParamLab parameter Format N111AAA field IdParam 1 1 111 3 digit number AAA units DB ChemMeasurements field IdParam 1 M First part of the parameter Text 4 YES code composed of a capital letter and 3 numbers format 111 AAA abbreviation of units of Text 3 YES DB_LibUniqueUnit measurements formed by 3 field ShortUnit letters ID from DB LibUniqueUnits Parameter name local Text 100 YES language NO UNIQUE there are different measurement units for each parameter Different classification parameter pesticides industrial detergents 3 2 8 Description of DB LibChemParameter
37. e the texts format to hypervincle when necessary 3 2 5 Description of DB LibEntities 1 1 NAME OF THE FIELD DESCRIPTION FORMAT RELATIONSHIPS IdEntity Unique identifier for each entity laboratory Text 10 YES DB Points field IdOwnPoint company employees etc 1 M DB LibChemParamLab field IdLabEntity 1 M DB ChemSamples field IdResponsibleEntity 1 M DB ChemSamples field IdEntity 1 M NameEntity Entity s name Text 50 SI Address Entity s adress Text 160 NO ContactName Name and surnames of the contact person Text 160 NO ContactTelf Contact s telephone Text 40 NO ContactMail Contact s e mail Text 100 NO Observations Additional information Text 255 NO NumbReg Autonumber 3 2 6 Description of DB Campaigns 1 1 NAME OF THE FIELD DESCRIPTION FORMAT RELATIONSHIPS IdCampaign Unique indentifier for each Text 20 YES DB ChemSamples campo field campaign IdCampaign 1 M IdProject Unique identifier for each Text 10 NO DB Projects project related with the field field IdProject M 1 campaign StartDate Start date of the campaign Date NO EndDate End date of the campaign Date NO IdRef IdRef of the document that Text 50 YES DB References field IdRef contain the details of the M 1 field campaign Observations Additional information Text 160 NO Obsinput Observations of the person Text 160 NO that introduce the data into the database NumbReg Autonumber IdProject Project s Uniqu
38. enting number of samples for with measurements of the selected parameter for each queried well 2 1 9 Spatial Quimet instructions Hydrochemical data analysis tools D2 Min Max o average for selected parameter El Clorurs Min 4 Param Min d 7 9 4049 72 Z 4049 72 8091 54 8091 54 12133 36 12133 36 16175 18 16175 18 20217 Example map with minimum value for the selected parameter for each queried points This query generated shapefiles to carry out a geostatistical analysis 2 1 9 Spatial Quimet instructions Hydrochemical data analysis tools D 3 Create files for a further geostatistical analysis STEP 1 Select temporal interval query and parameters to analyse alike D 2 STEP 2 The created layer Lyr can be used to further statistical queries with Geostatistical Analyst DOM from ArcGIS Qaand E Clorurs_Min_4 a Query Time Query Choose your time interval Begin date lunes 01de enero de 1900 v Easy Quim Analysis Generate Easy Quim Excel Report Parameter Query Choose parameters CE 20 Clorfenvinfos sumatori Cloroform_CHCI3 End date domingo 04 de noviembre de 2012 08015 0023 201 5 23 2011 08019 0014 201 5 21 2010 08019 0014 201 5 5 2011 08019 0037 199 1 26 1994 08019 0037 199 9 21 1995 08019 0037 199 9 18 1997 08019 0037 199 9 21 1998
39. es 2 1 3 Draw SALINITY diagram 2 1 4 Draw Scholler Berkaloff diagram 2 1 5 Draw Piper diagram 2 1 6 Dravv Stiff Diagram 2 1 7 Get lonic Balance 2 1 8 Load Data and identify points 2 1 9 Hydrochemical data Analysis Tools 2 1 10 Goestatistical Analysis Tools 2 1 11 EASY QUIM 2 1 12 MIX 2 1 13 Regulatory Parameter Query 2 2 Statistical QUIMET instructions 2 2 1 Interface 2 2 2 General Univariable Analysis 2 2 3 Correlation Matrix 2 2 4 Covariance Matrix 2 2 5 Univariable Analysis 2 2 6 Coefficient R2 Matrix 2 2 7 Correlation Matrix 2 2 8 Bivariavle Analysis 3 Database QUIMET Spatial Database 3 1 Database General Structure 3 2 Database Tables and Components Descriptions 3 3 Insert Data in the Database See Velasco et al 2013 Velasco et al 2014 Velasco et al 2012 1 QUIMET 10 Installation STEP 1 Run Quimet10 According to your OS executable files are available for 32 or 64 bits Quimet10x86 or Quimet10x64 Also the regional language configuration of your OS must match with the language of the Office Package installed WARMING This computer program iz protected by copyright law and international treaties Unauthorized duplication or distribution of this program ar any portion of it may result in severe civil or criminal penalties and will be prosecuted to the maximum extent possible under the law Cm J 1 QUIMET 10 Installation STEP
40. gram Select All Deselect All Continues in Next Slide 2 1 3 Spatial Quimet instructions SALINITY Diagram Hydrochemical diagrams tools B Salinity diagram for different points vvith just one date for each one ud SAR Report SAR report and diaqram SAR Report L SAR Diagram di 14 38 36 34 32 30 20 26 24 22 20 18 16 14 12 ATION SAR EL RPTION R ca SODIO ADSO Export RTF Report Export Excel Report SAR Diagram o VeryHigh 4 10 0 100 0 1000 0 10000 0 ELECTRIC CONDUCTIVITY uS cm DANO PUIG Y ul SAR Report SAR Report SAR Diagram Visualize parameters values in a table SAR report and diagram CE uS cm Ca meg Mg meg Na meg 1005 0000 4 2300 1 8017 4 1696 28 10 1997 832 0000 0 4150 1 8843 6 2913 29 01 1998 1610 0000 8 2250 4 2066 7 1000 28 10 1997 1169 0000 0 3400 0 4463 11 8174 29 10 1997 1325 0000 6 5000 5 1901 3 6609 20 11 1997 1400 0000 8 8500 2 9669 6 0000 29 10 1997 1889 0000 7 8200 5 0248 10 8739 24 02 2003 1417 0000 8 6500 3 4298 4 7826 Spiny diagram Two options export a complete report diagram and parameters values to MSWord or MSExcel 2 1 4 Spatial Quimet instructions SCHOLLER BERKALOFF Hy
41. hnical Engineering and Geosciences and Institute of Environmental Assessment and Water Research IDAEA CSIC Grupo de Hidrologia Subterr nea ETCG UPC CSIC Barcelona Spain Available at http www h20geo upc es castellano software htm Accessed 18 September 2013 Serrano Juan A V zquez Su e E Alcaraz M Ayora C Velasco V Criollo R 2013 major revisions Using MS Excel and VBA to recycle personalize and extend current hydrogeological software Computer 4 Geosciences Velasco V Vazquez Sune E Criollo R Alcaraz M Serrano Juan A Garc a Gil A Tubau l Gogu R Gaitanaru D 2013 GIS based Hydrogeological Database and Analysis Tools INFOCOMP2013 The Third International Conference on Advanced Communications and Computation 17 22 Noviembre Lisboa Portugal ISBN 978 1 61208 310 0 Velasco V Tubau l Vazquez Sune E Gogu R Gaitanaru D Alcaraz M Serrano Juan A Fernandez Garcia D Garrido T Fraile J Sanchez Vila X 2014 Accepted GIS based hydrogeochemical analysis tools QUIMET Computers amp Geosciences CAGEO D 13 00373R2 Velasco V Tubau l Vazquez Sune E Gaitanaru D Gogu R Alcaraz M Serrano A S nchez X Fernandez D Fraile J Garrido T 2012 GIS based Hydrochemical Analysis Tools QUIMET 7th EUREGEO Bolonia Italia Junio 2012 Vol1 419 420 hydor tools cid csic es ACKNOWLEDGEMENTS Ag ncia Catalana de l Aigua The auth
42. icrosoft Excel F rmulas Datos Revisar Vista General Y Am Formato condi Area Delta Besos Date 17 02 2012 14 43 49 xb 000 genere Alineaci n S N mero m Estilos Wellld Campaign Sample SampleDate FRIG Violeta ca iN 24 10 2006 Cloroform CHCI3 icrog l a S s E E 2 ERN ERE ka maaa IdVariable MONT Violeta MONT_C 24 09 2006 Cloroform CHCI3 microg FEL i 1 2 nomVariable 3 j funitatsVariable 4 PUIG CU 24 10 2006 Cloroform CHCI3 MEL 4 AbrVariable P0610 ja Violeta REGA C 24 10 2001 Cloroform CHCI3 microg 5 PUNT DATA _ CAMPANY MOSTRA x v clorurs rr 10 6 CCAD 24 02 2003 Campa a ABTE CANC CCLO3O2 432962 0663 4584641 892 142 CCAD 05 07 2004 Campa a ABTE CANC CCLO407 432962 0663 4584641 892 123 REGA REGA C 27 09 2006 Cloroform_CHCIS 8 CCAD 26 11 2010 Campa a CCAD CPR1011 432962 0663 4584641 892 210 UP0609 z x ans Violeta SAN3 C 25 10 2006 Cloroform CHCI3 microg l 9 COLA 25 11 2010 Campa a COLA CPR1011 432962 0663 4584641 892 211 UP0610 10 COLA 29 01 1998 Campa a COLA CUP9801 003 433856 6737 4586378 58 lil Violeta SCO1 C 24 10 2001 Cloroform CHCI3 microg l 1 COLA 07 07 1998 Campa a COLA CUP9807 004 433856 6737 4586378 58 10 w mmi 12 COLA 09 10 1998 Campa a COLA CUP9810 004 433856 6737 4586378 58 203 SCO1 Violeta S661 C 27 09 2006 Cloroform CHCI3 microgl m 43 COLA 28 01 1999 Campa a COLA CUP9901 014 433856 6737 4586378
43. ighting 2 1 10 Geostatistical Analysis Also the Geostatistical Analyst Module from ArcGIS is embedded in Quimet Toolbar to perform geostatistical analysis vvith the layer created in D 3 For additional information about these commands please visit http help arcgis com en arcgisdeskto 0 0 pdf geostatistical analyst tutorial pdf 2 1 10 Spatial Quimet instructions Geostatistical Analysis Tools ArcGIS Det inisti thod Global Polynomial Interpolation Local Polynomial Interpolation Radial Basis Functions Kriging CoKrigin El Interpolation with barriers Kernel Smoothing Diffusion Kernel El Dataset Source Dataset Data Field Weight Field Clorurs_Min_2 Param_Std About Inverse Distance Weighting Inverse Distance Weighting IDW is a quick deterministic interpolator that is exact There are very few decisions to make regarding model parameters It can be a good way to take a first look at an interpolated surface However there is no assessment of prediction errors and IDW can produce bulls eyes around data locations There are no assumptions required of the data Learn more about Inverse Distance Weighting lt Back Next gt nish cms j Deterministic and geostatistical methods are available in Geostatistical Analyst Module ArcGIS 3057 3 668 Distance h 107 0 611 1 834 Model Binned F Averaged 2 446 Semivariogra m map El General Optimize model Variable El
44. jana de la poblaci 21 74 170 74 871 70 10 29 473 25 16 34 30 58 59 48 2059 27 This spreadsheet exists in each of the files generated by each command 2 2 3 Statistical Quimet instructions Correlation Matrix General Univariable Analysis Correlation Matrix Covariance Matrix Univarable Analysis Coefficient RA Matrix Correlation Graphic Bivariable Analysis 1 00000 0 24796 1 00000 0 20626 1 00000 0 03049 0 30224 0 189687 0 30326 0 14191 1 00000 Generates and Excel file named CorrelationMatrix xls with the Correlation Matrix for query parameters 2 2 4 Statistical Quimet instructions Covariance Matrix Generates an Excel file named CovarianceMatrix xls with the Covariance Matriz for queried parameters Clorurs Hitrats Sodi 11 72 45746 91 5631 83 10681057 206101 61 7193323 81 1195463275 41083531 28 Bicarbonats Sulfats 14188 99 83776 47 11963 34 1705422 72 17406923 04 73276 19 941870454 322151 68 51855254 2246 30 171826 60 64011678 22235703 40 1293 18 174385 34 264960 46 752514 81 171 72 6116 46 9421 91 6103281 2796075 64 Gee Une Ai Bivariable Analysis Sodi 4 5 3 70 00 o 2 60 008 o 50 00 2 40 002 Eo 4 30 007 20 00 10 00 0 0 00 eo xy vy Y KON RC RON LL AV AV AL AL AL AV AV AL AL AV AV x x x x x x X x x x x x CL DEDE C C SSL x cS AV ON NS ND EE Freq encia Acumulat 14 2 2 5 Statistical Quimet instructions
45. lysis tools A Query temporal evolution from hydrochemical parameters according to selected points STEP 1 Select temporal interval query STEP 2 Select hydrogeochemical parameters to query STEP 3 Consult and choose points parameters to visualize temporal evolutions Several options i Multiple wells multiple parameters i Multiple wells just one parameter iii Just one well multiple wells iv One well One parameter gt 2 1 9 Spatial Quimet instructions Hydrochemical data analysis tools i Multiple wells multiple parameters li Multiple wells just one parameter Temporal Evolution Temporal Evolution 1997 2000 2003 2006 2009 Date 08245 0005 Clorurs 4 08281 0028 Clorurs 08230 0022 Clorurs 08126 0011 Clorurs 1997 2000 2003 2006 Date 08245 0005 Clorurs amp 08281 0028 Clorurs 08245 0005 Sodi 08281 0028 Sodi 2 1 9 Spatial Quimet instructions Hydrochemical data analysis tools iii Just one vvell multiple wells iv One vvell One parameter Temporal Evolution Temporal Evolution 2000 2003 2006 2009 Date 08281 0028 Sodi amp 08281 0028 Clorurs 2003 2006 Date 4 08281 0028 Clorurs 2 1 9 Spatial Quimet instructions Hydrochemical data analysis tools B Create MS VVord reports vvith chosen C Create MS Excel documents vvith chosen parameters parameters Query Report Data M
46. m Analysis Generate Eas y Quim Excel Report EASY QUIM v5 0 2012 y D o INPUT ouTPUT JS Analysis Title Example Analysis Date Ref April 2012 Number of analysis to be stored 54 a a INSTRUCTIONS 1 Write the tite date and number of analysis to be stored m x 199 Use ENTER key to skip to the next textbox 2 Click Enter your data to introduce or copy amp paste from another document Highlighted cells are obligatory 3 Visualize the results by dicking the Output tab and use the different options that it offers Some data cn be exported NOTE This menu window can be moved wherever you wish OF UPC i GUIDE lunes 21 de enero STEP 1 Select points to query in the map and define the temporal interval query de 1500 End date viemes 21 de marzo de 2014 STEP 2 Click here to create Ea Qu m n na Easy F rmulas Datos Revisar Vista Programador Acrobat er ali Ajustar texto General y Ey Buena Incorrecto Neutral c Z Z E a4 Combinary centrar EH 000 78 Formato Dar Tomato 935 5399 Celdavincul Entrada Notas s x condicional como tabla l z Alineaci n x N mero P Estilos D E F G H I J K De sept 14 may 08 03 jun 09 ma bma 23 may 11 Look out Easy Quim works with 199 samples as maximum A A ne A SE AAN CE uSicm 3016 00 262000 254300 _1975 00 _1726 00 _1480 00
47. ne Temporal Interval Query End date lunes 11de julio de 2011 9 STEP 2 Click Run the Query Selected Points 7 4 4 4 4 4 4 4 4 Select All Deselect All Create Report Close STEP 3 Two Options A Salinity diagram for different dates at the same point B Salinity diagram for different points with just one date for each one Continues in Next Slide 2 1 3 Spatial Quimet instructions SALINITY Diagram Hydrochemical diagrams tools A Salinity diagram for different dates at the same point QUIMET 7 0 0 Begin date viemes 11 de julio de 1397 9 End date lunes lide julio de 2011 m EE Selected Points STEP 1 Click here After select 3 CET REST date in the drop down 10 1997 2810 1997 s mue Be CAC NT Select All Deselect All gt _ Create Report _ Close Continues in Next Slide 2 1 3 Spatial Quimet instructions SALINITY Diagram Hydrochemical diagrams tools A Salinity diagram for different dates at the same point STEP 2 Two options A 1 Choose one by one dates to query or select all at once A 2 Choose the query interval ud Draw Graph by Single Date Interval Date L 2 se SAR Diagram Classification del Aqua par Riesgo HEURE LLL A1 EA 1 Choose the date to query 2 Click to select 3 Click Create Graph A2 1 Define a temporal interval to query instead of pi
48. ng and recording the data Filling up the rest of the tables This can be done by using Excel Access ArcCatalog Todos los objetos de Access DB ChemSamples LibChemParameters DB LibChemParamLab 7 DB LibchemParamNorm DB LibEntities DB LibNorm DE LibPointType DB LibUniquelnits ibUnits PiezaMeasurements DB points table 7 DB PointsHasLibPointType 7 DB Project DB References DB WellsDescription QUIMET COMPULSORY TABLES FIELDS DB Points IdPoint coordinates X Y DB ChemSample IdPoint DateSamp IdChemSamp DB ChemMeasurement IdChemSamp IdParam DateMeas Value or compValue References Carrera J Castillo O V zquez Sun E Sanchez Vila X 2004 A methodology to compute mixing ratios with uncertain end members VVater Resources Research vol 40 12 Art VV12101 ESRI 2010 ArcGIS 10 Environmental Systems Research Institute Redlands United States of America Available at http www esri com software arcgis arcgis for desktop Accessed 03 06 2013 GHS 2013a EASYQUIM Developed in the Department of Geotechnical Engineering and Geosciences and Institute of Environmental Assessment and Water Research IDAEA CSIC Grupo de Hidrologia Subterr nea ETCG UPC CSIC Barcelona Spain Available at http www h20geo upc es castellano software htm Accessed 18 September 2013 GHS 2013b MIX Developed in the Department of Geotec
49. ngth 3 3 Computing and recording the data EXAMPLE 2 Access and ArcMap STEP 1 Fill up DB Points table IdPoint and coordinates XY compulsory to subsequent creation of feature class Todos los objetos de Access IdPoint H DB PiezoMeasurements DB Points YL Qs EXE UNI DB Points Shape Index DB PointsHasLibPointType Hid HI B DIP DDO DDDO Po DB_Project DE References POL DE points table STEP 3 Create pd A feature_class with Display XY Data Joins and Relates X Remove Data Es Geocode Addresses t Display Route Events Display XY Data T Mi Nam2Poir Nam3Point Coox 433856 67371 431168 02008 428407 24872 432962 06628 431795 20612 428048 80792 427370 00012 431194 57672 427931 75232 Display XY Data CooY 4586378 5801 4584621 3501 4581490 8971 4584641 8921 4585562 0091 4583038 9961 4581660 0001 4581402 2591 4580059 4431 3 3 Computing and recording the data EXAMPLE 2 Access and ArcMap SETP 4 Export feature class event to the database and substitute the existing DB Points E Layers a E C Users violeta Documents trabajo bbddhi E DB_points_table Events Copy DB_points_table AX Remove Repair Data Source Attribute Table Export Data nd Relates Make Permanent To Layer View Metadata To Make Visible Scale Range a Review Rematch Addreszes mbol Levels Selecti Label Features Convert Labels to Annotation
50. ors would like to acknowledge the financial support of the Ag ncia gt Catalana de l Aigua Catalan Water Agency for the development of the software d
51. pen Statistical QUIMET Interface LB ArcMap 10 2 2 1 Statistical Quimet instructions Interface QUIMETLO AA Q Quimet10 File Settings Tools Database Help e Nosed Quimet Tools Spatial Quimet A spatial tool to analvze the spatial distribution of hvdrochemical parameters Statistcal Quimet STEP 2 Click here to define the query s Geostatistical Quimet SM DL E Statistical QUIMET Tools EU NEP 3 Lo ms Geostatistical c EI Time Query E Choose your time interval Begin date 12 January 1999 vl Enddate 12 January 2012 sua Nonreactive mixture Geostatistical dar aL QUOI Organical Chemistry Geostatistical Submit Guery Results The academic version only allows the user to perform a query with a maximum of 50 values 2 2 1 Statistical Quimet instructions Interface STEP 3 Define temporal interval ial gt E Query STEP 4 Click Ime Huen Choose your time interval Begin date 12 January 1999 End date 12 January 2012 MEN Choose parameters 1 2 Dicloropropa 1 8 Cineale eucaliptal cloropiridina e et11 1 hexarnol metilisoborneal jwbenee STEP 5 Choose pa rameters to query STEP 6 Click Query Results Select l Deselect l d d well Campaign
52. s 2 2 NAME OF THE DESCRIPTION FORMAT RELATIONSHIPS FIELD Observations Observations and or clarifications about Text 80 NO the parameters Obsinput Observations of the person that introduce Text 160 NO the data into the database NumbReg Autonumber Autonumber Pelli Conversion factor to mmol L This conversion factor will facilitate the conversion of measurement units to avoid inconsistencies in the units of measurement between different data sets for the statistical QUIMET tools and for the Hydrochemical data analysis tools of Spatial QUIMET Default value 1 no conv factor 3 2 9 Description of DB LibUniqueUnits 1 1 IdUnits Unit ID Autonumber YES ShortUnits Abbreviation of the Text 3 YES parameters unit 3 characters NamUnits Parameter units name Text 30 YES standard NAME OF THE FIELD DESCRIPTION FORMAT RELATIONSHIPS DB LibChemParamLab field IdUnits 1 M DB LibChemParameters field IdUnits 1 M DB_LibChemParamNorm field IdUnits 1 M IdParam IdLabEntity IdParamLab ShortUnits detecLim IdProcessUsed Unique identifier for each Text 8 YES parameter ID from DB LibChemParameters Laboratory entity in charge of Text 10 YES collecting data in lab or the entity that provide the information ID from DB LibEntity Parameter ID used by the entity Text 30 NO in charge of providing analysing hydrochemical data Units of measurements of the Integer YES
53. sPoint AccDesc Observations Obsinput NumbReg DESCRIPTION Adress e g Palm Beach 92 Cuenca Description of the access to the point for taking water samples e g easy access it is in the middle of the street talk to the owner its unknown In any case the information has to be accompanied vvith the date Aditional observations Observations of the person that introduce the data into the database Autonumber FORMAT Text 255 No Text 255 No Text 255 No Text 255 No Autonumber RELATIONSHIPS 31 3 2 2 Description of DB LibPointType 1 1 NAME OF THE FIELD DESCRIPTION FORMAT RELATIONSHIPS IdTypeP Unique Identifier ID foreach Text 4 YES PointsHasLibPointType type of point field IdTypeP M 1 DescType Description of the type of Text 80 YES point local language DescTypeEN Description of the type of Text 80 NO point english NumbReg Autonumber Autonumber This table acts as a library of terms if the point type is already included you do not need to adda new term 3 2 3 Description of DB PointsHasLibPointType 1 1 NAME OF THE FIELD DESCRIPTION FORMAT RELATIONSHIPS IdPoint Unique identifier for each Text 30 YES DB Points field IdPoint point Id from 1 M DB Point Table dropdwon list IdTypeP Unique identifier defining Text 4 YES DB LibPointType field point type Id form IdTypeP 1 M DB LibPointType dropdwon list NumbReg Autonumber Autonumber
54. ssUsedType Field IdProcUsedType Text 30 YES DB LibProcessUsedClass Field IdProcUsedClass Autonumber 3 3 Computing and recording the data The geospatial database represents information based on the Personal Geodatabase structure provided by the ArcGIS concept 2 types of data spatial and non spatial data rJ BD_QUIMET mdb EN DE Campaign EE DB LibUniqueUnits I GCoordSystem E DB ChemMeasureme nts E DE LibUnits z Globalization SS DB ChemSamples Sl ME B DiezoMeasurements G5QLOperatorTable EE DB LibChemParameters IB Parameters EE DB LibChemParamLab Fi ModificationLog E DB LibChemParamNorm HB Freie todified Tables ES DB_LibEntities Piner Parame El DB_LibNorm x Ak E_WellsDescription EF DB LibPointType Show of type Datasets and Layers hr Feature class with spatial information x y z ArcMap ArcCatalog Differents methodologies see next slides for some examples Further information http www esri es es productos arcgis 3 3 Computing and recording the data EXAMPLE 1 One to one ArcMap STEP 1 add DB Points gt start editing gt modify feature E7 Stop Editing Els Save Edits STEP 2 gt Absolute X Y mA Editor AP Task Create New Feature vl Target DB Points El 4h sg NOX J gt alo Pig cR Snap To Feature Direction Ctrl 4 Deflection Ctrl F Absolute X Y Length Ctrl L Change Le
55. surements Globalization DB Points GSQLOperatorTable DB points table IB Parameters DB PointsHasLibPointType EElModificationLog EADB Project EA ModifiedTables E DB_References ESJOld DB LibUnits DB WellsDescription Piper Parameters GAliasTable SAR Parameters mo en Conventional Add data from ArcGIS ESRI command can be used Add Points Layer to analyze STEP 1 Open Database 2 1 2 Spatial Quimet instructions Select Features ArcGIS tools 2 1 2 SELECT FEATURES AMET 10 0 q HJ E be OE ES 2 Qe M 9 Geostatistical Analyst Help Select points to query Once you have selected the points on the screen that represents sampling points the QUIMETS tools will become active a Ri y A Spe iis dne dies bs UM Em 7 j gt A hu aE NA tl C0 d AAE RN EN i our ST a LM du N A ur Le MY M es au y L AA NA AS 9st fy e 202 oy YU n Conventional select feature commands of ArcGIS can be used as Select By Attributes Select By Location Select By Circle The academic version only allows the user to select 20 points each time If you select more than 20 points at the same time the different commands will continue being off 2 1 3 Spatial Quimet instructions SALINITY Hydrochemical diagrams tools 2 1 3 DRAW SALINITY DIAGRAM Dravv Query Salinity Diagram from points previously selected in ArcMap Begin date viemes 11 de julio de 1887 9 STEP 1 Defi
56. ted or as less than or greater than Laboratory identifier from DB LibEntities Reference ID from the table DB References Observations Comments and or clarification Observations of the person that introduce the data into the database Autonumber Text 30 YES DB ChemSamples field IdChemSamp M 1 Text S YES BD LibChemParameters field IdParam M 1 Date NO Doble YES Text 10 NO Text 30 SIl DB LibEntities fielf IdEntity M 1 Text 50 NO DB References field IdRef M 1 Text 80 NO Text 160 No Fields required for using QUIMET tools Autonumbe 3 2 15 Description of DB ProcessUsed 1 1 NAME OF THE DESCRIPTION FORMAT RELATIONSHIPS FIELD IdProcessUsed NamProcess ShortDesc ShortDescEN IdProcUsedField IdProcUsedType IdProcUsedClass NumbReg Unique Identifier for each type of process used NamProcess Short description of the process in the local language Short description of the process in English Unique identifier field of the process from DB LibProcessUsedField e g Hydrochemistry geology Unique identifier for each type process from DB LibProcessUsedType Unique identifier from DB LibProcessUsedClass Autonumber Text 30 YES DB ChemSamples field IdProcessUsed DB LibChemParamLab field IdProcessUsed Text 50 NO Text 255 NO Text 255 NO Text 30 NO DB LibProcessUsedField Field IdProcUsedField Text 30 NO DB LibProce
57. tion of hydrochemical parameters Create MS Word reports for the chosen parameters Create MS Excel documents for the chosen parameters Create maps to show for each point Unis __CompVeue 2 D 1 Number of samples irr fano Para meme e itt mer Campagn2 DANO CUPSGIZ 12 19 1896 Ntrets 894 pm available for the selected points mp2 Campagni0 EXPO CPRIO 11 24 2010 las 06 nel and parameters mn e CS YR renea arra AB e mE w D 2 Min Max o average IS IN A tows me om MPs Campaign8 FRIG_CCLO301 1 29 2003 Mtrts 579 mah for the selected points and IS 0 ICH 2 Me oa EN saan Ter Ta a parameters on Eu Campaign HOCO CUP5612 Enemy ne 0m 15 2 EE n dien s D 3 Create files for a further sr C r E Begin date lunes Olde enero de 190 End date viemes 21 de marzo de 2014 Query Results fe m eee ATF por Leap ns ns geostatistical analysis and specified temporal interval Time Query Choose your time interval Begin date lunes 01de enero de 1900 End date viemes 21 de marzo de 2014 37 a Date Units Comp Value lp IC fos E E ers pmomm wen R Em pen aran Tana Nias 078 pm mp2 CT I Wes CN m mea comet GIO VD me St Rei Cmonin Rpsp aaas es a2 gh G 1 52 So Hi P5 Campaign12 MANS CCLO 1 28 2003 Nitrats 70 3 mg l Corra Gmelin cet 2 1 9 Spatial Quimet instructions Hydrochemical data ana
58. y UE Conversion Tools amp Bg Data Interoperability Tools DE Data Management Tools 61 483 Editing Tools H ENVI Tools El y ERDAS Image Analysis Tools 0 55 ERDAS Import Export Tools m a Genendina Tanle ESRI 2010 ArcGIS 10 Environmental Systems Research Institute Redlands United States of America Available at http www esri com software arcgis arcgis for desktop Accessed 03 06 2013 QUIMET10 Mame config Easy Quim shps amp EasyQuim dll m EasyQuim tlb Interop Excel dll J Interop Office dil El Interop VBIDE dll B Microsoft Office Interop Excel dll Microsoft Vbe Interop dll 83 office dil ZedGraph dll amp ZedGraph Web dll STEP 7 Click Add from file and select EasyQuim tlb file in the directory C GHSTools QUIMET10 gt e m 1 QUIMET 10 Installation Date modified T 07 04 2013 07 59 p 07 04 2013 07 59 p 25 03 2013 09 53 a 20 03 2013 06 15 p 20 03 2013 06 15 p 19 03 1909 08 30 a 20 03 1999 04 39 p 11 03 1999 05 35 a 19 04 2012 07 00 p 19 04 2012 07 00 p 19 04 2012 07 00 p 13 12 2008 01 01 a 13 12 2008 01 14 a File folder File folder File folder Applicatic TLB File Applicatic Applicatic Applicatic Applicatic Applicatic Applicatic Applicatic Applicatic 1 QUIMET 10 Installation STEP 8 Select the nevv toolbar in Toolbars Tab under the Customize Menu Quimet 10 Toolbar
59. ymbol c REI s Description Additional description appearing next to the symbol in your map s legend Cancelar Aplicar 2 1 6 Spatial Quimet instructions Stiff Hydrochemical diagrams tools STEP 3 Create diagrams and value parameters table for each selected point ad Stiff Report Stiff table and diagrams Report table Point lo Na meg Mg nep k DANO a 11 Ca Pest Cl mega 504 4 Stiff Diagram Export RTF Report 2 1 7 Spatial Quimet instructions lonic Balance Parameter Calculator Tools 2 1 7 GET THE IONIC BALANCE Calculate the ionic balance 62 Ionic Balance E Select temporal interval query End date lunes 11 de julio de 2011 Y in t sabado 1 j Begin date s bado Tide julio de 1898 L STEP STEP 2 Click herell to execute the query Same mechanism as SALINITY DIAGRAM Sch ller Berkaloff and Draw PIPER diagram Look at previous ides mm umi 13 12 2006 G gt 02006 x EJEE EJE ETE E III Date 11 La 10 La STEP 3 Two Options 10 200 La 10 El 10 1 lA Calculate ionic balance for ao NT different dates at the same point B Calculate ionic balance for different points vvith just one date for each one 2 1 7 Spatial Quimet instructions lonic Balance Parameter Calculator Tools 2 1 7 GET THE IONIC BALANCE A Calculate ionic balanc

STEP 1

Contents

Download Pdf Manuals

Related Search

Related Contents