trees
246 rows where qSpecies_id = 20 sorted by rowid descending
This data as json, CSV (advanced)
rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |
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 | |||
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 | |
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 | |
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 | ||
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 | |
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | ||
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 | ||
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 | ||
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 | |
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 | |||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |
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 | |||
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 | |||
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 | |
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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |
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 | ||
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 | |||
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 | |
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );