Stack Overflow
Stack Overflow

Questions tagged [socrata]

Socrata is a company which provides government data services. Use this tag for questions about Socrata products, including the SODA API (http://dev.socrata.com/); and also indicate the Socrata product such as Data Portal, GovStat, or API Foundry. If your question is not closely related to programming, please consider asking your question on https://opendata.stackexchange.com.

Socrata is a company which provides government data services. From 2007 to 2009, it was known as Blist. Use this tag for questions about Socrata products, including the SODA API; and also indicate the Socrata product such as Data Portal, GovStat, or API Foundry.

235 questions
1
vote
1 answer

Filter Table dataset using like in socrata

I am trying to run a filter on the dataset which is private in Socrata. I have tried doing it through browser and using SoQL but it doesn't work. https://xxxxx/resource/xxxx-xxxx.json?$where=product like '%test%' When I am making request to the…
Arun Kumar
  • 907
  • 13
  • 33
1
vote
1 answer

Socrata SODA End Point object return limit

I want to get a Medicare.gov dataset via the SODA API End Point. Does SoQL support a 'not equal to' operator (<> or !=) ? My URI string returns…
Colin
  • 930
  • 3
  • 19
  • 42
1
vote
0 answers

socrata soda upload file as attachment capability

Can I upload files as attachments to my Socrata Dataset using soda-ruby? I saw an example that used a method named upload_file When I tried that, I received the following error undefined method error.
wfraser
  • 11
  • 1
1
vote
1 answer

Does the Socrata SODA API support getting a list of dates on which the dataset was modified?

Does the Socrata SODA API support a method to query out all the dates a dataset has been updated? Basically a changelog for the dataset that has an object for every modification/update to a dataset. There is an existing question that asks for the…
Max Shenfield
  • 3,927
  • 2
  • 13
  • 16
1
vote
0 answers

Socrata - SoQL - Query for recent data

I'm trying to pull data from a variety of Socrata datasets in to a analytic architecture using the REST json API. I would like to find a way to get the new data dropping into the data set since the last request. My plan at the moment is to use…
Ed Fullman
  • 21
  • 2
1
vote
1 answer

Why am I limited to 1,000 rows on SODA API when I have an App Key

I'm trying to load the Consumer Financial Protection Bureau (CFPB) into a Pandas Data Frame in Python 3.4. My code works, however it appears that I'm limited to 1,000 rows through the SODA API. I'm using an app token and referencing the URL…
Ben Porter
  • 78
  • 1
  • 7
1
vote
1 answer

'in(..)' function not working in SoQL query

Using SoQL (Socrata Query Language) we can filter the values of a data set using the in(...) function. A sample example is shown in the socrata website using the Chicago open data…
Nachikethas
  • 43
  • 1
  • 8
1
vote
1 answer

Socrata callback url issue

I am currently inplementing socrata oauth2 for accessing private information.call back url is not accepting localhost path example:http://localhost:8080/callback. Let me know is there any way to use redirect url?
KREDDY
  • 23
  • 6
1
vote
1 answer

How do I do column contains with API

With the GUI I can do a filter on a column for contains. The API does not seem to allow that. Is there anyway to do this with the api?
Tim Clemans
  • 875
  • 1
  • 10
  • 18
1
vote
1 answer

Socrata URL works from Chrome, not from Android app

I'm trying to use the open data sets that data.LACity.org publishes using Socrata software. They have a Java API for it, but first I tried to just build and send a URL, as a variant on the 'Sunshine' app several people have learned from on…
kzoom
  • 241
  • 1
  • 2
  • 12
1
vote
1 answer

Deleting all rows in dataset with SODA API

I'm trying to programmatically delete all the rows in a Socrata dataset, using the SODA API. I don't want to delete the dataset itself, because then I'd have lots of work to reconstruct it. It's also very slow to do this for thousands of…
Steve Bennett
  • 114,604
  • 39
  • 168
  • 219
1
vote
2 answers

Can't target fields in SODA api because of whitespace

I'm trying to use the Socrata SODA API on a NYC gov database by searching for specific street addresses. The URL would look as follows: http://data.cityofnewyork.us/resource/eabe-havv.json?house_street=PARK+PLACE However, although I know that PARK…
romeboards
  • 387
  • 5
  • 19
1
vote
3 answers

Socrata SODA and Python

Socrata confirms there is no official Python API. I would like to know if there is some reason for this that would make it worthwhile to learn one of the languages which does have official API support, ie is Python (and associated packages like…
user4048937
1
vote
3 answers

SOCRATA SODA LIKE Queries

How do I request LIKE queries in Socrata SODA API? For example, I take all the Socrata data and ETL (extract, transform, and load) it into BigQuery For example, start…
Ralph Yozzo
  • 1,086
  • 13
  • 25
1
vote
1 answer

How to query a list of OpenData end points

How can a query to get a list of end-points provided by a OpenData site using Socrata?
Stephen Woodbridge
  • 1,100
  • 1
  • 8
  • 16
1 2 3
…
15 16