Ecosyste.ms: OpenCollective

An open API service for software projects hosted on Open Collective.

github.com/censusreporter/census-api

The home for the API that powers the Census Reporter project.
https://github.com/censusreporter/census-api

Update Python script and markdown instructions with futher instructions.

The Python sript now has an explanation of the complicated SQL query.
Full detail is provided in...

42c1d1640be285178d7a30943a4053ecd33823a3 authored over 8 years ago by Tushar Chandra <[email protected]>
Add exception for incorrect command line usage

06e8323a7eef9fe3ee198dab5c81c3e9ac72ddaa authored over 8 years ago by Joon Park <[email protected]>
Include column titles as part of search data.

The search data now includes column titles, as well as the previously
included table title, subj...

617ff6f268b189ee0ef118134d5a6910cc816678 authored over 8 years ago by Joon Park <[email protected]>
Add querying instructions and create querying script.

Querying instructions take the form of full-text guide.txt,
which walks through the process of d...

7116b4348175b72471e4b21fb001752e0de58386 authored over 8 years ago by Tushar Chandra <[email protected]>
Make small filename changes to profile page sitemaps

Fix error where profile pages with more than 50000 sitemaps had names
such as sitemap101-2.xml i...

1e453bb3951132c3b09d5c002aab272dcb12a01b authored over 8 years ago by Joon Park <[email protected]>
Clean up sitemap files and change sitemap file names

The profile page sitemap file names were changed from 101.xml to
sitemap_101.xml and the table p...

67418447f32d3c75ec963ddbd6df5570bf6d4be8 authored over 8 years ago by Joon Park <[email protected]>
Sitemap files, committing before I up and leave for the rest of the

week

bae257fb99c3490419bf0c034c27131b41a59c03 authored over 8 years ago by Tushar Chandra <[email protected]>
Add additional install instructions for OS X

For my system, libmemcached had to be installed (through brew) and
pylibmc had to be installed w...

2d2c316a0d2a5e70375f480b5afa10074ddaea3c authored over 8 years ago by Joon Park <[email protected]>
some more on database setup

add info

3ec41321bc1686b3011fd86a93332b5f7f2abbf5 authored over 8 years ago by Joe Germuska <[email protected]>
add data import notes

bf798101f0c956b79a8e0a551961c5c4a6458740 authored over 8 years ago by Joe Germuska <[email protected]>
put something better in for homebrew install

af2af93908b061e5d517f3cef4876190a70ef9e2 authored over 8 years ago by Joe Germuska <[email protected]>
Merge pull request #45 from censusreporter/remove_elasticsearch_endpoints

Remove elasticsearch endpoints for now

3eaa1cde93586d60eb8ccc150758e83db75834f6 authored over 8 years ago by Ian Dees <[email protected]>
Remove pyes

2a187ef80391755167e8d7ee55a4bf914d2684b2 authored over 8 years ago by Ian Dees <[email protected]>
Remove elasticsearch endpoints for now

7384302a4abc8c9afdde92c6e1ac33d48495f365 authored over 8 years ago by Ian Dees <[email protected]>
Merge pull request #38 from censusreporter/allow_numbers_through_geo_search

Allow digits through the geo search filter

bca4971605891bb89f6e9f03eb8b3bf56edfb732 authored over 8 years ago by Ian Dees <[email protected]>
Allow digits through the geo search filter

Fixes https://github.com/censusreporter/census-api/issues/37

1b2846d610ea173e67cfa071be0c15614373b621 authored over 8 years ago by Ian Dees <[email protected]>
use a copy of acs var for table ID search in case there are no results -- acs var used later. All of this would be nicer searching against census_tabulation_metadata which is shared across all releases

1b8973d221eee09647dee1acdb0e5afc9203339d authored almost 9 years ago by Joe Germuska <[email protected]>
fix search logic

cc326b5d80632760064348db633b401f91dffdf5 authored almost 9 years ago by Joe Germuska <[email protected]>
Merge branch 'master' of github.com:censusreporter/census-api

21cf9327cbe696075aec29716b59bc17b3b591dd authored almost 9 years ago by Joe Germuska <[email protected]>
table code searches should be case insensitive and honor partial matches. Also added somewhat inefficient loop through all allowed_acs because not all tables are in the default ACS, and at least from the UI perspective, there's no important reason to limit the search to a single ACS release. IF later some API user complains, we can refine this.

cc6228a64ed3f3e140957206a85fc63eae21dee9 authored almost 9 years ago by Joe Germuska <[email protected]>
excel seems to work ok

ff6c6e6e54b2998a87d2553142cdb495d1b83db8 authored almost 9 years ago by Joe Germuska <[email protected]>
OGR all still works and make an empty XLSX

