3,267 rows where qSpecies_id = 67

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)
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
184 204541 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 400x Marietta Dr 4 Median : Cutout Tree DPW 1     16 Width 3ft   5999538.51913 2097033.8732 37.7380286277303 -122.444108242518 (37.7380286277303, -122.444108242518) 9 7 4 59 40
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
336 189035 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 50 Russ St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010091.10409 2111787.20644 37.7791343146469 -122.408663052281 (37.7791343146469, -122.408663052281) 14 2 9 28853 34
439 8729 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3200 Geary Blvd 9 Median : Cutout Tree DPW 1     6 M6   5997259.3218258 2113018.202003 37.7817872731337 -122.453142084637 (37.7817872731337, -122.453142084637) 15 6 1 54 31
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
800 43502 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 401 Gates St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/2000 12:00:00 AM     Permit Number 43180 6008272.42807324 2096955.00828501 37.7383064636933 -122.413905114955 (37.7383064636933, -122.413905114955) 2 7 7 28859 2
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
1234 74480 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 4045 Kirkham St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5982259.5223 2104870.2558 37.7585442772343 -122.504429677037 (37.7585442772343, -122.504429677037) 1 8 3 56 35
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
1578 10783 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1200X Hudson Ave 6 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
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
1799 125860 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2130 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6007669.37183 2119725.10958 37.8007939141569 -122.417603593144 (37.8007939141569, -122.417603593144) 5 1 1 308 32
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
2387 204545 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 300x Marietta Dr 73 Median : Cutout Tree DPW 1     15 Width 3ft   5999723.14356 2097244.03838 37.7386162222515 -122.44348499884 (37.7386162222515, -122.44348499884) 9 7 4 59 40
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
2685 264708 Private 9 Callistemon citrinus :: Lemon Bottlebrush 67 4345 Clement St 4 Sidewalk: Property side : Cutout Tree Private 2   09/17/2020 12:00:00 AM 3     5982064.28374 2113052.50483 37.7809988756405 -122.505711450059 (37.7809988756405, -122.505711450059) 11 6 2 55 26
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
3122 74788 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 4045 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5982233.8553 2104870.2558 37.758542767533 -122.504518443568 (37.758542767533, -122.504518443568) 1 8 3 56 35
3452 74635 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 4045 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5982248.2166 2104869.6447 37.7585419343481 -122.504468731299 (37.7585419343481, -122.504468731299) 1 8 3 56 35
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
3736 38554 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1791 La Salle Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 6   Permit Number 40521 6014548.21389 2096859.31136 37.7383941607708 -122.392199668106 (37.7383941607708, -122.392199668106) 10 3 8 58 1
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
4132 78489 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3345 Ocean Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5988664.39778 2095197.91873 37.7323612287764 -122.481570599508 (37.7323612287764, -122.481570599508) 1 8 4 64 35
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
4183 204530 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 400x Marietta Dr 28 Median : Cutout Tree DPW 1     9 Width 3ft   5999185.819 2097019.37186 37.7379686834 -122.445326654823 (37.7379686834, -122.445326654823) 9 7 4 59 40
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
4862 113857 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1201 SAN BRUNO AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011184 2102716 37.7542879873687 -122.40424363426 (37.7542879873687, -122.40424363426) 10 4 8 28859 19
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
5040 138039 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1 Wilmot St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6003372.0036 2115027.1902 37.7876518850973 -122.432138591007 (37.7876518850973, -122.432138591007) 13 9 11 29490 27
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
5340 247013 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 500 Valley St 3 : Tree Private 2     14 Width 3ft   6002616.04169 2099183.02337 37.7441047811073 -122.433621285011 (37.7441047811073, -122.433621285011) 2 7 5 63 22
5346 125748 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1830 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6004242.00992 2118405.50242 37.7969771599227 -122.429369541272 (37.7969771599227, -122.429369541272) 13 9 1 57 17
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
6227 77210 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 17 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 5 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
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
6350 117651 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 5101 Anza St 2 Sidewalk: Property side : Yard Tree Private 2     6 Width 8ft   5982808.62425 2111663.85148 37.77722982032 -122.503033613638 (37.77722982032, -122.503033613638) 11 6 2 55 26
6657 142247 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 521 Laguna St 3 Sidewalk: Curb side : Pot Tree Private 2     10 Width 0ft   6004975.0608 2110846.6753 37.7762639813435 -122.426294566563 (37.7762639813435, -122.426294566563) 7 9 11 28852 10
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
6663 205779 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 451 Hearst Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5998302.15103 2094370.64521 37.7306454275301 -122.448191246446 (37.7306454275301, -122.448191246446) 9 7 4 28861 40
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
6802 188921 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2001 25th St 16 Sidewalk: Property side : Yard Tree Private 2     6 Width 8ft   6012543.15348 2101838.55647 37.751954571155 -122.399481710736 (37.751954571155, -122.399481710736) 10 3 8 28856 29
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
6979 42994 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 500 Yale St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM     Permit Number 42870 6007553.67502493 2091408.33369541 37.7230361052022 -122.415997529963 (37.7230361052022, -122.415997529963) 9 3 7 309 28
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
7254 204421 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1890 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5993170.3661 2102643.88053 37.7530669363127 -122.466533561676 (37.7530669363127, -122.466533561676) 1 8 4 56 12
7365 125750 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2870 Filbert St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   5999187.17827 2118395.44877 37.7966620797435 -122.446859678745 (37.7966620797435, -122.446859678745) 13 9 1 57 17
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
7441 101155 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1400X 19th St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6013491.9 2105242.3 37.7613533485104 -122.396439344349 (37.7613533485104, -122.396439344349) 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
7617 246440 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 485 Duncan St 2 Front Yard : Yard Tree Private 2     12     6003368.11948 2099777.56573 37.745779900623 -122.431063194026 (37.745779900623, -122.431063194026) 2 7 5 63 22
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
7780 8836 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 4000 Geary Blvd 5 Median : Cutout Tree DPW 1     6 M6   5994660.7719396 2112852.5225639 37.7811830898725 -122.462119766821 (37.7811830898725, -122.462119766821) 11 6 2 54 11
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
8239 259577 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 300 Public Park 3 Unaccepted Street : Cutout Tree Private 2       4x4   5994278 2098760 37.7424666368704 -122.462421492412 (37.7424666368704, -122.462421492412) 1 8 4 59 40
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
8871 72911 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1970 Scott St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6001491.2891 2115220.1537 37.7880749043224 -122.438659315373 (37.7880749043224, -122.438659315373) 13 6 1 29490 27
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
9270 97907 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2000 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/18/1994 12:00:00 AM 8   Permit Number 33440 6002166.03814 2119855.12291 37.8008396887472 -122.436656706436 (37.8008396887472, -122.436656706436) 13 9 1 57 17
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
9504 74038 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1501 25th St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6014092.75077 2101968.09189 37.7523964980076 -122.394132008099 (37.7523964980076, -122.394132008099) 10 3 8 28856 1
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
9709 31362 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2295 17th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1995 12:00:00 AM 4   Permit Number 34969 5991015.94012 2099809.33155 37.7451594448661 -122.47377714392 (37.7451594448661, -122.47377714392) 1 8 4 29491 40
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

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