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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114200 | 114200 | 50874 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1160 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2004 12:00:00 AM | Permit Number 47384 | 6007625.30066101 | 2102900.0062832 | 37.7545937308752 | -122.41656358052 | (37.7545937308752, -122.41656358052) | ||
| 114250 | 114250 | 65614 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 901 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 3x3 | Permit Number 28521 | 6001429.80797007 | 2088950.28994853 | 37.715940663173704 | -122.43699057256201 | (37.7159406631737, -122.436990572562) | |
| 114821 | 114821 | 63106 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 67 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1986 12:00:00 AM | Permit Number 23602 | 6006857.2853572 | 2099318.42969221 | 37.744716312649004 | -122.41896557522101 | (37.744716312649, -122.418965575221) | ||
| 116121 | 116121 | 110179 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 321 Fair Oaks St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005492.60818902 | 2101839.04635751 | 37.7515604083348 | -122.423863569693 | (37.7515604083348, -122.423863569693) | ||||
| 116794 | 116794 | 94386 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 117345 | 117345 | 51287 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 726 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 47659 | 5989465.45229129 | 2110387.70383509 | 37.774114887360504 | -122.479912367003 | (37.7741148873605, -122.479912367003) | ||
| 118139 | 118139 | 88605 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2719 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 52923 | 5991770.2 | 2096974.3 | 37.737418827963 | -122.470962580807 | (37.737418827963, -122.470962580807) | ||
| 118150 | 118150 | 68260 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 330 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32066 | 6009617.65665916 | 2092860.11678258 | 37.7271382244341 | -122.408965114302 | (37.7271382244341, -122.408965114302) | ||
| 118459 | 118459 | 94599 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1709 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997540.0 | 2108126.0 | 37.7683706375079 | -122.451818041345 | (37.7683706375079, -122.451818041345) | |||||
| 119576 | 119576 | 68317 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1999X 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32130 | 5981353.71840295 | 2101490.23529545 | 37.7492103807501 | -122.50731153380801 | (37.7492103807501, -122.507311533808) | ||
| 120422 | 120422 | 30787 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 488 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1995 12:00:00 AM | 3x3 | Permit Number 51964 | 6013865.01842582 | 2112595.14259648 | 37.7815633679001 | -122.39566406844601 | (37.7815633679001, -122.395664068446) | ||
| 120912 | 120912 | 60707 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1059 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20357 | 6009209.04775492 | 2102998.94986664 | 37.754954349681 | -122.4110935285 | (37.754954349681, -122.4110935285) | ||
| 121437 | 121437 | 33220 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 130 Vasquez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37412 | 5995037.97859853 | 2099619.33373801 | 37.7448698872964 | -122.459855964981 | (37.7448698872964, -122.459855964981) | ||
| 121834 | 121834 | 69022 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2094 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | Permit Number 33026 | 5981407.07152231 | 2100831.13487358 | 37.7474038185251 | -122.507078153918 | (37.7474038185251, -122.507078153918) | ||
| 122165 | 122165 | 62017 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 53 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1986 12:00:00 AM | Permit Number 22088 | 6004287.33949957 | 2108757.29100043 | 37.7704881450556 | -122.428524619186 | (37.7704881450556, -122.428524619186) | ||
| 122655 | 122655 | 91085 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 4055 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2009 12:00:00 AM | 3x3 | Permit Number 51980 | 6002824.0 | 2101802.0 | 37.751307673555395 | -122.433089295463 | (37.7513076735554, -122.433089295463) | ||
| 122660 | 122660 | 66751 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1126 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/12/1991 12:00:00 AM | Permit Number 30003 | 5998922.20523511 | 2106051.2337001 | 37.7627529185657 | -122.446887825215 | (37.7627529185657, -122.446887825215) | ||
| 123487 | 123487 | 62308 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 930@ Lorraine Ct Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | Permit Number 22446 | 5996162.7133263005 | 2112267.41531283 | 37.77966290152 | -122.456881494589 | (37.77966290152, -122.456881494589) | ||
| 124637 | 124637 | 67497 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 143 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/18/1999 12:00:00 AM | Permit Number 31025 | 5999134.28418924 | 2093760.51474913 | 37.7290176881307 | -122.445270595435 | (37.7290176881307, -122.445270595435) | ||
| 125188 | 125188 | 63363 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 339 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | Permit Number 30042 | 6006824.56139145 | 2096444.26906016 | 37.736822665934 | -122.418874924172 | (37.736822665934, -122.418874924172) | ||
| 125326 | 125326 | 94378 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 125653 | 125653 | 4328 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 816 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2000 12:00:00 AM | 3 | 3X3 | 6001892.96711 | 2095861.1675200001 | 37.7349426843331 | -122.435883876812 | (37.7349426843331, -122.435883876812) | ||
| 126005 | 126005 | 60557 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 646 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20167 | 5985081.30797731 | 2111459.74994128 | 37.776802733932 | -122.495156735304 | (37.776802733932, -122.495156735304) | ||
| 126825 | 126825 | 58101 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 535 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29160 | 6004548.41463352 | 2110369.10321649 | 37.774928559979 | -122.427736418344 | (37.774928559979, -122.427736418344) | ||
| 127079 | 127079 | 31998 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 501#302 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | Permit Number 35397 | 5993950.60803177 | 2114839.47908066 | 37.7865978192777 | -122.464720892381 | (37.7865978192777, -122.464720892381) | ||
| 127438 | 127438 | 110180 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 321 Fair Oaks St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005492.60818902 | 2101839.04635751 | 37.7515604083348 | -122.423863569693 | (37.7515604083348, -122.423863569693) | ||||
| 127453 | 127453 | 94387 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 127914 | 127914 | 60604 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 526 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/17/1983 12:00:00 AM | Permit Number 20226 | 6000645.93118316 | 2110758.39288593 | 37.7757759257469 | -122.441263840373 | (37.7757759257469, -122.441263840373) | ||
| 128416 | 128416 | 60301 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 158 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2015 12:00:00 AM | 3 | Permit Number 775317 | 6004878.91046715 | 2099326.15693939 | 37.744625928835 | -122.425806967542 | (37.744625928835, -122.425806967542) | ||
| 138298 | 138298 | 63136 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 75 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23653 | 6007261.8048924 | 2099033.40342516 | 37.7439564645667 | -122.417546624418 | (37.7439564645667, -122.417546624418) | ||
| 138463 | 138463 | 63705 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1679 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1987 12:00:00 AM | Permit Number 24365 | 5994000.03328261 | 2104083.32941502 | 37.757067134665 | -122.463768902449 | (37.757067134665, -122.463768902449) | ||
| 139101 | 139101 | 32831 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 4259 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37188 | 6001527.35157379 | 2101718.97801883 | 37.7510060780925 | -122.437567299188 | (37.7510060780925, -122.437567299188) | ||
| 139675 | 139675 | 24063 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 21X Whitfield Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6017547.749564401 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | |||
| 139722 | 139722 | 68255 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 235 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32060 | 6009537.98073102 | 2093299.04188101 | 37.7283389564803 | -122.409271515047 | (37.7283389564803, -122.409271515047) | ||
| 139769 | 139769 | 63699 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1536 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/1987 12:00:00 AM | Permit Number 24357 | 5993400.20760956 | 2105023.79114259 | 37.7596148153145 | -122.465911644507 | (37.7596148153145, -122.465911644507) | ||
| 139868 | 139868 | 52193 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2050x Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1982 12:00:00 AM | 14 | Permit Number 48383 | 6003893.10220549 | 2115458.97047215 | 37.788866975157205 | -122.430366510079 | (37.7888669751572, -122.430366510079) | |
| 140807 | 140807 | 65605 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 138 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | Permit Number 28509 | 6004309.62922812 | 2093740.61229591 | 37.7292571013758 | -122.427377609436 | (37.7292571013758, -122.427377609436) | ||
| 140923 | 140923 | 11637 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 499X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 140949 | 140949 | 107852 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 150 APTOS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992855.9 | 2093940.6 | 37.7291517756313 | -122.466988351985 | (37.7291517756313, -122.466988351985) | ||||
| 141175 | 141175 | 61115 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1106 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1983 12:00:00 AM | Permit Number 20962 | 6007608.55332469 | 2103202.26724843 | 37.7554227286129 | -122.416642908427 | (37.7554227286129, -122.416642908427) | ||
| 141186 | 141186 | 61435 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 327 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/2003 12:00:00 AM | 26 | Permit Number 21367 | 5999764.1184147 | 2104644.81954389 | 37.7589393153031 | -122.44387490382499 | (37.7589393153031, -122.443874903825) | |
| 141990 | 141990 | 61657 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 162 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | Permit Number 21649 | 5993073.36079419 | 2114411.6730158003 | 37.785372566948 | -122.467724802862 | (37.785372566948, -122.467724802862) | ||
| 142109 | 142109 | 110178 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 321 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005492.60818902 | 2101839.04635751 | 37.7515604083348 | -122.423863569693 | (37.7515604083348, -122.423863569693) | ||||
| 142804 | 142804 | 32992 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 666 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.784438562575204 | -122.39822862272 | (37.7844385625752, -122.39822862272) | ||
| 142893 | 142893 | 32990 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 666 Folsom St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.784438562575204 | -122.39822862272 | (37.7844385625752, -122.39822862272) | ||
| 142936 | 142936 | 55768 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 64 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2006 12:00:00 AM | Permit Number 48893 | 6004070.72244185 | 2102685.02755706 | 37.7538029009663 | -122.428840933443 | (37.7538029009663, -122.428840933443) | ||
| 143352 | 143352 | 32991 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 666 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.784438562575204 | -122.39822862272 | (37.7844385625752, -122.39822862272) | ||
| 143481 | 143481 | 11367 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1351X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6017270.42563 | 2093912.097264 | 37.730452470679005 | -122.38258247713001 | (37.730452470679, -122.38258247713) | |||
| 143548 | 143548 | 53071 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 530@ CAPITOL Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2006 12:00:00 AM | Permit Number 49042 | 5995240.54795335 | 2090593.06935713 | 37.7200976112635 | -122.458502260031 | (37.7200976112635, -122.458502260031) | ||
| 143608 | 143608 | 94382 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 144319 | 144319 | 63123 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 44 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23636 | 6007712.34207152 | 2099218.71581656 | 37.7444906318459 | -122.416001886054 | (37.7444906318459, -122.416001886054) | ||
| 144476 | 144476 | 64980 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 50 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/24/1989 12:00:00 AM | Permit Number 26018 | 6005559.62367556 | 2099364.11059581 | 37.744768585112 | -122.42345589064699 | (37.744768585112, -122.423455890647) | ||
| 144684 | 144684 | 99975 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2295 Folsom St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | ||||
| 145237 | 145237 | 65550 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 292 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1990 12:00:00 AM | Permit Number 28449 | 5995404.07668865 | 2097513.82279858 | 37.7391097231572 | -122.458437696075 | (37.7391097231572, -122.458437696075) | ||
| 145422 | 145422 | 61359 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1234 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 3x3 | Permit Number 21268 | 6008775.22346441 | 2117343.22168335 | 37.7943160027564 | -122.413608310086 | (37.7943160027564, -122.413608310086) | ||
| 152160 | 152160 | 51577 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 584 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2005 12:00:00 AM | 28 | Permit Number 47871 | 5982583.51771 | 2111812.9357 | 37.7776259284617 | -122.50382336032 | (37.7776259284617, -122.50382336032) | |
| 156289 | 156289 | 54758 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 324 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/1972 12:00:00 AM | 8 | Permit Number 10607 | 6012398.45595 | 2086740.4083099999 | 37.710490116783 | -122.39892252845699 | (37.710490116783, -122.398922528457) | ||
| 160277 | 160277 | 66846 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 25 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | 14 | Permit Number 30150 | 5998189.80412132 | 2110576.56755949 | 37.7751364632784 | -122.449747058625 | (37.7751364632784, -122.449747058625) | |
| 165342 | 165342 | 62644 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1255 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50627 | 5983022.3246657 | 2106594.48040873 | 37.763323345885404 | -122.50191918393699 | (37.7633233458854, -122.501919183937) | |
| 170536 | 170536 | 32593 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1375 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 1 | Permit Number 37061 | 5985530.158172799 | 2105866.8789552 | 37.7614725555795 | -122.49319192882099 | (37.7614725555795, -122.493191928821) | |
| 1680 | 1680 | 251668 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 301x Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5995349.0 | 2100852.0 | 37.7482723626065 | -122.458869747183 | (37.7482723626065, -122.458869747183) | ||||
| 2761 | 2761 | 253204 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2253 09th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5993186.0 | 2100608.0 | 37.7474778324271 | -122.466331547971 | (37.7474778324271, -122.466331547971) | ||||
| 2763 | 2763 | 253205 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2253 09th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5993186.0 | 2100608.0 | 37.7474778324271 | -122.466331547971 | (37.7474778324271, -122.466331547971) | ||||
| 13294 | 13294 | 187652 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 46 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992908.0 | 2101735.0 | 37.750556241076204 | -122.467374782979 | (37.7505562410762, -122.467374782979) | ||||
| 15123 | 15123 | 116637 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2100 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 6011768.89448 | 2104683.8431599997 | 37.759723915951206 | -122.40235926517799 | (37.7597239159512, -122.402359265178) | ||
| 15480 | 15480 | 116639 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2100 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 6011723.51737 | 2104681.2870400003 | 37.7597143642338 | -122.402516023304 | (37.7597143642338, -122.402516023304) | ||
| 16694 | 16694 | 104424 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 917 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011907.00978 | 2104135.17777 | 37.7582251112167 | -122.401843021952 | (37.7582251112167, -122.401843021952) | |||
| 16837 | 16837 | 116638 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2100 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 6011745.2802099995 | 2104684.37435 | 37.75972405623921 | -122.402440973074 | (37.7597240562392, -122.402440973074) | ||
| 25099 | 25099 | 224199 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005272.32245 | 2097108.7115200001 | 37.738559550591795 | -122.42428894459299 | (37.7385595505918, -122.424288944593) | ||||
| 28658 | 28658 | 187032 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984967.607000001 | 2097835.0603 | 37.73938646460329 | -122.494545412715 | (37.7393864646033, -122.494545412715) | |||
| 29001 | 29001 | 137844 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1957 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003342.7396 | 2115504.846 | 37.7889617474845 | -122.43227396506398 | (37.7889617474845, -122.432273965064) | |||
| 31769 | 31769 | 224212 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6005187.142969999 | 2097371.8747799997 | 37.739277327390795 | -122.42460216947501 | (37.7392773273908, -122.424602169475) | ||||
| 32548 | 32548 | 244479 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 124 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005906.1302 | 2110197.2252 | 37.7745333330343 | -122.423027565946 | (37.7745333330343, -122.423027565946) | |||
| 34116 | 34116 | 224214 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6005180.62218 | 2097351.71746 | 37.73922161167361 | -122.424623281961 | (37.7392216116736, -122.424623281961) | ||||
| 35856 | 35856 | 142225 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 641 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6004777.6628 | 2110866.818 | 37.7763081284007 | -122.42697885578698 | (37.7763081284007, -122.426978855787) | |||
| 37917 | 37917 | 199398 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1027 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6013845.577380001 | 2089711.9694400001 | 37.718729970701396 | -122.394128826289 | (37.7187299707014, -122.394128826289) | ||||
| 39778 | 39778 | 122380 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 557 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005149.0 | 2111246.0 | 37.777370259808 | -122.42572129147301 | (37.777370259808, -122.425721291473) | |||
| 39821 | 39821 | 224196 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005192.428069999 | 2096936.6445 | 37.73808258165379 | -122.424552945066 | (37.7380825816538, -122.424552945066) | ||||
| 41295 | 41295 | 187029 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 0ft | 5984947.4301 | 2097843.1311 | 37.7394074439231 | -122.49461576933999 | (37.7394074439231, -122.49461576934) | |||
| 43878 | 43878 | 187030 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5984957.5185 | 2097843.1311 | 37.7394080343891 | -122.49458088860901 | (37.7394080343891, -122.494580888609) | |||
| 44361 | 44361 | 247091 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2301 Castro St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6002747.911280001 | 2098608.69961 | 37.7425353031757 | -122.43312428277099 | (37.7425353031757, -122.433124282771) | ||||
| 47306 | 47306 | 224452 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 57 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6003256.424219999 | 2095477.2065700002 | 37.7339657739995 | -122.43114253132099 | (37.7339657739995, -122.431142531321) | ||||
| 48344 | 48344 | 191716 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 561 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6011818.5901 | 2105765.65198 | 37.7626970962079 | -122.40226345320801 | (37.7626970962079, -122.402263453208) | |||
| 50324 | 50324 | 224208 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 66 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 8ft | 6005339.07699 | 2097371.10972 | 37.7392838060945 | -122.424076794516 | (37.7392838060945, -122.424076794516) | |||
| 53591 | 53591 | 113159 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 555 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005146.0 | 2111243.0 | 37.777361853017 | -122.425731455878 | (37.777361853017, -122.425731455878) | ||||
| 57509 | 57509 | 224451 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 56 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6003260.74151 | 2095484.4937599998 | 37.73398602761579 | -122.431128125086 | (37.7339860276158, -122.431128125086) | ||||
| 58693 | 58693 | 218793 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 616 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 5998053.08406 | 2095010.8668400003 | 37.7323890825862 | -122.449098408785 | (37.7323890825862, -122.449098408785) | |||
| 61013 | 61013 | 199410 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 822 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6015932.24155 | 2096672.73443 | 37.7379586091972 | -122.387401320018 | (37.7379586091972, -122.387401320018) | |||
| 62541 | 62541 | 224210 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6005362.146369999 | 2097481.1402 | 37.739587227456205 | -122.42400485326401 | (37.7395872274562, -122.424004853264) | ||||
| 62903 | 62903 | 224203 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003487.067319999 | 2095623.9761599998 | 37.734381837255505 | -122.430355595758 | (37.7343818372555, -122.430355595758) | ||||
| 63643 | 63643 | 224453 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 6003249.48151 | 2095473.62453 | 37.733955545103505 | -122.43116627879499 | (37.7339555451035, -122.431166278795) | ||||
| 67534 | 67534 | 121262 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 505 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005321.0 | 2111256.0 | 37.7774074352434 | -122.42512699851002 | (37.7774074352434, -122.42512699851) | |||
| 68584 | 68584 | 139748 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1330 Laguna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004640.4611 | 2113601.4606 | 37.783809022804206 | -122.427648355277 | (37.7838090228042, -122.427648355277) | |||
| 69429 | 69429 | 224202 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6003508.627309999 | 2095617.8291 | 37.7343661800531 | -122.430280617458 | (37.7343661800531, -122.430280617458) | ||||
| 71049 | 71049 | 224216 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005148.6559 | 2097255.3705700003 | 37.73895525948029 | -122.424726954897 | (37.7389552594803, -122.424726954897) | ||||
| 72098 | 72098 | 187038 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984961.8902 | 2097789.6624 | 37.7392614795793 | -122.494561832752 | (37.7392614795793, -122.494561832752) | |||
| 72865 | 72865 | 224450 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 55 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6003275.39086 | 2095494.7434599998 | 37.7340150010873 | -122.431078209119 | (37.7340150010873, -122.431078209119) | ||||
| 78083 | 78083 | 113326 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 237 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004215.8 | 2097159.4 | 37.7386390150291 | -122.427945503988 | (37.7386390150291, -122.427945503988) | ||||
| 78473 | 78473 | 105080 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 3770 24TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x4 | 6004633.1 | 2101955.7 | 37.7518321521274 | -122.426844164794 | (37.7518321521274, -122.426844164794) | |||
| 81756 | 81756 | 97781 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 249 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | strip | 5992441.6 | 2097612.4 | 37.7392096976829 | -122.468687674985 | (37.7392096976829, -122.468687674985) |
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");