Hi annalisa 1. Your reference system is not google maps but wgs84 I think 2. You can create a new column in your table (or field in a view, but this will be slower), of type sqlgeometry
Ie https://docs.microsoft.com/en-us/sql/t-sql/spatial-geometry/stgeomfromtext-geometry-data-type Bart -----Original Message----- From: annalisa [mailto:[email protected]] Sent: dinsdag 18 april 2017 12:50 To: [email protected] Subject: [Geoserver-users] geoserver connect to sql server hi guy, i'm new in GeoServer but i want to ask you: how to take coordinates from a sql server database where i have a column called lat and a column called lon where the reference system is google maps? To be more specific: i have a sql server database and i have a table, called tbl_places in witch i have a lot of records as <43.89898;11.989898> , <22.89898;12.909> I want geoserver recognize my google maps coordinates and show me in a openlayer maps. I've already installed geoserver and the connection to sql server is ok, but i don't know how to tell geoserver that my column lat and lon( double type) are my coordinates. Anybody can help me? Thanks you -- View this message in context: http://osgeo-org.1560.x6.nabble.com/geoserver-connect-to-sql-server-tp5317579.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users ________________________________ Informatie Vlaanderen e-mail disclaimer: http://www.vlaanderen.be/informatievlaanderen ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
