Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||
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) | ||
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) | ||
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) | ||
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) | |||
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) | |
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) | |
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) | ||||
28898 | 28898 | 250221 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 312 Filbert St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6011282.00764 | 2120080.85256 | 37.8019733165766 | -122.405127362244 | (37.8019733165766, -122.405127362244) | |||
60128 | 60128 | 250187 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 665 Parker Ave | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 5997222.68042 | 2110871.6887 | 37.7758914096851 | -122.453113845732 | (37.7758914096851, -122.453113845732) | |||
169196 | 169196 | 250186 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 665 Parker Ave | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5997220.39466 | 2110886.1472400003 | 37.7759309780695 | -122.4531227967 | (37.7759309780695, -122.4531227967) | |||
68072 | 68072 | 250185 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 665 Parker Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5997218.614440001 | 2110901.95743 | 37.7759742867055 | -122.453130096488 | (37.7759742867055, -122.453130096488) | |||
44983 | 44983 | 250184 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 665 Parker Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5997216.13133 | 2110917.44789 | 37.7760166771611 | -122.45313980466699 | (37.7760166771611, -122.453139804667) | |||
165775 | 165775 | 249954 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 303 Filbert St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 0ft | 6011374.5207 | 2120037.6372700003 | 37.8018598293151 | -122.404804177386 | (37.8018598293151, -122.404804177386) | |||
64441 | 64441 | 249953 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 303 Filbert St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 0ft | 6011372.652369999 | 2120041.55492 | 37.8018704817969 | -122.40481091868901 | (37.8018704817969, -122.404810918689) | |||
71813 | 71813 | 249952 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 303 Filbert St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 0ft | 6011371.46837 | 2120040.8031 | 37.801868351303796 | -122.40481496294399 | (37.8018683513038, -122.404814962944) | |||
75481 | 75481 | 249813 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 260 Chestnut St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6010621.11973 | 2121031.8935700003 | 37.8045476726861 | -122.407481446514 | (37.8045476726861, -122.407481446514) | |||
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) | |
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) | |||
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) | |||
49219 | 49219 | 247756 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 52 Alpine Ter | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6001615.48849 | 2108494.65039 | 37.7696154359451 | -122.437747736977 | (37.7696154359451, -122.437747736977) | |||
153633 | 153633 | 247755 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 52 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6001613.95356 | 2108514.35375 | 37.7696694492075 | -122.43775445760299 | (37.7696694492075, -122.437754457603) | |||
164978 | 164978 | 246941 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 269 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5998752.122880001 | 2107600.5740099996 | 37.7669972990085 | -122.447587610674 | (37.7669972990085, -122.447587610674) | |||
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) | |||
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) | |||
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) | |
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) | |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
151066 | 151066 | 230349 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 222 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001969.40377 | 2096197.83075 | 37.735871425709995 | -122.43564368671801 | (37.73587142571, -122.435643686718) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
181671 | 181671 | 230338 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 31 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003171.4913099995 | 2108119.01737 | 37.7686723924455 | -122.43233874923 | (37.7686723924455, -122.43233874923) | |||
42139 | 42139 | 230337 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 823 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002470.86224 | 2103420.79735 | 37.7557324674964 | -122.43442621241199 | (37.7557324674964, -122.434426212412) | |||
74944 | 74944 | 230336 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 823 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002471.62973 | 2103413.82046 | 37.7557133541918 | -122.434423059382 | (37.7557133541918, -122.434423059382) | |||
147958 | 147958 | 230335 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 823 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002473.18997 | 2103401.0764 | 37.7556784506177 | -122.434416752458 | (37.7556784506177, -122.434416752458) | |||
173292 | 173292 | 230334 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3817 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002957.98298 | 2102975.20169 | 37.7545366065863 | -122.43270976546499 | (37.7545366065863, -122.432709765465) | |||
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) | |||
48337 | 48337 | 230332 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 73 Leese St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005526.20735 | 2096295.99594 | 37.736342348511 | -122.423353372654 | (37.736342348511, -122.423353372654) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
175002 | 175002 | 230325 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 30 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6004684.33252 | 2103302.03118 | 37.7555317594992 | -122.426762864436 | (37.7555317594992, -122.426762864436) | |||
161292 | 161292 | 230324 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 14 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004676.492190001 | 2103485.42894 | 37.7560348834086 | -122.426803038952 | (37.7560348834086, -122.426803038952) | |||
50219 | 50219 | 230323 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 12 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004674.70805 | 2103511.60917 | 37.7561066672951 | -122.42681107348601 | (37.7561066672951, -122.426811073486) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
57885 | 57885 | 230313 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 968 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010194.52879 | 2103588.6082900004 | 37.756628635618604 | -122.40772701540399 | (37.7566286356186, -122.407727015404) | |||
133786 | 133786 | 230312 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2901 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009544.39548 | 2104509.50944 | 37.759120806308204 | -122.41004043054701 | (37.7591208063082, -122.410040430547) | |||
34741 | 34741 | 230311 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2901 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009504.69694 | 2104506.09173 | 37.7591091969416 | -122.41017748630101 | (37.7591091969416, -122.410177486301) | |||
164626 | 164626 | 230310 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 322 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005451.16912 | 2101791.33905 | 37.7514270756131 | -122.424003479091 | (37.7514270756131, -122.424003479091) | |||
151933 | 151933 | 230309 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3668 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005328.964269999 | 2101978.057 | 37.7519328597144 | -122.424439358013 | (37.7519328597144, -122.424439358013) | |||
165271 | 165271 | 230308 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3795 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6005100.08631 | 2104263.85733 | 37.7581962060976 | -122.42539350181801 | (37.7581962060976, -122.425393501818) | |||
75357 | 75357 | 230307 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 316 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006700.0483099995 | 2104252.32406 | 37.758254804122 | -122.419859309575 | (37.758254804122, -122.419859309575) | |||
74490 | 74490 | 230306 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 65 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005267.4467 | 2105080.91438 | 37.7604491067472 | -122.42487282493299 | (37.7604491067472, -122.424872824933) | |||
153672 | 153672 | 230305 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3689 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6005047.22841 | 2104845.66376 | 37.7597907229735 | -122.42561771539499 | (37.7597907229735, -122.425617715395) | |||
54472 | 54472 | 230304 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3689 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6005034.41688 | 2104845.09352 | 37.7597884333033 | -122.42566198362101 | (37.7597884333033, -122.425661983621) | |||
188778 | 188778 | 230303 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2784 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010083.7548 | 2102826.7491599997 | 37.7545305388726 | -122.40805638669501 | (37.7545305388726, -122.408056386695) | |||
187466 | 187466 | 230302 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2908 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009976.47339 | 2101651.34742 | 37.751297139764795 | -122.408344495308 | (37.7512971397648, -122.408344495308) | |||
147644 | 147644 | 230301 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1083 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010010.1738 | 2102926.1510900003 | 37.754799354323 | -122.40831786097999 | (37.754799354323, -122.40831786098) | |||
151893 | 151893 | 230300 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1225 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010064.03861 | 2101924.1335400003 | 37.7520510531386 | -122.408060919271 | (37.7520510531386, -122.408060919271) | |||
164901 | 164901 | 230299 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 590 York St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009785.6882 | 2105558.56974 | 37.762014809365 | -122.409279952113 | (37.762014809365, -122.409279952113) | |||
37460 | 37460 | 230298 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 613 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009857.38844 | 2105338.70025 | 37.761415114429795 | -122.409016453452 | (37.7614151144298, -122.409016453452) | |||
23594 | 23594 | 230297 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1171 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008685.11737 | 2101744.284 | 37.7514799242568 | -122.412816735721 | (37.7514799242568, -122.412816735721) | |||
59160 | 59160 | 230296 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3500 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006123.351530001 | 2104947.42015 | 37.7601308699707 | -122.421903157405 | (37.7601308699707, -122.421903157405) | |||
161500 | 161500 | 230295 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3500 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006165.1210199995 | 2104950.71502 | 37.7601422724637 | -122.42175893043199 | (37.7601422724637, -122.421758930432) | |||
165212 | 165212 | 230294 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3500 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006176.610669999 | 2104951.77673 | 37.760145835588006 | -122.421719268545 | (37.760145835588, -122.421719268545) | |||
184182 | 184182 | 230293 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3500 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006188.70146 | 2104951.15176 | 37.7601448013679 | -122.42167740779301 | (37.7601448013679, -122.421677407793) | |||
74024 | 74024 | 230292 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3500 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006199.95177 | 2104950.54929 | 37.760143781519496 | -122.42163845546499 | (37.7601437815195, -122.421638455465) | |||
174376 | 174376 | 230291 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 3623 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005393.28111 | 2105446.83582 | 37.7614609474791 | -122.424463649589 | (37.7614609474791, -122.424463649589) | |||
156468 | 156468 | 230290 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 59 Ramona Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005216.74861 | 2107488.55744 | 37.76705705897071 | -122.425219491113 | (37.7670570589707, -122.425219491113) |
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");