trees

186 rows where Supervisor Districts = 5 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)
193861 44757 Permitted Site 7 Ficus nitida :: Laurel Fig 53 480 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43870 6003593.00847933 2105481.98628904 37.7614556341181 -122.430692553071 (37.7614556341181, -122.430692553071) 15 4 5 28862 3
193673 120592 Undocumented 4 Ficus nitida :: Laurel Fig 53 3773 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003806 2105923 37.7626786166025 -122.429987363922 (37.7626786166025, -122.429987363922) 8 4 5 28862 3
192675 111390 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 19
192632 5633 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1256 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005118.39805 2100997.74937 37.749229268656 -122.425097781596 (37.749229268656, -122.425097781596) 2 4 5 28862 22
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
190159 225029 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 4543 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/14/2017 12:00:00 AM 3 Width 3ft Permit Number 17041 6000793.7951 2105198.47261 37.7605181908718 -122.440353514511 (37.7605181908718, -122.440353514511) 2 4 5 28862 3
189703 66879 Permitted Site 7 Ficus nitida :: Laurel Fig 53 277 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1991 12:00:00 AM     Permit Number 768127 6001144.84674667 2104743.15871911 37.7592879918503 -122.439106757133 (37.7592879918503, -122.439106757133) 2 4 5 28862 3
189307 111392 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 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
188536 117125 Undocumented 4 Ficus nitida :: Laurel Fig 53 766 NOE ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003023 2103770 37.7567226205836 -122.432541687014 (37.7567226205836, -122.432541687014) 2 4 5 28862 3
188517 109332 Undocumented 4 Ficus nitida :: Laurel Fig 53 1321 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     22 3x3   5998933 2105018 37.7599165333482 -122.446776141106 (37.7599165333482, -122.446776141106) 15 5 5 28862 12
187242 44341 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2294 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM     Permit Number 43725 6002286.29088827 2107094.04279132 37.7658078311453 -122.435327256937 (37.7658078311453, -122.435327256937) 15 5 5 28862 3
184960 109002 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
184670 59431 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3033 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1980 12:00:00 AM 14 3x3 Permit Number 18793 6002899.25612306 2096070.04882186 37.7355733371118 -122.432419698468 (37.7355733371118, -122.432419698468) 2 7 5 63 7
181736 5595 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1100 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     90 3x3   6005095.5235026 2101950.1341989 37.7518430048639 -122.425244643333 (37.7518430048639, -122.425244643333) 2 4 5 28862 22
181257 109235 Undocumented 4 Ficus nitida :: Laurel Fig 53 670 CHENERY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6002570.3 2095716.9 37.7345850124828 -122.433531794387 (37.7345850124828, -122.433531794387) 2 7 5 63 7
180301 96962 Undocumented 4 Ficus nitida :: Laurel Fig 53 3401X 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 5x5   6004198 2106595 37.7645459600586 -122.428679481968 (37.7645459600586, -122.428679481968) 8 4 5 28862 3
180167 99046 Undocumented 4 Ficus nitida :: Laurel Fig 53 2194 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6002943 2107121 37.7659191216839 -122.43305776744 (37.7659191216839, -122.43305776744) 15 5 5 28862 3
178363 5655 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1332 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6005148.4988519 2100582.0357256 37.7480895150856 -122.424964119184 (37.7480895150856, -122.424964119184) 2 4 5 63 22
177897 100470 Undocumented 4 Ficus nitida :: Laurel Fig 53 5X Pearl St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6005567.3 2108720.4 37.7704592014806 -122.424094599295 (37.7704592014806, -122.424094599295) 8 2 5 28853 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
176391 55727 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2153 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM     Permit Number 11753 6003484.39561577 2107108.612602 37.7659158038039 -122.431184308511 (37.7659158038039, -122.431184308511) 15 4 5 28862 3
176337 104331 Undocumented 4 Ficus nitida :: Laurel Fig 53 9 Beaver St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002844 2106791 37.7650074058753 -122.433376604069 (37.7650074058753, -122.433376604069) 15 5 5 28862 3
175062 97110 Undocumented 4 Ficus nitida :: Laurel Fig 53 1095X Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6003193.9 2101874 37.751526344012 -122.431815280512 (37.751526344012, -122.431815280512) 2 4 5 28862 22
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
172156 97109 Undocumented 4 Ficus nitida :: Laurel Fig 53 1095X Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6003187 2102045 37.7519954785262 -122.431851350128 (37.7519954785262, -122.431851350128) 2 4 5 28862 22
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
170923 109294 Significant Tree 6 Ficus nitida :: Laurel Fig 53 370 27TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18     6004104.9 2100171.3 37.7469027259862 -122.428543573264 (37.7469027259862, -122.428543573264) 2 7 5 63 22
170556 87134 Permitted Site 7 Ficus nitida :: Laurel Fig 53 65 Mars St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 50103 5999603 2105413 37.7610393570971 -122.444487333455 (37.7610393570971, -122.444487333455) 15 5 5 28862 3
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
166856 95409 Undocumented 4 Ficus nitida :: Laurel Fig 53 2885 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Added tree to database on 2/28/11. Appears to be 15-20 yrs old. 6002410 2095371 37.7336261540057 -122.434061286386 (37.7336261540057, -122.434061286386) 2 7 5 63 7
166702 57580 Permitted Site 7 Ficus nitida :: Laurel Fig 53 6 Sharon St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/1976 12:00:00 AM 10   Permit Number 16447 6003825.41823987 2107112.36179244 37.7659454174839 -122.430005049505 (37.7659454174839, -122.430005049505) 8 4 5 28862 3
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
163561 101313 Undocumented 4 Ficus nitida :: Laurel Fig 53 4244X 19th St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5     14 5x6   6001912 2104709 37.7592378221466 -122.436451128899 (37.7592378221466, -122.436451128899) 2 4 5 28862 3
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
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
160630 62897 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4123 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/1986 12:00:00 AM 7   Permit Number 23271 6001535.79254212 2105815.28492087 37.7622540264533 -122.437831469331 (37.7622540264533, -122.437831469331) 15 5 5 28862 3
160495 5728 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1688 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 3X3   6005263.1161773 2098508.6699422 37.742402999925 -122.42442032403 (37.742402999925, -122.42442032403) 2 7 5 63 22
159337 98224 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4068 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2012 12:00:00 AM   3x3 Permit Number 56734 6003417.8 2101304.1 37.7499742222019 -122.431000336814 (37.7499742222019, -122.431000336814) 2 4 5 28862 22
158811 225015 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 157 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780170 6002699.82559 2104972.04176 37.7600048066089 -122.433745251143 (37.7600048066089, -122.433745251143) 2 4 5 28862 3
155693 110274 Undocumented 4 Ficus nitida :: Laurel Fig 53 4624 18TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     22 3x3   6000413 2105241 37.7606132717498 -122.4416735587 (37.7606132717498, -122.4416735587) 15 4 5 28862 3
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
155520 58902 Permitted Site 7 Ficus nitida :: Laurel Fig 53 15 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/1980 12:00:00 AM     Permit Number 18176 6005036.25199829 2101622.63318287 37.7509404143338 -122.425426308198 (37.7509404143338, -122.425426308198) 2 4 5 28862 22
153620 93043 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110X Ord St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6000798.7 2105708.1 37.7619177818182 -122.440373100603 (37.7619177818182, -122.440373100603) 15 5 5 28862 3
152624 4455 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1404 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/13/2015 12:00:00 AM 70 3X3   6004493.5375 2100668.30282 37.7482893665971 -122.427235096559 (37.7482893665971, -122.427235096559) 2 4 5 63 22
152209 105842 Undocumented 4 Ficus nitida :: Laurel Fig 53 51 Prosper St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 2x3   6003352 2106231 37.7634985883576 -122.431579576657 (37.7634985883576, -122.431579576657) 15 4 5 28862 3
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
149401 55522 Permitted Site 7 Ficus nitida :: Laurel Fig 53 484 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/1972 12:00:00 AM     Permit Number 11483 6003594.27279224 2105459.16759406 37.7613930510814 -122.430686551957 (37.7613930510814, -122.430686551957) 15 4 5 28862 3
148285 111389 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 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
143577 55394 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2271 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2016 12:00:00 AM 3   Permit Number 778438 6002436.86184357 2107050.31699598 37.765696320564 -122.43480333738 (37.765696320564, -122.43480333738) 15 5 5 28862 3
143541 28384 Permitted Site 7 Ficus nitida :: Laurel Fig 53 286 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     18     6006047.68288 2107930.23885 37.7683167183705 -122.422376798825 (37.7683167183705, -122.422376798825) 8 4 5 28853 19
142768 112396 Undocumented 4 Ficus nitida :: Laurel Fig 53 574 VALLEY ST 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6002248 2099192 37.7441085392299 -122.434894531673 (37.7441085392299, -122.434894531673) 2 7 5 63 22
141541 109003 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 4 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
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
140999 109004 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 5 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
140782 120966 Undocumented 4 Ficus nitida :: Laurel Fig 53 1145x Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003243 2101623 37.7508399403415 -122.43162756863 (37.7508399403415, -122.43162756863) 2 4 5 28862 22
140034 95413 Undocumented 4 Ficus nitida :: Laurel Fig 53 691 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2016 12:00:00 AM 12 3x3 Permit Number 779045 6002523 2095666 37.7344425689427 -122.433691689524 (37.7344425689427, -122.433691689524) 2 7 5 63 7
140006 173777 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 89 Eureka St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001439 2105287 37.7607979807122 -122.438128392537 (37.7607979807122, -122.438128392537) 15 4 5 28862 3
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
139096 51485 Permitted Site 7 Ficus nitida :: Laurel Fig 53 253 Chattanooga St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2005 12:00:00 AM     Permit Number 47796 6004792.25802571 2102204.70843345 37.7525248690267 -122.426311501214 (37.7525248690267, -122.426311501214) 2 4 5 28862 22
139038 104320 Undocumented 4 Ficus nitida :: Laurel Fig 53 80 Beaver St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2016 12:00:00 AM 3 3x3 Permit Number 778510 6002383 2106795 37.7649922243231 -122.434971372236 (37.7649922243231, -122.434971372236) 15 5 5 28862 3
138560 121561 Undocumented 4 Ficus nitida :: Laurel Fig 53 1044 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6003754 2102206 37.7524696725481 -122.429902065263 (37.7524696725481, -122.429902065263) 2 4 5 28862 22
138351 107659 Undocumented 4 Ficus nitida :: Laurel Fig 53 1324 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   5999078.1 2104991.6 37.759852333413 -122.446272413537 (37.759852333413, -122.446272413537) 15 5 5 28862 3
135877 109331 Undocumented 4 Ficus nitida :: Laurel Fig 53 1325 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     22 3x3   5998933 2105018 37.7599165333482 -122.446776141106 (37.7599165333482, -122.446776141106) 15 5 5 28862 12
132426 95220 Undocumented 4 Ficus nitida :: Laurel Fig 53 3208 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005461 2106663 37.7648040703693 -122.424315938973 (37.7648040703693, -122.424315938973) 8 4 5 28853 19
131463 120674 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3876 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780.8 2105549.3 37.761651098806 -122.430047862208 (37.761651098806, -122.430047862208) 8 4 5 28862 3
130690 109005 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 6 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
129658 5136 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2842 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 1x1   6002395.52907 2095496.33738 37.7339694804636 -122.434120273378 (37.7339694804636, -122.434120273378) 2 7 5 63 7
129122 111818 Undocumented 4 Ficus nitida :: Laurel Fig 53 80 ORD ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000817 2105938 37.7625500726099 -122.440326296311 (37.7625500726099, -122.440326296311) 15 5 5 28862 3
128105 109334 Undocumented 4 Ficus nitida :: Laurel Fig 53 1313 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   5999032 2105350 37.7608337776961 -122.446457634643 (37.7608337776961, -122.446457634643) 15 5 5 28862 12
127071 104321 Undocumented 4 Ficus nitida :: Laurel Fig 53 80 BEAVER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     25 3x3 Permit Number 778510 6002416.6 2106828.4 37.7650858403074 -122.434857547122 (37.7650858403074, -122.434857547122) 15 5 5 28862 3
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
125904 57425 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3870 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/1976 12:00:00 AM 20 6x10 Permit Number 16267 6004690.36073914 2101363.26470881 37.750208699936 -122.426603966833 (37.750208699936, -122.426603966833) 2 4 5 28862 22
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
124546 5589 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1082 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   6005080.54834 2102051.49498 37.7521204720239 -122.425303641737 (37.7521204720239, -122.425303641737) 2 4 5 28862 22
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
123903 173773 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2235 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002649 2107045 37.7656937631635 -122.434069218237 (37.7656937631635, -122.434069218237) 15 5 5 28862 3
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
122961 53708 Permitted Site 7 Ficus nitida :: Laurel Fig 53 350 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/1970 12:00:00 AM 36   Permit Number 6655 6003550.85725641 2106242.74617004 37.7635421097395 -122.430892631532 (37.7635421097395, -122.430892631532) 15 4 5 28862 3
122006 4883 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 87 Crags Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 2X2   6000657.5251593 2098217.505729 37.7413423773337 -122.440324154875 (37.7413423773337, -122.440324154875) 2 7 5 63 7
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
120227 96963 Undocumented 4 Ficus nitida :: Laurel Fig 53 3401X 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 5x5   6004198 2106595 37.7645459600586 -122.428679481968 (37.7645459600586, -122.428679481968) 8 4 5 28862 3
116920 39774 Permitted Site 7 Ficus nitida :: Laurel Fig 53 112 28th St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/19/1999 12:00:00 AM 14 5.5x6 Permit Number 41140 6005154.17276637 2099634.09116827 37.7454869972987 -122.424877067697 (37.7454869972987, -122.424877067697) 2 7 5 63 22
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
115017 4281 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 4270 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 2X2   6002137.7495821 2100347.8176818 37.7472758823749 -122.435358414005 (37.7472758823749, -122.435358414005) 2 4 5 63 22
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
114066 54117 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4356 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM   3x3 Permit Number 52105 6001531.81835159 2105282.89107801 37.7607919769606 -122.437807081492 (37.7607919769606, -122.437807081492) 15 4 5 28862 3
113469 117124 Undocumented 4 Ficus nitida :: Laurel Fig 53 766 NOE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3x3   6003023 2103770 37.7567226205836 -122.432541687014 (37.7567226205836, -122.432541687014) 2 4 5 28862 3
112940 106936 Undocumented 4 Ficus nitida :: Laurel Fig 53 98X EUREKA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 6x5   6001388 2105433 37.7611959604452 -122.438315238354 (37.7611959604452, -122.438315238354) 15 4 5 28862 3
112589 115746 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 4 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   28 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
112309 115745 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 3 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   20 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
111149 53710 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4067 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/1970 12:00:00 AM 14   Permit Number 6657 6002578.30950532 2104703.42856113 37.7592603634983 -122.434146313573 (37.7592603634983, -122.434146313573) 2 4 5 28862 3
107985 115744 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 2 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   24 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
107245 58071 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4545 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/1977 12:00:00 AM 13   Permit Number 17041 6000791.5456109 2105188.83821507 37.7604916091053 -122.440360603481 (37.7604916091053, -122.440360603481) 2 4 5 28862 3
107111 44172 Permitted Site 7 Ficus nitida :: Laurel Fig 53 59 Milton St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2000 12:00:00 AM     Permit Number 43639 6003760.97911216 2095401.48581894 37.733786440894 -122.429392732684 (37.733786440894, -122.429392732684) 2 7 5 28861 25
106391 115747 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 5 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   16 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
103761 121256 Undocumented 4 Ficus nitida :: Laurel Fig 53 283 Dorland St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780 2105549 37.7616502297697 -122.430050607682 (37.7616502297697, -122.430050607682) 8 4 5 28862 3
103514 4559 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1250X Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 10x6   6005144.0595933 2101075.0968609 37.7494430966122 -122.425014546007 (37.7494430966122, -122.425014546007) 2 4 5 28862 22
103473 55732 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2229 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM 20   Permit Number 11758 6002695.31984114 2107064.65711257 37.7657503654861 -122.433910413324 (37.7657503654861, -122.433910413324) 15 5 5 28862 3

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)
);