Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 564 | 564 | 222895 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3080 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | Permit Number 27054 | 6006273.18784 | 2106724.0940099997 | 37.765017648370105 | -122.42151112584801 | (37.7650176483701, -122.421511125848) | ||
| 568 | 568 | 222894 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3080 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1989 12:00:00 AM | 14 | Width 3ft | Permit Number 27054 | 6006296.82054 | 2106727.45524 | 37.765028210007 | -122.42142962480301 | (37.765028210007, -122.421429624803) | |
| 946 | 946 | 23565 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2958 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X2 | 6005634.29929 | 2120573.5209 | 37.8030087114389 | -122.424706189543 | (37.8030087114389, -122.424706189543) | |||
| 1160 | 1160 | 18860 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2212 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004055.90045 | 2116026.39415 | 37.7904341972353 | -122.429843740294 | (37.7904341972353, -122.429843740294) | |||
| 1249 | 1249 | 237914 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1001 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 4ft | 5997227.0 | 2107052.0 | 37.7654037766697 | -122.452823145368 | (37.7654037766697, -122.452823145368) | |||
| 1440 | 1440 | 222893 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 301 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 4ft | 6004914.2278 | 2106488.73534 | 37.7642946914815 | -122.426194676362 | (37.7642946914815, -122.426194676362) | |||
| 3024 | 3024 | 225099 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 109 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 14 | Width 3ft | Permit Number 37779 | 6003663.75485 | 2108815.27117 | 37.770612035853404 | -122.43068573955401 | (37.7706120358534, -122.430685739554) | |
| 3203 | 3203 | 2528 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | 3X3 | 6016517.59351 | 2098961.55525 | 37.744275647795604 | -122.38553691568998 | (37.7442756477956, -122.38553691569) | ||
| 3206 | 3206 | 189833 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 2 | : 4 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 14 | Width 3ft | 6016585.78665 | 2098909.19771 | 37.7441356575455 | -122.385297468507 | (37.7441356575455, -122.385297468507) | ||
| 3214 | 3214 | 2529 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | 3X3 | 6016429.35383 | 2099026.76072 | 37.744449806015204 | -122.385846576558 | (37.7444498060152, -122.385846576558) | ||
| 3231 | 3231 | 188482 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1580 Burke Ave | 3 | : 4 | Tree 1 | DPW 2 | 03/30/1990 12:00:00 AM | 9 | Width 4ft | 6016171.38717 | 2099220.37618 | 37.7449671554124 | -122.386752079638 | (37.7449671554124, -122.386752079638) | ||
| 3247 | 3247 | 188481 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 10 | : 4 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | Width 3ft | 6016299.33242 | 2099120.87091 | 37.744701017238796 | -122.38630272799999 | (37.7447010172388, -122.386302728) | ||
| 3418 | 3418 | 18865 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2230 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003863.26827 | 2115999.97726 | 37.7903507527417 | -122.43050834919501 | (37.7903507527417, -122.430508349195) | |||
| 3892 | 3892 | 222929 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 979 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1979 12:00:00 AM | 10 | Width 4ft | Permit Number 17592 | 5999199.8898 | 2106672.6396 | 37.7644750037296 | -122.445972112616 | (37.7644750037296, -122.445972112616) | |
| 4380 | 4380 | 106727 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2809 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000017.8025 | 2114366.8285 | 37.785647962066996 | -122.443695977864 | (37.785647962067, -122.443695977864) | |||
| 4762 | 4762 | 188472 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6007955.34249 | 2108999.99523 | 37.7713614445082 | -122.41585412666099 | (37.7713614445082, -122.415854126661) | |||
| 4765 | 4765 | 188470 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6008074.61393 | 2108923.40936 | 37.7711578622784 | -122.415436137088 | (37.7711578622784, -122.415436137088) | |||
| 4768 | 4768 | 188475 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6007904.0486 | 2109028.3939900002 | 37.7714365370061 | -122.41603356660299 | (37.7714365370061, -122.416033566603) | |||
| 4779 | 4779 | 188471 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6008055.90153 | 2108933.51614 | 37.7711845613454 | -122.41550157982799 | (37.7711845613454, -122.415501579828) | |||
| 4791 | 4791 | 188467 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6008105.3532300005 | 2108904.54782 | 37.77110780062 | -122.415328472924 | (37.77110780062, -122.415328472924) | |||
| 4806 | 4806 | 188473 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6007942.65601 | 2109006.33264 | 37.771378132318894 | -122.415898458759 | (37.7713781323189, -122.415898458759) | |||
| 4810 | 4810 | 188468 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6008096.35172 | 2108912.02487 | 37.7711278249234 | -122.415360138963 | (37.7711278249234, -122.415360138963) | |||
| 4814 | 4814 | 188469 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6008084.262680001 | 2108917.7420900003 | 37.771142843604004 | -122.41540236032499 | (37.771142843604, -122.415402360325) | |||
| 4816 | 4816 | 188474 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6007923.258880001 | 2109012.80714 | 37.7713948192467 | -122.41596601311599 | (37.7713948192467, -122.415966013116) | |||
| 5000 | 5000 | 83036 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:55:00 PM | 3 | 6018559.56213 | 2097806.04485 | 37.7412156164156 | -122.378395939846 | (37.7412156164156, -122.378395939846) | |||
| 5182 | 5182 | 225094 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 621 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780775 | 6002723.2165 | 2108842.98565 | 37.7706348030957 | -122.433941050651 | (37.7706348030957, -122.433941050651) | |
| 6028 | 6028 | 11179 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2750X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 6006893.591019999 | 2121789.4662 | 37.8064184289444 | -122.42043473540001 | (37.8064184289444, -122.4204347354) | |||
| 6403 | 6403 | 11181 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2750X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6006890.68476 | 2121823.94924 | 37.8065129467732 | -122.42044724225599 | (37.8065129467732, -122.420447242256) | |||
| 6620 | 6620 | 18859 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2212 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/1992 12:00:00 AM | 12 | 3X3 | 6004082.46062 | 2116030.31556 | 37.7904464684691 | -122.429752123658 | (37.7904464684691, -122.429752123658) | ||
| 7048 | 7048 | 18853 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2222 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6004009.33777 | 2116018.08762 | 37.7904087527096 | -122.430004251319 | (37.7904087527096, -122.430004251319) | |||
| 7135 | 7135 | 65883 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3100X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2013 12:00:00 AM | 3 | Permit Number 770126 | 6002440.42815 | 2118878.8821400004 | 37.798174776289294 | -122.435637321312 | (37.7981747762893, -122.435637321312) | ||
| 7397 | 7397 | 18866 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2241 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004050.55009 | 2115976.0428299997 | 37.7902956422834 | -122.429858659173 | (37.7902956422834, -122.429858659173) | |||
| 7418 | 7418 | 11180 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2750X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006892.18437 | 2121805.14198 | 37.806461391357004 | -122.420440716763 | (37.806461391357, -122.420440716763) | |||
| 7791 | 7791 | 18864 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2230 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003886.2489 | 2116004.41909 | 37.7903642506674 | -122.430429154879 | (37.7903642506674, -122.430429154879) | |||
| 7949 | 7949 | 14640 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 600X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6006169.26455 | 2112150.7692 | 37.779912136471 | -122.422256155719 | (37.779912136471, -122.422256155719) | |||
| 8392 | 8392 | 23566 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2958 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2005 12:00:00 AM | 6 | 6005632.06356 | 2120580.6858200002 | 37.8030282582004 | -122.424714436346 | (37.8030282582004, -122.424714436346) | |||
| 9098 | 9098 | 2530 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016273.7509883 | 2099134.0637751 | 37.7447358261247 | -122.38639210410601 | (37.7447358261247, -122.386392104106) | |||
| 9135 | 9135 | 2542 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1580 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016211.0400559995 | 2099180.9466222 | 37.7448610852571 | -122.386612216975 | (37.7448610852571, -122.386612216975) | |||
| 9160 | 9160 | 16481 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 9221 | 9221 | 16483 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 9262 | 9262 | 16480 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 9277 | 9277 | 16482 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 9322 | 9322 | 16485 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 9397 | 9397 | 2544 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1580 BURKE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6016440.0 | 2099034.0 | 37.7444702727306 | -122.385810268433 | (37.7444702727306, -122.385810268433) | |||
| 9402 | 9402 | 16488 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 0 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 9478 | 9478 | 16486 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 9480 | 9480 | 2531 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016273.7509883 | 2099134.0637751 | 37.7447358261247 | -122.38639210410601 | (37.7447358261247, -122.386392104106) | |||
| 9911 | 9911 | 173732 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1690x Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015419.0 | 2098106.0 | 37.7418656239974 | -122.389275919147 | (37.7418656239974, -122.389275919147) | ||||
| 11938 | 11938 | 19762 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 100 STAIRWAY16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 30ST | ||||||||
| 11951 | 11951 | 19967 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 100 STAIRWAY41 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 13413 | 13413 | 17446 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1966 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6012949.4647699995 | 2096727.20845 | 37.737942533829106 | -122.397718137505 | (37.7379425338291, -122.397718137505) | |||
| 13442 | 13442 | 47240 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1006X Jamestown Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6013969.3769 | 2089681.5637 | 37.7186533627648 | -122.39369877082301 | (37.7186533627648, -122.393698770823) |
| 13474 | 13474 | 17398 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1734X Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6014174.38954 | 2095813.0161 | 37.7355004859498 | -122.393418978825 | (37.7355004859498, -122.393418978825) | |||
| 13486 | 13486 | 2517 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016481.64243 | 2098901.45238 | 37.7441086284068 | -122.385657039951 | (37.7441086284068, -122.385657039951) | |||
| 13493 | 13493 | 107151 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 215 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6013483.16907 | 2106058.28155 | 37.7635933686511 | -122.396526740817 | (37.7635933686511, -122.396526740817) | |||
| 13503 | 13503 | 16543 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6016084.8488 | 2098009.98397 | 37.74163887514379 | -122.38696691508999 | (37.7416388751438, -122.38696691509) | ||
| 13524 | 13524 | 17444 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1950 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6013023.363469999 | 2096670.73663 | 37.737791588910206 | -122.397458672302 | (37.7377915889102, -122.397458672302) | |||
| 13616 | 13616 | 83038 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2006 12:00:00 AM | 6018593.33009 | 2097780.6594 | 37.7411477742489 | -122.378277419086 | (37.7411477742489, -122.378277419086) | |||
| 13824 | 13824 | 2526 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6016552.46567 | 2098935.10176 | 37.744204941317 | -122.385414490998 | (37.744204941317, -122.385414490998) | |||
| 13899 | 13899 | 16527 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016370.17243 | 2098292.39049 | 37.7424301004582 | -122.386000034169 | (37.7424301004582, -122.386000034169) | |||
| 13990 | 13990 | 16545 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:31:00 PM | 3 | 3x3 | 6016063.42274 | 2097976.36799 | 37.7415453861211 | -122.38703865582701 | (37.7415453861211, -122.387038655827) | ||
| 14034 | 14034 | 78331 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 50 Pomona St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014103.033559999 | 2094377.1679 | 37.7315539757311 | -122.393565225657 | (37.7315539757311, -122.393565225657) | |
| 14232 | 14232 | 2518 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016498.61775 | 2098890.1921900003 | 37.7440786495081 | -122.38559755790399 | (37.7440786495081, -122.385597557904) | |||
| 14244 | 14244 | 2501 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016709.08958 | 2098828.16093 | 37.7439199677279 | -122.38486546568599 | (37.7439199677279, -122.384865465686) | |||
| 14264 | 14264 | 2516 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016465.84234 | 2098914.75953 | 37.7441442928392 | -122.38571260096 | (37.7441442928392, -122.38571260096) | |||
| 14293 | 14293 | 17415 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6013619.40586 | 2096223.80848 | 37.73659758599771 | -122.395366549732 | (37.7365975859977, -122.395366549732) | |||
| 14309 | 14309 | 14975 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Mendell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3x3 | 6016578.93942 | 2097580.627 | 37.7404872941606 | -122.38522858943001 | (37.7404872941606, -122.38522858943) | |||
| 14317 | 14317 | 2533 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016180.33193 | 2099126.3075599996 | 37.7447093575531 | -122.386714591425 | (37.7447093575531, -122.386714591425) | |||
| 14401 | 14401 | 17464 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2043 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6012526.80505 | 2096970.93797 | 37.738588218270294 | -122.39919659325301 | (37.7385882182703, -122.399196593253) | |||
| 14457 | 14457 | 6846 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 595X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015951.07042 | 2097735.77472 | 37.7408785442151 | -122.387410355501 | (37.7408785442151, -122.387410355501) | |||
| 14483 | 14483 | 7418 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1090 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6010342.8854 | 2110986.7114 | 37.77695044101711 | -122.407735574616 | (37.7769504410171, -122.407735574616) | |||
| 14523 | 14523 | 107150 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 219 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5x5 | 6013483.53646 | 2106027.96623 | 37.7635101499066 | -122.396523344982 | (37.7635101499066, -122.396523344982) | |||
| 14666 | 14666 | 17420 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1844 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013467.77602 | 2096339.40457 | 37.736906554399496 | -122.395898900707 | (37.7369065543995, -122.395898900707) | |||
| 14807 | 14807 | 2520 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016533.26 | 2098864.45764 | 37.744009904432 | -122.385475978555 | (37.744009904432, -122.385475978555) | |||
| 14851 | 14851 | 2534 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016196.15475 | 2099115.85615 | 37.744681536129896 | -122.38665915001499 | (37.7446815361299, -122.386659150015) | |||
| 14926 | 14926 | 17432 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1899 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6013304.38665 | 2096386.76437 | 37.7370275033033 | -122.39646713286899 | (37.7370275033033, -122.396467132869) | |||
| 14957 | 14957 | 2540 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016367.14673 | 2098986.82897 | 37.7443367189812 | -122.386058894813 | (37.7443367189812, -122.386058894813) | |||
| 15046 | 15046 | 17433 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1900 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6013265.7394 | 2096489.52235 | 37.7373075045406 | -122.396607955902 | (37.7373075045406, -122.396607955902) | |||
| 15063 | 15063 | 16523 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016311.2033400005 | 2098218.94031 | 37.742225157565606 | -122.386198814044 | (37.7422251575656, -122.386198814044) | |||
| 15110 | 15110 | 7417 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1090 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2003 12:00:00 AM | 6 | 3X3 | 6010360.058999999 | 2111002.9309 | 37.7769959373466 | -122.40767730948099 | (37.7769959373466, -122.407677309481) | ||
| 15226 | 15226 | 16522 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016298.51131 | 2098203.0123900003 | 37.7421807202532 | -122.386241589372 | (37.7421807202532, -122.386241589372) | |||
| 15281 | 15281 | 2535 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016210.73833 | 2099105.1228400003 | 37.7446528720358 | -122.386607974081 | (37.7446528720358, -122.386607974081) | |||
| 15374 | 15374 | 16525 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016336.5971099995 | 2098251.27907 | 37.7423153586798 | -122.38611326331801 | (37.7423153586798, -122.386113263318) | |||
| 15376 | 15376 | 17400 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1740 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6014126.91093 | 2095851.1855799998 | 37.735602653440296 | -122.393585802156 | (37.7356026534403, -122.393585802156) | |||
| 15444 | 15444 | 2521 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016567.75907 | 2098840.9849799997 | 37.743947361995794 | -122.38535505210501 | (37.7439473619958, -122.385355052105) | |||
| 15447 | 15447 | 2513 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016387.5124699995 | 2098972.29453 | 37.7442979375022 | -122.385987460765 | (37.7442979375022, -122.385987460765) | |||
| 15529 | 15529 | 78325 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 50 Pomona St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014082.074630001 | 2094268.0058099998 | 37.731253074258596 | -122.393630047885 | (37.7312530742586, -122.393630047885) | |
| 15570 | 15570 | 2499 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016750.97009 | 2098814.51662 | 37.7438848195436 | -122.384719700863 | (37.7438848195436, -122.384719700863) | |||
| 15581 | 15581 | 2519 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016516.51157 | 2098877.59586 | 37.7440450526322 | -122.38553480681101 | (37.7440450526322, -122.385534806811) | |||
| 15597 | 15597 | 16524 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016323.686869999 | 2098236.56346 | 37.7422742380775 | -122.386156877755 | (37.7422742380775, -122.386156877755) | |||
| 15614 | 15614 | 17378 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1600 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6014792.92868 | 2095354.29337 | 37.7342752738796 | -122.391248382303 | (37.7342752738796, -122.391248382303) | |||
| 15657 | 15657 | 2514 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6016429.25086 | 2098939.95078 | 37.7442114380124 | -122.385840882964 | (37.7442114380124, -122.385840882964) | |||
| 15689 | 15689 | 2500 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016728.12134 | 2098825.14197 | 37.7439127309012 | -122.384799447345 | (37.7439127309012, -122.384799447345) | |||
| 15763 | 15763 | 2504 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016654.18712 | 2098861.64491 | 37.7440088711085 | -122.385057640012 | (37.7440088711085, -122.385057640012) | |||
| 15837 | 15837 | 16547 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016044.76119 | 2097949.4335 | 37.741470396145104 | -122.387101303489 | (37.7414703961451, -122.387101303489) | |||
| 15887 | 15887 | 16546 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6016053.72523 | 2097961.74591 | 37.7415046998888 | -122.387071167201 | (37.7415046998888, -122.387071167201) | |||
| 15943 | 15943 | 2515 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016446.65639 | 2098928.8879 | 37.7441820247861 | -122.385779926925 | (37.7441820247861, -122.385779926925) | |||
| 15961 | 15961 | 17437 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1919 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6013108.75457 | 2096537.612 | 37.7374308105776 | -122.397154099803 | (37.7374308105776, -122.397154099803) | |||
| 15967 | 15967 | 17458 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1999 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3x3 | 6012778.88075 | 2096779.8432200002 | 37.7380775571329 | -122.398311626199 | (37.7380775571329, -122.398311626199) | |||
| 16011 | 16011 | 47239 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1004X Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6013984.3411 | 2089670.3406 | 37.718623377888896 | -122.393646260173 | (37.7186233778889, -122.393646260173) |
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");