trees

150 rows where Supervisor Districts = 7 and qSpecies_id = 53 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
191336 505 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2766X 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6010189.63609 2102250.35484 37.7529538159215 -122.407649581645 (37.7529538159215, -122.407649581645) 2 4 7 28859 19
191197 18454 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1106 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 3x3   6010521.1889393 2102709.7477141 37.7542337610764 -122.406535372627 (37.7542337610764, -122.406535372627) 10 4 7 28859 19
188189 111222 Undocumented 4 Ficus nitida :: Laurel Fig 53 3150x 19TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008324 2105048 37.7605309015758 -122.41429925401 (37.7605309015758, -122.41429925401) 2 4 7 28859 19
186502 18393 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 886 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     30 3x3   6010424.2598856 2104075.0244367 37.7579770833513 -122.406966801395 (37.7579770833513, -122.406966801395) 10 4 7 28859 19
185861 18445 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1024 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 4x4   6010473.6370906 2103261.6949103 37.7557466249525 -122.406738715199 (37.7557466249525, -122.406738715199) 10 4 7 28859 19
179971 634 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3194 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 3X3   6007781.42285 2102140.57786 37.7525172919755 -122.415969890792 (37.7525172919755, -122.415969890792) 2 4 7 28859 19
178044 48952 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3046 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/26/2002 12:00:00 AM 28   Permit Number 46137 6008657.12939462 2102169.92315078 37.7526470627455 -122.412943613067 (37.7526470627455, -122.412943613067) 2 4 7 28859 19
177969 122633 Undocumented 4 Ficus nitida :: Laurel Fig 53 260 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6006915 2105702 37.7622473847542 -122.419218743707 (37.7622473847542, -122.419218743707) 8 4 7 28859 19
173070 50573 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2295 Folsom St 10 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2003 12:00:00 AM     Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
173047 71507 Undocumented 4 Ficus nitida :: Laurel Fig 53 3100 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1988 12:00:00 AM 12     6008781.55607863 2105099.68545767 37.7606985097306 -122.412720425202 (37.7606985097306, -122.412720425202) 2 4 7 28859 19
172873 33586 Permitted Site 7 Ficus nitida :: Laurel Fig 53 248 Bonview St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2006 12:00:00 AM   3x3 Permit Number 48813 6006863.32350459 2097675.63643968 37.7402059100197 -122.418828210102 (37.7402059100197, -122.418828210102) 2 7 7 28859 2
172812 18468 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1200X Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 4X4   6010533.61703 2102196.70237 37.7528257474783 -122.406456244122 (37.7528257474783, -122.406456244122) 10 4 7 28859 19
172669 87144 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2405 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3x3 Permit Number 50131 6008226 2104427 37.7588202724984 -122.414594246502 (37.7588202724984, -122.414594246502) 2 4 7 28859 19
169697 117565 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2450 HARRISON ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     32 3x3   6008799 2104200 37.7582291576174 -122.412596493354 (37.7582291576174, -122.412596493354) 2 4 7 28859 19
169220 94550 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2851 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 6x5   6009753.55231 2102181.05227 37.7527391057434 -122.40915275887 (37.7527391057434, -122.40915275887) 2 4 7 28859 19
166088 103636 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 9 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
165793 39111 Permitted Site 7 Ficus nitida :: Laurel Fig 53 145 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM 20   Permit Number 40799 6006719.36046982 2102938.94159671 37.7546496469874 -122.41969933167 (37.7546496469874, -122.41969933167) 2 4 7 28859 19
164853 103632 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
164080 570 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2972 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6009057.78841 2102246.54845 37.7528799408325 -122.411563471864 (37.7528799408325, -122.411563471864) 2 4 7 28859 19
161467 632 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3179 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6007841.79281 2102038.51474 37.7522404437102 -122.415753894425 (37.7522404437102, -122.415753894425) 2 4 7 28859 19
160281 103637 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 10 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
159897 617 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3141X 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6008071.59955 2102085.94599 37.7523835952977 -122.414962541065 (37.7523835952977, -122.414962541065) 2 4 7 28859 19
158510 18390 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 866 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3x3   6010418.2672605 2104189.3928818 37.7582907781506 -122.406995587546 (37.7582907781506, -122.406995587546) 10 4 7 28859 19
156055 653 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3255X 24th St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     3 4x4   6007260.4251 2102038.7621 37.7522084236972 -122.417764377532 (37.7522084236972, -122.417764377532) 2 4 7 28859 19
152589 510 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2781 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6010149.8233 2102141.49518 37.7526526827318 -122.407779587097 (37.7526526827318, -122.407779587097) 2 4 7 28859 19
152427 112646 Undocumented 4 Ficus nitida :: Laurel Fig 53 3101 26TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6008718 2100791 37.7488642652044 -122.412635640211 (37.7488642652044, -122.412635640211) 2 4 7 28859 19
151621 482 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1182X Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     35 3x3   6010538.0981 2102333.37734 37.7532012773937 -122.406450377502 (37.7532012773937, -122.406450377502) 10 4 7 28859 19
151070 121123 Undocumented 4 Ficus nitida :: Laurel Fig 53 2701X 24th St 7 Sidewalk: Property side : Cutout Tree Private 2     24 3x3   6010429 2102109 37.7525790830309 -122.406811850318 (37.7525790830309, -122.406811850318) 10 4 7 28859 19
150296 100481 Undocumented 4 Ficus nitida :: Laurel Fig 53 1849 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3 Permit Number 26048 6008683 2107773 37.7680332828269 -122.413250335235 (37.7680332828269, -122.413250335235) 8 4 7 28853 19
148177 100480 Undocumented 4 Ficus nitida :: Laurel Fig 53 245 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6007080 2107899 37.7682891227663 -122.418803888241 (37.7682891227663, -122.418803888241) 8 4 7 28853 19
146667 15335 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1720 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6006691.81678 2108397.85831 37.7696370050813 -122.420181988192 (37.7696370050813, -122.420181988192) 8 4 7 28853 19
145968 45426 Permitted Site 7 Ficus nitida :: Laurel Fig 53 614 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2001 12:00:00 AM   9x9 Permit Number 44218 6008960.61704517 2105361.82717089 37.7614283394777 -122.412119658359 (37.7614283394777, -122.412119658359) 2 4 7 28859 19
145761 173892 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 24 Prospect Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007185 2099410 37.7449861923813 -122.417838888286 (37.7449861923813, -122.417838888286) 2 7 7 28859 2
145297 511 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2782 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6010123.24297 2102258.68458 37.7529729707581 -122.407879770058 (37.7529729707581, -122.407879770058) 2 4 7 28859 19
142871 18385 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 812 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 16x5   6010402.1602537 2104496.7929466 37.759133928444 -122.407072960308 (37.759133928444, -122.407072960308) 10 4 7 28859 19
142433 486 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2708 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6010515.41751 2102258.44338 37.7529942564805 -122.406523532023 (37.7529942564805, -122.406523532023) 10 4 7 28859 19
142406 111224 Undocumented 4 Ficus nitida :: Laurel Fig 53 3150x 19TH ST 7 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6008324 2105048 37.7605309015758 -122.41429925401 (37.7605309015758, -122.41429925401) 2 4 7 28859 19
141160 18451 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1082 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 4x4   6010493.0142586 2102932.3469158 37.7548433927728 -122.40664849396 (37.7548433927728, -122.40664849396) 10 4 7 28859 19
140677 68840 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1506 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/1993 12:00:00 AM     Permit Number 32793 6009553.56622839 2100554.07443475 37.7482605801949 -122.4097295193 (37.7482605801949, -122.4097295193) 2 4 7 28859 2
139905 18447 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1036 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6010477.6303584 2103193.8225196 37.7555604859056 -122.406720122129 (37.7555604859056, -122.406720122129) 10 4 7 28859 19
139754 98643 Undocumented 4 Ficus nitida :: Laurel Fig 53 2391 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6008222 2104509 37.7590452010005 -122.414613883143 (37.7590452010005, -122.414613883143) 2 4 7 28859 19
138766 635 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3198 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3x3   6007763.62302 2102126.97717 37.7524789468036 -122.416030482711 (37.7524789468036, -122.416030482711) 2 4 7 28859 19
138573 603 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3085 24th St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6008454.62539 2102106.73452 37.7524621916923 -122.413639440921 (37.7524621916923, -122.413639440921) 2 4 7 28859 19
138528 662 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3290X 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6007123.820387 2102082.126741 37.7523198047665 -122.418239853186 (37.7523198047665, -122.418239853186) 2 4 7 28859 19
137374 585 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3035 24TH ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     122 3x3   6008718 2102146 37.7525847918351 -122.412731419953 (37.7525847918351, -122.412731419953) 2 4 7 28859 19
136552 103634 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 7 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
135014 111218 Undocumented 4 Ficus nitida :: Laurel Fig 53 3150x 19TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6008324 2105048 37.7605309015758 -122.41429925401 (37.7605309015758, -122.41429925401) 2 4 7 28859 19
133761 102454 Undocumented 4 Ficus nitida :: Laurel Fig 53 3365 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007790 2104415 37.7587628183764 -122.416101290754 (37.7587628183764, -122.416101290754) 2 4 7 28859 19
133574 100482 Undocumented 4 Ficus nitida :: Laurel Fig 53 1849 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008683 2107773 37.7680332828269 -122.413250335235 (37.7680332828269, -122.413250335235) 8 4 7 28853 19
133502 583 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3032 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6008758.82346 2102183.24018 37.7526893362197 -122.412592877178 (37.7526893362197, -122.412592877178) 2 4 7 28859 19
133311 26518 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2881 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6009034.88918 2101730.9691 37.7514629908808 -122.411606237117 (37.7514629908808, -122.411606237117) 2 4 7 28859 19
133106 18462 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1170 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 3X3   6010530.25012 2102443.0228 37.7535019005095 -122.406485243092 (37.7535019005095, -122.406485243092) 10 4 7 28859 19
132675 45428 Permitted Site 7 Ficus nitida :: Laurel Fig 53 614 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2001 12:00:00 AM     Permit Number 44218 6008960.61704517 2105361.82717089 37.7614283394777 -122.412119658359 (37.7614283394777, -122.412119658359) 2 4 7 28859 19
131499 121120 Undocumented 4 Ficus nitida :: Laurel Fig 53 2701X 24th St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010429 2102109 37.7525790830309 -122.406811850318 (37.7525790830309, -122.406811850318) 10 4 7 28859 19
130738 96736 Undocumented 4 Ficus nitida :: Laurel Fig 53 520 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3.5   6007401.6 2106571.6 37.7646624959011 -122.417597409955 (37.7646624959011, -122.417597409955) 8 4 7 28859 19
129162 615 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3134X 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6008105.60803 2102127.90457 37.7525007150423 -122.414847903135 (37.7525007150423, -122.414847903135) 2 4 7 28859 19
127664 499 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2751 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/29/2017 12:00:00 AM 3 4x4 Permit Number 780031 6010232.5569 2102206.4482 37.7528356605554 -122.407498057365 (37.7528356605554, -122.407498057365) 2 4 7 28859 19
127611 618 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3141X 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6008071.59955 2102085.94599 37.7523835952977 -122.414962541065 (37.7523835952977, -122.414962541065) 2 4 7 28859 19
126549 541 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2869 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009654.44601 2102141.49288 37.752624931831 -122.409492696033 (37.752624931831, -122.409492696033) 2 4 7 28859 19
122861 103633 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 6 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
122363 116519 Undocumented 4 Ficus nitida :: Laurel Fig 53 2050 BRYANT ST 6 Sidewalk: Curb side : Cutout Tree DPW 1     32 3x3   6009415 2105202 37.7610149749795 -122.410536843727 (37.7610149749795, -122.410536843727) 2 4 7 28859 19
121805 669 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3297X 24th St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6007079.62061 2102029.84762 37.7521737701718 -122.418388996947 (37.7521737701718, -122.418388996947) 2 4 7 28859 19
121432 624 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3157 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6007970.52254 2102065.21548 37.752320993709 -122.415310615518 (37.752320993709, -122.415310615518) 2 4 7 28859 19
121361 506 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2773 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6010149.8233 2102141.49518 37.7526526827318 -122.407779587097 (37.7526526827318, -122.407779587097) 2 4 7 28859 19
120567 103630 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
119605 102455 Undocumented 4 Ficus nitida :: Laurel Fig 53 3365 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007790 2104415 37.7587628183764 -122.416101290754 (37.7587628183764, -122.416101290754) 2 4 7 28859 19
119249 648 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3244X 24th St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6007408.30918 2102098.45375 37.7523806444342 -122.417257199664 (37.7523806444342, -122.417257199664) 2 4 7 28859 19
118796 65046 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2498 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1989 12:00:00 AM 18   Permit Number 26099 6008837.93100399 2103923.47328543 37.7574720629103 -122.412442306383 (37.7574720629103, -122.412442306383) 2 4 7 28859 19
117580 100483 Undocumented 4 Ficus nitida :: Laurel Fig 53 1849 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008683 2107773 37.7680332828269 -122.413250335235 (37.7680332828269, -122.413250335235) 8 4 7 28853 19
117076 102235 Undocumented 4 Ficus nitida :: Laurel Fig 53 1104 York St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009987 2102770 37.7543693005663 -122.408386989199 (37.7543693005663, -122.408386989199) 2 4 7 28859 19
115602 550 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2899 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009498.42946 2102171.88233 37.7526996313063 -122.410034375932 (37.7526996313063, -122.410034375932) 2 4 7 28859 19
115348 50571 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2295 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/2003 12:00:00 AM     Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
112964 103629 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
111853 99974 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2295 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47188 6008194 2105070 37.7605840051662 -122.414750422926 (37.7605840051662, -122.414750422926) 2 4 7 28859 19
111614 87145 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2405 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3x3 Permit Number 50131 6008226 2104427 37.7588202724984 -122.414594246502 (37.7588202724984, -122.414594246502) 2 4 7 28859 19
110718 113188 Undocumented 4 Ficus nitida :: Laurel Fig 53 12 LUNDYS LN 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x12   6007151 2099622 37.7455663833026 -122.417971480149 (37.7455663833026, -122.417971480149) 2 7 7 28859 2
110191 111226 Undocumented 4 Ficus nitida :: Laurel Fig 53 3150x 19TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6008324 2105048 37.7605309015758 -122.41429925401 (37.7605309015758, -122.41429925401) 2 4 7 28859 19
106094 117567 Undocumented 4 Ficus nitida :: Laurel Fig 53 2498 HARRISON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6008843 2103923 37.7574710478396 -122.41242474225 (37.7574710478396, -122.41242474225) 2 4 7 28859 19
106064 121117 Undocumented 4 Ficus nitida :: Laurel Fig 53 2701X 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6010429 2102109 37.7525790830309 -122.406811850318 (37.7525790830309, -122.406811850318) 10 4 7 28859 19
103831 58284 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1528 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/1978 12:00:00 AM   4x4 Permit Number 17298 6007189.64621742 2107366.09742219 37.7668320707182 -122.418386841574 (37.7668320707182, -122.418386841574) 8 4 7 28853 19
99827 109850 Undocumented 4 Ficus nitida :: Laurel Fig 53 3250x 22ND ST 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6006518 2103190 37.7553276504831 -122.420413510616 (37.7553276504831, -122.420413510616) 2 4 7 28859 19
99014 117566 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2450 HARRISON ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     32 3x3   6008799 2104200 37.7582291576174 -122.412596493354 (37.7582291576174, -122.412596493354) 2 4 7 28859 19
97918 102451 Undocumented 4 Ficus nitida :: Laurel Fig 53 602 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007851.6 2104381.9 37.758675396701 -122.415885905109 (37.758675396701, -122.415885905109) 2 4 7 28859 19
97770 18392 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 886 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3x3   6010424.2598856 2104075.0244367 37.7579770833513 -122.406966801395 (37.7579770833513, -122.406966801395) 10 4 7 28859 19
95503 103635 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 8 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
92126 103631 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
91776 18465 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1176 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/05/2015 12:00:00 AM 45 3X4   6010529.14326 2102401.59944 37.7533880992141 -122.40648615219 (37.7533880992141, -122.40648615219) 10 4 7 28859 19
90722 56236 Permitted Site 7 Ficus nitida :: Laurel Fig 53 147 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/20/1973 12:00:00 AM 24   Permit Number 12362 6006719.97734959 2102927.77810186 37.7546190293471 -122.419696406291 (37.7546190293471, -122.419696406291) 2 4 7 28859 19
90532 490 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2734 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6010357.12636 2102291.83707 37.7530770912847 -122.407073289419 (37.7530770912847, -122.407073289419) 10 4 7 28859 19
89426 65007 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1849 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/13/1989 12:00:00 AM 18 3x3 Permit Number 26048 6008683.18209706 2107760.52572873 37.7679990416006 -122.413248823154 (37.7679990416006, -122.413248823154) 8 4 7 28853 19
86183 645 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3244X 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6007408.30918 2102098.45375 37.7523806444342 -122.417257199664 (37.7523806444342, -122.417257199664) 2 4 7 28859 19
85308 631 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3195 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6007841.79281 2102038.51474 37.7522404437102 -122.415753894425 (37.7522404437102, -122.415753894425) 2 4 7 28859 19
81588 113833 Significant Tree 6 Ficus nitida :: Laurel Fig 53 932 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30     6007966 2102301 37.7529681504442 -122.415342945464 (37.7529681504442, -122.415342945464) 2 4 7 28859 19
80775 15434 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2137 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006871.30054 2105936.92899 37.7628899837695 -122.419386550959 (37.7628899837695, -122.419386550959) 8 4 7 28859 19
80355 588 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3044 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6008688.10488 2102161.42262 37.7526254609089 -122.412835893087 (37.7526254609089, -122.412835893087) 2 4 7 28859 19
79996 96733 Undocumented 4 Ficus nitida :: Laurel Fig 53 514 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3.5   6007319.4 2106562.9 37.7646339820142 -122.417881101898 (37.7646339820142, -122.417881101898) 8 4 7 28859 19
79982 628 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3166 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     21 3x3   6007874.17365 2102144.23632 37.7525325514911 -122.41564940087 (37.7525325514911, -122.41564940087) 2 4 7 28859 19
79861 649 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3244X 24th St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007408.30918 2102098.45375 37.7523806444342 -122.417257199664 (37.7523806444342, -122.417257199664) 2 4 7 28859 19
79797 113702 Undocumented 4 Ficus nitida :: Laurel Fig 53 14 LUNDYS LN 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6007138 2099599 37.7455024988094 -122.418014802057 (37.7455024988094, -122.418014802057) 2 7 7 28859 2
78654 96735 Undocumented 4 Ficus nitida :: Laurel Fig 53 520 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3.5   6007401.6 2106571.6 37.7646624959011 -122.417597409955 (37.7646624959011, -122.417597409955) 8 4 7 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);