Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 180418 | 180418 | 143162 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6009943.6415 | 2121579.1756 | 37.8060124294215 | -122.409864588833 | (37.8060124294215, -122.409864588833) | |||
| 137260 | 137260 | 143170 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 179 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009922.0853 | 2121576.7805 | 37.8060046449874 | -122.409939018662 | (37.8060046449874, -122.409939018662) | |||
| 120867 | 120867 | 143169 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 185 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009906.0036 | 2121573.3589 | 37.80599434882029 | -122.40999443049999 | (37.8059943488203, -122.4099944305) | |||
| 163737 | 163737 | 143168 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 189 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6009887.869 | 2121571.9902 | 37.8059895743176 | -122.410057091761 | (37.8059895743176, -122.410057091761) | |||
| 156822 | 156822 | 143167 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 195 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009865.9706 | 2121568.5686 | 37.8059789520686 | -122.410132633272 | (37.8059789520686, -122.410132633272) | |||
| 147016 | 147016 | 142635 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 241 BAY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009773.7882 | 2121554.2814 | 37.805934555696204 | -122.410450636982 | (37.8059345556962, -122.410450636982) | |||
| 157304 | 157304 | 142634 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 241 BAY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6009751.1154 | 2121551.1896 | 37.805924795329204 | -122.410528881628 | (37.8059247953292, -122.410528881628) | |||
| 73921 | 73921 | 142633 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 241 BAY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009714.0145 | 2121546.0367 | 37.805908566732896 | -122.41065691150699 | (37.8059085667329, -122.410656911507) | |||
| 38851 | 38851 | 142632 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 241 BAY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6009699.071 | 2121543.9755 | 37.805902069362794 | -122.410708480373 | (37.8059020693628, -122.410708480373) | |||
| 31190 | 31190 | 142631 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 241 BAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009683.097 | 2121540.8838 | 37.8058926846956 | -122.410763542627 | (37.8058926846956, -122.410763542627) | |||
| 173338 | 173338 | 143166 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2130 STOCKTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009846.1251 | 2121530.2463 | 37.805872616224704 | -122.410198604722 | (37.8058726162247, -122.410198604722) | |||
| 150219 | 150219 | 97934 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009804.1904 | 2121525.9403 | 37.8058584423979 | -122.410343422594 | (37.8058584423979, -122.410343422594) | |||
| 166883 | 166883 | 143165 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2130 STOCKTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009847.836 | 2121509.3744 | 37.805815403092396 | -122.410191209337 | (37.8058154030924, -122.410191209337) | |||
| 39408 | 39408 | 97935 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6009806.2516 | 2121504.2981 | 37.8057991338594 | -122.41033476040501 | (37.8057991338594, -122.410334760405) | |||
| 176541 | 176541 | 143179 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 37 MIDWAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010057.031 | 2121502.7089 | 37.8058088248802 | -122.40946678446899 | (37.8058088248802, -122.409466784469) | |||
| 132458 | 132458 | 97936 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6009809.8586 | 2121486.2629 | 37.8057498158932 | -122.41032100357701 | (37.8057498158932, -122.410321003577) | |||
| 40051 | 40051 | 143180 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 37 MIDWAY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010061.0151 | 2121485.1789 | 37.8057609150954 | -122.40945175887501 | (37.8057609150954, -122.409451758875) | |||
| 135169 | 135169 | 143164 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2130 STOCKTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009854.6792 | 2121476.1846 | 37.805724655750396 | -122.41016518259701 | (37.8057246557504, -122.410165182597) | |||
| 71552 | 71552 | 143163 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2130 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009857.4165 | 2121454.9705 | 37.8056665605493 | -122.410154211058 | (37.8056665605493, -122.410154211058) | |||
| 74568 | 74568 | 97937 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768327 | 6009817.5879999995 | 2121415.668 | 37.8055564131765 | -122.410289267199 | (37.8055564131765, -122.410289267199) | |
| 71988 | 71988 | 143185 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 184 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010419.6313 | 2121347.0095 | 37.8054016230717 | -122.408200957332 | (37.8054016230717, -122.408200957332) | |||
| 130810 | 130810 | 143186 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 184 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6010406.8966 | 2121345.6921 | 37.805397292747 | -122.40824493467501 | (37.805397292747, -122.408244934675) | |||
| 58031 | 58031 | 143187 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 184 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010390.2098 | 2121342.6183 | 37.8053879184635 | -122.408302464879 | (37.8053879184635, -122.408302464879) | |||
| 131255 | 131255 | 143188 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 184 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010371.7665 | 2121341.3009 | 37.8053832684295 | -122.40836619766 | (37.8053832684295, -122.40836619766) | |||
| 39577 | 39577 | 142706 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 567 BAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6008189.6261 | 2121340.372 | 37.805258279506795 | -122.41591773769301 | (37.8052582795068, -122.415917737693) | |||
| 26124 | 26124 | 143189 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 184 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010358.1536 | 2121339.5444 | 37.8053776832044 | -122.408413183131 | (37.8053776832044, -122.408413183131) | |||
| 133674 | 133674 | 56572 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 238 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6010130.9034 | 2121308.9776 | 37.805281025756 | -122.40919745742201 | (37.805281025756, -122.409197457422) | ||||
| 72576 | 72576 | 56573 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 250 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6010068.531 | 2121298.26 | 37.8052481034096 | -122.409412549107 | (37.8052481034096, -122.409412549107) | ||||
| 22298 | 22298 | 143213 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010427.9747 | 2121297.8273 | 37.8052670481181 | -122.40816861291 | (37.8052670481181, -122.40816861291) | |||
| 66204 | 66204 | 143212 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010402.9445 | 2121293.4361 | 37.8052535894305 | -122.408254923564 | (37.8052535894305, -122.408254923564) | |||
| 68186 | 68186 | 143211 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6010376.5969 | 2121289.0448 | 37.8052400566335 | -122.408345793229 | (37.8052400566335, -122.408345793229) | |||
| 44940 | 44940 | 143210 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6010365.1796 | 2121277.1884 | 37.8052068625476 | -122.408384467587 | (37.8052068625476, -122.408384467587) | |||
| 160473 | 160473 | 143217 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 235 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010187.3061 | 2121274.0368 | 37.80518824668 | -122.40899980098 | (37.80518824668, -122.40899980098) | |||
| 34879 | 34879 | 143218 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 251 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010143.2987 | 2121269.7317 | 37.8051739606787 | -122.409151790672 | (37.8051739606787, -122.409151790672) | |||
| 51113 | 51113 | 53752 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 251 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1972 12:00:00 AM | 13 | Permit Number 9432 | 6010125.6 | 2121266.3833 | 37.805163775279205 | -122.40921280301701 | (37.8051637752792, -122.409212803017) | ||
| 29034 | 29034 | 64425 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 259 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1988 12:00:00 AM | 9 | Permit Number 25277 | 6010096.4211 | 2121261.5999 | 37.8051490065079 | -122.409313442808 | (37.8051490065079, -122.409313442808) | ||
| 4565 | 4565 | 142525 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 301 FRANCISCO ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 23 | Width 0ft | 6009759.5801 | 2121214.59 | 37.8050010513122 | -122.410475804946 | (37.8050010513122, -122.410475804946) | |||
| 36777 | 36777 | 142949 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 20 BELLAIR PL | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010058.1538 | 2121167.8448 | 37.8048894342531 | -122.40943925119 | (37.8048894342531, -122.40943925119) | |||
| 28588 | 28588 | 143227 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 106 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010308.3267 | 2121146.7978 | 37.8048456584244 | -122.408572011197 | (37.8048456584244, -122.408572011197) | |||
| 26086 | 26086 | 59151 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 112 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1980 12:00:00 AM | 13 | Permit Number 18460 | 6010290.1497 | 2121142.971 | 37.8048341329685 | -122.408634644798 | (37.8048341329685, -122.408634644798) | ||
| 72229 | 72229 | 142948 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 20 BELLAIR PL | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6010061.9805 | 2121140.5793 | 37.804814784372894 | -122.409424083009 | (37.8048147843729, -122.409424083009) | |||
| 182228 | 182228 | 142947 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 21 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6010050.2611 | 2121139.8618 | 37.8048121576562 | -122.40946458873002 | (37.8048121576562, -122.40946458873) | |||
| 113892 | 113892 | 142943 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 112 PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010269.581 | 2121139.6226 | 37.8048237870919 | -122.408705588917 | (37.8048237870919, -122.408705588917) | |||
| 171274 | 171274 | 59153 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 20 Bellair Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/1982 12:00:00 AM | 11 | Permit Number 19779 | 6010063.4155 | 2121130.5341 | 37.8047872831513 | -122.40941840765801 | (37.8047872831513, -122.409418407658) | ||
| 70577 | 70577 | 142944 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 152 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6010124.6433 | 2121121.924 | 37.8047670723213 | -122.409205913626 | (37.8047670723213, -122.409205913626) | |||
| 41314 | 41314 | 142953 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 19 PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010052.6528 | 2121119.7714 | 37.804757128417 | -122.409454893216 | (37.804757128417, -122.409454893216) | |||
| 57517 | 57517 | 142945 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 152 PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010109.3364 | 2121119.0539 | 37.804758334186296 | -122.40925868229799 | (37.8047583341863, -122.409258682298) | |||
| 178610 | 178610 | 142946 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 154 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010096.4211 | 2121116.6622 | 37.8047510435874 | -122.409303208326 | (37.8047510435874, -122.409303208326) | |||
| 153908 | 153908 | 142950 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 156 Pfeiffer St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6010083.0275 | 2121115.7055 | 37.8047476663275 | -122.409349490891 | (37.8047476663275, -122.409349490891) | |||
| 5526 | 5526 | 99210 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007993.4855 | 2121112.3432 | 37.8046211410646 | -122.416580345595 | (37.8046211410646, -122.416580345595) | |||
| 27469 | 27469 | 143247 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 153 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010131.5523 | 2121103.7243 | 37.8047174875245 | -122.40918071917 | (37.8047174875245, -122.40918071917) | |||
| 5501 | 5501 | 99227 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008003.9616 | 2121103.5041 | 37.8045974602939 | -122.416543465428 | (37.8045974602939, -122.416543465428) | |||
| 29795 | 29795 | 142969 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 155 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010117.5609 | 2121101.8588 | 37.804711581482294 | -122.40922900630501 | (37.8047115814823, -122.409229006305) | |||
| 147044 | 147044 | 142958 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 172 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009982.8149 | 2121100.1594 | 37.8046993654404 | -122.40969519031 | (37.8046993654404, -122.40969519031) | |||
| 177709 | 177709 | 142959 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 178 Pfeiffer St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009960.8111 | 2121097.7677 | 37.8046915653635 | -122.409771168052 | (37.8046915653635, -122.409771168052) | |||
| 35662 | 35662 | 142960 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 180 Pfeiffer St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6009952.201 | 2121096.8109999998 | 37.804688455991396 | -122.409800896711 | (37.8046884559914, -122.409800896711) | |||
| 61609 | 61609 | 142961 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 188 Pfeiffer St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6009941.6774 | 2121096.8109999998 | 37.8046878662366 | -122.409837314827 | (37.8046878662366, -122.409837314827) | |||
| 6739 | 6739 | 99228 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008013.4555 | 2121093.6827 | 37.8045710271276 | -122.416509914664 | (37.8045710271276, -122.416509914664) | |||
| 64926 | 64926 | 142962 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 192 Pfeiffer St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009928.7622 | 2121093.4626 | 37.804677948564404 | -122.409881772835 | (37.8046779485644, -122.409881772835) | |||
| 49366 | 49366 | 142561 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2145 POWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009379.1154 | 2121092.3828 | 37.80464416450771 | -122.41178381071998 | (37.8046441645077, -122.41178381072) | |||
| 36885 | 36885 | 142970 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010034.7291 | 2121089.9447 | 37.804674227418296 | -122.409514813908 | (37.8046742274183, -122.409514813908) | |||
| 6213 | 6213 | 99229 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008022.9494 | 2121084.5162 | 37.804546392141496 | -122.416476410342 | (37.8045463921415, -122.416476410342) | |||
| 29471 | 29471 | 56977 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 177 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 14 | Permit Number 14230 | 6009999.8042 | 2121084.2658 | 37.8046566775876 | -122.40963527441002 | (37.8046566775876, -122.40963527441) | ||
| 177052 | 177052 | 142562 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2145 POWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6009382.2185 | 2121078.4189 | 37.804605997205 | -122.41177208479999 | (37.804605997205, -122.4117720848) | |||
| 8449 | 8449 | 7686 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 521 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6008772.4139 | 2121077.9257 | 37.8045704150203 | -122.413882343906 | (37.8045704150203, -122.413882343906) | |||
| 8204 | 8204 | 7685 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 521 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6008756.4018 | 2121076.0419 | 37.804564343319605 | -122.41393762212 | (37.8045643433196, -122.41393762212) | |||
| 8148 | 8148 | 99230 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008035.3898 | 2121073.3853 | 37.8045165290969 | -122.416432570152 | (37.8045165290969, -122.416432570152) | |||
| 8426 | 8426 | 99231 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008046.5206 | 2121063.2366 | 37.804489289265106 | -122.416393331612 | (37.8044892892651, -122.416393331612) | |||
| 8244 | 8244 | 99232 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008054.705 | 2121057.3439 | 37.8044735696368 | -122.416364591045 | (37.8044735696368, -122.416364591045) | |||
| 3051 | 3051 | 99233 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008063.2168 | 2121048.832 | 37.8044506767497 | -122.416334531861 | (37.8044506767497, -122.416334531861) | |||
| 134965 | 134965 | 63910 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2135 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1991 12:00:00 AM | 14 | Permit Number 30246 | 6009385.3216 | 2121038.8544 | 37.804497537044895 | -122.411758548847 | (37.8044975370449, -122.411758548847) | ||
| 29179 | 29179 | 63908 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2125 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1987 12:00:00 AM | 14 | Permit Number 24623 | 6009389.9763 | 2121003.9446 | 37.8044019445665 | -122.411739972568 | (37.8044019445665, -122.411739972568) | ||
| 48871 | 48871 | 142566 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2125 POWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009390.752 | 2120983.7745 | 37.804346606020495 | -122.41173586211 | (37.8043466060205, -122.41173586211) | |||
| 7263 | 7263 | 4725 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1050 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6008238.1211 | 2120976.4945 | 37.8042618899237 | -122.415724133248 | (37.8042618899237, -122.415724133248) | |||
| 29578 | 29578 | 108616 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 289 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6010459.7673 | 2120958.2392 | 37.8043364033733 | -122.408034626667 | (37.8043364033733, -122.408034626667) | |||
| 175202 | 175202 | 63909 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2119 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1987 12:00:00 AM | 12 | Permit Number 24624 | 6009399.6734 | 2120957.786 | 37.804275748547504 | -122.41170315133301 | (37.8042757485475, -122.411703151333) | ||
| 5852 | 5852 | 4724 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1050 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6008259.9153 | 2120954.1415 | 37.8042017393393 | -122.41564712883101 | (37.8042017393393, -122.415647128831) | |||
| 40096 | 40096 | 142987 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1871 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6010368.8695 | 2120931.1728 | 37.8042569960583 | -122.408347277199 | (37.8042569960583, -122.408347277199) | |||
| 5637 | 5637 | 4723 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1050 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 5x5 | 6008295.1213 | 2120922.8472 | 37.804117792011795 | -122.41552307845801 | (37.8041177920118, -122.415523078458) | |||
| 44685 | 44685 | 142988 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1861 Grant Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010372.0828 | 2120911.5359 | 37.804203257928 | -122.408334771369 | (37.804203257928, -122.408334771369) | |||
| 6233 | 6233 | 4722 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1040 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 4x4 | 6008317.4743 | 2120903.2884 | 37.804065344872704 | -122.415444338519 | (37.8040653448727, -122.415444338519) | |||
| 72866 | 72866 | 142989 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1851 Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6010373.868 | 2120901.8959999997 | 37.8041768891146 | -122.408327913174 | (37.8041768891146, -122.408327913174) | |||
| 7692 | 7692 | 4721 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1040 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5x5 | 6008335.3567 | 2120887.0824 | 37.8040218523597 | -122.415381307054 | (37.8040218523597, -122.415381307054) | |||
| 23286 | 23286 | 4726 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1075 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 6008251.3021 | 2120879.6119999997 | 37.803996615927794 | -122.41567165532301 | (37.8039966159278, -122.415671655323) | ||||
| 5730 | 5730 | 4720 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1040 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 5x5 | 6008353.7979 | 2120870.8765 | 37.8039783914932 | -122.415316341899 | (37.8039783914932, -122.415316341899) | |||
| 23229 | 23229 | 28073 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1075 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008262.9463 | 2120869.8064 | 37.803970346765496 | -122.415630664984 | (37.8039703467655, -122.415630664984) | |||
| 188248 | 188248 | 142992 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 455 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6009662.0127 | 2120854.6155 | 37.804007180841204 | -122.41078801080799 | (37.8040071808412, -122.410788010808) | |||
| 167676 | 167676 | 142591 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008291.5451 | 2120841.4416 | 37.8038940717069 | -122.41552968724 | (37.8038940717069, -122.41552968724) | |||
| 24338 | 24338 | 142592 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008300.8769 | 2120835.2204 | 37.803877514381 | -122.415496953155 | (37.803877514381, -122.415496953155) | |||
| 63234 | 63234 | 142593 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008314.0969 | 2120822.0003 | 37.8038419583694 | -122.415450267897 | (37.8038419583694, -122.415450267897) | |||
| 47603 | 47603 | 142594 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008329.6499 | 2120808.0026 | 37.8038043983711 | -122.41539545409401 | (37.8038043983711, -122.415395454094) | |||
| 167035 | 167035 | 142595 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008339.7594 | 2120798.6708 | 37.803779343791795 | -122.415359808453 | (37.8037793437918, -122.415359808453) | |||
| 156752 | 156752 | 142993 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008349.8689 | 2120789.339 | 37.803754289201606 | -122.415324162836 | (37.8037542892016, -122.415324162836) | |||
| 173501 | 173501 | 142596 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008359.2007 | 2120780.7848 | 37.8037313259866 | -122.415291263605 | (37.8037313259866, -122.415291263605) | |||
| 130431 | 130431 | 142597 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008368.5325 | 2120773.0083 | 37.8037104981311 | -122.41525841948 | (37.8037104981311, -122.41525841948) | |||
| 164164 | 164164 | 142598 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008376.308999999 | 2120765.2318 | 37.8036895828586 | -122.415230957587 | (37.8036895828586, -122.415230957587) | |||
| 39425 | 39425 | 142599 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008384.0855 | 2120756.6777 | 37.8036665324855 | -122.415203440632 | (37.8036665324855, -122.415203440632) | |||
| 178657 | 178657 | 142600 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008394.1949 | 2120748.9012 | 37.803645748305 | -122.415167905628 | (37.803645748305, -122.415167905628) | |||
| 34909 | 34909 | 143246 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 647 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6008746.811000001 | 2120723.5878 | 37.8035960540957 | -122.413945863948 | (37.8035960540957, -122.413945863948) | |||
| 49979 | 49979 | 53483 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 647 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1969 12:00:00 AM | 16 | Permit Number 6392 | 6008737.1169 | 2120721.7235 | 37.80359039074771 | -122.413979278997 | (37.8035903907477, -122.413979278997) |
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");