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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21335 | 248633 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1550 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6009395.0721 | 2107534.93214 | 37.767419555005 | -122.410770529855 | (37.767419555005, -122.410770529855) | 8 | 4 | 7 | 28853 | 19 | |||
| 21663 | 189513 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 130 Acacia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6018133.38456 | 2096174.43393 | 37.7367120373179 | -122.379756193195 | (37.7367120373179, -122.379756193195) | 10 | 3 | 8 | 58 | 1 | |||
| 21752 | 29977 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 610X Junipero Serra Blvd | 2 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991336.00972369 | 2093444.32433125 | 37.7277012826104 | -122.47220652658 | (37.7277012826104, -122.47220652658) | 9 | 8 | 4 | 64 | 40 | ||
| 21784 | 123231 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 759 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 6ft | 5993483.55222 | 2110312.60045 | 37.7741412977795 | -122.466007712161 | (37.7741412977795, -122.466007712161) | 11 | 6 | 2 | 54 | 11 | |||
| 21802 | 212277 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 751 Junipero Serra Blvd | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5991382.29042 | 2092479.81131 | 37.725055648191 | -122.471976265919 | (37.725055648191, -122.471976265919) | 9 | 8 | 4 | 59 | 40 | |||
| 21817 | 222088 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3757 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003335.69899 | 2103576.63958 | 37.7562094265452 | -122.431446457193 | (37.7562094265452, -122.431446457193) | 2 | 4 | 5 | 28862 | 22 | |||
| 21890 | 205097 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 27 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991311.65126 | 2092183.57203 | 37.7242381608387 | -122.472198871475 | (37.7242381608387, -122.472198871475) | 9 | 8 | 4 | 59 | 40 | |||
| 21900 | 176048 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989010.93647 | 2089619.81285 | 37.7170653066825 | -122.479964486788 | (37.7170653066825, -122.479964486788) | 1 | 8 | 4 | 64 | 14 | ||||
| 21958 | 248538 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 109 Beulah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997573.6273 | 2107783.5338 | 37.767432238783 | -122.451677021277 | (37.767432238783, -122.451677021277) | 15 | 5 | 11 | 29492 | 9 | |||
| 21966 | 14887 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2006 12:00:00 AM | 3 | 3x3 | 6017068.53164 | 2098456.8281 | 37.7429202372855 | -122.383596739007 | (37.7429202372855, -122.383596739007) | 10 | 3 | 8 | 58 | 1 | ||
| 22098 | 205111 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 49 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991346.44389 | 2092729.45294 | 37.7257390277172 | -122.472118370494 | (37.7257390277172, -122.472118370494) | 9 | 8 | 4 | 59 | 40 | |||
| 22317 | 30044 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Junipero Serra Blvd | 25 | Median : Cutout | Tree | DPW 1 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.471585892822 | (37.7138086207581, -122.471585892822) | 1 | 8 | 4 | 64 | 24 | |||
| 22374 | 12660 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1045 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 4X4 | 5992154.39933 | 2114773.56456 | 37.7863131171963 | -122.470930475416 | (37.7863131171963, -122.470930475416) | 11 | 6 | 2 | 54 | 11 | |||
| 22384 | 14951 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 225 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017001.18429 | 2098171.14482 | 37.7421320862857 | -122.383809722815 | (37.7421320862857, -122.383809722815) | 10 | 3 | 8 | 58 | 1 | |||
| 22428 | 248743 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2225 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6008185.21113 | 2105259.93562 | 37.7611050308912 | -122.41479426214 | (37.7611050308912, -122.41479426214) | 2 | 4 | 7 | 28859 | 19 | |||
| 22477 | 248840 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 65 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006855.4137 | 2099329.69653 | 37.7447471434584 | -122.418972846027 | (37.7447471434584, -122.418972846027) | 2 | 7 | 7 | 28859 | 2 | |||
| 22614 | 142207 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 427 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 0ft | 5999714.6993 | 2110123.1538 | 37.7739786302184 | -122.444439532021 | (37.7739786302184, -122.444439532021) | 15 | 5 | 11 | 29492 | 16 | |||
| 22615 | 212111 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1802x Monterey Blvd | 2 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 5992507.56631 | 2095396.95389 | 37.7331304494932 | -122.468298465918 | (37.7331304494932, -122.468298465918) | 9 | 8 | 4 | 59 | 40 | |||
| 22671 | 248642 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 101 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007785.69421 | 2107933.31633 | 37.7684230563089 | -122.416365384082 | (37.7684230563089, -122.416365384082) | 8 | 4 | 7 | 28853 | 19 | |||
| 22731 | 11780 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Junipero Serra Blvd | 12 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991289.71415 | 2091805.70466 | 37.7231993611319 | -122.472247172286 | (37.7231993611319, -122.472247172286) | 9 | 8 | 4 | 59 | 40 | ||
| 22869 | 12149 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X La Salle Ave | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016248.95724 | 2095649.36964 | 37.735166191751 | -122.386234942494 | (37.735166191751, -122.386234942494) | 10 | 3 | 8 | 58 | 1 | |||
| 22924 | 246218 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1378 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5999578.5072 | 2107913.2961 | 37.7679031482442 | -122.444751767156 | (37.7679031482442, -122.444751767156) | 15 | 5 | 11 | 29492 | 9 | |||
| 22935 | 12652 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5992352.41288 | 2114839.20557 | 37.7865047992766 | -122.470250187524 | (37.7865047992766, -122.470250187524) | 11 | 6 | 1 | 54 | 11 | |||
| 23052 | 3754 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1020 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 36 | 18 | 6012443.0515847 | 2103208.5839527 | 37.755710788358 | -122.399924077269 | (37.755710788358, -122.399924077269) | 10 | 3 | 8 | 28856 | 29 | |||
| 23077 | 16168 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 425 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 28 | 3X3 | 5999268.01839 | 2094645.05904 | 37.7314540727301 | -122.444871826278 | (37.7314540727301, -122.444871826278) | 9 | 7 | 4 | 59 | 40 | ||
| 23094 | 248636 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 83 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6005406.472 | 2103224.32125 | 37.7553591885768 | -122.42425995315 | (37.7553591885768, -122.42425995315) | 2 | 4 | 5 | 28859 | 19 | |||
| 23098 | 189496 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Acacia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017841.42794 | 2096187.45373 | 37.736731678516 | -122.380766529361 | (37.736731678516, -122.380766529361) | 10 | 3 | 8 | 58 | 1 | |||
| 23280 | 22237 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4445 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6015309.22014 | 2096468.43632 | 37.7373631231169 | -122.389541166269 | (37.7373631231169, -122.389541166269) | 10 | 3 | 8 | 58 | 1 | |||
| 23313 | 67885 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 558 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/1993 12:00:00 AM | 11 | 4x4 | Permit Number 31579 | 6012000.40021 | 2117278.49262 | 37.7943188457921 | -122.402444206153 | (37.7943188457921, -122.402444206153) | 3 | 1 | 10 | 28860 | 4 | |
| 23339 | 248637 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 83 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6005405.36943 | 2103242.79732 | 37.7554098573023 | -122.424265080165 | (37.7554098573023, -122.424265080165) | 2 | 4 | 5 | 28859 | 19 | |||
| 23438 | 5987 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1640 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x6 | 6002592.39189 | 2112708.53671 | 37.7812412183178 | -122.434670029614 | (37.7812412183178, -122.434670029614) | 15 | 5 | 11 | 29490 | 41 | |||
| 23442 | 1196 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3080 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/1992 12:00:00 AM | 28 | 3X3 | 5996438.01379 | 2087205.1874 | 37.7108640234246 | -122.454118486498 | (37.7108640234246, -122.454118486498) | 9 | 7 | 6 | 28861 | 25 | ||
| 23470 | 16820 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2130 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001107.6476595 | 2113179.9385941 | 37.782451166007 | -122.439840308676 | (37.782451166007, -122.439840308676) | 15 | 5 | 11 | 29490 | 41 | |||
| 23585 | 2101 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000X Bosworth St | 9 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 14 | 6001184.3961353 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | 9 | 7 | 5 | 63 | 7 | |||
| 23632 | 222089 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3751 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003397.45281 | 2103581.47899 | 37.7562262141931 | -122.43123323693 | (37.7562262141931, -122.43123323693) | 2 | 4 | 5 | 28862 | 22 | |||
| 23645 | 16758 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1900X O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002203.1786904 | 2113328.4738156 | 37.7829213052255 | -122.43606088796 | (37.7829213052255, -122.43606088796) | 13 | 5 | 11 | 29490 | 41 | |||
| 23920 | 189446 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 175 Mendell St | 3 | : | Tree | Private 2 | 28 | Width 4ft | 6017051.6761 | 2098373.04051 | 37.7426892419063 | -122.383649189252 | (37.7426892419063, -122.383649189252) | 10 | 3 | 8 | 58 | 1 | |||
| 23933 | 251069 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 5200x Geary Blvd | 1 | Median : Yard | Tree | DPW 1 | 2 | Width 10ft | 5990794.5513 | 2112690.3427 | 37.7805144291466 | -122.475482989541 | (37.7805144291466, -122.475482989541) | 11 | 6 | 2 | 54 | 26 | |||
| 24017 | 14992 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Mendell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016399.93011 | 2097341.84893 | 37.7398217535785 | -122.385830900501 | (37.7398217535785, -122.385830900501) | 10 | 3 | 8 | 58 | 1 | |||
| 24024 | 54655 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 18 | Permit Number 10479 | 6012382.77536 | 2087271.8623 | 37.7119485104815 | -122.399014002112 | (37.7119485104815, -122.399014002112) | 10 | 3 | 8 | 309 | 1 | ||
| 24111 | 2116 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 5 | 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 | ||||
| 24143 | 99344 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 22 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986571.83486 | 2113111.88593 | 37.7814261792312 | -122.490122179259 | (37.7814261792312, -122.490122179259) | 11 | 6 | 2 | 55 | 26 | ||
| 24244 | 139815 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1652 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | Width 0ft | 6002517 | 2112708 | 37.7812354643217 | -122.434930809638 | (37.7812354643217, -122.434930809638) | 15 | 5 | 11 | 29490 | 41 | |||
| 24268 | 142433 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 0ft | 5997499.5859 | 2114503.0128 | 37.7858779390155 | -122.452418068061 | (37.7858779390155, -122.452418068061) | 11 | 6 | 1 | 54 | 31 | |||
| 24318 | 12678 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1302 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 4X4 | 5991402.06133 | 2114800.45081 | 37.7863433996674 | -122.473535307672 | (37.7863433996674, -122.473535307672) | 11 | 6 | 1 | 54 | 33 | |||
| 24340 | 126290 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1198 Columbus Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6007603.03986 | 2121549.62811 | 37.8057998482576 | -122.417962541334 | (37.8057998482576, -122.417962541334) | 5 | 1 | 10 | 308 | 23 | |||
| 24372 | 212187 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 720 Bosworth St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 16 | 6002096.28779 | 2095466.30888 | 37.733870041163 | -122.435152693763 | (37.733870041163, -122.435152693763) | 2 | 7 | 5 | 63 | 7 | ||||
| 24554 | 142386 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 0ft | 5998114.6675 | 2114591.1717 | 37.7861552196694 | -122.450296423393 | (37.7861552196694, -122.450296423393) | 11 | 6 | 1 | 54 | 31 | |||
| 24587 | 126136 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2722 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6000010.55961 | 2117815.97054 | 37.7951179896682 | -122.443968946536 | (37.7951179896682, -122.443968946536) | 13 | 9 | 1 | 57 | 17 | |||
| 24625 | 199947 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1322 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6016399.8746 | 2093108.561 | 37.7281979890567 | -122.385536147419 | (37.7281979890567, -122.385536147419) | 10 | 3 | 8 | 58 | 1 | |||
| 24635 | 251248 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 829 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001839 | 2095802 | 37.7347771581377 | -122.436066227259 | (37.7347771581377, -122.436066227259) | 2 | 7 | 5 | 63 | 7 | ||||
| 24640 | 176024 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 3 | Front Yard : Yard | Tree | Private 2 | 25 | 6009648.36238 | 2089313.42999 | 37.7174014822691 | -122.40860887622 | (37.7174014822691, -122.40860887622) | 9 | 7 | 8 | 309 | 18 | ||||
| 24749 | 201463 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 221 Catalina St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 6017910.15961 | 2096044.43658 | 37.736342774794 | -122.380518954089 | (37.736342774794, -122.380518954089) | 10 | 3 | 8 | 58 | 1 | |||
| 24858 | 120075 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 135 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5987696.45298 | 2115057.78701 | 37.7868346797306 | -122.486374501304 | (37.7868346797306, -122.486374501304) | 11 | 6 | 1 | 55 | 33 | |||
| 25023 | 176021 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Ervine St | 8 | Front Yard : Yard | Tree | Private 2 | 5 | 6009620.69504 | 2089243.53702 | 37.7172080210075 | -122.408699581837 | (37.7172080210075, -122.408699581837) | 9 | 7 | 8 | 309 | 18 | ||||
| 25028 | 23944 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2334X Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003622.99851 | 2115966.72014 | 37.7902458233354 | -122.431337290596 | (37.7902458233354, -122.431337290596) | 13 | 9 | 1 | 29490 | 27 | |||
| 25165 | 124037 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 501 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 5993889.84064 | 2114842.13228 | 37.786601600681 | -122.464931323831 | (37.786601600681, -122.464931323831) | 11 | 6 | 2 | 54 | 11 | |||
| 25171 | 189501 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Acacia Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017983.54314 | 2096181.73638 | 37.7367238220386 | -122.380274772865 | (37.7367238220386, -122.380274772865) | 10 | 3 | 8 | 58 | 1 | |||
| 25334 | 205114 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500x Junipero Serra Blvd | 16 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991407.36099 | 2093694.15878 | 37.7283913946494 | -122.471978068129 | (37.7283913946494, -122.471978068129) | 9 | 8 | 4 | 59 | 40 | |||
| 25351 | 212056 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 69 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 6ft | 5993975.87115 | 2097379.24968 | 37.7386580389404 | -122.463365981278 | (37.7386580389404, -122.463365981278) | 1 | 8 | 4 | 59 | 40 | |||
| 25365 | 248690 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 598 Belvedere St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 21 | Width 2ft | 5998657.19471 | 2105800.74902 | 37.7620500070202 | -122.447786365366 | (37.7620500070202, -122.447786365366) | 15 | 5 | 11 | 29492 | 9 | |||
| 25445 | 1280 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3995X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5992520.10718 | 2087379.1823 | 37.7111163336128 | -122.467672210425 | (37.7111163336128, -122.467672210425) | 9 | 8 | 4 | 64 | 24 | |||
| 25454 | 96949 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 798X 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988521.18817 | 2110597.78203 | 37.7746367985505 | -122.483194104095 | (37.7746367985505, -122.483194104095) | 11 | 6 | 2 | 55 | 26 | |||
| 25471 | 2132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100X Bosworth St | 21 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 0 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | ||||
| 25543 | 126300 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008880.73692 | 2121834.44066 | 37.8066536978683 | -122.413561019128 | (37.8066536978683, -122.413561019128) | 3 | 1 | 10 | 308 | 23 | |||
| 25608 | 212004 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 135 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 5992880.81315 | 2095779.08404 | 37.7342012344874 | -122.467035834859 | (37.7342012344874, -122.467035834859) | 9 | 8 | 4 | 59 | 40 | |||
| 25628 | 100017 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6011791.69231 | 2117640.10072 | 37.7953000816886 | -122.403191812578 | (37.7953000816886, -122.403191812578) | 3 | 1 | 10 | 28860 | 4 | ||||
| 25658 | 7812 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006212.78826 | 2112695.72596 | 37.7814109097272 | -122.422144314234 | (37.7814109097272, -122.422144314234) | 7 | 9 | 11 | 28852 | 41 | |||
| 25688 | 4330 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 831 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001821.43184 | 2095823.4199 | 37.7348349741444 | -122.436128498656 | (37.7348349741444, -122.436128498656) | 2 | 7 | 5 | 63 | 7 | |||
| 25779 | 205107 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 41 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 5991336.964 | 2092532.2101 | 37.7251968993055 | -122.472136770613 | (37.7251968993055, -122.472136770613) | 9 | 8 | 4 | 59 | 40 | |||
| 25864 | 5789 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 551 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003097.4127 | 2108300.15747 | 37.7691655581641 | -122.432607921711 | (37.7691655581641, -122.432607921711) | 15 | 5 | 5 | 28862 | 3 | |||
| 25883 | 142395 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 0ft | 5997933.9503 | 2114564.4364 | 37.7860714676838 | -122.450919725605 | (37.7860714676838, -122.450919725605) | 11 | 6 | 1 | 54 | 31 | |||
| 25886 | 126275 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2836 Larkin St | 7 | Side Yard : Yard | Tree | Private 2 | 26 | 6006511.2494 | 2120976.42855 | 37.8041644823576 | -122.421700114785 | (37.8041644823576, -122.421700114785) | 5 | 9 | 1 | 28858 | 32 | ||||
| 26104 | 206342 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401 15th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5991726.99536 | 2097627.51238 | 37.7392098845372 | -122.471159534008 | (37.7392098845372, -122.471159534008) | 1 | 8 | 4 | 29491 | 40 | |||
| 26325 | 124553 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 36 Palm Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5995908.32639 | 2114279.98645 | 37.7851742747708 | -122.457907204393 | (37.7851742747708, -122.457907204393) | 11 | 6 | 1 | 54 | 31 | |||
| 26452 | 249722 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Broderick St | 6 | Front Yard : Yard | Tree | Private 2 | 14 | 6000190.26691 | 2117349.57001 | 37.7938476262185 | -122.443313617731 | (37.7938476262185, -122.443313617731) | 13 | 9 | 1 | 57 | 27 | ||||
| 26456 | 206405 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 160 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 3ft | 5994407.40356 | 2096440.94307 | 37.7361065336912 | -122.461805940812 | (37.7361065336912, -122.461805940812) | 9 | 8 | 4 | 59 | 40 | |||
| 26494 | 222099 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 58 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6003922.64158 | 2105116.71076 | 37.7604713442974 | -122.429526437895 | (37.7604713442974, -122.429526437895) | 2 | 4 | 5 | 28862 | 3 | |||
| 26505 | 212298 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 12 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 5991179.12071 | 2090094.55389 | 37.7184945623549 | -122.472504777687 | (37.7184945623549, -122.472504777687) | 9 | 8 | 4 | 64 | 24 | |||
| 26634 | 212204 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | Width 3ft | 6001555.51112 | 2095599.51711 | 37.7342050772889 | -122.437031852331 | (37.7342050772889, -122.437031852331) | 9 | 7 | 5 | 63 | 7 | |||
| 26716 | 26466 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | |||
| 26824 | 139535 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2171 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 6000955.3801 | 2113112.4377 | 37.7822571572358 | -122.440362244117 | (37.7822571572358, -122.440362244117) | 15 | 5 | 11 | 29490 | 41 | |||
| 27004 | 141435 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 511 HAYES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005366.2195 | 2110950.1956 | 37.776570325295 | -122.424948806725 | (37.776570325295, -122.424948806725) | 7 | 9 | 11 | 28852 | 10 | |||
| 27098 | 212033 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 77 San Leandro Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 42 | Width 8ft | 5992382.09631 | 2096171.88188 | 37.7352509600559 | -122.468788615307 | (37.7352509600559, -122.468788615307) | 1 | 8 | 4 | 59 | 40 | |||
| 27149 | 206329 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 218 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5996602.13864 | 2105802.63508 | 37.7619375135335 | -122.454894104978 | (37.7619375135335, -122.454894104978) | 15 | 5 | 11 | 29492 | 12 | |||
| 27332 | 14938 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016907.69513 | 2098053.92414 | 37.741805053675 | -122.384124820925 | (37.741805053675, -122.384124820925) | 10 | 3 | 8 | 58 | 1 | |||
| 27547 | 2079 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900X Bosworth St | 10 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001652.8683328 | 2095576.0345147 | 37.7341461328318 | -122.436693577752 | (37.7341461328318, -122.436693577752) | 2 | 7 | 5 | 63 | 7 | |||
| 27609 | 142416 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5997686.3947 | 2114529.7482 | 37.7859620480803 | -122.451773694005 | (37.7859620480803, -122.451773694005) | 11 | 6 | 1 | 54 | 31 | |||
| 27659 | 206363 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 136 San Leandro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 5992358.97952 | 2095954.25785 | 37.7346520835226 | -122.468852706414 | (37.7346520835226, -122.468852706414) | 9 | 8 | 4 | 59 | 40 | |||
| 27861 | 126209 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2692 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6000795.3234 | 2117174.07818 | 37.7934002557748 | -122.441207473859 | (37.7934002557748, -122.441207473859) | 13 | 9 | 1 | 29490 | 27 | |||
| 27989 | 248699 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 839 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5998645.80739 | 2107339.54148 | 37.7662744931923 | -122.447936542246 | (37.7662744931923, -122.447936542246) | 15 | 5 | 11 | 29492 | 9 | |||
| 28235 | 122331 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 950X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996124 | 2112291 | 37.7797254357482 | -122.45701712634 | (37.7797254357482, -122.45701712634) | 11 | 6 | 2 | 54 | 16 | ||||
| 28361 | 5082 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2563 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002286.6614 | 2096942.37452 | 37.7379337860994 | -122.434600024386 | (37.7379337860994, -122.434600024386) | 2 | 7 | 5 | 63 | 7 | |||
| 28380 | 142413 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 0ft | 5997716.1759 | 2114533.1324 | 37.7859730457909 | -122.451670903916 | (37.7859730457909, -122.451670903916) | 11 | 6 | 1 | 54 | 31 | |||
| 28428 | 126195 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2315 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6000798.79511 | 2116331.19704 | 37.7910861220794 | -122.441134960611 | (37.7910861220794, -122.441134960611) | 13 | 6 | 1 | 29490 | 27 | |||
| 28434 | 248681 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 325 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6004375.69481 | 2100128.24838 | 37.7467998370462 | -122.427604122635 | (37.7467998370462, -122.427604122635) | 2 | 7 | 5 | 63 | 22 | |||
| 28479 | 126251 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Elm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6007028.01622 | 2112773.92137 | 37.7816715629397 | -122.419329563908 | (37.7816715629397, -122.419329563908) | 7 | 9 | 9 | 28852 | 36 | |||
| 28594 | 2069 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 843 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001701.03191 | 2095490.91331 | 37.7339151466682 | -122.436520970873 | (37.7339151466682, -122.436520970873) | 9 | 7 | 5 | 63 | 40 | |||
| 28624 | 212089 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 223 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 4ft | 5994065.04722 | 2096675.37629 | 37.7367305147902 | -122.463006600482 | (37.7367305147902, -122.463006600482) | 9 | 8 | 4 | 59 | 40 | |||
| 28643 | 2608 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1760 Bush St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005030.51103 | 2115130.79368 | 37.7880302457848 | -122.426407854199 | (37.7880302457848, -122.426407854199) | 13 | 9 | 11 | 28858 | 27 |
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) );