Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 107907 | 107907 | 88241 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2501 Turk Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51228 | 5998431.6 | 2111697.4 | 37.778227810594295 | -122.44899139417299 | (37.7782278105943, -122.448991394173) | ||
| 108136 | 108136 | 112556 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 35 DOLORES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2015 12:00:00 AM | 3x3 | 6004913.0 | 2108042.0 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | |||
| 108377 | 108377 | 89188 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 108546 | 108546 | 41047 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1394 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53732 | 5999600.05829403 | 2107789.40004447 | 37.767564190631106 | -122.444668318417 | (37.7675641906311, -122.444668318417) | |
| 108560 | 108560 | 86950 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1610 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2007 12:00:00 AM | 3x3 | Permit Number 49916 | 6000149.0 | 2110263.0 | 37.7743873828756 | -122.442947262018 | (37.7743873828756, -122.442947262018) | ||
| 108616 | 108616 | 95787 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3234 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767531 | 6008132.0 | 2101545.0 | 37.750901673491995 | -122.41471538692801 | (37.750901673492, -122.414715386928) | |
| 108868 | 108868 | 80286 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 280 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50470 | 6004535.68280027 | 2096559.61306431 | 37.73701022767111 | -122.42679679858699 | (37.7370102276711, -122.426796798587) | ||
| 109397 | 109397 | 112555 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 35 DOLORES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2015 12:00:00 AM | 3x3 | 6004913.0 | 2108042.0 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | |||
| 109413 | 109413 | 92603 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Baker St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814.0 | 2116396.0 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | ||
| 109870 | 109870 | 99290 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.38992452193199 | (37.753957014382, -122.389924521932) | ||
| 110088 | 110088 | 114688 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 231 Dwight St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 774702 | 6010865.8 | 2091429.3 | 37.723279336417704 | -122.404549596707 | (37.7232793364177, -122.404549596707) | |||
| 110111 | 110111 | 107776 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4115 26TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003143.1 | 2100622.5 | 37.7480871393693 | -122.431901599648 | (37.7480871393693, -122.431901599648) | |||||
| 110286 | 110286 | 88514 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 640 Faxon Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51446 | 5994921.4 | 2092497.3 | 37.7253078255283 | -122.459743296133 | (37.7253078255283, -122.459743296133) | |||
| 110433 | 110433 | 99294 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300 Minnesota St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.38992452193199 | (37.753957014382, -122.389924521932) | ||
| 110507 | 110507 | 87911 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 101 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50936 | 6007398.0 | 2097753.0 | 37.7404484242714 | -122.41698498961 | (37.7404484242714, -122.41698498961) | ||
| 110527 | 110527 | 96067 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 981 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767692 | 6008020.0 | 2102218.0 | 37.7527432860874 | -122.415150327914 | (37.7527432860874, -122.415150327914) | |
| 110669 | 110669 | 89185 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 110741 | 110741 | 121601 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201x San Carlos St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006718.0 | 2104916.0 | 37.7600781154964 | -122.419844317752 | (37.7600781154964, -122.419844317752) | ||||
| 110911 | 110911 | 52432 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1890 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51617 | 6004399.67181712 | 2115311.0350232 | 37.7884894628626 | -122.42860329951401 | (37.7884894628626, -122.428603299514) | ||
| 110943 | 110943 | 88424 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1465 Washington St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51388 | 6007689.0 | 2117147.0 | 37.7937161726159 | -122.417352866644 | (37.7937161726159, -122.417352866644) | |||
| 110966 | 110966 | 87903 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 223 Bocana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50920 | 6007150.2 | 2097674.7 | 37.7402194874954 | -122.41783623809401 | (37.7402194874954, -122.417836238094) | ||
| 110968 | 110968 | 87269 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4109 Irving St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2008 12:00:00 AM | 3x3 | Permit Number 50292 | 5983031.0 | 2106268.0 | 37.762427433139294 | -122.50186502168002 | (37.7624274331393, -122.50186502168) | |||
| 111039 | 111039 | 106843 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1869 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2014 12:00:00 AM | Permit Number 773317 | 6004088.44172 | 2118602.99638 | 37.7975107321666 | -122.429915018594 | (37.7975107321666, -122.429915018594) | |||
| 111675 | 111675 | 81067 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1283 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50902 | 5992359.24137134 | 2106729.49777919 | 37.7642381302347 | -122.46963596784799 | (37.7642381302347, -122.469635967848) | ||
| 112316 | 112316 | 88332 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 659 Madrid St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51320 | 6002140.0 | 2090092.0 | 37.7191158866353 | -122.434617409737 | (37.7191158866353, -122.434617409737) | |||
| 112511 | 112511 | 121599 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201x San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006718.0 | 2104916.0 | 37.7600781154964 | -122.419844317752 | (37.7600781154964, -122.419844317752) | ||||
| 113114 | 113114 | 92604 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Baker St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814.0 | 2116396.0 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | ||
| 113248 | 113248 | 112574 | Section 143 8 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 56 ROCKWOOD CT | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x6 | Permit Number 776002 | 5995685.0 | 2098946.0 | 37.7430582687021 | -122.457569991387 | (37.7430582687021, -122.457569991387) | ||
| 113354 | 113354 | 87851 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 97 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2013 12:00:00 AM | 3x3 | Permit Number 779093 | 6007313.0 | 2098782.0 | 37.7432690474632 | -122.41735179051201 | (37.7432690474632, -122.417351790512) | ||
| 115103 | 115103 | 89172 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 115603 | 115603 | 121600 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201x San Carlos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006718.0 | 2104916.0 | 37.7600781154964 | -122.419844317752 | (37.7600781154964, -122.419844317752) | ||||
| 116900 | 116900 | 104140 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2301X Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/2013 12:00:00 AM | 3x3 | Permit Number 770728 | 6001711.91514 | 2118723.596 | 37.797706995714606 | -122.438147056882 | (37.7977069957146, -122.438147056882) | ||
| 116964 | 116964 | 89192 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2008 12:00:00 AM | 3x3 | Permit Number 51807 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||
| 117208 | 117208 | 104139 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2301X Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/2013 12:00:00 AM | 3x3 | Permit Number 770728 | 6001711.91514 | 2118723.596 | 37.797706995714606 | -122.438147056882 | (37.7977069957146, -122.438147056882) | ||
| 117699 | 117699 | 117276 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3431 19TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 6006713.0 | 2104938.0 | 37.760138240698794 | -122.41986317152201 | (37.7601382406988, -122.419863171522) | ||||
| 118087 | 118087 | 89184 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 118980 | 118980 | 113661 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3060 JACKSON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 5x5 | Permit Number 776720 | 5999534.0 | 2116404.0 | 37.7912138957856 | -122.44551632933901 | (37.7912138957856, -122.445516329339) | ||
| 119879 | 119879 | 94144 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1670 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53556 | 5992831.3 | 2104104.9 | 37.757058944886396 | -122.467812361688 | (37.7570589448864, -122.467812361688) | ||
| 120151 | 120151 | 88327 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51315 | 6001911.0 | 2090236.0 | 37.7194982755804 | -122.43541926902701 | (37.7194982755804, -122.435419269027) | ||
| 120377 | 120377 | 114754 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 83 Karen Ct | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | Permit Number 777134 | 6010271.6 | 2091687.4 | 37.723954799188704 | -122.406621822462 | (37.7239547991887, -122.406621822462) | ||||
| 120756 | 120756 | 109759 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3590 20TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006354.0 | 2104372.0 | 37.75856390529879 | -122.421064595152 | (37.7585639052988, -122.421064595152) | ||
| 120967 | 120967 | 87787 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 114 Theresa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.43466954464199 | (37.7289708079503, -122.434669544642) | |||
| 121132 | 121132 | 87786 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 114 Theresa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.43466954464199 | (37.7289708079503, -122.434669544642) | |||
| 121384 | 121384 | 95582 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1352 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767370 | 6002514.0 | 2101648.0 | 37.7508672366014 | -122.434150301439 | (37.7508672366014, -122.434150301439) | |
| 121536 | 121536 | 89171 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 122431 | 122431 | 89187 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 122771 | 122771 | 46568 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3900 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51812 | 6002455.82917315 | 2102994.91492425 | 37.754562242839704 | -122.43444775294701 | (37.7545622428397, -122.434447752947) | ||
| 122922 | 122922 | 55172 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3599X 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2013 12:00:00 AM | Permit Number 11079 | 6002961.15352471 | 2106486.99776749 | 37.7641793352608 | -122.432949678981 | (37.7641793352608, -122.432949678981) | |||
| 123276 | 123276 | 113270 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1570 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 773602 | 6015432.5 | 2094545.1 | 37.732088865659705 | -122.38898068227199 | (37.7320888656597, -122.388980682272) | |||
| 123330 | 123330 | 84225 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1361 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50686 | 6011917.47723073 | 2088615.29524593 | 37.7156113688947 | -122.400716532679 | (37.7156113688947, -122.400716532679) | ||
| 123609 | 123609 | 89169 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 123675 | 123675 | 113269 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1328 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 774425 | 6016744.9 | 2093624.7 | 37.7296342890732 | -122.384379303046 | (37.7296342890732, -122.384379303046) | |||
| 123890 | 123890 | 89193 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | |||||
| 124094 | 124094 | 92602 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Baker St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814.0 | 2116396.0 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | ||
| 124483 | 124483 | 37803 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 465 Woolsey St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010402.90992445 | 2091781.87036726 | 37.7242215408534 | -122.406174555323 | (37.7242215408534, -122.406174555323) | ||
| 124910 | 124910 | 93624 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 149 Collins St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | Permit Number 53164 | 5998064.0 | 2113562.0 | 37.783326485193 | -122.450397500912 | (37.783326485193, -122.450397500912) | |||
| 124961 | 124961 | 88312 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 518 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51303 | 6003514.0 | 2090320.0 | 37.7198198301278 | -122.42988427506201 | (37.7198198301278, -122.429884275062) | |||
| 125641 | 125641 | 113226 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1118 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006956.0 | 2114756.0 | 37.787109810462 | -122.419719385886 | (37.787109810462, -122.419719385886) | ||||
| 125699 | 125699 | 88320 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 645 France Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51311 | 6002646.5 | 2089495.7 | 37.717507319615706 | -122.432824059512 | (37.7175073196157, -122.432824059512) | |||
| 126048 | 126048 | 83189 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1670 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53556 | 5992811.58181355 | 2104100.90541778 | 37.7570468381941 | -122.467880263564 | (37.7570468381941, -122.467880263564) | ||
| 126909 | 126909 | 95564 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 497 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767357 | 6003239.0 | 2102086.6 | 37.75211264995529 | -122.43167449646799 | (37.7521126499553, -122.431674496468) | |
| 127067 | 127067 | 87902 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 223 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50920 | 6007150.2 | 2097674.7 | 37.7402194874954 | -122.41783623809401 | (37.7402194874954, -122.417836238094) | ||
| 127266 | 127266 | 95734 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 626 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767481 | 6002384.8 | 2090170.7 | 37.7193458734928 | -122.43377685304199 | (37.7193458734928, -122.433776853042) | |
| 127785 | 127785 | 37585 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 210 Eagle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40016 | 5999628.99810136 | 2104552.86123042 | 37.758679112173205 | -122.444335603116 | (37.7586791121732, -122.444335603116) | ||
| 127852 | 127852 | 92600 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Baker St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814.0 | 2116396.0 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | ||
| 128361 | 128361 | 88259 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1460 Clayton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51244 | 5999422.0 | 2104472.0 | 37.758445274906 | -122.445045681381 | (37.758445274906, -122.445045681381) | |||
| 129025 | 129025 | 88319 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 631 France Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51310 | 6002604.8 | 2089521.8 | 37.7175766192591 | -122.43297006078501 | (37.7175766192591, -122.432970060785) | |||
| 129116 | 129116 | 88261 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 229 Douglass St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51248 | 6001199.0 | 2104918.0 | 37.7597711445886 | -122.438931999231 | (37.7597711445886, -122.438931999231) | |||
| 129492 | 129492 | 50837 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 202 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2004 12:00:00 AM | Permit Number 47354 | 5994277.69303186 | 2105335.48637483 | 37.7605212305047 | -122.462899497742 | (37.7605212305047, -122.462899497742) | |||
| 138917 | 138917 | 98077 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 731 Duboce Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6001992.2 | 2108216.2 | 37.768872292925295 | -122.436424775079 | (37.7688722929253, -122.436424775079) | |||||
| 139165 | 139165 | 99577 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 301X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2013 12:00:00 AM | 3x3 | 6002944.2 | 2106475.3 | 37.7641462544056 | -122.433007480488 | (37.7641462544056, -122.433007480488) | |||
| 139591 | 139591 | 87070 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 395 Byxbee St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 140338 | 140338 | 89189 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 141970 | 141970 | 94820 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1227 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53900 | 5992334.0 | 2107055.2 | 37.7651309632558 | -122.469746983482 | (37.7651309632558, -122.469746983482) | |
| 142179 | 142179 | 95565 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 497 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767357 | 6003239.0 | 2102086.6 | 37.75211264995529 | -122.43167449646799 | (37.7521126499553, -122.431674496468) | |
| 142314 | 142314 | 47094 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 336 Willard North St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51142 | 5996292.61494047 | 2110619.69439374 | 37.775146151844794 | -122.456312937477 | (37.7751461518448, -122.456312937477) | ||
| 142320 | 142320 | 82180 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 105 Lake St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773769 | 5995179.68463591 | 2114884.08050195 | 37.78679106496129 | -122.46047184952101 | (37.7867910649613, -122.460471849521) | ||
| 142629 | 142629 | 87975 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2160 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51010 | 5999212.8 | 2111613.6 | 37.778042363793396 | -122.446282917617 | (37.7780423637934, -122.446282917617) | ||
| 143562 | 143562 | 89299 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2825 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2008 12:00:00 AM | 3x3 | Permit Number 51902 | 6000069.8 | 2117048.2 | 37.7930132732955 | -122.44370878246599 | (37.7930132732955, -122.443708782466) | ||
| 143622 | 143622 | 87071 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 395 Byxbee St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 143971 | 143971 | 114720 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 465 Woolsey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788.0 | 37.724241933851296 | -122.405954818575 | (37.7242419338513, -122.405954818575) | |||
| 143973 | 143973 | 89191 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 144271 | 144271 | 33553 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 238 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53983 | 6007052.33241005 | 2097631.90832878 | 37.740096482896 | -122.418171592585 | (37.740096482896, -122.418171592585) | |
| 144702 | 144702 | 112554 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 35 DOLORES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/2015 12:00:00 AM | 3x3 | 6004913.0 | 2108042.0 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | |||
| 144889 | 144889 | 108925 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 209 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 770705 | 6009037.7 | 2097340.0 | 37.739406516451204 | -122.411286359806 | (37.7394065164512, -122.411286359806) | ||
| 145185 | 145185 | 99291 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.38992452193199 | (37.753957014382, -122.389924521932) | ||
| 145493 | 145493 | 117275 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3431 19TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 6006713.0 | 2104938.0 | 37.760138240698794 | -122.41986317152201 | (37.7601382406988, -122.419863171522) | ||||
| 145621 | 145621 | 51877 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4200 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50819 | 6002010.54318716 | 2105309.8458945 | 37.760893198333704 | -122.436153317055 | (37.7608931983337, -122.436153317055) | ||
| 5133 | 5133 | 242839 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1151 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 7ft | 6005182.8356800005 | 2101610.74761 | 37.750916060132106 | -122.424918561756 | (37.7509160601321, -122.424918561756) | |||
| 5246 | 5246 | 243453 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 73 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 4x6 | 6007416.818030001 | 2098970.61704 | 37.74379278831079 | -122.41700617529699 | (37.7437927883108, -122.417006175297) | |||
| 12646 | 12646 | 115976 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011653.53869 | 2091254.58415 | 37.7228435956385 | -122.401814242757 | (37.7228435956385, -122.401814242757) | |||
| 23030 | 23030 | 17382 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1627 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2015 12:00:00 AM | 1 | 3X3 | Permit Number 776412 | 6014690.32946 | 2095358.97831 | 37.7342824432881 | -122.39160343105 | (37.7342824432881, -122.39160343105) | |
| 23545 | 23545 | 177395 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 715 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001937.656140001 | 2089768.77997 | 37.718216907458704 | -122.435293726344 | (37.7182169074587, -122.435293726344) | |||
| 23977 | 23977 | 177421 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 0 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001079.38248 | 2091791.86287 | 37.7237230579705 | -122.438405269984 | (37.7237230579705, -122.438405269984) | |||
| 26519 | 26519 | 115980 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011593.71434 | 2091235.60939 | 37.722788156028706 | -122.402019710862 | (37.7227881560287, -122.402019710862) | |||
| 26535 | 26535 | 177420 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 121 Cotter St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6001985.26237 | 2093449.7289900002 | 37.728326668619296 | -122.435392337892 | (37.7283266686193, -122.435392337892) | |||
| 27217 | 27217 | 230322 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4089 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6003345.458190001 | 2100655.86235 | 37.7481902141138 | -122.43120423378299 | (37.7481902141138, -122.431204233783) | |||
| 27791 | 27791 | 38712 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2000 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2012 12:00:00 AM | 1 | Permit Number 768631 | 5999544.5843 | 2111225.8207 | 37.7769965642688 | -122.44510727559799 | (37.7769965642688, -122.445107275598) | ||
| 27994 | 27994 | 52460 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 682@ CABRILLO 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 1 | Permit Number 48571 | 5992268.12798 | 2110826.06835 | 37.775480948973396 | -122.470249439229 | (37.7754809489734, -122.470249439229) | |
| 28385 | 28385 | 230289 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3798 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6005260.07773 | 2101390.67485 | 37.750316153870294 | -122.424635797817 | (37.7503161538703, -122.424635797817) |
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");