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

fix geoid format for tiger table query

c91eba87e288c382ec5b96fe0c629248c65aecb5 authored over 11 years ago by Ryan Pitts <[email protected]>
search path for table comparison

13642ed63e41d5ba02764d86cd453cef2af958cb authored over 11 years ago by Ryan Pitts <[email protected]>
add option for returning geometries in comparison response

1221b8da60b784c6924250e02a5170cf44e410da authored over 11 years ago by Ryan Pitts <[email protected]>
add map of column names to compare response

53a2fd591c574f14e5f73809d1eb54081bbf2e7e authored over 11 years ago by Ryan Pitts <[email protected]>
grrr, another thing I'd have caught if developing against the db

7c2b4badb8d42626f9827e5ea16115e65ff63ff0 authored over 11 years ago by Ryan Pitts <[email protected]>
fix mismatched var names

88e53d0ad3cc55abc32b513a2a30685dcba03bd9 authored over 11 years ago by Ryan Pitts <[email protected]>
aaaah, loop through the list, not the map

fd29d8c6f3731d056fdcfcb2b5f61113ebc34068 authored over 11 years ago by Ryan Pitts <[email protected]>
naming conflict

387179867d1bc9f560f0f9da3f41f83bb9804ef6 authored over 11 years ago by Ryan Pitts <[email protected]>
derp

a9ef90e3ee168ca2da1059d06104456bda20db47 authored over 11 years ago by Ryan Pitts <[email protected]>
update table comparison view

d93d3ed28620795f933644546b82605b1afe391e authored over 11 years ago by Ryan Pitts <[email protected]>
crossdomain on table test

04ba9bfa48a6b76e9603727974c6a2ef9ef85de7 authored over 11 years ago by Ryan Pitts <[email protected]>
add port so we don't clobber local change on the server

0bd1e050dbaac771912b42e2f05fbe9c389bb788 authored over 11 years ago by Ryan Pitts <[email protected]>
experimental table view

1e4f3e9bc1b8ece8d40e0ada24b87ba918f6b233 authored over 11 years ago by Ryan Pitts <[email protected]>
Adding water and land area to the geo search endpoint.

9890359a96807939611c5cdda04bae7a3f995910 authored over 11 years ago by Ian Dees <[email protected]>
Learning SQL...

ed95cb530bc1b81c5190503a839df8206567260a authored over 11 years ago by Ian Dees <[email protected]>
Fix syntax errors.

841096b9d202cc3aee7f8dfc97f609adda7c468b authored over 11 years ago by Ian Dees <[email protected]>
Use the census_names view instead of hardcoding the sumlevel mappings.

cc900b7db6dd5d5cabbbb2516976ea6d20111cb3 authored over 11 years ago by Ian Dees <[email protected]>
Have to use the correct words.

cab27c8b8d7649805ef4bf9466a0b96c352fa8de authored over 11 years ago by Ian Dees <[email protected]>
Only dump out the important stuff and floatize the intpt.

4cbdff7c59e45825d536e512fdd8e2faa6951bdc authored over 11 years ago by Ian Dees <[email protected]>
Fix the geoid lookup

9ee50b5ce235ac5d8a067b38ee6059f55683ba2a authored over 11 years ago by Ian Dees <[email protected]>
Add a tiger2012 geoid lookup.

14dfe55588570cea87bbd92a65e9e487d67b4d4e authored over 11 years ago by Ian Dees <[email protected]>
Don't simplify the geom so much.

7af92b4d12129453fb380cbc64950c7d58a1d08e authored over 11 years ago by Ian Dees <[email protected]>
Specify the schema for the census_names relations.

ebd996d33ff414f20a3e416df4f1de568cc8f0f0 authored over 11 years ago by Ian Dees <[email protected]>
Use a simplified census names view that doesn't use all TIGER data.

e2e1e0bfa5f5191257a9f74fec08268ad921dc11 authored over 11 years ago by Ian Dees <[email protected]>
Try simplifying less.

2c1048f848de7d7f24beb281b2c3f48341968fd8 authored over 11 years ago by Ian Dees <[email protected]>
Try including geometry when asked.

