trees
8,298 rows where qLegalStatus_id = 4 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194507 | 265147 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1362 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5993998 | 2106231 | 37.7629639639015 | -122.463931825158 | (37.7629639639015, -122.463931825158) | 1 | 5 | 11 | 56 | 12 | ||||
| 194479 | 265136 | Undocumented 4 | :: Tree 573 | 100 Winston Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990934 | 2093194 | 37.7269906812088 | -122.47357801435 | (37.7269906812088, -122.47357801435) | 9 | 8 | 4 | 64 | 40 | ||||
| 194466 | 265098 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 194464 | 265097 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 194463 | 265099 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 194453 | 265096 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 880 Urbano Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15x4 | 5993935 | 2091989 | 37.7238553830872 | -122.46311629567 | (37.7238553830872, -122.46311629567) | 9 | 8 | 4 | 59 | 40 | ||||
| 194431 | 265089 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 747 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002550 | 2089172 | 37.7166130372881 | -122.433134500018 | (37.7166130372881, -122.433134500018) | 9 | 7 | 6 | 28861 | 5 | ||||
| 194407 | 265071 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 430 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000887 | 2092304 | 37.7251183251209 | -122.439106989741 | (37.7251183251209, -122.439106989741) | 9 | 7 | 6 | 28861 | 25 | ||||
| 194406 | 265062 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 285 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992682 | 2089081 | 37.7157984624799 | -122.46723633367 | (37.7157984624799, -122.46723633367) | 9 | 8 | 6 | 64 | 24 | ||||
| 194380 | 255779 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 45 Niagara Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/08/2017 12:00:00 AM | 3 | 3x3 | 5999808 | 2089058 | 37.7161440949055 | -122.442604012325 | (37.7161440949055, -122.442604012325) | 9 | 7 | 6 | 28861 | 25 | |
| 194365 | 265036 | Undocumented 4 | Potential Site :: Potential Site 48 | 1250X Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009246 | 2101881 | 37.7518867820544 | -122.410886782822 | (37.7518867820544, -122.410886782822) | 2 | 4 | 7 | 28859 | 19 | |||||
| 194364 | 265034 | Undocumented 4 | Potential Site :: Potential Site 48 | 3012 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009402 | 2101646 | 37.7512502705876 | -122.410330719668 | (37.7512502705876, -122.410330719668) | 2 | 4 | 7 | 28859 | 19 | ||||
| 194353 | 265038 | Undocumented 4 | Potential Site :: Potential Site 48 | 1250X Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009246 | 2101881 | 37.7518867820544 | -122.410886782822 | (37.7518867820544, -122.410886782822) | 2 | 4 | 7 | 28859 | 19 | |||||
| 194339 | 265037 | Undocumented 4 | Potential Site :: Potential Site 48 | 1250X Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009246 | 2101881 | 37.7518867820544 | -122.410886782822 | (37.7518867820544, -122.410886782822) | 2 | 4 | 7 | 28859 | 19 | |||||
| 194337 | 265035 | Undocumented 4 | Potential Site :: Potential Site 48 | 1250X Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009246 | 2101881 | 37.7518867820544 | -122.410886782822 | (37.7518867820544, -122.410886782822) | 2 | 4 | 7 | 28859 | 19 | |||||
| 194229 | 98736 | Undocumented 4 | Tree(s) :: 17 | 89 Paradise Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 6000827.4 | 2096045.9 | 37.7353893278652 | -122.439581147409 | (37.7353893278652, -122.439581147409) | 2 | 7 | 5 | 63 | 7 | ||||||
| 194193 | 108718 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1103 GOUGH ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005549.7 | 2113553.5 | 37.7837287235103 | -122.424499312595 | (37.7837287235103, -122.424499312595) | 7 | 9 | 11 | 28858 | 41 | ||||
| 194143 | 118792 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 746 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 5982002.3368 | 2110652.98782 | 37.7744068613492 | -122.505747814892 | (37.7744068613492, -122.505747814892) | 11 | 6 | 2 | 55 | 26 | ||||
| 194127 | 122584 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2500X Lyon St | 4 | Median : Cutout | Tree | Private 2 | 11 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
| 194056 | 256816 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1101 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006375 | 2114401 | 37.786102322085 | -122.421704297146 | (37.786102322085, -122.421704297146) | 13 | 9 | 11 | 28858 | 41 | ||||
| 194044 | 115634 | Undocumented 4 | Tree(s) :: 17 | 844 43RD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982626 | 2109989 | 37.7726204302856 | -122.503541302768 | (37.7726204302856, -122.503541302768) | 11 | 6 | 2 | 55 | 26 | ||||
| 194010 | 120978 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 699X Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007023 | 2113270 | 37.7830333917519 | -122.419382121036 | (37.7830333917519, -122.419382121036) | 7 | 9 | 9 | 28852 | 36 | ||||
| 193979 | 95851 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 498X Minna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6010279.2 | 2112410.7 | 37.7808568143498 | -122.408056331236 | (37.7808568143498, -122.408056331236) | 14 | 2 | 9 | 28853 | 34 | |||
| 193965 | 108150 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2232 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
| 193955 | 93226 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 746 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4.5 | 5998618.6 | 2107971.8 | 37.7680089598714 | -122.44807617536 | (37.7680089598714, -122.44807617536) | 15 | 5 | 11 | 29492 | 9 | ||||
| 193904 | 99774 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 4330 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x6 | 6001764 | 2100607 | 37.7479663028981 | -122.436669359529 | (37.7479663028981, -122.436669359529) | 2 | 4 | 5 | 28862 | 22 | ||||
| 193894 | 107703 | Undocumented 4 | Tree(s) :: 17 | 41 Hill St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773950 | 6006079.45841 | 2103417.96835 | 37.7559288760699 | -122.421946314733 | (37.7559288760699, -122.421946314733) | 2 | 4 | 5 | 28859 | 19 | ||
| 193863 | 111072 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1450 IRVING ST | 1 | Sidewalk: Property side : Cutout | Tree | Fire Dept 16 | 3x3 | 5991277 | 2106586 | 37.7637815143869 | -122.473368628437 | (37.7637815143869, -122.473368628437) | 11 | 8 | 11 | 56 | 12 | ||||
| 193846 | 110147 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 90 WOODLAND AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 46 | 4x15 | 5997155.9 | 2105983.7 | 37.7624664223167 | -122.452991942132 | (37.7624664223167, -122.452991942132) | 15 | 5 | 11 | 29492 | 12 | |||
| 193834 | 111412 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 150x SAN MARCOS AVE | 7 | Median : Yard | Tree | Private 2 | 36 | 5993566 | 2100407 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | 1 | 8 | 4 | 29491 | 40 | ||||
| 193832 | 100062 | Undocumented 4 | Tree(s) :: 17 | 430X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2012 12:00:00 AM | 3x3 | Permit Number 768595 | 6011459 | 2112320 | 37.7806737592872 | -122.403968419194 | (37.7806737592872, -122.403968419194) | 14 | 2 | 9 | 28853 | 34 | ||
| 193817 | 111176 | Undocumented 4 | Tree(s) :: 17 | 650 28TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775967 | 6001692 | 2099453 | 37.7447935997954 | -122.436835733404 | (37.7447935997954, -122.436835733404) | 2 | 7 | 5 | 63 | 22 | |
| 193813 | 121556 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 421 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 779269 | 6003622 | 2102696 | 37.7538076209017 | -122.430393500907 | (37.7538076209017, -122.430393500907) | 2 | 4 | 5 | 28862 | 22 | ||
| 193783 | 101555 | Undocumented 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 435X 11th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6009095.5 | 2108566.4 | 37.770234925082 | -122.411879608901 | (37.770234925082, -122.411879608901) | 8 | 2 | 9 | 28853 | 34 | |||
| 193712 | 104914 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 614 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 193679 | 101838 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3815-3817 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003483 | 2105926 | 37.762668556024 | -122.431104719068 | (37.762668556024, -122.431104719068) | 15 | 4 | 5 | 28862 | 3 | |||||
| 193673 | 120592 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3773 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003806 | 2105923 | 37.7626786166025 | -122.429987363922 | (37.7626786166025, -122.429987363922) | 8 | 4 | 5 | 28862 | 3 | ||||
| 193654 | 102153 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Clipper St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003792.2 | 2100904.7 | 37.7488987706557 | -122.429677160081 | (37.7488987706557, -122.429677160081) | 2 | 4 | 5 | 28862 | 22 | |||
| 193622 | 110514 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
| 193588 | 101174 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 445 Irving St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994418 | 2106645 | 37.7641248955045 | -122.462509231781 | (37.7641248955045, -122.462509231781) | 1 | 5 | 11 | 56 | 12 | ||||
| 193559 | 102483 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1501X Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999365.6 | 2109075.3 | 37.7710815652008 | -122.445571755181 | (37.7710815652008, -122.445571755181) | 15 | 5 | 11 | 29492 | 9 | ||||
| 193545 | 109651 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 22 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 193536 | 99816 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 660-662 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | Most likely permitted for planting at same time as tree no. 1 | 6002127 | 2102089 | 37.7520561456392 | -122.435520126196 | (37.7520561456392, -122.435520126196) | 2 | 4 | 5 | 28862 | 22 | |||
| 193524 | 255735 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301x Congdon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 6004745 | 2093607 | 37.7289148453459 | -122.425862986743 | (37.7289148453459, -122.425862986743) | 9 | 7 | 6 | 28861 | 5 | ||||
| 193436 | 105653 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 150 BRONTE ST | 3 | Unaccepted Street : Yard | Tree | Private 2 | 16 | Permit Number 770978 | 6009287.5 | 2096640.3 | 37.737499298819 | -122.410373266073 | (37.737499298819, -122.410373266073) | 10 | 7 | 7 | 28859 | 2 | |||
| 193402 | 115811 | Undocumented 4 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 399X CONNECTICUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6013409 | 2105275 | 37.7614385218822 | -122.396728355206 | (37.7614385218822, -122.396728355206) | 10 | 3 | 8 | 28856 | 29 | |||
| 193394 | 99455 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 400X Miramar Ave | 5 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.458120762721 | (37.7250639553871, -122.458120762721) | 9 | 7 | 4 | 28861 | 40 | |||
| 193377 | 121126 | Undocumented 4 | :: 45 | 201 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216 | 2096386 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | 2 | 7 | 5 | 63 | 7 | ||
| 193352 | 112858 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2098x ULLOA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989583 | 2098399 | 37.7412039444452 | -122.47862882847 | (37.7412039444452, -122.47862882847) | 1 | 8 | 3 | 29491 | 35 | ||||
| 193346 | 178671 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 624 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6002757.8843 | 2087321.68 | 37.7115442544376 | -122.432283877092 | (37.7115442544376, -122.432283877092) | 9 | 7 | 6 | 28861 | 5 | |||
| 193304 | 107084 | Undocumented 4 | Tree(s) :: 17 | 54 FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 9x3 | Permit Number 773533 | 6005346 | 2103401 | 37.7558408924527 | -122.424481650335 | (37.7558408924527, -122.424481650335) | 2 | 4 | 5 | 28859 | 19 | ||
| 193294 | 98540 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 4736 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 5998512 | 2105692 | 37.7617431097225 | -122.448280704282 | (37.7617431097225, -122.448280704282) | 15 | 5 | 11 | 29492 | 9 | ||||
| 193272 | 113486 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 30 PRESIDIO AVE | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998975 | 2116473 | 37.7913714231174 | -122.447455414162 | (37.7913714231174, -122.447455414162) | 13 | 6 | 1 | 29490 | 31 | ||||
| 193270 | 116150 | Undocumented 4 | Tree(s) :: 17 | 3701 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | 8 | 4 | 5 | 28862 | 3 | |||||
| 193185 | 119913 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 225 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013509 | 2106013 | 37.7634704729857 | -122.396434224989 | (37.7634704729857, -122.396434224989) | 14 | 3 | 8 | 28856 | 29 | ||||
| 193176 | 212200 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 820 Bosworth St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6001696.91365 | 2095566.3144 | 37.7341219466514 | -122.436540603989 | (37.7341219466514, -122.436540603989) | 2 | 7 | 5 | 63 | 7 | ||||
| 193169 | 108114 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 786 Clayton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x7 | 5998636 | 2107697 | 37.7672554233108 | -122.447996203185 | (37.7672554233108, -122.447996203185) | 15 | 5 | 11 | 29492 | 9 | ||||
| 193097 | 101175 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994553 | 2106706 | 37.7643001590155 | -122.462046733301 | (37.7643001590155, -122.462046733301) | 11 | 5 | 11 | 56 | 12 | ||||
| 192954 | 110534 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 100X ASHBURY ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | City College | 3x3 | 5998750 | 2110223 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | 15 | 5 | 11 | 29492 | 16 | |||
| 192916 | 96224 | Undocumented 4 | Tree(s) :: 17 | 185 Chilton Ave | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6001587.1 | 2095138.7 | 37.732941575251 | -122.436889661497 | (37.732941575251, -122.436889661497) | 9 | 7 | 5 | 63 | 40 | ||||
| 192911 | 122759 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86X Park Hill Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001171 | 2107689 | 37.7673780360046 | -122.439227450619 | (37.7673780360046, -122.439227450619) | 15 | 5 | 5 | 29492 | 3 | ||||
| 192897 | 108243 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 201 SUSSEX ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6001706.4 | 2096365.4 | 37.7363165900689 | -122.436564983425 | (37.7363165900689, -122.436564983425) | 2 | 7 | 5 | 63 | 7 | ||||
| 192864 | 114481 | Undocumented 4 | Washingtonia filifera :: California Fan Palm 176 | 45 HOFF ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6006591 | 2106401 | 37.7641484227608 | -122.420388955837 | (37.7641484227608, -122.420388955837) | 8 | 4 | 7 | 28859 | 19 | ||||
| 192863 | 106188 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1353 ULLOA ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 4x15 | 5991777 | 2098367.4 | 37.7412443198206 | -122.471040528993 | (37.7412443198206, -122.471040528993) | 1 | 8 | 4 | 59 | 40 | |||
| 192855 | 110382 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2275 PALOU AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27x18 | 6011433 | 2097903 | 37.7410864434132 | -122.40304401029 | (37.7410864434132, -122.40304401029) | 10 | 3 | 8 | 58 | 1 | ||||
| 192843 | 106150 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1855 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005088.8 | 2107180.4 | 37.7662037032764 | -122.425640111201 | (37.7662037032764, -122.425640111201) | 8 | 4 | 5 | 28853 | 19 | |||
| 192835 | 115870 | Undocumented 4 | :: 45 | 84X Cordova St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | on Athens St. Frontage | 6001679.7 | 2087642.4 | 37.7123636875758 | -122.436033295685 | (37.7123636875758, -122.436033295685) | 9 | 7 | 6 | 28861 | 5 | ||||
| 192724 | 116815 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 2 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
| 192696 | 238273 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4134 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002159.93034 | 2104730.60743 | 37.7593112359535 | -122.435595213262 | (37.7593112359535, -122.435595213262) | 2 | 4 | 5 | 28862 | 3 | |||
| 192681 | 102558 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
| 192675 | 111390 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | ||||
| 192660 | 112981 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3880 NORIEGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982016 | 2102928 | 37.7531970663373 | -122.505127932021 | (37.7531970663373, -122.505127932021) | 1 | 8 | 3 | 56 | 35 | ||||
| 192657 | 73935 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 98x LANDERS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1984 12:00:00 AM | 13 | 3x3 | 6004473 | 2107480 | 37.7669915173508 | -122.427791394155 | (37.7669915173508, -122.427791394155) | 8 | 4 | 5 | 28862 | 3 | |
| 192614 | 122806 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 3201X Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998880 | 2116541 | 37.791552703824 | -122.447789008322 | (37.791552703824, -122.447789008322) | 13 | 6 | 1 | 54 | 31 | ||||
| 192547 | 108274 | Undocumented 4 | Malus :: Crab Apple 82 | 1800x ALAMEDA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011533 | 2107928 | 37.7686184708296 | -122.403403344125 | (37.7686184708296, -122.403403344125) | 8 | 2 | 8 | 28853 | 20 | ||||
| 192531 | 101702 | Undocumented 4 | Tree(s) :: 17 | 2700 18th St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/13/2012 12:00:00 AM | 2x3 | Permit Number 769052 | 6009810.4 | 2105505.4 | 37.7618702017999 | -122.409190731152 | (37.7618702017999, -122.409190731152) | 8 | 4 | 8 | 28859 | 19 | ||
| 192530 | 114586 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 155x BRONTE ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 15 | 3x3 | Permit Number 777226 | 6009330 | 2096609 | 37.7374157381662 | -122.410224113722 | (37.7374157381662, -122.410224113722) | 10 | 7 | 7 | 28859 | 2 | ||
| 192520 | 122601 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 510 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011010 | 2115960 | 37.7906432427033 | -122.405778205997 | (37.7906432427033, -122.405778205997) | 5 | 1 | 10 | 28857 | 6 | ||||
| 192441 | 98513 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 De Montfort Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | Permit Number 775766 | 5995016.6 | 2091971.4 | 37.7238693046984 | -122.459376132933 | (37.7238693046984, -122.459376132933) | 9 | 8 | 4 | 28861 | 24 | ||
| 192424 | 106899 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 63 BROSNAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x3 | 6005693 | 2108028.3 | 37.7685659568303 | -122.423610587475 | (37.7685659568303, -122.423610587475) | 8 | 4 | 5 | 28853 | 19 | |||
| 192395 | 102739 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1249 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016779.4097 | 2092749.4074 | 37.7272328159816 | -122.384199065737 | (37.7272328159816, -122.384199065737) | 10 | 3 | 8 | 58 | 1 | |||
| 192371 | 254531 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 315 Crestmont Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x2.5 | 5995000 | 2104188 | 37.7574121051756 | -122.460318243952 | (37.7574121051756, -122.460318243952) | 1 | 5 | 4 | 63 | 12 | ||||
| 192347 | 102405 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
| 192341 | 231196 | Undocumented 4 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 3498 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006617.04806 | 2100606.14609 | 37.7482385598621 | -122.419887630105 | (37.7482385598621, -122.419887630105) | 2 | 4 | 7 | 28859 | 19 | |||
| 192268 | 121197 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2112 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5990734 | 2100991 | 37.7483876657955 | -122.474838269225 | (37.7483876657955, -122.474838269225) | 1 | 8 | 4 | 29491 | 40 | |||
| 192264 | 112167 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 838X MISSION ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011020 | 2113508 | 37.7839111917985 | -122.405570835545 | (37.7839111917985, -122.405570835545) | 12 | 2 | 9 | 28853 | 34 | ||||
| 192258 | 104036 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 149 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 770678 | 6005538 | 2099025 | 37.7438362440335 | -122.423506557165 | (37.7438362440335, -122.423506557165) | 2 | 7 | 5 | 28859 | 22 | ||
| 192196 | 103016 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1950X Turk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x4 | 6000619.3 | 2112146.9 | 37.7795868963645 | -122.441455622144 | (37.7795868963645, -122.441455622144) | 15 | 5 | 1 | 29490 | 16 | |||
| 192142 | 108288 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | ||||
| 192133 | 112301 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25x WALLER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005453 | 2109246 | 37.7718959184753 | -122.424527356528 | (37.7718959184753, -122.424527356528) | 7 | 9 | 5 | 28852 | 10 | ||||
| 192093 | 116988 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 300x BRODERICK ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6001353 | 2109892 | 37.7734372805127 | -122.438755818588 | (37.7734372805127, -122.438755818588) | 15 | 5 | 11 | 29492 | 10 | ||||
| 192036 | 115760 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 918 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 6003072 | 2102882 | 37.7542871624955 | -122.432308808853 | (37.7542871624955, -122.432308808853) | 2 | 4 | 5 | 28862 | 22 | |||
| 192018 | 110881 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 800 INDIANA ST | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
| 192010 | 106337 | Undocumented 4 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 | 497 VALLEY ST | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 04/17/2014 12:00:00 AM | 2 | Permit Number 770848 | 6002779 | 2099138 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | 2 | 7 | 5 | 63 | 22 | ||
| 191995 | 116176 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
| 191989 | 116816 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 111 BAY ST | 3 | Front Yard : Yard | Tree | PUC 8 | 6010193 | 2121519 | 37.8058611737053 | -122.408997391272 | (37.8058611737053, -122.408997391272) | 3 | 1 | 10 | 308 | 23 | |||||
| 191986 | 115085 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2786 JACKSON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6000894 | 2116629 | 37.7919092338162 | -122.440826927692 | (37.7919092338162, -122.440826927692) | 13 | 6 | 1 | 29490 | 27 | |||
| 191946 | 107167 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 27 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993261.4 | 2098012.7 | 37.7403561458765 | -122.465882276537 | (37.7403561458765, -122.465882276537) | 1 | 8 | 4 | 59 | 40 | |||||
| 191937 | 110254 | Undocumented 4 | Tree(s) :: 17 | 464 WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003481.8 | 2109039.2 | 37.7712165795204 | -122.431331110461 | (37.7712165795204, -122.431331110461) | 15 | 9 | 11 | 29492 | 10 | ||||
| 191908 | 121565 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 740 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6004294 | 2104553 | 37.7589445476691 | -122.428201904748 | (37.7589445476691, -122.428201904748) | 2 | 4 | 5 | 28862 | 3 |
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) );