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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 13312 | 13312 | 20032 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 100 STAIRWAY51 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3ST | ||||||||
| 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 | |||||||||
| 15835 | 15835 | 19850 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 100 STAIRWAY27 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 10ST | ||||||||
| 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 | |||||||||
| 162594 | 162594 | 119125 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 601 46th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5981604.24423 | 2111607.23903 | 37.777003516584294 | -122.507195675426 | (37.7770035165843, -122.507195675426) | |||
| 111496 | 111496 | 108667 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 743 45th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773175 | 5981956.75596 | 2110691.0447299997 | 37.7745086716833 | -122.50590830698098 | (37.7745086716833, -122.505908306981) | |
| 42291 | 42291 | 68569 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 859 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 6 | Permit Number 32459 | 5981982.26484 | 2109895.99725 | 37.77232720481071 | -122.50576111622 | (37.7723272048107, -122.50576111622) | |
| 42105 | 42105 | 118703 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 4237 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5982406.56675 | 2110976.40955 | 37.775318666131604 | -122.504373495781 | (37.7753186661316, -122.504373495781) | |||
| 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) | |
| 185114 | 185114 | 47434 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 610 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 3 | Permit Number 45345 | 5982901.04749 | 2111608.7377400002 | 37.777083925934896 | -122.50270981678999 | (37.7770839259349, -122.50270981679) | |
| 116096 | 116096 | 47436 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 674 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45347 | 5982919.26774055 | 2111199.0450077 | 37.7759600998145 | -122.502616456458 | (37.7759600998145, -122.502616456458) | ||
| 39505 | 39505 | 183642 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1490 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982814.3712 | 2105004.9294 | 37.7589466720393 | -122.50252075916599 | (37.7589466720393, -122.502520759166) | |||
| 139065 | 139065 | 87822 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2274 44th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50715 | 5982710.3 | 2099649.4 | 37.744235769489 | -122.502484303694 | (37.744235769489, -122.502484303694) | |||
| 120572 | 120572 | 113234 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2023 43RD AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 3x3 | 5982877.0 | 2101339.0 | 37.748884737458795 | -122.50203289923901 | (37.7488847374588, -122.502032899239) | |||
| 65948 | 65948 | 183683 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 4109 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982989.6121 | 2106254.8366 | 37.7623888588818 | -122.50200719073 | (37.7623888588818, -122.50200719073) | |||
| 56119 | 56119 | 183261 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1231 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983023.9383 | 2106705.6545 | 37.7636286930826 | -122.501921829451 | (37.7636286930826, -122.501921829451) | |||
| 183035 | 183035 | 63002 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1247 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1986 12:00:00 AM | 2 | Permit Number 23410 | 5983025.6110000005 | 2106604.4545 | 37.763350924952505 | -122.501908555809 | (37.7633509249525, -122.501908555809) | ||
| 148383 | 148383 | 117923 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 655 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5983173.6456 | 2111340.41093 | 37.7763631945421 | -122.50174697284099 | (37.7763631945421, -122.501746972841) | |||
| 129204 | 129204 | 109172 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 663 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773586 | 5983176.95596 | 2111290.88937 | 37.7762274171819 | -122.501731856866 | (37.7762274171819, -122.501731856866) |
| 63121 | 63121 | 183308 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1278 42nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5983073.9761 | 2106448.9537 | 37.762926804993796 | -122.50172977407401 | (37.7629268049938, -122.501729774074) | |||
| 99300 | 99300 | 109190 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 667 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773585 | 5983177.971390001 | 2111266.917 | 37.7761616556669 | -122.50172657027599 | (37.7761616556669, -122.501726570276) |
| 30327 | 30327 | 183307 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1278 42nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5983074.8909 | 2106436.1459 | 37.7628916921497 | -122.501725662519 | (37.7628916921497, -122.501725662519) | |||
| 150834 | 150834 | 46377 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2247 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2005 12:00:00 AM | 2 | Permit Number 44614 | 5982946.355 | 2099827.607 | 37.744738944686205 | -122.501681271429 | (37.7447389446862, -122.501681271429) | |
| 132826 | 132826 | 117829 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 886 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5983896.9414800005 | 2109796.46595 | 37.7721664253666 | -122.499130822703 | (37.7721664253666, -122.499130822703) | |||
| 168124 | 168124 | 71995 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 400 38th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1986 12:00:00 AM | 3 | 5984088.02561 | 2113084.3081799997 | 37.7812050975324 | -122.498712783587 | (37.7812050975324, -122.498712783587) | ||
| 35058 | 35058 | 34812 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 400 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 3 | Permit Number 38704 | 5984089.4315 | 2113048.43592 | 37.7811066852081 | -122.498705269197 | (37.7811066852081, -122.498705269197) | |
| 130741 | 130741 | 118036 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 470 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5984100.05848 | 2112686.8237099997 | 37.7801144265426 | -122.49864178525499 | (37.7801144265426, -122.498641785255) | |||
| 149836 | 149836 | 182922 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2909 Yorba St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983962.6687 | 2096093.6404 | 37.7345461275096 | -122.497891434487 | (37.7345461275096, -122.497891434487) | |||
| 57609 | 57609 | 118082 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 7300 Geary Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5984332.1669 | 2112501.37067 | 37.7796188361138 | -122.49782513132799 | (37.7796188361138, -122.497825131328) | |||
| 138979 | 138979 | 63216 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 499 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | Permit Number 33571 | 5984372.470711 | 2112463.62545386 | 37.7795175613562 | -122.497682917511 | (37.7795175613562, -122.497682917511) | ||
| 133429 | 133429 | 51905 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1438 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | 2 | Permit Number 48112 | 5984354.7331 | 2105363.9479 | 37.760022829898 | -122.49722004913001 | (37.760022829898, -122.49722004913) | ||
| 131659 | 131659 | 50251 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1590 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 3 | Permit Number 48647 | 5984388.5406 | 2104356.2375 | 37.757257919888204 | -122.497028745879 | (37.7572579198882, -122.497028745879) | |
| 44499 | 44499 | 184563 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1714 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984417.5527 | 2103483.9989 | 37.7548646952585 | -122.496864038241 | (37.7548646952585, -122.496864038241) | |||
| 107107 | 107107 | 115168 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2550 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775038 | 5984326.9 | 2097810.6 | 37.7392817833273 | -122.49675885631099 | (37.7392817833273, -122.496758856311) | |||
| 161207 | 161207 | 69030 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1451 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/04/2001 12:00:00 AM | 2 | Permit Number 33036 | 5984623.8069 | 2105296.0559 | 37.759852183084604 | -122.496284456968 | (37.7598521830846, -122.496284456968) | |
| 157278 | 157278 | 183148 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2331 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984516.3306 | 2099293.7848 | 37.743365304708206 | -122.496213301366 | (37.7433653047082, -122.496213301366) | |||
| 178202 | 178202 | 73361 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Huntington Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1995 12:00:00 AM | 6 | 5984617.0399400005 | 2094708.0142400002 | 37.730779908566 | -122.49552692473301 | (37.730779908566, -122.495526924733) | ||
| 187131 | 187131 | 73537 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Huntington Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1995 12:00:00 AM | 5 | 5984627.56608 | 2094712.4640000002 | 37.7307927427943 | -122.495490862808 | (37.7307927427943, -122.495490862808) | ||
| 178068 | 178068 | 78301 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 631 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 6 | 5985028.236930001 | 2111540.9016299997 | 37.7770224459764 | -122.495346307534 | (37.7770224459764, -122.495346307534) | ||
| 181521 | 181521 | 69802 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 627 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 5 | 5985028.72707 | 2111563.88652 | 37.7770855845831 | -122.495346307533 | (37.7770855845831, -122.495346307533) | ||
| 51123 | 51123 | 20886 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1892X Sunset Blvd | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
| 139794 | 139794 | 20885 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1892X Sunset Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
| 143188 | 143188 | 20883 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1892X Sunset Blvd | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
| 38022 | 38022 | 118204 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 634 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985074.67436 | 2111534.8563900003 | 37.7770085663204 | -122.49518522253099 | (37.7770085663204, -122.495185222531) | |||
| 106892 | 106892 | 20930 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1992X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984875.945426799 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | |||
| 118832 | 118832 | 20931 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1992X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984875.945426799 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | |||
| 119078 | 119078 | 20928 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1992X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984875.945426799 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | |||
| 51270 | 51270 | 181711 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3403 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985126.2438 | 2107009.2181 | 37.7645854668325 | -122.49467310158701 | (37.7645854668325, -122.494673101587) | |||
| 89677 | 89677 | 21204 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2392X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 98238 | 98238 | 21201 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2392X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 110019 | 110019 | 21202 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2392X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 176792 | 176792 | 50241 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1231 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 3 | Permit Number 46947 | 5985192.563999999 | 2106818.2406 | 37.7640649777407 | -122.49442964224 | (37.7640649777407, -122.49442964224) | |
| 31663 | 31663 | 50242 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1231 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 3 | Permit Number 46947 | 5985193.177999999 | 2106799.8183 | 37.7640144312015 | -122.49442616053499 | (37.7640144312015, -122.494426160535) | |
| 60256 | 60256 | 92539 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1351 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52884 | 5985220.6535 | 2106008.9529 | 37.7618445439072 | -122.494272834312 | (37.7618445439072, -122.494272834312) | |
| 164712 | 164712 | 50243 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1242 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 6 | Permit Number 46948 | 5985238.0051 | 2106741.9575 | 37.7638581850069 | -122.49426685395399 | (37.7638581850069, -122.494266853954) | |
| 153172 | 153172 | 50245 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1282 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 2 | Permit Number 46950 | 5985245.6795 | 2106487.522 | 37.7631600254306 | -122.494221555939 | (37.7631600254306, -122.494221555939) | |
| 159607 | 159607 | 69448 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 427 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 11 | Permit Number 33558 | 5985596.8732 | 2112995.80013 | 37.7810504575356 | -122.493486469695 | (37.7810504575356, -122.493486469695) | |
| 53084 | 53084 | 43852 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2708 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51148 | 5985261.6386 | 2096783.5367 | 37.736516466659204 | -122.49345134135 | (37.7365164666592, -122.49345134135) | |
| 62647 | 62647 | 69462 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3199 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 8 | Permit Number 33574 | 5985666.41969 | 2113176.66549 | 37.78155112970239 | -122.49325920583401 | (37.7815511297024, -122.493259205834) | |
| 63635 | 63635 | 250692 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 850 El Camino Del Mar | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5985754.9302 | 2115039.63583 | 37.7866714841451 | -122.49309028449801 | (37.7866714841451, -122.493090284498) | |||
| 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) | |||||
| 56642 | 56642 | 250691 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 850 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5985780.23123 | 2115050.10184 | 37.786701700454394 | -122.49300352150401 | (37.7867017004544, -122.493003521504) | |||
| 37949 | 37949 | 49461 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1519@ KIRKHAM 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2003 12:00:00 AM | 4 | Permit Number 46391 | 5985568.6393 | 2104859.6745 | 37.758709302234 | -122.49298464569401 | (37.758709302234, -122.492984645694) | ||
| 159556 | 159556 | 250690 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 850 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 5985788.39353 | 2115054.1604299997 | 37.786713321507705 | -122.492975581372 | (37.7867133215077, -122.492975581372) | |||
| 73155 | 73155 | 182433 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1551 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5985573.1425 | 2104667.8354 | 37.7581828284958 | -122.49295494088601 | (37.7581828284958, -122.492954940886) | |||
| 160572 | 160572 | 55802 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2379 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51126 | 5985455.6616 | 2099044.0741 | 37.7427346444375 | -122.49294699219999 | (37.7427346444375, -122.4929469922) | |
| 76081 | 76081 | 182434 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1551 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5985575.3942 | 2104648.4714 | 37.7581297919874 | -122.492945727305 | (37.7581297919874, -122.492945727305) | |||
| 151080 | 151080 | 33160 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2447 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 3 | Permit Number 37383 | 5985473.2595 | 2098547.6093 | 37.7413725147529 | -122.492849584664 | (37.7413725147529, -122.492849584664) |
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");