ec34cd8ebc7ec13e14d9099fc8b8eadc077c380b authored over 11 years ago by Ian Dees <[email protected]>
Looks like I missed some digits in the full geoid.

d3d53d747d68dfb117f8821e6636612a4c3808a3 authored over 11 years ago by Ian Dees <[email protected]>
Build a full geoid in the search response.

08cabd6720a6079a2c1067517c2049ab4282ce7e authored over 11 years ago by Ian Dees <[email protected]>
Forgot the wildcard for the LIKE operation.

4ee756dc2b272d9a9b0fdc9c210e30f5e00b15f5 authored over 11 years ago by Ian Dees <[email protected]>
Add CORS headers to the geo search API for now.

83fdbef2190c424e99c07c22da287b1ffed296d4 authored over 11 years ago by Ian Dees <[email protected]>
Attempt at a fullstack TIGER shape search endpoint.

8b5563b35f281e37415f85be09485ef3f87eea39 authored over 11 years ago by Ian Dees <[email protected]>
Hacky geo stack query.

0e407ff9b4c73f63fc96910bd0d6982137054109 authored over 11 years ago by Ian Dees <[email protected]>
Forgot to specify the schema.

1d915d3a87cf5cbb6461e4428f3ec8148c87024b authored over 11 years ago by Ian Dees <[email protected]>
Coerce lat/lon to floats.

bb215ac9072d9df65df9274e1a9d65399cbc5e2b authored over 11 years ago by Ian Dees <[email protected]>
Fix the bounds check.

15b6c2b835f62cafc31b476104c46fde821cce2d authored over 11 years ago by Ian Dees <[email protected]>
Fix my tiger endpoint.

efff1322b545d910f27a250d975ba80489221dca authored over 11 years ago by Ian Dees <[email protected]>
Merge branch 'master' of github.com:censusreporter/census-extractomatic

02e736bc347ff48f523e5b84e7b3d9cabffbd432 authored over 11 years ago by Ryan Pitts <[email protected]>
should have been a list for appending

a9ad699a2c8927027c249d524ccc783a0c4ec844 authored over 11 years ago by Ryan Pitts <[email protected]>
A really quick and dirty test of the TIGER data.

e7e3a7a9b29686019b901c7975e508b1d4748b43 authored over 11 years ago by Ian Dees <[email protected]>
add comparison dict to api response

77cf3e1c77c1677e830d6959d258007ae02e643a authored over 11 years ago by Ryan Pitts <[email protected]>
remove some ancient zeros

9915b832dd56ae6917f1ed6bd4d236a663394fc2 authored over 11 years ago by Ryan Pitts <[email protected]>
don't need to hit two tables for comparison

ef014da563e8ff6fd06894b60ebc17dc8cf3f32f authored over 11 years ago by Ryan Pitts <[email protected]>
set search_path in comparison

e529d079827baa7d69ad1f2fdd8fddc2c5c32df8 authored over 11 years ago by Ryan Pitts <[email protected]>
need some g

486cc9f0fbd4ef501a3304b06aeac1bb44b0bb58 authored over 11 years ago by Ryan Pitts <[email protected]>
escape the %

94564a1e11e246c48dcb189787a84249884e054e authored over 11 years ago by Ryan Pitts <[email protected]>
Adding newrelic stuff.

dc62da92a09ad1c0a6be175fad267ee6cbc28d99 authored over 11 years ago by Ian Dees <[email protected]>
Try using the generic item builder for everything.

baeeff9c33d181ff414caf8934899583733aeff0 authored over 11 years ago by Ian Dees <[email protected]>
Make a nullable division.

df015a47275555e296ead95c3351b461ee0e770a authored over 11 years ago by Ian Dees <[email protected]>
Merge branch 'master' of github.com:censusreporter/census-extractomatic

08ed555c85c697f1c596aa7a9cca792e6a4e990b authored over 11 years ago by Ryan Pitts <[email protected]>
wait, I think I flipped the division there

88127a7cb45889e6b92ddec5b1e64307ff208440 authored over 11 years ago by Ryan Pitts <[email protected]>
Try generalizing the item building process.

