title,note,,,
Reference WATERBASE - Rivers: stations characteristic data,The Stations table contains data on the EUROWATERNET river monitoring stations' physical characteristics. Each station has been assigned a unique WATERBASE identifier (WaterbaseID) which can be used to link the Stations with their respective Quality and Pressure data. The meta data below provides detailed information on the content and format of the Stations table. The actual Stations table can be downloaded using the link at the foot of this page or via the Downloads section. A sample of the data stored in this table can be viewed by clicking on the Example View link below.,,,
,,,,
Item,Definition,note,Data Type,Key
Latitude,Latitude,(Y) International Geographical Co-ordinates of the monitoring station in decimal format,float(8),No
RiverDischarge,Mean Long Term River Discharge in m3/s,Discharge at the monitoring station,float(8),No
CatchmentArea,Upstream catchment area in km2,,float(8),No
Altitude,Altitude in m above sea level,,float(8),No
Longitude,Longitude,(X) International Geographical Co-ordinates of the monitoring station in decimal format,float(8),No
RevisionYear,Year of Revision,Last year of revision or update,int(4),No
Region,Region,Provided at national level,nvarchar(100),No
StationType,Station Type,"Station can fall into more than one type of B = Reference, R = Representative, F = Flux, L = Largest, Most Important, I = Impact (if more than one type applies, types will be listed alphabetically with no separator e.g. FL)",nvarchar(20),No
NationalStationID,National Station ID,Provided at national level,nvarchar(20),No
RiverName,River Name,Provided at national level,nvarchar(100),No
CatchmentName,Catchment name,Provided at national level,nvarchar(100),No
CountryCode,Country code,ISO 3166-alpha-2 code elements,nvarchar(2),No
Country,Country name (ISO 3166-1),Official short name in English,nvarchar(100),No
WaterbaseName,Name of the river station ,,nvarchar(200),No
WaterbaseID,Unique Waterbase Identifier,"Internally produced, unique identifier used to represent the monitoring station for rivers",varchar(20),Yes