trees
3,709 rows where qSpecies_id = 9 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
196 | 116631 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 12 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
416 | 116621 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 2 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||||||||||||
1912 | 261449 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 306 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006931 | 2095728 | 37.7348619417662 | -122.418456144702 | (37.7348619417662, -122.418456144702) | 2 | 7 | 7 | 28859 | 2 | ||||
2011 | 264734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1364 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006427.83864 | 2119405.514 | 37.7998464469137 | -122.42187710854 | (37.7998464469137, -122.42187710854) | 13 | 9 | 1 | 28858 | 32 | |||||
2359 | 35980 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 349 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39134 | 6006399.96537133 | 2097866.62265006 | 37.740704214618 | -122.420443871581 | (37.740704214618, -122.420443871581) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||||
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 | ||||||||||||||
3596 | 264801 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011023 | 2089107 | 37.7169115603385 | -122.403842847789 | (37.7169115603385, -122.403842847789) | 10 | 7 | 8 | 309 | 39 | ||||
4050 | 173690 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 690X 03RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2015 12:00:00 AM | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | |||
4903 | 88595 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 399 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52536 | 6004228 | 2109402 | 37.7722550008378 | -122.428775842479 | (37.7722550008378, -122.428775842479) | 7 | 9 | 11 | 28852 | 10 | ||
5987 | 262213 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 66 Clarendon Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5997837 | 2104660 | 37.7588708842054 | -122.450540844653 | (37.7588708842054, -122.450540844653) | 15 | 5 | 11 | 28862 | 12 | ||||
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 | ||
6720 | 116625 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 6 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
6841 | 45453 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 191 Corona St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/2001 12:00:00 AM | Permit Number 44237 | 5993006.32104665 | 2092505.10355506 | 37.7252189362985 | -122.466364051503 | (37.7252189362985, -122.466364051503) | 9 | 8 | 4 | 59 | 40 | ||
6952 | 264732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1965 Quint St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012227 | 2095019 | 37.7332118929398 | -122.40009613746 | (37.7332118929398, -122.40009613746) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||||||||||||||
7701 | 97237 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125 Excelsior Ave | Sidewalk: Property side : Yard | Tree | SFUSD 4 | FUF | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911 | 2092621.3 | 37.7261045201699 | -122.432132888294 | (37.7261045201699, -122.432132888294) | 9 | 7 | 6 | 28861 | 5 | |||
9358 | 252934 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 78 Edgar Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997141 | 2091229 | 37.7219527643602 | -122.451978930217 | (37.7219527643602, -122.451978930217) | 9 | 8 | 6 | 28861 | 24 | |||||
9743 | 34866 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 579 Miramar Ave | 1 | Median : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | 9 | 7 | 4 | 28861 | 40 | ||
10271 | 262199 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 801 Sanchez St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003778 | 2103544 | 37.7561448640021 | -122.429914501498 | (37.7561448640021, -122.429914501498) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | |||||||||||||
12031 | 262472 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 210 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 6001697 | 2086437 | 37.7090549070704 | -122.435887307636 | (37.7090549070704, -122.435887307636) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||||
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 | ||||||||||||||
14018 | 111009 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1801x WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003409 | 2114904 | 37.7873157334926 | -122.432001790592 | (37.7873157334926, -122.432001790592) | 13 | 9 | 11 | 29490 | 27 | ||||
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 | ||||||||||||||
14962 | 41296 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 65 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 41973 | 6006281.33179879 | 2109112.42754659 | 37.7715759040746 | -122.421652604165 | (37.7715759040746, -122.421652604165) | 8 | 2 | 9 | 28853 | 19 | ||
15184 | 32343 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2885 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36904 | 5999249.30586492 | 2118007.60671846 | 37.7956007178544 | -122.446616785481 | (37.7956007178544, -122.446616785481) | 13 | 9 | 1 | 57 | 17 | |||
15351 | 261516 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 671 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 11:26:00 AM | 3x3 | 5983177.86359 | 2111217.50955 | 37.7760259908371 | -122.501723286949 | (37.7760259908371, -122.501723286949) | 11 | 6 | 2 | 55 | 26 | |||
15934 | 113606 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
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 | |||||||||||||
16427 | 262473 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 210 Drake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 6001697 | 2086437 | 37.7090549070704 | -122.435887307636 | (37.7090549070704, -122.435887307636) | 9 | 7 | 6 | 28861 | 5 | |||
16480 | 50938 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4752 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48543 | 5998450.03825367 | 2105698.06494287 | 37.7617562199837 | -122.448495440986 | (37.7617562199837, -122.448495440986) | 15 | 5 | 11 | 29492 | 9 | ||
17332 | 38426 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 126 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1999 12:00:00 AM | Permit Number 41732 | 6001233.109597 | 2094965.61225629 | 37.7324461904854 | -122.438101100943 | (37.7324461904854, -122.438101100943) | 9 | 7 | 5 | 63 | 40 | ||
17696 | 39128 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 755 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40809 | 6007359.12700155 | 2102919.00118427 | 37.7546309134503 | -122.417485428329 | (37.7546309134503, -122.417485428329) | 2 | 4 | 7 | 28859 | 19 | ||
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 | ||||||||||||||
18440 | 60477 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1343 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1982 12:00:00 AM | Permit Number 20072 | 6002221.27409585 | 2113110.91985101 | 37.7823249851452 | -122.435982713361 | (37.7823249851452, -122.435982713361) | 15 | 5 | 11 | 29490 | 41 | ||
18844 | 99796 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 703-705 Elizabeth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001860 | 2102041 | 37.7519091810186 | -122.436440015083 | (37.7519091810186, -122.436440015083) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | ||
20783 | 42043 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | 2 | 4 | 5 | 28862 | 22 | ||
21121 | 51223 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 78 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/11/2004 12:00:00 AM | Permit Number 47589 | 5999349.25090269 | 2107863.63052883 | 37.7677536935842 | -122.445541163796 | (37.7677536935842, -122.445541163796) | 15 | 5 | 11 | 29492 | 9 | ||
21201 | 47307 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 905 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45238 | 6009420.31304698 | 2103898.06138647 | 37.7574349528314 | -122.410426393727 | (37.7574349528314, -122.410426393727) | 2 | 4 | 7 | 28859 | 19 | ||
21706 | 88180 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 435 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51188 | 6011272.5 | 2112058.5 | 37.7799453198016 | -122.404595202044 | (37.7799453198016, -122.404595202044) | 14 | 2 | 9 | 28853 | 34 | ||
22330 | 105059 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500X 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | 3x3 | Permit Number 770390 | 5987202.10059 | 2112208.93891 | 37.7789837289288 | -122.487875431883 | (37.7789837289288, -122.487875431883) | 11 | 6 | 2 | 55 | 26 | ||
23066 | 115227 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 22 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775148 | 5988276.3 | 2115892 | 37.7891589710102 | -122.484429598969 | (37.7891589710102, -122.484429598969) | 11 | 6 | 1 | 61 | 30 | |||
23181 | 102518 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 498X Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010140.7 | 2089714.5 | 37.7185302998738 | -122.406935337509 | (37.7185302998738, -122.406935337509) | 10 | 7 | 8 | 309 | 39 | |||||
23770 | 39620 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 176 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41019 | 5997495.40415115 | 2106779.2398399 | 37.7646702234482 | -122.451875122756 | (37.7646702234482, -122.451875122756) | 15 | 5 | 11 | 29492 | 9 | ||
24003 | 48767 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 837 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2002 12:00:00 AM | Permit Number 46025 | 6001146.78889593 | 2099651.30348098 | 37.7453070923234 | -122.438735172895 | (37.7453070923234, -122.438735172895) | 2 | 4 | 5 | 63 | 22 | |||
25147 | 87468 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 147 Laidley St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2008 12:00:00 AM | 3x3 | Permit Number 50383 | 6003836 | 2097532 | 37.7396405954937 | -122.429285233348 | (37.7396405954937, -122.429285233348) | 2 | 7 | 5 | 63 | 7 | |||
25642 | 103578 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 101X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | ||||
25812 | 42775 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 595 Hayes St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42746 | 6005021.69046201 | 2110898.204752 | 37.7764081042584 | -122.426136930931 | (37.7764081042584, -122.426136930931) | 7 | 9 | 11 | 28852 | 10 | ||
25877 | 52000 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 222 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1973 12:00:00 AM | Permit Number 48218 | 6003679.11274535 | 2101599.81538645 | 37.7508009907308 | -122.430117797464 | (37.7508009907308, -122.430117797464) | 2 | 4 | 5 | 28862 | 22 | |||
26374 | 65083 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 453 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/09/1995 12:00:00 AM | Permit Number 27047 | 6010566.1381684 | 2112563.56806909 | 37.7812926155318 | -122.407074445388 | (37.7812926155318, -122.407074445388) | 14 | 2 | 9 | 28853 | 34 | ||
26382 | 82437 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 539 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50245 | 6009859.63908286 | 2098999.33240433 | 37.7440087468647 | -122.408561465079 | (37.7440087468647, -122.408561465079) | 2 | 7 | 7 | 28859 | 2 | ||
26538 | 49701 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3224@ PRECITA Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/25/2005 12:00:00 AM | Permit Number 46520 | 6008982.54318387 | 2099905.81339366 | 37.7464485829446 | -122.411658311185 | (37.7464485829446, -122.411658311185) | 2 | 7 | 7 | 28859 | 2 | ||
27942 | 43715 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 31 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43356 | 5995595.90606819 | 2090114.46838183 | 37.7188039024441 | -122.457239310884 | (37.7188039024441, -122.457239310884) | 9 | 8 | 6 | 28861 | 24 | ||
28155 | 106768 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 226 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x9 | 6001629.46862 | 2120633.92047 | 37.8029475537601 | -122.438569291156 | (37.8029475537601, -122.438569291156) | 13 | 9 | 1 | 57 | 17 | ||||
28173 | 253446 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1339 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1992 12:00:00 AM | 3x3 | 6002186 | 2113207 | 37.7825867929513 | -122.436111623564 | (37.7825867929513, -122.436111623564) | 15 | 5 | 11 | 29490 | 41 | |||
29566 | 43027 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3615 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | Permit Number 42890 | 6005490.1381461 | 2105449.62279736 | 37.7614740690255 | -122.424128859066 | (37.7614740690255, -122.424128859066) | 2 | 4 | 5 | 28859 | 19 | |||
29924 | 46800 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 296 Maywood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | Permit Number 44889 | 5994480.57701846 | 2094690.84310418 | 37.7313054013186 | -122.461426117294 | (37.7313054013186, -122.461426117294) | 9 | 8 | 4 | 59 | 40 | |||
30260 | 114430 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 455 EDDY ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6008254 | 2113439 | 37.7835666804498 | -122.415135318852 | (37.7835666804498, -122.415135318852) | 7 | 10 | 9 | 28852 | 36 | ||||
31133 | 89121 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1455 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51791 | 6002022 | 2099858 | 37.7459243843383 | -122.435723628141 | (37.7459243843383, -122.435723628141) | 2 | 7 | 5 | 63 | 22 | ||
32165 | 103580 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
32285 | 39796 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1920 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.7509247944527 | -122.499795829171 | (37.7509247944527, -122.499795829171) | 1 | 8 | 3 | 29491 | 35 | ||
32349 | 88001 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 801 Bay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952 | 2121180 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | 5 | 1 | 1 | 28858 | 32 | ||
32559 | 38709 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1900 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1998 12:00:00 AM | Permit Number 40614 | 6000044.14141087 | 2111300.00488868 | 37.7772287555823 | -122.443384488436 | (37.7772287555823, -122.443384488436) | 15 | 5 | 11 | 29490 | 16 | ||
33506 | 44313 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2150 Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2001 12:00:00 AM | Permit Number 43711 | 6001880.60996644 | 2113983.70033588 | 37.7847020596058 | -122.437223769823 | (37.7847020596058, -122.437223769823) | 13 | 6 | 11 | 29490 | 13 | |||
33766 | 38707 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1900 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1998 12:00:00 AM | Permit Number 40614 | 6000044.14141087 | 2111300.00488868 | 37.7772287555823 | -122.443384488436 | (37.7772287555823, -122.443384488436) | 15 | 5 | 11 | 29490 | 16 | ||
33921 | 43570 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1604 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43231 | 6002560.91042795 | 2100907.07838403 | 37.7488355032508 | -122.433935126175 | (37.7488355032508, -122.433935126175) | 2 | 4 | 5 | 28862 | 22 | ||
34575 | 95869 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 585 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 767589 | 6010187.2 | 2119540 | 37.8004270041515 | -122.408877749885 | (37.8004270041515, -122.408877749885) | 3 | 1 | 10 | 308 | 23 | ||
34791 | 116627 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 8 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
35570 | 68419 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 94 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32262 | 5993499.28123568 | 2093584.8530568 | 37.728212096333 | -122.464738324511 | (37.728212096333, -122.464738324511) | 9 | 8 | 4 | 59 | 40 | ||
35665 | 37546 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 830 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39987 | 6008596.95727106 | 2115265.79023303 | 37.7886018721806 | -122.414078094846 | (37.7886018721806, -122.414078094846) | 5 | 1 | 10 | 28858 | 21 | ||
36004 | 187698 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2880 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008980.17665 | 2103937.78959 | 37.7575193538388 | -122.41195137385 | (37.7575193538388, -122.41195137385) | 2 | 4 | 7 | 28859 | 19 | ||||
36632 | 116630 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 5732X GEARY BLVD | 11 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||
37049 | 37025 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 410 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39635 | 6003833.74081357 | 2100145.79948593 | 37.7468173585654 | -122.429479398489 | (37.7468173585654, -122.429479398489) | 2 | 7 | 5 | 63 | 22 | ||
37139 | 98289 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
37165 | 84952 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 8 Kronquist Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2007 12:00:00 AM | Permit Number 49383 | 6002223 | 2100219 | 37.7469270204759 | -122.43505441311 | (37.7469270204759, -122.43505441311) | 2 | 7 | 5 | 63 | 22 | |||
37613 | 49955 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 823 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | Permit Number 46736 | 6012467.34839499 | 2104144.40371857 | 37.7582816988758 | -122.399905762693 | (37.7582816988758, -122.399905762693) | 10 | 3 | 8 | 28856 | 29 | ||
37891 | 79374 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 532 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50243 | 6009806.51936766 | 2099019.13677638 | 37.7440601502387 | -122.40874653873 | (37.7440601502387, -122.40874653873) | 2 | 7 | 7 | 28859 | 2 | ||
38425 | 43408 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 521 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43151 | 6001773.04601386 | 2101442.02033721 | 37.7502595844098 | -122.436697841973 | (37.7502595844098, -122.436697841973) | 2 | 4 | 5 | 28862 | 22 | ||
38488 | 51294 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1217 Shafter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2004 12:00:00 AM | Permit Number 47666 | 6016937.80385774 | 2092637.74842389 | 37.7269349786738 | -122.383643722332 | (37.7269349786738, -122.383643722332) | 10 | 3 | 8 | 58 | 1 | |||
38591 | 103581 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
38713 | 113610 | Section 143 10 | Olea europaea :: Olive Tree 9 | 595 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009000 | 2105472 | 37.7617330585457 | -122.411991234579 | (37.7617330585457, -122.411991234579) | 8 | 4 | 7 | 28859 | 19 | |||
38850 | 37193 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1726 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/1998 12:00:00 AM | Permit Number 39760 | 5986905.42853407 | 2103505.82529925 | 37.7550700890109 | -122.488261987916 | (37.7550700890109, -122.488261987916) | 1 | 8 | 3 | 56 | 35 | ||
39870 | 173692 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 690X 03RD ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | |||
40140 | 253661 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 715 Buena Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999814 | 2107879 | 37.7678224156838 | -122.443934762725 | (37.7678224156838, -122.443934762725) | 15 | 5 | 11 | 29492 | 9 | ||||
40141 | 34838 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 94 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/1997 12:00:00 AM | Permit Number 38463 | 6004273.91738669 | 2109284.40431145 | 37.7719347104397 | -122.428608626151 | (37.7719347104397, -122.428608626151) | 7 | 9 | 11 | 28852 | 10 | |||
40829 | 42773 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 595 Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42746 | 6005021.69046201 | 2110898.204752 | 37.7764081042584 | -122.426136930931 | (37.7764081042584, -122.426136930931) | 7 | 9 | 11 | 28852 | 10 | ||
40963 | 66563 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 223 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1991 12:00:00 AM | Permit Number 29752 | 6004817.37970152 | 2094084.27959898 | 37.7302294392737 | -122.425646720474 | (37.7302294392737, -122.425646720474) | 9 | 7 | 6 | 28861 | 5 | ||
41228 | 33871 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 199 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50234 | 6010103.23973562 | 2099711.91394451 | 37.74597898005 | -122.407769380972 | (37.74597898005, -122.407769380972) | 2 | 7 | 7 | 28859 | 2 | ||
41240 | 40488 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1999 12:00:00 AM | 5x5 | Permit Number 41567 | 5995790.34429445 | 2107089.36315796 | 37.7654239364323 | -122.457794878244 | (37.7654239364323, -122.457794878244) | 15 | 5 | 11 | 56 | 12 | ||
41343 | 60649 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 292 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20280 | 6003745.89450953 | 2097926.17013377 | 37.7407177947851 | -122.429624884311 | (37.7407177947851, -122.429624884311) | 2 | 7 | 5 | 63 | 7 | ||
42085 | 50612 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 231 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/2003 12:00:00 AM | Permit Number 47210 | 6006872.46746704 | 2096756.42071917 | 37.7376824626662 | -122.418731421871 | (37.7376824626662, -122.418731421871) | 2 | 7 | 7 | 28859 | 2 | ||
42104 | 44315 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2150 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2001 12:00:00 AM | Permit Number 43711 | 6001880.60996644 | 2113983.70033588 | 37.7847020596058 | -122.437223769823 | (37.7847020596058, -122.437223769823) | 13 | 6 | 11 | 29490 | 13 | |||
42358 | 50355 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 200 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47030 | 6014664.3812076 | 2111605.18300999 | 37.7788895958171 | -122.392829354684 | (37.7788895958171, -122.392829354684) | 6 | 2 | 9 | 28856 | 34 | |||
42927 | 34496 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 208 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38219 | 6008611.6034595 | 2097621.61105631 | 37.7401558519993 | -122.412779523149 | (37.7401558519993, -122.412779523149) | 10 | 7 | 7 | 28859 | 2 | ||
43198 | 84954 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 8 Kronquist Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002223 | 2100219 | 37.7469270204759 | -122.43505441311 | (37.7469270204759, -122.43505441311) | 2 | 7 | 5 | 63 | 22 |
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) );