Changes between Version 64 and Version 65 of WKTRaster/PlanningAndFunding


Ignore:
Timestamp:
Feb 3, 2010, 7:40:30 AM (13 years ago)
Author:
pracine
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • WKTRaster/PlanningAndFunding

    v64 v65  
    2424'''Need raster? -''' If you need support for raster in [http://www.postgresql.org/ PostgreSQL] or you have to do raster/vector operations, help us develop WKT Raster! WKT Raster developement is a work in progress. Each slice of 2000$ will bring new functions in! The approximate cost of the whole project is about 60 000$US. If 30 groups each give 2000$US, we will have the best seamless raster/vector set of SQL functions available by the end of 2009!
    2525
    26 '''Time or Money -''' You can contribute with money or developer time (DevTime). Contributing give you the opportunity to have a word to say on the development priorities and on the schedule.
     26'''Time or Money -''' You can contribute with money or developer time (!DevTime). Contributing give you the opportunity to have a word to say on the development priorities and on the schedule.
    2727
    2828For financial contribution, the conversion rate between time and money is 1200$ per week ˜ 5000US$ per month ˜ 60 000 US$ per year. Coders have to be experienced C developer with a minimal object oriented database development experience. There are some developers out there willing to offer their services to implement your needs.
     
    7474||GiST indexing support||PR||February 2009||1 week||1200 by SC||done
    7575||[[BR]]'''Objective 0.1.6c - Being able to load raster in the database''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6c-Beingabletoloadrastersinthedatabase specifications])
    76 ||gdal2wktraster.py as a prototype of raster2pgsql.exe based on [http://www.gdal.org/ GDAL]||ML||February 2009||1 week||DevTime from MD||done
     76||gdal2wktraster.py as a prototype of raster2pgsql.exe based on [http://www.gdal.org/ GDAL]||ML||February 2009||1 week||!DevTime from MD||done
    7777||raster2pgsql.exe[[BR]](tiff only, only one band, option for tiling)||TBD||March 2009||4 weeks||4800||todo
    7878||[[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])||
    79 ||- ST_SRID(raster|geometry) -> integer[[BR]]- ST_GetWidth(raster) -> integer[[BR]]- ST_GetHeight(raster) -> integer[[BR]]- ST_GetXPixelSize(raster) -> float32[[BR]]- ST_GetYPixelSize(raster) -> float32[[BR]]- ST_GetYPixelSize(raster) -> float32[[BR]]- ST_GetXRotation(raster) -> float32[[BR]]- ST_GetYRotation(raster) -> float32[[BR]]- ST_GetXUpperLeft(raster) -> float32[[BR]]- ST_GetYUpperLeft(raster) -> float32[[BR]]- ST_GetGeoReference(raster) -> string[[BR]]- ST_GetNumBands(raster) -> integer[[BR]]- ST_GetBandPixelType(raster, band) -> string[[BR]]- ST_GetBandNoDataValue(raster, band) -> float32||ML||February 2009||1 weeks||DevTime from MD||done||
     79||- ST_SRID(raster|geometry) -> integer[[BR]]- ST_GetWidth(raster) -> integer[[BR]]- ST_GetHeight(raster) -> integer[[BR]]- ST_GetXPixelSize(raster) -> float32[[BR]]- ST_GetYPixelSize(raster) -> float32[[BR]]- ST_GetYPixelSize(raster) -> float32[[BR]]- ST_GetXRotation(raster) -> float32[[BR]]- ST_GetYRotation(raster) -> float32[[BR]]- ST_GetXUpperLeft(raster) -> float32[[BR]]- ST_GetYUpperLeft(raster) -> float32[[BR]]- ST_GetGeoReference(raster) -> string[[BR]]- ST_GetNumBands(raster) -> integer[[BR]]- ST_GetBandPixelType(raster, band) -> string[[BR]]- ST_GetBandNoDataValue(raster, band) -> float32||ML||February 2009||1 weeks||!DevTime from MD||done||
    8080||[[BR]]'''Objective 0.1.6e - Being able to intersect vector and raster to produce vector. ''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6e-Beingabletointersectvectorandrastertoproducevector. specifications])||
    81 ||- ST_ConvexHull(raster) -> polygon geometry[[BR]]- ST_Envelope(raster|geometry) -> polygon geometry[[BR]]- ST_Shape(raster) -> polygon geometry[[BR]]- ST_AsPolygon(raster) -> polygon geometry set[[BR]]- ST_Intersects(raster|geometry, raster|geometry)[[BR]]- ST_Intersection(raster|geometry, raster|geometry, ‘raster’|’geometry’)->raster/geometry||JA||July - August 2010||4 weeks||4800 by SC / DevTime from JA ||in-progress||
     81||- ST_ConvexHull(raster) -> polygon geometry[[BR]]- ST_Envelope(raster|geometry) -> polygon geometry[[BR]]- ST_Shape(raster) -> polygon geometry[[BR]]- ST_AsPolygon(raster) -> polygon geometry set[[BR]]- ST_Intersects(raster|geometry, raster|geometry)[[BR]]- ST_Intersection(raster|geometry, raster|geometry, ‘raster’|’geometry’)->raster/geometry||JA||July - August 2010||4 weeks||4800 by SC / !DevTime from JA ||in-progress||
    8282||[[BR]]'''Objective 0.1.6f - Being able to return a JPEG, a TIFF or a PNG.''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6f-BeingabletoreturnaJPEGaTIFForaPNG. specifications])||
    83 ||- ST_Band(raster, band) -> raster[[BR]]- ST_AsJPEG(raster, band, quality) -> JPEG as "bytea"[[BR]]- ST_AsTIFF(raster, band, compression) -> TIFF as "bytea"[[BR]]- ST_AsPNG(raster, band) -> PNG as "bytea"||ML||July - August 2010||2 weeks||2400 / DevTime from ML||todo||
     83||- ST_Band(raster, band) -> raster[[BR]]- ST_AsJPEG(raster, band, quality) -> JPEG as "bytea"[[BR]]- ST_AsTIFF(raster, band, compression) -> TIFF as "bytea"[[BR]]- ST_AsPNG(raster, band) -> PNG as "bytea"||ML||July - August 2010||2 weeks||2400 / !DevTime from ML||todo||
    8484||[[BR]]'''Objective 0.1.6g - Being able to read and write WKT Raster with GDAL driver. ''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6g-BeingabletoreadandwriteWKTRasterwithGDALdriver. specifications])||
    85 ||- Read a WKT Raster from database (in-db/out-db, regular/irregular blocking)[[BR]]- Create a new WKT Raster in database (in-db/out-db, regular/irregular blocking)||JA||July - August 2010||4 weeks||DevTime from JA ||in-progress||
     85||- Read a WKT Raster from database (in-db/out-db, regular/irregular blocking)[[BR]]- Create a new WKT Raster in database (in-db/out-db, regular/irregular blocking)||JA||July - August 2010||4 weeks||!DevTime from JA ||in-progress||
    8686
    8787== Milestones for Beta 0.2.4 ==
     
    124124||[[BR]]'''Objective B07b - Being able to edit a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||
    125125||- ST_SetValue(raster, band, x, y, value)[[BR]]- ST_Affine(raster|geometry,...) -> same type as input[[BR]]- ST_Translate(raster|geometry,...) -> same type as input[[BR]]- ST_Scale(raster|geometry,...) -> same type as input[[BR]]- ST_TransScale(raster|geometry,...) -> same type as input[[BR]]- ST_RotateZ,Y,Z(raster|geometry, float8) -> same type as input||TBD||||2 weeks||2400||todo||
    126 ||Other functions[[BR]]- ST_AsBinary(raster, compression)[[BR]]- ST_RasterFromWKB(raster, [<srid>])[[BR]]- ST_RasterFromText(string, [<srid>])[[BR]]- ST_AsText(raster)|| ML (start ST_AsBinary) || Aug 2009||2 weeks||2400 / DevTime from MD||in-progress||
     126||Other functions[[BR]]- ST_AsBinary(raster, compression)[[BR]]- ST_RasterFromWKB(raster, [<srid>])[[BR]]- ST_RasterFromText(string, [<srid>])[[BR]]- ST_AsText(raster)|| ML (start ST_AsBinary) || Aug 2009||2 weeks||2400 / !DevTime from MD||in-progress||
    127127||'''Total'''||||||48 weeks||58800||||
    128128