Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have tracking data from GPS, which gives latitude, longitude, heading, etc.

Right now it's stored in a non-standard database (Accumulo) and I'm looking into how best to make the data available for Geoserver to be displayed using OpenLayers.

The data is not in any standard format either, it arrives as part of complex JSON files that report more information.

Essentially I have some text based lat/long data that I can put into anything, though I'd prefer to avoid using PostGIS if possible so I don't have to maintain two databases.

What are my options for getting the data into Geoserver?

share|improve this question
add comment

3 Answers

It depends what you mean by "Getting it into Geoserver" Do you want to display it on a WMS layer as a tile? What Client are you using?

Simplest way is to remove the items you don't want sent to the client from the JSON and just send the Json to the client and render it client side, assuming the client can read Json like OpenLayers can.

Geoserver can access a MySql Database, but if you want it Geo-referenced properly, you need to use PostGres with PostGis. Parse the Json File, put them into a PostGres Table with the postGis extensions, create a geometry column from the lat/lon text, point Geoserver at the table and you can serve your points to your client as a wms layer.

If they are from a GOPS, most likely the projection will be EPSG:4326 (WGS84)

Other options are to use shape files, etc but it is a lot more complicated.

Geoserver can also server Kml files if your client supports it or you want it to end up in Google Earth

Another BIG advantage is that you can style your layers and points using server side SLD and make them look very nice, all on the server.

Cheers

Mark

share|improve this answer
add comment

If you need to do this a lot (more than a couple of times) then you could write a custom datastore by following the steps in this GeoTools tutorial. Then all you need to do is drop the jar file into your WEB-INF/lib folder and it will work just like any other datastore in GeoServer.

share|improve this answer
add comment

Convert the GeoJSON to Shapefile with some of the ogr tools, if you want to avoid PostgreSQL.

share|improve this answer
    
Your answer was flagged as low-quality because of its length and content - is there any chance that you could expand upon your answer in order to help both the asker and any future readers? –  PolyGeo Nov 29 '13 at 11:14
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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