GEOSPATIAL EXAMPLES OUTPUT ========================== CREATING A TABLE AND INSERTING WKT DATA --------------------------------------- Table created: OK Number of records inserted: 4 SCALAR FUNCTIONS ---------------- Number of trips where geographic distance < recorded distance: 33 Top 5 largest taxi zones: Zone_ID Zone_Name Zone_Area_in_Square_Kilometers ======= =========================== ============================== 23 Bloomfield/Emerson Hill 19.6376 132 JFK Airport 18.2025 118 Heartland Village/Todt Hill 17.1140 44 Charleston/Tottenville 13.5326 2 Jamaica Bay 13.3225 GEOSPATIAL AGGREGATIONS ----------------------- Queens neighborhood boundaries dissolved: OK GEOSPATIAL JOINS ---------------- Subset of pickup point neighborhood locations: Vendor ID Pass. Count Pickup Long. Pickup Lat. Borough NTA ========== ============ ============= ============ =========== =========================================== CMT 1 -74.034180 40.615738 Brooklyn Bay Ridge YCAB 1 -74.016340 40.709830 Manhattan Battery Park City-Lower Manhattan NYC 4 -74.016190 40.714996 Manhattan Battery Park City-Lower Manhattan NYC 5 -74.015920 40.715140 Manhattan Battery Park City-Lower Manhattan NYC 3 -74.015810 40.714867 Manhattan Battery Park City-Lower Manhattan NYC 1 -74.015200 40.714190 Manhattan Battery Park City-Lower Manhattan YCAB 4 -74.014320 40.712482 Manhattan Battery Park City-Lower Manhattan YCAB 2 -74.013920 40.711407 Manhattan Battery Park City-Lower Manhattan DDS 1 -74.013115 40.716476 Manhattan Battery Park City-Lower Manhattan LYFT 3 -74.012600 40.707497 Manhattan Battery Park City-Lower Manhattan YCAB 1 -74.012600 40.707497 Manhattan Battery Park City-Lower Manhattan CMT 1 -74.012054 40.702896 Manhattan Battery Park City-Lower Manhattan CMT 1 -74.010635 40.710896 Manhattan Battery Park City-Lower Manhattan CMT 1 -74.010590 40.711815 Manhattan Battery Park City-Lower Manhattan YCAB 1 -74.010574 40.711460 Manhattan Battery Park City-Lower Manhattan NYC 1 -74.010345 40.715206 Manhattan SoHo-TriBeCa-Civic Center-Little Italy CMT 2 -74.010290 40.711650 Manhattan Battery Park City-Lower Manhattan YCAB 1 -74.010210 40.719913 Manhattan SoHo-TriBeCa-Civic Center-Little Italy CMT 1 -74.010160 40.711304 Manhattan Battery Park City-Lower Manhattan CMT 1 -74.010160 40.712013 Manhattan Battery Park City-Lower Manhattan YCAB 1 -74.009970 40.705220 Manhattan Battery Park City-Lower Manhattan YCAB 1 -74.009790 40.705190 Manhattan Battery Park City-Lower Manhattan YCAB 1 -74.009730 40.722120 Manhattan SoHo-TriBeCa-Civic Center-Little Italy NYC 1 -74.009674 40.710415 Manhattan Battery Park City-Lower Manhattan CMT 1 -74.009620 40.710285 Manhattan Battery Park City-Lower Manhattan Top 10 neighborhood pickup locations: Pickup NTA Total Pickups =========================================== ============== Midtown-Midtown South 192 Hudson Yards-Chelsea-Flatiron-Union Square 93 Upper East Side-Carnegie Hill 83 Turtle Bay-East Midtown 72 West Village 71 SoHo-TriBeCa-Civic Center-Little Italy 59 Upper West Side 48 Murray Hill-Kips Bay 47 Lincoln Square 44 Lenox Hill-Roosevelt Island 41 Top 10 neighborhood pickup geos: Total Trip Distance Pickup Geo =================== ================================================== 262.90 MULTIPOLYGON (((-73.74712154262473 40.637162275... 206.08 MULTIPOLYGON (((-73.89008921667376 40.773626435... 74.47 MULTIPOLYGON (((-73.96802436915853 40.759578140... 54.52 MULTIPOLYGON (((-73.98225528672133 40.757387364... 51.76 MULTIPOLYGON (((-74.00860085403333 40.711392239... 51.65 MULTIPOLYGON (((-73.99799957540135 40.698797685... 49.58 MULTIPOLYGON (((-73.98411754823196 40.754842053... 45.53 MULTIPOLYGON (((-74.00530986129975 40.721824191... 43.09 MULTIPOLYGON (((-73.9877690594583 40.7497870294... 42.04 MULTIPOLYGON (((-73.98088709894269 40.753480988... GEOSPATIAL EQUALITY ------------------- Comparing ST_ALMOSTEQUALS(), ST_EQUALS(), and ST_EQUALSEXACT(): Source_1_Type Source_2_Type Almost_Equals Equals Equals_Exact ============= ============= ============= ====== ============ ST_LineString ST_LineString 0 0 1 ST_LineString ST_LineString 0 0 1 ST_Point ST_Point 1 0 1 ST_Polygon ST_Polygon 0 1 0