[SoC] GSOC Weekly Report #9 - PostGIS View Module for Cartaro
Naveen Panwar
panwarnaveen9 at gmail.com
Sat Jul 19 03:51:45 PDT 2014
Hello,
Please find the GSOC week #9 report as follow.
Report URL -
https://github.com/panwarnaveen9/View-Module-for-Cartaro-GSOC2014/wiki/Code-Week-%239
*Weekly Report (13th July to 19th July) -*
*Aim* - Implement the spatial filter functions for the module.
*Things, I have done this week*
-
Changed the input WKT data to geometry_A in operation function.
$geometry_where = "$operation(st_setsrid(:wkt,4326),
$table_name.$field_name)";
-
Added a complex where clause to the query.
$this->query->add_where_expression($this->options['group'],
$geometry_where, $args = array(':wkt' => $geometry_B_wkt_data) );
- Completed the query function, also successfully tested it for
ST_Contains.
- Removed unnecessary lines from the code.
*Cautions*
- We need to set the SRID as 4326 for input WKT geometry.
*Mentor Suggestions*
- Use psql or pgadmin to have a look at the cartaro database and find
out how the postgis field tables are structured and named.
- Turn on the "Show the SQL query" setting under Structure > Views >
Settings.
*Things to do next week*
- Test the query function for the remaining operations like:
ST_Intersects, ST_Covers etc..
- Define the function "check_wkt_data()", as a part of error handling.
*Reference Modules/Files* -
- postgis_views_handler_filter_geometry.inc
<https://github.com/panwarnaveen9/View-Module-for-Cartaro-GSOC2014/blob/20964232f29365a6ff28f54c11b09244936f9eec/cartaro/profiles/cartaro/modules/contrib/postgis/views/postgis_views_handler_filter_geometry.inc>
*Am I blocked on anything ?*
No.
--
Regards,
*Naveen Panwar*
IIIT-Hyderabad, India.
+91-9030736015
http://lsi.iiit.ac.in/naveen.panwar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/soc/attachments/20140719/bdc99b5f/attachment.html>
More information about the SoC
mailing list