4cf1990ca4c930660eaf3945535bc944f6ee8364 authored almost 9 years ago by Joe Germuska <[email protected]>
moved ogr stuff out to its own method in pursuit of an alternative XLSX building process

f036b2bf0001a390a87214a3a983bba7584d9466 authored almost 9 years ago by Joe Germuska <[email protected]>
catch up with updates

61d95fd147f7de3139a404526defe7c60a3706a7 authored almost 9 years ago by Joe Germuska <[email protected]>
Clean up old dev stuff

7fe56a1e992ee92ac43bb7c1241367487ed3bc30 authored almost 9 years ago by Ian Dees <[email protected]>
Add a new endpoint for table details where the release is specified in the URL

ad32943eddf7ad4682546dcb94d1a0b82b535e17 authored almost 9 years ago by Ian Dees <[email protected]>
Set the SENTRY_DSN in Flask config

316fbe14929455dd2b965b853a3cb34b44d3d6f9 authored almost 9 years ago by Ian Dees <[email protected]>
Add Sentry for error reporting

baddf69e68ff6a7e290f5508e365b5979a70fe24 authored almost 9 years ago by Ian Dees <[email protected]>
Missed a cache key

558ae0462eaa0885f8597ee7cbbe22be1f17b4d7 authored almost 9 years ago by Ian Dees <[email protected]>
Make sure we're using consistently-cased cache keys

3c99ca4ee83e7dfad7d83ae221804fa371ef9af9 authored almost 9 years ago by Ian Dees <[email protected]>
Handle searching parents on a geoid that has lower case 'US' in geoid.

8b0c21bcafae88f770f21a52eae213a86ae2c06a authored almost 9 years ago by Ian Dees <[email protected]>
Handle searching parents on a geoid that has lower case 'US' in geoid.

4aad9dd9b6e389835849cfda2add795e8377c965 authored almost 9 years ago by Ian Dees <[email protected]>
Don't dict the row until we know we have a result from the database

f4c0a92e79d90311c28599213560181d6fb80874 authored almost 9 years ago by Ian Dees <[email protected]>
Re-remove acs2013_3yr

99e07a4faf5687b99185385accfc58ffcd90f7c3 authored almost 9 years ago by Ian Dees <[email protected]>
Try not chopping the allowed_acs list

03867489eb7933272e8894e33946d40cfb790b8d authored almost 9 years ago by Ian Dees <[email protected]>
Try removing support for 2013 3yr

35b3d7973d66647573623c9a563fc44b1ba79007 authored almost 9 years ago by Ian Dees <[email protected]>
Use the correct expansion release.

73e1fa0064582617ff5b2c9f44c4ffc0513fe23e authored almost 9 years ago by Ian Dees <[email protected]>
Don't try to set geometry on non-geometry download types

9bcec657131c34be22beca3b104c4d13c979cc99 authored almost 9 years ago by Ian Dees <[email protected]>
Use 127.0.0.1 instead of localhost for elasticsearch

ff2e794b25f3cf71ed95e0ae0681b6279e7baa06 authored almost 9 years ago by Ian Dees <[email protected]>
The biggest release is the second one, not the last one

0622de4cda81ece55d514b6696f5320a71de4035 authored almost 9 years ago by Ian Dees <[email protected]>
Need parens around the IN clause

9114d048d01af4fd2c65f73b263dbe3e63a1836f authored almost 9 years ago by Ian Dees <[email protected]>
Trying to protect OGR from unicode

46afd17f3b99a1536ee2a942f6b6fcb30d1e4619 authored almost 9 years ago by Ian Dees <[email protected]>
Maybe the column name is too long?

871eb9597d169ae27ae2873a5e895d8ff487c7ad authored almost 9 years ago by Ian Dees <[email protected]>
Try encoding the column names to utf8 while downloading

997483f07598ee1e55c0b8a2e6d04d339822e215 authored almost 9 years ago by Ian Dees <[email protected]>
Is it in error.description?

a7514af657905e8efae5ff6eb5259bc07492974d authored almost 9 years ago by Ian Dees <[email protected]>
Have to include a message on the exception

f410fbe9eb94cbc03e5c0a927b3deba39d5d5542 authored almost 9 years ago by Ian Dees <[email protected]>
Define the validation exception's constructor correctly

7a12ff8cc28d6f45cb15cac7d1ef0cdf0cd10cdd authored almost 9 years ago by Ian Dees <[email protected]>
Trying to do a better job with request validation error feedback

dca269de4be8265d7e3c08384cc5accee62f5e34 authored almost 9 years ago by Ian Dees <[email protected]>
Add some debug information.

