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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
767 | 100549 | Undocumented 4 | Acer spp :: Maple 88 | 290X Tehama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | |||||||||||||
3669 | 103667 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
4476 | 112909 | Undocumented 4 | Tree(s) :: 17 | 1899X Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
4983 | 112267 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
5100 | 101532 | Undocumented 4 | Tree(s) :: 17 | 11323 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
5748 | 115724 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 250x Octavia St | 1 | Side Yard : Yard | Tree | Dept of Real Estate 7 | |||||||||||||||
6238 | 103666 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
7827 | 115725 | Undocumented 4 | Syzygium paniculatum :: Brush Cherry 243 | 250X Octavia St | 2 | Side Yard : Yard | Tree | Dept of Real Estate 7 | |||||||||||||||
9335 | 112908 | Undocumented 4 | Tree(s) :: 17 | 1899X Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
9557 | 112910 | Undocumented 4 | Tree(s) :: 17 | 1899X Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10205 | 173902 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10489 | 102839 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1101X Portola Dr | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10516 | 102842 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10813 | 100543 | Undocumented 4 | Acer spp :: Maple 88 | 290X Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | |||||||||||||
10916 | 108180 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 835 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
10998 | 100001 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 501X 01st St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | Address is 100 1st Street | ||||||||||||||
11335 | 112269 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
12733 | 102843 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
14524 | 99746 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
15154 | 102838 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
15233 | 109923 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 214 state st | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
15258 | 103665 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
16355 | 103663 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
18064 | 103664 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
18422 | 112268 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
18674 | 103662 | Undocumented 4 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
126084 | 112633 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 800x BRUNSWICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 5x6 | 5997602 | 2086276 | 37.70837936312 | -122.450028571713 | (37.70837936312, -122.450028571713) | 9 | 7 | 6 | 28861 | 5 | |||
134879 | 112634 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800x BRUNSWICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x6 | 5997602 | 2086276 | 37.70837936312 | -122.450028571713 | (37.70837936312, -122.450028571713) | 9 | 7 | 6 | 28861 | 5 | ||||
29963 | 106965 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 63 BELLE AVE | Sidewalk: Property side : Yard | Tree | Private 2 | 5991753.8 | 2086471.1 | 37.7085786821221 | -122.47025464516 | (37.7085786821221, -122.47025464516) | 9 | 8 | 4 | 64 | 24 | ||||||
1769 | 251583 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 75 Rice St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1995 12:00:00 AM | 3x3 | 5995352 | 2086409 | 37.7086155444167 | -122.457814401925 | (37.7086155444167, -122.457814401925) | 9 | 7 | 6 | 28861 | 25 | |||
59333 | 73959 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 75 Rice St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1995 12:00:00 AM | 4 | 2x4 | Permit Number 773591 | 5995358.56494273 | 2086411.36688337 | 37.7086224204841 | -122.457791883945 | (37.7086224204841, -122.457791883945) | 9 | 7 | 6 | 28861 | 25 | |
190879 | 71596 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 75 Rice St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1995 12:00:00 AM | 12 | 2x3 | 5995358.56494273 | 2086411.36688337 | 37.7086224204841 | -122.457791883945 | (37.7086224204841, -122.457791883945) | 9 | 7 | 6 | 28861 | 25 | ||
124564 | 257893 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 23 Canyon Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003365 | 2086282 | 37.7087239233851 | -122.430111404197 | (37.7087239233851, -122.430111404197) | 9 | 7 | 6 | 28861 | 5 | ||||
153868 | 102841 | Undocumented 4 | Tree(s) :: 17 | 5 Canyon Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2013 12:00:00 AM | Permit Number 770737 | 6003515 | 2086316 | 37.7088257745465 | -122.429595407579 | (37.7088257745465, -122.429595407579) | 9 | 7 | 6 | 28861 | 5 | |||
14604 | 108382 | Undocumented 4 | Tree(s) :: 17 | 30 CASTILLO ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6x12 | 6006869.1 | 2086298.1 | 37.7089659714277 | -122.418001881162 | (37.7089659714277, -122.418001881162) | 9 | 7 | 8 | 309 | 39 | ||||
33077 | 178244 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 62 Tomaso Ct | 4 | Front Yard : Yard | Tree | Private 2 | 17 | Width 8ft | 6009170.0421 | 2086265.24197 | 37.7090049835504 | -122.410047143074 | (37.7090049835504, -122.410047143074) | 9 | 7 | 8 | 309 | 39 | |||
20014 | 178243 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 62 Tomaso Ct | 3 | Front Yard : Yard | Tree | Private 2 | 26 | Width 8ft | 6009152.06447 | 2086268.0035 | 37.7090115585089 | -122.410109471469 | (37.7090115585089, -122.410109471469) | 9 | 7 | 8 | 309 | 39 | |||
173782 | 177816 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 60 Tomaso Ct | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Width 3ft | 6009147.33252 | 2086269.13541 | 37.7090144012735 | -122.410125905706 | (37.7090144012735, -122.410125905706) | 9 | 7 | 8 | 309 | 39 | |||
142905 | 117181 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 8 KNOTT CT | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000120 | 2086463 | 37.7090365866676 | -122.441339502506 | (37.7090365866676, -122.441339502506) | 9 | 7 | 6 | 28861 | 5 | ||||
174844 | 117180 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 8 KNOTT CT | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000120 | 2086463 | 37.7090365866676 | -122.441339502506 | (37.7090365866676, -122.441339502506) | 9 | 7 | 6 | 28861 | 5 | |||
12031 | 262472 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 210 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 6001697 | 2086437 | 37.7090549070704 | -122.435887307636 | (37.7090549070704, -122.435887307636) | 9 | 7 | 6 | 28861 | 5 | |||
16427 | 262473 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 210 Drake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 6001697 | 2086437 | 37.7090549070704 | -122.435887307636 | (37.7090549070704, -122.435887307636) | 9 | 7 | 6 | 28861 | 5 | |||
129524 | 117509 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 300x HANOVER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999715 | 2086521 | 37.7091727618039 | -122.442743399736 | (37.7091727618039, -122.442743399736) | 9 | 7 | 6 | 28861 | 5 | ||||
12759 | 113115 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
27633 | 113114 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1x TOMASO CT | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
42255 | 113119 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
46911 | 113122 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1x TOMASO CT | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
50533 | 113121 | Undocumented 4 | Eriobotrya japonica :: Edible Loquat 119 | 1x TOMASO CT | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
52382 | 113126 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
59885 | 113113 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1x TOMASO CT | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
68222 | 113118 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
81192 | 113127 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
81661 | 113130 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
100120 | 113128 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
104371 | 113116 | Undocumented 4 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 263 | 1x TOMASO CT | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
120932 | 113131 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
123231 | 113123 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
157350 | 113117 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
164325 | 113129 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 1x TOMASO CT | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
174138 | 113120 | Undocumented 4 | Eriobotrya japonica :: Edible Loquat 119 | 1x TOMASO CT | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
7333 | 262326 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 10 Roemer Way | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998623 | 2086576 | 37.7092614661016 | -122.446521459005 | (37.7092614661016, -122.446521459005) | 9 | 7 | 6 | 28861 | 5 | |||||
60445 | 251757 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 233 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001887 | 2086528 | 37.7093155646434 | -122.43523714505 | (37.7093155646434, -122.43523714505) | 9 | 7 | 6 | 28861 | 5 | ||||
107920 | 251756 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 233 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001887 | 2086528 | 37.7093155646434 | -122.43523714505 | (37.7093155646434, -122.43523714505) | 9 | 7 | 6 | 28861 | 5 | ||||
160762 | 98352 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001689 | 2086535 | 37.709323539126 | -122.435921964243 | (37.709323539126, -122.435921964243) | 9 | 7 | 6 | 28861 | 5 | ||||
168177 | 181059 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 5810 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:37:00 PM | 3 | Width 3ft | 5997243.54219 | 2086644.28205 | 37.7093700633606 | -122.451293980329 | (37.7093700633606, -122.451293980329) | 9 | 7 | 6 | 28861 | 25 | ||
164999 | 104135 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 254 WINDING WAY | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 6x9 | 6001720 | 2086577 | 37.7094406229145 | -122.435817826478 | (37.7094406229145, -122.435817826478) | 9 | 7 | 6 | 28861 | 5 | |||
53102 | 102229 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 254 WINDING WAY | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 6x9 | 6001720 | 2086577.5 | 37.7094419958048 | -122.435817862229 | (37.7094419958048, -122.435817862229) | 9 | 7 | 6 | 28861 | 5 | |||
79736 | 251742 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 300 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002771 | 2086560 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | 9 | 7 | 6 | 28861 | 5 | ||||
88641 | 251741 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002771 | 2086560 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | 9 | 7 | 6 | 28861 | 5 | ||||
158252 | 251761 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001827 | 2086593 | 37.7094906329517 | -122.435449161052 | (37.7094906329517, -122.435449161052) | 9 | 7 | 6 | 28861 | 5 | ||||
12772 | 111858 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
59455 | 111853 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | |||
71655 | 111854 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
94741 | 111857 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
120888 | 111855 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
178196 | 111856 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
29910 | 172261 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 230 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6001860 | 2086600 | 37.7095117275676 | -122.435335608043 | (37.7095117275676, -122.435335608043) | 9 | 7 | 6 | 28861 | 5 | |||
180499 | 110077 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4099x ALEMANY BLVD | Median : Cutout | Tree | Private 2 | 48 | 5991599 | 2086829 | 37.7095524384103 | -122.470815701049 | (37.7095524384103, -122.470815701049) | 9 | 8 | 4 | 64 | 24 | |||||
24902 | 180669 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 171 Winding Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 6ft | 6002170.18422 | 2086635.71157 | 37.7096273944518 | -122.434266111507 | (37.7096273944518, -122.434266111507) | 9 | 7 | 6 | 28861 | 5 | |||
158982 | 113432 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 460x PENINSULA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012123 | 2086509 | 37.7098393624731 | -122.399858330527 | (37.7098393624731, -122.399858330527) | 10 | 3 | 8 | 309 | 1 | ||||
28472 | 108538 | Undocumented 4 | Washingtonia filifera :: California Fan Palm 176 | 400-422X Tocoloma Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012449.25025 | 2086560.52634 | 37.7099990266406 | -122.398734355673 | (37.7099990266406, -122.398734355673) | 10 | 3 | 8 | 309 | 1 | |||||
2991 | 99574 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 16 | 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 | |||
28026 | 99572 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
36173 | 99571 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
36617 | 99580 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 650X Brunswick St | 20 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
41703 | 99570 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.446699086535 | (37.710155688278, -122.446699086535) | 9 | 7 | 6 | 28861 | 5 | |||
65669 | 99568 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 10 | 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 | |||
80187 | 99562 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 4 | 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 | |||
84268 | 99573 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 650X Brunswick St | 15 | 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 | |||
93883 | 99582 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 22 | 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 | |||
97231 | 99575 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650X Brunswick St | 17 | 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 | |||
99288 | 99579 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 19 | 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 | |||
108209 | 99567 | Undocumented 4 | Tree(s) :: 17 | 650X Brunswick St | 9 | 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 | |||
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 |
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) );