I have two data sets for at least one, to possibly 13, US State(s). They are polygons features (Areas) that have attached attributes related to Wild Fire potential. One set has values like Low, Moderate, High, and Very High. The other has many classes of urban and residential categories, water & agriculture and Wildland. All data is Lat/Lon. There are several million records in the data sets. I need to accept a lat/lon pair, or collection of them, and determine the following. 1) Which category the point lands in, for each data-set. 2) The distance, in feet, from the point to the nearest High or Very High category. 3) The distance, in feet, from the point to the nearest Wildland. I have imported the shapefiles into Manifold and Exported to SQL Server. I’ve set up a project with Linked Drawings using the DatabaseConsole and an Area Of Interest and AR_Rick's AOI add-in and a home grown derivative for the automated approach. I've also cobbled together some queries and control from an external C# application. It works, but is way slower I would like. Watching Windows Task Manager while the queries run, it seems that Sql Server is active the whole time. It doesn't matter if the queries are run from the GUI or the external app. It seems that Manifold is not using the linked drawing but going back to the server each time. I thought the whole point of the linked drawing / AOI concept was to work quicker with only the data required. I only need to compare my point to a small number of Area records that are within 5000 ft., not the whole data set. Am I missing something?
bdg |