Hi People,
Just wondering if Geoserver can open Google docs spreadsheet on Geoserver. Say for example if you edit the tabular data on Google doc spread sheet the attribute data will also change on Geoserver.
Cheers
Currently no.
Google Fusion tables probably make more sense than straight google doc spreadsheet, as they have spatial types and I don’t believe spreadsheets do. But I guess you could do like x,y in a spreadsheet. Or if we had cool joining capabilities it’d be possible.
But we don’t even have Google Fusion table support yet. So probably pretty far away from being able to meet your needs, but an interesting thought.
Chris
On Thu, Jan 5, 2012 at 10:13 PM, Nomeneta Saili <nome.saili@anonymised.com> wrote:
Hi People,
Just wondering if Geoserver can open Google docs spreadsheet on Geoserver. Say for example if you edit the tabular data on Google doc spread sheet the attribute data will also change on Geoserver.
Cheers
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don’t need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Hi Chris,
Thanks for the info. Yes i just went through fusion tables and they are very cool. Would be a great candidate to be included into Geoserver as another data source if possible.
The great thing with google docs is that anyone can access use and change them. It is much easier for those without any GIS/IT software experience to enter data even if its its just for data entry. If they are linked dynamically with Geoserver that would be great.
Imagine a natural disaster and hundreds of users are entering damage data report from the field on fusion tables and translated in real time on geoserver for access by decision makers/ emergency response agency using QGIS or Openlayers as client.
I know ushahidi does this but i rather like the openness and flexibility of Geoserver from a mapserver perspective as i am able to add any data we have on it that is not available on others.
Just an idea.
Regards,
Nome
Currently no.
Google Fusion tables probably make more sense than straight google doc spreadsheet, as they have spatial types and I don’t believe spreadsheets do. But I guess you could do like x,y in a spreadsheet. Or if we had cool joining capabilities it’d be possible.
But we don’t even have Google Fusion table support yet. So probably pretty far away from being able to meet your needs, but an interesting thought.
Chris
On Thu, Jan 5, 2012 at 10:13 PM, Nomeneta Saili <nome.saili@anonymised.com> wrote:
Hi People,
Just wondering if Geoserver can open Google docs spreadsheet on Geoserver. Say for example if you edit the tabular data on Google doc spread sheet the attribute data will also change on Geoserver.
Cheers
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don’t need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
Nomeneta Saili
MIS/GIS Ofiicer
EPC Vaitele
MOB : 7565412
DD : 65504/65507
Hello,
Next release of GDAL will have a Google Fusion Table driver. As GeoServer use
OGR for vector layer input, it could be possible to use this kind of data
source (see http://www.gdal.org/ogr/drv_gft.html).
Chris, Andrea, am I wrong?
Y.
Le vendredi 06 janvier 2012 05:45:22, Nomeneta Saili a écrit :
Hi Chris,
Thanks for the info. Yes i just went through fusion tables and they are
very cool. Would be a great candidate to be included into Geoserver as
another data source if possible.The great thing with google docs is that anyone can access use and change
them. It is much easier for those without any GIS/IT software experience to
enter data even if its its just for data entry. If they are linked
dynamically with Geoserver that would be great.Imagine a natural disaster and hundreds of users are entering damage data
report from the field on fusion tables and translated in real time on
geoserver for access by decision makers/ emergency response agency using
QGIS or Openlayers as client.I know ushahidi does this but i rather like the openness and flexibility of
Geoserver from a mapserver perspective as i am able to add any data we have
on it that is not available on others.Just an idea.
Regards,
Nome
> Currently no.
>
> Google Fusion tables probably make more sense than straight google doc
> spreadsheet, as they have spatial types and I don't believe spreadsheets
> do. But I guess you could do like x,y in a spreadsheet. Or if we had
> cool joining capabilities it'd be possible.
>
> But we don't even have Google Fusion table support yet. So probably
> pretty far away from being able to meet your needs, but an interesting
> thought.
>
> Chris
>
> On Thu, Jan 5, 2012 at 10:13 PM, Nomeneta Saili
<nome.saili@anonymised.com>wrote:
>> Hi People,
>>
>> Just wondering if Geoserver can open Google docs spreadsheet on
>> Geoserver. Say for example if you edit the tabular data on Google doc
>> spread sheet the attribute data will also change on Geoserver.
>>
>> Cheers
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------
>> ------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a
>> complex infrastructure or vast IT resources to deliver seamless, secure
>> access to virtual desktops. With this all-in-one solution, easily
>> deploy virtual desktops for less than the cost of PCs and save 60% on
>> VDI infrastructure costs. Try it free!
>> http://p.sf.net/sfu/Citrix-VDIinabox
>> _______________________________________________
>> Geoserver-users mailing list
>> Geoserver-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Responsable Formation et Support
Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac, Cedex
Tel (France) : +33 4 79 26 57 98
Tel (Suisse) : +41 21 619 1031
Mob. : +33 6 18 75 42 21
Fax : 04 79 70 15 81
Mail : yves.jacolin@anonymised.com
http://www.camptocamp.com
On Fri, Jan 6, 2012 at 9:17 AM, Yves Jacolin <yves.jacolin@…1104…> wrote:
Hello,
Next release of GDAL will have a Google Fusion Table driver. As GeoServer use
OGR for vector layer input, it could be possible to use this kind of data
source (see http://www.gdal.org/ogr/drv_gft.html).
GeoServer does not have a officially supported OGR data store.
On trunk I’ve made a new version of the OGR data store that has some chance
of getting into supported land, but at the moment it is still problematic,
if you also want to use GDAL based imageio-ext raster data sources,
as the two use two different ways to map to the gdal libraries, imageio-ext
in particular is built against a specific GDAL version, while the approach
I took worked, in my limited testing, across versions (tested whatever comes
with FWTools on Windows and 1.7 and 1.8 on Linux).
They work fine if you use the binaries that come with imagieo-ext, but those
are pretty limited in terms of what vector data sources you get.
Besides working only on trunk, the OGR data store also has other limitations:
- it’s not supported, I’ve made it in my spare time but I have no production
usage for it,so it’s not getting any serious testing - besing a native library, the slightest problem will result in a segfault which
in turn will kill GeoServer, then container, and all other web applications
running in said container. For the GDAL raster data sources published
with imageio-ext we have a good track record, but for the OGR one we
just don’t know - the native libraries have to be built with multithreading support, I don’t
know what’s the situation on the binaries available on the various
platforms nor how reliable multithreading support on the OGR stores is.
Getting a native component to work reliably in a java long lived application
is unfortunately hard, requires testing and dedication, unlike with desktop
applications and CGI scripts it simply cannot fail.
I’ve made the work to make the store available, who is willing to do the
hard testing? 
Cheers
Andrea
–
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 339 8844549
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
On Fri, Jan 6, 2012 at 5:45 AM, Nomeneta Saili <nome.saili@anonymised.com4…> wrote:
Hi Chris,
Thanks for the info. Yes i just went through fusion tables and they are very cool. Would be a great candidate to be included into Geoserver as another data source if possible.
The great thing with google docs is that anyone can access use and change them. It is much easier for those without any GIS/IT software experience to enter data even if its its just for data entry. If they are linked dynamically with Geoserver that would be great.
Imagine a natural disaster and hundreds of users are entering damage data report from the field on fusion tables and translated in real time on geoserver for access by decision makers/ emergency response agency using QGIS or Openlayers as client.
I know ushahidi does this but i rather like the openness and flexibility of Geoserver from a mapserver perspective as i am able to add any data we have on it that is not available on others.
Implementing support for google documents might not be too hard, if someone starts by using
the excel data store that Ian made in unsupported land of GeoTools (unsupported, yes, but
being pure java is going to be safer than a native one).
The google documents expose a network api that allows to export a spreadsheet in
excel format. So a store could be created that connects to a certain google spreadsheet,
downloads it in excel format and stores it in a temporary location, and delegate actual
data access to the excel store. The wrapping store would have to periodically check
if the google spreadsheet has been modified, and if so, download it again.
Just some ideas in case someone wants to take a stab at implementing it
Cheers
Andrea
–
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 339 8844549
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf