trees

190 rows where Zip Codes = 28859 and qSpecies_id = 53 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

  • 28859 · 190 ✖
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
190351 110732 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 28859 19
188704 57306 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3265 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/1992 12:00:00 AM   5.5x9 Permit Number 30983 6005094.29272651 2106604.42467206 37.7646225228273 -122.425580116407 (37.7646225228273, -122.425580116407) 8 4 5 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
177096 51793 Permitted Site 7 Ficus nitida :: Laurel Fig 53 65 Oakwood St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2005 12:00:00 AM     Permit Number 48042 6005279.64463313 2105087.60921781 37.7604681781651 -122.42483111417 (37.7604681781651, -122.42483111417) 2 4 5 28859 19
173374 98862 Undocumented 4 Ficus nitida :: Laurel Fig 53 25 OAKWOOD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005344.6 2105317.5 37.7611030726424 -122.424622816907 (37.7611030726424, -122.424622816907) 2 4 5 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
171840 69122 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3744 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/18/1994 12:00:00 AM 22 5x9 Permit Number 33140 6005352.36529805 2104323.23161765 37.7583734841408 -122.424525234112 (37.7583734841408, -122.424525234112) 2 4 5 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
168783 96335 Undocumented 4 Ficus nitida :: Laurel Fig 53 3705 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3 Permit Number 28622 6005781 2101380 37.7503162492489 -122.422833652647 (37.7503162492489, -122.422833652647) 2 4 5 28859 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
165318 93031 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3265 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 5.5x9   6005231 2106625 37.7646867413409 -122.425108746155 (37.7646867413409, -122.425108746155) 8 4 5 28859 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
163969 18370 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 635 Potrero Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     25 4x4   6010438.67568 2105328.38433 37.7614193346753 -122.407005286068 (37.7614193346753, -122.407005286068) 10 4 8 28859 19
162339 10147 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 940 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 2x3   6005660.7422371 2103489.3240903 37.7561011788947 -122.423399446987 (37.7561011788947, -122.423399446987) 2 4 5 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
161145 706 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1509X Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6005302.49516 2099477.85942 37.7450663972586 -122.424353081707 (37.7450663972586, -122.424353081707) 2 7 5 28859 22
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
155548 115216 Undocumented 4 Ficus nitida :: Laurel Fig 53 3395x 21ST ST 2 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2016 12:00:00 AM 3 3x3   6005778 2103691 37.7566615513452 -122.423008263345 (37.7566615513452, -122.423008263345) 2 4 5 28859 19
154248 18380 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 756 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6010387.2722525 2104782.2318449 37.7599168463595 -122.407144570806 (37.7599168463595, -122.407144570806) 10 4 8 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
150324 702 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1399X Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 3X3   6005246.2674799 2100192.367786 37.74702509847 -122.424598323807 (37.74702509847, -122.424598323807) 2 7 5 28859 22
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
144703 220211 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1399 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 7ft   6005241 2100194 37.747029282671 -122.424616654405 (37.747029282671, -122.424616654405) 2 7 5 28859 22
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
142133 18453 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1101 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 3x3   6010571.1211098 2102712.3512407 37.7542437031283 -122.406362877305 (37.7542437031283, -122.406362877305) 10 4 8 28859 19
141296 15649 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3718 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6005292.79028 2096596.92241 37.7371554485093 -122.42418178869 (37.7371554485093, -122.42418178869) 2 7 5 28859 2
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
139295 59013 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3755 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/1980 12:00:00 AM 20   Permit Number 18304 6005291.98683548 2104267.80164023 37.7582178764875 -122.424730106513 (37.7582178764875, -122.424730106513) 2 4 5 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
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
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
131086 18365 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 598 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     40 3x3   6010361.2141646 2105516.7578044 37.7619322307219 -122.407286474232 (37.7619322307219, -122.407286474232) 8 4 8 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
129417 18412 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 799X Potrero Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6010481.3464666 2104567.7087473 37.7593330783471 -122.406804093165 (37.7593330783471, -122.406804093165) 10 4 8 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
127066 96913 Undocumented 4 Ficus nitida :: Laurel Fig 53 65X Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005919.1 2102263.8 37.7527507518094 -122.422418882903 (37.7527507518094, -122.422418882903) 2 4 5 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
125549 110733 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 28859 19
123934 110723 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
123770 5390 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 330X Dolores St 3 Sidewalk: Curb side : Cutout Tree DPW 1     90 4X4   6004823.7091277 2106419.4754114 37.7640994035261 -122.426502823086 (37.7640994035261, -122.426502823086) 8 4 5 28859 3
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
120502 57735 Permitted Site 7 Ficus nitida :: Laurel Fig 53 364 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/1993 12:00:00 AM 16   Permit Number 31982 6005454.9599493 2101588.78174199 37.7508711140338 -122.423975967283 (37.7508711140338, -122.423975967283) 2 4 5 28859 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
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
115099 110727 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
114328 50197 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3279@ DOLORES 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/2003 12:00:00 AM     Permit Number 46903 6005006.02996154 2106599.52754391 37.7646040888867 -122.425885045341 (37.7646040888867, -122.425885045341) 8 4 5 28859 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
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
95901 110725 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
95408 110726 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
93776 110724 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 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)
);