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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37400 | 37400 | 88728 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 68 Pontiac St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51663 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | |||
| 48042 | 48042 | 88589 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 874 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51533 | 5988541.53724 | 2110053.24401 | 37.7731428326728 | -122.48308379276699 | (37.7731428326728, -122.483083792767) | ||
| 61152 | 61152 | 90191 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1860X Balboa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989777.17693 | 2111298.4454200002 | 37.776633638000604 | -122.478900695137 | (37.7766336380006, -122.478900695137) | |||
| 66740 | 66740 | 91087 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 134 Ralston St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51982 | 5992207.0 | 2088764.0 | 37.7149006256244 | -122.46885508368 | (37.7149006256244, -122.46885508368) | |||
| 79535 | 79535 | 96590 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 81703 | 81703 | 96593 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 85657 | 85657 | 96591 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 87301 | 87301 | 108891 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 434 Hearst Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773352 | 5998535.11764 | 2094404.2240000002 | 37.7307509423916 | -122.44738826472201 | (37.7307509423916, -122.447388264722) | |
| 87482 | 87482 | 88794 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1240 05th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2010 12:00:00 AM | 3x3 | Permit Number 51706 | 5994624.7 | 2107112.8 | 37.765421253667796 | -122.461828244278 | (37.7654212536678, -122.461828244278) | |||
| 89940 | 89940 | 92240 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1470 32nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3x3 | Permit Number 52686 | 5986244.6 | 2105237.3 | 37.7597856659048 | -122.49067468059499 | (37.7597856659048, -122.490674680595) | |||
| 91917 | 91917 | 88205 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 241 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51210 | 5998774.0 | 2109909.0 | 37.7733369001006 | -122.447678136621 | (37.7733369001006, -122.447678136621) | |||
| 93152 | 93152 | 88727 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 66 Pontiac St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51662 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | |||
| 94944 | 94944 | 108615 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 136 Precita Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774598 | 6007320.4947 | 2100127.53408 | 37.746964004181706 | -122.417421212351 | (37.7469640041817, -122.417421212351) | |
| 96635 | 96635 | 87186 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3041 Webster St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50188 | 6002864.0 | 2119027.0 | 37.798605518649296 | -122.43418223343599 | (37.7986055186493, -122.434182233436) | |||
| 97416 | 97416 | 96594 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 97798 | 97798 | 88616 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 484 05th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 3x3 | Permit Number 51569 | 5994405.1 | 2112223.6 | 37.7794415135995 | -122.46295861508999 | (37.7794415135995, -122.46295861509) | |||
| 98974 | 98974 | 87757 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 375 Diamond St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50411 | 6001812.0 | 2103665.0 | 37.7563655677175 | -122.436722244288 | (37.7563655677175, -122.436722244288) | |||
| 104868 | 104868 | 94553 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 634 Clayton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53730 | 5998522.0 | 2108509.0 | 37.769478452068896 | -122.448448994315 | (37.7694784520689, -122.448448994315) | ||
| 107072 | 107072 | 108888 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 658 Monterey Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772760 | 5997727.10617 | 2094743.09717 | 37.7316352013333 | -122.450206090909 | (37.7316352013333, -122.450206090909) | |
| 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) | |||
| 115664 | 115664 | 85184 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 501 Bartlett St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/13/2006 12:00:00 AM | 3x25 | Permit Number 768657 | 6006822.0 | 2100867.0 | 37.748966349809606 | -122.419197411761 | (37.7489663498096, -122.419197411761) | |||
| 116129 | 116129 | 88379 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 351 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51357 | 5990853.6 | 2113045.1 | 37.7814919173335 | -122.475304621963 | (37.7814919173335, -122.475304621963) | |||
| 116314 | 116314 | 96592 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 121354 | 121354 | 94125 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1478 32nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2010 12:00:00 AM | 3x3 | Permit Number 53485 | 5986246.3 | 2105188.0 | 37.75965040100729 | -122.490665173884 | (37.7596504010073, -122.490665173884) | |||
| 121581 | 121581 | 96589 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 127425 | 127425 | 87390 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3318 Fillmore St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | 3x3 | Permit Number 50367 | 6002344.5 | 2119563.8 | 37.8000499325498 | -122.43601829666099 | (37.8000499325498, -122.436018296661) | |||
| 138265 | 138265 | 88556 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 623 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51501 | 5990912.1 | 2111136.5 | 37.776254817936504 | -122.47496288065201 | (37.7762548179365, -122.474962880652) | |||
| 139205 | 139205 | 90190 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1844 Balboa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989791.50296 | 2111298.5559400003 | 37.7766347733354 | -122.47885114584801 | (37.7766347733354, -122.478851145848) | |||
| 142738 | 142738 | 88204 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 225 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51209 | 5998766.0 | 2109964.0 | 37.77348745880521 | -122.447709769744 | (37.7734874588052, -122.447709769744) | |||
| 142875 | 142875 | 87454 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2516 Greenwich St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2008 12:00:00 AM | 3x3 | Permit Number 50378 | 6000865.0 | 2118972.0 | 37.7983408450274 | -122.441095438221 | (37.7983408450274, -122.441095438221) | |||
| 160823 | 160823 | 88392 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 318 22nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51370 | 5989049.86115 | 2113182.34537 | 37.7817640398692 | -122.481554671506 | (37.7817640398692, -122.481554671506) | ||
| 167884 | 167884 | 88383 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 122 18th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51361 | 5990241.512159999 | 2114541.21965 | 37.78556434694811 | -122.477531513518 | (37.7855643469481, -122.477531513518) | ||
| 72085 | 72085 | 191061 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Clara St | 0 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6011653.56606 | 2111728.79849 | 37.779061325667 | -122.403253717397 | (37.779061325667, -122.403253717397) | |||
| 132555 | 132555 | 191060 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Clara St | 0 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011653.22625 | 2111699.06795 | 37.7789796735174 | -122.40325280096901 | (37.7789796735174, -122.403252800969) | |||
| 490 | 490 | 85529 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 3x3 | 6007351.89443 | 2109342.45047 | 37.7722678019432 | -122.417965767207 | (37.7722678019432, -122.417965767207) | ||
| 644 | 644 | 251319 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 1100 | 1100 | 2952 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2001 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6004785.43 | 2115651.1441 | 37.789445140420604 | -122.427292872615 | (37.7894451404206, -122.427292872615) | |||
| 1527 | 1527 | 103937 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2300 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2013 12:00:00 AM | 26 | Permit Number 770288 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | ||
| 1562 | 1562 | 251589 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 339 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778123 | 6007098.02705 | 2095773.46513 | 37.7349961804395 | -122.417881894445 | (37.7349961804395, -122.417881894445) | |
| 1729 | 1729 | 223604 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 54 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007683.47887 | 2107616.2985400003 | 37.7675468513265 | -122.41669647756599 | (37.7675468513265, -122.416696477566) | |||
| 1827 | 1827 | 251744 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 70 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002620.0 | 2086992.0 | 37.710631205907 | -122.43273690550899 | (37.710631205907, -122.432736905509) | ||||
| 1840 | 1840 | 251759 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 248 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001757.0 | 2086582.0 | 37.709456453529796 | -122.43569030601002 | (37.7094564535298, -122.43569030601) | ||||
| 1849 | 1849 | 251761 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001827.0 | 2086593.0 | 37.709490632951706 | -122.43544916105199 | (37.7094906329517, -122.435449161052) | ||||
| 2035 | 2035 | 252855 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 926 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001578.0 | 2088750.0 | 37.7153991335272 | -122.43646402536001 | (37.7153991335272, -122.43646402536) | ||||
| 2516 | 2516 | 251771 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 90x Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002045.0 | 2087474.0 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | ||||
| 2675 | 2675 | 223660 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1980 12:00:00 AM | 7 | Width 3ft | Permit Number 18811 | 6003709.54346 | 2095276.16661 | 37.7334394304696 | -122.429561626586 | (37.7334394304696, -122.429561626586) | |
| 2771 | 2771 | 248515 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 170 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 14 | Width 0ft | Permit Number 17884 | 5998314.3472 | 2107764.7584 | 37.7674230792249 | -122.44911363069099 | (37.7674230792249, -122.449113630691) | |
| 2978 | 2978 | 246035 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 640 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | 6 | Width 0ft | Permit Number 44478 | 5999014.0338 | 2108493.5166 | 37.7694640582811 | -122.446745961985 | (37.7694640582811, -122.446745961985) | |
| 3083 | 3083 | 252820 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 2339 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2017 12:00:00 AM | 3 | 3x3 | 5983590.30233 | 2099230.6863599997 | 37.743137766616 | -122.49941055724301 | (37.743137766616, -122.499410557243) | ||
| 3126 | 3126 | 170290 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 112 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2017 12:00:00 AM | 3 | Width 3ft | 5999300.3013 | 2093511.3105799998 | 37.7283429067858 | -122.44467875893999 | (37.7283429067858, -122.44467875894) | ||
| 3406 | 3406 | 172261 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 230 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6001860.0 | 2086600.0 | 37.7095117275676 | -122.435335608043 | (37.7095117275676, -122.435335608043) | |||
| 3437 | 3437 | 180625 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 18 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 6ft | 6002816.84046 | 2087215.85653 | 37.711257028952495 | -122.432072557104 | (37.7112570289525, -122.432072557104) | |||
| 3489 | 3489 | 74967 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 998 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 8 | 3x3 | 6012084.12824 | 2119041.9172900002 | 37.799165460472295 | -122.40227854024401 | (37.7991654604723, -122.402278540244) | |
| 3792 | 3792 | 223602 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 280x Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2017 12:00:00 AM | 3 | Width 3ft | 6007724.0 | 2106220.0 | 37.7637152201621 | -122.41645740380899 | (37.7637152201621, -122.416457403809) | ||
| 3890 | 3890 | 161753 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 175x Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001022.0 | 2087749.0 | 37.7126190008501 | -122.43831413288 | (37.7126190008501, -122.43831413288) | |
| 3901 | 3901 | 253246 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1192 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001173.0 | 2087586.0 | 37.7121800264355 | -122.437780563503 | (37.7121800264355, -122.437780563503) | |
| 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) | ||
| 3929 | 3929 | 251760 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 242 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 10:24:00 AM | 3 | 3x3 | 6001791.0 | 2086587.0 | 37.709472113614396 | -122.43557315397499 | (37.7094721136144, -122.435573153975) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 3988 | 3988 | 159293 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 486 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:16:00 AM | 3 | Width 0ft | 5998231.36405 | 2087340.7209 | 37.711338838486206 | -122.44793002935499 | (37.7113388384862, -122.447930029355) | ||
| 3993 | 3993 | 180622 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 771 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:19:00 AM | 3 | Width 6ft | 6002476.28052 | 2087135.9896900002 | 37.7110184181363 | -122.433243913293 | (37.7110184181363, -122.433243913293) | ||
| 3996 | 3996 | 251731 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 749 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:28:00 AM | 3 | 3x3 | 6002542.0 | 2087174.0 | 37.7111265141547 | -122.433019485161 | (37.7111265141547, -122.433019485161) | ||
| 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) | ||
| 4017 | 4017 | 159290 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 476 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 12:01:00 PM | 3 | Width 0ft | 5998270.831130001 | 2087378.17542 | 37.71144393594879 | -122.447796316346 | (37.7114439359488, -122.447796316346) | ||
| 4020 | 4020 | 159292 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 482 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:20:00 AM | 3 | Width 0ft | 5998250.20897 | 2087358.72103 | 37.7113893399111 | -122.447866191868 | (37.7113893399111, -122.447866191868) | ||
| 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) | ||
| 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) | ||
| 4054 | 4054 | 212592 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 626 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:33:00 PM | 3 | Width 3ft | 5994858.52059 | 2091254.05594 | 37.7218905597914 | -122.459870645607 | (37.7218905597914, -122.459870645607) | ||
| 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) | ||
| 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) | ||
| 4088 | 4088 | 30930 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 342 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2017 02:15:00 PM | 3 | 4.5x9 | Permit Number 779282 | 5995716.95289 | 2091237.86508 | 37.7218954350219 | -122.45690211214199 | (37.7218954350219, -122.456902112142) |
| 4108 | 4108 | 180634 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 824 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:16:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.4224099999 | 37.7108048597154 | -122.43377544319401 | (37.7108048597154, -122.433775443194) | ||
| 4114 | 4114 | 180623 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 755 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:23:00 AM | 3 | Width 6ft | 6002495.21129 | 2087156.5558200001 | 37.711075962150204 | -122.43317995261499 | (37.7110759621502, -122.433179952615) | ||
| 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) | ||
| 4183 | 4183 | 180766 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1206 Naples St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:29:00 AM | 3 | Width 8ft | 6001093.57723 | 2087421.33847 | 37.7117233858917 | -122.438043283865 | (37.7117233858917, -122.438043283865) | ||
| 4195 | 4195 | 181063 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 280 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:21:00 PM | 3 | Width 3ft | 5999687.90058 | 2086653.1482400002 | 37.7095340664096 | -122.44284654223999 | (37.7095340664096, -122.44284654224) | ||
| 4207 | 4207 | 251781 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1237 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:14:00 AM | 3 | 3x3 | 6001070.0 | 2087245.0 | 37.711237858655295 | -122.438112149268 | (37.7112378586553, -122.438112149268) | ||
| 4209 | 4209 | 180663 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 355 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:48:00 PM | 3 | Width 6ft | 6002383.84355 | 2086445.14687 | 37.709116270155604 | -122.43351405884898 | (37.7091162701556, -122.433514058849) | ||
| 4210 | 4210 | 251779 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1207 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:23:00 AM | 3 | 3x3 | 6001136.0 | 2087356.0 | 37.7115463934242 | -122.437891982586 | (37.7115463934242, -122.437891982586) | ||
| 4218 | 4218 | 181054 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 120 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:03:00 AM | 3 | Width 2ft | 6000669.11916 | 2087419.81595 | 37.711695057256605 | -122.439510213951 | (37.7116950572566, -122.439510213951) | ||
| 4253 | 4253 | 216859 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 249 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 08:28:00 AM | 3 | Width 3ft | 5994500.65492 | 2087744.1970099998 | 37.712232734922104 | -122.46085344003299 | (37.7122327349221, -122.460853440033) | ||
| 4293 | 4293 | 216862 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 272 Sadowa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 08:43:00 AM | 3 | Width 3ft | 5994260.82584 | 2087785.69998 | 37.7123328897311 | -122.461685361516 | (37.7123328897311, -122.461685361516) | ||
| 4315 | 4315 | 216902 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 174 Bright St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/11/2017 11:02:00 AM | 3 | Width 3ft | 5993764.72474 | 2088364.55203 | 37.7138937098892 | -122.46344200363899 | (37.7138937098892, -122.463442003639) | ||
| 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) | |
| 4389 | 4389 | 177791 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 400 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:44:00 AM | 3 | Width 8ft | 6001956.24423 | 2086810.19432 | 37.710094340458 | -122.435017995105 | (37.710094340458, -122.435017995105) | ||
| 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) | |
| 4475 | 4475 | 253631 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 6009957.290080001 | 2113442.89538 | 37.783672949399204 | -122.409242840109 | (37.7836729493992, -122.409242840109) | ||||
| 4520 | 4520 | 253628 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 123 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6009831.1503800005 | 2113653.7445799997 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | |||||
| 4635 | 4635 | 160567 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 790 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 11:57:00 AM | 3 | Width 0ft | 6002104.08605 | 2089098.7371 | 37.716386568565 | -122.43467056358999 | (37.716386568565, -122.43467056359) | |
| 4648 | 4648 | 160560 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 718 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:51:00 PM | 3 | Width 0ft | 6002343.44923 | 2089479.7194599998 | 37.7174462478135 | -122.43387042418301 | (37.7174462478135, -122.433870424183) | |
| 4653 | 4653 | 160561 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 730 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:42:00 PM | 3 | Width 0ft | 6002306.04947 | 2089419.84324 | 37.7172797185636 | -122.43399542008001 | (37.7172797185636, -122.43399542008) | |
| 4654 | 4654 | 160563 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 750 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:34:00 PM | 3 | Width 0ft | 6002231.24921 | 2089300.0903 | 37.7169466582377 | -122.434245412715 | (37.7169466582377, -122.434245412715) | |
| 4662 | 4662 | 50502 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 744 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 01:37:00 PM | 3 | 3x3 | Permit Number 767517 | 6002255.61475 | 2089339.38797 | 37.7170559438579 | -122.434164000676 | (37.7170559438579, -122.434164000676) |
| 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) | |
| 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) | |
| 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) |
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");