api icon indicating copy to clipboard operation
api copied to clipboard

Census Tract as Aggregation Field

Open cmc333333 opened this issue 11 years ago • 4 comments

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?

cmc333333 avatar Jun 02 '14 14:06 cmc333333

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

I'll be adding this to a milestone.

dezzie avatar Jun 02 '14 14:06 dezzie

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

marcesher avatar Jun 02 '14 15:06 marcesher

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?

cmc333333 avatar Jun 02 '14 15:06 cmc333333

@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.

marcesher avatar Jun 02 '14 15:06 marcesher