cf281f8928dff5d0383925fd0765985cc3231608 authored almost 9 years ago by Ian Dees <[email protected]>
Be consistent with table search ACS release choice

a517c88725772d24a3e62976735b64e1b2cc6afa authored almost 9 years ago by Ian Dees <[email protected]>
Always expand GEOIDs with the same release

57def863c2553ebccf7b4cda63fc850d3ed8cf7e authored almost 9 years ago by Ian Dees <[email protected]>
Coerce the geo_ids set into a tuple so SQLAlchemy works

2d8e3c3cd41cc7f022d6bc6950e00c2f8c2f32c3 authored almost 9 years ago by Ian Dees <[email protected]>
Merge pull request #35 from censusreporter/use_sqlalchemy

Use SQLALchemy, add support for TIGER 2014

67223cf2f3b0b18c7176627e147703cce5dfbbb7 authored almost 9 years ago by Ian Dees <[email protected]>
dict-ify the tabulation row

1b88bcab66fd6b871022a66bb29273e9562aefe0 authored about 9 years ago by Ian Dees <[email protected]>
Tabulation search switch to use sqlalchemy

09b9fd087f5b657b90da39bf3c4bd83bacbab53a authored about 9 years ago by Ian Dees <[email protected]>
Missed a single dict-ification

1ac70539a7824a4771f67e1e545cb059fa7765be authored about 9 years ago by Ian Dees <[email protected]>
The biggest/best ACS is the second one in 2014

9a25a59b94de417e65278be9f97d2f88c2acc0f3 authored about 9 years ago by Ian Dees <[email protected]>
Support multiple TIGER releases

91f3b70f18aec77c45369e3e373d250ad5877441 authored about 9 years ago by Ian Dees <[email protected]>
SQLalchemy is looking for :, not % for replacements

db4c4204667061aa7782a5f157db4296d68e121f authored about 9 years ago by Ian Dees <[email protected]>
Update postgres URL

c355c74b8f51858e5c59bef93a908adb97435b43 authored about 9 years ago by Ian Dees <[email protected]>
Missed a spot

a9d3e949becaaeaab09c28e53b6bbe4b599ebd94 authored about 9 years ago by Ian Dees <[email protected]>
Dict all the rows cuz it worked

ac8ff8b4bf370470db189ab5e8cebcc3944eb5bf authored about 9 years ago by Ian Dees <[email protected]>
How about applying dict() to the row object?

b602fee2b51820bc08147c953257ffbd20f20530 authored about 9 years ago by Ian Dees <[email protected]>
What about using the internal dict field of the SQLAlchemy row object?

cd5a7d6d25ae237c8e1419a0f42d5c2f25a1cf0e authored about 9 years ago by Ian Dees <[email protected]>
Instead of fetchall, try not popping

8cec58ec0b8542e36e18c8bf994278e0ed1d1ac9 authored about 9 years ago by Ian Dees <[email protected]>
Need to call fetchall() so we can interact with the rows as objects

cb782c540909461763d634bd5d08b29e1d3e074d authored about 9 years ago by Ian Dees <[email protected]>
Log exception better

78d66dfe5ab3acc452ab13cb3f20c99854778f2e authored about 9 years ago by Ian Dees <[email protected]>
Switch up the allowed_acs list

1a4c2a93b67cf1852e6f8eeb40aace55774f39be authored about 9 years ago by Ian Dees <[email protected]>
Switch to tiger2014

0f33a32bf61946114bf1088e4c71d98be4f49609 authored about 9 years ago by Ian Dees <[email protected]>
Update the RDS URI and Elasticsearch .deb URL

b5f9b995a9b78ed453ee67fb98b3f1e9086a409c authored about 9 years ago by Ian Dees <[email protected]>
Whitespace

53adb0fe46bcd4e0b86a915f1064e26e099fb639 authored about 9 years ago by Ian Dees <[email protected]>
Get started switching to Flask-SQLAlchemy for DB session handling

4f37d48d6101a23c992b8c5dbe54efb2edbcda87 authored about 9 years ago by Ian Dees <[email protected]>
Update the data updates doc

51839591bf9aed37bc2ced6011c9f61b295f9fc0 authored about 9 years ago by Ian Dees <[email protected]>
Update to fabfile to support nginx+gunicorn

c439ac6764d416fd1d9adad92977f9e0dcdd921d authored over 9 years ago by Ian Dees <[email protected]>
Add a wsgi.py in prep for switching to gunicorn

0a055d4080f0b6eaae5dd7b34a4467f69d694c8e authored over 9 years ago by Ian Dees <[email protected]>
Update INSTALL.md

