246 rows where qSpecies_id = 20 sorted by Police 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)
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
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
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
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
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
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
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
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
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
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
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
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
33431 39987 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 1430 Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/1999 12:00:00 AM 6   Permit Number 41245 6017109.13931221 2093820.25947236 37.7301913909688 -122.383133682915 (37.7301913909688, -122.383133682915) 10 3 8 58 1
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
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
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
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
142205 200499 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1082 Jamestown Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6013591.41 2089958.2062 37.7193919575312 -122.395024624648 (37.7193919575312, -122.395024624648) 10 3 8 58 1
160329 117201 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 298 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6013997.02726 2105851.29667 37.7630536171528 -122.394734957662 (37.7630536171528, -122.394734957662) 14 3 8 28856 29
162731 27135 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1921 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/1999 12:00:00 AM 7 2X3   6011851.93655 2095690.98382 37.7350361003237 -122.401440051024 (37.7350361003237, -122.401440051024) 10 3 8 58 1
178625 192813 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 1251 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6013542.5057 2106139.39713 37.7638193961669 -122.396327198343 (37.7638193961669, -122.396327198343) 14 3 8 28856 29
184881 177297 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 175 Nueva Ave 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 8ft   6012935.72172 2087140.54754 37.7116187434797 -122.397093648265 (37.7116187434797, -122.397093648265) 10 3 8 309 1
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
125928 10081 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 630 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2     26 3x3   6005564.83767 2105271.62168 37.7609895372482 -122.42385784647 (37.7609895372482, -122.42385784647) 2 4 5 28859 19
127374 229251 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 3856 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002696.23202 2103588.44836 37.7562055873309 -122.433658793934 (37.7562055873309, -122.433658793934) 2 4 5 28862 3
129271 229246 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 4107 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6001682.48896 2103485.0455 37.755864094973 -122.437157253802 (37.755864094973, -122.437157253802) 2 4 5 28862 22
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
135686 229230 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 265 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6006749.35138 2102271.82416 37.7528195849561 -122.419548287136 (37.7528195849561, -122.419548287136) 2 4 7 28859 19
136172 56244 Permitted Site 7 Magnolia doltsopa :: Himalayan Magnolia 20 259 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/20/1973 12:00:00 AM 3 3x4 Permit Number 12370 6006755.08173393 2102278.34303033 37.752837807054 -122.419528932935 (37.752837807054, -122.419528932935) 2 4 7 28859 19
144482 229247 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 601 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002381.85851 2102645.62111 37.7535989662456 -122.434678587346 (37.7535989662456, -122.434678587346) 2 4 5 28862 22
152788 229249 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 310 Liberty St 52 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   6003824.40718 2103923.16543 37.7571885904097 -122.429781053062 (37.7571885904097, -122.429781053062) 2 4 5 28862 3
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
158951 229250 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 396 Cumberland St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6003147.80925 2104494.52044 37.7587190575556 -122.432161790553 (37.7587190575556, -122.432161790553) 2 4 5 28862 3
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
169626 229233 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 4233 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002320.97141 2101183.15228 37.7495799175888 -122.434784573367 (37.7495799175888, -122.434784573367) 2 4 5 28862 22
174917 229234 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 909 Elizabeth St 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6000533.75366 2101957.19594 37.751603625115 -122.441020338428 (37.751603625115, -122.441020338428) 2 4 5 28862 22
183542 27640 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 2797 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2000 12:00:00 AM 6 3X3   6009854.42856 2101083.40112 37.7497308499102 -122.408726478761 (37.7497308499102, -122.408726478761) 2 4 7 28859 19
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
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
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
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
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
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
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
98438 96573 Undocumented 4 Magnolia doltsopa :: Himalayan Magnolia 20 44 Levant St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 5x6   6000274 2106572 37.7642599479849 -122.442249845362 (37.7642599479849, -122.442249845362) 15 5 5 28862 3
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
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
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
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
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
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
187508 229254 DPW Maintained 1 Magnolia doltsopa :: Himalayan Magnolia 20 157 States St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001282.99504 2106223.75237 37.7633611996826 -122.438735069383 (37.7633611996826, -122.438735069383) 15 5 5 28862 3
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
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
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
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

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