trees

39,840 rows where qLegalStatus_id = 7 sorted by qSpecies_id descending

✎ View and edit SQL

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)
187521 100073 Permitted Site 7 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 930@ Lorraine Ct Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2012 12:00:00 AM   3x3 Permit Number 769060 5996162 2112255 37.7796287713947 -122.456883064061 (37.7796287713947, -122.456883064061) 11 6 2 54 16
160289 26589 Permitted Site 7 Ulmus procera :: English Elm 413 1647 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2000 12:00:00 AM 6 3X3   6012128.96715 2091072.24592 37.7223694528076 -122.400157976887 (37.7223694528076, -122.400157976887) 10 3 8 58 1
38506 11875 Permitted Site 7 Juglans californica :: Walnut: Black (s.calif) 412 1501X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree PUC 8     18 3x3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061) 9 8 4 64 24
24862 40225 Permitted Site 7 Acer ginnela :: Amur Maple 408 394 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1999 12:00:00 AM     Permit Number 41407 6003833.01657725 2102180.77232097 37.7524048777321 -122.429627013671 (37.7524048777321, -122.429627013671) 2 4 5 28862 22
24007 112959 Permitted Site 7 Tilia americana 'Redmond' :: Redmond Linden 403 2501 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010338.6 2105004.3 37.760523871543 -122.407328560408 (37.760523871543, -122.407328560408) 10 4 8 28859 19
113181 112960 Permitted Site 7 Tilia americana 'Redmond' :: Redmond Linden 403 2501 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/02/2015 12:00:00 AM   3x3   6010338.6 2105004.3 37.760523871543 -122.407328560408 (37.760523871543, -122.407328560408) 10 4 8 28859 19
23887 39717 Permitted Site 7 Malus x 'Callaway' :: White-Flowered Crabapple 402 735 Mangels Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41098 5996645.89936221 2095233.50926101 37.732919821696 -122.453979420774 (37.732919821696, -122.453979420774) 9 7 4 59 40
41153 47719 Permitted Site 7 Malus x 'Callaway' :: White-Flowered Crabapple 402 227 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45514 6001968.67680158 2096145.76019893 37.7357284107067 -122.435642476033 (37.7357284107067, -122.435642476033) 2 7 5 63 7
68890 50864 Permitted Site 7 Malus x 'Callaway' :: White-Flowered Crabapple 402 3949 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2004 12:00:00 AM     Permit Number 47379 6004213.25771434 2100699.47949469 37.7483591159424 -122.428206518167 (37.7483591159424, -122.428206518167) 2 4 5 63 22
96806 39713 Permitted Site 7 Malus x 'Callaway' :: White-Flowered Crabapple 402 690 Mangels Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   01/05/1999 12:00:00 AM     Permit Number 41097 5996877.25794519 2095301.81406685 37.7331206330938 -122.45318448806 (37.7331206330938, -122.45318448806) 9 7 4 59 40
136479 39712 Permitted Site 7 Malus x 'Callaway' :: White-Flowered Crabapple 402 690 Mangels Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/05/1999 12:00:00 AM     Permit Number 41097 5996877.25794519 2095301.81406685 37.7331206330938 -122.45318448806 (37.7331206330938, -122.45318448806) 9 7 4 59 40
143171 46918 Permitted Site 7 Malus x 'Callaway' :: White-Flowered Crabapple 402 132 Apollo St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2002 12:00:00 AM     Permit Number 44975 6012573.05799142 2094250.99481075 37.731122398703 -122.398845831273 (37.731122398703, -122.398845831273) 10 3 8 58 1
151306 39716 Permitted Site 7 Malus x 'Callaway' :: White-Flowered Crabapple 402 690 Mangels Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/05/1999 12:00:00 AM     Permit Number 41097 5996877.25794519 2095301.81406685 37.7331206330938 -122.45318448806 (37.7331206330938, -122.45318448806) 9 7 4 59 40
168294 39714 Permitted Site 7 Malus x 'Callaway' :: White-Flowered Crabapple 402 690 Mangels Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41097 5996877.25794519 2095301.81406685 37.7331206330938 -122.45318448806 (37.7331206330938, -122.45318448806) 9 7 4 59 40
190216 39715 Permitted Site 7 Malus x 'Callaway' :: White-Flowered Crabapple 402 690 Mangels Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   01/05/1999 12:00:00 AM     Permit Number 41097 5996877.25794519 2095301.81406685 37.7331206330938 -122.45318448806 (37.7331206330938, -122.45318448806) 9 7 4 59 40
27370 94880 Permitted Site 7 Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 1590x MCKINNON AVE 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53948 6015457 2095933 37.7359011166528 -122.388992845715 (37.7359011166528, -122.388992845715) 10 3 8 58 1
31075 95839 Permitted Site 7 Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 2 Sheridan St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/29/2011 12:00:00 AM   3x3 Permit Number 767567 6009435.1 2109579.3 37.7730351591854 -122.410776475157 (37.7730351591854, -122.410776475157) 8 2 9 28853 34
59480 102201 Permitted Site 7 Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 442 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2013 12:00:00 AM 3 3x3 Permit Number 769775 6002908.2 2105655.8 37.7618940636715 -122.433073438645 (37.7618940636715, -122.433073438645) 15 4 5 28862 3
69446 78196 Permitted Site 7 Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 130 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2009 12:00:00 AM   3x3 Permit Number 52582 6007025.13106895 2098703.78217433 37.743038078306 -122.41834162381 (37.743038078306, -122.41834162381) 2 7 7 28859 2
93530 94881 Permitted Site 7 Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 1590x MCKINNON AVE 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53948 6015457 2095933 37.7359011166528 -122.388992845715 (37.7359011166528, -122.388992845715) 10 3 8 58 1
104725 82742 Permitted Site 7 Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 207 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM 7 3x3 Permit Number 52434 6008814.37056405 2110286.91631719 37.7749432836243 -122.412973704517 (37.7749432836243, -122.412973704517) 8 2 9 28853 34
130707 95840 Permitted Site 7 Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 2 Sheridan St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/29/2011 12:00:00 AM   3x3 Permit Number 767567 6009435.1 2109579.3 37.7730351591854 -122.410776475157 (37.7730351591854, -122.410776475157) 8 2 9 28853 34
140323 95838 Permitted Site 7 Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 2 Sheridan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/29/2011 12:00:00 AM   3x3 Permit Number 767567 6009435.1 2109579.3 37.7730351591854 -122.410776475157 (37.7730351591854, -122.410776475157) 8 2 9 28853 34
149593 82986 Permitted Site 7 Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 130 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2009 12:00:00 AM   3x3 Permit Number 52582 6007025.13106895 2098703.78217433 37.743038078306 -122.41834162381 (37.743038078306, -122.41834162381) 2 7 7 28859 2
153982 28788 Permitted Site 7 Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 2948 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/2005 12:00:00 AM 3 3X3   6008327.76166 2101276.48444 37.7501753870711 -122.414019428779 (37.7501753870711, -122.414019428779) 2 4 7 28859 19
155718 44029 Permitted Site 7 Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 401 96 Lafayette St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2000 12:00:00 AM     Permit Number 43568 6007789.10415303 2109389.65553955 37.7724220125921 -122.416456760011 (37.7724220125921, -122.416456760011) 8 2 9 28853 19
23531 33504 Permitted Site 7 Fraxinus holotricha :: Holotricha Ash 399 187 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM     Permit Number 37598 6006493.12826546 2098644.93339698 37.7428465310244 -122.420176972942 (37.7428465310244, -122.420176972942) 2 7 7 28859 2
60704 117515 Permitted Site 7 Fraxinus holotricha :: Holotricha Ash 399 252 SANCHEZ ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6003503 2106732 37.7648827709762 -122.431093076836 (37.7648827709762, -122.431093076836) 15 4 5 28862 3
153274 33490 Permitted Site 7 Fraxinus holotricha :: Holotricha Ash 399 35 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/1996 12:00:00 AM     Permit Number 37609 6006977.21573848 2099539.13365135 37.7453290686773 -122.418566525643 (37.7453290686773, -122.418566525643) 2 7 7 28859 2
184060 33506 Permitted Site 7 Fraxinus holotricha :: Holotricha Ash 399 229 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM     Permit Number 37601 6006405.76060345 2098478.97764317 37.7423859306557 -122.420467289121 (37.7423859306557, -122.420467289121) 2 7 7 28859 2
193213 33505 Permitted Site 7 Fraxinus holotricha :: Holotricha Ash 399 201 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM     Permit Number 37599 6006452.6422086 2098569.84491652 37.7426380736375 -122.420311634322 (37.7426380736375, -122.420311634322) 2 7 7 28859 2
21974 62694 Permitted Site 7 Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 395 223 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1987 12:00:00 AM     Permit Number 24327 6005062.32368294 2100161.23117158 37.7469292144699 -122.425232170901 (37.7469292144699, -122.425232170901) 2 7 5 63 22
87674 59885 Permitted Site 7 Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 395 1850 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/07/1981 12:00:00 AM     Permit Number 19351 5998908.71324025 2110792.89105347 37.7757715367559 -122.447275774754 (37.7757715367559, -122.447275774754) 15 5 2 29492 16
88625 67362 Permitted Site 7 Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 395 2671 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1992 12:00:00 AM     Permit Number 30853 6010086.54525916 2103948.57589748 37.757610980443 -122.408125849252 (37.757610980443, -122.408125849252) 2 4 7 28859 19
132086 66692 Permitted Site 7 Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 395 201 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1991 12:00:00 AM     Permit Number 29921 6008604.66149229 2112784.65195825 37.7817896977572 -122.413875858365 (37.7817896977572, -122.413875858365) 7 10 9 28852 36
173785 63629 Permitted Site 7 Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 395 226 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/22/2011 12:00:00 AM     Permit Number 24272 6005034.16074873 2100211.76184956 37.7470663690256 -122.425333151112 (37.7470663690256, -122.425333151112) 2 7 5 63 22
92408 35508 Permitted Site 7 Radermachera sinica :: China Doll Tree 394 3460 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/23/1998 12:00:00 AM     Permit Number 38910 6005335.59882734 2103155.12631958 37.7551651932954 -122.42450013257 (37.7551651932954, -122.42450013257) 2 4 5 28859 19
19951 43473 Permitted Site 7 Quercus wislizenii :: Interior Live Oak 389 1000 Cayuga Ave 11 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2000 12:00:00 AM     Permit Number 43163 6000647.65925572 2091203.91791776 37.722084128815 -122.439855525614 (37.722084128815, -122.439855525614) 9 7 6 28861 25
137440 43468 Permitted Site 7 Quercus wislizenii :: Interior Live Oak 389 1000 Cayuga Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2000 12:00:00 AM     Permit Number 43163 6000647.65925572 2091203.91791776 37.722084128815 -122.439855525614 (37.722084128815, -122.439855525614) 9 7 6 28861 25
137584 43460 Permitted Site 7 Quercus wislizenii :: Interior Live Oak 389 1000 Cayuga Ave 13 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2000 12:00:00 AM     Permit Number 43163 6000647.65925572 2091203.91791776 37.722084128815 -122.439855525614 (37.722084128815, -122.439855525614) 9 7 6 28861 25
19900 44785 Permitted Site 7 Magnolia x foggii 'Jack Fogg' :: Jack Fogg Michelia 388 2617 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM     Permit Number 43881 6010076.56395717 2105007.94237061 37.7605192034119 -122.408235084144 (37.7605192034119, -122.408235084144) 2 4 8 28859 19
140552 45265 Permitted Site 7 Magnolia x foggii 'Jack Fogg' :: Jack Fogg Michelia 388 518 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2001 12:00:00 AM     Permit Number 44111 6008531.90898366 2096401.49208651 37.7368011983538 -122.41296882917 (37.7368011983538, -122.41296882917) 10 7 7 28859 2
169127 47008 Permitted Site 7 Magnolia x foggii 'Jack Fogg' :: Jack Fogg Michelia 388 152 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/25/2002 12:00:00 AM     Permit Number 45006 6003832.178109 2108907.79685217 37.7708756291768 -122.430109763276 (37.7708756291768, -122.430109763276) 7 9 11 29492 10
25764 84866 Permitted Site 7 Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 1800 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2014 12:00:00 AM 12   Permit No. 49260 6006192 2116736.3 37.7925041547793 -122.422503429039 (37.7925041547793, -122.422503429039) 13 9 10 28858 32
27513 85279 Permitted Site 7 Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 2265 California St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM     Permit Number 49569 6003535 2115568 37.7891460516563 -122.431613280743 (37.7891460516563, -122.431613280743) 13 9 1 29490 27
63042 108158 Permitted Site 7 Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 2559 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/26/2014 12:00:00 AM 3 3x3 Permit Number 770697 6005706.55725 2119199.49847 37.7992400776696 -122.424358353177 (37.7992400776696, -122.424358353177) 13 9 1 57 17
66297 84863 Permitted Site 7 Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 1800 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2014 12:00:00 AM 3   Permit Number 771086 6006192 2116736.3 37.7925041547793 -122.422503429039 (37.7925041547793, -122.422503429039) 13 9 10 28858 32
119234 105533 Permitted Site 7 Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 1800X Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2014 12:00:00 AM     Permit Number 771086 6006192 2116736.3 37.7925041547793 -122.422503429039 (37.7925041547793, -122.422503429039) 13 9 10 28858 32
123525 85280 Permitted Site 7 Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 2265 California St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003535 2115568 37.7891460516563 -122.431613280743 (37.7891460516563, -122.431613280743) 13 9 1 29490 27
134034 105532 Permitted Site 7 Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 386 1800X Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2014 12:00:00 AM     Permit Number 771086 6006192 2116736.3 37.7925041547793 -122.422503429039 (37.7925041547793, -122.422503429039) 13 9 10 28858 32
70939 113392 Permitted Site 7 Corymbia citriodora :: Lemon Scented Gum 384 2741 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991774.5 2096885.7 37.7371758034866 -122.470941261472 (37.7371758034866, -122.470941261472) 1 8 4 29491 40
31509 61146 Permitted Site 7 Fraxinus americana :: American Ash 381 218 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/01/1983 12:00:00 AM     Permit Number 21000 5997856.78022338 2109854.41813893 37.7731345685047 -122.450846975383 (37.7731345685047, -122.450846975383) 15 5 11 29492 16
103226 79790 Permitted Site 7 Fraxinus americana :: American Ash 381 1367 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52440 6008963.36292155 2109590.31438919 37.7730389407256 -122.41240905716 (37.7730389407256, -122.41240905716) 8 2 9 28853 34
121101 84273 Permitted Site 7 Fraxinus americana :: American Ash 381 3420 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50589 6007432.35867316 2104438.63663813 37.7588076039256 -122.417339857257 (37.7588076039256, -122.417339857257) 2 4 7 28859 19
166697 35778 Permitted Site 7 Fraxinus americana :: American Ash 381 3426 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51390 6007395.20860977 2104436.57542117 37.7587998540815 -122.417468193596 (37.7587998540815, -122.417468193596) 2 4 7 28859 19
17928 87790 Permitted Site 7 Brahea aramata :: Mexican Blue Palm 377 635 Buena Vista West Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/31/2008 12:00:00 AM     Permit Number 50531 5999771 2107673 37.7672543384354 -122.444068690497 (37.7672543384354, -122.444068690497) 15 5 5 29492 9
27350 87261 Permitted Site 7 Brahea aramata :: Mexican Blue Palm 377 2360 Pacific Ave   Sidewalk: Curb side : Cutout Tree Private 2   03/12/2009 12:00:00 AM   3x3 Permit Number 52082 6002863.7 2117183.6 37.7935440023778 -122.434051428216 (37.7935440023778, -122.434051428216) 13 9 1 29490 27
41279 87262 Permitted Site 7 Brahea aramata :: Mexican Blue Palm 377 2360 Pacific Ave   Sidewalk: Curb side : Cutout Tree Private 2   03/12/2009 12:00:00 AM   3x3 Permit Number 52082 6002863.7 2117183.6 37.7935440023778 -122.434051428216 (37.7935440023778, -122.434051428216) 13 9 1 29490 27
47898 92681 Permitted Site 7 Brahea aramata :: Mexican Blue Palm 377 2660 Harrison St   Sidewalk: Curb side : Cutout Tree Private 2   09/14/2009 12:00:00 AM     Permit Number 52944 6008902 2102968 37.7548521445958 -122.412153203197 (37.7548521445958, -122.412153203197) 2 4 7 28859 19
80645 87789 Permitted Site 7 Brahea aramata :: Mexican Blue Palm 377 635 Buena Vista West Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/31/2008 12:00:00 AM     Permit Number 50531 5999771 2107673 37.7672543384354 -122.444068690497 (37.7672543384354, -122.444068690497) 15 5 5 29492 9
85344 91385 Permitted Site 7 Brahea aramata :: Mexican Blue Palm 377 855 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2009 12:00:00 AM   3x3 Permit Number 52083 5990825 2101082 37.7486428010582 -122.474530236673 (37.7486428010582, -122.474530236673) 1 8 4 29491 40
128214 92680 Permitted Site 7 Brahea aramata :: Mexican Blue Palm 377 2660 Harrison St   Sidewalk: Curb side : Cutout Tree Private 2   09/14/2009 12:00:00 AM     Permit Number 52944 6008902 2102968 37.7548521445958 -122.412153203197 (37.7548521445958, -122.412153203197) 2 4 7 28859 19
184824 87260 Permitted Site 7 Brahea aramata :: Mexican Blue Palm 377 2360 Pacific Ave   Sidewalk: Curb side : Cutout Tree Private 2   03/12/2009 12:00:00 AM   3x3 Permit Number 52082 6002863.7 2117183.6 37.7935440023778 -122.434051428216 (37.7935440023778, -122.434051428216) 13 9 1 29490 27
17640 33844 Permitted Site 7 Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum 375 790 Pennsylvania Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2013 12:00:00 AM     Permit Number 767208 6014420.16934645 2103447.5968517 37.7564770950936 -122.39310324452 (37.7564770950936, -122.39310324452) 10 3 8 28856 29
22429 33840 Permitted Site 7 Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum 375 790 Pennsylvania Ave 12 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2013 12:00:00 AM     Permit Number 767208 6014420.16934645 2103447.5968517 37.7564770950936 -122.39310324452 (37.7564770950936, -122.39310324452) 10 3 8 28856 29
32713 71723 Permitted Site 7 Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum 375 1635 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767445 6002617.90640431 2100826.33987679 37.7486170486522 -122.433732264652 (37.7486170486522, -122.433732264652) 2 4 5 28862 22
50343 33849 Permitted Site 7 Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum 375 790 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2013 12:00:00 AM 3 3x3 Permit Number 767208 6014420.16934645 2103447.5968517 37.7564770950936 -122.39310324452 (37.7564770950936, -122.39310324452) 10 3 8 28856 29
52745 33848 Permitted Site 7 Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum 375 790 Pennsylvania Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2013 12:00:00 AM 3 3x3 Permit Number 767208 6014420.16934645 2103447.5968517 37.7564770950936 -122.39310324452 (37.7564770950936, -122.39310324452) 10 3 8 28856 29
84953 82369 Permitted Site 7 Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum 375 390X San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2007 12:00:00 AM 4 3x3 Permit Number 49903 6006735.54842487 2103815.93628153 37.7570585841288 -122.419705571484 (37.7570585841288, -122.419705571484) 2 4 7 28859 19
111297 77104 Permitted Site 7 Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum 375 790 Pennsylvania Ave 18 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2013 12:00:00 AM     Permit Number 767208 6014420.16934645 2103447.5968517 37.7564770950936 -122.39310324452 (37.7564770950936, -122.39310324452) 10 3 8 28856 29
129481 33839 Permitted Site 7 Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum 375 790 Pennsylvania Ave 13 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2013 12:00:00 AM     Permit Number 767208 6014420.16934645 2103447.5968517 37.7564770950936 -122.39310324452 (37.7564770950936, -122.39310324452) 10 3 8 28856 29
143328 82358 Permitted Site 7 Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum 375 390X San Carlos St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2007 12:00:00 AM 4 3x3 Permit Number 49903 6006735.54842487 2103815.93628153 37.7570585841288 -122.419705571484 (37.7570585841288, -122.419705571484) 2 4 7 28859 19
144441 82357 Permitted Site 7 Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum 375 390X San Carlos St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2007 12:00:00 AM 4 3x3 Permit Number 49903 6006735.54842487 2103815.93628153 37.7570585841288 -122.419705571484 (37.7570585841288, -122.419705571484) 2 4 7 28859 19
147964 33845 Permitted Site 7 Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum 375 790 Pennsylvania Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2013 12:00:00 AM     Permit Number 767208 6014420.16934645 2103447.5968517 37.7564770950936 -122.39310324452 (37.7564770950936, -122.39310324452) 10 3 8 28856 29
159981 77117 Permitted Site 7 Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum 375 790 Pennsylvania Ave 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2013 12:00:00 AM     Permit Number 767208 6014420.16934645 2103447.5968517 37.7564770950936 -122.39310324452 (37.7564770950936, -122.39310324452) 10 3 8 28856 29
178740 82356 Permitted Site 7 Liquidambar styraciflua 'Palo Alto' :: Palo Alto Sweet Gum 375 390X San Carlos St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2007 12:00:00 AM 4 3x3 Permit Number 49903 6006735.54842487 2103815.93628153 37.7570585841288 -122.419705571484 (37.7570585841288, -122.419705571484) 2 4 7 28859 19
153491 53978 Permitted Site 7 Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 373 306 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2016 12:00:00 AM 3   Permit Number 777378 5992338.18292859 2094872.36081759 37.7316802632484 -122.468845903285 (37.7316802632484, -122.468845903285) 9 8 4 59 40
133606 100571 Permitted Site 7 Prunus laurocerasus :: English laurel 371 20 Landers St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2014 12:00:00 AM   3x3 Permit Number 770316 6004449 2107658 37.7674789047962 -122.427887091326 (37.7674789047962, -122.427887091326) 8 4 5 28862 3
20578 44813 Permitted Site 7 Hakea laurina :: Sea Urchin Tree 370 2700x Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2001 12:00:00 AM     Permit Number 43905 5986474 2105095 37.7594083467555 -122.489870843925 (37.7594083467555, -122.489870843925) 1 8 3 56 35
53158 52072 Permitted Site 7 Hakea laurina :: Sea Urchin Tree 370 1180 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2008 12:00:00 AM   3x3 Permit Number 48266 6007369.565674 2118849.33698482 37.7983723881125 -122.418578912423 (37.7983723881125, -122.418578912423) 5 1 10 28858 32
89220 44812 Permitted Site 7 Hakea laurina :: Sea Urchin Tree 370 2700x Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2001 12:00:00 AM     Permit Number 43905 5986474 2105095 37.7594083467555 -122.489870843925 (37.7594083467555, -122.489870843925) 1 8 3 56 35
121630 45680 Permitted Site 7 Hakea laurina :: Sea Urchin Tree 370 215 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/18/2001 12:00:00 AM     Permit Number 44367 6004811.33845947 2097114.51665019 37.7385494492977 -122.425883220193 (37.7385494492977, -122.425883220193) 2 7 5 63 7
181636 34948 Permitted Site 7 Hakea laurina :: Sea Urchin Tree 370 2746 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/1997 12:00:00 AM     Permit Number 38546 5984041.36569537 2096474.98661901 37.7355978151008 -122.497647503936 (37.7355978151008, -122.497647503936) 1 8 3 29491 35
43215 38429 Permitted Site 7 Sambucus mexicana :: Blue Elderberry 367 1000X Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/18/1998 12:00:00 AM       6012766 2102838 37.7547112450133 -122.398781204994 (37.7547112450133, -122.398781204994) 10 3 8 28856 29
63109 95699 Permitted Site 7 Malus floribunda 'Prairie Fire' :: Prairie Fire Crabapple Tree 366 101 Arbor St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/2011 12:00:00 AM   3x3 Permit Number 767450 6001805 2096722 37.737301333655 -122.436249595043 (37.737301333655, -122.436249595043) 2 7 5 63 7
74486 95698 Permitted Site 7 Malus floribunda 'Prairie Fire' :: Prairie Fire Crabapple Tree 366 101 Arbor St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/2011 12:00:00 AM   3x3 Permit Number 767450 6001805 2096722 37.737301333655 -122.436249595043 (37.737301333655, -122.436249595043) 2 7 5 63 7
81490 95696 Permitted Site 7 Malus floribunda 'Prairie Fire' :: Prairie Fire Crabapple Tree 366 101 Arbor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/2011 12:00:00 AM   3x3 Permit Number 767450 6001805 2096722 37.737301333655 -122.436249595043 (37.737301333655, -122.436249595043) 2 7 5 63 7
157618 95697 Permitted Site 7 Malus floribunda 'Prairie Fire' :: Prairie Fire Crabapple Tree 366 101 Arbor St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/2011 12:00:00 AM   3x3 Permit Number 767450 6001805 2096722 37.737301333655 -122.436249595043 (37.737301333655, -122.436249595043) 2 7 5 63 7
63756 93549 Permitted Site 7 Betula nigra :: River Birch 361 729 Congo St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/2010 12:00:00 AM 12 3x3 Permit Number 53245 6000222 2096067 37.7354127885514 -122.441675748683 (37.7354127885514, -122.441675748683) 9 7 4 63 40
14958 46361 Permitted Site 7 Populus canadensis :: Canadian Poplar 359 160 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2002 12:00:00 AM     Permit Number 44599 6015543.16497343 2115073.84916298 37.7884625396437 -122.390031641839 (37.7884625396437, -122.390031641839) 6 2 9 28855 6
132550 52841 Permitted Site 7 Populus canadensis :: Canadian Poplar 359 2600@ PIERCE Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/22/2006 12:00:00 AM     Permit Number 48859 6001694.15234168 2117006.51478628 37.7929913285029 -122.438085457515 (37.7929913285029, -122.438085457515) 13 6 1 29490 27
164934 48732 Permitted Site 7 Populus canadensis :: Canadian Poplar 359 1840 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/24/2002 12:00:00 AM     Permit Number 46012 6001561.51478574 2114750.36064197 37.7867889680887 -122.438382676367 (37.7867889680887, -122.438382676367) 13 6 11 29490 27
189879 50176 Permitted Site 7 Populus canadensis :: Canadian Poplar 359 1400 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2003 12:00:00 AM     Permit Number 46885 5993138.94338431 2097622.37512786 37.7392773470465 -122.46627731988 (37.7392773470465, -122.46627731988) 1 8 4 59 40
168932 101806 Permitted Site 7 Eucalyptus pulverulenta :: Silver Mountain Gum Tree 357 733 Treat Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 19463 6008567.7 2104253 37.7583616995478 -122.413400180344 (37.7583616995478, -122.413400180344) 2 4 7 28859 19
25677 26621 Permitted Site 7 Ulmus 'Prospector' :: Prospector Elm 354 1287 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   01/15/1998 12:00:00 AM 6 3X3   6011580.6766762 2093245.3904793 37.7283058730155 -122.402206012046 (37.7283058730155, -122.402206012046) 10 3 8 58 1
26370 26622 Permitted Site 7 Ulmus 'Prospector' :: Prospector Elm 354 1287 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   01/15/1998 12:00:00 AM 6 3X3   6011580.6766762 2093245.3904793 37.7283058730155 -122.402206012046 (37.7283058730155, -122.402206012046) 10 3 8 58 1
40690 26592 Permitted Site 7 Ulmus 'Prospector' :: Prospector Elm 354 1641 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/1998 12:00:00 AM 6 3X3   6012044.29404 2091348.95121 37.723124507518 -122.400470100871 (37.723124507518, -122.400470100871) 10 3 8 58 1
88560 26620 Permitted Site 7 Ulmus 'Prospector' :: Prospector Elm 354 1291 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   01/15/1998 12:00:00 AM 6 3X3   6011586.2312153 2093228.0893826 37.728258677836 -122.402185593782 (37.728258677836, -122.402185593782) 10 3 8 58 1
101599 26597 Permitted Site 7 Ulmus 'Prospector' :: Prospector Elm 354 1587 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   01/08/1998 12:00:00 AM 6 3X3   6011950.6493597 2091636.7727547 37.723909583861 -122.400814025253 (37.723909583861, -122.400814025253) 10 3 8 58 1
111803 26627 Permitted Site 7 Ulmus 'Prospector' :: Prospector Elm 354 1175 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/1998 12:00:00 AM 10 3X3   6011420.37467 2093734.24789 37.7296392246522 -122.402794552619 (37.7296392246522, -122.402794552619) 10 3 8 58 1

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