Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, 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) | |
| 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) | |||
| 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) | |||
| 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 | ||||||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 38567 | 38567 | 176431 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 146 Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008376.30406 | 2087394.4749 | 37.7120611046958 | -122.41287021121401 | (37.7120611046958, -122.412870211214) | |||
| 39271 | 39271 | 126617 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3001 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 5999428.93901 | 2119163.44026 | 37.798784587708504 | -122.446078403512 | (37.7987845877085, -122.446078403512) | |||
| 39277 | 39277 | 176408 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 55 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998608.92575 | 2087907.1259400002 | 37.7129156324143 | -122.44666581189101 | (37.7129156324143, -122.446665811891) | |||
| 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) | |||
| 41062 | 41062 | 55568 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1132 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | 13 | 3x2 | Permit Number 11537 | 6011293.45596 | 2089493.71978 | 37.7179885201224 | -122.40293519190901 | (37.7179885201224, -122.402935191909) | |
| 41113 | 41113 | 224656 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 712 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007860.71313 | 2097707.8013299997 | 37.740350336402294 | -122.415381905247 | (37.7403503364023, -122.415381905247) | |||
| 42340 | 42340 | 224585 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008501.81805 | 2106792.30192 | 37.765330339934295 | -122.413807647409 | (37.7653303399343, -122.413807647409) | |||
| 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) | |||
| 42892 | 42892 | 218825 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 295 Bright St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5993731.49381 | 2089150.28883 | 37.716049240944706 | -122.463613852416 | (37.7160492409447, -122.463613852416) | |||
| 43618 | 43618 | 218812 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 317 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995879.6181 | 2088168.92922 | 37.713478198842296 | -122.456118052617 | (37.7134781988423, -122.456118052617) | |||
| 43665 | 43665 | 224592 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3117 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005984.09151 | 2106650.9865599996 | 37.7648006077779 | -122.422505844393 | (37.7648006077779, -122.422505844393) | |||
| 43831 | 43831 | 224555 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3361 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007814.31661 | 2104415.71368 | 37.7587661451722 | -122.416017243027 | (37.7587661451722, -122.416017243027) | |||
| 44309 | 44309 | 41283 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3948 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2000 12:00:00 AM | 0 | Permit Number 41961 | 5981803.95386186 | 2102184.90266006 | 37.751144251784204 | -122.505806132064 | (37.7511442517842, -122.505806132064) | ||
| 44349 | 44349 | 124423 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5996107.9721800005 | 2115471.34233 | 37.78845688642 | -122.45730271274401 | (37.78845688642, -122.457302712744) | |||
| 44782 | 44782 | 224499 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 35 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6007169.2602 | 2099278.27912 | 37.744623630583 | -122.41788397836599 | (37.744623630583, -122.417883978366) | |||
| 44876 | 44876 | 224512 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 915 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009423.35212 | 2103670.74387 | 37.756810960566 | -122.41039983289 | (37.756810960566, -122.41039983289) | |||
| 45410 | 45410 | 218818 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 230 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5996994.979669999 | 2089536.5843200001 | 37.7172974217136 | -122.452361618599 | (37.7172974217136, -122.452361618599) | |||
| 45557 | 45557 | 218824 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 104 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5992465.47636 | 2088577.7234599998 | 37.7144040850433 | -122.46794814758499 | (37.7144040850433, -122.467948147585) | |||
| 45864 | 45864 | 176424 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 538 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009812.17284 | 2092615.8358900002 | 37.7264783747515 | -122.40827544896601 | (37.7264783747515, -122.408275448966) | |||
| 46175 | 46175 | 176428 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 250 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009763.04467 | 2087916.9312200001 | 37.7135734055712 | -122.40811403774599 | (37.7135734055712, -122.408114037746) | |||
| 46392 | 46392 | 224600 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3318 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6006204.33769 | 2103782.43262 | 37.7569366525255 | -122.421540324144 | (37.7569366525255, -122.421540324144) | |||
| 47489 | 47489 | 224527 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 171 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6006719.85919 | 2102790.50948 | 37.7542421146046 | -122.419687075893 | (37.7542421146046, -122.419687075893) | |||
| 48272 | 48272 | 224596 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3395 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005741.73742 | 2103713.82749 | 37.7567221840006 | -122.423135295184 | (37.7567221840006, -122.423135295184) | |||
| 48289 | 48289 | 60093 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3340 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1982 12:00:00 AM | 15 | Permit Number 19594 | 5998249.449130001 | 2116202.11644 | 37.7905861601801 | -122.44994626172199 | (37.7905861601801, -122.449946261722) | |
| 49595 | 49595 | 33663 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 424 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37751 | 6005309.878255201 | 2111164.52643651 | 37.7771556428857 | -122.425158961888 | (37.7771556428857, -122.425158961888) | |||
| 50097 | 50097 | 62304 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2504 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | Permit Number 22442 | 5997225.79467532 | 2110840.29768365 | 37.7758053966105 | -122.45310080621901 | (37.7758053966105, -122.453100806219) | ||
| 50369 | 50369 | 224654 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 38 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007453.75758 | 2099095.22372 | 37.7441370083106 | -122.416887273228 | (37.7441370083106, -122.416887273228) | |||
| 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) | |||
| 51721 | 51721 | 176410 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 60 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000924.6013400005 | 2091091.4970599997 | 37.7217912071684 | -122.438890154751 | (37.7217912071684, -122.438890154751) | |||
| 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) | |||
| 52254 | 52254 | 65586 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1779 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1990 12:00:00 AM | 10 | Permit Number 28486 | 6014089.25997 | 2096159.17746 | 37.7364462435881 | -122.39373752768499 | (37.7364462435881, -122.393737527685) | ||
| 52756 | 52756 | 218802 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2370 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992350.84884 | 2099324.20257 | 37.7439046297971 | -122.46912600049 | (37.7439046297971, -122.46912600049) | |||
| 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) | |||
| 53251 | 53251 | 94021 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 67 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2010 12:00:00 AM | 3x3 | Permit Number 53440 | 6007432.0 | 2099002.0 | 37.7438798129267 | -122.416955902584 | (37.7438798129267, -122.416955902584) | ||
| 53537 | 53537 | 224668 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6009343.82267 | 2104472.74899 | 37.7590086266741 | -122.410731513656 | (37.7590086266741, -122.410731513656) | |||
| 53602 | 53602 | 64963 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1701 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | Permit Number 25998 | 6004752.02742796 | 2119466.94279483 | 37.7999204646826 | -122.42768042225599 | (37.7999204646826, -122.427680422256) | ||
| 54632 | 54632 | 61750 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3235 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1984 12:00:00 AM | Permit Number 21761 | 6005283.427251 | 2106614.91851966 | 37.7646620214784 | -122.424926696656 | (37.7646620214784, -122.424926696656) |
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");