Hot answers tagged

13

Firstly, let me note that I work at Socrata with Ian. I agree that maintaining technical options and preventing lock-in is important but, I disagree that Socrata fosters lock-in of any kind. Lock-in, for open data, could come from two sources--the data and the API. Socrata enables customers and users to download the data via a huge number of open ...


10

With respect to the question about Socrata and CKAN complementing each other, I also work at Socrata and support a number of Federal agencies on data publishing efforts. I’m seeing more and more cases where Socrata and CKAN are both part of a federated ecosystem of data publishing activities rather than one monolithic catalog that must serve everyone. IMO we’...


10

I'm also quite biased because I work on CKAN and DKAN, but four things to add: 1) Both CKAN and Socrata are often integrated in various ways with a Content Management System such as Wordpress (data.gov) or Drupal (data.gov.uk), in order to more readily provide a more full featured web portal including use cases like telling stories around data, creating ...


8

Just a quick response from CKAN -- Second, there are some basic differences about the tools. Socrata is a turn-key product solution; CKAN requires technically-savvy people to implement and maintain their project solution. One approach is not universally better than the other, they are just different. We (the OKF) also offer a hosted solution where all ...


7

Socrata actually isn't built on top of an existing spreadsheet application or platform. We've built our own platform using a number of different open source technologies. Customer data is stored in our backend, where we use different datastores in a sharded configuration to make sure queries are performant while data remains highly available and safe. Long ...


5

There are a number of lenses through which a choice of platforms can be viewed. I will suggest one other ... from the perspective of risk management. CKAN, especially the option of taking the code base without OKF support, requires a user to essentially bear all risks associated with install, integration and platform service and updating on an ongoing ...


4

I am going to admit some bias up-front by saying that I work for Socrata. But I'm also a believer in open source, so please afford me a chance to provide a thoughtful response with three points. First, I don't consider CKAN vs Socrata as an "either / or" decision. Sure, both the OKFN and Socrata have a similar vision for our customers. But looking at how ...


3

I see our support team responded to your support request you posted to support.socrata.com. The gist of the answer, for others' benefit, is that this is not currently supported but we are passing this feedback and request on to our product and marketing teams. If you are absolutely determined to do this, you can visit a chart such as https://data....


2

Escape the & as hex code %26. http://data.cityofchicago.org/resource/xh8b-g55w.json?$where=license_description='Special Event Beer %26 Wine'&$limit=1


2

Yep, that's exactly what you need to do. Looking at the error message you posted, it looks like you ended up confusing our query parser. As we improve the SODA query APIs, we'll likely make that interface clearer. Thanks, Chris Metcalf Director of Developer Platform chris.metcalf (at) socrata.com


2

From Socrata Tech Support The [Socrata SODA 2 API] expects strings to be enclosed in single quotes. You can use double single quotes to escape it within a string. http://data.cityofchicago.org/resource/xh8b-g55w.json?$where=license_description='Caterer''s Liquor License'&$limit=1


2

This undocumented method seems to get really close: /data?search=tags%3Aparking+OR+tags%3Afootpath That is, you can search for "tags:parking OR tags:footpath". It's "close" because Socrata applies stemming, so it also finds datasets with tags such as "park", but it ranks exact matches higher. It seems that Socrata has removed boolean queries from more ...


2

Approach #1 is doable, but not necessary. We'll go with approach #2 here: Download metadata provided by Socrata. The Open Data Network has an official API that you can use to query the various entities and datasets. You should be able to use that to find all datasets in the network (it looks like that might be doable through a single query, without having ...


1

Thank you for your question. 2 CFR 200.315 is a clause in the Uniform Administrative Requirements, Cost Principles, And Audit Requirements For Federal Awards, which apply to grants and cooperative agreements, together referred to as assistance awards. The agreement with our partner (Socrata) to manage the DDL is a contract, subject to the Federal ...


1

No need to use the secret parameters on our /data.json feed, you can actually use our actually-not-secret Discovery API now!: http://docs.socratadiscovery.apiary.io/#reference/0/searching-particular-categoriestags/category/tag-search-api Edit: I now understand better what you're looking for. I thought you were looking for an API, but it really looks like ...


1

I'm guessing tags are comma separated, because This search returns results with parking and sensors tags: https://data.melbourne.vic.gov.au/data?tags=parking,sensors Didn't use your example, because there is only one set tagged with footpaths, and it doesn't also have a parking tag. EDIT: comma separated doesn't do SQL's OR, but adding &OR between tag ...


1

Update: I realized my answer is for the browser and not related to Socrata. I'll probably delete it soon. Your core URI is http://data.cityofchicago.org/resource/4ijn-s7e5.json which is actually just a large JSON file. It's possible to use the browser to filter the JSON file. After the core URI above, you put a question mark (?) and then the filters. ...


1

Correct, you can also URL encode the whole $where parameter if you want to.


Only top voted, non community-wiki answers of a minimum length are eligible