8,298 rows where qLegalStatus_id = 4 sorted by Latitude

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);