Report not found

There was a problem finding this report.
NYC Taxis - Distance Collinearity
June 24, 2014 · Refreshed almost 4 years ago
Description
Shows the relationship between the size of tracts' non-white population and their distance from Times Square in miles. Only includes tracts in New York County.

Collaborators

Run History
SELECT (DEGREES( ACOS( SIN(RADIANS(40.7577)) * SIN(RADIANS(latitude)) + COS(RADIANS(40.7577)) * COS(RADIANS(latitude)) * COS(RADIANS(-73.9857 - longitude)) ) ) * 60 * 1.1515) AS distance_in_miles, * FROM ( SELECT tract.county, tract.tract_code, income.median_income, people.population, people.white/people.population::FLOAT AS white_percent, (people.population - people.white)/people.population::FLOAT AS non_white_percent, AVG(tract.lat) AS latitude, AVG(tract.long) AS longitude, COUNT(*) AS trips FROM benn.nyc_taxi_data_june_week taxi JOIN benn.tract_lookup tract ON tract.lat = ROUND(taxi.pickup_latitude*1000)/1000 AND tract.long = ROUND(taxi.pickup_longitude*1000)/1000 AND tract.county = 'New York' JOIN benn.nyc_census_tract_incomes income ON income.county = tract.county AND income.tract_number = tract.tract_code AND income.median_income IS NOT NULL JOIN benn.nyc_census_tract_people people ON people.county = tract.county AND people.tract_number = tract.tract_code AND people.population >= 1000 WHERE taxi.pickup_latitude > 40 AND taxi.pickup_latitude < 41 AND taxi.pickup_longitude > -75 AND taxi.pickup_longitude < -73 GROUP BY 1,2,3,4,5,6 ) a ORDER BY 1
SELECT (DEGREES( ACOS( SIN(RADIANS(40.7577)) * SIN(RADIANS(latitude)) + COS(RADIANS(40.7577)) * COS(RADIANS(latitude)) * COS(RADIANS(-73.9857 - longitude)) ) ) * 60 * 1.1515) AS distance_in_miles, * FROM ( SELECT tract.county, tract.tract_code, income.median_income, people.population, people.white/people.population::FLOAT AS white_percent, (people.population - people.white)/people.population::FLOAT AS non_white_percent, AVG(tract.lat) AS latitude, AVG(tract.long) AS longitude, COUNT(*) AS trips FROM benn.nyc_taxi_data_june_week taxi JOIN benn.tract_lookup tract ON tract.lat = ROUND(taxi.pickup_latitude*1000)/1000 AND tract.long = ROUND(taxi.pickup_longitude*1000)/1000 AND tract.county = 'New York' JOIN benn.nyc_census_tract_incomes income ON income.county = tract.county AND income.tract_number = tract.tract_code AND income.median_income IS NOT NULL JOIN benn.nyc_census_tract_people people ON people.county = tract.county AND people.tract_number = tract.tract_code AND people.population >= 1000 WHERE taxi.pickup_latitude > 40 AND taxi.pickup_latitude < 41 AND taxi.pickup_longitude > -75 AND taxi.pickup_longitude < -73 GROUP BY 1,2,3,4,5,6 ) a ORDER BY 1
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="container mode-grid"> <div class="row"> <div class="col-md-12"> <mode-chart id="chart_53b8a0faf72a" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-12"> <mode-table id="table_993566d464c2" dataset="dataset" options="table_options"></mode-table> </div> </div> </div>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled