I frequently have to use large tables and results from MS SQL in ArcMap and for that saving the data as .xls is one of the options. But when I add the data to arcmap, processes like joining and plotting the data take a lot of time. My question is that what would be the fastest method of importing SQL data into Arcmap and then working on it?
Answer
The fastest way to get SQL query to ArcMap (10.1 and later) is to use a Query layer.
Menu File > Add Data > Add Query Layer
Before further question please also refer to the Manual relevant to your version (RTFM!)
Manual entry : What is a query layer? 10.1, 10.2.x or 10.3 (latest)
ESRI support manual changed since latest release, this is why I provided you those 3 links. Query layer had become easier and easier to set up with each release especially for me who work with PostGIS.
You could also read this other manual section about database connections (10.3)
(please look for yourself for previous manual version if needed ;)
No comments:
Post a Comment