trees
891 rows where qSpecies_id = 75 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 544 | 259763 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2701 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2019 12:00:00 AM | 3 | |||||||||||||
| 1480 | 81721 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 998 Indiana St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014944.54926 | 2104094.31483 | 37.7582819600733 | -122.391334945673 | (37.7582819600733, -122.391334945673) | 10 | 3 | 8 | 28856 | 29 | |||
| 3170 | 38792 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 655 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 3 | Permit Number 43810 | 6012704.44378 | 2111400.47389 | 37.7782184558633 | -122.399595224034 | (37.7782184558633, -122.399595224034) | 6 | 2 | 9 | 28856 | 34 | |
| 3351 | 81717 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 998 Indiana St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6014951.75745 | 2104011.46368 | 37.7580548686454 | -122.391304224825 | (37.7580548686454, -122.391304224825) | 10 | 3 | 8 | 28856 | 29 | |||
| 5464 | 66327 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1231 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | 4 | Permit Number 29446 | 5987052.1054 | 2106857.6987 | 37.7642819711606 | -122.488001017639 | (37.7642819711606, -122.488001017639) | 1 | 8 | 3 | 56 | 35 | |
| 6991 | 112084 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99X Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.7905278405438 | -122.396700174955 | (37.7905278405438, -122.396700174955) | 12 | 2 | 9 | 28855 | 6 | |||
| 8638 | 116994 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 600M Divisadero St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 6001630.0135 | 2110553.7073 | 37.7752699186497 | -122.43784499429 | (37.7752699186497, -122.43784499429) | 15 | 5 | 11 | 29492 | 10 | ||||
| 9269 | 71335 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 277 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6011311.01378 | 2111537.1063 | 37.7785158463684 | -122.404425254319 | (37.7785158463684, -122.404425254319) | 14 | 2 | 9 | 28856 | 34 | |||
| 11352 | 73737 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 595 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6013232.29052 | 2111907.2745 | 37.7796394233505 | -122.397804754791 | (37.7796394233505, -122.397804754791) | 6 | 2 | 9 | 28856 | 34 | |||
| 12330 | 259764 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2701 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2019 12:00:00 AM | 3 | |||||||||||||
| 12995 | 81719 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 998 Indiana St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6014948.61072 | 2104053.54358 | 37.7581702363807 | -122.391318049186 | (37.7581702363807, -122.391318049186) | 10 | 3 | 8 | 28856 | 29 | |||
| 13737 | 81723 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 998 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6014945.42498 | 2104137.64024 | 37.7584009709475 | -122.391334945662 | (37.7584009709475, -122.391334945662) | 10 | 3 | 8 | 28856 | 29 | |||
| 14551 | 72302 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 595 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6013261.50947 | 2111935.00833 | 37.7797172012305 | -122.397705618927 | (37.7797172012305, -122.397705618927) | 6 | 2 | 9 | 28856 | 34 | |||
| 17021 | 53357 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 333 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/1969 12:00:00 AM | 3 | Permit Number 6250 | 6014738.31742 | 2114732.62752 | 37.7874809531407 | -122.392792429224 | (37.7874809531407, -122.392792429224) | 6 | 2 | 9 | 28855 | 6 | ||
| 17355 | 258161 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 335 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6009797.86626 | 2110165.76552 | 37.7746657903123 | -122.409563015883 | (37.7746657903123, -122.409563015883) | 8 | 2 | 9 | 28853 | 34 | |||
| 18211 | 49144 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 206 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2003 12:00:00 AM | Permit Number 46269 | 5994953.84956095 | 2088734.37736924 | 37.7149776031797 | -122.459358738579 | (37.7149776031797, -122.459358738579) | 9 | 8 | 6 | 28861 | 24 | |||
| 19613 | 187949 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6015269.3196 | 2115112.5908 | 37.7885537238177 | -122.390981820563 | (37.7885537238177, -122.390981820563) | 6 | 2 | 9 | 28855 | 6 | ||||
| 20764 | 108061 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 333 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014711.31667 | 2114762.04187 | 37.7875602184789 | -122.392887905777 | (37.7875602184789, -122.392887905777) | 6 | 2 | 9 | 28855 | 6 | ||
| 22984 | 92756 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
| 24868 | 71898 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 455 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2015 12:00:00 AM | 3 | Permit Number 775644 | 6007926.40343 | 2114015.89838 | 37.7851322881578 | -122.416309554165 | (37.7851322881578, -122.416309554165) | 7 | 10 | 9 | 28858 | 36 | |
| 26661 | 56057 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2857 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2012 12:00:00 AM | Permit Number 769384 | 6009126.12851397 | 2103311.62297626 | 37.7558082292146 | -122.41140237592 | (37.7558082292146, -122.41140237592) | 2 | 4 | 7 | 28859 | 19 | |||
| 27552 | 187948 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | ||||
| 29592 | 47957 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 681 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2002 12:00:00 AM | 7 | Permit Number 45687 | 6014451.3801 | 2103976.60292 | 37.7579313656632 | -122.393032317982 | (37.7579313656632, -122.393032317982) | 10 | 3 | 8 | 28856 | 29 | ||
| 34491 | 187942 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015080.74918 | 2115307.92538 | 37.7890796023783 | -122.391647913344 | (37.7890796023783, -122.391647913344) | 6 | 2 | 9 | 28855 | 6 | ||||
| 35828 | 48550 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
| 36899 | 187864 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 801 Arkansas St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6013072.09173 | 2103413.55671 | 37.7563086487315 | -122.397763018152 | (37.7563086487315, -122.397763018152) | 10 | 3 | 8 | 28856 | 29 | ||||
| 38677 | 59325 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 345 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/1990 12:00:00 AM | 12 | Permit Number 29282 | 6006158.21098 | 2111403.55582 | 37.7778598467005 | -122.422241292597 | (37.7778598467005, -122.422241292597) | 7 | 9 | 11 | 28852 | 10 | ||
| 41561 | 48548 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
| 41848 | 49375 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 522Walbridge Carter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Permit Number 46344 | 6005207.53082 | 2086275.43702 | 37.7088100869824 | -122.423742899628 | (37.7088100869824, -122.423742899628) | 9 | 7 | 8 | 309 | 5 | |||
| 42965 | 49242 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 47304 | 256005 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | |||||
| 47592 | 48549 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
| 47707 | 254263 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 66 Lansing St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6014289.84402 | 2114150.25322 | 37.7858569681792 | -122.394303277683 | (37.7858569681792, -122.394303277683) | 6 | 2 | 9 | 28855 | 6 | ||||
| 49283 | 49391 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 522Walbridge Carter St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 46344 | 6005169.44863 | 2086179.03953 | 37.7085432500485 | -122.423867667086 | (37.7085432500485, -122.423867667086) | 9 | 7 | 8 | 309 | 5 | |||
| 51309 | 51960 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 3953 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2005 12:00:00 AM | Permit Number 48181 | 6003479.49286747 | 2101832.63497006 | 37.7514289506507 | -122.43082471383 | (37.7514289506507, -122.43082471383) | 2 | 4 | 5 | 28862 | 22 | |||
| 53211 | 49231 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 53294 | 220434 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2x Coso Ave | 8 | Median : Yard | Tree | DPW 1 | 6 | 6007135.32414 | 2099827.64271 | 37.746130149684 | -122.418040260776 | (37.746130149684, -122.418040260776) | 2 | 7 | 7 | 28859 | 2 | ||||
| 54288 | 115736 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 66 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776551 | 5993801.4 | 2096894.7 | 37.7373175329251 | -122.463934052027 | (37.7373175329251, -122.463934052027) | 1 | 8 | 4 | 59 | 40 | ||
| 59866 | 49372 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 522Walbridge Carter St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 46344 | 6005157.82583 | 2086153.99564 | 37.7084738286642 | -122.42390605734 | (37.7084738286642, -122.42390605734) | 9 | 7 | 8 | 309 | 5 | |||
| 60651 | 68389 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 122 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1993 12:00:00 AM | 1 | Permit Number 32216 | 6002009.36321 | 2093483.54875 | 37.7284208987036 | -122.43531143848 | (37.7284208987036, -122.43531143848) | 9 | 7 | 6 | 28861 | 25 | |
| 71364 | 115730 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776540 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
| 71462 | 187943 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015093.73077 | 2115293.30797 | 37.7890401869059 | -122.391601975949 | (37.7890401869059, -122.391601975949) | 6 | 2 | 9 | 28855 | 6 | ||||
| 71980 | 96783 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 219 Prentiss St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | 10 | 7 | 7 | 28859 | 2 | |||
| 73267 | 115729 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 776540 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | |||
| 73578 | 187945 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015129.76051 | 2115255.3706 | 37.7889380194338 | -122.391474663423 | (37.7889380194338, -122.391474663423) | 6 | 2 | 9 | 28855 | 6 | ||||
| 77418 | 96781 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 219 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | 10 | 7 | 7 | 28859 | 2 | |||
| 77538 | 38793 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 655 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1998 12:00:00 AM | 6 | Permit Number 40642 | 6012718.22828 | 2111411.20954 | 37.7782487018563 | -122.399548292025 | (37.7782487018563, -122.399548292025) | 6 | 2 | 9 | 28856 | 34 | ||
| 80415 | 187865 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 801 Arkansas St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6013076.18705 | 2103452.55665 | 37.7564159621389 | -122.397751590464 | (37.7564159621389, -122.397751590464) | 10 | 3 | 8 | 28856 | 29 | ||||
| 81119 | 187951 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6015307.96603 | 2115072.71193 | 37.7884463699393 | -122.390845320574 | (37.7884463699393, -122.390845320574) | 6 | 2 | 9 | 28855 | 6 | ||||
| 82230 | 53151 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1397@ JENNINGS Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2006 12:00:00 AM | 3 | Permit Number 49077 | 6016183.7166 | 2093547.2272 | 37.7293905172533 | -122.386313991736 | (37.7293905172533, -122.386313991736) | 10 | 3 | 8 | 58 | 1 | ||
| 83163 | 115737 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 9x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776557 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
| 85317 | 42181 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 649 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 4 | Permit Number 42465 | 6012754.97243 | 2111452.86272 | 37.7783651199972 | -122.399424104664 | (37.7783651199972, -122.399424104664) | 6 | 2 | 9 | 28856 | 34 | |
| 87322 | 62024 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 427 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/1985 12:00:00 AM | 5 | Permit Number 22097 | 6014298.34567 | 2112925.54615 | 37.7824946755423 | -122.394188090731 | (37.7824946755423, -122.394188090731) | 6 | 2 | 9 | 28856 | 6 | ||
| 96718 | 115731 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 15 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776556 | 5993468.8 | 2097225 | 37.7382052810266 | -122.465107977902 | (37.7382052810266, -122.465107977902) | 1 | 8 | 4 | 59 | 40 | ||
| 97512 | 256006 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | |||||
| 99183 | 108062 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 333 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014690.02107 | 2114784.12371 | 37.7876196672567 | -122.392963130455 | (37.7876196672567, -122.392963130455) | 6 | 2 | 9 | 28855 | 6 | ||
| 100478 | 50680 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 320 Clementina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | 2 | Permit Number 47253 | 6011881.28809 | 2112735.18958 | 37.7818373574415 | -122.40253671761 | (37.7818373574415, -122.40253671761) | 6 | 2 | 9 | 28853 | 34 | ||
| 100678 | 94790 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1985 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | Permit Number 53888 | 5993755.4 | 2101986.9 | 37.751296778417 | -122.464462718314 | (37.751296778417, -122.464462718314) | 1 | 8 | 4 | 29491 | 12 | |||
| 100845 | 49378 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 522Walbridge Carter St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Permit Number 46344 | 6005189.74904 | 2086240.2488 | 37.7087124637721 | -122.423801855593 | (37.7087124637721, -122.423801855593) | 9 | 7 | 8 | 309 | 5 | |||
| 105658 | 2363 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2478 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 6009688.22905 | 2102936.69302 | 37.7548102667048 | -122.409431983418 | (37.7548102667048, -122.409431983418) | 2 | 4 | 7 | 28859 | 19 | ||||
| 106018 | 60333 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 4051 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1982 12:00:00 AM | Permit Number 19906 | 6002674.88696195 | 2104708.78701715 | 37.7592805573459 | -122.433812685394 | (37.7592805573459, -122.433812685394) | 2 | 4 | 5 | 28862 | 3 | |||
| 106727 | 49229 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 110801 | 187940 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015048.62855 | 2115342.19505 | 37.7891719160015 | -122.391761444649 | (37.7891719160015, -122.391761444649) | 6 | 2 | 9 | 28855 | 6 | ||||
| 112204 | 49215 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 112518 | 46480 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 425 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2002 12:00:00 AM | Permit Number 44673 | 6005932.49263568 | 2107829.56696454 | 37.7680337988036 | -122.422768076165 | (37.7680337988036, -122.422768076165) | 8 | 4 | 5 | 28853 | 19 | |||
| 114155 | 48551 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
| 116051 | 115752 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
| 120325 | 112085 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.7905278405438 | -122.396700174955 | (37.7905278405438, -122.396700174955) | 12 | 2 | 9 | 28855 | 6 | |||
| 120509 | 49228 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 122606 | 187947 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015161.72984 | 2115222.99296 | 37.7888508922136 | -122.391361788631 | (37.7888508922136, -122.391361788631) | 6 | 2 | 9 | 28855 | 6 | ||||
| 122971 | 187950 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6015285.41791 | 2115092.62187 | 37.7884997869723 | -122.390924726221 | (37.7884997869723, -122.390924726221) | 6 | 2 | 9 | 28855 | 6 | ||||
| 125360 | 92755 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
| 126943 | 96782 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 219 Prentiss St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | 10 | 7 | 7 | 28859 | 2 | |||
| 127705 | 108060 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 333 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014722.47105 | 2114748.49264 | 37.7875236349662 | -122.392848365253 | (37.7875236349662, -122.392848365253) | 6 | 2 | 9 | 28855 | 6 | ||
| 128556 | 220433 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2x Coso Ave | 6 | Median : Yard | Tree | DPW 1 | 7 | 6007106.26454 | 2099845.01478 | 37.7461762138757 | -122.418141976794 | (37.7461762138757, -122.418141976794) | 2 | 7 | 7 | 28859 | 2 | ||||
| 132606 | 87551 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 3195 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6011859.438328 | 2090836.432048 | 37.7217069237885 | -122.401073119638 | (37.7217069237885, -122.401073119638) | 10 | 3 | 7 | 309 | 28 | ||||
| 133882 | 187944 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015109.7038 | 2115276.55289 | 37.7889950679055 | -122.391545539018 | (37.7889950679055, -122.391545539018) | 6 | 2 | 9 | 28855 | 6 | ||||
| 139423 | 42228 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 66 Lansing St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 2 | Permit Number 42484 | 6014289.84402 | 2114150.25322 | 37.7858569681792 | -122.394303277683 | (37.7858569681792, -122.394303277683) | 6 | 2 | 9 | 28855 | 6 | |
| 139444 | 115733 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 50 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776548 | 5993693.2 | 2096969 | 37.7375153061033 | -122.464313539267 | (37.7375153061033, -122.464313539267) | 1 | 8 | 4 | 59 | 40 | ||
| 139980 | 256007 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | |||||
| 142792 | 38959 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3186 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1998 12:00:00 AM | 6 | Permit Number 40754 | 5999542.34025 | 2115724.95595 | 37.7893498954312 | -122.445438624911 | (37.7893498954312, -122.445438624911) | 13 | 6 | 1 | 29490 | 27 | ||
| 147343 | 52126 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 482 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | 5 | Permit Number 48311 | 6005097.5281 | 2110773.3561 | 37.7760695863917 | -122.425865698035 | (37.7760695863917, -122.425865698035) | 7 | 9 | 11 | 28852 | 10 | |
| 148004 | 109047 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2146 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6000527.7493 | 2120317.86339 | 37.802017012843 | -122.442359096207 | (37.802017012843, -122.442359096207) | 13 | 9 | 1 | 57 | 17 | ||||
| 149325 | 187946 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015145.56326 | 2115239.56325 | 37.7888954931699 | -122.391418882079 | (37.7888954931699, -122.391418882079) | 6 | 2 | 9 | 28855 | 6 | ||||
| 154802 | 84875 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1936 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2007 12:00:00 AM | 3 | Permit No. 49244 | 5998519.2047 | 2110389.3497 | 37.7746412516506 | -122.448594107091 | (37.7746412516506, -122.448594107091) | 15 | 5 | 11 | 29492 | 16 | ||
| 155480 | 116958 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777762 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
| 160771 | 187941 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 300 Main St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6015065.49236 | 2115322.58848 | 37.7891190169896 | -122.391701726057 | (37.7891190169896, -122.391701726057) | 6 | 2 | 9 | 28855 | 6 | ||||
| 167954 | 50679 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 320 Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | 2 | Permit Number 47253 | 6011906.20035 | 2112760.01525 | 37.7819069137177 | -122.40245227846 | (37.7819069137177, -122.40245227846) | 6 | 2 | 9 | 28853 | 34 | ||
| 169207 | 50681 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 320 Clementina St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | 2 | Permit Number 47253 | 6011867.27865 | 2112722.46624 | 37.7818016399861 | -122.402584289042 | (37.7818016399861, -122.402584289042) | 6 | 2 | 9 | 28853 | 34 | ||
| 170785 | 57791 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/1977 12:00:00 AM | 2 | Permit Number 16718 | 6011755.44922 | 2112615.88032 | 37.7815027359001 | -122.402963669841 | (37.7815027359001, -122.402963669841) | 6 | 2 | 9 | 28853 | 34 | ||
| 173673 | 92758 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
| 175622 | 92757 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 528 Carter St | Front Yard : Yard | Tree | Private 2 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | 9 | 7 | 8 | 309 | 5 | ||||
| 177311 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
| 179132 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | 9 | 8 | 4 | 59 | 40 | ||
| 179843 | 49216 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
| 182457 | 115738 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 95x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776553 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
| 188463 | 115734 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 776555 | 5993732.7 | 2097034 | 37.7376960566374 | -122.464181687663 | (37.7376960566374, -122.464181687663) | 1 | 8 | 4 | 59 | 40 | ||||
| 189796 | 30769 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1642 Wallace Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 7 | Permit Number 34649 | 6014556.9626 | 2093085.2912 | 37.7280319553097 | -122.391905589486 | (37.7280319553097, -122.391905589486) | 10 | 3 | 8 | 58 | 1 | |
| 191487 | 53153 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1397@ JENNINGS Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49077 | 6016165.18448304 | 2093562.93446239 | 37.7294326204666 | -122.386379154297 | (37.7294326204666, -122.386379154297) | 10 | 3 | 8 | 58 | 1 | ||
| 193868 | 115735 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776554 | 5993777.6 | 2097002.8 | 37.7376129769989 | -122.464024183823 | (37.7376129769989, -122.464024183823) | 1 | 8 | 4 | 59 | 40 |
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) );