Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 88377 | 88377 | 21777 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2500X Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1992 12:00:00 AM | 3 | 3x3 | 6008409.452819999 | 2121407.87429 | 37.8054559800011 | -122.415161778523 | (37.8054559800011, -122.415161778523) | ||
| 84256 | 84256 | 63130 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 26 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23644 | 6007187.15982152 | 2099399.82780325 | 37.7449583833589 | -122.417830699083 | (37.7449583833589, -122.417830699083) | ||
| 84450 | 84450 | 51842 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 34 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 48069 | 6007044.58832094 | 2099374.8552715 | 37.7448817898933 | -122.41832191623199 | (37.7448817898933, -122.418321916232) | ||
| 120646 | 120646 | 63121 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 42 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23632 | 6007120.53987433 | 2099276.08223849 | 37.7446148564174 | -122.418052288309 | (37.7446148564174, -122.418052288309) | ||
| 143717 | 143717 | 63120 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 46 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23631 | 6007008.06371762 | 2099307.94192573 | 37.7446960047915 | -122.418443468102 | (37.7446960047915, -122.418443468102) | ||
| 144535 | 144535 | 63125 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 80 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23639 | 6007006.19001516 | 2099063.67894521 | 37.744025207978 | -122.418432630519 | (37.744025207978, -122.418432630519) | ||
| 117344 | 117344 | 57469 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 71 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1987 12:00:00 AM | Permit Number 24965 | 5992451.26080169 | 2092911.00734917 | 37.7263014049972 | -122.46831233823299 | (37.7263014049972, -122.468312338233) | ||
| 81764 | 81764 | 63117 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 72 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23624 | 6006928.92708318 | 2099162.96302102 | 37.7442934699851 | -122.418706828381 | (37.7442934699851, -122.418706828381) | ||
| 86972 | 86972 | 58315 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 86 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23623 | 6006886.31504247 | 2099084.89744452 | 37.744076720184495 | -122.41884863660299 | (37.7440767201845, -122.418848636603) | ||
| 93830 | 93830 | 63116 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 115 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23622 | 6006844.85682717 | 2098899.69149034 | 37.7435658517454 | -122.41897885676701 | (37.7435658517454, -122.418978856767) | ||
| 107534 | 107534 | 63118 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 70 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23625 | 6006935.01451866 | 2099174.11524824 | 37.7443244342333 | -122.418686569992 | (37.7443244342333, -122.418686569992) | ||
| 123961 | 123961 | 57556 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 57 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1986 12:00:00 AM | Permit Number 23627 | 6007019.50965831 | 2099220.3784742 | 37.7444562195491 | -122.418397682663 | (37.7444562195491, -122.418397682663) | ||
| 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) | |
| 142139 | 142139 | 33711 | 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 | Permit Number 37779 | 6003691.57039211 | 2108804.29883955 | 37.7705834843276 | -122.430588742236 | (37.7705834843276, -122.430588742236) | |||
| 16790 | 16790 | 16509 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016661.92107 | 2098301.48789 | 37.742471221974 | -122.384991878867 | (37.742471221974, -122.384991878867) | ||
| 94061 | 94061 | 94895 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
| 94704 | 94704 | 94894 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
| 104168 | 104168 | 94893 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
| 119228 | 119228 | 94892 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
| 106049 | 106049 | 59362 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/1980 12:00:00 AM | Permit Number 18713 | 6001270.92113106 | 2096540.31776103 | 37.736772117155496 | -122.43808313790001 | (37.7367721171555, -122.4380831379) | |||
| 105938 | 105938 | 51301 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 101 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/2004 12:00:00 AM | Permit Number 47670 | 6008105.70875607 | 2112751.56982087 | 37.7816708281319 | -122.41559966360799 | (37.7816708281319, -122.415599663608) | ||
| 88159 | 88159 | 65411 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 81 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1989 12:00:00 AM | Permit Number 28262 | 6004263.16526256 | 2108931.19399052 | 37.77096427235279 | -122.42862063626801 | (37.7709642723528, -122.428620636268) | |||
| 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) | |
| 124706 | 124706 | 63223 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 74 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1986 12:00:00 AM | Permit Number 23767 | 6007024.24525419 | 2099097.21630379 | 37.7441183104389 | -122.418372576893 | (37.7441183104389, -122.418372576893) | ||
| 125283 | 125283 | 35826 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 658 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47147 | 6002331.25520589 | 2089974.9119099 | 37.718805244392904 | -122.433947949751 | (37.7188052443929, -122.433947949751) | ||
| 124125 | 124125 | 101489 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 59X Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769087 | 6005416.7 | 2109221.0 | 37.7718252244657 | -122.424651142233 | (37.7718252244657, -122.424651142233) | |
| 85788 | 85788 | 57557 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 88 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1976 12:00:00 AM | 8 | 3x3 | Permit Number 16422 | 6006885.0 | 2099070.0 | 37.744035741100504 | -122.418852127392 | (37.7440357411005, -122.418852127392) | |
| 20488 | 20488 | 82142 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | ||
| 106363 | 106363 | 82092 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | ||
| 111792 | 111792 | 82143 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | ||
| 113829 | 113829 | 82141 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | ||
| 127952 | 127952 | 82121 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 44 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49840 | 5998809.17063994 | 2096527.78133102 | 37.7365973852663 | -122.44659355011801 | (37.7365973852663, -122.446593550118) | ||
| 177476 | 177476 | 32581 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1314 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 4 | Permit Number 37055 | 5985876.1437 | 2106257.7648 | 37.762566049362704 | -122.492024105228 | (37.7625660493627, -122.492024105228) | |
| 91351 | 91351 | 63739 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 665 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1988 12:00:00 AM | Permit Number 24410 | 6003393.73641512 | 2109629.91106527 | 37.7728335359212 | -122.43167790707399 | (37.7728335359212, -122.431677907074) | ||
| 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) | ||
| 154115 | 154115 | 32473 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 144 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 9 | Permit Number 36981 | 6000263.910540001 | 2106227.11632 | 37.763312407875205 | -122.442259981907 | (37.7633124078752, -122.442259981907) | |
| 78262 | 78262 | 62275 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 141 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22411 | 6004215.98521889 | 2109270.59348358 | 37.771893510559 | -122.428808033039 | (37.771893510559, -122.428808033039) | ||
| 89326 | 89326 | 62271 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 108 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22405 | 6004283.36290773 | 2109163.56782991 | 37.771603457424604 | -122.428567338549 | (37.7716034574246, -122.428567338549) | ||
| 101649 | 101649 | 62273 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 123 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22409 | 6004226.44756002 | 2109195.3304156 | 37.7716874486567 | -122.42876647673701 | (37.7716874486567, -122.428766476737) | ||
| 102431 | 102431 | 62270 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 102 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22404 | 6004290.78316217 | 2109110.18870614 | 37.7714573112605 | -122.42853786594999 | (37.7714573112605, -122.42853786595) | ||
| 105012 | 105012 | 62272 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 113 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1985 12:00:00 AM | Permit Number 22406 | 6004233.40404883 | 2109145.28748516 | 37.7715504366717 | -122.428738845772 | (37.7715504366717, -122.428738845772) | ||
| 104509 | 104509 | 60288 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2932 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1982 12:00:00 AM | Permit Number 19852 | 6009284.44431761 | 2102786.94037008 | 37.754376447104995 | -122.410817812439 | (37.754376447105, -122.410817812439) | ||
| 131650 | 131650 | 32421 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36948 | 6000917.26502 | 2096711.2312599998 | 37.7372212865363 | -122.439318125938 | (37.7372212865363, -122.439318125938) | ||
| 81810 | 81810 | 50386 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 100880 | 100880 | 50384 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 103487 | 103487 | 50383 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 104167 | 104167 | 50385 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 109880 | 109880 | 50388 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 296 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 110320 | 110320 | 60260 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2844 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/1984 12:00:00 AM | Permit Number 19815 | 6009158.9675903 | 2103949.64001782 | 37.757561921733 | -122.41133387759399 | (37.757561921733, -122.411333877594) | ||
| 128506 | 128506 | 60264 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2804 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/1984 12:00:00 AM | Permit Number 19820 | 6009362.55423892 | 2103960.83669592 | 37.7576040815568 | -122.410630580485 | (37.7576040815568, -122.410630580485) | ||
| 145409 | 145409 | 60263 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2781 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/1984 12:00:00 AM | Permit Number 19819 | 6009497.44754454 | 2103916.17692673 | 37.757489017835496 | -122.410160909746 | (37.7574890178355, -122.410160909746) | ||
| 105923 | 105923 | 59722 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2905 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/14/1984 12:00:00 AM | Permit Number 19154 | 6008831.83417105 | 2103879.56302809 | 37.757351153159 | -122.41246028798 | (37.757351153159, -122.41246028798) | ||
| 89790 | 89790 | 60257 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 911 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1982 12:00:00 AM | Permit Number 19811 | 6009422.17813465 | 2103864.55146626 | 37.757343046708 | -122.410417577389 | (37.757343046708, -122.410417577389) | ||
| 118697 | 118697 | 60271 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2761 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1982 12:00:00 AM | 12 | 3x3 | Permit Number 19827 | 6009603.81924648 | 2103922.02713572 | 37.7575110429284 | -122.409793445145 | (37.7575110429284, -122.409793445145) |
| 141489 | 141489 | 96123 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 181 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767774 | 6004920.8 | 2095965.5 | 37.735400693790204 | -122.42542300740601 | (37.7354006937902, -122.425423007406) | |
| 72094 | 72094 | 51302 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2004 12:00:00 AM | 12 | Permit Number 47670 | 6008052.8861 | 2112760.32075 | 37.781691886721795 | -122.415783025366 | (37.7816918867218, -122.415783025366) | |
| 151813 | 151813 | 51298 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2004 12:00:00 AM | 7 | Permit Number 47670 | 6008009.38054 | 2112753.19289 | 37.7816698695126 | -122.415933029587 | (37.7816698695126, -122.415933029587) | |
| 159567 | 159567 | 51299 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2004 12:00:00 AM | 10 | Permit Number 47670 | 6008033.00976 | 2112757.64367 | 37.781683418708404 | -122.415851598691 | (37.7816834187084, -122.415851598691) | |
| 39687 | 39687 | 80561 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 15 | 6013651.87309 | 2096197.8113799999 | 37.736528009043795 | -122.395252475224 | (37.7365280090438, -122.395252475224) | ||
| 18276 | 18276 | 16647 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 178 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2015 12:00:00 AM | 14 | 4x4 | 6002850.6051900005 | 2107244.6681 | 37.7662534427777 | -122.433386179722 | (37.7662534427777, -122.433386179722) | ||
| 40687 | 40687 | 57316 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1515 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16140 | 5999629.2653 | 2114178.0114 | 37.7851073514303 | -122.445026621162 | (37.7851073514303, -122.445026621162) | ||
| 169707 | 169707 | 57317 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2706 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16141 | 5999606.4685 | 2114016.4513 | 37.7846624482509 | -122.44509387174801 | (37.7846624482509, -122.445093871748) | ||
| 185909 | 185909 | 57320 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2728 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 15 | Permit Number 16145 | 5999531.6355 | 2114001.5838 | 37.7846173544843 | -122.445351698652 | (37.7846173544843, -122.445351698652) | ||
| 138411 | 138411 | 63122 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 42 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1993 12:00:00 AM | Permit Number 32290 | 6007020.23858667 | 2099330.24637666 | 37.7447579331798 | -122.41840295087499 | (37.7447579331798, -122.418402950875) | ||
| 106473 | 106473 | 60259 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 900 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28050 | 6009367.15001104 | 2103917.51160129 | 37.757485378294895 | -122.41061162692301 | (37.7574853782949, -122.410611626923) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 66191 | 66191 | 48531 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500(REVISED) Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | |||
| 88250 | 88250 | 48533 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500(REVISED) Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | |||
| 138752 | 138752 | 48532 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500(REVISED) Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | |||
| 99294 | 99294 | 52077 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2959 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2005 12:00:00 AM | Permit Number 48273 | 6009147.75263717 | 2102727.30105861 | 37.7542050255745 | -122.41128631630698 | (37.7542050255745, -122.411286316307) | ||
| 100270 | 100270 | 54886 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 140 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1972 12:00:00 AM | 3x4 | Permit Number 10751 | 5997750.13061777 | 2107162.33224107 | 37.7657366841835 | -122.45102172287201 | (37.7657366841835, -122.451021722872) | ||
| 150575 | 150575 | 56925 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 12 | Permit Number 14168 | 6014784.53223 | 2116103.90747 | 37.7912487383869 | -122.392728500917 | (37.7912487383869, -122.392728500917) | ||
| 110804 | 110804 | 21781 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2550X Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2011 12:00:00 AM | 3 | 4x4 | 6008458.5658599995 | 2121488.77145 | 37.805680863133205 | -122.41499754514 | (37.8056808631332, -122.41499754514) | ||
| 124297 | 124297 | 59670 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 98X PARNASSUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 15 | 3x3 | Permit Number 32228 | 5998297.0 | 2106864.0 | 37.76494883262271 | -122.449108733904 | (37.7649488326227, -122.449108733904) |
| 142476 | 142476 | 68375 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 175 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32198 | 5997884.42699251 | 2106160.35589629 | 37.76299319850379 | -122.45048498278999 | (37.7629931985038, -122.45048498279) | ||
| 81979 | 81979 | 56848 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1025 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | 6x5 | Permit Number 14082 | 5998817.86133668 | 2106377.94605096 | 37.763644027141396 | -122.447272227776 | (37.7636440271414, -122.447272227776) | ||
| 97514 | 97514 | 56845 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 980 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | 4x4 | Permit Number 14078 | 5998833.42862215 | 2106621.08669964 | 37.7643125198309 | -122.447235885769 | (37.7643125198309, -122.447235885769) | ||
| 53040 | 53040 | 56853 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 245 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1974 12:00:00 AM | 10 | Permit Number 14088 | 6004257.880580001 | 2091960.10063 | 37.724365284516395 | -122.427429718013 | (37.7243652845164, -122.427429718013) | ||
| 82379 | 82379 | 65221 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 411 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 28008 | 6002203.13463286 | 2091195.37244375 | 37.722149084859296 | -122.43447802603701 | (37.7221490848593, -122.434478026037) | ||
| 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) | |
| 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) | |
| 124374 | 124374 | 37053 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 231 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2015 12:00:00 AM | 3 | 6x9 | Permit Number 775674 | 6005030.06979159 | 2099868.96006137 | 37.7461248828886 | -122.425322907066 | (37.7461248828886, -122.425322907066) |
| 78776 | 78776 | 85052 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 355x Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/27/2007 12:00:00 AM | Permit Number 49332 | 6004826.8 | 2109751.4 | 37.7732482408903 | -122.426729425627 | (37.7732482408903, -122.426729425627) | |||
| 115300 | 115300 | 85051 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 355x Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/27/2007 12:00:00 AM | Permit Number 49332 | 6004826.8 | 2109751.4 | 37.7732482408903 | -122.426729425627 | (37.7732482408903, -122.426729425627) | |||
| 85449 | 85449 | 41699 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2 Mizpah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42149 | 6001021.55719924 | 2096664.38095079 | 37.737098580964606 | -122.438954184383 | (37.7370985809646, -122.438954184383) | ||
| 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) | |
| 116782 | 116782 | 4389 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 56 Chilton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2008 12:00:00 AM | 30 | 3x3 | 6001657.8215553 | 2095631.9001159 | 37.7342998083721 | -122.436680450501 | (37.7342998083721, -122.436680450501) | ||
| 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) | |||
| 126974 | 126974 | 49779 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 241@ BLANKEN Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46565 | 6012711.25696991 | 2087289.78103258 | 37.7120160109599 | -122.39787992529499 | (37.7120160109599, -122.397879925295) | ||
| 122387 | 122387 | 65950 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 120 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28971 | 6008148.07854497 | 2112823.994523 | 37.7818720705068 | -122.415458212735 | (37.7818720705068, -122.415458212735) | ||
| 22318 | 22318 | 3611 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018038.2961099995 | 2098194.83807 | 37.7422544187983 | -122.380225323637 | (37.7422544187983, -122.380225323637) | ||
| 140595 | 140595 | 61796 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 60 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/1985 12:00:00 AM | Permit Number 21819 | 6002883.06164476 | 2108748.24537279 | 37.7703837393735 | -122.43338137366399 | (37.7703837393735, -122.433381373664) | ||
| 126575 | 126575 | 21789 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/2015 12:00:00 AM | 3 | 4X4 | 6008161.90241 | 2121549.7946200003 | 37.8058317424248 | -122.41602851933997 | (37.8058317424248, -122.41602851934) | ||
| 30875 | 30875 | 64436 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2445 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1988 12:00:00 AM | 12 | Permit Number 25292 | 6006658.75135 | 2119650.10198 | 37.8005310432266 | -122.421095439396 | (37.8005310432266, -122.421095439396) | ||
| 85510 | 85510 | 4912 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2016 12:00:00 AM | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
| 140926 | 140926 | 4919 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/2016 12:00:00 AM | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | ||
| 117686 | 117686 | 47317 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2524 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2002 12:00:00 AM | Permit Number 45245 | 6010338.92838604 | 2105074.55283943 | 37.7607167883884 | -122.407332377331 | (37.7607167883884, -122.407332377331) | |||
| 127575 | 127575 | 47316 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2524 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | Permit Number 45245 | 6010338.92838604 | 2105074.55283943 | 37.7607167883884 | -122.407332377331 | (37.7607167883884, -122.407332377331) |
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");