trees
3,709 rows where qSpecies_id = 9 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6339 | 202874 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 560 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011757.6465 | 2105763.90852 | 37.7626889070017 | -122.402474114009 | (37.7626889070017, -122.402474114009) | 8 | 3 | 8 | 28856 | 29 | |||
| 6369 | 55285 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1255 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11211 | 5988297.4779 | 2106775.5193 | 37.7641288996273 | -122.483687653384 | (37.7641288996273, -122.483687653384) | 1 | 8 | 3 | 56 | 35 | ||
| 6418 | 194172 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 664 Wisconsin St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6012676.7573 | 2104370.99604 | 37.7589155441312 | -122.399197435936 | (37.7589155441312, -122.399197435936) | 10 | 3 | 8 | 28856 | 29 | |||
| 6532 | 119947 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 326 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | 5986858.05985 | 2113733.39411 | 37.783149373707 | -122.489177700438 | (37.783149373707, -122.489177700438) | 11 | 6 | 2 | 55 | 26 | |||
| 6614 | 233670 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 803 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002469.64412 | 2103508.89631 | 37.7559742970036 | -122.434436723671 | (37.7559742970036, -122.434436723671) | 2 | 4 | 5 | 28862 | 22 | |||
| 6647 | 233181 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1088 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998975.05646 | 2106207.82472 | 37.7631858975236 | -122.446716299819 | (37.7631858975236, -122.446716299819) | 15 | 5 | 5 | 29492 | 9 | |||
| 6676 | 70370 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1462 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5983119.2114 | 2105188.9573 | 37.7594698688276 | -122.501480109549 | (37.7594698688276, -122.501480109549) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | ||||
| 6963 | 177993 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 219 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004143.56512 | 2092257.28503 | 37.7251748209582 | -122.427846056457 | (37.7251748209582, -122.427846056457) | 9 | 7 | 6 | 28861 | 5 | |||
| 6968 | 106969 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 504 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 772815 | 6007433 | 2096444 | 37.7368561680545 | -122.416771259928 | (37.7368561680545, -122.416771259928) | 2 | 7 | 7 | 28859 | 2 | |
| 7046 | 69901 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 607 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6002511.32191 | 2089559.78285 | 37.7176756091205 | -122.433295884208 | (37.7176756091205, -122.433295884208) | 9 | 7 | 6 | 28861 | 5 | |||
| 7048 | 70747 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 775 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988472.81051 | 2110739.80778 | 37.7750239462768 | -122.483371863607 | (37.7750239462768, -122.483371863607) | 11 | 6 | 2 | 55 | 26 | |||
| 7121 | 13051 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 548 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:01:00 PM | 3 | 3x3 | 6009711.5863 | 2120552.0553 | 37.803179205163 | -122.410595078527 | (37.803179205163, -122.410595078527) | 3 | 1 | 10 | 308 | 23 | ||
| 7198 | 233017 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 89 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785451 | 6007345.5921 | 2098843.81852 | 37.7434406209891 | -122.417243474931 | (37.7434406209891, -122.417243474931) | 2 | 7 | 7 | 28859 | 2 | |
| 7300 | 183627 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1442 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981873.5609 | 2105253.9792 | 37.759575163504 | -122.505792929352 | (37.759575163504, -122.505792929352) | 1 | 8 | 3 | 56 | 35 | |||
| 7307 | 17780 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1791 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005376.6767315 | 2115458.3552628 | 37.7889492101001 | -122.425233498798 | (37.7889492101001, -122.425233498798) | 13 | 9 | 1 | 28858 | 41 | |||
| 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 | |||
| 7416 | 52562 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1267 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 3 | Permit Number 48659 | 5983648.1273 | 2106539.2749 | 37.7632085093228 | -122.49975069135 | (37.7632085093228, -122.49975069135) | 1 | 8 | 3 | 56 | 35 | |
| 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 | ||
| 7468 | 244539 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 410 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998914.5258 | 2109210.0073 | 37.7714256747979 | -122.447141725905 | (37.7714256747979, -122.447141725905) | 15 | 5 | 11 | 29492 | 9 | |||
| 7516 | 177998 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 182 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003203.98579 | 2092372.59593 | 37.7254382413572 | -122.431102310926 | (37.7254382413572, -122.431102310926) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 7572 | 210820 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1570 07th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994025.69959 | 2104801.19481 | 37.7590396865612 | -122.463732240966 | (37.7590396865612, -122.463732240966) | 1 | 5 | 4 | 56 | 12 | |||
| 7639 | 178021 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 501 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6009115.97426 | 2093800.21325 | 37.7296914141147 | -122.410765795799 | (37.7296914141147, -122.410765795799) | 9 | 3 | 7 | 309 | 28 | |||
| 7716 | 47426 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 573 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45337 | 5983462.70057 | 2111933.41652 | 37.7780083900123 | -122.50079093001 | (37.7780083900123, -122.50079093001) | 11 | 6 | 2 | 55 | 26 | |
| 7778 | 138593 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2816 PINE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000380.1632 | 2114818.3649 | 37.7869084247529 | -122.44247474757 | (37.7869084247529, -122.44247474757) | 13 | 6 | 1 | 29490 | 27 | |||
| 8079 | 42144 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 471 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 10 | Permit Number 42439 | 5990590.8617 | 2112190.82997 | 37.7791310957428 | -122.476151146082 | (37.7791310957428, -122.476151146082) | 11 | 6 | 2 | 55 | 26 | |
| 8377 | 42837 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1258 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2000 12:00:00 AM | 14 | Permit Number 42769 | 6005846.59276 | 2120362.48981 | 37.8024412617221 | -122.423956527271 | (37.8024412617221, -122.423956527271) | 5 | 9 | 1 | 28858 | 32 | ||
| 8413 | 120008 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 700 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5986957.64552 | 2111044.59279 | 37.7757725016367 | -122.488635485438 | (37.7757725016367, -122.488635485438) | 11 | 6 | 2 | 55 | 26 | |||
| 8449 | 131913 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2108 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6004558.4355 | 2116754.37575 | 37.7924614957554 | -122.428156903513 | (37.7924614957554, -122.428156903513) | 13 | 9 | 1 | 28858 | 27 | |||
| 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 | ||||
| 8979 | 210840 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 32 Malta Dr | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5999647.66435 | 2095993.4021 | 37.735177965674 | -122.443656149716 | (37.735177965674, -122.443656149716) | 9 | 7 | 4 | 63 | 40 | |||
| 9078 | 233225 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 317 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007069.05319 | 2097329.92608 | 37.7392682478392 | -122.41809237556 | (37.7392682478392, -122.41809237556) | 2 | 7 | 7 | 28859 | 2 | |||
| 9131 | 75410 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5984433.26554 | 2112138.70931 | 37.7786289992279 | -122.497448611431 | (37.7786289992279, -122.497448611431) | 11 | 6 | 2 | 55 | 26 | |||
| 9148 | 76641 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 148X Paris St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002952.72216 | 2092480.76402 | 37.7257210052939 | -122.43197862653 | (37.7257210052939, -122.43197862653) | 9 | 7 | 6 | 28861 | 5 | ||
| 9149 | 233773 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 40 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001427.02083 | 2107882.34187 | 37.7679234703253 | -122.438355765017 | (37.7679234703253, -122.438355765017) | 15 | 5 | 5 | 29492 | 3 | |||
| 9185 | 177862 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 941 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000858.94149 | 2091517.81461 | 37.7229580424721 | -122.439147663029 | (37.7229580424721, -122.439147663029) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | ||||
| 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 | |||||
| 9397 | 194190 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1120 19th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014220.74696 | 2105285.57644 | 37.7615127088737 | -122.393921578412 | (37.7615127088737, -122.393921578412) | 10 | 3 | 8 | 28856 | 29 | |||
| 9405 | 177889 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 151 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010419.89966 | 2087893.48861 | 37.7135457936846 | -122.405842049878 | (37.7135457936846, -122.405842049878) | 9 | 7 | 8 | 309 | 39 | |||
| 9488 | 233080 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4379 Cesar Chavez St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001430.46687 | 2100267.77544 | 37.7470159126695 | -122.437798408372 | (37.7470159126695, -122.437798408372) | 2 | 4 | 5 | 63 | 22 | |||
| 9594 | 138528 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2255 SUTTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001797.268 | 2114262.3261 | 37.7854623568286 | -122.43753206476 | (37.7854623568286, -122.43753206476) | 13 | 6 | 11 | 29490 | 13 | |||
| 9669 | 71248 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1853 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009517.1243 | 2120069.0751 | 37.8018421572412 | -122.411233884286 | (37.8018421572412, -122.411233884286) | 3 | 1 | 10 | 308 | 23 | |||
| 9691 | 210624 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5993034.36809 | 2106545.7737 | 37.763772669194 | -122.467287556882 | (37.763772669194, -122.467287556882) | 1 | 8 | 11 | 56 | 12 | |||
| 9713 | 71215 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2143 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5988194.3764 | 2100717.2109 | 37.7474884169564 | -122.483600053104 | (37.7474884169564, -122.483600053104) | 1 | 8 | 3 | 29491 | 35 | |||
| 9726 | 87886 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3750 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50857 | 6002562.15931 | 2121499.01412 | 37.8053758844436 | -122.4354036226 | (37.8053758844436, -122.4354036226) | 13 | 9 | 1 | 57 | 17 | |
| 9805 | 246529 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Laguna St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6005210.23202 | 2109136.89842 | 37.77158263905 | -122.425359343752 | (37.77158263905, -122.425359343752) | 7 | 9 | 5 | 28852 | 10 | |||
| 9934 | 233207 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007340 | 2097733 | 37.7403902459184 | -122.417184114538 | (37.7403902459184, -122.417184114538) | 2 | 7 | 7 | 28859 | 2 | |||
| 10208 | 250096 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1701 Pine St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6005700.60971 | 2115508.13842 | 37.789104197049 | -122.42411627476 | (37.789104197049, -122.42411627476) | 13 | 9 | 1 | 28858 | 41 | |||
| 10318 | 78551 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2255 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982019.5732 | 2099750.385 | 37.7444724345971 | -122.504880128796 | (37.7444724345971, -122.504880128796) | 1 | 8 | 3 | 29491 | 35 | |||
| 10328 | 233802 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 250 Randall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003925.67071 | 2097778.5347 | 37.7403225995025 | -122.428992763101 | (37.7403225995025, -122.428992763101) | 2 | 7 | 5 | 63 | 7 | |||
| 10431 | 48599 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1338(Revised) Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50644 | 6006556.20417 | 2119076.48456 | 37.7989502536048 | -122.42140953573 | (37.7989502536048, -122.42140953573) | 13 | 9 | 1 | 28858 | 32 | |
| 10555 | 18999 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3039 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6000252.38525 | 2115449.79519 | 37.7886348840283 | -122.442962190565 | (37.7886348840283, -122.442962190565) | 13 | 6 | 1 | 29490 | 27 | |||
| 10709 | 210631 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1446 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5993378.13325 | 2105628.69584 | 37.7612744523625 | -122.466031944136 | (37.7612744523625, -122.466031944136) | 1 | 8 | 11 | 56 | 12 | |||
| 10896 | 13070 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 630 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/05/2019 12:00:00 AM | 22 | 3x3 | 6009332.6794 | 2120506.3975 | 37.8030325899081 | -122.4119030734 | (37.8030325899081, -122.4119030734) | 3 | 1 | 10 | 308 | 23 | ||
| 10904 | 131990 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 12:00:00 AM | 3 | Width 3ft | 6006996.42169 | 2120694.04403 | 37.8034164730582 | -122.420001084983 | (37.8034164730582, -122.420001084983) | 5 | 1 | 1 | 28858 | 32 | ||
| 10918 | 233197 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 799 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007609.55119 | 2095754.81208 | 37.7349737377405 | -122.416112048657 | (37.7349737377405, -122.416112048657) | 2 | 7 | 7 | 28859 | 2 | |||
| 10929 | 233639 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 738x San Jose Ave | 1 | Median : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6005705.79778 | 2098817.87018 | 37.7432769821506 | -122.422911632871 | (37.7432769821506, -122.422911632871) | 2 | 7 | 7 | 28859 | 2 | |||
| 10933 | 138331 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002699 | 2115111 | 37.7878438257201 | -122.43447304438 | (37.7878438257201, -122.43447304438) | 13 | 9 | 11 | 29490 | 27 | |||
| 10975 | 154534 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1391 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 2ft | 5993623.67748 | 2106028.43629 | 37.7623861978859 | -122.465211753439 | (37.7623861978859, -122.465211753439) | 1 | 8 | 11 | 56 | 12 | |||
| 11031 | 194139 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 770 Illinois St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6015990.60538 | 2105494.8516 | 37.7621855348578 | -122.387814914632 | (37.7621855348578, -122.387814914632) | 10 | 3 | 8 | 28856 | 29 | ||||
| 11049 | 74796 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2338 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983322.3378 | 2099244.9576 | 37.7431612263111 | -122.500338147126 | (37.7431612263111, -122.500338147126) | 1 | 8 | 3 | 29491 | 35 | |||
| 11186 | 233023 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 377 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007268.08655 | 2096284.2929 | 37.7364083704527 | -122.417330125494 | (37.7364083704527, -122.417330125494) | 2 | 7 | 7 | 28859 | 2 | |||
| 11353 | 210831 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 El Verano Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994495.15253 | 2094669.90963 | 37.7312487620154 | -122.461374210478 | (37.7312487620154, -122.461374210478) | 9 | 8 | 4 | 59 | 40 | |||
| 11455 | 71633 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 666 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983841.90754 | 2111286.39703 | 37.7762541180901 | -122.499431311865 | (37.7762541180901, -122.499431311865) | 11 | 6 | 2 | 55 | 26 | |||
| 11480 | 233768 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 55 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003179.19885 | 2107982.61518 | 37.7682983023649 | -122.43230234649 | (37.7682983023649, -122.43230234649) | 15 | 5 | 5 | 28862 | 3 | |||
| 11500 | 80930 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 214 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6000799.22346 | 2087352.62937 | 37.7115179816306 | -122.439055727159 | (37.7115179816306, -122.439055727159) | 9 | 7 | 6 | 28861 | 5 | |||
| 11523 | 80597 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 443 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6014099.89803 | 2105040.34202 | 37.7608326316413 | -122.394322377476 | (37.7608326316413, -122.394322377476) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 11665 | 233743 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 286 Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003735.38571 | 2104523.16208 | 37.7588309970763 | -122.430131725694 | (37.7588309970763, -122.430131725694) | 2 | 4 | 5 | 28862 | 3 | |||
| 11711 | 38775 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | 8 | Permit Number 40638 | 6014484.21875 | 2111755.81993 | 37.7792932023544 | -122.393463157999 | (37.7792932023544, -122.393463157999) | 6 | 2 | 9 | 28856 | 34 | |
| 11761 | 10268 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215X Haight St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 6005053.18335 | 2109512.97249 | 37.7726063733294 | -122.425929359246 | (37.7726063733294, -122.425929359246) | 7 | 9 | 5 | 28852 | 10 | ||||
| 11782 | 75252 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5984435.27406 | 2112051.02131 | 37.7783883510577 | -122.497435187925 | (37.7783883510577, -122.497435187925) | 11 | 6 | 2 | 55 | 26 | |||
| 11877 | 210668 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 220 Ulloa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996107.59871 | 2098932.75932 | 37.7430461792465 | -122.456107811121 | (37.7430461792465, -122.456107811121) | 1 | 8 | 4 | 59 | 40 | |||
| 11914 | 262434 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 634 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 2ft | 6002626 | 2089963 | 37.7187892592726 | -122.43292828484 | (37.7187892592726, -122.43292828484) | 9 | 7 | 6 | 28861 | 5 | ||
| 11947 | 114496 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 506 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6013514.3964 | 2111397.60401 | 37.778255690483 | -122.396793080454 | (37.778255690483, -122.396793080454) | 6 | 2 | 9 | 28856 | 34 | |||
| 11999 | 78469 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 620 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6007750.85494 | 2094230.07543 | 37.730795086422 | -122.415515595769 | (37.730795086422, -122.415515595769) | 9 | 3 | 7 | 309 | 28 | |||
| 12136 | 137985 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2281 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003041.7191 | 2115135.3028 | 37.7879300034078 | -122.433289038266 | (37.7879300034078, -122.433289038266) | 13 | 9 | 11 | 29490 | 27 | |||
| 12171 | 84266 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 705 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988141.50064 | 2111140.28908 | 37.7761042683076 | -122.484547303766 | (37.7761042683076, -122.484547303766) | 11 | 6 | 2 | 55 | 26 | |||
| 12403 | 17740 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1347 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 12/01/1982 12:00:00 AM | 6 | 3X3 | 6002203.7996 | 2113272.0173 | 37.7827663252153 | -122.436054698673 | (37.7827663252153, -122.436054698673) | 15 | 5 | 11 | 29490 | 41 | ||
| 12429 | 71684 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 163 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994555.12862 | 2086427.38157 | 37.7086202032335 | -122.460569802865 | (37.7086202032335, -122.460569802865) | 9 | 8 | 6 | 28861 | 25 | |||
| 12433 | 210785 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 228 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5993497.42043 | 2103949.45109 | 37.7566705638043 | -122.465497389788 | (37.7566705638043, -122.465497389788) | 1 | 8 | 4 | 56 | 12 | |||
| 12517 | 83658 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 735 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001863.16562 | 2089646.83142 | 37.717877833364 | -122.435542488698 | (37.717877833364, -122.435542488698) | 9 | 7 | 6 | 28861 | 5 | |||
| 12544 | 233012 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 323 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006460.26092 | 2097992.5742 | 37.7410534470593 | -122.420244329108 | (37.7410534470593, -122.420244329108) | 2 | 7 | 7 | 28859 | 2 | |||
| 12572 | 1414 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 15 Arguello Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 20 | 3X5 | 5995457.5707 | 2115860.24617 | 37.7894873341044 | -122.459581162818 | (37.7894873341044, -122.459581162818) | 11 | 6 | 1 | 54 | 11 | |||
| 12579 | 233051 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3165 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007206.48709 | 2103796.80236 | 37.7570325643122 | -122.41807552586 | (37.7570325643122, -122.41807552586) | 2 | 4 | 7 | 28859 | 19 | |||
| 12636 | 233814 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 76 Colton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6006700.12713 | 2109639.8219 | 37.7730476095043 | -122.420241401833 | (37.7730476095043, -122.420241401833) | 8 | 2 | 9 | 28853 | 19 | |||
| 12828 | 131988 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2445 Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 12:00:00 AM | 3 | Width 3ft | 6006993.00733 | 2120736.62098 | 37.8035331861796 | -122.420015923817 | (37.8035331861796, -122.420015923817) | 5 | 1 | 1 | 28858 | 32 | ||
| 12888 | 260885 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 639 32nd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985963.68769 | 2111543.65127 | 37.7770847226637 | -122.49211054124 | (37.7770847226637, -122.49211054124) | 11 | 6 | 2 | 55 | 26 | |||
| 12917 | 233683 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 280 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003374.25108 | 2100995.16255 | 37.7491234846824 | -122.431128883194 | (37.7491234846824, -122.431128883194) | 2 | 4 | 5 | 28862 | 22 | |||
| 13048 | 131805 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2474 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999492.72938 | 2119826.91207 | 37.8006099461438 | -122.445905412604 | (37.8006099461438, -122.445905412604) | 13 | 9 | 1 | 57 | 17 | |||
| 13060 | 232933 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1270 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003841.13405 | 2100936.80962 | 37.748989706922 | -122.429510235714 | (37.748989706922, -122.429510235714) | 2 | 4 | 5 | 28862 | 22 | |||
| 13090 | 131960 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1340 Lombard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005876.90863 | 2120024.68366 | 37.8015154438506 | -122.423827585198 | (37.8015154438506, -122.423827585198) | 5 | 9 | 1 | 28858 | 32 | |||
| 13444 | 247158 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3998 17th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6002441.05995 | 2105914.96249 | 37.7625791519331 | -122.43470762288 | (37.7625791519331, -122.43470762288) | 15 | 4 | 5 | 28862 | 3 | |||
| 13554 | 137982 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2281 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002983.8805 | 2115127.6807 | 37.7879057937101 | -122.433488604212 | (37.7879057937101, -122.433488604212) | 13 | 9 | 11 | 29490 | 27 | |||
| 13589 | 74272 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6015960.78285 | 2105386.23771 | 37.7618856523157 | -122.387910481099 | (37.7618856523157, -122.387910481099) | 10 | 3 | 8 | 28856 | 29 | |||
| 13702 | 83044 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6018777.54715 | 2097643.31156 | 37.7407807960029 | -122.377630926146 | (37.7407807960029, -122.377630926146) | 10 | 3 | 8 | 58 | 1 | |||
| 13779 | 48583 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1172 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | 6 | Permit Number 45898 | 6008021.61269 | 2118241.60717 | 37.7967404007911 | -122.416279558156 | (37.7967404007911, -122.416279558156) | 5 | 1 | 10 | 28858 | 21 | |
| 13797 | 120007 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 700 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5986954.13488 | 2111117.22618 | 37.7759717275571 | -122.488652969333 | (37.7759717275571, -122.488652969333) | 11 | 6 | 2 | 55 | 26 |
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) );