Changes between Version 26 and Version 27 of PetascopeDevGuide


Ignore:
Timestamp:
Feb 17, 2013 2:51:05 PM (4 years ago)
Author:
dmisev
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • PetascopeDevGuide

    v26 v27  
    3535There are several GML-related aspect to be solved before these modifications can be applied, but meanwhile I can post the relevant modifications to the ''petascopedb'' schema, so that some implementation can get started, in case. Any comment and suggestion is appreciated, of course!
    3636
    37   * '''__NEW TABLES__'''
     37==== NEW TABLES ====
    3838     * '''''ps_irrSeries''''' : explicit mapping of each domain-value of an irregularly spaced axis to its cell index.
    3939     {{{
     
    8383
    8484     }}}
    85   * '''__MODIFIED TABLES__'''
     85
     86==== MODIFIED TABLES ====
     87
    8688     * '''''ps_coverage''''' : `crs` field turned to foreign key (as it was meant to be) imported from `ps_crs`; this field, previously left empty, will now be used as unique CRS reference of the coverage, independently of its number of axes: a unique compound URI will be used in case. The URI must be stored in  `ps_crs` and referenced by `ps_coverage`.
    8789     {{{
     
    136138
    137139
    138   * '''__DROPPED TABLES__'''
     140==== DROPPED TABLES ====
    139141     * '''''ps_crsDetails''''' : really harmful table, limiting the bboxes to 2D and providing redundant information already visible in `ps_domain`.
    140142     * '''''ps_cellDomain''''' : the cell-domain extents are now retrieved by Petascope via RasQL queries (`sdom`).
     
    142144     * '''''ps_axisType''''': this kind of metadata is now in the GML definitions of the CRSs and in Petascope.
    143145
    144   * '''__INTEGRITY ISSUES__'''
     146==== INTEGRITY ISSUES ====
    145147     * '''''ps_coverage''''' : `nulldefault`, `interpolationtypedefault`, `nullresistancedefault`, `type` and `crs` should be `NOT NULL` (?)
    146148     * '''''ps_domain''''' : `minvalue` and `maxvalue` should be `NOT NULL`.