Exporting spectral values
It is possible to export spectral values for further processing in excel or other applications. For this we use the Export Viewset.
Choose Export Results (CSV) as the export action:
Note: enter a sample period of 0 when you want the raw (unsampled) data.
From the list of properties, select either Octaves (A, C or Z weighted) in the Spectra category:
Or select ⅓ octaves, also available in (A, C or Z weighted):
In the resulting CSV the columns are named with bin_ names. Starting from 0 to 42. Not all of those bins will contain data, most sensors use a smaller range.
Bin to Hertz Mapping
0 => 1.25 Hz,
1 => 1.6 Hz,
2 => 2 Hz,
3 => 2.5,
4 => 3.15,
5 => 4,
6 => 5,
7 => 6.3,
8 => 8,
9 => 10,
10 => 12.5,
11 => 16,
12 => 20,
13 => 25,
14 => 31.5,
15 => 40,
16 => 50,
17 => 63,
18 => 80,
19 => 100,
20 => 125,
21 => 160,
22 => 200,
23 => 250,
24 => 315,
25 => 400,
26 => 500,
27 => 630,
28 => 800,
29 => 1000,
30 => 1250,
31 => 1600,
32 => 2000,
33 => 2500,
34 => 3150,
35 => 4000,
36 => 5000,
37 => 6300,
38 => 8000,
39 => 10000,
40 => 12500,
41 => 16000,
42 => 20000,
Querying spectral values via the webservice
The same options are also available via the webservice.
For ⅓ octaves, use:
- spectrum_a
- spectrum_c
- spectrum_z
https://your_portal.munisense.net/webservices/v2/soundmeasurementpoints/<measurement_point_id>/spectrum_z/query/2022-11-17T14:00:00.000+00:00
For full octaves, use:
- octaves_a
- octaves_c
- octaves_z
https://your_portal.munisense.net/webservices/v2/soundmeasurementpoints/<measurement_point_id>/octaves_z/query/2022-11-17T14:00:00.000+00:00
To fetch individual ⅓ octave bands use the bin to hertz table and prefix the index with "spectrum_bins_bin_"
So to fetch results from the 1000Hz band, use spectrum_bins_bin_29
https://your_portal.munisense.net/webservices/v2/soundmeasurementpoints/<measurement_point_id>/spectrum_bins_bin_29/query/2022-11-17T14:00:00.000+00:00
0 Comments