trees
3,587 rows where qSpecies_id = 28 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||||||||||||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 17347 | 12370 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1335 Laguna St | 2 | 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 | |||
| 17411 | 12539 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/01/2019 12:00:00 AM | 3 | 3x3 | 5994802.33005 | 2114932.67469 | 37.7869027759417 | -122.461780923147 | (37.7869027759417, -122.461780923147) | 11 | 6 | 1 | 54 | 11 | ||
| 17574 | 120058 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 132 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 4ft | 5987428.81431 | 2115064.18199 | 37.7868366349011 | -122.487300926674 | (37.7868366349011, -122.487300926674) | 11 | 6 | 1 | 55 | 33 | |||
| 17595 | 255124 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 17905 | 260412 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Brotherhood Way | 1 | Side Yard : Yard | Tree | Private 2 | Width 0ft | 5992928.58802 | 2087852.90738 | 37.7124406464989 | -122.466294818667 | (37.7124406464989, -122.466294818667) | 9 | 8 | 4 | 64 | 24 | ||||
| 18145 | 12518 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 25 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 5995386.16934 | 2114888.58618 | 37.7868153127181 | -122.459757792257 | (37.7868153127181, -122.459757792257) | 11 | 6 | 1 | 54 | 11 | |||
| 18193 | 189473 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 149 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6015891.28978 | 2113582.38645 | 37.7843866224808 | -122.38872301585 | (37.7843866224808, -122.38872301585) | 6 | 2 | 9 | 28856 | 6 | |||
| 18267 | 248156 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 225 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6010067.63283 | 2099505.65063 | 37.7454106326971 | -122.407877963018 | (37.7454106326971, -122.407877963018) | 2 | 7 | 7 | 28859 | 2 | |||
| 18469 | 61073 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2638 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/1983 12:00:00 AM | 20 | Permit Number 20909 | 5999566.78827199 | 2113662.02579548 | 37.78368702296 | -122.445205661056 | (37.78368702296, -122.445205661056) | 15 | 6 | 11 | 29490 | 31 | |
| 18557 | 206368 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 80 Southwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 39 | Width 3ft | 5995490.98867 | 2092437.73844 | 37.7251770224761 | -122.457769987599 | (37.7251770224761, -122.457769987599) | 9 | 7 | 4 | 28861 | 40 | |||
| 18576 | 261447 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 317 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006993 | 2095799 | 37.7350603822594 | -122.418246820854 | (37.7350603822594, -122.418246820854) | 2 | 7 | 7 | 28859 | 2 | ||||
| 18584 | 248142 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6009850.53205 | 2099420.75509 | 37.7451653713952 | -122.408622678105 | (37.7451653713952, -122.408622678105) | 2 | 7 | 7 | 28859 | 2 | |||
| 18730 | 205491 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 528 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5994097.86449 | 2107018.61016 | 37.7651322903366 | -122.46364359657 | (37.7651322903366, -122.46364359657) | 11 | 5 | 11 | 56 | 12 | |||
| 18822 | 65766 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1937 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1990 12:00:00 AM | 15 | Permit Number 28729 | 6003642.45675 | 2118972.66599 | 37.7985004828598 | -122.431484647806 | (37.7985004828598, -122.431484647806) | 13 | 9 | 1 | 57 | 17 | |
| 19077 | 138568 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2626 Pine St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6001336.9539 | 2114950.5561 | 37.7873258778413 | -122.439173956551 | (37.7873258778413, -122.439173956551) | 13 | 6 | 1 | 29490 | 27 | |||
| 19147 | 255132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 19241 | 26162 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 220 Richardson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999090.09548 | 2119848.96049 | 37.8006474865597 | -122.447300272802 | (37.8006474865597, -122.447300272802) | 13 | 9 | 1 | 57 | 17 | |||
| 19433 | 123853 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Lake St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 7ft | 5994558.56386 | 2114921.26273 | 37.786857406167 | -122.462623463806 | (37.786857406167, -122.462623463806) | 11 | 6 | 1 | 54 | 11 | |||
| 19442 | 123590 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 28 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5994274.25903 | 2115401.74269 | 37.7881602957788 | -122.463641970091 | (37.7881602957788, -122.463641970091) | 11 | 6 | 1 | 54 | 11 | |||
| 19545 | 141294 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1835 ELLIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002014.4712 | 2112907.6925 | 37.7817552238956 | -122.436683606845 | (37.7817552238956, -122.436683606845) | 15 | 5 | 11 | 29490 | 41 | |||
| 19587 | 260401 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3900 Alemany Blvd | 2 | Median : Yard | Tree | DPW 1 | 3X5 | 5992602.03225 | 2087509.49597 | 37.7114788737215 | -122.467398529617 | (37.7114788737215, -122.467398529617) | 9 | 8 | 4 | 64 | 24 | ||||
| 19608 | 189403 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1900 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6012367.68824 | 2104717.66867 | 37.7598502014559 | -122.400290696781 | (37.7598502014559, -122.400290696781) | 10 | 3 | 8 | 28856 | 29 | |||
| 19665 | 189518 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Acacia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6018139.6232 | 2096213.22199 | 37.736818885776 | -122.379737317327 | (37.736818885776, -122.379737317327) | 10 | 3 | 8 | 58 | 1 | |||
| 19666 | 98539 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 710 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 4x4 | 5991968.21537 | 2110556.64654 | 37.774723845896 | -122.471267264576 | (37.774723845896, -122.471267264576) | 11 | 6 | 2 | 54 | 11 | |||
| 19682 | 16216 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 527-529 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | Also has partial frontage shared with 535 Monterey Blvd. | 5998570.71989 | 2094653.44366 | 37.7314372752037 | -122.447283112845 | (37.7314372752037, -122.447283112845) | 9 | 7 | 4 | 59 | 40 | ||
| 19688 | 126199 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3045 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5999577.09584 | 2116663.67012 | 37.7919293417196 | -122.44538589855 | (37.7919293417196, -122.44538589855) | 13 | 6 | 1 | 29490 | 27 | |||
| 19739 | 119985 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2512 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 5ft | 5987666.80033 | 2110540.30319 | 37.7744292202448 | -122.486145343797 | (37.7744292202448, -122.486145343797) | 11 | 6 | 2 | 55 | 26 | |||
| 19759 | 206343 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 320 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5993037.90763 | 2099693.34054 | 37.7449578645128 | -122.46677715836 | (37.7449578645128, -122.46677715836) | 1 | 8 | 4 | 29491 | 40 | |||
| 19805 | 126225 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2137 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003795.94873 | 2115803.8767 | 37.7898084966014 | -122.430727270273 | (37.7898084966014, -122.430727270273) | 13 | 9 | 1 | 29490 | 27 | |||
| 19926 | 1838 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2201X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011226.77764 | 2087216.18178 | 37.7117311371657 | -122.403005565662 | (37.7117311371657, -122.403005565662) | 10 | 3 | 8 | 309 | 1 | |||
| 19936 | 206425 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 197 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 6000818.65749 | 2094921.32163 | 37.7323009993923 | -122.439530782334 | (37.7323009993923, -122.439530782334) | 9 | 7 | 4 | 63 | 40 | |||
| 20023 | 126333 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 537 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011888.21181 | 2117712.45326 | 37.7955041342546 | -122.402862928705 | (37.7955041342546, -122.402862928705) | 3 | 1 | 10 | 28860 | 4 | |||
| 20078 | 248752 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1179 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6007686.46628 | 2102816.39807 | 37.7543676015089 | -122.416346131374 | (37.7543676015089, -122.416346131374) | 2 | 4 | 7 | 28859 | 19 | |||
| 20135 | 248904 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4109 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1976 12:00:00 AM | 28 | Width 5ft | Permit Number 16599 | 6001658.90013 | 2103489.46423 | 37.7558748868343 | -122.437239147875 | (37.7558748868343, -122.437239147875) | 2 | 4 | 5 | 28862 | 22 | |
| 20154 | 126324 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 514 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012230.12166 | 2117309.16104 | 37.7944158754575 | -122.401651495115 | (37.7944158754575, -122.401651495115) | 3 | 1 | 10 | 28860 | 4 | |||
| 20178 | 6025 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1791 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001894.3231 | 2112551.24042 | 37.7807696680583 | -122.437073734016 | (37.7807696680583, -122.437073734016) | 15 | 5 | 11 | 29490 | 41 | |||
| 20216 | 121344 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
| 20251 | 126264 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1333 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007187.34034 | 2115852.63803 | 37.7901339378778 | -122.418996808454 | (37.7901339378778, -122.418996808454) | 13 | 9 | 10 | 28858 | 21 | |||
| 20259 | 26515 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2886 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6008938.68629 | 2101687.00134 | 37.7513368683627 | -122.411935812817 | (37.7513368683627, -122.411935812817) | 2 | 4 | 7 | 28859 | 19 | ||||
| 20268 | 248759 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2987 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008379.36946 | 2103275.26244 | 37.7556664788408 | -122.413982346112 | (37.7556664788408, -122.413982346112) | 2 | 4 | 7 | 28859 | 19 | |||
| 20479 | 120223 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 250 25th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5988081.34041 | 2114326.62635 | 37.7848495475274 | -122.484989234472 | (37.7848495475274, -122.484989234472) | 11 | 6 | 2 | 55 | 26 | |||
| 20704 | 2136 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
| 20773 | 247271 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1520 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 5999161.4757 | 2109086.5323 | 37.7711007505764 | -122.446278633453 | (37.7711007505764, -122.446278633453) | 15 | 5 | 11 | 29492 | 9 | |||
| 20866 | 212161 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300x Marietta Dr | 11 | Median : Cutout | Tree | DPW 1 | 24 | Width 5ft | 5999206.26812 | 2097588.84406 | 37.7395334857736 | -122.445296885446 | (37.7395334857736, -122.445296885446) | 9 | 7 | 4 | 59 | 40 | |||
| 20912 | 24331 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | ||||
| 20969 | 212079 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 121 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 5994275.39415 | 2097162.78754 | 37.7380809394917 | -122.462314685482 | (37.7380809394917, -122.462314685482) | 9 | 8 | 4 | 59 | 40 | |||
| 20983 | 26458 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017771.22225 | 2096841.34416 | 37.7385232566369 | -122.381054711725 | (37.7385232566369, -122.381054711725) | 10 | 3 | 8 | 58 | 1 | |||
| 21021 | 212245 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 281 Brighton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5996217.16098 | 2091789.9772 | 37.723440115058 | -122.455212909243 | (37.723440115058, -122.455212909243) | 9 | 8 | 4 | 28861 | 24 | |||
| 21101 | 189529 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 213 Acacia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017810.85672 | 2096234.27169 | 37.7368585440828 | -122.380875482215 | (37.7368585440828, -122.380875482215) | 10 | 3 | 8 | 58 | 1 | |||
| 21189 | 14933 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016941.57525 | 2098184.84614 | 37.7421664120423 | -122.384016788063 | (37.7421664120423, -122.384016788063) | 10 | 3 | 8 | 58 | 1 |
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) );