Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23132 | 23132 | 25364 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 994 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000636.2417 | 2088870.0556299998 | 37.7156752201082 | -122.43972775363001 | (37.7156752201082, -122.43972775363) | |||
| 78272 | 78272 | 106690 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 98X CHATTANOOGA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 4x4 | 6004701.0 | 2103385.0 | 37.7557605147563 | -122.426711131232 | (37.7557605147563, -122.426711131232) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 56265 | 56265 | 104652 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 94 | 953 Indiana St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6015057.1 | 2104275.7 | 37.758786250670205 | -122.39095836980302 | (37.7587862506702, -122.390958369803) | |||||
| 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) | |
| 11311 | 11311 | 25396 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 945 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6000465.251630001 | 2089064.76788 | 37.7162001220051 | -122.440332727576 | (37.7162001220051, -122.440332727576) | |||
| 109700 | 109700 | 97313 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 926 Taraval St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1984 12:00:00 AM | 3x3 | 5990372.0 | 2099065.0 | 37.74307838657921 | -122.47594940431101 | (37.7430783865792, -122.475949404311) | |||
| 106510 | 106510 | 66867 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 925 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1991 12:00:00 AM | 15 | 3x3 | Permit Number 30174 | 6008155.266254799 | 2115151.32890411 | 37.788262771233 | -122.41559817658899 | (37.788262771233, -122.415598176589) | |
| 125498 | 125498 | 66848 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 919 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | Permit Number 30152 | 6008182.6560056 | 2115155.17049763 | 37.7882748588768 | -122.41550368440399 | (37.7882748588768, -122.415503684404) | ||
| 44876 | 44876 | 224512 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 915 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009423.35212 | 2103670.74387 | 37.756810960566 | -122.41039983289 | (37.756810960566, -122.41039983289) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 25222 | 25222 | 224646 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 9 Heyman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006447.484730001 | 2098360.83948 | 37.7420639010279 | -122.420314636308 | (37.7420639010279, -122.420314636308) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 182594 | 182594 | 224610 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 87 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000904.1974 | 2097866.66824 | 37.740393101855204 | -122.43944610755699 | (37.7403931018552, -122.439446107557) | |||
| 56649 | 56649 | 176416 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 860 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000990.84724 | 2088839.6326 | 37.715611862882 | -122.438499899353 | (37.715611862882, -122.438499899353) | |||
| 55190 | 55190 | 218839 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990579.44919 | 2099089.86589 | 37.7431586880264 | -122.47523392331199 | (37.7431586880264, -122.475233923312) | |||
| 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) | |||
| 180807 | 180807 | 176414 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 850 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001021.05329 | 2088894.2263099998 | 37.7157634831843 | -122.43839940283199 | (37.7157634831843, -122.438399402832) | |||
| 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) | ||
| 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) | ||||
| 114426 | 114426 | 98988 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 847 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009438.4 | 2115684.0 | 37.789797399949606 | -122.411196371815 | (37.7897973999496, -122.411196371815) | ||||
| 126605 | 126605 | 98985 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 847 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009438.4 | 2115684.0 | 37.789797399949606 | -122.411196371815 | (37.7897973999496, -122.411196371815) | ||||
| 140187 | 140187 | 98987 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 847 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009438.4 | 2115684.0 | 37.789797399949606 | -122.411196371815 | (37.7897973999496, -122.411196371815) | ||||
| 96095 | 96095 | 31350 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34960 | 6003828.78534548 | 2110731.50789971 | 37.7758829003399 | -122.43025162922702 | (37.7758829003399, -122.430251629227) | ||
| 881 | 881 | 251399 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008927.4869099995 | 2120274.72498 | 37.802373734427796 | -122.413288863041 | (37.8023737344278, -122.413288863041) | ||||
| 152430 | 152430 | 58156 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 837 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1978 12:00:00 AM | 9 | Permit Number 17140 | 6001092.2872 | 2088918.12181 | 37.7158331464556 | -122.43815489694401 | (37.7158331464556, -122.438154896944) | ||
| 78071 | 78071 | 54520 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 836 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | Permit Number 11498 | 5993201.36132572 | 2106658.05231245 | 37.7640905954535 | -122.466718145476 | (37.7640905954535, -122.466718145476) | |||
| 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) | ||
| 136359 | 136359 | 224498 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 834 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007554.05965 | 2095454.27722 | 37.734145414466795 | -122.416282623937 | (37.7341454144668, -122.416282623937) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 65572 | 65572 | 101289 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 830 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6001069.51096 | 2088976.2004099998 | 37.715991321918004 | -122.438237780259 | (37.715991321918, -122.438237780259) | ||||
| 147702 | 147702 | 224497 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 826 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007559.62386 | 2095519.1947400002 | 37.7343239766775 | -122.416267983001 | (37.7343239766775, -122.416267983001) | |||
| 148290 | 148290 | 176417 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 825 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6001125.807159999 | 2088973.54213 | 37.7159872246076 | -122.438043004189 | (37.7159872246076, -122.438043004189) | |||
| 132452 | 132452 | 224496 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 822 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007561.99234 | 2095547.7778 | 37.7344025926964 | -122.416261818137 | (37.7344025926964, -122.416261818137) | |||
| 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) | ||
| 141268 | 141268 | 66115 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 817 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29170 | 6003947.68857827 | 2110748.1234611 | 37.7759352566539 | -122.429841497852 | (37.7759352566539, -122.429841497852) | ||
| 120319 | 120319 | 64776 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 816 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1989 12:00:00 AM | Permit Number 25768 | 6010808.79838009 | 2116967.92817235 | 37.7933995175775 | -122.40654541205299 | (37.7933995175775, -122.406545412053) | ||
| 66428 | 66428 | 58153 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 816 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1978 12:00:00 AM | 2 | Permit Number 17137 | 6001098.08865 | 2089024.55935 | 37.7161257300936 | -122.438142464699 | (37.7161257300936, -122.438142464699) | ||
| 181204 | 181204 | 176413 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 816 Lisbon St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6001088.39895 | 2089005.3588599998 | 37.7160724587542 | -122.43817458219999 | (37.7160724587542, -122.4381745822) | |||
| 63536 | 63536 | 58155 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 815 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1978 12:00:00 AM | 11 | Permit Number 17139 | 6001141.03185 | 2088999.4930099999 | 37.7160593457428 | -122.437992238373 | (37.7160593457428, -122.437992238373) | ||
| 108545 | 108545 | 66218 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 81 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1990 12:00:00 AM | Permit Number 29310 | 6005039.41557773 | 2105712.51494257 | 37.7621704498093 | -122.425706435205 | (37.7621704498093, -122.425706435205) | ||
| 161850 | 161850 | 58154 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 807 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1978 12:00:00 AM | 10 | Permit Number 17138 | 6001157.22948 | 2089029.0056 | 37.716141301843294 | -122.43793836449 | (37.7161413018433, -122.43793836449) | ||
| 73083 | 73083 | 58152 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 806 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1978 12:00:00 AM | 11 | Permit Number 17136 | 6001116.27875 | 2089048.9565700002 | 37.716193753914105 | -122.43808133779699 | (37.7161937539141, -122.438081337797) | ||
| 94548 | 94548 | 66852 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 805 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | Permit Number 30158 | 6008246.52380896 | 2115214.16051417 | 37.788440420773796 | -122.415286889274 | (37.7884404207738, -122.415286889274) | ||
| 41755 | 41755 | 126624 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 801x Greenwich St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6009066.28691 | 2120109.01558 | 37.801926529358504 | -122.41279682292401 | (37.8019265293585, -122.412796822924) | |||
| 120721 | 120721 | 65423 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 801 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1989 12:00:00 AM | Permit Number 28281 | 6010517.63649674 | 2116529.16048818 | 37.7921784739149 | -122.40752190934299 | (37.7921784739149, -122.407521909343) | ||
| 94531 | 94531 | 65486 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 801 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1989 12:00:00 AM | Permit Number 28370 | 6009649.36997858 | 2115707.80146662 | 37.7898745823318 | -122.410468114048 | (37.7898745823318, -122.410468114048) | ||
| 86230 | 86230 | 114016 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800x ALABAMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009320.0 | 2104474.0 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | ||||
| 91851 | 91851 | 114017 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800x ALABAMA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009320.0 | 2104474.0 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | ||||
| 92579 | 92579 | 114018 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800x ALABAMA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009320.0 | 2104474.0 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | ||||
| 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) | ||||
| 142782 | 142782 | 72861 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800x ALABAMA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1999 12:00:00 AM | 14 | 3x3 | 6009320.0 | 2104474.0 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | ||
| 75200 | 75200 | 62505 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 800 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/1986 12:00:00 AM | 15 | Permit Number 22680 | 6000887.297669999 | 2089194.5830599999 | 37.716580586514795 | -122.43888323447901 | (37.7165805865148, -122.438883234479) | ||
| 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) | |||
| 44954 | 44954 | 224672 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800 Florida St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009346.5218400005 | 2104406.68388 | 37.758827378187796 | -122.410717513006 | (37.7588273781878, -122.410717513006) | |||
| 53537 | 53537 | 224668 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6009343.82267 | 2104472.74899 | 37.7590086266741 | -122.410731513656 | (37.7590086266741, -122.410731513656) | |||
| 134334 | 134334 | 224670 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009345.18768 | 2104440.47189 | 37.758920077605 | -122.41072451332701 | (37.758920077605, -122.410724513327) | |||
| 162159 | 162159 | 224671 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800 Florida St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009345.91132 | 2104426.34813 | 37.758881337533005 | -122.410721013192 | (37.758881337533, -122.410721013192) | |||
| 116903 | 116903 | 62604 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 796 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | Permit Number 22912 | 5984497.70797117 | 2110431.26743747 | 37.773944632299205 | -122.497099617838 | (37.7739446322992, -122.497099617838) | ||
| 143537 | 143537 | 48492 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 789(REVISED) 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | Permit Number 45835 | 5984443.84017034 | 2110481.58351844 | 37.7740796289032 | -122.49728966782 | (37.7740796289032, -122.49728966782) | ||
| 19453 | 19453 | 1923 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 78 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6001189.660619999 | 2097346.8097900003 | 37.7389819342562 | -122.43842185440901 | (37.7389819342562, -122.438421854409) | |||
| 99975 | 99975 | 58797 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 772 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1979 12:00:00 AM | 24 | 3x3 | Permit Number 53459 | 6003043.36972634 | 2103781.55156302 | 37.756755493530896 | -122.43247206616199 | (37.7567554935309, -122.432472066162) | |
| 27818 | 27818 | 224481 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 77 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005108.87913 | 2105720.69975 | 37.762196848333396 | -122.42546676957599 | (37.7621968483334, -122.425466769576) | |||
| 16905 | 16905 | 26220 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 765X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005701.2867 | 2098677.11468 | 37.7428902448864 | -122.422917229343 | (37.7428902448864, -122.422917229343) | |||
| 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) | |||
| 90716 | 90716 | 65402 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 760 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1989 12:00:00 AM | 12 | 3x3 | Permit Number 28251 | 6008077.0 | 2114493.0 | 37.7864507606031 | -122.41582233096099 | (37.7864507606031, -122.415822330961) |
| 142421 | 142421 | 101055 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 760 Geary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008077.0 | 2114493.0 | 37.7864507606031 | -122.41582233096099 | (37.7864507606031, -122.415822330961) | |||
| 21401 | 21401 | 28743 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 750 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005621.9935800005 | 2098694.18206 | 37.742932633526 | -122.42319261615 | (37.742932633526, -122.42319261615) | |||
| 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) | |||
| 63243 | 63243 | 218810 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 75 Williar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997095.6983 | 2090612.61251 | 37.7202577138075 | -122.452091075552 | (37.7202577138075, -122.452091075552) | |||
| 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) | |||
| 137325 | 137325 | 176405 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 75 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 5998552.29871 | 2087983.35456 | 37.7131217039812 | -122.446867014517 | (37.7131217039812, -122.446867014517) | |||
| 143571 | 143571 | 65401 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 747 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1989 12:00:00 AM | Permit Number 28250 | 6008150.2130763 | 2114455.0011203 | 37.7863505404889 | -122.415566339973 | (37.7863505404889, -122.415566339973) | ||
| 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) | |||
| 99249 | 99249 | 101053 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 746 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008144.0 | 2114503.0 | 37.786481984518396 | -122.415591235338 | (37.7864819845184, -122.415591235338) | |||
| 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) | ||
| 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) | ||||
| 143341 | 143341 | 59298 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 734 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1980 12:00:00 AM | Permit Number 18636 | 5993516.37713931 | 2106668.84289355 | 37.7641383983924 | -122.465629390558 | (37.7641383983924, -122.465629390558) | |||
| 160894 | 160894 | 224606 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 73 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6005880.9879 | 2103425.9555900004 | 37.7559396119431 | -122.42263325944201 | (37.7559396119431, -122.422633259442) | |||
| 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) | ||||
| 122522 | 122522 | 107383 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 73 HILL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6005896.4 | 2103362.0 | 37.7557648742481 | -122.422575414787 | (37.7557648742481, -122.422575414787) | ||||
| 164569 | 164569 | 218837 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 725 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990923.73813 | 2099033.65671 | 37.7430243014348 | -122.474039375442 | (37.7430243014348, -122.474039375442) | |||
| 71920 | 71920 | 218838 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 723 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990942.64769 | 2099036.77615 | 37.743033961950005 | -122.473974219529 | (37.74303396195, -122.473974219529) | |||
| 87079 | 87079 | 63899 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 719 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1987 12:00:00 AM | Permit Number 24609 | 6002042.34774334 | 2110925.77664223 | 37.776314966213896 | -122.43644527379699 | (37.7763149662139, -122.436445273797) | ||
| 41113 | 41113 | 224656 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 712 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007860.71313 | 2097707.8013299997 | 37.740350336402294 | -122.415381905247 | (37.7403503364023, -122.415381905247) | |||
| 82620 | 82620 | 102901 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 712 BATTERY ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6012523.0 | 2118543.0 | 37.797820041376205 | -122.400724815577 | (37.7978200413762, -122.400724815577) | ||||
| 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) | |||
| 169115 | 169115 | 224605 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 71 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005897.27948 | 2103429.1332799997 | 37.7559492562604 | -122.42257714351801 | (37.7559492562604, -122.422577143518) | |||
| 85375 | 85375 | 98530 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 701X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991613.7 | 2110635.6 | 37.77492011755329 | -122.472499350726 | (37.7749201175533, -122.472499350726) | ||||
| 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) | ||||
| 62389 | 62389 | 224645 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 7 Heyman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006421.94544 | 2098375.74609 | 37.742103392067 | -122.42040400106701 | (37.742103392067, -122.420404001067) |
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");