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
0
votes
1 answer

offset and limit in the /api/views call

I am using the the /api/views/.../rows.json call to access the data and the metadata for a dataset, e.g. - https://data.colorado.gov/api/views/wumm-7awb/rows.json Problem is I don't want to access all of the data but using limit and offset…
Jeff McWhirter
  • 1
  • 1
0
votes
1 answer

How to talk to OpenData API Endpoint without using sodaclient in mvc application

How can I talk to an OpenData API Endpoint (private dataset) in an MVC application without using sodaclient? I have an apptoken and credentials.
salman rathore
  • 53
  • 8
0
votes
3 answers

How to set SODA API end points programatically in asp.net MVC

I am developing an application with open data hosted by socrata using the information from the below link http://dev.socrata.com/consumers/examples/creating-an-application-with-asp-dotnet.html How ever you need to specify the API end point in the…
Nachikethas
  • 43
  • 1
  • 8
0
votes
1 answer

Socrata SODA within polygon is too complex

Using the Socrata SODA api for within_polygon an error is thrown stating that it is too…
DAS
  • 1
0
votes
1 answer

Socrata views in Leaflet maps

I'm new to programming and I'm trying to display permits information in a leaflet map. The permits data is from a view in Socrata. I follow http://fire.seattle.io/ code to figure out how to do this and managed to recreate the map on my own but…
ufeliciano
  • 3
  • 2
0
votes
1 answer

Socrata: How do I add the $order clause to a query?

I'm working a small Android project for a class. In it, I'm building a query against an open Socrata dataset in Los Angeles. Here's the…
kzoom
  • 241
  • 1
  • 2
  • 12
0
votes
2 answers

Android Studio: How do I install Socrata's Soda 2.0 API for Java

How do I install this API (https://github.com/socrata/soda-java) in order to use it in an Android project? This seems to be a "left to the student as an exercise" hole in their documentation, while all the usages of the various objects in the API…
kzoom
  • 241
  • 1
  • 2
  • 12
0
votes
1 answer

How to send those Logstash events which has only "multiline,_xmlparsefailure" in tags to Elastic Search

I am using below config file so that only those events which have "multiline,_xmlparsefailure" tags can be send to the Elastic search. But in my case all of the events irrespective of tags are sent to the ES. Can someone please suggest? Config…
Ajay
  • 11
  • 2
0
votes
1 answer

SODA API: make query string 'starts with', 'ends with', 'containts', etc?

I need to do a search on a partial string. ex: query string 'starts with', 'ends with', 'contains', etc SODA API documentation doesn't cover much at all. Tnx for help.
mangonights
  • 909
  • 1
  • 10
  • 11
0
votes
1 answer

Should socrata/soda-scala be used for new Socrata SODA consumer development?

Given that it hasn't been updated in over a year there's no doc it's still dependent on Scala 2.9.2 I'm guessing that the Socrata Scala SODA SDK is probably dead or nearly so, and shouldn't be used for new (consumer) development - that the Java…
Ed Staub
  • 15,480
  • 3
  • 61
  • 91
0
votes
1 answer

Is there a way to select fields that are grayed out on the Socrata web client?

I am attempting to get the compared_to_national column for the readmission data located at Data.Medicare.gov This column is grayed out on the web interface making me think that it is a computed field or a join with another table. $ curl…
Diablojoe
  • 231
  • 1
  • 8
0
votes
1 answer

Order by Multiple Columns with SoQL

How do I format a query with multiple order by columns. The data I'm working with has a date column and a time column and I want to order by both of them. I know how to do this query in regular SQL but I can't make it work in SoQL. Here is what…
Gregory Arenius
  • 2,904
  • 5
  • 26
  • 47
0
votes
1 answer

socrata ny data service not taking $where?

https://health.data.ny.gov/resource/u4ud-w55t.json?hospital_county=Suffolk$limit=1 works but https://health.data.ny.gov/resource/u4ud-w55t.json?$where=hospital_county=Suffolk does not. Why is this ? since $limit is working why is that $where is not?
Jonas Almeida
  • 11
  • 1
0
votes
1 answer

SoQL query for unique values with Socrata API

I am trying to count the total unique number of heating complaints in the Socrata NYC 311 service requests database: https://data.cityofnewyork.us/Social-Services/All-Heat-complaints-to-311/m5nm-vca4 Ideally I want to use the data to populate a map…
Andrew H
  • 46
  • 1
  • 4
0
votes
2 answers

automated Socrata download

I need to download data from Socrata unattended, i.e., the program starts up as scheduled and runs, downloads data, then ends; all without human interaction. I found a reference to downloading to Excel via OData and thought I would try that since I…
Dallas Reader
  • 1
  • 1
1 2 3
…
15 16