Hi Jose
I once wrote a spatialite outputformat for Geoserver. It does not use any spatialite stuff and uses only org.sqlite.jdbc. It’s like dumping the features into an empty sqlite database.
You can find the sources here:
http://code.google.com/p/cataisrepository/source/browse/#svn%2Ftrunk%2Fgeoserver%2Foutputformats%2Fspatialite%253Fstate%253Dclosed
Test request:
http://www.catais.org/geoserver/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=mo:gemeinden_so&maxFeatures=200&outputformat=spatialite
regards
Stefan
-----Ursprüngliche Nachricht-----
Von: Jose Macchi [mailto:jmacchi@anonymised.com]
Gesendet am: Montag, 16. Mai 2011 05:00
Cc: geoserver-devel@lists.sourceforge.net
Betreff: Re: [Geoserver-devel] community module request
Hi Gabriel,
Right now, we are on resources assignation and schedule.
I receipt some more instructions/comments from Chris and Justin about this issue and so we are ordering tasks/validations we should meet.
For now, there is no prototype.
I will let you know as soon as we have something
Regards
Jose
Gabriel Roldán escribió:
Hi Jose,
glad to hear from you.
The proposed work certainly looks interesting, and I'm +1 on a community
module for it.
Question is: what stage is the work at? from what you say it looks like
it's still on the "planning" stage? or is there some development already
as a prototype?
So I'm +1 with a little concern to bring to the PSC with regard to the
proliferation of community modules that I'll bring up on a separate
message.
Best regards,
Gabriel
On Fri, 2011-05-13 at 13:32 -0300, Jose Macchi wrote:
Hello, I'm Jose from geotekne.com. Currently we are partners of OpenGeo,
and we would like to contribute at Geoserver with a new community
module, so as we understand, we should ask for permission on devlist.
The objective will be to get SQLite/SpatiaLite as a WFS output format
for GeoServer.
See [http://docs.geoserver.org/stable/en/user/services/wfs/outputformats.html](http://docs.geoserver.org/stable/en/user/services/wfs/outputformats.html)
The first part of this will involve cleaning up and testing GeoTools
with SpatiaLite on a variety of platforms. The datastore is at
[http://svn.osgeo.org/geotools/trunk/modules/plugin/jdbc/jdbc-spatialite/](http://svn.osgeo.org/geotools/trunk/modules/plugin/jdbc/jdbc-spatialite/)
We should test it on 32-bit and 64-bit Linux, OS X and Windows.
Then we expect to make an output format for GeoServer WFS. It should
produce a full SQLite / Spatialite single file database. Done properly
it should construct itself according to whatever WFS parameters are
passed in, so could be multiple featureTypes, with different properties,
of certain areas or attributes.
Let us know if it's ok, and if it's necesary to consider some other
information/request on same "scope".
We would like your approval, and then....permissions to commit on
community folder at svn
Regards
Jose
------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
[http://p.sf.net/sfu/intel-dev2devmay](http://p.sf.net/sfu/intel-dev2devmay)
_______________________________________________
Geoserver-devel mailing list
[Geoserver-devel@lists.sourceforge.net](mailto:Geoserver-devel@anonymised.comurceforge.net)
[https://lists.sourceforge.net/lists/listinfo/geoserver-devel](https://lists.sourceforge.net/lists/listinfo/geoserver-devel)
Ah cool. Would you be willing for us to put that in to a GeoServer community module? Or to help you get it in? So we can eventually migrate it to an extension and have it as a core part of the code?
Looks like it’s GPL licensed which is fine, but we will need a contributor’s agreement to get it in to more core GeoServer. I can point you in the right direction if you’re able to contribute.
best regards,
Chris
On Mon, May 16, 2011 at 3:58 AM, Ziegler Stefan <Stefan.Ziegler@anonymised.com> wrote:
Hi Jose
I once wrote a spatialite outputformat for Geoserver. It does not use any spatialite stuff and uses only org.sqlite.jdbc. It’s like dumping the features into an empty sqlite database.
You can find the sources here:
http://code.google.com/p/cataisrepository/source/browse/#svn%2Ftrunk%2Fgeoserver%2Foutputformats%2Fspatialite%253Fstate%253Dclosed
Test request:
http://www.catais.org/geoserver/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=mo:gemeinden_so&maxFeatures=200&outputformat=spatialite
regards
Stefan
-----Ursprüngliche Nachricht-----
Von: Jose Macchi [mailto:jmacchi@anonymised.com…2730…]
Gesendet am: Montag, 16. Mai 2011 05:00
Cc: geoserver-devel@lists.sourceforge.net
Betreff: Re: [Geoserver-devel] community module request
Hi Gabriel,
Right now, we are on resources assignation and schedule.
I receipt some more instructions/comments from Chris and Justin about this issue and so we are ordering tasks/validations we should meet.
For now, there is no prototype.
I will let you know as soon as we have something
Regards
Jose
Gabriel Roldán escribió:
Hi Jose,
glad to hear from you.
The proposed work certainly looks interesting, and I'm +1 on a community
module for it.
Question is: what stage is the work at? from what you say it looks like
it's still on the "planning" stage? or is there some development already
as a prototype?
So I'm +1 with a little concern to bring to the PSC with regard to the
proliferation of community modules that I'll bring up on a separate
message.
Best regards,
Gabriel
On Fri, 2011-05-13 at 13:32 -0300, Jose Macchi wrote:
Hello, I'm Jose from [geotekne.com](http://geotekne.com). Currently we are partners of OpenGeo,
and we would like to contribute at Geoserver with a new community
module, so as we understand, we should ask for permission on devlist.
The objective will be to get SQLite/SpatiaLite as a WFS output format
for GeoServer.
See [http://docs.geoserver.org/stable/en/user/services/wfs/outputformats.html](http://docs.geoserver.org/stable/en/user/services/wfs/outputformats.html)
The first part of this will involve cleaning up and testing GeoTools
with SpatiaLite on a variety of platforms. The datastore is at
[http://svn.osgeo.org/geotools/trunk/modules/plugin/jdbc/jdbc-spatialite/](http://svn.osgeo.org/geotools/trunk/modules/plugin/jdbc/jdbc-spatialite/)
We should test it on 32-bit and 64-bit Linux, OS X and Windows.
Then we expect to make an output format for GeoServer WFS. It should
produce a full SQLite / Spatialite single file database. Done properly
it should construct itself according to whatever WFS parameters are
passed in, so could be multiple featureTypes, with different properties,
of certain areas or attributes.
Let us know if it's ok, and if it's necesary to consider some other
information/request on same "scope".
We would like your approval, and then....permissions to commit on
community folder at svn
Regards
Jose
------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
[http://p.sf.net/sfu/intel-dev2devmay](http://p.sf.net/sfu/intel-dev2devmay)
_______________________________________________
Geoserver-devel mailing list
[Geoserver-devel@lists.sourceforge.net](mailto:Geoserver-devel@lists.sourceforge.net)
[https://lists.sourceforge.net/lists/listinfo/geoserver-devel](https://lists.sourceforge.net/lists/listinfo/geoserver-devel)
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
Geoserver-devel mailing list
Geoserver-devel@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel