trees
3,587 rows where qSpecies_id = 28
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9839 | 48748 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
9847 | 248795 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 5175 Diamond Heights Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6000777.48804 | 2099988.6184 | 37.7462122622804 | -122.440036333505 | (37.7462122622804, -122.440036333505) | 2 | 4 | 5 | 63 | 22 | ||||
9867 | 18856 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2201 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004191.66186 | 2115995.22985 | 37.79035631503 | -122.429371791378 | (37.79035631503, -122.429371791378) | 13 | 9 | 1 | 29490 | 27 | |||
9872 | 19236 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 651 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002073.38012 | 2110681.82337 | 37.7756468948621 | -122.436320461165 | (37.7756468948621, -122.436320461165) | 15 | 5 | 11 | 29492 | 10 | |||
9937 | 99488 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Miramar Ave | 1 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | 9 | 7 | 4 | 28861 | 40 | |
10052 | 14948 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016767.4558 | 2097838.85848 | 37.7412067724716 | -122.384594749942 | (37.7412067724716, -122.384594749942) | 10 | 3 | 8 | 58 | 1 | |||
10114 | 12679 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1302 Lake St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4x4 | 5991386.80092 | 2114799.39324 | 37.7863396121206 | -122.473588027094 | (37.7863396121206, -122.473588027094) | 11 | 6 | 1 | 54 | 33 | |||
10116 | 248844 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 38 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007344.42201 | 2099271.59206 | 37.7446151256805 | -122.417277828134 | (37.7446151256805, -122.417277828134) | 2 | 7 | 7 | 28859 | 2 | |||
10121 | 110450 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 56 HANCOCK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003933 | 2105145 | 37.7605496062864 | -122.429492630385 | (37.7605496062864, -122.429492630385) | 2 | 4 | 5 | 28862 | 3 | ||||
10137 | 228617 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 576 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6002640.85339 | 2103292.8906 | 37.7553909139673 | -122.43382918759 | (37.7553909139673, -122.43382918759) | 2 | 4 | 5 | 28862 | 22 | |||
10173 | 48744 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
10232 | 140742 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2001 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 6001472.9963 | 2113178.7683 | 37.7824687423539 | -122.438576280753 | (37.7824687423539, -122.438576280753) | 15 | 5 | 11 | 29490 | 41 | |||
10238 | 255130 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10360 | 30354 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1956 12:00:00 AM | Permit Number 43 | ||||||||||||||
10391 | 261268 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1544 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5999025.8241 | 2109069.656 | 37.771046664384 | -122.446746640696 | (37.771046664384, -122.446746640696) | 15 | 5 | 11 | 29492 | 9 | ||||
10613 | 56603 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4199@43rd Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 5982724.27515302 | 2106932.91664164 | 37.7642350821119 | -122.502975078628 | (37.7642350821119, -122.502975078628) | 1 | 8 | 3 | 56 | 35 | ||||
10635 | 255127 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10661 | 114250 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 FONT BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 5990844 | 2088883 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | 1 | 8 | 4 | 64 | 14 | ||||
10712 | 205508 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 620 Quintara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 5ft | 5991536.67412 | 2101158.90463 | 37.7488951701835 | -122.472074903552 | (37.7488951701835, -122.472074903552) | 1 | 8 | 4 | 29491 | 12 | |||
10799 | 212114 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1902x Monterey Blvd | 2 | Median : Yard | Tree | DPW 1 | 36 | Width 10ft | 5992265.63325 | 2095412.19532 | 37.7331583221951 | -122.469135994644 | (37.7331583221951, -122.469135994644) | 9 | 8 | 4 | 59 | 40 | |||
10872 | 33492 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 25 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37604 | 6007009.01726732 | 2099597.28801828 | 37.7454905378147 | -122.418460683772 | (37.7454905378147, -122.418460683772) | 2 | 7 | 7 | 28859 | 2 | ||
10989 | 254569 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400x Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 6004613 | 2113717 | 37.7841247118733 | -122.427751595484 | (37.7841247118733, -122.427751595484) | 13 | 9 | 11 | 28858 | 41 | |||
11020 | 261566 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 26th St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
11060 | 49693 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 23 | 5x5 | Permit Number 46512 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.454382576109 | (37.7738204478349, -122.454382576109) | 15 | 5 | 2 | 29492 | 16 | |
11079 | 6325 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1895X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | 15 | 5 | 11 | 29490 | 41 | |||
11098 | 99478 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 650X Miramar Ave | 4 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.458085302932 | (37.728535605791, -122.458085302932) | 9 | 7 | 4 | 28861 | 40 | |
11184 | 56634 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1917 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 6001626.77222134 | 2112852.27703888 | 37.7815810267112 | -122.438020890084 | (37.7815810267112, -122.438020890084) | 15 | 5 | 11 | 29490 | 41 | ||||
11261 | 117631 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3406 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 3x3 | 5998437.09993 | 2115571.11659 | 37.7888643370692 | -122.44925152374 | (37.7888643370692, -122.44925152374) | 13 | 6 | 1 | 54 | 31 | |||
11512 | 205516 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 309 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5992122.52237 | 2094864.24873 | 37.7316455276108 | -122.469590887926 | (37.7316455276108, -122.469590887926) | 9 | 8 | 4 | 59 | 40 | |||
11636 | 249410 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 698 Polk St | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6007114.55441 | 2113257.76141 | 37.7830049436594 | -122.419064511231 | (37.7830049436594, -122.419064511231) | 7 | 9 | 9 | 28852 | 36 | |||
11685 | 122149 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 159 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5991148.17044 | 2114368.07321 | 37.7851415048457 | -122.47438213241 | (37.7851415048457, -122.47438213241) | 11 | 6 | 2 | 54 | 26 | |||
11714 | 24315 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006566.61253 | 2112551.64159 | 37.7810352395317 | -122.420910018978 | (37.7810352395317, -122.420910018978) | 7 | 9 | 11 | 28852 | 41 | |||
11727 | 27637 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Lake St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 4x4 | 5994586.51749 | 2114934.45483 | 37.7868952379175 | -122.462527708701 | (37.7868952379175, -122.462527708701) | 11 | 6 | 1 | 54 | 11 | |||
11833 | 16835 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2200 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x14 | 6000775.7711116 | 2113134.575359 | 37.7823077134494 | -122.440985198149 | (37.7823077134494, -122.440985198149) | 15 | 5 | 1 | 29490 | 41 | |||
11851 | 124059 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 3ft | 5991855.82446 | 2112441.44184 | 37.7798924782755 | -122.471793433921 | (37.7798924782755, -122.471793433921) | 11 | 6 | 2 | 54 | 11 | |||
11876 | 5083 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2566 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | 3X3 | 6002238.2938951 | 2096914.6597978 | 37.7378549419938 | -122.434765273064 | (37.7378549419938, -122.434765273064) | 2 | 7 | 5 | 63 | 7 | |||
11933 | 189475 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 149 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015929.94321 | 2113614.84757 | 37.7844778955793 | -122.388591553884 | (37.7844778955793, -122.388591553884) | 6 | 2 | 9 | 28856 | 6 | |||
11935 | 50824 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47344 | ||||||||||||||
11953 | 189434 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301 Mendell St | 3 | : | Tree | Private 2 | 12 | Width 3ft | 6016859.57023 | 2097844.08748 | 37.7412262239015 | -122.384276612087 | (37.7412262239015, -122.384276612087) | 10 | 3 | 8 | 58 | 1 | |||
12040 | 48742 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
12047 | 176041 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 420 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5989405 | 2090258 | 37.7188404967574 | -122.478649058693 | (37.7188404967574, -122.478649058693) | 1 | 8 | 4 | 64 | 14 | ||||
12050 | 261306 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1555 Union St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6005549 | 2118864 | 37.7983099861265 | -122.424879674285 | (37.7983099861265, -122.424879674285) | 13 | 9 | 1 | 57 | 17 | ||||
12051 | 106705 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 199X BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5996224 | 2090880 | 37.7209419254054 | -122.455123542447 | (37.7209419254054, -122.455123542447) | 9 | 8 | 6 | 28861 | 24 | ||||
12133 | 133687 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1451 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003859 | 2120749 | 37.803390106055 | -122.430862178125 | (37.803390106055, -122.430862178125) | 13 | 9 | 1 | 28858 | 17 | |||
12205 | 142979 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 302 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 34 | Width 0ft | 6010333.0283 | 2120985.7302 | 37.8044047900705 | -122.40847515981 | (37.8044047900705, -122.40847515981) | 3 | 1 | 10 | 308 | 23 | |||
12565 | 104957 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 759 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
12785 | 48747 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
12838 | 110205 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2113 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 6x6 | 6000355.27236 | 2115993.16696 | 37.7901327067156 | -122.442645247897 | (37.7901327067156, -122.442645247897) | 13 | 6 | 1 | 29490 | 27 | |||
12883 | 255123 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
12893 | 24392 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 699X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/21/1995 12:00:00 AM | 12 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | ||
12920 | 175992 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Geneva Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 5ft | 5998869.40884 | 2090603.99979 | 37.7203355078481 | -122.445959349454 | (37.7203355078481, -122.445959349454) | 9 | 7 | 6 | 28861 | 25 | |||
13040 | 261562 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1801 25th St | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
13046 | 112126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 8245 Geary Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 55 | 3x3 | 5981385.27932 | 2112314.25515 | 37.7789318748139 | -122.508005614464 | (37.7789318748139, -122.508005614464) | 11 | 6 | 2 | 55 | 26 | ||||
13061 | 111232 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2601X 15TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991704 | 2097685 | 37.7393664008113 | -122.471243228199 | (37.7393664008113, -122.471243228199) | 1 | 8 | 4 | 29491 | 40 | ||||
13507 | 184527 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1961 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5981338.0835 | 2101535.3662 | 37.7493333765729 | -122.507368946557 | (37.7493333765729, -122.507368946557) | 1 | 8 | 3 | 29491 | 35 | |||
13608 | 70503 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 193 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004252.47977 | 2092436.67804 | 37.7256735552654 | -122.427482323859 | (37.7256735552654, -122.427482323859) | 9 | 7 | 6 | 28861 | 5 | |||
13816 | 99468 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Miramar Ave | 4 | Median : Cutout | Tree | Private 2 | 6 | 15x280 | 5995435.2 | 2093399 | 37.7278132105567 | -122.458032376835 | (37.7278132105567, -122.458032376835) | 9 | 7 | 4 | 28861 | 40 | |||
14022 | 139534 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2139 O'Farrell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6001083.2761 | 2113123.1868 | 37.7822939527692 | -122.439920553002 | (37.7822939527692, -122.439920553002) | 15 | 5 | 11 | 29490 | 41 | |||
14179 | 257990 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1299x Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004575 | 2113275 | 37.7829089401984 | -122.427851556708 | (37.7829089401984, -122.427851556708) | 7 | 9 | 11 | 29490 | 41 | ||||
14358 | 206311 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 145 Majestic Ave | 1 | : | Tree | Private 2 | 16 | Width 3ft | 5996946.82319 | 2089129.17686 | 37.7161760165962 | -122.452498687872 | (37.7161760165962, -122.452498687872) | 9 | 8 | 6 | 28861 | 24 | |||
14784 | 141149 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1934 O'Farrell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 0ft | 6001965.0616 | 2113298.9081 | 37.7828265946555 | -122.436882555626 | (37.7828265946555, -122.436882555626) | 13 | 5 | 11 | 29490 | 41 | |||
14878 | 104430 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 73-75 MIRABEL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | Permit Number 770914 | 6007834 | 2100080 | 37.7468623651304 | -122.415642186435 | (37.7468623651304, -122.415642186435) | 2 | 7 | 7 | 28859 | 2 | ||
14949 | 206319 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Junipero Serra Blvd | 45 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5991343.42057 | 2093507.86668 | 37.7278761829176 | -122.472185537258 | (37.7278761829176, -122.472185537258) | 9 | 8 | 4 | 64 | 40 | |||
15048 | 189404 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1180 De Haro St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 17 | Width 3ft | 6012199.54355 | 2102869.99992 | 37.7547675318026 | -122.40074242533 | (37.7547675318026, -122.40074242533) | 10 | 3 | 8 | 28856 | 29 | |||
15052 | 1279 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3995X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
15071 | 48749 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
15264 | 2135 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 24 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 24 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
15339 | 222951 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6003922.8139 | 2108399.31131 | 37.7694845845646 | -122.429759978361 | (37.7694845845646, -122.429759978361) | 7 | 9 | 5 | 29492 | 10 | |||
15382 | 248899 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4007 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 3ft | 6001751.7117 | 2102909.07323 | 37.7542865483021 | -122.436876628447 | (37.7542865483021, -122.436876628447) | 2 | 4 | 5 | 28862 | 22 | |||
15504 | 126213 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2730 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 4ft | 6000853.52401 | 2116888.62885 | 37.7926198016173 | -122.440985608413 | (37.7926198016173, -122.440985608413) | 13 | 6 | 1 | 29490 | 27 | |||
15569 | 4741 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1120 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/29/1992 12:00:00 AM | 12 | 3X3 | 6008069.3023022 | 2121114.6784448 | 37.8046318166674 | -122.416318139035 | (37.8046318166674, -122.416318139035) | 5 | 1 | 10 | 308 | 23 | ||
15588 | 120716 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 154 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5989318.46493 | 2114336.78774 | 37.7849494287395 | -122.480709979349 | (37.7849494287395, -122.480709979349) | 11 | 6 | 2 | 55 | 26 | |||
15622 | 126182 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1451 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003859 | 2120749 | 37.803390106055 | -122.430862178125 | (37.803390106055, -122.430862178125) | 13 | 9 | 1 | 28858 | 17 | |||
15641 | 48745 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
15643 | 212158 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1340 Monterey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 10ft | 5993891.68041 | 2094668.02643 | 37.7312088402015 | -122.463460369625 | (37.7312088402015, -122.463460369625) | 9 | 8 | 4 | 59 | 40 | |||
15721 | 126288 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500x Van Ness Ave | 7 | Median : Yard | Tree | DPW 1 | 27 | Width 8ft | 6005772.33142 | 2119211.18315 | 37.7992758747311 | -122.424131583019 | (37.7992758747311, -122.424131583019) | 13 | 9 | 1 | 28858 | 32 | |||
15723 | 105168 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 4755X 03RD ST | 2 | Front Yard : Cutout | Tree | Arts Commission 19 | 23 | 3x3 | Permit Number 770204 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | ||
15776 | 245828 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009169.65844 | 2107587.30571 | 37.7675507193221 | -122.411553908588 | (37.7675507193221, -122.411553908588) | 8 | 4 | 7 | 28853 | 19 | |||
15846 | 75161 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1500X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6005585.43876 | 2119632.07302 | 37.8004209769936 | -122.42480825631 | (37.8004209769936, -122.42480825631) | 13 | 9 | 1 | 57 | 17 | |||
15888 | 16825 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2139X OFARRELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6001076 | 2113135 | 37.7823259746064 | -122.439946572306 | (37.7823259746064, -122.439946572306) | 15 | 5 | 11 | 29490 | 41 | |||
15919 | 94903 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3701 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 5997033.01745 | 2115334.97967 | 37.7881355570475 | -122.454092366574 | (37.7881355570475, -122.454092366574) | 11 | 6 | 1 | 54 | 31 | ||||
15938 | 248756 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 439 Shotwell St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007844.54725 | 2105467.77556 | 37.7616565644138 | -122.415987193962 | (37.7616565644138, -122.415987193962) | 2 | 4 | 7 | 28859 | 19 | |||
16008 | 212124 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Miramar Ave | 6 | Median : Yard | Tree | DPW 1 | 5 | 5995365.62659 | 2092320.18392 | 37.7248470432517 | -122.45819484442 | (37.7248470432517, -122.45819484442) | 9 | 7 | 4 | 28861 | 40 | ||||
16175 | 206292 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1273 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | 14 | 3x4 | Permit Number 10064 | 5995766.39546 | 2106910.95096 | 37.764932686723 | -122.457864799544 | (37.764932686723, -122.457864799544) | 15 | 5 | 11 | 56 | 12 | |
16242 | 100094 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 11X Shotwell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007856.7 | 2107724 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | 8 | 4 | 7 | 28853 | 19 | |||
16305 | 222125 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3772 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003278.47263 | 2103621.8407 | 37.7563302945281 | -122.431647592373 | (37.7563302945281, -122.431647592373) | 2 | 4 | 5 | 28862 | 3 | |||
16543 | 222123 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3766 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6003315.09234 | 2103619.46185 | 37.7563258383857 | -122.431520778958 | (37.7563258383857, -122.431520778958) | 2 | 4 | 5 | 28862 | 3 | |||
16569 | 248863 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3224 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007411.22947 | 2102674.7075 | 37.7539630702642 | -122.417287932915 | (37.7539630702642, -122.417287932915) | 2 | 4 | 7 | 28859 | 19 | |||
16576 | 142423 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 0ft | 5997605.1735 | 2114516.8881 | 37.7859220855908 | -122.452053767548 | (37.7859220855908, -122.452053767548) | 11 | 6 | 1 | 54 | 31 | |||
16677 | 12369 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1335 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004408.00965 | 2113459.2839 | 37.7834054897746 | -122.428442413333 | (37.7834054897746, -122.428442413333) | 7 | 9 | 11 | 29490 | 41 | |||
16776 | 248830 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 511 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 5ft | 6006940.05316 | 2097940.07234 | 37.7409363121555 | -122.41858165623 | (37.7409363121555, -122.41858165623) | 2 | 7 | 7 | 28859 | 2 | |||
16795 | 189397 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1851 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6011825.915 | 2106039.85924 | 37.7634504169379 | -122.402257398966 | (37.7634504169379, -122.402257398966) | 8 | 3 | 8 | 28856 | 29 | |||
16946 | 189444 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 201 Mendell St | 7 | : | Tree | Private 2 | 18 | Width 4ft | 6017009.92172 | 2098163.28563 | 37.7421109895326 | -122.383778964147 | (37.7421109895326, -122.383778964147) | 10 | 3 | 8 | 58 | 1 | |||
17014 | 189420 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1751 22nd St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6012859.34416 | 2103757.23618 | 37.7572404677783 | -122.39852289312 | (37.7572404677783, -122.39852289312) | 10 | 3 | 8 | 28856 | 29 | |||
17024 | 248778 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 172 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6006028.35698 | 2096346.83132 | 37.7365102591456 | -122.421620838654 | (37.7365102591456, -122.421620838654) | 2 | 7 | 7 | 28859 | 2 | |||
17215 | 212029 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 80 San Leandro Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 8ft | 5992352.59251 | 2096080.713 | 37.7349989286488 | -122.468883987517 | (37.7349989286488, -122.468883987517) | 1 | 8 | 4 | 59 | 40 | |||
17229 | 262360 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 241 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001078 | 2098361 | 37.7417603103416 | -122.438880584073 | (37.7417603103416, -122.438880584073) | 2 | 7 | 5 | 63 | 7 | ||||
17242 | 253971 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
17272 | 11727 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/15/1995 12:00:00 AM | 12 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
17286 | 24406 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/28/2000 12:00:00 AM | 6 | 3x3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 |
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) );