Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 58026 | 58026 | 199854 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2505 Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6014200.0457 | 2092143.0549 | 37.7254249428706 | -122.393073571548 | (37.7254249428706, -122.393073571548) | |||
| 185441 | 185441 | 38610 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015263.8639 | 2094301.7253 | 37.7314112587254 | -122.38954670833701 | (37.7314112587254, -122.389546708337) | |
| 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) | |||
| 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) | |||
| 164818 | 164818 | 87369 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 926 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50349 | 5990243.3148 | 2099080.9621 | 37.7431147521003 | -122.476395524083 | (37.7431147521003, -122.476395524083) | |
| 20229 | 20229 | 493 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6010421.2461 | 2102217.9187 | 37.752877715813796 | -122.406846340514 | (37.7528777158138, -122.406846340514) | |||
| 130725 | 130725 | 245471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2700 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6010463.1133 | 2102261.5065 | 37.7529997408326 | -122.406704626743 | (37.7529997408326, -122.406704626743) | |||
| 165135 | 165135 | 101264 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2000 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Permit Number 20727 | 5989453.6006 | 2106533.1127 | 37.7635305455459 | -122.479671267422 | (37.7635305455459, -122.479671267422) | |||
| 163380 | 163380 | 245439 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2940 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6007210.058999999 | 2106771.9452 | 37.7652018171161 | -122.418274106734 | (37.7652018171161, -122.418274106734) | |||
| 47183 | 47183 | 98470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011914.0134 | 2107036.3406 | 37.7661914486194 | -122.402022750022 | (37.7661914486194, -122.402022750022) | |||
| 64636 | 64636 | 246098 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997112.7214 | 2108174.1833 | 37.7684784553517 | -122.45329942957198 | (37.7684784553517, -122.453299429572) | |||
| 147110 | 147110 | 248373 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1609 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997837.6943 | 2108167.0669 | 37.768500442306106 | -122.45079131066002 | (37.7685004423061, -122.45079131066) | |||
| 27737 | 27737 | 248360 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1485 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998667.1431 | 2108281.3848 | 37.768861776014795 | -122.447930562543 | (37.7688617760148, -122.447930562543) | |||
| 4278 | 4278 | 246148 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998461.6736 | 2108298.4947 | 37.768897008730896 | -122.44864249661501 | (37.7688970087309, -122.448642496615) | |||
| 22359 | 22359 | 246131 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1486 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998602.7919 | 2108317.2701 | 37.768956629428395 | -122.448155732181 | (37.7689566294284, -122.448155732181) | |||
| 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) | |||
| 135750 | 135750 | 247391 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 215 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002287.9227 | 2109197.4231 | 37.7715832884679 | -122.435472094457 | (37.7715832884679, -122.435472094457) | |||
| 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) | |||
| 153723 | 153723 | 245132 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1585 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999461.1138 | 2109428.3140000002 | 37.7720563046211 | -122.44526675609801 | (37.7720563046211, -122.445266756098) | |||
| 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) | |||
| 28034 | 28034 | 140161 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 251 ASHBURY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998791.141 | 2109784.5074 | 37.7729960548875 | -122.44760988046998 | (37.7729960548875, -122.44760988047) | |||
| 2908 | 2908 | 140145 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2077 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997912.6072 | 2109907.6306 | 37.7732838718856 | -122.45065770078699 | (37.7732838718856, -122.450657700787) | |||
| 131662 | 131662 | 247451 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 915 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002618.2019 | 2109871.0089 | 37.773451540866496 | -122.434377807884 | (37.7734515408665, -122.434377807884) | |||
| 184088 | 184088 | 247447 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 899 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002801.7546 | 2109893.9494 | 37.7735249469174 | -122.43374451324301 | (37.7735249469174, -122.433744513243) | |||
| 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) | |||
| 148433 | 148433 | 244501 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 607 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004030.4942 | 2110064.8827 | 37.7740639341827 | -122.42950631481199 | (37.7740639341827, -122.429506314812) | |||
| 134866 | 134866 | 244278 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 589 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004214.5249 | 2110092.3934 | 37.774149889764 | -122.42887168253701 | (37.774149889764, -122.428871682537) | |||
| 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) | |||
| 22888 | 22888 | 245220 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 351 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6005075.2787 | 2110089.7787 | 37.774191391909596 | -122.425893994936 | (37.7741913919096, -122.425893994936) | |||
| 59283 | 59283 | 140706 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500 PIERCE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6002658.7155 | 2110338.0026 | 37.774736089286606 | -122.434271058386 | (37.7747360892866, -122.434271058386) | |||
| 37168 | 37168 | 140723 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 555 PIERCE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6002602.535 | 2110423.8561 | 37.7749686327575 | -122.434471537714 | (37.7749686327575, -122.434471537714) | |||
| 43832 | 43832 | 138987 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003459.8516 | 2110684.9037 | 37.7757340330654 | -122.43152453742701 | (37.7757340330654, -122.431524537427) | |||
| 171623 | 171623 | 141660 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 16 LOYOLA TER | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998448.6735 | 2110841.7689 | 37.775879445116104 | -122.448870682731 | (37.7758794451161, -122.448870682731) | |||
| 132858 | 132858 | 138866 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 STEINER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003084.5886 | 2110775.7422 | 37.7759621766443 | -122.43282915583401 | (37.7759621766443, -122.432829155834) | |||
| 7525 | 7525 | 7159 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 719 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003516.9027 | 2110817.5612 | 37.7761015111675 | -122.431336655161 | (37.7761015111675, -122.431336655161) | |||
| 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) | |||
| 37976 | 37976 | 140209 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 704 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003553.8988 | 2110879.8473 | 37.7762746300025 | -122.431213122749 | (37.7762746300025, -122.431213122749) | |||
| 68465 | 68465 | 108005 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 520 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6005304.2003 | 2110990.4457 | 37.7766773388863 | -122.425166213949 | (37.7766773388863, -122.425166213949) | |||
| 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) | |||
| 66174 | 66174 | 30889 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 412 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | 21 | 4x4 | Permit Number 34719 | 6005803.6075 | 2111060.8215 | 37.776898773465796 | -122.42344361968 | (37.7768987734658, -122.42344361968) | |
| 70659 | 70659 | 139446 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 508 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005466.7779 | 2111071.8783 | 37.7769101159246 | -122.424609603708 | (37.7769101159246, -122.424609603708) | |||
| 68579 | 68579 | 138831 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 745 BUCHANAN ST | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 6004451.1778 | 2111098.9724 | 37.7769271009021 | -122.428124806353 | (37.7769271009021, -122.428124806353) | |||
| 1336 | 1336 | 7171 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003475.9145 | 2111120.5411 | 37.7769310959731 | -122.431500078765 | (37.7769310959731, -122.431500078765) | ||
| 56825 | 56825 | 108010 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 419X Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6005279.8436 | 2111122.0196 | 37.777037232737705 | -122.42525983588001 | (37.7770372327377, -122.42525983588) | ||||
| 75416 | 75416 | 33693 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 401 Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37765 | 6005397.8063 | 2111143.0332 | 37.7771015944949 | -122.42485326118401 | (37.7771015944949, -122.424853261184) | ||
| 134331 | 134331 | 139436 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 410 Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6005361.8436 | 2111159.167 | 37.7771438626442 | -122.424978815742 | (37.7771438626442, -122.424978815742) | |||
| 54759 | 54759 | 139432 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 539 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005403.0601 | 2111196.299 | 37.77724814614 | -122.424838877048 | (37.77724814614, -122.424838877048) | |||
| 155936 | 155936 | 111731 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 313 Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 2.5x3 | 6005824.7151 | 2111202.6522 | 37.7772893974301 | -122.423380687053 | (37.7772893974301, -122.423380687053) | |||
| 31925 | 31925 | 139285 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 855 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003448.7737 | 2111306.0955 | 37.7774390440386 | -122.431607217597 | (37.7774390440386, -122.431607217597) | |||
| 50778 | 50778 | 140610 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 860 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003498.0852 | 2111306.0629 | 37.7774417494141 | -122.431436630621 | (37.7774417494141, -122.431436630621) | |||
| 73309 | 73309 | 110467 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | 6005585.7014 | 2111327.1742 | 37.7776178118347 | -122.424216371681 | (37.7776178118347, -122.424216371681) | ||
| 181301 | 181301 | 140064 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 903 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002956.7221 | 2111383.6945 | 37.777624209443395 | -122.433314931056 | (37.7776242094434, -122.433314931056) | |||
| 593 | 593 | 140072 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005402.0 | 2111410.0 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | |||
| 149432 | 149432 | 140067 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 616 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005420.4192 | 2111411.6517 | 37.7778404325738 | -122.424794150591 | (37.7778404325738, -122.424794150591) | |||
| 14749 | 14749 | 7388 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6010798.3361 | 2111334.861 | 37.7779318645299 | -122.406184557349 | (37.7779318645299, -122.406184557349) | |||
| 46666 | 46666 | 140592 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 950 STEINER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002968.2418 | 2111603.9288 | 37.778229571438295 | -122.433290821469 | (37.7782295714383, -122.433290821469) | |||
| 168944 | 168944 | 140051 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 501 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005299.4561 | 2111632.5014 | 37.7784399990073 | -122.42522832358 | (37.7784399990073, -122.42522832358) | |||
| 182520 | 182520 | 141684 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2350 TURK BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998631.8104 | 2111816.1017 | 37.7785651829019 | -122.448307345965 | (37.7785651829019, -122.448307345965) | |||
| 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) | |||
| 59370 | 59370 | 141680 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2340 TURK BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998758.0111 | 2111834.2387 | 37.7786221965848 | -122.447872077437 | (37.7786221965848, -122.447872077437) | |||
| 183645 | 183645 | 140505 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1020 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003444.6141 | 2111801.8852 | 37.7788001236235 | -122.43165701281 | (37.7788001236235, -122.43165701281) | |||
| 184755 | 184755 | 140540 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003378.1969 | 2111847.7586 | 37.7789223156672 | -122.43189005228001 | (37.7789223156672, -122.43189005228) | |||
| 163747 | 163747 | 140534 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1099 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003360.1767 | 2111967.4014 | 37.7792498034321 | -122.431960936856 | (37.7792498034321, -122.431960936856) | |||
| 174213 | 174213 | 137519 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 11 Seymour St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001649.8446 | 2112101.8284 | 37.7795217969961 | -122.437887303264 | (37.7795217969961, -122.437887303264) | |||
| 24888 | 24888 | 45611 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1100 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2001 12:00:00 AM | 16 | Permit Number 44335 | 6003449.1823 | 2112117.4289 | 37.7796667869975 | -122.43166374401001 | (37.7796667869975, -122.43166374401) | ||
| 73100 | 73100 | 141695 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 392 EWING TER | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998748.3741 | 2112341.6402 | 37.78001483889879 | -122.44794195643499 | (37.7800148388988, -122.447941956435) | |||
| 27146 | 27146 | 140419 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 STEINER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6002875.6498 | 2112268.3783 | 37.780048730384 | -122.43365863076201 | (37.780048730384, -122.433658630762) | |||
| 30246 | 30246 | 140690 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003362.1468 | 2112293.1578 | 37.7801443609542 | -122.431977389111 | (37.7801443609542, -122.431977389111) | |||
| 3334 | 3334 | 140424 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 13 | Width 0ft | 6002981.8736 | 2112352.3525 | 37.7802853291655 | -122.43329715719 | (37.7802853291655, -122.43329715719) | |||
| 63167 | 63167 | 142150 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 20 Stanyan Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5996389.5624 | 2112799.0591 | 37.7811356783284 | -122.456135178495 | (37.7811356783284, -122.456135178495) | |||
| 34800 | 34800 | 140777 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 77 TERRA VISTA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000158.3968 | 2112814.4573 | 37.7813935692054 | -122.44309803536699 | (37.7813935692054, -122.443098035367) | |||
| 158904 | 158904 | 141084 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 3360 GEARY BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5996679.0822 | 2112965.7318 | 37.7816099317752 | -122.45514563789 | (37.7816099317752, -122.45514563789) | |||
| 33367 | 33367 | 141080 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 192 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996588.0468 | 2113019.8793 | 37.7817533832417 | -122.45546448989799 | (37.7817533832417, -122.455464489898) | |||
| 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) | |||
| 135066 | 135066 | 141781 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1480 ELLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003816.5092 | 2113214.7018 | 37.7827004390473 | -122.43047131515301 | (37.7827004390473, -122.430471315153) | |||
| 166722 | 166722 | 141778 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 9 Hollis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003916.891 | 2113262.7794 | 37.7828381339765 | -122.430127467778 | (37.7828381339765, -122.430127467778) | |||
| 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) | ||
| 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) | ||
| 162784 | 162784 | 141765 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1529 O'Farrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003847.9445 | 2113512.4132 | 37.7835196607686 | -122.43038381035 | (37.7835196607686, -122.43038381035) | |||
| 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) | ||||
| 177611 | 177611 | 110909 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6013356.5185 | 2113781.277 | 37.7847919207208 | -122.397506459776 | (37.7847919207208, -122.397506459776) | ||||
| 176185 | 176185 | 201184 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 620 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6013400.7332 | 2113908.7797 | 37.78514447543571 | -122.397362434941 | (37.7851444754357, -122.397362434941) | |||
| 58484 | 58484 | 138743 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2965 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999307.6319 | 2114263.2516 | 37.7853230365302 | -122.446145501349 | (37.7853230365302, -122.446145501349) | |||
| 76808 | 76808 | 138539 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1700 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003089.8085 | 2114203.6138 | 37.785374549591204 | -122.433056065597 | (37.7853745495912, -122.433056065597) | |||
| 151721 | 151721 | 139365 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1590 LYON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999665.9385 | 2114296.9513 | 37.7854360225018 | -122.44490829680599 | (37.7854360225018, -122.444908296806) | |||
| 64988 | 64988 | 138503 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1799 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002537.1515 | 2114272.2749 | 37.7855317115931 | -122.43497300238899 | (37.7855317115931, -122.434973002389) | |||
| 5781 | 5781 | 7252 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1701 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003031.0875 | 2114271.6252 | 37.78555796067371 | -122.433264083866 | (37.7855579606737, -122.433264083866) | |||
| 150460 | 150460 | 106407 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 650 Presidio Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5x6 | 5999244.445 | 2114365.5896 | 37.7856004213418 | -122.44637147273599 | (37.7856004213418, -122.446371472736) | |||
| 73003 | 73003 | 117049 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2183 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6002213.4716 | 2114319.9367 | 37.7856441950939 | -122.436096250016 | (37.7856441950939, -122.436096250016) | |||
| 163469 | 163469 | 138718 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1605 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999603.495 | 2114383.6783 | 37.7856705883683 | -122.445130569247 | (37.7856705883683, -122.445130569247) | |||
| 131793 | 131793 | 138473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1749 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003016.4418 | 2114370.4842 | 37.7858285716099 | -122.433321820329 | (37.7858285716099, -122.433321820329) | |||
| 59660 | 59660 | 117031 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2100 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6002487.092999999 | 2114413.0027 | 37.78591527192879 | -122.435156258966 | (37.7859152719288, -122.435156258966) | |||
| 8428 | 8428 | 21739 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2045 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002859.7063 | 2114412.7642 | 37.785935768772 | -122.433867103908 | (37.785935768772, -122.433867103908) | |||
| 24601 | 24601 | 138420 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1819 STEINER ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 0ft | 6002521.5979 | 2114452.899 | 37.786026776312596 | -122.435039736101 | (37.7860267763126, -122.435039736101) | |||
| 221 | 221 | 138361 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002830.8674 | 2114461.7028 | 37.78606850519029 | -122.433970377911 | (37.7860685051903, -122.433970377911) | |||
| 162133 | 162133 | 138374 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1801 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002553.8497 | 2114553.8768 | 37.786305866911796 | -122.43493537792601 | (37.7863058669118, -122.434935377926) | |||
| 5722 | 5722 | 21711 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1900 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6x6 | 6003392.8992 | 2114541.4083 | 37.7863192355998 | -122.43203159373999 | (37.7863192355998, -122.43203159374) | |||
| 131804 | 131804 | 138123 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1850 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003035.9259 | 2114580.1998 | 37.786405502849604 | -122.433269401448 | (37.7864055028496, -122.433269401448) | |||
| 188446 | 188446 | 138009 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1803 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003935.4192 | 2114568.0116 | 37.7864230237501 | -122.430156512807 | (37.7864230237501, -122.430156512807) |
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");