trees
1,381 rows where qSpecies_id = 54 sorted by TreeID descending
This data as json, CSV (advanced)
These facets timed out: Fire Prevention Districts
| rowid | TreeID ▲ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37866 | 67753 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1992 12:00:00 AM | 11 | 3x3 | Permit Number 31377 | 6011258.7412 | 2118020.5233 | 37.79631485229 | -122.405062718866 | (37.79631485229, -122.405062718866) | 3 | 1 | 10 | 308 | 4 | |
| 154408 | 67469 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 13 | Permit Number 30990 | 6001172.0898 | 2110442.123 | 37.774937486349 | -122.439421053126 | (37.774937486349, -122.439421053126) | 15 | 5 | 11 | 29492 | 10 | |
| 100603 | 66825 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2047 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | 9 | Permit Number 30121 | 5998040.6169 | 2109928.3267 | 37.7733480244518 | -122.450216391954 | (37.7733480244518, -122.450216391954) | 15 | 5 | 11 | 29492 | 16 | |
| 89857 | 66720 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 819 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1991 12:00:00 AM | 14 | Permit Number 29962 | 5999956.9512 | 2111893.0193 | 37.778852049002 | -122.443728719684 | (37.778852049002, -122.443728719684) | 15 | 5 | 11 | 29490 | 16 | ||
| 24743 | 66562 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 144 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | 5 | Permit Number 29750 | 5998095.4621 | 2113585.8052 | 37.7833936486138 | -122.450290371551 | (37.7833936486138, -122.450290371551) | 15 | 6 | 1 | 54 | 31 | |
| 58688 | 66506 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2458 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 15 | Permit Number 29669 | 6001738.4652 | 2114659.4492 | 37.7865494118178 | -122.43776395706 | (37.7865494118178, -122.43776395706) | 13 | 6 | 11 | 29490 | 27 | |
| 100833 | 66504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2456 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 5 | Permit Number 29667 | 6001757.7853 | 2114663.6996 | 37.786562180873 | -122.437697418913 | (37.786562180873, -122.437697418913) | 13 | 6 | 11 | 29490 | 27 | |
| 165292 | 66381 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 648 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 13 | Permit Number 29507 | 6003596.4072 | 2110594.4854 | 37.775493505524 | -122.431045702786 | (37.775493505524, -122.431045702786) | 7 | 9 | 11 | 29492 | 10 | |
| 11850 | 66378 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 624 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 8 | Permit Number 29503 | 6003604.7588 | 2110527.1817 | 37.7753091794017 | -122.431012007993 | (37.7753091794017, -122.431012007993) | 7 | 9 | 11 | 29492 | 10 | |
| 11526 | 66368 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 5 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 10 | Permit Number 29490 | 5997440.3621 | 2113655.9431 | 37.7835487164216 | -122.452561811691 | (37.7835487164216, -122.452561811691) | 15 | 6 | 1 | 54 | 31 | |
| 33318 | 66182 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1819 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/06/1990 12:00:00 AM | 12 | Permit Number 29259 | 6004371.7533 | 2115130.5363 | 37.7879922787707 | -122.428687021207 | (37.7879922787707, -122.428687021207) | 13 | 9 | 11 | 29490 | 27 | ||
| 117346 | 65955 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1234 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1990 12:00:00 AM | 13 | Permit Number 28976 | 6001892.8907 | 2110857.546 | 37.7761191282962 | -122.436957400422 | (37.7761191282962, -122.436957400422) | 15 | 5 | 11 | 29492 | 10 | ||
| 56486 | 65627 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2116 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1990 12:00:00 AM | 12 | 6x6 | Permit Number 28535 | 6002451.5098 | 2114409.7678 | 37.7859043690694 | -122.435279135393 | (37.7859043690694, -122.435279135393) | 13 | 6 | 1 | 29490 | 27 |
| 29027 | 65538 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2180 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1990 12:00:00 AM | 16 | 6x6 | Permit Number 28435 | 6002182.4791 | 2114372.5672 | 37.7857869442252 | -122.436207242735 | (37.7857869442252, -122.436207242735) | 13 | 6 | 1 | 29490 | 27 |
| 109783 | 64843 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 618 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 11 | Permit Number 29500 | 6003607.7064 | 2110511.4611 | 37.7752661815317 | -122.431000689329 | (37.7752661815317, -122.431000689329) | 7 | 9 | 11 | 29492 | 10 | |
| 80284 | 64505 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 412 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 9 | Permit Number 25386 | 6001213.6317 | 2110153.0182 | 37.7741460412807 | -122.439256624823 | (37.7741460412807, -122.439256624823) | 15 | 5 | 11 | 29492 | 10 | |
| 4913 | 64501 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 545 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 13 | Permit Number 25381 | 6001107.084 | 2110608.9242 | 37.7753917807448 | -122.439657882213 | (37.7753917807448, -122.439657882213) | 15 | 5 | 11 | 29492 | 10 | |
| 20967 | 64425 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 259 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/1988 12:00:00 AM | 9 | Permit Number 25277 | 6010096.4211 | 2121261.5999 | 37.8051490065079 | -122.409313442808 | (37.8051490065079, -122.409313442808) | 3 | 1 | 10 | 308 | 23 | ||
| 143879 | 64376 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 69 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1988 12:00:00 AM | 11 | Permit Number 25215 | 5996673.1599 | 2112554.0417 | 37.7804791997483 | -122.455136367138 | (37.7804791997483, -122.455136367138) | 11 | 6 | 2 | 54 | 16 | ||
| 17669 | 64062 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1205 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/18/1990 12:00:00 AM | 7 | Permit Number 29268 | 6011082.0743 | 2119072.3147 | 37.799192938755 | -122.405748149412 | (37.799192938755, -122.405748149412) | 3 | 1 | 10 | 308 | 23 | |
| 82175 | 64038 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 16 Loyola Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/1988 12:00:00 AM | 10 | Permit Number 25745 | 5998453.4174 | 2110814.7286 | 37.7758054707119 | -122.44885232426 | (37.7758054707119, -122.44885232426) | 15 | 6 | 2 | 29492 | 16 | ||
| 140116 | 64012 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 10 Loyola Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1987 12:00:00 AM | 10 | Permit Number 24766 | 5998456.7381 | 2110792.4322 | 37.7757444404433 | -122.44883923079 | (37.7757444404433, -122.44883923079) | 15 | 6 | 2 | 29492 | 16 | ||
| 194465 | 63910 | Prune Opt Out 3 | Ficus retusa nitida :: Banyan Fig 54 | 2135 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1991 12:00:00 AM | 14 | Permit Number 788005 | 6009385.3216 | 2121038.8544 | 37.8044975370449 | -122.411758548847 | (37.8044975370449, -122.411758548847) | 3 | 1 | 10 | 308 | 23 | ||
| 36126 | 63909 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2119 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/1987 12:00:00 AM | 12 | Permit Number 24624 | 6009399.6734 | 2120957.786 | 37.8042757485475 | -122.411703151333 | (37.8042757485475, -122.411703151333) | 3 | 1 | 10 | 308 | 23 | ||
| 177769 | 63908 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2125 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/1987 12:00:00 AM | 14 | Permit Number 24623 | 6009389.9763 | 2121003.9446 | 37.8044019445665 | -122.411739972568 | (37.8044019445665, -122.411739972568) | 3 | 1 | 10 | 308 | 23 | ||
| 141102 | 63488 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 811 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/07/1987 12:00:00 AM | 12 | Permit Number 24085 | 5999970.1497 | 2111784.3859 | 37.7785545222825 | -122.443675254762 | (37.7785545222825, -122.443675254762) | 15 | 5 | 11 | 29490 | 16 | |
| 119444 | 62957 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 159 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1986 12:00:00 AM | 12 | Permit Number 23343 | 5998260.9157 | 2110109.071 | 37.7738569063547 | -122.449467376934 | (37.7738569063547, -122.449467376934) | 15 | 5 | 11 | 29492 | 16 | ||
| 77793 | 62731 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2307 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1993 12:00:00 AM | 10 | Permit Number 32015 | 5985442.2939 | 2099497.5593 | 37.7439790107491 | -122.49302661105 | (37.7439790107491, -122.49302661105) | 1 | 8 | 3 | 29491 | 35 | ||
| 162693 | 62689 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 523 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/1986 12:00:00 AM | 14 | Permit Number 23025 | 6010433.276 | 2119569.2907 | 37.8005212097535 | -122.408028291205 | (37.8005212097535, -122.408028291205) | 3 | 1 | 10 | 308 | 23 | ||
| 131718 | 6245 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1280 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6004753.0279 | 2113338.633 | 37.7830937301366 | -122.427240188063 | (37.7830937301366, -122.427240188063) | 7 | 9 | 11 | 28858 | 41 | ||
| 136758 | 6242 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1250 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004855.4094 | 2113352.7921 | 37.7831383969133 | -122.426886998286 | (37.7831383969133, -122.426886998286) | 7 | 9 | 11 | 28858 | 41 | ||
| 63983 | 62369 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 137 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/1985 12:00:00 AM | 9 | 3x3 | Permit Number 22515 | 5998258.1694 | 2110129.1192 | 37.7739117964536 | -122.449478321628 | (37.7739117964536, -122.449478321628) | 15 | 5 | 11 | 29492 | 16 | |
| 6829 | 62365 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2132 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/1985 12:00:00 AM | 14 | 6x4 | Permit Number 22511 | 6002365.7866 | 2114401.6807 | 37.7858772955002 | -122.43557513482 | (37.7858772955002, -122.43557513482) | 13 | 6 | 1 | 29490 | 27 | |
| 114954 | 62362 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1905 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/1985 12:00:00 AM | 13 | Permit Number 22507 | 6004330.152 | 2115433.2423 | 37.7888210787145 | -122.428852543084 | (37.7888210787145, -122.428852543084) | 13 | 9 | 11 | 29490 | 27 | ||
| 59417 | 6235 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1250 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004904.9664 | 2113362.05 | 37.7831666187465 | -122.426716210533 | (37.7831666187465, -122.426716210533) | 7 | 9 | 11 | 28858 | 41 | ||
| 40612 | 6232 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1220 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6005007.0756 | 2113377.0261 | 37.7832135118405 | -122.426364020332 | (37.7832135118405, -122.426364020332) | 7 | 9 | 11 | 28858 | 41 | ||
| 128466 | 6224 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1220 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6005090.9413 | 2113387.3731 | 37.7832466624445 | -122.426074615309 | (37.7832466624445, -122.426074615309) | 7 | 9 | 11 | 28858 | 41 | |||
| 19361 | 61824 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 568 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/1985 12:00:00 AM | 19 | Permit Number 21857 | 6005139.9121 | 2110969.4321 | 37.7766103583758 | -122.425733039566 | (37.7766103583758, -122.425733039566) | 7 | 9 | 11 | 28852 | 10 | ||
| 165670 | 61337 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 650 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/1984 12:00:00 AM | 10 | 5x6 | Permit Number 21242 | 5999250.392 | 2114334.8634 | 37.7855163948709 | -122.446348686743 | (37.7855163948709, -122.446348686743) | 15 | 6 | 1 | 29490 | 31 | |
| 110225 | 61148 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2237 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1983 12:00:00 AM | 7 | Permit Number 21005 | 5997050.2982 | 2110479.7459 | 37.7748053558267 | -122.453681848705 | (37.7748053558267, -122.453681848705) | 15 | 5 | 2 | 29492 | 16 | ||
| 71607 | 61078 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2590 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1983 12:00:00 AM | 13 | Permit Number 20915 | 5999806.8161 | 2113697.9026 | 37.7837992291467 | -122.444377837774 | (37.7837992291467, -122.444377837774) | 15 | 6 | 11 | 29490 | 31 | ||
| 149100 | 60603 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 630 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 9 | Permit Number 29505 | 6003603.285 | 2110552.7276 | 37.775379238631 | -122.431018929857 | (37.775379238631, -122.431018929857) | 7 | 9 | 11 | 29492 | 10 | |
| 55174 | 60217 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2100 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1982 12:00:00 AM | 15 | 3x3 | Permit Number 19767 | 6002507.5803 | 2114417.8549 | 37.7859297581806 | -122.43508572581 | (37.7859297581806, -122.43508572581) | 13 | 6 | 1 | 29490 | 27 | |
| 33826 | 59960 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 492 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1981 12:00:00 AM | 21 | Permit Number 19438 | 6005457.1486 | 2111358.1318 | 37.7776955544263 | -122.424663282479 | (37.7776955544263, -122.424663282479) | 7 | 9 | 11 | 28852 | 10 | |
| 188275 | 59956 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 426 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1981 12:00:00 AM | 16 | Permit Number 19433 | 6005279.4106 | 2111149.1414 | 37.7771116781194 | -122.42526326419 | (37.7771116781194, -122.42526326419) | 7 | 9 | 11 | 28852 | 10 | ||
| 194022 | 59752 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2375 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1981 12:00:00 AM | 11 | Permit Number 19189 | 6000826.215 | 2113783.3508 | 37.7840919573447 | -122.440857239763 | (37.7840919573447, -122.440857239763) | 15 | 6 | 11 | 29490 | 13 | ||
| 144900 | 59664 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 947 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 15 | 5x5 | Permit Number 19086 | 6002929.3099 | 2111572.5338 | 37.7781411599151 | -122.433423256969 | (37.7781411599151, -122.433423256969) | 15 | 9 | 11 | 29492 | 41 | |
| 137205 | 59663 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 943 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19085 | 6002930.6636 | 2111548.8443 | 37.778076191259 | -122.433416880741 | (37.778076191259, -122.433416880741) | 15 | 9 | 11 | 29492 | 41 | ||
| 170938 | 59662 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 911 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 17 | Permit Number 19084 | 6002943.8621 | 2111474.7299 | 37.7778734403922 | -122.433365924976 | (37.7778734403922, -122.433365924976) | 15 | 9 | 11 | 29492 | 41 | ||
| 178749 | 59661 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 950 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19083 | 6002974.356 | 2111562.0693 | 37.7781149825494 | -122.433266678398 | (37.7781149825494, -122.433266678398) | 15 | 9 | 11 | 29492 | 41 | ||
| 173853 | 59660 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 910 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 15 | Permit Number 19082 | 6002982.2355 | 2111513.667 | 37.7779825288987 | -122.43323596098 | (37.7779825288987, -122.43323596098) | 15 | 9 | 11 | 29492 | 41 | ||
| 27540 | 59659 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 906 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19081 | 6002986.1752 | 2111478.2094 | 37.7778853946604 | -122.433219797973 | (37.7778853946604, -122.433219797973) | 15 | 9 | 11 | 29492 | 41 | ||
| 18641 | 59622 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 448 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 8 | Permit Number 25385 | 6001193.7685 | 2110273.1905 | 37.7744748738878 | -122.439333950555 | (37.7744748738878, -122.439333950555) | 15 | 5 | 11 | 29492 | 10 | |
| 67896 | 59593 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1528 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1981 12:00:00 AM | 15 | Permit Number 18990 | 6000159.8025 | 2114219.1556 | 37.7852505885272 | -122.443194090382 | (37.7852505885272, -122.443194090382) | 15 | 6 | 1 | 29490 | 27 | ||
| 181651 | 59592 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1610 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1981 12:00:00 AM | 13 | Permit Number 18989 | 6000112.8301 | 2114568.7427 | 37.7862077855538 | -122.443381719167 | (37.7862077855538, -122.443381719167) | 13 | 6 | 1 | 29490 | 27 | ||
| 36701 | 59351 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 503 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52085 | 6000121.1922 | 2110676.4601 | 37.7755210539143 | -122.443073153769 | (37.7755210539143, -122.443073153769) | 15 | 5 | 11 | 29492 | 16 | |
| 8024 | 59162 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 465 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1981 12:00:00 AM | 16 | 3x3 | Permit Number 19443 | 6005553.1697 | 2111320.8777 | 37.7775986862615 | -122.424328461999 | (37.7775986862615, -122.424328461999) | 7 | 9 | 11 | 28852 | 10 |
| 80867 | 59153 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 20 Bellair Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/1982 12:00:00 AM | 11 | Permit Number 19779 | 6010063.4155 | 2121130.5341 | 37.8047872831513 | -122.409418407658 | (37.8047872831513, -122.409418407658) | 3 | 1 | 10 | 308 | 23 | ||
| 65586 | 59151 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 112 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1980 12:00:00 AM | 13 | Permit Number 18460 | 6010290.1497 | 2121142.971 | 37.8048341329685 | -122.408634644798 | (37.8048341329685, -122.408634644798) | 3 | 1 | 10 | 308 | 23 | ||
| 129892 | 58879 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2900 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1988 12:00:00 AM | 13 | Permit Number 25516 | 5999589.5873 | 2114362.4153 | 37.7856114118811 | -122.445177156478 | (37.7856114118811, -122.445177156478) | 15 | 6 | 1 | 29490 | 31 | ||
| 144570 | 58783 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/1979 12:00:00 AM | 15 | 3x3 | Permit Number 18026 | 6005406.4028 | 2111007.6387 | 37.7767303197423 | -122.424813888538 | (37.7767303197423, -122.424813888538) | 7 | 9 | 11 | 28852 | 10 | |
| 111837 | 58709 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1952 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/1979 12:00:00 AM | 14 | Permit Number 17941 | 6003655.3938 | 2118679.8466 | 37.7976972096555 | -122.431418967171 | (37.7976972096555, -122.431418967171) | 13 | 9 | 1 | 57 | 17 | ||
| 60753 | 58122 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 24 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1978 12:00:00 AM | 13 | Permit Number 17103 | 6003170.2635 | 2115307.1662 | 37.7884091881086 | -122.432856580985 | (37.7884091881086, -122.432856580985) | 13 | 9 | 1 | 29490 | 27 | ||
| 159445 | 58051 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1609 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/1977 12:00:00 AM | 5 | Permit Number 17020 | 6006619.5836 | 2116449.4594 | 37.7917406740828 | -122.421003598405 | (37.7917406740828, -122.421003598405) | 13 | 9 | 10 | 28858 | 21 | ||
| 83890 | 57820 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2357 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1977 12:00:00 AM | 11 | Permit Number 16759 | 6002204.3143 | 2114668.0157 | 37.7865994109848 | -122.436152849525 | (37.7865994109848, -122.436152849525) | 13 | 6 | 1 | 29490 | 27 | ||
| 117632 | 57633 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 486 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1976 12:00:00 AM | 19 | Permit Number 16531 | 6005481.2851 | 2111360.2306 | 37.7777026803458 | -122.424579935329 | (37.7777026803458, -122.424579935329) | 7 | 9 | 11 | 28852 | 10 | ||
| 12129 | 57526 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 501 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1981 12:00:00 AM | 13 | 3x3 | Permit Number 19437 | 6005352.078 | 2111299.9206 | 37.7775297860553 | -122.425022615137 | (37.7775297860553, -122.425022615137) | 7 | 9 | 11 | 28852 | 10 | |
| 185324 | 57510 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 630 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1976 12:00:00 AM | 16 | Permit Number 16363 | 6005412.5487 | 2111488.2587 | 37.7780503321524 | -122.424826828837 | (37.7780503321524, -122.424826828837) | 7 | 9 | 11 | 28852 | 10 | ||
| 84048 | 57327 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2904 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1976 12:00:00 AM | 17 | Permit Number 16155 | 5999526.9274 | 2114356.6691 | 37.7855920575643 | -122.445393527485 | (37.7855920575643, -122.445393527485) | 15 | 6 | 1 | 29490 | 31 | ||
| 119949 | 56977 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 177 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | 14 | Permit Number 14230 | 6009999.8042 | 2121084.2658 | 37.8046566775876 | -122.40963527441 | (37.8046566775876, -122.40963527441) | 3 | 1 | 10 | 308 | 23 | ||
| 41667 | 56934 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1923 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 16 | 3x3 | Permit Number 14180 | 6001934.7565 | 2115177.2253 | 37.7879822517226 | -122.437121923696 | (37.7879822517226, -122.437121923696) | 13 | 6 | 1 | 29490 | 27 | |
| 108721 | 56933 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1915 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 14 | 3x3 | Permit Number 14177 | 6001940.9389 | 2115134.3349 | 37.787864837109 | -122.437097461747 | (37.787864837109, -122.437097461747) | 13 | 6 | 1 | 29490 | 27 | |
| 100279 | 56932 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1911 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 18 | 3x3 | Permit Number 14176 | 6001946.3485 | 2115087.5805 | 37.787736769008 | -122.43707539686 | (37.787736769008, -122.43707539686) | 13 | 6 | 1 | 29490 | 27 | |
| 65242 | 56926 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 13 | Permit Number 14169 | 6001161.4908 | 2110173.8745 | 37.7742003402164 | -122.439438484322 | (37.7742003402164, -122.439438484322) | 15 | 5 | 11 | 29492 | 10 | ||
| 72010 | 56572 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 238 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6010130.9034 | 2121308.9776 | 37.805281025756 | -122.409197457422 | (37.805281025756, -122.409197457422) | 3 | 1 | 10 | 308 | 23 | ||||
| 157958 | 55484 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 701 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 18 | Permit Number 11437 | 6002049.3973 | 2110903.3005 | 37.7762536529278 | -122.436419278446 | (37.7762536529278, -122.436419278446) | 15 | 5 | 11 | 29492 | 10 | ||
| 190495 | 55481 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 530 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 13 | Permit Number 11434 | 6002173.9724 | 2110343.1732 | 37.7747227610629 | -122.435948251092 | (37.7747227610629, -122.435948251092) | 15 | 5 | 11 | 29492 | 10 | ||
| 103769 | 55477 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 555 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 17 | Permit Number 11429 | 6002598.3437 | 2110470.6592 | 37.7750969045142 | -122.434489383438 | (37.7750969045142, -122.434489383438) | 15 | 5 | 11 | 29492 | 10 | ||
| 162060 | 55476 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 17 | Permit Number 11428 | 6002664.0079 | 2110296.3247 | 37.7746219525119 | -122.434249770689 | (37.7746219525119, -122.434249770689) | 15 | 5 | 11 | 29492 | 10 | ||
| 54837 | 55473 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1270 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 18 | Permit Number 11425 | 6001761.1754 | 2110839.3962 | 37.7760618062261 | -122.437411738171 | (37.7760618062261, -122.437411738171) | 15 | 5 | 11 | 29492 | 10 | ||
| 126360 | 55105 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 219 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11004 | 5998291.6539 | 2109868.1545 | 37.7731971698727 | -122.44934368775 | (37.7731971698727, -122.44934368775) | 15 | 5 | 11 | 29492 | 16 | |
| 105481 | 549 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2899 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009532.5718 | 2102167.7354 | 37.7526901583127 | -122.409916012434 | (37.7526901583127, -122.409916012434) | 2 | 4 | 7 | 28859 | 19 | |||
| 191893 | 54834 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 109 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 17 | Permit Number 10688 | 5998714.6082 | 2110323.5588 | 37.7744717777818 | -122.447913432558 | (37.7744717777818, -122.447913432558) | 15 | 5 | 11 | 29492 | 16 | ||
| 159022 | 54831 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 79 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/1972 12:00:00 AM | 8 | Permit Number 10685 | 6000087.3282 | 2112805.9967 | 37.7813662861419 | -122.443343289517 | (37.7813662861419, -122.443343289517) | 15 | 5 | 1 | 29490 | 16 | ||
| 105187 | 547 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2889 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009603.6887 | 2102171.1765 | 37.7527035922626 | -122.409670319384 | (37.7527035922626, -122.409670319384) | 2 | 4 | 7 | 28859 | 19 | |||
| 89324 | 545 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2878 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6009558.0762 | 2102211.8871 | 37.7528128183786 | -122.409830929661 | (37.7528128183786, -122.409830929661) | 2 | 4 | 7 | 28859 | 19 | |||
| 176892 | 544 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2872 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009585.3031 | 2102212.479 | 37.7528159694172 | -122.409736815429 | (37.7528159694172, -122.409736815429) | 2 | 4 | 7 | 28859 | 19 | |||
| 110511 | 542 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2870 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6009603.0598 | 2102213.6628 | 37.7528202149244 | -122.409675492792 | (37.7528202149244, -122.409675492792) | 2 | 4 | 7 | 28859 | 19 | |||
| 54460 | 54103 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2317 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1972 12:00:00 AM | 3x3 | Permit Number 9832 | 6003101.11509235 | 2116824.39264322 | 37.7925711821936 | -122.433204275613 | (37.7925711821936, -122.433204275613) | 13 | 9 | 1 | 29490 | 27 | ||
| 21482 | 540 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6009646.1294 | 2102175.7647 | 37.7527185686087 | -122.409523875049 | (37.7527185686087, -122.409523875049) | 2 | 4 | 7 | 28859 | 19 | |||
| 27045 | 538 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2860 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009651.0028 | 2102218.3979 | 37.7528359029411 | -122.409510030546 | (37.7528359029411, -122.409510030546) | 2 | 4 | 7 | 28859 | 19 | |||
| 131288 | 53752 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 251 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/1972 12:00:00 AM | 13 | Permit Number 9432 | 6010125.6 | 2121266.3833 | 37.8051637752792 | -122.409212803017 | (37.8051637752792, -122.409212803017) | 3 | 1 | 10 | 308 | 23 | ||
| 60248 | 53539 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 322 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/1969 12:00:00 AM | Permit Number 776401 | 5995280.52661988 | 2113383.63166464 | 37.7826770367733 | -122.460014224406 | (37.7826770367733, -122.460014224406) | 11 | 6 | 2 | 54 | 11 | |||
| 104054 | 53486 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3360 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/1969 12:00:00 AM | 14 | Permit Number 6395 | 5996703.1102 | 2112969.116 | 37.7816206023811 | -122.455062757544 | (37.7816206023811, -122.455062757544) | 11 | 6 | 1 | 54 | 31 | ||
| 76877 | 53483 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 647 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1969 12:00:00 AM | 16 | Permit Number 6392 | 6008737.1169 | 2120721.7235 | 37.8035903907477 | -122.413979278997 | (37.8035903907477, -122.413979278997) | 3 | 1 | 10 | 308 | 23 | ||
| 79122 | 533 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2850 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009680.0053 | 2102218.3979 | 37.7528375279845 | -122.409409734124 | (37.7528375279845, -122.409409734124) | 2 | 4 | 7 | 28859 | 19 | |||
| 189533 | 532 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2850 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009709.5998 | 2102220.1735 | 37.7528440615121 | -122.409307515735 | (37.7528440615121, -122.409307515735) | 2 | 4 | 7 | 28859 | 19 | |||
| 19257 | 531 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2839 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 6009825.6422 | 2102183.2205 | 37.7527490975863 | -122.408903610932 | (37.7527490975863, -122.408903610932) | 2 | 4 | 7 | 28859 | 19 | |||
| 27696 | 53066 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2161 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2006 12:00:00 AM | 4 | Permit Number 49038 | 6002280.6463 | 2114328.4092 | 37.7856712745428 | -122.435864451687 | (37.7856712745428, -122.435864451687) | 13 | 6 | 11 | 29490 | 13 | ||
| 19555 | 529 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2839 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009902.781 | 2102188.0955 | 37.7527668038666 | -122.408637193736 | (37.7527668038666, -122.408637193736) | 2 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );