S

Open-source alternative to Socrata

CKAN is the free, open-source Socrata alternative behind national open data portals such as Canada’s and Australia’s: publish datasets with their descriptions, group them by organisation, and offer each for download and through an API. Socrata, now Tyler Data & Insights, is a hosted-only subscription; self-hosted CKAN runs on your own server with no licence fee, but has fewer built-in charts and visualisations.

Free app Code: Open source Import from Socrata: No Some setup

Why look for an alternative to Socrata?

Socrata, now called Tyler Data & Insights and owned by Tyler Technologies, is a hosted open data platform used by many US cities, counties and states. It publishes datasets with charts, maps and the SODA API, and is sold by subscription.

Governments look for an alternative when the subscription is hard to justify on a public budget, or because the portal and its data live only on the vendor's platform. A self-hosted CKAN is open source, free to run, and used by national governments, though it has fewer built-in visualisations and needs technical staff or a partner to run.

How CKAN compares

Publish your organisation's datasets on your own open data portal.

Publishes datasets with their descriptions, files and links, groups them by organisation, and gives people search, previews of tables, images and text, and an API for everything. Government of Canada and Australian Government portals run on it. It has fewer built-in charts and visualisations than Socrata, and those come from extensions you add yourself.

Some setup Open source

Moving from Socrata

There is no import from Socrata, so export each dataset as a file, such as CSV or GeoJSON, with its title and description. In CKAN, create an organisation for each department, then add the datasets with their licence and tags and upload the files. Larger portals usually script this through CKAN's API, and some have hired consultants for the move. Data that changes often can be stored in CKAN's DataStore and updated through its API. Keep the old portal's addresses in mind, so you can point visitors to the new pages.

Questions

What is the best open-source alternative to Socrata?

CKAN is the free, open-source alternative to Socrata for publishing government open data in the catalogue today. Publishes datasets with their descriptions, files and links, groups them by organisation, and gives people search, previews of tables, images and text, and an API for everything. Government of Canada and Australian Government portals run on it. It has fewer built-in charts and visualisations than Socrata, and those come from extensions you add yourself.

Do governments use CKAN instead of Socrata?

Yes. CKAN runs national open data portals, including those of the Government of Canada, Singapore and Australia, as well as many city portals.

Does CKAN have an API like Socrata's SODA API?

Yes. Everything you can do in CKAN's web interface can also be done through its API, and data in its DataStore can be queried by code.

Can CKAN make charts and maps like Socrata?

Only partly. CKAN previews tables, images and text, and has fewer built-in charts and visualisations than Socrata, now Tyler Data & Insights. Charts and maps in CKAN come from extensions you add and configure yourself.

Is CKAN really free compared with Socrata?

Yes, CKAN is free. To run them you need Cloudgate and a server. Use hosted Cloudgate, which can also provide the server, or install Cloudgate on a server of your own for free. Cloudgate's plans and prices are at cloudgate.octabyte.io/pricing. One server can run several apps.

Do I need a developer to replace Socrata?

No. Cloudgate installs CKAN on your server and gives it a secure web address, and you use it in your browser instead of Socrata.