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

Whether tinyurl can be used to fetch json data from socrata

Does the socrata support tinyurl or any urlshortener service to fetch data if the query string is too long. Please correct if I am wrong
vikram r
  • 33
  • 5
2
votes
2 answers

Is there a Socrata API for reading a site's catalog?

Is there a Socrata API for reading a site's catalog of datasets? For example, for Boston, is there an API equivalent of this page?
Ed Staub
  • 15,480
  • 3
  • 61
  • 91
2
votes
1 answer

Is there a Socrata API for reading a dataset's metadata?

Apart from the column names and types in the HTTP header, is there any way to access a dataset's metadata via the Socrata REST API? The following fields in the "About" window are of high interest: category tags row count visits downloads In…
Ed Staub
  • 15,480
  • 3
  • 61
  • 91
2
votes
1 answer

Using Socrata SODA API to query most recent rows by datetime

I am new to this site and this is my first question. I am trying to query the "Seattle Real Time Fire 911 Calls" database from the Socrata Seattle Open Data site: https://data.seattle.gov/Public-Safety/Seattle-Real-Time-Fire-911-Calls/kzjm-xkqj. …
Open Data Bits
  • 23
  • 1
  • 3
1
vote
2 answers

After building the project from pom.xml using Maven, how do I use its resources

It's been tedious. This is the API I am trying to use. Its resources were set up in a pom.xml which I built using Maven. On built up, it gave me the project socrata-publisher that has src/main/java the source folder with packages com.socrata.api…
jmishra
  • 2,086
  • 2
  • 24
  • 38
1
vote
2 answers

reading filtered data from socrata in R

does anyone know how to filter data automatically based on date_of_incident from socrata dataset in R in the first step of import to speed up read time? this is what I have so far token <- "n15hFiXqJU6DBItiSjA4jWD2U" PoliceIncidents <-…
Kristina Paterson
  • 11
  • 4
1
vote
0 answers

Extracting charts from Socrata as you would a dataset

I need some help with extracting charts as you would a dataset and though the visualizations appear to be saved in the catalog as assets, I have not been able to find a way to pull the visualization out. I need to do this for at least 100 charts…
Kifarm
  • 11
  • 1
1
vote
1 answer

Q: How to remove the limit of 1000 records per request

I am running this endpoint https://www.datos.gov.co/resource/qx3q-zr7u.json?limit=1000 I put a limit of a thousand records but I receive the following message Unrecognized arguments [limit]
Juan Ramirez
  • 37
  • 5
1
vote
1 answer

How to determine number of records on a socrata table

Is there a way to determine how many records are available to download for a socarata table? I'm using the API endpoint routines. I can down the file but it would be nice to know how many records are available to download before starting a download.
Henry F
  • 48
  • 3
1
vote
2 answers

SODA between operator does not work with some datasets

The between operator works for some Socrata SODA datasets and not for others. When used on certain datasets the query yields no results, but on other datasets it works as expected. What am I doing wrong? Instead of using between I tried using >=…
Amar Mehta
  • 98
  • 1
  • 6
1
vote
1 answer

Open Payments - How to reconcile or explain differences between API data versus live site visual data

We are connected to the API for https://openpaymentsdata.cms.gov/. In some cases the data points differ (for example - quantity of general payments) between the raw API data versus what is seen on the live site. What is the source for these data…
matisses
  • 11
  • 2
1
vote
1 answer

my app token is useless, how could I access to the dataset

I am trying to use my own generated app token to access the socrata data, but I don't know why my app token is useless, and it always returns "forbidden 403" and "error in getResponse()" I checked the syntax for read.socrata() function, and modify…
Cooper
  • 73
  • 6
1
vote
2 answers

case-insensitive queries for a Socrata SoQL

I trying to find all the mixed case results. For example 'Abee' will only return is searching that exact case. I've looked in the like '...' option and tried upper (but it appears to be for the return not the query). This is working query I'm…
paulywill
  • 629
  • 10
  • 29
1
vote
1 answer

Chicago Data Portal API format for filter with multiple conditions

Probably very easy, however I cant find the answer in the documentation. I have the following API url which I like to extend with additional filter condition for the "location_description". It currently filters on…
xbmcgotham
  • 33
  • 3
1
vote
2 answers

Socrata API - How to replace empty data fields from query as empty strings in results array

I'm using the "phpsoda" library and trying to query the city of Seattle's permits dataset through the Socrata API (SODA). Data: https://data.seattle.gov/Permitting/Land-Use-Permits/ht3q-kdvx They have several columns such as the ones I'm selecting…
alin
  • 11
  • 2
1
2
3
…
15 16