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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93455 | 93455 | 41290 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 33 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/2000 12:00:00 AM | Permit Number 41966 | 6005810.71369941 | 2107063.80355088 | 37.765924322936705 | -122.423134859591 | (37.7659243229367, -122.423134859591) | ||
| 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) | ||
| 94622 | 94622 | 37843 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 117 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40136 | 6010376.80138594 | 2099288.55656196 | 37.7448318435542 | -122.406793605579 | (37.7448318435542, -122.406793605579) | ||
| 95345 | 95345 | 41295 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 154 Julian Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/2000 12:00:00 AM | Permit Number 41972 | 6006408.35563549 | 2106971.5871641003 | 37.7657048266582 | -122.421061187567 | (37.7657048266582, -122.421061187567) | ||
| 95476 | 95476 | 38289 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 40 Adair St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40372 | 6007297.20256077 | 2106986.85810046 | 37.765796822532295 | -122.41798793380501 | (37.7657968225323, -122.417987933805) | ||
| 95976 | 95976 | 40054 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1294 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41290 | 6016570.04020415 | 2092976.75616645 | 37.7278454926494 | -122.384938693931 | (37.7278454926494, -122.384938693931) | ||
| 96337 | 96337 | 38294 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 65 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40373 | 6007133.38425029 | 2106994.31986795 | 37.7658080895378 | -122.418555077027 | (37.7658080895378, -122.418555077027) | ||
| 96872 | 96872 | 38290 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 65 Capp St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40373 | 6007133.38425029 | 2106994.31986795 | 37.7658080895378 | -122.418555077027 | (37.7658080895378, -122.418555077027) | ||
| 97338 | 97338 | 88832 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 900 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2008 12:00:00 AM | 3x3 | Permit Number 51715 | 6009115.5 | 2098028.9 | 37.741302448690604 | -122.41106600773001 | (37.7413024486906, -122.41106600773) | ||
| 97886 | 97886 | 38293 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 65 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40373 | 6007133.38425029 | 2106994.31986795 | 37.7658080895378 | -122.418555077027 | (37.7658080895378, -122.418555077027) | ||
| 98285 | 98285 | 38292 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 65 Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40373 | 6007133.38425029 | 2106994.31986795 | 37.7658080895378 | -122.418555077027 | (37.7658080895378, -122.418555077027) | ||
| 98306 | 98306 | 38287 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 32 Adair St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40900 | 6007321.94599403 | 2106988.23094143 | 37.765801984592 | -122.417902448639 | (37.765801984592, -122.417902448639) | ||
| 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) | ||
| 100251 | 100251 | 41737 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1342-1344 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42176 | 6006947.20300055 | 2107647.30575448 | 37.767590551717 | -122.419245364711 | (37.767590551717, -122.419245364711) | ||
| 100367 | 100367 | 43909 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1179 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43508 | 6008693.56566701 | 2101689.35157322 | 37.7513295663287 | -122.41278363717699 | (37.7513295663287, -122.412783637177) | ||
| 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) | |||
| 101176 | 101176 | 45276 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 518 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44119 | 6007993.51053318 | 2096451.22471646 | 37.7369075159799 | -122.41483383306601 | (37.7369075159799, -122.414833833066) | ||
| 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) | ||
| 103312 | 103312 | 115991 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2211 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 2x4 | Permit Number 777665 | 6007568.4 | 2119969.3 | 37.8014587174384 | -122.417970318963 | (37.8014587174384, -122.417970318963) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 108968 | 108968 | 48972 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 135 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | Permit Number 46159 | 6003310.63727526 | 2108787.86549198 | 37.770516774816606 | -122.431905219461 | (37.7705167748166, -122.431905219461) | ||
| 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) | ||
| 110413 | 110413 | 45167 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2695 Sacramento St | 4 | 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) | |||
| 110896 | 110896 | 95988 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 10 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2011 12:00:00 AM | 3x3 | Permit Number 767640 | 6007158.9 | 2099647.0 | 37.745635472302205 | -122.417945934991 | (37.7456354723022, -122.417945934991) | ||
| 111090 | 111090 | 56244 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 259 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1973 12:00:00 AM | 3 | 3x4 | Permit Number 12370 | 6006755.08173393 | 2102278.34303033 | 37.752837807054 | -122.41952893293501 | (37.752837807054, -122.419528932935) | |
| 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) | ||
| 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) | ||
| 114183 | 114183 | 38288 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 40 Adair St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40372 | 6007297.20256077 | 2106986.85810046 | 37.765796822532295 | -122.41798793380501 | (37.7657968225323, -122.417987933805) | ||
| 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) | |||
| 115087 | 115087 | 16869 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 251 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52092 | 6005763.06398 | 2110312.25693 | 37.774841108223 | -122.42353064029498 | (37.774841108223, -122.423530640295) | |
| 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) | |||
| 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) | ||
| 116712 | 116712 | 46338 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 3703 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/13/2002 12:00:00 AM | Permit Number 44587 | 6005824.5079347 | 2100789.51596522 | 37.7486973702763 | -122.422641242993 | (37.7486973702763, -122.422641242993) | ||
| 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) | ||
| 118774 | 118774 | 45169 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2695 Sacramento St | 1 | 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) | |||
| 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) | ||
| 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) | ||
| 119963 | 119963 | 48596 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2828 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | Permit Number 45906 | 6006109.55880525 | 2120479.22122038 | 37.8027766188477 | -122.42305483532199 | (37.8027766188477, -122.423054835322) | ||
| 121122 | 121122 | 17695 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1100X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2004 12:00:00 AM | 3 | 3X3 | 6002388.9320519995 | 2112303.1746509997 | 37.780116643601296 | -122.435344894499 | (37.7801166436013, -122.435344894499) | ||
| 121767 | 121767 | 46558 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 3632 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2003 12:00:00 AM | Permit Number 44695 | 6005360.40468284 | 2105494.4369831 | 37.7615897924042 | -122.424580741803 | (37.7615897924042, -122.424580741803) | ||
| 122356 | 122356 | 48710 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45977 | 6002865.90865477 | 2096146.69511849 | 37.735781899273 | -122.432540466241 | (37.735781899273, -122.432540466241) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 124279 | 124279 | 46337 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 3703 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51341 | 6005824.5079347 | 2100789.51596522 | 37.7486973702763 | -122.422641242993 | (37.7486973702763, -122.422641242993) | |
| 124490 | 124490 | 38286 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 29 Adair St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40899 | 6007332.77993019 | 2106936.7520651002 | 37.7656612453629 | -122.417861326827 | (37.7656612453629, -122.417861326827) | |||
| 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) | ||
| 126271 | 126271 | 39987 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1430 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 6 | Permit Number 41245 | 6017109.13931221 | 2093820.25947236 | 37.7301913909688 | -122.383133682915 | (37.7301913909688, -122.383133682915) | |
| 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) | ||
| 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) | ||
| 127609 | 127609 | 39141 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1088 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40819 | 6007414.12012463 | 2100977.25645313 | 37.749302417702104 | -122.417157664156 | (37.7493024177021, -122.417157664156) | ||
| 128118 | 128118 | 12993 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 330 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | 3 | 3X3 | 6010724.12169 | 2120710.3451799997 | 37.8036705448693 | -122.40710231783899 | (37.8036705448693, -122.407102317839) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 132807 | 132807 | 192813 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1251 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013542.5057 | 2106139.39713 | 37.763819396166895 | -122.39632719834299 | (37.7638193961669, -122.396327198343) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 135563 | 135563 | 229255 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 260 Randall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003887.38012 | 2097809.34417 | 37.7404050277631 | -122.42912735293801 | (37.7404050277631, -122.429127352938) | |||
| 136112 | 136112 | 229230 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 265 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006749.35138 | 2102271.82416 | 37.7528195849561 | -122.419548287136 | (37.7528195849561, -122.419548287136) | |||
| 136148 | 136148 | 229222 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 67 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005445.58133 | 2108574.74537 | 37.7700523958333 | -122.424505263025 | (37.7700523958333, -122.424505263025) | |||
| 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) | ||||
| 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) | |
| 140817 | 140817 | 88831 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 900 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2008 12:00:00 AM | 3x3 | Permit Number 51715 | 6009115.5 | 2098028.9 | 37.741302448690604 | -122.41106600773001 | (37.7413024486906, -122.41106600773) | ||
| 142873 | 142873 | 37270 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 3722 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39810 | 6003578.77249291 | 2103641.69607352 | 37.756401829721604 | -122.43061046837 | (37.7564018297216, -122.43061046837) | ||
| 142940 | 142940 | 42243 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 547 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42492 | 6010057.93942853 | 2111817.75656126 | 37.779216340569604 | -122.408779938797 | (37.7792163405696, -122.408779938797) | ||
| 143881 | 143881 | 42244 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 547 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42492 | 6010057.93942853 | 2111817.75656126 | 37.779216340569604 | -122.408779938797 | (37.7792163405696, -122.408779938797) | ||
| 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) | ||
| 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) | |||
| 147025 | 147025 | 229241 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 900 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009182.189669999 | 2098038.44408 | 37.7413323942725 | -122.410836091326 | (37.7413323942725, -122.410836091326) | |||
| 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) | |
| 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) | |||
| 148656 | 148656 | 229256 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 260 Randall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003866.23298 | 2097822.81814 | 37.740440827071794 | -122.429201431925 | (37.7404408270718, -122.429201431925) | |||
| 149336 | 149336 | 229229 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 25 Adair St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007282.8727 | 2106946.5610700003 | 37.7656853698119 | -122.41803464088001 | (37.7656853698119, -122.41803464088) | |||
| 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) | |||
| 151211 | 151211 | 111160 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003321.77346 | 2119803.50555 | 37.8007635719416 | -122.43265369092899 | (37.8007635719416, -122.432653690929) | |||
| 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) | |||
| 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) | |||
| 151995 | 151995 | 229259 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 269 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003857.56826 | 2097789.37323 | 37.7403485044927 | -122.429229006915 | (37.7403485044927, -122.429229006915) | |||
| 154205 | 154205 | 60303 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 678 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1982 12:00:00 AM | 6 | Permit Number 19870 | 6009154.33491 | 2088966.77185 | 37.7164219496995 | -122.410292044649 | (37.7164219496995, -122.410292044649) | ||
| 154752 | 154752 | 111162 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6003355.09781 | 2119808.05454 | 37.8007779520905 | -122.43253870000001 | (37.8007779520905, -122.4325387) | |||
| 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) | ||
| 158998 | 158998 | 130433 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 550 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004538.94577 | 2111043.55474 | 37.776779903004 | -122.427817240371 | (37.776779903004, -122.427817240371) | |||
| 160739 | 160739 | 229218 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 154 Julian Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006411.90444 | 2106966.83782 | 37.7656919861306 | -122.42104857575 | (37.7656919861306, -122.42104857575) | |||
| 160990 | 160990 | 229220 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 10 Lundys Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6007188.55641 | 2099623.37433 | 37.745572270542795 | -122.41784171294701 | (37.7455722705428, -122.417841712947) | |||
| 161509 | 161509 | 115023 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 618 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | 6 | Permit Number 775874 | 6003941.0094099995 | 2091735.88537 | 37.7237317121275 | -122.42850912299299 | (37.7237317121275, -122.428509122993) | ||
| 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) | ||
| 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) | |
| 162899 | 162899 | 229248 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 436 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003539.13196 | 2102171.5132 | 37.752362809400104 | -122.430642653946 | (37.7523628094001, -122.430642653946) | |||
| 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) | ||
| 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) | |||
| 164189 | 164189 | 177291 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 400 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6003906.05607 | 2090945.9900200001 | 37.721560855742105 | -122.428573672752 | (37.7215608557421, -122.428573672752) | |||
| 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) | |||
| 164919 | 164919 | 229227 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 518 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008002.667119999 | 2096426.21911 | 37.7368393705501 | -122.414800405411 | (37.7368393705501, -122.414800405411) |
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");