trees
969 rows where qSpecies_id = 97 sorted by XCoord
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15539 | 37970 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 602 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | Permit Number 40200 | |||||||||||||
| 124631 | 67263 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 552 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | Permit Number 30730 | 5981340.11898895 | 2111976.56286736 | 37.7780020106611 | -122.508136768544 | (37.7780020106611, -122.508136768544) | 11 | 6 | 2 | 55 | 26 | ||
| 141932 | 41283 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3948 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2000 12:00:00 AM | 0 | Permit Number 41961 | 5981803.95386186 | 2102184.90266006 | 37.7511442517842 | -122.505806132064 | (37.7511442517842, -122.505806132064) | 1 | 8 | 3 | 56 | 35 | ||
| 37941 | 184315 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1557 39th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5984032.5928 | 2104430.6415 | 37.7574413473895 | -122.498265228241 | (37.7574413473895, -122.498265228241) | 1 | 8 | 3 | 56 | 35 | |||
| 77132 | 184317 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1557 39th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5984033.1876 | 2104377.9194 | 37.7572966221146 | -122.498259277429 | (37.7572966221146, -122.498259277429) | 1 | 8 | 3 | 56 | 35 | |||
| 172351 | 48492 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 789(REVISED) 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1986 12:00:00 AM | Permit Number 45835 | 5984443.84017034 | 2110481.58351844 | 37.7740796289032 | -122.49728966782 | (37.7740796289032, -122.49728966782) | 11 | 6 | 2 | 55 | 26 | ||
| 169413 | 62604 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 796 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1986 12:00:00 AM | Permit Number 22912 | 5984497.70797117 | 2110431.26743747 | 37.7739446322992 | -122.497099617838 | (37.7739446322992, -122.497099617838) | 11 | 6 | 2 | 55 | 26 | ||
| 94509 | 63203 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2 Shore View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | Permit Number 23745 | 5984685.41505479 | 2112889.29978003 | 37.7807046794697 | -122.496631747831 | (37.7807046794697, -122.496631747831) | 11 | 6 | 2 | 55 | 26 | ||
| 60273 | 60549 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 523 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20159 | 5985000.44766821 | 2112307.598992 | 37.7791259492381 | -122.495498998876 | (37.7791259492381, -122.495498998876) | 11 | 6 | 2 | 55 | 26 | ||
| 64863 | 60554 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 562 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20164 | 5985061.1383554 | 2112041.58145553 | 37.7783990952425 | -122.495269425078 | (37.7783990952425, -122.495269425078) | 11 | 6 | 2 | 55 | 26 | ||
| 176171 | 60542 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 615 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20152 | 5985331.57099648 | 2111677.45152223 | 37.7774151286277 | -122.494307063797 | (37.7774151286277, -122.494307063797) | 11 | 6 | 2 | 55 | 26 | ||
| 30056 | 250762 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 231 32nd Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5985862.1127 | 2114339.73432 | 37.7847560253059 | -122.492667897222 | (37.7847560253059, -122.492667897222) | 11 | 6 | 1 | 55 | 33 | |||
| 121213 | 250765 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 233 32nd Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5985862.42802 | 2114310.4019 | 37.7846755054012 | -122.49266464526 | (37.7846755054012, -122.49266464526) | 11 | 6 | 1 | 55 | 33 | |||
| 37346 | 250802 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 283 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5986182.86321 | 2114039.35976 | 37.7839500331106 | -122.491536104007 | (37.7839500331106, -122.491536104007) | 11 | 6 | 1 | 55 | 33 | |||
| 8038 | 250803 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 283 31st Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5986183.75415 | 2114029.47113 | 37.7839229338472 | -122.491532293599 | (37.7839229338472, -122.491532293599) | 11 | 6 | 1 | 55 | 33 | |||
| 141514 | 250901 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 262 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5986843.4258 | 2114179.11857 | 37.784372351133 | -122.489261109739 | (37.784372351133, -122.489261109739) | 11 | 6 | 1 | 55 | 33 | |||
| 129256 | 98025 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1633 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988173 | 2098960 | 37.7426623364986 | -122.483545164432 | (37.7426623364986, -122.483545164432) | 1 | 8 | 3 | 29491 | 35 | ||||
| 66528 | 115675 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 650 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5988846.1 | 2110886.2 | 37.7754476168018 | -122.482091316315 | (37.7754476168018, -122.482091316315) | 11 | 6 | 2 | 55 | 26 | |||||
| 114822 | 97313 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 926 Taraval St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/1984 12:00:00 AM | 3x3 | 5990372 | 2099065 | 37.7430783865792 | -122.475949404311 | (37.7430783865792, -122.475949404311) | 1 | 8 | 3 | 29491 | 35 | |||
| 135351 | 218830 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 833 Rivera St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5990479.90891 | 2100386.13678 | 37.7467121414596 | -122.475672739417 | (37.7467121414596, -122.475672739417) | 1 | 8 | 4 | 29491 | 40 | |||
| 51462 | 218829 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 833 Rivera St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5990502.9727 | 2100388.60646 | 37.746720259628 | -122.475593168284 | (37.746720259628, -122.475593168284) | 1 | 8 | 4 | 29491 | 40 | |||
| 28762 | 218828 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 831 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5990524.89237 | 2100389.62216 | 37.7467243191683 | -122.475517447198 | (37.7467243191683, -122.475517447198) | 1 | 8 | 4 | 29491 | 40 | |||
| 7426 | 218839 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2010 12:00:00 AM | 2 | Width 3ft | Permit Number 54033 | 5990579.44919 | 2099089.86589 | 37.7431586880264 | -122.475233923312 | (37.7431586880264, -122.475233923312) | 1 | 8 | 4 | 29491 | 40 | |
| 5392 | 60144 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1614 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19674 | 5990908.81036863 | 2104400.55481137 | 37.7577595366377 | -122.474482571431 | (37.7577595366377, -122.474482571431) | 1 | 8 | 4 | 56 | 12 | ||
| 182989 | 218837 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 725 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990923.73813 | 2099033.65671 | 37.7430243014348 | -122.474039375442 | (37.7430243014348, -122.474039375442) | 1 | 8 | 4 | 29491 | 40 | |||
| 133330 | 218838 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 723 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990942.64769 | 2099036.77615 | 37.74303396195 | -122.473974219529 | (37.74303396195, -122.473974219529) | 1 | 8 | 4 | 29491 | 40 | |||
| 55197 | 60152 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1790 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19683 | 5990948.80079989 | 2103226.18449464 | 37.7545373426794 | -122.474258577533 | (37.7545373426794, -122.474258577533) | 1 | 8 | 4 | 56 | 12 | ||
| 163838 | 218836 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991107.22907 | 2098459.95547 | 37.7414596924238 | -122.473363085249 | (37.7414596924238, -122.473363085249) | 1 | 8 | 4 | 29491 | 40 | |||
| 135076 | 218835 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991107.25372 | 2098449.01305 | 37.7414296487733 | -122.473362202106 | (37.7414296487733, -122.473362202106) | 1 | 8 | 4 | 29491 | 40 | |||
| 73159 | 218834 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991139.93283 | 2098423.38649 | 37.7413611770786 | -122.473247341618 | (37.7413611770786, -122.473247341618) | 1 | 8 | 4 | 29491 | 40 | |||
| 34968 | 258294 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2498X 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991168 | 2098442 | 37.7414139101312 | -122.473151653247 | (37.7414139101312, -122.473151653247) | 1 | 8 | 4 | 29491 | 40 | ||||
| 107613 | 258293 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2498X 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991168 | 2098442 | 37.7414139101312 | -122.473151653247 | (37.7414139101312, -122.473151653247) | 1 | 8 | 4 | 29491 | 40 | ||||
| 98172 | 61524 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 5301 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1984 12:00:00 AM | Permit Number 21481 | 5991172.88177213 | 2114060.20768973 | 37.7842976232811 | -122.474274166868 | (37.7842976232811, -122.474274166868) | 11 | 6 | 2 | 54 | 26 | ||
| 24232 | 218833 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991183.94041 | 2098426.02106 | 37.7413709589947 | -122.473095372371 | (37.7413709589947, -122.473095372371) | 1 | 8 | 4 | 29491 | 40 | |||
| 120941 | 218832 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991196.18997 | 2098425.25378 | 37.7413695614616 | -122.473052962144 | (37.7413695614616, -122.473052962144) | 1 | 8 | 4 | 29491 | 40 | |||
| 184346 | 218831 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991205.91202 | 2098425.81226 | 37.7413716577778 | -122.473019387736 | (37.7413716577778, -122.473019387736) | 1 | 8 | 4 | 29491 | 40 | |||
| 184895 | 218827 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 15 Rossmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991236.4555 | 2094303.51433 | 37.7300546412872 | -122.472613299773 | (37.7300546412872, -122.472613299773) | 9 | 8 | 4 | 64 | 40 | |||
| 76352 | 61525 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1341 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1989 12:00:00 AM | Permit Number 28272 | 5991348.55791434 | 2114747.92419088 | 37.7861960776153 | -122.473716580773 | (37.7861960776153, -122.473716580773) | 11 | 6 | 2 | 54 | 26 | ||
| 178899 | 61526 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1335 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1984 12:00:00 AM | Permit Number 21483 | 5991367.33157346 | 2114748.57792616 | 37.7861989598694 | -122.47365167719 | (37.7861989598694, -122.47365167719) | 11 | 6 | 2 | 54 | 26 | ||
| 24672 | 218819 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 205 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5991410.90841 | 2090573.24495 | 37.7198223438984 | -122.471738457278 | (37.7198223438984, -122.471738457278) | 9 | 8 | 6 | 64 | 24 | |||
| 161624 | 218820 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 205 Beverly St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5991411.7286 | 2090565.37313 | 37.7198007772708 | -122.471735048829 | (37.7198007772708, -122.471735048829) | 9 | 8 | 6 | 64 | 24 | |||
| 58522 | 98530 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 701X 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991613.7 | 2110635.6 | 37.7749201175533 | -122.472499350726 | (37.7749201175533, -122.472499350726) | 11 | 6 | 2 | 54 | 26 | ||||
| 94913 | 98531 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 701X 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991613.7 | 2110635.6 | 37.7749201175533 | -122.472499350726 | (37.7749201175533, -122.472499350726) | 11 | 6 | 2 | 54 | 26 | ||||
| 71226 | 218821 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 278 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5991714.63996 | 2090365.57714 | 37.719269707816 | -122.470673455841 | (37.719269707816, -122.470673455841) | 9 | 8 | 6 | 64 | 24 | |||
| 189517 | 176433 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 118 Chester Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991720.02905 | 2088438.70148 | 37.7139792884876 | -122.470514566313 | (37.7139792884876, -122.470514566313) | 9 | 8 | 6 | 64 | 24 | |||
| 53327 | 176434 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 109 Chester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991752.24555 | 2088448.0917 | 37.714006934552 | -122.47040389842 | (37.714006934552, -122.47040389842) | 9 | 8 | 6 | 64 | 24 | |||
| 132605 | 218804 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 161 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5991882.49508 | 2095116.63402 | 37.7323246389721 | -122.470439076297 | (37.7323246389721, -122.470439076297) | 9 | 8 | 4 | 59 | 40 | |||
| 40301 | 218803 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2370 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5992349.88043 | 2099344.31841 | 37.7439598068059 | -122.469130812732 | (37.7439598068059, -122.469130812732) | 1 | 8 | 4 | 29491 | 40 | |||
| 145876 | 218802 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2370 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5992350.84884 | 2099324.20257 | 37.7439046297971 | -122.46912600049 | (37.7439046297971, -122.46912600049) | 1 | 8 | 4 | 29491 | 40 | |||
| 103243 | 218824 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 104 Vernon St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5992465.47636 | 2088577.72346 | 37.7144040850433 | -122.467948147585 | (37.7144040850433, -122.467948147585) | 9 | 8 | 6 | 64 | 24 | |||
| 149904 | 218823 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 122 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5992474.68721 | 2088695.04537 | 37.7147267546141 | -122.467924839857 | (37.7147267546141, -122.467924839857) | 9 | 8 | 6 | 64 | 24 | |||
| 50071 | 218822 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 210 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5992480.53035 | 2089289.94219 | 37.7163605349795 | -122.467947888583 | (37.7163605349795, -122.467947888583) | 9 | 8 | 6 | 64 | 24 | |||
| 54947 | 63166 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1534 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23703 | 5992780.43210356 | 2105015.68842996 | 37.7595567946867 | -122.468054529997 | (37.7595567946867, -122.468054529997) | 1 | 8 | 4 | 56 | 12 | ||
| 42835 | 218840 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 18 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992943.37066 | 2098991.78527 | 37.7430261153754 | -122.467053051482 | (37.7430261153754, -122.467053051482) | 1 | 8 | 4 | 59 | 40 | |||
| 26889 | 54520 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 836 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | Permit Number 11498 | 5993201.36132572 | 2106658.05231245 | 37.7640905954535 | -122.466718145476 | (37.7640905954535, -122.466718145476) | 11 | 8 | 11 | 56 | 12 | |||
| 68365 | 98237 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1299X 09th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 32025 | 5993314 | 2106663 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | 11 | 8 | 11 | 56 | 12 | ||||
| 83507 | 98238 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1299X 09th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 32025 | 5993314 | 2106663 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | 11 | 8 | 11 | 56 | 12 | ||||
| 77928 | 55379 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1236 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/1972 12:00:00 AM | Permit Number 11316 | 5993330.37884563 | 2107053.53607455 | 37.7651839347095 | -122.466300659155 | (37.7651839347095, -122.466300659155) | 11 | 8 | 11 | 56 | 12 | |||
| 43482 | 101285 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1236 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 11316 | 5993350.8 | 2107040.7 | 37.7651498684815 | -122.466229094974 | (37.7651498684815, -122.466229094974) | 11 | 8 | 11 | 56 | 12 | |||
| 147151 | 218826 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 354 Head St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5993503.05802 | 2088221.25741 | 37.713485177561 | -122.46433601702 | (37.713485177561, -122.46433601702) | 9 | 8 | 6 | 64 | 24 | |||
| 186372 | 59298 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 734 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1980 12:00:00 AM | Permit Number 18636 | 5993516.37713931 | 2106668.84289355 | 37.7641383983924 | -122.465629390558 | (37.7641383983924, -122.465629390558) | 11 | 8 | 11 | 56 | 12 | |||
| 27917 | 101249 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 734 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993518 | 2106670 | 37.764141669108 | -122.465623861668 | (37.764141669108, -122.465623861668) | 11 | 8 | 11 | 56 | 12 | ||||
| 117760 | 176435 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 275 De Long St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 5993714.58235 | 2086792.86785 | 37.7095753489021 | -122.463501322023 | (37.7095753489021, -122.463501322023) | 9 | 8 | 6 | 28861 | 25 | |||
| 169776 | 218825 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 295 Bright St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 5993731.49381 | 2089150.28883 | 37.7160492409447 | -122.463613852416 | (37.7160492409447, -122.463613852416) | 9 | 8 | 6 | 64 | 24 | |||
| 57590 | 218841 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1522 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994017.40797 | 2105128.44374 | 37.7599377495509 | -122.463784669644 | (37.7599377495509, -122.463784669644) | 1 | 5 | 4 | 56 | 12 | |||
| 122820 | 65917 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1322 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28932 | 5994588.71634117 | 2106515.79856518 | 37.7637799716089 | -122.461909408356 | (37.7637799716089, -122.461909408356) | 15 | 5 | 11 | 56 | 12 | ||
| 12747 | 65465 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 618 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 28343 | 5994991.49008264 | 2091257.73775868 | 37.7219083154277 | -122.459411273619 | (37.7219083154277, -122.459411273619) | 9 | 8 | 4 | 28861 | 24 | ||
| 153527 | 65474 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1185 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1989 12:00:00 AM | Permit Number 28355 | 5995034.99249971 | 2091783.3730714 | 37.7233540853263 | -122.459298943633 | (37.7233540853263, -122.459298943633) | 9 | 8 | 4 | 28861 | 24 | ||
| 98687 | 218805 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 67 Marne Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995289.12081 | 2097585.29615 | 37.73929936437 | -122.458840331911 | (37.73929936437, -122.458840331911) | 9 | 7 | 4 | 59 | 40 | |||
| 154697 | 113877 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 101 HUGO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995437 | 2107003 | 37.7651664998927 | -122.4590107531 | (37.7651664998927, -122.4590107531) | 15 | 5 | 11 | 56 | 12 | ||||
| 77511 | 54514 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1221 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20683 | 5995443.00414725 | 2107246.09430383 | 37.7658343190377 | -122.459007589279 | (37.7658343190377, -122.459007589279) | 15 | 5 | 11 | 56 | 12 | ||
| 5550 | 207625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1223 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5995447.2053 | 2107231.58705 | 37.7657947273793 | -122.458992007973 | (37.7657947273793, -122.458992007973) | 15 | 5 | 11 | 56 | 12 | |||
| 39540 | 251008 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3878 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995662.21487 | 2115838.76904 | 37.7894401289022 | -122.458871565395 | (37.7894401289022, -122.458871565395) | 11 | 6 | 1 | 54 | 31 | |||
| 123777 | 250310 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3878 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995676.88978 | 2115841.14336 | 37.7894474916527 | -122.458820964144 | (37.7894474916527, -122.458820964144) | 11 | 6 | 1 | 54 | 31 | |||
| 3331 | 250313 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3832 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | Permit Number 772728 | 5995868.43222 | 2115867.93469 | 37.7895320612144 | -122.458160192637 | (37.7895320612144, -122.458160192637) | 11 | 6 | 1 | 54 | 31 | ||
| 43800 | 218814 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 317 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995878.65108 | 2088143.05914 | 37.7134071101336 | -122.456119525718 | (37.7134071101336, -122.456119525718) | 9 | 8 | 6 | 28861 | 24 | |||
| 133682 | 218815 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 317 Plymouth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995878.85538 | 2088132.44419 | 37.7133779756852 | -122.456118052609 | (37.7133779756852, -122.456118052609) | 9 | 8 | 6 | 28861 | 24 | |||
| 184855 | 218813 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 317 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995878.91715 | 2088155.78665 | 37.7134420721779 | -122.456119525718 | (37.7134420721779, -122.456119525718) | 9 | 8 | 6 | 28861 | 24 | |||
| 70372 | 218812 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 317 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995879.6181 | 2088168.92922 | 37.7134781988423 | -122.456118052617 | (37.7134781988423, -122.456118052617) | 9 | 8 | 6 | 28861 | 24 | |||
| 125933 | 250314 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995896.25125 | 2115871.75264 | 37.7895441427054 | -122.458064218812 | (37.7895441427054, -122.458064218812) | 11 | 6 | 1 | 54 | 31 | |||
| 72078 | 251012 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995905.52497 | 2115874.18508 | 37.7895513543625 | -122.458032309042 | (37.7895513543625, -122.458032309042) | 11 | 6 | 1 | 54 | 31 | |||
| 177333 | 250315 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995912.98237 | 2115873.60258 | 37.7895501834435 | -122.458006465223 | (37.7895501834435, -122.458006465223) | 11 | 6 | 1 | 54 | 31 | |||
| 95847 | 251013 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995926.37639 | 2115877.04966 | 37.78956041774 | -122.457960373191 | (37.78956041774, -122.457960373191) | 11 | 6 | 1 | 54 | 31 | |||
| 158296 | 250316 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995936.88043 | 2115877.74696 | 37.7895629358285 | -122.457924081037 | (37.7895629358285, -122.457924081037) | 11 | 6 | 1 | 54 | 31 | |||
| 36191 | 251014 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995959.01851 | 2115881.76769 | 37.7895752475348 | -122.457847777179 | (37.7895752475348, -122.457847777179) | 11 | 6 | 1 | 54 | 31 | |||
| 178322 | 30927 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 236 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 13 | Permit Number 34740 | 5996038.7385 | 2091232.95448 | 37.7219004244455 | -122.455789433158 | (37.7219004244455, -122.455789433158) | 9 | 8 | 4 | 28861 | 24 | |
| 44712 | 30926 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 230 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 13 | Permit Number 34739 | 5996065.71046 | 2091231.30039 | 37.7218974306099 | -122.455696079012 | (37.7218974306099, -122.455696079012) | 9 | 8 | 4 | 28861 | 24 | |
| 44755 | 124423 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 207 Cherry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 5996107.97218 | 2115471.34233 | 37.78845688642 | -122.457302712744 | (37.78845688642, -122.457302712744) | 11 | 6 | 1 | 54 | 31 | |||
| 18655 | 124424 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 207 Cherry St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 5996110.10232 | 2115455.34422 | 37.7884130822591 | -122.457294185036 | (37.7884130822591, -122.457294185036) | 11 | 6 | 1 | 54 | 31 | |||
| 91227 | 40081 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 22 Rossi Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41303 | 5996321.69068784 | 2112123.86441597 | 37.7792778762225 | -122.456321143761 | (37.7792778762225, -122.456321143761) | 11 | 6 | 2 | 54 | 16 | ||||
| 125788 | 218817 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 431 Lakeview Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5996521.08411 | 2089810.02006 | 37.7180210513199 | -122.454019381193 | (37.7180210513199, -122.454019381193) | 9 | 8 | 6 | 28861 | 24 | |||
| 47140 | 218809 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 118 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996535.53946 | 2090678.52967 | 37.720406603762 | -122.45403210661 | (37.720406603762, -122.45403210661) | 9 | 8 | 6 | 28861 | 24 | |||
| 67440 | 218816 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 170 Margaret Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 5996666.01962 | 2089250.86092 | 37.7164940402408 | -122.453478054989 | (37.7164940402408, -122.453478054989) | 9 | 8 | 6 | 28861 | 24 | |||
| 42094 | 107775 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 311 PARNASSUS AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996666.6 | 2106591.7 | 37.7641077820156 | -122.454728170136 | (37.7641077820156, -122.454728170136) | 15 | 5 | 11 | 29492 | 12 | |||||
| 86489 | 126619 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3616 Jackson St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5996924.84901 | 2116015.00596 | 37.789996524161 | -122.454515752993 | (37.789996524161, -122.454515752993) | 11 | 6 | 1 | 54 | 31 | |||
| 132084 | 126621 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3616 Jackson St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5996947.82538 | 2116018.92975 | 37.7900086155661 | -122.454436540723 | (37.7900086155661, -122.454436540723) | 11 | 6 | 1 | 54 | 31 | |||
| 124492 | 218818 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 230 Lakeview Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5996994.97967 | 2089536.58432 | 37.7172974217136 | -122.452361618599 | (37.7172974217136, -122.452361618599) | 9 | 8 | 6 | 28861 | 24 | |||
| 98278 | 66836 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2920 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1993 12:00:00 AM | Permit Number 30137 | 5997039.99678003 | 2111588.58372334 | 37.777849344501 | -122.453797573256 | (37.777849344501, -122.453797573256) | 15 | 6 | 2 | 54 | 16 | ||
| 125538 | 218810 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 75 Williar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997095.6983 | 2090612.61251 | 37.7202577138075 | -122.452091075552 | (37.7202577138075, -122.452091075552) | 9 | 8 | 6 | 28861 | 24 | |||
| 38823 | 218811 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 75 Williar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997101.63162 | 2090622.46989 | 37.7202851197392 | -122.45207127697 | (37.7202851197392, -122.45207127697) | 9 | 8 | 6 | 28861 | 24 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );