Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5520 | 5520 | 37970 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 602 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40200 | ||||||||
| 106879 | 106879 | 67263 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 552 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | Permit Number 30730 | 5981340.11898895 | 2111976.56286736 | 37.778002010661105 | -122.508136768544 | (37.7780020106611, -122.508136768544) | ||
| 44309 | 44309 | 41283 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3948 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2000 12:00:00 AM | 0 | Permit Number 41961 | 5981803.95386186 | 2102184.90266006 | 37.751144251784204 | -122.505806132064 | (37.7511442517842, -122.505806132064) | ||
| 56169 | 56169 | 184315 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1557 39th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5984032.5928 | 2104430.6415 | 37.757441347389495 | -122.49826522824101 | (37.7574413473895, -122.498265228241) | |||
| 64271 | 64271 | 184317 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1557 39th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5984033.1876 | 2104377.9194 | 37.7572966221146 | -122.49825927742901 | (37.7572966221146, -122.498259277429) | |||
| 143537 | 143537 | 48492 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 789(REVISED) 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | Permit Number 45835 | 5984443.84017034 | 2110481.58351844 | 37.7740796289032 | -122.49728966782 | (37.7740796289032, -122.49728966782) | ||
| 116903 | 116903 | 62604 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 796 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | Permit Number 22912 | 5984497.70797117 | 2110431.26743747 | 37.773944632299205 | -122.497099617838 | (37.7739446322992, -122.497099617838) | ||
| 93578 | 93578 | 63203 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2 Shore View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23745 | 5984685.41505479 | 2112889.29978003 | 37.78070467946971 | -122.496631747831 | (37.7807046794697, -122.496631747831) | ||
| 89083 | 89083 | 60549 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 523 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20159 | 5985000.44766821 | 2112307.598992 | 37.7791259492381 | -122.495498998876 | (37.7791259492381, -122.495498998876) | ||
| 90109 | 90109 | 60554 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 562 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20164 | 5985061.1383554 | 2112041.58145553 | 37.7783990952425 | -122.49526942507799 | (37.7783990952425, -122.495269425078) | ||
| 144201 | 144201 | 60542 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 615 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20152 | 5985331.57099648 | 2111677.45152223 | 37.7774151286277 | -122.494307063797 | (37.7774151286277, -122.494307063797) | ||
| 171666 | 171666 | 250762 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 231 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5985862.1127 | 2114339.7343200003 | 37.7847560253059 | -122.492667897222 | (37.7847560253059, -122.492667897222) | |||
| 134419 | 134419 | 250765 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 233 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5985862.4280199995 | 2114310.4019 | 37.784675505401204 | -122.49266464526 | (37.7846755054012, -122.49266464526) | |||
| 72099 | 72099 | 250802 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 283 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986182.86321 | 2114039.35976 | 37.7839500331106 | -122.491536104007 | (37.7839500331106, -122.491536104007) | |||
| 25337 | 25337 | 250803 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 283 31st Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986183.75415 | 2114029.47113 | 37.7839229338472 | -122.491532293599 | (37.7839229338472, -122.491532293599) | |||
| 187775 | 187775 | 250901 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 262 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986843.4258 | 2114179.11857 | 37.784372351133 | -122.489261109739 | (37.784372351133, -122.489261109739) | |||
| 106430 | 106430 | 98025 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1633 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988173.0 | 2098960.0 | 37.742662336498604 | -122.48354516443199 | (37.7426623364986, -122.483545164432) | ||||
| 79998 | 79998 | 115675 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 650 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5988846.1 | 2110886.2 | 37.7754476168018 | -122.482091316315 | (37.7754476168018, -122.482091316315) | |||||
| 109700 | 109700 | 97313 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 926 Taraval St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1984 12:00:00 AM | 3x3 | 5990372.0 | 2099065.0 | 37.74307838657921 | -122.47594940431101 | (37.7430783865792, -122.475949404311) | |||
| 56060 | 56060 | 218830 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 833 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5990479.90891 | 2100386.13678 | 37.746712141459604 | -122.47567273941699 | (37.7467121414596, -122.475672739417) | |||
| 187354 | 187354 | 218829 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 833 Rivera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5990502.9727 | 2100388.60646 | 37.746720259628 | -122.475593168284 | (37.746720259628, -122.475593168284) | |||
| 33009 | 33009 | 218828 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 831 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5990524.89237 | 2100389.62216 | 37.746724319168294 | -122.47551744719802 | (37.7467243191683, -122.475517447198) | |||
| 55190 | 55190 | 218839 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990579.44919 | 2099089.86589 | 37.7431586880264 | -122.47523392331199 | (37.7431586880264, -122.475233923312) | |||
| 71516 | 71516 | 60144 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1614 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19674 | 5990908.81036863 | 2104400.55481137 | 37.7577595366377 | -122.47448257143101 | (37.7577595366377, -122.474482571431) | ||
| 101209 | 101209 | 61524 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 5301 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1984 12:00:00 AM | Permit Number 21481 | 5991172.88177213 | 2114060.20768973 | 37.784297623281105 | -122.474274166868 | (37.7842976232811, -122.474274166868) | ||
| 78841 | 78841 | 60152 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1790 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19683 | 5990948.80079989 | 2103226.18449464 | 37.7545373426794 | -122.47425857753299 | (37.7545373426794, -122.474258577533) | ||
| 164569 | 164569 | 218837 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 725 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990923.73813 | 2099033.65671 | 37.7430243014348 | -122.474039375442 | (37.7430243014348, -122.474039375442) | |||
| 71920 | 71920 | 218838 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 723 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990942.64769 | 2099036.77615 | 37.743033961950005 | -122.473974219529 | (37.74303396195, -122.473974219529) | |||
| 94180 | 94180 | 61525 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1341 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1989 12:00:00 AM | Permit Number 28272 | 5991348.55791434 | 2114747.92419088 | 37.7861960776153 | -122.47371658077299 | (37.7861960776153, -122.473716580773) | ||
| 141827 | 141827 | 61526 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1335 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1984 12:00:00 AM | Permit Number 21483 | 5991367.33157346 | 2114748.57792616 | 37.7861989598694 | -122.47365167719 | (37.7861989598694, -122.47365167719) | ||
| 137425 | 137425 | 218836 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1550 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991107.229069999 | 2098459.95547 | 37.741459692423796 | -122.473363085249 | (37.7414596924238, -122.473363085249) | |||
| 66970 | 66970 | 218835 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1550 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991107.253719999 | 2098449.01305 | 37.7414296487733 | -122.473362202106 | (37.7414296487733, -122.473362202106) | |||
| 71781 | 71781 | 218834 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1550 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991139.93283 | 2098423.38649 | 37.7413611770786 | -122.473247341618 | (37.7413611770786, -122.473247341618) | |||
| 164535 | 164535 | 218833 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1550 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991183.94041 | 2098426.0210599997 | 37.7413709589947 | -122.473095372371 | (37.7413709589947, -122.473095372371) | |||
| 182314 | 182314 | 218832 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1550 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991196.18997 | 2098425.25378 | 37.7413695614616 | -122.473052962144 | (37.7413695614616, -122.473052962144) | |||
| 174580 | 174580 | 218831 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1550 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991205.91202 | 2098425.81226 | 37.7413716577778 | -122.473019387736 | (37.7413716577778, -122.473019387736) | |||
| 132188 | 132188 | 218827 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 15 Rossmoor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991236.4555 | 2094303.51433 | 37.730054641287204 | -122.472613299773 | (37.7300546412872, -122.472613299773) | |||
| 85375 | 85375 | 98530 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 701X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991613.7 | 2110635.6 | 37.77492011755329 | -122.472499350726 | (37.7749201175533, -122.472499350726) | ||||
| 95737 | 95737 | 98531 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 701X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991613.7 | 2110635.6 | 37.77492011755329 | -122.472499350726 | (37.7749201175533, -122.472499350726) | ||||
| 159184 | 159184 | 218819 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 205 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5991410.90841 | 2090573.24495 | 37.71982234389839 | -122.47173845727801 | (37.7198223438984, -122.471738457278) | |||
| 48220 | 48220 | 218820 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 205 Beverly St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5991411.7286 | 2090565.37313 | 37.7198007772708 | -122.471735048829 | (37.7198007772708, -122.471735048829) | |||
| 143728 | 143728 | 218821 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 278 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5991714.63996 | 2090365.5771400002 | 37.719269707816 | -122.47067345584101 | (37.719269707816, -122.470673455841) | |||
| 67463 | 67463 | 176433 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 118 Chester Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991720.02905 | 2088438.7014799998 | 37.7139792884876 | -122.470514566313 | (37.7139792884876, -122.470514566313) | |||
| 148024 | 148024 | 218804 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 161 San Rafael Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5991882.495080001 | 2095116.63402 | 37.7323246389721 | -122.470439076297 | (37.7323246389721, -122.470439076297) | |||
| 179557 | 179557 | 176434 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 109 Chester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991752.24555 | 2088448.0917 | 37.714006934552 | -122.47040389841999 | (37.714006934552, -122.47040389842) | |||
| 186397 | 186397 | 218803 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2370 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992349.88043 | 2099344.31841 | 37.7439598068059 | -122.46913081273199 | (37.7439598068059, -122.469130812732) | |||
| 52756 | 52756 | 218802 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2370 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992350.84884 | 2099324.20257 | 37.7439046297971 | -122.46912600049 | (37.7439046297971, -122.46912600049) | |||
| 79346 | 79346 | 63166 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1534 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23703 | 5992780.43210356 | 2105015.68842996 | 37.7595567946867 | -122.468054529997 | (37.7595567946867, -122.468054529997) | ||
| 45557 | 45557 | 218824 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 104 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5992465.47636 | 2088577.7234599998 | 37.7144040850433 | -122.46794814758499 | (37.7144040850433, -122.467948147585) | |||
| 26790 | 26790 | 218822 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 210 Vernon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5992480.53035 | 2089289.94219 | 37.7163605349795 | -122.467947888583 | (37.7163605349795, -122.467947888583) | |||
| 171301 | 171301 | 218823 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 122 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5992474.68721 | 2088695.0453700002 | 37.7147267546141 | -122.467924839857 | (37.7147267546141, -122.467924839857) | |||
| 181310 | 181310 | 218840 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 18 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992943.37066 | 2098991.78527 | 37.7430261153754 | -122.467053051482 | (37.7430261153754, -122.467053051482) | |||
| 78071 | 78071 | 54520 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 836 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | Permit Number 11498 | 5993201.36132572 | 2106658.05231245 | 37.7640905954535 | -122.466718145476 | (37.7640905954535, -122.466718145476) | |||
| 85104 | 85104 | 98237 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1299X 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 32025 | 5993314.0 | 2106663.0 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | ||||
| 97387 | 97387 | 98238 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1299X 09th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 32025 | 5993314.0 | 2106663.0 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | ||||
| 96102 | 96102 | 55379 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1236 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1972 12:00:00 AM | Permit Number 11316 | 5993330.37884563 | 2107053.53607455 | 37.7651839347095 | -122.46630065915501 | (37.7651839347095, -122.466300659155) | |||
| 84518 | 84518 | 101285 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1236 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 11316 | 5993350.8 | 2107040.7 | 37.7651498684815 | -122.466229094974 | (37.7651498684815, -122.466229094974) | |||
| 143341 | 143341 | 59298 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 734 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1980 12:00:00 AM | Permit Number 18636 | 5993516.37713931 | 2106668.84289355 | 37.7641383983924 | -122.465629390558 | (37.7641383983924, -122.465629390558) | |||
| 124911 | 124911 | 101249 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 734 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993518.0 | 2106670.0 | 37.764141669108 | -122.46562386166799 | (37.764141669108, -122.465623861668) | ||||
| 137901 | 137901 | 218826 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 354 Head St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5993503.058019999 | 2088221.2574099998 | 37.713485177561004 | -122.46433601702 | (37.713485177561, -122.46433601702) | |||
| 66569 | 66569 | 218841 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1522 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994017.40797 | 2105128.44374 | 37.7599377495509 | -122.463784669644 | (37.7599377495509, -122.463784669644) | |||
| 42892 | 42892 | 218825 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 295 Bright St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5993731.49381 | 2089150.28883 | 37.716049240944706 | -122.463613852416 | (37.7160492409447, -122.463613852416) | |||
| 184163 | 184163 | 176435 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 275 De Long St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 10ft | 5993714.58235 | 2086792.86785 | 37.7095753489021 | -122.46350132202299 | (37.7095753489021, -122.463501322023) | |||
| 104397 | 104397 | 65917 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1322 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28932 | 5994588.71634117 | 2106515.79856518 | 37.7637799716089 | -122.461909408356 | (37.7637799716089, -122.461909408356) | ||
| 124159 | 124159 | 65465 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 618 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1989 12:00:00 AM | Permit Number 28343 | 5994991.49008264 | 2091257.73775868 | 37.721908315427704 | -122.459411273619 | (37.7219083154277, -122.459411273619) | ||
| 118567 | 118567 | 65474 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1185 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1989 12:00:00 AM | Permit Number 28355 | 5995034.99249971 | 2091783.3730714 | 37.72335408532629 | -122.459298943633 | (37.7233540853263, -122.459298943633) | ||
| 121528 | 121528 | 113877 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 101 HUGO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995437.0 | 2107003.0 | 37.7651664998927 | -122.45901075309999 | (37.7651664998927, -122.4590107531) | ||||
| 92970 | 92970 | 54514 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1221 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 20683 | 5995443.00414725 | 2107246.09430383 | 37.7658343190377 | -122.459007589279 | (37.7658343190377, -122.459007589279) | ||
| 25991 | 25991 | 251008 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3878 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995662.214869999 | 2115838.76904 | 37.7894401289022 | -122.45887156539499 | (37.7894401289022, -122.458871565395) | |||
| 75115 | 75115 | 218805 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 67 Marne Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5995289.12081 | 2097585.29615 | 37.739299364370005 | -122.45884033191099 | (37.73929936437, -122.458840331911) | |||
| 147242 | 147242 | 250310 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3878 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995676.88978 | 2115841.1433599996 | 37.7894474916527 | -122.458820964144 | (37.7894474916527, -122.458820964144) | |||
| 159330 | 159330 | 250313 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3832 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995868.43222 | 2115867.93469 | 37.7895320612144 | -122.45816019263701 | (37.7895320612144, -122.458160192637) | |||
| 40147 | 40147 | 250314 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3828 Jackson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995896.25125 | 2115871.75264 | 37.789544142705395 | -122.45806421881201 | (37.7895441427054, -122.458064218812) | |||
| 136233 | 136233 | 251012 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3828 Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995905.52497 | 2115874.1850799997 | 37.7895513543625 | -122.458032309042 | (37.7895513543625, -122.458032309042) | |||
| 56620 | 56620 | 250315 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3828 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995912.982369999 | 2115873.6025799997 | 37.789550183443495 | -122.45800646522301 | (37.7895501834435, -122.458006465223) | |||
| 132844 | 132844 | 251013 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3828 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995926.37639 | 2115877.04966 | 37.78956041774 | -122.457960373191 | (37.78956041774, -122.457960373191) | |||
| 24936 | 24936 | 250316 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3828 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995936.88043 | 2115877.7469599997 | 37.7895629358285 | -122.457924081037 | (37.7895629358285, -122.457924081037) | |||
| 71221 | 71221 | 251014 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3828 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995959.01851 | 2115881.76769 | 37.78957524753479 | -122.457847777179 | (37.7895752475348, -122.457847777179) | |||
| 44349 | 44349 | 124423 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5996107.9721800005 | 2115471.34233 | 37.78845688642 | -122.45730271274401 | (37.78845688642, -122.457302712744) | |||
| 154029 | 154029 | 124424 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5996110.10232 | 2115455.34422 | 37.788413082259105 | -122.45729418503599 | (37.7884130822591, -122.457294185036) | |||
| 95118 | 95118 | 40081 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 22 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41303 | 5996321.69068784 | 2112123.86441597 | 37.7792778762225 | -122.456321143761 | (37.7792778762225, -122.456321143761) | ||||
| 76726 | 76726 | 218814 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 317 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995878.65108 | 2088143.0591400003 | 37.7134071101336 | -122.45611952571801 | (37.7134071101336, -122.456119525718) | |||
| 156993 | 156993 | 218813 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 317 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995878.91715 | 2088155.78665 | 37.7134420721779 | -122.45611952571801 | (37.7134420721779, -122.456119525718) | |||
| 43618 | 43618 | 218812 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 317 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995879.6181 | 2088168.92922 | 37.713478198842296 | -122.456118052617 | (37.7134781988423, -122.456118052617) | |||
| 169194 | 169194 | 218815 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 317 Plymouth Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995878.855380001 | 2088132.4441900002 | 37.713377975685205 | -122.456118052609 | (37.7133779756852, -122.456118052609) | |||
| 134768 | 134768 | 30927 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 236 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34740 | 5996038.7385 | 2091232.9544799998 | 37.7219004244455 | -122.455789433158 | (37.7219004244455, -122.455789433158) | |
| 150299 | 150299 | 30926 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 230 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34739 | 5996065.71046 | 2091231.3003900002 | 37.7218974306099 | -122.455696079012 | (37.7218974306099, -122.455696079012) | |
| 83657 | 83657 | 107775 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 311 PARNASSUS AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996666.6 | 2106591.7 | 37.7641077820156 | -122.454728170136 | (37.7641077820156, -122.454728170136) | |||||
| 154959 | 154959 | 126619 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3616 Jackson St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 5996924.84901 | 2116015.0059599997 | 37.789996524161 | -122.45451575299299 | (37.789996524161, -122.454515752993) | |||
| 175781 | 175781 | 126621 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3616 Jackson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 5996947.82538 | 2116018.92975 | 37.7900086155661 | -122.454436540723 | (37.7900086155661, -122.454436540723) | |||
| 176566 | 176566 | 218809 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 118 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996535.53946 | 2090678.52967 | 37.720406603762 | -122.45403210661001 | (37.720406603762, -122.45403210661) | |||
| 167625 | 167625 | 218817 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 431 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5996521.08411 | 2089810.0200599998 | 37.7180210513199 | -122.454019381193 | (37.7180210513199, -122.454019381193) | |||
| 101414 | 101414 | 66836 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2920 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1993 12:00:00 AM | Permit Number 30137 | 5997039.99678003 | 2111588.58372334 | 37.777849344501 | -122.453797573256 | (37.777849344501, -122.453797573256) | ||
| 155873 | 155873 | 218816 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 170 Margaret Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 5996666.019619999 | 2089250.8609200001 | 37.716494040240796 | -122.45347805498899 | (37.7164940402408, -122.453478054989) | |||
| 50097 | 50097 | 62304 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2504 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | Permit Number 22442 | 5997225.79467532 | 2110840.29768365 | 37.7758053966105 | -122.45310080621901 | (37.7758053966105, -122.453100806219) | ||
| 45410 | 45410 | 218818 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 230 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5996994.979669999 | 2089536.5843200001 | 37.7172974217136 | -122.452361618599 | (37.7172974217136, -122.452361618599) | |||
| 63243 | 63243 | 218810 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 75 Williar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997095.6983 | 2090612.61251 | 37.7202577138075 | -122.452091075552 | (37.7202577138075, -122.452091075552) | |||
| 33319 | 33319 | 218811 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 75 Williar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997101.63162 | 2090622.46989 | 37.7202851197392 | -122.45207127696999 | (37.7202851197392, -122.45207127697) | |||
| 125427 | 125427 | 61140 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2132 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | Permit Number 20992 | 5997609.15376905 | 2110265.51143343 | 37.7742491458885 | -122.451733203729 | (37.7742491458885, -122.451733203729) | ||
| 108706 | 108706 | 61139 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2128 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | Permit Number 20991 | 5997627.50212199 | 2110268.03572246 | 37.774257127748605 | -122.45166991589599 | (37.7742571277486, -122.451669915896) |
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");