trees
3,267 rows where qSpecies_id = 67
This data as json, CSV (advanced)
rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );