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
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]
------------------------------------------------------------------------------
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
