trees
340 rows where Police Districts = 3 and qSpecies_id = 8 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1530 | 191101 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012369.93883 | 2101402.46492 | 37.7507475020033 | -122.400050093052 | (37.7507475020033, -122.400050093052) | 10 | 3 | 8 | 28856 | 1 | |||
1997 | 61779 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2227 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1985 12:00:00 AM | 9 | Permit Number 21800 | 6011831.44367 | 2102306.03776 | 37.7531984774519 | -122.401975779864 | (37.7531984774519, -122.401975779864) | 10 | 3 | 8 | 28856 | 29 | |
4634 | 61780 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2127 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1985 12:00:00 AM | 9 | Permit Number 21802 | 6012087.28443 | 2102320.53166 | 37.7532525500908 | -122.401092043975 | (37.7532525500908, -122.401092043975) | 10 | 3 | 8 | 28856 | 29 | |
6046 | 81390 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1588 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6015103.68734 | 2101191.55999 | 37.750320442739 | -122.390581737352 | (37.750320442739, -122.390581737352) | 10 | 3 | 8 | 28856 | 1 | |||
9764 | 150815 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 640 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013813.37874 | 2104087.70708 | 37.7582009725247 | -122.395246594574 | (37.7582009725247, -122.395246594574) | 10 | 3 | 8 | 28856 | 29 | |||
10433 | 189238 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2126 24th St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6012108.67622 | 2102369.63804 | 37.75338857883 | -122.401021516451 | (37.75338857883, -122.401021516451) | 10 | 3 | 8 | 28856 | 29 | |||
11137 | 46998 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
12361 | 61778 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2219 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1985 12:00:00 AM | 13 | Permit Number 21799 | 6011858.65617 | 2102307.02304 | 37.7532027015499 | -122.401881742259 | (37.7532027015499, -122.401881742259) | 10 | 3 | 8 | 28856 | 29 | |
15768 | 61783 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2104 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1985 12:00:00 AM | 13 | Permit Number 21805 | 6012173.04745 | 2102374.48428 | 37.7534054761945 | -122.400799246287 | (37.7534054761945, -122.400799246287) | 10 | 3 | 8 | 28856 | 29 | |
16058 | 111561 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1498x Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779654 | 6011715.78319 | 2101470.38867 | 37.7508975116216 | -122.402317008737 | (37.7508975116216, -122.402317008737) | 10 | 3 | 8 | 28856 | 29 | |
19092 | 150813 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25 Sierra St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013747.19893 | 2104113.81693 | 37.758268983752 | -122.395477303948 | (37.758268983752, -122.395477303948) | 10 | 3 | 8 | 28856 | 29 | |||
19307 | 191107 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2021 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012536.97765 | 2101462.04256 | 37.7509204011789 | -122.399476636765 | (37.7509204011789, -122.399476636765) | 10 | 3 | 8 | 28856 | 1 | |||
19885 | 191110 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2251 24th St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6011791.4986 | 2102301.92631 | 37.7531849588319 | -122.40211362974 | (37.7531849588319, -122.40211362974) | 10 | 3 | 8 | 28856 | 29 | |||
23656 | 191084 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6014440.03961 | 2105781.9689 | 37.7628878793072 | -122.393197865211 | (37.7628878793072, -122.393197865211) | 14 | 3 | 8 | 28856 | 29 | ||||
31011 | 189240 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6013877.57271 | 2103955.2138 | 37.7578407445781 | -122.39501530244 | (37.7578407445781, -122.39501530244) | 10 | 3 | 8 | 28856 | 29 | |||
33794 | 191086 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6014399.78897 | 2105779.8886 | 37.762879931094 | -122.393336933676 | (37.762879931094, -122.393336933676) | 14 | 3 | 8 | 28856 | 29 | |||
36881 | 46985 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | 5 | Permit Number 44999 | 6012611.41785 | 2101473.70376 | 37.7509565692018 | -122.399220032275 | (37.7509565692018, -122.399220032275) | 10 | 3 | 8 | 28856 | 1 | ||
37859 | 46993 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
38276 | 52807 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
42964 | 52803 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 4 | Permit Number 48835 | 6013662.91964 | 2104110.04081 | 37.7582539273014 | -122.395768516112 | (37.7582539273014, -122.395768516112) | 10 | 3 | 8 | 28856 | 29 | ||
44374 | 191081 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015467.86658 | 2102506.20441 | 37.7539503763268 | -122.389414166444 | (37.7539503763268, -122.389414166444) | 10 | 3 | 8 | 28856 | 29 | |||
44433 | 94516 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1106X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 08/27/2010 12:00:00 AM | 2 | Permit Number 53703 | 6012787.7377 | 2102360.94736 | 37.7534025731789 | -122.398672553793 | (37.7534025731789, -122.398672553793) | 10 | 3 | 8 | 28856 | 29 | ||
44482 | 191104 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2031 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012452.22687 | 2101435.1702 | 37.7508418912642 | -122.399767828221 | (37.7508418912642, -122.399767828221) | 10 | 3 | 8 | 28856 | 1 | |||
45437 | 111562 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1498x Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011716.74502 | 2101442.02185 | 37.7508196762016 | -122.402311688344 | (37.7508196762016, -122.402311688344) | 10 | 3 | 8 | 28856 | 29 | |||
46308 | 191085 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6014420.63086 | 2105780.43179 | 37.762882580487 | -122.393264886285 | (37.762882580487, -122.393264886285) | 14 | 3 | 8 | 28856 | 29 | ||||
47596 | 189239 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 670 Texas St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6013865.85822 | 2103972.02889 | 37.7578862637531 | -122.39505699409 | (37.7578862637531, -122.39505699409) | 10 | 3 | 8 | 28856 | 29 | |||
47946 | 46990 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
50221 | 191111 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2251 24th St | 4 | : | Tree | Private 2 | 11 | Width 4ft | 6011810.68033 | 2102303.0748 | 37.7531891829555 | -122.402047375812 | (37.7531891829555, -122.402047375812) | 10 | 3 | 8 | 28856 | 29 | |||
52671 | 43032 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2111 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | 8 | Permit Number 42893 | 6012270.45394 | 2101364.96859 | 37.7506389979096 | -122.400391489185 | (37.7506389979096, -122.400391489185) | 10 | 3 | 8 | 28856 | 1 | ||
54558 | 102355 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012524.1 | 2106651 | 37.7651674211522 | -122.399885503722 | (37.7651674211522, -122.399885503722) | 14 | 3 | 8 | 28856 | 20 | |||||
55194 | 191103 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012409.65437 | 2101419.97094 | 37.7507977840112 | -122.399913981553 | (37.7507977840112, -122.399913981553) | 10 | 3 | 8 | 28856 | 1 | |||
55558 | 191092 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 299 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014058.4688 | 2105768.40922 | 37.7628294422497 | -122.394516646351 | (37.7628294422497, -122.394516646351) | 14 | 3 | 8 | 28856 | 29 | |||
56904 | 191106 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2021 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012517.84627 | 2101457.29069 | 37.7509062872025 | -122.39954246174 | (37.7509062872025, -122.39954246174) | 10 | 3 | 8 | 28856 | 1 | |||
58874 | 43033 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2111 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | 6 | Permit Number 42893 | 6012236.17829 | 2101361.16711 | 37.7506266484242 | -122.400509750935 | (37.7506266484242, -122.400509750935) | 10 | 3 | 8 | 28856 | 1 | ||
60769 | 52801 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 1 | Permit Number 48835 | 6013622.04592 | 2104108.35581 | 37.7582470267928 | -122.395909758227 | (37.7582470267928, -122.395909758227) | 10 | 3 | 8 | 28856 | 29 | ||
61893 | 191099 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012326.74085 | 2101388.24241 | 37.7507060414673 | -122.4001984776 | (37.7507060414673, -122.4001984776) | 10 | 3 | 8 | 28856 | 1 | |||
64054 | 52809 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
68640 | 52808 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
73029 | 46994 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
74782 | 191109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2251 24th St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6011772.01455 | 2102301.09153 | 37.7531815791754 | -122.402180951204 | (37.7531815791754, -122.402180951204) | 10 | 3 | 8 | 28856 | 29 | |||
75361 | 46996 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
75967 | 82925 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 733 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52380 | 6012148.34936451 | 2104990.04920575 | 37.7605858648735 | -122.401068426273 | (37.7605858648735, -122.401068426273) | 10 | 3 | 8 | 28856 | 29 | ||
78139 | 106892 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 629 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2014 12:00:00 AM | 1 | Permit Number 773229 | 6014439.75654 | 2104200.5982 | 37.7585457626959 | -122.393088190163 | (37.7585457626959, -122.393088190163) | 10 | 3 | 8 | 28856 | 29 | ||
79507 | 94172 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53593 | 6012553 | 2102835 | 37.7546911374705 | -122.399517610991 | (37.7546911374705, -122.399517610991) | 10 | 3 | 8 | 28856 | 29 | ||
79618 | 61781 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2121 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/04/1985 12:00:00 AM | 12 | Permit Number 21856 | 6012125.65384 | 2102323.13714 | 37.7532618445577 | -122.400959536972 | (37.7532618445577, -122.400959536972) | 10 | 3 | 8 | 28856 | 29 | |
79628 | 68421 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2207 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1993 12:00:00 AM | 9 | Permit Number 32265 | 6011906.60073 | 2102309.43328 | 37.7532119951541 | -122.401716108723 | (37.7532119951541, -122.401716108723) | 10 | 3 | 8 | 28856 | 29 | ||
86145 | 46992 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
89001 | 102356 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012524.1 | 2106651 | 37.7651674211522 | -122.399885503722 | (37.7651674211522, -122.399885503722) | 14 | 3 | 8 | 28856 | 20 | |||||
89435 | 191102 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012387.52299 | 2101410.46082 | 37.7507704374056 | -122.399989846558 | (37.7507704374056, -122.399989846558) | 10 | 3 | 8 | 28856 | 1 | |||
93543 | 46988 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
94288 | 68425 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2209 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | 10 | Permit Number 32274 | 6011881.53796 | 2102307.78883 | 37.7532060812206 | -122.401802665774 | (37.7532060812206, -122.401802665774) | 10 | 3 | 8 | 28856 | 29 | ||
96520 | 191096 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2221 26th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011887.54449 | 2101344.68629 | 37.7505619466985 | -122.401714203957 | (37.7505619466985, -122.401714203957) | 10 | 3 | 8 | 28856 | 1 | |||
97130 | 189241 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6013889.32799 | 2103940.39875 | 37.7578007193328 | -122.394973609851 | (37.7578007193328, -122.394973609851) | 10 | 3 | 8 | 28856 | 29 | |||
102488 | 94173 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53593 | 6012553 | 2102835 | 37.7546911374705 | -122.399517610991 | (37.7546911374705, -122.399517610991) | 10 | 3 | 8 | 28856 | 29 | ||
102516 | 37990 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 1 | Permit Number 44744 | 6013820.84604 | 2104031.24845 | 37.758046364659 | -122.395216814417 | (37.758046364659, -122.395216814417) | 10 | 3 | 8 | 28856 | 29 | |
103332 | 49838 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 630 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781214 | 6010947.62469 | 2105199.05587 | 37.7610926949039 | -122.405235926615 | (37.7610926949039, -122.405235926615) | 10 | 3 | 8 | 28856 | 29 |
106598 | 191100 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012349.12966 | 2101394.53419 | 37.7507245656958 | -122.400121496519 | (37.7507245656958, -122.400121496519) | 10 | 3 | 8 | 28856 | 1 | |||
106707 | 46991 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
108786 | 191082 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015413.33991 | 2102503.20842 | 37.7539391266996 | -122.389602524941 | (37.7539391266996, -122.389602524941) | 10 | 3 | 8 | 28856 | 29 | |||
110605 | 46987 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2010 12:00:00 AM | 5 | Permit Number 53455 | 6012596.87958 | 2101472.71362 | 37.7509530402521 | -122.39927023785 | (37.7509530402521, -122.39927023785) | 10 | 3 | 8 | 28856 | 1 | ||
112415 | 46997 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
114813 | 191095 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1951 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012592.46534 | 2102823.04083 | 37.7546604998905 | -122.399380288765 | (37.7546604998905, -122.399380288765) | 10 | 3 | 8 | 28856 | 29 | |||
115638 | 61795 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2124 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1985 12:00:00 AM | Permit Number 21818 | 6012164.19544903 | 2102373.44678404 | 37.7534021337144 | -122.400829785677 | (37.7534021337144, -122.400829785677) | 10 | 3 | 8 | 28856 | 29 | ||
115858 | 52802 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 3 | Permit Number 48835 | 6013642.25558 | 2104109.31738 | 37.7582507913691 | -122.395839931279 | (37.7582507913691, -122.395839931279) | 10 | 3 | 8 | 28856 | 29 | ||
118388 | 191088 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 01st St | 19 | : Yard | Tree | Private 2 | 18 | 6014455.34951 | 2105889.69248 | 37.7631845152826 | -122.393152451232 | (37.7631845152826, -122.393152451232) | 14 | 3 | 8 | 28856 | 29 | ||||
120511 | 114551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 815 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 2 | Permit Number 777069 | 6011882.52063 | 2104552.93824 | 37.759370822322 | -122.401957083855 | (37.759370822322, -122.401957083855) | 10 | 3 | 8 | 28856 | 29 | ||
124140 | 191087 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6014377.05875 | 2105781.79588 | 37.762883905197 | -122.393415683687 | (37.762883905197, -122.393415683687) | 14 | 3 | 8 | 28856 | 29 | ||||
126830 | 43031 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2121 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | 5 | Permit Number 42892 | 6012197.347 | 2101360.5481 | 37.7506227831148 | -122.400643990055 | (37.7506227831148, -122.400643990055) | 10 | 3 | 8 | 28856 | 1 | ||
138524 | 189243 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6013912.25282 | 2103910.20868 | 37.757719098672 | -122.3948922113 | (37.757719098672, -122.3948922113) | 10 | 3 | 8 | 28856 | 29 | |||
139174 | 189244 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780809 | 6013923.09543 | 2103892.83973 | 37.7576720101792 | -122.394853496397 | (37.7576720101792, -122.394853496397) | 10 | 3 | 8 | 28856 | 29 | |
140307 | 191091 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 150 Wisconsin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012554.29768 | 2106630.73656 | 37.7651134657424 | -122.399779633617 | (37.7651134657424, -122.399779633617) | 14 | 3 | 8 | 28856 | 20 | |||
140396 | 66887 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1324 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1991 12:00:00 AM | 9 | Permit Number 30200 | 6013938.0874 | 2104806.5934 | 37.7601818129701 | -122.394865641745 | (37.7601818129701, -122.394865641745) | 10 | 3 | 8 | 28856 | 29 | ||
140946 | 43029 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2131 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | 6 | Permit Number 42891 | 6012151.06584 | 2101359.39792 | 37.7506170436447 | -122.400803954262 | (37.7506170436447, -122.400803954262) | 10 | 3 | 8 | 28856 | 1 | ||
141839 | 191089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 150 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012552.52179 | 2106660.8958 | 37.7651961772892 | -122.399787893906 | (37.7651961772892, -122.399787893906) | 14 | 3 | 8 | 28856 | 20 | |||
141928 | 191093 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1951 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012569.60579 | 2102821.43848 | 37.7546548260739 | -122.399459231268 | (37.7546548260739, -122.399459231268) | 10 | 3 | 8 | 28856 | 29 | |||
145145 | 43030 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2121 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | 6 | Permit Number 42892 | 6012174.28913 | 2101359.6022 | 37.7506188998561 | -122.400723660095 | (37.7506188998561, -122.400723660095) | 10 | 3 | 8 | 28856 | 1 | ||
146226 | 52806 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
146350 | 191094 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1951 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6012582.07272 | 2102822.21844 | 37.7546576625444 | -122.399416171744 | (37.7546576625444, -122.399416171744) | 10 | 3 | 8 | 28856 | 29 | |||
148788 | 46995 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
152105 | 46999 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2010 12:00:00 AM | 5 | Permit Number 53455 | 6012582.01898 | 2101471.73036 | 37.7509495122074 | -122.399321558558 | (37.7509495122074, -122.399321558558) | 10 | 3 | 8 | 28856 | 1 | ||
152232 | 189242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6013899.94699 | 2103926.17826 | 37.7577622634227 | -122.394935888703 | (37.7577622634227, -122.394935888703) | 10 | 3 | 8 | 28856 | 29 | |||
154897 | 111560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1498x Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6011715.03072 | 2101496.45297 | 37.7509690365089 | -122.402321443274 | (37.7509690365089, -122.402321443274) | 10 | 3 | 8 | 28856 | 29 | |||
161565 | 191090 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 150 Wisconsin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012554.60334 | 2106645.79178 | 37.765154821059 | -122.399779633629 | (37.765154821059, -122.399779633629) | 14 | 3 | 8 | 28856 | 20 | |||
164084 | 191108 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2251 24th St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6011748.82992 | 2102300.63955 | 37.753179044 | -122.402261096995 | (37.753179044, -122.402261096995) | 10 | 3 | 8 | 28856 | 29 | |||
164537 | 52805 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 3 | Permit Number 48835 | 6013721.70041 | 2104112.27723 | 37.758263337788 | -122.395565381751 | (37.758263337788, -122.395565381751) | 10 | 3 | 8 | 28856 | 29 | ||
164702 | 37992 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 Texas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40210 | 6013843.22598 | 2104002.49869 | 37.7579686686468 | -122.39513740069 | (37.7579686686468, -122.39513740069) | 10 | 3 | 8 | 28856 | 29 | ||
164893 | 67391 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1992 12:00:00 AM | Permit Number 30888 | 6012577.17209413 | 2106598.24360902 | 37.7650255224957 | -122.399698234444 | (37.7650255224957, -122.399698234444) | 14 | 3 | 8 | 28856 | 20 | ||
167748 | 46986 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2010 12:00:00 AM | 4 | Permit Number 53455 | 6012562.93976 | 2101469.54753 | 37.7509424552537 | -122.399387383547 | (37.7509424552537, -122.399387383547) | 10 | 3 | 8 | 28856 | 1 | ||
169572 | 94174 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Carolina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53593 | 6012553 | 2102835 | 37.7546911374705 | -122.399517610991 | (37.7546911374705, -122.399517610991) | 10 | 3 | 8 | 28856 | 29 | ||
170486 | 95807 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10993 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767551 | 6014326.8 | 2102083.7 | 37.752726939242 | -122.393330710599 | (37.752726939242, -122.393330710599) | 10 | 3 | 8 | 28856 | 29 | |
175743 | 191097 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012299.11366 | 2101378.20136 | 37.7506769304023 | -122.400293310212 | (37.7506769304023, -122.400293310212) | 10 | 3 | 8 | 28856 | 1 | |||
176741 | 43028 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2131 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | Permit Number 42891 | 6012232.74483127 | 2101350.9845752 | 37.7505984979091 | -122.400520909002 | (37.7505984979091, -122.400520909002) | 10 | 3 | 8 | 28856 | 1 | |||
177312 | 37991 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | 4 | Permit Number 40210 | 6013832.0389 | 2104017.01631 | 37.7580079087535 | -122.395177107536 | (37.7580079087535, -122.395177107536) | 10 | 3 | 8 | 28856 | 29 | ||
178055 | 191098 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6012312.12427 | 2101383.39868 | 37.75069192661 | -122.400248683139 | (37.75069192661, -122.400248683139) | 10 | 3 | 8 | 28856 | 1 | |||
178699 | 191105 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2031 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6012471.08809 | 2101442.49761 | 37.7508630621826 | -122.39970311841 | (37.7508630621826, -122.39970311841) | 10 | 3 | 8 | 28856 | 1 | |||
180956 | 191112 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2121 24th St | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6012137.40992 | 2102323.82129 | 37.7532643788521 | -122.400918929861 | (37.7532643788521, -122.400918929861) | 10 | 3 | 8 | 28856 | 29 | |||
186400 | 191083 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6014452.20409 | 2105784.61715 | 37.7628958266015 | -122.39315597749 | (37.7628958266015, -122.39315597749) | 14 | 3 | 8 | 28856 | 29 | ||||
188224 | 46989 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
190222 | 52804 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 4 | Permit Number 48835 | 6013685.88605 | 2104111.17484 | 37.758258318682 | -122.395689167119 | (37.758258318682, -122.395689167119) | 10 | 3 | 8 | 28856 | 29 | ||
194119 | 191080 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015525.99309 | 2102510.04982 | 37.7539641575461 | -122.389213417992 | (37.7539641575461, -122.389213417992) | 10 | 3 | 8 | 28856 | 29 |
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) );