Stack Overflow
Stack Overflow

Questions tagged [soda]

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.

153 questions
18
votes
3 answers

How to edit Sublime Text 3 Soda Theme

I installed the Soda Theme on Sublime Text 3 on OSX and I was wondering where are the actual files and folder to the theme that way I could look at the theme file and make my own edits to it, along with I would like to adjust a few of the images…
Greenhoe
  • 1,051
  • 4
  • 18
  • 41
8
votes
1 answer

Converting GeoJSON into a Simple Feature in R

I would like to read a spatial dataset from a Socrata repository into R and then convert it into a simple feature object. The dataset consists of capital improvement projects represented as polygons: The data used in the app above is accessible via…
Tiernan
  • 828
  • 8
  • 20
7
votes
3 answers

Trouble applying the Soda Theme in Sublime Text 2

I've installed the Soda Theme using the Package Control in Sublime Text 2, then activated it via Preferences -> Settings - User. However it doesn't get applied. Instead my theme now is Solarized, which is declared at the top of my…
fullstackplus
  • 1,061
  • 3
  • 17
  • 31
3
votes
1 answer

SODA API not returning all fields in data set

I am having trouble obtaining all of the fields in a dataset from the Socrata Open Data Network. I am using urllib3 to make the request as such: url = 'https://data.sfgov.org/resource/g8m3-pdis.json' http =…
KoalaKey
  • 252
  • 3
  • 11
3
votes
1 answer

Oracle Soda - VERSION field use case

I am studying Oracle SODA for using it as no-sql's document-store in my Java project. Each collection is represented as an SQL table in the Oracle database. This table is composed by some fields like BLOB that contains the JSON payload, and VERSION…
michele
  • 26,348
  • 30
  • 111
  • 168
3
votes
0 answers

Node-based automated testing of browser key events

I'm trying to write automated tests for Hashify Editor. Here are the sorts of assertions I'd like to make: Assert that a textarea matches a particular selector. Assert that the textarea is currently empty. Type "_" into the textarea. Assert that it…
davidchambers
  • 23,918
  • 16
  • 76
  • 105
2
votes
3 answers

Using $limit and $offset to get more than 1,000 rows on a SODA API

I am pulling data with a SODA API using the following code in Python response = requests.get('https://healthdata.gov/resource/uqq2-txqb.json') The dataset contains 434,865 rows but when I use the API, it only returns the first 1,000 rows. I saw on…
amatof
  • 175
  • 1
  • 13
2
votes
1 answer

Is there a way to get millions of records using sodapy in python?

I am trying to read in data from nyc opendata and it has about 25million records. def JSON_to_DF(json_file): json_data = requests.get(json_file) text_data = json.loads(json_data.text) pd_data = pd.DataFrame(text_data) return…
John_gis
  • 117
  • 8
2
votes
2 answers

PLS-00201: identifier 'DBMS_SODA_ADMIN.DESCRIBE_COLLECTION' must be declared

I am using SODA for Java to store and retrieve documents from oracle 12c DB. I am following this example. I am getting exception after the execution of the code. oracle.soda.rdbms.impl.SODAUtils$1OracleSQLException at…
Kaustubh Khare
  • 3,280
  • 2
  • 32
  • 48
2
votes
2 answers

SODA API Filtering

I am trying to filter through ny gov open database with their SODA API. I am following the docs on how to filter, but it is returning an empty dataframe. # noinspection PyUnresolvedReferences import numpy as np # noinspection…
GSatterwhite
  • 301
  • 1
  • 3
  • 12
2
votes
1 answer

Trouble putting together a SoQL query with Socrata

I have this query that I put together in MySQL in my test db and am trying to figure out how to port it over to the SoQL SODA API. Pretty much just trying to get a list of the unique business and associated details. SELECT DISTINCT (CAMIS), dba,…
Zeratas
  • 1,005
  • 3
  • 17
  • 36
2
votes
2 answers

how to convert text to number in a SOQL query?

Can somebody please help me figure out what is wrong with this query? https://data.cityofnewyork.us/resource/i4gi-tjb9.json?$where=speed<10 It failed with error code: query.soql.type-mismatch the "speed" column of the table is declared as text. I am…
Andrew Tang
  • 111
  • 1
  • 5
2
votes
1 answer

Querying from Soda database using Socrata client.get in Python

I am trying to query from a database and I've tried to lookup the right way to format an SoQL string but I am failing. I try the following: from __future__ import division, print_function from sodapy import Socrata import pandas as pd import numpy…
jtorca
  • 1,531
  • 2
  • 17
  • 31
2
votes
1 answer

db4o SODA compare field values

class SomeClass { private DateTime fieldA; private DateTime fieldB; } Using SODA, what is the proper way to select all objects whose fieldA is greater than fieldB? Something like this? var query =…
Travis Heseman
  • 11,359
  • 8
  • 37
  • 46
2
votes
1 answer

Android Gradle duplicate files copied exception

I have seen many versions of this question where the solution is to simply exclude the META-INF file name, but those are already excluded and the duplicate file, in this case, is not even a file associated with META-INF. When I run ./gradlew…
imcraigery
  • 21
  • 5
1
2 3
…
10 11