trees
3,267 rows where qSpecies_id = 67 sorted by PlantDate 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
170081 | 105128 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1835 47TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774579 | 5981612.2 | 2102591.6 | 37.7522496399023 | -122.506499383522 | (37.7522496399023, -122.506499383522) | 1 | 8 | 3 | 56 | 35 | |
173024 | 29053 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 340 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008751.06899 | 2108844.78645 | 37.770979979973 | -122.413090685387 | (37.770979979973, -122.413090685387) | 8 | 2 | 9 | 28853 | 19 | ||
181812 | 114958 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 66 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2015 12:00:00 AM | 1 | Permit Number 775977 | 5999698.38088 | 2087820.43772 | 37.7127397789845 | -122.44289408849 | (37.7127397789845, -122.44289408849) | 9 | 7 | 6 | 28861 | 5 | ||
6771 | 43351 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 385 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1977 12:00:00 AM | 26 | 3x3 | Permit Number 43103 | 6010005.03169 | 2109964.91982 | 37.7741259209126 | -122.408832212936 | (37.7741259209126, -122.408832212936) | 8 | 2 | 9 | 28853 | 34 | |
6660 | 189023 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010789.05197 | 2109573.65252 | 37.7730954749965 | -122.406092565024 | (37.7730954749965, -122.406092565024) | 14 | 2 | 9 | 28853 | 34 | ||
41108 | 189025 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010814.25369 | 2109596.96764 | 37.7731609024948 | -122.406007031421 | (37.7731609024948, -122.406007031421) | 14 | 2 | 9 | 28853 | 34 | ||
45547 | 189024 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010801.22197 | 2109583.73033 | 37.7731238270259 | -122.406051177336 | (37.7731238270259, -122.406051177336) | 14 | 2 | 9 | 28853 | 34 | ||
47135 | 189026 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010848.73344 | 2109624.73915 | 37.7732390850389 | -122.405889717541 | (37.7732390850389, -122.405889717541) | 14 | 2 | 9 | 28853 | 34 | ||
170526 | 189022 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010767.85313 | 2109551.04982 | 37.7730322274755 | -122.406164302148 | (37.7730322274755, -122.406164302148) | 14 | 2 | 9 | 28853 | 34 | ||
181438 | 189021 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010755.67796 | 2109540.70716 | 37.7730031478998 | -122.406205688962 | (37.7730031478998, -122.406205688962) | 14 | 2 | 9 | 28853 | 34 | ||
97011 | 63557 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2971 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/20/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768581 | 6008414.60000343 | 2103856.53351654 | 37.7572644957121 | -122.413901624069 | (37.7572644957121, -122.413901624069) | 2 | 4 | 7 | 28859 | 19 |
121970 | 102062 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 26 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769724 | 6007185 | 2097679 | 37.7402332527197 | -122.417716218117 | (37.7402332527197, -122.417716218117) | 2 | 7 | 7 | 28859 | 2 |
102189 | 46107 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 76 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2001 12:00:00 AM | Permit Number 44471 | 6005231.58471967 | 2105020.01841489 | 37.7602798751206 | -122.424992522324 | (37.7602798751206, -122.424992522324) | 2 | 4 | 5 | 28859 | 19 | ||
137642 | 63185 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 422 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 10 | Permit Number 23724 | 5984714.39169 | 2112987.07257 | 37.7809748328781 | -122.496538722251 | (37.7809748328781, -122.496538722251) | 11 | 6 | 2 | 55 | 26 | |
193878 | 34952 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 315 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1997 12:00:00 AM | Permit Number 38549 | 5994259.00226066 | 2099898.8670044 | 37.7455925857292 | -122.462569772731 | (37.7455925857292, -122.462569772731) | 1 | 8 | 4 | 29491 | 40 | |||
140447 | 64202 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 712 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1987 12:00:00 AM | 7 | Permit Number 24989 | 6007253.84118 | 2121612.31265 | 37.8059523049123 | -122.419175447994 | (37.8059523049123, -122.419175447994) | 5 | 1 | 1 | 28858 | 32 | ||
4343 | 65663 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1991 12:00:00 AM | Permit Number 28583 | 5998824.47448758 | 2095859.96140736 | 37.7347645844735 | -122.446492607567 | (37.7347645844735, -122.446492607567) | 9 | 7 | 4 | 59 | 40 | ||
87728 | 114804 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2427 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2015 12:00:00 AM | Permit Number 775689 | 5989172 | 2098830.2 | 37.7423640356628 | -122.480081453283 | (37.7423640356628, -122.480081453283) | 1 | 8 | 3 | 29491 | 35 | |||
110778 | 62443 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4486 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22606 | 5999444.95917987 | 2105754.12577185 | 37.7619669848025 | -122.445058450512 | (37.7619669848025, -122.445058450512) | 15 | 5 | 5 | 28862 | 3 | ||
156980 | 222459 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 103 Germania St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 12 | Width 3ft | Permit Number 37768 | 6003745.35961 | 2108826.05534 | 37.7706462694291 | -122.430404237367 | (37.7706462694291, -122.430404237367) | 15 | 9 | 11 | 29492 | 10 | |
73494 | 33678 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 447 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 5 | Permit Number 37759 | 6005220.1458 | 2111114.8558 | 37.7770141899152 | -122.425465839355 | (37.7770141899152, -122.425465839355) | 7 | 9 | 11 | 28852 | 10 | ||
173061 | 63097 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3060 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1986 12:00:00 AM | 11 | Permit Number 23584 | 6001459.2061 | 2118948.46858 | 37.798310061319 | -122.439037622007 | (37.798310061319, -122.439037622007) | 13 | 9 | 1 | 57 | 17 | ||
30996 | 27121 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2335 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2002 12:00:00 AM | 12 | 2x2 | 6013101.69827 | 2096426.31583 | 37.7371248216631 | -122.397170694996 | (37.7371248216631, -122.397170694996) | 10 | 3 | 8 | 58 | 1 | ||
100159 | 33604 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37717 | 6005085.63985065 | 2110091.4174032 | 37.7741964769258 | -122.42585827051 | (37.7741964769258, -122.42585827051) | 7 | 9 | 11 | 28852 | 10 | |||
160347 | 33603 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37717 | 6005085.63985065 | 2110091.4174032 | 37.7741964769258 | -122.42585827051 | (37.7741964769258, -122.42585827051) | 7 | 9 | 11 | 28852 | 10 | |||
110050 | 114702 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 237 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774513 | 6006534.54774 | 2092840.44849 | 37.7269110313963 | -122.41962201445 | (37.7269110313963, -122.41962201445) | 9 | 7 | 7 | 309 | 5 | ||
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 | ||
171059 | 68203 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 259 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1993 12:00:00 AM | 7 | Permit Number 32750 | 5993355.85866 | 2113766.00242 | 37.783616039219 | -122.466700502775 | (37.783616039219, -122.466700502775) | 11 | 6 | 2 | 54 | 11 | ||
101695 | 65575 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 44 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2007 12:00:00 AM | 3x3 | Permit Number 49937 | 6007552.07395288 | 2099897.22885684 | 37.7463446647462 | -122.41660411777 | (37.7463446647462, -122.41660411777) | 2 | 7 | 7 | 28859 | 2 | ||
4040 | 33572 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 154 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37681 | 6007125.01151204 | 2098130.43275156 | 37.7414694106773 | -122.417955628165 | (37.7414694106773, -122.417955628165) | 2 | 7 | 7 | 28859 | 2 | |||
88734 | 33570 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 152 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37680 | 6007130.56275094 | 2098140.70005851 | 37.74149791484 | -122.417937161506 | (37.74149791484, -122.417937161506) | 2 | 7 | 7 | 28859 | 2 | |||
138162 | 33571 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 152 Bonview St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37680 | 6007130.56275094 | 2098140.70005851 | 37.74149791484 | -122.417937161506 | (37.74149791484, -122.417937161506) | 2 | 7 | 7 | 28859 | 2 | |||
76854 | 61661 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 246 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/1984 12:00:00 AM | Permit Number 21655 | 6006644.56233954 | 2093348.38333355 | 37.7283119065735 | -122.419277711746 | (37.7283119065735, -122.419277711746) | 9 | 7 | 7 | 309 | 5 | ||
53134 | 33548 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 252 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37656 | 6007019.4634549 | 2097570.65263156 | 37.7399264382232 | -122.418280898297 | (37.7399264382232, -122.418280898297) | 2 | 7 | 7 | 28859 | 2 | |||
62353 | 33545 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 24 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37653 | 6007172.51039113 | 2097685.46488673 | 37.7402503010209 | -122.417759860395 | (37.7402503010209, -122.417759860395) | 2 | 7 | 7 | 28859 | 2 | |||
114778 | 33541 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 213 BOCANA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37650 | 6007164 | 2097722 | 37.7403501394021 | -122.417791875043 | (37.7403501394021, -122.417791875043) | 2 | 7 | 7 | 28859 | 2 | |||
115714 | 33540 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 213 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37650 | 6007159.19506099 | 2097721.08233602 | 37.7403473492981 | -122.417808423627 | (37.7403473492981, -122.417808423627) | 2 | 7 | 7 | 28859 | 2 | |||
146423 | 53514 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1382 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1969 12:00:00 AM | 3 | Permit Number 6426 | 6015935.5088 | 2093105.8067 | 37.7281647222543 | -122.38714130029 | (37.7281647222543, -122.38714130029) | 10 | 3 | 8 | 58 | 1 | ||
76760 | 81369 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 14 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2011 12:00:00 AM | Permit Number 58731 | 5992684.22042124 | 2099043.76352214 | 37.7431538726351 | -122.467952894625 | (37.7431538726351, -122.467952894625) | 1 | 8 | 4 | 29491 | 40 | |||
181754 | 68791 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2354 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32729 | 5992040.99368144 | 2099415.84247722 | 37.744138340677 | -122.470204069983 | (37.744138340677, -122.470204069983) | 1 | 8 | 4 | 29491 | 40 | ||
91000 | 63069 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 152 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1986 12:00:00 AM | Permit Number 23543 | 6008631.63225831 | 2097862.90988188 | 37.7408195298569 | -122.412727325892 | (37.7408195298569, -122.412727325892) | 10 | 7 | 7 | 28859 | 2 | ||
74588 | 67715 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 472 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 8 | 3x3 | Permit Number 31328 | 6013692.95356 | 2112582.14451 | 37.7815181053298 | -122.396258423594 | (37.7815181053298, -122.396258423594) | 6 | 2 | 9 | 28856 | 34 |
9718 | 66871 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 350 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 30181 | 6001115.30809688 | 2104289.68730442 | 37.7580411890038 | -122.43917641405 | (37.7580411890038, -122.43917641405) | 2 | 4 | 5 | 28862 | 38 | ||
21777 | 66859 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1116 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1991 12:00:00 AM | 4 | Permit Number 30166 | 5989755.3106 | 2099063.2795 | 37.7430378863443 | -122.478081600833 | (37.7430378863443, -122.478081600833) | 1 | 8 | 3 | 29491 | 35 | ||
144759 | 58086 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3001 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1977 12:00:00 AM | 7 | Permit Number 17057 | 6002870.87342 | 2118942.93288 | 37.7983750823084 | -122.434152436312 | (37.7983750823084, -122.434152436312) | 13 | 9 | 1 | 57 | 17 | ||
153062 | 54453 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1305 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1976 12:00:00 AM | 9 | Permit Number 16511 | 6013657.09709 | 2105679.36016 | 37.7625626116008 | -122.39589862014 | (37.7625626116008, -122.39589862014) | 14 | 3 | 8 | 28856 | 29 | ||
153304 | 57621 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1319 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1976 12:00:00 AM | 6 | Permit Number 16514 | 6013585.69477 | 2105673.14999 | 37.7625415872419 | -122.396145141378 | (37.7625415872419, -122.396145141378) | 14 | 3 | 8 | 28856 | 29 | ||
193874 | 57620 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1315 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1976 12:00:00 AM | 7 | Permit Number 16513 | 6013619.85223 | 2105678.11132 | 37.7625571104404 | -122.396027350002 | (37.7625571104404, -122.396027350002) | 14 | 3 | 8 | 28856 | 29 | ||
81070 | 256613 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2214 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781468 | 5985177 | 2100108 | 37.745639596763 | -122.493988903155 | (37.745639596763, -122.493988903155) | 1 | 8 | 3 | 29491 | 35 | |
45977 | 33246 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2455 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 3 | Permit Number 37427 | 5987953.5529 | 2098598.711 | 37.7416575568292 | -122.484277448664 | (37.7416575568292, -122.484277448664) | 1 | 8 | 3 | 29491 | 35 | |
58462 | 57605 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 250 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/1976 12:00:00 AM | 3x3 | Permit Number 26693 | 5999752.23932038 | 2094391.78344807 | 37.7307862598115 | -122.443179604218 | (37.7307862598115, -122.443179604218) | 9 | 7 | 4 | 63 | 40 | ||
139415 | 59349 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 275 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/1980 12:00:00 AM | 10 | Permit Number 18697 | 6002772.3177 | 2086703.69426 | 37.7098482184782 | -122.432189886274 | (37.7098482184782, -122.432189886274) | 9 | 7 | 6 | 28861 | 5 | ||
175101 | 45780 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 646 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2001 12:00:00 AM | Permit Number 44420 | 5990064.86918672 | 2110959.72836088 | 37.7757203159741 | -122.47788072714 | (37.7757203159741, -122.47788072714) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||
129719 | 67678 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1566 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 11 | Permit Number 31282 | 6014784.0524 | 2093614.4352 | 37.7294974829563 | -122.391157497644 | (37.7294974829563, -122.391157497644) | 10 | 3 | 8 | 58 | 1 | |
9444 | 205868 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 Lakeview Ave | 1 | : | Tree | Private 2 | 11/04/1969 12:00:00 AM | 13 | Width 3ft | Permit Number 6398 | 5996845.79725 | 2089640.92362 | 37.7175753652817 | -122.452884796511 | (37.7175753652817, -122.452884796511) | 9 | 8 | 6 | 28861 | 24 | |
145385 | 44097 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 690 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2000 12:00:00 AM | Permit Number 43610 | 6012084.69063396 | 2105194.13037963 | 37.7611426751013 | -122.401302935991 | (37.7611426751013, -122.401302935991) | 10 | 3 | 8 | 28856 | 29 | |||
179916 | 44096 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 690 De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2000 12:00:00 AM | Permit Number 43610 | 6012084.69063396 | 2105194.13037963 | 37.7611426751013 | -122.401302935991 | (37.7611426751013, -122.401302935991) | 10 | 3 | 8 | 28856 | 29 | |||
36494 | 38922 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 758 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/1998 12:00:00 AM | Permit Number 40732 | 5994446.73850644 | 2089956.09273845 | 37.7183029732854 | -122.461200022537 | (37.7183029732854, -122.461200022537) | 9 | 8 | 6 | 28861 | 24 | |||
104602 | 66255 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 47 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1991 12:00:00 AM | Permit Number 29357 | 5998777.54020022 | 2095889.92461041 | 37.7348441754269 | -122.446657030024 | (37.7348441754269, -122.446657030024) | 9 | 7 | 4 | 59 | 40 | ||
125991 | 66267 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 948 Key Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1990 12:00:00 AM | 4 | Permit Number 29374 | 6013650.54179 | 2089569.78312 | 37.7183287129789 | -122.394793038594 | (37.7183287129789, -122.394793038594) | 10 | 3 | 8 | 58 | 1 | ||
71077 | 57192 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 896X DOUGLASS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1974 12:00:00 AM | 3x3 | Permit Number 14472 | 6001277 | 2101164 | 37.7494680040733 | -122.438393281323 | (37.7494680040733, -122.438393281323) | 2 | 4 | 5 | 28862 | 22 | ||
1528 | 70442 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2017 12:00:00 AM | 3 | Permit Number 780711 | 5983049.5384 | 2098315.9426 | 37.7405943893559 | -122.501212699104 | (37.7405943893559, -122.501212699104) | 1 | 8 | 3 | 29491 | 35 | |
186412 | 13167 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1906 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 26 | 3X3 | 6003216.0169 | 2119655.6641 | 37.8003516396791 | -122.433009083838 | (37.8003516396791, -122.433009083838) | 13 | 9 | 1 | 57 | 17 | ||
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 | ||
24420 | 55329 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 241 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 10 | Permit Number 11260 | 6011497.74978 | 2089236.66648 | 37.7172941095093 | -122.402210970564 | (37.7172941095093, -122.402210970564) | 10 | 7 | 8 | 309 | 39 | ||
98366 | 55331 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 245 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 12 | Permit Number 11262 | 6011470.05429 | 2089227.30087 | 37.7172668474735 | -122.402306043313 | (37.7172668474735, -122.402306043313) | 10 | 7 | 8 | 309 | 39 | ||
101547 | 55325 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1231 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 11 | Permit Number 11255 | 6011451.82111 | 2089071.07644 | 37.7168368689981 | -122.402358088854 | (37.7168368689981, -122.402358088854) | 10 | 7 | 8 | 309 | 39 | ||
145568 | 55327 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | Permit Number 11257 | 6011659.22686105 | 2089335.34929904 | 37.717574084708 | -122.401659748875 | (37.717574084708, -122.401659748875) | 10 | 7 | 8 | 309 | 39 | |||
147209 | 55323 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1186 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 18 | Permit Number 11253 | 6011357.40386 | 2089280.46993 | 37.7174065499613 | -122.402699162137 | (37.7174065499613, -122.402699162137) | 10 | 7 | 8 | 309 | 39 | ||
162306 | 61035 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 208 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 13 | Permit Number 20858 | 6011595.89338 | 2089312.04675 | 37.7175065662474 | -122.40187702801 | (37.7175065662474, -122.40187702801) | 10 | 7 | 8 | 309 | 39 | ||
177709 | 42671 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1115 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49824 | 6007552.92747 | 2119520.43861 | 37.8002253861525 | -122.417992022918 | (37.8002253861525, -122.417992022918) | 5 | 1 | 1 | 28858 | 32 | |
54750 | 81857 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 550 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49819 | 6013442.18813 | 2112205.75243 | 37.780470662242 | -122.397099557694 | (37.780470662242, -122.397099557694) | 6 | 2 | 9 | 28856 | 34 | |
170366 | 66252 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2145 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29353 | 6003919.79626515 | 2107385.50523164 | 37.7667007479345 | -122.429698098531 | (37.7667007479345, -122.429698098531) | 8 | 4 | 5 | 28862 | 3 | ||
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 | |
156270 | 61052 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 201-203 HEARST AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1994 12:00:00 AM | 8 | 3x3 | Permit Number 20880 | 6000007 | 2094313 | 37.7305844621254 | -122.442293205182 | (37.7305844621254, -122.442293205182) | 9 | 7 | 4 | 63 | 40 |
180645 | 68649 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1958 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32554 | 5990677.94928449 | 2102064.97890772 | 37.7513332827559 | -122.475110479712 | (37.7513332827559, -122.475110479712) | 1 | 8 | 4 | 29491 | 12 | ||
108835 | 40956 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 39 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1999 12:00:00 AM | Permit Number 41810 | 5993626.53166315 | 2093066.42761178 | 37.7267959624654 | -122.464260796159 | (37.7267959624654, -122.464260796159) | 9 | 8 | 4 | 59 | 40 | |||
2331 | 68539 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 155 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 7 | 3x7 | Permit Number 32421 | 5991148.39741 | 2114378.82995 | 37.7851710530124 | -122.474382132413 | (37.7851710530124, -122.474382132413) | 11 | 6 | 2 | 54 | 26 |
162717 | 68498 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1830 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32374 | 5993468.12743357 | 2103022.1478049 | 37.7541227389181 | -122.465531331053 | (37.7541227389181, -122.465531331053) | 1 | 8 | 4 | 56 | 12 | ||
27771 | 53400 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2502 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/1969 12:00:00 AM | 10 | Permit Number 6299 | 5990880.06647 | 2112020.40978 | 37.7786799348836 | -122.475138234513 | (37.7786799348836, -122.475138234513) | 11 | 6 | 2 | 54 | 26 | ||
19862 | 32496 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 631 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 9 | Permit Number 37001 | 6007448.1287 | 2095989.14143 | 37.7356080772339 | -122.416686739725 | (37.7356080772339, -122.416686739725) | 2 | 7 | 7 | 28859 | 2 | |
133916 | 64699 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3290 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/1988 12:00:00 AM | 14 | 4x4 | Permit Number 25642 | 6007783.42095653 | 2101534.76819168 | 37.7508539880545 | -122.415920085137 | (37.7508539880545, -122.415920085137) | 2 | 4 | 7 | 28859 | 19 |
95460 | 118310 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 990 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||
166334 | 45756 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1395 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2001 12:00:00 AM | Permit Number 44403 | 6003940.26983915 | 2100157.37260664 | 37.7468551666159 | -122.429111856365 | (37.7468551666159, -122.429111856365) | 2 | 7 | 5 | 63 | 22 | |||
50289 | 97454 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 758 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2011 12:00:00 AM | 3 | 3x3 | 6007159.12761 | 2121599.09194 | 37.8059106699013 | -122.419502281419 | (37.8059106699013, -122.419502281419) | 5 | 1 | 1 | 28858 | 32 | |
133779 | 41232 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3721 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51879 | 6002533.18198 | 2121382.3124 | 37.8050538066511 | -122.4354955486 | (37.8050538066511, -122.4354955486) | 13 | 9 | 1 | 57 | 17 | |
39560 | 32490 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 26 Uranus Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 5 | Permit Number 36996 | 5999294.82707 | 2105565.3001 | 37.7614399465063 | -122.445564118098 | (37.7614399465063, -122.445564118098) | 15 | 5 | 5 | 28862 | 3 | |
115343 | 32489 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 26 Uranus Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | Permit Number 36996 | 5999299.5495957 | 2105598.47960948 | 37.7615313187924 | -122.445550170873 | (37.7615313187924, -122.445550170873) | 15 | 5 | 5 | 28862 | 3 | ||
91490 | 32412 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 557 Congo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | Permit Number 36944 | 6000089.06506058 | 2095518.18439448 | 37.7338982944093 | -122.442095971095 | (37.7338982944093, -122.442095971095) | 9 | 7 | 4 | 63 | 40 | |||
119502 | 32411 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 557 Congo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | Permit Number 36944 | 6000089.06506058 | 2095518.18439448 | 37.7338982944093 | -122.442095971095 | (37.7338982944093, -122.442095971095) | 9 | 7 | 4 | 63 | 40 | |||
139923 | 32416 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1923 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/1996 12:00:00 AM | Permit Number 36946 | 6000134.72597959 | 2092799.5506529 | 37.7264361591854 | -122.441743063058 | (37.7264361591854, -122.441743063058) | 9 | 7 | 6 | 28861 | 25 | ||
33772 | 60306 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1731 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/1982 12:00:00 AM | 6 | Permit Number 19876 | 5999539.5651 | 2110487.8324 | 37.7749699505091 | -122.445071570973 | (37.7749699505091, -122.445071570973) | 15 | 5 | 11 | 29492 | 16 | ||
163250 | 86756 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3630 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49737 | 6005363 | 2105488 | 37.7615722645382 | -122.424571307751 | (37.7615722645382, -122.424571307751) | 8 | 4 | 5 | 28859 | 19 | |||
178022 | 83014 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 815 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49726 | 5994400.44945449 | 2090555.08730476 | 37.7199450051039 | -122.461403423134 | (37.7199450051039, -122.461403423134) | 9 | 8 | 6 | 28861 | 24 | ||
39118 | 32369 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 858 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | 6 | Permit Number 36919 | 6008860.83914 | 2119402.12264 | 37.7999740436362 | -122.413457749072 | (37.7999740436362, -122.413457749072) | 3 | 1 | 10 | 308 | 32 | ||
186467 | 48734 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 112 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2002 12:00:00 AM | Permit Number 46014 | 6001443.50423179 | 2107544.90678437 | 37.7669978945619 | -122.438274574244 | (37.7669978945619, -122.438274574244) | 15 | 5 | 5 | 28862 | 3 | |||
136347 | 48569 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45988 | 5992993.59423207 | 2088277.32681995 | 37.7136097512741 | -122.466100961633 | (37.7136097512741, -122.466100961633) | 9 | 8 | 6 | 64 | 24 | ||
91611 | 65941 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 665 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2000 12:00:00 AM | Permit Number 28962 | 6007255.62038472 | 2113291.4844342 | 37.7831054816789 | -122.418578871955 | (37.7831054816789, -122.418578871955) | 7 | 9 | 9 | 28852 | 36 | ||
144113 | 65307 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3519 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1989 12:00:00 AM | Permit Number 28126 | 6006135.4691914 | 2104900.791717 | 37.7600035225776 | -122.421857935906 | (37.7600035225776, -122.421857935906) | 2 | 4 | 5 | 28859 | 19 |
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) );