Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5515 | 5515 | 48743 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 6135 | 6135 | 48746 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 6948 | 6948 | 20002 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY46 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
| 6959 | 6959 | 48747 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 7180 | 7180 | 48749 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 7696 | 7696 | 19998 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY46 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
| 8095 | 8095 | 50823 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | Permit Number 47344 | |||||||||
| 8773 | 8773 | 48750 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 8939 | 8939 | 48748 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 9025 | 9025 | 48744 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 10338 | 10338 | 30354 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1956 12:00:00 AM | Permit Number 43 | |||||||||
| 10647 | 10647 | 19755 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY15 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
| 13566 | 13566 | 48742 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 14417 | 14417 | 48751 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 15637 | 15637 | 48745 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 16097 | 16097 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X Portola Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 16139 | 16139 | 19754 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY15 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
| 16857 | 16857 | 50824 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | Permit Number 47344 | |||||||||
| 189144 | 189144 | 121399 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 349X Cargo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | ||||||||||
| 47892 | 47892 | 176012 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 460 Peninsula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 6012147.1719 | 2086483.56891 | 37.709770881279205 | -122.399773002936 | (37.7097708812792, -122.399773002936) | |||
| 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) | ||
| 117056 | 117056 | 113432 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 460x PENINSULA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012123.0 | 2086509.0 | 37.709839362473105 | -122.399858330527 | (37.7098393624731, -122.399858330527) | ||||
| 23380 | 23380 | 53997 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 437 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 27 | Permit Number 9715 | 6012213.68621 | 2086616.7781099998 | 37.7101403551771 | -122.399552462203 | (37.7101403551771, -122.399552462203) | ||
| 53552 | 53552 | 176029 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 121 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010522.92349 | 2086697.3716799999 | 37.7102672593977 | -122.40540177597799 | (37.7102672593977, -122.405401775978) | |||
| 52129 | 52129 | 54126 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 415 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | 16 | Permit Number 9859 | 6012243.80314 | 2086705.1932599999 | 37.7103848043898 | -122.39945457456301 | (37.7103848043898, -122.399454574563) | ||
| 137310 | 137310 | 176030 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 121 Desmond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010531.16028 | 2086717.01407 | 37.710321653982 | -122.40537469018899 | (37.710321653982, -122.405374690189) | |||
| 48061 | 48061 | 53996 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 409 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 33 | Permit Number 9714 | 6012251.58643 | 2086735.6167099997 | 37.7104687749864 | -122.399429808164 | (37.7104687749864, -122.399429808164) | ||
| 67584 | 67584 | 176011 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 114 Gillette Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 3ft | 6013066.75306 | 2086848.56663 | 37.7108243147535 | -122.39662031080499 | (37.7108243147535, -122.396620310805) | |||
| 87595 | 87595 | 114791 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 100x GILLETTE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013060.0 | 2086881.0 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | ||||
| 107109 | 107109 | 1851 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2401 Bay Shore Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/1991 12:00:00 AM | 12 | 3X3 | 6011063.3259362 | 2087019.7277799998 | 37.7111825850692 | -122.403556689346 | (37.7111825850692, -122.403556689346) | ||
| 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) | |||||
| 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) | |||||
| 95921 | 95921 | 116835 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
| 110125 | 110125 | 116836 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
| 114433 | 114433 | 116837 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
| 188789 | 188789 | 1301 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 4000X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | 10 | 5991772.09471 | 2087046.42932 | 37.7101594558675 | -122.470233284447 | (37.7101594558675, -122.470233284447) | |||
| 31575 | 31575 | 54673 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/1972 12:00:00 AM | 24 | 3x5 | Permit Number 10502 | 6012086.572000001 | 2087197.07093 | 37.7117266378561 | -122.40003252207799 | (37.7117266378561, -122.400032522078) | |
| 10466 | 10466 | 1196 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3080 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 28 | 3X3 | 5996438.01379 | 2087205.1874 | 37.7108640234246 | -122.45411848649799 | (37.7108640234246, -122.454118486498) | ||
| 10644 | 10644 | 1838 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2201X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6011226.77764 | 2087216.18178 | 37.71173113716571 | -122.403005565662 | (37.7117311371657, -122.403005565662) | |||
| 130127 | 130127 | 54764 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 162 Nueva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 10 | Permit Number 10613 | 6012914.10887 | 2087224.38992 | 37.7118477549504 | -122.397174223923 | (37.7118477549504, -122.397174223923) | ||
| 13163 | 13163 | 1267 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5992203.06147 | 2087231.00688 | 37.710691168335096 | -122.468757212784 | (37.7106911683351, -122.468757212784) | |||
| 155961 | 155961 | 54763 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 158 Nueva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 18 | Permit Number 10612 | 6012922.81222 | 2087247.3744599998 | 37.711911350487796 | -122.39714575316799 | (37.7119113504878, -122.397145753168) | ||
| 186200 | 186200 | 54788 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 266 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1972 12:00:00 AM | 17 | Permit Number 10637 | 6012648.47164 | 2087248.62221 | 37.711899500144796 | -122.398094045129 | (37.7118995001448, -122.398094045129) | ||
| 11884 | 11884 | 1270 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5992245.7583099995 | 2087252.3125599998 | 37.7107521351809 | -122.46861119345101 | (37.7107521351809, -122.468611193451) | |||
| 26962 | 26962 | 54655 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 280 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 18 | Permit Number 10479 | 6012382.775359999 | 2087271.8623 | 37.7119485104815 | -122.39901400211201 | (37.7119485104815, -122.399014002112) | ||
| 91843 | 91843 | 1272 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 123541 | 123541 | 1279 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 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) | ||
| 11364 | 11364 | 1271 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992356.50735 | 2087300.8185599998 | 37.7108917180496 | -122.468231949349 | (37.7108917180496, -122.468231949349) | |||
| 13079 | 13079 | 1273 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | Permit Number 771193 | 5992398.03069 | 2087322.1494900002 | 37.710952685801104 | -122.46808998688499 | (37.7109526858011, -122.468089986885) | ||
| 12454 | 12454 | 1277 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992498.771269999 | 2087369.1133 | 37.7110874546035 | -122.46774522006099 | (37.7110874546035, -122.467745220061) | |||
| 10580 | 10580 | 1280 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5992520.10718 | 2087379.1823 | 37.71111633361279 | -122.467672210425 | (37.7111163336128, -122.467672210425) | |||
| 158122 | 158122 | 65732 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 254 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 23 | Permit Number 28666 | 6000124.55623 | 2087429.0552700001 | 37.711689418507206 | -122.44139302826099 | (37.7116894185072, -122.441393028261) | |
| 12581 | 12581 | 1281 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992683.69403 | 2087456.96265 | 37.7113393439098 | -122.46711247059099 | (37.7113393439098, -122.467112470591) | |||
| 184228 | 184228 | 176027 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 343 Alpha St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | Width 3ft | 6010655.072790001 | 2087637.48051 | 37.71285599659021 | -122.40501118873199 | (37.7128559965902, -122.405011188732) | |||
| 163294 | 163294 | 175998 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 212 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6012662.88951 | 2087649.95478 | 37.7130022829956 | -122.39807234986701 | (37.7130022829956, -122.398072349867) | |||
| 175083 | 175083 | 175999 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 214 Hester Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6012611.70015 | 2087649.9736 | 37.7129994834244 | -122.39824927977301 | (37.7129994834244, -122.398249279773) | |||
| 48857 | 48857 | 108757 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 210x Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6012680.348730001 | 2087652.65908 | 37.713010680885404 | -122.3980121942 | (37.7130106808854, -122.3980121942) | |||
| 169272 | 169272 | 112624 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 238 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x2 | 6012530.7402099995 | 2087662.8306099998 | 37.713030276211796 | -122.39853000764799 | (37.7130302762118, -122.398530007648) | |||
| 74445 | 74445 | 176000 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 238 Hester Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6012507.66792 | 2087669.41562 | 37.713047071938895 | -122.39861021550101 | (37.7130470719389, -122.398610215501) | |||
| 76708 | 76708 | 176001 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 240 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6012474.50677 | 2087683.3418400001 | 37.7130834630049 | -122.39872580897 | (37.7130834630049, -122.39872580897) | |||
| 155010 | 155010 | 108755 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 200x Hester Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6012748.711019999 | 2087691.71249 | 37.7131217210609 | -122.397778647462 | (37.7131217210609, -122.397778647462) | |||
| 152936 | 152936 | 176028 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 339 Alpha St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 3ft | 6010692.1495 | 2087704.77428 | 37.71304284423189 | -122.40488777384701 | (37.7130428442319, -122.404887773847) | |||
| 76284 | 76284 | 176002 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 244 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6012430.281359999 | 2087707.00792 | 37.7131459811712 | -122.398880327773 | (37.7131459811712, -122.398880327773) | |||
| 165367 | 165367 | 94787 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 258 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x3 | 6012332.17997 | 2087766.4303 | 37.7133036764001 | -122.399223570238 | (37.7133036764001, -122.399223570238) | |||
| 79157 | 79157 | 93152 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 222 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x13 | 5994796.0 | 2087777.0 | 37.7123397937745 | -122.45983502172301 | (37.7123397937745, -122.459835021723) | |||
| 175808 | 175808 | 206308 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 222 Sadowa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5994765.8705 | 2087778.7663099999 | 37.712342910867 | -122.459939285491 | (37.712342910867, -122.459939285491) | |||
| 23485 | 23485 | 206309 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 226 Sadowa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5994744.569130001 | 2087779.6169999999 | 37.712344021541796 | -122.46001297051599 | (37.7123440215418, -122.460012970516) | |||
| 138042 | 138042 | 176003 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 258 Hester Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012308.92518 | 2087780.83528 | 37.7133419335641 | -122.39930495795099 | (37.7133419335641, -122.399304957951) | |||
| 53698 | 53698 | 206310 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 268 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 5994318.2704 | 2087784.4957400002 | 37.712332889733 | -122.461486730044 | (37.712332889733, -122.461486730044) | |||
| 136727 | 136727 | 176004 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 268 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012290.75284 | 2087793.4379 | 37.7133755250238 | -122.399368652462 | (37.7133755250238, -122.399368652462) | |||
| 13264 | 13264 | 187632 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 268 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994314.0 | 2087800.0 | 37.7123752149716 | -122.461502613047 | (37.7123752149716, -122.461502613047) | ||||
| 166876 | 166876 | 176005 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 268 Hester Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012269.2175199995 | 2087808.4876299999 | 37.713415648281604 | -122.39944414243601 | (37.7134156482816, -122.399444142436) | |||
| 72765 | 72765 | 176006 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 268 Hester Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012249.02594 | 2087822.49084 | 37.7134529728551 | -122.39951491459401 | (37.7134529728551, -122.399514914594) | |||
| 59032 | 59032 | 176007 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 280 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012229.46857 | 2087834.10203 | 37.7134837647275 | -122.39958332691299 | (37.7134837647275, -122.399583326913) | |||
| 52611 | 52611 | 176008 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 280 Hester Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012207.9471 | 2087849.83115 | 37.7135257540887 | -122.399658816915 | (37.7135257540887, -122.399658816915) | |||
| 133207 | 133207 | 176009 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 288 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6012184.99919 | 2087862.53113 | 37.713559346468 | -122.399739024757 | (37.713559346468, -122.399739024757) | |||
| 114279 | 114279 | 104367 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 601X Rutland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010110.7474 | 2087906.11213 | 37.71356316100189 | -122.406911484727 | (37.7135631610019, -122.406911484727) | |||||
| 165111 | 165111 | 39935 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 601X Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/25/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770539 | 6010138.7177 | 2087941.04422 | 37.713660642495 | -122.406817269312 | (37.713660642495, -122.406817269312) |
| 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) | ||||
| 115096 | 115096 | 99209 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 Hahn St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768718 | 6007772.4 | 2088271.5 | 37.7144353163031 | -122.415019520784 | (37.7144353163031, -122.415019520784) | ||||
| 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) | |||
| 73331 | 73331 | 176010 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2168 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012292.82852 | 2088295.9675900002 | 37.7147554870429 | -122.399396735587 | (37.7147554870429, -122.399396735587) | |||
| 79082 | 79082 | 11840 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 87684 | 87684 | 11839 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 93762 | 93762 | 11846 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 95638 | 95638 | 11841 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 99517 | 99517 | 11834 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 101567 | 101567 | 11830 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | ||
| 106431 | 106431 | 11831 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | ||
| 138707 | 138707 | 11843 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 2X2 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 139771 | 139771 | 11844 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 139855 | 139855 | 11845 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 140080 | 140080 | 11835 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 144436 | 144436 | 11832 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 144641 | 144641 | 11847 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 145215 | 145215 | 11837 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 145667 | 145667 | 11836 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 78324 | 78324 | 30038 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.47158589282199 | (37.7138086207581, -122.471585892822) | ||
| 89892 | 89892 | 30039 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.47158589282199 | (37.7138086207581, -122.471585892822) |
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");