trees
3,965 rows where qSpecies_id = 70 sorted by PlotSize
This data as json, CSV (advanced)
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29542 | 85499 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Nebraska St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | |||||
| 30617 | 220175 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 40 | Front Yard : Yard | Tree | Private 2 | 17 | 6004976.12829 | 2096559.96941 | 37.7370360990465 | -122.425274005312 | (37.7370360990465, -122.425274005312) | 2 | 7 | 5 | 28859 | 2 | ||||
| 30644 | 188724 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 961 Le Conte Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013382.05808 | 2089359.66984 | 37.7177368520568 | -122.395706366661 | (37.7177368520568, -122.395706366661) | 10 | 3 | 8 | 58 | 1 | ||||
| 30846 | 220142 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2300 22nd St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6011259.06651 | 2103712.6119 | 37.7570286576638 | -122.40405416618 | (37.7570286576638, -122.40405416618) | 10 | 4 | 8 | 28859 | 19 | ||||
| 31010 | 249714 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2975 Broadway | 3 | Back Yard : Yard | Tree | Private 2 | 20 | 5999388.9274 | 2116973.59042 | 37.7927695576174 | -122.446059261445 | (37.7927695576174, -122.446059261445) | 13 | 9 | 1 | 29490 | 27 | ||||
| 31144 | 187736 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301x Cashmere St | 2 | Median : Yard | Tree | DPW 1 | 15 | 6016350.44721 | 2096194.42304 | 37.7366684157019 | -122.385922032401 | (37.7366684157019, -122.385922032401) | 10 | 3 | 8 | 58 | 1 | ||||
| 31158 | 117161 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1383X VERMONT ST | 1 | Front Yard : Cutout | Tree | Private 2 | 6011571 | 2102081 | 37.7525660338429 | -122.402860625738 | (37.7525660338429, -122.402860625738) | 10 | 3 | 8 | 28856 | 29 | |||||
| 31746 | 104753 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2328 12TH AVE | Front Yard : Cutout | Tree | Private 2 | 22 | Permit Number 770921 | 5992676.8 | 2099585.2 | 37.7446400909628 | -122.468017927356 | (37.7446400909628, -122.468017927356) | 1 | 8 | 4 | 29491 | 40 | ||||
| 32089 | 106242 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 De Haro St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Permit Number 770844 | 6012041.04445 | 2105749.16688 | 37.7626642466674 | -122.401492899679 | (37.7626642466674, -122.401492899679) | 8 | 3 | 8 | 28856 | 29 | |||
| 32225 | 121022 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Executive Park Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014230 | 2086988 | 37.7112718434151 | -122.392609576957 | (37.7112718434151, -122.392609576957) | 10 | 3 | 8 | 58 | 1 | |||||
| 32384 | 46269 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2373 REVISED Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Permit Number 44553 | 6003358.75375 | 2116535.00791 | 37.7917912175406 | -122.432292160763 | (37.7917912175406, -122.432292160763) | 13 | 9 | 1 | 29490 | 27 | |||
| 32460 | 46703 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 332(North) Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2002 12:00:00 AM | Permit Number 44834 | 6005821.63060952 | 2110714.77999165 | 37.7759496446584 | -122.423356666691 | (37.7759496446584, -122.423356666691) | 7 | 9 | 11 | 28852 | 10 | |||
| 32513 | 187739 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301x Cashmere St | 18 | Median : Yard | Tree | DPW 1 | 26 | 6016069.71075 | 2096081.97327 | 37.736344111196 | -122.386884828594 | (37.736344111196, -122.386884828594) | 10 | 3 | 8 | 58 | 1 | ||||
| 32544 | 105274 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 232 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986553.3 | 2114252.8 | 37.784557719608 | -122.490270252434 | (37.784557719608, -122.490270252434) | 11 | 6 | 1 | 55 | 33 | |||||
| 32576 | 99657 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1325 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | 1 | 8 | 4 | 59 | 40 | |||||
| 32695 | 38515 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2735 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40502 | 5999957.99990299 | 2117760.48412278 | 37.7949626403238 | -122.444146821557 | (37.7949626403238, -122.444146821557) | 13 | 9 | 1 | 57 | 27 | |||
| 32701 | 247931 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1099 Esmeralda Ave | 4 | Side Yard : Yard | Tree | Private 2 | 6 | 6010377.81236 | 2098773.8118 | 37.7434185228518 | -122.406753840137 | (37.7434185228518, -122.406753840137) | 10 | 7 | 7 | 28859 | 2 | ||||
| 33137 | 220158 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 66 | Front Yard : Yard | Tree | Private 2 | 9 | 6004531.65878 | 2096118.78837 | 37.7357995950731 | -122.426779327416 | (37.7357995950731, -122.426779327416) | 2 | 7 | 5 | 28861 | 2 | ||||
| 33246 | 220147 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 1 | Front Yard : Yard | Tree | Private 2 | 23 | 6004138.65271 | 2095814.53197 | 37.7349419476117 | -122.428116427727 | (37.7349419476117, -122.428116427727) | 2 | 7 | 5 | 28861 | 2 | ||||
| 33714 | 188705 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1998 Revere Ave | 2 | Side Yard : Yard | Tree | Private 2 | 3 | 6013030.362 | 2095929.4873 | 37.7357566623473 | -122.397382506903 | (37.7357566623473, -122.397382506903) | 10 | 3 | 8 | 58 | 1 | ||||
| 34055 | 105417 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X McAllister St | 3 | Front Yard : Yard | Tree | Private 2 | 6002220.78829 | 2111575.67932 | 37.7781095739995 | -122.435874511445 | (37.7781095739995, -122.435874511445) | 15 | 5 | 11 | 29492 | 41 | |||||
| 34078 | 106506 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3975 22nd St | 2 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 773291 | 6002049 | 2102913 | 37.7543142223274 | -122.435848813122 | (37.7543142223274, -122.435848813122) | 2 | 4 | 5 | 28862 | 22 | ||||
| 34135 | 106832 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 138 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 774880 | 5997571.74884 | 2115814.60363 | 37.7894833530272 | -122.452263079899 | (37.7894833530272, -122.452263079899) | 11 | 6 | 1 | 54 | 31 | |||
| 34218 | 32423 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2641 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36950 | 6000352.62092 | 2118166.60357 | 37.7961002417749 | -122.442810555866 | (37.7961002417749, -122.442810555866) | 13 | 9 | 1 | 57 | 17 | ||
| 34698 | 188634 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Helena St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6010981.22837 | 2096191.91786 | 37.7363629384827 | -122.404485665384 | (37.7363629384827, -122.404485665384) | 10 | 3 | 8 | 58 | 1 | ||||
| 35576 | 109177 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 320 COLON AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 5995887.7 | 2094797.5 | 37.7316791433679 | -122.456569176029 | (37.7316791433679, -122.456569176029) | 9 | 7 | 4 | 59 | 40 | ||||
| 35847 | 249706 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2400 Baker St | 38 | Front Yard : Yard | Tree | Private 2 | 10 | 5999689.68932 | 2117193.09573 | 37.7933894315405 | -122.445034403012 | (37.7933894315405, -122.445034403012) | 13 | 9 | 1 | 57 | 27 | ||||
| 35903 | 105966 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 290X Arkansas St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012903.22107 | 2105890.09903 | 37.7630992845925 | -122.398520809474 | (37.7630992845925, -122.398520809474) | 14 | 3 | 8 | 28856 | 29 | |||||
| 36619 | 43982 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 58 Blake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2000 12:00:00 AM | 11 | Permit Number 43545 | 5997823.8786 | 2113381.5676 | 37.7828173196945 | -122.451215205093 | (37.7828173196945, -122.451215205093) | 15 | 6 | 1 | 54 | 31 | ||
| 37172 | 188573 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Pennsylvania Ave | 23 | Front Yard : Yard | Tree | Private 2 | 2 | 6014313.95748 | 2106525.31857 | 37.7649219497227 | -122.393685974041 | (37.7649219497227, -122.393685974041) | 14 | 3 | 8 | 310 | 29 | ||||
| 37336 | 84810 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 654 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2007 12:00:00 AM | Permit No. 49280 | 5997579.9 | 2108309.3 | 37.7688762175244 | -122.451693255762 | (37.7688762175244, -122.451693255762) | 15 | 5 | 11 | 29492 | 9 | |||
| 37466 | 46533 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1526 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44685 | 6001986.07565014 | 2099639.81164239 | 37.7453232498567 | -122.435832240904 | (37.7453232498567, -122.435832240904) | 2 | 7 | 5 | 63 | 22 | ||||
| 37590 | 30343 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3789 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 27 | 6001958.22163 | 2121669.55401 | 37.8058098244409 | -122.437505844543 | (37.8058098244409, -122.437505844543) | 13 | 9 | 1 | 57 | 17 | |||
| 37625 | 175067 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 Thornton Ave | 2 | Side Yard : Yard | Tree | Private 2 | 26 | 6010979.40226 | 2094033.66945 | 37.7304367416449 | -122.404340115499 | (37.7304367416449, -122.404340115499) | 10 | 3 | 7 | 309 | 28 | ||||
| 38356 | 42959 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2616 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42848 | 6003634.5143762 | 2117314.3321902 | 37.7939466747915 | -122.431393686963 | (37.7939466747915, -122.431393686963) | 13 | 9 | 1 | 29490 | 27 | |||
| 38717 | 98546 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 555@Rio Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
| 39146 | 50877 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2601on STEINER Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2004 12:00:00 AM | 14 | Permit Number 47387 | 6002325.56696 | 2115734.74753 | 37.789535271782 | -122.435809697086 | (37.789535271782, -122.435809697086) | 13 | 6 | 1 | 29490 | 27 | ||
| 39243 | 110886 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
| 39452 | 38955 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1322 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1998 12:00:00 AM | Permit Number 40750 | 5999535.03970594 | 2108258.16543211 | 37.7688475919778 | -122.44492690983 | (37.7688475919778, -122.44492690983) | 15 | 5 | 11 | 29492 | 9 | |||
| 40734 | 220146 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 450 Bosworth St | 3 | Front Yard : Yard | Tree | Private 2 | 27 | 6003150.7799 | 2095211.43274 | 37.7332300323227 | -122.431488808967 | (37.7332300323227, -122.431488808967) | 2 | 7 | 5 | 28861 | 25 | ||||
| 40809 | 21052 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2103X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5984987.6230273 | 2100889.8482373 | 37.7477752566644 | -122.494701361992 | (37.7477752566644, -122.494701361992) | 1 | 8 | 3 | 29491 | 35 | ||||
| 40864 | 59299 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2105 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1980 12:00:00 AM | 3 | Permit Number 18637 | 6003797.66413 | 2115784.10582 | 37.7897543079647 | -122.430719923706 | (37.7897543079647, -122.430719923706) | 13 | 9 | 1 | 29490 | 27 | ||
| 41779 | 246827 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400 Franconia St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | 6009974.41819 | 2098730.47702 | 37.7432769560816 | -122.408145625541 | (37.7432769560816, -122.408145625541) | 10 | 7 | 7 | 28859 | 2 | ||||
| 42050 | 64574 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2872 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1988 12:00:00 AM | 25 | Permit Number 25468 | 5995849.04615 | 2111058.0388 | 37.7763242568893 | -122.45787905836 | (37.7763242568893, -122.45787905836) | 11 | 6 | 2 | 54 | 16 | ||
| 42127 | 247539 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6000199.67712 | 2108517.8655 | 37.7695985727307 | -122.442646631948 | (37.7695985727307, -122.442646631948) | 15 | 5 | 11 | 29492 | 9 | ||||
| 42339 | 247532 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6000110.00328 | 2108483.6988 | 37.7694996473165 | -122.442954355683 | (37.7694996473165, -122.442954355683) | 15 | 5 | 11 | 29492 | 9 | ||||
| 42888 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Hiliritas Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | 2 | 7 | 5 | 63 | 7 | ||||
| 43206 | 187735 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 299x Cashmere St | 23 | Median : Yard | Tree | DPW 1 | 21 | 6016637.03713 | 2096003.63788 | 37.7361604138763 | -122.384917870088 | (37.7361604138763, -122.384917870088) | 10 | 3 | 8 | 58 | 1 | ||||
| 43870 | 188564 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Vermont St | 4 | Back Yard : Yard | Tree | Private 2 | 21 | 6011131.87643 | 2106822.77201 | 37.7655613532939 | -122.404712987912 | (37.7655613532939, -122.404712987912) | 8 | 3 | 8 | 28853 | 19 | ||||
| 44628 | 188723 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 961 Le Conte Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6013346.44573 | 2089388.27628 | 37.7178134185452 | -122.395831466855 | (37.7178134185452, -122.395831466855) | 10 | 3 | 8 | 58 | 1 | ||||
| 44642 | 187763 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 135 Reardon Rd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6018954.68397 | 2093453.67115 | 37.7292866202724 | -122.376727902495 | (37.7292866202724, -122.376727902495) | 10 | 3 | 8 | 58 | 1 | ||||
| 45267 | 38477 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1998 12:00:00 AM | 12 | Permit Number 40477 | 5987973.38245 | 2115305.78698 | 37.7875317543588 | -122.48543460753 | (37.7875317543588, -122.48543460753) | 11 | 6 | 1 | 55 | 33 | ||
| 45428 | 443 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700x 23rd Ave | 3 | Median : Cutout | Tree | DPW 1 | 3 | 5988815.98803 | 2110428.99683 | 37.7741905124987 | -122.482161976658 | (37.7741905124987, -122.482161976658) | 11 | 6 | 2 | 55 | 26 | ||||
| 45747 | 201375 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Fairfax Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 6018327.36542 | 2095666.89439 | 37.7353291318294 | -122.379050271262 | (37.7353291318294, -122.379050271262) | 10 | 3 | 8 | 58 | 1 | ||||
| 45821 | 50989 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3880 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Permit Number 47473 | 5996269.10887 | 2115596.09858 | 37.7888086870176 | -122.456754234819 | (37.7888086870176, -122.456754234819) | 11 | 6 | 1 | 54 | 31 | |||
| 46123 | 101424 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6000365.03159 | 2116237.93468 | 37.7908053312568 | -122.442629063689 | (37.7908053312568, -122.442629063689) | 13 | 6 | 1 | 29490 | 27 | ||||
| 46736 | 47791 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 415 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45915 | 5995369.31891331 | 2098249.44976906 | 37.741127575703 | -122.45861111062 | (37.741127575703, -122.45861111062) | 1 | 8 | 4 | 59 | 40 | ||
| 46939 | 220174 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 39 | Front Yard : Yard | Tree | Private 2 | 8 | 6004973.16585 | 2096557.19919 | 37.7370283252818 | -122.425284050737 | (37.7370283252818, -122.425284050737) | 2 | 7 | 5 | 28859 | 2 | ||||
| 48043 | 102629 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 168 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Permit Number 769953 | 5988063.8153 | 2114882.99878 | 37.7863761669029 | -122.485090700066 | (37.7863761669029, -122.485090700066) | 11 | 6 | 1 | 55 | 33 | |||
| 48525 | 188644 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Cargo Way | 4 | Median : Yard | Tree | DPW 1 | 27 | 6018318.49597 | 2097930.97465 | 37.7415453582258 | -122.379238145042 | (37.7415453582258, -122.379238145042) | 10 | 3 | 8 | 58 | 1 | ||||
| 48779 | 203876 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 41 Ralston St | 4 | Back Yard : Yard | Tree | Private 2 | 25 | 5992169.18145 | 2088225.46502 | 37.7134197536892 | -122.468946631609 | (37.7134197536892, -122.468946631609) | 9 | 8 | 6 | 64 | 24 | ||||
| 49173 | 94915 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1922 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2010 12:00:00 AM | 16 | 5993509.6 | 2102385.8 | 37.752377883346 | -122.465341688659 | (37.752377883346, -122.465341688659) | 1 | 8 | 4 | 29491 | 12 | |||
| 49519 | 188657 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Cargo Way | 123 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6016750.16767 | 2099204.87087 | 37.7449566081772 | -122.384749662688 | (37.7449566081772, -122.384749662688) | 10 | 3 | 8 | 58 | 1 | ||||
| 49584 | 101654 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 465 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5991223.42773 | 2112267.5766 | 37.7793784815584 | -122.473968464522 | (37.7793784815584, -122.473968464522) | 11 | 6 | 2 | 54 | 26 | ||||
| 49681 | 116977 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x CARGO WAY | 117 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
| 49703 | 48683 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3839 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2002 12:00:00 AM | 24 | Permit Number 45963 | 5996485.35892 | 2115571.58061 | 37.7887537816114 | -122.456004271305 | (37.7887537816114, -122.456004271305) | 11 | 6 | 1 | 54 | 31 | ||
| 49773 | 111913 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3333 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6003233.77012 | 2119841.33042 | 37.8008624380147 | -122.432960922718 | (37.8008624380147, -122.432960922718) | 13 | 9 | 1 | 57 | 17 | ||||
| 49929 | 448 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700x 23rd Ave | 8 | Median : Cutout | Tree | DPW 1 | 3 | 5988818.05287 | 2110350.21953 | 37.7739743319878 | -122.482149061597 | (37.7739743319878, -122.482149061597) | 11 | 6 | 2 | 55 | 26 | ||||
| 50305 | 247535 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Waller St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6000144.0267 | 2108489.25837 | 37.7695168522425 | -122.442837069672 | (37.7695168522425, -122.442837069672) | 15 | 5 | 11 | 29492 | 9 | ||||
| 50374 | 87004 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
| 50973 | 43163 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 8 | Permit Number 42973 | 6005640.84958 | 2092540.26694 | 37.7260364164322 | -122.422690190993 | (37.7260364164322, -122.422690190993) | 9 | 7 | 7 | 309 | 5 | |
| 51024 | 105872 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 595X San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6006124.47156 | 2100100.14306 | 37.7468214281195 | -122.421555015777 | (37.7468214281195, -122.421555015777) | 2 | 7 | 7 | 28859 | 2 | |||||
| 51248 | 188655 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300x Cargo Way | 5 | Median : Yard | Tree | DPW 1 | 22 | 6017659.9469 | 2098420.67777 | 37.7428536469791 | -122.381549254301 | (37.7428536469791, -122.381549254301) | 10 | 3 | 8 | 58 | 1 | ||||
| 51410 | 187757 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6017577.45499 | 2093289.42876 | 37.7287597011768 | -122.38147773753 | (37.7287597011768, -122.38147773753) | 10 | 3 | 8 | 58 | 1 | ||||
| 51426 | 188679 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Middle Point Rd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6018264.75043 | 2096477.95592 | 37.7375526939091 | -122.379323076118 | (37.7375526939091, -122.379323076118) | 10 | 3 | 8 | 58 | 1 | ||||
| 51559 | 249687 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2400 Baker St | 19 | Front Yard : Yard | Tree | Private 2 | 37 | 5999715.024 | 2117348.66269 | 37.7938180232448 | -122.444957931866 | (37.7938180232448, -122.444957931866) | 13 | 9 | 1 | 57 | 27 | ||||
| 51614 | 111552 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x BOSWORTH ST | 30 | Front Yard : Yard | Tree | DPW 1 | 6 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 52491 | 98830 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 333@Lopez Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994230.9 | 2100817.4 | 37.748113026994 | -122.462733567037 | (37.748113026994, -122.462733567037) | 1 | 8 | 4 | 29491 | 40 | |||||
| 52641 | 30419 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 599 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/1956 12:00:00 AM | Permit Number 74 | 6011244.65303661 | 2117958.27162773 | 37.7961431366669 | -122.405107081517 | (37.7961431366669, -122.405107081517) | 3 | 1 | 10 | 28857 | 4 | |||
| 52837 | 99659 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1325 Portola Dr | 3 | Front Yard : Yard | Tree | Private 2 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | 1 | 8 | 4 | 59 | 40 | |||||
| 53086 | 99902 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
| 53341 | 255638 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 220 Masonic Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999023 | 2112089 | 37.7793368479896 | -122.446973720271 | (37.7793368479896, -122.446973720271) | 15 | 5 | 1 | 54 | 16 | |||||
| 53964 | 106787 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400 17TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5990900.3 | 2105751.3 | 37.7614678308385 | -122.474610582701 | (37.7614678308385, -122.474610582701) | 1 | 8 | 4 | 56 | 12 | |||||
| 54170 | 101422 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 6000369.95559 | 2116208.82574 | 37.790725686401 | -122.442609936018 | (37.790725686401, -122.442609936018) | 13 | 6 | 1 | 29490 | 27 | ||||
| 54202 | 107622 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 191 HAIGHT ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | 6005238.1 | 2109520.1 | 37.7726363924224 | -122.425290219951 | (37.7726363924224, -122.425290219951) | 7 | 9 | 11 | 28852 | 10 | ||||
| 54519 | 220179 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 44 | Front Yard : Yard | Tree | Private 2 | 22 | 6004963.53829 | 2096567.90345 | 37.7370571728501 | -122.42531809906 | (37.7370571728501, -122.42531809906) | 2 | 7 | 5 | 28859 | 2 | ||||
| 54547 | 105345 | - 12 | Acacia melanoxylon :: Blackwood Acacia 70 | 466 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5989603.4 | 2089229.6 | 37.7160282834266 | -122.477888136934 | (37.7160282834266, -122.477888136934) | 1 | 8 | 4 | 64 | 14 | |||||
| 54987 | 187761 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1040 Palou Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6017511.07328 | 2093334.48306 | 37.7288797462969 | -122.381710357951 | (37.7288797462969, -122.381710357951) | 10 | 3 | 8 | 58 | 1 | ||||
| 55998 | 99606 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | ||||
| 56164 | 32303 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 750 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Permit Number 36880 | 5990706.9497 | 2110266.10779 | 37.7738530681416 | -122.475608974177 | (37.7738530681416, -122.475608974177) | 11 | 6 | 2 | 54 | 26 | |||
| 56173 | 53099 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 370@HILL WAY Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2006 12:00:00 AM | Permit Number 49061 | 5996124.75088045 | 2106531.46709728 | 37.7639113030063 | -122.456597900952 | (37.7639113030063, -122.456597900952) | 15 | 5 | 11 | 29492 | 12 | |||
| 56627 | 111324 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Peabody St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6010207.43823 | 2087366.89683 | 37.7120879953496 | -122.406539311355 | (37.7120879953496, -122.406539311355) | 9 | 7 | 8 | 309 | 39 | ||||
| 57172 | 6797 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1375 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2011 12:00:00 AM | 3 | 6016896.75135 | 2097199.75019 | 37.7394590596789 | -122.384103192232 | (37.7394590596789, -122.384103192232) | 10 | 3 | 8 | 58 | 1 | |||
| 57473 | 203823 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 830 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5996652.15177 | 2095040.88377 | 37.7323912769404 | -122.453943898404 | (37.7323912769404, -122.453943898404) | 9 | 7 | 4 | 59 | 40 | ||||
| 57615 | 188567 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500 24th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6016949.54535 | 2102644.83882 | 37.7544130748234 | -122.384299775913 | (37.7544130748234, -122.384299775913) | 3 | 8 | 28856 | 29 | |||||
| 58489 | 104690 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1435X La Salle Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770699 | 6016460.43075 | 2095036.98644 | 37.7334964128222 | -122.385461132957 | (37.7334964128222, -122.385461132957) | 10 | 3 | 8 | 58 | 1 | ||||
| 58946 | 30316 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1955 12:00:00 AM | Permit Number 12 | 6009097.70753924 | 2116729.99483623 | 37.7926503347532 | -122.412449106972 | (37.7926503347532, -122.412449106972) | 3 | 1 | 10 | 28857 | 21 | |||
| 58980 | 220171 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 35 | Front Yard : Yard | Tree | Private 2 | 23 | 6004943.37646 | 2096556.00352 | 37.7370233592275 | -122.425386961047 | (37.7370233592275, -122.425386961047) | 2 | 7 | 5 | 28859 | 2 | ||||
| 59144 | 52034 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2960 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Permit Number 48246 | 6002027.71863 | 2118348.63065 | 37.7966953942316 | -122.437027433096 | (37.7966953942316, -122.437027433096) | 13 | 9 | 1 | 57 | 17 | |||
| 59675 | 110867 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 |
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) );