AnsweredAssumed Answered

Displaying only unique points

Question asked by cheesle on Jan 15, 2019

Hello!  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
0     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.

 

Thanks for your help!

 

Chris.

Outcomes