trees
39,840 rows where qLegalStatus_id = 7 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
45319 | 113360 | Permitted Site 7 | Tree(s) :: 17 | 821 HEAD ST | 1 | Front Yard : Yard | Tree | Private 2 | 10/08/2015 12:00:00 AM | 25 | 3x3 | Permit Number 776477 | 5993783 | 2091497 | 37.7224957130636 | -122.463606040268 | (37.7224957130636, -122.463606040268) | 9 | 8 | 4 | 59 | 40 | |
46964 | 70844 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 179 Hamerton Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/19/2015 12:00:00 AM | 3 | Permit Number 774723 | 6001345.45815513 | 2095262.03450684 | 37.7332664863814 | -122.437733908358 | (37.7332664863814, -122.437733908358) | 9 | 7 | 5 | 63 | 40 | ||
47226 | 94411 | Permitted Site 7 | Tree(s) :: 17 | 905 California St | 1 | Front Yard : Yard | Tree | Private 2 | 07/27/2010 12:00:00 AM | 9 | Permit Number 53651 | 6010018 | 2116471 | 37.7919908000075 | -122.409246561226 | (37.7919908000075, -122.409246561226) | 5 | 1 | 10 | 28857 | 21 | ||
47259 | 94419 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 5800 03rd St | 12 | Front Yard : Yard | Tree | Private 2 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849 | 2092184 | 37.7255178628117 | -122.394289979276 | (37.7255178628117, -122.394289979276) | 10 | 3 | 8 | 58 | 1 | ||
47902 | 92013 | Permitted Site 7 | Tree(s) :: 17 | 360 04th St | 7 | Front Yard : Yard | Tree | Private 2 | 06/02/2009 12:00:00 AM | Permit Number 52163 | 6012527 | 2112512 | 37.7812605579477 | -122.400287160132 | (37.7812605579477, -122.400287160132) | 6 | 2 | 9 | 28856 | 34 | |||
48089 | 96905 | Permitted Site 7 | Ulmus 'Frontier' :: Frontier Elm 115 | 1155@Greenwich Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 08/05/2011 12:00:00 AM | Park | Permit Number 768022 | 6012245 | 2120028 | 37.8018819838627 | -122.401791216362 | (37.8018819838627, -122.401791216362) | 3 | 1 | 10 | 28860 | 6 | ||
49841 | 68449 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 4054 20th St | 2 | Front Yard : Yard | Tree | Private 2 | FUF | 04/24/1999 12:00:00 AM | Permit Number 32307 | 6003251.17179249 | 2104206.64930012 | 37.7579344920216 | -122.431783761852 | (37.7579344920216, -122.431783761852) | 2 | 4 | 5 | 28862 | 3 | ||
49914 | 93587 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 8 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
51017 | 92762 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
51128 | 93601 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 22 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
51143 | 104236 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1265 Bosworth St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770727 | 6000365.2 | 2096127.5 | 37.7355870653858 | -122.441184993439 | (37.7355870653858, -122.441184993439) | 9 | 7 | 4 | 63 | 40 | ||||
51474 | 98149 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 850 Rockdale Dr | 1 | Front Yard : Yard | Tree | Private 2 | 02/23/2012 12:00:00 AM | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | 9 | 7 | 4 | 59 | 40 | |||
54038 | 104639 | Permitted Site 7 | Tree(s) :: 17 | 217 Montcalm St | 3 | Front Yard : Yard | Tree | Private 2 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | |||||
61358 | 97440 | Permitted Site 7 | Lagerstroemia indica :: Crape Myrtle 259 | 1900 Pacific Ave | 5 | Front Yard : Yard | Tree | Private 2 | 10/11/2011 12:00:00 AM | Permit Number 768364 | 6004943.9 | 2117474.7 | 37.7944611255838 | -122.426874507837 | (37.7944611255838, -122.426874507837) | 13 | 9 | 1 | 28858 | 27 | |||
62133 | 106822 | Permitted Site 7 | Tree(s) :: 17 | 75 Cerritos Ave | 1 | Front Yard : Yard | Tree | Private 2 | 06/09/2014 12:00:00 AM | 5992422.3 | 2092894.9 | 37.7262555054251 | -122.468411282045 | (37.7262555054251, -122.468411282045) | 9 | 8 | 4 | 59 | 40 | ||||
63358 | 106823 | Permitted Site 7 | Tree(s) :: 17 | 75 Cerritos Ave | 2 | Front Yard : Yard | Tree | Private 2 | 06/09/2014 12:00:00 AM | 5992422.3 | 2092894.9 | 37.7262555054251 | -122.468411282045 | (37.7262555054251, -122.468411282045) | 9 | 8 | 4 | 59 | 40 | ||||
64321 | 92014 | Permitted Site 7 | Tree(s) :: 17 | 360 04th St | 8 | Front Yard : Yard | Tree | Private 2 | 06/02/2009 12:00:00 AM | Permit Number 52163 | 6012527 | 2112512 | 37.7812605579477 | -122.400287160132 | (37.7812605579477, -122.400287160132) | 6 | 2 | 9 | 28856 | 34 | |||
66938 | 92761 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
69911 | 93593 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 14 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
72305 | 93603 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 24 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
76407 | 87294 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2087 28th Ave | Front Yard : Yard | Tree | Private 2 | 03/20/2008 12:00:00 AM | Permit Number 50307 | 5987541.6 | 2101099.3 | 37.7484995140672 | -122.485885323793 | (37.7484995140672, -122.485885323793) | 1 | 8 | 3 | 29491 | 35 | ||||
77392 | 116877 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 401x Franconia St | 2 | Front Yard : Yard | Tree | Private 2 | 05/05/2016 12:00:00 AM | 3 | Permit Number 777241 | 6009999.3 | 2098658.1 | 37.743079617703 | -122.408054487165 | (37.743079617703, -122.408054487165) | 10 | 7 | 7 | 28859 | 2 | ||
80026 | 93602 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 23 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
82600 | 93581 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
87551 | 94417 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 5800 03rd St | 4 | Front Yard : Yard | Tree | Private 2 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849 | 2092184 | 37.7255178628117 | -122.394289979276 | (37.7255178628117, -122.394289979276) | 10 | 3 | 8 | 58 | 1 | ||
87570 | 92759 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
88794 | 98150 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 850 Rockdale Dr | 2 | Front Yard : Yard | Tree | Private 2 | 02/23/2012 12:00:00 AM | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | 9 | 7 | 4 | 59 | 40 | |||
91877 | 113055 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 815 Buena Vista West Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5999858 | 2108239 | 37.76881339508 | -122.443808439423 | (37.76881339508, -122.443808439423) | 15 | 5 | 11 | 29492 | 9 | |||||
92240 | 93591 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 12 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
93058 | 93037 | Permitted Site 7 | Tree(s) :: 17 | 1220 45th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 01/14/2010 12:00:00 AM | Permit Number 53146 | 5982155.6 | 2106783.3 | 37.7637908375908 | -122.504930842514 | (37.7637908375908, -122.504930842514) | 1 | 8 | 3 | 56 | 35 | |||
99136 | 93605 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 26 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
99892 | 94418 | Permitted Site 7 | Hymenosporum flavum :: Sweet Shade 125 | 5800 03rd St | 8 | Front Yard : Yard | Tree | Private 2 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849 | 2092184 | 37.7255178628117 | -122.394289979276 | (37.7255178628117, -122.394289979276) | 10 | 3 | 8 | 58 | 1 | ||
101232 | 107902 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 133 Elsie St | Front Yard : Yard | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | Permit Number 773996 | 6007164.40736 | 2098513.65139 | 37.742523860764 | -122.417846568545 | (37.742523860764, -122.417846568545) | 2 | 7 | 7 | 28859 | 2 | |||
102260 | 93612 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 33 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
105077 | 93590 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 11 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
105397 | 93582 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
105469 | 93596 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 17 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
107637 | 94416 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 5800 03rd St | 3 | Front Yard : Yard | Tree | Private 2 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849 | 2092184 | 37.7255178628117 | -122.394289979276 | (37.7255178628117, -122.394289979276) | 10 | 3 | 8 | 58 | 1 | ||
107823 | 93609 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 30 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
120398 | 102679 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 333 Eucalyptus Dr | 5 | Front Yard : Yard | Tree | Private 2 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133155 | -122.476573573496 | (37.731002133155, -122.476573573496) | 1 | 8 | 4 | 64 | 14 | |||
120964 | 102675 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 333 Eucalyptus Dr | 1 | Front Yard : Yard | Tree | Private 2 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133155 | -122.476573573496 | (37.731002133155, -122.476573573496) | 1 | 8 | 4 | 64 | 14 | |||
122326 | 108368 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 36 KNOLLVIEW WAY | 2 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 774549 | 5997629 | 2101321 | 37.7496909137477 | -122.451019424553 | (37.7496909137477, -122.451019424553) | 1 | 5 | 4 | 63 | 38 | |||
122539 | 98164 | Permitted Site 7 | Magnolia x alba :: White Champaca 294 | 90 Balceta Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12/22/2011 12:00:00 AM | Permit Number 768312 | 5995830.5 | 2099880.5 | 37.7456325309111 | -122.457134479076 | (37.7456325309111, -122.457134479076) | 1 | 5 | 4 | 59 | 40 | |||
125360 | 92755 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
127741 | 93588 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 9 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
131448 | 112486 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 6 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | Permit Number 774532 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||
134204 | 92767 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
135151 | 97924 | Permitted Site 7 | Tree(s) :: 17 | 2939 Divisadero St | 1 | Front Yard : Yard | Tree | Private 2 | 12/02/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768415 | 6000521 | 2118346 | 37.7966024147448 | -122.442240817081 | (37.7966024147448, -122.442240817081) | 13 | 9 | 1 | 57 | 17 | |
135662 | 102677 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 333 Eucalyptus Dr | 3 | Front Yard : Yard | Tree | Private 2 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133155 | -122.476573573496 | (37.731002133155, -122.476573573496) | 1 | 8 | 4 | 64 | 14 | |||
137802 | 93611 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 32 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
141772 | 88288 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 74 Lobos St | 1 | Front Yard : Yard | Tree | Private 2 | 07/09/2008 12:00:00 AM | Permit Number 51290 | 5996341 | 2088696 | 37.7149518852461 | -122.454561415793 | (37.7149518852461, -122.454561415793) | 9 | 8 | 6 | 28861 | 24 | |||
143575 | 104077 | Permitted Site 7 | Tree(s) :: 17 | 39 Miraloma Dr | 1 | Front Yard : Yard | Tree | Private 2 | 08/07/2013 12:00:00 AM | Permit Number 770105 | 5994966 | 2097586 | 37.7392827186602 | -122.459957583013 | (37.7392827186602, -122.459957583013) | 9 | 7 | 4 | 59 | 40 | |||
145051 | 108367 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 36 KNOLLVIEW WAY | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 774549 | 5997629 | 2101321 | 37.7496909137477 | -122.451019424553 | (37.7496909137477, -122.451019424553) | 1 | 5 | 4 | 63 | 38 | |||
146539 | 104831 | Permitted Site 7 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 3210 Jackson St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | 3x3 | 5998893.9 | 2116279.9 | 37.7908365867802 | -122.447722110161 | (37.7908365867802, -122.447722110161) | 13 | 6 | 1 | 54 | 31 | |||
147791 | 93604 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 25 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
147850 | 65849 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 66 Rico Way | 1 | Front Yard : Yard | Tree | Private 2 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50013 | 6001352.95008446 | 2121456.09779386 | 37.8051893002679 | -122.439585161616 | (37.8051893002679, -122.439585161616) | 13 | 9 | 1 | 57 | 17 | ||
149511 | 92766 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
150534 | 93599 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 20 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
151733 | 93584 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 5 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
151826 | 255813 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 532 Wawona St | 1 | Front Yard : Yard | Tree | Private 2 | 07/24/2018 12:00:00 AM | 3 | 3X3 | Permit Number 782164 | 5991340.67425 | 2097062.85197 | 37.7376371178542 | -122.472454091358 | (37.7376371178542, -122.472454091358) | 1 | 8 | 4 | 29491 | 40 | |
152091 | 86746 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 41 Nevada St | Front Yard : Yard | Tree | Private 2 | Permit Number 49711 | 6009063 | 2098235 | 37.7418654099413 | -122.411262090685 | (37.7418654099413, -122.411262090685) | 10 | 7 | 7 | 28859 | 2 | |||||
153229 | 93229 | Permitted Site 7 | Tree(s) :: 17 | 804 Steiner St | 1 | Front Yard : Yard | Tree | Private 2 | 03/02/2010 12:00:00 AM | Permit Number 53218 | 6003047.9 | 2111017.2 | 37.7766230788836 | -122.432973325779 | (37.7766230788836, -122.432973325779) | 15 | 9 | 11 | 29492 | 10 | |||
153547 | 102676 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 333 Eucalyptus Dr | 2 | Front Yard : Yard | Tree | Private 2 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133155 | -122.476573573496 | (37.731002133155, -122.476573573496) | 1 | 8 | 4 | 64 | 14 | |||
153817 | 93608 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 29 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
154711 | 93592 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 13 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
157028 | 93583 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 4 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
160499 | 94688 | Permitted Site 7 | Tree(s) :: 17 | 230 Upland Dr | 1 | Front Yard : Yard | Tree | Private 2 | 10/27/2010 12:00:00 AM | 23 | 2x3 | Permit Number 53827 | 5993701 | 2094087 | 37.729602496423 | -122.464077417771 | (37.729602496423, -122.464077417771) | 9 | 8 | 4 | 59 | 40 | |
161689 | 94415 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 5800 03rd St | 2 | Front Yard : Yard | Tree | Private 2 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849 | 2092184 | 37.7255178628117 | -122.394289979276 | (37.7255178628117, -122.394289979276) | 10 | 3 | 8 | 58 | 1 | ||
163590 | 93589 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 10 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
164392 | 93598 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 19 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
169314 | 113391 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2151 15TH AVE | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 12/10/2015 12:00:00 AM | 1 | Permit Number 776062 | 5991602 | 2100781 | 37.7478613219593 | -122.471821470999 | (37.7478613219593, -122.471821470999) | 1 | 8 | 4 | 29491 | 40 | |
171080 | 104237 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1265 Bosworth St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 770727 | 6000365.2 | 2096127.5 | 37.7355870653858 | -122.441184993439 | (37.7355870653858, -122.441184993439) | 9 | 7 | 4 | 63 | 40 | ||||
172237 | 108298 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 10X Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 12/15/2014 12:00:00 AM | 3 | Permit Number 774449 | 6012830 | 2116175 | 37.7913351933509 | -122.399496166675 | (37.7913351933509, -122.399496166675) | 4 | 1 | 10 | 28854 | 6 | ||
173673 | 92758 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
174810 | 93600 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 21 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
175451 | 93607 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 28 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
175622 | 92757 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
176461 | 108981 | Permitted Site 7 | Eucalyptus odorata :: Peppermint Box 526 | 10 ARBOR ST | Front Yard : Yard | Tree | Private 2 | 03/02/2015 12:00:00 AM | 3 | Permit Number 774690 | 6002183.8 | 2097008.7 | 37.7381100606509 | -122.434960408352 | (37.7381100606509, -122.434960408352) | 2 | 7 | 5 | 63 | 7 | |||
181940 | 93586 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 7 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
182311 | 94636 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 170X Crestmont Dr | 1 | Front Yard : Yard | Tree | Private 2 | 09/24/2010 12:00:00 AM | Permit Number 53783 | 5995178.5 | 2103444 | 37.7553795372421 | -122.459647037768 | (37.7553795372421, -122.459647037768) | 1 | 5 | 4 | 63 | 12 | |||
189311 | 105224 | Permitted Site 7 | Tree(s) :: 17 | 1155X Buchanan St | 1 | Front Yard : Yard | Tree | Private 2 | 01/02/2014 12:00:00 AM | Permit Number 771274 | 6004294.39059 | 2112384.93564 | 37.7804491663905 | -122.428758877311 | (37.7804491663905, -122.428758877311) | 7 | 9 | 11 | 29490 | 41 | |||
192239 | 107674 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 133 ELSIE ST | 1 | Front Yard : Yard | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | 6007164.4 | 2098513.7 | 37.742523993822 | -122.417846597438 | (37.742523993822, -122.417846597438) | 2 | 7 | 7 | 28859 | 2 | |||
193323 | 94637 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 170X Crestmont Dr | 2 | Front Yard : Yard | Tree | Private 2 | 09/24/2010 12:00:00 AM | Permit Number 53783 | 5995178.5 | 2103444 | 37.7553795372421 | -122.459647037768 | (37.7553795372421, -122.459647037768) | 1 | 5 | 4 | 63 | 12 | |||
1132 | 87818 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 85 Mendosa Ave | 1 | Median : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | Permit Number 50680 | 5993356 | 2100787 | 37.747979128324 | -122.465756707117 | (37.747979128324, -122.465756707117) | 1 | 8 | 4 | 29491 | 40 | |||
2509 | 27941 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 699 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.8014446443351 | -122.399901749617 | (37.8014446443351, -122.399901749617) | 3 | 1 | 10 | 28860 | 6 | |||
3522 | 25785 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
7166 | 48480 | Permitted Site 7 | Tree(s) :: 17 | 1 | Median : Cutout | Tree | Private 2 | Permit Number 45832 | |||||||||||||||
7822 | 26018 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6012483.6012207 | 2120310.1113669 | 37.8026699057947 | -122.400985372375 | (37.8026699057947, -122.400985372375) | 3 | 1 | 10 | 28860 | 6 | ||
8261 | 25749 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011423.5148387 | 2121491.4283584 | 37.805854321699 | -122.404737040358 | (37.805854321699, -122.404737040358) | 3 | 1 | 10 | 28860 | 23 | ||
9743 | 34866 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 579 Miramar Ave | 1 | Median : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | 9 | 7 | 4 | 28861 | 40 | ||
17161 | 28026 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014253.80701 | 2117776.67601 | 37.795812278914 | -122.394682002417 | (37.795812278914, -122.394682002417) | 4 | 2 | 10 | 28860 | 6 | ||
18148 | 27929 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | 3 | 1 | 10 | 28860 | 6 | ||
20512 | 25787 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012271.38601 | 2120709.84401 | 37.8037556344242 | -122.401747862284 | (37.8037556344242, -122.401747862284) | 3 | 1 | 10 | 28860 | 6 | ||
20840 | 27943 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 699 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.8014446443351 | -122.399901749617 | (37.8014446443351, -122.399901749617) | 3 | 1 | 10 | 28860 | 6 | |||
22525 | 25795 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 9 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012764.87501 | 2119980.67701 | 37.8017810445969 | -122.399988868692 | (37.8017810445969, -122.399988868692) | 3 | 1 | 10 | 28860 | 6 | ||
22781 | 26096 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 499X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6013385.9217822 | 2119009.0450001 | 37.7991477810775 | -122.397771551765 | (37.7991477810775, -122.397771551765) | 3 | 1 | 10 | 28860 | 6 | ||
23927 | 27766 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 24 | 6013580.1568022 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | 3 | 1 | 10 | 28860 | 6 | |||
24155 | 26028 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 599X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 4X4 | 6012976.7050293 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | 3 | 1 | 10 | 28860 | 6 | ||
25206 | 25733 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 501X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013387.7643744 | 2119020.8269614 | 37.7991802341421 | -122.39776600259 | (37.7991802341421, -122.39776600259) | 3 | 1 | 10 | 28860 | 6 | ||
25228 | 27953 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.393196597915 | (37.7940982979938, -122.393196597915) | 12 | 2 | 10 | 28855 | 6 |
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) );