969 rows where qSpecies_id = 97 sorted by Longitude

View and edit SQL

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)
15539 37970 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 602 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/1998 12:00:00 AM     Permit Number 40200                    
23203 6798 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1375 Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x9   6016915.23611 2097187.56543 37.7394266247399 -122.384038431137 (37.7394266247399, -122.384038431137) 10 3 8 58 1
39941 6742 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1300X Fairfax Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 01:53:00 PM 3 3x3   6016901.50063 2097278.26947 37.7396749203573 -122.384092237585 (37.7396749203573, -122.384092237585) 10 3 8 58 1
109268 200443 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2535 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6015875.48388 2103755.07735 37.7574021083324 -122.388091663914 (37.7574021083324, -122.388091663914) 10 3 8 28856 29
39551 39879 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 301 Bryant St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/21/1999 12:00:00 AM     Permit Number 41173 6015620.67363669 2114221.43610992 37.786126305998 -122.389703911477 (37.786126305998, -122.389703911477) 6 2 9 28855 6
95322 39878 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 301 Bryant St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/21/1999 12:00:00 AM     Permit Number 41173 6015620.67363669 2114221.43610992 37.786126305998 -122.389703911477 (37.786126305998, -122.389703911477) 6 2 9 28855 6
3099 104652 Significant Tree 6 Ficus microcarpa :: Chinese Banyan 97 953 Indiana St 1 Front Yard : Cutout Tree Private 2           6015057.1 2104275.7 37.7587862506702 -122.390958369803 (37.7587862506702, -122.390958369803) 10 3 8 28856 29
30016 199432 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1400 Newhall St 1 : Tree Private 2     7 Width 3ft   6014474.33722 2095838.07196 37.7355859449403 -122.39238369005 (37.7355859449403, -122.39238369005) 10 3 8 58 1
31557 199435 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1711 Oakdale Ave 3 : Tree Private 2     5 Width 3ft   6014455.52547 2095885.24717 37.735714433762 -122.392452028664 (37.735714433762, -122.392452028664) 10 3 8 58 1
101216 199433 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1400 Newhall St 2 : Tree Private 2     9 Width 3ft   6014453.55095 2095806.16281 37.7354971746608 -122.392453325466 (37.7354971746608, -122.392453325466) 10 3 8 58 1
120742 26003 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1711 Oakdale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6014451.27252 2095887.995 37.7357217425631 -122.39246692502 (37.7357217425631, -122.39246692502) 10 3 8 58 1
71962 199434 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1711 Oakdale Ave 2 : Tree Private 2     6 Width 3ft   6014431.27107 2095902.06527 37.7357592658851 -122.392537062245 (37.7357592658851, -122.392537062245) 10 3 8 58 1
118175 26002 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1711 Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6014429.78226 2095903.68978 37.7357636437757 -122.392542323281 (37.7357636437757, -122.392542323281) 10 3 8 58 1
129824 26001 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1711 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6014400.39468 2095925.25999 37.7358212390678 -122.392645436853 (37.7358212390678, -122.392645436853) 10 3 8 58 1
18380 65586 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1779 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2020 12:00:00 AM 3   Permit Number 28486 6014089.25997 2096159.17746 37.7364462435881 -122.393737527685 (37.7364462435881, -122.393737527685) 10 3 8 58 1
21188 34146 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
31415 34159 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 12 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
46822 34158 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
49127 34147 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
60189 34157 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 13 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
64627 34152 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
83177 34155 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 11 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
101840 34156 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 14 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
108990 34150 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 6 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
127886 34148 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
129401 34154 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 15 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
131588 34153 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 10 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
171989 34145 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 8 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
177108 34149 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
179766 34151 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 30 Steuart St 7 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1997 12:00:00 AM     Permit Number 37992 6014341.06792841 2117132.86353937 37.7940493718531 -122.394334961669 (37.7940493718531, -122.394334961669) 12 2 9 28855 6
121851 61725 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 66 Williams Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/1985 12:00:00 AM     Permit Number 21727 6013825.41276045 2093670.69143799 37.7295987054368 -122.394475571882 (37.7295987054368, -122.394475571882) 10 3 8 58 1
49450 111387 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 469 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014036 2112699 37.7818580461792 -122.395079826315 (37.7818580461792, -122.395079826315) 6 2 9 28856 6
61828 251398 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 299 Townsend St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   6013957 2110872 37.776837125863 -122.395225113019 (37.776837125863, -122.395225113019) 6 2 9 28856 20
126290 251396 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 299 Townsend St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6013957 2110872 37.776837125863 -122.395225113019 (37.776837125863, -122.395225113019) 6 2 9 28856 20
149080 251397 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 311 Townsend St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6013957 2110872 37.776837125863 -122.395225113019 (37.776837125863, -122.395225113019) 6 2 9 28856 20
118171 126626 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 50 Washington St 1 Median : Yard Tree Private 2     16 Width 8ft   6013909.98641 2118052.46146 37.7965503992498 -122.395891028944 (37.7965503992498, -122.395891028944) 3 1 10 28860 6
162216 126627 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 50x Washington St 2 Median : Yard Tree DPW 1     17 Width 8ft   6013882.15291 2118048.61881 37.796538299751 -122.395987070255 (37.796538299751, -122.395987070255) 3 1 10 28860 6
33799 112160 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1328 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6013587.23518 2105720.84823 37.7626726418425 -122.396143156607 (37.7626726418425, -122.396143156607) 14 3 8 28856 29
187823 199429 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1340 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6013567.84766 2105719.02996 37.7626665705253 -122.396210084142 (37.7626665705253, -122.396210084142) 14 3 8 28856 29
57949 126628 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 50x Washington St 3 Median : Yard Tree DPW 1     15 Width 8ft   6013814.15262 2118039.92484 37.7965106447043 -122.396221758237 (37.7965106447043, -122.396221758237) 3 1 10 28860 6
113783 126629 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 50x Washington St 4 Median : Yard Tree DPW 1     15 Width 8ft   6013771.20775 2118034.57435 37.7964935638782 -122.396369982705 (37.7964935638782, -122.396369982705) 3 1 10 28860 6
145617 126630 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 50x Washington St 6 Median : Yard Tree DPW 1     9 Width 8ft   6013712.21512 2118015.33042 37.7964374416781 -122.396572761821 (37.7964374416781, -122.396572761821) 3 1 10 28860 6
115001 67594 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 308 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM     Permit Number 31161 6013452.45067872 2105638.02121278 37.7624377166869 -122.39660352483 (37.7624377166869, -122.39660352483) 10 3 8 28856 29
5167 126631 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 50x Washington St 7 Median : Yard Tree DPW 1     15 Width 8ft   6013670.6132 2118002.84349 37.796400840179 -122.39671583859 (37.796400840179, -122.39671583859) 3 1 10 28860 6
25718 176421 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 526 Lathrop Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6013003.58559 2086544.76512 37.7099866196603 -122.396817348641 (37.7099866196603, -122.396817348641) 10 3 8 309 1
139460 176420 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 526 Lathrop Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6012864.54988 2086589.64347 37.7101021070033 -122.397301031027 (37.7101021070033, -122.397301031027) 10 3 8 309 1
71033 62088 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 474 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1985 12:00:00 AM     Permit Number 22174 6013214.9408475 2104861.98073646 37.7602936588903 -122.397370564655 (37.7602936588903, -122.397370564655) 10 3 8 28856 29
2420 260860 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 695 Arkansas St 3 Sidewalk: Curb side : Cutout Tree DPW 1   10/16/2019 12:00:00 AM 3 3x3   6013106 2103855 37.7575226440732 -122.397676712285 (37.7575226440732, -122.397676712285) 10 3 8 28856 29
10390 199430 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 695 Arkansas St 1 Sidewalk: Property side : Yard Tree Private 2   10/16/2019 12:00:00 AM 3 Width 10ft   6013045.24345 2103834.71473 37.7574635617095 -122.397885411392 (37.7574635617095, -122.397885411392) 10 3 8 28856 29
1151 199431 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 695 Arkansas St 2 Sidewalk: Property side : Yard Tree Private 2   10/16/2019 12:00:00 AM 3 Width 10ft   6013045.46319 2103845.54885 37.7574933220764 -122.397885411405 (37.7574933220764, -122.397885411405) 10 3 8 28856 29
150898 54789 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 271 Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/1972 12:00:00 AM 21   Permit Number 10638 6012677.12996 2087211.64652 37.7117995683772 -122.39799240103 (37.7117995683772, -122.39799240103) 10 3 8 309 1
75846 32047 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 501 Tunnel Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1999 12:00:00 AM     Permit Number 35428 6012610 2086139 37.7088505533644 -122.398149216451 (37.7088505533644, -122.398149216451) 10 3 8 309 1
173842 32046 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 501 Tunnel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1999 12:00:00 AM     Permit Number 35428 6012610 2086139 37.7088505533644 -122.398149216451 (37.7088505533644, -122.398149216451) 10 3 8 309 1
53369 67032 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 255 California St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/29/2011 12:00:00 AM     Permit Number 767841 6012868.03417039 2116855.7141363 37.7932063935721 -122.399412377848 (37.7932063935721, -122.399412377848) 4 1 10 28860 6
27966 173643 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 657 Howard St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012793 2114089 37.7856054636163 -122.399477673173 (37.7856054636163, -122.399477673173) 6 2 9 28853 6
74295 97191 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 255 California St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/29/2011 12:00:00 AM     Permit Number 767841 6012839.6 2116825.7 37.7931223970079 -122.399508654361 (37.7931223970079, -122.399508654361) 4 1 10 28860 6
92709 97190 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 255 California St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/29/2011 12:00:00 AM     Permit Number 767841 6012839.6 2116825.7 37.7931223970079 -122.399508654361 (37.7931223970079, -122.399508654361) 4 1 10 28860 6
93302 97189 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 255 California St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/29/2011 12:00:00 AM     Permit Number 767841 6012839.6 2116825.7 37.7931223970079 -122.399508654361 (37.7931223970079, -122.399508654361) 4 1 10 28860 6
150846 28252 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3342 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X3   6011993.05449 2089944.36853 37.7192649513087 -122.400548608856 (37.7192649513087, -122.400548608856) 10 7 8 309 28
102221 28251 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3340 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X3   6011988.71606 2089960.7357 37.7193096502899 -122.400564754381 (37.7193096502899, -122.400564754381) 10 7 8 309 28
120892 176426 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3338 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011984.529 2089984.5422 37.7193747846049 -122.400580899003 (37.7193747846049, -122.400580899003) 10 7 8 309 28
37053 176425 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3338 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011982.06755 2090001.33634 37.7194207606357 -122.400590586484 (37.7194207606357, -122.400590586484) 10 7 8 309 28
36324 102902 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 290 PACIFIC AVE   Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6012556 2118523 37.797766966668 -122.400609219963 (37.797766966668, -122.400609219963) 3 1 10 28860 6
43388 102901 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 712 BATTERY ST   Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6012523 2118543 37.7978200413762 -122.400724815577 (37.7978200413762, -122.400724815577) 3 1 10 28860 6
60993 61785 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1495 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/06/1987 12:00:00 AM     Permit Number 24636 6012051.50334521 2101403.29784414 37.7507320294913 -122.401151335946 (37.7507320294913, -122.401151335946) 10 3 8 28856 29
104901 104050 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 145X Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2           6012363 2119165 37.7995189786281 -122.401322196982 (37.7995189786281, -122.401322196982) 3 1 10 28860 6
90644 61306 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1494 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/10/1984 12:00:00 AM     Permit Number 21205 6011999.58311152 2101400.41872379 37.7507212274206 -122.401330679383 (37.7507212274206, -122.401330679383) 10 3 8 28856 29
165378 61309 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2325 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/10/1984 12:00:00 AM     Permit Number 21208 6011929.28683038 2101842.72936764 37.7519317939639 -122.40160485559 (37.7519317939639, -122.40160485559) 10 3 8 28856 29
134941 61310 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2337 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/10/1984 12:00:00 AM     Permit Number 21209 6011897.61971652 2101840.97458612 37.7519252086186 -122.4017142423 (37.7519252086186, -122.4017142423) 10 3 8 28856 29
124236 30843 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1375 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/14/1995 12:00:00 AM     Permit Number 34691 6011743.60320296 2101979.83639733 37.7522978969141 -122.40225661865 (37.7522978969141, -122.40225661865) 10 3 8 28856 29
167803 41049 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1452 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1999 12:00:00 AM     Permit Number 41829 6011713.00642169 2101589.94219711 37.7512256245579 -122.402335016202 (37.7512256245579, -122.402335016202) 10 3 8 28856 29
11332 55316 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1125 Goettingen St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/26/1972 12:00:00 AM 14 3x3 Permit Number 11245 6011314.64048 2089535.2445 37.7181037214869 -122.402864884726 (37.7181037214869, -122.402864884726) 10 7 8 309 39
78944 55568 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1132 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/1972 12:00:00 AM 13 3x2 Permit Number 11537 6011293.45596 2089493.71978 37.7179885201224 -122.402935191909 (37.7179885201224, -122.402935191909) 10 7 8 309 39
164692 55317 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1126 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1972 12:00:00 AM 4   Permit Number 11246 6011285.28669 2089520.65076 37.7180620109438 -122.402965322811 (37.7180620109438, -122.402965322811) 10 7 8 309 39
5103 55566 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1120 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/1972 12:00:00 AM 14 3x3 Permit Number 11535 6011279.28081 2089546.81423 37.7181335151377 -122.402987921868 (37.7181335151377, -122.402987921868) 10 7 8 309 39
84831 111317 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1114 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6011270.9057 2089563.62226 37.7181791988873 -122.403018052761 (37.7181791988873, -122.403018052761) 10 7 8 309 39
34847 173694 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 201X Stevenson St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011772 2114653 37.7870971135768 -122.403049742128 (37.7870971135768, -122.403049742128) 12 2 9 28853 6
69802 111611 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 301x Ward St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 9x3   6011211.14629 2089627.82993 37.7183521627878 -122.403229130826 (37.7183521627878, -122.403229130826) 10 7 8 309 39
26923 101895 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 590X Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011780 2117743.1 37.795582240012 -122.403239519119 (37.795582240012, -122.403239519119) 3 1 10 28860 4
39200 111610 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 301x Ward St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 9x3   6011193.26322 2089621.79675 37.7183345981422 -122.403290521257 (37.7183345981422, -122.403290521257) 10 7 8 309 39
106151 126625 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1445 Sansome St 6 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6011819.79643 2120570.04508 37.8033465696629 -122.403300781611 (37.8033465696629, -122.403300781611) 3 1 10 28860 6
46674 111609 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 301x Ward St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 15x3   6011168.56615 2089615.14952 37.7183149668287 -122.403375421742 (37.7183149668287, -122.403375421742) 10 7 8 309 39
30353 105684 Property Tree 8 Ficus microcarpa :: Chinese Banyan 97 635 08TH ST 1 Front Yard : Pot Tree Private 2     10     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
33251 105685 Property Tree 8 Ficus microcarpa :: Chinese Banyan 97 635 08TH ST 2 Front Yard : Pot Tree Private 2     8     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
145638 105686 Property Tree 8 Ficus microcarpa :: Chinese Banyan 97 635 08TH ST 3 Front Yard : Pot Tree Private 2     6     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
103250 111889 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 142 Wayland St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6011076.19973 2092521.56402 37.7262902239912 -122.403899105983 (37.7262902239912, -122.403899105983) 10 3 7 309 28
61919 43305 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 693 Vermont St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/12/2000 12:00:00 AM 6   Permit Number 43072 6011285.67007 2105193.27319 37.7610957103087 -122.4040663601 (37.7610957103087, -122.4040663601) 10 3 8 28856 29
143067 122749 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 693 Vermont St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5     6011285.50671 2105214.92948 37.7611551645106 -122.404068449214 (37.7611551645106, -122.404068449214) 10 3 8 28856 29
122926 122750 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 693 Vermont St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   9     6011285.1392 2105241.40164 37.7612278306072 -122.404071583333 (37.7612278306072, -122.404071583333) 10 3 8 28856 29
36749 122752 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 693 Vermont St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18     6011278.80569 2105286.3398 37.7613508668666 -122.404096651066 (37.7613508668666, -122.404096651066) 10 3 8 28856 29
40283 30534 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1020 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1995 12:00:00 AM     Permit Number 34535 6011195.92412392 2110919.1949505 37.77681277294 -122.404779881684 (37.77681277294, -122.404779881684) 14 2 9 28853 34
45618 30532 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1020 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1995 12:00:00 AM     Permit Number 34535 6011195.92412392 2110919.1949505 37.77681277294 -122.404779881684 (37.77681277294, -122.404779881684) 14 2 9 28853 34
60674 30533 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1020 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1995 12:00:00 AM     Permit Number 34535 6011195.92412392 2110919.1949505 37.77681277294 -122.404779881684 (37.77681277294, -122.404779881684) 14 2 9 28853 34
37377 176427 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 383 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6010742.02473 2089174.64706 37.7170816042145 -122.404818807562 (37.7170816042145, -122.404818807562) 9 7 8 309 39
32511 117226 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1009 HARRISON ST 12 Sidewalk: Curb side : Cutout Tree DPW 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
67963 117227 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1009 HARRISON ST 13 Sidewalk: Curb side : Cutout Tree DPW 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
86094 117224 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1009 HARRISON ST 10 Sidewalk: Curb side : Cutout Tree DPW 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
88021 115029 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1009 HARRISON ST 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
117473 115032 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1009 HARRISON ST 8 Sidewalk: Curb side : Cutout Tree DPW 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
122705 115031 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1009 HARRISON ST 7 Sidewalk: Curb side : Cutout Tree DPW 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34

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