Detail view contents are inconsistent on subsequent clicks

[brianashpugh]

Sometimes if you click a data_point or data_polygon, it will fail to pull in the details from the underlying parcel. It seems that we rely on a mouseclick event on both layers to be triggered, but sometimes it fails to do so. We will eventually want to find an alternative way to handle this aggregation across layers.

One solution would send Carto some PostGIS SQL getting the parcel most overlapping with the selected point or polygon.

Generally, we're going to have to build out some way of fuzzily figuring out when two data points are the same parcel. This will also be useful for aggregating multiple data points added from the same parcel.

[calo1]

One solution would send Carto some PostGIS SQL getting the parcel most overlapping with the selected point or polygon.

I thought this is the current method we have. We pass some form of ST_Contain or ST_within
where there is survey data on top of parcel data

[brianashpugh]

I expected that but didn't see it anywhere in the code. The main part of the sql is below.

        // Build a background query string
        //
        let clauses = [];
        for(let key in datapoint) {
          clauses.push(key + ' = ' + datapoint[key]);
        }
        let sql = 'SELECT * FROM ' + tableName + ' WHERE ' + clauses.join(' and ');```