camptocamp maps open_e_rp.key

Camptocamp / 13. avril 2011 / www.camptocamp.com / info@camptocamp.com

Map integration into OpenERPPartner/community days presentation

History of Maps ModuleCamptocamp expertise in both worlds

Cross business needs

Technical challenge

Why a new moduleBECAUSE WE CAN

Actual tools only provide basic visualizationNothing to address complex GIS business / technical problems

re/projection

cloud/computation

goeindexing

spatial querydata aggregation

simplification

data valorisation

spatial marketing spatial tracking

spatial catalogue

spatial routing

Technologies overview- Postgis http://postgis.refractions.net/

- OpenLayers http://openlayers.org/

- Python geo proxy (maybe ? maybe MapFish)

- OpenERP

Technologies overviewWHY ?Strong and production proofNo Java or any new programming languageGreat GIS features coverage

Full OpenSource

Screencast

http://bit.ly/dWTVAB

Quick lookSwitch to map view

Select layer(s)

View entity datas

On

OFF

Activate

Select layers

Quick lookMeasure tools

Navigation tools

Get Distance

Get Surface

Query Result

Pan

Zoom

Quick look

How does it works

10

OpenE

RP S

erverORM

OSV

GEO ORM

GEO OSV

NETSVC/ETC.

Postgresql

Postgis 1.5.2

Attributs*Geometries

Table

OpenE

RP W

ebClient

CherryPy

OpenERP stuff

map_view addon

OpenLayers

Geojson based protocol(Yet encapsulated in RPC)

Into the code

11

New GeoOSV class

import geo_osvclass PartnerAddress(geo_osv.GeoOsv): _inherits ....

Into the code

12

New GeoOSV class

_georepr = [ { 'geometry': 'the_geom', 'variable': 'partner_id', 'method': 'unique_values', }, { 'geometry': 'the_geom', 'variable': 'total_sales', 'method': 'proportional_symbols', }, ]

Into the code

13

New colum class

'the_geom' : fields.geom('Coordinate')

'the_geom' : fields.geom('Coordinate', geo_type="POINT", #All postgis supported typesdim=2, #2, 3, 4 are possible valuessrid=900913, #Projection of the columnetc.),

TODOORM better Geo operatorSupport related geom fieldsXML/YAML import export supportQuery toolShape edition on mapGeo ref on mapVector simplification based on extendGeo agregationsXML View definitionView style definition

Now everything can be imagined

15

ContactCamptocamp SAPSE A – Parc Scientifique EPFL1015 Lausanne, Suisse

Camptocamp France SASSavoie Technolac48 avenue du Lac du Bourget73372 Le Bourget du Lac, France

www.camptocamp.com

Luc Maurer, Directeur et co-fondateur

Tél : +41 21 619 10 12 (CH), +33 479 44 44 95 (FR)Mobile : +41 79 606 07 73E-mail : luc.maurer@camptocamp.com