Street_Tree_List

Data source: data.sfgov.org

711 rows where qSpecies = 36 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
146356 146356 199366 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 300x Division St 5 Median : Yard 3 Tree 1 DPW 2     28 Width 9ft   6009946.07759 2108167.65587 37.769187748042704 -122.40890931543801 (37.7691877480427, -122.408909315438)
28031 28031 199363 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2001 25th St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 8ft   6012400.8175099995 2101833.78107 37.7519335243359 -122.39997359673 (37.7519335243359, -122.39997359673)
56308 56308 199365 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 300x Division St 4 Median : Yard 3 Tree 1 DPW 2     36 Width 8ft   6009969.14716 2108168.58479 37.7691915908542 -122.408829584245 (37.7691915908542, -122.408829584245)
75412 75412 176393 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1669 Geneva Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 8ft   6003772.59409 2087534.0234400001 37.712184786677206 -122.42879190044901 (37.7121847866772, -122.428791900449)
133709 133709 176392 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1669 Geneva Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 8ft   6003793.19406 2087522.42519 37.712154106300396 -122.428719874622 (37.7121541063004, -122.428719874622)
134942 134942 123506 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2630 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 8ft   5995210.5755199995 2110304.28467 37.774217945514 -122.460033072871 (37.774217945514, -122.460033072871)
162695 162695 206275 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 531 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 8ft   5993329.29471 2096110.62255 37.735137433227294 -122.465509381364 (37.7351374332273, -122.465509381364)
169310 169310 176391 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1669 Geneva Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 8ft   6003898.25323 2087460.6657900002 37.711990473755606 -122.42835236038401 (37.7119904737556, -122.428352360384)
23710 23710 199357 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 929 Rhode Island St 2 : 4 Tree 1 Private 1     23 Width 7ft   6011910.785069999 2104052.6476 37.757998712287204 -122.401824164069 (37.7579987122872, -122.401824164069)
25039 25039 199364 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 300x Division St 3 Median : Cutout 11 Tree 1 DPW 2     28 Width 6ft   6009993.3485 2108173.3882400002 37.7692061355694 -122.408746211675 (37.7692061355694, -122.408746211675)
58467 58467 199371 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1600 Davidson Ave 2 Front Yard : Yard 7 Tree 1 Private 1     16 Width 6ft   6014641.960109999 2099662.49642 37.7460963297753 -122.39207151560801 (37.7460963297753, -122.392071515608)
58936 58936 224026 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 3902 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 6ft   6004448.76336 2100465.8103 37.7477308368081 -122.42737550149499 (37.7477308368081, -122.427375501495)
60209 60209 124039 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 737 Lake St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 6ft   5993203.99509 2114811.08925 37.7864767964616 -122.467301904185 (37.7864767964616, -122.467301904185)
66055 66055 206268 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 576 Dewey Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 6ft   5994062.286309999 2099409.86302 37.74423857324471 -122.463214504856 (37.7442385732447, -122.463214504856)
74208 74208 199359 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1450 Rhode Island St 2 : 4 Tree 1 Private 1     22 Width 6ft   6011987.04436 2101599.75481 37.751267861428104 -122.401388046827 (37.7512678614281, -122.401388046827)
77097 77097 199347 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1100 Mariposa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 6ft   6013918.13926 2106206.1968099996 37.764023708663295 -122.39503266563 (37.7640237086633, -122.39503266563)
127278 127278 206267 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 576 Dewey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 6ft   5994070.0708800005 2099419.58791 37.7442657237995 -122.46318829319901 (37.7442657237995, -122.463188293199)
129571 129571 206277 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 100 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 6ft   5994075.53376 2096720.2997299999 37.73685446745821 -122.46297360255801 (37.7368544674582, -122.462973602558)
153651 153651 199341 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 400 Mariposa St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24 Width 6ft   6015776.44164 2106315.00515 37.764425633653296 -122.388612884902 (37.7644256336533, -122.388612884902)
157434 157434 206269 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 576 Dewey Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 6ft   5994053.8446 2099403.66341 37.744221064358705 -122.463243244477 (37.7442210643587, -122.463243244477)
170233 170233 199346 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 467 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     37 Width 6ft   6014392.30341 2104959.03416 37.7606256274859 -122.39330537915501 (37.7606256274859, -122.393305379155)
28422 28422 199384 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1650 Owen St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6014197.25358 2107577.39089 37.7678042229128 -122.394163287405 (37.7678042229128, -122.394163287405)
37030 37030 250127 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1798 Pine St 4 : 4 Tree 1 Private 1     22 Width 5ft   6005361.6989 2115505.86135 37.789078803778295 -122.425288702018 (37.7890788037783, -122.425288702018)
49328 49328 199385 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1650 Owen St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 5ft   6014336.83861 2107435.43762 37.7674222079956 -122.39367053897101 (37.7674222079956, -122.393670538971)
53297 53297 206294 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1291 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   5995770.00748 2106810.2745 37.7646564626472 -122.457845020728 (37.7646564626472, -122.457845020728)
54305 54305 199397 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 937 Mendell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     32 Width 5ft   6015818.29952 2096458.58261 37.7373642805443 -122.387780339289 (37.7373642805443, -122.387780339289)
55567 55567 206292 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1275 Arguello Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   5995766.39546 2106910.95096 37.764932686723 -122.457864799544 (37.764932686723, -122.457864799544)
64197 64197 224004 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2 McCoppin St 5 : 4 Tree 1 Private 1     26 Width 5ft   6006363.216469999 2109170.7903299998 37.77174077135479 -122.42137350531 (37.7717407713548, -122.42137350531)
65730 65730 206293 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1283 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   5995766.93118 2106868.2316900003 37.7648154214066 -122.457859855072 (37.7648154214066, -122.457859855072)
66115 66115 199350 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 580 De Haro St 13 Front Yard : Yard 7 Tree 1 Private 1     22 Width 5ft   6012038.02992 2105655.7284 37.7624075172137 -122.401496758684 (37.7624075172137, -122.401496758684)
74021 74021 224435 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 425 Eugenia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 5ft   6007117.8206400005 2097842.00465 37.7406770466051 -122.41796005021901 (37.7406770466051, -122.417960050219)
77011 77011 199386 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1700 Owen St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6014439.56337 2107313.3314 37.767092638846606 -122.393306679585 (37.7670926388466, -122.393306679585)
157239 157239 224025 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1193 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 5ft   6004485.645169999 2101988.85608 37.7519148526121 -122.427356445766 (37.7519148526121, -122.427356445766)
1520 1520 199389 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 16 Reuel Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 Width 4ft   6017439.78771 2096071.60272 37.7363914002406 -122.38214713169901 (37.7363914002406, -122.382147131699)
26359 26359 199356 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2151 20th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 4ft   6011640.657000001 2104629.31608 37.759567037301004 -122.40279894282301 (37.759567037301, -122.402798942823)
26804 26804 250105 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1688 Pine St 1 : 4 Tree 1 Private 1     18 Width 4ft   6005949.70174 2115586.76552 37.7893341482864 -122.423260038317 (37.7893341482864, -122.423260038317)
27310 27310 199370 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 3550 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     27 Width 4ft   6016015.91083 2099228.15232 37.74497989792071 -122.38729023576799 (37.7449798979207, -122.387290235768)
33431 33431 199352 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2201 20th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   6011438.777290001 2104618.08684 37.7595249301544 -122.403496357191 (37.7595249301544, -122.403496357191)
33604 33604 206271 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1510 Monterey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   5993525.3861 2095199.14432 37.7326460476786 -122.46476525891899 (37.7326460476786, -122.464765258919)
35053 35053 123308 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 401 05th Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   5994328.16527 2112546.87269 37.7803247018036 -122.46324822682399 (37.7803247018036, -122.463248226824)
35112 35112 250107 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1688 Pine St 3 : 4 Tree 1 Private 1     2 Width 4ft   6005911.45005 2115583.3816299997 37.7893226981327 -122.423392144226 (37.7893226981327, -122.423392144226)
38240 38240 176381 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2020 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     29 Width 4ft   6012133.88275 2088039.9913700002 37.714043767182105 -122.39992815667699 (37.7140437671821, -122.399928156677)
39777 39777 199354 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2201 20th St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   6011487.25188 2104620.43012 37.759534071763 -122.403328871935 (37.759534071763, -122.403328871935)
40055 40055 250106 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1688 Pine St 2 : 4 Tree 1 Private 1     16 Width 4ft   6005930.7358800005 2115585.60481 37.7893298908963 -122.42332557552601 (37.7893298908963, -122.423325575526)
40661 40661 199343 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1801 03rd St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 4ft   6015732.2545300005 2106672.58002 37.7654050079639 -122.388790681754 (37.7654050079639, -122.388790681754)
43433 43433 123307 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 401 05th Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 4ft   5994333.67454 2112494.59894 37.7801814895167 -122.46322537368 (37.7801814895167, -122.46322537368)
50774 50774 199342 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1801 03rd St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 4ft   6015732.89393 2106644.75831 37.7653286510121 -122.38878652777201 (37.7653286510121, -122.388786527772)
52315 52315 120312 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 160 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 4ft   5988698.92527 2114284.33233 37.784769373123005 -122.482849516634 (37.784769373123, -122.482849516634)
56783 56783 199353 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2201 20th St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   6011453.77249 2104619.23603 37.7595289231366 -122.40344457691499 (37.7595289231366, -122.403444576915)
59543 59543 199395 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 822 Mendell St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6015923.40773 2096662.96792 37.7379313030858 -122.38743118203001 (37.7379313030858, -122.38743118203)
63679 63679 250102 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1634 Pine St 3 : 4 Tree 1 Private 1     16 Width 4ft   6006004.13239 2115596.49895 37.7893639455439 -122.42307240646099 (37.7893639455439, -122.423072406461)
67214 67214 218790 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 370 Monterey Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 4ft   5999688.29402 2094714.6188400001 37.7316690439961 -122.443423853031 (37.7316690439961, -122.443423853031)
69722 69722 123306 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 401 05th Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 4ft   5994336.05737 2112465.72885 37.7801023572772 -122.463215034991 (37.7801023572772, -122.463215034991)
74140 74140 199355 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2201 20th St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   6011503.64432 2104620.9577599997 37.7595364360688 -122.403272215543 (37.7595364360688, -122.403272215543)
129818 129818 206264 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1235 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 4ft   5995769.52537 2107097.9044 37.7654461924254 -122.45786750379101 (37.7654461924254, -122.457867503791)
130217 130217 250108 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1688 Pine St 4 : 4 Tree 1 Private 1     20 Width 4ft   6005895.20899 2115581.5118400003 37.7893166475034 -122.423448203486 (37.7893166475034, -122.423448203486)
133083 133083 250094 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1700 Gough St 8 : 4 Tree 1 Private 1     16 Width 4ft   6005324.767440001 2115623.21527 37.789398941767004 -122.425424835102 (37.789398941767, -122.425424835102)
135072 135072 224028 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1420 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   5997836.6848 2105808.46526 37.7620242630195 -122.450624734548 (37.7620242630195, -122.450624734548)
136016 136016 199382 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 200 Jennings St 20 : 4 Tree 1 Private 1     15 Width 4ft   6018339.04048 2096582.3620200001 37.7378434689969 -122.37907346658501 (37.7378434689969, -122.379073466585)
150144 150144 224030 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 56 Alma St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 4ft   5998290.39945 2106258.63265 37.7632862690788 -122.44908794966899 (37.7632862690788, -122.449087949669)
150829 150829 224029 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 56 Alma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 4ft   5998311.99153 2106260.3659 37.7632922630546 -122.44901339496799 (37.7632922630546, -122.449013394968)
152750 152750 206265 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1223 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 4ft   5995764.11125 2107172.86823 37.765651712687394 -122.45789165508002 (37.7656517126874, -122.45789165508)
152830 152830 199362 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 936 Wisconsin St 1 : 4 Tree 1 Private 1     13 Width 4ft   6012742.61969 2103151.37524 37.7555704024715 -122.39888405366699 (37.7555704024715, -122.398884053667)
153010 153010 224448 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 36 McCoppin St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     32 Width 4ft   6006371.64374 2109173.2323 37.7717479515507 -122.421344528235 (37.7717479515507, -122.421344528235)
154600 154600 224031 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 822 Clayton St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 4ft   5998688.13035 2107403.24761 37.766451833222604 -122.447794742535 (37.7664518332226, -122.447794742535)
156597 156597 176395 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 5 Lisbon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   6003928.40899 2093435.3216799998 37.728397273506 -122.42867376727699 (37.728397273506, -122.428673767277)
156619 156619 123312 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 401 05th Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   5994326.95545 2112691.62436 37.7807220812689 -122.46326291878201 (37.7807220812689, -122.463262918782)
158273 158273 250109 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1688 Pine St 5 : 4 Tree 1 Private 1     20 Width 4ft   6005867.157869999 2115579.68143 37.7893100383746 -122.42354512700899 (37.7893100383746, -122.423545127009)
159517 159517 250101 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1634 Pine St 4 : 4 Tree 1 Private 1     13 Width 4ft   6005978.51572 2115593.66659 37.78935472300171 -122.42316083590299 (37.7893547230017, -122.423160835903)
160411 160411 199378 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 200 Jennings St 16 : 4 Tree 1 Private 1     21 Width 4ft   6018401.90254 2096662.3376799999 37.7380665323305 -122.37886167173401 (37.7380665323305, -122.378861671734)
166171 166171 123313 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 401 05th Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   5994324.87447 2112727.37957 37.7808201355721 -122.46327271312599 (37.7808201355721, -122.463272713126)
166280 166280 123309 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 401 05th Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   5994326.71646 2112582.77127 37.7804231861892 -122.463255844547 (37.7804231861892, -122.463255844547)
168540 168540 199394 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 818 Mendell St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 4ft   6015978.55484 2096747.59262 37.738166719509394 -122.387246410905 (37.7381667195094, -122.387246410905)
169546 169546 250104 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1634 Pine St 1 : 4 Tree 1 Private 1     2 Width 4ft   6006039.94152 2115602.86884 37.789383456327705 -122.422948963731 (37.7893834563277, -122.422948963731)
176451 176451 199344 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1801 03rd St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 4ft   6015727.94816 2106771.64308 37.7656767749832 -122.38881249299801 (37.7656767749832, -122.388812492998)
176523 176523 121988 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 528 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 4ft   5991288.02079 2111782.83574 37.778051257453704 -122.473709641027 (37.7780512574537, -122.473709641027)
183607 183607 250103 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1634 Pine St 2 : 4 Tree 1 Private 1     2 Width 4ft   6006023.8446 2115600.71368 37.7893766304877 -122.423004504073 (37.7893766304877, -122.423004504073)
188187 188187 250125 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1730 Pine St 1 : 4 Tree 1 Private 1     25 Width 4ft   6005649.1110000005 2115549.12657 37.7892138324921 -122.424297370338 (37.7892138324921, -122.424297370338)
94 94 201404 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1051 Ingalls St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/02/1990 12:00:00 AM 14 Width 3ft   6018112.6185 2094686.77545 37.732626074632705 -122.379724665662 (37.7326260746327, -122.379724665662)
792 792 199372 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 2 Newhall St 2 : 4 Tree 1 DPW 2   11/12/2014 12:00:00 AM 15 Width 3ft Permit Number 774049 6018530.30847 2097200.55685 37.7395514542225 -122.37845506126499 (37.7395514542225, -122.378455061265)
1197 1197 224424 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2500X Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 3ft   6002246.98159 2097281.36199 37.738862314555 -122.43476145089501 (37.738862314555, -122.434761450895)
4566 4566 176382 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2112 Bay Shore Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     31 Width 3ft   6011978.0 2087840.0 37.7134859388755 -122.40045291074101 (37.7134859388755, -122.400452910741)
24830 24830 199390 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1201 Ingalls St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 3ft   6018025.5889 2093953.39853 37.730607564281605 -122.379974610641 (37.7306075642816, -122.379974610641)
27587 27587 224437 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 101 Cortland Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     27 Width 3ft   6006291.67485 2097655.32793 37.7401179434992 -122.420803302726 (37.7401179434992, -122.420803302726)
31211 31211 224444 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 50 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6003894.23838 2108432.6331700003 37.7695744601141 -122.42986119705 (37.7695744601141, -122.42986119705)
33400 33400 123284 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 400 06th Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   5994067.51233 2112489.4392 37.780151985503004 -122.46414576865699 (37.780151985503, -122.464145768657)
34483 34483 201405 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1051 Ingalls St 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6018105.253280001 2094684.7781099998 37.732620184068296 -122.379749990578 (37.7326201840683, -122.379749990578)
38508 38508 206297 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 565 Los Palmos Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   5996520.85452 2095770.92684 37.7343882701062 -122.454450538684 (37.7343882701062, -122.454450538684)
41379 41379 224035 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1619 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft   6003374.882069999 2098756.34444 37.7429762470666 -122.430966938682 (37.7429762470666, -122.430966938682)
42606 42606 224426 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 74 Arbor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6001898.6057400005 2096858.66767 37.7376819093764 -122.435935733463 (37.7376819093764, -122.435935733463)
44072 44072 218788 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 380 Monterey Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft   5999450.96536 2094715.0251900002 37.7316566225397 -122.444244371989 (37.7316566225397, -122.444244371989)
44352 44352 206286 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 199 Elk St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 3ft   6000787.19541 2095992.57825 37.735240630441396 -122.439716327743 (37.7352406304414, -122.439716327743)
44357 44357 224428 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 74 Arbor St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6001850.79221 2096807.3936 37.737538406363 -122.436097379408 (37.737538406363, -122.436097379408)
45323 45323 224434 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 11 Wool St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft   6007430.10011 2098092.51153 37.741382453248896 -122.416898048032 (37.7413824532489, -122.416898048032)
48142 48142 224439 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 3883 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 3ft   6003903.27581 2102441.01038 37.7531234083377 -122.429402602143 (37.7531234083377, -122.429402602143)
48470 48470 206295 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1289 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft   5993598.25468 2106726.01097 37.76430008921321 -122.465350355136 (37.7643000892132, -122.465350355136)
52077 52077 218791 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 138 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   6001157.9301 2094692.71106 37.731692590921995 -122.438341469381 (37.731692590922, -122.438341469381)
59795 59795 224432 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 111 Surrey St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6002272.00576 2096248.81682 37.736028604724005 -122.434601117971 (37.736028604724, -122.434601117971)
60526 60526 224443 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 198 Corbin Pl 10 Side Yard : Yard 17 Tree 1 Private 1     15 Width 3ft   6000083.78895 2105729.05454 37.76193458623221 -122.442847194237 (37.7619345862322, -122.442847194237)
61215 61215 206288 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 199 Elk St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 3ft   6000799.22427 2096049.60807 37.735397905697205 -122.439678826929 (37.7353979056972, -122.439678826929)

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