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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4665 | 4665 | 160559 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 710 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:15:00 PM | 3 | Width 0ft | 6002373.4779900005 | 2089525.5110400002 | 37.7175736853632 | -122.433769899784 | (37.7175736853632, -122.433769899784) | |
| 4718 | 4718 | 160845 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 669 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 03:09:00 PM | 3 | Width 0ft | 6002769.79165 | 2089568.5134700001 | 37.7177142412877 | -122.432403094831 | (37.7177142412877, -122.432403094831) | |
| 4728 | 4728 | 160846 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 669 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 12:20:00 PM | 3 | Width 0ft | 6002781.71244 | 2089588.8302099998 | 37.717770702526295 | -122.432363340291 | (37.7177707025263, -122.432363340291) | |
| 177073 | 177073 | 207611 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 64 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5997222.96665 | 2089595.38167 | 37.717471924360794 | -122.45157781718599 | (37.7174719243608, -122.451577817186) | |||
| 41426 | 41426 | 176252 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 95 Delta St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010107.1247 | 2089599.03617 | 37.7182113811213 | -122.407043259958 | (37.7182113811213, -122.407043259958) | |||
| 140919 | 140919 | 60458 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 64 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | 8 | 3x3 | Permit Number 20044 | 5997231.487462901 | 2089612.30707346 | 37.717518885545005 | -122.45154958496201 | (37.717518885545, -122.451549584962) |
| 151697 | 151697 | 176253 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 95 Delta St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010117.92765 | 2089629.2495 | 37.7182949452416 | -122.407008046982 | (37.7182949452416, -122.407008046982) | |||
| 144046 | 144046 | 60455 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 60 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | Permit Number 20041 | 5997245.01433776 | 2089631.74975866 | 37.7175730452663 | -122.451504230583 | (37.7175730452663, -122.451504230583) | ||
| 34684 | 34684 | 52253 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 477 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | 6 | Permit Number 48420 | 6010242.5453699995 | 2089633.7594299999 | 37.718314301343796 | -122.406577611683 | (37.7183143013438, -122.406577611683) | ||
| 55547 | 55547 | 52985 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 483 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2006 12:00:00 AM | 5 | Permit Number 48967 | 6010218.63808 | 2089641.8160400002 | 37.7183350855707 | -122.40666081696101 | (37.7183350855707, -122.406660816961) | ||
| 130731 | 130731 | 207610 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 51 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997347.38565 | 2089696.67863 | 37.7177571866363 | -122.451155061159 | (37.7177571866363, -122.451155061159) | |||
| 57297 | 57297 | 176254 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1101 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011871.08574 | 2089770.5771299999 | 37.718780952366096 | -122.400958007209 | (37.7187809523661, -122.400958007209) | |||
| 39850 | 39850 | 207617 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 385 Victoria St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993228.76427 | 2089783.4849099999 | 37.717758864755794 | -122.46539747963001 | (37.7177588647558, -122.46539747963) | |||
| 147544 | 147544 | 176231 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 670 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001253.10056 | 2089784.4863200001 | 37.7182211342895 | -122.437661063033 | (37.7182211342895, -122.437661063033) | |||
| 4426 | 4426 | 160887 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 687 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:35:00 AM | 3 | Width 0ft | 6002277.9096800005 | 2089801.2576099997 | 37.7183254007788 | -122.434119936579 | (37.7183254007788, -122.434119936579) | |
| 157109 | 157109 | 207616 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 385 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993229.18719 | 2089803.6198599997 | 37.7178141748665 | -122.46539747963001 | (37.7178141748665, -122.46539747963) | |||
| 98142 | 98142 | 48571 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 301 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | |||
| 125846 | 125846 | 48572 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 301 Shields St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | |||
| 128633 | 128633 | 48573 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 301 Shields St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | |||
| 79370 | 79370 | 34891 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 95 Ward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.718924606748296 | -122.401046743519 | (37.7189246067483, -122.401046743519) | |||
| 142100 | 142100 | 34892 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 95 Ward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.718924606748296 | -122.401046743519 | (37.7189246067483, -122.401046743519) | |||
| 4376 | 4376 | 160888 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 679 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 08:26:00 AM | 3 | Width 0ft | 6002304.816330001 | 2089843.73714 | 37.7184435671833 | -122.43402996661999 | (37.7184435671833, -122.43402996662) | |
| 169080 | 169080 | 51030 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1085 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 5 | Permit Number 47506 | 6011828.2745 | 2089900.6227799999 | 37.7191356431884 | -122.401115122362 | (37.7191356431884, -122.401115122362) | ||
| 153913 | 153913 | 51031 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1085 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 6 | Permit Number 47506 | 6011820.571409999 | 2089923.6648799998 | 37.7191984823926 | -122.40114336739799 | (37.7191984823926, -122.401143367398) | ||
| 3954 | 3954 | 216641 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 8 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:34:00 PM | 3 | Width 2ft | 5996523.62122 | 2089940.0235400002 | 37.7183781559031 | -122.45401999544399 | (37.7183781559031, -122.454019995444) | ||
| 11147 | 11147 | 83378 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 586 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52310 | 6003277.11077 | 2089949.83191 | 37.718790012118795 | -122.430676716663 | (37.7187900121188, -122.430676716663) | |
| 3943 | 3943 | 216737 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 11 Lee Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/04/2017 02:31:00 PM | 3 | Width 2ft | 5996481.70655 | 2089974.5093900003 | 37.7184704425356 | -122.45416736555799 | (37.7184704425356, -122.454167365558) | ||
| 169187 | 169187 | 58274 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 679 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 11 | Permit Number 28518 | 6002069.6967400005 | 2089980.14992 | 37.718804779905206 | -122.43485242630301 | (37.7188047799052, -122.434852426303) | |
| 3997 | 3997 | 251702 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 910 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:10:00 AM | 3 | 3x3 | 5995959.0 | 2089989.0 | 37.7184802428284 | -122.455975181765 | (37.7184802428284, -122.455975181765) | ||
| 167475 | 167475 | 65612 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 676 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 12 | Permit Number 28517 | 6002045.90134 | 2090021.05349 | 37.718915740944794 | -122.434937601102 | (37.7189157409448, -122.434937601102) | |
| 68961 | 68961 | 78365 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 671 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 5 | 6002103.17705 | 2090031.785 | 37.7189484591704 | -122.434740388752 | (37.7189484591704, -122.434740388752) | ||
| 10324 | 10324 | 108369 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 611 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773814 | 6001475.26516 | 2090061.55368 | 37.7189945287407 | -122.436912960177 | (37.7189945287407, -122.436912960177) |
| 185264 | 185264 | 84126 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1045 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50691 | 6011772.837180001 | 2090087.8836 | 37.7196467305931 | -122.401319901612 | (37.7196467305931, -122.401319901612) | |
| 51911 | 51911 | 65610 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 655 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 10 | Permit Number 28515 | 6002150.8874699995 | 2090106.59961 | 37.71915659198321 | -122.434580819343 | (37.7191565919832, -122.434580819343) | |
| 4750 | 4750 | 160919 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 656 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:14:00 AM | 3 | Width 0ft | 6002115.87134 | 2090131.5374900002 | 37.719223077968294 | -122.43470363886001 | (37.7192230779683, -122.43470363886) | |
| 74239 | 74239 | 78311 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 651 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 6 | 6002171.16475 | 2090137.2340799998 | 37.7192418585039 | -122.43451291783701 | (37.7192418585039, -122.434512917837) | ||
| 39678 | 39678 | 78352 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 647 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 5 | 6002178.01905 | 2090148.09572 | 37.71927207124 | -122.43449000133499 | (37.71927207124, -122.434490001335) | ||
| 4065 | 4065 | 216746 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 935 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:04:00 AM | 3 | Width 3ft | 5995893.729730001 | 2090148.9347 | 37.71891563932461 | -122.456212350117 | (37.7189156393246, -122.456212350117) | ||
| 124989 | 124989 | 66231 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 299 Tara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/1994 12:00:00 AM | Permit Number 29328 | 5997721.47171687 | 2090151.04761265 | 37.7190261896858 | -122.449894746819 | (37.7190261896858, -122.449894746819) | ||
| 4754 | 4754 | 160918 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:50:00 AM | 3 | Width 0ft | 6002126.85051 | 2090151.3483900002 | 37.7192780975889 | -122.43466710393 | (37.7192780975889, -122.43466710393) | |
| 3948 | 3948 | 251682 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 40 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:02:00 PM | 3 | 3x3 | 5996554.0 | 2090155.0 | 37.7189701727187 | -122.45393050605401 | (37.7189701727187, -122.453930506054) | ||
| 131570 | 131570 | 207608 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 299 Tara St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5997723.56116 | 2090176.57785 | 37.71909640934621 | -122.44988936340799 | (37.7190964093462, -122.449889363408) | |||
| 4770 | 4770 | 160917 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 646 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:31:00 AM | 3 | Width 0ft | 6002146.555269999 | 2090180.2898900001 | 37.719358683138 | -122.434601060409 | (37.719358683138, -122.434601060409) | |
| 161926 | 161926 | 207609 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 299 Tara St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997727.90986 | 2090186.7844599998 | 37.7191246831501 | -122.44987506687599 | (37.7191246831501, -122.449875066876) | |||
| 3923 | 3923 | 251683 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 46 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:00:00 PM | 3 | 3x3 | 5996555.0 | 2090205.0 | 37.7191075183288 | -122.453930658436 | (37.7191075183288, -122.453930658436) | ||
| 145243 | 145243 | 85040 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 946 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2007 12:00:00 AM | Permit Number 49388 | 5995963.8 | 2090215.2 | 37.7191016102225 | -122.455974934213 | (37.7191016102225, -122.455974934213) | |||
| 3959 | 3959 | 216642 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 50 Lee Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/04/2017 01:57:00 PM | 3 | Width 2ft | 5996528.83108 | 2090217.4765599999 | 37.7191402755735 | -122.45402201441999 | (37.7191402755735, -122.45402201442) | ||
| 116195 | 116195 | 65471 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 50 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1989 12:00:00 AM | Permit Number 28352 | 5995649.70460039 | 2090232.90843382 | 37.719132200507296 | -122.457061914585 | (37.7191322005073, -122.457061914585) | ||
| 4049 | 4049 | 216738 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 55 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:15:00 AM | 3 | Width 3ft | 5996190.92128 | 2090248.8159599998 | 37.7192069450213 | -122.455192295882 | (37.7192069450213, -122.455192295882) | ||
| 4761 | 4761 | 160908 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 615 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:06:00 PM | 3 | Width 0ft | 6002284.55838 | 2090317.50092 | 37.7197432674186 | -122.434133839205 | (37.7197432674186, -122.434133839205) | |
| 86352 | 86352 | 49496 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2X ORDWAY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2003 12:00:00 AM | 16 | 3x3 | Permit Number 46411 | 6011821.0 | 2090323.0 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | |
| 121004 | 121004 | 49497 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2X ORDWAY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2003 12:00:00 AM | 7 | 3x3 | Permit Number 46411 | 6011821.0 | 2090323.0 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | |
| 139340 | 139340 | 49495 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2X ORDWAY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2003 12:00:00 AM | 9 | 3x3 | Permit Number 46411 | 6011821.0 | 2090323.0 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | |
| 139972 | 139972 | 49494 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2X ORDWAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46411 | 6011821.0 | 2090323.0 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | |
| 144170 | 144170 | 49493 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2X ORDWAY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2003 12:00:00 AM | 8 | 3x3 | Permit Number 46411 | 6011821.0 | 2090323.0 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | |
| 111587 | 111587 | 65460 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 967 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1989 12:00:00 AM | Permit Number 28338 | 5995896.95851716 | 2090334.96533864 | 37.7194266209016 | -122.45621463281 | (37.7194266209016, -122.45621463281) | ||
| 186789 | 186789 | 176247 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011833.809309999 | 2090345.7505400002 | 37.720358182462704 | -122.401127251532 | (37.7203581824627, -122.401127251532) | |||
| 178205 | 178205 | 207606 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 967 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995896.38015 | 2090348.1044299998 | 37.7194626645441 | -122.45621758148701 | (37.7194626645441, -122.456217581487) | |||
| 74948 | 74948 | 176246 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011847.19322 | 2090350.44098 | 37.72037180809671 | -122.401081316846 | (37.7203718080967, -122.401081316846) | |||
| 62288 | 62288 | 84009 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 980 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50690 | 6011658.3598 | 2090351.5567 | 37.7203643356392 | -122.401734134722 | (37.7203643356392, -122.401734134722) | |
| 52431 | 52431 | 176245 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6011861.55971 | 2090354.4495299999 | 37.72038361619379 | -122.401031937775 | (37.7203836161938, -122.401031937775) | |||
| 153042 | 153042 | 207605 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 68 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994168.04761 | 2090360.8156299999 | 37.71939820295 | -122.46219266815599 | (37.71939820295, -122.462192668156) | |||
| 70812 | 70812 | 176244 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011881.091109999 | 2090360.91966 | 37.720402471380204 | -122.400964878027 | (37.7204024713802, -122.400964878027) | |||
| 150014 | 150014 | 176243 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011901.96297 | 2090368.71329 | 37.72042503536171 | -122.40089327761801 | (37.7204250353617, -122.400893277618) | |||
| 79353 | 79353 | 39646 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 72 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41040 | 5994176.513717599 | 2090402.3957613998 | 37.719512859484794 | -122.462166418076 | (37.7195128594848, -122.462166418076) | ||
| 186210 | 186210 | 176239 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 901 Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009040.83689 | 2090406.80665 | 37.7203696227506 | -122.41078599367701 | (37.7203696227506, -122.410785993677) | |||
| 164326 | 164326 | 176240 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 901 Olmstead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009052.31678 | 2090410.35877 | 37.7203800198047 | -122.41074656201 | (37.7203800198047, -122.41074656201) | |||
| 49953 | 49953 | 176241 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 901 Olmstead St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009064.8482099995 | 2090413.67882 | 37.7203898385876 | -122.410703479104 | (37.7203898385876, -122.410703479104) | |||
| 176059 | 176059 | 176242 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 901 Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009078.67243 | 2090418.2351099998 | 37.7204031242939 | -122.41065601467 | (37.7204031242939, -122.41065601467) | |||
| 107267 | 107267 | 39647 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 76 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41041 | 5994176.75103926 | 2090428.14003501 | 37.719583560751 | -122.46216746380101 | (37.719583560751, -122.462167463801) | ||
| 84897 | 84897 | 95669 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 Colby St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110.0 | 2090446.0 | 37.720481117261706 | -122.41054968459 | (37.7204811172617, -122.41054968459) | |
| 86497 | 86497 | 95668 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 Colby St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110.0 | 2090446.0 | 37.720481117261706 | -122.41054968459 | (37.7204811172617, -122.41054968459) | |
| 90403 | 90403 | 95670 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 Colby St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110.0 | 2090446.0 | 37.720481117261706 | -122.41054968459 | (37.7204811172617, -122.41054968459) | |
| 144330 | 144330 | 95671 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 Colby St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110.0 | 2090446.0 | 37.720481117261706 | -122.41054968459 | (37.7204811172617, -122.41054968459) | |
| 4079 | 4079 | 162895 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 989 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 07:58:00 AM | 3 | Width 0ft | 5995899.78819 | 2090467.68802 | 37.7197912084714 | -122.45621444283998 | (37.7197912084714, -122.45621444284) | ||
| 96157 | 96157 | 40429 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 516 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | Permit Number 41524 | 6002015.10880124 | 2090488.09848269 | 37.7201963938126 | -122.435077424443 | (37.7201963938126, -122.435077424443) | |||
| 4024 | 4024 | 162893 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 989 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 07:55:00 AM | 3 | Width 0ft | 5995900.9159699995 | 2090507.1472900002 | 37.719899619041705 | -122.45621339603301 | (37.7198996190417, -122.456213396033) | ||
| 138595 | 138595 | 67306 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 252 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773656 | 5997299.10481202 | 2090605.17719866 | 37.7202489476622 | -122.451387434099 | (37.7202489476622, -122.451387434099) | ||
| 115205 | 115205 | 84789 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 499x Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2007 12:00:00 AM | Permit No. 49321 | 6002176.0 | 2090606.0 | 37.720529259637296 | -122.43452970370501 | (37.7205292596373, -122.434529703705) | |||
| 127561 | 127561 | 84791 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 499x Lisbon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2007 12:00:00 AM | Permit No. 49321 | 6002176.0 | 2090606.0 | 37.720529259637296 | -122.43452970370501 | (37.7205292596373, -122.434529703705) | |||
| 44800 | 44800 | 176232 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 490 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002153.50763 | 2090617.3285 | 37.7205590883176 | -122.434608262185 | (37.7205590883176, -122.434608262185) | |||
| 172122 | 172122 | 207618 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 720 Head St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993529.31712 | 2090633.6912900002 | 37.720110655762 | -122.464420306879 | (37.720110655762, -122.464420306879) | |||
| 127690 | 127690 | 39665 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 720 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41055 | 5993542.26347395 | 2090641.85281267 | 37.7201338116039 | -122.46437614831301 | (37.7201338116039, -122.464376148313) | ||
| 172271 | 172271 | 176233 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 490 Lisbon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002171.16375 | 2090646.0569 | 37.720638972395896 | -122.43454928373001 | (37.7206389723959, -122.43454928373) | |||
| 29383 | 29383 | 207619 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 724 Head St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993530.3141 | 2090655.8864799999 | 37.720171655864604 | -122.46441847134199 | (37.7201716558646, -122.464418471342) | |||
| 42199 | 42199 | 207620 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 724 Head St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993530.060819999 | 2090669.11588 | 37.7202079660024 | -122.46442030687099 | (37.7202079660024, -122.464420306871) | |||
| 82776 | 82776 | 39666 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 724 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41056 | 5993542.587203501 | 2090669.62247691 | 37.7202100790578 | -122.464377044443 | (37.7202100790578, -122.464377044443) | ||
| 140405 | 140405 | 39667 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 724 Head St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41056 | 5993542.587203501 | 2090669.62247691 | 37.7202100790578 | -122.464377044443 | (37.7202100790578, -122.464377044443) | ||
| 170042 | 170042 | 95763 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 417 Moscow St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767499 | 6004111.77372 | 2090686.36945 | 37.7208596345484 | -122.42784407254999 | (37.7208596345484, -122.42784407255) |
| 84246 | 84246 | 84682 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 121 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49717 | 5996195.09164629 | 2090696.9376961002 | 37.720437620979 | -122.455210247054 | (37.720437620979, -122.455210247054) | ||
| 140781 | 140781 | 81911 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 122 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | 3X3 | Permit Number 49718 | 5996247.30096369 | 2090708.70815365 | 37.7204729351862 | -122.455030627418 | (37.7204729351862, -122.455030627418) | ||
| 4062 | 4062 | 216659 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1022 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 07:44:00 AM | 3 | Width 4ft | 5995946.33237 | 2090713.9624 | 37.7204700913979 | -122.456071352615 | (37.7204700913979, -122.456071352615) | ||
| 137127 | 137127 | 207603 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 122 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996240.91229 | 2090722.7587 | 37.7205111481621 | -122.455053725648 | (37.7205111481621, -122.455053725648) | |||
| 28671 | 28671 | 207602 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 121 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996198.32663 | 2090727.0482700001 | 37.7205204831134 | -122.455201239645 | (37.7205204831134, -122.455201239645) | |||
| 57943 | 57943 | 95767 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 291 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767502 | 6004463.995209999 | 2090737.7812599998 | 37.721020719304704 | -122.426630208134 | (37.7210207193047, -122.426630208134) |
| 88115 | 88115 | 58747 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 129 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1992 12:00:00 AM | Permit Number 30343 | 5995606.37444292 | 2090757.94596432 | 37.720571340719104 | -122.45724965074699 | (37.7205713407191, -122.457249650747) | ||
| 27265 | 27265 | 207601 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 129 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5995608.85604 | 2090759.60342 | 37.720576034226 | -122.457241192545 | (37.720576034226, -122.457241192545) | |||
| 62352 | 62352 | 72297 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 463 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 12 | 6002248.50751 | 2090769.44278 | 37.7209821527804 | -122.43429074752301 | (37.7209821527804, -122.434290747523) | ||
| 4144 | 4144 | 216652 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 329 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:15:00 AM | 3 | Width 4ft | 5994725.9247 | 2090785.7094700001 | 37.7205969659665 | -122.460295076156 | (37.7205969659665, -122.460295076156) | ||
| 10434 | 10434 | 15775 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 4808 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/05/1997 12:00:00 AM | 10 | 3X3 | Permit Number 773279 | 6001261.3736 | 2090797.0594 | 37.7210019026793 | -122.437704946106 | (37.7210019026793, -122.437704946106) |
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");