trees
221 rows where qSpecies_id = 153 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13919 | 71602 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 149 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5994628.01123 | 2086360.41662 | 37.7084405258897 | -122.460313064399 | (37.7084405258897, -122.460313064399) | 9 | 8 | 6 | 28861 | 25 | |||
14562 | 71685 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 249 Wilson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5994260.16312 | 2086694.74554 | 37.7093373478025 | -122.461608605251 | (37.7093373478025, -122.461608605251) | 9 | 8 | 6 | 28861 | 25 | |||
14724 | 71645 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 193 Goethe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994617.0264 | 2086718.36179 | 37.7094227276519 | -122.460376946856 | (37.7094227276519, -122.460376946856) | 9 | 8 | 6 | 28861 | 25 | |||
18603 | 175826 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1669 Geneva Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 6003554.6564 | 2087615.13702 | 37.7123951695857 | -122.429550938144 | (37.7123951695857, -122.429550938144) | 9 | 7 | 6 | 28861 | 5 | |||
25126 | 251400 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 101 Rhine St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 3ft | 5994375.43496 | 2086552.55756 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | 9 | 8 | 6 | 28861 | 25 | ||||
38578 | 40707 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 49 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 9 | Permit Number 41686 | 6002532.07349 | 2093390.42378 | 37.7281948693858 | -122.433497753227 | (37.7281948693858, -122.433497753227) | 9 | 7 | 6 | 28861 | 25 | |
44326 | 175834 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 6 | : | Tree | Private 2 | 6 | Width 3ft | 5994720.17465 | 2086786.57384 | 37.7096159550821 | -122.460025390159 | (37.7096159550821, -122.460025390159) | 9 | 8 | 6 | 28861 | 25 | |||
55123 | 175827 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1669 Geneva Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 8ft | 6003539.76747 | 2087618.63679 | 37.7124039361582 | -122.42960264824 | (37.7124039361582, -122.42960264824) | 9 | 7 | 6 | 28861 | 5 | |||
62139 | 19046 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 115 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5995705.68255 | 2087377.98209 | 37.7112964570392 | -122.456662066002 | (37.7112964570392, -122.456662066002) | 9 | 8 | 6 | 28861 | 24 | |||
71593 | 175832 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 5994691.10568 | 2086786.70031 | 37.7096146303906 | -122.460125866041 | (37.7096146303906, -122.460125866041) | 9 | 8 | 6 | 28861 | 25 | |||
73379 | 175833 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 5 | : | Tree | Private 2 | 5 | Width 3ft | 5994704.65642 | 2086785.934 | 37.709613305686 | -122.46007897717 | (37.709613305686, -122.46007897717) | 9 | 8 | 6 | 28861 | 25 | |||
75950 | 175835 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 101 Rhine St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994375.43496 | 2086552.55756 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | 9 | 8 | 6 | 28861 | 25 | |||
97583 | 205980 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 121 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995564.77238 | 2087377.85645 | 37.7112880204943 | -122.457149074963 | (37.7112880204943, -122.457149074963) | 9 | 8 | 6 | 28861 | 24 | |||
104937 | 175831 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 5994675.09306 | 2086785.58839 | 37.7096106562906 | -122.460181127555 | (37.7096106562906, -122.460181127555) | 9 | 8 | 6 | 28861 | 25 | |||
107571 | 175829 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5994644.58104 | 2086786.22758 | 37.709610656267 | -122.460286627948 | (37.709610656267, -122.460286627948) | 9 | 8 | 6 | 28861 | 25 | |||
115792 | 175830 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5994659.60487 | 2086786.3953 | 37.7096119809882 | -122.460234715484 | (37.7096119809882, -122.460234715484) | 9 | 8 | 6 | 28861 | 25 | |||
165117 | 175825 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1669 Geneva Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 6003581.23003 | 2087608.20421 | 37.7123776381814 | -122.429458597533 | (37.7123776381814, -122.429458597533) | 9 | 7 | 6 | 28861 | 5 | |||
183417 | 46864 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 96 Athens St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44930 | 6004995.61677719 | 2092705.22653245 | 37.726452934298 | -122.424932453632 | (37.726452934298, -122.424932453632) | 9 | 7 | 6 | 28861 | 5 | ||
190723 | 175837 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 101 Rhine St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994356.88277 | 2086531.76861 | 37.7088954182656 | -122.461262522762 | (37.7088954182656, -122.461262522762) | 9 | 8 | 6 | 28861 | 25 | |||
191773 | 175838 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 101 Rhine St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994346.0156 | 2086520.62322 | 37.7088641902123 | -122.461299273568 | (37.7088641902123, -122.461299273568) | 9 | 8 | 6 | 28861 | 25 | |||
192421 | 46860 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 96 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | 7 | Permit Number 44930 | 6005007.55179 | 2092712.98729 | 37.7264749177759 | -122.424891746668 | (37.7264749177759, -122.424891746668) | 9 | 7 | 6 | 28861 | 5 | ||
3622 | 222861 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 77 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008184.4457 | 2107955.63736 | 37.7685067598049 | -122.414987714411 | (37.7685067598049, -122.414987714411) | 8 | 4 | 7 | 28853 | 19 | |||
8138 | 38246 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40358 | 6008135.39153425 | 2107951.7492744 | 37.7684933273993 | -122.415157113805 | (37.7684933273993, -122.415157113805) | 8 | 4 | 7 | 28853 | 19 | ||
12726 | 78188 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 61 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6007814.1581 | 2093767.18412 | 37.7295276448871 | -122.415263990666 | (37.7295276448871, -122.415263990666) | 9 | 3 | 7 | 309 | 28 | |||
15276 | 40430 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 242 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1999 12:00:00 AM | Permit Number 41525 | 6007877.26148184 | 2097485.40267829 | 37.7397406088372 | -122.415308947554 | (37.7397406088372, -122.415308947554) | 2 | 7 | 7 | 28859 | 2 | ||
22023 | 35972 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 323 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39130 | 6006883.86528874 | 2096321.14092587 | 37.7364879223661 | -122.418661155064 | (37.7364879223661, -122.418661155064) | 2 | 7 | 7 | 28859 | 2 | ||
43668 | 38245 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40358 | 6008135.39153425 | 2107951.7492744 | 37.7684933273993 | -122.415157113805 | (37.7684933273993, -122.415157113805) | 8 | 4 | 7 | 28853 | 19 | ||
55650 | 222871 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 51 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6005724.8358 | 2097421.61611 | 37.7394442577386 | -122.422746599186 | (37.7394442577386, -122.422746599186) | 2 | 7 | 7 | 28859 | 2 | |||
77523 | 222862 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008204.35624 | 2107957.35065 | 37.7685125829154 | -122.414918966632 | (37.7685125829154, -122.414918966632) | 8 | 4 | 7 | 28853 | 19 | |||
84625 | 35990 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 222 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | 3x3 | Permit Number 39141 | 6006789.6042559 | 2098298.49411338 | 37.7419119870032 | -122.419127271552 | (37.7419119870032, -122.419127271552) | 2 | 7 | 7 | 28859 | 2 | |
98312 | 48741 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 964 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | Permit Number 46597 | 6009929.68094635 | 2103590.07459933 | 37.7566178319635 | -122.40864306235 | (37.7566178319635, -122.40864306235) | 2 | 4 | 7 | 28859 | 19 | ||
123654 | 37019 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1057 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39631 | 6008654.53435588 | 2102395.73728972 | 37.753266951872 | -122.412968551923 | (37.753266951872, -122.412968551923) | 2 | 4 | 7 | 28859 | 19 | ||
128123 | 175839 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 728 Burrows St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009068.66668 | 2092869.3876 | 37.7271329121485 | -122.410863628551 | (37.7271329121485, -122.410863628551) | 9 | 3 | 7 | 309 | 28 | |||
132856 | 37018 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1057 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39631 | 6008654.53435588 | 2102395.73728972 | 37.753266951872 | -122.412968551923 | (37.753266951872, -122.412968551923) | 2 | 4 | 7 | 28859 | 19 | ||
133095 | 222870 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 25 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007227.82526 | 2099384.75669 | 37.7449192898986 | -122.417689017034 | (37.7449192898986, -122.417689017034) | 2 | 7 | 7 | 28859 | 2 | |||
135942 | 222863 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008222.11657 | 2107958.04741 | 37.7685154940131 | -122.414857584305 | (37.7685154940131, -122.414857584305) | 8 | 4 | 7 | 28853 | 19 | |||
151909 | 48945 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 819 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46132 | 6009934.90888897 | 2104445.04060173 | 37.7589656692148 | -122.408685294891 | (37.7589656692148, -122.408685294891) | 2 | 4 | 7 | 28859 | 19 | ||
156537 | 40720 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 36 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 770949 | 6009333.47018643 | 2097251.8201173 | 37.7391809774349 | -122.41025748835 | (37.7391809774349, -122.41025748835) | 10 | 7 | 7 | 28859 | 2 | ||
170623 | 36005 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 315 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39154 | 6008606.55118779 | 2100215.49511804 | 37.7472778014217 | -122.412980345984 | (37.7472778014217, -122.412980345984) | 2 | 7 | 7 | 28859 | 2 | ||
179419 | 38247 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40358 | 6008135.39153425 | 2107951.7492744 | 37.7684933273993 | -122.415157113805 | (37.7684933273993, -122.415157113805) | 8 | 4 | 7 | 28853 | 19 | |
187258 | 222864 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1057 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008644.3268 | 2102383.5696 | 37.7532329691398 | -122.413002991602 | (37.7532329691398, -122.413002991602) | 2 | 4 | 7 | 28859 | 19 | |||
7413 | 74449 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 21 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6014188.34415 | 2094602.28938 | 37.7321768533812 | -122.393286035632 | (37.7321768533812, -122.393286035632) | 10 | 3 | 8 | 58 | 1 | |||
8159 | 78322 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 25 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014069.27853 | 2094204.92894 | 37.7310791669665 | -122.393669873461 | (37.7310791669665, -122.393669873461) | 10 | 3 | 8 | 58 | 1 | ||
11126 | 51368 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014172.09212 | 2094713.43563 | 37.7324811353964 | -122.393349998121 | (37.7324811353964, -122.393349998121) | 10 | 3 | 8 | 58 | 1 |
13195 | 78202 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014063.31576 | 2094176.73754 | 37.7310014277784 | -122.393688515509 | (37.7310014277784, -122.393688515509) | 10 | 3 | 8 | 58 | 1 | ||
16291 | 51365 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014154.93455 | 2094628.60419 | 37.7322472522973 | -122.393403381858 | (37.7322472522973, -122.393403381858) | 10 | 3 | 8 | 58 | 1 |
16535 | 78324 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 23 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014075.45071 | 2094231.93865 | 37.7311536731068 | -122.393650424725 | (37.7311536731068, -122.393650424725) | 10 | 3 | 8 | 58 | 1 | ||
35999 | 115859 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
36425 | 115854 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
37176 | 49776 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 110 Talbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | Permit Number 46562 | 6010272.64518115 | 2086887.71649918 | 37.7107759109747 | -122.406280195673 | (37.7107759109747, -122.406280195673) | 9 | 7 | 8 | 309 | 39 | ||
37804 | 188455 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011498.78949 | 2106422.93471 | 37.76448399066 | -122.403415778809 | (37.76448399066, -122.403415778809) | 8 | 3 | 8 | 28856 | 29 | |||
40010 | 188453 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011500.6075 | 2106371.58763 | 37.7643431046639 | -122.40340587818 | (37.7643431046639, -122.40340587818) | 8 | 3 | 8 | 28856 | 29 | |||
48148 | 188456 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011496.96392 | 2106445.77608 | 37.7645466059608 | -122.403423700042 | (37.7645466059608, -122.403423700042) | 8 | 3 | 8 | 28856 | 29 | |||
55478 | 49757 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1360 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 7 | Permit Number 46553 | 6011586.487 | 2088506.84926 | 37.7152951315438 | -122.401852972956 | (37.7152951315438, -122.401852972956) | 10 | 7 | 8 | 309 | 39 | |
65403 | 116770 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 307 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x6 | 6013506.88243 | 2105617.60092 | 37.7623846762351 | -122.396413832751 | (37.7623846762351, -122.396413832751) | 10 | 3 | 8 | 28856 | 29 | |||
68626 | 115858 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
73325 | 115865 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
74126 | 188445 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011511.33671 | 2106160.81157 | 37.7637649602022 | -122.403353939635 | (37.7637649602022, -122.403353939635) | 8 | 3 | 8 | 28856 | 29 | |||
82479 | 188443 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011515.17164 | 2106121.75692 | 37.7636579390857 | -122.403337928096 | (37.7636579390857, -122.403337928096) | 8 | 3 | 8 | 28856 | 29 | |||
83759 | 115862 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
84919 | 188459 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1300 Evans Ave | 12 | : | Tree | Private 2 | 8 | Width 3ft | 6017898.8154 | 2096917.74741 | 37.7387400867836 | -122.380618860675 | (37.7387400867836, -122.380618860675) | 10 | 3 | 8 | 58 | 1 | |||
86079 | 188451 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011503.70347 | 2106326.77104 | 37.7642202212997 | -122.403392016924 | (37.7642202212997, -122.403392016924) | 8 | 3 | 8 | 28856 | 29 | |||
88567 | 188457 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1300 Evans Ave | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6017980.56674 | 2096851.4508 | 37.7385625606061 | -122.380331593842 | (37.7385625606061, -122.380331593842) | 10 | 3 | 8 | 58 | 1 | |||
88822 | 188444 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011513.49426 | 2106142.74637 | 37.7637154777208 | -122.403345206341 | (37.7637154777208, -122.403345206341) | 8 | 3 | 8 | 28856 | 29 | |||
88876 | 188458 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1300 Evans Ave | 8 | : | Tree | Private 2 | 7 | Width 3ft | 6017965.45294 | 2096866.00027 | 37.7386016766138 | -122.38038486158 | (37.7386016766138, -122.38038486158) | 10 | 3 | 8 | 58 | 1 | |||
95478 | 37963 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 655 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 11 | Permit Number 40194 | 6014150.19564 | 2104114.25281 | 37.7582925873621 | -122.39408358501 | (37.7582925873621, -122.39408358501) | 10 | 3 | 8 | 28856 | 29 | |
99443 | 115866 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
105468 | 188446 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011512.27704 | 2106186.35742 | 37.763835155891 | -122.403352484549 | (37.763835155891, -122.403352484549) | 8 | 3 | 8 | 28856 | 29 | |||
110268 | 188447 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011509.63905 | 2106201.49872 | 37.7638765831644 | -122.40336267386 | (37.7638765831644, -122.40336267386) | 8 | 3 | 8 | 28856 | 29 | |||
111421 | 51367 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/09/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52508 | 6014166.48709 | 2094684.74927 | 37.7324020570933 | -122.39336736943 | (37.7324020570933, -122.39336736943) | 10 | 3 | 8 | 58 | 1 |
119756 | 188450 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011505.24263 | 2106303.9355 | 37.7641576060043 | -122.403385086777 | (37.7641576060043, -122.403385086777) | 8 | 3 | 8 | 28856 | 29 | |||
132403 | 115855 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
140364 | 188454 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6011500.01929 | 2106398.96501 | 37.7644182439416 | -122.403409838819 | (37.7644182439416, -122.403409838819) | 8 | 3 | 8 | 28856 | 29 | |||
146222 | 115860 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
146826 | 188448 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011508.86092 | 2106242.57461 | 37.7639893248743 | -122.403368255061 | (37.7639893248743, -122.403368255061) | 8 | 3 | 8 | 28856 | 29 | |||
147434 | 115861 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
157286 | 188449 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011506.74728 | 2106279.38998 | 37.7640902935593 | -122.403378155697 | (37.7640902935593, -122.403378155697) | 8 | 3 | 8 | 28856 | 29 | |||
161579 | 188452 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011502.89501 | 2106343.32084 | 37.7642656181765 | -122.403395977545 | (37.7642656181765, -122.403395977545) | 8 | 3 | 8 | 28856 | 29 | |||
162996 | 115863 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
173545 | 115867 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
176766 | 115856 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
177372 | 175828 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 490 Harkness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010182.47488 | 2089702.17663 | 37.7184987999604 | -122.406790070203 | (37.7184987999604, -122.406790070203) | 10 | 7 | 8 | 309 | 39 | |||
179557 | 115853 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 401x KANSAS ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011620 | 2106285 | 37.7641120222234 | -122.402986839965 | (37.7641120222234, -122.402986839965) | 8 | 3 | 8 | 28856 | 29 | |||||
179749 | 115864 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
187222 | 115857 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
5393 | 28504 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 270 06th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010824.2979387 | 2111653.7211901 | 37.7788088323978 | -122.406117215604 | (37.7788088323978, -122.406117215604) | 14 | 2 | 9 | 28853 | 34 | |||
23578 | 188462 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011845.31362 | 2109707.14292 | 37.7735210314987 | -122.402448188337 | (37.7735210314987, -122.402448188337) | 14 | 2 | 9 | 28853 | 34 | |||
25730 | 105283 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 190 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009798.61642 | 2111399.33424 | 37.7780529230461 | -122.40964750682 | (37.7780529230461, -122.40964750682) | 8 | 2 | 9 | 28853 | 34 | |||
28981 | 32639 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 787 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 11 | Permit Number 37084 | 6011743.68261 | 2109609.56566 | 37.7732474325671 | -122.402792883183 | (37.7732474325671, -122.402792883183) | 14 | 2 | 9 | 28853 | 34 | |
34969 | 32629 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 766 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 8 | Permit Number 37081 | 6011821.13713 | 2109777.45892 | 37.7737127534642 | -122.402536764383 | (37.7737127534642, -122.402536764383) | 14 | 2 | 9 | 28853 | 34 | |
36778 | 188465 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 766 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011787.2831 | 2109744.85419 | 37.7736213382813 | -122.402651578111 | (37.7736213382813, -122.402651578111) | 14 | 2 | 9 | 28853 | 34 | |||
39097 | 42252 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 151 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50766 | 6010454.20711 | 2111454.07429 | 37.778239941556 | -122.407383433006 | (37.778239941556, -122.407383433006) | 14 | 2 | 9 | 28853 | 34 | |
48796 | 32635 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
57757 | 32659 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 55 Boardman Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 14 | Permit Number 37092 | 6011762.82772 | 2110068.09254 | 37.7745075113438 | -122.402758910415 | (37.7745075113438, -122.402758910415) | 14 | 2 | 9 | 28853 | 34 | |
64231 | 188461 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011834.92433 | 2109696.16508 | 37.7734903088701 | -122.40248335455 | (37.7734903088701, -122.40248335455) | 14 | 2 | 9 | 28853 | 34 | |||
64637 | 32631 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
67222 | 32634 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
70461 | 32632 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
71955 | 188463 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011854.34986 | 2109717.34943 | 37.7735495606877 | -122.402417648277 | (37.7735495606877, -122.402417648277) | 14 | 2 | 9 | 28853 | 34 | |||
74214 | 38807 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 202 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1998 12:00:00 AM | Permit Number 40646 | 6014649.4963121 | 2111590.96099347 | 37.7788497186051 | -122.392879852588 | (37.7788497186051, -122.392879852588) | 6 | 2 | 9 | 28856 | 34 |
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) );