= PostGIS WKT Raster Planning and Funding = {{{ #!html
}}} '''Quick Links''' * [wiki:WKTRaster WKT Raster Home Page] * [wiki:WKTRaster/SpecificationWorking01 Beta 0.1.6 Working Specifications] * [wiki:WKTRaster/SpecificationFinal01 Beta 0.1.6 Final Specifications] * [wiki:WKTRaster/Documentation01 Beta 0.1.6 Documentation] * [wiki:WKTRaster/SpecificationWorking02 Beta 0.2.4 Working Specifications] * [wiki:WKTRaster/SpecificationWorking03 Working Specifications for Future Versions] {{{ #!html
}}} [[TOC]] This is the development page of [wiki:WKTRaster PostGIS WKT Raster] - a project extending PostGIS engine with raster support. '''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! '''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. For 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. '''Expectations -''' We expect that developers will: * Try to follow the schedule or at least arrange it to fit their particular needs as much as possible in accordance with the project roadmap. The project is divided into coherent groups of tasks. We are very flexible on modifying the content of those sections. * Contribute to the specifications in order to agree and to keep track of what's done. Specifications of the intented development should be described in the Specifications page and submited to the postgis-devel mailing list for comments before starting development. Ask [http://www.cef-cfr.ca/index.php?n=Membres.PierreRacine Pierre Racine] to get write access to the specification page. * Contribute to the Documentation as much as they can to make sure we produce a coherent and a professional open source product. '''Tasks -''' Tasks are arranged into coherent groups: Similar functions together and dependencies first. == Developers == WKT Raster development team members with officially allocated tasks: * [http://mateusz.loskot.net/ Mateusz Loskot] (ML) at ([http://cadcorp.com/ Cadcorp]) * [http://www.cef-cfr.ca/index.php?n=Membres.PierreRacine Pierre Racine] (PR) * [http://foo.keybit.net/~strk/ Sandro Santilli] (SS) * [http://www.gis4free.org/blog Jorge Arévalo] (JA) at ([http://www.deimos-space.com/UK/index.asp?lang=UK Deimos Space]) == Funding Contributors == Prime financial contributors who established development of the WKT Raster project: * [http://www.cef-cfr.ca/index.php?n=Membres.StevenGCumming Steve Cumming] (SC): 2400 + 4800 + 4800 + 1200 = $13200 USD * [http://blog.lostinspatial.com/ Martin Daly] (MD), ([http://cadcorp.com/ Cadcorp]): $2600 USD and 2 weeks of Development Time (DT) * [http://wiki.mtri.org/display/mtripub/tyler+erickson/ Tyler Erickson] (TE), ([http://mtri.org/ Michigan Tech Research Institute]): $1200 USD == Development Status == Explanation of status markers used in the tables below: * '''todo''': The task has not yet been funded. Everything is to do. * '''funded''': Someone committed some funding or developer time and the task has been assigned to a developper but the task is still to do. * '''in-progress''': The task is being implemented. * '''pending''': The developer is waiting for other development to continue. * '''buggy''': The tast has been implemented but is disfunctional for some reason. * '''done''': The task is finished. == Milestones for Beta 0.1.6 == ||'''Objectives and Tasks'''||'''Coder'''||'''Approx. Schedule'''||'''Time'''||'''Fund (US$)'''||'''Status'''|| ||[[BR]]'''Objective 0.1.6a - Being able to create tables with RASTER fields'''|| ||Initial setup: type definition, canonical input/output||SS||January 2009||4 weeks||2400 by SC[[BR]]2600 by MD||done ||[[BR]]'''Objective 0.1.6b - Being able to select RASTER values based on bbox spatial relation''' ||[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 ||GiST indexing support||PR||February 2009||1 week||1200 by SC||done ||[[BR]]'''Objective 0.1.6c - Being able to load raster in the database''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6c-Beingabletoloadrastersinthedatabase specifications]) ||gdal2wktraster.py as a prototype of raster2pgsql.exe based on [http://www.gdal.org/ GDAL]||ML||February 2009||1 week||!DevTime from MD||done ||raster2pgsql.exe[[BR]](tiff only, only one band, option for tiling)||TBD||March 2009||4 weeks||4800||todo ||[[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])|| ||- 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|| ||[[BR]]'''Objective 0.1.6e - Being able to intersect vector and raster to produce vector. ''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6e-Beingabletointersectvectorandrastertoproducevector. specifications])|| ||- 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|| ||[[BR]]'''Objective 0.1.6f - Being able to return a JPEG, a TIFF or a PNG.''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6f-BeingabletoreturnaJPEGaTIFForaPNG. specifications])|| ||- 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|| ||[[BR]]'''Objective 0.1.6g - Being able to read and write WKT Raster with GDAL driver. ''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6g-BeingabletoreadandwriteWKTRasterwithGDALdriver. specifications])|| ||- 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|| == Milestones for Beta 0.2.4 == ||'''Objectives and Tasks'''||'''Coder'''||'''Approx. Schedule'''||'''Time'''||'''Fund (US$)'''||'''Status'''|| ||[[BR]]'''Objective 0.2.4a - Being able to register TIFF and JPEG tiles as raster stored outside the database.''' ([wiki:WKTRaster/SpecificationWorking02#ObjectiveB02a-BeingabletoregisterTIFFandJPEGtilesasrasterstoredoutsidethedatabase. specifications])|| ||Mostly changes to raster2pgsql.exe and ST_RasterFromText().[[BR]]- ST_GetPath() -> string[[BR]]- ST_SetPath(string)||TBD||November 2010||2 weeks||2400||todo|| ||[[BR]]'''Objective 0.2.4b - Being able to import JPEG rasters using raster2pgsql.exe.''' ([wiki:WKTRaster/SpecificationWorking02#ObjectiveB02b-BeingabletoimportJPEGrastersusingraster2pgsql.exe. specifications])|| ||Mostly changes to raster2pgsql.exe||TBD||November 2010||1 week||1200||todo|| ||[[BR]]'''Objective 0.2.4c - Being able to intersect vector and raster to produce raster.''' ([wiki:WKTRaster/SpecificationWorking02#ObjectiveB02c-Beingabletointersectvectorandrastertoproduceraster. specifications])|| ||- ST_AsRaster(geometry, pixelsize) -> raster[[BR]]- Changes to ST_Intersection||TBD||November 2010||4 weeks||4800||todo|| ||[[BR]]'''Objective 0.2.4d - Being able to use "group by" to accumulate tiles to form a new raster.''' ([wiki:WKTRaster/SpecificationWorking02#ObjectiveB02d-Beingabletousegroupbytoaccumulatetilestoformanewraster. specifications])|| ||- ST_Union(raster|geometry, raster|geometry, ‘raster’|’geometry’) -> raster/geometry[[BR]]- ST_Accum(raster set|geometry set, ‘raster’|’geometry’) -> raster/geometry||TBD||November 2010||2 weeks||2400||todo|| == Other Important Milestones == ||'''Objectives and Tasks'''||'''Coder'''||'''Approx. Schedule'''||'''Time'''||'''Fund (US$)'''||'''Status'''|| ||[[BR]]'''Objective B03a - Being able to set all the properties of a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])|| ||- ST_SetSRID(raster|geometry, integer)[[BR]]- ST_SetPixelType(raster, band, string)[[BR]]- ST_SetPixelSize(raster)[[BR]]- ST_SetNoDataValue(raster, band, value)[[BR]]- ST_SetGeoReference(raster, string)||TBD||||1 week||1200||todo|| ||[[BR]]'''Objective B03b - Being able to reproject a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])|| ||- ST_Transform(raster|geometry, SRID) -> same type as input||TBD||||1 week||1200||todo|| ||[[BR]]'''Objective B03c - Being able todo some base raster operations.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])|| ||- ST_Area(raster|geometry) -> double[[BR]]- ST_Count(raster, value) -> integer[[BR]]- ST_Resample(raster, pixelsize, method) -> raster[[BR]]- ST_SelectByValue(raster|geometry, ‘expression’) -> same type as first argument[[BR]]- ST_Reclass(raster|geometry,string) -> same type as first argument[[BR]]- ST_MapAlgebra(raster|geometry, [raster|geometry,...], ‘mathematical expression’, ‘raster’ |’geometry’) -> raster/geometry[[BR]]- ST_Clip(raster|geometry,geometry) -> same type as first argument[[BR]]- ST_Flip(raster|geometry, ’vertical’|’horizontal’) -> same type as first argument||TBD||||6 weeks||7200||todo|| ||[[BR]]'''Objective B04a - Being able to convert a raster to standards formats.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])|| ||- ST_AsKML(raster|geometry) -> string[[BR]]- ST_AsSVG(raster|geometry) -> string||TBD||||2 weeks||2400||todo|| ||[[BR]]'''Objective B04b - Being able to control the validity of a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])|| ||- ST_IsEmpty(raster|geometry) -> boolean[[BR]]- ST_mem_size(raster|geometry) -> integer[[BR]]- ST_isvalid(raster|geometry) -> boolean||TBD||||1 week||1200||todo|| ||[[BR]]'''Objective B04c - Being able to use other major topological operators.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])|| ||- ST_Within(raster|geometry A, raster|geometry B)[[BR]]- ST_Contains(raster|geometry A, raster|geometry B)[[BR]]- ST_Overlaps(raster|geometry, raster|geometry)||TBD||||1 week||1200||todo|| ||[[BR]]'''Objective B05a - Being able to derive a raster layer from vector layer.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])|| ||- ST_Interpolate(points, pixelsize, method) -> raster||TBD||||1 week||1200||todo|| ||[[BR]]'''Objective B05b - Being able todo on rasters most operations available on geometries.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])|| ||- ST_Centroid(raster|geometry) -> point geometry[[BR]]- ST_PointOnSurface(raster|geometry) -> point geometry[[BR]]- ST_Buffer(raster|geometry, double) -> same type as first arg.[[BR]]- ST_ConvexHull(raster|geometry) -> same type as input[[BR]]- ST_Difference(raster|geometry A, raster|geometry B) -> same type as first argument[[BR]]- ST_SymDifference(raster|geometry,raster|geometry,‘raster’|’geometry’) -> raster/geometry||TBD||||4 weeks||4800||todo|| ||[[BR]]'''Objective B06a - Being able to use all the other topological operators.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])|| ||- ST_Equals(raster|geometry, raster|geometry)[[BR]]- ST_Disjoint(raster|geometry, raster|geometry)[[BR]]- ST_Touches(raster|geometry, raster|geometry)[[BR]]- ST_Crosses(raster|geometry, raster|geometry)[[BR]]- ST_Covers(raster|geometry A, raster|geometry B)[[BR]]- ST_IsCoveredBy(raster|geometry A, raster|geometry B)[[BR]]- ST_Relate(raster|geometry, raster|geometry, intersectionPatternMatrix )||TBD||||2 weeks||2400||todo|| ||[[BR]]'''Objective B07b - Being able to edit a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])|| ||- 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|| ||Other functions[[BR]]- ST_AsBinary(raster, compression)[[BR]]- ST_RasterFromWKB(raster, [])[[BR]]- ST_RasterFromText(string, [])[[BR]]- ST_AsText(raster)|| ML (start ST_AsBinary) || Aug 2009||2 weeks||2400 / !DevTime from MD||in-progress|| ||'''Total'''||||||48 weeks||58800||||