trees
8,298 rows where qLegalStatus_id = 4 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11756 | 108765 | Undocumented 4 | :: 45 | 500X Lathrop Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | ||||
142114 | 108771 | Undocumented 4 | :: 45 | 500X Lathrop Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | ||||
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 | ||||
106748 | 114218 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 119 TALBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010311 | 2086793 | 37.7105179840213 | -122.406140963349 | (37.7105179840213, -122.406140963349) | 9 | 7 | 8 | 309 | 39 | ||||
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 | ||||
110125 | 108826 | Undocumented 4 | :: 45 | 146-150X Gillette Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6013072.89275 | 2086799.91674 | 37.7106910734067 | -122.39659568235 | (37.7106910734067, -122.39659568235) | 10 | 3 | 8 | 309 | 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 | |||
166107 | 258529 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 121 Peabody St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010049 | 2086885 | 37.7107559391642 | -122.407052976777 | (37.7107559391642, -122.407052976777) | 9 | 7 | 8 | 309 | 39 | ||||
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 | |||
63362 | 114791 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 100x GILLETTE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013060 | 2086881 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | 10 | 3 | 8 | 309 | 1 | ||||
71923 | 114790 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 100x GILLETTE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013060 | 2086881 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | 10 | 3 | 8 | 309 | 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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||||
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 | |||
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 | |||
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 | ||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | ||||
161955 | 94038 | Undocumented 4 | Cornus florida :: Eastern Dogwood 385 | 227 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5995000.1 | 2087926.4 | 37.7127617466649 | -122.459140406861 | (37.7127617466649, -122.459140406861) | 9 | 8 | 6 | 28861 | 24 | |||
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 | ||
16017 | 254863 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x5 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
17023 | 254832 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 3 | 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 | ||
17824 | 254830 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x5 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
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 | |||
116417 | 104205 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 710X Brotherhood Way | 2 | Front Yard : Yard | Tree | DPW 1 | Permit Number 770788 | 5991124.9259 | 2088065.41222 | 37.7129198985758 | -122.472544248538 | (37.7129198985758, -122.472544248538) | 1 | 8 | 4 | 64 | 14 | ||||
143404 | 104204 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 710X Brotherhood Way | 1 | Front Yard : Yard | Tree | DPW 1 | Permit Number 770788 | 5991124.9259 | 2088065.41222 | 37.7129198985758 | -122.472544248538 | (37.7129198985758, -122.472544248538) | 1 | 8 | 4 | 64 | 14 | ||||
13163 | 255351 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
36199 | 255343 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
39787 | 255358 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 39 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
56921 | 255350 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
59019 | 255359 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 40 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 |
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) );