Viewing data from Oracle/SQL data

Feb 22, 2009 at 11:26 PM
Hi,
    Is it possible to view a map with data from Oracle/SQL Server data directly? That is not using any tiling.
Also, what is the support for WFS/WMS?  Lastly, can dynamic geometries be created on the map(i.e. redlining objects)?

Thanks and regards,
Praveen
Feb 23, 2009 at 5:29 PM
Hi,

I think there is some future prospect on allowing additional multiScaleElements as stacks, which would then mean you could stack WMS tiles on top of base tiles. That would be an easy solution to Oracle since your Oracle could be mediated thru an OWS server like GoeServer. Not as efficient as loading geometries directly, but a nice generalized solution that lets lots of data stores share in the DeepEarth goodness.

Also I read a previous post about GML from MS SQL Server. If a DeepEarth to Geometry parser is in place for GML it could read WFS output from an OWS server as well, becauseWFS export is OGC specified to be GML. Also a GML parser might be easy to extend into an SVG parser which would then let WMS svg export be added to DeepEarth as well.

As far as creating objects it is pretty easy to create geometries for redlining etc locally in the browser. The harder issue might be how to persist the created geometry and share with other users, which gets into OGC WFS-T or back to a direct DB driver. I think DeepEarth is going to be oriented around MS SQL server rather than DBs in general so I think it more likely to look for an OGC solution than a direct Oracle one.

just a bit of wishful speculation
Developer
Feb 23, 2009 at 11:48 PM
There is a a way to add "Overlays"

	map.BaseLayer.Overlays.Add(new OsmTileSource(OsmMapModes.Mapnik));

This can be any TileSource, an existing one or a new one you create your self.

I also have a basic TileSource class for WMS EPSG:3395 / EPSG:900913 which is the same kind of projection like DeepEarth uses
the WMS TileSource in the download is WMS EPSG:4326, which is not the same projection so the map distorts

Also I have a basic TileSource class for ArcGIS server as well

I will post these up some here in next couple days after I clean them up a little bit if anyone would like to check them out.
Feb 24, 2009 at 12:08 AM
Thanks for your response.
Please do let me know once you have example code online.

-Praveen
Feb 24, 2009 at 9:26 PM
Is that basic ArcGIS TileSource for servers that are already setup to mimic Virtual Earth?
Developer
Feb 25, 2009 at 2:11 AM
Hi Colin, 

This could be the case, it has a similar kind of url, 

I don'y really know about ArcGIS I just found a tile server on the web and worked out the url's that were populating the tiles and created a TileSource class for it
Feb 25, 2009 at 2:48 PM
There was a previous discussion at http://www.codeplex.com/deepearth/Thread/View.aspx?ThreadId=43552 where ArcGIS was begin discussed and I gave instructions on how to setup the URL and more importantly how to setup the ArcGIS server to conform to Virtual Earth. If you want to actually include an ArcGIS tile source into the project you should probably include those instructions. The big thing we were trying to figure out are the free ArcGIS online sources found at http://www.esri.com/software/arcgis/arcgisonline-services/agol-standard/index.html but those maps are in WGS 1984 instead of WGS Web Mercator and the zoom scales do not match.

The ArcGIS scales are at : http://webhelp.esri.com/arcgisserver/9.3/dotNet/arcgis_online_scales.txt
The VE/Google/DeepEarth scales are at: http://webhelp.esri.com/arcgisserver/9.3/dotNet/gmaps_ve_scales.txt

If we could get that conversion figured out we would have tons of new maps to use.