Community
Select to view content in your preferred language

Geocode SQL 2008 Table and Display using JavaScript API

947
1
03-07-2012 02:10 PM
BradOleson
by
Emerging Contributor
‎03-07-2012 02:10 PM
I have a task in which I have a table of addresses in a SQL Server 2008 table.  I need to display these as referenced points in a map via JavaScript API.  The addresses in the table are dynamic and change, so this won't work as a feature class.  What is the best method to accomplish this?  Thanks!

B
0 Kudos
1 Reply
HemingZhu
by
Frequent Contributor
‎03-08-2012 04:51 AM
I have a task in which I have a table of addresses in a SQL Server 2008 table.  I need to display these as referenced points in a map via JavaScript API.  The addresses in the table are dynamic and change, so this won't work as a feature class.  What is the best method to accomplish this?  Thanks!

B


One approach i would take would be a GP services (Add X, Y as a layer or GeoCode etc. base on your date) with result/event layer on your mxd. There are certain limitations though if your SQL server table does not have OBJECTID field. So I would suggest you registered you table with Geodatabase. It really does not affect non GIS access to the table.
0 Kudos