Ice and Snow Accumulation Forecasts for Line Loading
This dataset provides detailed winter weather forecasts for ice and snow accumulation on transmission and distribution conductors, including location, loading zone, and outage risk assessment. It enables utilities and grid operators to evaluate infrastructure vulnerability and proactively manage outage risks during severe weather events.
Sample rows
preview · 8 of 100 rows · all 16 columns| forecast_idstring | outage_risk_levelstring | forecast_ice_accumulation_mmfloat | created_bystring | forecast_datetimedatetime | valid_start_datetimedatetime | valid_end_datetimedatetime | location_idstring | location_namestring | latitudefloat | longitudefloat | conductor_typestring | loading_zonestring | forecast_snow_accumulation_mmfloat | forecast_total_loading_kg_per_meterfloat | risk_assessment_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| F0001-B1 | Moderate | 15.7 | JSmith | 2024-01-04T08:45:00 | 2024-01-05T00:00:00 | 2024-01-05T23:59:00 | LN-1001 | North Ridge Substation | 42.7346 | -72.5241 | overhead | Heavy | 28.2 | 1.11 | Ice buildup observed, moderate wind forecast. |
| F0002-B1 | Low | 7.3 | ForecastBot | 2024-01-04T09:10:00 | 2024-01-05T06:00:00 | 2024-01-06T06:00:00 | LN-1002 | West Valley Line | 41.8233 | -73.0457 | transmission | Medium | 19.5 | 0.73 | No precipitation after initial storm. |
| F0003-B1 | High | 22.9 | AWalker | 2024-01-04T10:32:00 | 2024-01-05T12:00:00 | 2024-01-06T12:00:00 | LN-1003 | East Ridge Segment | 41.2556 | -72.9951 | distribution | Heavy | 34.4 | 1.54 | Heavy accumulation expected overnight. |
| F0004-B1 | Low | 5.1 | ForecastBot | 2024-01-04T10:52:00 | 2024-01-05T18:00:00 | 2024-01-06T18:00:00 | LN-1004 | Pinecrest Junction | 40.7342 | -74.1139 | overhead | Medium | 7.8 | 0.39 | Minimal risk, light precipitation. |
| F0005-B1 | Low | 0 | JSmith | 2024-01-04T11:18:00 | 2024-01-06T00:00:00 | 2024-01-06T23:59:00 | LN-1005 | Maple Grove Tap | 42.1012 | -73.8935 | underground | Light | 12.1 | 0.11 | Underground; snow impact negligible. |
| F0006-B1 | Low | 3.2 | AWalker | 2024-01-04T12:05:00 | 2024-01-06T06:00:00 | 2024-01-07T06:00:00 | LN-1006 | Birchwood Crossing | 41.5467 | -74.7238 | distribution | Medium | 23.5 | 0.57 | blank |
| F0007-B1 | Severe | 30.2 | ForecastBot | 2024-01-04T12:18:00 | 2024-01-06T12:00:00 | 2024-01-07T12:00:00 | LN-1007 | South Lake Line | 40.9247 | -73.8652 | transmission | Heavy | 41 | 1.88 | Major event forecast; monitor closely. |
| F0008-B1 | Low | 1.5 | JSmith | 2024-01-04T13:21:00 | 2024-01-07T00:00:00 | 2024-01-07T23:59:00 | LN-1008 | Elm Street Segment | 41.3738 | -73.6227 | overhead | Light | 14.3 | 0.17 | blank |
| F0009-B1 | Moderate | 9 | AWalker | 2024-01-04T13:58:00 | 2024-01-07T06:00:00 | 2024-01-08T06:00:00 | LN-1009 | Cedar Fork Junction | 42.2951 | -74.2075 | distribution | Medium | 29.8 | 0.91 | Elevated risk due to snow depth. |
| F0010-B1 | Low | 0 | ForecastBot | 2024-01-04T14:03:00 | 2024-01-07T12:00:00 | 2024-01-08T12:00:00 | LN-1010 | Willow Branch Tap | 41.9782 | -73.4881 | underground | Light | 7.6 | 0.07 | Snow accumulation minor. |
| F0011-B1 | Moderate | 16.2 | JSmith | 2024-01-04T14:26:00 | 2024-01-08T00:00:00 | 2024-01-08T23:59:00 | LN-1011 | Springfield Hub | 41.3206 | -72.8163 | transmission | Heavy | 25.4 | 1.04 | Temperature expected to drop. |
| F0012-B1 | Low | 4.4 | AWalker | 2024-01-04T14:41:00 | 2024-01-08T06:00:00 | 2024-01-09T06:00:00 | LN-1012 | Oak Hill Crossing | 42.5067 | -73.5892 | overhead | Medium | 17 | 0.53 | blank |
| F0013-B1 | Moderate | 12.8 | ForecastBot | 2024-01-04T15:03:00 | 2024-01-08T12:00:00 | 2024-01-09T12:00:00 | LN-1013 | Hickory Lane Substation | 41.7284 | -74.0229 | distribution | Heavy | 27.6 | 0.99 | Precipitation rate increasing. |
| F0014-B1 | Moderate | 10.5 | AWalker | 2024-01-04T15:29:00 | 2024-01-09T00:00:00 | 2024-01-09T23:59:00 | LN-1014 | Redwood Valley Line | 42.184 | -74.3306 | transmission | Medium | 30.2 | 0.97 | Wind gusts to 30 km/h. |
| F0015-B1 | Low | 3.7 | JSmith | 2024-01-04T15:44:00 | 2024-01-09T06:00:00 | 2024-01-10T06:00:00 | LN-1015 | Silver Pine Crossing | 41.5823 | -73.9234 | overhead | Light | 15.4 | 0.19 | blank |
| F0016-B1 | Low | 6.6 | AWalker | 2024-01-04T16:12:00 | 2024-01-09T12:00:00 | 2024-01-10T12:00:00 | LN-1016 | Riverbend Junction | 42.6271 | -74.4125 | distribution | Medium | 22.3 | 0.72 | No ice accretion overnight. |
| F0017-B1 | Low | 0 | ForecastBot | 2024-01-04T16:29:00 | 2024-01-10T00:00:00 | 2024-01-10T23:59:00 | LN-1017 | Greenway Substation | 41.8892 | -73.6794 | underground | Light | 9.9 | 0.09 | Underground; minimal impact. |
| F0018-B1 | High | 19.5 | JSmith | 2024-01-04T16:45:00 | 2024-01-10T06:00:00 | 2024-01-11T06:00:00 | LN-1018 | Lakeview Tap | 40.9671 | -73.7123 | overhead | Heavy | 32.8 | 1.32 | blank |
| F0019-B1 | Low | 8.4 | AWalker | 2024-01-04T17:13:00 | 2024-01-10T12:00:00 | 2024-01-11T12:00:00 | LN-1019 | Hilltop Crossing | 42.5234 | -73.7842 | distribution | Medium | 20.7 | 0.73 | blank |
| F0020-B1 | Moderate | 13.7 | ForecastBot | 2024-01-04T17:28:00 | 2024-01-11T00:00:00 | 2024-01-11T23:59:00 | LN-1020 | Walnut Grove Line | 41.3113 | -72.5056 | transmission | Heavy | 27.9 | 0.96 | Freezing conditions likely. |
What the 100 rows show
from the 100-row sampleSevere (outage risk level) stands out: mean forecast_
- 8.1median forecast_
ice_ accumulation_ mm - 3loading zones
- 4conductor types
- 17.7median forecast_
snow_ accumulation_ mm - 0.80median forecast_
total_ loading_ kg_ per_ meter
Median 8.1, from 0.0 to 30.2.
- string 8
- float 5
- datetime 3
Columns
16 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 8 columns | |||
forecast_id | string | Unique identifier for each forecast recordunique | F0001-B1 |
location_id | string | Unique identifier for the forecast location (e.g., substation, line segment) | LN-1001 |
location_name | string | Human-readable name of the forecast location | North Ridge Substation |
conductor_type | string | Type of conductor (e.g., transmission, distribution, overhead, underground)transmission · distribution · overhead · underground | overhead |
loading_zone | string | NESC loading zone classification for the locationHeavy · Medium · Light | Heavy |
outage_risk_level | string | Assessed outage risk level based on forecasted loadingLow · Moderate · High · Severe | Moderate |
risk_assessment_notes | string | Additional notes or comments regarding the risk assessmentoptional | Snow accumulation minor. |
created_by | string | Identifier or name of the analyst or system that created the forecast record11 values | JSmith |
| Numbers 5 columns | |||
latitude | float | Latitude of the forecast location-90 to 90 | 42.7346 |
longitude | float | Longitude of the forecast location-180 to 180 | -72.5241 |
forecast_ice_accumulation_mm | float | Forecasted ice accumulation on conductors in millimeters0 or more | 15.7 |
forecast_snow_accumulation_mm | float | Forecasted snow accumulation on conductors in millimeters0 or more | 28.2 |
forecast_total_loading_kg_per_meter | float | Total forecasted loading on conductors in kilograms per meter (ice + snow)0 or more | 1.11 |
| Dates and times 3 columns | |||
forecast_datetime | datetime | Date and time when the forecast is issued | 2024-01-04T08:45:00 |
valid_start_datetime | datetime | Start date and time for which the forecast is valid | 2024-01-05T00:00:00 |
valid_end_datetime | datetime | End date and time for which the forecast is valid | 2024-01-05T23:59:00 |
Use it for
An energy dashboard
Forecast_
ice_ accumulation_ mm by outage_ risk_ level and a breakdown of created_ by. Excel, Power BI or Tableau. Why do the 10 Severe rows have a mean forecast_
ice_ accumulation_ mm of 25.6? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Forecasts100F0001-B115.7ModerateF0002-B17.3LowF0003-B122.9High
A software demo
Believable forecasts with forecast_
datetime, valid_ start_ datetime and valid_ end_ datetime to fill a screen in front of a buyer.
This dataset100 rows16 columns
Yours1,000 rows16 columnslocation_id: UK only
blueprint · ice-and-snow-accumulation-forecasts-for-line-loading
Behind this dataset
Same schema. As many rows as you need.
These 100 rows came out of a blueprint — 16 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Forecast timestamp and event duration
- Ice accumulation: radial ice thickness on conductors (inches)
- Snow accumulation depth (inches) and snow-water equivalent
- NESC loading zone: Heavy, Medium, Light, or Extreme (ice + wind)
- Conductor type and diameter for loading calculations
- Wind speed during ice accumulation (combined ice + wind loading)
- Conductor sag increase and ground clearance violations
- Galloping conductor risk (ice shedding + wind excitation)
Open the blueprint in Data Factory
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- ice-and-snow-accumulation-forecasts-for-line-loading