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.615738 Brooklyn Bay Ridge YCAB 1 -74.016342 40.709831 Manhattan Battery Park City-Lower Manhattan NYC 4 -74.016190 40.714996 Manhattan Battery Park City-Lower Manhattan NYC 5 -74.015923 40.715141 Manhattan Battery Park City-Lower Manhattan NYC 3 -74.015808 40.714867 Manhattan Battery Park City-Lower Manhattan NYC 1 -74.015198 40.714191 Manhattan Battery Park City-Lower Manhattan YCAB 4 -74.014320 40.712483 Manhattan Battery Park City-Lower Manhattan YCAB 2 -74.013924 40.711407 Manhattan Battery Park City-Lower Manhattan DDS 1 -74.013115 40.716476 Manhattan Battery Park City-Lower Manhattan LYFT 3 -74.012604 40.707497 Manhattan Battery Park City-Lower Manhattan YCAB 1 -74.012604 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.710895 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.010292 40.711651 Manhattan Battery Park City-Lower Manhattan YCAB 1 -74.010208 40.719913 Manhattan SoHo-TriBeCa-Civic Center-Little Italy CMT 1 -74.010162 40.711304 Manhattan Battery Park City-Lower Manhattan CMT 1 -74.010162 40.712013 Manhattan Battery Park City-Lower Manhattan YCAB 1 -74.009972 40.705219 Manhattan Battery Park City-Lower Manhattan YCAB 1 -74.009788 40.705189 Manhattan Battery Park City-Lower Manhattan YCAB 1 -74.009727 40.722118 Manhattan SoHo-TriBeCa-Civic Center-Little Italy NYC 1 -74.009674 40.710415 Manhattan Battery Park City-Lower Manhattan CMT 1 -74.009621 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 ============= ============= ============= ====== ============ LineString LineString 0 0 1 LineString LineString 0 0 1 Point Point 1 0 1 Polygon Polygon 0 1 0