This might be a very basic question as I am new to GeoServer.

What I am trying to do:

  1. I have a MySQL table that stores data attached to a spatial point and have latitude and longitude columns to store the location attribute.
  2. Use GeoServer to display these data points as layer.

What has been done:

  1. Create a new table which is duplicate of the original table but also have POINT field which is generated using POINT(orig_lat, orig_lon).
  2. Use the MySQL extension to create a new data store linked with this spatial_table.
  3. Create a new layer here we need two fields called as native and declared SRS, in the demo I had seen EPSG:4326 as the declared SRS and hence I have added that SRS.


  1. When I view the layer preview in OpenLayers I do not see any map? Not sure if this is because of SRS or do I need to specify a map layer.
  2. Most of the points seem like they are overlaid on top of each other and zooming and panning does not make much difference. This seems like SRS issue.
  3. Is it possible to overlay the points on top of Google Maps using GeoServer?

2 Answers 2


For 1 and 2 : try to set "force declared" in SRS Handling combobox. By the way did you define srs for your dataset in MySQL ?

For 3 : No it is not possible if you mean using baselayer in layer preview but if you use openlayers you can overlay your layer that is served by Geoserver on top of google maps or open street maps.

  • Thank you for the response. No I did not define SRS for my dataset in MySQL, can you point to me how to do that and what SRS to be used?
    – PravinCG
    Sep 4, 2012 at 18:49
  • Sorry I overlooked at that you are using Mysql extension. Did you check this : geo.ifip.tuwien.ac.at/imak/2009/stack_workshop/doc/mysql/… It says "MySQL does not know about spatial reference systems (SRS). It is up to you to provide the correct EPSG code for the stored coordinates." Therefore Goeserver settings should be sufficient.
    – Ozgun Alan
    Sep 4, 2012 at 19:24
  • That is my original question. How to figure out what is the correct SRS code.
    – PravinCG
    Sep 5, 2012 at 4:31
  • Then I should ask do you arbitrarily creating those points or are they coming from a dataset with a certain SRS ? If it is arbitrary then go with ESPG:4326 otherwise set native SRS to the one that the dataset has. However I guess you don't have it right ?
    – Ozgun Alan
    Sep 5, 2012 at 8:02
  • These are data logged for a specific points using GPS receiver. I am not aware if they are related to a certain dataset.
    – PravinCG
    Sep 5, 2012 at 8:36

As oalan said, you need to find the srs of your spatial informaiton (but you can actually overlay your data in the geoserver test page). If the points comes from a GPS, it could (reasonably) be EGS84 (EPSG:4326). What you can try is to overlay your data to a WMS map server. In your geoserver, add a new datasource of type WMS, using a publi free WMS service like this.

Then, in the "layer preview" open the OpenLayers test page with your data, and add the new wms layer at the url of the page


In my case, optima_piemonte:link is my layer, and optima_piemonte:OSM_Basic is a layer produced by the service above linked

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.