Queries using SODA | Socrata

Loading...
Queries using SODA Overview

The Socrata APIs provide rich query functionality through a query language we call the “Socrata Query Language” or “SoQL”. As its name might suggest, it borrows heavily from Structured Query Language (SQL)

API Endpoints

(http://en.wikipedia.org/wiki/Sql), used by many relational database systems. Its paradigms should be familiar to

(/docs/endpoints.html)

most developers who have previously worked with SQL, and are easy to learn for those who are new to it.

Row Identifiers (/docs/rowidentifiers.html) RESTful Verbs (/docs/verbs.html) Application Tokens (/docs/app-tokens.html) Authentication (/docs/authentication.html) Response Codes & Headers (/docs/response-codes.html) System Fields (/docs/system-fields.html) CORS & JSONP (/docs/cors-and-jsonp.html)

Filtering & Querying Simple Filters (/docs/filtering.html) SoQL Queries (/docs/queries/) Paging Through Data (/docs/paging.html) SoQL Function Listing (/docs/functions/)

Data Formats (/docs/formats/) JSON (/docs/formats/json.html) GeoJSON

SoQL Clauses SoQL statements are broken into “parameters” similar to clauses in SQL statements. Each clause can be expressed either directly as a URL parameter or as a SoQL statement. If a parameter is not specified, then the default is used. Click each parameter name for more details: Parameter

Description

Default

$select The set of columns to be returned, All columns, equivalent to $select=* (/docs/queries/select.html) similar to a SELECT in SQL $where Filters the rows to be returned, No filter (/docs/queries/where.html) similar to WHERE $order Column to order results on, similar to Unspecified order (/docs/queries/order.html) ORDER BY in SQL $group Column to group results on, similar to No grouping (/docs/queries/group.html) GROUP BY in SQL $having Filters the rows that result from an No filter (/docs/queries/having.html)aggregation, similar to HAVING $limit 1000 (2.0 endpoints: maximum of 50,000; Maximum number of results to return 2.1: unlimited » (/docs/endpoints.html)) (/docs/queries/limit.html) $offset Offset count into the results to start 0 (/docs/queries/offset.html) at, used for paging Performs a full text search for a $q (/docs/queries/q.html) No search value. $query A full SoQL query string, all as one N/A (/docs/queries/query.html) parameter $$bom Prepends a UTF-8 Byte Order Mark false (/docs/queries/bom.html) to the beginning of CSV output

In $query SELECT WHERE ORDER BY GROUP BY HAVING LIMIT OFFSET N/A N/A N/A

Note that for equality comparisons, the $where clause can be replaced with using the column name as the query parameter. See filtering (/docs/filtering.html) for more details. These parameters can then be directly added to the API endpoint. For example, here is how you would query the USGS Earthquakes datasets for quakes of greater than 3.0 on the Richter scale:

(/docs/formats/geojson.html)

https://soda.demo.socrata.com/resource/4tka-6guv.json?$where=magnitude > 3.0

CSV

(https://soda.demo.socrata.com/resource/4tka-6guv.json?$where=magnitude%20%3E%203.0)

(/docs/formats/csv.html)

In examples, we will leave the parameters as is, but it is best to URL Encode

RDF-XML (/docs/formats/rdf-

(http://en.wikipedia.org/wiki/Url_encode) your parameters to ensure they are parsed correctly.

xml.html)

Datatypes (/docs/datatypes/) Checkbox (/docs/datatypes/checkbox.html) Double (/docs/datatypes/double.html) Floating Timestamp (/docs/datatypes/floating_timestamp.html)

Line (/docs/datatypes/line.html) Location (/docs/datatypes/location.html) Money (/docs/datatypes/money.html) MultiLine (/docs/datatypes/multiline.html) MultiPoint (/docs/datatypes/multipoint.html) MultiPolygon (/docs/datatypes/multipolygon.html) Number (/docs/datatypes/number.html) Point (/docs/datatypes/point.html) Polygon (/docs/datatypes/polygon.html) Text (/docs/datatypes/text.html)

Other APIs Discovery (http://docs.socratadiscovery.apiary.io/) Open Performance (http://docs.openperformance.apiary.io/) OData (/odata/)

(http://creativecommons.org/licenses/by-nc-sa/3.0/deed.en_US) Licensed by Socrata (http://socrata.com) under CC BY-NC-SA 3.0 (http://creativecommons.org/licenses/by-nc-sa/3.0/deed.en_US). Learn how you can contribute! (/contributing.html)

Loading...

Queries using SODA | Socrata

Queries using SODA Overview The Socrata APIs provide rich query functionality through a query language we call the “Socrata Query Language” or “SoQL”...

44KB Sizes 2 Downloads 16 Views

Recommend Documents

Queries using multiple tables Contents
Jul 21, 2011 - This practical chapter aims to provide you with the following skills and knowledge to achieve the learnin

Editors - Socrata
Utopia in Four. Movements,The. Weather Underground. Pedro del Rey. /guid/9202a8c040. 00641f800000000. 110a0fa. Tristana,

Knoxville Backup - Socrata
Texaco. Michelle Chaffman. ONI. Operator Not. Interested. Your Grate Escape. Jason Rector. King College Market. PNS. Pro

SBL Abbreviations - Socrata
Interpretation: A Bible Commentary for Teaching and Preaching. IBS. Irish Biblical Studies. ICC. International Critical

Baking Soda atau soda kue atau bicarbonat Baking Soda - Pinterest
Aneka Essence/esens Esen adalah ekstrak dari aroma bahan makanan seperti vanili,cokelat,moka, orange, stroberi dan lainn

Baking Soda atau soda kue atau bicarbonat Baking Soda - Pinterest
Dijual dalam kemasan box atau kaleng. ... Esens digunakan untuk menambah atau menguatkan aroma pada bahan cake, roti, ku

Baking Soda atau soda kue atau bicarbonat Baking Soda - Pinterest
Baking Soda atau soda kue atau bicarbonat Baking Soda Sering disebut juga soda kue. Baking soda sebenarnya nama lain dar

Run Queries Safely - Databases using R - RStudio
SQL Injection Attack. The dbGetQuery() command allows us to write queries and retrieve the results. The query has to be

Pet Store Directory - Socrata
506 Arnold Avenue. Point Pleasant Beach. NJ. 8742. Animal Trax. 975 Delsea Drive. Franklinville. NJ. 8322. Chow Down. 37

NJ Day Care Providers - Socrata
Daycare Center. 8-09 Plaza Road. FAIR LAWN. NJ. B 4 School Learning. Center. 1-36 30th Street. FAIR LAWN. NJ. Fair Lawn