Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33482 | 33482 | 230350 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 35 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002643.63835 | 2096299.62877 | 37.7361892128574 | -122.433319865541 | (37.7361892128574, -122.433319865541) | |||
| 61328 | 61328 | 193352 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1707 McKinnon Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014777.576230001 | 2096343.32459 | 37.736990099615 | -122.39137057769199 | (37.736990099615, -122.391370577692) | |||
| 65368 | 65368 | 230328 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 518 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008539.17549 | 2096369.5184099998 | 37.7367138134929 | -122.41294144560601 | (37.7367138134929, -122.412941445606) | |||
| 84365 | 84365 | 108933 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 518 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773146 | 6008530.3 | 2096373.5 | 37.7367242478568 | -122.41297241357 | (37.7367242478568, -122.41297241357) |
| 108868 | 108868 | 80286 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 280 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50470 | 6004535.68280027 | 2096559.61306431 | 37.73701022767111 | -122.42679679858699 | (37.7370102276711, -122.426796798587) | ||
| 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) | |||
| 88766 | 88766 | 84634 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 361 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50931 | 6008966.27725874 | 2096629.00783692 | 37.737450280623605 | -122.411483091014 | (37.7374502806236, -122.411483091014) | ||
| 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) | ||
| 165815 | 165815 | 230351 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 132 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002667.4556599995 | 2096824.4771 | 37.737631676855294 | -122.43327501094299 | (37.7376316768553, -122.433275010943) | |||
| 57558 | 57558 | 230352 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 136 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002654.78135 | 2096839.9013099999 | 37.7376733091617 | -122.433319933881 | (37.7376733091617, -122.433319933881) | |||
| 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) | |
| 129514 | 129514 | 230353 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 210 Moffitt St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002369.42033 | 2097177.7522 | 37.7385847765781 | -122.43433070979401 | (37.7385847765781, -122.434330709794) | |||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 144889 | 144889 | 108925 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 209 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 770705 | 6009037.7 | 2097340.0 | 37.739406516451204 | -122.411286359806 | (37.7394065164512, -122.411286359806) | ||
| 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) | ||
| 67518 | 67518 | 230357 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 137 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004642.1298400005 | 2097534.3319200003 | 37.739692602838296 | -122.426498147168 | (37.7396926028383, -122.426498147168) | |||
| 172322 | 172322 | 230356 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 137 Randall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004658.9023 | 2097536.10277 | 37.73969841334279 | -122.42644028119 | (37.7396984133428, -122.42644028119) | |||
| 144271 | 144271 | 33553 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 238 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53983 | 6007052.33241005 | 2097631.90832878 | 37.740096482896 | -122.418171592585 | (37.740096482896, -122.418171592585) | |
| 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) | ||
| 127067 | 127067 | 87902 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 223 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50920 | 6007150.2 | 2097674.7 | 37.7402194874954 | -122.41783623809401 | (37.7402194874954, -122.417836238094) | ||
| 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) | |
| 87745 | 87745 | 87898 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 700 Eugenia Ave | 1 | 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) | ||
| 88613 | 88613 | 87900 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 700 Eugenia Ave | 3 | 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) | ||
| 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) | ||
| 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) | |
| 94972 | 94972 | 96116 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201 Andover St | 1 | 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) | |
| 96203 | 96203 | 96118 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 201 Andover St | 3 | 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) | |
| 83905 | 83905 | 87914 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 101 Wool St | 4 | 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) | ||
| 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) | ||
| 104650 | 104650 | 87913 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 101 Wool St | 3 | 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) | ||
| 110507 | 110507 | 87911 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 101 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50936 | 6007398.0 | 2097753.0 | 37.7404484242714 | -122.41698498961 | (37.7404484242714, -122.41698498961) | ||
| 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) | ||
| 176498 | 176498 | 230339 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 65 Chenery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004912.08615 | 2097855.70847 | 37.7405902872201 | -122.425587619594 | (37.7405902872201, -122.425587619594) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 83737 | 83737 | 82146 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1083 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51167 | 5995391.16373818 | 2098013.23554983 | 37.7404802453018 | -122.458518484651 | (37.7404802453018, -122.458518484651) | ||
| 152854 | 152854 | 208839 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 131 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992959.48741 | 2098205.81206 | 37.74086896193 | -122.466940197353 | (37.74086896193, -122.466940197353) | |||
| 29464 | 29464 | 230344 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1801 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004583.81865 | 2098292.85658 | 37.7417720422523 | -122.426753765994 | (37.7417720422523, -122.426753765994) | |||
| 157255 | 157255 | 230354 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 531 30th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003165.5903900005 | 2098301.47872 | 37.7417154299181 | -122.431658143201 | (37.7417154299181, -122.431658143201) | |||
| 188010 | 188010 | 230345 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1801 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004583.18993 | 2098311.13062 | 37.7418221830485 | -122.42675724096901 | (37.7418221830485, -122.426757240969) | |||
| 24569 | 24569 | 230346 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1801 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004582.48938 | 2098325.9035400003 | 37.74186270650671 | -122.426760715042 | (37.7418627065067, -122.426760715042) | |||
| 168110 | 168110 | 230355 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 397 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004002.34815 | 2098351.08289 | 37.7418990256315 | -122.428768448829 | (37.7418990256315, -122.428768448829) | |||
| 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) | |||
| 72299 | 72299 | 247777 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 240 30th St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005014.994390001 | 2098457.52943 | 37.742248565111204 | -122.42527461684799 | (37.7422485651112, -122.425274616848) | |||
| 102514 | 102514 | 107902 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 133 Elsie St | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 773996 | 6007164.40736 | 2098513.6513900002 | 37.742523860763995 | -122.417846568545 | (37.742523860764, -122.417846568545) | |||
| 145579 | 145579 | 107674 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 133 ELSIE ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/10/2014 12:00:00 AM | 3 | 6007164.4 | 2098513.7 | 37.742523993822 | -122.41784659743799 | (37.742523993822, -122.417846597438) | |||
| 68631 | 68631 | 208843 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 40 Agua Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997291.06099 | 2098595.63938 | 37.74218838968729 | -122.451991423486 | (37.7421883896873, -122.451991423486) | |||
| 79964 | 79964 | 109389 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 174X Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774921 | 6006834.59164 | 2098690.08898 | 37.74298975220871 | -122.418999487845 | (37.7429897522087, -122.418999487845) |
| 154873 | 154873 | 230319 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 119 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005056.96104 | 2098704.0891400003 | 37.7429279327818 | -122.425147048897 | (37.7429279327818, -122.425147048897) | |||
| 84429 | 84429 | 5717 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1647 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2008 12:00:00 AM | 3 | 3X3 | 6005332.0180626 | 2098744.9227683996 | 37.7430555871926 | -122.424198880257 | (37.7430555871926, -122.424198880257) | ||
| 113354 | 113354 | 87851 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 97 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2013 12:00:00 AM | 3x3 | Permit Number 779093 | 6007313.0 | 2098782.0 | 37.7432690474632 | -122.41735179051201 | (37.7432690474632, -122.417351790512) | ||
| 66618 | 66618 | 248252 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 110 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006810.41598 | 2098914.4324 | 37.7436043875329 | -122.41909899033999 | (37.7436043875329, -122.41909899034) | |||
| 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) | |
| 97250 | 97250 | 96057 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 110 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 2 | 3.5x6 | Permit Number 767685 | 6006775.4 | 2098937.3 | 37.7436652048745 | -122.419221689065 | (37.7436652048745, -122.419221689065) |
| 90414 | 90414 | 112573 | Section 143 8 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 56 ROCKWOOD CT | 1 | 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) | ||
| 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) | ||
| 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) | |||
| 55956 | 55956 | 246808 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 162 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6010230.46229 | 2099004.5054099998 | 37.744043711743004 | -122.407279600877 | (37.744043711743, -122.407279600877) | |||
| 66196 | 66196 | 107892 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 162 Brewster St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773952 | 6010231.01704 | 2099016.49618 | 37.7440766668365 | -122.40727852777799 | (37.7440766668365, -122.407278527778) | ||
| 125633 | 125633 | 99307 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 59 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777839 | 6006944.8 | 2099028.3 | 37.7439246092205 | -122.418642395457 | (37.7439246092205, -122.418642395457) | |
| 170923 | 170923 | 230330 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 38 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007670.81289 | 2099114.19378 | 37.744201302652705 | -122.416138084916 | (37.7442013026527, -122.416138084916) | |||
| 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) | |||
| 87298 | 87298 | 108921 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 33 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772690 | 6007205.6 | 2099297.0 | 37.7446770790021 | -122.417759648925 | (37.7446770790021, -122.417759648925) |
| 180726 | 180726 | 230329 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 33 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007181.85452 | 2099302.37672 | 37.7446905059706 | -122.417842137412 | (37.7446905059706, -122.417842137412) | |||
| 77158 | 77158 | 208851 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 185 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994827.47674 | 2099365.31036 | 37.7441602944536 | -122.46056543215299 | (37.7441602944536, -122.460565432153) | |||
| 135913 | 135913 | 208850 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 185 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994846.41703 | 2099381.9265400004 | 37.7442070079607 | -122.46050114503001 | (37.7442070079607, -122.46050114503) | |||
| 74610 | 74610 | 230333 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 629 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001808.677069999 | 2099403.33262 | 37.7446638554471 | -122.436428732821 | (37.7446638554471, -122.436428732821) | |||
| 27017 | 27017 | 230320 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 469 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002876.4268 | 2099458.33871 | 37.7448755037027 | -122.432740595108 | (37.7448755037027, -122.432740595108) | |||
| 112214 | 112214 | 230331 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 217 Montcalm St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 6ft | 6009886.65194 | 2099610.71375 | 37.745688979177 | -122.40851117835699 | (37.745688979177, -122.408511178357) | |||
| 75476 | 75476 | 208842 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 168 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993717.6087 | 2099811.01881 | 37.7453201833801 | -122.46443543703998 | (37.7453201833801, -122.46443543704) | |||
| 49507 | 49507 | 230314 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 31 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009412.86003 | 2099877.13325 | 37.7463939631256 | -122.41016829345301 | (37.7463939631256, -122.410168293453) | |||
| 127069 | 127069 | 108608 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 46 Mirabel Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774593 | 6007564.86266 | 2099909.6740900003 | 37.7463795558054 | -122.416560777242 | (37.7463795558054, -122.416560777242) | |
| 135085 | 135085 | 246460 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 200 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005150.47679 | 2099924.83113 | 37.7462850938946 | -122.42491052900299 | (37.7462850938946, -122.424910529003) | |||
| 180308 | 180308 | 230326 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 383 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004064.30243 | 2100111.9169799997 | 37.7467373764274 | -122.428679723506 | (37.7467373764274, -122.428679723506) | |||
| 146648 | 146648 | 230316 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 131 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010129.26175 | 2100145.52723 | 37.7471710439032 | -122.407709968747 | (37.7471710439032, -122.407709968747) | |||
| 150867 | 150867 | 230315 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 131 Peralta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010141.9244099995 | 2100150.42012 | 37.7471851875523 | -122.407666527004 | (37.7471851875523, -122.407666527004) | |||
| 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) | |||
| 165446 | 165446 | 230327 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 204 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005133.403419999 | 2100215.61494 | 37.747082555133 | -122.42499025209999 | (37.747082555133, -122.4249902521) | |||
| 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) | |||
| 176873 | 176873 | 230285 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 112 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6005732.266 | 2100246.49817 | 37.7472011631029 | -122.422921627052 | (37.7472011631029, -122.422921627052) | |||
| 150105 | 150105 | 230317 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 609 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009667.55833 | 2100362.09801 | 37.74773984264029 | -122.40932179038799 | (37.7477398426403, -122.409321790388) | |||
| 183043 | 183043 | 230286 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3714 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005720.70834 | 2100540.1162799997 | 37.748006719144 | -122.42298245807899 | (37.748006719144, -122.422982458079) | |||
| 88687 | 88687 | 95549 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1712 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767351 | 6002582.0 | 2100598.0 | 37.7479880436154 | -122.433840109923 | (37.7479880436154, -122.433840109923) | |
| 110111 | 110111 | 107776 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4115 26TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003143.1 | 2100622.5 | 37.7480871393693 | -122.431901599648 | (37.7480871393693, -122.431901599648) | |||||
| 89746 | 89746 | 107495 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4089 26TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | 5x5 | Permit Number 774317 | 6003351.8 | 2100635.3 | 37.7481341140921 | -122.431180836539 | (37.7481341140921, -122.431180836539) | |
| 27217 | 27217 | 230322 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 4089 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6003345.458190001 | 2100655.86235 | 37.7481902141138 | -122.43120423378299 | (37.7481902141138, -122.431204233783) | |||
| 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) | |||
| 171575 | 171575 | 230321 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1297 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003909.46951 | 2100753.0320099997 | 37.748488965296204 | -122.42926082853901 | (37.7484889652962, -122.429260828539) | |||
| 130198 | 130198 | 208841 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2134 09th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993696.59277 | 2101147.8080700003 | 37.74898945599679 | -122.46460515623001 | (37.7489894559968, -122.46460515623) | |||
| 131979 | 131979 | 230284 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1329 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009558.57595 | 2101226.99135 | 37.7501085417965 | -122.409759687386 | (37.7501085417965, -122.409759687386) | |||
| 49119 | 49119 | 65035 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1205 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51820 | 6003879.11104946 | 2101261.18670708 | 37.7498825208731 | -122.429402039878 | (37.7498825208731, -122.429402039878) | ||
| 28385 | 28385 | 230289 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3798 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6005260.07773 | 2101390.67485 | 37.750316153870294 | -122.424635797817 | (37.7503161538703, -122.424635797817) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");