trees
190 rows where Police Districts = 9 and qSpecies_id = 8 sorted by PermitNotes
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1541 | 70231 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005265.5585 | 2110935.6138 | 37.7765246008409 | -122.425295984643 | (37.7765246008409, -122.425295984643) | 7 | 9 | 11 | 28852 | 10 | |||
4522 | 141909 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004576.1236 | 2111931.0419 | 37.7792188274982 | -122.427751880486 | (37.7792188274982, -122.427751880486) | 7 | 9 | 11 | 29490 | 41 | |||
7024 | 141437 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005239.6877 | 2110933.7323 | 37.7765179730819 | -122.425385345316 | (37.7765179730819, -122.425385345316) | 7 | 9 | 11 | 28852 | 10 | |||
7031 | 126517 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3835 Scott St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6000579.5194 | 2121468.07283 | 37.8051781307269 | -122.44226256568 | (37.8051781307269, -122.44226256568) | 13 | 9 | 1 | 57 | 17 | |||
9657 | 126497 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1651 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005046.68269 | 2119164.91299 | 37.7991078310233 | -122.426639284086 | (37.7991078310233, -122.426639284086) | 13 | 9 | 1 | 57 | 17 | |||
11592 | 224089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 224 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004580.79593 | 2109148.95091 | 37.7715801506238 | -122.427537458604 | (37.7715801506238, -122.427537458604) | 7 | 9 | 11 | 28852 | 10 | |||
14335 | 126528 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2865 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999858.5831 | 2117397.02889 | 37.7939590162525 | -122.444464683403 | (37.7939590162525, -122.444464683403) | 13 | 9 | 1 | 57 | 27 | |||
14856 | 126525 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3321 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004100.5255 | 2120576.79123 | 37.8029309470697 | -122.430014078187 | (37.8029309470697, -122.430014078187) | 13 | 9 | 1 | 57 | 17 | |||
20602 | 126531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1870 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005210.197 | 2117169.09516 | 37.7936370652524 | -122.425931322478 | (37.7936370652524, -122.425931322478) | 13 | 9 | 1 | 28858 | 27 | |||
22636 | 126510 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 251 Alhambra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000996.04097 | 2120002.97644 | 37.8011790965073 | -122.440715988969 | (37.8011790965073, -122.440715988969) | 13 | 9 | 1 | 57 | 17 | |||
24312 | 126513 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1775 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001669.3138 | 2121059.84725 | 37.8041193022167 | -122.438461940777 | (37.8041193022167, -122.438461940777) | 13 | 9 | 1 | 57 | 17 | |||
26950 | 104269 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2867 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 7x7 | 5999338.58115 | 2117675.40642 | 37.7946936832082 | -122.446283969628 | (37.7946936832082, -122.446283969628) | 13 | 9 | 1 | 57 | 27 | |||
27761 | 126498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1645 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005080.33881 | 2119170.38355 | 37.7991247544637 | -122.426523212175 | (37.7991247544637, -122.426523212175) | 13 | 9 | 1 | 57 | 17 | |||
33012 | 138860 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 523 IVY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004843.1098 | 2111063.3665 | 37.7768515029621 | -122.426766456726 | (37.7768515029621, -122.426766456726) | 7 | 9 | 11 | 28852 | 10 | |||
35448 | 2952 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2001 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6004785.43 | 2115651.1441 | 37.7894451404206 | -122.427292872615 | (37.7894451404206, -122.427292872615) | 13 | 9 | 11 | 28858 | 27 | |||
36215 | 126492 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2901 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003445.69979 | 2118326.5799 | 37.7967153438803 | -122.432119324565 | (37.7967153438803, -122.432119324565) | 13 | 9 | 1 | 57 | 17 | |||
37947 | 224082 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 285 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004326.71028 | 2109072.08218 | 37.7713547130825 | -122.428410875685 | (37.7713547130825, -122.428410875685) | 7 | 9 | 11 | 28852 | 10 | |||
47759 | 246581 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 184 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 6005207.86965 | 2109476.17522 | 37.772514077681 | -122.425391663601 | (37.772514077681, -122.425391663601) | 7 | 9 | 11 | 28852 | 10 | |||
48492 | 141906 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 MCALLISTER ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004683.4832 | 2111946.7944 | 37.7792681524686 | -122.427381601663 | (37.7792681524686, -122.427381601663) | 7 | 9 | 11 | 29490 | 41 | |||
51071 | 246580 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 182 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 6005210.93182 | 2109452.28431 | 37.7724486520281 | -122.425379370776 | (37.7724486520281, -122.425379370776) | 7 | 9 | 11 | 28852 | 10 | |||
51136 | 224091 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 246 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004510.25041 | 2109143.13465 | 37.7715601901838 | -122.427781065151 | (37.7715601901838, -122.427781065151) | 7 | 9 | 11 | 28852 | 10 | |||
51354 | 126501 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000880.46744 | 2118977.69433 | 37.7983573611488 | -122.441042325066 | (37.7983573611488, -122.441042325066) | 13 | 9 | 1 | 57 | 17 | |||
58226 | 126507 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2300 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000262.11092 | 2119933.43499 | 37.8009463312723 | -122.443250701178 | (37.8009463312723, -122.443250701178) | 13 | 9 | 1 | 57 | 17 | |||
59517 | 139858 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 702 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6005734.4525 | 2112096.2581 | 37.779737926575 | -122.4237564888 | (37.779737926575, -122.4237564888) | 7 | 9 | 11 | 28852 | 41 | |||
61862 | 250069 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 307 Austin St | 2 | : | Tree | Private 2 | 2 | Width 2ft | 6005709.21572 | 2115345.18544 | 37.7886572546664 | -122.424074905926 | (37.7886572546664, -122.424074905926) | 13 | 9 | 1 | 28858 | 41 | |||
62500 | 137814 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1806 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004851.542 | 2115527.4258 | 37.7891091797181 | -122.427055316869 | (37.7891091797181, -122.427055316869) | 13 | 9 | 1 | 28858 | 27 | |||
67585 | 224096 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 310 Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003743.84038 | 2108689.19941 | 37.7702704103723 | -122.430399726373 | (37.7702704103723, -122.430399726373) | 15 | 9 | 11 | 29492 | 10 | |||
68414 | 126491 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3041 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002852.03397 | 2119100.62162 | 37.7988069853068 | -122.434228905666 | (37.7988069853068, -122.434228905666) | 13 | 9 | 1 | 57 | 17 | |||
70288 | 126514 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 54 Casa Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001509.62012 | 2121629.43894 | 37.8056741643903 | -122.439055417799 | (37.8056741643903, -122.439055417799) | 13 | 9 | 1 | 57 | 17 | |||
72717 | 246573 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6005236.998 | 2109273.038 | 37.771957957636 | -122.425276447877 | (37.771957957636, -122.425276447877) | 7 | 9 | 11 | 28852 | 10 | |||
73987 | 14750 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 940 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2000 12:00:00 AM | 3 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | ||
74465 | 126522 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3318 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002338.78522 | 2119619.00301 | 37.800201180891 | -122.436042024317 | (37.800201180891, -122.436042024317) | 13 | 9 | 1 | 57 | 17 | |||
74476 | 126519 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Alhambra St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6000986.5183 | 2120044.44522 | 37.8012924164688 | -122.440751917771 | (37.8012924164688, -122.440751917771) | 13 | 9 | 1 | 57 | 17 | |||
75209 | 224088 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 222 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004610.98363 | 2109155.17088 | 37.7715989365628 | -122.427433480775 | (37.7715989365628, -122.427433480775) | 7 | 9 | 11 | 28852 | 10 | |||
76374 | 126521 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Alhambra St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000953.24503 | 2120036.11736 | 37.8012676554495 | -122.440866459913 | (37.8012676554495, -122.440866459913) | 13 | 9 | 1 | 57 | 17 | |||
83955 | 126526 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3101 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004207.10509 | 2119826.7769 | 37.8008776374509 | -122.429591735885 | (37.8008776374509, -122.429591735885) | 13 | 9 | 1 | 57 | 17 | |||
84723 | 126495 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2700 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6000053.14506 | 2117822.05774 | 37.7951371326294 | -122.44382203238 | (37.7951371326294, -122.44382203238) | 13 | 9 | 1 | 57 | 17 | |||
87158 | 126506 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2300 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000233.97348 | 2119929.48889 | 37.8009338918396 | -122.44334778477 | (37.8009338918396, -122.44334778477) | 13 | 9 | 1 | 57 | 17 | |||
87301 | 224087 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 216 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004639.34009 | 2109155.86974 | 37.7716024592153 | -122.427335443897 | (37.7716024592153, -122.427335443897) | 7 | 9 | 11 | 28852 | 10 | |||
92943 | 126496 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1695 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004921.92717 | 2119147.20146 | 37.7990521458892 | -122.42706971849 | (37.7990521458892, -122.42706971849) | 13 | 9 | 1 | 57 | 17 | |||
93556 | 224095 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 54 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004037.99786 | 2108888.07328 | 37.77083312788 | -122.429396421106 | (37.77083312788, -122.429396421106) | 7 | 9 | 11 | 29492 | 10 | |||
96474 | 142259 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 566 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004708.2263 | 2110563.0976 | 37.7754702599594 | -122.427197416812 | (37.7754702599594, -122.427197416812) | 7 | 9 | 11 | 28852 | 10 | |||
98434 | 224090 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004557.93322 | 2109147.67974 | 37.7715753671272 | -122.427616451463 | (37.7715753671272, -122.427616451463) | 7 | 9 | 11 | 28852 | 10 | |||
101455 | 126529 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2401 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002006.44363 | 2117342.94973 | 37.7939328468693 | -122.437029012298 | (37.7939328468693, -122.437029012298) | 13 | 9 | 1 | 29490 | 27 | |||
101946 | 17744 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1600X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6006169.66382 | 2115620.29477 | 37.7894386225292 | -122.422501377441 | (37.7894386225292, -122.422501377441) | 13 | 9 | 1 | 28858 | 41 | |||
103676 | 126536 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1859 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006939.28013 | 2117655.36372 | 37.7950698030789 | -122.419983060779 | (37.7950698030789, -122.419983060779) | 13 | 9 | 10 | 28858 | 32 | |||
103766 | 224084 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 243 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004527.68926 | 2109092.69188 | 37.7714226730598 | -122.427717148539 | (37.7714226730598, -122.427717148539) | 7 | 9 | 11 | 28852 | 10 | |||
104631 | 250068 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 307 Austin St | 1 | : | Tree | Private 2 | 2 | Width 2ft | 6005700.31875 | 2115344.38579 | 37.7886545567034 | -122.424105631271 | (37.7886545567034, -122.424105631271) | 13 | 9 | 1 | 28858 | 41 | |||
105436 | 137813 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1804 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004855.4082 | 2115502.2955 | 37.7890403968446 | -122.42704014968 | (37.7890403968446, -122.42704014968) | 13 | 9 | 1 | 28858 | 27 | |||
109183 | 246574 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 3 | : | Tree | Private 2 | 10 | Width 3ft | 6005235.59585 | 2109292.29359 | 37.7720107496197 | -122.425282668482 | (37.7720107496197, -122.425282668482) | 7 | 9 | 11 | 28852 | 10 | |||
112806 | 121021 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1649 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6005068.54414 | 2119516.86917 | 37.8000754484782 | -122.42658871161 | (37.8000754484782, -122.42658871161) | 13 | 9 | 1 | 57 | 17 | |||
112846 | 126505 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3434 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000801.45062 | 2120178.5293 | 37.8016500345732 | -122.441401958532 | (37.8016500345732, -122.441401958532) | 13 | 9 | 1 | 57 | 17 | |||
112987 | 244450 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 600 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003616.0838 | 2109707.0129 | 37.7730578394028 | -122.430914285765 | (37.7730578394028, -122.430914285765) | 15 | 9 | 11 | 29492 | 10 | |||
113129 | 126530 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1870 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005227.37951 | 2117173.30895 | 37.7936496062927 | -122.425872169587 | (37.7936496062927, -122.425872169587) | 13 | 9 | 1 | 28858 | 27 | |||
113456 | 139822 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005086 | 2111993 | 37.7794177784995 | -122.425992418184 | (37.7794177784995, -122.425992418184) | 7 | 9 | 11 | 28852 | 41 | |||
114388 | 224085 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 243 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004536.35935 | 2109097.26869 | 37.7714357303029 | -122.427687484405 | (37.7714357303029, -122.427687484405) | 7 | 9 | 11 | 28852 | 10 | |||
115234 | 224083 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 285 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004355.4783 | 2109071.91707 | 37.7713558875841 | -122.428311353983 | (37.7713558875841, -122.428311353983) | 7 | 9 | 11 | 28852 | 10 | |||
116146 | 246582 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 198 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 6005203.89906 | 2109501.9724 | 37.7725846861634 | -122.425407234452 | (37.7725846861634, -122.425407234452) | 7 | 9 | 11 | 28852 | 10 | |||
116466 | 126494 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2901 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003442.2603 | 2118361.73826 | 37.7968116846621 | -122.432133738008 | (37.7968116846621, -122.432133738008) | 13 | 9 | 1 | 57 | 17 | |||
117720 | 224094 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 52 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004048.7307 | 2108889.92984 | 37.7708388331853 | -122.42935942839 | (37.7708388331853, -122.42935942839) | 7 | 9 | 11 | 29492 | 10 | |||
118575 | 126503 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2514 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000838.22718 | 2118974.91794 | 37.7983473319336 | -122.441188289519 | (37.7983473319336, -122.441188289519) | 13 | 9 | 1 | 57 | 17 | |||
120076 | 126511 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 251 Alhambra St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000979.36028 | 2119998.96358 | 37.8011671283179 | -122.44077342326 | (37.8011671283179, -122.44077342326) | 13 | 9 | 1 | 57 | 17 | |||
124905 | 246577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6005225.24464 | 2109364.93457 | 37.7722096193969 | -122.425323644264 | (37.7722096193969, -122.425323644264) | 7 | 9 | 11 | 28852 | 10 | |||
128406 | 246572 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6005238.2187 | 2109262.186 | 37.7719282296287 | -122.425271453026 | (37.7719282296287, -122.425271453026) | 7 | 9 | 11 | 28852 | 10 | |||
130525 | 224086 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 223 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004621.17543 | 2109107.92251 | 37.7714697804289 | -122.427394860302 | (37.7714697804289, -122.427394860302) | 7 | 9 | 11 | 28852 | 10 | |||
132271 | 141989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1019 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004298.7778 | 2111838.3869 | 37.7789487270827 | -122.42870472731 | (37.7789487270827, -122.42870472731) | 7 | 9 | 11 | 29490 | 41 | |||
133050 | 78962 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2324 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6000164.38759 | 2119919.60804 | 37.8009027932886 | -122.443587870495 | (37.8009027932886, -122.443587870495) | 13 | 9 | 1 | 57 | 17 | |||
136408 | 126504 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2520 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000806.13814 | 2118970.30741 | 37.798332844742 | -122.441298996056 | (37.798332844742, -122.441298996056) | 13 | 9 | 1 | 57 | 17 | |||
138813 | 139857 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 700 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005751.5937 | 2112096.7775 | 37.7797403203321 | -122.423697226772 | (37.7797403203321, -122.423697226772) | 7 | 9 | 11 | 28852 | 41 | |||
139588 | 246579 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 Laguna St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6005220.7586 | 2109411.73941 | 37.772337880726 | -122.425342493187 | (37.772337880726, -122.425342493187) | 7 | 9 | 11 | 28852 | 10 | |||
140852 | 126508 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2241 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000053.49785 | 2120204.95376 | 37.801679951426 | -122.443992108573 | (37.801679951426, -122.443992108573) | 13 | 9 | 1 | 57 | 17 | |||
142355 | 126518 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6001004.11411 | 2120049.67751 | 37.8013077849919 | -122.440691404186 | (37.8013077849919, -122.440691404186) | 13 | 9 | 1 | 57 | 17 | |||
147006 | 126509 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2259 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5999989.15096 | 2120195.34054 | 37.801649885296 | -122.444214086407 | (37.801649885296, -122.444214086407) | 13 | 9 | 1 | 57 | 17 | |||
147719 | 126493 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2901 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003443.96116 | 2118340.85925 | 37.796754452719 | -122.432126360859 | (37.796754452719, -122.432126360859) | 13 | 9 | 1 | 57 | 17 | |||
149291 | 246575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 4 | : | Tree | Private 2 | 11 | Width 3ft | 6005230.8128 | 2109313.15324 | 37.7720677549581 | -122.425300698072 | (37.7720677549581, -122.425300698072) | 7 | 9 | 11 | 28852 | 10 | |||
151841 | 224092 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 262 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004449.56008 | 2109136.25999 | 37.77153788069 | -122.427990506479 | (37.77153788069, -122.427990506479) | 7 | 9 | 11 | 28852 | 10 | |||
152745 | 126523 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1436 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004946.35763 | 2120239.41034 | 37.8020524524204 | -122.427063015844 | (37.8020524524204, -122.427063015844) | 13 | 9 | 1 | 57 | 17 | |||
152935 | 14731 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 912X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1997 12:00:00 AM | 6 | 6004848.1679 | 2112085.98552 | 37.7796596496687 | -122.426821804086 | (37.7796596496687, -122.426821804086) | 7 | 9 | 11 | 28852 | 41 | |||
154292 | 142260 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 566 FELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004691.5283 | 2110560.7676 | 37.7754629180406 | -122.427255013183 | (37.7754629180406, -122.427255013183) | 7 | 9 | 11 | 28852 | 10 | |||
155242 | 138855 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 517 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004909.9473 | 2111074.8774 | 37.776886887754 | -122.426536065317 | (37.776886887754, -122.426536065317) | 7 | 9 | 11 | 28852 | 10 | |||
157616 | 141987 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1047 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004139.84 | 2111815.1387 | 37.7788758968254 | -122.429252898528 | (37.7788758968254, -122.429252898528) | 7 | 9 | 11 | 29490 | 41 | |||
157873 | 126500 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000899.88147 | 2118980.33539 | 37.7983657185536 | -122.440975336363 | (37.7983657185536, -122.440975336363) | 13 | 9 | 1 | 57 | 17 | |||
158435 | 126499 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1636 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005076.86043 | 2119214.79365 | 37.7992464965988 | -122.426538412535 | (37.7992464965988, -122.426538412535) | 13 | 9 | 1 | 57 | 17 | |||
162807 | 126502 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000862.28412 | 2118975.43357 | 37.7983501180095 | -122.441105082435 | (37.7983501180095, -122.441105082435) | 13 | 9 | 1 | 57 | 17 | |||
168367 | 14641 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 600X McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1998 12:00:00 AM | 8 | 4x4 | 6006147.64251 | 2112148.2738 | 37.7799040650672 | -122.422330778736 | (37.7799040650672, -122.422330778736) | 7 | 9 | 11 | 28852 | 41 | ||
168569 | 137794 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2001 CALIFORNIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004786.5899 | 2115639.5455 | 37.7894133591775 | -122.427288032938 | (37.7894133591775, -122.427288032938) | 13 | 9 | 11 | 28858 | 27 | |||
173377 | 126524 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1550 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002732.93596 | 2121317.83643 | 37.8048881155466 | -122.434799663981 | (37.8048881155466, -122.434799663981) | 13 | 9 | 1 | 57 | 17 | |||
178180 | 246578 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6005224.61763 | 2109380.51832 | 37.7722523731835 | -122.425326922304 | (37.7722523731835, -122.425326922304) | 7 | 9 | 11 | 28852 | 10 | |||
178959 | 137812 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1802 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004857.7279 | 2115477.5519 | 37.7889725883007 | -122.42703036076 | (37.7889725883007, -122.42703036076) | 13 | 9 | 1 | 28858 | 27 | |||
179067 | 246576 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 5 | : | Tree | Private 2 | 11 | Width 3ft | 6005228.37861 | 2109333.02061 | 37.7721221684335 | -122.42531053216 | (37.7721221684335, -122.42531053216) | 7 | 9 | 11 | 28852 | 10 | |||
187177 | 244451 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 600 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003597.7695 | 2109704.6031 | 37.7730501849709 | -122.430977465184 | (37.7730501849709, -122.430977465184) | 15 | 9 | 11 | 29492 | 10 | |||
187425 | 126520 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Alhambra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000968.94208 | 2120040.14536 | 37.8012796092356 | -122.440812430464 | (37.8012796092356, -122.440812430464) | 13 | 9 | 1 | 57 | 17 | |||
187626 | 126512 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 251 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000962.49695 | 2119994.9542 | 37.8011551592542 | -122.440831489795 | (37.8011551592542, -122.440831489795) | 13 | 9 | 1 | 57 | 17 | |||
187709 | 28242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 815 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2001 12:00:00 AM | 3 | 3X3 | 6003956.63253 | 2110750.38303 | 37.7759419673559 | -122.42981071961 | (37.7759419673559, -122.42981071961) | 7 | 9 | 11 | 29492 | 10 | ||
188422 | 224093 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 353 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004017.83242 | 2109024.56898 | 37.7712067701103 | -122.429475909489 | (37.7712067701103, -122.429475909489) | 7 | 9 | 11 | 29492 | 10 | |||
189880 | 137795 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2001 CALIFORNIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004791.6159 | 2115599.7237 | 37.7893043027615 | -122.427267805749 | (37.7893043027615, -122.427267805749) | 13 | 9 | 11 | 28858 | 27 | |||
67463 | 55804 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1631 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1973 12:00:00 AM | 12 | Permit Number 11848 | 6005137.19925 | 2119177.96133 | 37.7991487753414 | -122.42632699542 | (37.7991487753414, -122.42632699542) | 13 | 9 | 1 | 57 | 17 | ||
31066 | 56439 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 12650 | 6005234.88834925 | 2109313.51101723 | 37.7720689675781 | -122.425286625875 | (37.7720689675781, -122.425286625875) | 7 | 9 | 11 | 28852 | 10 | ||
165274 | 61980 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3105 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | 11 | Permit Number 22047 | 6004204.10885 | 2119849.9786 | 37.8009411736685 | -122.4296037598 | (37.8009411736685, -122.4296037598) | 13 | 9 | 1 | 57 | 17 | |
193756 | 61982 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3150 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1989 12:00:00 AM | Permit Number 22049 | 6004241.15992791 | 2119938.65131172 | 37.8011867438319 | -122.429481874601 | (37.8011867438319, -122.429481874601) | 13 | 9 | 1 | 57 | 17 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );