trees
3,709 rows where qSpecies_id = 9 sorted by Zip Codes descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▲ | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 291 | 210733 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 239 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992956.15258 | 2088805.34296 | 37.7150573966491 | -122.466268722147 | (37.7150573966491, -122.466268722147) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 6162 | 46753 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 378 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44855 | 5993270.29922187 | 2089695.37971007 | 37.7175193444423 | -122.465247516931 | (37.7175193444423, -122.465247516931) | 9 | 8 | 6 | 64 | 24 | ||
| 7404 | 210734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 270 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992990.46687 | 2089001.91036 | 37.7155991032881 | -122.466164394482 | (37.7155991032881, -122.466164394482) | 9 | 8 | 6 | 64 | 24 | |||
| 7457 | 2165 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 119X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/1997 12:00:00 AM | 12 | 3X27 | 5993658.6263 | 2088481.9826 | 37.7142100327703 | -122.463817234952 | (37.7142100327703, -122.463817234952) | 9 | 8 | 6 | 64 | 24 | ||
| 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 | ||||
| 13349 | 261323 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 278 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993017 | 2089051 | 37.7157354224316 | -122.466076249864 | (37.7157354224316, -122.466076249864) | 9 | 8 | 6 | 64 | 24 | ||||
| 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 | ||
| 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 | ||||
| 23967 | 210736 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 279 Ramsell St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992958.08764 | 2089050.23377 | 37.7157299195648 | -122.466279820655 | (37.7157299195648, -122.466279820655) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | |
| 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 | ||||
| 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 | ||||
| 36811 | 46745 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 24 Sargent St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | 9 | 8 | 6 | 64 | 24 | ||
| 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 | |||
| 57979 | 210740 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 146 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992981.03901 | 2088189.5314 | 37.7133679617255 | -122.466137980489 | (37.7133679617255, -122.466137980489) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 59564 | 177913 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2924 21st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 5990007.1003 | 2095790.68963 | 37.7340668092368 | -122.476971913545 | (37.7340668092368, -122.476971913545) | 1 | 8 | 4 | 64 | 35 | |||
| 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 | ||||
| 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 | ||||
| 68351 | 18609 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 5992399.8764 | 2088496.7733 | 37.7141780269744 | -122.468168999945 | (37.7141780269744, -122.468168999945) | 9 | 8 | 6 | 64 | 24 | |||
| 68744 | 46748 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 24 Sargent St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 71863 | 46747 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 24 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | 9 | 8 | 6 | 64 | 24 | ||
| 72108 | 18611 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 618 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992335.2804 | 2088560.1418 | 37.7143482906927 | -122.468396874173 | (37.7143482906927, -122.468396874173) | 9 | 8 | 6 | 64 | 24 | |||
| 72526 | 18605 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 533 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992541.0363 | 2088494.6252 | 37.7141802803508 | -122.467680944889 | (37.7141802803508, -122.467680944889) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 79629 | 18615 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 701 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992139.1908 | 2088496.6198 | 37.7141625464129 | -122.469070010847 | (37.7141625464129, -122.469070010847) | 9 | 8 | 6 | 64 | 24 | |||
| 80897 | 31169 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 701 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2015 12:00:00 AM | 3 | 3x3 | Permit Number 34870 | 5992182.10994821 | 2088503.70058995 | 37.7141844683459 | -122.468922182021 | (37.7141844683459, -122.468922182021) | 9 | 8 | 6 | 64 | 24 | |
| 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 | ||||
| 86323 | 210737 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 283 Ramsell St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5992959.06004 | 2089081.22924 | 37.7158150817716 | -122.466278710897 | (37.7158150817716, -122.466278710897) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 90815 | 210735 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 274 Ramsell St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5992991.6057 | 2089025.54794 | 37.7156640721019 | -122.466162174951 | (37.7156640721019, -122.466162174951) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 93646 | 18578 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 114 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5993641.4878 | 2088544.8235 | 37.7143815912468 | -122.463881030417 | (37.7143815912468, -122.463881030417) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 100529 | 210710 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 389 Orizaba Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5994002.44073 | 2089155.53894 | 37.7160792648303 | -122.462677719297 | (37.7160792648303, -122.462677719297) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 106545 | 210732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 486 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992756.33333 | 2090404.7555 | 37.719437465534 | -122.467075592082 | (37.719437465534, -122.467075592082) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 107429 | 45542 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3300 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 4 | Permit Number 44296 | 5988742.04656 | 2095268.07892 | 37.7325583853409 | -122.481307288808 | (37.7325583853409, -122.481307288808) | 1 | 8 | 4 | 64 | 35 | |
| 108989 | 46744 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 24 Sargent St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | 9 | 8 | 6 | 64 | 24 | |||
| 109048 | 46751 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 374 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44853 | 5993270.00396137 | 2089670.22710211 | 37.7174502644102 | -122.465246711525 | (37.7174502644102, -122.465246711525) | 9 | 8 | 6 | 64 | 24 | ||
| 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 | ||||
| 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 | ||||
| 113998 | 52972 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 355 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48953 | 5991933.5202918 | 2090897.4017579 | 37.7207426228906 | -122.46995557771 | (37.7207426228906, -122.46995557771) | 9 | 8 | 6 | 64 | 24 | ||
| 116608 | 210730 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 599 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5992718.10768 | 2091174.58463 | 37.721549022462 | -122.467263668211 | (37.721549022462, -122.467263668211) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 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 | |||
| 125337 | 18595 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 400 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5992880.7313 | 2088552.758 | 37.7143595070954 | -122.466511060282 | (37.7143595070954, -122.466511060282) | 9 | 8 | 6 | 64 | 24 | |||
| 128397 | 18600 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1992 12:00:00 AM | 6 | 3X3 | 5992650.7421 | 2088555.8456 | 37.7143547106063 | -122.467306211311 | (37.7143547106063, -122.467306211311) | 9 | 8 | 6 | 64 | 24 | ||
| 129214 | 18587 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 301 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2003 12:00:00 AM | 3 | 3X3 | 5993176.8455 | 2088486.1085 | 37.7141935864691 | -122.4654827422 | (37.7141935864691, -122.4654827422) | 9 | 8 | 6 | 64 | 24 | ||
| 129911 | 210708 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401 Orizaba Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5993993.93281 | 2089184.16477 | 37.7161573745291 | -122.462709201884 | (37.7161573745291, -122.462709201884) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 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 | ||||
| 135482 | 46746 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 24 Sargent St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44850 | 5993950.76633689 | 2089205.28272749 | 37.7162128731821 | -122.462859935923 | (37.7162128731821, -122.462859935923) | 9 | 8 | 6 | 64 | 24 | ||
| 136049 | 105994 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 131 GRIJALVA DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989195.7 | 2089107.3 | 37.7156688070552 | -122.479288383095 | (37.7156688070552, -122.479288383095) | 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 | ||||
| 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 | ||||
| 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 | ||||
| 141156 | 45517 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2975 26th Ave | 2 | 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 | ||
| 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 | ||||
| 142123 | 18594 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 400 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5992917.5472 | 2088553.0754 | 37.7143625030062 | -122.466383834117 | (37.7143625030062, -122.466383834117) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 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 | ||||
| 146772 | 45519 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2980 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | Permit Number 44281 | 5988597.7763851 | 2095373.33810815 | 37.7328390111084 | -122.481813767038 | (37.7328390111084, -122.481813767038) | 1 | 8 | 4 | 64 | 35 | ||
| 148122 | 210709 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 389 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5994001.88114 | 2089168.33159 | 37.7161143581664 | -122.462680580956 | (37.7161143581664, -122.462680580956) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 151828 | 18601 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 509 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5992650.5887 | 2088494.932 | 37.7141874476643 | -122.467302314998 | (37.7141874476643, -122.467302314998) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 155730 | 17241 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 17X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5993905.3882 | 2088478.8088 | 37.714215535169 | -122.462964106477 | (37.714215535169, -122.462964106477) | 9 | 8 | 6 | 64 | 24 | |||
| 159028 | 18574 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 24 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5993864.1289 | 2088541.8084 | 37.7143861403954 | -122.463111281888 | (37.7143861403954, -122.463111281888) | 9 | 8 | 6 | 64 | 24 | |||
| 159208 | 254192 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 131 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/18/2018 12:00:00 AM | 3 | 3x3 | 5989195 | 2089107 | 37.7156679426736 | -122.479290780653 | (37.7156679426736, -122.479290780653) | 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 | ||||
| 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 | ||||
| 164173 | 18616 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 715 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5992096.2291 | 2088496.6198 | 37.7141600639726 | -122.469218501712 | (37.7141600639726, -122.469218501712) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 165198 | 45518 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2980 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | Permit Number 44281 | 5988597.7763851 | 2095373.33810815 | 37.7328390111084 | -122.481813767038 | (37.7328390111084, -122.481813767038) | 1 | 8 | 4 | 64 | 35 | ||
| 165519 | 210731 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 555 Arch St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992721.77233 | 2090849.66532 | 37.7206570847417 | -122.46722738773 | (37.7206570847417, -122.46722738773) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 168209 | 210738 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 291 Ramsell St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5992961.95972 | 2089127.53233 | 37.7159423862175 | -122.46627205144 | (37.7159423862175, -122.46627205144) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 172203 | 210707 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401 Orizaba Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5994004.02055 | 2089191.37438 | 37.716177751384 | -122.462674856786 | (37.716177751384, -122.462674856786) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 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 | ||||
| 177929 | 45543 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3300 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | 4 | Permit Number 44296 | 5988727.59367 | 2095266.58975 | 37.7325534561717 | -122.481357146331 | (37.7325534561717, -122.481357146331) | 1 | 8 | 4 | 64 | 35 | |
| 177977 | 210739 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 378 Victoria St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993261.2949 | 2089711.81841 | 37.7175639618854 | -122.465279833897 | (37.7175639618854, -122.465279833897) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 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 | ||||
| 184092 | 187618 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 146 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993007 | 2088191 | 37.71337349192 | -122.466048357651 | (37.71337349192, -122.466048357651) | 9 | 8 | 6 | 64 | 24 | ||||
| 186466 | 210706 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 401 Orizaba Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5994003.39155 | 2089200.86992 | 37.7162037876449 | -122.462677719319 | (37.7162037876449, -122.462677719319) | 9 | 8 | 6 | 64 | 24 | |||
| 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 |
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) );