Map SQL Query Layer Data

154
2
07-18-2017 06:03 AM
Highlighted
New Contributor III

We have non-spatial data stored on an SQL Server (Backflow Valve w. Adress Location) that we would like to map out for our field users to see (using AGO and Collector). How could we link that data geographically (Map) and keep an active link the the SQL Server to show most current db version?

Reply
0 Kudos
2 Replies
Highlighted
MVP Esteemed Contributor

So you have a table that looks something like this:

ValveID            Address

V1                    1234 S Main St

...                      .....

Why not geocode the addresses and get a point feature class out of the?

What is geocoding?—Help | ArcGIS for Desktop 

Reply
0 Kudos
Highlighted
New Contributor III

It is our solution for now but we wanted to keep an active link to the DB so we wouldn't have to run the geocoder everytime the DB changes (new valve or change of status).

Reply
0 Kudos