trees
246 rows where qSpecies_id = 20 sorted by Fire Prevention Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3119 | 264752 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 176 Hahn St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
7535 | 264754 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 176 Hahn St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
12128 | 81186 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 559 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6001911.78003 | 2090228.45376 | 37.7194775995917 | -122.435416033226 | (37.7194775995917, -122.435416033226) | 9 | 7 | 6 | 28861 | 5 | |||
15774 | 208544 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 171 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5999615.39289 | 2094047.29924 | 37.7298325824993 | -122.443627964962 | (37.7298325824993, -122.443627964962) | 9 | 7 | 4 | 63 | 40 | |||
18449 | 264755 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 176 Hahn St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
19323 | 81173 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 559 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001918.1505 | 2090237.98214 | 37.7195041241905 | -122.435394694117 | (37.7195041241905, -122.435394694117) | 9 | 7 | 6 | 28861 | 5 | |||
19604 | 78246 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1447 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5999064.52078 | 2089547.19331 | 37.7174448988403 | -122.445208973141 | (37.7174448988403, -122.445208973141) | 9 | 7 | 6 | 28861 | 25 | |||
26180 | 115023 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 618 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 12:00:00 AM | 6 | Permit Number 775874 | 6003941.00941 | 2091735.88537 | 37.7237317121275 | -122.428509122993 | (37.7237317121275, -122.428509122993) | 9 | 7 | 6 | 28861 | 5 | ||
28278 | 49981 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001 | (37.7234037567812, -122.43984643001) | 9 | 7 | 6 | 28861 | 25 | ||
28410 | 177294 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 570 Edinburgh St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6002574.43441 | 2090375.15322 | 37.7199180155891 | -122.433135958685 | (37.7199180155891, -122.433135958685) | 9 | 7 | 6 | 28861 | 5 | |||
28736 | 36479 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 541 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39372 | 5996872.5215496 | 2093815.84341283 | 37.7290402419627 | -122.45309363195 | (37.7290402419627, -122.45309363195) | 9 | 7 | 4 | 28861 | 40 | ||
31077 | 177293 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 570 Edinburgh St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6002594.98621 | 2090406.02371 | 37.7200039448969 | -122.433067122761 | (37.7200039448969, -122.433067122761) | 9 | 7 | 6 | 28861 | 5 | |||
33104 | 49982 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001 | (37.7234037567812, -122.43984643001) | 9 | 7 | 6 | 28861 | 25 | ||
37036 | 177300 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1222 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001639.62994 | 2087602.93432 | 37.7122530470215 | -122.436168967218 | (37.7122530470215, -122.436168967218) | 9 | 7 | 6 | 28861 | 5 | |||
49181 | 36477 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 531 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39371 | 5996915.79992705 | 2093810.02039561 | 37.7290267336025 | -122.452943595903 | (37.7290267336025, -122.452943595903) | 9 | 7 | 4 | 28861 | 40 | ||
50140 | 177288 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 170 Lawrence Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5996808.94464 | 2087276.43363 | 37.7110809120333 | -122.452841609247 | (37.7110809120333, -122.452841609247) | 9 | 7 | 6 | 28861 | 25 | |||
58877 | 208545 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 12 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5996523.6042 | 2089967.17912 | 37.7184527177873 | -122.454022014425 | (37.7184527177873, -122.454022014425) | 9 | 8 | 6 | 28861 | 24 | |||
62848 | 177296 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 115 Newton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000995.34675 | 2087902.8646 | 37.7130399628101 | -122.438417271438 | (37.7130399628101, -122.438417271438) | 9 | 7 | 6 | 28861 | 5 | |||
63410 | 208550 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 498 Vernon St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5992503.57103 | 2091183.80618 | 37.7215619556104 | -122.468005927235 | (37.7215619556104, -122.468005927235) | 9 | 8 | 6 | 64 | 24 | |||
70318 | 60303 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 678 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1982 12:00:00 AM | 6 | Permit Number 19870 | 6009154.33491 | 2088966.77185 | 37.7164219496995 | -122.410292044649 | (37.7164219496995, -122.410292044649) | 9 | 7 | 8 | 309 | 39 | ||
70784 | 52521 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 225 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 6 | Permit Number 48914 | 6000062.86091 | 2091491.3711 | 37.7228401035632 | -122.441897645058 | (37.7228401035632, -122.441897645058) | 9 | 7 | 6 | 28861 | 25 | |
73392 | 177301 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1222 Athens St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001599.00625 | 2087595.59489 | 37.7122305864419 | -122.436308849585 | (37.7122305864419, -122.436308849585) | 9 | 7 | 6 | 28861 | 5 | |||
76828 | 177295 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 115 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001002.00553 | 2087880.82642 | 37.7129798296258 | -122.438392678593 | (37.7129798296258, -122.438392678593) | 9 | 7 | 6 | 28861 | 5 | |||
86510 | 115434 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 563 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777504 | 6001902.43576 | 2090213.7176 | 37.7194366066954 | -122.435447279293 | (37.7194366066954, -122.435447279293) | 9 | 7 | 6 | 28861 | 5 | ||
89049 | 177289 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1200 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 5999793.10154 | 2090324.86823 | 37.719621778009 | -122.442746423415 | (37.719621778009, -122.442746423415) | 9 | 7 | 6 | 28861 | 25 | |||
89773 | 208553 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 595 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5993236.49495 | 2091160.42378 | 37.7215400517233 | -122.465470730297 | (37.7215400517233, -122.465470730297) | 9 | 8 | 6 | 64 | 24 | |||
90883 | 36476 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 524 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1999 12:00:00 AM | Permit Number 41513 | 5996948.70097149 | 2093858.06219815 | 37.729160530354 | -122.452833321223 | (37.729160530354, -122.452833321223) | 9 | 7 | 4 | 28861 | 40 | ||
97114 | 208543 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 100 Vista Verde Ct | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999208.78816 | 2096056.42924 | 37.7353259823914 | -122.445178028358 | (37.7353259823914, -122.445178028358) | 9 | 7 | 4 | 63 | 40 | |||
103730 | 30933 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 515 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 2 | Permit Number 34746 | 5995238.05278 | 2091207.05999 | 37.7217833398997 | -122.458555307998 | (37.7217833398997, -122.458555307998) | 9 | 8 | 6 | 28861 | 24 | |
113052 | 49980 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001 | (37.7234037567812, -122.43984643001) | 9 | 7 | 6 | 28861 | 25 | ||
117553 | 114096 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 424 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2015 12:00:00 AM | 3 | 3x3 | 5998431.96208 | 2087528.92056 | 37.7118670561881 | -122.447250250697 | (37.7118670561881, -122.447250250697) | 9 | 7 | 6 | 28861 | 25 | ||
118863 | 208547 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 249 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996507.17422 | 2091557.14862 | 37.7228174577402 | -122.454193583485 | (37.7228174577402, -122.454193583485) | 9 | 8 | 4 | 28861 | 24 | |||
121806 | 208551 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 439 Vernon St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5992460.92355 | 2090770.88393 | 37.7204257089658 | -122.46812332475 | (37.7204257089658, -122.46812332475) | 9 | 8 | 6 | 64 | 24 | |||
122883 | 36480 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 541 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39372 | 5996872.5215496 | 2093815.84341283 | 37.7290402419627 | -122.45309363195 | (37.7290402419627, -122.45309363195) | 9 | 7 | 4 | 28861 | 40 | ||
124056 | 52522 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 225 Onondaga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2005 12:00:00 AM | 4 | Permit Number 48622 | 6000078.51361 | 2091484.10329 | 37.7228210397476 | -122.441843015763 | (37.7228210397476, -122.441843015763) | 9 | 7 | 6 | 28861 | 25 | ||
127211 | 36478 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 531 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39371 | 5996915.79992705 | 2093810.02039561 | 37.7290267336025 | -122.452943595903 | (37.7290267336025, -122.452943595903) | 9 | 7 | 4 | 28861 | 40 | ||
133372 | 208549 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 498 Vernon St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5992504.0941 | 2091172.39511 | 37.7215306538065 | -122.468003289534 | (37.7215306538065, -122.468003289534) | 9 | 8 | 6 | 64 | 24 | |||
136520 | 208542 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1201 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995837.91455 | 2092068.13773 | 37.7241821115032 | -122.456543992205 | (37.7241821115032, -122.456543992205) | 9 | 7 | 4 | 28861 | 40 | |||
136599 | 208554 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 447 Head St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 5993467.66599 | 2088853.99323 | 37.7152204788151 | -122.464504257677 | (37.7152204788151, -122.464504257677) | 9 | 8 | 6 | 64 | 24 | |||
138076 | 177292 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 400 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6003897.68799 | 2090933.24803 | 37.7215253954716 | -122.428601691123 | (37.7215253954716, -122.428601691123) | 9 | 7 | 6 | 28861 | 5 | |||
143244 | 52513 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 60 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48618 | 5997208.37126376 | 2086857.00593017 | 37.7099521405309 | -122.451430868837 | (37.7099521405309, -122.451430868837) | 9 | 7 | 6 | 28861 | 25 | ||
146900 | 177291 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 400 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003906.05607 | 2090945.99002 | 37.7215608557421 | -122.428573672752 | (37.7215608557421, -122.428573672752) | 9 | 7 | 6 | 28861 | 5 | |||
158347 | 49979 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001 | (37.7234037567812, -122.43984643001) | 9 | 7 | 6 | 28861 | 25 | ||
159248 | 177299 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1222 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001664.56674 | 2087607.40628 | 37.7122667427937 | -122.43608309818 | (37.7122667427937, -122.43608309818) | 9 | 7 | 6 | 28861 | 5 | |||
161934 | 114095 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 424 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2015 12:00:00 AM | 3 | 3x3 | 5998448.01058 | 2087544.4934 | 37.7119107326703 | -122.44719590289 | (37.7119107326703, -122.44719590289) | 9 | 7 | 6 | 28861 | 25 | ||
164273 | 208552 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Vernon St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 5992432.90306 | 2088632.12991 | 37.7145515909498 | -122.468064688039 | (37.7145515909498, -122.468064688039) | 9 | 8 | 6 | 64 | 24 | |||
164546 | 208548 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 150 Thrift St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 5995469.48283 | 2089658.18964 | 37.7175438071807 | -122.457643306389 | (37.7175438071807, -122.457643306389) | 9 | 8 | 6 | 28861 | 24 | |||
171110 | 177290 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 231 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004061.30791 | 2089085.46996 | 37.7164610594049 | -122.427904501587 | (37.7164610594049, -122.427904501587) | 9 | 7 | 6 | 28861 | 5 | |||
171270 | 208540 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1205 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995843.60881 | 2092100.29717 | 37.7242707405805 | -122.456526632611 | (37.7242707405805, -122.456526632611) | 9 | 7 | 4 | 28861 | 40 | |||
180489 | 208541 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1201 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995841.38448 | 2092081.24928 | 37.7242183119117 | -122.456532944957 | (37.7242183119117, -122.456532944957) | 9 | 7 | 4 | 28861 | 40 | |||
184176 | 208546 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 12 Lee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5996523.78627 | 2089975.89779 | 37.7184766676518 | -122.454022014422 | (37.7184766676518, -122.454022014422) | 9 | 8 | 6 | 28861 | 24 | |||
645 | 38285 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 27 Adair St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1998 12:00:00 AM | 12 | 3x12 | Permit Number 40369 | 6007338.83954453 | 2106937.08827094 | 37.7656625095236 | -122.417840391728 | (37.7656625095236, -122.417840391728) | 8 | 4 | 7 | 28853 | 19 |
20559 | 38286 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 29 Adair St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40899 | 6007332.77993019 | 2106936.7520651 | 37.7656612453629 | -122.417861326827 | (37.7656612453629, -122.417861326827) | 8 | 4 | 7 | 28853 | 19 | |||
22549 | 229216 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 33 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005800.05935 | 2107051.19883 | 37.7658891121107 | -122.423170814787 | (37.7658891121107, -122.423170814787) | 8 | 4 | 5 | 28853 | 19 | |||
23151 | 229229 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 25 Adair St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007282.8727 | 2106946.56107 | 37.7656853698119 | -122.41803464088 | (37.7656853698119, -122.41803464088) | 8 | 4 | 7 | 28853 | 19 | |||
30847 | 229218 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 154 Julian Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006411.90444 | 2106966.83782 | 37.7656919861306 | -122.42104857575 | (37.7656919861306, -122.42104857575) | 8 | 4 | 7 | 28853 | 19 | |||
42332 | 38291 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 65 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40373 | 6007133.38425029 | 2106994.31986795 | 37.7658080895378 | -122.418555077027 | (37.7658080895378, -122.418555077027) | 8 | 4 | 7 | 28853 | 19 | ||
48773 | 229219 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1342 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 15 | Width 2ft | Permit Number 42176 | 6006959.38912 | 2107664.54838 | 37.7676385821924 | -122.419204437651 | (37.7676385821924, -122.419204437651) | 8 | 4 | 7 | 28853 | 19 | |
55419 | 41289 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 27 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 41965 | 6005808.60053678 | 2107097.83336605 | 37.76601764148 | -122.42314458768 | (37.76601764148, -122.42314458768) | 8 | 4 | 5 | 28853 | 19 | ||
61067 | 41292 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 46 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2000 12:00:00 AM | Permit Number 41968 | 6005763.36283856 | 2106987.3220579 | 37.7657116506856 | -122.423293199372 | (37.7657116506856, -122.423293199372) | 8 | 4 | 5 | 28853 | 19 | |||
76605 | 38290 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 65 Capp St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40373 | 6007133.38425029 | 2106994.31986795 | 37.7658080895378 | -122.418555077027 | (37.7658080895378, -122.418555077027) | 8 | 4 | 7 | 28853 | 19 | ||
77498 | 38289 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 40 Adair St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40372 | 6007297.20256077 | 2106986.85810046 | 37.7657968225323 | -122.417987933805 | (37.7657968225323, -122.417987933805) | 8 | 4 | 7 | 28853 | 19 | ||
80931 | 41295 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 154 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 41972 | 6006408.35563549 | 2106971.5871641 | 37.7657048266582 | -122.421061187567 | (37.7657048266582, -122.421061187567) | 8 | 4 | 7 | 28853 | 19 | ||
82639 | 38294 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 65 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40373 | 6007133.38425029 | 2106994.31986795 | 37.7658080895378 | -122.418555077027 | (37.7658080895378, -122.418555077027) | 8 | 4 | 7 | 28853 | 19 | ||
89938 | 41290 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 33 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 41966 | 6005810.71369941 | 2107063.80355088 | 37.7659243229367 | -122.423134859591 | (37.7659243229367, -122.423134859591) | 8 | 4 | 5 | 28853 | 19 | ||
98054 | 38287 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 32 Adair St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40900 | 6007321.94599403 | 2106988.23094143 | 37.765801984592 | -122.417902448639 | (37.765801984592, -122.417902448639) | 8 | 4 | 7 | 28853 | 19 | ||
103553 | 41737 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1342-1344 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42176 | 6006947.20300055 | 2107647.30575448 | 37.767590551717 | -122.419245364711 | (37.767590551717, -122.419245364711) | 8 | 4 | 7 | 28853 | 19 | ||
108550 | 38292 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 65 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40373 | 6007133.38425029 | 2106994.31986795 | 37.7658080895378 | -122.418555077027 | (37.7658080895378, -122.418555077027) | 8 | 4 | 7 | 28853 | 19 | ||
112424 | 38293 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 65 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40373 | 6007133.38425029 | 2106994.31986795 | 37.7658080895378 | -122.418555077027 | (37.7658080895378, -122.418555077027) | 8 | 4 | 7 | 28853 | 19 | ||
118680 | 9993 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 65 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2001 12:00:00 AM | 6 | 2X2 | 6005451.908597 | 2108608.747745 | 37.770146115502 | -122.424485796032 | (37.770146115502, -122.424485796032) | 8 | 2 | 5 | 28853 | 19 | ||
133104 | 38288 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 40 Adair St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40372 | 6007297.20256077 | 2106986.85810046 | 37.7657968225323 | -122.417987933805 | (37.7657968225323, -122.417987933805) | 8 | 4 | 7 | 28853 | 19 | ||
155315 | 46558 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 3632 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2003 12:00:00 AM | Permit Number 44695 | 6005360.40468284 | 2105494.4369831 | 37.7615897924042 | -122.424580741803 | (37.7615897924042, -122.424580741803) | 8 | 4 | 5 | 28859 | 19 | ||
190649 | 229222 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 67 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005445.58133 | 2108574.74537 | 37.7700523958333 | -122.424505263025 | (37.7700523958333, -122.424505263025) | 8 | 2 | 5 | 28853 | 19 | |||
38852 | 85278 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 506 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49567 | 6004562 | 2110191 | 37.7744403005412 | -122.427676731417 | (37.7744403005412, -122.427676731417) | 7 | 9 | 11 | 28852 | 10 | |||
41793 | 253689 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 60 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005848 | 2109690 | 37.7731373345919 | -122.423192587546 | (37.7731373345919, -122.423192587546) | 7 | 9 | 11 | 28852 | 10 | ||||
130401 | 10238 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 48 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/29/2017 12:00:00 AM | 3 | 3X3 | 6005948.4469202 | 2109689.9882841 | 37.7731429705185 | -122.422845127343 | (37.7731429705185, -122.422845127343) | 7 | 9 | 11 | 28852 | 10 | ||
137574 | 16869 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 251 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52092 | 6005763.06398 | 2110312.25693 | 37.774841108223 | -122.423530640295 | (37.774841108223, -122.423530640295) | 7 | 9 | 11 | 28852 | 10 | |
139619 | 16927 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 516 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/1999 12:00:00 AM | 3 | 3X3 | 6004360.99062 | 2110167.09094 | 37.7743632798821 | -122.428370356734 | (37.7743632798821, -122.428370356734) | 7 | 9 | 11 | 28852 | 10 | ||
155003 | 253692 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 68 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005803 | 2109684 | 37.7731183204112 | -122.423347821955 | (37.7731183204112, -122.423347821955) | 7 | 9 | 11 | 28852 | 10 | ||||
176947 | 130433 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 550 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004538.94577 | 2111043.55474 | 37.776779903004 | -122.427817240371 | (37.776779903004, -122.427817240371) | 7 | 9 | 11 | 28852 | 10 | |||
188519 | 253691 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 60 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005848 | 2109690 | 37.7731373345919 | -122.423192587546 | (37.7731373345919, -122.423192587546) | 7 | 9 | 11 | 28852 | 10 | ||||
193889 | 253690 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 60 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005848 | 2109690 | 37.7731373345919 | -122.423192587546 | (37.7731373345919, -122.423192587546) | 7 | 9 | 11 | 28852 | 10 | ||||
11239 | 260905 | Private 9 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2211 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 2X3 | 6007589.07412 | 2119959.01259 | 37.8014316343257 | -122.417898047397 | (37.8014316343257, -122.417898047397) | 5 | 1 | 1 | 28858 | 32 | ||
12190 | 260906 | Private 9 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2215 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 2X3 | 6007586.25473 | 2119982.21322 | 37.8014951787433 | -122.417909449339 | (37.8014951787433, -122.417909449339) | 5 | 1 | 1 | 28858 | 32 | ||
13810 | 115990 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2211 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 2x4 | Permit Number 777665 | 6007568.4 | 2119969.3 | 37.8014587174384 | -122.417970318963 | (37.8014587174384, -122.417970318963) | 5 | 1 | 1 | 28858 | 32 | |
42561 | 130436 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2201 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007584.36539 | 2119972.20513 | 37.8014675927187 | -122.417915277469 | (37.8014675927187, -122.417915277469) | 5 | 1 | 1 | 28858 | 32 | |||
103779 | 115991 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2211 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 2x4 | Permit Number 777665 | 6007568.4 | 2119969.3 | 37.8014587174384 | -122.417970318963 | (37.8014587174384, -122.417970318963) | 5 | 1 | 1 | 28858 | 32 | |
141863 | 130437 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2201 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007591.42221 | 2119948.52727 | 37.8014029764228 | -122.417889178244 | (37.8014029764228, -122.417889178244) | 5 | 1 | 1 | 28858 | 32 | |||
169767 | 48596 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2828 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | Permit Number 45906 | 6006109.55880525 | 2120479.22122038 | 37.8027766188477 | -122.423054835322 | (37.8027766188477, -122.423054835322) | 5 | 9 | 1 | 28858 | 32 | ||
130355 | 12993 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 330 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | 3 | 3X3 | 6010724.12169 | 2120710.34518 | 37.8036705448693 | -122.407102317839 | (37.8036705448693, -122.407102317839) | 3 | 1 | 10 | 308 | 23 | ||
175958 | 13062 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 590 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2000 12:00:00 AM | 6 | 2X2 | 6009500.6409 | 2120545.5727 | 37.8031495768645 | -122.411324605789 | (37.8031495768645, -122.411324605789) | 3 | 1 | 10 | 308 | 23 | ||
5938 | 229255 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 260 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003887.38012 | 2097809.34417 | 37.7404050277631 | -122.429127352938 | (37.7404050277631, -122.429127352938) | 2 | 7 | 5 | 63 | 7 | |||
7571 | 237826 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 210 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2020 12:00:00 AM | 3 | Width 2ft | Permit Number 785232 | 6002395.63458 | 2097149.51403 | 37.7385087290057 | -122.434238055364 | (37.7385087290057, -122.434238055364) | 2 | 7 | 5 | 63 | 7 | |
19877 | 246803 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Brewster St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6010372.78366 | 2099322.13571 | 37.7449238197814 | -122.406809864293 | (37.7449238197814, -122.406809864293) | 2 | 7 | 7 | 28859 | 2 | |||
22730 | 4491 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1608 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/1998 12:00:00 AM | 3 | 3X3 | 6004562.86857 | 2099453.04475 | 37.7449564687567 | -122.426908813616 | (37.7449564687567, -122.426908813616) | 2 | 7 | 5 | 63 | 22 | ||
24435 | 46337 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 3703 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51341 | 6005824.5079347 | 2100789.51596522 | 37.7486973702763 | -122.422641242993 | (37.7486973702763, -122.422641242993) | 2 | 4 | 5 | 28859 | 19 | |
30277 | 25186 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 3644 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 3 | 3X3 | 6000415.91154 | 2103347.84626 | 37.7554153008829 | -122.441527633417 | (37.7554153008829, -122.441527633417) | 2 | 4 | 5 | 63 | 38 | ||
30911 | 39141 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1088 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40819 | 6007414.12012463 | 2100977.25645313 | 37.7493024177021 | -122.417157664156 | (37.7493024177021, -122.417157664156) | 2 | 4 | 7 | 28859 | 19 | ||
32343 | 229262 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 108 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004703.69496 | 2102959.30971 | 37.7545918213685 | -122.426671498699 | (37.7545918213685, -122.426671498699) | 2 | 4 | 5 | 28862 | 22 | |||
32674 | 27639 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2787 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2000 12:00:00 AM | 6 | 3X3 | 6009853.94655 | 2101110.41145 | 37.7498049873079 | -122.408730050863 | (37.7498049873079, -122.408730050863) | 2 | 4 | 7 | 28859 | 19 |
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) );