trees
3,587 rows where qSpecies_id = 28 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 29836 | 115998 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 143 ASHBURY ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998718 | 2110172 | 37.7740558300516 | -122.447890785953 | (37.7740558300516, -122.447890785953) | 15 | 5 | 11 | 29492 | 16 | |||||
| 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 | |||
| 56570 | 102458 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 3267 20th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6008409 | 2104449 | 37.7588909590293 | -122.413962902008 | (37.7588909590293, -122.413962902008) | 2 | 4 | 7 | 28859 | 19 | ||||
| 85829 | 87052 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 511 Euclid Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 3x3 | Permit Number 50168 | 5996764.3 | 2113789 | 37.7838752968943 | -122.454910329525 | (37.7838752968943, -122.454910329525) | 11 | 6 | 1 | 54 | 31 | |||
| 111799 | 108018 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 109 ALPINE TER | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4x7 | 6001716.4 | 2108199.1 | 37.7688096651516 | -122.43737752181 | (37.7688096651516, -122.43737752181) | 15 | 5 | 5 | 29492 | 3 | ||||
| 149976 | 104650 | Private 9 | Corymbia ficifolia :: Red Flowering Gum 28 | 346 LAKE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 10x8 | 5994385.6 | 2114927.2 | 37.7868637456835 | -122.463222305141 | (37.7868637456835, -122.463222305141) | 11 | 6 | 1 | 54 | 11 | ||||
| 161476 | 85112 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 4201 22nd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51811 | 6001198 | 2102882 | 37.7541807256906 | -122.438789558922 | (37.7541807256906, -122.438789558922) | 2 | 4 | 5 | 28862 | 22 | |||
| 169013 | 105767 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 245 RUTLEDGE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 6010031.3 | 2099465.2 | 37.7452975299559 | -122.40800074457 | (37.7452975299559, -122.40800074457) | 2 | 7 | 7 | 28859 | 2 | ||||
| 50 | 264964 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3641 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 5996989 | 2114619 | 37.7861671437011 | -122.454192924446 | (37.7861671437011, -122.454192924446) | 11 | 6 | 1 | 54 | 31 | ||||
| 69 | 126274 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1240 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 6ft | 6006421.51674 | 2120105.21307 | 37.8017672864012 | -122.421948716173 | (37.8017672864012, -122.421948716173) | 5 | 9 | 1 | 28858 | 32 | |||
| 79 | 121399 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349X Cargo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
| 498 | 260403 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X Brotherhood Way | 1 | Median : Yard | Tree | Private 2 | 30x30 | 5992691 | 2087881 | 37.712504070633 | -122.467118029673 | (37.712504070633, -122.467118029673) | 9 | 8 | 6 | 64 | 24 | ||||
| 600 | 35359 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 917 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 28 | 6x6 | Permit Number 38821 | 6011905.65469 | 2104108.25722 | 37.7581511177091 | -122.40184581615 | (37.7581511177091, -122.40184581615) | 10 | 3 | 8 | 28856 | 29 |
| 1078 | 206334 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1795 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 47 | Width 3ft | 5993395.55114 | 2103268.51853 | 37.7547950231872 | -122.465800214925 | (37.7547950231872, -122.465800214925) | 1 | 8 | 4 | 56 | 12 | |||
| 2152 | 33675 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 469 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 13 | Permit Number 37757 | 6005116.23557125 | 2111084.96150687 | 37.7769262359606 | -122.425823168919 | (37.7769262359606, -122.425823168919) | 7 | 9 | 11 | 28852 | 10 | |
| 2245 | 126164 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3404 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5998411.11322 | 2115565.12364 | 37.7888463955847 | -122.449341001806 | (37.7888463955847, -122.449341001806) | 13 | 6 | 1 | 54 | 31 | |||
| 2496 | 331 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3402X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 50 | 2X3 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
| 2816 | 126194 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2323 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6000797.30385 | 2116351.55373 | 37.7911419313024 | -122.441141581441 | (37.7911419313024, -122.441141581441) | 13 | 6 | 1 | 29490 | 27 | |||
| 2970 | 183328 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1216 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 5982775 | 2106802 | 37.7638786035994 | -122.5027899471 | (37.7638786035994, -122.5027899471) | 1 | 8 | 3 | 56 | 35 | |||
| 2993 | 140841 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 128 JORDAN AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 5996252.84 | 2113531.7423 | 37.7831395829214 | -122.456661169882 | (37.7831395829214, -122.456661169882) | 11 | 6 | 1 | 54 | 31 | |||
| 3684 | 98923 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3527 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 5997962.31773 | 2115134.58282 | 37.7876385629149 | -122.450862707746 | (37.7876385629149, -122.450862707746) | 11 | 6 | 1 | 54 | 31 | |||
| 4157 | 52083 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 770 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2005 12:00:00 AM | Permit Number 48281 | 6010080.56543171 | 2116389.03640526 | 37.7917692527785 | -122.409024297587 | (37.7917692527785, -122.409024297587) | 5 | 1 | 10 | 28857 | 21 | |||
| 4470 | 19187 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 125 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003528.70248 | 2107586.69801 | 37.7672310211182 | -122.431065186025 | (37.7672310211182, -122.431065186025) | 7 | 9 | 5 | 28862 | 3 | |||
| 5246 | 262331 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 2140 Wawona St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5986390 | 2097232 | 37.7378137677629 | -122.489583137449 | (37.7378137677629, -122.489583137449) | 1 | 8 | 3 | 29491 | 35 | ||||
| 5274 | 212748 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1583 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5992725 | 2104704 | 37.7586977784353 | -122.468223565677 | (37.7586977784353, -122.468223565677) | 1 | 8 | 4 | 56 | 12 | |||
| 5305 | 5766 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 414 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6003770.1384677 | 2108392.97573 | 37.769458541933 | -122.430287624255 | (37.769458541933, -122.430287624255) | 15 | 9 | 5 | 29492 | 10 | |||
| 5631 | 50066 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 406 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46794 | 6003569.14495563 | 2105912.6827965 | 37.7626368713078 | -122.430805824209 | (37.7626368713078, -122.430805824209) | 15 | 4 | 5 | 28862 | 3 | ||
| 5676 | 122158 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 515 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 6ft | 5991239.57046 | 2111867.63351 | 37.7782812827035 | -122.473883434468 | (37.7782812827035, -122.473883434468) | 11 | 6 | 2 | 54 | 26 | |||
| 6068 | 244550 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1544 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5999032 | 2109089 | 37.7711001308876 | -122.446726670211 | (37.7711001308876, -122.446726670211) | 15 | 5 | 11 | 29492 | 9 | |||
| 6376 | 206322 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1580 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5992477.65617 | 2104709.18498 | 37.7586977265366 | -122.469079363447 | (37.7586977265366, -122.469079363447) | 1 | 8 | 4 | 56 | 12 | |||
| 6473 | 48743 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
| 6611 | 262204 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 907 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001442 | 2095927 | 37.735097816857 | -122.437447738546 | (37.735097816857, -122.437447738546) | 2 | 7 | 5 | 63 | 7 | ||||
| 6726 | 2033 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002154.6210393 | 2095431.8532492 | 37.7337787461998 | -122.434948555048 | (37.7337787461998, -122.434948555048) | 2 | 7 | 5 | 63 | 7 | |||
| 7147 | 260402 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Arch St | 1 | Median : Yard | Tree | DPW 1 | 3X5 | 5992587 | 2087523 | 37.7115150847083 | -122.467451465905 | (37.7115150847083, -122.467451465905) | 9 | 8 | 4 | 64 | 24 | ||||
| 7199 | 5759 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 3X3 | 6003976.63728 | 2108405.62354 | 37.7695049641016 | -122.42957425574 | (37.7695049641016, -122.42957425574) | 7 | 9 | 5 | 29492 | 10 | |||
| 7358 | 108758 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1449 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999638.3 | 2109087.9 | 37.7711317264146 | -122.444629385712 | (37.7711317264146, -122.444629385712) | 15 | 5 | 11 | 29492 | 9 | |||||
| 7629 | 248826 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 187 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007246.75289 | 2097900.1277 | 37.7408438951347 | -122.417518368874 | (37.7408438951347, -122.417518368874) | 2 | 7 | 7 | 28859 | 2 | |||
| 7848 | 54566 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1312 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 3x3 | Permit Number 10364 | 6000274.16247872 | 2109249.10106233 | 37.7716106075543 | -122.44244149612 | (37.7716106075543, -122.44244149612) | 15 | 5 | 11 | 29492 | 9 | ||
| 7909 | 244126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1777 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 0ft | 5998100.8363 | 2108896.3044 | 37.7705178019644 | -122.449933692773 | (37.7705178019644, -122.449933692773) | 15 | 5 | 11 | 29492 | 9 | |||
| 8922 | 222961 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 36 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | Width 4ft | 6006486.54397 | 2109181.00608 | 37.771775773859 | -122.420947632224 | (37.771775773859, -122.420947632224) | 8 | 2 | 9 | 28853 | 19 | |||
| 9073 | 205507 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1518 05th Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 24 | 5994641.65352 | 2105137.30281 | 37.7599980266194 | -122.46162636506 | (37.7599980266194, -122.46162636506) | 15 | 5 | 4 | 56 | 12 | ||||
| 9139 | 12607 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 653 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 125 | 9x7 | 5993406.40366 | 2114819.71467 | 37.7865121620391 | -122.466602254029 | (37.7865121620391, -122.466602254029) | 11 | 6 | 2 | 54 | 11 | |||
| 9240 | 126178 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2413 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000282.738 | 2119543.98555 | 37.7998781830919 | -122.44315133689 | (37.7998781830919, -122.44315133689) | 13 | 9 | 1 | 57 | 17 | |||
| 9354 | 121493 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6012099.85909 | 2104630.58778 | 37.7595961582563 | -122.401210873181 | (37.7595961582563, -122.401210873181) | 10 | 3 | 8 | 28856 | 29 | |||
| 9809 | 120740 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 682 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5989760.03773 | 2110677.58416 | 37.7749279292467 | -122.478914562404 | (37.7749279292467, -122.478914562404) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||||||||||||
| 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 | ||||
| 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 | |||||||||||||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 18302 | 33467 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 72 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37623 | 6006783.56593714 | 2099291.50343979 | 37.7446382277934 | -122.419218573599 | (37.7446382277934, -122.419218573599) | 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 | |
| 18502 | 1999 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 217 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | 3X3 | 6007148.9837828 | 2097704.1672578 | 37.7403003295941 | -122.417842531543 | (37.7403003295941, -122.417842531543) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 |
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) );