Street_Tree_List

Data source: data.sfgov.org

3,888 rows where qSpecies = 22 sorted by PlotSize

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▼ PermitNotes XCoord YCoord Latitude Longitude Location
125 119758 Undocumented 2 Maytenus boaria :: Mayten 22 151X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
130 66855 Permitted Site 1 Maytenus boaria :: Mayten 22 2041 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/15/1991 12:00:00 AM 8   Permit Number 30161 5998071.2779 2109932.9259 37.7733624072524 -122.450110663343 (37.7733624072524, -122.450110663343)
1950 252823 Significant Tree 6 Maytenus boaria :: Mayten 22 3852 17th St 2 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
3501 247943 Planning Code 138.1 required 4 Maytenus boaria :: Mayten 22 29 Joy St 6 Unaccepted Street : Yard 14 Tree 1 DPW 2     2   Permit Number 775404 6010304.2598 2098903.51059 37.7437705318851 -122.407017307297 (37.7437705318851, -122.407017307297)
3735 63212 Permitted Site 1 Maytenus boaria :: Mayten 22 450 38th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1986 12:00:00 AM 10   Permit Number 23755 5984123.0 2112760.0 37.7803166927985 -122.498567828267 (37.7803166927985, -122.498567828267)
9572 100227 Undocumented 2 Maytenus boaria :: Mayten 22 542 Valley St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30   Permit Number 769993 6002426.0 2099190.0 37.7441131524814 -122.434278904907 (37.7441131524814, -122.434278904907)
9674 61426 Permitted Site 1 Maytenus boaria :: Mayten 22 3501X 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/05/1984 12:00:00 AM     Permit Number 21355 6006351.47468928 2100870.60661273 37.7489497429973 -122.420824749243 (37.7489497429973, -122.420824749243)
9704 104747 Undocumented 2 Maytenus boaria :: Mayten 22 2-X FORD ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12     6003502.9 2105705.5 37.762064243675106 -122.431020153892 (37.7620642436751, -122.431020153892)
10074 60000 Permitted Site 1 Maytenus boaria :: Mayten 22 1227 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/25/2017 12:00:00 AM 3   Permit Number 19486 5991400.84514705 2107067.03072332 37.76510946688521 -122.472975370228 (37.7651094668852, -122.472975370228)
10328 51740 Permitted Site 1 Maytenus boaria :: Mayten 22 2034 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/24/2005 12:00:00 AM 4   Permit Number 48017 5989452.1138 2101481.869 37.7496610947618 -122.479306857855 (37.7496610947618, -122.479306857855)
11717 61760 Permitted Site 1 Maytenus boaria :: Mayten 22 3739 Landers St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/19/1984 12:00:00 AM     Permit Number 21774          
11810 30642 Permitted Site 1 Maytenus boaria :: Mayten 22 1500 Houston St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/1995 12:00:00 AM     Permit Number 34585          
13258 60325 Permitted Site 1 Maytenus boaria :: Mayten 22 335 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/2017 12:00:00 AM 3   Permit Number 779431 5986505.891009999 2113659.48607 37.7829258811438 -122.49039060665001 (37.7829258811438, -122.49039060665)
15410 30596 Permitted Site 1 Maytenus boaria :: Mayten 22 451 Walter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/26/1995 12:00:00 AM     Permit Number 34563          
16505 30597 Permitted Site 1 Maytenus boaria :: Mayten 22 461 Walter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/26/1995 12:00:00 AM     Permit Number 34564          
17866 52082 Permitted Site 1 Maytenus boaria :: Mayten 22 138 Whitney St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/17/2005 12:00:00 AM     Permit Number 48280 6004279.40612984 2097417.63926751 37.7393516795249 -122.427743978882 (37.7393516795249, -122.427743978882)
18038 69250 Permitted Site 1 Maytenus boaria :: Mayten 22 1838 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/04/1994 12:00:00 AM     Permit Number 33318 5991599.04334449 2102860.56941142 37.75357110789611 -122.471983242544 (37.7535711078961, -122.471983242544)
18073 34608 Permitted Site 1 Maytenus boaria :: Mayten 22 3201 Washington St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1997 12:00:00 AM     Permit Number 38293 5999396.5502932 2115980.32977494 37.7900427611316 -122.445961414408 (37.7900427611316, -122.445961414408)
18084 46314 Permitted Site 1 Maytenus boaria :: Mayten 22 232 Miguel St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/06/2002 12:00:00 AM     Permit Number 44568 6004150.97651676 2096753.27523133 37.737520221240295 -122.42814069810801 (37.7375202212403, -122.428140698108)
18566 60665 Permitted Site 1 Maytenus boaria :: Mayten 22 252 Whitney St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/12/1983 12:00:00 AM     Permit Number 20299 6004348.3258315995 2096924.2789461997 37.738000922583396 -122.427470547071 (37.7380009225834, -122.427470547071)
18685 63020 Permitted Site 1 Maytenus boaria :: Mayten 22 114 Wool St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/23/1986 12:00:00 AM     Permit Number 23436 6007353.07984272 2097681.79796769 37.740250392327496 -122.41713526229499 (37.7402503923275, -122.417135262295)
18787 52295 Permitted Site 1 Maytenus boaria :: Mayten 22 170 Eureka St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/01/2005 12:00:00 AM     Permit Number 48456 6001395.21232185 2104838.80194346 37.7595648477135 -122.438247725187 (37.7595648477135, -122.438247725187)
18884 61111 Permitted Site 1 Maytenus boaria :: Mayten 22 2916 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/10/1983 12:00:00 AM     Permit Number 20958 6008785.97486998 2103345.01468126 37.755880830837604 -122.41258110159201 (37.7558808308376, -122.412581101592)
19007 15590 DPW Maintained 3 Maytenus boaria :: Mayten 22 3215 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/10/2004 12:00:00 AM 6     6006582.7955 2099541.6385 37.7453137333046 -122.41993054619499 (37.7453137333046, -122.419930546195)
19351 67808 Permitted Site 1 Maytenus boaria :: Mayten 22 4 Hoffman Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/17/1992 12:00:00 AM     Permit Number 31459 6000553.20461336 2102855.81352911 37.754072119422 -122.44101753615801 (37.754072119422, -122.441017536158)
19359 38905 Permitted Site 1 Maytenus boaria :: Mayten 22 617 Spruce St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/02/1998 12:00:00 AM     Permit Number 40718 5997126.04960675 2113686.45872815 37.783614490579296 -122.453651409956 (37.7836144905793, -122.453651409956)
19558 52414 Permitted Site 1 Maytenus boaria :: Mayten 22 3180 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/20/2005 12:00:00 AM     Permit Number 48533 6006685.96266598 2099861.46080956 37.7461977049098 -122.41959649754601 (37.7461977049098, -122.419596497546)
19846 52323 Permitted Site 1 Maytenus boaria :: Mayten 22 4437EUREKA 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/05/2005 12:00:00 AM     Permit Number 48476 6001658.45435831 2104067.04414381 37.7574607564447 -122.43728204425699 (37.7574607564447, -122.437282044257)
20074 54875 Permitted Site 1 Maytenus boaria :: Mayten 22 300 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/24/2004 12:00:00 AM     Permit Number 25697 6005109.34291576 2109921.18465674 37.7737303986235 -122.42576415810301 (37.7737303986235, -122.425764158103)
20262 68645 Permitted Site 1 Maytenus boaria :: Mayten 22 1922 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/21/1993 12:00:00 AM     Permit Number 32550 5990669.94043667 2102299.92572181 37.751977920883604 -122.475155324919 (37.7519779208836, -122.475155324919)
20370 3884 Permitted Site 1 Maytenus boaria :: Mayten 22 15 Castro St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/26/1990 12:00:00 AM 6     6002109.01321 2108516.23898 37.769702762802 -122.43604219971 (37.769702762802, -122.43604219971)
20394 63280 Permitted Site 1 Maytenus boaria :: Mayten 22 363 Lexington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/26/1987 12:00:00 AM     Permit Number 23841 6006563.98546453 2103999.80423144 37.7575537770148 -122.420311952542 (37.7575537770148, -122.420311952542)
20469 69095 Permitted Site 1 Maytenus boaria :: Mayten 22 1643 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/10/1994 12:00:00 AM     Permit Number 33110 5992753.45517617 2104281.67357461 37.757539823727704 -122.468094434883 (37.7575398237277, -122.468094434883)
22287 60883 Permitted Site 1 Maytenus boaria :: Mayten 22 770 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/11/1983 12:00:00 AM 12   Permit Number 20667 6009158.5873 2119786.8398 37.8010470949934 -122.41245463263901 (37.8010470949934, -122.412454632639)
23016 22683 DPW Maintained 3 Maytenus boaria :: Mayten 22 1391X Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     11     6003467.4183 2112420.8099 37.7805008292142 -122.43162232340201 (37.7805008292142, -122.431622323402)
23470 71021 Undocumented 2 Maytenus boaria :: Mayten 22 511 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/09/1996 12:00:00 AM 6     5990601.64729 2111881.43393 37.7782822050168 -122.476091231143 (37.7782822050168, -122.476091231143)
23568 32213 Permitted Site 1 Maytenus boaria :: Mayten 22 16 Norwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/22/1995 12:00:00 AM 5   Permit Number 35534 6009218.36931 2099496.57161 37.7453381212708 -122.410813950014 (37.7453381212708, -122.410813950014)
23744 32591 Permitted Site 1 Maytenus boaria :: Mayten 22 1367 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/1996 12:00:00 AM 5   Permit Number 37060 5985531.9989 2105934.1277 37.7616573095776 -122.493190516924 (37.7616573095776, -122.493190516924)
24226 57083 Permitted Site 1 Maytenus boaria :: Mayten 22 700 Arkansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/22/1974 12:00:00 AM 19   Permit Number 14350 6012989.82027 2103754.31377 37.7572397114663 -122.39807144786501 (37.7572397114663, -122.398071447865)
25159 66416 Permitted Site 1 Maytenus boaria :: Mayten 22 1330 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/14/1991 12:00:00 AM 10   Permit Number 29547 5988671.0008 2106260.0416 37.7627352735652 -122.482357990308 (37.7627352735652, -122.482357990308)
25441 61533 Permitted Site 1 Maytenus boaria :: Mayten 22 342 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/20/1984 12:00:00 AM 7   Permit Number 21490 5991238.8038099995 2113097.3629099997 37.78165773678771 -122.47397582980899 (37.7816577367877, -122.473975829809)
25965 61548 Permitted Site 1 Maytenus boaria :: Mayten 22 218 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/17/1984 12:00:00 AM 8   Permit Number 21506 5991210.3094 2113903.7549799997 37.7838702157395 -122.474133262259 (37.7838702157395, -122.474133262259)
25997 66081 Permitted Site 1 Maytenus boaria :: Mayten 22 963 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/08/1990 12:00:00 AM 8   Permit Number 29125 6008260.3123 2119964.4945799997 37.801484439724 -122.41557564442199 (37.801484439724, -122.415575644422)
26981 36169 Permitted Site 1 Maytenus boaria :: Mayten 22 6453 Euclid Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/04/1998 12:00:00 AM 3   Permit Number 39247 5996287.8666 2113794.1884 37.7838622010514 -122.45655897784201 (37.7838622010514, -122.456558977842)
27050 106118 Undocumented 2 Maytenus boaria :: Mayten 22 2680 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2     6000260.43777 2117853.06146 37.7952340822301 -122.44310699759701 (37.7952340822301, -122.443106997597)
27233 36171 Permitted Site 1 Maytenus boaria :: Mayten 22 6453 Euclid Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/04/1998 12:00:00 AM 4   Permit Number 39247 5996326.4467 2113794.1884 37.7838644159639 -122.456425505824 (37.7838644159639, -122.456425505824)
27829 193480 Undocumented 2 Maytenus boaria :: Mayten 22 1301 Minnesota St 57 Front Yard : Yard 7 Tree 1 Private 1     3     6015360.9836800005 2102396.38137 37.7536428990178 -122.389776125583 (37.7536428990178, -122.389776125583)
28108 33660 Permitted Site 1 Maytenus boaria :: Mayten 22 511 Linden St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/03/2001 12:00:00 AM 12   Permit Number 37748 6004957.21005 2110733.7746099997 37.7759529745959 -122.42634827696699 (37.7759529745959, -122.426348276967)
28375 58711 Permitted Site 1 Maytenus boaria :: Mayten 22 2229 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/24/1979 12:00:00 AM 10   Permit Number 17944 6002306.84269 2118435.43689 37.796949602887395 -122.43606781690201 (37.7969496028874, -122.436067816902)
28540 68532 Permitted Site 1 Maytenus boaria :: Mayten 22 704 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 8   Permit Number 32414 5994135.037269999 2110647.755 37.7750991055642 -122.463778459231 (37.7750991055642, -122.463778459231)
28929 32396 Permitted Site 1 Maytenus boaria :: Mayten 22 224 Richland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/03/1996 12:00:00 AM 8   Permit Number 36937 6005825.6534 2096103.36545 37.7358303239982 -122.422304379146 (37.7358303239982, -122.422304379146)
28970 84365 Undocumented 2 Maytenus boaria :: Mayten 22 129 Escolta Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   5     5986616.9958 2097211.3869 37.7377704195158 -122.488796798517 (37.7377704195158, -122.488796798517)
29423 61606 Permitted Site 1 Maytenus boaria :: Mayten 22 29 Tamalpais Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/1984 12:00:00 AM 6   Permit Number 21579 5998469.3177 2111579.0405 37.7779049830772 -122.44885238767799 (37.7779049830772, -122.448852387678)
29786 62315 Permitted Site 1 Maytenus boaria :: Mayten 22 626 05th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/1990 12:00:00 AM 8   Permit Number 29075 5994423.38031 2111229.7723 37.7767137814792 -122.46282325722099 (37.7767137814792, -122.462823257221)
29890 56011 Permitted Site 1 Maytenus boaria :: Mayten 22 3632 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/1973 12:00:00 AM 15   Permit Number 12093 5998868.764359999 2121280.04333 37.804564203133204 -122.448169269697 (37.8045642031332, -122.448169269697)
29966 61554 Permitted Site 1 Maytenus boaria :: Mayten 22 1254 De Haro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/25/1984 12:00:00 AM 13   Permit Number 21513 6012216.8343400005 2102544.44226 37.753874585952 -122.40065975964501 (37.753874585952, -122.400659759645)
30162 193481 Undocumented 2 Maytenus boaria :: Mayten 22 1301 Minnesota St 58 Front Yard : Yard 7 Tree 1 Private 1     4     6015360.43842 2102393.9251099997 37.753636124410896 -122.389777839677 (37.7536361244109, -122.389777839677)
30226 31673 Permitted Site 1 Maytenus boaria :: Mayten 22 147 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/1995 12:00:00 AM 6   Permit Number 35180 5987698.59874 2114990.45524 37.7866499310368 -122.48636213243 (37.7866499310368, -122.48636213243)
30324 75688 Undocumented 2 Maytenus boaria :: Mayten 22 1345 Vicente St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/14/1998 12:00:00 AM 4     5988707.2425 2097607.0331 37.738978524128704 -122.481598859375 (37.7389785241287, -122.481598859375)
30369 209572 Undocumented 2 Maytenus boaria :: Mayten 22 100 Malta Dr 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     5999439.81114 2096263.84796 37.7359086891413 -122.444394200825 (37.7359086891413, -122.444394200825)
30386 41949 Permitted Site 1 Maytenus boaria :: Mayten 22 431 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 6   Permit Number 42306 5993092.7149 2112519.1712700003 37.7801773906958 -122.467520171446 (37.7801773906958, -122.467520171446)
30535 32878 Permitted Site 1 Maytenus boaria :: Mayten 22 1483 05th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/30/1996 12:00:00 AM     Permit Number 37223 5994573.62006414 2105444.34000884 37.760837155099104 -122.461883922509 (37.7608371550991, -122.461883922509)
30967 69364 Permitted Site 1 Maytenus boaria :: Mayten 22 3530 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/18/1994 12:00:00 AM 4   Permit Number 33458 6002665.33965 2120755.09557 37.803339139460796 -122.43499331678998 (37.8033391394608, -122.43499331679)
31302 70578 Undocumented 2 Maytenus boaria :: Mayten 22 201 20th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/30/1994 12:00:00 AM 7     5989595.95127 2113926.1891900003 37.7838381644508 -122.479719921835 (37.7838381644508, -122.479719921835)
31426 61537 Permitted Site 1 Maytenus boaria :: Mayten 22 246 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/20/1984 12:00:00 AM 14   Permit Number 21495 5991216.38557 2113770.28494 37.7835040959825 -122.474102499434 (37.7835040959825, -122.474102499434)
31812 61502 Permitted Site 1 Maytenus boaria :: Mayten 22 166 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/27/1984 12:00:00 AM 8   Permit Number 21455 5989632.87408 2114250.53827 37.784730880786704 -122.479615923855 (37.7847308807867, -122.479615923855)
31861 43778 Permitted Site 1 Maytenus boaria :: Mayten 22 160 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/26/2000 12:00:00 AM 8   Permit Number 43408 5989627.89982 2114300.0227099997 37.784866462195296 -122.479636754902 (37.7848664621953, -122.479636754902)
32077 231557 Undocumented 2 Maytenus boaria :: Mayten 22 1001 San Jose Ave 43 Front Yard : Yard 7 Tree 1 Private 1     1     6005302.15218 2097157.06832 37.738694011804796 -122.424189245746 (37.7386940118048, -122.424189245746)
32441 61535 Permitted Site 1 Maytenus boaria :: Mayten 22 312 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/20/1984 12:00:00 AM 7   Permit Number 21493 5991235.06362 2113291.98998 37.7821919123157 -122.47400297330799 (37.7821919123157, -122.474002973308)
32850 103474 Undocumented 2 Maytenus boaria :: Mayten 22 310 Stanyan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2     5996780.9143 2110701.53 37.7753988700657 -122.454629724132 (37.7753988700657, -122.454629724132)
33024 61634 Permitted Site 1 Maytenus boaria :: Mayten 22 2724 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/24/1984 12:00:00 AM 13   Permit Number 21619 6000450.6837 2114479.9717 37.7859833040293 -122.442206462809 (37.7859833040293, -122.442206462809)
33041 64506 Permitted Site 1 Maytenus boaria :: Mayten 22 854 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/21/1988 12:00:00 AM 6   Permit Number 25387 6000491.15 2111950.3818 37.779040006052206 -122.441884838167 (37.7790400060522, -122.441884838167)
33493 68522 Permitted Site 1 Maytenus boaria :: Mayten 22 730 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 9   Permit Number 32402 5995377.49487 2110568.06849 37.7749518252414 -122.459474780725 (37.7749518252414, -122.459474780725)
34086 47421 Permitted Site 1 Maytenus boaria :: Mayten 22 866 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 7   Permit Number 45332 5984821.2395 2109952.74159 37.7726496913879 -122.49594517660299 (37.7726496913879, -122.495945176603)
34254 73145 Undocumented 2 Maytenus boaria :: Mayten 22 560 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/09/1999 12:00:00 AM 8     5991294.46609 2111590.92928 37.777524708179 -122.473673341879 (37.777524708179, -122.473673341879)
34941 47437 Permitted Site 1 Maytenus boaria :: Mayten 22 719 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 7   Permit Number 45348 5982882.50188 2110871.8928099996 37.7750596744967 -122.50271941529101 (37.7750596744967, -122.502719415291)
35295 51372 Permitted Site 1 Maytenus boaria :: Mayten 22 668 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/12/2004 12:00:00 AM 4   Permit Number 47706 5990371.65679 2110906.02605 37.775590664864396 -122.47681555893 (37.7755906648644, -122.47681555893)
36362 209568 Undocumented 2 Maytenus boaria :: Mayten 22 100 Malta Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     5999462.29955 2096158.98515 37.735622043705 -122.444308916343 (37.735622043705, -122.444308916343)
36404 47204 Permitted Site 1 Maytenus boaria :: Mayten 22 325 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2002 12:00:00 AM 6   Permit Number 45158 5986194.00617 2113731.94668 37.7831066164686 -122.491474919013 (37.7831066164686, -122.491474919013)
36549 64652 Permitted Site 1 Maytenus boaria :: Mayten 22 2517 Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/1988 12:00:00 AM 6   Permit Number 25572 6004472.75139 2117936.0093900003 37.7957011127613 -122.428537637801 (37.7957011127613, -122.428537637801)
36725 66568 Permitted Site 1 Maytenus boaria :: Mayten 22 38 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/15/1991 12:00:00 AM 11   Permit Number 29757 6005049.36388 2093286.73989 37.7280526775706 -122.42478800357401 (37.7280526775706, -122.424788003574)
36758 193478 Undocumented 2 Maytenus boaria :: Mayten 22 1301 Minnesota St 22 Front Yard : Yard 7 Tree 1 Private 1     7     6015377.93979 2102408.26653 37.7536764734156 -122.389718317152 (37.7536764734156, -122.389718317152)
36775 67683 Permitted Site 1 Maytenus boaria :: Mayten 22 1184 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1992 12:00:00 AM 16   Permit Number 31287 6001136.68439 2087160.96282 37.711010903415605 -122.437875656534 (37.7110109034156, -122.437875656534)
36808 32071 Permitted Site 1 Maytenus boaria :: Mayten 22 3685 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1995 12:00:00 AM 5   Permit Number 35445 6004358.206259999 2105972.09439 37.7628446758751 -122.428080978282 (37.7628446758751, -122.428080978282)
36892 193483 Undocumented 2 Maytenus boaria :: Mayten 22 1301 Minnesota St 60 Front Yard : Yard 7 Tree 1 Private 1     5     6015357.60434 2102388.55358 37.753621218165605 -122.38978726547501 (37.7536212181656, -122.389787265475)
36953 73444 Undocumented 2 Maytenus boaria :: Mayten 22 1353 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/13/1994 12:00:00 AM 10     6006988.50126 2115333.88055 37.7886983590984 -122.419647955393 (37.7886983590984, -122.419647955393)
37036 50479 Permitted Site 1 Maytenus boaria :: Mayten 22 2985 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/29/2003 12:00:00 AM 8   Permit Number 47115 5999895.67434 2116705.2773599997 37.7920617651015 -122.44428661046001 (37.7920617651015, -122.44428661046)
37122 56646 Permitted Site 1 Maytenus boaria :: Mayten 22 108 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13     5993676.27221 2114752.19783 37.7863423489505 -122.46566367623998 (37.7863423489505, -122.46566367624)
37731 60807 Permitted Site 1 Maytenus boaria :: Mayten 22 2023 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/02/1983 12:00:00 AM 8   Permit Number 20484 5989711.5047 2101567.8863 37.749912337728404 -122.47841617358401 (37.7499123377284, -122.478416173584)
37770 31798 Permitted Site 1 Maytenus boaria :: Mayten 22 39 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/1995 12:00:00 AM 5   Permit Number 35268 6001935.84631 2107865.07775 37.7679049955509 -122.436594562416 (37.7679049955509, -122.436594562416)
37773 44184 Permitted Site 1 Maytenus boaria :: Mayten 22 128 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/19/2000 12:00:00 AM 5   Permit Number 43646 5987739.153609999 2115125.7226400003 37.787023700339205 -122.486231758107 (37.7870237003392, -122.486231758107)
37990 62323 Permitted Site 1 Maytenus boaria :: Mayten 22 737 05th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/1985 12:00:00 AM 12   Permit Number 22465 5994405.29719 2110517.95963 37.7747582919092 -122.46283415917 (37.7747582919092, -122.46283415917)
38002 66708 Permitted Site 1 Maytenus boaria :: Mayten 22 374 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/1991 12:00:00 AM 10   Permit Number 29946 5986555.96764 2113423.78185 37.7822816295299 -122.490200020975 (37.7822816295299, -122.490200020975)
38162 70662 Undocumented 2 Maytenus boaria :: Mayten 22 472 Utah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/17/1994 12:00:00 AM 7     6010616.59856 2106126.86555 37.7636217386735 -122.40644618745701 (37.7636217386735, -122.406446187457)
38491 60086 Permitted Site 1 Maytenus boaria :: Mayten 22 1267 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/16/1982 12:00:00 AM 8   Permit Number 19587 5988920.1528 2106715.7793 37.764001095368 -122.48152965117201 (37.764001095368, -122.481529651172)
38792 209609 Undocumented 2 Maytenus boaria :: Mayten 22 562 Bright St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     5993802.84348 2090885.4872 37.7208177899974 -122.463493089652 (37.7208177899974, -122.463493089652)
38952 31604 Permitted Site 1 Maytenus boaria :: Mayten 22 1824 Pacheco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/10/1995 12:00:00 AM 6   Permit Number 35130 5989288.7965 2101763.3696 37.7504245340331 -122.47989220563299 (37.7504245340331, -122.479892205633)
39048 33235 Permitted Site 1 Maytenus boaria :: Mayten 22 2512 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/07/1996 12:00:00 AM 2   Permit Number 37421 5988636.4412 2098175.1069 37.7405341892879 -122.48188525576799 (37.7405341892879, -122.481885255768)
39224 44403 Permitted Site 1 Maytenus boaria :: Mayten 22 1171 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/23/2001 12:00:00 AM 5   Permit Number 43757 6001229.01614 2087080.5529 37.7107953655799 -122.437550781868 (37.7107953655799, -122.437550781868)
39311 193482 Undocumented 2 Maytenus boaria :: Mayten 22 1301 Minnesota St 59 Front Yard : Yard 7 Tree 1 Private 1     7     6015356.53951 2102391.04268 37.7536279936584 -122.38979112177 (37.7536279936584, -122.38979112177)

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 2256.373ms · Data source: data.sfgov.org