trees
8,298 rows where qLegalStatus_id = 4 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 111010 | 99581 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
| 139161 | 99569 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 11 | 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 | |||
| 146726 | 99563 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 650X Brunswick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
| 181618 | 99566 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 8 | 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 | |||
| 182004 | 99583 | Undocumented 4 | Shrub :: Shrub 66 | 650X Brunswick St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
| 185260 | 99578 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
| 188587 | 99565 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 650X Brunswick St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
| 72124 | 251752 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 128 South Hill Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | 9 | 7 | 6 | 28861 | 5 | ||||
| 91191 | 180655 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 128 South Hill Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | 9 | 7 | 6 | 28861 | 5 | |||
| 185565 | 251753 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 128 South Hill Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | 9 | 7 | 6 | 28861 | 5 | ||||
| 506 | 264804 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 600X Visitacion Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010564 | 2086911 | 37.7108561363482 | -122.405274840324 | (37.7108561363482, -122.405274840324) | 9 | 7 | 8 | 309 | 39 | |||
| 2023 | 264805 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 600X Visitacion Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010564 | 2086911 | 37.7108561363482 | -122.405274840324 | (37.7108561363482, -122.405274840324) | 9 | 7 | 8 | 309 | 39 | |||
| 8669 | 262474 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 600X Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6010564 | 2086911 | 37.7108561363482 | -122.405274840324 | (37.7108561363482, -122.405274840324) | 9 | 7 | 8 | 309 | 39 | |||
| 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 | |||
| 35458 | 115141 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
| 70426 | 115147 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
| 93001 | 115142 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
| 116719 | 115146 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
| 131287 | 115143 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
| 167987 | 115144 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
| 174412 | 115140 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
| 182929 | 115145 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
| 67925 | 175029 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010591.02139 | 2086933.10615 | 37.7109183460773 | -122.405183003288 | (37.7109183460773, -122.405183003288) | 9 | 7 | 8 | 309 | 39 | |||
| 22201 | 121023 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Executive Park Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014230 | 2086988 | 37.7112718434151 | -122.392609576957 | (37.7112718434151, -122.392609576957) | 10 | 3 | 8 | 58 | 1 | |||||
| 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 | |||||
| 167528 | 121024 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Executive Park Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2016 12:00:00 AM | 3 | 6014230 | 2086988 | 37.7112718434151 | -122.392609576957 | (37.7112718434151, -122.392609576957) | 10 | 3 | 8 | 58 | 1 | |||
| 2450 | 251744 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 70 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002620 | 2086992 | 37.710631205907 | -122.432736905509 | (37.710631205907, -122.432736905509) | 9 | 7 | 6 | 28861 | 5 | ||||
| 87109 | 103410 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
| 101910 | 103408 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
| 188484 | 103409 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | |||
| 78151 | 106555 | Undocumented 4 | Tree(s) :: 17 | 495X Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012736.59297 | 2087029.1616 | 37.711301812416 | -122.397774087156 | (37.711301812416, -122.397774087156) | 10 | 3 | 8 | 309 | 1 | |||
| 118826 | 106554 | Undocumented 4 | Tree(s) :: 17 | 495X Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012736.59297 | 2087029.1616 | 37.711301812416 | -122.397774087156 | (37.711301812416, -122.397774087156) | 10 | 3 | 8 | 309 | 1 | |||
| 128314 | 106557 | Undocumented 4 | Tree(s) :: 17 | 495X Blanken Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012736.59297 | 2087029.1616 | 37.711301812416 | -122.397774087156 | (37.711301812416, -122.397774087156) | 10 | 3 | 8 | 309 | 1 | |||
| 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 | |||
| 168353 | 180626 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 18 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6002802.39914 | 2087193.02957 | 37.7111935323316 | -122.432120840807 | (37.7111935323316, -122.432120840807) | 9 | 7 | 6 | 28861 | 5 | |||
| 76386 | 180625 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 18 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6002816.84046 | 2087215.85653 | 37.7112570289525 | -122.432072557104 | (37.7112570289525, -122.432072557104) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 119214 | 96535 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 6 | 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 | |||
| 133315 | 96531 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 2 | 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 | |||
| 141047 | 96534 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 5 | 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 | |||
| 153939 | 96536 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Raymond Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5x5 | 6011122.2 | 2087240.2 | 37.7117912459807 | -122.403368705104 | (37.7117912459807, -122.403368705104) | 9 | 7 | 8 | 309 | 39 | |||
| 53756 | 251780 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1219 Naples St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001110 | 2087312 | 37.7114241006266 | -122.437978695611 | (37.7114241006266, -122.437978695611) | 9 | 7 | 6 | 28861 | 5 | ||||
| 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 | |||
| 88905 | 258327 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 109 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998030 | 2087350 | 37.7113528047065 | -122.448626659544 | (37.7113528047065, -122.448626659544) | 9 | 7 | 6 | 28861 | 25 | ||||
| 76134 | 109289 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 26X Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011707.98734 | 2087352.96474 | 37.7121335759116 | -122.401351970141 | (37.7121335759116, -122.401351970141) | 10 | 3 | 8 | 309 | 1 | |||||
| 117132 | 93576 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2998 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | 9 | 8 | 6 | 28861 | 24 | |||
| 157490 | 93573 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2998 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | 9 | 8 | 6 | 28861 | 24 | |||
| 73067 | 180648 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 120 Seville St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 6ft | 6001751.26715 | 2087361.8508 | 37.7115974268507 | -122.435765878508 | (37.7115974268507, -122.435765878508) | 9 | 7 | 6 | 28861 | 5 | |||
| 96184 | 107386 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 26x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 6011510 | 2087367 | 37.712161065506 | -122.402037262127 | (37.712161065506, -122.402037262127) | 10 | 3 | 8 | 309 | 1 | |||
| 91148 | 258326 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 111 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997997 | 2087369 | 37.7114030873569 | -122.448742083083 | (37.7114030873569, -122.448742083083) | 9 | 7 | 6 | 28861 | 25 | ||||
| 84124 | 101825 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 50 Raymond Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6010875 | 2087406.8 | 37.7122348861177 | -122.404234819129 | (37.7122348861177, -122.404234819129) | 9 | 7 | 8 | 309 | 39 | |||
| 121123 | 101824 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 50 Raymond Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6010875 | 2087406.8 | 37.7122348861177 | -122.404234819129 | (37.7122348861177, -122.404234819129) | 9 | 7 | 8 | 309 | 39 | |||
| 145372 | 101826 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 50 Raymond Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6010875 | 2087406.8 | 37.7122348861177 | -122.404234819129 | (37.7122348861177, -122.404234819129) | 9 | 7 | 8 | 309 | 39 | |||
| 59876 | 116749 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
| 62277 | 116746 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
| 120938 | 110397 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 2200 BAY SHORE BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x30 | 6011234 | 2087411 | 37.7122664722191 | -122.40299429709 | (37.7122664722191, -122.40299429709) | 9 | 7 | 8 | 309 | 39 | ||||
| 131415 | 116747 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
| 156017 | 116748 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
| 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 | ||
| 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 | ||||
| 56264 | 112690 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 731 HURON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x4 | 5997668 | 2087467 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | 9 | 7 | 6 | 28861 | 25 | ||||
| 97274 | 112689 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 731 HURON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x4 | 5997668 | 2087467 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | 9 | 7 | 6 | 28861 | 25 | ||||
| 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 | ||||
| 45628 | 251771 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 90x Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002045 | 2087474 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | 9 | 7 | 6 | 28861 | 5 | ||||
| 4356 | 262525 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
| 9260 | 262526 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
| 17025 | 262527 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
| 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 | ||||
| 131878 | 112062 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1199 VISITACION AVE | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/18/2015 12:00:00 AM | 4x4 | 6009231 | 2087548 | 37.7125305915537 | -122.409926954579 | (37.7125305915537, -122.409926954579) | 9 | 7 | 8 | 309 | 39 | ||
| 154395 | 112063 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1199 VISITACION AVE | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4x4 | 6009231 | 2087548 | 37.7125305915537 | -122.409926954579 | (37.7125305915537, -122.409926954579) | 9 | 7 | 8 | 309 | 39 | |||
| 159171 | 112058 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1199 VISITACION AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4x4 | 6009231 | 2087548 | 37.7125305915537 | -122.409926954579 | (37.7125305915537, -122.409926954579) | 9 | 7 | 8 | 309 | 39 | |||
| 178370 | 112061 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1199 VISITACION AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4x4 | 6009231 | 2087548 | 37.7125305915537 | -122.409926954579 | (37.7125305915537, -122.409926954579) | 9 | 7 | 8 | 309 | 39 | |||
| 180505 | 112060 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1199 VISITACION AVE | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4x4 | 6009231 | 2087548 | 37.7125305915537 | -122.409926954579 | (37.7125305915537, -122.409926954579) | 9 | 7 | 8 | 309 | 39 | |||
| 156719 | 108322 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 22 ARLETA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774396 | 6011232.7 | 2087548.1 | 37.7126428486885 | -122.403008427372 | (37.7126428486885, -122.403008427372) | 9 | 7 | 8 | 309 | 39 | |
| 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 | ||||
| 171327 | 111287 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 450 ROLPH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002226 | 2087613 | 37.7123139824471 | -122.434143019741 | (37.7123139824471, -122.434143019741) | 9 | 7 | 6 | 28861 | 5 | |||
| 46286 | 111319 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 200x PENINSULA AVE | 2 | Unaccepted Street : Yard | Tree | Private 2 | 6012569 | 2087626 | 37.7129312780718 | -122.398395185538 | (37.7129312780718, -122.398395185538) | 10 | 3 | 8 | 309 | 1 | |||||
| 73281 | 111318 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 200x PENINSULA AVE | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6012569 | 2087626 | 37.7129312780718 | -122.398395185538 | (37.7129312780718, -122.398395185538) | 10 | 3 | 8 | 309 | 1 | |||||
| 164541 | 111320 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 200x PENINSULA AVE | 3 | Unaccepted Street : Yard | Tree | Private 2 | 6012569 | 2087626 | 37.7129312780718 | -122.398395185538 | (37.7129312780718, -122.398395185538) | 10 | 3 | 8 | 309 | 1 | |||||
| 46272 | 112621 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 226x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012667 | 2087636 | 37.7129641948773 | -122.398057164184 | (37.7129641948773, -122.398057164184) | 10 | 3 | 8 | 309 | 1 | ||||
| 134710 | 112622 | Undocumented 4 | Corymbia citriodora :: Lemon Scented Gum 384 | 226x HESTER AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012667 | 2087636 | 37.7129641948773 | -122.398057164184 | (37.7129641948773, -122.398057164184) | 10 | 3 | 8 | 309 | 1 | ||||
| 171514 | 115762 | Undocumented 4 | :: 45 | 84X Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | on Athens Street frontage | 6001679.7 | 2087642.4 | 37.7123636875758 | -122.436033295685 | (37.7123636875758, -122.436033295685) | 9 | 7 | 6 | 28861 | 5 | |||
| 189112 | 115869 | Undocumented 4 | :: 45 | 84X Cordova St | 2 | 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 | ||||
| 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 | ||||
| 86958 | 112623 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 228 HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | 6012539 | 2087662 | 37.7130284556779 | -122.398501400627 | (37.7130284556779, -122.398501400627) | 10 | 3 | 8 | 309 | 1 | ||||
| 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 | |||
| 77754 | 251748 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002576.6751 | 2087720.05109 | 37.7126278178947 | -122.43293862582 | (37.7126278178947, -122.43293862582) | 9 | 7 | 6 | 28861 | 5 | ||||
| 82563 | 104649 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 200 Wheeler Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6012242.2 | 2087732.7 | 37.7132060446128 | -122.399532207425 | (37.7132060446128, -122.399532207425) | 10 | 3 | 8 | 309 | 1 | |||||
| 117848 | 111916 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 125 TUNNEL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012052 | 2087737 | 37.7132072479286 | -122.400189909434 | (37.7132072479286, -122.400189909434) | 10 | 3 | 8 | 309 | 1 | ||||
| 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 | |||
| 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 | |||
| 155752 | 115341 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 1514 SUNNYDALE AVE | 2 | Sidewalk: Property side : Yard | Tree | Housing Authority 15 | Private | 3x3 | 6006572 | 2087815 | 37.7131143345755 | -122.419136228821 | (37.7131143345755, -122.419136228821) | 9 | 7 | 8 | 309 | 39 | |||
| 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 | |||
| 123948 | 75029 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 141X Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | FUF | 02/24/2016 12:00:00 AM | 3 | This record is for lthe ot between 141-143 Arleta Ave. | 6010470.01061258 | 2087860.00753073 | 37.7134566637798 | -122.405666490875 | (37.7134566637798, -122.405666490875) | 9 | 7 | 8 | 309 | 39 | |
| 132603 | 74892 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 141X Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | FUF | 02/24/2016 12:00:00 AM | 3 | This is for the trees adjacent to the lot between 141-143 Arleta | 6010470.01061258 | 2087860.00753073 | 37.7134566637798 | -122.405666490875 | (37.7134566637798, -122.405666490875) | 9 | 7 | 8 | 309 | 39 | |
| 122000 | 104507 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99x DICHIERA CT | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 5998517 | 2087907 | 37.7129100350962 | -122.446983527065 | (37.7129100350962, -122.446983527065) | 9 | 7 | 6 | 28861 | 25 | |||
| 2168 | 254831 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 |
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) );