{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "%matplotlib inline" ] }, { "cell_type": "code", "execution_count": 33, "metadata": { "collapsed": false }, "outputs": [], "source": [ "import geopandas as gpd\n", "import pandas as pd\n", "import numpy as np\n", "import seaborn\n", "import dask.dataframe as dd\n", "from matplotlib import pyplot as plt" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": true }, "outputs": [], "source": [ "bike = dd.read_parquet('/bigdata/citibike.parquet')" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | trip_duration | \n", "start_time | \n", "stop_time | \n", "start_station_id | \n", "start_station_name | \n", "start_station_latitude | \n", "start_station_longitude | \n", "end_station_id | \n", "end_station_name | \n", "end_station_latitude | \n", "end_station_longitude | \n", "bike_id | \n", "user_type | \n", "birth_year | \n", "gender | \n", "start_taxizone_id | \n", "end_taxizone_id | \n", "start_ct_id | \n", "end_ct_id | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "634 | \n", "2013-07-01 00:00:00 | \n", "2013-07-01 00:10:34 | \n", "164 | \n", "E 47 St & 2 Ave | \n", "40.753231 | \n", "-73.970322 | \n", "504 | \n", "1 Ave & E 15 St | \n", "40.732220 | \n", "-73.981659 | \n", "16950 | \n", "Customer | \n", "NaN | \n", "0 | \n", "233.0 | \n", "224.0 | \n", "1432.0 | \n", "2158.0 | \n", "
1 | \n", "1547 | \n", "2013-07-01 00:00:02 | \n", "2013-07-01 00:25:49 | \n", "388 | \n", "W 26 St & 10 Ave | \n", "40.749718 | \n", "-74.002953 | \n", "459 | \n", "W 20 St & 11 Ave | \n", "40.746746 | \n", "-74.007759 | \n", "19816 | \n", "Customer | \n", "NaN | \n", "0 | \n", "246.0 | \n", "246.0 | \n", "2098.0 | \n", "2098.0 | \n", "
2 | \n", "178 | \n", "2013-07-01 00:01:04 | \n", "2013-07-01 00:04:02 | \n", "293 | \n", "Lafayette St & E 8 St | \n", "40.730286 | \n", "-73.990768 | \n", "237 | \n", "E 11 St & 2 Ave | \n", "40.730473 | \n", "-73.986725 | \n", "14548 | \n", "Subscriber | \n", "1980.0 | \n", "2 | \n", "113.0 | \n", "79.0 | \n", "1472.0 | \n", "861.0 | \n", "
3 | \n", "1580 | \n", "2013-07-01 00:01:06 | \n", "2013-07-01 00:27:26 | \n", "531 | \n", "Forsyth St & Broome St | \n", "40.718941 | \n", "-73.992661 | \n", "499 | \n", "Broadway & W 60 St | \n", "40.769154 | \n", "-73.981918 | \n", "16063 | \n", "Customer | \n", "NaN | \n", "0 | \n", "148.0 | \n", "142.0 | \n", "1475.0 | \n", "1346.0 | \n", "
4 | \n", "757 | \n", "2013-07-01 00:01:10 | \n", "2013-07-01 00:13:47 | \n", "382 | \n", "University Pl & E 14 St | \n", "40.734928 | \n", "-73.992004 | \n", "410 | \n", "Suffolk St & Stanton St | \n", "40.720665 | \n", "-73.985176 | \n", "19213 | \n", "Subscriber | \n", "1986.0 | \n", "1 | \n", "113.0 | \n", "148.0 | \n", "969.0 | \n", "929.0 | \n", "
\n", " | start_station_latitude | \n", "start_station_longitude | \n", "start_ct_id | \n", "
---|---|---|---|
1676 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
2545 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
3113 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
3329 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
3339 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
3419 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
3711 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
3763 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
4049 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
4243 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
4269 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
4317 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
4360 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
4569 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
4583 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
4586 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
4739 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
4741 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
4841 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
5139 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
7740 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
7900 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
8311 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
8742 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
10987 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
12882 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
12998 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
13134 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
13675 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
14201 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
38192 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
38269 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
38289 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
38290 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
38291 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
38298 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
38498 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
38626 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
39191 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
39680 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
39681 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
40174 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
40248 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
41768 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
43287 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
45198 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
45480 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
46523 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
47132 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
47215 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
47216 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
47264 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
47330 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
48096 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
48097 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
48183 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
48654 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
48706 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
48762 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
51071 | \n", "40.720875 | \n", "-73.980858 | \n", "9.0 | \n", "
74799 rows × 3 columns
\n", "\n", " | biketrip_count | \n", "
---|---|
start_ct_id | \n", "\n", " |
9 | \n", "74799 | \n", "
10 | \n", "430761 | \n", "
11 | \n", "242609 | \n", "
12 | \n", "474650 | \n", "
13 | \n", "228317 | \n", "
14 | \n", "131138 | \n", "
15 | \n", "257177 | \n", "
16 | \n", "142856 | \n", "
17 | \n", "241261 | \n", "
18 | \n", "178008 | \n", "
20 | \n", "132012 | \n", "
21 | \n", "672318 | \n", "
22 | \n", "27447 | \n", "
23 | \n", "38145 | \n", "
24 | \n", "85521 | \n", "
25 | \n", "3139 | \n", "
26 | \n", "47407 | \n", "
27 | \n", "7187 | \n", "
29 | \n", "4636 | \n", "
30 | \n", "40977 | \n", "
31 | \n", "21306 | \n", "
33 | \n", "2023 | \n", "
54 | \n", "56658 | \n", "
55 | \n", "1103 | \n", "
56 | \n", "37623 | \n", "
63 | \n", "4940 | \n", "
64 | \n", "5573 | \n", "
65 | \n", "12196 | \n", "
80 | \n", "2734 | \n", "
82 | \n", "3622 | \n", "
... | \n", "... | \n", "
2037 | \n", "473707 | \n", "
2040 | \n", "262070 | \n", "
2043 | \n", "63137 | \n", "
2047 | \n", "19787 | \n", "
2048 | \n", "42559 | \n", "
2063 | \n", "2997 | \n", "
2081 | \n", "23797 | \n", "
2082 | \n", "50779 | \n", "
2090 | \n", "11260 | \n", "
2095 | \n", "511843 | \n", "
2098 | \n", "705033 | \n", "
2099 | \n", "308199 | \n", "
2100 | \n", "496842 | \n", "
2101 | \n", "148639 | \n", "
2102 | \n", "421357 | \n", "
2103 | \n", "215798 | \n", "
2104 | \n", "114130 | \n", "
2112 | \n", "166862 | \n", "
2123 | \n", "17863 | \n", "
2124 | \n", "11633 | \n", "
2133 | \n", "42592 | \n", "
2146 | \n", "135173 | \n", "
2148 | \n", "64526 | \n", "
2152 | \n", "246529 | \n", "
2155 | \n", "100156 | \n", "
2156 | \n", "34091 | \n", "
2157 | \n", "100684 | \n", "
2158 | \n", "436600 | \n", "
2163 | \n", "42561 | \n", "
2164 | \n", "57101 | \n", "
309 rows × 1 columns
\n", "\n", " | BoroCT2010 | \n", "BoroCode | \n", "BoroName | \n", "CDEligibil | \n", "CT2010 | \n", "CTLabel | \n", "NTACode | \n", "NTAName | \n", "PUMA | \n", "Shape_Area | \n", "Shape_Leng | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "5000900 | \n", "5 | \n", "Staten Island | \n", "I | \n", "000900 | \n", "9 | \n", "SI22 | \n", "West New Brighton-New Brighton-St. George | \n", "3903 | \n", "2.497010e+06 | \n", "7729.016729 | \n", "POLYGON ((962269.1260375977 173705.5001831055,... | \n", "
1 | \n", "5012500 | \n", "5 | \n", "Staten Island | \n", "I | \n", "012500 | \n", "125 | \n", "SI22 | \n", "West New Brighton-New Brighton-St. George | \n", "3903 | \n", "4.954936e+06 | \n", "10582.855530 | \n", "POLYGON ((951998.5532226562 168438.0043945312,... | \n", "
2 | \n", "5013301 | \n", "5 | \n", "Staten Island | \n", "E | \n", "013301 | \n", "133.01 | \n", "SI22 | \n", "West New Brighton-New Brighton-St. George | \n", "3903 | \n", "7.217847e+05 | \n", "3428.312676 | \n", "POLYGON ((951720.9486083984 170488.4069824219,... | \n", "
3 | \n", "5019700 | \n", "5 | \n", "Staten Island | \n", "I | \n", "019700 | \n", "197 | \n", "SI07 | \n", "Westerleigh | \n", "3903 | \n", "3.231720e+06 | \n", "9097.697226 | \n", "POLYGON ((947819.2308349609 164190.0209960938,... | \n", "
4 | \n", "5002002 | \n", "5 | \n", "Staten Island | \n", "I | \n", "002002 | \n", "20.02 | \n", "SI14 | \n", "Grasmere-Arrochar-Ft. Wadsworth | \n", "3902 | \n", "8.501224e+06 | \n", "12591.725901 | \n", "POLYGON ((966615.2556152344 158662.2927856445,... | \n", "
5 | \n", "5006400 | \n", "5 | \n", "Staten Island | \n", "I | \n", "006400 | \n", "64 | \n", "SI14 | \n", "Grasmere-Arrochar-Ft. Wadsworth | \n", "3902 | \n", "7.643184e+06 | \n", "12726.360406 | \n", "POLYGON ((963023.891784668 158246.7521972656, ... | \n", "
6 | \n", "5007400 | \n", "5 | \n", "Staten Island | \n", "I | \n", "007400 | \n", "74 | \n", "SI14 | \n", "Grasmere-Arrochar-Ft. Wadsworth | \n", "3902 | \n", "5.788238e+06 | \n", "9902.948475 | \n", "POLYGON ((967656.8290405273 155637.1314086914,... | \n", "
7 | \n", "5018701 | \n", "5 | \n", "Staten Island | \n", "I | \n", "018701 | \n", "187.01 | \n", "SI07 | \n", "Westerleigh | \n", "3903 | \n", "4.267476e+06 | \n", "8626.771269 | \n", "POLYGON ((950555.9412231445 161453.658203125, ... | \n", "
8 | \n", "1002202 | \n", "1 | \n", "Manhattan | \n", "I | \n", "002202 | \n", "22.02 | \n", "MN28 | \n", "Lower East Side | \n", "3809 | \n", "6.039223e+05 | \n", "3817.391631 | \n", "POLYGON ((990284.3284301758 201838.3563842773,... | \n", "
9 | \n", "1003200 | \n", "1 | \n", "Manhattan | \n", "I | \n", "003200 | \n", "32 | \n", "MN22 | \n", "East Village | \n", "3809 | \n", "2.334190e+06 | \n", "6358.386684 | \n", "POLYGON ((989819.2963867188 204093.9949951172,... | \n", "
10 | \n", "1006800 | \n", "1 | \n", "Manhattan | \n", "I | \n", "006800 | \n", "68 | \n", "MN21 | \n", "Gramercy | \n", "3808 | \n", "1.877943e+06 | \n", "5723.883037 | \n", "POLYGON ((989553.9097900391 209596.7955932617,... | \n", "
11 | \n", "1008900 | \n", "1 | \n", "Manhattan | \n", "I | \n", "008900 | \n", "89 | \n", "MN13 | \n", "Hudson Yards-Chelsea-Flatiron-Union Square | \n", "3807 | \n", "1.782279e+06 | \n", "5578.769499 | \n", "POLYGON ((984534.7501831055 210565.4451904297,... | \n", "
12 | \n", "1009600 | \n", "1 | \n", "Manhattan | \n", "E | \n", "009600 | \n", "96 | \n", "MN17 | \n", "Midtown-Midtown South | \n", "3807 | \n", "1.887288e+06 | \n", "5737.356247 | \n", "POLYGON ((990440.5057983398 215405.0643920898,... | \n", "
13 | \n", "1009800 | \n", "1 | \n", "Manhattan | \n", "I | \n", "009800 | \n", "98 | \n", "MN19 | \n", "Turtle Bay-East Midtown | \n", "3808 | \n", "1.906016e+06 | \n", "5534.199811 | \n", "POLYGON ((994133.507019043 214848.8975830078, ... | \n", "
14 | \n", "1010000 | \n", "1 | \n", "Manhattan | \n", "I | \n", "010000 | \n", "100 | \n", "MN19 | \n", "Turtle Bay-East Midtown | \n", "3808 | \n", "1.860938e+06 | \n", "5692.168488 | \n", "POLYGON ((993108.3057861328 216013.1307983398,... | \n", "
15 | \n", "1010200 | \n", "1 | \n", "Manhattan | \n", "I | \n", "010200 | \n", "102 | \n", "MN17 | \n", "Midtown-Midtown South | \n", "3807 | \n", "1.860993e+06 | \n", "5687.802579 | \n", "POLYGON ((992216.5391845703 216507.6870117188,... | \n", "
16 | \n", "1010400 | \n", "1 | \n", "Manhattan | \n", "I | \n", "010400 | \n", "104 | \n", "MN17 | \n", "Midtown-Midtown South | \n", "3807 | \n", "1.864600e+06 | \n", "5693.036118 | \n", "POLYGON ((991325.8814086914 217001.6885986328,... | \n", "
17 | \n", "1011201 | \n", "1 | \n", "Manhattan | \n", "I | \n", "011201 | \n", "112.01 | \n", "MN17 | \n", "Midtown-Midtown South | \n", "3807 | \n", "8.561644e+05 | \n", "3716.146785 | \n", "POLYGON ((991725.2440185547 217725.2991943359,... | \n", "
18 | \n", "1011202 | \n", "1 | \n", "Manhattan | \n", "I | \n", "011202 | \n", "112.02 | \n", "MN17 | \n", "Midtown-Midtown South | \n", "3807 | \n", "8.395258e+05 | \n", "3688.762328 | \n", "POLYGON ((992615.8984375 217228.1416015625, 99... | \n", "
19 | \n", "1011203 | \n", "1 | \n", "Manhattan | \n", "I | \n", "011203 | \n", "112.03 | \n", "MN19 | \n", "Turtle Bay-East Midtown | \n", "3808 | \n", "8.540825e+05 | \n", "3701.173031 | \n", "POLYGON ((993507.2319946289 216732.0338134766,... | \n", "
20 | \n", "1011300 | \n", "1 | \n", "Manhattan | \n", "I | \n", "011300 | \n", "113 | \n", "MN17 | \n", "Midtown-Midtown South | \n", "3807 | \n", "1.890907e+06 | \n", "5699.860641 | \n", "POLYGON ((988650.2766113281 214286.4022216797,... | \n", "
21 | \n", "1011402 | \n", "1 | \n", "Manhattan | \n", "I | \n", "011402 | \n", "114.02 | \n", "MN40 | \n", "Upper East Side-Carnegie Hill | \n", "3805 | \n", "1.063547e+06 | \n", "4125.256100 | \n", "POLYGON ((994013.2479858398 217645.299621582, ... | \n", "
22 | \n", "1013000 | \n", "1 | \n", "Manhattan | \n", "I | \n", "013000 | \n", "130 | \n", "MN40 | \n", "Upper East Side-Carnegie Hill | \n", "3805 | \n", "1.918145e+06 | \n", "5807.972956 | \n", "POLYGON ((994920.1096191406 221386.2695922852,... | \n", "
23 | \n", "1014000 | \n", "1 | \n", "Manhattan | \n", "I | \n", "014000 | \n", "140 | \n", "MN40 | \n", "Upper East Side-Carnegie Hill | \n", "3805 | \n", "1.925984e+06 | \n", "5820.815640 | \n", "POLYGON ((996728.3079833984 222545.6896362305,... | \n", "
24 | \n", "1014200 | \n", "1 | \n", "Manhattan | \n", "I | \n", "014200 | \n", "142 | \n", "MN40 | \n", "Upper East Side-Carnegie Hill | \n", "3805 | \n", "1.927688e+06 | \n", "5821.704944 | \n", "POLYGON ((995836.4956054688 223039.7406005859,... | \n", "
25 | \n", "1014601 | \n", "1 | \n", "Manhattan | \n", "I | \n", "014601 | \n", "146.01 | \n", "MN32 | \n", "Yorkville | \n", "3805 | \n", "7.998799e+05 | \n", "4016.133393 | \n", "POLYGON ((998271.5236206055 222317.6588134766,... | \n", "
26 | \n", "1014602 | \n", "1 | \n", "Manhattan | \n", "I | \n", "014602 | \n", "146.02 | \n", "MN32 | \n", "Yorkville | \n", "3805 | \n", "1.175339e+06 | \n", "4528.695483 | \n", "POLYGON ((998660.5087890625 223021.3121948242,... | \n", "
27 | \n", "1014801 | \n", "1 | \n", "Manhattan | \n", "I | \n", "014801 | \n", "148.01 | \n", "MN40 | \n", "Upper East Side-Carnegie Hill | \n", "3805 | \n", "5.592162e+05 | \n", "3135.951423 | \n", "POLYGON ((996994.3508300781 223026.0794067383,... | \n", "
28 | \n", "1014802 | \n", "1 | \n", "Manhattan | \n", "I | \n", "014802 | \n", "148.02 | \n", "MN40 | \n", "Upper East Side-Carnegie Hill | \n", "3805 | \n", "1.351365e+06 | \n", "4691.029341 | \n", "POLYGON ((997637.4860229492 224187.0347900391,... | \n", "
29 | \n", "1015300 | \n", "1 | \n", "Manhattan | \n", "I | \n", "015300 | \n", "153 | \n", "MN14 | \n", "Lincoln Square | \n", "3806 | \n", "1.872393e+06 | \n", "5674.292342 | \n", "POLYGON ((990644.7542114258 221597.942199707, ... | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2136 | \n", "2021800 | \n", "2 | \n", "Bronx | \n", "E | \n", "021800 | \n", "218 | \n", "BX08 | \n", "West Farms-Bronx River | \n", "3709 | \n", "3.460969e+06 | \n", "9122.453686 | \n", "POLYGON ((1021107.376037598 243458.9674072266,... | \n", "
2137 | \n", "2024000 | \n", "2 | \n", "Bronx | \n", "E | \n", "024000 | \n", "240 | \n", "BX37 | \n", "Van Nest-Morris Park-Westchester Square | \n", "3704 | \n", "2.577349e+06 | \n", "7190.177079 | \n", "POLYGON ((1021556.863220215 246239.2802124023,... | \n", "
2138 | \n", "2006000 | \n", "2 | \n", "Bronx | \n", "E | \n", "006000 | \n", "60 | \n", "BX75 | \n", "Crotona Park East | \n", "3705 | \n", "3.413187e+06 | \n", "7818.412089 | \n", "POLYGON ((1017867.582641602 245337.3627929688,... | \n", "
2139 | \n", "2006200 | \n", "2 | \n", "Bronx | \n", "E | \n", "006200 | \n", "62 | \n", "BX08 | \n", "West Farms-Bronx River | \n", "3709 | \n", "2.035611e+06 | \n", "7175.713453 | \n", "POLYGON ((1019153.905639648 243875.9155883789,... | \n", "
2140 | \n", "3030300 | \n", "3 | \n", "Brooklyn | \n", "E | \n", "030300 | \n", "303 | \n", "BK79 | \n", "Ocean Hill | \n", "4007 | \n", "2.690240e+06 | \n", "6898.560842 | \n", "POLYGON ((1008188.862182617 185753.8187866211,... | \n", "
2141 | \n", "3036501 | \n", "3 | \n", "Brooklyn | \n", "E | \n", "036501 | \n", "365.01 | \n", "BK79 | \n", "Ocean Hill | \n", "4007 | \n", "1.369715e+06 | \n", "5483.369156 | \n", "POLYGON ((1008957.26940918 185699.4918212891, ... | \n", "
2142 | \n", "3079602 | \n", "3 | \n", "Brooklyn | \n", "E | \n", "079602 | \n", "796.02 | \n", "BK60 | \n", "Prospect Lefferts Gardens-Wingate | \n", "4011 | \n", "1.453525e+06 | \n", "5043.967955 | \n", "POLYGON ((996507.9182128906 176285.0225830078,... | \n", "
2143 | \n", "3082000 | \n", "3 | \n", "Brooklyn | \n", "E | \n", "082000 | \n", "820 | \n", "BK60 | \n", "Prospect Lefferts Gardens-Wingate | \n", "4011 | \n", "1.599913e+06 | \n", "5582.419306 | \n", "POLYGON ((998104.8178100586 178068.6047973633,... | \n", "
2144 | \n", "3082200 | \n", "3 | \n", "Brooklyn | \n", "E | \n", "082200 | \n", "822 | \n", "BK60 | \n", "Prospect Lefferts Gardens-Wingate | \n", "4011 | \n", "1.827423e+06 | \n", "5792.844437 | \n", "POLYGON ((997439.182800293 176336.3872070312, ... | \n", "
2145 | \n", "1003400 | \n", "1 | \n", "Manhattan | \n", "I | \n", "003400 | \n", "34 | \n", "MN22 | \n", "East Village | \n", "3809 | \n", "1.718946e+06 | \n", "5503.345191 | \n", "POLYGON ((990340.0073852539 205029.4624023438,... | \n", "
2146 | \n", "3090000 | \n", "3 | \n", "Brooklyn | \n", "E | \n", "090000 | \n", "900 | \n", "BK81 | \n", "Brownsville | \n", "4007 | \n", "2.645351e+06 | \n", "6709.231083 | \n", "POLYGON ((1007479.828186035 181438.7852172852,... | \n", "
2147 | \n", "3000900 | \n", "3 | \n", "Brooklyn | \n", "I | \n", "000900 | \n", "9 | \n", "BK09 | \n", "Brooklyn Heights-Cobble Hill | \n", "4004 | \n", "1.737777e+06 | \n", "5883.375467 | \n", "POLYGON ((986838.3345947266 192326.7385864258,... | \n", "
2148 | \n", "3036100 | \n", "3 | \n", "Brooklyn | \n", "E | \n", "036100 | \n", "361 | \n", "BK79 | \n", "Ocean Hill | \n", "4007 | \n", "1.524421e+06 | \n", "6064.700108 | \n", "POLYGON ((1007864.663391113 183580.8475952148,... | \n", "
2149 | \n", "3078200 | \n", "3 | \n", "Brooklyn | \n", "E | \n", "078200 | \n", "782 | \n", "BK91 | \n", "East Flatbush-Farragut | \n", "4010 | \n", "1.811374e+06 | \n", "5948.145346 | \n", "POLYGON ((1001592.999633789 171330.1213989258,... | \n", "
2150 | \n", "3083000 | \n", "3 | \n", "Brooklyn | \n", "E | \n", "083000 | \n", "830 | \n", "BK91 | \n", "East Flatbush-Farragut | \n", "4010 | \n", "2.171915e+06 | \n", "6600.753863 | \n", "POLYGON ((1000207.434997559 172073.5809936523,... | \n", "
2151 | \n", "1006000 | \n", "1 | \n", "Manhattan | \n", "I | \n", "006000 | \n", "60 | \n", "MN50 | \n", "Stuyvesant Town-Cooper Village | \n", "3808 | \n", "1.296018e+06 | \n", "5239.096008 | \n", "POLYGON ((991333.3630371094 207173.3526000977,... | \n", "
2152 | \n", "3031300 | \n", "3 | \n", "Brooklyn | \n", "E | \n", "031300 | \n", "313 | \n", "BK61 | \n", "Crown Heights North | \n", "4006 | \n", "1.832522e+06 | \n", "5465.787220 | \n", "POLYGON ((999740.874206543 186352, 999901.1726... | \n", "
2153 | \n", "3031500 | \n", "3 | \n", "Brooklyn | \n", "E | \n", "031500 | \n", "315 | \n", "BK61 | \n", "Crown Heights North | \n", "4006 | \n", "1.886108e+06 | \n", "5658.750760 | \n", "POLYGON ((998973.1525878906 186411.3536376953,... | \n", "
2154 | \n", "3019300 | \n", "3 | \n", "Brooklyn | \n", "E | \n", "019300 | \n", "193 | \n", "BK69 | \n", "Clinton Hill | \n", "4004 | \n", "2.903179e+06 | \n", "6981.649815 | \n", "POLYGON ((995501.4732055664 190827.6047973633,... | \n", "
2155 | \n", "3023300 | \n", "3 | \n", "Brooklyn | \n", "E | \n", "023300 | \n", "233 | \n", "BK75 | \n", "Bedford | \n", "4003 | \n", "1.849442e+06 | \n", "5438.790291 | \n", "POLYGON ((996695.8309936523 190462.5628051758,... | \n", "
2156 | \n", "1002800 | \n", "1 | \n", "Manhattan | \n", "E | \n", "002800 | \n", "28 | \n", "MN28 | \n", "Lower East Side | \n", "3809 | \n", "1.973562e+06 | \n", "5627.595336 | \n", "POLYGON ((991650.9154052734 204299.32421875, 9... | \n", "
2157 | \n", "1004400 | \n", "1 | \n", "Manhattan | \n", "I | \n", "004400 | \n", "44 | \n", "MN50 | \n", "Stuyvesant Town-Cooper Village | \n", "3808 | \n", "4.277454e+06 | \n", "9684.842507 | \n", "(POLYGON ((994681.4056396484 203127.6748046875... | \n", "
2158 | \n", "4137700 | \n", "4 | \n", "Queens | \n", "I | \n", "137700 | \n", "1377 | \n", "QN42 | \n", "Oakland Gardens | \n", "4104 | \n", "8.038804e+06 | \n", "12085.908028 | \n", "POLYGON ((1052563.640808105 209850.8568115234,... | \n", "
2159 | \n", "4138502 | \n", "4 | \n", "Queens | \n", "I | \n", "138502 | \n", "1385.02 | \n", "QN99 | \n", "park-cemetery-etc-Queens | \n", "4104 | \n", "2.620882e+07 | \n", "48473.195704 | \n", "POLYGON ((1054368.627197266 217912.8056030273,... | \n", "
2160 | \n", "1028700 | \n", "1 | \n", "Manhattan | \n", "E | \n", "028700 | \n", "287 | \n", "MN35 | \n", "Washington Heights North | \n", "3801 | \n", "5.710876e+06 | \n", "12407.587938 | \n", "POLYGON ((1003963.362792969 255062.9552001953,... | \n", "
2161 | \n", "1029700 | \n", "1 | \n", "Manhattan | \n", "I | \n", "029700 | \n", "297 | \n", "MN99 | \n", "park-cemetery-etc-Manhattan | \n", "3801 | \n", "9.961849e+06 | \n", "20553.099113 | \n", "(POLYGON ((1004601.953430176 259027.5151977539... | \n", "
2162 | \n", "3000100 | \n", "3 | \n", "Brooklyn | \n", "I | \n", "000100 | \n", "1 | \n", "BK09 | \n", "Brooklyn Heights-Cobble Hill | \n", "4004 | \n", "2.237282e+06 | \n", "6527.281839 | \n", "POLYGON ((986764.3486328125 194584.6243896484,... | \n", "
2163 | \n", "3000301 | \n", "3 | \n", "Brooklyn | \n", "I | \n", "000301 | \n", "3.01 | \n", "BK09 | \n", "Brooklyn Heights-Cobble Hill | \n", "4004 | \n", "2.142139e+06 | \n", "6466.952122 | \n", "POLYGON ((985832.7232055664 193771.6766357422,... | \n", "
2164 | \n", "1023300 | \n", "1 | \n", "Manhattan | \n", "E | \n", "023300 | \n", "233 | \n", "MN04 | \n", "Hamilton Heights | \n", "3802 | \n", "2.535724e+06 | \n", "7136.778935 | \n", "POLYGON ((999389.0635986328 241090.4204101562,... | \n", "
2165 | \n", "1023700 | \n", "1 | \n", "Manhattan | \n", "E | \n", "023700 | \n", "237 | \n", "MN04 | \n", "Hamilton Heights | \n", "3802 | \n", "2.897558e+06 | \n", "7073.400099 | \n", "POLYGON ((1000029.442993164 242245.0491943359,... | \n", "
2166 rows × 12 columns
\n", "\n", " | LocationID | \n", "OBJECTID | \n", "Shape_Area | \n", "Shape_Leng | \n", "borough | \n", "geometry | \n", "zone | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "1 | \n", "0.000782 | \n", "0.116357 | \n", "EWR | \n", "POLYGON ((-74.18445299999996 40.6949959999999,... | \n", "Newark Airport | \n", "
1 | \n", "2 | \n", "2 | \n", "0.004866 | \n", "0.433470 | \n", "Queens | \n", "(POLYGON ((-73.82337597260663 40.6389870471767... | \n", "Jamaica Bay | \n", "
2 | \n", "3 | \n", "3 | \n", "0.000314 | \n", "0.084341 | \n", "Bronx | \n", "POLYGON ((-73.84792614099985 40.87134223399991... | \n", "Allerton/Pelham Gardens | \n", "
3 | \n", "4 | \n", "4 | \n", "0.000112 | \n", "0.043567 | \n", "Manhattan | \n", "POLYGON ((-73.97177410965318 40.72582128133705... | \n", "Alphabet City | \n", "
4 | \n", "5 | \n", "5 | \n", "0.000498 | \n", "0.092146 | \n", "Staten Island | \n", "POLYGON ((-74.17421738099989 40.56256808599987... | \n", "Arden Heights | \n", "
5 | \n", "6 | \n", "6 | \n", "0.000606 | \n", "0.150491 | \n", "Staten Island | \n", "POLYGON ((-74.06367318899999 40.60219816599994... | \n", "Arrochar/Fort Wadsworth | \n", "
6 | \n", "7 | \n", "7 | \n", "0.000390 | \n", "0.107417 | \n", "Queens | \n", "POLYGON ((-73.90413637799996 40.76752031699986... | \n", "Astoria | \n", "
7 | \n", "8 | \n", "8 | \n", "0.000027 | \n", "0.027591 | \n", "Queens | \n", "POLYGON ((-73.92334041500001 40.77512891199993... | \n", "Astoria Park | \n", "
8 | \n", "9 | \n", "9 | \n", "0.000338 | \n", "0.099784 | \n", "Queens | \n", "POLYGON ((-73.78502434699996 40.76103651599986... | \n", "Auburndale | \n", "
9 | \n", "10 | \n", "10 | \n", "0.000436 | \n", "0.099839 | \n", "Queens | \n", "POLYGON ((-73.7832662499999 40.68999429299992,... | \n", "Baisley Park | \n", "
10 | \n", "11 | \n", "11 | \n", "0.000265 | \n", "0.079211 | \n", "Brooklyn | \n", "POLYGON ((-74.00109809499993 40.60303462599992... | \n", "Bath Beach | \n", "
11 | \n", "12 | \n", "12 | \n", "0.000042 | \n", "0.036661 | \n", "Manhattan | \n", "POLYGON ((-74.01565756599994 40.70483308799993... | \n", "Battery Park | \n", "
12 | \n", "13 | \n", "13 | \n", "0.000149 | \n", "0.050281 | \n", "Manhattan | \n", "POLYGON ((-74.01244109299991 40.7190576729999,... | \n", "Battery Park City | \n", "
13 | \n", "14 | \n", "14 | \n", "0.001382 | \n", "0.175214 | \n", "Brooklyn | \n", "POLYGON ((-74.03407329297129 40.64431393298185... | \n", "Bay Ridge | \n", "
14 | \n", "15 | \n", "15 | \n", "0.000925 | \n", "0.144336 | \n", "Queens | \n", "POLYGON ((-73.7774039129087 40.79659824126783,... | \n", "Bay Terrace/Fort Totten | \n", "
15 | \n", "16 | \n", "16 | \n", "0.000872 | \n", "0.141292 | \n", "Queens | \n", "POLYGON ((-73.7685730499999 40.77910542899991,... | \n", "Bayside | \n", "
16 | \n", "17 | \n", "17 | \n", "0.000323 | \n", "0.093523 | \n", "Brooklyn | \n", "POLYGON ((-73.94306406899986 40.70142443499989... | \n", "Bedford | \n", "
17 | \n", "18 | \n", "18 | \n", "0.000149 | \n", "0.069800 | \n", "Bronx | \n", "POLYGON ((-73.88513907699999 40.86638287399992... | \n", "Bedford Park | \n", "
18 | \n", "19 | \n", "19 | \n", "0.000547 | \n", "0.101825 | \n", "Queens | \n", "POLYGON ((-73.72339596299987 40.75038907599986... | \n", "Bellerose | \n", "
19 | \n", "20 | \n", "20 | \n", "0.000135 | \n", "0.051440 | \n", "Bronx | \n", "POLYGON ((-73.88386792099986 40.8642908889999,... | \n", "Belmont | \n", "
20 | \n", "21 | \n", "21 | \n", "0.000380 | \n", "0.115974 | \n", "Brooklyn | \n", "POLYGON ((-73.97418385499991 40.6094635019999,... | \n", "Bensonhurst East | \n", "
21 | \n", "22 | \n", "22 | \n", "0.000472 | \n", "0.126170 | \n", "Brooklyn | \n", "POLYGON ((-73.99254973599997 40.62427426799996... | \n", "Bensonhurst West | \n", "
22 | \n", "23 | \n", "23 | \n", "0.002196 | \n", "0.290556 | \n", "Staten Island | \n", "POLYGON ((-74.19568609223377 40.63501686464005... | \n", "Bloomfield/Emerson Hill | \n", "
23 | \n", "24 | \n", "24 | \n", "0.000061 | \n", "0.047000 | \n", "Manhattan | \n", "POLYGON ((-73.95953658899998 40.7987185259999,... | \n", "Bloomingdale | \n", "
24 | \n", "25 | \n", "25 | \n", "0.000124 | \n", "0.047146 | \n", "Brooklyn | \n", "POLYGON ((-73.98155298299992 40.68914616399994... | \n", "Boerum Hill | \n", "
25 | \n", "26 | \n", "26 | \n", "0.000534 | \n", "0.123548 | \n", "Brooklyn | \n", "POLYGON ((-73.98331628499983 40.6414786819999,... | \n", "Borough Park | \n", "
26 | \n", "27 | \n", "27 | \n", "0.001341 | \n", "0.202509 | \n", "Queens | \n", "POLYGON ((-73.86522555399998 40.57045847199989... | \n", "Breezy Point/Fort Tilden/Riis Beach | \n", "
27 | \n", "28 | \n", "28 | \n", "0.000291 | \n", "0.097961 | \n", "Queens | \n", "POLYGON ((-73.79240413399991 40.71619304099993... | \n", "Briarwood/Jamaica Hills | \n", "
28 | \n", "29 | \n", "29 | \n", "0.000202 | \n", "0.071408 | \n", "Brooklyn | \n", "POLYGON ((-73.96004798699995 40.58326987199995... | \n", "Brighton Beach | \n", "
29 | \n", "30 | \n", "30 | \n", "0.000146 | \n", "0.094510 | \n", "Queens | \n", "POLYGON ((-73.82075892499992 40.61523267899991... | \n", "Broad Channel | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
233 | \n", "234 | \n", "234 | \n", "0.000073 | \n", "0.036072 | \n", "Manhattan | \n", "POLYGON ((-73.98996936399989 40.73490456699994... | \n", "Union Sq | \n", "
234 | \n", "235 | \n", "235 | \n", "0.000213 | \n", "0.076167 | \n", "Bronx | \n", "POLYGON ((-73.90947862999988 40.86180812899987... | \n", "University Heights/Morris Heights | \n", "
235 | \n", "236 | \n", "236 | \n", "0.000103 | \n", "0.044252 | \n", "Manhattan | \n", "POLYGON ((-73.95779380499984 40.77359989699993... | \n", "Upper East Side North | \n", "
236 | \n", "237 | \n", "237 | \n", "0.000096 | \n", "0.042213 | \n", "Manhattan | \n", "POLYGON ((-73.9661274729999 40.76217929999991,... | \n", "Upper East Side South | \n", "
237 | \n", "238 | \n", "238 | \n", "0.000185 | \n", "0.060109 | \n", "Manhattan | \n", "POLYGON ((-73.96884378999985 40.78596738899994... | \n", "Upper West Side North | \n", "
238 | \n", "239 | \n", "239 | \n", "0.000205 | \n", "0.063626 | \n", "Manhattan | \n", "POLYGON ((-73.97501417199996 40.78768560599987... | \n", "Upper West Side South | \n", "
239 | \n", "240 | \n", "240 | \n", "0.000722 | \n", "0.146070 | \n", "Bronx | \n", "POLYGON ((-73.87643743099994 40.89687059299995... | \n", "Van Cortlandt Park | \n", "
240 | \n", "241 | \n", "241 | \n", "0.000255 | \n", "0.068765 | \n", "Bronx | \n", "POLYGON ((-73.88840157099996 40.88441707499993... | \n", "Van Cortlandt Village | \n", "
241 | \n", "242 | \n", "242 | \n", "0.000360 | \n", "0.138136 | \n", "Bronx | \n", "POLYGON ((-73.83593362199987 40.84840635599993... | \n", "Van Nest/Morris Park | \n", "
242 | \n", "243 | \n", "243 | \n", "0.000438 | \n", "0.094331 | \n", "Manhattan | \n", "POLYGON ((-73.93156536999994 40.86958215799991... | \n", "Washington Heights North | \n", "
243 | \n", "244 | \n", "244 | \n", "0.000360 | \n", "0.080569 | \n", "Manhattan | \n", "POLYGON ((-73.94068822000003 40.85131543299985... | \n", "Washington Heights South | \n", "
244 | \n", "245 | \n", "245 | \n", "0.000466 | \n", "0.095983 | \n", "Staten Island | \n", "POLYGON ((-74.09787969199995 40.64035805499988... | \n", "West Brighton | \n", "
245 | \n", "246 | \n", "246 | \n", "0.000281 | \n", "0.069467 | \n", "Manhattan | \n", "POLYGON ((-74.00439976203513 40.76267135909888... | \n", "West Chelsea/Hudson Yards | \n", "
246 | \n", "247 | \n", "247 | \n", "0.000206 | \n", "0.092968 | \n", "Bronx | \n", "POLYGON ((-73.91222180499983 40.84235659099988... | \n", "West Concourse | \n", "
247 | \n", "248 | \n", "248 | \n", "0.000150 | \n", "0.056919 | \n", "Bronx | \n", "POLYGON ((-73.86393748099981 40.84004456599994... | \n", "West Farms/Bronx River | \n", "
248 | \n", "249 | \n", "249 | \n", "0.000072 | \n", "0.036384 | \n", "Manhattan | \n", "POLYGON ((-74.00250642399995 40.72901638499997... | \n", "West Village | \n", "
249 | \n", "250 | \n", "250 | \n", "0.000241 | \n", "0.079626 | \n", "Bronx | \n", "POLYGON ((-73.8455308949999 40.83917330699989,... | \n", "Westchester Village/Unionport | \n", "
250 | \n", "251 | \n", "251 | \n", "0.000626 | \n", "0.137711 | \n", "Staten Island | \n", "POLYGON ((-74.13107460299996 40.63114772899996... | \n", "Westerleigh | \n", "
251 | \n", "252 | \n", "252 | \n", "0.001025 | \n", "0.158004 | \n", "Queens | \n", "POLYGON ((-73.82049919995306 40.80101146781907... | \n", "Whitestone | \n", "
252 | \n", "253 | \n", "253 | \n", "0.000078 | \n", "0.036051 | \n", "Queens | \n", "POLYGON ((-73.83908354399988 40.76525691299991... | \n", "Willets Point | \n", "
253 | \n", "254 | \n", "254 | \n", "0.000360 | \n", "0.085886 | \n", "Bronx | \n", "POLYGON ((-73.85186563799999 40.87905886499989... | \n", "Williamsbridge/Olinville | \n", "
254 | \n", "255 | \n", "255 | \n", "0.000172 | \n", "0.062384 | \n", "Brooklyn | \n", "POLYGON ((-73.96176070375392 40.72522879205536... | \n", "Williamsburg (North Side) | \n", "
255 | \n", "256 | \n", "256 | \n", "0.000169 | \n", "0.067915 | \n", "Brooklyn | \n", "POLYGON ((-73.95834207500002 40.71330630099992... | \n", "Williamsburg (South Side) | \n", "
256 | \n", "257 | \n", "257 | \n", "0.000139 | \n", "0.058669 | \n", "Brooklyn | \n", "POLYGON ((-73.97984261899994 40.66072744099996... | \n", "Windsor Terrace | \n", "
257 | \n", "258 | \n", "258 | \n", "0.000366 | \n", "0.089013 | \n", "Queens | \n", "POLYGON ((-73.84504194899991 40.68931894699996... | \n", "Woodhaven | \n", "
258 | \n", "259 | \n", "259 | \n", "0.000395 | \n", "0.126750 | \n", "Bronx | \n", "POLYGON ((-73.85107116191899 40.91037152011096... | \n", "Woodlawn/Wakefield | \n", "
259 | \n", "260 | \n", "260 | \n", "0.000422 | \n", "0.133514 | \n", "Queens | \n", "POLYGON ((-73.9017537339999 40.76077547499995,... | \n", "Woodside | \n", "
260 | \n", "261 | \n", "261 | \n", "0.000034 | \n", "0.027120 | \n", "Manhattan | \n", "POLYGON ((-74.01332610899989 40.7050307879999,... | \n", "World Trade Center | \n", "
261 | \n", "262 | \n", "262 | \n", "0.000122 | \n", "0.049064 | \n", "Manhattan | \n", "(POLYGON ((-73.94383256699986 40.7828590889999... | \n", "Yorkville East | \n", "
262 | \n", "263 | \n", "263 | \n", "0.000066 | \n", "0.037017 | \n", "Manhattan | \n", "POLYGON ((-73.95218621999996 40.7730198449999,... | \n", "Yorkville West | \n", "
263 rows × 7 columns
\n", "