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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 140871 | 140871 | 32046 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 501 Tunnel Ave | 1 | 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 92829 | 92829 | 63410 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 834 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1987 12:00:00 AM | Permit Number 23993 | 6007543.2306715 | 2095481.74721631 | 37.7342202321398 | -122.41632200823601 | (37.7342202321398, -122.416322008236) | ||
| 81536 | 81536 | 63412 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 832 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1987 12:00:00 AM | Permit Number 23995 | 6007544.46590294 | 2095494.67209225 | 37.7342557904854 | -122.41631865277901 | (37.7342557904854, -122.416318652779) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 109998 | 109998 | 64335 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 148 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1988 12:00:00 AM | Permit Number 25163 | 6004614.99091661 | 2097575.59980235 | 37.7398043808352 | -122.426594919866 | (37.7398043808352, -122.426594919866) | ||
| 97722 | 97722 | 59421 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 59 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1988 12:00:00 AM | Permit Number 25134 | 6004314.38183356 | 2097887.85689933 | 37.7406447683968 | -122.42765654126998 | (37.7406447683968, -122.42765654127) | ||
| 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) | ||
| 112086 | 112086 | 64333 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 21 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1988 12:00:00 AM | Permit Number 25161 | 6004296.86075631 | 2098199.7784306 | 37.741500242556 | -122.42773934151501 | (37.741500242556, -122.427739341515) | ||
| 85612 | 85612 | 64334 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 18 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1988 12:00:00 AM | Permit Number 25162 | 6004243.25196821 | 2098226.95980835 | 37.7415718437352 | -122.427926638771 | (37.7415718437352, -122.427926638771) | ||
| 118480 | 118480 | 64287 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 359 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1988 12:00:00 AM | Permit Number 25092 | 6004210.28159871 | 2098359.34465346 | 37.7419334769159 | -122.428050070914 | (37.7419334769159, -122.428050070914) | ||
| 82018 | 82018 | 67095 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 432 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30500 | 6009952.08043631 | 2098577.67814271 | 37.7428561528472 | -122.40821208958799 | (37.7428561528472, -122.408212089588) | ||
| 120253 | 120253 | 67096 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 431 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30501 | 6010004.32773544 | 2098578.96669132 | 37.7428626163512 | -122.40803152307899 | (37.7428626163512, -122.408031523079) | ||
| 146115 | 146115 | 67150 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 427 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1992 12:00:00 AM | Permit Number 30582 | 6010005.12050673 | 2098589.41341875 | 37.7428913451797 | -122.40802951845 | (37.7428913451797, -122.40802951845) | ||
| 80250 | 80250 | 67152 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 412 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1992 12:00:00 AM | Permit Number 30584 | 6009956.04429273 | 2098629.91177988 | 37.7429997970033 | -122.408202066775 | (37.7429997970033, -122.408202066775) | ||
| 103603 | 103603 | 48038 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3350 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2005 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | ||
| 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) | ||
| 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) | ||
| 94506 | 94506 | 58807 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 40 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23661 | 6007506.51736783 | 2099215.13200372 | 37.744469217231 | -122.416713333977 | (37.744469217231, -122.416713333977) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 81391 | 81391 | 59350 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 97 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1987 12:00:00 AM | Permit Number 23892 | 6007961.12301785 | 2099994.21526918 | 37.7466339645312 | -122.41519653416599 | (37.7466339645312, -122.415196534166) | ||
| 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) | ||
| 84615 | 84615 | 64894 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1450 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/1989 12:00:00 AM | Permit Number 25920 | 6005836.52150612 | 2100535.66309095 | 37.7480010261231 | -122.42258166386499 | (37.7480010261231, -122.422581663865) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 90327 | 90327 | 61785 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1495 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1987 12:00:00 AM | Permit Number 24636 | 6012051.50334521 | 2101403.29784414 | 37.750732029491296 | -122.40115133594601 | (37.7507320294913, -122.401151335946) | ||
| 108336 | 108336 | 63779 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 143 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24460 | 6004205.74848694 | 2101576.80650466 | 37.750767626848294 | -122.428295003883 | (37.7507676268483, -122.428295003883) | ||
| 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) | ||||
| 140927 | 140927 | 63773 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 400 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24453 | 6004132.01414207 | 2101578.81224199 | 37.7507689616906 | -122.42855012672399 | (37.7507689616906, -122.428550126724) | ||
| 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) | ||
| 140200 | 140200 | 63778 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 140 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24459 | 6004215.48168844 | 2101629.42267968 | 37.750912649324796 | -122.42826509514099 | (37.7509126493248, -122.428265095141) | ||
| 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) | ||
| 118326 | 118326 | 41049 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1452 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1999 12:00:00 AM | Permit Number 41829 | 6011713.00642169 | 2101589.94219711 | 37.751225624557904 | -122.40233501620199 | (37.7512256245579, -122.402335016202) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 142730 | 142730 | 52783 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 269@ 24th ST Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/2006 12:00:00 AM | Permit Number 48827 | 6004796.86181264 | 2102115.84108407 | 37.7522811202098 | -122.426289254005 | (37.7522811202098, -122.426289254005) | ||
| 109018 | 109018 | 30843 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1375 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/1995 12:00:00 AM | Permit Number 34691 | 6011743.60320296 | 2101979.83639733 | 37.7522978969141 | -122.40225661865 | (37.7522978969141, -122.40225661865) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 9838 | 9838 | 68204 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1110 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 16 | 3x3 | Permit Number 32363 | 6009978.53990017 | 2102725.22931804 | 37.754245896491604 | -122.408413088762 | (37.7542458964916, -122.408413088762) |
| 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) | ||
| 90199 | 90199 | 65243 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28037 | 6009165.76758609 | 2102839.33295033 | 37.754513650320504 | -122.411231929366 | (37.7545136503205, -122.411231929366) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 93794 | 93794 | 64591 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3375 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1988 12:00:00 AM | Permit Number 25492 | 6005853.76544152 | 2103715.18666196 | 37.756732237337395 | -122.422747957423 | (37.7567322373374, -122.422747957423) | ||
| 144385 | 144385 | 63988 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 237 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1987 12:00:00 AM | Permit Number 24734 | 6004762.51437158 | 2103946.91619601 | 37.7573068822751 | -122.42653840478998 | (37.7573068822751, -122.42653840479) | ||
| 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) | ||
| 111917 | 111917 | 64693 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 110 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/1988 12:00:00 AM | Permit Number 25636 | 6005573.37725141 | 2104043.9306623 | 37.757619067817394 | -122.423741017308 | (37.7576190678174, -122.423741017308) | ||
| 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) | ||
| 104344 | 104344 | 63244 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3686 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/1987 12:00:00 AM | 14 | 4x4 | Permit Number 23795 | 6005743.604901999 | 2104344.93890143 | 37.758455174016596 | -122.42317369583701 | (37.7584551740166, -122.423173695837) |
| 109541 | 109541 | 64674 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3672 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1988 12:00:00 AM | Permit Number 25610 | 6005829.7777873 | 2104349.72005691 | 37.7584731646091 | -122.422876010971 | (37.7584731646091, -122.422876010971) | ||
| 121605 | 121605 | 64580 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3540 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1988 12:00:00 AM | Permit Number 25479 | 6006657.88465402 | 2104395.66614284 | 37.7586460128066 | -122.420015302359 | (37.7586460128066, -122.420015302359) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) |
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");