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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186207 | 186207 | 117729 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 444 40th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5983475.649730001 | 2112834.36493 | 37.7804828918797 | -122.500812777933 | (37.7804828918797, -122.500812777933) | |||
| 10241 | 10241 | 38335 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 444 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | Permit Number 47950 | 5983475.9244099995 | 2112817.71297 | 37.7804371865901 | -122.50081059591899 | (37.7804371865901, -122.500810595919) | ||
| 147611 | 147611 | 37200 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1523 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 0 | Permit Number 39767 | 5986185.22517174 | 2104866.53832379 | 37.7587641880882 | -122.49085274409501 | (37.7587641880882, -122.490852744095) | |
| 181381 | 181381 | 37205 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1579 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 4 | Permit Number 39772 | 5986201.0748 | 2104494.9459 | 37.757744823471796 | -122.49077058795099 | (37.7577448234718, -122.490770587951) | |
| 101945 | 101945 | 45081 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2143 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | Permit Number 43964 | 5987260.68011287 | 2100690.67520581 | 37.7473611656774 | -122.486826724588 | (37.7473611656774, -122.486826724588) | ||
| 145772 | 145772 | 45082 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2143 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | Permit Number 43964 | 5987260.68011287 | 2100690.67520581 | 37.7473611656774 | -122.486826724588 | (37.7473611656774, -122.486826724588) | ||
| 146616 | 146616 | 44219 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2139 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Permit Number 43665 | 5987260.984 | 2100720.2895 | 37.7474424963194 | -122.486827848138 | (37.7474424963194, -122.486827848138) | |||
| 163075 | 163075 | 44220 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2139 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2001 12:00:00 AM | 2 | Permit Number 43665 | 5987262.4786 | 2100698.6187 | 37.74738308124 | -122.48682108885599 | (37.74738308124, -122.486821088856) | ||
| 77743 | 77743 | 110153 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 267 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775195 | 5988018.8 | 2114202.3 | 37.7845045397665 | -122.48519647577601 | (37.7845045397665, -122.485196475776) | |
| 136573 | 136573 | 177298 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988403.4281 | 2091243.7200900002 | 37.721488831717 | -122.48218323117099 | (37.721488831717, -122.482183231171) | ||||
| 176865 | 176865 | 183390 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2673 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989554.4883 | 2097163.7436 | 37.7378105948151 | -122.478637096313 | (37.7378105948151, -122.478637096313) | |||
| 104143 | 104143 | 97119 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1151 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | |
| 122940 | 122940 | 97121 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1151 Taraval St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | |
| 139254 | 139254 | 97120 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1151 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | |
| 79820 | 79820 | 85261 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2998 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989779.1 | 2095328.3 | 37.7327839760928 | -122.477726384657 | (37.7327839760928, -122.477726384657) | |||
| 127040 | 127040 | 46900 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1357 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44956 | 5991106.29954004 | 2106174.99705817 | 37.7626431240146 | -122.473929035532 | (37.7626431240146, -122.473929035532) | ||
| 84155 | 84155 | 38441 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2591 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1998 12:00:00 AM | Permit Number 40466 | 5992043.633381099 | 2097820.82323466 | 37.739758976855796 | -122.470078824326 | (37.7397589768558, -122.470078824326) | |||
| 151718 | 151718 | 208552 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 117 Vernon St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992432.903059999 | 2088632.12991 | 37.714551590949796 | -122.468064688039 | (37.7145515909498, -122.468064688039) | |||
| 182385 | 182385 | 208551 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 439 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992460.92355 | 2090770.88393 | 37.7204257089658 | -122.46812332475001 | (37.7204257089658, -122.46812332475) | |||
| 181363 | 181363 | 208550 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 498 Vernon St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5992503.57103 | 2091183.8061799998 | 37.7215619556104 | -122.468005927235 | (37.7215619556104, -122.468005927235) | |||
| 51146 | 51146 | 208549 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 498 Vernon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5992504.0941 | 2091172.39511 | 37.721530653806504 | -122.468003289534 | (37.7215306538065, -122.468003289534) | |||
| 164507 | 164507 | 208553 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 595 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5993236.49495 | 2091160.4237799998 | 37.7215400517233 | -122.465470730297 | (37.7215400517233, -122.465470730297) | |||
| 185117 | 185117 | 208554 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 447 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5993467.665990001 | 2088853.99323 | 37.715220478815105 | -122.464504257677 | (37.7152204788151, -122.464504257677) | |||
| 169979 | 169979 | 123969 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 115 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993630.62281 | 2114735.8184599997 | 37.786294742523204 | -122.46582041968 | (37.7862947425232, -122.46582041968) | |||
| 182644 | 182644 | 36962 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 146 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 7 | Permit Number 39591 | 5994303.22649 | 2114557.05479 | 37.785842681857 | -122.463480424277 | (37.785842681857, -122.463480424277) | |
| 118842 | 118842 | 1680 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 400 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1998 12:00:00 AM | 12 | 3X3 | 5994348.50119 | 2111464.79497 | 37.777354777894395 | -122.46309934094299 | (37.7773547778944, -122.463099340943) | ||
| 115249 | 115249 | 123699 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 302 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994616.485830001 | 2111473.74211 | 37.777394777876 | -122.462172950615 | (37.777394777876, -122.462172950615) | |||
| 26609 | 26609 | 123604 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 288 04th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994649.79815 | 2113605.5520599997 | 37.7832500744158 | -122.462212359722 | (37.7832500744158, -122.462212359722) | |||
| 56374 | 56374 | 123605 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 288 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994650.61525 | 2113597.37697 | 37.78322767487 | -122.462208939817 | (37.78322767487, -122.462208939817) | |||
| 79017 | 79017 | 38836 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 254 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1998 12:00:00 AM | Permit Number 40666 | 5994768.12752284 | 2113559.99820217 | 37.783131808317705 | -122.461799686207 | (37.7831318083177, -122.461799686207) | ||
| 111763 | 111763 | 38837 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 254 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1998 12:00:00 AM | Permit Number 40666 | 5994768.12752284 | 2113559.99820217 | 37.783131808317705 | -122.461799686207 | (37.7831318083177, -122.461799686207) | ||
| 123275 | 123275 | 38834 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 254 Clement St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1998 12:00:00 AM | Permit Number 40666 | 5994768.12752284 | 2113559.99820217 | 37.783131808317705 | -122.461799686207 | (37.7831318083177, -122.461799686207) | ||
| 9437 | 9437 | 2767 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 238 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2016 12:00:00 AM | 3 | 3X3 | 5994814.49115 | 2110801.12928 | 37.775559360496004 | -122.461439216572 | (37.775559360496, -122.461439216572) | ||
| 111651 | 111651 | 21847 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 202X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 3 | 3X3 | 5994968.90714 | 2110807.33222 | 37.7755852784786 | -122.46090550770701 | (37.7755852784786, -122.460905507707) | ||
| 24434 | 24434 | 30933 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 515 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 2 | Permit Number 34746 | 5995238.0527800005 | 2091207.0599900002 | 37.7217833398997 | -122.45855530799801 | (37.7217833398997, -122.458555307998) | |
| 170125 | 170125 | 208548 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 150 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5995469.48283 | 2089658.1896400002 | 37.717543807180704 | -122.457643306389 | (37.7175438071807, -122.457643306389) | |||
| 151431 | 151431 | 208542 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1201 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5995837.91455 | 2092068.1377299998 | 37.724182111503204 | -122.45654399220501 | (37.7241821115032, -122.456543992205) | |||
| 188633 | 188633 | 208541 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1201 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5995841.3844800005 | 2092081.2492799999 | 37.7242183119117 | -122.456532944957 | (37.7242183119117, -122.456532944957) | |||
| 188406 | 188406 | 208540 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1205 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5995843.60881 | 2092100.2971700002 | 37.7242707405805 | -122.456526632611 | (37.7242707405805, -122.456526632611) | |||
| 123868 | 123868 | 47095 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 356 Willard North St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45077 | 5996301.73927169 | 2110554.62831554 | 37.7749680212207 | -122.456276668944 | (37.7749680212207, -122.456276668944) | ||
| 25990 | 25990 | 208547 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 249 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996507.174219999 | 2091557.14862 | 37.7228174577402 | -122.454193583485 | (37.7228174577402, -122.454193583485) | |||
| 58746 | 58746 | 40802 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 121 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1999 12:00:00 AM | 4 | Permit Number 41751 | 5996513.2556 | 2113630.7306 | 37.7834263270019 | -122.455767400466 | (37.7834263270019, -122.455767400466) | ||
| 48065 | 48065 | 208545 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 12 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5996523.6042 | 2089967.17912 | 37.7184527177873 | -122.454022014425 | (37.7184527177873, -122.454022014425) | |||
| 133884 | 133884 | 208546 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 12 Lee Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5996523.78627 | 2089975.89779 | 37.7184766676518 | -122.454022014422 | (37.7184766676518, -122.454022014422) | |||
| 132269 | 132269 | 68582 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 175 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1993 12:00:00 AM | 4 | Permit Number 32479 | 5996530.1767 | 2113176.9069999997 | 37.7821812189094 | -122.45567604598499 | (37.7821812189094, -122.455676045985) | ||
| 133524 | 133524 | 141042 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 175 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5996531.5303 | 2113164.047 | 37.7821459864366 | -122.45567043332 | (37.7821459864366, -122.45567043332) | |||
| 73379 | 73379 | 124522 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 51 Parsons St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996562.787219999 | 2110517.36103 | 37.7748806768667 | -122.45537095938101 | (37.7748806768667, -122.455370959381) | |||
| 105854 | 105854 | 41122 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2344 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41865 | 5996582.9529178 | 2110470.59190578 | 37.7747534181142 | -122.455297821718 | (37.7747534181142, -122.455297821718) | ||
| 118663 | 118663 | 41119 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2344 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41865 | 5996582.9529178 | 2110470.59190578 | 37.7747534181142 | -122.455297821718 | (37.7747534181142, -122.455297821718) | ||
| 119562 | 119562 | 41120 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2344 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41865 | 5996582.9529178 | 2110470.59190578 | 37.7747534181142 | -122.455297821718 | (37.7747534181142, -122.455297821718) | ||
| 145312 | 145312 | 41121 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2344 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41865 | 5996582.9529178 | 2110470.59190578 | 37.7747534181142 | -122.455297821718 | (37.7747534181142, -122.455297821718) | ||
| 162525 | 162525 | 50521 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 145 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 1 | Permit Number 47159 | 5996798.3759 | 2112040.3174 | 37.779075831041105 | -122.45466606343099 | (37.7790758310411, -122.454666063431) | |
| 130148 | 130148 | 177288 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 170 Lawrence Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5996808.94464 | 2087276.4336299999 | 37.711080912033296 | -122.452841609247 | (37.7110809120333, -122.452841609247) | |||
| 109399 | 109399 | 36480 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 541 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39372 | 5996872.521549599 | 2093815.84341283 | 37.72904024196271 | -122.45309363195 | (37.7290402419627, -122.45309363195) | ||
| 125488 | 125488 | 36479 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 541 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39372 | 5996872.521549599 | 2093815.84341283 | 37.72904024196271 | -122.45309363195 | (37.7290402419627, -122.45309363195) | ||
| 82484 | 82484 | 36477 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 531 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39371 | 5996915.79992705 | 2093810.02039561 | 37.7290267336025 | -122.452943595903 | (37.7290267336025, -122.452943595903) | ||
| 106635 | 106635 | 36478 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 531 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39371 | 5996915.79992705 | 2093810.02039561 | 37.7290267336025 | -122.452943595903 | (37.7290267336025, -122.452943595903) | ||
| 93986 | 93986 | 36476 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 524 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41513 | 5996948.70097149 | 2093858.06219815 | 37.729160530354 | -122.452833321223 | (37.729160530354, -122.452833321223) | ||
| 116313 | 116313 | 52513 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 60 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48618 | 5997208.37126376 | 2086857.00593017 | 37.709952140530895 | -122.451430868837 | (37.7099521405309, -122.451430868837) | ||
| 68345 | 68345 | 70836 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 239 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1994 12:00:00 AM | 3 | 5997827.1396 | 2109714.2746 | 37.7727480736245 | -122.450939398271 | (37.7727480736245, -122.450939398271) | ||
| 11076 | 11076 | 114096 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 424 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2015 12:00:00 AM | 3 | 3x3 | 5998431.96208 | 2087528.9205599998 | 37.711867056188105 | -122.447250250697 | (37.7118670561881, -122.447250250697) | ||
| 10704 | 10704 | 114095 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 424 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2015 12:00:00 AM | 3 | 3x3 | 5998448.0105800005 | 2087544.4934 | 37.7119107326703 | -122.44719590289 | (37.7119107326703, -122.44719590289) | ||
| 148071 | 148071 | 141620 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1801 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998848.2105 | 2110389.4859 | 37.774660432389396 | -122.447456024852 | (37.7746604323894, -122.447456024852) | |||
| 50583 | 50583 | 141622 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1801 GROVE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998881.826 | 2110394.3314 | 37.7746756578154 | -122.447340091401 | (37.7746756578154, -122.447340091401) | |||
| 181056 | 181056 | 78246 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1447 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 2 | 5999064.52078 | 2089547.1933099998 | 37.7174448988403 | -122.445208973141 | (37.7174448988403, -122.445208973141) | ||
| 70623 | 70623 | 208543 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 100 Vista Verde Ct | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 10ft | 5999208.78816 | 2096056.4292400002 | 37.7353259823914 | -122.445178028358 | (37.7353259823914, -122.445178028358) | |||
| 172225 | 172225 | 62147 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2057 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 3 | Permit Number 22261 | 5999361.52655 | 2121151.9257099996 | 37.804240583901795 | -122.44645480395599 | (37.8042405839018, -122.446454803956) | |
| 114539 | 114539 | 130432 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2824 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999398.65268 | 2118424.75751 | 37.796754632574206 | -122.44613004167499 | (37.7967546325742, -122.446130041675) | |||
| 184749 | 184749 | 208544 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 171 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 5999615.39289 | 2094047.29924 | 37.7298325824993 | -122.443627964962 | (37.7298325824993, -122.443627964962) | |||
| 3137 | 3137 | 110905 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2891 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775210 | 5999766.160759999 | 2117386.55705 | 37.7939249895015 | -122.44478371968701 | (37.7939249895015, -122.444783719687) | |
| 130747 | 130747 | 177289 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1200 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 5999793.10154 | 2090324.86823 | 37.719621778009 | -122.44274642341499 | (37.719621778009, -122.442746423415) | |||
| 89522 | 89522 | 41687 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 124 Saturn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42140 | 5999927.88161805 | 2106008.33179804 | 37.7626925227356 | -122.44340647595699 | (37.7626925227356, -122.443406475957) | ||
| 150371 | 150371 | 229231 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 754 Grand View Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6000043.848259999 | 2100826.21888 | 37.7484703196688 | -122.44263329140699 | (37.7484703196688, -122.442633291407) | |||
| 24883 | 24883 | 52521 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 225 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 6 | Permit Number 48914 | 6000062.86091 | 2091491.3711 | 37.7228401035632 | -122.441897645058 | (37.7228401035632, -122.441897645058) | |
| 59538 | 59538 | 52522 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 225 Onondaga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | 4 | Permit Number 48622 | 6000078.51361 | 2091484.1032900002 | 37.7228210397476 | -122.441843015763 | (37.7228210397476, -122.441843015763) | ||
| 100960 | 100960 | 96573 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 44 Levant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5x6 | 6000274.0 | 2106572.0 | 37.764259947984904 | -122.442249845362 | (37.7642599479849, -122.442249845362) | |||
| 17471 | 17471 | 25186 | DPW Maintained 3 | Magnolia doltsopa :: Himalayan Magnolia 187 | 3644 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 3 | 3X3 | 6000415.91154 | 2103347.84626 | 37.755415300882895 | -122.441527633417 | (37.7554153008829, -122.441527633417) | ||
| 47140 | 47140 | 229234 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 909 Elizabeth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6000533.75366 | 2101957.19594 | 37.751603625114996 | -122.441020338428 | (37.751603625115, -122.441020338428) | |||
| 77935 | 77935 | 49982 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 145 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001001 | (37.7234037567812, -122.43984643001) | ||
| 100154 | 100154 | 49980 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 145 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001001 | (37.7234037567812, -122.43984643001) | ||
| 123123 | 123123 | 49979 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 145 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001001 | (37.7234037567812, -122.43984643001) | ||
| 127608 | 127608 | 49981 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 145 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001001 | (37.7234037567812, -122.43984643001) | ||
| 36266 | 36266 | 229253 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 245 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000709.628269999 | 2106546.14051 | 37.7642137623885 | -122.44074127969401 | (37.7642137623885, -122.440741279694) | |||
| 62512 | 62512 | 177296 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 115 Newton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000995.34675 | 2087902.8646 | 37.7130399628101 | -122.43841727143801 | (37.7130399628101, -122.438417271438) | |||
| 70917 | 70917 | 177295 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 115 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001002.005530001 | 2087880.82642 | 37.712979829625795 | -122.438392678593 | (37.7129798296258, -122.438392678593) | |||
| 163099 | 163099 | 130434 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2701 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001177.09215 | 2116887.43491 | 37.7926349471062 | -122.439865967752 | (37.7926349471062, -122.439865967752) | |||
| 134515 | 134515 | 229232 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 708 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001218.15121 | 2102192.48263 | 37.752288623422295 | -122.43867046747 | (37.7522886234223, -122.43867046747) | |||
| 170798 | 170798 | 229254 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 157 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001282.99504 | 2106223.75237 | 37.763361199682606 | -122.43873506938299 | (37.7633611996826, -122.438735069383) | |||
| 18941 | 18941 | 1920 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 48 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2012 12:00:00 AM | 3 | 3x3 | 6001413.10408 | 2097289.51467 | 37.738837322394204 | -122.437645189074 | (37.7388373223942, -122.437645189074) | ||
| 36829 | 36829 | 177301 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1222 Athens St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6001599.00625 | 2087595.59489 | 37.7122305864419 | -122.436308849585 | (37.7122305864419, -122.436308849585) | |||
| 44007 | 44007 | 177300 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1222 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6001639.62994 | 2087602.93432 | 37.7122530470215 | -122.436168967218 | (37.7122530470215, -122.436168967218) | |||
| 45959 | 45959 | 177299 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1222 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6001664.56674 | 2087607.40628 | 37.7122667427937 | -122.43608309818 | (37.7122667427937, -122.43608309818) | |||
| 27125 | 27125 | 229246 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 4107 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6001682.48896 | 2103485.0455 | 37.755864094973 | -122.437157253802 | (37.755864094973, -122.437157253802) | |||
| 185165 | 185165 | 229252 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 171 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001736.09856 | 2107829.47275 | 37.767795879895296 | -122.43728291608 | (37.7677958798953, -122.43728291608) | |||
| 105250 | 105250 | 36894 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 4107 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51263 | 6001777.66119006 | 2103491.87307187 | 37.755888251327896 | -122.436828606579 | (37.7558882513279, -122.436828606579) | ||
| 10574 | 10574 | 115434 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 563 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777504 | 6001902.43576 | 2090213.7176 | 37.719436606695396 | -122.435447279293 | (37.7194366066954, -122.435447279293) | ||
| 157647 | 157647 | 81186 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 559 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/2003 12:00:00 AM | 3 | 6001911.78003 | 2090228.45376 | 37.719477599591706 | -122.43541603322599 | (37.7194775995917, -122.435416033226) | ||
| 162118 | 162118 | 81173 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 559 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/2003 12:00:00 AM | 2 | 6001918.1505 | 2090237.9821400002 | 37.7195041241905 | -122.435394694117 | (37.7195041241905, -122.435394694117) | ||
| 83869 | 83869 | 45168 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2695 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2001 12:00:00 AM | Permit Number 44017 | 6001924.94764161 | 2115681.1327225 | 37.7893652944435 | -122.437191954251 | (37.7893652944435, -122.437191954251) | |||
| 85426 | 85426 | 45170 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2695 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2001 12:00:00 AM | Permit Number 44017 | 6001924.94764161 | 2115681.1327225 | 37.7893652944435 | -122.437191954251 | (37.7893652944435, -122.437191954251) |
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");