python - Publishing geospatial data with Plone -

-

i setting new site on plone using collective.geo.bundle, need make data accessible desktop gis. 2 obvious ways of doing use postgres/postgis database, or publish data through wfs service. problem appears plone stores pickles in database, gis wouldn't able make sense of data, , there doesn't seem addon exposes wfs. 2 questions then:

  1. is there way use configure plone use postgres/postgis database geometry data types, data can read outside plone?

  2. is there way set plone (e.g. through addon) expose wfs?

tl;dr: don't think there out-of-the-box solution (using collective.geo.*) this.

as mentioned in comments, plone doesn't deal geospatial data @ all, it's collective.geo.geographer this. more specifically, it's georeferencingannotator saves coordinates igeoreferenceable objects annotations (and loads them there).

so, forcing plone store content in relational db, example using relstorage wont - plone or relstorage don't know geospatial data, , store annotations other.

however, shouldn't too hard write own iwritegeoreferenced adapter writes georeferencing data postgis database instead of annotations, using uuid of context link data objects, , maybe store additional metadata title or url. georeferencing data separate actual content - there's no need put plone content postgresql db.

a different approach write event handler objectgeoreferencedevent, , publish georeferencing data postgis db (in addition having stored in annotations on actual objects). since want access read-only desktop gis, wouldn't have worry syncing data in both directions.

last not least, suggest have @ collective.geo mailing list - people on there responsive , helpful, , imagine else had same use case.


Comments

Post a Comment

Popular posts from this blog

python - Subclassed QStyledItemDelegate ignores Stylesheet -

-
i'm trying subclass qstyleditemdelegate remove focus rectangle in qcombobox . even though i'm calling base implementation of paint function , nothing else, result different. looks if parts of style-sheet influence bounding box of item taken consideration. class pstyleditemdelegate(qstyleditemdelegate): def __init__(self, *args, **kwds): super(pstyleditemdelegate, self).__init__(*args, **kwds) def paint(self, *args, **kwargs): qstyleditemdelegate.paint(*args, **kwargs) what have paint unmodified qstyleditemdelegate ? as suggested tried replacing pyside pyqt4 , works, appears bug. update pyside 1.1.2 1.2.1 result same. unfortunately switch breaks other parts of code, if there no other suggestions i'm going accept answer. edit bug tracked here
Read more

java - HttpClient 3.1 Connection pooling vs HttpClient 4.3.2 -

-
i have used httpclient3.1(java) connection pooling below : import org.apache.commons.httpclient.httpclient; import org.apache.commons.httpclient.multithreadedhttpconnectionmanager; import org.apache.commons.httpclient.params.httpclientparams; import org.apache.commons.httpclient.params.httpmethodparams; import org.apache.log4j.logger; public class httpclientmanager { private static logger logger = logger.getlogger(httpclientmanager.class); private static multithreadedhttpconnectionmanager connectionmanager = new multithreadedhttpconnectionmanager(); private static httpclientparams clientparams = new httpclientparams(); static { try { clientparams.makelenient(); clientparams.setauthenticationpreemptive(false); clientparams.setparameter(httpmethodparams.so_timeout, new integer(30000)); // set so_timeout clientparams.setparameter(httpmethodparams.head_body_check_timeout, new integer(3000)); // head responses
Read more

SQL: Divide the sum of values in one table with the count of rows in another -

-
is possible to, in single query, sum bunch of values in 1 table, , divide count of rows in another? there common id/key in both tables... fyi, win points least info provided in question. answer it's possible...here psuedo code since i'm guessing @ tables , columns select summing / counting whynot (select id, sum(whatever) summing where_ever ) inner join (select id, count(1) counting what_ever)b on a.id = b.id question = 'vague' group a.id
Read more