aa2f9ea1cc9ff7df8783ef785bfe1af7a5abe996 authored over 9 years ago by Ian Dees <[email protected]>
Missed a spot I guess?

83a3ceb8f0b0e01748ebba1231e5576f07f3bc68 authored over 9 years ago by Ian Dees <[email protected]>
Swap out 2013 1-year with 2014 1-year

1e168fceee180a296f0e4b748ac4f39614b25b2f authored over 9 years ago by Ian Dees <[email protected]>
Update DATA_UPDATES.md

2b84430ff033a3b8c1e9f92b30c80d40ffe59c3a authored over 9 years ago by Ian Dees <[email protected]>
Update DATA_UPDATES.md

fd073967b1cd59fdb7a3701e79938db6dc3ce580 authored over 9 years ago by Ian Dees <[email protected]>
Update DATA_UPDATES.md

000fc3a37281a6ae79da84eece51e59fe0556027 authored over 9 years ago by Ian Dees <[email protected]>
if no acs release is specified, look harder for a table instead of failing if it's not in the 1-year. Closes censusreporter/censusreporter#131

babcc7f18bcf3769d931e5575882ed53037ed3ea authored over 9 years ago by Joe Germuska <[email protected]>
often don't bother with memcache for local dev so comment it out

ecc34234fdaa9248cb191fd1f6d2de2783670e35 authored over 9 years ago by Joe Germuska <[email protected]>
pass even more search characters, since otherwise some places are unfindable. censusreporter/censusreporter#133

4644e447a95e48eae1b8e95129e57d7f7f7e13e8 authored over 9 years ago by Joe Germuska <[email protected]>
be more precise in input cleaning. closes censusreporter/censusreporter#133

9597623398bb080f1f9c3c98a28cbd00f6131f3b authored over 9 years ago by Joe Germuska <[email protected]>
add a bit more. closes #32

e1e75ac3b675c1c60aa770fddf4961deab7d75ae authored over 9 years ago by Joe Germuska <[email protected]>
remove references to the elasticsearch API pieces since we don't really have a solid handle on that atm

d4fbc04713de0f9b9dc2b0121058c2a9d2cd08a1 authored over 9 years ago by Joe Germuska <[email protected]>
Merge pull request #31 from censusreporter/consistent_decimals

Missed a couple spots where ST_AsGeoJSON needed precision specified

2c302827ee9ea90252f4acfcdd55e591b4a5eb49 authored over 9 years ago by Ian Dees <[email protected]>
Missed a couple spots where ST_AsGeoJSON needed precision specified

Fixes https://github.com/censusreporter/censusreporter/issues/125

ab1e9cf2d9549b4e5939581ae82f625fa723b79f authored over 9 years ago by Ian Dees <[email protected]>
Merge pull request #30 from censusreporter/specified_release

Respect the requested ACS release when expanding geoids

05f1a3b7bbecfb38304d9bee47ae1c9eee94cb28 authored over 9 years ago by Ian Dees <[email protected]>
Pass the desired release through

0a946fcdb2a473749e626c9c710ad12c38e53e15 authored over 9 years ago by Ian Dees <[email protected]>
Respect the requested ACS release when expanding geoids

7187e6c25cda01677239d2784f4769b941fcee90 authored over 9 years ago by Ian Dees <[email protected]>
bump up download limit to 3500 to allow type queries

88b9947c79107203ee76d8e8f13eabbdcdde2022 authored over 9 years ago by Ryan Pitts <[email protected]>
Lowercase the geo elasticsearch query

d091b119a61f65159abdf5e0fa34d8cefa127563 authored over 9 years ago by Ian Dees <[email protected]>
redirect root to API doc

e98ebf85fdf00a9b141771eadcb4dcea4425b4ea authored over 9 years ago by Joe Germuska <[email protected]>
Finish an incomplete sentence

efda8052a9e6aff41a8fe3a86ab188e5ecfaae25 authored over 9 years ago by Joe Germuska <[email protected]>
Bump up the limits a bit.

8da9691b0113089d8565174643ab673e3b295c4e authored over 9 years ago by Ian Dees <[email protected]>
Merge branch 'master' of github.com:censusreporter/census-api

f6308ee4a390df781e012e43358dd26c5148ee21 authored over 9 years ago by Joe Germuska <[email protected]>
implement 'small fix by Audrius Kažukauskas' as described in http://flask.pocoo.org/snippets/56/#comment-box

c2a3292a8eb81e3fae668cd58a7c0a36504c07da authored over 9 years ago by Joe Germuska <[email protected]>
Try disabling read timeouts to quiet logs

ffcdc9569ef7e704b1cb18aea608ff1aab5e763c authored over 9 years ago by Ian Dees <[email protected]>