Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▲ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
71510 | 71510 | 77210 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 5 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
72481 | 72481 | 42343 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
76344 | 76344 | 77198 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 3 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
86065 | 86065 | 42350 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
90442 | 90442 | 42345 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
91332 | 91332 | 77217 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
92098 | 92098 | 42366 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 250 Foerster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
92789 | 92789 | 77219 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
93542 | 93542 | 42354 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
93801 | 93801 | 77212 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
94089 | 94089 | 42360 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
100102 | 100102 | 42349 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
100207 | 100207 | 77211 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 8 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
103741 | 103741 | 77204 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 6 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
105224 | 105224 | 42352 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
109486 | 109486 | 77207 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 5 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
111991 | 111991 | 42361 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 250 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
114618 | 114618 | 42365 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 250 Foerster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
114830 | 114830 | 96210 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 201X Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/28/2012 12:00:00 AM | 3 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.43696480408701 | (37.759113460692, -122.436964804087) | |
120818 | 120818 | 42357 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 3 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
121322 | 121322 | 42347 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
121470 | 121470 | 42369 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 250 Foerster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
122117 | 122117 | 42367 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 250 Foerster St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
123050 | 123050 | 77206 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
123438 | 123438 | 42348 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 3 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
139199 | 139199 | 77209 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 5 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
140146 | 140146 | 42356 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
144409 | 144409 | 42358 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 4x4 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
4369 | 4369 | 222216 | Planning Code 138.1 required 4 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2 Van Buren St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 3ft | Permit Number 780743 | 6002014.89564 | 2096488.79408 | 37.7366729276156 | -122.435507211887 | (37.7366729276156, -122.435507211887) | ||
5803 | 5803 | 22598 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 835 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005965.95079 | 2112761.85116 | 37.7815785478641 | -122.42300295452401 | (37.7815785478641, -122.423002954524) | |||
5932 | 5932 | 22599 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 835 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005992.6226 | 2112765.71653 | 37.7815906662302 | -122.422910957475 | (37.7815906662302, -122.422910957475) | |||
6417 | 6417 | 18979 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2916 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000692.61661 | 2115558.6800700002 | 37.7889589430353 | -122.4414468761 | (37.7889589430353, -122.4414468761) | |||
8444 | 8444 | 13167 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1906 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 26 | 3X3 | 6003216.0169 | 2119655.6641 | 37.8003516396791 | -122.433009083838 | (37.8003516396791, -122.433009083838) | ||
10927 | 10927 | 24271 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001388.30533 | 2086462.2685599998 | 37.70910674815379 | -122.436956008017 | (37.7091067481538, -122.436956008017) | |||
11032 | 11032 | 24272 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001382.61488 | 2086464.9875900003 | 37.7091138905754 | -122.43697586956301 | (37.7091138905754, -122.436975869563) | |||
11289 | 11289 | 24269 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001399.20674 | 2086458.92155 | 37.7090981776115 | -122.43691809171999 | (37.7090981776115, -122.43691809172) | |||
13019 | 13019 | 24270 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001396.0736 | 2086458.9864 | 37.709098177596005 | -122.436928924942 | (37.709098177596, -122.436928924942) | |||
13540 | 13540 | 27121 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2335 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2002 12:00:00 AM | 12 | 2x2 | 6013101.69827 | 2096426.31583 | 37.7371248216631 | -122.39717069499599 | (37.7371248216631, -122.397170694996) | ||
13724 | 13724 | 4898 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017985.0017 | 2094485.55993 | 37.7320665362465 | -122.380151894906 | (37.7320665362465, -122.380151894906) | |||
14242 | 14242 | 10905 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1336 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6017099.8174 | 2095796.95321 | 37.735618485109995 | -122.38330345120899 | (37.73561848511, -122.383303451209) | |||
14360 | 14360 | 5802 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 218X Cashmere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6016122.2563 | 2096227.4462099997 | 37.736746459772604 | -122.386713296401 | (37.7367464597726, -122.386713296401) | |||
15093 | 15093 | 5801 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 218X Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6016115.70396 | 2096246.37508 | 37.736798071860704 | -122.386737270517 | (37.7367980718607, -122.386737270517) | |||
16623 | 16623 | 4897 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018099.28954 | 2094405.0263599998 | 37.731851711585996 | -122.37975117949 | (37.731851711586, -122.37975117949) | |||
16806 | 16806 | 29053 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 340 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008751.0689900005 | 2108844.78645 | 37.770979979973 | -122.413090685387 | (37.770979979973, -122.413090685387) | ||
16821 | 16821 | 7409 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1074 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6010471.6875 | 2111110.7430000002 | 37.7772982123977 | -122.40729875221399 | (37.7772982123977, -122.407298752214) | |||
16917 | 16917 | 3443 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 21 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 5999529.741909999 | 2099788.8465400003 | 37.745592625791296 | -122.444336516539 | (37.7455926257913, -122.444336516539) | |||
16979 | 16979 | 10038 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 360 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005474.31982 | 2106984.12162 | 37.7656865461171 | -122.424292710045 | (37.7656865461171, -122.424292710045) | |||
17023 | 17023 | 4229 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3987 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003999.73105 | 2100398.02374 | 37.7475193045808 | -122.428923399303 | (37.7475193045808, -122.428923399303) | |||
17287 | 17287 | 4230 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3987 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004020.01969 | 2100398.84161 | 37.7475226986238 | -122.42885330076099 | (37.7475226986238, -122.428853300761) | |||
17685 | 17685 | 1341 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 172 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5999321.34336 | 2099380.66579 | 37.7444599674701 | -122.44502778580299 | (37.7444599674701, -122.445027785803) | |||
17737 | 17737 | 4853 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6000632.86051 | 2098307.8213299997 | 37.7415889582704 | -122.440415912169 | (37.7415889582704, -122.440415912169) | |||
18279 | 18279 | 4484 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1566 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1990 12:00:00 AM | 12 | 3X3 | 6004549.88502 | 2099732.13285 | 37.7457220463542 | -122.42697358187701 | (37.7457220463542, -122.426973581877) | ||
18431 | 18431 | 1350 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 261 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 5999733.43875 | 2099278.43357 | 37.7442027739306 | -122.443595506633 | (37.7442027739306, -122.443595506633) | |||
18490 | 18490 | 90663 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3600X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984396.70061 | 2110421.43862 | 37.7739117254104 | -122.497448288038 | (37.7739117254104, -122.497448288038) | ||
18712 | 18712 | 10788 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1200X Hudson Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | |||
18988 | 18988 | 16343 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996035.52811 | 2094660.72414 | 37.7313120760949 | -122.456048222959 | (37.7313120760949, -122.456048222959) | ||
19627 | 19627 | 16344 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996005.09349 | 2094651.8098799998 | 37.7312858527477 | -122.45615279610901 | (37.7312858527477, -122.456152796109) | ||
19703 | 19703 | 16350 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/23/1998 12:00:00 AM | 3 | 5 | 5995968.77487 | 2094643.75333 | 37.731261646602995 | -122.45627777310601 | (37.731261646603, -122.456277773106) | ||
19869 | 19869 | 1340 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 157 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5999318.51798 | 2099488.255 | 37.7447552202944 | -122.445045288424 | (37.7447552202944, -122.445045288424) | |||
19999 | 19999 | 1998 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 213 Bocana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6007163.78515 | 2097749.92103 | 37.7404267922562 | -122.41779459653799 | (37.7404267922562, -122.417794596538) | |||
20092 | 20092 | 24477 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 94 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/23/2011 12:00:00 AM | 3 | 3x3 | 6002318.918930001 | 2096714.27726 | 37.7373093148834 | -122.43447219024401 | (37.7373093148834, -122.434472190244) | ||
20148 | 20148 | 17245 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 501 Ortega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3 | 5992555.1394 | 2103055.38176 | 37.754161290716205 | -122.468691056856 | (37.7541612907162, -122.468691056856) | |||
20227 | 20227 | 4881 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 83 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2X2 | 6000907.7136 | 2097921.62837 | 37.74054420955 | -122.439437888659 | (37.74054420955, -122.439437888659) | |||
20471 | 20471 | 8716 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3140 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5997420.69043 | 2113059.93694 | 37.7819111134077 | -122.452586840538 | (37.7819111134077, -122.452586840538) | |||
20560 | 20560 | 22807 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 16 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/1991 12:00:00 AM | 12 | 2X2 | 5998909.64995 | 2099772.3846 | 37.745512026751896 | -122.446479507446 | (37.7455120267519, -122.446479507446) | ||
21275 | 21275 | 5112 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2711 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 4X4 | 6002382.81986 | 2096188.0405700002 | 37.7358680173011 | -122.434213645952 | (37.7358680173011, -122.434213645952) | |||
21448 | 21448 | 5058 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5521 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001859.76299 | 2097506.95056 | 37.739459736871204 | -122.436116409072 | (37.7394597368712, -122.436116409072) | |||
21696 | 21696 | 10044 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 360 Guerrero St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005474.87318 | 2106843.21233 | 37.7652996739685 | -122.424280773353 | (37.7652996739685, -122.424280773353) | |||
21714 | 21714 | 26062 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 236 Broad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5994603.6211 | 2088111.4430000002 | 37.71324702988721 | -122.460524155594 | (37.7132470298872, -122.460524155594) | |||
21784 | 21784 | 10043 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 360 Guerrero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005477.51423 | 2106859.7680900004 | 37.765345281278 | -122.424272816157 | (37.765345281278, -122.424272816157) | |||
21834 | 21834 | 4871 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 48 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6000859.63404 | 2098067.6041 | 37.7409422881585 | -122.43961459104901 | (37.7409422881585, -122.439614591049) | |||
22253 | 22253 | 4256 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4082 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003396.9856199995 | 2100411.62921 | 37.7475225268465 | -122.431008624962 | (37.7475225268465, -122.431008624962) | |||
22386 | 22386 | 9093 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989210.8329 | 2112629.8539 | 37.78025641160821 | -122.48095732694999 | (37.7802564116082, -122.48095732695) | |||
22392 | 22392 | 9015 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990451.7846 | 2112676.0938 | 37.780455430166704 | -122.47666772777599 | (37.7804554301667, -122.476667727776) | |||
22394 | 22394 | 9094 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989203.8431 | 2112625.0148 | 37.7802427184836 | -122.48098115319901 | (37.7802427184836, -122.480981153199) | |||
22395 | 22395 | 9019 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 3 | 8M | 5990422.2126 | 2112674.4808 | 37.780449286015 | -122.476769912257 | (37.780449286015, -122.476769912257) | ||
22396 | 22396 | 21529 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6006199.49469 | 2114932.42153 | 37.7875515759816 | -122.42234927152799 | (37.7875515759816, -122.422349271528) | |||
22405 | 22405 | 9178 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987973.0454 | 2112592.9065 | 37.7800829358976 | -122.485236638901 | (37.7800829358976, -122.485236638901) | |||
22408 | 22408 | 21538 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1350 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006090.48396 | 2114915.1534700003 | 37.787498012379 | -122.42272519983 | (37.787498012379, -122.42272519983) | |||
22427 | 22427 | 9095 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989203.3055 | 2112634.6929 | 37.780269260588604 | -122.480983721798 | (37.7802692605886, -122.480983721798) | |||
22433 | 22433 | 9091 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989224.2748 | 2112631.4669 | 37.7802616218044 | -122.48091094389 | (37.7802616218044, -122.48091094389) | |||
22441 | 22441 | 9219 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987356.9662 | 2112573.6226 | 37.779994079355895 | -122.487366491184 | (37.7799940793559, -122.487366491184) | |||
22462 | 22462 | 9179 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987967.3441 | 2112595.2541 | 37.7800890496186 | -122.48525653433799 | (37.7800890496186, -122.485256534338) | |||
22464 | 22464 | 9180 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987967.6795 | 2112585.8637 | 37.7800632857697 | -122.485254684827 | (37.7800632857697, -122.485254684827) | |||
22465 | 22465 | 9099 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989192.0143 | 2112627.1655 | 37.780247936097396 | -122.481022231507 | (37.7802479360974, -122.481022231507) | |||
22471 | 22471 | 9181 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987959.6305 | 2112590.5589 | 37.7800757085683 | -122.485282874223 | (37.7800757085683, -122.485282874223) | |||
22497 | 22497 | 9218 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987387.1497 | 2112575.6349 | 37.78000136471471 | -122.48726222211799 | (37.7800013647147, -122.487262222118) | |||
22507 | 22507 | 9049 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5500 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989816.2539 | 2112654.318 | 37.7803587568757 | -122.478864709732 | (37.7803587568757, -122.478864709732) | |||
22524 | 22524 | 9096 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989196.3157 | 2112631.4669 | 37.78025999658 | -122.48100766619 | (37.78025999658, -122.48100766619) | |||
22529 | 22529 | 9177 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987977.7406 | 2112589.2174 | 37.7800730801841 | -122.485220125518 | (37.7800730801841, -122.485220125518) | |||
22540 | 22540 | 9014 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990456.086 | 2112679.8576 | 37.7804660140104 | -122.476653122424 | (37.7804660140104, -122.476653122424) | |||
22541 | 22541 | 9137 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5900 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5988584.9325 | 2112610.849 | 37.7801678269123 | -122.48312118538799 | (37.7801678269123, -122.483121185388) | |||
22544 | 22544 | 9217 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987387.8205 | 2112562.8907 | 37.77996641187121 | -122.487258965224 | (37.7799664118712, -122.487258965224) | |||
22548 | 22548 | 9215 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987407.9428 | 2112568.2567 | 37.779982318766706 | -122.48718974831999 | (37.7799823187667, -122.48718974832) | |||
22573 | 22573 | 9017 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990440.4935 | 2112674.4808 | 37.780450346394794 | -122.476706670705 | (37.7804503463948, -122.476706670705) | |||
22584 | 22584 | 9016 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990445.3325 | 2112679.3199 | 37.7804639139017 | -122.476690284152 | (37.7804639139017, -122.476690284152) | |||
22612 | 22612 | 9018 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990428.6646 | 2112675.0185 | 37.7804511366409 | -122.476747631291 | (37.7804511366409, -122.476747631291) | |||
22637 | 22637 | 9140 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5900 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5988567.4931 | 2112610.849 | 37.7801668120621 | -122.48318151551001 | (37.7801668120621, -122.48318151551) | |||
22654 | 22654 | 21537 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1350 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006105.21197 | 2114916.89235 | 37.787503617856295 | -122.42267436743299 | (37.7875036178563, -122.422674367433) | |||
22655 | 22655 | 9184 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987942.8619 | 2112587.5406 | 37.7800664442915 | -122.485340662126 | (37.7800664442915, -122.485340662126) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");