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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 881 | 881 | 251399 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008927.4869099995 | 2120274.72498 | 37.802373734427796 | -122.413288863041 | (37.8023737344278, -122.413288863041) | ||||
| 855 | 855 | 251398 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 299 Townsend St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 1705 | 1705 | 251397 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 311 Townsend St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 859 | 859 | 251396 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 299 Townsend St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 166019 | 166019 | 249547 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 298 Myrtle St | 4 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6006068.98024 | 2114032.1287599998 | 37.7850722314402 | -122.422736821748 | (37.7850722314402, -122.422736821748) | |||
| 59560 | 59560 | 249546 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 298 Myrtle St | 3 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6006094.99565 | 2114034.77585 | 37.785080967461795 | -122.422647004665 | (37.7850809674618, -122.422647004665) | |||
| 43163 | 43163 | 249545 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 298 Myrtle St | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6006121.634219999 | 2114038.6036799997 | 37.7850929805917 | -122.42255511555099 | (37.7850929805917, -122.422555115551) | |||
| 4239 | 4239 | 244052 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 401 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997900.6668 | 2109181.4943 | 37.771289404865 | -122.450646641766 | (37.771289404865, -122.450646641766) | |||
| 3854 | 3854 | 244051 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 401 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997898.1905 | 2109198.4158 | 37.7713357252186 | -122.450656427551 | (37.7713357252186, -122.450656427551) | |||
| 42648 | 42648 | 226500 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 155 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6005540.15432 | 2099025.50317 | 37.743837747220894 | -122.423499143787 | (37.7438377472209, -122.423499143787) | |||
| 169405 | 169405 | 226499 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 133 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6005600.01114 | 2099028.12585 | 37.7438483268298 | -122.42329235906999 | (37.7438483268298, -122.42329235907) | |||
| 130967 | 130967 | 226498 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1850 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008688.72129 | 2107547.38011 | 37.767414104217295 | -122.41321458949601 | (37.7674141042173, -122.413214589496) | |||
| 161713 | 161713 | 226497 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1850 Harrison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008687.35447 | 2107561.73783 | 37.767453450448706 | -122.41322033256 | (37.7674534504487, -122.41322033256) | |||
| 76463 | 76463 | 226496 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1850 Harrison St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008684.6321 | 2107591.00428 | 37.767533656488 | -122.413231818694 | (37.767533656488, -122.413231818694) | |||
| 146825 | 146825 | 226495 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1850 Harrison St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008685.7148400005 | 2107616.88585 | 37.767604782056296 | -122.41322990403098 | (37.7676047820563, -122.413229904031) | |||
| 38008 | 38008 | 226494 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2300 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008770.52865 | 2104997.0899900002 | 37.7604161870861 | -122.412751310945 | (37.7604161870861, -122.412751310945) | |||
| 175285 | 175285 | 226493 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2300 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008772.32666 | 2104949.6501700003 | 37.7602860290962 | -122.41274173856002 | (37.7602860290962, -122.41274173856) | |||
| 66263 | 66263 | 226492 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2300 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008774.11165 | 2104928.66815 | 37.7602285174483 | -122.412734081726 | (37.7602285174483, -122.412734081726) | |||
| 26257 | 26257 | 226491 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2450 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008819.815769999 | 2104185.8103 | 37.7581913641506 | -122.412523500065 | (37.7581913641506, -122.412523500065) | |||
| 41825 | 41825 | 226490 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2450 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008822.75268 | 2104167.00903 | 37.758139904958206 | -122.412512013916 | (37.7581399049582, -122.412512013916) | |||
| 177370 | 177370 | 226489 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2496 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008832.21298 | 2104006.96318 | 37.757700986321 | -122.41246798312001 | (37.757700986321, -122.41246798312) | |||
| 148521 | 148521 | 226488 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2498 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008832.88031 | 2103985.45214 | 37.757641959338706 | -122.41246415471001 | (37.7576419593387, -122.41246415471) | |||
| 64033 | 64033 | 226487 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3120 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008546.79549 | 2105667.11477 | 37.7622433612724 | -122.41357249268499 | (37.7622433612724, -122.413572492685) | |||
| 154231 | 154231 | 226486 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3120 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008522.957719999 | 2105665.90861 | 37.7622387108737 | -122.41365485348801 | (37.7622387108737, -122.413654853488) | |||
| 178284 | 178284 | 226485 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3120 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008502.54321 | 2105665.76145 | 37.7622371604259 | -122.41372544938999 | (37.7622371604259, -122.41372544939) | |||
| 167655 | 167655 | 226484 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3120 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6008470.16955 | 2105663.03593 | 37.7622278587398 | -122.413837225211 | (37.7622278587398, -122.413837225211) | |||
| 55616 | 55616 | 226483 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3470 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006409.05576 | 2104966.19294 | 37.7601985241524 | -122.420916373596 | (37.7601985241524, -122.420916373596) | |||
| 151146 | 151146 | 226482 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3470 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006420.39089 | 2104965.96025 | 37.760198524162995 | -122.420877154151 | (37.760198524163, -122.420877154151) | |||
| 176422 | 176422 | 226481 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3235 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6007993.239469999 | 2105048.9001700003 | 37.7605147878543 | -122.415443270504 | (37.7605147878543, -122.415443270504) | |||
| 77245 | 77245 | 226480 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008258.38904 | 2105066.62295 | 37.7605783501336 | -122.414527490854 | (37.7605783501336, -122.414527490854) | |||
| 170500 | 170500 | 226479 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6008278.21403 | 2105065.6529900003 | 37.7605768005893 | -122.414458856385 | (37.7605768005893, -122.414458856385) | |||
| 167351 | 167351 | 226478 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6008300.96502 | 2105069.13983 | 37.760587652724396 | -122.41438041754 | (37.7605876527244, -122.41438041754) | |||
| 74404 | 74404 | 226477 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008318.01409 | 2105071.04935 | 37.7605938535523 | -122.414321587482 | (37.7605938535523, -122.414321587482) | |||
| 60202 | 60202 | 226476 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008336.71685 | 2105070.6667299997 | 37.7605938535513 | -122.414256875855 | (37.7605938535513, -122.414256875855) | |||
| 178689 | 178689 | 226475 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008399.696219999 | 2105072.76604 | 37.760603155239295 | -122.41403920664301 | (37.7606031552393, -122.414039206643) | |||
| 133723 | 133723 | 226474 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3160 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008423.54633 | 2105074.53683 | 37.7606093569454 | -122.41395684494101 | (37.7606093569454, -122.413956844941) | |||
| 42815 | 42815 | 226473 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3101 19th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008617.67732 | 2105085.24659 | 37.7606496645635 | -122.413286189004 | (37.7606496645635, -122.413286189004) | |||
| 30653 | 30653 | 226472 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3101 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008660.80856 | 2105087.18769 | 37.7606574158171 | -122.41313715427799 | (37.7606574158171, -122.413137154278) | |||
| 135207 | 135207 | 226471 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3101 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008696.0744900005 | 2105092.67763 | 37.760674469666 | -122.41301557310601 | (37.760674469666, -122.413015573106) | |||
| 71972 | 71972 | 226470 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3101 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008736.33721 | 2105092.9838400004 | 37.76067757053 | -122.412876343665 | (37.76067757053, -122.412876343665) | |||
| 175313 | 175313 | 226469 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3005 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009304.0856800005 | 2104491.35381 | 37.759057483222605 | -122.41087025746 | (37.7590574832226, -122.41087025746) | |||
| 134403 | 134403 | 226468 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3001 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009315.52474 | 2104496.20216 | 37.7590714371022 | -122.410831038029 | (37.7590714371022, -122.410831038029) | |||
| 164912 | 164912 | 224713 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3546 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006637.61846 | 2104388.97132 | 37.7586264885425 | -122.420084917099 | (37.7586264885425, -122.420084917099) | |||
| 63214 | 63214 | 224712 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3560 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006570.05679 | 2104384.7111400003 | 37.7586109842303 | -122.420318274095 | (37.7586109842303, -122.420318274095) | |||
| 178369 | 178369 | 224711 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3287 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006422.5903900005 | 2103751.13112 | 37.756863009738396 | -122.42078330091299 | (37.7568630097384, -122.420783300913) | |||
| 47541 | 47541 | 224710 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3278 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6006579.99639 | 2103217.6190400003 | 37.755406979454996 | -122.42020106814199 | (37.755406979455, -122.420201068142) | |||
| 150231 | 150231 | 224709 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3278 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6006609.601919999 | 2103216.71936 | 37.755406177257704 | -122.42009861917299 | (37.7554061772577, -122.420098619173) | |||
| 58368 | 58368 | 224708 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3018 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6008114.55455 | 2103302.41792 | 37.7557261650385 | -122.414900084483 | (37.7557261650385, -122.414900084483) | |||
| 51013 | 51013 | 224707 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3128 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6008124.010419999 | 2102718.1378200003 | 37.7541223959334 | -122.414826033413 | (37.7541223959334, -122.414826033413) | |||
| 135158 | 135158 | 224706 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3200 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007512.60917 | 2102684.32552 | 37.753995182337 | -122.416938018377 | (37.753995182337, -122.416938018377) | |||
| 74987 | 74987 | 224705 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2783 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007157.84145 | 2102080.74215 | 37.7523179179397 | -122.418122104462 | (37.7523179179397, -122.418122104462) | |||
| 52943 | 52943 | 224704 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3282 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6007185.4124300005 | 2102081.52674 | 37.7523216240474 | -122.418026814981 | (37.7523216240474, -122.418026814981) | |||
| 2012 | 2012 | 224703 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3236 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 3ft | 6007440.93162 | 2102096.08231 | 37.7523759682811 | -122.417144217627 | (37.7523759682811, -122.417144217627) | |||
| 1970 | 1970 | 224702 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3236 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 6007468.557569999 | 2102099.5649099997 | 37.752387084812604 | -122.417048929078 | (37.7523870848126, -122.417048929078) | |||
| 2011 | 2011 | 224701 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 3ft | 6007503.74003 | 2102097.0446900004 | 37.7523821439458 | -122.416927083514 | (37.7523821439458, -122.416927083514) | |||
| 1962 | 1962 | 224700 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 3ft | 6007513.40637 | 2102105.84325 | 37.7524068465217 | -122.416894278962 | (37.7524068465217, -122.416894278962) | |||
| 1961 | 1961 | 224699 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 3ft | 6007526.74961 | 2102095.6735900003 | 37.7523796734842 | -122.416847415286 | (37.7523796734842, -122.416847415286) | |||
| 176263 | 176263 | 224698 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3196 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007749.279159999 | 2102109.5588 | 37.7524303134304 | -122.416078852874 | (37.7524303134304, -122.416078852874) | |||
| 188891 | 188891 | 224697 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3186 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007787.21683 | 2102109.23167 | 37.752431548191296 | -122.415947634593 | (37.7524315481913, -122.415947634593) | |||
| 32232 | 32232 | 224696 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3164 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6007892.65304 | 2102118.31873 | 37.752462426418205 | -122.415583660969 | (37.7524624264182, -122.415583660969) | |||
| 150672 | 150672 | 224695 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3028 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6008772.76102 | 2102170.4878700003 | 37.7526551034509 | -122.412543777077 | (37.7526551034509, -122.412543777077) | |||
| 150164 | 150164 | 224694 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3022 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6008827.838280001 | 2102168.91217 | 37.752653867804206 | -122.41235319816201 | (37.7526538678042, -122.412353198162) | |||
| 66761 | 66761 | 224693 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 281 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006755.71735 | 2102172.37571 | 37.7525468808523 | -122.41951921745 | (37.7525468808523, -122.41951921745) | |||
| 148374 | 148374 | 224692 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3514 25th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006331.52942 | 2101449.49488 | 37.7505381137462 | -122.42093481508199 | (37.7505381137462, -122.420934815082) | |||
| 56925 | 56925 | 224691 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3514 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006345.67902 | 2101450.87841 | 37.750542710175296 | -122.420885982798 | (37.7505427101753, -122.420885982798) | |||
| 46980 | 46980 | 224690 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3514 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006361.82473 | 2101451.2167700003 | 37.750544549297 | -122.420830173598 | (37.750544549297, -122.420830173598) | |||
| 65026 | 65026 | 224689 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3514 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006377.96332 | 2101451.22022 | 37.7505454684046 | -122.420774365244 | (37.7505454684046, -122.420774365244) | |||
| 52089 | 52089 | 224688 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3514 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006392.77142 | 2101451.9207900004 | 37.7505482266294 | -122.420723207318 | (37.7505482266294, -122.420723207318) | |||
| 135738 | 135738 | 224687 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3513 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006398.661830001 | 2101411.28771 | 37.7504369894718 | -122.420699953558 | (37.7504369894718, -122.420699953558) | |||
| 147109 | 147109 | 224686 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3513 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006380.82201 | 2101410.31464 | 37.750433312158606 | -122.42076157599199 | (37.7504333121586, -122.420761575992) | |||
| 33898 | 33898 | 224685 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3513 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006366.00015 | 2101408.94489 | 37.7504287157262 | -122.420812733918 | (37.7504287157262, -122.420812733918) | |||
| 148216 | 148216 | 224684 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3513 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006347.14535 | 2101407.6579400003 | 37.7504241193009 | -122.420877843938 | (37.7504241193009, -122.420877843938) | |||
| 58083 | 58083 | 224683 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1380 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006412.3793 | 2101568.5660099997 | 37.750869612842294 | -122.420663681196 | (37.7508696128423, -122.420663681196) | |||
| 46174 | 46174 | 224682 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1390 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6006417.42588 | 2101484.35178 | 37.750638664248704 | -122.42064025206899 | (37.7506386642487, -122.420640252069) | |||
| 71668 | 71668 | 224681 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1390 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6006415.878380001 | 2101496.97772 | 37.7506732449771 | -122.42064649965499 | (37.7506732449771, -122.420646499655) | |||
| 40276 | 40276 | 224680 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1390 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6006416.173690001 | 2101511.36496 | 37.7507127656919 | -122.420646499657 | (37.7507127656919, -122.420646499657) | |||
| 164944 | 164944 | 224679 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 904 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007366.7394199995 | 2101988.35955 | 37.752076011999605 | -122.417393153575 | (37.7520760119996, -122.417393153575) | |||
| 160939 | 160939 | 224678 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 904 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6007360.84858 | 2102028.60298 | 37.752186179864104 | -122.41741637677201 | (37.7521861798641, -122.417416376772) | |||
| 153329 | 153329 | 224677 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 254 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007152.66781 | 2105827.76249 | 37.762606081230395 | -122.418405656216 | (37.7626060812304, -122.418405656216) | |||
| 136908 | 136908 | 224676 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 123 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007744.73276 | 2107219.6910599996 | 37.766461304874 | -122.416456511479 | (37.766461304874, -122.416456511479) | |||
| 167883 | 167883 | 224675 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 121 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007745.9196 | 2107233.93005 | 37.7665004685576 | -122.41645341510001 | (37.7665004685576, -122.4164534151) | |||
| 158257 | 158257 | 224674 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 600 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007862.99313 | 2104382.32986 | 37.7586772175088 | -122.41584653279301 | (37.7586772175088, -122.415846532793) | |||
| 117670 | 117670 | 224673 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 610 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007868.35883 | 2104304.97763 | 37.7584651276847 | -122.415822498411 | (37.7584651276847, -122.415822498411) | |||
| 44954 | 44954 | 224672 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800 Florida St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009346.5218400005 | 2104406.68388 | 37.758827378187796 | -122.410717513006 | (37.7588273781878, -122.410717513006) | |||
| 162159 | 162159 | 224671 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800 Florida St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009345.91132 | 2104426.34813 | 37.758881337533005 | -122.410721013192 | (37.758881337533, -122.410721013192) | |||
| 134334 | 134334 | 224670 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009345.18768 | 2104440.47189 | 37.758920077605 | -122.41072451332701 | (37.758920077605, -122.410724513327) |
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");