David et al,
Shouldn't I point the geometry_columns table to the View somehow or will
Geoserver get the View by itself? I see the geometry_columns table would
get the "mytable" entry at f_table_name, not the View?
Best regards,
Martijn Coenen
http://www.covadis.nl/emailkop/logo.gif<http://www.covadis.nl/emailkop/l
ogo.gif>
Covadis b.v.
t: 026 3616600
Geograaf 12
f: 026 3612317
6921 EW Duiven
e: [email protected]
Van: David Winslow [mailto:[email protected]]
Verzonden: dinsdag 12 juli 2011 14:48
Aan: Martijn Coenen
CC: [email protected]
Onderwerp: Re: [Geoserver-users] Non-geometrytype column
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
Fout! Bestandsnaam niet opgegeven.
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
------------------------------------------------------------------------------
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on "Lean Startup
Secrets Revealed." This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
