trees
3,267 rows where qSpecies_id = 67 sorted by qCaretaker_id descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id ▲ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
15793 | 42348 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 7 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 3 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
23669 | 42343 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
37151 | 77198 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 3 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
72021 | 42345 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
72982 | 42350 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
76451 | 77217 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
81932 | 42360 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
82359 | 42366 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 250 Foerster St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
82711 | 42354 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
89171 | 77219 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 23 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
90903 | 77212 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
99306 | 77204 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 6 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
99818 | 77211 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 8 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
108541 | 42349 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
115123 | 77207 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 14 | 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 | |
130186 | 42352 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
142390 | 96210 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 201X Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/28/2012 12:00:00 AM | 3 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.436964804087 | (37.759113460692, -122.436964804087) | 2 | 4 | 5 | 28862 | 3 | |
144395 | 42361 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 250 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
147728 | 42365 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 250 Foerster St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
153739 | 77206 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
154352 | 42367 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 250 Foerster St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
160859 | 42357 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 3 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
161881 | 42369 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 250 Foerster St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
162866 | 42347 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
180710 | 42358 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 4x4 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
182513 | 42356 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
186220 | 77209 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 16 | 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 | |
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 | |||
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 | |||
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 | |||
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 |
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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) );