-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsensorWikiDataDumpComplete.sql
1631 lines (1299 loc) · 43.7 KB
/
sensorWikiDataDumpComplete.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
--
-- PostgreSQL database dump
--
-- Dumped from database version 14.1 (Debian 14.1-1.pgdg110+1)
-- Dumped by pg_dump version 14.1 (Debian 14.1-1.pgdg110+1)
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- Name: Device; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public."Device" (
id integer NOT NULL,
slug text NOT NULL,
contact text,
website text,
validation boolean DEFAULT false NOT NULL,
image text,
"labelId" integer,
"descriptionId" integer,
"markdownId" integer
);
ALTER TABLE public."Device" OWNER TO postgres;
--
-- Name: Device_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public."Device_id_seq"
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public."Device_id_seq" OWNER TO postgres;
--
-- Name: Device_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public."Device_id_seq" OWNED BY public."Device".id;
--
-- Name: Domain; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public."Domain" (
id integer NOT NULL,
slug text NOT NULL,
validation boolean DEFAULT false NOT NULL,
"labelId" integer,
"descriptionId" integer
);
ALTER TABLE public."Domain" OWNER TO postgres;
--
-- Name: Domain_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public."Domain_id_seq"
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public."Domain_id_seq" OWNER TO postgres;
--
-- Name: Domain_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public."Domain_id_seq" OWNED BY public."Domain".id;
--
-- Name: Element_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public."Element_id_seq"
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public."Element_id_seq" OWNER TO postgres;
--
-- Name: Element; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public."Element" (
id integer DEFAULT nextval('public."Element_id_seq"'::regclass) NOT NULL,
accuracy double precision,
"sensorId" integer NOT NULL,
"phenomenonId" integer NOT NULL,
"unitId" integer
);
ALTER TABLE public."Element" OWNER TO postgres;
--
-- Name: Language; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public."Language" (
code character varying(2) NOT NULL,
label character varying(255)
);
ALTER TABLE public."Language" OWNER TO postgres;
--
-- Name: Phenomenon; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public."Phenomenon" (
id integer NOT NULL,
slug text NOT NULL,
validation boolean DEFAULT false NOT NULL,
"labelId" integer,
"descriptionId" integer,
"markdownId" integer
);
ALTER TABLE public."Phenomenon" OWNER TO postgres;
--
-- Name: Phenomenon_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public."Phenomenon_id_seq"
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public."Phenomenon_id_seq" OWNER TO postgres;
--
-- Name: Phenomenon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public."Phenomenon_id_seq" OWNED BY public."Phenomenon".id;
--
-- Name: RangeOfValues_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public."RangeOfValues_id_seq"
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public."RangeOfValues_id_seq" OWNER TO postgres;
--
-- Name: RangeOfValues; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public."RangeOfValues" (
id integer DEFAULT nextval('public."RangeOfValues_id_seq"'::regclass) NOT NULL,
min integer,
max integer,
"unitId" integer NOT NULL,
"phenomenonId" integer NOT NULL
);
ALTER TABLE public."RangeOfValues" OWNER TO postgres;
--
-- Name: Sensor; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public."Sensor" (
id integer NOT NULL,
slug text NOT NULL,
manufacturer text,
"lifePeriod" integer,
price double precision,
validation boolean DEFAULT false NOT NULL,
image text,
datasheet text,
"labelId" integer,
"descriptionId" integer
);
ALTER TABLE public."Sensor" OWNER TO postgres;
--
-- Name: Sensor_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public."Sensor_id_seq"
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public."Sensor_id_seq" OWNER TO postgres;
--
-- Name: Sensor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public."Sensor_id_seq" OWNED BY public."Sensor".id;
--
-- Name: Translation_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public."Translation_id_seq"
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public."Translation_id_seq" OWNER TO postgres;
--
-- Name: Translation; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public."Translation" (
id integer DEFAULT nextval('public."Translation_id_seq"'::regclass) NOT NULL
);
ALTER TABLE public."Translation" OWNER TO postgres;
--
-- Name: TranslationItem; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public."TranslationItem" (
"languageCode" text NOT NULL,
text character varying(4096) NOT NULL,
"translationId" integer NOT NULL
);
ALTER TABLE public."TranslationItem" OWNER TO postgres;
--
-- Name: Unit; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public."Unit" (
id integer NOT NULL,
slug text NOT NULL,
name character varying(255) NOT NULL,
notation character varying(255) NOT NULL,
validation boolean DEFAULT false NOT NULL,
"descriptionId" integer
);
ALTER TABLE public."Unit" OWNER TO postgres;
--
-- Name: Unit_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public."Unit_id_seq"
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public."Unit_id_seq" OWNER TO postgres;
--
-- Name: Unit_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public."Unit_id_seq" OWNED BY public."Unit".id;
--
-- Name: _DeviceToSensor; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public."_DeviceToSensor" (
"A" integer NOT NULL,
"B" integer NOT NULL
);
ALTER TABLE public."_DeviceToSensor" OWNER TO postgres;
--
-- Name: _DomainToPhenomenon; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public."_DomainToPhenomenon" (
"A" integer NOT NULL,
"B" integer NOT NULL
);
ALTER TABLE public."_DomainToPhenomenon" OWNER TO postgres;
--
-- Name: Device id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public."Device" ALTER COLUMN id SET DEFAULT nextval('public."Device_id_seq"'::regclass);
--
-- Name: Domain id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public."Domain" ALTER COLUMN id SET DEFAULT nextval('public."Domain_id_seq"'::regclass);
--
-- Name: Phenomenon id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public."Phenomenon" ALTER COLUMN id SET DEFAULT nextval('public."Phenomenon_id_seq"'::regclass);
--
-- Name: Sensor id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public."Sensor" ALTER COLUMN id SET DEFAULT nextval('public."Sensor_id_seq"'::regclass);
--
-- Name: Unit id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public."Unit" ALTER COLUMN id SET DEFAULT nextval('public."Unit_id_seq"'::regclass);
--
-- Data for Name: Device; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public."Device" (id, slug, contact, website, validation, image, "labelId", "descriptionId", "markdownId") FROM stdin;
1 sensebox_home \N \N f sensebox_home.jpg 1 2 3
2 sensebox_edu \N \N f sensebox_edu.jpg 4 5 6
3 airdatainfo_device \N \N f airdatainfo_device.jpeg 7 8 113
\.
--
-- Data for Name: Domain; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public."Domain" (id, slug, validation, "labelId", "descriptionId") FROM stdin;
1 air_quality f 44 45
2 climate_phenomena f 46 47
3 ground_phenomena f 48 49
4 water_phenomena f 142 143
\.
--
-- Data for Name: Element; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public."Element" (id, accuracy, "sensorId", "phenomenonId", "unitId") FROM stdin;
5 2 3 2 4
9 3 5 5 4
10 0.8 5 3 2
13 \N 8 8 \N
14 \N 25 9 \N
15 \N 25 10 \N
8 0.4 4 3 2
6 30 4 4 5
7 3 4 2 4
12 0 7 7 7
11 1 7 6 11
1 0.12 1 1 3
2 3 1 2 4
3 0 1 3 2
4 0.12 2 1 3
17 \N 43 9 \N
18 10 47 14 13
\.
--
-- Data for Name: Language; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public."Language" (code, label) FROM stdin;
en English
de German
es Spanish
fr French
\.
--
-- Data for Name: Phenomenon; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public."Phenomenon" (id, slug, validation, "labelId", "descriptionId", "markdownId") FROM stdin;
1 barometric_pressure f 23 24 25
2 relative_humidity f 26 27 28
3 temperature f 29 30 31
4 co2 f 32 33 34
5 soil_moisture f 35 36 37
6 ambient_light f 38 39 40
7 ultraviolet_a_light t 41 42 43
8 humidity f 104 105 106
9 pm25 f 107 108 109
10 pm10_concentration f 110 111 112
13 air_temperature f 136 137 138
14 precipitation f 139 140 141
15 volatile_organic_compound_voc f 146 147 148
16 voltage f 149 150 151
17 sound_level f 154 155 156
18 water_level f 157 158 159
19 water_temperature f 160 161 162
20 wind_direction f 163 164 165
21 wind_speed f 166 167 168
\.
--
-- Data for Name: RangeOfValues; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public."RangeOfValues" (id, min, max, "unitId", "phenomenonId") FROM stdin;
1 0 100000 11 6
5 0 200 8 13
6 -273 200 2 13
7 \N \N 13 14
8 \N \N 14 16
9 \N \N 15 21
\.
--
-- Data for Name: Sensor; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public."Sensor" (id, slug, manufacturer, "lifePeriod", price, validation, image, datasheet, "labelId", "descriptionId") FROM stdin;
3 hdc1080 Texas Instruments 364 2.03 t \N \N 13 14
5 smt50 TRUEBNER GmbH 365 0 f \N \N 17 18
6 tsl4531 ams 50 0.5 f \N \N 19 20
8 bme280 \N \N \N f \N \N 50 51
10 dht22 \N \N \N f \N \N 54 55
11 ds18b20 \N \N \N f \N \N 56 57
12 ds18s20 \N \N \N f \N \N 58 59
13 hpm \N \N \N f \N \N 60 61
14 htu21d \N \N \N f \N \N 62 63
15 neo-6m \N \N \N f \N \N 64 65
16 no2-a43f \N \N \N f \N \N 66 67
17 pms1003 \N \N \N f \N \N 68 69
18 pms3003 \N \N \N f \N \N 70 71
19 pms5003 \N \N \N f \N \N 72 73
20 pms6003 \N \N \N f \N \N 74 75
21 pms7003 \N \N \N f \N \N 76 77
22 ppd42ns \N \N \N f \N \N 78 79
23 sbm-19 \N \N \N f \N \N 80 81
24 sbm-20 \N \N \N f \N \N 82 83
25 sds011 \N \N \N f \N \N 84 85
26 sds021 \N \N \N f \N \N 86 87
27 sht10 \N \N \N f \N \N 88 89
28 sht11 \N \N \N f \N \N 90 91
29 sht15 \N \N \N f \N \N 92 93
30 sht30 \N \N \N f \N \N 94 95
31 sht31 \N \N \N f \N \N 96 97
32 sht35 \N \N \N f \N \N 98 99
33 sht85 \N \N \N f \N \N 100 101
34 sps30 \N \N \N f \N \N 102 103
4 scd30 Sensirion 5475 0 f \N \N 15 16
7 veml6070v2 Vishay 2 1 f \N https://pdf1.alldatasheet.com/datasheet-pdf/view/911505/VISHAY/VEML6070.html 21 22
1 bme680 Bosch 365 0 f \N \N 9 10
2 bmp280 Bosch Sensortec 360 23.7 f \N \N 11 12
36 as7262 \N \N \N f \N \N 170 171
37 bmp085 Bosch \N \N f \N \N 172 173
9 bmp180 Bosch \N \N f \N \N 52 53
38 csm-m8q \N \N \N f \N \N 174 175
39 dht11 \N \N \N f \N \N 176 177
40 gl5528 \N \N \N f \N \N 178 179
41 grove_-_multichannel_gas_sensor \N \N \N f \N \N 180 181
42 hdc1008 \N \N \N f \N \N 182 183
43 hm3301 \N \N \N f \N \N 184 185
44 lm35 \N \N \N f \N \N 186 187
45 lm386 \N \N \N f \N \N 191 192
46 max4465 \N \N \N f \N \N 193 194
48 ox-a431 \N \N \N f \N \N 197 198
47 optical_rain_gauge_rg_15 \N \N \N f \N https://files.seeedstudio.com/products/114992321/res/RG-15_instructions_sw_1.000.pdf 195 196
49 sen0232 DFRobot \N \N f \N https://wiki.dfrobot.com/Gravity__Analog_Sound_Level_Meter_SKU_SEN0232 199 200
50 si22g \N \N \N f \N \N 201 202
51 tsl2561 \N \N \N f \N \N 203 204
52 tx20 \N \N \N f \N \N 205 206
\.
--
-- Data for Name: Translation; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public."Translation" (id) FROM stdin;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
120
121
123
124
125
134
135
136
137
138
139
140
141
142
143
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
\.
--
-- Data for Name: TranslationItem; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public."TranslationItem" ("languageCode", text, "translationId") FROM stdin;
de Die senseBox:home ist ein Toolkit für Umweltmessungen. 2
de 3
de Die senseBox:edu ist ein Toolkit für Umweltmessungen. 5
de 6
de Gerät zur Messung der Lufqualität. 8
de Der BME680 ist ein Gassensor, der hochlineare und hochgenaue Gas-, Druck-, Feuchte- und Temperatursensoren integriert. 10
de Der barometrische Drucksensor BMP280 von Bosch Sensortec ist ein absoluter Drucksensor, der speziell für mobile Anwendungen entwickelt wurde. Er kann auch die Lufttemperatur messen. 12
de HDC1080 13
en HDC1080 13
de Der Sensor HDC1080 von Texas Instruments ist ein digitaler Feuchtigkeitssensor. Er misst die relative Luftfeuchtigkeit und die Temperatur. 14
en The Texas Instruments' HDC1080 sensor is a digital humidity sensor. It measures relative humidity and and temperature. 14
de Der SCD30 von Sensirion ist ein hochwertiger, auf nicht-dispersivem Infrarot (NDIR) basierender CO₂-Sensor, der 400 bis 10000ppm mit einer Genauigkeit von ±(30ppm+3%) erfassen kann. 16
de SMT50 17
en SMT50 17
de Der SMT50 wird von TRUEBNER entwickelt und hergestellt. Er ist ein FDR-Bodenfeuchtesensor. Das Gehäuse und das Kabel sind wasserdicht. 18
en The SMT50 is designed and manufactured by TRUEBNER. It is a FDR soil moisture sensor. The casing and cable is water sealed. 18
de TSL4531 19
en TSL4531 19
de Der AMS TSL4531 Lichtsensor ist ein Umgebungslichtsensor. Er erkennt also die Helligkeit des Umgebungslichts. 20
en The AMS TSL4531 light sensor is an ambient light sensor. Therefore, it detects the brightness of ambient light. 20
de Der VEML6070 ist ein fortschrittlicher Ultraviolett (UV)-Lichtsensor mitI2C-Protokollschnittstelle und wurde im CMOS-Verfahren entwickelt. 22
de Der barometrische Druck ist der Druck in der Atmosphäre der Erde. Er wird auch als atmosphärischer Druck bezeichnet. 24
de 25
de Die relative Luftfeuchtigkeit (RH) ist das Verhältnis zwischen dem Partialdruck von Wasserdampf und dem Gleichgewichtsdampfdruck von Wasser bei einer bestimmten Temperatur. (Quelle: Wikipedia) 27
de 28
de Temperatur 29
en Temperature 29
de Beschreibt die Wärme eines Mediums. 30
en Describes the warmness of a medium. 30
de 31
en 31
de Kohlendioxid (CO2) wird in parts-per-per-million (ppm) gemessen. 33
de test 34
de Bodenfeuchte 35
en Soil moisture 35
de Bodenfeuchtesensoren messen den volumetrischen Wassergehalt im Boden. 36
en Soil moisture sensors measure the volumetric water content in soil. 36
de 37
en 37
de Die Intensität des Umgebungslichts entspricht der Reaktion des menschlichen Auges auf Licht unter verschiedenen Lichtverhältnissen. 39
de 40
de Ultraviolett A Licht 41
en Ultraviolet A light 41
de Ultraviolettes Licht mit einer Wellenlänge zwischen 315 und 380 nm. 42
en Ultraviolet light with wavelength between 315 and 380 nm. 42
de 43
en 43
de Phänomene, die mit der Qualität der Luft zusammenhängen. Zum Beispiel können sie uns sagen, aktualisieren Luftverschmutzung Ebene. 45
de Phänomene, die mit dem Klima und/oder klimatischen Veränderungen zusammenhängen. 47
de Bodenphänomene 48
en Ground phenomena 48
en The SCD30 from Sensirion is a high quality non-dispersive infrared (NDIR) based CO₂ sensor capable of detecting 400 to 10000ppm with an accuracy of ±(30ppm+3%). 16
en 25
de Barometric pressure 23
de SCD30 15
en SCD30 15
de Phänomene, die im Boden gemessen werden können. 49
en Phenomena that can be measured in the ground. 49
de BME280 50
en BME280 50
de Feuchtigkeit 51
en Humidity 51
en 28
de VEML6070V2 21
en 34
en VEML6070V2 21
en VEML6070 is an advanced ultraviolet (UV) light sensor withI2C protocol interface and designed by the CMOS process. 22
de Umgebungslicht 38
en Ambient Light 38
de LuftdatenInfo Gerät 7
en 40
en BMP280 11
en The sensebox:home is a kit for environmental sensing. 2
de Klimaphänomen 46
en 3
en senseBox:edu 4
en The senseBox:edu is a kit for environmental sensing. 5
en 6
de Luftqualität 44
de senseBox:edu 4
de BME680 9
en Air quality 44
en The BME680 is a gas sensor that integrates high-linearity and high-accuracy gas, pressure, humidity and temperature sensors. 10
en Phenomenona that are related to climate and/or climatic changes. 47
en BME680 9
en Phenomenona that are related to the quality of air. For instance, they can tell us update air pollution level. 45
en Climate phenomena 46
en Ambient light intensity matches the human eye's response to light under a variety of lighting conditions. 39
de BMP180 52
en Bosch Sensortec barometric pressure Sensor BMP280 is an absolute barometric pressure sensor especially designed for mobile applications. Also able to measure air temperature. 12
en LuftdatenInfo Device 7
de BMP280 11
en BMP180 52
en Device to measure air quality. 8
de Der BMP180 ist die nächste Generation von Sensoren von Bosch und ersetzt den BMP085. 53
de DHT22 54
en DHT22 54
de Digitaler Sensor zur Messung von Temperatur und Luftfeuchtigkeit. Besonders geeignet für Raspberry und Arduino. 55
en Digital sensor for measuring temperature and humidity. Particularly suitable for Raspberry and Arduino. 55
de DS18B20 56
en DS18B20 56
de Das Digitalthermometer DS18B20 bietet 9-Bit- bis 12-Bit-Celsius-Temperaturmessungen und verfügt über eine Alarmfunktion mit nichtflüchtigen, vom Benutzer programmierbaren oberen und unteren Auslösepunkten. Das DS18B20 kommuniziert über einen 1-Wire-Bus, der per Definition nur eine Datenleitung (und Masse) für die Kommunikation mit einem zentralen Mikroprozessor benötigt. Darüber hinaus kann der DS18B20 direkt über die Datenleitung mit Strom versorgt werden ('parasite power'), so dass eine externe Stromversorgung nicht erforderlich ist. 57
en The DS18B20 digital thermometer provides 9-bit to 12-bit Celsius temperature measurements and has an alarm function with nonvolatile user-programmable upper and lower trigger points. The DS18B20 communicates over a 1-Wire bus that by definition requires only one data line (and ground) for communication with a central microprocessor. In addition, the DS18B20 can derive power directly from the data line (“parasite power”), eliminating the need for an external power supply. 57
de DS18S20 58
en DS18S20 58
de Temperatur 59
en Temperature 59
de HPM 60
en HPM 60
de Luftqualität 61
en Air quality 61
de HTU21D 62
en HTU21D 62
de Feuchtigkeitssensor 63
en Humidity sensor 63
de NEO-6M 64
en NEO-6M 64
de GPS 65
en GPS 65
de NO2-A43F 66
en NO2-A43F 66
de Gassensor 67
en Gas sensor 67
de PMS1003 68
en PMS1003 68
de Der PMS 1003 Sensor ist ein neuer laserbasierter Luftqualitätssensor, der von plantower (chinesischer Name: 攀藤 (pānténg)) entwickelt wurde und in zahlreichen Geräten zur Messung der Luftqualität eingesetzt wird. 69
en The PMS 1003 sensor is a recent laser based air quality sensor developped by plantower (chinese name: 攀藤 (pānténg)) and used inside a numerous number of air quality sensing devices. 69
de PMS3003 70
en PMS3003 70
de Luftqualitätssensor 71
en Air quality sensor 71
de PMS5003 72
en PMS5003 72
de TODO 73
en TODO 73
de PMS6003 74
en PMS6003 74
de Luftqualität 75
en Air quality 75
de PMS7003 76
en PMS7003 76
de Der Sensor nutzt das Prinzip der Laser-Streuung. Es bedeutet, dass das Laserlicht auf die Partikel in der Luft und machen die Streuung, während das Sammeln von Streulicht in einem bestimmten Winkel, was in Streulichtintensität mit der Zeit Kurve. 77
en The sensor uses the principle of laser scattering. It means that the laser light on the particles in the air and making the scattering, while collecting scattered light at a particular angle , resulting in scattered light intensity with time curve. 77
de PPD42NS 78
en PPD42NS 78
de Luftqualität 79
en Air quality 79
de SBM-19 80
en SBM-19 80
de Strahlung 81
en Radiation 81
de SBM-20 82
en SBM-20 82
de Strahlung 83
en Radiation 83
de SDS011 84
en SDS011 84
de Partikelsensor 85
en Particular matter sensor 85
de SDS021 86
en SDS021 86
de Luftqualität 87
en Air quality 87
de SHT10 88
en SHT10 88
de Feuchtigkeit 89
en Humidity 89
de SHT11 90
en SHT11 90
de Feuchtigkeit 91
en Humidity 91
de SHT15 92
en SHT15 92
de Feuchtigkeit 93
en Humidity 93
de SHT30 94
en SHT30 94
de Feuchtigkeit 95
en Humidity 95
de SHT31 96
en SHT31 96
de Temperatur- und Feuchtigkeitssensor 97
en Temperature and humidity sensor 97
de SHT35 98
en SHT35 98
de Feuchtigkeit 99
en Humidity 99
de SHT85 100
en SHT85 100
de Der digitale Feuchtesensor SHT85 ist der klassenbeste Feuchtesensor von Sensirion mit einem Stiftstecker für einfache Integration und Austausch. 101
en The digital humidity sensor SHT85 is Sensirion's best-in-class humidity sensor with a pin-type connector for easy integration and replacement. 101
de SPS30 102
en SPS30 102
de Partikelsensor 103
en Particulate matter sensor 103
de Feuchtigkeit 104
en Humidity 104
de Eine Größe, die die Menge an Wasserdampf in der Atmosphäre oder in einem Gas angibt. 105
en A quantity representing the amount of water vapour in the atmosphere or in a gas. 105
de 106
en 106
de PM2.5 107
en PM2.5 107
de 108
en 108
de 109
en 109
de PM10-Konzentration 110
en PM10 concentration 110
de Die Konzentration von Partikeln in der Luft. 111
en The concentration of particles in the air. 111
de 112
en 112
de 113
de deTest 114
de 115
de 116
de 117
de 118
de 120
de 121
en The degree Celsius is a unit of temperature on the Celsius scale, a temperature scale originally known as the centigrade scale. The degree Celsius can refer to a specific temperature on the Celsius scale or a unit to indicate a difference or range between two temperatures. 115
en The pascal is the SI derived unit of pressure used to quantify internal pressure, stress, Young's modulus, and ultimate tensile strength. The unit, named after Blaise Pascal, is defined as one newton per square metre and is equivalent to 10 barye in the CGS system. 116
en In mathematics, a percentage is a number or ratio expressed as a fraction of 100. It is often denoted using the percent sign, "%", although the abbreviations "pct.", "pct" and sometimes "pc" are also used. A percentage is a dimensionless number; it has no unit of measurement. 117
en A SI derived unit of density of heat flow rate, irradiance, and radiant energy fluence rate equal to one watt per the unit area of one square meter. 120
en The Fahrenheit scale is a temperature scale based on one proposed in 1724 by the physicist Daniel Gabriel Fahrenheit. It uses the degree Fahrenheit as the unit. 121
en The lux is the SI derived unit of illuminance, measuring luminous flux per unit area. It is equal to one lumen per square metre. In photometry, this is used as a measure of the intensity, as perceived by the human eye, of light that hits or passes through a surface. 135
en Barometric pressure is the pressure within the atmosphere of the Earth. It is also called atmospheric pressure. 24
en Barometric pressure 23
en NO2 concentration 123
de NO2 Konzentration 123
en The Air Quality Standards Regulations 2010 require that the annual mean concentration of NO2 must not exceed 40 µg/m3 and that there should be no more than 18 exceedances of the hourly mean limit value (concentrations above 200 µg/m3) in a single year. 124
en 125
en The concentration of an air pollutant (eg. ozone) is given in micrograms (one-millionth of a gram) per cubic meter air or µg/m³. 134
de Relative Luftfeuchte 26
en Relative humidity (RH) is the ratio of the partial pressure of water vapor to the equilibrium vapor pressure of water at a given temperature. (Source: Wikipedia) 27
en Relative humidity 26
en The millimetre or millimeter is a unit of length in the metric system, equal to one thousandth of a metre, which is the SI base unit of length. Therefore, there are one thousand millimetres in a metre. There are ten millimetres in a centimetre. One millimetre is equal to 1000 micrometres or 1000000 nanometres. 145
de senseBox:home 1
en senseBox:home 1
en The volt is the derived unit for electric potential, electric potential difference, and electromotive force. It is named after the Italian physicist Alessandro Volta. 152
en Parts per million (ppm) is the number of units of mass of a contaminant per million units of total mass. Source: GreenFacts. More: ppm (or ppm(m)) is used to measure the concentration of a contaminant in soils and sediments. In that case 1 ppm equals 1 mg of substance per kg of solid (mg/kg). 118
en Voltage 149
en 113
de Spannung 149
en Voltage, electric potential difference, electric pressure or electric tension is the difference in electric potential between two points, which (in a static electric field) is defined as the work needed per unit of charge to move a test charge between the two points. In the International System of Units, the derived unit for voltage (potential difference) is named volt. 150
en Precipitation 139