Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190 | 190 | 57209 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2898 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | Permit Number 773671 | 6000999.92024 | 2115926.87738 | 37.7899874194288 | -122.440410066565 | (37.7899874194288, -122.440410066565) | ||
430 | 430 | 103824 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006951.91038 | 2114418.6460599997 | 37.786183288961205 | -122.419709589538 | (37.7861832889612, -122.419709589538) | ||
768 | 768 | 13057 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 566 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2014 12:00:00 AM | 3 | 2x2 | 6009630.8999 | 2120542.6321 | 37.8031488074681 | -122.410873631329 | (37.8031488074681, -122.410873631329) | ||
878 | 878 | 108700 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3024 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772805 | 6001479.41501 | 2118822.32035 | 37.7979648412708 | -122.438958648025 | (37.7979648412708, -122.438958648025) |
943 | 943 | 17376 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1600 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Property owner contact Achmed 821-1594. | 6014810.6051199995 | 2095342.4042099998 | 37.7342436096391 | -122.391186437905 | (37.7342436096391, -122.391186437905) | ||
1179 | 1179 | 40176 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3591 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1999 12:00:00 AM | 7 | 4X4 | Permit Number 41367 | 5997123.1138 | 2115994.68514 | 37.7899520976567 | -122.453828309438 | (37.7899520976567, -122.453828309438) | |
1329 | 1329 | 108251 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2342 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2014 12:00:00 AM | 3 | Permit Number 772707 | 6003487.823480001 | 2116598.59659 | 37.791973133309796 | -122.43185012238199 | (37.7919731333098, -122.431850122382) | ||
1396 | 1396 | 21755 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2350 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008465.3581 | 2120976.6726 | 37.8042751503167 | -122.414937771753 | (37.8042751503167, -122.414937771753) | |||
2176 | 2176 | 103962 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3240 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | Permit Number 780028 | 5998623.05948 | 2116578.56663 | 37.7916411629484 | -122.448680722253 | (37.7916411629484, -122.448680722253) | ||
2187 | 2187 | 47144 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3240 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780028 | 5998645.601919999 | 2116582.6217400003 | 37.7916535861885 | -122.448603018129 | (37.7916535861885, -122.448603018129) | |
2241 | 2241 | 193105 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1649 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 10/28/1996 12:00:00 AM | 10 | Width 5ft | 6014582.89152 | 2095437.7386599998 | 37.734492738953 | -122.39198038730301 | (37.734492738953, -122.391980387303) | ||
2357 | 2357 | 39974 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 0 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
2473 | 2473 | 253095 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1201 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779996 | 5987047.82966 | 2107087.0186099997 | 37.7649113707945 | -122.488032657316 | (37.7649113707945, -122.488032657316) | |
2679 | 2679 | 21616 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005148.1308 | 2114788.2908 | 37.7870964664996 | -122.425976519639 | (37.7870964664996, -122.425976519639) | |||
2802 | 2802 | 229983 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 568 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1982 12:00:00 AM | 15 | Width 2ft | Permit Number 19661 | 6003129.342019999 | 2095763.1248 | 37.7347436380916 | -122.43160229890499 | (37.7347436380916, -122.431602298905) | |
2807 | 2807 | 229984 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 570 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 15 | Width 2ft | Permit Number 18749 | 6003101.73362 | 2095751.10024 | 37.734709056481705 | -122.431696892311 | (37.7347090564817, -122.431696892311) | |
2809 | 2809 | 229980 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 542 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1982 12:00:00 AM | 15 | Width 3ft | Permit Number 19660 | 6003257.39485 | 2095864.5781900003 | 37.735029463323 | -122.431166815702 | (37.735029463323, -122.431166815702) | |
2813 | 2813 | 229987 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 581 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 13 | Width 2ft | Permit Number 18753 | 6003140.984180001 | 2095726.54341 | 37.734643853813296 | -122.431559437241 | (37.7346438538133, -122.431559437241) | |
2818 | 2818 | 229986 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 599 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1984 12:00:00 AM | 9 | Width 2ft | Permit Number 21284 | 6003081.800919999 | 2095704.053 | 37.734578745606704 | -122.431762448377 | (37.7345787456067, -122.431762448377) | |
2820 | 2820 | 229988 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 569 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 10 | Width 2ft | Permit Number 18752 | 6003200.6174 | 2095770.85092 | 37.734768891957394 | -122.43135642697099 | (37.7347688919574, -122.431356426971) | |
2821 | 2821 | 229978 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 530 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 16 | Width 2ft | Permit Number 18745 | 6003326.59414 | 2095915.8411400001 | 37.735174140867294 | -122.43093122660801 | (37.7351741408673, -122.430931226608) | |
2822 | 2822 | 229979 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 536 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1982 12:00:00 AM | 11 | Width 3ft | Permit Number 19659 | 6003305.39384 | 2095901.6279 | 37.7351339132885 | -122.431003509611 | (37.7351339132885, -122.431003509611) | |
2831 | 2831 | 229982 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 560 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 12 | Width 2ft | Permit Number 18747 | 6003179.1898 | 2095802.1923599998 | 37.734853734004105 | -122.431432746149 | (37.7348537340041, -122.431432746149) | |
2836 | 2836 | 229976 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 506 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1983 12:00:00 AM | 13 | Width 2ft | Permit Number 20257 | 6003460.201330001 | 2096023.8631099998 | 37.7354783140686 | -122.430477003328 | (37.7354783140686, -122.430477003328) | |
2838 | 2838 | 229981 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 556 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 14 | Width 3ft | Permit Number 18746 | 6003219.85889 | 2095834.25264 | 37.7349440691062 | -122.431294426813 | (37.7349440691062, -122.431294426813) | |
2840 | 2840 | 229977 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 522 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 14 | Width 2ft | Permit Number 18744 | 6003363.64026 | 2095947.4621700002 | 37.7352630640274 | -122.43080540066099 | (37.7352630640274, -122.430805400661) | |
2938 | 2938 | 60590 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 601 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 14 | 4x4 | Permit Number 20209 | 6000481.0 | 2111039.0 | 37.77653700517929 | -122.441854521628 | (37.7765370051793, -122.441854521628) |
3365 | 3365 | 229966 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 278 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 17 | Width 3ft | Permit Number 18733 | 6004468.47248 | 2096814.7875400002 | 37.7377070787211 | -122.42704734426 | (37.7377070787211, -122.42704734426) | |
3456 | 3456 | 27619 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2799X Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001525.7969 | 2115623.6000599996 | 37.7891846270188 | -122.438568843173 | (37.7891846270188, -122.438568843173) | |||
3473 | 3473 | 8205 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1374 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/2006 12:00:00 AM | 30 | 3X3 | 6001195.167 | 2111111.9943 | 37.7767780974284 | -122.43938925166599 | (37.7767780974284, -122.439389251666) | ||
3593 | 3593 | 108302 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2200X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | Permit Number 773671 | 6000905.886 | 2115941.06387 | 37.7900210171946 | -122.440736434162 | (37.7900210171946, -122.440736434162) | ||
3616 | 3616 | 97137 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2929 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 24 | 3x3 | Permit Number 776885 | 6000677.09541 | 2116163.2813 | 37.790618136459706 | -122.441543981264 | (37.7906181364597, -122.441543981264) | |
3678 | 3678 | 208759 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 300 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/24/2005 12:00:00 AM | 2 | Width 3ft | Permit Number 48287 | 5993126.46853 | 2099702.60224 | 37.7449884054972 | -122.466471606489 | (37.7449884054972, -122.466471606489) | |
3821 | 3821 | 46195 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
3888 | 3888 | 229599 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 955 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2000 12:00:00 AM | 2 | Width 4ft | Permit Number 43291 | 5999204.37358 | 2106797.0588 | 37.7648168837066 | -122.44596555389 | (37.7648168837066, -122.44596555389) | |
4777 | 4777 | 177351 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 501X San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | 4 | Width 3ft | Permit Number 48612 | 6000375.5599 | 2092850.3110099998 | 37.7265892548896 | -122.440914152761 | (37.7265892548896, -122.440914152761) | |
4783 | 4783 | 177353 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 501X San Juan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | 7 | Width 3ft | Permit Number 48612 | 6000427.73907 | 2092811.4085099997 | 37.726485409251794 | -122.44073098247401 | (37.7264854092518, -122.440730982474) | |
4824 | 4824 | 177352 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 501X San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | 8 | Width 3ft | Permit Number 48612 | 6000403.69972 | 2092831.46295 | 37.7265391050915 | -122.44081552323999 | (37.7265391050915, -122.44081552324) | |
4942 | 4942 | 58811 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2049 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2014 12:00:00 AM | 3 | Permit Number 773701 | 6003239.80181 | 2118222.27779 | 37.796417281581505 | -122.432824322909 | (37.7964172815815, -122.432824322909) | ||
5098 | 5098 | 253771 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 844 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2017 12:00:00 AM | 3 | 3x3 | 6008309.10382 | 2120362.6037 | 37.802580290063 | -122.41543500385 | (37.802580290063, -122.41543500385) | ||
5109 | 5109 | 36635 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
5381 | 5381 | 103000 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2440 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | Permit Number 19730 | 6002354.34125 | 2116771.6973599996 | 37.7923841036956 | -122.435784363176 | (37.7923841036956, -122.435784363176) | ||
5435 | 5435 | 33143 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2272 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 14 | 4x4 | Permit Number 37369 | 6002130.31107 | 2118463.23451 | 37.7970158973151 | -122.43668064819401 | (37.7970158973151, -122.436680648194) |
5511 | 5511 | 27288 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005131.3442 | 2114782.5023 | 37.78707962400679 | -122.426034185389 | (37.7870796240068, -122.426034185389) | |||
5578 | 5578 | 18957 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2870 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2000 12:00:00 AM | 3 | 3X3 | 6001094.21569 | 2115613.50067 | 37.789132336830605 | -122.44006133289 | (37.7891323368306, -122.44006133289) | ||
5593 | 5593 | 103823 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006948.133219999 | 2114434.09135 | 37.7862254851663 | -122.419723753855 | (37.7862254851663, -122.419723753855) | ||
5724 | 5724 | 18967 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X5 | 6000819.2901800005 | 2115577.18131 | 37.789016958326705 | -122.44100993146999 | (37.7890169583267, -122.44100993147) | |||
5776 | 5776 | 18968 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X5 | 6000810.83314 | 2115575.0283 | 37.789010565033294 | -122.44103903711901 | (37.7890105650333, -122.441039037119) | |||
5806 | 5806 | 103783 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1233 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006792.9578 | 2115204.8755 | 37.788333126211796 | -122.42031534861601 | (37.7883331262118, -122.420315348616) | ||
5809 | 5809 | 46193 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
5842 | 5842 | 103829 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006929.69351 | 2114192.11644 | 37.7855600426056 | -122.41977037472 | (37.7855600426056, -122.41977037472) | ||
5900 | 5900 | 27618 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2799X Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 6 | 3X3 | 6001512.5153 | 2115623.04918 | 37.789182358914 | -122.43861475628799 | (37.789182358914, -122.438614756288) | ||
5915 | 5915 | 84945 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1812 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49349 | 6003466.4043 | 2115034.3792 | 37.7876769759783 | -122.431812496651 | (37.7876769759783, -122.431812496651) | |
6031 | 6031 | 27339 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 640 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6004290.4577 | 2110500.9764 | 37.7752760561488 | -122.428638148774 | (37.7752760561488, -122.428638148774) | |||
6146 | 6146 | 97674 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2619 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768452 | 5999883.3195 | 2113998.3376 | 37.7846285104726 | -122.444134760871 | (37.7846285104726, -122.444134760871) | |
6157 | 6157 | 117446 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1442 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778580 | 6007836.0514 | 2116543.8472700003 | 37.792068336434205 | -122.416801303441 | (37.7920683364342, -122.416801303441) | ||
6175 | 6175 | 18989 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2949 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 12 | 3x3 | Permit Number 49846 | 6000698.465009999 | 2115512.61265 | 37.78883278704021 | -122.44142333452 | (37.7888327870402, -122.44142333452) | |
6261 | 6261 | 58063 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1747 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1977 12:00:00 AM | 12 | Permit Number 17033 | 5999523.022000001 | 2114932.0979 | 37.7871718119958 | -122.445448429932 | (37.7871718119958, -122.445448429932) | ||
6278 | 6278 | 103957 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2465 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770692 | 6002902.62076 | 2116470.8664700002 | 37.7915892279996 | -122.433865791789 | (37.7915892279996, -122.433865791789) | |
6300 | 6300 | 103795 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1215 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006811.4062 | 2115079.7468 | 37.78799059318229 | -122.42024263571899 | (37.7879905931823, -122.420242635719) | ||
6326 | 6326 | 58062 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1732 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1977 12:00:00 AM | 10 | 3x3 | Permit Number 17032 | 5999582.2359 | 2114859.9248 | 37.78697702365571 | -122.44523837241199 | (37.7869770236557, -122.445238372412) | |
6329 | 6329 | 18985 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2926 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1997 12:00:00 AM | 3 | 3X3 | 6000546.31871 | 2115537.57863 | 37.7888926683961 | -122.441951530652 | (37.7888926683961, -122.441951530652) | ||
6415 | 6415 | 18972 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6000755.04185 | 2115567.80541 | 37.7889875549728 | -122.441231548694 | (37.7889875549728, -122.441231548694) | |||
6461 | 6461 | 34901 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
6648 | 6648 | 103825 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006956.54225 | 2114398.79268 | 37.786129037366294 | -122.41969215528 | (37.7861290373663, -122.41969215528) | ||
6684 | 6684 | 38517 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2150 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/29/1998 12:00:00 AM | 25 | 6x6 | Permit Number 40504 | 5997521.1508 | 2110251.9474 | 37.77420686213429 | -122.45203664156999 | (37.7742068621343, -122.45203664157) |
6707 | 6707 | 97136 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2929 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 24 | 3x3 | Permit Number 776885 | 6000665.32299 | 2116159.50281 | 37.790607091004404 | -122.441584441793 | (37.7906070910044, -122.441584441793) | |
6781 | 6781 | 28297 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 886 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2003 12:00:00 AM | 3 | 3X3 | 6003187.6794 | 2110345.6225 | 37.77478702085 | -122.43244181014799 | (37.77478702085, -122.432441810148) | ||
6889 | 6889 | 27340 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 646 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004269.3633 | 2110497.2933 | 37.7752647494287 | -122.428710856528 | (37.7752647494287, -122.428710856528) | ||
6892 | 6892 | 36621 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
6926 | 6926 | 18969 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6000801.71475 | 2115573.33512 | 37.78900539663729 | -122.44107046394501 | (37.7890053966373, -122.441070463945) | |||
7024 | 7024 | 34903 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
7168 | 7168 | 18966 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6000828.50108 | 2115578.8735599997 | 37.789022129422 | -122.440978184497 | (37.789022129422, -122.440978184497) | |||
7196 | 7196 | 53176 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 3 | 3x3 | Permit Number 49094 | 5998327.8723 | 2109933.5008 | 37.7733786657012 | -122.449223112808 | (37.7733786657012, -122.449223112808) |
7287 | 7287 | 82972 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2808 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775067 | 6000141.37646 | 2117136.25898 | 37.79325914223679 | -122.44346745307199 | (37.7932591422368, -122.443467453072) | |
7301 | 7301 | 103830 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006932.57902 | 2114171.45975 | 37.785503486943604 | -122.419758925448 | (37.7855034869436, -122.419758925448) | ||
7335 | 7335 | 21613 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1990 12:00:00 AM | 3 | 3X3 | 6005201.9639 | 2114793.5005 | 37.7871138132891 | -122.42579063980499 | (37.7871138132891, -122.425790639805) | ||
7343 | 7343 | 58834 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1864 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1979 12:00:00 AM | 14 | 3x3 | Permit Number 772490 | 6003989.96335 | 2119411.99542 | 37.7997264575584 | -122.430313528149 | (37.7997264575584, -122.430313528149) | |
7345 | 7345 | 27341 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 646 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004251.9521 | 2110495.2843 | 37.7752582477922 | -122.4287709426 | (37.7752582477922, -122.4287709426) | ||
7381 | 7381 | 50780 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2257 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47307 | 6002153.86522 | 2118764.0547700003 | 37.7978432097613 | -122.436620688605 | (37.7978432097613, -122.436620688605) | |
7388 | 7388 | 5226 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1031 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | 3 | 3X3 | 6001391.1909 | 2111988.4032 | 37.779195648412 | -122.43877396477501 | (37.779195648412, -122.438773964775) | ||
7394 | 7394 | 21614 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005184.5984 | 2114790.6062 | 37.787104884924204 | -122.42585051456699 | (37.7871048849242, -122.425850514567) | |||
7487 | 7487 | 21615 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005165.4963 | 2114788.8697 | 37.7870990374175 | -122.425916480019 | (37.7870990374175, -122.425916480019) | |||
7504 | 7504 | 58099 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 864X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1977 12:00:00 AM | 22 | 4x4 | Permit Number 17073 | 6006749.38738 | 2113618.48291 | 37.7839748265105 | -122.42035345285 | (37.7839748265105, -122.42035345285) | |
7506 | 7506 | 14836 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1300 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 10/22/2008 12:00:00 AM | 9 | 3X3 | 6002892.8097 | 2111692.1261 | 37.7784674596438 | -122.43355807318501 | (37.7784674596438, -122.433558073185) | |
7542 | 7542 | 94240 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2517 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 18 | 3x3 | Permit Number 53613 | 6001913.777980001 | 2116990.9963700003 | 37.792961206750604 | -122.437324430597 | (37.7929612067506, -122.437324430597) | |
7600 | 7600 | 2716 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2178 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003083.0342 | 2114847.1509 | 37.7871411551889 | -122.433125499331 | (37.7871411551889, -122.433125499331) | |||
7606 | 7606 | 27342 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 658 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1998 12:00:00 AM | 3 | 4X4 | 6004212.4421 | 2110492.9405 | 37.7752495760457 | -122.428907449576 | (37.7752495760457, -122.428907449576) | ||
7774 | 7774 | 103816 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1100 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006901.46306 | 2114785.14538 | 37.7871867641959 | -122.41991014106002 | (37.7871867641959, -122.41991014106) | ||
7775 | 7775 | 27289 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005110.5056 | 2114781.9235 | 37.7870768570073 | -122.42610624116101 | (37.7870768570073, -122.426106241161) | |||
7813 | 7813 | 18956 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2867 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 3x3 | 6001086.2115 | 2115563.33325 | 37.788994134415496 | -122.440085427516 | (37.7889941344155, -122.440085427516) | ||
7835 | 7835 | 103691 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 136 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2013 12:00:00 AM | 2 | 2x4 | Permit Number 768685 | 6002704.424240001 | 2119047.06433 | 37.7986515518927 | -122.434735850806 | (37.7986515518927, -122.434735850806) | |
7843 | 7843 | 18977 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2912 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000739.52312 | 2115564.90607 | 37.788978710133 | -122.44128503318599 | (37.788978710133, -122.441285033186) | |||
7885 | 7885 | 21612 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005218.1717 | 2114795.8159 | 37.7871210866889 | -122.4257347292 | (37.7871210866889, -122.4257347292) | |||
7957 | 7957 | 21757 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2350 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008462.5324 | 2121012.4644 | 37.8043732668186 | -122.414950085154 | (37.8043732668186, -122.414950085154) | |||
8052 | 8052 | 3037 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2611 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X2 | 6001770.5365 | 2115308.215 | 37.7883325797422 | -122.437699479333 | (37.7883325797422, -122.437699479333) | |||
8059 | 8059 | 34906 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | Permit Number 38505 | |||||||||
8080 | 8080 | 18902 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2599 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002415.46801 | 2115750.47994 | 37.7895835752639 | -122.43549977541599 | (37.7895835752639, -122.435499775416) | |||
8090 | 8090 | 18971 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000776.930509999 | 2115571.586 | 37.7889991823101 | -122.44115608838301 | (37.7889991823101, -122.441156088383) | |||
8101 | 8101 | 18925 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2679 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002005.1865 | 2115691.57373 | 37.7893985235705 | -122.43691508526301 | (37.7893985235705, -122.436915085263) |
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");