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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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) | ||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 68923 | 68923 | 123900 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 11th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 10ft | 5992382.46379 | 2114901.63457 | 37.7866779493995 | -122.470150767402 | (37.7866779493995, -122.470150767402) | |||
| 131610 | 131610 | 193291 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Ardath Ct | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017457.59567 | 2095286.9396900001 | 37.7342378548914 | -122.382030995952 | (37.7342378548914, -122.382030995952) | |||
| 158336 | 158336 | 193288 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017236.66649 | 2095426.16645 | 37.734607940290104 | -122.382804511829 | (37.7346079402901, -122.382804511829) | |||
| 171547 | 171547 | 193289 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Ardath Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017396.94192 | 2095313.3929599999 | 37.7343071404432 | -122.38224253716601 | (37.7343071404432, -122.382242537166) | |||
| 178805 | 178805 | 193290 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Ardath Ct | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017463.55131 | 2095291.12818 | 37.734249684563 | -122.38201069645099 | (37.734249684563, -122.382010696451) | |||
| 23962 | 23962 | 245061 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000833.6361 | 2109001.0122 | 37.7709612910265 | -122.44048845278 | (37.7709612910265, -122.44048845278) | |||
| 45889 | 45889 | 201340 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Bitting Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012714.10336 | 2092626.0861900002 | 37.7266685912663 | -122.39824424808901 | (37.7266685912663, -122.398244248089) | ||||
| 168141 | 168141 | 201342 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Bitting Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6012732.15495 | 2092620.2542299998 | 37.7266535833942 | -122.398181434938 | (37.7266535833942, -122.398181434938) | ||||
| 175355 | 175355 | 229657 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Bradford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009643.76186 | 2098683.06501 | 37.743128253176295 | -122.40928560886499 | (37.7431282531763, -122.409285608865) | |||
| 184615 | 184615 | 230854 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Castro St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002226.53145 | 2107879.97904 | 37.7679624253424 | -122.435590183343 | (37.7679624253424, -122.435590183343) | |||
| 56781 | 56781 | 230558 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004244.19102 | 2095797.65599 | 37.7349015806344 | -122.42775034252399 | (37.7349015806344, -122.427750342524) | |||
| 109757 | 109757 | 60992 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31624 | 6004216.5458966 | 2095763.6003461003 | 37.7348065076562 | -122.42784349558998 | (37.7348065076562, -122.42784349559) | ||
| 34346 | 34346 | 202086 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Gould St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6012832.48602 | 2091118.85258 | 37.722536627341796 | -122.39772932687299 | (37.7225366273418, -122.397729326873) | ||||
| 38534 | 38534 | 192961 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Missouri St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6013428.8993 | 2106971.39143 | 37.7660975461955 | -122.39677846284901 | (37.7660975461955, -122.396778462849) | |||
| 41355 | 41355 | 192962 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Missouri St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6013428.91312 | 2106990.27483 | 37.766149396595104 | -122.39677973902 | (37.7661493965951, -122.39677973902) | |||
| 157347 | 157347 | 192963 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Missouri St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6013426.6142 | 2107013.53276 | 37.7662131297585 | -122.396789321282 | (37.7662131297585, -122.396789321282) | |||
| 159740 | 159740 | 192960 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6013429.15967 | 2106956.37648 | 37.7660563329628 | -122.396776509533 | (37.7660563329628, -122.396776509533) | |||
| 182635 | 182635 | 192964 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Missouri St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6013426.74121 | 2107037.58883 | 37.7662791894618 | -122.396790568631 | (37.7662791894618, -122.396790568631) | |||
| 111483 | 111483 | 113691 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 WALTER U LUM PL | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010972.0 | 2117336.0 | 37.794419283176495 | -122.406006661324 | (37.7944192831765, -122.406006661324) | ||||
| 127146 | 127146 | 113690 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 WALTER U LUM PL | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010972.0 | 2117336.0 | 37.794419283176495 | -122.406006661324 | (37.7944192831765, -122.406006661324) | ||||
| 27985 | 27985 | 143502 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Walter U Lum Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6011053.9105 | 2117332.9615 | 37.7944155210534 | -122.405723025535 | (37.7944155210534, -122.405723025535) | |||
| 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) | ||||
| 62581 | 62581 | 177303 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 10 Ruth St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 6001666.9736 | 2091588.58341 | 37.7231983035377 | -122.436359529079 | (37.7231983035377, -122.436359529079) | |||
| 67374 | 67374 | 177304 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 10 Ruth St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 2ft | 6001647.41554 | 2091598.6912099998 | 37.723224945954 | -122.43642786046101 | (37.723224945954, -122.436427860461) | |||
| 36665 | 36665 | 193207 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 10 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014550.69631 | 2112820.9410200003 | 37.7822214767738 | -122.393307738057 | (37.7822214767738, -122.393307738057) | |||
| 52583 | 52583 | 193206 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 10 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014561.27051 | 2112829.17177 | 37.7822446640061 | -122.39327173191201 | (37.7822446640061, -122.393271731912) | |||
| 36657 | 36657 | 230266 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 10 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002981.00853 | 2095469.58645 | 37.73392923992321 | -122.43209418311199 | (37.7339292399232, -122.432094183112) | |||
| 93538 | 93538 | 65368 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 10 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1989 12:00:00 AM | Permit Number 28206 | 6003053.48376145 | 2095454.29402477 | 37.733891359152395 | -122.43184252277 | (37.7338913591524, -122.43184252277) | ||
| 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) | ||
| 89407 | 89407 | 46091 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 100 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2001 12:00:00 AM | Permit Number 44465 | 5989930.31260509 | 2114699.05014668 | 37.785979641938205 | -122.478619707642 | (37.7859796419382, -122.478619707642) | |||
| 123888 | 123888 | 46090 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 100 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2001 12:00:00 AM | Permit Number 44465 | 5989930.31260509 | 2114699.05014668 | 37.785979641938205 | -122.478619707642 | (37.7859796419382, -122.478619707642) | |||
| 56457 | 56457 | 140847 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 COMMONWEALTH AVE | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5996563.0036 | 2113772.191 | 37.7838175945574 | -122.455605521023 | (37.7838175945574, -122.455605521023) | |||
| 76435 | 76435 | 140846 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5996563.342 | 2113760.0078 | 37.783784162147704 | -122.455603469395 | (37.7837841621477, -122.455603469395) | |||
| 125984 | 125984 | 33498 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37606 | 6006683.58482984 | 2099106.89574168 | 37.74412570540729 | -122.419551194294 | (37.7441257054073, -122.419551194294) | |||
| 118336 | 118336 | 52505 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Delano Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48612 | 6000459.21212403 | 2092796.53249414 | 37.726446355434106 | -122.44062111517599 | (37.7264463554341, -122.440621115176) | ||
| 120191 | 120191 | 52504 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48612 | 6000459.21212403 | 2092796.53249414 | 37.726446355434106 | -122.44062111517599 | (37.7264463554341, -122.440621115176) | ||
| 138847 | 138847 | 52503 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48612 | 6000459.21212403 | 2092796.53249414 | 37.726446355434106 | -122.44062111517599 | (37.7264463554341, -122.440621115176) | ||
| 37119 | 37119 | 230739 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001694.43925 | 2105191.75415 | 37.760550982871706 | -122.43723812355199 | (37.7605509828717, -122.437238123552) | |||
| 75557 | 75557 | 230738 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001693.29132 | 2105215.82364 | 37.7606170065784 | -122.437243817162 | (37.7606170065784, -122.437243817162) | |||
| 150398 | 150398 | 208602 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Edgewood Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 4ft | 5996618.83287 | 2106426.3084 | 37.7636509189712 | -122.454881430853 | (37.7636509189712, -122.454881430853) | |||
| 37957 | 37957 | 230116 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Ellert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007159.83351 | 2097032.6620599998 | 37.738457135785296 | -122.41775743207701 | (37.7384571357853, -122.417757432077) | |||
| 95557 | 95557 | 12527 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5995151.97418 | 2114942.29811 | 37.7869493206202 | -122.460571940769 | (37.7869493206202, -122.460571940769) | |||
| 26135 | 26135 | 130570 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Maple St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996597.05315 | 2115854.8899 | 37.789538083068706 | -122.45563831375401 | (37.7895380830687, -122.455638313754) | |||
| 35620 | 35620 | 130566 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Maple St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996609.34051 | 2115762.66793 | 37.789285571419796 | -122.45558913254 | (37.7892855714198, -122.45558913254) | |||
| 50725 | 50725 | 130567 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Maple St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996608.23291 | 2115784.90382 | 37.7893465616436 | -122.455594572544 | (37.7893465616436, -122.455594572544) | |||
| 52182 | 52182 | 130568 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Maple St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5996607.55895 | 2115808.58588 | 37.7894115475449 | -122.45559861679199 | (37.7894115475449, -122.455598616792) | |||
| 75925 | 75925 | 130565 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Maple St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996612.8231 | 2115714.26414 | 37.789152867453396 | -122.455573583256 | (37.7891528674534, -122.455573583256) | |||
| 135380 | 135380 | 130571 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Maple St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996592.08363 | 2115880.31383 | 37.78960760516829 | -122.45565734611401 | (37.7896076051683, -122.455657346114) | |||
| 167700 | 167700 | 130569 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Maple St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996602.67631 | 2115833.52881 | 37.7894797539414 | -122.45561731370701 | (37.7894797539414, -122.455617313707) | |||
| 111402 | 111402 | 91383 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 100 SAN JOSE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006168.0 | 2102576.0 | 37.7536220187283 | -122.421580311855 | (37.7536220187283, -122.421580311855) | |||
| 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 | ||||||||
| 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 | ||||||||
| 41133 | 41133 | 230130 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006162.21511 | 2102529.99038 | 37.7534953607276 | -122.42159704978998 | (37.7534953607276, -122.42159704979) | |||
| 67045 | 67045 | 193107 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Thornton Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014292.7910400005 | 2094097.73703 | 37.7307972573678 | -122.392889649557 | (37.7307972573678, -122.392889649557) | |||
| 155233 | 155233 | 193108 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Thornton Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014279.85245 | 2094099.9138200001 | 37.7308025157065 | -122.392934532911 | (37.7308025157065, -122.392934532911) | |||
| 165073 | 165073 | 130905 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008670.58834 | 2116008.76921 | 37.7906460469339 | -122.41387591943199 | (37.7906460469339, -122.413875919432) | |||
| 430 | 430 | 103824 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006951.91038 | 2114418.6460599997 | 37.786183288961205 | -122.419709589538 | (37.7861832889612, -122.419709589538) | ||
| 5593 | 5593 | 103823 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006948.133219999 | 2114434.09135 | 37.7862254851663 | -122.419723753855 | (37.7862254851663, -122.419723753855) | ||
| 6648 | 6648 | 103825 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006956.54225 | 2114398.79268 | 37.786129037366294 | -122.41969215528 | (37.7861290373663, -122.41969215528) | ||
| 73635 | 73635 | 130882 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Polk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006947.79281 | 2114448.21135 | 37.7862642360477 | -122.419725933829 | (37.7862642360477, -122.419725933829) | |||
| 75772 | 75772 | 230011 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997298.06475 | 2106860.60293 | 37.7648823210859 | -122.452563536173 | (37.7648823210859, -122.452563536173) | |||
| 23342 | 23342 | 4711 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6008439.857000001 | 2120847.9647 | 37.8039203178058 | -122.41501690508801 | (37.8039203178058, -122.415016905088) | |||
| 49882 | 49882 | 229404 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009947.44128 | 2103311.08092 | 37.7558527725071 | -122.408561960379 | (37.7558527725071, -122.408561960379) | |||
| 154171 | 154171 | 229402 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009946.62507 | 2103338.81408 | 37.7559288758449 | -122.40856673937799 | (37.7559288758449, -122.408566739378) | |||
| 166081 | 166081 | 229403 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009946.56186 | 2103326.03812 | 37.7558937923786 | -122.408566056777 | (37.7558937923786, -122.408566056777) | |||
| 70207 | 70207 | 229597 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1001 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998810.79476 | 2106435.70161 | 37.7638022056215 | -122.44730082587601 | (37.7638022056215, -122.447300825876) | |||
| 80893 | 80893 | 46114 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2001 12:00:00 AM | Permit Number 44473 | 5998803.64501261 | 2106479.79215495 | 37.7639228586403 | -122.44732872816401 | (37.7639228586403, -122.447328728164) | |||
| 111463 | 111463 | 68477 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32346 | 6010253.77501878 | 2103382.5290377 | 37.756066104478 | -122.407507590908 | (37.756066104478, -122.407507590908) | ||
| 177091 | 177091 | 229344 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1001 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6010247.17323 | 2103327.9648599997 | 37.755915913899 | -122.40752657540001 | (37.755915913899, -122.4075265754) | |||
| 182836 | 182836 | 208733 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1001 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990828.95595 | 2102433.7995 | 37.752354718202604 | -122.474615201448 | (37.7523547182026, -122.474615201448) | |||
| 150161 | 150161 | 142882 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1001 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006903.448 | 2114407.3806 | 37.7861496266915 | -122.41987645727801 | (37.7861496266915, -122.419876457278) |
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");