trees
3,709 rows where qSpecies_id = 9 sorted by Fire Prevention Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1005 | 39481 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
| 2927 | 35280 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 4304 | 17630 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 150 Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10M | |||||||||||||
| 6966 | 35281 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 10720 | 39483 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
| 13401 | 35284 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 14355 | 35285 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 15594 | 19769 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
| 16339 | 39482 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
| 17767 | 35283 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 17923 | 19768 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY16 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30ST | |||||||||||||
| 18560 | 19875 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 STAIRWAY33 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
| 1262 | 47855 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1339 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 3 | Permit Number 45614 | 5982734.7831 | 2106002.3859 | 37.7616807275351 | -122.502869846098 | (37.7616807275351, -122.502869846098) | 1 | 8 | 3 | 56 | 35 | |
| 1512 | 177963 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5988967.05933 | 2088996.09626 | 37.7153501871281 | -122.480070526755 | (37.7153501871281, -122.480070526755) | 1 | 8 | 4 | 64 | 14 | ||||
| 1732 | 74552 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2345 Ortega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986706.7381 | 2102298.6623 | 37.7517439532499 | -122.488860374683 | (37.7517439532499, -122.488860374683) | 1 | 8 | 3 | 29491 | 35 | |||
| 1763 | 184039 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984935.4051 | 2103815.5297 | 37.755805317385 | -122.4950976324 | (37.755805317385, -122.4950976324) | 1 | 8 | 3 | 56 | 35 | |||
| 2218 | 210632 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1695 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5993073.70749 | 2104007.38642 | 37.7568051923228 | -122.46696694227 | (37.7568051923228, -122.46696694227) | 1 | 8 | 4 | 56 | 12 | |||
| 2291 | 29222 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
| 2818 | 38377 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3815 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | 2 | Permit Number 40436 | 5982149.2806 | 2102814.4314 | 37.7528930799905 | -122.504658614747 | (37.7528930799905, -122.504658614747) | 1 | 8 | 3 | 56 | 35 | |
| 2981 | 70375 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1590 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983148.8552 | 2104320.0131 | 37.757085733924 | -122.501313312685 | (37.757085733924, -122.501313312685) | 1 | 8 | 3 | 56 | 35 | |||
| 3293 | 74706 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2345 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986691.3356 | 2102298.6623 | 37.7517430543366 | -122.488913637871 | (37.7517430543366, -122.488913637871) | 1 | 8 | 3 | 29491 | 35 | |||
| 3298 | 210771 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 115 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5994196.30129 | 2105955.3306 | 37.7622184734172 | -122.463225970324 | (37.7622184734172, -122.463225970324) | 1 | 5 | 11 | 56 | 12 | |||
| 4541 | 184962 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1990 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983548.4855 | 2101665.8278 | 37.7498215412297 | -122.499735091789 | (37.7498215412297, -122.499735091789) | 1 | 8 | 3 | 29491 | 35 | |||
| 4833 | 75711 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1360 43rd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5982781.2778 | 2105936.6274 | 37.7615029058487 | -122.502704174703 | (37.7615029058487, -122.502704174703) | 1 | 8 | 3 | 56 | 35 | |||
| 5112 | 71219 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2287 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988225.9763 | 2099753.3826 | 37.7448438391255 | -122.483420138524 | (37.7448438391255, -122.483420138524) | 1 | 8 | 3 | 29491 | 35 | |||
| 5421 | 78924 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2355 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988240.3654 | 2099300.0902 | 37.7436000553334 | -122.483337162026 | (37.7436000553334, -122.483337162026) | 1 | 8 | 3 | 29491 | 35 | |||
| 5653 | 215048 | Private 9 | Olea europaea :: Olive Tree 9 | 1719 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782897 | 5990885.18116 | 2103671.34742 | 37.7557559568771 | -122.474511074324 | (37.7557559568771, -122.474511074324) | 1 | 8 | 4 | 56 | 12 | |
| 6173 | 210586 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1677 16th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 5ft | 5991138.28819 | 2103959.43747 | 37.7565616379133 | -122.47365677234 | (37.7565616379133, -122.47365677234) | 1 | 8 | 4 | 56 | 12 | |||
| 6369 | 55285 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1255 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11211 | 5988297.4779 | 2106775.5193 | 37.7641288996273 | -122.483687653384 | (37.7641288996273, -122.483687653384) | 1 | 8 | 3 | 56 | 35 | ||
| 6676 | 70370 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1462 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5983119.2114 | 2105188.9573 | 37.7594698688276 | -122.501480109549 | (37.7594698688276, -122.501480109549) | 1 | 8 | 3 | 56 | 35 | |||
| 7300 | 183627 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1442 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981873.5609 | 2105253.9792 | 37.759575163504 | -122.505792929352 | (37.759575163504, -122.505792929352) | 1 | 8 | 3 | 56 | 35 | |||
| 7416 | 52562 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1267 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 3 | Permit Number 48659 | 5983648.1273 | 2106539.2749 | 37.7632085093228 | -122.49975069135 | (37.7632085093228, -122.49975069135) | 1 | 8 | 3 | 56 | 35 | |
| 7572 | 210820 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1570 07th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994025.69959 | 2104801.19481 | 37.7590396865612 | -122.463732240966 | (37.7590396865612, -122.463732240966) | 1 | 5 | 4 | 56 | 12 | |||
| 8816 | 177939 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989472.35628 | 2089125.29207 | 37.7157342731997 | -122.478333458321 | (37.7157342731997, -122.478333458321) | 1 | 8 | 4 | 64 | 14 | ||||
| 9238 | 177934 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5988635.61259 | 2089280.10032 | 37.7161107276166 | -122.481236924063 | (37.7161107276166, -122.481236924063) | 1 | 8 | 4 | 64 | 14 | ||||
| 9691 | 210624 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5993034.36809 | 2106545.7737 | 37.763772669194 | -122.467287556882 | (37.763772669194, -122.467287556882) | 1 | 8 | 11 | 56 | 12 | |||
| 9713 | 71215 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2143 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5988194.3764 | 2100717.2109 | 37.7474884169564 | -122.483600053104 | (37.7474884169564, -122.483600053104) | 1 | 8 | 3 | 29491 | 35 | |||
| 10318 | 78551 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2255 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982019.5732 | 2099750.385 | 37.7444724345971 | -122.504880128796 | (37.7444724345971, -122.504880128796) | 1 | 8 | 3 | 29491 | 35 | |||
| 10709 | 210631 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1446 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5993378.13325 | 2105628.69584 | 37.7612744523625 | -122.466031944136 | (37.7612744523625, -122.466031944136) | 1 | 8 | 11 | 56 | 12 | |||
| 10975 | 154534 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1391 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 2ft | 5993623.67748 | 2106028.43629 | 37.7623861978859 | -122.465211753439 | (37.7623861978859, -122.465211753439) | 1 | 8 | 11 | 56 | 12 | |||
| 11049 | 74796 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2338 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983322.3378 | 2099244.9576 | 37.7431612263111 | -122.500338147126 | (37.7431612263111, -122.500338147126) | 1 | 8 | 3 | 29491 | 35 | |||
| 11877 | 210668 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 220 Ulloa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996107.59871 | 2098932.75932 | 37.7430461792465 | -122.456107811121 | (37.7430461792465, -122.456107811121) | 1 | 8 | 4 | 59 | 40 | |||
| 12433 | 210785 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 228 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5993497.42043 | 2103949.45109 | 37.7566705638043 | -122.465497389788 | (37.7566705638043, -122.465497389788) | 1 | 8 | 4 | 56 | 12 | |||
| 14239 | 210646 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1330 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991878.87557 | 2098447.75168 | 37.7414708368091 | -122.470694133953 | (37.7414708368091, -122.470694133953) | 1 | 8 | 4 | 29491 | 40 | |||
| 14327 | 70383 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1465 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5982453.54 | 2105161.4635 | 37.759355260686 | -122.503780254641 | (37.759355260686, -122.503780254641) | 1 | 8 | 3 | 56 | 35 | |||
| 14671 | 74991 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2345 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986666.6916 | 2102296.6086 | 37.7517359771217 | -122.488998708008 | (37.7517359771217, -122.488998708008) | 1 | 8 | 3 | 29491 | 35 | |||
| 15933 | 75880 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1360 43rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5982784.1317 | 2105860.9992 | 37.7612954200169 | -122.502688706201 | (37.7612954200169, -122.502688706201) | 1 | 8 | 3 | 56 | 35 | |||
| 16334 | 70226 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1466 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5982190.0408 | 2105127.5478 | 37.759246640966 | -122.504689034952 | (37.759246640966, -122.504689034952) | 1 | 8 | 3 | 56 | 35 | |||
| 17500 | 37109 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301X 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981799.7427 | 2106129.159 | 37.7619738119048 | -122.506113117253 | (37.7619738119048, -122.506113117253) | 1 | 8 | 3 | 56 | 35 |
| 17854 | 821 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1409 45th Ave | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 04/02/2015 05:34:00 PM | 3 | 3X3 | 5982132.645 | 2105492.3927 | 37.7602450246853 | -122.504914569939 | (37.7602450246853, -122.504914569939) | 1 | 8 | 3 | 56 | 35 | ||
| 18179 | 74854 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2345 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986677.9867 | 2102297.122 | 37.7517380460087 | -122.48895968631 | (37.7517380460087, -122.48895968631) | 1 | 8 | 3 | 29491 | 35 | |||
| 18616 | 184963 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1990 41st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5983546.455 | 2101707.1153 | 37.7499347861229 | -122.499745164476 | (37.7499347861229, -122.499745164476) | 1 | 8 | 3 | 29491 | 35 | |||
| 18920 | 47271 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1838 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 9 | Permit Number 45212 | 5988771.9103 | 2105832.039 | 37.7615659640444 | -122.48197762946 | (37.7615659640444, -122.48197762946) | 1 | 8 | 3 | 56 | 35 | |
| 19237 | 74938 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2340 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983322.8922 | 2099223.3332 | 37.7431018841787 | -122.500334631769 | (37.7431018841787, -122.500334631769) | 1 | 8 | 3 | 29491 | 35 | |||
| 19401 | 45516 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2975 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | Permit Number 44280 | 5988544.38188689 | 2095413.25132317 | 37.7329454972405 | -122.482001286035 | (37.7329454972405, -122.482001286035) | 1 | 8 | 4 | 64 | 35 | ||
| 19520 | 37110 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301X 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981797.2694 | 2106191.6975 | 37.7621453791042 | -122.506126308526 | (37.7621453791042, -122.506126308526) | 1 | 8 | 3 | 56 | 35 |
| 19538 | 210662 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2638 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991142.54201 | 2097448.3857 | 37.7386842254032 | -122.473167230904 | (37.7386842254032, -122.473167230904) | 1 | 8 | 4 | 29491 | 40 | |||
| 20256 | 32289 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1459 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | 7 | Permit Number 36871 | 5991131.73942 | 2105485.99284 | 37.7607527754302 | -122.473790782119 | (37.7607527754302, -122.473790782119) | 1 | 8 | 4 | 56 | 12 | ||
| 20376 | 55284 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1250 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11210 | 5988338.8364 | 2106796.1986 | 37.7641880866728 | -122.483546124231 | (37.7641880866728, -122.483546124231) | 1 | 8 | 3 | 56 | 35 | ||
| 20808 | 177944 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Josepha Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5989684.83075 | 2089660.83958 | 37.717217086174 | -122.477638179862 | (37.717217086174, -122.477638179862) | 1 | 8 | 4 | 64 | 14 | ||||
| 20989 | 185356 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2601 Sunset Blvd | 81 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985014.265 | 2096945.9513 | 37.7369479403483 | -122.49431857261 | (37.7369479403483, -122.49431857261) | 1 | 8 | 3 | 29491 | 35 | |||
| 21144 | 50246 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1287 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 0 | Permit Number 46951 | 5985199.39967199 | 2106457.48369728 | 37.7630748403476 | -122.494379405671 | (37.7630748403476, -122.494379405671) | 1 | 8 | 3 | 56 | 35 | |
| 21285 | 49944 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2514@ ULLOA 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | 5 | Permit Number 46702 | 5986465.7143 | 2098114.3677 | 37.7402409353633 | -122.489386220661 | (37.7402409353633, -122.489386220661) | 1 | 8 | 3 | 29491 | 35 | |
| 21368 | 183749 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2275 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5987605.0718 | 2099820.1671 | 37.7449910546775 | -122.485571982913 | (37.7449910546775, -122.485571982913) | 1 | 8 | 3 | 29491 | 35 | |||
| 21401 | 55292 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1275 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11218 | 5988302.8392 | 2106643.7849 | 37.763767505067 | -122.483659451396 | (37.763767505067, -122.483659451396) | 1 | 8 | 3 | 56 | 35 | ||
| 21982 | 210773 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 530 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992612.70871 | 2103920.27322 | 37.7565393833141 | -122.468554894112 | (37.7565393833141, -122.468554894112) | 1 | 8 | 4 | 56 | 12 | |||
| 22242 | 37108 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301X 46th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981801.156 | 2106110.4328 | 37.7619224783225 | -122.506106840747 | (37.7619224783225, -122.506106840747) | 1 | 8 | 3 | 56 | 35 |
| 22873 | 92250 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1418 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52699 | 5985588.7674 | 2105529.3375 | 37.7605491882923 | -122.492964362242 | (37.7605491882923, -122.492964362242) | 1 | 8 | 3 | 56 | 35 | |
| 22883 | 185266 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2301 Vicente St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 0ft | 5985748.3724 | 2097496.5905 | 37.7385027823228 | -122.491820997516 | (37.7385027823228, -122.491820997516) | 1 | 8 | 3 | 29491 | 35 | |||
| 23521 | 92331 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2539 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52763 | 5987045.4336 | 2097971.4347 | 37.7398823039806 | -122.487371313991 | (37.7398823039806, -122.487371313991) | 1 | 8 | 3 | 29491 | 35 |
| 23527 | 184026 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1600 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984920.3345 | 2103785.5463 | 37.7557221089671 | -122.495147539697 | (37.7557221089671, -122.495147539697) | 1 | 8 | 3 | 56 | 35 | |||
| 24067 | 43048 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2159 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 8 | Permit Number 42902 | 5983545.7781 | 2100465.2765 | 37.7465249999307 | -122.499655734442 | (37.7465249999307, -122.499655734442) | 1 | 8 | 3 | 29491 | 35 | |
| 24590 | 45541 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3300 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 4 | Permit Number 44296 | 5988715.44051 | 2095267.29581 | 37.7325546882288 | -122.481399213927 | (37.7325546882288, -122.481399213927) | 1 | 8 | 4 | 64 | 35 | |
| 24648 | 210641 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2120 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990713.89113 | 2100926.43546 | 37.7482092230825 | -122.47490309242 | (37.7482092230825, -122.47490309242) | 1 | 8 | 4 | 29491 | 40 | |||
| 25509 | 210810 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 481 Dewey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994793.05822 | 2100026.653 | 37.7459741955468 | -122.460732360732 | (37.7459741955468, -122.460732360732) | 1 | 8 | 4 | 59 | 40 | |||
| 26448 | 210827 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 62 Castenada Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5994427.70394 | 2101488.5443 | 37.7499671521736 | -122.46210169544 | (37.7499671521736, -122.46210169544) | 1 | 8 | 4 | 29491 | 40 | |||
| 27806 | 210640 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 439 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993473.81307 | 2105251.38351 | 37.7602439705117 | -122.465673617351 | (37.7602439705117, -122.465673617351) | 1 | 8 | 4 | 56 | 12 | |||
| 28195 | 177938 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5989480.91989 | 2089050.18574 | 37.7155285469807 | -122.478298370392 | (37.7155285469807, -122.478298370392) | 1 | 8 | 4 | 64 | 14 | ||||
| 28823 | 186299 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1800 Sunset Blvd | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985021.1385 | 2102711.497 | 37.7527789669048 | -122.494719750937 | (37.7527789669048, -122.494719750937) | 1 | 8 | 3 | 56 | 35 | |||
| 29524 | 210625 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1364 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5992433.16935 | 2106174.82283 | 37.7627194119902 | -122.469339897922 | (37.7627194119902, -122.469339897922) | 1 | 8 | 11 | 56 | 12 | |||
| 29640 | 210639 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 531 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993152.88121 | 2105240.56396 | 37.7601957461608 | -122.4667827737 | (37.7601957461608, -122.4667827737) | 1 | 8 | 4 | 56 | 12 | |||
| 30265 | 38339 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1506 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 6 | Permit Number 40406 | 5982199.9382 | 2104810.9773 | 37.7583780105423 | -122.504631350136 | (37.7583780105423, -122.504631350136) | 1 | 8 | 3 | 56 | 35 | |
| 31762 | 177953 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989426.93386 | 2089569.48868 | 37.7169512897353 | -122.478522921221 | (37.7169512897353, -122.478522921221) | 1 | 8 | 4 | 64 | 14 | ||||
| 32285 | 39796 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1920 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
| 32958 | 210770 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1407 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5994247.24825 | 2105911.89788 | 37.7621021533037 | -122.463046614021 | (37.7621021533037, -122.463046614021) | 1 | 5 | 11 | 56 | 12 | |||
| 33873 | 182044 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1334 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 0ft | 5987739.7617 | 2106184.8282 | 37.7624745441388 | -122.485573255158 | (37.7624745441388, -122.485573255158) | 1 | 8 | 3 | 56 | 35 | |||
| 34484 | 210634 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1836 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993775.61999 | 2102996.13103 | 37.7540690337611 | -122.464466066177 | (37.7540690337611, -122.464466066177) | 1 | 8 | 4 | 56 | 12 | |||
| 34660 | 210623 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1362 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993046.19691 | 2106186.95527 | 37.7627881309967 | -122.467220553797 | (37.7627881309967, -122.467220553797) | 1 | 8 | 11 | 56 | 12 | |||
| 35090 | 184274 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1503 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5981845.7185 | 2104811.6648 | 37.7583590554552 | -122.50585642835 | (37.7583590554552, -122.50585642835) | 1 | 8 | 3 | 56 | 35 | |||
| 35511 | 820 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1407 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2015 05:29:00 PM | 3 | 3X3 | 5982131.0395 | 2105513.2639 | 37.760302236597 | -122.504921669151 | (37.760302236597, -122.504921669151) | 1 | 8 | 3 | 56 | 35 | ||
| 37103 | 44815 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1491 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52891 | 5986181.0148 | 2105126.7269 | 37.7594783482199 | -122.49088645096 | (37.7594783482199, -122.49088645096) | 1 | 8 | 3 | 56 | 35 | |
| 37470 | 182026 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2090 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989004.7845 | 2106517.7947 | 37.7634624040762 | -122.481222439805 | (37.7634624040762, -122.481222439805) | 1 | 8 | 3 | 56 | 35 | |||
| 38850 | 37193 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1726 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/1998 12:00:00 AM | Permit Number 39760 | 5986905.42853407 | 2103505.82529925 | 37.7550700890109 | -122.488261987916 | (37.7550700890109, -122.488261987916) | 1 | 8 | 3 | 56 | 35 | ||
| 39938 | 83992 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1682 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51096 | 5984098.9069 | 2103728.8955 | 37.7555184368042 | -122.497984070914 | (37.7555184368042, -122.497984070914) | 1 | 8 | 3 | 56 | 35 | |
| 40604 | 210615 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1387 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5994243.35697 | 2106080.49784 | 37.7625648608104 | -122.463072305837 | (37.7625648608104, -122.463072305837) | 1 | 5 | 11 | 56 | 12 | |||
| 41216 | 210818 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1570 07th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994023.38515 | 2104893.67233 | 37.7592934725235 | -122.463746957456 | (37.7592934725235, -122.463746957456) | 1 | 5 | 4 | 56 | 12 | |||
| 41425 | 210815 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 472 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994764.41105 | 2100081.22837 | 37.746122397545 | -122.460835372654 | (37.746122397545, -122.460835372654) | 1 | 8 | 4 | 29491 | 40 | |||
| 42056 | 210587 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1455 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5991455.59144 | 2105520.54641 | 37.7608664020776 | -122.472673253082 | (37.7608664020776, -122.472673253082) | 1 | 8 | 4 | 56 | 12 | |||
| 42337 | 210825 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 62 Castenada Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5994426.35188 | 2101525.71618 | 37.750069138884 | -122.462109066296 | (37.750069138884, -122.462109066296) | 1 | 8 | 4 | 29491 | 40 | |||
| 43142 | 181767 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1250 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987102.8924 | 2106769.7073 | 37.7640433336272 | -122.487818896835 | (37.7640433336272, -122.487818896835) | 1 | 8 | 3 | 56 | 35 |
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) );