Files currently created by poorly written jupyter notebook ~u0035056/ebus/mob_aq_lev2_wtrax.ipynb Description of monthly csv formatted files containing mobile observations aggregated into minute median values on a .0005 latitude-longitude grid (~550 km). There are separate files for TRAX and ebuses. The objective is to have files that integrate all observations available during each minute in that grid square. Observations are summarized as medians. The total number of observations are available. Flags obtained at earlier QC checks are counted. Users can decide to reject median observations when one or more flags are tripped. File location from CHPC: ebus: /uufs/chpc.utah.edu/common/home/horel-group8/horel/meop/level3/ebus_YYYY trax: /uufs/chpc.utah.edu/common/home/horel-group8/horel/meop/level3/trx_YYYY File location externally: ebus: https://horel.chpc.utah.edu/data/meop/level3/ebus_YYYY trax: https://horel.chpc.utah.edu/data/meop/level3/trx_YYYY File names ebus_min_YYYY_MM.csv trx_min_YYYY_MM.csv Variables. Time: YYYY-MM-DD HH:mm:00 LOCAL TIME LAT: Latitude LON: Longitude ROW,COL: location in the Salt Lake Valley defined by index values within a 91x100 0.005 resolution lat-lon grid ROW is longitude and COL is latitude. Further Grid information included below GSP: Onboard GPS-derived vehicle speed (m/s) SP: Vehicle speed derived from successive lat/lon locations (m/s) TT: External air temperature (C) inside radiation shield on top of vehicle. Exterior temperature in non-aspirated shield (may read higher than environment if bus not moving) TRH: External relative humidity (%) inside radiation shield on top of vehicle. PM may read heigher than environment if TRH high (> 80%) PM1: PM2.5, PM4, PM10. Particulate concentrations of differing sizes (ug/m^3). Particulate sensors installed vary over time. PM2.5 concentrations are typically available PRHI: RH inside particulate sensor. When sensor detects RH > 35%, then heater turned on to attempt to maintain that RH. That often leads to PM concentration oscillations in moist environments as the heater cycles on/off to maintain that sensor RH O3: ozone concentration (ppb) PMF: Particulate concentration flag: 0- less likely to have issues for all obs; 1+- count of high RH (> 80%) likely to create issues or possibly low flow rate O3F: Ozone concentration flag flag: 0- less likely to have issues for all obs; 1+- count of issues including low flow rate GPF: GPS flag: 0 likely to be outside depot area; 1+ count of obs located within Bus Depot area SPF: Speed flag: 0 likely to be moving for all obs: 1+ count of observations with bus speed < 1 m/s The fundamental parameters defining the aggregated statistics in these files are: Grid squares at 0.005 degree latitude/longitude (~550 m) resolution defining the core area in Salt Lake County covered by the bus routes The current reasoning for this file format is as follows: While data are recorded at 5 sec intervals on buses and 2 seconds on Trax, the core sensors (temp, PM, and O3) have time responses longer than that (order minute). SLC city blocks are typically 200 m in length. Hence, observations are aggregated within 1-2+ typical blocks route sections in each direction Buses and Trains travel at speeds up to 30 m/s but typically are moving along routes at speeds of 5-15 m/s and stopping frequently. Example rows for 2024_06 ebus file times,LAT,LON,ELV,ROW,COL,GSP,SP,TT,TRH,PM1,PM2.5,PM4,PM10,PRHI,O3,PMF,O3F,GPF,SPF,MOB 2024-06-01 00:00:00,40.67596,-111.86558,1311.9,45,67,4.0,3.2,25.8,19.3,,,,,,57.6,0,0,0,5,11 2024-06-01 00:00:00,40.7637,-111.90948,1296.2,63,58,0.0,0.0,27.8,15.9,,3.0,,,13.0,49.4,0,0,33,26,33 Interpetation of reports based on info above. Row 1: Time: midnight LT Median GPS speed: 4 m/sec Median Calc Speed: 3.2 m/sec (both values reasonable) Temp: 25.8 RH: 19.3 % No PM available Median Ozone: 57.6 ppb PM,O3, GPS flags all 0 indicating no flags tripped for PM or O3 and not in bus depot area SPF: 5- some of the obs were when a bus was not moving MOB: 11 total observations in this grid squares ROW : Time: midnight LT Median GPS speed: 0 m/sec Median Calc Speed: 0 m/sec (both values 0 implies not moving and likely in depot area) Mewdian Temp: 27.8 Median RH: 15.9 % Median PM 2.5: 3 ug/m3 Median RH: 13% Median Ozone: 49.4 ppb PM,O3 flags: 0 indicating no flags tripped for PM or O3 GPF: 33. Indicates 33 obs in depot area SPF: 25 (out of 33)- some of the obs were moving (or GPS inaccurate enough that showing > 1 m/s motion in 8 cases) MOB: 33 total observations in this grid square These observations are not likely in error, but one of many in depot area trx_min_YYYY_MM.csv TRAX file times,LAT,LON,ELV,ROW,COL,SP,TT,TRH,PM2.5,PRHI,O3,PMF,O3F,GPF,SPF,MOB 2024-06-01 00:00:00,40.699,-111.95801,1298.5,50,48,15.7,28.2,16.6,2.5,12.0,48.6,12,0,0,0,12 Time: Midnight LT Median Calc Speed: 15.7 m/sec Median Temp: 28.2 C Median RH: 16.6 % Median PM 2.5: 3 ug/m3 Median RH: 12% Median Ozone: 48.6 ppb PMF: 12. Possibly flow rate issues, O3 flag: 0 indicating no flags tripped for O3 SP flag: 0 Trax moving MOB: 12 observations in this grid square in this minute Grid Information Corner coordinates of the grid are as follows: bot_left_lat = 40.45 bot_left_lon = -112.20 top_right_lat = 40.95 top_right_lon = -111.75 Companion csv files provide the longitude and latitude for each of the 91x100 grid squares longitude_005.csv latitude_005.csv Additional QC applied prior to aggregation A vehicle must report at least one of the following: Top Temperature; O3, or PM2.5 Bus top temperatures set to nan if BTT<-30C or BTT>50C Bus reports from outside the grid domain removed Ozone concentrations less than 0 set to 0