trees
6,344 rows where qSpecies_id = 19 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
382 | 34903 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
569 | 112652 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 3100X 26TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008747 | 2100981 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | 2 | 4 | 7 | 28859 | 19 | ||||
1118 | 36625 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
2140 | 46192 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
3365 | 46090 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 100 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2001 12:00:00 AM | Permit Number 44465 | 5989930.31260509 | 2114699.05014668 | 37.7859796419382 | -122.478619707642 | (37.7859796419382, -122.478619707642) | 11 | 6 | 2 | 55 | 26 | |||
3381 | 258768 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1511 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015807.577 | 2096620.6892 | 37.7378087983482 | -122.38782872013 | (37.7378087983482, -122.38782872013) | 10 | 3 | 8 | 58 | 1 | ||||
3497 | 46195 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
3531 | 39973 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
3892 | 39976 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
4013 | 264857 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
4058 | 34900 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
4332 | 30435 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3229 Barker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 88 | |||||||||||||
4883 | 264808 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 801x Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012291 | 2112706 | 37.7817800743931 | -122.401117244746 | (37.7817800743931, -122.401117244746) | 6 | 2 | 9 | 28856 | 34 | ||||
4900 | 263589 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012532 | 2112188 | 37.7803712075622 | -122.400247099708 | (37.7803712075622, -122.400247099708) | 6 | 2 | 9 | 28856 | 34 | |||
4959 | 47411 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2722 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45322 | |||||||||||||
4969 | 36620 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
5892 | 261243 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 840 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 5985843 | 2115056 | 37.786721565729 | -122.492786794237 | (37.786721565729, -122.492786794237) | 11 | 6 | 1 | 55 | 33 | ||||
6196 | 33080 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 221 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37335 | |||||||||||||
6342 | 264855 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
7141 | 264858 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
7649 | 39891 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41175 | 6005174.09555111 | 2114787.61295618 | 37.7870960726836 | -122.425886638993 | (37.7870960726836, -122.425886638993) | 13 | 9 | 11 | 28858 | 27 | |||
7727 | 259597 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 345 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6012481.99467 | 2112636.57875 | 37.7816001127017 | -122.400451610675 | (37.7816001127017, -122.400451610675) | 6 | 2 | 9 | 28856 | 34 | ||||
7798 | 52068 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 712 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2005 12:00:00 AM | Permit Number 48263 | 6002387.64911421 | 2104013.98805982 | 37.7573565030376 | -122.434756406645 | (37.7573565030376, -122.434756406645) | 2 | 4 | 5 | 28862 | 3 | |||
8081 | 39780 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 50 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41452 | 6006177.81610853 | 2102875.29261487 | 37.7544443606741 | -122.421567620452 | (37.7544443606741, -122.421567620452) | 2 | 4 | 5 | 28859 | 19 | ||
8091 | 84430 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3500 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50590 | 6006171.77574756 | 2102614.8499471 | 37.7537289046252 | -122.421570013482 | (37.7537289046252, -122.421570013482) | 2 | 4 | 5 | 28859 | 19 | ||
8285 | 36624 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
8825 | 36621 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
8963 | 36618 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
9853 | 46194 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
10060 | 262273 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2470 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | 6002133 | 2097220 | 37.738687356955 | -122.435151157914 | (37.738687356955, -122.435151157914) | 2 | 7 | 5 | 63 | 7 | ||||
10149 | 47738 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 765ST Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2002 12:00:00 AM | Permit Number 45522 | 6001007.50472324 | 2111284.16772448 | 37.7772401606319 | -122.440050778725 | (37.7772401606319, -122.440050778725) | 15 | 5 | 11 | 29492 | 41 | |||
10274 | 39974 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
10529 | 46191 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
10686 | 34901 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
10748 | 92022 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 230 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2009 12:00:00 AM | 3x3 | Permit Number 770960 | 6011866.1 | 2113060.9 | 37.7827308344341 | -122.402612173234 | (37.7827308344341, -122.402612173234) | 6 | 2 | 9 | 28853 | 34 | ||
11013 | 60619 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 209 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20243 | 6004834.14454804 | 2097168.79499693 | 37.7386997741774 | -122.425808230058 | (37.7386997741774, -122.425808230058) | 2 | 7 | 5 | 63 | 7 | ||
11247 | 264702 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 625 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3x3 | Permit Number 783216 | 6005628.43923 | 2105332.18724 | 37.761159426347 | -122.42364218242 | (37.761159426347, -122.42364218242) | 2 | 4 | 5 | 28859 | 19 | ||
11316 | 120672 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 3819 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004118 | 2105356 | 37.7611394347307 | -122.42886784279 | (37.7611394347307, -122.42886784279) | 2 | 4 | 5 | 28862 | 3 | ||||
11435 | 36622 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
11817 | 33081 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 221 Greenwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37335 | |||||||||||||
11841 | 34905 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
11883 | 259596 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 345 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6012481.99467 | 2112636.57875 | 37.7816001127017 | -122.400451610675 | (37.7816001127017, -122.400451610675) | 6 | 2 | 9 | 28856 | 34 | ||||
12228 | 34902 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
12660 | 255643 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1122 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6010085.7211 | 2110745.2484 | 37.7762730405804 | -122.408608151117 | (37.7762730405804, -122.408608151117) | 8 | 2 | 9 | 28853 | 34 | ||||
12922 | 262080 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 320 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 4x4 | 6012356.2542 | 2112686.81 | 37.7817310231605 | -122.4008901457 | (37.7817310231605, -122.4008901457) | 6 | 2 | 9 | 28856 | 34 | |||
13013 | 46193 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
13201 | 67714 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 599 02ND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1996 12:00:00 AM | Permit Number 31327 | 6014887 | 2112829 | 37.7822622831747 | -122.392144832206 | (37.7822622831747, -122.392144832206) | 6 | 2 | 9 | 28856 | 6 | ||
13384 | 39889 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41175 | 6005174.09555111 | 2114787.61295618 | 37.7870960726836 | -122.425886638993 | (37.7870960726836, -122.425886638993) | 13 | 9 | 11 | 28858 | 27 | |||
13392 | 112649 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 3100X 26TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008747 | 2100981 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | 2 | 4 | 7 | 28859 | 19 | ||||
13440 | 264856 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
13886 | 34906 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
14106 | 36623 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
14123 | 36635 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
14175 | 260509 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 436 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5995686 | 2095271 | 37.7329676771739 | -122.457300730651 | (37.7329676771739, -122.457300730651) | 9 | 7 | 4 | 59 | 40 | ||||
14816 | 45836 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 680 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2001 12:00:00 AM | Permit Number 44447 | 6012169.50994414 | 2114476.97613275 | 37.7866359833773 | -122.401662060279 | (37.7866359833773, -122.401662060279) | 12 | 2 | 9 | 28855 | 6 | |||
14834 | 263588 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012532 | 2112188 | 37.7803712075622 | -122.400247099708 | (37.7803712075622, -122.400247099708) | 6 | 2 | 9 | 28856 | 34 | ||||
14870 | 87142 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 54 Homestead St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50130 | 6000955 | 2101398 | 37.7500921913505 | -122.439523535984 | (37.7500921913505, -122.439523535984) | 2 | 4 | 5 | 28862 | 22 | |||
15230 | 84432 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3500 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50590 | 6006171.77574756 | 2102614.8499471 | 37.7537289046252 | -122.421570013482 | (37.7537289046252, -122.421570013482) | 2 | 4 | 5 | 28859 | 19 | ||
15275 | 36627 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
15299 | 96710 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2900 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2012 12:00:00 AM | Permit Number 767523 | 5987054 | 2098280 | 37.7407300421735 | -122.487364354837 | (37.7407300421735, -122.487364354837) | 1 | 8 | 3 | 29491 | 35 | |||
15484 | 36610 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
15685 | 65904 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1334 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1990 12:00:00 AM | Permit Number 28912 | 5993661.3773817 | 2106405.83948229 | 37.7634246223214 | -122.465108777096 | (37.7634246223214, -122.465108777096) | 1 | 8 | 11 | 56 | 12 | ||
16013 | 108100 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 2390X Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
16682 | 34784 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1245 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38420 | 6007703.93896299 | 2102409.74434789 | 37.7532520054251 | -122.416256906305 | (37.7532520054251, -122.416256906305) | 2 | 4 | 7 | 28859 | 19 | ||
16990 | 261324 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 434 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/09/2013 12:00:00 AM | 3x3 | Permit Number 767522 | 5993810 | 2090074 | 37.7185900537676 | -122.463409493673 | (37.7185900537676, -122.463409493673) | 9 | 8 | 6 | 64 | 24 | ||
17019 | 45465 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2901 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2001 12:00:00 AM | Permit Number 44246 | 6000256.9932138 | 2116755.78762604 | 37.7922210605835 | -122.44304007615 | (37.7922210605835, -122.44304007615) | 13 | 6 | 1 | 29490 | 27 | |||
17104 | 34766 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1051 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | Permit Number 38408 | 6008054.52837271 | 2101811.29200567 | 37.7516284982081 | -122.415002137966 | (37.7516284982081, -122.415002137966) | 2 | 4 | 7 | 28859 | 19 | |||
17317 | 264807 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 801x Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012291 | 2112706 | 37.7817800743931 | -122.401117244746 | (37.7817800743931, -122.401117244746) | 6 | 2 | 9 | 28856 | 34 | ||||
17350 | 34904 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
17701 | 46199 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
19128 | 36616 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
19157 | 46202 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
19413 | 33513 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 283 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37607 | 6006312.43871152 | 2098305.73442698 | 37.7419049842036 | -122.420777672299 | (37.7419049842036, -122.420777672299) | 2 | 7 | 7 | 28859 | 2 | |||
19622 | 264806 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 801x Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012291 | 2112706 | 37.7817800743931 | -122.401117244746 | (37.7817800743931, -122.401117244746) | 6 | 2 | 9 | 28856 | 34 | ||||
19738 | 60123 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 298 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19650 | 6004272.79376242 | 2096671.25180618 | 37.7373018951098 | -122.42771367587 | (37.7373018951098, -122.42771367587) | 2 | 7 | 5 | 63 | 7 | ||
19881 | 32358 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1660 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36912 | 6010095.76502785 | 2119756.50526668 | 37.8010163522878 | -122.409209439254 | (37.8010163522878, -122.409209439254) | 3 | 1 | 10 | 308 | 23 | |||
20234 | 110527 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1208 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000769 | 2109311 | 37.771808759149 | -122.440734269497 | (37.771808759149, -122.440734269497) | 15 | 5 | 11 | 29492 | 9 | ||||
20736 | 255581 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 101X San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006852 | 2105534 | 37.7617825477464 | -122.419424718408 | (37.7617825477464, -122.419424718408) | 2 | 4 | 7 | 28859 | 19 | ||||
21330 | 33784 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/1996 12:00:00 AM | Permit Number 37821 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |||
21701 | 113690 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1 WALTER U LUM PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010972 | 2117336 | 37.7944192831765 | -122.406006661324 | (37.7944192831765, -122.406006661324) | 3 | 1 | 10 | 28857 | 4 | ||||
21758 | 103918 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1300X Fitzgerald Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
21792 | 59832 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2080 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1990 12:00:00 AM | Permit Number 19285 | 5999268.33868417 | 2121186.40779193 | 37.8043299394007 | -122.446779769241 | (37.8043299394007, -122.446779769241) | 13 | 9 | 1 | 57 | 17 | ||
21933 | 40234 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3750 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1999 12:00:00 AM | Permit Number 41412 | 6005244.44626478 | 2096435.85175558 | 37.7367104548817 | -122.42433748337 | (37.7367104548817, -122.42433748337) | 2 | 7 | 5 | 28859 | 2 | |||
22320 | 114941 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 11x BELMONT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996611 | 2106266 | 37.7632103037359 | -122.454896938495 | (37.7632103037359, -122.454896938495) | 15 | 5 | 11 | 29492 | 12 | ||||
22326 | 46867 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1901 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44933 | 6009072.28883715 | 2119759.64832211 | 37.8009675906301 | -122.412751340025 | (37.8009675906301, -122.412751340025) | 3 | 1 | 10 | 308 | 32 | ||
22411 | 30461 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 443 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 110 | 6010832.04824719 | 2119620.20470279 | 37.8006833258058 | -122.406651960918 | (37.8006833258058, -122.406651960918) | 3 | 1 | 10 | 308 | 23 | |||
22575 | 46866 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1901 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44933 | 6009072.28883715 | 2119759.64832211 | 37.8009675906301 | -122.412751340025 | (37.8009675906301, -122.412751340025) | 3 | 1 | 10 | 308 | 32 | ||
23265 | 60591 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 611 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/1983 12:00:00 AM | Permit Number 20210 | 6000554.27615394 | 2111039.24067554 | 37.7765418411159 | -122.441601056307 | (37.7765418411159, -122.441601056307) | 15 | 5 | 11 | 29492 | 16 | ||
23848 | 114246 | Section 143 10 | Magnolia grandiflora :: Southern Magnolia 19 | 54 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996571 | 2114184 | 37.7849487713586 | -122.455607632252 | (37.7849487713586, -122.455607632252) | 11 | 6 | 1 | 54 | 31 | ||||
23862 | 102476 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 760 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
24030 | 848 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 109X POTRERO AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2006 12:00:00 AM | 3x3 | Permit Number 777000 | 6010279 | 2107809 | 37.7682216042911 | -122.407732456911 | (37.7682216042911, -122.407732456911) | 8 | 4 | 8 | 28853 | 19 | ||
24666 | 39008 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2736 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1998 12:00:00 AM | Permit Number 40765 | 6010046.67772728 | 2104584.33173286 | 37.7593543906434 | -122.408308568528 | (37.7593543906434, -122.408308568528) | 2 | 4 | 8 | 28859 | 19 | ||
24676 | 45236 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1334 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2001 12:00:00 AM | Permit Number 44061 | 5999545.87613757 | 2108180.03786548 | 37.7686336918072 | -122.444883810639 | (37.7686336918072, -122.444883810639) | 15 | 5 | 11 | 29492 | 9 | |||
24748 | 39884 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41175 | 6005174.09555111 | 2114787.61295618 | 37.7870960726836 | -122.425886638993 | (37.7870960726836, -122.425886638993) | 13 | 9 | 11 | 28858 | 27 | |||
25092 | 50848 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1636REVISED Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2004 12:00:00 AM | Permit Number 47364 | 6014694.26637327 | 2095422.25015862 | 37.7344563934175 | -122.391594241924 | (37.7344563934175, -122.391594241924) | 10 | 3 | 8 | 58 | 1 | |||
25106 | 54033 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 919 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1972 12:00:00 AM | 6x9 | Permit Number 9754 | 6004397.63865744 | 2103548.43352753 | 37.7561921088561 | -122.427771896657 | (37.7561921088561, -122.427771896657) | 2 | 4 | 5 | 28862 | 22 | ||
25237 | 49927 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 643 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | 3x3 | Permit Number 46685 | 6007938 | 2104185 | 37.7581396114352 | -122.415573152996 | (37.7581396114352, -122.415573152996) | 2 | 4 | 7 | 28859 | 19 | |
25601 | 104243 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 42 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998257.6 | 2108324 | 37.7689553686247 | -122.449350208019 | (37.7689553686247, -122.449350208019) | 15 | 5 | 11 | 29492 | 9 | ||||
25828 | 62033 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 201 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1987 12:00:00 AM | Permit Number 24376 | 6007708.69200618 | 2100343.23056264 | 37.7475780925299 | -122.416094129936 | (37.7475780925299, -122.416094129936) | 2 | 7 | 7 | 28859 | 2 | ||
25928 | 96470 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2001 Market St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 |
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) );