trees
1,626 rows where qSpecies_id = 53 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28739 | 11129 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2140 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6007198.4118085 | 2119638.2581616 | 37.8005289300711 | -122.419227150729 | (37.8005289300711, -122.419227150729) | 5 | 1 | 1 | 28858 | 32 | |||
| 58920 | 11130 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2140 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6007198.4118085 | 2119638.2581616 | 37.8005289300711 | -122.419227150729 | (37.8005289300711, -122.419227150729) | 5 | 1 | 1 | 28858 | 32 | |||
| 110376 | 25995 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1781 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6014085.16035 | 2096167.03762 | 37.7364675981514 | -122.39375225191 | (37.7364675981514, -122.39375225191) | 10 | 3 | 8 | 58 | 1 | |||
| 115017 | 4281 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 4270 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2X2 | 6002137.7495821 | 2100347.8176818 | 37.7472758823749 | -122.435358414005 | (37.7472758823749, -122.435358414005) | 2 | 4 | 5 | 63 | 22 | |||
| 122006 | 4883 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 87 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 2X2 | 6000657.5251593 | 2098217.505729 | 37.7413423773337 | -122.440324154875 | (37.7413423773337, -122.440324154875) | 2 | 7 | 5 | 63 | 7 | |||
| 130776 | 25271 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1800 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 5994503.82801 | 2092400.83619 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | 9 | 8 | 4 | 28861 | 40 | |||
| 137544 | 25272 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1800 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 5994503.82801 | 2092400.83619 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | 9 | 8 | 4 | 28861 | 40 | |||
| 151589 | 25270 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1800 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 5994503.82801 | 2092400.83619 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | 9 | 8 | 4 | 28861 | 40 | |||
| 168485 | 25273 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1800 Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 5994503.82801 | 2092400.83619 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | 9 | 8 | 4 | 28861 | 40 | |||
| 83228 | 28249 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3340 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011954.9354871 | 2090169.2153285 | 37.7198802090971 | -122.400696159958 | (37.7198802090971, -122.400696159958) | 10 | 7 | 8 | 309 | 28 | |||
| 103656 | 28250 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3340 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011954.9354871 | 2090169.2153285 | 37.7198802090971 | -122.400696159958 | (37.7198802090971, -122.400696159958) | 10 | 7 | 8 | 309 | 28 | |||
| 69799 | 59060 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4437 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1992 12:00:00 AM | 14 | 2x2 | Permit Number 30882 | 6000423.21385776 | 2102243.23045707 | 37.7523827100743 | -122.441423120737 | (37.7523827100743, -122.441423120737) | 2 | 4 | 5 | 28862 | 22 | |
| 178705 | 59665 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 993 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 12 | 2x2 | Permit Number 19087 | 6002914.43276984 | 2111641.44659541 | 37.7783295332017 | -122.433479648258 | (37.7783295332017, -122.433479648258) | 15 | 9 | 11 | 29492 | 41 | |
| 181257 | 109235 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 670 CHENERY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6002570.3 | 2095716.9 | 37.7345850124828 | -122.433531794387 | (37.7345850124828, -122.433531794387) | 2 | 7 | 5 | 63 | 7 | ||||
| 65899 | 109000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 525x BURNETT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 circle | 5999530 | 2102478 | 37.7529764040195 | -122.444528861079 | (37.7529764040195, -122.444528861079) | 2 | 5 | 5 | 63 | 38 | |||
| 43665 | 94218 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 01st St | 3 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | 6 | 2 | 9 | 28855 | 6 | ||
| 59324 | 94216 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1X Tehama St | 1 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6013910.7 | 2114841.3 | 37.7877333404996 | -122.395663455814 | (37.7877333404996, -122.395663455814) | 6 | 2 | 9 | 28855 | 6 | ||
| 152209 | 105842 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 51 Prosper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 2x3 | 6003352 | 2106231 | 37.7634985883576 | -122.431579576657 | (37.7634985883576, -122.431579576657) | 15 | 4 | 5 | 28862 | 3 | |||
| 162339 | 10147 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 940 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2x3 | 6005660.7422371 | 2103489.3240903 | 37.7561011788947 | -122.423399446987 | (37.7561011788947, -122.423399446987) | 2 | 4 | 5 | 28859 | 19 | |||
| 187881 | 94217 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 01st St | 2 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | 6 | 2 | 9 | 28855 | 6 | ||
| 148347 | 18327 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 259 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X2 | 6010329.0895487 | 2107117.8320658 | 37.7663266190773 | -122.407510465965 | (37.7663266190773, -122.407510465965) | 8 | 4 | 8 | 28853 | 19 | |||
| 371 | 251215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 175X Otis St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | ||||
| 5822 | 16933 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 530 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 3X3 | 6004214.00427 | 2110149.16937 | 37.7743057532085 | -122.428877532014 | (37.7743057532085, -122.428877532014) | 7 | 9 | 11 | 28852 | 10 | |||
| 13161 | 4609 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 316 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774670 | 6010771.0363 | 2118706.95943 | 37.7981723635161 | -122.406798689949 | (37.7981723635161, -122.406798689949) | 3 | 1 | 10 | 308 | 23 | |
| 14128 | 16935 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 542 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004164.66828 | 2110140.85762 | 37.7742801386068 | -122.429047601533 | (37.7742801386068, -122.429047601533) | 7 | 9 | 11 | 28852 | 10 | |||
| 14591 | 17106 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1777 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5998507.83576 | 2109285.1679 | 37.7716088013494 | -122.448553894841 | (37.7716088013494, -122.448553894841) | 15 | 5 | 11 | 29492 | 9 | |||
| 14802 | 11429 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 810X Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016007.44377 | 2096780.42114 | 37.7382584597776 | -122.387148815626 | (37.7382584597776, -122.387148815626) | 10 | 3 | 8 | 58 | 1 | |||
| 18087 | 4603 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 270 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6010933.33158 | 2118545.7793 | 37.7977388815556 | -122.406225735505 | (37.7977388815556, -122.406225735505) | 3 | 1 | 10 | 308 | 23 | |||
| 19494 | 20113 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800X OAK ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002934 | 2109937 | 37.7736506563952 | -122.433290134136 | (37.7736506563952, -122.433290134136) | 15 | 5 | 11 | 29492 | 9 | |||
| 20324 | 4630 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 427 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6010279.42625 | 2119026.32466 | 37.7990217431564 | -122.408522353672 | (37.7990217431564, -122.408522353672) | 3 | 1 | 10 | 308 | 4 | |||
| 20430 | 647 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
| 20552 | 15171 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 941 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010472.08374 | 2112774.72891 | 37.7818671496492 | -122.407414720255 | (37.7818671496492, -122.407414720255) | 14 | 2 | 9 | 28853 | 34 | |||
| 20606 | 15650 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3718 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6005292.79028 | 2096596.92241 | 37.7371554485093 | -122.42418178869 | (37.7371554485093, -122.42418178869) | 2 | 7 | 5 | 28859 | 2 | |||
| 20699 | 17025 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1109 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001571.2304 | 2109724.9634 | 37.7729910525637 | -122.43798896281 | (37.7729910525637, -122.43798896281) | 15 | 5 | 11 | 29492 | 9 | |||
| 22585 | 23704 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2119X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6005103.6033 | 2116867.23334 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | 13 | 9 | 1 | 28858 | 27 | |||
| 22613 | 7891 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1187 Franklin St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005998.65959 | 2113925.10155 | 37.7847743933389 | -122.422972499839 | (37.7847743933389, -122.422972499839) | 13 | 9 | 11 | 28858 | 41 | |||
| 23488 | 1442 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 144 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995540.31731 | 2115189.6989 | 37.7876509503315 | -122.459246293031 | (37.7876509503315, -122.459246293031) | 11 | 6 | 1 | 54 | 31 | |||
| 24360 | 26948 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6002746.89171 | 2114446.33864 | 37.7860215531341 | -122.434259812125 | (37.7860215531341, -122.434259812125) | 13 | 9 | 11 | 29490 | 27 | |||
| 24565 | 10586 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1050X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 75 | 3X3 | 6011036.2882597 | 2110765.2479161 | 37.7763811461579 | -122.405321269139 | (37.7763811461579, -122.405321269139) | 14 | 2 | 9 | 28853 | 34 | |||
| 25241 | 8179 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1205X Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002000.37874 | 2111170.93633 | 37.7769857283744 | -122.436608008152 | (37.7769857283744, -122.436608008152) | 15 | 5 | 11 | 29492 | 10 | |||
| 25450 | 17122 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1931 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5997743.85041 | 2109170.01524 | 37.7712489089965 | -122.451188245827 | (37.7712489089965, -122.451188245827) | 15 | 5 | 11 | 29492 | 9 | |||
| 26003 | 20242 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
| 27391 | 6825 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
| 28315 | 6990 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 855 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003337.33996 | 2110322.66362 | 37.7747324668328 | -122.431922464006 | (37.7747324668328, -122.431922464006) | 15 | 9 | 11 | 29492 | 10 | |||
| 28468 | 23821 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Webster St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6003795.89428 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | 7 | 9 | 11 | 29490 | 41 | |||
| 29445 | 26153 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1500 Oakdale Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
| 31660 | 7182 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 857 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6003432.47617 | 2111314.05853 | 37.7774599847744 | -122.43166416476 | (37.7774599847744, -122.43166416476) | 15 | 9 | 11 | 29492 | 10 | |||
| 32727 | 16390 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6006205.61528 | 2114051.709 | 37.7851337020107 | -122.422265498437 | (37.7851337020107, -122.422265498437) | 13 | 9 | 11 | 28858 | 41 | |||
| 32743 | 22671 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1140X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6003752.72615 | 2112639.82159 | 37.7811183481869 | -122.430650941901 | (37.7811183481869, -122.430650941901) | 15 | 9 | 11 | 29490 | 41 | |||
| 32968 | 16997 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 903 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6002604.56537 | 2109869.28932 | 37.7734460452794 | -122.43442485558 | (37.7734460452794, -122.43442485558) | 15 | 5 | 11 | 29492 | 9 | |||
| 33408 | 6246 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1280 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004721.4422 | 2113335.3655 | 37.7830829720913 | -122.427349228935 | (37.7830829720913, -122.427349228935) | 7 | 9 | 11 | 28858 | 41 | |||
| 34217 | 575 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3007 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6008864.65035 | 2102095.7164 | 37.7524549543286 | -122.41222072227 | (37.7524549543286, -122.41222072227) | 2 | 4 | 7 | 28859 | 19 | |||
| 34758 | 15261 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007445.07805 | 2110006.65891 | 37.7740968045009 | -122.417690522857 | (37.7740968045009, -122.417690522857) | 8 | 2 | 9 | 28853 | 19 | |||
| 35689 | 7151 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003574.54383 | 2110759.08622 | 37.775944219835 | -122.431133084506 | (37.775944219835, -122.431133084506) | 7 | 9 | 11 | 29492 | 10 | |||
| 36315 | 4701 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6008961.46783 | 2120321.2947 | 37.8025035109944 | -122.41317456692 | (37.8025035109944, -122.41317456692) | 3 | 1 | 10 | 308 | 23 | |||
| 36964 | 11109 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2022 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6007225.09879 | 2119363.63368 | 37.7997763833106 | -122.419115312272 | (37.7997763833106, -122.419115312272) | 5 | 1 | 1 | 28858 | 32 | |||
| 37080 | 6828 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
| 37194 | 4729 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1075 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6008196.257 | 2120907.29394 | 37.8040695291651 | -122.41586410452 | (37.8040695291651, -122.41586410452) | 5 | 1 | 10 | 308 | 32 | |||
| 37666 | 646 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
| 38327 | 17368 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2308X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005067.32521 | 2117488.78546 | 37.794506778582 | -122.426448444628 | (37.794506778582, -122.426448444628) | 13 | 9 | 1 | 28858 | 27 | |||
| 38667 | 21584 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1499 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005574.52113 | 2114792.70084 | 37.787132663766 | -122.424501615425 | (37.787132663766, -122.424501615425) | 13 | 9 | 1 | 28858 | 41 | |||
| 39074 | 20124 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 924X Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002999.41967 | 2110319.25168 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | 15 | 5 | 11 | 29492 | 10 | |||
| 39117 | 14994 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1459X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016235.7427248 | 2097702.9858463 | 37.7408042749191 | -122.38642376985 | (37.7408042749191, -122.38642376985) | 10 | 3 | 8 | 58 | 1 | |||
| 39319 | 23703 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2119X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005103.6033 | 2116867.23334 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | 13 | 9 | 1 | 28858 | 27 | |||
| 39764 | 11100 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1960 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007273.5320198 | 2119093.4977666 | 37.7990373853425 | -122.418928545127 | (37.7990373853425, -122.418928545127) | 5 | 1 | 10 | 28858 | 32 | |||
| 40269 | 25702 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 06th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6012081.78675 | 2110335.7627 | 37.7752602760543 | -122.401674380603 | (37.7752602760543, -122.401674380603) | 14 | 2 | 9 | 28853 | 34 | |||
| 40655 | 16939 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
| 41017 | 11117 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2054 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6007235.1189832 | 2119374.3616564 | 37.7998064039059 | -122.419081399975 | (37.7998064039059, -122.419081399975) | 5 | 1 | 1 | 28858 | 32 | |||
| 41634 | 13254 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2408 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 45 | 3X3 | 6000832.23006 | 2119380.36917 | 37.7994602521243 | -122.441238147567 | (37.7994602521243, -122.441238147567) | 13 | 9 | 1 | 57 | 17 | ||
| 42234 | 25701 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6012066.85402 | 2110350.08491 | 37.7752987682674 | -122.40172704355 | (37.7752987682674, -122.40172704355) | 14 | 2 | 9 | 28853 | 34 | |||
| 43323 | 23820 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Webster St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6003795.89428 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | 7 | 9 | 11 | 29490 | 41 | |||
| 43589 | 15250 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1450X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007716.15968 | 2110227.06056 | 37.7747172257492 | -122.416768419302 | (37.7747172257492, -122.416768419302) | 8 | 2 | 9 | 28853 | 34 | |||
| 43818 | 24454 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1384 Valencia St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.7508023001764 | -122.420834214589 | (37.7508023001764, -122.420834214589) | 2 | 4 | 5 | 28859 | 19 | |||
| 43860 | 8182 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1218 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6001778.22585 | 2111194.36963 | 37.7770374434445 | -122.437378180533 | (37.7770374434445, -122.437378180533) | 15 | 5 | 11 | 29492 | 41 | |||
| 44695 | 525 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2829 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009855.90033 | 2102163.70478 | 37.7526972066188 | -122.408797595672 | (37.7526972066188, -122.408797595672) | 2 | 4 | 7 | 28859 | 19 | |||
| 44901 | 4596 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
| 45310 | 11177 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2740 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3X3 | Permit Number 769071 | 6006912.1976315 | 2121679.9811894 | 37.8061188596167 | -122.420362567782 | (37.8061188596167, -122.420362567782) | 5 | 1 | 1 | 28858 | 32 | ||
| 45474 | 26944 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6002826.48876 | 2114460.91922 | 37.7860661051899 | -122.433985470782 | (37.7860661051899, -122.433985470782) | 13 | 9 | 11 | 29490 | 27 | |||
| 45836 | 9661 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 112 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006079.13931 | 2110176.88384 | 37.7744872417771 | -122.422427647286 | (37.7744872417771, -122.422427647286) | 7 | 9 | 11 | 28852 | 10 | |||
| 46216 | 6816 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
| 46932 | 17830 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1961 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004561.39396 | 2115345.0767756 | 37.7885920838825 | -122.428046192771 | (37.7885920838825, -122.428046192771) | 13 | 9 | 11 | 28858 | 27 | |||
| 47161 | 18304 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.7683100673499 | -122.407895847634 | (37.7683100673499, -122.407895847634) | 8 | 4 | 8 | 28853 | 19 | |||
| 47614 | 4599 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
| 48251 | 23814 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6003795.89428 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | 7 | 9 | 11 | 29490 | 41 | |||
| 48721 | 9675 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 235 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/1981 12:00:00 AM | 12 | 3X3 | 6005972.11971 | 2110519.21136 | 37.7754211527567 | -122.422822183014 | (37.7754211527567, -122.422822183014) | 7 | 9 | 11 | 28852 | 10 | ||
| 49311 | 8762 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
| 49389 | 11091 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1906 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6007294.23278 | 2118880.01642 | 37.7984523847496 | -122.418841764779 | (37.7984523847496, -122.418841764779) | 5 | 1 | 10 | 28858 | 32 | |||
| 49601 | 16393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 250X Myrtle St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006231.99165 | 2114068.14091 | 37.7851803077551 | -122.422175412097 | (37.7851803077551, -122.422175412097) | 13 | 9 | 11 | 28858 | 41 | |||
| 50702 | 11103 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1995X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007217.8875 | 2119096.40041 | 37.7990422218557 | -122.419121300277 | (37.7990422218557, -122.419121300277) | 5 | 1 | 10 | 28858 | 32 | |||
| 50755 | 7185 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 865 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003457.39592 | 2111275.80383 | 37.7773563593355 | -122.431575227386 | (37.7773563593355, -122.431575227386) | 15 | 9 | 11 | 29492 | 10 | |||
| 50810 | 20244 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
| 50875 | 7183 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 857 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003432.47617 | 2111314.05853 | 37.7774599847744 | -122.43166416476 | (37.7774599847744, -122.43166416476) | 15 | 9 | 11 | 29492 | 10 | |||
| 51362 | 2729 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2250 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002744.1445 | 2114802.6476 | 37.7869997310528 | -122.434294799469 | (37.7869997310528, -122.434294799469) | 13 | 9 | 11 | 29490 | 27 | |||
| 51471 | 20141 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1001 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002903.1358 | 2111776.1473 | 37.7786987467479 | -122.433528357436 | (37.7786987467479, -122.433528357436) | 15 | 9 | 11 | 29490 | 41 | |||
| 51714 | 7156 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 712 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6003631.55189 | 2110917.37527 | 37.7763820727629 | -122.430947178384 | (37.7763820727629, -122.430947178384) | 7 | 9 | 11 | 29492 | 10 | |||
| 51739 | 19375 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390X 06th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6011348.29286 | 2111104.97037 | 37.7773313845055 | -122.404265868127 | (37.7773313845055, -122.404265868127) | 14 | 2 | 9 | 28853 | 34 | |||
| 51742 | 11446 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2191X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005072.64937 | 2117089.85961 | 37.7934117301419 | -122.426401604865 | (37.7934117301419, -122.426401604865) | 13 | 9 | 1 | 28858 | 27 | |||
| 51840 | 15324 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1698X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | 8 | 4 | 9 | 28853 | 19 | |||
| 51996 | 17674 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1015X Pierce St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002359.74374 | 2112046.46454 | 37.7794101245475 | -122.435427501131 | (37.7794101245475, -122.435427501131) | 15 | 5 | 11 | 29490 | 41 | |||
| 52126 | 22281 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4755X 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 18 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 |
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) );