Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19227 | 19227 | 5445 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 500X Dolores St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/20/1990 12:00:00 AM | 8 | 6 | 6004913.51654 | 2104964.38719 | 37.76010915314279 | -122.426088611215 | (37.7601091531428, -122.426088611215) | ||
| 19361 | 19361 | 5439 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 500X Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/01/1990 12:00:00 AM | 45 | 6 | 6004897.2550099995 | 2105174.4218599997 | 37.7606849395651 | -122.426159805147 | (37.7606849395651, -122.426159805147) | ||
| 19611 | 19611 | 5725 | DPW Maintained 3 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 1676 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 6005265.5295 | 2098569.21573 | 37.7425693811872 | -122.424416284994 | (37.7425693811872, -122.424416284994) | |||
| 20102 | 20102 | 5373 | DPW Maintained 3 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 267 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6004889.68559 | 2106830.22133 | 37.7652309432866 | -122.426303875628 | (37.7652309432866, -122.426303875628) | |||
| 20946 | 20946 | 5453 | DPW Maintained 3 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 553 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 6X6 | 6004986.22513 | 2105148.12108 | 37.7606177521254 | -122.42585022520399 | (37.7606177521254, -122.425850225204) | |||
| 23094 | 23094 | 4414 | DPW Maintained 3 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 1117 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/1992 12:00:00 AM | 4 | 1X1 | 6004464.79166 | 2102375.2261799998 | 37.7529745552411 | -122.42745608254299 | (37.7529745552411, -122.427456082543) | ||
| 36860 | 36860 | 227529 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 4297 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001280.54465 | 2102294.52512 | 37.752572356836204 | -122.438462011837 | (37.7525723568362, -122.438462011837) | |||
| 40880 | 40880 | 227528 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 18 Worth St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6000854.651000001 | 2103166.63578 | 37.7549427269363 | -122.439997349707 | (37.7549427269363, -122.439997349707) | |||
| 44620 | 44620 | 32238 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 800 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 1 | Permit Number 35555 | 6009122.52689 | 2090393.35811 | 37.7203372759166 | -122.410502667675 | (37.7203372759166, -122.410502667675) | ||
| 48892 | 48892 | 129682 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 2222 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5999361.98488 | 2116489.3764299997 | 37.791438495331796 | -122.446117638238 | (37.7914384953318, -122.446117638238) | |||
| 51646 | 51646 | 227523 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 3450 26th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6006737.2033 | 2100885.725 | 37.7490129885555 | -122.419491968004 | (37.7490129885555, -122.419491968004) | |||
| 54138 | 54138 | 66230 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 122 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29327 | 5994183.35951866 | 2090739.39799628 | 37.7204385809106 | -122.462167182155 | (37.7204385809106, -122.462167182155) | ||
| 59816 | 59816 | 227534 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 310 Liberty St | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 6004116.82698 | 2103937.8336 | 37.757245420345896 | -122.428770797837 | (37.7572454203459, -122.428770797837) | |||
| 60888 | 60888 | 227533 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 202 Hartford St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002683.27293 | 2104635.8349599997 | 37.759080724411504 | -122.43377846851999 | (37.7590807244115, -122.43377846852) | |||
| 66484 | 66484 | 227532 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 202 Hartford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002679.72985 | 2104658.05028 | 37.759141521284796 | -122.433792309982 | (37.7591415212848, -122.433792309982) | |||
| 67102 | 67102 | 227531 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 202 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002677.00253 | 2104676.70583 | 37.75919259017461 | -122.433803075747 | (37.7591925901746, -122.433803075747) | |||
| 73319 | 73319 | 227525 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 705 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001257.1165 | 2102241.08377 | 37.7524242870632 | -122.438539201525 | (37.7524242870632, -122.438539201525) | |||
| 77550 | 77550 | 68571 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 680 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32462 | 5981371.58179768 | 2111111.81123309 | 37.775629511649704 | -122.50796373535499 | (37.7756295116497, -122.507963735355) | ||
| 77986 | 77986 | 84039 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 1117-1119 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | Permit Number 50428 | 6004461.93276532 | 2102391.33206178 | 37.753018616529005 | -122.427467116446 | (37.753018616529, -122.427467116446) | |||
| 78856 | 78856 | 65742 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 156 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | Permit Number 28679 | 5999815.09781742 | 2087341.70418364 | 37.7114319377923 | -122.442456329735 | (37.7114319377923, -122.442456329735) | ||
| 79663 | 79663 | 55504 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 869 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/1992 12:00:00 AM | Permit Number 27152 | 6001313.84664035 | 2101330.48409718 | 37.7499272254089 | -122.438277790254 | (37.7499272254089, -122.438277790254) | ||
| 80720 | 80720 | 65912 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 1319 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28921 | 5994225.84250459 | 2106529.43291316 | 37.7637965106849 | -122.46316545767401 | (37.7637965106849, -122.463165457674) | ||
| 81051 | 81051 | 58468 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 731 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1997 12:00:00 AM | Permit Number 32215 | 5998538.83594579 | 2108065.94626606 | 37.7682629016755 | -122.448358849843 | (37.7682629016755, -122.448358849843) | ||
| 81126 | 81126 | 62266 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 107 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1994 12:00:00 AM | Permit Number 28558 | 6003332.16344898 | 2108632.83425409 | 37.770092317262296 | -122.43181968917801 | (37.7700923172623, -122.431819689178) | ||
| 82232 | 82232 | 62510 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 40 Worth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1986 12:00:00 AM | Permit Number 22686 | 6000851.23665541 | 2103119.64379278 | 37.754813503958104 | -122.440005788129 | (37.7548135039581, -122.440005788129) | ||
| 82696 | 82696 | 84103 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 4297 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50420 | 6001255.77068266 | 2102291.23804397 | 37.75256192209 | -122.438547448801 | (37.75256192209, -122.438547448801) | ||
| 83409 | 83409 | 84102 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 4297 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50420 | 6001255.77068266 | 2102291.23804397 | 37.75256192209 | -122.438547448801 | (37.75256192209, -122.438547448801) | ||
| 83516 | 83516 | 63253 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 347 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/1987 12:00:00 AM | Permit Number 23805 | 6006558.34152348 | 2104089.11498703 | 37.7577986856169 | -122.420337810485 | (37.7577986856169, -122.420337810485) | ||
| 85787 | 85787 | 67819 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 132 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31475 | 6004088.24128484 | 2102368.84156133 | 37.7529357200137 | -122.428757810552 | (37.7529357200137, -122.428757810552) | ||
| 86656 | 86656 | 65743 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 161 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | Permit Number 28700 | 5999869.91209267 | 2087340.5824876 | 37.7114319821081 | -122.442266797514 | (37.7114319821081, -122.442266797514) | ||
| 86978 | 86978 | 65741 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 150 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | Permit Number 28678 | 5999807.34647383 | 2087366.58605487 | 37.711499816004896 | -122.442484905562 | (37.7114998160049, -122.442484905562) | ||
| 87095 | 87095 | 53681 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 3676 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1989 12:00:00 AM | 12 | 7x9 | Permit Number 28114 | 6005126.00914316 | 2104896.86340653 | 37.7599357563315 | -122.42534889488701 | (37.7599357563315, -122.425348894887) | |
| 88727 | 88727 | 48403 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 137 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2002 12:00:00 AM | Permit Number 45784 | 5999838.90671346 | 2087440.10998802 | 37.7117034951385 | -122.442381100461 | (37.7117034951385, -122.442381100461) | ||
| 88991 | 88991 | 39790 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 50 San Jose Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/1999 12:00:00 AM | Permit Number 41142 | 6006177.81610853 | 2102875.29261487 | 37.7544443606741 | -122.42156762045201 | (37.7544443606741, -122.421567620452) | ||
| 89353 | 89353 | 67953 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 587 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31669 | 5988423.51616993 | 2112003.2558784 | 37.778490152422705 | -122.483635032376 | (37.7784901524227, -122.483635032376) | ||
| 90261 | 90261 | 66576 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 183 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | Permit Number 29766 | 6004051.78498145 | 2092614.17435811 | 37.7261495673942 | -122.42818875391501 | (37.7261495673942, -122.428188753915) | ||
| 91630 | 91630 | 63800 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 98 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1997 12:00:00 AM | Permit Number 30485 | 6009121.91960633 | 2096902.39222229 | 37.7382096636994 | -122.41096426405198 | (37.7382096636994, -122.410964264052) | ||
| 91872 | 91872 | 65740 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 131 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | Permit Number 28676 | 5999831.15536745 | 2087464.99186701 | 37.7117713733875 | -122.44240967633301 | (37.7117713733875, -122.442409676333) | ||
| 92587 | 92587 | 64486 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 1760 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | Permit Number 25361 | 6009183.88964129 | 2119335.0439705 | 37.799807995554296 | -122.41233512381599 | (37.7998079955543, -122.412335123816) | ||
| 93659 | 93659 | 64791 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 235 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | Permit Number 25787 | 6002748.20782442 | 2109342.92244592 | 37.7720089245306 | -122.43389034537701 | (37.7720089245306, -122.433890345377) | ||
| 93770 | 93770 | 66929 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 175 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1992 12:00:00 AM | Permit Number 31181 | 6007601.16481288 | 2097856.63104946 | 37.7407443985359 | -122.41628986145399 | (37.7407443985359, -122.416289861454) | ||
| 96491 | 96491 | 82868 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 229- 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52430 | 6009387.0 | 2110633.0 | 37.775925675553296 | -122.411017299189 | (37.7759256755533, -122.411017299189) | ||
| 97004 | 97004 | 68388 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 4977 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 15 | Permit Number 32213 | 5997544.8295208 | 2105597.02046098 | 37.7614269792514 | -122.451618890925 | (37.7614269792514, -122.451618890925) | |
| 97286 | 97286 | 100307 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 202X Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52417 | 6002676.8 | 2104706.1 | 37.7592732879998 | -122.43380587713499 | (37.7592732879998, -122.433805877135) | |||
| 97419 | 97419 | 82958 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 35 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50805 | 6000912.41841684 | 2104895.69025966 | 37.7596935780473 | -122.439921541658 | (37.7596935780473, -122.439921541658) | ||
| 97556 | 97556 | 65252 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 992 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28051 | 6009395.74802139 | 2103403.69283522 | 37.7560761510907 | -122.41047644187 | (37.7560761510907, -122.41047644187) | ||
| 99274 | 99274 | 58827 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 761 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 18081 | 5998566.09450379 | 2107870.66513368 | 37.767728267607204 | -122.448250501912 | (37.7677282676072, -122.448250501912) | ||
| 101282 | 101282 | 100308 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 202X Hartford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52417 | 6002676.8 | 2104706.1 | 37.7592732879998 | -122.43380587713499 | (37.7592732879998, -122.433805877135) | |||
| 105279 | 105279 | 59346 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 526 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1996 12:00:00 AM | Permit Number 18694 | 6000169.01235763 | 2110692.10451001 | 37.7755667359424 | -122.44290885654499 | (37.7755667359424, -122.442908856545) | ||
| 106085 | 106085 | 59580 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 157 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/1981 12:00:00 AM | Permit Number 18972 | 6004144.08144051 | 2102300.97252485 | 37.752752527797206 | -122.42855986736 | (37.7527525277972, -122.42855986736) | ||
| 106185 | 106185 | 62512 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 47 Worth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1986 12:00:00 AM | Permit Number 22688 | 6000904.62792341 | 2103094.84013439 | 37.7547484383972 | -122.43981936856501 | (37.7547484383972, -122.439819368565) | ||
| 107514 | 107514 | 59007 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 3731 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1993 12:00:00 AM | Permit Number 29743 | 6005443.80886724 | 2104276.22523779 | 37.75824957931761 | -122.42420563843099 | (37.7582495793176, -122.424205638431) | ||
| 109117 | 109117 | 62513 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 48 Worth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1986 12:00:00 AM | Permit Number 22689 | 6000852.895877 | 2103088.41664199 | 37.7547278562227 | -122.43999781112801 | (37.7547278562227, -122.439997811128) | ||
| 109186 | 109186 | 65358 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 123 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1989 12:00:00 AM | Permit Number 28193 | 6001809.60745082 | 2096649.18793885 | 37.737101670399205 | -122.43622845577299 | (37.7371016703992, -122.436228455773) | ||
| 109359 | 109359 | 67336 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 616 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1992 12:00:00 AM | Permit Number 30820 | 5993805.86166428 | 2111291.38109791 | 37.7768473564115 | -122.46496389539301 | (37.7768473564115, -122.464963895393) | ||
| 110410 | 110410 | 68802 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 39 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32743 | 5993216.60176137 | 2098854.68485021 | 37.7426654396593 | -122.46609833981 | (37.7426654396593, -122.46609833981) | ||
| 110756 | 110756 | 68572 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 685 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32463 | 5981320.71250249 | 2111079.78815826 | 37.7755385883149 | -122.508137324272 | (37.7755385883149, -122.508137324272) | ||
| 114358 | 114358 | 81485 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 1268 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50894 | 5994575.83487134 | 2106890.23144341 | 37.764807325258005 | -122.46198111515 | (37.764807325258, -122.46198111515) | ||
| 114423 | 114423 | 83293 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 25 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50806 | 6000965.01829306 | 2104898.82090875 | 37.759705168142396 | -122.43973984968201 | (37.7597051681424, -122.439739849682) | ||
| 115001 | 115001 | 33035 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 494 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50595 | 6006779.65662971 | 2100908.40918731 | 37.7490776652966 | -122.41934677281 | (37.7490776652966, -122.41934677281) | ||
| 115863 | 115863 | 106776 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 202X Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | Permit Number 769790 | 6002676.8 | 2104706.1 | 37.7592732879998 | -122.43380587713499 | (37.7592732879998, -122.433805877135) | ||
| 116338 | 116338 | 65699 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 201 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/1990 12:00:00 AM | Permit Number 28628 | 6000097.30491035 | 2087663.87118265 | 37.7123326179359 | -122.441504055389 | (37.7123326179359, -122.441504055389) | ||
| 116552 | 116552 | 68390 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 751 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32217 | 5998557.00831722 | 2107935.75884853 | 37.767906478991 | -122.448286617718 | (37.767906478991, -122.448286617718) | ||
| 120655 | 120655 | 67695 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 64 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1995 12:00:00 AM | Permit Number 32214 | 5998556.66816134 | 2105411.31929459 | 37.7609749843529 | -122.44810600505699 | (37.7609749843529, -122.448106005057) | ||
| 121071 | 121071 | 41375 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 174 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2000 12:00:00 AM | Permit Number 42012 | 5999838.35184821 | 2087267.05856995 | 37.7112283031088 | -122.44237060256701 | (37.7112283031088, -122.442370602567) | ||
| 122765 | 122765 | 60827 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 4248 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 25330 | 6001569.00146643 | 2102360.55614987 | 37.752770066010704 | -122.437469208461 | (37.7527700660107, -122.437469208461) | ||
| 123573 | 123573 | 53770 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 316 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1996 12:00:00 AM | Permit Number 9456 | 5992852.04223281 | 2094739.01017834 | 37.7313437896565 | -122.46705971241 | (37.7313437896565, -122.46705971241) | ||
| 124172 | 124172 | 63971 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 464 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/1987 12:00:00 AM | 6002138.24458134 | 2101514.59186962 | 37.7504795961936 | -122.435440154372 | (37.7504795961936, -122.435440154372) | |||
| 124618 | 124618 | 82867 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 243-245 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52430 | 6009431.77507071 | 2110559.3179918 | 37.775725872790204 | -122.410857204902 | (37.7757258727902, -122.410857204902) | ||
| 124772 | 124772 | 63278 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 359 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23839 | 6006562.57447992 | 2104022.1319099 | 37.7576150041382 | -122.42031841700899 | (37.7576150041382, -122.420318417009) | ||
| 124956 | 124956 | 62511 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 45 Worth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1986 12:00:00 AM | Permit Number 22687 | 6000904.22158412 | 2103102.48758677 | 37.7547694133198 | -122.43982132206101 | (37.7547694133198, -122.439821322061) | ||
| 128174 | 128174 | 58473 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 755 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 5x4 | Permit Number 32218 | 5998560.64278981 | 2107909.72137719 | 37.767835194479396 | -122.448272171383 | (37.7678351944794, -122.448272171383) | |
| 129854 | 129854 | 208017 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 133 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993400.26342 | 2093895.06859 | 37.7290581627904 | -122.465103152187 | (37.7290581627904, -122.465103152187) | |||
| 136437 | 136437 | 227522 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 749 Dolores St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 8ft | 6005045.57864 | 2104083.12055 | 37.7576968656229 | -122.425569150194 | (37.7576968656229, -122.425569150194) | |||
| 139420 | 139420 | 63076 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 199 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1986 12:00:00 AM | Permit Number 23555 | 6007806.32049195 | 2098166.67321626 | 37.7416072398469 | -122.415602454818 | (37.7416072398469, -122.415602454818) | ||
| 139880 | 139880 | 227535 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 433 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003472.7376 | 2103874.65169 | 37.7570354628405 | -122.430993799639 | (37.7570354628405, -122.430993799639) | |||
| 141621 | 141621 | 67048 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 202X Hartford St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52417 | 6002670.77878077 | 2104705.7738753003 | 37.759272050861505 | -122.433826678093 | (37.7592720508615, -122.433826678093) | ||
| 142986 | 142986 | 63249 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 348 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/1986 12:00:00 AM | Permit Number 23801 | 6006507.15053837 | 2104074.67156974 | 37.7577561425846 | -122.420513825277 | (37.7577561425846, -122.420513825277) | ||
| 142987 | 142987 | 84061 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 4297 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50420 | 6001255.77068266 | 2102291.23804397 | 37.75256192209 | -122.438547448801 | (37.75256192209, -122.438547448801) | ||
| 143163 | 143163 | 63252 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 329 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/1987 12:00:00 AM | Permit Number 23804 | 6006551.99209013 | 2104189.58958185 | 37.7580742077609 | -122.420366900872 | (37.7580742077609, -122.420366900872) | ||
| 145008 | 145008 | 62509 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 30 Worth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1986 12:00:00 AM | Permit Number 22685 | 6000849.16262918 | 2103158.67771698 | 37.7549205635855 | -122.440015759403 | (37.7549205635855, -122.440015759403) | ||
| 150032 | 150032 | 95667 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 800 Colby St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767425 | 6009127.32448 | 2090380.0074200002 | 37.7203008866705 | -122.410485141671 | (37.7203008866705, -122.410485141671) |
| 153880 | 153880 | 227530 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 25 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000951.522369999 | 2104906.4844299997 | 37.75972544210779 | -122.439787074722 | (37.7597254421078, -122.439787074722) | |||
| 168994 | 168994 | 84124 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 1118 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50685 | 6011552.18251 | 2089642.5375 | 37.7184115873075 | -122.402051338211 | (37.7184115873075, -122.402051338211) | |
| 175406 | 175406 | 191510 | DPW Maintained 3 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 900x Carolina St | 34 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6012478.66144 | 2103273.09419 | 37.7558899046023 | -122.399805455861 | (37.7558899046023, -122.399805455861) | ||||
| 178765 | 178765 | 208018 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 1268 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994573.78905 | 2106877.28551 | 37.764771661314896 | -122.461987252204 | (37.7647716613149, -122.461987252204) | |||
| 180993 | 180993 | 208016 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 2348 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5992345.588280001 | 2099437.95609 | 37.7442166639716 | -122.469152467524 | (37.7442166639716, -122.469152467524) | |||
| 181070 | 181070 | 227527 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 18 Worth St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6000853.892999999 | 2103182.27868 | 37.7549856353975 | -122.440001092669 | (37.7549856353975, -122.440001092669) | |||
| 187096 | 187096 | 227524 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 3458 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006695.80913 | 2100883.44136 | 37.7490043865639 | -122.419634947601 | (37.7490043865639, -122.419634947601) | |||
| 187512 | 187512 | 227526 | Undocumented 2 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 705 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001255.81284 | 2102255.85885 | 37.7524647817245 | -122.438544768324 | (37.7524647817245, -122.438544768324) |
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");