246 rows where qSpecies_id = 20 sorted by qLegalStatus_id

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)
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
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
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
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
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
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
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
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
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
12536 43291 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 123 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/12/2000 12:00:00 AM 7   Permit Number 43059 6013181.78147 2106427.07637 37.7645892203513 -122.397595020318 (37.7645892203513, -122.397595020318) 14 3 8 28856 29
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
17535 49781 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 308@ BLANKEN Tocoloma Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/09/2003 12:00:00 AM 6   Permit Number 46566 6012565.76433 2086991.30055 37.7111883387537 -122.398361863208 (37.7111883387537, -122.398361863208) 10 3 8 309 1
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
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
19925 229241 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 900 Powhattan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009182.18967 2098038.44408 37.7413323942725 -122.410836091326 (37.7413323942725, -122.410836091326) 10 7 7 28859 2
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
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
23138 55180 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 91 Gillette Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/04/1987 12:00:00 AM 4   Permit Number 24627 6013135.97557 2086935.85146 37.7110678340902 -122.396387174153 (37.7110678340902, -122.396387174153) 10 3 8 309 1
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
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
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
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
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
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
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
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
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
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
31440 229253 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 245 States St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6000709.62827 2106546.14051 37.7642137623885 -122.440741279694 (37.7642137623885, -122.440741279694) 15 5 5 28862 3
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
35087 1920 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 48 Berkeley Way 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2012 12:00:00 AM 3 3x3   6001413.10408 2097289.51467 37.7388373223942 -122.437645189074 (37.7388373223942, -122.437645189074) 2 7 5 63 7
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
36895 229248 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 436 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003539.13196 2102171.5132 37.7523628094001 -122.430642653946 (37.7523628094001, -122.430642653946) 2 4 5 28862 22
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
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
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
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
45222 229221 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 850 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009897.05589 2104252.20928 37.7584340776962 -122.408802604559 (37.7584340776962, -122.408802604559) 2 4 7 28859 19
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
47683 229217 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 3703 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6005775.74136 2100791.00452 37.7486987060772 -122.422809983411 (37.7486987060772, -122.422809983411) 2 4 5 28859 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
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
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
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
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
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
53686 26853 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 624 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/29/1998 12:00:00 AM 24 3X3   6005561.83223 2105304.71691 37.7610802392886 -122.423870594369 (37.7610802392886, -122.423870594369) 2 4 5 28859 19
58097 229244 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 3300X 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006303.66439 2103203.60326 37.7553529212127 -122.421155714687 (37.7553529212127, -122.421155714687) 2 4 5 28859 19
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
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
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
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
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
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
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
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
70454 229226 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 546 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007812.08689 2096313.01345 37.7365178224466 -122.415451314937 (37.7365178224466, -122.415451314937) 2 7 7 28859 2
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
76611 229261 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 2617 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009984.45916 2105005.31178 37.7605068225536 -122.40855344831 (37.7605068225536, -122.40855344831) 2 4 8 28859 19
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
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
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
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
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
84061 229220 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 10 Lundys Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6007188.55641 2099623.37433 37.7455722705428 -122.417841712947 (37.7455722705428, -122.417841712947) 2 7 7 28859 2
84940 68270 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 425 Holyoke St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/2014 12:00:00 AM 3   Permit Number 773761 6009804.05619 2092417.85671 37.7259343110037 -122.408289550324 (37.7259343110037, -122.408289550324) 10 3 7 309 28
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
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
87645 229235 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1626 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6003320.17625 2098729.19184 37.7428985924036 -122.431154158661 (37.7428985924036, -122.431154158661) 2 7 5 63 22
87868 40029 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1637 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 3   Permit Number 41272 6014869.44662 2095922.83463 37.7358406185575 -122.391023557209 (37.7358406185575, -122.391023557209) 10 3 8 58 1
88802 229224 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 428 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003023.34739 2099505.62424 37.7450136701507 -122.432235947738 (37.7450136701507, -122.432235947738) 2 7 5 63 22
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
89360 229231 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 754 Grand View Ave 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 5ft   6000043.84826 2100826.21888 37.7484703196688 -122.442633291407 (37.7484703196688, -122.442633291407) 2 4 5 28862 22
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
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
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
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
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
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
104967 32521 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 849 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/15/1996 12:00:00 AM 6   Permit Number 37023 6007575.18526 2095405.75029 37.734013358015 -122.416206150117 (37.734013358015, -122.416206150117) 2 7 7 28859 2
105157 117202 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 298 Mississippi St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013997.81154 2105821.62372 37.7629721853348 -122.394730166958 (37.7629721853348, -122.394730166958) 14 3 8 28856 29
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
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
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
110283 229232 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 708 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6001218.15121 2102192.48263 37.7522886234223 -122.43867046747 (37.7522886234223, -122.43867046747) 2 4 5 28862 22
113486 229243 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 310 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6006167.98483 2101344.37423 37.7502402565045 -122.421492901096 (37.7502402565045, -122.421492901096) 2 4 5 28859 19
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
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
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
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
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

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