trees
3,587 rows where qSpecies_id = 28 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79903 | 126311 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6011596.42071 | 2121114.01244 | 37.804827692793 | -122.404112091508 | (37.804827692793, -122.404112091508) | 3 | 1 | 10 | 28860 | 6 | |||
| 80149 | 112305 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 3x3 | 6008684 | 2117318 | 37.7942416273691 | -122.413922169868 | (37.7942416273691, -122.413922169868) | 5 | 1 | 10 | 28857 | 21 | |||
| 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 | |||
| 82556 | 58791 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 505 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1992 12:00:00 AM | 15 | Permit Number 30381 | 6012232.54216 | 2117604.48195 | 37.7952268912538 | -122.401663886901 | (37.7952268912538, -122.401663886901) | 3 | 1 | 10 | 28860 | 4 | ||
| 84637 | 99993 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
| 85685 | 100011 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6011807.60069 | 2117536.15907 | 37.7950155712566 | -122.40312945177 | (37.7950155712566, -122.40312945177) | 3 | 1 | 10 | 28860 | 4 | ||||
| 88654 | 126271 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 757 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007135.30447 | 2121541.57652 | 37.8057514053527 | -122.419580642053 | (37.8057514053527, -122.419580642053) | 5 | 1 | 1 | 28858 | 32 | |||
| 90560 | 142909 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 470 GREEN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6010691.0969 | 2119300.3155 | 37.7997971013368 | -122.407117151967 | (37.7997971013368, -122.407117151967) | 3 | 1 | 10 | 308 | 23 | |||
| 91007 | 256619 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1255 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6007516.58505 | 2121541.63395 | 37.8057730322633 | -122.418261164826 | (37.8057730322633, -122.418261164826) | 5 | 1 | 1 | 308 | 32 | ||||
| 95012 | 100000 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
| 96489 | 126285 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1819 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6009101.69173 | 2119559.34428 | 37.800419255712 | -122.412635425182 | (37.800419255712, -122.412635425182) | 3 | 1 | 10 | 308 | 32 | |||
| 98411 | 126331 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 537 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6011841.29022 | 2117708.6013 | 37.7954909376158 | -122.403025015297 | (37.7954909376158, -122.403025015297) | 3 | 1 | 10 | 28860 | 4 | |||
| 99963 | 142977 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1909 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6010355.8809 | 2121023.9734 | 37.804511076187 | -122.408398775224 | (37.804511076187, -122.408398775224) | 3 | 1 | 10 | 308 | 23 | |||
| 103532 | 88132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 6007534.97421 | 2121589.88295 | 37.8059065468398 | -122.418200949141 | (37.8059065468398, -122.418200949141) | 5 | 1 | 10 | 308 | 23 | ||||
| 107942 | 126286 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1819 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009103.85324 | 2119545.79169 | 37.8003821649739 | -122.412626986872 | (37.8003821649739, -122.412626986872) | 3 | 1 | 10 | 308 | 32 | |||
| 109088 | 100014 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 6011819.70044 | 2117479.02475 | 37.7948593698064 | -122.403083563865 | (37.7948593698064, -122.403083563865) | 3 | 1 | 10 | 28860 | 4 | ||||
| 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 | |||
| 113584 | 126340 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 502 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6012057.16837 | 2117472.36557 | 37.7948543435036 | -122.402261418053 | (37.7948543435036, -122.402261418053) | 3 | 1 | 10 | 28860 | 4 | |||
| 119436 | 121004 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 770 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010080.56543171 | 2116389.03640526 | 37.7917692527785 | -122.409024297587 | (37.7917692527785, -122.409024297587) | 5 | 1 | 10 | 28857 | 21 | |||||
| 119985 | 126327 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 514 Commercial St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012105.07843 | 2117293.5141 | 37.794365934285 | -122.402083061776 | (37.794365934285, -122.402083061776) | 3 | 1 | 10 | 28860 | 4 | |||
| 120188 | 126298 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 4ft | 6008998.98319 | 2121852.98911 | 37.8067112661735 | -122.413153116346 | (37.8067112661735, -122.413153116346) | 3 | 1 | 10 | 308 | 23 | |||
| 121257 | 86891 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
| 121680 | 126276 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1281 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007427.08243 | 2118463.17771 | 37.7973153292952 | -122.41835249187 | (37.7973153292952, -122.41835249187) | 5 | 1 | 10 | 28858 | 32 | |||
| 123886 | 100006 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6011806.48185 | 2117548.03354 | 37.7950481132234 | -122.403134158813 | (37.7950481132234, -122.403134158813) | 3 | 1 | 10 | 28860 | 4 | ||||
| 124490 | 121015 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 750 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010108 | 2116326 | 37.7915977068213 | -122.408924924133 | (37.7915977068213, -122.408924924133) | 5 | 1 | 10 | 28857 | 21 | ||||
| 124561 | 100022 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
| 125560 | 30491 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1123 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1956 12:00:00 AM | Permit Number 150 | 6011534.42767209 | 2119133.27614211 | 37.7993856101137 | -122.404187135798 | (37.7993856101137, -122.404187135798) | 3 | 1 | 10 | 308 | 23 | |||
| 128866 | 126341 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 504 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6011976.85161 | 2117464.75326 | 37.7948289583503 | -122.402538791428 | (37.7948289583503, -122.402538791428) | 3 | 1 | 10 | 28860 | 4 | |||
| 129974 | 100021 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
| 130296 | 126257 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1018 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008191.90392 | 2115962.34798 | 37.7904916908939 | -122.415528858086 | (37.7904916908939, -122.415528858086) | 5 | 1 | 10 | 28858 | 21 | |||
| 130948 | 258043 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007535 | 2121589 | 37.8059041239352 | -122.418200797252 | (37.8059041239352, -122.418200797252) | 5 | 1 | 10 | 308 | 23 | ||||
| 131054 | 126347 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 504 Clay St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6011875.13389 | 2117451.48758 | 37.794786854781 | -122.402889817521 | (37.794786854781, -122.402889817521) | 3 | 1 | 10 | 28860 | 4 | |||
| 131360 | 126334 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 537 Washington St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6011902.4584 | 2117714.99047 | 37.795511896304 | -122.402813811308 | (37.795511896304, -122.402813811308) | 3 | 1 | 10 | 28860 | 4 | |||
| 131394 | 126344 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 504 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6011910.10694 | 2117456.41385 | 37.7948023339012 | -122.402769151871 | (37.7948023339012, -122.402769151871) | 3 | 1 | 10 | 28860 | 4 | |||
| 133958 | 57385 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1045 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1976 12:00:00 AM | 15 | Permit Number 16224 | 6008126.26677 | 2116107.7389 | 37.7908872091246 | -122.415766258399 | (37.7908872091246, -122.415766258399) | 13 | 1 | 10 | 28858 | 21 | ||
| 134992 | 41336 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1202 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2000 12:00:00 AM | 22 | Permit Number 41990 | 6008099.77433 | 2116609.72669 | 37.7922640549929 | -122.415893483695 | (37.7922640549929, -122.415893483695) | 5 | 1 | 10 | 28858 | 21 | ||
| 135347 | 258042 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6007535 | 2121589 | 37.8059041239352 | -122.418200797252 | (37.8059041239352, -122.418200797252) | 5 | 1 | 10 | 308 | 23 | ||
| 135570 | 126315 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6011706.66389 | 2121131.24206 | 37.8048811601877 | -122.403731794293 | (37.8048811601877, -122.403731794293) | 3 | 1 | 10 | 28860 | 6 | |||
| 135793 | 100005 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6011805.43211 | 2117563.29295 | 37.7950899532827 | -122.403138864979 | (37.7950899532827, -122.403138864979) | 3 | 1 | 10 | 28860 | 4 | ||||
| 136340 | 86890 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
| 136392 | 109847 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 535 CLAY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6012019 | 2117742 | 37.7955925645 | -122.402412455116 | (37.7955925645, -122.402412455116) | 3 | 1 | 10 | 28860 | 4 | ||||
| 136656 | 100016 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6011790.6974 | 2117658.0677 | 37.7953493591435 | -122.403196519624 | (37.7953493591435, -122.403196519624) | 3 | 1 | 10 | 28860 | 4 | ||||
| 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 | |||
| 140424 | 256621 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1255 Columbus Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6007516.58505 | 2121541.63395 | 37.8057730322633 | -122.418261164826 | (37.8057730322633, -122.418261164826) | 5 | 1 | 1 | 308 | 32 | ||||
| 140859 | 107838 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1000x LEAVENWORTH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008256 | 2115925 | 37.790392745036 | -122.415304443955 | (37.790392745036, -122.415304443955) | 5 | 1 | 10 | 28858 | 21 | ||||
| 141018 | 126256 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1018 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008192.90353 | 2115949.02612 | 37.7904551685145 | -122.415524455913 | (37.7904551685145, -122.415524455913) | 5 | 1 | 10 | 28858 | 21 | |||
| 143809 | 126348 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 504 Clay St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6011856.29626 | 2117449.39028 | 37.7947800442244 | -122.402954851105 | (37.7947800442244, -122.402954851105) | 3 | 1 | 10 | 28860 | 4 | |||
| 143924 | 100028 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
| 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 | |||
| 147605 | 126336 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 537 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011931.21803 | 2117719.21185 | 37.7955250929746 | -122.402714594497 | (37.7955250929746, -122.402714594497) | 3 | 1 | 10 | 28860 | 4 | |||
| 148244 | 100012 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Washington St Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6011815.13883 | 2117505.52997 | 37.7949318920521 | -122.403101213045 | (37.7949318920521, -122.403101213045) | 3 | 1 | 10 | 28860 | 4 | ||||
| 148249 | 126320 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6013315.31247 | 2116974.36665 | 37.7935571047345 | -122.397873082591 | (37.7935571047345, -122.397873082591) | 4 | 1 | 10 | 28860 | 6 | |||
| 148277 | 99990 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Permit Number 44594 | 6011811.05033 | 2117521.86685 | 37.7949765208901 | -122.403116509626 | (37.7949765208901, -122.403116509626) | 3 | 1 | 10 | 28860 | 4 | |||
| 148766 | 126329 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 537 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6011813.45696 | 2117705.17673 | 37.795479980266 | -122.403121082668 | (37.795479980266, -122.403121082668) | 3 | 1 | 10 | 28860 | 4 | |||
| 149715 | 126190 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1490 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007676.57843 | 2116519.48391 | 37.7919924696259 | -122.417351355802 | (37.7919924696259, -122.417351355802) | 5 | 1 | 10 | 28858 | 21 | |||
| 150832 | 126269 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 757 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007103.42585 | 2121534.93603 | 37.8057313765645 | -122.419690491528 | (37.8057313765645, -122.419690491528) | 5 | 1 | 1 | 28858 | 32 | |||
| 151964 | 126316 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 30 Chestnut St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6011523.49407 | 2121154.08896 | 37.8049336581286 | -122.404367285814 | (37.8049336581286, -122.404367285814) | 3 | 1 | 10 | 28860 | 23 | |||
| 153528 | 114700 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 645 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010496 | 2116407 | 37.7918418395307 | -122.407588155464 | (37.7918418395307, -122.407588155464) | 5 | 1 | 10 | 28857 | 21 | ||||
| 153999 | 67625 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1281 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | 16 | Permit Number 31211 | 6007384.19721 | 2118457.03367 | 37.7972960451262 | -122.418500450146 | (37.7972960451262, -122.418500450146) | 5 | 1 | 10 | 28858 | 32 | |
| 157696 | 102605 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010368 | 2120990 | 37.8044184722981 | -122.408354438035 | (37.8044184722981, -122.408354438035) | 3 | 1 | 10 | 308 | 23 | ||||
| 157901 | 126295 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 4ft | 6009138.25888 | 2121870.32475 | 37.8067666832919 | -122.412672350444 | (37.8067666832919, -122.412672350444) | 3 | 1 | 10 | 308 | 23 | |||
| 158289 | 256620 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1255 Columbus Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6007516.58505 | 2121541.63395 | 37.8057730322633 | -122.418261164826 | (37.8057730322633, -122.418261164826) | 5 | 1 | 1 | 308 | 32 | ||||
| 159475 | 256617 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1255 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6007516.58505 | 2121541.63395 | 37.8057730322633 | -122.418261164826 | (37.8057730322633, -122.418261164826) | 5 | 1 | 1 | 308 | 32 | ||||
| 160228 | 126303 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 150 Lombard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011649.70987 | 2120828.01575 | 37.8040453932491 | -122.403907539796 | (37.8040453932491, -122.403907539796) | 3 | 1 | 10 | 28860 | 6 | |||
| 160909 | 100025 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
| 163030 | 99119 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 480 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6011162.75623 | 2119015.64779 | 37.799041856745 | -122.405464967752 | (37.799041856745, -122.405464967752) | 3 | 1 | 10 | 308 | 23 | |||
| 165330 | 143476 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 645 CALIFORNIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6010513.9675 | 2116421.9644 | 37.7918839339006 | -122.407527043118 | (37.7918839339006, -122.407527043118) | 5 | 1 | 10 | 28857 | 21 | |||
| 166089 | 258044 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007535 | 2121589 | 37.8059041239352 | -122.418200797252 | (37.8059041239352, -122.418200797252) | 5 | 1 | 10 | 308 | 23 | ||||
| 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 | |||
| 167149 | 126328 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 558 Commercial St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6011981.05173 | 2117276.54743 | 37.7943124246192 | -122.40251101768 | (37.7943124246192, -122.40251101768) | 3 | 1 | 10 | 28860 | 4 | |||
| 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 | |||
| 167930 | 99988 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
| 167967 | 126338 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6012200.46625 | 2117481.40408 | 37.7948871588715 | -122.401766219857 | (37.7948871588715, -122.401766219857) | 3 | 1 | 10 | 28860 | 4 | |||
| 168548 | 249774 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 102 Pfeiffer St | 5 | Side Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 6010412.38512 | 2121159.3166 | 37.8048858591461 | -122.408212787783 | (37.8048858591461, -122.408212787783) | 3 | 1 | 10 | 308 | 23 | |||
| 169008 | 99995 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Permit Number 44594 | 6011799.65117 | 2117580.00293 | 37.795135512042 | -122.403160044009 | (37.795135512042, -122.403160044009) | 3 | 1 | 10 | 28860 | 4 | |||
| 171100 | 67886 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 554 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/1993 12:00:00 AM | 16 | Permit Number 31581 | 6012025.24722 | 2117281.36529 | 37.7943281205081 | -122.402358434194 | (37.7943281205081, -122.402358434194) | 3 | 1 | 10 | 28860 | 4 | ||
| 171436 | 65393 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1345 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/1989 12:00:00 AM | 22 | Permit Number 28235 | 6008898.78625 | 2117545.17326 | 37.7948774497893 | -122.41319505442 | (37.7948774497893, -122.41319505442) | 5 | 1 | 10 | 28857 | 21 | ||
| 173360 | 126319 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 752 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 6ft | 6010083.7089 | 2116366.90376 | 37.7917086579707 | -122.409011858816 | (37.7917086579707, -122.409011858816) | 5 | 1 | 10 | 28857 | 21 | |||
| 173612 | 97638 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 3x3 | 6008684 | 2117318 | 37.7942416273691 | -122.413922169868 | (37.7942416273691, -122.413922169868) | 5 | 1 | 10 | 28857 | 21 | |||
| 174201 | 57384 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1041 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1976 12:00:00 AM | 18 | Permit Number 16223 | 6008133.39739 | 2116067.55346 | 37.7907772706074 | -122.415738740065 | (37.7907772706074, -122.415738740065) | 13 | 1 | 10 | 28858 | 21 | ||
| 174214 | 114413 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1345 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 6008903.22514 | 2117506.21986 | 37.7947707425189 | -122.413176939363 | (37.7947707425189, -122.413176939363) | 5 | 1 | 10 | 28857 | 21 | ||||
| 174389 | 126287 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 Florence St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6008482.54317 | 2118328.02028 | 37.7970035775046 | -122.41469074659 | (37.7970035775046, -122.41469074659) | 5 | 1 | 10 | 308 | 21 | ||||
| 175170 | 100019 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
| 175597 | 99994 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
| 175700 | 97634 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008163 | 2117572 | 37.7949097746331 | -122.415742887246 | (37.7949097746331, -122.415742887246) | 5 | 1 | 10 | 28858 | 21 | |||||
| 176116 | 143223 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 291 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6009921.7346 | 2121237.0316 | 37.8050717594781 | -122.409916233664 | (37.8050717594781, -122.409916233664) | 3 | 1 | 10 | 308 | 23 | |||
| 176397 | 126330 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 537 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6011827.62278 | 2117706.61766 | 37.7954847277906 | -122.403072167645 | (37.7954847277906, -122.403072167645) | 3 | 1 | 10 | 28860 | 4 | |||
| 177646 | 126314 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6011690.09523 | 2121129.11088 | 37.8048743829079 | -122.403788982197 | (37.8048743829079, -122.403788982197) | 3 | 1 | 10 | 28860 | 6 | |||
| 178398 | 126317 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 730 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6010085.86198 | 2116311.63248 | 37.7915570169928 | -122.409000507594 | (37.7915570169928, -122.409000507594) | 5 | 1 | 10 | 28857 | 21 | |||
| 179677 | 99992 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
| 181134 | 126325 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 514 Commercial St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6012207.85144 | 2117304.67676 | 37.7944023199544 | -122.401728237874 | (37.7944023199544, -122.401728237874) | 3 | 1 | 10 | 28860 | 4 | |||
| 181765 | 97636 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008163 | 2117572 | 37.7949097746331 | -122.415742887246 | (37.7949097746331, -122.415742887246) | 5 | 1 | 10 | 28858 | 21 | |||||
| 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 | |||
| 183410 | 126310 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 19 Chestnut St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011567.70518 | 2121110.48267 | 37.804816396425 | -122.404211216594 | (37.804816396425, -122.404211216594) | 3 | 1 | 10 | 28860 | 6 | |||
| 186150 | 126337 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 505 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012234.06302 | 2117586.04773 | 37.7951763601562 | -122.401657328144 | (37.7951763601562, -122.401657328144) | 3 | 1 | 10 | 28860 | 4 | |||
| 186511 | 126259 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1202 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 5ft | 6008095.42077 | 2116655.37814 | 37.7923891578898 | -122.415911781323 | (37.7923891578898, -122.415911781323) | 5 | 1 | 10 | 28858 | 21 | |||
| 187159 | 126297 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300 North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009095.83841 | 2121864.72541 | 37.806748927978 | -122.412818759199 | (37.806748927978, -122.412818759199) | 3 | 1 | 10 | 308 | 23 | |||
| 189363 | 126321 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6013275.05108 | 2116971.76517 | 37.7935477194132 | -122.398012208604 | (37.7935477194132, -122.398012208604) | 4 | 1 | 10 | 28860 | 6 | |||
| 189542 | 27431 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4X4 | 6007595.97622 | 2121559.89845 | 37.8058276504572 | -122.41798771471 | (37.8058276504572, -122.41798771471) | 5 | 1 | 10 | 308 | 23 | |||
| 189935 | 99989 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Permit Number 44594 | 6011816.52839 | 2117490.26365 | 37.7948900519939 | -122.403095330591 | (37.7948900519939, -122.403095330591) | 3 | 1 | 10 | 28860 | 4 |
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) );