home / trees

Street_Tree_List

Data source: data.sfgov.org

148 rows where qSpecies = 46

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
190 100189 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 160 Palm Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3 Permit Number 772698 5995944.7835 2113256.71049 37.782366726791295 -122.457707006716 (37.7823667267913, -122.457707006716) 11 6 1 54 31
334 100348 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 622 Connecticut St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/07/2012 12:00:00 AM 1 8x10 Permit Number 769139 6013248.11312 2104189.7017900003 37.758449574805105 -122.397208694044 (37.7584495748051, -122.397208694044) 10 3 8 28856 29
1787 102067 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 24 Coso Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM 3 3x3 Permit Number 769727 6007035.7 2099866.2 37.7462304116746 -122.418387482558 (37.7462304116746, -122.418387482558) 2 7 7 28859 2
1877 102166 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 627 Castro St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769759 6002435.1 2104542.4 37.7588100889329 -122.434630086253 (37.7588100889329, -122.434630086253) 2 4 5 28862 3
2449 102762 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 100X Russ St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/26/2013 12:00:00 AM 3 3x3 Permit Number 54619 6010215.5 2111581.3 37.7785759102049 -122.40821818771099 (37.7785759102049, -122.408218187711) 14 2 9 28853 34
2483 102795 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 873 De Haro St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/28/2013 12:00:00 AM 2 3x3 Permit Number 770021 6012177.73114 2104340.1615400002 37.758803056042 -122.400921145798 (37.758803056042, -122.400921145798) 10 3 8 28856 29
3057 103423 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 131 Arkansas St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/28/2015 12:00:00 AM 1 3x3 Permit Number 770059 6012899.886519999 2106401.44605 37.7645031444165 -122.398568227055 (37.7645031444165, -122.398568227055) 14 3 8 28856 29
4678 105297 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 15 Karen Ct 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/01/2015 12:00:00 AM 18 3x3 Permit Number 774558 6010447.0 2091541.0 37.7235626269277 -122.406005180928 (37.7235626269277, -122.406005180928) 10 3 7 309 28
5874 106764 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 2900x Buchanan St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/27/2018 12:00:00 AM 3   Permit Number 781463 6003486.1984 2118369.16676 37.796834572421396 -122.431982232797 (37.7968345724214, -122.431982232797) 13 9 1 57 17
6304 107300 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 333 Harrison St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/19/2014 12:00:00 AM     Permit Number 767149 6015127.71951 2114620.09555 37.7871935864977 -122.39143729580799 (37.7871935864977, -122.391437295808) 6 2 9 28855 6
6305 107301 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 333 Harrison St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/19/2014 12:00:00 AM     Permit Number 767149 6015127.71951 2114620.09555 37.7871935864977 -122.39143729580799 (37.7871935864977, -122.391437295808) 6 2 9 28855 6
6306 107302 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 333 Harrison St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/19/2014 12:00:00 AM     Permit Number 767149 6015127.71951 2114620.09555 37.7871935864977 -122.39143729580799 (37.7871935864977, -122.391437295808) 6 2 9 28855 6
7147 108264 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 400x ELIZABETH ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/16/2015 12:00:00 AM 3 4x5 Permit Number 774411 6003752.0 2102232.0 37.7525409491736 -122.429910836031 (37.7525409491736, -122.429910836031) 2 4 5 28862 22
7546 108659 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 233 Clayton St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774611 5998294.8298 2109868.31432 37.773197790362 -122.449332713458 (37.773197790362, -122.449332713458) 15 5 11 29492 16
8782 110035 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 160 Shrader St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/19/2015 12:00:00 AM 3   Permit Number 775209 5997364.1 2109993.9 37.77348933368629 -122.45256127909599 (37.7734893336863, -122.452561279096) 15 5 11 29492 16
12903 114643 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 609 Precita Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/30/2015 12:00:00 AM     Permit Number 774764 6009663.9 2100372.9 37.7477692975566 -122.40933520293899 (37.7477692975566, -122.409335202939) 2 7 7 28859 2
13387 115164 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 112 Clifford Ter 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/14/2016 12:00:00 AM     Permit Number 775244 5999576.0 2106584.4 37.7642541893967 -122.444664912175 (37.7642541893967, -122.444664912175) 15 5 5 29492 9
13388 115165 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 402 Belvedere St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/14/2016 12:00:00 AM     Permit Number 775277 5998511.59251 2106738.31574 37.7646160064689 -122.448357464082 (37.7646160064689, -122.448357464082) 15 5 11 29492 9
13389 115166 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 402 Belvedere St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/14/2016 12:00:00 AM     Permit Number 775277 5998511.59251 2106738.31574 37.7646160064689 -122.448357464082 (37.7646160064689, -122.448357464082) 15 5 11 29492 9
13637 115402 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 218 Richland Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Port 10   01/29/2016 12:00:00 AM 3   Permit Number 776284 6005779.9 2096086.1 37.7357803359495 -122.42246134044301 (37.7357803359495, -122.422461340443) 2 7 7 28859 2
48634 177450 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 655 Goettingen St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 Width 4ft   6010679.56487 2091598.96237 37.7237347842164 -122.40520532088699 (37.7237347842164, -122.405205320887) 10 3 7 309 28
54746 18369 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 635 Potrero Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   05/02/2016 12:00:00 AM 3 4X4   6010448.75923 2105261.1592 37.761235313885706 -122.406965672731 (37.7612353138857, -122.406965672731) 10 4 8 28859 19
54843 18378 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 732 Potrero Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   07/31/2012 12:00:00 AM 3 3x3   6010381.26044 2104876.29383 37.760174782967404 -122.407171993386 (37.7601747829674, -122.407171993386) 10 4 8 28859 19
54854 18379 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 744 Potrero Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/02/2005 12:00:00 AM 3 3X4   6010385.6799800005 2104816.8587 37.7600118348065 -122.40715251859301 (37.7600118348065, -122.407152518593) 10 4 8 28859 19
54963 18389 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 852 Potrero Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/02/2005 12:00:00 AM 3 3x3   6010416.63719 2104254.1287700003 37.7584684371764 -122.407005787885 (37.7584684371764, -122.407005787885) 10 4 7 28859 19
55290 18419 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 645X POTRERO AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/02/2005 12:00:00 AM 3 3X3   6010440.0 2105310.0 37.7613689295586 -122.40699940993099 (37.7613689295586, -122.406999409931) 10 4 8 28859 19
55915 18477 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1290 Potrero Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   01/11/1991 12:00:00 AM 18 3x3   6010548.57225 2101900.54788 37.752013409302705 -122.406383660293 (37.7520134093027, -122.406383660293) 10 4 7 28859 19
55936 18479 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1290 Potrero Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   01/11/1991 12:00:00 AM 18 3x3   6010549.62955 2101874.40132 37.75194167576571 -122.40637816183799 (37.7519416757657, -122.406378161838) 10 4 7 28859 19
64984 193378 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1301 Minnesota St 40 Front Yard : Yard 4 Tree 1 Private 2     3     6015354.84712 2102508.01149 37.7539490714005 -122.38980514398999 (37.7539490714005, -122.38980514399) 10 3 8 28856 29
64985 193379 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 500 Wisconsin St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     11 Width 9ft   6012632.72668 2105144.08354 37.7610358181789 -122.39940398859699 (37.7610358181789, -122.399403988597) 10 3 8 28856 29
64987 193380 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 572 Wisconsin St 8 Sidewalk: Property side : Yard 5 Tree 1 Private 2     12 Width 7ft   6012652.42015 2104742.48091 37.7599342035261 -122.399307683824 (37.7599342035261, -122.399307683824) 10 3 8 28856 29
64988 193381 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1800 20th St 7 Sidewalk: Property side : Yard 5 Tree 1 Private 2     4 Width 5ft   6012498.39561 2104730.49879 37.7598927177809 -122.399839541976 (37.7598927177809, -122.399839541976) 10 3 8 28856 29
64989 193382 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1800 20th St 8 Sidewalk: Property side : Yard 5 Tree 1 Private 2     5 Width 5ft   6012480.76033 2104730.48315 37.7598916916751 -122.39990053310801 (37.7598916916751, -122.399900533108) 10 3 8 28856 29
64990 193383 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1701 19th St 5 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     7 Width 4ft   6012488.23279 2105143.9346 37.7610273546478 -122.39990372297599 (37.7610273546478, -122.399903722976) 10 3 8 28856 29
64991 193384 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1701 19th St 7 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     7 Width 4ft   6012512.334919999 2105144.43798 37.7610300804989 -122.399820398993 (37.7610300804989, -122.399820398993) 10 3 8 28856 29
64992 193385 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1701 19th St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 Width 3ft   6012546.6255 2105147.54735 37.7610405297218 -122.399702020336 (37.7610405297218, -122.399702020336) 10 3 8 28856 29
64993 193386 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1701 19th St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 Width 3ft   6012561.08135 2105147.5846700002 37.7610414380218 -122.399652026121 (37.7610414380218, -122.399652026121) 10 3 8 28856 29
64994 193387 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 951 Vermont St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 1ft   6011465.45541 2103904.70895 37.757567642937495 -122.403353904557 (37.7575676429375, -122.403353904557) 10 3 8 28856 29
64995 193388 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 199 Missouri St 1 : 14 Tree 1 Private 2     5 Width 3ft   6013472.83799 2106235.0928700003 37.7640782786103 -122.39657486803699 (37.7640782786103, -122.396574868037) 14 3 8 28856 29
64996 193389 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 357 Missouri St 1 : 14 Tree 1 Private 2     12 Width 6ft   6013519.95695 2105414.95396 37.7618289797317 -122.39635440822701 (37.7618289797317, -122.396354408227) 10 3 8 28856 29
64998 193390 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 1 : 14 Tree 1 Private 2     2 Width 3ft   6012604.40245 2099978.37692 37.7468503321847 -122.399139341508 (37.7468503321847, -122.399139341508) 10 3 8 58 1
64999 193391 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 2 : 14 Tree 1 Private 2     3 Width 3ft   6012620.26773 2099985.30508 37.7468702395635 -122.39908496672399 (37.7468702395635, -122.399084966724) 10 3 8 58 1
65000 193392 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 3 : 14 Tree 1 Private 2     3 Width 3ft   6012636.8219800005 2099992.72138 37.746891525638205 -122.399028243757 (37.7468915256382, -122.399028243757) 10 3 8 58 1
65001 193393 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 4 : 14 Tree 1 Private 2     3 Width 3ft   6012653.35348 2099999.0304400004 37.7469097701736 -122.398971521724 (37.7469097701736, -122.398971521724) 10 3 8 58 1
65002 193394 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 5 : 14 Tree 1 Private 2     3 Width 3ft   6012734.79399 2100018.46405 37.7469676685241 -122.39869126958901 (37.7469676685241, -122.398691269589) 10 3 8 58 1
65003 193395 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 6 : 14 Tree 1 Private 2     3 Width 3ft   6012753.0318599995 2100019.72606 37.746972149844396 -122.39862829278098 (37.7469721498444, -122.398628292781) 10 3 8 58 1
65004 193396 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 7 : 14 Tree 1 Private 2     3 Width 3ft   6012770.52712 2100020.27801 37.7469746400861 -122.398567834043 (37.7469746400861, -122.398567834043) 10 3 8 58 1
65005 193397 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 8 : 14 Tree 1 Private 2     3 Width 3ft   6012788.95459 2100021.89909 37.74698011783261 -122.398504226789 (37.7469801178326, -122.398504226789) 10 3 8 58 1
65006 193398 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 9 : 14 Tree 1 Private 2     4 Width 3ft   6012806.99945 2100022.62103 37.7469831053839 -122.39844187948601 (37.7469831053839, -122.398441879486) 10 3 8 58 1
65007 193399 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 10 : 14 Tree 1 Private 2     3 Width 3ft   6012824.86969 2100023.70943 37.746987089395795 -122.398380161711 (37.7469870893958, -122.398380161711) 10 3 8 58 1
65009 193400 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 11 : 14 Tree 1 Private 2     4 Width 3ft   6012842.918219999 2100024.61277 37.7469905751716 -122.398317814431 (37.7469905751716, -122.398317814431) 10 3 8 58 1
65010 193401 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 12 : 14 Tree 1 Private 2     3 Width 3ft   6012860.78478 2100025.51981 37.7469940609376 -122.39825609664601 (37.7469940609376, -122.398256096646) 10 3 8 58 1
65011 193402 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 13 : 14 Tree 1 Private 2     3 Width 3ft   6012879.019230001 2100026.60085 37.74699804493 -122.398193118921 (37.74699804493, -122.398193118921) 10 3 8 58 1
65012 193403 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 14 : 14 Tree 1 Private 2     2 Width 3ft   6012896.33959 2100027.519 37.7470015307137 -122.398133290628 (37.7470015307137, -122.398133290628) 10 3 8 58 1
65013 193404 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 15 : 14 Tree 1 Private 2     3 Width 3ft   6012914.94166 2100028.77373 37.7470060120314 -122.39806905386601 (37.7470060120314, -122.398069053866) 10 3 8 58 1
65014 193405 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 151 Napoleon St 16 : 14 Tree 1 Private 2     3 Width 3ft   6012932.62256 2100029.50346 37.747009000471394 -122.39800796562099 (37.7470090004714, -122.398007965621) 10 3 8 58 1
97826 226514 Planning Code 138.1 required 8 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1225 Dolores St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/10/2018 12:00:00 AM 3 3x3 Permit Number 781565 6005204.64951 2101211.3969900003 37.7498207677153 -122.42481471974101 (37.7498207677153, -122.424814719741) 2 4 5 28859 19
101970 230358 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 48 Pearl St 1 : 14 Tree 1 Private 2     6 Width 3ft   6005612.30306 2108731.67387 37.770492697607295 -122.423939735133 (37.7704926976073, -122.423939735133) 8 2 5 28853 19
101971 230359 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 74 Pearl St 1 : 14 Tree 1 Private 2     5 Width 4ft   6005616.74873 2108631.0205599996 37.7702165787549 -122.42391719903401 (37.7702165787549, -122.423917199034) 8 2 5 28853 19
101973 230360 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 9 Scott St 1 : 14 Tree 1 Private 2     5 Width 3ft   6002397.510369999 2108386.59466 37.7693631769914 -122.435035024651 (37.7693631769914, -122.435035024651) 15 5 5 29492 9
101974 230361 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1294 Potrero Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 3ft   6010548.423769999 2101854.23832 37.7518862451648 -122.406380911045 (37.7518862451648, -122.406380911045) 10 4 7 28859 19
101975 230362 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1294 Potrero Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 3ft   6010552.21638 2101806.26487 37.7517547328158 -122.40636441569299 (37.7517547328158, -122.406364415693) 10 4 7 28859 19
101976 230363 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 995 Potrero Ave 15 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 Width 3ft   6010489.275669999 2104457.6140400004 37.7590312266388 -122.40676891097799 (37.7590312266388, -122.406768910978) 10 4 8 28859 19
101977 230364 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1384 Florida St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 Width 3ft   6009527.682130001 2101137.2789 37.74986047997471 -122.40986018842199 (37.7498604799747, -122.409860188422) 2 4 7 28859 19
101978 230365 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 398 Dolores St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 7ft   6004848.8503 2106072.66034 37.7631485531897 -122.426391171909 (37.7631485531897, -122.426391171909) 8 4 5 28859 3
101979 230366 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 62 Tiffany Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 7ft   6006279.39712 2099668.2568099997 37.7456443008565 -122.420988637738 (37.7456443008565, -122.420988637738) 2 7 5 28859 2
101980 230367 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 66 Tiffany Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 Width 6ft   6006268.47063 2099645.39127 37.7455809013368 -122.421024796751 (37.7455809013368, -122.421024796751) 2 7 5 28859 2
101981 230368 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 11 Fair Oaks St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6005387.30117 2103566.74796 37.7562983299305 -122.42435060570601 (37.7562983299305, -122.424350605706) 2 4 5 28859 19
101982 230369 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 11 Fair Oaks St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 Width 3ft   6005387.79794 2103576.12181 37.7563240963852 -122.424349554394 (37.7563240963852, -122.424349554394) 2 4 5 28859 19
101984 230370 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1298 Vermont St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 6ft   6011381.02251 2102414.42534 37.753470936941596 -122.40354106069401 (37.7534709369416, -122.403541060694) 10 4 8 28859 19
101985 230371 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1298 Vermont St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 6ft   6011383.11883 2102397.34825 37.753424164099 -122.403532609747 (37.753424164099, -122.403532609747) 10 4 8 28859 19
101986 230372 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1248 Utah St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 Width 3ft   6010819.236769999 2102490.41358 37.7536481879148 -122.405489197274 (37.7536481879148, -122.405489197274) 10 4 8 28859 19
101987 230373 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1731 15th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 Width 3ft   6005847.40501 2107246.03161 37.7664267484281 -122.423020905012 (37.7664267484281, -122.423020905012) 8 4 5 28853 19
101988 230374 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 725 Treat Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 Width 4ft   6008540.74616 2104312.6152 37.7585238758885 -122.413497615138 (37.7585238758885, -122.413497615138) 2 4 7 28859 19
123573 253209 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1129 Naples St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/15/2019 12:00:00 AM 3 3x3 Permit Number 782482 6001432.0 2087854.0 37.712930619101 -122.43690455890899 (37.712930619101, -122.436904558909) 9 7 6 28861 5
124594 254691 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1207 30th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/20/2018 12:00:00 AM 3 3x3 Permit Number 778150 5986738.32849 2107038.6996299997 37.7647606402542 -122.489099576399 (37.7647606402542, -122.489099576399) 1 8 3 56 35
125298 255711 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 280 32nd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/29/2018 12:00:00 AM 3 3x3 Permit Number 782096 5985913.43206 2114030.51387 37.7839099959026 -122.49246757201401 (37.7839099959026, -122.492467572014) 11 6 1 55 33
128784 28124 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 112 Arguello Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/02/2004 12:00:00 AM 3 3X3   5995536.80725 2115362.80117 37.7881260406124 -122.45927097722901 (37.7881260406124, -122.459270977229) 11 6 1 54 31
130538 2990 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 2266X California St 5 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     18 3X3   6003475.85532 2115607.4866 37.7892511192874 -122.43182073435601 (37.7892511192874, -122.431820734356) 13 9 1 29490 27
132156 31536 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1360 Vermont St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 05/10/1995 12:00:00 AM 11   Permit Number 35087 6011404.38341 2101989.62813 37.752305841845605 -122.40343039011101 (37.7523058418456, -122.403430390111) 10 4 8 28859 19
132157 31537 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1364 Vermont St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 06/08/2002 12:00:00 AM 8   Permit Number 35088 6011407.03261 2101949.80473 37.752196643481604 -122.403418427315 (37.7521966434816, -122.403418427315) 10 4 8 28859 19
132338 31702 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 320 Frederick St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/14/2016 12:00:00 AM 8 3x3 Permit Number 775273 5998457.5854 2107603.3505 37.766988085426505 -122.448606565306 (37.7669880854265, -122.448606565306) 15 5 11 29492 9
138303 37176 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 66 Tiffany Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/22/2010 12:00:00 AM   3x3 Permit Number 53571 6006281.21006007 2099680.48261535 37.7456779723428 -122.420983236738 (37.7456779723428, -122.420983236738) 2 7 5 28859 2
139116 37941 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 730 22nd St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/08/1998 12:00:00 AM 2   Permit Number 40183 6015640.36164 2103965.71 37.7579674311726 -122.388919522216 (37.7579674311726, -122.388919522216) 10 3 8 28856 29
140076 38835 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 254 Clement St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/03/2008 12:00:00 AM   3x3 Permit Number 50625 5994768.12752284 2113559.99820217 37.783131808317705 -122.461799686207 (37.7831318083177, -122.461799686207) 11 6 2 54 11
142360 40938 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 250 10th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52425 6008608.67126022 2109716.51836429 37.773365556377705 -122.413644912079 (37.7733655563777, -122.413644912079) 8 2 9 28853 34
148866 46979 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 1310 Minnesota St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/01/2002 12:00:00 AM 3   Permit Number 44998 6015318.4768 2102468.70414 37.753839124779205 -122.38992817666401 (37.7538391247792, -122.389928176664) 10 3 8 28856 29
154474 52186 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 117 Diamond St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/15/2009 12:00:00 AM   3x3 Permit Number 52618 6001741.54156575 2105161.20855715 37.7604697895723 -122.43707303146799 (37.7604697895723, -122.437073031468) 2 4 5 28862 3
154475 52187 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 117 Diamond St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/15/2009 12:00:00 AM   3x3 Permit Number 52618 6001741.54156575 2105161.20855715 37.7604697895723 -122.43707303146799 (37.7604697895723, -122.437073031468) 2 4 5 28862 3
155300 52956 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 478 Victoria St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/22/2010 12:00:00 AM   3x3 Permit Number 53570 5993279.13745627 2090341.45680434 37.7192938259954 -122.46526387046801 (37.7192938259954, -122.465263870468) 9 8 6 64 24
156506 5408 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 398 Dolores St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/02/2012 12:00:00 AM 5 3x3   6004847.1008 2106094.6203 37.763208751117396 -122.426398786502 (37.7632087511174, -122.426398786502) 8 4 5 28859 3
156764 5433 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 500X Dolores St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   09/27/2008 12:00:00 AM 3 6   6004888.034519999 2105376.13123 37.76123826456529 -122.42620605546301 (37.7612382645653, -122.426206055463) 2 4 5 28862 3
156775 5434 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 500X Dolores St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   04/14/2009 12:00:00 AM 3 6   6004889.66204 2105352.28361 37.7611728766429 -122.426198728713 (37.7611728766429, -122.426198728713) 2 4 5 28862 3
157051 5460 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 595 Dolores St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   10/27/2017 12:00:00 AM 3 3X3   6005000.81386 2104899.04779 37.759934680147296 -122.425782040418 (37.7599346801473, -122.425782040418) 2 4 5 28859 19
158237 55695 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 51 Santa Marina St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/2009 12:00:00 AM   3x3 Permit Number 52581 6005948.92964432 2097719.44263908 37.740274663612205 -122.421992931257 (37.7402746636122, -122.421992931257) 2 7 7 28859 2
164498 61585 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 748 Wisconsin St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 08/25/1984 12:00:00 AM 10   Permit Number 21549 6012696.34573 2104009.38799 37.7579237394054 -122.39910430751199 (37.7579237394054, -122.399104307512) 10 3 8 28856 29
167217 64113 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 155 Connecticut St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 04/28/2006 12:00:00 AM 7   Permit Number 24881 6013197.0039 2106190.5600099997 37.763940646370294 -122.397525780603 (37.7639406463703, -122.397525780603) 14 3 8 28856 29
169102 65898 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 160 Palm Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 04/16/2014 12:00:00 AM 1 3x3 Permit Number 772698 5995945.63615 2113245.27605 37.7823353798467 -122.45770322931101 (37.7823353798467, -122.457703229311) 11 6 1 54 31
169295 66075 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 381 Missouri St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/14/2008 12:00:00 AM 3 3x3 Permit Number 51883 6013523.39392 2105319.18697 37.761566215833795 -122.396335808474 (37.7615662158338, -122.396335808474) 10 3 8 28856 29
169954 66687 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 45 Carl St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/16/2008 12:00:00 AM   3x3 Permit Number 50886 5998400.68996099 2107200.48527227 37.765878666088604 -122.448774336236 (37.7658786660886, -122.448774336236) 15 5 11 29492 9

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 27.959ms · Data source: data.sfgov.org