Re: [WDB-Users] add.parameter
Brought to you by:
falkenroth,
michaeloa
From: Michael A. <mic...@me...> - 2012-06-14 21:27:12
|
Hi, I have just added a new section to the WCI metadata manual that hopefully illuminates this aspect of WDB administration: https://wdb.met.no/doku.php?id=manuals:wdb_metadata#parameters In particular, take a look at the metadata install files to see examples of what you want to do. https://github.com/wdb/wdb/blob/master/etc/metadata/wdb_parameter.in.sql >From the look of what you are doing, you are using the Canonical (0) namespace. The canonical namespace _always_ contains canonical parameter names constructed from CF standard parameter name components. To get alternative names, you need to use another namespace and copy the parameters you need/want over to that. You can see an example of that in the first two lines of the metno WDB metadata set. https://github.com/metno/wdb-metadata/blob/master/etc/wdb_parameter.in.sql The metno metadata set has 'max air temperature' as a parameter, as described in the documentation. Note that data values in WDB are by default always specified using SI units (so K - Kelvin, rather than Cel - Celsius). And parameters are bound to a unit, so it is not possible to have an 'air temperature' parameter in K, and an 'air temperature' parameter in Cel at the same time in the database. It is recommended to follow this principle, though obviously you can always insert an 'air temperature cel' or other differently names parameter with Cel as a unit of measure. There is no function to delete metadata, though obviously updates and data deletion can be done manually on the tables involved by a user with admin privileges who knows what he/she is doing. For parameters, the relevant table is the wdb_int.parameter table. Hope this helps answer your question, otherwise let us know. Regards, Michael A. ----- Original Message ----- > Hi, > I'm adding new parameter throught the function wci.addparameter(); I > don't well understand how to fill in a good manner the function > parameter: > > For example: > > > I tried: > > > SELECT wci.addparameter('average',null,null,'air > temperature',null,null,null,'Cel'); --> "(66,average,,,"air > temperature",,,,Cel,1000,"average in air temperature")" > > > > SELECT wci.addparameter('air temperature',null,null,null,'max within > hours',null,null,'Cel');-->"(69,"air temperature",,,,"max within > hours",,,Cel,1000,"air temperature due to max within hours")" > SELECT wci.addparameter('air temperature',null,null,null,null,'max > within hours',null,'Cel');-->"(70,"air temperature",,,,,"max within > hours",,Cel,1000,"air temperature assuming max within hours")" > > > I'd like to obtain: > > > "(6,"air temperature",,,,,,"maximum within days",K,1000,"max air > temperature")" > > > but "maximun within hours", in this case "within" is a key-word? > Also, is it possible to delete parameters, if yes, how? > > > Thank you so much! > Regards > Filippo > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. > Discussions > will include endpoint security, mobile security and the latest in > malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > WDB-Users mailing list > WDB...@li... > https://lists.sourceforge.net/lists/listinfo/wdb-users |