246 rows where qSpecies_id = 20 sorted by Supervisor Districts

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)
5802 62147 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 2057 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/06/1985 12:00:00 AM 3   Permit Number 22261 5999361.52655 2121151.92571 37.8042405839018 -122.446454803956 (37.8042405839018, -122.446454803956) 13 9 1 57 17
8722 130434 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 2701 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001177.09215 2116887.43491 37.7926349471062 -122.439865967752 (37.7926349471062, -122.439865967752) 13 6 1 29490 27
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
20359 111160 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 99X Magnolia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6003321.77346 2119803.50555 37.8007635719416 -122.432653690929 (37.8007635719416, -122.432653690929) 13 9 1 57 17
35594 111164 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 99X Magnolia St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6003392.25539 2119813.00098 37.8007936407819 -122.432410472862 (37.8007936407819, -122.432410472862) 13 9 1 57 17
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
49315 141042 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 175 COMMONWEALTH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5996531.5303 2113164.047 37.7821459864366 -122.45567043332 (37.7821459864366, -122.45567043332) 11 6 1 54 31
52323 130435 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 2127 Broadway 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6003305.56754 2117513.80582 37.7944757298119 -122.432546129322 (37.7944757298119, -122.432546129322) 13 9 1 29490 27
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
58828 110905 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 2891 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2015 12:00:00 AM 3 3x10 Permit Number 775210 5999766.16076 2117386.55705 37.7939249895015 -122.444783719687 (37.7939249895015, -122.444783719687) 13 9 1 57 27
64224 130432 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 2824 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5999398.65268 2118424.75751 37.7967546325742 -122.446130041675 (37.7967546325742, -122.446130041675) 13 9 1 57 17
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
70046 40802 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 121 Commonwealth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/1999 12:00:00 AM 4   Permit Number 41751 5996513.2556 2113630.7306 37.7834263270019 -122.455767400466 (37.7834263270019, -122.455767400466) 11 6 1 54 31
85882 18881 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 2323 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/26/2009 12:00:00 AM 3 2X2   6003542.78856 2115901.08421 37.7900610577291 -122.431610123004 (37.7900610577291, -122.431610123004) 13 9 1 29490 27
102327 36962 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 146 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM 7   Permit Number 39591 5994303.22649 2114557.05479 37.785842681857 -122.463480424277 (37.785842681857, -122.463480424277) 11 6 1 54 11
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
107681 111163 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 99X Magnolia St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6003374.28365 2119810.99129 37.8007871036097 -122.432472518919 (37.8007871036097, -122.432472518919) 13 9 1 57 17
109450 68582 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 175 Commonwealth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/18/1993 12:00:00 AM 4   Permit Number 32479 5996530.1767 2113176.907 37.7821812189094 -122.455676045985 (37.7821812189094, -122.455676045985) 11 6 1 54 31
117311 111161 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 99X Magnolia St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6003338.31122 2119805.54449 37.8007701082019 -122.432596609162 (37.8007701082019, -122.432596609162) 13 9 1 57 17
126173 111165 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 99X Magnolia St 6 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6003411.20248 2119815.94235 37.8008027913768 -122.432345118256 (37.8008027913768, -122.432345118256) 13 9 1 57 17
137511 111162 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 99X Magnolia St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6003355.09781 2119808.05454 37.8007779520905 -122.4325387 (37.8007779520905, -122.4325387) 13 9 1 57 17
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
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
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
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
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
25342 7018 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1055 Fell St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/22/2008 12:00:00 AM 2 3X3   6002378.8301 2110180.8206 37.7742886166676 -122.435227992558 (37.7742886166676, -122.435227992558) 15 5 11 29492 10
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
68787 70836 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 239 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1994 12:00:00 AM 3     5997827.1396 2109714.2746 37.7727480736245 -122.450939398271 (37.7727480736245, -122.450939398271) 15 5 11 29492 16
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
104254 7016 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1055 Fell St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6002352.4572 2110178.4231 37.7742805360567 -122.43531904959 (37.7742805360567, -122.43531904959) 15 5 11 29492 10
108785 141622 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1801 GROVE ST 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5998881.826 2110394.3314 37.7746756578154 -122.447340091401 (37.7746756578154, -122.447340091401) 15 5 11 29492 16
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
136825 141620 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1801 GROVE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5998848.2105 2110389.4859 37.7746604323894 -122.447456024852 (37.7746604323894, -122.447456024852) 15 5 11 29492 16
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
160538 17695 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 1100X Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2004 12:00:00 AM 3 3X3   6002388.932052 2112303.174651 37.7801166436013 -122.435344894499 (37.7801166436013, -122.435344894499) 15 5 11 29490 41
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
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
25917 123969 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 115 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5993630.62281 2114735.81846 37.7862947425232 -122.46582041968 (37.7862947425232, -122.46582041968) 11 6 2 54 11
30320 110153 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 267 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2015 12:00:00 AM 3 3x3 Permit Number 775195 5988018.8 2114202.3 37.7845045397665 -122.485196475776 (37.7845045397665, -122.485196475776) 11 6 2 55 26
49263 123604 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 288 04th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994649.79815 2113605.55206 37.7832500744158 -122.462212359722 (37.7832500744158, -122.462212359722) 11 6 2 54 11
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
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
76771 2767 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 238 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/23/2016 12:00:00 AM 3 3X3   5994814.49115 2110801.12928 37.775559360496 -122.461439216572 (37.775559360496, -122.461439216572) 11 6 2 54 11
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
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
121565 123605 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 288 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5994650.61525 2113597.37697 37.78322767487 -122.462208939817 (37.78322767487, -122.462208939817) 11 6 2 54 11
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
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
157847 124522 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 51 Parsons St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5996562.78722 2110517.36103 37.7748806768667 -122.455370959381 (37.7748806768667, -122.455370959381) 11 6 2 54 16
159123 1680 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 400 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/02/1998 12:00:00 AM 12 3X3   5994348.50119 2111464.79497 37.7773547778944 -122.463099340943 (37.7773547778944, -122.463099340943) 11 6 2 54 11
159254 38335 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 444 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2017 12:00:00 AM 3   Permit Number 47950 5983475.92441 2112817.71297 37.7804371865901 -122.500810595919 (37.7804371865901, -122.500810595919) 11 6 2 55 26
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
177265 21847 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 202X Cabrillo St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2000 12:00:00 AM 3 3X3   5994968.90714 2110807.33222 37.7755852784786 -122.460905507707 (37.7755852784786, -122.460905507707) 11 6 2 54 11
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
190537 123699 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 302 Balboa St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5994616.48583 2111473.74211 37.777394777876 -122.462172950615 (37.777394777876, -122.462172950615) 11 6 2 54 11
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
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
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
92543 183390 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 2673 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5989554.4883 2097163.7436 37.7378105948151 -122.478637096313 (37.7378105948151, -122.478637096313) 1 8 3 29491 35
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
115190 97119 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 1151 Taraval St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2011 12:00:00 AM 2 3x3 Permit Number 768432 5989613.2 2098967.9 37.7427677493048 -122.478566001777 (37.7427677493048, -122.478566001777) 1 8 3 29491 35
124243 37205 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1579 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM 4   Permit Number 39772 5986201.0748 2104494.9459 37.7577448234718 -122.490770587951 (37.7577448234718, -122.490770587951) 1 8 3 56 35
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
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
185492 44220 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 2139 29th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2001 12:00:00 AM 2   Permit Number 43665 5987262.4786 2100698.6187 37.74738308124 -122.486821088856 (37.74738308124, -122.486821088856) 1 8 3 29491 35
186826 254204 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1766 44th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2018 12:00:00 AM 3 3x3 Permit Number 781022 5982566.32735 2103096.10961 37.7536910129268 -122.503237266994 (37.7536910129268, -122.503237266994) 1 8 3 56 35
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
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
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
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
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
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
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
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
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
149031 177298 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 0 Font Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     3     5988403.4281 2091243.72009 37.721488831717 -122.482183231171 (37.721488831717, -122.482183231171) 1 8 4 64 14
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
35 16620 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 125 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/1999 12:00:00 AM 6 3X3   6002913 2107540 37.7670678918229 -122.433191472284 (37.7670678918229, -122.433191472284) 15 5 5 28862 3
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
12464 229252 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 171 Alpine Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001736.09856 2107829.47275 37.7677958798953 -122.43728291608 (37.7677958798953, -122.43728291608) 15 5 5 29492 3
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
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

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