trees
246 rows where qSpecies_id = 20 sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
169759 | 229227 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 518 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008002.66712 | 2096426.21911 | 37.7368393705501 | -122.414800405411 | (37.7368393705501, -122.414800405411) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
154896 | 229237 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 224 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004172.07476 | 2097038.42996 | 37.7383043850279 | -122.428088066711 | (37.7383043850279, -122.428088066711) | 2 | 7 | 5 | 63 | 7 | |||
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 | |
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 | |||
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 | |||
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 | |
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | |
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 | |||
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 | ||
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 | |
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 | |||
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 | |
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 | ||
121806 | 208551 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 439 Vernon St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5992460.92355 | 2090770.88393 | 37.7204257089658 | -122.46812332475 | (37.7204257089658, -122.46812332475) | 9 | 8 | 6 | 64 | 24 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
131472 | 246804 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Brewster St | 2 | : | Tree | Private 2 | 5 | Width 2ft | 6010378.07148 | 2099339.08892 | 37.7449706654762 | -122.406792774468 | (37.7449706654762, -122.406792774468) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
124056 | 52522 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 225 Onondaga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2005 12:00:00 AM | 4 | Permit Number 48622 | 6000078.51361 | 2091484.10329 | 37.7228210397476 | -122.441843015763 | (37.7228210397476, -122.441843015763) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |
125022 | 229258 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 143 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004624.04074 | 2097533.11714 | 37.7396882447137 | -122.426560605103 | (37.7396882447137, -122.426560605103) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
133372 | 208549 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 498 Vernon St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5992504.0941 | 2091172.39511 | 37.7215306538065 | -122.468003289534 | (37.7215306538065, -122.468003289534) | 9 | 8 | 6 | 64 | 24 | |||
134610 | 229240 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009167.29555 | 2098038.41743 | 37.7413314859486 | -122.410887588289 | (37.7413314859486, -122.410887588289) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
138076 | 177292 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 400 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6003897.68799 | 2090933.24803 | 37.7215253954716 | -122.428601691123 | (37.7215253954716, -122.428601691123) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | |
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 | ||
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |
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 | |
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 | |||
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 | ||
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 | ||
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 | ||
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 | |
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 | |||
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 | |||
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 |
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) );