trees
8,298 rows where qLegalStatus_id = 4 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19879 | 121647 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 90 Fernwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5994730 | 2095273 | 37.7329182144954 | -122.46060599284 | (37.7329182144954, -122.46060599284) | 9 | 8 | 4 | 59 | 40 | ||||
20014 | 178243 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 62 Tomaso Ct | 3 | Front Yard : Yard | Tree | Private 2 | 26 | Width 8ft | 6009152.06447 | 2086268.0035 | 37.7090115585089 | -122.410109471469 | (37.7090115585089, -122.410109471469) | 9 | 7 | 8 | 309 | 39 | |||
20187 | 110389 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 601X JOOST AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998083 | 2094940 | 37.7321962100447 | -122.448989879749 | (37.7321962100447, -122.448989879749) | 9 | 7 | 4 | 59 | 40 | ||||
20269 | 121646 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 90 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5994730 | 2095273 | 37.7329182144954 | -122.46060599284 | (37.7329182144954, -122.46060599284) | 9 | 8 | 4 | 59 | 40 | ||||
21767 | 109635 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2X GENEVA AVE | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 5997165.4 | 2091482.5 | 37.7226502134341 | -122.451912865332 | (37.7226502134341, -122.451912865332) | 9 | 8 | 6 | 28861 | 24 | ||||
21975 | 107666 | Undocumented 4 | Quillaja saponaria :: Chilean Soapbark 349 | 140 STRATFORD DR | 1 | Front Yard : Yard | Tree | Private 2 | 12/17/2014 12:00:00 AM | 3 | Permit Number 774157 | 5990881.4 | 2091504.3 | 37.7223481397163 | -122.473636645054 | (37.7223481397163, -122.473636645054) | 9 | 8 | 4 | 64 | 40 | ||
22356 | 93153 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 222 Sadowa St | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 3x24 | 5994796 | 2087777 | 37.7123397937745 | -122.459835021723 | (37.7123397937745, -122.459835021723) | 9 | 8 | 6 | 28861 | 24 | |||
22418 | 100843 | Undocumented 4 | Cedrus deodara :: Deodar Cedar 109 | 1 Estero Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
22502 | 121649 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 90 Fernwood Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5994730 | 2095273 | 37.7329182144954 | -122.46060599284 | (37.7329182144954, -122.46060599284) | 9 | 8 | 4 | 59 | 40 | ||||
22503 | 254552 | Undocumented 4 | Prunus serrulata 'Akebono' :: 'Akebono' Cherry 351 | 898X Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000986 | 2091876 | 37.723948767299 | -122.438734102779 | (37.723948767299, -122.438734102779) | 9 | 7 | 6 | 28861 | 25 | ||||
22778 | 120919 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 198X Miraloma Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x10 | 5994595 | 2096392 | 37.7359829456919 | -122.461153801837 | (37.7359829456919, -122.461153801837) | 9 | 8 | 4 | 59 | 40 | |||
22815 | 108344 | Undocumented 4 | Tree(s) :: 17 | 268 FARALLONES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774684 | 5994321.4 | 2088439.9 | 37.7141326548779 | -122.461523399561 | (37.7141326548779, -122.461523399561) | 9 | 8 | 6 | 28861 | 24 | |
22968 | 115663 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 601x PERU AVE | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 6005068 | 2092670 | 37.7263602983163 | -122.424679722884 | (37.7263602983163, -122.424679722884) | 9 | 7 | 6 | 28861 | 5 | ||||
23257 | 177158 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 221 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6007422.75752 | 2087173.92491 | 37.7114019502079 | -122.416150341778 | (37.7114019502079, -122.416150341778) | 9 | 7 | 8 | 309 | 39 | |||
23455 | 97490 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 500X Miramar Ave | 7 | Median : Cutout | Tree | Private 2 | 12 | 15x280 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.458022688068 | (37.7258701708071, -122.458022688068) | 9 | 7 | 4 | 28861 | 40 | |||
23474 | 107219 | Undocumented 4 | Tree(s) :: 17 | 100 WINSTON DR | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2015 12:00:00 AM | 36 | Permit Number 776841 | 5990934.3 | 2093194.2 | 37.7269912477326 | -122.473576991848 | (37.7269912477326, -122.473576991848) | 9 | 8 | 4 | 64 | 40 | ||
23862 | 102476 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 760 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
24902 | 180669 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 171 Winding Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 6ft | 6002170.18422 | 2086635.71157 | 37.7096273944518 | -122.434266111507 | (37.7096273944518, -122.434266111507) | 9 | 7 | 6 | 28861 | 5 | |||
25361 | 113722 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 57 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 779057 | 5994581 | 2092950 | 37.7265312490745 | -122.460952813642 | (37.7265312490745, -122.460952813642) | 9 | 8 | 4 | 28861 | 40 | ||
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 | ||||
26451 | 104562 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 210 FLOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999356 | 2094123 | 37.7300256415139 | -122.444530151255 | (37.7300256415139, -122.444530151255) | 9 | 7 | 4 | 28861 | 40 | |||
27247 | 93191 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 220 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x10 | 5994811.8 | 2087851.3 | 37.7125447127349 | -122.459785791066 | (37.7125447127349, -122.459785791066) | 9 | 8 | 6 | 28861 | 24 | |||
27608 | 251772 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 90x Seville St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002045 | 2087474 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | 9 | 7 | 6 | 28861 | 5 | ||||
27633 | 113114 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1x TOMASO CT | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
27830 | 111201 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800x CAYUGA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6001173 | 2092267 | 37.7250330011493 | -122.438115670551 | (37.7250330011493, -122.438115670551) | 9 | 7 | 6 | 28861 | 25 | |||
28026 | 99572 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
28142 | 121663 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
28184 | 109638 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1X Geneva Ave | 2 | Median : Cutout | Tree | DPW 1 | 3x3 | 6001799 | 2091822 | 37.723846713797 | -122.435919833731 | (37.723846713797, -122.435919833731) | 9 | 7 | 6 | 28861 | 25 | ||||
28217 | 258038 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 55 Mercedes Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5991909 | 2093425 | 37.7276813664439 | -122.470224302167 | (37.7276813664439, -122.470224302167) | 9 | 8 | 4 | 59 | 40 | ||||
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 | ||||
28573 | 101604 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 180X Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 2x2 | 5998894.7 | 2093810.1 | 37.7291401587489 | -122.446102418286 | (37.7291401587489, -122.446102418286) | 9 | 7 | 4 | 28861 | 40 | |||
28927 | 105423 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 GARFIELD ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/28/2014 12:00:00 AM | 28 | 3x20 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.462873531809 | (37.7201106425596, -122.462873531809) | 9 | 8 | 6 | 64 | 24 | ||
29145 | 121591 | Undocumented 4 | :: 45 | 162 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6000339 | 2095263 | 37.7332118579221 | -122.441213569672 | (37.7332118579221, -122.441213569672) | 9 | 7 | 5 | 63 | 40 | ||||
29283 | 122748 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 125 Santa Paula Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 5994040 | 2096990 | 37.7375929505752 | -122.463116020518 | (37.7375929505752, -122.463116020518) | 9 | 8 | 4 | 59 | 40 | |||
29286 | 104780 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 177 GLADSTONE DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005563.4 | 2093681.6 | 37.7291658964922 | -122.423039015945 | (37.7291658964922, -122.423039015945) | 9 | 7 | 6 | 28861 | 5 | |||
29910 | 172261 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 230 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6001860 | 2086600 | 37.7095117275676 | -122.435335608043 | (37.7095117275676, -122.435335608043) | 9 | 7 | 6 | 28861 | 5 | |||
29963 | 106965 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 63 BELLE AVE | Sidewalk: Property side : Yard | Tree | Private 2 | 5991753.8 | 2086471.1 | 37.7085786821221 | -122.47025464516 | (37.7085786821221, -122.47025464516) | 9 | 8 | 4 | 64 | 24 | ||||||
30073 | 113257 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 45 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994580 | 2092875 | 37.7263252596904 | -122.46095083712 | (37.7263252596904, -122.46095083712) | 9 | 8 | 4 | 28861 | 40 | ||||
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 | ||||
30723 | 120885 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6009830 | 2087548 | 37.7125641444482 | -122.407856615551 | (37.7125641444482, -122.407856615551) | 9 | 7 | 8 | 309 | 39 | ||||
31197 | 99493 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Miramar Ave | 3 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | 9 | 7 | 4 | 28861 | 40 | |||
32562 | 110175 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 901 MONTEREY BLVD | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | 9 | 7 | 4 | 28861 | 40 | ||||
32678 | 99483 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Miramar Ave | 2 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | 9 | 7 | 4 | 28861 | 40 | |||
32895 | 109672 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 798x GRAFTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994496 | 2090624 | 37.7201397218642 | -122.461078132621 | (37.7201397218642, -122.461078132621) | 9 | 8 | 6 | 28861 | 24 | ||||
33077 | 178244 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 62 Tomaso Ct | 4 | Front Yard : Yard | Tree | Private 2 | 17 | Width 8ft | 6009170.0421 | 2086265.24197 | 37.7090049835504 | -122.410047143074 | (37.7090049835504, -122.410047143074) | 9 | 7 | 8 | 309 | 39 | |||
33132 | 97488 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500X Miramar Ave | 4 | Median : Cutout | Tree | Private 2 | 10 | 15x280 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.458022688068 | (37.7258701708071, -122.458022688068) | 9 | 7 | 4 | 28861 | 40 | |||
33262 | 116307 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | |||
33375 | 255389 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 86 Niagara Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2018 05:25:00 AM | 3 | 5.5x6 | 5999683 | 2089300 | 37.7168014457499 | -122.443053440221 | (37.7168014457499, -122.443053440221) | 9 | 7 | 6 | 28861 | 25 | ||
33394 | 79686 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 50 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2002 12:00:00 AM | 17 | 3x3 | 6010880.07744846 | 2087416.54149132 | 37.7122619180075 | -122.404217955056 | (37.7122619180075, -122.404217955056) | 9 | 7 | 8 | 309 | 39 | ||
33401 | 255388 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 78 Niagara Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2018 05:25:00 AM | 3 | 5x6 | 5999719 | 2089263 | 37.7167019046917 | -122.442926350787 | (37.7167019046917, -122.442926350787) | 9 | 7 | 6 | 28861 | 25 | ||
33425 | 99460 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 550X Miramar Ave | 7 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995413 | 2092983.7 | 37.7266716211667 | -122.458079078858 | (37.7266716211667, -122.458079078858) | 9 | 7 | 4 | 28861 | 40 | |||
33802 | 115791 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 101 SAN ALESO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5993432 | 2094808 | 37.7315666775405 | -122.465059716371 | (37.7315666775405, -122.465059716371) | 9 | 8 | 4 | 59 | 40 | ||||
34986 | 113307 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 COLONIAL WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | 6000472 | 2093592 | 37.7286312543271 | -122.440633939625 | (37.7286312543271, -122.440633939625) | 9 | 7 | 6 | 28861 | 25 | ||||
35037 | 108336 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 1099 CAPITOL AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995030 | 2091211 | 37.7217821988442 | -122.459274772662 | (37.7217821988442, -122.459274772662) | 9 | 8 | 6 | 28861 | 24 | ||||
35059 | 116297 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 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 | ||||
35887 | 100199 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 739 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5998111 | 2095813 | 37.7345948616995 | -122.448955941335 | (37.7345948616995, -122.448955941335) | 9 | 7 | 4 | 59 | 40 | |||||
35891 | 180620 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6002386.35916 | 2087019.94096 | 37.7106946720927 | -122.433546414645 | (37.7106946720927, -122.433546414645) | 9 | 7 | 6 | 28861 | 5 | |||
36053 | 105376 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 150 WESTGATE DR | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5993482 | 2093943.9 | 37.7291969547583 | -122.464824129449 | (37.7291969547583, -122.464824129449) | 9 | 8 | 4 | 59 | 40 | |||
36162 | 110396 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1x ARLETA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x30 | 6011055 | 2087587 | 37.7127397354919 | -122.403625353192 | (37.7127397354919, -122.403625353192) | 9 | 7 | 8 | 309 | 39 | ||||
36173 | 99571 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
36279 | 99451 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 400X Miramar Ave | 1 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.458120762721 | (37.7250639553871, -122.458120762721) | 9 | 7 | 4 | 28861 | 40 | |||
36617 | 99580 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 650X Brunswick St | 20 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
37063 | 212059 | Undocumented 4 | Tree(s) :: 17 | 125 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/08/2019 12:00:00 AM | 3 | Width 6ft | Permit Number 779144 | 5994018.1401 | 2096987.89262 | 37.7375859049576 | -122.463191447135 | (37.7375859049576, -122.463191447135) | 9 | 8 | 4 | 59 | 40 | |
37608 | 97493 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X Miramar Ave | 9 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.458022688068 | (37.7258701708071, -122.458022688068) | 9 | 7 | 4 | 28861 | 40 | |||
37664 | 96807 | Undocumented 4 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 1520X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x100 | 5993467 | 2095277.3 | 37.7328572774743 | -122.464972786509 | (37.7328572774743, -122.464972786509) | 9 | 8 | 4 | 59 | 40 | |||
38067 | 121684 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 208 Joost Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6000684 | 2094988 | 37.7324764179648 | -122.440001102333 | (37.7324764179648, -122.440001102333) | 9 | 7 | 5 | 63 | 40 | ||||
38295 | 113711 | Undocumented 4 | Tree(s) :: 17 | 160 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2016 12:00:00 AM | 3x3 | Permit Number 777009 | 5993496 | 2093977 | 37.7292886463954 | -122.464778133382 | (37.7292886463954, -122.464778133382) | 9 | 8 | 4 | 59 | 40 | ||
38387 | 113577 | Undocumented 4 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 444 | 301X PLYMOUTH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995855 | 2088109 | 37.7133122340733 | -122.456198810604 | (37.7133122340733, -122.456198810604) | 9 | 8 | 6 | 28861 | 24 | ||||
38701 | 258325 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997933 | 2087452 | 37.7116273264288 | -122.448969257639 | (37.7116273264288, -122.448969257639) | 9 | 7 | 6 | 28861 | 25 | ||||
38860 | 119269 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 141 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5994478 | 2093007 | 37.726681829874 | -122.461313008217 | (37.726681829874, -122.461313008217) | 9 | 8 | 4 | 28861 | 40 | |||
38975 | 116839 | Undocumented 4 | Tree(s) :: 17 | 690 ROCKDALE DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5997625 | 2098222 | 37.7411815887471 | -122.45080983743 | (37.7411815887471, -122.45080983743) | 9 | 7 | 4 | 59 | 40 | ||||
39029 | 103456 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 410 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6003658 | 2091068 | 37.721881827041 | -122.429439831937 | (37.721881827041, -122.429439831937) | 9 | 7 | 6 | 28861 | 5 | ||||
39088 | 255806 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 255X Evelyn Way | 1 | Median : Yard | Tree | PUC 8 | 10x10 | 5998108 | 2098711 | 37.742551901709 | -122.449175024155 | (37.742551901709, -122.449175024155) | 9 | 7 | 4 | 59 | 40 | ||||
39421 | 121669 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 92X Fairfield Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993836 | 2093526 | 37.7280699074048 | -122.463570014172 | (37.7280699074048, -122.463570014172) | 9 | 8 | 4 | 59 | 40 | ||||
39549 | 101657 | Undocumented 4 | Ilex aquifolium :: European Holly 390 | 320 Santa Ana Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992576.9 | 2094712.8 | 37.7312559376124 | -122.46800901581 | (37.7312559376124, -122.46800901581) | 9 | 8 | 4 | 59 | 40 | |||||
39839 | 93152 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 222 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x13 | 5994796 | 2087777 | 37.7123397937745 | -122.459835021723 | (37.7123397937745, -122.459835021723) | 9 | 8 | 6 | 28861 | 24 | |||
40245 | 180646 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 451 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 6ft | 6002230.18825 | 2087673.61332 | 37.7124806510226 | -122.434132874236 | (37.7124806510226, -122.434132874236) | 9 | 7 | 6 | 28861 | 5 | |||
40477 | 105375 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 133 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 5993389.1 | 2093898.7 | 37.7290674900164 | -122.465142008345 | (37.7290674900164, -122.465142008345) | 9 | 8 | 4 | 59 | 40 | |||
40991 | 180403 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 428 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002092.32458 | 2093893.81656 | 37.7295521118195 | -122.435053967971 | (37.7295521118195, -122.435053967971) | 9 | 7 | 6 | 28861 | 25 | |||
41206 | 210528 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 466 Bright St | 1 | : | Tree | Private 2 | 17 | Width 3ft | 5993789.40568 | 2090279.07412 | 37.7191519514685 | -122.463495553783 | (37.7191519514685, -122.463495553783) | 9 | 8 | 6 | 64 | 24 | |||
41393 | 99479 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 650X Miramar Ave | 7 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.458085302932 | (37.728535605791, -122.458085302932) | 9 | 7 | 4 | 28861 | 40 | |||
41551 | 113993 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 813 BOSWORTH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6001774 | 2095490 | 37.7339167850924 | -122.436268633067 | (37.7339167850924, -122.436268633067) | 9 | 7 | 5 | 63 | 40 | |||
41703 | 99570 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
41809 | 106281 | Undocumented 4 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 | 399X Elliot St | 2 | Unaccepted Street : Yard | Tree | Rec/Park 5 | Permit Number 772905 | 6008798.75873 | 2088103.62049 | 37.7140319762934 | -122.411460149363 | (37.7140319762934, -122.411460149363) | 9 | 7 | 8 | 309 | 39 | ||||
42089 | 177159 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 221 Hahn St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6007445.49487 | 2087228.32343 | 37.711552595661 | -122.416075605431 | (37.711552595661, -122.416075605431) | 9 | 7 | 8 | 309 | 39 | |||
42128 | 102522 | Undocumented 4 | Cedrus deodara :: Deodar Cedar 109 | 1X 31st St | 2 | Unaccepted Street : Yard | Tree | Private 2 | 5999966.2 | 2097547.4 | 37.7394630398899 | -122.442666404233 | (37.7394630398899, -122.442666404233) | 9 | 7 | 4 | 59 | 40 | |||||
42255 | 113119 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
42371 | 115664 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 601x PERU AVE | 2 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 6005068 | 2092670 | 37.7263602983163 | -122.424679722884 | (37.7263602983163, -122.424679722884) | 9 | 7 | 6 | 28861 | 5 | ||||
43129 | 100849 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 1 Estero Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
43136 | 181033 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 39 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 4ft | 6000587.53239 | 2088326.47 | 37.7141798831749 | -122.439857163381 | (37.7141798831749, -122.439857163381) | 9 | 7 | 6 | 28861 | 5 | |||
43378 | 115006 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 225 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996088.1 | 2091171.8 | 37.7217353414931 | -122.455614385962 | (37.7217353414931, -122.455614385962) | 9 | 8 | 6 | 28861 | 24 | ||||
43481 | 107218 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 WINSTON DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 42 | 5990934.3 | 2093194.2 | 37.7269912477326 | -122.473576991848 | (37.7269912477326, -122.473576991848) | 9 | 8 | 4 | 64 | 40 | ||||
43574 | 110263 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 101x HEARST AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6000711 | 2094308 | 37.7306108324003 | -122.439859019702 | (37.7306108324003, -122.439859019702) | 9 | 7 | 4 | 63 | 40 | |||
43642 | 255804 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 151 Urbano Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 5993243 | 2092509 | 37.7252432887469 | -122.465546165723 | (37.7252432887469, -122.465546165723) | 9 | 8 | 4 | 59 | 40 | ||||
43978 | 117197 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 70 CERRITOS AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10x6 | 5992485 | 2092977 | 37.7264845532002 | -122.4682005031 | (37.7264845532002, -122.4682005031) | 9 | 8 | 4 | 59 | 40 | ||||
44211 | 105373 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 130 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 5993430.1 | 2093832.6 | 37.7288883598425 | -122.464995470532 | (37.7288883598425, -122.464995470532) | 9 | 8 | 4 | 59 | 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) );