trees
1,381 rows where qSpecies_id = 54 sorted by DBH
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
192522 | 8181 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1212 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6001826.5111 | 2111197.1465 | 37.7770478129311 | -122.43721134601 | (37.7770478129311, -122.43721134601) | 15 | 5 | 11 | 29492 | 41 | |||
3207 | 111734 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2.5x3 | 6005865.3001 | 2111209.4164 | 37.777310260787 | -122.423240771205 | (37.777310260787, -122.423240771205) | 7 | 9 | 11 | 28852 | 10 | |||
20537 | 141610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1501 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000537 | 2110949 | 37.7762930788063 | -122.441654341711 | (37.7762930788063, -122.441654341711) | 15 | 5 | 11 | 29492 | 16 | |||
22348 | 111433 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500X Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5999168.0016 | 2114897.9415 | 37.7870577541309 | -122.446674260217 | (37.7870577541309, -122.446674260217) | 15 | 6 | 1 | 29490 | 31 | |||
34438 | 142561 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2145 POWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009379.1154 | 2121092.3828 | 37.8046441645077 | -122.41178381072 | (37.8046441645077, -122.41178381072) | 3 | 1 | 10 | 308 | 23 | |||
37866 | 67753 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1992 12:00:00 AM | 11 | 3x3 | Permit Number 31377 | 6011258.7412 | 2118020.5233 | 37.79631485229 | -122.405062718866 | (37.79631485229, -122.405062718866) | 3 | 1 | 10 | 308 | 4 | |
38110 | 138007 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1803 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003877.7864 | 2114559.3667 | 37.7863960226531 | -122.430355290708 | (37.7863960226531, -122.430355290708) | 13 | 9 | 11 | 29490 | 13 | |||
40947 | 111735 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2.5x3 | 6005874.8827 | 2111210.5438 | 37.7773138971451 | -122.423207702005 | (37.7773138971451, -122.423207702005) | 7 | 9 | 11 | 28852 | 10 | |||
45097 | 138716 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1609 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999594.5745 | 2114418.8648 | 37.7857666921726 | -122.445163962127 | (37.7857666921726, -122.445163962127) | 15 | 6 | 1 | 29490 | 31 | |||
48538 | 142516 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1205 KEARNY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6011083.7416 | 2119059.5323 | 37.7991579346332 | -122.405741479105 | (37.7991579346332, -122.405741479105) | 3 | 1 | 10 | 308 | 23 | |||
51226 | 141659 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 16 LOYOLA TER | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998449.6222 | 2110830.3835 | 37.7758482379963 | -122.448866580658 | (37.7758482379963, -122.448866580658) | 15 | 6 | 2 | 29492 | 16 | |||
52878 | 247257 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2095 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997008.9956 | 2109086.9596 | 37.7709787579671 | -122.453724126699 | (37.7709787579671, -122.453724126699) | 15 | 5 | 11 | 29492 | 9 | |||
56443 | 138041 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1 Wilmot St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003396.2249 | 2115029.767 | 37.7876603335628 | -122.432054974157 | (37.7876603335628, -122.432054974157) | 13 | 9 | 11 | 29490 | 27 | |||
56605 | 141611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1501 Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000537 | 2110949 | 37.7762930788063 | -122.441654341711 | (37.7762930788063, -122.441654341711) | 15 | 5 | 11 | 29492 | 16 | |||
57394 | 142946 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 154 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010096.4211 | 2121116.6622 | 37.8047510435874 | -122.409303208326 | (37.8047510435874, -122.409303208326) | 3 | 1 | 10 | 308 | 23 | |||
60700 | 244192 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 529 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998441.2408 | 2108808.2865 | 37.7702955988047 | -122.448749895574 | (37.7702955988047, -122.448749895574) | 15 | 5 | 11 | 29492 | 9 | |||
62099 | 217621 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 1830 Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5994307.7366 | 2092494.0455 | 37.725263580598 | -122.461864420033 | (37.725263580598, -122.461864420033) | 9 | 8 | 4 | 28861 | 40 | |||
67040 | 142933 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 502 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6011075.0739 | 2119008.1155 | 37.7990162718949 | -122.405767848781 | (37.7990162718949, -122.405767848781) | 3 | 1 | 10 | 308 | 23 | |||
67787 | 143524 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2240 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002241.7862 | 2118472.6878 | 37.7970481880141 | -122.436295594804 | (37.7970481880141, -122.436295594804) | 13 | 9 | 1 | 57 | 17 | |||
68433 | 142988 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1861 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010372.0828 | 2120911.5359 | 37.804203257928 | -122.408334771369 | (37.804203257928, -122.408334771369) | 3 | 1 | 10 | 308 | 23 | |||
72244 | 17057 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1285 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6000879.2146 | 2109627.576 | 37.772684273376 | -122.440375738629 | (37.772684273376, -122.440375738629) | 15 | 5 | 11 | 29492 | 9 | |||
73860 | 137987 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1815 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004374.8136 | 2115107.5838 | 37.7879294301748 | -122.428674796307 | (37.7879294301748, -122.428674796307) | 13 | 9 | 11 | 29490 | 27 | |||
75521 | 140689 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003360.489 | 2112281.5531 | 37.7801124033613 | -122.431982295298 | (37.7801124033613, -122.431982295298) | 15 | 9 | 11 | 29490 | 41 | |||
77520 | 33692 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 11 | Permit Number 37765 | 6005361.9877 | 2111137.3022 | 37.7770838353758 | -122.42497676123 | (37.7770838353758, -122.42497676123) | 7 | 9 | 11 | 28852 | 10 | ||
78085 | 143124 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1997 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002936.4047 | 2119532.9834 | 37.7999989264566 | -122.43396787787 | (37.7999989264566, -122.43396787787) | 13 | 9 | 1 | 57 | 17 | |||
79297 | 182039 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1323 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5988935.747 | 2106319.8798 | 37.7629149697028 | -122.481446720354 | (37.7629149697028, -122.481446720354) | 1 | 8 | 3 | 56 | 35 | |||
80323 | 140142 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 208 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997849.5605 | 2109871.4122 | 37.7731808165196 | -122.450873174815 | (37.7731808165196, -122.450873174815) | 15 | 5 | 11 | 29492 | 16 | |||
80867 | 59153 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 20 Bellair Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/1982 12:00:00 AM | 11 | Permit Number 19779 | 6010063.4155 | 2121130.5341 | 37.8047872831513 | -122.409418407658 | (37.8047872831513, -122.409418407658) | 3 | 1 | 10 | 308 | 23 | ||
83890 | 57820 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2357 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1977 12:00:00 AM | 11 | Permit Number 16759 | 6002204.3143 | 2114668.0157 | 37.7865994109848 | -122.436152849525 | (37.7865994109848, -122.436152849525) | 13 | 6 | 1 | 29490 | 27 | ||
85272 | 98472 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6011885.4815 | 2107033.4874 | 37.766182021887 | -122.402121236301 | (37.766182021887, -122.402121236301) | 8 | 3 | 8 | 28853 | 20 | |||
88515 | 143357 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1944 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003704.7436 | 2118683.7427 | 37.797710704116 | -122.431248481701 | (37.797710704116, -122.431248481701) | 13 | 9 | 1 | 57 | 17 | |||
91526 | 245076 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1387 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000344.2484 | 2109550.1314 | 37.7724411555945 | -122.442220678844 | (37.7724411555945, -122.442220678844) | 15 | 5 | 11 | 29492 | 9 | |||
95252 | 143212 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 175 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010402.9445 | 2121293.4361 | 37.8052535894305 | -122.408254923564 | (37.8052535894305, -122.408254923564) | 3 | 1 | 10 | 308 | 23 | |||
97052 | 244473 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 859 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003334.8057 | 2110313.6958 | 37.774707699746 | -122.431930590036 | (37.774707699746, -122.431930590036) | 15 | 9 | 11 | 29492 | 10 | |||
98101 | 142489 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 651 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009636.3672 | 2119608.7257 | 37.8005848384211 | -122.410788716085 | (37.8005848384211, -122.410788716085) | 3 | 1 | 10 | 308 | 4 | |||
98202 | 110911 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 633 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6013393.5354 | 2113814.1809 | 37.7848843282601 | -122.397380700853 | (37.7848843282601, -122.397380700853) | 6 | 2 | 9 | 28856 | 6 | ||||
99064 | 244499 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 605 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004067.3081 | 2110070.8068 | 37.7740822846104 | -122.429379391728 | (37.7740822846104, -122.429379391728) | 7 | 9 | 11 | 29492 | 10 | |||
99152 | 248533 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 174 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998320.7066 | 2107735.9897 | 37.7673444513971 | -122.449089561777 | (37.7673444513971, -122.449089561777) | 15 | 5 | 11 | 29492 | 9 | |||
100156 | 143164 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2130 STOCKTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009854.6792 | 2121476.1846 | 37.8057246557504 | -122.410165182597 | (37.8057246557504, -122.410165182597) | 3 | 1 | 10 | 308 | 23 | |||
100398 | 247449 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 919 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002569.9466 | 2109861.5161 | 37.773422736804 | -122.434544050831 | (37.773422736804, -122.434544050831) | 15 | 5 | 11 | 29492 | 9 | |||
106261 | 13311 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2973X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 5999715.5386 | 2114669.4924 | 37.7864617540071 | -122.444763483448 | (37.7864617540071, -122.444763483448) | 15 | 6 | 1 | 29490 | 31 | |||
109680 | 28299 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 100 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 5995861.9776 | 2088092.909 | 37.7132684524741 | -122.456173531067 | (37.7132684524741, -122.456173531067) | 9 | 8 | 6 | 28861 | 24 | |||
109783 | 64843 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 618 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 11 | Permit Number 29500 | 6003607.7064 | 2110511.4611 | 37.7752661815317 | -122.431000689329 | (37.7752661815317, -122.431000689329) | 7 | 9 | 11 | 29492 | 10 | |
111163 | 141074 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 189 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5996533.2225 | 2113090.6095 | 37.7819444436309 | -122.455659269227 | (37.7819444436309, -122.455659269227) | 11 | 6 | 1 | 54 | 31 | |||
112471 | 117049 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2183 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6002213.4716 | 2114319.9367 | 37.7856441950939 | -122.436096250016 | (37.7856441950939, -122.436096250016) | 13 | 6 | 11 | 29490 | 13 | |||
114170 | 143508 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1931 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003561.2395 | 2118662.3144 | 37.7976437341192 | -122.431743514178 | (37.7976437341192, -122.431743514178) | 13 | 9 | 1 | 57 | 17 | |||
114929 | 139283 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 855 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003446.5582 | 2111336.5596 | 37.7775225653231 | -122.431617057223 | (37.7775225653231, -122.431617057223) | 15 | 9 | 11 | 29492 | 10 | |||
116180 | 142958 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 172 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009982.8149 | 2121100.1594 | 37.8046993654404 | -122.40969519031 | (37.8046993654404, -122.40969519031) | 3 | 1 | 10 | 308 | 23 | |||
116294 | 140576 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 1225 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003302.4616 | 2111703.7722 | 37.7785226712194 | -122.432141765433 | (37.7785226712194, -122.432141765433) | 15 | 9 | 11 | 29492 | 41 | |||
117001 | 248404 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1713 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997468.9999 | 2108115.1317 | 37.7683367292403 | -122.452062838629 | (37.7683367292403, -122.452062838629) | 15 | 5 | 11 | 29492 | 9 | |||
117117 | 141366 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 445 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6001152.0558 | 2110273.1905 | 37.7744725000369 | -122.439478242448 | (37.7744725000369, -122.439478242448) | 15 | 5 | 11 | 29492 | 10 | |||
117293 | 142970 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 175 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010034.7291 | 2121089.9447 | 37.8046742274183 | -122.409514813908 | (37.8046742274183, -122.409514813908) | 3 | 1 | 10 | 308 | 23 | |||
118043 | 98468 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6011948.2516 | 2107041.0959 | 37.7662064164751 | -122.401904660337 | (37.7662064164751, -122.401904660337) | 8 | 3 | 8 | 28853 | 20 | |||
118617 | 111432 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500X Presidio Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5999166.6215 | 2114917.2623 | 37.7871107251509 | -122.446680425702 | (37.7871107251509, -122.446680425702) | 15 | 6 | 1 | 29490 | 31 | |||
119500 | 138131 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2135 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003060.8632 | 2114789.3963 | 37.7869813180356 | -122.433198077825 | (37.7869813180356, -122.433198077825) | 13 | 9 | 11 | 29490 | 27 | |||
122119 | 141768 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3 Hollis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003889.1539 | 2113490.7518 | 37.7834625181939 | -122.430239695918 | (37.7834625181939, -122.430239695918) | 7 | 9 | 11 | 29490 | 41 | |||
122397 | 140223 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 610 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003617.0405 | 2110448.5788 | 37.7750940511339 | -122.43096391169 | (37.7750940511339, -122.43096391169) | 7 | 9 | 11 | 29492 | 10 | |||
122945 | 248308 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1327 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999347.2972 | 2108376.4732 | 37.7691617186903 | -122.445584804207 | (37.7691617186903, -122.445584804207) | 15 | 5 | 11 | 29492 | 9 | |||
123304 | 143227 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 106 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010308.3267 | 2121146.7978 | 37.8048456584244 | -122.408572011197 | (37.8048456584244, -122.408572011197) | 3 | 1 | 10 | 308 | 23 | |||
126969 | 143217 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 235 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010187.3061 | 2121274.0368 | 37.80518824668 | -122.40899980098 | (37.80518824668, -122.40899980098) | 3 | 1 | 10 | 308 | 23 | |||
127184 | 246082 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1390 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999092.1637 | 2108384.801 | 37.7691700156221 | -122.446467892576 | (37.7691700156221, -122.446467892576) | 15 | 5 | 11 | 29492 | 9 | |||
129125 | 140141 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 210 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997851.4768 | 2109847.2667 | 37.7731146288991 | -122.450864804769 | (37.7731146288991, -122.450864804769) | 15 | 5 | 11 | 29492 | 16 | |||
129424 | 247348 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1563 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999102.729 | 2109036.7578 | 37.7709607271706 | -122.44647825803 | (37.7709607271706, -122.44647825803) | 15 | 5 | 11 | 29492 | 9 | |||
141382 | 248349 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1589 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997958.0688 | 2108183.1168 | 37.7685514011761 | -122.450376104779 | (37.7685514011761, -122.450376104779) | 15 | 5 | 11 | 29492 | 9 | |||
143879 | 64376 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 69 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1988 12:00:00 AM | 11 | Permit Number 25215 | 5996673.1599 | 2112554.0417 | 37.7804791997483 | -122.455136367138 | (37.7804791997483, -122.455136367138) | 11 | 6 | 2 | 54 | 16 | ||
144865 | 142962 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 192 Pfeiffer St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009928.7622 | 2121093.4626 | 37.8046779485644 | -122.409881772835 | (37.8046779485644, -122.409881772835) | 3 | 1 | 10 | 308 | 23 | |||
146348 | 248359 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1485 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998647.9135 | 2108278.8108 | 37.7688536092872 | -122.447996890761 | (37.7688536092872, -122.447996890761) | 15 | 5 | 11 | 29492 | 9 | |||
146663 | 138040 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1 Wilmot St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003385.4026 | 2115029.2516 | 37.7876583048425 | -122.432092380369 | (37.7876583048425, -122.432092380369) | 13 | 9 | 11 | 29490 | 27 | |||
148789 | 248309 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1333 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999321.5567 | 2108373.142 | 37.769151102475 | -122.445673599246 | (37.769151102475, -122.445673599246) | 15 | 5 | 11 | 29492 | 9 | |||
149114 | 247438 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 430 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002224.5888 | 2109990.6164 | 37.7737576031752 | -122.435747929432 | (37.7737576031752, -122.435747929432) | 15 | 5 | 11 | 29492 | 10 | |||
150274 | 251080 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 5616 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5989535.588 | 2112697.0631 | 37.7804598215152 | -122.47983878159 | (37.7804598215152, -122.47983878159) | 11 | 6 | 2 | 55 | 26 | |||
152841 | 140214 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 668 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003589.5295 | 2110658.3502 | 37.7756684727789 | -122.43107405366 | (37.7756684727789, -122.43107405366) | 7 | 9 | 11 | 29492 | 10 | |||
156150 | 143125 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2095 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002486.7834 | 2119470.709 | 37.7998024110973 | -122.435519279075 | (37.7998024110973, -122.435519279075) | 13 | 9 | 1 | 57 | 17 | |||
160471 | 248352 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1585 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998007.43 | 2108190.3847 | 37.7685741818657 | -122.450205893283 | (37.7685741818657, -122.450205893283) | 15 | 5 | 11 | 29492 | 9 | |||
164335 | 138504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2199 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002136.009 | 2114306.6228 | 37.7856032373843 | -122.436363294657 | (37.7856032373843, -122.436363294657) | 13 | 6 | 11 | 29490 | 13 | |||
166162 | 142959 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 178 Pfeiffer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009960.8111 | 2121097.7677 | 37.8046915653635 | -122.409771168052 | (37.8046915653635, -122.409771168052) | 3 | 1 | 10 | 308 | 23 | |||
176113 | 246089 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 29 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998181.8595 | 2108411.1471 | 37.7691903195921 | -122.449618468841 | (37.7691903195921, -122.449618468841) | 15 | 5 | 11 | 29492 | 9 | |||
181093 | 139436 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 410 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005361.8436 | 2111159.167 | 37.7771438626442 | -122.424978815742 | (37.7771438626442, -122.424978815742) | 7 | 9 | 11 | 28852 | 10 | |||
181998 | 138373 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1801 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6002557.3186 | 2114515.2232 | 37.7861999309178 | -122.434920611081 | (37.7861999309178, -122.434920611081) | 13 | 9 | 11 | 29490 | 27 | |||
186358 | 247445 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 811 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003098.9445 | 2109936.0688 | 37.7736574554899 | -122.432719499751 | (37.7736574554899, -122.432719499751) | 15 | 5 | 11 | 29492 | 9 | |||
191861 | 248318 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998789.7889 | 2108283.5046 | 37.768874606083 | -122.447506493604 | (37.768874606083, -122.447506493604) | 15 | 5 | 11 | 29492 | 9 | |||
194022 | 59752 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2375 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1981 12:00:00 AM | 11 | Permit Number 19189 | 6000826.215 | 2113783.3508 | 37.7840919573447 | -122.440857239763 | (37.7840919573447, -122.440857239763) | 15 | 6 | 11 | 29490 | 13 | ||
122 | 17067 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1355 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000506.9486 | 2109572.2346 | 37.7725111167076 | -122.441659471159 | (37.7725111167076, -122.441659471159) | 15 | 5 | 11 | 29492 | 9 | |||
1620 | 16991 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 899 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002773.5007 | 2109890.2869 | 37.7735132873347 | -122.433841985714 | (37.7735132873347, -122.433841985714) | 15 | 5 | 11 | 29492 | 9 | |||
3486 | 12249 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 511 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004989.1563 | 2110705.1842 | 37.7758762780635 | -122.426235730542 | (37.7758762780635, -122.426235730542) | 7 | 9 | 11 | 28852 | 10 | |||
7238 | 17116 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1899 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997981.6278 | 2109222.6111 | 37.7714069348749 | -122.450369559944 | (37.7714069348749, -122.450369559944) | 15 | 5 | 11 | 29492 | 9 | |||
7836 | 72023 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 655 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010509.9754 | 2116460.1743 | 37.7919886256319 | -122.407543551006 | (37.7919886256319, -122.407543551006) | 5 | 1 | 10 | 28857 | 21 | |||
7894 | 7178 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 837 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/24/2020 11:28:00 AM | 12 | 6x6 | 6003458.7438 | 2111235.1971 | 37.7772449397217 | -122.431567664925 | (37.7772449397217, -122.431567664925) | 15 | 9 | 11 | 29492 | 10 | ||
7900 | 138130 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2145 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003041.4675 | 2114785.2401 | 37.7869688058807 | -122.433264885414 | (37.7869688058807, -122.433264885414) | 13 | 9 | 11 | 29490 | 27 | |||
9445 | 32298 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011655.3244 | 2107023.9767 | 37.7661430585802 | -122.40291664053 | (37.7661430585802, -122.40291664053) | 8 | 3 | 8 | 28853 | 20 | |
10282 | 18081 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2967 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999746.4018 | 2114674.089 | 37.7864761362834 | -122.444657035366 | (37.7864761362834, -122.444657035366) | 15 | 6 | 1 | 29490 | 31 | |||
12978 | 7162 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 727 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003506.9326 | 2110884.8593 | 37.7762857300682 | -122.431375949555 | (37.7762857300682, -122.431375949555) | 15 | 9 | 11 | 29492 | 10 | |||
13226 | 141684 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2350 TURK BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998631.8104 | 2111816.1017 | 37.7785651829019 | -122.448307345965 | (37.7785651829019, -122.448307345965) | 15 | 6 | 2 | 54 | 16 | |||
14805 | 143525 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1957 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003628.1215 | 2118621.4061 | 37.7975352014281 | -122.43150916251 | (37.7975352014281, -122.43150916251) | 13 | 9 | 1 | 57 | 17 | |||
17314 | 71305 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 445 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6001154.5387 | 2110263.7555 | 37.7744467352044 | -122.439468977163 | (37.7744467352044, -122.439468977163) | 15 | 5 | 11 | 29492 | 10 | |||
17922 | 21738 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2045 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002837.9936 | 2114410.7158 | 37.7859289122324 | -122.433942077336 | (37.7859289122324, -122.433942077336) | 13 | 9 | 11 | 29490 | 13 | |||
19555 | 529 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2839 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009902.781 | 2102188.0955 | 37.7527668038666 | -122.408637193736 | (37.7527668038666, -122.408637193736) | 2 | 4 | 7 | 28859 | 19 | |||
20716 | 5146 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 217 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001830.6224 | 2108865.7235 | 37.7706465411236 | -122.437030167851 | (37.7706465411236, -122.437030167851) | 15 | 5 | 11 | 29492 | 9 | |||
21051 | 141109 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 154 WOOD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998503.1758 | 2112860.4826 | 37.7814254265925 | -122.448827586566 | (37.7814254265925, -122.448827586566) | 15 | 6 | 2 | 54 | 16 | |||
24303 | 139447 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005464.5232 | 2111090.4798 | 37.7769610637771 | -122.424618726949 | (37.7769610637771, -122.424618726949) | 7 | 9 | 11 | 28852 | 10 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );