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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106879 | 106879 | 67263 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 552 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | Permit Number 30730 | 5981340.11898895 | 2111976.56286736 | 37.778002010661105 | -122.508136768544 | (37.7780020106611, -122.508136768544) | ||
| 143537 | 143537 | 48492 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 789(REVISED) 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | Permit Number 45835 | 5984443.84017034 | 2110481.58351844 | 37.7740796289032 | -122.49728966782 | (37.7740796289032, -122.49728966782) | ||
| 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) | ||
| 93578 | 93578 | 63203 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2 Shore View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23745 | 5984685.41505479 | 2112889.29978003 | 37.78070467946971 | -122.496631747831 | (37.7807046794697, -122.496631747831) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 94180 | 94180 | 61525 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1341 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1989 12:00:00 AM | Permit Number 28272 | 5991348.55791434 | 2114747.92419088 | 37.7861960776153 | -122.47371658077299 | (37.7861960776153, -122.473716580773) | ||
| 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) | ||
| 79346 | 79346 | 63166 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1534 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23703 | 5992780.43210356 | 2105015.68842996 | 37.7595567946867 | -122.468054529997 | (37.7595567946867, -122.468054529997) | ||
| 104397 | 104397 | 65917 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1322 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28932 | 5994588.71634117 | 2106515.79856518 | 37.7637799716089 | -122.461909408356 | (37.7637799716089, -122.461909408356) | ||
| 124159 | 124159 | 65465 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 618 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1989 12:00:00 AM | Permit Number 28343 | 5994991.49008264 | 2091257.73775868 | 37.721908315427704 | -122.459411273619 | (37.7219083154277, -122.459411273619) | ||
| 118567 | 118567 | 65474 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1185 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1989 12:00:00 AM | Permit Number 28355 | 5995034.99249971 | 2091783.3730714 | 37.72335408532629 | -122.459298943633 | (37.7233540853263, -122.459298943633) | ||
| 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) | ||
| 134768 | 134768 | 30927 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 236 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34740 | 5996038.7385 | 2091232.9544799998 | 37.7219004244455 | -122.455789433158 | (37.7219004244455, -122.455789433158) | |
| 150299 | 150299 | 30926 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 230 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34739 | 5996065.71046 | 2091231.3003900002 | 37.7218974306099 | -122.455696079012 | (37.7218974306099, -122.455696079012) | |
| 101414 | 101414 | 66836 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2920 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1993 12:00:00 AM | Permit Number 30137 | 5997039.99678003 | 2111588.58372334 | 37.777849344501 | -122.453797573256 | (37.777849344501, -122.453797573256) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 139593 | 139593 | 64025 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 24782 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||
| 113951 | 113951 | 64051 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2362 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1987 12:00:00 AM | 18 | 3x3 | Permit Number 24809 | 6001958.39518673 | 2107077.48794504 | 37.765743748959295 | -122.436460191864 | (37.7657437489593, -122.436460191864) |
| 96257 | 96257 | 64024 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2356 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 24781 | 6001973.19869493 | 2107076.19337817 | 37.7657410355678 | -122.436408897131 | (37.7657410355678, -122.436408897131) | ||
| 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) | |||
| 97890 | 97890 | 104423 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2362 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 18 | 3x3 | Permit Number 24809 | 6002031.0 | 2107070.0 | 37.7657273142687 | -122.436208531898 | (37.7657273142687, -122.436208531898) | |
| 125826 | 125826 | 104403 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2362 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 18 | 3x3 | Permit Number 24809 | 6002031.0 | 2107070.0 | 37.7657273142687 | -122.436208531898 | (37.7657273142687, -122.436208531898) | |
| 87079 | 87079 | 63899 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 719 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1987 12:00:00 AM | Permit Number 24609 | 6002042.34774334 | 2110925.77664223 | 37.776314966213896 | -122.43644527379699 | (37.7763149662139, -122.436445273797) | ||
| 114220 | 114220 | 64019 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2321 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 24776 | 6002140.06473103 | 2107033.66278157 | 37.7656337371655 | -122.435828700932 | (37.7656337371655, -122.435828700932) | ||
| 92404 | 92404 | 55576 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2309 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 24775 | 6002194.69587728 | 2107036.79090461 | 37.76564542937879 | -122.43563996790199 | (37.7656454293788, -122.435639967902) | ||
| 116808 | 116808 | 66469 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 430 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1991 12:00:00 AM | Permit Number 29620 | 6002231.09425836 | 2109952.33731326 | 37.7736528678468 | -122.435722686817 | (37.7736528678468, -122.435722686817) | ||
| 91089 | 91089 | 65540 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2154 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1990 12:00:00 AM | 3x3 | Permit Number 28437 | 6002291.71421754 | 2114386.89695038 | 37.78583249572021 | -122.43583034619199 | (37.7858324957202, -122.435830346192) | |
| 126631 | 126631 | 66042 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 303 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/1990 12:00:00 AM | Permit Number 29081 | 6002303.92307718 | 2106443.08966771 | 37.7640214741501 | -122.43521970611201 | (37.7640214741501, -122.435219706112) | ||
| 20372 | 20372 | 65541 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2146 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1990 12:00:00 AM | Permit Number 28438 | 6002328.18536025 | 2114391.9672646 | 37.78584848917 | -122.43570452929701 | (37.78584848917, -122.435704529297) | ||
| 145722 | 145722 | 64807 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 74 Newburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25809 | 6002370.48571479 | 2099839.6903707 | 37.7458938988463 | -122.434517304917 | (37.7458938988463, -122.434517304917) | ||
| 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) | ||
| 116705 | 116705 | 63853 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1482 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24552 | 6002495.53817147 | 2111986.73822711 | 37.7792538422906 | -122.43495345893999 | (37.7792538422906, -122.43495345894) | ||
| 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) | ||
| 105276 | 105276 | 63854 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1437 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24553 | 6002713.14606438 | 2111964.58520586 | 37.779205368769 | -122.434199079816 | (37.779205368769, -122.434199079816) | ||
| 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) | ||
| 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) | ||
| 109294 | 109294 | 65199 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 393 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 27185 | 6003086.32595187 | 2091584.19795725 | 37.723266808431795 | -122.431452793676 | (37.7232668084318, -122.431452793676) | ||
| 140644 | 140644 | 63877 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 849 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24582 | 6003121.89544563 | 2103305.24261692 | 37.7554521151946 | -122.43216648149799 | (37.7554521151946, -122.432166481498) | ||
| 119790 | 119790 | 59572 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 893 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1991 12:00:00 AM | Permit Number 24583 | 6003136.10237421 | 2103049.36160406 | 37.7547503322276 | -122.43209907763901 | (37.7547503322276, -122.432099077639) | ||
| 141054 | 141054 | 63876 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 493 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24580 | 6003154.01696483 | 2103272.14676469 | 37.755363063005206 | -122.432053032269 | (37.7553630630052, -122.432053032269) | ||
| 143227 | 143227 | 63772 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1134 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24451 | 6003162.44517655 | 2101626.56141002 | 37.750845152832206 | -122.431906388672 | (37.7508451528322, -122.431906388672) | ||
| 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) | ||
| 144547 | 144547 | 51017 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 464 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2004 12:00:00 AM | Permit Number 47495 | 6003323.42861905 | 2103333.57669245 | 37.75554133817 | -122.43147154109501 | (37.75554133817, -122.431471541095) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 98302 | 98302 | 63872 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 426 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24575 | 6003557.23375757 | 2103346.48170692 | 37.7555900208672 | -122.43066389151699 | (37.7555900208672, -122.430663891517) | ||
| 85639 | 85639 | 66379 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 625 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | Permit Number 29504 | 6003563.84234841 | 2110464.21135378 | 37.7751339598215 | -122.431149051781 | (37.7751339598215, -122.431149051781) | ||
| 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) | ||
| 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) | ||
| 83797 | 83797 | 60434 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 461 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/07/1987 12:00:00 AM | Permit Number 24099 | 6003594.47944671 | 2098910.74347696 | 37.7434126315981 | -122.43021864419201 | (37.7434126315981, -122.430218644192) | ||
| 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) | ||
| 79447 | 79447 | 66438 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 650X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1991 12:00:00 AM | Permit Number 29582 | 6003603.61647971 | 2110556.18401653 | 37.7753887478808 | -122.43101802993601 | (37.7753887478808, -122.431018029936) | ||
| 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) | ||
| 96682 | 96682 | 66375 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 612 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | Permit Number 29499 | 6003620.76837837 | 2110432.17499844 | 37.775049221566206 | -122.430949845165 | (37.7750492215662, -122.430949845165) | ||
| 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) | ||
| 97049 | 97049 | 66374 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 600 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | Permit Number 29498 | 6003626.18476729 | 2110393.01425684 | 37.7749420027203 | -122.430928313262 | (37.7749420027203, -122.430928313262) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 122183 | 122183 | 60432 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 447 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1992 12:00:00 AM | Permit Number 31498 | 6003680.70369729 | 2098915.54804456 | 37.7434307072212 | -122.42992084535 | (37.7434307072212, -122.42992084535) | ||
| 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) | ||
| 103274 | 103274 | 67815 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 967 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31469 | 6003802.17585758 | 2102641.49083741 | 37.7536681560563 | -122.42976652391701 | (37.7536681560563, -122.429766523917) | ||
| 96095 | 96095 | 31350 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34960 | 6003828.78534548 | 2110731.50789971 | 37.7758829003399 | -122.43025162922702 | (37.7758829003399, -122.430251629227) | ||
| 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) | ||
| 17978 | 17978 | 59647 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 100 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1987 12:00:00 AM | 6x9 | Permit Number 24228 | 6003848.70238053 | 2108788.55742661 | 37.770549162658895 | -122.43004409806002 | (37.7705491626589, -122.43004409806) |
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");