Changes between Version 201 and Version 202 of WKTRaster/SpecificationWorking03


Ignore:
Timestamp:
Dec 10, 2011, 9:01:40 AM (13 years ago)
Author:
Bborie Park
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • WKTRaster/SpecificationWorking03

    v201 v202  
    38013801                        <TD ALIGN=LEFT>srid</TD>
    38023802                        <TD ALIGN=LEFT>integer</TD>
    3803                         <TD ALIGN=LEFT>ID of the spatial reference system of the rasters in this column.  Value is extracted from the ST_SRID constraint on this raster column.  The constraint is typically named enforce_srid_&lt;r_raster_column&gt;.</TD>
     3803                        <TD ALIGN=LEFT>ID of the spatial reference system of the rasters in this column.  Value is extracted from the ST_SRID constraint on this raster column.  <span style="font-style: italic;">The constraint is typically named enforce_srid_&lt;r_raster_column&gt;.</span></TD>
    38043804                </TR>
    38053805                <TR>
    38063806                        <TD ALIGN=LEFT>scale_x</TD>
    38073807                        <TD ALIGN=LEFT>double precision</TD>
    3808                         <TD ALIGN=LEFT>The scale on the X-axis of the rasters in this column.  Value is extracted from the ST_ScaleX constraint on this raster column.  The constraint is typically named enforce_scalex_&lt;r_raster_column&gt;.</TD>
     3808                        <TD ALIGN=LEFT>The scale on the X-axis of the rasters in this column.  Value is extracted from the ST_ScaleX constraint on this raster column.  <span style="font-style: italic;">The constraint is typically named enforce_scalex_&lt;r_raster_column&gt;.</span></TD>
    38093809                </TR>
    38103810                <TR>
    38113811                        <TD ALIGN=LEFT>scale_y</TD>
    38123812                        <TD ALIGN=LEFT>double precision</TD>
    3813                         <TD ALIGN=LEFT>The scale on the Y-axis of the rasters in this column.  Value is extracted from the ST_ScaleY constraint on this raster column.  The constraint is typically named enforce_scaley_&lt;r_raster_column&gt;.</TD>
     3813                        <TD ALIGN=LEFT>The scale on the Y-axis of the rasters in this column.  Value is extracted from the ST_ScaleY constraint on this raster column.  <span style="font-style: italic;">The constraint is typically named enforce_scaley_&lt;r_raster_column&gt;.</span></TD>
    38143814                </TR>
    38153815                <TR>
    38163816                        <TD ALIGN=LEFT>blocksize_x</TD>
    38173817                        <TD ALIGN=LEFT>integer</TD>
    3818                         <TD ALIGN=LEFT>The width of the rasters in this column.  Value is extracted from the ST_Width constraint on this raster column.  The constraint is typically named enforce_width_&lt;r_raster_column&gt;.</TD>
     3818                        <TD ALIGN=LEFT>The width of the rasters in this column.  Value is extracted from the ST_Width constraint on this raster column.  <span style="font-style: italic;">The constraint is typically named enforce_width_&lt;r_raster_column&gt;.</span></TD>
    38193819                </TR>
    38203820                <TR>
    38213821                        <TD ALIGN=LEFT>blocksize_y</TD>
    38223822                        <TD ALIGN=LEFT>integer</TD>
    3823                         <TD ALIGN=LEFT>The height of the rasters in this column.  Value is extracted from the ST_Height constraint on this raster column.  The constraint is typically named enforce_height_&lt;r_raster_column&gt;.</TD>
     3823                        <TD ALIGN=LEFT>The height of the rasters in this column.  Value is extracted from the ST_Height constraint on this raster column.  <span style="font-style: italic;">The constraint is typically named enforce_height_&lt;r_raster_column&gt;.</span></TD>
    38243824                </TR>
    38253825                <TR>
    38263826                        <TD ALIGN=LEFT>same_alignment</TD>
    38273827                        <TD ALIGN=LEFT>boolean</TD>
    3828                         <TD ALIGN=LEFT>If TRUE, all rasters in this column are aligned.  State is extracted from the ST_SameAlignment constraint comparing the rasters in this column against coordinates known to be on the grid.  The constraint is typically named enforce_same_alignment_&lt;r_raster_column&gt;.</TD>
     3828                        <TD ALIGN=LEFT>If TRUE, all rasters in this column are aligned.  State is extracted from the ST_SameAlignment constraint comparing the rasters in this column against coordinates known to be on the grid.  <span style="font-style: italic;">The constraint is typically named enforce_same_alignment_&lt;r_raster_column&gt;.</span></TD>
    38293829                </TR>
    38303830                <TR>
    38313831                        <TD ALIGN=LEFT>regular_blocking</TD>
    38323832                        <TD ALIGN=LEFT>boolean</TD>
    3833                         <TD ALIGN=LEFT>If TRUE, all rasters in this column are regularly blocked.  <span style="color: red; font-weight: bold;">Though this column is technically based upon a constraint, the constraint is purely information and does NO actual constraining.  Therefore if this column is TRUE, a user explicitly specified that the rasters in this column are regularly blocked.</span>  The constraint is typically named enforce_regular_blocking_&lt;r_raster_column&gt;.</TD>
     3833                        <TD ALIGN=LEFT>If TRUE, all rasters in this column are regularly blocked.  <span style="color: red; font-weight: bold;">Though this column is technically based upon a constraint, the constraint is purely information and does NO actual constraining.  Therefore if this column is TRUE, a user explicitly specified that the rasters in this column are regularly blocked.</span>  <span style="font-style: italic;">The constraint is typically named enforce_regular_blocking_&lt;r_raster_column&gt;.</span></TD>
    38343834                </TR>
    38353835                <TR>
    38363836                        <TD ALIGN=LEFT>num_bands</TD>
    38373837                        <TD ALIGN=LEFT>integer</TD>
    3838                         <TD ALIGN=LEFT>The number bands within each raster of this column.  Value is extracted from the ST_NumBands constraint on this raster column.  The constraint is typically named enforce_num_bands_&lt; r_raster_column&gt;.</TD>
     3838                        <TD ALIGN=LEFT>The number bands within each raster of this column.  Value is extracted from the ST_NumBands constraint on this raster column.  <span style="font-style: italic;">The constraint is typically named enforce_num_bands_&lt; r_raster_column&gt;.</span></TD>
    38393839                </TR>
    38403840                <TR>
    38413841                        <TD ALIGN=LEFT>pixel_types</TD>
    38423842                        <TD ALIGN=LEFT>text[]</TD>
    3843                         <TD ALIGN=LEFT>Text array of the pixel types of the bands within each raster of this column.  Value is extracted from a special function that creates an array of the band pixel types of the rasters in this column.  The constraint is typically named enforce_pixel_types_&lt;r_raster_column&gt;.</TD>
     3843                        <TD ALIGN=LEFT>Text array of the pixel types of the bands within each raster of this column.  Value is extracted from a special function that creates an array of the band pixel types of the rasters in this column.  <span style="font-style: italic;">The constraint is typically named enforce_pixel_types_&lt;r_raster_column&gt;.</span></TD>
    38443844                </TR>
    38453845                <TR>
    38463846                        <TD ALIGN=LEFT>nodata_values</TD>
    38473847                        <TD ALIGN=LEFT>double precision[]</TD>
    3848                         <TD ALIGN=LEFT>Double precision array of the NODATA values of the bands within each raster of this column.  Value is extracted from a special function that creates an array of the band NODATA values of the rasters in this column.  The constraint is typically named enforce_nodata_values_&lt;r_raster_column&gt;.</TD>
     3848                        <TD ALIGN=LEFT>Double precision array of the NODATA values of the bands within each raster of this column.  Value is extracted from a special function that creates an array of the band NODATA values of the rasters in this column.  <span style="font-style: italic;">The constraint is typically named enforce_nodata_values_&lt;r_raster_column&gt;.</span></TD>
    38493849                </TR>
    38503850                <TR>
    38513851                        <TD ALIGN=LEFT>extent</TD>
    38523852                        <TD ALIGN=LEFT>geometry</TD>
    3853                         <TD ALIGN=LEFT>The maximum extent within which all rasters of this column must be covered by.  The maximum extent is computed by ST_ConvexHull(ST_Collect(ST_ConvexHull(raster))) of all rasters in this column at the time that the extent constraint was added..  Value is extracted from the ST_CoveredBy(ST_ConvexHull(raster)) constraint on this raster column.  The constraint is typically named enforce_max_extent_&lt;r_raster_column&gt;.</TD>
     3853                        <TD ALIGN=LEFT>The maximum extent within which all rasters of this column must be covered by.  The maximum extent is computed by ST_ConvexHull(ST_Collect(ST_ConvexHull(raster))) of all rasters in this column at the time that the extent constraint was added..  Value is extracted from the ST_CoveredBy(ST_ConvexHull(raster)) constraint on this raster column.  <span style="font-style: italic;">The constraint is typically named enforce_max_extent_&lt;r_raster_column&gt;.</span></TD>
    38543854                </TR>
    38553855        </TBODY>
    … …  
    39243924As all overviews are rasters, overviews will have have a record in raster_columns and another record in raster_overviews.
    39253925
     3926'''One column has been removed from the raster_overviews views: out_db.'''
     3927
    39263928~~Following the conversion of geometry_columns to a view in PostGIS, it is planned to do the same with raster_column and raster_overview for the raster part. Converting to a view has a number of advantages:
    39273929