For new analysis use the following checklist:

- [ ] Uses `the_geom geometry(Geometry, 4326)` column for all geospatial operations.
- [ ] Outputs a `the_geom geometry(Geometry, 4326)` column.
- [ ] Outputs a `cartodb_id numeric` column.
- [ ] Uses `{cache: true}` option when it needs full knowledge of the table it. Hints: aggregations, window functions.
- [ ] Uses `{cache: true}` if it access external services.
- [ ] Naming uses a-z lowercase and hyphens.
- [ ] All mandatory params cannot be made optional.
- [ ] Avoids using CTEs for join operations when result is not cached.
- [ ] Has tests to validate the result is the expected one.

For modified analyses:

- [ ] If it modifies the output columns, updates the analysis version
- [ ] Has tests to validate the result is the expected one.

For new analysis use the following checklist:

- [ ] Uses `the_geom geometry(Geometry, 4326)` column for all geospatial operations.
- [ ] Outputs a `the_geom geometry(Geometry, 4326)` column.
- [ ] Outputs a `cartodb_id numeric` column.
- [ ] Uses `{cache: true}` option when it needs full knowledge of the table it. Hints: aggregations, window functions.
- [ ] Uses `{cache: true}` if it access external services.
- [ ] Naming uses a-z lowercase and hyphens.
- [ ] All mandatory params cannot be made optional.
- [ ] Avoids using CTEs for join operations when result is not cached.
- [ ] Has tests to validate the result is the expected one.

Update PR template for existing analyses
Github: Update PR template for existing analyses
