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

rowcounts endpoint gets slugs as keys

a417f4659d16ecd11bfbe4252ee4fafb03f536b7 authored over 11 years ago by Ryan Pitts <[email protected]>
remove reference to census_names_simple in compare endpoint

16de4f71e1ea65dda9a9b42ae6434801e3a5e0c8 authored over 11 years ago by Ryan Pitts <[email protected]>
Sometimes the geojson row will be empty.

dd84abcdb21fc449a90409f90a7ed41ebb352ddd authored over 11 years ago by Ian Dees <[email protected]>
Point to the staging database for dev work.

655276477ecdd3b86dfca3191bcbb67ecb94a8eb authored over 11 years ago by Ian Dees <[email protected]>
Add a table details endpoint.

3dbf7ada336c94be74ee8900cadd67a46a18d928 authored over 11 years ago by Ian Dees <[email protected]>
Fix table search duplicates.

bf3f80fccf771e3ee71ba6a5e9990a9a36c99e4e authored over 11 years ago by Ian Dees <[email protected]>
order table search response by table_id

b78075944005e7a5146567d837e284899249ce63 authored over 11 years ago by Ryan Pitts <[email protected]>
Remove the LIMIT 25 on table search.

42b9e14f791e97232eb7d43e85d94a5c80560bb3 authored over 11 years ago by Ian Dees <[email protected]>
Redo the '*' special case for table search.

6b4ba97232837fc69c76081cce1b72e5751dc577 authored over 11 years ago by Ian Dees <[email protected]>
Include the universe again...

5a0bc60ecfcb9903eaf092cd5c487270c923170f authored over 11 years ago by Ian Dees <[email protected]>
Set the search path above the special case.

2fd28aed4a7882d9ffe0139850e62c490cf43c4e authored over 11 years ago by Ian Dees <[email protected]>
Huh, wonder where this commit went. Guess I'll do it again.

2fa7e0ca3d7733bc12db3c408b596d1b6575d344 authored over 11 years ago by Ian Dees <[email protected]>
Special case on the table search to dump all tables.

8a364aad95d434cfe99a5d18d8eb9da49f40cdb3 authored over 11 years ago by Ian Dees <[email protected]>
guess universe ought to be in the query, too

eb2b25a185c2dc6e1ba8ea175d9c5e0afe89e67e authored over 11 years ago by Ryan Pitts <[email protected]>
add universe, unique_key to table search response

b1321ed8b9b39318eba452fc092f690db9c584ab authored over 11 years ago by Ryan Pitts <[email protected]>
Sort the table search by len(table_id) then alpha.

dae6563916dc6781135bb5183a3caaf7682cdd2c authored over 11 years ago by Ian Dees <[email protected]>
Add denominator column ID to the compare API results.

dc4249a400579b04bb65cc2bda634d122da1068c authored over 11 years ago by Ian Dees <[email protected]>
Add simple table name to the table search API.

716bd240b1cbcd2222a015bbf8ba4381b9c3f8c6 authored over 11 years ago by Ian Dees <[email protected]>
Join the column and table metadata based on the new schema.

7bb3fe22329b6e9bab7ad080ca7f5e38acb9d439 authored over 11 years ago by Ian Dees <[email protected]>
Add topics to the table/column search results.

de8e8bcb579f54800e852e76ae07635e27dc4c1b authored over 11 years ago by Ian Dees <[email protected]>
add 010 to PARENT_CHILD_CONTAINMENT

94ce1cf68ecb9f9d88ccfdf1a2f3dee6507aad2c authored over 11 years ago by Ryan Pitts <[email protected]>
rowcount and compare endpoints account for sumlevs with zero results

45cf5bdc05cb67c264d8caeb32ce11532c6c6a14 authored over 11 years ago by Ryan Pitts <[email protected]>
Join on the census_names view to use the normalized geoid column.

8026d1d6df447e6001a22ba2d63dd466770b59ea authored over 11 years ago by Ian Dees <[email protected]>
fix search path in rowcount

