trees
7,322 rows where qSpecies_id = 1 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 264847 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 109 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6010522 | 2093730 | 37.729577358437 | -122.405900044893 | (37.729577358437, -122.405900044893) | 10 | 3 | 7 | 309 | 28 | |||
| 26 | 259857 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1255 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/01/2020 12:00:00 AM | 3 | 6011768.59367 | 2089078.72926 | 37.7168755602396 | -122.401263692233 | (37.7168755602396, -122.401263692233) | 10 | 7 | 8 | 309 | 39 | ||
| 90 | 259864 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
| 283 | 78989 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2319 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5988235.2891 | 2099507.8812 | 37.7441702991504 | -122.483369943638 | (37.7441702991504, -122.483369943638) | 1 | 8 | 3 | 29491 | 35 | |||
| 540 | 35140 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 911 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 7 | Permit Number 38670 | 6001882.60594 | 2088665.49745 | 37.7151844124098 | -122.435405132561 | (37.7151844124098, -122.435405132561) | 9 | 7 | 6 | 28861 | 5 | |
| 605 | 52150 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1646 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 5 | Permit Number 48341 | 6014994.17904 | 2096246.44188 | 37.7367360986871 | -122.390614910664 | (37.7367360986871, -122.390614910664) | 10 | 3 | 8 | 58 | 1 | |
| 680 | 47114 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 65 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45098 | 6008176.0434029 | 2098254.72889507 | 37.7418697970416 | -122.414330302805 | (37.7418697970416, -122.414330302805) | 2 | 7 | 7 | 28859 | 2 | ||
| 805 | 259342 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 124 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6011093.06151 | 2093005.0494 | 37.7276187164247 | -122.403874822512 | (37.7276187164247, -122.403874822512) | 10 | 3 | 7 | 309 | 28 | ||
| 882 | 31596 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1319 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 3 | Permit Number 35123 | 5989912.9927 | 2102412.7013 | 37.7522436720962 | -122.477781174123 | (37.7522436720962, -122.477781174123) | 1 | 8 | 3 | 29491 | 35 | |
| 927 | 260891 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 839 34th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985392.72943 | 2110161.55054 | 37.7732564760791 | -122.493983752439 | (37.7732564760791, -122.493983752439) | 11 | 6 | 2 | 55 | 26 | |||
| 950 | 72251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 437 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6001865.6588 | 2091176.05062 | 37.7220768687262 | -122.435643214558 | (37.7220768687262, -122.435643214558) | 9 | 7 | 6 | 28861 | 5 | |||
| 1030 | 260915 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Waller St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5999454.48308 | 2108393.47297 | 37.7692145145226 | -122.445215277932 | (37.7692145145226, -122.445215277932) | 15 | 5 | 11 | 29492 | 9 | |||
| 1095 | 255202 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 1125 | 101207 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 1138 | 260594 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
| 1284 | 72257 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 671 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002561.32843 | 2089744.29585 | 37.7181850777589 | -122.433136210491 | (37.7181850777589, -122.433136210491) | 9 | 7 | 6 | 28861 | 5 | |||
| 1312 | 71251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1364 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6007075.57639 | 2118114.43065 | 37.7963379640898 | -122.419544039651 | (37.7963379640898, -122.419544039651) | 5 | 1 | 10 | 28858 | 32 | |||
| 1375 | 84555 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 838 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5986366.07727 | 2110177.34593 | 37.7733567490821 | -122.490618019642 | (37.7733567490821, -122.490618019642) | 11 | 6 | 2 | 55 | 26 | |||
| 1391 | 71539 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 277 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6011318.23655 | 2111544.70179 | 37.7785371054488 | -122.40440080265 | (37.7785371054488, -122.40440080265) | 14 | 2 | 9 | 28856 | 34 | |||
| 1557 | 33639 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 440 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 5 | Permit Number 37734 | 6005272.3664 | 2110799.1387 | 37.7761502580876 | -122.425262720434 | (37.7761502580876, -122.425262720434) | 7 | 9 | 11 | 28852 | 10 | |
| 1580 | 31821 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 4 | Permit Number 35284 | 6009820.27489 | 2111475.42861 | 37.7782630739317 | -122.409577954154 | (37.7782630739317, -122.409577954154) | 14 | 2 | 9 | 28853 | 34 | |
| 1651 | 37169 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 151 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1998 12:00:00 AM | Permit Number 39743 | 6005565.93572779 | 2099898.57048032 | 37.7462364463923 | -122.423472053683 | (37.7462364463923, -122.423472053683) | 2 | 7 | 5 | 28859 | 22 | ||
| 1729 | 75952 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6555 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5986669.94788 | 2112490.96622 | 37.7797270399513 | -122.489737083171 | (37.7797270399513, -122.489737083171) | 11 | 6 | 2 | 55 | 26 | |||
| 1897 | 84137 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 316 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011309.96937 | 2088940.1025 | 37.7164693214661 | -122.402839197385 | (37.7164693214661, -122.402839197385) | 10 | 7 | 8 | 309 | 39 | |||
| 2032 | 71654 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 442 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011342.51966 | 2119044.79856 | 37.7991319472408 | -122.404844976017 | (37.7991319472408, -122.404844976017) | 3 | 1 | 10 | 308 | 23 | |||
| 2075 | 75757 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2194 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988246.235 | 2100404.2075 | 37.7466320110547 | -122.483397789712 | (37.7466320110547, -122.483397789712) | 1 | 8 | 3 | 29491 | 35 | |||
| 2128 | 52629 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 77 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2006 12:00:00 AM | 5 | Permit Number 48714 | 6000818.47433 | 2092706.59424 | 37.7262198574511 | -122.439372720173 | (37.7262198574511, -122.439372720173) | 9 | 7 | 6 | 28861 | 25 | |
| 2142 | 84383 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012616.61055 | 2098993.72766 | 37.7441473756935 | -122.399028026147 | (37.7441473756935, -122.399028026147) | 10 | 3 | 8 | 58 | 1 | |||
| 2354 | 65134 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 608 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1989 12:00:00 AM | 8 | Permit Number 27109 | 5984138.754 | 2111678.31461 | 37.7773476222303 | -122.498433409341 | (37.7773476222303, -122.498433409341) | 11 | 6 | 2 | 55 | 26 | |
| 2475 | 259866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 2476 | 61679 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Williams Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1984 12:00:00 AM | 11 | Permit Number 21676 | 6013741.75867 | 2093626.49588 | 37.729472702598 | -122.394761681005 | (37.729472702598, -122.394761681005) | 10 | 3 | 8 | 58 | 1 | |
| 2622 | 65282 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 445 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1989 12:00:00 AM | 1 | Permit Number 28089 | 6011007.15755 | 2112137.38618 | 37.7801470897487 | -122.405518702235 | (37.7801470897487, -122.405518702235) | 14 | 2 | 9 | 28853 | 34 | |
| 2686 | 42160 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 583 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 6 | Permit Number 42455 | 5988424.33679 | 2112023.8597 | 37.7785467725028 | -122.483633704561 | (37.7785467725028, -122.483633704561) | 11 | 6 | 2 | 55 | 26 | |
| 2801 | 57909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 900 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/10/1977 12:00:00 AM | 3 | Permit Number 16867 | 6009529.40724 | 2116088.3946 | 37.790912873091 | -122.410910067748 | (37.790912873091, -122.410910067748) | 5 | 1 | 10 | 28857 | 21 | |
| 2815 | 62472 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 139 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1986 12:00:00 AM | 9 | Permit Number 22643 | 6001469.26063 | 2093519.40721 | 37.7284886706995 | -122.43718116229 | (37.7284886706995, -122.43718116229) | 9 | 7 | 6 | 28861 | 25 | |
| 3289 | 262310 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1356 20th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2016 12:00:00 AM | 5989914.31197 | 2106134.19071 | 37.7624619657204 | -122.478048663847 | (37.7624619657204, -122.478048663847) | 1 | 8 | 3 | 56 | 35 | |||||
| 3423 | 71632 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 623 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5984096.43813 | 2111562.96127 | 37.7770284137687 | -122.498571268398 | (37.7770284137687, -122.498571268398) | 11 | 6 | 2 | 55 | 26 | |||
| 3494 | 75703 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1154 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011133.22449 | 2118927.94274 | 37.7987993887319 | -122.405560977554 | (37.7987993887319, -122.405560977554) | 3 | 1 | 10 | 308 | 23 | |||
| 3557 | 44729 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | 3 | Permit Number 43848 | 5989582.3113 | 2101095.9623 | 37.7486090577263 | -122.478828414076 | (37.7486090577263, -122.478828414076) | 1 | 8 | 3 | 29491 | 35 | |
| 3591 | 82389 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1638 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6002181.7362 | 2112286.2654 | 37.7800584461593 | -122.436060467665 | (37.7800584461593, -122.436060467665) | 15 | 5 | 11 | 29490 | 41 | |||
| 3747 | 36212 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2006 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
| 3964 | 37244 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2550 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 4 | Permit Number 39799 | 5986061.104 | 2102337.4318 | 37.7518127029083 | -122.491095885429 | (37.7518127029083, -122.491095885429) | 1 | 8 | 3 | 56 | 35 | |
| 3968 | 73735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 350 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002380.79151 | 2091565.74366 | 37.7231761244664 | -122.433890370255 | (37.7231761244664, -122.433890370255) | 9 | 7 | 6 | 28861 | 5 | |||
| 4009 | 54330 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1257 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2012 12:00:00 AM | Permit Number 769330 | 5994831.50805386 | 2106979.48216267 | 37.7650671008227 | -122.461103283683 | (37.7650671008227, -122.461103283683) | 15 | 5 | 11 | 56 | 12 | |||
| 4112 | 255223 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 4152 | 37192 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1695 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/1998 12:00:00 AM | 4 | Permit Number 39759 | 5986844.2604 | 2103759.2633 | 37.7557623917813 | -122.488492147727 | (37.7557623917813, -122.488492147727) | 1 | 8 | 3 | 56 | 35 | |
| 4328 | 36209 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
| 4362 | 72167 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2157 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5999876.34149 | 2120874.18187 | 37.8035073648317 | -122.444653277524 | (37.8035073648317, -122.444653277524) | 13 | 9 | 1 | 57 | 17 | |||
| 4458 | 37157 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 88 29th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | Permit Number 39737 | 6005841.01788139 | 2099087.47125623 | 37.7440248746354 | -122.422463228878 | (37.7440248746354, -122.422463228878) | 2 | 7 | 5 | 28859 | 2 | |||
| 4538 | 78935 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2131 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5986022.5823 | 2100717.4644 | 37.7473624613212 | -122.491109891303 | (37.7473624613212, -122.491109891303) | 1 | 8 | 3 | 29491 | 35 | |||
| 4652 | 35361 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 969 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 4 | Permit Number 38823 | 6011919.41112 | 2103909.48398 | 37.7576060979734 | -122.401784268334 | (37.7576060979734, -122.401784268334) | 10 | 3 | 8 | 28856 | 29 | |
| 4706 | 71655 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 551 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010904.1531 | 2118940.5182 | 37.7988211063956 | -122.406354529449 | (37.7988211063956, -122.406354529449) | 3 | 1 | 10 | 308 | 23 | |||
| 4712 | 39418 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
| 4733 | 70369 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1454 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983117.2046 | 2105238.7271 | 37.7596064047755 | -122.50149073173 | (37.7596064047755, -122.50149073173) | 1 | 8 | 3 | 56 | 35 | |||
| 4837 | 115185 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2300X Alemany Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 5999482.43288 | 2089277.31598 | 37.716727722789 | -122.443745071105 | (37.716727722789, -122.443745071105) | 9 | 7 | 6 | 28861 | 25 | ||||
| 4843 | 260426 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 740 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6009322.86982 | 2092462.23119 | 37.726029197201 | -122.409956117368 | (37.726029197201, -122.409956117368) | 9 | 3 | 7 | 309 | 28 | ||
| 4943 | 260913 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 482 Frederick St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997348.59542 | 2107447.85511 | 37.7664976608583 | -122.452431145559 | (37.7664976608583, -122.452431145559) | 15 | 5 | 11 | 29492 | 9 | |||
| 4962 | 71085 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 336 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000237.45691 | 2087069.9768 | 37.7107099003031 | -122.440977070243 | (37.7107099003031, -122.440977070243) | 9 | 7 | 6 | 28861 | 5 | |||
| 4987 | 84397 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012443.22283 | 2099122.96445 | 37.7444925687938 | -122.399636638738 | (37.7444925687938, -122.399636638738) | 10 | 3 | 8 | 58 | 1 | |||
| 4998 | 62129 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 618 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/1985 12:00:00 AM | 7 | Permit Number 22236 | 6001798.50341 | 2093490.78314 | 37.7284287857379 | -122.436040907355 | (37.7284287857379, -122.436040907355) | 9 | 7 | 6 | 28861 | 25 | |
| 5090 | 72166 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2164 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5999887.26115 | 2120921.40259 | 37.8036376433293 | -122.444618885675 | (37.8036376433293, -122.444618885675) | 13 | 9 | 1 | 57 | 17 | |||
| 5092 | 31222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 566 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | 7 | Permit Number 34909 | 6010818.5641 | 2118972.1322 | 37.7989031225504 | -122.406652925798 | (37.7989031225504, -122.406652925798) | 3 | 1 | 10 | 308 | 23 | |
| 5314 | 71429 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2029 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009865.7372 | 2121062.537 | 37.8045895022466 | -122.410097693334 | (37.8045895022466, -122.410097693334) | 3 | 1 | 10 | 308 | 23 | |||
| 5402 | 259405 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1140 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6013491.54198 | 2090383.23631 | 37.7205534514179 | -122.395399593578 | (37.7205534514179, -122.395399593578) | 10 | 3 | 8 | 58 | 1 | ||
| 5481 | 112239 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400X Alemany Blvd | 4 | Median : Cutout | Tree | DPW 1 | 10/27/2015 07:41:00 AM | 3 | 5999153.8915 | 2088963.97845 | 37.7158486246797 | -122.444858161098 | (37.7158486246797, -122.444858161098) | 9 | 7 | 6 | 28861 | 25 | |||
| 5558 | 38535 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4517 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40515 | 6015241.886192 | 2096337.56497418 | 37.7370000434098 | -122.389764834673 | (37.7370000434098, -122.389764834673) | 10 | 3 | 8 | 58 | 1 | ||
| 5598 | 62124 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 789 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/1985 12:00:00 AM | 12 | Permit Number 22230 | 6001290.71631 | 2092388.94515 | 37.7253745288844 | -122.437717468513 | (37.7253745288844, -122.437717468513) | 9 | 7 | 6 | 28861 | 25 | |
| 5603 | 36757 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1578 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39522 | 5993099.35503511 | 2104739.07158377 | 37.7588156897013 | -122.466931435386 | (37.7588156897013, -122.466931435386) | 1 | 8 | 4 | 56 | 12 | |||
| 5609 | 83165 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1903 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015168.2313 | 2093359.9647 | 37.7288200702379 | -122.389811574581 | (37.7288200702379, -122.389811574581) | 10 | 3 | 8 | 58 | 1 | |||
| 5613 | 73412 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 147 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009997.41366 | 2093830.92817 | 37.7298251334141 | -122.407720715656 | (37.7298251334141, -122.407720715656) | 10 | 3 | 7 | 309 | 28 | |||
| 5718 | 76201 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6009589.6321 | 2110267.6834 | 37.7749339625844 | -122.410290540065 | (37.7749339625844, -122.410290540065) | 8 | 2 | 9 | 28853 | 34 | |||
| 5739 | 52729 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2015 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/2006 12:00:00 AM | 5 | Permit Number 48785 | 6003207.48866 | 2119256.92944 | 37.7992563342625 | -122.433010091366 | (37.7992563342625, -122.433010091366) | 13 | 9 | 1 | 57 | 17 | |
| 5743 | 30556 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011713.13245 | 2086267.11073 | 37.7091523239944 | -122.40125793023 | (37.7091523239944, -122.40125793023) | 10 | 3 | 8 | 309 | 1 | ||
| 5765 | 112237 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2400X Alemany Blvd | 2 | Median : Cutout | Tree | DPW 1 | 10/27/2015 08:35:00 AM | 3 | 5999175.75859 | 2088985.62206 | 37.71590930104 | -122.444784133402 | (37.71590930104, -122.444784133402) | 9 | 7 | 6 | 28861 | 25 | |||
| 5890 | 65218 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 345 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 14 | Permit Number 28005 | 6002441.48783 | 2091581.27418 | 37.723222212016 | -122.433681664588 | (37.723222212016, -122.433681664588) | 9 | 7 | 6 | 28861 | 5 | |
| 5940 | 84389 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012558.72681 | 2099037.97239 | 37.7442656365553 | -122.399231281913 | (37.7442656365553, -122.399231281913) | 10 | 3 | 8 | 58 | 1 | |||
| 6254 | 60033 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 166 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 6 | Permit Number 19521 | 6014106.41368 | 2112395.33258 | 37.7810281600483 | -122.394814952371 | (37.7810281600483, -122.394814952371) | 6 | 2 | 9 | 28856 | 6 | |
| 6371 | 179976 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 670 Brunswick St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 5998720.79345 | 2086710.36043 | 37.7096359749025 | -122.446193129116 | (37.7096359749025, -122.446193129116) | 9 | 7 | 6 | 28861 | 5 | ||||
| 6374 | 70234 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 715 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983192.21244 | 2110893.91815 | 37.7751383456194 | -122.501649705941 | (37.7751383456194, -122.501649705941) | 11 | 6 | 2 | 55 | 26 | |||
| 6573 | 262162 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 18 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | ||
| 6640 | 255204 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 6672 | 39412 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
| 6680 | 84384 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012605.75567 | 2099001.93015 | 37.7441692930905 | -122.399066135804 | (37.7441692930905, -122.399066135804) | 10 | 3 | 8 | 58 | 1 | |||
| 6710 | 71626 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 546 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6010902.3539 | 2118984.9834 | 37.7989430963584 | -122.406363890018 | (37.7989430963584, -122.406363890018) | 3 | 1 | 10 | 308 | 23 | |||
| 6711 | 62157 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2158 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 10 | Permit Number 22272 | 5999899.60106 | 2120922.78087 | 37.8036421318499 | -122.444576282063 | (37.8036421318499, -122.444576282063) | 13 | 9 | 1 | 57 | 17 | |
| 6819 | 198078 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1501 25th St | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014189.20223 | 2101966.89329 | 37.752398567346 | -122.393798376688 | (37.752398567346, -122.393798376688) | 10 | 3 | 8 | 28856 | 1 | ||||
| 6874 | 258105 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 49 Naglee Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5998652.17813 | 2087511.67596 | 37.7118322871785 | -122.446487885746 | (37.7118322871785, -122.446487885746) | 9 | 7 | 6 | 28861 | 25 | |||||
| 6902 | 60051 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1435 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 1 | Permit Number 53408 | 5988341.1998 | 2105537.0323 | 37.7607308969178 | -122.483445635266 | (37.7607308969178, -122.483445635266) | 1 | 8 | 3 | 56 | 35 | |
| 6945 | 259738 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 659 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/09/2018 12:00:00 AM | 3 | 6005639.64346 | 2105140.6799 | 37.760634224683 | -122.423589815732 | (37.760634224683, -122.423589815732) | 2 | 4 | 5 | 28859 | 19 | ||
| 6946 | 67565 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 560 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 7 | Permit Number 31117 | 6011492.02501 | 2105753.25027 | 37.7626448096454 | -122.403392059208 | (37.7626448096454, -122.403392059208) | 8 | 3 | 8 | 28856 | 29 | |
| 6972 | 259353 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 242 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6010364.72852 | 2093515.77495 | 37.7289803445436 | -122.40642866223 | (37.7289803445436, -122.40642866223) | 10 | 3 | 7 | 309 | 28 | ||
| 6981 | 259867 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 7004 | 73618 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 623 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5984097.49569 | 2111586.76051 | 37.7770938216215 | -122.498569368455 | (37.7770938216215, -122.498569368455) | 11 | 6 | 2 | 55 | 26 | |||
| 7008 | 84391 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012539.7904 | 2099051.16113 | 37.744300794662 | -122.39929768604 | (37.744300794662, -122.39929768604) | 10 | 3 | 8 | 58 | 1 | |||
| 7040 | 76155 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009557.4611 | 2110236.6613 | 37.7748469797507 | -122.410399635935 | (37.7748469797507, -122.410399635935) | 8 | 2 | 9 | 28853 | 34 | |||
| 7078 | 62154 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2016 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 12 | Permit Number 22268 | 5999531.33121 | 2121219.56404 | 37.8044359975872 | -122.445872051358 | (37.8044359975872, -122.445872051358) | 13 | 9 | 1 | 57 | 17 | |
| 7214 | 31890 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 999 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35322 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | 8 | 2 | 9 | 28853 | 34 | ||
| 7240 | 62150 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2033 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | 11 | Permit Number 22264 | 5999463.73231 | 2121165.54346 | 37.8042838116209 | -122.446102094357 | (37.8042838116209, -122.446102094357) | 13 | 9 | 1 | 57 | 17 | |
| 7350 | 50613 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 185 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/2003 12:00:00 AM | 3 | Permit Number 47212 | 5989898.39738 | 2114150.75846 | 37.784472333864 | -122.478690011448 | (37.784472333864, -122.478690011448) | 11 | 6 | 2 | 55 | 26 | |
| 7475 | 260914 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1165 Oak St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 6001427.67727 | 2109710.45692 | 37.7729430567741 | -122.438484490103 | (37.7729430567741, -122.438484490103) | 15 | 5 | 11 | 29492 | 9 |
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) );