Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 112538 | 112538 | 14773 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1000X McAllister St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 05/13/1992 12:00:00 AM | 6 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | ||
| 38315 | 38315 | 179295 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 103 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004297.98606 | 2093012.3139099998 | 37.727256697520204 | -122.42736600014 | (37.7272566975202, -122.42736600014) | |||
| 87312 | 87312 | 24482 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 103X Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002240.5138934 | 2096668.0977393002 | 37.7371780656004 | -122.434739971035 | (37.7371780656004, -122.434739971035) | |||
| 71421 | 71421 | 213970 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995027.09423 | 2091143.79671 | 37.721597507607996 | -122.45927995292699 | (37.721597507608, -122.459279952927) | |||
| 41596 | 41596 | 197086 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014471.44073 | 2102209.38753 | 37.7530800852958 | -122.39283930551599 | (37.7530800852958, -122.392839305516) | |||
| 62833 | 62833 | 197084 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014468.76337 | 2102245.03022 | 37.753177803814 | -122.39285105782801 | (37.753177803814, -122.392851057828) | |||
| 170402 | 170402 | 197083 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014468.24915 | 2102256.69833 | 37.7532098133945 | -122.392853652369 | (37.7532098133945, -122.392853652369) | |||
| 181135 | 181135 | 197093 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014477.98301 | 2102105.11898 | 37.7527941494528 | -122.392809386851 | (37.7527941494528, -122.392809386851) | |||
| 60352 | 60352 | 44270 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2001 12:00:00 AM | 6 | 3x3 | Permit Number 43698 | 6009401.249919999 | 2117056.5968 | 37.793564133816794 | -122.411421918689 | (37.7935641338168, -122.411421918689) | |
| 128132 | 128132 | 12670 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1128 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1998 12:00:00 AM | 6 | 3X3 | 5991921.00031 | 2114824.3919900004 | 37.786439173997 | -122.47174167386801 | (37.786439173997, -122.471741673868) | ||
| 99583 | 99583 | 9555 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1195X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.43006254712499 | (37.7797350134544, -122.430062547125) | |||
| 140317 | 140317 | 9553 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1195X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.43006254712499 | (37.7797350134544, -122.430062547125) | |||
| 141722 | 141722 | 9550 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1195X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.43006254712499 | (37.7797350134544, -122.430062547125) | |||
| 9321 | 9321 | 11465 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016782.5188136 | 2095601.0665952999 | 37.7350630793796 | -122.384386845805 | (37.7350630793796, -122.384386845805) | ||
| 14701 | 14701 | 11464 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016788.858519999 | 2095545.6720200002 | 37.734911327499205 | -122.384361070118 | (37.7349113274992, -122.384361070118) | ||
| 16006 | 16006 | 11463 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016797.65257 | 2095521.33822 | 37.7348449980066 | -122.384328971504 | (37.7348449980066, -122.384328971504) | ||
| 75524 | 75524 | 120438 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 123 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5988956.31634 | 2114501.1697400003 | 37.7853797200377 | -122.48197492857099 | (37.7853797200377, -122.481974928571) | |||
| 8221 | 8221 | 5902 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1230 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004519.1281 | 2112960.2158 | 37.7820414601118 | -122.428022411289 | (37.7820414601118, -122.428022411289) | |||
| 82718 | 82718 | 90488 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 125 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 6 | 3x3 | 5987997.512680001 | 2115126.89685 | 37.7870419790043 | -122.485337990995 | (37.7870419790043, -122.485337990995) | ||
| 14888 | 14888 | 24090 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 125X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1997 12:00:00 AM | 6 | 3x3 | 6016342.364159999 | 2095991.2568 | 37.736110114791 | -122.3859358217 | (37.736110114791, -122.3859358217) | ||
| 87317 | 87317 | 8192 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1280 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/1991 12:00:00 AM | 6 | 3X3 | 6001602.3460099995 | 2111171.39622 | 37.776964363900596 | -122.437984956441 | (37.7769643639006, -122.437984956441) | ||
| 144769 | 144769 | 689 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1299X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 22887 | 22887 | 120259 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 130 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5988369.32629 | 2115004.14379 | 37.7867265878172 | -122.484042609601 | (37.7867265878172, -122.484042609601) | |||
| 74086 | 74086 | 239242 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Potrero Ave | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010651.99768 | 2101656.70763 | 37.751349662874105 | -122.406008821959 | (37.7513496628741, -122.406008821959) | |||
| 60392 | 60392 | 244923 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1318 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999810.5322 | 2108837.5844 | 37.7704542495024 | -122.444015641705 | (37.7704542495024, -122.444015641705) | |||
| 172109 | 172109 | 213994 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 132 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999171.152980001 | 2095530.50421 | 37.7338797682181 | -122.445270345553 | (37.7338797682181, -122.445270345553) | |||
| 50367 | 50367 | 142842 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1343 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6006739.5174 | 2115575.1482 | 37.789346792117705 | -122.420526537815 | (37.7893467921177, -122.420526537815) | |||
| 74169 | 74169 | 136203 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1349 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004849.1859800005 | 2120525.70738 | 37.8028330549672 | -122.42741968339399 | (37.8028330549672, -122.427419683394) | |||
| 54566 | 54566 | 141886 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1355 EDDY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004027.64 | 2112849.1164 | 37.7817085903995 | -122.429714809344 | (37.7817085903995, -122.429714809344) | |||
| 70907 | 70907 | 197139 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 139 Venus St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012870.02823 | 2094155.1374099997 | 37.730875736712704 | -122.39781242511101 | (37.7308757367127, -122.397812425111) | |||
| 23213 | 23213 | 10408 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1391 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5999500.982999999 | 2108743.0478 | 37.7701770128525 | -122.445079572577 | (37.7701770128525, -122.445079572577) | |||
| 185326 | 185326 | 49094 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 140 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 6 | Permit Number 46242 | 5993992.46837 | 2114616.14539 | 37.785987019084295 | -122.464559844416 | (37.7859870190843, -122.464559844416) | ||
| 49555 | 49555 | 120257 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 140 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5988368.87318 | 2114954.3645200003 | 37.786589881739104 | -122.484040525506 | (37.7865898817391, -122.484040525506) | |||
| 162145 | 162145 | 60407 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1430 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1983 12:00:00 AM | 6 | Permit Number 19988 | 6016156.6712 | 2093985.1354 | 37.7305914290757 | -122.38643801167801 | (37.7305914290757, -122.386438011678) | |
| 59609 | 59609 | 213995 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 146 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999776.55649 | 2094090.41195 | 37.729960150431 | -122.44307390075399 | (37.729960150431, -122.443073900754) | |||
| 30381 | 30381 | 197107 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014386.38736 | 2102037.52751 | 37.7526034697945 | -122.393121414743 | (37.7526034697945, -122.393121414743) | |||
| 55248 | 55248 | 197103 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014438.05571 | 2102040.91433 | 37.7526156394141 | -122.392942972153 | (37.7526156394141, -122.392942972153) | |||
| 76745 | 76745 | 197102 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014466.67746 | 2102042.06403 | 37.752620386043205 | -122.392844072804 | (37.7526203860432, -122.392844072804) | |||
| 178466 | 178466 | 197104 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014428.85484 | 2102039.8538900004 | 37.752612216591004 | -122.392974716426 | (37.752612216591, -122.392974716426) | |||
| 35501 | 35501 | 197166 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017812.186480001 | 2093598.1535200002 | 37.729620355985205 | -122.380687698389 | (37.7296203559852, -122.380687698389) | |||
| 55755 | 55755 | 48872 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 150 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2002 12:00:00 AM | 6 | 3x3 | Permit Number 46081 | 6011751.8076 | 2120847.07255 | 37.8041034220013 | -122.403555563145 | (37.8041034220013, -122.403555563145) | |
| 93857 | 93857 | 8232 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1500X Galvez Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/13/1992 12:00:00 AM | 6 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 59502 | 59502 | 244531 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1504 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998919.2255 | 2108717.3892 | 37.7700733392593 | -122.44709001202 | (37.7700733392593, -122.44709001202) | |||
| 18749 | 18749 | 10444 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1508 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/1999 12:00:00 AM | 6 | 3x3 | 5998873.5099 | 2108710.5533 | 37.770051957545704 | -122.447247648975 | (37.7700519575457, -122.447247648975) | ||
| 125432 | 125432 | 8257 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1525 GALVEZ AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/13/1992 12:00:00 AM | 6 | 3x3 | 6016246.0 | 2097351.0 | 37.739838361172204 | -122.38636376878901 | (37.7398383611722, -122.386363768789) | ||
| 57520 | 57520 | 69320 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1546 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1994 12:00:00 AM | 6 | Permit Number 33401 | 6004443.14953 | 2120171.11922 | 37.801836474839796 | -122.428799484421 | (37.8018364748398, -122.428799484421) | |
| 44860 | 44860 | 240204 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 157 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002560.276330001 | 2096896.15431 | 37.7378224050816 | -122.43365070183901 | (37.7378224050816, -122.433650701839) | |||
| 166469 | 166469 | 239248 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 16 Tiffany Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6006371.4941 | 2099835.91554 | 37.746109844791704 | -122.420682079532 | (37.7461098447917, -122.420682079532) | |||
| 147968 | 147968 | 200740 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1667 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014877.3618 | 2094866.6866 | 37.732941090123404 | -122.390922400079 | (37.7329410901234, -122.390922400079) | |||
| 50615 | 50615 | 137711 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1695 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001100.0524 | 2111395.1736 | 37.777550222844 | -122.439738587802 | (37.777550222844, -122.439738587802) | |||
| 6172 | 6172 | 7253 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1701 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/1991 12:00:00 AM | 6 | 4X4 | 6003034.749 | 2114248.1919 | 37.7854938264749 | -122.433249741154 | (37.7854938264749, -122.433249741154) | ||
| 98800 | 98800 | 117418 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 171 COLERIDGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6006547.0 | 2098715.0 | 37.743041953466296 | -122.41999567036801 | (37.7430419534663, -122.419995670368) | |||
| 53362 | 53362 | 136246 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1723 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006533.72276 | 2116650.00017 | 37.7922864687885 | -122.421314924346 | (37.7922864687885, -122.421314924346) | |||
| 147690 | 147690 | 136247 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1723 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006549.579919999 | 2116650.11937 | 37.7922876900734 | -122.421260066609 | (37.7922876900734, -122.421260066609) | |||
| 56367 | 56367 | 52632 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1725@ POLK Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2006 12:00:00 AM | 6 | Permit Number 48716 | 6006419.56903 | 2116963.2187099997 | 37.793140052215705 | -122.421732156715 | (37.7931400522157, -122.421732156715) | ||
| 65322 | 65322 | 73401 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1733 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 6 | 6006559.8799 | 2116866.9427 | 37.7928836135597 | -122.421239831973 | (37.7928836135597, -122.421239831973) | ||
| 101812 | 101812 | 16753 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1785 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002792.36489 | 2113361.8294900004 | 37.783046346317796 | -122.434024935538 | (37.7830463463178, -122.434024935538) | |||
| 79895 | 79895 | 16755 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1795 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002763.899780001 | 2113354.2774799997 | 37.7830239949229 | -122.434122873023 | (37.7830239949229, -122.434122873023) | |||
| 80384 | 80384 | 16754 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1795 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/26/1992 12:00:00 AM | 6 | 4X4 | 6002743.54981 | 2113352.23837 | 37.783017241069004 | -122.434193129672 | (37.783017241069, -122.434193129672) | ||
| 150995 | 150995 | 140394 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1795 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002772.8115 | 2113360.8016 | 37.783042414286 | -122.43409250869 | (37.783042414286, -122.43409250869) | |||
| 1966 | 1966 | 138440 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/2014 12:00:00 AM | 6 | Width 0ft | 6003498.0109 | 2114207.9928 | 37.7854097192823 | -122.431644121578 | (37.7854097192823, -122.431644121578) | ||
| 51590 | 51590 | 138446 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003295.7109 | 2114182.3135 | 37.7853277416205 | -122.43234218389799 | (37.7853277416205, -122.432342183898) | |||
| 133253 | 133253 | 138442 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003410.7813 | 2114198.962 | 37.7853799782744 | -122.431945264637 | (37.7853799782744, -122.431945264637) | |||
| 135886 | 135886 | 65108 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 183 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 6 | Permit Number 27075 | 5988968.22756 | 2114128.63613 | 37.7843575407485 | -122.481906421224 | (37.7843575407485, -122.481906421224) | |
| 98310 | 98310 | 18253 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1830 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1998 12:00:00 AM | 6 | 4X4 | 6003407.35543 | 2114195.13868 | 37.7853692861869 | -122.43195684400499 | (37.7853692861869, -122.431956844005) | ||
| 135435 | 135435 | 68690 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 186 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 6 | Permit Number 32600 | 5992142.590419999 | 2114229.3610400003 | 37.7848182016374 | -122.47093167287201 | (37.7848182016374, -122.470931672872) | |
| 78063 | 78063 | 18261 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1870 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/1991 12:00:00 AM | 6 | 4X4 | 6003225.470724501 | 2114168.1799394 | 37.7852849514104 | -122.43258418353399 | (37.7852849514104, -122.432584183534) | ||
| 88462 | 88462 | 18260 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1870 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/1990 12:00:00 AM | 6 | 4X4 | 6003225.470724501 | 2114168.1799394 | 37.7852849514104 | -122.43258418353399 | (37.7852849514104, -122.432584183534) | ||
| 103857 | 103857 | 7248 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1880X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/04/2015 12:00:00 AM | 6 | 4X4 | 6003177.7471647 | 2114161.423532 | 37.7852636935379 | -122.43274880955 | (37.7852636935379, -122.43274880955) | ||
| 83913 | 83913 | 24563 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1897 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/18/1996 12:00:00 AM | 6 | 3X3 | 6002968.48938 | 2114735.5090099997 | 37.786828116669795 | -122.433513817626 | (37.7868281166698, -122.433513817626) | ||
| 108331 | 108331 | 1688 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 19 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1993 12:00:00 AM | 6 | 3X3 | 6017679.592279 | 2093598.3775556 | 37.7296136527509 | -122.381146110708 | (37.7296136527509, -122.381146110708) | ||
| 176037 | 176037 | 213935 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 19 Forest Side Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992714.0636 | 2098999.44218 | 37.74303390080429 | -122.46784648283001 | (37.7430339008043, -122.46784648283) | |||
| 140070 | 140070 | 7302 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1908 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002991.44687 | 2114925.25661 | 37.787350417898104 | -122.433447954843 | (37.7873504178981, -122.433447954843) | |||
| 94428 | 94428 | 7306 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1913 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002897.81123 | 2114891.63011 | 37.787252775252 | -122.43376950997299 | (37.787252775252, -122.433769509973) | |||
| 118335 | 118335 | 21722 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1927 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1990 12:00:00 AM | 6 | 4X4 | 6003422.355 | 2114492.57202 | 37.7861868134065 | -122.431926195851 | (37.7861868134065, -122.431926195851) | ||
| 3763 | 3763 | 18277 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1950 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 4X4 | 6002776.9831 | 2114109.0569 | 37.7850971709049 | -122.434131584258 | (37.7850971709049, -122.434131584258) | ||
| 85840 | 85840 | 18272 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1950 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 4X4 | 6002831.4981407 | 2114113.4681378 | 37.78511237688 | -122.433943294941 | (37.78511237688, -122.433943294941) | ||
| 50979 | 50979 | 213925 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996354.0642099995 | 2106807.80111 | 37.7646832084757 | -122.45582475672701 | (37.7646832084757, -122.455824756727) | |||
| 6434 | 6434 | 7318 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2001 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/1996 12:00:00 AM | 6 | 3x3 | 6002895.5378 | 2115212.2273 | 37.7881329245579 | -122.43380029876002 | (37.7881329245579, -122.43380029876) | ||
| 36622 | 36622 | 102487 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2001 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5999337.8085 | 2111150.0142 | 37.7767766147896 | -122.445817121147 | (37.7767766147896, -122.445817121147) | |||
| 31714 | 31714 | 46872 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2006 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | 6 | Permit Number 44935 | 6006916.93752 | 2118140.46696 | 37.7964005164122 | -122.420094813224 | (37.7964005164122, -122.420094813224) | |
| 74919 | 74919 | 136206 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5998023.60869 | 2115735.83366 | 37.7892929467667 | -122.450694020137 | (37.7892929467667, -122.450694020137) | |||
| 150842 | 150842 | 136205 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Locust St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5997542.32225 | 2115652.46545 | 37.78903647900739 | -122.452353187461 | (37.7890364790074, -122.452353187461) | |||
| 59141 | 59141 | 240169 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 204 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5998975.98045 | 2106976.10403 | 37.7652954525443 | -122.446768387673 | (37.7652954525443, -122.446768387673) | |||
| 81094 | 81094 | 7329 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2043 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 6002875.62738 | 2115359.09835 | 37.7885350652007 | -122.43387968738199 | (37.7885350652007, -122.433879687382) | ||||
| 128939 | 128939 | 7333 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2066 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002924.90365 | 2115430.7727099997 | 37.7887346608959 | -122.433714323915 | (37.7887346608959, -122.433714323915) | |||
| 161987 | 161987 | 179331 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 21 Drake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001453.95042 | 2086881.4918 | 37.7102615738952 | -122.43675911853501 | (37.7102615738952, -122.436759118535) | |||
| 180272 | 180272 | 179333 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 21 Drake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001438.26403 | 2086921.6489 | 37.710370944937104 | -122.436816206603 | (37.7103709449371, -122.436816206603) | |||
| 5575 | 5575 | 105537 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2192 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6002561.80287 | 2118173.8704 | 37.796245890587 | -122.435166876954 | (37.796245890587, -122.435166876954) | |||
| 102850 | 102850 | 17358 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2221X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005488.40666 | 2117587.01663 | 37.7948002909451 | -122.424998441372 | (37.7948002909451, -122.424998441372) | |||
| 69784 | 69784 | 213949 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 223 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994439.2720800005 | 2091407.20179 | 37.722286941382706 | -122.46133096657199 | (37.7222869413827, -122.461330966572) | |||
| 117899 | 117899 | 16668 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 226 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002868.0131043 | 2106963.7207257 | 37.7654830172848 | -122.43330589175501 | (37.7654830172848, -122.433305891755) | |||
| 26661 | 26661 | 213931 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 23 Hill Point Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996332.88729 | 2106669.96482 | 37.7643035299972 | -122.455888036623 | (37.7643035299972, -122.455888036623) | |||
| 70520 | 70520 | 213932 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 23 Hill Point Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996332.4383 | 2106648.48476 | 37.7642445254929 | -122.455888036625 | (37.7642445254929, -122.455888036625) | |||
| 136671 | 136671 | 213929 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 23 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996331.850980001 | 2106710.16203 | 37.7644138417466 | -122.455894527006 | (37.7644138417466, -122.455894527006) | |||
| 160573 | 160573 | 213930 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 23 Hill Point Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996333.00406 | 2106697.9920200002 | 37.7643804922005 | -122.455889659002 | (37.7643804922005, -122.455889659002) | |||
| 10316 | 10316 | 110495 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 230 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003598.79471 | 2092490.0157299999 | 37.7257830144685 | -122.429745863482 | (37.7257830144685, -122.429745863482) | |||
| 81088 | 81088 | 25542 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 230 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002869.108268499 | 2106943.9548823996 | 37.765428807217205 | -122.433300691324 | (37.7654288072172, -122.433300691324) | |||
| 153338 | 153338 | 197072 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2300 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010557.18002 | 2106482.58278 | 37.7645951333716 | -122.406676768239 | (37.7645951333716, -122.406676768239) | |||
| 129069 | 129069 | 24578 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2301 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1996 12:00:00 AM | 6 | 3x3 | 6002768.23016 | 2116232.67907 | 37.7909275993488 | -122.434313744932 | (37.7909275993488, -122.434313744932) |
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");