Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 246 | 246 | 251253 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1350 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008544.9526 | 2110145.4696299997 | 37.774539777213995 | -122.413895673958 | (37.774539777214, -122.413895673958) | ||||
| 1337 | 1337 | 251410 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2777 Pine St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 779015 | 6000658.0 | 2114782.0 | 37.7868244087741 | -122.441510888069 | (37.7868244087741, -122.441510888069) | |||
| 1857 | 1857 | 251765 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | ||||
| 1870 | 1870 | 251767 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | ||||
| 1876 | 1876 | 251766 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | ||||
| 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 | |||||||||
| 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) | |||||
| 4034 | 4034 | 253599 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x9 | 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) | |||||
| 4864 | 4864 | 253698 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2200 Ofarrell St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Width 0ft | 6000775.0 | 2113124.0 | 37.7822786323031 | -122.440987106931 | (37.7822786323031, -122.440987106931) | ||||
| 4921 | 4921 | 253716 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2959 21st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5x15 | 5989962.0 | 2095532.0 | 37.733353897105495 | -122.477108940264 | (37.7333538971055, -122.477108940264) | ||||
| 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 | |||||||||
| 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 | |||||||||
| 7553 | 7553 | 142835 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1515 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Width 0ft | 6006663.5874 | 2116129.9342 | 37.7908658176323 | -122.42082865045799 | (37.7908658176323, -122.420828650458) | ||||
| 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) | |||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 18074 | 18074 | 112652 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | ||||
| 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) | |||||
| 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) | |||
| 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) | |||
| 20987 | 20987 | 92022 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 230 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2009 12:00:00 AM | 3x3 | Permit Number 770960 | 6011866.1 | 2113060.9 | 37.7827308344341 | -122.402612173234 | (37.7827308344341, -122.402612173234) | ||
| 47283 | 47283 | 39891 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1999 12:00:00 AM | Permit Number 41175 | 6005174.09555111 | 2114787.61295618 | 37.7870960726836 | -122.42588663899299 | (37.7870960726836, -122.425886638993) | |||
| 48565 | 48565 | 112649 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | ||||
| 49633 | 49633 | 84430 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3500 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50590 | 6006171.77574756 | 2102614.8499471 | 37.7537289046252 | -122.421570013482 | (37.7537289046252, -122.421570013482) | ||
| 51264 | 51264 | 60619 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 209 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20243 | 6004834.14454804 | 2097168.79499693 | 37.7386997741774 | -122.425808230058 | (37.7386997741774, -122.425808230058) | ||
| 51520 | 51520 | 65904 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1334 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | Permit Number 28912 | 5993661.3773817 | 2106405.83948229 | 37.7634246223214 | -122.465108777096 | (37.7634246223214, -122.465108777096) | ||
| 54135 | 54135 | 39780 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 50 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41452 | 6006177.81610853 | 2102875.29261487 | 37.7544443606741 | -122.42156762045201 | (37.7544443606741, -122.421567620452) | ||
| 55721 | 55721 | 34784 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1245 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38420 | 6007703.93896299 | 2102409.74434789 | 37.753252005425104 | -122.41625690630501 | (37.7532520054251, -122.416256906305) | ||
| 65295 | 65295 | 67714 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 599 02ND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | Permit Number 31327 | 6014887.0 | 2112829.0 | 37.7822622831747 | -122.392144832206 | (37.7822622831747, -122.392144832206) | ||
| 65720 | 65720 | 120672 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3819 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004118.0 | 2105356.0 | 37.7611394347307 | -122.42886784279 | (37.7611394347307, -122.42886784279) | ||||
| 66029 | 66029 | 34766 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1051 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | Permit Number 38408 | 6008054.52837271 | 2101811.29200567 | 37.751628498208106 | -122.415002137966 | (37.7516284982081, -122.415002137966) | |||
| 67567 | 67567 | 45465 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2901 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2001 12:00:00 AM | Permit Number 44246 | 6000256.9932138 | 2116755.78762604 | 37.7922210605835 | -122.44304007615 | (37.7922210605835, -122.44304007615) | |||
| 76013 | 76013 | 97279 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 194@ Lake St 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2011 12:00:00 AM | Permit Number 768130 | 5987198.3 | 2114675.7 | 37.785756529848705 | -122.488069885717 | (37.7857565298487, -122.488069885717) | |||
| 76345 | 76345 | 30327 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 414 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/1956 12:00:00 AM | Permit Number 18 | 6013759.67199369 | 2105160.54223846 | 37.761143757186204 | -122.395507498425 | (37.7611437571862, -122.395507498425) | |||
| 77418 | 77418 | 114246 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 54 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996571.0 | 2114184.0 | 37.7849487713586 | -122.45560763225201 | (37.7849487713586, -122.455607632252) | ||||
| 77578 | 77578 | 848 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 109X POTRERO AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2006 12:00:00 AM | 3x3 | Permit Number 777000 | 6010279.0 | 2107809.0 | 37.7682216042911 | -122.40773245691099 | (37.7682216042911, -122.407732456911) | ||
| 77619 | 77619 | 30430 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 418 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | Permit Number 83 | 6010919.16231667 | 2119684.73214888 | 37.8008653758927 | -122.40635505796301 | (37.8008653758927, -122.406355057963) | |||
| 77684 | 77684 | 104322 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 90X Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002383.0 | 2106795.0 | 37.7649922243231 | -122.434971372236 | (37.7649922243231, -122.434971372236) | ||||
| 77794 | 77794 | 67555 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1324 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | Permit Number 31104 | 6001511.87530009 | 2110460.33363228 | 37.77500681950411 | -122.43824696987801 | (37.7750068195041, -122.438246969878) | ||
| 77797 | 77797 | 116382 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2501 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | DPW for City Agency 2 | 3x3 | 6011435.88896489 | 2101815.42613948 | 37.7518292809831 | -122.403309184671 | (37.7518292809831, -122.403309184671) | |||
| 77924 | 77924 | 46894 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1445 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2006 12:00:00 AM | Permit Number 44949 | 5992707.32410369 | 2105628.35090548 | 37.7612347828689 | -122.468351943903 | (37.7612347828689, -122.468351943903) | ||
| 77955 | 77955 | 104243 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 42 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998257.6 | 2108324.0 | 37.7689553686247 | -122.44935020801901 | (37.7689553686247, -122.449350208019) | ||||
| 78016 | 78016 | 34755 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 930 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/2010 12:00:00 AM | 3x3 | 6007964.37275398 | 2102502.67346206 | 37.7535218086 | -122.415362848727 | (37.7535218086, -122.415362848727) | ||
| 78067 | 78067 | 39884 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1999 12:00:00 AM | Permit Number 41175 | 6005174.09555111 | 2114787.61295618 | 37.7870960726836 | -122.42588663899299 | (37.7870960726836, -122.425886638993) | |||
| 78220 | 78220 | 34235 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1997 12:00:00 AM | Permit Number 38048 | 6016895.91787464 | 2103845.69851644 | 37.757707418448895 | -122.38456887610201 | (37.7577074184489, -122.384568876102) | ||||
| 78484 | 78484 | 38386 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1516 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/2004 12:00:00 AM | Permit Number 40445 | 5999708.4478050005 | 2107273.92637961 | 37.766155013685896 | -122.444256367831 | (37.7661550136859, -122.444256367831) | ||
| 78544 | 78544 | 104874 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 890X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769944 | 6007654.60199 | 2097738.03982 | 37.7404217779739 | -122.416096698799 | (37.7404217779739, -122.416096698799) | |||
| 78594 | 78594 | 102827 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2001X Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997438.0 | 2109144.0 | 37.77115996155629 | -122.45224431217899 | (37.7711599615563, -122.452244312179) | ||||
| 78650 | 78650 | 65241 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1055 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50990 | 6009207.81332518 | 2103021.34341787 | 37.7550157681098 | -122.41109937921699 | (37.7550157681098, -122.411099379217) | ||
| 78806 | 78806 | 101317 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 273 Magellan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | |||||
| 78835 | 78835 | 39893 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1999 12:00:00 AM | Permit Number 41175 | 6005174.09555111 | 2114787.61295618 | 37.7870960726836 | -122.42588663899299 | (37.7870960726836, -122.425886638993) | |||
| 78880 | 78880 | 68717 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3906 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | Permit Number 32633 | 6002903.511036 | 2105942.15376651 | 37.7626800559393 | -122.433110116369 | (37.7626800559393, -122.433110116369) | ||
| 78998 | 78998 | 34287 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2700 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | Permit Number 47000 | 5987152.40290337 | 2114633.58792494 | 37.7856382245586 | -122.48822557883699 | (37.7856382245586, -122.488225578837) | ||
| 79100 | 79100 | 101874 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 952 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2012 12:00:00 AM | Permit Number 769482 | 6009937.0 | 2103656.0 | 37.7567992582457 | -122.408622400801 | (37.7567992582457, -122.408622400801) | |||
| 79220 | 79220 | 86712 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3806 22nd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2007 12:00:00 AM | Permit Number 49698 | 6003066.0 | 2103019.0 | 37.7546629917484 | -122.43233934232599 | (37.7546629917484, -122.432339342326) | ||||
| 79316 | 79316 | 50408 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 98 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47060 | 6000474.19064274 | 2092822.35654564 | 37.7265181152989 | -122.44057118662799 | (37.7265181152989, -122.440571186628) | ||
| 79388 | 79388 | 39786 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 50 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41452 | 6006177.81610853 | 2102875.29261487 | 37.7544443606741 | -122.42156762045201 | (37.7544443606741, -122.421567620452) | ||
| 79411 | 79411 | 60754 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1326 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/1983 12:00:00 AM | Permit Number 20420 | 6009245.12435038 | 2101426.54577047 | 37.7506389030081 | -122.410857717488 | (37.7506389030081, -122.410857717488) | ||
| 79485 | 79485 | 53663 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1347 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1995 12:00:00 AM | Permit Number 18593 | 6006742.77162231 | 2115546.43032117 | 37.789268123315 | -122.42051323923599 | (37.789268123315, -122.420513239236) | ||
| 79499 | 79499 | 104245 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 42 Belvedere St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2013 12:00:00 AM | 3x3 | Permit Number 769673 | 5998257.6 | 2108324.0 | 37.7689553686247 | -122.44935020801901 | (37.7689553686247, -122.449350208019) | ||
| 79519 | 79519 | 116593 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 830x PIERCE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6002569.0 | 2111577.0 | 37.778132974581 | -122.434670017402 | (37.778132974581, -122.434670017402) | |||
| 79590 | 79590 | 40232 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3750 Mission St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1999 12:00:00 AM | Permit Number 41412 | 6005244.44626478 | 2096435.85175558 | 37.7367104548817 | -122.42433748337 | (37.7367104548817, -122.42433748337) | |||
| 79650 | 79650 | 107185 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 10 Florence St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 773363 | 6008515.42073 | 2118375.20615 | 37.7971349853662 | -122.41458032272 | (37.7971349853662, -122.41458032272) | ||||
| 79743 | 79743 | 47710 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 35 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45505 | 6002613.96578563 | 2096324.44810828 | 37.7362556776497 | -122.433424228715 | (37.7362556776497, -122.433424228715) | ||
| 79764 | 79764 | 45832 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 680 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2001 12:00:00 AM | Permit Number 44447 | 6012169.50994414 | 2114476.97613275 | 37.786635983377295 | -122.40166206027901 | (37.7866359833773, -122.401662060279) | |||
| 79768 | 79768 | 39566 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 340 Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40986 | 6011428.39903317 | 2106785.87476625 | 37.7654766104888 | -122.40368478038299 | (37.7654766104888, -122.403684780383) | |||
| 79868 | 79868 | 56034 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 519 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1996 12:00:00 AM | Permit Number 12120 | 6003657.78686602 | 2105252.79680615 | 37.7608300044343 | -122.430452158183 | (37.7608300044343, -122.430452158183) | ||
| 79969 | 79969 | 30319 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 867 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/1955 12:00:00 AM | Permit Number 14 | 5988182.28713273 | 2110079.61323567 | 37.773194323540004 | -122.484328404455 | (37.77319432354, -122.484328404455) | |||
| 80036 | 80036 | 48652 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 439 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45945 | 5992980.71663157 | 2103877.73673829 | 37.756443840271295 | -122.46727910948299 | (37.7564438402713, -122.467279109483) | ||
| 80103 | 80103 | 33103 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2869 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37344 | 6000019.36553323 | 2118377.7802106002 | 37.7966610726075 | -122.44397886276501 | (37.7966610726075, -122.443978862765) | ||
| 80224 | 80224 | 60611 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 62 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20235 | 6004863.65784783 | 2097891.67649788 | 37.740686310723206 | -122.425757625585 | (37.7406863107232, -122.425757625585) |
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");