sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
68017 208858 2 73 438 Capitol Ave 1 1 1 1     1 Width 3ft   5995058.10493 2088636.3102900002 37.7147143277695 -122.458991293911 (37.7147143277695, -122.458991293911)
69513 202022 2 73 1330 Fitzgerald Ave 4 4 1 1     3 Width 3ft   6013717.54523 2091271.8320400002 37.723005925068605 -122.39468056126199 (37.7230059250686, -122.394680561262)
70356 193410 2 73 551 Utah St 3 1 1 1     3 Width 3ft   6010705.60274 2105553.4377099997 37.762052213957794 -122.40609794748501 (37.7620522139578, -122.406097947485)
70771 193438 2 73 170 Scotia Ave 1 4 1 1     1 Width 3ft   6012250.26105 2094642.5839099998 37.7321796295918 -122.39998929257601 (37.7321796295918, -122.399989292576)
71026 230404 2 73 995 Potrero Ave 14 1 1 1     4 Width 3ft   6010493.00859 2104414.71875 37.7589136546545 -122.406752977672 (37.7589136546545, -122.406752977672)
74087 230423 2 73 387 Shotwell St 2 1 1 1     2 Width 3ft   6007832.95914 2105672.86461 37.7622190400112 -122.416041797198 (37.7622190400112, -122.416041797198)
74732 117153 2 73 701 Pennsylvania Ave 1 1 1 1     5 3x3   6014462.23102 2103712.78244 37.757207574192 -122.392976332502 (37.757207574192, -122.392976332502)
75391 230416 2 73 1301 San Jose Ave 2 1 1 1     3 Width 3ft   6003629.87373 2095518.0627099997 37.734099111076496 -122.429854315422 (37.7340991110765, -122.429854315422)
76597 46980 1 73 1310 Minnesota St 4 1 1 1   05/01/2002 12:00:00 AM 2   Permit Number 44998 6015320.4365300005 2102435.8456200003 37.7537490109239 -122.38991910430799 (37.7537490109239, -122.389919104308)
76703 230409 2 73 701 Potrero Ave 8 1 1 1     5 Width 4ft   6010459.52552 2104963.6053 37.7604189003367 -122.406907464126 (37.7604189003367, -122.406907464126)
77661 94252 2 73 2125 BRYANT ST 10 1 1 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
80296 94248 2 73 2125 BRYANT ST 5 1 1 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
80407 94251 2 73 2125 BRYANT ST 9 1 1 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
80702 29817 1 73 1695X Evans Ave 14 1 1 15   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.74391708243721 -122.39024991836901 (37.7439170824372, -122.390249918369)
81640 87806 1 73 291 28th Ave 1 1 1 1   06/02/2008 12:00:00 AM 3 3x12 Permit Number 50584 5987096.8 2114028.5 37.783973582398794 -122.48837346173 (37.7839735823988, -122.48837346173)
81669 117300 1 73 2238 34th Ave 1 1 1 1   06/06/2016 12:00:00 AM 3   Permit Number 778520 5985801.3 2099978.9 37.7453216318219 -122.49182069563601 (37.7453216318219, -122.491820695636)
82328 115264 1 73 1634 22nd Ave 1 1 1 1   01/21/2016 12:00:00 AM     Permit Number 775141 5989384.4 2104210.4 37.7571489820097 -122.47974063936701 (37.7571489820097, -122.479740639367)
83236 94249 2 73 2125 BRYANT ST 6 1 1 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
83398 93296 3 73 999X Church St 1 1 1 2   12/12/2008 12:00:00 AM 3 3x3   6004559.2 2103505.3 37.7560828122733 -122.42721008996901 (37.7560828122733, -122.427210089969)
83678 99998 2 73 501X Mission St 1 10 1 1   06/26/2012 12:00:00 AM     Permit Number 768978 6013420.0 2115433.0 37.7893307029327 -122.397402707509 (37.7893307029327, -122.397402707509)
85349 87807 1 73 291 28th Ave 2 1 1 1   06/02/2008 12:00:00 AM 3 3x3 Permit Number 50584 5987096.8 2114028.5 37.783973582398794 -122.48837346173 (37.7839735823988, -122.48837346173)
85527 58794 1 73 2125 BRYANT ST 2 1 1 1   09/17/1979 12:00:00 AM     Permit Number 18041 6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
85880 93629 1 73 251 32nd Ave 1 1 1 1   03/16/2010 12:00:00 AM   3x3 Permit Number 53264 5985797.0 2114222.0 37.7844289534299 -122.492884487425 (37.7844289534299, -122.492884487425)
86642 39178 1 73 1050 South Van Ness Ave 2 1 1 1   06/03/2015 12:00:00 AM 3 4x4 Permit Number 775243 6007589.88726975 2103539.15878969 37.7563467058962 -122.416731326975 (37.7563467058962, -122.416731326975)
86692 93242 3 73 636 Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004253.0 2105189.0 37.7606885326436 -122.428389032489 (37.7606885326436, -122.428389032489)
86859 115273 1 73 1314 35th Ave 1 1 1 1   01/21/2016 12:00:00 AM     Permit Number 775588 5985278.7 2106245.9 37.762498531179396 -122.49408954164 (37.7624985311794, -122.49408954164)
89459 16928 3 73 518 Oak St 1 1 1 2   04/02/2007 12:00:00 AM 3 2.5 X3   6004333.80114 2110174.91218 37.7743832165186 -122.42846496781999 (37.7743832165186, -122.42846496782)
90330 93297 3 73 985 Church St 1 1 1 2   12/12/2008 12:00:00 AM 3 3x3   6004420.0 2103163.0 37.755135063976205 -122.42766710326099 (37.7551350639762, -122.427667103261)
91544 93246 3 73 990 Church St 2 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004369.0 2103119.0 37.7550113653552 -122.427840341146 (37.7550113653552, -122.427840341146)
93002 115285 1 73 32 Richland Ave 1 1 1 1   01/22/2016 12:00:00 AM     Permit Number 775365 6004721.1 2096171.8 37.7359558621574 -122.426128127271 (37.7359558621574, -122.426128127271)
93824 117589 2 73 2698 VALLEJO ST 1 1 1 1       3x3   6000707.0 2117582.0 37.7945152706116 -122.44154236468901 (37.7945152706116, -122.441542364689)
94785 100008 2 73 501X Mission St 4 10 1 1   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339)
96459 94253 2 73 2125 BRYANT ST 12 1 1 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
97825 93239 3 73 600X Church St 2 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004217.7 2105335.5 37.761088789181 -122.428521561971 (37.761088789181, -122.428521561971)
100689 115319 1 73 86 Homestead St 1 1 1 1   01/26/2016 12:00:00 AM 3   Permit Number 777439 6000946.9 2101238.5 37.7496537815844 -122.439540113547 (37.7496537815844, -122.439540113547)
101374 106758 2 73 445 Grafton Ave   1 1 1   06/02/2014 12:00:00 AM     Permit Number 772911 5995409.1 2090523.2 37.7199154518997 -122.457914582927 (37.7199154518997, -122.457914582927)
101686 54058 1 73 501 Irving St 1 1 1 1   03/24/2011 12:00:00 AM     Permit Number 767754 5994238.69785688 2106641.55496777 37.7641051091536 -122.46312913118099 (37.7641051091536, -122.463129131181)
107887 93247 3 73 990 Church St 3 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004369.0 2103119.0 37.7550113653552 -122.427840341146 (37.7550113653552, -122.427840341146)
108925 94327 1 73 1132 Capitol Ave 1 1 1 1   07/15/2010 12:00:00 AM   3x3 Permit Number 53627 5995101.4 2091446.0 37.722431557418396 -122.459044970295 (37.7224315574184, -122.459044970295)
109745 115375 1 73 230 Bennington St 1 1 1 1   01/28/2016 12:00:00 AM 3   Permit Number 776301 6007067.3 2096865.5 37.7379929380378 -122.41806552154101 (37.7379929380378, -122.418065521541)
109955 112881 1 73 634 35th Ave 1 1 1 1   08/26/2015 12:00:00 AM     Permit Number 773545 5985072.5 2111537.7 37.777016246756894 -122.49519295395201 (37.7770162467569, -122.495192953952)
110498 114987 1 73 157 Thrift St 1 1 1 1   12/29/2015 12:00:00 AM     Permit Number 775985 5995400.7 2089591.3 37.7173561925503 -122.45787621793899 (37.7173561925503, -122.457876217939)
111534 62821 1 73 165 Jersey St 1 1 1 1   10/05/2010 12:00:00 AM   3x3 Permit Number 53769 6004060.48554268 2101568.78877881 37.750737391448396 -122.42879676445 (37.7507373914484, -122.42879676445)
112590 104967 2 73 143-147 FAIR OAKS ST 1 1 1 1     17 3x3 Permit Number 770854 6005451.2 2102876.8 37.7544075015735 -122.424080557223 (37.7544075015735, -122.424080557223)
112880 88518 1 73 133 Kenwood Way   1 1 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51449 5994469.5 2093573.6 37.728237086689404 -122.46138344933 (37.7282370866894, -122.46138344933)
113588 93243 3 73 656 Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004259.0 2105076.0 37.7603786010488 -122.428360227113 (37.7603786010488, -122.428360227113)
114085 39177 1 73 1050 South Van Ness Ave 1 1 1 1   06/03/2015 12:00:00 AM 3 4x4 Permit Number 775243 6007589.88726975 2103539.15878969 37.7563467058962 -122.416731326975 (37.7563467058962, -122.416731326975)
116382 94250 2 73 2125 BRYANT ST 8 1 1 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
116397 94257 2 73 2777X 19th St 2 1 1 1     6 3x3   6009684.4 2104752.7 37.7597963985886 -122.40957339028499 (37.7597963985886, -122.409573390285)
118297 45655 1 73 501 Irving St 2 1 1 1   03/24/2011 12:00:00 AM     Permit Number 767754 5994244.0 2106639.0 37.764098399310704 -122.463110607355 (37.7640983993107, -122.463110607355)
119015 8129 1 73 899 Fulton St 2 1 1 1   09/04/2013 12:00:00 AM 12 3X3 Permit Number 770378 6003470.39544 2111382.10126 37.7776489625125 -122.431537848369 (37.7776489625125, -122.431537848369)
119249 93241 3 73 626 Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004249.0 2105248.0 37.7608503062499 -122.428407072017 (37.7608503062499, -122.428407072017)
119713 93245 3 73 990 Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004369.0 2103119.0 37.7550113653552 -122.427840341146 (37.7550113653552, -122.427840341146)
119799 94256 2 73 2777X 19th St 3 1 1 1     9 3x3   6009684.4 2104752.7 37.7597963985886 -122.40957339028499 (37.7597963985886, -122.409573390285)
120541 93238 3 73 600X Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004217.7 2105335.5 37.761088789181 -122.428521561971 (37.761088789181, -122.428521561971)
121754 17176 1 73 1601 Octavia St 1 1 1 1   02/05/1999 12:00:00 AM 3 4X4   6004921.1693652 2114736.5058391998 37.7869414485048 -122.426758067349 (37.7869414485048, -122.426758067349)
123112 18993 1 73 2965 Sacramento St 3 1 1 1   04/08/1999 12:00:00 AM 3 3X3   6000621.16815 2115478.56365 37.7887348935356 -122.441688325582 (37.7887348935356, -122.441688325582)
124081 93240 3 73 600X Church St 3 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004217.7 2105335.5 37.761088789181 -122.428521561971 (37.761088789181, -122.428521561971)
124084 117301 1 73 2238 34th Ave 2 1 1 1   06/06/2016 12:00:00 AM 3   Permit Number 778520 5985801.3 2099978.9 37.7453216318219 -122.49182069563601 (37.7453216318219, -122.491820695636)
124691 100003 2 73 501X Mission St 2 10 1 1   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339)
124793 93248 3 73 990 Church St 4 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004369.0 2103119.0 37.7550113653552 -122.427840341146 (37.7550113653552, -122.427840341146)
126057 93244 3 73 910X Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004315.0 2103566.4 37.7562367654726 -122.42805896962099 (37.7562367654726, -122.428058969621)
126378 45656 1 73 501 Irving St 3 1 1 1   03/24/2011 12:00:00 AM     Permit Number 767754 5994244.0 2106639.0 37.764098399310704 -122.463110607355 (37.7640983993107, -122.463110607355)
127184 93298 3 73 869 Church St 1 1 1 2   12/12/2008 12:00:00 AM 3 3x3   6004381.0 2103841.0 37.75699448617571 -122.427850284713 (37.7569944861757, -122.427850284713)
128958 100007 2 73 501X Mission St 3 10 1 1   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339)
130484 193429 2 73 1151 22nd St 3 1 1 1     6 Width 3ft   6014506.85634 2103858.18885 37.7576093076281 -122.39283217206699 (37.7576093076281, -122.392832172067)
132389 46977 1 73 1310 Minnesota St 8 1 1 1   05/01/2002 12:00:00 AM 2   Permit Number 44998 6015323.660209999 2102361.18474 37.7535441867291 -122.38990274114201 (37.7535441867291, -122.389902741142)
135447 193437 2 73 420 Bay Shore Blvd 1 4 1 1     4 Width 3ft   6010286.5563 2097785.62722 37.7407000755616 -122.40699974536501 (37.7407000755616, -122.406999745365)
136176 117160 2 73 701 Pennsylvania Ave 8 1 1 1     7 3x3   6014455.03317 2103837.45298 37.7575494928317 -122.393009948265 (37.7575494928317, -122.393009948265)
137569 177457 2 73 1651 San Jose Ave 5 1 1 1     2 Width 2ft   6001558.284440001 2094165.3004599998 37.730267205960295 -122.436919623235 (37.7302672059603, -122.436919623235)
138541 230402 2 73 995 Potrero Ave 3 4 1 1     7 Width 4ft   6010527.0507 2103856.48907 37.7573827855076 -122.406595905697 (37.7573827855076, -122.406595905697)
138542 54682 1 73 1212 10th Ave 1 1 1 1   06/14/2011 12:00:00 AM     Permit Number 767886 5993014.13432891 2107214.38358529 37.7656073275163 -122.467406160634 (37.7656073275163, -122.467406160634)
140028 115265 1 73 1634 22nd Ave 2 1 1 1   01/21/2016 12:00:00 AM     Permit Number 775141 5989384.4 2104210.4 37.7571489820097 -122.47974063936701 (37.7571489820097, -122.479740639367)
140226 93299 3 73 801X Church St 6 1 1 2   12/12/2008 12:00:00 AM 3 3x3   6004394.3 2104124.7 37.757774211767796 -122.427824502367 (37.7577742117678, -122.427824502367)
143820 115252 1 73 438 Capitol Ave 1 1 1 1   01/21/2016 12:00:00 AM     Permit Number 772344 5995084.0 2088641.7 37.7147306151804 -122.45890218049101 (37.7147306151804, -122.458902180491)
144594 82560 1 73 832 Alabama St 1 1 1 1   06/26/2009 12:00:00 AM   3x3 Permit Number 52208 6009084.37207289 2104307.27777207 37.7585397298832 -122.411617128308 (37.7585397298832, -122.411617128308)
145233 18367 3 73 625 Potrero Ave 1 1 1 2   07/17/2015 09:59:00 AM 3 4X3   6010438.66394 2105366.85434 37.7615249639888 -122.407008038291 (37.7615249639888, -122.407008038291)
145504 84013 1 73 207 Lakeview Ave 1 1 1 1   01/21/2016 12:00:00 AM   3x3 Permit Number 771913 5997093.91103174 2089409.10522836 37.7169530610701 -122.45201046888201 (37.7169530610701, -122.452010468882)
145552 96632 1 73 1212 10th Ave 3 1 1 1   06/14/2011 12:00:00 AM     Permit Number 767886 5993035.2 2107183.3 37.7655231963247 -122.467331039359 (37.7655231963247, -122.467331039359)
145630 56557 1 73 27 Ardenwood Way 1 1 1 1   04/09/2010 12:00:00 AM     Permit Number 53358 5991301.89931547 2096270.47961182 37.7354592201324 -122.47253040166201 (37.7354592201324, -122.472530401662)
146792 101611 1 73 681 San Bruno Ave 2 1 1 1     6 3x6   6011008.341990001 2105144.37638 37.7609459516243 -122.40502208042 (37.7609459516243, -122.40502208042)
147472 230408 2 73 701 Potrero Ave 6 1 1 1     1 Width 4ft   6010466.90309 2104889.86859 37.7602168487345 -122.40687675138001 (37.7602168487345, -122.40687675138)
149115 93670 2 73 12 Robblee Ave 1 1 1 1   01/07/2011 12:00:00 AM 1 3x3 Permit Number 54071 6012650.87025 2095997.96753 37.735923558519104 -122.39869937070299 (37.7359235585191, -122.398699370703)
150182 193425 2 73 501 18th St 6 1 1 1     8 Width 3ft   6015950.63788 2105804.61367 37.7630338608554 -122.38797476464799 (37.7630338608554, -122.387974764648)
151479 193416 2 73 1425 Indiana St 3 1 1 1     5 Width 4ft   6015128.54714 2101843.94886 37.75211314410829 -122.390541350608 (37.7521131441083, -122.390541350608)
154620 202023 2 73 1330 Fitzgerald Ave 5 4 1 1     3 Width 3ft   6013701.15269 2091283.23076 37.723036312264796 -122.394738025239 (37.7230363122648, -122.394738025239)
154854 177455 2 73 1651 San Jose Ave 3 1 1 1     4 Width 2ft   6001518.96973 2094154.72477 37.7302359329302 -122.43705478235701 (37.7302359329302, -122.437054782357)
155237 131012 2 73 1661 Sacramento St 1 1 1 1     1 Width 4ft   6006845.959840001 2116366.0433 37.7915243922801 -122.420214413174 (37.7915243922801, -122.420214413174)
159837 193415 2 73 1425 Indiana St 2 1 1 1     5 Width 4ft   6015129.4675 2101818.79874 37.75204413825129 -122.390536410622 (37.7520441382513, -122.390536410622)
160052 230400 2 73 898 Potrero Ave 1 1 1 1     2 Width 4ft   6010432.2870000005 2104046.5208099997 37.7578992679501 -122.406937031143 (37.7578992679501, -122.406937031143)
161322 202025 2 73 1330 Fitzgerald Ave 7 4 1 1     3 Width 3ft   6013662.901769999 2091312.2744599998 37.723113933631204 -122.394872285044 (37.7231139336312, -122.394872285044)
162305 230396 2 73 675 Potrero Ave 2 1 1 1     1 Width 3ft   6010452.66825 2105159.82839 37.7609573010551 -122.406945010817 (37.7609573010551, -122.406945010817)
163256 193435 2 73 600 Missouri St 1 4 1 1     7 Width 3ft   6013537.44197 2104295.86136 37.7587571690323 -122.39621549896299 (37.7587571690323, -122.396215498963)
165780 193423 2 73 501 18th St 4 1 1 1     7 Width 3ft   6015877.90137 2105798.99134 37.7630143932264 -122.388225945268 (37.7630143932264, -122.388225945268)
167491 230403 2 73 995 Potrero Ave 10 4 1 1     4 Width 2ft   6010508.06667 2104211.71419 37.758357092123106 -122.406686593337 (37.7583570921231, -122.406686593337)
170064 202026 2 73 1330 Fitzgerald Ave 8 4 1 1     3 Width 3ft   6013645.7458 2091325.32173 37.723148804870206 -122.394932503635 (37.7231488048702, -122.394932503635)
171216 177456 2 73 1651 San Jose Ave 4 1 1 1     3 Width 2ft   6001539.4565 2094159.8919400002 37.7302512852618 -122.436984326781 (37.7302512852618, -122.436984326781)
172396 193422 2 73 501 18th St 3 1 1 1     7 Width 3ft   6015855.7958 2105797.31045 37.763008553013 -122.388302284235 (37.763008553013, -122.388302284235)
173435 230401 2 73 1140 Potrero Ave 1 1 1 1     3 Width 3ft   6010508.63913 2102581.4092 37.753880669869794 -122.406569730021 (37.7538806698698, -122.406569730021)
174486 230411 2 73 2901 Cesar Chavez St 1 2 1 1     7     6010009.797780001 2100525.6899 37.7482081987543 -122.408149874844 (37.7482081987543, -122.408149874844)
174880 46981 1 73 1310 Minnesota St 5 1 1 1   05/01/2002 12:00:00 AM 1   Permit Number 44998 6015319.9852 2102418.03165 37.7537000725041 -122.389919420856 (37.7537000725041, -122.389919420856)
Powered by Datasette · Query took 3.155ms · Data source: data.sfgov.org