trees
3,267 rows where qSpecies_id = 67 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );