Upper Orange WMA 2019-10-18 22:35:27 surface , RQIS WMS water quality data Department of Water and Sanitation, kml_WMS_mnpts

Resource water quality data for Upper Orange WMA.

List of 252 sites, other than groundwater, for Upper Orange WMA. (Show groundwater list.)

plot Link to pre-generated water quality PNG or PDF time-series plots, which show the median and 90^th percentile statistics to minimise the effect of outliers.
data Link to compact, comma-delimited water quality data files(missing data = #N/A; for detection limits, obtain the latest "raw" data from RQIS).
n/a means that this system could not find inorganic chemical data (other types may exist). (Obtain the latest data from RQIS.)
Site descriptions are verbatim from the database: please report errors.
Type is the database classification.
First date, last date and number of samples shown here, while not current, are more up to date than in the pre-generated graphs and data.
median Electrical Conductivity in milliSiemens per metre.
Flow data (where applicable) are presented courtesy of DWS' Hydrological Services.
Hints:
- To zoom to a particular point on Google Earth, highlight the Latitude and Longitude and copy and paste them into Google Earth's search box.
- The Water Quality Guidelines may help in interpreting water quality data.

Water quality			Description	Type	n	First date	Last date	med EC	Flow, if any	Latitude	Longitude
C52 90811	plot	data	At Likatlong / Sannaspos on Modder River (ncwq NCMP)	Rivers	822	1987-08-26	2018-07-16	43	C5H003	-29.16028	26.57333
C52 90812	plot	data	At Bishop S Glen on Renosterspruit	Rivers	19	1987-05-22	2018-06-22	55	C5H006	-28.98472	26.34194
C52 90813	plot	data	At Shannon Valley on Renosterspruit (NCWQ)	Rivers	645	1972-06-13	2018-06-22	63	C5H007	-29.14444	26.31806
C51 90814	plot	data	Riet River at Riviera	Rivers	22	1972-03-18	1999-02-16	27	C5H008	-29.81222	26.21222
C51 90815	plot	data	Ospoort Spruit at Os Poort	Rivers	12	1972-03-18	1998-06-29	16	C5H009	-29.90222	26.21500
C51 90816	plot	data	Riet River at Kromdraai/Rietwater (ncwq NCMP)	Rivers	334	1975-12-21	2018-07-20	59	C5H012	-29.65806	25.97333
C51 90817	plot	data	Richie Klipdrift 109 - at U/S Side of Weir on Riet River (NCWQ NCMP)	Rivers	838	1992-11-02	2017-07-31	46	C5H014	-29.04222	24.60000
C52 90818	plot	data	At Stoomhoek on Modder Rivier	Rivers	128	1967-01-22	1996-07-22	35	C5H015	-28.80750	26.11222
C51 90819	plot	data	At Estate Biesiesbult Aucampshoop on Riet River (ncwq NCMP)	Rivers	753	1970-06-08	2017-06-30	106	C5H016	-28.96000	24.24250
C52 90820	plot	data	Modder River at Tweerivier (ncwq)	Rivers	569	1971-05-03	2013-05-27	77	C5H018	-29.04333	24.64083
C52 90823	plot	data	Kgabanyane River at Bedford up Stream Groothoek D (NCWQ)	Rivers	196	1986-06-10	2018-05-08	49	C5H022	-29.28556	26.92194
C52 90824	plot	data	Kgabanyane River at Dankbaar D/Stream Groothoek D (NCWQ)	Rivers	152	1983-07-27	2011-08-23	25	C5H023	-29.28611	26.76417
C52 90826	plot	data	Koranna Spruit at Brightside	Rivers	6	1987-09-07	1988-03-01	13	C5H026	-29.08028	26.59333
C52 90827	plot	data	Sepane Spruit at Likatlong/Sannaspos	Rivers	8	1987-09-07	1988-03-01	27	C5H027	-29.16139	26.59750
C52 90828	plot	data	Kgabanyane River at Blijdschap	Rivers	5	1987-09-09	1994-03-24	15	C5H028	-29.28417	26.81306
C52 90829	plot	data	At Kromdraai on Klein Modder Rivier	Rivers	8	1987-08-26	2013-02-25	35	C5H029	-29.24278	26.67194
C52 90831	plot	data	Doorns 131 - Tweerivier 129 - at Modderrivier downstream Nico Smith Bridge on Modder River (NCWQ NCMP)	Rivers	886	1992-11-02	2017-07-31	32	C5H035	-29.02863	24.63839
C52 90833	plot	data	Krugersdrift Dam on Modder River: downstream Weir (ncwq NCMP)	Rivers	1007	1979-08-21	2018-06-15	44	C5H039	-28.88333	25.95028
C51 90835	plot	data	At Zoutpansdrift on Riet River (NCWQ NCMP nemp NEMP)	Rivers	1512	1990-08-10	2018-09-19	122	C5H048	-29.03333	23.98333
C51 86106	plot	data	Philippia Kalkfontein Dam Weir for Spilway Discharge on Riet T (NCWQ)	Rivers	7	2006-05-10	2017-05-11	104	C5H049	-29.47222	25.20667
C52 90836	plot	data	Cypress 89 - at Glen on Modder River (ncwq NCMP)	Rivers	775	1995-09-18	2018-10-19	58	C5H053	-28.94911	26.32099
C52 90837	plot	data	At Bishops Glen on Renosterspruit (NCWQ)	Rivers	558	1995-09-25	2018-07-16	66	C5H054	-28.96667	26.33306
C52 187233	plot	data	Diepwater 227 - on Modderrivier (NCWQ)	Rivers	209	2009-08-14	2018-10-23	27	C5H056	-29.37556	26.66556
C51 88779	plot	data	At Jacobsdal Bridge on Rietrivier	Rivers	66	1994-03-02	2015-03-24	106	ZJAC002	-29.14114	24.76892
C52 88780	plot	data	Canal S3050/15 at Inflow to Scholtzburg Weir	Rivers	7	1994-03-02	1994-07-26	18	ZJAC003	-29.02694	24.64194
C51 88787	plot	data	Blaauwboschfontein Weir on Riet River	Rivers	8	1994-03-22	1994-07-27	116	ZJAC014	-29.01306	24.14000
C51 88785	plot	data	ZJAC010C Riet River upstream of Confluence with Modder Riv	Rivers	12	1994-03-02	1994-08-16	106	88785	-29.04472	24.63250
C52 182329	plot	data	Botshabelo 3 at Bridge downstream of Pse Outflow (nmmp)	Rivers	1263	2000-02-15	2013-03-26	710	182329	-29.24283	26.67367
C52 182330	plot	data	Botshabelo 2 Final City Exit Point upstream of Pse Outflow (nmmp)	Rivers	1264	2000-02-15	2013-03-26	568	182330	-29.23800	26.68200
C52 182332	plot	data	Botshabelo 1 Runs Through Suburb Collecting Residential Waste (nmmp)	Rivers	1254	2000-02-15	2013-03-26	511	182332	-29.29533	26.71500
C52 188085	plot	data	Loch Logan at Gazebo on Bloemspruit (nmmp)	Rivers	487	2004-07-14	2013-03-26	n/a	188085	-29.11425	26.21044
C52 188182	plot	data	Selosesha (Seroala) Dam at Inlet on Sepane (nmmp)	Rivers	372	2004-11-02	2013-03-26	n/a	188182	-29.20537	26.79977
C51 188235	plot	data	Ditlhake Township Koffiefontein on Rietrivier (nmmp)	Rivers	438	2005-04-08	2013-03-26	n/a	188235	-29.39456	25.00503
C52 189013	plot	data	Midway at N8 Bridge on Bloemspruit	Rivers	58	2010-05-07	2015-03-12	73	189013	-29.11142	26.31353
C52 189015	plot	data	Glen at Road Bridge on Modder	Rivers	57	2012-11-19	2015-03-12	37	189015	-28.95550	26.33533
C51 189016	plot	data	Koffiefontein at R48 Road Bridge on Rietrivier	Rivers	63	2009-08-14	2015-03-17	320	189016	-29.41269	25.01728
C52 189017	plot	data	Palmietfontein at Botshabelo Dam on Klein Modder Rivier	Rivers	56	2012-11-19	2015-03-12	60	189017	-29.24981	26.65775
C52 189019	plot	data	Stoom Hoek 826 - Soetdoring at R700 Road Bridge on Modderrivier	Rivers	56	2010-05-07	2015-03-11	72	189019	-28.80700	26.10925
C51 189020	plot	data	Doorns at Modderrivier R29 Road Bridge on Rietrivier	Rivers	55	2012-11-27	2015-03-23	49	189020	-29.03775	24.62481
C51 189022	plot	data	Rietkuil 21 - at 704 (706) Road Bridge on Prosesspruit	Rivers	62	2009-08-14	2015-03-17	100	189022	-29.80608	25.49594
C51 189023	plot	data	Slagkraal 594 - at R706 Road Bridge on Rietrivier	Rivers	58	2011-09-23	2015-03-17	79	189023	-29.57594	25.71075
C51 189026	plot	data	Lockshoek 192 - at R706 Road Bridge on Kromellenboogspruit	Rivers	63	2009-08-14	2015-03-17	76	189026	-29.70431	25.60008
C52 189027	plot	data	Likatlong / Sannaspos at Farm Road Bridge on Sepane	Rivers	58	2012-11-19	2015-03-12	56	189027	-29.16347	26.59508
C51 189047	plot	data	Davidsrust Eindpunt on Rietrivier	Rivers	58	2010-02-25	2015-03-24	57	189047	-29.15631	24.77292
C51 189048	plot	data	Kalkfontein Dam Discharge to Rietrivier	Rivers	3	2009-08-14	2012-04-26	42	189048	-29.49631	25.22106
C52 189076	plot	data	Rooidam on Modderrivier	Rivers	53	2012-11-27	2015-03-24	182	189076	-29.02594	24.74956
C51 189096	plot	data	Taaibosch Fontein Scholtzburg Barrage on Rietrivier	Rivers	53	2011-09-02	2015-03-23	94	189096	-29.02669	24.04269
C52 191145	plot	data	Brandfort Townlands 720 - downstream of Brandfort WWTW on Keeromspruit	Rivers	52	2010-05-07	2015-03-12	62	191145	-28.71008	26.44644
C52 191156	plot	data	Brandfort Townlands 720 - upstream of Brandfort WWTW on Keeromspruit	Rivers	16	2010-05-07	2015-02-05	39	191156	-28.71126	26.44713
C52 191171	plot	data	Uitvlugt West 2810 - at Road Bridge downstream of Krugersdrift Dam on Modderrivier	Rivers	60	2010-05-07	2015-03-11	52	191171	-28.88531	25.95604
C51 191175	plot	data	Schutse Kama 103 - downstream of Lillydale on Rietrivier	Rivers	59	2009-08-14	2015-03-23	55	191175	-28.95341	24.40785
C51 191200	plot	data	Bellevue 413 - downstream of Reddersburg WWTW on Fouriespruit	Rivers	54	2012-11-18	2015-02-17	63	191200	-29.64058	26.15331
C52 300000058	plot	data	Koranaspruit on Modder River	Rivers	1	1999-01-28	1999-01-28	73	3-58	-29.15833	26.85556
D14 101788	plot	data	Wonderboom/Stormberg Spruit at Diepkloof/Burgersdorp (ncwq NCMP)	Rivers	975	1967-02-13	2018-07-19	69	D1H001	-31.00083	26.35306
D14 101789	plot	data	Orange River at Aliwal North (NCWQ NCMP)	Rivers	2318	1968-06-14	2018-10-25	18	D1H003	-30.67972	26.71250
D15 101791	plot	data	Kornet Spruit at Maghaleen (NCWQ NCMP)	Rivers	1389	1975-05-27	2018-10-24	20	D1H006	-30.16009	27.40124
D13 101792	plot	data	Kraai River at Buffels Vallei/Sunnyside	Rivers	267	1974-06-04	1975-07-25	26	D1H007	-30.72694	26.78278
D12 101793	plot	data	Orange River at Oranjedraai (NCWQ NCMP)	Rivers	1456	1963-03-12	2018-09-19	16	D1H009	-30.33611	27.35944
D14 101794	plot	data	Stormberg Spruit at Molteno Commonage	Rivers	167	1975-11-28	1981-03-30	51	D1H010	-31.40667	26.36833
D13 101795	plot	data	Kraai River at Roodewal (NCWQ NCMP GEMS)	Rivers	1366	1967-02-13	2018-10-25	23	D1H011	-30.83056	26.92139
D12 191410	plot	data	Verliesfontein 354 - 200M D/S of Zastron WWTW on Gryskopspruit	Rivers	51	2012-11-29	2015-02-17	76	ZASTRON	-30.30014	27.11402
D12 191423	plot	data	Verliesfontein 354 - 200M U/S of Zastron WWTW on Gryskopspruit	Rivers	51	2012-11-29	2015-02-17	70	ZASTRON	-30.29904	27.10571
D13 100164	plot	data	Kraairivier Buffelsvalley (dup name 6157)	Rivers	8	1974-02-28	1974-03-31	20	100164	-30.72500	26.78333
D13 100165	plot	data	Kraairivier Buffelsvalley (dup name 6158)	Rivers	1	1974-03-18	1974-03-18	18	100165	-30.71667	26.78333
D12 186214	plot	data	Orange River-Orange River Expedition 2002-09-27	Rivers	1	2002-09-27	2002-09-27	20	186214	-30.49160	27.24910
D12 186215	plot	data	Orange River-Orange River Expedition 2002-09-28	Rivers	1	2002-09-28	2002-09-28	20	186215	-30.59590	27.00700
D12 186590	plot	data	Orange River-Orange River Expedition 2002-09-26	Rivers	1	2002-09-26	2002-09-26	19	186590	-30.40580	27.33880
D14 186593	plot	data	Orange River-Orange River Expedition 2002-09-29 Aliwal North	Rivers	1	2002-09-29	2002-09-29	27	186593	-30.67810	26.71680
D14 191387	plot	data	Aliwal North - 400M D/S of Aliwal North WWTW on Orange River	Rivers	49	2012-07-05	2015-02-17	24	191387	-30.68769	26.68960
D14 191414	plot	data	Goedemoed Oudefontein 14 - 2KM D/S of Goedemoed WWTW on Oranjerivier	Rivers	48	2013-03-26	2015-02-17	20	191414	-30.58707	26.36470
D14 191415	plot	data	Goedemoed Deelfontein 237 - 2KM U/S of Goedemoed WWTW on Oranjerivier	Rivers	48	2013-03-26	2015-02-17	23	191415	-30.56677	26.41359
D13 191431	plot	data	Barkly East - 1KM D/S of Barkly East WWTW at Road Bridge on Langkloof	Rivers	52	2012-07-05	2015-02-18	33	191431	-30.95484	27.60690
D13 191432	plot	data	Barkly East - 400M U/S of Barkly East WWTW on Langkloof River	Rivers	52	2012-07-05	2015-02-18	32	191432	-30.96641	27.61672
D23 101804	plot	data	Caledon River at Jammerdrift	Rivers	331	1955-02-04	1984-10-02	22	D2H001	-29.71528	26.98333
D21 101808	plot	data	Caledonspoort 190 the Poplars 199 at the Poplars on Little Caledon River (ncwq NCMP)	Rivers	822	1971-09-24	2018-10-23	32	D2H012	-28.69485	28.23487
D22 101809	plot	data	Caledon River at Pleasant View/Maseru	Rivers	89	1982-09-21	1991-03-05	16	D2H020	-29.30167	27.48778
D23 101810	plot	data	Caledon River at Wilgedraai/Hobhouse (NCWQ NCMP)	Rivers	201	1988-11-06	2018-10-24	26	D2H022	-29.61556	27.06528
D23 101813	plot	data	Armenia Dam on Leeu River: Down Stream Weir	Rivers	3	1979-12-31	1993-09-15	30	D2H026	-29.36389	27.13167
D23 101814	plot	data	Knellpoort Dam on Riet Spruit: Down Stream Weir	Rivers	43	1992-10-20	1993-11-09	29	D2H028	-29.77917	26.88944
D24 86337	plot	data	Welbedacht 285 - at Gauging Weir on Caledon River D/S of Welbedachtdam	Rivers	15	2011-09-15	2018-09-04	37	D2H033	-29.92556	26.86000
D22 101815	plot	data	Caledon River at Ficksburg/ Ficksburg Bridge (ncwq NCMP)	Rivers	581	1994-08-09	2018-10-23	21	D2H035	-28.88333	27.89000
D24 101816	plot	data	Caledon River at Kommissiedrift (NCWQ NCMP)	Rivers	621	1993-05-12	2018-10-25	22	D2H036	-30.27917	26.65417
D23 101817	plot	data	Caledon River at Wilgedraai/Hobhouse (ncwq ncmp)	Rivers	893	1995-10-31	2018-10-24	21	D2H037	-29.60917	27.06556
D21 187244	plot	data	Caledonspoort on Caledon River (NCWQ)	Rivers	15	2012-04-17	2014-06-11	27	D2H039	-28.69000	28.23000
D22 187060	plot	data	Tributary of Caledon at Riverside Lodge (nmmp)	Rivers	335	2003-02-05	2013-03-26	n/a	187060	-29.29367	27.46250
D21 191335	plot	data	The Poplars 199 - 500M U/S of Caledonspoort Bridge - on Caledon Rivier	Rivers	54	2012-11-20	2015-02-12	24	191335	-28.69616	28.23884
D21 191336	plot	data	Pietersdal 1207 - D/S of WWTW at Road Bridge on Little Caledon River	Rivers	56	2012-11-20	2015-03-16	32	191336	-28.53938	28.43126
D21 191337	plot	data	Pietersdal 1207 - U/S of Clarens WWTW at Bank of Little Caledon River	Rivers	56	2012-11-20	2015-02-12	32	191337	-28.53477	28.43936
D22 191353	plot	data	Moordkop 215 - 550M D/S of Maseru Border Post Bridge on Caledon River	Rivers	50	2013-03-05	2015-03-04	20	191353	-29.30210	27.45628
D22 191354	plot	data	Riverside 927 - 1KM U/S of Maseru Border Post Bridge on Caledon River	Rivers	50	2013-03-05	2015-03-04	19	191354	-29.29445	27.46477
D24 193325	plot	data	Downstream Rouxville Sewage Treatment Works	Rivers	51	2012-11-29	2015-02-17	77	193325	-30.39320	26.83306
D35 101822	plot	data	Orange River at Bethulie	Rivers	377	1965-07-21	2008-12-17	19	D3H002	-30.53694	25.98583
D34 101823	plot	data	Orange River at Waschbank/Norvalspont	Rivers	147	1971-07-23	1998-11-15	16	D3H004	-30.62111	25.46444
D35 101825	plot	data	Orange River at Zeekoegat/Oviston	Rivers	43	1970-12-02	1980-05-07	14	D3H010	-30.69056	25.76361
D35 101826	plot	data	Orange River at Boshismanpoort/Bethulie	Rivers	29	1979-12-04	1999-02-10	14	D3H011	-30.53278	26.02611
D33 101827	plot	data	Orange River at Dooren Kuilen (downstream of D3R003) (NCWQ NCMP)	Rivers	919	1971-08-11	2018-03-26	18	D3H012	-29.99111	24.72444
D34 101828	plot	data	Roodepoort on Orange River (NCWQ NCMP)	Rivers	1687	1976-09-30	2018-10-25	17	D3H013	-30.58389	25.41972
D32 101829	plot	data	Seekoei River at de Eerste Poort (NCWQ NCMP)	Rivers	618	1981-02-04	2018-10-25	79	D3H015	-30.53417	24.96194
D34 88933	plot	data	Sterkspruit at Weilbackskloof - Biological Point	Rivers	2	1995-10-26	1995-10-26	9	ZSSP-WBKL	-30.50694	25.12194
D34 100196	plot	data	Oranje downstream of Hv Dam	Rivers	4	1975-06-11	1975-07-24	13	100196	-30.62500	25.50000
D34 186275	plot	data	Orange River-Orange River Expedition 2002-10-05	Rivers	1	2002-10-05	2002-10-05	18	186275	-30.56370	25.34760
D34 186276	plot	data	Orange River-Orange River Expedition 2002-10-06	Rivers	1	2002-10-06	2002-10-06	18	186276	-30.41970	25.12410
D31 186277	plot	data	Orange River-Orange River Expedition 2002-10-08	Rivers	1	2002-10-08	2002-10-08	18	186277	-29.99960	24.75590
D33 186278	plot	data	Orange River-Orange River Expedition 2002-10-09	Rivers	1	2002-10-09	2002-10-09	18	186278	-29.81860	24.50040
D33 186597	plot	data	Orange River-Orange River Expedition 2002-10-10	Rivers	1	2002-10-10	2002-10-10	19	186597	-29.79940	24.42130
D33 186600	plot	data	Orange River-Orange River Expedition 2002-10-11	Rivers	1	2002-10-11	2002-10-11	19	186600	-29.61280	24.15090
D33 186603	plot	data	Orange River-Orange River Expedition 2002-10-12	Rivers	1	2002-10-12	2002-10-12	20	186603	-29.32650	23.88380
C51 90838	plot	data	Tijgerpoort 1636 - Tierpoort Dam on Tierpoortrivier near Dam Wal (NCWQ) Q01	Dam / Barrage	793	1972-10-27	2018-07-20	28	C5R001	-29.42167	26.13639
C51 90839	plot	data	Kalkfontein Nature Reserve - Kalkfontein Dam on Rietrivier: near Dam Wall (NCWQ NEMP) Q01	Dam / Barrage	1604	1968-04-02	2018-06-21	46	C5R002	-29.49590	25.22230
C52 90840	plot	data	Rustfontein Nature Reserve - Rustfontein Dam on Modder Rivier: near Dam Wall (NCWQ) Q01	Dam / Barrage	1454	1968-05-19	2018-06-18	28	C5R003	-29.27130	26.61610
C52 90841	plot	data	Uitvlugt West 2810 - Krugersdrifdam on Modderrivier: near Dam Wall (NCWQ nemp) Q01	Dam / Barrage	1397	1975-03-10	2018-10-19	44	C5R004	-28.88333	25.95611
C52 90842	plot	data	Moroka S Hoek 58 - Groothoek Dam on Kgabanyane: near Dam Wall (NCWQ) Q01	Dam / Barrage	759	1981-03-03	2018-07-16	24	C5R005	-29.30278	26.84889
C52 90843	plot	data	Maselspoort Dam on Modder River: near Dam Wall (NCWQ) Q01	Dam / Barrage	661	1987-03-18	2018-07-20	32	C5R006	-29.02917	26.40833
C52 90844	plot	data	Mockes Dam on Modder River: near Dam Wall (NCWQ) Q01	Dam / Barrage	593	1987-05-22	2018-07-20	34	C5R007	-29.05056	26.46167
C52 189018	plot	data	Uitvlugt West 2810 - Krugersdrift Dam at Dam Wall near Right Bank	Dam / Barrage	5	2012-09-25	2013-04-05	60	189018	-28.88325	25.95406
C52 189021	plot	data	Mazelspoort 8 - Waterworks Lot a 1536 - at Mazelspoort Dam on Modder	Dam / Barrage	56	2012-11-19	2015-03-12	33	189021	-29.02856	26.40661
C52 189024	plot	data	Rustfontein Dam near Yacht Club on Rustfontein Dam	Dam / Barrage	56	2012-11-19	2015-03-12	28	189024	-29.26989	26.60872
C51 191170	plot	data	Kalkfontein 677 - at Jetty near Dam Wall on Kalkfontein Dam	Dam / Barrage	60	2010-02-25	2015-03-17	57	191170	-29.49836	25.22271
D12 101803	plot	data	Sterkspruit Dam at Jozana Hoek (NCWQ) Q01	Dam / Barrage	168	1998-03-24	2018-10-24	16	D1R001	-30.63667	27.36917
D22 86338	plot	data	Mpharane - at Dam Spillway on Meulspruit Dam (NCWQ)	Dam / Barrage	76	2012-03-28	2018-06-19	37	D2H034	-28.88056	27.83500
D24 101818	plot	data	Egmont 30 - Egmont Dam on Witspruit: near Dam Wall (NCWQ) Q01	Dam / Barrage	392	1975-02-22	2018-06-20	23	D2R001	-30.05222	27.02861
D23 101819	plot	data	Tshiamelo 664 - Armenia Dam on Leeurivier: near Dam Wall (NCWQ) Q01	Dam / Barrage	424	1972-10-26	2018-10-23	22	D2R002	-29.36410	27.12900
D24 101820	plot	data	Welbedacht 285 - Welbedacht Dam on Caledon River: near Dam Wall (ncwq NCMP nemp) Q01	Dam / Barrage	868	1975-02-22	2018-10-25	21	D2R004	-29.90889	26.86056
D23 101821	plot	data	Knellpoort 48 - Knellpoort Dam on Rietspruit: near Dam Wall (NCWQ nemp) Q01	Dam / Barrage	467	1989-07-03	2018-06-19	26	D2R006	-29.78130	26.88916
D35 101833	plot	data	Bethulie - Bethulie Dam on Bethulie Spruit: near Dam Wall Q01	Dam / Barrage	153	1978-02-28	1999-07-07	74	D3R001	-30.48778	25.97389
D34 101834	plot	data	Oviston Nature Reserve - Gariep Dam (H F Verwoerd Dam) on Orangerivier: near Dam Wall (NCWQ NEMP GEMS) Q01	Dam / Barrage	3054	1971-01-08	2018-09-20	18	D3R002	-30.62306	25.50722
D34 101835	plot	data	Gariep Dam on Orange River: at Bethulie Bridge Q02	Dam / Barrage	462	1974-01-28	2008-01-10	15	D3R002	-30.62306	25.50722
D34 101836	plot	data	Gariep Dam on Orange River: at Oviston Tunnel Inl Q03	Dam / Barrage	507	1974-01-28	1989-09-19	16	D3R002	-30.62306	25.50722
D31 101837	plot	data	Kareekloof 1184 - Vanderkloof Dam on Oranjerivier: near Dam Wall (NCWQ NEMP) Q01	Dam / Barrage	2032	1971-07-24	2018-01-31	20	D3R003	-29.99100	24.73210
C51 90821	plot	data	Trompsburg Eye at Trompsburg Townlands	Spring/Eye	172	1979-09-25	1992-10-06	57	C5H020	-30.03833	25.77861
C51 90822	plot	data	Mosters Hoek Eye at Mosters Hoek	Spring/Eye	152	1975-10-29	1999-08-06	58	C5H021	-29.66833	26.24778
C52 183712	plot	data	2826CC00026 Florisbad Warm Bath (N_GW)	Spring/Eye	44	2000-11-10	2018-04-23	420	ZQMFBD1	-28.76778	26.07000
D14 89868	plot	data	3026DA00035 Aliwal North (N_GW)	Spring/Eye	56	1995-05-04	2018-05-02	219	ZQMALI1	-30.71556	26.71472
C51 103048	plot	data	Riet River Treatm Works - Orange/Riet Canal Raw W	Potable Water Treatment Works	133	1991-04-02	2012-03-02	19	C5H051	-29.14694	24.73472
C51 103049	plot	data	Riet River/Jacobsdal Treatment Works - Treated Wa	Potable Water Treatment Works	129	1991-04-02	2008-07-28	21	C5H051	-29.14694	24.73472
C52 103050	plot	data	Maselspoort Treatment Works - Treated Water	Potable Water Treatment Works	32	1987-03-18	1992-01-09	27	C5H052	-29.02806	26.40778
D24 103053	plot	data	Caledon/Bloemfontein Treatment Works - Welbedacht Dam Raw Wa Ater	Potable Water Treatment Works	438	1979-09-15	2012-01-30	19	D2H021	-29.91533	26.84558
D24 103054	plot	data	Caledon/Bloemfontein Treatment Works - Treated Water	Potable Water Treatment Works	408	1979-09-15	2012-01-14	21	D2H021	-29.91533	26.84558
D34 103055	plot	data	Gariep Dam Treatment Works - Gariep Dam Raw Water	Potable Water Treatment Works	337	1980-12-01	2008-09-01	17	D3H017	-30.62644	25.48694
D34 103056	plot	data	Gariep Dam Treatment Works - Treated Water	Potable Water Treatment Works	330	1980-12-01	2006-10-16	20	D3H017	-30.62650	25.48686
C52 90825	plot	data	Sunnyside Bloemfontein - Bloemspruit WWTW Discharge to Bloemspruit	Waste Water Treatment Works	83	1987-08-29	2015-03-12	58	C5H025	-29.12333	26.28083
C52 188751	plot	data	Brandfort Townlands 720 - Brandfort WWTW Final Effluent Discharge to Keeromspruit	Waste Water Treatment Works	45	2001-09-07	2015-03-12	76	188751	-28.71003	26.44751
C52 188758	plot	data	Bloemfontein - Bloemspruit WWTW Discharge to Bloemspruit	Waste Water Treatment Works	62	2012-11-19	2015-03-12	66	188758	-29.12444	26.24583
C52 188760	plot	data	Thaba Nchu Sewage Works Discharge to Sepane	Waste Water Treatment Works	55	2012-11-21	2015-03-12	60	188760	-29.18861	26.79306
C52 188762	plot	data	Hillandale 249 - Bloemfontein - Northern WWTW Discharge to Unnamed Stinkhoutspruit Tributary	Waste Water Treatment Works	55	2012-11-19	2015-03-17	76	188762	-29.04667	26.20417
C51 188763	plot	data	Koffiefontein Sewage Works Discharge to Rietrivier	Waste Water Treatment Works	111	2004-07-05	2015-03-17	210	188763	-29.41694	25.01528
C52 188769	plot	data	Bloemfontein Sterkwater Sewage Works Discharge to Renosterspruit	Waste Water Treatment Works	63	2009-11-06	2015-05-12	52	188769	-29.19000	26.32889
C52 188771	plot	data	Botshabelo 826 - Botshabelo WWTW Final Eff Discharge to Klein Modder Rivier	Waste Water Treatment Works	59	2012-11-19	2015-03-12	65	188771	-29.24014	26.68521
C52 191143	plot	data	Rosekrans 2527 - Bainsvlei WWTW Final Discharge to Retention Dam + Irrigation	Waste Water Treatment Works	2	2010-05-07	2011-09-23	61	191143	-29.22184	26.12013
C52 191158	plot	data	Klipkoppan 535 - Dealesville WWTW at Oxidation Pond	Oxidation Pond	46	2011-09-23	2015-01-13	348	191158	-28.66371	25.77814
C51 191160	plot	data	Edenburg Town Lands 104 - Edenburg WWTW Oxidation Pond	Oxidation Pond	53	2012-11-18	2015-02-18	74	191160	-29.72118	25.93314
C51 191162	plot	data	Gamma 492 - Fauresmith WWTW Oxidation Pond	Oxidation Pond	62	2010-05-14	2015-03-17	123	191162	-29.72417	25.30354
C52 191165	plot	data	Palestina 95 - Igomotseng WWTW Oxidation Ponds	Oxidation Pond	1	2010-05-07	2010-05-07	133	191165	-28.73023	26.09964
C51 191167	plot	data	Dorpsgronden van Jacobsdal -11 Jacobsdal WWTW Oxidation Pond Discharge to Rietrivier	Oxidation Pond	63	2010-01-19	2015-03-23	201	191167	-29.13031	24.76011
C51 191169	plot	data	Jagersfontein - Jagersfontein WWTW Oxidation Pond Discharge to Prosesspruit Tributary	Oxidation Pond	58	2011-09-02	2015-02-03	87	191169	-29.79008	25.44987
C52 191189	plot	data	Diepfontein 54 - Petrusburg WWTW Oxidation Pond Discharge to Open Veld	Oxidation Pond	50	2010-05-14	2015-01-12	186	191189	-29.12849	25.40852
C51 191192	plot	data	Reddersburg 291 - Reddersburg WWTW Oxidation Ponds Discharge to Fouriespruit	Oxidation Pond	58	2012-02-07	2015-02-17	61	191192	-29.64303	26.15522
C51 191251	plot	data	Ritchie - at Ritchie WWTW Where Final Effluent Overflows from Oxi. Pond	Waste Water Treatment Works	54	2012-11-27	2015-02-23	68	191251	-29.00267	24.58729
C52 193314	plot	data	Dewetsdorp WWTW at Chlorine Contact Tank Where Effluent Discharges into Outl	Waste Water Treatment Works	54	2012-11-18	2015-02-17	70	193314	-29.57160	26.68159
C51 193324	plot	data	Oppermasgronde Sewage Treatment Works at Final Oxidation Pond	Waste Water Treatment Works	53	2012-11-18	2015-02-03	77	193324	-29.41618	24.74695
D12 300000092	plot	data	Sewage Works at Chlorinatn Discharge to Montagu Dam	Waste Water Treatment Works	26	2001-03-20	2005-11-16	86	ZASTRON	-30.28611	27.09444
D13 191409	plot	data	Jamestown - at Oxidation Pond on Jamestown WWTW	Waste Water Treatment Works	52	2012-11-28	2015-02-18	211	191409	-31.14190	26.80739
D12 191418	plot	data	Lady Grey Zagte Vally 32 - at Final Oxidation Pond on Lady Grey WWTW	Waste Water Treatment Works	51	2012-07-04	2015-02-18	71	191418	-30.71026	27.18028
D14 193068	plot	data	Goedemoed WWTW at Correctional Services in Soil Canal at Evapoartion Dam	Waste Water Treatment Works	49	2012-07-05	2015-02-17	48	193068	-30.57517	26.38262
D14 300000096	plot	data	Goedemoed S/W at Chlorination Chamber Discharge to Orange	Waste Water Treatment Works	22	2001-03-30	2005-11-16	48	3-96	-30.55556	26.40278
D14 300000098	plot	data	Aliwal North WWTW at Sedimentation Tank Discharge Point	Waste Water Treatment Works	66	2000-09-21	2015-02-17	73	3-98	-30.68320	26.69584
D14 300000103	plot	data	Burgersdorp WWTW at Chlorination Chamber Discharge to Undergroun Pipe	Waste Water Treatment Works	60	2005-06-17	2015-02-18	81	3-103	-31.00638	26.33875
D23 191352	plot	data	Hobhouse Townlands 557 - at Oxidation on Hobhouse Waste Water Treatment Works	Waste Water Treatment Works	52	2012-11-14	2015-03-04	201	191352	-29.52400	27.16014
D22 191364	plot	data	Rosendal Rosendal 299 - at Rosendal Waste Water Treatment Works	Waste Water Treatment Works	54	2012-12-11	2015-02-12	124	191364	-28.50170	27.92139
D24 191369	plot	data	Smithfield - at Oxidation Pond on Smithfield WWTW	Waste Water Treatment Works	37	2013-06-19	2015-02-17	102	191369	-30.22359	26.54827
D23 191372	plot	data	Thaba Phatshwa Thaba Patchoa 105 - at Final Oxidation Pond of Thaba Patchoa WWTW	Oxidation Pond	53	2012-11-12	2015-03-04	55	191372	-29.32109	27.12362
D23 191375	plot	data	Tweespruit - at Final Oxidation Pond on Tweespruit WWTW	Oxidation Pond	54	2012-11-12	2015-03-04	159	191375	-29.18189	27.04004
D23 191386	plot	data	Wepener - at Wepener Waste Water Treatment Works	Waste Water Treatment Works	41	2013-06-19	2015-02-17	109	191386	-29.72982	27.01760
D21 300000089	plot	data	Clarens Sewage Works Discharge to Little Caledon	Waste Water Treatment Works	87	2001-06-08	2015-03-16	56	3-89	-28.51806	28.43111
D24 300000107	plot	data	Rouxville S/W at Chlorination Chaber Discharge to Kalkoenkrans	Waste Water Treatment Works	6	2005-06-14	2005-11-16	140	3-107	-30.41500	26.82500
D35 193061	plot	data	WWTW at Final Oxidation Pond Where Effluent Discharge to Soil Canal	Waste Water Treatment Works	51	2012-07-04	2015-02-17	81	ZASTRON	-30.78416	25.78514
D33 191321	plot	data	Luckhoff - at Luckhoff Waste Water Treatment Works Oxidation Pond	Waste Water Treatment Works	51	2012-04-26	2015-02-19	69	191321	-29.74577	24.77165
D34 191326	plot	data	Philippolis Philippolis 143 - at Philippolis Waste Water Treatment Works	Waste Water Treatment Works	41	2013-06-18	2015-02-19	68	191326	-30.28189	25.28037
D35 191390	plot	data	Bethulie - at Final Oxidation Pond on Bethulie WWTW	Waste Water Treatment Works	56	2012-07-04	2015-02-18	59	191390	-30.52366	25.96028
D31 191392	plot	data	Vanderkloof - at Vanderkloof Waste Water Treatment Works	Waste Water Treatment Works	50	2012-11-28	2015-02-19	52	191392	-30.00075	24.74693
D35 193064	plot	data	Oviston WWTW at Weir Discharges into Soil Canal	Waste Water Treatment Works	55	2012-07-05	2015-02-18	44	193064	-30.70145	25.75979
D33 193327	plot	data	Hopetown Sewage Treatment Works at Oxidation Ponds	Waste Water Treatment Works	54	2012-11-27	2015-03-23	75	193327	-29.60448	24.08623
D32 193465	plot	data	Noouport WWTW- Oxidation Ponds	Waste Water Treatment Works	41	2013-06-19	2015-02-19	153	193465	-31.16801	24.93877
D34 193468	plot	data	Novalspont at Oxidation Ponds	Waste Water Treatment Works	42	2013-06-18	2015-02-19	153	193468	-30.63444	25.44579
D35 300000110	plot	data	Vanderkloof S/W at the Chlorination Chamber Discharge to Vanderkloof Dam	Waste Water Treatment Works	4	2005-07-11	2005-11-28	62	3-110	-30.76250	25.78750
D35 300000113	plot	data	Venterstad S/W at the Chlorination Chamber Discharge to the Orange Rive Er	Waste Water Treatment Works	4	2005-06-17	2005-11-28	50	3-113	-30.76250	25.78750
D35 300000114	plot	data	Oviston S/W at the Chlorination Chamber Discharge to the Gariep Dam	Waste Water Treatment Works	4	2005-06-17	2005-11-28	48	3-114	-30.76667	25.75139
C51 90830	plot	data	at Rietrivier Sett. Jacobsdal on Orange-Riet Canal (ncwq NCMP)	Canal	458	1994-04-19	2017-07-31	19	C5H030	-29.14056	24.75667
C52 90832	plot	data	Rustfontein Dam on Modder River: Left Canal/River	Canal	6	1983-02-28	2013-08-07	27	C5H037	-29.27083	26.61667
C51 90834	plot	data	Kalkfontein Dam on Riet River: Left Canal (NCWQ)	Canal	592	1981-12-02	2018-06-28	48	C5H040	-29.49694	25.22139
C52 86107	plot	data	Groothoek 125 - at Pipeline to Treatment Works - Thaba Nchu at Groothoek Dam (NCWQ)	Pipeline	1	2012-04-25	2012-04-25	25	C5H050	-29.30278	26.84889
C52 187232	plot	data	De Wetskom 452 - on Novo Canal (NCWQ)	Canal	66	2012-03-29	2018-04-17	23	C5H055	-29.62417	26.71667
C51 189078	plot	data	Mayville 400 - Balancing Dam Outlet to Oranje-Riet (Sarel Hayward) Canal	Canal	59	2009-08-14	2015-03-24	21	S2	-29.16578	24.70519
C51 88778	plot	data	Kalkfontein Canal near Inflow to Orange-Riet	Canal	9	1994-03-02	1994-08-15	34	ZJAC001	-29.17194	24.73333
C51 88782	plot	data	Outflow into Riet River of Drainage Canal	Canal	11	1994-03-02	1994-08-16	52	ZJAC008	-29.13111	24.73722
C51 88783	plot	data	Outflow to Riet River at Rietrivier of Drainage Canal	Canal	9	1994-03-02	1994-08-15	47	ZJAC009	-29.09694	24.69194
C51 88784	plot	data	Outflow to Riet River at Rietrivier of Drainage Canal	Canal	9	1994-03-02	1994-08-15	54	ZJAC010	-29.09778	24.67111
C51 88781	plot	data	ZJAC007A at Inflow to S2 Balancing Dam on Orange-Riet Canal	Canal	10	1994-03-02	1994-08-16	16	88781	-29.16806	24.70694
C51 88786	plot	data	ZJAC010D at Inflow to Ritchie Weir of Ritchie Branch Canal	Canal	4	1994-05-03	1994-07-26	16	88786	-29.04222	24.60000
C51 190123	plot	data	Phambile Rietrivier Settlement East 387 on Drainage Canal (NMMP)	Canal	116	2010-10-14	2013-03-26	n/a	190123	-29.10665	24.66540
C51 191172	plot	data	Weltevrede 710 - at S555 Road Bridge on Left Main Canal from Kalkfontein Dam	Canal	55	2012-11-18	2015-03-17	57	191172	-29.49307	25.14570
C51 191429	plot	data	Trompsburg Gruisfontein 35 - at Final Oxidation Pond on Trompsburg WWTW	Canal	39	2013-07-10	2015-02-18	52	191429	-30.02650	25.79518
D14 191422	plot	data	Molteno Paarde Kraal 64 - at Molteno Waste Water Treatment Works	Pipeline	48	2013-03-19	2015-02-18	87	191422	-31.38595	26.37657
D13 191430	plot	data	Dordrecht - at Final Oxidation Pond on Dordrecht WWTW	Pipeline	51	2012-11-29	2015-02-18	60	191430	-31.36464	27.03601
D13 191436	plot	data	Barkly East - at Maturation Dam on Barkly East WWTW	Pipeline	51	2012-07-05	2015-02-18	63	191436	-30.96535	27.61313
D24 101811	plot	data	Egmont Dam on Wit Spruit: Left Canal	Canal	140	1977-11-09	1993-11-09	24	D2H024	-30.05222	27.02861
D23 101812	plot	data	Armenia Dam on Leeu River: Right Canal	Canal	63	1980-02-04	1993-10-11	22	D2H025	-29.36389	27.13167
D24 178762	plot	data	Caledon River: River Outlet K01	Canal	125	1981-09-14	2007-05-01	17	D2R004	-29.90889	26.86056
D22 191341	plot	data	Clocolan - at Pumpstation of Clocolan WWTW by Oxidation Pond	Pipeline	53	2012-11-12	2015-03-04	101	191341	-28.92923	27.56787
D21 191347	plot	data	Fouriesburg - at Fouriesburg WWTW Maturation Dam (Oxidation Pond)	Canal	56	2012-11-20	2015-03-16	71	191347	-28.62669	28.19997
D22 191360	plot	data	Ladybrand Dorp Gronden van Ladybrand 451 - at Ladybrand WWTW Final Discharge on Caledon River Tributa	Pipeline	53	2012-11-12	2015-03-04	60	191360	-29.18483	27.48839
D24 191366	plot	data	Rouxville Dorpsgronden van Rouxville 108 - at Rouxville Waste Water Treatment Works	Canal	52	2012-11-29	2015-02-17	76	191366	-30.39423	26.83175
D24 191380	plot	data	Vanstadensrus - at Vanstadensrus Waste Water Treatment Works	Canal	41	2013-06-19	2015-02-17	113	191380	-29.99008	26.99529
D35 101831	plot	data	Gariep Dam on Orange River: Turbines	Canal	72	1972-09-20	1977-06-08	17	D3H022	-30.62639	25.50722
D33 101832	plot	data	Kareekloof 1184 Vanderkloof Dam - on Right Bank Canal (NCWQ NEMP)	Canal	371	1979-12-12	2017-11-09	18	D3H024	-29.98690	24.72224
D33 187247	plot	data	Scheiding Orange-Riet Canal on Orange-Riet Canal	Canal	1	2006-05-09	2006-05-09	18	D3H034	-29.89000	24.70000
D33 190904	plot	data	Naauwpoort 417 Scheiding - at Ramah Canal	Canal	1	2011-11-29	2011-11-29	19	D3H035	-29.90677	24.70137
D33 187581	plot	data	Hopetown ptn Oranjerivier	Pipeline	2	2003-07-07	2003-07-07	25	187581	-29.62290	24.08870
D31 187583	plot	data	Vanderkloof ptn Vanderkloofdam at Reticulation Reservoir	Pipeline	2	2003-07-07	2003-07-07	20	187583	-30.00500	24.73897
D31 187585	plot	data	Philipstown	Pipeline	2	2003-07-10	2003-07-10	116	187585	-30.43947	24.47058
D34 191285	plot	data	Colesburg - at Colesburg WWTW at Oxidation Pond Overflow	Canal	43	2013-06-19	2015-02-19	58	191285	-30.69847	25.12074
D32 191312	plot	data	Hanover - at Canal Flowing from Hanover WWTW to Open Field	Canal	41	2013-06-19	2015-02-19	140	191312	-31.07186	24.46012
D31 191330	plot	data	Philipstown Slagt Kraal 133 - at Oxidation Pond on Philipstown WWTW	Pipeline	50	2012-11-28	2015-02-19	186	191330	-30.43198	24.48195
D35 191334	plot	data	Springfontein - at Pipeline from Springfontein WWTW to Unknown Tributary	Pipeline	41	2013-06-18	2015-02-18	65	191334	-30.27573	25.70760
D35 193063	plot	data	Venterstad WWTW Discharge into Drain to Soil Canal	Canal	54	2012-07-05	2015-02-18	35	193063	-30.78416	25.78514
D33 193476	plot	data	Petrusville WWTW at at Final Oxidation Pond	Canal	51	2012-11-18	2015-02-19	46	193476	-30.07362	24.66530
C51 99795	plot	data	Rietrivier Blaauwbosfontein	unknown	6	1970-06-08	1971-08-16	183	99795	-29.00833	24.14167
C51 99796	plot	data	Rietrivier Koedoesbergdam	unknown	6	1970-07-08	1971-08-16	217	99796	-28.97500	24.41667
C52 100284	plot	data	Modder Rivier	unknown	3	1976-06-14	1976-06-14	56	100284	-29.56667	26.70556
C52 100285	plot	data	Spruit Dewetsdorp Suid	unknown	1	1976-06-16	1976-06-16	44	100285	-29.59722	26.66667
C52 100935	plot	data	Florisbad (dup name 6641)	unknown	1	1988-01-14	1988-01-14	430	100935	-28.75556	26.05000
C51 101131	plot	data	Trompsburg (dup name 6753)	unknown	1	1992-09-25	1992-09-25	61	101131	-30.05944	25.76250
D14 100806	plot	data	Burghersdorp (dup name 6554)	unknown	1	1983-04-22	1983-04-22	70	100806	-31.01667	26.33333
D14 100807	plot	data	Burghersdorp (dup name 6555)	unknown	1	1983-04-22	1983-04-22	51	100807	-31.01806	26.33472
D14 100933	plot	data	Aliwal North Com	unknown	1	1988-01-11	1988-01-11	182	100933	-30.71611	26.72083
D12 101127	plot	data	Ladygrey	unknown	1	1992-09-23	1992-09-23	36	101127	-30.72250	27.23694
D23 100116	plot	data	Leeurivier Yaxham	unknown	1	1972-10-26	1972-10-26	15	100116	-29.37083	27.13333
D23 100132	plot	data	Caledonrivier Welbedacht	unknown	6	1973-02-05	1973-02-09	17	100132	-29.90833	26.85833
D24 100932	plot	data	Beersheba	unknown	1	1988-01-11	1988-01-11	47	100932	-30.12000	26.73333
D33 1000000770	plot	data	Taay Bosch Draai NO1	unknown	1	2002-07-30	2002-07-30	193	8	-29.89428	24.48942
D34 99824	plot	data	Plaasdam	unknown	6	1976-11-18	1976-12-02	59	99824	-30.24861	25.24583
D33 99884	plot	data	Segorong Spruit (dup name 6034)	unknown	1	1977-11-25	1977-11-25	10	99884	-30.24583	24.36667
D31 100186	plot	data	Driekoprivier	unknown	1	1975-02-20	1975-02-20	600	100186	-30.05833	24.95000
D34 100203	plot	data	Oranje River downstream Hv Dam	unknown	3	1975-08-06	1975-08-20	15	100203	-30.62639	25.50139
D35 101230	plot	data	Badsfontein (dup name 6793)	unknown	1	1994-01-10	1994-01-10	97	101230	-30.88056	25.77639
D32 101558	plot	data	Hanover Allotment (dup name 7029)	unknown	1	1997-11-20	1997-11-20	94	101558	-31.07278	24.43278
D32 101559	plot	data	Hanover Allotment (dup name 7030)	unknown	1	1997-11-20	1997-11-20	81	101559	-31.06111	24.43222
D32 101560	plot	data	Hanover Allotment (dup name 7031)	unknown	1	1997-11-20	1997-11-20	90	101560	-31.07389	24.42750
C52 1000003271	plot	data	Petrusburg Meent PBG01/0001 - Rf	Meteorology	5	2003-02-05	2008-02-14	6	1-3271	-29.11804	25.44021
C52 1000003273	plot	data	Theronskop PBG02/0001 - Rf	Meteorology	3	2003-02-04	2004-02-03	5	1-3273	-29.19797	25.55950
C52 1000003275	plot	data	Attleborough PBG03/0001 - Rf	Meteorology	5	2003-02-04	2008-02-14	6	1-3275	-29.16322	25.61350
D14 86240	plot	data	0175-373A Aliwal-North - Evaporation Station at Aliwal-North School	Meteorology	1	1992-09-23	1992-09-23	221	D1E001	-30.70000	26.70611

2019-10-18 23:10:20 | WMS water quality sites home | kml_WMS_mnpts_html.R v 7.4 db = SQLite