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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 83369 | 83369 | 66220 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1 Dolores Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1990 12:00:00 AM | Permit Number 29312 | 6005304.82019082 | 2105877.54249684 | 37.7626385702507 | -122.424800241819 | (37.7626385702507, -122.424800241819) | ||
| 157834 | 157834 | 57946 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 10 Byron Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 9 | Permit Number 16905 | 5999382.31979 | 2086721.86457 | 37.7097053198058 | -122.44390761184401 | (37.7097053198058, -122.443907611844) | ||
| 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) | |
| 89586 | 89586 | 56750 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 100 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/1985 12:00:00 AM | Permit Number 21307 | 6002862.2859563 | 2108898.25983772 | 37.770794463527395 | -122.433463958699 | (37.7707944635274, -122.433463958699) | ||
| 92726 | 92726 | 97722 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 111527 | 111527 | 115025 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 122320 | 122320 | 121141 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 100x Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 9x6 | 6010389.0 | 2099533.0 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | |||
| 164602 | 164602 | 218842 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 101 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997801.418330001 | 2096410.61107 | 37.73621804871821 | -122.450069323134 | (37.7362180487182, -122.450069323134) | |||
| 81299 | 81299 | 62352 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 102 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22496 | 6005217.58297735 | 2099637.57957653 | 37.745500157100295 | -122.424658053081 | (37.7455001571003, -122.424658053081) | ||
| 81288 | 81288 | 30534 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
| 144452 | 144452 | 33820 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1025 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1984 12:00:00 AM | Permit Number 37834 | 6007679.68250964 | 2115084.43114941 | 37.7880523419006 | -122.417238879212 | (37.7880523419006, -122.417238879212) | |||
| 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) | ||
| 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) | |||
| 124078 | 124078 | 66488 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1043 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | Permit Number 29647 | 6007587.84875499 | 2109703.11754078 | 37.7732713850209 | -122.417175139527 | (37.7732713850209, -122.417175139527) | ||
| 159391 | 159391 | 224628 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1053 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5997656.24362 | 2106853.17472 | 37.7648824406996 | -122.45132415711001 | (37.7648824406996, -122.45132415711) | |||
| 101030 | 101030 | 61727 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 106 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21732 | 6004453.38447501 | 2101057.16682643 | 37.7493548261549 | -122.42740164255501 | (37.7493548261549, -122.427401642555) | ||
| 64255 | 64255 | 224659 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6009169.148580001 | 2102873.09479 | 37.754606542358296 | -122.41122262175 | (37.7546065423583, -122.41122262175) | |||
| 90199 | 90199 | 65243 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28037 | 6009165.76758609 | 2102839.33295033 | 37.754513650320504 | -122.411231929366 | (37.7545136503205, -122.411231929366) | ||
| 179557 | 179557 | 176434 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 109 Chester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991752.24555 | 2088448.0917 | 37.714006934552 | -122.47040389841999 | (37.714006934552, -122.47040389842) | |||
| 170568 | 170568 | 224647 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 11 Heyman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6006471.9777 | 2098350.49655 | 37.74203688180479 | -122.420229213316 | (37.7420368818048, -122.420229213316) | |||
| 90546 | 90546 | 64702 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 110 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1988 12:00:00 AM | Permit Number 25683 | 6010200.02442425 | 2113768.63085544 | 37.7845809377612 | -122.40842605163701 | (37.7845809377612, -122.408426051637) | ||
| 111917 | 111917 | 64693 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 110 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/1988 12:00:00 AM | Permit Number 25636 | 6005573.37725141 | 2104043.9306623 | 37.757619067817394 | -122.423741017308 | (37.7576190678174, -122.423741017308) | ||
| 181334 | 181334 | 224503 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 111 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006785.203840001 | 2096905.7488900002 | 37.7380875710875 | -122.41904372338301 | (37.7380875710875, -122.419043723383) | |||
| 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) |
| 184359 | 184359 | 111317 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1114 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6011270.9057 | 2089563.6222599999 | 37.7181791988873 | -122.403018052761 | (37.7181791988873, -122.403018052761) | |||
| 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) | |||
| 68571 | 68571 | 55566 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1120 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11535 | 6011279.280809999 | 2089546.81423 | 37.7181335151377 | -122.402987921868 | (37.7181335151377, -122.402987921868) | |
| 136673 | 136673 | 55316 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1125 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 14 | Permit Number 11245 | 6011314.6404800005 | 2089535.2445 | 37.7181037214869 | -122.40286488472601 | (37.7181037214869, -122.402864884726) | ||
| 185528 | 185528 | 55317 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1126 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 4 | Permit Number 11246 | 6011285.28669 | 2089520.6507599999 | 37.7180620109438 | -122.402965322811 | (37.7180620109438, -122.402965322811) | ||
| 101311 | 101311 | 62353 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 113 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | 18 | Permit Number 22497 | 6005157.02914158 | 2099582.1696783 | 37.7453445941022 | -122.42486349755501 | (37.7453445941022, -122.424863497555) | |
| 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) | |
| 143227 | 143227 | 63772 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1134 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24451 | 6003162.44517655 | 2101626.56141002 | 37.750845152832206 | -122.431906388672 | (37.7508451528322, -122.431906388672) | ||
| 129373 | 129373 | 109918 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 114 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | 6010269.5 | 2121152.3 | 37.80485859155171 | -122.408706764133 | (37.8048585915517, -122.408706764133) | ||||
| 18141 | 18141 | 24446 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1156 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6006345.52984 | 2102866.64807 | 37.754430080088895 | -122.420987008139 | (37.7544300800889, -122.420987008139) | |||
| 74423 | 74423 | 34453 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1167 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 10 | Permit Number 38197 | 6007453.346609999 | 2118811.2297099996 | 37.798272471441706 | -122.418286300874 | (37.7982724714417, -122.418286300874) | |
| 176566 | 176566 | 218809 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 118 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996535.53946 | 2090678.52967 | 37.720406603762 | -122.45403210661001 | (37.720406603762, -122.45403210661) | |||
| 118567 | 118567 | 65474 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1185 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1989 12:00:00 AM | Permit Number 28355 | 5995034.99249971 | 2091783.3730714 | 37.72335408532629 | -122.459298943633 | (37.7233540853263, -122.459298943633) | ||
| 54737 | 54737 | 35236 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1198 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 10 | Permit Number 38733 | 6007268.58471 | 2119527.95161 | 37.80023000775871 | -122.418976495462 | (37.8002300077587, -122.418976495462) | |
| 129648 | 129648 | 224510 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1198 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007627.9779199995 | 2102718.14058 | 37.7540945196695 | -122.416541439837 | (37.7540945196695, -122.416541439837) | |||
| 173633 | 173633 | 224486 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 12 Lundys Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 2ft | 6007182.48369 | 2099609.18315 | 37.7455329629926 | -122.417861705765 | (37.7455329629926, -122.417861705765) | |||
| 144222 | 144222 | 99114 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1200x KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011163.0 | 2119066.0 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | ||||
| 84474 | 84474 | 33816 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1201 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.791339665663294 | -122.414142270961 | (37.7913396656633, -122.414142270961) | |||
| 144927 | 144927 | 61728 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 121 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21733 | 6004369.94753879 | 2101000.29060373 | 37.7491939379116 | -122.427686117612 | (37.7491939379116, -122.427686117612) | ||
| 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) | |||
| 127954 | 127954 | 50305 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1217@ ARMY Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/2003 12:00:00 AM | Permit Number 47015 | 6001375.35048187 | 2100228.68999583 | 37.74690545910129 | -122.43798619649401 | (37.7469054591013, -122.437986196494) | ||
| 171301 | 171301 | 218823 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 122 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5992474.68721 | 2088695.0453700002 | 37.7147267546141 | -122.467924839857 | (37.7147267546141, -122.467924839857) | |||
| 92970 | 92970 | 54514 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1221 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 20683 | 5995443.00414725 | 2107246.09430383 | 37.7658343190377 | -122.459007589279 | (37.7658343190377, -122.459007589279) | ||
| 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) | |||
| 143752 | 143752 | 68371 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1233 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32193 | 5998967.61980979 | 2105592.97843293 | 37.7614972584923 | -122.44669777928699 | (37.7614972584923, -122.446697779287) | ||
| 96102 | 96102 | 55379 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1236 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1972 12:00:00 AM | Permit Number 11316 | 5993330.37884563 | 2107053.53607455 | 37.7651839347095 | -122.46630065915501 | (37.7651839347095, -122.466300659155) | |||
| 156600 | 156600 | 176432 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 125 Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008419.02136 | 2087402.0784099998 | 37.7120843800612 | -122.41272310459999 | (37.7120843800612, -122.4127231046) | |||
| 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) | |||
| 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) | ||||
| 113402 | 113402 | 61731 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1250 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21736 | 6003842.20340405 | 2100987.35465575 | 37.7491285523468 | -122.42951014206001 | (37.7491285523468, -122.42951014206) | ||
| 113862 | 113862 | 61717 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 126 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1984 12:00:00 AM | Permit Number 21717 | 6005390.65318574 | 2108294.55770451 | 37.7692799656993 | -122.42467532414801 | (37.7692799656993, -122.424675324148) | ||
| 140269 | 140269 | 64726 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 127 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1988 12:00:00 AM | Permit Number 25681 | 6010217.12887008 | 2114048.91615067 | 37.7853514923776 | -122.40838665256001 | (37.7853514923776, -122.40838665256) | ||
| 129966 | 129966 | 224658 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 127 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007231.85422 | 2100130.75523 | 37.746967860998105 | -122.41772795228998 | (37.7469678609981, -122.41772795229) | |||
| 128053 | 128053 | 62137 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 127 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/31/1985 12:00:00 AM | Permit Number 22247 | 6001408.1074829 | 2092199.32717361 | 37.7248605551976 | -122.43729808771201 | (37.7248605551976, -122.437298087712) | ||
| 118729 | 118729 | 62533 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 128 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1988 12:00:00 AM | Permit Number 25140 | 6004317.58532782 | 2101049.36983513 | 37.749325736021 | -122.427870683655 | (37.749325736021, -122.427870683655) | |||
| 70766 | 70766 | 224620 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1316 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5999063.560769999 | 2105040.06353 | 37.759984571857 | -122.446326183806 | (37.759984571857, -122.446326183806) | |||
| 71253 | 71253 | 224621 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1321 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5999027.25079 | 2105080.82131 | 37.7600944087555 | -122.44645469424499 | (37.7600944087555, -122.446454694245) | |||
| 104397 | 104397 | 65917 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1322 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28932 | 5994588.71634117 | 2106515.79856518 | 37.7637799716089 | -122.461909408356 | (37.7637799716089, -122.461909408356) | ||
| 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) | |||
| 165447 | 165447 | 224622 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1323 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5999026.564590001 | 2105047.83376 | 37.7600037939542 | -122.446454694247 | (37.7600037939542, -122.446454694247) | |||
| 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) | |||
| 94045 | 94045 | 62670 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1328 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1986 12:00:00 AM | Permit Number 23002 | 6002790.04269178 | 2111680.73625558 | 37.7784303546549 | -122.43391276835101 | (37.7784303546549, -122.433912768351) | ||
| 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) | |||
| 141827 | 141827 | 61526 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1335 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1984 12:00:00 AM | Permit Number 21483 | 5991367.33157346 | 2114748.57792616 | 37.7861989598694 | -122.47365167719 | (37.7861989598694, -122.47365167719) | ||
| 161703 | 161703 | 199429 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1340 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6013567.8476599995 | 2105719.02996 | 37.7626665705253 | -122.396210084142 | (37.7626665705253, -122.396210084142) | |||
| 94180 | 94180 | 61525 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1341 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1989 12:00:00 AM | Permit Number 28272 | 5991348.55791434 | 2114747.92419088 | 37.7861960776153 | -122.47371658077299 | (37.7861960776153, -122.473716580773) | ||
| 114015 | 114015 | 34978 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 135 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | Permit Number 38559 | 6002699.25501919 | 2105112.74476166 | 37.76039111075829 | -122.43375728104701 | (37.7603911107583, -122.433757281047) | |||
| 97456 | 97456 | 61733 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1352 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21738 | 6004486.387982 | 2101012.81721841 | 37.7492349189645 | -122.42728435687401 | (37.7492349189645, -122.427284356874) | ||
| 109018 | 109018 | 30843 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1375 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/1995 12:00:00 AM | Permit Number 34691 | 6011743.60320296 | 2101979.83639733 | 37.7522978969141 | -122.40225661865 | (37.7522978969141, -122.40225661865) | ||
| 20538 | 20538 | 10222 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1375-1377 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005868.37697 | 2101019.32612 | 37.7493308512387 | -122.422505871374 | (37.7493308512387, -122.422505871374) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 183571 | 183571 | 224487 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 14 Lundys Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 6007167.0998599995 | 2099582.88965 | 37.7454599011682 | -122.41791303725 | (37.7454599011682, -122.41791303725) | |||
| 55684 | 55684 | 224640 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 14 Powers Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006790.58194 | 2099800.70275 | 37.7460367694939 | -122.41923042716002 | (37.7460367694939, -122.41923042716) | |||
| 21156 | 21156 | 5334 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 140 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004762.96876 | 2107575.6784599996 | 37.7672706263574 | -122.426795251693 | (37.7672706263574, -122.426795251693) | |||
| 104494 | 104494 | 66311 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 140 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29426 | 6001329.17242898 | 2095394.93152934 | 37.7336304648573 | -122.43779972754601 | (37.7336304648573, -122.437799727546) | ||
| 140200 | 140200 | 63778 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 140 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24459 | 6004215.48168844 | 2101629.42267968 | 37.750912649324796 | -122.42826509514099 | (37.7509126493248, -122.428265095141) | ||
| 76431 | 76431 | 224494 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 140 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005454.36959 | 2096149.2528900001 | 37.73593537021829 | -122.423591316208 | (37.7359353702183, -122.423591316208) | |||
| 131492 | 131492 | 199432 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1400 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6014474.33722 | 2095838.0719599999 | 37.7355859449403 | -122.39238369005 | (37.7355859449403, -122.39238369005) | |||
| 180059 | 180059 | 116038 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1401x Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6008011.067530001 | 2116537.17208 | 37.792059850433795 | -122.416195270994 | (37.7920598504338, -122.416195270994) | |||
| 80543 | 80543 | 48790 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1405 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | ||
| 21797 | 21797 | 23099 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1406 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x4 | 6006424.41645 | 2101384.80463 | 37.7503657245067 | -122.420609012309 | (37.7503657245067, -122.420609012309) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 97475 | 97475 | 64063 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1421 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1988 12:00:00 AM | Permit Number 25296 | 6010151.38612308 | 2118964.80181049 | 37.7988456450066 | -122.408961074202 | (37.7988456450066, -122.408961074202) | |||
| 16957 | 16957 | 5672 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1422 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6005185.06241 | 2100046.61651 | 37.7466214421279 | -122.424799598532 | (37.7466214421279, -122.424799598532) | |||
| 108336 | 108336 | 63779 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 143 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24460 | 6004205.74848694 | 2101576.80650466 | 37.750767626848294 | -122.428295003883 | (37.7507676268483, -122.428295003883) | ||
| 138144 | 138144 | 126620 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1430 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6007903.30397 | 2116551.24821 | 37.7920924400618 | -122.41656913265801 | (37.7920924400618, -122.416569132658) | |||
| 105276 | 105276 | 63854 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1437 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24553 | 6002713.14606438 | 2111964.58520586 | 37.779205368769 | -122.434199079816 | (37.779205368769, -122.434199079816) | ||
| 172582 | 172582 | 224655 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 144 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6006439.43826 | 2097444.91016 | 37.7395485107564 | -122.42027746554 | (37.7395485107564, -122.42027746554) | |||
| 91059 | 91059 | 30886 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1440 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34718 | 6011020.35277298 | 2119822.53522602 | 37.8012494094877 | -122.40601460797501 | (37.8012494094877, -122.406014607975) | ||||
| 84615 | 84615 | 64894 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1450 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/1989 12:00:00 AM | Permit Number 25920 | 6005836.52150612 | 2100535.66309095 | 37.7480010261231 | -122.42258166386499 | (37.7480010261231, -122.422581663865) | ||
| 118326 | 118326 | 41049 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1452 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1999 12:00:00 AM | Permit Number 41829 | 6011713.00642169 | 2101589.94219711 | 37.751225624557904 | -122.40233501620199 | (37.7512256245579, -122.402335016202) | ||
| 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) |
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");