52c29c7d9f24092f40c9043c5123761e05ab3cfe authored over 11 years ago by Ian Dees <[email protected]>
use dif on mean travel time

1486a8242539f78c2fbc43cbae2b80a8c0a1a041 authored over 11 years ago by Ryan Pitts <[email protected]>
Merge branch 'master' of github.com:censusreporter/census-extractomatic

7128e41ef642c64101634abbacca93d4a84d9a81 authored over 11 years ago by Ryan Pitts <[email protected]>
add mean travel time

cb09717c3340a9c174ce7c4ece2f07a614243f98 authored over 11 years ago by Ryan Pitts <[email protected]>
Put the * 100 in the wrong spot.

be4b0bb023aebcb6d7abe53436f22d4d1980714e authored over 11 years ago by Ian Dees <[email protected]>
Merge branch 'master' of github.com:censusreporter/census-extractomatic

d0259c3bbf9faf4cf66afdbbf1e2b7d55ec5b082 authored over 11 years ago by Ryan Pitts <[email protected]>
maybe_percent needs floats

ec9886f94b9440e324099704e7dbbfe14dd43570 authored over 11 years ago by Ryan Pitts <[email protected]>
Try a null-safe subtract.

8ccafbe1fbb579a88e3d1a3a08a9a194f827d099 authored over 11 years ago by Ian Dees <[email protected]>
add persons_per_household to profile api

46d7494b2545996ae538320d25481bef2898c1fc authored over 11 years ago by Ryan Pitts <[email protected]>
Should have moved that paren, not deleted it.

675fdeb57863ea6110bb573421b45c7ccce640a6 authored over 11 years ago by Ian Dees <[email protected]>
Try to fix the extraneous paren.

994f0b6caf7aea5ad858f98064ee0b116cd9af26 authored over 11 years ago by Ian Dees <[email protected]>
only need to make one dict lookup for defauls acs value

69d4d28fd136fb7830a29f212244a9c1727e1e60 authored over 11 years ago by Ryan Pitts <[email protected]>
add acs name and data_years for profile api response

a6c83eea74a8052e9d03029e1f1a7b7909e189ff authored over 11 years ago by Ryan Pitts <[email protected]>
fabfile delete pyc on deploy

1318f6e17ed74b2639658639d342f8d779d2232a authored over 11 years ago by Ryan Pitts <[email protected]>
Use a function instead of division operator.

a85d741d018e56da0959b789a3efaec1b1274386 authored over 11 years ago by Ian Dees <[email protected]>
Fixing complaint about importing future from the beginning of the file.

dce4f877d01d139b618297c2303cfdcf90fa9ff2 authored over 11 years ago by Ian Dees <[email protected]>
Turn off flask debug because it doesn't appear to work anyway.

67629dc395c120b084f0a9c69602b8ccea9d487b authored over 11 years ago by Ian Dees <[email protected]>
Describe why we're importing division.

20bbefff1fcd2d5f59c63559045a0bf887e62d9e authored over 11 years ago by Ian Dees <[email protected]>
Also debug the app.

aa2ff586d7a74ed1027845d1e190dff5288e506c authored over 11 years ago by Ian Dees <[email protected]>
Fine! I'll put it in /tmp

a527d0bed2b06b810cbd0c63a4d0eae9e78f001d authored over 11 years ago by Ian Dees <[email protected]>
Add logging for warnings.

3f021b06a012e5f11401625234e2a68f8cf1a1a6 authored over 11 years ago by Ian Dees <[email protected]>
hit different table for percent_hispanic data

b0ba609abdbd32bd891fc46dbe9c9a3e53797367 authored over 11 years ago by Ryan Pitts <[email protected]>
hey ryan those should be floats not ints

1da16f6bb9e6207b4b3dbb8f249100c6fec36a47 authored over 11 years ago by Ryan Pitts <[email protected]>
pretty names for acs releases

396a6e631d5cd166e83edf6d1324aa8fcdd32b3b authored over 11 years ago by Ryan Pitts <[email protected]>
convert percentages; add median age

