Changes between Version 85 and Version 86 of WKTRaster/PlanningAndFunding


Ignore:
Timestamp:
Jul 29, 2010, 7:05:16 AM (14 years ago)
Author:
pracine
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • WKTRaster/PlanningAndFunding

    v85 v86  
    8181
    8282||'''Objectives and Tasks'''||'''Coder'''||'''Approx. Schedule'''||'''Time'''||'''Fund (US$)'''||'''Status'''||
    83 ||[[BR]]'''Objective 0.1.6a - Being able to create tables with RASTER fields'''||
     83||[[BR]]'''Objective 0.1.6a - Being able to create tables with RASTER fields'''||||||||||
    8484||Initial setup: type definition, canonical input/output||SS||January 2009||4 weeks||2400 by SC[[BR]]2600 by MD||done
    85 ||[[BR]]'''Objective 0.1.6b - Being able to select RASTER values based on bbox spatial relation'''
     85||[[BR]]'''Objective 0.1.6b - Being able to select RASTER values based on bbox spatial relation'''||||||||||
    8686||[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
    8787||GiST indexing support||PR||February 2009||1 week||1200 by SC||done
    88 ||[[BR]]'''Objective 0.1.6c - Being able to load raster in the database''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6c-Beingabletoloadrastersinthedatabase specifications])
     88||[[BR]]'''Objective 0.1.6c - Being able to load raster in the database''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6c-Beingabletoloadrastersinthedatabase specifications])||||||||||
    8989||gdal2wktraster.py as a prototype of raster2pgsql.exe based on [http://www.gdal.org/ GDAL]||ML||February 2009||1 week||!DevTime from MD||done
    9090||raster2pgsql.exe[[BR]](tiff only, only one band, option for tiling)||TBD||||4 weeks||4800||todo
    91 ||[[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])||
     91||[[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])||||||||||
    9292||- 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||
    93 ||[[BR]]'''Objective 0.1.6e - Being able to intersect vector and raster to produce vector. ''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6e-Beingabletointersectvectorandrastertoproducevector. specifications])||
     93||[[BR]]'''Objective 0.1.6e - Being able to intersect vector and raster to produce vector. ''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6e-Beingabletointersectvectorandrastertoproducevector. specifications])||||||||||
    9494||- 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||TBD||4800 by SC / !DevTime from JA ||in-progress||
    95 ||[[BR]]'''Objective 0.1.6f - Being able to return a JPEG, a TIFF or a PNG.''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6f-BeingabletoreturnaJPEGaTIFForaPNG. specifications])||
     95||[[BR]]'''Objective 0.1.6f - Being able to return a JPEG, a TIFF or a PNG.''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6f-BeingabletoreturnaJPEGaTIFForaPNG. specifications])||||||||||
    9696||- 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||TBD||2400 / !DevTime from ML||todo||
    97 ||[[BR]]'''Objective 0.1.6g - Being able to read and write WKT Raster with GDAL driver. ''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6g-BeingabletoreadandwriteWKTRasterwithGDALdriver. specifications])||
     97||[[BR]]'''Objective 0.1.6g - Being able to read and write WKT Raster with GDAL driver. ''' ([wiki:WKTRaster/SpecificationWorking01#Objective0.1.6g-BeingabletoreadandwriteWKTRasterwithGDALdriver. specifications])||||||||||
    9898||- 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||TBD||!DevTime from JA ||in-progress||
    99 ||[[BR]]'''Objective 0.1.6h - Being able to set all the properties of a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||
     99||[[BR]]'''Objective 0.1.6h - Being able to set all the properties of a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||||||||||
    100100||- 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_Rotation(raster)[[BR]]- ST_SetRotation(raster, rotation)[[BR]]- ST_SetUpperLeft(raster, x, y)||dzwarg||||1 week||Devtime from DZ||in-progress||
    101101
    … …  
    106106||'''Objectives and Tasks'''||'''Coder'''||'''Approx. Schedule'''||'''Time'''||'''Fund (US$)'''||'''Status'''||
    107107
    108 ||[[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])||
     108||[[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])||||||||||
    109109||Mostly changes to raster2pgsql.exe and ST_RasterFromText().[[BR]]- ST_BandPath() -> string[[BR]]- ST_SetPath(string)||TBD||November 2010||2 weeks||2400||todo||
    110 ||[[BR]]'''Objective 0.2.4b - Being able to import JPEG rasters using raster2pgsql.exe.''' ([wiki:WKTRaster/SpecificationWorking02#ObjectiveB02b-BeingabletoimportJPEGrastersusingraster2pgsql.exe. specifications])||
     110||[[BR]]'''Objective 0.2.4b - Being able to import JPEG rasters using raster2pgsql.exe.''' ([wiki:WKTRaster/SpecificationWorking02#ObjectiveB02b-BeingabletoimportJPEGrastersusingraster2pgsql.exe. specifications])||||||||||
    111111||Mostly changes to raster2pgsql.exe||TBD||November 2010||1 week||1200||todo||
    112 ||[[BR]]'''Objective 0.2.4c - Being able to intersect vector and raster to produce raster.''' ([wiki:WKTRaster/SpecificationWorking02#ObjectiveB02c-Beingabletointersectvectorandrastertoproduceraster. specifications])||
     112||[[BR]]'''Objective 0.2.4c - Being able to intersect vector and raster to produce raster.''' ([wiki:WKTRaster/SpecificationWorking02#ObjectiveB02c-Beingabletointersectvectorandrastertoproduceraster. specifications])||||||||||
    113113||- ST_AsRaster(geometry, pixelsize) -> raster[[BR]]- Changes to ST_Intersection||TBD||November 2010||4 weeks||4800||todo||
    114 ||[[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])||
     114||[[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])||||||||||
    115115||- 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||
    116116
    … …  
    120120||'''Objectives and Tasks'''||'''Coder'''||'''Approx. Schedule'''||'''Time'''||'''Fund (US$)'''||'''Status'''||
    121121
    122 ||[[BR]]'''Objective B03b - Being able to reproject a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||
     122||[[BR]]'''Objective B03b - Being able to reproject a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||||||||||
    123123||- ST_Transform(raster|geometry, SRID) -> same type as input||TBD||||1 week||1200||todo||
    124 ||[[BR]]'''Objective B03c - Being able todo some base raster operations.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||
     124||[[BR]]'''Objective B03c - Being able todo some base raster operations.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||||||||||
    125125||- 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||
    126 ||[[BR]]'''Objective B04a - Being able to convert a raster to standards formats.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||
     126||[[BR]]'''Objective B04a - Being able to convert a raster to standards formats.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||||||||||
    127127||- ST_AsKML(raster|geometry) -> string[[BR]]- ST_AsSVG(raster|geometry) -> string||TBD||||2 weeks||2400||todo||
    128 ||[[BR]]'''Objective B04b - Being able to control the validity of a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||
     128||[[BR]]'''Objective B04b - Being able to control the validity of a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||||||||||
    129129||- ST_IsEmpty(raster|geometry) -> boolean[[BR]]- ST_mem_size(raster|geometry) -> integer[[BR]]- ST_isvalid(raster|geometry) -> boolean||TBD||||1 week||1200||todo||
    130 ||[[BR]]'''Objective B04c - Being able to use other major topological operators.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||
     130||[[BR]]'''Objective B04c - Being able to use other major topological operators.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||||||||||
    131131||- 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||
    132 ||[[BR]]'''Objective B05a - Being able to derive a raster layer from vector layer.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||
     132||[[BR]]'''Objective B05a - Being able to derive a raster layer from vector layer.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||||||||||
    133133||- ST_Interpolate(points, pixelsize, method) -> raster||TBD||||1 week||1200||todo||
    134 ||[[BR]]'''Objective B05b - Being able todo on rasters most operations available on geometries.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||
     134||[[BR]]'''Objective B05b - Being able todo on rasters most operations available on geometries.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||||||||||
    135135||- 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||
    136 ||[[BR]]'''Objective B06a - Being able to use all the other topological operators.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||
     136||[[BR]]'''Objective B06a - Being able to use all the other topological operators.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||||||||||
    137137||- 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||
    138 ||[[BR]]'''Objective B07b - Being able to edit a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||
     138||[[BR]]'''Objective B07b - Being able to edit a raster.''' ([wiki:WKTRaster/SpecificationWorking03 specifications])||||||||||
    139139||- 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||
    140140||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||