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 · 863 ✖
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)
174749 100263 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 3 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
174050 49256 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 6 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
173558 113006 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
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
173344 111211 Undocumented 4 Ficus nitida :: Laurel Fig 53 601X 09TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
173264 111594 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
173238 113007 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
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
172909 106523 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 3 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
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
172861 117048 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2183 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   6002170 2114323 37.7856501363162 -122.436246868292 (37.7856501363162, -122.436246868292) 13 6 11 29490 13
172671 49251 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 18 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
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
172294 110990 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 9 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
172169 117345 Undocumented 4 Ficus nitida :: Laurel Fig 53 395 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006014 2111158 37.7771774746178 -122.422722714586 (37.7771774746178, -122.422722714586) 7 9 11 28852 10
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
172014 101769 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 12 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
171851 110997 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 16 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
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
171777 96409 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 4 Sidewalk: Curb side : Cutout Tree Private 2           5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
171446 257980 Significant Tree 6 Ficus nitida :: Laurel Fig 53 2864 Broadway 3 Front Yard : Yard Tree Private 2         Permit Number 782825 5999909.76407 2117098.92712 37.7931434275556 -122.444266160734 (37.7931434275556, -122.444266160734) 13 9 1 57 27
170953 101768 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 11 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
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
170611 104729 Undocumented 4 Ficus nitida :: Laurel Fig 53 250-252 FRANCISCO ST   Sidewalk: Curb side : Cutout Tree Private 2     22 5x5   6010061.3 2121325.4 37.805322217951 -122.409439489572 (37.805322217951, -122.409439489572) 3 1 10 308 23
170574 114952 Undocumented 4 Ficus nitida :: Laurel Fig 53 601X OCTAVIA ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005348 2111368 37.7777164851071 -122.42504156742 (37.7777164851071, -122.42504156742) 7 9 11 28852 10
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
170512 94219 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 4 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM     Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
170466 114281 Undocumented 4 Ficus nitida :: Laurel Fig 53 200X STEUART ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
170119 103480 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1247 06th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 5x5 Permit Number 31998 5994182.5 2107061.8 37.765255754741 -122.463353999562 (37.765255754741, -122.463353999562) 11 5 11 56 12
169641 12630 Permitted Site 7 Ficus nitida :: Laurel Fig 53 841 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2     40 3X3   5992831.38337 2114795.44702 37.7864123300728 -122.468589897945 (37.7864123300728, -122.468589897945) 11 6 2 54 11
169402 50375 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2727 Pierce St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47038 6001577.22511674 2117761.13132823 37.7950566585474 -122.43854412401 (37.7950566585474, -122.43854412401) 13 9 1 57 27
169319 101719 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 5 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
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
168941 120136 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
168885 48703 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 10 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
168880 112409 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
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
168743 7855 Permitted Site 7 Ficus nitida :: Laurel Fig 53 915 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6006074.49976 2113274.48833 37.7829922485484 -122.422663866925 (37.7829922485484, -122.422663866925) 7 9 11 28858 41
168710 21809 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2627 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6008310.29957 2121825.65474 37.806597526846 -122.415534509856 (37.806597526846, -122.415534509856) 5 1 10 308 23
168672 9974 Permitted Site 7 Ficus nitida :: Laurel Fig 53 812X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6003525.87553 2111110.58272 37.7769065842705 -122.431326537326 (37.7769065842705, -122.431326537326) 7 9 11 29492 10
168485 25273 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1800 Ocean Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     6 2X2   5994503.82801 2092400.83619 37.725018937185 -122.461179802839 (37.725018937185, -122.461179802839) 9 8 4 28861 40
168453 17019 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1053 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6001967.47701 2109780.334 37.7731656122234 -122.436622263598 (37.7731656122234, -122.436622263598) 15 5 11 29492 9
168220 258046 Undocumented 4 Ficus nitida :: Laurel Fig 53 1250 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2019 12:00:00 AM 3 3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
167657 100264 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 4 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
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
166398 9620 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1165X Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/16/1990 12:00:00 AM 50 3X3   6002862.99505 2112096.1743 37.779575183286 -122.433690098242 (37.779575183286, -122.433690098242) 15 9 11 29490 41
166324 8202 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1323 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6001450.33053 2111015.64115 37.7765280537514 -122.438499661404 (37.7765280537514, -122.438499661404) 15 5 11 29492 10
166186 112407 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
166088 103636 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 9 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
165827 41193 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 7 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
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
165688 120662 Undocumented 4 Ficus nitida :: Laurel Fig 53 299X Main St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
165652 21672 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1781 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004087.4531427 2114585.0546301 37.7864784293602 -122.429631729681 (37.7864784293602, -122.429631729681) 13 9 11 29490 13
165464 148687 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 14 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010830.11496 2110873.17046 37.7766659471997 -122.406042088772 (37.7766659471997, -122.406042088772) 14 2 9 28853 34
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
165112 116511 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1500x Waller St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998488 2108327 37.7689767823615 -122.448553488995 (37.7689767823615, -122.448553488995) 15 5 11 29492 9
164853 103632 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
164129 91329 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2885 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52056 6000915 2116200 37.7907325075106 -122.440723481884 (37.7907325075106, -122.440723481884) 13 6 1 29490 27
164124 57410 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 109 Wilmot St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/1976 12:00:00 AM 15   Permit Number 770100 6002753.5601 2114939.9175 37.7873771736852 -122.434272041026 (37.7873771736852, -122.434272041026) 13 9 11 29490 27
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
163880 15107 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014322.84653 2116550.95179 37.7924505652168 -122.394357247259 (37.7924505652168, -122.394357247259) 12 2 9 28855 6
163667 102619 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
163074 110027 Undocumented 4 Ficus nitida :: Laurel Fig 53 1101X WEBSTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6003707 2112516 37.7807757743573 -122.430800292528 (37.7807757743573, -122.430800292528) 15 9 11 29490 41
162862 58508 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1390 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1979 12:00:00 AM   3x3 Permit Number 17683 5999052.33988667 2108383.59508746 37.7691644298026 -122.446605553634 (37.7691644298026, -122.446605553634) 15 5 11 29492 9
162853 105343 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2500X Post St 1 Sidewalk: Curb side : Cutout Tree Private 2           5999969.06573 2113691.86409 37.7837919048286 -122.443816082596 (37.7837919048286, -122.443816082596) 15 6 11 29490 31
162574 113000 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
162297 108098 Undocumented 4 Ficus nitida :: Laurel Fig 53 2800X Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2           5999639 2117762 37.7949485989127 -122.445250712888 (37.7949485989127, -122.445250712888) 13 9 1 57 17
162257 97610 Permitted Site 7 Ficus nitida :: Laurel Fig 53 349 10th St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6009106.7 2109348.6 37.7723832922197 -122.411896150488 (37.7723832922197, -122.411896150488) 8 2 9 28853 34
162113 108325 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
160693 108107 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
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
160281 103637 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 10 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
159917 122820 Permitted Site 7 Ficus nitida :: Laurel Fig 53 776 Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6009771.51732552 2115777.23613944 37.7900720800575 -122.410050397484 (37.7900720800575, -122.410050397484) 5 1 10 28857 21
159895 113553 Undocumented 4 Ficus nitida :: Laurel Fig 53 700 TAYLOR ST 3 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM   3x3   6009263 2115423 37.7890709188275 -122.411784791395 (37.7890709188275, -122.411784791395) 5 1 10 28857 21
159363 58908 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 353 10th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/1980 12:00:00 AM 13 3x3 Permit Number 780019 6009109.47745 2109280.29041 37.7721958858688 -122.411881715065 (37.7721958858688, -122.411881715065) 8 2 9 28853 34
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
159266 7227 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1025 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003385.45092 2111827.8386 37.7788680315263 -122.431863535021 (37.7788680315263, -122.431863535021) 15 9 11 29490 41
158929 101720 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 6 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
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
158763 111774 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 215 CLAYTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5998260 2109886 37.7732443583423 -122.449454468346 (37.7732443583423, -122.449454468346) 15 5 11 29492 16
158673 117398 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
158317 111591 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
157239 44224 Permitted Site 7 Ficus nitida :: Laurel Fig 53 150 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43669 6012974 2118691 37.7982515579635 -122.399174613744 (37.7982515579635, -122.399174613744) 3 1 10 28860 6
157130 11034 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1509 HYDE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     70 3X3   6007406.1 2117518.3 37.7947197495209 -122.418358066687 (37.7947197495209, -122.418358066687) 5 1 10 28858 32
156885 111208 Undocumented 4 Ficus nitida :: Laurel Fig 53 601X 09TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
156467 109326 Undocumented 4 Ficus nitida :: Laurel Fig 53 1624 VALLEJO ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005582.1 2118270.7 37.7966828044962 -122.424722909098 (37.7966828044962, -122.424722909098) 13 9 1 57 17
156343 113279 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2 Hugo St 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5   5995790.34429445 2107089.36315796 37.7654239364323 -122.457794878244 (37.7654239364323, -122.457794878244) 15 5 11 56 12
156157 59335 Permitted Site 7 Ficus nitida :: Laurel Fig 53 201 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1980 12:00:00 AM   4x4 Permit Number 18682 6003287.79827449 2108952.35112135 37.7709671172915 -122.431995967048 (37.7709671172915, -122.431995967048) 15 9 11 29492 9
156149 49237 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 18 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
156118 41200 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 1 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
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
155645 110676 Undocumented 4 Ficus nitida :: Laurel Fig 53 1898 SCOTT ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001594 2114879 37.7871440264162 -122.438279504546 (37.7871440264162, -122.438279504546) 13 6 11 29490 27
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
155542 54199 Permitted Site 7 Ficus nitida :: Laurel Fig 53 44 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1972 12:00:00 AM   4x4 Permit Number 9937 5995656.55399656 2107084.69972772 37.7654034448102 -122.458257287589 (37.7654034448102, -122.458257287589) 15 5 11 56 12
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
155310 11113 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2037 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6007192.03327 2119340.88684 37.7997120641075 -122.41922811701 (37.7997120641075, -122.41922811701) 5 1 1 28858 32
155305 102600 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
154699 121624 Undocumented 4 Ficus nitida :: Laurel Fig 53 101x Trenton St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010049 2117862 37.7958118850813 -122.409237502382 (37.7958118850813, -122.409237502382) 3 1 10 308 4

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