topic Build an Application to Show a map from a database in Java Maps SDK Questions

Build an Application to Show a map from a database

CarlosErazo — Thu, 16 Jun 2016 01:06:25 GMT

How to Build a Desktop Java Application to Show a map from a database (Oracle, Postgres, SQL Server, etc).

Re: Build an Application to Show a map from a database

VijayGandhi — Fri, 17 Jun 2016 17:23:20 GMT

You would need to create a Feature Service using ArcMap (see What is a feature service?—Documentation | ArcGIS for Server ). It can then be added as a FeatureLayer to the Java application (Example: Feature layer feature service—ArcGIS Runtime SDK for Java (Quartz Beta) | ArcGIS for Developers ).

If you simply want to display the data from the database, you could read data from the database (using JDBC for example), and then add the data as Graphics to a GraphicsOverlay (Example: Add graphics overlays to your app—ArcGIS Runtime SDK for Java (Quartz Beta) | ArcGIS for Developers )

Re: Build an Application to Show a map from a database

CarlosErazo — Sun, 19 Jun 2016 18:05:40 GMT

Thanks for the answer, Vijay. Exactly, I just want to display the data from the database, like Oracle, SQL Server or Postgres. So, how could I read data from the database?

Re: Build an Application to Show a map from a database

VijayGandhi — Mon, 20 Jun 2016 16:29:21 GMT

First step would be read the data from the database. Here is an example using JDBC - Lesson: JDBC Introduction (The Java™ Tutorials > JDBC(TM) Database Access).

Next step is to create a Graphic using the Runtime API. Examples at Add graphics and text to graphics overlays—ArcGIS Runtime SDK for Java (Quartz Beta) | ArcGIS for Developers

For example if you have read fields called lat and lng in your database table, then you could create a Graphic like this:

SpatialReference wgs84 = SpatialReferences.getWgs84();

Point location = new Point(lng, lat, wgs84);

SimpleMarkerSymbol marker = new SimpleMarkerSymbol(new RgbColor(255, 0, 0, 255), 10, SimpleMarkerSymbol.Style.CIRCLE);

Graphic graphic = new Graphic(location, marker);

graphicOverlay.getGraphics().add(graphic);