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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 165675 | 165675 | 177297 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 175 Nueva Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6012935.72172 | 2087140.5475400002 | 37.711618743479704 | -122.397093648265 | (37.7116187434797, -122.397093648265) | |||
| 167104 | 167104 | 130437 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2201 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007591.4222099995 | 2119948.52727 | 37.80140297642279 | -122.417889178244 | (37.8014029764228, -122.417889178244) | |||
| 167365 | 167365 | 111163 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6003374.28365 | 2119810.9912900003 | 37.80078710360971 | -122.43247251891898 | (37.8007871036097, -122.432472518919) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 172975 | 172975 | 229247 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 601 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002381.85851 | 2102645.6211099997 | 37.753598966245605 | -122.434678587346 | (37.7535989662456, -122.434678587346) | |||
| 173782 | 173782 | 229237 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 224 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004172.07476 | 2097038.4299599999 | 37.7383043850279 | -122.42808806671101 | (37.7383043850279, -122.428088066711) | |||
| 174121 | 174121 | 229216 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 33 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005800.05935 | 2107051.19883 | 37.765889112110706 | -122.423170814787 | (37.7658891121107, -122.423170814787) | |||
| 174843 | 174843 | 192814 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 1251 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6013571.381680001 | 2106139.70119 | 37.763821837831394 | -122.396227345714 | (37.7638218378314, -122.396227345714) | |||
| 176571 | 176571 | 246803 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 117 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6010372.78366 | 2099322.13571 | 37.7449238197814 | -122.40680986429301 | (37.7449238197814, -122.406809864293) | |||
| 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) | |||
| 177602 | 177602 | 229240 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 900 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009167.29555 | 2098038.41743 | 37.7413314859486 | -122.410887588289 | (37.7413314859486, -122.410887588289) | |||
| 180613 | 180613 | 229224 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 428 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003023.34739 | 2099505.6242400003 | 37.745013670150705 | -122.432235947738 | (37.7450136701507, -122.432235947738) | |||
| 180885 | 180885 | 246804 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 117 Brewster St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6010378.07148 | 2099339.08892 | 37.7449706654762 | -122.406792774468 | (37.7449706654762, -122.406792774468) | |||
| 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) | |||
| 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) | |||
| 182859 | 182859 | 130436 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2201 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007584.36539 | 2119972.20513 | 37.8014675927187 | -122.417915277469 | (37.8014675927187, -122.417915277469) | |||
| 183722 | 183722 | 130435 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 2127 Broadway | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6003305.56754 | 2117513.80582 | 37.7944757298119 | -122.43254612932199 | (37.7944757298119, -122.432546129322) |
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");