246 rows where qSpecies_id = 20 sorted by DBH

View and edit SQL

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
4560 47095 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 356 Willard North St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM     Permit Number 45077 5996301.73927169 2110554.62831554 37.7749680212207 -122.456276668944 (37.7749680212207, -122.456276668944) 11 6 2 54 16
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
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
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
22680 46900 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 1357 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/2002 12:00:00 AM     Permit Number 44956 5991106.29954004 2106174.99705817 37.7626431240146 -122.473929035532 (37.7626431240146, -122.473929035532) 1 8 11 56 12
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
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
30898 254205 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1766 44th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   5982566.32735 2103096.10961 37.7536910129268 -122.503237266994 (37.7536910129268, -122.503237266994) 1 8 3 56 35
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
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
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
40861 85261 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 2998 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2007 12:00:00 AM     Permit Number 49557 5989779.1 2095328.3 37.7327839760928 -122.477726384657 (37.7327839760928, -122.477726384657) 1 8 4 64 35
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
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
44112 40458 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 65 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/1999 12:00:00 AM     Permit Number 41543 6008355.36167983 2098222.23165667 37.7417906382072 -122.413707978506 (37.7417906382072, -122.413707978506) 2 7 7 28859 2
48134 88833 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 900 Powhattan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2008 12:00:00 AM   3x3 Permit Number 51715 6009115.5 2098028.9 37.7413024486906 -122.41106600773 (37.7413024486906, -122.41106600773) 10 7 7 28859 2
48201 42814 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 3944 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/2000 12:00:00 AM     Permit Number 42759 6003333.22216153 2105381.87042866 37.7611660186553 -122.431583898012 (37.7611660186553, -122.431583898012) 15 4 5 28862 3
48235 38441 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 2591 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/1998 12:00:00 AM     Permit Number 40466 5992043.6333811 2097820.82323466 37.7397589768558 -122.470078824326 (37.7397589768558, -122.470078824326) 1 8 4 59 40
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
52550 38836 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 254 Clement St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/1998 12:00:00 AM     Permit Number 40666 5994768.12752284 2113559.99820217 37.7831318083177 -122.461799686207 (37.7831318083177, -122.461799686207) 11 6 2 54 11
53896 42075 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 125 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/25/2005 12:00:00 AM     Permit Number 42387 6009870.15357172 2099865.41345763 37.7463874047531 -122.408586191488 (37.7463874047531, -122.408586191488) 2 7 7 28859 2
53984 45168 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 2695 Sacramento St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/23/2001 12:00:00 AM     Permit Number 44017 6001924.94764161 2115681.1327225 37.7893652944435 -122.437191954251 (37.7893652944435, -122.437191954251) 13 6 1 29490 27
54737 84949 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 1305 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/19/1983 12:00:00 AM   3x3 Permit Number 49351 6009354 2101579 37.7510636126747 -122.410491979069 (37.7510636126747, -122.410491979069) 2 4 7 28859 19
54872 50865 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 238 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/08/2004 12:00:00 AM     Permit Number 47380 6007739.99301992 2097997.57355167 37.741139201026 -122.415819822319 (37.741139201026, -122.415819822319) 2 7 7 28859 2
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
59467 41687 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 124 Saturn St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42140 5999927.88161805 2106008.33179804 37.7626925227356 -122.443406475957 (37.7626925227356, -122.443406475957) 15 5 5 28862 3
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
63595 37844 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 117 Brewster St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM     Permit Number 40136 6010376.80138594 2099288.55656196 37.7448318435542 -122.406793605579 (37.7448318435542, -122.406793605579) 2 7 7 28859 2
64634 45170 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 2695 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/23/2001 12:00:00 AM     Permit Number 44017 6001924.94764161 2115681.1327225 37.7893652944435 -122.437191954251 (37.7893652944435, -122.437191954251) 13 6 1 29490 27
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
83083 40054 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 1294 Shafter Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41290 6016570.04020415 2092976.75616645 37.7278454926494 -122.384938693931 (37.7278454926494, -122.384938693931) 10 3 8 58 1
86063 37843 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 117 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM     Permit Number 40136 6010376.80138594 2099288.55656196 37.7448318435542 -122.406793605579 (37.7448318435542, -122.406793605579) 2 7 7 28859 2
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
90447 88832 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 900 Powhattan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2008 12:00:00 AM   3x3 Permit Number 51715 6009115.5 2098028.9 37.7413024486906 -122.41106600773 (37.7413024486906, -122.41106600773) 10 7 7 28859 2
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
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
100896 45081 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 2143 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2001 12:00:00 AM     Permit Number 43964 5987260.68011287 2100690.67520581 37.7473611656774 -122.486826724588 (37.7473611656774, -122.486826724588) 1 8 3 29491 35
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
109085 45276 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 518 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2001 12:00:00 AM     Permit Number 44119 6007993.51053318 2096451.22471646 37.7369075159799 -122.414833833066 (37.7369075159799, -122.414833833066) 2 7 7 28859 2
109410 43909 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 1179 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/10/2000 12:00:00 AM     Permit Number 43508 6008693.56566701 2101689.35157322 37.7513295663287 -122.412783637177 (37.7513295663287, -122.412783637177) 2 4 7 28859 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
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
115382 41122 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 2344 Fulton St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1999 12:00:00 AM     Permit Number 41865 5996582.9529178 2110470.59190578 37.7747534181142 -122.455297821718 (37.7747534181142, -122.455297821718) 11 5 2 54 16
118148 36894 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 4107 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2008 12:00:00 AM   3x3 Permit Number 51263 6001777.66119006 2103491.87307187 37.7558882513279 -122.436828606579 (37.7558882513279, -122.436828606579) 2 4 5 28862 22
120165 48972 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 135 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/17/2004 12:00:00 AM     Permit Number 46159 6003310.63727526 2108787.86549198 37.7705167748166 -122.431905219461 (37.7705167748166, -122.431905219461) 15 9 5 29492 9
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
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
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
138010 95988 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 10 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2011 12:00:00 AM   3x3 Permit Number 767640 6007158.9 2099647 37.7456354723022 -122.417945934991 (37.7456354723022, -122.417945934991) 2 7 7 28859 2
140173 45167 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 2695 Sacramento St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/23/2001 12:00:00 AM     Permit Number 44017 6001924.94764161 2115681.1327225 37.7893652944435 -122.437191954251 (37.7893652944435, -122.437191954251) 13 6 1 29490 27
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
149416 38837 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 254 Clement St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/1998 12:00:00 AM     Permit Number 40666 5994768.12752284 2113559.99820217 37.7831318083177 -122.461799686207 (37.7831318083177, -122.461799686207) 11 6 2 54 11
151888 45169 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 2695 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/23/2001 12:00:00 AM     Permit Number 44017 6001924.94764161 2115681.1327225 37.7893652944435 -122.437191954251 (37.7893652944435, -122.437191954251) 13 6 1 29490 27
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
155231 41120 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 2344 Fulton St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1999 12:00:00 AM     Permit Number 41865 5996582.9529178 2110470.59190578 37.7747534181142 -122.455297821718 (37.7747534181142, -122.455297821718) 11 5 2 54 16
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
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
159246 46338 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 3703 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2002 12:00:00 AM     Permit Number 44587 6005824.5079347 2100789.51596522 37.7486973702763 -122.422641242993 (37.7486973702763, -122.422641242993) 2 4 5 28859 19
160681 38834 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 254 Clement St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/1998 12:00:00 AM     Permit Number 40666 5994768.12752284 2113559.99820217 37.7831318083177 -122.461799686207 (37.7831318083177, -122.461799686207) 11 6 2 54 11
161225 41119 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 2344 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1999 12:00:00 AM     Permit Number 41865 5996582.9529178 2110470.59190578 37.7747534181142 -122.455297821718 (37.7747534181142, -122.455297821718) 11 5 2 54 16
166087 48710 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 1 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45977 6002865.90865477 2096146.69511849 37.735781899273 -122.432540466241 (37.735781899273, -122.432540466241) 2 7 5 63 7
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
179310 42243 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 547 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42492 6010057.93942853 2111817.75656126 37.7792163405696 -122.408779938797 (37.7792163405696, -122.408779938797) 14 2 9 28853 34
187310 37270 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 3722 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39810 6003578.77249291 2103641.69607352 37.7564018297216 -122.43061046837 (37.7564018297216, -122.43061046837) 2 4 5 28862 3
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
188919 88831 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 900 Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2008 12:00:00 AM   3x3 Permit Number 51715 6009115.5 2098028.9 37.7413024486906 -122.41106600773 (37.7413024486906, -122.41106600773) 10 7 7 28859 2
189499 42244 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 547 Natoma St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42492 6010057.93942853 2111817.75656126 37.7792163405696 -122.408779938797 (37.7792163405696, -122.408779938797) 14 2 9 28853 34
190510 41121 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 2344 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1999 12:00:00 AM     Permit Number 41865 5996582.9529178 2110470.59190578 37.7747534181142 -122.455297821718 (37.7747534181142, -122.455297821718) 11 5 2 54 16
193435 45082 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 2143 29th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2001 12:00:00 AM     Permit Number 43964 5987260.68011287 2100690.67520581 37.7473611656774 -122.486826724588 (37.7473611656774, -122.486826724588) 1 8 3 29491 35
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
80382 37200 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1523 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM 0   Permit Number 39767 5986185.22517174 2104866.53832379 37.7587641880882 -122.490852744095 (37.7587641880882, -122.490852744095) 1 8 3 56 35
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
30930 192814 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1251 Mariposa St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6013571.38168 2106139.70119 37.7638218378314 -122.396227345714 (37.7638218378314, -122.396227345714) 14 3 8 28856 29
38714 229260 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1325 Florida St 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6009552.03774 2101426.1917 37.7506551353331 -122.409796356326 (37.7506551353331, -122.409796356326) 2 4 7 28859 19
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
45226 229225 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 4015 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6003754.02498 2100677.61604 37.7482730893484 -122.42979297446 (37.7482730893484, -122.42979297446) 2 4 5 63 22
53505 229257 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 210 Moffitt St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6002381.14665 2097165.58245 37.7385520268501 -122.434289296035 (37.7385520268501, -122.434289296035) 2 7 5 63 7
60221 50521 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 145 Beaumont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/2003 12:00:00 AM 1   Permit Number 47159 5996798.3759 2112040.3174 37.7790758310411 -122.454666063431 (37.7790758310411, -122.454666063431) 15 6 2 54 16
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
77081 44219 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 2139 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1   Permit Number 43665 5987260.984 2100720.2895 37.7474424963194 -122.486827848138 (37.7474424963194, -122.486827848138) 1 8 3 29491 35
77741 229223 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 587 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/1988 12:00:00 AM 1 Width 2ft Permit Number 25015 6002801.67142 2098869.60801 37.7432547464139 -122.432957032239 (37.7432547464139, -122.432957032239) 2 7 5 63 22
79567 137580 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1150 PIERCE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6002381.2868 2112341.0686 37.7802202566686 -122.435374054285 (37.7802202566686, -122.435374054285) 15 5 11 29490 41
80365 229259 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 269 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6003857.56826 2097789.37323 37.7403485044927 -122.429229006915 (37.7403485044927, -122.429229006915) 2 7 5 63 7
81612 117729 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 444 40th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 4ft   5983475.64973 2112834.36493 37.7804828918797 -122.500812777933 (37.7804828918797, -122.500812777933) 11 6 2 55 26
123138 229256 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 260 Randall St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6003866.23298 2097822.81814 37.7404408270718 -122.429201431925 (37.7404408270718, -122.429201431925) 2 7 5 63 7
138978 229236 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 34 Natick St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6003050.62642 2095609.57771 37.7343175708005 -122.431863485408 (37.7343175708005, -122.431863485408) 2 7 5 63 7
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
157092 97121 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 1151 Taraval St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2011 12:00:00 AM 1 3x3 Permit Number 768432 5989613.2 2098967.9 37.7427677493048 -122.478566001777 (37.7427677493048, -122.478566001777) 1 8 3 29491 35
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
165989 229228 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 588 Ogden Ave 3 Sidewalk: Curb side : Pot Tree Private 2     1 Width 4ft   6007775.88717 2096147.34568 37.7360609002791 -122.415564747312 (37.7360609002791, -122.415564747312) 2 7 7 28859 2
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
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
184259 97120 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 1151 Taraval St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2011 12:00:00 AM 1 3x3 Permit Number 768432 5989613.2 2098967.9 37.7427677493048 -122.478566001777 (37.7427677493048, -122.478566001777) 1 8 3 29491 35
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);