Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
11475 | 11475 | 13369 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 900 Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X50 | 6009189.31279 | 2090017.3428599997 | 37.71930856033371 | -122.410245275395 | (37.7193085603337, -122.410245275395) | |||
14200 | 14200 | 26002 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6014429.78226 | 2095903.68978 | 37.7357636437757 | -122.392542323281 | (37.7357636437757, -122.392542323281) | |||
20707 | 20707 | 24450 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1384 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006415.18821 | 2101529.37673 | 37.7507621663522 | -122.42065118602301 | (37.7507621663522, -122.420651186023) | |||
24936 | 24936 | 250316 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3828 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995936.88043 | 2115877.7469599997 | 37.7895629358285 | -122.457924081037 | (37.7895629358285, -122.457924081037) | |||
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) | |||
25337 | 25337 | 250803 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 283 31st Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986183.75415 | 2114029.47113 | 37.7839229338472 | -122.491532293599 | (37.7839229338472, -122.491532293599) | |||
25991 | 25991 | 251008 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3878 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995662.214869999 | 2115838.76904 | 37.7894401289022 | -122.45887156539499 | (37.7894401289022, -122.458871565395) | |||
26601 | 26601 | 224669 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009345.52709 | 2104457.09364 | 37.758965736194504 | -122.410724513338 | (37.7589657361945, -122.410724513338) | |||
31299 | 31299 | 176423 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 538 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009799.11271 | 2092612.1001799998 | 37.726467385945 | -122.408320334118 | (37.726467385945, -122.408320334118) | |||
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) | |||
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) | |||
32870 | 32870 | 224543 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3257 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6006596.438630001 | 2103760.0556900003 | 37.7568973116766 | -122.420182701267 | (37.7568973116766, -122.420182701267) | |||
33319 | 33319 | 218811 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 75 Williar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997101.63162 | 2090622.46989 | 37.7202851197392 | -122.45207127696999 | (37.7202851197392, -122.45207127697) | |||
33898 | 33898 | 224685 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3513 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006366.00015 | 2101408.94489 | 37.7504287157262 | -122.420812733918 | (37.7504287157262, -122.420812733918) | |||
33917 | 33917 | 224641 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 14 Powers Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006763.87284 | 2099814.11824 | 37.7460721011655 | -122.41932373541901 | (37.7460721011655, -122.419323735419) | |||
35607 | 35607 | 224556 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3361 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007831.17362 | 2104415.66296 | 37.7587669536521 | -122.415958939967 | (37.7587669536521, -122.415958939967) | |||
37859 | 37859 | 224591 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3117 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006001.0018 | 2106651.39278 | 37.7648026771212 | -122.42244738485701 | (37.7648026771212, -122.422447384857) | |||
38769 | 38769 | 35237 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1198 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | Permit Number 38733 | 6007256.149780001 | 2119525.9627099996 | 37.8002238465228 | -122.419019384135 | (37.8002238465228, -122.419019384135) | |
41825 | 41825 | 226490 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2450 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008822.75268 | 2104167.00903 | 37.758139904958206 | -122.412512013916 | (37.7581399049582, -122.412512013916) | |||
43163 | 43163 | 249545 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 298 Myrtle St | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6006121.634219999 | 2114038.6036799997 | 37.7850929805917 | -122.42255511555099 | (37.7850929805917, -122.422555115551) | |||
43555 | 43555 | 224584 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008542.99689 | 2106795.22797 | 37.76534068665 | -122.41366542593799 | (37.76534068665, -122.413665425938) | |||
44217 | 44217 | 224657 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 710 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007803.71411 | 2097712.0639400003 | 37.740358836792495 | -122.415579287554 | (37.7403588367925, -122.415579287554) | |||
46243 | 46243 | 224511 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1117 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6009227.24206 | 2102557.50534 | 37.7537432624556 | -122.410999428875 | (37.7537432624556, -122.410999428875) | |||
47182 | 47182 | 224514 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 439 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007856.97968 | 2105196.19408 | 37.760911563330296 | -122.415924962689 | (37.7609115633303, -122.415924962689) | |||
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) | ||||
48220 | 48220 | 218820 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 205 Beverly St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5991411.7286 | 2090565.37313 | 37.7198007772708 | -122.471735048829 | (37.7198007772708, -122.471735048829) | |||
49218 | 49218 | 224525 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 145 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006711.819209999 | 2102941.19607 | 37.7546554124388 | -122.419725571382 | (37.7546554124388, -122.419725571382) | |||
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) | |||
55616 | 55616 | 226483 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3470 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006409.05576 | 2104966.19294 | 37.7601985241524 | -122.420916373596 | (37.7601985241524, -122.420916373596) | |||
56084 | 56084 | 224631 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 667 Moultrie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007655.79797 | 2096256.88725 | 37.73635492642521 | -122.415987700275 | (37.7363549264252, -122.415987700275) | |||
65026 | 65026 | 224689 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3514 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006377.96332 | 2101451.22022 | 37.7505454684046 | -122.420774365244 | (37.7505454684046, -122.420774365244) | |||
66195 | 66195 | 101056 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 746 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008144.0 | 2114503.0 | 37.786481984518396 | -122.415591235338 | (37.7864819845184, -122.415591235338) | |||
68273 | 68273 | 224547 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3381 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007651.432 | 2104404.91293 | 37.758727329511 | -122.416579809432 | (37.758727329511, -122.416579809432) | |||
71668 | 71668 | 224681 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1390 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6006415.878380001 | 2101496.97772 | 37.7506732449771 | -122.42064649965499 | (37.7506732449771, -122.420646499655) | |||
72056 | 72056 | 199433 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1400 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6014453.55095 | 2095806.16281 | 37.7354971746608 | -122.39245332546601 | (37.7354971746608, -122.392453325466) | |||
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) | |||
77470 | 77470 | 101054 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 760 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008077.0 | 2114493.0 | 37.7864507606031 | -122.41582233096099 | (37.7864507606031, -122.415822330961) | |||
78322 | 78322 | 33615 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 312 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.42604905489999 | (37.7741722139784, -122.4260490549) | |||
79146 | 79146 | 110117 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 160x PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010076.0 | 2121146.0 | 37.8048304537654 | -122.409375949631 | (37.8048304537654, -122.409375949631) | ||||
79998 | 79998 | 115675 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 650 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5988846.1 | 2110886.2 | 37.7754476168018 | -122.482091316315 | (37.7754476168018, -122.482091316315) | |||||
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) | ||||
84518 | 84518 | 101285 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1236 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 11316 | 5993350.8 | 2107040.7 | 37.7651498684815 | -122.466229094974 | (37.7651498684815, -122.466229094974) | |||
85365 | 85365 | 30533 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
87790 | 87790 | 32047 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 501 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610.0 | 2086139.0 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | ||
88976 | 88976 | 99115 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1200x KEARNY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011163.0 | 2119066.0 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | ||||
91896 | 91896 | 33764 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1580 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | |||
92014 | 92014 | 103152 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2190X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002428.2 | 2119190.0 | 37.799028330156204 | -122.43570190483601 | (37.7990283301562, -122.435701904836) | ||||
95737 | 95737 | 98531 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 701X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991613.7 | 2110635.6 | 37.77492011755329 | -122.472499350726 | (37.7749201175533, -122.472499350726) | ||||
95951 | 95951 | 97189 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 255 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | |||
98701 | 98701 | 99964 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2439 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769385 | 6003671.0 | 2116729.0 | 37.7923415699538 | -122.431225642925 | (37.7923415699538, -122.431225642925) | ||||
103877 | 103877 | 121142 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 100x Rutledge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 9x6 | 6010389.0 | 2099533.0 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | |||
103906 | 103906 | 48039 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3350 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | |||
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) | ||||
105170 | 105170 | 98986 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 847 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009438.4 | 2115684.0 | 37.789797399949606 | -122.411196371815 | (37.7897973999496, -122.411196371815) | ||||
105201 | 105201 | 34148 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
105221 | 105221 | 99176 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 300x BEACH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008712.0 | 2122248.0 | 37.8077797512209 | -122.414174245084 | (37.8077797512209, -122.414174245084) | ||||
106386 | 106386 | 116389 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | ||||
106430 | 106430 | 98025 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1633 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988173.0 | 2098960.0 | 37.742662336498604 | -122.48354516443199 | (37.7426623364986, -122.483545164432) | ||||
106522 | 106522 | 33651 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 284 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | |||
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) | ||||
108270 | 108270 | 33611 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 310 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.774176257824394 | -122.42601725751001 | (37.7741762578244, -122.42601725751) | |||
108609 | 108609 | 101519 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 15X Bellair Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769472 | 6010051.6 | 2121037.7 | 37.8045317217453 | -122.409452740826 | (37.8045317217453, -122.409452740826) | |||
110473 | 110473 | 101515 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 610 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 28301 | 6008387.0 | 2114552.0 | 37.7866301828456 | -122.414753982265 | (37.7866301828456, -122.414753982265) | ||
111715 | 111715 | 33610 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 308 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.774180301661794 | -122.42598546011699 | (37.7741803016618, -122.425985460117) | |||
116256 | 116256 | 32039 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3653 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1995 12:00:00 AM | Permit Number 35422 | 6003092.33534727 | 2120827.43015376 | 37.803561986725505 | -122.43352085652398 | (37.8035619867255, -122.433520856524) | |||
118250 | 118250 | 52858 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2260on VALLEJO Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.796344678332794 | -122.42333957744499 | (37.7963446783328, -122.423339577445) | |||
119749 | 119749 | 107384 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 73 HILL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9x6 | 6005896.4 | 2103362.0 | 37.7557648742481 | -122.422575414787 | (37.7557648742481, -122.422575414787) | ||||
121898 | 121898 | 33589 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 180 Bonview St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37696 | 6007052.84530249 | 2097996.95756942 | 37.7410988557538 | -122.41819569379 | (37.7410988557538, -122.41819569379) | |||
122027 | 122027 | 224650 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 24 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007190.04837 | 2099393.66184 | 37.744941615564706 | -122.417820274 | (37.7449416155647, -122.417820274) | |||
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) | ||
123497 | 123497 | 33634 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 416 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37730 | 6005394.17412308 | 2110828.6660173 | 37.7762382136369 | -122.424843455434 | (37.7762382136369, -122.424843455434) | |||
124466 | 124466 | 53067 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2161 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2006 12:00:00 AM | Permit Number 49038 | 6002271.52116096 | 2114331.58955378 | 37.7856794886217 | -122.435896249645 | (37.7856794886217, -122.435896249645) | |||
124771 | 124771 | 105685 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 2 | Front Yard : Pot 30 | Tree 1 | Private 1 | 8 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
124911 | 124911 | 101249 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 734 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993518.0 | 2106670.0 | 37.764141669108 | -122.46562386166799 | (37.764141669108, -122.465623861668) | ||||
125474 | 125474 | 101895 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 590X Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011780.0 | 2117743.1 | 37.795582240012 | -122.403239519119 | (37.795582240012, -122.403239519119) | ||||
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) | |
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) | ||||
127846 | 127846 | 48789 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1405 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | |||
127861 | 127861 | 101427 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
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) | |||
129073 | 129073 | 33817 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1201 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.791339665663294 | -122.414142270961 | (37.7913396656633, -122.414142270961) | |||
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) | ||||
129826 | 129826 | 224588 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2765 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008276.684169999 | 2106776.8374099997 | 37.7652752322039 | -122.414585240843 | (37.7652752322039, -122.414585240843) | |||
135639 | 135639 | 224644 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 7 Heyman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6006402.40696 | 2098386.74463 | 37.7421324905292 | -122.42047233962099 | (37.7421324905292, -122.420472339621) | |||
137425 | 137425 | 218836 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1550 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991107.229069999 | 2098459.95547 | 37.741459692423796 | -122.473363085249 | (37.7414596924238, -122.473363085249) | |||
137655 | 137655 | 199434 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014431.27107 | 2095902.0652700001 | 37.7357592658851 | -122.39253706224501 | (37.7357592658851, -122.392537062245) | |||
140873 | 140873 | 93707 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1864 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53296 | 6004115.0 | 2118383.0 | 37.7969081825869 | -122.42980742014299 | (37.7969081825869, -122.429807420143) | |||
141164 | 141164 | 63515 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3379 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1987 12:00:00 AM | Permit Number 24124 | 6007714.38800344 | 2104402.20456648 | 37.758723433411 | -122.416361886265 | (37.758723433411, -122.416361886265) | ||
141220 | 141220 | 34143 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 400 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1997 12:00:00 AM | Permit Number 37990 | 6008524.65557539 | 2106230.12436926 | 37.7637880127631 | -122.41368889061701 | (37.7637880127631, -122.413688890617) | ||
141964 | 141964 | 114015 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800x ALABAMA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009320.0 | 2104474.0 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | ||||
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) | ||
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) | |||
150231 | 150231 | 224709 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3278 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6006609.601919999 | 2103216.71936 | 37.755406177257704 | -122.42009861917299 | (37.7554061772577, -122.420098619173) | |||
151509 | 151509 | 116039 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1401x Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6008038.315669999 | 2116541.7615900002 | 37.7920739841803 | -122.416101317043 | (37.7920739841803, -122.416101317043) | |||
151532 | 151532 | 199431 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 695 Arkansas St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 10ft | 6013045.4631900005 | 2103845.54885 | 37.7574933220764 | -122.39788541140499 | (37.7574933220764, -122.397885411405) | |||
152250 | 152250 | 176426 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3338 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011984.529 | 2089984.5422 | 37.719374784604895 | -122.40058089900299 | (37.7193747846049, -122.400580899003) | |||
152736 | 152736 | 224534 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3175 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007849.05039 | 2102074.8141 | 37.752340521521 | -122.41573136650601 | (37.752340521521, -122.415731366506) | |||
154029 | 154029 | 124424 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5996110.10232 | 2115455.34422 | 37.788413082259105 | -122.45729418503599 | (37.7884130822591, -122.457294185036) | |||
154231 | 154231 | 226486 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3120 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6008522.957719999 | 2105665.90861 | 37.7622387108737 | -122.41365485348801 | (37.7622387108737, -122.413654853488) |
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");