Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
159391 | 159391 | 224628 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1053 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5997656.24362 | 2106853.17472 | 37.7648824406996 | -122.45132415711001 | (37.7648824406996, -122.45132415711) | |||
169537 | 169537 | 218843 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 661 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5997657.5738 | 2098142.0216099997 | 37.740963852094204 | -122.450691444481 | (37.7409638520942, -122.450691444481) | |||
3854 | 3854 | 244051 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 401 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997898.1905 | 2109198.4158 | 37.7713357252186 | -122.450656427551 | (37.7713357252186, -122.450656427551) | |||
4239 | 4239 | 244052 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 401 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997900.6668 | 2109181.4943 | 37.771289404865 | -122.450646641766 | (37.771289404865, -122.450646641766) | |||
164602 | 164602 | 218842 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 101 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997801.418330001 | 2096410.61107 | 37.73621804871821 | -122.450069323134 | (37.7362180487182, -122.450069323134) | |||
75837 | 75837 | 126622 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3340 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5998235.513119999 | 2116198.50625 | 37.7905754501486 | -122.449994218979 | (37.7905754501486, -122.449994218979) | |||
48289 | 48289 | 60093 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3340 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1982 12:00:00 AM | 15 | Permit Number 19594 | 5998249.449130001 | 2116202.11644 | 37.7905861601801 | -122.44994626172199 | (37.7905861601801, -122.449946261722) | |
23566 | 23566 | 59480 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3326 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1980 12:00:00 AM | 13 | Permit Number 18850 | 5998315.87391 | 2116208.53382 | 37.7906075811119 | -122.449716899529 | (37.7906075811119, -122.449716899529) | ||
82331 | 82331 | 65673 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 355 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28593 | 5997947.70792661 | 2098297.78452014 | 37.7414081426615 | -122.449699493918 | (37.7414081426615, -122.449699493918) | ||
32026 | 32026 | 224492 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 60 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5998346.422619999 | 2106894.64873 | 37.7650358128629 | -122.448940002185 | (37.7650358128629, -122.448940002185) | |||
62058 | 62058 | 224491 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 60 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5998359.17902 | 2106895.28933 | 37.765038301310796 | -122.4488959273 | (37.7650383013108, -122.4488959273) | |||
47472 | 47472 | 218808 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 379 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998237.66884 | 2094066.68072 | 37.7298071263007 | -122.448392288972 | (37.7298071263007, -122.448392288972) | ||||
53817 | 53817 | 224489 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 24 Alma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5998519.39636 | 2106289.8820599997 | 37.763385166627295 | -122.44829817853399 | (37.7633851666273, -122.448298178534) | |||
171712 | 171712 | 224488 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 24 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998533.31147 | 2106291.41144 | 37.763390161444896 | -122.44825016102502 | (37.7633901614449, -122.448250161025) | |||
59614 | 59614 | 126623 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3200 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998899.76803 | 2116292.09263 | 37.7908703998933 | -122.44770268523399 | (37.7908703998933, -122.447702685234) | |||
145344 | 145344 | 66937 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2350 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/1992 12:00:00 AM | Permit Number 30262 | 5998853.41639727 | 2111835.46191539 | 37.7786310079222 | -122.44754212322201 | (37.7786310079222, -122.447542123222) | ||
161729 | 161729 | 224490 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 4630 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5998778.21735 | 2105711.3278799998 | 37.7618113953113 | -122.447361360161 | (37.7618113953113, -122.447361360161) | |||
25064 | 25064 | 176406 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 75 Dichiera Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 2ft | 5998546.73235 | 2087959.10708 | 37.71305480791771 | -122.446884509935 | (37.7130548079177, -122.446884509935) | |||
137325 | 137325 | 176405 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 75 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 5998552.29871 | 2087983.35456 | 37.7131217039812 | -122.446867014517 | (37.7131217039812, -122.446867014517) | |||
54887 | 54887 | 176407 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 65 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998589.29961 | 2087923.49641 | 37.7129594608753 | -122.446734823157 | (37.7129594608753, -122.446734823157) | |||
143752 | 143752 | 68371 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1233 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32193 | 5998967.61980979 | 2105592.97843293 | 37.7614972584923 | -122.44669777928699 | (37.7614972584923, -122.446697779287) | ||
39277 | 39277 | 176408 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 55 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998608.92575 | 2087907.1259400002 | 37.7129156324143 | -122.44666581189101 | (37.7129156324143, -122.446665811891) | |||
172813 | 172813 | 176409 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 45 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5998625.6999 | 2087888.85423 | 37.7128664206305 | -122.44660652136999 | (37.7128664206305, -122.44660652137) | |||
185146 | 185146 | 224624 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1323 Clayton St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5999021.66534 | 2105005.43313 | 37.7598870925388 | -122.446468587874 | (37.7598870925388, -122.446468587874) | |||
27084 | 27084 | 224623 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1323 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5999023.60773 | 2105026.39376 | 37.759944756159996 | -122.44646337809601 | (37.75994475616, -122.446463378096) | |||
165447 | 165447 | 224622 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1323 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5999026.564590001 | 2105047.83376 | 37.7600037939542 | -122.446454694247 | (37.7600037939542, -122.446454694247) | |||
71253 | 71253 | 224621 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1321 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5999027.25079 | 2105080.82131 | 37.7600944087555 | -122.44645469424499 | (37.7600944087555, -122.446454694245) | |||
35969 | 35969 | 224619 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1324 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5999058.149540001 | 2104997.17372 | 37.75986649804889 | -122.446341813123 | (37.7598664980489, -122.446341813123) | |||
70766 | 70766 | 224620 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1316 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5999063.560769999 | 2105040.06353 | 37.759984571857 | -122.446326183806 | (37.759984571857, -122.446326183806) | |||
170317 | 170317 | 176404 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 332 Ellington Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5998751.95541 | 2087834.14028 | 37.712723399629 | -122.44616620971901 | (37.712723399629, -122.446166209719) | |||
40036 | 40036 | 176403 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 332 Ellington Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5998770.03746 | 2087851.6869599998 | 37.7127726114513 | -122.44610497396201 | (37.7127726114513, -122.446104973962) | |||
39271 | 39271 | 126617 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3001 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 5999428.93901 | 2119163.44026 | 37.798784587708504 | -122.446078403512 | (37.7987845877085, -122.446078403512) | |||
157131 | 157131 | 176402 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 332 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5998803.89987 | 2087884.3075400002 | 37.7128641138726 | -122.44599027982201 | (37.7128641138726, -122.445990279822) | |||
155045 | 155045 | 224625 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 50 Piedmont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5999457.54578 | 2107020.99028 | 37.7654461969099 | -122.44510599986602 | (37.7654461969099, -122.445105999866) | |||
165442 | 165442 | 224493 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 232 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999538.9593 | 2106236.29263 | 37.7632962596403 | -122.444768001354 | (37.7632962596403, -122.444768001354) | |||
87287 | 87287 | 65844 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | Permit Number 28834 | 5999811.44226859 | 2119196.23574668 | 37.798896470812004 | -122.44475718144301 | (37.798896470812, -122.444757181443) | ||
54897 | 54897 | 224611 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 525 Burnett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5999479.683569999 | 2102426.58534 | 37.752832360735205 | -122.44469916905399 | (37.7528323607352, -122.444699169054) | |||
177800 | 177800 | 224612 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 525 Burnett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999484.75601 | 2102435.63345 | 37.752857494093206 | -122.444682277976 | (37.7528574940932, -122.444682277976) | |||
185301 | 185301 | 224613 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 525 Burnett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999489.63243 | 2102445.2352299998 | 37.7528841365055 | -122.44466610455 | (37.7528841365055, -122.44466610455) | |||
29663 | 29663 | 224614 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 525 Burnett Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5999496.34966 | 2102468.38313 | 37.7529480782956 | -122.444644538818 | (37.7529480782956, -122.444644538818) | |||
44303 | 44303 | 224615 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 525 Burnett Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5999500.0818 | 2102479.1727400003 | 37.752977916897294 | -122.444632407852 | (37.7529779168973, -122.444632407852) | |||
50977 | 50977 | 224616 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 525 Burnett Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5999502.23945 | 2102489.21916 | 37.7530056250346 | -122.444625668335 | (37.7530056250346, -122.444625668335) | |||
149281 | 149281 | 57942 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 15 Byron Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776219 | 5999289.472159999 | 2086646.12526 | 37.7094920599881 | -122.44422306973499 | (37.7094920599881, -122.444223069735) | |
96992 | 96992 | 62435 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 297 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22596 | 5999684.09914601 | 2105294.09451438 | 37.760717499173396 | -122.44419830300801 | (37.7607174991734, -122.444198303008) | ||
20778 | 20778 | 22835 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 104 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1994 12:00:00 AM | 20 | 2X2 | 5999575.13645 | 2098938.39255 | 37.743260073094504 | -122.44411845071899 | (37.7432600730945, -122.444118450719) | ||
9891 | 9891 | 173730 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 387 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999535.0 | 2094919.0 | 37.7322214835803 | -122.443968498715 | (37.7322214835803, -122.443968498715) | ||||
146975 | 146975 | 224617 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 970 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999693.044980001 | 2101841.1304900004 | 37.7512370173901 | -122.44391926795299 | (37.7512370173901, -122.443919267953) | |||
157834 | 157834 | 57946 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 10 Byron Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 9 | Permit Number 16905 | 5999382.31979 | 2086721.86457 | 37.7097053198058 | -122.44390761184401 | (37.7097053198058, -122.443907611844) | ||
136604 | 136604 | 224627 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 601 Buena Vista Ave West | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5999834.58358 | 2107589.10397 | 37.767027607963904 | -122.443842736578 | (37.7670276079639, -122.443842736578) | |||
31967 | 31967 | 224626 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 601 Buena Vista Ave West | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5999843.00884 | 2107568.58853 | 37.7669717582745 | -122.443812120926 | (37.7669717582745, -122.443812120926) | |||
22195 | 22195 | 1351 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 271 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999796.36324 | 2099302.3291700003 | 37.7442719740833 | -122.443379644158 | (37.7442719740833, -122.443379644158) | |||
120508 | 120508 | 62442 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3090 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22605 | 5999929.32075843 | 2105305.0040382 | 37.7607614409418 | -122.443350977814 | (37.7607614409418, -122.443350977814) | ||
108632 | 108632 | 62436 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 227 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | 14 | 3x3 | Permit Number 772864 | 5999948.226671799 | 2105562.60505464 | 37.7614698277306 | -122.44330409370501 | (37.7614698277306, -122.443304093705) |
178436 | 178436 | 126616 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2660 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6000233.00854 | 2118542.38093 | 37.797125207219295 | -122.443251440404 | (37.7971252072193, -122.443251440404) | |||
168890 | 168890 | 61440 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2660 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1984 12:00:00 AM | 14 | Permit Number 21375 | 6000247.84617 | 2118544.3750299998 | 37.797131528551795 | -122.443200241996 | (37.7971315285518, -122.443200241996) | ||
187652 | 187652 | 218807 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 238 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5999815.8902199995 | 2094384.2804599998 | 37.7307692875673 | -122.44295901504299 | (37.7307692875673, -122.442959015043) | |||
174569 | 174569 | 218806 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 217 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999893.776380001 | 2094346.53737 | 37.730670094141296 | -122.44268704209 | (37.7306700941413, -122.44268704209) | |||
115226 | 115226 | 98913 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2088 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | Permit No. 49312 | 6000424.0 | 2115788.0 | 37.7895732892814 | -122.442392720884 | (37.7895732892814, -122.442392720884) | |||
51250 | 51250 | 99287 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2839 Pacific Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6000564.2 | 2116779.0 | 37.7923023065947 | -122.44197880493999 | (37.7923023065947, -122.44197880494) | |||||
124761 | 124761 | 99286 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2839 Pacific Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6000564.2 | 2116779.0 | 37.7923023065947 | -122.44197880493999 | (37.7923023065947, -122.44197880494) | |||||
87713 | 87713 | 107997 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2X Clover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | 6000451.13785 | 2105044.8413 | 37.760076841062 | -122.441527580895 | (37.760076841062, -122.441527580895) | ||||
11311 | 11311 | 25396 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 945 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6000465.251630001 | 2089064.76788 | 37.7162001220051 | -122.440332727576 | (37.7162001220051, -122.440332727576) | |||
38462 | 38462 | 176412 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6000489.461069999 | 2089401.4731400001 | 37.71712601723571 | -122.440273180786 | (37.7171260172357, -122.440273180786) | |||
110011 | 110011 | 58069 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4525 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1991 12:00:00 AM | Permit Number 30131 | 6000914.77254872 | 2105195.89592401 | 37.7605180033322 | -122.439934925187 | (37.7605180033322, -122.439934925187) | ||
23132 | 23132 | 25364 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 994 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000636.2417 | 2088870.0556299998 | 37.7156752201082 | -122.43972775363001 | (37.7156752201082, -122.43972775363) | |||
109763 | 109763 | 59623 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 445 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1988 12:00:00 AM | Permit Number 19030 | 6001158.23229918 | 2110194.44132426 | 37.7742566261049 | -122.43945123063101 | (37.7742566261049, -122.439451230631) | ||
182594 | 182594 | 224610 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 87 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000904.1974 | 2097866.66824 | 37.740393101855204 | -122.43944610755699 | (37.7403931018552, -122.439446107557) | |||
104854 | 104854 | 92018 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4182 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001163.0 | 2105841.0 | 37.7623034284238 | -122.439122658321 | (37.7623034284238, -122.439122658321) | ||||
115854 | 115854 | 66878 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 281 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30189 | 6001145.91509222 | 2104727.87963003 | 37.7592460999874 | -122.439101967223 | (37.7592460999874, -122.439101967223) | ||
131542 | 131542 | 176411 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 60 Onondaga Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000874.430240001 | 2091115.9770099998 | 37.72185556895379 | -122.43906533639601 | (37.7218555689538, -122.439065336396) | |||
17857 | 17857 | 66830 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 393 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1991 12:00:00 AM | Permit Number 30127 | 6001175.80343985 | 2104102.01378806 | 37.7575293253254 | -122.43895374638201 | (37.7575293253254, -122.438953746382) | ||
51721 | 51721 | 176410 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 60 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000924.6013400005 | 2091091.4970599997 | 37.7217912071684 | -122.438890154751 | (37.7217912071684, -122.438890154751) | |||
75200 | 75200 | 62505 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 800 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/1986 12:00:00 AM | 15 | Permit Number 22680 | 6000887.297669999 | 2089194.5830599999 | 37.716580586514795 | -122.43888323447901 | (37.7165805865148, -122.438883234479) | ||
108357 | 108357 | 62139 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 394 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | Permit Number 22347 | 6000980.72200275 | 2092487.56875551 | 37.7256276955072 | -122.43879615169399 | (37.7256276955072, -122.438796151694) | ||
162058 | 162058 | 37390 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 95 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 15 | Permit Number 41125 | 6000958.3691 | 2088020.2870200002 | 37.7133602752401 | -122.43855348637301 | (37.7133602752401, -122.438553486373) | |
56649 | 56649 | 176416 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 860 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000990.84724 | 2088839.6326 | 37.715611862882 | -122.438499899353 | (37.715611862882, -122.438499899353) | |||
149042 | 149042 | 176415 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 850 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001011.08243 | 2088875.9268 | 37.715712669668605 | -122.43843255632099 | (37.7157126696686, -122.438432556321) | |||
19453 | 19453 | 1923 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 78 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6001189.660619999 | 2097346.8097900003 | 37.7389819342562 | -122.43842185440901 | (37.7389819342562, -122.438421854409) | |||
180807 | 180807 | 176414 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 850 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001021.05329 | 2088894.2263099998 | 37.7157634831843 | -122.43839940283199 | (37.7157634831843, -122.438399402832) | |||
115455 | 115455 | 31210 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2736 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | Permit Number 34902 | 6001624.16755345 | 2117801.03750222 | 37.7951689006516 | -122.43838455687201 | (37.7951689006516, -122.438384556872) | |||
65572 | 65572 | 101289 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 830 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6001069.51096 | 2088976.2004099998 | 37.715991321918004 | -122.438237780259 | (37.715991321918, -122.438237780259) | ||||
181204 | 181204 | 176413 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 816 Lisbon St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6001088.39895 | 2089005.3588599998 | 37.7160724587542 | -122.43817458219999 | (37.7160724587542, -122.4381745822) | |||
152430 | 152430 | 58156 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 837 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1978 12:00:00 AM | 9 | Permit Number 17140 | 6001092.2872 | 2088918.12181 | 37.7158331464556 | -122.43815489694401 | (37.7158331464556, -122.438154896944) | ||
66428 | 66428 | 58153 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 816 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1978 12:00:00 AM | 2 | Permit Number 17137 | 6001098.08865 | 2089024.55935 | 37.7161257300936 | -122.438142464699 | (37.7161257300936, -122.438142464699) | ||
73083 | 73083 | 58152 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 806 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1978 12:00:00 AM | 11 | Permit Number 17136 | 6001116.27875 | 2089048.9565700002 | 37.716193753914105 | -122.43808133779699 | (37.7161937539141, -122.438081337797) | ||
148290 | 148290 | 176417 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 825 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6001125.807159999 | 2088973.54213 | 37.7159872246076 | -122.438043004189 | (37.7159872246076, -122.438043004189) | |||
63536 | 63536 | 58155 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 815 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1978 12:00:00 AM | 11 | Permit Number 17139 | 6001141.03185 | 2088999.4930099999 | 37.7160593457428 | -122.437992238373 | (37.7160593457428, -122.437992238373) | ||
127954 | 127954 | 50305 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1217@ ARMY Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/2003 12:00:00 AM | Permit Number 47015 | 6001375.35048187 | 2100228.68999583 | 37.74690545910129 | -122.43798619649401 | (37.7469054591013, -122.437986196494) | ||
161850 | 161850 | 58154 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 807 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1978 12:00:00 AM | 10 | Permit Number 17138 | 6001157.22948 | 2089029.0056 | 37.716141301843294 | -122.43793836449 | (37.7161413018433, -122.43793836449) | ||
181817 | 181817 | 66495 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2476 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 14 | Permit Number 772310 | 6001690.937999999 | 2114651.3348 | 37.78652442918529 | -122.437927807736 | (37.7865244291853, -122.437927807736) | |
129241 | 129241 | 101288 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3355X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001810.5 | 2119614.7 | 37.8001593395999 | -122.437869785341 | (37.8001593395999, -122.437869785341) | ||||
104494 | 104494 | 66311 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 140 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29426 | 6001329.17242898 | 2095394.93152934 | 37.7336304648573 | -122.43779972754601 | (37.7336304648573, -122.437799727546) | ||
137467 | 137467 | 58912 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2308 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/1980 12:00:00 AM | 18 | Permit Number 776948 | 6001885.650830001 | 2118771.72016 | 37.7978490112876 | -122.437549333047 | (37.7978490112876, -122.437549333047) | ||
110861 | 110861 | 63405 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4330 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/1987 12:00:00 AM | Permit Number 23987 | 6001641.42159443 | 2104703.75073536 | 37.7592080301488 | -122.43738654191799 | (37.7592080301488, -122.437386541918) | ||
89201 | 89201 | 63396 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4326 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/1987 12:00:00 AM | Permit Number 23978 | 6001653.34817436 | 2104704.40880226 | 37.759210515065 | -122.437345341266 | (37.759210515065, -122.437345341266) | ||
128053 | 128053 | 62137 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 127 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/31/1985 12:00:00 AM | Permit Number 22247 | 6001408.1074829 | 2092199.32717361 | 37.7248605551976 | -122.43729808771201 | (37.7248605551976, -122.437298087712) | ||
1622 | 1622 | 15770 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4770 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001421.7162 | 2091049.3752 | 37.721703820816394 | -122.43716874658399 | (37.7217038208164, -122.437168746584) | ||
87335 | 87335 | 63397 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4300 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | Permit Number 30165 | 6001730.87094671 | 2104708.68623731 | 37.759226666669505 | -122.437077536949 | (37.7592266666695, -122.437077536949) | ||
19276 | 19276 | 108963 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
83043 | 83043 | 108962 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");