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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97454 | 97454 | 105000 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 280X SAN MARCOS AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 65 | Tree tag no. 416 | 5993063.2 | 2100277.9 | 37.7465643757171 | -122.466732187112 | (37.7465643757171, -122.466732187112) | |||
| 90092 | 90092 | 93735 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 201@ Page Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 2 on Page St. | 5999812.1 | 2109210.9 | 37.771479369328205 | -122.44403704657 | (37.7714793693282, -122.44403704657) | ||||
| 122319 | 122319 | 103020 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 40X Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | See 61 Fair Ave property permits | 6006901.0 | 2099544.2 | 37.745338688611206 | -122.41883042692801 | (37.7453386886112, -122.418830426928) | |
| 16035 | 16035 | 54185 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1526 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | 30 | 4x4 | Permit Number 9920 | 6015598.37895 | 2096494.31778 | 37.7374502170542 | -122.388543207207 | (37.7374502170542, -122.388543207207) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 662 | 662 | 206411 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 241 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | Permit Number 779935 | 5993240.35303 | 2102520.36003 | 37.752731819221 | -122.466282559112 | (37.752731819221, -122.466282559112) | ||
| 492 | 492 | 173939 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 570 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2017 12:00:00 AM | 3 | 5xt | Permit Number 779890 | 6014341.0 | 2104455.0 | 37.7592388085315 | -122.39344754111201 | (37.7592388085315, -122.393447541112) | |
| 3053 | 3053 | 126134 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2829 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | Permit Number 779774 | 6000559.90395 | 2118036.87537 | 37.7957558571972 | -122.44208400078101 | (37.7957558571972, -122.442084000781) | ||
| 9805 | 9805 | 57857 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 491 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/1984 12:00:00 AM | 15 | Permit Number 779316 | 5992173.1495199995 | 2112167.2990599996 | 37.7791581122705 | -122.47067570242599 | (37.7791581122705, -122.470675702426) | ||
| 8791 | 8791 | 117119 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 447 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 5x9 | Permit Number 778563 | 5997182.09338 | 2114812.8648 | 37.78671051561479 | -122.45353887881001 | (37.7867105156148, -122.45353887881) | |
| 110526 | 110526 | 104806 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 101X4 Surrey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | Permit Number 776355 | 6002238.26788 | 2096221.16673 | 37.7359507686256 | -122.43471578665 | (37.7359507686256, -122.43471578665) | ||
| 111050 | 111050 | 104803 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 101X5 Surrey St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3x3 | Permit Number 776355 | 6002238.26788 | 2096221.16673 | 37.7359507686256 | -122.43471578665 | (37.7359507686256, -122.43471578665) | ||
| 90168 | 90168 | 98320 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1811 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773893 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | |
| 143413 | 143413 | 33677 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 455 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 773435 | 6005180.13897934 | 2111093.89138396 | 37.776954366261 | -122.42560274302299 | (37.776954366261, -122.425602743023) | |||
| 182229 | 182229 | 106951 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 156 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2014 12:00:00 AM | 22 | 3x3 | Permit Number 773389 | 5987431.57269 | 2114958.38797 | 37.7865463157209 | -122.487283609867 | (37.7865463157209, -122.487283609867) | |
| 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) | ||
| 86969 | 86969 | 99459 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 550X Miramar Ave | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 10/28/2014 12:00:00 AM | 3 | 15x280 | Permit Number 772553 | 5995413.0 | 2092983.7 | 37.7266716211667 | -122.45807907885799 | (37.7266716211667, -122.458079078858) | |
| 100862 | 100862 | 99476 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 650X Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 10/28/2014 12:00:00 AM | 3 | 15x280 | Permit Number 772553 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |
| 128765 | 128765 | 99475 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 650X Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 04/18/2014 12:00:00 AM | 44 | 15x280 | Permit Number 772553 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |
| 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) | ||
| 98229 | 98229 | 62433 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4392 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 770962 | 6000030.87492783 | 2105785.85783865 | 37.762087537224396 | -122.44303428204901 | (37.7620875372244, -122.443034282049) | ||
| 123647 | 123647 | 104430 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 73-75 MIRABEL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | Permit Number 770914 | 6007834.0 | 2100080.0 | 37.7468623651304 | -122.415642186435 | (37.7468623651304, -122.415642186435) | ||
| 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) |
| 42991 | 42991 | 105168 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 4755X 03RD ST | 2 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 23 | 3x3 | Permit Number 770204 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | ||
| 140647 | 140647 | 105160 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600X OAKDALE AVE | 1 | Front Yard : Yard 7 | Tree 1 | Arts Commission 19 | 13 | Permit Number 770204 | 6015006.0 | 2095503.0 | 37.734695414582795 | -122.390522107646 | (37.7346954145828, -122.390522107646) | |||
| 19556 | 19556 | 99478 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 650X Miramar Ave | 4 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |
| 81264 | 81264 | 99456 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Miramar Ave | 6 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.45812076272101 | (37.7250639553871, -122.458120762721) | |
| 85151 | 85151 | 99471 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Miramar Ave | 7 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995435.2 | 2093399.0 | 37.727813210556704 | -122.458032376835 | (37.7278132105567, -122.458032376835) | |
| 87236 | 87236 | 99491 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 5 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |
| 98576 | 98576 | 99490 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 4 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |
| 123683 | 123683 | 99488 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |
| 138714 | 138714 | 99482 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Miramar Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | |
| 139549 | 139549 | 55340 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1570 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | Permit Number 769406 | 5992478.56101588 | 2104770.1953725 | 37.758865297372104 | -122.46908067431299 | (37.7588652973721, -122.469080674313) | |||
| 16332 | 16332 | 26455 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 401X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | Permit Number 769095 | 6017718.24501 | 2096772.8589700002 | 37.738332285595206 | -122.381233122826 | (37.7383322855952, -122.381233122826) | ||
| 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) | ||||
| 64605 | 64605 | 98705 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1050 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2012 12:00:00 AM | 10 | 3x3 | Permit Number 768656 | 6007880.11955 | 2092984.0697400002 | 37.7273810881671 | -122.414980548629 | (37.7273810881671, -122.414980548629) | |
| 100087 | 100087 | 97954 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 140 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 3x3 | Permit Number 768198 | 5995938.36032 | 2113419.39672 | 37.7828130508284 | -122.457741003486 | (37.7828130508284, -122.457741003486) | ||
| 142328 | 142328 | 53624 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4330 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1970 12:00:00 AM | Permit Number 6555 | 6001727.50679504 | 2101199.57281892 | 37.749591293136895 | -122.436837965286 | (37.7495912931369, -122.436837965286) | |||
| 175477 | 175477 | 53614 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 157 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1970 12:00:00 AM | 25 | Permit Number 6545 | 5993950.70262 | 2114432.49008 | 37.7854803438469 | -122.464691000244 | (37.7854803438469, -122.464691000244) | ||
| 46418 | 46418 | 53581 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 149 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1970 12:00:00 AM | 20 | Permit Number 6509 | 5993949.30457 | 2114483.86823 | 37.7856213336586 | -122.46469956926599 | (37.7856213336586, -122.464699569266) | ||
| 40493 | 40493 | 53401 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 730 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1969 12:00:00 AM | 19 | Permit Number 6300 | 5990392.09793 | 2110392.4951299997 | 37.774181835613206 | -122.476707321825 | (37.7741818356132, -122.476707321825) | ||
| 139081 | 139081 | 92211 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 12/29/2010 12:00:00 AM | 2x2 | Permit Number 54064 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
| 126732 | 126732 | 94848 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 55X Heron St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53927 | 6009970.0 | 2109980.0 | 37.7741653653004 | -122.408954458449 | (37.7741653653004, -122.408954458449) | |
| 99750 | 99750 | 92208 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 2x2 | Permit Number 52642 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
| 112226 | 112226 | 92209 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 2x2 | Permit Number 52642 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
| 172521 | 172521 | 41920 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 612 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 13 | 3x3 | Permit Number 52406 | 5995349.87473 | 2111350.37207 | 37.777098235843 | -122.459626997558 | (37.777098235843, -122.459626997558) | |
| 122131 | 122131 | 85112 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4201 22nd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51811 | 6001198.0 | 2102882.0 | 37.7541807256906 | -122.43878955892201 | (37.7541807256906, -122.438789558922) | |||
| 58786 | 58786 | 81639 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 678 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 10 | 3x3 | Permit Number 51574 | 5994125.833 | 2110896.56875 | 37.77578175135179 | -122.463828362424 | (37.7757817513518, -122.463828362424) | |
| 175444 | 175444 | 82865 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 614 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 11 | 3x3 | Permit Number 51572 | 5994112.637619999 | 2111294.28874 | 37.7768730237535 | -122.463902883988 | (37.7768730237535, -122.463902883988) | |
| 124247 | 124247 | 88364 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2559 33rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51343 | 5986101.6 | 2097823.5 | 37.739421027827 | -122.490623769288 | (37.739421027827, -122.490623769288) | |||
| 102260 | 102260 | 87974 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2160 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51010 | 5999212.8 | 2111613.6 | 37.778042363793396 | -122.446282917617 | (37.7780423637934, -122.446282917617) | ||
| 124558 | 124558 | 87671 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50395 | 5987244.0 | 2115292.0 | 37.787451378555396 | -122.48795707816299 | (37.7874513785554, -122.487957078163) | ||
| 92060 | 92060 | 87052 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 511 Euclid Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 50168 | 5996764.3 | 2113789.0 | 37.783875296894294 | -122.45491032952499 | (37.7838752968943, -122.454910329525) | |||
| 77803 | 77803 | 86893 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Mason St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2007 12:00:00 AM | 3x3 | Permit Number 49821 | 6008765.0 | 2122158.0 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | ||
| 106093 | 106093 | 86891 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Mason St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49821 | 6008765.0 | 2122158.0 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | |||
| 110750 | 110750 | 86890 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49821 | 6008765.0 | 2122158.0 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | |||
| 129146 | 129146 | 86892 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Mason St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49821 | 6008765.0 | 2122158.0 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | |||
| 91120 | 91120 | 53212 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 132 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2006 12:00:00 AM | Permit Number 49185 | 6004089.5020644 | 2108196.64307491 | 37.7689375443291 | -122.42916895785 | (37.7689375443291, -122.42916895785) | |||
| 92857 | 92857 | 53058 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 235@ FOLSOM Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2006 12:00:00 AM | Permit Number 49035 | 6014758.5845738 | 2115729.7936401 | 37.790220067206704 | -122.392792095849 | (37.7902200672067, -122.392792095849) | |||
| 107100 | 107100 | 53057 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 235@ FOLSOM Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2006 12:00:00 AM | Permit Number 49035 | 6014758.5845738 | 2115729.7936401 | 37.790220067206704 | -122.392792095849 | (37.7902200672067, -122.392792095849) | |||
| 108285 | 108285 | 53059 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 235@ FOLSOM Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49035 | 6014758.5845738 | 2115729.7936401 | 37.790220067206704 | -122.392792095849 | (37.7902200672067, -122.392792095849) | ||||
| 124432 | 124432 | 53048 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 65@ APPLETON Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2006 12:00:00 AM | Permit Number 49026 | 6005683.68607987 | 2097324.15915168 | 37.7391743410359 | -122.42288195252199 | (37.7391743410359, -122.422881952522) | |||
| 144654 | 144654 | 52775 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3006 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48821 | 6000400.26777078 | 2115518.80324345 | 37.7888327924103 | -122.442455496921 | (37.7888327924103, -122.442455496921) | |||
| 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) | |||
| 134558 | 134558 | 52239 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1025REVISED Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2006 12:00:00 AM | 20 | Permit Number 48410 | 6011950.95504 | 2103369.42747 | 37.756124981991206 | -122.401637218391 | (37.7561249819912, -122.401637218391) | |
| 3045 | 3045 | 141431 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 501 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2005 12:00:00 AM | 17 | Width 0ft | Permit Number 48304 | 6005404.7905 | 2110954.8993 | 37.776585419130896 | -122.42481571306601 | (37.7765854191309, -122.424815713066) | |
| 94325 | 94325 | 52113 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 501 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | 4x4 | Permit Number 48304 | 6005450.41519372 | 2110958.1148217 | 37.7765968250138 | -122.42465811266199 | (37.7765968250138, -122.424658112662) | |
| 123756 | 123756 | 52083 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 770 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2005 12:00:00 AM | Permit Number 48281 | 6010080.56543171 | 2116389.03640526 | 37.7917692527785 | -122.409024297587 | (37.7917692527785, -122.409024297587) | |||
| 106694 | 106694 | 33517 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 148 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2005 12:00:00 AM | Permit Number 48274 | 6007365.58443644 | 2098215.69549509 | 37.741717059847495 | -122.41712984786601 | (37.7417170598475, -122.417129847866) | |||
| 116460 | 116460 | 52036 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 551 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2005 12:00:00 AM | Permit Number 48248 | 6003933.03406109 | 2105071.04130005 | 37.760346535270706 | -122.429487238107 | (37.7603465352707, -122.429487238107) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 106768 | 106768 | 51557 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 29 West Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2005 12:00:00 AM | Permit Number 47854 | 5988768.43262818 | 2115023.56671426 | 37.7868031451511 | -122.48266323691001 | (37.7868031451511, -122.48266323691) | |||
| 138295 | 138295 | 51558 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 29 West Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2005 12:00:00 AM | Permit Number 47854 | 5988768.43262818 | 2115023.56671426 | 37.7868031451511 | -122.48266323691001 | (37.7868031451511, -122.48266323691) | |||
| 97408 | 97408 | 46076 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3800 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2005 12:00:00 AM | Permit Number 47852 | 5996586.74903344 | 2115641.8686237 | 37.788952592538706 | -122.455658560713 | (37.7889525925387, -122.455658560713) | |||
| 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) | ||
| 98743 | 98743 | 50635 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2900 Jennings St | 3 | 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) | ||
| 135524 | 135524 | 50633 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2900 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | 7 | Permit Number 47740 | 6014091.6306 | 2090874.9645 | 37.721936997210996 | -122.393359654849 | (37.721936997211, -122.393359654849) | |
| 38847 | 38847 | 51264 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 791 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 11 | Permit Number 47641 | 5991632.45779 | 2110058.1497 | 37.773335681454896 | -122.472392358685 | (37.7733356814549, -122.472392358685) | |
| 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) | |
| 103674 | 103674 | 51158 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2663DIVISADERO Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 47563 | 6000913.18019234 | 2117191.80900567 | 37.7934556526619 | -122.440800954263 | (37.7934556526619, -122.440800954263) | |||
| 110427 | 110427 | 51155 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2663DIVISADERO Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 47563 | 6000913.18019234 | 2117191.80900567 | 37.7934556526619 | -122.440800954263 | (37.7934556526619, -122.440800954263) | |||
| 89145 | 89145 | 50979 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 201 Richardson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2004 12:00:00 AM | 3x3 | Permit Number 47465 | 5999116.7 | 2119758.3 | 37.8004000774175 | -122.447201682136 | (37.8004000774175, -122.447201682136) | ||
| 99120 | 99120 | 50969 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3901 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 47462 | 6002458.87676393 | 2102943.00430693 | 37.7544198816731 | -122.43443350231001 | (37.7544198816731, -122.43443350231) | |||
| 98128 | 98128 | 50878 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2506 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47388 | 6002262.04828144 | 2097251.96755917 | 37.7387824596371 | -122.43470725599501 | (37.7387824596371, -122.434707255995) | ||||
| 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 | |||||||||
| 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 | |||||||||
| 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) | |||
| 123074 | 123074 | 50804 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1498 Fulton St | 1 | 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) | |||
| 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) | ||||
| 99199 | 99199 | 50657 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 35 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/15/2005 12:00:00 AM | Permit Number 47239 | 5995410.10661733 | 2114891.76691609 | 37.7868254226819 | -122.4596752059 | (37.7868254226819, -122.4596752059) | ||
| 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) | ||
| 108489 | 108489 | 50567 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2295 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | |||
| 138454 | 138454 | 50572 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2295 Folsom St | 2 | 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) | ||
| 95868 | 95868 | 50448 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 303on BOCANA Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47095 | 6006949.39342482 | 2097361.11055858 | 37.739347137768604 | -122.418508317181 | (37.7393471377686, -122.418508317181) |
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");