trees
3,709 rows where qSpecies_id = 9 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||||||||
| 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 | ||||||||||||||
| 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 | ||||||||||||||
| 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 | ||||||||||||||
| 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 | |||||||||||||
| 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 | |||||||||||||
| 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 | |||||||||||||
| 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 | ||||
| 91884 | 177932 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988789.67714 | 2089358.25698 | 37.7163342819918 | -122.480710128176 | (37.7163342819918, -122.480710128176) | 1 | 8 | 4 | 64 | 14 | ||||
| 92388 | 177930 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5988862.76325 | 2089422.54432 | 37.7165150466091 | -122.480462212988 | (37.7165150466091, -122.480462212988) | 1 | 8 | 4 | 64 | 14 | ||||
| 117932 | 177923 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5988561.02848 | 2089156.81478 | 37.7157678799561 | -122.481485695422 | (37.7157678799561, -122.481485695422) | 1 | 8 | 4 | 64 | 14 | ||||
| 118117 | 177928 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5988855.6313 | 2089468.65527 | 37.7166412412847 | -122.480490237638 | (37.7166412412847, -122.480490237638) | 1 | 8 | 4 | 64 | 14 | ||||
| 139082 | 177926 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5988935.7978 | 2089543.35128 | 37.7168509964648 | -122.480218609114 | (37.7168509964648, -122.480218609114) | 1 | 8 | 4 | 64 | 14 | ||||
| 141505 | 177927 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 5988959.91996 | 2089504.3338 | 37.716745265857 | -122.48013237763 | (37.716745265857, -122.48013237763) | 1 | 8 | 4 | 64 | 14 | ||||
| 143228 | 177933 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5988685.34824 | 2089320.71628 | 37.7162251402652 | -122.481067988213 | (37.7162251402652, -122.481067988213) | 1 | 8 | 4 | 64 | 14 | ||||
| 177831 | 177929 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5988839.75679 | 2089455.3276 | 37.7166037242653 | -122.480544132207 | (37.7166037242653, -122.480544132207) | 1 | 8 | 4 | 64 | 14 | ||||
| 192389 | 177931 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988808.76092 | 2089375.86435 | 37.7163837365992 | -122.480645454328 | (37.7163837365992, -122.480645454328) | 1 | 8 | 4 | 64 | 14 | ||||
| 56001 | 177922 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Cambon Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5990625.84661 | 2089245.25322 | 37.7161305522573 | -122.474355255986 | (37.7161305522573, -122.474355255986) | 1 | 8 | 4 | 64 | 14 | |||
| 119745 | 177921 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Cambon Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5990636.51581 | 2089256.00468 | 37.7161606912434 | -122.474319162615 | (37.7161606912434, -122.474319162615) | 1 | 8 | 4 | 64 | 14 | |||
| 106360 | 177925 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Crespi Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 5989826.52584 | 2090074.03315 | 37.7183598349297 | -122.477178590321 | (37.7183598349297, -122.477178590321) | 1 | 8 | 4 | 64 | 14 | ||||
| 138439 | 177924 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Crespi Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5989730.82285 | 2090240.32639 | 37.718810881792 | -122.47752153959 | (37.718810881792, -122.47752153959) | 1 | 8 | 4 | 64 | 14 | ||||
| 105921 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 0 Diaz Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.81974 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | 1 | 8 | 4 | 64 | 14 | ||
| 163165 | 177945 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Diaz Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5990273.00331 | 2089979.48461 | 37.7181261218096 | -122.475628420827 | (37.7181261218096, -122.475628420827) | 1 | 8 | 4 | 64 | 14 | ||||
| 66870 | 177914 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Font Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5989849.36693 | 2089820.74775 | 37.7176657012986 | -122.477081140675 | (37.7176657012986, -122.477081140675) | 1 | 8 | 4 | 64 | 14 | ||||
| 58808 | 177947 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989601.96089 | 2090504.09134 | 37.7195276360688 | -122.477986231896 | (37.7195276360688, -122.477986231896) | 1 | 8 | 4 | 64 | 14 | ||||
| 104030 | 177946 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5989610.43005 | 2090657.90132 | 37.7199504514394 | -122.477968195982 | (37.7199504514394, -122.477968195982) | 1 | 8 | 4 | 64 | 14 | ||||
| 164370 | 177948 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989566.53985 | 2090511.453 | 37.7195457933774 | -122.478109206096 | (37.7195457933774, -122.478109206096) | 1 | 8 | 4 | 64 | 14 | ||||
| 173597 | 177949 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Fuente Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989559.04866 | 2090448.78739 | 37.7193732944219 | -122.478130520911 | (37.7193732944219, -122.478130520911) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | ||||
| 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 | ||||
| 87980 | 177937 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5989487.39768 | 2088989.39507 | 37.7153620069155 | -122.478271538203 | (37.7153620069155, -122.478271538203) | 1 | 8 | 4 | 64 | 14 | ||||
| 110390 | 177935 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989493.36658 | 2088932.77712 | 37.7152068945538 | -122.478246769977 | (37.7152068945538, -122.478246769977) | 1 | 8 | 4 | 64 | 14 | ||||
| 137788 | 177936 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5989491.06081 | 2088964.93712 | 37.7152950640932 | -122.478257089699 | (37.7152950640932, -122.478257089699) | 1 | 8 | 4 | 64 | 14 | ||||
| 180676 | 177940 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989427.62768 | 2089128.02152 | 37.7157391708956 | -122.478488258642 | (37.7157391708956, -122.478488258642) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | ||||
| 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 | ||||
| 60585 | 177955 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 5989333.41698 | 2089519.46327 | 37.7168085025868 | -122.478842503398 | (37.7168085025868, -122.478842503398) | 1 | 8 | 4 | 64 | 14 | ||||
| 89198 | 177951 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989499.70601 | 2089731.63068 | 37.7174007160611 | -122.478283234789 | (37.7174007160611, -122.478283234789) | 1 | 8 | 4 | 64 | 14 | ||||
| 111656 | 177957 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989199.22849 | 2089287.00846 | 37.7161624467126 | -122.479289326156 | (37.7161624467126, -122.479289326156) | 1 | 8 | 4 | 64 | 14 | ||||
| 131577 | 177956 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5989293.3686 | 2089406.92644 | 37.7164971788871 | -122.478972702723 | (37.7164971788871, -122.478972702723) | 1 | 8 | 4 | 64 | 14 | ||||
| 144120 | 177954 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5989416.48515 | 2089561.18461 | 37.7169278821906 | -122.478558430025 | (37.7169278821906, -122.478558430025) | 1 | 8 | 4 | 64 | 14 | ||||
| 146587 | 177964 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5988925.38088 | 2089008.91353 | 37.7153829584191 | -122.480215521739 | (37.7153829584191, -122.480215521739) | 1 | 8 | 4 | 64 | 14 | ||||
| 155324 | 177958 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5989169.01716 | 2089315.78059 | 37.7162396930894 | -122.479395853531 | (37.7162396930894, -122.479395853531) | 1 | 8 | 4 | 64 | 14 | ||||
| 161539 | 177950 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5989537.87078 | 2089714.62637 | 37.7173562418745 | -122.478150075788 | (37.7173562418745, -122.478150075788) | 1 | 8 | 4 | 64 | 14 | ||||
| 165570 | 177960 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989129.76935 | 2089200.6687 | 37.7159213447791 | -122.479523094137 | (37.7159213447791, -122.479523094137) | 1 | 8 | 4 | 64 | 14 | ||||
| 170558 | 177962 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5989078.7127 | 2089134.39971 | 37.7157364207672 | -122.479694721656 | (37.7157364207672, -122.479694721656) | 1 | 8 | 4 | 64 | 14 | ||||
| 180758 | 177952 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989400.28977 | 2089605.00468 | 37.7170472609007 | -122.478617611739 | (37.7170472609007, -122.478617611739) | 1 | 8 | 4 | 64 | 14 | ||||
| 187180 | 177959 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5989083.70402 | 2089208.46347 | 37.7159400713658 | -122.479682885652 | (37.7159400713658, -122.479682885652) | 1 | 8 | 4 | 64 | 14 | ||||
| 192263 | 177961 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5989118.28423 | 2089183.86132 | 37.7158745287534 | -122.479561562622 | (37.7158745287534, -122.479561562622) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | ||||
| 72550 | 177943 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Josepha Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5989687.38089 | 2089641.08495 | 37.7171629928544 | -122.477627922194 | (37.7171629928544, -122.477627922194) | 1 | 8 | 4 | 64 | 14 | ||||
| 133241 | 177941 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Josepha Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5989724.37872 | 2089308.83263 | 37.7162528573591 | -122.477475769516 | (37.7162528573591, -122.477475769516) | 1 | 8 | 4 | 64 | 14 | ||||
| 190001 | 177942 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Josepha Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5989710.75871 | 2089436.68507 | 37.7166031181237 | -122.477532185763 | (37.7166031181237, -122.477532185763) | 1 | 8 | 4 | 64 | 14 | ||||
| 70097 | 177918 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5989709.79651 | 2089731.70675 | 37.7174131186015 | -122.477557062834 | (37.7174131186015, -122.477557062834) | 1 | 8 | 4 | 64 | 14 | ||||
| 84197 | 177919 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5989736.06041 | 2089740.76738 | 37.7174395208859 | -122.477466943539 | (37.7174395208859, -122.477466943539) | 1 | 8 | 4 | 64 | 14 | ||||
| 88411 | 177916 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989586.18825 | 2089731.4345 | 37.7174051973785 | -122.477984294746 | (37.7174051973785, -122.477984294746) | 1 | 8 | 4 | 64 | 14 | ||||
| 97552 | 177915 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5989561.17412 | 2089735.80949 | 37.7174157581119 | -122.478071075724 | (37.7174157581119, -122.478071075724) | 1 | 8 | 4 | 64 | 14 | ||||
| 107379 | 177917 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989687.39355 | 2089722.56421 | 37.7173867154012 | -122.477633830752 | (37.7173867154012, -122.477633830752) | 1 | 8 | 4 | 64 | 14 | ||||
| 150289 | 177920 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989764.37663 | 2089755.55448 | 37.7174817656499 | -122.477370148614 | (37.7174817656499, -122.477370148614) | 1 | 8 | 4 | 64 | 14 | ||||
| 36151 | 232435 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1 Church St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 6ft | 6004121.39652 | 2108664.33355 | 37.7702235143292 | -122.429091988022 | (37.7702235143292, -122.429091988022) | 7 | 9 | 5 | 29492 | 10 | |||
| 79814 | 233227 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006435.78425 | 2096959.11758 | 37.7382144267543 | -122.420255629995 | (37.7382144267543, -122.420255629995) | 2 | 7 | 7 | 28859 | 2 | |||
| 98680 | 210822 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994075.12889 | 2102034.61648 | 37.7514462212671 | -122.463360530485 | (37.7514462212671, -122.463360530485) | 1 | 8 | 4 | 29491 | 40 | |||
| 175724 | 210823 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994071.60304 | 2101964.35734 | 37.7512531044495 | -122.463367625221 | (37.7512531044495, -122.463367625221) | 1 | 8 | 4 | 29491 | 40 | |||
| 24774 | 107077 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 10 BRADY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x4 | 6006482 | 2109752 | 37.7733433304068 | -122.421003898549 | (37.7733433304068, -122.421003898549) | 8 | 2 | 9 | 28853 | 19 | |||
| 108773 | 255780 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 10 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006476 | 2109729 | 37.7732798396992 | -122.421023020053 | (37.7732798396992, -122.421023020053) | 8 | 2 | 9 | 28853 | 19 | ||||
| 19689 | 232961 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5998954.69213 | 2105425.20137 | 37.7610358460469 | -122.446730418281 | (37.7610358460469, -122.446730418281) | 15 | 5 | 11 | 29492 | 12 | |||
| 37099 | 232963 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Carmel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5998915.09351 | 2105421.46828 | 37.761023333779 | -122.446867103551 | (37.761023333779, -122.446867103551) | 15 | 5 | 11 | 29492 | 12 | |||
| 149346 | 232964 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Carmel St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5998893.42724 | 2105419.84777 | 37.7610176464756 | -122.446941920852 | (37.7610176464756, -122.446941920852) | 15 | 5 | 11 | 29492 | 12 | |||
| 193283 | 232962 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Carmel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5998932.61026 | 2105423.58947 | 37.7610301587293 | -122.446806673598 | (37.7610301587293, -122.446806673598) | 15 | 5 | 11 | 29492 | 12 | |||
| 164574 | 65473 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 10 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29345 | 5995326.58257059 | 2091913.57647422 | 37.7237283530048 | -122.45830039747 | (37.7237283530048, -122.45830039747) | 9 | 8 | 4 | 28861 | 24 | ||
| 74660 | 210755 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994519.49208 | 2106024.97078 | 37.762428300536 | -122.462113234642 | (37.762428300536, -122.462113234642) | 1 | 5 | 11 | 56 | 12 | |||
| 130900 | 210756 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994500.79193 | 2106024.87293 | 37.7624269551699 | -122.462177903984 | (37.7624269551699, -122.462177903984) | 1 | 5 | 11 | 56 | 12 | |||
| 36590 | 233783 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Saturn St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000623.49703 | 2106025.63794 | 37.7627796854658 | -122.441001838469 | (37.7627796854658, -122.441001838469) | 15 | 5 | 5 | 28862 | 3 | |||
| 41508 | 233781 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Saturn St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000622.86001 | 2106032.19557 | 37.7627976548176 | -122.441004512163 | (37.7627976548176, -122.441004512163) | 15 | 5 | 5 | 28862 | 3 | |||
| 64424 | 233779 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Saturn St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6000624.58928 | 2106041.01354 | 37.762821965281 | -122.44099916388 | (37.762821965281, -122.44099916388) | 15 | 5 | 5 | 28862 | 3 | |||
| 131519 | 233780 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Saturn St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000618.75311 | 2106039.2097 | 37.7628166799724 | -122.441019219675 | (37.7628166799724, -122.441019219675) | 15 | 5 | 5 | 28862 | 3 | |||
| 181826 | 233782 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 10 Saturn St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6000620.83206 | 2106027.61812 | 37.7627849707639 | -122.441011197703 | (37.7627849707639, -122.441011197703) | 15 | 5 | 5 | 28862 | 3 | |||
| 49168 | 47597 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/2003 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
| 56693 | 47594 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
| 91322 | 232866 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009630.05174 | 2096202.69692 | 37.736316931874 | -122.409158028324 | (37.736316931874, -122.409158028324) | 10 | 7 | 7 | 28859 | 2 | |||
| 100537 | 47593 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
| 134900 | 232867 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Alemany Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009311.71143 | 2095856.61824 | 37.7353488350788 | -122.410234240737 | (37.7353488350788, -122.410234240737) | 10 | 7 | 7 | 28859 | 2 | |||
| 181884 | 47595 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
| 25993 | 194151 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Carolina St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 6012252.37464 | 2106853.87297 | 37.7657093124668 | -122.400839596166 | (37.7657093124668, -122.400839596166) | 14 | 3 | 8 | 28856 | 20 | |||
| 84614 | 194153 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Carolina St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 6012257.45791 | 2106772.39506 | 37.765485875897 | -122.400816289341 | (37.765485875897, -122.400816289341) | 14 | 3 | 8 | 28856 | 20 | |||
| 96462 | 194152 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Carolina St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 6012254.86513 | 2106816.35106 | 37.7656064246163 | -122.400828345673 | (37.7656064246163, -122.400828345673) | 14 | 3 | 8 | 28856 | 20 | |||
| 179453 | 194150 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Carolina St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 6012249.4838 | 2106891.91002 | 37.7658135924426 | -122.400852267621 | (37.7658135924426, -122.400852267621) | 14 | 3 | 8 | 28856 | 20 | |||
| 274 | 232433 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004078.25972 | 2108290.75217 | 37.7691953086514 | -122.429214555715 | (37.7691953086514, -122.429214555715) | 7 | 9 | 5 | 28862 | 3 | |||
| 2714 | 113322 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004079.74050315 | 2108375.213269 | 37.7694273021614 | -122.42921545709 | (37.7694273021614, -122.42921545709) | 7 | 9 | 5 | 28862 | 3 | ||||
| 66577 | 232434 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Church St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6004077.27006 | 2108309.37309 | 37.7692463811546 | -122.429219306844 | (37.7692463811546, -122.429219306844) | 7 | 9 | 5 | 28862 | 3 | |||
| 94459 | 232432 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Church St | 3 | : | Tree | Private 2 | 15 | Width 4ft | 6004078.65513 | 2108269.95494 | 37.7691382268875 | -122.429211704867 | (37.7691382268875, -122.429211704867) | 7 | 9 | 5 | 28862 | 3 | |||
| 101830 | 113323 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6004079.74050315 | 2108375.213269 | 37.7694273021614 | -122.42921545709 | (37.7694273021614, -122.42921545709) | 7 | 9 | 5 | 28862 | 3 | |||
| 101993 | 88512 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51445 | 5995638 | 2093313 | 37.7275887253261 | -122.457325078591 | (37.7275887253261, -122.457325078591) | 9 | 7 | 4 | 28861 | 40 | ||
| 122430 | 88513 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51445 | 5995638 | 2093313 | 37.7275887253261 | -122.457325078591 | (37.7275887253261, -122.457325078591) | 9 | 7 | 4 | 28861 | 40 | ||
| 11353 | 210831 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 El Verano Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994495.15253 | 2094669.90963 | 37.7312487620154 | -122.461374210478 | (37.7312487620154, -122.461374210478) | 9 | 8 | 4 | 59 | 40 | |||
| 18498 | 210832 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 El Verano Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994491.87078 | 2094685.88565 | 37.7312924393794 | -122.461386713728 | (37.7312924393794, -122.461386713728) | 9 | 8 | 4 | 59 | 40 | |||
| 62021 | 210600 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5995427.38447 | 2107071.96 | 37.7653552934468 | -122.459049004307 | (37.7653552934468, -122.459049004307) | 15 | 5 | 11 | 56 | 12 | |||
| 139987 | 210601 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5995408.81164 | 2107071.42488 | 37.7653527564515 | -122.45911320422 | (37.7653527564515, -122.45911320422) | 15 | 5 | 11 | 56 | 12 | |||
| 106206 | 210681 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Malta Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5999441.24065 | 2096192.06642 | 37.735711675549 | -122.444384101443 | (37.735711675549, -122.444384101443) | 9 | 7 | 4 | 63 | 40 |
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) );