Would it be possible for you to use a VIEW?
CREATE VIEW spatial_mytable AS SELECT id, msg, ST_PointFromText("POINT(" ||
coordinates || ")", 4326) AS the_geom FROM mytable;
INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name,
f_geometry_column, coord_dimension, srid, "type") VALUES ('', '', 'mytable',
'the_geom', 2, 4326, 'POINT');
GeoServer would then be able to serve that view as if it were a normal table
with a full-fledged geometry column.
--
David Winslow
OpenGeo - http://opengeo.org/
On Tue, Jul 12, 2011 at 3:37 AM, Martijn Coenen <[email protected]> wrote:
> Hello,****
>
> ** **
>
> Got an interesting question here at our company. Would it be possible to
> get a table from a datasource like PostGIS or Oracle without a real geometry
> column into Geoserver? The situation can be seen as one has a table with ID,
> Name and Geometry, but the last colum is a normal character colum. No fancy
> geometry but only with the lat/lon information in it as a char. Such as “1,
> HelloWorld, 3.256031600246515 50.73412861353171” or something like that.**
> **
>
> ** **
>
> Would such be possible? And if so, any special actions that need to be
> taken? In above example, it’s about a single point, no polygons or
> multipoints.****
>
> ** **
>
> Best regards,
> Martijn Coenen****
>
> [image: http://www.covadis.nl/emailkop/logo.gif]****
>
> Covadis b.v. ****
>
> t: 026 3616600 ****
>
> Geograaf 12****
>
> f: 026 3612317 ****
>
> 6921 EW Duiven****
>
> e: [email protected]****
>
> ** **
>
> ** **
>
>
> ------------------------------------------------------------------------------
> All of the data generated in your IT infrastructure is seriously valuable.
> Why? It contains a definitive record of application performance, security
> threats, fraudulent activity, and more. Splunk takes this data and makes
> sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-d2d-c2
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
![http://www.covadis.nl/emailkop/logo.gif]****](http://www.covadis.nl/emailkop/logo.gif]****){kind=link}