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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 92501 | 92501 | 97725 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | |||
| 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) | ||
| 117800 | 117800 | 97724 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 128722 | 128722 | 97723 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 2 | 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) | ||
| 85453 | 85453 | 117227 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 91179 | 91179 | 117224 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 93347 | 93347 | 115029 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 106099 | 106099 | 115031 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 106354 | 106354 | 115030 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 107487 | 107487 | 115032 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 111118 | 111118 | 117225 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 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) | ||||
| 112402 | 112402 | 115026 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 127844 | 127844 | 117226 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 142948 | 142948 | 115033 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 143506 | 143506 | 115027 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 145077 | 145077 | 115028 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 103877 | 103877 | 121142 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 100x Rutledge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 9x6 | 6010389.0 | 2099533.0 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | |||
| 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) | |||
| 121528 | 121528 | 113877 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 101 HUGO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995437.0 | 2107003.0 | 37.7651664998927 | -122.45901075309999 | (37.7651664998927, -122.4590107531) | ||||
| 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) | |||
| 81461 | 81461 | 30532 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 4 | 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) | |||
| 85365 | 85365 | 30533 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 2 | 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) | |||
| 21085 | 21085 | 5576 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1040 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6005062.54747 | 2102282.8606 | 37.752754731270706 | -122.425382354736 | (37.7527547312707, -122.425382354736) | |||
| 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) | |||
| 97035 | 97035 | 47045 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 111 Maiden Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45035 | 6011125.92683466 | 2115044.13243826 | 37.7881349707775 | -122.40531257909599 | (37.7881349707775, -122.405312579096) | |||
| 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) | |||
| 46243 | 46243 | 224511 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1117 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6009227.24206 | 2102557.50534 | 37.7537432624556 | -122.410999428875 | (37.7537432624556, -122.410999428875) | |||
| 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) | |
| 96990 | 96990 | 99016 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1133 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 29980 | 6008997.0 | 2116859.0 | 37.7929988993441 | -122.41280668476999 | (37.7929988993441, -122.41280668477) | ||||
| 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) | ||||
| 17762 | 17762 | 24449 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1156 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6006348.4307699995 | 2102831.95647 | 37.7543349884778 | -122.420974512988 | (37.7543349884778, -122.420974512988) | |||
| 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) | |||
| 20042 | 20042 | 24448 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1156 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006348.61536 | 2102840.94797 | 37.7543596874688 | -122.420974512988 | (37.7543596874688, -122.420974512988) | |||
| 20215 | 20215 | 24447 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1156 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6006347.0218400005 | 2102851.3253900004 | 37.754388091646 | -122.420980760555 | (37.754388091646, -122.420980760555) | |||
| 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) | |
| 67463 | 67463 | 176433 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 118 Chester Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991720.02905 | 2088438.7014799998 | 37.7139792884876 | -122.470514566313 | (37.7139792884876, -122.470514566313) | |||
| 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) | ||
| 38769 | 38769 | 35237 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1198 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | Permit Number 38733 | 6007256.149780001 | 2119525.9627099996 | 37.8002238465228 | -122.419019384135 | (37.8002238465228, -122.419019384135) | |
| 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) | |||
| 80439 | 80439 | 99116 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1200x KEARNY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011163.0 | 2119066.0 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | ||||
| 88976 | 88976 | 99115 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1200x KEARNY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011163.0 | 2119066.0 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | ||||
| 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) | |||
| 129073 | 129073 | 33817 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1201 California St | 2 | 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) | ||
| 84518 | 84518 | 101285 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1236 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 11316 | 5993350.8 | 2107040.7 | 37.7651498684815 | -122.466229094974 | (37.7651498684815, -122.466229094974) | |||
| 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) | |||
| 85104 | 85104 | 98237 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1299X 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 32025 | 5993314.0 | 2106663.0 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | ||||
| 97387 | 97387 | 98238 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1299X 09th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 32025 | 5993314.0 | 2106663.0 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | ||||
| 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) | |||
| 185146 | 185146 | 224624 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1323 Clayton St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5999021.66534 | 2105005.43313 | 37.7598870925388 | -122.446468587874 | (37.7598870925388, -122.446468587874) | |||
| 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) |
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");