sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
20974 109568 6 116 95 Nordhoff St 1 13 1 1         Permit Number 777169 6000348.8 2095645.6 37.734262946491704 -122.44120712981501 (37.7342629464917, -122.441207129815)
43173 112929 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
78522 112919 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
81040 112918 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
85824 112921 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
89530 112922 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
100331 112930 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
115520 112925 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
117865 112928 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
128076 112923 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
140824 112927 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
141641 112926 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
142904 112920 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
77818 108026 6 116 862 Kansas St   7 1 1         Permit Number 774734 6011570.0 2104296.0 37.758647879927395 -122.403019866682 (37.7586478799274, -122.403019866682)
12707 107222 2 116 327 Vienna St 1 1 1 1   09/29/2014 12:00:00 AM 3 6x5 Permit Number 773943 6003989.6035400005 2091508.12122 37.7231090719178 -122.42832491578301 (37.7231090719178, -122.428324915783)
106519 105769 2 116 1 Gonzalez Dr 1 7 1 1   02/24/2014 12:00:00 AM     Permit Number 772589 5990111.8 2090190.8 37.718696994740704 -122.476201051717 (37.7186969947407, -122.476201051717)
140384 104978 2 116 66X San Lorenzo Way 1 3 1 1         Permit Number 770332 5993690.5 2097533.7 37.7390656757525 -122.46436386193301 (37.7390656757525, -122.464363861933)
87470 102106 6 116 50X Noe St 8 7 1 1   12/19/2012 12:00:00 AM 25   Permit Number 769282 6002816.1 2107996.5 37.7683158318555 -122.433559261751 (37.7683158318555, -122.433559261751)
91222 98597 1 116 400X Steiner St 3 5 1 1         Permit Number 768529 6004639.0 2109849.0 37.7735056071657 -122.42738600543899 (37.7735056071657, -122.427386005439)
82219 97945 6 116 2 Mendosa Ave 1 7 1 1         Permit Number 768165 5993624.4 2101138.5 37.748959736293294 -122.464854121346 (37.7489597362933, -122.464854121346)
14101 96173 1 116     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767806          
50092 372 1 116 3711X 19th Ave 3 1 1 1   09/11/2008 12:00:00 AM 6 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
86905 88838 1 116 3711 19th Ave 14 1 1 1   09/11/2008 12:00:00 AM   3x3 Permit Number 51718 5990297.3 2090806.0 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889)
88885 370 1 116 3711X 19th Ave 1 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
92695 375 1 116 3711X 19th Ave 5 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
96847 376 1 116 3711X 19th Ave 8 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
101507 381 1 116 3711X 19th Ave 13 1 1 1   09/11/2008 12:00:00 AM 16 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
102899 373 1 116 3711X 19th Ave 4 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
105060 380 1 116 3711X 19th Ave 12 1 1 1   09/11/2008 12:00:00 AM 16 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
115004 88839 1 116 3711 19th Ave 15 1 1 1   09/11/2008 12:00:00 AM   3x3 Permit Number 51718 5990297.3 2090806.0 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889)
116977 371 1 116 3711X 19th Ave 2 1 1 1   09/11/2008 12:00:00 AM 6 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
117801 27532 1 116 3711X 19th Ave 7 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
122391 374 1 116 3711X 19th Ave 6 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
124243 378 1 116 3711X 19th Ave 10 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
125133 377 1 116 3711X 19th Ave 9 1 1 1   09/11/2008 12:00:00 AM 12 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
129416 379 1 116 3711X 19th Ave 11 1 1 1   09/11/2008 12:00:00 AM 3 3x3 Permit Number 51718 5990365.2788562 2091006.8640877 37.720952400174 -122.475384436189 (37.720952400174, -122.475384436189)
115065 87450 1 116 180 Castenada Ave 1 1 1 1   04/30/2008 12:00:00 AM   3x3 Permit Number 50376 5994470.9 2100852.3 37.748222673270895 -122.461906191942 (37.7482226732709, -122.461906191942)
86911 87150 6 116 4 Bellair Pl 2 13 1 1         Permit Number 50135 6010093.0 2120950.0 37.8042932388788 -122.409303278994 (37.8042932388788, -122.409303278994)
60930 52819 1 116 1327@ JUDAH 28th Ave 1 1 1 1     4   Permit Number 48844 5987385.2929 2106232.8495 37.7625857382219 -122.48680274332399 (37.7625857382219, -122.486802743324)
175534 39823 1 116 2190 46th Ave 2 1 1 1 1 01/06/1999 12:00:00 AM 1   Permit Number 41149 5982046.2311 2100191.8316 37.7456860925771 -122.50482065715099 (37.7456860925771, -122.504820657151)
177016 39822 1 116 2190 46th Ave 3 1 1 1 1 01/06/1999 12:00:00 AM 1   Permit Number 41149 5982045.5543 2100206.3838 37.7457260090551 -122.504824075497 (37.7457260090551, -122.504824075497)
182822 39824 1 116 2190 46th Ave 1 1 1 1 1 01/06/1999 12:00:00 AM 1   Permit Number 41149 5982047.2464 2100175.5874 37.745641550250895 -122.504815942994 (37.7456415502509, -122.504815942994)
137793 53580 1 116 148 06th Ave 1 1 1 1   08/15/1973 12:00:00 AM 34   Permit Number 12426 5993993.6857199995 2114568.59854 37.7858565385613 -122.46455217907699 (37.7858565385613, -122.464552179077)
107500 54927 1 116 485 Duncan St 1 1 1 1   08/16/1972 12:00:00 AM 10   Permit Number 10801 6003402.69319537 2099776.66443458 37.745779384936206 -122.43094357883498 (37.7457793849362, -122.430943578835)
105545 54448 1 116 425 Vermont St 1 1 1 1   12/16/2015 12:00:00 AM   3x5 Permit Number 10233 6011220.56042251 2106374.73270267 37.764336094761 -122.40437470921499 (37.764336094761, -122.404374709215)
838 19815 3 116 100 STAIRWAY24 6 1 1 2     6 100ST            
1817 251719 6 116 1301 Clayton St 1 17 1 1           5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866)
3280 253389 2 116 30X Grand View Ave 2 17 1 1       3x3   6000475.0 2103841.0 37.756772747069604 -122.44135867200701 (37.7567727470696, -122.441358672007)
3355 253433 2 116 3 Vulcan Stwy 1 14 1 1       3x3   6000640.0 2106231.0 37.7633444989385 -122.440959493883 (37.7633444989385, -122.440959493883)
4452 19593 3 116 100 STAIRWAY4 16 1 1 2     3 60            
5737 20074 3 116 100 STAIRWAY55 7 1 1 2     24 27X            
6387 19592 3 116 100 STAIRWAY4 15 1 1 2     3 60            
7219 20014 3 116 100 STAIRWAY47 2 1 1 2     12 100ST            
7290 19816 3 116 100 STAIRWAY24 7 1 1 2     6 100ST            
10060 19578 3 116 100 STAIRWAY4 1 1 1 2     36 8            
11264 117179 3 116 350x Winding Way 1 11 1 2     30 3x3   6001167.67306 2086580.24641 37.7094181465037 -122.43772698870701 (37.7094181465037, -122.437726988707)
12451 20015 3 116 100 STAIRWAY47 3 1 1 2     12 100ST            
13822 20456 3 116 495X Sunset Blvd 21 1 1 2     36 60            
15735 19811 3 116 100 STAIRWAY24 2 1 1 2     24 100ST            
20116 2370 3 116 2516 Bryant St 1 1 1 2     12 4X4PL   6009703.1421 2102664.68486 37.7540642287015 -122.40936121487499 (37.7540642287015, -122.409361214875)
21212 11673 3 116 700X Junipero Serra Blvd 10 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991295.1451900005 2092921.61878 37.7262636985024 -122.47230970662399 (37.7262636985024, -122.472309706624)
22599 2580 1 116 1668 Bush St 4 1 1 1     12 4X4   6005450.60125 2115176.6463599997 37.7881798837348 -122.424957678647 (37.7881798837348, -122.424957678647)
24557 136431 2 116 13 MacOndray Ln 2 9 1 1     23     6008632.90068 2119166.6230200003 37.799314619318 -122.414229834152 (37.799314619318, -122.414229834152)
25384 185213 2 116 2500 Sunset Blvd 68 9 1 1     1 Width 0ft   5985153.279 2098105.011 37.740138541922 -122.49392333934799 (37.740138541922, -122.493923339348)
26484 184736 2 116 1301 Sunset Blvd 2 9 1 1     1 Width 0ft   5984658.5537 2106283.3352 37.762565010947704 -122.49623713063801 (37.7625650109477, -122.496237130638)
27330 187124 2 116 2600 Sunset Blvd 60 9 1 1     2 Width 0ft   5985135.2439 2097353.8058 37.738074878751895 -122.493930349328 (37.7380748787519, -122.493930349328)
27359 240611 2 116 255 Jersey St 1 1 1 1     5 Width 3ft   6003497.9531 2101542.75011 37.750634040826796 -122.43074019171699 (37.7506340408268, -122.430740191717)
29043 181547 2 116 1300 Sunset Blvd 25 9 1 1     1 Width 0ft   5984881.425 2105994.983 37.761786329172104 -122.495445043427 (37.7617863291721, -122.495445043427)
29532 186369 2 116 1801 Sunset Blvd 36 9 1 1     1 Width 0ft   5984816.0737 2102538.2484 37.7522912688492 -122.495416115464 (37.7522912688492, -122.495416115464)
29906 250138 3 116 2550x Lyon St 6 3 1 2     101     5999227.62567 2117605.22496 37.7944946461503 -122.446662836939 (37.7944946461503, -122.446662836939)
29908 249959 2 116 273 Filbert St 1 7 1 1     23 Width 0ft   6011558.5565599995 2120064.53903 37.801943979781896 -122.40416921824301 (37.8019439797819, -122.404169218243)
30053 240601 2 116 609 28th St 2 1 1 1     4 Width 2ft   6001917.090969999 2099400.07719 37.744661076553 -122.43605362647301 (37.744661076553, -122.436053626473)
30220 181484 2 116 1400 Sunset Blvd 44 9 1 1     2 Width 0ft   5984898.4123 2105356.9862 37.7600355628364 -122.49533923888201 (37.7600355628364, -122.495339238882)
31261 215028 2 116 100 Terrace Dr 23 2 1 1     13     5993755.12546 2096561.9752 37.7364012864951 -122.464069896803 (37.7364012864951, -122.464069896803)
33291 240614 2 116 3637 22nd St 3 2 1 1     3 Width 3ft   6003933.5831699995 2103025.57629 37.7547302045579 -122.429339475147 (37.7547302045579, -122.429339475147)
34861 240630 2 116 32 Harry St 5 9 1 1     35     6003226.48563 2097681.33135 37.7400160997695 -122.43140332841999 (37.7400160997695, -122.43140332842)
35086 185875 2 116 2000 Sunset Blvd 19 9 1 1     2 Width 0ft   5985024.3241 2101081.1994 37.74830280287971 -122.494588557862 (37.7483028028797, -122.494588557862)
35152 215041 2 116 497 Joost Ave 1 9 1 1     3 Width 10ft   5998794.49638 2094951.64479 37.732268849509104 -122.44653092436701 (37.7322688495091, -122.446530924367)
35177 184804 2 116 1301 Sunset Blvd 65 9 1 1     1 Width 0ft   5984679.0585 2105723.8188 37.7610299368102 -122.496124931271 (37.7610299368102, -122.496124931271)
35570 240617 2 116 685 Sanchez St 2 2 1 1     13 Width 5ft   6003712.72581 2104261.51662 37.7581112975082 -122.43019142809099 (37.7581112975082, -122.430191428091)
36125 186472 2 116 1601 Sunset Blvd 60 9 1 1     1 Width 0ft   5984790.3524 2103740.0582 37.755589600564704 -122.495593697553 (37.7555896005647, -122.495593697553)
36375 136443 2 116 3 Broadway 9 9 1 1     18     6013384.0493 2118922.9353099996 37.7989112401317 -122.39777198798201 (37.7989112401317, -122.397771987982)
36809 215040 2 116 88 Ashton Ave 1 9 1 1     13     5994178.77111 2090487.7098599998 37.71974724151371 -122.46216479907 (37.7197472415137, -122.46216479907)
37950 247598 2 116 900 Tompkins Ave 3 9 1 1     13 Width 10ft   6009167.823059999 2096407.9062599998 37.7368544863348 -122.410770639572 (37.7368544863348, -122.410770639572)
38099 200496 2 116 3239 Jennings St 3 1 1 1     7 Width 0ft   6013542.8885 2090062.874 37.7196766561509 -122.39519967454399 (37.7196766561509, -122.395199674544)
38278 215037 2 116 314 Staples Ave 7 9 1 1     13     5997982.72892 2093830.4607099998 37.7291439428352 -122.449256629186 (37.7291439428352, -122.449256629186)
38586 246713 2 116 1 Bonview St 19 2 1 1     20     6007763.89494 2099225.75212 37.7445128502976 -122.415824124379 (37.7445128502976, -122.415824124379)
38662 215039 2 116 179 Ashton Ave 1 9 1 1     32     5994134.23715 2091156.84385 37.721581958319504 -122.462367242757 (37.7215819583195, -122.462367242757)
39303 118611 2 116 349 Point Lobos Ave 3 17 1 1     6     5981718.6857199995 2112644.15815 37.7798573303546 -122.506876725888 (37.7798573303546, -122.506876725888)
39748 240597 2 116 523 Powhattan Ave 1 2 1 1     29     6008567.55649 2098119.2319799997 37.741519737445294 -122.412966995358 (37.7415197374453, -122.412966995358)
40236 120278 2 116 129 24th Ave 8 7 1 1     14     5988337.84774 2115148.37916 37.7871207843354 -122.48416209808799 (37.7871207843354, -122.484162098088)
40320 187361 2 116 2200 Sunset Blvd 46 9 1 1     2 Width 0ft   5985088.1562 2099814.8531 37.7448294961486 -122.49427450340099 (37.7448294961486, -122.494274503401)
40443 120276 2 116 129 24th Ave 6 7 1 1     13     5988325.261 2115160.84311 37.787154273948204 -122.484206559328 (37.7871542739482, -122.484206559328)
40656 186033 2 116 1900 Sunset Blvd 28 9 1 1     1 Width 0ft   5985025.9241 2102045.6103 37.7509509050251 -122.49465411447399 (37.7509509050251, -122.494654114474)
40766 120272 2 116 129 24th Ave 2 7 1 1     13     5988314.622169999 2115170.4665900003 37.7871800778407 -122.48424407294901 (37.7871800778407, -122.484244072949)
40898 185564 2 116 2201 Sunset Blvd 48 9 1 1     1 Width 0ft   5984920.5667 2099758.7289 37.744665585625896 -122.494849850524 (37.7446655856259, -122.494849850524)
41136 250136 3 116 2550x Lyon St 3 3 1 2     100     5999230.194080001 2117561.109 37.794373662156296 -122.446650774326 (37.7943736621563, -122.446650774326)
41346 181435 2 116 1500 Sunset Blvd 68 9 1 1     2 Width 0ft   5984924.5894 2104933.1403 37.7588733327201 -122.495217449651 (37.7588733327201, -122.495217449651)
41820 136433 2 116 2671 Leavenworth St 6 9 1 1     32     6007318.566930001 2121838.23641 37.8065762788357 -122.418967487863 (37.8065762788357, -122.418967487863)
42971 111268 3 116 700X BOSWORTH ST 6 7 1 2     3     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854)
43258 240627 2 116 5413 Diamond Heights Blvd 6 9 1 1     8     6002066.06456 2097929.8821400004 37.7406327271153 -122.43543335598 (37.7406327271153, -122.43543335598)
Powered by Datasette · Query took 5.23ms · Data source: data.sfgov.org