trees
3,709 rows where qSpecies_id = 9 sorted by PlotSize 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4290 | 232871 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 301 Putnam St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 9ft | 6009080.37891 | 2095903.22512 | 37.7354638376772 | -122.411037337111 | (37.7354638376772, -122.411037337111) | 10 | 7 | 7 | 28859 | 2 | |||
36260 | 194193 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1601 Kansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 9ft | 6011834.44242 | 2100473.73914 | 37.748167551187 | -122.401836621487 | (37.748167551187, -122.401836621487) | 10 | 3 | 8 | 58 | 1 | |||
40254 | 210860 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 458 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 5998392.85645 | 2095276.63418 | 37.7331382439186 | -122.447942868994 | (37.7331382439186, -122.447942868994) | 9 | 7 | 4 | 59 | 40 | |||
43055 | 131861 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3640 Lyon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 9ft | 5998876.90196 | 2121298.68391 | 37.8046158502946 | -122.448142451919 | (37.8046158502946, -122.448142451919) | 13 | 9 | 1 | 57 | 17 | |||
45461 | 124176 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 11 Almaden Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 9ft | 5995826.09852 | 2112588.51087 | 37.7805252097548 | -122.458069228121 | (37.7805252097548, -122.458069228121) | 11 | 6 | 2 | 54 | 16 | |||
90874 | 232869 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 301 Putnam St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 9ft | 6009077.71064 | 2095875.53633 | 37.7353876606063 | -122.411044607225 | (37.7353876606063, -122.411044607225) | 10 | 7 | 7 | 28859 | 2 | |||
101385 | 210682 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100x Idora Ave | 6 | Median : Yard | Tree | DPW 1 | 15 | Width 9ft | 5995339.29404 | 2099412.44102 | 37.7443191354124 | -122.4587991034 | (37.7443191354124, -122.4587991034) | 1 | 8 | 4 | 59 | 40 | |||
136827 | 194192 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1601 Kansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 9ft | 6011834.44242 | 2100473.73914 | 37.748167551187 | -122.401836621487 | (37.748167551187, -122.401836621487) | 10 | 3 | 8 | 58 | 1 | |||
147133 | 232870 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 301 Putnam St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 9ft | 6009078.53533 | 2095890.17638 | 37.7354279052703 | -122.411042789701 | (37.7354279052703, -122.411042789701) | 10 | 7 | 7 | 28859 | 2 | |||
160633 | 232868 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 301 Putnam St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 9ft | 6009077.45417 | 2095862.97856 | 37.735353165298 | -122.411044607224 | (37.735353165298, -122.411044607224) | 10 | 7 | 7 | 28859 | 2 | |||
47133 | 210687 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 270 Hearst Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 5999611.40538 | 2094395.78433 | 37.7307892138454 | -122.443666775201 | (37.7307892138454, -122.443666775201) | 9 | 7 | 4 | 63 | 40 | |||
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 | |||
82239 | 124660 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 8ft | 5995479.96756 | 2115219.29012 | 37.7877287300454 | -122.45945723391 | (37.7877287300454, -122.45945723391) | 11 | 6 | 1 | 54 | 11 | |||
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 | |||
119440 | 131813 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 145 Capra Way | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6001082.26232 | 2120520.90623 | 37.802606103861 | -122.440454793478 | (37.802606103861, -122.440454793478) | 13 | 9 | 1 | 57 | 17 | |||
148967 | 177874 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1222 Naples St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 6001049.49395 | 2087346.60283 | 37.7115156712695 | -122.438190296958 | (37.7115156712695, -122.438190296958) | 9 | 7 | 6 | 28861 | 5 | |||
181667 | 131846 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3265 Baker St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 5999287.02532 | 2120101.46569 | 37.8013520487037 | -122.446636994919 | (37.8013520487037, -122.446636994919) | 13 | 9 | 1 | 57 | 17 | |||
185004 | 131814 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 145 Capra Way | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6001091.88484 | 2120522.16453 | 37.80261010672 | -122.440421585107 | (37.80261010672, -122.440421585107) | 13 | 9 | 1 | 57 | 17 | |||
189213 | 210872 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 371 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5997627.30354 | 2093781.83319 | 37.7289900868006 | -122.450481853864 | (37.7289900868006, -122.450481853864) | 9 | 7 | 4 | 28861 | 40 | |||
191402 | 210873 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 62 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5998923.83927 | 2093227.89544 | 37.7275432251404 | -122.445959824297 | (37.7275432251404, -122.445959824297) | 9 | 7 | 4 | 28861 | 40 | |||
11542 | 194238 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6 Hillview Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6016710.45664 | 2095786.72783 | 37.7355688829898 | -122.384648921526 | (37.7355688829898, -122.384648921526) | 10 | 3 | 8 | 58 | 1 | |||
21749 | 120838 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 55 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 7ft | 5989873.67504 | 2114823.8325 | 37.7863189706432 | -122.478824785693 | (37.7863189706432, -122.478824785693) | 11 | 6 | 1 | 55 | 33 | |||
44605 | 246528 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 1 | : | Tree | Private 2 | 13 | Width 7ft | 6005204.62433 | 2109172.65839 | 37.7716805104709 | -122.425381286315 | (37.7716805104709, -122.425381286315) | 7 | 9 | 5 | 28852 | 10 | |||
77732 | 194235 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 19 Hillview Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6016602.67648 | 2095728.95529 | 37.7354042899791 | -122.385017538329 | (37.7354042899791, -122.385017538329) | 10 | 3 | 8 | 58 | 1 | |||
91176 | 120839 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 55 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 7ft | 5989874.45589 | 2114802.58309 | 37.7862606710831 | -122.478820529469 | (37.7862606710831, -122.478820529469) | 11 | 6 | 1 | 55 | 33 | |||
91693 | 246530 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 3 | : | Tree | Private 2 | 13 | Width 7ft | 6005220.62037 | 2109069.23024 | 37.7713974254703 | -122.425318593679 | (37.7713974254703, -122.425318593679) | 7 | 9 | 5 | 28852 | 10 | |||
104105 | 246518 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 155 Laguna St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 7ft | 6005162.55314 | 2109484.17323 | 37.7725334778669 | -122.425548987397 | (37.7725334778669, -122.425548987397) | 7 | 9 | 5 | 28852 | 10 | |||
104805 | 194236 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 17 Hillview Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6016647.59382 | 2095743.55851 | 37.7354468719595 | -122.384863257848 | (37.7354468719595, -122.384863257848) | 10 | 3 | 8 | 58 | 1 | |||
118962 | 232438 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 Florida St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 7ft | 6009220.36399 | 2105639.7439 | 37.7622060061254 | -122.411240931034 | (37.7622060061254, -122.411240931034) | 8 | 4 | 7 | 28859 | 19 | |||
126515 | 120840 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 55 19th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 7ft | 5989874.85476 | 2114772.97102 | 37.7861793878304 | -122.478816982934 | (37.7861793878304, -122.478816982934) | 11 | 6 | 1 | 55 | 33 | |||
133499 | 131862 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3640 Lyon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 5998877.1278 | 2121309.5311 | 37.8046456466411 | -122.448142451907 | (37.8046456466411, -122.448142451907) | 13 | 9 | 1 | 57 | 17 | |||
137967 | 232437 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 Florida St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 7ft | 6009218.18097 | 2105675.07688 | 37.7623028999848 | -122.411250977369 | (37.7623028999848, -122.411250977369) | 8 | 4 | 7 | 28859 | 19 | |||
143183 | 233118 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1803 Castro St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 7ft | 6002653.14547 | 2100266.75628 | 37.7470825632048 | -122.433570422942 | (37.7470825632048, -122.433570422942) | 2 | 7 | 5 | 63 | 22 | |||
143445 | 131874 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 295 Marina Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6002038.91196 | 2121849.60525 | 37.8063087844798 | -122.437239504003 | (37.8063087844798, -122.437239504003) | 13 | 9 | 1 | 57 | 17 | |||
170810 | 194234 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 21 Hillview Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6016584.85791 | 2095721.56039 | 37.7353829994301 | -122.385078629298 | (37.7353829994301, -122.385078629298) | 10 | 3 | 8 | 58 | 1 | |||
173670 | 232439 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 Florida St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 7ft | 6009231.67857 | 2105511.08607 | 37.761853375653 | -122.411192709398 | (37.761853375653, -122.411192709398) | 8 | 4 | 7 | 28859 | 19 | |||
5721 | 246522 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 155 Laguna St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 6005173.73012 | 2109399.79549 | 37.7723024285329 | -122.425504318986 | (37.7723024285329, -122.425504318986) | 7 | 9 | 5 | 28852 | 10 | |||
22944 | 210863 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 412 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5999336.30619 | 2094992.2158 | 37.7324111807223 | -122.444660686135 | (37.7324111807223, -122.444660686135) | 9 | 7 | 4 | 59 | 40 | |||
26421 | 246525 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 155 Laguna St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6005186.06731 | 2109316.74693 | 37.7720750943316 | -122.425455732201 | (37.7720750943316, -122.425455732201) | 7 | 9 | 5 | 28852 | 10 | |||
29626 | 210852 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 330 Baden St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6000786.85539 | 2095109.56492 | 37.732816061802 | -122.439654219669 | (37.732816061802, -122.439654219669) | 9 | 7 | 5 | 63 | 40 | |||
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 | |||
40549 | 131815 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 149 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 9 | Width 6ft | Permit Number 49255 | 6001582.80517 | 2120278.3225 | 37.8019685213769 | -122.438705274832 | (37.8019685213769, -122.438705274832) | 13 | 9 | 1 | 57 | 17 | |
50179 | 232444 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 146 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6005545.81418 | 2100237.45098 | 37.7471657990643 | -122.423565720582 | (37.7471657990643, -122.423565720582) | 2 | 7 | 5 | 28859 | 22 | |||
60885 | 210667 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 461 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993772.15723 | 2101783.21661 | 37.7507384818159 | -122.464389983509 | (37.7507384818159, -122.464389983509) | 1 | 8 | 4 | 29491 | 40 | |||
63596 | 232474 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2759 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6009584.16394 | 2103339.51156 | 37.7559104846995 | -122.409820303469 | (37.7559104846995, -122.409820303469) | 2 | 4 | 7 | 28859 | 19 | |||
66379 | 117843 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 620x 39th Ave | 4 | Median : Cutout | Tree | DPW 1 | 9 | Width 6ft | 5983810.12526 | 2111540.49138 | 37.7769499228703 | -122.499560036853 | (37.7769499228703, -122.499560036853) | 11 | 6 | 2 | 55 | 26 | |||
76952 | 194195 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 9 Pomona St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6014203.67115 | 2094680.19203 | 37.7323916096872 | -122.393238495663 | (37.7323916096872, -122.393238495663) | 10 | 3 | 8 | 58 | 1 | |||
79438 | 194241 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4 Mabrey Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6016531.12407 | 2095935.7497 | 37.7359681478157 | -122.385279329202 | (37.7359681478157, -122.385279329202) | 10 | 3 | 8 | 58 | 1 | |||
85332 | 117845 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 620x 39th Ave | 2 | Median : Cutout | Tree | DPW 1 | 23 | Width 6ft | 5983812.70856 | 2111515.33399 | 37.7768809995382 | -122.499549240882 | (37.7768809995382, -122.499549240882) | 11 | 6 | 2 | 55 | 26 | |||
97218 | 120356 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2350 Lake St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 5988131.96893 | 2114686.12809 | 37.7858395857997 | -122.48484046088 | (37.7858395857997, -122.48484046088) | 11 | 6 | 1 | 55 | 33 | |||
101263 | 232862 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1129 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6010301.9887 | 2102418.59091 | 37.7534220434926 | -122.407272901822 | (37.7534220434926, -122.407272901822) | 10 | 4 | 7 | 28859 | 19 | |||
102289 | 117836 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660x 39th Ave | 3 | Median : Cutout | Tree | DPW 1 | 11 | Width 6ft | 5983819.78589 | 2111279.0355 | 37.7762326075425 | -122.499507291354 | (37.7762326075425, -122.499507291354) | 11 | 6 | 2 | 55 | 26 | |||
109076 | 210866 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 110 Monterey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 6001326.24557 | 2094696.71947 | 37.7317131692257 | -122.437759857137 | (37.7317131692257, -122.437759857137) | 9 | 7 | 4 | 63 | 40 | |||
112084 | 233069 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 774 Duncan St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 6ft | 6001540.64018 | 2099730.3572 | 37.7455465535424 | -122.437378962779 | (37.7455465535424, -122.437378962779) | 2 | 7 | 5 | 63 | 22 | |||
133925 | 194162 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1905 23rd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6012692.73182 | 2102821.35031 | 37.7546614459721 | -122.399033419356 | (37.7546614459721, -122.399033419356) | 10 | 3 | 8 | 28856 | 29 | |||
134006 | 117847 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 640x 39th Ave | 4 | Median : Cutout | Tree | DPW 1 | 12 | Width 6ft | 5983816.43037 | 2111419.86537 | 37.7766190887274 | -122.499529309057 | (37.7766190887274, -122.499529309057) | 11 | 6 | 2 | 55 | 26 | |||
134150 | 117924 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 611 41st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 6ft | 5983159.66185 | 2111615.25799 | 37.7771170231905 | -122.501815685868 | (37.7771170231905, -122.501815685868) | 11 | 6 | 2 | 55 | 26 | |||
137761 | 177974 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6004875.55792 | 2093420.90474 | 37.7284112462806 | -122.425398400422 | (37.7284112462806, -122.425398400422) | 9 | 7 | 6 | 28861 | 5 | |||
140357 | 131816 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 149 Alhambra St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/27/2007 12:00:00 AM | 8 | Width 6ft | Permit Number 49255 | 6001591.27048 | 2120267.97849 | 37.8019406010393 | -122.438675239298 | (37.8019406010393, -122.438675239298) | 13 | 9 | 1 | 57 | 17 | |
144091 | 210665 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 461 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993745.33672 | 2101802.5185 | 37.7507899338305 | -122.46448413175 | (37.7507899338305, -122.46448413175) | 1 | 8 | 4 | 29491 | 40 | |||
145932 | 210660 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 181 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5994349.85178 | 2096588.91654 | 37.7365095190008 | -122.462015646523 | (37.7365095190008, -122.462015646523) | 9 | 8 | 4 | 59 | 40 | |||
149489 | 210862 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 412 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5999352.48487 | 2094990.83835 | 37.7324083217769 | -122.444604653878 | (37.7324083217769, -122.444604653878) | 9 | 7 | 4 | 59 | 40 | |||
151866 | 194226 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2 Jakey Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6016841.98922 | 2095417.85433 | 37.7345633033443 | -122.384168478511 | (37.7345633033443, -122.384168478511) | 10 | 3 | 8 | 58 | 1 | |||
160574 | 232882 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 877 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6010202.29933 | 2104146.86733 | 37.7581619248595 | -122.407739504273 | (37.7581619248595, -122.407739504273) | 10 | 4 | 7 | 28859 | 19 | |||
163245 | 210867 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 774 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 5996972.31897 | 2095027.19016 | 37.7323720296365 | -122.452836023577 | (37.7323720296365, -122.452836023577) | 9 | 7 | 4 | 59 | 40 | |||
164436 | 117838 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660x 39th Ave | 1 | Median : Cutout | Tree | DPW 1 | 8 | Width 6ft | 5983820.62988 | 2111252.49481 | 37.7761597840052 | -122.499502409931 | (37.7761597840052, -122.499502409931) | 11 | 6 | 2 | 55 | 26 | |||
168638 | 194227 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 8 Jakey Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6016817.60054 | 2095485.74545 | 37.7347483703482 | -122.384257525772 | (37.7347483703482, -122.384257525772) | 10 | 3 | 8 | 58 | 1 | |||
174302 | 246520 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 155 Laguna St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005167.3236 | 2109440.76034 | 37.7724145461197 | -122.425529395676 | (37.7724145461197, -122.425529395676) | 7 | 9 | 5 | 28852 | 10 | |||
187969 | 210666 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 461 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993758.36783 | 2101793.87252 | 37.7507669453544 | -122.464438441679 | (37.7507669453544, -122.464438441679) | 1 | 8 | 4 | 29491 | 40 | |||
6173 | 210586 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1677 16th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 5ft | 5991138.28819 | 2103959.43747 | 37.7565616379133 | -122.47365677234 | (37.7565616379133, -122.47365677234) | 1 | 8 | 4 | 56 | 12 | |||
7522 | 131891 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3211 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 5999369.54226 | 2115325.66446 | 37.7882436798582 | -122.446007752769 | (37.7882436798582, -122.446007752769) | 13 | 6 | 1 | 29490 | 31 | |||
20728 | 210775 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1280 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 5993026.62735 | 2106720.09282 | 37.7642508567239 | -122.467327005649 | (37.7642508567239, -122.467327005649) | 11 | 8 | 11 | 56 | 12 | |||
21293 | 233126 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1411 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6003310.36641 | 2099907.98672 | 37.7461347335404 | -122.431272203649 | (37.7461347335404, -122.431272203649) | 2 | 7 | 5 | 63 | 22 | |||
21666 | 210591 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1243 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 5991730.66093 | 2106951.40503 | 37.7648110785786 | -122.471826201445 | (37.7648110785786, -122.471826201445) | 11 | 8 | 11 | 56 | 12 | |||
23815 | 232967 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1350 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 5998278.03823 | 2105754.12772 | 37.7619003184538 | -122.449094356436 | (37.7619003184538, -122.449094356436) | 15 | 5 | 11 | 29492 | 9 | |||
24204 | 123292 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 534 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5994090.59421 | 2111856.90796 | 37.7784165550324 | -122.464019989261 | (37.7784165550324, -122.464019989261) | 11 | 6 | 2 | 54 | 11 | |||
26288 | 124398 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3920 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5995972.08379 | 2115555.35439 | 37.7886797552779 | -122.457778943801 | (37.7886797552779, -122.457778943801) | 11 | 6 | 1 | 54 | 31 | |||
26504 | 233699 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1111 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6004130.42864 | 2102416.0616 | 37.7530677627665 | -122.428615284394 | (37.7530677627665, -122.428615284394) | 2 | 4 | 5 | 28862 | 22 | |||
27819 | 131863 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3640 Lyon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5998876.58216 | 2121318.22377 | 37.8046694831589 | -122.448144966435 | (37.8046694831589, -122.448144966435) | 13 | 9 | 1 | 57 | 17 | |||
30775 | 131798 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3550 Baker St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5999217.12066 | 2121060.49219 | 37.8039812832582 | -122.446947946285 | (37.8039812832582, -122.446947946285) | 13 | 9 | 1 | 57 | 17 | |||
31620 | 131917 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1870 Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6005825.85678 | 2116265.47758 | 37.7911907321235 | -122.423736805829 | (37.7911907321235, -122.423736805829) | 13 | 9 | 1 | 28858 | 27 | |||
39036 | 194228 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 9 Hawkins Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6016962.87933 | 2095412.73629 | 37.7345559334103 | -122.38375016066 | (37.7345559334103, -122.38375016066) | 10 | 3 | 8 | 58 | 1 | |||
43564 | 131908 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2300 Lyon St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5999329.15646 | 2116759.94991 | 37.7921795438926 | -122.446250695616 | (37.7921795438926, -122.446250695616) | 13 | 6 | 1 | 29490 | 27 | |||
44750 | 210585 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1677 16th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 5ft | 5991143.28102 | 2103974.04499 | 37.7566020354667 | -122.473640571055 | (37.7566020354667, -122.473640571055) | 1 | 8 | 4 | 56 | 12 | |||
45231 | 131964 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2616 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6006972.36413 | 2121248.27564 | 37.8049368965806 | -122.420123694077 | (37.8049368965806, -122.420123694077) | 5 | 1 | 1 | 28858 | 32 | |||
51420 | 131854 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2561 Chestnut St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5999582.77366 | 2119421.91936 | 37.7995030857465 | -122.445564684683 | (37.7995030857465, -122.445564684683) | 13 | 9 | 1 | 57 | 17 | |||
52467 | 194231 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 62 Hawkins Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6016795.73668 | 2095634.4055 | 37.7351553522317 | -122.384343467669 | (37.7351553522317, -122.384343467669) | 10 | 3 | 8 | 58 | 1 | |||
55329 | 232885 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 800 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6010146.27619 | 2104492.59406 | 37.7591080763824 | -122.407957637561 | (37.7591080763824, -122.407957637561) | 2 | 4 | 7 | 28859 | 19 | |||
55919 | 178013 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 88 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6007561.5406 | 2093436.50677 | 37.7286054755646 | -122.416113907532 | (37.7286054755646, -122.416113907532) | 9 | 3 | 7 | 309 | 5 | |||
55953 | 232884 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 800 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6010144.19408 | 2104517.0522 | 37.7591751163599 | -122.407966563306 | (37.7591751163599, -122.407966563306) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
56708 | 194154 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 470 Carolina St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 5ft | 6012311.64472 | 2105752.08257 | 37.7626873475533 | -122.400557189269 | (37.7626873475533, -122.400557189269) | 14 | 3 | 8 | 28856 | 29 | |||
81201 | 131890 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3225 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 5999224.60117 | 2115306.72197 | 37.7881833911006 | -122.446507859461 | (37.7881833911006, -122.446507859461) | 13 | 6 | 1 | 29490 | 31 | |||
84535 | 210742 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1231 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 5ft | 5995454.06251 | 2107177.64382 | 37.7656470074244 | -122.458964384416 | (37.7656470074244, -122.458964384416) | 15 | 5 | 11 | 56 | 12 | |||
86152 | 131965 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2616 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6006966.56349 | 2121270.91846 | 37.8049987411622 | -122.420145375824 | (37.8049987411622, -122.420145375824) | 5 | 1 | 1 | 28858 | 32 | |||
87149 | 131787 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2674 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6000147.00101 | 2118531.04457 | 37.7970891758715 | -122.443548231968 | (37.7970891758715, -122.443548231968) | 13 | 9 | 1 | 57 | 17 | |||
87840 | 233709 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 82 Hancock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6003745.39338 | 2105110.58954 | 37.7604444995348 | -122.430139020996 | (37.7604444995348, -122.430139020996) | 2 | 4 | 5 | 28862 | 3 | |||
88653 | 233702 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 64 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6004074.63863 | 2102693.13969 | 37.7538253966311 | -122.428827968645 | (37.7538253966311, -122.428827968645) | 2 | 4 | 5 | 28862 | 22 | |||
92038 | 124397 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3920 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 5995992.84838 | 2115560.19598 | 37.7886942418507 | -122.45770745229 | (37.7886942418507, -122.45770745229) | 11 | 6 | 1 | 54 | 31 | |||
95256 | 124668 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Arguello Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 5995484.34747 | 2115002.47602 | 37.7871336688932 | -122.4594263723 | (37.7871336688932, -122.4594263723) | 11 | 6 | 1 | 54 | 11 |
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) );