SODA - the Socrata Open Data API
SODA (Socrata Open Data API) is an API used for accessing and modifying data in Socrata-based open data portals.
Questions tagged [soda]
153 questions
1
vote
1 answer
Is there a way to represent location values in a query?
For things like simple filters and comparisons in a where clause, is there any way of representing a location value? For example, something like:
https://data.seattle.gov/rescource/82su-5fxf.json?location='LOCATION (Seattle, 47.612237,…
StevenW
- 27
- 2
- 7
1
vote
1 answer
How do I get the most recent rows in Socrata SODA datasets since the last query?
I am using Splunk to analyse SFGov open data (data.sfgov.org), which is a Socrata system.
I am able to download the json data and analyse stuff offline. I am now implementing automated indexing of updates to the datasets (everyday).
I am trying to…
Subbu Vincent
- 11
- 3
1
vote
1 answer
Query with negative numbers not working as expected
I'm trying to write a query to this data set:
https://data.sfgov.org/City-Infrastructure/Street-Tree-List/tkzw-k3nq
I want to return the records that have a latitude AND longitude between certain values.
My attempt at a query string:…
Dylan
- 13
- 2
1
vote
1 answer
RSocrata package with Chicago data neglects my token
I can not throttle-up my downloads by using the token issued to my app (on data.chicago.com portal, where I had to register)
Error 1:
token <- "___my_app_token__";
fdf <-…
Alex Fedotov
- 497
- 3
- 8
1
vote
1 answer
How do I escape an ampersand in a Socrata SODA 2 API call?
I am working with the NYC crime dataset and I notice that the offense type for homicides is MURDER & NON-NEGL. MANSLAUGHTE. (Yes, that’s “manslaughte” without the “r”.) However, when I try to filter for this using the SODA API, I get…
isthmuses
- 1,316
- 1
- 17
- 27
1
vote
2 answers
Is there a SoQL DISTINCT or equivelent directive
For the URL based query in Socrata's SoQL is there a SQL equivalent of DISTINCT.
Thanks.
1
vote
1 answer
What am I doing wrong to get an 500 statusCode
Is this code supported by soda-js, and if so, why am I getting a 500 status code
var identifier = 'fgzt-sd3n'
var op = new soda.Consumer('data.cms.gov', options);
op.query()
.withDataset(identifier)
…
Chris McKay
- 37
- 5
1
vote
0 answers
android-soda-client not found in Maven repository
Hi I am following the directions in https://github.com/socrata/soda-android-sdk to include the android-soda-client as a gradle/maven dependency in my build.gradle, but the dependency is not resolved. I looked in the Maven Repository for com.socrata…
Cait Crawford
- 21
- 1
1
vote
1 answer
Trying to set up a Socrata API to enter a value and receive a specific string in return
I work for a business which operates several garages in the Netherlands. Normally I don't do webdev professionally, as I'm an online marketer, but since I'm the only one in the company with knowledge of web development, my boss has asked me to build…
Tijmen
- 542
- 1
- 6
- 29
1
vote
1 answer
Acces all data from RDW API by adding App Token
For a school project i need to work with the information that a api is giving me.
I choose for the RDW API(Dutch License plate info). What i now have is only acces to 1000 licenseplates but i want to be able to get all off them.
import…
Teted
- 27
- 5
1
vote
1 answer
Socrata API call using within_polygon function returning error
Using hurl.it, I am trying to make an API call to the City of Seattle open data.
Here's the GET destination:
https://data.seattle.gov/resource/82su-5fxf.json?$where=within_polygon(location, 'MULTIPOLYGON(((-122.345239999941…
Rachel Lanman
- 499
- 1
- 5
- 15
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
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
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