Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 132124 | 132124 | 193349 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2501 18th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010309.72434 | 2105489.81742 | 37.761855376635104 | -122.407462658778 | (37.7618553766351, -122.407462658778) | |||
| 500 | 500 | 6742 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:53:00 PM | 3 | 3x3 | 6016901.500630001 | 2097278.26947 | 37.7396749203573 | -122.384092237585 | (37.7396749203573, -122.384092237585) | ||
| 3902 | 3902 | 253544 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 12 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 02:38:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 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) | ||
| 505 | 505 | 6741 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:50:00 PM | 3 | 3x3 | 6016924.03316 | 2097256.8815900004 | 37.739617439282604 | -122.38401284003099 | (37.7396174392826, -122.384012840031) | ||
| 3900 | 3900 | 253543 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 11 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 02:35:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 16611 | 16611 | 116932 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015412.75293 | 2102554.60022 | 37.7540802051572 | -122.38960814389799 | (37.7540802051572, -122.389608143898) | ||
| 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) | ||||
| 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) | ||
| 3896 | 3896 | 253542 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 10 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 02:42:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 16017 | 16017 | 116931 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015431.47773 | 2102556.1938099996 | 37.754085619065705 | -122.38954349973301 | (37.7540856190657, -122.389543499733) | ||
| 93683 | 93683 | 92601 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Baker St | 10 | 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) | ||
| 119795 | 119795 | 450 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 700x 23rd Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/29/2015 01:42:00 PM | 3 | 5988819.93055 | 2110324.8097900003 | 37.773904673102 | -122.48214070454901 | (37.773904673102, -122.482140704549) | |||
| 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) | ||||
| 3899 | 3899 | 253541 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 9 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 03:59:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 9836 | 9836 | 6755 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1215 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/03/2017 06:41:00 AM | 3 | 3x3 | 6017521.099066501 | 2096743.3718321999 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | ||
| 14067 | 14067 | 116930 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015446.80292 | 2102557.08015 | 37.7540889024884 | -122.389490562948 | (37.7540889024884, -122.389490562948) | ||
| 36826 | 36826 | 218387 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 50 San Marcos Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5993857.52408 | 2100226.90247 | 37.746470159084396 | -122.46398181990101 | (37.7464701590844, -122.463981819901) | |||
| 77791 | 77791 | 85870 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2310 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/2007 12:00:00 AM | 3 | 3x3 | 6008150.982530001 | 2104964.863142 | 37.760292906427296 | -122.41489175995599 | (37.7602929064273, -122.414891759956) | ||
| 102499 | 102499 | 89170 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 116957 | 116957 | 8230 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1500X Galvez Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/2015 08:33:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 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) | ||
| 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) | ||
| 182271 | 182271 | 130978 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002959.932159999 | 2118244.90398 | 37.7964635301195 | -122.433794348725 | (37.7964635301195, -122.433794348725) | |||
| 3906 | 3906 | 253540 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 8 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 04:11:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 14755 | 14755 | 33779 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013803.37475 | 2116233.23226 | 37.79154929181811 | -122.396132371028 | (37.7915492918181, -122.396132371028) | |
| 16892 | 16892 | 116929 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015461.93425 | 2102556.8401200003 | 37.7540890823654 | -122.38943821792401 | (37.7540890823654, -122.389438217924) | ||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 153254 | 153254 | 230343 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 65 Chenery St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004910.0558400005 | 2097921.66035 | 37.7407712613889 | -122.42559933235 | (37.7407712613889, -122.42559933235) | |||
| 165318 | 165318 | 130977 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 2ft | 6002958.5494099995 | 2118258.6214900003 | 37.7965011163873 | -122.43380011427901 | (37.7965011163873, -122.433800114279) | |||
| 3940 | 3940 | 179536 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1880 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 10:42:00 AM | 3 | Width 3ft | 6000969.55481 | 2091096.3953200001 | 37.7218072142025 | -122.438735113438 | (37.7218072142025, -122.438735113438) | ||
| 13642 | 13642 | 33785 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Beale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013812.6799 | 2116223.3583 | 37.7915226979635 | -122.39609948281701 | (37.7915226979635, -122.396099482817) | |
| 16512 | 16512 | 116928 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015476.82973 | 2102557.66932 | 37.754092185022394 | -122.38938676319599 | (37.7540921850224, -122.389386763196) | ||
| 37514 | 37514 | 193348 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2501 18th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010227.27367 | 2105486.95448 | 37.7618429003376 | -122.407747622459 | (37.7618429003376, -122.407747622459) | |||
| 44551 | 44551 | 230342 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 65 Chenery St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004911.05921 | 2097907.1085200002 | 37.740731362062704 | -122.42559482765499 | (37.7407313620627, -122.425594827655) | |||
| 69069 | 69069 | 130976 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6002956.82977 | 2118266.12381 | 37.796521618235005 | -122.433806601098 | (37.796521618235, -122.433806601098) | |||
| 94680 | 94680 | 89190 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 370 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013271.0 | 2113050.0 | 37.782779240858495 | -122.39775101659401 | (37.7827792408585, -122.397751016594) | ||||
| 135397 | 135397 | 218385 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 50 San Marcos Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5993842.10795 | 2100214.10934 | 37.7464341439306 | -122.46403419821999 | (37.7464341439306, -122.46403419822) | |||
| 160542 | 160542 | 130984 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200 Beach St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 5999592.955130001 | 2120888.49408 | 37.803530487293 | -122.445634974783 | (37.803530487293, -122.445634974783) | |||
| 168943 | 168943 | 88037 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2301X Lyon St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51052 | 5999275.57165 | 2116691.87228 | 37.7919895603315 | -122.446431199448 | (37.7919895603315, -122.446431199448) | |
| 13895 | 13895 | 33780 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Beale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013824.14126 | 2116210.79912 | 37.7914888510795 | -122.39605894586 | (37.7914888510795, -122.39605894586) | |
| 16727 | 16727 | 116927 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015494.24319 | 2102557.91546 | 37.7540938262957 | -122.38932655988899 | (37.7540938262957, -122.389326559889) | ||
| 17962 | 17962 | 5397 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 347 Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/2014 12:00:00 AM | 30 | 6x6 | 6004921.39011 | 2106378.39566 | 37.7639921298444 | -122.42616204806002 | (37.7639921298444, -122.42616204806) | ||
| 21415 | 21415 | 136 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1025X 14th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6001971.14414 | 2107605.72409 | 37.767194880067294 | -122.436453906645 | (37.7671948800673, -122.436453906645) | |||
| 38961 | 38961 | 230341 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 65 Chenery St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004909.36728 | 2097888.2006599996 | 37.7406793497697 | -122.425599332346 | (37.7406793497697, -122.425599332346) | |||
| 45725 | 45725 | 130982 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3601 Broderick St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5999659.44076 | 2120919.3234599996 | 37.8036189320344 | -122.44540711714701 | (37.8036189320344, -122.445407117147) | |||
| 54260 | 54260 | 177419 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 100 Capistrano Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001443.854169999 | 2093560.7227900003 | 37.7286006695825 | -122.437271950666 | (37.7286006695825, -122.437271950666) | |||
| 55251 | 55251 | 130983 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200 Beach St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 5999604.2907300005 | 2120890.91469 | 37.8035377808009 | -122.44559592174 | (37.8035377808009, -122.44559592174) | |||
| 79562 | 79562 | 114722 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 465 Woolsey St | 6 | 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) | |||
| 84281 | 84281 | 26689 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1295X Pierce St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6002245.89461 | 2112942.9215 | 37.7818651028046 | -122.435885513106 | (37.7818651028046, -122.435885513106) | |||
| 105976 | 105976 | 112558 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 35 DOLORES ST | 6 | 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) | |||
| 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) | ||||
| 169605 | 169605 | 193341 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1751 22nd St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 4ft | 6012847.48484 | 2103764.38864 | 37.757259446178104 | -122.398564409431 | (37.7572594461781, -122.398564409431) | |||
| 184007 | 184007 | 130975 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6002956.23707 | 2118277.75105 | 37.796553509993 | -122.43380948344101 | (37.796553509993, -122.433809483441) | |||
| 1063 | 1063 | 248924 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201x Cashmere St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/29/2017 10:39:00 AM | 3 | 3x3 | 6016272.0 | 2096170.0 | 37.7365970133228 | -122.38619155869101 | (37.7365970133228, -122.386191558691) | |
| 14030 | 14030 | 116926 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015510.15678 | 2102558.1918900004 | 37.7540954675573 | -122.389271545654 | (37.7540954675573, -122.389271545654) | ||
| 15251 | 15251 | 108093 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2501X 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2014 12:00:00 AM | 3 | Permit Number 773081 | 6010203.41719 | 2105485.67353 | 37.7618380476045 | -122.40783004261999 | (37.7618380476045, -122.40783004262) | ||
| 16526 | 16526 | 33774 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Beale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013834.28126 | 2116198.48682 | 37.791455608540396 | -122.396022998165 | (37.7914556085404, -122.396022998165) | |
| 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) | |||
| 49969 | 49969 | 112557 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 35 DOLORES ST | 5 | 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) | |||
| 59160 | 59160 | 230296 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3500 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006123.351530001 | 2104947.42015 | 37.7601308699707 | -122.421903157405 | (37.7601308699707, -122.421903157405) | |||
| 60313 | 60313 | 193334 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1258 Minnesota St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015304.94166 | 2102636.75923 | 37.7542998178001 | -122.38998672342 | (37.7542998178001, -122.38998672342) | |||
| 82829 | 82829 | 88007 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1394 Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53732 | 5999618.7 | 2107794.0 | 37.7675778847064 | -122.44460417005699 | (37.7675778847064, -122.444604170057) | |
| 83713 | 83713 | 99542 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 801X Central Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2012 12:00:00 AM | 3x3 | Permit Number 768631 | 5999563.7 | 2111218.2 | 37.776976730821794 | -122.445040600733 | (37.7769767308218, -122.445040600733) | ||
| 90740 | 90740 | 18413 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 799X Potrero Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2013 12:00:00 AM | 3 | 4X4 | 6010481.346466599 | 2104567.7087473 | 37.759333078347105 | -122.406804093165 | (37.7593330783471, -122.406804093165) | ||
| 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) | ||||
| 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) | ||
| 143836 | 143836 | 103802 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1157 Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.787518325661296 | -122.42006782447201 | (37.7875183256613, -122.420067824472) | ||
| 144400 | 144400 | 103811 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1145 Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.42020072617599 | (37.7874934070669, -122.420200726176) | ||
| 147660 | 147660 | 230340 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 65 Chenery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004910.8116 | 2097869.74707 | 37.7406287620114 | -122.425593025396 | (37.7406287620114, -122.425593025396) | |||
| 161578 | 161578 | 230318 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 107 Valley St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6005160.92225 | 2099293.15868 | 37.744551255839795 | -122.424829478514 | (37.7445512558398, -122.424829478514) | |||
| 164901 | 164901 | 230299 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 590 York St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009785.6882 | 2105558.56974 | 37.762014809365 | -122.409279952113 | (37.762014809365, -122.409279952113) | |||
| 165491 | 165491 | 193346 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1133 19th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6014187.49963 | 2105244.21667 | 37.761397296172 | -122.394033672633 | (37.761397296172, -122.394033672633) | |||
| 167026 | 167026 | 130974 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 2ft | 6002954.53886 | 2118286.2899 | 37.796576859099105 | -122.433815970239 | (37.7965768590991, -122.433815970239) | |||
| 177912 | 177912 | 130966 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 99 Moulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002966.56472 | 2119407.57255 | 37.7996562924699 | -122.433854543963 | (37.7996562924699, -122.433854543963) | |||
| 181062 | 181062 | 31608 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 5 Lucerne St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1995 12:00:00 AM | 4 | Permit Number 35133 | 6012020.8525 | 2109827.45516 | 37.7738611793697 | -122.401849428724 | (37.7738611793697, -122.401849428724) | ||
| 10309 | 10309 | 108845 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 420 Woolsey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010479.05335 | 2091857.99264 | 37.7244348155857 | -122.405916697196 | (37.7244348155857, -122.405916697196) | |
| 14247 | 14247 | 33783 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Beale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013842.9233800005 | 2116188.62598 | 37.7914290137913 | -122.395992405042 | (37.7914290137913, -122.395992405042) | |
| 14797 | 14797 | 116925 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015524.58204 | 2102559.09611 | 37.7540987500629 | -122.389221722302 | (37.7540987500629, -122.389221722302) | ||
| 22958 | 22958 | 103860 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1475 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006677.0 | 2115920.4 | 37.7902912446707 | -122.420767361582 | (37.7902912446707, -122.420767361582) | ||
| 27684 | 27684 | 208849 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 15 Santa Rita Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 3ft | 5993729.602000001 | 2100694.18749 | 37.7477458321253 | -122.464458079273 | (37.7477458321253, -122.464458079273) | |||
| 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) | |||
| 33296 | 33296 | 110565 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 135 Theresa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x9 | 6002103.512680001 | 2093689.48997 | 37.728991712774295 | -122.43500068223301 | (37.7289917127743, -122.435000682233) | |||
| 35821 | 35821 | 130973 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002952.36205 | 2118301.89076 | 37.796619571497104 | -122.43382461811501 | (37.7966195714971, -122.433824618115) | |||
| 36370 | 36370 | 130994 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 800 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008432.69085 | 2120383.1883 | 37.8026437557674 | -122.41500878732401 | (37.8026437557674, -122.415008787324) | |||
| 42961 | 42961 | 193318 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 136 Hawthorne St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6013332.96782 | 2113640.4980900004 | 37.7844040630434 | -122.397578060899 | (37.7844040630434, -122.397578060899) | |||
| 44168 | 44168 | 177405 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 688 Vienna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002677.6930599995 | 2089500.91725 | 37.71752341415829 | -122.432716611994 | (37.7175234141583, -122.432716611994) | |||
| 45125 | 45125 | 193342 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 401 Texas St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013812.69862 | 2105193.07398 | 37.7612360315304 | -122.39532637971901 | (37.7612360315304, -122.395326379719) | |||
| 51630 | 51630 | 193333 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1258 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015305.27356 | 2102653.19148 | 37.7543449556813 | -122.389986723422 | (37.7543449556813, -122.389986723422) | |||
| 53463 | 53463 | 47067 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 604 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2012 12:00:00 AM | 1 | Permit Number 768780 | 6004041.40702 | 2110873.30571 | 37.7762842830232 | -122.429526231047 | (37.7762842830232, -122.429526231047) | ||
| 54511 | 54511 | 131009 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 150x Drumm St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 7ft | 6013684.354719999 | 2117443.2289299998 | 37.794865035532396 | -122.396629040522 | (37.7948650355324, -122.396629040522) | |||
| 60128 | 60128 | 250187 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 665 Parker Ave | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 5997222.68042 | 2110871.6887 | 37.7758914096851 | -122.453113845732 | (37.7758914096851, -122.453113845732) | |||
| 60673 | 60673 | 230347 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1801 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004579.28935 | 2098353.48586 | 37.741938260334294 | -122.42677374352199 | (37.7419382603343, -122.426773743522) | |||
| 61520 | 61520 | 130998 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Leavenworth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6007580.24685 | 2119942.9983 | 37.8013871663302 | -122.41792745790899 | (37.8013871663302, -122.417927457909) | |||
| 72470 | 72470 | 130987 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1332 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006981.766419999 | 2115388.7011599997 | 37.7888485036088 | -122.419675148215 | (37.7888485036088, -122.419675148215) | |||
| 73543 | 73543 | 193322 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2111 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011436.66428 | 2105551.33646 | 37.762087307318104 | -122.403569326371 | (37.7620873073181, -122.403569326371) | |||
| 80385 | 80385 | 99541 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 801X Central Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2012 12:00:00 AM | 3x3 | Permit Number 768631 | 5999563.7 | 2111218.2 | 37.776976730821794 | -122.445040600733 | (37.7769767308218, -122.445040600733) |
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");