trees
969 rows where qSpecies_id = 97 sorted by Supervisor Districts descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts ▲ | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1390 | 33763 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
2261 | 101055 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 760 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008077 | 2114493 | 37.7864507606031 | -122.415822330961 | (37.7864507606031, -122.415822330961) | 13 | 1 | 9 | 28858 | 36 | |||
7669 | 101056 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 746 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008144 | 2114503 | 37.7864819845184 | -122.415591235338 | (37.7864819845184, -122.415591235338) | 13 | 1 | 9 | 28858 | 36 | |||
8245 | 259048 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1x Otis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007165 | 2109609 | 37.7729891632586 | -122.418631158564 | (37.7729891632586, -122.418631158564) | 8 | 2 | 9 | 28853 | 19 | ||||
9284 | 259046 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1x Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007165 | 2109609 | 37.7729891632586 | -122.418631158564 | (37.7729891632586, -122.418631158564) | 8 | 2 | 9 | 28853 | 19 | ||||
10424 | 259047 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1x Otis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007165 | 2109609 | 37.7729891632586 | -122.418631158564 | (37.7729891632586, -122.418631158564) | 8 | 2 | 9 | 28853 | 19 | ||||
21188 | 34146 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
25618 | 101054 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 760 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008077 | 2114493 | 37.7864507606031 | -122.415822330961 | (37.7864507606031, -122.415822330961) | 13 | 1 | 9 | 28858 | 36 | |||
27707 | 66488 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1043 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | Permit Number 29647 | 6007587.84875499 | 2109703.11754078 | 37.7732713850209 | -122.417175139527 | (37.7732713850209, -122.417175139527) | 8 | 2 | 9 | 28853 | 19 | ||
27966 | 173643 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 657 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012793 | 2114089 | 37.7856054636163 | -122.399477673173 | (37.7856054636163, -122.399477673173) | 6 | 2 | 9 | 28853 | 6 | ||||
30353 | 105684 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 1 | Front Yard : Pot | Tree | Private 2 | 10 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
31415 | 34159 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
32511 | 117226 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
33251 | 105685 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 2 | Front Yard : Pot | Tree | Private 2 | 8 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
34847 | 173694 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 201X Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011772 | 2114653 | 37.7870971135768 | -122.403049742128 | (37.7870971135768, -122.403049742128) | 12 | 2 | 9 | 28853 | 6 | ||||
36413 | 33765 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
39551 | 39879 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 301 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
40283 | 30534 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1020 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.77681277294 | -122.404779881684 | (37.77681277294, -122.404779881684) | 14 | 2 | 9 | 28853 | 34 | |||
45618 | 30532 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1020 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.77681277294 | -122.404779881684 | (37.77681277294, -122.404779881684) | 14 | 2 | 9 | 28853 | 34 | |||
46822 | 34158 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
49127 | 34147 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
49450 | 111387 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 469 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014036 | 2112699 | 37.7818580461792 | -122.395079826315 | (37.7818580461792, -122.395079826315) | 6 | 2 | 9 | 28856 | 6 | ||||
58481 | 65402 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 760 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1989 12:00:00 AM | 12 | 3x3 | Permit Number 28251 | 6008077 | 2114493 | 37.7864507606031 | -122.415822330961 | (37.7864507606031, -122.415822330961) | 13 | 1 | 9 | 28858 | 36 |
60189 | 34157 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
60674 | 30533 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1020 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.77681277294 | -122.404779881684 | (37.77681277294, -122.404779881684) | 14 | 2 | 9 | 28853 | 34 | |||
61828 | 251398 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 299 Townsend St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6013957 | 2110872 | 37.776837125863 | -122.395225113019 | (37.776837125863, -122.395225113019) | 6 | 2 | 9 | 28856 | 20 | ||||
64627 | 34152 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
67963 | 117227 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
78943 | 33764 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
83177 | 34155 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
86094 | 117224 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
87966 | 30505 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1500 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 34518 | 6007587.04685478 | 2110100.36731732 | 37.7743620934089 | -122.417206068405 | (37.7743620934089, -122.417206068405) | 8 | 2 | 9 | 28853 | 19 | |||
88021 | 115029 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
95322 | 39878 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 301 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
101268 | 101053 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 746 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008144 | 2114503 | 37.7864819845184 | -122.415591235338 | (37.7864819845184, -122.415591235338) | 13 | 1 | 9 | 28858 | 36 | |||
101840 | 34156 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
108990 | 34150 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
111103 | 64725 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 174 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25680 | 6010012.44318345 | 2114072.97215331 | 37.7854060800363 | -122.409096504402 | (37.7854060800363, -122.409096504402) | 14 | 10 | 9 | 28852 | 36 | ||
117473 | 115032 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
122705 | 115031 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
126290 | 251396 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 299 Townsend St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6013957 | 2110872 | 37.776837125863 | -122.395225113019 | (37.776837125863, -122.395225113019) | 6 | 2 | 9 | 28856 | 20 | ||||
127886 | 34148 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
129401 | 34154 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
131588 | 34153 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
132591 | 115030 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
135027 | 115025 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
140818 | 65399 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 471 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1989 12:00:00 AM | Permit Number 28247 | 6008612.45505665 | 2113822.69504434 | 37.7846403524021 | -122.41392234969 | (37.7846403524021, -122.41392234969) | 7 | 10 | 9 | 28852 | 36 | ||
143436 | 115026 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
144563 | 64727 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 166 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25682 | 6009623.89289745 | 2113671.39889681 | 37.7842816815144 | -122.410412412425 | (37.7842816815144, -122.410412412425) | 14 | 10 | 9 | 28852 | 36 | ||
145158 | 117225 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
145638 | 105686 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 3 | Front Yard : Pot | Tree | Private 2 | 6 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
149080 | 251397 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 311 Townsend St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6013957 | 2110872 | 37.776837125863 | -122.395225113019 | (37.776837125863, -122.395225113019) | 6 | 2 | 9 | 28856 | 20 | ||||
171805 | 115033 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
171989 | 34145 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
177108 | 34149 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
178512 | 115027 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
179766 | 34151 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
183193 | 65401 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 747 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1989 12:00:00 AM | Permit Number 28250 | 6008150.2130763 | 2114455.0011203 | 37.7863505404889 | -122.415566339973 | (37.7863505404889, -122.415566339973) | 13 | 1 | 9 | 28858 | 36 | ||
193914 | 115028 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
1151 | 199431 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 10ft | 6013045.46319 | 2103845.54885 | 37.7574933220764 | -122.397885411405 | (37.7574933220764, -122.397885411405) | 10 | 3 | 8 | 28856 | 29 | ||
2420 | 260860 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6013106 | 2103855 | 37.7575226440732 | -122.397676712285 | (37.7575226440732, -122.397676712285) | 10 | 3 | 8 | 28856 | 29 | ||
3099 | 104652 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 953 Indiana St | 1 | Front Yard : Cutout | Tree | Private 2 | 6015057.1 | 2104275.7 | 37.7587862506702 | -122.390958369803 | (37.7587862506702, -122.390958369803) | 10 | 3 | 8 | 28856 | 29 | |||||
5103 | 55566 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1120 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11535 | 6011279.28081 | 2089546.81423 | 37.7181335151377 | -122.402987921868 | (37.7181335151377, -122.402987921868) | 10 | 7 | 8 | 309 | 39 | |
10390 | 199430 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 10ft | 6013045.24345 | 2103834.71473 | 37.7574635617095 | -122.397885411392 | (37.7574635617095, -122.397885411392) | 10 | 3 | 8 | 28856 | 29 | ||
11332 | 55316 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1125 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11245 | 6011314.64048 | 2089535.2445 | 37.7181037214869 | -122.402864884726 | (37.7181037214869, -122.402864884726) | 10 | 7 | 8 | 309 | 39 | |
11351 | 78716 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 412 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008662.0794 | 2088043.12802 | 37.7138582091656 | -122.411928294567 | (37.7138582091656, -122.411928294567) | 9 | 7 | 8 | 309 | 39 | |||
18380 | 65586 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1779 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Permit Number 28486 | 6014089.25997 | 2096159.17746 | 37.7364462435881 | -122.393737527685 | (37.7364462435881, -122.393737527685) | 10 | 3 | 8 | 58 | 1 | ||
19928 | 176429 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 246 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009787.6259 | 2087905.19547 | 37.7135425579218 | -122.4080282487 | (37.7135425579218, -122.4080282487) | 9 | 7 | 8 | 309 | 39 | |||
23203 | 6798 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1375 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x9 | 6016915.23611 | 2097187.56543 | 37.7394266247399 | -122.384038431137 | (37.7394266247399, -122.384038431137) | 10 | 3 | 8 | 58 | 1 | |||
25718 | 176421 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 526 Lathrop Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6013003.58559 | 2086544.76512 | 37.7099866196603 | -122.396817348641 | (37.7099866196603, -122.396817348641) | 10 | 3 | 8 | 309 | 1 | |||
30016 | 199432 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1400 Newhall St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6014474.33722 | 2095838.07196 | 37.7355859449403 | -122.39238369005 | (37.7355859449403, -122.39238369005) | 10 | 3 | 8 | 58 | 1 | |||
31557 | 199435 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6014455.52547 | 2095885.24717 | 37.735714433762 | -122.392452028664 | (37.735714433762, -122.392452028664) | 10 | 3 | 8 | 58 | 1 | |||
33799 | 112160 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1328 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6013587.23518 | 2105720.84823 | 37.7626726418425 | -122.396143156607 | (37.7626726418425, -122.396143156607) | 14 | 3 | 8 | 28856 | 29 | |||
36749 | 122752 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 6011278.80569 | 2105286.3398 | 37.7613508668666 | -122.404096651066 | (37.7613508668666, -122.404096651066) | 10 | 3 | 8 | 28856 | 29 | |||
37053 | 176425 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3338 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011982.06755 | 2090001.33634 | 37.7194207606357 | -122.400590586484 | (37.7194207606357, -122.400590586484) | 10 | 7 | 8 | 309 | 28 | |||
37377 | 176427 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 383 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6010742.02473 | 2089174.64706 | 37.7170816042145 | -122.404818807562 | (37.7170816042145, -122.404818807562) | 9 | 7 | 8 | 309 | 39 | |||
39200 | 111610 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 301x Ward St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 9x3 | 6011193.26322 | 2089621.79675 | 37.7183345981422 | -122.403290521257 | (37.7183345981422, -122.403290521257) | 10 | 7 | 8 | 309 | 39 | |||
39941 | 6742 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1300X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 01:53:00 PM | 3 | 3x3 | 6016901.50063 | 2097278.26947 | 37.7396749203573 | -122.384092237585 | (37.7396749203573, -122.384092237585) | 10 | 3 | 8 | 58 | 1 | ||
46674 | 111609 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 301x Ward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 15x3 | 6011168.56615 | 2089615.14952 | 37.7183149668287 | -122.403375421742 | (37.7183149668287, -122.403375421742) | 10 | 7 | 8 | 309 | 39 | |||
59959 | 176428 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 250 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009763.04467 | 2087916.93122 | 37.7135734055712 | -122.408114037746 | (37.7135734055712, -122.408114037746) | 9 | 7 | 8 | 309 | 39 | |||
60993 | 61785 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1495 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1987 12:00:00 AM | Permit Number 24636 | 6012051.50334521 | 2101403.29784414 | 37.7507320294913 | -122.401151335946 | (37.7507320294913, -122.401151335946) | 10 | 3 | 8 | 28856 | 29 | ||
61919 | 43305 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/12/2000 12:00:00 AM | 6 | Permit Number 43072 | 6011285.67007 | 2105193.27319 | 37.7610957103087 | -122.4040663601 | (37.7610957103087, -122.4040663601) | 10 | 3 | 8 | 28856 | 29 | |
69802 | 111611 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 301x Ward St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 9x3 | 6011211.14629 | 2089627.82993 | 37.7183521627878 | -122.403229130826 | (37.7183521627878, -122.403229130826) | 10 | 7 | 8 | 309 | 39 | |||
71033 | 62088 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 474 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1985 12:00:00 AM | Permit Number 22174 | 6013214.9408475 | 2104861.98073646 | 37.7602936588903 | -122.397370564655 | (37.7602936588903, -122.397370564655) | 10 | 3 | 8 | 28856 | 29 | ||
71962 | 199434 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6014431.27107 | 2095902.06527 | 37.7357592658851 | -122.392537062245 | (37.7357592658851, -122.392537062245) | 10 | 3 | 8 | 58 | 1 | |||
74260 | 176431 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 146 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008376.30406 | 2087394.4749 | 37.7120611046958 | -122.412870211214 | (37.7120611046958, -122.412870211214) | 9 | 7 | 8 | 309 | 39 | |||
75846 | 32047 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 501 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610 | 2086139 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | 10 | 3 | 8 | 309 | 1 | ||
78944 | 55568 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1132 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1972 12:00:00 AM | 13 | 3x2 | Permit Number 11537 | 6011293.45596 | 2089493.71978 | 37.7179885201224 | -122.402935191909 | (37.7179885201224, -122.402935191909) | 10 | 7 | 8 | 309 | 39 | |
84831 | 111317 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1114 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6011270.9057 | 2089563.62226 | 37.7181791988873 | -122.403018052761 | (37.7181791988873, -122.403018052761) | 10 | 7 | 8 | 309 | 39 | |||
90644 | 61306 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1494 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1984 12:00:00 AM | Permit Number 21205 | 6011999.58311152 | 2101400.41872379 | 37.7507212274206 | -122.401330679383 | (37.7507212274206, -122.401330679383) | 10 | 3 | 8 | 28856 | 29 | ||
101216 | 199433 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1400 Newhall St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6014453.55095 | 2095806.16281 | 37.7354971746608 | -122.392453325466 | (37.7354971746608, -122.392453325466) | 10 | 3 | 8 | 58 | 1 | |||
102221 | 28251 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3340 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011988.71606 | 2089960.7357 | 37.7193096502899 | -122.400564754381 | (37.7193096502899, -122.400564754381) | 10 | 7 | 8 | 309 | 28 | |||
109268 | 200443 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2535 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6015875.48388 | 2103755.07735 | 37.7574021083324 | -122.388091663914 | (37.7574021083324, -122.388091663914) | 10 | 3 | 8 | 28856 | 29 | |||
115001 | 67594 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31161 | 6013452.45067872 | 2105638.02121278 | 37.7624377166869 | -122.39660352483 | (37.7624377166869, -122.39660352483) | 10 | 3 | 8 | 28856 | 29 | ||
118175 | 26002 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6014429.78226 | 2095903.68978 | 37.7357636437757 | -122.392542323281 | (37.7357636437757, -122.392542323281) | 10 | 3 | 8 | 58 | 1 | |||
120742 | 26003 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6014451.27252 | 2095887.995 | 37.7357217425631 | -122.39246692502 | (37.7357217425631, -122.39246692502) | 10 | 3 | 8 | 58 | 1 | |||
120892 | 176426 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3338 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011984.529 | 2089984.5422 | 37.7193747846049 | -122.400580899003 | (37.7193747846049, -122.400580899003) | 10 | 7 | 8 | 309 | 28 | |||
121851 | 61725 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 66 Williams Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1985 12:00:00 AM | Permit Number 21727 | 6013825.41276045 | 2093670.69143799 | 37.7295987054368 | -122.394475571882 | (37.7295987054368, -122.394475571882) | 10 | 3 | 8 | 58 | 1 | ||
122926 | 122750 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 6011285.1392 | 2105241.40164 | 37.7612278306072 | -122.404071583333 | (37.7612278306072, -122.404071583333) | 10 | 3 | 8 | 28856 | 29 | |||
124236 | 30843 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1375 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/1995 12:00:00 AM | Permit Number 34691 | 6011743.60320296 | 2101979.83639733 | 37.7522978969141 | -122.40225661865 | (37.7522978969141, -122.40225661865) | 10 | 3 | 8 | 28856 | 29 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );