Content
# #buellton — 2026-03-05
**12:22 [Kevin](https://slack.com/archives/C091185E1JN/p1772742123554449):** @AutoBot show any notes on the buellton server wwtp flow data extraction that you have
**12:22 [AutoBot](https://slack.com/archives/C091185E1JN/p1772742124493119):** :mag: Searching the vault…
**12:22 [AutoBot](https://slack.com/archives/C091185E1JN/p1772742131745499):**
Notes on Buellton server WWTP flow data extraction:
- On 2026-02-24, Kevin asked Mason Radke to query AutoBot for notes on extracting/manipulating the WWTP flow data, suggesting keywords like "wwtp flow sql" to search in Slack. Mason found no results for extracting or manipulating flow data and requested Kevin to share any findings so he could add them (Source: 2026-02-24_buellton.md).
- On 2026-03-03, Kevin reported transferring existing WWTP flow data from the old SCADA server to the new server at the path:
`C:\ProgramData\Schneider Electric\ClearSCADA\Database\Backups\From old server`
He noted the need to shut down SCADA, copy old data to the new server, then restart SCADA (Source: 2026-03-03_buellton.md).
- The SCADA software used is Geo SCADA (formerly ClearSCADA) by Schneider Electric, running on a server located in the WWTP Lab building (Source: Client_Summary.md).
- The GeoSCADA database history folder is located at:
`C:\ProgramData\Schneider Electric\ClearSCADA\Database\History` (Source: _equipment-info.md).
- WWTP flow meter calibration data exists in spreadsheets with some dated images, indicating ongoing calibration efforts (Source: WWTP_flow_meter_calibration.md).
- WWTP flow range is noted as 0-1716 gpm for 4-20 mA signal range, with PLC full scale at 31220 and zero at 6223 (Source: WWTP_Flow.md).
Summary: The flow data extraction involves GeoSCADA database files stored on the SCADA server. Data from the old SCADA server has been transferred to the new server backup folder. No specific SQL queries or scripts for flow data extraction were found in Slack as of late February 2026. Further details or scripts may need to be developed or shared by the team.
If you need access to the SCADA server or database, the SCADA server IPs are 10.0.0.50 and 10.1.10.2, and the HMI server IPs are 10.0.0.51 and 10.1.10.3 (Source: _client-info.md). Credentials are available if needed.
Please let me know if you want assistance with specific queries or accessing the data.
:card_file_box: *Sources* (10 chunks):
• *Buellton* — `Clients/Buellton/slack/2026/02/2026-02-24_buellton.md`
• *Buellton* — `Clients/Buellton/slack/2026/03/2026-03-03_buellton.md`
• *Buellton* — `Clients/Buellton/Client_Summary.md`
• *Buellton* — `Clients/Buellton/Snapshot_from_Buellton_WWTP_internet.md`
• *Buellton* — `Clients/Buellton/WWTP_flow_meter_calibration.md`
**12:50 [AutoBot](https://slack.com/archives/C091185E1JN/p1772743802896479):** :mag: Searching the vault…
**12:50 [AutoBot](https://slack.com/archives/C091185E1JN/p1772743810984159):**
Notes on Buellton server WWTP flow data extraction:
- As of 2026-02-24, there were no existing notes or Slack messages found regarding extracting or manipulating WWTP flow data using SQL or other methods. Kevin asked Mason Radke to search Slack with keywords like "wwtp flow sql" but nothing was found. Mason requested Kevin to share any findings so they could be added (Source: 2026-02-24_buellton.md).
- On 2026-03-03, Kevin reported that the existing WWTP flow data was transferred from the old SCADA server to the new server at the path:
`C:\ProgramData\Schneider Electric\ClearSCADA\Database\Backups\From old server`
The process requires shutting down SCADA, copying the old data to the new server, then restarting SCADA (Source: 2026-03-03_buellton.md).
- The SCADA software in use is Geo SCADA (formerly ClearSCADA) by Schneider Electric, running on a server located in the WWTP Lab building (Source: Client_Summary.md).
- The GeoSCADA database history folder is located at:
`C:\ProgramData\Schneider Electric\ClearSCADA\Database\History` (Source: _equipment-info.md).
- WWTP flow meter calibration data exists in spreadsheets with dated images, indicating ongoing calibration efforts (Source: WWTP_flow_meter_calibration.md).
- The WWTP flow range is 0-1716 gpm for the 4-20 mA signal range, with PLC full scale at 31220 and zero at 6223 (Source: WWTP_Flow.md).
- No specific SQL queries or scripts for extracting flow data have been documented or found in Slack as of early March 2026. Further development or sharing of such scripts may be needed.
- SCADA server IPs are 10.0.0.50 and 10.1.10.2; HMI server IPs are 10.0.0.51 and 10.1.10.3. Credentials are available if access is needed (Source: _client-info.md).
If you need help with specific queries or accessing the data, assistance can be provided.
(Source: Clients/Buellton/slack/2026/03/2026-03-05_buellton.md and referenced documents)
:card_file_box: *Sources* (10 chunks):
• *Buellton* — `Clients/Buellton/slack/2026/03/2026-03-05_buellton.md`
• *Buellton* — `Clients/Buellton/slack/2026/02/2026-02-24_buellton.md`
• *Buellton* — `Clients/Buellton/slack/2026/03/2026-03-03_buellton.md`
• *Buellton* — `Clients/Buellton/Client_Summary.md`
• *Buellton* — `Clients/Buellton/Snapshot_from_Buellton_WWTP_internet.md`
**12:56 [Kevin](https://slack.com/archives/C091185E1JN/p1772744209168569):** Rebooted the SCADA VM to try and get it to index the old data files
**12:57 [Mason Radke](https://slack.com/archives/C091185E1JN/p1772744249233239):** Make a checkpoint?
**12:58 [Kevin](https://slack.com/archives/C091185E1JN/p1772744327428499):** yes
**12:58 [Kevin](https://slack.com/archives/C091185E1JN/p1772744338579159):** thanks
**13:12 [Kevin](https://slack.com/archives/C091185E1JN/p1772745165879089):** well.....
![[F0AJT47EUJJ_image.png]]
**13:13 [Mason Radke](https://slack.com/archives/C091185E1JN/p1772745196793789):** cant get mad at it for doing what we tell it
**13:14 [Kevin](https://slack.com/archives/C091185E1JN/p1772745273510259):** yep
**13:35 [Kevin](https://slack.com/archives/C091185E1JN/p1772746504292239):** @AutoBot create a task for kevin under buellton to investigate how to setup the historian archive as a two star priority with a due date of 3/31/26
**13:35 [AutoBot](https://slack.com/archives/C091185E1JN/p1772746506043339):**
:white_check_mark: *Task created:* under buellton to investigate how to setup the historian archive as a two star priority with a
:bust_in_silhouette: Kevin :star: Medium :calendar: 2026-03-31 :office: Buellton
[View in list](https://app.slack.com/lists/T089GAQQHTN/F09DBBTNQFJ/Rec0AJT8Q2LKG)
**13:35 [AutoBot](https://slack.com/archives/C091185E1JN/p1772746506550389):**
:white_check_mark: *Task created:* under buellton to investigate how to setup the historian archive as a two star priority with a
:bust_in_silhouette: Kevin :star: Medium :calendar: 2026-03-31 :office: Buellton
[View in list](https://app.slack.com/lists/T089GAQQHTN/F09DBBTNQFJ/Rec0AJT8QBNHL)
**13:35 [Mason Radke](https://slack.com/archives/C091185E1JN/p1772746548878639):** i think i know why this double entry thing is happening..
**13:36 [Kevin](https://slack.com/archives/C091185E1JN/p1772746598764199):** copy
**13:38 [Mason Radke](https://slack.com/archives/C091185E1JN/p1772746689225829):** ya fixed
**14:19 [Kevin](https://slack.com/archives/C091185E1JN/p1772749157348129):** changed settings in historian to retain data for 10 years and make available for archive every 4 weeks.
**14:19 [Kevin](https://slack.com/archives/C091185E1JN/p1772749166024359):** restarted the server
**14:19 [Kevin](https://slack.com/archives/C091185E1JN/p1772749180288689):** there was still no history greater than 1 year
**14:19 [Kevin](https://slack.com/archives/C091185E1JN/p1772749192884289):** found the historian had already pruned the data I copied over
**14:19 [Mason Radke](https://slack.com/archives/C091185E1JN/p1772749197043879):** it may have deleted the records after one year
**14:20 [Mason Radke](https://slack.com/archives/C091185E1JN/p1772749205402719):** did you re-copy the files?
**14:20 [Kevin](https://slack.com/archives/C091185E1JN/p1772749221779349):** yes it did. just recopied the files and did another reboot.
**14:20 [Mason Radke](https://slack.com/archives/C091185E1JN/p1772749233360819):** interesting.
**14:20 [Kevin](https://slack.com/archives/C091185E1JN/p1772749245690309):** I haven't looked yet. it may be there now
**14:22 [Mason Radke](https://slack.com/archives/C091185E1JN/p1772749341069459):** oh i see
**14:22 [Mason Radke](https://slack.com/archives/C091185E1JN/p1772749353704369):** oh i just read your messages in full
**14:22 [Mason Radke](https://slack.com/archives/C091185E1JN/p1772749357768699):** my brain did a super quick scan
**14:24 [Kevin](https://slack.com/archives/C091185E1JN/p1772749490433299):** ok! now have data back to 2023
**14:25 [Mason Radke](https://slack.com/archives/C091185E1JN/p1772749505155159):** boom
**14:25 [Mason Radke](https://slack.com/archives/C091185E1JN/p1772749507504909):** nice work
**14:25 [Kevin](https://slack.com/archives/C091185E1JN/p1772749517896189):** gracias
**14:28 [Kevin](https://slack.com/archives/C091185E1JN/p1772749688996889):** Gemini was helpful in getting what I was looking for in the GeoSCADA online help. I gave it the website and asked it a question and said to use the data in the website.
**14:28 [Kevin](https://slack.com/archives/C091185E1JN/p1772749693470789):** https://tprojects.schneider-electric.com/GeoSCADAHelp/Geo%20SCADA%202022/Default.htm
**14:28 [Mason Radke](https://slack.com/archives/C091185E1JN/p1772749717604669):** yeah the more direct,clear, specific you get with it the better
**14:50 [Kevin](https://slack.com/archives/C091185E1JN/p1772751043649929):**
here is the query that gives me the highest flow read for each minute for a 24 hour period
```
ELECT
{ FN HOUR("RecordTime") } AS "Hour",
{ FN MINUTE("RecordTime") } AS "Minute",
MAX("Value") AS "FlowValue"
FROM
CDBHISTORIC
WHERE
"Id" = 1570
AND "RecordTime" BETWEEN { TS '2024-02-04 00:00:00' } AND { TS '2024-02-04 23:59:59' }
GROUP BY
"Hour", "Minute"
ORDER BY
"Hour" ASC, "Minute" AS
```
**14:51 [Mason Radke](https://slack.com/archives/C091185E1JN/p1772751069151919):** kevin knows sql now
**14:51 [Kevin](https://slack.com/archives/C091185E1JN/p1772751098115669):** ya right
**14:56 [Kevin](https://slack.com/archives/C091185E1JN/p1772751362841499):** saved the data here C:\Users\autos\Dropbox\AUTOSYS_SHARED\BUELLTON\DATA