trees
6,714 rows where qSpecies_id = 7 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
159785 | 10018 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 205 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1993 12:00:00 AM | 6 | 3x3 | 6005510.9123943 | 2107567.8958458 | 37.7672915172207 | -122.424207665862 | (37.7672915172207, -122.424207665862) | 8 | 4 | 5 | 28853 | 19 | ||
28194 | 10019 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 205 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6005510.9123943 | 2107567.8958458 | 37.7672915172207 | -122.424207665862 | (37.7672915172207, -122.424207665862) | 8 | 4 | 5 | 28853 | 19 | |||
83504 | 100286 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 1435 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994228.1 | 2105736.9 | 37.7616205515651 | -122.463100142071 | (37.7616205515651, -122.463100142071) | 1 | 5 | 11 | 56 | 12 | |||||
133268 | 100349 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 551 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769104 | 6002969.98856 | 2090393.63163 | 37.7199911835241 | -122.431769984714 | (37.7199911835241, -122.431769984714) | 9 | 7 | 6 | 28861 | 5 | |
140093 | 10039 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 360 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/1991 12:00:00 AM | 20 | 3X3 | 6005477.19258 | 2106955.99773 | 37.76560948682 | -122.424280773358 | (37.76560948682, -122.424280773358) | 8 | 4 | 5 | 28853 | 19 | ||
174779 | 10040 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 360 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005476.56858 | 2106925.65434 | 37.7655261358546 | -122.424280773346 | (37.7655261358546, -122.424280773346) | 8 | 4 | 5 | 28853 | 19 | |||
75410 | 10041 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 360 Guerrero St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1991 12:00:00 AM | 20 | 3X3 | 6005475.31081 | 2106892.46038 | 37.7654349221143 | -122.424282762643 | (37.7654349221143, -122.424282762643) | 8 | 4 | 5 | 28853 | 19 | ||
110173 | 10042 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 360 Guerrero St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005475.5325 | 2106875.27322 | 37.7653877427782 | -122.424280773365 | (37.7653877427782, -122.424280773365) | 8 | 4 | 5 | 28853 | 19 | |||
182738 | 10045 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 375 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2007 12:00:00 AM | 6 | 2X2 | 6005552.9439989 | 2106809.2959802 | 37.7652109557568 | -122.424008332395 | (37.7652109557568, -122.424008332395) | 8 | 4 | 5 | 28853 | 19 | ||
152523 | 100460 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 24 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997085.6 | 2106503.4 | 37.7638893573064 | -122.453272603676 | (37.7638893573064, -122.453272603676) | 15 | 5 | 11 | 29492 | 12 | ||||
194159 | 10077 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 611 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005621.78486 | 2105416.82041 | 37.7613914334809 | -122.423671214664 | (37.7613914334809, -122.423671214664) | 2 | 4 | 5 | 28859 | 19 | |||
61755 | 100883 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Welsh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013382.01151 | 2111778.63358 | 37.7792945414358 | -122.397277778167 | (37.7792945414358, -122.397277778167) | 6 | 2 | 9 | 28856 | 34 | |||
133096 | 100885 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Welsh St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | 3x3 | 6013481.27468 | 2111873.98359 | 37.7795618766263 | -122.396941070175 | (37.7795618766263, -122.396941070175) | 6 | 2 | 9 | 28856 | 34 | ||
5585 | 100886 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Welsh St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013501.81999 | 2111894.49362 | 37.7796193360911 | -122.396871432992 | (37.7796193360911, -122.396871432992) | 6 | 2 | 9 | 28856 | 34 | |||
29056 | 100887 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Welsh St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013527.06662 | 2111917.77164 | 37.7796846574549 | -122.396785725789 | (37.7796846574549, -122.396785725789) | 6 | 2 | 9 | 28856 | 34 | |||
174619 | 100893 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Welsh St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013651.46361 | 2112030.89517 | 37.7800021918959 | -122.396363310639 | (37.7800021918959, -122.396363310639) | 6 | 2 | 9 | 28856 | 34 | |||
154152 | 100908 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1800 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
108778 | 10097 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 744 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2X2 | 6005593.39843 | 2104652.72108 | 37.7592917939369 | -122.423715061076 | (37.7592917939369, -122.423715061076) | 2 | 4 | 5 | 28859 | 19 | |||
106695 | 100983 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
132915 | 100984 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
3324 | 100985 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 03/23/2016 02:34:00 PM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |
191936 | 100987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
63444 | 10099 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 750 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1995 12:00:00 AM | 30 | 2x2 | 6005606.10854 | 2104557.89173 | 37.7590321322447 | -122.423664360924 | (37.7590321322447, -122.423664360924) | 2 | 4 | 5 | 28859 | 19 | ||
125007 | 10100 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 750 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/1995 12:00:00 AM | 40 | 2x2 | 6005607.26399 | 2104540.55602 | 37.7589845976709 | -122.423659132264 | (37.7589845976709, -122.423659132264) | 2 | 4 | 5 | 28859 | 19 | ||
26201 | 10106 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 785 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005679.32961 | 2104414.6071 | 37.7586428391006 | -122.423400941414 | (37.7586428391006, -122.423400941414) | 2 | 4 | 5 | 28859 | 19 | |||
109601 | 10111 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 817 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 | 6005691.67507 | 2104204.22323 | 37.7580658709717 | -122.423343289458 | (37.7580658709717, -122.423343289458) | 2 | 4 | 5 | 28859 | 19 | |||
123731 | 10113 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 827 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005696.52511 | 2104103.91625 | 37.757790725171 | -122.423319385483 | (37.757790725171, -122.423319385483) | 2 | 4 | 5 | 28859 | 19 | |||
37532 | 10114 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 827 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005696.25247 | 2104120.31934 | 37.7578357488369 | -122.423321494416 | (37.7578357488369, -122.423321494416) | 2 | 4 | 5 | 28859 | 19 | |||
81026 | 10115 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 827 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005698.17392 | 2104144.57278 | 37.7579024515588 | -122.423316573309 | (37.7579024515588, -122.423316573309) | 2 | 4 | 5 | 28859 | 19 | |||
106701 | 10117 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 845 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005699.22258 | 2104067.01691 | 37.7576895604408 | -122.423307433493 | (37.7576895604408, -122.423307433493) | 2 | 4 | 5 | 28859 | 19 | |||
53719 | 10118 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 845 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/01/1990 12:00:00 AM | 3 | 3X3 | 6005704.2510557 | 2104056.9285895 | 37.7576621440613 | -122.423289325813 | (37.7576621440613, -122.423289325813) | 2 | 4 | 5 | 28859 | 19 | ||
193072 | 10119 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 850 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/06/1992 12:00:00 AM | 18 | 3X3 | 6005631.880167 | 2104012.3184419 | 37.757535570368 | -122.423536442741 | (37.757535570368, -122.423536442741) | 2 | 4 | 5 | 28859 | 19 | ||
141017 | 10140 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 906 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/1991 12:00:00 AM | 8 | 2x2 | 6005653.96599 | 2103626.9979 | 37.7564788166491 | -122.423432668582 | (37.7564788166491, -122.423432668582) | 2 | 4 | 5 | 28859 | 19 | ||
34075 | 10141 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 906 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6005654.69613 | 2103615.0906 | 37.7564461631881 | -122.423429297021 | (37.7564461631881, -122.423429297021) | 2 | 4 | 5 | 28859 | 19 | |||
73530 | 10142 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 915 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 | 6005723.61297 | 2103645.63054 | 37.7565339082426 | -122.423193128776 | (37.7565339082426, -122.423193128776) | 2 | 4 | 5 | 28859 | 19 | |||
186258 | 101623 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 80 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/2012 12:00:00 AM | 4x4 | Permit Number 769409 | 6000945.5 | 2101263.6 | 37.7497226204904 | -122.439546753899 | (37.7497226204904, -122.439546753899) | 2 | 4 | 5 | 28862 | 22 | |
48849 | 10167 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1021 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005764.98523 | 2102811.58089 | 37.7542461363638 | -122.422990770503 | (37.7542461363638, -122.422990770503) | 2 | 4 | 5 | 28859 | 19 | |||
21856 | 101694 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 265X Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5996668.18061 | 2111006.52263 | 37.7762298334399 | -122.455041737627 | (37.7762298334399, -122.455041737627) | 11 | 6 | 2 | 54 | 16 | |||
110353 | 101695 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 265X Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5996669.11429 | 2110994.57124 | 37.7761970716147 | -122.455037643993 | (37.7761970716147, -122.455037643993) | 11 | 6 | 2 | 54 | 16 | |||
174618 | 102021 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 139 Saturn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5999859 | 2105985 | 37.7626245310548 | -122.443643035925 | (37.7626245310548, -122.443643035925) | 15 | 5 | 5 | 28862 | 3 | |||
34084 | 102045 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2853 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 1x1 | Permit Number 769645 | 5999896.35932 | 2117404.6933 | 37.7939822160532 | -122.444334525426 | (37.7939822160532, -122.444334525426) | 13 | 9 | 1 | 57 | 27 | ||
161913 | 102047 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2853 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 1x1 | Permit Number 769645 | 5999920.96714 | 2117404.74534 | 37.7939837628837 | -122.444249383927 | (37.7939837628837, -122.444249383927) | 13 | 9 | 1 | 57 | 27 | ||
134139 | 102085 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 475 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/2009 12:00:00 AM | 4 | Permit Number 52516 | 5989662.20818 | 2112129.83383 | 37.7789097231702 | -122.479359238366 | (37.7789097231702, -122.479359238366) | 11 | 6 | 2 | 55 | 26 | |
169993 | 10210 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1306 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1992 12:00:00 AM | 18 | 2X2 | 6005782.73241 | 2101317.8159 | 37.7501456037461 | -122.422823243019 | (37.7501456037461, -122.422823243019) | 2 | 4 | 5 | 28859 | 19 | ||
26360 | 102164 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 152 Venus St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6012823.11721 | 2094145.77539 | 37.730847417966 | -122.397973948736 | (37.730847417966, -122.397973948736) | 10 | 3 | 8 | 58 | 1 | |||
72745 | 102377 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 870 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 5983889.8768 | 2109995.31333 | 37.7727119887219 | -122.499169955109 | (37.7727119887219, -122.499169955109) | 11 | 6 | 2 | 55 | 26 | ||||
120564 | 102378 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 870 39th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2 | 5983886.84831 | 2110037.48525 | 37.7728276030319 | -122.499183547509 | (37.7728276030319, -122.499183547509) | 11 | 6 | 2 | 55 | 26 | ||||
117225 | 102628 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 100 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2013 12:00:00 AM | 3x3 | Permit Number 769972 | 6013417.4 | 2111578.2 | 37.778746166691 | -122.397141295625 | (37.778746166691, -122.397141295625) | 6 | 2 | 9 | 28856 | 34 | |
109767 | 102782 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2485 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6001163.50399 | 2118281.20479 | 37.7964611010649 | -122.44001296732 | (37.7964611010649, -122.44001296732) | 13 | 9 | 1 | 57 | 17 | |||
127904 | 102986 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1459 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2013 12:00:00 AM | 3x3 | Permit Number 769945 | 5996811.8 | 2106244.7 | 37.7631633360428 | -122.45420090344 | (37.7631633360428, -122.45420090344) | 15 | 5 | 11 | 29492 | 12 | ||
50677 | 102989 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 161 Edgewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3x3 | 5996558.2 | 2106100.3 | 37.7627523048829 | -122.455067580852 | (37.7627523048829, -122.455067580852) | 15 | 5 | 11 | 29492 | 12 | |||
97172 | 102990 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 161 Edgewood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3x3 | 5996558.2 | 2106100.3 | 37.7627523048829 | -122.455067580852 | (37.7627523048829, -122.455067580852) | 15 | 5 | 11 | 29492 | 12 | |||
38736 | 103621 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3982 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2013 12:00:00 AM | 12 | 3x3 | Permit Number 771038 | 5995737.80986 | 2114868.57006 | 37.7867805691894 | -122.458539756662 | (37.7867805691894, -122.458539756662) | 11 | 6 | 1 | 54 | 31 | |
129277 | 103959 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 460X Lily St | 1 | unknown : Pot | Tree | Private 2 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | |||||
133883 | 104476 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 350X Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2013 12:00:00 AM | 3 | 3x3 | Permit Number 767241 | 6012304.0596 | 2118478.64735 | 37.7976311307414 | -122.401477889986 | (37.7976311307414, -122.401477889986) | 3 | 1 | 10 | 28860 | 6 | |
173560 | 104477 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 350X Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2013 12:00:00 AM | 3 | 3x3 | Permit Number 767241 | 6012286.11088 | 2118476.93783 | 37.7976254353175 | -122.401539877573 | (37.7976254353175, -122.401539877573) | 3 | 1 | 10 | 28860 | 6 | |
183713 | 104496 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 825 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5997621 | 2107726 | 37.7672769785597 | -122.451509016059 | (37.7672769785597, -122.451509016059) | 15 | 5 | 11 | 29492 | 9 | ||||
88605 | 105252 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1875 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770851 | 6004061.8803 | 2118683.0933 | 37.7977291534815 | -122.430012644752 | (37.7977291534815, -122.430012644752) | 13 | 9 | 1 | 57 | 17 | ||||
47525 | 105287 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2567 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 770757 | 6000732.18991 | 2118218.38629 | 37.7962640551003 | -122.441500892961 | (37.7962640551003, -122.441500892961) | 13 | 9 | 1 | 57 | 17 | ||
147327 | 105288 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 2567 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000728.1 | 2118193.8 | 37.7961963146182 | -122.441513279672 | (37.7961963146182, -122.441513279672) | 13 | 9 | 1 | 57 | 17 | ||||
74062 | 106161 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 827 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770049 | 6006757.57528 | 2121490.32366 | 37.8055893943007 | -122.420884191365 | (37.8055893943007, -122.420884191365) | 5 | 1 | 1 | 28858 | 32 | |
138355 | 106848 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 2637 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6001627 | 2117446 | 37.7941942213429 | -122.438349308017 | (37.7941942213429, -122.438349308017) | 13 | 9 | 1 | 57 | 27 | ||||
190527 | 106859 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 946 RHODE ISLAND ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | 14 | 3x3 | Permit Number 773008 | 6011839.2 | 2104029.4 | 37.7579308843014 | -122.402070102772 | (37.7579308843014, -122.402070102772) | 10 | 3 | 8 | 28856 | 29 | ||
151565 | 106947 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2710 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2014 12:00:00 AM | 1 | 3x3 | 5999608.44981 | 2118168.47191 | 37.7960629190222 | -122.445385661119 | (37.7960629190222, -122.445385661119) | 13 | 9 | 1 | 57 | 17 | ||
13768 | 106948 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2710 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2014 12:00:00 AM | 1 | 3x3 | 5999606.41459 | 2118186.75395 | 37.7961130004661 | -122.445394018543 | (37.7961130004661, -122.445394018543) | 13 | 9 | 1 | 57 | 17 | ||
31713 | 107635 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 1150 Lombard St | 10 | Front Yard : Yard | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773092 | 6006825.00646 | 2120436.80144 | 37.8027004912885 | -122.420576003873 | (37.8027004912885, -122.420576003873) | 5 | 1 | 1 | 28858 | 32 | ||
134151 | 108204 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 1192 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000914.97169 | 2109351.778 | 37.7719290371123 | -122.440232269589 | (37.7719290371123, -122.440232269589) | 15 | 5 | 11 | 29492 | 9 | |||||
140507 | 108205 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1192 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/2014 12:00:00 AM | 3 | Permit Number 774208 | 6000914.97169 | 2109351.778 | 37.7719290371123 | -122.440232269589 | (37.7719290371123, -122.440232269589) | 15 | 5 | 11 | 29492 | 9 | ||
105994 | 108206 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 1192 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000914.97169 | 2109351.778 | 37.7719290371123 | -122.440232269589 | (37.7719290371123, -122.440232269589) | 15 | 5 | 11 | 29492 | 9 | |||||
138322 | 108485 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 41 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009911.00607 | 2111023.57735 | 37.7770274800675 | -122.409232186416 | (37.7770274800675, -122.409232186416) | 8 | 2 | 9 | 28853 | 34 | |||
33146 | 108559 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 247 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773718 | 6001785.96966 | 2094072.85918 | 37.7300263216596 | -122.436125873507 | (37.7300263216596, -122.436125873507) | 9 | 7 | 6 | 28861 | 25 |
147374 | 108944 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 105 Richland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2015 12:00:00 AM | 3 | 4x4 | Permit Number 772521 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | 2 | 7 | 7 | 28859 | 2 | |
121516 | 109320 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 3110 23RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2015 12:00:00 AM | 7 | 3x3 | 6008224.7 | 2102742.2 | 37.7541941223175 | -122.414479525681 | (37.7541941223175, -122.414479525681) | 2 | 4 | 7 | 28859 | 19 | ||
117593 | 109381 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 11 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5990493.41695 | 2114971.95587 | 37.7867616423246 | -122.476691486324 | (37.7867616423246, -122.476691486324) | 11 | 6 | 1 | 55 | 33 | |||
84288 | 109597 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1050 South Van Ness Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007567.1 | 2103584.6 | 37.7564701953683 | -122.416813352731 | (37.7564701953683, -122.416813352731) | 2 | 4 | 7 | 28859 | 19 | |||||
154983 | 109598 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1050 South Van Ness Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007567.1 | 2103584.6 | 37.7564701953683 | -122.416813352731 | (37.7564701953683, -122.416813352731) | 2 | 4 | 7 | 28859 | 19 | |||||
68039 | 110146 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 64 WOODLAND AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x15 | 5997139.6 | 2106104.1 | 37.7627960760002 | -122.453057009148 | (37.7627960760002, -122.453057009148) | 15 | 5 | 11 | 29492 | 12 | |||
74019 | 110150 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 101 Woodland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 5997047.9 | 2105929.4 | 37.7623111384262 | -122.453361551942 | (37.7623111384262, -122.453361551942) | 15 | 5 | 11 | 29492 | 12 | ||||
183057 | 110151 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 87 WOODLAND AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5997070.7 | 2106047.1 | 37.7626356195752 | -122.453291193402 | (37.7626356195752, -122.453291193402) | 15 | 5 | 11 | 29492 | 12 | |||
58955 | 110152 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 87 WOODLAND AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5997070.7 | 2106047.1 | 37.7626356195752 | -122.453291193402 | (37.7626356195752, -122.453291193402) | 15 | 5 | 11 | 29492 | 12 | |||
70751 | 110203 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 82 POTOMAC ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003128.3 | 2108821.4 | 37.7705985140517 | -122.432538320625 | (37.7705985140517, -122.432538320625) | 15 | 5 | 5 | 29492 | 9 | ||||
65756 | 110275 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2612 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2016 12:00:00 AM | 3 | Permit Number 778382 | 6001183.56283 | 2117454.33561 | 37.794191876798 | -122.43988424377 | (37.794191876798, -122.43988424377) | 13 | 9 | 1 | 57 | 27 | ||
79117 | 111025 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 699x 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5984730.84558 | 2111224.06012 | 37.7761350733047 | -122.496351676847 | (37.7761350733047, -122.496351676847) | 11 | 6 | 2 | 55 | 26 | |||
75962 | 111070 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 1836 08TH AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 2 | 3x15 | 5993799 | 2102987 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | 1 | 8 | 4 | 56 | 12 | |||
118311 | 111111 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 274 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011331.28551 | 2111595.46543 | 37.7786772198139 | -122.404359235093 | (37.7786772198139, -122.404359235093) | 14 | 2 | 9 | 28856 | 34 | |||
32690 | 111292 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 291 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5991505.83233 | 2113494.12901 | 37.7827626107443 | -122.47308099011 | (37.7827626107443, -122.47308099011) | 11 | 6 | 2 | 54 | 26 | |||
68815 | 111368 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 24 MELROSE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5999942 | 2095537 | 37.7339415754871 | -122.442605768576 | (37.7339415754871, -122.442605768576) | 9 | 7 | 4 | 63 | 40 | |||
126965 | 111962 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 100x PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x9 | 6006854 | 2098911 | 37.7435974172286 | -122.418948043759 | (37.7435974172286, -122.418948043759) | 2 | 7 | 7 | 28859 | 2 | |||
179985 | 111963 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 100x PROSPECT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x9 | 6006854 | 2098911 | 37.7435974172286 | -122.418948043759 | (37.7435974172286, -122.418948043759) | 2 | 7 | 7 | 28859 | 2 | |||
47219 | 112099 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 200X RICHLAND AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006012 | 2096107 | 37.7358508133721 | -122.421660362723 | (37.7358508133721, -122.421660362723) | 2 | 7 | 7 | 28859 | 2 | |||
21409 | 112100 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 200X RICHLAND AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6006012 | 2096107 | 37.7358508133721 | -122.421660362723 | (37.7358508133721, -122.421660362723) | 2 | 7 | 7 | 28859 | 2 | |||
115249 | 112101 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 200X RICHLAND AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6006012 | 2096107 | 37.7358508133721 | -122.421660362723 | (37.7358508133721, -122.421660362723) | 2 | 7 | 7 | 28859 | 2 | |||
132480 | 112102 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 200X RICHLAND AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6006012 | 2096107 | 37.7358508133721 | -122.421660362723 | (37.7358508133721, -122.421660362723) | 2 | 7 | 7 | 28859 | 2 | |||
79198 | 112368 | Section 143 10 | Prunus cerasifera :: Cherry Plum 7 | 550 Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2015 12:00:00 AM | 3 | 3x3 | 6009683.8 | 2112475.6 | 37.7810016601266 | -122.410120702727 | (37.7810016601266, -122.410120702727) | 14 | 2 | 9 | 28853 | 34 | ||
169504 | 112369 | Section 143 10 | Prunus cerasifera :: Cherry Plum 7 | 550 Jessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2015 12:00:00 AM | 3 | 3x3 | 6009683.8 | 2112475.6 | 37.7810016601266 | -122.410120702727 | (37.7810016601266, -122.410120702727) | 14 | 2 | 9 | 28853 | 34 | ||
93555 | 112370 | Section 143 10 | Prunus cerasifera :: Cherry Plum 7 | 550 Jessie St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2015 12:00:00 AM | 3 | 3x3 | 6009683.8 | 2112475.6 | 37.7810016601266 | -122.410120702727 | (37.7810016601266, -122.410120702727) | 14 | 2 | 9 | 28853 | 34 | ||
98375 | 112371 | Section 143 10 | Prunus cerasifera :: Cherry Plum 7 | 550 Jessie St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2015 12:00:00 AM | 3 | 3x3 | 6009683.8 | 2112475.6 | 37.7810016601266 | -122.410120702727 | (37.7810016601266, -122.410120702727) | 14 | 2 | 9 | 28853 | 34 | ||
81844 | 112372 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 15 Vandewater St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009194.601 | 2121319.3086 | 37.8052568931935 | -122.412438393162 | (37.8052568931935, -122.412438393162) | 3 | 1 | 10 | 308 | 23 | |||
120842 | 112620 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 160 Newman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007378.4 | 2096719 | 37.7376081863162 | -122.416979515408 | (37.7376081863162, -122.416979515408) | 2 | 7 | 7 | 28859 | 2 | |||||
46421 | 112639 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2470 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001807.148 | 2117372.77339 | 37.7940034049855 | -122.437720730351 | (37.7940034049855, -122.437720730351) | 13 | 9 | 1 | 57 | 27 |
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) );