bee1142e721c5a4c1d3f3ed812a8caa5c12ecf3d authored over 11 years ago by Ryan Pitts <[email protected]>
add Ian's geo prefix/GIS method to rowcount endpoint

390510bf26b5d30b7d2249a44492d22f0600bdb3 authored over 11 years ago by Ryan Pitts <[email protected]>
I suck at Python.

6d96db576dad759c8714909290a10b205143c7be authored over 11 years ago by Ian Dees <[email protected]>
Add native area sumlevel and use the full census view instead of the simplified one.

0f1cf5f412084cd210ecb2af9e932a37071ee9d1 authored over 11 years ago by Ian Dees <[email protected]>
match qwarg name for sumlev

cb0d5cd4b9ebee53bfadb0ae29cc2f1a16eba76a authored over 11 years ago by Ryan Pitts <[email protected]>
Used the wrong variable name here.

937470d73e13f00445f360a39b55ca4a366f09fa authored over 11 years ago by Ian Dees <[email protected]>
Use Joe's parent/child containment dict.

70f7360d3d36e8d5d79b651fb20309a63da14f59 authored over 11 years ago by Ian Dees <[email protected]>
CDPs can be bounded by states.

ae054814c8603ff334e7f909d4db08354e31d37d authored over 11 years ago by Ian Dees <[email protected]>
Build a full name for the geo search response.

b5dce1c8705241bfb87fa38fba9cb44aa401b02c authored over 11 years ago by Ian Dees <[email protected]>
for parents too

d97538d27dfc49aed5c777ebc414ad8a2e52dd4a authored over 11 years ago by Ryan Pitts <[email protected]>
uppercase column IDs in child data

685690ef8775b22e25adba3655b8178dcc059ab5 authored over 11 years ago by Ryan Pitts <[email protected]>
flip islander/other in profile response

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

1b7202d034dc96175515e84564683d1308c1887f authored over 11 years ago by Ryan Pitts <[email protected]>
order table columns in response

497aeead3fe042c65fd236a32fcbe417640ee204 authored over 11 years ago by Ryan Pitts <[email protected]>
Don't make duplicate calls for parent geoheader info.

dfa1ac972fe3e5f9064fcb972005c59ea528bfa1 authored over 11 years ago by Ian Dees <[email protected]>
Fix the child geoid prefix building.

3e18fc41cef30ef9a856cb292aee385644312c9b authored over 11 years ago by Ian Dees <[email protected]>
Clean up some pylint stuff.

738fb50028cd8f59e5c51ec84ee6e1c0010df2d4 authored over 11 years ago by Ian Dees <[email protected]>
Try to optimize the parent/child relationship calculation when possible.

0668cfe51bab72f2859d7e26978e844cba92e29f authored over 11 years ago by Ian Dees <[email protected]>
Allow null names/plurals in instead of blank strings.

2d38021d8da3a390baa073702da9452972ef9b44 authored over 11 years ago by Ian Dees <[email protected]>
Ditch dead endpoint.

45179c28b745dcb6aafe8328c86e8b80a399e421 authored over 11 years ago by Ian Dees <[email protected]>
Use TIGER/PostGIS to find parent/children.

211f854b10bd3f8888ea09d4545cb1c199d9636b authored over 11 years ago by Ian Dees <[email protected]>
nope, sort rowcounts on client

b6cfdc8f739f710a11dc921c37e438a65d4ca07d authored over 11 years ago by Ryan Pitts <[email protected]>
merge

d5eb174ee358bcf481efe0ebed88e208e82fbdc6 authored over 11 years ago by Ryan Pitts <[email protected]>
rowcount api endpoint returns a list

6c51c6af965e8a1e96a7eb07f6902704020831ca authored over 11 years ago by Ryan Pitts <[email protected]>
Fix config module names.

1d27cf4823765a9511ab79dc8d4d57cddb8475cb authored over 11 years ago by Ian Dees <[email protected]>
Use a config module to point to the development DB.

