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

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
0 answers

application frezes IOUtils.toString()

I have an application that I need to read some open data from a (Socrata) dataset using their API. Since there are many records on that dataset, I am looping it through using offsets inside a while //initialize variables //... do{ …
Skaros Ilias
  • 1,008
  • 12
  • 40
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.
Reluctant Interlocutor
  • 11
  • 5
1
vote
1 answer

Socata Soda Api Java Error: function #LIKE is not defined in SoQL

I am trying to do a like query on a socrata dataset using the soda-java api with this code Soda2Consumer consumer = Soda2Consumer.newConsumer("https://data.cityofboston.gov"); SoqlQuery departmentOfStateQuery = new SoqlQueryBuilder() …
Skaros Ilias
  • 1,008
  • 12
  • 40
1
vote
2 answers

Socrata, find all available datasets

I am interested into getting financial open data from any available Socrata dataset. I have managed to get a small java application working for any specific dataset, but i was wondering if there is a way to get all available datasets…
Skaros Ilias
  • 1,008
  • 12
  • 40
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
1 answer

Using unmodified soda-php demo, getting 'Error "0" from server:'

I'm running XAMPP/Win10, PHP 7.0.1. I grabbed Socrata/soda-php from GitHub and ran the index.php. I made no changes to the file. When I submit the form, I always get Error "0" from server: with no other information. There is nothing in my PHP error…
aardrian
  • 8,581
  • 30
  • 40
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
0 answers

Socrata Full dataset replace API

I've been trying to follow the API docs for a full replace, by POSTing the payload to the dataset's endpoint (/resource/~ID~.json). I'm being returned the following object, which shows nothing actually happened. { "By RowIdentifier" : 0, "Rows…
Zack Sarver
  • 11
  • 2
1
vote
1 answer

Highcharts csv data loading

I'm trying to load csv data for a highcharts basic column chart. I'm using the latest data-module method here and not parsing like the old method ( http://www.highcharts.com/docs/working-with-data/data-module ) I have loaded all js libraries &…
Pravin
  • 461
  • 5
  • 26
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 2 3
…
15 16