trees
3,267 rows where qSpecies_id = 67
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9815 | 204454 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 250 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992342.47482 | 2097596.2365 | 37.7391595899374 | -122.469029226223 | (37.7391595899374, -122.469029226223) | 1 | 8 | 4 | 59 | 40 | |||
| 9837 | 175669 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 218 Craut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004027.59383 | 2093929.81211 | 37.729760646628 | -122.428366110135 | (37.729760646628, -122.428366110135) | 9 | 7 | 6 | 28861 | 5 | |||
| 9967 | 15752 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4650 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6001829 | 2091729 | 37.7235930609595 | -122.435809477936 | (37.7235930609595, -122.435809477936) | 9 | 7 | 6 | 28861 | 25 | |||
| 10012 | 175625 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 22 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6009376.03196 | 2090018.08104 | 37.7193210519043 | -122.409599906627 | (37.7193210519043, -122.409599906627) | 9 | 3 | 8 | 309 | 18 | |||
| 10062 | 199899 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1829 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6015967.4581 | 2093314.0277 | 37.7287382249947 | -122.387045366056 | (37.7287382249947, -122.387045366056) | 10 | 3 | 8 | 58 | 1 | |||
| 10172 | 100673 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 680X Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008043.6 | 2121019.4 | 37.804368760788 | -122.41640033173 | (37.804368760788, -122.41640033173) | 5 | 1 | 10 | 308 | 32 | |||
| 10174 | 73299 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1970 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6001495.5714 | 2115163.912 | 37.7879207227072 | -122.438640467915 | (37.7879207227072, -122.438640467915) | 13 | 6 | 1 | 29490 | 27 | |||
| 10199 | 15747 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4596 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002118.4331 | 2092158.7505 | 37.7247894959296 | -122.434839677987 | (37.7247894959296, -122.434839677987) | 9 | 7 | 6 | 28861 | 25 | |||
| 10219 | 78797 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 85 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001030.80147 | 2087976.50512 | 37.7132441799408 | -122.438300000759 | (37.7132441799408, -122.438300000759) | 9 | 7 | 6 | 28861 | 5 | |||
| 10401 | 205781 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 451 Hearst Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998357.35987 | 2094370.04016 | 37.7306469222149 | -122.448000338355 | (37.7306469222149, -122.448000338355) | 9 | 7 | 4 | 28861 | 40 | |||
| 10420 | 105551 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1398X HAWES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6017214 | 2092838 | 37.7275000929711 | -122.382702837059 | (37.7275000929711, -122.382702837059) | 10 | 3 | 8 | 58 | 1 | |||
| 10430 | 220973 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6000866.47877 | 2097867.45006 | 37.7403931018698 | -122.439576579423 | (37.7403931018698, -122.439576579423) | 2 | 7 | 5 | 63 | 7 | |||
| 10544 | 3441 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 14 Cameo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 5999497.99147 | 2099800.24311 | 37.7456221064729 | -122.444447123237 | (37.7456221064729, -122.444447123237) | 2 | 7 | 5 | 63 | 22 | |||
| 10604 | 222394 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 18 Eagle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6000169.69731 | 2104368.33992 | 37.7582032963592 | -122.442452376583 | (37.7582032963592, -122.442452376583) | 2 | 4 | 5 | 28862 | 3 | |||
| 10711 | 247134 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 27th St | 4 | Front Yard : Yard | Tree | Private 2 | 6 | 6003187.16367 | 2100094.09523 | 37.7466387612688 | -122.431711508093 | (37.7466387612688, -122.431711508093) | 2 | 7 | 5 | 63 | 22 | ||||
| 10724 | 175667 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 218 Craut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004027.33391 | 2093958.94333 | 37.7298406197321 | -122.42836908418 | (37.7298406197321, -122.42836908418) | 9 | 7 | 6 | 28861 | 5 | |||
| 10766 | 189037 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010129.26407 | 2111748.29533 | 37.7790296110535 | -122.408528295169 | (37.7790296110535, -122.408528295169) | 14 | 2 | 9 | 28853 | 34 | |||
| 10778 | 189038 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010137.33918 | 2111739.58339 | 37.7790061423445 | -122.408499745276 | (37.7790061423445, -122.408499745276) | 14 | 2 | 9 | 28853 | 34 | |||
| 10804 | 125788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2812 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 5999154.81918 | 2118474.67758 | 37.7968777722368 | -122.446977352345 | (37.7968777722368, -122.446977352345) | 13 | 9 | 1 | 57 | 17 | |||
| 10844 | 122354 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 155 Appleton Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
| 10882 | 32604 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1327 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 6 | Permit Number 37070 | 5985214.1986 | 2106157.4162 | 37.7622518049359 | -122.494306102635 | (37.7622518049359, -122.494306102635) | 1 | 8 | 3 | 56 | 35 | |
| 10973 | 10788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200X Hudson Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | |||
| 10999 | 31902 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 965 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 14 | Permit Number 35327 | 6008027.66279 | 2109898.08591 | 37.7738314549808 | -122.415667565898 | (37.7738314549808, -122.415667565898) | 8 | 2 | 9 | 28853 | 34 | |
| 11001 | 222338 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3847 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002778.03156 | 2102959.54865 | 37.7544834197881 | -122.433330965848 | (37.7544834197881, -122.433330965848) | 2 | 4 | 5 | 28862 | 22 | |||
| 11008 | 125832 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6005294.88878 | 2118203.51089 | 37.7964820948146 | -122.425711940964 | (37.7964820948146, -122.425711940964) | 13 | 9 | 1 | 28858 | 17 | |||
| 11399 | 73153 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1970 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6001494.4295 | 2115195.887 | 37.7880084528635 | -122.438646710686 | (37.7880084528635, -122.438646710686) | 13 | 6 | 1 | 29490 | 27 | |||
| 11604 | 54558 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 8 | Permit Number 10353 | 6012731.08144 | 2095469.91543 | 37.7344781060868 | -122.398385007285 | (37.7344781060868, -122.398385007285) | 10 | 3 | 8 | 58 | 1 | ||
| 11637 | 220924 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 121 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6009569.56061 | 2097892.28263 | 37.7409527796372 | -122.409486379805 | (37.7409527796372, -122.409486379805) | 10 | 7 | 7 | 28859 | 2 | |||
| 11996 | 204552 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 60 | Median : Cutout | Tree | DPW 1 | 11 | Width 5ft | 5999641.44525 | 2097441.40723 | 37.7391534907361 | -122.443781647414 | (37.7391534907361, -122.443781647414) | 9 | 7 | 4 | 59 | 40 | |||
| 12005 | 222475 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1712 Sanchez St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6003947.79258 | 2098269.9182 | 37.7416730781499 | -122.428951298963 | (37.7416730781499, -122.428951298963) | 2 | 7 | 5 | 63 | 7 | |||
| 12081 | 69044 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1426 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 2 | Permit Number 33051 | 5984041.3218 | 2105444.0326 | 37.7602243472537 | -122.498309886187 | (37.7602243472537, -122.498309886187) | 1 | 8 | 3 | 56 | 35 | |
| 12114 | 78378 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Russia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6001605.25452 | 2090913.72299 | 37.7213417817901 | -122.436524599656 | (37.7213417817901, -122.436524599656) | 9 | 7 | 6 | 28861 | 5 | |||
| 12140 | 260108 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 921 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008890 | 2090823 | 37.7215039438499 | -122.411336776053 | (37.7215039438499, -122.411336776053) | 9 | 3 | 7 | 309 | 28 | ||||
| 12167 | 259578 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 350 Public Park | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 3x3 | 5994424 | 2098888 | 37.7428264992104 | -122.461925951337 | (37.7428264992104, -122.461925951337) | 1 | 8 | 4 | 59 | 40 | ||||
| 12234 | 112475 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1799X Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5988753.5421 | 2104412.2034 | 37.7576664111078 | -122.481937145542 | (37.7576664111078, -122.481937145542) | 1 | 8 | 3 | 56 | 35 | |||
| 12374 | 65607 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 182 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767458 | 6004579.16944 | 2093759.75788 | 37.7293249116129 | -122.426447147525 | (37.7293249116129, -122.426447147525) | 9 | 7 | 6 | 28861 | 5 |
| 12381 | 65434 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 555 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/1999 12:00:00 AM | Permit Number 33170 | 6008638.12512872 | 2114173.69680574 | 37.785605560242 | -122.41385837708 | (37.785605560242, -122.41385837708) | 7 | 10 | 9 | 28852 | 36 | ||
| 12455 | 222436 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 277 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999681.48171 | 2105384.26851 | 37.760964945302 | -122.444213835499 | (37.760964945302, -122.444213835499) | 15 | 5 | 5 | 28862 | 3 | |||
| 12481 | 220975 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 27 Dawnview Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998722.32011 | 2100761.22513 | 37.7482164410366 | -122.447198415596 | (37.7482164410366, -122.447198415596) | 2 | 5 | 5 | 63 | 38 | |||
| 12522 | 125844 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1463 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006489.38359 | 2117961.8198 | 37.7958858973642 | -122.421561549045 | (37.7958858973642, -122.421561549045) | 13 | 9 | 10 | 28858 | 32 | |||
| 12669 | 222494 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 21 Harry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6003368.61725 | 2097750.91511 | 37.7402152150692 | -122.430916860842 | (37.7402152150692, -122.430916860842) | 2 | 7 | 5 | 63 | 7 | |||
| 12837 | 47215 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 106 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45166 | 6006633.47627 | 2094299.61445 | 37.7309231552671 | -122.419383490876 | (37.7309231552671, -122.419383490876) | 9 | 7 | 7 | 309 | 5 | |
| 12851 | 188928 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012639.77007 | 2101842.50365 | 37.7519707940373 | -122.39914787158 | (37.7519707940373, -122.39914787158) | 10 | 3 | 8 | 28856 | 29 | |||
| 12868 | 111864 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Allston Way | 1 | Front Yard : Yard | Tree | Private 2 | 06/26/2015 12:00:00 AM | 3 | Permit Number 775591 | 5994228.4 | 2098418 | 37.7415247340782 | -122.462568190827 | (37.7415247340782, -122.462568190827) | 1 | 8 | 4 | 59 | 40 | ||
| 12915 | 120365 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2250 Cabrillo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5988577.68715 | 2110575.68251 | 37.7745794071716 | -122.482997045151 | (37.7745794071716, -122.482997045151) | 11 | 6 | 2 | 55 | 26 | |||
| 12936 | 189036 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010111.83402 | 2111767.71706 | 37.7790819623998 | -122.408589963453 | (37.7790819623998, -122.408589963453) | 14 | 2 | 9 | 28853 | 34 | |||
| 13010 | 247253 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6000028.37595 | 2108519.10482 | 37.7695922091358 | -122.443239243804 | (37.7695922091358, -122.443239243804) | 15 | 5 | 11 | 29492 | 9 | |||
| 13088 | 8817 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3800 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5995279.8386756 | 2112876.8357526 | 37.7812854712581 | -122.459979879431 | (37.7812854712581, -122.459979879431) | 11 | 6 | 2 | 54 | 11 | |||
| 13274 | 188254 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013780.02718 | 2089753.49239 | 37.7188403408752 | -122.39435831441 | (37.7188403408752, -122.39435831441) | 10 | 3 | 8 | 58 | 1 | ||||
| 13378 | 73382 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 502 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6001158.1468 | 2110520.1446 | 37.7751509205215 | -122.439474878934 | (37.7751509205215, -122.439474878934) | 15 | 5 | 11 | 29492 | 10 | |||
| 13380 | 55308 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1595 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1972 12:00:00 AM | 10 | Permit Number 11237 | 6005282.80537 | 2119544.50402 | 37.8001634372533 | -122.425849253052 | (37.8001634372533, -122.425849253052) | 13 | 9 | 1 | 57 | 17 | ||
| 13520 | 175634 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 29 Tucker Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010973.25986 | 2088486.32565 | 37.7152045356343 | -122.403971122781 | (37.7152045356343, -122.403971122781) | 9 | 7 | 8 | 309 | 39 | |||
| 13824 | 101104 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1580 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25190 | 5989126.9 | 2103185.1 | 37.754318820325 | -122.480556110859 | (37.754318820325, -122.480556110859) | 1 | 8 | 3 | 56 | 35 | ||||
| 14011 | 247884 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 387 Mayflower St | 5 | Side Yard : Yard | Tree | Private 2 | 8 | 6009916.04567 | 2098399.55514 | 37.7423650480079 | -122.408324127476 | (37.7423650480079, -122.408324127476) | 10 | 7 | 7 | 28859 | 2 | ||||
| 14118 | 125818 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2081 Green St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003105.57534 | 2118201.45062 | 37.7963524818244 | -122.433287285795 | (37.7963524818244, -122.433287285795) | 13 | 9 | 1 | 57 | 17 | |||
| 14482 | 175650 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990453.87404 | 2090277.74723 | 37.7189555611377 | -122.475024995517 | (37.7189555611377, -122.475024995517) | 1 | 8 | 4 | 64 | 14 | |||
| 14659 | 55328 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 225 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 8 | Permit Number 11259 | 6011565.54063 | 2089256.51546 | 37.717352394562 | -122.40197804257 | (37.717352394562, -122.40197804257) | 10 | 7 | 8 | 309 | 39 | ||
| 14798 | 199912 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1319 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016381.1458 | 2093047.4167 | 37.728029062608 | -122.385596634641 | (37.728029062608, -122.385596634641) | 10 | 3 | 8 | 58 | 1 | |||
| 14824 | 188911 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6012384.77523 | 2101833.46813 | 37.751931770655 | -122.400029051595 | (37.751931770655, -122.400029051595) | 10 | 3 | 8 | 28856 | 29 | |||
| 14853 | 188956 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1706 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014961.30392 | 2096622.74747 | 37.7377675329349 | -122.390754864938 | (37.7377675329349, -122.390754864938) | 10 | 3 | 8 | 58 | 1 | |||
| 14863 | 222337 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 584 Diamond St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001829.51468 | 2102403.81265 | 37.7529036455068 | -122.436571403945 | (37.7529036455068, -122.436571403945) | 2 | 4 | 5 | 28862 | 22 | |||
| 14928 | 120545 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2195 18th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990654 | 2100514 | 37.7470733117967 | -122.475080088588 | (37.7470733117967, -122.475080088588) | 1 | 8 | 4 | 29491 | 40 | ||||
| 14974 | 71651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 177 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5994505.19973 | 2086471.6739 | 37.7087389470079 | -122.460745569971 | (37.7087389470079, -122.460745569971) | 9 | 8 | 6 | 28861 | 25 | |||
| 15010 | 35807 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Sycamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.7625808703221 | -122.420443179735 | (37.7625808703221, -122.420443179735) | 8 | 4 | 7 | 28859 | 19 | ||
| 15023 | 125822 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2301 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6003751.95692 | 2115935.88569 | 37.7901684673368 | -122.430888902704 | (37.7901684673368, -122.430888902704) | 13 | 9 | 1 | 29490 | 27 | |||
| 15047 | 222339 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 902 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003088.6063 | 2102957.06813 | 37.7544942233475 | -122.432256740954 | (37.7544942233475, -122.432256740954) | 2 | 4 | 5 | 28862 | 22 | |||
| 15197 | 205713 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 141 Taraval St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993198.15008 | 2099148.55003 | 37.7434712545842 | -122.466183490689 | (37.7434712545842, -122.466183490689) | 1 | 8 | 4 | 59 | 40 | |||
| 15203 | 70396 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 309 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6005777.21829 | 2092245.96314 | 37.7252360153268 | -122.422197872442 | (37.7252360153268, -122.422197872442) | 9 | 7 | 7 | 309 | 5 | |||
| 15208 | 56135 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 719 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 10 | Permit Number 12238 | 6012444.68154 | 2104578.12119 | 37.7594713278533 | -122.400014612979 | (37.7594713278533, -122.400014612979) | 10 | 3 | 8 | 28856 | 29 | ||
| 15293 | 78417 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3345 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988680.63361 | 2095198.47268 | 37.7323636938327 | -122.481514509695 | (37.7323636938327, -122.481514509695) | 1 | 8 | 4 | 64 | 35 | |||
| 15323 | 222453 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 349 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004042.83429 | 2109029.18488 | 37.7712208597768 | -122.429389756259 | (37.7712208597768, -122.429389756259) | 7 | 9 | 11 | 29492 | 10 | |||
| 15396 | 71222 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2207 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5987585.8685 | 2100255.6538 | 37.746185666387 | -122.485670338512 | (37.746185666387, -122.485670338512) | 1 | 8 | 3 | 29491 | 35 | |||
| 15502 | 78224 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1214 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009704.84764 | 2090538.93921 | 37.7207696402774 | -122.408500030351 | (37.7207696402774, -122.408500030351) | 9 | 3 | 7 | 309 | 28 | |||
| 15573 | 10975 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1468X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016410.2814628 | 2096936.3836856 | 37.7387090009717 | -122.385766856192 | (37.7387090009717, -122.385766856192) | 10 | 3 | 8 | 58 | 1 | |||
| 15598 | 112413 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 469x IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005169 | 2110996 | 37.7766849510116 | -122.425634307332 | (37.7766849510116, -122.425634307332) | 7 | 9 | 11 | 28852 | 10 | ||||
| 15665 | 222485 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002560.02403 | 2096411.24476 | 37.7364909407996 | -122.433616928699 | (37.7364909407996, -122.433616928699) | 2 | 7 | 5 | 63 | 7 | |||
| 15793 | 42348 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 7 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 3 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
| 15816 | 26895 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1245X Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4 | 6015870.9547371 | 2095407.1210845 | 37.7344800964063 | -122.387524951 | (37.7344800964063, -122.387524951) | 10 | 3 | 8 | 58 | 1 | |||
| 15917 | 247048 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 537 Valley St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6002432.31725 | 2099137.61339 | 37.7439696696596 | -122.434253316852 | (37.7439696696596, -122.434253316852) | 2 | 7 | 5 | 63 | 22 | |||
| 15976 | 31863 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 550 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | Permit Number 35305 | 5994717.97074246 | 2111781.46316747 | 37.7782455405542 | -122.461844202225 | (37.7782455405542, -122.461844202225) | 11 | 6 | 2 | 54 | 11 | |||
| 16073 | 222257 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 34 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009162.53021 | 2097236.17229 | 37.7391284284365 | -122.410847419192 | (37.7391284284365, -122.410847419192) | 10 | 7 | 7 | 28859 | 2 | |||
| 16154 | 188901 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1640 20th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6013030.31907 | 2104757.32999 | 37.7599960301161 | -122.39800174768 | (37.7599960301161, -122.39800174768) | 10 | 3 | 8 | 28856 | 29 | |||
| 16202 | 8839 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
| 16254 | 189034 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010058.78317 | 2111821.06751 | 37.7792254789148 | -122.408777253584 | (37.7792254789148, -122.408777253584) | 14 | 2 | 9 | 28853 | 34 | |||
| 16361 | 188907 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1551 19th St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6013010.92349 | 2105173.17566 | 37.7611367706692 | -122.398098002138 | (37.7611367706692, -122.398098002138) | 10 | 3 | 8 | 28856 | 29 | |||
| 16632 | 42238 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 479 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42487 | 6010497.26908 | 2112250.8624 | 37.7804301450699 | -122.407290649051 | (37.7804301450699, -122.407290649051) | 14 | 2 | 9 | 28853 | 34 | |
| 16704 | 30848 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1153 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/1995 12:00:00 AM | 14 | Permit Number 34697 | 6002549.89906 | 2102133.17334 | 37.7522014449412 | -122.434060837652 | (37.7522014449412, -122.434060837652) | 2 | 4 | 5 | 28862 | 22 | |
| 16774 | 8683 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
| 16874 | 55307 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2770 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2012 12:00:00 AM | 2 | Permit Number 769514 | 6005272.5834 | 2119510.27332 | 37.8000688708465 | -122.42588218711 | (37.8000688708465, -122.42588218711) | 13 | 9 | 1 | 57 | 17 | ||
| 16928 | 118190 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 830 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5985433.46743 | 2110210.14946 | 37.7733922984241 | -122.493846418352 | (37.7733922984241, -122.493846418352) | 11 | 6 | 2 | 55 | 26 | |||
| 17030 | 220770 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 54 Pearl St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6005613.92059 | 2108688.47135 | 37.7703741651755 | -122.423931067487 | (37.7703741651755, -122.423931067487) | 8 | 2 | 5 | 28853 | 19 | |||
| 17168 | 8947 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4800 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
| 17297 | 189039 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010144.76793 | 2111731.54232 | 37.7789844794824 | -122.408473478765 | (37.7789844794824, -122.408473478765) | 14 | 2 | 9 | 28853 | 34 | |||
| 17307 | 74930 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4045 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982222.2441 | 2104869.0336 | 37.7585387287405 | -122.50455850909 | (37.7585387287405, -122.50455850909) | 1 | 8 | 3 | 56 | 35 | |||
| 17440 | 188953 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1723 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014879.29111 | 2096612.07207 | 37.7377336698595 | -122.391037679267 | (37.7377336698595, -122.391037679267) | 10 | 3 | 8 | 58 | 1 | |||
| 17521 | 142554 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 670 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6008032.7708 | 2121023.624 | 37.8043797498479 | -122.416438106574 | (37.8043797498479, -122.416438106574) | 5 | 1 | 10 | 308 | 32 | |||
| 17591 | 222359 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 496 Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003219.50427 | 2102739.56773 | 37.7539044398485 | -122.431788533216 | (37.7539044398485, -122.431788533216) | 2 | 4 | 5 | 28862 | 22 | |||
| 17592 | 205706 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 141 Taraval St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993174.64326 | 2099144.25251 | 37.7434580984164 | -122.466264458435 | (37.7434580984164, -122.466264458435) | 1 | 8 | 4 | 59 | 40 | |||
| 17841 | 107624 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 467 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011064.4697 | 2111919.17259 | 37.7795511306237 | -122.405305061079 | (37.7795511306237, -122.405305061079) | 14 | 2 | 9 | 28853 | 34 | |||
| 17947 | 222204 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Worth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000891.10082 | 2103189.05131 | 37.7550063494651 | -122.439872903318 | (37.7550063494651, -122.439872903318) | 2 | 4 | 5 | 28862 | 22 |
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) );