Census Tract as Aggregation Field

[cmc333333]

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]

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

I'll be adding this to a milestone.

[marcesher]

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

[cmc333333]

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

[marcesher]

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