trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
50 264964 6 28 3641 California St 1 Sidewalk: Curb side : Cutout Tree 2       3X3   5996989 2114619 37.7861671437011 -122.454192924446 (37.7861671437011, -122.454192924446) 11 6 1 54 31
79 121399 1 28 349X Cargo Way 1 Sidewalk: Curb side : Cutout Tree 1                              
100 255131 1 28 401X Brotherhood Way 9 Sidewalk: Property side : Yard Tree 1                              
498 260403 1 28 500X Brotherhood Way 1 Median : Yard Tree 2       30x30   5992691 2087881 37.712504070633 -122.467118029673 (37.712504070633, -122.467118029673) 9 8 6 64 24
2050 50805 7 28 1498 Fulton St 2 Sidewalk: Curb side : Cutout Tree 2   03/09/2004 12:00:00 AM     Permit Number 47329 6000596.76427703 2111027.41746177 37.7765117981927 -122.441453229456 (37.7765117981927, -122.441453229456) 15 5 11 29492 41
2868 255125 1 28 401X Brotherhood Way 3 Sidewalk: Property side : Yard Tree 1                              
3319 255128 1 28 401X Brotherhood Way 6 Sidewalk: Property side : Yard Tree 1                              
3631 260410 1 28 400X Brotherhood Way 10 Side Yard : Yard Tree 2       30x30   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
3865 105892 4 28 1100 Masonic Ave 3 Sidewalk: Curb side : Cutout Tree 2           5999444.5 2109060.1 37.7710443339737 -122.445297745357 (37.7710443339737, -122.445297745357) 15 5 11 29492 9
4157 52083 7 28 770 Powell St 1 Sidewalk: Curb side : Cutout Tree 2   10/17/2005 12:00:00 AM     Permit Number 48281 6010080.56543171 2116389.03640526 37.7917692527785 -122.409024297587 (37.7917692527785, -122.409024297587) 5 1 10 28857 21
5059 255129 1 28 401X Brotherhood Way 7 Sidewalk: Property side : Yard Tree 1                              
5129 255126 1 28 401X Brotherhood Way 4 Sidewalk: Property side : Yard Tree 1                              
5246 262331 6 28 2140 Wawona St 1 Back Yard : Cutout Tree 2       3x3   5986390 2097232 37.7378137677629 -122.489583137449 (37.7378137677629, -122.489583137449) 1 8 3 29491 35
5510 104813 6 28 1601X Portola Dr 5 Front Yard : Yard Tree 2                              
5631 50066 7 28 406 Sanchez St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46794 6003569.14495563 2105912.6827965 37.7626368713078 -122.430805824209 (37.7626368713078, -122.430805824209) 15 4 5 28862 3
5844 99991 7 28 600@Clay Montgomery St 3 Sidewalk: Curb side : Cutout Tree 2         Permit Number 44594 6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
6425 102410 4 28 55X Lyon St 2 Sidewalk: Curb side : Cutout Tree 2           6000310.8 2109142 37.7713186232103 -122.442307075209 (37.7713186232103, -122.442307075209) 15 5 11 29492 9
6473 48743 7 28   1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
6611 262204 1 28 907 Chenery St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6001442 2095927 37.735097816857 -122.437447738546 (37.735097816857, -122.437447738546) 2 7 5 63 7
7147 260402 1 28 10X Arch St 1 Median : Yard Tree 1       3X5   5992587 2087523 37.7115150847083 -122.467451465905 (37.7115150847083, -122.467451465905) 9 8 4 64 24
7358 108758 7 28 1449 PAGE ST 1 Sidewalk: Curb side : Cutout Tree 2           5999638.3 2109087.9 37.7711317264146 -122.444629385712 (37.7711317264146, -122.444629385712) 15 5 11 29492 9
7374 48751 7 28   9 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
7848 54566 7 28 1312 Page St 1 Sidewalk: Curb side : Cutout Tree 2   07/18/1972 12:00:00 AM   3x3 Permit Number 10364 6000274.16247872 2109249.10106233 37.7716106075543 -122.44244149612 (37.7716106075543, -122.44244149612) 15 5 11 29492 9
7881 260404 1 28 500X Brotherhood Way 2 Median : Yard Tree 2       30x30   5992691 2087881 37.712504070633 -122.467118029673 (37.712504070633, -122.467118029673) 9 8 6 64 24
8604 48746 7 28   4 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
8612 255133 1 28 401X Brotherhood Way 11 Sidewalk: Property side : Yard Tree 1                              
8893 50823 7 28   2 Sidewalk: Curb side : Cutout Tree 2   03/19/2004 12:00:00 AM     Permit Number 47344                    
9226 99970 4 28 2270 Folsom St 12 Sidewalk: Curb side : Cutout Tree 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
9839 48748 7 28   6 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
10121 110450 4 28 56 HANCOCK ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6003933 2105145 37.7605496062864 -122.429492630385 (37.7605496062864, -122.429492630385) 2 4 5 28862 3
10173 48744 7 28   2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
10238 255130 1 28 401X Brotherhood Way 8 Sidewalk: Property side : Yard Tree 1                              
10360 30354 7 28   1 Sidewalk: Curb side : Cutout Tree 2   02/17/1956 12:00:00 AM     Permit Number 43                    
10391 261268 1 28 1544 Page St 1 Sidewalk: Curb side : Cutout Tree 2       Width 0ft   5999025.8241 2109069.656 37.771046664384 -122.446746640696 (37.771046664384, -122.446746640696) 15 5 11 29492 9
10635 255127 1 28 401X Brotherhood Way 5 Sidewalk: Property side : Yard Tree 1                              
10872 33492 7 28 25 Coleridge St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37604 6007009.01726732 2099597.28801828 37.7454905378147 -122.418460683772 (37.7454905378147, -122.418460683772) 2 7 7 28859 2
10989 254569 7 28 1400x Laguna St 4 Sidewalk: Curb side : Cutout Tree 2 DPW     3x3   6004613 2113717 37.7841247118733 -122.427751595484 (37.7841247118733, -122.427751595484) 13 9 11 28858 41
11020 261566 1 28 1800 26th St 1 Sidewalk: Property side : Yard Tree 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
11935 50824 7 28   1 Sidewalk: Curb side : Cutout Tree 2   03/19/2004 12:00:00 AM     Permit Number 47344                    
12040 48742 7 28   10 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
12050 261306 6 28 1555 Union St 1 Front Yard : Cutout Tree 2       3x3   6005549 2118864 37.7983099861265 -122.424879674285 (37.7983099861265, -122.424879674285) 13 9 1 57 17
12565 104957 4 28 759 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
12785 48747 7 28   5 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
12883 255123 1 28 401X Brotherhood Way 1 Sidewalk: Property side : Yard Tree 1                              
13040 261562 1 28 1801 25th St 7 Sidewalk: Property side : Yard Tree 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
13061 111232 4 28 2601X 15TH AVE 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5991704 2097685 37.7393664008113 -122.471243228199 (37.7393664008113, -122.471243228199) 1 8 4 29491 40
14179 257990 4 28 1299x Laguna St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6004575 2113275 37.7829089401984 -122.427851556708 (37.7829089401984, -122.427851556708) 7 9 11 29490 41
15071 48749 7 28   7 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
15641 48745 7 28   3 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
17229 262360 1 28 241 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6001078 2098361 37.7417603103416 -122.438880584073 (37.7417603103416, -122.438880584073) 2 7 5 63 7
17242 253971 6 28 1401X Laguna St 4 Sidewalk: Property side : Yard Tree 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
17595 255124 1 28 401X Brotherhood Way 2 Sidewalk: Property side : Yard Tree 1                              
17899 110754 4 28 500 COLE ST 3 Sidewalk: Curb side : Cutout Tree 2       6x4   5998015 2108858 37.770407716093 -122.450227838314 (37.770407716093, -122.450227838314) 15 5 11 29492 9
17905 260412 1 28 10X Brotherhood Way 1 Side Yard : Yard Tree 2       Width 0ft   5992928.58802 2087852.90738 37.7124406464989 -122.466294818667 (37.7124406464989, -122.466294818667) 9 8 4 64 24
18302 33467 7 28 72 Coleridge St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37623 6006783.56593714 2099291.50343979 37.7446382277934 -122.419218573599 (37.7446382277934, -122.419218573599) 2 7 7 28859 2
18540 48750 7 28   8 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46023                    
18576 261447 1 28 317 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6006993 2095799 37.7350603822594 -122.418246820854 (37.7350603822594, -122.418246820854) 2 7 7 28859 2
18977 97306 4 28 47 Kittredge Ter 1 Sidewalk: Curb side : Cutout Tree 2           5997949.8 2111441.7 37.7774981585608 -122.450639669067 (37.7774981585608, -122.450639669067) 15 6 2 54 16
19147 255132 1 28 401X Brotherhood Way 10 Sidewalk: Property side : Yard Tree 1                              
19587 260401 1 28 3900 Alemany Blvd 2 Median : Yard Tree 1       3X5   5992602.03225 2087509.49597 37.7114788737215 -122.467398529617 (37.7114788737215, -122.467398529617) 9 8 4 64 24
20003 99987 4 28 535@Clay Washington St 5 Sidewalk: Curb side : Cutout Tree 2           6012018 2117734 37.7955705425922 -122.402415352518 (37.7955705425922, -122.402415352518) 3 1 10 28860 4
20259 26515 1 28 2886 Harrison St 1 Sidewalk: Curb side : Cutout Tree 1       3X3   6008938.68629 2101687.00134 37.7513368683627 -122.411935812817 (37.7513368683627, -122.411935812817) 2 4 7 28859 19
20402 257888 8 28 155X Magellan Ave 1 Front Yard : Yard Tree 3       10x10   5995070 2100842 37.7482288640106 -122.459833790503 (37.7482288640106, -122.459833790503) 1 8 4 29491 40
20491 118331 4 28 2 Winfield St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6007461 2099574 37.7454520282724 -122.416896144845 (37.7454520282724, -122.416896144845) 2 7 7 28859 2
20880 99966 4 28 2270 Folsom St 8 Sidewalk: Curb side : Cutout Tree 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
22089 86892 7 28 2500 Mason St 10 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 49821 6008765 2122158 37.8075356107649 -122.413984454109 (37.8075356107649, -122.413984454109) 3 1 10 308 23
22417 58653 7 28 1041 Stanyan St 1 Sidewalk: Curb side : Cutout Tree 2   04/10/1979 12:00:00 AM   3x3 Permit Number 17875 5997239.92048014 2106921.18918515 37.7650453439116 -122.452769014505 (37.7650453439116, -122.452769014505) 15 5 11 29492 12
22660 33533 7 28 185 Bocana St 1 Sidewalk: Curb side : Cutout Tree 2   11/25/1996 12:00:00 AM     Permit Number 37643 6007275.34853053 2097937.54990535 37.7409482571652 -122.417422147014 (37.7409482571652, -122.417422147014) 2 7 7 28859 2
24635 251248 1 28 829 Chenery St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6001839 2095802 37.7347771581377 -122.436066227259 (37.7347771581377, -122.436066227259) 2 7 5 63 7
24682 50574 7 28 2295 Folsom St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/18/2003 12:00:00 AM     Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
24768 50314 7 28 1055 Ellis St 4 Sidewalk: Curb side : Cutout Tree 2   09/22/2003 12:00:00 AM     Permit Number 47021 6005825.34130744 2113438.50468071 37.7834285368624 -122.42353751819 (37.7834285368624, -122.42353751819) 7 9 11 28858 41
24910 50685 7 28 915 Ashbury St 1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 47258 5999168.89515798 2107036.01925898 37.7654709832109 -122.446105453704 (37.7654709832109, -122.446105453704) 15 5 11 29492 9
24948 100206 7 28 155X Lundy's Ln 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6006736.3 2098711.7 37.7430435558186 -122.4193408869 (37.7430435558186, -122.4193408869) 2 7 7 28859 2
25404 113493 4 28 2850 LAKE ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5986565 2114493 37.7852179229774 -122.490247450243 (37.7852179229774, -122.490247450243) 11 6 1 55 33
25604 99496 7 28 1400X Plymouth Ave 3 Median : Cutout Tree 2           5995903 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576) 9 7 4 28861 40
25986 119612 7 28 200 Parnassus Ave 4 Sidewalk: Curb side : Cutout Tree 2       3x3   5997281.95614032 2106749.56867224 37.7645765263283 -122.452611237527 (37.7645765263283, -122.452611237527) 15 5 11 29492 12
26412 34885 7 28 1539 Beach St 1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 38493 6002855.27225509 2121286.11305956 37.8048079563004 -122.434374036967 (37.8048079563004, -122.434374036967) 13 9 1 57 17
26881 97635 7 28 1254 Jackson St 2 Sidewalk: Curb side : Cutout Tree 2           6008163 2117572 37.7949097746331 -122.415742887246 (37.7949097746331, -122.415742887246) 5 1 10 28858 21
27213 87671 7 28 450 El Camino Del Mar 1 Sidewalk: Property side : Cutout Tree 2   05/22/2008 12:00:00 AM   3x3 Permit Number 50395 5987244 2115292 37.7874513785554 -122.487957078163 (37.7874513785554, -122.487957078163) 11 6 1 55 33
28235 122331 1 28 950X Anza St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5996124 2112291 37.7797254357482 -122.45701712634 (37.7797254357482, -122.45701712634) 11 6 2 54 16
28699 40132 7 28 697 Banks St 1 Sidewalk: Curb side : Cutout Tree 2   03/31/1999 12:00:00 AM     Permit Number 41337 6008515.22056385 2095655.65791493 37.7347523629036 -122.412973810281 (37.7347523629036, -122.412973810281) 10 7 7 28859 2
29014 115937 4 28 500X LAKE ST 2 Sidewalk: Curb side : Cutout Tree 2       4x4   5993877 2114929 37.786839375345 -122.464982060228 (37.786839375345, -122.464982060228) 11 6 1 54 11
29279 86893 7 28 2500 Mason St 12 Sidewalk: Curb side : Cutout Tree 2   10/24/2007 12:00:00 AM   3x3 Permit Number 49821 6008765 2122158 37.8075356107649 -122.413984454109 (37.8075356107649, -122.413984454109) 3 1 10 308 23
29446 50634 7 28 2900 Jennings St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 10/14/2004 12:00:00 AM     Permit Number 47740 6014120.76360854 2090918.26429059 37.7220575083684 -122.393261977074 (37.7220575083684, -122.393261977074) 10 3 8 58 1
29507 115701 4 28 2840 LAKE ST 3 Sidewalk: Curb side : Cutout Tree 2       3x15   5986626 2114487 37.785205010982 -122.490035970437 (37.785205010982, -122.490035970437) 11 6 1 55 33
29672 49691 7 28 450 Stanyan St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 05/21/2003 12:00:00 AM   tx5 Permit Number 46512 5996840.32777146 2110125.42661407 37.7738204478349 -122.454382576109 (37.7738204478349, -122.454382576109) 15 5 2 29492 16
29836 115998 4 28 143 ASHBURY ST   Sidewalk: Curb side : Cutout Tree 2       3x3   5998718 2110172 37.7740558300516 -122.447890785953 (37.7740558300516, -122.447890785953) 15 5 11 29492 16
29844 53048 7 28 65@ APPLETON Gladys St 1 Sidewalk: Curb side : Cutout Tree 2   09/26/2006 12:00:00 AM     Permit Number 49026 6005683.68607987 2097324.15915168 37.7391743410359 -122.422881952522 (37.7391743410359, -122.422881952522) 2 7 7 28859 2
29882 100026 7 28 600 Montgomery St 4 Sidewalk: Curb side : Cutout Tree 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
30430 102606 4 28 300 Chestnut St 2 Sidewalk: Curb side : Cutout Tree 2       4x4   6010368 2120990 37.8044184722981 -122.408354438035 (37.8044184722981, -122.408354438035) 3 1 10 308 23
30511 103595 7 28 10X Hermann St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
31425 103598 7 28 10X Hermann St 7 Sidewalk: Curb side : Cutout Tree 2       3x3   6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
31664 115699 4 28 2840 LAKE ST 1 Sidewalk: Curb side : Cutout Tree 2       3x15   5986626 2114487 37.785205010982 -122.490035970437 (37.785205010982, -122.490035970437) 11 6 1 55 33
32983 38841 7 28 1817 California St 1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 40670 6005665.65244341 2115853.93139831 37.7900516844756 -122.42426182602 (37.7900516844756, -122.42426182602) 13 9 1 28858 41
32986 251533 1 28 1201X Pierce St 1 Sidewalk: Property side : Yard Tree 2       3x3   6002292 2112799 37.7814725496882 -122.435715710029 (37.7814725496882, -122.435715710029) 15 5 11 29490 41
33171 33502 7 28 155 Coleridge St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37596 6006575.63931047 2098797.68147059 37.7432705917121 -122.419902509091 (37.7432705917121, -122.419902509091) 2 7 7 28859 2
33339 100023 7 28 600 Montgomery St 6 Sidewalk: Curb side : Cutout Tree 2           6011817 2117412 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
34555 33952 7 28 1 Arbor St 3 Sidewalk: Curb side : Cutout Tree 2   04/09/1997 12:00:00 AM     Permit Number 37910 6002287.3237241 2097040.91143479 37.7382043832783 -122.434604778209 (37.7382043832783, -122.434604778209) 2 7 5 63 7
34612 115897 4 28 899X CHURCH ST 3 Sidewalk: Curb side : Cutout Tree 2       6x11   6004447 2103700 37.7566110668577 -122.427611986325 (37.7566110668577, -122.427611986325) 2 4 5 28862 3
34737 111082 4 28 130 JUNIPERO SERRA BLVD 1 Median : Cutout Tree 2       3x3   5991393 2095322 37.7328602072681 -122.472146321186 (37.7328602072681, -122.472146321186) 1 8 4 64 40
35363 51559 7 28 29 West Clay St 3 Sidewalk: Curb side : Cutout Tree 2         Permit Number 47854 5988768.43262818 2115023.56671426 37.7868031451511 -122.48266323691 (37.7868031451511, -122.48266323691) 11 6 1 55 33