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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21803 | 21803 | 15326 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1700X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006681.5676 | 2108466.3283 | 37.769824429915204 | -122.420222300021 | (37.7698244299152, -122.420222300021) | |||
| 21249 | 21249 | 15334 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1720 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 4 | 3x3 | 6006687.4636 | 2108380.8364 | 37.7695900216736 | -122.420195837478 | (37.7695900216736, -122.420195837478) | ||
| 894 | 894 | 15433 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2135 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006876.1683 | 2105910.6162 | 37.7628180091578 | -122.419367848279 | (37.7628180091578, -122.419367848279) | |||
| 17778 | 17778 | 15435 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2141 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006881.4762 | 2105834.0306 | 37.7626080219354 | -122.419344056803 | (37.7626080219354, -122.419344056803) | |||
| 21777 | 21777 | 15445 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2250 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006857.7723 | 2105245.8857 | 37.7609917781074 | -122.419384314212 | (37.7609917781074, -122.419384314212) | |||
| 17957 | 17957 | 15626 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3550 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005569.6902 | 2097797.6263 | 37.7404679423018 | -122.42330974756901 | (37.7404679423018, -122.423309747569) | |||
| 20461 | 20461 | 15627 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3550 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005560.95 | 2097781.3943 | 37.7404228796109 | -122.423338814191 | (37.7404228796109, -122.423338814191) | |||
| 21132 | 21132 | 15628 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3550 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005530.9833 | 2097730.2012 | 37.74028062358521 | -122.423438788897 | (37.7402806235852, -122.423438788897) | |||
| 12618 | 12618 | 15750 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 4625 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6002067.6674 | 2091962.7327 | 37.7242483928285 | -122.43500115616301 | (37.7242483928285, -122.435001156163) | |||
| 11043 | 11043 | 15768 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 4770 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 15 | 3x3 | 6001444.506 | 2091085.1877 | 37.721803449313896 | -122.437092531149 | (37.7218034493139, -122.437092531149) | ||
| 17156 | 17156 | 16864 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 230 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005857.5291 | 2110371.9412 | 37.7750103183132 | -122.423208108745 | (37.7750103183132, -122.423208108745) | |||
| 22102 | 22102 | 16865 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 230 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005838.6934 | 2110371.3705 | 37.7750076883115 | -122.423273225017 | (37.7750076883115, -122.423273225017) | |||
| 18202 | 18202 | 16867 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 235 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6005854.7098 | 2110323.2964 | 37.7748765923478 | -122.42321440275299 | (37.7748765923478, -122.423214402753) | |||
| 19775 | 19775 | 16873 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 262 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005733.6702 | 2110353.6763 | 37.7749531766501 | -122.423635265131 | (37.7749531766501, -122.423635265131) | |||
| 18861 | 18861 | 16876 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 274 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005679.4463 | 2110349.1101 | 37.7749375780539 | -122.423822512667 | (37.7749375780539, -122.423822512667) | |||
| 21752 | 21752 | 16896 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 377 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005209.3255 | 2110233.2837 | 37.7745929962798 | -122.425440517449 | (37.7745929962798, -122.425440517449) | |||
| 17085 | 17085 | 16938 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 595X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004175.1129 | 2110087.9596 | 37.7741354848182 | -122.42900769942301 | (37.7741354848182, -122.429007699423) | |||
| 20691 | 20691 | 16953 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 643 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003890.8551 | 2110044.9948 | 37.774001419661104 | -122.42998793149401 | (37.7740014196611, -122.429987931494) | |||
| 22087 | 22087 | 16962 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 729 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003498.0043 | 2109990.6447 | 37.7738299314263 | -122.431342987883 | (37.7738299314263, -122.431342987883) | |||
| 18389 | 18389 | 16963 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 741 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003456.556 | 2109979.0777 | 37.7737958222062 | -122.43148553825701 | (37.7737958222062, -122.431485538257) | |||
| 20998 | 20998 | 16964 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 747 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6003424.2649 | 2109979.0777 | 37.7737939919852 | -122.431597238278 | (37.7737939919852, -122.431597238278) | |||
| 21454 | 21454 | 16971 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 780 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003271.9397 | 2110011.5439 | 37.7738745011261 | -122.43212647411501 | (37.7738745011261, -122.432126474115) | |||
| 21063 | 21063 | 16972 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 780 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003244.9501 | 2110008.9107 | 37.7738657407699 | -122.43221964740499 | (37.7738657407699, -122.432219647405) | |||
| 17134 | 17134 | 16973 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 779 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003283.5334 | 2109961.2453 | 37.773737050882396 | -122.432082777045 | (37.7737370508824, -122.432082777045) | |||
| 18612 | 18612 | 16974 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 785 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003248.3505 | 2109954.9799 | 37.7737178528926 | -122.43220403261299 | (37.7737178528926, -122.432204032613) | |||
| 17964 | 17964 | 16976 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 811 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003075.3996 | 2109932.9295 | 37.7736475004085 | -122.432800720802 | (37.7736475004085, -122.432800720802) | |||
| 17671 | 17671 | 16978 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 823 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003035.6347 | 2109919.8489 | 37.7736093289353 | -122.432937338869 | (37.7736093289353, -122.432937338869) | |||
| 21967 | 21967 | 16981 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 837 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002980.1732 | 2109918.2793 | 37.7736018732822 | -122.433129076252 | (37.7736018732822, -122.433129076252) | |||
| 22154 | 22154 | 16983 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 847 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002927.3278 | 2109904.9371 | 37.773562241081706 | -122.43331092272899 | (37.7735622410817, -122.433310922729) | |||
| 20280 | 20280 | 16984 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 861 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002878.6682 | 2109904.9371 | 37.7735594804671 | -122.433479243381 | (37.7735594804671, -122.433479243381) | |||
| 17632 | 17632 | 16985 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 867 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002849.3678 | 2109899.7049 | 37.7735434517189 | -122.433580223732 | (37.7735434517189, -122.433580223732) | |||
| 20398 | 20398 | 16986 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 870 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002847.8984 | 2109953.1746 | 37.7736901829149 | -122.433589128645 | (37.7736901829149, -122.433589128645) | |||
| 17814 | 17814 | 16989 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 880 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002806.5013 | 2109946.7063 | 37.77367007365171 | -122.433731865097 | (37.7736700736517, -122.433731865097) | |||
| 21377 | 21377 | 16990 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 899 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002737.3984 | 2109886.1011 | 37.773499745425795 | -122.43396656947701 | (37.7734997454258, -122.433966569477) | |||
| 17157 | 17157 | 16991 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 899 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002773.5007 | 2109890.2869 | 37.7735132873347 | -122.433841985714 | (37.7735132873347, -122.433841985714) | |||
| 20899 | 20899 | 16992 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 1x1 | 6002640.9603 | 2109924.6842 | 37.773600211727 | -122.434302921546 | (37.773600211727, -122.434302921546) | |||
| 17284 | 17284 | 16993 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002625.7759 | 2109923.0859 | 37.7735949613156 | -122.434355332323 | (37.7735949613156, -122.434355332323) | |||
| 19445 | 19445 | 16994 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002602.5998 | 2109922.2867 | 37.7735914513761 | -122.434435444699 | (37.7735914513761, -122.434435444699) | |||
| 17192 | 17192 | 17024 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1101 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001643.357000001 | 2109735.2672 | 37.7730234456568 | -122.437740206634 | (37.7730234456568, -122.437740206634) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17214 | 17214 | 17082 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1565 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5999524.2661 | 2109435.6263 | 37.7720799869694 | -122.445048833846 | (37.7720799869694, -122.445048833846) | |||
| 17168 | 17168 | 17084 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1575 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999487.0395 | 2109431.3054 | 37.772065998090895 | -122.445177292475 | (37.7720659980909, -122.445177292475) | |||
| 20300 | 20300 | 17086 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1611 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5999247.78 | 2109394.7924 | 37.771952083100295 | -122.446002280338 | (37.7719520831003, -122.446002280338) | |||
| 19249 | 19249 | 17087 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1621 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5999187.9651 | 2109387.1019 | 37.7719275511448 | -122.446208630434 | (37.7719275511448, -122.446208630434) | |||
| 17403 | 17403 | 17098 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1705 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5998777.5925 | 2109332.4141 | 37.7717539478166 | -122.447624196011 | (37.7717539478166, -122.447624196011) | |||
| 21546 | 21546 | 17107 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1781 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998487.0633 | 2109292.2527 | 37.7716270666505 | -122.44862625802799 | (37.7716270666505, -122.448626258028) | |||
| 17595 | 17595 | 17108 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1789 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998462.7101 | 2109289.6892 | 37.7716186353865 | -122.448710312151 | (37.7716186353865, -122.448710312151) | |||
| 17820 | 17820 | 17112 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1855 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998114.9295 | 2109242.2645 | 37.7714685261947 | -122.449909881636 | (37.7714685261947, -122.449909881636) | |||
| 18214 | 18214 | 17113 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1875 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5998056.3964 | 2109231.5833 | 37.7714358490518 | -122.45011157971099 | (37.7714358490518, -122.450111579711) | |||
| 17479 | 17479 | 17114 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1889X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998005.981000001 | 2109225.1746 | 37.7714153673222 | -122.45028550625 | (37.7714153673222, -122.45028550625) | |||
| 19853 | 19853 | 17115 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1899 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997963.2561 | 2109219.1931 | 37.7713964984716 | -122.450432861809 | (37.7713964984716, -122.450432861809) | |||
| 21997 | 21997 | 17116 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1899 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997981.6278 | 2109222.6111 | 37.771406934874896 | -122.450369559944 | (37.7714069348749, -122.450369559944) | |||
| 18594 | 18594 | 17117 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1907 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5997844.0536 | 2109200.8214 | 37.771339231452 | -122.45084386213101 | (37.771339231452, -122.450843862131) | |||
| 19773 | 19773 | 17120 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1931 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997753.4769 | 2109191.4219 | 37.7713082373467 | -122.45115649157499 | (37.7713082373467, -122.451156491575) | |||
| 17174 | 17174 | 17123 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1949 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997679.9901 | 2109179.4590000003 | 37.7712711825876 | -122.451409821439 | (37.7712711825876, -122.451409821439) | |||
| 21861 | 21861 | 17124 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1959 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997650.0826 | 2109175.1865 | 37.7712577387998 | -122.451512964016 | (37.7712577387998, -122.451512964016) | |||
| 17644 | 17644 | 17126 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1971 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997587.7043 | 2109167.9232 | 37.7712342233691 | -122.45172820804599 | (37.7712342233691, -122.451728208046) | |||
| 18803 | 18803 | 17128 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1999 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2003 12:00:00 AM | 12 | 3X3 | 5997486.4463 | 2109152.9695 | 37.7711873646815 | -122.452077382727 | (37.7711873646815, -122.452077382727) | ||
| 18301 | 18301 | 17129 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1999 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5997503.109 | 2109154.2513 | 37.7711918386222 | -122.452019838592 | (37.7711918386222, -122.452019838592) | |||
| 21113 | 21113 | 17130 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2001 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5997372.7981 | 2109137.1613 | 37.7711374488605 | -122.45246935322399 | (37.7711374488605, -122.452469353224) | |||
| 19705 | 19705 | 17131 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2001 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5997393.7333 | 2109140.5793 | 37.771148033222794 | -122.452397184671 | (37.7711480332228, -122.452397184671) | |||
| 21783 | 21783 | 17132 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2017 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5997337.3364 | 2109131.1798 | 37.7711189934376 | -122.45259158414301 | (37.7711189934376, -122.452591584143) | |||
| 21485 | 21485 | 17133 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2021 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5997314.265 | 2109127.7618 | 37.7711082865548 | -122.452671141791 | (37.7711082865548, -122.452671141791) | |||
| 21345 | 21345 | 17138 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2049 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5997189.9355 | 2109110.6719 | 37.771054237387396 | -122.453099965702 | (37.7710542373874, -122.453099965702) | |||
| 18945 | 18945 | 17664 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 892X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002741.8184 | 2109937.0039 | 37.773639762745 | -122.433954919315 | (37.773639762745, -122.433954919315) | |||
| 8120 | 8120 | 17670 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1015X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/1995 12:00:00 AM | 12 | 3X3 | 6002378.1109 | 2112076.6861 | 37.7794941484605 | -122.435366123882 | (37.7794941484605, -122.435366123882) | ||
| 5252 | 5252 | 17675 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1010 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002421.1673 | 2112056.7065 | 37.779441734619205 | -122.435215744209 | (37.7794417346192, -122.435215744209) | |||
| 5884 | 5884 | 17676 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1004 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002427.6935 | 2112026.5749 | 37.779359371412795 | -122.43519101157301 | (37.7793593714128, -122.435191011573) | |||
| 6737 | 6737 | 17678 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1016 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002420.6118 | 2112080.0342 | 37.7795057550774 | -122.435219334932 | (37.7795057550774, -122.435219334932) | |||
| 5342 | 5342 | 17679 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1004 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002429.082 | 2112004.3581 | 37.7792984485069 | -122.435184618671 | (37.7792984485069, -122.435184618671) | |||
| 2890 | 2890 | 17680 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1020 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002416.7239 | 2112103.0842 | 37.7795688238035 | -122.43523443397801 | (37.7795688238035, -122.435234433978) | |||
| 8167 | 8167 | 17998 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2655 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001236.5127 | 2114885.1235 | 37.7871405009053 | -122.43951676886299 | (37.7871405009053, -122.439516768863) | |||
| 6034 | 6034 | 17999 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2663 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001215.9923 | 2114878.7551 | 37.7871218470279 | -122.439587308087 | (37.7871218470279, -122.439587308087) | |||
| 3729 | 3729 | 18005 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2683 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001144.5248 | 2114870.2639 | 37.787094464568796 | -122.43983396035101 | (37.7870944645688, -122.439833960351) | |||
| 5822 | 5822 | 18009 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2704 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6000887.4934 | 2114883.9407 | 37.787117383440794 | -122.440724211427 | (37.7871173834408, -122.440724211427) | |||
| 6264 | 6264 | 18011 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2707 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000900.4249 | 2114838.7005 | 37.786993901953394 | -122.440676225149 | (37.7869939019534, -122.440676225149) | |||
| 6933 | 6933 | 18012 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2707 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000934.1764 | 2114843.3331 | 37.787008543855 | -122.44055978525299 | (37.787008543855, -122.440559785253) | |||
| 5946 | 5946 | 18013 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2707 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000963.2953 | 2114846.642 | 37.7870192873225 | -122.440459278057 | (37.7870192873225, -122.440459278057) | |||
| 10070 | 10070 | 18018 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2718 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000772.0 | 2114884.0 | 37.7871109684575 | -122.44112379643299 | (37.7871109684575, -122.441123796433) | |||
| 6938 | 6938 | 18020 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2723 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000792.5524 | 2114820.8321 | 37.786938696374 | -122.44104815631201 | (37.786938696374, -122.441048156312) | |||
| 296 | 296 | 18021 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2725 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000769.3896 | 2114817.5231 | 37.78692829139071 | -122.44112805661501 | (37.7869282913907, -122.441128056615) | |||
| 8032 | 8032 | 18023 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2729 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000744.2415 | 2114813.5523 | 37.786915956134294 | -122.44121477806101 | (37.7869159561343, -122.441214778061) | |||
| 7121 | 7121 | 18036 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2807 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000406.6253 | 2114762.207 | 37.7867557380075 | -122.44237916186701 | (37.7867557380075, -122.442379161867) | |||
| 9434 | 9434 | 18037 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2807 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/1993 12:00:00 AM | 6 | 3X3 | 6000386.5591 | 2114760.4621 | 37.7867498032378 | -122.442448460651 | (37.7867498032378, -122.442448460651) | ||
| 8872 | 8872 | 18050 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2832 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000363.8297 | 2114817.6224 | 37.7869054550264 | -122.442531204238 | (37.7869054550264, -122.442531204238) | |||
| 7089 | 7089 | 18081 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2967 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999746.4018 | 2114674.089 | 37.7864761362834 | -122.444657035366 | (37.7864761362834, -122.444657035366) | |||
| 7109 | 7109 | 18519 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1700X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6009627.5943 | 2119520.0726 | 37.800340927010296 | -122.410812809398 | (37.8003409270103, -122.410812809398) | |||
| 21210 | 21210 | 19218 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1103X Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002097.9849 | 2110143.8576 | 37.7741711731344 | -122.43619684024799 | (37.7741711731344, -122.436196840248) | |||
| 20516 | 20516 | 19219 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1101X Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002112.0403 | 2110145.6145 | 37.774176795696995 | -122.436148345951 | (37.774176795697, -122.436148345951) | |||
| 17505 | 17505 | 20093 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2079X Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997064.7516 | 2109095.7182 | 37.7710060031357 | -122.453531898634 | (37.7710060031357, -122.453531898634) | |||
| 21742 | 21742 | 20094 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2075X Oak St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997081.4143 | 2109098.2817 | 37.7710139970036 | -122.453474447283 | (37.7710139970036, -122.453474447283) | |||
| 20192 | 20192 | 20112 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 809X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003121.4431 | 2109939.2081 | 37.7736673511786 | -122.43264189798799 | (37.7736673511786, -122.432641897988) |
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");