Thanks for the info guys. I'm glad it wasn't something simple that I was overlooking. I'm surprised that there aren't more OpenLayers-based apps out there that have a need for layers of text that don't come across as part of the image with the geometric data. It's an absolute necessity for mine.<br>
<br>
It turns out that I have an extra database I need to connect to which
is a proprietary format (no way GeoServer or anything else will connect
to it) so I'm going to need to write a web service to get the data out
of it and into OpenLayers somehow (maybe in GeoJSON format as suggested). Or write an app to automatically transfer it into PostGIS.
<br><br>Andreas, you mentioned that if my data was in PostGIS I could use
either a WMS or WFS to get the data. If I went down the WMS path, I
would have one WMS for my base map layer, and another one for my text
objects layer. My understanding is that the text WMS would return a
tile map of images which would be largely empty space with the
occasional text value here and there. I guess this layer would be
transparent so as not to occlude the underlying map images. Meanwhile,
the WFS would return the details about the text labels and rely on
OpenLayers to actually render the vector representations.
<br><br>You mentioned that WMS would be preferred if there were a 'huge number of features' - I'm surprised that creating all those image tiles on the server side is faster than adding x vector objects on the browser side (I will probably have a few dozen at most). Is there a
certain point where it just makes more sense to do it on the server based on the number of objects you want to display? <br><br>Regards,<br><br>Andrew<br><br><div class="gmail_quote">On Sun, Mar 22, 2009 at 11:08 PM, Chris Holmes <span dir="ltr"><<a href="mailto:cholmes@opengeo.org">cholmes@opengeo.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5"><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Here's what I want to do. I have a GeoServer map server and a PostGIS<br>
database containing my map data. In a completely separate database<br>
(Oracle), I have a table which has a bunch of values that are changing<br>
regularly. Each value has a corresponding lat/lon value. I want to call a<br>
web service from within OpenLayers which requests the text values (and<br>
corresponding coordinates) and then shows them as a layer on the map. As in<br>
I want to see the actual text value on the map, not a marker where the text<br>
should be. I would then periodically redraw the layer to get the updated<br>
values.<br>
<br>
I guess my questions are as follows:<br>
<br>
1. Can you actually add a layer of text objects in OpenLayers? If so, what<br>
layer type do you use? Can anyone point me to a publicly accessible<br>
example?<br>
</blockquote>
<br>
This will be a vector layer then.<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
2. Is my approach reasonable? I could potentially copy the data from the<br>
Oracle database into the PostGIS database if it would make things easier,<br>
but I'm still not sure how to then get the data from PostGIS into my map. I<br>
know that PostGIS has functions like 'AsGML' and 'AsSVG'. However, this<br>
leads me to more questions:<br>
</blockquote>
<br>
Copying the data from Oracle to PostGIS would make things much easier<br>
if you also consider using a WMS like GeoServer or Mapserver. Both can<br>
connect to a PostGIS data store and output your points either as WMS<br>
(map image) or WFS (vector data to be rendered on the client). This is<br>
the state-of-the-art solution, WMS being preferred if you have a huge<br>
number of features.<br>
<br>
</blockquote>
<br></div></div>
Note also that if you can turn your oracle lat/longs in to point objects in Oracle Locator or Oracle spatial than you can serve WMS directly from there with GeoServer or MapServer. Both connect to oracle pretty well. PostGIS is a bit better for both, but GeoServer has a new Oracle NG datastore that is almost as fast.<div>
<div></div><div class="h5"><br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
If, however, you do not want to bother with the conversion of your<br>
data from Oracle to PostGIS and are fine writing a small server side<br>
script to provide your text data, I'd recommend sending GeoJSON to<br>
OpenLayers (but only if the number of labels does not reach into three<br>
figures):<br>
<br>
{<br>
"type": "FeatureCollection",<br>
"features": [<br>
{"type":"Feature", "id":"ft_1721", "properties":{"label":<br>
"foo"}, "geometry":{"type":"Point", "coordinates":[-89.296875,<br>
-14.4140625]}, "crs":{"type":"OGC",<br>
"properties":{"urn":"urn:ogc:def:crs:OGC:1.3:CRS84"}}}<br>
]<br>
}<br>
<br>
You will be able to style this in a way that just the label and not<br>
the point is shown. As you can see, you have a point feature here with<br>
a label attribute. All you need to render in OpenLayers (see my<br>
explanation on GML below, which uses the same concept).<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
- I know that SVG supports text objects but don't know if OpenLayers can<br>
overlay SVG objects on maps. Is SVG even a viable option?<br>
</blockquote>
<br>
SVG is the technology used in OpenLayers to render vector layers<br>
(including text once this feature is ready) in all browsers except<br>
Internet Explorer. But I would not recommend sending SVG output to the<br>
client, since OpenLayers is not designed to display third-party SVG.<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
- I know next to nothing about GML. My quick Googling tells me that GML has<br>
things like LineString, Polygon and Point, but I haven't found anything like<br>
a 'Text' element. Is GML just for displaying vector shape objects?<br>
</blockquote>
<br>
GML works with features. Features have a geometry and other<br>
attributes. To display text, you will want features with a point<br>
geometry and a text attribute containing your label text. And there is<br>
no need to touch GML manually if you use a WMS. You will get images<br>
that you can display using OpenLayers.Layer.WMS.<br>
<br>
Regards,<br>
Andreas.<br>
<br>
</blockquote>
<br>
-- <br></div></div><font color="#888888">
Chris Holmes</font><div><div></div><div class="h5"><br>
OpenGeo - <a href="http://opengeo.org" target="_blank">http://opengeo.org</a><br>
Expert service straight from the developers.<br>
</div></div></blockquote></div><br>