[Geoserver-users] creating data for overlay in google earth

Hi there,

I got GeoServer running now and I can also see the overlay in Google Earth as shown in the video tutorial http://geoserver.codehaus.org/tutorials/videos/google_earth/google_earth.html

I just don't know, how I could create my own data for a overlay in Google Earth?
In Google Earth I can add placemarks and paste html-code in the description with links to different files that are located on a network drive. That would be my data, but I would not have the possibility to add attributes like date or version of the files and then filter, which would be necessary once there are many different placemarks in that small area.
But in GeoServer I do not know how to create data. Is there a way I could put those files into a table with different columns like coordinates, name, date, version, html-code and then have it transferred into a gml or kml-file that is suitable for a overlay in Google Earth?

Thanks in advance for any hints on how I could get my data into Google Earth via GeoServer..

newbie

older requests from me (reading this may be useful if you want to understand, what i have in mind):

" Thank you David for your reply!
Can you tell me what in your opinion would be the easiest way to have the opportunity to display 2D-Plans and 3D-Models in Google Earth together with (filtered) placemarks that contain links to files concerning certain areas or buildings (f.ex. "//intranetserver/subdir/1st floor plan 2005.pdf" - when filtered for year 2005?) ?

I do have plans and 3d-models in kmz-format, but I don't know how I could create the data (placemarks placed on the building plans f.ex.) within uDig (they cannot read KMZ-files, I assume). I would need the building plans from the kmz (I also have JPEGs, but they have no georeference yet) as a layer to add the placemarks at the right position.

I hope you can tell me a workflow that could work for me...

newbie"

************

"Hi everyone,

I'm thinking about using GeoServer in combination with Google Earth for my diploma thesis and wanted to ask you if you could tell me how much time it would approximately take to get it to work for a newbie like me. Or if I'm getting it wrong, then I would be grateful if you could tell me how I could achieve my plan with other tools.
Within my diploma thesis I want to develop some kind of new approach of making data from our intranet/network storage (of certain positions or even 3d-models) available to my colleagues.
To do so I have already tried Google Earth and got some results by using placemarks and adding html with links to the data I want to make available.

The problem is: If I add placemarks within Google Earth, I don't seem to be able to have them sorted/filtered or even search for them in the 'my places'-section. So I came up with the idea of using Geoserver so I would have the opportunity to filter the data I created (like in http://geoserver.org/display/GEOSDOC/3+Google+Earth+customizations#3GoogleEarthcustomizations-section2).
If you think that in my case the use of Geoserver ain't necessary then please tell me how I can add attributes to certain placemarks and filter them search for them in Google Earth. If you think the use of GeoServer would be helpful, then I would need information, how I can create data with the GeoServer (i.e. adding placemarks like in Google Earth).

I hope you can follow my thougths...

Thanks in advance for your replies!

the newbie

----- Original Nachricht ----
Von: David Winslow <dwinslow@anonymised.com>
An: e-mail2008@anonymised.com
Datum: 17.02.2009 04:38
Betreff: Re: [Geoserver-users] GeoServer and Google Earth usage newbie
questions

GeoServer can certainly sort and filter data exported as KML.

With regard to loading your data, you will need to have it in some
format that GeoServer can read. PostGIS and Shapefile are popular
choices. You can create a Shapefile with a desktop GIS application such
as uDig or QGis; PostGIS uses standard SQL syntax to create tables (with
a little extra setup; see the PostGIS documentation for details).

