trees
163,064 rows where qCaretaker_id = 2 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
67021 | 100113 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
51202 | 100114 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
135501 | 100115 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
149669 | 100116 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
93715 | 100117 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
181201 | 100118 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
68742 | 100119 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
162104 | 100120 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
3096 | 100121 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 690 Miramar Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5995444.4 | 2093941.6 | 37.7293035878447 | -122.458039824042 | (37.7293035878447, -122.458039824042) | 9 | 7 | 4 | 28861 | 40 | |||||
127087 | 100123 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 690 Miramar Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995444.4 | 2093941.6 | 37.7293035878447 | -122.458039824042 | (37.7293035878447, -122.458039824042) | 9 | 7 | 4 | 28861 | 40 | |||||
21762 | 100124 | Significant Tree 6 | Radermachera sinica :: China Doll Tree 394 | 40@ San Ramon Eastwood Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5995635 | 2092781 | 37.7261278087338 | -122.457296979484 | (37.7261278087338, -122.457296979484) | 9 | 7 | 4 | 28861 | 40 | |||||
154195 | 100125 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6005967.88782 | 2116944.18436 | 37.7930623076392 | -122.423293649581 | (37.7930623076392, -122.423293649581) | 13 | 9 | 1 | 28858 | 27 | ||||
127780 | 100126 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6005948.98718 | 2116940.10629 | 37.7930500435754 | -122.423358756926 | (37.7930500435754, -122.423358756926) | 13 | 9 | 1 | 28858 | 27 | ||||
56463 | 100127 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6005919.01328 | 2116937.33835 | 37.7930407517779 | -122.423462271584 | (37.7930407517779, -122.423462271584) | 13 | 9 | 1 | 28858 | 27 | ||||
82331 | 100128 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6005897.30712 | 2116933.8296 | 37.7930298924771 | -122.423537126645 | (37.7930298924771, -122.423537126645) | 13 | 9 | 1 | 28858 | 27 | ||||
156977 | 100129 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011082.10119 | 2112775.22352 | 37.7819026320456 | -122.405304366814 | (37.7819026320456, -122.405304366814) | 12 | 2 | 9 | 28853 | 34 | |
181095 | 100130 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011065.09249 | 2112790.58254 | 37.7819438533601 | -122.405364291326 | (37.7819438533601, -122.405364291326) | 12 | 2 | 9 | 28853 | 34 | |
143498 | 100131 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011051.59118 | 2112804.91213 | 37.7819824441767 | -122.405412009362 | (37.7819824441767, -122.405412009362) | 12 | 2 | 9 | 28853 | 34 | |
70912 | 100132 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011001.43438 | 2112862.15185 | 37.7821368065155 | -122.405589562524 | (37.7821368065155, -122.405589562524) | 12 | 2 | 9 | 28853 | 34 | |
109349 | 100133 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6010986.38868 | 2112879.38733 | 37.7821832897709 | -122.405642828459 | (37.7821832897709, -122.405642828459) | 12 | 2 | 9 | 28853 | 34 | |
181514 | 100134 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6010970.10593 | 2112898.88439 | 37.782235913593 | -122.405700533469 | (37.782235913593, -122.405700533469) | 12 | 2 | 9 | 28853 | 34 | |
107208 | 100135 | Undocumented 4 | Tree(s) :: 17 | 155 05th St | 1 | Front Yard : Yard | Tree | Private 2 | 11/27/2012 12:00:00 AM | 9 | Permit Number 769351 | 6011029.6 | 2112857.4 | 37.7821253339557 | -122.405491786923 | (37.7821253339557, -122.405491786923) | 12 | 2 | 9 | 28853 | 34 | ||
143275 | 100136 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6010957.25903 | 2112913.83939 | 37.7822762580963 | -122.405746031954 | (37.7822762580963, -122.405746031954) | 12 | 2 | 9 | 28853 | 34 | |
97699 | 100137 | Undocumented 4 | Tree(s) :: 17 | 155 05th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.7821253339557 | -122.405491786923 | (37.7821253339557, -122.405491786923) | 12 | 2 | 9 | 28853 | 34 | |||
39248 | 100138 | Undocumented 4 | Tree(s) :: 17 | 155 05th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.7821253339557 | -122.405491786923 | (37.7821253339557, -122.405491786923) | 12 | 2 | 9 | 28853 | 34 | |||
95526 | 100139 | Property Tree 8 | Tree(s) :: 17 | 155 05th St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.7821253339557 | -122.405491786923 | (37.7821253339557, -122.405491786923) | 12 | 2 | 9 | 28853 | 34 | ||||
155249 | 100145 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 222X Cumberland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004147.2 | 2104574.7 | 37.7589958235368 | -122.428711154895 | (37.7589958235368, -122.428711154895) | 2 | 4 | 5 | 28862 | 3 | |||||
76067 | 100146 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 222X Cumberland St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004147.2 | 2104574.7 | 37.7589958235368 | -122.428711154895 | (37.7589958235368, -122.428711154895) | 2 | 4 | 5 | 28862 | 3 | |||||
96465 | 100147 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3955 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003272 | 2105332 | 37.7610256161684 | -122.431792078279 | (37.7610256161684, -122.431792078279) | 2 | 4 | 5 | 28862 | 3 | |||
26011 | 100148 | Property Tree 8 | Tree(s) :: 17 | 209 Vicksburg St | Back Yard : Yard | Tree | Private 2 | 6004141 | 2102142 | 37.7523158521071 | -122.428559192815 | (37.7523158521071, -122.428559192815) | 2 | 4 | 5 | 28862 | 22 | ||||||
136685 | 100149 | Undocumented 4 | Tree(s) :: 17 | 3975 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6003144 | 2105325 | 37.7609991391758 | -122.432234274425 | (37.7609991391758, -122.432234274425) | 2 | 4 | 5 | 28862 | 3 | |||
4072 | 100150 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 4007 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6002942 | 2105314 | 37.7609574805046 | -122.432932117926 | (37.7609574805046, -122.432932117926) | 2 | 4 | 5 | 28862 | 3 | |||
153574 | 100151 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 4047 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 5x5 | Permit Number 776452 | 6002690 | 2105300 | 37.7609047432887 | -122.433802674054 | (37.7609047432887, -122.433802674054) | 2 | 4 | 5 | 28862 | 3 | ||
61720 | 100152 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002933.4 | 2105264.1 | 37.7608199793321 | -122.432958296422 | (37.7608199793321, -122.432958296422) | 2 | 4 | 5 | 28862 | 3 | |||
48746 | 100153 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 590 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 780398 | 5993481.43699 | 2111479.23814 | 37.7773444498569 | -122.466099823613 | (37.7773444498569, -122.466099823613) | 11 | 6 | 2 | 54 | 11 | |||
41837 | 100154 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 421 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768665 | 5995548.20979 | 2113421.38615 | 37.7827960924124 | -122.459090895565 | (37.7827960924124, -122.459090895565) | 11 | 6 | 2 | 54 | 11 | |
138493 | 100155 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 421 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768665 | 5995547.63901 | 2113410.08576 | 37.7827650317513 | -122.459092051698 | (37.7827650317513, -122.459092051698) | 11 | 6 | 2 | 54 | 11 | |
185437 | 100156 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 421 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768665 | 5995549.3318 | 2113386.41255 | 37.7827001287608 | -122.459084480701 | (37.7827001287608, -122.459084480701) | 11 | 6 | 2 | 54 | 11 | |
138742 | 100157 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 14 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001430.1 | 2108737.2 | 37.7702708737839 | -122.438406367889 | (37.7702708737839, -122.438406367889) | 15 | 5 | 11 | 29492 | 9 | |||||
34119 | 100158 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 14 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | Permit Number 769008 | 6001430.1 | 2108737.2 | 37.7702708737839 | -122.438406367889 | (37.7702708737839, -122.438406367889) | 15 | 5 | 11 | 29492 | 9 | |||
94130 | 100160 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1699 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Permit Number 28164 | 6005505.58523 | 2118187.22554 | 37.7964492830571 | -122.424981725648 | (37.7964492830571, -122.424981725648) | 13 | 9 | 1 | 28858 | 27 | |||
38359 | 100161 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1699 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 28164 | 6005519.03005 | 2118189.86695 | 37.7964572951359 | -122.424935391656 | (37.7964572951359, -122.424935391656) | 13 | 9 | 1 | 28858 | 27 | |||
115639 | 100162 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1699 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 28164 | 6005532.34096 | 2118193.08724 | 37.7964668890905 | -122.424889562218 | (37.7964668890905, -122.424889562218) | 13 | 9 | 1 | 28858 | 27 | |||
87452 | 100163 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1814 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6004278.90656 | 2118759.95598 | 37.7979524872736 | -122.429267157958 | (37.7979524872736, -122.429267157958) | 13 | 9 | 1 | 57 | 17 | ||||
68208 | 100164 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 839 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008231.9319 | 2115379.46118 | 37.7888934760005 | -122.41534908182 | (37.7888934760005, -122.41534908182) | 13 | 1 | 10 | 28858 | 21 | |||
99569 | 100165 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 839 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008234.89338 | 2115366.55149 | 37.7888581955857 | -122.415337921201 | (37.7888581955857, -122.415337921201) | 13 | 1 | 10 | 28858 | 21 | |||
1694 | 100166 | Property Tree 8 | Salix spp :: Willow 203 | 2340 Twin Peaks Blvd | Front Yard : Yard | Tree | Private 2 | Permit Number 769026 | |||||||||||||||
159845 | 100167 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 710 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986405.6 | 2114870 | 37.7862437457696 | -122.490826667671 | (37.7862437457696, -122.490826667671) | 11 | 6 | 1 | 55 | 33 | |||||
171432 | 100168 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 710 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986405.6 | 2114870 | 37.7862437457696 | -122.490826667671 | (37.7862437457696, -122.490826667671) | 11 | 6 | 1 | 55 | 33 | |||||
171295 | 100170 | DPW Maintained 1 | Tree(s) :: 17 | 2149 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769012 | 5997531 | 2110183 | 37.7740181145799 | -122.451997596236 | (37.7740181145799, -122.451997596236) | 15 | 5 | 11 | 29492 | 16 | |
139403 | 100171 | Significant Tree 6 | Quercus suber :: Cork Oak 78 | 109 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996563.8 | 2106359.1 | 37.763463224844 | -122.455066914463 | (37.763463224844, -122.455066914463) | 15 | 5 | 11 | 29492 | 12 | |||||
133313 | 100174 | Undocumented 4 | Tree(s) :: 17 | 50 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2012 12:00:00 AM | 18 | 3x3 | Permit Number 769094 | 6010932.2 | 2114627.3 | 37.7869796149513 | -122.405953468587 | (37.7869796149513, -122.405953468587) | 5 | 10 | 10 | 28857 | 6 | |
148324 | 100175 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1140 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2012 12:00:00 AM | 3x3 | Permit Number 768230 | 6001099 | 2109378.2 | 37.772012061027 | -122.439597598173 | (37.772012061027, -122.439597598173) | 15 | 5 | 11 | 29492 | 9 | ||
17896 | 100177 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 252 States St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 768965 | 6000636 | 2106677.4 | 37.7645699751489 | -122.44100535545 | (37.7645699751489, -122.44100535545) | 15 | 5 | 5 | 28862 | 3 | ||||
101769 | 100178 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1270 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2012 12:00:00 AM | 3x3 | 6003851 | 2100874 | 37.7488178049495 | -122.42947164058 | (37.7488178049495, -122.42947164058) | 2 | 4 | 5 | 28862 | 22 | |||
84934 | 100179 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1270 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2012 12:00:00 AM | 3x3 | 6003851 | 2100874 | 37.7488178049495 | -122.42947164058 | (37.7488178049495, -122.42947164058) | 2 | 4 | 5 | 28862 | 22 | |||
159785 | 10018 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 205 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1993 12:00:00 AM | 6 | 3x3 | 6005510.9123943 | 2107567.8958458 | 37.7672915172207 | -122.424207665862 | (37.7672915172207, -122.424207665862) | 8 | 4 | 5 | 28853 | 19 | ||
77968 | 100180 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 100x BELVEDERE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997991 | 2108152 | 37.7684678470263 | -122.450259955793 | (37.7684678470263, -122.450259955793) | 15 | 5 | 11 | 29492 | 9 | ||||
100479 | 100181 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 230 Ritch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6013794.16577 | 2112184.81721 | 37.7804327665865 | -122.39588042504 | (37.7804327665865, -122.39588042504) | 6 | 2 | 9 | 28856 | 34 | ||||
2882 | 100182 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 230 Ritch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6013808.29227 | 2112170.33848 | 37.7803937971776 | -122.39583053966 | (37.7803937971776, -122.39583053966) | 6 | 2 | 9 | 28856 | 34 | ||||
38085 | 100183 | Permitted Site 7 | Tree(s) :: 17 | 956 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003075.2 | 2102641.9 | 37.7536280862965 | -122.432280596021 | (37.7536280862965, -122.432280596021) | 2 | 4 | 5 | 28862 | 22 | ||||
126592 | 100184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 480 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6006818.05082 | 2091764.69226 | 37.7239732025834 | -122.418565697766 | (37.7239732025834, -122.418565697766) | 9 | 7 | 7 | 309 | 28 | |||
111037 | 100187 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 217 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 3x3 | Permit Number 768935 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | ||
168610 | 100188 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 217 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 3x3 | Permit Number 768935 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | ||
84320 | 100189 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 160 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 772698 | 5995944.7835 | 2113256.71049 | 37.7823667267913 | -122.457707006716 | (37.7823667267913, -122.457707006716) | 11 | 6 | 1 | 54 | 31 | ||
28194 | 10019 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 205 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6005510.9123943 | 2107567.8958458 | 37.7672915172207 | -122.424207665862 | (37.7672915172207, -122.424207665862) | 8 | 4 | 5 | 28853 | 19 | |||
34066 | 100190 | Undocumented 4 | Tree(s) :: 17 | 404 Noriega St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/07/2016 12:00:00 AM | Permit Number 776979 | 5992802 | 2103239 | 37.754679716601 | -122.467850713731 | (37.754679716601, -122.467850713731) | 1 | 8 | 4 | 56 | 12 | |||
58651 | 100191 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1201 Holloway Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5992431.5 | 2091178.1 | 37.7215421255294 | -122.468254640211 | (37.7215421255294, -122.468254640211) | 9 | 8 | 6 | 64 | 24 | |||||
75465 | 100192 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 62 Nordhoff St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x6 | 6000448 | 2095531 | 37.7339539318334 | -122.440855946438 | (37.7339539318334, -122.440855946438) | 9 | 7 | 5 | 63 | 40 | ||||
28871 | 100193 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 361 Dellbrook Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | 1 | 5 | 4 | 63 | 38 | |||||
17949 | 100194 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 361 Dellbrook Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | 1 | 5 | 4 | 63 | 38 | |||||
80551 | 100195 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 361 Dellbrook Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | 1 | 5 | 4 | 63 | 38 | |||||
102142 | 100197 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 81 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 21 | Permit Number 769099 | 5994240.47669 | 2115083.18474 | 37.7872836759267 | -122.463735720083 | (37.7872836759267, -122.463735720083) | 11 | 6 | 1 | 54 | 11 | ||
12340 | 100198 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 81 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 22 | Permit Number 769099 | 5994239.22854 | 2115068.80691 | 37.7872441264014 | -122.463738994433 | (37.7872441264014, -122.463738994433) | 11 | 6 | 1 | 54 | 11 | ||
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 | |||||
107304 | 10020 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 250 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 2x2 | 6005442.42406 | 2107520.98643 | 37.767158847823 | -122.424441220501 | (37.767158847823, -122.424441220501) | 8 | 4 | 5 | 28853 | 19 | |||
61342 | 100200 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 743 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5998111 | 2095844 | 37.7346799803076 | -122.448958173673 | (37.7346799803076, -122.448958173673) | 9 | 7 | 4 | 59 | 40 | |||||
43509 | 100201 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 255 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 51875 | 6008346.92713 | 2112747.04212 | 37.7816719523255 | -122.414764839028 | (37.7816719523255, -122.414764839028) | 7 | 10 | 9 | 28852 | 36 | ||
106283 | 100202 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2389 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2012 12:00:00 AM | Permit Number 768863 | 6003320.6 | 2116507.6 | 37.79171379901 | -122.432422214141 | (37.79171379901, -122.432422214141) | 13 | 9 | 1 | 29490 | 27 | |||
59943 | 100203 | DPW Maintained 1 | Shrub :: Shrub 66 | 2237 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6001906 | 2114287 | 37.7855362863546 | -122.437157652203 | (37.7855362863546, -122.437157652203) | 13 | 6 | 11 | 29490 | 13 | |||
47901 | 100204 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2237 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 5x5 | 6001902.2596 | 2114280.466 | 37.7855181330415 | -122.437170124873 | (37.7855181330415, -122.437170124873) | 13 | 6 | 11 | 29490 | 13 | |||
64512 | 100205 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 4085 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2012 12:00:00 AM | 12 | 3x4 | Permit Number 769140 | 6003091 | 2104064 | 37.7575337303282 | -122.432327515179 | (37.7575337303282, -122.432327515179) | 2 | 4 | 5 | 28862 | 3 | |
24948 | 100206 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 155X Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006736.3 | 2098711.7 | 37.7430435558186 | -122.4193408869 | (37.7430435558186, -122.4193408869) | 2 | 7 | 7 | 28859 | 2 | ||||
64294 | 100207 | Permitted Site 7 | Tree(s) :: 17 | 149X Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006751.8 | 2098740.3 | 37.7431229579688 | -122.419289320387 | (37.7431229579688, -122.419289320387) | 2 | 7 | 7 | 28859 | 2 | ||||
193537 | 100208 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 634 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x10 | 5992873.67037 | 2111136.23263 | 37.7763675669424 | -122.468177309737 | (37.7763675669424, -122.468177309737) | 11 | 6 | 2 | 54 | 11 | |||
95493 | 100209 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 701 Rhode Island St | 1 | Front Yard : Yard | Tree | Private 2 | 10 | Permit Number 769013 | 6011855.86556 | 2105057.10212 | 37.7607536567646 | -122.402084714731 | (37.7607536567646, -122.402084714731) | 10 | 3 | 8 | 28856 | 29 | |||
65243 | 100210 | Permitted Site 7 | Tree(s) :: 17 | 701 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2012 12:00:00 AM | Permit Number 769013 | 6011921.4 | 2105078.9 | 37.7608171664666 | -122.401859591355 | (37.7608171664666, -122.401859591355) | 10 | 3 | 8 | 28856 | 29 | |||
64775 | 100211 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 701 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2012 12:00:00 AM | 1 | Permit Number 769013 | 6011855.60136 | 2105068.89592 | 37.7607860251716 | -122.402086457638 | (37.7607860251716, -122.402086457638) | 10 | 3 | 8 | 28856 | 29 | ||
34760 | 100212 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 701 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Permit Number 769013 | 6011854.68115 | 2105077.88991 | 37.7608106693075 | -122.402090272569 | (37.7608106693075, -122.402090272569) | 10 | 3 | 8 | 28856 | 29 | |||
134278 | 100213 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 120 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768999 | 5994920.57635 | 2114719.03859 | 37.786322995296 | -122.461356328132 | (37.786322995296, -122.461356328132) | 11 | 6 | 1 | 54 | 11 | |
78025 | 100214 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 730 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001088.1 | 2111178.5 | 37.7769546116117 | -122.439764396806 | (37.7769546116117, -122.439764396806) | 15 | 5 | 11 | 29492 | 41 | |||
48985 | 100215 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 7x6 | 6008249 | 2099678 | 37.7457818821655 | -122.414178714053 | (37.7457818821655, -122.414178714053) | 2 | 7 | 7 | 28859 | 2 | |||
136027 | 100216 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 527-529 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003013 | 2105186 | 37.7606100501577 | -122.432677416542 | (37.7606100501577, -122.432677416542) | 2 | 4 | 5 | 28862 | 3 | |||
163276 | 100217 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 527-529 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003013 | 2105186 | 37.7606100501577 | -122.432677416542 | (37.7606100501577, -122.432677416542) | 2 | 4 | 5 | 28862 | 3 | |||
160532 | 100223 | Permitted Site 7 | Tree(s) :: 17 | 3841 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2012 12:00:00 AM | 3x3 | Permit Number 769110 | 6004154.3 | 2102433.2 | 37.75311617172 | -122.428533954088 | (37.75311617172, -122.428533954088) | 2 | 4 | 5 | 28862 | 22 | |
135684 | 100224 | Permitted Site 7 | Tree(s) :: 17 | 101X Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2012 12:00:00 AM | 3x3 | Permit Number 769110 | 6004128.9 | 2102465.7 | 37.7532039716563 | -122.428624108827 | (37.7532039716563, -122.428624108827) | 2 | 4 | 5 | 28862 | 22 | |
67433 | 100225 | Permitted Site 7 | Tree(s) :: 17 | 101X Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2012 12:00:00 AM | 3x3 | Permit Number 769110 | 6004128.9 | 2102465.7 | 37.7532039716563 | -122.428624108827 | (37.7532039716563, -122.428624108827) | 2 | 4 | 5 | 28862 | 22 | |
84120 | 100226 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1192 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000853 | 2109323 | 37.7718464914602 | -122.440444569342 | (37.7718464914602, -122.440444569342) | 15 | 5 | 11 | 29492 | 9 | ||||
104956 | 100227 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 542 Valley St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Permit Number 769993 | 6002426 | 2099190 | 37.7441131524814 | -122.434278904907 | (37.7441131524814, -122.434278904907) | 2 | 7 | 5 | 63 | 22 | |||
56634 | 100228 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 701X 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778265 | 5983810.9 | 2111033.8 | 37.7755587404093 | -122.499519901729 | (37.7755587404093, -122.499519901729) | 11 | 6 | 2 | 55 | 26 |
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) );