Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 72482 | 72482 | 116841 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2344 15TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 24 | 6002015.0 | 2107091.0 | 37.7657840660528 | -122.436265375372 | (37.7657840660528, -122.436265375372) | |||
| 75077 | 75077 | 78716 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 412 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | 7 | 6008662.0794 | 2088043.1280200002 | 37.7138582091656 | -122.41192829456699 | (37.7138582091656, -122.411928294567) | ||
| 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) | ||||
| 88381 | 88381 | 108965 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 107771 | 107771 | 116773 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 400 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6004132.01414207 | 2101578.81224199 | 37.7507689616906 | -122.42855012672399 | (37.7507689616906, -122.428550126724) | ||||
| 110078 | 110078 | 108964 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 114409 | 114409 | 114807 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2811 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6004778.36642477 | 2119194.00734605 | 37.799172543824504 | -122.427569823594 | (37.7991725438245, -122.427569823594) | ||||
| 125939 | 125939 | 114806 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2811 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6004778.36642477 | 2119194.00734605 | 37.799172543824504 | -122.427569823594 | (37.7991725438245, -122.427569823594) | ||||
| 128320 | 128320 | 121150 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1918 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 24 | 6004687.86766006 | 2107227.29036829 | 37.766309789844996 | -122.42703019928601 | (37.766309789845, -122.427030199286) | |||
| 143551 | 143551 | 111900 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 650X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2016 12:00:00 AM | 3 | 6003603.61647971 | 2110556.18401653 | 37.7753887478808 | -122.43101802993601 | (37.7753887478808, -122.431018029936) | ||
| 99208 | 99208 | 56883 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 229 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1986 12:00:00 AM | Permit Number 14121 | 6003628.47766901 | 2109141.87347388 | 37.7715068072846 | -122.430831075204 | (37.7715068072846, -122.430831075204) | ||
| 101844 | 101844 | 56884 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 219 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1986 12:00:00 AM | Permit Number 14122 | 6003674.18790761 | 2109148.24088129 | 37.771526880372 | -122.430673415548 | (37.771526880372, -122.430673415548) | ||
| 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) | ||
| 97042 | 97042 | 59954 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 559 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | Permit Number 19431 | 6005185.88290556 | 2110921.14903305 | 37.7764803824816 | -122.42557057591002 | (37.7764803824816, -122.42557057591) | ||
| 91026 | 91026 | 59961 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 444 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | Permit Number 19440 | 6005671.77527769 | 2111387.84010103 | 37.7777892453109 | -122.4239229277 | (37.7777892453109, -122.4239229277) | ||
| 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) | |
| 71516 | 71516 | 60144 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1614 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19674 | 5990908.81036863 | 2104400.55481137 | 37.7577595366377 | -122.47448257143101 | (37.7577595366377, -122.474482571431) | ||
| 78841 | 78841 | 60152 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1790 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19683 | 5990948.80079989 | 2103226.18449464 | 37.7545373426794 | -122.47425857753299 | (37.7545373426794, -122.474258577533) | ||
| 96162 | 96162 | 60279 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 890 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1982 12:00:00 AM | Permit Number 19841 | 6007951.11915857 | 2102749.5563076 | 37.7541989479338 | -122.415426159541 | (37.7541989479338, -122.415426159541) | ||
| 140276 | 140276 | 60290 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2915 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1982 12:00:00 AM | Permit Number 19854 | 6009379.15115854 | 2102740.05515277 | 37.754253020662105 | -122.41048698011002 | (37.7542530206621, -122.41048698011) | ||
| 111175 | 111175 | 60292 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2902 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1982 12:00:00 AM | Permit Number 19857 | 6009437.54414231 | 2102795.33502096 | 37.754408080201294 | -122.410288944543 | (37.7544080802013, -122.410288944543) | ||
| 144201 | 144201 | 60542 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 615 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20152 | 5985331.57099648 | 2111677.45152223 | 37.7774151286277 | -122.494307063797 | (37.7774151286277, -122.494307063797) | ||
| 89083 | 89083 | 60549 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 523 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20159 | 5985000.44766821 | 2112307.598992 | 37.7791259492381 | -122.495498998876 | (37.7791259492381, -122.495498998876) | ||
| 90109 | 90109 | 60554 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 562 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20164 | 5985061.1383554 | 2112041.58145553 | 37.7783990952425 | -122.49526942507799 | (37.7783990952425, -122.495269425078) | ||
| 122713 | 122713 | 60714 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 21 Oakwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1989 12:00:00 AM | Permit Number 20367 | 6005264.975818 | 2105333.47768938 | 37.761142446432096 | -122.424899339668 | (37.7611424464321, -122.424899339668) | ||
| 64064 | 64064 | 60829 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 82 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20508 | 6004586.81845905 | 2101649.91280729 | 37.7509899147675 | -122.42698243599199 | (37.7509899147675, -122.426982435992) | ||
| 84789 | 84789 | 57103 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3743 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20509 | 6004792.79553424 | 2102485.90723803 | 37.7532970057744 | -122.426329661558 | (37.7532970057744, -122.426329661558) | ||
| 102308 | 102308 | 54295 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3761 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20600 | 6004679.68604313 | 2102479.51319776 | 37.7532730549459 | -122.426720362353 | (37.7532730549459, -122.426720362353) | ||
| 126670 | 126670 | 60830 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 282 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | 22 | Permit Number 20603 | 6004748.95976393 | 2102035.39189802 | 37.7520575177016 | -122.42644917929199 | (37.7520575177016, -122.426449179292) | |
| 85577 | 85577 | 60831 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 205 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20604 | 6004778.44666437 | 2102471.31049199 | 37.753256115419504 | -122.426378243722 | (37.7532561154195, -122.426378243722) | ||
| 95847 | 95847 | 60832 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 210 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20605 | 6004728.24272246 | 2102435.29497545 | 37.7531543871846 | -122.42654929494499 | (37.7531543871846, -122.426549294945) | ||
| 103549 | 103549 | 60834 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 233 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20607 | 6004786.50329151 | 2102315.79263057 | 37.752829555056 | -122.426339310434 | (37.752829555056, -122.426339310434) | ||
| 140325 | 140325 | 60835 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 237 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20608 | 6004787.65423878 | 2102293.57578284 | 37.752768617829105 | -122.42633374857 | (37.7527686178291, -122.42633374857) | ||
| 87072 | 87072 | 60836 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 253 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20609 | 6004792.25802571 | 2102204.70843345 | 37.7525248690267 | -122.426311501214 | (37.7525248690267, -122.426311501214) | ||
| 102917 | 102917 | 60837 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 255 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20610 | 6004792.83349827 | 2102193.60003035 | 37.7524944004681 | -122.426308720309 | (37.7524944004681, -122.426308720309) | ||
| 83249 | 83249 | 60838 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 261 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20611 | 6004794.55991917 | 2102160.27475876 | 37.75240299462 | -122.426300377591 | (37.75240299462, -122.426300377591) | ||
| 87662 | 87662 | 60839 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 271 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20613 | 6004797.43728628 | 2102104.7326602 | 37.7522506515925 | -122.42628647311301 | (37.7522506515925, -122.426286473113) | ||
| 89556 | 89556 | 60840 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 315 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20614 | 6004809.28697134 | 2101883.59513704 | 37.7516441291888 | -122.426229752639 | (37.7516441291888, -122.426229752639) | ||
| 92970 | 92970 | 54514 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1221 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 20683 | 5995443.00414725 | 2107246.09430383 | 37.7658343190377 | -122.459007589279 | (37.7658343190377, -122.459007589279) | ||
| 108706 | 108706 | 61139 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2128 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | Permit Number 20991 | 5997627.50212199 | 2110268.03572246 | 37.774257127748605 | -122.45166991589599 | (37.7742571277486, -122.451669915896) | ||
| 125427 | 125427 | 61140 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2132 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | Permit Number 20992 | 5997609.15376905 | 2110265.51143343 | 37.7742491458885 | -122.451733203729 | (37.7742491458885, -122.451733203729) | ||
| 97471 | 97471 | 61306 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1494 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1984 12:00:00 AM | Permit Number 21205 | 6011999.58311152 | 2101400.41872379 | 37.7507212274206 | -122.401330679383 | (37.7507212274206, -122.401330679383) | ||
| 118038 | 118038 | 61309 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2325 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1984 12:00:00 AM | Permit Number 21208 | 6011929.28683038 | 2101842.72936764 | 37.7519317939639 | -122.40160485558998 | (37.7519317939639, -122.40160485559) | ||
| 116589 | 116589 | 61310 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2337 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1984 12:00:00 AM | Permit Number 21209 | 6011897.61971652 | 2101840.97458612 | 37.7519252086186 | -122.4017142423 | (37.7519252086186, -122.4017142423) | ||
| 89586 | 89586 | 56750 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 100 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/1985 12:00:00 AM | Permit Number 21307 | 6002862.2859563 | 2108898.25983772 | 37.770794463527395 | -122.433463958699 | (37.7707944635274, -122.433463958699) | ||
| 117709 | 117709 | 61473 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1918 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1984 12:00:00 AM | 24 | Permit Number 21416 | 6004687.86766006 | 2107227.29036829 | 37.766309789844996 | -122.42703019928601 | (37.766309789845, -122.427030199286) | |
| 124268 | 124268 | 61474 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1960 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1984 12:00:00 AM | Permit Number 21417 | 6004396.86379546 | 2107211.14447839 | 37.766248997560204 | -122.428035576337 | (37.7662489975602, -122.428035576337) | ||
| 101209 | 101209 | 61524 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 5301 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1984 12:00:00 AM | Permit Number 21481 | 5991172.88177213 | 2114060.20768973 | 37.784297623281105 | -122.474274166868 | (37.7842976232811, -122.474274166868) | ||
| 141827 | 141827 | 61526 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1335 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1984 12:00:00 AM | Permit Number 21483 | 5991367.33157346 | 2114748.57792616 | 37.7861989598694 | -122.47365167719 | (37.7861989598694, -122.47365167719) | ||
| 140344 | 140344 | 61704 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 560 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1984 12:00:00 AM | Permit Number 21703 | 6005065.62335195 | 2107833.77826085 | 37.7679964138535 | -122.42576678516001 | (37.7679964138535, -122.42576678516) | ||
| 78837 | 78837 | 61705 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 57 Rosemont Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1984 12:00:00 AM | Permit Number 21704 | 6005150.34156307 | 2107947.67774505 | 37.768313941532604 | -122.42548186081999 | (37.7683139415326, -122.42548186082) | ||
| 86479 | 86479 | 61708 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 580 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1984 12:00:00 AM | Permit Number 21707 | 6004928.75046121 | 2107826.22237424 | 37.767967931643 | -122.426239675726 | (37.767967931643, -122.426239675726) | ||
| 80440 | 80440 | 61710 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1975 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1984 12:00:00 AM | Permit Number 21709 | 6004910.69371619 | 2108330.79575039 | 37.7693523480889 | -122.426338061309 | (37.7693523480889, -122.426338061309) | ||
| 100167 | 100167 | 61712 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 239 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1984 12:00:00 AM | Permit Number 21712 | 6005177.32533199 | 2108193.82077345 | 37.768991315779 | -122.42540604522301 | (37.768991315779, -122.425406045223) | ||
| 107957 | 107957 | 61713 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 269 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1984 12:00:00 AM | Permit Number 21713 | 6004998.47961276 | 2108183.57904333 | 37.7689530882522 | -122.42602393241998 | (37.7689530882522, -122.42602393242) | ||
| 115227 | 115227 | 61714 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 236 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1984 12:00:00 AM | Permit Number 21714 | 6005186.2754150005 | 2108246.41850013 | 37.7691362421663 | -122.425378830956 | (37.7691362421663, -122.425378830956) | ||
| 83967 | 83967 | 61715 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 281 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1984 12:00:00 AM | Permit Number 21715 | 6004926.94134289 | 2108179.4823523 | 37.7689377963385 | -122.42627108706002 | (37.7689377963385, -122.42627108706) | ||
| 83414 | 83414 | 61716 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 271 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1984 12:00:00 AM | Permit Number 21716 | 6004986.55656035 | 2108182.89626107 | 37.7689505396343 | -122.426065124893 | (37.7689505396343, -122.426065124893) | ||
| 113862 | 113862 | 61717 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 126 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1984 12:00:00 AM | Permit Number 21717 | 6005390.65318574 | 2108294.55770451 | 37.7692799656993 | -122.42467532414801 | (37.7692799656993, -122.424675324148) | ||
| 108005 | 108005 | 61725 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 66 Williams Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | Permit Number 21727 | 6013825.41276045 | 2093670.69143799 | 37.7295987054368 | -122.394475571882 | (37.7295987054368, -122.394475571882) | ||
| 101030 | 101030 | 61727 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 106 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21732 | 6004453.38447501 | 2101057.16682643 | 37.7493548261549 | -122.42740164255501 | (37.7493548261549, -122.427401642555) | ||
| 144927 | 144927 | 61728 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 121 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21733 | 6004369.94753879 | 2101000.29060373 | 37.7491939379116 | -122.427686117612 | (37.7491939379116, -122.427686117612) | ||
| 113402 | 113402 | 61731 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1250 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21736 | 6003842.20340405 | 2100987.35465575 | 37.7491285523468 | -122.42951014206001 | (37.7491285523468, -122.42951014206) | ||
| 138743 | 138743 | 61732 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 184 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21737 | 6003971.9147598 | 2101029.52294751 | 37.7492516799815 | -122.429064604837 | (37.7492516799815, -122.429064604837) | ||
| 97456 | 97456 | 61733 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1352 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21738 | 6004486.387982 | 2101012.81721841 | 37.7492349189645 | -122.42728435687401 | (37.7492349189645, -122.427284356874) | ||
| 113098 | 113098 | 61734 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 264 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21739 | 6003453.08659842 | 2101001.58454059 | 37.7491455850179 | -122.430856727417 | (37.7491455850179, -122.430856727417) | ||
| 139164 | 139164 | 61735 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 246 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21740 | 6003563.88991247 | 2101007.45012611 | 37.74916796792179 | -122.430473986745 | (37.7491679679218, -122.430473986745) | ||
| 109220 | 109220 | 61739 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 232 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21744 | 6003650.07025761 | 2101012.01224764 | 37.749185375985604 | -122.43017629943199 | (37.7491853759856, -122.430176299432) | ||
| 17973 | 17973 | 61740 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 219 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21745 | 6003738.99947337 | 2100964.64707663 | 37.7490603587459 | -122.42986540291099 | (37.7490603587459, -122.429865402911) | ||
| 107287 | 107287 | 61741 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 175 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21746 | 6004036.62237664 | 2100981.15253515 | 37.7491225287463 | -122.428837396831 | (37.7491225287463, -122.428837396831) | ||
| 54632 | 54632 | 61750 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3235 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1984 12:00:00 AM | Permit Number 21761 | 6005283.427251 | 2106614.91851966 | 37.7646620214784 | -122.424926696656 | (37.7646620214784, -122.424926696656) | ||
| 139021 | 139021 | 61751 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1839 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1984 12:00:00 AM | Permit Number 21762 | 6005280.05550322 | 2107208.06692616 | 37.7662904752312 | -122.424980563467 | (37.7662904752312, -122.424980563467) | ||
| 105138 | 105138 | 61754 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3208 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1984 12:00:00 AM | Permit Number 21766 | 6005459.89972761 | 2106676.78980679 | 37.764841871773896 | -122.424320725398 | (37.7648418717739, -122.424320725398) | ||
| 86617 | 86617 | 61763 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 390 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1984 12:00:00 AM | Permit Number 21777 | 6005479.130443 | 2106713.50276565 | 37.764943762720705 | -122.424256822517 | (37.7649437627207, -122.424256822517) | ||
| 102612 | 102612 | 61431 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 682 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1985 12:00:00 AM | Permit Number 22021 | 6002437.42157042 | 2108855.24055446 | 37.7706522292485 | -122.434930494274 | (37.7706522292485, -122.434930494274) | ||
| 86321 | 86321 | 62088 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 474 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1985 12:00:00 AM | Permit Number 22174 | 6013214.9408475 | 2104861.98073646 | 37.7602936588903 | -122.397370564655 | (37.7602936588903, -122.397370564655) | ||
| 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) | ||
| 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) | ||
| 50097 | 50097 | 62304 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2504 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | Permit Number 22442 | 5997225.79467532 | 2110840.29768365 | 37.7758053966105 | -122.45310080621901 | (37.7758053966105, -122.453100806219) | ||
| 127827 | 127827 | 62333 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 54 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | Permit Number 22475 | 6005123.90294191 | 2096395.98906268 | 37.7365941933288 | -122.42475141936701 | (37.7365941933288, -122.424751419367) | ||
| 90592 | 90592 | 62334 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 66 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | Permit Number 22476 | 6005174.05627534 | 2096389.57268342 | 37.7365794079222 | -122.424577561345 | (37.7365794079222, -122.424577561345) | ||
| 127257 | 127257 | 62335 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 88 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | Permit Number 22477 | 6005278.45102522 | 2096412.38253023 | 37.7366479337699 | -122.424218245392 | (37.7366479337699, -122.424218245392) | ||
| 81299 | 81299 | 62352 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 102 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22496 | 6005217.58297735 | 2099637.57957653 | 37.745500157100295 | -122.424658053081 | (37.7455001571003, -122.424658053081) | ||
| 101311 | 101311 | 62353 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 113 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | 18 | Permit Number 22497 | 6005157.02914158 | 2099582.1696783 | 37.7453445941022 | -122.42486349755501 | (37.7453445941022, -122.424863497555) | |
| 126738 | 126738 | 62357 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 172 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22501 | 6004773.71147679 | 2099613.16071739 | 37.745408029937 | -122.42619115384701 | (37.745408029937, -122.426191153847) | ||
| 88721 | 88721 | 62360 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 198 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22505 | 6004608.84494602 | 2099604.09085689 | 37.7453738062021 | -122.426760590215 | (37.7453738062021, -122.426760590215) | ||
| 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) | ||
| 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) | ||
| 116903 | 116903 | 62604 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 796 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | Permit Number 22912 | 5984497.70797117 | 2110431.26743747 | 37.773944632299205 | -122.497099617838 | (37.7739446322992, -122.497099617838) | ||
| 77562 | 77562 | 62653 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 250 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1986 12:00:00 AM | Permit Number 22975 | 6003520.74083492 | 2109179.36788903 | 37.771603653022794 | -122.431206419247 | (37.7716036530228, -122.431206419247) | ||
| 123926 | 123926 | 62428 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 223 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1986 12:00:00 AM | Permit Number 22976 | 6003655.90381046 | 2109145.69391809 | 37.7715188511616 | -122.430736479427 | (37.7715188511616, -122.430736479427) | ||
| 122279 | 122279 | 56880 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 260 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1986 12:00:00 AM | Permit Number 22991 | 6003475.03058778 | 2109173.00048042 | 37.771583579219204 | -122.431364078952 | (37.7715835792192, -122.431364078952) | ||
| 111323 | 111323 | 56882 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 228 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1986 12:00:00 AM | Permit Number 22996 | 6003621.30337351 | 2109193.37618724 | 37.7716478146462 | -122.43085956761401 | (37.7716478146462, -122.430859567614) | ||
| 19840 | 19840 | 60045 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 235 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1986 12:00:00 AM | Permit Number 22998 | 6003601.05151902 | 2109138.05302848 | 37.7714947633279 | -122.43092567098101 | (37.7714947633279, -122.430925670981) | ||
| 138408 | 138408 | 60193 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 236 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1986 12:00:00 AM | Permit Number 22999 | 6003584.73517067 | 2109188.28225965 | 37.771631755989 | -122.43098569555201 | (37.771631755989, -122.430985695552) | ||
| 112645 | 112645 | 62668 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 275 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1986 12:00:00 AM | Permit Number 23000 | 6003418.21056461 | 2109112.58339882 | 37.771414468363204 | -122.43155630855 | (37.7714144683632, -122.43155630855) | ||
| 100744 | 100744 | 62669 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 299 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/1992 12:00:00 AM | Permit Number 23001 | 6003308.50596463 | 2109097.30161721 | 37.7713662897526 | -122.43193469053101 | (37.7713662897526, -122.431934690531) | ||
| 94045 | 94045 | 62670 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1328 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1986 12:00:00 AM | Permit Number 23002 | 6002790.04269178 | 2111680.73625558 | 37.7784303546549 | -122.43391276835101 | (37.7784303546549, -122.433912768351) | ||
| 123836 | 123836 | 62680 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 654 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1986 12:00:00 AM | Permit Number 23014 | 6002561.35247931 | 2108872.24257196 | 37.7707059484007 | -122.43450303191901 | (37.7707059484007, -122.434503031919) |
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");