sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
174132 188415 2 58 2 Jennings St 2 4 1 1     1 Width 3ft   6019090.329030001 2097590.47628 37.7406529492792 -122.37654576818998 (37.7406529492792, -122.37654576819)
79940 37260 1 58 801X Church St 3 1 1 1   06/12/1998 12:00:00 AM 3 3x3 Permit Number 39806 6017074.59942826 2104815.9109509 37.7603812969624 -122.38401847505399 (37.7603812969624, -122.384018475054)
97304 37262 1 58 801X Church St 4 1 1 1   06/12/1998 12:00:00 AM 3 3x3 Permit Number 39806 6017074.59942826 2104815.9109509 37.7603812969624 -122.38401847505399 (37.7603812969624, -122.384018475054)
112848 37261 1 58 801X Church St 1 1 1 1   06/12/1998 12:00:00 AM 3 3x3 Permit Number 39806 6017074.59942826 2104815.9109509 37.7603812969624 -122.38401847505399 (37.7603812969624, -122.384018475054)
44277 188414 2 58 602 Arthur Ave 36 7 1 1     5     6015677.9579 2099872.41216 37.746730180067395 -122.388503787217 (37.7467301800674, -122.388503787217)
81119 22153 3 58 1570X Fairfax Ave 4 1 1 2     0 3X3   6015582.155925799 2098251.0940713002 37.742273066345604 -122.388721900676 (37.7422730663456, -122.388721900676)
109961 22155 5 58 1570X FAIRFAX AVE 7 1 1 1     1 3X3   6015579.0 2098247.0 37.74226164995721 -122.388732527256 (37.7422616499572, -122.388732527256)
113561 115771 1 58 1204 Egbert Ave 2 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 775363 6015358.9 2090410.1 37.7207308974409 -122.38894654781099 (37.7207308974409, -122.388946547811)
47522 188400 2 58 1045 Tennessee St 1 1 1 1     1 Width 4ft   6015554.8451 2104260.21833 37.7587713477501 -122.389235841663 (37.7587713477501, -122.389235841663)
167143 188401 2 58 909 Minnesota St 1 1 1 1     1 Width 5ft   6015267.441000001 2104396.98208 37.7591309344718 -122.39023938074101 (37.7591309344718, -122.390239380741)
176601 188418 2 58 1790 McKinnon Ave 1 4 1 1     9 Width 3ft   6014392.11707 2096695.01257 37.737934361678796 -122.39272788847401 (37.7379343616788, -122.392727888474)
159639 188416 2 58 1790 McKinnon Ave 1 4 1 1     20 Width 8ft   6014390.68688 2096696.7168 37.7379389617097 -122.392732952571 (37.7379389617097, -122.392732952571)
54760 188413 2 58 398 Mississippi St 4 4 1 1     1 Width 3ft   6014027.478680001 2105319.8341099997 37.7615960301482 -122.394592417822 (37.7615960301482, -122.394592417822)
62795 188412 2 58 398 Mississippi St 3 4 1 1     1 Width 3ft   6014026.1658 2105339.44297 37.761649798808996 -122.394598331744 (37.761649798809, -122.394598331744)
77059 188411 2 58 398 Mississippi St 2 4 1 1     1 Width 3ft   6014024.24871 2105357.36092 37.7616988910081 -122.394606216998 (37.7616988910081, -122.394606216998)
91902 91227 1 58 250 Texas St 1 1 1 1   02/02/2010 12:00:00 AM   3x3 Permit Number 53161 6013717.0 2105930.0 37.763254145992796 -122.39570899856199 (37.7632541459928, -122.395708998562)
48133 60575 1 58 250 Texas St 1 1 1 1   12/16/1982 12:00:00 AM 3   Permit Number 20188 6013715.09373 2105885.47906 37.763131795228794 -122.395712472146 (37.7631317952288, -122.395712472146)
40968 91228 1 58 250 Texas St 2 1 1 1   02/02/2010 12:00:00 AM 4 3x3 Permit Number 53161 6013714.91861 2105876.83519 37.7631080513185 -122.39571247215 (37.7631080513185, -122.39571247215)
68446 188417 2 58 274 Topeka Ave 1 9 1 1     2 Width 3ft   6013295.80448 2094667.84679 37.7323072334974 -122.396376359792 (37.7323072334974, -122.396376359792)
173848 188410 2 58 1501 22nd St 23 7 1 1     15     6013292.91596 2103788.2689099996 37.7573498217412 -122.397025598364 (37.7573498217412, -122.397025598364)
13070 93869 1 58 400-422X Tocoloma Ave 2 1 1 1 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773818 6012466.99875 2086683.8296 37.7103385819422 -122.398681660343 (37.7103385819422, -122.398681660343)
12503 93870 1 58 400-422X Tocoloma Ave 3 1 1 1 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773818 6012462.01959 2086667.4072599998 37.7102932120209 -122.398697717749 (37.7102932120209, -122.398697717749)
178316 202043 2 58 52 Exeter St 2 4 1 1     1 Width 3ft   6012522.16713 2090984.69593 37.722150974681604 -122.398792625891 (37.7221509746816, -122.398792625891)
183898 188402 2 58 654 Carolina St 1 1 1 1     6 Width 3ft   6012373.88939 2104883.09648 37.7603047754705 -122.40028086897 (37.7603047754705, -122.40028086897)
54560 175803 2 58 421 Wheeler Ave 3 1 1 1     4 Width 3ft   6011997.87722 2086794.11576 37.7106152574533 -122.400310793023 (37.7106152574533, -122.400310793023)
171201 175802 2 58 421 Wheeler Ave 2 1 1 1     3 Width 3ft   6011992.04716 2086775.8851599998 37.7105648747395 -122.400329663484 (37.7105648747395, -122.400329663484)
70804 175801 2 58 421 Wheeler Ave 1 1 1 1     4 Width 3ft   6011986.878880001 2086756.6218599998 37.7105116933366 -122.400346174163 (37.7105116933366, -122.400346174163)
185898 188406 3 58 1300x De Haro St 6 3 1 2     6 Width 9ft   6012288.20028 2102185.92507 37.75289415586 -122.400387777694 (37.75289415586, -122.400387777694)
165288 188407 3 58 1300x De Haro St 5 3 1 2     6     6012285.79175 2102196.41625 37.7529228280459 -122.400396843734 (37.7529228280459, -122.400396843734)
91704 188404 3 58 1300x De Haro St 10 3 1 2     2     6012258.41015 2102196.39231 37.7529212353325 -122.40049153337401 (37.7529212353325, -122.400491533374)
171476 188405 3 58 1300x De Haro St 9 3 1 2     9     6012256.82794 2102204.54617 37.752943535820606 -122.400497577699 (37.7529435358206, -122.400497577699)
12119 102524 1 58 154 Wilde Ave 1 1 1 1   07/03/2013 12:00:00 AM 16 3x3 Permit Number 770317 6011839.9295 2088903.3705900002 37.7163980403033 -122.401004803454 (37.7163980403033, -122.401004803454)
36636 188403 2 58 700 De Haro St 1 9 1 1     13     6012073.44818 2105095.84941 37.7608721901295 -122.401334912194 (37.7608721901295, -122.401334912194)
63986 188409 2 58 2033 22nd St 3 9 1 1     3 Width 3ft   6011983.90541 2103708.46876 37.757057753421 -122.40154709194799 (37.757057753421, -122.401547091948)
24848 188408 2 58 2033 22nd St 2 9 1 1     1 Width 3ft   6011976.80987 2103707.86259 37.7570556930855 -122.40157158857299 (37.7570556930855, -122.401571588573)
149036 32269 1 58 2033 22nd St 1 1 1 1 1 10/07/2000 12:00:00 AM 4   Permit Number 36855 6011970.48286 2103707.9911700003 37.7570556930908 -122.40159347895 (37.7570556930908, -122.40159347895)
13992 108725 1 58 877 Rhode Island St 2 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773104 6011895.30838 2104315.65478 37.758720008153 -122.401896177292 (37.758720008153, -122.401896177292)
5046 150652 2 58 647 Kansas St 1 1 1 1     0 Width 4ft   6011556.07446 2105379.04628 37.7616209062969 -122.403144210544 (37.7616209062969, -122.403144210544)
56499 222681 2 58 2318 22nd St 1 2 1 1     1     6011232.98207 2103716.09635 37.7570367677534 -122.404144621787 (37.7570367677534, -122.404144621787)
16644 80780 1 58 702 Vermont St 1 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773102 6011234.66837 2105019.04099 37.760614457905795 -122.404230490851 (37.7606144579058, -122.404230490851)
29820 187571 2 58 73 Bishop St 2 17 1 1     7     6010860.52073 2089475.11103 37.7179132396708 -122.40443035886899 (37.7179132396708, -122.404430358869)
60035 187570 2 58 73 Bishop St 1 17 1 1     6     6010859.73078 2089462.03095 37.7178772802949 -122.404432169207 (37.7178772802949, -122.404432169207)
162264 187573 2 58 73 Bishop St 4 17 1 1     14     6010858.37792 2089492.3055900002 37.717960332674295 -122.404438975305 (37.7179603326743, -122.404438975305)
29739 187574 2 58 72 Bishop St 1 17 1 1     10     6010842.8913900005 2089488.5588 37.71794917929 -122.404492242147 (37.71794917929, -122.404492242147)
36978 187575 2 58 72 Bishop St 2 17 1 1     11     6010832.96557 2089490.7918200002 37.7179547559905 -122.40452670863998 (37.7179547559905, -122.40452670864)
146973 187576 2 58 72 Bishop St 3 17 1 1     6     6010826.85106 2089479.8583099998 37.7179243930824 -122.40454707471301 (37.7179243930824, -122.404547074713)
71501 188399 2 58 619 San Bruno Ave 1 1 1 1     5 Width 3ft   6010997.55787 2105333.97174 37.7614659351153 -122.40507272844499 (37.7614659351153, -122.405072728445)
34874 175804 3 58 500x Mansell St 7 11 1 2     12 Width 0ft   6010489.90873 2090338.0061700002 37.72026185429429 -122.40577215548402 (37.7202618542943, -122.405772155484)
91092 51953 1 58 82 Mary St 2 1 1 1   08/08/2005 12:00:00 AM     Permit Number 48176 6010868.83737248 2112458.01845687 37.781019735711006 -122.40601981145599 (37.781019735711, -122.406019811456)
101349 51952 1 58 82 Mary St 1 1 1 1   08/08/2005 12:00:00 AM     Permit Number 48176 6010868.83737248 2112458.01845687 37.781019735711006 -122.40601981145599 (37.781019735711, -122.406019811456)
141053 51954 1 58 82 Mary St 3 1 1 1   08/08/2005 12:00:00 AM     Permit Number 48176 6010868.83737248 2112458.01845687 37.781019735711006 -122.40601981145599 (37.781019735711, -122.406019811456)
147518 188397 2 58 501 Utah St 1 1 1 1     11 Width 5ft   6010696.0277 2105850.49204 37.7628673226003 -122.406151993137 (37.7628673226003, -122.406151993137)
148509 188398 2 58 501 Utah St 4 1 1 1     12 Width 5ft   6010694.68122 2105889.4054 37.7629740945886 -122.406159391868 (37.7629740945886, -122.406159391868)
62782 175806 2 58 154 Raymond Ave 1 1 1 1     4 Width 3ft   6010320.93963 2087695.47295 37.7129965480265 -122.406170150427 (37.7129965480265, -122.406170150427)
45007 248046 2 58 38 Rutledge St 3 17 1 1     4     6010555.404680001 2099417.48898 37.745195855721995 -122.406185107956 (37.745195855722, -122.406185107956)
118314 45178 1 58 8 Joy St 1 1 1 1 1 05/23/2001 12:00:00 AM     Permit Number 44026 6010481.29682875 2098887.30560798 37.7437359418448 -122.406404010665 (37.7437359418448, -122.406404010665)
184518 39934 1 58 186 Arleta Ave 1 1 1 1 1 01/25/1999 12:00:00 AM 3 3x3 Permit Number 41205 6010249.35801 2088014.8431799999 37.7138694695674 -122.40644005139299 (37.7138694695674, -122.406440051393)
170167 222677 2 58 1498 Hampshire St 1 1 1 1     1 Width 3ft   6010454.79524 2100826.85949 37.749060050992604 -122.40663230034201 (37.7490600509926, -122.406632300342)
54390 247973 2 58 155 Faith St 1 9 1 1     8 Width 6ft   6010331.53551 2099090.76742 37.7442862247418 -122.406936189376 (37.7442862247418, -122.406936189376)
3497 247942 4 58 29 Joy St 5 14 1 2     3   Permit Number 775404 6010292.72224 2098904.67919 37.7437730949632 -122.40705728398399 (37.7437730949632, -122.407057283984)
3510 247941 4 58 29 Joy St 4 14 1 2     5   Permit Number 775404 6010287.82636 2098909.7574 37.743786764646 -122.40707457072901 (37.743786764646, -122.407074570729)
3511 247940 4 58 29 Joy St 3 14 1 2     5   Permit Number 775404 6010280.31746 2098909.2881400003 37.7437850559498 -122.407100501782 (37.7437850559498, -122.407100501782)
40369 222690 2 58 1071 Hampshire St 1 1 1 1     1 Width 4ft   6010267.11643 2102987.22407 37.754981431951606 -122.40743358371901 (37.7549814319516, -122.407433583719)
39135 247897 2 58 351 Mayflower St 2 17 1 1     4     6010077.88258 2098386.8429099997 37.7423392041858 -122.407763645688 (37.7423392041858, -122.407763645688)
37117 175815 2 58 616 Dwight St 1 1 1 1     1 Width 3ft   6009798.67948 2091167.8757200001 37.722501823573 -122.40822001654301 (37.722501823573, -122.408220016543)
156475 175816 2 58 616 Dwight St 2 1 1 1     1 Width 3ft   6009781.28405 2091163.7033900002 37.7224893931511 -122.40827985473699 (37.7224893931511, -122.408279854737)
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)
137834 175805 2 58 35 Ervine St 1 1 1 1     1 Width 2ft   6009673.12409 2089221.0725599998 37.7171492746007 -122.408516774841 (37.7171492746007, -122.408516774841)
49133 247976 2 58 503 Peralta Ave 2 17 1 1     9     6009801.95016 2099270.17301 37.7447491849331 -122.408780045086 (37.7447491849331, -122.408780045086)
136139 222692 2 58 501 York St 5 9 1 1     5 Width 2ft   6009835.7153900005 2105907.76012 37.7629764094606 -122.409131567579 (37.7629764094606, -122.409131567579)
100374 52165 1 58 2981 26th St 1 1 1 1 1 11/01/2005 12:00:00 AM     Permit Number 48358 6009655.09893949 2101001.15400866 37.7494938511533 -122.409409967788 (37.7494938511533, -122.409409967788)
116538 45157 1 58 52 Bradford St 1 1 1 1 1 05/22/2001 12:00:00 AM     Permit Number 44010 6009584.15178374 2098431.32664232 37.7424336946684 -122.40947396270701 (37.7424336946684, -122.409473962707)
24397 222703 2 58 214 Bradford St 1 1 1 1     6 Width 3ft   6009527.84065 2097295.3841 37.7393114881468 -122.40958851400299 (37.7393114881468, -122.409588514003)
149330 222691 2 58 2981 26th St 1 1 1 1     5 Width 3ft   6009598.49349 2101000.57831 37.7494890986626 -122.40960567126801 (37.7494890986626, -122.409605671268)
118878 108906 1 58 214 Bradford St 1 1 1 1 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772968 6009519.2 2097295.6 37.7393115967784 -122.40961840488701 (37.7393115967784, -122.409618404887)
81823 36071 1 58 1504 Bryant St 3 1 1 1 1 04/28/1998 12:00:00 AM     Permit Number 39187 6009387.99483758 2107777.56202059 37.7680853638298 -122.410812146882 (37.7680853638298, -122.410812146882)
94464 36069 1 58 1504 Bryant St 2 1 1 1 1 04/19/2002 12:00:00 AM     Permit Number 44775 6009387.99483758 2107777.56202059 37.7680853638298 -122.410812146882 (37.7680853638298, -122.410812146882)
96552 36068 1 58 1504 Bryant St 5 1 1 1 1 04/28/1998 12:00:00 AM     Permit Number 39187 6009387.99483758 2107777.56202059 37.7680853638298 -122.410812146882 (37.7680853638298, -122.410812146882)
142039 36072 1 58 1504 Bryant St 4 1 1 1 1 04/28/1998 12:00:00 AM     Permit Number 39187 6009387.99483758 2107777.56202059 37.7680853638298 -122.410812146882 (37.7680853638298, -122.410812146882)
105253 109313 1 58 3261 Harrison St 1 1 1 1 1 01/05/2016 12:00:00 AM   3x3 Permit Number 771278 6009056.2 2099704.9 37.745901050724 -122.411389421874 (37.745901050724, -122.411389421874)
185 251243 2 58 299x Chapman St 1 1 1 2       3x3   6008953.0 2098186.0 37.7417246968109 -122.411638974942 (37.7417246968109, -122.411638974942)
88482 92854 1 58 52 Prentiss St 1 1 1 1   12/14/2009 12:00:00 AM   3x4 Permit Number 53073 6008847.1 2098275.4 37.7419642285502 -122.412011459633 (37.7419642285502, -122.412011459633)
85314 40436 1 58 250 Banks St 1 1 1 1 1 06/08/1999 12:00:00 AM     Permit Number 41528 6008599.59735478 2097476.96685444 37.7397580168027 -122.412810811968 (37.7397580168027, -122.412810811968)
84993 117424 2 58 600x POWHATTAN AVE 1 1 1 1     2 3x3   6008524.0 2098073.0 37.7413903494898 -122.41311433102699 (37.7413903494898, -122.413114331027)
97134 122681 2 58 598x Powhattan Ave 3 1 1 1       3x3   6008469.0 2098078.0 37.7414009906205 -122.413304856031 (37.7414009906205, -122.413304856031)
127137 122679 2 58 598x Powhattan Ave 1 1 1 1       3x3   6008469.0 2098078.0 37.7414009906205 -122.413304856031 (37.7414009906205, -122.413304856031)
144281 122680 2 58 598x Powhattan Ave 2 1 1 1       3x3   6008469.0 2098078.0 37.7414009906205 -122.413304856031 (37.7414009906205, -122.413304856031)
155099 222702 2 58 123 Gates St 1 1 1 1     3 Width 3ft   6008311.654 2097864.96994 37.7408072216699 -122.413833840154 (37.7408072216699, -122.413833840154)
52153 125934 2 58 1715 Taylor St 3 9 1 1     7 Width 4ft   6008711.31794 2118818.3670900003 37.7983627993626 -122.41393383309799 (37.7983627993626, -122.413933833098)
133308 222682 2 58 2 Trainor St 12 1 1 1     2 Width 3ft   6008292.2753800005 2108046.95875 37.768763565716704 -122.41462120290501 (37.7687635657167, -122.414621202905)
94233 115439 1 58 77 Mirabel Ave 1 1 1 1   02/01/2016 12:00:00 AM 3   Permit Number 777507 6007860.5 2100030.9 37.746729037116104 -122.41554707594 (37.7467290371161, -122.41554707594)
125305 222705 2 58 77 Mirabel Ave 1 1 1 1     3 Width 3ft   6007841.33022 2100005.82897 37.74665912012979 -122.41561158852899 (37.7466591201298, -122.415611588529)
117432 107476 2 58 69 Mirabel Ave   1 1 1   09/15/2014 12:00:00 AM 3 10x6 Permit Number 773500 6007782.9107099995 2100032.55813 37.746729228385895 -122.41581549012899 (37.7467292283859, -122.415815490129)
135290 222704 2 58 69 Mirabel Ave 1 1 1 1     2 Width 3ft   6007772.24851 2100018.26139 37.746689373329296 -122.415851346858 (37.7466893733293, -122.415851346858)
115834 246707 2 58 1 Bonview St 13 2 1 1     4     6007720.78655 2099148.69396 37.744298842209 -122.415967729029 (37.744298842209, -122.415967729029)
53901 222695 2 58 52 Mirabel Ave 1 1 1 1     1 Width 3ft   6007649.81084 2099951.99688 37.746500541785394 -122.416270032545 (37.7465005417854, -122.416270032545)
145814 106327 1 58 37 Elsie St   1 1 1       3X3 Permit Number 772574 6007569.3 2099210.3 37.7444594805766 -122.4164959017 (37.7444594805766, -122.4164959017)
51309 222685 2 58 145 Coso Ave 2 9 1 1     5     6007512.1231 2099620.66206 37.74558302735271 -122.41672267392201 (37.7455830273527, -122.416722673922)
155156 125935 2 58 1132 Greenwich St 2 7 1 1     9     6007463.08276 2119890.85277 37.8012373932575 -122.418329199431 (37.8012373932575, -122.418329199431)
19241 116677 3 58 100 Esmeralda Ave 16 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
127057 116678 3 58 100 Esmeralda Ave 17 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
Powered by Datasette · Query took 5.356ms · Data source: data.sfgov.org