You can also create an empty dataset and use OpenLayers with WFS-T to
edit your table through the web; see the OpenLayers examples
(http://openlayers.org/dev/examples/) for more info on that.

Hope this helps,
--
David Winslow
OpenGeo - http://opengeo.org/

Erwischt! Bei Arcor sehen Sie die besten Promi-Bilder riesengroß und in Top-Qualität. Hier finden Sie die schönsten Schnappschüsse auf dem roten Teppich, lernen die Frauen des Womanizers Boris Becker kennen und schauen den Royals ins Wohnzimmer. Viel Spaß auf Ihrer virtuellen Reise durch die Welt der Stars und Sternchen: http://vip.arcor.de.

The Google Earth section on the wiki has tutorials on how to customize
your KML output, including height and time info.

http://geoserver.org/display/GEOSDOC/Google+Earth

Hope this helps.

--
David Winslow
OpenGeo - http://opengeo.org/

On Wed, 2009-02-18 at 11:26 +0100, e-mail2008@anonymised.com wrote:

Hi there,

I got GeoServer running now and I can also see the overlay in Google Earth as shown in the video tutorial http://geoserver.codehaus.org/tutorials/videos/google_earth/google_earth.html

I just don't know, how I could create my own data for a overlay in Google Earth?
In Google Earth I can add placemarks and paste html-code in the description with links to different files that are located on a network drive. That would be my data, but I would not have the possibility to add attributes like date or version of the files and then filter, which would be necessary once there are many different placemarks in that small area.
But in GeoServer I do not know how to create data. Is there a way I could put those files into a table with different columns like coordinates, name, date, version, html-code and then have it transferred into a gml or kml-file that is suitable for a overlay in Google Earth?

Thanks in advance for any hints on how I could get my data into Google Earth via GeoServer..

newbie

older requests from me (reading this may be useful if you want to understand, what i have in mind):

" Thank you David for your reply!
Can you tell me what in your opinion would be the easiest way to have the opportunity to display 2D-Plans and 3D-Models in Google Earth together with (filtered) placemarks that contain links to files concerning certain areas or buildings (f.ex. "//intranetserver/subdir/1st floor plan 2005.pdf" - when filtered for year 2005?) ?

I do have plans and 3d-models in kmz-format, but I don't know how I could create the data (placemarks placed on the building plans f.ex.) within uDig (they cannot read KMZ-files, I assume). I would need the building plans from the kmz (I also have JPEGs, but they have no georeference yet) as a layer to add the placemarks at the right position.

I hope you can tell me a workflow that could work for me...

newbie"

************

"Hi everyone,

I'm thinking about using GeoServer in combination with Google Earth for my diploma thesis and wanted to ask you if you could tell me how much time it would approximately take to get it to work for a newbie like me. Or if I'm getting it wrong, then I would be grateful if you could tell me how I could achieve my plan with other tools.
Within my diploma thesis I want to develop some kind of new approach of making data from our intranet/network storage (of certain positions or even 3d-models) available to my colleagues.
To do so I have already tried Google Earth and got some results by using placemarks and adding html with links to the data I want to make available.

The problem is: If I add placemarks within Google Earth, I don't seem to be able to have them sorted/filtered or even search for them in the 'my places'-section. So I came up with the idea of using Geoserver so I would have the opportunity to filter the data I created (like in http://geoserver.org/display/GEOSDOC/3+Google+Earth+customizations#3GoogleEarthcustomizations-section2).
If you think that in my case the use of Geoserver ain't necessary then please tell me how I can add attributes to certain placemarks and filter them search for them in Google Earth. If you think the use of GeoServer would be helpful, then I would need information, how I can create data with the GeoServer (i.e. adding placemarks like in Google Earth).

I hope you can follow my thougths...

Thanks in advance for your replies!

the newbie

----- Original Nachricht ----
Von: David Winslow <dwinslow@anonymised.com>
An: e-mail2008@anonymised.com
Datum: 17.02.2009 04:38
Betreff: Re: [Geoserver-users] GeoServer and Google Earth usage newbie
questions

>
> GeoServer can certainly sort and filter data exported as KML.
>
> With regard to loading your data, you will need to have it in some
> format that GeoServer can read. PostGIS and Shapefile are popular
> choices. You can create a Shapefile with a desktop GIS application such
> as uDig or QGis; PostGIS uses standard SQL syntax to create tables (with
> a little extra setup; see the PostGIS documentation for details).
>
> You can also create an empty dataset and use OpenLayers with WFS-T to
> edit your table through the web; see the OpenLayers examples
> (http://openlayers.org/dev/examples/) for more info on that.
>
> Hope this helps,
> --
> David Winslow
> OpenGeo - http://opengeo.org/

Erwischt! Bei Arcor sehen Sie die besten Promi-Bilder riesengroß und in Top-Qualität. Hier finden Sie die schönsten Schnappschüsse auf dem roten Teppich, lernen die Frauen des Womanizers Boris Becker kennen und schauen den Royals ins Wohnzimmer. Viel Spaß auf Ihrer virtuellen Reise durch die Welt der Stars und Sternchen: http://vip.arcor.de.

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users