Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30887 | 30887 | 140482 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1137 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003743.6898 | 2112670.736 | 37.781202719512 | -122.430684409839 | (37.781202719512, -122.430684409839) | |||
| 6214 | 6214 | 23797 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1143 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003734.1252 | 2112710.5884 | 37.7813116023897 | -122.430720343349 | (37.7813116023897, -122.430720343349) | |||
| 273 | 273 | 20166 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1155X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4X4 | 6002621.0 | 2112212.0 | 37.7798794773869 | -122.43453554599199 | (37.7798794773869, -122.434535545992) | |||
| 183176 | 183176 | 142938 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1160 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010744.0272 | 2118552.2837 | 37.797746150342604 | -122.406881242638 | (37.7977461503426, -122.406881242638) | |||
| 171470 | 171470 | 140525 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1190 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6003468.9224 | 2111772.2595 | 37.7787201566355 | -122.43157080528799 | (37.7787201566355, -122.431570805288) | |||
| 1644 | 1644 | 14813 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1195 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003481.2511 | 2111720.7527 | 37.778579430545896 | -122.431524477475 | (37.7785794305459, -122.431524477475) | |||
| 74755 | 74755 | 199769 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1197 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6016909.41 | 2092306.5247 | 37.726023933628895 | -122.383718829233 | (37.7260239336289, -122.383718829233) | |||
| 178515 | 178515 | 142934 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1201 KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6011088.1877 | 2119032.3 | 37.7990834099948 | -122.40572417480699 | (37.7990834099948, -122.405724174807) | |||
| 52503 | 52503 | 142516 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1205 KEARNY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6011083.7416 | 2119059.5323 | 37.7991579346332 | -122.40574147910499 | (37.7991579346332, -122.405741479105) | |||
| 23414 | 23414 | 64062 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1205 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | Permit Number 29268 | 6011082.0743 | 2119072.3147 | 37.799192938755 | -122.405748149412 | (37.799192938755, -122.405748149412) | |
| 18281 | 18281 | 17048 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1205 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001170.7121 | 2109662.4759 | 37.7727966927365 | -122.43936992159401 | (37.7727966927365, -122.439369921594) | |||
| 18240 | 18240 | 14585 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1206 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999464.9463 | 2108691.264 | 37.7700327707282 | -122.44520049918002 | (37.7700327707282, -122.44520049918) | |||
| 43462 | 43462 | 142119 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1208 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6002005.9378 | 2110874.6586 | 37.776172539897296 | -122.43656756597 | (37.7761725398973, -122.43656756597) | |||
| 156324 | 156324 | 77283 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1210 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 16 | 6001986.2323 | 2110871.5472 | 37.7761628769629 | -122.436635509753 | (37.7761628769629, -122.436635509753) | ||
| 8969 | 8969 | 8181 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1212 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6001826.5111 | 2111197.1465 | 37.7770478129311 | -122.43721134601002 | (37.7770478129311, -122.43721134601) | |||
| 52482 | 52482 | 245025 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1215 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001121.5198 | 2109662.8083 | 37.772794805840704 | -122.43954010678499 | (37.7727948058407, -122.439540106785) | |||
| 55308 | 55308 | 139484 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1216 FULTON ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 0ft | 6001778.449 | 2111192.2794 | 37.7770317168845 | -122.437377258879 | (37.7770317168845, -122.437377258879) | |||
| 155583 | 155583 | 142120 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1218 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6001961.8598 | 2110867.3987 | 37.77615010114471 | -122.436719523648 | (37.7761501011447, -122.436719523648) | |||
| 76841 | 76841 | 140576 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1219 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003302.4616 | 2111703.7722 | 37.7785226712194 | -122.432141765433 | (37.7785226712194, -122.432141765433) | |||
| 3945 | 3945 | 6232 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1220 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6005007.0756 | 2113377.0261 | 37.7832135118405 | -122.42636402033199 | (37.7832135118405, -122.426364020332) | ||
| 7032 | 7032 | 6224 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1220 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6005090.9413 | 2113387.3731 | 37.7832466624445 | -122.42607461530899 | (37.7832466624445, -122.426074615309) | |||
| 67205 | 67205 | 142124 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1221 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001940.0404 | 2111161.7753 | 37.776957145428 | -122.43681608077499 | (37.776957145428, -122.436816080775) | |||
| 130015 | 130015 | 142107 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1223 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001862.2998 | 2111151.4099 | 37.776924266063105 | -122.437084266624 | (37.7769242660631, -122.437084266624) | |||
| 166925 | 166925 | 142506 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1223 KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6011074.9884 | 2119120.527 | 37.7993249217375 | -122.405776067035 | (37.7993249217375, -122.405776067035) | |||
| 20305 | 20305 | 17050 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1225 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001073.9894 | 2109656.1607 | 37.7727738479618 | -122.43970404277201 | (37.7727738479618, -122.439704042772) | |||
| 74499 | 74499 | 199975 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1233 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016858.7319 | 2092693.7716 | 37.7270844364031 | -122.38392097441299 | (37.7270844364031, -122.383920974413) | |||
| 53528 | 53528 | 65955 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1234 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1990 12:00:00 AM | 13 | Permit Number 28976 | 6001892.8907 | 2110857.546 | 37.7761191282962 | -122.436957400422 | (37.7761191282962, -122.436957400422) | ||
| 6753 | 6753 | 14817 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1234 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003267.0451 | 2111739.9368 | 37.7786199621548 | -122.43226686795799 | (37.7786199621548, -122.432266867958) | |||
| 23207 | 23207 | 7224 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1234X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 6003339.1357 | 2111756.6534 | 37.778669949054 | -122.432018673024 | (37.778669949054, -122.432018673024) | ||||
| 29669 | 29669 | 137591 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1235 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6002786.4345 | 2112612.3356 | 37.7809880882364 | -122.433991859956 | (37.7809880882364, -122.433991859956) | |||
| 157150 | 157150 | 43881 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1245 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 3 | Permit Number 43494 | 5981473.1113 | 2106617.2091 | 37.7632946239394 | -122.507278997702 | (37.7632946239394, -122.507278997702) | ||
| 172121 | 172121 | 142923 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1249 KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6011057.7598 | 2119245.0173 | 37.7996657782982 | -122.40584445833099 | (37.7996657782982, -122.405844458331) | |||
| 5652 | 5652 | 6235 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1250 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004904.9664 | 2113362.05 | 37.7831666187465 | -122.426716210533 | (37.7831666187465, -122.426716210533) | ||
| 7583 | 7583 | 6242 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1250 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004855.4094 | 2113352.7921 | 37.783138396913294 | -122.426886998286 | (37.7831383969133, -122.426886998286) | ||
| 58145 | 58145 | 183272 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1251 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5983645.262999999 | 2106639.9345 | 37.7634847239936 | -122.49976803825199 | (37.7634847239936, -122.499768038252) | |||
| 187140 | 187140 | 183273 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1251 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5983646.3542 | 2106625.2038 | 37.7634443416971 | -122.49976317535801 | (37.7634443416971, -122.499763175358) | |||
| 167397 | 167397 | 142113 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1270 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6001736.8029 | 2110836.8034 | 37.7760533014164 | -122.437495863249 | (37.7760533014164, -122.437495863249) | |||
| 153102 | 153102 | 55473 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1270 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 18 | Permit Number 11425 | 6001761.1754 | 2110839.3962 | 37.7760618062261 | -122.43741173817101 | (37.7760618062261, -122.437411738171) | ||
| 6970 | 6970 | 6245 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1280 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6004753.0279 | 2113338.633 | 37.7830937301366 | -122.427240188063 | (37.7830937301366, -122.427240188063) | ||
| 40023 | 40023 | 141792 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1280 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003805.1483 | 2112935.1558 | 37.7819322319873 | -122.43049066646499 | (37.7819322319873, -122.430490666465) | |||
| 46667 | 46667 | 141799 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1280 WEBSTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003782.7951 | 2113127.1113 | 37.782458027558 | -122.43058169950899 | (37.782458027558, -122.430581699509) | |||
| 68791 | 68791 | 141793 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1280 WEBSTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003797.3488 | 2112989.7381 | 37.7820816595285 | -122.430521544957 | (37.7820816595285, -122.430521544957) | |||
| 147829 | 147829 | 141798 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1280 WEBSTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003785.6349 | 2113107.9429 | 37.7824055567974 | -122.43057050684901 | (37.7824055567974, -122.430570506849) | |||
| 18203 | 18203 | 17058 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1285 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000917.1059 | 2109633.5588 | 37.7727028580257 | -122.44024509796301 | (37.7727028580257, -122.440245097963) | |||
| 21314 | 21314 | 17056 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1285 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x4.5 | 6000853.6213 | 2109624.5846 | 37.7726746024779 | -122.44046405381799 | (37.7726746024779, -122.440464053818) | |||
| 22235 | 22235 | 17057 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1285 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6000879.2146 | 2109627.576 | 37.772684273376 | -122.440375738629 | (37.772684273376, -122.440375738629) | |||
| 23633 | 23633 | 137529 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300 Pierce St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6002258.0131 | 2113181.285 | 37.7825202770743 | -122.43586064910801 | (37.7825202770743, -122.435860649108) | |||
| 49750 | 49750 | 137532 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300 Pierce St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002250.4834 | 2113262.6052 | 37.7827431340216 | -122.435892519009 | (37.7827431340216, -122.435892519009) | |||
| 60794 | 60794 | 137528 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300 Pierce St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6002263.2838 | 2113153.4253 | 37.7824440807926 | -122.435840420812 | (37.7824440807926, -122.435840420812) | |||
| 13740 | 13740 | 97243 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016226.9194 | 2094855.7145 | 37.7329857540551 | -122.38625582218701 | (37.7329857540551, -122.386255822187) | |||
| 15892 | 15892 | 97244 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016216.2447 | 2094842.5281 | 37.7329489559822 | -122.38629180873501 | (37.7329489559822, -122.386291808735) | |||
| 16688 | 16688 | 97242 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016235.0824 | 2094868.9009 | 37.7330224130953 | -122.386228519291 | (37.7330224130953, -122.386228519291) | |||
| 129779 | 129779 | 141586 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1301 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6001472.6683 | 2111100.3675 | 37.776761961586 | -122.438428460489 | (37.776761961586, -122.438428460489) | |||
| 6530 | 6530 | 8195 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1301 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001448.9604 | 2111096.3198 | 37.776749499067705 | -122.438510182933 | (37.7767494990677, -122.438510182933) | |||
| 46963 | 46963 | 139407 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1311 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000207.9303 | 2113507.6319999998 | 37.7832996726996 | -122.44297646838301 | (37.7832996726996, -122.442976468383) | |||
| 18161 | 18161 | 107661 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1312 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5999086.9 | 2105066.2 | 37.7600576690463 | -122.446247345124 | (37.7600576690463, -122.446247345124) | |||
| 148225 | 148225 | 137640 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1319 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6002813.9379 | 2111632.5778 | 37.778299479553105 | -122.433826662886 | (37.7782994795531, -122.433826662886) | |||
| 170504 | 170504 | 245138 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1320 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000087.6508 | 2109218.0834 | 37.7715148081993 | -122.443084420904 | (37.7715148081993, -122.443084420904) | |||
| 72332 | 72332 | 182039 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1323 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5988935.747 | 2106319.8798 | 37.7629149697028 | -122.481446720354 | (37.7629149697028, -122.481446720354) | |||
| 172304 | 172304 | 248308 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1327 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999347.2972 | 2108376.4732 | 37.76916171869029 | -122.445584804207 | (37.7691617186903, -122.445584804207) | |||
| 71407 | 71407 | 140492 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1330 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003634.4941 | 2112489.009 | 37.7806975555682 | -122.431049198514 | (37.7806975555682, -122.431049198514) | |||
| 8759 | 8759 | 22673 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1330 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003656.8115 | 2112490.6031 | 37.780703197144 | -122.430972105719 | (37.780703197144, -122.430972105719) | |||
| 25206 | 25206 | 98347 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1331 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6011023.1341 | 2119487.8255 | 37.800330533908294 | -122.40598139081999 | (37.8003305339083, -122.40598139082) | |||
| 168121 | 168121 | 248309 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1333 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999321.5567 | 2108373.142 | 37.769151102475 | -122.445673599246 | (37.769151102475, -122.445673599246) | |||
| 38684 | 38684 | 137659 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1334 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002765.4317 | 2111672.0138 | 37.778405008308795 | -122.43399728327101 | (37.7784050083088, -122.433997283271) | |||
| 67147 | 67147 | 92952 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1334 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6006791.0528 | 2115558.9055 | 37.789305097845 | -122.42034707761499 | (37.789305097845, -122.420347077615) | ||||
| 5681 | 5681 | 14846 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1335 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6002759.5163 | 2111624.2963 | 37.7782736522759 | -122.43401433498501 | (37.7782736522759, -122.434014334985) | |||
| 149706 | 149706 | 92953 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1338 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6006789.4485 | 2115574.9476 | 37.7893490550841 | -122.420353767408 | (37.7893490550841, -122.420353767408) | ||||
| 146640 | 146640 | 142920 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1339 KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6011019.5196 | 2119515.0732 | 37.800405147287 | -122.405995819069 | (37.800405147287, -122.405995819069) | |||
| 7272 | 7272 | 14849 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1344 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002734.6717 | 2111669.6476 | 37.7783967656122 | -122.43410352432501 | (37.7783967656122, -122.434103524325) | |||
| 134348 | 134348 | 97114 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1345 Noriega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 18860 | 5989801.9904 | 2103085.8445 | 37.7540855022306 | -122.47821424615101 | (37.7540855022306, -122.478214246151) | |||
| 175857 | 175857 | 140293 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 135 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998254.8738 | 2110151.3644 | 37.773972687525 | -122.449491324786 | (37.773972687525, -122.449491324786) | |||
| 17107 | 17107 | 17067 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1355 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000506.9486 | 2109572.2346 | 37.772511116707605 | -122.441659471159 | (37.7725111167076, -122.441659471159) | |||
| 169792 | 169792 | 246387 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1356 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5999191.1888 | 2108399.0339 | 37.7692147510646 | -122.446126395439 | (37.7692147510646, -122.446126395439) | |||
| 6076 | 6076 | 8204 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1369 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001211.3032 | 2111062.2036 | 37.7766423030153 | -122.439329862063 | (37.7766423030153, -122.439329862063) | |||
| 18241 | 18241 | 10403 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1369 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5999594.2543 | 2108755.1609 | 37.77021559548189 | -122.44475781986999 | (37.7702155954819, -122.44475781987) | |||
| 19910 | 19910 | 17068 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1369 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000465.401000001 | 2109559.9366 | 37.7724749822064 | -122.441802305278 | (37.7724749822064, -122.441802305278) | |||
| 165188 | 165188 | 62369 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 137 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1985 12:00:00 AM | 9 | 3x3 | Permit Number 22515 | 5998258.1694 | 2110129.1192 | 37.773911796453596 | -122.44947832162799 | (37.7739117964536, -122.449478321628) | |
| 39156 | 39156 | 248312 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1375 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999157.272000001 | 2108349.6728 | 37.769077281031606 | -122.44624016016199 | (37.7690772810316, -122.446240160162) | |||
| 156171 | 156171 | 246039 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1378 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999138.4966 | 2108392.6745 | 37.7691942805388 | -122.446308196721 | (37.7691942805388, -122.446308196721) | |||
| 183831 | 183831 | 246038 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1378 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999156.0607 | 2108395.7028 | 37.7692035985916 | -122.446247661551 | (37.7692035985916, -122.446247661551) | |||
| 151317 | 151317 | 245078 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1387 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000393.4407 | 2109556.4466 | 37.7724612989944 | -122.442050971779 | (37.7724612989944, -122.442050971779) | |||
| 185478 | 185478 | 245077 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1387 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000372.5007 | 2109554.1199 | 37.7724537171291 | -122.442123238035 | (37.7724537171291, -122.442123238035) | |||
| 188994 | 188994 | 245076 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1387 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000344.2484 | 2109550.1314 | 37.7724411555945 | -122.442220678844 | (37.7724411555945, -122.442220678844) | |||
| 1154 | 1154 | 246084 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999058.5497 | 2108380.2585 | 37.7691556230859 | -122.446583834228 | (37.7691556230859, -122.446583834228) | |||
| 1164 | 1164 | 246083 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999078.2336 | 2108382.6812 | 37.7691633995354 | -122.446515923307 | (37.7691633995354, -122.446515923307) | |||
| 1169 | 1169 | 246080 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 12 | Width 0ft | Permit Number 17683 | 5999123.3551 | 2108389.3434 | 37.7691842694065 | -122.446360330481 | (37.7691842694065, -122.446360330481) | |
| 1176 | 1176 | 246082 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999092.1637 | 2108384.801 | 37.7691700156221 | -122.44646789257601 | (37.7691700156221, -122.446467892576) | |||
| 72459 | 72459 | 141344 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1391 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001208.1693 | 2110371.5133 | 37.7747456630859 | -122.439291184524 | (37.7747456630859, -122.439291184524) | |||
| 62505 | 62505 | 140491 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1396 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6003381.0328 | 2112450.7507 | 37.7805781423675 | -122.431923310003 | (37.7805781423675, -122.431923310003) | |||
| 7852 | 7852 | 14863 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1398 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6002510.6756 | 2111638.0989 | 37.77829742557871 | -122.434876152922 | (37.7782974255787, -122.434876152922) | |||
| 68178 | 68178 | 32290 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1400 Egbert Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 13 | Permit Number 36872 | 6014301.1518 | 2091179.5011 | 37.7227848326743 | -122.392656680249 | (37.7227848326743, -122.392656680249) | ||
| 177466 | 177466 | 32291 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1400 Egbert Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 7 | Permit Number 36872 | 6014236.59 | 2091225.7906 | 37.722908348540294 | -122.39288309530001 | (37.7229083485403, -122.3928830953) | ||
| 41015 | 41015 | 138010 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1401 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6005424.6122 | 2114535.8430000003 | 37.7864189291949 | -122.42500198582199 | (37.7864189291949, -122.425001985822) | |||
| 56971 | 56971 | 138011 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1401 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6005427.9087 | 2114512.7674 | 37.786355755539105 | -122.424988938346 | (37.7863557555391, -122.424988938346) | |||
| 185285 | 185285 | 105341 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1407 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6000167.325 | 2113807.8025 | 37.7841215482425 | -122.44313851129999 | (37.7841215482425, -122.4431385113) | ||||
| 19368 | 19368 | 17069 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1407 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000238.3853 | 2109534.8419 | 37.7723931405508 | -122.442585770509 | (37.7723931405508, -122.442585770509) | |||
| 18854 | 18854 | 17070 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1419 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000207.1415 | 2109530.5209 | 37.7723794951397 | -122.442693535131 | (37.7723794951397, -122.442693535131) | |||
| 135505 | 135505 | 142472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1429 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6010978.9762 | 2119829.6657 | 37.8012666737636 | -122.40615829244699 | (37.8012666737636, -122.406158292447) | |||
| 171052 | 171052 | 142473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1429 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6010981.054 | 2119812.8124 | 37.8012205149436 | -122.40614991427499 | (37.8012205149436, -122.406149914275) |
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");