Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50552 | 50552 | 37144 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 663 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 39726 | 5990019.8111 | 2110855.0945599996 | 37.7754304051942 | -122.478028941227 | (37.7754304051942, -122.478028941227) | |||
| 50593 | 50593 | 55186 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 352 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1972 12:00:00 AM | 13 | Permit Number 11096 | 6013396.91313 | 2094278.1263700002 | 37.731242767132294 | -122.395999500683 | (37.7312427671323, -122.395999500683) | ||
| 51317 | 51317 | 31863 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 550 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | Permit Number 35305 | 5994717.97074246 | 2111781.46316747 | 37.7782455405542 | -122.461844202225 | (37.7782455405542, -122.461844202225) | |||
| 51671 | 51671 | 112792 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 23x Joice St | 3 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 5 | 6010303.89255 | 2116225.84414 | 37.7913336739481 | -122.40824006785101 | (37.7913336739481, -122.408240067851) | ||||
| 51953 | 51953 | 205753 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200x Terrace Dr | 34 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5993866.87232 | 2096473.28451 | 37.7361642036105 | -122.463677108908 | (37.7361642036105, -122.463677108908) | ||||
| 51987 | 51987 | 30475 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 424 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1956 12:00:00 AM | 8 | Permit Number 123 | 6010870.8148 | 2119673.484 | 37.8008317865696 | -122.406521568491 | (37.8008317865696, -122.406521568491) | ||
| 52135 | 52135 | 46369 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 14 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2002 12:00:00 AM | 12 | Permit Number 44606 | 5993652.77755 | 2115385.98394 | 37.788081196911 | -122.465791026812 | (37.788081196911, -122.465791026812) | ||
| 52190 | 52190 | 42235 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 479 Natoma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 3 | Permit Number 42487 | 6010547.8419 | 2112298.97398 | 37.780565078461706 | -122.407119085392 | (37.7805650784617, -122.407119085392) | |
| 52401 | 52401 | 112793 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 23x Joice St | 4 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 8 | 6010304.6147 | 2116218.08658 | 37.7913124139936 | -122.40823702184099 | (37.7913124139936, -122.408237021841) | ||||
| 52478 | 52478 | 56160 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 529 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 7 | Permit Number 12268 | 5990914.4091 | 2111783.8388900002 | 37.778032366664796 | -122.475002157716 | (37.7780323666648, -122.475002157716) | ||
| 52921 | 52921 | 66871 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 350 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30181 | 6001115.30809688 | 2104289.68730442 | 37.7580411890038 | -122.43917641405001 | (37.7580411890038, -122.43917641405) | ||
| 53271 | 53271 | 74480 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4045 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5982259.5223 | 2104870.2558 | 37.7585442772343 | -122.504429677037 | (37.7585442772343, -122.504429677037) | ||
| 53282 | 53282 | 53701 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2656 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/1970 12:00:00 AM | 12 | Permit Number 6647 | 5999210.43552 | 2117936.02801 | 37.795401961392706 | -122.44674613035102 | (37.7954019613927, -122.446746130351) | ||
| 53443 | 53443 | 42672 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42700 | 6008565.6692 | 2121051.5528 | 37.80448638863479 | -122.414595938174 | (37.8044863886348, -122.414595938174) | |
| 53842 | 53842 | 54993 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 681 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 4 | Permit Number 10871 | 5990951.138669999 | 2110770.38221 | 37.775251821012795 | -122.474801107552 | (37.7752518210128, -122.474801107552) | ||
| 53937 | 53937 | 175653 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5988966.88544 | 2089648.46014 | 37.7171414055178 | -122.480118843736 | (37.7171414055178, -122.480118843736) | ||||
| 54044 | 54044 | 78489 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3345 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 5 | 5988664.39778 | 2095197.91873 | 37.7323612287764 | -122.481570599508 | (37.7323612287764, -122.481570599508) | ||
| 54274 | 54274 | 56311 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 211 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 7 | Permit Number 12445 | 5993036.2389400005 | 2114024.56075 | 37.784307519182 | -122.467825066835 | (37.784307519182, -122.467825066835) | ||
| 54445 | 54445 | 53953 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 166 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | 7 | Permit Number 9668 | 6009649.77155 | 2095111.3186599999 | 37.7333213458895 | -122.40901286606501 | (37.7333213458895, -122.409012866065) | ||
| 54593 | 54593 | 42885 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2546 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 4 | Permit Number 42806 | 5985850.2562 | 2097897.6252 | 37.7396098709906 | -122.491498248106 | (37.7396098709906, -122.491498248106) | |
| 54738 | 54738 | 66859 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1116 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1991 12:00:00 AM | 4 | Permit Number 30166 | 5989755.3106 | 2099063.2795 | 37.7430378863443 | -122.478081600833 | (37.7430378863443, -122.478081600833) | ||
| 55646 | 55646 | 63097 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3060 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1986 12:00:00 AM | 11 | Permit Number 23584 | 6001459.2061 | 2118948.46858 | 37.798310061319 | -122.439037622007 | (37.798310061319, -122.439037622007) | ||
| 55686 | 55686 | 222169 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4462 24th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6000207.39895 | 2101702.40373 | 37.7508854337154 | -122.442130623452 | (37.7508854337154, -122.442130623452) | ||||
| 55998 | 55998 | 31018 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 21 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 6 | Permit Number 43762 | 6002296.8403 | 2087180.6482 | 37.711130859472604 | -122.433867290956 | (37.7111308594726, -122.433867290956) | |
| 56387 | 56387 | 112791 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 23x Joice St | 2 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 7 | 6010302.18584 | 2116235.66689 | 37.791360549286104 | -122.408246666156 | (37.7913605492861, -122.408246666156) | ||||
| 56400 | 56400 | 175657 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5990127.49163 | 2089397.98883 | 37.716521041479204 | -122.476088939347 | (37.7165210414792, -122.476088939347) | ||||
| 56612 | 56612 | 188254 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6013780.02718 | 2089753.4923900003 | 37.718840340875204 | -122.39435831441001 | (37.7188403408752, -122.39435831441) | ||||
| 57367 | 57367 | 175730 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 582 Sweeny St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6007932.69884 | 2094306.03264 | 37.7310138680958 | -122.41489230444799 | (37.7310138680958, -122.414892304448) | ||||
| 57450 | 57450 | 247885 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 387 Mayflower St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6009895.877069999 | 2098407.02536 | 37.7423844301873 | -122.408394391499 | (37.7423844301873, -122.408394391499) | ||||
| 57659 | 57659 | 56730 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1551 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6015631.7584 | 2095701.0969999998 | 37.7352740434099 | -122.388372450522 | (37.7352740434099, -122.388372450522) | ||||
| 58099 | 58099 | 53509 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1306 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 4 | Permit Number 12537 | 6016318.8998 | 2092822.1194 | 37.7274069963434 | -122.385796126204 | (37.7274069963434, -122.385796126204) | ||
| 58328 | 58328 | 64440 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 86 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1988 12:00:00 AM | 9 | Permit Number 25302 | 6004572.18453 | 2093022.2791099998 | 37.7272995637139 | -122.426418806283 | (37.7272995637139, -122.426418806283) | ||
| 58826 | 58826 | 38560 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1539 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40525 | 6015686.9214 | 2095659.8019 | 37.7351637119843 | -122.388178849076 | (37.7351637119843, -122.388178849076) | |
| 58838 | 58838 | 188880 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 875 Vermont St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6011314.3865 | 2104282.5433099996 | 37.758596653528706 | -122.40390295235599 | (37.7585966535287, -122.403902952356) | ||||
| 58880 | 58880 | 43337 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 451 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 8 | Permit Number 43094 | 6003321.30466 | 2090952.47585 | 37.7215455546665 | -122.430595462026 | (37.7215455546665, -122.430595462026) | |
| 58961 | 58961 | 31221 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 766 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | Permit Number 34908 | 5981084.03491617 | 2110503.52214182 | 37.773942382229706 | -122.50891323703699 | (37.7739423822297, -122.508913237037) | |||
| 59437 | 59437 | 70396 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 309 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 7 | 6005777.21829 | 2092245.9631400001 | 37.72523601532679 | -122.422197872442 | (37.7252360153268, -122.422197872442) | ||
| 59747 | 59747 | 34645 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1514 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38324 | 5987781.2369 | 2104967.961 | 37.7591357755256 | -122.48534051269199 | (37.7591357755256, -122.485340512692) | |
| 60167 | 60167 | 32490 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 26 Uranus Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 5 | Permit Number 36996 | 5999294.82707 | 2105565.3001 | 37.76143994650629 | -122.44556411809799 | (37.7614399465063, -122.445564118098) | |
| 60168 | 60168 | 93570 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 920 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6001322.49897 | 2088870.0232799998 | 37.715714168855904 | -122.437355737785 | (37.7157141688559, -122.437355737785) | ||||
| 60286 | 60286 | 188255 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013785.156280001 | 2089757.61987 | 37.718851959233 | -122.394340873848 | (37.718851959233, -122.394340873848) | ||||
| 60863 | 60863 | 56394 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1371 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12551 | 6015964.7038 | 2093008.8573 | 37.7279001350956 | -122.387033612146 | (37.7279001350956, -122.387033612146) | ||
| 60970 | 60970 | 188944 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 398 Quint St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015253.92457 | 2099115.9674299997 | 37.7446296326645 | -122.389917233688 | (37.7446296326645, -122.389917233688) | ||||
| 61475 | 61475 | 114702 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 237 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774513 | 6006534.54774 | 2092840.44849 | 37.7269110313963 | -122.41962201445 | (37.7269110313963, -122.41962201445) | ||
| 61476 | 61476 | 69162 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1201 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 6 | Permit Number 33199 | 5982705.2838 | 2106882.9636 | 37.7640968091015 | -122.503037064776 | (37.7640968091015, -122.503037064776) | |
| 61498 | 61498 | 104897 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 303 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 61700 | 61700 | 101104 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1580 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 25190 | 5989126.9 | 2103185.1 | 37.754318820325 | -122.480556110859 | (37.754318820325, -122.480556110859) | ||||
| 62048 | 62048 | 37093 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1426 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 3 | Permit Number 39693 | 5981559.2885 | 2105362.1483 | 37.7598536626334 | -122.506887844351 | (37.7598536626334, -122.506887844351) | |
| 62120 | 62120 | 78400 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 735 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 4 | 5986604.8504 | 2110908.2290000003 | 37.7753774919681 | -122.48984584488701 | (37.7753774919681, -122.489845844887) | ||
| 62783 | 62783 | 68276 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 543 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32083 | 6008845.70964 | 2093488.4538 | 37.7288202318587 | -122.411678113946 | (37.7288202318587, -122.411678113946) | |
| 63356 | 63356 | 57621 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1319 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1976 12:00:00 AM | 6 | Permit Number 16514 | 6013585.69477 | 2105673.1499900003 | 37.7625415872419 | -122.396145141378 | (37.7625415872419, -122.396145141378) | ||
| 63488 | 63488 | 33246 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2455 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 3 | Permit Number 37427 | 5987953.5529 | 2098598.711 | 37.7416575568292 | -122.484277448664 | (37.7416575568292, -122.484277448664) | |
| 64104 | 64104 | 31621 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 263 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 5 | Permit Number 45471 | 6004202.65828 | 2091873.5770299998 | 37.7241245863632 | -122.42761445225099 | (37.7241245863632, -122.427614452251) | |
| 64490 | 64490 | 67678 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1566 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 11 | Permit Number 31282 | 6014784.0524 | 2093614.4352 | 37.7294974829563 | -122.391157497644 | (37.7294974829563, -122.391157497644) | |
| 64625 | 64625 | 205790 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 Hearst Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6000031.692480001 | 2094391.3460900001 | 37.7308009895781 | -122.442213461795 | (37.7308009895781, -122.442213461795) | ||||
| 64748 | 64748 | 55091 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 526 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 9 | Permit Number 10988 | 5990960.9789 | 2111793.50527 | 37.7780616066781 | -122.47484176351999 | (37.7780616066781, -122.47484176352) | ||
| 64944 | 64944 | 218223 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 399 Claremont Blvd | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5993474.17256 | 2097846.02445 | 37.73991076848 | -122.465134496264 | (37.73991076848, -122.465134496264) | ||||
| 64991 | 64991 | 106213 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1646 35th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5985329.6566 | 2104002.0012 | 37.7563403897038 | -122.493747943766 | (37.7563403897038, -122.493747943766) | ||||
| 65431 | 65431 | 54628 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 8 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/1972 12:00:00 AM | 8 | Permit Number 10451 | 6012754.31078 | 2095657.3299099999 | 37.734994001272 | -122.39831784049801 | (37.734994001272, -122.398317840498) | ||
| 65842 | 65842 | 31005 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 5 | Permit Number 34779 | 6000594.89127 | 2088305.62905 | 37.71412307747921 | -122.439830234972 | (37.7141230774792, -122.439830234972) | |
| 65966 | 65966 | 38554 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1791 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | 6 | Permit Number 40521 | 6014548.21389 | 2096859.31136 | 37.738394160770795 | -122.392199668106 | (37.7383941607708, -122.392199668106) | |
| 65967 | 65967 | 69012 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2170 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 3 | Permit Number 33015 | 5982352.1644 | 2100332.9535 | 37.746091567164896 | -122.503773252601 | (37.7460915671649, -122.503773252601) | |
| 66172 | 66172 | 73153 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1970 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1999 12:00:00 AM | 5 | 6001494.4295 | 2115195.887 | 37.7880084528635 | -122.438646710686 | (37.7880084528635, -122.438646710686) | ||
| 66354 | 66354 | 32060 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3641 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 4 | Permit Number 35437 | 6004597.15155 | 2105983.21796 | 37.7628887345501 | -122.42725534218201 | (37.7628887345501, -122.427255342182) | |
| 66408 | 66408 | 78070 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 818 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 4 | 6011825.3920599995 | 2104537.71061 | 37.7593258220597 | -122.402153592937 | (37.7593258220597, -122.402153592937) | ||
| 66446 | 66446 | 56135 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 719 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 10 | Permit Number 12238 | 6012444.68154 | 2104578.1211900003 | 37.7594713278533 | -122.40001461297899 | (37.7594713278533, -122.400014612979) | ||
| 66552 | 66552 | 58086 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3001 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1977 12:00:00 AM | 7 | Permit Number 17057 | 6002870.87342 | 2118942.9328799997 | 37.7983750823084 | -122.434152436312 | (37.7983750823084, -122.434152436312) | ||
| 66674 | 66674 | 33678 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 447 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 5 | Permit Number 37759 | 6005220.1458 | 2111114.8558 | 37.77701418991521 | -122.425465839355 | (37.7770141899152, -122.425465839355) | ||
| 66759 | 66759 | 78797 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 85 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 1 | 6001030.801469999 | 2087976.50512 | 37.713244179940794 | -122.43830000075899 | (37.7132441799408, -122.438300000759) | ||
| 66936 | 66936 | 188884 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 861 Vermont St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6011309.015240001 | 2104361.95853 | 37.7588144099776 | -122.40392711715799 | (37.7588144099776, -122.403927117158) | ||||
| 67255 | 67255 | 188883 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 861 Vermont St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6011316.75844 | 2104356.6633599997 | 37.75880030321861 | -122.403899964826 | (37.7588003032186, -122.403899964826) | ||||
| 67351 | 67351 | 247884 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 387 Mayflower St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009916.04567 | 2098399.5551400003 | 37.7423650480079 | -122.408324127476 | (37.7423650480079, -122.408324127476) | ||||
| 67406 | 67406 | 69044 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1426 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1994 12:00:00 AM | 2 | Permit Number 33051 | 5984041.3218 | 2105444.0326 | 37.760224347253704 | -122.498309886187 | (37.7602243472537, -122.498309886187) | |
| 67558 | 67558 | 111864 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Allston Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/26/2015 12:00:00 AM | 3 | Permit Number 775591 | 5994228.4 | 2098418.0 | 37.741524734078205 | -122.46256819082701 | (37.7415247340782, -122.462568190827) | ||
| 68387 | 68387 | 57845 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 153 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/1977 12:00:00 AM | 10 | Permit Number 16786 | 6004375.10165 | 2094347.97988 | 37.7309284999329 | -122.427194511121 | (37.7309284999329, -122.427194511121) | ||
| 69334 | 69334 | 38559 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1538 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 9 | Permit Number 40524 | 6015720.042 | 2095709.5571 | 37.735302164763496 | -122.38806780916799 | (37.7353021647635, -122.388067809168) | |
| 69346 | 69346 | 69027 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3830 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 0 | Permit Number 33031 | 5981593.45716069 | 2100816.99566217 | 37.747375971680796 | -122.50643260796801 | (37.7473759716808, -122.506432607968) | |
| 69422 | 69422 | 59553 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1700 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1981 12:00:00 AM | 9 | Permit Number 18938 | 6005363.02873 | 2118214.93321 | 37.7965173077913 | -122.425476975078 | (37.7965173077913, -122.425476975078) | ||
| 69433 | 69433 | 65697 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 20 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/1990 12:00:00 AM | 12 | Permit Number 28626 | 6000103.70653 | 2088525.9220900002 | 37.714699980888795 | -122.44154375196501 | (37.7146999808888, -122.441543751965) | |
| 69516 | 69516 | 54915 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 491 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1972 12:00:00 AM | 10 | Permit Number 10781 | 6011237.02996 | 2106095.07508 | 37.7635691382211 | -122.40429806051901 | (37.7635691382211, -122.404298060519) | ||
| 69680 | 69680 | 43164 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 243 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 7 | Permit Number 42974 | 6005687.812469999 | 2092539.3514599998 | 37.726036552238604 | -122.42252777796001 | (37.7260365522386, -122.42252777796) | |
| 69979 | 69979 | 116703 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 119 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6004176.22677 | 2094340.0625200002 | 37.730895511920096 | -122.427881490641 | (37.7308955119201, -122.427881490641) | ||||
| 70129 | 70129 | 60817 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1150 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/1983 12:00:00 AM | 3 | Permit Number 20495 | 5989806.3915 | 2101102.4889 | 37.7486399870467 | -122.478054033081 | (37.7486399870467, -122.478054033081) | |
| 70559 | 70559 | 54478 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 107 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1972 12:00:00 AM | 10 | Permit Number 10270 | 6012476.330519999 | 2095283.4732700002 | 37.7339519802024 | -122.399252687573 | (37.7339519802024, -122.399252687573) | ||
| 70843 | 70843 | 65434 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 555 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/1999 12:00:00 AM | Permit Number 33170 | 6008638.12512872 | 2114173.69680574 | 37.785605560242 | -122.41385837708 | (37.785605560242, -122.41385837708) | ||
| 70865 | 70865 | 204586 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 231 Edna St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998760.41171 | 2095319.0068400002 | 37.7332755919857 | -122.446675184631 | (37.7332755919857, -122.446675184631) | ||||
| 72128 | 72128 | 66041 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 74 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/1990 12:00:00 AM | 13 | Permit Number 29080 | 6004614.4703 | 2093089.36495 | 37.7274861568572 | -122.426277398677 | (37.7274861568572, -122.426277398677) | ||
| 72236 | 72236 | 58985 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 524 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1980 12:00:00 AM | 6 | Permit Number 18274 | 5995019.83864 | 2111966.36498 | 37.778770604928205 | -122.46081334146099 | (37.7787706049282, -122.460813341461) | ||
| 72277 | 72277 | 39921 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1938 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 4 | Permit Number 41195 | 6001498.9973 | 2115128.5111 | 37.7878237158389 | -122.43862607738998 | (37.7878237158389, -122.43862607739) | |
| 73197 | 73197 | 205752 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200x Terrace Dr | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5993857.73884 | 2096475.3667 | 37.7361693944936 | -122.46370883791501 | (37.7361693944936, -122.463708837915) | ||||
| 73377 | 73377 | 188946 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 398 Quint St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6015180.727109999 | 2099016.7469900004 | 37.7443531342865 | -122.390163407814 | (37.7443531342865, -122.390163407814) | ||||
| 73591 | 73591 | 56312 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 225 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 9 | Permit Number 12446 | 5993038.8288199995 | 2113952.3218099996 | 37.784109320359704 | -122.46781085101401 | (37.7841093203597, -122.467810851014) | ||
| 73609 | 73609 | 205796 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 432 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5997861.4274 | 2094122.1851400002 | 37.72993801002821 | -122.449696990342 | (37.7299380100282, -122.449696990342) | ||||
| 73804 | 73804 | 74038 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1501 25th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/1997 12:00:00 AM | 3 | 6014092.75077 | 2101968.0918900003 | 37.752396498007606 | -122.394132008099 | (37.7523964980076, -122.394132008099) | ||
| 74799 | 74799 | 61035 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 208 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 13 | Permit Number 20858 | 6011595.89338 | 2089312.04675 | 37.717506566247394 | -122.40187702801 | (37.7175065662474, -122.40187702801) | ||
| 75001 | 75001 | 222170 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 524 28th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | 6002478.0142 | 2099479.37016 | 37.7449106474076 | -122.434119733363 | (37.7449106474076, -122.434119733363) | ||||
| 75399 | 75399 | 54552 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 7 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 14 | Permit Number 10347 | 6012795.21693 | 2095672.85449 | 37.7350389071076 | -122.398177501316 | (37.7350389071076, -122.398177501316) | ||
| 75571 | 75571 | 64657 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 160 Boutwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1988 12:00:00 AM | 11 | Permit Number 25583 | 6010631.28531 | 2095737.0280400002 | 37.73509434492679 | -122.40566354073499 | (37.7350943449268, -122.405663540735) | ||
| 75751 | 75751 | 47272 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2407 Lincoln Wy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2002 12:00:00 AM | Permit Number 45213 | 5988289.74121062 | 2107116.7438459997 | 37.7650653584421 | -122.48373943230499 | (37.7650653584421, -122.483739432305) | |||
| 75794 | 75794 | 54149 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 34 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | 22 | Permit Number 9884 | 6013977.76426 | 2095493.9516 | 37.7346134738323 | -122.394076462386 | (37.7346134738323, -122.394076462386) |
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");