Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||||
| 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) | |
| 4665 | 4665 | 160559 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 710 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:15:00 PM | 3 | Width 0ft | 6002373.4779900005 | 2089525.5110400002 | 37.7175736853632 | -122.433769899784 | (37.7175736853632, -122.433769899784) | |
| 4718 | 4718 | 160845 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 669 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 03:09:00 PM | 3 | Width 0ft | 6002769.79165 | 2089568.5134700001 | 37.7177142412877 | -122.432403094831 | (37.7177142412877, -122.432403094831) | |
| 4728 | 4728 | 160846 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 669 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 12:20:00 PM | 3 | Width 0ft | 6002781.71244 | 2089588.8302099998 | 37.717770702526295 | -122.432363340291 | (37.7177707025263, -122.432363340291) | |
| 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) | |
| 4761 | 4761 | 160908 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 615 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:06:00 PM | 3 | Width 0ft | 6002284.55838 | 2090317.50092 | 37.7197432674186 | -122.434133839205 | (37.7197432674186, -122.434133839205) | |
| 4770 | 4770 | 160917 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 646 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:31:00 AM | 3 | Width 0ft | 6002146.555269999 | 2090180.2898900001 | 37.719358683138 | -122.434601060409 | (37.719358683138, -122.434601060409) | |
| 4887 | 4887 | 236267 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 98X Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 775137 | 6007694.337 | 2107447.14933 | 37.76708301789029 | -122.41664693661998 | (37.7670830178903, -122.41664693662) | |
| 5159 | 5159 | 242086 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4185 25th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002948.22198 | 2101215.85126 | 37.7497052929799 | -122.432617857444 | (37.7497052929799, -122.432617857444) | |||
| 10539 | 10539 | 97421 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 84 Liebig St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2011 12:00:00 AM | 3 | 6x15 | Permit Number 768371 | 5995500.38132 | 2086681.7504200002 | 37.709372977163504 | -122.457321298761 | (37.7093729771635, -122.457321298761) | |
| 15700 | 15700 | 72422 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2400 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1996 12:00:00 AM | 10 | 3x3 | 6010224.23312 | 2105998.24791 | 37.7632466260627 | -122.40779419295299 | (37.7632466260627, -122.407794192953) | |
| 16724 | 16724 | 74019 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2400 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1996 12:00:00 AM | 10 | 3x3 | 6010272.25282 | 2105997.87843 | 37.7632482996846 | -122.40762808187799 | (37.7632482996846, -122.407628081878) | |
| 23709 | 23709 | 223384 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6005565.506580001 | 2104580.7732 | 37.759092667419 | -122.42380640884701 | (37.759092667419, -122.423806408847) | |||
| 23816 | 23816 | 224059 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3628 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002696.79261 | 2106527.84926 | 37.76427650537521 | -122.43386694650499 | (37.7642765053752, -122.433866946505) | |||
| 23983 | 23983 | 224070 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4411 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000003.97958 | 2105733.8947099997 | 37.7619433258348 | -122.443123570319 | (37.7619433258348, -122.443123570319) | |||
| 24000 | 24000 | 246500 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 273 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6004745.35521 | 2099854.76299 | 37.746069811469 | -122.426306403626 | (37.746069811469, -122.426306403626) | |||
| 24032 | 24032 | 207660 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1207 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996711.4694300005 | 2107231.1786 | 37.7658662000893 | -122.454619182239 | (37.7658662000893, -122.454619182239) | |||
| 24108 | 24108 | 223503 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3421 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006951.65327 | 2101439.66063 | 37.750546046666706 | -122.41878967662 | (37.7505460466667, -122.41878967662) | |||
| 24291 | 24291 | 207706 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 215 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5998739.57891 | 2093599.69117 | 37.7285535657887 | -122.446623550035 | (37.7285535657887, -122.446623550035) | |||
| 24319 | 24319 | 176264 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 165 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010291.19923 | 2093895.2108900002 | 37.7300180820504 | -122.40670958899099 | (37.7300180820504, -122.406709588991) | |||
| 24524 | 24524 | 223397 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3560 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005876.75311 | 2104933.14392 | 37.7600777604998 | -122.422755010534 | (37.7600777604998, -122.422755010534) | |||
| 24709 | 24709 | 182142 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1418 25th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 5988379.3786 | 2105646.1459999997 | 37.761032715479395 | -122.483321592218 | (37.7610327154794, -122.483321592218) | |||
| 24712 | 24712 | 189244 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013923.095430001 | 2103892.83973 | 37.757672010179206 | -122.394853496397 | (37.7576720101792, -122.394853496397) | |||
| 24989 | 24989 | 223551 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1143 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5997699.39696 | 2106553.80105 | 37.764062907387704 | -122.45115331019 | (37.7640629073877, -122.45115331019) | |||
| 25085 | 25085 | 223541 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 814 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6001016.96065 | 2102616.12439 | 37.7534403941744 | -122.43939657921301 | (37.7534403941744, -122.439396579213) | |||
| 25196 | 25196 | 137812 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1802 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004857.7279 | 2115477.5519 | 37.7889725883007 | -122.42703036076 | (37.7889725883007, -122.42703036076) | |||
| 25319 | 25319 | 124355 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1108 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5992124.25378 | 2111386.32559 | 37.7770109442204 | -122.470787948699 | (37.7770109442204, -122.470787948699) | |||
| 25711 | 25711 | 223380 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009884.795080001 | 2104504.34853 | 37.7591257084916 | -122.40886279708499 | (37.7591257084916, -122.408862797085) | |||
| 25760 | 25760 | 223377 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2801 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010298.3381900005 | 2101037.92652 | 37.7496308398979 | -122.407188209083 | (37.7496308398979, -122.407188209083) | |||
| 25831 | 25831 | 124534 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 951 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992622.68332 | 2111346.9142400003 | 37.7769315430211 | -122.46906087290701 | (37.7769315430211, -122.469060872907) |
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");