We have some experience in using ArcMap and ArcSDE, but this dates back to 2008, so we're not up to date with the recent developments in ESRI products.
Now we're dealing with a database that has some Lat/Lng coordinates stored as plain
FLOAT columns. The client wants an HTML5 map that displays some information based on these Lat/Lng coordinates: some point annotations, as well as some arrows between pairs of Lat/Lng coordinates.
However, due to high-level decisions by the customer's management, the map component must be implemented using ESRI products, so my idea with Google Maps and the simple JSON service won't work as intended.
I see the following options:
- WFS service: We install/implement some kind of (OGC-compliant) WFS web service that reads the Lat/Lng values from the Oracle database and serves them as an OGC-compliant feature layer. Then, we're using an HTML5 map component by ESRI to consume that WFS service. No idea how I would implement the arrows between two Lat/Lng pairs.
- ESRI service: Maybe ESRI provides a web service component with a generic data source, so we could wire that web service component to the Lat/Lng columns from the DB. This is basically the same architecture as in option 2, but with an ESRI service instead of some generic WFS component.
Thanks for any hints. We're new to the HTML5 world of ESRI, so we're just looking for some what's-possible and how-to-get-started hints.