186 rows where Supervisor Districts = 5 and qSpecies_id = 53 sorted by Latitude

View and edit SQL

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)
89944 108971 Undocumented 4 Ficus nitida :: Laurel Fig 53 20x ROUSSEAU ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003466 2095297.3 37.7334836652593 -122.430405132046 (37.7334836652593, -122.430405132046) 2 7 5 28861 25
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
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
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
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
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
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
20606 15650 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3718 Mission St 2 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
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
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
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
61784 59066 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1658 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/16/1980 12:00:00 AM     Permit Number 18361 6003975.177671 2098610.37486855 37.7426094440159 -122.428880876877 (37.7426094440159, -122.428880876877) 2 7 5 63 22
38445 4501 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1748 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6004612.9512322 2098708.9638206 37.74291622476 -122.4266826598 (37.74291622476, -122.4266826598) 2 7 5 63 22
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
57759 4493 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1616 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6004570.9658455 2099475.4807252 37.7450185306318 -122.426882412261 (37.7450185306318, -122.426882412261) 2 7 5 63 22
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
82935 39773 Permitted Site 7 Ficus nitida :: Laurel Fig 53 112 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/29/2001 12:00:00 AM 14 6x6 Permit Number 41140 6005154.17276637 2099634.09116827 37.7454869972987 -122.424877067697 (37.7454869972987, -122.424877067697) 2 7 5 63 22
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
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
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
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
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
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
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
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
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
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
61535 5622 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1202 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     28 3X3   6005101.96034 2101291.72603 37.7500355321086 -122.425175538874 (37.7500355321086, -122.425175538874) 2 4 5 28862 22
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
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
43227 110731 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 28859 19
54160 110730 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 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
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
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
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
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
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
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
93614 109925 Undocumented 4 Ficus nitida :: Laurel Fig 53 375 FAIR OAKS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6005525.2 2101540.6 37.7507427833765 -122.423729644924 (37.7507427833765, -122.423729644924) 2 4 5 28859 19
43818 24454 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1384 Valencia St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6006362.58284 2101545.07315 37.7508023001764 -122.420834214589 (37.7508023001764, -122.420834214589) 2 4 5 28859 19
53498 24453 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1384 Valencia St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6006362.58284 2101545.07315 37.7508023001764 -122.420834214589 (37.7508023001764, -122.420834214589) 2 4 5 28859 19
58653 24451 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1384 Valencia St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6006362.58284 2101545.07315 37.7508023001764 -122.420834214589 (37.7508023001764, -122.420834214589) 2 4 5 28859 19
72643 24452 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1384 Valencia St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6006362.58284 2101545.07315 37.7508023001764 -122.420834214589 (37.7508023001764, -122.420834214589) 2 4 5 28859 19
10358 120965 Undocumented 4 Ficus nitida :: Laurel Fig 53 1145x Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003243 2101623 37.7508399403415 -122.43162756863 (37.7508399403415, -122.43162756863) 2 4 5 28862 22
43513 120964 Undocumented 4 Ficus nitida :: Laurel Fig 53 1145x Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003243 2101623 37.7508399403415 -122.43162756863 (37.7508399403415, -122.43162756863) 2 4 5 28862 22
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
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
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
102319 61449 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1330-1332 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/1984 12:00:00 AM     Permit Number 21384 6002514.93546023 2101705.58374617 37.7510254010171 -122.434151182595 (37.7510254010171, -122.434151182595) 2 4 5 28862 22
53386 55163 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1328 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/1993 12:00:00 AM     Permit Number 31912 6002514.24849197 2101716.89965545 37.751056432833 -122.434154367056 (37.751056432833, -122.434154367056) 2 4 5 28862 22
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
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
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
44231 57108 Permitted Site 7 Ficus nitida :: Laurel Fig 53 280 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1974 12:00:00 AM 24 6x6 Permit Number 14378 6004748.38429029 2102046.50032189 37.7520879863161 -122.426451960244 (37.7520879863161, -122.426451960244) 2 4 5 28862 22
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
69799 59060 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4437 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1992 12:00:00 AM 14 2x2 Permit Number 30882 6000423.21385776 2102243.23045707 37.7523827100743 -122.441423120737 (37.7523827100743, -122.441423120737) 2 4 5 28862 22
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
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
63433 4418 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1128 Church St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004420.05713 2102283.99445 37.752721523998 -122.427604283815 (37.752721523998, -122.427604283815) 2 4 5 28862 22
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
8959 113224 Undocumented 4 Ficus nitida :: Laurel Fig 53 4244 23RD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001623 2102374 37.7528100494278 -122.437283434624 (37.7528100494278, -122.437283434624) 2 4 5 28862 22
28234 109001 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
65899 109000 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     6 2x2 circle   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
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
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
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
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
61113 57802 Permitted Site 7 Ficus nitida :: Laurel Fig 53 107 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/26/1988 12:00:00 AM 8 3x3 Permit Number 25561 6000622.33928566 2102551.03510935 37.7532392091702 -122.440756591601 (37.7532392091702, -122.440756591601) 2 4 5 28862 22
66076 112051 Undocumented 4 Ficus nitida :: Laurel Fig 53 3748x 22ND ST 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3x3   6003448 2103060 37.7547972209553 -122.431021210073 (37.7547972209553, -122.431021210073) 2 4 5 28862 22
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
44100 115215 Undocumented 4 Ficus nitida :: Laurel Fig 53 3395x 21ST ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2016 12:00:00 AM 3 9x5 Permit Number 779049 6005778 2103691 37.7566615513452 -122.423008263345 (37.7566615513452, -122.423008263345) 2 4 5 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
4294 117126 Undocumented 4 Ficus nitida :: Laurel Fig 53 766 NOE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6003023 2103770 37.7567226205836 -122.432541687014 (37.7567226205836, -122.432541687014) 2 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
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
62161 109596 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3332 21ST ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6006085.3 2103802.1 37.7569839418566 -122.421953398845 (37.7569839418566, -122.421953398845) 2 4 5 28859 19
32408 54027 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2016 12:00:00 AM 3 6x6 Permit Number 778679 6004696.3346429 2103995.33974478 37.7574361004301 -122.426770728763 (37.7574361004301, -122.426770728763) 2 4 5 28862 3
51820 12942 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 725X Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     16 6   6005046.7981655 2104134.69405 37.7578385432445 -122.425568603003 (37.7578385432445, -122.425568603003) 2 4 5 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
60853 97999 Undocumented 4 Ficus nitida :: Laurel Fig 53 30 Eagle St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6000135 2104379 37.7582305885461 -122.442573139957 (37.7582305885461, -122.442573139957) 2 4 5 28862 3
85172 98001 Undocumented 4 Ficus nitida :: Laurel Fig 53 30 Eagle St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6000135 2104379 37.7582305885461 -122.442573139957 (37.7582305885461, -122.442573139957) 2 4 5 28862 3
64331 5481 Permitted Site 7 Ficus nitida :: Laurel Fig 53 700X Dolores St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     80 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166) 2 4 5 28862 3
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
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
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
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
20709 109328 Undocumented 4 Ficus nitida :: Laurel Fig 53 1349 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2015 12:00:00 AM 3 3x3   5999000.5 2104870.1 37.7595142924854 -122.446532051538 (37.7595142924854, -122.446532051538) 15 5 5 28862 12
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
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
27436 107660 Undocumented 4 Ficus nitida :: Laurel Fig 53 1316 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5999083.9 2105040.7 37.7599874810533 -122.446255886285 (37.7599874810533, -122.446255886285) 15 5 5 28862 3
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
75176 173949 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1306 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999102 2105133 37.7602419475954 -122.446199926833 (37.7602419475954, -122.446199926833) 15 5 5 28862 3
66858 173948 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1300 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999106 2105162 37.7603218028196 -122.446188178838 (37.7603218028196, -122.446188178838) 15 5 5 28862 3
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
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
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
72782 58078 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4624 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/1977 12:00:00 AM     Permit Number 17049 6000401 2105218 37.7605494356876 -122.441713410467 (37.7605494356876, -122.441713410467) 15 4 5 28862 3
24098 50784 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4425@ EUREKA 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/2004 12:00:00 AM     Permit Number 47310 6001319.3692016 2105218.84665198 37.760604043869 -122.438537258087 (37.760604043869, -122.438537258087) 2 4 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)
);