Street_Tree_List

Data source: data.sfgov.org

1,925 rows where qSpecies = 82

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
13554 85620 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1344 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016632.8917 2093635.0593 37.729656539473 -122.384767252586 (37.729656539473, -122.384767252586)
13600 85619 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1338 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016653.5768 2093624.593 37.729628945087704 -122.384695012523 (37.7296289450877, -122.384695012523)
13802 85643 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1235 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6017171.4256 2093155.5219 37.7283695937915 -122.38287210620199 (37.7283695937915, -122.382872106202)
13898 30637 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1690 Folsom St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008025.7883 2108500.0528 37.7699926802506 -122.415575048334 (37.7699926802506, -122.415575048334)
13961 85647 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1351 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016557.1838 2093613.7118 37.7295937360014 -122.385027498588 (37.7295937360014, -122.385027498588)
13999 10614 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 37 Hawkins Ln 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/15/2001 12:00:00 AM 3 3X3   6016916.49156 2095577.9947400002 37.7350071358711 -122.383922043589 (37.7350071358711, -122.383922043589)
14061 24180 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 101X Whitney Young Cir 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3x3   6016621.33395 2095295.74377 37.7342158098126 -122.384922860422 (37.7342158098126, -122.384922860422)
14063 30634 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1690 Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008069.1402 2108631.1108 37.770354971481794 -122.415434374116 (37.7703549714818, -122.415434374116)
14099 11466 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 39X Hawkins Ln 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/1992 12:00:00 AM 3 3X3   6016784.967569999 2095560.66167 37.73495227093311 -122.384375566285 (37.7349522709331, -122.384375566285)
14120 85653 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1541 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6015555.708 2094360.5338 37.731588912651404 -122.388541843069 (37.7315889126514, -122.388541843069)
14131 85613 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1190 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6017458.1534 2093022.4369 37.728020006278 -122.38187161186 (37.728020006278, -122.38187161186)
14147 11467 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 39X Hawkins Ln 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/1992 12:00:00 AM 8 3X3   6016799.4589 2095596.1573400002 37.7350505362442 -122.384327935502 (37.7350505362442, -122.384327935502)
14162 85622 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1360 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016552.9396 2093696.0654 37.729819627930105 -122.385047906896 (37.7298196279301, -122.385047906896)
14204 85646 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1321 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016609.4363 2093572.233 37.7294827335965 -122.38484396608999 (37.7294827335965, -122.38484396609)
14210 11472 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 39X Hawkins Ln 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 3X3   6016881.34744 2095602.56066 37.7350726460825 -122.384045260583 (37.7350726460825, -122.384045260583)
14222 16526 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 375 Newhall St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/03/1992 12:00:00 AM 3 3X3   6016351.58796 2098272.95822 37.7423757148758 -122.386062939968 (37.7423757148758, -122.386062939968)
14255 85641 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1215 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6017274.7558 2093081.4055 37.72817179324429 -122.382509730509 (37.7281717932443, -122.382509730509)
14406 120561 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 245 Mississippi St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3   6014054.5814 2105863.37396 37.7630899785332 -122.394536741704 (37.7630899785332, -122.394536741704)
14424 6845 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 595X Newhall St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/16/1992 12:00:00 AM 6 3x3   6015936.9719 2097716.00593 37.7408234823092 -122.38745772460899 (37.7408234823092, -122.387457724609)
14505 85632 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1582 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6015365.5421 2094575.4322 37.7321684400373 -122.38921428964 (37.7321684400373, -122.38921428964)
14570 16549 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 400X Newhall St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6015994.10911 2097882.11034 37.7412827355083 -122.38727174751001 (37.7412827355083, -122.38727174751)
14632 85652 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1519 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6015655.7374 2094284.1377 37.7313846871586 -122.388190689138 (37.7313846871586, -122.388190689138)
14634 24178 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 101X Whitney Young Cir 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/15/2001 12:00:00 AM 4 4x3   6016619.186290001 2095310.93644 37.7342574070589 -122.384931343733 (37.7342574070589, -122.384931343733)
14701 11464 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 12 Jakey Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/22/1992 12:00:00 AM 6 3X3   6016788.858519999 2095545.6720200002 37.734911327499205 -122.384361070118 (37.7349113274992, -122.384361070118)
14774 85650 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1419 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016182.7975 2093891.6734 37.730336247224706 -122.386341174586 (37.7303362472247, -122.386341174586)
14845 30632 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1690 Folsom St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008058.1142 2108604.0472 37.770280041456104 -122.415470596847 (37.7702800414561, -122.415470596847)
14882 85659 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1623 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6015103.6745 2094694.6627 37.7324813021879 -122.390127958436 (37.7324813021879, -122.390127958436)
14888 24090 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 125X Whitney Young Cir 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/07/1997 12:00:00 AM 6 3x3   6016342.364159999 2095991.2568 37.736110114791 -122.3859358217 (37.736110114791, -122.3859358217)
14904 24147 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 100X Whitney Young Cir 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6016689.05107 2095205.54183 37.7339718785836 -122.384682457242 (37.7339718785836, -122.384682457242)
14937 16560 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 702X Newhall St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/03/1992 12:00:00 AM 12 3X3   6015615.61867 2097370.07413 37.7398558207833 -122.38854471268299 (37.7398558207833, -122.388544712683)
14960 85627 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1466 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6015977.8277 2094121.4228 37.730955745426606 -122.387065808076 (37.7309557454266, -122.387065808076)
15002 85644 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1275 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016975.0441 2093297.8038 37.728749419657 -122.383560914081 (37.728749419657, -122.383560914081)
15012 85551 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 288 12th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/29/2007 12:00:00 AM 3     6008109.65239 2108844.36385 37.7709427912139 -122.41530934075199 (37.7709427912139, -122.415309340752)
15041 24179 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 101X Whitney Young Cir 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/29/1990 12:00:00 AM 12 5x3   6016625.58798 2095312.02915 37.7342607615082 -122.38490928693199 (37.7342607615082, -122.384909286932)
15047 30638 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1690 Folsom St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008054.606000001 2108589.5131 37.7702399370436 -122.415481702601 (37.7702399370436, -122.415481702601)
15074 11468 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 39X Hawkins Ln 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/1992 12:00:00 AM 6 3X3   6016817.53474 2095601.45988 37.735066095427705 -122.384265809434 (37.7350660954277, -122.384265809434)
15083 30628 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1690 Folsom St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008014.7624 2108466.4739 37.769899860698295 -122.415610809035 (37.7698998606983, -122.415610809035)
15141 81729 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1200 Indiana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/06/2012 12:00:00 AM 5 3x3 Permit Number 768902 6015012.434719999 2102924.7634900003 37.7550743894922 -122.391018422974 (37.7550743894922, -122.391018422974)
15196 85648 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1357 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016534.0204 2093632.0271 37.7296427448929 -122.38510885322701 (37.7296427448929, -122.385108853227)
15328 85611 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1150 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6017700.249 2092841.4739 37.7275364831055 -122.381022095395 (37.7275364831055, -122.381022095395)
15334 30635 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1690 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008075.6555 2108643.1391 37.770388364567104 -122.41541268929899 (37.7703883645671, -122.415412689299)
15354 30627 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1690 Folsom St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008040.0718 2108546.913 37.770122150229 -122.41552895995899 (37.770122150229, -122.415528959959)
15360 85624 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1422 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016199.7661 2093954.969 37.7305109836044 -122.38628692243 (37.7305109836044, -122.38628692243)
15393 11470 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 39X Hawkins Ln 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X3   6016849.3995 2095607.3792400002 37.7350841106266 -122.38415605258001 (37.7350841106266, -122.38415605258)
15458 85621 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1356 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016575.2959 2093679.014 37.7297740447744 -122.38496943038601 (37.7297740447744, -122.384969430386)
15489 30626 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1690 Folsom St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/24/2016 12:00:00 AM 3 3x3 Permit Number 769481 6008034.8095 2108530.1235 37.7700757544141 -122.415545973379 (37.7700757544141, -122.415545973379)
15537 85657 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1651 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6014964.3549 2094799.3159999999 37.7327609307407 -122.39061693379999 (37.7327609307407, -122.3906169338)
15644 16542 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 400X Newhall St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6016097.47551 2098025.0219 37.741680865376 -122.386924304309 (37.741680865376, -122.386924304309)
15649 85651 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1467 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6015942.8131 2094070.7863 37.730814768733396 -122.387183329829 (37.7308147687334, -122.387183329829)
15797 101777 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 1700 Yosemite Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   6014038.07825 2093123.5904299999 37.72810829704029 -122.39370208181101 (37.7281082970403, -122.393702081811)
15814 85630 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1518 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6015608.4708 2094395.709 37.7316884205401 -122.388361884277 (37.7316884205401, -122.388361884277)
15847 11469 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 39X Hawkins Ln 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/1992 12:00:00 AM 9 3X3   6016835.012019999 2095606.77415 37.735081653692 -122.38420575361401 (37.735081653692, -122.384205753614)
15931 85649 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1399 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016350.3286 2093764.5437 37.7299964462298 -122.385753133703 (37.7299964462298, -122.385753133703)
15934 85623 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1404 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016275.7207 2093898.407 37.7303598794973 -122.38602039250401 (37.7303598794973, -122.386020392504)
15981 16561 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 702X Newhall St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/11/2006 12:00:00 AM 3 3X3   6015590.528940001 2097333.28077 37.739753403296206 -122.388628895503 (37.7397534032962, -122.388628895503)
16006 11463 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 12 Jakey Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/22/1992 12:00:00 AM 6 3X3   6016797.65257 2095521.33822 37.7348449980066 -122.384328971504 (37.7348449980066, -122.384328971504)
16023 30631 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1690 Folsom St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008010.753 2108447.9304 37.769848719225294 -122.415623364383 (37.7698487192253, -122.415623364383)
16109 85626 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1454 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016038.1604 2094077.7893 37.7308392772335 -122.38685418415001 (37.7308392772335, -122.38685418415)
16244 85633 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1590 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6015320.4739 2094608.4089 37.732256488847106 -122.38937240380899 (37.7322564888471, -122.389372403809)
16295 27141 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1775 Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X3   6011398.088769999 2095346.30396 37.7340643486912 -122.402984937921 (37.7340643486912, -122.402984937921)
16358 85616 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1258 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6017082.7023 2093297.2628 37.7287538840188 -122.383188691469 (37.7287538840188, -122.383188691469)
16359 30629 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1690 Folsom St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008019.272999999 2108482.0104 37.7699427738264 -122.415596307092 (37.7699427738264, -122.415596307092)
16412 30636 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1690 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2004 12:00:00 AM 3 3x3 Permit Number 47466 6008078.6625 2108652.1603 37.770413303673394 -122.4154029268 (37.7704133036734, -122.4154029268)
16510 85610 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1132 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6017745.1516 2092811.7191 37.727457260594704 -122.38086479752899 (37.7274572605947, -122.380864797529)
16538 85640 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1201X Quesada Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6017322.9044 2093043.5358 37.7280704700942 -122.382340643729 (37.7280704700942, -122.382340643729)
16542 6847 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 595X Newhall St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/11/2002 12:00:00 AM 3 3x3   6015962.97666 2097752.7883599997 37.7409259196071 -122.38737037433701 (37.7409259196071, -122.387370374337)
16554 85618 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1314 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016773.2527 2093530.9730000002 37.729378500955896 -122.384274758873 (37.7293785009559, -122.384274758873)
16579 85638 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1201X Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6017293.1497 2093067.8806 37.728135672587904 -122.382445200849 (37.7281356725879, -122.382445200849)
16642 85639 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1201X Quesada Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6017307.7565 2093058.1427 37.7281097410693 -122.382394026885 (37.7281097410693, -122.382394026885)
16831 16544 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 400X Newhall St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6016074.6462900005 2097992.47705 37.7415902397879 -122.38700097152399 (37.7415902397879, -122.387000971524)
16855 85645 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1313 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/30/2007 12:00:00 AM 3 3x3   6016677.8494 2093524.29 37.7293548752151 -122.384604114815 (37.7293548752151, -122.384604114815)
16955 15610 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 3350 Mission St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/18/1995 12:00:00 AM 3 3x3   6006029.1794 2098644.8095 37.742820038399 -122.421781171739 (37.742820038399, -122.421781171739)
17097 15580 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 3159 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/26/1998 12:00:00 AM 6 3X3   6006815.4591 2099977.9757 37.746524922000205 -122.41915697739401 (37.7465249220002, -122.419156977394)
17233 16673 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 244 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6002873.2969 2106860.8212200003 37.7652007800214 -122.43328026297701 (37.7652007800214, -122.433280262977)
17348 4322 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 752 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6002136.242880001 2095781.1252 37.7347367232032 -122.435037065224 (37.7347367232032, -122.435037065224)
17662 4223 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 3975 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6004059.37365 2100401.32602 37.7475317476004 -122.428717394312 (37.7475317476004, -122.428717394312)
17704 15609 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 3350 Mission St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/18/1995 12:00:00 AM 3 3x3   6006037.9197 2098666.6602 37.742880528375395 -122.42175250189501 (37.7428805283754, -122.421752501895)
17939 26869 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 890 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/25/2002 12:00:00 AM 3 3X3   6001564.842 2095930.60071 37.7351146866797 -122.437023288105 (37.7351146866797, -122.437023288105)
18016 49368 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 448 Campbell Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/10/2003 12:00:00 AM     Permit Number 46341 6010694.36763099 2088383.30285889 37.7149060701976 -122.40492785111799 (37.7149060701976, -122.404927851118)
18483 66408 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 632 Ellsworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/08/1991 12:00:00 AM     Permit Number 29535 6007948.77791486 2095967.06920677 37.7355756171998 -122.414954236685 (37.7355756171998, -122.414954236685)
18626 5933 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1355 Eddy St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/1990 12:00:00 AM 3 4X4   6004029.334559999 2112693.29822 37.781280848415 -122.42969783017901 (37.781280848415, -122.429697830179)
18749 10444 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1508 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/04/1999 12:00:00 AM 6 3x3   5998873.5099 2108710.5533 37.770051957545704 -122.447247648975 (37.7700519575457, -122.447247648975)
18752 10423 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1401 Haight St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 3x3   5999371.8264 2108722.9096 37.7701143458549 -122.44552487423 (37.7701143458549, -122.44552487423)
18926 15619 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 3517 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/27/2001 12:00:00 AM 6 3X3   6005685.7885 2097881.8817 37.7407058402708 -122.422914311238 (37.7407058402708, -122.422914311238)
18932 30938 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1106 Plymouth Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2015 12:00:00 AM 8 3x3 Permit Number 772469 5995956.71997 2091289.90864 37.722052099618104 -122.456077064214 (37.7220520996181, -122.456077064214)
19015 23089 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 1360 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/03/1992 12:00:00 AM 3 3X3   6006386.45124 2101639.17827 37.751062036612 -122.420758355385 (37.751062036612, -122.420758355385)
19275 34240 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 9 Chattanooga St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/1997 12:00:00 AM     Permit Number 38051 6004714.42221556 2103615.95230322 37.7563954143949 -122.426681158586 (37.7563954143949, -122.426681158586)
19418 90383 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 20 12th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/21/2008 12:00:00 AM 3 3x3   6006777.292282 2110019.638696 37.7740948433326 -122.42000143597099 (37.7740948433326, -122.420001435971)
19622 63665 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 3975 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/02/1987 12:00:00 AM     Permit Number 24314 6004068.8441765 2100399.56050654 37.747527435901496 -122.428684519984 (37.7475274359015, -122.428684519984)
19725 114507 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 10 LOMBARD ST 2 Back Yard : Cutout 16 Tree 1 Port 9       4x4   6011932.0 2120995.0 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468)
19876 10381 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 1324 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 2X3   5999783.9663 2108832.8405 37.770439708466604 -122.44410719203998 (37.7704397084666, -122.44410719204)
19877 22862 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 151 Turquoise Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 2X2   5999932.75509 2099167.18309 37.7439086722544 -122.442898328797 (37.7439086722544, -122.442898328797)
20207 4337 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 906 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/27/2001 12:00:00 AM 6 3X3   6001499.188490001 2095960.05903 37.735191840439896 -122.437252384095 (37.7351918404399, -122.437252384095)
20253 28342 DPW Maintained 3 Pyrus kawakamii :: Evergreen Pear 82 3101 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/10/2004 12:00:00 AM 3 3X3   6007042.9194 2100397.9596 37.747690909992706 -122.418400216794 (37.7476909099927, -122.418400216794)
20299 63295 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 29 Bessie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/26/1987 12:00:00 AM     Permit Number 23861 6008153.74699222 2100060.03492719 37.746825514117205 -122.41453511521401 (37.7468255141172, -122.414535115214)
20482 15620 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 3529 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/12/2000 12:00:00 AM 6 3X3   6005636.1083 2097793.1908 37.740459511674 -122.423079784271 (37.740459511674, -122.423079784271)
20547 15616 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 3461 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/12/2000 12:00:00 AM 6 3X3   6005827.515 2098142.9917 37.741430785549205 -122.422442822684 (37.7414307855492, -122.422442822684)
20573 15605 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 3349 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/01/2000 12:00:00 AM 6 3X3   6006192.9166 2098824.6926 37.743323189063 -122.42122778433998 (37.743323189063, -122.42122778434)
20863 112866 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 750 VICENTE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5990595.0 2097751.0 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927)
21028 15622 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 3535 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/27/2001 12:00:00 AM 6 3X3   6005607.2671 2097740.6765 37.7403136916677 -122.423175774097 (37.7403136916677, -122.423175774097)

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" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 18.39ms · Data source: data.sfgov.org