trees

963 rows where qCaretaker_id = 2 and qSpecies_id = 53 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 963 ✖
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)
193965 108150 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
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
193656 16998 Permitted Site 7 Ficus nitida :: Laurel Fig 53 903 Oak St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3X3   6002629.22495 2109872.04506 37.7734550115897 -122.434339751705 (37.7734550115897, -122.434339751705) 15 5 11 29492 9
193427 106524 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 4 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
193266 97278 Permitted Site 7 Ficus nitida :: Laurel Fig 53 60 Palm Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 768156 5995934.7 2114107.9 37.7847032866401 -122.457803503646 (37.7847032866401, -122.457803503646) 11 6 1 54 31
192777 48866 Permitted Site 7 Ficus nitida :: Laurel Fig 53 129 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/2002 12:00:00 AM     Permit Number 46075 6006370.62112219 2110394.65908683 37.7751016387897 -122.421434823029 (37.7751016387897, -122.421434823029) 7 9 11 28852 10
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
192243 94600 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1709 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2           5997540 2108126 37.7683706375079 -122.451818041345 (37.7683706375079, -122.451818041345) 15 5 11 29492 9
191709 52838 Permitted Site 7 Ficus nitida :: Laurel Fig 53 795on Trenton Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 48857 6010309.20673902 2118158.51574656 37.7966406195852 -122.408358059553 (37.7966406195852, -122.408358059553) 3 1 10 308 4
191099 100527 Undocumented 4 Ficus nitida :: Laurel Fig 53 1728 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2       4.5x6   6008341 2118363 37.7970916696404 -122.415182998934 (37.7970916696404, -122.415182998934) 5 1 10 308 21
190730 110993 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 12 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2015 12:00:00 AM 3     6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
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
190125 52718 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1330on LARKIN Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2006 12:00:00 AM     Permit Number 48769 6007121.03491046 2115409.40396286 37.7889131924877 -122.419194766666 (37.7889131924877, -122.419194766666) 13 9 10 28858 21
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
189256 91128 Permitted Site 7 Ficus nitida :: Laurel Fig 53 610 Brannan St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
188867 121000 Undocumented 4 Ficus nitida :: Laurel Fig 53 390 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6010815 2115725 37.7899870820688 -122.406436332672 (37.7899870820688, -122.406436332672) 5 1 10 28857 6
188786 99614 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
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
188426 148686 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 13 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010834.41502 2110868.71034 37.7766539412504 -122.406026899245 (37.7766539412504, -122.406026899245) 14 2 9 28853 34
188290 100708 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
188273 2450 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1805X Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6003959.520066 2114567.2690482 37.7864223498862 -122.430073076908 (37.7864223498862, -122.430073076908) 13 9 11 29490 13
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
188136 120939 Undocumented 4 Ficus nitida :: Laurel Fig 53 485 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012395 2105853 37.7629690927527 -122.400275979648 (37.7629690927527, -122.400275979648) 14 3 8 28856 29
188066 9689 Permitted Site 7 Ficus nitida :: Laurel Fig 53 332 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6006025.5202 2110969.11106 37.7766594813407 -122.422669436188 (37.7766594813407, -122.422669436188) 7 9 11 28852 10
187881 94217 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 2 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
187371 89021 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1500 Mission St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51766 6007445.1 2110006.7 37.7740969185595 -122.417690449841 (37.7740969185595, -122.417690449841) 8 2 9 28853 19
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
187091 100051 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
186730 120142 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
186717 107211 Undocumented 4 Ficus nitida :: Laurel Fig 53 2255 CLAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6003966.3 2116269.9 37.7910977281266 -122.430171131086 (37.7910977281266, -122.430171131086) 13 9 1 29490 27
186566 15267 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1531 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6007476.41024 2109891.28194 37.7737817698767 -122.417573960108 (37.7737817698767, -122.417573960108) 8 2 9 28853 19
186477 113509 Undocumented 4 Ficus nitida :: Laurel Fig 53 318 TURK ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008412 2113183 37.7828726439691 -122.414570576408 (37.7828726439691, -122.414570576408) 7 10 9 28852 36
186331 122713 Undocumented 4 Ficus nitida :: Laurel Fig 53 855x Kearny St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011188 2117923 37.7960431220576 -122.40530062832 (37.7960431220576, -122.40530062832) 3 1 10 28857 4
186252 116029 Undocumented 4 Ficus nitida :: Laurel Fig 53 1500 PACIFIC AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006937 2117734 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467) 13 9 10 28858 32
186128 21645 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1657 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/23/1990 12:00:00 AM 18 4X4   6004676.7022509 2114666.9735246 37.7867367053745 -122.427598912468 (37.7867367053745, -122.427598912468) 13 9 11 28858 13
185775 117401 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
185695 60219 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1812 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   07/07/1982 12:00:00 AM 18 3x3 Permit Number 19769 6004928.04684857 2117801.00675234 37.795356184696 -122.426952612815 (37.795356184696, -122.426952612815) 13 9 1 28858 27
185458 91127 Permitted Site 7 Ficus nitida :: Laurel Fig 53 610 Brannan St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
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
184672 113275 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2147 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2           6002730.25600058 2118492.02135193 37.7971290147198 -122.43460675571 (37.7971290147198, -122.43460675571) 13 9 1 57 17
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
184217 113003 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
184158 127219 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 8 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999916.98549 2117117.82475 37.7931957274607 -122.444242532876 (37.7931957274607, -122.444242532876) 13 9 1 57 27
183563 110986 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 5 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
183408 50980 Permitted Site 7 Ficus nitida :: Laurel Fig 53 201 Richardson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/06/2004 12:00:00 AM   3x3 Permit Number 47465 5999116.7 2119758.3 37.8004000774175 -122.447201682136 (37.8004000774175, -122.447201682136) 13 9 1 57 17
183245 120146 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2111839 37.7791606496002 -122.415810780563 (37.7791606496002, -122.415810780563) 7 10 9 28852 36
183181 108106 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
183049 111628 Undocumented 4 Ficus nitida :: Laurel Fig 53 11X SOUTH VAN NESS AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007074 2110234 37.7747001403616 -122.418990277193 (37.7747001403616, -122.418990277193) 8 2 9 28853 19
182867 120141 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
182806 112161 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1324 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013680.97327942 2105726.70860795 37.7626939483281 -122.39581935837 (37.7626939483281, -122.39581935837) 14 3 8 28856 29
182781 117184 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
182731 40355 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 9 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
182718 100710 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
182516 44225 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43670 6013393.18767606 2119056.04835121 37.799277245684 -122.397749707821 (37.799277245684, -122.397749707821) 3 1 10 28860 6
182401 99616 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
182282 32648 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2005 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
182236 117650 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 79 ROSSI AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     22 3x3   5996337 2111626 37.7779117506286 -122.456232175702 (37.7779117506286, -122.456232175702) 11 6 2 54 16
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
180816 113763 Undocumented 4 Ficus nitida :: Laurel Fig 53 1730 BAKER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6000110 2114968 37.7873038809733 -122.443420199664 (37.7873038809733, -122.443420199664) 13 6 1 29490 27
180679 120134 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
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
180211 18159 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     40 3x3   6005423.15 2114537.67279 37.7864238707484 -122.425007174907 (37.7864238707484, -122.425007174907) 13 9 11 28858 13
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
180149 112971 Undocumented 4 Ficus nitida :: Laurel Fig 53 601x COLE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   5997795 2108483 37.7693654697431 -122.450961770246 (37.7693654697431, -122.450961770246) 15 5 11 29492 9
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
179624 110706 Undocumented 4 Ficus nitida :: Laurel Fig 53 2999X Turk St 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
179551 120145 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2111839 37.7791606496002 -122.415810780563 (37.7791606496002, -122.415810780563) 7 10 9 28852 36
179159 101726 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 12 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
179011 100052 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
178705 59665 Permitted Site 7 Ficus nitida :: Laurel Fig 53 993 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/1981 12:00:00 AM 12 2x2 Permit Number 19087 6002914.43276984 2111641.44659541 37.7783295332017 -122.433479648258 (37.7783295332017, -122.433479648258) 15 9 11 29492 41
178358 110702 Undocumented 4 Ficus nitida :: Laurel Fig 53 2999X Turk St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
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
178040 120998 Undocumented 4 Ficus nitida :: Laurel Fig 53 370 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6010792 2115565 37.789546473623 -122.406504631878 (37.789546473623, -122.406504631878) 5 1 10 28857 6
178024 173876 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 250 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009764 2087931 37.7136120890563 -122.408111727364 (37.7136120890563, -122.408111727364) 9 7 8 309 39
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
177966 106938 Undocumented 4 Ficus nitida :: Laurel Fig 53 1607 WALLER ST 3 Sidewalk: Curb side : Cutout Tree Private 2     11     5997889 2108175 37.7685251613651 -122.450614421545 (37.7685251613651, -122.450614421545) 15 5 11 29492 9
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
177832 106521 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 1 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
177601 17085 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1585 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5999415.39608 2109426.2103 37.7720479186519 -122.445424745443 (37.7720479186519, -122.445424745443) 15 5 11 29492 9
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
177091 108561 Undocumented 4 Ficus nitida :: Laurel Fig 53 141 02nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995170 2114629.2 37.7860906748156 -122.460486880145 (37.7860906748156, -122.460486880145) 11 6 1 54 11
177069 49259 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 12 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
176974 113008 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
176915 101718 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 4 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
176842 99613 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
176501 104744 Undocumented 4 Ficus nitida :: Laurel Fig 53 15 WAVERLY PL   Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6010745.5 2116998.1 37.7934788206973 -122.406766557506 (37.7934788206973, -122.406766557506) 3 1 10 28857 4
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
176242 41192 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
176167 16388 Permitted Site 7 Ficus nitida :: Laurel Fig 53 238 Myrtle St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6006262.13214 2114058.51032 37.7851555645201 -122.422070450769 (37.7851555645201, -122.422070450769) 13 9 11 28858 41
176043 111207 Undocumented 4 Ficus nitida :: Laurel Fig 53 601X 09TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
175879 15105 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014344.93761 2116565.97781 37.7924930511311 -122.394281863407 (37.7924930511311, -122.394281863407) 12 2 9 28855 6
175212 13101 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501 Lombard St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005049.00181 2119804.80205 37.800864933484 -122.426676850993 (37.800864933484, -122.426676850993) 13 9 1 57 17
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
174828 21667 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1773 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004123.7222039 2114590.0968475 37.7864943276059 -122.429506607504 (37.7864943276059, -122.429506607504) 13 9 11 29490 13

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