Select to view content in your preferred language

Map SQL Query Layer Data

385
2
07-18-2017 06:03 AM
KevinRobert1
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?

0 Kudos
2 Replies
JoeBorgione
MVP Emeritus

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 

That should just about do it....
0 Kudos
KevinRobert1
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).

0 Kudos