Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1366 | 1366 | 81793 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 435 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | 5 | 3x3 | 6005759.2342 | 2111006.7416 | 37.7767477786156 | -122.42359327476801 | (37.7767477786156, -122.423593274768) | |
| 4390 | 4390 | 175420 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 211 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6003926.56795 | 2092414.35505 | 37.7255938222743 | -122.428607384746 | (37.7255938222743, -122.428607384746) | |||
| 9202 | 9202 | 1709 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 7X Bass Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2006 12:00:00 AM | 5 | 3x3 | 6016610.521033701 | 2095134.7434862 | 37.7337731370994 | -122.384949031469 | (37.7337731370994, -122.384949031469) | ||
| 15141 | 15141 | 81729 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1200 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768902 | 6015012.434719999 | 2102924.7634900003 | 37.7550743894922 | -122.391018422974 | (37.7550743894922, -122.391018422974) |
| 23669 | 23669 | 138324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2492 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001634.5236 | 2114647.8572 | 37.7865116723619 | -122.438122738022 | (37.7865116723619, -122.438122738022) | |||
| 25023 | 25023 | 213915 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1221 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993897.03256 | 2107168.07527 | 37.7655311082052 | -122.464349072465 | (37.7655311082052, -122.464349072465) | |||
| 25141 | 25141 | 213923 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996379.96302 | 2106767.55131 | 37.76457417918571 | -122.455732270441 | (37.7645741791857, -122.455732270441) | |||
| 27161 | 27161 | 197088 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014473.69906 | 2102184.6927400003 | 37.753012404101 | -122.39282976818998 | (37.753012404101, -122.39282976819) | |||
| 27408 | 27408 | 85487 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 380 Bacon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010399.4592 | 2092794.41628 | 37.727001587734605 | -122.40625779115801 | (37.7270015877346, -122.406257791158) | ||
| 27910 | 27910 | 183007 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2440 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989549.7088 | 2098739.1145 | 37.742135877465294 | -122.478768805014 | (37.7421358774653, -122.478768805014) | |||
| 29178 | 29178 | 197081 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 690 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015537.3565 | 2105827.07749 | 37.7630726369229 | -122.389405745189 | (37.7630726369229, -122.389405745189) | |||
| 30825 | 30825 | 240180 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 415 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008254.09787 | 2096890.0031299999 | 37.738126944293796 | -122.413963894722 | (37.7381269442938, -122.413963894722) | |||
| 32581 | 32581 | 197122 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Napoleon St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013973.73168 | 2100142.08459 | 37.747376054258105 | -122.394415755007 | (37.7473760542581, -122.394415755007) | |||
| 33654 | 33654 | 141285 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 303 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5998264.5884 | 2112604.2973 | 37.780708361851396 | -122.449634513412 | (37.7807083618514, -122.449634513412) | |||
| 34527 | 34527 | 123209 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993132.47666 | 2112678.91247 | 37.7806182922184 | -122.46739423754299 | (37.7806182922184, -122.467394237543) | |||
| 34718 | 34718 | 139271 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 765 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004149.5758 | 2111471.3855 | 37.7779325866279 | -122.42919470092698 | (37.7779325866279, -122.429194700927) | |||
| 38003 | 38003 | 136244 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1747 Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006363.52762 | 2116626.5882200003 | 37.7922125885856 | -122.42190214028099 | (37.7922125885856, -122.421902140281) | |||
| 38106 | 38106 | 142044 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005880.5674 | 2111021.3015 | 37.7767946045442 | -122.423174581774 | (37.7767946045442, -122.423174581774) | |||
| 39419 | 39419 | 197144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 67 Jennings Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012875.71849 | 2089235.92195 | 37.717368885441395 | -122.397447893917 | (37.7173688854414, -122.397447893917) | |||
| 41799 | 41799 | 46849 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 273 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 5 | Permit Number 44917 | 6003953.72556 | 2091952.73307 | 37.724327847540295 | -122.42848061451201 | (37.7243278475403, -122.428480614512) | |
| 44291 | 44291 | 247563 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6008788.9631 | 2095462.99791 | 37.734238722726495 | -122.41201377422199 | (37.7342387227265, -122.412013774222) | |||
| 44512 | 44512 | 38662 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 834 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40585 | 6001015.5346 | 2111586.9168 | 37.778071890037 | -122.440044714881 | (37.778071890037, -122.440044714881) |
| 45316 | 45316 | 141980 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 676 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004463.6367 | 2111570.2882 | 37.778221923041 | -122.42811530330299 | (37.778221923041, -122.428115303303) | |||
| 45418 | 45418 | 197094 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014478.47867 | 2102089.9100099998 | 37.7527524163908 | -122.392806608832 | (37.7527524163908, -122.392806608832) | |||
| 46895 | 46895 | 88581 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 515 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51523 | 5989364.701169999 | 2111797.63767 | 37.777980320812 | -122.480364100125 | (37.777980320812, -122.480364100125) | ||
| 47148 | 47148 | 72144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1985 12:00:00 AM | 5 | 6000049.527000001 | 2091859.62504 | 37.723850484693706 | -122.441970156497 | (37.7238504846937, -122.441970156497) | ||
| 47669 | 47669 | 36825 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1220 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 5 | Permit Number 49072 | 6014545.9992 | 2090648.9983 | 37.721341772631895 | -122.39177321286199 | (37.7213417726319, -122.391773212862) | |
| 48657 | 48657 | 139274 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 725 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004227.9769 | 2111481.8263 | 37.7779656924567 | -122.42892422841899 | (37.7779656924567, -122.428924228419) | |||
| 48741 | 48741 | 71411 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1556 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1983 12:00:00 AM | 5 | 6015495.2506 | 2094478.7004 | 37.7319100238031 | -122.388759104128 | (37.7319100238031, -122.388759104128) | ||
| 52609 | 52609 | 34250 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1998 12:00:00 AM | 5 | Permit Number 38731 | 6006204.75677 | 2121056.43709 | 37.8043668775019 | -122.42276644632601 | (37.8043668775019, -122.422766446326) | |
| 53523 | 53523 | 48812 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.053730001 | 2102353.10418 | 37.753474456898104 | -122.392864530587 | (37.7534744568981, -122.392864530587) | ||
| 54424 | 54424 | 197151 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 99 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6016637.91847 | 2095129.63156 | 37.7337606161438 | -122.384853953468 | (37.7337606161438, -122.384853953468) | |||
| 56000 | 56000 | 30618 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1645 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 5 | Permit Number 34580 | 6008139.305 | 2108622.0896 | 37.7703341448356 | -122.41519103466601 | (37.7703341448356, -122.415191034666) | |
| 56227 | 56227 | 197135 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015262.92854 | 2096819.7411099998 | 37.738325167482294 | -122.389725749154 | (37.7383251674823, -122.389725749154) | |||
| 56408 | 56408 | 197131 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 Newhall St | 17 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015885.54456 | 2097735.3383299997 | 37.740873716654 | -122.38763689115 | (37.740873716654, -122.38763689115) | |||
| 57568 | 57568 | 213989 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2583 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992043.57751 | 2097881.5544 | 37.7399257259925 | -122.47008343851299 | (37.7399257259925, -122.470083438513) | |||
| 59877 | 59877 | 142215 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999732.1302 | 2109994.3314 | 37.7736259111784 | -122.444369976113 | (37.7736259111784, -122.444369976113) | |||
| 60644 | 60644 | 141284 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 305 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5998229.3925 | 2112598.2057 | 37.7806896223004 | -122.44975583332199 | (37.7806896223004, -122.449755833322) | |||
| 62088 | 62088 | 213946 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 30 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996526.79114 | 2090102.3106200001 | 37.718823939946795 | -122.454020752656 | (37.7188239399468, -122.454020752656) | |||
| 62359 | 62359 | 197142 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 67 Jennings Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012879.123819999 | 2089210.84364 | 37.717300215014205 | -122.39743436542601 | (37.7173002150142, -122.397434365426) | |||
| 62957 | 62957 | 213921 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 28 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996377.267469999 | 2106728.36623 | 37.7644664323134 | -122.45573876085501 | (37.7644664323134, -122.455738760855) | |||
| 63638 | 63638 | 136265 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Joice St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010230.84505 | 2116901.45866 | 37.7931846576946 | -122.408540490873 | (37.7931846576946, -122.408540490873) | |||
| 64524 | 64524 | 197071 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2300 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010571.86967 | 2106484.7733400003 | 37.7646019700183 | -122.40662611481301 | (37.7646019700183, -122.406626114813) | |||
| 65149 | 65149 | 197108 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6012056.73956 | 2105565.85317 | 37.762161783771205 | -122.401425732033 | (37.7621617837712, -122.401425732033) | ||||
| 68096 | 68096 | 200038 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015316.6267 | 2094740.3159 | 37.7326184655785 | -122.38939491276501 | (37.7326184655785, -122.389394912765) | |||
| 68138 | 68138 | 239270 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007357.25381 | 2107576.0791 | 37.767418064810705 | -122.41782199889201 | (37.7674180648107, -122.417821998892) | |||
| 68616 | 68616 | 137867 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2044 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002928.9527 | 2115414.1909 | 37.7886893612244 | -122.43369912921301 | (37.7886893612244, -122.433699129213) | |||
| 70248 | 70248 | 100361 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1135 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6007562.69285 | 2118825.76087 | 37.7983185248271 | -122.417908959744 | (37.7983185248271, -122.417908959744) | |||
| 70939 | 70939 | 200236 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 921 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014551.0541 | 2089524.7802 | 37.718255172199896 | -122.39167717639299 | (37.7182551721999, -122.391677176393) | |||
| 71108 | 71108 | 31557 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 166 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2015 12:00:00 AM | 5 | Permit Number 774125 | 5998574.5828 | 2112531.8751 | 37.7805272390885 | -122.44855688064399 | (37.7805272390885, -122.448556880644) | |
| 71297 | 71297 | 199665 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015244.0778 | 2093456.6965 | 37.729089882168395 | -122.389556118834 | (37.7290898821684, -122.389556118834) | |||
| 71612 | 71612 | 197082 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 690 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015524.49345 | 2105827.33722 | 37.7630726369153 | -122.38945025263901 | (37.7630726369153, -122.389450252639) | |||
| 72557 | 72557 | 138536 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1840 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/04/2015 12:00:00 AM | 5 | Width 0ft | 6003152.9747 | 2114161.9926 | 37.7852638510753 | -122.432834555298 | (37.7852638510753, -122.432834555298) | ||
| 72842 | 72842 | 69456 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 471 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 5 | Permit Number 33566 | 5985607.3929 | 2112736.22477 | 37.7803383536355 | -122.493430946652 | (37.7803383536355, -122.493430946652) | |
| 73028 | 73028 | 197130 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 Newhall St | 16 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015893.1870800005 | 2097747.64492 | 37.7409079313583 | -122.38761132431299 | (37.7409079313583, -122.387611324313) | |||
| 73788 | 73788 | 138936 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 611 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004391.0086 | 2110998.5233 | 37.776647887890896 | -122.428325789109 | (37.7766478878909, -122.428325789109) | |||
| 73927 | 73927 | 139494 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1282 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001605.3645 | 2111168.2484 | 37.776955892433705 | -122.437974289048 | (37.7769558924337, -122.437974289048) | |||
| 73982 | 73982 | 137614 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2250 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999234.5899 | 2111901.9875 | 37.7788354460524 | -122.446228288937 | (37.7788354460524, -122.446228288937) | |||
| 74292 | 74292 | 54817 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1414 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49953 | 6015568.3491 | 2093032.3958 | 37.7279428116622 | -122.388405474303 | (37.7279428116622, -122.388405474303) | |
| 76235 | 76235 | 179325 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 139 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009883.98076 | 2094924.5226900002 | 37.7328215611604 | -122.408189966611 | (37.7328215611604, -122.408189966611) | |||
| 76800 | 76800 | 67939 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 424 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1993 12:00:00 AM | 5 | Permit Number 31653 | 5999771.9705 | 2110008.0811 | 37.7736659373793 | -122.444233151163 | (37.7736659373793, -122.444233151163) | ||
| 89195 | 89195 | 84586 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3280 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51600 | 6006479.54925803 | 2103214.61842513 | 37.7553930801265 | -122.420548232521 | (37.7553930801265, -122.420548232521) | |
| 94122 | 94122 | 81726 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1111X 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768902 | 6015016.9034833005 | 2102945.53994176 | 37.7551316851739 | -122.39100442062201 | (37.7551316851739, -122.391004420622) |
| 112664 | 112664 | 32235 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 5 | Permit Number 35550 | 6008746.13073 | 2099389.39192 | 37.7450173393701 | -122.412439304646 | (37.7450173393701, -122.412439304646) | |
| 118181 | 118181 | 179285 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 93 Delta St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010162.36149 | 2089750.0772799999 | 37.7186291998585 | -122.40686296837099 | (37.7186291998585, -122.406862968371) | |||
| 119496 | 119496 | 199666 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015268.2608 | 2093490.7724 | 37.72918478862329 | -122.389474894337 | (37.7291847886233, -122.389474894337) | |||
| 119603 | 119603 | 239286 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1999 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009565.6404099995 | 2105513.83187 | 37.761879638550504 | -122.410037856662 | (37.7618796385505, -122.410037856662) | |||
| 122012 | 122012 | 197080 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 690 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015550.01358 | 2105828.2198099997 | 37.7630764752211 | -122.389362048039 | (37.7630764752211, -122.389362048039) | |||
| 126705 | 126705 | 47740 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3583 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2002 12:00:00 AM | 5 | 3x3 | Permit Number 45523 | 6005444.07123 | 2097374.1868 | 37.7392981824927 | -122.42371398959101 | (37.7392981824927, -122.423713989591) | |
| 130726 | 130726 | 60409 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1448 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52503 | 6016089.8742 | 2094040.62 | 37.73074008090121 | -122.38667280863399 | (37.7307400809012, -122.386672808634) | |
| 133498 | 133498 | 239325 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009350.01559 | 2099840.2126 | 37.746289064404294 | -122.410382996672 | (37.7462890644043, -122.410382996672) | |||
| 135080 | 135080 | 69741 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 93 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 5 | 6010157.175969999 | 2089735.57492 | 37.7185890892048 | -122.40687987112601 | (37.7185890892048, -122.406879871126) | ||
| 135819 | 135819 | 197165 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Reuel Ct | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017366.51517 | 2096051.5594799998 | 37.7363323183867 | -122.382399074074 | (37.7363323183867, -122.382399074074) | |||
| 136061 | 136061 | 139287 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 894 STEINER ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6003017.2906 | 2111263.9995 | 37.7772989926884 | -122.43309685014499 | (37.7772989926884, -122.433096850145) | |||
| 136232 | 136232 | 240135 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 277 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6004681.7574 | 2100144.35115 | 37.74686135877779 | -122.426546933603 | (37.7468613587778, -122.426546933603) | |||
| 137891 | 137891 | 67598 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3320 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/1992 12:00:00 AM | 5 | Permit Number 31166 | 5998906.2009 | 2115636.68755 | 37.789071198237295 | -122.44763322790199 | (37.7890711982373, -122.447633227902) | ||
| 144326 | 144326 | 136235 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 928 Leavenworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008235.611740001 | 2115647.76794 | 37.7896303876902 | -122.41535535186199 | (37.7896303876902, -122.415355351862) | |||
| 147189 | 147189 | 213947 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 300 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995892.36071 | 2091233.5723299999 | 37.7218937190991 | -122.456295465473 | (37.7218937190991, -122.456295465473) | |||
| 148294 | 148294 | 123628 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 142 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995232.14872 | 2114600.88341 | 37.7860165001902 | -122.460269811318 | (37.7860165001902, -122.460269811318) | |||
| 149097 | 149097 | 197092 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014476.97343 | 2102121.40509 | 37.752838811567 | -122.392814017467 | (37.752838811567, -122.392814017467) | |||
| 149179 | 149179 | 85485 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 380 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010430.57281 | 2092804.2489200002 | 37.72703032647411 | -122.40615092385299 | (37.7270303264741, -122.406150923853) | ||
| 149670 | 149670 | 30617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1625 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 5 | Permit Number 34579 | 6008161.857999999 | 2108672.7086 | 37.7704744001626 | -122.41511660718399 | (37.7704744001626, -122.415116607184) | |
| 150051 | 150051 | 239358 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1560 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003940.0433 | 2099157.5205099997 | 37.744109791227395 | -122.42904136337098 | (37.7441097912274, -122.429041363371) | |||
| 150776 | 150776 | 239247 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1330 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010310.37957 | 2101498.2335 | 37.7508954153113 | -122.407179012596 | (37.7508954153113, -122.407179012596) | |||
| 151589 | 151589 | 48815 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.97393 | 2102326.82142 | 37.7534023411579 | -122.392859509671 | (37.7534023411579, -122.392859509671) | ||
| 151617 | 151617 | 48799 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014465.83632 | 2102364.69447 | 37.753506213741396 | -122.392869551502 | (37.7535062137414, -122.392869551502) | ||
| 152237 | 152237 | 213961 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994775.27388 | 2091185.74798 | 37.7216982145873 | -122.460153459921 | (37.7216982145873, -122.460153459921) | |||
| 152567 | 152567 | 249824 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 285 Kearny St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6010866.76079 | 2120642.6759099998 | 37.8034927229673 | -122.40660393393999 | (37.8034927229673, -122.40660393394) | |||
| 156477 | 156477 | 197073 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2310 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010516.44047 | 2106481.63446 | 37.7645902500634 | -122.406817609258 | (37.7645902500634, -122.406817609258) | |||
| 156662 | 156662 | 141624 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1801 GROVE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998927.5552 | 2110401.5996 | 37.7746982273973 | -122.447182428734 | (37.7746982273973, -122.447182428734) | |||
| 156985 | 156985 | 65109 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 145 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 5 | Permit Number 27078 | 5988958.234730001 | 2114388.99376 | 37.7850718280894 | -122.481960071321 | (37.7850718280894, -122.481960071321) | |
| 157309 | 157309 | 197105 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014414.64892 | 2102038.8947099997 | 37.752608793773796 | -122.393023776248 | (37.7526087937738, -122.393023776248) | |||
| 158710 | 158710 | 141283 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 305 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5998211.7946 | 2112594.1447 | 37.7806774650063 | -122.44981641989901 | (37.7806774650063, -122.449816419899) | |||
| 159587 | 159587 | 213922 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 28 Hill Point Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996376.57374 | 2106740.0599 | 37.7644985003194 | -122.45574200560499 | (37.7644985003194, -122.455742005605) | |||
| 160169 | 160169 | 197087 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014472.10243 | 2102198.29911 | 37.753049675611 | -122.39283624152 | (37.753049675611, -122.39283624152) | |||
| 160235 | 160235 | 246010 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1509 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998926.3648 | 2108660.5268 | 37.7699176174446 | -122.447061224692 | (37.7699176174446, -122.447061224692) | |||
| 160245 | 160245 | 123627 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 142 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995231.45698 | 2114622.12535 | 37.786074785036504 | -122.46027374413099 | (37.7860747850365, -122.460273744131) | |||
| 160765 | 160765 | 68930 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 768 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | Permit Number 32914 | 5993218.422259999 | 2110247.19429 | 37.7739464110699 | -122.466920079783 | (37.7739464110699, -122.466920079783) | |
| 160986 | 160986 | 240145 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1209 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998178.05243 | 2106154.45126 | 37.7629937870534 | -122.44946901220301 | (37.7629937870534, -122.449469012203) | |||
| 161068 | 161068 | 138103 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1826 BUCHANAN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003982.1491 | 2114786.5332 | 37.787025675647996 | -122.430010433007 | (37.787025675648, -122.430010433007) |
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");