cfpb / api

Documentation to support upcoming data platform API and data sets
http://cfpb.github.io/api/hmda/
31 stars 73 forks source link

Census Tract as Aggregation Field #35

Open cmc333333 opened 10 years ago

cmc333333 commented 10 years ago

Right now, the UI (and maybe Qu?) doesn't allow aggregations over census tract (because it's a number maybe?). Combined with state and county, the census tract id because uniquely identifiable across the US.

Not sure if this is as simple as using a string to represent the census tract?

dezzie commented 10 years ago

Hey CM, can you upload a screenshot of which UI you're referring to?

I'll be adding this to a milestone.

marcesher commented 10 years ago

@cmc333333 If you can provide the URL to the query, that's helpful as well

cmc333333 commented 10 years ago

screen shot 2014-06-02 at 11 43 16 am

I'd like to aggregate by state, county, and census tract (as a single query). Does that make sense?

marcesher commented 10 years ago

@cmc333333 Ah. We removed the ability to aggregate on census tract some time ago as it caused significant problems when run unconstrained (i.e. aggregating across all states / msas without a filter). When we upgrade mongo, we can revisit it, as we'll be moving to the aggregation framework and away from map reduce. You can help us test it.