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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2657 | 2657 | 229219 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1342 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 15 | Width 2ft | Permit Number 42176 | 6006959.3891199995 | 2107664.54838 | 37.7676385821924 | -122.419204437651 | (37.7676385821924, -122.419204437651) | |
| 3106 | 3106 | 229223 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 587 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1988 12:00:00 AM | 1 | Width 2ft | Permit Number 25015 | 6002801.67142 | 2098869.6080099996 | 37.743254746413896 | -122.432957032239 | (37.7432547464139, -122.432957032239) | |
| 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) | |
| 4851 | 4851 | 253692 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 68 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005803.0 | 2109684.0 | 37.77311832041121 | -122.42334782195499 | (37.7731183204112, -122.423347821955) | ||||
| 4852 | 4852 | 253689 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 60 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005848.0 | 2109690.0 | 37.7731373345919 | -122.42319258754601 | (37.7731373345919, -122.423192587546) | ||||
| 4855 | 4855 | 253691 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 60 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005848.0 | 2109690.0 | 37.7731373345919 | -122.42319258754601 | (37.7731373345919, -122.423192587546) | ||||
| 4856 | 4856 | 253690 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 60 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005848.0 | 2109690.0 | 37.7731373345919 | -122.42319258754601 | (37.7731373345919, -122.423192587546) | ||||
| 4858 | 4858 | 10238 | DPW Maintained 3 | Magnolia doltsopa :: Himalayan Magnolia 187 | 48 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2017 12:00:00 AM | 3 | 3X3 | 6005948.4469202 | 2109689.9882841 | 37.7731429705185 | -122.42284512734301 | (37.7731429705185, -122.422845127343) | ||
| 6579 | 6579 | 18881 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2323 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/2009 12:00:00 AM | 3 | 2X2 | 6003542.78856 | 2115901.08421 | 37.790061057729105 | -122.43161012300399 | (37.7900610577291, -122.431610123004) | ||
| 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) | ||
| 10005 | 10005 | 9993 | DPW Maintained 3 | Magnolia doltsopa :: Himalayan Magnolia 187 | 65 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2001 12:00:00 AM | 6 | 2X2 | 6005451.908597 | 2108608.7477450003 | 37.770146115502 | -122.42448579603202 | (37.770146115502, -122.424485796032) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 12725 | 12725 | 68270 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 425 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773761 | 6009804.05619 | 2092417.85671 | 37.725934311003705 | -122.408289550324 | (37.7259343110037, -122.408289550324) | |
| 15826 | 15826 | 27135 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1921 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1999 12:00:00 AM | 7 | 2X3 | 6011851.93655 | 2095690.98382 | 37.735036100323704 | -122.401440051024 | (37.7350361003237, -122.401440051024) | ||
| 17270 | 17270 | 27639 | DPW Maintained 3 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2787 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2000 12:00:00 AM | 6 | 3X3 | 6009853.94655 | 2101110.41145 | 37.7498049873079 | -122.408730050863 | (37.7498049873079, -122.408730050863) | ||
| 17283 | 17283 | 26853 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 624 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1998 12:00:00 AM | 24 | 3X3 | 6005561.832230001 | 2105304.71691 | 37.7610802392886 | -122.42387059436899 | (37.7610802392886, -122.423870594369) | ||
| 17305 | 17305 | 4491 | DPW Maintained 3 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1608 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1998 12:00:00 AM | 3 | 3X3 | 6004562.86857 | 2099453.04475 | 37.744956468756705 | -122.42690881361601 | (37.7449564687567, -122.426908813616) | ||
| 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) | ||
| 17910 | 17910 | 38285 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 27 Adair St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/08/1998 12:00:00 AM | 12 | 3x12 | Permit Number 40369 | 6007338.83954453 | 2106937.08827094 | 37.7656625095236 | -122.417840391728 | (37.7656625095236, -122.417840391728) |
| 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) | ||
| 21245 | 21245 | 27640 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2797 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2000 12:00:00 AM | 6 | 3X3 | 6009854.42856 | 2101083.40112 | 37.7497308499102 | -122.40872647876101 | (37.7497308499102, -122.408726478761) | ||
| 21483 | 21483 | 7016 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1055 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6002352.4572 | 2110178.4231 | 37.77428053605671 | -122.43531904958999 | (37.7742805360567, -122.43531904959) | |||
| 21704 | 21704 | 16927 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 516 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | 3 | 3X3 | 6004360.990619999 | 2110167.09094 | 37.7743632798821 | -122.428370356734 | (37.7743632798821, -122.428370356734) | ||
| 23189 | 23189 | 7018 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1055 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2008 12:00:00 AM | 2 | 3X3 | 6002378.8301 | 2110180.8206 | 37.7742886166676 | -122.435227992558 | (37.7742886166676, -122.435227992558) | ||
| 23446 | 23446 | 177294 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 570 Edinburgh St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6002574.43441 | 2090375.15322 | 37.7199180155891 | -122.433135958685 | (37.7199180155891, -122.433135958685) | |||
| 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) | |
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 27444 | 27444 | 177293 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 570 Edinburgh St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6002594.98621 | 2090406.0237099999 | 37.720003944896895 | -122.433067122761 | (37.7200039448969, -122.433067122761) | |||
| 31918 | 31918 | 229261 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2617 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009984.45916 | 2105005.31178 | 37.7605068225536 | -122.40855344831002 | (37.7605068225536, -122.40855344831) | |||
| 32860 | 32860 | 117202 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 298 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013997.81154 | 2105821.62372 | 37.762972185334796 | -122.39473016695801 | (37.7629721853348, -122.394730166958) | |||
| 35347 | 35347 | 40029 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1637 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 3 | Permit Number 41272 | 6014869.44662 | 2095922.83463 | 37.7358406185575 | -122.391023557209 | (37.7358406185575, -122.391023557209) | |
| 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) | |||
| 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) | |||
| 37061 | 37061 | 177292 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 400 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6003897.6879900005 | 2090933.24803 | 37.7215253954716 | -122.428601691123 | (37.7215253954716, -122.428601691123) | |||
| 37607 | 37607 | 229242 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 490 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007221.538980001 | 2104492.64849 | 37.7589440445439 | -122.418072800033 | (37.7589440445439, -122.418072800033) | |||
| 39443 | 39443 | 177290 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 231 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004061.30791 | 2089085.46996 | 37.7164610594049 | -122.42790450158701 | (37.7164610594049, -122.427904501587) | |||
| 39507 | 39507 | 229226 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 546 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007812.08689 | 2096313.01345 | 37.7365178224466 | -122.415451314937 | (37.7365178224466, -122.415451314937) | |||
| 40121 | 40121 | 117201 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 298 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013997.02726 | 2105851.29667 | 37.7630536171528 | -122.394734957662 | (37.7630536171528, -122.394734957662) | |||
| 40921 | 40921 | 55180 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 91 Gillette Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/1987 12:00:00 AM | 4 | Permit Number 24627 | 6013135.97557 | 2086935.8514599998 | 37.7110678340902 | -122.396387174153 | (37.7110678340902, -122.396387174153) | ||
| 42631 | 42631 | 229243 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 310 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6006167.98483 | 2101344.3742299997 | 37.750240256504505 | -122.421492901096 | (37.7502402565045, -122.421492901096) | |||
| 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) | |||
| 44523 | 44523 | 111165 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6003411.20248 | 2119815.94235 | 37.800802791376796 | -122.432345118256 | (37.8008027913768, -122.432345118256) | |||
| 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) | |||
| 47084 | 47084 | 49781 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 308@ BLANKEN Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 6 | Permit Number 46566 | 6012565.764330001 | 2086991.30055 | 37.71118833875371 | -122.39836186320801 | (37.7111883387537, -122.398361863208) | |
| 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) | |||
| 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) | |||
| 48445 | 48445 | 229245 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1604 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005879.33617 | 2099593.72705 | 37.7454170997346 | -122.42236669586399 | (37.7454170997346, -122.422366695864) | |||
| 49201 | 49201 | 229244 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1098 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006303.6643900005 | 2103203.60326 | 37.755352921212705 | -122.421155714687 | (37.7553529212127, -122.421155714687) | |||
| 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) | |||
| 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) | |||
| 53592 | 53592 | 115990 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2211 Leavenworth St | 1 | 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) | |
| 53706 | 53706 | 111161 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003338.31122 | 2119805.5444900002 | 37.8007701082019 | -122.432596609162 | (37.8007701082019, -122.432596609162) | |||
| 54965 | 54965 | 229235 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1626 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6003320.17625 | 2098729.19184 | 37.742898592403606 | -122.431154158661 | (37.7428985924036, -122.431154158661) | |||
| 55183 | 55183 | 229217 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 3703 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005775.741359999 | 2100791.00452 | 37.74869870607721 | -122.42280998341101 | (37.7486987060772, -122.422809983411) | |||
| 55752 | 55752 | 229239 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 900 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009149.94921 | 2098041.7895299997 | 37.7413397723193 | -122.410947804196 | (37.7413397723193, -122.410947804196) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 61006 | 61006 | 137580 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1150 PIERCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6002381.2868 | 2112341.0686 | 37.7802202566686 | -122.43537405428499 | (37.7802202566686, -122.435374054285) | |||
| 61277 | 61277 | 229249 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 310 Liberty St | 52 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6003824.40718 | 2103923.16543 | 37.757188590409704 | -122.429781053062 | (37.7571885904097, -122.429781053062) | |||
| 61466 | 61466 | 111164 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6003392.2553900005 | 2119813.00098 | 37.8007936407819 | -122.43241047286199 | (37.8007936407819, -122.432410472862) | |||
| 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) | |||
| 63194 | 63194 | 229236 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 34 Natick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003050.62642 | 2095609.5777099999 | 37.7343175708005 | -122.431863485408 | (37.7343175708005, -122.431863485408) | |||
| 65228 | 65228 | 229257 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 210 Moffitt St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002381.14665 | 2097165.58245 | 37.7385520268501 | -122.434289296035 | (37.7385520268501, -122.434289296035) | |||
| 66841 | 66841 | 229233 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 4233 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002320.97141 | 2101183.15228 | 37.7495799175888 | -122.43478457336701 | (37.7495799175888, -122.434784573367) | |||
| 67481 | 67481 | 229221 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 850 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009897.05589 | 2104252.20928 | 37.7584340776962 | -122.408802604559 | (37.7584340776962, -122.408802604559) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 70933 | 70933 | 229228 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 588 Ogden Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6007775.88717 | 2096147.34568 | 37.7360609002791 | -122.41556474731199 | (37.7360609002791, -122.415564747312) | |||
| 71063 | 71063 | 143041 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 590 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6009568.471 | 2120534.3867 | 37.8031226669303 | -122.411089086343 | (37.8031226669303, -122.411089086343) | |||
| 72289 | 72289 | 229225 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 4015 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003754.02498 | 2100677.61604 | 37.748273089348395 | -122.42979297446001 | (37.7482730893484, -122.42979297446) | |||
| 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) | |||
| 75918 | 75918 | 229250 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 396 Cumberland St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6003147.80925 | 2104494.52044 | 37.7587190575556 | -122.432161790553 | (37.7587190575556, -122.432161790553) | |||
| 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) | |
| 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) | ||
| 78310 | 78310 | 88833 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 900 Powhattan Ave | 3 | 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) | ||
| 78315 | 78315 | 85278 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 506 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49567 | 6004562.0 | 2110191.0 | 37.77444030054121 | -122.42767673141701 | (37.7744403005412, -122.427676731417) | |||
| 78723 | 78723 | 41289 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 27 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/2000 12:00:00 AM | Permit Number 41965 | 6005808.60053678 | 2107097.83336605 | 37.76601764148 | -122.42314458768 | (37.76601764148, -122.42314458768) | ||
| 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) | ||
| 79279 | 79279 | 42075 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 125 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/2005 12:00:00 AM | Permit Number 42387 | 6009870.15357172 | 2099865.41345763 | 37.7463874047531 | -122.408586191488 | (37.7463874047531, -122.408586191488) | ||
| 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) | |||
| 80651 | 80651 | 42814 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 3944 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | Permit Number 42759 | 6003333.22216153 | 2105381.87042866 | 37.761166018655295 | -122.43158389801201 | (37.7611660186553, -122.431583898012) | ||
| 80724 | 80724 | 38291 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 65 Capp St | 4 | 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) | ||
| 81518 | 81518 | 50865 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 238 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/2004 12:00:00 AM | Permit Number 47380 | 6007739.99301992 | 2097997.57355167 | 37.741139201026 | -122.415819822319 | (37.741139201026, -122.415819822319) | ||
| 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) | ||
| 82721 | 82721 | 40458 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 65 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41543 | 6008355.36167983 | 2098222.23165667 | 37.7417906382072 | -122.413707978506 | (37.7417906382072, -122.413707978506) | ||
| 83619 | 83619 | 84949 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1305 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/1983 12:00:00 AM | 3x3 | Permit Number 49351 | 6009354.0 | 2101579.0 | 37.751063612674706 | -122.41049197906901 | (37.7510636126747, -122.410491979069) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 87821 | 87821 | 41292 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 46 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2000 12:00:00 AM | Permit Number 41968 | 6005763.36283856 | 2106987.3220579 | 37.7657116506856 | -122.42329319937201 | (37.7657116506856, -122.423293199372) | |||
| 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) | ||
| 89536 | 89536 | 37844 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 117 Brewster St | 2 | 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) |
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");