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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145 | 145 | 111561 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1498x Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779654 | 6011715.78319 | 2101470.3886700002 | 37.7508975116216 | -122.40231700873699 | (37.7508975116216, -122.402317008737) | |
| 469 | 469 | 85530 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 101X 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007333.48731 | 2109350.5044400003 | 37.772288880253704 | -122.418030010287 | (37.7722888802537, -122.418030010287) | |||
| 479 | 479 | 85531 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 101X 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007317.968280001 | 2109362.68703 | 37.7723214572932 | -122.418084555959 | (37.7723214572932, -122.418084555959) | |||
| 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) | ||
| 541 | 541 | 251317 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 635 | 635 | 251315 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 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) | ||||
| 645 | 645 | 251316 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 851 | 851 | 234149 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3652 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005288.48907 | 2102558.72214 | 37.753524945734 | -122.42462062893601 | (37.753524945734, -122.424620628936) | |||
| 1009 | 1009 | 223537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300 Noe St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 6003218.0959 | 2100594.3408 | 37.7480140720016 | -122.431640256605 | (37.7480140720016, -122.431640256605) | |||
| 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) | ||||
| 1859 | 1859 | 251772 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 90x Seville St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002045.0 | 2087474.0 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | ||||
| 1861 | 1861 | 251780 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1219 Naples St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001110.0 | 2087312.0 | 37.7114241006266 | -122.437978695611 | (37.7114241006266, -122.437978695611) | ||||
| 1874 | 1874 | 251773 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 90x Seville St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002045.0 | 2087474.0 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | ||||
| 1997 | 1997 | 28906 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 354 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2014 12:00:00 AM | 5 | 3X3 | Permit Number 779305 | 6011835.68516 | 2111895.24936 | 37.779528530663704 | -122.402635398413 | (37.7795285306637, -122.402635398413) | |
| 2026 | 2026 | 252856 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 926 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001578.0 | 2088750.0 | 37.7153991335272 | -122.43646402536001 | (37.7153991335272, -122.43646402536) | ||||
| 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) | ||||
| 2524 | 2524 | 141906 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 900 MCALLISTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004683.4832 | 2111946.7944 | 37.7792681524686 | -122.427381601663 | (37.7792681524686, -122.427381601663) | |||
| 2540 | 2540 | 141909 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 900 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004576.1236 | 2111931.0419 | 37.779218827498205 | -122.427751880486 | (37.7792188274982, -122.427751880486) | |||
| 2565 | 2565 | 191072 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 779704 | 6008614.31812 | 2108613.9778 | 37.770338555601505 | -122.41354738542101 | (37.7703385556015, -122.413547385421) | ||
| 2608 | 2608 | 115877 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1880 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005144.10497 | 2117158.82947 | 37.7936051429156 | -122.42615927543999 | (37.7936051429156, -122.42615927544) | ||
| 2674 | 2674 | 223658 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 18811 | 6003665.26948 | 2095270.38526 | 37.7334210492488 | -122.429714281988 | (37.7334210492488, -122.429714281988) | ||
| 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) | |
| 2678 | 2678 | 223657 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 18811 | 6003655.959980001 | 2095270.88152 | 37.7334218847062 | -122.429746502924 | (37.7334218847062, -122.429746502924) | ||
| 2680 | 2680 | 223656 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 18811 | 6003648.753819999 | 2095269.66073 | 37.7334181246305 | -122.42977132959601 | (37.7334181246305, -122.429771329596) | ||
| 2685 | 2685 | 223659 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 18811 | 6003694.10013 | 2095275.57225 | 37.7334369240608 | -122.42961497614901 | (37.7334369240608, -122.429614976149) | ||
| 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) | |
| 3065 | 3065 | 175836 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Rhine St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994366.585519999 | 2086543.72285 | 37.70892880020671 | -122.46122985488998 | (37.7089288002067, -122.46122985489) | |||
| 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) | |||
| 3478 | 3478 | 180626 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 18 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 6ft | 6002802.39914 | 2087193.02957 | 37.7111935323316 | -122.432120840807 | (37.7111935323316, -122.432120840807) | |||
| 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) | |
| 3736 | 3736 | 223410 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 898 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1993 12:00:00 AM | 9 | Width 4ft | Permit Number 32344 | 6010171.02881 | 2104045.21453 | 37.7578810584907 | -122.407840483778 | (37.7578810584907, -122.407840483778) | |
| 3749 | 3749 | 223601 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 280x Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007724.0 | 2106220.0 | 37.7637152201621 | -122.41645740380899 | (37.7637152201621, -122.416457403809) | |||
| 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) | |
| 3916 | 3916 | 179075 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2017 08:37:00 AM | 3 | Width 3ft | 6004507.82534 | 2093430.5210099998 | 37.7284168670376 | -122.426670354762 | (37.7284168670376, -122.426670354762) | ||
| 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) | ||
| 3953 | 3953 | 44431 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 859 Prague St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2017 11:19:00 AM | 3 | Permit Number 43768 | 6002228.37284 | 2086951.06128 | 37.71049657842789 | -122.434087529513 | (37.7104965784279, -122.434087529513) | |
| 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) | ||
| 3991 | 3991 | 44420 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 859 Prague St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2017 08:03:00 AM | 3 | Permit Number 43768 | 6002331.23577 | 2087017.31055 | 37.710684321803896 | -122.433736745364 | (37.7106843218039, -122.433736745364) | |
| 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) | ||
| 4059 | 4059 | 251733 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 824 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:24:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.4224099999 | 37.7108048597154 | -122.43377544319401 | (37.7108048597154, -122.433775443194) | ||
| 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) | ||
| 4069 | 4069 | 251732 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 824 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:20:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.4224099999 | 37.7108048597154 | -122.43377544319401 | (37.7108048597154, -122.433775443194) | ||
| 4071 | 4071 | 251734 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 856 Prague St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 08:08:00 AM | 3 | Width 6ft | 6002039.2106099995 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | ||
| 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) | ||
| 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) | ||
| 4304 | 4304 | 181055 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 120 Brunswick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:09:00 AM | 3 | Width 2ft | 6000651.24572 | 2087413.96665 | 37.711677979129604 | -122.43957157019899 | (37.7116779791296, -122.439571570199) | ||
| 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) | |
| 4458 | 4458 | 253080 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2849X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 11:00:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 4465 | 4465 | 253081 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2849X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:35:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 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) | ||||
| 4506 | 4506 | 253629 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 123 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6009831.1503800005 | 2113653.7445799997 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | |||||
| 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) |
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");