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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8913 | 8913 | 13286 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2599 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/1993 12:00:00 AM | 12 | 3X3 | 6000047.9587 | 2119131.9019 | 37.7987333214715 | -122.443934134594 | (37.7987333214715, -122.443934134594) | ||
| 8915 | 8915 | 10629 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 817 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003911.8012 | 2110745.3047 | 37.775925484701794 | -122.429965440473 | (37.7759254847018, -122.429965440473) | ||
| 8963 | 8963 | 12998 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 348 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6010660.6396 | 2120687.9769 | 37.803605574331705 | -122.407320424126 | (37.8036055743317, -122.407320424126) | |||
| 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) | |||
| 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) | ||
| 9530 | 9530 | 12248 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 511 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004985.727999999 | 2110723.6115 | 37.775926681152896 | -122.42624890215599 | (37.7759266811529, -122.426248902156) | |||
| 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) | |||
| 15556 | 15556 | 7384 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1026 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6010763.6701 | 2111388.108 | 37.7780761292824 | -122.406308232523 | (37.7780761292824, -122.406308232523) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17142 | 17142 | 545 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2878 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009558.0762 | 2102211.8871 | 37.7528128183786 | -122.40983092966101 | (37.7528128183786, -122.409830929661) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17198 | 17198 | 538 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2860 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009651.0028 | 2102218.3979 | 37.7528359029411 | -122.409510030546 | (37.7528359029411, -122.409510030546) | |||
| 17292 | 17292 | 540 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6009646.1294 | 2102175.7647 | 37.75271856860871 | -122.409523875049 | (37.7527185686087, -122.409523875049) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17565 | 17565 | 542 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2870 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009603.0598 | 2102213.6628 | 37.7528202149244 | -122.40967549279199 | (37.7528202149244, -122.409675492792) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17676 | 17676 | 25267 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1738 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5994656.4814 | 2092369.8948 | 37.7249427634406 | -122.46064985933901 | (37.7249427634406, -122.460649859339) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 18114 | 18114 | 27413 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1125 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002017.7522 | 2110131.5591 | 37.774132845741704 | -122.436473498525 | (37.7741328457417, -122.436473498525) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 18580 | 18580 | 497 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6010516.451 | 2102220.2128 | 37.75288934158429 | -122.40651726425399 | (37.7528893415843, -122.406517264254) | |||
| 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) | |||
| 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) | ||
| 18821 | 18821 | 25266 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1738 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 5994668.335 | 2092363.0322 | 37.7249246023662 | -122.460608386003 | (37.7249246023662, -122.460608386003) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 18957 | 18957 | 15300 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006966.3695 | 2109250.29 | 37.7719930461457 | -122.41929279621 | (37.7719930461457, -122.41929279621) | |||
| 19043 | 19043 | 533 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2850 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009680.0053 | 2102218.3979 | 37.7528375279845 | -122.409409734124 | (37.7528375279845, -122.409409734124) | |||
| 19201 | 19201 | 15302 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006948.3596 | 2109215.1279 | 37.7718954850631 | -122.419352599105 | (37.7718954850631, -122.419352599105) | |||
| 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) | |||
| 19393 | 19393 | 527 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2836 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009841.2951 | 2102226.6843 | 37.7528693162895 | -122.408852546362 | (37.7528693162895, -122.408852546362) | |||
| 19398 | 19398 | 547 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2889 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009603.6887 | 2102171.1765 | 37.7527035922626 | -122.409670319384 | (37.7527035922626, -122.409670319384) | |||
| 19595 | 19595 | 7021 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1105 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002080.4157 | 2110140.9294 | 37.7741621348105 | -122.43625740553301 | (37.7741621348105, -122.436257405533) | |||
| 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) | |||
| 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) | |||
| 19885 | 19885 | 549 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2899 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009532.5718 | 2102167.7354 | 37.7526901583127 | -122.40991601243401 | (37.7526901583127, -122.409916012434) | |||
| 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) | |||
| 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) | |||
| 20249 | 20249 | 25265 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1738 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5994685.8034 | 2092359.9129 | 37.7249170424989 | -122.46054777423099 | (37.7249170424989, -122.460547774231) | |||
| 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) | |||
| 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) | |||
| 20349 | 20349 | 10509 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1792 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5997587.0634 | 2108527.2635 | 37.7694750996845 | -122.45168420313499 | (37.7694750996845, -122.451684203135) | |||
| 20426 | 20426 | 496 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6010495.2306 | 2102220.2128 | 37.7528881543902 | -122.406590648723 | (37.7528881543902, -122.406590648723) | |||
| 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) | |||
| 20511 | 20511 | 10259 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 180 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005281.5755 | 2109598.2125 | 37.772853326524896 | -122.425145392536 | (37.7728533265249, -122.425145392536) | |||
| 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) | |||
| 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) | |||
| 21019 | 21019 | 15299 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006975.8032 | 2109269.1574 | 37.7720453828325 | -122.41926150288602 | (37.7720453828325, -122.419261502886) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 21140 | 21140 | 28785 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 800 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002281.4779 | 2109178.7673 | 37.7715316982304 | -122.435493052551 | (37.7715316982304, -122.435493052551) | |||
| 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) | |||
| 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) | |||
| 21361 | 21361 | 7023 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1115 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002035.3214 | 2110135.6586 | 37.7741451002744 | -122.43641301713801 | (37.7741451002744, -122.436413017138) | |||
| 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) | |||
| 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) | |||
| 21535 | 21535 | 15301 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006957.7934 | 2109234.853 | 37.7719501768124 | -122.41932136637399 | (37.7719501768124, -122.419321366374) | |||
| 21538 | 21538 | 10477 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1649 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5998216.9877 | 2108565.5899 | 37.7696163897252 | -122.449508092743 | (37.7696163897252, -122.449508092743) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 21819 | 21819 | 544 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2872 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009585.3031 | 2102212.4790000003 | 37.752815969417206 | -122.409736815429 | (37.7528159694172, -122.409736815429) | |||
| 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) | |||
| 21929 | 21929 | 1652 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1701X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998816.4722 | 2109337.1138 | 37.7717690739196 | -122.44749004749399 | (37.7717690739196, -122.447490047494) | |||
| 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) | |||
| 21990 | 21990 | 528 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2836 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009819.9871 | 2102225.5005 | 37.7528648722833 | -122.408926150195 | (37.7528648722833, -122.408926150195) | |||
| 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) | |||
| 22044 | 22044 | 15319 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1680 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006779.4102 | 2108712.5677 | 37.77050605746361 | -122.41990134010099 | (37.7705060574636, -122.419901340101) | |||
| 22051 | 22051 | 28786 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 800 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002265.8749 | 2109178.7673 | 37.7715308120493 | -122.43554702410299 | (37.7715308120493, -122.435547024103) | |||
| 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) | |||
| 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) | |||
| 22132 | 22132 | 28299 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 100 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 5995861.9776 | 2088092.909 | 37.713268452474104 | -122.45617353106701 | (37.7132684524741, -122.456173531067) | |||
| 22134 | 22134 | 532 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2850 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009709.5998 | 2102220.1735 | 37.7528440615121 | -122.409307515735 | (37.7528440615121, -122.409307515735) | |||
| 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) | |||
| 22172 | 22172 | 489 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2730 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6010359.8791 | 2102254.6242 | 37.7529750670361 | -122.40706114707301 | (37.7529750670361, -122.407061147073) | |||
| 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) | |||
| 23190 | 23190 | 13311 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2973X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 5999715.5386 | 2114669.4924 | 37.7864617540071 | -122.44476348344801 | (37.7864617540071, -122.444763483448) | |||
| 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) |
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");