trees
1,985 rows where qSpecies_id = 83 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
88487 | 213958 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5994774.32905 | 2091126.87145 | 37.7215364993901 | -122.460152462564 | (37.7215364993901, -122.460152462564) | 9 | 8 | 6 | 28861 | 24 | |||
73942 | 213970 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995027.09423 | 2091143.79671 | 37.721597507608 | -122.459279952927 | (37.721597507608, -122.459279952927) | 9 | 8 | 6 | 28861 | 24 | |||
97733 | 213959 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994775.57323 | 2091144.94508 | 37.721586196814 | -122.460149470543 | (37.721586196814, -122.460149470543) | 9 | 8 | 6 | 28861 | 24 | |||
114931 | 213960 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994774.81066 | 2091163.63557 | 37.7216374725616 | -122.460153459937 | (37.7216374725616, -122.460153459937) | 9 | 8 | 6 | 28861 | 24 | |||
56476 | 213969 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995027.18674 | 2091165.82123 | 37.7216579869959 | -122.459281227274 | (37.7216579869959, -122.459281227274) | 9 | 8 | 6 | 28861 | 24 | |||
39384 | 213968 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995026.49617 | 2091185.65951 | 37.7217124184688 | -122.459285050266 | (37.7217124184688, -122.459285050266) | 9 | 8 | 6 | 28861 | 24 | |||
179345 | 213961 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994775.27388 | 2091185.74798 | 37.7216982145873 | -122.460153459921 | (37.7216982145873, -122.460153459921) | 9 | 8 | 6 | 28861 | 24 | |||
132540 | 87073 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 395 Byxbee St | 4 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
134671 | 87072 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 395 Byxbee St | 3 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
3470 | 260424 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 751 Goettingen St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6010808.85842 | 2091198.73798 | 37.7226430782423 | -122.404730210147 | (37.7226430782423, -122.404730210147) | 10 | 3 | 7 | 309 | 28 | |||
87195 | 213966 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 621 Holloway Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994898.75092 | 2091213.04066 | 37.7217802552317 | -122.459728611213 | (37.7217802552317, -122.459728611213) | 9 | 8 | 6 | 28861 | 24 | |||
144385 | 213965 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 621 Holloway Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5994879.14088 | 2091213.45138 | 37.7217802552499 | -122.459796427288 | (37.7217802552499, -122.459796427288) | 9 | 8 | 6 | 28861 | 24 | |||
85785 | 213967 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 621 Holloway Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994931.65056 | 2091213.50095 | 37.72178341096 | -122.459614919817 | (37.72178341096, -122.459614919817) | 9 | 8 | 6 | 28861 | 24 | |||
137170 | 213963 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 621 Holloway Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994830.12755 | 2091215.05246 | 37.7217818326369 | -122.45996596837 | (37.7217818326369, -122.45996596837) | 9 | 8 | 6 | 28861 | 24 | |||
23953 | 213964 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 621 Holloway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994850.90322 | 2091215.19212 | 37.7217834109648 | -122.459894162891 | (37.7217834109648, -122.459894162891) | 9 | 8 | 6 | 28861 | 24 | |||
136791 | 213962 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 621 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994792.34345 | 2091215.55668 | 37.7217810439445 | -122.460096613778 | (37.7217810439445, -122.460096613778) | 9 | 8 | 6 | 28861 | 24 | |||
43778 | 213947 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 300 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995892.36071 | 2091233.57233 | 37.7218937190991 | -122.456295465473 | (37.7218937190991, -122.456295465473) | 9 | 8 | 4 | 28861 | 24 | |||
151467 | 213948 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 300 Holloway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995862.50546 | 2091234.82146 | 37.7218954350104 | -122.456398757109 | (37.7218954350104, -122.456398757109) | 9 | 8 | 4 | 28861 | 24 | |||
138242 | 30938 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1106 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 8 | 3x3 | Permit Number 772469 | 5995956.71997 | 2091289.90864 | 37.7220520996181 | -122.456077064214 | (37.7220520996181, -122.456077064214) | 9 | 8 | 4 | 28861 | 24 | |
134997 | 179284 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 721 Goettingen St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 4ft | 6010763.30464 | 2091319.72205 | 37.7229727292859 | -122.404896194231 | (37.7229727292859, -122.404896194231) | 10 | 3 | 7 | 309 | 28 | |||
1245 | 213791 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 209 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 768064 | 5995620.63174 | 2091343.81767 | 37.7221808240739 | -122.45724272857 | (37.7221808240739, -122.45724272857) | 9 | 8 | 4 | 28861 | 24 |
95813 | 213949 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 223 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994439.27208 | 2091407.20179 | 37.7222869413827 | -122.461330966572 | (37.7222869413827, -122.461330966572) | 9 | 8 | 4 | 28861 | 24 | |||
3545 | 70593 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 314 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004216.40489 | 2091443.51048 | 37.722944495983 | -122.427536307463 | (37.722944495983, -122.427536307463) | 9 | 7 | 6 | 28861 | 5 | |||
3969 | 73442 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 314 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004223.02083 | 2091452.87155 | 37.7229705736272 | -122.427514104094 | (37.7229705736272, -122.427514104094) | 9 | 7 | 6 | 28861 | 5 | |||
7088 | 70592 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 312 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6004234.1327 | 2091472.60684 | 37.7230253908821 | -122.4274770979 | (37.7230253908821, -122.4274770979) | 9 | 7 | 6 | 28861 | 5 | |||
27070 | 179328 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 381 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003082.18231 | 2091589.31338 | 37.7232806193946 | -122.431467482451 | (37.7232806193946, -122.431467482451) | 9 | 7 | 6 | 28861 | 5 | |||
87766 | 179326 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 327 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003741.70772 | 2091620.88811 | 37.7234046745582 | -122.429189879225 | (37.7234046745582, -122.429189879225) | 9 | 7 | 6 | 28861 | 5 | |||
89213 | 179329 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 381 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003114.67783 | 2091636.05117 | 37.7234107926576 | -122.431358486426 | (37.7234107926576, -122.431358486426) | 9 | 7 | 6 | 28861 | 5 | |||
5553 | 70621 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 713 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004140.66992 | 2091658.50291 | 37.7235305337986 | -122.427813419165 | (37.7235305337986, -122.427813419165) | 9 | 7 | 6 | 28861 | 5 | |||
129383 | 55344 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1518 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/1972 12:00:00 AM | 11 | Permit Number 11275 | 6007044.75091 | 2091766.91199 | 37.723992057772 | -122.417782186794 | (37.723992057772, -122.417782186794) | 9 | 7 | 7 | 309 | 28 | ||
81774 | 65172 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 332 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 27153 | 6003474.08618593 | 2091790.3446491 | 37.72385481082 | -122.430127080192 | (37.72385481082, -122.430127080192) | 9 | 7 | 6 | 28861 | 5 | ||
60897 | 179327 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 332 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003477.0395 | 2091792.3955 | 37.7238606092698 | -122.430117017306 | (37.7238606092698, -122.430117017306) | 9 | 7 | 6 | 28861 | 5 | |||
119008 | 38191 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 642 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42701 | 6011185.93624372 | 2091843.1881073 | 37.7244336742141 | -122.403472045096 | (37.7244336742141, -122.403472045096) | 10 | 3 | 7 | 309 | 28 | ||
12053 | 72144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6000049.527 | 2091859.62504 | 37.7238504846937 | -122.441970156497 | (37.7238504846937, -122.441970156497) | 9 | 7 | 6 | 28861 | 25 | |||
96641 | 83904 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50528 | 6000071.45882216 | 2091861.79510204 | 37.7238576929528 | -122.441894497682 | (37.7238576929528, -122.441894497682) | 9 | 7 | 6 | 28861 | 25 | ||
68242 | 46849 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 273 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 5 | Permit Number 44917 | 6003953.72556 | 2091952.73307 | 37.7243278475403 | -122.428480614512 | (37.7243278475403, -122.428480614512) | 9 | 7 | 6 | 28861 | 5 | |
14084 | 258134 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 131 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6011357.19142 | 2092082.52958 | 37.7251004206417 | -122.402896861649 | (37.7251004206417, -122.402896861649) | 10 | 3 | 7 | 309 | 28 | |||
15913 | 258136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 125 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x4 | 6011373.95167 | 2092087.62826 | 37.7251153564238 | -122.402839281337 | (37.7251153564238, -122.402839281337) | 10 | 3 | 7 | 309 | 28 | ||
51805 | 179306 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 272 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003680.49546 | 2092115.04602 | 37.7247580571263 | -122.429436701757 | (37.7247580571263, -122.429436701757) | 9 | 7 | 6 | 28861 | 5 | |||
89744 | 179307 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 263 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6003768.55013 | 2092162.80496 | 37.724894177618 | -122.429135711245 | (37.724894177618, -122.429135711245) | 9 | 7 | 6 | 28861 | 5 | |||
19440 | 262431 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 231 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2019 12:00:00 AM | 3x3 | 6002625 | 2092333 | 37.7252966937933 | -122.433100982945 | (37.7252966937933, -122.433100982945) | 9 | 7 | 6 | 28861 | 5 | ||
193501 | 179308 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 223 Edinburgh St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 6003895.65676 | 2092365.82614 | 37.7254588232518 | -122.428710784278 | (37.7254588232518, -122.428710784278) | 9 | 7 | 6 | 28861 | 5 | |||
43165 | 179305 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 226 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003843.99427 | 2092374.03152 | 37.7254784293655 | -122.428889961619 | (37.7254784293655, -122.428889961619) | 9 | 7 | 6 | 28861 | 5 | |||
114724 | 179309 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 213 Edinburgh St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6003911.34447 | 2092391.41197 | 37.7255299641136 | -122.428658376308 | (37.7255299641136, -122.428658376308) | 9 | 7 | 6 | 28861 | 5 | |||
189553 | 175420 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 211 Edinburgh St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6003926.56795 | 2092414.35505 | 37.7255938222743 | -122.428607384746 | (37.7255938222743, -122.428607384746) | 9 | 7 | 6 | 28861 | 5 | |||
136492 | 179304 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 210 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003900.76299 | 2092464.46075 | 37.7257299409794 | -122.428700160583 | (37.7257299409794, -122.428700160583) | 9 | 7 | 6 | 28861 | 5 | |||
179734 | 110496 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 234 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003585.89382 | 2092469.97138 | 37.7257272466074 | -122.429789031845 | (37.7257272466074, -122.429789031845) | 9 | 7 | 6 | 28861 | 5 | |||
21998 | 110495 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 230 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003598.79471 | 2092490.01573 | 37.7257830144685 | -122.429745863482 | (37.7257830144685, -122.429745863482) | 9 | 7 | 6 | 28861 | 5 | |||
94237 | 179310 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 433 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6006956.66212 | 2092492.35946 | 37.7259790226133 | -122.418138103411 | (37.7259790226133, -122.418138103411) | 9 | 3 | 7 | 309 | 28 | |||
33517 | 179311 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 427 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006943.30245 | 2092535.62338 | 37.7260970640242 | -122.418187352968 | (37.7260970640242, -122.418187352968) | 9 | 3 | 7 | 309 | 28 | |||
160028 | 106724 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 421 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6006940.66037 | 2092543.63058 | 37.7261189013498 | -122.418197053944 | (37.7261189013498, -122.418197053944) | 9 | 3 | 7 | 309 | 28 | ||||
163789 | 179312 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 407 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6006926.51281 | 2092590.56457 | 37.726246975603 | -122.41824928748 | (37.726246975603, -122.41824928748) | 9 | 3 | 7 | 309 | 28 | |||
157598 | 179294 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 187 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004035.67978 | 2092592.11371 | 37.7260880824925 | -122.428242857139 | (37.7260880824925, -122.428242857139) | 9 | 7 | 6 | 28861 | 5 | |||
47390 | 179303 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 204 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003684.6928 | 2092628.55261 | 37.726168269631 | -122.429458795389 | (37.726168269631, -122.429458795389) | 9 | 7 | 6 | 28861 | 5 | |||
54499 | 85635 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1101 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017893.31364 | 2092631.421507 | 37.7269703746724 | -122.380340070254 | (37.7269703746724, -122.380340070254) | 10 | 3 | 8 | 58 | 1 | ||
139167 | 199972 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1200 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6017032.2494 | 2092637.585 | 37.7269397498685 | -122.383317211424 | (37.7269397498685, -122.383317211424) | 10 | 3 | 8 | 58 | 1 | |||
5177 | 179302 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 200 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003690.09434 | 2092638.18195 | 37.7261950154772 | -122.429440808968 | (37.7261950154772, -122.429440808968) | 9 | 7 | 6 | 28861 | 5 | |||
97600 | 179293 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 180 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004018.855 | 2092658.23186 | 37.7262686762461 | -122.428305729646 | (37.7262686762461, -122.428305729646) | 9 | 7 | 6 | 28861 | 5 | |||
88753 | 199943 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1101 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6017830.3585 | 2092664.2977 | 37.7270571724447 | -122.380559991407 | (37.7270571724447, -122.380559991407) | 10 | 3 | 8 | 58 | 1 | |||
88464 | 179292 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 180 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004024.15435 | 2092667.65473 | 37.7262948492128 | -122.428288081343 | (37.7262948492128, -122.428288081343) | 9 | 7 | 6 | 28861 | 5 | |||
18559 | 70412 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1817 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6005464.04095 | 2092680.05814 | 37.7264102753879 | -122.423311341054 | (37.7264102753879, -122.423311341054) | 9 | 7 | 7 | 309 | 5 | |||
192122 | 179301 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 324 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003618.31142 | 2092719.86754 | 37.7264152414524 | -122.429694781997 | (37.7264152414524, -122.429694781997) | 9 | 7 | 6 | 28861 | 5 | |||
83545 | 179300 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 318 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003594.26211 | 2092734.45611 | 37.7264539365874 | -122.429778959455 | (37.7264539365874, -122.429778959455) | 9 | 7 | 6 | 28861 | 5 | |||
96891 | 199942 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1151 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017725.4053 | 2092742.7421 | 37.7272667732913 | -122.380928267994 | (37.7272667732913, -122.380928267994) | 10 | 3 | 8 | 58 | 1 | |||
192403 | 85487 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 380 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010399.4592 | 2092794.41628 | 37.7270015877346 | -122.406257791158 | (37.7270015877346, -122.406257791158) | 10 | 3 | 7 | 309 | 28 | ||
140355 | 85486 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 380 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010415.33133 | 2092799.63405 | 37.7270168024731 | -122.406203288666 | (37.7270168024731, -122.406203288666) | 10 | 3 | 7 | 309 | 28 | ||
89272 | 85485 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 380 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010430.57281 | 2092804.24892 | 37.7270303264741 | -122.406150923853 | (37.7270303264741, -122.406150923853) | 10 | 3 | 7 | 309 | 28 | ||
184497 | 199941 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1161 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6017637.764 | 2092806.0386 | 37.7274357354826 | -122.381235645904 | (37.7274357354826, -122.381235645904) | 10 | 3 | 8 | 58 | 1 | |||
174114 | 85610 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1132 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017745.1516 | 2092811.7191 | 37.7274572605947 | -122.380864797529 | (37.7274572605947, -122.380864797529) | 10 | 3 | 8 | 58 | 1 | ||
25176 | 85636 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1161 Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017631.370144 | 2092826.687243 | 37.7274920796749 | -122.381259184857 | (37.7274920796749, -122.381259184857) | 10 | 3 | 8 | 58 | 1 | ||
126859 | 85611 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1150 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017700.249 | 2092841.4739 | 37.7275364831055 | -122.381022095395 | (37.7275364831055, -122.381022095395) | 10 | 3 | 8 | 58 | 1 | ||
20758 | 38463 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1160 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1998 12:00:00 AM | 4 | Permit Number 40473 | 6017671.3057 | 2092861.7612 | 37.7275905904586 | -122.38112356357 | (37.7275905904586, -122.38112356357) | 10 | 3 | 8 | 58 | 1 | ||
691 | 199940 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1177 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017562.0246 | 2092865.5482 | 37.7275949559017 | -122.381501616556 | (37.7275949559017, -122.381501616556) | 10 | 3 | 8 | 58 | 1 | |||
142318 | 85637 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1177 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017561.518521 | 2092878.758124 | 37.7276311998388 | -122.381504284348 | (37.7276311998388, -122.381504284348) | 10 | 3 | 8 | 58 | 1 | ||
92413 | 85612 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1160 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017578.234449 | 2092916.188247 | 37.7277348985577 | -122.381449098373 | (37.7277348985577, -122.381449098373) | 10 | 3 | 8 | 58 | 1 | ||
194376 | 171271 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 3ft | 6004457.49043 | 2092972.68503 | 37.7271569051579 | -122.426811773162 | (37.7271569051579, -122.426811773162) | 9 | 7 | 6 | 28861 | 5 | ||
3900 | 36339 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 59 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906106 | 2092991.57857678 | 37.726705001322 | -122.457372735726 | (37.726705001322, -122.457372735726) | 9 | 7 | 4 | 28861 | 40 | ||
14032 | 49886 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 59@ WILDWOOD Eastwood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906106 | 2092991.57857678 | 37.726705001322 | -122.457372735726 | (37.726705001322, -122.457372735726) | 9 | 7 | 4 | 28861 | 40 | |||
60010 | 49885 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 59@ WILDWOOD Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906106 | 2092991.57857678 | 37.726705001322 | -122.457372735726 | (37.726705001322, -122.457372735726) | 9 | 7 | 4 | 28861 | 40 | |||
36052 | 179295 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 103 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004297.98606 | 2093012.31391 | 37.7272566975202 | -122.42736600014 | (37.7272566975202, -122.42736600014) | 9 | 7 | 6 | 28861 | 5 | |||
50534 | 179299 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Peru Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004388.44448 | 2093015.96904 | 37.7272718493156 | -122.427053545987 | (37.7272718493156, -122.427053545987) | 9 | 7 | 6 | 28861 | 5 | |||
42075 | 85613 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1190 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017458.1534 | 2093022.4369 | 37.728020006278 | -122.38187161186 | (37.728020006278, -122.38187161186) | 10 | 3 | 8 | 58 | 1 | ||
37749 | 179298 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Peru Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004373.55102 | 2093025.79015 | 37.7272979737044 | -122.427105731855 | (37.7272979737044, -122.427105731855) | 9 | 7 | 6 | 28861 | 5 | |||
28575 | 54817 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1414 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49953 | 6015568.3491 | 2093032.3958 | 37.7279428116622 | -122.388405474303 | (37.7279428116622, -122.388405474303) | 10 | 3 | 8 | 58 | 1 | |
21845 | 179297 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Peru Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004358.25207 | 2093034.47753 | 37.7273209621682 | -122.427159238819 | (37.7273209621682, -122.427159238819) | 9 | 7 | 6 | 28861 | 5 | |||
80513 | 179296 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004346.75764 | 2093042.32572 | 37.7273418615316 | -122.42719953384 | (37.7273418615316, -122.42719953384) | 9 | 7 | 6 | 28861 | 5 | |||
180012 | 85640 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1201X Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017322.9044 | 2093043.5358 | 37.7280704700942 | -122.382340643729 | (37.7280704700942, -122.382340643729) | 10 | 3 | 8 | 58 | 1 | ||
176745 | 85639 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1201X Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017307.7565 | 2093058.1427 | 37.7281097410693 | -122.382394026885 | (37.7281097410693, -122.382394026885) | 10 | 3 | 8 | 58 | 1 | ||
93068 | 85615 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1200X Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017380.895352 | 2093063.294675 | 37.7281279271047 | -122.382141539059 | (37.7281279271047, -122.382141539059) | 10 | 3 | 8 | 58 | 1 | ||
171736 | 85638 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1201X Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017293.1497 | 2093067.8806 | 37.7281356725879 | -122.382445200849 | (37.7281356725879, -122.382445200849) | 10 | 3 | 8 | 58 | 1 | ||
45531 | 85641 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1215 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017274.7558 | 2093081.4055 | 37.7281717932443 | -122.382509730509 | (37.7281717932443, -122.382509730509) | 10 | 3 | 8 | 58 | 1 | ||
163192 | 85614 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1200X Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 5 | 3x3 | 6017331.5604 | 2093113.8652 | 37.7282640589934 | -122.382315610259 | (37.7282640589934, -122.382315610259) | 10 | 3 | 8 | 58 | 1 | ||
165958 | 101777 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1700 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6014038.07825 | 2093123.59043 | 37.7281082970403 | -122.393702081811 | (37.7281082970403, -122.393702081811) | 10 | 3 | 8 | 58 | 1 | |||
158258 | 85642 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1227 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017224.223609 | 2093130.194602 | 37.7283029670068 | -122.382687817525 | (37.7283029670068, -122.382687817525) | 10 | 3 | 8 | 58 | 1 | ||
13606 | 264731 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1515 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014824 | 2093132 | 37.7281750296252 | -122.390985688648 | (37.7281750296252, -122.390985688648) | 10 | 3 | 8 | 58 | 1 | ||||
1502 | 77647 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | 9 | 3 | 7 | 309 | 5 | ||
33810 | 85643 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1235 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017171.4256 | 2093155.5219 | 37.7283695937915 | -122.382872106202 | (37.7283695937915, -122.382872106202) | 10 | 3 | 8 | 58 | 1 | ||
94497 | 213943 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 98 Westwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5995156.25779 | 2093258.26131 | 37.727410745106 | -122.458986493338 | (37.727410745106, -122.458986493338) | 9 | 7 | 4 | 28861 | 40 | |||
170943 | 213944 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 98 Westwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5995156.98418 | 2093277.67362 | 37.7274640883802 | -122.458985387177 | (37.7274640883802, -122.458985387177) | 9 | 7 | 4 | 28861 | 40 | |||
167397 | 85616 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1258 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017082.7023 | 2093297.2628 | 37.7287538840188 | -122.383188691469 | (37.7287538840188, -122.383188691469) | 10 | 3 | 8 | 58 | 1 |
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) );