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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 199 | 199 | 138362 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 0ft | 6002806.585 | 2114457.2427 | 37.78605488083279 | -122.434054069465 | (37.7860548808328, -122.434054069465) | |||
| 1164 | 1164 | 246083 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999078.2336 | 2108382.6812 | 37.7691633995354 | -122.446515923307 | (37.7691633995354, -122.446515923307) | |||
| 1466 | 1466 | 247380 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1001 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002208.0 | 2109818.0 | 37.7732826991746 | -122.43579295981199 | (37.7732826991746, -122.435792959812) | |||
| 2910 | 2910 | 140146 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2077 HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997931.7703 | 2109910.6967 | 37.773293387477395 | -122.450591634422 | (37.7732933874774, -122.450591634422) | |||
| 3344 | 3344 | 140425 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 12 | Width 0ft | 6003006.2764 | 2112357.3766 | 37.780300508432795 | -122.43321309578998 | (37.7803005084328, -122.43321309579) | |||
| 3945 | 3945 | 6232 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1220 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6005007.0756 | 2113377.0261 | 37.7832135118405 | -122.42636402033199 | (37.7832135118405, -122.426364020332) | ||
| 4223 | 4223 | 246149 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998439.5671 | 2108294.2551 | 37.7688841037799 | -122.44871865576 | (37.7688841037799, -122.44871865576) | |||
| 6213 | 6213 | 99229 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008022.9494 | 2121084.5162 | 37.804546392141496 | -122.416476410342 | (37.8045463921415, -122.416476410342) | |||
| 6484 | 6484 | 21712 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1900 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6x8 | 6003372.5799 | 2114537.2521 | 37.786306671740704 | -122.432101596345 | (37.7863066717407, -122.432101596345) | |||
| 6968 | 6968 | 4661 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009739.5649 | 2119605.2627 | 37.8005811155969 | -122.41043136381901 | (37.8005811155969, -122.410431363819) | |||
| 7225 | 7225 | 21740 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2045 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002881.8287 | 2114415.6319 | 37.7859448981022 | -122.433790771597 | (37.7859448981022, -122.433790771597) | |||
| 8536 | 8536 | 21588 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005294.0011 | 2114805.6563 | 37.7871523906748 | -122.42547307647301 | (37.7871523906748, -122.425473076473) | |||
| 8679 | 8679 | 21671 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1776 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6004100.5679 | 2114639.3689 | 37.7866283052779 | -122.429590230958 | (37.7866283052779, -122.429590230958) | |||
| 14753 | 14753 | 7389 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6010809.9838 | 2111345.3995 | 37.7779614523005 | -122.406145006296 | (37.7779614523005, -122.406145006296) | |||
| 17307 | 17307 | 15307 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1650 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 3 | 4X4 | 6006881.466 | 2109048.7514 | 37.771434887034104 | -122.419572183108 | (37.7714348870341, -122.419572183108) | ||
| 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) | |||
| 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) | |||
| 18224 | 18224 | 494 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6010448.7752 | 2102218.4922 | 37.752880830855496 | -122.40675117970801 | (37.7528808308555, -122.406751179708) | |||
| 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) | |||
| 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) | |||
| 22298 | 22298 | 143213 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010427.9747 | 2121297.8273 | 37.8052670481181 | -122.40816861291 | (37.8052670481181, -122.40816861291) | |||
| 32530 | 32530 | 97312 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 926 Taraval St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1984 12:00:00 AM | 10 | 3x3 | 5990212.18 | 2099077.2394 | 37.7431027248159 | -122.476502906842 | (37.7431027248159, -122.476502906842) | ||
| 36039 | 36039 | 140707 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500 PIERCE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6002654.7462 | 2110357.8493 | 37.7747903581014 | -122.434286208176 | (37.7747903581014, -122.434286208176) | |||
| 45616 | 45616 | 247452 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 913 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002642.725 | 2109874.1732 | 37.773461621200795 | -122.434293205315 | (37.7734616212008, -122.434293205315) | |||
| 45631 | 45631 | 138474 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1749 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003020.1032 | 2114355.1062 | 37.7857865552298 | -122.433308053669 | (37.7857865552298, -122.433308053669) | |||
| 46126 | 46126 | 141766 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1529 O'Farrell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003866.9642 | 2113516.1114 | 37.783530892448 | -122.43031827350599 | (37.783530892448, -122.430318273506) | |||
| 47388 | 47388 | 199743 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2392 Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014556.9144 | 2092538.9669 | 37.7265318557922 | -122.391867570434 | (37.7265318557922, -122.391867570434) | |||
| 47412 | 47412 | 141681 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2340 TURK BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998731.3741 | 2111830.7737 | 37.77861116004 | -122.447963975147 | (37.77861116004, -122.447963975147) | |||
| 47603 | 47603 | 142594 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008329.6499 | 2120808.0026 | 37.8038043983711 | -122.41539545409401 | (37.8038043983711, -122.415395454094) | |||
| 48348 | 48348 | 140506 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1020 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003442.3352 | 2111811.0008 | 37.77882502362021 | -122.43166554740299 | (37.7788250236202, -122.431665547403) | |||
| 50702 | 50702 | 138124 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1850 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003031.7696 | 2114609.7551 | 37.7864864184254 | -122.433285893848 | (37.7864864184254, -122.433285893848) | |||
| 51707 | 51707 | 138041 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1 Wilmot St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003396.2249 | 2115029.767 | 37.7876603335628 | -122.43205497415701 | (37.7876603335628, -122.432054974157) | |||
| 52729 | 52729 | 117032 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2100 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6002478.4668 | 2114411.3853 | 37.7859103411195 | -122.435185987474 | (37.7859103411195, -122.435185987474) | |||
| 52857 | 52857 | 244541 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1520 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999127.722999999 | 2109084.8233 | 37.7710941303807 | -122.44639526179701 | (37.7710941303807, -122.446395261797) | |||
| 53527 | 53527 | 200684 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1618 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6015017.6376 | 2095531.4827 | 37.7347742678836 | -122.39048386170401 | (37.7347742678836, -122.390483861704) | |||
| 53658 | 53658 | 138867 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 STEINER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003082.3731 | 2110792.3591 | 37.7760076768733 | -122.43283800718399 | (37.7760076768733, -122.432838007184) | |||
| 59694 | 59694 | 141685 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2350 TURK BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998607.1225 | 2111811.7705 | 37.7785518790932 | -122.448392438493 | (37.7785518790932, -122.448392438493) | |||
| 60040 | 60040 | 111732 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 313 Ivy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2.5x3 | 6005836.5524 | 2111203.7796 | 37.777293161078795 | -122.423339818124 | (37.7772931610788, -122.423339818124) | |||
| 61609 | 61609 | 142961 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 188 Pfeiffer St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6009941.6774 | 2121096.8109999998 | 37.8046878662366 | -122.409837314827 | (37.8046878662366, -122.409837314827) | |||
| 62505 | 62505 | 140491 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1396 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6003381.0328 | 2112450.7507 | 37.7805781423675 | -122.431923310003 | (37.7805781423675, -122.431923310003) | |||
| 63385 | 63385 | 143364 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1892 UNION ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003944.3499 | 2118711.0149 | 37.7977991621229 | -122.43042132535801 | (37.7977991621229, -122.430421325358) | |||
| 64852 | 64852 | 103460 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 666 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 7x7 | 6005392.6099 | 2111621.0092 | 37.7784137063831 | -122.424905251399 | (37.7784137063831, -122.424905251399) | |||
| 68176 | 68176 | 110468 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | 6005616.1343 | 2111331.3718 | 37.7776310557335 | -122.42411139247 | (37.7776310557335, -122.42411139247) | ||
| 68785 | 68785 | 199855 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2507 Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6014175.0737 | 2092094.9381 | 37.7252914365514 | -122.393156532831 | (37.7252914365514, -122.393156532831) | |||
| 68791 | 68791 | 141793 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1280 WEBSTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003797.3488 | 2112989.7381 | 37.7820816595285 | -122.430521544957 | (37.7820816595285, -122.430521544957) | |||
| 70703 | 70703 | 141081 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 190 Commonwealth Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996587.7084 | 2113030.7088 | 37.78178309876421 | -122.45546644353901 | (37.7817830987642, -122.455466443539) | |||
| 71272 | 71272 | 199749 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1555 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014744.6664 | 2092522.7122 | 37.7264976449454 | -122.39121737809799 | (37.7264976449454, -122.391217378098) | |||
| 71810 | 71810 | 139433 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 539 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005406.0306 | 2111183.3028 | 37.777212629523795 | -122.424827676313 | (37.7772126295238, -122.424827676313) | |||
| 76841 | 76841 | 140576 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1219 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003302.4616 | 2111703.7722 | 37.7785226712194 | -122.432141765433 | (37.7785226712194, -122.432141765433) | |||
| 89483 | 89483 | 113468 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 06/21/2016 02:14:00 PM | 3 | 6x7 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||
| 129651 | 129651 | 111432 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500X Presidio Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5999166.6215 | 2114917.2623 | 37.7871107251509 | -122.446680425702 | (37.7871107251509, -122.446680425702) | |||
| 129813 | 129813 | 248337 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1539 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998178.2256 | 2108213.3997 | 37.7686471477417 | -122.449616786829 | (37.7686471477417, -122.449616786829) | |||
| 131255 | 131255 | 143188 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 184 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010371.7665 | 2121341.3009 | 37.8053832684295 | -122.40836619766 | (37.8053832684295, -122.40836619766) | |||
| 131547 | 131547 | 140420 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 STEINER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6002874.2144 | 2112292.0633 | 37.7801136820125 | -122.43366528968599 | (37.7801136820125, -122.433665289686) | |||
| 133283 | 133283 | 247448 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 899 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002819.5442 | 2109896.0423 | 37.7735317029302 | -122.433683126065 | (37.7735317029302, -122.433683126065) | |||
| 134568 | 134568 | 140535 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1099 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003363.1308 | 2111944.3591 | 37.7791867024877 | -122.4319490716 | (37.7791867024877, -122.4319490716) | |||
| 135654 | 135654 | 201185 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 620 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6013380.1682 | 2113890.2713 | 37.7850925106546 | -122.397432285471 | (37.7850925106546, -122.397432285471) | |||
| 136427 | 136427 | 140548 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1080 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002919.3909 | 2111977.3656 | 37.7792521641585 | -122.433486508226 | (37.7792521641585, -122.433486508226) | |||
| 137260 | 137260 | 143170 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 179 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009922.0853 | 2121576.7805 | 37.8060046449874 | -122.409939018662 | (37.8060046449874, -122.409939018662) | |||
| 148925 | 148925 | 140691 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003358.8311 | 2112311.3938 | 37.780194244485294 | -122.43199016217899 | (37.7801942444853, -122.431990162179) | |||
| 149439 | 149439 | 140593 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 950 STEINER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6002965.1287 | 2111621.7183 | 37.7782782403601 | -122.43330286230899 | (37.7782782403601, -122.433302862309) | |||
| 149550 | 149550 | 138744 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2965 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999334.3934 | 2114268.2075 | 37.7853381723766 | -122.44605327160801 | (37.7853381723766, -122.446053271608) | |||
| 151515 | 151515 | 139447 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 508 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005464.5232 | 2111090.4798 | 37.7769610637771 | -122.424618726949 | (37.7769610637771, -122.424618726949) | |||
| 151601 | 151601 | 141533 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2901 TURK BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996746.9 | 2111493.597 | 37.7775717277647 | -122.45480462688101 | (37.7775717277647, -122.454804626881) | |||
| 152688 | 152688 | 141696 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 392 EWING TER | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998768.2977 | 2112343.8058 | 37.7800219238864 | -122.447873187985 | (37.7800219238864, -122.447873187985) | |||
| 152705 | 152705 | 143350 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1651 UNION ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6005097.5770000005 | 2118824.6493 | 37.7981764310334 | -122.426438931744 | (37.7981764310334, -122.426438931744) | |||
| 153429 | 153429 | 113988 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2183 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6002243.1253 | 2114325.3833 | 37.7856608347208 | -122.43599404678801 | (37.7856608347208, -122.435994046788) | |||
| 155805 | 155805 | 108006 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 520 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6005290.3504 | 2110988.0578 | 37.7766699998805 | -122.425213954913 | (37.7766699998805, -122.425213954913) | |||
| 157304 | 157304 | 142634 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 241 BAY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6009751.1154 | 2121551.1896 | 37.805924795329204 | -122.410528881628 | (37.8059247953292, -122.410528881628) | |||
| 159841 | 159841 | 141610 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1515 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000503.7259 | 2110965.3234 | 37.7763360028573 | -122.441770617481 | (37.7763360028573, -122.441770617481) | |||
| 160458 | 160458 | 106408 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 650 Presidio Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 5x9 | 5999241.4715 | 2114391.8555 | 37.7856723708173 | -122.44638365037399 | (37.7856723708173, -122.446383650374) | |||
| 163956 | 163956 | 108011 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 419X Ivy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6005290.828 | 2111124.4075 | 37.7770444098803 | -122.42522200735 | (37.7770444098803, -122.42522200735) | ||||
| 164772 | 164772 | 137520 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 11 Seymour St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6001651.2928 | 2112086.3813 | 37.779479465517504 | -122.437881186624 | (37.7794794655175, -122.437881186624) | |||
| 166089 | 166089 | 142491 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 651 COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009641.4463 | 2119604.1083 | 37.8005724449635 | -122.410770813978 | (37.8005724449635, -122.410770813978) | |||
| 167934 | 167934 | 138421 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1819 STEINER ST | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 0ft | 6002523.7545 | 2114441.5771 | 37.7859958117094 | -122.435031464821 | (37.7859958117094, -122.435031464821) | |||
| 170111 | 170111 | 115985 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6011253.147999999 | 2118063.4049 | 37.7964322821358 | -122.405085093558 | (37.7964322821358, -122.405085093558) | |||
| 170427 | 170427 | 199732 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014820.4695 | 2092191.1459 | 37.7255914365754 | -122.390932164611 | (37.7255914365754, -122.390932164611) | |||
| 170725 | 170725 | 199724 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2300 Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6015054.2433 | 2092170.6809999999 | 37.7255482128528 | -122.390122592124 | (37.7255482128528, -122.390122592124) | |||
| 173338 | 173338 | 143166 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2130 STOCKTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009846.1251 | 2121530.2463 | 37.805872616224704 | -122.410198604722 | (37.8058726162247, -122.410198604722) | |||
| 176807 | 176807 | 140541 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003379.3786 | 2111825.8979 | 37.7788623586164 | -122.43188440296001 | (37.7788623586164, -122.43188440296) | |||
| 180852 | 180852 | 246097 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997110.2988 | 2108193.2616 | 37.7685307006045 | -122.45330918662901 | (37.7685307006045, -122.453309186629) | |||
| 181180 | 181180 | 142104 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 902 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002990.6954 | 2110322.4378 | 37.774712189416704 | -122.43312156093398 | (37.7747121894167, -122.433121560934) | |||
| 181203 | 181203 | 98471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011899.7475 | 2107035.3895 | 37.7661880408824 | -122.40207202642401 | (37.7661880408824, -122.402072026424) | |||
| 181828 | 181828 | 245472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2700 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010432.7166 | 2102259.7859 | 37.7529933156944 | -122.406809623625 | (37.7529933156944, -122.406809623625) | |||
| 184834 | 184834 | 217619 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1830 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5994357.3344 | 2092471.2741 | 37.7252039110132 | -122.461691316268 | (37.7252039110132, -122.461691316268) | |||
| 188113 | 188113 | 142604 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 CHESTNUT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6008306.3204 | 2120712.3516 | 37.8035404535195 | -122.415469411535 | (37.8035404535195, -122.415469411535) | |||
| 156483 | 156483 | 32296 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 8 | Permit Number 36875 | 6011540.2459 | 2107019.2214 | 37.7661235750542 | -122.403314342162 | (37.7661235750542, -122.403314342162) | ||
| 111616 | 111616 | 37061 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.745930528166596 | -122.429203495744 | (37.7459305281666, -122.429203495744) | |
| 37094 | 37094 | 38611 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40556 | 6015254.5205 | 2094308.8703 | 37.7314303593885 | -122.389579509324 | (37.7314303593885, -122.389579509324) | |
| 131817 | 131817 | 45603 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1100 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2001 12:00:00 AM | 14 | Permit Number 44335 | 6003434.2619 | 2112117.4289 | 37.779665941263104 | -122.43171536011101 | (37.7796659412631, -122.431715360111) | ||
| 74568 | 74568 | 97937 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768327 | 6009817.5879999995 | 2121415.668 | 37.8055564131765 | -122.410289267199 | (37.8055564131765, -122.410289267199) | |
| 3219 | 3219 | 142514 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 624 VALLEJO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 20 | Width 0ft | Permit Number 774306 | 6010535.3238 | 2118936.1488 | 37.7987884700296 | -122.407630496745 | (37.7987884700296, -122.407630496745) | |
| 51356 | 51356 | 120658 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 160 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 778623 | 6015062.3817 | 2115495.3661 | 37.789593251915704 | -122.391724574055 | (37.7895932519157, -122.391724574055) | ||
| 1340 | 1340 | 7172 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003478.683999999 | 2111101.7087 | 37.7768795438362 | -122.43148915347099 | (37.7768795438362, -122.431489153471) |
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");