Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 190 | 190 | 57209 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2898 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | Permit Number 773671 | 6000999.92024 | 2115926.87738 | 37.7899874194288 | -122.440410066565 | (37.7899874194288, -122.440410066565) | ||
| 1138 | 1138 | 44040 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 2504 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2012 12:00:00 AM | 3 | Permit Number 769379 | 6002104.9323 | 2116736.7445400003 | 37.7922739619269 | -122.436644820121 | (37.7922739619269, -122.436644820121) | ||
| 1329 | 1329 | 108251 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2342 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2014 12:00:00 AM | 3 | Permit Number 772707 | 6003487.823480001 | 2116598.59659 | 37.791973133309796 | -122.43185012238199 | (37.7919731333098, -122.431850122382) | ||
| 2176 | 2176 | 103962 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3240 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | Permit Number 780028 | 5998623.05948 | 2116578.56663 | 37.7916411629484 | -122.448680722253 | (37.7916411629484, -122.448680722253) | ||
| 2357 | 2357 | 39974 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 0 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 3593 | 3593 | 108302 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2200X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | Permit Number 773671 | 6000905.886 | 2115941.06387 | 37.7900210171946 | -122.440736434162 | (37.7900210171946, -122.440736434162) | ||
| 3821 | 3821 | 46195 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 4027 | 4027 | 253600 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
| 4041 | 4041 | 253601 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
| 4942 | 4942 | 58811 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2049 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2014 12:00:00 AM | 3 | Permit Number 773701 | 6003239.80181 | 2118222.27779 | 37.796417281581505 | -122.432824322909 | (37.7964172815815, -122.432824322909) | ||
| 5109 | 5109 | 36635 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 5809 | 5809 | 46193 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 6157 | 6157 | 117446 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1442 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778580 | 6007836.0514 | 2116543.8472700003 | 37.792068336434205 | -122.416801303441 | (37.7920683364342, -122.416801303441) | ||
| 6261 | 6261 | 58063 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1747 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1977 12:00:00 AM | 12 | Permit Number 17033 | 5999523.022000001 | 2114932.0979 | 37.7871718119958 | -122.445448429932 | (37.7871718119958, -122.445448429932) | ||
| 6461 | 6461 | 34901 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
| 6892 | 6892 | 36621 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 7024 | 7024 | 34903 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
| 8059 | 8059 | 34906 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
| 8112 | 8112 | 36618 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 8143 | 8143 | 53665 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1540 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/1969 12:00:00 AM | Permit Number 6603 | 6006700.2941 | 2116215.7306 | 37.791103462133705 | -122.420707740038 | (37.7911034621337, -122.420707740038) | |||
| 8704 | 8704 | 108300 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2898 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | Permit Number 773671 | 6000965.8204 | 2115920.74629 | 37.789968643383204 | -122.440527608864 | (37.7899686433832, -122.440527608864) | ||
| 8917 | 8917 | 108299 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2898 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | Permit Number 773671 | 6000983.93549 | 2115922.8900099997 | 37.7899755609799 | -122.44046508619302 | (37.7899755609799, -122.440465086193) | ||
| 9577 | 9577 | 36622 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 9913 | 9913 | 59381 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 484 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1982 12:00:00 AM | Permit Number 19657 | 6003572.8522015 | 2096120.76265672 | 37.735750758984295 | -122.430094437299 | (37.7357507589843, -122.430094437299) | |||
| 9973 | 9973 | 34904 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
| 10415 | 10415 | 47411 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2722 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45322 | ||||||||
| 10516 | 10516 | 46191 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 10641 | 10641 | 87649 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2132 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2008 12:00:00 AM | 3 | 6011869.04727 | 2087711.09521 | 37.7131259154971 | -122.400820441523 | (37.7131259154971, -122.400820441523) | |||
| 10864 | 10864 | 115820 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 70 Gladstone Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2016 12:00:00 AM | 3 | Permit Number 773037 | 6006341.45931 | 2093992.33165 | 37.730062972613794 | -122.420371241439 | (37.7300629726138, -122.420371241439) | ||
| 10947 | 10947 | 34905 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
| 11359 | 11359 | 36625 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 11887 | 11887 | 46194 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 11889 | 11889 | 87695 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2630 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2008 12:00:00 AM | 3 | 6010495.31841 | 2086065.48531 | 37.7085306829266 | -122.40545271269501 | (37.7085306829266, -122.405452712695) | |||
| 11991 | 11991 | 46192 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 12032 | 12032 | 39973 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 0 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 12224 | 12224 | 95538 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1220 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6001061.1187 | 2087367.06647 | 37.711572521034604 | -122.438151583834 | (37.7115725210346, -122.438151583834) | ||||
| 12274 | 12274 | 33081 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 221 Greenwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37335 | ||||||||
| 12314 | 12314 | 36623 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 12645 | 12645 | 30435 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3229 Barker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | Permit Number 88 | ||||||||
| 12886 | 12886 | 33080 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 221 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37335 | ||||||||
| 12930 | 12930 | 36616 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 12947 | 12947 | 87653 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2180X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6011545.44829 | 2087485.71058 | 37.7124889994373 | -122.401923081412 | (37.7124889994373, -122.401923081412) | ||||
| 13657 | 13657 | 37185 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 140 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1998 12:00:00 AM | 2 | Permit Number 39756 | 6009578.451859999 | 2111630.6587099996 | 37.7786757458161 | -122.41042547617901 | (37.7786757458161, -122.410425476179) | ||
| 13700 | 13700 | 36624 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 13764 | 13764 | 36627 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 13775 | 13775 | 46199 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 13844 | 13844 | 56718 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1542 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2015 12:00:00 AM | 3 | Permit Number 775560 | 6015709.0498 | 2095719.9997 | 37.7353302290178 | -122.388106542106 | (37.7353302290178, -122.388106542106) | ||
| 14367 | 14367 | 46202 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 14482 | 14482 | 109063 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 401 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2015 12:00:00 AM | 3 | Permit Number 774722 | 6014773.1420599995 | 2114255.79417 | 37.7861736122787 | -122.39263857322901 | (37.7861736122787, -122.392638573229) | ||
| 15359 | 15359 | 63894 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1640 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2017 12:00:00 AM | 3 | Permit Number 779548 | 6006894.81694 | 2116748.05753 | 37.7925760612872 | -122.420072490278 | (37.7925760612872, -122.420072490278) | ||
| 15451 | 15451 | 34902 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
| 15515 | 15515 | 39976 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 0 Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 15625 | 15625 | 109064 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 401 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2015 12:00:00 AM | 3 | Permit Number 774722 | 6014787.30736 | 2114269.34055 | 37.7862115942283 | -122.39259051256799 | (37.7862115942283, -122.392590512568) | ||
| 15681 | 15681 | 73555 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 315 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 8 | 6011765.85635 | 2112068.38095 | 37.7800000110193 | -122.402889147539 | (37.7800000110193, -122.402889147539) | ||
| 15974 | 15974 | 36620 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 16053 | 16053 | 36610 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 16211 | 16211 | 34900 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
| 16245 | 16245 | 109062 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 401 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2015 12:00:00 AM | 3 | Permit Number 774722 | 6014756.57852 | 2114238.14616 | 37.7861242349771 | -122.392694644144 | (37.7861242349771, -122.392694644144) | ||
| 16719 | 16719 | 71331 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 315 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 8 | 6011757.84173 | 2112077.6198 | 37.780024931232795 | -122.402917523848 | (37.7800249312328, -122.402917523848) | ||
| 18258 | 18258 | 30562 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1074 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 14 | Permit Number 38411 | 6008011.79259 | 2101700.97642 | 37.7513231949327 | -122.41514211632798 | (37.7513231949327, -122.415142116328) | |
| 18789 | 18789 | 108100 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2390X Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | |||||
| 19038 | 19038 | 10330 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 827 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2007 12:00:00 AM | 3 | 6002167.0188 | 2109110.84492 | 37.7713386988586 | -122.435884111474 | (37.7713386988586, -122.435884111474) | |||
| 19847 | 19847 | 47738 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 765ST Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2002 12:00:00 AM | Permit Number 45522 | 6001007.50472324 | 2111284.16772448 | 37.7772401606319 | -122.440050778725 | (37.7772401606319, -122.440050778725) | |||
| 20458 | 20458 | 30563 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1074 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 14 | Permit Number 38411 | 6008014.076330001 | 2101681.3139299997 | 37.7512693345126 | -122.415132827214 | (37.7512693345126, -122.415132827214) | |
| 20487 | 20487 | 52068 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 712 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2005 12:00:00 AM | Permit Number 48263 | 6002387.64911421 | 2104013.98805982 | 37.7573565030376 | -122.434756406645 | (37.7573565030376, -122.434756406645) | |||
| 21109 | 21109 | 5698 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1563 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 6005312.626 | 2099232.77644 | 37.744394027363704 | -122.424300623169 | (37.7443940273637, -122.424300623169) | |||
| 22971 | 22971 | 108017 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 540 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773431 | 6005280.9160400005 | 2110975.82036 | 37.776635865873104 | -122.425245720162 | (37.7766358658731, -122.425245720162) | ||
| 23061 | 23061 | 3903 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 86 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6002177.2282 | 2107781.12662 | 37.767688200474 | -122.435753644126 | (37.767688200474, -122.435753644126) | ||||
| 23083 | 23083 | 4435 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1252 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 6004447.85854 | 2101556.1820400003 | 37.750724693399206 | -122.42745629658 | (37.7507246933992, -122.42745629658) | ||||
| 23255 | 23255 | 18991 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2965 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 6000619.7723 | 2115501.32985 | 37.788797324076 | -122.44169478950501 | (37.788797324076, -122.441694789505) | ||||
| 23361 | 23361 | 2382 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2600 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 6009734.663319999 | 2102078.76769 | 37.7524571968444 | -122.40921086350401 | (37.7524571968444, -122.409210863504) | ||||
| 23505 | 23505 | 40203 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 567 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1999 12:00:00 AM | 7 | Permit Number 41385 | 5982843.19919 | 2111934.60892 | 37.77797527327971 | -122.50293405873 | (37.7779752732797, -122.50293405873) | |
| 23548 | 23548 | 65528 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1406 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/1990 12:00:00 AM | 3 | Permit Number 28416 | 6006766.789 | 2115740.5827 | 37.7898025712066 | -122.420443928528 | (37.7898025712066, -122.420443928528) | ||
| 23627 | 23627 | 65292 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/1991 12:00:00 AM | 14 | Permit Number 29486 | 6010574.9893 | 2116273.6869 | 37.7914802149935 | -122.407305449035 | (37.7914802149935, -122.407305449035) | |
| 23688 | 23688 | 208664 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 462 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998358.74509 | 2094413.2873 | 37.730765747833296 | -122.44799866202699 | (37.7307657478333, -122.447998662027) | ||||
| 23821 | 23821 | 74230 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1011 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 10 | 6011143.4423 | 2118449.9882 | 37.797487612886705 | -122.40549194088301 | (37.7974876128867, -122.405491940883) | ||
| 23884 | 23884 | 70675 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 49 Rausch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 11 | 6009740.45587 | 2110875.89947 | 37.7766124348397 | -122.409811748212 | (37.7766124348397, -122.409811748212) | ||
| 24512 | 24512 | 52728 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2015 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/2006 12:00:00 AM | 4 | Permit Number 48785 | 6003190.39374 | 2119254.94728 | 37.7992499220995 | -122.43306910395599 | (37.7992499220995, -122.433069103956) | |
| 24759 | 24759 | 47463 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1824 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 8 | Permit Number 45367 | 6000019.70376 | 2115264.08924 | 37.788111715140204 | -122.443753884429 | (37.7881117151402, -122.443753884429) | |
| 24945 | 24945 | 31011 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 101 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34782 | 6000906.10436 | 2087937.38156 | 37.713129662086395 | -122.438728194053 | (37.7131296620864, -122.438728194053) | |
| 25146 | 25146 | 47865 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 60Street Rausch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | 11 | Permit Number 47213 | 6009781.37011 | 2110787.05601 | 37.776370784322 | -122.409663941064 | (37.776370784322, -122.409663941064) | ||
| 25542 | 25542 | 38817 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 216 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1998 12:00:00 AM | 7 | Permit Number 40653 | 5994941.81216 | 2114078.08818 | 37.7845643407629 | -122.461236379694 | (37.7845643407629, -122.461236379694) | |
| 25924 | 25924 | 46092 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 100 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2001 12:00:00 AM | 2 | Permit Number 44465 | 5989927.3729 | 2114632.55981 | 37.785796907481206 | -122.478625013843 | (37.7857969074812, -122.478625013843) | ||
| 26078 | 26078 | 49621 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1808 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2003 12:00:00 AM | 6 | Permit Number 46480 | 6007981.31834 | 2109654.0767599996 | 37.7731588583184 | -122.41581059767401 | (37.7731588583184, -122.415810597674) | |
| 26225 | 26225 | 64100 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 19 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/1987 12:00:00 AM | 4 | Permit Number 24866 | 5993610.12916 | 2115328.81295 | 37.7879217608498 | -122.46593442580401 | (37.7879217608498, -122.465934425804) | ||
| 26343 | 26343 | 31607 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 5 Lucerne St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1995 12:00:00 AM | 9 | Permit Number 35133 | 6012055.459419999 | 2109792.65137 | 37.7737675473795 | -122.40172727021002 | (37.7737675473795, -122.40172727021) | ||
| 26413 | 26413 | 69393 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 35 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 13 | Permit Number 33497 | 6001235.31343 | 2088039.6013 | 37.7134290580849 | -122.437597654505 | (37.7134290580849, -122.437597654505) | |
| 26437 | 26437 | 31611 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 5 Lucerne St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1995 12:00:00 AM | 2 | Permit Number 35133 | 6012160.7712900005 | 2109682.61509 | 37.7734712891136 | -122.401355243146 | (37.7734712891136, -122.401355243146) | ||
| 26623 | 26623 | 58372 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 520 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 6 | Permit Number 22168 | 6013233.92594 | 2104448.90475 | 37.7591604996691 | -122.397275936353 | (37.7591604996691, -122.397275936353) | |
| 26837 | 26837 | 39565 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 340 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/11/2001 12:00:00 AM | 7 | Permit Number 40986 | 6011421.0186 | 2106801.06955 | 37.765517919653 | -122.403711377001 | (37.765517919653, -122.403711377001) | |
| 26936 | 26936 | 55002 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 567 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2001 12:00:00 AM | 5 | Permit Number 43697 | 5990923.7049 | 2111532.47147 | 37.7773427195124 | -122.474951647244 | (37.7773427195124, -122.474951647244) | ||
| 26998 | 26998 | 63476 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2051 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1987 12:00:00 AM | 9 | Permit Number 24070 | 5999777.5984 | 2111554.8683 | 37.7779133417521 | -122.444324862708 | (37.7779133417521, -122.444324862708) | |
| 27079 | 27079 | 36965 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 167 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 7 | Permit Number 39593 | 5994259.0556 | 2114506.2266 | 37.785700576420005 | -122.463629551786 | (37.78570057642, -122.463629551786) | |
| 27394 | 27394 | 72145 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 350 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1985 12:00:00 AM | 1 | 6001088.11474 | 2092709.73665 | 37.72624382708 | -122.438440814794 | (37.72624382708, -122.438440814794) | ||
| 27400 | 27400 | 79632 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 66 Danton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2003 12:00:00 AM | 7 | 6002838.60108 | 2094532.2016200002 | 37.7313473196134 | -122.432519596596 | (37.7313473196134, -122.432519596596) | ||
| 27491 | 27491 | 52049 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2440 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2005 12:00:00 AM | 8 | Permit Number 48253 | 6002261.8769 | 2117085.04617 | 37.7932392258584 | -122.436126725161 | (37.7932392258584, -122.436126725161) | ||
| 27595 | 27595 | 32441 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 4124 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 11 | Permit Number 36964 | 6001535.595480001 | 2105867.5676 | 37.76239757069921 | -122.437835895728 | (37.7623975706992, -122.437835895728) | |
| 27824 | 27824 | 30321 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2828 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/1956 12:00:00 AM | 2 | Permit Number 15 | 6000624.45105 | 2118021.66176 | 37.7957177628231 | -122.441859564181 | (37.7957177628231, -122.441859564181) | ||
| 27962 | 27962 | 79969 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1209 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 2 | 6009151.65519 | 2110631.00796 | 37.7759070057295 | -122.411831280182 | (37.7759070057295, -122.411831280182) | ||
| 28360 | 28360 | 53655 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1314 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1980 12:00:00 AM | 2 | Permit Number 18591 | 6006805.5909 | 2115457.7398 | 37.7890281410374 | -122.42028959422501 | (37.7890281410374, -122.420289594225) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");