Socrata was acquired by Tyler Technologies in 2018 and is now the Data and Insights division of Tyler. The platform is still powered by the same software formerly known as Socrata but you will see references to Data & Insights going forward.

URL Datatype

The URL datatype is a type that contains a url and a description. It may be accessed as an object with 2 keys in it. These keys are:

  • The url of the field. This can be directly accessed using dot notation: fieldName.url
  • The description of the field (may be null). This can be directly accessed using dot notation: fieldName.description

The following operators can be used with URL fields:

Operator Description
< TRUE for strings that are alphanumerically before this string
<= TRUE for strings that are alphanumerically before or equal to this string
> TRUE for strings that are alphanumerically after this string
>= TRUE for strings that are alphanumerically after or equal to this string
= TRUE for strings that are equal to this string
!= TRUE for strings that are not equal to this string
IS NULL TRUE for strings that are NULL.
IS NOT NULL TRUE for strings that are not NULL.

And the following functions can be used with them:

Keyword Name Description Availability
distinct Returns distinct set of records 2.1
Function Name Description Availability
case(...) Returns different values based on the evaluation of boolean comparisons 2.1
count(...) Returns a count of a given set of records 2.0 and 2.1

Here is what a URL field with both the url and the description looks like:

https://soda.demo.socrata.com/resource/7caz-dk9s.json?$query=SELECT url_with_description

If you just want the description string:

https://soda.demo.socrata.com/resource/7caz-dk9s.json?$query=SELECT url_with_description.description

Similarly, if you just want the url string:

https://soda.demo.socrata.com/resource/7caz-dk9s.json?$query=SELECT url_with_description.url