Discuss all the things!
Home Page: https://dev.socrata.com
License: Apache License 2.0
Due to TLS security issues with older versions, the plugin requires QGIS3 or above.
The Socrata plugin is added the 'Web' menu.
Enter in the domain. Username and Password are optional fields.
You can use the "Get Maps" button to get a list of all map assets on the domain or conversely enter in the dataset ID if you have it.
By clicking OK the map will then be added to your project.
All maps on Socrata are in WGS84 and are retrieved through the GeoJSON endpoint.
Any tips on where to find fuel consumption in this dataset?
API Docs: https://dev.socrata.com/foundry/opendata.rdw.nl/m9d7-ebf2
On August 20th we updated the Socrata platform to require support for the SNI extension on all TLS connections. This may affect your code and you may need to update your system or environment to a newer version that supports SNI.
This issue will serve as location to track what versions of different libraries are necessary. If you're having problems upgrading to use SNI, comment here, and we'll help out.
We've also posted a changelog update to dev.socrata.com with more information
Known good version combinations:
net/httpNet::SSLeay version 1.50 and IO::Socket::SSL version 1.56API Docs: https://dev.socrata.com/foundry/data.cms.gov/cng4-92f3
I am trying to data mine the number of physician home visits for California for a measurement period 2014/2015.
This thread will serve as a discussion and feedback thread about what we should take into consideration as we design and build a replacement for the Import API.
API Docs: https://dev.socrata.com/foundry/data.nashville.gov/xbru-cfzi
The mapped_location_zip data seems to be blank in the Parks Locations resource. Am I missing something? I'd like to get a lat/lon or zip code to associate with the park data.
Thanks in advance!
I was trying to fetch a9we-mtpn from the SODA api, but I get back this error message:
{
"message": "Dataset '_a9we-mtpn' was not found",
"errorCode": "soda.dataset.not-found",
"data": {
"dataset": "_a9we-mtpn"
}
}I believe it is an issue on your side because even when I visit the dataset here:
https://dev.socrata.com/foundry/data.cityofnewyork.us/a9we-mtpn
and I use try it, I get the following issue on safari:
I tried the same setup in chrome and it also broke.
Trying to hit the url directly here also did not work:
Thanks for your time,
Dean
API Docs: https://dev.socrata.com/foundry/data.iowa.gov/gq4y-pik4
Hi guys.
With respect to the new downloadable version of the CSV file the row containing primary_county_coordinates is concatenated as primary_county_long and then primary_county_lat
Should it not read primary_county_lat then primary_county_long.
If you agree and are planning to fix , could you also include a comma between the coordinates also. It would make mapping easier when pulling into Folium
FAPRev1.txt
The endpoint for the realtime 9/11 fire calls data doesn't expose information about whether or not the call is active or closed. However, the much-more-primitive site (hosted by city of seattle) located here indicates which units are/were dispatched, the state of the call, and the level.
Not sure this is the right place for feature requests like this, but I figure if anyone can has the right points of contact to feed this back to the city of seattle, they'd be here.
Hi there, we're developing an Open City Council app that leverages your open data platform.
The City of Austin has a feed of their Council Agenda Items on their feed:
https://data.austintexas.gov/Government/Austin-City-Council-Agenda-Items/es7e-878h
But the City of Las Vegas does not:
https://opendata.lasvegasnevada.gov/browse?q=council&sortBy=relevance&utf8=%E2%9C%93
Both use the same SIRE agenda management system. Is there a way for Las Vegas to get its Agenda Item data from SIRE into Socrata Open Data?
API Docs: https://dev.socrata.com/foundry/data.seattle.gov/3neb-8edu
Can you tell me how to interpret the status field, and how it differs from the vacant field? I see that status contains either a number or the value "open". I figured the number corresponded to the number of available parking spaces, and if that number was not known (and maybe only if the lot was known to not be full), then it would contain "open". However, I see that there is also a field called vacant, which contains a number that is close to, but not always the same as the number in status. And when the status is "open", there is still a number for vacant.
So, my questions are:
status?vacant?"open"?vacant and status?Why the difference in size and currency ?
Hi,
Can anyone confirm the timezone of the timestamps in Melbourne Bike Share data? It seems to be current data (at most 15 min old), but the timestamps are 6 hours in the past.
Is it really updated every 15 min, but 6 hours old data, or is the timezone wrong for Melbourne?
Thanks!
API Docs: https://dev.socrata.com/foundry/data.cityofnewyork.us/dvnq-fhaa
Hi All,
Im getting the JSON data using the below Java code:
The program was running successfully for past few months. But suddenly for the past one week, Im getting the exception.
StringBuilder urlString = new StringBuilder("https://data.cityofnewyork.us/resource/dvnq-fhaa.json");
URL url = new URL(urlString.toString());
HttpsURLConnection conn = (HttpsURLConnection) url.openConnection();
conn.setRequestMethod("GET");
conn.setRequestProperty("Accept", "application/json");
conn.setRequestProperty("X-App-Token", "XXXXXX");
if (conn.getResponseCode() != 200) {
throw new RuntimeException("Failed : HTTP error code : " + conn.getResponseCode());
}
BufferedReader br = new BufferedReader(new InputStreamReader((conn.getInputStream())));
Im getting the following exception :
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:196)
at java.net.SocketInputStream.read(SocketInputStream.java:122)
at sun.security.ssl.InputRecord.readFully(InputRecord.java:442)
at sun.security.ssl.InputRecord.read(InputRecord.java:480)
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:934)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1332)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1359)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1343)
at sun.net.www.protocol.https.HttpsClient.afterConnect(HttpsClient.java:563)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:185)
Kindly help me, what went wrong. I couldnt understand. Any changes made in the API that is causing the issue? Because the program was successfully running. This exception is happening for the past one week only.
Thank you,
Marimuthu M
We recently ran into an issue where we were getting errors on filtered views that include checkboxes in their filter (in this case, that the columns were not checked). The underlying dataset is private and the filtered views are public.
The dataset is populated by an ETL process that uses our SODA.NET library and the checkbox columns are defined as boolean properties. Our process was setting the boolean properties to true or false. everything appeared to be working correctly until we tested anonymous access to the filtered views via the API - the service returned status 500 errors.
Socrata support investigated it for some time and determined that the filtered view API call could not deal with the checkbox columns containing false values. Instead, the checkbox columns needed to contain true or null.
We recoded our ETL to specifically set the boolean properties to true or null and our filtered view API calls now work correctly. However, this raises a question about the API, or its documentation:
https://dev.socrata.com/docs/datatypes/checkbox.html#,
Either the API service should be updated to support false values as well as null or the documentation should reflect that only true or null values are allowed
I'm getting daily 500 Server Errors when sending API calls to https://opendata.rdw.nl
Recent errors:
21-Mar-2016 15:43:01
21-Mar-2016 17:09:03
21-Mar-2016 17:18:24
Example API calls:
https://opendata.rdw.nl/resource/kmfi-hrps.xml?kenteken=28TVSH
https://opendata.rdw.nl/resource/m9d7-ebf2.xml?kenteken=HD507J
The API calls are working now, but on the datetimes above then gave a 500 Server Error.
Everyday I get 500 Server Errors on different API calls and different times.
I want to be able to do analyze by day of week, by hour, etc. strftime would let me do that.
API Docs: https://dev.socrata.com/foundry/data.seattle.gov/vwtx-gvpm How should the "trail_clas" number be used? If I want to fetch only officially endorsed trails, which numbers are they?
The search query for [?naicgroupname=HEALTH CARE & SOCIAL ASSISTANCE (I)] is not working, but most other search queries do work such as RETAIL TRADE (G). Please help?
Hi,
I am querying the RMS arrest report dataset and it appears there are no new entries since August 18th. I see new arrest charges since August 18 in the arrest charges dataset so there had to be new arrests but no new entries are showing up. Any explanation as to why this could be happening or is there some problem with the Dallas RMS arrest dataset currently?
API Docs: https://dev.socrata.com/foundry/data.melbourne.vic.gov.au/qnjw-wgaj
Needed help to just get ID, NBBikes, NBEmptydoc columns in pHP
https://data.seattle.gov/resource/pu5n-trf4.json?$select=event_clearance_group,count(*)&$group=event_clearance_group&$where=within_circle(incident_location,%2047.61,%20-122.34,%201000)&$order=count(*)%20DESC&$limit=10
I believe it's actually a problem with the data source itself and not my code, but where this is my first time trying out Socrata, I was hoping someone could confirm. You'll notice you can't even use the "try it" function here:
https://dev.socrata.com/foundry/data.novascotia.ca/tntn-er5g
Hi, I am lead integration consultant for http://www.usefulfeedback.com. We provide on-demand complaint management software to a range of US finance customers. I notice that you publicize an API allowing access to resolved complaints - we wondered if you also had an API that would allow secure access to a feed of new complaints per organisation that we could access to automatically populate work queues for our clients?
This query https://data.seattle.gov/resource/pu5n-trf4.json?$select=hundred_block_location,incident_location&$group=hundred_block_location,incident_location&$where=within_circle(incident_location,%2047.508145,-122.234978,%201)&$order=hundred_block_location shows that a bunch of city blocks were given the same incident_location
Results for first two block addresses where XX replaced with 00 using http://www.latlong.net/ Note when using XX instead of 00 I get the reported issue of the lat/lngs not being different.
47.512174,-122.247753
47.511724,-122.245971
API Docs: https://dev.socrata.com/foundry/data.seattle.gov/pu5n-trf4
Invoke-RestMethod : The underlying connection was closed: An unexpected error occurred on a send
I have used the example:
`$url = "https://opendata.rdw.nl/resource/m9d7-ebf2"
$apptoken = "YOURAPPTOKENHERE"
$headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]"
$headers.Add("Accept","application/json")
$headers.Add("X-App-Token",$apptoken)
$results = Invoke-RestMethod -Uri $url -Method get -Headers $headers`
I had to add:
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
can this by added by the example(s)
API Docs: https://dev.socrata.com/foundry/data.cityofnewyork.us/muk7-ct23
Hello ,
I want to request the socrata team to kindly include the second row of DOB complaints page in the dataset . the second row contains a little detail about the complaint such as
""ILLEGAL CONVERSION IN BASEMENT AND ATTIC ""
Hello ,
i've been working on Socrata API for ACRIS and i'm unable to find the following fields from the api
assesment date
collateral
file_number
map_sequence_number
message
pages
parcels
property_type
rptt_number
slid_num
any help is greatly appreciated
Because each Crimereports agency has its own Socrata dataset I need a way to get the dataset for the area that a lat/lng is in.
Another test discussion
API Docs: https://dev.socrata.com/foundry/data.seattle.gov/vwtx-gvpm What is "check steps" type of "surface_ty"? Does this mean rough terrain? I'm marking surface types in Seattle Trails App by soft, medium, hard and stairs groupings.
API Docs: https://dev.socrata.com/foundry/data.baltimorecity.gov/m8g9-abgb
Is any information about the geocoding process for this dataset available? There appear to be a number of valid human readable locations ("incidentLocation" column) that do not appear to be geocoded to a valid location ("location" column) and some invalid locations geocoded to a valid geographical location.
A list with entries that could not be assigned a neighborhood from the past day can be found at https://www.neighborhoodcallwatch.com/Uncategorized. 50 of the 118 entries do not have a location (either "(,)" or "(0.000000,0.000000)") and the remainder either have "100" or similar for the "incidentLocation" and a "location" that does not appear to correspond to a Baltimore City neighborhood (e.g., "2600 ROYAL OAK AV").
"MONDAWMIN MALL", a recognizable place, has been geocoded to "(0.000000,0.000000)" for call "P163321463" and "(39.318644,-76.654012)" for call "P163321732". "P163321463" appears to have occurred before "P163321732".
"1300 DOCK ST" was geocoded to "(,)" for calls "P163321083" and "P163321131".
"HQE" was geocoded to "(0.000000,0.000000)" for call "P163321606".
"100" was geocoded to "(39.3810499,-76.6572571)", which appears to be outside of city limits, for a number of calls, among them, "P163320024". Does 100 have a special meaning?
Each call entry appears to have a description to summarize the issue ("description" column). However, the number of unique descriptions appear to be in the thousands when counted by year and close to one thousand when counted by month with some duplication/typos.
Is any information available with regard to the data normalization/a list of terms that should be expected for comparisons across time/areas?
Thanks!
I was reviewing the API Docs located here, https://dev.socrata.com/foundry/data.montgomerycountymd.gov/yc8a-5df8, and noticed that the data in the API doesn't seem to accurately reflect the data in the Montgomery County Crime Open Data Portal, https://data.montgomerycountymd.gov/Public-Safety/Crime/icn6-v9z3. How often is the API data reviewed?
Following the 12/18/2016 dataset update our process reading the 'Patient survey (HCAHPS) - State' (6e4e-y3f9) results started experiencing a deserialization error. It was isolated to the hcahps_answer_percent field.
We're using c# and NewtonSoft.Json to deserialize results. Our class had a decimal property for a number value, which now has a datatype of Text.
The 3 Patient survey (HCAHPS) datasets are inconsistent in the hcahps_answer_percent data type
'Patient survey (HCAHPS) - Hospital' (rmgi-5fhi) : hcahps_answer_percent [text]
'Patient survey (HCAHPS) - State' (6e4e-y3f9) : hcahps_answer_percent [text]
'Patient survey (HCAHPS) - National' (jk4x-yzqp) : hcahps_answer_percent [number]
Before the 12/18/2016 update I think the 'Patient survey (HCAHPS) - State' hcahps_answer_percent data type was number, as it is on the National dataset. It's now text, as it is on the Hospital dataset.
There is a column for lat and column for lng but not a Socrata location/point column.
API Docs: https://dev.socrata.com/foundry/data.kingcounty.gov/gkhn-e8mn
Hi,
I am getting an error when invoking: https://data.cms.gov/resource/iadr-zq3i.json
Can you please let me know why this error occurs? This used to work from our app and recently discovered that it has stopped. This time I am passing an APP TOKEN, but still getting the error below:
"The underlying connection was closed: An unexpected error occurred on a send."
Thanks.
Hi, I'm having trouble accessing the WNV Mosquito dataset using the RSocrata interface.
The R command listed at the end of the webpage:
API Docs: https://dev.socrata.com/foundry/data.cityofchicago.org/baqf-cmdv
does not work:
df <- read.socrata("https://data.cityofchicago.org/resource/baqf-cmdv?$$app_token=MYTOKEN")
returns the error message "Error in read.socrata: text/plain not a supported data format."
I also tried other options, to no avail: the command below returns the same error
read.socrata("https://data.cityofchicago.org/resource/baqf-cmdv", app_token="s0ucmjE7RYtXUmMhwUYPI8Xdm")
while this:
read.socrata("https://data.cityofchicago.org/resource/baqf-cmdv.json")
returns "Error in rbind(deparse.level, ...) : numbers of columns of arguments do not match"
The python interface functions properly.
API Docs: https://dev.socrata.com/foundry/data.seattle.gov/exjr-udk6
A reporter who wrote about the dropped frame issue today told me that he had to export this data to Excel and that Excel couldn't handle this much data. This dataset needs a datetime column so one can use Socrata to chart number of drop frame cases per day, month, year.
API Docs: https://dev.socrata.com/foundry/data.sfgov.org/ktji-gk7t
The page has a helpful looking section called "External Integration" but the plotly portion is saying that the file is too big, and the Carto DB integration ends in an error, with the message to contact the great people at Carto and reference them the error message. Done. Carto quickly responded,
Hi Greg,
Thank you for reaching out. The import error is that the file is too large. The free plan associated with your email address has a max import file size of 150MB and a max import row size of 500,000. What is the size of the file you are attempting to import? Please note that CARTO will use the uncompressed version of the file as the import size.
Best,
Michelle
Here his what the plotly error looks like.
**Perhaps, as a workaround for the people who don't have a Plotly professional plan, you could limit the endpoint to filter just the last 50,000 rows for Carto and 1000 rows for Plotly ..., and give instructions for the cases where more is needed.
bests**
API Docs: https://dev.socrata.com/foundry/data.energystar.gov/ymjh-yrse
Hello there,
We are using our approved token but there is still a threshold of product count on the response, 1000 limit. We are using the following URL to extract over 1500 refrigerators:
https://data.energystar.gov/resource/ymjh-yrse.csv?&&app_token={invisible_token_here}
Thank you very much in ahead,
Danny Suiza
API Docs: https://dev.socrata.com/foundry/data.cityofnewyork.us/ujkp-2x99
Please consider sending the data results without any HTML formatting. I'd love to be able to use the JSON file to make links to the appropriate forms for specific programs, but I will have to use JS to "deformat" the content before I use it in the page.
If the JSON file came with no formatting, I could use it as I wish and apply my own formatting to the result.
Is there a Socrata API method to get links to all dataset snapshots for a given API endpoint?
I can click on more views -> dataset snapshots to get these information.
It would be great if there's an API method.
I've also checked the headers, but it's not there.
Does https://dev.socrata.com/foundry/data.oregon.gov/qajw-6p2c always returns results for the previous month?
If so: https://data.oregon.gov/api/views/esjy-u4fc/ seems to return data for May/16.
Can I get a list for all months?
API Docs: https://dev.socrata.com/foundry/data.cityofchicago.org/ijzp-q8t2
I am trying to access all data from 2001 to present but its only returning 1000 records from 2017
API Docs: https://dev.socrata.com/foundry/data.seattle.gov/r6xd-5qab
I'm noticing that this API endpoint results in json that seems like arcgis output: https://data.seattle.gov/resource/r6xd-5qab.json
Is there a way to get a geojson response?
API Docs: https://dev.socrata.com/foundry/data.oaklandnet.com/x452-eizt
Hello,
It appears that all of the lat/longs in this dataset are the same. Is this a DB issue or an error in the endpoint code?
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.