Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, 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 | ||||||||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 128053 | 128053 | 62137 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 127 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/31/1985 12:00:00 AM | Permit Number 22247 | 6001408.1074829 | 2092199.32717361 | 37.7248605551976 | -122.43729808771201 | (37.7248605551976, -122.437298087712) | ||
| 108357 | 108357 | 62139 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 394 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | Permit Number 22347 | 6000980.72200275 | 2092487.56875551 | 37.7256276955072 | -122.43879615169399 | (37.7256276955072, -122.438796151694) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 92829 | 92829 | 63410 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 834 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1987 12:00:00 AM | Permit Number 23993 | 6007543.2306715 | 2095481.74721631 | 37.7342202321398 | -122.41632200823601 | (37.7342202321398, -122.416322008236) | ||
| 81536 | 81536 | 63412 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 832 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1987 12:00:00 AM | Permit Number 23995 | 6007544.46590294 | 2095494.67209225 | 37.7342557904854 | -122.41631865277901 | (37.7342557904854, -122.416318652779) | ||
| 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) | |||
| 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) | |||
| 21680 | 21680 | 5133 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2796 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6002464.77756 | 2095726.89475 | 37.734606468121704 | -122.433897334607 | (37.7346064681217, -122.433897334607) | |||
| 131492 | 131492 | 199432 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1400 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6014474.33722 | 2095838.0719599999 | 37.7355859449403 | -122.39238369005 | (37.7355859449403, -122.39238369005) | |||
| 13913 | 13913 | 26001 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6014400.39468 | 2095925.2599900002 | 37.735821239067796 | -122.392645436853 | (37.7358212390678, -122.392645436853) | |||
| 21001 | 21001 | 5127 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 2764 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/1994 12:00:00 AM | 15 | 3X3 | 6002472.72131 | 2095943.62285 | 37.7352020045603 | -122.433885356532 | (37.7352020045603, -122.433885356532) | ||
| 26758 | 26758 | 224495 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 142 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005480.01407 | 2096145.7478200002 | 37.7359271935727 | -122.42350240381501 | (37.7359271935727, -122.423502403815) | |||
| 76431 | 76431 | 224494 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 140 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005454.36959 | 2096149.2528900001 | 37.73593537021829 | -122.423591316208 | (37.7359353702183, -122.423591316208) | |||
| 52254 | 52254 | 65586 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1779 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1990 12:00:00 AM | 10 | Permit Number 28486 | 6014089.25997 | 2096159.17746 | 37.7364462435881 | -122.39373752768499 | (37.7364462435881, -122.393737527685) | ||
| 31380 | 31380 | 224632 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 667 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007654.90569 | 2096244.9671 | 37.736322146140104 | -122.41598994138599 | (37.7363221461401, -122.415989941386) | |||
| 185283 | 185283 | 224630 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 661 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007657.44331 | 2096273.95417 | 37.7364018809509 | -122.415983219874 | (37.7364018809509, -122.415983219874) | |||
| 90592 | 90592 | 62334 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 66 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | Permit Number 22476 | 6005174.05627534 | 2096389.57268342 | 37.7365794079222 | -122.424577561345 | (37.7365794079222, -122.424577561345) | ||
| 127827 | 127827 | 62333 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 54 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | Permit Number 22475 | 6005123.90294191 | 2096395.98906268 | 37.7365941933288 | -122.42475141936701 | (37.7365941933288, -122.424751419367) | ||
| 77427 | 77427 | 32868 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 456 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37214 | 6003519.04848512 | 2096396.05502281 | 37.736503601704996 | -122.430300092251 | (37.736503601705, -122.430300092251) | |||
| 164602 | 164602 | 218842 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 101 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997801.418330001 | 2096410.61107 | 37.73621804871821 | -122.450069323134 | (37.7362180487182, -122.450069323134) | |||
| 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) | ||
| 4385 | 4385 | 224618 | Planning Code 138.1 required 4 | Ficus microcarpa :: Chinese Banyan 94 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | ||
| 181334 | 181334 | 224503 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 111 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006785.203840001 | 2096905.7488900002 | 37.7380875710875 | -122.41904372338301 | (37.7380875710875, -122.419043723383) | |||
| 17610 | 17610 | 24602 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 419 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007254.49022 | 2097303.30919 | 37.7392055992492 | -122.41744932972401 | (37.7392055992492, -122.417449329724) | |||
| 19544 | 19544 | 24603 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 407 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6007220.87336 | 2097309.53692 | 37.739220807683296 | -122.41756600326401 | (37.7392208076833, -122.417566003264) | |||
| 175191 | 175191 | 224633 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 196 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007335.08307 | 2097320.51793 | 37.739257384923704 | -122.41717189426599 | (37.7392573849237, -122.417171894266) | |||
| 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) | |||
| 172582 | 172582 | 224655 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 144 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6006439.43826 | 2097444.91016 | 37.7395485107564 | -122.42027746554 | (37.7395485107564, -122.42027746554) | |||
| 170759 | 170759 | 224629 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 329 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007740.48208 | 2097528.6384 | 37.7398516362417 | -122.415784934638 | (37.7398516362417, -122.415784934638) |
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");