Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39883 | 39883 | 203492 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 23 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5999946.35958 | 2095464.23555 | 37.7337420298607 | -122.442585473564 | (37.7337420298607, -122.442585473564) | |||
| 40273 | 40273 | 125508 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008930.4214699995 | 2118571.4914 | 37.797697242591504 | -122.41315819931299 | (37.7976972425915, -122.413158199313) | |||
| 40602 | 40602 | 203478 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2453 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992323.79318 | 2098755.04508 | 37.74234030496479 | -122.469178135975 | (37.7423403049648, -122.469178135975) | |||
| 40929 | 40929 | 249550 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6005507.2276099995 | 2114996.10092 | 37.7876873493358 | -122.424748911848 | (37.7876873493358, -122.424748911848) | |||
| 40963 | 40963 | 125473 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 655 Powell St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6010077.67437 | 2116003.04391 | 37.7907092485717 | -122.409007053757 | (37.7907092485717, -122.409007053757) | |||
| 41144 | 41144 | 175153 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 783 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6001323.552619999 | 2092431.0494099997 | 37.7254920046417 | -122.43760697060101 | (37.7254920046417, -122.437606970601) | |||
| 41206 | 41206 | 189186 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6013353.399019999 | 2110803.04971 | 37.776614217315505 | -122.39730832904199 | (37.7766142173155, -122.397308329042) | |||
| 41654 | 41654 | 125506 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6008920.97468 | 2118571.47788 | 37.7976966751291 | -122.413190886946 | (37.7976966751291, -122.413190886946) | |||
| 41677 | 41677 | 249947 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 305 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011342.9125 | 2120054.18632 | 37.8019035022036 | -122.40491472295 | (37.8019035022036, -122.40491472295) | |||
| 41684 | 41684 | 203490 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 29 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001874.24208 | 2094906.2061700001 | 37.7323195164307 | -122.43588030914302 | (37.7323195164307, -122.435880309143) | |||
| 42654 | 42654 | 125464 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 887 Eddy St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6006280.54306 | 2113153.33425 | 37.782671211560704 | -122.4219424317 | (37.7826712115607, -122.4219424317) | |||
| 43148 | 43148 | 32487 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 257 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 5 | Permit Number 36994 | 6000562.081590001 | 2106647.6707099997 | 37.7644841354656 | -122.441258885382 | (37.7644841354656, -122.441258885382) | |
| 43229 | 43229 | 220599 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 714 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010100.45141 | 2104938.60727 | 37.7603301624296 | -122.408147577953 | (37.7603301624296, -122.408147577953) | |||
| 43603 | 43603 | 249538 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 7 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6006360.10871 | 2114050.0114700003 | 37.785137754239294 | -122.421730877876 | (37.7851377542393, -122.421730877876) | |||
| 43773 | 43773 | 189175 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012666.59913 | 2115298.5353200003 | 37.788919518565706 | -122.39999995672599 | (37.7889195185657, -122.399999956726) | |||
| 43774 | 43774 | 203480 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993659.30191 | 2093497.00296 | 37.7279801058879 | -122.464178756148 | (37.7279801058879, -122.464178756148) | |||
| 43884 | 43884 | 189176 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012661.31608 | 2115304.6540900003 | 37.7889360247231 | -122.40001866534901 | (37.7889360247231, -122.400018665349) | |||
| 43939 | 43939 | 203498 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 234 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999190.87551 | 2094097.9228400001 | 37.72994736206179 | -122.445099202768 | (37.7299473620618, -122.445099202768) | |||
| 43952 | 43952 | 221766 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 712 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002158.80169 | 2108813.78872 | 37.770522589268204 | -122.43589127638799 | (37.7705225892682, -122.435891276388) | |||
| 44032 | 44032 | 220657 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 505 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008343.07833 | 2096482.99595 | 37.737014388512996 | -122.41362746465799 | (37.737014388513, -122.413627464658) | |||
| 44045 | 44045 | 221755 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 14 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6004062.6885 | 2102905.39693 | 37.7544075287057 | -122.42888442629601 | (37.7544075287057, -122.428884426296) | |||
| 44557 | 44557 | 119343 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 462 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5985960.41468 | 2112779.42827 | 37.7804776215792 | -122.49221287963199 | (37.7804776215792, -122.492212879632) | |||
| 44628 | 44628 | 220614 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2979 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008369.0064199995 | 2103859.12249 | 37.757269043737395 | -122.414059488154 | (37.7572690437374, -122.414059488154) | |||
| 44709 | 44709 | 125485 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6007640.9414 | 2118138.07584 | 37.796434716745 | -122.417589429708 | (37.796434716745, -122.417589429708) | ||||
| 45092 | 45092 | 64967 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1671 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004948.17442 | 2119151.63157 | 37.799065794014396 | -122.42697920982201 | (37.7990657940144, -122.426979209822) | |
| 45739 | 45739 | 249986 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011589.33259 | 2120106.08083 | 37.802059763014 | -122.404065643309 | (37.802059763014, -122.404065643309) | |||
| 45984 | 45984 | 125495 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6006051.2199 | 2120336.9264 | 37.802382621428706 | -122.423246597049 | (37.8023826214287, -122.423246597049) | |||
| 46074 | 46074 | 221767 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 287 Hermann St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6003902.82897 | 2108654.79623 | 37.770184952298 | -122.429847331292 | (37.770184952298, -122.429847331292) | |||
| 46216 | 46216 | 189159 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008170.01676 | 2109410.076 | 37.7724994960939 | -122.415140588393 | (37.7724994960939, -122.415140588393) | |||
| 46441 | 46441 | 189189 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6013286.37012 | 2110737.4235099996 | 37.776430290657004 | -122.397535599396 | (37.776430290657, -122.397535599396) | |||
| 46755 | 46755 | 37601 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 781 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 11 | 6x9 | Permit Number 40028 | 5992556.63358 | 2110168.87379 | 37.7736931455181 | -122.469203595419 | (37.7736931455181, -122.469203595419) |
| 46865 | 46865 | 249820 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 281 Kearny St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6010902.80513 | 2120614.31353 | 37.8034168633488 | -122.40647720057301 | (37.8034168633488, -122.406477200573) | |||
| 47152 | 47152 | 125475 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009249.92549 | 2116801.2629400003 | 37.7928545606515 | -122.41192746357599 | (37.7928545606515, -122.411927463576) | |||
| 47327 | 47327 | 201923 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 125 Elmira St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6011215.48386 | 2096005.8192 | 37.735865039640395 | -122.403662651736 | (37.7358650396404, -122.403662651736) | |||
| 47594 | 47594 | 220635 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 628 Chenery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002826.10631 | 2095715.4099400002 | 37.7345954316319 | -122.432647280541 | (37.7345954316319, -122.432647280541) | |||
| 47631 | 47631 | 221761 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4441 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001542.762080001 | 2104063.39418 | 37.75744415704379 | -122.437681892224 | (37.7574441570438, -122.437681892224) | |||
| 47885 | 47885 | 125511 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008625.76186 | 2119029.2242099997 | 37.7989369553212 | -122.41424481055799 | (37.7989369553212, -122.414244810558) | |||
| 48020 | 48020 | 189179 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012646.32236 | 2115321.2423900003 | 37.788980736331794 | -122.400071707361 | (37.7889807363318, -122.400071707361) | |||
| 48362 | 48362 | 125504 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1001 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6007489.69173 | 2120199.0729400003 | 37.8020851859507 | -122.418258985774 | (37.8020851859507, -122.418258985774) | |||
| 48661 | 48661 | 125469 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6008779.73096 | 2116281.55689 | 37.791401184258795 | -122.413517591782 | (37.7914011842588, -122.413517591782) | |||
| 48805 | 48805 | 220628 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 907 Elizabeth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6000553.10276 | 2101957.71166 | 37.751606143208 | -122.44095346395201 | (37.751606143208, -122.440953463952) | |||
| 48809 | 48809 | 125436 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3157 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001892.570830001 | 2119015.7946 | 37.798519569189 | -122.437542875929 | (37.798519569189, -122.437542875929) | |||
| 48836 | 48836 | 203495 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 363 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5999677.596390001 | 2094931.24105 | 37.732263227850204 | -122.443476391437 | (37.7322632278502, -122.443476391437) | |||
| 48850 | 48850 | 246960 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2177 15th St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6003038.46952 | 2107086.92585 | 37.7658309772437 | -122.432725124067 | (37.7658309772437, -122.432725124067) | |||
| 49008 | 49008 | 125522 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1087 Greenwich St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6007750.4574 | 2119887.81691 | 37.8012452299295 | -122.417334539369 | (37.8012452299295, -122.417334539369) | |||
| 49140 | 49140 | 175171 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6003766.2619199995 | 2091125.7997700002 | 37.7220466613948 | -122.429069717203 | (37.7220466613948, -122.429069717203) | |||
| 49294 | 49294 | 221759 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4515 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001360.92884 | 2104054.05926 | 37.7574081850601 | -122.438310074049 | (37.7574081850601, -122.438310074049) | |||
| 49324 | 49324 | 175168 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004674.59943 | 2093952.62434 | 37.7298598742113 | -122.426130962075 | (37.7298598742113, -122.426130962075) | |||
| 49472 | 49472 | 41212 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3676 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 6 | Permit Number 41921 | 6002149.73701 | 2121055.69726 | 37.804135222937 | -122.43679910691002 | (37.804135222937, -122.43679910691) | |
| 49575 | 49575 | 123145 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 562 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992857.65671 | 2111637.4840599997 | 37.7777429430313 | -122.468269178657 | (37.7777429430313, -122.468269178657) | |||
| 49765 | 49765 | 94178 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1379 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53590 | 6011748.15969 | 2101956.8719099998 | 37.752235095787704 | -122.402239247057 | (37.7522350957877, -122.402239247057) | |
| 49806 | 49806 | 221764 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3809 16th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6001727.44948 | 2106346.3994299998 | 37.7637232334694 | -122.437206631108 | (37.7637232334694, -122.437206631108) | |||
| 49868 | 49868 | 125509 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6008633.29576 | 2119030.27082 | 37.7989402522368 | -122.41421881477301 | (37.7989402522368, -122.414218814773) | |||
| 50288 | 50288 | 220659 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 998 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009137.788819999 | 2103468.55533 | 37.756239784053996 | -122.41137313676799 | (37.756239784054, -122.411373136768) | |||
| 50380 | 50380 | 189181 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6013494.8789800005 | 2110935.49205 | 37.7769857497279 | -122.39682819267901 | (37.7769857497279, -122.396828192679) | |||
| 50442 | 50442 | 220612 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 9 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009640.52107 | 2098655.41337 | 37.743052146240295 | -122.409294863773 | (37.7430521462403, -122.409294863773) | |||
| 50704 | 50704 | 35721 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 556 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1998 12:00:00 AM | 10 | Permit Number 39004 | 6008810.28905 | 2093458.06001 | 37.728734789961706 | -122.411798418969 | (37.7287347899617, -122.411798418969) | |
| 50982 | 50982 | 220615 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3117 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009011.326230001 | 2104478.69915 | 37.75900631630999 | -122.411881867955 | (37.75900631631, -122.411881867955) | |||
| 51580 | 51580 | 189194 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6012053.23647 | 2107512.8913 | 37.7675077191257 | -122.40157469843001 | (37.7675077191257, -122.40157469843) | |||
| 51714 | 51714 | 125450 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 44 Normandie Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6000949.24806 | 2117425.20451 | 37.79409854965171 | -122.44069290604999 | (37.7940985496517, -122.44069290605) | |||
| 51784 | 51784 | 125483 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1471 Washington St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6007681.40554 | 2117137.6606799997 | 37.793690101870205 | -122.417378482047 | (37.7936901018702, -122.417378482047) | |||
| 52304 | 52304 | 220625 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 665 Elizabeth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002079.843669999 | 2102040.673 | 37.751920772823794 | -122.43567974235 | (37.7519207728238, -122.43567974235) | |||
| 52510 | 52510 | 189190 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6013250.96845 | 2110705.54176 | 37.7763407793478 | -122.39765582795499 | (37.7763407793478, -122.397655827955) | |||
| 52592 | 52592 | 220600 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 75 Montcalm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010666.22738 | 2100038.82593 | 37.7469081100366 | -122.405845659758 | (37.7469081100366, -122.405845659758) | |||
| 52909 | 52909 | 175174 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Vienna St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6003793.29108 | 2091173.5648599998 | 37.722179343787396 | -122.428979687879 | (37.7221793437874, -122.428979687879) | |||
| 53096 | 53096 | 125439 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 99 Collins St | 0 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5998117.25486 | 2114050.06951 | 37.7846696436241 | -122.450248453727 | (37.7846696436241, -122.450248453727) | ||||
| 53366 | 53366 | 203468 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 2ft | 5998155.09728 | 2094421.38368 | 37.7307763355428 | -122.448703284436 | (37.7307763355428, -122.448703284436) | |||
| 53779 | 53779 | 120025 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 743 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5987224.82866 | 2110876.6376900002 | 37.775326931785294 | -122.487698901899 | (37.7753269317853, -122.487698901899) | |||
| 53916 | 53916 | 220624 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 665 Elizabeth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6002066.32428 | 2102040.31203 | 37.7519190137697 | -122.435726468425 | (37.7519190137697, -122.435726468425) | |||
| 54200 | 54200 | 125490 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1322 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007597.86895 | 2115819.15526 | 37.7900651109764 | -122.417574034214 | (37.7900651109764, -122.417574034214) | |||
| 54337 | 54337 | 175154 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000079.77144 | 2092298.5573 | 37.7250574153596 | -122.44189709559299 | (37.7250574153596, -122.441897095593) | |||
| 54829 | 54829 | 221760 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4515 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001372.8328 | 2104055.08022 | 37.7574116654297 | -122.43826897865101 | (37.7574116654297, -122.438268978651) | |||
| 54839 | 54839 | 125453 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002078.25785 | 2117342.70193 | 37.793936248105 | -122.43678051073299 | (37.793936248105, -122.436780510733) | |||
| 54933 | 54933 | 203443 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995223.6819 | 2097798.00617 | 37.7398796519151 | -122.459081986971 | (37.7398796519151, -122.459081986971) | |||
| 55076 | 55076 | 125501 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1115 Filbert St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6007553.747280001 | 2119514.62481 | 37.8002094690578 | -122.417988773678 | (37.8002094690578, -122.417988773678) | |||
| 55188 | 55188 | 203461 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 409 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5998653.32929 | 2094365.51359 | 37.7306514071182 | -122.446976805539 | (37.7306514071182, -122.446976805539) | |||
| 55787 | 55787 | 189171 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 672 Missouri St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 1ft | 6013547.271380001 | 2103937.2716200002 | 37.7577731065529 | -122.396156373043 | (37.7577731065529, -122.396156373043) | |||
| 55795 | 55795 | 189170 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 360 Texas St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6013732.7365 | 2105419.1930299997 | 37.761852457439495 | -122.395618779897 | (37.7618524574395, -122.395618779897) | |||
| 56342 | 56342 | 125442 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3719 Scott St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6000612.64349 | 2121133.3219999997 | 37.8042608824853 | -122.442123892024 | (37.8042608824853, -122.442123892024) | |||
| 56741 | 56741 | 220619 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 618 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6001863.58646 | 2099454.0588599998 | 37.744806257700205 | -122.43624249671801 | (37.7448062577002, -122.436242496718) | ||||
| 56962 | 56962 | 220618 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 237 Murray St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6005720.296519999 | 2095375.55283 | 37.7338259689755 | -122.422616936749 | (37.7338259689755, -122.422616936749) | |||
| 57123 | 57123 | 175162 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000098.0141199995 | 2092315.01212 | 37.7251036360216 | -122.441835213242 | (37.7251036360216, -122.441835213242) | |||
| 57215 | 57215 | 175165 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004671.92277 | 2094015.32561 | 37.730031886663 | -122.42614467765 | (37.730031886663, -122.42614467765) | |||
| 57484 | 57484 | 221751 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4000 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003801.92979 | 2101310.951 | 37.750014791971104 | -122.429672485102 | (37.7500147919711, -122.429672485102) | |||
| 58238 | 58238 | 116047 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 650x Kansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 5x12 | 6011496.1211 | 2105415.8281900003 | 37.761718552879 | -122.403354153666 | (37.761718552879, -122.403354153666) | ||
| 58297 | 58297 | 220644 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 16 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6009354.03531 | 2097334.2588400003 | 37.7394084890188 | -122.410192201918 | (37.7394084890188, -122.410192201918) | |||
| 58353 | 58353 | 125529 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6010076.61244 | 2116904.10673 | 37.793183289838 | -122.40907433472 | (37.793183289838, -122.40907433472) | |||
| 58417 | 58417 | 125477 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009239.02025 | 2116870.71678 | 37.793044652131 | -122.41197010674802 | (37.793044652131, -122.411970106748) | |||
| 58639 | 58639 | 203477 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2331 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990713.76496 | 2099522.32344 | 37.7443538888309 | -122.47480105801701 | (37.7443538888309, -122.474801058017) | |||
| 59975 | 59975 | 220649 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 41 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008103.651880001 | 2099402.16609 | 37.7450163384242 | -122.414661792014 | (37.7450163384242, -122.414661792014) | |||
| 60021 | 60021 | 249949 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011354.62644 | 2120055.4997 | 37.801907763195 | -122.404874279527 | (37.801907763195, -122.404874279527) | |||
| 60116 | 60116 | 248097 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010442.71302 | 2099823.47595 | 37.7463043033989 | -122.406603382656 | (37.7463043033989, -122.406603382656) | |||
| 60321 | 60321 | 203473 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 128 Howth St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997584.72507 | 2091125.26044 | 37.7216933258806 | -122.450437617121 | (37.7216933258806, -122.450437617121) | |||
| 60506 | 60506 | 203484 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 101 Los Palmos Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998423.23469 | 2096036.13552 | 37.7352253905456 | -122.447892505138 | (37.7352253905456, -122.447892505138) | |||
| 60904 | 60904 | 16944 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 599X Oak St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 20 | 3x3 | 6004143.777734599 | 2110082.9014722 | 37.774119822677996 | -122.429115732545 | (37.774119822678, -122.429115732545) | |||
| 61016 | 61016 | 125467 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6008702.23207 | 2116269.4831 | 37.791363680726796 | -122.413784882888 | (37.7913636807268, -122.413784882888) | |||
| 61458 | 61458 | 249988 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011583.89861 | 2120104.21147 | 37.802054326596206 | -122.404084315938 | (37.8020543265962, -122.404084315938) | |||
| 61770 | 61770 | 249991 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011578.47013 | 2120102.62532 | 37.802049668108396 | -122.404102989475 | (37.8020496681084, -122.404102989475) | |||
| 63040 | 63040 | 249939 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 331 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011281.55151 | 2120038.154 | 37.801856051265204 | -122.40512593233 | (37.8018560512652, -122.40512593233) | |||
| 63274 | 63274 | 203472 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 126 Howth St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997592.47815 | 2091138.0222 | 37.721728810427706 | -122.450411736413 | (37.7217288104277, -122.450411736413) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");