trees
7,322 rows where qSpecies_id = 1 sorted by qCareAssistant descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22229 | 255887 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Columbia Square St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
34844 | 102134 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 11/24/2015 12:00:00 AM | 1 | 3x3 | Permit Number 769373 | 6015285.47231 | 2114577.79035 | 37.7870861804203 | -122.390888542866 | (37.7870861804203, -122.390888542866) | 6 | 2 | 9 | 28855 | 6 |
51281 | 187631 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4255x Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/28/2017 11:56:00 AM | 3 | 3x3 | 5981269 | 2105492 | 37.7601930989218 | -122.507901429287 | (37.7601930989218, -122.507901429287) | 1 | 8 | 3 | 56 | 35 | |
59222 | 106322 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1040 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/29/2018 12:00:00 AM | 3 | 3x3 | 6012164.19951 | 2103531.96134 | 37.7565831613987 | -122.400911161547 | (37.7565831613987, -122.400911161547) | 10 | 3 | 8 | 28856 | 29 | |
103935 | 21639 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1641 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/14/2010 12:00:00 AM | 18 | 4X4 | Permit Number 53778 | 6004750.8195846 | 2114677.2774985 | 37.7867691895303 | -122.427343218264 | (37.7867691895303, -122.427343218264) | 13 | 9 | 11 | 28858 | 13 |
108393 | 251275 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1175x Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 09/16/2011 12:00:00 AM | 3x3 | 6017547 | 2094834 | 37.732999109091 | -122.381690402626 | (37.732999109091, -122.381690402626) | 10 | 3 | 8 | 58 | 1 | ||
112603 | 251276 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1175X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/09/1998 12:00:00 AM | 3x3 | 6017547 | 2094834 | 37.732999109091 | -122.381690402626 | (37.732999109091, -122.381690402626) | 10 | 3 | 8 | 58 | 1 | ||
133801 | 102879 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1680X Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 07/23/2010 12:00:00 AM | 2 | 4x4 | Permit Number 53643 | 6014844.7 | 2094689.6 | 37.7324530338407 | -122.391022948435 | (37.7324530338407, -122.391022948435) | 10 | 3 | 8 | 58 | 1 |
144881 | 106120 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 849X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 6x9 | 5992954.7 | 2110649.6 | 37.7750360842588 | -122.467861605393 | (37.7750360842588, -122.467861605393) | 11 | 6 | 2 | 54 | 11 | |||
194340 | 265026 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2621 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 11/07/2001 12:00:00 AM | 3x3 | 5997640 | 2089142 | 37.7162509166522 | -122.450103671662 | (37.7162509166522, -122.450103671662) | 9 | 8 | 6 | 28861 | 24 | ||
194348 | 265030 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2611 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/05/1997 12:00:00 AM | 3x3 | 5997671 | 2089167 | 37.7163213347739 | -122.449998321991 | (37.7163213347739, -122.449998321991) | 9 | 8 | 6 | 28861 | 24 | ||
194361 | 265029 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2611 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/05/1997 12:00:00 AM | 3x3 | 5997671 | 2089167 | 37.7163213347739 | -122.449998321991 | (37.7163213347739, -122.449998321991) | 9 | 8 | 6 | 28861 | 24 | ||
14929 | 256105 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1935 34th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Port | 09/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778629 | 5985666.45669 | 2102048.38182 | 37.7509959848908 | -122.492439326416 | (37.7509959848908, -122.492439326416) | 1 | 8 | 3 | 29491 | 35 |
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 | |||
287 | 39813 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2019 12:00:00 AM | 3 | 3x10 | Permit Number 41144 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 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 | |
679 | 258141 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 312 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 1x3 | 5998583.51543 | 2115521.94134 | 37.7887376884438 | -122.448741405189 | (37.7887376884438, -122.448741405189) | 13 | 6 | 1 | 54 | 31 | ||
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 | |||
951 | 258181 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 332 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6009802.23856 | 2094053.68877 | 37.7304258589231 | -122.408411167734 | (37.7304258589231, -122.408411167734) | 10 | 3 | 7 | 309 | 28 | ||
965 | 184959 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 41st Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 3x10 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 | |
1020 | 256741 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1494 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x3 | 5987774.09162 | 2105131.6228 | 37.7595847299836 | -122.485377233769 | (37.7595847299836, -122.485377233769) | 1 | 8 | 3 | 56 | 35 | ||
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 | ||||||||||||||
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 | ||||||||||||
1141 | 171735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1124 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 3x5 | 6007457.06473 | 2093337.1735 | 37.7283268529824 | -122.416468054284 | (37.7283268529824, -122.416468054284) | 9 | 3 | 7 | 309 | 5 | ||
1226 | 264874 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2218 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/2020 12:00:00 AM | 3 | 4x6 | 5985178 | 2100085 | 37.7455765035143 | -122.493983750596 | (37.7455765035143, -122.493983750596) | 1 | 8 | 3 | 29491 | 35 | |
1271 | 256035 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1478 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x5 | 6015597 | 2093725 | 37.7298461523087 | -122.388354746587 | (37.7298461523087, -122.388354746587) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
1870 | 70434 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 855 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 5982604.49779 | 2109922.26737 | 37.772435937677 | -122.503610737191 | (37.772435937677, -122.503610737191) | 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 | |
2872 | 47238 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200X Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | Permit Number 45189 | 6014641.0147 | 2090577.1277 | 37.7211497042731 | -122.39143974641 | (37.7211497042731, -122.39143974641) | 10 | 3 | 8 | 58 | 1 |
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 | |||
3648 | 262535 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/05/2019 12:00:00 AM | 3x3 | 6001472.85598 | 2090996.66296 | 37.7215619917613 | -122.43698819828 | (37.7215619917613, -122.43698819828) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
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 | |||
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 | |||
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 | |||
4767 | 40166 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3031 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1999 12:00:00 AM | 8 | 6x6 | Permit Number 41359 | 6004240.20521 | 2119600.37832 | 37.8002578795473 | -122.429461041019 | (37.8002578795473, -122.429461041019) | 13 | 9 | 1 | 57 | 17 |
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 | |||
4994 | 260596 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3116x Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/20/2020 12:00:00 AM | 3 | 4x6 | 6013747 | 2090444 | 37.7207345013838 | -122.394520802284 | (37.7207345013838, -122.394520802284) | 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 | ||
5441 | 147494 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 503 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2019 12:00:00 AM | 3 | 4x6 | 5989673.74283 | 2111853.74948 | 37.7781523421991 | -122.479299133273 | (37.7781523421991, -122.479299133273) | 11 | 6 | 2 | 55 | 26 | |
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 | |
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 | |
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 | |||
6095 | 261222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1890 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2020 12:00:00 AM | 3 | 5x5 | 5982931 | 2102276 | 37.751460650826 | -122.501915490969 | (37.751460650826, -122.501915490969) | 1 | 8 | 3 | 56 | 35 | |
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 | |
6264 | 45045 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2310 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2001 12:00:00 AM | 5 | 6x7.5 | Permit Number 43931 | 5988588.7333 | 2099576.402 | 37.7443790032439 | -122.482152844384 | (37.7443790032439, -122.482152844384) | 1 | 8 | 3 | 29491 | 35 |
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 | ||||||||||||||
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 |
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) );