trees
3,587 rows where qSpecies_id = 28 sorted by DBH descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75275 | 222092 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 431 Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003571.61021 | 2102712.59852 | 37.7538503420436 | -122.430568944614 | (37.7538503420436, -122.430568944614) | 2 | 4 | 5 | 28862 | 22 | |||
| 75300 | 21834 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 198X LAKE ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 5995045 | 2114905 | 37.7868407552542 | -122.46093934021 | (37.7868407552542, -122.46093934021) | 11 | 6 | 1 | 54 | 11 | |||
| 81167 | 205108 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 44 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 5991339.84346 | 2092605.69382 | 37.7253988339751 | -122.472132170572 | (37.7253988339751, -122.472132170572) | 9 | 8 | 4 | 59 | 40 | |||
| 89637 | 212062 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 31 San Pablo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 5994561.16155 | 2097812.55217 | 37.7398814829331 | -122.461373742812 | (37.7398814829331, -122.461373742812) | 1 | 8 | 4 | 59 | 40 | |||
| 92563 | 182808 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1814 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5988165.8641 | 2102960.2953 | 37.7536456676195 | -122.483863093122 | (37.7536456676195, -122.483863093122) | 1 | 8 | 3 | 56 | 35 | |||
| 113298 | 126294 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009197.28554 | 2121879.69921 | 37.8067957358898 | -122.412468739439 | (37.8067957358898, -122.412468739439) | 3 | 1 | 10 | 308 | 23 | |||
| 116528 | 176026 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 136 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011766.53231 | 2088401.57632 | 37.7150161195868 | -122.401223260471 | (37.7150161195868, -122.401223260471) | 10 | 7 | 8 | 309 | 39 | |||
| 121033 | 212138 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 602x Miramar Ave | 3 | Median : Yard | Tree | DPW 1 | 8 | 5995385.58848 | 2093480.77927 | 37.7280349060874 | -122.458209800162 | (37.7280349060874, -122.458209800162) | 9 | 7 | 4 | 28861 | 40 | ||||
| 124515 | 126208 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2692 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6000784.31459 | 2117172.74456 | 37.7933959669112 | -122.441245469314 | (37.7933959669112, -122.441245469314) | 13 | 9 | 1 | 29490 | 27 | |||
| 127692 | 99342 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986574.23671 | 2113063.60704 | 37.7812937594666 | -122.490110317893 | (37.7812937594666, -122.490110317893) | 11 | 6 | 2 | 55 | 26 | ||
| 133384 | 105167 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 4755X 03RD ST | 1 | Front Yard : Cutout | Tree | Arts Commission 19 | 8 | 3x3 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | |||
| 133971 | 176007 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280 Hester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012229.46857 | 2087834.10203 | 37.7134837647275 | -122.399583326913 | (37.7134837647275, -122.399583326913) | 10 | 3 | 8 | 309 | 1 | |||
| 137569 | 126313 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6011665.22297 | 2121124.95419 | 37.8048615801547 | -122.40387476313 | (37.8048615801547, -122.40387476313) | 3 | 1 | 10 | 28860 | 6 | |||
| 145616 | 111530 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900x BOSWORTH ST | 8 | Front Yard : Yard | Tree | DPW 1 | 8 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
| 150470 | 189436 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301 Mendell St | 5 | : | Tree | Private 2 | 8 | Width 3ft | 6016883.04052 | 2097872.31866 | 37.7413050387037 | -122.384197424971 | (37.7413050387037, -122.384197424971) | 10 | 3 | 8 | 58 | 1 | |||
| 161638 | 205080 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 31 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 5991211.60542 | 2090562.33735 | 37.7197808608892 | -122.47242657625 | (37.7197808608892, -122.47242657625) | 9 | 8 | 4 | 64 | 24 | |||
| 161824 | 206373 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995163.12674 | 2099738.31218 | 37.7452037688521 | -122.459431843925 | (37.7452037688521, -122.459431843925) | 1 | 8 | 4 | 59 | 40 | |||
| 163301 | 206396 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 154 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5994267.309 | 2096914.39622 | 37.7373984529805 | -122.462324629276 | (37.7373984529805, -122.462324629276) | 9 | 8 | 4 | 59 | 40 | |||
| 172722 | 98925 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3541 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | 5997905.152 | 2115121.83421 | 37.7876002859601 | -122.451059569364 | (37.7876002859601, -122.451059569364) | 11 | 6 | 1 | 54 | 31 | |||
| 175421 | 212088 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 175 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 5994342.27003 | 2096639.03726 | 37.7366467015913 | -122.462045493226 | (37.7366467015913, -122.462045493226) | 9 | 8 | 4 | 59 | 40 | |||
| 176266 | 5117 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2720 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2002 12:00:00 AM | 8 | 5x6 | 6002348.76973 | 2096171.20815 | 37.735819866687 | -122.434330167515 | (37.735819866687, -122.434330167515) | 2 | 7 | 5 | 63 | 7 | ||
| 179392 | 137527 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300 Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002268.7428 | 2113135.9189 | 37.7823963227446 | -122.435820282125 | (37.7823963227446, -122.435820282125) | 15 | 5 | 11 | 29490 | 41 | |||
| 185566 | 206382 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 6 San Pablo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5994455.43125 | 2097793.85045 | 37.7398240468482 | -122.461737955636 | (37.7398240468482, -122.461737955636) | 1 | 8 | 4 | 59 | 40 | |||
| 187080 | 212264 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991294.251 | 2091109.76949 | 37.7212887577439 | -122.472180785219 | (37.7212887577439, -122.472180785219) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | |||
| 59283 | 5088 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2586 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 75 | 3X3 | 6002230.0958 | 2096785.75676 | 37.7375005386149 | -122.434784402504 | (37.7375005386149, -122.434784402504) | 2 | 7 | 5 | 63 | 7 | |||
| 69029 | 15985 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2543 Diamond St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | 3X3 | 6002304.1295915 | 2097048.5555312 | 37.7382263262375 | -122.434547218349 | (37.7382263262375, -122.434547218349) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 30760 | 12633 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 901 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 5992608.24045 | 2114791.4731 | 37.7863885262578 | -122.469361619855 | (37.7863885262578, -122.469361619855) | 11 | 6 | 2 | 54 | 11 | |||
| 44022 | 17728 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300X Pierce St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 05/20/1992 12:00:00 AM | 70 | 3X3 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | ||
| 57002 | 12634 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 901 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 5992626.81907 | 2114790.44344 | 37.7863867727046 | -122.469297268142 | (37.7863867727046, -122.469297268142) | 11 | 6 | 2 | 54 | 11 | |||
| 60801 | 24545 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 704 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X4 | 6007936.03774 | 2097164.78596 | 37.7388635691031 | -122.415083035373 | (37.7388635691031, -122.415083035373) | 2 | 7 | 7 | 28859 | 2 | |||
| 62173 | 13395 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 316 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 70 | 5 | 5999447.6447037 | 2097480.7016993 | 37.7392503280525 | -122.444454543024 | (37.7392503280525, -122.444454543024) | 9 | 7 | 4 | 59 | 40 | |||
| 118074 | 12547 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280X Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5994746.02737 | 2114925.4133 | 37.7868795968599 | -122.461975189313 | (37.7868795968599, -122.461975189313) | 11 | 6 | 1 | 54 | 11 | |||
| 165596 | 12676 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1302 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4X4 | 5991438.14945 | 2114803.82797 | 37.786354762234 | -122.473410699647 | (37.786354762234, -122.473410699647) | 11 | 6 | 1 | 54 | 33 | |||
| 167537 | 12635 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 901 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5992640.98396 | 2114793.0195 | 37.7863946643837 | -122.469248449218 | (37.7863946643837, -122.469248449218) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 32616 | 206303 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500x Junipero Serra Blvd | 34 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991439.20179 | 2094163.21932 | 37.7296811600564 | -122.471902166249 | (37.7296811600564, -122.471902166249) | 9 | 8 | 4 | 59 | 40 | |||
| 38895 | 176008 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280 Hester Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012207.9471 | 2087849.83115 | 37.7135257540887 | -122.399658816915 | (37.7135257540887, -122.399658816915) | 10 | 3 | 8 | 309 | 1 | |||
| 38986 | 205098 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 29 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991316.70247 | 2092233.82069 | 37.7243764235161 | -122.472185071407 | (37.7243764235161, -122.472185071407) | 9 | 8 | 4 | 59 | 40 | |||
| 40099 | 212306 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 22 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991196.13313 | 2090333.39999 | 37.7191513597144 | -122.472463376508 | (37.7191513597144, -122.472463376508) | 9 | 8 | 4 | 64 | 24 | |||
| 47736 | 205105 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 39 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991330.58276 | 2092481.99012 | 37.7250586384304 | -122.472155170739 | (37.7250586384304, -122.472155170739) | 9 | 8 | 4 | 59 | 40 | |||
| 52063 | 124438 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349 Cherry St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996187.96111 | 2114964.97685 | 37.7870711366417 | -122.456989324693 | (37.7870711366417, -122.456989324693) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | ||||
| 57214 | 212140 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 602x Miramar Ave | 6 | Median : Yard | Tree | DPW 1 | 7 | 5995385.57791 | 2093583.78482 | 37.7283177338747 | -122.458217288803 | (37.7283177338747, -122.458217288803) | 9 | 7 | 4 | 28861 | 40 | ||||
| 60515 | 205092 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 22 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991305.54801 | 2092051.849 | 37.723876128855 | -122.472210372006 | (37.723876128855, -122.472210372006) | 9 | 8 | 4 | 59 | 40 | |||
| 62048 | 212127 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400x Miramar Ave | 3 | Median : Yard | Tree | DPW 1 | 7 | 5995366.60081 | 2092506.27853 | 37.7253580704006 | -122.458204939327 | (37.7253580704006, -122.458204939327) | 9 | 7 | 4 | 28861 | 40 | ||||
| 62304 | 212044 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 29 San Leandro Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992357.05317 | 2096532.52984 | 37.7362397619376 | -122.468901434378 | (37.7362397619376, -122.468901434378) | 1 | 8 | 4 | 59 | 40 | |||
| 62482 | 126207 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2692 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6000770.45736 | 2117170.22017 | 37.7933882462337 | -122.441293235 | (37.7933882462337, -122.441293235) | 13 | 9 | 1 | 29490 | 27 | |||
| 84025 | 124262 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5994889.29773 | 2114930.8515 | 37.7869027759437 | -122.461479904872 | (37.7869027759437, -122.461479904872) | 11 | 6 | 1 | 54 | 11 | |||
| 84187 | 212021 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 52 San Leandro Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992352.26357 | 2096295.36213 | 37.7355882822803 | -122.468900740075 | (37.7355882822803, -122.468900740075) | 1 | 8 | 4 | 59 | 40 | |||
| 84408 | 206395 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 140 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5994257.3897 | 2096991.29786 | 37.7376090346331 | -122.46236450072 | (37.7376090346331, -122.46236450072) | 9 | 8 | 4 | 59 | 40 | |||
| 85091 | 205082 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 34 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991216.27623 | 2090657.65451 | 37.7200428486756 | -122.472417376165 | (37.7200428486756, -122.472417376165) | 9 | 8 | 4 | 64 | 24 | |||
| 85551 | 212308 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 24 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991201.47803 | 2090397.56088 | 37.7193278390954 | -122.472449576408 | (37.7193278390954, -122.472449576408) | 9 | 8 | 4 | 64 | 24 | |||
| 101417 | 212075 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 105 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5994262.67597 | 2097310.06479 | 37.7384845939004 | -122.462369337275 | (37.7384845939004, -122.462369337275) | 9 | 8 | 4 | 59 | 40 | |||
| 102955 | 31435 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4319 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | 7 | Permit Number 46573 | 6000964.17426 | 2103290.04828 | 37.7552878220004 | -122.43962743516 | (37.7552878220004, -122.43962743516) | 2 | 4 | 5 | 28862 | 22 | |
| 118360 | 50633 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2900 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | 7 | Permit Number 47740 | 6014091.6306 | 2090874.9645 | 37.721936997211 | -122.393359654849 | (37.721936997211, -122.393359654849) | 10 | 3 | 8 | 58 | 1 | |
| 122380 | 206388 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 30 San Pablo Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5994328.56615 | 2097694.80223 | 37.739544781266 | -122.462169417096 | (37.739544781266, -122.462169417096) | 1 | 8 | 4 | 59 | 40 | |||
| 128062 | 124437 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349 Cherry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996187.83905 | 2114973.87692 | 37.7870955668367 | -122.456990390989 | (37.7870955668367, -122.456990390989) | 11 | 6 | 1 | 54 | 31 | |||
| 128172 | 211997 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 135 San Leandro Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5992398.43952 | 2095776.76806 | 37.7341670206952 | -122.468703370368 | (37.7341670206952, -122.468703370368) | 9 | 8 | 4 | 59 | 40 | |||
| 133378 | 206381 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 6 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5994515.46684 | 2097828.68165 | 37.7399231404381 | -122.461532903932 | (37.7399231404381, -122.461532903932) | 1 | 8 | 4 | 59 | 40 | |||
| 136725 | 206398 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 170 San Pablo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5994279.6027 | 2096813.24705 | 37.7371214303175 | -122.462274790658 | (37.7371214303175, -122.462274790658) | 9 | 8 | 4 | 59 | 40 | |||
| 139461 | 205104 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 38 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991328.11288 | 2092459.51484 | 37.7249967839599 | -122.472162071244 | (37.7249967839599, -122.472162071244) | 9 | 8 | 4 | 59 | 40 | |||
| 149294 | 189477 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 149 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015966.3296 | 2113647.95256 | 37.7845708108238 | -122.388467979813 | (37.7845708108238, -122.388467979813) | 6 | 2 | 9 | 28856 | 6 | |||
| 152972 | 212261 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991287.20633 | 2090983.7854 | 37.7209424288218 | -122.472195957673 | (37.7209424288218, -122.472195957673) | 9 | 8 | 6 | 64 | 24 | |||
| 153414 | 176034 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Junipero Serra Blvd | 4 | : | Tree | Private 2 | 7 | Width 0ft | 5991251.90527 | 2089128.82374 | 37.7158471165157 | -122.472182837493 | (37.7158471165157, -122.472182837493) | 1 | 8 | 4 | 64 | 24 | |||
| 158682 | 212300 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 16 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991186.31185 | 2090192.49351 | 37.7187638967107 | -122.472487057435 | (37.7187638967107, -122.472487057435) | 9 | 8 | 4 | 64 | 24 | |||
| 159473 | 212064 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 45 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5994487.79606 | 2097767.49144 | 37.7397535345889 | -122.461624141958 | (37.7397535345889, -122.461624141958) | 1 | 8 | 4 | 59 | 40 | |||
| 164207 | 205110 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 48 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5991343.90426 | 2092703.66679 | 37.7256680783935 | -122.472125270987 | (37.7256680783935, -122.472125270987) | 9 | 8 | 4 | 59 | 40 | |||
| 164650 | 189432 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1600 Davidson Ave | 1 | Front Yard : Yard | Tree | Private 2 | 7 | Width 6ft | 6014722.01923 | 2099603.1392 | 37.7459377919092 | -122.391790529623 | (37.7459377919092, -122.391790529623) | 10 | 3 | 8 | 58 | 1 | |||
| 167621 | 176033 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Junipero Serra Blvd | 3 | : | Tree | Private 2 | 7 | Width 0ft | 5991250.41814 | 2089152.61686 | 37.7159123605459 | -122.472189711002 | (37.7159123605459, -122.472189711002) | 1 | 8 | 4 | 64 | 24 | |||
| 175285 | 212126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400x Miramar Ave | 2 | Median : Yard | Tree | DPW 1 | 7 | 5995367.13793 | 2092485.42648 | 37.725300846538 | -122.458201574057 | (37.725300846538, -122.458201574057) | 9 | 7 | 4 | 28861 | 40 | ||||
| 185412 | 117356 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6005443.21862963 | 2111009.61442816 | 37.7767378239513 | -122.424686672119 | (37.7767378239513, -122.424686672119) | 7 | 9 | 11 | 28852 | 10 | |||
| 191549 | 212272 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 851 Junipero Serra Blvd | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5991349.46561 | 2091914.71653 | 37.7235021385885 | -122.4720485669 | (37.7235021385885, -122.4720485669) | 9 | 8 | 4 | 59 | 40 | |||
| 80991 | 105000 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280X SAN MARCOS AVE | 1 | Median : Cutout | Tree | DPW 1 | 65 | Tree tag no. 416 | 5993063.2 | 2100277.9 | 37.7465643757171 | -122.466732187112 | (37.7465643757171, -122.466732187112) | 1 | 8 | 4 | 29491 | 40 | |||
| 148382 | 217821 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1x Junipero Serra Blvd | 9 | Median : Yard | Tree | DPW 1 | 65 | 5991615.01367 | 2095586.81694 | 37.7336001735084 | -122.471398059368 | (37.7336001735084, -122.471398059368) | 1 | 8 | 4 | 59 | 40 | ||||
| 165232 | 5124 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2740 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 65 | 3X3 | 6002421.30392 | 2096030.43222 | 37.7354374451851 | -122.434069328485 | (37.7354374451851, -122.434069328485) | 2 | 7 | 5 | 63 | 7 | |||
| 10114 | 12679 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1302 Lake St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4x4 | 5991386.80092 | 2114799.39324 | 37.7863396121206 | -122.473588027094 | (37.7863396121206, -122.473588027094) | 11 | 6 | 1 | 54 | 33 | |||
| 35794 | 12552 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280X Lake St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5994647.05266 | 2114915.6366 | 37.7868470540675 | -122.462316907107 | (37.7868470540675, -122.462316907107) | 11 | 6 | 1 | 54 | 11 | |||
| 114115 | 4767 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 26 Commer Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6016521.3746591 | 2094751.2728264 | 37.7327152718937 | -122.385230528967 | (37.7327152718937, -122.385230528967) | 10 | 3 | 8 | 58 | 1 | |||
| 188736 | 98324 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1899X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x3 | 6001966.9 | 2114999.4 | 37.7874958161075 | -122.4369979772 | (37.7874958161075, -122.4369979772) | 13 | 6 | 11 | 29490 | 27 | |||
| 190681 | 12574 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 352 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 5994320.89991 | 2114924.89711 | 37.7868536951076 | -122.463445983594 | (37.7868536951076, -122.463445983594) | 11 | 6 | 1 | 54 | 11 | |||
| 1723 | 19755 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY15 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
| 1845 | 20002 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY46 | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2 | |||||||||||||
| 3449 | 19754 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY15 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
| 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 | |||
| 13816 | 99468 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Miramar Ave | 4 | Median : Cutout | Tree | Private 2 | 6 | 15x280 | 5995435.2 | 2093399 | 37.7278132105567 | -122.458032376835 | (37.7278132105567, -122.458032376835) | 9 | 7 | 4 | 28861 | 40 | |||
| 17286 | 24406 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/28/2000 12:00:00 AM | 6 | 3x3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
| 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 | |||
| 24726 | 14899 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 160 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6016997.24223 | 2098390.01536 | 37.7427328424729 | -122.383838589425 | (37.7427328424729, -122.383838589425) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 29397 | 24458 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 6 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
| 31250 | 212259 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991274.76967 | 2090780.48576 | 37.7203834983807 | -122.472224135259 | (37.7203834983807, -122.472224135259) | 9 | 8 | 6 | 64 | 24 | |||
| 33486 | 176038 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Junipero Serra Blvd | 9 | : | Tree | Private 2 | 6 | Width 0ft | 5991295.02694 | 2088957.62103 | 37.7153795311078 | -122.472021319244 | (37.7153795311078, -122.472021319244) | 1 | 8 | 4 | 64 | 24 | |||
| 35907 | 248657 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 San Jose Ave | 111 | Front Yard : Yard | Tree | Private 2 | 6 | 6005025.16759 | 2096929.69692 | 37.7380540578596 | -122.425130754104 | (37.7380540578596, -122.425130754104) | 2 | 7 | 5 | 63 | 7 | ||||
| 36158 | 176035 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1100 Junipero Serra Blvd | 6 | : | Tree | Private 2 | 6 | Width 0ft | 5991271.23185 | 2089055.15051 | 37.7156459462668 | -122.472110669573 | (37.7156459462668, -122.472110669573) | 1 | 8 | 4 | 64 | 24 | |||
| 37800 | 26456 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/13/1997 12:00:00 AM | 6 | 3x3 | 6017743.98861 | 2096808.93299 | 37.7384327587528 | -122.381146620635 | (37.7384327587528, -122.381146620635) | 10 | 3 | 8 | 58 | 1 | ||
| 42756 | 126211 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2692 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6000823.62641 | 2117177.24031 | 37.7934105503173 | -122.441109770604 | (37.7934105503173, -122.441109770604) | 13 | 9 | 1 | 29490 | 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) );