Project

General

Profile

Support #3149

Weather station levels: which WS?

Added by Philippe May over 7 years ago. Updated almost 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Giulio Di Anastasio
Start date:
17/11/2016
Due date:
% Done:

0%

Spent time:
0.50 h
Close

Description

In the weather station "levels" files (ex: 2016_aws_raw_data.xlsx), there's no indication which weather station it is related to.

There's only one WS right now (shape file still pending), but we'll need to consider there will be a couple, so we need a tag somehow which one the measurements are from.

This id (foreign key to the WS geographical table from the shape file) can be inside of Excel, or included in the file name (ex: 2016_aws_raw_data-1.xlsx). You can take the most convenient option.

History

#1 Updated by Philippe May over 7 years ago

Ping?

#2 Updated by Philippe May over 7 years ago

As discussed: same formalism as raingauge: add a suffix on the file name.
The first sheet to be created with the id of the raingauge in cell B1

#3 Updated by Philippe May over 7 years ago

  • Status changed from New to Resolved

#5 Updated by Philippe May over 7 years ago

  • Status changed from Resolved to New

I don't remember why we closed this ticket: the files in http://server.gis.av/admin/dataimportbasketadmin/b/weather_station_levels still do not have the weather_station_id in cell B1 of the first sheet.

So, reopening the ticket.

#6 Updated by Giulio Di Anastasio over 7 years ago

Dear Philippe,
I just uploaded the weather station data into the basket.
They refer to weather station id=1, I mentioned it in the file name as well as in the first sheet of the excel file, for your convenience.

I am now trying to find a way to have Akash's data in the same format...

Waiting for your kind reply

Giulio

#7 Updated by Philippe May over 7 years ago

  • Status changed from New to Resolved

#8 Updated by Giulio Di Anastasio almost 4 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF