trees
190 rows where Police Districts = 9 and qSpecies_id = 8
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1308 | 52427 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1815X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004786.32091155 | 2115731.58720361 | 37.7896660673411 | -122.427295522794 | (37.7896660673411, -122.427295522794) | 13 | 9 | 11 | 28858 | 27 |
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 | |||
2884 | 46077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 814 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2001 12:00:00 AM | Permit Number 44458 | 6003949.63841524 | 2110800.90118746 | 37.7760802817088 | -122.429838518249 | (37.7760802817088, -122.429838518249) | 7 | 9 | 11 | 29492 | 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 | |||
5105 | 153628 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3140 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780837 | 6004230.96494 | 2119993.8857 | 37.8013378259475 | -122.429521095049 | (37.8013378259475, -122.429521095049) | 13 | 9 | 1 | 57 | 17 | |
6315 | 46517 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 182 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2003 12:00:00 AM | Permit Number 46010 | 6005209.24135079 | 2109497.7250609 | 37.7725733258296 | -122.425388452589 | (37.7725733258296, -122.425388452589) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
9725 | 31671 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1435 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1995 12:00:00 AM | 11 | Permit Number 35179 | 6007129.43317 | 2116257.26195 | 37.7912416742097 | -122.419225877479 | (37.7912416742097, -122.419225877479) | 13 | 9 | 10 | 28858 | 21 | |
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 | |||
12399 | 55507 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1660 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/25/1986 12:00:00 AM | 20 | Permit Number 23375 | 6004977.3709 | 2119202.3279 | 37.7992066440205 | -122.426881792584 | (37.7992066440205, -122.426881792584) | 13 | 9 | 1 | 57 | 17 | |
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 | |||
18297 | 51025 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 51 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | Permit Number 47502 | 6005670.67188859 | 2109250.29159524 | 37.7719199923513 | -122.423774718207 | (37.7719199923513, -122.423774718207) | 7 | 9 | 5 | 28852 | 10 | |||
20072 | 52428 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1809X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004799.3483 | 2115577.2997 | 37.7892431693813 | -122.427239454587 | (37.7892431693813, -122.427239454587) | 13 | 9 | 11 | 28858 | 27 |
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 | |||
23473 | 87390 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3318 Fillmore St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2008 12:00:00 AM | 3x3 | Permit Number 50367 | 6002344.5 | 2119563.8 | 37.8000499325498 | -122.436018296661 | (37.8000499325498, -122.436018296661) | 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 | |||
26406 | 33945 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2858 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | 8 | Permit Number 45901 | 6004794.02705 | 2119422.76429 | 37.7998015374823 | -122.427531938546 | (37.7998015374823, -122.427531938546) | 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 | |||
29099 | 33334 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3360 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 8 | 6x9 | Permit Number 37474 | 6004131.26666 | 2120719.53303 | 37.8033246198945 | -122.42991788582 | (37.8033246198945, -122.42991788582) | 13 | 9 | 1 | 28858 | 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 | ||
32015 | 61986 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3219 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | 13 | Permit Number 22053 | 6004150.64271 | 2120237.53433 | 37.8020022738516 | -122.429816434187 | (37.8020022738516, -122.429816434187) | 13 | 9 | 1 | 57 | 17 | |
32383 | 88740 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51675 | 6004299 | 2109043 | 37.7712732924091 | -122.428504653556 | (37.7712732924091, -122.428504653556) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
33184 | 31346 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 5 | Permit Number 34957 | 6004784.8126 | 2111056.6827 | 37.7768298546653 | -122.426967648313 | (37.7768298546653, -122.426967648313) | 7 | 9 | 11 | 28852 | 10 | |
34097 | 115876 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1880 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005184.1768 | 2117160.91115 | 37.793613123489 | -122.426020771756 | (37.793613123489, -122.426020771756) | 13 | 9 | 1 | 28858 | 27 | ||
34618 | 63613 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 191 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 24252 | 6005229.19307431 | 2109538.39058576 | 37.7726861107413 | -122.425322331795 | (37.7726861107413, -122.425322331795) | 7 | 9 | 11 | 28852 | 10 | ||
35395 | 64964 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1649 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 12 | Permit Number 25999 | 6005045.10624 | 2119511.23081 | 37.8000586419391 | -122.426669414059 | (37.8000586419391, -122.426669414059) | 13 | 9 | 1 | 57 | 17 | |
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 | |||
36343 | 87872 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2334 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50844 | 6000114.75256 | 2119911.95547 | 37.8008789504673 | -122.443759078037 | (37.8008789504673, -122.443759078037) | 13 | 9 | 1 | 57 | 17 | |
36476 | 115877 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1880 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005144.10497 | 2117158.82947 | 37.7936051429156 | -122.42615927544 | (37.7936051429156, -122.42615927544) | 13 | 9 | 1 | 28858 | 27 | ||
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 | |||
38299 | 66118 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 262 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29177 | 6004443.55987266 | 2109134.3816324 | 37.771532383715 | -122.428011127655 | (37.771532383715, -122.428011127655) | 7 | 9 | 11 | 28852 | 10 | ||
45388 | 84616 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 65 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50830 | 6001046.02752 | 2119987.7015 | 37.8011400020673 | -122.440541917971 | (37.8011400020673, -122.440541917971) | 13 | 9 | 1 | 57 | 17 | |
46236 | 87868 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 65 Avila St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50830 | 6001059 | 2119911 | 37.8009301387701 | -122.440491523393 | (37.8009301387701, -122.440491523393) | 13 | 9 | 1 | 57 | 17 | ||
47747 | 52433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1807 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | Permit Number 48548 | 6004803.7724 | 2115546.524 | 37.7891589172332 | -122.427221954641 | (37.7891589172332, -122.427221954641) | 13 | 9 | 11 | 28858 | 27 | |
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 | |||
48194 | 172714 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1487 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782598 | 6005831.81614 | 2119622.88276 | 37.8004096554382 | -122.42395503709 | (37.8004096554382, -122.42395503709) | 13 | 9 | 1 | 28858 | 32 | |
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 | |||
48583 | 87865 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 65 Avila St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50830 | 6001049.07284 | 2119968.8143 | 37.8010883162347 | -122.440530024452 | (37.8010883162347, -122.440530024452) | 13 | 9 | 1 | 57 | 17 | |
50099 | 52435 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1808 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48549 | 6004868.1713119 | 2115451.13806854 | 37.7889006530789 | -122.426992345901 | (37.7889006530789, -122.426992345901) | 13 | 9 | 1 | 28858 | 27 | ||
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 | |||
57493 | 64965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1695 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 9 | Permit Number 26000 | 6004890.47461 | 2119142.08334 | 37.7990363142334 | -122.42717819022 | (37.7990363142334, -122.42717819022) | 13 | 9 | 1 | 57 | 17 | |
57827 | 34683 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1901X Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2013 12:00:00 AM | 2 | Permit Number 770151 | 6003781.4605 | 2118989.07405 | 37.7985534124753 | -122.43100482351 | (37.7985534124753, -122.43100482351) | 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 | |||
58419 | 32155 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 521 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | 7 | Permit Number 35505 | 6004828.77889 | 2111059.03276 | 37.7768387933121 | -122.426815722994 | (37.7768387933121, -122.426815722994) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
60161 | 33723 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 52 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37790 | 6003978.61539507 | 2108896.55422138 | 37.7708530523079 | -122.429602431291 | (37.7708530523079, -122.429602431291) | 7 | 9 | 11 | 29492 | 10 | |||
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 | |||
64853 | 52436 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1808 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48549 | 6004868.1713119 | 2115451.13806854 | 37.7889006530789 | -122.426992345901 | (37.7889006530789, -122.426992345901) | 13 | 9 | 1 | 28858 | 27 | ||
66763 | 33335 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3360 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 7 | 9x9 | Permit Number 37474 | 6004127.03344 | 2120735.4068 | 37.8033679654079 | -122.429933668002 | (37.8033679654079, -122.429933668002) | 13 | 9 | 1 | 28858 | 17 |
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 | ||
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 | |||
71932 | 88741 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 92 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51675 | 6004299 | 2109043 | 37.7712732924091 | -122.428504653556 | (37.7712732924091, -122.428504653556) | 7 | 9 | 11 | 28852 | 10 | ||
72095 | 58393 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 511 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2008 12:00:00 AM | 20 | 3x3 | Permit Number 51724 | 6005404.80617926 | 2110951.74140997 | 37.7765767492195 | -122.424815434114 | (37.7765767492195, -122.424815434114) | 7 | 9 | 11 | 28852 | 10 | |
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 | ||
74042 | 61992 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3315 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | Permit Number 22059 | 6004110.15533963 | 2120501.76517011 | 37.8027254903671 | -122.429975398963 | (37.8027254903671, -122.429975398963) | 13 | 9 | 1 | 57 | 17 | ||
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 | |||
75073 | 63599 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 241 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1987 12:00:00 AM | 8x6 | Permit Number 24233 | 6004551.34106685 | 2109096.89343089 | 37.7714355473733 | -122.427635635138 | (37.7714355473733, -122.427635635138) | 7 | 9 | 11 | 28852 | 10 | |
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 | |||
76415 | 87186 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3041 Webster St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50188 | 6002864 | 2119027 | 37.7986055186493 | -122.434182233436 | (37.7986055186493, -122.434182233436) | 13 | 9 | 1 | 57 | 17 | |||
77189 | 52437 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1808 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48549 | 6004868.1713119 | 2115451.13806854 | 37.7889006530789 | -122.426992345901 | (37.7889006530789, -122.426992345901) | 13 | 9 | 1 | 28858 | 27 | ||
77337 | 64966 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1690 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 9 | Permit Number 26001 | 6004915.29698 | 2119193.66495 | 37.79917934781 | -122.427095972412 | (37.79917934781, -122.427095972412) | 13 | 9 | 1 | 57 | 17 | |
78668 | 50867 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2626 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | Permit Number 47381 | 6001007.94143804 | 2117610.91289932 | 37.7946117985032 | -122.440503146962 | (37.7946117985032, -122.440503146962) | 13 | 9 | 1 | 57 | 27 | |||
81050 | 87866 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 65 Avila St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50830 | 6001059 | 2119911 | 37.8009301387701 | -122.440491523393 | (37.8009301387701, -122.440491523393) | 13 | 9 | 1 | 57 | 17 | ||
81351 | 31348 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 611 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | Permit Number 34959 | 6004950.38276667 | 2110982.38504046 | 37.7766352121679 | -122.42638959957 | (37.7766352121679, -122.42638959957) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
85115 | 100357 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 566 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2012 12:00:00 AM | 1 | Permit Number 769115 | 6004695.2 | 2110571.1 | 37.7754914959302 | -122.427243048056 | (37.7754914959302, -122.427243048056) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
87541 | 83184 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 223 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51667 | 6004633.65578728 | 2109108.35984762 | 37.7714716870977 | -122.427351721243 | (37.7714716870977, -122.427351721243) | 7 | 9 | 11 | 28852 | 10 | ||
87764 | 61985 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3212 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | 11 | Permit Number 22052 | 6004200.44828 | 2120220.07156 | 37.8019571458696 | -122.429642837148 | (37.8019571458696, -122.429642837148) | 13 | 9 | 1 | 57 | 17 | |
90366 | 55965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2740 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2015 12:00:00 AM | 18 | 5x5 | Permit Number 773535 | 6006142.14258 | 2120235.85685 | 37.8021102410536 | -122.422924771976 | (37.8021102410536, -122.422924771976) | 5 | 9 | 1 | 28858 | 32 | |
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 | |||
93522 | 256142 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1487 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 782598 | 6005892.76091 | 2119629.13744 | 37.8004302697025 | -122.423744588545 | (37.8004302697025, -122.423744588545) | 13 | 9 | 1 | 28858 | 32 | |
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 | |||
96778 | 64972 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1627 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1989 12:00:00 AM | Permit Number 26007 | 6005156.95767536 | 2119176.82289308 | 37.7991467663209 | -122.426258543392 | (37.7991467663209, -122.426258543392) | 13 | 9 | 1 | 57 | 17 | ||
97010 | 40609 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1262 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/1999 12:00:00 AM | 10 | Permit Number 41619 | 6005248.55961 | 2120627.08998 | 37.8031340049926 | -122.426044866398 | (37.8031340049926, -122.426044866398) | 13 | 9 | 1 | 28858 | 17 | ||
98178 | 47029 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 121 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | 5 | Permit Number 778397 | 6003325.68265754 | 2108679.50884572 | 37.7702201068925 | -122.431845439306 | (37.7702201068925, -122.431845439306) | 15 | 9 | 5 | 29492 | 9 | |
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 | |||
102272 | 64786 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1989 12:00:00 AM | Permit Number 25781 | 6005246.79588468 | 2109227.98306531 | 37.7718348011935 | -122.425239349655 | (37.7718348011935, -122.425239349655) | 7 | 9 | 11 | 28852 | 10 | ||
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 |
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) );