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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4879 | 4879 | 171860 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 909 Woolsey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 2ft | 6009090.60075 | 2091384.92035 | 37.72305810822721 | -122.41068301413601 | (37.7230581082272, -122.410683014136) | |||
| 4921 | 4921 | 253716 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2959 21st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5x15 | 5989962.0 | 2095532.0 | 37.733353897105495 | -122.477108940264 | (37.7333538971055, -122.477108940264) | ||||
| 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) | ||
| 5041 | 5041 | 13058 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2016 12:00:00 AM | 3 | 3x3 | 6009536.2583 | 2120492.2964 | 37.803005290938394 | -122.411197584686 | (37.8030052909384, -122.411197584686) | ||
| 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 | |||||||||
| 5149 | 5149 | 229451 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 265 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6005008.0 | 2106862.0 | 37.7653248869664 | -122.425896916313 | (37.7653248869664, -122.425896916313) | |||
| 5162 | 5162 | 110966 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2445 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x5 | 6003013.8449 | 2116487.52825 | 37.791641287967 | -122.433482149098 | (37.791641287967, -122.433482149098) | |||
| 5291 | 5291 | 17848 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2090 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003963.2928 | 2115315.9593 | 37.78847827825761 | -122.430113454106 | (37.7884782782576, -122.430113454106) | |||
| 5356 | 5356 | 17193 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004642.48731 | 2116869.91995 | 37.792783506093706 | -122.427874318555 | (37.7927835060937, -122.427874318555) | |||
| 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) |
| 5502 | 5502 | 1908 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 35 Beideman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001516.9911 | 2113051.8602 | 37.782122787571 | -122.438414983045 | (37.782122787571, -122.438414983045) | |||
| 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) | |||
| 5750 | 5750 | 113067 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 170 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6002551.458330001 | 2119026.31072 | 37.7985858824821 | -122.435263675492 | (37.7985858824821, -122.435263675492) | |||
| 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) | |||
| 6117 | 6117 | 2621 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1806 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6004737.1436 | 2115078.0261 | 37.78786877138371 | -122.427419093403 | (37.7878687713837, -122.427419093403) | |||
| 6118 | 6118 | 98490 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1815 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773915 | 5999966.14399 | 2115303.99268 | 37.788218224545005 | -122.443942059503 | (37.788218224545, -122.443942059503) | |
| 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) | |
| 6185 | 6185 | 17854 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2110 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 6003813.5023 | 2115294.8194 | 37.7884117486508 | -122.430630196593 | (37.7884117486508, -122.430630196593) | |||
| 6236 | 6236 | 113401 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1620 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3x3 | 6006660.9339 | 2116485.9449 | 37.7918431849995 | -122.420863117756 | (37.7918431849995, -122.420863117756) | |||
| 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) | |||
| 6424 | 6424 | 29121 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6008434.8728 | 2114228.13336 | 37.7857436131333 | -122.414565426956 | (37.7857436131333, -122.414565426956) | ||
| 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 | |||||||||
| 6606 | 6606 | 110464 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2820 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000086.68948 | 2117131.47994 | 37.793242901382 | -122.44365632957899 | (37.793242901382, -122.443656329579) | |||
| 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) | ||
| 6663 | 6663 | 17852 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2105 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003811.8281 | 2115238.2923 | 37.7882564446804 | -122.430631953837 | (37.7882564446804, -122.430631953837) | |||
| 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 | |||||||||
| 7098 | 7098 | 98592 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2331 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2015 12:00:00 AM | 3 | 5x5 | Permit Number 774879 | 6003024.44034 | 2116816.90003 | 37.7925462595429 | -122.43346903696998 | (37.7925462595429, -122.43346903697) | |
| 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) | |
| 7553 | 7553 | 142835 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1515 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Width 0ft | 6006663.5874 | 2116129.9342 | 37.7908658176323 | -122.42082865045799 | (37.7908658176323, -122.420828650458) | ||||
| 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) | ||
| 7742 | 7742 | 17849 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2098 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003937.153 | 2115309.199 | 37.7884582356735 | -122.43020341123001 | (37.7884582356735, -122.43020341123) | |||
| 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) | |||
| 7897 | 7897 | 2622 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1806 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004719.8929 | 2115076.5886 | 37.787863848693796 | -122.427478675215 | (37.7878638486938, -122.427478675215) | |||
| 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) | |||
| 7977 | 7977 | 121363 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2235 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 4x4 | 6003480.6040199995 | 2116883.14161 | 37.792754011941106 | -122.431895428424 | (37.7927540119411, -122.431895428424) | |||
| 8036 | 8036 | 116472 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 825 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009953.87046 | 2116097.82442 | 37.7909625570162 | -122.40944210258999 | (37.7909625570162, -122.40944210259) | |||
| 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) | |||
| 8112 | 8112 | 36618 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 8133 | 8133 | 5227 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1045 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1990 12:00:00 AM | 4 | 3X3 | 6001390.1765 | 2112022.1316 | 37.779288200344894 | -122.438779891576 | (37.7792882003449, -122.438779891576) | ||
| 8143 | 8143 | 53665 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1540 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/1969 12:00:00 AM | Permit Number 6603 | 6006700.2941 | 2116215.7306 | 37.791103462133705 | -122.420707740038 | (37.7911034621337, -122.420707740038) | |||
| 8262 | 8262 | 18970 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6000791.352940001 | 2115572.7233700003 | 37.789003126734706 | -122.441106270442 | (37.7890031267347, -122.441106270442) | |||
| 8285 | 8285 | 112347 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 21 Perine Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6002122.29425 | 2115555.10135 | 37.7890304607445 | -122.436500134475 | (37.7890304607445, -122.436500134475) | |||
| 8310 | 8310 | 110965 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2445 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | 5x5 | 6003004.00297 | 2116485.50112 | 37.791635163595096 | -122.433516057127 | (37.7916351635951, -122.433516057127) | |||
| 8425 | 8425 | 60186 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2440 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1982 12:00:00 AM | 14 | 4x4 | Permit Number 19730 | 6002369.68995 | 2116773.36894 | 37.7923895652649 | -122.435731376003 | (37.7923895652649, -122.435731376003) | |
| 8480 | 8480 | 5228 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1045 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | 2 | 3X3 | 6001391.6981 | 2112008.1837 | 37.77924998951 | -122.438773627985 | (37.77924998951, -122.438773627985) | ||
| 8530 | 8530 | 17824 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1916 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/1994 12:00:00 AM | 12 | 3X3 | 6004630.1566 | 2115406.5655 | 37.7887648065492 | -122.427812667349 | (37.7887648065492, -122.427812667349) | ||
| 8544 | 8544 | 110463 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2820 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000109.08248 | 2117133.8316 | 37.7932506355596 | -122.443579017584 | (37.7932506355596, -122.443579017584) | |||
| 8601 | 8601 | 103873 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1331 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006745.9342 | 2115531.8344 | 37.789228224750296 | -122.42050126058999 | (37.7892282247503, -122.42050126059) | ||
| 8652 | 8652 | 17853 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2107 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003780.8726 | 2115230.9219 | 37.7882344536868 | -122.430738528508 | (37.7882344536868, -122.430738528508) | |||
| 8688 | 8688 | 19233 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 605 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1992 12:00:00 AM | 6 | 3X3 | 6002090.2242 | 2110622.18 | 37.7754840861265 | -122.436257924088 | (37.7754840861265, -122.436257924088) | ||
| 8704 | 8704 | 108300 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2898 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | Permit Number 773671 | 6000965.8204 | 2115920.74629 | 37.789968643383204 | -122.440527608864 | (37.7899686433832, -122.440527608864) | ||
| 8749 | 8749 | 94239 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2517 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 18 | 3x3 | Permit Number 53613 | 6001890.99196 | 2116983.8431599997 | 37.792940270517995 | -122.437402758825 | (37.792940270518, -122.437402758825) | |
| 8755 | 8755 | 110066 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2800 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775072 | 6000181.955 | 2117156.2585 | 37.79331636970829 | -122.443328486221 | (37.7933163697083, -122.443328486221) |
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");