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: 26 Top 5 largest taxi zones: Zone_ID Zone_Name Zone_Area_in_Square_Kilometers ======= =========================== ============================== 23 Bloomfield/Emerson Hill 19.6376 132 JFK Airport 18.2026 118 Heartland Village/Todt Hill 17.1140 44 Charleston/Tottenville 13.5363 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.615740 Brooklyn Bay Ridge YCAB 1 -74.016340 40.709830 Manhattan Battery Park City-Lower Manhattan NYC 4 -74.016190 40.715000 Manhattan Battery Park City-Lower Manhattan NYC 5 -74.015920 40.715140 Manhattan Battery Park City-Lower Manhattan NYC 3 -74.015810 40.714870 Manhattan Battery Park City-Lower Manhattan NYC 1 -74.015200 40.714190 Manhattan Battery Park City-Lower Manhattan YCAB 4 -74.014320 40.712480 Manhattan Battery Park City-Lower Manhattan YCAB 2 -74.013920 40.711410 Manhattan Battery Park City-Lower Manhattan DDS 1 -74.013110 40.716480 Manhattan Battery Park City-Lower Manhattan LYFT 3 -74.012600 40.707500 Manhattan Battery Park City-Lower Manhattan YCAB 1 -74.012600 40.707500 Manhattan Battery Park City-Lower Manhattan CMT 1 -74.012050 40.702900 Manhattan Battery Park City-Lower Manhattan CMT 1 -74.010640 40.710900 Manhattan Battery Park City-Lower Manhattan CMT 1 -74.010590 40.711810 Manhattan Battery Park City-Lower Manhattan YCAB 1 -74.010570 40.711460 Manhattan Battery Park City-Lower Manhattan NYC 1 -74.010350 40.715210 Manhattan SoHo-TriBeCa-Civic Center-Little Italy CMT 2 -74.010290 40.711650 Manhattan Battery Park City-Lower Manhattan YCAB 1 -74.010210 40.719910 Manhattan SoHo-TriBeCa-Civic Center-Little Italy CMT 1 -74.010160 40.712010 Manhattan Battery Park City-Lower Manhattan CMT 1 -74.010160 40.711300 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.009670 40.710410 Manhattan Battery Park City-Lower Manhattan CMT 1 -74.009620 40.710290 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 ============= ============= ============= ====== ============ LineString LineString 0 0 1 LineString LineString 0 0 1 Point Point 1 0 1 Polygon Polygon 0 1 0