trees
1,121 rows where qSpecies_id = 6 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32904 | 256600 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 51877 | 256607 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 34 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 61590 | 256576 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 70541 | 256574 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 92562 | 256604 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 134706 | 256601 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 160238 | 256575 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 183981 | 256606 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 158624 | 49803 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 8 | Permit Number 46598 | 6014016.82872 | 2106570.58674 | 37.7650297307661 | -122.394716845308 | (37.7650297307661, -122.394716845308) | 14 | 3 | 8 | 28856 | 29 | |
| 65951 | 191221 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Mississippi St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014015.89789 | 2106592.91783 | 37.7650909952748 | -122.394721628821 | (37.7650909952748, -122.394721628821) | 14 | 3 | 8 | 28856 | 29 | |||
| 31876 | 88495 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 27 Reddy St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51437 | 6013659 | 2094063 | 37.7306666521666 | -122.395078350002 | (37.7306666521666, -122.395078350002) | 10 | 3 | 8 | 58 | 1 | |||
| 174884 | 191222 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1143 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6013778.51486 | 2106149.81223 | 37.7638611238173 | -122.39551163825 | (37.7638611238173, -122.39551163825) | 14 | 3 | 8 | 28856 | 29 | |||
| 106294 | 191227 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201 Texas St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6013759.688 | 2106121.42545 | 37.7637821327587 | -122.395574766182 | (37.7637821327587, -122.395574766182) | 14 | 3 | 8 | 28856 | 29 | |||
| 80264 | 105013 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 330 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | 6 | 2 | 9 | 28856 | 34 | ||||
| 92191 | 105012 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 330 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | 6 | 2 | 9 | 28856 | 34 | ||||
| 136349 | 105014 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 330 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | 6 | 2 | 9 | 28856 | 34 | ||||
| 57255 | 176878 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013154.94381 | 2086496.55313 | 37.7098626625021 | -122.396290845073 | (37.7098626625021, -122.396290845073) | 10 | 3 | 8 | 309 | 1 | |||
| 169305 | 176877 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013098.43993 | 2086515.08302 | 37.7099103976217 | -122.396487432357 | (37.7099103976217, -122.396487432357) | 10 | 3 | 8 | 309 | 1 | |||
| 174505 | 108825 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 146-150X Gillette Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6013072.89275 | 2086799.91674 | 37.7106910734067 | -122.39659568235 | (37.7106910734067, -122.39659568235) | 10 | 3 | 8 | 309 | 1 | |
| 127629 | 176876 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013031.56753 | 2086536.06642 | 37.7099642921874 | -122.396720027609 | (37.7099642921874, -122.396720027609) | 10 | 3 | 8 | 309 | 1 | |||
| 192015 | 108829 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 545 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6012931.90275 | 2086607.74701 | 37.7101555653976 | -122.397069513169 | (37.7101555653976, -122.397069513169) | 10 | 3 | 8 | 309 | 1 | ||
| 101851 | 176875 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012929.76757 | 2086570.3757 | 37.7100528322548 | -122.397074274178 | (37.7100528322548, -122.397074274178) | 10 | 3 | 8 | 309 | 1 | |||
| 9738 | 79640 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 168 Orsi Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6012982.50067 | 2092948.34875 | 37.727568405236 | -122.397338990501 | (37.727568405236, -122.397338990501) | 10 | 3 | 8 | 58 | 1 | |||
| 12096 | 83834 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6013045.53048 | 2096356.5558 | 37.7369301480983 | -122.397360003177 | (37.7369301480983, -122.397360003177) | 10 | 3 | 8 | 58 | 1 | |||
| 56826 | 176874 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012843.86934 | 2086597.3532 | 37.7101221250005 | -122.397373047849 | (37.7101221250005, -122.397373047849) | 10 | 3 | 8 | 309 | 1 | |||
| 122458 | 87640 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | 6012975.96285 | 2096322.27153 | 37.7368321371284 | -122.397598127165 | (37.7368321371284, -122.397598127165) | 10 | 3 | 8 | 58 | 1 | |||
| 37255 | 108775 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 54619 | 108768 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 108222 | 108764 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 117917 | 108778 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 134524 | 108772 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 185726 | 200836 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6013076.6871 | 2107039.6693 | 37.7662654119853 | -122.398001493496 | (37.7662654119853, -122.398001493496) | 14 | 3 | 8 | 28856 | 20 | |||
| 120653 | 200835 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6013058.6169 | 2107038.7182 | 37.7662617940431 | -122.398063928568 | (37.7662617940431, -122.398063928568) | 14 | 3 | 8 | 28856 | 20 | |||
| 887 | 60297 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1982 12:00:00 AM | 7 | Permit Number 19862 | 6013032.9382 | 2107035.865 | 37.7662525295396 | -122.398152546702 | (37.7662525295396, -122.398152546702) | 14 | 3 | 8 | 28856 | 20 | |
| 102170 | 39552 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 10 | Permit Number 40979 | 6013009.1617 | 2107035.865 | 37.7662512051775 | -122.398234785624 | (37.7662512051775, -122.398234785624) | 14 | 3 | 8 | 28856 | 20 | ||
| 67683 | 191232 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2055 Silver Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012617.37339 | 2096166.05375 | 37.7363832218132 | -122.398826976382 | (37.7363832218132, -122.398826976382) | 10 | 3 | 8 | 58 | 1 | |||
| 157196 | 27169 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2080 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1999 12:00:00 AM | 6 | 2x3 | 6012550.77406 | 2096074.99276 | 37.7361294762783 | -122.39905085002 | (37.7361294762783, -122.39905085002) | 10 | 3 | 8 | 58 | 1 | ||
| 86466 | 191233 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2055 Silver Ave | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6012545.71972 | 2096123.80654 | 37.7362632270542 | -122.399071750278 | (37.7362632270542, -122.399071750278) | 10 | 3 | 8 | 58 | 1 | |||
| 162447 | 88066 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2055 Silver Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51066 | 6012463.39117 | 2096075.79817 | 37.736126817888 | -122.399353026719 | (37.736126817888, -122.399353026719) | 10 | 3 | 8 | 58 | 1 | |
| 87554 | 27125 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2095X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2011 12:00:00 AM | 6 | 3X3 | 6012407.8106259 | 2096047.4553772 | 37.7360458965855 | -122.399543203223 | (37.7360458965855, -122.399543203223) | 10 | 3 | 8 | 58 | 1 | ||
| 137916 | 27123 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2095X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2011 12:00:00 AM | 3 | 3X3 | 6012407.8106259 | 2096047.4553772 | 37.7360458965855 | -122.399543203223 | (37.7360458965855, -122.399543203223) | 10 | 3 | 8 | 58 | 1 | ||
| 138661 | 27273 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2095X Silver Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2011 12:00:00 AM | 8 | 3X3 | 6012407.8106259 | 2096047.4553772 | 37.7360458965855 | -122.399543203223 | (37.7360458965855, -122.399543203223) | 10 | 3 | 8 | 58 | 1 | ||
| 111468 | 27168 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2070X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 6 | 2X3 | 6012351.75792 | 2095958.07131 | 37.735797342091 | -122.399730727068 | (37.735797342091, -122.399730727068) | 10 | 3 | 8 | 58 | 1 | ||
| 8 | 264824 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1x Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6012032 | 2089425 | 37.7178410421308 | -122.400377527521 | (37.7178410421308, -122.400377527521) | 10 | 7 | 8 | 309 | 39 | |||
| 141360 | 176880 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3333 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012013.01229 | 2090122.10429 | 37.7197540907522 | -122.400492099948 | (37.7197540907522, -122.400492099948) | 10 | 7 | 8 | 309 | 28 | |||
| 150802 | 61555 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1175- 1175 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781207 | 6012252.19835 | 2102963.49184 | 37.7550271768774 | -122.400566896541 | (37.7550271768774, -122.400566896541) | 10 | 3 | 8 | 28856 | 29 |
| 23429 | 176881 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3303 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011991.79808 | 2090250.44255 | 37.7201052985 | -122.400574440964 | (37.7201052985, -122.400574440964) | 10 | 7 | 8 | 309 | 28 | |||
| 44173 | 49818 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1300 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 7 | 3x3 | Permit Number 46609 | 6012222.38132 | 2102319.17957 | 37.7532563730854 | -122.400624753529 | (37.7532563730854, -122.400624753529) | 10 | 3 | 8 | 28856 | 29 |
| 25 | 49783 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | Permit Number 46568 | 6011944.29976 | 2088937.30454 | 37.7164970376796 | -122.400646428989 | (37.7164970376796, -122.400646428989) | 10 | 7 | 8 | 309 | 39 | |
| 175350 | 191223 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1112 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012178.19052 | 2103217.19746 | 37.7557196692435 | -122.400840661869 | (37.7557196692435, -122.400840661869) | 10 | 3 | 8 | 28856 | 29 | |||
| 97730 | 41784 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 13 | Permit Number 42194 | 6011899.9957 | 2107451.97946 | 37.7673319169733 | -122.40210045827 | (37.7673319169733, -122.40210045827) | 8 | 2 | 8 | 28853 | 20 | |
| 140711 | 41785 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 13 | Permit Number 42194 | 6011884.29769 | 2107452.29856 | 37.7673319169518 | -122.402154778231 | (37.7673319169518, -122.402154778231) | 8 | 2 | 8 | 28853 | 20 | |
| 86891 | 41786 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 11 | Permit Number 42194 | 6011862.44614 | 2107450.91483 | 37.7673268978362 | -122.402230262809 | (37.7673268978362, -122.402230262809) | 8 | 2 | 8 | 28853 | 20 | |
| 59083 | 88474 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51428 | 6011695.42869 | 2099760.86607 | 37.7462023967426 | -122.402267215055 | (37.7462023967426, -122.402267215055) | 10 | 3 | 8 | 58 | 1 | |
| 108082 | 41787 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 11 | Permit Number 42194 | 6011846.53611 | 2107450.83181 | 37.7673257817889 | -122.402285287842 | (37.7673257817889, -122.402285287842) | 8 | 2 | 8 | 28853 | 20 | |
| 133595 | 88475 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51428 | 6011686.38123 | 2099767.14104 | 37.7462191214225 | -122.402298941348 | (37.7462191214225, -122.402298941348) | 10 | 3 | 8 | 58 | 1 | |
| 17049 | 112023 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 17413 | 112021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 127080 | 112029 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 9x9 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 187598 | 112025 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 13960 | 27162 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700X Silver Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011270.31088 | 2095195.56425 | 37.7336433130742 | -122.40341610708 | (37.7336433130742, -122.40341610708) | 10 | 3 | 8 | 58 | 1 | ||
| 132281 | 254353 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2 Ankeny St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777225 | 6011131.69741 | 2089639.6721 | 37.7183802415409 | -122.403504586485 | (37.7183802415409, -122.403504586485) | 10 | 7 | 8 | 309 | 28 | |
| 49657 | 46433 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777225 | 6011103.47209 | 2089684.58226 | 37.718501979072 | -122.403605308234 | (37.718501979072, -122.403605308234) | 10 | 7 | 8 | 309 | 28 |
| 95475 | 46434 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011096.25435 | 2089701.2859 | 37.7185474406786 | -122.40363143174 | (37.7185474406786, -122.40363143174) | 10 | 7 | 8 | 309 | 28 | |
| 172292 | 176884 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 96 Alpha St | 2 | Front Yard : Yard | Tree | Private 2 | 1 | 6011062.55449 | 2088258.87965 | 37.7145850034576 | -122.403646486396 | (37.7145850034576, -122.403646486396) | 9 | 7 | 8 | 309 | 39 | ||||
| 82669 | 46431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2002 12:00:00 AM | 1 | Permit Number 44652 | 6011089.42189 | 2089718.35805 | 37.7185939356546 | -122.403656249429 | (37.7185939356546, -122.403656249429) | 10 | 7 | 8 | 309 | 28 | ||
| 66747 | 27158 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700X Silver Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011192.58379 | 2095136.52795 | 37.7334768701528 | -122.403680681311 | (37.7334768701528, -122.403680681311) | 10 | 3 | 8 | 58 | 1 | ||
| 151427 | 176883 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 96 Alpha St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6011048.63475 | 2088252.82193 | 37.7145675926038 | -122.403694172945 | (37.7145675926038, -122.403694172945) | 9 | 7 | 8 | 309 | 39 | ||||
| 97627 | 27156 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700X Silver Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011160.21022 | 2095112.55455 | 37.7334092357479 | -122.403790920224 | (37.7334092357479, -122.403790920224) | 10 | 3 | 8 | 58 | 1 | ||
| 76984 | 176882 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 371 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781358 | 6010924.50069 | 2089093.90072 | 37.7168700890604 | -122.404182392406 | (37.7168700890604, -122.404182392406) | 9 | 7 | 8 | 309 | 39 |
| 15493 | 259346 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 106 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6011005.88556 | 2093460.4594 | 37.728864306632 | -122.404208230977 | (37.728864306632, -122.404208230977) | 10 | 3 | 7 | 309 | 28 | ||
| 191983 | 27161 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700X Silver Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011020.5092245 | 2095004.7366116 | 37.7331053850338 | -122.40426632243 | (37.7331053850338, -122.40426632243) | 10 | 3 | 8 | 58 | 1 | ||
| 189147 | 191218 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 477 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6011234.32907 | 2106146.16371 | 37.7637092651804 | -122.404310998169 | (37.7637092651804, -122.404310998169) | 8 | 3 | 8 | 28856 | 29 | |||
| 334 | 162296 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 299 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6010920.41592 | 2090984.45712 | 37.7220609417541 | -122.40432950351 | (37.7220609417541, -122.40432950351) | 10 | 3 | 7 | 309 | 28 | ||
| 118890 | 176879 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 140 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010956.3364 | 2092967.77816 | 37.7275087379234 | -122.404344863032 | (37.7275087379234, -122.404344863032) | 10 | 3 | 7 | 309 | 28 | |||
| 9949 | 162295 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 299 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6010903.85659 | 2090979.54911 | 37.7220465400048 | -122.404386400036 | (37.7220465400048, -122.404386400036) | 10 | 3 | 7 | 309 | 28 | ||
| 50859 | 114691 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 391 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 774511 | 6010909.5 | 2092975 | 37.7275259502006 | -122.404507285761 | (37.7275259502006, -122.404507285761) | 10 | 3 | 7 | 309 | 28 | |||
| 138944 | 114692 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 391 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 12/01/2015 12:00:00 AM | Permit Number 774511 | 6010909.5 | 2092975 | 37.7275259502006 | -122.404507285761 | (37.7275259502006, -122.404507285761) | 10 | 3 | 7 | 309 | 28 | ||
| 170413 | 191224 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 20th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011129.67031 | 2104650.44992 | 37.7595965215873 | -122.404567686256 | (37.7595965215873, -122.404567686256) | 10 | 3 | 8 | 28856 | 29 | ||||
| 174893 | 191225 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011119.4005 | 2104649.28038 | 37.7595927363317 | -122.404603122242 | (37.7595927363317, -122.404603122242) | 10 | 3 | 8 | 28856 | 29 | ||||
| 40165 | 191226 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 20th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6011107.06002 | 2104648.42845 | 37.7595897074225 | -122.404645742032 | (37.7595897074225, -122.404645742032) | 10 | 3 | 8 | 28856 | 29 | |||
| 12282 | 83440 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2230 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011076.92464 | 2105580.38381 | 37.7621469638337 | -122.404815578978 | (37.7621469638337, -122.404815578978) | 8 | 3 | 8 | 28856 | 29 | |||
| 23895 | 92663 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
| 73269 | 92664 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
| 122415 | 92665 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 791 San Bruno Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/11/2009 12:00:00 AM | Permit Number 52939 | 6011029.3 | 2104669.9 | 37.7596443172001 | -122.404916188138 | (37.7596443172001, -122.404916188138) | 10 | 3 | 8 | 28856 | 29 | |||
| 153170 | 191220 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2300 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010900.2167 | 2105543.22676 | 37.762035060293 | -122.405424130428 | (37.762035060293, -122.405424130428) | 8 | 3 | 8 | 28856 | 29 | |||
| 15168 | 259102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 619 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010517.89431 | 2086850.21293 | 37.7106866494876 | -122.405429914879 | (37.7106866494876, -122.405429914879) | 9 | 7 | 8 | 309 | 39 | |||
| 9408 | 259103 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 625 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010501.76504 | 2086856.29359 | 37.7107024439005 | -122.405486089504 | (37.7107024439005, -122.405486089504) | 9 | 7 | 8 | 309 | 39 | |||
| 175025 | 115381 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1657X York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 775521 | 6010720.61658 | 2099977.21326 | 37.7467419766429 | -122.405653246985 | (37.7467419766429, -122.405653246985) | 2 | 7 | 7 | 28859 | 2 | ||
| 30613 | 227099 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 75 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010635.77556 | 2100089.10311 | 37.7470444571367 | -122.405954501114 | (37.7470444571367, -122.405954501114) | 2 | 7 | 7 | 28859 | 2 | |||
| 156212 | 27014 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1518 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 6 | 3X3 | 6010461.99919 | 2094665.45469 | 37.7321425639198 | -122.40617335478 | (37.7321425639198, -122.40617335478) | 10 | 3 | 7 | 309 | 28 | ||
| 191490 | 60927 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1506 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/1983 12:00:00 AM | 5 | Permit Number 20728 | 6010428.9415 | 2094674.96946 | 37.7321668403311 | -122.406288313254 | (37.7321668403311, -122.406288313254) | 10 | 3 | 7 | 309 | 28 | ||
| 138303 | 191219 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 318 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010580.39617 | 2106780.39752 | 37.7654141639451 | -122.406617457953 | (37.7654141639451, -122.406617457953) | 8 | 4 | 8 | 28853 | 19 | |||
| 18289 | 88190 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1118 Harrison St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51195 | 6010631 | 2110372 | 37.7752787109316 | -122.406695562022 | (37.7752787109316, -122.406695562022) | 8 | 2 | 9 | 28853 | 34 | |||
| 121138 | 95828 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 174 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767563 | 6010564.55165 | 2110346.83579 | 37.775205897855 | -122.406923649213 | (37.775205897855, -122.406923649213) | 8 | 2 | 9 | 28853 | 34 |
| 12682 | 260425 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 508 Dwight St | Unaccepted Street : Yard | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6010099.90949 | 2091269.80828 | 37.7227985719868 | -122.407185909529 | (37.7227985719868, -122.407185909529) | 10 | 3 | 7 | 309 | 28 | |||
| 187299 | 27010 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1462 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6010153.37045 | 2094576.28824 | 37.7318804638018 | -122.407234074496 | (37.7318804638018, -122.407234074496) | 10 | 3 | 7 | 309 | 28 | ||
| 89153 | 27009 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1446 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2007 12:00:00 AM | 3 | 3X3 | 6010020.23018 | 2094527.09535 | 37.7317379383331 | -122.407690903133 | (37.7317379383331, -122.407690903133) | 10 | 3 | 7 | 309 | 28 | ||
| 12985 | 229829 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1472 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | Width 6ft | 6010097.10021 | 2100699.13339 | 37.7486893243481 | -122.407860213076 | (37.7486893243481, -122.407860213076) | 2 | 4 | 7 | 28859 | 19 | ||
| 41225 | 82433 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 235 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50249 | 6010057.43217179 | 2099484.04645755 | 37.745350741274 | -122.407911712216 | (37.745350741274, -122.407911712216) | 2 | 7 | 7 | 28859 | 2 |
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) );