trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1303 35175 7 16   7 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
1340 87020 7 16 10 Osceola Dr 2 Sidewalk: Property side : Cutout Tree 2   12/05/2007 12:00:00 AM     Permit Number 49949                    
1492 20444 1 16 495X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree 1     12 15                      
2323 35205 7 16   16 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
2511 20282 1 16 20X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree 1     12 60                      
2538 20304 1 16 50X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree 1     12 60                      
3339 19580 1 16 100 STAIRWAY4 3 Sidewalk: Curb side : Cutout Tree 1     3 8                      
3634 20382 1 16 262X Sunset Blvd 28 Sidewalk: Curb side : Cutout Tree 1     18 60                      
3913 35208 7 16   13 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
3997 20436 1 16 495X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree 1     3 15                      
4295 20447 1 16 495X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree 1     12 15                      
4531 20442 1 16 495X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree 1     12 15                      
4587 35197 7 16   17 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
5218 19581 1 16 100 STAIRWAY4 4 Sidewalk: Curb side : Cutout Tree 1     3 8                      
5272 20437 1 16 495X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree 1     3 15                      
5362 109193 7 16 4124 Moraga Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/02/2015 12:00:00 AM 3 3x3 Permit Number 773525                    
5850 20445 1 16 495X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree 1     12 15                      
6596 20449 1 16 495X Sunset Blvd 14 Sidewalk: Curb side : Cutout Tree 1     12 15                      
6911 20443 1 16 495X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree 1     12 15                      
6998 20438 1 16 495X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree 1     12 15                      
7474 35177 7 16   5 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
8283 19872 1 16 100 STAIRWAY33 4 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
8676 34246 7 16   1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 38056                    
9631 35176 7 16   6 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
9856 35210 7 16   11 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
10004 20406 1 16 262X Sunset Blvd 51 Sidewalk: Curb side : Cutout Tree 1     12 60                      
10031 35174 7 16   8 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
10516 102842 4 16 1101X Portola Dr 8 Sidewalk: Property side : Yard Tree 1                              
10526 20383 1 16 262X Sunset Blvd 29 Sidewalk: Curb side : Cutout Tree 1     18 60                      
10547 20439 1 16 495X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree 1     3 15                      
10551 35179 7 16   3 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
10979 35203 7 16   20 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
11384 258014 1 16 4222 Moraga Ave 1 Sidewalk: Curb side : Tree 1                              
11690 35212 7 16   19 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
11860 20441 1 16 495X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree 1     18 15                      
11862 260530 1 16 1790x 46th Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 07/27/2019 12:00:00 AM 3                        
12844 35183 7 16   1 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
13065 20384 1 16 262X Sunset Blvd 30 Sidewalk: Curb side : Cutout Tree 1     18 60                      
13515 35181 7 16   9 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
13897 20448 1 16 495X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree 1     12 15                      
14056 20375 1 16 262X Sunset Blvd 23 Sidewalk: Curb side : Cutout Tree 1     18 60                      
14273 20403 1 16 262X Sunset Blvd 48 Sidewalk: Curb side : Cutout Tree 1     12 60                      
14818 20309 1 16 50X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree 1     12 60                      
14889 35207 7 16   14 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
14939 20281 1 16 20X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree 1     12 60                      
15355 20450 1 16 495X Sunset Blvd 15 Sidewalk: Curb side : Cutout Tree 1     12 15                      
15456 20376 1 16 262X Sunset Blvd 24 Sidewalk: Curb side : Cutout Tree 1     18 60                      
15754 35209 7 16   12 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
15758 260531 1 16 1790x 46th Ave 2 Sidewalk: Curb side : Cutout Tree 1 FUF 07/27/2019 12:00:00 AM 3                        
16160 20446 1 16 495X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree 1     6 15                      
16270 35178 7 16   4 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
16636 35198 7 16   10 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
17105 20440 1 16 495X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree 1     12 30                      
17110 35180 7 16   2 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
17377 260517 1 16 4711x Lincoln Way 2 Sidewalk: Curb side : Cutout Tree 1 FUF 04/27/2019 12:00:00 AM 3                        
17847 20000 1 16 100 STAIRWAY46 20 Sidewalk: Curb side : Cutout Tree 1     6 2                      
18187 35206 7 16   15 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
18230 35204 7 16   18 Sidewalk: Curb side : Cutout Tree 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
18875 46976 7 16 94122 47th Ave 1 Sidewalk: Curb side : Cutout Tree 2   05/01/2002 12:00:00 AM     Permit Number 44996                    
19559 19579 1 16 100 STAIRWAY4 2 Sidewalk: Curb side : Cutout Tree 1     3 3X3                      
682 16784 1 16 1961 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree 1     6 4X4   5999039.4234543 2112720.6314145 37.781072082708 -122.446962370058 (37.781072082708, -122.446962370058) 15 5 1 54 16
1147 131409 1 16 2817 Buchanan St 1 Sidewalk: Curb side : Cutout Tree 2     17 Width 4ft   6003467.33625 2118170.97636 37.796289323341 -122.432033340382 (37.796289323341, -122.432033340382) 13 9 1 57 17
1201 2190 1 16 1055 Broderick St 1 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6000864.0909 2112351.4116 37.7801623757286 -122.440623460362 (37.7801623757286, -122.440623460362) 15 5 1 29490 41
1667 101664 4 16 2X Daniel Burnham Ct 4 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1677 259282 1 16 3891 Sacramento St 5 Sidewalk: Property side : Yard Tree 2       Width 7ft   5996301.11796 2114890.85877 37.7868741256738 -122.456592467462 (37.7868741256738, -122.456592467462) 11 6 1 54 31
1966 61296 1 16 2360 Larkin St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/20/1986 12:00:00 AM 9   Permit Number 23055 6006748.00387 2119357.01746 37.7997313381808 -122.420765770421 (37.7997313381808, -122.420765770421) 5 9 1 28858 32
2051 250522 1 16 95 26th Ave 2 Sidewalk: Curb side : Yard Tree 2     14 Width 6ft   5987685.78964 2115424.25577 37.7878402763649 -122.486438309599 (37.7878402763649, -122.486438309599) 11 6 1 55 33
2162 250415 1 16 50 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree 2   01/14/2020 12:00:00 AM 3 Width 4ft   5987895.18737 2115830.32518 37.7889674299609 -122.485743656163 (37.7889674299609, -122.485743656163) 11 6 1 55 33
2401 75310 1 16 40 Vega St 2 Sidewalk: Curb side : Cutout Tree 2 FUF   14     5999369.874 2112377.7239 37.7801494207177 -122.445794512547 (37.7801494207177, -122.445794512547) 15 5 1 54 16
2422 80046 1 16 2325 Filbert St 2 Sidewalk: Curb side : Cutout Tree 2 FUF   8     6001817.74148 2118715.85745 37.7976917657091 -122.437780314931 (37.7976917657091, -122.437780314931) 13 9 1 57 17
2518 250436 1 16 98 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree 2     11 Width 4ft   5987616.8568 2115817.96032 37.7889172576592 -122.486705722111 (37.7889172576592, -122.486705722111) 11 6 1 55 33
2749 60098 1 16 3349 Jackson St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/19/1982 12:00:00 AM 12   Permit Number 19599 5998205.44012 2116147.0262 37.7904323787895 -122.450094557236 (37.7904323787895, -122.450094557236) 13 6 1 54 31
2971 250510 1 16 75 27th Ave 3 Sidewalk: Curb side : Yard Tree 2     12 Width 5ft   5987308.66603 2115522.71145 37.7880886178397 -122.487750306256 (37.7880886178397, -122.487750306256) 11 6 1 55 33
3003 131309 1 16 101 Maple St 2 Sidewalk: Curb side : Pot Tree 2     8 Width 3ft   5996544.36803 2115871.17754 37.7895797810398 -122.455821775454 (37.7895797810398, -122.455821775454) 11 6 1 54 31
3317 75134 1 16 40 Vega St 4 Sidewalk: Curb side : Cutout Tree 2 FUF   13     5999276.808 2112366.556 37.7801134423261 -122.44611566553 (37.7801134423261, -122.44611566553) 15 5 1 54 16
3424 116715 1 16 2817 Bush St 1 Sidewalk: Curb side : Cutout Tree 2     10 3x3   5999908.2786 2114349.9787 37.7855954495545 -122.444073686604 (37.7855954495545, -122.444073686604) 15 6 1 29490 31
3650 72105 1 16 3024 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree 2 FUF   13     5997692.6555 2113106.1769 37.7820536550082 -122.451649308253 (37.7820536550082, -122.451649308253) 15 6 1 54 31
3825 263630 4 16 1020 Baker St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6000550 2112598 37.7808215534457 -122.441727743189 (37.7808215534457, -122.441727743189) 15 5 1 29490 16
3859 75387 1 16 40 Vega St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   6     5999425.0368 2112388.5534 37.7801823052034 -122.445604458946 (37.7801823052034, -122.445604458946) 15 5 1 54 16
3921 12687 1 16 1330 Lake St 1 Sidewalk: Curb side : Cutout Tree 2     50 3X3   5991313.40727 2114800.59643 37.7863386650766 -122.473842035632 (37.7863386650766, -122.473842035632) 11 6 1 54 33
4017 250443 1 16 120 Seacliff Ave 2 Sidewalk: Curb side : Yard Tree 2     14 Width 4ft   5987542.94428 2115793.76045 37.7888465026131 -122.486959668166 (37.7888465026131, -122.486959668166) 11 6 1 55 33
4111 131305 1 16 401 Spruce St 1 Sidewalk: Curb side : Cutout Tree 2     17 Width 6ft   5997155.69751 2115003.89282 37.7872335145555 -122.453644000576 (37.7872335145555, -122.453644000576) 11 6 1 54 31
4193 66459 1 16 26 Wood St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/09/1991 12:00:00 AM 12   Permit Number 29609 5998393.1041 2113638.7682 37.7835561003446 -122.449264468811 (37.7835561003446, -122.449264468811) 15 6 1 54 31
5115 260959 6 16 400 Cherry St 11 Sidewalk: Property side : Yard Tree 2       Width 9ft   5996243 2114742 37.7864620624436 -122.456782770891 (37.7864620624436, -122.456782770891) 11 6 1 54 31
5354 8706 1 16 3100 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree 2     12 3x3   5997482.4956 2113078.7647 37.7819663504933 -122.452374383353 (37.7819663504933, -122.452374383353) 15 6 1 54 31
5512 259281 1 16 3891 Sacramento St 4 Sidewalk: Property side : Yard Tree 2       Width 7ft   5996301.11796 2114890.85877 37.7868741256738 -122.456592467462 (37.7868741256738, -122.456592467462) 11 6 1 54 31
5611 139705 1 16 301 Saint Joseph's Ave 11 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   6000476.8247 2113129.5897 37.7822769928429 -122.442019059209 (37.7822769928429, -122.442019059209) 15 5 1 29490 16
5620 250454 1 16 200 Seacliff Ave 1 : Tree 2     9 Width 4ft   5987161.73503 2115752.97281 37.7887122778945 -122.488275583153 (37.7887122778945, -122.488275583153) 11 6 1 55 33
5672 250483 1 16 475 Seacliff Ave 6 : Tree 2     7 Width 2ft   5986409.29286 2115158.05614 37.7870348804072 -122.490835095073 (37.7870348804072, -122.490835095073) 11 6 1 55 33
5810 111954 4 16 73 SEACLIFF AVE 4 Sidewalk: Curb side : Cutout Tree 2     24     5987709 2115789 37.7888431121968 -122.486384796167 (37.7888431121968, -122.486384796167) 11 6 1 55 33
6563 71813 1 16 3353 Jackson St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   13     5998192.69497 2116144.55888 37.7904248748608 -122.450138476504 (37.7904248748608, -122.450138476504) 13 6 1 54 31
6571 94972 7 16 230 Seacliff Ave 4 Sidewalk: Curb side : Tree 2   04/28/2010 12:00:00 AM     Permit Number 53388 5987086.7 2115743.7 37.7886824393648 -122.488534508212 (37.7886824393648, -122.488534508212) 11 6 1 55 33
6828 131262 1 16 2711 Union St 2 Front Yard : Cutout Tree 1     8 3x3 Permit Number 785082 6000010.78683 2118118.88771 37.7959497330364 -122.443989935801 (37.7959497330364, -122.443989935801) 13 9 1 57 17
8514 250400 4 16 15 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree 2     16 Width 4ft   5988097.76743 2115798.38338 37.7888915289683 -122.485040420476 (37.7888915289683, -122.485040420476) 11 6 1 55 33
8762 97574 4 16 501x Presidio Ave 4 Sidewalk: Curb side : Cutout Tree 2           5999116.8 2114959.9 37.7872249510267 -122.4468558657 (37.7872249510267, -122.4468558657) 15 6 1 54 31
9040 3086 1 16 2925 California St 1 Sidewalk: Curb side : Cutout Tree 2     45 3X3   6000198.2675 2115085.6403 37.7876319239021 -122.443123265692 (37.7876319239021, -122.443123265692) 13 6 1 29490 27
9076 9908 1 16 1809 Gough St 2 Sidewalk: Curb side : Cutout Tree 1     14 6x6   6005225.98494 2115998.17525 37.7904229062421 -122.425793311632 (37.7904229062421, -122.425793311632) 13 9 1 28858 27
9336 131379 1 16 2990 Broadway 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 4ft   5999358.44425 2117025.78745 37.7929111360792 -122.446168490398 (37.7929111360792, -122.446168490398) 13 9 1 57 27
9491 72305 1 16 3662 Clay St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   8     5997266.67895 2115407.36737 37.7883477098214 -122.453289170381 (37.7883477098214, -122.453289170381) 11 6 1 54 31
9679 111947 4 16 95 SEACLIFF AVE 4 Sidewalk: Curb side : Cutout Tree 2     30     5987570 2115773 37.7887910778243 -122.486864535179 (37.7887910778243, -122.486864535179) 11 6 1 55 33
9926 80088 1 16 2325 Filbert St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   7     6001799.98611 2118713.99662 37.7976856467424 -122.437841619893 (37.7976856467424, -122.437841619893) 13 9 1 57 17