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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5520 | 5520 | 37970 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 602 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40200 | ||||||||
| 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) | ||
| 149281 | 149281 | 57942 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 15 Byron Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776219 | 5999289.472159999 | 2086646.12526 | 37.7094920599881 | -122.44422306973499 | (37.7094920599881, -122.444223069735) | |
| 184163 | 184163 | 176435 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 275 De Long St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 10ft | 5993714.58235 | 2086792.86785 | 37.7095753489021 | -122.46350132202299 | (37.7095753489021, -122.463501322023) | |||
| 157834 | 157834 | 57946 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 10 Byron Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 9 | Permit Number 16905 | 5999382.31979 | 2086721.86457 | 37.7097053198058 | -122.44390761184401 | (37.7097053198058, -122.443907611844) | ||
| 42614 | 42614 | 176421 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 526 Lathrop Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6013003.58559 | 2086544.76512 | 37.7099866196603 | -122.396817348641 | (37.7099866196603, -122.396817348641) | |||
| 43376 | 43376 | 176420 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 526 Lathrop Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012864.549880001 | 2086589.64347 | 37.7101021070033 | -122.397301031027 | (37.7101021070033, -122.397301031027) | |||
| 67018 | 67018 | 54789 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 271 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1972 12:00:00 AM | 21 | Permit Number 10638 | 6012677.12996 | 2087211.6465200002 | 37.7117995683772 | -122.39799240103001 | (37.7117995683772, -122.39799240103) | ||
| 38567 | 38567 | 176431 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 146 Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008376.30406 | 2087394.4749 | 37.7120611046958 | -122.41287021121401 | (37.7120611046958, -122.412870211214) | |||
| 156600 | 156600 | 176432 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 125 Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008419.02136 | 2087402.0784099998 | 37.7120843800612 | -122.41272310459999 | (37.7120843800612, -122.4127231046) | |||
| 170317 | 170317 | 176404 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 332 Ellington Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5998751.95541 | 2087834.14028 | 37.712723399629 | -122.44616620971901 | (37.712723399629, -122.446166209719) | |||
| 40036 | 40036 | 176403 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 332 Ellington Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5998770.03746 | 2087851.6869599998 | 37.7127726114513 | -122.44610497396201 | (37.7127726114513, -122.446104973962) | |||
| 157131 | 157131 | 176402 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 332 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5998803.89987 | 2087884.3075400002 | 37.7128641138726 | -122.44599027982201 | (37.7128641138726, -122.445990279822) | |||
| 172813 | 172813 | 176409 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 45 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5998625.6999 | 2087888.85423 | 37.7128664206305 | -122.44660652136999 | (37.7128664206305, -122.44660652137) | |||
| 39277 | 39277 | 176408 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 55 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998608.92575 | 2087907.1259400002 | 37.7129156324143 | -122.44666581189101 | (37.7129156324143, -122.446665811891) | |||
| 54887 | 54887 | 176407 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 65 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998589.29961 | 2087923.49641 | 37.7129594608753 | -122.446734823157 | (37.7129594608753, -122.446734823157) | |||
| 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) | |||
| 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) | |
| 169194 | 169194 | 218815 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 317 Plymouth Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995878.855380001 | 2088132.4441900002 | 37.713377975685205 | -122.456118052609 | (37.7133779756852, -122.456118052609) | |||
| 76726 | 76726 | 218814 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 317 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995878.65108 | 2088143.0591400003 | 37.7134071101336 | -122.45611952571801 | (37.7134071101336, -122.456119525718) | |||
| 156993 | 156993 | 218813 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 317 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995878.91715 | 2088155.78665 | 37.7134420721779 | -122.45611952571801 | (37.7134420721779, -122.456119525718) | |||
| 43618 | 43618 | 218812 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 317 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995879.6181 | 2088168.92922 | 37.713478198842296 | -122.456118052617 | (37.7134781988423, -122.456118052617) | |||
| 137901 | 137901 | 218826 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 354 Head St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5993503.058019999 | 2088221.2574099998 | 37.713485177561004 | -122.46433601702 | (37.713485177561, -122.46433601702) | |||
| 147641 | 147641 | 176430 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 242 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009808.91529 | 2087898.0205299999 | 37.7135240489616 | -122.40795415897499 | (37.7135240489616, -122.407954158975) | |||
| 70821 | 70821 | 176429 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 246 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009787.6259 | 2087905.1954700002 | 37.7135425579218 | -122.4080282487 | (37.7135425579218, -122.4080282487) | |||
| 46175 | 46175 | 176428 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 250 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009763.04467 | 2087916.9312200001 | 37.7135734055712 | -122.40811403774599 | (37.7135734055712, -122.408114037746) | |||
| 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) | ||
| 67463 | 67463 | 176433 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 118 Chester Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991720.02905 | 2088438.7014799998 | 37.7139792884876 | -122.470514566313 | (37.7139792884876, -122.470514566313) | |||
| 179557 | 179557 | 176434 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 109 Chester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991752.24555 | 2088448.0917 | 37.714006934552 | -122.47040389841999 | (37.714006934552, -122.47040389842) | |||
| 45557 | 45557 | 218824 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 104 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5992465.47636 | 2088577.7234599998 | 37.7144040850433 | -122.46794814758499 | (37.7144040850433, -122.467948147585) | |||
| 171301 | 171301 | 218823 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 122 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5992474.68721 | 2088695.0453700002 | 37.7147267546141 | -122.467924839857 | (37.7147267546141, -122.467924839857) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||||
| 42892 | 42892 | 218825 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 295 Bright St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5993731.49381 | 2089150.28883 | 37.716049240944706 | -122.463613852416 | (37.7160492409447, -122.463613852416) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 26790 | 26790 | 218822 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 210 Vernon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5992480.53035 | 2089289.94219 | 37.7163605349795 | -122.467947888583 | (37.7163605349795, -122.467947888583) | |||
| 155873 | 155873 | 218816 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 170 Margaret Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 5996666.019619999 | 2089250.8609200001 | 37.716494040240796 | -122.45347805498899 | (37.7164940402408, -122.453478054989) | |||
| 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) | ||
| 153476 | 153476 | 176418 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 216 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 1ft | 6004075.47639 | 2089186.2671 | 37.7167386279577 | -122.427862706522 | (37.7167386279577, -122.427862706522) | |||
| 137665 | 137665 | 176427 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 383 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6010742.024730001 | 2089174.6470599999 | 37.7170816042145 | -122.40481880756201 | (37.7170816042145, -122.404818807562) | |||
| 38462 | 38462 | 176412 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6000489.461069999 | 2089401.4731400001 | 37.71712601723571 | -122.440273180786 | (37.7171260172357, -122.440273180786) | |||
| 45410 | 45410 | 218818 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 230 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5996994.979669999 | 2089536.5843200001 | 37.7172974217136 | -122.452361618599 | (37.7172974217136, -122.452361618599) | |||
| 41062 | 41062 | 55568 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1132 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | 13 | 3x2 | Permit Number 11537 | 6011293.45596 | 2089493.71978 | 37.7179885201224 | -122.40293519190901 | (37.7179885201224, -122.402935191909) | |
| 167625 | 167625 | 218817 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 431 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5996521.08411 | 2089810.0200599998 | 37.7180210513199 | -122.454019381193 | (37.7180210513199, -122.454019381193) | |||
| 185528 | 185528 | 55317 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1126 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 4 | Permit Number 11246 | 6011285.28669 | 2089520.6507599999 | 37.7180620109438 | -122.402965322811 | (37.7180620109438, -122.402965322811) | ||
| 136673 | 136673 | 55316 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1125 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 14 | Permit Number 11245 | 6011314.6404800005 | 2089535.2445 | 37.7181037214869 | -122.40286488472601 | (37.7181037214869, -122.402864884726) | ||
| 68571 | 68571 | 55566 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1120 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11535 | 6011279.280809999 | 2089546.81423 | 37.7181335151377 | -122.402987921868 | (37.7181335151377, -122.402987921868) | |
| 184359 | 184359 | 111317 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1114 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6011270.9057 | 2089563.6222599999 | 37.7181791988873 | -122.403018052761 | (37.7181791988873, -122.403018052761) | |||
| 73707 | 73707 | 111609 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 301x Ward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 15x3 | 6011168.56615 | 2089615.14952 | 37.71831496682871 | -122.403375421742 | (37.7183149668287, -122.403375421742) | |||
| 187298 | 187298 | 111610 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 301x Ward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 9x3 | 6011193.26322 | 2089621.79675 | 37.71833459814221 | -122.403290521257 | (37.7183345981422, -122.403290521257) | |||
| 154035 | 154035 | 111611 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 301x Ward St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 9x3 | 6011211.1462900005 | 2089627.82993 | 37.718352162787795 | -122.40322913082599 | (37.7183521627878, -122.403229130826) | |||
| 12579 | 12579 | 28252 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3342 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011993.05449 | 2089944.3685299999 | 37.7192649513087 | -122.40054860885598 | (37.7192649513087, -122.400548608856) | |||
| 143728 | 143728 | 218821 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 278 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5991714.63996 | 2090365.5771400002 | 37.719269707816 | -122.47067345584101 | (37.719269707816, -122.470673455841) | |||
| 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) | |||
| 11743 | 11743 | 28251 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3340 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011988.71606 | 2089960.7357 | 37.7193096502899 | -122.40056475438101 | (37.7193096502899, -122.400564754381) | |||
| 152250 | 152250 | 176426 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3338 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011984.529 | 2089984.5422 | 37.719374784604895 | -122.40058089900299 | (37.7193747846049, -122.400580899003) | |||
| 166125 | 166125 | 176425 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3338 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011982.06755 | 2090001.3363400002 | 37.71942076063571 | -122.400590586484 | (37.7194207606357, -122.400590586484) | |||
| 178907 | 178907 | 176419 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 638 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6002178.18938 | 2090229.77829 | 37.719496363045295 | -122.43449524976002 | (37.7194963630453, -122.43449524976) | |||
| 48220 | 48220 | 218820 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 205 Beverly St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5991411.7286 | 2090565.37313 | 37.7198007772708 | -122.471735048829 | (37.7198007772708, -122.471735048829) | |||
| 159184 | 159184 | 218819 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 205 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5991410.90841 | 2090573.24495 | 37.71982234389839 | -122.47173845727801 | (37.7198223438984, -122.471738457278) | |||
| 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) | |||
| 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) | |||
| 176566 | 176566 | 218809 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 118 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996535.53946 | 2090678.52967 | 37.720406603762 | -122.45403210661001 | (37.720406603762, -122.45403210661) | |||
| 1622 | 1622 | 15770 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4770 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001421.7162 | 2091049.3752 | 37.721703820816394 | -122.43716874658399 | (37.7217038208164, -122.437168746584) | ||
| 51721 | 51721 | 176410 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 60 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000924.6013400005 | 2091091.4970599997 | 37.7217912071684 | -122.438890154751 | (37.7217912071684, -122.438890154751) | |||
| 131542 | 131542 | 176411 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 60 Onondaga Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000874.430240001 | 2091115.9770099998 | 37.72185556895379 | -122.43906533639601 | (37.7218555689538, -122.439065336396) | |||
| 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) | ||
| 182926 | 182926 | 66628 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 412 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1991 12:00:00 AM | 16 | Permit Number 29832 | 6002951.536859999 | 2091458.2652 | 37.7229133848294 | -122.43190974564399 | (37.7229133848294, -122.431909745644) | ||
| 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) | ||
| 77451 | 77451 | 31969 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 470 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1995 12:00:00 AM | Permit Number 35370 | 6009517.59351868 | 2092163.53246737 | 37.725219944905895 | -122.40926189775499 | (37.7252199449059, -122.409261897755) | |||
| 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) | ||
| 12464 | 12464 | 111889 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 142 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6011076.19973 | 2092521.5640200002 | 37.72629022399121 | -122.40389910598302 | (37.7262902239912, -122.403899105983) | |||
| 170821 | 170821 | 176422 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 538 Bacon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009782.31983 | 2092607.2094299998 | 37.726453016592394 | -122.40837804183701 | (37.7264530165924, -122.408378041837) | |||
| 31299 | 31299 | 176423 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 538 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009799.11271 | 2092612.1001799998 | 37.726467385945 | -122.408320334118 | (37.726467385945, -122.408320334118) | |||
| 45864 | 45864 | 176424 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 538 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009812.17284 | 2092615.8358900002 | 37.7264783747515 | -122.40827544896601 | (37.7264783747515, -122.408275448966) | |||
| 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) | ||
| 47472 | 47472 | 218808 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 379 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998237.66884 | 2094066.68072 | 37.7298071263007 | -122.448392288972 | (37.7298071263007, -122.448392288972) | ||||
| 132188 | 132188 | 218827 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 15 Rossmoor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991236.4555 | 2094303.51433 | 37.730054641287204 | -122.472613299773 | (37.7300546412872, -122.472613299773) | |||
| 174569 | 174569 | 218806 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 217 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999893.776380001 | 2094346.53737 | 37.730670094141296 | -122.44268704209 | (37.7306700941413, -122.44268704209) | |||
| 187652 | 187652 | 218807 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 238 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5999815.8902199995 | 2094384.2804599998 | 37.7307692875673 | -122.44295901504299 | (37.7307692875673, -122.442959015043) | |||
| 9891 | 9891 | 173730 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 387 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999535.0 | 2094919.0 | 37.7322214835803 | -122.443968498715 | (37.7322214835803, -122.443968498715) | ||||
| 148024 | 148024 | 218804 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 161 San Rafael Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5991882.495080001 | 2095116.63402 | 37.7323246389721 | -122.470439076297 | (37.7323246389721, -122.470439076297) | |||
| 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) | ||
| 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) |
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");