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

Display error message when api call comes back empty in Shiny?

I have an interactive visualization that connects to a city government's police data API. When certain combinations of inputs are selected, my API call comes back empty and I get a nasty red error message (as my plot inputs are unavailable). Can…
DJC
  • 1,491
  • 6
  • 19
1
vote
1 answer

Socrata SELECT/WHERE works on Zip field but not Last_name field in NYS Attorneys data

I'm using PHP to access the NYS Attorneys data. This query works for the zip field: https://data.ny.gov/resource/cdhq-buk7.json?$select=first_name, last_name, company_name, street_1, street_2, city, county, state, zip, zip_plus_four,…
Jim Gerland
  • 11
  • 2
1
vote
0 answers

Sodapy HTTPError: 403 Client Error: Forbidden

I'm trying to connect to the openpayments data using the sodapy library. I have previously been able to connect with my code as is, but suddenly, today, I have been receiving the error below. I've checked that my openpayments account is still…
NilesRath
  • 11
  • 1
1
vote
1 answer

How to query between floating dates?

I am querying from this dataset. From the documentation I know there is a variable disp_date (floating_timestamp). From the documentation I think I should be able to use the between ... and ... on disp_date. Suppose I want from 2016-01-01 to…
Dambo
  • 3,318
  • 5
  • 30
  • 79
1
vote
1 answer

How to stream data into Google Cloud BigQuery using Appengine with Python Script-flowing data from API?

I've been attempting to stream data from the below api and finding very little success. https://dev.socrata.com/foundry/data.cityofchicago.org/8v9j-bter Automating a datalab notebook with a shell script is too finnicky Using airflow to orchestrate…
just_sung
  • 27
  • 7
1
vote
1 answer

SODA dll in Script Task

I am trying to download some of the data from Data.Medicare.Gov using SODA APIs in an SSIS package. Is there a strongly named version of SODA.dll that I can install in the GAC? The Script Task loses the reference otherwise. Note: When I tried…
Mary G.
  • 19
  • 2
1
vote
0 answers

How do I query rows in Socrata SODA API for Medicare.gov list of facilities that have been updated or added within the date range?

Can we rely on the system field :updated-at for Medicare.gov data to get only recently updated rows rather than the entire set of records?
Marsha
  • 11
  • 2
1
vote
1 answer

Python KeyError: using peewee insert_many()

As an exercise, I'm pulling data from an API and inserting it into a psql database. I was initially following the default limit of 1000 entries per pull, but decided I wanted to try and get all of the data which is approximately 40K rows. After a…
Kurt Maurer
  • 425
  • 1
  • 5
  • 15
1
vote
1 answer

To stop if paging through data reaches its limit, using API

I am calling 1000 records a time using for loop from a database using API (paging through data) and want that if the database record reaches its limit, the loop should terminate. I am using limit and offset in url but i failed to stop at last record…
Raj
  • 77
  • 2
  • 5
1
vote
1 answer

Summing from large public dataset

I'm working on a web app that will let users explore some data from a public API. The idea is to let the user select a U.S. state and some other parameters, and I'll give them a line chart showing, for example, what percentage of home loans in that…
J. Trimarco
  • 149
  • 1
  • 8
1
vote
1 answer

Socrata SODA API: Select by day of week, hour, etc

I'm looking for a SODA API function that would allow me to select/extract the day of week, hour, etc from a floating timestamp field. In other words, I'm looking for a SODA equivalent to SQL's DATEPART. The API has a few function for manipulating…
spatialaustin
  • 582
  • 4
  • 21
1
vote
1 answer

Printing all extracted emails in one text field and one activity in android app development

i succeeded in writing an android program that extracts emails from inputted words but then the program doesnt print all the emails it found into one text field designated for it. Instead it prints the emails one after another on different screens…
Nono
  • 25
  • 7
1
vote
1 answer

Get EditText value word by word

Please can someone help me out with this code. I am a newbie programmer and i am trying to build a sample android project that extracts emails from texts in a text field. The .xml file is in place but the mainActivity is the problem. Please do take…
Nono
  • 25
  • 7
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
0 answers

403 error querying opendata at socrata

I'm querying data from an opendata source at socrata. The objective is to retrieve some information on vehicles by entering a licenseplate. The code worked nice, however it stopped working a few days ago. //strip licenseplate, it may only contain…
Michiel
  • 11
  • 2
1 2
3
…
15 16