sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
114652 97162 7 235 478 10th Ave   13 1 1         Tree in backyard on private property; not significant. 5992861.5 2112216.7 37.7793335349967 -122.468298031686 (37.7793335349967, -122.468298031686)
114869 111205 9 24 46 COOK ST   13 1 1     36   Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514.0 2113392.0 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469)
92869 99821 2 218 1230 Twin Peaks Blvd 1 13 1 1     11   Tree closest to sidewalk and retaining wall 5997905.5 2100119.1 37.7464066170132 -122.449976668748 (37.7464066170132, -122.449976668748)
129485 97033 7 70 61 Vicksburg St   13 1 1         Possible significant tree; Nellie RoW; rear yard 6004120.0 2102703.0 37.753855038047 -122.428671801406 (37.753855038047, -122.428671801406)
2864 209183 2 17 140 Kensington Way 3 13 1 1   08/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780524 5994862.40668 2098482.07156 37.741737150351 -122.460380669142 (37.741737150351, -122.460380669142)
2887 209188 2 17 156 Kensington Way 2 13 1 1   08/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780524 5994823.818630001 2098534.27999 37.7418782818471 -122.46051787510599 (37.7418782818471, -122.460517875106)
2502 253119 5 3 185 Belgrave Ave 1 13 1 1         Permit Number 780239 5997636.85301 2104869.74588 37.759435335978296 -122.45124816933 (37.7594353359783, -122.45124816933)
22866 251139 6 17 621X Gough St 1 13 1 1   03/10/2017 12:00:00 AM 3   Permit Number 779685          
115524 117309 6 17 3711 19th Ave 1 13 1 1   06/06/2016 12:00:00 AM 3 10x10 Permit Number 777997 5990297.3 2090806.0 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889)
82211 115446 6 17 546 FRANCONIA ST 2 13 1 1   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777844 6009931.0 2098208.0 37.7418399166086 -122.40825891223801 (37.7418399166086, -122.408258912238)
89719 115445 6 17 546 FRANCONIA ST 1 13 1 1   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777844 6009931.0 2098208.0 37.7418399166086 -122.40825891223801 (37.7418399166086, -122.408258912238)
52917 116537 6 17 598x MOUNT VERNON AVE 6 13 1 1   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754.0 2090179.0 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005)
96225 116534 6 17 598x MOUNT VERNON AVE 3 13 1 1   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754.0 2090179.0 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005)
101782 116536 6 17 598x MOUNT VERNON AVE 5 13 1 1   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754.0 2090179.0 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005)
111156 116535 6 17 598x MOUNT VERNON AVE 4 13 1 1   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754.0 2090179.0 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005)
20974 109568 6 116 95 Nordhoff St 1 13 1 1         Permit Number 777169 6000348.8 2095645.6 37.734262946491704 -122.44120712981501 (37.7342629464917, -122.441207129815)
142191 114191 6 17 201 Delano Ave 7 13 1 1     20   Permit Number 776814 6000172.52130735 2092388.14283689 37.7253086814057 -122.44158289611 (37.7253086814057, -122.44158289611)
97754 115459 6 17 80 Crestline Dr 1 13 1 1   02/02/2016 12:00:00 AM 3   Permit Number 776150 5999012.8 2102131.7 37.7519960240451 -122.446292521132 (37.7519960240451, -122.446292521132)
144323 115460 6 17 80 Crestline Dr 2 13 1 1   02/02/2016 12:00:00 AM 3   Permit Number 776150 5999012.8 2102131.7 37.7519960240451 -122.446292521132 (37.7519960240451, -122.446292521132)
98769 112422 2 17 279 Topaz Way   13 1 1   07/29/2015 12:00:00 AM 3 3x3 Permit Number 775772 6001205.6 2097796.6 37.7402178594385 -122.43839895973301 (37.7402178594385, -122.438398959733)
90297 107819 2 3 75X RALSTON ST   13 1 1     45   Permit Number 775492 5992193.0 2088303.0 37.7136340221674 -122.46886994586599 (37.7136340221674, -122.468869945866)
138928 108171 2 17 59x MACONDRAY LN 1 13 1 1     30   Permit Number 774825 6008454.0 2119149.0 37.7992561803015 -122.414847646907 (37.7992561803015, -122.414847646907)
50494 110477 6 12 131X Washington St 1 13 1 1   04/16/2015 12:00:00 AM 3 10x10 Permit Number 774729 6013427.21844 2117958.83498 37.796266453658795 -122.397554954018 (37.7962664536588, -122.397554954018)
126031 110476 6 12 3700 Washington St 1 13 1 1   04/16/2015 12:00:00 AM 3 10x10 Permit Number 774729 5997015.1 2115715.0 37.7891779638687 -122.454181816252 (37.7891779638687, -122.454181816252)
28419 108850 1 58 250x MONTCALM ST 1 13 1 1   02/09/2015 12:00:00 AM 3   Permit Number 774524 6009909.2 2099657.1 37.745817608401104 -122.40843648152 (37.7458176084011, -122.40843648152)
82422 113192 1 58 150X Museum Way 1 13 1 1   09/11/2015 12:00:00 AM     Permit Number 774288 6001029.7 2106463.5 37.7640050744287 -122.439628320832 (37.7640050744287, -122.439628320832)
93109 107611 6 3 470x Broadway 1 13 1 1         Permit Number 774041 6011286.02608 2118707.45024 37.7982025127238 -122.40501669828998 (37.7982025127238, -122.40501669829)
96078 108000 6 17 1000 Rhode Island St 1 13 1 1   11/12/2014 12:00:00 AM 3   Permit Number 774025 6011852.20179 2103661.18899 37.7569205837919 -122.401999252275 (37.7569205837919, -122.401999252275)
142812 107493 6 17 180 BARTLETT ST 1 13 1 1   11/10/2014 12:00:00 AM 3   Permit Number 774017 6006657.2 2102756.7 37.7541457516772 -122.419901368465 (37.7541457516772, -122.419901368465)
19360 105328 6 17 2051 03rd St 2 13 1 1         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631)
118543 105327 6 17 2051 03rd St 1 13 1 1         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631)
101621 104406 6 3 290 Stonecrest Dr 1 13 1 1     36   Permit Number 770927 5990725.0 2092655.0 37.7254986161427 -122.474261202586 (37.7254986161427, -122.474261202586)
141746 104027 6 3 520X Oak Park Dr 1 13 1 1   07/25/2013 12:00:00 AM     Permit Number 770238 5995008.5 2103700.7 37.756074592877496 -122.46025354267599 (37.7560745928775, -122.460253542676)
101996 101236 6 17 895X Church St 1 13 1 1   10/05/2012 12:00:00 AM 13   Permit Number 769299 6004383.5 2103691.7 37.7565846850157 -122.42783100085899 (37.7565846850157, -122.427831000859)
87905 100771 6 108 450 Hayes St 2 13 1 1         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899)
101515 100772 6 108 450 Hayes St 3 13 1 1         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899)
115663 100770 6 108 450 Hayes St 1 13 1 1         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899)
81929 98694 6 338 191@Clarendon Forest Knolls Dr 1 13 1 1   05/01/2012 12:00:00 AM     Permit Number 768674 5996330.9 2103059.9 37.754391095173794 -122.455633951336 (37.7543910951738, -122.455633951336)
140306 98695 6 338 191@Clarendon Forest Knolls Dr 2 13 1 1   05/01/2012 12:00:00 AM     Permit Number 768674 5996330.9 2103059.9 37.754391095173794 -122.455633951336 (37.7543910951738, -122.455633951336)
144229 98696 6 338 191@Clarendon Forest Knolls Dr 3 13 1 1   05/01/2012 12:00:00 AM     Permit Number 768674 5996330.9 2103059.9 37.754391095173794 -122.455633951336 (37.7543910951738, -122.455633951336)
141687 96779 6 17 555 Melrose Ave 1 13 1 1   07/18/2011 12:00:00 AM     Permit Number 767966 5996882.6 2095364.1 37.7332919614683 -122.45317051411999 (37.7332919614683, -122.45317051412)
84714 92484 1 17 155 Greenwich St 15 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
85249 92475 1 17 155 Greenwich St 5 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
85668 92476 1 17 155 Greenwich St 6 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
88491 92474 1 17 155 Greenwich St 4 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
91344 87564 1 17 155 Greenwich St 3 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
104140 92480 1 17 155 Greenwich St 10 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
113154 87562 1 17 155 Greenwich St 1 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
128270 92481 1 17 155 Greenwich St 12 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
140175 87563 1 17 155 Greenwich St 2 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
145573 92485 1 17 155 Greenwich St 11 13 1 1   07/30/2009 12:00:00 AM   3x3 Permit Number 52856 6012015.0 2120477.0 37.803101990704896 -122.402618721555 (37.8031019907049, -122.402618721555)
88950 86946 1 3 495 Pacheco St 1 13 1 1   11/20/2007 12:00:00 AM   3x3 Permit Number 51051 5993544.7 2101797.8 37.750765410178 -122.465177603148 (37.750765410178, -122.465177603148)
114899 88028 1 17 495 Pacheco St 1 13 1 1   06/23/2008 12:00:00 AM     Permit Number 51051 5993544.7 2101797.8 37.750765410178 -122.465177603148 (37.750765410178, -122.465177603148)
96761 87388 1 175 201 Topeka Ave 2 13 1 1   04/24/2008 12:00:00 AM     Permit Number 50366 6012955.9 2095077.8 37.7334139596128 -122.39758023766399 (37.7334139596128, -122.397580237664)
99282 87387 1 175 201 Topeka Ave   13 1 1   04/24/2008 12:00:00 AM     Permit Number 50366 6012955.9 2095077.8 37.7334139596128 -122.39758023766399 (37.7334139596128, -122.397580237664)
110484 87389 1 175 201 Topeka Ave 3 13 1 1   04/24/2008 12:00:00 AM     Permit Number 50366 6012955.9 2095077.8 37.7334139596128 -122.39758023766399 (37.7334139596128, -122.397580237664)
28143 87300 3 44 2323 Cesar Chavez St 2 13 1 2     6   Permit Number 50312 6011877.987480001 2100898.0514700003 37.749335051069004 -122.401715863223 (37.749335051069, -122.401715863223)
49336 87301 3 44 2323 Cesar Chavez St 3 13 1 2     5   Permit Number 50312 6011915.6161 2100899.61614 37.7493414470685 -122.401585851825 (37.7493414470685, -122.401585851825)
152183 87299 3 44 2323 Cesar Chavez St 1 13 1 2     4   Permit Number 50312 6011851.38946 2100896.5951099996 37.7493295679091 -122.401807737936 (37.7493295679091, -122.401807737936)
91632 87216 6 502 500 Cortland Ave 2 13 1 1   02/08/2008 12:00:00 AM   3x3 Permit Number 50224 6007640.7 2097187.4 37.7389090609704 -122.416105779709 (37.7389090609704, -122.416105779709)
101276 62912 6 502 500 Cortland Ave 1 13 1 1   02/08/2008 12:00:00 AM   3x3 Permit Number 50224 6007523.90359428 2097218.90762974 37.7389890062486 -122.416511839888 (37.7389890062486, -122.416511839888)
86911 87150 6 116 4 Bellair Pl 2 13 1 1         Permit Number 50135 6010093.0 2120950.0 37.8042932388788 -122.409303278994 (37.8042932388788, -122.409303278994)
91108 97177 7 17 257 Roosevelt Way   13 1 1         Monterey cypress tree in backyard on private property; not a Significant tree 6000848.1 2107127.9 37.765819014897296 -122.44030407045099 (37.7658190148973, -122.440304070451)
88847 103457 3 3 800X Bosworth St 3 13 1 2     26   Located on DPW property next to 84 Lippard Ave 6001796.5 2095573.7 37.7341478843848 -122.436196831648 (37.7341478843848, -122.436196831648)
115312 100244 7 113 71 Sanchez St   13 1 1         Interior courtyard 6003507.0 2107903.0 37.7680982797144 -122.431162830878 (37.7680982797144, -122.431162830878)
110289 103566 3 3 51X Prentiss St 1 13 1 2     12   DPW property; below Bernal Heights Blvd near this address 6008906.8 2098323.8 37.742100473688396 -122.41180845469201 (37.7421004736884, -122.411808454692)
128311 98265 7 143 755 O'Farrell St   13 1 1         Backyard tree; not significant 6007700.0 2113968.3 37.784988860902295 -122.417089467607 (37.7849888609023, -122.417089467607)
120804 96938 7 17 1306 Cole St   13 1 1         Backyard tree on private property 5998246.0 2105961.0 37.7624665052811 -122.449220068104 (37.7624665052811, -122.449220068104)
122667 100169 3 3 180X Manchester St   13 1 2         Adjacent to rear of property - DPW parcel 6008242.0 2099158.0 37.7443536844995 -122.414166136282 (37.7443536844995, -122.414166136282)
427 251307 2 17 200 Cashmere St 1 13 1 1       3x3   6016315.0 2096328.0 37.7370332293639 -122.38605389871 (37.7370332293639, -122.38605389871)
433 251301 2 36 100 Whitney Young Cir 2 13 1 7       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
474 251300 2 36 100 Whitney Young Cir 1 13 1 8       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
669 251343 7 39 934 Brannan St 1 13 1 1       3x3   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
780 251383 2 113 49x Milan Ter 1 13 1 1       3x3   5997587.0 2087495.0 37.711725600519706 -122.450168218052 (37.7117256005197, -122.450168218052)
883 251306 2 1 1 Cashmere St 5 13 1 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
885 251305 2 1 1 Cashmere St 4 13 1 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
887 251303 2 103 1 Cashmere St 2 13 1 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
891 251304 2 1 1 Cashmere St 3 13 1 1 5     3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
896 251302 2 103 1 Cashmere St 1 13 1 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
1273 251481 7 3 32 Peralta Ave 1 13 1 2       3x3   6010779.0 2100499.0 37.7481779538542 -122.40548810426901 (37.7481779538542, -122.405488104269)
1305 251497 2 17 329x Warren Dr 1 13 1 1       3x3   5994610.0 2103362.0 37.7551216790189 -122.461607123764 (37.7551216790189, -122.461607123764)
1380 251512 7 20 4116x 18th St 1 13 1 6       3x3   6002190.0 2105341.0 37.760988934022706 -122.43553488468001 (37.7609889340227, -122.43553488468)
1384 251515 6 3 99x Mountview Ct 1 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1398 251517 2 47 145 Bonview St 1 13 1 1       3x3   6007188.0 2098162.0 37.7415596321362 -122.417740072125 (37.7415596321362, -122.417740072125)
1409 251514 6 3 99x Mountview Ct 2 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1598 251612 6 3 60R Amber Dr 1 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1600 251625 2 47 76R Amber Dr 3 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1603 251636 6 3 22R Amethyst Way 1 13 1 1           5999148.0 2100052.0 37.74629339412971 -122.44567543770901 (37.7462933941297, -122.445675437709)
1604 251632 6 47 14R Amethyst Way 1 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1605 251634 2 47 14R Amethyst Way 3 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1607 251602 6 108 44R Amber Dr 1 13 1 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1608 251603 6 47 44R Amber Dr 2 13 1 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1609 251630 6 47 8R Amethyst Way 2 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1611 251605 6 108 48R Amber Dr 2 13 1 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1613 251616 2 47 64R Amber Dr 3 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1615 251604 6 3 48R Amber Dr 1 13 1 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1616 251607 6 3 52R Amber Dr 2 13 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1618 251611 2 47 56R Amber Dr 4 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1619 251617 2 47 64R Amber Dr 4 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1623 251613 6 47 60R Amber Dr 2 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1624 251624 2 47 76R Amber Dr 2 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
Powered by Datasette · Query took 8.374ms · Data source: data.sfgov.org