Pinterest • The world’s catalog of ideas

Related Boards

Embed often-updated information on your Website by uploading a spreadsheet to Socrata.

Pinned from

kingcounty.gov

Create a calendar, map, and sortable table all from one dataset

Boundary Review Board meetings - King County

kingcounty.gov

Meeting agendas and minutes from the same dataset

Saved by

Al Boss

Create a map automatically from street addresses or latitude/longitude.

Pinned from

kingcounty.gov

It's easy to add a spreadsheet to Socrata.

Saved by

Al Boss

Registered users land on a "My data" page upon login.

Pinned from

data.kingcounty.gov

Upon importing the data, choose the data types for the columns.

Saved by

Al Boss

If you have an address, or latitude/longitude coordinates, you can use them to create a "Location" column for making maps from your data.

Saved by

Al Boss

Identify the rows and/or columns that will be headings or field names. Check the "Errors" notification and attend to any potential issues.

Saved by

Al Boss

Specify the metadata that describes your datasets, to make them discoverable and universally accessible. (Metadata is what data publishers use to describe their datasets, create user-friendly descriptions and tag content to help constituents find the data and make sense of it.)

Saved by

Al Boss

Newly-uploaded data, or data you're editing, is stored in a "working copy," which lets you make changes and review them before releasing them to the public.

Saved by

Al Boss

The "Edit" tab offers options for replacing the dataset, adding to it, or adding a column to it.

Saved by

Al Boss

The "Manage" tab lets you share ownership, let someone else view a privata dataset, show and hide columns or rearrange them, and more.

Saved by

Al Boss

Every dataset that is hosted on the Socrata open data platform, or federated from another Socrata-powered site, can be interactively explored online.

Saved by

Al Boss

Socrata data can be filtered, sorted, arranged as tables, text lists, or single pages for each record in the dataset.

Saved by

Al Boss

On a Socrata dataset, the "About" tab includes the metadata, but also information about how the dataset is being received and used.

Saved by

Al Boss

Socrata data can be filtered, sorted, arranged as tables, text lists, or single pages for each record in the dataset.

Saved by

Al Boss

You can rearrange the layout of different views.

Saved by

Al Boss

This is the "edit layout" display for a Socrata "rich text list" display.

Saved by

Al Boss

The single-row display can page through each individual record in the dataset.

Saved by

Al Boss

The "Visualiize" tab lets you create visual representations of the data.

Saved by

Al Boss

An open data tool gives the public many opportunities to contribute to the value of the data. Feedback, ratings, comments, suggested datasets. Citizens promote content. Healthy debate is fostered.

Saved by

Al Boss

Collect information via a form that pipes directly into the database, thus updating your results real-time. NOAA did this with citizen reports during the BP spill, and King County used this approach when collecting damage reports for the state.

Saved by

Al Boss

Socrata generates code that you can use to make what you've created there show up in your Website. Everything based on the dataset will update automatically whenever the data changes. This also allows news media, bloggers etc. to display our data, real-time, on their Websites. This has been most recently used for snow closures and election results.

Saved by

Al Boss

Users can save their own copy of the data if they like. Datasets hosted on the Socrata open data platform can be automatically downloaded in a number of file formats such as CSV, XLS, RDF, XML, or JSON.

Saved by

Al Boss