trees
3,965 rows where qSpecies_id = 70 sorted by Fire Prevention Districts descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1031 | 203993 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 62 Eastwood Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 3ft | 5995660.26957 | 2093014.24924 | 37.7267697065318 | -122.457226490416 | (37.7267697065318, -122.457226490416) | 9 | 7 | 4 | 28861 | 40 | |||
| 1424 | 264758 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007165 | 2087428 | 37.7120850908031 | -122.417059211527 | (37.7120850908031, -122.417059211527) | 9 | 7 | 8 | 309 | 39 | ||||
| 2088 | 203278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 618 Detroit St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5999459.31749 | 2095070.52066 | 37.7326332062613 | -122.444241033706 | (37.7326332062613, -122.444241033706) | 9 | 7 | 4 | 63 | 40 | |||
| 2155 | 174995 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 83 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6000678.32688 | 2088039.79794 | 37.71339791366 | -122.439522805332 | (37.71339791366, -122.439522805332) | 9 | 7 | 6 | 28861 | 5 | |||
| 2829 | 264759 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunnydale Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007165 | 2087428 | 37.7120850908031 | -122.417059211527 | (37.7120850908031, -122.417059211527) | 9 | 7 | 8 | 309 | 39 | ||||
| 3045 | 261353 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 160 Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5990864 | 2091394 | 37.7220442755547 | -122.473688749933 | (37.7220442755547, -122.473688749933) | 9 | 8 | 4 | 64 | 40 | ||||
| 3286 | 264753 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 176 Hahn St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
| 3727 | 175033 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 120 Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010491.77199 | 2086707.01072 | 37.7102919844537 | -122.405510120904 | (37.7102919844537, -122.405510120904) | 9 | 7 | 8 | 309 | 39 | |||
| 3768 | 262321 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990975 | 2093805 | 37.7286707085155 | -122.473480827138 | (37.7286707085155, -122.473480827138) | 9 | 8 | 4 | 64 | 40 | ||||
| 4735 | 262469 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 35 Broadmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2x6 | 5991096 | 2093545 | 37.7279638199594 | -122.4730435743 | (37.7279638199594, -122.4730435743) | 9 | 8 | 4 | 64 | 40 | ||||
| 5478 | 175059 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 12 Valmar Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005473.36477 | 2092951.58695 | 37.7271563601569 | -122.423298402505 | (37.7271563601569, -122.423298402505) | 9 | 7 | 6 | 28861 | 5 | |||
| 5486 | 203905 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5000 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 8ft | 5990628.48581 | 2093315.14661 | 37.7273056215527 | -122.474642998573 | (37.7273056215527, -122.474642998573) | 9 | 8 | 4 | 64 | 40 | |||
| 5779 | 175064 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 68 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6007788.38725 | 2093731.97467 | 37.7294295189361 | -122.415350591757 | (37.7294295189361, -122.415350591757) | 9 | 3 | 7 | 309 | 28 | |||
| 6698 | 261941 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Verna St | 6 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
| 7206 | 264879 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 94 Stratford Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4x6 | 5990921 | 2091777 | 37.7230991995598 | -122.473519640019 | (37.7230991995598, -122.473519640019) | 9 | 8 | 4 | 64 | 40 | ||||
| 7938 | 369 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3690X 19th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 25 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
| 8318 | 98543 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 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 | |||||
| 8673 | 175076 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1262 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6001389.55659 | 2087620.87899 | 37.7122881079857 | -122.437034577295 | (37.7122881079857, -122.437034577295) | 9 | 7 | 6 | 28861 | 5 | |||
| 10158 | 203254 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 355 Hazelwood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5996025.0602 | 2095489.12153 | 37.7335860541429 | -122.456144283154 | (37.7335860541429, -122.456144283154) | 9 | 7 | 4 | 59 | 40 | |||
| 12649 | 157063 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1617 Plymouth Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 0 | Width 10ft | 5995578.39636 | 2094696.59169 | 37.7313843105403 | -122.457631195237 | (37.7313843105403, -122.457631195237) | 9 | 7 | 4 | 59 | 40 | |||
| 12775 | 260566 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Denslowe Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 5990592.24818 | 2090826.09743 | 37.7204692135739 | -122.474586693137 | (37.7204692135739, -122.474586693137) | 9 | 8 | 4 | 64 | 40 | |||||
| 13081 | 203859 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5991237.16543 | 2090216.16791 | 37.7188318441037 | -122.472313003552 | (37.7188318441037, -122.472313003552) | 9 | 8 | 6 | 64 | 24 | |||
| 14302 | 175030 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010584.6901 | 2086918.22746 | 37.710877138233 | -122.405203838782 | (37.710877138233, -122.405203838782) | 9 | 7 | 8 | 309 | 39 | |||
| 15254 | 260460 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1798X Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x10 | 5992678 | 2095461 | 37.733316146518 | -122.467713892437 | (37.733316146518, -122.467713892437) | 9 | 8 | 4 | 59 | 40 | ||||
| 15872 | 203996 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 855 Monterey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5996332.32562 | 2094668.87187 | 37.7313514789886 | -122.455022734117 | (37.7313514789886, -122.455022734117) | 9 | 7 | 4 | 59 | 40 | |||
| 16020 | 96530 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.403368705104 | (37.7117912459807, -122.403368705104) | 9 | 7 | 8 | 309 | 39 | |||
| 16264 | 111321 | Section 806 (d) 5 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Peabody St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6010185.88551 | 2087316.24933 | 37.7119477217782 | -122.406610237293 | (37.7119477217782, -122.406610237293) | 9 | 7 | 8 | 309 | 39 | ||||
| 17569 | 98514 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1209 Capitol Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995023.6 | 2091955.9 | 37.7238271478872 | -122.45935081328 | (37.7238271478872, -122.45935081328) | 9 | 8 | 4 | 28861 | 24 | ||||
| 18941 | 264761 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 240 Hahn St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007356 | 2087104 | 37.7112061971181 | -122.416376123926 | (37.7112061971181, -122.416376123926) | 9 | 7 | 8 | 309 | 39 | ||||
| 19477 | 203874 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Sargent St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 5993391.13026 | 2089210.06391 | 37.7161937512299 | -122.464794638879 | (37.7161937512299, -122.464794638879) | 9 | 8 | 6 | 64 | 24 | |||
| 20230 | 203896 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5990596.84308 | 2090479.69294 | 37.7195183388684 | -122.474545542655 | (37.7195183388684, -122.474545542655) | 9 | 8 | 4 | 64 | 40 | |||
| 21622 | 175038 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 137 Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010492.95199 | 2086616.94014 | 37.7100447347569 | -122.405499703176 | (37.7100447347569, -122.405499703176) | 9 | 7 | 8 | 309 | 39 | |||
| 23323 | 203284 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 436 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 7ft | 5999187.02892 | 2095000.6796 | 37.73242590082 | -122.445177379037 | (37.73242590082, -122.445177379037) | 9 | 7 | 4 | 59 | 40 | |||
| 23392 | 203897 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3804 19th Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 5990591.46397 | 2090484.77315 | 37.7195319761952 | -122.474564506644 | (37.7195319761952, -122.474564506644) | 9 | 8 | 4 | 64 | 40 | |||
| 23841 | 203991 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 61 Westwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995098.20375 | 2093017.11176 | 37.7267452692552 | -122.45916973021 | (37.7267452692552, -122.45916973021) | 9 | 7 | 4 | 28861 | 40 | |||
| 24057 | 175026 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Raymond Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6011082.6747 | 2087261.47183 | 37.7118474464748 | -122.403506811807 | (37.7118474464748, -122.403506811807) | 9 | 7 | 8 | 309 | 39 | |||
| 24797 | 203992 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 402 Montecito Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5995690.08771 | 2093990.03586 | 37.7294506943798 | -122.457193967347 | (37.7294506943798, -122.457193967347) | 9 | 7 | 4 | 28861 | 40 | |||
| 25108 | 97979 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 9 | Front Yard : Yard | Tree | Private 2 | 17 | 3x105 | Permit Number 767976 | 6008557.48708 | 2094193.99719 | 37.730741330332 | -122.412724380735 | (37.730741330332, -122.412724380735) | 9 | 3 | 7 | 309 | 28 | ||
| 25220 | 203990 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 61 Westwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995096.59699 | 2093007.77703 | 37.7267195459651 | -122.459174609041 | (37.7267195459651, -122.459174609041) | 9 | 7 | 4 | 28861 | 40 | |||
| 25537 | 175005 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 183 Curtis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6000792.5891 | 2087495.45523 | 37.7119097722015 | -122.439088886968 | (37.7119097722015, -122.439088886968) | 9 | 7 | 6 | 28861 | 5 | |||
| 25538 | 97980 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 10 | Front Yard : Yard | Tree | Private 2 | 3x105 | Permit Number 767976 | 6008582.5 | 2094142.5 | 37.7306013339748 | -122.412634267782 | (37.7306013339748, -122.412634267782) | 9 | 3 | 7 | 309 | 28 | |||
| 25711 | 111769 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 855 MONTEREY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996319 | 2094654 | 37.7313098799379 | -122.455067728735 | (37.7313098799379, -122.455067728735) | 9 | 7 | 4 | 28861 | 40 | ||||
| 26139 | 253819 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100x Prague St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001057 | 2086858 | 37.7101745029318 | -122.43812937572 | (37.7101745029318, -122.43812937572) | 9 | 7 | 6 | 28861 | 5 | |||||
| 26685 | 324 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3470X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2008 12:00:00 AM | 20 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
| 27679 | 175034 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 132 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010467.70028 | 2086649.87132 | 37.7101337451556 | -122.40558929631 | (37.7101337451556, -122.40558929631) | 9 | 7 | 8 | 309 | 39 | |||
| 28555 | 112249 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 133X EUCALYPTUS DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991186 | 2094598 | 37.730860304248 | -122.472809193365 | (37.730860304248, -122.472809193365) | 9 | 8 | 4 | 64 | 40 | ||||
| 28825 | 30290 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Bowdoin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1956 12:00:00 AM | Permit Number 134 | 6009266.77435284 | 2092132.72070272 | 37.725121286809 | -122.410126783708 | (37.725121286809, -122.410126783708) | 9 | 3 | 7 | 309 | 28 | |||
| 29531 | 11850 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1401X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3 | 5991539.129622 | 2088082.4465587 | 37.7129906371476 | -122.471113878415 | (37.7129906371476, -122.471113878415) | 9 | 8 | 6 | 64 | 24 | |||
| 30315 | 114947 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 146 STRATFORD DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990875 | 2091468 | 37.7222480982686 | -122.473656121456 | (37.7222480982686, -122.473656121456) | 9 | 8 | 4 | 64 | 40 | ||||
| 31114 | 175073 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1109 Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6001851.58682 | 2087075.00114 | 37.7108154987183 | -122.435398641242 | (37.7108154987183, -122.435398641242) | 9 | 7 | 6 | 28861 | 5 | |||
| 31283 | 203854 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1209 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995041.91528 | 2091943.51422 | 37.7237941925307 | -122.4592866043 | (37.7237941925307, -122.4592866043) | 9 | 8 | 4 | 28861 | 24 | |||
| 31651 | 174975 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 650 Amazon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6002092.43802 | 2088621.22126 | 37.7150747544838 | -122.434676698769 | (37.7150747544838, -122.434676698769) | 9 | 7 | 6 | 28861 | 5 | |||
| 31813 | 203888 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 177 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 2ft | 5990956.3868 | 2094658.3857 | 37.7310128131833 | -122.473607398684 | (37.7310128131833, -122.473607398684) | 9 | 8 | 4 | 64 | 40 | |||
| 32815 | 253627 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 5991061 | 2093828 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | 9 | 8 | 4 | 64 | 40 | ||||
| 33679 | 253604 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 267 Teresita Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5997729 | 2098564 | 37.7421265906625 | -122.450474893449 | (37.7421265906625, -122.450474893449) | 9 | 7 | 4 | 59 | 40 | ||||
| 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 | ||||
| 35837 | 114606 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 36 CURTIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000494 | 2088444 | 37.7144972695987 | -122.440188869703 | (37.7144972695987, -122.440188869703) | 9 | 7 | 6 | 28861 | 5 | ||||
| 36038 | 115661 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 341 HAZELWOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5996066 | 2095432 | 37.7334315621613 | -122.455998615118 | (37.7334315621613, -122.455998615118) | 9 | 7 | 4 | 59 | 40 | |||
| 36882 | 96532 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.403368705104 | (37.7117912459807, -122.403368705104) | 9 | 7 | 8 | 309 | 39 | |||
| 38134 | 175024 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Raymond Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011045.77873 | 2087277.95122 | 37.7118906346058 | -122.403635493987 | (37.7118906346058, -122.403635493987) | 9 | 7 | 8 | 309 | 39 | |||
| 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 | |||||
| 38725 | 97974 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 14 | 3x3 | Permit Number 767976 | 6008567.92648 | 2094152.82902 | 37.7306288773042 | -122.412685380727 | (37.7306288773042, -122.412685380727) | 9 | 3 | 7 | 309 | 28 | |
| 39726 | 203249 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 380 Valdez Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5995787.98942 | 2095468.33628 | 37.7335153719345 | -122.456962397309 | (37.7335153719345, -122.456962397309) | 9 | 7 | 4 | 59 | 40 | |||
| 39911 | 97975 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 5 | Front Yard : Yard | Tree | Private 2 | 10 | 3x105 | Permit Number 767976 | 6008564.43786 | 2094166.6254 | 37.7306665633988 | -122.412698416414 | (37.7306665633988, -122.412698416414) | 9 | 3 | 7 | 309 | 28 | ||
| 41350 | 203279 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 59 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 5999700.96572 | 2095477.61898 | 37.7337647863229 | -122.44343483107 | (37.7337647863229, -122.44343483107) | 9 | 7 | 4 | 63 | 40 | |||
| 41461 | 203906 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 4996 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5990638.47075 | 2093500.44016 | 37.727814969685 | -122.47462199853 | (37.727814969685, -122.47462199853) | 9 | 8 | 4 | 64 | 40 | |||
| 41920 | 203836 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 386 Hazelwood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5995958.60933 | 2095699.73792 | 37.7341605410715 | -122.456389245893 | (37.7341605410715, -122.456389245893) | 9 | 7 | 4 | 59 | 40 | |||
| 42797 | 203857 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991224.82027 | 2090017.23176 | 37.7182848998132 | -122.472341181102 | (37.7182848998132, -122.472341181102) | 9 | 8 | 6 | 64 | 24 | |||
| 43462 | 24278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 350X Winding Way | 16 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6000808.42529 | 2086790.57674 | 37.709975233345 | -122.438983668972 | (37.709975233345, -122.438983668972) | 9 | 7 | 6 | 28861 | 5 | |||
| 44421 | 113145 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 150 BROADMOOR DR | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990980 | 2092843 | 37.7260295867704 | -122.473393404688 | (37.7260295867704, -122.473393404688) | 9 | 8 | 4 | 64 | 40 | ||||
| 44618 | 175041 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Burr Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6007781.09007 | 2086643.56012 | 37.7099658201356 | -122.414874335982 | (37.7099658201356, -122.414874335982) | 9 | 7 | 8 | 309 | 39 | |||
| 44801 | 25393 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1051 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6001007.68114 | 2088741.24323 | 37.7153426652198 | -122.438434668834 | (37.7153426652198, -122.438434668834) | 9 | 7 | 6 | 28861 | 5 | |||
| 45033 | 203285 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 436 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 5999181.66056 | 2095001.81408 | 37.7324287094117 | -122.445196020186 | (37.7324287094117, -122.445196020186) | 9 | 7 | 4 | 59 | 40 | |||
| 45252 | 256859 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 356 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5991007 | 2092571 | 37.7252843060575 | -122.473280239218 | (37.7252843060575, -122.473280239218) | 9 | 8 | 4 | 64 | 40 | ||||
| 46279 | 254187 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 128 Stonecrest Dr | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990776 | 2093635 | 37.7281924051657 | -122.474156376051 | (37.7281924051657, -122.474156376051) | 9 | 8 | 4 | 64 | 40 | |||||
| 47940 | 97971 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 3x105 | 6008579.18793 | 2094106.30305 | 37.7305017590298 | -122.412643160269 | (37.7305017590298, -122.412643160269) | 9 | 3 | 7 | 309 | 28 | |||
| 48296 | 11709 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700X Junipero Serra Blvd | 26 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.83406 | 2092750.40868 | 37.7257930014245 | -122.472332875878 | (37.7257930014245, -122.472332875878) | 9 | 8 | 4 | 64 | 40 | ||
| 48392 | 175001 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Newton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 5ft | 6000856.01918 | 2088342.93848 | 37.714240381459 | -122.438930350851 | (37.714240381459, -122.438930350851) | 9 | 7 | 6 | 28861 | 5 | |||
| 48689 | 203870 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 9 Granada Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995594.9546 | 2089959.93559 | 37.7183795372759 | -122.457231426804 | (37.7183795372759, -122.457231426804) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | ||||
| 49122 | 175035 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 177 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010415.17043 | 2086409.01493 | 37.7094694645007 | -122.405753896527 | (37.7094694645007, -122.405753896527) | 9 | 7 | 8 | 309 | 39 | |||
| 50041 | 203817 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1615 Monterey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 4ft | 5993108.74619 | 2095336.27282 | 37.7329985387476 | -122.46621563515 | (37.7329985387476, -122.46621563515) | 9 | 8 | 4 | 59 | 40 | |||
| 50479 | 120538 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002576.6751 | 2087720.05109 | 37.7126278178947 | -122.43293862582 | (37.7126278178947, -122.43293862582) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |
| 51482 | 203865 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995933.09889 | 2089739.90956 | 37.7177948124633 | -122.456046712088 | (37.7177948124633, -122.456046712088) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | ||||
| 52910 | 203779 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 788 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 10ft | 5994915.16771 | 2093240.53783 | 37.7273482188287 | -122.459818653129 | (37.7273482188287, -122.459818653129) | 9 | 7 | 4 | 28861 | 40 | |||
| 55364 | 11774 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 2x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
| 55903 | 203855 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 330 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5994200.98333 | 2092085.6479 | 37.7241360734166 | -122.46220384765 | (37.7241360734166, -122.46220384765) | 9 | 8 | 4 | 28861 | 24 | |||
| 56494 | 254186 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 120 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990762 | 2093642 | 37.7282108143844 | -122.474205284655 | (37.7282108143844, -122.474205284655) | 9 | 8 | 4 | 64 | 40 | ||||
| 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 | ||||
| 57232 | 100838 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 10X Tulane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x9 | 6007491.7 | 2093814.7 | 37.7296399852574 | -122.416382127882 | (37.7296399852574, -122.416382127882) | 9 | 3 | 7 | 309 | 28 | ||||
| 57299 | 203860 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1025 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5991248.87422 | 2090355.17031 | 37.719214188172 | -122.472282658627 | (37.719214188172, -122.472282658627) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 58144 | 175023 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Raymond Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011015.66047 | 2087294.85448 | 37.7119353650883 | -122.403740780316 | (37.7119353650883, -122.403740780316) | 9 | 7 | 8 | 309 | 39 | |||
| 58812 | 175007 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 183 Curtis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6000780.85798 | 2087537.73014 | 37.712025182185 | -122.439132460907 | (37.712025182185, -122.439132460907) | 9 | 7 | 6 | 28861 | 5 | |||
| 60433 | 203901 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3794 19th Ave | 3 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 12 | Width 3ft | 5990470.12167 | 2090714.31084 | 37.720155198286 | -122.475000685058 | (37.720155198286, -122.475000685058) | 9 | 8 | 4 | 64 | 40 | |||
| 62177 | 99097 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5994003.8 | 2097131.6 | 37.7379796635799 | -122.463251452094 | (37.7379796635799, -122.463251452094) | 9 | 8 | 4 | 59 | 40 | |||||
| 62581 | 175058 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1132x Alemany Blvd | 2 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6003548.97454 | 2094354.07012 | 37.7308984688672 | -122.430051002559 | (37.7308984688672, -122.430051002559) | 9 | 7 | 6 | 28861 | 25 | |||
| 63078 | 396 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3790X 19th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 2 | 5990481.42225 | 2090722.77019 | 37.7201790804753 | -122.474962240321 | (37.7201790804753, -122.474962240321) | 9 | 8 | 4 | 64 | 40 |
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) );