0

Environment: I am using ArgGIS Server to host and ArcMap to publish my data.

I have a layer with 3 million points, of the 3 million there are roughly 70,000 distinct coordinates (but each of the 3 million points also have coordinates).

I only need to display the 70,000 unique points but I need to be able to query the 3,000,000 records (using JS API), a simplistic view of the data below:

ID    SITE    LAT    LONG    PRODUCT 
1     1       1.1    1.1     Product 1
2     1       1.1    1.1     Product 2 
3     1       1.1    1.1     Product 3 
4     2       2.2    2.2     Product 1
5     2       2.2    2.2     Product 6
6     2       2.2    2.2     Product 9 
7     3       3.3    3.3     Product 4
8     3       3.3    3.3     Product 6
9     4       4.4    4.4     Product 1
10    4       4.4    4.4     Product 2 
...
3000000 .....

If I publish this layer then all 3 million points are plotted which is not great for performance.

For plotting terms I only need to plot the distinct points BUT for querying terms I need to query the entire 3 million rows (using a QueryTask).

I think the solution may be to create a parent child relationship but Im struggling to see how I can filter on PRODUCT in the child table and then de-reference back to the parent record.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.