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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2772 | 2772 | 252949 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
| 2810 | 2810 | 23452 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2209 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005880.951090001 | 2118079.82441 | 37.796175582497504 | -122.423675237326 | (37.7961755824975, -122.423675237326) | |||
| 2877 | 2877 | 2888 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1541 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6007004.32462 | 2116031.27674 | 37.7906141281881 | -122.41964270965201 | (37.7906141281881, -122.419642709652) | |||
| 2892 | 2892 | 99717 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001694.9164 | 2113468.8804 | 37.7832779377979 | -122.437829320807 | (37.7832779377979, -122.437829320807) | |||
| 2941 | 2941 | 246063 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 657 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | Permit Number 41993 | 5998975.8774 | 2108455.663 | 37.769357942133205 | -122.446875218626 | (37.7693579421332, -122.446875218626) | ||
| 2942 | 2942 | 95170 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1306 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2015 12:00:00 AM | 3 | 3x3 | 6001329.6747 | 2112935.9507 | 37.781793873207 | -122.439054702012 | (37.781793873207, -122.439054702012) | ||
| 3160 | 3160 | 109437 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 940 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x6 | 6003136.3777 | 2111029.1486 | 37.7766609049 | -122.432668109569 | (37.7766609049, -122.432668109569) | |||
| 3168 | 3168 | 33093 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 3185 | 3185 | 3123 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3195 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X2 | 5999194.2227 | 2114949.0037 | 37.787199455340705 | -122.44658721654801 | (37.7871994553407, -122.446587216548) | |||
| 3277 | 3277 | 3186 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3633 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5997046.4391 | 2114650.2263 | 37.7862561763922 | -122.45399645741999 | (37.7862561763922, -122.45399645742) | |||
| 3301 | 3301 | 3014 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2450 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3X3 | 6002569.4448 | 2115483.65814 | 37.7888596947603 | -122.43494794241501 | (37.7888596947603, -122.434947942415) | |||
| 3391 | 3391 | 2983 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2226 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6003696.67837 | 2115640.99047 | 37.7893556277051 | -122.431059105706 | (37.7893556277051, -122.431059105706) | |||
| 3415 | 3415 | 58712 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 688 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1979 12:00:00 AM | 12 | 3x3 | Permit Number 17946 | 6004581.34636 | 2110890.2862299997 | 37.776361463754604 | -122.427659641397 | (37.7763614637546, -122.427659641397) | |
| 3442 | 3442 | 2868 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1389 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007715.890269999 | 2116130.82655 | 37.790927523941704 | -122.417187783496 | (37.7909275239417, -122.417187783496) | |||
| 3452 | 3452 | 2818 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6008957.0218 | 2116372.57941 | 37.79166106316271 | -122.412910605154 | (37.7916610631627, -122.412910605154) | |||
| 3454 | 3454 | 23347 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1245 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 0 | 6006327.19373 | 2114871.36437 | 37.7873911306548 | -122.421903118752 | (37.7873911306548, -122.421903118752) | |||
| 3457 | 3457 | 108164 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770697 | 6005639.99861 | 2119248.14004 | 37.7993698763863 | -122.42459213123301 | (37.7993698763863, -122.424592131233) | |
| 3460 | 3460 | 249511 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1243 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006333.62129 | 2114827.84877 | 37.7872720100542 | -122.421877788428 | (37.7872720100542, -122.421877788428) | |||
| 3631 | 3631 | 133550 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3498 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 772596 | 5998146.13345 | 2115528.5550599997 | 37.7887308273139 | -122.450255153677 | (37.7887308273139, -122.450255153677) | |
| 3632 | 3632 | 122539 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3443 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 779060 | 5998247.97366 | 2115501.74936 | 37.788663053514 | -122.44990087023001 | (37.788663053514, -122.44990087023) | ||
| 3633 | 3633 | 133551 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3498 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 772596 | 5998134.73529 | 2115528.0239 | 37.788728716592104 | -122.45029455117701 | (37.7887287165921, -122.450294551177) | |
| 3638 | 3638 | 2840 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1255 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008320.47773 | 2116218.27733 | 37.7912016363983 | -122.41510212258301 | (37.7912016363983, -122.415102122583) | |||
| 3673 | 3673 | 3073 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2880 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/1998 12:00:00 AM | 3 | 3X3 | 6000583.9217 | 2115208.18648 | 37.7879903857924 | -122.44179777983999 | (37.7879903857924, -122.44179777984) | ||
| 3722 | 3722 | 2900 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1675 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6006330.22809 | 2115940.35545 | 37.7903264863286 | -122.4219685876 | (37.7903264863286, -122.4219685876) | |||
| 3836 | 3836 | 3098 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3014 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5999901.41366 | 2115112.8463 | 37.7876896938595 | -122.444152274206 | (37.7876896938595, -122.444152274206) | |||
| 3891 | 3891 | 2801 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6009324.7749 | 2116423.80567 | 37.791822353872796 | -122.411641798449 | (37.7918223538728, -122.411641798449) | |||
| 4009 | 4009 | 34002 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 4013 | 4013 | 253610 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1075 Mission St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 6009725.02676 | 2112060.52163 | 37.7798642637711 | -122.40994876804 | (37.7798642637711, -122.40994876804) | ||||
| 4171 | 4171 | 39901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 4313 | 4313 | 2803 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1055 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6009318.69522 | 2116357.3469700003 | 37.791639533399795 | -122.41165813642999 | (37.7916395333998, -122.41165813643) | |||
| 4339 | 4339 | 3082 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2913 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6000319.2838 | 2115099.7465 | 37.7876775552832 | -122.442705587482 | (37.7876775552832, -122.442705587482) | |||
| 4361 | 4361 | 2887 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1530 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 6007023.220480001 | 2116101.4928900003 | 37.7908079887437 | -122.41958231479401 | (37.7908079887437, -122.419582314794) | |||
| 4460 | 4460 | 55487 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 601 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | 20 | 6x9 | Permit Number 24565 | 6003098.1372 | 2110364.0779 | 37.774832616894706 | -122.43275287348601 | (37.7748326168947, -122.432752873486) |
| 4471 | 4471 | 100799 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2455 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002438.67863 | 2116735.02721 | 37.7922882071812 | -122.435489929626 | (37.7922882071812, -122.435489929626) | |||
| 4495 | 4495 | 2802 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1055 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6009267.5769 | 2116351.4322900004 | 37.7916204254988 | -122.411834587904 | (37.7916204254988, -122.411834587904) | |||
| 4567 | 4567 | 109546 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006868.4272 | 2111721.79621 | 37.778773692788 | -122.419806988803 | (37.778773692788, -122.419806988803) | |||
| 4621 | 4621 | 122573 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2014 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6003898.8446 | 2115409.2515 | 37.7887307847056 | -122.430343093484 | (37.7887307847056, -122.430343093484) | |||
| 4628 | 4628 | 3096 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3003 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999955.8775 | 2115049.7006 | 37.787519419160795 | -122.443959301682 | (37.7875194191608, -122.443959301682) | |||
| 4639 | 4639 | 102681 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001426.627069999 | 2115693.54787 | 37.7893710438761 | -122.43891697256399 | (37.7893710438761, -122.438916972564) | |||
| 4715 | 4715 | 103364 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 3 | 3x3 | 6009173.30525 | 2116699.27717 | 37.79257023366971 | -122.412185363057 | (37.7925702336697, -122.412185363057) | ||
| 4730 | 4730 | 234655 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 437 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6x12 | 6002991.56268 | 2105705.90685 | 37.762036373292 | -122.432788699846 | (37.762036373292, -122.432788699846) | |||
| 4737 | 4737 | 18665 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 68 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999650.82657 | 2119343.62461 | 37.799291994198796 | -122.445323565644 | (37.7992919941988, -122.445323565644) | |||
| 4784 | 4784 | 248429 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 735 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998546.7685 | 2108037.7588 | 37.7681859595657 | -122.448329381959 | (37.7681859595657, -122.448329381959) | |||
| 4818 | 4818 | 2858 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6007920.97179 | 2116228.0555 | 37.7912060259903 | -122.416485098214 | (37.7912060259903, -122.416485098214) | |||
| 4826 | 4826 | 248398 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 726 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5998582.351 | 2108084.2431 | 37.768315627898005 | -122.448209653817 | (37.768315627898, -122.448209653817) | |||
| 4842 | 4842 | 53619 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2635 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1969 12:00:00 AM | 14 | 6x9 | Permit Number 6550 | 6001139.602580001 | 2117434.01333 | 37.794133574667 | -122.44003489281 | (37.794133574667, -122.44003489281) | |
| 4897 | 4897 | 27584 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1785 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2000 12:00:00 AM | 3 | 3X3 | 6001489.4944 | 2112142.9438 | 37.77962556986321 | -122.43844496845199 | (37.7796255698632, -122.438444968452) | ||
| 4910 | 4910 | 24648 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1995 12:00:00 AM | 3 | 3X3 | 6001203.4433 | 2113355.9321 | 37.782939851650895 | -122.439521518598 | (37.7829398516509, -122.439521518598) | ||
| 5033 | 5033 | 69190 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2401 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1994 12:00:00 AM | 12 | 3x3 | Permit Number 33233 | 6002598.67193 | 2116757.13717 | 37.7923580008738 | -122.43493793203501 | (37.7923580008738, -122.434937932035) | |
| 5139 | 5139 | 235614 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 573 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006249.0 | 2106283.0 | 37.7638051443341 | -122.421563455709 | (37.7638051443341, -122.421563455709) | |||
| 5166 | 5166 | 235615 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 573 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006249.0 | 2106283.0 | 37.7638051443341 | -122.421563455709 | (37.7638051443341, -122.421563455709) | |||
| 5215 | 5215 | 3081 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2912 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000297.468780001 | 2115166.83236 | 37.787860511999995 | -122.442785882062 | (37.787860512, -122.442785882062) | |||
| 5243 | 5243 | 2979 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X2 | 6003796.8849 | 2115584.1912 | 37.7892053489441 | -122.430708347922 | (37.7892053489441, -122.430708347922) | |||
| 5274 | 5274 | 58105 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 920 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1977 12:00:00 AM | 5 | Permit Number 17081 | 6006591.68402 | 2113670.96002 | 37.7841100278879 | -122.42090277676701 | (37.7841100278879, -122.420902776767) | ||
| 5283 | 5283 | 2897 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1635 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6006502.249530001 | 2115965.50958 | 37.7904052534492 | -122.42137519153098 | (37.7904052534492, -122.421375191531) | |||
| 5301 | 5301 | 45635 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2002 12:00:00 AM | 7 | Permit Number 44342 | 6006530.053069999 | 2113426.6825900003 | 37.7834358277545 | -122.421098647281 | (37.7834358277545, -122.421098647281) | ||
| 5305 | 5305 | 3116 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3151 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999317.7381 | 2114962.1143 | 37.7872425080555 | -122.44616082493799 | (37.7872425080555, -122.446160824938) | |||
| 5319 | 5319 | 2956 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2022 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004492.42277 | 2115751.35307 | 37.7897037139057 | -122.428313790248 | (37.7897037139057, -122.428313790248) | |||
| 5330 | 5330 | 103513 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1859 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6004155.22179 | 2118342.1254 | 37.7967982290065 | -122.429665326519 | (37.7967982290065, -122.429665326519) | |||
| 5345 | 5345 | 2950 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2000 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6004708.4584 | 2115781.93381 | 37.7897999027004 | -122.427568507708 | (37.7897999027004, -122.427568507708) | |||
| 5346 | 5346 | 109550 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006859.56746 | 2111778.81942 | 37.778929765630295 | -122.41984168553999 | (37.7789297656303, -122.41984168554) | |||
| 5349 | 5349 | 2825 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6008708.35177 | 2116339.22144 | 37.791555508841206 | -122.413768643818 | (37.7915555088412, -122.413768643818) | |||
| 5354 | 5354 | 109556 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006837.67499 | 2111950.4922 | 37.7793999042174 | -122.41992960596501 | (37.7793999042174, -122.419929605965) | |||
| 5362 | 5362 | 3137 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3302 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 2X3 | 5998543.29371 | 2114921.59911 | 37.787087006913296 | -122.44883730591002 | (37.7870870069133, -122.44883730591) | |||
| 5376 | 5376 | 112253 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3401 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5998472.27762 | 2115859.72352 | 37.789658787381796 | -122.449150614422 | (37.7896587873818, -122.449150614422) | |||
| 5394 | 5394 | 2865 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1370 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6007816.79371 | 2116213.72438 | 37.7911608170581 | -122.41684453654699 | (37.7911608170581, -122.416844536547) | |||
| 5398 | 5398 | 98494 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2820 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5999556.928169999 | 2118555.98315 | 37.79712398054429 | -122.44559181541099 | (37.7971239805443, -122.445591815411) | |||
| 5414 | 5414 | 3114 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3150 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X2 | 5999305.56047 | 2115029.35273 | 37.7874264317373 | -122.446207795272 | (37.7874264317373, -122.446207795272) | |||
| 5426 | 5426 | 2882 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1499 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6007281.77747 | 2116069.5098599996 | 37.7907347317813 | -122.418685448789 | (37.7907347317813, -122.418685448789) | |||
| 5447 | 5447 | 3170 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3468X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5997817.62351 | 2114819.66546 | 37.786765599102395 | -122.45134059761001 | (37.7867655991024, -122.45134059761) | |||
| 5468 | 5468 | 3007 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2383 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 2X3 | 6003000.8179 | 2115475.95 | 37.788863013488296 | -122.433454901543 | (37.7888630134883, -122.433454901543) | |||
| 5470 | 5470 | 100796 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2477 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6002339.98716 | 2116721.3494700002 | 37.79224504601171 | -122.43583042464199 | (37.7922450460117, -122.435830424642) | |||
| 5488 | 5488 | 5869 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1010X Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005558.007 | 2113111.8938 | 37.7825166508653 | -122.424439152252 | (37.7825166508653, -122.424439152252) | |||
| 5489 | 5489 | 92814 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2801 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2009 12:00:00 AM | 6 | 3x3 | Permit Number 53021 | 6000681.38674 | 2116493.06256 | 37.791523874264705 | -122.44155280902201 | (37.7915238742647, -122.441552809022) | |
| 5505 | 5505 | 3198 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3700X California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5996450.47097 | 2114631.1669799997 | 37.786169655243704 | -122.45605696165501 | (37.7861696552437, -122.456056961655) | |||
| 5519 | 5519 | 2854 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1325 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6007999.55811 | 2116173.32334 | 37.7910601640548 | -122.41620931301 | (37.7910601640548, -122.41620931301) | |||
| 5537 | 5537 | 108160 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2559 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770697 | 6005726.72514 | 2119185.00062 | 37.7992014090788 | -122.42428753355301 | (37.7992014090788, -122.424287533553) | |
| 5599 | 5599 | 3028 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2545 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6002144.8336 | 2115361.2222 | 37.7884993990958 | -122.436408269694 | (37.7884993990958, -122.436408269694) | |||
| 5609 | 5609 | 105280 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3017 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6002863.14914 | 2118997.09169 | 37.7985233499191 | -122.43418303843399 | (37.7985233499191, -122.434183038434) | |||
| 5610 | 5610 | 109560 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006827.8052900005 | 2112008.26753 | 37.7795579852454 | -122.41996785053101 | (37.7795579852454, -122.419967850531) | |||
| 5640 | 5640 | 79352 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2909 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | 8 | 3x3 | 5999487.033 | 2114286.0485 | 37.785395874336 | -122.445526470028 | (37.785395874336, -122.445526470028) | |
| 5656 | 5656 | 95168 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1304 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001332.382 | 2112914.9685 | 37.7817364154726 | -122.43904383182199 | (37.7817364154726, -122.439043831822) | |||
| 5658 | 5658 | 13028 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 454 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6010168.2162 | 2120621.6241 | 37.8033958137672 | -122.40901980222401 | (37.8033958137672, -122.409019802224) | |||
| 5662 | 5662 | 2799 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6009392.24103 | 2116434.8412200003 | 37.7918564390776 | -122.411409144728 | (37.7918564390776, -122.411409144728) | |||
| 5711 | 5711 | 2967 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2119 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6004200.3541 | 2115640.9046 | 37.7893839195842 | -122.42931643968201 | (37.7893839195842, -122.429316439682) | |||
| 5720 | 5720 | 2839 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1245 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6008398.91585 | 2116229.07014 | 37.791235678433296 | -122.414831492307 | (37.7912356784333, -122.414831492307) | |||
| 5727 | 5727 | 3064 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2825 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6000790.4891 | 2115166.9367 | 37.787888892538206 | -122.44108013491501 | (37.7878888925382, -122.441080134915) | |||
| 5749 | 5749 | 3071 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2870 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1998 12:00:00 AM | 3 | 3X3 | 6000614.84019 | 2115212.41465 | 37.7880037569245 | -122.44169111125 | (37.7880037569245, -122.44169111125) | ||
| 5779 | 5779 | 24620 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1008 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001476.3994 | 2111883.9213 | 37.7789136147751 | -122.43847170626499 | (37.7789136147751, -122.438471706265) | |||
| 5817 | 5817 | 103362 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009111.87446 | 2116690.2667799997 | 37.7925420462198 | -122.41239727931601 | (37.7925420462198, -122.412397279316) | ||
| 5850 | 5850 | 26674 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1825 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003781.9718 | 2114546.3993 | 37.786354989662705 | -122.430685859171 | (37.7863549896627, -122.430685859171) | |||
| 5857 | 5857 | 99700 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1412 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6007375.87378 | 2117463.43004 | 37.794567388720296 | -122.41845876116301 | (37.7945673887203, -122.418458761163) | |||
| 5882 | 5882 | 109553 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006853.14044 | 2111821.07903 | 37.7790454382325 | -122.41986691873801 | (37.7790454382325, -122.419866918738) | |||
| 5892 | 5892 | 23502 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2550 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005823.04846 | 2119213.04912 | 37.7992838616217 | -122.423956217027 | (37.7992838616217, -122.423956217027) | |||
| 5912 | 5912 | 35691 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 5935 | 5935 | 18670 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99X Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 5999509.53732 | 2119357.2628900004 | 37.799321375051704 | -122.445813455145 | (37.7993213750517, -122.445813455145) | |||
| 5953 | 5953 | 18676 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 133 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 5999263.47679 | 2119581.27708 | 37.7999224054595 | -122.44668103382901 | (37.7999224054595, -122.446681033829) | |||
| 5955 | 5955 | 30167 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3110 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2007 12:00:00 AM | 3 | 3X3 | 5999426.69765 | 2115046.3511900003 | 37.7874800223365 | -122.445789909978 | (37.7874800223365, -122.445789909978) | ||
| 5956 | 5956 | 2708 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2140 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003264.856000001 | 2114868.535 | 37.7872101826993 | -122.43249796405 | (37.7872101826993, -122.43249796405) | |||
| 5983 | 5983 | 7747 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 400X Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006377.68827 | 2111578.0704799998 | 37.7783513990461 | -122.421494439834 | (37.7783513990461, -122.421494439834) |
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");