sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
161999 218270 2 20 1456 Portola Dr 1 2 1 1     15 Width 5ft   5992782.12061 2097251.65776 37.73823885594471 -122.46748409202 (37.7382388559447, -122.46748409202)
84733 116949 2 20 123 WEST PORTAL AVE 2 1 1 1       3x3   5992936.0 2097647.0 37.7393332491746 -122.46698079132099 (37.7393332491746, -122.466980791321)
121155 116948 2 20 123 WEST PORTAL AVE 1 1 1 1       3x3   5992936.0 2097647.0 37.7393332491746 -122.46698079132099 (37.7393332491746, -122.466980791321)
110263 52957 1 20 227 Ramsell St 1 1 1 1 1 08/03/2006 12:00:00 AM     Permit Number 48944 5992946.65383726 2088708.6513983002 37.714791356792 -122.46629453065701 (37.714791356792, -122.466294530657)
131290 204620 2 20 1440 10th Ave 1 1 1 1     8 Width 2ft   5993064.41106 2105672.78897 37.7613774166458 -122.467120173251 (37.7613774166458, -122.467120173251)
80681 110721 2 20 1898X 10th Ave 2 1 1 1           5993137.43282 2102888.05903 37.753735486992 -122.466665198088 (37.753735486992, -122.466665198088)
123646 110722 2 20 1898X 10th Ave 3 1 1 1           5993137.43282 2102888.05903 37.753735486992 -122.466665198088 (37.753735486992, -122.466665198088)
126160 110720 2 20 1898X 10th Ave 1 1 1 1           5993137.43282 2102888.05903 37.753735486992 -122.466665198088 (37.753735486992, -122.466665198088)
82665 39219 1 20 347 Victoria St 1 1 1 1   11/30/1998 12:00:00 AM     Permit Number 40862 5993215.94072133 2089494.769314 37.7169653816902 -122.465420843024 (37.7169653816902, -122.465420843024)
28372 204655 2 20 452 Victoria St 1 4 1 1     5 Width 3ft   5993265.60688 2090192.2995 37.7188834957636 -122.46529981143298 (37.7188834957636, -122.465299811433)
120200 47376 1 20 454 Victoria St 1 1 1 1 1 05/13/2002 12:00:00 AM     Permit Number 45293 5993277.02762299 2090193.33113846 37.718886987019 -122.46526040964899 (37.718886987019, -122.465260409649)
32793 67326 1 20 714 Balboa St 1 1 1 1 1 07/15/1992 12:00:00 AM 12   Permit Number 30809 5993329.61616 2111427.9815700003 37.7771949529998 -122.466621290245 (37.7771949529998, -122.466621290245)
103622 48643 1 20 1481 09th Ave 1 1 1 1 1 08/30/2002 12:00:00 AM     Permit Number 45936 5993334.71771315 2105415.01360696 37.7606852319988 -122.466166570005 (37.7606852319988, -122.466166570005)
187499 204621 2 20 1481 09th Ave 1 1 1 1     5 Width 2ft   5993335.30038 2105432.94132 37.7607344904344 -122.466165857685 (37.7607344904344, -122.466165857685)
27101 124082 2 20 3220 Fulton St 2 1 1 1     9 Width 3ft   5993384.863369999 2110069.41246 37.773467874758296 -122.466331413768 (37.7734678747583, -122.466331413768)
31785 124081 2 20 3220 Fulton St 1 1 1 1     7 Width 3ft   5993396.8995199995 2110067.15404 37.7734623682136 -122.46628961516399 (37.7734623682136, -122.466289615164)
154732 204656 2 20 201 Sargent St 1 4 1 1     12 Width 3ft   5993464.3561 2089166.2811200002 37.716077755750206 -122.464538359982 (37.7160777557502, -122.464538359982)
60672 204624 2 20 1830 09th Ave 1 1 1 1     6 Width 3ft   5993464.78312 2103004.20884 37.7540732902536 -122.465541593278 (37.7540732902536, -122.465541593278)
173962 123230 2 20 785 08th Ave 2 1 1 1     5 Width 3ft   5993487.30033 2110174.28885 37.7737617473343 -122.465984694601 (37.7737617473343, -122.465984694601)
154132 123824 2 20 1665 Anza St 1 1 1 1     10 Width 3ft   5993487.5757 2112056.30859 37.7789292839599 -122.466120533372 (37.7789292839599, -122.466120533372)
156878 56952 1 20 795 08th Ave 1 1 1 1   08/27/1974 12:00:00 AM 7   Permit Number 14204 5993489.41899 2110144.08424 37.7736789357713 -122.465975170673 (37.7736789357713, -122.465975170673)
150124 123229 2 20 785 08th Ave 1 1 1 1     7 Width 3ft   5993489.53527 2110160.53271 37.773724105582296 -122.465975963885 (37.7737241055823, -122.465975963885)
113808 89718 3 20 1655 Anza St 1 1 1 2   02/08/2008 12:00:00 AM 3 3x3   5993507.69164 2112056.80986 37.778931820846296 -122.46605098131501 (37.7789318208463, -122.466050981315)
172522 204657 2 20 2200 Mesa Ave 2 2 1 1     4 Width 3ft   5993588.18999 2100755.25284 37.7479053493615 -122.46495150490601 (37.7479053493615, -122.464951504906)
169508 204622 2 20 1518 08th Ave 1 1 1 1     9 Width 3ft   5993700.04012 2105141.70568 37.7599558699739 -122.46488324546499 (37.7599558699739, -122.464883245465)
147889 204616 2 20 621 Lincoln Way 1 1 1 1     3 Width 2ft   5993775.2241 2107303.2691599997 37.7658952931499 -122.46478019575198 (37.7658952931499, -122.464780195752)
24896 204623 2 20 1880 08th Ave 3 1 1 1     13 Width 3ft   5993786.05175 2102711.73048 37.7532887441949 -122.46440934321801 (37.7532887441949, -122.464409343218)
149380 204617 2 20 621 Lincoln Way 2 1 1 1     4 Width 2ft   5993792.5560800005 2107303.5698 37.7658971178728 -122.464720270343 (37.7658971178728, -122.464720270343)
9115 90912 1 20 545 Cabrillo St 1 1 1 1   02/20/2008 12:00:00 AM 3 3x3   5993886.17439 2110710.21085 37.775256248873895 -122.464643860229 (37.7752562488739, -122.464643860229)
87473 121683 2 20 1645 07th Ave 2 1 1 1       3x3   5993978.0 2104308.0 37.757682752419896 -122.46386140871401 (37.7576827524199, -122.463861408714)
141162 121682 2 20 1645 07th Ave 1 1 1 1       3x3   5993978.0 2104308.0 37.757682752419896 -122.46386140871401 (37.7576827524199, -122.463861408714)
86680 39663 1 20 901 Grafton Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41054 5994040.07409456 2090558.08173508 37.719932478931796 -122.46264932396299 (37.7199324789318, -122.462649323963)
90504 39664 1 20 901 Grafton Ave 2 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41054 5994040.07409456 2090558.08173508 37.719932478931796 -122.46264932396299 (37.7199324789318, -122.462649323963)
67938 204649 2 20 508 Orizaba Ave 1 1 1 1     2 Width 2ft   5994044.084530001 2090032.62859 37.7184899416364 -122.46259736577 (37.7184899416364, -122.46259736577)
92664 39671 1 20 500 Orizaba Ave 2 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41059 5994056.18580091 2089950.78311256 37.7182659104704 -122.462549603412 (37.7182659104704, -122.462549603412)
99326 39673 1 20 500 Orizaba Ave 4 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41059 5994056.18580091 2089950.78311256 37.7182659104704 -122.462549603412 (37.7182659104704, -122.462549603412)
112900 39672 1 20 500 Orizaba Ave 3 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41059 5994056.18580091 2089950.78311256 37.7182659104704 -122.462549603412 (37.7182659104704, -122.462549603412)
127185 39670 1 20 500 Orizaba Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41059 5994056.18580091 2089950.78311256 37.7182659104704 -122.462549603412 (37.7182659104704, -122.462549603412)
82360 39674 1 20 510 Orizaba Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41060 5994056.62807806 2090013.39911729 37.718437864492394 -122.462552614145 (37.7184378644924, -122.462552614145)
107272 39648 1 20 111 Ashton Ave 1 1 1 1 1 05/25/2002 12:00:00 AM     Permit Number 41042 5994130.09830184 2090661.11089351 37.720220556524204 -122.462345612464 (37.7202205565242, -122.462345612464)
145840 39649 1 20 111 Ashton Ave 2 1 1 1   12/29/1998 12:00:00 AM 5 3x20 Permit Number 41042 5994130.09830184 2090661.11089351 37.720220556524204 -122.462345612464 (37.7202205565242, -122.462345612464)
54422 204645 2 20 111 Ashton Ave 1 1 1 1     6 Width 3ft   5994132.807630001 2090689.3393400002 37.7202982210683 -122.462338293601 (37.7202982210683, -122.462338293601)
107581 39652 1 20 141 Ashton Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41045 5994132.92951736 2090837.78725757 37.7207058303918 -122.462348633516 (37.7207058303918, -122.462348633516)
164499 204646 2 20 111 Ashton Ave 3 2 1 1     5 Width 3ft   5994133.91606 2090657.47285 37.7202107871682 -122.462332152117 (37.7202107871682, -122.462332152117)
65031 204644 2 20 150 Ashton Ave 1 1 1 1     4 Width 3ft   5994179.89282 2090937.7889 37.7209831150476 -122.46219354590099 (37.7209831150476, -122.462193545901)
103711 39650 1 20 114 Ashton Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41043 5994182.55528924 2090689.21166175 37.7203007349832 -122.462166324336 (37.7203007349832, -122.462166324336)
139952 39653 1 20 150 Ashton Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41046 5994186.17432148 2090915.05015887 37.7209210416097 -122.462170184545 (37.7209210416097, -122.462170184545)
107537 39654 1 20 326 Ashton Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41047 5994205.8673586 2092067.47591786 37.7240864587641 -122.46218564714898 (37.7240864587641, -122.462185647149)
158419 204619 2 20 1367 06th Ave 1 1 1 1     12 Width 2ft   5994238.00536 2106214.43805 37.762932317501004 -122.463100533768 (37.762932317501, -122.463100533768)
170503 204618 2 20 1379 06th Ave 1 1 1 1     12 Width 3ft   5994241.53027 2106136.0721 37.7627173480462 -122.463082656152 (37.7627173480462, -122.463082656152)
105338 54365 1 20 1426 06th Ave 1 1 1 1   06/20/1972 12:00:00 AM     Permit Number 10129 5994302.95595576 2105800.34386055 37.7617990637215 -122.46284585058999 (37.7617990637215, -122.46284585059)
106992 54367 1 20 1434 06th Ave 1 1 1 1   06/20/1972 12:00:00 AM     Permit Number 10133 5994304.74891037 2105748.22696325 37.7616560675176 -122.462835868431 (37.7616560675176, -122.462835868431)
109326 54368 1 20 1440 06th Ave 1 1 1 1   06/20/1972 12:00:00 AM   4x6 Permit Number 10134 5994306.09362611 2105709.13929636 37.76154882037861 -122.462828381839 (37.7615488203786, -122.462828381839)
92646 54369 1 20 1444 06th Ave 1 1 1 1   06/20/1972 12:00:00 AM   4x6 Permit Number 10135 5994306.99010384 2105683.08083554 37.761477322240005 -122.462823390787 (37.76147732224, -122.462823390787)
18373 54772 1 20 1446 06th Ave 1 1 1 1   07/25/1972 12:00:00 AM   4x5 Permit Number 10621 5994307.43834186 2105670.05162948 37.7614415732371 -122.46282089526899 (37.7614415732371, -122.462820895269)
82171 46798 1 20 151 Maywood Dr 1 1 1 1 1 04/25/2002 12:00:00 AM     Permit Number 44888 5994310.21524684 2095607.50798883 37.7338125312017 -122.46208153607701 (37.7338125312017, -122.462081536077)
109661 100285 1 20 1426 06th Ave 2 1 1 1         Permit Number 10129 5994323.3 2105790.0 37.761771833907794 -122.462774738749 (37.7617718339078, -122.462774738749)
89747 39705 1 20 85 El Verano Way 2 1 1 1 1 01/05/1999 12:00:00 AM     Permit Number 41089 5994595.05199927 2094752.76443113 37.7314820102104 -122.461034845634 (37.7314820102104, -122.461034845634)
95766 39704 1 20 85 El Verano Way 1 1 1 1 1 01/05/1999 12:00:00 AM     Permit Number 41089 5994595.05199927 2094752.76443113 37.7314820102104 -122.461034845634 (37.7314820102104, -122.461034845634)
90190 59352 1 20 469 Faxon Ave 1 1 1 1   11/19/1980 12:00:00 AM 11 4x4 Permit Number 18701 5994737.99829015 2091686.56057322 37.7230711817022 -122.460318578759 (37.7230711817022, -122.460318578759)
133067 204658 2 20 99 Fernwood Dr 1 1 1 1     21 Width 3ft   5994773.2638 2095284.74721 37.732952958415105 -122.46045727068001 (37.7329529584151, -122.46045727068)
4156 213178 1 20 629 Grafton Ave 1 1 1 1   10/06/2017 08:23:00 AM 3 Width 3ft Permit Number 20774 5994856.22066 2090552.89382 37.7199652039099 -122.45982783161502 (37.7199652039099, -122.459827831615)
117199 51289 1 20 875 Capitol Ave 1 1 1 1   08/26/2004 12:00:00 AM     Permit Number 47661 5995029.72941729 2089837.87433116 37.718011907210204 -122.45917632673999 (37.7180119072102, -122.45917632674)
112096 51290 1 20 738 Capitol Ave 1 1 1 1   08/26/2004 12:00:00 AM     Permit Number 47662 5995079.16819472 2089446.39884805 37.716939850408394 -122.458977110473 (37.7169398504084, -122.458977110473)
38724 204643 2 20 290 Miramar Ave 1 1 1 1     1 Width 3ft   5995381.41136 2092014.7979700002 37.7240094335681 -122.458118187113 (37.7240094335681, -122.458118187113)
113716 35090 1 20 122 Hugo St 1 1 1 1 1 05/03/2003 12:00:00 AM     Permit Number 38632 5995399.98940883 2107075.75682232 37.7653641436682 -122.459144031764 (37.7653641436682, -122.459144031764)
175753 204641 2 20 290 Granada Ave 2 1 1 1     1 Width 3ft   5995679.43604 2091904.4278 37.7237235031239 -122.45707998907601 (37.7237235031239, -122.457079989076)
54861 204642 2 20 290 Granada Ave 7 1 1 1     5 Width 4ft   5995680.91746 2091957.8181099999 37.7238701852543 -122.457078728228 (37.7238701852543, -122.457078728228)
78376 36468 1 20 1469 Plymouth Ave 1 1 1 1 1 05/18/1998 12:00:00 AM     Permit Number 39366 5995883.06149021 2093810.4895036 37.728968784247705 -122.456513863949 (37.7289687842477, -122.456513863949)
110193 41345 1 20 733 Plymouth Ave 1 1 1 1   03/03/2000 12:00:00 AM     Permit Number 41999 5995888.07123287 2089420.5370121002 37.716915305937796 -122.4561792734 (37.7169153059378, -122.4561792734)
32795 204648 2 20 733 Plymouth Ave 1 1 1 1     12 Width 2ft   5995892.41562 2089491.7886299998 37.71711119551271 -122.456169405709 (37.7171111955127, -122.456169405709)
144749 16346 3 20 900X Monterey Blvd 4 11 1 2   01/19/2013 12:00:00 AM 3 5   5996119.1686597 2094698.5315602 37.7314206866198 -122.45576179592301 (37.7314206866198, -122.455761795923)
134307 204647 2 20 64 Montana St 1 1 1 1     6 Width 2ft   5996124.76777 2089322.40375 37.716659439069794 -122.455354045254 (37.7166594390698, -122.455354045254)
80412 99239 1 20 940 Laguna Honda Blvd   1 1 1   05/22/2012 12:00:00 AM     Permit Number 768814 5996167.3 2098870.1 37.7428775588654 -122.45589685275 (37.7428775588654, -122.45589685275)
121726 106704 2 20 179 BRIGHTON AVE 1 1 1 1     12 3x3   5996189.7 2091071.1 37.7214646729593 -122.45525590980199 (37.7214646729593, -122.455255909802)
80689 106706 2 20 199X BRIGHTON AVE 2 1 1 1     10 3x3   5996224.0 2090880.0 37.7209419254054 -122.455123542447 (37.7209419254054, -122.455123542447)
146237 41633 1 20 100 Jordan Ave 3 1 1 1   06/01/2000 12:00:00 AM     Permit Number 42113 5996241.92564567 2113793.75965037 37.7838583861175 -122.456717884501 (37.7838583861175, -122.456717884501)
61227 140862 2 20 100 Jordan Ave 3 2 1 1     2 Width 0ft   5996243.3642 2113769.3144 37.783791348572706 -122.456711139169 (37.7837913485727, -122.456711139169)
115519 46180 1 20 321 Parnassus Ave 1 1 1 1 1 12/28/2001 12:00:00 AM     Permit Number 44508 5996626.00544099 2106611.60599874 37.7641601102413 -122.45487001246599 (37.7641601102413, -122.454870012466)
10145 173881 2 20 1245 Willard St 1 1 1 1       3x3   5996703.0 2107106.0 37.7655220059747 -122.45463943175601 (37.7655220059747, -122.454639431756)
75181 66828 1 20 154 Beaumont Ave 1 1 1 1 1 01/22/1992 12:00:00 AM 5   Permit Number 30314 5996849.4776 2111929.315 37.7787739785332 -122.454481262068 (37.7787739785332, -122.454481262068)
4201 252891 2 20 300x Howth St 1 1 1 1   10/10/2017 04:13:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4203 252894 2 20 300x Howth St 4 1 1 1   10/10/2017 04:10:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4213 252892 2 20 300x Howth St 2 1 1 1   10/10/2017 04:08:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4246 252893 2 20 300x Howth St 3 1 1 1   10/10/2017 04:25:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4212 204652 2 20 324 Howth St 1 1 1 1   10/10/2017 03:45:00 PM 3 Width 3ft   5997137.29551 2090290.56774 37.719375836806705 -122.45192406695601 (37.7193758368067, -122.451924066956)
106583 46402 1 20 324 Howth St 1 1 1 1 1 03/05/2002 12:00:00 AM     Permit Number 44632 5997151.20329152 2090327.07955038 37.7194768863059 -122.451878625824 (37.7194768863059, -122.451878625824)
4291 252895 2 20 790x Mount Vernon Ave 1 1 1 1   10/10/2017 03:29:00 PM 3 3x3   5997282.0 2090432.0 37.719772464034904 -122.45143407539 (37.7197724640349, -122.45143407539)
181555 204650 2 20 254 Howth St 1 4 1 1     11 Width 3ft   5997292.004269999 2090577.4247599998 37.720172339354704 -122.451409977591 (37.7201723393547, -122.451409977591)
43337 204651 2 20 27 Majestic Ave 1 4 1 1     6 Width 3ft   5997399.75585 2089775.82239 37.7179774953307 -122.45097974552401 (37.7179774953307, -122.450979745524)
13269 187626 2 20 298x Molimo Dr 1 5 1 1       3x3   5997428.0 2096652.0 37.7368594694916 -122.451377782024 (37.7368594694916, -122.451377782024)
72610 204630 2 20 304 Gennessee St 1 1 1 1     13 Width 2ft   5997471.23605 2094490.2943 37.7309264189197 -122.45107245665501 (37.7309264189197, -122.451072456655)
188602 204669 2 20 582 Mangels Ave 3 1 1 1     8 Width 2ft   5997556.3797699995 2095278.95948 37.7330967797945 -122.45083494657 (37.7330967797945, -122.45083494657)
67823 246058 2 20 610 Shrader St 1 1 1 1     8 Width 0ft   5997562.1198 2108443.0956 37.769242567665295 -122.451764409004 (37.7692425676653, -122.451764409004)
41865 204668 2 20 582 Mangels Ave 2 1 1 1     8 Width 2ft   5997569.23018 2095279.46651 37.7330989075946 -122.45079055604499 (37.7330989075946, -122.450790556045)
63204 204667 2 20 582 Mangels Ave 1 1 1 1     9 Width 2ft   5997581.48097 2095279.2111 37.7330989075759 -122.45074818359899 (37.7330989075759, -122.450748183599)
73619 248397 2 20 710 Shrader St 1 1 1 1     3 Width 0ft   5997610.5725 2108098.1732 37.7682982739336 -122.451571931383 (37.7682982739336, -122.451571931383)
63668 175754 2 20 12 Farragut Ave 1 1 1 1     4 Width 2ft   5997730.99268 2086963.4604 37.7102743532383 -122.449632264321 (37.7102743532383, -122.449632264321)
7114 45767 1 20 99 Blake St 1 1 1 1 1 04/02/2002 12:00:00 AM 5 3x3 Permit Number 44690 5997811.6954 2113198.143 37.782312986330794 -122.45124412099399 (37.7823129863308, -122.451244120994)
7399 45765 1 20 99 Blake St 2 1 1 1   04/02/2002 12:00:00 AM 5 3x3 Permit Number 44690 5997815.0796 2113173.4382 37.782245347199996 -122.451230630986 (37.7822453472, -122.451230630986)
47824 204629 2 20 223 Molimo Dr 1 1 1 1     21 Width 2ft   5997855.18506 2096638.3314 37.7368463906537 -122.449899836933 (37.7368463906537, -122.449899836933)
Powered by Datasette · Query took 10.677ms · Data source: data.sfgov.org