This question already has an answer here:

I am not good at programming, so I would ask for your understanding concerning my question.

I have an attribute table that contains five columns which are: (Date, ID, Latitude, Longitude, Rainfall). Rainfall for different periods of time (which are defined in column "Date") have been recorded in certain stations. In the column "ID" is the ID of the station on which the recording has been made for a specific period of time. Every station has a unique ID, but at the same location, rainfall has been recorded for different time periods. On the column "Rainfall" appears the amount of rain that was recorded on the specific time and the specific station.

My question is, how can I get the total rainfall in a certain station that has been recorded, using all the records in column "Date" that refer to that specific station. Could I somehow use the coordinates of its station to get the total rainfall that has occurred on that specific station?

The software I use is QGIS 2.4 on Windows machine.

marked as duplicate by Chris W, Jason Scheirer, BradHards, PolyGeo, whuber Jul 15 '14 at 0:14

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • 1
    Welcome to GIS! Please add which software and version you are using (eg. QGIS 2.4, ArcGIS 10.1 etc) – Joseph Jul 14 '14 at 11:00
  • As someone new to GIS SE this may give you some quick hints on how to use the various parts of each question you ask: meta.gis.stackexchange.com/questions/3349/… I would recommend that you edit your question to include "I use QGIS 2.4" there rather than as another tag. – PolyGeo Jul 14 '14 at 11:08

Should be a fairly simple query. In Qgis, use select by expression. Under fields and values select the ID field, find the unique ID for the station you would like and you can return all the values for that station. As and example "ID= MissoulaWX". You can add other conditionals to the statement to select for a specific date or range of dates.

Others have asked similar questions here on GIS.stackexchange

  • F_Kellner, thanks for the response! The thing is that in my point shapefile I have 2900 stations for which I need to calculate the total rainfall. Is there a way that I can automatise the procedure (calculate the total rainfall for all the stations that have the same ID)? – mar Jul 14 '14 at 16:00
  • I don't have as much experience scripting in Qgis environment, but with Python almost anything is possible. Kicking out the attribute table into a tabular format that you could use in something like Python, or Matlab, or R may make your life easier, rather than trying to script these calculations in Qgis. – F_Kellner Jul 14 '14 at 16:24

Not the answer you're looking for? Browse other questions tagged or ask your own question.