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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 9703 | 9703 | 173646 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 380 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003542.0 | 2106028.0 | 37.7629519666094 | -122.43090793911999 | (37.7629519666094, -122.43090793912) | ||||
| 10029 | 10029 | 94465 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 5x6 | Permit Number 779215 | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||
| 14243 | 14243 | 105849 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1025 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 19016 | 6015551.36754 | 2104359.7286799997 | 37.7590443891103 | -122.389254817379 | (37.7590443891103, -122.389254817379) | ||
| 17261 | 17261 | 2372 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2527 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6009769.958330001 | 2102611.45041 | 37.753921802157706 | -122.40912639109699 | (37.7539218021577, -122.409126391097) | |||
| 17537 | 17537 | 2317 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2266 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6009618.58082 | 2104167.6101900004 | 37.758186185862606 | -122.409759727848 | (37.7581861858626, -122.409759727848) | |||
| 17558 | 17558 | 2327 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2301 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5X5 | 6009698.3897 | 2103901.33897 | 37.757459537241395 | -122.409464921063 | (37.7574595372414, -122.409464921063) | |||
| 17562 | 17562 | 4250 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4047 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003586.97779 | 2100377.2494099997 | 37.747438891704505 | -122.43034919167201 | (37.7474388917045, -122.430349191672) | |||
| 17638 | 17638 | 2318 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2270 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5X5 | 6009620.42845 | 2104139.7744 | 37.7581098586044 | -122.40975137312999 | (37.7581098586044, -122.40975137313) | |||
| 18250 | 18250 | 2427 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2884 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6009813.095380001 | 2100671.03054 | 37.7485962562324 | -122.408840321235 | (37.7485962562324, -122.408840321235) | |||
| 18504 | 18504 | 2406 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2729 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009835.509980001 | 2101434.53387 | 37.7506939230859 | -122.408816669975 | (37.7506939230859, -122.408816669975) | |||
| 18551 | 18551 | 2379 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2565 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6009779.24964 | 2102431.71295 | 37.753428803702 | -122.40908157785101 | (37.753428803702, -122.409081577851) | |||
| 19596 | 19596 | 2329 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2309 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6009696.95759 | 2103872.6762900003 | 37.7573807557313 | -122.409467851061 | (37.7573807557313, -122.409467851061) | |||
| 20430 | 20430 | 2398 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2700 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009763.2742 | 2101575.57486 | 37.7510771440053 | -122.409076419352 | (37.7510771440053, -122.409076419352) | |||
| 20689 | 20689 | 2421 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2834 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6009805.25518 | 2100829.83171 | 37.7490318500391 | -122.408878635061 | (37.7490318500391, -122.408878635061) | |||
| 21051 | 21051 | 2331 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2311 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009700.99321 | 2103848.9649799997 | 37.7573158759309 | -122.409452220849 | (37.7573158759309, -122.409452220849) | |||
| 21122 | 21122 | 2423 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2840 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6009807.43229 | 2100804.44049 | 37.748962253304 | -122.408869315378 | (37.748962253304, -122.408869315378) | |||
| 21566 | 21566 | 2377 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2553 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009776.86013 | 2102474.30381 | 37.7535456148439 | -122.409092846361 | (37.7535456148439, -122.409092846361) | |||
| 21741 | 21741 | 2404 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2724 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009770.26673 | 2101463.3127900003 | 37.750769288979605 | -122.409044318046 | (37.7507692889796, -122.409044318046) | |||
| 41889 | 41889 | 101220 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6012016.9208 | 2106179.0839 | 37.763843356795995 | -122.40160655331199 | (37.763843356796, -122.401606553312) | |||
| 44337 | 44337 | 103160 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | |||
| 52181 | 52181 | 51643 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | Permit Number 47930 | 6003254.005 | 2113044.5364 | 37.7822013271565 | -122.432405181484 | (37.7822013271565, -122.432405181484) | ||
| 53171 | 53171 | 85317 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1278 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 5989890.9 | 2106671.2 | 37.76393508945571 | -122.478168901115 | (37.7639350894557, -122.478168901115) | ||||
| 65638 | 65638 | 101218 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6012013.595980001 | 2106263.07985 | 37.764073805372 | -122.401623956992 | (37.764073805372, -122.401623956992) | |||
| 74300 | 74300 | 101215 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6012007.47473 | 2106385.20235 | 37.7644087848666 | -122.401653712871 | (37.7644087848666, -122.401653712871) | |||
| 78478 | 78478 | 117133 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6014096.85518034 | 2104132.8866965002 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | ||||
| 79048 | 79048 | 103163 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | ||||
| 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) | |||
| 81211 | 81211 | 121461 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 17 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 5x5 | 6006175.0 | 2103983.2 | 37.757486258842796 | -122.421656044278 | (37.7574862588428, -122.421656044278) | |||
| 81460 | 81460 | 12262 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 630 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005027.40572 | 2111152.82001 | 37.7771075385512 | -122.426135290831 | (37.7771075385512, -122.426135290831) | |||
| 89778 | 89778 | 108937 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 65 Homestead St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001019.9 | 2101294.0 | 37.749810325724 | -122.439291655065 | (37.749810325724, -122.439291655065) | ||||
| 91914 | 91914 | 44218 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43664 | 6000710.69184788 | 2110000.79371699 | 37.7736994385051 | -122.440985455094 | (37.7736994385051, -122.440985455094) | ||||
| 92227 | 92227 | 94505 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 85 Piedmont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x15 | 5999436.0 | 2106966.0 | 37.7652939775851 | -122.445176567667 | (37.7652939775851, -122.445176567667) | |||
| 92315 | 92315 | 52824 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 301FERNWOOD Brentwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48849 | 5994767.16572707 | 2095140.66542727 | 37.732556994280706 | -122.46046791665701 | (37.7325569942807, -122.460467916657) | ||||
| 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) | |||
| 93536 | 93536 | 119890 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 520 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003249.18885376 | 2096183.56473871 | 37.735904862626 | -122.431217948328 | (37.735904862626, -122.431217948328) | ||||
| 96178 | 96178 | 97500 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 97453 | 97453 | 46531 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 881PERMIT) Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44684 | 5998680.49722421 | 2107051.08092489 | 37.765484436098 | -122.44779578842699 | (37.765484436098, -122.447795788427) | ||||
| 98450 | 98450 | 39211 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3320 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 40855 | 6006915.83116682 | 2102071.77265415 | 37.7522796651602 | -122.41895838053999 | (37.7522796651602, -122.41895838054) | ||||
| 102146 | 102146 | 97502 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 104879 | 104879 | 94466 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 111067 | 111067 | 97499 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 111153 | 111153 | 108936 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 65 Homestead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001019.9 | 2101294.0 | 37.749810325724 | -122.439291655065 | (37.749810325724, -122.439291655065) | ||||
| 115162 | 115162 | 112277 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 100x BELVEDERE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 5998324.0 | 2108210.0 | 37.7686461515867 | -122.449112322085 | (37.7686461515867, -122.449112322085) | ||||
| 115193 | 115193 | 44217 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43664 | 6000710.69184788 | 2110000.79371699 | 37.7736994385051 | -122.440985455094 | (37.7736994385051, -122.440985455094) | ||||
| 122115 | 122115 | 30568 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2681 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34545 | 6008703.52928477 | 2122408.3500681 | 37.8082195561589 | -122.41421491247101 | (37.8082195561589, -122.414214912471) | ||||
| 123314 | 123314 | 117135 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6014096.85518034 | 2104132.8866965002 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | ||||
| 127577 | 127577 | 97501 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 128045 | 128045 | 103161 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | |||||
| 141568 | 141568 | 535 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2578X Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009729.93179 | 2102266.32124 | 37.7529719120351 | -122.409240459881 | (37.7529719120351, -122.409240459881) | |||
| 142845 | 142845 | 117134 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6014096.85518034 | 2104132.8866965002 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | ||||
| 144608 | 144608 | 94467 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 145871 | 145871 | 103166 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201X Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | ||||
| 146669 | 146669 | 101221 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6012019.899180001 | 2106139.93997 | 37.763736042505 | -122.401593500559 | (37.763736042505, -122.401593500559) | |||
| 149106 | 149106 | 101214 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6012005.53818 | 2106423.45815 | 37.7645137186686 | -122.40166309997299 | (37.7645137186686, -122.401663099973) | |||
| 156691 | 156691 | 106659 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 492 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6x9 | 5993768.84062 | 2112215.6427700003 | 37.7793829957774 | -122.465159109631 | (37.7793829957774, -122.465159109631) | |||
| 156910 | 156910 | 51645 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47930 | 6003273.8297 | 2112901.0989 | 37.7818086078686 | -122.43232634946399 | (37.7818086078686, -122.432326349464) | |||
| 158575 | 158575 | 51642 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47930 | 6003249.3404 | 2113069.0257 | 37.782268304126795 | -122.432423068554 | (37.7822683041268, -122.432423068554) | |||
| 159617 | 159617 | 51644 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 47930 | 6003258.6697 | 2113006.0531 | 37.7820959261745 | -122.43238629430701 | (37.7820959261745, -122.432386294307) | ||
| 164001 | 164001 | 56674 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1371 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5984603.4838 | 2105851.1543 | 37.761375137437604 | -122.496395703433 | (37.7613751374376, -122.496395703433) | ||||
| 184721 | 184721 | 101219 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6012016.9704 | 2106218.6671 | 37.7639520461846 | -122.401609164037 | (37.7639520461846, -122.401609164037) | |||
| 49865 | 49865 | 51646 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2006 12:00:00 AM | 2 | Permit Number 47930 | 6003261.002 | 2112980.3977 | 37.7820256151298 | -122.43237639268801 | (37.7820256151298, -122.432376392688) | ||
| 63843 | 63843 | 51639 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2006 12:00:00 AM | 1 | Permit Number 47930 | 6003279.6605 | 2112867.2804 | 37.7817160813577 | -122.432303761604 | (37.7817160813577, -122.432303761604) | ||
| 77507 | 77507 | 57277 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 65 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/1975 12:00:00 AM | 12 | 3x3 | Permit Number 14571 | 6001002.12740755 | 2101341.51741263 | 37.749939785763104 | -122.43935651893801 | (37.7499397857631, -122.439356518938) | |
| 128281 | 128281 | 69079 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1256 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | 3x3 | Permit Number 33087 | 5992094.79631072 | 2106892.73003089 | 37.764671035074 | -122.470562489037 | (37.764671035074, -122.470562489037) | |
| 85929 | 85929 | 32216 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 519 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1998 12:00:00 AM | Permit Number 35537 | 6009462.41872105 | 2100262.21191199 | 37.747454081953 | -122.410024104812 | (37.747454081953, -122.410024104812) | ||
| 54438 | 54438 | 51491 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2005 12:00:00 AM | 15 | Permit Number 47802 | 6012000.2882 | 2106461.09609 | 37.764616771064404 | -122.401683904009 | (37.7646167710644, -122.401683904009) | ||
| 145248 | 145248 | 61069 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2011 12:00:00 AM | 3x3 | Permit Number 54089 | 6000057.45151415 | 2105676.05314863 | 37.7617875559763 | -122.442934478534 | (37.7617875559763, -122.442934478534) | ||
| 89276 | 89276 | 59505 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 148 JULIAN AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/1981 12:00:00 AM | 12 | 4x4 | Permit Number 18882 | 6006386.5 | 2107005.0 | 37.7657953383606 | -122.421139154349 | (37.7657953383606, -122.421139154349) | |
| 79389 | 79389 | 98269 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2700 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscape plot | Permit Number 768491 | 6009963.0 | 2103401.0 | 37.7561005415225 | -122.40851449565001 | (37.7561005415225, -122.40851449565) | |
| 125728 | 125728 | 108999 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 699X Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | Permit Number 773694 | 6011413.0 | 2108471.0 | 37.7701027222045 | -122.403856631371 | (37.7701027222045, -122.403856631371) | |
| 42285 | 42285 | 33829 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1121 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | 15 | Permit Number 37844 | 6015587.6013400005 | 2103776.1855900004 | 37.7574441129692 | -122.38908875844601 | (37.7574441129692, -122.389088758446) | ||
| 156880 | 156880 | 33828 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1121 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | 7 | Permit Number 37844 | 6015588.22624 | 2103756.71192 | 37.757390677059 | -122.38908523761299 | (37.757390677059, -122.389085237613) | ||
| 11139 | 11139 | 35047 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1998 12:00:00 AM | Permit Number 38613 | ||||||||
| 14838 | 14838 | 35048 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1998 12:00:00 AM | Permit Number 38613 | ||||||||
| 139257 | 139257 | 75814 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 300X Vallejo St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2013 12:00:00 AM | Permit Number 769917 | 6011998.05472036 | 2119270.81717993 | 37.7997891592695 | -122.402592490972 | (37.7997891592695, -122.402592490972) | |||
| 46897 | 46897 | 30588 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 109 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | 8 | Permit Number 34558 | 6003337.11539 | 2108646.4783400004 | 37.770130061294104 | -122.431803534827 | (37.7701300612941, -122.431803534827) | ||
| 21572 | 21572 | 2411 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2759 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1999 12:00:00 AM | 6 | 4X4 | 6009845.01424 | 2101254.8528 | 37.7502010910033 | -122.408771128311 | (37.7502010910033, -122.408771128311) | ||
| 84243 | 84243 | 109102 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1665 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771042 | 5993673.5 | 2104163.7 | 37.7572689897716 | -122.46490400670099 | (37.7572689897716, -122.464904006701) |
| 97430 | 97430 | 109101 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1665 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771042 | 5993673.5 | 2104163.7 | 37.7572689897716 | -122.46490400670099 | (37.7572689897716, -122.464904006701) |
| 64321 | 64321 | 69193 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1151 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1994 12:00:00 AM | 8 | Permit Number 33239 | 6008629.33261 | 2117936.9394099996 | 37.79593801218729 | -122.41415513556299 | (37.7959380121873, -122.414155135563) | ||
| 115034 | 115034 | 33841 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/1997 12:00:00 AM | 4 | 3x6 | 6014420.16934645 | 2103447.5968517 | 37.7564770950936 | -122.39310324451999 | (37.7564770950936, -122.39310324452) | |
| 103585 | 103585 | 60713 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 9 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1983 12:00:00 AM | 12 | 5x5 | Permit Number 20366 | 6005260.97523206 | 2105400.53272708 | 37.761326337757104 | -122.424917946837 | (37.7613263377571, -122.424917946837) | |
| 90996 | 90996 | 46310 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3812 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2002 12:00:00 AM | Permit Number 44565 | 6004204.87913613 | 2104845.75610024 | 37.759743343448704 | -122.42853099404199 | (37.7597433434487, -122.428530994042) | |||
| 29061 | 29061 | 95316 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870@Divisadero Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 4 | 3x3 | Permit Number 54638 | 6000971.60034 | 2116251.73043 | 37.7908777689321 | -122.44053135994899 | (37.7908777689321, -122.440531359949) | |
| 40292 | 40292 | 95320 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 4 | 3x3 | Permit Number 54638 | 6000942.23432 | 2116247.30101 | 37.790863934682 | -122.440632646973 | (37.790863934682, -122.440632646973) | |
| 43341 | 43341 | 95321 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 4 | 3x3 | Permit Number 54638 | 6000921.95955 | 2116245.56207 | 37.7908580054302 | -122.44070267179899 | (37.7908580054302, -122.440702671799) | |
| 92283 | 92283 | 95319 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 3x3 | Permit Number 54638 | 6000976.2 | 2116269.7 | 37.7909273706115 | -122.440516734748 | (37.7909273706115, -122.440516734748) | ||
| 106400 | 106400 | 95318 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 3x3 | Permit Number 54638 | 6000976.2 | 2116269.7 | 37.7909273706115 | -122.440516734748 | (37.7909273706115, -122.440516734748) | ||
| 12206 | 12206 | 65603 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 131 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 15 | 3x3 | Permit Number 28506 | 6004245.84033 | 2093781.6134799998 | 37.7293660735617 | -122.427601053271 | (37.7293660735617, -122.427601053271) |
| 13622 | 13622 | 28926 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 275 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2008 12:00:00 AM | 3 | 3x3 | 6009566.071769999 | 2110427.96033 | 37.775372724794394 | -122.41038336002501 | (37.7753727247944, -122.410383360025) | ||
| 30462 | 30462 | 58671 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 624 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1998 12:00:00 AM | 5 | Permit Number 17896 | 6014367.3263 | 2104224.98671 | 37.7586087044554 | -122.39334039516199 | (37.7586087044554, -122.393340395162) | |
| 81858 | 81858 | 62560 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22760 | 6002239.76573177 | 2109514.87514883 | 37.7724521979542 | -122.435661387293 | (37.7724521979542, -122.435661387293) |
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");