Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189130 | 189130 | 227619 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1193 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008092.35309 | 2100991.6752 | 37.7493801403813 | -122.414813334067 | (37.7493801403813, -122.414813334067) | |||
| 189123 | 189123 | 84613 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2029-22031 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50833 | 6000517.3597800005 | 2120966.99196 | 37.8037987541811 | -122.442441679147 | (37.8037987541811, -122.442441679147) | |
| 188902 | 188902 | 182960 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1901 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5990064.3236 | 2098390.6107 | 37.741208843809794 | -122.47696398819299 | (37.7412088438098, -122.476963988193) | |||
| 188877 | 188877 | 191318 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015134.48609 | 2108114.99928 | 37.7693324264746 | -122.39095906320499 | (37.7693324264746, -122.390959063205) | |||
| 188601 | 188601 | 37092 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1422 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39692 | 5981562.80857566 | 2105390.4854708 | 37.7599316756927 | -122.506877772277 | (37.7599316756927, -122.506877772277) | |
| 188401 | 188401 | 207079 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 59 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5992173.18035 | 2088300.4585900002 | 37.7136258989769 | -122.46893826428699 | (37.7136258989769, -122.468938264287) | ||||
| 187960 | 187960 | 227595 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501 14th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005359.22331 | 2107799.65504 | 37.7679193064505 | -122.424748826411 | (37.7679193064505, -122.424748826411) | |||
| 187926 | 187926 | 176923 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 298 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003940.88243 | 2089479.82592 | 37.7175370613599 | -122.42834884222201 | (37.7175370613599, -122.428348842222) | |||
| 187479 | 187479 | 227589 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 23 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006036.6609 | 2100222.07218 | 37.7471512660344 | -122.42186731675 | (37.7471512660344, -122.42186731675) | |||
| 187273 | 187273 | 176963 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 83 Badger St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 6002428.97482 | 2094295.2581 | 37.7306734890866 | -122.43391881851299 | (37.7306734890866, -122.433918818513) | |||
| 187192 | 187192 | 246314 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6006868.6018 | 2109014.4469 | 37.7713399704187 | -122.419614246796 | (37.7713399704187, -122.419614246796) | |||
| 187174 | 187174 | 122008 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2650 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990390.42893 | 2112003.07059 | 37.7786039357458 | -122.476830795247 | (37.7786039357458, -122.476830795247) | |||
| 186617 | 186617 | 176959 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 228 Hester Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012551.8348 | 2087659.68415 | 37.7130228118314 | -122.398456876593 | (37.7130228118314, -122.398456876593) | |||
| 186532 | 186532 | 191339 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015062.12286 | 2108415.00786 | 37.7701521684295 | -122.391230340108 | (37.7701521684295, -122.391230340108) | |||
| 186507 | 186507 | 227658 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001589.01566 | 2106181.9491 | 37.763263822894295 | -122.437673651738 | (37.7632638228943, -122.437673651738) | |||
| 186485 | 186485 | 207063 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993031.18209 | 2099190.3171200003 | 37.7435763017135 | -122.46676385469401 | (37.7435763017135, -122.466763854694) | |||
| 186402 | 186402 | 227647 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999980.75729 | 2104959.09552 | 37.7598145945821 | -122.44314823869499 | (37.7598145945821, -122.443148238695) | |||
| 186363 | 186363 | 129407 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2033 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001882.3909599995 | 2115581.31929 | 37.789088813243396 | -122.437332045161 | (37.7890888132434, -122.437332045161) | |||
| 186133 | 186133 | 129431 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6004108.39045 | 2116309.70837 | 37.7912150785667 | -122.42968234348301 | (37.7912150785667, -122.429682343483) | |||
| 185179 | 185179 | 61519 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1161 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1984 12:00:00 AM | 7 | Permit Number 21475 | 6007368.68612 | 2119491.86468 | 37.8001365583177 | -122.418627544125 | (37.8001365583177, -122.418627544125) | ||
| 184974 | 184974 | 42710 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1600 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53744 | 6005271.11771 | 2118900.89126 | 37.7983955805457 | -122.42584385893 | (37.7983955805457, -122.42584385893) |
| 184877 | 184877 | 31769 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990271.0654 | 2098396.6732 | 37.7412374811669 | -122.476249599037 | (37.7412374811669, -122.476249599037) | ||
| 184634 | 184634 | 227630 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 10 Arbor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002176.820309999 | 2096986.40745 | 37.7380484541639 | -122.43498294671998 | (37.7380484541639, -122.43498294672) | |||
| 184598 | 184598 | 207080 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1648 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992494.37113 | 2104224.8500200002 | 37.75736883521821 | -122.46898630879299 | (37.7573688352182, -122.468986308793) | |||
| 184585 | 184585 | 56604 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1914 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 5999483.43623 | 2115589.8774599996 | 37.788975642546 | -122.445632707581 | (37.788975642546, -122.445632707581) | ||||
| 184446 | 184446 | 142580 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 650 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6008660.8 | 2120758.6253 | 37.8036874273397 | -122.414245990591 | (37.8036874273397, -122.414245990591) | |||
| 184382 | 184382 | 227607 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 61 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004513.177130001 | 2096122.0643 | 37.735807545078295 | -122.426843458979 | (37.7358075450783, -122.426843458979) | ||||
| 184290 | 184290 | 227618 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 119 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009077.3937800005 | 2097965.31988 | 37.7411257345706 | -122.411193275964 | (37.7411257345706, -122.411193275964) | |||
| 184269 | 184269 | 227602 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 54 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004494.61967 | 2096104.27773 | 37.735757657887994 | -122.426906353066 | (37.735757657888, -122.426906353066) | ||||
| 183981 | 183981 | 191314 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015140.28305 | 2108016.70866 | 37.7690628636861 | -122.390932141124 | (37.7690628636861, -122.390932141124) | |||
| 183903 | 183903 | 176947 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 39 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012433.06951 | 2087793.9478900002 | 37.713384856409 | -122.398876788934 | (37.713384856409, -122.398876788934) | |||
| 183793 | 183793 | 207061 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993037.74509 | 2099188.24411 | 37.7435709885186 | -122.466741010989 | (37.7435709885186, -122.466741010989) | |||
| 183467 | 183467 | 207095 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1565 Plymouth Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995634.15192 | 2094407.3594099998 | 37.730593351393296 | -122.457417521726 | (37.7305933513933, -122.457417521726) | |||
| 183459 | 183459 | 207081 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1967 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992237.024130001 | 2102091.85973 | 37.751497327037605 | -122.46972102612601 | (37.7514973270376, -122.469721026126) | |||
| 183393 | 183393 | 50456 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 993 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 6 | Permit Number 47101 | 6015538.43851 | 2104592.1377 | 37.7596818177679 | -122.38931576171001 | (37.7596818177679, -122.38931576171) | ||
| 183006 | 183006 | 129410 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2199 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003271.2174 | 2116075.89812 | 37.7905256555748 | -122.43256222807301 | (37.7905256555748, -122.432562228073) | |||
| 182969 | 182969 | 48451 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5995956.24653 | 2113838.6701 | 37.783965291128204 | -122.457709472605 | (37.7839652911282, -122.457709472605) | ||
| 182745 | 182745 | 114221 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 28 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6012377.24762 | 2087856.00195 | 37.7135521339029 | -122.39907408311599 | (37.7135521339029, -122.399074083116) | |||
| 182608 | 182608 | 191309 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015155.3814900005 | 2107742.43002 | 37.768310592479 | -122.390860744836 | (37.768310592479, -122.390860744836) | |||
| 182528 | 182528 | 176929 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 110 Hester Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012755.76956 | 2087791.93581 | 37.7133973075252 | -122.397761276185 | (37.7133973075252, -122.397761276185) | |||
| 182481 | 182481 | 129436 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010030.57511 | 2115756.25526 | 37.7900289879055 | -122.409152593735 | (37.7900289879055, -122.409152593735) | |||
| 182340 | 182340 | 207075 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5994498.162330001 | 2100407.0553599996 | 37.7470017132656 | -122.461779641027 | (37.7470017132656, -122.461779641027) | |||
| 182154 | 182154 | 207098 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Mangels Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6000468.8354 | 2095254.59465 | 37.733196173744105 | -122.440764091915 | (37.7331961737441, -122.440764091915) | ||||
| 182098 | 182098 | 227599 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3542 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005268.27661 | 2106072.0060799997 | 37.7631704570704 | -122.424940469222 | (37.7631704570704, -122.424940469222) | |||
| 182025 | 182025 | 200099 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015044.482999999 | 2092374.4958 | 37.7261073063636 | -122.390170565448 | (37.7261073063636, -122.390170565448) | |||
| 181896 | 181896 | 176977 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6002472.369080001 | 2086850.07188 | 37.710233128335396 | -122.433237015483 | (37.7102331283354, -122.433237015483) | |||
| 181722 | 181722 | 176935 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 38 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6012462.52056 | 2087802.51935 | 37.7134100329326 | -122.398775596322 | (37.7134100329326, -122.398775596322) | |||
| 181554 | 181554 | 191329 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015112.65717 | 2108516.8034 | 37.7704344808868 | -122.39106265703501 | (37.7704344808868, -122.391062657035) | |||
| 180507 | 180507 | 191300 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015176.682999999 | 2107358.12451 | 37.767256555574 | -122.39076020421699 | (37.767256555574, -122.390760204217) | |||
| 180480 | 180480 | 143382 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1600 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6005275.1713 | 2118900.2974 | 37.798394179030794 | -122.425829789965 | (37.7983941790308, -122.425829789965) | |||
| 180428 | 180428 | 191337 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015057.64715 | 2108462.45276 | 37.7702821932842 | -122.39124913866002 | (37.7702821932842, -122.39124913866) | |||
| 180047 | 180047 | 35838 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 524 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 6 | Permit Number 39065 | 6001524.77874 | 2090714.46307 | 37.7207900854698 | -122.436788524592 | (37.7207900854698, -122.436788524592) | |
| 179940 | 179940 | 227644 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3801 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003004.720380001 | 2103560.48994 | 37.756146319318496 | -122.43258993978901 | (37.7561463193185, -122.432589939789) | |||
| 179903 | 179903 | 191289 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014403.282380001 | 2110504.70975 | 37.7758534385095 | -122.393655562567 | (37.7758534385095, -122.393655562567) | |||
| 179838 | 179838 | 191331 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1108 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014830.54088 | 2110082.99883 | 37.77471924682621 | -122.392148055082 | (37.7747192468262, -122.392148055082) | |||
| 179818 | 179818 | 191317 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015134.8576 | 2108090.59219 | 37.769265430583296 | -122.39095607208401 | (37.7692654305833, -122.390956072084) | |||
| 179336 | 179336 | 82943 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52427 | 6009392.50715 | 2110510.5860099997 | 37.7755898643032 | -122.410989600209 | (37.7755898643032, -122.410989600209) | |
| 179315 | 179315 | 176955 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 95 Lois Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012720.393999999 | 2087742.5814099999 | 37.7132598200564 | -122.397880087391 | (37.7132598200564, -122.397880087391) | |||
| 178956 | 178956 | 176921 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002409.56015 | 2089503.5863700002 | 37.717515532482096 | -122.43364361428301 | (37.7175155324821, -122.433643614283) | |||
| 178509 | 178509 | 106106 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 708 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6011765.54028 | 2117816.6633 | 37.7957834196109 | -122.403294730072 | (37.7957834196109, -122.403294730072) | ||||
| 178480 | 178480 | 119541 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 823 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5986627.47166 | 2110288.5169900004 | 37.773677258601 | -122.48972200943399 | (37.773677258601, -122.489722009434) | |||
| 178335 | 178335 | 191275 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014152.76855 | 2110885.05471 | 37.7768838565355 | -122.394548799799 | (37.7768838565355, -122.394548799799) | |||
| 178278 | 178278 | 191323 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015122.4628099995 | 2108363.5556 | 37.7700142403001 | -122.391018026356 | (37.7700142403001, -122.391018026356) | |||
| 178142 | 178142 | 207065 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Taraval St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993024.9505900005 | 2099189.6741400003 | 37.743574176615894 | -122.46678535477301 | (37.7435741766159, -122.466785354773) | |||
| 178008 | 178008 | 129422 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6003322.87221 | 2117886.8736900003 | 37.7955010594859 | -122.432512912861 | (37.7955010594859, -122.432512912861) | |||
| 177608 | 177608 | 191346 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015085.76507 | 2107965.02098 | 37.768917915461294 | -122.391117103785 | (37.7689179154613, -122.391117103785) | |||
| 177487 | 177487 | 176949 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 59 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012531.85348 | 2087734.51235 | 37.7132271620641 | -122.39853118666201 | (37.7132271620641, -122.398531186662) | |||
| 177184 | 177184 | 191261 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Wisconsin St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6012675.54577 | 2104288.99957 | 37.7586903323146 | -122.399195870217 | (37.7586903323146, -122.399195870217) | |||
| 177180 | 177180 | 176930 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 78 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012665.081590001 | 2087756.9566900001 | 37.7132962111247 | -122.39807227523501 | (37.7132962111247, -122.398072275235) | |||
| 177153 | 177153 | 191286 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 720 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014348.90708 | 2110556.6159200002 | 37.7759929395558 | -122.39384729623801 | (37.7759929395558, -122.393847296238) | |||
| 177023 | 177023 | 191256 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1901 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011633.048719999 | 2106495.6595400004 | 37.764691174667796 | -122.402956525646 | (37.7646911746678, -122.402956525646) | |||
| 176903 | 176903 | 129458 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 731 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012131.08094 | 2118327.87745 | 37.7972074996935 | -122.40206584156401 | (37.7972074996935, -122.402065841564) | |||
| 176799 | 176799 | 182968 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2501 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5990431.4773 | 2098333.0499 | 37.7410720891089 | -122.475690312642 | (37.7410720891089, -122.475690312642) | |||
| 176769 | 176769 | 191254 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1901 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011532.07084 | 2106491.2007 | 37.7646732925511 | -122.40330546976601 | (37.7646732925511, -122.403305469766) | |||
| 176691 | 176691 | 75284 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1335 Griffith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 3 | 6017835.3471 | 2092484.583 | 37.7265639860027 | -122.380530259866 | (37.7265639860027, -122.380530259866) | ||
| 176268 | 176268 | 200103 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014982.2186 | 2092417.8102 | 37.72622278535071 | -122.390388836652 | (37.7262227853507, -122.390388836652) | |||
| 176194 | 176194 | 187582 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 747 University St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6008739.08909 | 2090759.6184900003 | 37.7213214463175 | -122.41185395930799 | (37.7213214463175, -122.411853959308) | ||||
| 175752 | 175752 | 183581 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2614 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988348.717 | 2097504.9177 | 37.738677287922 | -122.48283097892299 | (37.738677287922, -122.482830978923) | |||
| 175672 | 175672 | 191260 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1058 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6012165.085 | 2103460.39568 | 37.7563867072014 | -122.400903071241 | (37.7563867072014, -122.400903071241) | |||
| 175622 | 175622 | 37630 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 546 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 4 | Permit Number 40048 | 5990347.694519999 | 2111641.30179 | 37.777608139525 | -122.476952187306 | (37.777608139525, -122.476952187306) | |
| 175597 | 175597 | 207073 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994505.45248 | 2100370.5542599997 | 37.746901910105 | -122.46175178633601 | (37.746901910105, -122.461751786336) | |||
| 175556 | 175556 | 30703 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 361 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 2 | Permit Number 34614 | 6005258.9715 | 2110239.8029 | 37.7746137012839 | -122.425269246 | (37.7746137012839, -122.425269246) | |
| 175198 | 175198 | 207091 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 520 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991320.331130001 | 2097065.30066 | 37.7376426638631 | -122.47252460501998 | (37.7376426638631, -122.47252460502) | |||
| 174716 | 174716 | 227591 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 27 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6005552.79952 | 2098729.9467700003 | 37.743026930158294 | -122.423434412384 | (37.7430269301583, -122.423434412384) | |||
| 174454 | 174454 | 227588 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 435 Oak St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004887.16184 | 2110182.76224 | 37.77443606920671 | -122.42655134748001 | (37.7744360692067, -122.42655134748) | |||
| 174307 | 174307 | 31774 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 0 | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | |
| 174066 | 174066 | 176973 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 82 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008143.29471 | 2093583.4510299999 | 37.729041645841896 | -122.414113135409 | (37.7290416458419, -122.414113135409) | |||
| 174040 | 174040 | 191338 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015059.91247 | 2108440.08294 | 37.770220896405704 | -122.39123973893899 | (37.7702208964057, -122.391239738939) | |||
| 173859 | 173859 | 191343 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015066.17772 | 2108313.11356 | 37.769872614151396 | -122.39120919074499 | (37.7698726141514, -122.391209190745) | |||
| 173789 | 173789 | 227596 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 501 14th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005369.47041 | 2107799.69843 | 37.7679200043356 | -122.424713385909 | (37.7679200043356, -122.424713385909) | |||
| 173778 | 173778 | 71255 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1392 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 1 | 6007494.44606 | 2117816.87319 | 37.795544530015604 | -122.418073553678 | (37.7955445300156, -122.418073553678) | ||
| 173661 | 173661 | 191249 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2300 18th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 10ft | 6010915.57021 | 2105542.63703 | 37.7620342994705 | -122.405370986778 | (37.7620342994705, -122.405370986778) | |||
| 173580 | 173580 | 176972 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 161 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008005.59306 | 2093164.83572 | 37.7278844827614 | -122.41455957148399 | (37.7278844827614, -122.414559571484) | |||
| 173577 | 173577 | 191280 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014475.48285 | 2110565.8320299997 | 37.776025278288294 | -122.393410079138 | (37.7760252782883, -122.393410079138) | |||
| 173431 | 173431 | 191284 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 751 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014408.26812 | 2110636.4725 | 37.7762155064684 | -122.39364753972201 | (37.7762155064684, -122.393647539722) | |||
| 173107 | 173107 | 54086 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2405 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1972 12:00:00 AM | 7 | Permit Number 9810 | 6003110.67405 | 2116498.63256 | 37.791677270739896 | -122.433147915142 | (37.7916772707399, -122.433147915142) | ||
| 172614 | 172614 | 244059 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1652 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998660.6331 | 2109020.8428 | 37.7708917674934 | -122.44800632768299 | (37.7708917674934, -122.448006327683) | |||
| 172600 | 172600 | 191327 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015115.08625 | 2108468.00525 | 37.770300626710295 | -122.391050843517 | (37.7703006267103, -122.391050843517) | |||
| 172429 | 172429 | 176940 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 15 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6012273.467119999 | 2087900.15525 | 37.7136675861685 | -122.399435885762 | (37.7136675861685, -122.399435885762) | |||
| 172420 | 172420 | 200111 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1552 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014807.6076 | 2092549.7837 | 37.726575470666106 | -122.39100168241998 | (37.7265754706661, -122.39100168242) |
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");