trees
1,381 rows where qSpecies_id = 54 sorted by rowid descending
This data as json, CSV (advanced)
| rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 181049 | 9074 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 5612 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5989576.4513 | 2112697.6008 | 37.780463671789 | -122.479697457165 | (37.780463671789, -122.479697457165) | 11 | 6 | 2 | 55 | 26 | |||
| 180949 | 38058 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2844 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 15 | Permit Number 40253 | 5999884.3012 | 2114402.2303 | 37.7857375510232 | -122.44416039717 | (37.7857375510232, -122.44416039717) | 15 | 6 | 1 | 29490 | 31 | |
| 180620 | 143540 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2149 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002719.054 | 2118495.5705 | 37.7971381238315 | -122.434645771265 | (37.7971381238315, -122.434645771265) | 13 | 9 | 1 | 57 | 17 | |||
| 180542 | 17132 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2017 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5997337.3364 | 2109131.1798 | 37.7711189934376 | -122.452591584143 | (37.7711189934376, -122.452591584143) | 15 | 5 | 11 | 29492 | 9 | |||
| 180082 | 143557 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 848 KEARNY ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6011271.7921 | 2117938.489 | 37.7960903354635 | -122.405011780806 | (37.7960903354635, -122.405011780806) | 3 | 1 | 10 | 28857 | 4 | |||
| 180014 | 138587 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1732 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000059.0615 | 2114952.3738 | 37.7872580704829 | -122.443595312613 | (37.7872580704829, -122.443595312613) | 13 | 6 | 1 | 29490 | 27 | |||
| 179783 | 106204 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1600X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 5x5 | 6003122.9413 | 2113972.2468 | 37.7847411535968 | -122.432924900964 | (37.7847411535968, -122.432924900964) | 13 | 9 | 11 | 29490 | 13 | |||
| 179434 | 143506 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1944 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003692.4061 | 2118683.7427 | 37.7977100049425 | -122.431291172811 | (37.7977100049425, -122.431291172811) | 13 | 9 | 1 | 57 | 17 | |||
| 179334 | 141082 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 188 Commonwealth Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5996586.3547 | 2113042.2151 | 37.7818146143415 | -122.455471958556 | (37.7818146143415, -122.455471958556) | 11 | 6 | 1 | 54 | 31 | |||
| 179204 | 140428 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 7 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6003076.6138 | 2112365.9894 | 37.7803281468599 | -122.432970381874 | (37.7803281468599, -122.432970381874) | 15 | 9 | 11 | 29490 | 41 | |||
| 179052 | 182246 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1455 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5985863.116 | 2105312.6885 | 37.7599703705151 | -122.491999577939 | (37.7599703705151, -122.491999577939) | 1 | 8 | 3 | 56 | 35 | |||
| 178882 | 16964 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 747 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6003424.2649 | 2109979.0777 | 37.7737939919852 | -122.431597238278 | (37.7737939919852, -122.431597238278) | 15 | 9 | 11 | 29492 | 10 | |||
| 178861 | 37062 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 1450 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.7459305281666 | -122.429203495744 | (37.7459305281666, -122.429203495744) | 2 | 7 | 5 | 63 | 22 | ||
| 178797 | 142102 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Fell St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 6003042.617 | 2110331.1771 | 37.7747391304954 | -122.432942578238 | (37.7747391304954, -122.432942578238) | 15 | 5 | 11 | 29492 | 10 | |||
| 178749 | 59661 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 950 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19083 | 6002974.356 | 2111562.0693 | 37.7781149825494 | -122.433266678398 | (37.7781149825494, -122.433266678398) | 15 | 9 | 11 | 29492 | 41 | ||
| 178727 | 199743 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2351 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6014556.9144 | 2092538.9669 | 37.7265318557922 | -122.391867570434 | (37.7265318557922, -122.391867570434) | 10 | 3 | 8 | 58 | 1 | |||
| 178582 | 138502 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1799 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002532.1465 | 2114322.3247 | 37.7856688514425 | -122.434993898965 | (37.7856688514425, -122.434993898965) | 13 | 9 | 11 | 29490 | 13 | |||
| 178572 | 113276 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2129 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6002796.8552 | 2118506.6849 | 37.7971730575287 | -122.434377355222 | (37.7971730575287, -122.434377355222) | 13 | 9 | 1 | 57 | 17 | |||
| 178543 | 140710 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002647.4691 | 2110413.42 | 37.7749425283913 | -122.434315354923 | (37.7749425283913, -122.434315354923) | 15 | 5 | 11 | 29492 | 10 | |||
| 177996 | 17124 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1959 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997650.0826 | 2109175.1865 | 37.7712577387998 | -122.451512964016 | (37.7712577387998, -122.451512964016) | 15 | 5 | 11 | 29492 | 9 | |||
| 177953 | 16896 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 377 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005209.3255 | 2110233.2837 | 37.7745929962798 | -122.425440517449 | (37.7745929962798, -122.425440517449) | 7 | 9 | 11 | 28852 | 10 | |||
| 177855 | 18050 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2832 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000363.8297 | 2114817.6224 | 37.7869054550264 | -122.442531204238 | (37.7869054550264, -122.442531204238) | 13 | 6 | 1 | 29490 | 27 | |||
| 177769 | 63908 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2125 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/1987 12:00:00 AM | 14 | Permit Number 24623 | 6009389.9763 | 2121003.9446 | 37.8044019445665 | -122.411739972568 | (37.8044019445665, -122.411739972568) | 3 | 1 | 10 | 308 | 23 | ||
| 177642 | 142107 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1223 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001862.2998 | 2111151.4099 | 37.7769242660631 | -122.437084266624 | (37.7769242660631, -122.437084266624) | 15 | 5 | 11 | 29492 | 10 | |||
| 177613 | 244504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 697 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003691.552 | 2110018.3364 | 37.773916933054 | -122.430675451783 | (37.773916933054, -122.430675451783) | 7 | 9 | 11 | 29492 | 10 | |||
| 177315 | 138475 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1749 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6003020.8355 | 2114339.7281 | 37.7857443724045 | -122.433304420865 | (37.7857443724045, -122.433304420865) | 13 | 9 | 11 | 29490 | 13 | |||
| 177164 | 13222 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2245 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001648.8811 | 2119355.19 | 37.7994376018224 | -122.438410445473 | (37.7994376018224, -122.438410445473) | 13 | 9 | 1 | 57 | 17 | |||
| 177129 | 247502 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1105 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002054.0619 | 2110138.0012 | 37.7741525973198 | -122.436348358239 | (37.7741525973198, -122.436348358239) | 15 | 5 | 11 | 29492 | 10 | |||
| 176892 | 544 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2872 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009585.3031 | 2102212.479 | 37.7528159694172 | -122.409736815429 | (37.7528159694172, -122.409736815429) | 2 | 4 | 7 | 28859 | 19 | |||
| 176662 | 99230 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008035.3898 | 2121073.3853 | 37.8045165290969 | -122.416432570152 | (37.8045165290969, -122.416432570152) | 5 | 1 | 10 | 308 | 32 | |||
| 176648 | 140610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 860 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6003498.0852 | 2111306.0629 | 37.7774417494141 | -122.431436630621 | (37.7774417494141, -122.431436630621) | 7 | 9 | 11 | 29492 | 10 | |||
| 176134 | 10477 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1649 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5998216.9877 | 2108565.5899 | 37.7696163897252 | -122.449508092743 | (37.7696163897252, -122.449508092743) | 15 | 5 | 11 | 29492 | 9 | |||
| 176113 | 246089 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 29 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998181.8595 | 2108411.1471 | 37.7691903195921 | -122.449618468841 | (37.7691903195921, -122.449618468841) | 15 | 5 | 11 | 29492 | 9 | |||
| 175970 | 141351 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 457 BRODERICK ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 6001146.5934 | 2110320.3656 | 37.7746017201243 | -122.439500520347 | (37.7746017201243, -122.439500520347) | 15 | 5 | 11 | 29492 | 10 | |||
| 175326 | 15326 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006681.5676 | 2108466.3283 | 37.7698244299152 | -122.420222300021 | (37.7698244299152, -122.420222300021) | 8 | 4 | 7 | 28853 | 19 | |||
| 175312 | 142179 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 400 BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000700.9795 | 2110406.5438 | 37.7748129727095 | -122.441048166714 | (37.7748129727095, -122.441048166714) | 15 | 5 | 11 | 29492 | 10 | |||
| 175132 | 244244 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 150 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005791.8047 | 2110016.6014 | 37.7740309317752 | -122.423410197258 | (37.7740309317752, -122.423410197258) | 7 | 9 | 11 | 28852 | 10 | |||
| 174812 | 143130 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2770 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5999261.9713 | 2119102.3163 | 37.7986072215669 | -122.44665176347 | (37.7986072215669, -122.44665176347) | 13 | 9 | 1 | 57 | 17 | |||
| 174803 | 140293 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 135 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998254.8738 | 2110151.3644 | 37.773972687525 | -122.449491324786 | (37.773972687525, -122.449491324786) | 15 | 5 | 11 | 29492 | 16 | |||
| 174777 | 13185 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2055X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002536.6029 | 2119475.0682 | 37.7998172097056 | -122.435347197327 | (37.7998172097056, -122.435347197327) | 13 | 9 | 1 | 57 | 17 | |||
| 174691 | 108010 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419X Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6005279.8436 | 2111122.0196 | 37.7770372327377 | -122.42525983588 | (37.7770372327377, -122.42525983588) | 7 | 9 | 11 | 28852 | 10 | ||||
| 174467 | 143349 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1651 UNION ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005080.6941 | 2118822.052 | 37.7981683451252 | -122.426497166568 | (37.7981683451252, -122.426497166568) | 13 | 9 | 1 | 57 | 17 | |||
| 174365 | 21629 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1615 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1994 12:00:00 AM | 12 | 4X4 | 6004674.0893 | 2114666.9174 | 37.7867364034737 | -122.427607948661 | (37.7867364034737, -122.427607948661) | 13 | 9 | 11 | 28858 | 13 | ||
| 174355 | 246165 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5997526.8402 | 2108168.581 | 37.7684868003121 | -122.451866631913 | (37.7684868003121, -122.451866631913) | 15 | 5 | 11 | 29492 | 9 | |||
| 174204 | 140775 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 79 TERRA VISTA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000103.2341 | 2112808.3657 | 37.7813736978278 | -122.443288433233 | (37.7813736978278, -122.443288433233) | 15 | 5 | 1 | 29490 | 16 | |||
| 174010 | 21712 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1900 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6x8 | 6003372.5799 | 2114537.2521 | 37.7863066717407 | -122.432101596345 | (37.7863066717407, -122.432101596345) | 13 | 9 | 11 | 29490 | 27 | |||
| 173853 | 59660 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 910 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 15 | Permit Number 19082 | 6002982.2355 | 2111513.667 | 37.7779825288987 | -122.43323596098 | (37.7779825288987, -122.43323596098) | 15 | 9 | 11 | 29492 | 41 | ||
| 173263 | 142465 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1457 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010961.892 | 2119955.2575 | 37.8016105625065 | -122.406226265244 | (37.8016105625065, -122.406226265244) | 3 | 1 | 10 | 308 | 23 | |||
| 173201 | 142961 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 188 Pfeiffer St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6009941.6774 | 2121096.811 | 37.8046878662366 | -122.409837314827 | (37.8046878662366, -122.409837314827) | 3 | 1 | 10 | 308 | 23 | |||
| 173051 | 140068 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 582 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005004.7286 | 2111303.2254 | 37.7775192332012 | -122.426224448803 | (37.7775192332012, -122.426224448803) | 7 | 9 | 11 | 28852 | 10 | |||
| 172891 | 98024 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1639 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5988098.059 | 2098940.517 | 37.742604479099 | -122.483802857352 | (37.742604479099, -122.483802857352) | 1 | 8 | 3 | 29491 | 35 | |||
| 172748 | 142944 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 152 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6010124.6433 | 2121121.924 | 37.8047670723213 | -122.409205913626 | (37.8047670723213, -122.409205913626) | 3 | 1 | 10 | 308 | 23 | |||
| 172700 | 99231 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008046.5206 | 2121063.2366 | 37.8044892892651 | -122.416393331612 | (37.8044892892651, -122.416393331612) | 5 | 1 | 10 | 308 | 32 | |||
| 172618 | 141075 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 189 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5996533.8993 | 2113075.3805 | 37.7819026676704 | -122.455655826701 | (37.7819026676704, -122.455655826701) | 11 | 6 | 1 | 54 | 31 | |||
| 172590 | 247448 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 899 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002819.5442 | 2109896.0423 | 37.7735317029302 | -122.433683126065 | (37.7735317029302, -122.433683126065) | 15 | 5 | 11 | 29492 | 9 | |||
| 172387 | 143338 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1862 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004088.5033 | 2118729.1964 | 37.797857248461 | -122.429923812172 | (37.797857248461, -122.429923812172) | 13 | 9 | 1 | 57 | 17 | |||
| 172312 | 527 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2836 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6009841.2951 | 2102226.6843 | 37.7528693162895 | -122.408852546362 | (37.7528693162895, -122.408852546362) | 2 | 4 | 7 | 28859 | 19 | |||
| 172102 | 21739 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2045 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002859.7063 | 2114412.7642 | 37.785935768772 | -122.433867103908 | (37.785935768772, -122.433867103908) | 13 | 9 | 11 | 29490 | 13 | |||
| 171824 | 1652 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5998816.4722 | 2109337.1138 | 37.7717690739196 | -122.447490047494 | (37.7717690739196, -122.447490047494) | 15 | 5 | 11 | 29492 | 9 | |||
| 171060 | 15433 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2135 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006876.1683 | 2105910.6162 | 37.7628180091578 | -122.419367848279 | (37.7628180091578, -122.419367848279) | 8 | 4 | 7 | 28859 | 19 | |||
| 170999 | 110580 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 403 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6001169.4361 | 2110112.2986 | 37.7740317204292 | -122.439406585409 | (37.7740317204292, -122.439406585409) | 15 | 5 | 11 | 29492 | 10 | |||
| 170938 | 59662 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 911 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 17 | Permit Number 19084 | 6002943.8621 | 2111474.7299 | 37.7778734403922 | -122.433365924976 | (37.7778734403922, -122.433365924976) | 15 | 9 | 11 | 29492 | 41 | ||
| 170781 | 21586 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1500 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005346.0976 | 2114810.866 | 37.7871696385608 | -122.425293204645 | (37.7871696385608, -122.425293204645) | 13 | 9 | 11 | 28858 | 27 | |||
| 170716 | 141079 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 194 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5996588.7236 | 2113000.2508 | 37.7816995274116 | -122.455460729419 | (37.7816995274116, -122.455460729419) | 11 | 6 | 1 | 54 | 31 | |||
| 170680 | 143496 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 877 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6011215.3935 | 2117948.7433 | 37.7961153384403 | -122.405207654625 | (37.7961153384403, -122.405207654625) | 3 | 1 | 10 | 28857 | 4 | |||
| 170449 | 10636 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003811.0913 | 2110732.5317 | 37.7758847092198 | -122.430312910525 | (37.7758847092198, -122.430312910525) | 7 | 9 | 11 | 29492 | 10 | ||
| 170320 | 246043 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 601 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5997853.8956 | 2108495.9392 | 37.7694043689932 | -122.450758987128 | (37.7694043689932, -122.450758987128) | 15 | 5 | 11 | 29492 | 9 | |||
| 170228 | 7164 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 733 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003503.3323 | 2110918.6468 | 37.7763782981407 | -122.431390816474 | (37.7763782981407, -122.431390816474) | 15 | 9 | 11 | 29492 | 10 | |||
| 170149 | 142562 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2145 POWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6009382.2185 | 2121078.4189 | 37.804605997205 | -122.4117720848 | (37.804605997205, -122.4117720848) | 3 | 1 | 10 | 308 | 23 | |||
| 170076 | 199769 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1197 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6016909.41 | 2092306.5247 | 37.7260239336289 | -122.383718829233 | (37.7260239336289, -122.383718829233) | 10 | 3 | 8 | 58 | 1 | |||
| 170061 | 140544 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003387.6502 | 2111766.8151 | 37.7787006008552 | -122.431851568456 | (37.7787006008552, -122.431851568456) | 15 | 9 | 11 | 29490 | 41 | |||
| 169613 | 143218 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 251 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010143.2987 | 2121269.7317 | 37.8051739606787 | -122.409151790672 | (37.8051739606787, -122.409151790672) | 3 | 1 | 10 | 308 | 23 | |||
| 169233 | 68430 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 501 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | 6 | Permit Number 32281 | 6005253.5217 | 2111626.0919 | 37.7784198049854 | -122.425386771844 | (37.7784198049854, -122.425386771844) | 7 | 9 | 11 | 28852 | 10 | ||
| 169210 | 17056 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1285 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x4.5 | 6000853.6213 | 2109624.5846 | 37.7726746024779 | -122.440464053818 | (37.7726746024779, -122.440464053818) | 15 | 5 | 11 | 29492 | 9 | |||
| 169091 | 246094 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 Stanyan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5997100.0026 | 2108265.6377 | 37.7687288366145 | -122.453350026115 | (37.7687288366145, -122.453350026115) | 15 | 5 | 11 | 29492 | 9 | |||
| 168911 | 142600 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 365 COLUMBUS AVE | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008394.1949 | 2120748.9012 | 37.803645748305 | -122.415167905628 | (37.803645748305, -122.415167905628) | 5 | 1 | 10 | 308 | 32 | |||
| 168823 | 246084 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1390 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999058.5497 | 2108380.2585 | 37.7691556230859 | -122.446583834228 | (37.7691556230859, -122.446583834228) | 15 | 5 | 11 | 29492 | 9 | |||
| 168798 | 17133 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2021 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5997314.265 | 2109127.7618 | 37.7711082865548 | -122.452671141791 | (37.7711082865548, -122.452671141791) | 15 | 5 | 11 | 29492 | 9 | |||
| 168368 | 112635 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1715 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6000531.3846 | 2114698.9549 | 37.7865891741887 | -122.441942983766 | (37.7865891741887, -122.441942983766) | 13 | 6 | 1 | 29490 | 27 | |||
| 168247 | 43881 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1245 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 3 | Permit Number 43494 | 5981473.1113 | 2106617.2091 | 37.7632946239394 | -122.507278997702 | (37.7632946239394, -122.507278997702) | 1 | 8 | 3 | 56 | 35 | ||
| 168055 | 181853 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2318 32nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5986420.3329 | 2099445.95 | 37.7438944556176 | -122.489641026377 | (37.7438944556176, -122.489641026377) | 1 | 8 | 3 | 29491 | 35 | |||
| 167935 | 18023 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2729 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000744.2415 | 2114813.5523 | 37.7869159561343 | -122.441214778061 | (37.7869159561343, -122.441214778061) | 13 | 6 | 1 | 29490 | 27 | |||
| 167831 | 97937 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2133 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768327 | 6009817.588 | 2121415.668 | 37.8055564131765 | -122.410289267199 | (37.8055564131765, -122.410289267199) | 3 | 1 | 10 | 308 | 23 | |
| 167816 | 138091 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1890 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 15 | Width 0ft | 6003632 | 2114586 | 37.7864552256154 | -122.431207550794 | (37.7864552256154, -122.431207550794) | 13 | 9 | 11 | 29490 | 27 | ||
| 167706 | 32297 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1616 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011502.2034 | 2107015.4172 | 37.7661110048054 | -122.403445656745 | (37.7661110048054, -122.403445656745) | 8 | 3 | 8 | 28853 | 20 | ||
| 167542 | 143170 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 179 Bay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009922.0853 | 2121576.7805 | 37.8060046449874 | -122.409939018662 | (37.8060046449874, -122.409939018662) | 3 | 1 | 10 | 308 | 23 | |||
| 167541 | 251079 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 5616 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5989547.9545 | 2112698.1385 | 37.7804634926969 | -122.479796079248 | (37.7804634926969, -122.479796079248) | 11 | 6 | 2 | 55 | 26 | |||
| 167294 | 7167 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 761 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003488.931 | 2111020.5633 | 37.776657319429 | -122.431447911846 | (37.776657319429, -122.431447911846) | 15 | 9 | 11 | 29492 | 10 | |||
| 167293 | 7023 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1115 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002035.3214 | 2110135.6586 | 37.7741451002744 | -122.436413017138 | (37.7741451002744, -122.436413017138) | 15 | 5 | 11 | 29492 | 10 | |||
| 167006 | 112132 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 630 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6003600.3374 | 2110567.9569 | 37.7754208875098 | -122.431030213476 | (37.7754208875098, -122.431030213476) | 7 | 9 | 11 | 29492 | 10 | |||
| 166999 | 182128 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2650 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987739.3319 | 2098310.7141 | 37.7408543176455 | -122.484997019316 | (37.7408543176455, -122.484997019316) | 1 | 8 | 3 | 29491 | 35 | |||
| 166532 | 247447 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 899 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002801.7546 | 2109893.9494 | 37.7735249469174 | -122.433744513243 | (37.7735249469174, -122.433744513243) | 15 | 5 | 11 | 29492 | 9 | |||
| 166492 | 247345 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 604 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6004033.5399 | 2110118.9664 | 37.7742126072073 | -122.429499636998 | (37.7742126072073, -122.429499636998) | 7 | 9 | 11 | 29492 | 10 | |||
| 166387 | 141766 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1529 O'Farrell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003866.9642 | 2113516.1114 | 37.783530892448 | -122.430318273506 | (37.783530892448, -122.430318273506) | 13 | 9 | 11 | 29490 | 41 | |||
| 166357 | 246283 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2125 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6006872.377 | 2105970.5198 | 37.7629822769131 | -122.419385210964 | (37.7629822769131, -122.419385210964) | 8 | 4 | 7 | 28859 | 19 | |||
| 166317 | 247450 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 917 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6002601.5894 | 2109867.0536 | 37.7734397376197 | -122.434434989996 | (37.7734397376197, -122.434434989996) | 15 | 5 | 11 | 29492 | 9 | |||
| 166303 | 33642 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 462 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 10 | Permit Number 37736 | 6005186.1558 | 2110786.6502 | 37.776111096903 | -122.42556005737 | (37.776111096903, -122.42556005737) | 7 | 9 | 11 | 28852 | 10 | |
| 166162 | 142959 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 178 Pfeiffer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009960.8111 | 2121097.7677 | 37.8046915653635 | -122.409771168052 | (37.8046915653635, -122.409771168052) | 3 | 1 | 10 | 308 | 23 | |||
| 166099 | 19218 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1103X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002097.9849 | 2110143.8576 | 37.7741711731344 | -122.436196840248 | (37.7741711731344, -122.436196840248) | 15 | 5 | 11 | 29492 | 10 | |||
| 165915 | 7168 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 761 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003490.0388 | 2111001.7309 | 37.7766056731066 | -122.431442734929 | (37.7766056731066, -122.431442734929) | 15 | 9 | 11 | 29492 | 10 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );