trees
3,587 rows where qSpecies_id = 28 sorted by DBH
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35363 | 51559 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 29 West Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47854 | 5988768.43262818 | 2115023.56671426 | 37.7868031451511 | -122.48266323691 | (37.7868031451511, -122.48266323691) | 11 | 6 | 1 | 55 | 33 | ||||
| 35802 | 114180 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1x SHRADER ST | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997234 | 2110523 | 37.7749346499606 | -122.453049512511 | (37.7749346499606, -122.453049512511) | 15 | 5 | 2 | 29492 | 16 | ||||
| 36389 | 120124 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 620 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5986678 | 2115081 | 37.7868390002377 | -122.489899771602 | (37.7868390002377, -122.489899771602) | 11 | 6 | 1 | 55 | 33 | ||||
| 36447 | 57112 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 3x3 | Permit Number 14382 | 6001372.84758587 | 2109038.85294203 | 37.7710958809442 | -122.438626020879 | (37.7710958809442, -122.438626020879) | 15 | 5 | 11 | 29492 | 9 | ||
| 36474 | 88364 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2559 33rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51343 | 5986101.6 | 2097823.5 | 37.739421027827 | -122.490623769288 | (37.739421027827, -122.490623769288) | 1 | 8 | 3 | 29491 | 35 | |||
| 37225 | 41146 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1534 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41879 | 5998316.1437305 | 2108281.00611102 | 37.7688406669583 | -122.449144612222 | (37.7688406669583, -122.449144612222) | 15 | 5 | 11 | 29492 | 9 | ||
| 37240 | 50313 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1055 Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.7834285368624 | -122.42353751819 | (37.7834285368624, -122.42353751819) | 7 | 9 | 11 | 28858 | 41 | |||
| 38062 | 97284 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 295X Collins St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4.5x6 | 5998207 | 2112634 | 37.7807866229433 | -122.449835879738 | (37.7807866229433, -122.449835879738) | 15 | 6 | 2 | 54 | 16 | ||||
| 39098 | 251637 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1640 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6002593.76659 | 2112688.53477 | 37.7811863760687 | -122.434663843142 | (37.7811863760687, -122.434663843142) | 15 | 5 | 11 | 29490 | 41 | ||||
| 39233 | 114181 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1x SHRADER ST | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997234 | 2110523 | 37.7749346499606 | -122.453049512511 | (37.7749346499606, -122.453049512511) | 15 | 5 | 2 | 29492 | 16 | ||||
| 39656 | 115936 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X LAKE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5993877 | 2114929 | 37.786839375345 | -122.464982060228 | (37.786839375345, -122.464982060228) | 11 | 6 | 1 | 54 | 11 | ||||
| 39795 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
| 39845 | 49157 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 116 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2003 12:00:00 AM | Permit Number 46278 | 6004391.65758992 | 2101053.62273947 | 37.7493416035982 | -122.4276148431 | (37.7493416035982, -122.4276148431) | 2 | 4 | 5 | 28862 | 22 | |||
| 41557 | 115704 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2820 LAKE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x15 | 5986689 | 2114483 | 37.7851977068092 | -122.489817718558 | (37.7851977068092, -122.489817718558) | 11 | 6 | 1 | 55 | 33 | ||||
| 41861 | 30494 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 245 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/1956 12:00:00 AM | Permit Number 153 | 6003080.18850262 | 2096294.42354032 | 37.7361996769017 | -122.431810162156 | (37.7361996769017, -122.431810162156) | 2 | 7 | 5 | 63 | 7 | |||
| 42032 | 101361 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1303 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007113.6 | 2115829 | 37.7900648810449 | -122.419250267251 | (37.7900648810449, -122.419250267251) | 13 | 9 | 10 | 28858 | 21 | ||||
| 42257 | 115376 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6004637 | 2110246 | 37.7745955592359 | -122.427421211008 | (37.7745955592359, -122.427421211008) | 7 | 9 | 11 | 28852 | 10 | ||||
| 42390 | 121115 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 Stanyan St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.454382576109 | (37.7738204478349, -122.454382576109) | 15 | 5 | 2 | 29492 | 16 | |||
| 42488 | 94440 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 598 Belvedere St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998670 | 2105688 | 37.7617411583254 | -122.447733959945 | (37.7617411583254, -122.447733959945) | 15 | 5 | 11 | 29492 | 9 | ||||
| 42596 | 103592 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
| 42643 | 258040 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007535 | 2121589 | 37.8059041239352 | -122.418200797252 | (37.8059041239352, -122.418200797252) | 5 | 1 | 10 | 308 | 23 | ||||
| 43053 | 41636 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 727 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42114 | 6002231.96646512 | 2108774.97906552 | 37.7704201835081 | -122.435635422279 | (37.7704201835081, -122.435635422279) | 15 | 5 | 5 | 29492 | 9 | |||
| 43094 | 50445 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1458 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47092 | 5999576.80908785 | 2109151.13897488 | 37.7713018555978 | -122.444846630775 | (37.7713018555978, -122.444846630775) | 15 | 5 | 11 | 29492 | 9 | ||||
| 43222 | 33511 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 30 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37606 | 6006939.76943127 | 2099579.03687854 | 37.7454365257217 | -122.418698838359 | (37.7454365257217, -122.418698838359) | 2 | 7 | 7 | 28859 | 2 | |||
| 43890 | 251535 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2799 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6002520 | 2095715 | 37.7345769414893 | -122.433705562416 | (37.7345769414893, -122.433705562416) | 2 | 7 | 5 | 63 | 7 | ||||
| 43947 | 102413 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1301 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x6 | 6000345 | 2109213 | 37.7715155205087 | -122.442193873774 | (37.7715155205087, -122.442193873774) | 15 | 5 | 11 | 29492 | 9 | ||||
| 43978 | 117197 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 70 CERRITOS AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10x6 | 5992485 | 2092977 | 37.7264845532002 | -122.4682005031 | (37.7264845532002, -122.4682005031) | 9 | 8 | 4 | 59 | 40 | ||||
| 44052 | 114240 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x FONT BLVD | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | |||||
| 44179 | 111235 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2601X 15TH AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991704 | 2097685 | 37.7393664008113 | -122.471243228199 | (37.7393664008113, -122.471243228199) | 1 | 8 | 4 | 29491 | 40 | ||||
| 44230 | 49370 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 470 REVISED West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2003 12:00:00 AM | Permit Number 46343 | 5991620.22800025 | 2096213.28684732 | 37.7353206035412 | -122.471425664133 | (37.7353206035412, -122.471425664133) | 1 | 8 | 4 | 29491 | 40 | |||
| 44949 | 100027 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
| 45624 | 121113 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 Stanyan St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.454382576109 | (37.7738204478349, -122.454382576109) | 15 | 5 | 2 | 29492 | 16 | |||
| 45859 | 98551 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 290X Brighton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x5.5 | 5996260 | 2091802.8 | 37.7234777811703 | -122.45506574959 | (37.7234777811703, -122.45506574959) | 9 | 8 | 4 | 28861 | 24 | ||||
| 45933 | 33219 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37411 | 5995201.63425474 | 2099773.01638321 | 37.7453012719366 | -122.459301205113 | (37.7453012719366, -122.459301205113) | 1 | 8 | 4 | 59 | 40 | ||
| 46853 | 251245 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 701 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1992 12:00:00 AM | 6002463.96916 | 2095671.24377 | 37.7344536174122 | -122.433896153002 | (37.7344536174122, -122.433896153002) | 2 | 7 | 5 | 63 | 7 | ||||
| 47565 | 116834 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
| 48096 | 99968 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
| 49686 | 99089 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2801@Broderick Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000146.4 | 2117058.8 | 37.7930467467367 | -122.443444504836 | (37.7930467467367, -122.443444504836) | 13 | 6 | 1 | 29490 | 27 | ||||
| 49751 | 101134 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1477 Grove St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000788.3 | 2110635.6 | 37.7754468763902 | -122.44076254186 | (37.7754468763902, -122.44076254186) | 15 | 5 | 11 | 29492 | 10 | ||||
| 50134 | 100004 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
| 50422 | 121422 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2466 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999524 | 2119846 | 37.8006641419807 | -122.445798577396 | (37.8006641419807, -122.445798577396) | 13 | 9 | 1 | 57 | 17 | ||||
| 52349 | 112105 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 208 WARREN DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994949 | 2102924 | 37.7539385499463 | -122.46040303664 | (37.7539385499463, -122.46040303664) | 1 | 5 | 4 | 63 | 12 | ||||
| 52388 | 99208 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768718 | 6007772.4 | 2088271.5 | 37.7144353163031 | -122.415019520784 | (37.7144353163031, -122.415019520784) | 9 | 7 | 8 | 309 | 39 | ||||
| 52760 | 94439 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 598 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998670 | 2105688 | 37.7617411583254 | -122.447733959945 | (37.7617411583254, -122.447733959945) | 15 | 5 | 11 | 29492 | 9 | |||||
| 52888 | 114178 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1x SHRADER ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997234 | 2110523 | 37.7749346499606 | -122.453049512511 | (37.7749346499606, -122.453049512511) | 15 | 5 | 2 | 29492 | 16 | ||||
| 53412 | 109180 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 301x 28TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003894 | 2099493 | 37.7450283339929 | -122.429224487562 | (37.7450283339929, -122.429224487562) | 2 | 7 | 5 | 63 | 22 | ||||
| 53453 | 52252 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 237 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2005 12:00:00 AM | Permit Number 48419 | 6006717.04487845 | 2104738.84078637 | 37.7595916236736 | -122.419835049965 | (37.7595916236736, -122.419835049965) | 2 | 4 | 7 | 28859 | 19 | |||
| 53489 | 107162 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 798X 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993812 | 2110401 | 37.7744029620428 | -122.464877983618 | (37.7744029620428, -122.464877983618) | 11 | 6 | 2 | 54 | 11 | |||||
| 54221 | 33464 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 52 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37617 | 6006854.98101405 | 2099423.3660818 | 37.7450043146116 | -122.418980984578 | (37.7450043146116, -122.418980984578) | 2 | 7 | 7 | 28859 | 2 | ||
| 54643 | 258523 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 55940 | 38221 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 140 Chester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | Permit Number 40348 | 5991708.17687703 | 2088279.9583595 | 37.7135427330302 | -122.470543976889 | (37.7135427330302, -122.470543976889) | 9 | 8 | 6 | 64 | 24 | |||
| 56537 | 98319 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1811 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | 13 | 6 | 11 | 29490 | 27 | ||||
| 56876 | 51669 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 852@ DIAMOND Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2005 12:00:00 AM | Permit Number 47947 | 6001771.23876172 | 2095874.53487777 | 37.7349724722871 | -122.436305690211 | (37.7349724722871, -122.436305690211) | 2 | 7 | 5 | 63 | 7 | |||
| 57242 | 114460 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1462 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005986 | 2118991 | 37.7986833693446 | -122.423376553534 | (37.7986833693446, -122.423376553534) | 13 | 9 | 1 | 28858 | 32 | ||||
| 57271 | 100029 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
| 57366 | 57042 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 201@ Page Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/1974 12:00:00 AM | Permit Number 14305. Tree 1 on Page St | 5999842.06289616 | 2109172.2578569 | 37.7713749769665 | -122.443930626832 | (37.7713749769665, -122.443930626832) | 15 | 5 | 11 | 29492 | 9 | |||
| 57663 | 254422 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 18 | Median : Cutout | Tree | DPW 1 | 6X6 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | ||||
| 57866 | 47600 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
| 58279 | 44162 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 853 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/2001 12:00:00 AM | Permit Number 43636 | 6002495.49530521 | 2109506.13705466 | 37.7724427273552 | -122.434776169901 | (37.7724427273552, -122.434776169901) | 15 | 5 | 11 | 29492 | 9 | ||
| 58650 | 58013 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3531 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1977 12:00:00 AM | 10x5 | Permit Number 16980 | 6005344.55719622 | 2106027.69514764 | 37.7630530981818 | -122.424673487617 | (37.7630530981818, -122.424673487617) | 8 | 4 | 5 | 28859 | 19 | ||
| 59195 | 93735 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 201@ Page Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on Page St. | 5999812.1 | 2109210.9 | 37.7714793693282 | -122.44403704657 | (37.7714793693282, -122.44403704657) | 15 | 5 | 11 | 29492 | 9 | ||||
| 59385 | 46423 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 179 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1969 12:00:00 AM | Permit Number 44645 | 5999395.58867085 | 2107159.64271916 | 37.7658233652373 | -122.445330264611 | (37.7658233652373, -122.445330264611) | 15 | 5 | 5 | 29492 | 9 | |||
| 59569 | 121116 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 Stanyan St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.454382576109 | (37.7738204478349, -122.454382576109) | 15 | 5 | 2 | 29492 | 16 | |||
| 59927 | 121221 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1639 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5998709 | 2108958 | 37.7707219817969 | -122.4478345011 | (37.7707219817969, -122.4478345011) | 15 | 5 | 11 | 29492 | 9 | ||||
| 60177 | 99996 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
| 60802 | 122728 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2199x Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008252 | 2105724 | 37.7623829973195 | -122.414596107789 | (37.7623829973195, -122.414596107789) | 8 | 4 | 7 | 28859 | 19 | ||||
| 60809 | 100009 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
| 60934 | 258521 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 61157 | 102864 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2750X Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x7.5 | 6000834.2 | 2116922.3 | 37.792711153164 | -122.441054886769 | (37.792711153164, -122.441054886769) | 13 | 6 | 1 | 29490 | 27 | ||||
| 61460 | 120946 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3224 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6007386 | 2102705 | 37.7540448270925 | -122.417377329228 | (37.7540448270925, -122.417377329228) | 2 | 4 | 7 | 28859 | 19 | ||||
| 62274 | 258513 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 62295 | 106457 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1x CHESTNUT ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011546 | 2121132 | 37.8048742648975 | -122.404287845465 | (37.8048742648975, -122.404287845465) | 3 | 1 | 10 | 28860 | 6 | |||||
| 63362 | 114791 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 100x GILLETTE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013060 | 2086881 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | 10 | 3 | 8 | 309 | 1 | ||||
| 63569 | 98550 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 290X Brighton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5.5x5.5 | 5996260 | 2091802.8 | 37.7234777811703 | -122.45506574959 | (37.7234777811703, -122.45506574959) | 9 | 8 | 4 | 28861 | 24 | ||||
| 63613 | 114172 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1x SHRADER ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997234 | 2110523 | 37.7749346499606 | -122.453049512511 | (37.7749346499606, -122.453049512511) | 15 | 5 | 2 | 29492 | 16 | ||||
| 63627 | 104944 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 532 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 63719 | 187632 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 268 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994314 | 2087800 | 37.7123752149716 | -122.461502613047 | (37.7123752149716, -122.461502613047) | 9 | 8 | 6 | 28861 | 24 | ||||
| 63778 | 254163 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 Brotherhood Way | 1 | Side Yard : Cutout | Tree | Private 2 | Width 0ft | 5993694.0595 | 2087568.46764 | 37.7117037797802 | -122.463628505047 | (37.7117037797802, -122.463628505047) | 9 | 8 | 4 | 64 | 24 | ||||
| 64138 | 99494 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Plymouth Ave | 1 | Median : Cutout | Tree | Private 2 | 5995903 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | 9 | 7 | 4 | 28861 | 40 | |||||
| 64576 | 104958 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 759 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
| 64698 | 114701 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 645 STOCKTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010496 | 2116407 | 37.7918418395307 | -122.407588155464 | (37.7918418395307, -122.407588155464) | 5 | 1 | 10 | 28857 | 21 | ||||
| 65316 | 50979 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 201 Richardson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2004 12:00:00 AM | 3x3 | Permit Number 47465 | 5999116.7 | 2119758.3 | 37.8004000774175 | -122.447201682136 | (37.8004000774175, -122.447201682136) | 13 | 9 | 1 | 57 | 17 | ||
| 65764 | 103594 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
| 65934 | 117632 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 3406 CLAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998421 | 2115586 | 37.7889042820755 | -122.449308299768 | (37.7889042820755, -122.449308299768) | 13 | 6 | 1 | 54 | 31 | ||||
| 66003 | 99092 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2801@Broderick Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000146.4 | 2117058.8 | 37.7930467467367 | -122.443444504836 | (37.7930467467367, -122.443444504836) | 13 | 6 | 1 | 29490 | 27 | ||||
| 66095 | 104946 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 532 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 66269 | 99611 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 Entrada Ct | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992743 | 2092489 | 37.7251595224946 | -122.467273147781 | (37.7251595224946, -122.467273147781) | 9 | 8 | 4 | 59 | 40 | |||||
| 66649 | 121100 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001372.84758587 | 2109038.85294203 | 37.7710958809442 | -122.438626020879 | (37.7710958809442, -122.438626020879) | 15 | 5 | 11 | 29492 | 9 | ||||
| 67088 | 33493 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 7 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37621 | 6007079.73577518 | 2099722.81418474 | 37.7458391853073 | -122.418225047767 | (37.7458391853073, -122.418225047767) | 2 | 7 | 7 | 28859 | 2 | ||
| 68465 | 109270 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 875x CHENERY ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6001242 | 2095902 | 37.7350178001347 | -122.438137418666 | (37.7350178001347, -122.438137418666) | 2 | 7 | 5 | 63 | 7 | ||||
| 68568 | 33184 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 585 Dewey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37394 | 5994051.93950389 | 2099322.38418157 | 37.7439977822914 | -122.463243935185 | (37.7439977822914, -122.463243935185) | 1 | 8 | 4 | 59 | 40 | ||
| 69083 | 95961 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 5200 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 5990756.89162 | 2112756.21837 | 37.7806931223902 | -122.475618082454 | (37.7806931223902, -122.475618082454) | 11 | 6 | 2 | 54 | 26 | ||||
| 69204 | 120126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 620 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5986678 | 2115081 | 37.7868390002377 | -122.489899771602 | (37.7868390002377, -122.489899771602) | 11 | 6 | 1 | 55 | 33 | ||||
| 69228 | 102411 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000310.8 | 2109142 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | 15 | 5 | 11 | 29492 | 9 | |||||
| 70393 | 51565 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3860 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47863 | 6004041.27502949 | 2102496.18556684 | 37.7532827184773 | -122.428929306917 | (37.7532827184773, -122.428929306917) | 2 | 4 | 5 | 28862 | 22 | |||
| 70746 | 109021 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800x FOLSOM ST | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.415713764528 | (37.7678993280557, -122.415713764528) | 8 | 4 | 7 | 28853 | 19 | ||||
| 72553 | 103455 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 953 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x9 | 6001548 | 2088631 | 37.7150706812167 | -122.436559205883 | (37.7150706812167, -122.436559205883) | 9 | 7 | 6 | 28861 | 5 | ||||
| 72568 | 112306 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008684 | 2117318 | 37.7942416273691 | -122.413922169868 | (37.7942416273691, -122.413922169868) | 5 | 1 | 10 | 28857 | 21 | ||||
| 72619 | 100020 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
| 72904 | 117269 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X SANTA CLARA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x10 | 5993324 | 2095440 | 37.7332957649176 | -122.465478985137 | (37.7332957649176, -122.465478985137) | 9 | 8 | 4 | 59 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );