Changes between Version 103 and Version 104 of PetascopeUserGuide


Ignore:
Timestamp:
Dec 30, 2015 3:16:19 PM (21 months ago)
Author:
pbaumann
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • PetascopeUserGuide

    v103 v104  
    262262A final report of coverage migrations is then printed: name and general information on coverage domain and range will be displayed for every migrated coverage. If some problem arose while migrating a coverage, an additional ''log'' column will describe what did not work. In case the mistake can be fixed (maybe changing the pre-upgrade database?), then one can just repeat the operation by reverting back (`--revert`) and re-migrating.
    263263
    264 
    265 === SQL macros ===
    266 
    267 A first set of SQL macros is made available for users (and devs) in order to ease the analysis of the (currently only gridded-) coverage metadata in ''petascopedb'', and they are hereby explained with examples.
    268 
    269  `getCrs('<coverage_name>')` ::
    270     Returns the ordered sequence of single CRS URIs which together constitute the (composed) native CRS of the coverage (such URIs for single CRSs will we shown together on a single compound URI (`def/crs-compound?`) in the WCS responses):
    271 {{{
    272 petascopedb=# SELECT * FROM getCrs('eobstest');
    273  id |                                       uri                                       
    274 ----+----------------------------------------------------------------------------------
    275  11 | http://localhost:8080/def/crs/OGC/0/Temporal?epoch="1950-01-01T00:00:00"&uom="d"
    276  12 | http://localhost:8080/def/crs/EPSG/0/4326
    277 (2 rows)
    278 }}}
    279  `getDomainSet('<coverage_name>')` ::
    280    Returnes the CRS coordinates of grid origin and of every offset vector of the coverage, ordered by the order of grid axis inside ''rasdaman'':
    281 {{{
    282 petascopedb=# SELECT * FROM getDomainSet('eobstest');
    283  rasdaman_order | grid_origin | offset_vector
    284 ----------------+-------------+---------------
    285               0 | {0,75.5,25} | {1,0,0}
    286               1 | {0,75.5,25} | {0,0,0.5}
    287               2 | {0,75.5,25} | {0,-0.5,0}
    288 (3 rows)
    289 }}}
    290  `getRangeSet('<coverage_name>')` ::
    291    Returns the collection and the internal marray (its OID) associated with the coverage; optionally the ''rasdaman'' base type can be set:
    292 {{{
    293 petascopedb=# SELECT * FROM getRangeSet('eobstest');
    294  coverage name | collection name | collection OID | base_type
    295 ---------------+-----------------+----------------+-----------
    296  eobstest      | eobstest        |         176641 |
    297 (1 row)
    298 }}}
    299  `getRangeType('<coverage_name>')` ::
    300     Returns a description of principal SWE metadata for each component of the coverage's range (that is, each band or channel):
    301 {{{
    302 petascopedb=# SELECT * FROM getRangeType('rgb');
    303  component order | name  | SWE type |   data type   | UoM  | allowed interval(s)
    304 -----------------+-------+----------+---------------+------+---------------------
    305                0 | red   | Quantity | unsigned char | 10^0 | (0,255)
    306                1 | green | Quantity | unsigned char | 10^0 | (0,255)
    307                2 | blue  | Quantity | unsigned char | 10^0 | (0,255)
    308 (3 rows)
    309 }}}
    310 
    311 Further macros will be developed, but please contact the [MailingLists mailing lists] if you want to suggest/request a specific change to existing macros, or a new one.
    312264
    313265== OGC Web Services ==