Data on light pollution. Infos on http://lightmeter.astronomy2009.at, also gwuchterl@tls-tautenburg.de should know more. The data here gets uploaded through a special renderer (in bin) since auth is done through the path. You need a subdirectory upload writable by whoever the server runs as (currently msdemlei). To add a new station, cd stations cp ../template.kv .kv vi .kv # make up an access key as desired (e.g., use pwgen), leave calib* empty. # Paste data from data providers above. # type usually is IYA Lightmeter these days # For now, east longitude is positive (maybe change this?) cd .. gavo imp q stationsdata # reply to the mail, giving the accessKey. Here's a template: """ Your access key is ACCESS_KEY. You can upload manually to http://dc.g-vo.org/lightmeter/q/upload/custom/STATION_ID/ACCESS_KEY For automated uploads, see http://dc.g-vo.org/lightmeter/q/upload/info To see what you've uploaded, go to http://dc.g-vo.org/lightmeter/q/upload/static/STATION_ID Once Günther Wuchterl has calibrated your lightmeter, the reduced data is ingested into the database and can be queried using a form at http://dc.g-vo.org/lightmeter/q/weather/form or using ADQL at http://dc.g-vo.org/adql. Feel free to contact us for any further questions, and in particular if something doesn't work as expected. Cheers, Markus """ Or in German: """ Ihr Zugriffsschlüssel ist ACCESS_KEY. Damit können Sie manuell zur URL http://dc.g-vo.org/lightmeter/q/upload/custom/STATION_ID/ACCESS_KEY hochladen. Hinweise zum Automatisieren des Uploads finden sich auf http://dc.g-vo.org/lightmeter/q/upload/info Ihre Uploads können Sie auf http://dc.g-vo.org/lightmeter/q/upload/static/STATION_ID sehen. Sobald Günther Wuchterl Ihr Lightmeter kalibriert hat, können Sie die reduzierten Daten unter http://dc.g-vo.org/lightmeter/q/weather/form oder per ADQL unter http://dc.g-vo.org/adql abfragen. Sollte beim Upload etwas nicht klappen, wenden Sie sich gerne an uns (gavo@ari.uni-heidelberg.de) Grüße, Markus Demleitner """ Add a line to Contacts specifying the e-mail address for the station id. ------------------------------- When a calibration comes in, the mail should give the parameters a, b, c, and d for W/m^2. Enter those values in the calibX fields of the stations .kv file. Then, in the lightmeter directory, gavo imp q stationsdata (this imports the new data into the database) Optionally (but recommended, you can try to ingest the calibrated data sets; this may take a while): gavo imp q add (this should pick up data from the changed station) ------------------------------- To recreate the whole thing (DON'T! It's going to take ages!), do gavo imp q createTables gavo imp q stationsdata (which reads .kv-files from stations) gavo imp q add When a calibration was wrong, you need to nuke the station's ingested data and tell the machinery you did so. So, for the id NL_Utrecht_2 this looks like this: delete from lightmeter.measurements where stationid='NL_Utrecht_2'; delete from lightmeter.filesindb where stationid='NL_Utrecht_2'; Then, correct the calibration, say ``gavo imp q stationsdata`` and ``gavo imp q``