= Sprint 2009 Notes = = General Actions = == Attending == * RO: Regina Obe * PR: Paul Ramsey * MCA: Mark Cave Ayland * OC: Olivier Courtin == PSC == * RO - formalize PSC membership rules and desires, talk w/ RRI about PSC = PostGIS 2.0 Goals = == Geodetic Support == * PG_LWGEOG * Backed into LWGEOM * Alter LWGEOM to add "geographic bit" * write menu of functions of things we need to do * spherical indexing (q3c) * PR - research and give recommendation on indexes * PR - recommendation on serialization changes * PR - RFC on implementation == !TypeMods to turn GEOMETRY_COLUMNS into a view == * MCA - build prototype and see? * MCA - RFC on typmod for 2.0 == Routing in the Database == * embed graphserver in pgsql * load edges from pgsql tables * float graphserver structures into higher memory context * PR - investigate effort and do RFC == Handling of EMPTY geometries == * Document what LWGEOM conditions constitute "empty" * POINT => pa == NULL * LINE => npoints == 0 * POLYGON => nrings == 0 * COLLECTION => ngeoms == 0 (already handled) MCA - fix unparser to respectfully write those out (all types) == LWGEOM Header == What are our goals for re-writing our serialization? And handling thereof. * Room for more types. * Account for future changes ? (versioning) (PR - No!) * Aligned double? * Prototype vardata type w/ double* and compare speed of direct access w/ copied access for some ops * PR - do performance prototype * PR - finalize RFC for new serialized form == ISO Official Formats == * BREAKING CHANGE: SRID=0 is no-value * "Be liberal in what you accept, conservative in what you emit." * Only emit proper ISO formats * WKB, use the ISO/SFSQL2 type codes * WKT, use the official Z/M modifiers (eg POINT Z (1 2 3), POINT ZM (1 2 3 4)) * What does SFSQL2 say ST_Asbinary should emit? highera dimensionality? (probably) * OC - Handle GeomFromGML() / GeomFromKML() * need estimate / RFC * Will need to link libxml == "Package" infrastructure for PostGIS == * MCA - Bug PgSQL-hackers and establish requirements == Deprecating ST_ handing in Dependent Apps == * PR - Mapserver (change for 5.4?) * Ask if people mind losing support for PostGIS < 1.2 * PR -- Geoserver (change for ??) * PR - FME * PR - !CadCorp == SRTEXT handling == * PR - Formalize our generation of SPATIAL_REF_SYS from EPSG database * PR - Handle SRTEXT erratta from the mailing list so we don't lose projection fixes anymore * PR - embed EPSG database version number in #define at the time we build SPATIAL_REF_SYS.sql == WKT Raster == * By summer, raster/vector intersections() and out-db raster support * Integrate with PostGIS 2.0, if PSC determines there is enough functionality to warrant. * Allow binary-only dependency (more generally a PostGIS plan) == Topology support == * OC: based on Sandro previous work and SQL MM 2.0 * concrete needs: simplify working with lat/lon geom and topology compliant * requires: build topology from set of polygons (snap and clean and build) == 3D == * OC - SQL/MM !PolyhedralSurface type * CGAL librairie form intersection stuff ??? * CityGML and Collada export * 3D GIST index support