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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76012 | 76012 | 97025 | Property Tree 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 80419 | 80419 | 83398 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4244X 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/12/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50813 | 6001912.0 | 2104709.0 | 37.7592378221466 | -122.43645112889901 | (37.7592378221466, -122.436451128899) | |
| 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) | ||
| 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) | ||
| 528 | 528 | 248942 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1500x Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/18/2017 12:56:00 PM | 3 | 3x3 | 6016393.0 | 2097292.0 | 37.739684495027205 | -122.385851388433 | (37.7396844950272, -122.385851388433) | |
| 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) | |
| 1480 | 1480 | 251545 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 347 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6004948.0 | 2106317.0 | 37.7638250559684 | -122.426065641314 | (37.7638250559684, -122.426065641314) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 6628 | 6628 | 17981 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2583 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2014 12:00:00 AM | 3 | 3x3 | 6001557.63 | 2114929.1565 | 37.7872796746141 | -122.438408931359 | (37.7872796746141, -122.438408931359) | ||
| 6833 | 6833 | 4378 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2425X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6006994.61601 | 2120672.53629 | 37.803357316535795 | -122.42000580642201 | (37.8033573165358, -122.420005806422) | |||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | ||
| 22940 | 22940 | 103859 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1475 Polk St | 3 | 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) | ||
| 22953 | 22953 | 103852 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1507 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006614.6 | 2116113.6 | 37.7908182067111 | -122.420996984718 | (37.7908182067111, -122.420996984718) | ||
| 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) | ||
| 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) | ||
| 25560 | 25560 | 131008 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 150x Drumm St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 7ft | 6013685.844769999 | 2117434.71438 | 37.7948417395127 | -122.396623287539 | (37.7948417395127, -122.396623287539) | |||
| 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) | |||
| 53694 | 53694 | 109906 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1415 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 6008272.88194 | 2109795.90835 | 37.773564680997296 | -122.41481207772199 | (37.7735646809973, -122.414812077722) | |||
| 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) | |||
| 69630 | 69630 | 177417 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1x Rolph St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 6000503.4246 | 2088653.73075 | 37.7150736797726 | -122.440171325345 | (37.7150736797726, -122.440171325345) | |||
| 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) | ||
| 81549 | 81549 | 8225 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1500X Galvez Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/2015 08:37:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 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) | ||
| 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) | |||
| 86852 | 86852 | 103869 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1411 Polk St | 4 | Sidewalk: Curb side : Pot 10 | 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) | ||
| 88285 | 88285 | 103775 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1288 Polk St | 1 | 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) | ||
| 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) | ||
| 90280 | 90280 | 103767 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1323 Polk St | 1 | 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) | ||
| 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) | ||
| 91623 | 91623 | 103865 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1424 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006775.0 | 2115831.4 | 37.790052395748404 | -122.420421968076 | (37.7900523957484, -122.420421968076) | ||
| 98614 | 98614 | 103810 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1145 Polk St | 4 | 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) | ||
| 101450 | 101450 | 109486 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1314 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Landscaping 2 | DPW 2 | 01/23/2016 04:50:00 AM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | ||
| 103588 | 103588 | 1922 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 66 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2016 02:50:00 PM | 3 | 3x3 | 6001235.3932896 | 2097346.6778621003 | 37.7389841732277 | -122.43826372276199 | (37.7389841732277, -122.438263722762) | ||
| 103601 | 103601 | 103866 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1411 Polk St | 1 | Sidewalk: Curb side : Pot 10 | 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) | ||
| 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) | ||
| 105404 | 105404 | 103863 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1435 Polk St | 1 | 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) | ||
| 105507 | 105507 | 94055 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 179 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/2010 12:00:00 AM | 3 | 3x9 | 6005293.287409999 | 2109516.64513 | 37.7726300238656 | -122.42509907481 | (37.7726300238656, -122.42509907481) | ||
| 112063 | 112063 | 109488 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1314 POLK ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 01/23/2016 04:53:00 AM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | ||
| 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) | ||
| 115999 | 115999 | 103868 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1411 Polk St | 3 | Sidewalk: Curb side : Pot 10 | 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) | ||
| 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) | ||
| 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) | ||
| 117870 | 117870 | 17877 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2189 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 6003478.4464424 | 2115194.6078963 | 37.7881176060092 | -122.431782277912 | (37.7881176060092, -122.431782277912) | |||
| 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) | |||
| 122302 | 122302 | 103861 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1436 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006766.2 | 2115894.4 | 37.7902248822442 | -122.42045688909701 | (37.7902248822442, -122.420456889097) | ||
| 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) | ||
| 127048 | 127048 | 103773 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1288 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 144432 | 144432 | 94054 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 185 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/2010 12:00:00 AM | 3 | 3x9 | 6005268.81764 | 2109524.34557 | 37.7726497850887 | -122.425184266439 | (37.7726497850887, -122.425184266439) | ||
| 145707 | 145707 | 103809 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1145 Polk St | 3 | 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) | ||
| 2247 | 2247 | 95100 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773992 | 5999642.14759 | 2120895.8486200003 | 37.8035534892505 | -122.445465271815 | (37.8035534892505, -122.445465271815) | |
| 2310 | 2310 | 102805 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 600 Kansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780021 | 6011492.26434 | 2105507.65774 | 37.7619704808857 | -122.403373953167 | (37.7619704808857, -122.403373953167) | |
| 2326 | 2326 | 32310 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 600 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780021 | 6011490.21346 | 2105535.41825 | 37.762046590490705 | -122.40338299943899 | (37.7620465904907, -122.403382999439) | |
| 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) | |
| 2512 | 2512 | 178827 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 927 Brazil Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004338.08735 | 2090755.04432 | 37.7210610008535 | -122.427066663506 | (37.7210610008535, -122.427066663506) | |||
| 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) | |||
| 2537 | 2537 | 230348 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 280 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6004547.50076 | 2096560.5372400002 | 37.7370134334286 | -122.42675600438 | (37.7370134334286, -122.42675600438) | |||
| 3174 | 3174 | 253344 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2586 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780063 | 5987098.36417 | 2097677.28593 | 37.7390777358027 | -122.487166705945 | (37.7390777358027, -122.487166705945) | |
| 3318 | 3318 | 253415 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 Stoneybrook Ave | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/31/2017 12:00:00 AM | 3 | Permit Number 779907 | 6005926.97731 | 2093972.4268599998 | 37.729984953042795 | -122.421802746417 | (37.7299849530428, -122.421802746417) | |||
| 3386 | 3386 | 243475 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 109X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779653 | 6007857.826 | 2097024.89565 | 37.738475065558895 | -122.415343555473 | (37.7384750655589, -122.415343555473) | |
| 3389 | 3389 | 243477 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 109 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779653 | 6007827.749919999 | 2097028.5645299999 | 37.7384834490575 | -122.415447803985 | (37.7384834490575, -122.415447803985) | |
| 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) | ||
| 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) | |||
| 5141 | 5141 | 237496 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3927 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003620.49393 | 2101843.48933 | 37.751466742003295 | -122.430337889878 | (37.7514667420033, -122.430337889878) | |||
| 5195 | 5195 | 253341 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1935 46th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 769984 | 5981944.6810099995 | 2101921.14451 | 37.750428327874204 | -122.505299944249 | (37.7504283278742, -122.505299944249) | |
| 6714 | 6714 | 97108 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1472 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768373 | 6007110.8589699995 | 2117762.02293 | 37.795372327823 | -122.419396941128 | (37.795372327823, -122.419396941128) |
| 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) | |||
| 9719 | 9719 | 173651 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 80 Entrada Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/21/2016 12:00:00 AM | 3 | 4x10 | 5992424.456569999 | 2092194.59394 | 37.7243327619491 | -122.46835290122299 | (37.7243327619491, -122.468352901223) | ||
| 9784 | 9784 | 115368 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 79 ELSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778647 | 6007415.0 | 2098925.0 | 37.7436674318334 | -122.417009230148 | (37.7436674318334, -122.417009230148) | |
| 9960 | 9960 | 173748 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1259 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773489 | 5989520.0 | 2106786.0 | 37.764228762563896 | -122.47946011839899 | (37.7642287625639, -122.479460118399) | |
| 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) | |
| 10311 | 10311 | 27188 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 258 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 5 | 2X3 | 6002908.14927 | 2093727.2885 | 37.729141154025506 | -122.43222169348999 | (37.7291411540255, -122.43222169349) | ||
| 10319 | 10319 | 109211 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 819 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773413 | 6011187.7232800005 | 2090968.5283099997 | 37.722032138266 | -122.403404362845 | (37.722032138266, -122.403404362845) | |
| 10860 | 10860 | 104506 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 631 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6002582.75614 | 2089515.1433 | 37.7175570910528 | -122.43304578096 | (37.7175570910528, -122.43304578096) | ||
| 10886 | 10886 | 83673 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 618 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52311 | 6003154.7737300005 | 2089756.30482 | 37.7182516977425 | -122.43108578140499 | (37.7182516977425, -122.431085781405) | |
| 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) | |
| 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) | |
| 11066 | 11066 | 109684 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 250 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773450 | 6005044.41141 | 2093779.7607 | 37.729406123972296 | -122.42484018495001 | (37.7294061239723, -122.42484018495) |
| 11429 | 11429 | 83565 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 647 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769747 | 6003095.84203 | 2089582.30789 | 37.7177706009018 | -122.43127706988199 | (37.7177706009018, -122.431277069882) |
| 11730 | 11730 | 108558 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 222 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773717 | 6001903.01628 | 2093995.18892 | 37.729819706015704 | -122.43571567476101 | (37.7298197060157, -122.435715674761) |
| 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) | |||
| 12772 | 12772 | 109685 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 266 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775044 | 6005143.37702 | 2093783.4945099999 | 37.7294219655289 | -122.424498316649 | (37.7294219655289, -122.424498316649) |
| 12835 | 12835 | 109714 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 250 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772039 | 6005020.03097 | 2094315.2579700002 | 37.7308751035831 | -122.424962554792 | (37.7308751035831, -122.424962554792) |
| 13056 | 13056 | 108448 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 90-98X Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | 6004670.84101 | 2090640.5659299998 | 37.7207654791334 | -122.42590828635599 | (37.7207654791334, -122.425908286356) | |
| 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) | ||
| 13608 | 13608 | 116924 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 900x 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015542.44799 | 2102559.60008 | 37.754101124282606 | -122.389159972153 | (37.7541011242826, -122.389159972153) | ||
| 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) |
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");