Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31267 | 31267 | 140047 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 997 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6002926.2641 | 2111608.0681 | 37.778238555435 | -122.433436333455 | (37.778238555435, -122.433436333455) | |||
| 140393 | 140393 | 140048 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 993 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6002927.2794 | 2111591.8239 | 37.7781940105178 | -122.433431660039 | (37.7781940105178, -122.433431660039) | |||
| 61935 | 61935 | 247443 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 988 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6002297.3139 | 2109877.1332 | 37.7734501371932 | -122.43548824232 | (37.7734501371932, -122.43548824232) | |||
| 54262 | 54262 | 247457 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 969 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6002376.9254 | 2109837.784 | 37.773346615242 | -122.435210039995 | (37.773346615242, -122.435210039995) | |||
| 153964 | 153964 | 59661 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 950 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19083 | 6002974.356000001 | 2111562.0693 | 37.7781149825494 | -122.433266678398 | (37.7781149825494, -122.433266678398) | ||
| 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) | |||
| 49156 | 49156 | 140591 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 950 STEINER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002971.355 | 2111585.6946 | 37.778179681485206 | -122.433278748514 | (37.7781796814852, -122.433278748514) | |||
| 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) | |||
| 7541 | 7541 | 7214 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 950 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003450.6988 | 2111662.2209 | 37.778416985075104 | -122.431625989594 | (37.7784169850751, -122.431625989594) | |||
| 8928 | 8928 | 7213 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 950 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003452.6284 | 2111644.2112 | 37.7783676442869 | -122.43161802827 | (37.7783676442869, -122.43161802827) | |||
| 1759 | 1759 | 7200 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 949 Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003420.9887 | 2111521.8792 | 37.7780299575939 | -122.431718745255 | (37.7780299575939, -122.431718745255) | |||
| 7644 | 7644 | 7201 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 949 Fillmore St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003424.6737 | 2111504.3754 | 37.7779821053868 | -122.431704747493 | (37.7779821053868, -122.431704747493) | |||
| 41568 | 41568 | 140583 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 949 FILLMORE ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6003424.6737 | 2111485.9504 | 37.7779315149131 | -122.431703431668 | (37.7779315149131, -122.431703431668) | |||
| 133517 | 133517 | 140585 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 949 FILLMORE ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6003432.0437 | 2111445.4153 | 37.777820633348796 | -122.43167504147699 | (37.7778206333488, -122.431675041477) | |||
| 155611 | 155611 | 140584 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 949 FILLMORE ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6003428.3587 | 2111466.6041 | 37.77787860365579 | -122.431689302353 | (37.7778786036558, -122.431689302353) | |||
| 44806 | 44806 | 59664 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 947 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1981 12:00:00 AM | 15 | 5x5 | Permit Number 19086 | 6002929.3099 | 2111572.5338 | 37.7781411599151 | -122.433423256969 | (37.7781411599151, -122.433423256969) | |
| 66240 | 66240 | 59663 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 943 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19085 | 6002930.6636 | 2111548.8443 | 37.778076191259 | -122.433416880741 | (37.778076191259, -122.433416880741) | ||
| 6144 | 6144 | 7206 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 940 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003460.3469 | 2111580.5338 | 37.778193239457295 | -122.431586779834 | (37.7781932394573, -122.431586779834) | |||
| 6743 | 6743 | 7207 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 940 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003456.4877 | 2111615.9101 | 37.778290155247205 | -122.431602656487 | (37.7782901552472, -122.431602656487) | |||
| 146907 | 146907 | 140056 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 933 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002938.7857 | 2111497.0658 | 37.77793448120671 | -122.433385082512 | (37.7779344812067, -122.433385082512) | |||
| 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) | ||
| 74885 | 74885 | 97311 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 926 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1984 12:00:00 AM | 7 | 3x3 | 5990303.3847 | 2099082.1466 | 37.7431214880079 | -122.47618790715099 | (37.7431214880079, -122.476187907151) | ||
| 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) | |
| 73116 | 73116 | 140597 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 926 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003478.9999 | 2111464.1135 | 37.7778746354568 | -122.431513938953 | (37.7778746354568, -122.431513938953) | |||
| 169493 | 169493 | 247449 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 919 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002569.9466 | 2109861.5161 | 37.773422736804 | -122.434544050831 | (37.773422736804, -122.434544050831) | |||
| 50203 | 50203 | 247450 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 917 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002601.5894 | 2109867.0536 | 37.773439737619704 | -122.43443498999599 | (37.7734397376197, -122.434434989996) | |||
| 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) | |||
| 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) | |||
| 175055 | 175055 | 59662 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 911 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1981 12:00:00 AM | 17 | Permit Number 19084 | 6002943.8621 | 2111474.7299 | 37.777873440392206 | -122.433365924976 | (37.7778734403922, -122.433365924976) | ||
| 166509 | 166509 | 59660 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 910 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1981 12:00:00 AM | 15 | Permit Number 19082 | 6002982.2355 | 2111513.667 | 37.777982528898704 | -122.43323596098 | (37.7779825288987, -122.43323596098) | ||
| 42656 | 42656 | 140057 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 909 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6002945.8926 | 2111449.3483 | 37.7778038640415 | -122.43335708659299 | (37.7778038640415, -122.433357086593) | |||
| 171567 | 171567 | 140062 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 907 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002950.6305 | 2111424.6435 | 37.7777362996085 | -122.43333893078301 | (37.7777362996085, -122.433338930783) | |||
| 137939 | 137939 | 59659 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 906 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19081 | 6002986.1752 | 2111478.2094 | 37.777885394660395 | -122.43321979797301 | (37.7778853946604, -122.433219797973) | ||
| 71479 | 71479 | 140063 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 905 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002952.9994 | 2111406.0303 | 37.7776853267914 | -122.433329405572 | (37.7776853267914, -122.433329405572) | |||
| 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) | |||
| 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) | |||
| 173946 | 173946 | 138927 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 901 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003523.5494 | 2110764.9413 | 37.775957406614204 | -122.431309905462 | (37.7759574066142, -122.431309905462) | |||
| 17284 | 17284 | 16993 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002625.7759 | 2109923.0859 | 37.7735949613156 | -122.434355332323 | (37.7735949613156, -122.434355332323) | |||
| 19445 | 19445 | 16994 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002602.5998 | 2109922.2867 | 37.7735914513761 | -122.434435444699 | (37.7735914513761, -122.434435444699) | |||
| 20899 | 20899 | 16992 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 1x1 | 6002640.9603 | 2109924.6842 | 37.773600211727 | -122.434302921546 | (37.773600211727, -122.434302921546) | |||
| 148730 | 148730 | 67753 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1992 12:00:00 AM | 11 | 3x3 | Permit Number 31377 | 6011258.7412 | 2118020.5233 | 37.79631485229 | -122.405062718866 | (37.79631485229, -122.405062718866) | |
| 162030 | 162030 | 115983 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6011256.8768 | 2118034.0404 | 37.796351862758996 | -122.40507012236701 | (37.796351862759, -122.405070122367) | |||
| 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) | |||
| 182606 | 182606 | 115984 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6011255.4785 | 2118051.2862 | 37.796399137392896 | -122.405076175742 | (37.7963991373929, -122.405076175742) | |||
| 38088 | 38088 | 142102 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 900 Fell St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6003042.617000001 | 2110331.1771 | 37.7747391304954 | -122.43294257823798 | (37.7747391304954, -122.432942578238) | |||
| 7436 | 7436 | 4702 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1989 12:00:00 AM | 30 | 3X3 | 6008773.44 | 2120486.1314 | 37.8029455537581 | -122.413836905739 | (37.8029455537581, -122.413836905739) | ||
| 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) | |||
| 17157 | 17157 | 16991 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 899 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002773.5007 | 2109890.2869 | 37.7735132873347 | -122.433841985714 | (37.7735132873347, -122.433841985714) | |||
| 21377 | 21377 | 16990 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 899 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002737.3984 | 2109886.1011 | 37.773499745425795 | -122.43396656947701 | (37.7734997454258, -122.433966569477) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 179842 | 179842 | 143496 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 877 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6011215.3935 | 2117948.7433 | 37.7961153384403 | -122.405207654625 | (37.7961153384403, -122.405207654625) | |||
| 5332 | 5332 | 10639 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 877 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003685.3267 | 2110714.3548 | 37.7758276754833 | -122.43074666505301 | (37.7758276754833, -122.430746665053) | |||
| 155471 | 155471 | 247306 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 873 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002371.1002 | 2109493.4114 | 37.772400722701796 | -122.435205553676 | (37.7724007227018, -122.435205553676) | |||
| 48254 | 48254 | 248610 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 872 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997691.4278 | 2107516.4386 | 37.7667056091614 | -122.4512503025 | (37.7667056091614, -122.4512503025) | |||
| 20398 | 20398 | 16986 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 870 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002847.8984 | 2109953.1746 | 37.7736901829149 | -122.433589128645 | (37.7736901829149, -122.433589128645) | |||
| 5748 | 5748 | 6994 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 870 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003272.597999999 | 2110360.7630000003 | 37.77483340788321 | -122.43214914086201 | (37.7748334078832, -122.432149140862) | |||
| 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) | |||
| 156337 | 156337 | 143497 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 867 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6011217.2579 | 2117938.9551 | 37.796088566637394 | -122.40520051378999 | (37.7960885666374, -122.40520051379) | |||
| 47609 | 47609 | 139282 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 863 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003442.6809 | 2111357.0537 | 37.7775786172665 | -122.431631933616 | (37.7775786172665, -122.431631933616) | |||
| 60986 | 60986 | 248611 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 862 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997689.6108 | 2107534.9111 | 37.7667562259025 | -122.45125791953001 | (37.7667562259025, -122.45125791953) | |||
| 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) | |||
| 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) | |||
| 175619 | 175619 | 244473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 859 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003334.8057 | 2110313.6958 | 37.774707699745996 | -122.43193059003599 | (37.774707699746, -122.431930590036) | |||
| 130403 | 130403 | 143498 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 857 Kearny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6011217.723999999 | 2117930.0991 | 37.796064276257205 | -122.40519827705499 | (37.7960642762572, -122.405198277055) | |||
| 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) | |||
| 119306 | 119306 | 139284 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 855 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003447.6659 | 2111322.7123 | 37.7774846068582 | -122.431612236467 | (37.7774846068582, -122.431612236467) | |||
| 147729 | 147729 | 139283 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 855 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003446.5582 | 2111336.5596 | 37.7775225653231 | -122.431617057223 | (37.7775225653231, -122.431617057223) | |||
| 5904 | 5904 | 24490 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 852 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6003356.8582 | 2110371.9538 | 37.7748689119653 | -122.431858466675 | (37.7748689119653, -122.431858466675) | ||
| 155455 | 155455 | 140609 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 850 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003501.1005 | 2111292.4942 | 37.777404664022 | -122.431425230844 | (37.777404664022, -122.431425230844) | |||
| 132506 | 132506 | 143556 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 848 KEARNY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6011275.0549 | 2117918.4465 | 37.796035485985705 | -122.40499907891301 | (37.7960354859857, -122.404999078913) | |||
| 169665 | 169665 | 143557 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 848 KEARNY ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6011271.7921 | 2117938.489 | 37.7960903354635 | -122.405011780806 | (37.7960903354635, -122.405011780806) | |||
| 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) | |||
| 24268 | 24268 | 139286 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 847 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003452.0971 | 2111280.6163 | 37.777369272847295 | -122.431593901382 | (37.7773692728473, -122.431593901382) | |||
| 8030 | 8030 | 10637 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 843 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003821.4079 | 2110734.0055 | 37.7758893402664 | -122.43027732793101 | (37.7758893402664, -122.430277327931) | ||
| 8268 | 8268 | 10636 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003811.0913 | 2110732.5317 | 37.7758847092198 | -122.430312910525 | (37.7758847092198, -122.430312910525) | ||
| 64806 | 64806 | 140608 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 840 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6003502.6081 | 2111278.9255 | 37.7773674931794 | -122.431419046703 | (37.7773674931794, -122.431419046703) | |||
| 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) | |||
| 6126 | 6126 | 7180 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 837 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003455.9744 | 2111255.1372 | 37.7772995333232 | -122.43157866908199 | (37.7772995333232, -122.431578669082) | |||
| 6429 | 6429 | 7178 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 837 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6x6 | 6003458.7438 | 2111235.1971 | 37.777244939721704 | -122.431567664925 | (37.7772449397217, -122.431567664925) | |||
| 5648 | 5648 | 7179 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 833 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003463.175 | 2111217.4725 | 37.777196523521795 | -122.431551070298 | (37.7771965235218, -122.431551070298) | |||
| 1064 | 1064 | 7177 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 827 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003463.7289 | 2111198.6401 | 37.7771448458144 | -122.431547809387 | (37.7771448458144, -122.431547809387) | |||
| 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) | |||
| 8458 | 8458 | 7176 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 821 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003466.4983 | 2111179.8077 | 37.777093293678206 | -122.43153688437401 | (37.7770932936782, -122.431536884374) | |||
| 180558 | 180558 | 66720 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 819 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1991 12:00:00 AM | 14 | Permit Number 29962 | 5999956.9512 | 2111893.0193 | 37.778852049002 | -122.44372871968399 | (37.778852049002, -122.443728719684) | ||
| 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) | ||
| 31071 | 31071 | 247300 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 815 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002551.3233 | 2109517.7945 | 37.772477905220796 | -122.434583889381 | (37.7724779052208, -122.434583889381) | |||
| 9575 | 9575 | 23736 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 815 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2005 12:00:00 AM | 8 | 4X4 | 6003952.5765 | 2110750.7086 | 37.775942631605204 | -122.429824773698 | (37.7759426316052, -122.429824773698) | ||
| 131601 | 131601 | 140621 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 814 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003510.9001 | 2111228.4198 | 37.7772292869927 | -122.431386755732 | (37.7772292869927, -122.431386755732) | |||
| 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) | |||
| 30879 | 30879 | 247445 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 811 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003098.9445 | 2109936.0688 | 37.7736574554899 | -122.432719499751 | (37.7736574554899, -122.432719499751) | |||
| 166843 | 166843 | 63488 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 811 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/07/1987 12:00:00 AM | 12 | Permit Number 24085 | 5999970.1497 | 2111784.3859 | 37.7785545222825 | -122.443675254762 | (37.7785545222825, -122.443675254762) | |
| 68519 | 68519 | 140631 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 810 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003522.9612 | 2111140.977 | 37.7769898742733 | -122.431338789049 | (37.7769898742733, -122.431338789049) | |||
| 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) | |||
| 176802 | 176802 | 140630 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 808 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003528.2379 | 2111115.3472 | 37.7769198002338 | -122.431318705355 | (37.7769198002338, -122.431318705355) | |||
| 186307 | 186307 | 137638 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 807 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999975.5644 | 2111759.3427 | 37.778486068888796 | -122.443654723767 | (37.7784860688888, -122.443654723767) | |||
| 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) | ||
| 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");