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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 543 | 543 | 224593 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3131 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1981 12:00:00 AM | 13 | Width 3ft | Permit Number 18870 | 6005970.19181 | 2106649.76485 | 37.7647964691065 | -122.42255383310801 | (37.7647964691065, -122.422553833108) | |
| 547 | 547 | 224594 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3133 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1981 12:00:00 AM | 14 | Width 3ft | Permit Number 18871 | 6005947.45622 | 2106648.2222599997 | 37.7647909508601 | -122.42263236011001 | (37.7647909508601, -122.42263236011) | |
| 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) | ||||
| 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) | ||||
| 1508 | 1508 | 224531 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3077 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008520.36157 | 2102113.23947 | 37.752483743936 | -122.413412573453 | (37.752483743936, -122.413412573453) | |||
| 1622 | 1622 | 15770 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4770 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001421.7162 | 2091049.3752 | 37.721703820816394 | -122.43716874658399 | (37.7217038208164, -122.437168746584) | ||
| 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) | ||||
| 2123 | 2123 | 128055 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 449 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780354 | 6008758.87824 | 2121765.85838 | 37.8064585449799 | -122.413977880988 | (37.8064585449799, -122.413977880988) | |
| 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) | |||
| 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) | |||
| 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 | ||||||||
| 5741 | 5741 | 64939 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1904 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/1989 12:00:00 AM | 14 | 4x9 | Permit Number 25968 | 6003770.598230001 | 2119034.75591 | 37.798678227572 | -122.431045672521 | (37.798678227572, -122.431045672521) | |
| 9698 | 9698 | 173643 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 657 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012793.0 | 2114089.0 | 37.78560546361629 | -122.39947767317301 | (37.7856054636163, -122.399477673173) | ||||
| 9737 | 9737 | 173681 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 125 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010317.0 | 2099454.0 | 37.7452827689443 | -122.40701204748301 | (37.7452827689443, -122.407012047483) | ||||
| 9802 | 9802 | 173694 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 201X Stevenson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011772.0 | 2114653.0 | 37.7870971135768 | -122.40304974212799 | (37.7870971135768, -122.403049742128) | ||||
| 9838 | 9838 | 68204 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1110 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 16 | 3x3 | Permit Number 32363 | 6009978.53990017 | 2102725.22931804 | 37.754245896491604 | -122.408413088762 | (37.7542458964916, -122.408413088762) |
| 9891 | 9891 | 173730 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 387 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999535.0 | 2094919.0 | 37.7322214835803 | -122.443968498715 | (37.7322214835803, -122.443968498715) | ||||
| 11311 | 11311 | 25396 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 945 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6000465.251630001 | 2089064.76788 | 37.7162001220051 | -122.440332727576 | (37.7162001220051, -122.440332727576) | |||
| 11475 | 11475 | 13369 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 900 Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X50 | 6009189.31279 | 2090017.3428599997 | 37.71930856033371 | -122.410245275395 | (37.7193085603337, -122.410245275395) | |||
| 12464 | 12464 | 111889 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 142 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6011076.19973 | 2092521.5640200002 | 37.72629022399121 | -122.40389910598302 | (37.7262902239912, -122.403899105983) | |||
| 13913 | 13913 | 26001 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6014400.39468 | 2095925.2599900002 | 37.735821239067796 | -122.392645436853 | (37.7358212390678, -122.392645436853) | |||
| 14200 | 14200 | 26002 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6014429.78226 | 2095903.68978 | 37.7357636437757 | -122.392542323281 | (37.7357636437757, -122.392542323281) | |||
| 16498 | 16498 | 26003 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6014451.27252 | 2095887.995 | 37.7357217425631 | -122.39246692501999 | (37.7357217425631, -122.39246692502) | |||
| 17117 | 17117 | 625 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3160 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x6 | 6007920.1411 | 2102115.05717 | 37.7524550160009 | -122.415488371495 | (37.7524550160009, -122.415488371495) | |||
| 17610 | 17610 | 24602 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 419 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007254.49022 | 2097303.30919 | 37.7392055992492 | -122.41744932972401 | (37.7392055992492, -122.417449329724) | |||
| 17807 | 17807 | 640 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3214 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6007574.72227 | 2102100.08892 | 37.7523944952223 | -122.41668183031601 | (37.7523944952223, -122.416681830316) | |||
| 17817 | 17817 | 643 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3224 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6007548.56119 | 2102101.97423 | 37.752398200442 | -122.41677243341199 | (37.752398200442, -122.416772433412) | |||
| 17857 | 17857 | 66830 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 393 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1991 12:00:00 AM | Permit Number 30127 | 6001175.80343985 | 2104102.01378806 | 37.7575293253254 | -122.43895374638201 | (37.7575293253254, -122.438953746382) | ||
| 17973 | 17973 | 61740 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 219 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21745 | 6003738.99947337 | 2100964.64707663 | 37.7490603587459 | -122.42986540291099 | (37.7490603587459, -122.429865402911) | ||
| 17978 | 17978 | 59647 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 100 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1987 12:00:00 AM | 6x9 | Permit Number 24228 | 6003848.70238053 | 2108788.55742661 | 37.770549162658895 | -122.43004409806002 | (37.7705491626589, -122.43004409806) | |
| 18006 | 18006 | 26514 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2880 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008952.92902 | 2101706.37447 | 37.7513908617048 | -122.411887928494 | (37.7513908617048, -122.411887928494) | |||
| 18232 | 18232 | 630 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3176 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6007837.40103 | 2102111.35303 | 37.752440194268395 | -122.41577423901501 | (37.7524401942684, -122.415774239015) | |||
| 18462 | 18462 | 623 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3158 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6007941.8237 | 2102115.0630200002 | 37.7524562507759 | -122.415413389641 | (37.7524562507759, -122.415413389641) | |||
| 18629 | 18629 | 23094 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1384 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/1992 12:00:00 AM | 3 | 3x3 | 6006412.34173 | 2101544.72785 | 37.750804156590206 | -122.42066211905701 | (37.7508041565902, -122.420662119057) | ||
| 18661 | 18661 | 598 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3070 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3x3 | 6008489.074019999 | 2102147.94889 | 37.75257729142999 | -122.41352322603399 | (37.75257729143, -122.413523226034) | |||
| 19276 | 19276 | 108963 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 19320 | 19320 | 5332 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 125 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 6x7 | 6004849.91389 | 2107615.9681599997 | 37.7673861676625 | -122.42649738994601 | (37.7673861676625, -122.426497389946) | |||
| 19453 | 19453 | 1923 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 78 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6001189.660619999 | 2097346.8097900003 | 37.7389819342562 | -122.43842185440901 | (37.7389819342562, -122.438421854409) | |||
| 19840 | 19840 | 60045 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 235 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1986 12:00:00 AM | Permit Number 22998 | 6003601.05151902 | 2109138.05302848 | 37.7714947633279 | -122.43092567098101 | (37.7714947633279, -122.430925670981) | ||
| 19961 | 19961 | 600 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3078 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6008460.582 | 2102146.28241 | 37.7525711157729 | -122.41362163882401 | (37.7525711157729, -122.413621638824) | |||
| 20031 | 20031 | 5670 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1416 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6005182.49595 | 2100071.1312 | 37.7466886088884 | -122.424810216828 | (37.7466886088884, -122.424810216828) | |||
| 20129 | 20129 | 642 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3225 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6007512.22413 | 2102054.36572 | 37.7522654344184 | -122.416894720512 | (37.7522654344184, -122.416894720512) | |||
| 20158 | 20158 | 605 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3098 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6008383.72095 | 2102142.9064 | 37.752557529712895 | -122.41388719964701 | (37.7525575297129, -122.413887199647) | |||
| 20356 | 20356 | 620 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3145 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008061.58213 | 2102085.15012 | 37.752380847108604 | -122.41499712672 | (37.7523808471086, -122.41499712672) | |||
| 20372 | 20372 | 65541 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2146 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1990 12:00:00 AM | Permit Number 28438 | 6002328.18536025 | 2114391.9672646 | 37.78584848917 | -122.43570452929701 | (37.78584848917, -122.435704529297) | ||
| 20645 | 20645 | 5358 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 230 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004797.6722800005 | 2107012.30465 | 37.765725699015604 | -122.426635095043 | (37.7657256990156, -122.426635095043) | |||
| 20649 | 20649 | 33653 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 284 Linden St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | |||
| 20672 | 20672 | 26517 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2883 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6009010.68122 | 2101716.60139 | 37.7514221824079 | -122.411688936397 | (37.7514221824079, -122.411688936397) | |||
| 20707 | 20707 | 24450 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1384 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006415.18821 | 2101529.37673 | 37.7507621663522 | -122.42065118602301 | (37.7507621663522, -122.420651186023) | |||
| 20778 | 20778 | 22835 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 104 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1994 12:00:00 AM | 20 | 2X2 | 5999575.13645 | 2098938.39255 | 37.743260073094504 | -122.44411845071899 | (37.7432600730945, -122.444118450719) | ||
| 20895 | 20895 | 641 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3208 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6007604.52296 | 2102099.47851 | 37.7523944952114 | -122.41657873113 | (37.7523944952114, -122.41657873113) | |||
| 20951 | 20951 | 592 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3056 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008558.8392900005 | 2102157.7680200003 | 37.752608169649 | -122.41328265918699 | (37.752608169649, -122.413282659187) | |||
| 21452 | 21452 | 569 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2970 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6009068.4734 | 2102184.68731 | 37.7527106833549 | -122.411522150837 | (37.7527106833549, -122.411522150837) | |||
| 21513 | 21513 | 604 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3090 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6008414.92242 | 2102144.51738 | 37.752563705358604 | -122.413779413197 | (37.7525637053586, -122.413779413197) | |||
| 22195 | 22195 | 1351 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 271 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999796.36324 | 2099302.3291700003 | 37.7442719740833 | -122.443379644158 | (37.7442719740833, -122.443379644158) | |||
| 23566 | 23566 | 59480 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3326 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1980 12:00:00 AM | 13 | Permit Number 18850 | 5998315.87391 | 2116208.53382 | 37.7906075811119 | -122.449716899529 | (37.7906075811119, -122.449716899529) | ||
| 24881 | 24881 | 224536 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3283 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007118.3907 | 2102031.54495 | 37.7521806130667 | -122.418255044036 | (37.7521806130667, -122.418255044036) | |||
| 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) | |||
| 25064 | 25064 | 176406 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 75 Dichiera Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 2ft | 5998546.73235 | 2087959.10708 | 37.71305480791771 | -122.446884509935 | (37.7130548079177, -122.446884509935) | |||
| 25222 | 25222 | 224646 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 9 Heyman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006447.484730001 | 2098360.83948 | 37.7420639010279 | -122.420314636308 | (37.7420639010279, -122.420314636308) | |||
| 25306 | 25306 | 224560 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3103 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008678.9898 | 2105047.11608 | 37.7605484090025 | -122.41307143989799 | (37.7605484090025, -122.413071439898) | |||
| 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) | |||
| 25653 | 25653 | 224561 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3105 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008657.355280001 | 2105044.9077 | 37.7605411307748 | -122.413146107923 | (37.7605411307748, -122.413146107923) | |||
| 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) | |||
| 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) | |||
| 26601 | 26601 | 224669 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009345.52709 | 2104457.09364 | 37.758965736194504 | -122.410724513338 | (37.7589657361945, -122.410724513338) | |||
| 26758 | 26758 | 224495 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 142 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005480.01407 | 2096145.7478200002 | 37.7359271935727 | -122.42350240381501 | (37.7359271935727, -122.423502403815) | |||
| 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) | |||
| 27084 | 27084 | 224623 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1323 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5999023.60773 | 2105026.39376 | 37.759944756159996 | -122.44646337809601 | (37.75994475616, -122.446463378096) | |||
| 27122 | 27122 | 224482 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 36 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005327.69113 | 2105769.4037900004 | 37.7623429387058 | -122.424713446172 | (37.7623429387058, -122.424713446172) | |||
| 27704 | 27704 | 224485 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1528 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6007214.093119999 | 2107363.71404 | 37.7668269026679 | -122.418302114548 | (37.7668269026679, -122.418302114548) | |||
| 27818 | 27818 | 224481 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 77 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005108.87913 | 2105720.69975 | 37.762196848333396 | -122.42546676957599 | (37.7621968483334, -122.425466769576) | |||
| 29663 | 29663 | 224614 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 525 Burnett Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5999496.34966 | 2102468.38313 | 37.7529480782956 | -122.444644538818 | (37.7529480782956, -122.444644538818) | |||
| 29802 | 29802 | 224567 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3235 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007896.19994 | 2105583.80933 | 37.7619780702545 | -122.41581676433701 | (37.7619780702545, -122.415816764337) | |||
| 30530 | 30530 | 101433 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
| 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) | |||
| 31192 | 31192 | 224609 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3556 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005809.7038900005 | 2102588.37341 | 37.753635783583796 | -122.422820259951 | (37.7536357835838, -122.422820259951) | |||
| 31299 | 31299 | 176423 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 538 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009799.11271 | 2092612.1001799998 | 37.726467385945 | -122.408320334118 | (37.726467385945, -122.408320334118) | |||
| 31380 | 31380 | 224632 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 667 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007654.90569 | 2096244.9671 | 37.736322146140104 | -122.41598994138599 | (37.7363221461401, -122.415989941386) | |||
| 31967 | 31967 | 224626 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 601 Buena Vista Ave West | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5999843.00884 | 2107568.58853 | 37.7669717582745 | -122.443812120926 | (37.7669717582745, -122.443812120926) | |||
| 32026 | 32026 | 224492 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 60 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5998346.422619999 | 2106894.64873 | 37.7650358128629 | -122.448940002185 | (37.7650358128629, -122.448940002185) | |||
| 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) | |||
| 32870 | 32870 | 224543 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3257 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6006596.438630001 | 2103760.0556900003 | 37.7568973116766 | -122.420182701267 | (37.7568973116766, -122.420182701267) | |||
| 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) | |||
| 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) | |||
| 33348 | 33348 | 224580 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6008616.559830001 | 2106802.76672 | 37.765365516923396 | -122.413411521233 | (37.7653655169234, -122.413411521233) | |||
| 33417 | 33417 | 224524 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 145 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006710.95301 | 2102956.09091 | 37.754696261449 | -122.419729623734 | (37.754696261449, -122.419729623734) | |||
| 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) | |||
| 33917 | 33917 | 224641 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 14 Powers Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006763.87284 | 2099814.11824 | 37.7460721011655 | -122.41932373541901 | (37.7460721011655, -122.419323735419) | |||
| 34568 | 34568 | 224517 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 439 Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007852.876569999 | 2105322.21505 | 37.76125735715679 | -122.41594807794701 | (37.7612573571568, -122.415948077947) | |||
| 34585 | 34585 | 224513 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1115 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008070.04378 | 2101397.41005 | 37.7504929435022 | -122.41491919326 | (37.7504929435022, -122.41491919326) | |||
| 35607 | 35607 | 224556 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3361 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007831.17362 | 2104415.66296 | 37.7587669536521 | -122.415958939967 | (37.7587669536521, -122.415958939967) | |||
| 35969 | 35969 | 224619 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1324 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5999058.149540001 | 2104997.17372 | 37.75986649804889 | -122.446341813123 | (37.7598664980489, -122.446341813123) | |||
| 36252 | 36252 | 224597 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3379 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005839.7237599995 | 2103719.1603099997 | 37.7567423557945 | -122.422796801149 | (37.7567423557945, -122.422796801149) | |||
| 36458 | 36458 | 224550 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3381 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007700.023440001 | 2104409.2187799998 | 37.7587418850474 | -122.41641206247499 | (37.7587418850474, -122.416412062475) | |||
| 36658 | 36658 | 224538 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2925 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008618.6240300005 | 2103873.92813 | 37.7573237135349 | -122.413197256868 | (37.7573237135349, -122.413197256868) | |||
| 37859 | 37859 | 224591 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3117 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006001.0018 | 2106651.39278 | 37.7648026771212 | -122.42244738485701 | (37.7648026771212, -122.422447384857) | |||
| 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) | |||
| 38032 | 38032 | 224519 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 439 Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007848.492430001 | 2105359.1644 | 37.7613585650588 | -122.415965857533 | (37.7613585650588, -122.415965857533) | |||
| 38462 | 38462 | 176412 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6000489.461069999 | 2089401.4731400001 | 37.71712601723571 | -122.440273180786 | (37.7171260172357, -122.440273180786) |
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");