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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
45187 | 45187 | 180215 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 67 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008244.87242 | 2086654.9382900002 | 37.710023111457296 | -122.41327221445499 | (37.7100231114573, -122.413272214455) | |||
181006 | 181006 | 179982 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Whittier St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5998163.8312800005 | 2086864.4965400002 | 37.710027374234706 | -122.44812917073901 | (37.7100273742347, -122.448129170739) | |||
148139 | 148139 | 30545 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34540 | 6011719.78338 | 2086594.44223 | 37.710051482356796 | -122.40125793021099 | (37.7100514823568, -122.401257930211) | ||
13002 | 13002 | 15914 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5694X Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/17/1995 12:00:00 AM | 8 | 3x3 | 5997854.28803 | 2086889.6248700002 | 37.71007867067 | -122.449200816374 | (37.71007867067, -122.449200816374) | ||
43977 | 43977 | 179983 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Whittier St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5998155.09065 | 2086884.2051799998 | 37.710080990013296 | -122.448160798105 | (37.7100809900133, -122.448160798105) | |||
33733 | 33733 | 180185 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2500 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010852.50351 | 2086625.63078 | 37.7100886954045 | -122.404257627902 | (37.7100886954045, -122.404257627902) | |||
138238 | 138238 | 30544 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401 Tunnel Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 10 | Permit Number 34540 | 6011720.93771 | 2086611.92604 | 37.7100995538248 | -122.401255168406 | (37.7100995538248, -122.401255168406) | ||
13230 | 13230 | 15913 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5694X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1995 12:00:00 AM | 6 | 3x3 | 5997872.7460900005 | 2086897.52065 | 37.7101014064224 | -122.44913759043999 | (37.7101014064224, -122.44913759044) | ||
99052 | 99052 | 180214 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 61 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008256.77817 | 2086683.98233 | 37.7101035288322 | -122.41323311821999 | (37.7101035288322, -122.41323311822) | |||
4259 | 4259 | 252872 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5700 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:41:00 PM | 3 | 3x3 | 5997704.0 | 2086907.0 | 37.7101177815644 | -122.449721490093 | (37.7101177815644, -122.449721490093) | ||
94252 | 94252 | 51973 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1x FARRAGUT AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2005 12:00:00 AM | Permit Number 48194 | 5997704.0 | 2086907.0 | 37.7101177815644 | -122.449721490093 | (37.7101177815644, -122.449721490093) | |||
110895 | 110895 | 51975 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1x FARRAGUT AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2005 12:00:00 AM | Permit Number 48194 | 5997704.0 | 2086907.0 | 37.7101177815644 | -122.449721490093 | (37.7101177815644, -122.449721490093) | |||
4473 | 4473 | 180841 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Farragut Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 12:10:00 PM | 3 | Width 2ft | 5997726.08242 | 2086911.31353 | 37.710130888906896 | -122.449645479868 | (37.7101308889069, -122.449645479868) | ||
27182 | 27182 | 15918 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5688X Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 5997918.76709 | 2086907.8121 | 37.710132296496894 | -122.44897927437799 | (37.7101322964969, -122.448979274378) | |||
84455 | 84455 | 15917 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5688X Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2011 12:00:00 AM | 3 | 3x3 | 5997918.76709 | 2086907.8121 | 37.710132296496894 | -122.44897927437799 | (37.7101322964969, -122.448979274378) | ||
111411 | 111411 | 15916 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5688X Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2011 12:00:00 AM | 3 | 3x3 | 5997918.76709 | 2086907.8121 | 37.710132296496894 | -122.44897927437799 | (37.7101322964969, -122.448979274378) | ||
12803 | 12803 | 15912 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5694X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1995 12:00:00 AM | 6 | 3x3 | 5997904.34067 | 2086910.6630000002 | 37.7101392993469 | -122.449029339958 | (37.7101392993469, -122.449029339958) | ||
169989 | 169989 | 179984 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Whittier St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5998143.81112 | 2086907.5465900002 | 37.710144435400295 | -122.44820146183201 | (37.7101444354003, -122.448201461832) | |||
28554 | 28554 | 180213 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 57 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008263.9243 | 2086701.53775 | 37.7101521335973 | -122.413209660291 | (37.7101521335973, -122.413209660291) | |||
78477 | 78477 | 99570 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
86231 | 86231 | 99568 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
96638 | 96638 | 99562 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
98094 | 98094 | 99575 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
111968 | 111968 | 99569 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
124043 | 124043 | 99572 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
125970 | 125970 | 99571 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
140140 | 140140 | 99566 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
72783 | 72783 | 179985 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Whittier St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5998139.51533 | 2086920.9795799998 | 37.7101810737559 | -122.448217275509 | (37.7101810737559, -122.448217275509) | |||
133875 | 133875 | 180007 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Farragut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997703.617219999 | 2086934.20431 | 37.71019245649521 | -122.449724772183 | (37.7101924564952, -122.449724772183) | |||
4466 | 4466 | 180840 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Farragut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 12:05:00 PM | 3 | Width 2ft | 5997679.45955 | 2086959.0123599998 | 37.7102591915804 | -122.449810052203 | (37.7102591915804, -122.449810052203) | ||
12959 | 12959 | 15911 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5694X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1995 12:00:00 AM | 6 | 3x3 | 5997980.63633 | 2086954.0637299998 | 37.7102628311224 | -122.44876877216801 | (37.7102628311224, -122.448768772168) | ||
186303 | 186303 | 65735 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 381 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 9 | Permit Number 28671 | 6000320.2870000005 | 2086910.79586 | 37.710277542235396 | -122.440679381145 | (37.7102775422354, -122.440679381145) | |
11355 | 11355 | 15910 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5694X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1995 12:00:00 AM | 6 | 3x3 | 5997998.29527 | 2086965.8977599998 | 37.7102963344846 | -122.448708591324 | (37.7102963344846, -122.448708591324) | ||
81587 | 81587 | 39205 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2188 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996320.5 | 2087005.2 | 37.7103081651051 | -122.454510201448 | (37.7103081651051, -122.454510201448) | |
95347 | 95347 | 39209 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2188 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996320.5 | 2087005.2 | 37.7103081651051 | -122.454510201448 | (37.7103081651051, -122.454510201448) | |
4324 | 4324 | 251737 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 228 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:13:00 AM | 3 | 3x3 | 6002872.0 | 2086877.0 | 37.7103297297312 | -122.43185773233601 | (37.7103297297312, -122.431857732336) | ||
174446 | 174446 | 36237 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5680 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | 5 | Permit Number 39265 | 5998017.05297 | 2086978.6282900001 | 37.7103323622296 | -122.44864467742599 | (37.7103323622296, -122.448644677426) | ||
11370 | 11370 | 39202 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2188 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996345.10254 | 2087018.18263 | 37.7103452234142 | -122.454426107682 | (37.7103452234142, -122.454426107682) | |
177445 | 177445 | 65734 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 366 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 7 | Permit Number 28670 | 6000278.09754 | 2086937.20541 | 37.710347654302794 | -122.440827089403 | (37.7103476543028, -122.440827089403) | |
166922 | 166922 | 180167 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 388 Pope St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000605.77227 | 2086933.0298099997 | 37.7103548452706 | -122.43969428086099 | (37.7103548452706, -122.439694280861) | |||
41283 | 41283 | 180212 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 51 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008290.64939 | 2086775.65834 | 37.7103571538246 | -122.413122530382 | (37.7103571538246, -122.413122530382) | |||
13081 | 13081 | 39204 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200X Sickles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996296.13951 | 2087023.8998599998 | 37.710358113413704 | -122.454595745896 | (37.7103581134137, -122.454595745896) | |
76390 | 76390 | 36238 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5680 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | 3 | Permit Number 39265 | 5998035.86448 | 2086989.70728 | 37.7103638582632 | -122.44858045862101 | (37.7103638582632, -122.448580458621) | ||
61398 | 61398 | 180166 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 388 Pope St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000602.0664 | 2086944.56458 | 37.710386306254 | -122.43970791550801 | (37.710386306254, -122.439707915508) | |||
4433 | 4433 | 180628 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 339 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:40:00 AM | 3 | Width 8ft | 6001976.18123 | 2086917.49182 | 37.710390087913794 | -122.43495675757299 | (37.7103900879138, -122.434956757573) | ||
185100 | 185100 | 36239 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5680 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | 5 | Permit Number 39265 | 5998053.6023 | 2087000.49619 | 37.7103944963771 | -122.448519929767 | (37.7103944963771, -122.448519929767) | ||
3423 | 3423 | 251752 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | ||||
3432 | 3432 | 180655 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | |||
3488 | 3488 | 251753 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | ||||
31317 | 31317 | 180012 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2168 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5996377.63541 | 2087048.98271 | 37.710431659053604 | -122.454315891261 | (37.7104316590536, -122.454315891261) | |||
11424 | 11424 | 15909 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5672 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1995 12:00:00 AM | 6 | 3x3 | 5998073.09723 | 2087015.06883 | 37.7104356241859 | -122.448453600256 | (37.7104356241859, -122.448453600256) | ||
4044 | 4044 | 159331 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 562 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:06:00 AM | 3 | Width 0ft | 5997894.14042 | 2087019.0117 | 37.7104362168201 | -122.449072394069 | (37.7104362168201, -122.449072394069) | ||
66537 | 66537 | 179987 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765 Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5998296.14725 | 2087014.5042 | 37.710446824338604 | -122.447682654627 | (37.7104468243386, -122.447682654627) | |||
11452 | 11452 | 39206 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3073X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996317.12895 | 2087059.6351599998 | 37.7104574381327 | -122.454525782264 | (37.7104574381327, -122.454525782264) | |
12091 | 12091 | 39208 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3073X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996328.55685 | 2087062.4339700001 | 37.7104657784446 | -122.45448648728001 | (37.7104657784446, -122.45448648728) | |
33930 | 33930 | 179988 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765 Morse St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 5998318.043769999 | 2087022.65362 | 37.7104704522241 | -122.447607562158 | (37.7104704522241, -122.447607562158) | |||
12290 | 12290 | 39207 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3073X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996341.69967 | 2087067.68226 | 37.7104809428024 | -122.454441442017 | (37.7104809428024, -122.454441442017) | |
4366 | 4366 | 251751 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 125 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:38:00 AM | 3 | 3x3 | 6003144.0 | 2086928.0 | 37.710485180250004 | -122.430921281744 | (37.71048518025, -122.430921281744) | ||
4396 | 4396 | 251750 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 125 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:46:00 AM | 3 | 3x3 | 6003144.0 | 2086928.0 | 37.710485180250004 | -122.430921281744 | (37.71048518025, -122.430921281744) | ||
56951 | 56951 | 180211 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 39 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008309.72741 | 2086823.54448 | 37.7104897103039 | -122.41305997625099 | (37.7104897103039, -122.413059976251) | |||
11131 | 11131 | 39203 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3073X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40853 | 5996355.3852 | 2087072.36701 | 37.7104945909167 | -122.454394480343 | (37.7104945909167, -122.454394480343) | |
69338 | 69338 | 179989 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 5998350.145880001 | 2087034.76993 | 37.7105055554714 | -122.447497482426 | (37.7105055554714, -122.447497482426) | |||
10954 | 10954 | 15902 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/23/1995 12:00:00 AM | 6 | TR20 | 5998238.99709 | 2087038.7453700001 | 37.7105101186185 | -122.447881921009 | (37.7105101186185, -122.447881921009) | ||
72444 | 72444 | 180013 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2168 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5996393.76853 | 2087077.91648 | 37.7105120296854 | -122.454262220628 | (37.7105120296854, -122.454262220628) | |||
73283 | 73283 | 84118 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 543 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50708 | 6010641.36534 | 2086802.2126200001 | 37.71056175319521 | -122.404999791608 | (37.7105617531952, -122.404999791608) | |
11532 | 11532 | 15904 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/1995 12:00:00 AM | 6 | TR20 | 5998273.75241 | 2087065.5939900002 | 37.7105858253457 | -122.44776373121 | (37.7105858253457, -122.44776373121) | ||
129724 | 129724 | 52009 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 359 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2006 12:00:00 AM | 6 | Permit Number 48990 | 6012536.41751 | 2086772.9103400002 | 37.7105870475244 | -122.39844797961099 | (37.7105870475244, -122.398447979611) | ||
11509 | 11509 | 15905 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/13/1994 12:00:00 AM | 12 | TR20 | 5998282.5187800005 | 2087066.12192 | 37.71058777596279 | -122.44773347081998 | (37.7105877759628, -122.44773347082) | ||
10548 | 10548 | 15906 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/23/1995 12:00:00 AM | 3 | TR20 | 5998281.91295 | 2087072.66875 | 37.7106057174457 | -122.447736035688 | (37.7106057174457, -122.447736035688) | ||
12577 | 12577 | 15907 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/23/1995 12:00:00 AM | 3 | TR20 | 5998292.86326 | 2087073.3238400002 | 37.7106081420281 | -122.447698236291 | (37.7106081420281, -122.447698236291) | ||
10887 | 10887 | 15908 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5600 Mission St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/01/1992 12:00:00 AM | 3 | TR20 | 5998294.210469999 | 2087081.2429799999 | 37.7106299631863 | -122.447694149767 | (37.7106299631863, -122.447694149767) | ||
4032 | 4032 | 253155 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 546 Ellington Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:02:00 AM | 3 | 3x3 | 5997941.0 | 2087090.0 | 37.710633814489604 | -122.44891554828999 | (37.7106338144896, -122.44891554829) | |||
172127 | 172127 | 84082 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 530-532 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50707 | 6010649.96914 | 2086842.4575099999 | 37.7106727385194 | -122.404972886602 | (37.7106727385194, -122.404972886602) | |
66382 | 66382 | 180206 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 530 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010632.30731 | 2086848.9077700002 | 37.7106894623249 | -122.405034384026 | (37.7106894623249, -122.405034384026) | |||
155083 | 155083 | 94594 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2446 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6010864.44098 | 2086844.85353 | 37.710691304128 | -122.404231788559 | (37.710691304128, -122.404231788559) | |||
3409 | 3409 | 180620 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 50 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6002386.3591599995 | 2087019.9409599998 | 37.71069467209271 | -122.43354641464501 | (37.7106946720927, -122.433546414645) | |||
11090 | 11090 | 96865 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 620 Palmetto Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5991908.438490001 | 2087239.0013 | 37.7106960939316 | -122.469776068222 | (37.7106960939316, -122.469776068222) | |||
12743 | 12743 | 96867 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 620 Palmetto Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5991882.45781 | 2087240.6995 | 37.710699255031294 | -122.46986598602301 | (37.7106992550313, -122.469865986023) | |||
13225 | 13225 | 1194 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3051 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1998 12:00:00 AM | 6 | 3X3 | 5996527.0746 | 2087144.8903599998 | 37.7107035681781 | -122.453806321904 | (37.7107035681781, -122.453806321904) | ||
52536 | 52536 | 71085 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 336 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1990 12:00:00 AM | 7 | 6000237.45691 | 2087069.9768 | 37.7107099003031 | -122.440977070243 | (37.7107099003031, -122.440977070243) | ||
45506 | 45506 | 94593 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2442 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6010872.81854 | 2086861.1094799999 | 37.7107364078213 | -122.40420397703801 | (37.7107364078213, -122.404203977038) | |||
42742 | 42742 | 15898 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5647X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 5998341.152919999 | 2087120.08013 | 37.7107392839911 | -122.447534700696 | (37.7107392839911, -122.447534700696) | ||
95470 | 95470 | 15899 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5647X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2007 12:00:00 AM | 3 | 3X3 | 5998341.152919999 | 2087120.08013 | 37.7107392839911 | -122.447534700696 | (37.7107392839911, -122.447534700696) | ||
118114 | 118114 | 180210 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 11 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6008343.95421 | 2086916.8221 | 37.7107477527694 | -122.412948271445 | (37.7107477527694, -122.412948271445) | |||
23236 | 23236 | 15894 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5635 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/1995 12:00:00 AM | 4 | 3x3 | 5998383.50628 | 2087139.43076 | 37.7107948367766 | -122.447389710384 | (37.7107948367766, -122.447389710384) | ||
11154 | 11154 | 25432 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2436 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1998 12:00:00 AM | 3 | 3X3 | 6010891.05193 | 2086887.1809599998 | 37.7108090136865 | -122.404142791654 | (37.7108090136865, -122.404142791654) | ||
12871 | 12871 | 1197 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3080 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/25/2015 12:00:00 AM | 3 | 3X3 | 5996407.37603 | 2087190.7232 | 37.7108225512021 | -122.454223333055 | (37.7108225512021, -122.454223333055) | ||
23293 | 23293 | 15895 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5635 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/1997 12:00:00 AM | 4 | 3X3 | 5998398.80737 | 2087150.2974599998 | 37.7108255486288 | -122.447337608149 | (37.7108255486288, -122.447337608149) | ||
51236 | 51236 | 65733 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 324 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 11 | Permit Number 33669 | 6000222.94909 | 2087115.45417 | 37.7108339446966 | -122.44103047290001 | (37.7108339446966, -122.4410304729) | |
138419 | 138419 | 1282 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3995X Alemany Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2000 12:00:00 AM | 3 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||
11552 | 11552 | 1195 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3062-3062 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/1998 12:00:00 AM | 8 | 3x3 | 5996475.62372 | 2087226.6805900002 | 37.710925195309294 | -122.453990049815 | (37.7109251953093, -122.453990049815) | ||
40761 | 40761 | 180203 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010383.47623 | 2086944.2281 | 37.710937279492796 | -122.40590111464701 | (37.7109372794928, -122.405901114647) | |||
41160 | 41160 | 180204 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010365.23615 | 2086949.58295 | 37.7109509626975 | -122.40596453395901 | (37.7109509626975, -122.405964533959) | |||
113927 | 113927 | 31208 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 112 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | Permit Number 34900 | 6011808.20404217 | 2086921.6592176002 | 37.7109548878303 | -122.400975304916 | (37.7109548878303, -122.400975304916) | |||
12413 | 12413 | 1191 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3044 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/1998 12:00:00 AM | 12 | 3X3 | 5996503.24503 | 2087241.9631400001 | 37.710968741375105 | -122.45389568755199 | (37.7109687413751, -122.453895687552) | ||
55762 | 55762 | 180205 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650 Visitacion Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010334.9036 | 2086961.82833 | 37.7109828895218 | -122.406070233066 | (37.7109828895218, -122.406070233066) | |||
11067 | 11067 | 1190 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3034 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 5996528.95527 | 2087256.53034 | 37.7110102136125 | -122.45380787863199 | (37.7110102136125, -122.453807878632) | ||
29399 | 29399 | 180000 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1207 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008297.27699 | 2087017.51562 | 37.7110216161269 | -122.413116714483 | (37.7110216161269, -122.413116714483) | |||
22994 | 22994 | 15896 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5635 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5998509.62683 | 2087220.1058900002 | 37.71102355866971 | -122.446959612304 | (37.7110235586697, -122.446959612304) | ||
36429 | 36429 | 180165 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 309 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000235.245680001 | 2087185.2549700001 | 37.7110263025015 | -122.440992977441 | (37.7110263025015, -122.440992977441) |
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");