Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

store weather information to database.

hi,

I have  a question from property team that if they have temperature sensor to collect all temperature and all weather related data, how can we store those information from sensor to database so that we can gather a report easier ?
Avatar of ste5an
ste5an
Flag of Germany image

Some one or some device must read the sensor value and store it in a database.

So, what is your real question?
Avatar of marrowyung
marrowyung

ASKER

I mean by automated method ! the sensor should know how to send information to the database in the table suggested by the Sensor vendor ?

The daily information will keep going everyday and using human to read and enter information to the database is not possible.
Sorry, but this is not a question. It's a broad topic where an answer would span 40 pages and require one or two weeks of research.

In short: a sensor measures something. Then you need a device reading this value. Then you need a device capable of storing this value.

Whether this is a single sensor/device which can do it or two, solely depends on the concrete used components (e.g. Measuring Temperature with a Raspberry Pi Temperature Sensor (1-Wire)), which you haven't told us anything about it.
sorry it is broad, but it is just like some friends asking if he want to measure the temperature outside of his shopping mall, and then draw report about it, what can he do ?

my first response is , the sensor should like a CC reader which read customer's CC and the insert the data automatically to a pre defined table in database server.

any other idea you can think of ?
ASKER CERTIFIED SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
he is the IT manager of the mall, so can do whatever connect he like.

"He also needs to tell you, where this "database" should be located and what kind of database he wants."

I think the sensor HW has the software say what OS platform and DB  software the Sensor software has to run on?

I am not sure any temperature selling on the street has this kind of additional feature ?

so it seems that he need to pick up a sensor has software support and LAN support so that it can upload data to database server ?
Well ask Columbia WS or Oregon Scientific. The may have out-of-the-shelf solution.
so you mean direction is correct to ask provider about the SW and DB support of thier hardware? what if the HW do not have it , then he can't implement the solution at all ?
Columbia and Oregon are weather station manufactures. And as already posted, you can do it all your self (raspi, arduino).
" you can do it all your self (raspi, arduino)."

so this means must use raspi or arduino which has the API, right?
Read the links I've provided..........
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Johnsone,

seems need to follow their buying guide : https://www.wunderground.com/pws/buying-guide

and then follow their procedure ? https://www.wunderground.com/pws/installation-guide 

and then register ? https://www.wunderground.com/member/devices 
?

ste5an,

https://azure-samples.github.io/azure-iot-starter-kits/seeed/1-temperature-sensor/

is that mean we can configure Raspberry Pi 3 as a LoT device to Azure hub and then do logic in Azure hub to get data from the device and then to database ?
Registering would only be if you want to send them the data.  If you actually try to figure it out yourself, all the information should be here
tks all.