Street_Tree_List

Data source: data.sfgov.org

953 rows where qSpecies = 94 sorted by qSiteInfo

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo ▼ PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
543 224593 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3131 16th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/02/1981 12:00:00 AM 13 Width 3ft Permit Number 18870 6005970.19181 2106649.76485 37.7647964691065 -122.42255383310801 (37.7647964691065, -122.422553833108)
547 224594 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3133 16th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/02/1981 12:00:00 AM 14 Width 3ft Permit Number 18871 6005947.45622 2106648.2222599997 37.7647909508601 -122.42263236011001 (37.7647909508601, -122.42263236011)
881 251399 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 841 Columbus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6008927.4869099995 2120274.72498 37.802373734427796 -122.413288863041 (37.8023737344278, -122.413288863041)
1492 224530 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3055 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     19 Width 3ft   6008605.155040001 2102119.10209 37.752504601916 -122.413119756879 (37.752504601916, -122.413119756879)
1507 590 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3049 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6008590.89573 2102118.12773 37.7525011260356 -122.413168999261 (37.7525011260356, -122.413168999261)
1508 224531 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3077 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6008520.36157 2102113.23947 37.752483743936 -122.413412573453 (37.752483743936, -122.413412573453)
1622 15770 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 4770 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/29/2007 12:00:00 AM 3 3X3   6001421.7162 2091049.3752 37.721703820816394 -122.43716874658399 (37.7217038208164, -122.437168746584)
1961 224699 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3230 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 Width 3ft   6007526.74961 2102095.6735900003 37.7523796734842 -122.416847415286 (37.7523796734842, -122.416847415286)
1962 224700 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3230 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 Width 3ft   6007513.40637 2102105.84325 37.7524068465217 -122.416894278962 (37.7524068465217, -122.416894278962)
1970 224702 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3236 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     19 Width 3ft   6007468.557569999 2102099.5649099997 37.752387084812604 -122.417048929078 (37.7523870848126, -122.417048929078)
2011 224701 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3230 24th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 Width 3ft   6007503.74003 2102097.0446900004 37.7523821439458 -122.416927083514 (37.7523821439458, -122.416927083514)
2012 224703 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3236 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 Width 3ft   6007440.93162 2102096.08231 37.7523759682811 -122.417144217627 (37.7523759682811, -122.417144217627)
2123 128055 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 449 North Point St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/23/2017 12:00:00 AM 3 Width 3ft Permit Number 780354 6008758.87824 2121765.85838 37.8064585449799 -122.413977880988 (37.8064585449799, -122.413977880988)
2216 122752 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 693 Vermont St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   18     6011278.80569 2105286.3398 37.7613508668666 -122.404096651066 (37.7613508668666, -122.404096651066)
2223 43305 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 693 Vermont St 10 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/12/2000 12:00:00 AM 6   Permit Number 43072 6011285.67007 2105193.27319 37.7610957103087 -122.4040663601 (37.7610957103087, -122.4040663601)
2231 122750 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 693 Vermont St 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   9     6011285.1392 2105241.4016400003 37.761227830607204 -122.40407158333299 (37.7612278306072, -122.404071583333)
2233 122749 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 693 Vermont St 9 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   5     6011285.506709999 2105214.92948 37.761155164510605 -122.404068449214 (37.7611551645106, -122.404068449214)
3854 244051 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 401 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5997898.1905 2109198.4158 37.7713357252186 -122.450656427551 (37.7713357252186, -122.450656427551)
4239 244052 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 401 Cole St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   5997900.6668 2109181.4943 37.771289404865 -122.450646641766 (37.771289404865, -122.450646641766)
4385 224618 Planning Code 138.1 required 4 Ficus microcarpa :: Chinese Banyan 94 165 Sussex St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     13 Width 3ft Permit Number 780743 6001936.24436 2096476.10277 37.7366336128599 -122.435778235198 (37.7366336128599, -122.435778235198)
5520 37970 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 602 Peninsula Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/1998 12:00:00 AM     Permit Number 40200          
5741 64939 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1904 Filbert St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/24/1989 12:00:00 AM 14 4x9 Permit Number 25968 6003770.598230001 2119034.75591 37.798678227572 -122.431045672521 (37.798678227572, -122.431045672521)
7271 23546 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 2805 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6005607.92942 2120044.70688 37.801555234346104 -122.424759800825 (37.8015552343461, -122.424759800825)
9698 173643 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 657 Howard St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6012793.0 2114089.0 37.78560546361629 -122.39947767317301 (37.7856054636163, -122.399477673173)
9737 173681 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 125 Rutledge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6010317.0 2099454.0 37.7452827689443 -122.40701204748301 (37.7452827689443, -122.407012047483)
9802 173694 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 201X Stevenson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6011772.0 2114653.0 37.7870971135768 -122.40304974212799 (37.7870971135768, -122.403049742128)
9838 68204 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1110 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 16 3x3 Permit Number 32363 6009978.53990017 2102725.22931804 37.754245896491604 -122.408413088762 (37.7542458964916, -122.408413088762)
9891 173730 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 387 Joost Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5999535.0 2094919.0 37.7322214835803 -122.443968498715 (37.7322214835803, -122.443968498715)
11311 25396 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 945 Geneva Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3X3   6000465.251630001 2089064.76788 37.7162001220051 -122.440332727576 (37.7162001220051, -122.440332727576)
11475 13369 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 900 Mansell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3X50   6009189.31279 2090017.3428599997 37.71930856033371 -122.410245275395 (37.7193085603337, -122.410245275395)
11743 28251 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3340 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X3   6011988.71606 2089960.7357 37.7193096502899 -122.40056475438101 (37.7193096502899, -122.400564754381)
12464 111889 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 142 Wayland St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3x3   6011076.19973 2092521.5640200002 37.72629022399121 -122.40389910598302 (37.7262902239912, -122.403899105983)
12579 28252 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3342 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X3   6011993.05449 2089944.3685299999 37.7192649513087 -122.40054860885598 (37.7192649513087, -122.400548608856)
13606 6798 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1375 Fairfax Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x9   6016915.23611 2097187.56543 37.7394266247399 -122.38403843113701 (37.7394266247399, -122.384038431137)
13913 26001 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1711 Oakdale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6014400.39468 2095925.2599900002 37.735821239067796 -122.392645436853 (37.7358212390678, -122.392645436853)
14200 26002 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1711 Oakdale Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6014429.78226 2095903.68978 37.7357636437757 -122.392542323281 (37.7357636437757, -122.392542323281)
16498 26003 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1711 Oakdale Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6014451.27252 2095887.995 37.7357217425631 -122.39246692501999 (37.7357217425631, -122.39246692502)
16901 16914 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 483 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6004697.20239 2110157.0841200002 37.77435482265879 -122.427206624104 (37.7743548226588, -122.427206624104)
16905 26220 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 765X San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6005701.2867 2098677.11468 37.7428902448864 -122.422917229343 (37.7428902448864, -122.422917229343)
16957 5672 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1422 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 3x3   6005185.06241 2100046.61651 37.7466214421279 -122.424799598532 (37.7466214421279, -122.424799598532)
16970 23100 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1406 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     27 3X3   6006427.47457 2101357.7543900004 37.7502916230775 -122.42059651712098 (37.7502916230775, -122.420596517121)
17077 551 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 2900 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6009445.64374 2102206.2231799997 37.752790964934704 -122.41021934346 (37.7527909649347, -122.41021934346)
17117 625 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3160 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 4x6   6007920.1411 2102115.05717 37.7524550160009 -122.415488371495 (37.7524550160009, -122.415488371495)
17131 5742 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1755 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3X3   6005373.18109 2098196.81653 37.741552935912 -122.424017580443 (37.741552935912, -122.424017580443)
17222 3468 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3231 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 4x4   6007477.096919999 2102052.55322 37.752258481762 -122.41701606785601 (37.752258481762, -122.417016067856)
17372 552 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 2904 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6009418.497 2102204.07854 37.7527835545272 -122.41031307080699 (37.7527835545272, -122.410313070807)
17377 12244 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 401X Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3X3   6005028.531359999 2110211.81183 37.7745238232573 -122.426064391571 (37.7745238232573, -122.426064391571)
17445 16902 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 427 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6004930.51635 2110189.46412 37.7744569217764 -122.42640185318899 (37.7744569217764, -122.426401853189)
17601 577 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3024 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6008801.63126 2102168.54838 37.752651398249604 -122.41244380126301 (37.7526513982496, -122.412443801263)
17610 24602 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 419 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6007254.49022 2097303.30919 37.7392055992492 -122.41744932972401 (37.7392055992492, -122.417449329724)
17762 24449 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1156 Valencia St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6006348.4307699995 2102831.95647 37.7543349884778 -122.420974512988 (37.7543349884778, -122.420974512988)
17807 640 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3214 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6007574.72227 2102100.08892 37.7523944952223 -122.41668183031601 (37.7523944952223, -122.416681830316)
17817 643 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3224 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6007548.56119 2102101.97423 37.752398200442 -122.41677243341199 (37.752398200442, -122.416772433412)
17857 66830 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 393 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/06/1991 12:00:00 AM     Permit Number 30127 6001175.80343985 2104102.01378806 37.7575293253254 -122.43895374638201 (37.7575293253254, -122.438953746382)
17916 587 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3041 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6008724.79045 2102125.26547 37.7525282406021 -122.41270647162202 (37.7525282406021, -122.412706471622)
17973 61740 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 219 Clipper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/15/1984 12:00:00 AM     Permit Number 21745 6003738.99947337 2100964.64707663 37.7490603587459 -122.42986540291099 (37.7490603587459, -122.429865402911)
17978 59647 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 100 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/05/1987 12:00:00 AM   6x9 Permit Number 24228 6003848.70238053 2108788.55742661 37.770549162658895 -122.43004409806002 (37.7705491626589, -122.43004409806)
18006 26514 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 2880 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6008952.92902 2101706.37447 37.7513908617048 -122.411887928494 (37.7513908617048, -122.411887928494)
18141 24446 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1156 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6006345.52984 2102866.64807 37.754430080088895 -122.420987008139 (37.7544300800889, -122.420987008139)
18228 633 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3182 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3x3   6007808.47554 2102110.59584 37.7524364890666 -122.415874214834 (37.7524364890666, -122.415874214834)
18232 630 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3176 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 3x3   6007837.40103 2102111.35303 37.752440194268395 -122.41577423901501 (37.7524401942684, -122.415774239015)
18462 623 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3158 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3x3   6007941.8237 2102115.0630200002 37.7524562507759 -122.415413389641 (37.7524562507759, -122.415413389641)
18516 580 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3013 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6008848.9981 2102129.16474 37.7525459176681 -122.412277214445 (37.7525459176681, -122.412277214445)
18629 23094 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1384 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/01/1992 12:00:00 AM 3 3x3   6006412.34173 2101544.72785 37.750804156590206 -122.42066211905701 (37.7508041565902, -122.420662119057)
18661 598 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3070 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 3x3   6008489.074019999 2102147.94889 37.75257729142999 -122.41352322603399 (37.75257729143, -122.413523226034)
18722 576 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3008 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6008852.23919 2102169.31321 37.7526563382221 -122.412268843556 (37.7526563382221, -122.412268843556)
18768 622 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3150 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 3x3   6007969.891890001 2102118.08704 37.7524661316063 -122.415316538925 (37.7524661316063, -122.415316538925)
19035 5708 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1603 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3X3   6005329.17263 2098980.1167599997 37.743701215741794 -122.424225442544 (37.7437012157418, -122.424225442544)
19276 108963 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 2395x 15TH ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1         6001858.0 2107008.0 37.7655472468341 -122.436802461881 (37.7655472468341, -122.436802461881)
19320 5332 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 125 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     90 6x7   6004849.91389 2107615.9681599997 37.7673861676625 -122.42649738994601 (37.7673861676625, -122.426497389946)
19453 1923 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 78 Berkeley Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6001189.660619999 2097346.8097900003 37.7389819342562 -122.43842185440901 (37.7389819342562, -122.438421854409)
19544 24603 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 407 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X2   6007220.87336 2097309.53692 37.739220807683296 -122.41756600326401 (37.7392208076833, -122.417566003264)
19625 571 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 2970 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/30/2015 12:00:00 AM 12 3x3   6009054.006130001 2102184.0831400002 37.752708212935794 -122.411572138748 (37.7527082129358, -122.411572138748)
19766 5379 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 299 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 4X4   6004899.9834 2106715.40982 37.764916280383 -122.426260083162 (37.764916280383, -122.426260083162)
19840 60045 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 235 Laussat St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/24/1986 12:00:00 AM     Permit Number 22998 6003601.05151902 2109138.05302848 37.7714947633279 -122.43092567098101 (37.7714947633279, -122.430925670981)
19855 602 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3085 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 5x5   6008423.83472 2102105.59165 37.7524573245683 -122.413745839724 (37.7524573245683, -122.413745839724)
19861 656 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3255X 24th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5     12 4x4   6007336.00672 2102041.77073 37.7522209377618 -122.41750321711099 (37.7522209377618, -122.417503217111)
19889 597 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3067 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6008545.44191 2102115.03145 37.7524900724667 -122.41332596783998 (37.7524900724667, -122.41332596784)
19935 613 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3124 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X3   6008177.96308 2102131.82169 37.7525155358782 -122.41459796353998 (37.7525155358782, -122.41459796354)
19950 5335 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 149 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 6X8   6004854.459 2107562.68516 37.7672401222731 -122.42647787465 (37.7672401222731, -122.42647787465)
19961 600 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3078 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 3x3   6008460.582 2102146.28241 37.7525711157729 -122.41362163882401 (37.7525711157729, -122.413621638824)
20011 644 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3245 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6007452.42683 2102052.29911 37.75225639624 -122.41710136313101 (37.75225639624, -122.417101363131)
20031 5670 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 1416 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3x3   6005182.49595 2100071.1312 37.7466886088884 -122.424810216828 (37.7466886088884, -122.424810216828)
20042 24448 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1156 Valencia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6006348.61536 2102840.94797 37.7543596874688 -122.420974512988 (37.7543596874688, -122.420974512988)
20104 26548 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3085 24th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6008470.90767 2102107.16108 37.752464277228 -122.41358316405399 (37.752464277228, -122.413583164054)
20129 642 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3225 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4x4   6007512.22413 2102054.36572 37.7522654344184 -122.416894720512 (37.7522654344184, -122.416894720512)
20144 16900 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 409 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6005007.3916 2110203.70331 37.774500364432505 -122.426136940772 (37.7745003644325, -122.426136940772)
20158 605 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3098 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3x3   6008383.72095 2102142.9064 37.752557529712895 -122.41388719964701 (37.7525575297129, -122.413887199647)
20206 5338 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 158 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 5x5   6004769.98156 2107435.4149 37.766885892799 -122.426761005535 (37.766885892799, -122.426761005535)
20211 5689 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1535 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 3X3   6005306.00348 2099419.02782 37.74490505722029 -122.424336766952 (37.7449050572203, -122.424336766952)
20213 5371 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 266 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 6x6   6004805.70542 2106808.5131599996 37.765166590486395 -122.42659279722 (37.7651665904864, -122.42659279722)
20215 24447 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1156 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6006347.0218400005 2102851.3253900004 37.754388091646 -122.420980760555 (37.754388091646, -122.420980760555)
20356 620 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 3145 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6008061.58213 2102085.15012 37.752380847108604 -122.41499712672 (37.7523808471086, -122.41499712672)
20360 611 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3108 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6008224.09237 2102134.47643 37.752525416718 -122.41443862795799 (37.752525416718, -122.414438627958)
20372 65541 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 2146 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/20/1990 12:00:00 AM     Permit Number 28438 6002328.18536025 2114391.9672646 37.78584848917 -122.43570452929701 (37.78584848917, -122.435704529297)
20532 627 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 3168 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 3x3   6007870.94281 2102116.96374 37.752457485548796 -122.415658642859 (37.7524574855488, -122.415658642859)
20538 10222 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1375-1377 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6005868.37697 2101019.32612 37.7493308512387 -122.422505871374 (37.7493308512387, -122.422505871374)
20570 554 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 2912X 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6009391.31353 2102200.13523 37.7527712032402 -122.410406798162 (37.7527712032402, -122.410406798162)
20574 23101 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 1406 Valencia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     28 3X3   6006426.26721 2101342.93585 37.7502508667074 -122.420599640465 (37.7502508667074, -122.420599640465)
20645 5358 Permitted Site 1 Ficus microcarpa :: Chinese Banyan 94 230 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3X3   6004797.6722800005 2107012.30465 37.765725699015604 -122.426635095043 (37.7657256990156, -122.426635095043)

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