Hi people,
A short question, would this view also be usable on Oracle? I know my way in PostgrSQL but hardly on Oracle but I have such "text as geometry point" data there too. Any Oracle people here who can "translate" this? Any help would be appreciated. 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: mart...@covadis.nl Van: Martijn Coenen [mailto:mart...@covadis.nl] Verzonden: woensdag 13 juli 2011 16:44 Aan: geoserver-users@lists.sourceforge.net Onderwerp: Re: [Geoserver-users] Non-geometrytype column Just for the archives: I used the following SQL to add my table with text as geometry to Geoserver as posted by David: CREATE VIEW spatial_mytable AS SELECT id, name, (ST_PointFromText('POINT(' || geometry || ')')) 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 ('', '', 'spatial_mytable', 'the_geom', 2, 28992, 'POINT'); Mind that I needed to use the single quotes and the 'spatial_' in the Insert into the geometry_columns table. Next up is getting it to work with OpenLayers, as I see I need to tweak the settings, I get the notice: "ERROR: Operation on two geometries with different SRIDs". J After working with GS for a year I still get confused around 4326, 28992, etc. J Thanks for the help David! Best regards, Martijn Coenen Covadis b.v. t: 026 3616600 Geograaf 12 f: 026 3612317 6921 EW Duiven e: mart...@covadis.nl
<<image001.jpg>>
------------------------------------------------------------------------------ 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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users