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 ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29850 | 29850 | 129698 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6000533.7718 | 2116193.1450799997 | 37.7906919681164 | -122.442042015953 | (37.7906919681164, -122.442042015953) | |||
| 181212 | 181212 | 129699 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6000522.034519999 | 2116191.05959 | 37.7906855730291 | -122.442082476442 | (37.7906855730291, -122.442082476442) | |||
| 161087 | 161087 | 129700 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6000509.65087 | 2116188.56402 | 37.790678015119205 | -122.442125143875 | (37.7906780151192, -122.442125143875) | |||
| 176023 | 176023 | 129701 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6000500.44634 | 2116185.5793 | 37.7906692952944 | -122.442156776619 | (37.7906692952944, -122.442156776619) | |||
| 152755 | 152755 | 111648 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2201 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 12x6 | 6000328.99529 | 2116181.728 | 37.7906489481292 | -122.44274970953501 | (37.7906489481292, -122.442749709535) | |||
| 48423 | 48423 | 129702 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3000 Washington St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 6000294.26409 | 2116157.6767599997 | 37.7905809297121 | -122.442868149367 | (37.7905809297121, -122.442868149367) | |||
| 59071 | 59071 | 129703 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3000 Washington St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6000282.93865 | 2116154.94774 | 37.790572790856 | -122.442907138554 | (37.790572790856, -122.442907138554) | |||
| 26117 | 26117 | 129704 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3000 Washington St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 6000269.523080001 | 2116153.9558 | 37.7905693023891 | -122.442953484235 | (37.7905693023891, -122.442953484235) | |||
| 64874 | 64874 | 129705 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3000 Washington St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 6000256.311000001 | 2116152.5364599996 | 37.7905646519773 | -122.442999095143 | (37.7905646519773, -122.442999095143) | |||
| 42595 | 42595 | 129690 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3498 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997573.73789 | 2116108.4846099997 | 37.7902903857379 | -122.45227741238199 | (37.7902903857379, -122.452277412382) | |||
| 175823 | 175823 | 129689 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3498 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997554.59355 | 2116102.0824700003 | 37.790271710430204 | -122.45234318791401 | (37.7902717104302, -122.452343187914) | |||
| 147342 | 147342 | 76428 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 300 Spear St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1998 12:00:00 AM | 1 | 6015359.03097 | 2115547.59056 | 37.7897531109548 | -122.390701840925 | (37.7897531109548, -122.390701840925) | ||
| 187505 | 187505 | 129706 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3248 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5999211.511 | 2115678.78718 | 37.78920423673 | -122.44657992842698 | (37.78920423673, -122.446579928427) | |||
| 176667 | 176667 | 138291 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2435 CALIFORNIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6002560.4532 | 2115416.5919 | 37.7886750374795 | -122.43497425370899 | (37.7886750374795, -122.434974253709) | |||
| 65171 | 65171 | 45763 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3954 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2001 12:00:00 AM | 5 | Permit Number 44411 | 5995817.4754 | 2115534.8475099998 | 37.7886145656939 | -122.45831237779 | (37.7886145656939, -122.45831237779) | ||
| 46423 | 46423 | 45764 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3954 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2001 12:00:00 AM | 5 | Permit Number 44411 | 5995797.28433 | 2115532.1043599998 | 37.788605873462 | -122.45838203677799 | (37.788605873462, -122.458382036778) | ||
| 176674 | 176674 | 31878 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3740 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 7 | Permit Number 35316 | 5996936.65811 | 2115356.47325 | 37.7881890469296 | -122.454427304671 | (37.7881890469296, -122.454427304671) | ||
| 32656 | 32656 | 123589 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 32 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994275.31768 | 2115360.29886 | 37.7880465633309 | -122.463635298323 | (37.7880465633309, -122.463635298323) | |||
| 178079 | 178079 | 122999 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 42 07th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5993659.38134 | 2115213.58534 | 37.787608218531794 | -122.46575564845699 | (37.7876082185318, -122.465755648457) | |||
| 89614 | 89614 | 123551 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 69 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994236.53379 | 2115140.07553 | 37.787439655324896 | -122.463753492359 | (37.7874396553249, -122.463753492359) | |||
| 130687 | 130687 | 38879 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 312 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40702 | 5996216.25426 | 2115095.08483 | 37.7874300029464 | -122.456900851289 | (37.7874300029464, -122.456900851289) | |
| 9611 | 9611 | 138137 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1790 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004447.4756 | 2114919.1759 | 37.7874162214119 | -122.42840996490801 | (37.7874162214119, -122.428409964908) | ||||
| 34010 | 34010 | 123582 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 82 05th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5994285.08275 | 2115071.4711700003 | 37.7872540838992 | -122.463580543309 | (37.7872540838992, -122.463580543309) | |||
| 180981 | 180981 | 123583 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 82 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994285.44541 | 2115062.1508 | 37.7872285135982 | -122.46357861191002 | (37.7872285135982, -122.46357861191) | |||
| 106871 | 106871 | 59867 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 82 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1981 12:00:00 AM | 10 | Permit Number 19326 | 5994285.52331 | 2115052.43823 | 37.7872018500152 | -122.463577637239 | (37.7872018500152, -122.463577637239) | ||
| 116982 | 116982 | 23926 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 12x1 | 6003454.884490401 | 2114845.825423 | 37.7871586020093 | -122.43183888463899 | (37.7871586020093, -122.431838884639) | |||
| 125350 | 125350 | 23923 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 12x1 | 6003454.884490401 | 2114845.825423 | 37.7871586020093 | -122.43183888463899 | (37.7871586020093, -122.431838884639) | |||
| 7162 | 7162 | 23924 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 12x1 | 6003487.1069 | 2114786.6255 | 37.7869978805436 | -122.43172317383998 | (37.7869978805436, -122.43172317384) | |||
| 134560 | 134560 | 138492 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2290 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/1992 12:00:00 AM | 6 | Width 0ft | 6002608.3612 | 2114780.8430000003 | 37.7869321532521 | -122.434763018716 | (37.7869321532521, -122.434763018716) | ||
| 139460 | 139460 | 2739 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2290X Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/1992 12:00:00 AM | 8 | 3x3 | 6002556.047619999 | 2114770.51181 | 37.7869008162884 | -122.434943272404 | (37.7869008162884, -122.434943272404) | ||
| 1473 | 1473 | 23922 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 12x1 | 6003506.5026 | 2114704.4246 | 37.786773277055204 | -122.431650198179 | (37.7867732770552, -122.431650198179) | ||
| 59631 | 59631 | 191142 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3 Bryant St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 6015882.39445 | 2114438.5684700003 | 37.7867370114514 | -122.388813583003 | (37.7867370114514, -122.388813583003) | |||
| 68782 | 68782 | 137952 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700x WEBSTER ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6003511.8133 | 2114663.5551 | 37.786661360752895 | -122.431628905483 | (37.7866613607529, -122.431628905483) | |||
| 46300 | 46300 | 191141 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3 Bryant St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6015816.86409 | 2114381.01819 | 37.78657535921089 | -122.389036284815 | (37.7865753592109, -122.389036284815) | |||
| 132996 | 132996 | 138328 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2381 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002138.0001 | 2114659.3895 | 37.786571957846796 | -122.436381662526 | (37.7865719578468, -122.436381662526) | |||
| 7311 | 7311 | 23920 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1700X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 12x12 | 6003521.972999999 | 2114612.7568 | 37.786522457310205 | -122.43159012740699 | (37.7865224573102, -122.431590127407) | |||
| 57238 | 57238 | 138689 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2511 BUSH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001375.2358 | 2114552.1107 | 37.786234027507 | -122.439012943204 | (37.786234027507, -122.439012943204) | |||
| 173733 | 173733 | 138688 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2511 BUSH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001355.4899 | 2114547.7912 | 37.7862210437499 | -122.43908094903 | (37.7862210437499, -122.43908094903) | |||
| 181488 | 181488 | 138661 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2511 BUSH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001335.1269 | 2114544.7059 | 37.7862114136354 | -122.43915117832199 | (37.7862114136354, -122.439151178322) | |||
| 2178 | 2178 | 18161 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005286.1585 | 2114461.6714 | 37.7862074506483 | -122.425475720608 | (37.7862074506483, -122.425475720608) | |||
| 103617 | 103617 | 15137 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 780X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6011914.84635 | 2114325.58433 | 37.7862060830296 | -122.40253249015801 | (37.7862060830296, -122.402532490158) | |||
| 44146 | 44146 | 138695 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2511 BUSH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001299.3374 | 2114542.2377 | 37.786202600035296 | -122.43927482337 | (37.7862026000353, -122.43927482337) | |||
| 131133 | 131133 | 250130 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1377 Post St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6005624.52501 | 2114452.88232 | 37.786202430153395 | -122.42430443452601 | (37.7862024301534, -122.424304434526) | |||
| 150255 | 150255 | 250129 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1377 Post St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6005609.22184 | 2114451.0225400003 | 37.786196459532704 | -122.42435724721201 | (37.7861964595327, -122.424357247212) | |||
| 37878 | 37878 | 138694 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2511 BUSH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001275.2721 | 2114538.5353 | 37.786191064717606 | -122.43935781732701 | (37.7861910647176, -122.439357817327) | |||
| 22794 | 22794 | 26757 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005593.49204 | 2114448.7926 | 37.786189448429205 | -122.42441150958099 | (37.7861894484292, -122.424411509581) | |||
| 5713 | 5713 | 18162 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005249.8968 | 2114455.0784 | 37.7861872990315 | -122.425600707285 | (37.7861872990315, -122.425600707285) | |||
| 162096 | 162096 | 138693 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2511 BUSH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001245.0361 | 2114535.45 | 37.7861808725601 | -122.439462204459 | (37.7861808725601, -122.439462204459) | |||
| 22378 | 22378 | 26756 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005569.26951 | 2114444.1495 | 37.7861753317646 | -122.424494982868 | (37.7861753317646, -122.424494982868) | |||
| 4082 | 4082 | 18163 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005210.3387 | 2114450.1336 | 37.7861714865556 | -122.425737215933 | (37.7861714865556, -122.425737215933) | |||
| 22804 | 22804 | 26755 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005555.38127 | 2114442.5721400003 | 37.7861702164197 | -122.424542920326 | (37.7861702164197, -122.424542920326) | |||
| 57433 | 57433 | 138692 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2511 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001223.438999999 | 2114531.1306 | 37.786167783460705 | -122.43953661481399 | (37.7861677834607, -122.439536614814) | |||
| 22634 | 22634 | 26754 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005539.86656 | 2114440.61457 | 37.7861639652384 | -122.424596457885 | (37.7861639652384, -122.424596457885) | |||
| 8468 | 8468 | 18164 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005185.0654 | 2114447.3865 | 37.78616251551679 | -122.42582445934299 | (37.7861625155168, -122.425824459343) | |||
| 22416 | 22416 | 26753 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005527.1532 | 2114438.07435 | 37.7861562724304 | -122.424640262031 | (37.7861562724304, -122.424640262031) | |||
| 5899 | 5899 | 18165 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005168.5828 | 2114444.09 | 37.786152532687105 | -122.42588125009199 | (37.7861525326871, -122.425881250092) | |||
| 22571 | 22571 | 26752 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005515.49515 | 2114435.63395 | 37.7861489132884 | -122.424680422175 | (37.7861489132884, -122.424680422175) | |||
| 5968 | 5968 | 18166 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005153.199 | 2114441.8923 | 37.786145628959204 | -122.42593431751101 | (37.7861456289592, -122.425934317511) | |||
| 82308 | 82308 | 26759 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005482.1110222 | 2114431.1702313 | 37.786134771520096 | -122.42479560486 | (37.7861347715201, -122.42479560486) | |||
| 140171 | 140171 | 26758 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005482.1110222 | 2114431.1702313 | 37.786134771520096 | -122.42479560486 | (37.7861347715201, -122.42479560486) | |||
| 6323 | 6323 | 18167 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005136.7165 | 2114437.497 | 37.7861326290509 | -122.425991029638 | (37.7861326290509, -122.425991029638) | |||
| 162304 | 162304 | 249548 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1398 Gough St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6005498.68778 | 2114410.1852 | 37.78607808808621 | -122.424736760212 | (37.7860780880862, -122.424736760212) | |||
| 46247 | 46247 | 250029 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1398 Gough St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6005499.34318 | 2114400.53474 | 37.7860516273342 | -122.424733805923 | (37.7860516273342, -122.424733805923) | |||
| 7873 | 7873 | 28650 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1600X Webster St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003539.955 | 2114426.6147 | 37.786012377283896 | -122.431514620567 | (37.7860123772839, -122.431514620567) | |||
| 129549 | 129549 | 250027 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1388 Gough St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6005504.43903 | 2114371.51964 | 37.7859722468757 | -122.424714110791 | (37.7859722468757, -122.424714110791) | |||
| 153116 | 153116 | 138697 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1600 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000126.7892 | 2114457.5063 | 37.7859031552801 | -122.44332543185 | (37.7859031552801, -122.44332543185) | |||
| 127535 | 127535 | 12849 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2412 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2010 12:00:00 AM | 12 | 3X3 | 5987958.93678 | 2114680.36581 | 37.7858136848869 | -122.48543867329501 | (37.7858136848869, -122.485438673295) | ||
| 80190 | 80190 | 9860 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1350X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005510.31895 | 2114302.95438 | 37.785784315765206 | -122.424688888506 | (37.7857843157652, -122.424688888506) | |||
| 80526 | 80526 | 9862 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1350X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005510.31895 | 2114302.95438 | 37.785784315765206 | -122.424688888506 | (37.7857843157652, -122.424688888506) | |||
| 92762 | 92762 | 9859 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1350X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005510.31895 | 2114302.95438 | 37.785784315765206 | -122.424688888506 | (37.7857843157652, -122.424688888506) | |||
| 133445 | 133445 | 124004 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 145 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5993946.73385 | 2114533.02839 | 37.785756165863106 | -122.464712034275 | (37.7857561658631, -122.464712034275) | |||
| 8006 | 8006 | 23900 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1600X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6 | 6003566.3311 | 2114312.7691 | 37.7857012808729 | -122.43141523648701 | (37.7857012808729, -122.431415236487) | |||
| 55138 | 55138 | 250022 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Peter Yorke Way | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6005626.62253 | 2114259.1773 | 37.785670682612704 | -122.424283395778 | (37.7856706826127, -122.424283395778) | |||
| 51658 | 51658 | 250023 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Peter Yorke Way | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6005617.72798 | 2114253.53243 | 37.785654680956505 | -122.424313766772 | (37.7856546809565, -122.424313766772) | |||
| 41550 | 41550 | 250024 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Peter Yorke Way | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6005604.615069999 | 2114246.3062 | 37.785634099068496 | -122.42435861956301 | (37.7856340990685, -122.424358619563) | |||
| 37080 | 37080 | 250025 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Peter Yorke Way | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6005592.08729 | 2114239.19437 | 37.7856138643192 | -122.424401456086 | (37.7856138643192, -122.424401456086) | |||
| 82286 | 82286 | 28268 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 20X Peter Yorke Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005597.7326569 | 2114202.21171 | 37.785512637883 | -122.42437929334999 | (37.785512637883, -122.42437929335) | |||
| 82790 | 82790 | 28267 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 20X Peter Yorke Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005597.7326569 | 2114202.21171 | 37.785512637883 | -122.42437929334999 | (37.785512637883, -122.42437929335) | |||
| 117723 | 117723 | 28270 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 20X Peter Yorke Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005597.7326569 | 2114202.21171 | 37.785512637883 | -122.42437929334999 | (37.785512637883, -122.42437929335) | |||
| 142691 | 142691 | 28269 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 20X Peter Yorke Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005597.7326569 | 2114202.21171 | 37.785512637883 | -122.42437929334999 | (37.785512637883, -122.42437929335) | |||
| 121012 | 121012 | 116266 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2340 SUTTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001385.0 | 2114274.0 | 37.7854709624663 | -122.438959223563 | (37.7854709624663, -122.438959223563) | ||||
| 132252 | 132252 | 116263 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2340 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6001396.5244 | 2114263.3264 | 37.785442311187204 | -122.438918587458 | (37.7854423111872, -122.438918587458) | |||
| 183593 | 183593 | 116264 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2340 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6001382.9491 | 2114260.8581 | 37.7854347614906 | -122.4389653769 | (37.7854347614906, -122.4389653769) | |||
| 115839 | 115839 | 116265 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2340 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6001353.9473 | 2114257.7728 | 37.7854246399045 | -122.439065493069 | (37.7854246399045, -122.439065493069) | |||
| 80400 | 80400 | 28651 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1600X Webster St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
| 14635 | 14635 | 15136 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 766 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/04/2008 12:00:00 AM | 3 | 3x3 | 6011623.78991 | 2113963.56505 | 37.7851958099766 | -122.40351399557699 | (37.7851958099766, -122.403513995577) | ||
| 50881 | 50881 | 191138 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 770 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011596.13889 | 2113930.29234 | 37.7851029064102 | -122.403607318248 | (37.7851029064102, -122.403607318248) | |||
| 149194 | 149194 | 191140 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 761 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6011668.442480001 | 2113913.34766 | 37.7850604188475 | -122.40335597660801 | (37.7850604188475, -122.403355976608) | |||
| 135757 | 135757 | 68140 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2520 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 3 | Permit Number 31894 | 6000504.5856 | 2114139.1025 | 37.785050437079796 | -122.441995501898 | (37.7850504370798, -122.441995501898) | |
| 184120 | 184120 | 191139 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 763 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6011643.5293 | 2113893.61304 | 37.7850048407399 | -122.403440779973 | (37.7850048407399, -122.403440779973) | |||
| 174514 | 174514 | 49395 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2483BRODERICK Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2003 12:00:00 AM | 6 | Permit Number 46348 | 6000704.8967 | 2114113.6763 | 37.7849920360606 | -122.44130066560699 | (37.7849920360606, -122.441300665607) | ||
| 159745 | 159745 | 69952 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 565 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1990 12:00:00 AM | 8 | 5997087.15611 | 2114145.30542 | 37.7848721322932 | -122.453819112066 | (37.7848721322932, -122.453819112066) | ||
| 94348 | 94348 | 23879 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1500X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 4 | 6003644.6262703 | 2113904.6308207 | 37.7845850728987 | -122.43111521625299 | (37.7845850728987, -122.431115216253) | |||
| 139971 | 139971 | 23878 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1500X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 4 | 6003644.6262703 | 2113904.6308207 | 37.7845850728987 | -122.43111521625299 | (37.7845850728987, -122.431115216253) | |||
| 50522 | 50522 | 31991 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 215 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 12 | Permit Number 35392 | 5994587.26751 | 2113998.16217 | 37.784324475145795 | -122.462457175798 | (37.7843244751458, -122.462457175798) | |
| 60653 | 60653 | 140333 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1567 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003115.1263 | 2113727.9521 | 37.78406993872171 | -122.43293447921002 | (37.7840699387217, -122.43293447921) | |||
| 7438 | 7438 | 23859 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003649.3852 | 2113669.4444 | 37.783939579713504 | -122.431081960003 | (37.7839395797135, -122.431081960003) | |||
| 36101 | 36101 | 140335 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1551 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003125.8973 | 2113652.5551 | 37.783863528484396 | -122.432891827231 | (37.7838635284844, -122.432891827231) | |||
| 84104 | 84104 | 117076 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1538 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 5x5 | 6003192.0 | 2113651.0 | 37.7838630075842 | -122.43266302547701 | (37.7838630075842, -122.432663025477) | |||
| 88844 | 88844 | 117077 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1538 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 5x5 | 6003192.0 | 2113651.0 | 37.7838630075842 | -122.43266302547701 | (37.7838630075842, -122.432663025477) |
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");