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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17759 | 8164 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1108 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 6002345.91863 | 2111334.94694 | 37.7774556905463 | -122.435424415956 | (37.7774556905463, -122.435424415956) | 15 | 5 | 11 | 29492 | 41 | |||
30248 | 12543 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 239 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5994669.04887 | 2114868.49847 | 37.786718892107 | -122.462237385897 | (37.786718892107, -122.462237385897) | 11 | 6 | 1 | 54 | 11 | |||
36800 | 1993 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 162 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6007301.50891 | 2098085.20202 | 37.7413551489316 | -122.417342154839 | (37.7413551489316, -122.417342154839) | 2 | 7 | 7 | 28859 | 2 | |||
42002 | 12629 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 841 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5992807.54616 | 2114798.77579 | 37.7864200929582 | -122.468672610251 | (37.7864200929582, -122.468672610251) | 11 | 6 | 2 | 54 | 11 | |||
47489 | 17723 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 90 | 3X3 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | |||
79675 | 12637 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 906 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5992634.642 | 2114847.92041 | 37.7865450406826 | -122.469274388054 | (37.7865450406826, -122.469274388054) | 11 | 6 | 1 | 54 | 11 | |||
82293 | 12601 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 637 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5993509.18858 | 2114827.45466 | 37.7865393448418 | -122.466247209305 | (37.7865393448418, -122.466247209305) | 11 | 6 | 2 | 54 | 11 | |||
82745 | 8148 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 4X4 | 6002886.96217 | 2111360.68278 | 37.7775570672136 | -122.433554609066 | (37.7775570672136, -122.433554609066) | 15 | 5 | 11 | 29492 | 41 | |||
103936 | 8165 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1114 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X4 | 6002315.0099 | 2111292.01756 | 37.7773360617805 | -122.43552826746 | (37.7773360617805, -122.43552826746) | 15 | 5 | 11 | 29492 | 41 | |||
108465 | 26667 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1005X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5992391.24573 | 2114787.53549 | 37.7863651725209 | -122.470112072904 | (37.7863651725209, -122.470112072904) | 11 | 6 | 2 | 54 | 11 | |||
113946 | 24546 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 704 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X4 | 6007961.02706 | 2097162.19636 | 37.7388578629053 | -122.414996450438 | (37.7388578629053, -122.414996450438) | 2 | 7 | 7 | 28859 | 2 | |||
119798 | 19289 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 5995266.05457 | 2114888.33631 | 37.7868077185268 | -122.460173340327 | (37.7868077185268, -122.460173340327) | 11 | 6 | 1 | 54 | 11 | |||
124735 | 12651 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5992370.23809 | 2114839.71142 | 37.7865072187383 | -122.470188554132 | (37.7865072187383, -122.470188554132) | 11 | 6 | 1 | 54 | 11 | |||
133381 | 8154 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1056 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6002712.32604 | 2111336.32587 | 37.7774802791955 | -122.434156991651 | (37.7774802791955, -122.434156991651) | 15 | 5 | 11 | 29492 | 41 | |||
136913 | 12672 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1132 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X4 | 5991897.52815 | 2114823.03375 | 37.786434086563 | -122.47182278185 | (37.786434086563, -122.47182278185) | 11 | 6 | 1 | 54 | 11 | |||
137848 | 12531 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 114 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 6x5.4 | 5995086.05859 | 2114933.31987 | 37.7869208764305 | -122.460799341203 | (37.7869208764305, -122.460799341203) | 11 | 6 | 1 | 54 | 11 | |||
144538 | 17727 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300X Pierce St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 90 | 3X3 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | |||
147246 | 12815 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2139 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5988780.51636 | 2114651.15635 | 37.7857813149586 | -122.482594130976 | (37.7857813149586, -122.482594130976) | 11 | 6 | 2 | 55 | 26 | |||
150197 | 12586 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 446 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 4X4 | 5994034.10882 | 2114901.58036 | 37.7867731461033 | -122.46443651291 | (37.7867731461033, -122.46443651291) | 11 | 6 | 1 | 54 | 11 | |||
163461 | 28145 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 429 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4x4 | 6006920.737469 | 2097958.7102788 | 37.7409864003091 | -122.418649764286 | (37.7409864003091, -122.418649764286) | 2 | 7 | 7 | 28859 | 2 | |||
163868 | 24547 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 704 Cortland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X4 | 6007976.32415 | 2097161.8833 | 37.7388578628999 | -122.414943537915 | (37.7388578628999, -122.414943537915) | 2 | 7 | 7 | 28859 | 2 | |||
173278 | 8147 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 4X4 | 6002886.96217 | 2111360.68278 | 37.7775570672136 | -122.433554609066 | (37.7775570672136, -122.433554609066) | 15 | 5 | 11 | 29492 | 41 | |||
174997 | 12599 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 620 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5993522.38559 | 2114878.26869 | 37.7866796276773 | -122.466205245403 | (37.7866796276773, -122.466205245403) | 11 | 6 | 1 | 54 | 11 | |||
191691 | 5126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2750 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6002442.8157587 | 2095988.0085916 | 37.7353221804907 | -122.433991922534 | (37.7353221804907, -122.433991922534) | 2 | 7 | 5 | 63 | 7 | |||
8333 | 126339 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012176.42228 | 2117479.41237 | 37.7948803483084 | -122.401849275842 | (37.7948803483084, -122.401849275842) | 3 | 1 | 10 | 28860 | 4 | |||
12133 | 133687 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1451 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003859 | 2120749 | 37.803390106055 | -122.430862178125 | (37.803390106055, -122.430862178125) | 13 | 9 | 1 | 28858 | 17 | |||
13507 | 184527 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1961 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5981338.0835 | 2101535.3662 | 37.7493333765729 | -122.507368946557 | (37.7493333765729, -122.507368946557) | 1 | 8 | 3 | 29491 | 35 | |||
20268 | 248759 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2987 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008379.36946 | 2103275.26244 | 37.7556664788408 | -122.413982346112 | (37.7556664788408, -122.413982346112) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 | |||
31298 | 206386 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 30 San Pablo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994357.93255 | 2097720.43356 | 37.7396168493304 | -122.462069739853 | (37.7396168493304, -122.462069739853) | 1 | 8 | 4 | 59 | 40 | |||
33959 | 126223 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2155 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6003784.13407 | 2115883.06343 | 37.7900252539066 | -122.430773801182 | (37.7900252539066, -122.430773801182) | 13 | 9 | 1 | 29490 | 27 | |||
39839 | 93152 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 222 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x13 | 5994796 | 2087777 | 37.7123397937745 | -122.459835021723 | (37.7123397937745, -122.459835021723) | 9 | 8 | 6 | 28861 | 24 | |||
40695 | 124226 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 197 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5996593.35228 | 2111590.32316 | 37.7778285035014 | -122.455342789124 | (37.7778285035014, -122.455342789124) | 11 | 6 | 2 | 54 | 16 | |||
41319 | 126210 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2692 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6000809.47478 | 2117175.6594 | 37.7934054034746 | -122.441158622678 | (37.7934054034746, -122.441158622678) | 13 | 9 | 1 | 29490 | 27 | |||
42309 | 24332 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1999 12:00:00 AM | 9 | 6006393.27479 | 2112527.98365 | 37.7809605085733 | -122.421508000714 | (37.7809605085733, -122.421508000714) | 7 | 9 | 11 | 28852 | 41 | |||
51784 | 121350 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 399X Cargo Way | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6017829 | 2098352 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | 10 | 3 | 8 | 58 | 1 | |||
55465 | 199744 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2301 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014576.6362 | 2092566.7568 | 37.726609256129 | -122.391801334681 | (37.726609256129, -122.391801334681) | 10 | 3 | 8 | 58 | 1 | |||
60191 | 176030 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 121 Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010531.16028 | 2086717.01407 | 37.710321653982 | -122.405374690189 | (37.710321653982, -122.405374690189) | 9 | 7 | 8 | 309 | 39 | |||
60377 | 19179 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 106 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6003475.35494 | 2107644.30442 | 37.767386171248 | -122.431253819727 | (37.767386171248, -122.431253819727) | 15 | 9 | 5 | 28862 | 3 | |||
63537 | 248781 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 784 Duncan St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6001437.23624 | 2099723.01207 | 37.7455205064601 | -122.43773599094 | (37.7455205064601, -122.43773599094) | 2 | 7 | 5 | 63 | 22 | |||
68929 | 206391 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 120 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994239.7131 | 2097149.97666 | 37.7380437093438 | -122.462437122771 | (37.7380437093438, -122.462437122771) | 9 | 8 | 4 | 59 | 40 | |||
73708 | 142407 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5997811.1032 | 2114546.5 | 37.7860151856477 | -122.451343447432 | (37.7860151856477, -122.451343447432) | 11 | 6 | 1 | 54 | 31 | |||
75808 | 248815 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 8 Woodland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997044.98326 | 2106621.55572 | 37.7642114547062 | -122.453421615336 | (37.7642114547062, -122.453421615336) | 15 | 5 | 11 | 29492 | 12 | |||
81461 | 126306 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011394.26023 | 2121086.86047 | 37.8047418426192 | -122.404809780174 | (37.8047418426192, -122.404809780174) | 3 | 1 | 10 | 28860 | 6 | |||
83239 | 246197 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 737 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999882.2448 | 2108026.857 | 37.768232286533 | -122.443709336181 | (37.768232286533, -122.443709336181) | 15 | 5 | 11 | 29492 | 9 | |||
85657 | 248791 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1607 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003372.73797 | 2098800.51158 | 37.7430973983254 | -122.430977503921 | (37.7430973983254, -122.430977503921) | 2 | 7 | 5 | 63 | 22 | |||
87530 | 222142 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 731 Duboce Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6001999.30264 | 2108241.81272 | 37.7689430227171 | -122.436402040939 | (37.7689430227171, -122.436402040939) | 15 | 5 | 5 | 29492 | 3 | |||
97787 | 248747 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2179 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008156.6696 | 2105716.49098 | 37.7623570229933 | -122.41492528978 | (37.7623570229933, -122.41492528978) | 8 | 4 | 7 | 28859 | 19 | |||
105839 | 212199 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 820 Bosworth St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6001716.86925 | 2095561.16435 | 37.7341089397759 | -122.436471242853 | (37.7341089397759, -122.436471242853) | 2 | 7 | 5 | 63 | 7 | ||||
121204 | 212212 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6001287.33853 | 2095677.45112 | 37.7344038193788 | -122.437964588704 | (37.7344038193788, -122.437964588704) | 9 | 7 | 5 | 63 | 7 | ||||
124378 | 206385 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 30 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994364.29668 | 2097729.32265 | 37.7396416229721 | -122.462048380048 | (37.7396416229721, -122.462048380048) | 1 | 8 | 4 | 59 | 40 | |||
128883 | 205096 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800x Junipero Serra Blvd | 26 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991311.702 | 2092154.41765 | 37.7241581130794 | -122.47219657191 | (37.7241581130794, -122.47219657191) | 9 | 8 | 4 | 59 | 40 | |||
134308 | 205078 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 29 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991207.21899 | 2090512.07145 | 37.7196425892212 | -122.472438075876 | (37.7196425892212, -122.472438075876) | 9 | 8 | 4 | 64 | 24 | |||
136840 | 212294 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 4 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991166.95703 | 2089883.01903 | 37.7179130355286 | -122.472531408396 | (37.7179130355286, -122.472531408396) | 9 | 8 | 4 | 64 | 24 | |||
137138 | 124439 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349 Cherry St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996190.55308 | 2114956.33203 | 37.7870475491294 | -122.456979731582 | (37.7870475491294, -122.456979731582) | 11 | 6 | 1 | 54 | 31 | |||
146260 | 126272 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 743 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007155.35459 | 2121542.9483 | 37.8057563012647 | -122.419511352869 | (37.8057563012647, -122.419511352869) | 5 | 1 | 1 | 28858 | 32 | |||
162570 | 212293 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 3 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991165.05081 | 2089858.71083 | 37.7178461808423 | -122.472536226064 | (37.7178461808423, -122.472536226064) | 9 | 8 | 4 | 64 | 24 | |||
164371 | 11691 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 9 | 3x3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | ||
167504 | 126312 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6011622.11904 | 2121118.15193 | 37.8048404946454 | -122.404023450725 | (37.8048404946454, -122.404023450725) | 3 | 1 | 10 | 28860 | 6 | |||
173676 | 248677 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 432 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003082.30019 | 2099226.70839 | 37.7442511745512 | -122.432012186516 | (37.7442511745512, -122.432012186516) | 2 | 7 | 5 | 63 | 22 | |||
176598 | 189465 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 119 Augusta St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6011093.84914 | 2095438.52571 | 37.7343005763028 | -122.404043282576 | (37.7343005763028, -122.404043282576) | 10 | 3 | 8 | 58 | 1 | |||
179973 | 206383 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 20 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994405.70437 | 2097759.62337 | 37.7397272051417 | -122.461907407719 | (37.7397272051417, -122.461907407719) | 1 | 8 | 4 | 59 | 40 | |||
180416 | 206397 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 170 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994276.74774 | 2096834.22345 | 37.7371788619233 | -122.462286182385 | (37.7371788619233, -122.462286182385) | 9 | 8 | 4 | 59 | 40 | |||
181179 | 126201 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2475 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000210.86121 | 2117050.03799 | 37.7930263644331 | -122.443220836491 | (37.7930263644331, -122.443220836491) | 13 | 6 | 1 | 29490 | 27 | |||
181852 | 248539 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 107 Beulah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997585.1348 | 2107785.048 | 37.7674370554132 | -122.451637327839 | (37.7674370554132, -122.451637327839) | 15 | 5 | 11 | 29492 | 9 | |||
182576 | 126326 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 514 Commercial St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012125.00664 | 2117298.30563 | 37.7943802029417 | -122.40201444441 | (37.7943802029417, -122.40201444441) | 3 | 1 | 10 | 28860 | 4 | |||
183501 | 212219 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1120 Bosworth St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6001099.22416 | 2095737.89591 | 37.7345590873286 | -122.438619289753 | (37.7345590873286, -122.438619289753) | 9 | 7 | 5 | 63 | 7 | ||||
184113 | 212051 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 60 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5993395.8495 | 2093423.18821 | 37.7277622406113 | -122.465084152224 | (37.7277622406113, -122.465084152224) | 9 | 8 | 4 | 59 | 40 | |||
185507 | 248680 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 303 28th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003887.25922 | 2099518.37438 | 37.7450976245676 | -122.429249604983 | (37.7450976245676, -122.429249604983) | 2 | 7 | 5 | 63 | 22 | |||
190136 | 212295 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 6 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5991170.53267 | 2089939.68134 | 37.7180688232854 | -122.472523177809 | (37.7180688232854, -122.472523177809) | 9 | 8 | 4 | 64 | 24 | |||
193520 | 124434 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349 Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996180.98022 | 2115014.21197 | 37.7872059221875 | -122.457017039515 | (37.7872059221875, -122.457017039515) | 11 | 6 | 1 | 54 | 31 | |||
95469 | 5077 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2530 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 85 | 3X3 | 6002265.74164 | 2097118.12019 | 37.7384151554343 | -122.434684917677 | (37.7384151554343, -122.434684917677) | 2 | 7 | 5 | 63 | 7 | |||
161812 | 15986 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2543 Diamond St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 85 | 3X3 | 6002304.1295915 | 2097048.5555312 | 37.7382263262375 | -122.434547218349 | (37.7382263262375, -122.434547218349) | 2 | 7 | 5 | 63 | 7 | |||
162136 | 15987 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2543 Diamond St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 85 | 3X3 | 6002304.1295915 | 2097048.5555312 | 37.7382263262375 | -122.434547218349 | (37.7382263262375, -122.434547218349) | 2 | 7 | 5 | 63 | 7 | |||
3585 | 14577 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1135 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 3X3 | 5999374.0888 | 2108906.7208 | 37.7706191740488 | -122.445530268097 | (37.7706191740488, -122.445530268097) | 15 | 5 | 11 | 29492 | 9 | |||
41128 | 8145 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 4X4 | 6002886.96217 | 2111360.68278 | 37.7775570672136 | -122.433554609066 | (37.7775570672136, -122.433554609066) | 15 | 5 | 11 | 29492 | 41 | |||
44670 | 332 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3402X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 80 | 2X3 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
45260 | 13398 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 332 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 80 | 5 | 5999526.1960451 | 2097456.6056762 | 37.7391886477693 | -122.444181217539 | (37.7391886477693, -122.444181217539) | 9 | 7 | 4 | 59 | 40 | |||
61163 | 12145 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X La Salle Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6016306.34986 | 2095580.87923 | 37.7349813073472 | -122.386031740688 | (37.7349813073472, -122.386031740688) | 10 | 3 | 8 | 58 | 1 | |||
104219 | 16584 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 745X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 3X3 | 5993146.00273 | 2114812.03373 | 37.7864760417982 | -122.467502610283 | (37.7864760417982, -122.467502610283) | 11 | 6 | 2 | 54 | 11 | |||
105876 | 27636 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 210 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3x3 | 5994810.25209 | 2114930.59849 | 37.7868975312955 | -122.461753364309 | (37.7868975312955, -122.461753364309) | 11 | 6 | 1 | 54 | 11 | |||
106547 | 13397 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 326 Marietta Dr | 2 | Median : Cutout | Tree | DPW 1 | 80 | 5 | 5999496.7834134 | 2097465.9380067 | 37.7392125940965 | -122.44428358328 | (37.7392125940965, -122.44428358328) | 9 | 7 | 4 | 59 | 40 | |||
121863 | 12657 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1030 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 3X3 | 5992237.14862 | 2114834.7776 | 37.7864859766897 | -122.470648646947 | (37.7864859766897, -122.470648646947) | 11 | 6 | 1 | 54 | 11 | |||
124755 | 17603 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 918 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6003916.62917 | 2090182.06037 | 37.7194638711075 | -122.428482700528 | (37.7194638711075, -122.428482700528) | 9 | 7 | 6 | 28861 | 5 | |||
142319 | 12580 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 430 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 5X4 | 5994092.37339 | 2114901.2583 | 37.7867756202333 | -122.464234909406 | (37.7867756202333, -122.464234909406) | 11 | 6 | 1 | 54 | 11 | |||
145484 | 14576 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1135 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 3x3 | 5999375.95624 | 2108930.97827 | 37.7706858855295 | -122.445525553195 | (37.7706858855295, -122.445525553195) | 15 | 5 | 11 | 29492 | 9 | |||
163738 | 4769 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 20 Commer Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6016624.63849 | 2094705.64307 | 37.7325956937246 | -122.384870339116 | (37.7325956937246, -122.384870339116) | 10 | 3 | 8 | 58 | 1 | |||
164177 | 8152 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1040 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3x3 | 6002782.41251 | 2111346.10112 | 37.7775110971373 | -122.433915238462 | (37.7775110971373, -122.433915238462) | 15 | 5 | 11 | 29492 | 41 | |||
166197 | 27430 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X4 | 6007606.86637 | 2121548.41017 | 37.8057967194592 | -122.417949212693 | (37.8057967194592, -122.417949212693) | 5 | 1 | 10 | 308 | 23 | |||
172505 | 12568 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 325 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 5994431.11917 | 2114832.80083 | 37.7866071733964 | -122.46305796877 | (37.7866071733964, -122.46305796877) | 11 | 6 | 1 | 54 | 11 | |||
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 | ||
29710 | 205081 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x Junipero Serra Blvd | 32 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 5991210.7499 | 2090584.88401 | 37.7198427189488 | -122.472431176281 | (37.7198427189488, -122.472431176281) | 9 | 8 | 4 | 64 | 24 | |||
37440 | 176029 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 121 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010522.92349 | 2086697.37168 | 37.7102672593977 | -122.405401775978 | (37.7102672593977, -122.405401775978) | 9 | 7 | 8 | 309 | 39 | |||
37787 | 2061 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Bosworth St | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6001908.8431877 | 2095495.9697002 | 37.7339408370986 | -122.435802866841 | (37.7339408370986, -122.435802866841) | 9 | 7 | 5 | 63 | 7 | |||
47235 | 87701 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Junipero Serra Blvd | 27 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 8 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | 9 | 8 | 4 | 59 | 40 | |||
47624 | 245900 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1085 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001380.4441 | 2109353.6946 | 37.771960789742 | -122.43862230723 | (37.771960789742, -122.43862230723) | 15 | 5 | 11 | 29492 | 9 | |||
54958 | 126172 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2901 Divisadero St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6000514.61681 | 2118336.13924 | 37.7965749759056 | -122.442262196039 | (37.7965749759056, -122.442262196039) | 13 | 9 | 1 | 57 | 17 | |||
58684 | 111272 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X BOSWORTH ST | 11 | Front Yard : Yard | Tree | DPW 1 | 8 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
73532 | 212060 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 11 San Pablo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 5994718.64937 | 2097902.07869 | 37.7401363633992 | -122.46083570631 | (37.7401363633992, -122.46083570631) | 9 | 8 | 4 | 59 | 40 |
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) );