Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90346 | 90346 | 6736 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 2 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 91184 | 91184 | 6737 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/30/2012 12:00:00 AM | 1 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 102788 | 102788 | 6738 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2016 12:00:00 AM | 1 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 127021 | 127021 | 26468 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 300X Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1998 12:00:00 AM | 3 | 3X3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | ||
| 19063 | 19063 | 11922 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 620X Keith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/2016 12:00:00 AM | 3 | 3X4 | 6017350.6902257 | 2096387.6229349 | 37.737254207453105 | -122.382477163454 | (37.7372542074531, -122.382477163454) | ||
| 172025 | 172025 | 191679 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 604 Keith St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6017194.35691 | 2096452.8116900001 | 37.7374245657007 | -122.383022220618 | (37.7374245657007, -122.383022220618) | |||
| 59341 | 59341 | 191681 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1241 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017111.18893 | 2093915.9080299998 | 37.7304541363294 | -122.383133251796 | (37.7304541363294, -122.383133251796) | |||
| 116800 | 116800 | 17171 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1221X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 3x3 | 6017100.78201 | 2093930.01601 | 37.730492298981794 | -122.383170211952 | (37.7304922989818, -122.383170211952) | ||
| 30905 | 30905 | 191680 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1241 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017088.63788 | 2093939.5635 | 37.7305178434155 | -122.383212860684 | (37.7305178434155, -122.383212860684) | |||
| 80548 | 80548 | 17169 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1221X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 3x3 | 6017071.13101 | 2093953.96501 | 37.7305564196556 | -122.38327438715599 | (37.7305564196556, -122.383274387156) | ||
| 14726 | 14726 | 6733 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6017061.2899 | 2097158.62505 | 37.7393552338433 | -122.383531422133 | (37.7393552338433, -122.383531422133) | |||
| 14736 | 14736 | 6734 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017044.07799 | 2097171.2102099997 | 37.739388838832504 | -122.383591809817 | (37.7393888388325, -122.383591809817) | |||
| 13664 | 13664 | 6735 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 2 | 3x3 | 6017028.4506 | 2097182.15302 | 37.7394180218109 | -122.383646604615 | (37.7394180218109, -122.383646604615) | ||
| 165709 | 165709 | 189267 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300 Fairfax Ave | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6017011.557469999 | 2097196.03632 | 37.7394552087924 | -122.383705980546 | (37.7394552087924, -122.383705980546) | |||
| 80214 | 80214 | 29491 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1628X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/05/2015 07:30:00 AM | 3 | 3x3 | 6016725.73414 | 2093293.6586200001 | 37.7287242549235 | -122.38442251427799 | (37.7287242549235, -122.384422514278) | ||
| 81178 | 81178 | 64551 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1315 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25434 | 6016281.43381852 | 2094844.2486814 | 37.7329572884599 | -122.386066550856 | (37.7329572884599, -122.386066550856) | ||
| 15766 | 15766 | 15015 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/14/2014 12:00:00 AM | 6 | 3x3 | 6016271.14274 | 2097128.2420599998 | 37.7392281047953 | -122.38626130881501 | (37.7392281047953, -122.386261308815) | ||
| 110945 | 110945 | 94897 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1375 Keith St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 53955 | 6016208.4 | 2094705.0 | 37.7325708970962 | -122.386309345138 | (37.7325708970962, -122.386309345138) | |||
| 14095 | 14095 | 64530 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1400 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3 | 20x30 | Permit Number 53955 | 6016100.7066 | 2094719.4549 | 37.732604625715794 | -122.38668267828899 | (37.7326046257158, -122.386682678289) |
| 174744 | 174744 | 64531 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1410 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1988 12:00:00 AM | 0 | Permit Number 25413 | 6016066.97411905 | 2094739.83359707 | 37.732658713948204 | -122.386800721401 | (37.7326587139482, -122.386800721401) | |
| 63900 | 63900 | 64532 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1414 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 0 | Permit Number 25414 | 6016046.60541162 | 2094755.16174124 | 37.732699674197605 | -122.38687221028 | (37.7326996741976, -122.38687221028) | |
| 14081 | 14081 | 26128 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1415 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2010 12:00:00 AM | 3 | 3X3 | 6016013.7391 | 2094719.7689 | 37.7326006727272 | -122.386983370719 | (37.7326006727272, -122.386983370719) | ||
| 107688 | 107688 | 64526 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1419 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1988 12:00:00 AM | Permit Number 25408 | 6015994.96935812 | 2094728.94048025 | 37.7326248167159 | -122.38704890232799 | (37.7326248167159, -122.387048902328) | ||
| 14680 | 14680 | 26127 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1419 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6015993.0176 | 2094731.6994 | 37.7326322840804 | -122.38705584245199 | (37.7326322840804, -122.387055842452) | |||
| 81878 | 81878 | 64533 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1423 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1988 12:00:00 AM | Permit Number 25415 | 6015974.60065069 | 2094744.26862441 | 37.732665776815 | -122.387120391311 | (37.732665776815, -122.387120391311) | ||
| 119515 | 119515 | 26418 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1438 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 3 | 3 | 6015934.46626 | 2094872.09535 | 37.733014540811 | -122.38726806039699 | (37.733014540811, -122.387268060397) | ||
| 57316 | 57316 | 200715 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1463 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6015932.4229 | 2095126.9778 | 37.7337142836816 | -122.387292898181 | (37.7337142836816, -122.387292898181) | |||
| 28172 | 28172 | 64537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1448 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 4 | Permit Number 25419 | 6015877.1655 | 2094890.2503 | 37.73306121716389 | -122.38746743202299 | (37.7330612171639, -122.387467432023) | |
| 139816 | 139816 | 26119 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1475 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2003 12:00:00 AM | 3 | 3X3 | 6015692.20395 | 2094932.7691099998 | 37.73316771923471 | -122.388109864863 | (37.7331677192347, -122.388109864863) | ||
| 47492 | 47492 | 60061 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1574 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1982 12:00:00 AM | 3 | Permit Number 19560 | 6015687.15879 | 2097129.44006 | 37.73919905308271 | -122.38828056471701 | (37.7391990530827, -122.388280564717) | ||
| 174491 | 174491 | 64538 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1486 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 0 | Permit Number 25421 | 6015679.96866361 | 2095031.06834702 | 37.7334369512525 | -122.388159023613 | (37.7334369512525, -122.388159023613) | |
| 181202 | 181202 | 200709 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1399 Lane St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6015661.7831 | 2095130.2658 | 37.7337083198644 | -122.388228817428 | (37.7337083198644, -122.388228817428) | |||
| 168639 | 168639 | 64540 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1490 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 0 | Permit Number 25423 | 6015659.59998474 | 2095046.3964697 | 37.7334779106152 | -122.38823051388901 | (37.7334779106152, -122.388230513889) | |
| 109174 | 109174 | 64539 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1487 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25422 | 6015648.7013223 | 2094989.51893827 | 37.7333211324836 | -122.38826422578 | (37.7333211324836, -122.38826422578) | ||
| 13781 | 13781 | 26117 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1487 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2003 12:00:00 AM | 3 | 3X3 | 6015648.6011 | 2094991.9741 | 37.733327868310205 | -122.38826474357 | (37.7333278683102, -122.38826474357) | ||
| 153841 | 153841 | 200708 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1399 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6015645.8444 | 2095108.8309 | 37.7336485807976 | -122.388282427214 | (37.7336485807976, -122.388282427214) | |||
| 80275 | 80275 | 26143 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Oakdale Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 89501 | 89501 | 26142 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Oakdale Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/21/2006 12:00:00 AM | 3 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 102647 | 102647 | 26141 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Oakdale Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/21/2006 12:00:00 AM | 3 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 118904 | 118904 | 26139 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Oakdale Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11/05/2005 12:00:00 AM | 4 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 61189 | 61189 | 191684 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1531 Kirkwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015574.655669999 | 2096443.50916 | 37.7373093922023 | -122.388621684764 | (37.7373093922023, -122.388621684764) | |||
| 47616 | 47616 | 64550 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1407 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 9 | Permit Number 25433 | 6015557.9064 | 2094994.5115 | 37.7333298097375 | -122.388578480063 | (37.7333298097375, -122.388578480063) | |
| 135201 | 135201 | 54187 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1540 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52350 | 6015552.16986 | 2096532.8786900002 | 37.7375535365611 | -122.388705666158 | (37.7375535365611, -122.388705666158) | |
| 163427 | 163427 | 71380 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1415 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 7 | 6015545.815 | 2094978.0232 | 37.7332838660921 | -122.388619133184 | (37.7332838660921, -122.388619133184) | ||
| 80822 | 80822 | 64549 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1414 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25432 | 6015539.44017214 | 2095047.54254922 | 37.7334743989165 | -122.38864602407699 | (37.7334743989165, -122.388646024077) | ||
| 58995 | 58995 | 191682 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1540 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6015538.54688 | 2096541.66085 | 37.7375768955577 | -122.38875338056299 | (37.7375768955577, -122.388753380563) | |||
| 158768 | 158768 | 191080 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 901 24th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6015525.99309 | 2102510.0498200003 | 37.7539641575461 | -122.389213417992 | (37.7539641575461, -122.389213417992) | |||
| 59309 | 59309 | 55067 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1404 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 11 | Permit Number 10961 | 6015524.9297 | 2095021.4425 | 37.7334019292539 | -122.388694369981 | (37.7334019292539, -122.388694369981) | ||
| 58190 | 58190 | 55068 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1408 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 11 | Permit Number 10962 | 6015508.9909 | 2094998.9084 | 37.733339171785204 | -122.38874790280899 | (37.7333391717852, -122.388747902809) | ||
| 14072 | 14072 | 15048 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1119 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/20/2000 12:00:00 AM | 6 | 3X3 | 6015497.5853 | 2096021.456 | 37.7361462484719 | -122.38885869852601 | (37.7361462484719, -122.388858698526) | ||
| 78615 | 78615 | 64541 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1513 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25424 | 6015494.68772587 | 2095105.29398738 | 37.7336304924024 | -122.38880477766199 | (37.7336304924024, -122.388804777662) | ||
| 185551 | 185551 | 71394 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1549 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 15 | 6015490.02353 | 2096504.2256900002 | 37.7374714167655 | -122.388918537456 | (37.7374714167655, -122.388918537456) | ||
| 87139 | 87139 | 26833 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1133 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 0 | 3X3 | 6015479.92911 | 2095965.0534700002 | 37.7359903999296 | -122.388915807139 | (37.7359903999296, -122.388915807139) | ||
| 146807 | 146807 | 73567 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1549 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 17 | 6015475.76559 | 2096515.7119900002 | 37.7375021654981 | -122.38896863599199 | (37.7375021654981, -122.388968635992) | ||
| 15680 | 15680 | 26834 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1129 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3 | 3X3 | 6015470.5845 | 2095986.9202 | 37.7360499235694 | -122.388949641676 | (37.7360499235694, -122.388949641676) | ||
| 16065 | 16065 | 26114 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1505 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 6 | 3x3 | 6015470.5181 | 2095128.0673 | 37.7336916836833 | -122.38888992918699 | (37.7336916836833, -122.388889929187) | ||
| 165805 | 165805 | 191081 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 901 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015467.86658 | 2102506.20441 | 37.75395037632679 | -122.389414166444 | (37.7539503763268, -122.389414166444) | |||
| 122459 | 122459 | 26112 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1509 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015459.73624 | 2095054.56513 | 37.7334892639404 | -122.388922075695 | (37.7334892639404, -122.388922075695) | ||
| 16889 | 16889 | 15051 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1137 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/20/2000 12:00:00 AM | 3 | 8X18 | 6015459.2819 | 2095972.4779 | 37.736009641441 | -122.388987711638 | (37.736009641441, -122.388987711638) | ||
| 15177 | 15177 | 26109 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1509 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/2010 12:00:00 AM | 3 | 3x3 | 6015436.4421 | 2095148.4030000002 | 37.7337456325918 | -122.389009160289 | (37.7337456325918, -122.389009160289) | ||
| 14921 | 14921 | 26108 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1509 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015422.1522 | 2095159.3952 | 37.733775022834394 | -122.38905933236099 | (37.7337750228344, -122.389059332361) | ||
| 155146 | 155146 | 191082 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 901 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015413.33991 | 2102503.20842 | 37.7539391266996 | -122.38960252494101 | (37.7539391266996, -122.389602524941) | |||
| 103363 | 103363 | 57789 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1201 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | Permit Number 16716 | 6015407.18997447 | 2095895.9761965 | 37.7357966956695 | -122.389162475837 | (37.7357966956695, -122.389162475837) | ||
| 46372 | 46372 | 191683 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1578 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6015394.19835 | 2096650.5888099999 | 37.737867988127704 | -122.38926007030099 | (37.7378679881277, -122.389260070301) | |||
| 147839 | 147839 | 200655 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1516 Oakdale Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015384.228999999 | 2095258.3254 | 37.7340445629032 | -122.389197350847 | (37.7340445629032, -122.389197350847) | |||
| 116398 | 116398 | 64542 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1535 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25425 | 6015382.7037495 | 2095189.38332023 | 37.7338551773356 | -122.389197811817 | (37.7338551773356, -122.389197811817) | ||
| 15994 | 15994 | 26106 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1539X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2000 12:00:00 AM | 12 | 3x3 | 6015355.6491 | 2095208.8603 | 37.733907157322605 | -122.389292708309 | (37.7339071573226, -122.389292708309) | ||
| 41581 | 41581 | 200656 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1518 Oakdale Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015329.8173 | 2095300.0959 | 37.734156239682 | -122.389388386574 | (37.734156239682, -122.389388386574) | |||
| 14462 | 14462 | 26105 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1547 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/2009 12:00:00 AM | 3 | 3x3 | 6015325.4204 | 2095230.2952 | 37.733964337308 | -122.38939871537501 | (37.733964337308, -122.389398715375) | ||
| 20657 | 20657 | 64543 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1547 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25426 | 6015321.62159268 | 2095235.25021997 | 37.7339777321734 | -122.389412195042 | (37.7339777321734, -122.389412195042) | ||
| 15058 | 15058 | 15055 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1224 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6015288.0468 | 2095812.3346 | 37.735560427325204 | -122.389568564294 | (37.7355604273252, -122.389568564294) | ||
| 33540 | 33540 | 200657 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1520 Oakdale Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015286.397999999 | 2095330.3246 | 37.734236834204395 | -122.389540612503 | (37.7342368342044, -122.389540612503) | |||
| 146739 | 146739 | 200658 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1522 Oakdale Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015268.8104 | 2095344.6145 | 37.7342750961819 | -122.38960241665801 | (37.7342750961819, -122.389602416658) | |||
| 140887 | 140887 | 64547 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1563 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25430 | 6015240.17870423 | 2095296.4060958 | 37.7341411380387 | -122.389698040486 | (37.7341411380387, -122.389698040486) | ||
| 16567 | 16567 | 26102 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1563 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015232.536 | 2095297.3479 | 37.73414330023979 | -122.389724529704 | (37.7341433002398, -122.389724529704) | |||
| 109846 | 109846 | 26101 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1567 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/2015 08:01:00 AM | 3 | 3x3 | 6015220.652553501 | 2095312.3188681 | 37.7341837485135 | -122.389766660198 | (37.7341837485135, -122.389766660198) | ||
| 16121 | 16121 | 26100 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1577 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015169.8802 | 2095341.3169 | 37.7342605555935 | -122.38994422273198 | (37.7342605555935, -122.389944222732) | |||
| 97783 | 97783 | 64546 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1577 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25429 | 6015168.9161816 | 2095349.91748359 | 37.7342841175888 | -122.389948156264 | (37.7342841175888, -122.389948156264) | ||
| 69005 | 69005 | 200072 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1912 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015166.0329 | 2093422.0709 | 37.7289904795126 | -122.389823510971 | (37.7289904795126, -122.389823510971) | |||
| 119650 | 119650 | 64545 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1583 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25428 | 6015138.37508416 | 2095372.85094775 | 37.734345394408 | -122.39005534909201 | (37.734345394408, -122.390055349092) | ||
| 23103 | 23103 | 26097 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1583X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2003 12:00:00 AM | 6 | 3x3 | 6015137.4531 | 2095367.1486 | 37.7343296857828 | -122.390058138496 | (37.7343296857828, -122.390058138496) | ||
| 92537 | 92537 | 26099 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1583 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2000 12:00:00 AM | 6 | 3x3 | 6015122.555480001 | 2095354.2938599999 | 37.7342935630106 | -122.39010874709 | (37.7342935630106, -122.39010874709) | ||
| 132290 | 132290 | 81390 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1588 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/2003 12:00:00 AM | 5 | 6015103.68734 | 2101191.55999 | 37.750320442739 | -122.39058173735201 | (37.750320442739, -122.390581737352) | ||
| 64477 | 64477 | 200096 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1528 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015074.2617 | 2092350.8083 | 37.726043916849896 | -122.390065967336 | (37.7260439168499, -122.390065967336) | |||
| 60546 | 60546 | 200100 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1528 Yosemite Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015024.8562 | 2092385.3244 | 37.7261359509126 | -122.390239170909 | (37.7261359509126, -122.390239170909) | |||
| 131313 | 131313 | 200101 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1528 Yosemite Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015012.674 | 2092395.4762 | 37.726163150008794 | -122.39028199338001 | (37.7261631500088, -122.39028199338) | |||
| 132755 | 132755 | 200102 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1528 Yosemite Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014998.4615 | 2092408.3352 | 37.726197669899996 | -122.39033202363899 | (37.7261976699, -122.390332023639) | |||
| 91673 | 91673 | 26011 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1618X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 01/02/1998 12:00:00 AM | 6 | 3X3 | 6014975.06835 | 2095558.9055400002 | 37.7348472038217 | -122.390632955135 | (37.7348472038217, -122.390632955135) | ||
| 19100 | 19100 | 99391 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 82203 | 82203 | 99384 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 83341 | 83341 | 99397 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 83456 | 83456 | 99392 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 96680 | 96680 | 99383 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 107105 | 107105 | 99388 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 109823 | 109823 | 99390 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 111018 | 111018 | 99396 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 121410 | 121410 | 99382 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 127191 | 127191 | 99389 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 162574 | 162574 | 99378 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | |
| 176357 | 176357 | 200106 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1536 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014892.206 | 2092484.8121 | 37.726401765616004 | -122.390704688118 | (37.726401765616, -122.390704688118) |
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");