Changes between Version 198 and Version 199 of WKTRaster/SpecificationWorking03


Ignore:
Timestamp:
Dec 9, 2011, 8:46:53 PM (12 years ago)
Author:
Bborie Park
Comment:

raster_overviews

Legend:

Unmodified
Added
Removed
Modified

  • WKTRaster/SpecificationWorking03

    v198 v199  
    38583858}}}
    38593859
    3860 One column has been removed from the raster_columns views: out_db.
    3861 
     3860'''One column has been removed from the raster_columns views: out_db.'''
     3861
     3862The raster_overviews view is structured as the following:
     3863
     3864{{{
     3865#!html
     3866<TABLE BORDER=1>
     3867        <THEAD>
     3868                <TR>
     3869                        <TD ALIGN=LEFT style="font-weight: bold; font-style: italic;">Column</TD>
     3870                        <TD ALIGN=LEFT style="font-weight: bold; font-style: italic;">PostgreSQL Type</TD>
     3871                        <TD ALIGN=LEFT style="font-weight: bold; font-style: italic;">Description</TD>
     3872                </TR>
     3873        </THEAD>
     3874        <TBODY>
     3875                <TR>
     3876                        <TD ALIGN=LEFT>o_table_catalog</TD>
     3877                        <TD ALIGN=LEFT>name</TD>
     3878                        <TD ALIGN=LEFT>Name of the database containing the table with the overview column.</TD>
     3879                </TR>
     3880                <TR>
     3881                        <TD ALIGN=LEFT>o_table_schema</TD>
     3882                        <TD ALIGN=LEFT>name</TD>
     3883                        <TD ALIGN=LEFT>Name of the schema containing the table with the overview column.</TD>
     3884                </TR>
     3885                <TR>
     3886                        <TD ALIGN=LEFT>o_table_name</TD>
     3887                        <TD ALIGN=LEFT>name</TD>
     3888                        <TD ALIGN=LEFT>Name of the table containing a column of type raster considered an overview.</TD>
     3889                </TR>
     3890                <TR>
     3891                        <TD ALIGN=LEFT>o_raster_column</TD>
     3892                        <TD ALIGN=LEFT>name</TD>
     3893                        <TD ALIGN=LEFT>Name of the overview column in the table. All attribute columns following this column apply to the rasters in this column.</TD>
     3894                </TR>
     3895                <TR>
     3896                        <TD ALIGN=LEFT>r_table_catalog</TD>
     3897                        <TD ALIGN=LEFT>name</TD>
     3898                        <TD ALIGN=LEFT>Name of the database containing the table with the raster column from which this overview column was derived.</TD>
     3899                </TR>
     3900                <TR>
     3901                        <TD ALIGN=LEFT>r_table_schema</TD>
     3902                        <TD ALIGN=LEFT>name</TD>
     3903                        <TD ALIGN=LEFT>Name of the schema containing the table with the raster column from which this overview column was derived.</TD>
     3904                </TR>
     3905                <TR>
     3906                        <TD ALIGN=LEFT>r_table_name</TD>
     3907                        <TD ALIGN=LEFT>name</TD>
     3908                        <TD ALIGN=LEFT>Name of the table containing a column of type raster from which this overview column was derived.</TD>
     3909                </TR>
     3910                <TR>
     3911                        <TD ALIGN=LEFT>r_raster_column</TD>
     3912                        <TD ALIGN=LEFT>name</TD>
     3913                        <TD ALIGN=LEFT>Name of the raster column in the table from which this overview column was derived.</TD>
     3914                </TR>
     3915                <TR>
     3916                        <TD ALIGN=LEFT>overview_factor</TD>
     3917                        <TD ALIGN=LEFT>integer</TD>
     3918                        <TD ALIGN=LEFT>The factor used to compute the overviews in this column.  If the factor is 2, the overviews' scale is 2x of the reference rasters.  </TD>
     3919                </TR>
     3920        </TBODY>
     3921</TABLE>
     3922}}}
     3923
     3924As all overviews are rasters, overviews will have have a record in raster_columns and another record in raster_overviews.
    38623925
    38633926~~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: