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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 19035 | 19035 | 5708 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1603 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005329.17263 | 2098980.1167599997 | 37.743701215741794 | -122.424225442544 | (37.7437012157418, -122.424225442544) | |||
| 42648 | 42648 | 226500 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 155 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6005540.15432 | 2099025.50317 | 37.743837747220894 | -122.423499143787 | (37.7438377472209, -122.423499143787) | |||
| 169405 | 169405 | 226499 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 133 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6005600.01114 | 2099028.12585 | 37.7438483268298 | -122.42329235906999 | (37.7438483268298, -122.42329235907) | |||
| 183406 | 183406 | 224652 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 50 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007400.925369999 | 2098998.39155 | 37.74386815689579 | -122.41706309608601 | (37.7438681568958, -122.417063096086) | |||
| 53251 | 53251 | 94021 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 67 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2010 12:00:00 AM | 3x3 | Permit Number 53440 | 6007432.0 | 2099002.0 | 37.7438798129267 | -122.416955902584 | (37.7438798129267, -122.416955902584) | ||
| 52756 | 52756 | 218802 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2370 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992350.84884 | 2099324.20257 | 37.7439046297971 | -122.46912600049 | (37.7439046297971, -122.46912600049) | |||
| 130557 | 130557 | 224653 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 44 Elsie St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6007416.47838 | 2099024.91557 | 37.743941860842796 | -122.417011196208 | (37.7439418608428, -122.417011196208) | |||
| 186397 | 186397 | 218803 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2370 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992349.88043 | 2099344.31841 | 37.7439598068059 | -122.46913081273199 | (37.7439598068059, -122.469130812732) | |||
| 50369 | 50369 | 224654 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 38 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6007453.75758 | 2099095.22372 | 37.7441370083106 | -122.416887273228 | (37.7441370083106, -122.416887273228) | |||
| 22195 | 22195 | 1351 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 271 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999796.36324 | 2099302.3291700003 | 37.7442719740833 | -122.443379644158 | (37.7442719740833, -122.443379644158) | |||
| 103012 | 103012 | 224501 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 41 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6007129.62294 | 2099203.4604599997 | 37.7444159645172 | -122.418015733552 | (37.7444159645172, -122.418015733552) | |||
| 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) | ||
| 152318 | 152318 | 224500 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 39 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6007142.185819999 | 2099226.02061 | 37.744478616691396 | -122.417973892579 | (37.7444786166914, -122.417973892579) | |||
| 44782 | 44782 | 224499 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 35 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6007169.2602 | 2099278.27912 | 37.744623630583 | -122.41788397836599 | (37.744623630583, -122.417883978366) | |||
| 20211 | 20211 | 5689 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1535 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005306.00348 | 2099419.02782 | 37.74490505722029 | -122.424336766952 | (37.7449050572203, -122.424336766952) | |||
| 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) | |||
| 187559 | 187559 | 224649 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6007194.88444 | 2099407.51056 | 37.7449799131997 | -122.41780453317 | (37.7449799131997, -122.41780453317) | |||
| 21323 | 21323 | 5685 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1506 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 5x5 | 6005209.87097 | 2099535.96992 | 37.7452207246578 | -122.42467749309601 | (37.7452207246578, -122.424677493096) | |||
| 9737 | 9737 | 173681 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 125 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010317.0 | 2099454.0 | 37.7452827689443 | -122.40701204748301 | (37.7452827689443, -122.407012047483) | ||||
| 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) | ||
| 183571 | 183571 | 224487 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 14 Lundys Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 6007167.0998599995 | 2099582.88965 | 37.7454599011682 | -122.41791303725 | (37.7454599011682, -122.41791303725) | |||
| 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) | ||
| 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) | |||
| 122320 | 122320 | 121141 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 100x Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 9x6 | 6010389.0 | 2099533.0 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | |||
| 173633 | 173633 | 224486 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 12 Lundys Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 2ft | 6007182.48369 | 2099609.18315 | 37.7455329629926 | -122.417861705765 | (37.7455329629926, -122.417861705765) | |||
| 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) | ||
| 55684 | 55684 | 224640 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 14 Powers Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006790.58194 | 2099800.70275 | 37.7460367694939 | -122.41923042716002 | (37.7460367694939, -122.41923042716) | |||
| 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) | |||
| 16957 | 16957 | 5672 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1422 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6005185.06241 | 2100046.61651 | 37.7466214421279 | -122.424799598532 | (37.7466214421279, -122.424799598532) | |||
| 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) | ||
| 20031 | 20031 | 5670 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1416 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6005182.49595 | 2100071.1312 | 37.7466886088884 | -122.424810216828 | (37.7466886088884, -122.424810216828) | |||
| 56060 | 56060 | 218830 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 833 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5990479.90891 | 2100386.13678 | 37.746712141459604 | -122.47567273941699 | (37.7467121414596, -122.475672739417) | |||
| 187354 | 187354 | 218829 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 833 Rivera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5990502.9727 | 2100388.60646 | 37.746720259628 | -122.475593168284 | (37.746720259628, -122.475593168284) | |||
| 33009 | 33009 | 218828 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 831 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5990524.89237 | 2100389.62216 | 37.746724319168294 | -122.47551744719802 | (37.7467243191683, -122.475517447198) | |||
| 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) | ||
| 129966 | 129966 | 224658 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 127 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007231.85422 | 2100130.75523 | 37.746967860998105 | -122.41772795228998 | (37.7469678609981, -122.41772795229) | |||
| 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) | ||
| 118729 | 118729 | 62533 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 128 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1988 12:00:00 AM | Permit Number 25140 | 6004317.58532782 | 2101049.36983513 | 37.749325736021 | -122.427870683655 | (37.749325736021, -122.427870683655) | |||
| 20538 | 20538 | 10222 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1375-1377 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005868.37697 | 2101019.32612 | 37.7493308512387 | -122.422505871374 | (37.7493308512387, -122.422505871374) | |||
| 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) | ||
| 20574 | 20574 | 23101 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1406 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6006426.26721 | 2101342.93585 | 37.7502508667074 | -122.420599640465 | (37.7502508667074, -122.420599640465) | |||
| 16970 | 16970 | 23100 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1406 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 3X3 | 6006427.47457 | 2101357.7543900004 | 37.7502916230775 | -122.42059651712098 | (37.7502916230775, -122.420596517121) | |||
| 21797 | 21797 | 23099 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1406 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x4 | 6006424.41645 | 2101384.80463 | 37.7503657245067 | -122.420609012309 | (37.7503657245067, -122.420609012309) | |||
| 148216 | 148216 | 224684 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3513 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006347.14535 | 2101407.6579400003 | 37.7504241193009 | -122.420877843938 | (37.7504241193009, -122.420877843938) | |||
| 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) | |||
| 147109 | 147109 | 224686 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3513 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006380.82201 | 2101410.31464 | 37.750433312158606 | -122.42076157599199 | (37.7504333121586, -122.420761575992) | |||
| 135738 | 135738 | 224687 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3513 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006398.661830001 | 2101411.28771 | 37.7504369894718 | -122.420699953558 | (37.7504369894718, -122.420699953558) | |||
| 34585 | 34585 | 224513 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1115 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008070.04378 | 2101397.41005 | 37.7504929435022 | -122.41491919326 | (37.7504929435022, -122.41491919326) | |||
| 148374 | 148374 | 224692 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3514 25th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006331.52942 | 2101449.49488 | 37.7505381137462 | -122.42093481508199 | (37.7505381137462, -122.420934815082) | |||
| 56925 | 56925 | 224691 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3514 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006345.67902 | 2101450.87841 | 37.750542710175296 | -122.420885982798 | (37.7505427101753, -122.420885982798) | |||
| 46980 | 46980 | 224690 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3514 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006361.82473 | 2101451.2167700003 | 37.750544549297 | -122.420830173598 | (37.750544549297, -122.420830173598) | |||
| 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) | |||
| 52089 | 52089 | 224688 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3514 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006392.77142 | 2101451.9207900004 | 37.7505482266294 | -122.420723207318 | (37.7505482266294, -122.420723207318) | |||
| 46174 | 46174 | 224682 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1390 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6006417.42588 | 2101484.35178 | 37.750638664248704 | -122.42064025206899 | (37.7506386642487, -122.420640252069) | |||
| 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) | |||
| 40276 | 40276 | 224680 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1390 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6006416.173690001 | 2101511.36496 | 37.7507127656919 | -122.420646499657 | (37.7507127656919, -122.420646499657) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 18629 | 18629 | 23094 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1384 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/1992 12:00:00 AM | 3 | 3x3 | 6006412.34173 | 2101544.72785 | 37.750804156590206 | -122.42066211905701 | (37.7508041565902, -122.420662119057) | ||
| 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) | ||
| 58083 | 58083 | 224683 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1380 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006412.3793 | 2101568.5660099997 | 37.750869612842294 | -122.420663681196 | (37.7508696128423, -122.420663681196) | |||
| 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) | ||
| 44309 | 44309 | 41283 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3948 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2000 12:00:00 AM | 0 | Permit Number 41961 | 5981803.95386186 | 2102184.90266006 | 37.751144251784204 | -122.505806132064 | (37.7511442517842, -122.505806132064) | ||
| 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) | ||
| 146975 | 146975 | 224617 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 970 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999693.044980001 | 2101841.1304900004 | 37.7512370173901 | -122.44391926795299 | (37.7512370173901, -122.443919267953) | |||
| 18006 | 18006 | 26514 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2880 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008952.92902 | 2101706.37447 | 37.7513908617048 | -122.411887928494 | (37.7513908617048, -122.411887928494) | |||
| 20672 | 20672 | 26517 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2883 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6009010.68122 | 2101716.60139 | 37.7514221824079 | -122.411688936397 | (37.7514221824079, -122.411688936397) | |||
| 134109 | 134109 | 224578 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2881 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009009.60186 | 2101733.0677 | 37.7514673346644 | -122.41169383231501 | (37.7514673346644, -122.411693832315) | |||
| 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) | |
| 164944 | 164944 | 224679 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 904 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007366.7394199995 | 2101988.35955 | 37.752076011999605 | -122.417393153575 | (37.7520760119996, -122.417393153575) | |||
| 24881 | 24881 | 224536 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3283 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007118.3907 | 2102031.54495 | 37.7521806130667 | -122.418255044036 | (37.7521806130667, -122.418255044036) | |||
| 160939 | 160939 | 224678 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 904 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6007360.84858 | 2102028.60298 | 37.752186179864104 | -122.41741637677201 | (37.7521861798641, -122.417416376772) | |||
| 19861 | 19861 | 656 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3255X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12 | 4x4 | 6007336.00672 | 2102041.77073 | 37.7522209377618 | -122.41750321711099 | (37.7522209377618, -122.417503217111) | |||
| 20968 | 20968 | 655 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3255X 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 06/02/1992 12:00:00 AM | 12 | 3x4 | 6007319.73993 | 2102042.10408 | 37.7522209377659 | -122.41755949396901 | (37.7522209377659, -122.417559493969) | ||
| 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) | ||
| 20011 | 20011 | 644 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3245 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6007452.42683 | 2102052.29911 | 37.75225639624 | -122.41710136313101 | (37.75225639624, -122.417101363131) | |||
| 17222 | 17222 | 3468 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3231 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 4x4 | 6007477.096919999 | 2102052.55322 | 37.752258481762 | -122.41701606785601 | (37.752258481762, -122.417016067856) | |||
| 20129 | 20129 | 642 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3225 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6007512.22413 | 2102054.36572 | 37.7522654344184 | -122.416894720512 | (37.7522654344184, -122.416894720512) | |||
| 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) |
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");