notatki.md

Synoptyk

metar

http://ogimet.com/ultimos_synops2.php?estado=Pola&fmt=html&Enviar=Ver

html_doc = Nokogiri::HTML(open("http://ogimet.com/ultimos_synops2.php?estado=Pola&fmt=html&Enviar=Ver")) html_doc.xpath('//table').xpath('//table').xpath('//tr')

rails generate scaffold metar_station name:string number:integer latitude:float longitude:float elevation:integer status:boolean
rails generate scaffold metar_raport station:integer day:integer hour:integer metar:string message:text --no-timestamps
rails generate migration AddCreatedToMetarRaports created_at:datetime
rails generate migration AddParamsToMetarRaports visibility:string cloud_cover:string wind_direct:string wind_speed:string temperature:string pressure:string situation:string

\copy (select name, number, latitude, longitude, elevation from metar_stations) To 'stacje_metar.csv' With CSV HEADER

powietrze

• lista stacji
• sensory
• dane pomiarowe
• indeksy

rails generate scaffold gios_station name:string latitude:float longitude:float number:integer city:string address:string
rails generate scaffold gios_measurments station:integer calc_date:datetime st_index:integer co_index:integer pm10_index:integer c6h6_index:integer no2_index:integer pm25_index:integer o3_index:integer so2_index:integer co_value:float pm10_value:float c6h6_value:float no2_value:float pm25_value:float o3_value:float so2_value:float co_date:datetime pm10_date:datetime c6h6_date:datetime no2_date:datetime pm25_date:datetime o3_date:datetime so2_date:datetime --no-timestamps

dane hydrologiczne

rails generate scaffold hydro_station name:string number:integer longitude:float latitude:integer river:string
rails generate scaffold hydro_measurments station:number water:integer water_date:datetime temperature:float temperature_date:datetime ice:integer ice_date:datetime encroach:integer encroach_date:datetime

gminy

rails generate scaffold city province:integer county:integer commune:integer genre:integer name:string name_add:string longitude:float latitude:float --no-timestamps

\copy (select * from cities where longitude is null) To 'terc_empty.csv' With CSV HEADER
delete from cities where longitude is null;
select * from cities where longitude is null;
select count(id) from cities where longitude is not null;
select count(id) from cities where longitude is null;
select * from cities order by province, county, commune, genre;
\copy (select province, county, commune, genre, name, name_add, longitude, latitude from cities order by province asc, county asc, commune asc, name asc, genre asc) To 'terc.csv' With CSV HEADER

http://api.geonames.org/findNearbyPlaceName?lat=51.1443537&lng=16.2427819&username=kamilpek
http://api.geonames.org/get?geonameId=3093691&username=kamilpek&style=full
http://www.yr.no/place/Poland/Lower Silesia/Legnickie Pole/forecast.xml

encoded_url = URI.encode("http://www.yr.no/place/Poland/Lower%20Silesia/Osiedle%20M%C5%82odych/forecast.xml")
url = URI.parse("http://www.yr.no/place/Poland/Lower%20Silesia/Osiedle%20M%C5%82odych/forecast.xml")
url = URI.parse("http://www.yr.no/place/Poland/Lower%20Silesia/L%C4%85dek-Zdr%C3%B3j/forecast.xml")
req = Net::HTTP.new(url.host, url.port)
res = req.request_head(url.path)
res.code

radary

rails generate scaffold radar cappi:string cmaxdbz:string eht:string pac:string zhail:string hshear:string
rails generate uploader RadarCappi
rails generate uploader RadarCmaxdbz
rails generate uploader RadarEht
rails generate uploader RadarPac
rails generate uploader RadarZhail
rails generate uploader RadarHshear
mount_uploader :cappi, RadarCappi
rails generate migration AddSriToRadars sri:string
rails generate uploader RadarSri
rails generate migration AddRtrToRadars rtr:string
rails generate uploader RadarRtr

gdańskie wody

rails generate scaffold gw_station no:integer name:string lat:float lng:float active:boolean rain:boolean water:boolean winddir:boolean windlevel:boolean
rails generate scaffold gw_measur gw_station:references datetime:datetime rain:float water:float winddir:float windlevel:float
rails generate migration AddLevelsToGwStations level_normal:float level_max:float level_rise:float

poziomy wody

1. Czarny - brak danych
2. Niebieski - niski - 0 - 1/2 normalnego
3. Zielony - średni - 1/2 - 1/1 normalnego
4. Żółty - wysoki - 1/2 - 1/1 maksymalnego
5. Pomarańczowy - ostrzegawczy - powyzej maksymalnego
6. Czerwony - alarmowy - normalny + wysokosc pietrzenia

ostrzeżenia meteo

rails generate scaffold client name:string person:string website:string email:string status:integer access_token:string --no-timestamps
rails generate scaffold category name:string image:string --no-timestamps
rails generate scaffold alert user:references category:references level:integer intro:string content:text time_from:datetime time_for:datetime clients:integer number:integer status:integer

rails generate uploader CategoryImageUploader