OpenSolarDB - database - introduce data - upload by csv file
Introduce Solar Data
By uploading a csv file

The csv should have 17 fields (Fields with a * are obligatory):

  • 1. * Iso Country Identification (string), for instance US, GB, ES, etc.)
  • 2. * Place Name (string), could be a city, village or area name.
  • 3. Place Lattitude (floating point). Can be left in blank, if the place already exists in the database.
  • 4. Place Longitude (floating point). Can be left in blank, if the place already exists in the database or if the longitude is unknown.
  • 5. Year of measurement (4 digits). Can be left in blank if the radation data are an average over more than one year.
  • 6 - 17. * 12 fields with the daily radiation for each month in MJ/(day*m2) (floating point).

Further rules:

  • Lattitude and longitude can have decimals, example: 34.92 (Decimals are not minutes!).
  • Lattitude ranges from -180º to 180º, negative for west
  • Longitude ranges from -90º to 90º, negative for south
  • Upto 10 kbytes (ca. 100 lines) can be uploaded at once. Bigger files should be split up.

Example Line:

CountryPlaceLattitude
(°)
Longitude
(°)
YearRadiation
Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec
USMiami25.47-80.1720056.7210.5015.0019.2021.2025.1026.7023.2018.8012.408.406.40

You can also download existing data to have an example csv file. You only will have to add the 'Year' field.

Upload solar data
      
The line where the real data starts in the csv file (skipping the header and possible empty lines)