9e6fedd43f79c73de23348cce5491cd70f38d0ac authored over 11 years ago by Ryan Pitts <[email protected]>
Give the python path as part of the daemonprocess config.

48b01015e66a7255e1d43c44d52abe96f28e9be9 authored over 11 years ago by Ian Dees <[email protected]>
Pass the wsgi path into the template.

1663b506488ee01c5ae36c31a307e01de4dbeb0b authored over 11 years ago by Ian Dees <[email protected]>
Connect with a user/pass.

203f454c1666a873dc90adc37f2b2b8e9af9df69 authored over 11 years ago by Ian Dees <[email protected]>
Add activate this to the wsgi maybe?

bf63d915e8ca19dbfbfd9a58bc2cd3aa5d30ade8 authored over 11 years ago by Ian Dees <[email protected]>
Try shoving api stuff into its own daemon process.

a114e4204b1b2061090eb599fdc067be971017da authored over 11 years ago by Ian Dees <[email protected]>
Try to fix the wsgi.

77299c37e45fddc72ab8cf1a8bfcd9bb188c6824 authored over 11 years ago by Ian Dees <[email protected]>
Try to make the extractomatic dir a module.

a0c210b566a14974a50f583a8a07ebf437313f2a authored over 11 years ago by Ian Dees <[email protected]>
migrate geo_comparison into api.py

81c9b1d9b3e733623e079dab4ab5c7fcd6aa6ca2 authored over 11 years ago by Ryan Pitts <[email protected]>
summary --> profile language

39fac5cdc6622faf53751a58b56c64b8e16d8d62 authored over 11 years ago by Ryan Pitts <[email protected]>
add underscores, names and universes to profile api response

cc57efa74a9183ed657a44527b36d1d83a02d8d5 authored over 11 years ago by Ryan Pitts <[email protected]>
Move stuff around to try and make WSGI work.

c174bd74b389b578358da02410ac6040e10979e7 authored over 11 years ago by Ian Dees <[email protected]>
Modify fabfile to twiddle mod_wsgi bits.

a77b422e74d915efd917245482c785081ea8491a authored over 11 years ago by Ian Dees <[email protected]>
Add a couple required .debs

32976a97e782ef457f921629eb65e579c2f257fd authored over 11 years ago by Ian Dees <[email protected]>
Add fabfile and requirements.

3e8aac8035976b3a25f1897dac19fdcb5438e650 authored over 11 years ago by Ian Dees <[email protected]>
Add readme and gitignore.

a00a7374dc07548794f4af94dcd5ffa391371114 authored over 11 years ago by Ian Dees <[email protected]>
Flip the geoid and summary parts of the URL around.

d40d24f7aa8f57fda6fc8e0ad1d22c3b681c63b7 authored over 11 years ago by Ian Dees <[email protected]>
Switch to percentage instead of fraction.

0780f90bf019064f5a2f8160f4440a5c24aee7fe authored over 11 years ago by Ian Dees <[email protected]>
Copy paste error.

c65466f3cc4e7ef31a61f74edd98e4cd33dd37e4 authored over 11 years ago by Ian Dees <[email protected]>
Too many zeroes.

9e6ec5965b72eafa3654e767ea54e0c84e6af85d authored over 11 years ago by Ian Dees <[email protected]>
Add most of the other data columns.

a0760a59c04e0a487fa1f603e41530df587fc079 authored over 11 years ago by Ian Dees <[email protected]>
Add economics section.

9ac78007ba7bcccbcf6f58f75faa4c74559746fc authored over 11 years ago by Ian Dees <[email protected]>
More race data points.

97cb24d5947f43d5b857f492b64febb314843e09 authored over 11 years ago by Ian Dees <[email protected]>
Move the sub-categories around a little.

4196e272fd183cb89f38fe90d11a6364161ccac9 authored over 11 years ago by Ian Dees <[email protected]>
Need to query for the race table.

56be6d9143c8f49abad25e5fba4beb7405fe72b7 authored over 11 years ago by Ian Dees <[email protected]>
Add some other data points.

03cf9c69f46f631c2d3f7c5e61c2eadf086173bc authored over 11 years ago by Ian Dees <[email protected]>