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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 176120 | 176120 | 138122 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1850 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003040.5439 | 2114556.1859999998 | 37.7863398290166 | -122.433251707831 | (37.7863398290166, -122.433251707831) | |||
| 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) | |||
| 176007 | 176007 | 240176 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 437 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008241.87185 | 2096776.8693400002 | 37.737815616996606 | -122.41399816519301 | (37.7378156169966, -122.413998165193) | |||
| 175783 | 175783 | 200043 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Lane St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015271.0088 | 2094675.4616 | 37.732437859472796 | -122.38954809856399 | (37.7324378594728, -122.389548098564) | |||
| 175706 | 175706 | 64667 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 155 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 7 | Permit Number 27077 | 5988959.0752 | 2114316.0403299998 | 37.784871567471704 | -122.48195181759701 | (37.7848715674717, -122.481951817597) | |
| 175573 | 175573 | 142841 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1347 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6006737.9132 | 2115595.2008 | 37.7894017611933 | -122.42053351217 | (37.7894017611933, -122.42053351217) | |||
| 175429 | 175429 | 239330 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3253 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009041.34304 | 2099722.57277 | 37.745948742940605 | -122.411442043712 | (37.7459487429406, -122.411442043712) | |||
| 175286 | 175286 | 141309 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 74 PARKER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996869.9521 | 2114088.2769 | 37.784703091925294 | -122.454566442022 | (37.7847030919253, -122.454566442022) | |||
| 175241 | 175241 | 35263 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2314 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52291 | 6006344.46456 | 2118787.78744 | 37.7981456238821 | -122.422121705266 | (37.7981456238821, -122.422121705266) | |
| 175163 | 175163 | 142043 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005850.7541 | 2111017.8349 | 37.776783403593996 | -122.42327746856199 | (37.776783403594, -122.423277468562) | |||
| 175148 | 175148 | 136110 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1725 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005929.66848 | 2117544.18385 | 37.7947075984216 | -122.423468565942 | (37.7947075984216, -122.423468565942) | |||
| 175096 | 175096 | 239364 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3995 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003953.0649 | 2100692.52563 | 37.7483252967888 | -122.429105762915 | (37.7483252967888, -122.429105762915) | |||
| 175081 | 175081 | 240201 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3004 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002850.8471 | 2096117.4239599998 | 37.735700673245 | -122.432590449705 | (37.735700673245, -122.432590449705) | |||
| 175020 | 175020 | 197153 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Jakey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016721.84036 | 2095568.4819 | 37.734970252878796 | -122.384594365947 | (37.7349702528788, -122.384594365947) | |||
| 174826 | 174826 | 213987 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 6 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5996535.27353 | 2089022.9105 | 37.7158606459376 | -122.45391352290599 | (37.7158606459376, -122.453913522906) | |||
| 174554 | 174554 | 85486 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 380 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010415.33133 | 2092799.63405 | 37.7270168024731 | -122.406203288666 | (37.7270168024731, -122.406203288666) | ||
| 174480 | 174480 | 213955 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994772.87853 | 2091030.08167 | 37.721270654392 | -122.460150467873 | (37.721270654392, -122.460150467873) | |||
| 174429 | 174429 | 35739 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 378 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1998 12:00:00 AM | 9 | Permit Number 39013 | 6008634.39829 | 2094282.55173 | 37.7309887985962 | -122.41246474286999 | (37.7309887985962, -122.41246474287) | |
| 174380 | 174380 | 56156 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 471 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 12 | Permit Number 12264 | 5990899.19855 | 2112188.99411 | 37.779143929860204 | -122.475084359841 | (37.7791439298602, -122.475084359841) | ||
| 174223 | 174223 | 179286 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002271.23579 | 2094443.82332 | 37.7310724625286 | -122.43447476411801 | (37.7310724625286, -122.434474764118) | |||
| 173991 | 173991 | 179297 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Peru Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004358.252069999 | 2093034.47753 | 37.7273209621682 | -122.427159238819 | (37.7273209621682, -122.427159238819) | |||
| 173914 | 173914 | 52631 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1725@ POLK Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2006 12:00:00 AM | 3 | Permit Number 48716 | 6006396.26388 | 2116959.2497900003 | 37.7931278403295 | -122.421812512039 | (37.7931278403295, -122.421812512039) | ||
| 173902 | 173902 | 239309 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6005351.1495900005 | 2103566.74632 | 37.7562962839536 | -122.42447563036801 | (37.7562962839536, -122.424475630368) | |||
| 173878 | 173878 | 240175 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 449 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008238.06241 | 2096739.7432799998 | 37.7377134629997 | -122.414008710659 | (37.7377134629997, -122.414008710659) | |||
| 173762 | 173762 | 124412 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3900 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5996120.28006 | 2115251.26489 | 37.787853319856794 | -122.45724420279 | (37.7878533198568, -122.45724420279) | |||
| 173604 | 173604 | 240189 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 49 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004299.90436 | 2097973.73041 | 37.7408797385189 | -122.427712715772 | (37.7408797385189, -122.427712715772) | |||
| 173537 | 173537 | 197097 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 379 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6014372.8543300005 | 2105361.9972099997 | 37.7617309959041 | -122.39340084578001 | (37.7617309959041, -122.39340084578) | |||
| 173465 | 173465 | 240164 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 953 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998770.20666 | 2106657.712 | 37.764409471033 | -122.447457188295 | (37.764409471033, -122.447457188295) | |||
| 173343 | 173343 | 197137 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1611 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6015105.04683 | 2096793.47619 | 37.7382442932251 | -122.39026979671699 | (37.7382442932251, -122.390269796717) | |||
| 173304 | 173304 | 65517 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2028 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1990 12:00:00 AM | 9 | Permit Number 28403 | 6003226.452219999 | 2118960.15524 | 37.7984425449573 | -122.43292325730499 | (37.7984425449573, -122.432923257305) | ||
| 173179 | 173179 | 122094 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 695 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990954.58445 | 2110703.0239 | 37.775067073184296 | -122.474784270445 | (37.7750670731843, -122.474784270445) | |||
| 173165 | 173165 | 239337 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1534 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009307.10914 | 2100388.95638 | 37.7477933882533 | -122.410570106037 | (37.7477933882533, -122.410570106037) | |||
| 173068 | 173068 | 197158 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 106 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016583.16711 | 2095682.22839 | 37.7352749081106 | -122.385081735533 | (37.7352749081106, -122.385081735533) | |||
| 172968 | 172968 | 39937 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 327 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50713 | 6009355.370709999 | 2088298.86848 | 37.7145992918994 | -122.40955005091499 | (37.7145992918994, -122.409550050915) | |
| 172877 | 172877 | 213968 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995026.496169999 | 2091185.65951 | 37.7217124184688 | -122.459285050266 | (37.7217124184688, -122.459285050266) | |||
| 172764 | 172764 | 120258 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 130 24th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5988366.4287 | 2115019.00218 | 37.7867672160285 | -122.48405372444599 | (37.7867672160285, -122.484053724446) | |||
| 172651 | 172651 | 71391 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1531 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 4 | 6015562.7322 | 2096452.7948 | 37.737334227876396 | -122.388663558077 | (37.7373342278764, -122.388663558077) | ||
| 172539 | 172539 | 248300 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3175 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6006753.7624 | 2099865.7323 | 37.74621325229 | -122.41936235698401 | (37.74621325229, -122.419362356984) | |||
| 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) | |||
| 172017 | 172017 | 179332 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 21 Drake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001443.39306 | 2086909.8506099998 | 37.7103388409345 | -122.43679763560301 | (37.7103388409345, -122.436797635603) | |||
| 171856 | 171856 | 139399 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 896 STEINER ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6003012.8594 | 2111291.1403 | 37.7773732632111 | -122.433114118747 | (37.7773732632111, -122.433114118747) | |||
| 171836 | 171836 | 197146 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Whitney Young Cir | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017111.39408 | 2094922.05635 | 37.733216832081396 | -122.383202548153 | (37.7332168320814, -122.383202548153) | |||
| 171759 | 171759 | 240146 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1217 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998179.2817400005 | 2106131.69521 | 37.7629313749956 | -122.449463120725 | (37.7629313749956, -122.449463120725) | |||
| 171756 | 171756 | 240130 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3517 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004936.2718 | 2103669.98473 | 37.756556314841 | -122.425917770609 | (37.756556314841, -122.425917770609) | |||
| 171604 | 171604 | 239341 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 249 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010255.29799 | 2100038.54541 | 37.746884349931705 | -122.407266602985 | (37.7468843499317, -122.407266602985) | |||
| 171603 | 171603 | 213948 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 300 Holloway Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995862.50546 | 2091234.8214599998 | 37.7218954350104 | -122.456398757109 | (37.7218954350104, -122.456398757109) | |||
| 171464 | 171464 | 141286 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 303 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5998281.8479 | 2112606.3279 | 37.7807149247435 | -122.449574951116 | (37.7807149247435, -122.449574951116) | |||
| 171428 | 171428 | 197068 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 430 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010884.7435 | 2106309.51664 | 37.764138254402596 | -122.405531618298 | (37.7641382544026, -122.405531618298) | |||
| 171356 | 171356 | 51529 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 846 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | 5 | Permit Number 47831 | 6013038.0341300005 | 2103130.6392200002 | 37.7555299221754 | -122.39786095703501 | (37.7555299221754, -122.397860957035) | ||
| 171342 | 171342 | 69369 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3715 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 7 | Permit Number 33463 | 6002534.674819999 | 2121358.09542 | 37.804987398007704 | -122.43548864898099 | (37.8049873980077, -122.435488648981) | |
| 171230 | 171230 | 139289 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 818 STEINER ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 6003024.4912 | 2111210.2718 | 37.777151878241206 | -122.433068101317 | (37.7771518782412, -122.433068101317) | |||
| 171068 | 171068 | 197090 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014474.311480001 | 2102148.65752 | 37.752913493081294 | -122.39282512948 | (37.7529134930813, -122.39282512948) | |||
| 171035 | 171035 | 179335 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1119 Athens St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6001959.57443 | 2087726.76645 | 37.7126112352992 | -122.435071996701 | (37.7126112352992, -122.435071996701) | |||
| 170803 | 170803 | 179301 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 324 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003618.31142 | 2092719.8675400002 | 37.7264152414524 | -122.429694781997 | (37.7264152414524, -122.429694781997) | |||
| 170669 | 170669 | 53032 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 35GOLDENGATE Temescal Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | 2 | 3x3 | Permit Number 49011 | 5997444.5897 | 2111409.0141 | 37.7773794808628 | -122.45238499119301 | (37.7773794808628, -122.452384991193) | |
| 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) | |||
| 170390 | 170390 | 240184 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3371 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004431.11432 | 2106566.00014 | 37.764479523721704 | -122.427871135859 | (37.7644795237217, -122.427871135859) | |||
| 170342 | 170342 | 240170 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1210 Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997763.42944 | 2106350.69035 | 37.763508882764796 | -122.45091719498699 | (37.7635088827648, -122.450917194987) | |||
| 170258 | 170258 | 138546 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1640 SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001642.2543 | 2114139.7444 | 37.7851169644034 | -122.438059581246 | (37.7851169644034, -122.438059581246) | |||
| 170174 | 170174 | 138832 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 745 BUCHANAN ST | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 6004455.5234 | 2111072.8991 | 37.7768557558926 | -122.428107915053 | (37.7768557558926, -122.428107915053) | |||
| 170056 | 170056 | 120777 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 21st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5989253.41901 | 2114816.7810299997 | 37.786263574020204 | -122.480970171004 | (37.7862635740202, -122.480970171004) | |||
| 170019 | 170019 | 141931 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 MCALLISTER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004116.6344 | 2111867.0624 | 37.7790171527246 | -122.42933687953999 | (37.7790171527246, -122.42933687954) | |||
| 169823 | 169823 | 197148 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Whitney Young Cir | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017233.106869999 | 2094952.3109 | 37.7333066302946 | -122.382783854412 | (37.7333066302946, -122.382783854412) | |||
| 169810 | 169810 | 239252 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3735 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005431.9472199995 | 2100770.05115 | 37.748621769087 | -122.42399733221501 | (37.748621769087, -122.423997332215) | |||
| 169703 | 169703 | 36194 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 107 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 39260 | 5997029.24357 | 2115938.23155 | 37.7897917089598 | -122.454149011282 | (37.7897917089598, -122.454149011282) | |||
| 169613 | 169613 | 200039 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Lane St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015308.9321 | 2094726.0259999998 | 37.7325788017835 | -122.38942051753 | (37.7325788017835, -122.38942051753) | |||
| 169460 | 169460 | 56218 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 475 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12339 | 5990899.771790001 | 2112161.89837 | 37.779069565646 | -122.475080398267 | (37.779069565646, -122.475080398267) | ||
| 169456 | 169456 | 136189 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6002539.896000001 | 2118184.5507 | 37.7962739719132 | -122.435243443451 | (37.7962739719132, -122.435243443451) | |||
| 169427 | 169427 | 248000 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 402 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009971.140819999 | 2098682.22782 | 37.7431442907726 | -122.408153555751 | (37.7431442907726, -122.408153555751) | |||
| 169415 | 169415 | 41926 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 444 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 7 | Permit Number 42286 | 5994688.62474 | 2112489.12651 | 37.7801869053866 | -122.46199705059601 | (37.7801869053866, -122.461997050596) | |
| 169324 | 169324 | 118185 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 435 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5985597.25903 | 2112945.4232900003 | 37.7809121598048 | -122.493481422073 | (37.7809121598048, -122.493481422073) | |||
| 169277 | 169277 | 30566 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2245 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 9 | Permit Number 34543 | 6002231.0779 | 2118426.8867900004 | 37.796921821948 | -122.436329368507 | (37.796921821948, -122.436329368507) | ||
| 169276 | 169276 | 136245 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1723 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006515.15933 | 2116648.60219 | 37.7922815836866 | -122.421379054996 | (37.7922815836866, -122.421379054996) | |||
| 169270 | 169270 | 73714 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2110 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 9 | 6012133.53509 | 2102840.64813 | 37.75468325634171 | -122.400968639917 | (37.7546832563417, -122.400968639917) | ||
| 169247 | 169247 | 239359 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6003915.03036 | 2100651.96891 | 37.7482117843565 | -122.42923439386699 | (37.7482117843565, -122.429234393867) | |||
| 168763 | 168763 | 213992 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6001188.39506 | 2095218.69175 | 37.733138545197704 | -122.43827381338801 | (37.7331385451977, -122.438273813388) | |||
| 168725 | 168725 | 74150 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 740 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1995 12:00:00 AM | 8 | 6004499.396000001 | 2111088.6935 | 37.776901605564206 | -122.427957272174 | (37.7769016055642, -122.427957272174) | ||
| 168559 | 168559 | 179317 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 213 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009388.38978 | 2094971.87362 | 37.7329238140651 | -122.40990669864999 | (37.7329238140651, -122.40990669865) | |||
| 168340 | 168340 | 197156 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 70 Hawkins Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016728.211 | 2095612.50382 | 37.73509148057529 | -122.38457540555001 | (37.7350914805753, -122.38457540555) | |||
| 168118 | 168118 | 123269 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 460 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993762.13117 | 2112380.5079099997 | 37.779835284094204 | -122.46519429844801 | (37.7798352840942, -122.465194298448) | |||
| 168024 | 168024 | 179299 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Peru Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004388.44448 | 2093015.96904 | 37.7272718493156 | -122.427053545987 | (37.7272718493156, -122.427053545987) | |||
| 167912 | 167912 | 137712 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1693 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001117.7986 | 2111396.751 | 37.7775555640701 | -122.43967731101101 | (37.7775555640701, -122.439677311011) | |||
| 167872 | 167872 | 179328 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 381 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003082.18231 | 2091589.31338 | 37.7232806193946 | -122.431467482451 | (37.7232806193946, -122.431467482451) | |||
| 167622 | 167622 | 213919 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 48 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996378.49971 | 2106675.08456 | 37.76432020522871 | -122.455730647159 | (37.7643202052287, -122.455730647159) | |||
| 167538 | 167538 | 179336 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 225 Naylor St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6002643.14283 | 2086748.99011 | 37.709965266168105 | -122.43263957156 | (37.7099652661681, -122.43263957156) | |||
| 167390 | 167390 | 140612 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 880 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003492.8085 | 2111354.3072 | 37.777573917234996 | -122.431458329369 | (37.777573917235, -122.431458329369) | |||
| 167380 | 167380 | 138444 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003354.9599 | 2114191.1274 | 37.785355301736004 | -122.43213783008999 | (37.785355301736, -122.43213783009) | |||
| 167341 | 167341 | 138453 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002943.8549 | 2114900.2728 | 37.7872791184788 | -122.433610826756 | (37.7872791184788, -122.433610826756) | |||
| 167332 | 167332 | 136212 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Spruce St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5997026.477630001 | 2115953.7993900003 | 37.7898342954728 | -122.454159706 | (37.7898342954728, -122.454159706) | |||
| 167314 | 167314 | 138129 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1850 FILLMORE ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003011.9121 | 2114750.6049 | 37.7868720297123 | -122.433364664404 | (37.7868720297123, -122.433364664404) | |||
| 167199 | 167199 | 239258 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 455 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005532.11414 | 2101023.4503599997 | 37.749323199804394 | -122.423668969944 | (37.7493231998044, -122.423668969944) | |||
| 167097 | 167097 | 240168 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 116 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5998899.29279 | 2107504.14215 | 37.766740931067204 | -122.447071634562 | (37.7667409310672, -122.447071634562) | |||
| 166963 | 166963 | 69319 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1490 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1994 12:00:00 AM | 8 | Permit Number 33400 | 6004756.29564 | 2120212.83745 | 37.801968740827206 | -122.42771882665899 | (37.8019687408272, -122.427718826659) | ||
| 166878 | 166878 | 182744 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1769 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986859.8585 | 2103239.7166 | 37.754336768117206 | -122.488400024275 | (37.7543367681172, -122.488400024275) | |||
| 166872 | 166872 | 239249 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3750 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005421.44735 | 2100814.19078 | 37.748742373565 | -122.424036779171 | (37.748742373565, -122.424036779171) | |||
| 166740 | 166740 | 239355 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 117 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6005097.05649 | 2098708.2685700003 | 37.7429416735155 | -122.425008707103 | (37.7429416735155, -122.425008707103) | |||
| 166708 | 166708 | 137981 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1940 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002965.4976 | 2115097.1921 | 37.7878210367847 | -122.433550025903 | (37.7878210367847, -122.433550025903) | |||
| 166691 | 166691 | 244474 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1909 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997392.6079 | 2108791.0607 | 37.7701882806465 | -122.452375851759 | (37.7701882806465, -122.452375851759) | |||
| 166527 | 166527 | 197112 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2051 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012308.80023 | 2102801.3144400003 | 37.754585029698504 | -122.400359759302 | (37.7545850296985, -122.400359759302) | |||
| 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) |
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");