Displaying only unique points

94
0
01-15-2019 04:34 AM
chrisweaves
New Contributor II

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.

0 Kudos
0 Replies