Skip to content
Naveen Panwar edited this page Jun 7, 2014 · 8 revisions

Weekly Report (1st June to 7th June) -


Aim - Prepare the technical design pipeline for PostGIS view module.

Things, I have done this week

  • Understood the current implementation of geometric field display in Cartaro.
    • Available pipeline -
      1. PostGIS (To store the raw geometric data)
      2. Geo-Server (To prepare geometric layer[WMS])
      3. OpenLayers (To display WMS layer)
    • Proposed pipeline -
      1. PostGIS
      2. View Module - Build the spatial query, execute the query, get the data and pass it to OpenLayers using handler.
      3. OpenLayers

Technical Design for Module (folder structure and class description) -

  • postgis/ -

    • postgis.openlayers.inc - Provides hooks for integration with OpenLayers.
  • postgis/views/ -

    • postgis.views.inc - Hooks for views integration. A class that contain all of the data to generate a view, plus the member functions to build the view query, execute the query and render the output.
    • postgis_views_handler_filter_geometry.inc - Provide filter for geo-spatial data.
  • postgis/views/handlers/ -

    • Implement all handlers which are needed. like: sort, field, argument proximity, filter etc.
  • Available filter -

    • 'ST_Contains', 'ST_Intersects', 'ST_Disjoint'
  • Plugin -

    • /plugins/geoserver/layer_types/geoserver_layer_type_postgis_field.inc - GeoServer layer type for PostGIS fields. [Contain select query]

Things to do next week

  • Working on relationship plugin.
  • Understand how exactly view module query on Postgres DB and pass the result to OpenLayers.

Reference Modules/Files -

Am I blocked on anything ?

No