| 80 | | == Milestones for Beta 0.1.6 - All Done == |
| 81 | | |
| 82 | | |
| 83 | | ||'''Objectives and Tasks'''||'''Coder'''||'''Approx. Schedule'''||'''Time'''||'''Approx. Contribution (US$)'''||'''Status'''|| |
| 84 | | |
| 85 | | ||[[BR]]'''Objective 0.1.6a - Being able to create tables with RASTER fields'''|||||||||| |
| 86 | | ||Initial setup: type definition, canonical input/output||SS||January 2009||4 weeks||2400 by SC[[BR]]2600 by MD||done |
| 87 | | ||[[BR]]'''Objective 0.1.6b - Being able to select RASTER values based on bbox spatial relation'''|||||||||| |
| 88 | | ||[http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2747989 Spatial operators with semantic matching postgis ones] ||SS||February 2009||1 week||1200 by TE||done |
| 89 | | ||GiST indexing support||PR||February 2009||1 week||1200 by SC||done |
| 90 | | ||[[BR]]'''Objective 0.1.6c - Being able to load raster in the database''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6c-Beingabletoloadrastersinthedatabase specifications])|||||||||| |
| 91 | | ||gdal2wktraster.py as a prototype of raster2pgsql.exe based on [http://www.gdal.org/ GDAL]||ML||February 2009||1 week||!DevTime from MD||done |
| 92 | | ||[[BR]]'''Objective 0.1.6d - Being able to get all the properties of a raster (all the "Get" functions).''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6d-BeingabletogetallthepropertiesofarasteralltheGetfunctions. specifications])|||||||||| |
| 93 | | ||- ST_SRID(raster|geometry) -> integer[[BR]]- ST_Width(raster) -> integer[[BR]]- ST_Height(raster) -> integer[[BR]]- ST_PixelSizeX(raster) -> float32[[BR]]- ST_PixelSizeY(raster) -> float32[[BR]]- ST_RotationX(raster) -> float32[[BR]]- ST_RotationY(raster) -> float32[[BR]]- ST_UpperLeftX(raster) -> float32[[BR]]- ST_UpperLeftY(raster) -> float32[[BR]]- ST_GeoReference(raster) -> string[[BR]]- ST_NumBands(raster) -> integer[[BR]]- ST_BandPixelType(raster, band) -> string[[BR]]- ST_BandNoDataValue(raster, band) -> float32||ML||February 2009||1 weeks||!DevTime from MD||done|| |
| 94 | | ||[[BR]]'''Objective 0.1.6e - Being able to intersect geometries and rasters to produce geometries . ''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6e-Beingabletointersectvectorandrastertoproducevector. specifications])|||||||||| |
| 95 | | ||- ST_ConvexHull(raster) -> polygon geometry[[BR]]- ST_Envelope(raster|geometry) -> polygon geometry[[BR]]- ST_Polygon(raster) -> polygon geometry[[BR]]- ST_DumpAsPolygons(raster) -> polygon geometry set[[BR]]- ST_Intersects(raster|geometry, raster|geometry)[[BR]]- ST_Intersection(raster|geometry, raster|geometry)->geometry set||JA & PR||July - August 2010||8 weeks||4800 by SC / !DevTime from JA ||done|| |
| 96 | | ||[[BR]]'''Objective 0.1.6f - Being able to set all the properties of a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])|||||||||| |
| 97 | | ||- ST_SetSRID(raster|geometry, integer)[[BR]]- ST_SetPixelSize(raster, pixelsizex, pixelsizey)[[BR]]- ST_SetBandNoDataValue(raster, band, nodatavalue)[[BR]]- ST_SetGeoReference(raster, string)[[BR]]- ST_SetSkew(raster, skewx, skewy)[[BR]]- ST_SetUpperLeft(raster, x, y)||DZ||April 2010||1 week||Devtime from DZ||done|| |
| 98 | | ||[[BR]]'''Objective 0.1.6g - Being able to register images as raster stored outside the database.''' ([wiki:WKTRaster/SpecificationWorking02#ObjectiveB02a-BeingabletoregisterTIFFandJPEGtilesasrasterstoredoutsidethedatabase. specifications])|||||||||| |
| 99 | | ||- Mostly changes to gdal2wktraster.py[[BR]]- ST_BandPath() -> string||PR||February 2010||1 weeks||2400||done|| |
| 100 | | ||[[BR]]'''Objective 0.1.6h - Being able to quickly get metadata for raster and band.'''|||||||||| |
| 101 | | ||- ST_Metadata(rast)[[BR]]- ST_BandMetadata(rast||PR||June 2010||1 day||!DevTime from SC||done|| |
| 102 | | ||[[BR]]'''Objective 0.1.6i - Being able to easily convert world coordinates to raster coordinates.'''|||||||||| |
| 103 | | ||- ST_World2RasterCoordX(rast, xw, yw)[[BR]]- ST_World2RasterCoordY(rast, xw, yw)[[BR]]- ST_Raster2WorldCoordX(rast, xr, yr)[[BR]]- ST_Raster2WorldCoordY(rast, xr, yr)||PR||June 2010||3 day||!DevTime from SC||done|| |
| 104 | | ||[[BR]]'''Objective 0.1.6j - Being able to set and know if a band nodata value is a true nodata value.'''|||||||||| |
| 105 | | ||- ST_BandHasNodataValue(rast, band)[[BR]]- ST_SetBandHasNodataValue(rast, band, boolean)||PR||June 2010||1 day||!DevTime from SC||done|| |
| 106 | | ||[[BR]]'''Objective 0.1.6k - Being able to get and set the value of a pixel.'''|||||||||| |
| 107 | | ||- ST_Value(rast, band, x, y)[[BR]]- ST_SetValue(rast, band, x, y, val)||PR||July 2010||1 day||!DevTime from SC||done|| |
| | 143 | |
| | 144 | == Old Milestones for Beta 0.1.6 - All Done == |
| | 145 | |
| | 146 | |
| | 147 | ||'''Objectives and Tasks'''||'''Coder'''||'''Approx. Schedule'''||'''Time'''||'''Approx. Contribution (US$)'''||'''Status'''|| |
| | 148 | |
| | 149 | ||[[BR]]'''Objective 0.1.6a - Being able to create tables with RASTER fields'''|||||||||| |
| | 150 | ||Initial setup: type definition, canonical input/output||SS||January 2009||4 weeks||2400 by SC[[BR]]2600 by MD||done |
| | 151 | ||[[BR]]'''Objective 0.1.6b - Being able to select RASTER values based on bbox spatial relation'''|||||||||| |
| | 152 | ||[http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2747989 Spatial operators with semantic matching postgis ones] ||SS||February 2009||1 week||1200 by TE||done |
| | 153 | ||GiST indexing support||PR||February 2009||1 week||1200 by SC||done |
| | 154 | ||[[BR]]'''Objective 0.1.6c - Being able to load raster in the database''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6c-Beingabletoloadrastersinthedatabase specifications])|||||||||| |
| | 155 | ||gdal2wktraster.py as a prototype of raster2pgsql.exe based on [http://www.gdal.org/ GDAL]||ML||February 2009||1 week||!DevTime from MD||done |
| | 156 | ||[[BR]]'''Objective 0.1.6d - Being able to get all the properties of a raster (all the "Get" functions).''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6d-BeingabletogetallthepropertiesofarasteralltheGetfunctions. specifications])|||||||||| |
| | 157 | ||- ST_SRID(raster|geometry) -> integer[[BR]]- ST_Width(raster) -> integer[[BR]]- ST_Height(raster) -> integer[[BR]]- ST_PixelSizeX(raster) -> float32[[BR]]- ST_PixelSizeY(raster) -> float32[[BR]]- ST_RotationX(raster) -> float32[[BR]]- ST_RotationY(raster) -> float32[[BR]]- ST_UpperLeftX(raster) -> float32[[BR]]- ST_UpperLeftY(raster) -> float32[[BR]]- ST_GeoReference(raster) -> string[[BR]]- ST_NumBands(raster) -> integer[[BR]]- ST_BandPixelType(raster, band) -> string[[BR]]- ST_BandNoDataValue(raster, band) -> float32||ML||February 2009||1 weeks||!DevTime from MD||done|| |
| | 158 | ||[[BR]]'''Objective 0.1.6e - Being able to intersect geometries and rasters to produce geometries . ''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6e-Beingabletointersectvectorandrastertoproducevector. specifications])|||||||||| |
| | 159 | ||- ST_ConvexHull(raster) -> polygon geometry[[BR]]- ST_Envelope(raster|geometry) -> polygon geometry[[BR]]- ST_Polygon(raster) -> polygon geometry[[BR]]- ST_DumpAsPolygons(raster) -> polygon geometry set[[BR]]- ST_Intersects(raster|geometry, raster|geometry)[[BR]]- ST_Intersection(raster|geometry, raster|geometry)->geometry set||JA & PR||July - August 2010||8 weeks||4800 by SC / !DevTime from JA ||done|| |
| | 160 | ||[[BR]]'''Objective 0.1.6f - Being able to set all the properties of a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])|||||||||| |
| | 161 | ||- ST_SetSRID(raster|geometry, integer)[[BR]]- ST_SetPixelSize(raster, pixelsizex, pixelsizey)[[BR]]- ST_SetBandNoDataValue(raster, band, nodatavalue)[[BR]]- ST_SetGeoReference(raster, string)[[BR]]- ST_SetSkew(raster, skewx, skewy)[[BR]]- ST_SetUpperLeft(raster, x, y)||DZ||April 2010||1 week||Devtime from DZ||done|| |
| | 162 | ||[[BR]]'''Objective 0.1.6g - Being able to register images as raster stored outside the database.''' ([wiki:WKTRaster/SpecificationWorking02#ObjectiveB02a-BeingabletoregisterTIFFandJPEGtilesasrasterstoredoutsidethedatabase. specifications])|||||||||| |
| | 163 | ||- Mostly changes to gdal2wktraster.py[[BR]]- ST_BandPath() -> string||PR||February 2010||1 weeks||2400||done|| |
| | 164 | ||[[BR]]'''Objective 0.1.6h - Being able to quickly get metadata for raster and band.'''|||||||||| |
| | 165 | ||- ST_Metadata(rast)[[BR]]- ST_BandMetadata(rast||PR||June 2010||1 day||!DevTime from SC||done|| |
| | 166 | ||[[BR]]'''Objective 0.1.6i - Being able to easily convert world coordinates to raster coordinates.'''|||||||||| |
| | 167 | ||- ST_World2RasterCoordX(rast, xw, yw)[[BR]]- ST_World2RasterCoordY(rast, xw, yw)[[BR]]- ST_Raster2WorldCoordX(rast, xr, yr)[[BR]]- ST_Raster2WorldCoordY(rast, xr, yr)||PR||June 2010||3 day||!DevTime from SC||done|| |
| | 168 | ||[[BR]]'''Objective 0.1.6j - Being able to set and know if a band nodata value is a true nodata value.'''|||||||||| |
| | 169 | ||- ST_BandHasNodataValue(rast, band)[[BR]]- ST_SetBandHasNodataValue(rast, band, boolean)||PR||June 2010||1 day||!DevTime from SC||done|| |
| | 170 | ||[[BR]]'''Objective 0.1.6k - Being able to get and set the value of a pixel.'''|||||||||| |
| | 171 | ||- ST_Value(rast, band, x, y)[[BR]]- ST_SetValue(rast, band, x, y, val)||PR||July 2010||1 day||!DevTime from SC||done|| |
