Changes between Version 193 and Version 194 of WKTRaster/SpecificationWorking03
- Timestamp:
- 12/01/11 08:20:26 (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TabularUnified WKTRaster/SpecificationWorking03
v193 v194 539 539 The '''major changes concerning the raster_column table''' are as follow: 540 540 541 * There will be a flexible !A pplyRasterConstraint() function trying to apply a set of constraint on a table. As for any constraint, each constraint will be successfully applied only when all the rows of the table fulfill this constraint. The list of potential constraint applied by the C loader (using the !ApplyRasterConstraint function) and hence the list of column available in the raster_column view will be: srid int, samealignment boolean, scalex float8, scaley float8, width int, height int, numberofbands int, pixeltypes text[], nodatavalues float[] in addition to the 'r_table_catalog', 'r_table_schema', 'r_table_name' and 'r_column' columns. There is still discussion about if global extent as a geometry should be added to this list. Comments are welcome.541 * There will be a flexible !AddRasterConstraint() function trying to add a set of constraint on a table. As for any constraint, each constraint will be successfully applied only when all the rows of the table fulfill this constraint. The list of potential constraint applied by the C loader (using the !AddRasterConstraint function) and hence the list of column available in the raster_column view will be: srid int, samealignment boolean, scalex float8, scaley float8, width int, height int, numberofbands int, pixeltypes text[], nodatavalues float[] in addition to the 'r_table_catalog', 'r_table_schema', 'r_table_name' and 'r_column' columns. There is still discussion about if global extent as a geometry should be added to this list. Comments are welcome. 542 542 543 543 * The raster_column view rows will be determined by querying the PostgreSQL catalog. A typical query exists for this. 544 544 545 * The raster_column view will derive columns of metadata from the constraints applied to each table listed. When a constraint does not exist (because it could not be applied successfully to the table by !A pplyRasterconstraint()), the column corresponding to this constraint for this table will be null.545 * The raster_column view will derive columns of metadata from the constraints applied to each table listed. When a constraint does not exist (because it could not be applied successfully to the table by !AddRasterconstraint()), the column corresponding to this constraint for this table will be null. 546 546 547 547 The '''major changes concerning the raster_overview table''' are as follow: … … 549 549 * The raster_overview table will also be replaced by a raster_overview view. 550 550 551 * We will provide a new function to support the creation of the raster_overview view and application of three additional constraints specific to overviews (!A pplyOverviewConstraints). These three additional constraints are: 'reference raster table oid', 'overview factor' and 'global extent'. Those constraints will be displayed by the raster_overview view as 'r_table_catalog', 'r_table_schema', 'r_table_name', 'r_column', 'overview_factor' and 'global_extent' in addition to the 'o_table_catalog', 'o_table_schema', 'o_table_name' and 'o_column' columns.551 * We will provide a new function to support the creation of the raster_overview view and application of three additional constraints specific to overviews (!AddOverviewConstraints). These three additional constraints are: 'reference raster table oid', 'overview factor' and 'global extent'. Those constraints will be displayed by the raster_overview view as 'r_table_catalog', 'r_table_schema', 'r_table_name', 'r_column', 'overview_factor' and 'global_extent' in addition to the 'o_table_catalog', 'o_table_schema', 'o_table_name' and 'o_column' columns. 552 552 553 553 * We will also provide a SQL function for creating overviews (ST_CreateOverview(schemaname text, tablename teat, columnname, factor int)). 554 554 555 * The raster_overview view will NOT be created by default by the rtpostgis.sql script. It will be the responsibility of applications to use the !A pplyOverviewConstraints and ST_CreateOverview() function to create the raster_overviews view and create overviews.555 * The raster_overview view will NOT be created by default by the rtpostgis.sql script. It will be the responsibility of applications to use the !AddOverviewConstraints and ST_CreateOverview() function to create the raster_overviews view and create overviews. 556 556 557 557 The '''major changes concerning the raster2pgsql loader''' are as follow: … … 559 559 * We are working on a new C importer to get rid of any Python, Numpy and Python GDAL Binding dependency which is a major obstacle to successful installation of PostGIS 2.0. 560 560 561 * This new loader will attempt to a pply the constraints on the loaded table using the !ApplyRasterConstraint() function. There will be an option to NOT try to applythe constraint for applications preferring to have no constraint applied to the tables over having a raster_column view filled with the proper information.561 * This new loader will attempt to add the constraints on the loaded table using the !AddRasterConstraint() function. There will be an option to NOT try to add the constraint for applications preferring to have no constraint applied to the tables over having a raster_column view filled with the proper information. 562 562 563 563 * This new importer will NOT have any option to create the raster_overview view, nor to create overview tables as we leave this to the application. We also think that it is more important to be able to create overviews in SQL as a post loading process query so overviews can be updated/recreated when rasters tiles are edited, added or deleted. Application wishing to create overview can implement their own overview creation code or just use the future ST_CreateOverview() SQL function. 564 564 565 * We will stop supporting the old raster2pgsql.py which was creating overview tables and filling the raster_overview table. It will be available in the script/python folder for people wishing to create overviews after a slight addaptation (to the new !A pplyRasterConstraints() and !ApplyOverviewConstraints() functions).565 * We will stop supporting the old raster2pgsql.py which was creating overview tables and filling the raster_overview table. It will be available in the script/python folder for people wishing to create overviews after a slight addaptation (to the new !AddRasterConstraints() and !AddOverviewConstraints() functions). 566 566 567 567