sf-trees

Data source: data.sfgov.org

Custom SQL query returning 24 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
23489 247849 2 5 152 Chapman St 1 17 1 1     15     6009118.007540001 2098230.0964599997 37.74185503078979 -122.41107154552401 (37.7418550307898, -122.411071545524)
25663 188593 2 5 1 20th St 1 17 1 1     27     6010961.38996 2104652.9831 37.759594070921004 -122.40514986509899 (37.759594070921, -122.405149865099)
31230 187779 2 5 230 Middle Point Rd 2 17 1 1     5 Width 6ft   6018271.33931 2096490.0449 37.737586251210104 -122.379301134458 (37.7375862512101, -122.379301134458)
44107 188705 2 5 1998 Revere Ave 2 17 1 1     3     6013030.362000001 2095929.4873 37.7357566623473 -122.397382506903 (37.7357566623473, -122.397382506903)
49102 248109 2 5 138 Rutledge St 3 17 1 1     24     6010416.26244 2099462.28287 37.7453110660681 -122.406669396477 (37.7453110660681, -122.406669396477)
53119 175069 2 5 101 Woolsey St 6 17 1 1     20     6011573.1556 2092162.2260200002 37.7253313074768 -122.402155892479 (37.7253313074768, -122.402155892479)
56158 247931 2 5 1099 Esmeralda Ave 4 17 1 1     6     6010377.81236 2098773.8118 37.7434185228518 -122.406753840137 (37.7434185228518, -122.406753840137)
65626 247850 2 5 152 Chapman St 2 17 1 1     42     6009080.756440001 2098231.91815 37.7418579436943 -122.41120047681801 (37.7418579436943, -122.411200476818)
66596 248070 2 5 20 Rutledge St 4 17 1 1     13     6010599.59932 2099402.0661 37.745155979779504 -122.406031203374 (37.7451559797795, -122.406031203374)
69221 247529 2 5 1101 Waller St 10 17 1 1     2     6000073.75314 2108487.72588 37.7695086378454 -122.44308003233499 (37.7695086378454, -122.443080032335)
130643 247527 2 5 1101 Waller St 8 17 1 1     2     6000059.53834 2108484.86365 37.769499968379705 -122.443128995021 (37.7694999683797, -122.443128995021)
132984 175066 2 5 800 Thornton Ave 1 17 1 1     8     6010981.076169999 2094029.55145 37.73042552801979 -122.40433403878599 (37.7304255280198, -122.404334038786)
133560 247858 2 5 82 Bradford St 1 17 1 1     12     6009570.7437 2098077.6511 37.7414618274161 -122.40949536852501 (37.7414618274161, -122.409495368525)
156377 247522 2 5 1101 Waller St 3 17 1 1     10     6000010.6242 2108472.60358 37.7694635161602 -122.443297305835 (37.7694635161602, -122.443297305835)
159551 247520 2 5 1101 Waller St 1 17 1 1     14     6000003.99995 2108482.26842 37.7694896756401 -122.443320913055 (37.7694896756401, -122.443320913055)
165964 175067 2 5 800 Thornton Ave 2 17 1 1     26     6010979.40226 2094033.66945 37.730436741644894 -122.404340115499 (37.7304367416449, -122.404340115499)
172072 187778 2 5 230 Middle Point Rd 1 17 1 1     2 Width 6ft   6018276.18855 2096495.79876 37.7376023175876 -122.37928476769899 (37.7376023175876, -122.379284767699)
172088 125288 2 5 943 Green St 11 17 1 1     1     6008674.79926 2118995.08989 37.7988459853112 -122.41407270821101 (37.7988459853112, -122.414072708211)
176347 125277 2 5 1285 Greenwich St 2 17 1 1     10     6006721.71386 2119753.35883 37.800818109519206 -122.420884898228 (37.8008181095192, -122.420884898228)
179049 175068 2 5 101 Woolsey St 5 17 1 1     5     6011564.90281 2092154.99462 37.7253109908919 -122.402183913575 (37.7253109908919, -122.402183913575)
181186 175070 2 5 104 Woolsey St 2 17 1 1     14     6011561.993480001 2092186.33195 37.725396874350096 -122.40219617312599 (37.7253968743501, -122.402196173126)
181546 125276 2 5 1285 Greenwich St 1 17 1 1     15     6006714.64641 2119759.73621 37.800835221824 -122.420909807645 (37.800835221824, -122.420909807645)
182693 187780 2 5 230 Middle Point Rd 3 17 1 1     4 Width 6ft   6018250.04699 2096453.9006400001 37.7374858320104 -122.379372242948 (37.7374858320104, -122.379372242948)
185208 247934 2 5 1099 Esmeralda Ave 7 17 1 1     14     6010311.02519 2098743.98721 37.7433328939103 -122.406982672633 (37.7433328939103, -122.406982672633)
Powered by Datasette · Query took 8.066ms · Data source: data.sfgov.org