| 54 | | Objective 0.1.6a - Being able to create tables with RASTER fields. |
| 55 | | |
| 56 | | || '''Task''' || '''Developer''' || '''Schedule''' || '''Time''' || '''Funds (USD)''' || '''Status''' || |
| 57 | | || Initial setup: type definition, canonical input/output || SS || January 2009 || 4 weeks || 2400 by SC, 2600 by MD || done || |
| 58 | | |
| 59 | | Objective 0.1.6b - Being able to select RASTER values based on bbox spatial relation. |
| 60 | | |
| 61 | | || '''Task''' || '''Developer''' || '''Schedule''' || '''Time''' || '''Funds (USD)''' || '''Status''' || |
| 62 | | || Spatial operators with semantic matching PostGIS ones || SS || February 2009 || 1 week || 1200 by TE || done || |
| 63 | | || GiST indexing support || PR || February 2009 || 1 week || 1200 by SC || Done || |
| 64 | | |
| 65 | | Objective 0.1.6c - Being able to import TIFF rasters using raster2pgsql. |
| 66 | | |
| 67 | | || '''Task''' || '''Developer''' || '''Schedule''' || '''Time''' || '''Funds (USD)''' || '''Status''' || |
| 68 | | || gdal2wktraster.py as a prototype of raster2pgsql based on [http://www.gdal.org GDAL] || ML || February 2009 || 1 week || DT by MD || done || |
| 69 | | || raster2pgsql (tiff only, only one band, option for tiling) || ? || March 2009 || 4 weeks ||4800 || to-do || |
| 70 | | |
| 71 | | Objective 0.1.6d - Being able to get all the properties of a raster by use of the following functions: |
| 72 | | * RT_SRID(raster|geometry) -> integer |
| 73 | | * RT_Width(raster) -> integer |
| 74 | | * RT_Height(raster) -> integer |
| 75 | | * RT_XPixelSize(raster) -> float32 |
| 76 | | * RT_YPixelSize(raster) -> float32 |
| 77 | | * RT_YPixelSize(raster) -> float32 |
| 78 | | * RT_XRotation(raster) -> float32 |
| 79 | | * RT_YRotation(raster) -> float32 |
| 80 | | * RT_XUpperLeft(raster) -> float32 |
| 81 | | * RT_YUpperLeft(raster) -> float32 |
| 82 | | * RT_GeoReference(raster) -> string |
| 83 | | * RT_NumBands(raster) -> integer |
| 84 | | * RT_GetBandPixelType(raster, band) -> string |
| 85 | | * RT_BandNoDataValue(raster, band) -> float32 |
| 86 | | |
| 87 | | || '''Task''' || '''Developer''' || '''Schedule''' || '''Time''' || '''Funds (USD)''' || '''Status''' || |
| 88 | | || Implementation of RASTER properties accessors || ML || February 2009 || 1 week || DT by MD || done || |
| 89 | | |
| 90 | | Objective 0.1.6e - Being able to intersect vector and raster to produce vector. This includes implementation of the following functions: |
| 91 | | |
| 92 | | * RT_GetBBox(raster) -> polygon geometry |
| 93 | | * RT_Envelope(raster|geometry) -> polygon geometry |
| 94 | | * RT_Shape(raster) -> polygon geometry |
| 95 | | * RT_AsPolygon(raster) -> polygon geometry set |
| 96 | | * RT_Intersects(raster|geometry, raster|geometry) |
| 97 | | * RT_Intersection(raster|geometry, raster|geometry, ‘raster’|’geometry’)->raster/geometry |
| 98 | | |
| 99 | | || '''Task''' || '''Developer''' || '''Schedule''' || '''Time''' || '''Funds (USD)''' || '''Status''' || |
| 100 | | || Implementation of functions producing raster-vector intersections || PR || April-June 2009 || 4 weeks || 4800 by SC || in-progress || |
| 101 | | |
| 102 | | |
| 103 | | Objective 0.1.6f - Being able to return a JPEG, a TIFF or a PNG. This milestone includes implementation of the following functions: |
| 104 | | * RT_Band(raster, band) -> raster |
| 105 | | * RT_AsJPEG(raster, band, quality) -> JPEG as "bytea" |
| 106 | | * RT_AsTIFF(raster, band, compression) -> TIFF as "bytea" |
| 107 | | * RT_AsPNG(raster, band) -> PNG as "bytea" |
| 108 | | |
| 109 | | || '''Task''' || '''Developer''' || '''Schedule''' || '''Time''' || '''Funds (USD)''' || '''Status''' || |
| 110 | | || Implementation of JPEG, TIFF and PNG output functions || ? || April 2009 || 2 weeks || 2400 || to-do || |
| | 54 | ||'''Objectives and Tasks'''||'''Coder'''||'''Approx. Schedule'''||'''Time'''||'''Fund (US$)'''||'''Status'''|| |
| | 55 | ||[[BR]]'''B01a - Being able to create tables with RASTER fields'''|| |
| | 56 | ||Initial setup: type definition, canonical input/output||SS||January 2009||4 weeks||2400 by SC[[BR]]2600 by MD||Done |
| | 57 | ||[[BR]]'''B01b - Being able to select RASTER values based on bbox spatial relation''' |
| | 58 | ||[[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 |
| | 59 | ||GiST indexing support||PR||February 2009||1 week||1200 by SC||Done |
| | 60 | ||[[BR]]'''B01c - Being able to import TIFF rasters using raster2pgsql.exe''' |
| | 61 | ||gdal2wktraster.py as a prototype of raster2pgsql.exe[[BR]](uses GDAL)||ML||February 2009||1 week||DevTime from MD||Done |
| | 62 | ||raster2pgsql.exe[[BR]](tiff only, only one band, option for tiling)||TBD||March 2009||4 weeks||4800||Todo |
| | 63 | ||[[BR]]'''B01d - Being able to get all the properties of a raster (all the "Get" functions).'''|| |
| | 64 | ||- RT_SRID(raster|geometry) -> integer[[BR]]- RT_GetWidth(raster) -> integer[[BR]]- RT_GetHeight(raster) -> integer[[BR]]- RT_GetXPixelSize(raster) -> float32[[BR]]- RT_GetYPixelSize(raster) -> float32[[BR]]- RT_GetYPixelSize(raster) -> float32[[BR]]- RT_GetXRotation(raster) -> float32[[BR]]- RT_GetYRotation(raster) -> float32[[BR]]- RT_GetXUpperLeft(raster) -> float32[[BR]]- RT_GetYUpperLeft(raster) -> float32[[BR]]- RT_GetGeoReference(raster) -> string[[BR]]- RT_GetNumBands(raster) -> integer[[BR]]- RT_GetBandPixelType(raster, band) -> string[[BR]]- RT_GetBandNoDataValue(raster, band) -> float32||ML||February 2009||1 weeks||DevTime from MD||Done|| |
| | 65 | ||[[BR]]'''B01e - Being able to intersect vector and raster to produce vector. '''|| |
| | 66 | ||- RT_GetBBox(raster) -> polygon geometry[[BR]]- RT_Envelope(raster|geometry) -> polygon geometry[[BR]]- RT_Shape(raster) -> polygon geometry[[BR]]- RT_AsPolygon(raster) -> polygon geometry set[[BR]]- RT_Intersects(raster|geometry, raster|geometry)[[BR]]- RT_Intersection(raster|geometry, raster|geometry, ‘raster’|’geometry’)->raster/geometry||PR||April-June 2009||4 weeks||4800 by SC||In progress|| |
| | 67 | ||[[BR]]'''B01f - Being able to return a JPEG, a TIFF or a PNG.'''|| |
| | 68 | ||- RT_Band(raster, band) -> raster[[BR]]- RT_AsJPEG(raster, band, quality) -> JPEG as "bytea"[[BR]]- RT_AsTIFF(raster, band, compression) -> TIFF as "bytea"[[BR]]- RT_AsPNG(raster, band) -> PNG as "bytea"||TBD||April 2009||2 weeks||2400||To do|| |