d3a29559907f280f666db80072643b95f7671e37 authored over 11 years ago by Ian Dees <[email protected]>
Parse the GeoJSON returned by PostGIS instead of putting it in a string.

61381e95210036e3c3e5cc817ac6d368420ddbf6 authored over 11 years ago by Ian Dees <[email protected]>
Add query arg validation code.

353c4418f45d3465461089ea5b8936038e360266 authored over 11 years ago by Ian Dees <[email protected]>
Remove trailing whitespace.

e91734fd7412c438c5dd0d8e5dccd0ffda613a7f authored over 11 years ago by Ian Dees <[email protected]>
Remove the demo geo_comparison endpoint.

951ed5515816601b216803b97c4bd536641a62e6 authored over 11 years ago by Ian Dees <[email protected]>
order table rowcount response by release with most results

ca0fd778a67cb56498ccce34065fdc199d27dce9 authored over 11 years ago by Ryan Pitts <[email protected]>
bump up geo search to 25 results

630d188265892b1e3cc339d1ff85e9e70caa987f authored over 11 years ago by Ryan Pitts <[email protected]>
add sumlev filter in geosearch

dd64b27b3987497ef3ed25e8187ae7a883c22896 authored over 11 years ago by Ryan Pitts <[email protected]>
note to self: no

8a7294f92fb91c99074da1b9691d52eca4eca81e authored over 11 years ago by Ryan Pitts <[email protected]>
fix str formatting

32aedf642a7d771aa5317cec4e75e222a752b5ad authored over 11 years ago by Ryan Pitts <[email protected]>
tuple the things

ed4f309609ab16774e682f1c8c64534079e94393 authored over 11 years ago by Ryan Pitts <[email protected]>
var referenced before assignment

4669dae8e557a343f9877436472f89cb28dc1fc8 authored over 11 years ago by Ryan Pitts <[email protected]>
table search endpoint

d1e7675f90947c41e66268c9f018452a040b30fd authored over 11 years ago by Ryan Pitts <[email protected]>
function params match url params

abcbfac88a7e39023f19c6818345a5a314ba43dd authored over 11 years ago by Ryan Pitts <[email protected]>
more consistent url scheme for table lookups

e8d10985f07b69afdb657a979971f16b92845212 authored over 11 years ago by Ryan Pitts <[email protected]>
return rowcount in compare endpoint

acd9a238a13c87f13932c73fd0cd52ebfc865224 authored over 11 years ago by Ryan Pitts <[email protected]>
handle releases where table doesn't exist

c250cb3520f7ab8f6ba0383d0a966976e0ca1b77 authored over 11 years ago by Ryan Pitts <[email protected]>
dump count straight into results attr

eba27fe6fbd0b58bcf6b9e4576e239b11f202776 authored over 11 years ago by Ryan Pitts <[email protected]>
didn't even have to ask Ian about this one. boom.

5c510da603f61df5855c4eeb83e4338b7c944014 authored over 11 years ago by Ryan Pitts <[email protected]>
add count endpoint for comparison api

281d50d2f6ba48435712e1c677a05a058ce0b0a3 authored over 11 years ago by Ryan Pitts <[email protected]>
Add fabric to the requirements.

179bf1b0f81b0a5b9f7afb1ac21e2259a47f9151 authored over 11 years ago by Ian Dees <[email protected]>
OH COME ON

349f42d8746eb7ae523206808989c16796691fae authored over 11 years ago by Ryan Pitts <[email protected]>
nooooooooo not again

7fbd6dacc27f149600df42f589adbecd82b2f8e7 authored over 11 years ago by Ryan Pitts <[email protected]>
escape the other %

2a057f51bd20ad1f4c8197bdf6c47e3fe230c4c7 authored over 11 years ago by Ryan Pitts <[email protected]>
escape the %s

8602e3eb431c973e64a3e33e63f136004c8b40c9 authored over 11 years ago by Ryan Pitts <[email protected]>
params into a tuple

a9800067b9d5fa487604aa2362169bc7f1664c88 authored over 11 years ago by Ryan Pitts <[email protected]>
remove uncessary quoting

