New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

new analysis node request: detect hotspots and coldspots #239

Open

andy-esch opened this issue Dec 6, 2016 · 1 comment

Assignees

Contributor

andy-esch commented Dec 6, 2016 •

edited

Loading

crankshaft v1.5.0 includes a new function for finding hotspots and coldspots. Docs here: https://github.com/CartoDB/crankshaft/blob/develop/doc/16_getis_ord_gstar.md The data types for all of the function inputs and outputs are in the table there.

Recommended use of the function is like this:

SELECT i.*, m.z_score, m.p_value
  FROM cdb_crankshaft.CDB_GetisOrdsG('SELECT * FROM incident_reports_clustered',
                                     'num_incidents') As m
  JOIN incident_reports_clustered As i
    ON i.cartodb_id = m.rowid

cc @rochoa @stuartlynn

rochoa assigned saleiva

Contributor

rochoa commented Dec 9, 2016

Assigning it to @saleiva to understand better the priority of this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment