opengov-opendata/ckanext-cartodbmap

CKAN CartoDB ResourceView

ckanext-cartodbmap's Issues

Local CartoDB installation

Is there any way to use this plugin with a locally installed version of CartoDB - not the public API version?

Support widgets

Leverage new widgets capability.

We need not over-engineer this, just have a field in the Resource View form to add a JSON configuration file, instead of dynamically creating a form based on the schema of the table.

Add minimap widget

Already in place on data.beta.nyc

see http://data.beta.nyc/dataset/transit-leadership-summit-data/resource/42870c8c-b110-4ca0-aff6-00241ad5022a

Design Templates

Have the ability to specify a template that will be used to generate the CartoDB viz.

Right now, all CartoDB resource views have the same design (e.g. getthedata button, minimap, scale, locator, etc.)

Let's put in the ability to specify a template so alternate UX can be specified (e.g. AirBnB Explorer template; AirBnB compliance tracking template; Template with radii for quarter-mile, half-mile etc.)

The template definitions themselves should be JSON config files.

Note that UI design is still done in CartoDB editor. These template definitions are only for UX elements like widgets, and widget sets.

Add screencast

showing how to install/use the plugin

Support SQL-based table synching

The current synching is a drop and replace mechanism, and is capped at 200mb and needs to be done from the CartoDB editor.

Let's improve it so we have the ability to do an upsert using CartoDB's SQL api.

For this to work, in the Resource View configuration form, prompt for:

SYNC TYPE:
Present three options: snapshot, table-sync, sql-sync.

For snapshot - no synching required
Table sync - activate data.api table sync
SQL sync - prompt for key field/s.

• use this info to create a unique index using the SQL api in CartoDB store

For table-sync/sql-sync, prompt for frequency. For table-sync, depend on CartoDB scheduler to fetch data. For sql-sync, schedule job on cron.

For sql-sync cron job, do upsert.