8f68eab4a23507799cad9f9235311f82f4a3989b authored over 11 years ago by Ryan Pitts <[email protected]>
validated_table_id

6779534f2ab8f1f1f04188afa80eda556a3c0e67 authored over 11 years ago by Ryan Pitts <[email protected]>
params on queries

43dc544b2368c66ead265cbc2c62ec39c7af3099 authored over 11 years ago by Ryan Pitts <[email protected]>
revert to search path

a26e8816db15967a78746f4e486cb42a380e1174 authored over 11 years ago by Ryan Pitts <[email protected]>
explicit table names

647e8ac0dd9e16ec805d7e9803db769964c037cb authored over 11 years ago by Ryan Pitts <[email protected]>
return basic metadata about requested comparison

b57b318be8db287ace12a5dccb0ef8adbef9c072 authored over 11 years ago by Ryan Pitts <[email protected]>
fix var name

0c55f15ab9099285b6fa607927a4b615ba42bbb3 authored over 11 years ago by Ryan Pitts <[email protected]>
column indent information in response

d48bd785bf3ad9922e176adf9fd1d03b386a73c3 authored over 11 years ago by Ryan Pitts <[email protected]>
handle missing geometries

b5f40012a0a769876d7769605b641eae90fb8f9d authored over 11 years ago by Ryan Pitts <[email protected]>
pop n lock

df255da79a0bc8d2680c10d71d5e55bf9f1eb7ff authored over 11 years ago by Ryan Pitts <[email protected]>
herp derp

2b9ab92bb54019a84ab2ed71ae181fe077e18173 authored over 11 years ago by Ryan Pitts <[email protected]>
fetch parent data too

f68034846e4701bfb185887f8e5afe07852a1877 authored over 11 years ago by Ryan Pitts <[email protected]>
grr

9a02be157eeef955e105694fcad0f22380496564 authored over 11 years ago by Ryan Pitts <[email protected]>
declare ordered dicts

b4e254e54dcbea834c23939f2319babaec3d9d95 authored over 11 years ago by Ryan Pitts <[email protected]>
parent geography object structure mimic child object

c17b518b68199dd055f8698b09f6b864e39ab09a authored over 11 years ago by Ryan Pitts <[email protected]>
preserve ordering when inserting into ordered dicts

571476f52e7d325f47b964a13967a0ccee05e4ee authored over 11 years ago by Ryan Pitts <[email protected]>
ordered dicts for comparison response

5976979fdad0b07a049614b1b254b334d6a30f1f authored over 11 years ago by Ryan Pitts <[email protected]>
add summary level to child items

d7d5c82033494cec0942abd57d067c81452cd8ee authored over 11 years ago by Ryan Pitts <[email protected]>
no sort_keys

6579b7bef4ad32aa564c21dac9e948b8ebb83d47 authored over 11 years ago by Ryan Pitts <[email protected]>
prettier json

4e484c485b4ea9cdd849279aa3c5bdfcdd426ab5 authored over 11 years ago by Ryan Pitts <[email protected]>
pull the geometry from child geodata map

e4eef445c6649c8a6589dafa8d81741ffc5001ec authored over 11 years ago by Ryan Pitts <[email protected]>
necessary formatting on parent sumlev

8bb21c9c65056669034ae5fab2ad1525f068f76e authored over 11 years ago by Ryan Pitts <[email protected]>
check sumlevel when fetching tiger data

4f910d1d9ecf19ab35b6c0f6f95906c9435a25d4 authored over 11 years ago by Ryan Pitts <[email protected]>
make child_geodata_map

505d50c59fec055c8a18a125cb6c726466604ede authored over 11 years ago by Ryan Pitts <[email protected]>
or maybe a tuple...

94bb6fa014dbee583666b60a35c4101a0718b24b authored over 11 years ago by Ryan Pitts <[email protected]>
we should make child geoid list a set for query

3ffe3d7a668586fbd4804c2ae427259510c89009 authored over 11 years ago by Ryan Pitts <[email protected]>