topic Map SQL Query Layer Data in Geodatabase Questions

Map SQL Query Layer Data

KevinRobert1 — Tue, 18 Jul 2017 13:03:13 GMT

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?

Re: Map SQL Query Layer Data

JoeBorgione — Tue, 18 Jul 2017 13:30:41 GMT

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

Re: Map SQL Query Layer Data

KevinRobert1 — Tue, 18 Jul 2017 13:35:16 GMT

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).