3,267 rows where qSpecies_id = 67 sorted by SiteOrder

View and edit SQL

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)
46292 104895 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 300 Gonzalez Dr   Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
128751 104793 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 700 39th Ave   Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5983853.59876 2111004.1266 37.7754797710072 -122.499370005427 (37.7754797710072, -122.499370005427) 11 6 2 55 26
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
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
156 222165 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 953 Elizabeth St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6000303.11526 2101951.8939 37.7515759277946 -122.441817532557 (37.7515759277946, -122.441817532557) 2 4 5 28862 22
188 112351 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 150 WEST PORTAL AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992711 2097652 37.7393339885882 -122.467759098278 (37.7393339885882, -122.467759098278) 1 8 4 59 40
298 107634 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 2431 24TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6011247.3 2102253.3 37.7530210518745 -122.403992166267 (37.7530210518745, -122.403992166267) 10 4 8 28859 19
734 222353 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3955 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6003457.00002 2101830.55749 37.7514219719536 -122.430902348489 (37.7514219719536, -122.430902348489) 2 4 5 28862 22
735 3444 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 22 Cameo Way 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3X3   5999501.27167 2099733.24754 37.745438339922 -122.444430966918 (37.745438339922, -122.444430966918) 2 7 5 63 22
1094 124411 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3906 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   5996074.1747 2115241.80305 37.7878246921221 -122.457403032995 (37.7878246921221, -122.457403032995) 11 6 1 54 31
1434 125812 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2211 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6000306.85222 2116323.62174 37.7910372888869 -122.442836516603 (37.7910372888869, -122.442836516603) 13 6 1 29490 27
1438 120859 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 555 19th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5989992.43451 2111575.4772 37.7774067879824 -122.478176324225 (37.7774067879824, -122.478176324225) 11 6 2 55 26
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
1545 137630 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2121 TURK BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5999789.9401 2111899.6185 37.7788606415974 -122.444306949553 (37.7788606415974, -122.444306949553) 15 5 11 29490 16
1671 220925 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 125 Bradford St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6009567.35719 2097865.4077 37.7408788634607 -122.409492102185 (37.7408788634607, -122.409492102185) 10 7 7 28859 2
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
2414 204512 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 38 Cresta Vista Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5995329.78004 2096137.76725 37.7353271425384 -122.458594991475 (37.7353271425384, -122.458594991475) 9 7 4 59 40
2579 125775 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3464 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5998240.44426 2115543.88697 37.7887783214189 -122.449929958814 (37.7887783214189, -122.449929958814) 13 6 1 54 31
2877 79593 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2407 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5988231.6107 2107115.9609 37.7650598247176 -122.483940431534 (37.7650598247176, -122.483940431534) 1 8 3 56 35
2891 220908 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 66 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007960.76184 2098335.3804 37.7420791526193 -122.415080385967 (37.7420791526193, -122.415080385967) 2 7 7 28859 2
3051 8716 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3140 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5997420.69043 2113059.93694 37.7819111134077 -122.452586840538 (37.7819111134077, -122.452586840538) 15 6 1 54 31
3111 222393 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 350 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6001119.04833 2104333.07424 37.7581605318006 -122.439166588377 (37.7581605318006, -122.439166588377) 2 4 5 28862 38
3483 222342 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 811 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002470.60136 2103452.27947 37.7558188950535 -122.434429365416 (37.7558188950535, -122.434429365416) 2 4 5 28862 22
3512 220863 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1307 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6003915.30602 2100633.09748 37.7481599834061 -122.4292320952 (37.7481599834061, -122.4292320952) 2 4 5 63 22
3642 41464 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 51 Sweeny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/06/2000 12:00:00 AM 6   Permit Number 42049 6010232.6367 2095048.38707 37.7331811829475 -122.406993296305 (37.7331811829475, -122.406993296305) 10 3 7 309 28
3672 4229 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3987 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003999.73105 2100398.02374 37.7475193045808 -122.428923399303 (37.7475193045808, -122.428923399303) 2 4 5 63 22
3826 78400 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 735 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5986604.8504 2110908.229 37.7753774919681 -122.489845844887 (37.7753774919681, -122.489845844887) 11 6 2 55 26
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
4092 222361 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 479 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6003292.98351 2102700.7202 37.7538019387158 -122.431531651787 (37.7538019387158, -122.431531651787) 2 4 5 28862 22
4122 3443 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 21 Cameo Way 1 Sidewalk: Curb side : Cutout Tree DPW 1     9 3X3   5999529.74191 2099788.84654 37.7455926257913 -122.444336516539 (37.7455926257913, -122.444336516539) 2 7 5 63 22
4178 31221 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 766 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/1995 12:00:00 AM     Permit Number 34908 5981084.03491617 2110503.52214182 37.7739423822297 -122.508913237037 (37.7739423822297, -122.508913237037) 11 6 2 55 26
4199 78379 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 35 Russia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6001615.3363 2090906.3588 37.7213221342777 -122.436489223015 (37.7213221342777, -122.436489223015) 9 7 6 28861 5
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
4453 5218 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 923 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 2X3   6001447.2358 2111647.0619 37.7782615998219 -122.438555619005 (37.7782615998219, -122.438555619005) 15 5 11 29490 41
4569 104897 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 303 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
4981 205652 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1775 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5990895.94718 2103333.51095 37.7548289707846 -122.474449189277 (37.7548289707846, -122.474449189277) 1 8 4 56 12
5075 125815 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2081 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6003051.46393 2118195.99672 37.7963344369473 -122.433474132552 (37.7963344369473, -122.433474132552) 13 9 1 57 17
5159 83758 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1640 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6013046.15855 2104759.52511 37.7600029395994 -122.397947120176 (37.7600029395994, -122.397947120176) 10 3 8 28856 29
5308 30814 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 145 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/1995 12:00:00 AM 8   Permit Number 34676 6001106.90976 2094917.71442 37.7323074960919 -122.438533971982 (37.7323074960919, -122.438533971982) 9 7 4 63 40
5466 90663 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3600X Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2008 12:00:00 AM 3 3x3   5984396.70061 2110421.43862 37.7739117254104 -122.497448288038 (37.7739117254104, -122.497448288038) 11 6 2 55 26
5655 222285 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 490X Ogden Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   6008298.67066 2096058.40427 37.7358460585503 -122.413750978428 (37.7358460585503, -122.413750978428) 2 7 7 28859 2
5826 78490 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3345 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5988631.47552 2095196.82107 37.7323563004975 -122.481684337683 (37.7323563004975, -122.481684337683) 1 8 4 64 35
5949 222255 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 105 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6008701 2098012 37.7412327917956 -122.412498013553 (37.7412327917956, -122.412498013553) 10 7 7 28859 2
6333 189017 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1715 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014919.07097 2096583.11887 37.7376563776397 -122.390898117058 (37.7376563776397, -122.390898117058) 10 3 8 58 1
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
6938 182118 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2469 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5987956.2603 2098511.3982 37.7414179765176 -122.484261685541 (37.7414179765176, -122.484261685541) 1 8 3 29491 35
6980 43621 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 2095 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2000 12:00:00 AM     Permit Number 43271 5985386.76911027 2100967.4929928 37.7480118028434 -122.493326874686 (37.7480118028434, -122.493326874686) 1 8 3 29491 35
7027 42067 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 201 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42379 6006853.95284376 2097931.35899667 37.7409075395301 -122.418878742158 (37.7409075395301, -122.418878742158) 2 7 7 28859 2
7079 120113 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 266 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999649 2094406 37.7308194078275 -122.443537538611 (37.7308194078275, -122.443537538611) 9 7 4 63 40
7081 199881 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1411 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6015892.5426 2093410.4263 37.7289987677543 -122.387311077708 (37.7289987677543, -122.387311077708) 10 3 8 58 1
7440 78070 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 818 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6011825.39206 2104537.71061 37.7593258220597 -122.402153592937 (37.7593258220597, -122.402153592937) 10 3 8 28856 29
7445 205695 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2236 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5990740.52284 2100154.10993 37.7460901613437 -122.47475463951 (37.7460901613437, -122.47475463951) 1 8 4 29491 40
7526 54915 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 491 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/16/1972 12:00:00 AM 10   Permit Number 10781 6011237.02996 2106095.07508 37.7635691382211 -122.404298060519 (37.7635691382211, -122.404298060519) 8 3 8 28856 29
7645 56389 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1338 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/17/1973 12:00:00 AM 14   Permit Number 12542 6016160.8061 2092941.1028 37.7277249515347 -122.386350953513 (37.7277249515347, -122.386350953513) 10 3 8 58 1
7769 199923 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1398 Hawes St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6017238.3952 2092867.7981 37.7275832604461 -122.382620574427 (37.7275832604461, -122.382620574427) 10 3 8 58 1
7905 222279 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 21 Mirabel Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   6007396.88355 2099878.3097 37.7462839877321 -122.417139408955 (37.7462839877321, -122.417139408955) 2 7 7 28859 2
8129 222155 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 4655 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6000428.56832 2101076.36707 37.7491790897485 -122.441320886466 (37.7491790897485, -122.441320886466) 2 4 5 28862 22
8344 205728 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 395 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5992226.12034 2094297.28733 37.7300947798476 -122.469191482823 (37.7300947798476, -122.469191482823) 9 8 4 59 40
8485 222292 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 81 Bernal Heights Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009524.51144 2098228.50014 37.7418734354045 -122.409665869203 (37.7418734354045, -122.409665869203) 10 7 7 28859 2
8568 181638 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2520 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5987970.1096 2106478.8633 37.7632953023912 -122.484798147384 (37.7632953023912, -122.484798147384) 1 8 3 56 35
8685 10038 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 360 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005474.31982 2106984.12162 37.7656865461171 -122.424292710045 (37.7656865461171, -122.424292710045) 8 4 5 28853 19
8725 60817 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1150 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/28/1983 12:00:00 AM 3   Permit Number 20495 5989806.3915 2101102.4889 37.7486399870467 -122.478054033081 (37.7486399870467, -122.478054033081) 1 8 3 29491 35
8896 56726 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1523 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16   Permit Number 769408 6015773.2097 2095596.9346 37.7349958716637 -122.387876131204 (37.7349958716637, -122.387876131204) 10 3 8 58 1
9044 222431 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 32 Ord St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6000820.71803 2106159.36126 37.7631580877986 -122.440329312863 (37.7631580877986, -122.440329312863) 15 5 5 28862 3
9250 70168 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 5129 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5982718.93125 2111668.17193 37.7772364107813 -122.503344205234 (37.7772364107813, -122.503344205234) 11 6 2 55 26
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
9642 53732 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 145 Topeka Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/1972 12:00:00 AM 11 3x3 Permit Number 9411 6012636.58641 2095202.58654 37.7337388121015 -122.398692955821 (37.7337388121015, -122.398692955821) 10 3 8 58 1
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
9787 222356 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3719 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6003591.29083 2103007.33829 37.7546607427065 -122.43052191368 (37.7546607427065, -122.43052191368) 2 4 5 28862 22
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
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
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
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
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
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
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
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
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
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
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);