Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
52559 | 52559 | 212209 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001437.10561 | 2095636.3706200002 | 37.7342995375914 | -122.437443855175 | (37.7342995375914, -122.437443855175) | ||||
52706 | 52706 | 212226 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1120 Bosworth St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6000822.65215 | 2095879.57602 | 37.734932370740296 | -122.439585642776 | (37.7349323707403, -122.439585642776) | ||||
52835 | 52835 | 75161 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/25/1989 12:00:00 AM | 15 | 6005585.43876 | 2119632.07302 | 37.80042097699361 | -122.42480825631 | (37.8004209769936, -122.42480825631) | ||
53623 | 53623 | 66064 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 612 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1990 12:00:00 AM | 14 | Permit Number 29104 | 6013245.790080001 | 2104237.6601 | 37.7585811285267 | -122.397220091143 | (37.7585811285267, -122.397220091143) | |
53859 | 53859 | 212129 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5995370.8895 | 2092734.46918 | 37.7259848735758 | -122.45820662195601 | (37.7259848735758, -122.458206621956) | ||||
54175 | 54175 | 248651 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1201 San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6004132.59499 | 2095830.66152 | 37.7349858929719 | -122.42813852050301 | (37.7349858929719, -122.428138520503) | ||||
54470 | 54470 | 248222 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 70 Fair Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6007138.69589 | 2099332.0409999997 | 37.7447695284905 | -122.41799347441601 | (37.7447695284905, -122.417993474416) | ||||
54591 | 54591 | 248654 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 81 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005089.97805 | 2097022.6793 | 37.7383130275105 | -122.42491328541901 | (37.7383130275105, -122.424913285419) | ||||
55017 | 55017 | 54653 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 274 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 16 | Permit Number 10477 | 6012392.2248 | 2087295.07392 | 37.7120127715543 | -122.39898297010299 | (37.7120127715543, -122.398982970103) | ||
55194 | 55194 | 248652 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1001 San Jose Ave | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005286.42848 | 2097142.8356 | 37.7386540441353 | -122.42424259893801 | (37.7386540441353, -122.424242598938) | ||||
55378 | 55378 | 176054 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5989245.31981 | 2089315.2477799999 | 37.7162426617475 | -122.47913207879101 | (37.7162426617475, -122.479132078791) | ||||
55703 | 55703 | 99995 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Permit Number 44594 | 6011799.6511699995 | 2117580.00293 | 37.795135512041995 | -122.403160044009 | (37.795135512042, -122.403160044009) | |||
55770 | 55770 | 212123 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5995365.84941 | 2092284.31295 | 37.724748562969395 | -122.458191479165 | (37.7247485629694, -122.458191479165) | ||||
57865 | 57865 | 212142 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 602x Miramar Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5995386.50296 | 2093627.98743 | 37.72843915673079 | -122.458217288806 | (37.7284391567308, -122.458217288806) | ||||
58061 | 58061 | 212092 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1485x Northwood Dr | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 5995863.34016 | 2094047.68745 | 37.7296189404529 | -122.456599188129 | (37.7296189404529, -122.456599188129) | ||||
58398 | 58398 | 218290 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Woodacre Dr | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | 5991251.16534 | 2095467.63693 | 37.733251880466 | -122.472647289653 | (37.733251880466, -122.472647289653) | ||||
58549 | 58549 | 212240 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 298 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5998225.68329 | 2093821.9579599998 | 37.7291344900407 | -122.448416107518 | (37.7291344900407, -122.448416107518) | ||||
58976 | 58976 | 212182 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 620 Bosworth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6002250.2087 | 2095427.67097 | 37.7337726895439 | -122.43461778151001 | (37.7337726895439, -122.43461778151) | ||||
59209 | 59209 | 33675 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 469 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 13 | Permit Number 37757 | 6005116.23557125 | 2111084.96150687 | 37.7769262359606 | -122.425823168919 | (37.7769262359606, -122.425823168919) | |
59466 | 59466 | 212242 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 298 Staples Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5998209.43788 | 2093823.68596 | 37.729138305887496 | -122.44847239338002 | (37.7291383058875, -122.44847239338) | ||||
59551 | 59551 | 249480 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1300x Van Ness Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6006341.46577 | 2115150.70304 | 37.788158930442705 | -122.421873590397 | (37.7881589304427, -122.421873590397) | ||||
60605 | 60605 | 51265 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 791 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 14 | Permit Number 47641 | 5991632.71365 | 2110039.2533299997 | 37.7732838119525 | -122.472390095818 | (37.7732838119525, -122.472390095818) | |
60832 | 60832 | 212127 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 400x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5995366.60081 | 2092506.27853 | 37.7253580704006 | -122.45820493932699 | (37.7253580704006, -122.458204939327) | ||||
61473 | 61473 | 212131 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 5995375.289340001 | 2092898.1948 | 37.7264346776031 | -122.45820325667201 | (37.7264346776031, -122.458203256672) | ||||
61517 | 61517 | 201542 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 Innes Ave | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 6020585.50312 | 2093400.1960900002 | 37.7292294638519 | -122.37108624845699 | (37.7292294638519, -122.371086248457) | ||||
61634 | 61634 | 212145 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 650x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995391.25206 | 2093803.15728 | 37.7289204037391 | -122.458213544026 | (37.7289204037391, -122.458213544026) | ||||
62427 | 62427 | 176057 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989281.98257 | 2089351.5172299999 | 37.7163443777799 | -122.479008007435 | (37.7163443777799, -122.479008007435) | ||||
62845 | 62845 | 176023 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6009654.67743 | 2089334.9097900002 | 37.71746081504929 | -122.40858856232 | (37.7174608150493, -122.40858856232) | ||||
63415 | 63415 | 33467 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 72 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37623 | 6006783.56593714 | 2099291.50343979 | 37.744638227793395 | -122.419218573599 | (37.7446382277934, -122.419218573599) | ||
64686 | 64686 | 212132 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 5995375.30973 | 2092922.4277599999 | 37.7265012166564 | -122.458204939309 | (37.7265012166564, -122.458204939309) | ||||
65336 | 65336 | 176043 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5989267.954919999 | 2090414.23117 | 37.7192615104927 | -122.47913418591499 | (37.7192615104927, -122.479134185915) | ||||
65606 | 65606 | 58791 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 505 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/1992 12:00:00 AM | 15 | Permit Number 30381 | 6012232.54216 | 2117604.48195 | 37.7952268912538 | -122.40166388690099 | (37.7952268912538, -122.401663886901) | ||
65725 | 65725 | 99970 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2270 Folsom St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
66741 | 66741 | 50805 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1498 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2004 12:00:00 AM | Permit Number 47329 | 6000596.76427703 | 2111027.41746177 | 37.7765117981927 | -122.441453229456 | (37.7765117981927, -122.441453229456) | |||
67093 | 67093 | 249488 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6006252.337669999 | 2115769.3960599997 | 37.7898526811986 | -122.422225932188 | (37.7898526811986, -122.422225932188) | ||||
67931 | 67931 | 32978 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 570 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 29 | Permit Number 37291 | 6014355.15854 | 2104463.2818299998 | 37.759262335300996 | -122.39339915324601 | (37.759262335301, -122.393399153246) | |
68692 | 68692 | 59156 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 724 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1980 12:00:00 AM | 21 | Permit Number 18465 | 5993208.37426 | 2110527.44532 | 37.7747153253036 | -122.466975215661 | (37.7747153253036, -122.466975215661) | ||
68934 | 68934 | 212125 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5995367.349909999 | 2092356.01382 | 37.7249455225917 | -122.45819147917 | (37.7249455225917, -122.45819147917) | ||||
69208 | 69208 | 176048 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989010.93647 | 2089619.81285 | 37.7170653066825 | -122.479964486788 | (37.7170653066825, -122.479964486788) | ||||
69234 | 69234 | 57994 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1582 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1983 12:00:00 AM | 16 | Permit Number 20710 | 6008213.2287 | 2108904.5033 | 37.7711137407294 | -122.41495532360099 | (37.7711137407294, -122.414955323601) | ||
69390 | 69390 | 212050 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 600x Faxon Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 5994919.39436 | 2092637.6704099998 | 37.7256931335128 | -122.45976039233999 | (37.7256931335128, -122.45976039234) | ||||
69502 | 69502 | 106886 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 580 Commercial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2014 12:00:00 AM | 3 | Permit Number 772874 | 6011893.85928 | 2117261.69096 | 37.7942667642387 | -122.402811670039 | (37.7942667642387, -122.402811670039) | ||
69754 | 69754 | 212137 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 602x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 5995383.74966 | 2093392.9126 | 37.7277935397334 | -122.458209800147 | (37.7277935397334, -122.458209800147) | ||||
71048 | 71048 | 54432 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 330 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1972 12:00:00 AM | 12 | Permit Number 10209 | 6014015.38229 | 2105524.69697 | 37.76215786632 | -122.39464860115801 | (37.76215786632, -122.394648601158) | ||
71291 | 71291 | 31404 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4249 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1995 12:00:00 AM | 14 | Permit Number 34995 | 6002129.55776 | 2104097.73636 | 37.75757179961771 | -122.43565497859 | (37.7575717996177, -122.43565497859) | ||
71511 | 71511 | 104957 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 759 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
72119 | 72119 | 54132 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 461 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | 24 | Permit Number 9865 | 6012176.495490001 | 2086499.28373 | 37.7098156657361 | -122.3996727573 | (37.7098156657361, -122.3996727573) | ||
72326 | 72326 | 212134 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995376.36506 | 2093112.3941099998 | 37.727022879194 | -122.458215034219 | (37.727022879194, -122.458215034219) | ||||
72582 | 72582 | 34885 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1539 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38493 | 6002855.27225509 | 2121286.11305956 | 37.804807956300394 | -122.43437403696699 | (37.8048079563004, -122.434374036967) | ||||
73344 | 73344 | 176058 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Crespi Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 5989854.78687 | 2090110.33741 | 37.7184611570226 | -122.47708355628599 | (37.7184611570226, -122.477083556286) | ||||
74105 | 74105 | 176021 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6009620.695040001 | 2089243.5370200002 | 37.7172080210075 | -122.40869958183701 | (37.7172080210075, -122.408699581837) | ||||
74942 | 74942 | 189463 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 22 | 6014124.78069 | 2095373.74732 | 37.7342915875929 | -122.393559763171 | (37.7342915875929, -122.393559763171) | ||||
76127 | 76127 | 50574 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2295 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | ||
76146 | 76146 | 212128 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 400x Miramar Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5995370.49354 | 2092599.25425 | 37.7256135830958 | -122.458198208781 | (37.7256135830958, -122.458198208781) | ||||
76246 | 76246 | 67886 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 554 Commercial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1993 12:00:00 AM | 16 | Permit Number 31581 | 6012025.247219999 | 2117281.36529 | 37.794328120508105 | -122.402358434194 | (37.7943281205081, -122.402358434194) | ||
76986 | 76986 | 59078 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 626 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 34 | Permit Number 18378 | 5993651.88803 | 2110754.40375 | 37.775364081352 | -122.46545751469 | (37.775364081352, -122.46545751469) | ||
77327 | 77327 | 33952 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Arbor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/1997 12:00:00 AM | Permit Number 37910 | 6002287.323724099 | 2097040.91143479 | 37.7382043832783 | -122.43460477820899 | (37.7382043832783, -122.434604778209) | |||
77439 | 77439 | 33533 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 185 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37643 | 6007275.34853053 | 2097937.54990535 | 37.7409482571652 | -122.41742214701401 | (37.7409482571652, -122.417422147014) | |||
77484 | 77484 | 97635 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1254 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008163.0 | 2117572.0 | 37.794909774633105 | -122.415742887246 | (37.7949097746331, -122.415742887246) | |||||
77699 | 77699 | 50634 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2900 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.722057508368394 | -122.39326197707399 | (37.7220575083684, -122.393261977074) | ||
77841 | 77841 | 24330 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 601X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | ||||
77978 | 77978 | 50685 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 915 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47258 | 5999168.89515798 | 2107036.01925898 | 37.765470983210896 | -122.44610545370399 | (37.7654709832109, -122.446105453704) | ||||
78017 | 78017 | 99966 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2270 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
78022 | 78022 | 50314 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1055 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.783428536862395 | -122.42353751818999 | (37.7834285368624, -122.42353751819) | |||
78069 | 78069 | 51559 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 29 West Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47854 | 5988768.43262818 | 2115023.56671426 | 37.7868031451511 | -122.48266323691001 | (37.7868031451511, -122.48266323691) | ||||
78254 | 78254 | 100023 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
78551 | 78551 | 38221 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 140 Chester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40348 | 5991708.17687703 | 2088279.9583595002 | 37.7135427330302 | -122.470543976889 | (37.7135427330302, -122.470543976889) | |||
78769 | 78769 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
78924 | 78924 | 41636 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 727 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42114 | 6002231.96646512 | 2108774.97906552 | 37.7704201835081 | -122.43563542227899 | (37.7704201835081, -122.435635422279) | |||
79797 | 79797 | 114240 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x FONT BLVD | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | |||||
79856 | 79856 | 51669 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 852@ DIAMOND Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2005 12:00:00 AM | Permit Number 47947 | 6001771.23876172 | 2095874.53487777 | 37.734972472287104 | -122.43630569021099 | (37.7349724722871, -122.436305690211) | |||
79986 | 79986 | 49370 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 470 REVISED West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2003 12:00:00 AM | Permit Number 46343 | 5991620.22800025 | 2096213.28684732 | 37.735320603541204 | -122.471425664133 | (37.7353206035412, -122.471425664133) | |||
80226 | 80226 | 99208 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768718 | 6007772.4 | 2088271.5 | 37.7144353163031 | -122.415019520784 | (37.7144353163031, -122.415019520784) | ||||
80267 | 80267 | 107218 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 WINSTON DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 42 | 5990934.3 | 2093194.2 | 37.7269912477326 | -122.47357699184799 | (37.7269912477326, -122.473576991848) | ||||
80381 | 80381 | 100004 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Washington St Montgomery St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
80480 | 80480 | 100029 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
80750 | 80750 | 99968 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2270 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
80769 | 80769 | 107162 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 798X 07TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993812.0 | 2110401.0 | 37.7744029620428 | -122.464877983618 | (37.7744029620428, -122.464877983618) | |||||
80970 | 80970 | 33511 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 30 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37606 | 6006939.76943127 | 2099579.03687854 | 37.7454365257217 | -122.41869883835899 | (37.7454365257217, -122.418698838359) | |||
80978 | 80978 | 94439 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 598 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998670.0 | 2105688.0 | 37.7617411583254 | -122.447733959945 | (37.7617411583254, -122.447733959945) | |||||
80983 | 80983 | 50445 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1458 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47092 | 5999576.80908785 | 2109151.13897488 | 37.7713018555978 | -122.44484663077499 | (37.7713018555978, -122.444846630775) | ||||
81000 | 81000 | 57042 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 201@ Page Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/1974 12:00:00 AM | Permit Number 14305. Tree 1 on Page St | 5999842.06289616 | 2109172.2578569 | 37.7713749769665 | -122.44393062683201 | (37.7713749769665, -122.443930626832) | |||
81041 | 81041 | 49157 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 116 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2003 12:00:00 AM | Permit Number 46278 | 6004391.65758992 | 2101053.62273947 | 37.749341603598204 | -122.42761484309999 | (37.7493416035982, -122.4276148431) | |||
81062 | 81062 | 30494 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 245 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/1956 12:00:00 AM | Permit Number 153 | 6003080.18850262 | 2096294.42354032 | 37.736199676901705 | -122.431810162156 | (37.7361996769017, -122.431810162156) | |||
81752 | 81752 | 116834 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
82044 | 82044 | 33219 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.745301271936604 | -122.459301205113 | (37.7453012719366, -122.459301205113) | ||
82755 | 82755 | 2119 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
83274 | 83274 | 99496 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Plymouth Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 5995903.0 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | |||||
83354 | 83354 | 33464 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 52 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37617 | 6006854.98101405 | 2099423.3660818003 | 37.7450043146116 | -122.418980984578 | (37.7450043146116, -122.418980984578) | ||
83492 | 83492 | 100027 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
84125 | 84125 | 52252 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 237 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | Permit Number 48419 | 6006717.04487845 | 2104738.84078637 | 37.7595916236736 | -122.419835049965 | (37.7595916236736, -122.419835049965) | |||
84602 | 84602 | 47600 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | ||
84676 | 84676 | 105867 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 3555 Cesar Chavez St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | |||||
85205 | 85205 | 104946 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 532 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
85324 | 85324 | 33493 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 7 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37621 | 6007079.73577518 | 2099722.81418474 | 37.7458391853073 | -122.418225047767 | (37.7458391853073, -122.418225047767) | ||
85995 | 85995 | 95969 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5600 Geary Blvd | 4 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 5989606.68558 | 2112715.06065 | 37.7805133679778 | -122.479594141591 | (37.7805133679778, -122.479594141591) | |||
86917 | 86917 | 104944 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 532 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
87404 | 87404 | 99494 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Plymouth Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 5995903.0 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | |||||
87458 | 87458 | 99996 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44594 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | ||||
87578 | 87578 | 51565 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3860 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | Permit Number 47863 | 6004041.27502949 | 2102496.18556684 | 37.753282718477294 | -122.428929306917 | (37.7532827184773, -122.428929306917) |
JSON shape: default, array, newline-delimited
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");