Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22057 | 22057 | 5393 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 347 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/2014 12:00:00 AM | 3 | 6x7 | 6004928.4905 | 2106245.9446799997 | 37.7636288523174 | -122.426128059965 | (37.7636288523174, -122.426128059965) | ||
| 143719 | 143719 | 8223 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1500X Galvez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/2015 08:24:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 4168 | 4168 | 13059 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 583 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2015 07:23:00 AM | 3 | 2x2 | 6009557.0524 | 2120495.5376 | 37.8030153566132 | -122.41112585507 | (37.8030153566132, -122.41112585507) | ||
| 143305 | 143305 | 13238 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2322 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1998 12:00:00 AM | 3 | 3X3 | 6001219.43305 | 2119376.81704 | 37.7994725475626 | -122.439898035919 | (37.7994725475626, -122.439898035919) | ||
| 89613 | 89613 | 24369 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 134 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/19/2016 04:44:00 AM | 3 | 3x3 | 6005829.420761799 | 2108507.0022787 | 37.7698880583785 | -122.42317275016899 | (37.7698880583785, -122.423172750169) | ||
| 116356 | 116356 | 26561 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 430 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6010306.750370901 | 2097855.6706051 | 37.740893529599106 | -122.406934857164 | (37.7408935295991, -122.406934857164) | ||
| 83616 | 83616 | 30531 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 100 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/1986 12:00:00 AM | 2 | 3x3 | Permit Number 34534 | 5989617.18715 | 2114630.7338900003 | 37.7857738797228 | -122.479698023599 | (37.7857738797228, -122.479698023599) |
| 16533 | 16533 | 33792 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 77 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013856.54517 | 2116173.60161 | 37.7913885182281 | -122.395944220262 | (37.7913885182281, -122.395944220262) | |
| 172672 | 172672 | 34927 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2625 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/2012 12:00:00 AM | 3 | Permit Number 768761 | 5999601.94789 | 2117876.9745400003 | 37.7952621734732 | -122.44538718908301 | (37.7952621734732, -122.445387189083) | ||
| 134484 | 134484 | 34949 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1246 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | 8 | Permit Number 38547 | 6007519.4935099995 | 2115461.74269 | 37.7890793334842 | -122.417819862092 | (37.7890793334842, -122.417819862092) | |
| 56984 | 56984 | 38711 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2000 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2012 12:00:00 AM | 1 | Permit Number 768631 | 5999529.3553 | 2111223.7902 | 37.7769901198015 | -122.44515981121201 | (37.7769901198015, -122.445159811212) | ||
| 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) | ||
| 87428 | 87428 | 49067 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1298 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50555 | 5995836.31315767 | 2092013.47244835 | 37.724031921729704 | -122.45654557668001 | (37.7240319217297, -122.45654557668) | ||
| 103390 | 103390 | 49736 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 251 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2003 12:00:00 AM | 3 | 3x12 | Permit Number 46536 | 5987104.42255848 | 2114202.9919751 | 37.7844531321546 | -122.488359918659 | (37.7844531321546, -122.488359918659) | |
| 153237 | 153237 | 50024 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1704 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 3 | Permit Number 46757 | 6005953.2164199995 | 2092396.45471 | 37.725659158041104 | -122.421600147046 | (37.7256591580411, -122.421600147046) | |
| 66641 | 66641 | 50836 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 202 Kirkham St | 2 | 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) | |||
| 2327 | 2327 | 53079 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 600 Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780021 | 6011490.70702 | 2105522.9440900004 | 37.7620123668039 | -122.4033804148 | (37.7620123668039, -122.4033804148) | |
| 66578 | 66578 | 70266 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 414 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 8 | 5988762.33088 | 2112478.2196299997 | 37.7798139854521 | -122.482497769619 | (37.7798139854521, -122.482497769619) | ||
| 11033 | 11033 | 83366 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 618 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52311 | 6003144.474669999 | 2089738.5573200001 | 37.718202383405206 | -122.43112011482701 | (37.7182023834052, -122.431120114827) | |
| 137475 | 137475 | 84780 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 224 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2007 12:00:00 AM | 4 | Permit No. 49287 | 6013987.25375 | 2106041.39506 | 37.7635750422708 | -122.39478207494899 | (37.7635750422708, -122.394782074949) | ||
| 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) | |||
| 76542 | 76542 | 87077 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2565 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50014 | 6006603.98041 | 2120038.0860099997 | 37.8015932612686 | -122.421312536668 | (37.8015932612686, -122.421312536668) | |
| 79183 | 79183 | 87126 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 438 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2008 12:00:00 AM | 3x3 | Permit Number 50074 | 5985668.2 | 2112929.7 | 37.7808731376826 | -122.493234847229 | (37.7808731376826, -122.493234847229) | ||
| 68243 | 68243 | 87490 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 496 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50390 | 5984109.08074 | 2112532.5405200003 | 37.77969133885821 | -122.498599173652 | (37.7796913388582, -122.498599173652) | |
| 100026 | 100026 | 87899 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 700 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50917 | 6007438.0 | 2097723.6 | 37.740369948387794 | -122.41684460251801 | (37.7403699483878, -122.416844602518) | ||
| 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) | ||
| 93883 | 93883 | 87912 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 101 Wool St | 2 | 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) | ||
| 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) | ||
| 105801 | 105801 | 88240 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2501 Turk Blvd | 2 | 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) | ||
| 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) | ||
| 96094 | 96094 | 88841 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1300 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2008 12:00:00 AM | 3x3 | Permit Number 51719 | 6006820.0 | 2115342.0 | 37.788711160036996 | -122.42023152280301 | (37.788711160037, -122.420231522803) | ||
| 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) | ||||
| 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) | |||
| 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) | ||
| 188017 | 188017 | 94885 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2010 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53951 | 6013050.0613 | 2096298.0841299999 | 37.736769849332 | -122.39734023878599 | (37.736769849332, -122.397340238786) |
| 149661 | 149661 | 95133 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 450@ Wayland Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2010 12:00:00 AM | 1 | 3x3 | Permit Number 54066 | 6010089.84133 | 2092358.2905700002 | 37.725786753837 | -122.407297408351 | (37.725786753837, -122.407297408351) | |
| 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) | |
| 81271 | 81271 | 96117 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201 Andover St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767772 | 6007577.0 | 2097739.0 | 37.7404200508617 | -122.41636508469699 | (37.7404200508617, -122.416365084697) | |
| 24130 | 24130 | 96862 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 387 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768142 | 5986827.805480001 | 2113344.76478 | 37.7820805427479 | -122.48925378416 | (37.7820805427479, -122.48925378416) | |
| 91295 | 91295 | 98410 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 19th Ave | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | Permit Number 768592 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||
| 53809 | 53809 | 98842 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 313 Maple St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2012 12:00:00 AM | 1 | Permit Number 768890 | 5996633.94495 | 2115242.03804 | 37.7878574732038 | -122.455466360678 | (37.7878574732038, -122.455466360678) | ||
| 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) | ||
| 135826 | 135826 | 99539 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 801X Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768631 | 5999563.7 | 2111218.2 | 37.776976730821794 | -122.445040600733 | (37.7769767308218, -122.445040600733) | |
| 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) | |||
| 103056 | 103056 | 99584 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3599X 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2013 12:00:00 AM | 6003014.6 | 2106437.9 | 37.7640475560396 | -122.432761315556 | (37.7640475560396, -122.432761315556) | ||||
| 82995 | 82995 | 99875 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1301X San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003616.3 | 2095455.7 | 37.733927108519204 | -122.429896797189 | (37.7339271085192, -122.429896797189) | |||
| 22965 | 22965 | 103768 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1323 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006757.0 | 2115467.0 | 37.7890508291132 | -122.42045837028401 | (37.7890508291132, -122.420458370284) | ||
| 105089 | 105089 | 103774 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1288 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | ||
| 83122 | 83122 | 103782 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1237 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006764.1 | 2115217.5 | 37.7883661638156 | -122.420416088533 | (37.7883661638156, -122.420416088533) | ||
| 127702 | 127702 | 103787 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1217 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006790.1 | 2115111.0 | 37.7880752061995 | -122.42031857060101 | (37.7880752061995, -122.420318570601) | ||
| 112678 | 112678 | 103864 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1435 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006674.8 | 2115856.4 | 37.790115392534 | -122.42077042798 | (37.790115392534, -122.42077042798) | ||
| 122862 | 122862 | 103867 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1411 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.42073037630101 | (37.7899185422019, -122.420730376301) | ||
| 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) | ||
| 171597 | 171597 | 105251 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 500 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2014 12:00:00 AM | 1 | Permit Number 771049 | 5984733.08187 | 2112389.43293 | 37.779334982299794 | -122.496429952441 | (37.7793349822998, -122.496429952441) | ||
| 126468 | 126468 | 105848 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 790 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008900.0 | 2110136.0 | 37.774533709285706 | -122.41266682187201 | (37.7745337092857, -122.412666821872) | |||
| 103987 | 103987 | 108663 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 842 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772817 | 5982645.59315 | 2110033.9904099996 | 37.7727451127869 | -122.50347686125099 | (37.7727451127869, -122.503476861251) |
| 10963 | 10963 | 108843 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 420 Woolsey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010519.109209999 | 2091869.71455 | 37.7244692416558 | -122.40577905416201 | (37.7244692416558, -122.405779054162) | |
| 115316 | 115316 | 109088 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 218 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 5987170.3 | 2114494.3 | 37.7852568239907 | -122.488153421892 | (37.7852568239907, -122.488153421892) | ||
| 4899 | 4899 | 109487 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1314 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 10/31/2017 02:27:00 PM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | ||
| 90133 | 90133 | 109758 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3590 20TH ST | 2 | 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) | ||
| 15461 | 15461 | 109908 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1401 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/18/2015 02:04:00 PM | 3 | 3x3 | Permit Number 778313 | 6008340.42119 | 2109862.66125 | 37.773751763372395 | -122.414583173274 | (37.7737517633724, -122.414583173274) | |
| 172336 | 172336 | 110563 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 135 Theresa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x9 | 6002082.973999999 | 2093709.6113599997 | 37.729045795311706 | -122.43507312442499 | (37.7290457953117, -122.435073124425) | |||
| 13472 | 13472 | 110653 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1189 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2015 12:00:00 AM | 3 | 3x4 | 6015597.65588 | 2103555.7138400003 | 37.7568393018153 | -122.38903859247101 | (37.7568393018153, -122.389038592471) | ||
| 91852 | 91852 | 112388 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4200 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002010.54318716 | 2105309.8458945 | 37.760893198333704 | -122.436153317055 | (37.7608931983337, -122.436153317055) | ||||
| 72706 | 72706 | 112523 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 195 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776238 | 5995199.36548 | 2114291.31706 | 37.7851646286632 | -122.46036079357799 | (37.7851646286632, -122.460360793578) | |
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 182061 | 182061 | 115977 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011639.0005 | 2091249.90123 | 37.722829925953896 | -122.40186416949 | (37.7228299259539, -122.40186416949) | |||
| 9341 | 9341 | 116840 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 636 POTRERO AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6010345.0 | 2105335.0 | 37.761432257364994 | -122.40732973919701 | (37.761432257365, -122.407329739197) | |||
| 15260 | 15260 | 116923 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015559.42731 | 2102560.4848599997 | 37.7541044949445 | -122.389101314797 | (37.7541044949445, -122.389101314797) | ||
| 15315 | 15315 | 116934 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1275 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015367.98495 | 2102613.01131 | 37.7542381072096 | -122.38976704331999 | (37.7542381072096, -122.38976704332) | ||
| 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) | ||||
| 52885 | 52885 | 120377 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 101 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5987995.9910699995 | 2115194.27342 | 37.7872268871617 | -122.485348201277 | (37.7872268871617, -122.485348201277) | |||
| 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) | ||||
| 160936 | 160936 | 121810 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 106 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5989928.89895 | 2114601.72994 | 37.7857123459232 | -122.478617478776 | (37.7857123459232, -122.478617478776) | |||
| 73090 | 73090 | 123057 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 514 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5991919.1397400005 | 2111920.98536 | 37.778467110254795 | -122.47153646453998 | (37.7784671102548, -122.47153646454) | |||
| 73056 | 73056 | 123366 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 780 04th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994765.69029 | 2110380.32738 | 37.774401141157796 | -122.461577514019 | (37.7744011411578, -122.461577514019) | |||
| 32960 | 32960 | 124335 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 176 Palm Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5995959.20478 | 2113110.98096 | 37.78196742074471 | -122.457646568088 | (37.7819674207447, -122.457646568088) | |||
| 68652 | 68652 | 124611 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3931 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995971.07063 | 2115182.72875 | 37.787656567418 | -122.457755475318 | (37.787656567418, -122.457755475318) | |||
| 48031 | 48031 | 130967 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 213 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998523.7164 | 2115638.03819 | 37.7890530400256 | -122.448956666639 | (37.7890530400256, -122.448956666639) | |||
| 65862 | 65862 | 130969 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 95 Heather Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5997355.4901 | 2113891.63765 | 37.7841910082488 | -122.452872452398 | (37.7841910082488, -122.452872452398) | ||||
| 56993 | 56993 | 130971 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6002947.99505 | 2118332.47012 | 37.7967032866916 | -122.43384191568998 | (37.7967032866916, -122.43384191569) | |||
| 134678 | 134678 | 130980 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3001 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6003394.29695 | 2118690.35312 | 37.797711256726 | -122.43232318378 | (37.797711256726, -122.43232318378) | |||
| 168749 | 168749 | 130985 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2098 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999249.259269999 | 2121180.66389 | 37.8043130782603 | -122.44684538130501 | (37.8043130782603, -122.446845381305) | |||
| 167906 | 167906 | 130986 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3147 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004613.79741 | 2120397.19916 | 37.802466888808496 | -122.42822508471599 | (37.8024668888085, -122.428225084716) | |||
| 43019 | 43019 | 130992 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1645 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006789.62412 | 2117015.0975 | 37.7933033592027 | -122.420455425186 | (37.7933033592027, -122.420455425186) | |||
| 161788 | 161788 | 130997 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2201 Leavenworth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6007578.93915 | 2119952.7888599997 | 37.8014139751467 | -122.417932677574 | (37.8014139751467, -122.417932677574) | |||
| 153469 | 153469 | 131001 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 937 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007906.15602 | 2120261.72441 | 37.80228064460721 | -122.416822257668 | (37.8022806446072, -122.416822257668) | |||
| 74720 | 74720 | 131004 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1109 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011962.5768099995 | 2119524.82057 | 37.8004846103385 | -122.402733131341 | (37.8004846103385, -122.402733131341) | |||
| 35824 | 35824 | 131007 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 150x Drumm St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 7ft | 6013687.07221 | 2117423.5151299997 | 37.7948110573238 | -122.396618254944 | (37.7948110573238, -122.396618254944) | |||
| 62272 | 62272 | 177397 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 650 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6002573.73742 | 2089477.3552599999 | 37.717452821874105 | -122.433074256169 | (37.7174528218741, -122.433074256169) | |||
| 36649 | 36649 | 177403 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 688 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002695.8436900005 | 2089531.77748 | 37.7176091789075 | -122.432656076817 | (37.7176091789075, -122.432656076817) | |||
| 71769 | 71769 | 177406 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 618 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002461.15734 | 2090172.80832 | 37.7193559950662 | -122.433513065093 | (37.7193559950662, -122.433513065093) | |||
| 31130 | 31130 | 177416 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 538 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002518.22292 | 2090772.4099400002 | 37.721005605292504 | -122.433358634398 | (37.7210056052925, -122.433358634398) | |||
| 151961 | 151961 | 177422 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 0 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6001061.39064 | 2091803.12496 | 37.7237529577069 | -122.438468271097 | (37.7237529577069, -122.438468271097) | |||
| 75167 | 75167 | 177436 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 99 Karen Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010107.2934 | 2091444.47715 | 37.7232785896114 | -122.40717269128099 | (37.7232785896114, -122.407172691281) | |||
| 41960 | 41960 | 177441 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 71 Karen Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010258.66598 | 2091491.8701799999 | 37.7234171913236 | -122.406652760812 | (37.7234171913236, -122.406652760812) | |||
| 2517 | 2517 | 178826 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 927 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004356.8834 | 2090741.4764900003 | 37.7210248094256 | -122.427000725205 | (37.7210248094256, -122.427000725205) |
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");